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 Confidential 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 - 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 ” - ed by Confidential 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.
• 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 Confidential .
• 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, 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.
• 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 Confidential 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.
• Experience in leading 10+ members Confidential offshore and 4 members team Confidential client site.
• Experience in managing teams across multiple geographic locations working Confidential 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 - 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.
• 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 Confidential .
• 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 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 SoftwareMS 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, CT

Data warehouse Solution Architect

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 Confidential 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, 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, Philadelphia, PA

Data Warehouse Solution Architect

Responsibilities:

• Have led a 5 member team Confidential offshore and a 2 member team Confidential 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, Middletown, CT

ETL Lead/Onsite Coordinator

Responsibilities:

• Have led a 6 member team Confidential offshore and a 2 member team Confidential 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, Rocky Hill, CT

Offshore ETL Lead/Sr. ETL Application Developer

Responsibilities:

• Led a 7 member team Confidential 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 New Jersey

Application Developer/Subject Matter Expert

Responsibilities:

• Have designed very complicated calling card number inventory modules in Confidential & T’s calling card application using COBOL, DB2 on Mainframes.
• Was one of the key developers in the CSC Confidential & 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.