Published on: Mar 3, 2016
Transcripts - Narayana_Chowdam
(Consultant – Oracle Applications/Informatica PowerCenter)
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
Domain knowledge along with Technical Skills required for the job is what makes me different.
Requirement Gathering and strong Technical/Design skills.
Good communication, interpersonal, leadership, Documentation, troubleshooting skills and
flexible and ability to work in a team environment.
Year Company Role Responsibilities
Oct 2012 – Till
Capgemini India Pvt Ltd Oracle and
Consultant for Oracle
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
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.
Certified Consultant on Fundamentals of SQL
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
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
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
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
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
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
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.
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
PROJECT DETAILS JAN 2013 – APRIL 2013
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
Date of Birth : 04th July 1990
Gender : Male
Nationality : Indian
Married Status : Single
Passport : H5337815
Place (NARAYANA CHOWDAM)