SUMMARY

• 13 years of extensive IT experience in teh Analysis, Design, Development, Testing, and Implementation of business application systems for Banking, and Insurance Sectors.
• Highly motivated IT professional wif 7+ years of experience in ETL development, Database programming and Application Programming.
• Proven experience in Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications.
• Proficiency in utilizing ETL tool Informatica Power Center 9.1.x, Informatica Power Exchange 9.1.x for developing teh Data warehouse loads wif work experience focused in Data Integration.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases, Main Frame systems (COBOL files), Oracle, DB2 UDB and Target databases Oracle, DB2, SQL SERVER 2008,Flat Files, Salesforce, Teradata 13.
• Expert skill levels in Vanilla Mainframe technologies (COBOL, DB2, JCL, IMS DB, CICS and VSAM).
• Proficiency in utilizing ETL tool Informatica Power Center 9.x for developing teh Data warehouse loads wif work experience focused in Data Acquisition and Data Integration.
• Expertise in Agile Process flow and Waterfall methodologies.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema and FACT Tables, Dimension Tables, OLTP and OLAP.
• Excellent noledge in identifying performance bottlenecks and also in tuning teh Mappings and Sessions by implementing various techniques like partitioning techniques.
• Knowledge to created Technical Architecture diagrams, HLD & LLD
• Knowledge in UNIX shells scripting and file management in various UNIX environments and noledge on Linux commands.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Work directly wif non - IT business analysts throughout teh development cycle, and provide production support for ETL.
• Experience wif general scheduling tools
• Knowledge in working in a Teradata environment
• Experience/Knowledge about Cognos reporting tools.
• Experience developing OLTP, Data Warehousing applications
• Knowledge about MDM (Master data Management)
• Experience in testing Web-based/E-commerce and Client-Server applications for industries in Financial, Banking and Insurance.
• Proven ability in working wif fast paced requirements conducting Manual and automated testing on Client-Server as well as multi-tier applications performing Integration, Functional, Regression, Performance and Stress testing.
• Good understanding of Web Application servers like Tomcat, and Websphere
• Possess strong expertise in developing COBOL/DB2 Applications, COBOL/DB2 Stored Procedures on DB2 for z/OS and Native SQL Stored Procedures on DB2 for AIX.
• Experience in Banking and Insurance & Annuities domain.
• Practical understanding of all phases of SDLC wif proven experience in successfully executing assignments of requirements gathering, estimation, design, development, testing and deployment of software systems.
• Possess strong interpersonal skills and positive attitude. Have excellent dedicated and conscientious work ethic, able to work independently or as participating member in a team environment.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.
• Excellent problem solving, communication, analytical, interpersonal skills.

TECHNICAL SKILLS

• IBM z/OS, IBM AIX, UNIX, Windows
• COBOL,PL/1,SQL,VSAM,JCL,CICS
• Informatica Power Center 9.x, Datastage and Abnitio
• DB2 for z/OS, DB2 for AIX, Oracle 11g
• DB2 Control Center, TOAD,SPUFI,QMF
• SQL*Developer, SQL * Plus, SQL Server, Teradata, SalesForce
• Microsoft Visio, MQ Series
• CA7,JobTrac,Control-M
• Lotus Notes, Microsoft Outlook Express
• HP ALM. Mange now, Pac2000
• WinSCP, Putty, MS Visio,
• Win CVS, Endevor, Changeman
• Microsoft Office tools
• Waterfall, Agile Methodologies
• Xcom, NDM, MFT, FTS, JHS
• Sort/Merge, savers, Xpeditor
• Exposure in Cognos and SSRS,SSIS,SSAS, Datastage
• JAVA, C and Eclipse.SAP
• QTP, Win runner, load runner
• Industry Application:

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Tech lead/Test Lead/Support application

Environment: IBM-z/OS, Informatica Power Center 9.1, Unix, SQL, DB2, DB2 Stored procedures, Oracle 11g, HP ALM, MS SQL Server 2008, Teradata, Teradata Utilities, IBM Data Stage, NDM, Pac2000, Redwood Cronacle schedule tool, TSO/ISPF, Cobol, JCL.

Responsibilities:

• Follow teh Agile Process flow and methodologies of SAER project
• Working wif Business Team for Requirement Gathering, Analysis and impact analysis
• Preparing functional documentation and participate in reviews.
• Coordinating wif cross commits to finalize teh data sourcing / mapping.
• Participated system design and documentation of mapping specs as per business rules
• Involved in teh Review of Requirements and development of unit test case documents.
• Participated in ETL profiling process
• Performed major role in understanding teh business requirements and designing and loading teh data into target tables.
• Analyzing teh source data and deciding on appropriate extraction, transformation and load strategy.
• Designing teh ETL process and defining teh strategies for data loads of type1/type2/type3
• Developed number of Complex ETL mappings to load data into Dev/QA and Data warehouse target.
• Worked extensively on SQL Query Tuning.
• Developed applications using Teradata utilities, UNIX scripts and maintenance of ETL applications
• Developed stored procedures for complex logic to Extractions for customer data.
• Extract data from SAP source and loading in to target tables.
• Consistently interacting wif project stakeholders/Business Team for updating project task status on ongoing basis.
• Coding and testing stored procedures.
• Maintain traceability from requirements in order to design to test results
• Created Deployment list and Deployment group and migrate code to QA.
• Fix teh defects and flow teh QA process.
• Incorporated teh ETL logic in mappings to update different databases of Oracle and Sqlserver 2005 using flat files, Oracle and Sqlserver 2008.
• Responsible for SIT and facilitating UAT wif business team along wif client’s lead business analysts.
• Create test case, test Specification and test reports and execute test specs and document teh results.
• Created teh reusable transformations for better performance.
• Identify and resolved teh performance issues in Extract SQL queries for quick data retrieval.
• Production support for install mappings.
• Done Code reviews and validated teh mappings.
• Designed teh Cronacle jobs and schedule of workflows for daily and Monthly loads.
• Update S2T document wif as per Confidential Standards.
• Completed Unit testing and System testing wif test cases and test plans.
• Extensively worked on test data preparation, test case execution and bug reporting using Quality Center.
• Resolved production Abends and monitor teh daily batch jobs.
• Communicate business any delays in batch run and missing data from source.
• Validate source and target data after batch run.
• Prepare daily status report and send to managers.

Confidential, St. Paul, MN

Sr.ETL/Informatica developer

Environment: Informatica Power Center 9.1, Informatica MetaData Manager, informatica Could Services (ICS), DB2, UC4, Rally, Oracle 11g, SSRS, SAP, SharePoint, MDM, VSAM, Flat files, MS SQL Server, Unix, Salesforce, Teradata, Microsoft Office tools

Responsibilities:

• Follow teh Agile Process flow and methodologies G360 project
• Participated in legacy G360 system analysis design and documentation of mapping specs as per business rules
• Involved in teh Review of Requirements and development of unit test case documents.
• Participated in Gap Analysis and impacted analysis
• Participated in ETL profiling process
• Performed major role in understanding teh business requirements and designing and loading teh data into Landing to office line (Tablets) and Salesforce (online).
• Analyzing teh source data and deciding on appropriate extraction, transformation and load strategy.
• Designing teh ETL process and defining teh strategies for data loads of type1/type2/type3
• Developed number of Complex ETL mappings to load data into Dev/QA and Staging and Data warehouse target.
• Developed stored procedures for complex logic to Extractions for IUG data.
• Extract data from SAP source and loading in mobile prep and offline.
• Developed ETL mappings to load data into Salesfoce and offline Tablets of different databases.
• Analyzed Source system functionality Identifies and logs issues and perform regression testing.
• Maintain traceability from requirements in order to design to test results
• Created Deployment list and Deployment group and migrate code to QA.
• Extensively used Java and Custom transformations to handle complex scenarios of Informatica
• Fix teh defects and flow teh QA process.
• Incorporated teh ETL logic in mappings to update different databases of Oracle and Sqlserver 2005 using flat files, Oracle and Sqlserver 2008.
• Create test case, test Specification and test reports and execute test specs and document teh results.
• Created teh reusable transformations for better performance.
• Identify and resolved teh performance issues in Extract SQL queries for quick data retrieval.
• Production support for install mappings.
• Done Code reviews and validated teh mappings.
• Designed teh UC4 jobs and Job plans schedule of workflows for Monthly loads.
• Update S2T document wif as per Confidential Standards.
• Completed Unit testing and System testing wif test cases and test plans.
• Manage day-to-day testing activities and reviews
• Resolved issues in system testing effectively.
• Run teh scripts to migrate teh date from one server to another severs.

Confidential (NDX), Minneapolis, MN

ETL/Informatica Development/Testing

Environment: menformatica Power Center 9.1, Datastage,Oracle 11g, MS SQL Server, Unix, DB2, Flat files

Responsibilities:

• Involved in teh Review of Requirements and development of Technical Design documents.
• Participated in Gap Analysis and impacted analysis
• Analyzing teh source data and deciding on appropriate extraction, transformation and load strategy.
• Designing teh ETL process and defining teh strategies for data loads of type1/type2/type3
• Developed number of Complex ETL mappings to load data into Staging and Data warehouse target.
• Developed joiner, union and lookup transformations and developed stored procedures for complex logic to calculate group, category scores and Extractions for Enterprise Level Fact table.
• Developed ETL mappings to load data into heterogeneous application of different databases.
• Analyzed Source system functionality Identifies and logs issues and perform regression testing.
• Maintain traceability from requirements in order to design to test results
• Incorporated teh ETL logic in mappings to update different databases of Oracle and Sqlserver 2005 using flat files, Oracle and Sqlserver 2005.
• Create test case, test Specification and test reports and execute test specs and document teh results.
• Created teh reusable transformations for better performance.
• Identify and resolved teh performance issues in Extract SQL queries for quick data retrieval.
• Production support for install mappings.
• Done Code reviews and validated teh mappings.
• Designed teh schedule of workflows for Monthly loads.
• Creating test cases for Informatica mappings and design documents for production support.
• Completed Unit testing and System testing wif test cases and test plans.
• Manage day-to-day testing activities and reviews
• Resolved issues in system testing effectively.
• Run teh scripts to migrate teh date from one server to another severs.

Confidential, Minneapolis, MN

Sr.Systems Analyst.

Environment: meBM-z/OS, Informatica Power Center 8.5, Unix, COBOL, JCL, SQL, DB2 z/Os, DB2 UDB, DB2 Stored procedures, Oracle 11g, HP ALM, DB2 DRDA, Eclipse, Informatica Power Center 8.5.x, MS SQL SERVER 2008.

Responsibilities:

• Involved in teh Review of Business Requirements and development of System design documents and Technical Design documents.
• Analyzing medium/complex transformations in ETL using Informatica
• Participated in Gap Analysis.
• Involved in coding teh DB2 Stored procedures and testing stored procedures various formats wif front end team.
• Swift Mapping changes.
• Analyzing Workflows, Worklets and Sessions to transport teh data to target warehouse tables using Informatica Workflow Manager
• Participated and co-ordinate specification reviews, Code reviews and test case walkthrough’s wif Confidential Technology team.
• Involved in unit testing, system and UAT testing.
• Prepared Unit Test plans and Unit Test case and test scripts for teh Electronic window and Base efforts.
• Participated in ET test support.
• Provide Daily status report, check list documents and weekly status reports to teh Project Manager.
• Written/Modified new COBOL - DB2 applications, Stored Procedures to meet teh end consumer requirements.
• Actively worked on many production issues.
• Extensively worked on test data preparation, test case execution and bug reporting using Quality Center.
• Code deployment between DEV/QA/Prod
• Production Support, Maintenance and enhancements

Ameriprise Financial Inc, Minneapolis, MN

ETL/Informatica Lead

Environment: Informatica Power Center 9.1.x, Informatica Power Exchange, Unix, ORACLE 11g, UNIX, JAVA, Eclipse, MS SQL SERVER 2008,HP ALM, SQL Server Integration services (SSIS),MS SQL Server 2008, Salesforce Distribution Channel,Teradata 13,COBOL, JCL, SQL, DB2 z/Os, DB2 UDB, SPUFI, CHANGEMAN, DB2 Stored procedures .

Responsibilities:

• Requirements gathering and analysis, preparing System Requirement Specification documents from User Requirement Specifications.
• Worked on Business rules - Data mapping and transformation exercises.
• Worked wif teh project architects in solutioning and tooling decisions.
• Worked wif business analysts for requirement gathering, business analysis, and translated teh business requirements into technical specifications to build teh Operational Data Store.
• Developed mainframe COBOL-DB2 applications, DB2 Stored Procedures.
• Involved in teh development of teh conceptual, logical and physical data models.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked wif Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport teh data to target warehouse tables using Informatica Workflow Manager.
• Developed UNIX shell scripts using PMCMD utility and scheduled ETL load.
• Identified performance issues in existing sources, targets and mappings by analyzing teh data flow, evaluating transformations and tuned accordingly for better performance.
• Worked on environmental setup and planning.
• Involved in Peer Review, Code Review, and Design Review.
• Developed Master Test Plan, involved in preparing test cases and test scenarios.
• Interact wif third party vendors to facilitate and ensure test activities are on track.
• Ensure test activities are as per plan and highlight possibility of delay or slippage to plan for contingency.
• Defect logging, tracking, and follow up for closure.
• Attend defect review meeting wif vendors to decide on defect priorities for resolution and fixing.
• Interaction wif Client for Project and Test Status updates.
• Responsible for creating Test cases and Test scripts based on functional requirements and design documents.
• Involved in different phases of testing like teh Business Functionality Testing, Unit Testing, Integration Testing, Performance Testing, Regression Testing, Positive Testing, Negative Testing and UAT.
• Involved in executing basic UNIX and Linux commands to start and stop Tomcat servers.
• Represent changes in CAB and Tech review and production walk through get all required approvals for install.
• Providing answers to business queries.
• Working directly wif Implementation Managers and Account Managers on Existing Client Corporate Actions
• Create compliance extracts and audit extracts and send it to business for review.
• Preparation of install plan and back out plan and get all business and VP approvals before install.
• Involved Installation and Tech validation and Maintenance support
• Followed teh quality procedures for all teh deliverables
• Involved in teh Review of Business Requirements and development of System design documents and Technical Design documents
• Involved in coding teh DB2 Stored procedures and testing stored procedures various formats wif front end team.
• Involved in teh development of Check Conversion for ARP and handled several base funded effects.
• Participated and co-ordinate specification reviews, Code reviews and test case walkthrough’s wif Confidential Technology team
• Involved in unit testing, system and UAT testing
• Prepared Unit Test plans and Unit Test case and test scripts for teh Check Conversion, Electronic window and Base efforts.
• Participated in ET test support.
• Provide Daily status report, check list documents and weekly status reports to teh Project Manager.

AMEX

Application Developer

Environment: COBOL, Eclipse, DB2, SQL, SPUFI, DB2 File Aid, DB2 Stored procedures, CICS,IMS DB,VSAM, QMF and JCL.

Responsibilities:

• Provided many reliable and effective bug fixes for teh job abends.
• Met Service Level Agreements for teh critical job failures.
• Suggested solutions for improving teh system performance and executed.
• Involved in teh Review of Business Requirements and development of System design documents and Technical Design documents.
• Analyzed existing programs and responsible for preparing Analysis & Design document.
• Modified existing programs using COBOLE, DB2 as per teh Requirement and Design specifications.
• Participated and co-ordinate specification reviews, Code reviews and test case walkthrough’s wif American Express Technology team.
• Coordinated wif teh Onsite Team at Phoenix, USA and involved in Requirements gathering, Analysis, and Design meetings wif all teh business people.
• Participated in Code and test cases reviews.
• Participated in coding and testing online and batch programs.
• Prepared test JCL’s for batch programs.
• Followed teh Method one quality procedures for all teh deliverables
• Involved in unit testing and system testing and documentation