SUMMARY

• 12 years of experience in the IT industry as a Ab - Initio Developer.
• Sound knowledge of Health Care & Insurance Domain. Also worked on FS Banking projects. Extensive experience as Lead Ab Initio Developer and Designer
• Excellent understanding of the System Development Life Cycle (SDLC). Involved in analysis, design, development, testing, implementation, and maintenance of various applications
• Deep understanding of Data Warehouse and Data integration frameworks
• Worked extensively on SQLs and SQL optimization techniques.
• Developed Ab-Initio graphs to integrate data from Oracle, Teradata, DB2, Excel, flat files, XML Files, MQ and Salesforce.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

ETL Tools: Ab Initio (GDE Version 3.0.2.2, Co>Operating system 3.1.6.1), EME, Data Profiler, Familiarity with Ab Initio ACE (Application Configuration Environment) and BRE (Business Rule Engine)

Scheduling tools: Ctrl-M

RDBMS: Teradata 13.10, Oracle 11g, SQL Server, DB2

DB Tools: SQL*Loader, TOAD, Teradata SQL Assistant, Teradata Parallel Transporter

Languages: C, C++, Java, SQL, PL / SQL, XML, Shell Scripting

Platforms: Sun Solaris 7.0, HP-UX UNIX, Linux, Windows, IBM OS/360

Modeling Tools: Erwin, MS Visio, Rational Rose (UML)

Big data: Hadoop (Cloudera implementation) - Basic proficiency

PROFESSIONAL EXPERIENCE

Confidential, Chapel Hill, NC

Lead Ab Initio developer

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.

Confidential, Deerfield, IL

Lead Ab-Initio Developer

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

Confidential, Deerfield, IL

Lead Ab Initio developer

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

Confidential, Northbrook, IL

Lead Ab Initio developer

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