SUMMARY

• Self - motivated and quick-learner with strong analytical, technical & leadership skills.
• Experience in Financial, Banking, Credit Cards, Investments, and Marketing businesses.
• Involvement in all SDLC phases, from requirement gathering and design to implementation.
• Discuss business requirements with business users; conduct technical design sessions with architects.
• Preparation of HLD & LLD, and Unit & System test plans for ETL & IBM Mainframe environments.
• Write medium to complex SQLs to analyze existing data; develop processes to meet new requirements.
• Preparation of Traceability matrix to confirm that all business requirements are implemented and successfully tested; interacting with end-users for production implementation approval.
• Preparation of Detailed Task Plan (DTS) for production implementation.
• Coordinating with other applications, business users & support groups.
• Experience working and coordinating with offshore resources in onshore/offshore model.
• Mentoring the development team for project approach and technical issues.
• Reviewing the code & test results for production implementation.
• Well versed with testing and defect management tools like Quality Center, and Gemini.
• Analyzing, assigning/resolving, tracking testing defects during System Testing and UAT.
• Ability to deliver quality deliverables under tight deadlines.
• Extensive development experience in ETL technologies & IBM Mainframe environments, and supporting testing/production environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Datastage, Scribe, SSIS, IDQ

Reporting Tools (Training): Business Objects, Cognos, SSRS, and Tableau

RDBMS: Oracle 10g/11g/12c, SQL Server 2012/2014, DB2 v9/v10, Teradata v12/v13, MS ACCESS

Database Tools: SQL Developer (Oracle), SQL Server Management Studio

Data Modeling: ERWIN;Scripting UNIX Shell Scripting

Mainframe Tools: COBOL, DB2, CICS, MVS, JCL, VSAM, TSO, ISPF, DB2I, BMC, CA-Platinum, SyncSort, File-Aid, Xpediter, Intertest, Endevor, Connect Direct, CA-7

Other Tools: Quality Center, Gemini, Service Center, Visio, MS-OFFICE (Word, Excel, Power point, Outlook)

Operating Systems: Win 2008 Server, Win 10/2007/XP/NT/2000, UNIX, MVS, Z/OS, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential

CDI Engineer

Responsibilities:

• Study the existing processes and design ETL strategies involving creation of new mappings, and modification of existing mappings to meet business requirements.
• Designed and developed ETL processes involving multi-source single-target mappings and vice versa, using heterogeneous sources like flat files, SQL Server, Oracle & XML.
• Used Informatica Power Center Client (Repository Manager, Designer & Workflow Manager).
• Used Designer to develop mappings and mapplets using Lookup, Sorter, Router, Joiner, Source Qualifier, Update Strategy, Filter, Sequence Generator, Aggregator, Normalizer, and Expression.
• Developed sessions, worklets, workflows, using the parameter files.
• Wrote UNIX shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Involved in Data Modeling to create Star and Snow Flake Schema models using Erwin.
• Developed SQLs and stored procedures to extract meaningful data from databases.
• Fine-tuning of mappings and SQL queries to achieve better performance and efficiency.
• Precise Documentation was done for all mappings, mapplets, sessions, worklets, and workflows.
• Used Debugger for troubleshooting the mappings.

Environment: Power Center 9.x, Scribe, Oracle 11g/12c, SQL Server 2012/2014, Microsoft Azure, XML files, Flat files, CSV files, UNIX, Tidal, Gemini, Service Now, Windows 2007 / Win 10

Confidential

Mainframe Senior Programmer / ETL Analyst

Responsibilities:

• Participate in meetings with business users to understand required enhancements.
• Involved in technical design sessions with architects to discuss the application changes.
• Analysis and design of ETL processes by creating/modifying new/existing mappings to meet requirements.
• Development ETL processes using heterogeneous sources like flat files, COBOL files, DB2, Oracle & XML.
• Used Mapping Designer to develop medium to complex mappings using Lookup, Sorter, Router, Joiner, Source Qualifier, Update Strategy, Filter, Sequence Generator, Aggregator, and Expression.
• Used Debugger for troubleshooting the mappings.
• Create parameter files to store all mapping variables and session parameters.
• Developed SQLs and stored procedures to extract meaningful data from databases.
• Deploy the mappings, sessions, workflows, etc. from development to testing environments.

Environment: Power Center 9.x/8.x/7.x, DB2 v9/v10, Oracle 9i/10g, Teradata v12/v13, XML, Flat files, UNIX, Windows XP, UNIX Shell Scripts

Confidential

Mainframe Senior Programmer / Analyst

Responsibilities:

• Involved in analysis, design, preparation of HLD & LLD, and Unit & System test plans.
• Development & testing of software modules; and supporting testing/production environments.
• Analyzing, assigning/resolving, tracking testing defects during System Testing and UAT.
• Coordinating with other applications, business users & support groups.
• Mentoring the development team for project approach and technical issues.
• Reviewing & approving the code & test results for production implementation.

Environment: IBM Mainframe, COBOL, DB2, CICS, MVS, JCL, VSAM, TSO/ISPF, DB2I, QMF, BMC, CA-Platinum, SyncSort, File-AID, File-Manager, Xpediter, Endevor, Connect Direct, CA-7

Confidential

Lead Consultant

Responsibilities:

• Gathered business requirements; analyzed various source systems to determine needed data.
• Analyzed the process flow diagrams, source to target mappings (Excel), and ETL mappings.
• Develop HLD & LLD, and test plans; production implementation planning.
• Created complex Informatica ETL mappings for extraction and loading data as per process requirements.
• Development and testing of software modules on IBM Mainframe environments.

Environment: Power Center 9.x, Oracle 10g, XML, Flat files, UNIX, Windows XP, UNIX Shell Scripts IBM Mainframe, COBOL, DB2, CICS, MVS, JCL, VSAM, TSO/ISPF, DB2I, QMF, SyncSort, File-AID

Confidential

Application Programmer / Analyst III

Responsibilities:

• Involved in enhancements to existing processes as per requirements.
• Preparation of HLD & LLD documents; Coding, Unit & System testing of software modules.

Environment: IBM Mainframe, COBOL, FileMaxx, CICS, MVS, JCL, VSAM, TSO/ISPF, SyncSort, File-AID, Xpediter, Endevor, CA-7