SUMMARY

• 6 years of professional experience performing full life cycle software development, design and implementation with focus on data warehousing. Over 5 years of experience in Ab - Initio GDE, UNIX shell scripting, EME, Autosys with a good understanding of databases.
• 6 years of professional experience in performing full life cycle software development, design and implementation with focus on Data Warehousing, Data Integration and Database Applications.
• Over 5 years of experience in using Ab-Initio and UNIX shell scripts for design and development of full lifecycle Data Warehouse solutions.
• Extensive experience in Creating, Executing, Testing and maintaining graphs in Ab-Initio
• Over 4 years of experience on Teradata development.
• Extensively worked on Performance tuning the ETL (Ab-Initio graphs), UNIX shell scripts.
• Hands on experience in end-to-end Data warehousing ETL routines, which include writing custom scripts, stress testing, data mining and data quality processes.
• Over 4 years of experience in developing and maintaining Autosys jobs for scheduling.
• Hands on experience in maintaining Control-M jobs for scheduling.
• Hands on experience on DB2, Oracle and Netezza warehouse appliance.
• Good Communication Skills and Strong interpersonal skills to deal effectively with a broad range of contacts from technical staff to clients to management.
• Handled several responsibilities like Requirement Analysis, Development, Design innovations (Providing Optimal Technical Solutions), Reviews, Client interactions, offshore team anchoring and onsite-offshore co-ordination activities.

TECHNICAL SKILLS

Hardware: Pentium IV, UNIX

Software: Ab-Initio GDE, EME, Unix Shell Scripting, Autosys, Control-M, Teradata, Oracle, DB2

PROFESSIONAL EXPERIENCE

Confidential, FL

Senior Consultant

Responsibilities:

• Creating an employee compensation data warehouse to address the accounting needs of incentive compensation and benefits for Confidential .
• Creating a system which would perform accounting, generate reports for the HR dept, tax dept and business users on the compensation and benefits data of all the employees.
• Determining the integration of various products like Ab initio, People Soft and Business Objects in the application.
• Analyzing the business requirements and creating the functional design.

Environment: Ab Initio GDE 1.15, Co Operating System 2.15, EME, Autosys, UNIX Shell Scripting, Oracle, PeopleSoft, Business Objects

Confidential, Richmond

Technology Lead

Responsibilities:

• Worked as Technology Lead in IFM that receives and consolidates fulfillment requests from a diversified set of requesting sources and fulfills those requests to various systems/vendors.
• Design action types that would fit in to the existing system.
• Worked in Agile Process methodology
• Effectively interacted with business analysts, client managers and business users.
• Developed and maintained generic Ab Initio graphs, UNIX shell scripts for the end to end processing of action types.
• Implemented successfully critical fulfillments in Confidential like Loan Payments, Check Reorders, Canada Delta Partnership etc
• Mentored 8-10 people in onsite /offshore
• Implementing application in production and testing live in production, supporting existing application, analyzing and fixing production defects with quick turnaround.

Environment: UNIX Shell scripting, Ab Initio GDE 1.15, Co Operating System 2.15, EME, Teradata, DB2

Confidential, Charlotte

Technology Lead

Responsibilities:

• Worked as Technology Lead in developing and maintaining the MIP data warehouse which stores various data sources most of which are mainly brokerage and trading related data.
• Created Ab Initio graphs and UNIX scripts to extract, transform and load data in to Netezza which was used as the data warehouse environment.
• Supporting the reporting team in understanding the environment and help create views and reports
• Accessed performance/scalability issues while designing systems.
• Performed both production support and development work in parallel.
• Debugged existing applications.
• On-call responsibility to monitor and fix failed jobs in production.
• Scheduled, tested and monitored jobs using Autosys.

Environment: UNIX Shell scripting, Ab Initio GDE 1.15, Co Operating System 2.15, Netezza, Oracle, Autosys

Confidential, Charlotte

Software Engineer and Technology Lead

Responsibilities:

• Worked in DW&M project in creating & maintaining the Corporate DW and Marts
• Created detailed and technical design documents.
• Lead the HUB team which did data cleansing process. Lead a team ranging 15-20 members.
• Hands on experience on Teradata and Informix
• Worked in RDS program to make Confidential comply with Basel II Accord and in turn improve risk management practices
• Involved in creating Macro and Micro Level design documents.
• Closely interacted with the Data modeling team and mappers regarding the mapping document.
• Involved in developing the Ab Initio Graphs for various applications.
• Participated in the Software Development Life Cycle (SDLC) in all phases for Data warehouse and Data mart application.
• Involved in Scheduling the Jobs using Autosys.
• End-to-end loads for RDS.
• Writing the Unit Test Cases for the applications.
• Extensively used Ab Initio web Interface (AIW) to navigate the EME for viewing Ab Initio objects like graphs, datasets etc. and performing Impact analysis.
• Closely Interacted with System Testing Team to perform various data validation, system test, Stress test or regression test process.
• Project estimates

Environment: UNIX Shell Scripting, Ab Initio GDE 1.14, Co Operating System 2.14, EME, Autosys, Teradata