SUMMARY

• An accomplished IT professional in analyzing Business Requirements, Software Development, Data Migration, Data Integration and ETL process.
• Expertise in data integration module of Informatica end - to-end implementation and production support projects.
• Expertise in creating technical specifications, data mapping documents, perform data analysis, data validation, data movement, data transformation.
• 14 years of successfully in design and development of ETL process using Informatica Power Center
• 2 years of successfully in design and development of ETL process using SAP Business Object Data Services
• Expertise in extraction, transformation and loading data to and from systems like Oracle, SQL Server, XML, flat files and JMS (Java Message Service)
• Experience using Informatica in implementing full loads, delta loads
• Experience in Oracle PL/SQL and Oracle SQL Developer to develop SQL Queries
• Experience in ETL Error Handing, performance tuning and Code Optimization
• Experience of project execution using Soft Development Life-Cycle Processes
• Experience in migrating the code between environments, with supporting documentation
• Implementation using Agile Methodology
• Strong analytical, technical, root cause analysis and problem resolution skills
• Interface well with clients, colleagues, and all staff levels using highly effective interpersonal skills
• Dedicated, hardworking, and committed to exceeding customer expectations

TECHNICAL SKILLS

• Informatica Power Center Version 10.2, Web Methods Active Transfer - MFT
• SAP Business Objects Data Services Integrator/Quality XI 3.1
• Generate and install SAP R/3 code - ABAP programs, Import tables from SAP
• Generate and execute DDL statement for Oracle database
• Oracle, SQL Server 2008, Star and Snow Flake Schemas, UNIX Shell Scripting
• Oracle PL/SQL, SQL*Plus, CuteFTP, EditPRO, Oracle SQL Developer, Putty, FileZilla
• SAP modules: MM, PP, QM, BI, BO, BOBJ, LSMW, SAP-ECC
• Microsoft Project, Word, Access, Excel, PowerPoint, Visio, SharePoint
• Mercury Test Management tools (Quality Center, Test Director)

PROFESSIONAL EXPERIENCE

Confidential

Informatica/ETL Developer

Responsibilities:

• Develops, tests, implements and supports interfaces between system and SAP R/3 application.
• Interact with Business users and review requirements to create technical and data mapping specification documents.
• Perform data analysis on source systems to define source to target data mapping
• Design, develop, unit test and maintain Informatica mappings, sessions and workflows.
• Developed Informatica mappings using various transformations like Lookup, Source Qualifier, Joiner, Router, Aggregator, Update Strategy and more as per requirements
• Assisted in developing test plans, support system testing and User acceptance testing
• Assisted team with troubleshooting, identifying issues, performance tuning, scheduled batch jobs and production support
• Used Informatica to extract, transform and load data from multiple input sources like flat files, XML, Oracle, SAP-ECC to target like Oracle, XML, flat files.
• Used JMS (Java Message Service) as source to insert/update Oracle tables.
• Developed and maintained Web Methods Active Transfer - (MFT) Managed File Transfer solution to exchange files between Confidential and external customers
• Extensively used SQL Developer to run SQL queries for data analysis in Oracle
• Performed deployment to move code from development to QA or Production
• Maintained Agile methodology

Technology on project: Informatica Power Center 10.2, Oracle, SQL Developer, FileZilla, Putty, UNIX Shell Scripting, XML, Microsoft Word, Access, Excel, PowerPoint, Mercury Test Management tools (Quality Center), Web Methods Active Transfer - MFT

Confidential

Informatica/ETL Developer

Responsibilities:

• Designed and developed new interfaces between legacy system and a web-based OMST application provides a global support solution for managing manufacturing impact of obsolete parts and for reducing risks
• Interacted with customers to review requirements to create high level specification and perform data analysis on source systems to define source to target data mapping
• Involved in extracting source data from flat files, databases on different systems
• Developed execution test plans for unit and system testing ETL process
• Assisted team with troubleshooting, identifying issues, performance tuning and production support
• Debugging mappings using break points, sessions, batches and target data tables
• Developed ETL process to extract and load source data files onto Oracle tables
• Extensively used SQL Developer to run SQL queries for data analysis in Oracle
• Create, maintain and troubleshooting complex SQL queries for data analysis
• Performed daily research issue resolution relating to batch processes, and end-to-end application delivery
• Maintained Software Development Life Cycle and Agile methodology

Technology on project: Informatica Power Center 9.5.1, Oracle, PL/SQL, SQL Developer, Putty, Bitvise SSH Client, UNIX Shell Scripting, Microsoft Word, Access, Excel, PowerPoint, Mercury Test Management tools (Quality Center, Test Director)

Confidential

Data Analyst/ETL Developer

Responsibilities:

• Worked as part of ETL team for development and implementation of SAP Conversion within Confidential (US, Asia and Europe) project; extracted and translated data from legacy system into SAP
• Worked with BI/Data Warehouse team to developed and implemented ETL processes.
• Interacted with customers to review requirements, high level system design, technical specification, data analysis on source systems to define source to target data mapping, estimating and implementations
• Performed data profiling and quality assessments on legacy system and conducted data related issues with customers
• Developed ETL process to extract and load source data into SQL Server tables
• Developed Technical design specification, ETL process flow and high level system design documents based on the functional design documents and physical data model
• Developed and executed test plans base on system and data validations
• Lead role to worked with offshore development team to conduct code reviews, identify issues, discrepancies and performance tuning optimization
• Developed and maintained, views and other database using SQL Server 2008 for SQL queries for Data Analysis
• Developed and managed ETL technical standards and methodology
• Created and modified SAP BO/BOBJ Reports for business needs
• Maintained Software Development Life Cycle and Agile methodology

Technology on project: SAP Business Objects Data Services Integrator/Quality XI 3.1, Informatica Power Center 8.6, Oracle, SQL Server 2008, PL/SQL, SQL, UNIX environment, Microsoft Word, Excel, PowerPoint, Visio, Mercury Test Management tools (Quality Center, Test Director), and SAP modules: MM, PP, QM, BI, BO, BOBJ