SUMMARY OF QUALIFICATIONS

Work Authorization: Green card holder
ETL Technical specialistwith five years of progressive experience in Data warehousing

• Worked in all phases of data warehousing projects including scoping study, requirements gathering, design, development, implementation and acceptance testing for end-to-end IT solutions
• Extensive experience in:
• Design & development of ETL jobs in Informatica and DataStage
• Design & development of stored procedures and queries in Oracle PL/SQL
• Design & development of scripts in Unix shell scripting
• Development of Reports in Cognos ReportNet
• Data Modeling using Erwin Data Modeling tool
• Good knowledge ofTeradata V2R5 architecture and SQL queries
• Experience supporting 24*7 production systems providing on call support for mission critical applications
• Wide experience implementing business views for various multinational clients in the TELECOM industry including Orange UK, T-Mobile (Germany) and Confidential
• Experience devising detail design & ETL Data mapping and leading teams in developing the warehouse
• Demonstrated ability to collaborate with managerial and analytical end users to construct and manage the development of business solutions for the warehouse
• Proven ability to develop warehouse business solutions efficiently within specified deadlines and handle pressure coordinating multiple tasks.

ETL Servers & Tools: Informatica 8.6.1&8.5.1,DataStage 7.5 Server Edition &Enterprise Edition
Tools, Utilities: ERWIN, MS Visio, MS Excel, MS Power Point, Toad, SQL Developer
Reporting Tools: Cognos ReportNet
Database Platforms: Oracle 9i and 10g, MS SQL Server, MS - Access, Teradata
Languages: VB 6.0, C, C++, Java, SQL, Oracle PL/SQL, Teradata SQL, Unix shell
scripting
Operating systems: Unix, Windows XP

• Successfully completed Infor matica Power Center 8 Mapping Design
• Teradata V2R5 Basics Certified Professional
• Teradata V2R5 SQL Certified Professional
• Successfully completed Cognos Certificate Program
• CompletedBrainbench certification for customer requirements analysis, business communication and presentation skills
• Advanced Java Training, CTS
• Cognizant Certified Professional in Data warehousing

Bachelor of Technology
Information Technology,
Dual Degree Program, 2002 - 2007

Bachelor of Technology
Automobile Engineering, 2001- 2005

Confidential
July 2005 - Aug 2010

Senior associate responsible for managing, designing, implementing, coordinating and successfully executing projects

Client, Project: Confidential,Enterprise Data Warehouse
Title: Team/Module Lead
Duration: Nov 2009-Aug 2010
Environment: Informatica 8.6.1, Unix shell scripting, Oracle 10G

The project involved taking charge of existing Confidential EDW modules from another organization and providing enhancement, maintenance and production support at Tier 1 and 2 levels. Being new to the system the challenge was to quickly learn the new system.

• Interacted with previous module owners to quickly assimilate the system in a very short duration and developed knowledge documents to aid other team members with the transition
• Involved in all aspects of the project: trouble tickets resolution, change requestsand enhancements
• As the lead, planned,distributed tasksand guided the team to complete tasks on time
• Introducedprocess enhancements to eliminate failureswhich was valuableto the client
• Worked on performance tuning the data extraction (involving millions of records) and data transfer forEDW. This involved working in UNIX, Informatica and Mainframe platforms
• Developed shell scripts to manage interaction between informatica jobs with other applications including CRM, ISAAC, SHOTS and SDP
• Developed and maintained shell scripts to monitor and report status of informatica jobs for various EDW applications including CRM, ISAAC, SHOTS and SDP
• Coordinated with onsite team effectively and provided status to management throughout the duration of the project

Client, Project: Confidential, U-verse Data Access Services
Job Title: Module Lead
Duration: Mar 2009 - Nov 2009
Environment: Informatica 8.6.1, Oracle 10G, Erwin

U-Verse is an Confidential product providing internet and other services. The U-Verse Data Access Services or uDASis used to handle all U-Verse related customer data including packages, billing etc.Involvedin developing the VSDA module for the uDAS system.

• Involved in requirements gathering for the VSDA module. Gained thorough understanding of U-Verse system; this ensured the new module was well designed
• Prepared functional and technical design documents for the module
• Developed data models using Erwintaking into consideration theprocess control logicfor VSDA and reporting required by downstream systems
• Developed oracle table scripts and Informatica mappings per design
• Extensively researched informatica features that could be leveraged for the desired functionality
• Provided guidance and suggestions to team members to improve and correct their designs
• Part of the team that provided 24x7 support during production and post-production phase
• Exclusively responsible for coordinating the work between offshore and onsite teams

Client, Project: Confidential Germany, BINGO Phase 1 DWH
Job Title: Module Lead - ETL Specialist
Duration: Dec 2008 - Feb 2009
Environment: DataStage Enterprise edition

Business Intelligence Next Generation Optimization (BINGO) was aimed at significantly reducingresource investments in data warehouses by decreasing project control and maintenance effort. Served as the lead forHistorization, P-Importer modules in DataStage.Also was the lead for a novelETL code generatorthat aimed at generating code for DataStage jobs using GUI input

• Effectively analyzed requirements anddeveloped proof of conceptto obtain validation from client
• Analyzed and fixed issues while setting up the DataStage environment
• Since the code generator will be used by users without Data Stage expertise, architected the code generator to be GUI based so that it is user friendly, extensible, customizable and to seamlessly integrate with DataStage
• Designed the Historization and P-Importermodulesto be reusable by researching DataStage
• As the lead, coordinated work between different teams effectively
• Delivered approach documents, understanding documents, functional & technical design documents

Client, Project:Confidential- UK, VCC Phase 3 - Single Network Queue
Job Title: Oracle PL/SQL developer &Application Support Analyst
Duration: Dec 2007 - Nov 2008
Environment: ORACLE 9i SQL and PL/SQL, JMETER

The project was aimed at re-engineering the call routing and queuing environment by centralizing all call routing decisions and queuing of all calls using Single Network Queue (SNQ) database

• Devised the required logic in Oracle PL/SQL by understanding the requirementswith in a very short time span. Fixed the bugs reported by testing team on integration tests and made the functionality fail proof
• Customer Service portal and Genesys system interface with the SNQ database. Gathered requirements and enhanced the SNQ data model to support their changes
• Designed and developed Oracle PL/SQL procedures for service configuration validation
• Worked proactively to identify uncommon call routing scenarios and worked with client to ensure the solution developed would handle them
• Conducted performance testing on SNQ database functionality using JMeter and produced reports for further analysis and improvement
• Developed unit test scriptsto determine system validity throughout out the cycle.
• Provided production support for SNQ database

Client, Project: Confidential,IBIS - ESA Implementation
Job Title: Programmer Analyst
Duration: Jul 2005 - May 2007
Environment: ORACLE 9I SQL and PL/SQL, MS SQL Server, DATASTAGE 7.5, COGNOS

Intelligence Business Integration System (IBIS) is a Data warehousing initiative that delivers analytical financial reports. The systemwas aimed at enabling decision-making and performance management for Cognizant

ESA Implementation (Nov 2006 - May 2007):
PeopleSoft Enterprise Service Automation (ESA) wasthe new system to which Cognizant got migrated from PeopleSoft 8.0. ESA implementation gave a new revision of all the eleven IBIS modules including Customer Masters, CPR, SGA, Payroll, RAMS, and Allocation

• As the development lead for a team of 7,gainedcomplete knowledge on ESA systemfrom Cognizant Finance, ESA technical team and analyzed migration impacts on IBIS reports thoroughly.
• Created new interface for the ESA data inflow onto IBIS, setup development environments, devised logical and physical ESA data models, planned, designed and guided the module leads accordingly.
• Developed ETL jobs with expertise in Oracle 9i SQL, MS SQL server and DataStage 7.5
• Conducted unit testing, user acceptance testing, obtained validation from the client for all the modules and successfully implemented ESA in IBIS production
• Managed monthly deliverables for production system while working on the new system

SBU Implementation (Jun 2006 - Aug 2006):
Two levels of Business units called Strategic Business unit 1 (SBU1) and Strategic Business unit 2 (SBU2) were added in addition to the existing organizational level hierarchy in IBIS financial reporting.

• Developed back end stored procedures, functions in Oracle 9i, PL/SQL programming.
• Developed ETL jobs and Cognos reports for the SBU1 and SBU2 hierarchy

PeopleSoft 8.0 Migration (Oct 2005 - Feb 2006):
PeopleSoft 8.0 migration was an enhancement to one of the modules of IBIS called Customer Profitability where new dimensions wereintroduced

• Developed oracle stored procedures and functions and DataStage ETL jobs
• Enhanced oracle views, SQL scripts and the dashboards in Cognos ReportNet. The dashboardspresent data from all the IBIS modules

IBIS Production Maintenance (Jul 2005 - Dec 2007):

• Developed and maintained ETL jobs, Cognos reports and Oracle stored procedures
• Automated the weekly DataStage projects backup
• Existing process for financial adjustment processing took over 4 hours to complete; collaborated with the clients to refine input data, updated the DataStage job bringing down the processing time to 4 minutes.
• Createdstored procedures for data validation and emailing the resultin oracle 9i
• Improved the performance of ETL jobs and reports by tuning the SQL queries and procedures
• Shared domain and technical knowledge with the team and documented all project changes
• Managed work for bothmaintenance anddevelopments in parallel and providing daily, monthly deliverables efficiently