Professional Summary:

• More than 8 Years of IT experience.
• Worked in complete Software Development Life Cycle SDLC , starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
• Worked on Oracle Database supporting OLTP and Data Warehouses.
• Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
• Strong experience with Informatica tools Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
• Developed effectively different type of SCD's based on the specifications.
• Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger projects.
• Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
• Experience in developing Test Strategies, Test Plans, Test Cases, and Test Scripts and provided 24x7 production support.
• Experience in T-SQL Programming skills. Experience in query optimization performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Experience in interacting with onsite clients while being responsible for deliverables.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Quick to learn.
• Good team player, strong interpersonal and communication skills combined with self-motivation initiative and positive attitude.
• Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.

Technical Skills:

Operating Systems: UNIX, Windows XP/2003/2007

Languages: C, C , Java, SQL, PL/SQL

Databases: Oracle, MS Access, DB2

Web Related: HTML

ETL Tools: Informatica, Ab Initio, OLAP

Schedulers: DAC Data Warehouse Administration Console , CA7 in Mainframes, Crontab in UNIX

Reporting Tools: Cognos, OBIEE

Utilities: TOAD, SQL Developer

Professional Experience:

Confidential

Role: Sr. ETL Informatica Developer

Responsibilities:

• Performed role of ETL Developer which includes requirement analysis, design, development, testing, documentation and production deployment.
• Worked on Informatica Power Center to develop mappings, sessions and workflows.
• Built Staging layer with error checks, WH and Marts to enable data exchange with external systems.
• Involved working on Oracle database, designing and creating tables, relations, constraints, indexes, PL-SQL functions and procedures.
• Also developed UNIX Shell Scripts to automate the ETL processes.
• Extensively involved in writing SQL queries sub queries and join conditions for building and testing ETL processes.
• Designed mappings for Slowly Changing Dimensions Type 1 Type 2 , used Lookup connected and unconnected , Update strategy and filter transformations for loading historical data.
• The weekly historical load of data from different geographic locations like NA, LA, WE, CE, AAI, GC, NEA. The system developed used to receive SAP-BW file from Gillete which was then converted into P G standards and loaded into the ADW system.
• The process was designed to run on a weekly basis for all the 7 different regions. The weekly run timings for different regions were different.
• Responsible for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings, fixing re-running and developing error-handling methods.
• Performed Admin tasks like recycling the services Repository and Integration services , purging log files, creating users, groups, roles, folders and assigning privileges permissions.
• Have built performance-tuned systems with maximum optimization, reusability and ease of operation.
• OLTP On-line Transaction Processing and OLAP Online Analytical Programming system will provide source data to data ware house which helps OLAP in data analysis.
• Created Function specification, High level design document ETL design architecture and Low level design document and Unit Test Case, deployment and operational document.
• Role also involved leading the onshore and offshore team members, assigning and reviewing their work.

Environment: Informatica Power Center 8.5/8.6, Cognos, SAP, Erwin, MQ Series, Altiris, Oracle 10g, DB2 8.1.6/8.2.0, UNIX, Windows NT 4.0, PL/SQL, T-SQL, SQL Loader, SSIS, Business Objects 6.0, TOAD Quest Software.

Confidential

Role: Sr. ETL Informatica Developer

Responsibilities:

• Designed the Mapping Spreadsheet and Functional Design Documents for the Source to Stage, Stage to Data Prep and Data Prep to Target mappings.
• Created the Physical and Logical Data Models using ER Studio Data Architect.
• Elaboration of Legacy Mainframe Files.
• Build the mappings for Profile tables from Data Prep Tables.
• Pre- Populated all the data required for the Fixed/Profiles tables using mappings and Stored Procedures.
• Created the Data Maps for the Mainframe Files Copybooks.
• For the conversion/historical data, the different source systems used are Legacy Mainframe files, DB2, Oracle and SQL Server ODS Systems , XML Files and BP ODS CP ODS Systems are sourced for Daily changes Change Data Capture
• Conducted user interviews with all the Business Partners and gather the requirements.
• Build and Unit tested all the mappings for Source to Stage, Stage to Data Prep Data Prep to Target Tables.
• Provided reports using OLAP capabilities of Cognos Reports for the purpose of data analysis
• Followed the Agile methodology and delivered the Data Assest per each Subject Areas.
• Executed different scenarios in Unit Testing, Integration Testing, Data Validation, System Testing and User acceptance testing.
• Produced the reports using SSAS for the Business users.

Environment: INFORMATICA POWER CENTER 9.5.1, INFORMATICA POWER EXHANGE, 9.5.1, Unix , windows Shell Scripting, SQL Server, Pl/SQL Stored Procedure , Oracle 11g, DB2, Teradata, Ultra Edit, Quest Putty, TFS , Clear Quest , SQL Server Management Studio , SSIS, SQL Developer , ER Studio Data Architect and XML Files.

Confidential

Role: ETL Informatica Developer

Responsibilities:

• Actively involving in the 24 7 support and doing the enhancements wherever required.
• Analyzing and fixing the code in production instantly after doing quick testing in production-like environment whenever there is a job failure due to the code issue.
• Tuning the Informatica workflows for optimal performance.
• Creating scripts in Unix for auditing and scheduling of Informatica batches
• Providing the permanent fix whenever the jobs get failed due to repeated issues.
• Preparing the documentation for easy maintenance of project.
• Update Business whenever there is any delay in the batches for any reason and plan accordingly so that there should not be much impact to Business.
• Actively participating in the DR Disaster Events that take place over the weekends in every quarter.
• Working over the incidents/tickets that are created by different business users by prioritizing them based on issue criticality.
• Providing necessary support for OBIEE queries whenever required.
• Provides spontaneous response to the queries posted by business users and supporting teams.
• Track the status of work from time to time and provide timely updates to team lead.
• Assign the team members accordingly to complete the work based on their competent.
• Working along with the team as a part of the regular activities in day-to-day work besides his other responsibilities.
• Automated the jobs by considering their internal dependencies and based on upstreams.
• Closely working with Business users during the month-end batches and provides timely updates in terms of status of the batches as they get executed continuously for 2 days as these are very critical to the Business for reporting purpose.
• Creating the OBIEE reports based on adhoc requirements from Business.
• Handling escalations in the best way whenever there are any.
• Scheduling the calls with Business users to understand the issues clearly and solve the issue accordingly.
• Encouraging the team to participate in multiple events that are conducted by Organization.

Environment: Informatica Power Center 8.6.1, Oracle 11, UNIX, Tivoli, OBIEE 10, TOAD andMainframes.

Confidential

Role: Informatica Developer

Responsibilities:

• Participated in discussion with senior management team for the better understanding of business requirements.
• Hands on experience in handling large volumes of data in production environments.
• Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
• The EP's were scheduled at DAC level as per client specifications after creating the tasks, assembling 'subject areas' and building the 'Execution plans'.
• Participated in the DAC implementation.
• Helping the team in resolving technical/non-technical issues.
• SIL- Source Independent loading, where the transformed data will be loaded into the final target tables.
• SDE - Source dependent Extraction, where the data gets extracted from different source systems to staging tables. This is the staging area.
• Designed the project in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica level.
• Involved in Analysis phase of business requirement and design of the Informatica mappings using low level design documents.
• Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Troubleshooting the loading failure cases, including database problems
• Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
• Documented Mappings, Transformations and Informatica sessions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Environment: Informatica Power Center 8.6.1, OBIEE 10, DAC, UNIX, Oracle 11, SSIS, SQL, PL/SQl and TOAD.

Confidential

Role: Informatica Developer

Responsibilities:

• Designed and developed Informatica mappings for data loads and data cleansing.
• Developed mappings with XML as target and formatting the target data according to the requirement.
• Developed code to load the data from Flat File to stage and stage to DWH.
• Migrating objects between different Environments using XML Export/Import using Repository Manager .
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code Performance Tuning
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Worked mostly on Lookup, Aggregator, and Expression Transformations to implement complex logics while coding a Mapping.
• Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Arranged weekly meetings with the offshore team and discuss both the technical and non-technical issues along with the status of work from time to time.
• Worked with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions by creating Technical Specifications Source to Target Documents for the ETL from the Functional Specifications.
• Created mappings to incorporate Incremental loads.
• Developed reusable Mapplets to include the Audit rules.
• Working with Power Center Versioning Check-in, Check-out , Querying to retrieve specific objects, maintaining the history of objects.
• Designed the Workflow for the ODS load following the load Dependencies.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Solely responsible for the daily loads and handling the reject data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Creating stored procedures and sequences to insert key into the database table.
• Involved in writing PERL scripts for file transfers, file renaming and few other database scripts to be executed from UNIX.
• Extensively Used Perl Scripting to schedule the Informatica Jobs.
• Maintained/Fixed bugs in existing PERL scripts.
• Guided the testing team and the development team and monitored the Implementation.
• Provided support for the Nightly jobs.

Environment: Informatica Power Center 8.6, Erwin 4.5, Oracle 10g, PL/SQL Developer, XML, Windows XP, PL/SQL, PERL, TOAD

Confidential

Role: ETL Informatica Developer, PL/SQL Developer

Responsibilities:

• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Tracked the status of work from time to time and provided timely updates to team lead.
• Gathered requirements from Client through calls and emails.
• Development and testing of mappings at Informatica level.
• Created PL/SQL Packages in Oracle for data validations like Database Validations i.e. primary, foreign key and check constraints as per the functional and technical documents.
• Provided test results to client and get sign-off for the same to deploy code in live environment.
• Migrated the code from UAT to production environments.
• Fix the issues as per the results of validations from PL/SQL packages in production.
• Provided spontaneous response to the queries posted by business users and supporting teams.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Scripts.

Confidential

Role: ETL Developer

Responsibilities:

• Analyzed the existing business model.
• Interacted with business users on weekly basis in finalizing high-level business requirements.
• Prepared detail-level design documents based on the discussions to get sign-off from business.
• Analyzed the impact and provided estimations in PD's to Client whenever there was a change in client requirements.
• Created Informatica jobs to extract data from different external sources and populate into data warehouse tables/flat files by transforming the data as per business rules.
• Involved in Unit testing and Integration testing of Informatica workflows.
• Responsible for tuning the Performance of Informatica ETL mappings.
• Reviewing and testing of mappings, sessions, workflows.
• Analyzing the impact and providing the Estimations to Client in PD's whenever there is a change in the requirement.
• Provided the warranty support by interacting with production support teams.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Scripts.