PROFESSIONAL SUMMARY:

• Over 7+ years have experience Abintio, SQl and unix shell scripting for data warehouse environments.
• 1 yrs Experience in Tableau tool in latest Design and Presentation.
• Work in a globally distributed team that will deliver Business driven projects and IT solutions for Data & ETL requirements for Insights and non - Insights spaces.
• Adhered to local development guidelines, standards, best practices and procedures as well as SDLC.
• Analyze requirements and develop ETL/BI reports with minimal supervision.
• Design and develop BI programs with consideration to data quality, data integrity and performance.
• Productionize the ETL changes by going through the review and approval processes by interfacing with different teams like engineering, operations and DBAs.
• Provide support to the Business in adhoc query space.
• Interface with the business team and business analysts, support QA & UAT Testing, deployment, and Level 3 support for Data & ETL.
• I worked on DQE (Data Quality Environment) to report the data quality checks in the data.
• I have knowledge on business rule Eviroment (BRE) to generate transformation.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Excellent knowledge of and experience with data warehousing/data marts concepts and practices viz. Abinitio and Sqoop is a must.
• Experience in BigData technologies like Hadoop, Sqoop, Hive, and HDFS.
• Excellent communication skills, both written and verbal.
• Manage scheduling (using Tivoli), support, tools and maintenance of integration processes.
• Experience in integration of various data sources such as flat files, ASCII, EBCDIC, Unicode and XML files, DB tables etc.
• Ability to co-ordinate effectively with development team, business partners, end users and management.
• Experience in Banking and card applications along with insurance applications.
• Highly experienced in working Onshore-offshore model. Has extensive experience as Lead coordinating with 7 member offshore team to deliver client projects.

TECHNICAL SKILLS:

Technology Specialization: Ab initio GDE 1.14 & 3.2.2, Co-operating System 2.14 & 2.5, Big data Sqoop ETL, HDFS, Tableau, DQE Express>it, ACE, BRE, Metadata Hub

Operating Systems: UNIX, LINUX

Scripting: Shell scripting

Database Technologies: db2, Oracle 9, 10g, SQL server

Tools: /Utilities/Packaged Software

PL/SQL Developer, Toad, Control: M, Tivoli Scheduler, HP Quality Center, Microsoft Office Tools (WinWord, Excel, Project, PowerPoint, Visio, Internet Explorer).

PROFESSIONAL EXPERIENCE:

Confidential, Brea, CA

Abinitio Developer

Responsibilities:

• Gathering requirements, design and implementation of data extracts, transformations and reporting between various interfaces across the landscape, using Ab Initio integration framework, implementing change requests and maintenance tasks.
• Developed Generic graphs for data cleansing, data validation and data transformation.
• Involved in developing totally metadata driven architecture.
• Involved in creating detail data flows with source and target mappings and convert data requirements into low level design templates.
• Worked with Departition Components like Concatenate, Gather, Interleave and merge in order to departition and repartition data from Multi-files accordingly.
• Worked with Partition Components like Partition-by-key, Partition-by-expression, and partition-by-Round Robin to partition the data from serial file.
• Using Metadata Importer for importing Metadata from an EME Technical Repository and other sources like ETL tools (Abinitio), reporting tools ( Tableau, Sqoop etc) and databases (Oracle, DB2 etc.).
• Worked on improving the performance of Ab Initio graphs by employing Ab Initio performance components like Lookups (instead of joins), In-Memory Joins, and Rollup and Scan components to speed up execution of the graphs.
• Tuned the Graphs by creating Lookup files, Memory sort and Max-core parameters for maximum usage of cache memory and to enhance the performance.
• Importing the Erwin Logical and Erwin UDPs Feeds for the Logical Models.
• Importing the EME Datasets and EME Graph Imports for building the Data Lineage.
• Importing the EME Datasets and Data Profiler results from EME to Technical Repository to show up the results in the Metadata portal.
• Importing the Business Data Definition Matrix feeds.
• Built generic applications in Ab-Inito ACE (Application Configuration environment) which can be dynamically modified by Business Analysts.
• Built re-usable transformation rules using Ab Initio BRE (Business Rules Environment) to help business analysts validate and plug the generated transformations in the graphs.
• Developed dynamic graphs to load data from data sources into tables and to parse records.

Environment: Ab Initio, Metadata Hub, ACE>BRE,Tivoli, EME, Tableau, Oracle, DB2, Linux

Confidential, Detroit, MI

Abinitio Developer

Responsibilities:

• Worked closely with the Business Analysts and Application Leads for Requirement study, Analysis and design of the application.
• Created low level design documents for various application processes.
• Developed Ab Initio graphs that transfer data from flat files to oracle data warehouse
• Extensively worked on most commonly used components to complex components like Scan, Rollup, Assign Keys, Partition, Departition, Sort, Join, Reformat components etc.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Developed different types of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition, reformat, rollup, join, scan, normalize, gather, sort, dedup sorted etc.
• Used Ab Initio’s Multifile systems for improving heavy data loads.
• Migration of Ab Initio Objects from development to QA environment and prepared appropriate documentation for code move to QA and production environment.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Prepared Unit test plan, Unit test release for developed Graphs by using mapping documents.
• Modified Ab Initio Graphs according to the new modifications.
• Involved in end to end data validation by interacting with the business (UAT).
• Implemented Lookups, lookup local, In-Memory Joins and rollups to speed up various AB Initio Graphs.
• Created various Ab Initio Multi File Systems (MFS) to run graphs in parallel.
• Developed Data transformation, loading and extraction programs using Ab Initio ETL tool.
• Validating graphs, Performed unit testing, regression testing and integration testing.

Environment: Ab Initio, Oracle, IBM DB2, TOAD, Autosys, UNIX.

Confidential, Chicago, IL

Abinitio Lead

Responsibilities:

• Involved in requirement analysis and designing the Ab-initio code changes for Allbridge system.
• Involved in converting all the graphs & scripts from UNIX server to Linux server.
• Involved in building interface between EME and GDE.
• Developed new graphs by using database, datasets, interchange, internet, metadata, partitioning, sort, transform, translate, validate, xml components based on the requirements from users and checking in the changed code in to EME.
• Primarily responsible for EME cleanup activities and version management for all the objects.
• Involved in changing the logic of all the xfr’s based on the lines of business.
• Allbridge has to allow new values for some deductible amounts based on new policies and new companies.
• Changing the code in the formats where the business of policies has changed.
• Working with outside partners to understand the data and impacts after disabling unwanted logic and how the new data flows.
• Create huge volume of files by using sqoop and HDFS to transfer files to upstream.
• Developing code in xfr’s by using math functions and adding rollup component to calculate the agent’s commissions based on the number and type of policies that customers have signed with them.
• Responsible for data quality check and generating reports for exceptional records.
• Involved in coordinating with downstream teams for processing the exceptional records.
• Cleaning up the redundant code in ab-initio xfr’s due policy discontinuation.
• Responsible for coordinate development activities with off shore team.
• Involved in defect resolution by using tools like HP-QC.
• Primarily responsible for Code Review and approval.
• Hosting daily status calls with Client and off shore team.
• Creating Scripts for new graphs and scheduling them with Tivoli.
• Export and Import data into HDFS and Hive using Sqoop.
• I worked on DQE (Data Quality Environment) to report the data quality checks in the data.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• I extensively worked on Data profiler to analyze, improve and profile the input data.
• Production Support for Allbridge and ADWAE.
• Responsible for project delivery within the agreed schedule.
• Working with SOX partners to get SOX validation for the projects.
• Handling QA and Production Migration Activities.
• I have involved in hyper care activities for all the projects.

Environment: Abinitio, EME, HDFS, Sqoop, Tivoli, ACE>BRE, SOX, Tableau, HP Quality Center, Linux.

Confidential, Phoenix, AZ

Abinitio Developer

Responsibilities:

• Involving in Requirement’s gathering & high level design.
• Developing of Ab Initio graphs that run on a daily & weekly basis.
• Daily interaction with the Client for the requirements/development activates which will make development faster and helps in process improvement.
• Developing of graphs to generate the delta feeds and the files are transferred to downstream.
• Developing of Ab Initio graphs that runs on a monthly basis.
• Developing of Connect graphs that acts as a bridge to the downstream system’s load processing.
• Promoting the code changes to testing & production environments.
• Explaining the code changes to QC team and validating the QC test cases.
• Promoting the changes to production after getting all the required approvals in process.
• Providing the 60 days warranty and KT on the code changes to production support to keep supporting the new code changes.

Environment: Ab Initio, DB2, Cotrol-M, HP Quality Center, UNIX.

Confidential

Abinitio Developer

Responsibilities:

• Involving in Requirement’s gathering & high level design.
• Developing of Ab Initio graphs that run on a daily & weekly basis.
• Daily interaction with the Client for the requirements/development activities, which will make development faster and helps in process improvement.
• Developing of graphs to generate the delta feeds and the files are transferred to downstream.
• Developing of Ab Initio graphs that runs on a monthly basis.
• Developing of Connect graphs that acts as a bridge to the downstream system’s load processing.
• Promoting the code changes to testing and production environments.
• Explaining the code changes to QC team and validating the QC test cases.
• Promoting the changes to production after getting all the required approvals in process.
• Providing the 60 days warranty and KT on the code changes to production support to keep supporting the new code changes.

Environment: Ab Initio, DB2, HP Quality Center, Unix.