SUMMARY

• 10+ years of proven experience in the areas of SDLC: Requirement analysis, Design, Development, Testing, Implementation and managing of applications using ETL & IBM Mainframe using tools like 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 & Data 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,X12 - 834 etc.
• Had good knowledge of working with OLAP systems like Cognos 7/8 & Business Objects.
• 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, SQL Server 2008, IDMS, IMS DB/DC

File System: VSAM

ETL Tools: Informatica Power Center 8.6/ 9.1/9.5, 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, 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,OLAP - Business Objects.

Sr.Informatica Developer/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,OLAP - Business Objects.

Sr.Informatica Developer/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/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 OLAP - Cognos.

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 Cognos.

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, Cognos.

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.

Senior Software Engineer/SME

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.