SUMMARY

• Senior ETL Consultant with 9+ Years of End - To-End BI Development experience ranging from ETL, Data Profiling, Data Quality, Data analysis, Data modelling and reporting.
• 9+ years of total experience in Business Requirements Analysis, Data Integration, Data Coversion,Data Warehouse/Data Marts, Business Intelligence, ETL, Dimensional Data Modeling, Coding, Development, Testing and Implementation with RDBMS and non RDBMS.
• 9 years of experience using Informatica in designing and developing ETL mappings and scripts using Informatica Power Center 9.6/9.5/9.1/8.6/8.5/8.1/7.1/7.0.
• 3 Years of experience in designing and developing ETL mappings and scripts using SAP data services-BODS.
• 2 Years of experience in designing and developing ETL mappings using IBM Datastage
• 2 Years of experience in SAP HANA modeling, creating attribute, analytical and calculation views.
• 1 years of experience in SAP Information Stewards, creating Multi column data profiling, Rules, Scorecards and Metapedia terms.
• 9+years of database experience using Oracle, DB2, MS SQL Server, Sybase IQ, Netezza, SAP HANA
• 2 years of experience in designing and developing ETL mappings and scripts using IBM DataStage
• Extensive experience working in Finance, mortgage, retail and sales-shipment.
• Experience in translating user requirements into functional, technical specifications and ETL mapping documents.
• Experience on Dimensional Data Modeling like Star and Snowflake schemas.
• Business Intelligence experience using Oracle BI (OBIEE), Business Objects and Tableau.
• Extensively worked on SQL & PL/SQL programming.
• Skilled in UNIX shell scripting and experience on different UNIX platforms.
• Excellent troubleshooting/Production Support skills, user interaction.
• Experiences on big data - Hadoop-HDFS, Hive and map reduce.
• Experience on Oracle Data Integrator(ODI)
• Experience in working on Informatica data quality-IDQ to attain data profiling, worked on reference data.
• Experience in Customer relationship management-CRM
• Experience in working with SAP sources
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.
• Experience in working with business users in gathering requirements, converting them to technical artifacts.
• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills.
• Experience in training business users on using products developed and creating user support documents.
• Proficient in production support activities with effective change management configurations using visual source safe VSS, Handling Incident tickets, change requests and Problem tickets using Remedy Incident Management and Quality Center tool.
• Involved in carrying out Quality Reviews, Audits, design and development reviews, review of user-cases and test-cases, business scenarios and root-cause analysis, coordinating user acceptance testing, training, and implementing new processes.

TECHNICAL SKILLS

Technologies: Informatica power center 7.x/8.x/9.x,Oracle 9i/10g/11g/12c SQL Server 2000/2005/2008 , Sybase ASE/Sybase IQ, Netezza,Tidal Scheduler, UNIX/HP-UX/Sun Solaris,IBM Datastage 8.x,Netezza,Hadoop, SAP Data services-BODS,SAP-HANA modelling

Domain Expertise: Sales, shipment, mortgage, Finance, human resources and Insurance

Industry Expertise: Oil and Gas Industry, Banking, Retail, Mortgage and Manufacturing Industry and IT industry.

PROFESSIONAL EXPERIENCE

Confidential, Torrance CA

Sr ETL developer/Lead

Responsibilities:

• Responsible for Design, Development and Implementation of EIP.
• Lead an offshore team, responsible for ETL work distribution, helps developers understand the requirements, Technical assistance in code development/design, Code review and testing coordination.
• Created Technical specification documents and worked with Business Analysts on analysis of multiple source systems data as part of ETL mapping exercise.
• Worked with business on requirement gathering and converting them into technical specification documents and mapping documents for some modules of the project.
• Created jobs for Informatica jobs to capture history and current data using slowly changing dimension concepts.
• Created ETL jobs for data conversion from one system to another system.
• Worked on reading heterogeneous sources to consume transactional data.
• Created batch Process which schedules and runs the total Informatica and pl/sql process by Parameterization.
• Created jobs to read reference data tables for identifying unique customer and its constituent table elements,Worked on Autosys scheduling plan based on dependency
• Created UNIX scripts to process files landed in the source location over a period, to archive, to merge on dealing with multiple files.
• Created ETL task tracking documents and task assignments to team, updating status to project team, identifying showstoppers and followed the required steps to mitigate latency in the deliverables.
• Created Oracle Stored procedures to automate table partition add/drop/exchange functionality.
• Created jobs to generate exception reports and route to business users and data governance teams to correct the data at host systems based on the exception report details.
• Created best practices document which will be used in other projects on floor or different modules of the project.
• Supported/Participated in the SIT and UAT testing cycles and worked on the quick remediation of the defects fell out of the testing.
• Worked on Performance tuning of ETL Processes, followed the best methods to enhance the execution times of the jobs.
• Provided support to training team to develop training materials for all downstream users, support team and scheduling team.
• Trained users with best practices and ways to use system more efficiently.

Technologies: Informatica 9.x, Tibco, MFT, Oracle PL/SQL, ESB, SQL Server, Autosys, Linux

Confidential, AR

Sr ETL developer/ETL architect

Responsibilities:

• Lead an offshore team, responsible for ETL work distribution, helps developers understand the requirements, Technical assistance in code development/design, Code review and testing coordination.
• Worked on implementing Change Requests by creating technical design documents, mapping documents and development.
• Worked with business analysts on analysis and with business on requirements and building the data services jobs for EDM.
• Worked on designing phase of HANA modelling solution for EDM based on the dimensions and facts data.
• Worked on SAP information Stewards for Data profiling .
• Creating data stage jobs for all the layers and put into the sequence. Worked on Transformations
• Extensively worked on jobs designing using MQ, checksum and XML input stages
• Creating Routines and Parameter sets for Datastage jobs.
• Created HANA attribute views, analytical views, Calculations views and generating reports on the views.
• Created jobs for BODS jobs to capture history and current data using slowly changing dimension concepts.
• Worked on database scripting to create calculation views in script mode.
• Creating test cases and unit testing worked closely with QA teams to progress the testing as per the schedule.
• Worked on project tracking, task assignments, status updates, identifying risks and communicating timely manner.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Technologies: IBM Datastage, SAP BODS, SAP HANA, SAP Information Stewards, Oracle, SQL server, Unix

Confidential, TX

Sr ETL Developer

Responsibilities:

• Lead a team from offshore, responsible for ETL work distribution, helps developers understand the requirements, Technical assistance in code development/design, Code review and testing coordination.
• Involved in design discussions and analysis at onshore during initial phase of the project.
• Understanding the business requirements and creating Informatica jobs for staging, ODS and history preserve jobs to hold the dimensional data IDR data warehouse.
• Created mapping to read data from COBOL copy books and load to relational target tables.
• Worked on Performance tuning of ETL Processes, followed the best methods to enhance the execution times of the jobs Worked on scheduling process.
• Developed encoding and decoding functions to generate hash keys for Change data capture to flag the records accordingly.
• Supported/Participated in the SIT and UAT testing cycles and worked on the quick remediation of the defects fell out of the testing.
• Provided Knowledge Transfer to the end users and support teams, created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Technologies: Informatica 8.6.1, Oracle, DAC,OBIEE,SAP applications

Confidential

Sr ETL Consultant

Responsibilities:

• Understanding the business requirements and building the mappings for OBIEE R2 data warehouse.
• Developed stored procedures to load data from staging tables to dimension and fact tables.
• Created new jobs and customized BI APPS mappings based on the project needs.
• Created overall dependency flow chart and embedded the schedule into Data warehouse admin console-DAC.
• Created Visio flows for ETL mapping flows based on rules provided in the mapping documents.
• Involved in peer review and created review documents which depict discrepancies with the ETL standard checklist.
• Supported/Participated in the SIT and UAT testing cycles and worked on the quick remediation of the defects fell out of the testing.
• Provided Knowledge Transfer to the end users and support teams, created extensive documentation on the development, implementation, daily loads and process flow of the mappings.

Technologies: Informatica 8.6.1, PeopleSoft, Oracle, DAC,OBIEE