Download PDF


  • Senior data engineer with 9+ years of experience analyzing, designing, developing and testing business software and implementing parallel data processing solutions using Ab Initio products, data warehouse, Unix scripting, SQL, schedulers and  batch/web application using Java/J2EE technologies.
  • Knowledgeable Ab Initio specialist skilled in extraction, cleansing, transformation, wrangling, profiling source data, integrating various sources like mainframe , SAS files, XML, JSON, HDFS & data migration by leveraging various Ab Initio components like rollup, join,lookup, ICFF, scan and many more.
  • Experienced in implementing dimensional design patterns and data warehousing concepts, parallel data extraction & loading techniques with MPP database. 
  • Hands on experience of generic graphs, PDL, data profiler, good understanding of conduct>It, BRE and continuous graph. 
  • Strong experience in optimizing & tuning SQL queries, indexing, table partitioning, writing and debugging stored procedure. 
  • Strong UNIX shell scripting skills with hands on experience of scheduling and automate Ab Initio jobs through TIVOLI job scheduler, Autosys tool and crontab.  
  • Actively participate in the design of new or changing mappings and workflows and produce technical specifications, test plans, test cases and execution of test scripts for the data warehouse solution.
  • Good experience with EME data store, air commands and version control repository like GITHUB, SVN.
  • Experience in scrum/agile model, managing quality processes & coordinate production releases. 
  • Strong in supporting,  executing, validating and monitoring ETL production jobs.
  • Proficient in communication, interpersonal skill, good analytical and problem solving skill
  • Worked as project lead to co-ordinate requirements, establish work priorities, organize assignments and mentoring junior team members.  
  • Knowledgeable in big data technologies like hadoop hive, sqoop and NO-SQL (Mongo DB) database.

Technical Skills

Data Integration & BI Tool

Ab Initio GDE, Co-op System, EME, Data profiler, Jaspersoft BI, Tableau,  Hadoop Ecosystem sqoop, BRE

Programming & Storage

Java, SQL, Shell Scripting, Hive, Oracle 12i, Teradata 14, Python, HDFS

Business Domain

Insurance (Property & Casualty), Finance ( Cards & student loan) 

Work History

Apr 2015Present

Data Analytic Consultant

Allstate Insurance
  • Profile, Analyze and evaluate Auto & Property policy data and prepare data plate form using Ab Initio for actuary. Leverage enterprise data warehouse and different tools to develop corporate research data files, information platforms or data spaces.
  • Evaluate technical designs and data mapping documents, utilize design to develop accurate defect free code, test programs using Ab-Initio, SQL, Shell Scripting, Java, python, oracle, SAS on UNIX environment. 
  • Execute, monitor and validate data of key policy, quotes and claim application, provide on-site support and perform root-cause analysis & fix any issues that arise in data sets. Participate in Production Support transition meetings
  • Participate in code reviews, and test plan reviews
  • Provides input in creating detailed ETL development estimates or change requests.
  • Perform performance tuning on both UNIX ETL and Oracle database environments
  • Work closely with Data scientist, Actuary and business managers to prepare requested data sets. Prepare use case document to evaluate different best suitable ETL tools.

Technical Environments: Ab Initio GDE 3.2.2, Co-Operating 3.2.4, Linux, Oracle 12i, Python, Java, SAS, Tivoli work scheduler and Hadoop ecosystem

Mar 2014Apr 2015

Sr. Ab Initio Consultant

Discover Financial Services, IL
  • Provided subject matter expertise in the analysis and preparation of specifications and plans for development/modification of the EDW.
  • Designed PULSE data marts and support business analytic using the Teradata database. Pro-actively identify and communicated scope, design, development issues and recommend potential solutions.
  • Developed ETL code to meet all technical specifications and business requirements according to the established designs, assisted & mentor other team members. 
  • Coordinated work with offshore team members, business analyst and data analyst to resolve gaps in EDW design specifications.
  • Coordinated with data modeler/DBA to design data model & integrate DB changes. 
  • Created, scheduled new jobs and Supported existing production job runs 
  • Keep ETL artifacts in EME and deploy it to production using Live_Queue process.

TE: Ab Initio GDE 3.1. 7, Co-Operating 3.1. 4, Linux, Teradata, Tivoli work scheduler and Cognos reporting

Nov 2013Mar 2014

Ab Initio Consultant

  • Migrated PERL drivers into Ab Inito Conduct>IT plan. 
  • Analyzed  and redesigned existing long running EDW process and improved run performance. Loaded high volume sales fact and dimension tables into Netezza. 

TE: Ab Initio Co>OP 3.0.4, Linux, Oracle 11g, Netezza DW appliance and Business Objects

Jan 2010Nov 2013

Project Lead - Ab Initio Specialist

Syntel Inc
  • Discussed requirements with business analyst, Data architects and QA and prepare technical specifications. 
  • Designed, developed and tested Ab Initio graphs, Java batch and web application.
  • Implemented various partitioning techniques (like data, Component and Pipeline), re-partitioning technique and multi-partition file and flow to speed up the processing of data wherever applicable.
  • Wrote shell script to invoke graph in scheduler. 
  • Maintained issue log, prioritize, resolve critical immediately and coordinate remaining issues with the offshore team member, resolve doubts related to requirements, design and guide them on technical issues.
  • Installed and configured A>I products, create EME projects in each of the environments, setup sandboxes in physical environment.
  • Actively involved in code reviewing and testing Ab Initio graphs, java program and shell script for its correctness.
  • Created and deploy Ab Initio tag & Java packages on test environment, support production release activities.

TE: Ab Initio GDE 3.0.4, CO>OP 3.0.4, HP Unix, IBM DB2 9, SQL and PL-SQL, Inetsoft reporting server, Autosys scheduler, Excel, MS visio, Java and Tomcat web server

Jan 2007Dec 2009

Programmer Analyst

Cognizant Technology Solution
  • Document, develop, test and deploy changes in web application  and reporting portal
  • Consult with business user and various data team to investigate issue and prepare technical specification document based on analysis.
  • Enhance functionality of existing java programs, prepare and review test cases
  • Analyze data, write complex SQL query to prepare report requested by business user
  • Create report using Jasper soft studio & Prepare dashboard using Kava chart libraries
  • Providing 3rd level support to business process flow in the production environment
  • Monitoring production jobs, resolving issues occurred in daily operation and inform business users.

TE: Java, Oracle, Unix, IBM MQ, Jaspersoft BI, JSP, struts, Hibernate, Spring, Weblogic application server

Awards & Recognition

  • Discover Financial Service, 2014 : Global Resources Exceptional Achievement Tribute - Best of the Best team player 
  • Syntel Inc (2012 and 2013): Speed and Smart Value Award