SUMMARY:

• versatile, analytical and hardworking professional having experience in Abinitio ETL tool.
• Able to collect and analyze information, digest facts/figures and quickly grasp complex technical issues.
• Proven ability to manage and complete projects/assignments to the highest standard with meticulous attention to detail and within agreed deadlines.
• Good communication and presentation skills and ability to quickly adapt to the technical environment of the Organization.
• Self - initiative and a good team leader, committed to the company's success and adaptable to its changing needs.
• Overall Eleven years of Extensive Working Experience in Data Warehousing Projects in India and USA. Worked for prestigious clients like Confidential, Confidential and Confidential .
• Expertise in Data Warehousing Technologies such as Ab Initio, Business Objects, Actuates and Oracle HTML DB.
• Worked in all aspects of Project Life Cycle Framework both Agile and Waterfall which includes Requirement gathering and Analysis, Design, Development and Unit Testing, SIT, UAT, PERF,REGR, Training, EME deployment p roduction Migration and Implementation support.
• Worked extensively in a complex, high-volume of data using Ab Initio, Oracle (PL/SQL), UNIX and UNIX Shell Scripts. Strong experience in designing, developing and testing large scaled applications.
• Good knowledge and experience with Telecom, Banking and Healthcare Domain. Good understanding of business processes in industry and ability to analyze the process and map it to the requirements and software packages available.
• Involved in conducting strategic evaluation (Proof of Concepts) of the use of Ab initio.
• Strong Ability to interact with end users and analyze existing systems, conceptualize new ones, design systems integration, and deploying innovative business solutions using the highest standards of quality control.
• Experience in identification of Business and Data requirements and converting them into conceptual and logical/physical data models.
• Experience in Dimensional Data Modeling (Star and Snow Flake Schemas). Experience in developing logical and physical data models using Erwin designer.
• Experience in Oracle based Client Server Applications in developing PL/SQL procedures, database triggers and other components of database applications.
• Experience of working with Control M Scheduling Tool and Job Manager Scheduling Tool.
• Good Project Management Skills. Closely worked with Project leads, Onsite Managers and Delivery Managers. Worked on PMR, Audits and Billing invoices.
• Good understanding of Hadoop Certified Associate Program objectives and HDP 2.4 use cases involving Pig,HDFS,Ambari,Yarn,Hive,Hbase,Tez,Storm,Flume,Nifi,Zippelin,Kafka,Ranger,Oozie,Zookeper,Cloudbr eak, Sqoop and Knox.

TECHNICAL EXPERTISE:

ETL Tool: Ab Initio Co>OS vs. 3.1/3.0/2.14

GDE: vs. 1.14.34/3.0/3.1 , Batch, Continuous Flows

Big Data: Hortonworks Hadoop Platform 2.4(Learner)

Designing Tools: Microsoft Visio 2003 Operating System-UNIX (AIX, Solaris,HP- UX,Linux),Windows 95/98/2000/NT, MS DOS

Web Technologies: HTML, DHTML, JAVA Script

Tools: TOAD 9.1.0, PL/SQL developer 5.1, CTRLM,MFT, XML, PDL, Express It, Query It, BRE, ACE, EME, Data Profiler.

OLAP Tool: Business Objects 6.5/XI, Actuate, Oracle HTML DB RDBMS- Oracle 8i/9i, Teradata Languages- SQL, PL/SQL & SQL*Plus, Java 2.0, C, C++

Version Control: Ab Initio EME

Defect Tracking: Quality Center 8.2, Service Center,TFS(Tivoli)

EXPERIENCE

Confidential

ETL offshore/Onsite Lead

Responsibilities:

• Perform System and Requirement Analysis, Coding, unit testing, reviews and production implementation of the Enterprise Data Warehouse - Customer & Products project which involves processing the membership data and load it into the Enterprise Data Warehouse.
• Determine the insurance membership data set which would be used as the source, work to source this data for the data warehouse processing.
• Develop data processing applications using Teradata and Ab Initio.
• Creating Control-M jobs for scheduling Ab Initio code processes.
• Design and Develop Ab Initio graphs for the data specifications provided by the client.
• Review & peer review the Ab Initio graphs to ensure optimum performance and fulfillment of requirements. Deploy Project and Sandboxes at EME. Create Project hierarachy,Tag,Checkin, Checkout and migrate across different branches.
• Develop UNIX Korn Shell & PL/SQL Scripts for the applications involved that automate the ETL Process, which can also be reused
• Do end to end system testing of the code development environment.
• Manage the issues raised from QA and assign the work items to the team and take up critical work items.
• Extensively used Enterprise Meta Environment (EME) for version control. Created Sand box for check in & checkout process.
• Design systems integration, and deploying innovative business solutions using the highest standards of quality control

Confidential

Senior ETL developer

Responsibilities:

• Participated in ETL development process using Ab Initio in Oracle 9i environment.
• Performed analysis on the extracted data which is transformed and loaded into the Data Warehouse, to achieve quality and consistency.
• Developed graphs to take process huge sets of input data (with millions of records) using compression techniques.
• Developed Common Project Sandbox objects (xfr,mp) which were used across all projects of FDW.
• Involved in developing Monthly and Daily Adjustment process where Adjustments were Submitted through DIF java portal in xls format.
• Involved in Ab Initio Upgrade from 2.14 to 3.0 and created cook book rules.
• Created Common Audit Graphs to capture statistics of total records loaded, rejected filtered in the process.
• Involved in Project Management, Effort Estimation, Resource allocation, Defect Tracking and Code review from Onshore.
• Created 5 new RRI - regulatory reporting infrastructure interfaces for Adjustment Submission which Involves calling Ab Initio via Java portal.
• Involved in giving ETL design specification in developing VADER migration portal to Migrate Ab Initio Objects across different Branches and environments(QA/UAT/DEV/PROD/Break fix).
• Created Dynamic xfr Generation Code where Component Rules xfr's were created directly by reading values from Business Rules Table.
• Worked with resources from Abnitio Corporation on Performance Tuning, Resolving Dynamic reference, Component Folding and issues related to Ab Initio 3.0.
• Working on Multi file systems with extensive parallel processing.
• Used Ab Initio partition components to achieve parallel data transformations and filtering.
• Responsible for the performance tuning of the ETL graphs.
• Prepared and implemented data verification and testing methods for the data warehouse.
• Implementing transformation rules using Ab Initio components
• Created graphs for performing aggregation and joins on the records
• Improvised the existing Ab Initio ETL process by identifying bottlenecks in the graphs and modifying them to make better use of the resources by utilizing the capabilities of the tool.
• Worked in close coordination with business analysts and reporting groups in designing aggregate business rules.
• Maintenance of Sandbox level Parameters and Project Level Paramenters.Deveoped Switch parameters to point to Different Underlying Databases.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio functions like is valid, is error, is defined, string * functions, date *functions.
• Used Ab Initio components like components like Sort, Partition by Key, Partition by round robin, Partition by expression, Reformat, Join, Normalize, Gather, concatenate, Replicate, filter by expression, Rollup, dedup sorted etc while developing graphs.
• Developed Shell Scripts for Batch Processing, start and end scripts for invoking the Ab Initio graphs
• Developed an ETL process to update the ODS database with the new and changed records as a result of Transactions at the end of each month.

ETL developer - BI Reporting

Confidential

Responsibilities:

• Design and develop Universes and generate Reports using Business Objects 6.5.
• Give privileges to BO users on each report.
• Develop Proof of Concept for Oracle HTML DB in Developing Major Business Reports.
• Maintain BO universe and Send the reports to Billing Mangers every Tuesday of the week.
• Application Maintenance, Solving Data Problems at Report level and Handling Customer Issues.
• Participated in ETL development process using Ab Initio in Oracle 8i environment
• Implementing transformation rules using Ab Initio components
• Created graphs for performing aggregation and joins on the records
• Worked in close coordination with business analysts and reporting groups in designing aggregate business rules.
• Developed various Ab Initio Graphs for data cleansing using Ab Initio functions like is valid, is error, is defined, string * functions, date *functions.
• Used Ab Initio components like components like Sort, Reformat, Join, Normalize, Gather, concatenate, Replicate, filter by expression, Rollup, dedup sorted etc for developing graphs.
• Developed Shell Scripts for Batch Processing, start and end scripts for invoking the Ab Initio graphs