SUMMARY

• 12+ years of proven experience in the areas of SDLC: Requirement analysis, Design, Development, Testing, Implementation and managing of applications using IBM Mainframe & ETL using ETL tool Informatica.
• Certified in Informatica PowerCenter 8 Mapping Design for ETL with 75% in April 2009.
• Certified in IBM DB2 Universal Database V8.1 with 87% in October 2008.
• Had played several rolls like Senior Informatica Developer/Lead, Informatica Admin & BI Analyst.
• Over 6+ years of experience in using Informatica Tool covering Designer, Workflow Manager, Repository Manager. ETL for enterprise Data Warehouse/ Data Marts.
• Over 7+ years of experience in leading team and solving issues for team members.
• Hands on experience of extracting data in Health domain specific format files like HL7,EDI - 834 etc.
• Had good understanding of Big Data & Hadoop concepts.
• Expertise in data conversion and data migration from multiple legacy systems (Mainframe) to other Relational/Flat files.
• Well versed with Relational and Flat file Data Migration Framework implemented using Agile and waterfall models.
• Experience in Data Conversion of various data sources like Oracle, SQL Server, DB2, MS Access, Fixed Width and Delimited Flat Files, VSAM, COBOL files & XML File.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, Flat files and XML
• Knowledge of writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, and Native Dynamic SQL using SQL, DB2 & DB2 UDB .
• Extensive experience on developing applications on Mainframe using COBOL, CICS, VSAM, JCL, DB2, DFSORT, SPUFI, TSO/ISPF, IBM OPTIM Studio 2.2.
• Very Good knowledge of both Batch and On-line Systems on Mainframe applications.
• Experience in performing Unit Testing, Integration Testing, and User Acceptance Testing (UAT) environments and experience in Bug Reporting and Fixing.
• Worked in various domains like Aviation, Financial, Automobile, Health care & Insurance domains, having good knowledge in Warranty Auto Claims processing.

TECHNICAL SKILLS

Languages: SQL,PL/SQL,COBOL, JCL, CICS, PL1,QPAC,REXX,CICS,BMS Macro

Operating Systems: Windows,UNIX,MVS OS/390, z/OS, DOS.

Database: DB 2 7.0/8.0/9.0 , Oracle 11g/10g/9i/8i/8, Teradata 13.10/14, SQL Server 2008, IDMS, IMS DB/DC

File System: VSAM

ETL Tools: Informatica Power Center 8.6/ 9.1/9.5/9.5.1 , IDQ Analyst & Developer.

Others Tools: CA interest, IBM Debugger, Manage Now, Changeman, Expeditor, MQ Series, Advantage Gen, Powerbuilder RPC, DB2 File Aid, Optium Studio 2.2, Tidal, Autosys, IMM 9.1 & IMM 9.5, Oracle SQL Developer, Teradata SQL assistant, SFTP.

Other: MS Word, MS Excel, MS Power point, MS office, MS outlook, Lotus Notes.

Internal Training: Undergone basic training on Advantage Gen(Coolgen) Big Data & Hadoop Training.

PROFESSIONAL EXPERIENCE

Confidential, Camp hill, PA

Environment: Informatica 9.5.1, DB2 V9.1, SQL Server 2008, Windows batch scripting.

Sr.Informatica Consultant/ETL Lead

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Worked with all teams for implementation of Informatica components & DB objects.
• Working for warranty tickets with in the teir1 SLA. Used to give estimation for teir2 tickets and development efforts for change requests.
• Developed mapping in creation of EDI 834 file format using informatica XSD’s.
• Had hands on experience of extracting data from views and cleanse data load into XML schema.
• Created complex stored informatica mappings that involved implementation of Business Logic to load data in to XML.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Used Informatica reusability at various levels of development.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Confidential, Cary, NC

Environment: Informatica 9.5.1, IDQ,Informatica Analyst,Oracle 11g, Teradata 14, UNIX Shell Scripting, Control-M,Crontab.

Sr.ETL Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Worked with architects to translate requirements into technical specifications. Involved in creation of source/Target mappings.
• Interacted with Business users on daily basis to recommend appropriate scope of requirements and priorities.
• Worked on mainframe conversion project to extract data from Oracle instead of DB2 to current DWH region.
• Had hands on experience of writing Teradata Stored procs to move data from Stage to Integration layer.
• Created complex stored proc’s that involved implementation of Business Logic to load data in to integration layer.
• Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Used Informatica reusability at various levels of development.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Applied DQ rules into current ETL process extensively used Data analyst tool to analyze data.
• Extensively worked as Teradata for data warehouse developer using utilities fast load, Multiload, TPT etc.
• Worked on CDC express environment.
• Worked on Scrum software development process involved in reporting of scrum meetings in different projects.Involved in scrum iterataion planning & closing sessions.

Confidential, Danville, PA

Environment: Informatica 9.1/9.5, IDQ,Informatica Analyst,Oracle 11g, Teradata 13.10, SQL Server 2008, UNIX Shell Scripting, Tidal 6.1.

Sr.Informatica Developer/ETL Lead

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Had hands on experience of data profiling, rules creation & matching rules using Informatica Data Quality Analyst & Informatica Developer tool.
• Have hands on experience of loading constraint based data model etc.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter, XML parser and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Assisting junior developers to resolve their technical problems.
• Extracted data from Oracle and SQL Server and used target as Teradata for data warehousing using utilities fast load, Multiload etc.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Confidential

Environment: Informatica 9.1, Informatica B2B,Oracle 11g, Teradata 13.10, SQL Server 2008, UNIX Shell Scripting, Tidal 6.0.

Sr.Informatica Developer/ETL Lead

Responsibilities:

• Acting as sole owner on ETL deliverables. Involved in project from starting phase from creation of BRD, design phase of data model, Development phase for ETL mappings and integration of Universe to current existing wellness project.
• Created mapping documents ETL developers.
• Had hands on experience of Informatica mappings development, workflow integrations.
• Had Played as Informatica Admin in migrating code from development to production environments.
• Has played vital role and revamping of Informatica folders. Created Source & Target DB connections.
• Modified existing BETQ scripts which runs on Teradata to accommodate new changes in data model.
• Analyzed complex SQL quires written for Business Objects which facing performance issues.
• Hands on experience of moving data from Stage to Foundation using CDC.
• Extracted data from different sources like SQL server, Oracles as well transformed data according into target as Teradata with instructions of to mapping documents.
• Had vast experience of building Master data for MDM hub.
• Worked on XML’s like reading from xml and writing to XML.

Confidential

Environment: Informatica 9.1, Oracle 11g, SQL Server 2008, Flat Files, UNIX Shell Scripting, Tidal 6.0.

Sr.Informatica Developer/ETL Lead

Responsibilities:

• Worked as Subject Matter Expert for this particular project in delivery and support of MediSpan project.
• Involved in design phase, Development phase and integration phases of this MediSpan project.
• Worked as Team Lead for this project in assisting junior developers.
• Had extensive hands on experience of Informatica mappings development using all types of Transformations.
• Created few UNIX scripts & worklets for the workflow. Designed robust workflow in handling error validations at every stage of work flow.
• Extensively used debugger to identify the errors in mappings.
• Extracted data from sources like fixed width, delimited flat files, SQL server & Oracles as well transformed data according to BRD for current project.
• Hands on code migration expertise from Development to production using SDLC process in all stages.
• Importing Source/Target Tables from the respective databases and created Reusable Transformations and Mappings using Designer Tool set of Informatica.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Power Center of Informatica.

Confidential, Cincinnati, Ohio

Environment: Informatica 9.1, Oracle 10g, Teradata 13.10, UNIX Shell Scripting, IMM 9.5.

Business Analyst/Data Analyst

Responsibilities:

• Played key role for Data Governance Team in collection of Metadata and management of MDM hub.
• Took over full control of Data Governance team for day to day activates involved like Master Data Management, Project Management, Template updating process of DGC.
• Created Story point/Uses Cases document with available tasks of Data Governance Team which can be use full for sprint planning’s.
• Created ETL designs for CDC (Change Data Capture), audits, exception handling etc.
• Involved in testing phase for migration of Business Glossary IMM 9.0 to IMM 9.5.
• Extensively worked in data Extraction, Transformation and Loading from source to target system using Power Center of Informatica.
• Importing Source/Target Tables from the respective databases and created Reusable Transformations and Mappings using Designer Tool set of Informatics.
• Involved in debugging and troubleshooting.

Confidential, Montvale, New Jersey

Environment: Informatica 8.6, DB2 9.0, UNIX Shell Scripting, DB2 UDB, XML.

Senior Informatica Developer/Team Lead

Responsibilities:

• Involved in development of full life cycle implementation of ETL using Informatica with sources like oracle, Mainframe DB2, SQL server, flat files and XML.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g.
• Built complex ETL solutions using Informatica to extract source data from Oracle, SQL Server, flat files and load it into Oracle based EDW (Enterprise Data Warehouse).
• Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type1, Type 2 and Type 3 for loading historical data and current data into EDW.
• Closely worked with Business Analysts for requirement analysis and in Design of Data modeling structures.
• Developed procedures and packages using dynamic PL/SQL.
• Used to run reports using Cognos 7 & Cognos 8 tool for data verification.
• Also involved in creation of functional document to write, test, debug, document, and implement complex Batch jobs to extract data from a variety of data sources, transform the data, and load the data to specified destinations using Data Services.
• Worked extensively with 10 mappings using Expression, Aggregator, Filter, Lookup and Stored procedures transformations.
• Extensively used Server Manager for creating and scheduling various sessions.
• Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping
• Used Mapplets extensively to design common mapping components

Confidential

Environment: Informatica 8.6, Oracle 10g, SQL Loader, PL/SQL, XML.

Senior Informatica Developer/Team Lead

Responsibilities:

• My key responsible for this project to Create Data Model on basis of Data Analysis which should be migrated to existing DWH region.
• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 10g.
• Built complex ETL solutions using Informatica to extract source data from Oracle, SQL Server, flat files and load it into Oracle based EDW (Enterprise Data Warehouse).
• Used to run reports using Cognos 7 & Cognos 8 tool for data analysis.
• Worked extensively with 10 mappings using Expression, Aggregator, Filter, Lookup and Stored procedures transformations.
• Implemented Joiner, Rank, Lookup, Update Strategy, and Router transformations in mapping

Confidential

Environment: Informatica 8.6, DB 2 7.0/8.0/9.0 , PL/SQL, DB2 UDB.

Informatica Developer

Responsibilities:

• Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was DB2.
• Worked on Round the clock production support, bug fixes, production break fixes.
• Prepared and presented training materials for the ETL tool and usage. Mentored employees on the ETL tool & processes.
• Tuned jobs for performance optimization of the resources.
• Performed pre production activities and involved in documenting all the test cases, tuning, enhancements procedures.

Confidential

Environment: DB2 7.0/8.0, PL/SQL, DB2 UDB, IBM Mainframes.

Responsibilities:

• Involved in Design, development, unit testing and integration testing of new Informatica jobs.
• Extracted data from legacy systems and put it in the Flat files, DB2 tables for further processing.
• Worked in implementation of user defined functions, initialization scripts for global variables used in during course of Job Execution, working with stored procedures and functions.
• Modified the existing Informatica jobs being used, according to latest requirements.
• Tuned jobs for performance optimization of the resources.
• Responsible for release engineer roles such as, configuring management and deployment.
• Involved in documenting high level design, detail design documents.
• Performed pre production activities and involved in documenting all the test cases, tuning, enhancements procedures.

Confidential

Environment: JCL, COBOL, CICS, DB2, Pan Valet, IBM Debugger, File Aid, File-Manager, REXX.

Responsibilities:

• As Senior Consultant involved designing, writing and modifying application’s using IBM Optim Development Studio 2.2, JCL, CICS, DB2 and COBOL for enhancement of existing & new applications.
• Coding & code walk through, writing detailed unit test plans and test requirements hierarchy, Unit Testing & Preparing Logs.
• Provide temporary and permanent fixes for the production batch abends.
• Review the deliverables to maintain the quality.
• Oversee the UAT execution for the production fixes.
• As a lead programmer implemented documentation process for the existing system.
• Involved in Project planning for CPOBMT as well involved more in tracking of issues with off shore team as well.
• Loading and unloading tables by using utilities and JCLs.
• Providing answers to queries/questions raised by Clients.
• Communicating with Business Partners for understanding the problem and clarifying their queries.
• Designed software requirements to implement dealer code comparison for every quarter which was made automated from manual process.