SUMMARY

• Seasoned Senior ETL resource experienced in analysis, Modeling, architecture, designing and building Data Warehouses, Data Marts and OLAP applications for Insurance Industry and Healthcare applications on Oracle, Teradata and DB2 Platform.
• Close to 9 years of good hands-on experience on Data Architecture, Data Modeling and ETL development using IBM DataStage Suite IIS Version 9.1, 8.7/8.5 7.5.2, DataStage Parallel Enterprise Edition, DataStage Server Edition, PL/SQL Programming for Oracle 11g, Teradata, Unix Shell Scripting, Perl Scripts, Erwin Data Modeler and working knowledge on Multiple Job schedulers.
• Hands on experience in creating OLAP Cubes, Facts, dashboards and reports.
• Skilled in various large-scale databases such as Teradata V2R5/V2R6/12 Teradata Administrator, Teradata Manager, Query man, BTEQ, TPT scripts, Fast Load, Multi Load, Fast Export, Teradata SQL, Database Query Manager .
• Expertise in Integration of various data sources like Teradata, DB2 UDB, Oracle 11g/10g/9i and SQL Server.
• Working as Data Warehouse ETL Solution Architect for building and maintaining a large scale Enterprise Data Warehouse Dimensional Modeling and Data Marts to hold the entire clinical data of Cigna Healthcare with size of 40 TB.
• Proud member and technology expert in Health Care - Enterprise Information Management Domain EIM-HC of Cognizant Technology Solutions USA whose primary focus is on providing consulting and Technology solution for Data warehousing and Business Intelligence needs of Healthcare majors across USA. Fortune 100 Clients I have worked so far include Cigna, UHG, and Aetna.
• Winner of Best Project Award - First Time Manager for exhibiting team Management skills and leadership skills leading towards successful implementation of a Data Warehouse Migration project.
• Winner of Cigna Champion Award - Awarded by Cigna Healthcare as a recognition for outstanding contribution on leading an ETL development team towards successful implementation of a Multi-million dollar project.
• Have played multiple roles like Data Warehouse solution Architect, DataStage ETL lead, Business Analyst, Healthcare Enterprise Warehouse System Analyst and Production support team member in my 8 years of software career.
• Result oriented candidate who considers continuous process and performance improvement as the Buzz word to achieve success in this highly competitive IT Industry.
• Sound knowledge of entire SDLC process on both waterfall model and agile methodology ranging from publishing BRDs until preparing Run books and Production handouts for Production Support team.

DATA MODELING AND DATA WAREHOUSE ARCHITECTURE SKILLS

• Hands-on knowledge of Data warehousing ETL and OLAP reporting tools, methodologies, 3NF Dimensional modeling, Solution architecture, Technical architecture, Data Profiling, Data cleansing technologies, Metadata Management and testing strategies.
• Data Modeling based on E-R Modeling and Dimension Modeling using CA Erwin 4.3
• Playing the role of Data Integration Specialist Consultant for past 5 years at Cigna Healthcare.
• Have done star-schema based model for Customer Centric Data Repository that holds the entire Client info including, Members, Client Structure, Product, enrollments, claims, Lab and programs data.
• Creation of Star-schema Data warehouse models, designing Data Marts, Dimension Tables, Fact tables, reference tables, Managing Slowly Changing Dimensions and in short Modeling of Warehouse and marts using combination of Ralph Kimball and Bill Inmon's Methodology.
• Experienced in creation of Logical and Physical Data models, Master Data Management, Data Dictionary Management, and Source to Target Data Mapping.
• Selection of indexes, foreign key constraints, Oracle partitioned tables, creation of DB sequences.

ETL DEVELOPMENT SKILLS

• IBM Certified DataStage developer with hands on experience on DataStage 7.5.2/8.5/8.7/9.1. Experienced in creating DataStage routines and custom Build stages using C code.
• Skilled in Performance Optimization of DataStage jobs through selection of correct DataStage components Stages , partitioning methods, usage of Datasets and configuration files.
• Hands on experience in creating OLAP Cubes, Facts, dashboards and reports.
• Hands on experience on Oracle PL/SQL programs, triggers, Sequences, table Joins and Hierarchical tables.
• Performance tuning of Oracle SQL queries and PL/SQL programs using Explain plan, Run-stats, selection of proper indexing, partitioning tables, exchange partitions etc.
• Skilled in various large-scale databases such as Teradata V2R5/V2R6/12 Teradata Administrator, Teradata Manager, Query man, BTEQ, TPT scripts, Fast Load, Multi Load, Fast Export, Teradata SQL, Database Query Manager .
• Expertise in Integration of various data sources like Teradata, DB2 UDB, Oracle 11g/10g/9i and SQL Server.
• Worked on Platform Migration of DataStage Jobs and UNIX scripts from Ascential DataStage EE 7.5.2 version to IBM Information Suite IIS DataStage 9.1platform.
• Worked on Migration of Clinical data from older Oracle based Warehouse to a Robust Dimension Modeled Star Schema Oracle Warehouse of size 40TB.
• Good at preparing UNIX shell Scripts wrapper to invoke DataStage jobs and to perform Dataset File management activity thru OSH scripting and ORCHADMIN commands in UNIX shell scripts.
• Experienced in creating Perl scripts to perform auto-mail triggers and error reporting.
• Exposure to different Job schedulers like Autosys, EAS, Tivoli Work Scheduler TWS , Zeke Scheduler.

TEAM AND PROJECT MANAGEMENT SKILLS

• Experience in leading 10 members at offshore and 4 members team at client site.
• Experience in managing teams across multiple geographic locations working at different time zones.
• Resource planning, effort estimation, team building, mentoring and supporting junior members.
• Managing Requirements gathering, conceptualization and modeling new data marts, preparation of Mapping documents, design and overseeing development, performance tuning of ETL processes, bug fixing and production rollout, in short, the entire Software Development Life Cycle for this project from Architectural and ETL Lead perspective.
• Currently getting groomed to take up Development Team Manager Role in my organization.
• Winner of the Best Project Award - First Time Manager for exhibiting team Management skills and leadership skills leading towards successful implementation of a Data Warehouse Migration project.
• Exposure to various Quality standards and Management skills as part of CMMI Company norms.

HEALTHCARE AND INSURANCE INDUSTRY EXPERIENCE

• 7 years of Data warehousing and Business Intelligence DW-BI and ETL Consulting to major Healthcare companies namely Cigna, UHG and Aetna.
• Worked on Insurance domain to do insurance Claim adjudication, Underwriting, enrollment and benefits, identification of high risk customers etc.
• Worked on ICD9 to ICD10 conversion project effort at Cigna Healthcare.
• Worked on projects establishing Health Exchange HIX and PPACA, commonly called as ObamaCare.
• Good knowledge on Claim processing, Medical, Pharmacy, Dental, Vision, Encounter and Behavioral Claims.
• Good domain and business knowledge on Healthcare subject areas like Membership Enrollment, Products, Benefits, Payers and Provider Groups, Networks and Claims.
• Exposure to Industry popular Healthcare programs like Incentives, Gaps In care, Episode Treatment Group ETG , Episode Risk Group ERG , Evidence Based Medicine EBM Utilization Management, Care Management, Disease Management etc.
• Exposure to Medicaid domain.

TECHNICAL SKILLS

• Languages/Scripts C, C , PL/SQL, UNIX Scripting, Perl Scripting, COBOL. Eazytrieve.
• Mainframe Skills TSO, ISPF, SPUFI, FILE-AID, QMF.
• ETL/Reporting Tools IBM Infosphere DataStage 9.1/8.7/8.5/7.5.2/6.0.1, DataStage Server 7.5.3 and DataStage Server 4.5
• Operating Systems UNIX AIX, SOLARIS, HP-UX , Mainframe Z/OS, MS-DOS, Windows 9x/NT/2K/XP.
• Methodologies E-R Modeling/3NF Modeling, Dimensional Modeling, OLAP, OLTP, Water fall, Agile - Scrum Methodology, UML Modeling.
• RDBMS Teradata, DB2, Oracle11g, 10g, 9i, 8i, SQL Server, Informix, Sybase.
• Design Tools CA ERWin Data Modeler, MS Visio.
• PM Software MS OFFICE, MS Project.
• Testing Tools Test Director 7.x/8.x, HP Quality Center, Clear Quest.
• Database Tools Oracle SQLPlus, Toad for Oracle, Teradata SQL Assist,
• SQL Developer for SQL Server, DB2 Control Center, SPUFI for DB2.
• Job schedulers Autosys, IBM Tivoli Work Scheduler TWS , ZEKE Scheduler.
• Source Control Tool Microsoft Visual SourceSafe, Rational Clear Case.

PROFESSIONAL EXPERIENCE

Confidential

Data warehouse Solution Architect

Architectural design and development of Clinical Data Warehouse and its Data Marts

• The Consumer Centric Data Repository CCDR provides integrated, member-centric information environment in support of Health Advocacy, Consumerism, and Informatics strategies. The data warehouse along with functional Data Marts provide 360 degree view of an individual internal and external membership across medical, behavioral, pharmaceutical, disability, Vision, and dental product lines. I am part of this warehouse since its inception and now our team is responsible for maintaining this warehouse as a single Information Management system.
• My end-to-end implementations at Cigna Healthcare can be split across two timelines as mentioned here

Confidential

ETL Inbound data flow into Warehouse

• Building Consumer Centric Data Repository CCDR . This is currently 40 TB in size.
• The subject areas involved are Client Structure, Products, Providers, Subscribed Members, member benefits, Claims and Biometrics to name few.
• SCD Type II based Dimension tables, Oracle partitioned Fact tables, bridge tables and grouper tables.
• This is a star schema based Data Warehouse built on Oracle currently on Oracle 11g .
• Platform Migration of Clinical data from an older Oracle Data Warehouse ACDR to a robust Customer Centric Data Repository CCDR .
• Platform Migration of Healthcare data from Great West to Cigna's CCDR Data Warehouse.
• Establishment of Patient Gaps In Care, Care Management, Utilization Management, Predictive modeling to identify high risk and high cost members.
• Establishment of Common Biometrics Format flow to store Patient Biometrics data for all External client accounts on CCDR warehouse.
• ICD10 remediation of Warehouse tables Done on Oct 2013 .

Confidential

ETL Outbound data flow out of Data Warehouse and Data Marts

• Creation of Collaborative Accountable Care CAC Management Mart to perform payments to Providers who have been part of Collaboration care program.
• Value Based Collaboration Report Mart VBCR to present the info on customers involved on Collaborate Care Management program via a web based Portal to be used by Health Care Professionals HCP .
• Creation of Member, Provider and claims feeds for Cigna Membership to Ingenix' s Symmetry Grouper software Version 7.5 in order to create Episodes of Care, Gaps in Care, Episode Treatment Group, Episode Risk Group for Cigna and Great West members to be used for Collaborative Account Care for Providers.
• Creation of Customer Reporting applications to publish Daily admission and discharge information of Patients on Inpatient facilities.
• Creation of Clinical Service Data Mart and Dashboards for Collaborative Care Management of patients by Health Care Practitioners.

Roles and Responsibilities:

• As a Solution Architect for Information Management Domain, responsibilities include but not limited to Architecture, modeling, source to target mapping, overseeing design and development activities.
• Data Modeling involves conceptual Dimension modeling and Erwin is the tool used to create data Model diagrams, maintaining naming conventions for tables and columns, maintaining Data Dictionary, in short called as Meta Data Management MDM .
• Have worked under dedicated ETL Development team for first one year and then moved on the ladder to become a Data warehouse Solution Architect. Hence, my roles and responsibilities are diverse and spread across the entire project life cycle.
• Worked closely with business users and customer systems for Cigna Healthcare to gather inputs and to conceptualize and design an architectural model to bring in Healthcare data from to Cigna Platform.
• Responsible for Architectural conceptualization of various Data marts for CCDR warehouse.
• My roles include managing Requirements gathering, conceptualization and modeling new data marts, preparation of Mapping documents, design and overseeing development, performance tuning of ETL processes, bug fixing and production rollout, in short, the entire Software Development Life Cycle for this project from Architectural perspective
• Work nature includes creating Star-schema Data warehouse models, designing Data Marts, Dimension Tables, Fact tables, reference tables, in short Modeling of Warehouse and marts.
• Hands-on experience in design, development, testing, fine tuning, Performance enhancement, Performance analysis and Bug fixing of Data Stage EE 8X and 7X jobs.
• Have expertise in design and implementation of DataStage Server jobs, parallel jobs, Shared Components and Job Sequencers.
• Have sound knowledge of Medical, Dental, Behavioral and Pharmacy Claims, Member Enrollment, Claims to Member Eligibility Matching.
• Responsible for identifying data redundancy and cleansing of old and duplicate data.

Confidential

Data Warehouse Solution Architect

• This project is to introduce a new Line of Business LOB for Nebraska State in order to process Medicaid for Nebraska State. Activities involve setting up new process and a new system Facets and Data Warehousing to process Medicaid received by Nebraska State Government.
• Have led a 5 member team at offshore and a 2 member team at customer site onsite for this assignment.
• Interacted with business users in gathering project requirements and created mapping documents.
• Developed server and parallel jobs using IBM Information server Infosphere DataStage.
• Extracted data from various sources like Oracle, DB2, SQL Server and Flat Files, applied required transformation rules and loading the data into Data warehouse
• Developed parallel jobs using various stages like transformer, aggregator, sort, merge, join, change capture, change apply, peek stages.
• Experience in working on developing oracle PL/SQL to write stored procedures, oracle functions, packages and triggers.
• Developed Unix Shell Scripts to validate sequential files, file manipulation, sort scripts and data loading procedures and execute the DataStage jobs.
• Used Autosys Scheduling tool to Schedule the jobs and collect the Job Statistics.
• Involved in system testing, integration testing and performance testing using Test director.

Confidential

ETL Lead/Onsite Coordinator

• The strategic Contact Center reporting solution will pull together all sources of member, provider and plan sponsor information in order to provide a complete view of a constituent's interactions with Aetna. This will provide the business with a robust, flexible reporting tool that will allow design of reports on
• Ad-hoc basis to meet the changing business needs. The project delivers in depth analysis and key metrics of Aetna's Customer Contact Center performance.
• Have led a 6 member team at offshore and a 2 member team at customer site onsite for this assignment.
• Worked in Requirement gathering with clients to identify and define the business requirements.
• Actively involved in interacting with DBAs in data mapping phases to come up with Data Modeling for the warehouse.
• Involved in the design of the project which includes Metadata modeling, Data stage job design and ETL architecture.
• Involved in designing jobs using Datastage EE Edition to Extract, transform and load data into target warehouse.
• Involved in reviewing and Unit testing of DataStage jobs and also troubleshooting the issues identified.
• This project has source database residing in DB2 and SQL Server. Two separate DB2 warehouses will be built. The new warehouse developed will enable the reporting activities as per business needs.
• Worked on Zeke Scheduler and created JCL scripts to have the DataStage jobs scheduled

Confidential

Offshore ETL Lead/Sr. ETL Application Developer

This project is all about of building of an Oracle DB warehouse called 'Nebula' and creating reports called 'Norms'. The project activity includes data-modeling in analysis/design phase using Erwin Data Modeler and Design, development and testing of Datastage PX jobs. Nebula is a consolidated warehouse designed to house all participating employer's group health and workforce productivity data.

• Led a 7 member team at offshore Cognizant India ensuring Software Development Life Cycle is in pace with project deadlines.
• Perform Requirements and Functional Analysis and Prepare Design functional specification document.
• SAS reporting was replaced by DataStage 7.5 Enterprise Edition to create 'Norms'.
• Data Modeling of Nebula Warehouse using Erwin 3.5
• Create, Develop and Test the ETL Mappings / jobs in Datastage EE edition. The development activity involved building complex DataStage jobs, developing Shell scripting to execute the jobs developed in Datastage EE, developing Perl scripts to notify job run status by Auto-triggering mails to Support team.

• Extensively used DataStage Designer to develop DataStage Parallel jobs 7.5 and Shared Containers using Aggregator, Transformer, Lookup, Join, Copy, Remove Duplicates, Filter, Change Capture, Funnel, Difference, Compare, Column Import, Column Export and Dataset Stages.

• Responsible for coordinating with the clients in UAT session and to ensure accurate release-testing in Beta and Production Environments
• Actively involved in shipping the components in production and conducted production run to ensure our product meets the business needs of client.
• Production scheduling of DataStage jobs and UNIX scripts using Autosys Scheduler.

Confidential

Application Developer/Subject Matter Expert

CPP The Card Provisioning Platform is a large DB2 MVS mainframe system. CPP processes calling card service orders for consumer and business customers. CPP is responsible for the support of AT T Card Accounts that allow business and residence subscribers to charge long distance and local telephone calls. It comprises of several applications, which perform various functions including service order processing, maintenance of customer information, card account maintenance, credit scoring, and creating of vendor records for card issue.

• Have designed very complicated calling card number inventory modules in AT T's calling card application using COBOL, DB2 on Mainframes.
• Was one of the key developers in the CSC AT T account's calling card merger project in 2007, with 4000 hours of effort
• A warehouse to accumulate all the card information with DB2 as database was built. Data will be extracted from OLTP system into DW system. Initially, the ETL was happening using Mainframe COBOL jobs.
• This has been migrated to Datastage for better performance.
• The data volume running in Millions were handled efficiently by Datastage jobs.
• Contributed well to Quality Audits in the application. Has faced audits by SQAG team independently.
• Traveled Hyderabad Client's offshore location to hand over application Knowledge Transfer to CSC India.