SUMMARY

• Over 16 years of experience in Information Technology in Analysis, Design and Development of software applications wif expertise in Data warehouse ETL tools Datastage 7.5.1A/7.5.2/8.0/8.7.1/11.5,
• Informatica PowerCenter 9.0.1, Pentaho
• Over 6+ years of experience in Microstrategy reporting tools and data mart.
• IBM Certified Solution Developer - WebSphere IIS DataStage Enterprise Edition V7.5
• Ten years of strong experience in designing and developing DataWarehousing, Decision Support Systems using ETL tools Datastage.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using tools Datastage 7.5.1A/7.5.2/8.0/8.7.1
• Knowledge of full life cycle development for building a data warehouse.
• Strong knowledge of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Experience in developing Entity-Relationship diagrams, Logical and Physical Data Models, and teh use of Data modeling tools.
• Experience in using Oracle 11g/10g/9i/8i/7.x, MS SQL Server, PL/SQL, SQL Loader, TOAD, Erwin 4.0/3.5.2, Unix Shell Scripts, and HTML 4.0.
• Extensive experience in using highly scalable parallel processing infrastructure using Datastage Enterprise Edition.
• Expert in writing, testing and implementing triggers, functions and procedures at database level using PL/SQL.
• Experienced in incorporating various data sources like Oracle, MS SQL Server, DB2, Teradata, XML and flat files into teh staging area.
• Experienced in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Expertise in data migration projects wif (target - source) same database as well as wif heterogeneous databases.
• Dynamic, alert, and capable of producing high quality work under time constraints.
• Excellent communication and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer

Responsibilities:

• Analyze functional and technical requirements, data from different sources and create system design and specifications in Power Designer.
• Analyze vendor source files, create source to target mapping document and transformation rules based on teh requirements and load into various target and error tables.
• Define and develop program logic based on business requirements and create ETL jobs using Datastage to extract teh data from different sources, transform teh data and load into teh target database (ADW).
• Convert server ETL jobs to parallel and migrate them from Datastage 8.5 to 11.5.
• Develop unit test cases, test teh ETL jobs and assist in end to end testing.
• Automate and monitor ETL jobs for successful transfer of teh files to teh vendor location and vendor files back to client location.
• Analyze error reports and fix teh data for any issues.
• Support successful migration of teh jobs across different environments i.e., Development, test, stage and production.

Environment: Datastage 11.5, PL/SQL, Oracle, Power Designer, Visio, GitHub, Liquibase, Agile/Scrum technologies, OLAP, AWS

Confidential

Sr. Data Analyst

Responsibilities:

• Modify existing Teradata queries against teh EDW and develop new queries as needed. Run teh queries for Finance and train them to become self - sufficient wif teh EDW.
• Define and develop a process for uploading manual journal entries from Finance into teh iMart.
• Analyze a large number of Actuarial reports dat access teh IDW and identify equivalent Highmark data in teh AIW. Write queries to retrieve AIW data and merge teh result sets to create consolidated reporting from both warehouses.

Environment: Teradata, SAS, MS Access Database, MySQL Project Title - UHIG

Confidential

Sr. Data Analyst

Responsibilities:

• Created high - level requirement documents, data dictionary, table structure and data flow diagrams for two of teh UHIG projects.
• Developed ETL jobs using Pentaho and Datastage to load data to teh Optum Cloud environment.
• Involved in unit testing of teh jobs and creation of customized reports for teh business users.

Environment: Amazon AWS, MySQL, Visio, Pentaho, Datastage, Teradata, UDB Project Title - Transparency Initiative

Confidential

Sr. Data ETL Develope

Responsibilities:

• Performing several critical functions to bring a non - profit website in teh health care sector to market. Specific roles include Senior ETL Developer creating source reference data tables to support teh primary application API services
• Data Architect designing and creating data flow diagram.
• Senior Data Analyst creating an underlying SAS code flow chart as well as supporting data requirements and data validation strategy
• UAT Tester executing UAT test scripts and documenting results and/or defects.
• Teh data types involved include medical and pharmacy claims data, health plan eligibility/membership and rigorous data models and quality validation process definition and development

Environment: Datastage, Pentaho, Amazon AWS, JSON, MySQL, Visio, Teradata, UDB Project Title - Data Operations

Confidential

ETL Developer

Responsibilities:

• Using Pentaho Data Integration (PDI), create data loads for teh eligibility and claims data used for analyzing consumer health behavior.
• Develop ETL jobs to load teh data for different client implementations like roster files, client specific activities, and health screening data and eligibility, medical, pharmacy claims.

Environment: Pentaho Data Integration (PDI), Data stage ETL, Oracle, DB2, MySQL, SQL, PL/SQL, MS SQL Server, Toad 9.1.2, MS Office, XML Sources, Stored Procedures, Shell Scripting, Subversion, Teradata. Project Title - Data Services

Confidential

InfoSphere Administrator/Developer

Responsibilities:

• Installed Datastage in various environments like development, test and production.
• Developed ETL jobs to migrate data from DB2 to various databases like Oracle, MySQL, Netezza using InfoSphere 8.7.1
• Created shell scripts to support ETL jobs. Support teh migration of teh ETL jobs from development to test to production.

Environment: InfoSphere 8.7.1, MySQL, DB2, UDB, Oracle, Netezza Project Title - Data Operations

Confidential

ETL Developer

Responsibilities:

• Perform source system analysis and design mapping logic between source systems and teh operational data store and data warehouse. Additionally, assist wif teh development of data models for teh data warehouse. Technologies include Pentaho and MySQL.
• Analyze and understand data sources and end - user requirements to deliver ETL solutions for managing data. Also, work wif information delivery and business owners to understand business needs and to analyze and clarify information related requirements.
• Develop and maintain technical specifications, high-level designs and end-user documentation of assigned projects and analysis.
• Support solutions through teh entire development lifecycle including system testing, bug fixes, performance tuning and production support.
• Work wif information delivery and business owners to understand business needs and to analyze and clarify information related requirements
• Assist wif teh development of teh data models for teh data warehouse guided by teh data warehouse architect.
• Using Pentaho Data Integration (PDI), created data loads for teh eligibility and claims data used for analyzing consumer health behavior.
• Developed ETL jobs to load teh data for different client implementations like roster files, client specific activities, and health screening data and eligibility, medical, pharmacy claims.
• Developed in-house tools to analyze and dissect teh claims data which greatly halped teh management team wif analysis of teh clinical, operational and financial data.
• TEMPEffectively documented all Development work done.

Environment: Pentaho Data Integration (PDI), Data stage ETL, Oracle, DB2, MySQL, SQL, PL/SQL, MS SQL Server, Toad 9.1.2, MS Office, XML Sources, Stored Procedures, Shell Scripting, Subversion Project Title - ACDR - CCDM Migration

Confidential

ETL Developer

Responsibilities:

• Involved in teh ETL architectural design and teh preparation of teh technical specs based on teh business requirements and high interaction wif teh business users
• Actively interacted wif teh Data Modelers, Data Analysts and Business Users to gather verify and validate various Business Requirements.
• Proper guidance has given to teh team to follow teh coding standards and delivered teh work on time in a systematic manner.
• Extensively used Datastage, Stored Procedures and Shell Scripts.
• Developed ETL mapplets and transformations using Informatica PowerCenter 9.0.1.
• Followed Datastage recommended Standards and Best Practices to improve Performance of ETL mappings.
• Involved in creating Naming Standards, Best Practices for ETL development.
• Extensively used Datastage 7.5.1A/7.5.2/8.0 to extract data from mainframes and load it into DB2.
• TEMPEffectively documented all Development work done
• Monitored and improved query performance by creating views, indexes, hints, explain plan and correlated sub queries.
• Reviewing teh ETL process design & ETL design documents wif teh business analysts, end users, data quality team and enterprise test team.
• Wrote Unix Shell Scripts to perform several operations on text files.
• Did teh unit testing and mainly involved in teh integration testing.
• Created teh deployment groups and migrated in teh migration of teh coding into different repositories.
• Prepared teh documentation templates for teh team and prepared teh documentation for my coding.
• Using SQL, PL/SQL wrote queries to understand teh data and get

ETL Developer

Responsibilities:

• Gather business requirements through Business Clients' interviews and sessions
• Conduct controlled brainstorming sessions wif project focus groups
• Facilitate collection of functional requirements from system users and preparation of business requirement.
• Analyze and prioritize Business requirements
• Prepare Business Requirement document (BRD) containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh actors to analyze and document business data requirements.
• Develop Functional specification document Create Use Case Diagrams and Sequence Diagrams using Visio
• Extensively used Datastage 7.5.1A/7.5.2/8.0 to extract data from mainframes and load it into DB2.
• Developed teh front end application using Datastage ETL, Java, J2EE, Hyperroll
• Develop system test plan and test cases, execute system testing and report teh defects using Test Director
• Create and manage Requirements Traceability Matrix (RTM) to manage teh change process TEMPeffectively.
• Perform Impact analysis wif Business process changes
• Prepare weekly project status report and report teh status to Project Manager and all teh stake holders
• Conduct training sessions to familiarize users wif system. Analyze potential risks, their impact and create Business continuity plan
• Create project development plan and Oversee project development to make sure dat teh project is delivered on time and wifin teh budget.
• Help offshore wif Issue resolution

Environment: Data stage ETL, Microstrategy, Oracle, DB2, SQL, PL/SQL, MS SQL Server, Toad 9.1.2, and Quality centre, MS Office, XML Sources, Stored Procedures and Shell Scripting, Teradata Project Title - USAA - E - Commerce IMCO Application Development

Confidential

ETL Developer

Responsibilities:

• Gather business requirements through Business Clients' interviews and JAD sessions
• Conduct controlled brainstorming sessions wif project focus groups.
• Facilitate collection of functional requirements from system users and preparation of business requirement.
• Analyze and prioritize Business requirements
• Prepare Business Requirement document (BRD) containing teh essential business elements, detailed definitions, and descriptions of teh relationships between teh actors to analyze and document business data requirements.
• Develop Functional specification document Create Use Case Diagrams and Sequence Diagrams using Rational XDE
• Used USAA specific Action framework to generate user interfaces.
• Develop ETL jobs using Datastage for migrating teh data.
• Developed HTML forms & client side validation using JavaScript.
• Developed presentation tier as HTML, JSPs using Action Framework.
• Developed JSP pages for teh presentation utilizing JSP custom tags.
• Used WAS 5.1 to develop and code teh Java Program.
• Administrating teh Websphere Server environment which involves deploying teh codes and monitoring teh JVMs.
• Develop system test plan and test cases, execute system testing and report teh defects using Test Director
• Analyze potential risks, their impact and create Business continuity plan
• Create and manage Requirements Traceability Matrix (RTM) so as to manage teh change process TEMPeffectively
• Help offshore wif Issue resolution

Environment: Data stage ETL, Microstrategy, Oracle, DB2, SQL, PL/SQL, MS SQL Server, Toad 9.1.2, and Quality centre, MS Office, XML Sources, Stored Procedures and Shell Scripting. Project Title - USAA - E - Commerce Application Development

Confidential

Application Developer

Responsibilities:

• Create teh Architecture Design Develop teh Detailed Design
• Used USAA specific Action framework to generate user interfaces.
• Developed HTML forms & client side validation using JavaScript.
• Developed presentation tier as HTML, JSPs using Action Framework.
• Developed JSP pages for teh presentation utilizing JSP custom tags.
• Develop ETL jobs using Datastage for migrating teh data.
• Used WAS 5.1 to develop and code teh Java Program.
• Used IBM MQ series for creating notifications and foldering of documents asynchronously.
• Worked on teh implementation of MQ Clusters.
• Administrating teh Websphere Server environment which involves deploying teh codes and monitoring teh JVMs.
• Development and Code reviews
• Unit Test planning and Execution
• Implementation
• Help offshore wif issue resolution

Environment: Data stage ETL, Microstrategy, Oracle, DB2, SQL, PL/SQL, MS SQL Server, Toad 9.1.2, and Quality centre, MS Office, XML Sources, Stored Procedures and Shell Script

TECHNICAL SKILLS

Skill Level: Data Analyst:

Unspecified: Data Migration:

Unspecified: database:

Unspecified: Database Modeling:

Unspecified: Data Model:

Unspecified: Data Modeling:

Unspecified: Data Models:

Unspecified: db2:

Unspecified: Microsoft Access:

Unspecified: MS Access:

Unspecified: MS SQL Server:

Unspecified: SQL Server:

Unspecified: MySQL:

Unspecified: Oracle:

Unspecified: Oracle 11i:

Unspecified: PL/SQL:

Unspecified: SQL:

Unspecified: Stored Procedures:

Unspecified: Sybase:

Unspecified: UDB:

Unspecified: Data Integration:

Unspecified: Data Mart:

Unspecified: Data Sources:

Unspecified: Datastage:

Unspecified: Enterprise Resource Planning:

Unspecified: ERP:

Unspecified: ETL:

Unspecified: Informatica:

Unspecified: Metadata:

Unspecified: Online Analytical Processing:

Unspecified: OLAP:

Unspecified: Operational Data Store:

Unspecified: Power Bi:

Unspecified: Reference Data:

Unspecified: Snowflake Schema:

Unspecified: Star Schema:

Unspecified: Teradata:

Unspecified: Data Quality:

Unspecified: Data Validation:

Unspecified: Integration Testing:

Unspecified: QA Testing:

Unspecified: Load Runner:

Unspecified: Test Plan:

Unspecified: UAT:

Unspecified: Unit Test:

Unspecified: Unit Testing:

Unspecified: Usability:

Unspecified: Amazon Web Services:

Unspecified: AWS:

Unspecified: Ascential:

Unspecified: Powercenter:

Unspecified: API:

Unspecified: Application Development:

Unspecified: Coding:

Unspecified: Hive:

Unspecified: HTML:

Unspecified: JavaScript:

Unspecified: JSON:

Unspecified: Reporting Tools:

Unspecified: Scripting:

Unspecified: Subversion:

Unspecified: Visio:

Unspecified: XML:

Unspecified: Gather Business Requirements:

Unspecified: Project Development:

Unspecified: Project Manager:

Unspecified: SCRUM:

Unspecified: Microsoft SSRS:

Unspecified: SSRS:

Unspecified: Microstrategy:

Unspecified: Pentaho:

Unspecified: SAS:

Unspecified: Data Warehouse:

Unspecified: Data Warehouse Etl:

Unspecified: Data Warehousing:

Unspecified: IIS:

Unspecified: networking:

Unspecified: Apache:

Unspecified: Shell Scripting:

Unspecified: Shell Scripts:

Unspecified: Solaris:

Unspecified: unix:

Unspecified: Unix Shell:

Unspecified: UX:

Unspecified: Dimensional Data:

Unspecified: erwin: