SUMMARY

• 11 Plus years of experience in software Application Development, Enhancement/Maintenance and Support projects involving analysis, design and integration of Data warehouse using ETL, Data Warehousing tools.
• Extensive experience in analysis, design, development, testing and maintenance of ETL using Informatica Power Center 7.x/8.x/9.x/.
• Good Knowledge on Physical modeling, logical modeling, Relational modeling, Dimensional modeling (Star Schema, Snow Flake Schema).
• Strong experience in designing and developing mappings to extract data from diverse sources including flat files, RDBMS tables, mainframe files, VSAM, XML and other legacy system files.
• Has developed mappings using Power Exchange 9.5,9.6 for mainframe, Web service Consumer, XML Generator, MQ Series.
• Has acquired domain knowledge in Investment Banking (US Clearance and Settlement) and Core banking.
• Has complete SDLC (Project Definition, Analysis, Design, Coding/Development, System Testing, Integration testing, Volume Testing, UAT, Pre - Implementation, Implementation, Post-implementation support) experience.
• Experience working in both Agile and Waterfall Methodologies.
• Profound knowledge of performance tuning concepts and could analyze for code/system bottleneck, implemented various Power Center, Power Exchange, Database (SQL tuning, Stats gathering) solutions including PDO, CDC, set based programming to reduce load windows.
• Functional knowledge on International Clearance systems (Euro-clear and other foreign markets). Additionally has good working knowledge on the SWIFT (Society for Worldwide Interbank Financial Telecommunication) messaging formats.
• Has working Knowledge on CA7 Workload automation tool and Autosys.
• Have knowledge on Teradata.
• Has good interpersonal skills, commitment towards work, result oriented, hard working with a zeal to learn new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.2/9.6.1/9.5.1/8.6.1/7.1.3 , Power Exchange 8.x/9.x, Informatica MDM

Operating Systems: MS DOS, Windows 95/98/2000/ NT/XP/7, MVS/ OS 390, UNIX,Linux

Application areas: Investment Banking, Credit Card, Core Banking, Finance

Languages: SQL, PL/SQL, CICS, COBOL.

Databases: DB2, Oracle 9i/10g/11g/12c, SQL Server

Tools: TSO/ISPF, File-aid, TOAD for Oracle, PL/SQL Developer SPUFI, QMF, IBM MQ, ALM(Application Life Cycle Management), Putty, Winscp, Ultraedit, JIRA Defect Tracking Tool, FTP, Winmerge

Scripting Languages: Unix Shell Scripting, Perl Scripting

Version Control Tools: Harvest, Endevor, Serena Changeman,UDeploy,SVN

PROFESSIONAL EXPERIENCE

Confidential, SAN LEANDRO, CA

SENIOR BUSINESS INTELLIGENCE DEVELOPER, MODULE LEAD

Responsibilities:

• Discuss with Business Analyst to understand the business requirements.
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio and Create Source target mapping specification documents.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed, tested stored procedures in PL/SQL for Data ETL.
• Worked extensively with SQL to create ad-hoc management reports for Management Reporting using PL/SQL and SQL.
• Used PMCMD command to call / run the workflows from the ABC cycle to process all jobs.
• Auditing the jobs to Create the data required for User Interface viewing(UI).
• Working with MQ targets to facilitate the near Realtime payment messaging service.
• Created workflows, sessions, tasks, mapping parameter, mapping variables, connections, parameter file etc. Also have knowledge on creating worklets.
• Migrate historical data, which is one time and built migration process for ongoing data loads.
• Scheduling the jobs using Autosys Scheduling tool.

Environment: Informatica PowerCenter 9.5.1/9.6.1 /10.2 , Informatica MDM, Unix Shell Scripting, Ultra-edit, Oracle 12c,Oracle Exadata, TOAD for Oracle, Autosys, NDM-Connect Direct, HP ALM, Power Exchange, SVN, Github, uDeploy.

Confidential, CLEVELAND-OH

SENIOR DEVELOPER, MODULE LEAD.

Responsibilities:

• Discuss with Business Analyst to understand the business requirements.
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio and Create Source target mapping specification documents.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed workflows using address validation for MDM Implementation.
• Developed, tested stored procedures in PL/SQL for Data ETL.
• Worked extensively with SQL to create ad-hoc management reports for Management Reporting using PL/SQL and SQL.
• Used PMCMD command to call / run the workflows from the ABC cycle to process all jobs.
• Created workflows, sessions, tasks, mapping parameter, mapping variables, connections, parameter file etc. Also have knowledge on Creating worklets.
• Migrate historical data, which is one time and built migration process for ongoing data loads.
• Develop the code and help offshore for any issues that they face in the development.
• Co-ordination with the offshore team during testing and address the Issue’s that arise during the testing phase.
• Worked with different source systems HR Payroll, Fixed assets, Actuals etc.
• Scheduling the jobs using the CA7 Workload automation tool and Endevor

Environment: Informatica PowerCenter v 9.5.1/9.6.1 , Unix Shell Scripting, Perl Scripting, Ultra-edit, Oracle 11g, TOAD for Oracle, CA-7, DB2, QMF, NDM-Connect Direct, HP ALM, Power Exchange, Mainframe, JCL, Endevor

Confidential, CLEVELAND-OH

SENIOR DEVELOPER

Responsibilities:

• Discuss with Business Analyst to understand the business requirements.
• Create Business Process Flow diagrams showing interfaces among connected systems for each scenario in Visio and Create Source target mapping specification documents.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed, tested stored procedures in PL/SQL for Data ETL.
• Worked extensively with SQL to create ad-hoc management reports for Management Reporting using PL/SQL and SQL.
• Used PMCMD command to call / run the workflows from the ABC cycle to process all jobs.
• Worked with Mainframe sources where data is in EBCDIC format.
• Created workflows, sessions, tasks, mapping parameter, mapping variables, connections, parameter file etc. Also have knowledge on Creating worklets.
• Scheduling the jobs using the CA7 Workload automation tool and Endevor. and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Used Debugger wizard to troubleshoot data and error conditions.
• Used Power Exchange for data map creation for mainframe source.

Environment: Informatica Power Center v 9.5.1/9.6.1 , Informatica MDM, CA-7, Unix Shell Scripting, Batch Scripts, Ultra-edit,NDM-Connect Direct, TOAD for Oracle, HP ALM, Power Exchange, Mainframe, JCL, Endevor, FTP

Confidential, CLEVELAND-OH

SENIOR DEVELOPER, TECH LEAD

Responsibilities:

• Discuss with Business Analyst to understand the business requirements.
• Create the Technical architecture flow and technical design document based on the functional requirements document.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, Source Qualifier and Stored procedure transformations.
• Developed, tested stored procedures in PL/SQL for Data ETL.
• Worked extensively with SQL to create ad-hoc management reports for Management Reporting using PL/SQL and SQL.
• Created workflows, sessions, tasks, mapping parameter, mapping variables, connections, parameter file etc. Also have knowledge on creating work lets.
• Scheduling the jobs using the CA7 Workload automation tool and Endeavor. and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Co-ordination with the offshore team during testing and address the Issues that arise during the testing phase
• Scheduling the jobs using the CA7 Workload automation tool.
• Worked on implementing the types of slowly changing dimensions (SCDs) - Type I and II.

Environment: Informatica Power Center v9.5.1, Power Exchange v9.5.1, CA7, Mainframe, JCL, NDM Connect Direct, SOAP UI WEB Services.

Confidential, CLEVELAND-OH

SENIOR PROGRAMMER

Responsibilities:

• Extensively used Informatica Power center for extracting, transforming and loading data from relational sources and non-relational sources.
• ETL design based on requirements gathered while working on a cross functional project team. Administer Informatica workflows, mappings and sessions to load large data volumes from multiple sources into an enterprise data warehouse.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Testing of Informatica Sessions, Batches and the Target Data.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Performance tune ETL code in a high-volume environment.
• Research data problems discovered by QA or product support and develop solutions to the problems.
• Define/improve processes for development and support functions.

Environment: Oracle 10g, TOAD for Oracle, Informatica Power Center 8.6, Power Exchange,Windows 2003 professional, Mainframes zOS, Endevor, Infoman.

Confidential, JERSEY CITY NJ

SR. PROGRAMMER, ONSITE COORDINATOR, MODULE LEAD

Responsibilities:

• Analyzing the various components impacted and in turn their impact on the BAU process.
• Prepare a Low-Level Design Document.
• Working closely with MSSB business users during actual Conversion as well as residual sweeps.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area, which is the source for stage loading.
• Created Source definitions from Flat Files, XML files, Oracle DB, Imported/Created Target definitions and created Reusable Transformations in Shared folder.
• For Mainframe development used COBOL, CICS, DB2 and VSAM.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Created sessions, tasks, parameters, variables, shortcuts, workflows etc. Also have knowledge on creating worklets.
• Interacting with Confidential agents at Euro clear, Mexico, Canada Markets and other markets for testing with them.
• Defect logging in JIRA and tracking them to Closure.
• Coordinating with the Business Users for System test Activity
• Interacting with the Depository Trust Company (DTC) for Settlement of the DTC eligible securities.
• Preparing the user validation reports and sharing with the users.
• Responsible for getting sign-off from the Business after the Integration testing and Implementation.

Environment: Informatica Power Center v9.5, Power Exchange, CA7, Mainframe, JCL, CICS,COBOL, NDM, File Aid, Infoman,DB-2,Oracle 10g,IBM-MQ, JIRA defect tracking Tool.

Confidential, JERSEY CITY NJ

SENIOR DEVELOPER

Responsibilities:

• Working closely with CBRS business users during actual Implementation of CBRS and for Post Implementation Support.
• Analyzing the various components impacted and in turn their impact on the BAU process.
• Prepare a Low-Level Design Document.
• Extracted data from wide variety of data Sources like Legacy Systems databases, Flat files, Relational Databases and Heterogeneous sources.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area, which is the source for stage loading.
• Created Source definitions from Flat Files, XML files, Oracle DB, Imported/Created Target definitions and created Reusable Transformations in Shared folder.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Created Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
• Used COBOL, CICS, DB2, VSAM flat files for mainframe development.
• Interacting with Confidential agents at Euro clear, Mexico, Canada Markets and other markets for testing with them.
• Defect logging in JIRA and tracking them to Closure.
• Coordinating with the Business Users for System test Activity
• Interacting with the Depository Trust Company (DTC) for Settlement of the DTC eligible securities.
• Preparing the user validation reports and sharing with the users.
• Responsible for getting sign-off from the Business after the Integration testing and Implementation

Environment: Informatica Power Center v8.5/8.6, Power Exchange, Autosys, Mainframe, COBOL, JCL, NDM File Aid, Infoman, DB-2, Oracle 10g, IBM-MQ, JIRA defect tracking Tool.

Confidential

SENIOR DEVELOPER-OFFSHORE MODULE LEAD

Responsibilities:

• Analyzing the various components impacted and in turn their impact on the BAU process.
• Prepare a Low-Level Design Document.
• Working closely with Pershing business users during actual Conversion as well as residual sweeps.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area, which is the source for stage loading.
• Created Source definitions from Flat Files, XML files, Oracle DB, Imported/Created Target definitions and created Reusable Transformations in Shared folder.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used COBOL, CICS, DB2, VSAM flat files for mainframe development.
• Interacting with Confidential agents at Euro clear, Mexico, Canada Markets and other markets for testing with them.
• Defect logging in JIRA and tracking them to Closure.
• Coordinating with the Business Users for System test Activity
• Interacting with the Depository Trust Company (DTC) for Settlement of the DTC eligible securities.
• Preparing the user validation reports and sharing with the users.
• Responsible for getting sign-off from the Business after the Integration testing and Implementation.

Environment: Informatica Power Center 7.1.3, Oracle 10g, Autosys, Mainframe, JCL, NDM File Aid, Infoman, DB-2, IBM-MQ, JIRA defect tracking Tool.

Confidential

DEVELOPER

Responsibilities:

• Working closely with Prime Broker business users to get the requirements.
• Prepare a Low-Level Design Document.
• Extracted data from wide variety of data Sources like Legacy Systems databases, Flat files, Relational Databases and Heterogeneous sources.
• Developed Transformation Logic to cleanse the source data of inconsistencies before loading the data into staging area, which is the source for stage loading.
• Created Source definitions from Flat Files, XML files, Imported/Created Target definitions and created Reusable Transformations in Shared folder.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter and Sequence Generator etc.
• Used COBOL, CICS,DB2,VSAM flat files for mainframe development.
• Defect logging in JIRA and tracking them to Closure.
• Coordinating with the Business Users for System test Activity
• Interacting with the Depository Trust Company (DTC) for Settlement of the DTC eligible securities.
• Preparing the user validation reports and sharing with the users.
• Responsible for getting sign-off from the Business after the Integration testing and Implementation.

Environment: Informatica Power Center 7.1.3, Autosys, Cobol,CICS, Mainframe, JCL, NDM File Aid, Infoman, DB-2, Oracle 10g, IBM-MQ, JIRA defect tracking Tool.