SUMMARY:

• Over eight years (8) of experience in analysis, design and development of data warehousing solutions along with developing strategies for Extraction, Transformation and Loading (ETL) using Ab Initio.
• Strong knowledge of data warehousing concepts and Dimensional Modeling such as Star Schema and Snowflake Schema.
• Extensive experience using various transformations, creating sandboxes, check in and checkout graphs from EME, air commands and dependency analysis.
• Created generic graphs/functions for applications to eliminate redundancy.
• Proficient in integration of various data source systems such as Flat files, Excel, CSV files, mainframes, DB2, Teradata, SQL server and Oracle.
• Worked with various Teradata utilities such as BTEQ, Fast load, Multi - load and Fast export.
• Proficient in SQL, PL/SQL with expertise in Stored Procedures, Triggers, Index and Table Partitions.
• Expert in designing UNIX shell wrappers, automating jobs and Oracle PL/SQL programming.
• Experience creating Autosys JILS for inserting, deleting and updating jobs in various environment instances by using Autosys Scheduler.
• Strong experience in performance tuning of Ab Initio graphs and query optimization.
• Proficient in optimizing the load process using explain plans and collect statistics.
• Proficient in requirement gathering, system analysis, impact analysis, technical/functional specifications of the project, and managing offshore/onsite models.

SKILL:

ETL Tools: Ab Initio Co>Op 3.x/2.x, GDE 3.x/3.x/1.x, Express, It 3.2.x, Conduct it

Databases: Oracle 11g/10g/9i, Teradata 12, DB2, MS SQL Server 2012

Other Tools: SQL Assistant, TOAD, Clear Case, Quality Center, Control Center

Programming Languages: C, SQL, UNIX Shell Scripting, PL/SQL

Scheduling Languages: Autosys, Tivoli, Control-M, CA7

Methodologies: ER Modeling, Star Schema, Snowflake Schema

Operating Systems: Windows 2000/2003/XP/Vista/7.0/8.0, UNIX, MVS Mainframes

EXPERIENCE:

Lead Ab Initio Developer

Confidential, Atlanta, GA

Responsibilities:

• Responsible for performance improvements, establishing graph lineage and addressing code redundancy issues to reduce future maintenance costs
• Decommissioned any redundant codes and streamlined the existing codes
• Worked with source system SME/owners to understand the source data and how it could be sourced into data lake
• Prepared design documents of the application adhering to standards and best practices
• Identified repeatable patterns and made use of generic graphs to reduce code redundancy and maintenance costs
• Designed the standards to be followed for storage and user access
• Worked with the PMO team providing regular updates, and set the timelines for completing the project
• Developed the applications as per design specs within specified timelines
• Defined the EME parameters for the graph lineage to be established
• Graphs were run in parallel between dimes and atlas servers and the lrfs when joined on all keys resulted in zero records
• Exceptions were documented, and exception approvals had to be obtained from the application SME and business users
• Responsible for UAT, Prod migration and post implementation support in the warranty period

Environment: Hadoop File System, Data Lake, Ab Initio 3.3, Linux, shell scripting, MS SQL, Oracle, DB2, Control Center, CA7, Ab Initio Conduct, IT-Plans

ETL Team Lead/Sr.Ab Initio Consultant

Confidential, Irving, TX

Responsibilities:

• Deployed over 200 IR2 reporting enhancements in a two-year span which improved the reporting quality and yielded the expected benefits for IR2 loans
• Attended daily cross-functional discussion calls with the operations team, risk management team, compliance team and regulatory oversight team regarding enhancements and logic changes in reporting perspective. The cadence of these discussions also provides the opportunity for real time troubleshooting and research of any improvements in the existing process
• Worked on enhancements which include business logic changes, business process changes, continued automation of IR2 processes and issue resolution
• Resolved a large population of IR2 edits and worked on new MHA changes or any new additions to MHA programs
• Worked with front end (reporting) teams to understand their data display capability, create the necessary Dimension and Fact tables and populate them
• Created a validation layer and response file creation system to validate and provide an automated response to the source systems indicating the errors in the data they sent over and scheduled those using Autosys
• Supported adhoc requests along with development, resolving escalated customer issues, as well as improving the integrity of the data we were trying to report. These requests also included edit check reject analysis, loan level analysis, logic requests, APEX process analysis, and service release loan analysis
• Worked with the source team and data modelling team to understand/standardize the data layout
• Provided estimation of the software development efforts
• Prepared the design documents for Ab Initio graphs that were modified or added, followed coding standards and naming conventions, and maintained defect and review logs
• Worked with the offshore team to develop/modify Ab Initio graphs along with UNIX shell scripts and automated using Autosys
• Checked the quality of software and determined the degree of compliance before implementing
• Responsible for UAT, post implementation production support and implementation
• Worked with the PMO team, providing regular updates and set the timelines for completing the project

Environment: Ab Initio 3.2.1, UNIX shell scripting, MS SQL, Oracle, Apex, Autosys, Teradata

ETL Team Lead/Sr. Ab Initio Consultant

Confidential, Irving, TX

Responsibilities:

• Gathered requirements, analyzed them and designed an ETL solution
• Estimated the software development effort
• Prepared the technical design, DLD and HLD documents
• Set the process to follow coding standards and naming conventions while developing the codes and maintaining the defect tracker, query log and review logs
• Worked with the offshore team for developing the Ab Initio code
• Worked with source team, Citisft team and Medalia team to set up the SFTP file transfer processing and analyze the source/target layouts that needs to be used
• Set up exception reporting process which sent rejected data back to the source team along with description of the defect
• Automated mailing scripts to send an email if the source files are not received as per SLA and also for any failures or successful transmission of Target files
• Automated the developed Ab Initio jobs along with mailing shell scripts using Autosys scheduler
• Checked the quality of the software and determined its degree of compliance before implementation
• Responsible for UAT and post implementation support
• Worked with the PMO team, providing regular updates and set the timelines for completing the project

Environment: Ab Initio 3.1.1, UNIX shell scripting, Oracle, Teradata, Autosys

Sr. Ab Initio Developer

Confidential, Irving, TX

Environment: Ab Initio 3.1.1, UNIX shell scripting, Oracle, Teradata, Autosys