SR. ABINITIO DEVELOPER
A Sr. developer with more than 5 Years of experience in Data ware Housing using Ab Initio and Teradata which involves the entire SDLC i.e. Understand and Analyze the Requirements/Functional Specifications by interacting with Business Analysts, Development, Testing, Implementation and providing technical solution to client.
5.4 years of IT experience working in Data Warehousing, development, UNIX/SQL Data Analysis/Documentation, Extraction, Transformation and Loading (ETL) mechanism using Ab Initio.
Worked on various Ab Initio components; reformat, sort, rollup, dedup sort, normalize, lookups,
Scan, input/output tables, xml split etc.
Well versed with various Ab Initio parallelism and partitioning techniques, currently working in a four way partitioned environment.
Extensive knowledge on EME, checkins, checkouts, command line interface, air commands.
Hands on experience in development of Data Warehouses/Data Marts using Ab Initio Co>OP, GDE, Component Library, Teradata and UNIX for mainly Insurance industry.
Experience in writing and optimizing complex SQL queries using Teradata.
Experience in Data Warehousing concepts; Dimensional Modeling/ Kimball Methodology, Star Schema, Snowflake Schema.
Experienced in interacting with EME Data store with several air commands.
Integration of various data sources such as flat files, ASCII, EBCDIC files, XML files, DB tables etc.
Experienced in working with Mainframe Data Files, COBOL Copybook, and UNIX shell wrapper scripts.
Excellent team member with a unique blend of Managerial, Technical, Functional and Qualitative skills backed by strong record of facilitating cross-functional coordination for successful delivery of the Software Solutions.
ETL Tools Ab Initio Co >op 184.108.40.206 and Co>op 220.127.116.11 Ab Initio version 3.1.2 and 18.104.22.168,
Ace Template, Ab Initio BRE. Informatica (hands on Experience)
Languages Unix-shell scripting, C, C++.
Databases Teradata, Oracle and Microsoft SQL server.
Scheduling Tools Autosys, Conduct>It
Testing tools HP Quality Center, Clear Quest
Operating System Windows (2007 onwards)
PROFESSIONAL EXPERIENCE June 2014 to Present
Role: Sr. Ab Initio Developer
Location – Hartford, CT
Client – Travelers Insurance
Project – To build a direct data warehouse, consuming data from eight odd sources in various formats like flat files, XML’s, database extracts etc. This warehouse contains an atomic layer of all the Digital data through web, mobile, tabs call, quote application etc. Over this we have a presentation layer, which summarizes the activity for each individual, and help the client understanding the customer behavior and invest accordingly in various campaigns.
Work extensively on Ab Initio development from the initial phase which include design discussion, SCD type, retention of a quote, data volume etc.
Developed complex graphs and plans using advance concepts like resource pooling, ICFF lookups TPT load, Rollup, scan, vector processing etc.
Playing a role of a tech lead and also managing team of four members from offshore.
Coordinating with offshore, doing code review and insuring timely delivery in an agile model.
Performance optimization using Ab Initio data parallelism and partitioning techniques
Interacting with EME (check out/Check in) working in parallel branches within EME and maintaining versions.
Using BRE for complex if then else logic.
Developed generic graphs using PSETS and graphs/object parameterization technique. Build generic framework for file validation Process.
Performed Unit testing and managed defects in Quality Centre.
Assigned phases and set up checkpoints to complex graphs having large number of components to protect against failure, avoid dead lock and easy recovery of failed graphs.
Aug 2012 to JUNE 2014
Role: Ab Initio Developer
Project: To extract data from the POLICY LINE WAREHOUSE and build an EARN PREMIUM Rating data mart .It includes cleansing of data, unloading various segments like driver, incidents, policies, coverages etc and marrying them together to give a DE normalized Policy look.
Worked as Ab Initio developer and involved in high-level design phase.
Worked on writing complex SQL’s for unloading data from warehouse according to the specifications using utilities like FASTLOAD and TPT.
Build a Generic framework for record count balancing and input file validation.
Applied Complex transformation using Joins, Vector append functions rollups etc.
Writing data into an XML blob using write XML component and loading in SQL server using bulk load.
Used PDL functions and build UDF’s used across projects
Responsible for the overall quality and timeliness of the deliverables.
Dec 2010 to Aug 2012
Role: Ab Initio Developer
Project: Applying mapping rules to POLICY LINE WAREHOUSE for QUOTES and migration of application from NON STND to STANDARD ENV.
Understanding complex mapping from business analyst.
Applying the transformation, generating DML’s and modified more than 100 objects.
Good exposure with Mainframe EBCDIC format files to handle with Ab Initio.
Created test cases for various scenarios for unit testing.
Convert the entire application to standard env, built PLANS from the existing scripts.
Convert Unix shell scripting into PDL functions and followed all Ab Initio best practices for standard env.
Used advanced concepts for Conduct>IT which includes looping in sub plan, resource pooling etc.
Conducted brown bag session on Conduct >IT and Ab Initio best practices
Conducted brown bag sessions on performance improvement at project level.
Build Ab Initio Generic Utilities used across all the projects Generic load, Generic Transformation, Generic Email generation and Generic file validation framework.
Got ACE award for best performer in 2013 (one of the highest rated award with in Accenture)
B. Tech (Computer Science) from Greater Noida Institute of Technology.