Mobile. +91-9930972279
(Consultant – Oracle Applications/Informatica Po...
 Over 2 years of programming experience as an Oracle SQL and PL/SQL Developer in Data
Migration, Analysis, ...
Project Description:
 Migration of oracle apps data from oracle11i to oracle R12.
 Validation of Data using Informatica ...
 Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression
and Lookup, Update strategy and...
of 4


Published on: Mar 3, 2016

Transcripts - Narayana_Chowdam

  • 1. Mobile. +91-9930972279 Email: NARAYANA CHOWDAM (Consultant – Oracle Applications/Informatica PowerCenter) SUMMARY A strong Techno – Functional Consultant with 3 years of experience with implementation experience and domain knowledge on Oracle SCM. Good hands on experience in Business Application Software Development with dedicated involvement in Data Migration, Analysis, Design, Development of Business Objects in Oracle HRMS and Informatica Power Center (Designer and Workflow Manager).  Good hand holding on Oracle EBS Applications R12 (SCM Modules), SQL and PL/SQL.  Good working knowledge on Informatica Designer, Workflow Manager and Repository Manager. WHY ME? Domain knowledge along with Technical Skills required for the job is what makes me different.  Work Independently.  Requirement Gathering and strong Technical/Design skills.  Good communication, interpersonal, leadership, Documentation, troubleshooting skills and flexible and ability to work in a team environment. WORKING EXPERIENCE Year Company Role Responsibilities Oct 2012 – Till Date Capgemini India Pvt Ltd Oracle and Informatica Developer. Techno-Functional Consultant for Oracle and Informatica EDUCATIONAL QUALIFICATION Degree Session University / Board Percentage B.Tech 2007-2011 Jawaharlal Nehru University, Anantapur(A.P) 68 10+2(MPC) 2005-2007 Sri Chaitanya Junior College 87 10th 2004-2005 Andhra Pradesh School Education 77 TECHNICAL SKILLS Database Languages : SQL and PL/SQL. Front End Applications : Oracle EBS Applications R12 (SCM). Data warehouse Tools ETL : Informatica (Repository Manager, Designer And Workflow Manager) Operating Systems : Windows 2007, UNIX. CERTIFICATIONS:  Certified Consultant on Fundamentals of SQL
  • 2. ORACLE SKILLS  Over 2 years of programming experience as an Oracle SQL and PL/SQL Developer in Data Migration, Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).  Involved in different phases of SDLC (Software Development Life Cycle) from requirement gathering, analysis, design and implement, development, testing, data migration and maintenance with timely delivery against deadlines.  Expertise in Client-Server application development using Oracle EBS Applications R12, 11g, PL/SQL, TOAD and SQL DEVELOPER.  Strong ETL tools experience like Data warehousing and ETL.  Create Tables, Views, Sequences, Synonyms, Constraints, Indexes and Grants.  Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.  Expertise in Error Collections and Exception handling. ETL INFORMATICA POWERCENTER SKILLS  Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.  Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.  Strong experience in Data Warehousing and ETL using Informatica Power Center 9.1.  Strong skills in Requirement and Analysis of Data and Mapping data for ETL processes in line with business process and requirement.  Hands on experience in creating mappings, workflows and sessions in various levels like sources, targets by using PowerCenter Designer and Workflow Manager.  Extensive experience in ETL design, data migration, development and maintenance using Oracle SQL, PL/SQL and Informatica Power Center 9.1.  Hands on experience in identifying the workflow and session log errors by using Workflow Monitor. PROJECT DETAILS MAY 2013 – TILL DATE Client Lend Lease Role Oracle and Informatica Developer Organization Capgemini India Pvt Ltd Duration May 2013 – Till Date Environment Oracle EBS Applications R12 (SCM Modules), SQL, PL/SQL, Informatica PowerCenter and SQL Developer
  • 3. Project Description:  Migration of oracle apps data from oracle11i to oracle R12.  Validation of Data using Informatica ETL tool for objects like PO, PO Receits, Inventory Items, Vendors, Vendor Sites etc.,  Detailed knowledge on Informatica and Meteor(Internal Tool of Capgemini used for Data migration).  Other area of expertise on Employee data, Projects & Tasks and Blanket Purchase Agreements. Oracle Roles and Responsibilities:  Preparation on Functional and Technical Design Document with client requirement.  Data Gathering from Client existing application (R11i).  Mapping Oracle R11 Data to Oracle R12 data for data compatibility.  Developed scripts to load and migrate data using ETL tools.  Prepared custom UNIX shell scripting in line with business need and requirement of customer.  Developed UNIX Shell Script solutions to process the files on daily basis like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.  Created PL/SQL stored procedures, function and packages for moving the data from staging area to data mart.  Developed and tested scripts to create new tables, views, queries for new enhancement in the application using SQL Developer.  Query indexing to enhance the overheads of SQL on database for better performance.  Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.  Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad and SQL Developer.  Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.  Testing application development and prepared test and failure cases to meet the client requirement.  Assisted junior team members on their day to day issues. Informatica PowerCenter Roles and Responsibilities:  Data gathering and analyzed the business requirements and functional specific ations from client.  Extracted data from oracle flat files and staged into a single place and applied business logic to load them in the central oracle database.  Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) of data in the data warehouse.
  • 4.  Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator.  Developed mappings in Informatica to load the data from various sources.  Used Informatica Power Center Workflow manager to create sessions and workflows to run with the logic embedded in the mappings.  Extensively used Informatica debugger to figure out the problems in mapping.  Written documentation to describe program development, logic, coding, testing, changes and corrections. PROJECT DETAILS JAN 2013 – APRIL 2013 Client Smiths Role Oracle Techno Functional Consultant and Tester Organization Capgemini India Pvt Ltd Duration 4 months Environment Oracle EBS Applications R12(SCM Modules) and HP Quality Center Roles and Responsibilities:  Worked as a Techno-Functional Consultant.  Involved in the Configuration of application setups for oracle purchasing and Inventory Item modules.  Executing the System Test Scripts based on business process of the client for the releases in Validation and System Testing.  Testing the complete business process as per the test script.  Generated test scripts based on the business process of the client and executed accordingly. Personal Details Date of Birth : 04th July 1990 Gender : Male Nationality : Indian Married Status : Single Passport : H5337815 Date Place (NARAYANA CHOWDAM)

Related Documents