Professional Summary:

• 12 years of experience in the IT industry as a Ab-Initio Developer.
• Sound knowledge of Health Care InsuranceDomain. Also worked on FS Banking projects.Extensive experience as Lead AbInitio Developer andDesigner
• Excellent understanding of the System Development Life Cycle SDLC . Involved in analysis, design, development, testing, implementation, and maintenance of various applications
• Deep understanding ofData Warehouse and Data integration frameworks
• Worked extensively on SQLs and SQL optimization techniques.
• Developed Ab-Initio graphs to integrate data fromOracle, Teradata,DB2, Excel,flat files,XML Files, MQ andSalesforce.com.
• Teradata 14.0 certified professional
• Sound knowledge of UNIX shell scripting.
• Developed prototype for parsing high volume XML files using Hadoop and storing output in HDFS for Ab Initio
• Experience in gathering and writing detailed business requirement and translating them into technical specifications and design
• Experience working as techno-functional Project Manager Managing project plans, schedules and financials
• Ability to work in a geographically distributed virtual team environment and to build relationships with internal and external stake holders.
• Experience working in onshore / offshore model
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.
• Ability to understand long-term project development issues at all levels, from interpersonal relationships to the details of coding scripts with strong analytical, organizational, presentation and problem solving skills

TECHNICAL SKILLS:

Professional Experience:

Client: Confidential

Role: Lead Ab Initio developer

Confidential has initiated this program to advance the effectiveness of its outreach to members, prospects, providers, producers, and group administrators. The customer hub data mart integrates customer and other related information for campaign generation, customer segmentation, marketing analytics. It integrates 10 heterogeneous sources including Teradata, Oracle, Salesforce.com and flat files

Responsibilities:

• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users
• Extensively worked with the Ab Initio Enterprise Meta Environment EME to obtain the initial setup variables and maintaining version control during the development effort.
• Worked with data modeler to create Logical and Physical data model
• Extracted data from various sources like databases Teradata, Oracle , delimited flat files and Salesforce.com
• Designed and developed parameterized generic graphs
• Designed Ab Initio graphs that would harness Teradata capabilities ELT and balance resources between database and Ab Initio
• Analyzed SQL explain plans to determine optimization techniques join strategy, indexes, collect stats etc.
• Responsible for the detailed design and documentation.
• Coordinated efforts with different teams and stakeholders
• Developed, tested and reviewed complex Ab Initio graphs, sub-graphs, DML, Psets, XFR, deployed scripts, DBC files for connectivity, create Package and exports.

Tools and technologies:

Ab Initio, Teradata 13.10, UNIX, Erwin 7.3, Ctrl-M scheduler, Oracle 10g, SAS Marketing Automation, Salesforce.com

Client: Confidential

Role: Lead Ab-Initio Developer

Application to integrate patient data from Confidential pharmacy systems, Take care systems and Confidential. The integrated data will help client to get unified view of patients, better Confidential and customer service. Also presents cross-sell opportunities in longer run.

Responsibilities:

• Design ETL mappings and interfaces to integrate data into data-mart
• Guide development team with creation of designs and build
• Participate in reviews with build teams as well as client business teams and technical architects
• Completed migration of 3 years of historical data into data mart
• Designed ETLs that integrate with MQ series message queues
• Designed and build graphs for XML processing
• HL7 message handling
• Resolution of technical / environmental issues during development / build process
• Support client in User Acceptance Testing and quick turn-around on defects

Tools and technologies:

Ab Initio, Oracle 10g, XML, IBM MQ, Solaris 7.0, UNIX Shell scripting

Client: Confidential

Role: Lead Ab Initio developer

This project is about integration of patient clinical data into Confidential

Responsibilities:

• Designing ETLs to integrate various sources into Enterprise Data Warehouse
• Design ETL and Account Balancing and Control framework that can be used across ETL projects
• Architect solutions accounting for various performance considerations and load SLAs
• Work closely with data modelers to design EDW data models
• Created 'Best practices' and 'Coding standards' for development team

Tools and technologies:

Ab Initio GDE 2.14, Co>Op 3.12 , Oracle 10g, XML, IBM MQ, Solaris 7.0, UNIX Shell scripting

Client: Confidential

Role:Lead Ab Initio developer

This project is claims reporting application designed to serve claim handlers at leading Insurance Company. The data is integrated from various transactional sources into data mart for BO reporting.

Responsibilities:

• Designed de-normalized tables and PL/SQL jobs that load into these tables that improved report performance up to 35
• Designed reports consisting of 100 key claims metrics
• Worked with EDW team to identify claims related data elements that needed to be part of EDW
• Worked on slow-running report SQLs either by using SQL tuning techniques or converting report SQLs into Ab Initio ETLs that improved report performance by up to 46 .
• Developed in-take process to prioritize and triage report requirements and enhancements