SUMMARY:

• Results-driven ETL Computer Programmer/Data Warehouse Analyst professional in BIDW Business Intelligence development projects with first-rate skills in analyzing full cycles for complex, multi-site projects and initiatives with expertise of agile methodologies.
• 8 years of ETL programming experience in Banking/financial domains serving at all levels of SDLC as Lead Senior Programmer.
• Thorough understanding of IT industry systems organization and architecture with a focus on Financial/Retail banking domains.
• Thorough understanding of the SDLC with proficiency in mapping client's requirements, Code development, quality assurance, integration testing and trouble shooting for complex information systems management in Financial/Retail banking domains.
• Strong communication, collaboration team building skills with proficiency at grasping new technical and functional environments straight off leveraging the same for bringing in successful project accomplishment with the satisfaction of all stakeholders.
• Proven ability to deliver substantial revenue, productivity and quality improvements through well-managed, on-time projects.
• Developed ETL code, conducted end-to-end UT/UAT testing for several successful project releases.
• Served as a point of contact for the Business, Solution Development and Testing Teams, and coordinated multiple teams at onsite and geographically dispersed multiple offsite locations.

FUNCTIONAL TECHNICAL COMPETEN CIES:

Project Types:

Application Development, Application Enhancement, Ado Business Support, Production Support, Maintenance, Migration, Project Management, performance improvement and QA Testing.

Job Functions:

Business Requirement Elicitation, Requirement Analysis Design , Business Presentations, Code Development with ETL Programming, Quality Assurance, Project Tracking Status Reporting, Release Management ,Internal Audit Onsite/Offsite Teams Coordination Training Development L2 Support

Technologies:

Tools Abinitio 2.16, Informatica, HP Quality Centre, Toad, Bartizan, VIPER, ITSM BMC Software , MS Office tools.

Database Technologies DB2, Oracle 9i/10g, Terawatt.

Version Control PVCS, Abinitio EME.

Operating Systems - UNIX, Windows 2000/ XP and NT.

Scheduling Tools TWS Browser, Control-M and Autosys.

Work Summary

Confidential

Development Lead/BAU

Responsibilities:

• Understanding business requirements.Create high level/detailed ETL design documents, conducting detailed ETL technical Design review with management, business stakeholders.
• Coding ETL Programs with tools Abinitio /Informatica/Unix/DB2 and make sure code meets exact business requirements and delivers as per business expectations.
• Co-ordinate with source project teams and get desired facts to perform end to end Unit testing of ETL code. Debug any identified problems during Unit testing phase.
• Deliver the code to QA team and make fresh data available to them for IST Integrated system testing to make sure new functionality is as expected and there is no impact to other existing functions.
• Resolve any valid defects/concerns raised by QA team and provide a code fix if necessary.
• Run ETL code and make fresh data available to Users/Stakeholders to perform UAT User Acceptance testing and support them for entire UAT period to resolve any concerns.
• Consolidate Users/QA sign-offs and create ITSM requests for 'production code deployment'.
• Support Production Team during code deployment process and make sure the 'first run' is successful.
• Support production team with any queries for next 30 days warranty period .
• 24 7 Production support on-call person for 2 weeks in a month.

Environment: Abinitio , Informatica, UNIX, PVCS, DB2, HP Quality Center, ITSM

Confidential

BAU Lead

Responsibilities

• BAU refers to Business as Usual BAU team's function is to make sure that on adhoc basis permanent fixes are provided to the processes which are frequently failing in production environment with different execution errors.
• Leading a BAU team, which analyze all production issues occurring over a week's period and provides permanent fixes to these processes with every weekend implementation.

Project Type: Requirement Gathering/Code Development/Implementation/UAT/Production on-call support

Confidential

ETL Lead/L2 Support

Responsibilities:

• Worked as a support team member for CMLS project.
• Handled several critical applications, which involved Monthly Billing generating/sending Invoices to all Banks across Globe using 'Visa Gateway' for Credit Cared Transactions .
• Involved in hadling some of the most critical application for example- Billing/Asia Pacific Region support/Visa Europe Customers/Clearing and Settlement/Verified by Visa etc. Some of the applications had SLA service level Agreement of as critical as 30 minutes.
• Supported end Users/Production environment for all assigned subject areas, which involved 24 7 on-call, support person for a week each month, rest of the days it was normal schedule .
• Provided fix to all production issues while handing the support activities, it involves every fix independent of effort hours.

Environment: Abinitio 2.16, UNIX, DB2, VIPER, Mainframe

Confidential

Responsibilities:

• Understanding business requirements.
• Create high level/detailed ETL design documents, conducting detailed ETL technical Design review with management, business stakeholders.
• Coding ETL Programs with tools Abinitio /Unix/DB2 for bimonthly project releases and make sure code meets exact business requirements and delivers as per business expectations.
• Deliver the code to QA team and make fresh data available to them for IST Integrated system testing to make sure new functionality is as expected and there is no impact to other existing functions.
• Resolve any valid defects/concerns raised by QA team and provide a code fix if necessary.
• Run ETL code and make fresh data available to Users/Stakeholders to perform UAT and support them for entire UAT period to resolve any concerns.
• Support Production Team during code deployment process and make sure the 'first run' is successful.

Confidential

Responsibilities:

• As an application primary for the Global Member Billing system GMBS application, this focuses on Enterprise Application Integration EAI and Extract Transform and Load ETL to data marts, my roles involved-
• Provide Level 3 support, investigate any application execution failure and take immediate corrective steps to recover the application and prevent any repeat failures and there by avoid business impact.
• Handling Primary Responsibility for GMBS, so My role is to handle any Application related Issues like Job failures, Incorrect Data for a particular field, Data Load Issue, also monitor performance of a job, Execution time, Turn around time and make sure that jobs are done within the SLA Service Level Agreements .
• Solving Incidents within the SLA and also find the root cause of the issue and provide the fix.
• Since this is billing system of VISA, there are usually a lot of queries to get the transaction details for particular service/charges. Resolve those critical queries by finding detail transaction and explain them the charges. It is time critical and requires considerable amount of work to provide the data.
• Developing UNIX shell scripts, which are used for validation purpose and to call the Ab-Initio graphs.
• Identifying the issues in Ab-Initio Graphs/Unix Shell scripts/Mainframe JCL scripts.
• Develop/enhance new functionalities for the supported application.
• Attend system design walkthrough sessions, providing recommendations and solutions.
• Performance tuning of the application SQL to reduce the resource utilization and time of execution.
• Involved in creation of proper test data, where applicable, to satisfy all required test cases and performed unit testing on all deliverables also was part of the code review team.
• Ensure zero defect deliveries.
• Involved in Unit Testing of the code-fix in Ab-Initio, DB2/Unix Script/JCL Script.
• Participating in peer-review process of the code-fix for the quality of deliverables.

Project Type: Requirement Gathering design/Implementation ETL Solution, quality Assurance, Production deployment.

Confidential

ETL Programmer/QA Testing Lead

Responsibilities:

• Client interfacing for requirement gathering, issue management, and testing life cycle monitoring.
• Process improvement and data modeling for CDCI vertical
• Client addition, interface addition, new extract creation and Data model changes in CDCI Consumer data customer Insight warehouse.
• Implementing compliance projects like PCI
• Analyzed business and functional requirement, working closely with business and technology leads to identify appropriate data for testing and design of quality system test cases.
• Developed and reviewed test cases using, managed testing team while leading QA team as a module lead.
• Managed RTB Run-to-Build Changes team which had the responsibly of consolidating all the changes code changes every week, which support team did while performing support activities and incorporating the same in Development/QA environments in order to keep the code in sync across all applications and each environment development, QA and Production.

Environment: Abinitio , EME, UNIX, Oracle9i/10g, Autosys.