SUMMARY:

• Have a total experience of 11 years in IT industry encompassing a wide range of skill sets & roles.
• Extensive work experience of 4 years in all phases of ETL - Informatica/Datastage Application development life cycle including requirement gathering, analysis, design, development, implementation, testing and support in Banking and Finance domain.
• Have 5 years of Onsite experience and worked as an ETL DW Lead & Mainframe Lead in both offshore and onshore.
• Good database skills in IBM DB2, IMS and oracle application development.
• Area of expertise include designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica Power Center 9.6.1 and IBM Infosphere Datastage 8.5 and 9.1
• Good understanding of Dimensional Modeling, Star and Snowflake Schemas and worked in complete data warehouse architecture
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Good knowledge in SQL and PL/SQL - Stored Procedures, Triggers and Functions.
• Other areas of expertise include programming skills in IBM Mainframes - ZOS using COBOL, JCL, DB2, MQ programs
• Extensively worked in various scheduling tools including Autosys, TWS and JAMS for scheduling ETL workflows and CA7 for mainframe jobs
• Widely experienced in both Agile as well as traditional waterfall lifecycle models of the project
• Quick learner with excellent analytical and problem-solving skills.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and have excellent interpersonal verbal & written communicational skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter V 9.6.1 and IBM Infosphere Datastage V8.5 and 9.1

Programming: IBM Mainframes, PL/SQL, UNIX shell scripting, COBOL, JCL, REXX, DFSort and SyncSort, Easytrieves, Stored Procedures, MQ

Database: DB2, Oracle 11g and 12c and IMS

Tools: /Utilities: Autosys, TWS, JAMS, Cyberark, Oracle SQL Developer, TOAD, Putty, FileZilla, Metadata Workbench, MDR, Visio, IBM DB2 connect, Visual Explain, IBM Data studio, HP Quality Centre, Service Now, XTND reporting tool, Jobtrac, File Manager, Platinum, CA7, SPUFI, DB2 Command Editor, BMC, STROBE, Expeditor

Versioning Tools: TFS (Visual studio), Changeman, Endevor, Clearcase, SVN

PROFESSIONAL EXPERIENCE:

Confidential, Plano, Texas

Tools: /Technologies: Oracle 11g and 12c, PL/SQL, Informatica 9.1, Toad, Unix, Autosys

• Database development, Database optimization and performance tuning
• Database design, Modelling and Migration
• Index design and tuning
• Identified and optimized SQL statements in stored procedures/reports
• Here are my previous work experience details:

Confidential, Plano,TX

ETL Informatica Lead

Responsibilities:

• Confidential is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina.
• This CODM project mainly involved designing, developing and implementing a data warehouse and various data marts that provided reporting capabilities and services to clients.
• Involved in gathering requirements from client
• Participate in architecture review sessions to provide input through framework analysis and design patterns.
• Involved in Analyze, design and develop Informatica workflows and design reviews.
• Worked on Informatica designer tools - Source Analyzer, Warehouse Designer, Mapping Designer and Mapplet Designer and did some POC for the application development.
• Worked on Data stage and developed framework (ODBC- Oracle and Oracle-Oracle) for applications with Parallel and Sequence jobs.
• Worked in Agile method of project delivery and played role of Scrum master for one Agile team
• Support client interfacing activities and help create the relevant reports in a timely manner.
• Applied slowly changing Dimensions Type 2 effectively to handle the delta loads
• Worked extensively on PL/SQL as part of the process to develop scripts to test different scenarios
• Played a key role in carrying out source data analysis, debugging and review informatica mappings and performance testing.
• Played a key role in Designing and Developing/Debugging UNIX shell scripts.
• Prepared Autosys JILs for scheduling the new workflows
• Involved in analyzing existing logical and physical data modelling with star schema techniques
• Optimizing performance tuning at mapping and session level.
• Developed several reusable transformations and mapplets that were used in other mappings
• Support the creation of ‘Go Live’ plan and manage the assigned activities in the plan.
• Onshore/offshore co-ordination
• Involved in Batch Monitoring and Problem management activities
• 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,Minneapolis,MN

Tools: /Technologies: Informatica 9.1, Oracle 11g, Mainframes, Unix, TWS, Oracle SQL Developer, IMS DB

ETL Informatica Lead & Developer

• Involved in requirement gathering and analysis of source data
• Involved in Analyze, design and develop Informatica mappings & workflows
• Prepared various mappings to load the data into different stages like Landing, Staging and Target tables
• Used various transformations like source qualifier, Rank, Router, Expressions, Sequence generator, Normalizer, Aggregator, Filter, Joiner, Lookup, Update strategy
• Worked extensively on Informatica Partitioning when dealing with huge volume of data
• Worked on DB2 and Oracle SQL queries to validate the data in both source and target databases
• Worked on TWS scheduler for scheduling ETL workflows
• Prepared the UNIX shell scripts to process the file uploads
• Involved in migrating mappings and workflows to Test and production environment
• Handled Mainframe files as the source file
• Onshore/offshore co-ordination
• Involved in Batch Monitoring and Problem management activities
• 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

Tools: /Technologies: Datastage v8.5/9.1, Mainframes, Unix, Autosys

ETL Datastage Offshore Lead & Developer

• Involved in impact analysis and High level/Low level design
• Prepared Data mapping documents
• Involved in development of ETL datastage jobs using various active and passive stages in parallel jobs using Designer
• Extracting data from sources like oracle, flat files and transforming them using business logic and loading the data to the business tables.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Worked on Autosys scheduler for monitoring the datastage jobs
• Prepared shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Involved in performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Onshore/offshore co-ordination
• Involved in Batch Monitoring and Problem management activities
• 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,Charlotte,NC

Tools: /Technologies: IBM Mainframes Z/OS, IBM DB2, CA7

Mainframe Onshore Lead

• Involved in requirement gathering and Impact analysis
• Involved in planning, estimation & HLD/LLD review for Mainframe flows
• Conducted code review and validation of all Mainframe components - batch flows, stored Procedures
• Involved in SIT, Regression and Performance testing
• Worked on CA7 scheduler for scheduling and monitoring the Mainframe jobs
• Onshore/offshore co-ordination and client Interaction
• Involved in Batch Monitoring and Problem management activities
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Prepared status reports and reviewed the test results
• Involved in end to end implementation activities and warranty support

Confidential

Tools: /Technologies: IBM Mainframes Z/OS, IBM DB2, CA7

Mainframe Offshore Lead & Developer

• Involved in impact analysis and provide optimal design solution for projects
• Involved in planning, estimation & HLD/LLD review for Mainframe flows
• Worked on creating jobs and modules using JCL, COBOM, DB2, Stored Procedures, Easytrieves, DFSORT, SYNCSORT and MQ
• Involved in SQL tuning and performance improvements
• Worked on CA7 scheduler for scheduling and monitoring the Mainframe jobs
• Involved in various phases of software development life cycle
• Involved in Batch Monitoring and Problem management activities
• Involved in code review, performance testing and Integration testing
• Offshore/onshore co-ordination

Confidential

Tools: /Technologies: IBM Mainframes Z/OS, Pacbase, DB2, IMS DB, CICS, JCL

Mainframe Offshore Developer

• Involved in job creation and modules using JCL, DB2, CICS, Stored Procedures
• Involved in preparation of test models and test data setup
• Involved in Unit testing and Integration testing
• Worked on CA7 scheduler for scheduling and monitoring the Mainframe jobs
• Involved in various phases of software development life cycle
• Involved in preparation of defect and error reports
• Offshore/onshore co-ordination