SUMMARY

• Around 7 Yrs. of professional work experience in all stages of software application development and support.
• Worked in all phases of the software Development Lifecycle (SDLC) - Analysis, Design and Modeling, development, System testing, System Implementation and maintenance.
• Actively involved in ETL design, coding using Ab-Initio ETL tool to meet requirement for extract, transformation, cleansing, and loading of data from source to target data structures.
• Excellent skills in Ab-Inito graphs/Plan development and implemented number of various Ab-Initio graphs using ETL techniques.
• Designed and developed graphs using the GDE, with components partition by round robin, partition by key, rollup, sort, scan, de-dup sort, reformat, join, merge, gather, runsql, Normalize components.
• Experience of Application Development & Maintenance using various SE methodologies like Agile (Scrum), Waterfall, Iterative development.
• Good in using various partition and de-partition components.
• Good knowledge in writing UNIX shell scripting and Autosys Jil script for Job scheduling.
• Experience in Integrations of various data source systems like Flat files, CSV files, mainframes, Teradata, SQL server and Oracle.
• Well versed in OLTP and OLTP data Modelling, Data warehousing concepts, RDBMS.
• Extensively used air commands to access EME and had good knowledge on working with version controlling, creating tags.
• Experienced in developing and deploying Ab Initio graphs, unit testing, troubleshooting the issues using all latest debugging techniques and performance enhancements.
• Experience in migrating code to higher environment like UAT & Prod and providing support during migration.
• Good in respond to client requests immediately with proper attention.
• Good analytical skills in understanding the data and coming up with requirements, functional and technical design, mapping documents.
• Extensively worked in offshore &onshore model.
• Experience in creating, Scheduling and running Autosys jobs.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills.

TECHNICAL SKILLS

ETL tools: AB Initio (GDE 3.2.6), DQE(Express IT),EMH

Databases: Teradata

Other tools: Autosys (Job scheduling), udeploy, Anthil

Programming Languages: Shell scripting, SQL

Operating Systems: UNIX, Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential

Ab-Initio Lead developer

Environment: Ab Inito GDE 3.2.6,EME,Unix,Teradata,Autosys

Responsibilities:

• Participated in design of data flow from external sources until sending out the feeds to downstream environments.
• Created high level and low level detailed technical design documents for the project.
• Involved in creating An Initio generic graphs to extract/load data and processing graphs to apply the transformation on the data to apply business rules on the data.
• Developed and Implemented extraction, transformation and loading the data from the legacy systems using Ab-Initio.
• Developed Ab Initio scripts for data conditioning, transformation, validation and loading.
• Involved in writing the scripts to run the graphs, to load into Data Warehouse and to verify the counts while loading.
• Developed shell scripts to automate file manipulation and data loading.
• Was responsible and took complete ownership of the tasks and kept the client with updated status.
• Coordinate with offshore team for the project status and deliverables.
• Used EME data store to check-in and checkout the code.
• Working on DQE projects to help end user in generating issue reports.
• Working on Metadata Hub to setup end to end lineage among projects.
• Design and implement corrective measurements based on production issues and tickets.

Confidential

Ab Initio Developer

Environment: Ab-Inito GDE 3.2.5, EME, Unix, Teradata, Autosys.

Responsibilities:

• Interacting with Onsite Coordinators for Requirements Gathering.
• Understanding mapping documentation.
• Technical Requirements Analysis and preparing technical design decisions.
• Development of ETL process and UNIX scripts.
• Scheduling Jobs
• Taking Responsibility of project role outs and implementations within the specified SLAs.
• Validate ETL mappings during the mock testing phase.
• Unit testing of ETL process, UNIX shell scripts.
• Integration testing of ETL process, UNIX shell scripts and queries.
• Analysis, Research, Coding, and Testing of project initiatives.
• Created high level and low level detailed technical design documents.
• Was responsible for maintenance of prod/non-prod environments at times looking for any failures and quick fixes.
• Participated in designing the scheduling process for the module and made sure all the jobs run without any contention.
• Worked with migration teams and DB teams during major releases.

Confidential

Ab Initio Developer

Environment: Ab-Inito GDE 3.2.5, EME,Unix,Teradata,Autosys.

Responsibilities:

• Interacting with Onsite Coordinator for requirements Gathering, Requirement Analysis.
• Understanding mapping documentation, Preparation of detailed design document.
• Development of ETL process and UNIX scripts.
• Taking Responsibility of project role outs and implementations within the specified SLAs.
• Validate ETL mappings during the mock testing phase, Unit testing and Integration testing of ETL process, UNIX shell scripts and queries.

Confidential

Informatica Developer

Environment: informatica 9.1,Unix