SUMMARY

• Over 11+ years of IT experience in design and development of ETL solutions using Ab Initio, Oracle, Teradata, MSSQL, DB2 for supporting data migration, data transformations & processing in data warehouse and integrating BI reporting environments through ETL solutions.
• 3 years of experience in leading ETL solutions delivery of Confidential Sales management applications.
• Excellent knowledge of Data Warehousing and Business Intelligence concepts and working wif Data Modeling Methodologies.
• Hands - on experience in improving performance and troubleshooting of Ab Initio graphs.
• Installation, Maintenance and administration of ETL tools
• Extensive hands-on experience in core Ab Initio concepts like Parallelism, MFS, and PDL.
• Experience in using EME for version controls, impact analysis and dependency analysis.
• Developed generic Ab Initio graph for loading teradata using Fast load or API based on data volume.
• Has worked on BRE and has exposure to Ab Initio suite of products ACE, Metadata hub & Express>It and Data Profiling.
• Experience in ETL tools like Informatica and exposure to Hadoop concepts of HDFS, HBASE, Sqoop and Pig.
• Hands on experience in Unix Shell Scripting and Scheduling tools.
• Excellent knowledge in ETL interfacing of heterogeneous source systems like Oracle, Teradata, MS SQL Server, DB2, flat files and legacy system.
• Expert in system analysis and troubleshooting, test plan strategy, release planning and has experience in all phases of SDLC starting from requirements collection till moving the code to Production.
• Flexible, enthusiastic and team player wif excellent communication skills, ability to grasp new concepts and implement productively.
• Worked in client interfacing roles for clients across various domains.
• Experience in handling concurrent projects in an offshore-onsite development model.
• Experience in Agile, Waterfall model of ETL development and understood SOX compliance
• 2 years of experience in 24*7 Production support Model.
• 1 Year Of Experience using Talend ETL Tool on Big data platform.

TECHNICAL SKILLS

ETL tools: Ab Initio 3.1.6, Conduct IT, Informatica

Reporting tools: Business Objects, Brio

Scripting Languages: Unix shell scripting

Version Control tools: EME, RCS, CVS, Clearcase, Visual Source Safe

Databases: Teradata, Oracle, DB2, SQL Server

Defect Tracking Tool: HP Quality Center, ClearQuest

Operating Systems: HP Unix, Solaris, Windows 7

Schedulers: Control-M, Autosys, Dollar U, Maestro, Cron

Others: PDSM, Visio, ITSM

PROFESSIONAL EXPERIENCE

Senior Technical Lead

Confidential - Memphis, TN

Environment: Ab Initio GDE 3.1.3, Cooperating system-3.1.3, Ab Initio Continuous Flows, Conduct>IT, Teradata, Oracle, EME, BRE, Unix, MQC, $UVIEW

Responsibilities:

• Work wif project business analysts to understand requirements for Adoption of SE and create ETL High Level and Low Level Design documents.
• Design and built Ab Initio graphs and calling graphs using Wrapper scripts to integrate PSETs based graph executions, establish dependencies wif various modules, implemented resource pools.
• Built ETL graph for populating various tables for Segmentation process which includes Hierarchy, revenue, address and attribute table loading before loading segmentation table for 5 sectors in Oracle which is a truncate and load process
• The segmentation process has Simulation and daily ETL processes where corresponding graphs and scripts created to populate the respective streams.
• The Simulation process is loading the data for future quarter i.e for next quartter and at the end of the quarter flipped to the daily tables.
• The Oracle tables are converted to EDW format and the files are FTP’ed to EDW acquisition server.
• The acquisition server has load scripts to load the various EDW tables using the scripts.
• The source is CVM application where the source tables are extracted from Teradata
• The various sectors are US, CANADA, LAC, EMEA and APAC for which the data is segmented to segmentation tables-SEG 1 TB to SEG 5 tb using Segmentation ETL process.
• The segmentation data is passed to alignments process where cash engine job runs and then runs cash alignment file process using Ab Initio graphs to create Quarterly Business Alignment files, Quarter End Alignment and SBA files(daily)
• Perform dollar-U scheduler change, scripts to trigger plan for ETL process.
• Defect support, environment scheduling, monitoring, job abend restart and root cause analysis for CASH WBA prod support.
• Perform Month end revenue runs and then use the revenue details to run cash engine jobs to create Quarter End Alignment files at end of each month which are sent to CSI server
• Prepare migration plan and production history load instructions.
• Generation of ETL jobs using Talend ETL for Mass upload process.

Ab Initio technical lead

Confidential - Franklin Lakes, NJ

Environment: Ab Initio GDE 3.1.3, Cooperating system-3.1.3, DB2, Teradata, EME, Unix, BRE,MQC, Autosys

Responsibilities:

• Based on the business requirements document enhancing the mappings and existing graphs based on Business requirements document
• Providing Production support
• Executing Conduct IT plan to run for various iterations of a tier
• Creating WHSEFULL files and RDX files and sending to be adjudicated by Mainframe and comparing east and west files and sending claim compare reports for business.
• Performance Tuning of Ab Initio Graphs and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team

Confidential - St Paul, MN

Environment: Ab Initio GDE 3.1.3, BRE, Conduct>IT, Cooperating system-3.1.3, DB2, Oracle, Teradata, MSSQL, EME, Unix, MQC, Autosys

Responsibilities:

• Estimation for the Design, Coding and Unit testing activities to fit into Project timelines and enhancing existing Ab Intio graphs as per Schema Mapping document
• Prepare Design documents for various workstreams in the Project.
• Coding, Unit testing of Ab Initio Code deliverables and Review of Code and involved in code promotions to higher environment.
• Performance Tuning of Ab Initio Graphs and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team

Confidential

Environment: Ab Initio GDE 3.1.1, Cooperating system-3.1.1, DB2, Oracle, Teradata, MSSQL, EME, Unix, MQC, Control-m

Responsibilities:

• Understand the legal requirement for Flow Mart & Claims LMA R2 Conversion, Space Project and identified the impacted BI ETL processes and propose design solutions.
• The Flow Mart Data Model is composed of 9 stars namely Account, Policy, Competitor, Transaction, Policy State, Location, Vehicle, Driver and Rule. In Flow Mart, a Type 1 indicates a column where a changed value would require an update to the record in place, and Type 2 indicates a column where a changed value would require an entirely new row to be inserted and played a key role in building the SBIS Flow Datamarts using the Type 1 and Type 2 Models.
• Worked in SCD Type 2 dimensions and was working in a Star Schema data model.
• Estimation for the Design, coding and Unit testing to fit into Flow Mart project timelines and completed design and development wifin the timelines
• Developed ETL process using generic graph to extract various tables from differing sources i.e SQL Server and Oracle and Teradata.
• LMA R2 Conversion is a project where existing Practice Manager(PM application is replaced wif LMA i.e Litigation Management Application for creating, tracking storing the matters/cases and played a key role in incorporating the functions of PM.
• Worked on trillium tool for standardizing Personal and Business Entity addresses.
• Estimation for the Design, Coding and Unit testing activities for LMA R2 Conversion to fit into Project timelines and enhancing existing Ab Intio graphs as per Schema Mapping document
• Space Program in Confidential comprises Product Inbound Interface where all Product tables extracted from Oracle and then transformed to generate Product Delta files which are loaded to JDA Product tables. Similarly Store Inbound interface extracts the store tables from Oracle and then transformed to generate store delta files loaded to JDA store tables and the JDA database is SQL Server Database.
• Preparation of High Level design and Low Level Design documents
• Coding, Unit testing of Ab Initio Code deliverables and Review of Code and involved in code promotions to higher environment.
• Involved in Performance Tuning of Ab Initio ETL graphs, processes and load routines and supporting System testing, Integration test environment and Preparing Implementation Plan documents for Ab Initio Support team.
• Developed customized shell scripts to trigger Ab Initio process in runtime.
• Created mapping documents wif the required transformation logic, sources tables & fields for loading the target tables.
• Design and built job schedulers using Autosys.
• Provide warranty support post production, identify and fix known issues.
• Release planning of ETL process wif interfacing applications by sending release plan documents to ETL Support team.

Module Lead

Confidential

Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, MQC, Maestro, RCS

Responsibilities:

• Analyzing and Gathering the requirements by direct interaction wif clients.
• Prepared Mapping documents for Source to Target Mapping.
• Worked on Low level design based on the High Level Design provided by ETL Tech lead in EDS.
• Develop ab initio graphs as per the design requirements and performed performance tuning of the graphs.
• Involved in unit testing, generation of Unit test plan document and involved in code promotion to higher environments using RCS.
• Good knowledge of RCS, EME Code versioning tools and RCS maintains the master copy of the objects.
• Design and built job schedulers using Maestro scripts and set the dependencies between jobs.
• Provide warranty support post production, identify and fix known issues.
• Release planning of ETL process wif interfacing applications by sending release plan documents to ETL Support team.

Ab Initio Developer

Confidential

Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, MQC, CVS

Responsibilities:

• Interpreting the requirements by direct interaction wif clients.
• Generating Low-level design and developing custom abinitio graphs as per the design requirements for 13 constraints
• Involved in generating code using Data Elements Framework
• Performed performance tuning of Ab Initio graphs and maintaining Ab Initio development standards and followed Ab Initio best practices.
• Involved in unit testing, generating unit test plan documents and support manual documents and involved in code promotions to higher environments using CVS.

Ab Initio Designer

Confidential

Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Oracle, Teradata, EME, Unix, Control-m, Clearcase, Clearquest

Responsibilities:

• The csv file containing debit card transactions wi moved to Central Staging area where Ab Initio jobs loads created to load newly created table in PCRANEUK database.
• Brio summary and exception reports are generated using the table data in PCRANEUK database
• Interpreting the requirements by direct interaction wif clients.
• Involved in preparing the design document as per the technical architecture document.
• Develop ab initio graphs to validate the data file in the ETL server, compare the checksum value wif the signal file.
• EME is the Code version tool used for checking in the code for CSA2 server and Clearcase is the version control tool for maintaining CSA1 objects.
• Involved in enhancement of capitalize transform function.

Ab Initio Developer

Confidential

Environment: Ab Initio GDE 2.15, Cooperating system-2.15, Plan>It, Continuous flows,Oracle, Teradata, EME, Unix, Cron, Informatica 7.1,6.2,Visual Source Safe, Business objects XI, Test Director

Responsibilities:

• Provide recommendation and code enhancements for the identified root cause of failure.
• Develop Ab Initio graphs and wrapper scripts
• Analyzed and fine-tuned Ab Initio graphs to reduce the job running time to enhance performance.
• Month end runs run as per the schedule in Production.
• Publish manual work effort statistics on a monthly, quarterly and yearly basis and recommend reoccurring issue resolutions to save manual effort put forth by team.
• Created Generic Housekeeping script as a part of Enhancement activity to ensure multiple project teams can reuse it by supplying the parameters for running the script from scheduling tool
• Setup automation alert scripts to monitor Server space, file system warning.
• Involved in job monitoring of production jobs.
• Handling rejections by analyzing the reason for rejections for the Ab Initio record Rejections in the reject file
• Solving Help Desk tickets and servicing the tickets by providing the resolutions based on the Severity for the various legacy systems and has exposure to handling defects in PLSQL packages
• Involved in Monitoring Informatica Sessions and Workflows