Summary of Experience

• Over 11 years of experience in the Information Technology industry and wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of the business technology solutions.
• Extensive experience in developing scalable enterprise applications to the user needs which serves for Food Beverages, Travel, Financial, Automotive Intelligence, Bank and PCB Manufacturing Industries.
• Expertise in Data warehousing experience using Informatica Power Center / Power Mart 6.2.2/6.1/5.1.1/5.0.
• Extensive knowledge of IBM's AS/400 tool using RPG, RPGLE, CL, CLLE, and DBU.
• Knowledge and Experience of front-end tools like Developer 2000, Genesis 2000 and Oracle 9i.
• Highly skilled in Planning, Designing, developing and deploying Data warehouses / Data Marts with experience of both relational multidimensional database design using Data Modeling tool ERWin Physical and Logical data models .
• Designed and Developed Data Marts by Following Star Schema and Snow Flake Schema methodology, using Data modeling tool ERWin 4.0/4.2.
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using PL/SQL.
• Involved in implementation of ISO 9001-2000 QMS.
• Good communication skills and has ability to implement projects with demanding objectives.

Technical Skills

• Operating Systems: Windows95/98/2000/XP, Windows NT
• 4.0, AS/400 Mid-Range , MAINFRAME,
• UNIX, DOS
• ETL Tools: Informatica Power Mart 5x Power
• Center v8x/v7x/v6x/v5x
• Data Modeling Tool: ERWin 3.5.2/4.0/4.2, Embarcadero 8.5
• Databases: Oracle 7.3/8i/9i/10g/11g, SQL/400,
• DB2, MS Access
• Languages: RPG, RPGLE, CL, COBOL, Java,
• PL/SQL, SDA, RLU, SEU, PDM,
• Fortran, FoxPro, TSO/ISPF, Pascal
• Front End: Developer 2000
• Software: Turnover tool, Hawkeye tool, GENESIS
• 2000, StarTeam 2005, eRoom, Caliber,
• TTU Teradata Tools Utilities

Professional Experience

Confidential

Sr. ETL Consultant

Environment -Informatica Power Center 8.1.6, Micrsoft SQL Server 2005/2008, SQL Server Management Studio, Quest Software TOAD for Data Analyst 2.7 , DB2, HP-UX B.11.11 U Shell script , AIX, Autosys, JIRA, SharePoint, Discovery, Eclipse 3.3.2 CVS , Windows XP

Responsibilities:

• Working Currently Working on analyzing various SQLs, which run on daily base as well as for month end as part of CEM and IMM application, and converting them into data flow diagram for senior leadership presentation.
• Working closely with Business Analyst to gather requirements and framing it into design specification.
• Also working on generating Pre-Close checks report via Informatica ETL tool, which is currently accomplished via running bunch of SQLs onto SQL server.
• Worked on existing production issues for sql scripts such as Silent Failure and implemented permanent fix to log syntax errors, logic errors and run-time errors into error log table.
• Created new SQL procedures to populate a new date control table that can be used to schedule CEM/IMM legacy jobs.
• Made use of JIRA application to log production bugs or enhancement project, so that it can be tracked through out different phases of SDLC.
• Working CEM/IMM re-write project to re-platform legacy CEM/IMM processes from SQL server 2008 into Informatica ETL mappings.
• For CEM/IMM re-write project constructed Source to Target matrix specs.
• Also worked on stream lining of existing sql scripts to get the best performance when incorporating the same logic using Informatica ETL tool.
• Also completed velocity documents which covers low level design for the actual mappings along with recovery process logic in case of failure, unix wrapper script, mapping parameters.
• Along with CEM/IMM re-write project, also worked on CEM/IMM month end close process.
• Developed jil scripts to install new autosys jobs and also modified existing autosys jobs.
• Designing and developing mappings using mapplets.
• Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
• Responsible for making master deployment sheet and back out checklist for scheduled production releases.

Confidential

Sr. ETL Consultant Team Lead

Environment -Informatica Power Center 8.1.1, Power Center Connect for JMS 8.1.1, Oracle 11G, SQL Plus, PL/SQL, TOAD 8.0, Teradata Tools Utilities, Embarcadero 8.5, HP-UX B.11.11 U Shell script , AIX, Control-M, Autosys, eRoom, STARTEAM 2005 v7.0.133 , SmartFTP v1.5, Caliber v6.5 SP2, Windows XP

Responsibilities:

• Working closely with business users and business analyst to gather requirements and framing it into design specification.
• Extensively making use of Informatica Power Center 8.1.1 as ETL tool to load tab delimited and XML files receiving from bottler system via ECG system.
• Working with Caliber RM tool to get the business requirement and implement once it gets approved.
• Worked extensively on Invoice and Customer subject area and acquired wide knowledge on Business.
• Responsible for ramping up new developers and enlighten with specific business processes.
• Worked extensively on different types of transformations like source qualifier, expression, lookup connected unconnected , stored procedure, joiner and union transformation.
• Designing and developing complex mappings using mapplets.
• Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
• Responsible for informatica code migration from development to Test, QA, Performance, and Data Validation environment and played the role of informatica admin.
• Created sessions and batches within a batch at required frequency.
• Frequently using import export utility to migrate session from developer's folder to subject folder.
• Extensively making use of Power connects for JMS to write Log and Exception messages to JMS CommonLE server.
• Generating Bluebook flat files for Pepsi Enterprise Data Warehouse PEDW based Functional mapping documents.
• Extensively used control-m scheduler to monitor the jobs as well as add new jobs.
• Extensively used parameter file to pass mapping and session variables.
• Involved in many technical decisions and prepared technical design document for ETL Tech Architect.
• Working as an individual team member to develop most of the process as well as working in a team to co-ordinate with other team members.
• Responsible for handling unit test, functional test, integration test and system test depending upon the environments along with testing team.
• Creating views, tables, materialized views using TOAD.
• Updated mappings and transformation with necessary comments to track of revision history and logic being used.
• Also taking care of additional requirements through various Change Requests and adding new codes and raising migration request to promote the code to other environments.
• Knowledge of Autosys scheduler for our bridging jobs.
• Working with business users to provide more technical details in business terms to better understanding of the technical processes.
• Assigned with various medium sized projects and completed them successfully with team members and successfully deployed them into Production.
• Responsible for working on new enhancements making sure no impact to existing developed system.
• Applied performance tuning to existing developed system to make better use of the job schedule.

Confidential

Sr. ETL Developer

Environment -Informatica Power Mart 5.1.2, Informatica Power Center 7.1, Oracle 9i, SQL Plus, PL/SQL, TOAD 8.0, AIX 3.2 PERL script , Windows 2000

Responsibilities:

• Worked with business analyst to gather requirements and framing it in technical design specification.
• Extensively making use of Informatica Power Mart 5.1.2 as ETL tool to load delimited and fixed width files receiving from AS/400 system.
• Loaded flat files to staging schema. Using business rules as per technical design specification to load data from staging to dimension and fact tables.
• Developed documents to set up CONTROL - M jobs to schedule Informatica batches and workflows to run at required frequency.
• Worked extensively on different types of transformations like source qualifier, expression, lookup connected unconnected , stored procedure and joiner.
• Designed and developed complex mapping using mapplets.
• Widely used of Shared folders, project folders and short cuts to maintain integrity between development, test and production repository.
• Worked closely with administrator to migrate mappings from development to testing environment.
• Created sessions and batches within a batch at required frequency.
• Implemented concurrent and sequential batch using Power Mart Server Manager 5.1.2.
• Frequently used import export utility to migrate session from developer's folder to subject folder.
• Polled the Informatica server, monitoring a session to troubleshoot sessions and to improve session performance.
• Extensively used parameter file to pass mapping and session variables.
• Involved in analyzing development, test production repositories before kicking off up gradation to Informatica 7.1.
• Involved in up gradation issue as well as post up gradation issue.
• Developed PERL scripts to remove unwanted hex characters such as Line feed and carriage return from a delimited flat file.
• Performed unit testing before promoting it to test environment.
• Created views, tables, materialized views using TOAD.
• Updated mappings and transformation with necessary comments to track of revision history and logic being used.
• Also took care of enhancement to existing applications by various Magic Tickets and adding new codes and raising change control request to promote the code to Production.

Confidential

ETL Developer

Environment -Informatica Power Center 7.1, Power Connect ODBC Striva , Oracle 10g, SQL Plus, PL/SQL, TOAD 8.0, Embarcadero ER Studio 6.5, Mainframe COBOL , Windows NT

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively used ETL to load data from fixed width as well as Delimited Flat files and COBOL files.
• Imported the COBOL files from sync sort data source and also from mainframe server using Power Connect ODBC Striva.
• Worked extensively on different types of transformations like normalizer, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 7.1
• Developed and tested all the Informatica mappings involving complex Router, lookups and update strategies.
• Created workflows and worklets for designed mappings.
• Implemented mapping variables and mapping parameters in mappings.
• Set up batches and sessions to schedule the loads at required frequency using Power center workflow manager, PMCMD and also using scheduling tools.
• Generated completion messages and status reports using workflow manager tool.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Involved in writing ETL specifications and unit test plans for ETL mappings.
• Performed Unit testing, Functional testing, System testing for the Informatica mappings.
• Involved in designing the data model for three schemas such as GAP, TSU and COM-DIM.

Confidential

ETL Developer

Environment -Informatica Power Center 6.2.2, Oracle 9i, SQL Plus, PL/SQL, TOAD 7.6, UNIX Kron Shell , Windows NT

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively used ETL to load data from both fixed width as well as Delimited Flat files, XML files and also from the relational database, which was Oracle 8i.
• Developed mappings, reusable Transformations for ETL using Informatica Power Center 6.2.2
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator and joiner.
• Developed and tested all the Informatica mappings involving complex Router, lookups and update strategies.
• Configured sessions with Email and Command task.
• Configured workflows with email task, Control task, Event-Raise task, Event-Wait task, Timer task, Command task, Assignment task and decision task based upon business requirements.
• Created workflows and reusable worklets for designed mappings.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Analyzed the session, event and error logs for troubleshooting mappings, sessions and workflows.
• Extensively used debugger to troubleshoot logical errors.
• Extensively used PL/SQL for creating views, stored procedure, and indexes on the tables.
• Involved in partitioning of the sessions and performance tuning of database, Mappings, as well as Sessions.
• Monitored the productions processes that run daily, weekly and monthly.
• FTP files from one server to another server and wrote a shell script to generate a columns report.