PROFESSIONAL SUMMARY:

• 9+ years of diversified experience in managing information business intelligence initiatives, enterprise data warehouse development, implementation, production support & Maintenance.
• Close to 5 years of strong functional exposure in US Banking & Financial Markets.
• Over 3 years of experience working at client location, engagement and delivery.
• Excellent hands - on, designing, defect fixing, optimizing, troubleshooting skills in Ab-Initio ETL tool.
• Proficiency in data migration development from various environments using Ab Initio Viz., from Mainframe Legacy Systems, Oracle, DB2, Informix to Teradata.
• Distinctive ideas generator with problem solving, business analysis, design and process acumen.
• Elegant communication & articulation skills.
• Extensive people management skills like leading teams and great capacity to succeed in challenging situations politically and technically.
• Result-focused with strategic foresight, clarity and exceptional documentation.

TECHNICAL SKILLS

DWH Toolset: Ab Initio 3.0

Scheduler: Autosys

Languages: Unix Shell Scripts, SQL

Databases / RDBMS: Oracle, Teradata V13, DB2, MSSQL

Version Control: CA Harvest, MS Visual Source Safe, EME

Change Management: BMC RARS

Testing Tools: HP Quality Center,Rationale ClearQuest

OS: Windows XP/Vista, Linux

PROFESSIONAL EXPERIENCE:

Ab-Initio Lead

Confidential, Charlotte, NC

Responsibilities:

• Onsite - offshore coordination & lead a team onsite of size 2(Onsite) + 7(Offshore).
• Plan, Estimate, Co-ordination with teams, Code Review, Work status tracking, Client communication, Production release & implementation.
• Apart from Quarterly releases, to address Problems, data issues and production incidents requiring permanent code fixes.
• Platform level initiatives to stabilize the environment brought up usage of Conduct>IT Plans to better handle the job functionalities.
• Created design patterns in the Sourcing to enable homogeneity in code delivery across the organization.
• Research performance issues and optimize graphs for better performance and resource usage.
• Optimize SQL in Teradata and reduce data skew issues.

Role Dimensions: Unix(Korn Shell), Ab-initio (co-op V3.0.4.10), GDE 3.0.4.2,Autosys, Web EME, Teradata 13, Oracle, Harvest, PAC 2K & MS office.

Ab-Initio Sr Developer

Confidential, Charlotte, NC

Responsibilities:

• Gather Requirements from Business Teams
• Understanding High Level Design and Detailed Design documentation and prepare Test Scenarios and Test Cases.
• Create a DFD(Detail Functional Design) and HLA (High Level Assessment)
• Assist Testing teams in preparing Test Plans for System Testing
• Documentation, Post Implementation verification Testing.
• Lead development teams from multiple vendors and orchestrated a successful inter-vendor delivery model

Role Dimensions: Unix (Koran Shell), Ab-initio (co-op V3.0.4), and GDE (V3.0.4), Autosys, Web EME, Unix, Harvest, PAC 2K & MS office.

Ab-initio Sr Developer

Confidential, Charlotte, NC

Responsibilities:

• Onsite - offshore coordination & lead a team onsite of size 2(Onsite) + 5(Offshore) for STOC team.
• Develop and maintain UNIX shell script for the ETL process and also for automate the system monitoring.
• Development of Autosys Jobs for the STOC process schedules.
• Involved in UAT setup coordination and to follow the release procedures upon sign-off.
• Application support lead, root-cause analysis and problem management.
• Defect Triage, Defect Analysis, Application re-design for CPU cost minimization, creating design/problem patterns.
• Performing Data Analysis and enhancing the technical architecture based on the demands from the business users.
• Involved in designing the interfaces with other applications based on different modes and requirements.
• All ETL batch programs are developed in AB-Initio and are wrapped in UNIX shell scripts and scheduled using Autosys Job scheduler.
• Convert the Functional requirements to Technical Design and tracking the same with Requirement Traceability Matrix (RTM).
• Co-ordinate with SQA for all the data security and Quality.
• Co-ordinate with multi location development projects for the timely delivery

Role Dimensions: Ab Initio(V2.14), Teradata,DB2,Oracle 10g, SQL, PL/SQL, UNIX (Korn Shell), Autosys, HP Quality Center, HP Service Manager

Ab-initio Sr Developer

Confidential, Columbus,OH

Responsibilities:

• Gather Requirements from Business Teams
• Develop and maintain UNIX shell script for the ETL process and also for automate the system monitoring.
• Create a DFD(Detail Functional Design) and HLA (High Level Assessment)
• Assist Testing team in preparing Test Plans for System Testing
• Creating load ready files using Ab Initio ETL tool to load into database.
• Develop Generic graphs using Psets and PDL.
• On-Site, Offshore Co-ordination
• Co-ordinate with SQA for all the data security and Quality.
• Performance improvement and optimization

Role Dimensions: Ab Initio GDE2.15, Co-Op2.15, Erwin 5.3.2, Teradata V2R6, Oracle, UNIX (Korn Shell), Oracle 10g

Ab-initio Developer

Confidential, Boston, MA

Responsibilities:

• Extensive development using Ab-initio and PL-SQL
• Understanding High Level Design and Detailed Design documentation and prepare Test Scenarios and Test Cases.
• Assist Testing team in preparing Test Plans for System Testing
• Leading all Offshore activities
• Planning and effort-estimation with Onsite.
• Configuration and set-up across all environments for testing and development.

Role Dimensions: AbInitio GDE2.15, Co-Op2.15, EME, Korn shell scripting, Mercury Quality- center 9.0, UNIX,PL

SQLAb-initio Developer

Confidential, Tampa, FL

Responsibilities:

• Involved in requirement study, analysis and design of the system.
• Involved in defining programming standards, database design, program development and finally testing and implementing the system
• Used EME for checking and checkout for graphs and also maintains graph versions.
• Designed and developed the Ab Initio graphs to standardize the data validation
• Written JIL scripts for the corresponding graphs and deployed in the Dev Environment.
• Coordinated the Development and Implementation of Strategic Plans

Role Dimensions: AbInitio GDE2.15, Co-Op2.15, EME, Korn shell scripting, Mercury Quality- center 9.0, UNIX,PLSQL

Software Engineer

Confidential

Responsibilities:

• Developed and implemented processes that apply business rules to the customer and revenue data.
• Report Generation such as Master/Detail, Cross Tab and Chart.
• Configuration of the data profiler
• Development of the data analysis Reports.
• Implement Teradata Index techniques to improve the query performance
• Loading data into warehouse from different sources using Multiload and Fastload to load millions of records.
• Performed tuning and optimization of complex SQL queries using Teradata Explain. Created several custom tables, views and macros to support reporting and analytic requirements.
• Involved in creating Partition Primary Index, Secondary, Join and Hash indexes for efficient access of data based on the requirements.

Role Dimensions:Ab Initio2.15, Oracle 8i, Teradata V2R4, BTEQTpump, FastLoad, COBOL, UNIX