Summary

I have more than ** years of data modeling, data migration/conversion, data mapping, data warehouse architecture, design and re-engineering, Full SDLC, ETL, Data Warehousing architecture, ETL tools like Informatica Powercenter, IBM Ascential Datastage, Oracle Warehouse Builder, C and C++ development and UNIX experience. I have worked with Oracle 10g/9i/8i/7x, DB2 UDB 9x/8x/7.5, Teradata, SQL Server 2000. I also have ten plus years experience as a Technical Lead where I had major roles in planning and managing development workloads for a 10+ member team. Have excellent communication skills and inter-personnel skills.

Education

Master’s in Computer Science and Engineering (1996-99)

University of Texas at Arlington, Arlington, Texas

Work Authorization Profile

US Citizen ( Eligible to work for any Employer )

Training & Certifications

Siebel CRM Software

Oracle 8i Database Administration

Informatica Designer Track

Java 1.2

OLAP tools (Information Advantage Inc).

Skills

Languages: C, C++, Pro *C/C++, Perl 5, HTML, UNIX Scripting

Systems: HP 11.x, SunOS, IBM AIX 5.x, Windows 95/98/XP/2000/NT, DEC VMS 6.2

ETL Tools: Oracle warehouse Builder 9.2, Datastage 8.0.5/7.5 administration/development, Informatica PowerCenter 8x/7x, 6.x, 5x/4.7

SQL Tools: ER Rapid SQL, Toad for DB2/Oracle, PL/SQL Developer, Golden for Oracle.

Databases: DB2 8x/9x, SQL Server 2000, Teradata, Oracle 10g/9i/8i, 7.x (PL/SQL, Pro *C, SQL Loader)

GUI/Tools: Visual Basic 5, VBA, ActiveX controls, OLAP tools, TOAD, ER Rapid SQL 7.2.4

OOA/OOD: Rumbaugh’s OMT

Version Control: SCCS, StarTeam 4.2.x, CA Harvest 7.1

Utilities: Syncsort HP-UX 3.x, Optsort HP-UX.

Office Tools: MS Excel, MS Project, MS Word, MS PowerPoint etc.

Design Tools: Star Schema, Snow Flake Schema, Erwin 4.1.x, MS Enterprise Manager

Testing Tools: Quality Center 9.0, Home Grown tools.

Experience

U.S. Cellular®, Bensenville, IL March 10 – Present

ETL/Informatica/Data warehouse Consultant

Worked on a new telcom marketing initiative called, The Belief Project, for last nine months. This project has some key business features like, Auto Pay Bill Suppression Discounts, Rewards, and Phone Replacement etc. The project also involves adding 25 plus new post-paid calling plans as well as few new devices using the Android Mobile OS.

My role is to design, develop and implement these changes using the U.S. Cellular® current SDLC processes and existing technologies. The tools we used here included, but not limited to, UNIX scripting, Informatica development like mappings, sessions and workflows, and database development on few one time data patch requirements.

Environment: Star Schema, ETL, Informatica Powercenter 8.6.1, Designer, Workflow Manager, Monitor, IBM AIX 5.2, Unix Scripting, Oracle 10g, Toad 10, U.S. Cellular® SDLC, C Programming.

Chicago Business Intelligence Group Oct 09 – Feb 10

ETL/Datastage/Data warehouse Consultant

Deerfield, IL

Worked on a short term project for a pharmaceutical company in Deerfield to create an Incentive and Compliance reporting data warehouse. The project is related to drug direct/redistribution sales and incentive program that are used to reward the client customers. The data warehouse is a project involving 3 fact tables with 6 dimensions. The source of the data is JD Edwards’s system on AS400. The target database is SQL Server 2005. The ETL tool is Datastage 8.0.1. I am involved in all phases of the project including technical analysis, design, development and User Acceptance Testing.

Environment: Star Schema, ETL, Sybase PowerDesigner 12, IBM Datastage 8.0.1 Designer, Director, Unix Scripting, SQL Server 2005 MS, SSIS, SQL, AS 400.

AON Re / Accenture LLP Jan 09 – Sep 09

ETL Architect/Senior Datastage Developer

Chicago, IL

Worked on a project, Management Information Program (MIP), which is a data warehouse containing the financial information from 35 countries where AON Re does business. The data warehouse information is related to re-insurance for business customers. The data warehouse is written in Oracle Warehouse builder and the client is intended to move to Datastage to align with company’s present and future global technical architecture and tools. I was brought in with two specific tasks, one to re-engineer the Oracle Warehouse Builder mappings/jobs and guide the off-shore team to re-write the mappings/jobs using Datastage 8.0.1 and also architect a repeatable archival process for the Data Warehouse. The project involved 100+ mappings/jobs and a few shell scripts. I was also involved in developing the project plan, assisting the management for resource allocation etc.

Environment: Star Schema, ETL, Oracle Warehouse Builder 9.2, Datastage 8.0.1 Designer, Director, IBM AIX 5.2/5.3, Oracle 9i, SQL, PL/SQL, UNIX Scripting, Toad for Oracle, SharePoint Portal, Window NT.

Walgreens Co May 08 – Nov 08

Deerfield, IL

ETL Consultant

Presently working as a Datastage /ETL specialist for POWER Metrics Reporting Team at Walgreens Co. POWER Project is a new initiative at Walgreens Co which aims at improving the Prescription Fill Time as well as reducing the total costs. The new initiative is a real-time system which is built on C/C++ with embedded SQL and Tuxedo on IBM UNIX Systems. Reporting Team, which I work for uses Datastage ETL tool to stage, load, merge and aggregate the POWER data. Our team also produces a numerous reports at granular level by hour, by week, by month etc. I am also involved in supporting the new development/maintenance for each release.

Environment: Star Schema, ETL, IBM Websphere Datastage Designer, Director, Monitor, Administrator 8.0.5, SQL, IBM AIX 5.2/5.3, Oracle 10g, PL/SQL, UNIX Scripting, Golden Query Tool, Toad for Oracle, SVN Tortoise for Code Management, Window NT.

Bradford Exchange Dec 07 – April 08

Niles (Chicago), IL

Informatica Upgrade Project

Worked for Bradford Exchange Group to upgrade the Informatica 6.2.1 to 8.5.1 because of the special needs around security and also client’s interest in moving away from unsupported informatica powercenter 6.2.1 version. I am also responsible for design and development of functional, integration and performance test plans, execution and publish the results with various groups. I am also involved in evaluating the needs of the client to move from 32bit Powercenter to 64bit powercenter with the new version and working closely with the management in helping them to understand the cost vs. benefit. This project does not involve any training of the full-time employees involved with the new features of the upgraded version. The project also involves the code migration at folder as well as mapping level to allow simultaneous development and Informatica Upgrade, as well as support as an administrator for a medium size team by writing the scripts, helping resolve the production issues and also performance related issues for version 6.2.1 as well as 8.1.1/8.5.1. I have also modified the scripts for backup as well as startup and shutdown of the Informatica server in different versions.

Environment: Informatica Powercenter 6.2.1/8.1.1 sp4/8.5.1, Informatica Meta Data Manager, IBM AIX 5.2/5.3, IBM DB2 UDB 8.5x/9.x, IBM z/OS Mainframe, UNIX Scripting, Oracle 10g/9i/8.0.5, Toad 3.1 (Trail version) for DB2, Query Tool for DB2

Informatica/Data warehousing Technical Lead May 07- Dec 07

Wachovia Securities, Chicago, IL

Worked in a Brokerage Data Management Group, which is responsible for managing the Brokerage Data warehouse (BDW) for Securities. This group is responsible for supporting the company for all data needs with respect to regulatory requirements as well as Business related data requirements. The group has shared resource model with on-site design/off-shore development Structure. I am responsible in taking the requirements and create design for ETL and manage/coordinate with the offshore resources to develop and test the code. Once the development cycle is done, Tech Lead is also responsible to move the project other phases of Wachovia SDLC. I have worked on couple of projects in last 4 months. Each one is a medium size project involving around more than 2000+ man-hours.

Environment: ETL, Informatica 7.1.3 Designer/Workflow Manager/Repository Manager/Monitor 7.1.3, SQL, DB2 9x/8x, Oracle 9i, PL/SQL (Stored Procedures, Functions), TOAD 8x, WinSQL, MF DB2, DB2 Direct Connect, Erwin 4x, Erwin Model Mart, IBM AIX 5.2, Unix Korn -Shell Scripting, Window NT, MS Excel, MS Word, MS Outlook etc.

Independent Contractor/ETL Specialist Feb 06 – April 07

Client: Yellow Roadways Corporation Worldwide (YRCW)

Overland Park, KS

Worked as a Technical Lead/Senior Informatica Expert for Yellow Roadways, a transportation company based out of Kansas City, KS. I am involved in all phases of the Yellow Marketing & Sales Campaign Data warehouse including data discovery, ETL architecture, High Level ETL design, and ETL development and test strategy.

I have helped the team in Data Discovery (analysis of different source systems), assisting with resolving the technical issues with DB2 Connect to use the DB2 connect gateway server. And also helped the team to write the ETL specifications once the functional specifications are reviewed and approved by the business team. And also assisted the team in managing the development of ETL mappings /mapplets and workflows as well as scripts to automate the production job flows. And was also involved in the developing the comprehensive test strategy and test plans and repeatability of execution and verification process of the testing for the project.

I have also worked as an administrator to resolve architectural level performance related issues with Informatica PowerCenter setup. This involved reducing the network traffic by installing the PowerCenter server on two different geo-graphical locations vis-à-vis sources and targets. Also involved folder setup, user/group creations, code migrations as well as other regular administration tasks like backup of the repository etc.

Roles and Responsibilities

Estimate the size required for database to load the source systems.

Help the team as an Informatica administrator by performing the backup of the repository as well as code migrations on regular basis.

Create source to target mappings along with transformation rules.

Write some complex queries to get the data out of the M/F DB2, VSAM Flat Files, and other heterogeneous sources into Oracle 9i

Help the team to write some quick ETL to load the source tables in Data Discovery area.

Assist the team to make the architectural decisions.

Design the approach for initial as well as daily change capture processes

Create technical design documents/technical specifications including flows

ETL Development Team technical screening and manages the development team.

Continuously coordinate Status/Issues with the Project Manager and help plan the project resources utilization to meet the project timelines.

Environment: Star Schema, ETL, Informatica 7.1.2 Designer/Workflow Manager/Repository Manager/Monitor 7.1.2, SQL, Oracle 9i, PL/SQL (Stored Procedures, Functions), TOAD 8x, WinSQL, MF DB2, DB2 Direct Connect, Erwin 4x, Erwin Model Mart, IBM AIX 5.2, Unix Korn -Shell Scripting, Window NT, MS Excel, MS Word, MS Outlook etc.

Senior Data Warehouse Consultant Aug 05 – Feb 06

Sogeti USA

Client – Children International

Worked on a project for building a data warehouse for a non-profit organization in Kansas City, MO as a senior data warehouse consultant. I have handled four major business areas as a data warehouse architect/senior developer. The business areas are: Child Status (Historical and Daily Loads), Marketing Campaigns (Historical and Daily Loads), Revenue and Orders for Daily loads. I am also involved in the administration in a support role.

Roles and Responsibilities:

Involved in requirements collections sessions with users for about 2 to 3 days in a week.

Developed the logical model using the star-schema design model.

Documented the requirements by producing the mapping documents.

Translated the logical model/requirements into physical model and business rules.

Produced the mapping documents for development of the ETL jobs.

Developed the jobs/mappings, sequences and unit test documents.

Involved in getting buy-off from the users on the historical data brought into data warehouse.

Developed the test cases for the historical as well as daily jobs.

Involved in running the test cases and getting sign-off from the users.

Environment: Star Schema, ETL, IBM Ascential Datastage Designer/Director/Monitor/Administrator 7.5, SQL, Transact-SQL, DTS, SQL Server 2000, Query Analyzer, Enterprise Manager, Stored Procedures, Aptify ERP system, Window NT, MS Excel, MS Word, MS Outlook etc.

Sogeti USA

Client – American Century Investments Inc.

Kansas City, MO

Worked on an 8-week project at American Century Investments Inc (20th Century Investments Inc) for rewriting the Mutual fund manager performance and bonus payout software. The existing software has been written in SAS and DB2 and has the hard-coded parameters in the code. It is kind of hard for the client to adapt easily to changing business needs. A Sogeti team was brought in to analyze and provide LOE and rewrite the system so that most of maintenance issues would be resolved.

Environment: Star Schema, ETL, Oracle, ER 6.0, SQL, PL/SQL, Stored Procedures, UNIX Scripting, Window NT, MS Excel, MS Word, MS Outlook etc.

Systems Development Lead Oct’01 - June’05

Sprint, Overland Park, KS

Presently working on a One Sprint Financial Information Systems data warehouse. In this project, Sprint is planning on bringing in the multi-divisional (LTD, LD, PCS) customer and revenue information into one warehouse to make it easy for analyze, follow market trends as well as reporting. The other advantage includes providing bundled services. This project also involves bringing in the 2 years history for revenue and complete historical information for customer. I have been involved in creating approach for history creation as well as system design.

Environment: Ab Initio, Teradata, Mainframe, JCL, Shell scripting, C, Pro*C, SQL Plus, Oracle 8.1.6,

HP-UX 11, TOAD, Syncsort HP-UX/LFS Release 2.4.10.

Development Team Lead

Sprint PCS, Overland Park, KS

Presently at Sprint worked on a billing conversion project which is trying to build a new billing system for its wireless customers. In this project, as a team lead I perform following tasks on day to day basis:

Develop and communicate project estimates, plans, deliverables, and status to team members as well as appropriate management team.

Involve in host of design sessions with business and architecture teams to brainstorm the solutions.

Translate management direction into specific actions and activities.

Direct a well qualified team of developers on their day to day activities, priorities and issue resolution.

Develop and maintain effective customer partnerships.

Identify and implement business/software development process improvements.

Planned, managed and implemented the migration of Informatica Powermart from 4.7 to 5.1, then to 5.1 to 6.x

Environment: Informatica PowerMart 6.x/5.1, PowerCenter, Informatica Repository Manager, C, PL/SQL, SQL

Loader, SQL Plus, Oracle 8.1.6, HP-UX 11, TOAD, C/C++, Pro *C/C++, Syncsort HP-UX/LFS Rel 2.4.10.

Systems Analyst Dec ’00 – Oct ‘01

Ajilon LLC Kansas City, KS

Worked on a Private Label Services 1.0 Billing Conversion Project for Sprint PCS. Sprint PCS is trying to implement a new billing system with added new functionality. As part of this project, Sprint PCS is also trying to change their Business Billing outsourcing from one Vendor to another. I have been actively involved in all phases of this new PLS 1.0 Billing System.

Environment: Informatica PowerMart 4.7, PowerCenter 1.7, C, PL/SQL, SQL Loader, SQL Plus, Oracle 8.1.6, HP-UX 11, TOAD, Syncsort HP-UX/LFS Rel 2.4.10.

System Analyst II Sep ‘99 –Nov ‘00

Verizon Information Services, Irving, TX.

Worked as senior database developer supporting three different databases which has about 300 GB (two years) worth of data for Verizon Directories, which is a premier directories publishing company in the world with presence in 19 countries. My duties involve talking to customers about the changes or modifications required for on going upgrades, designing and implementing the changes to Database. I also worked as support personnel for DSS group, which I generating all the reports required for sales personnel and management over the intranet using Oracle Web Server 4.0. So that the Verizon Employees all over the country can have instant access to customer’s information.

Environment: C++, Pro *C++, PL/SQL, SQL Loader, Oracle 8.1.6, Oracle Web Server, HP-UX 11.

Information Analyst Jan 99 to Aug 99

EDS inc, Plano, TX

Worked as a database programmer in Data warehousing project with Electronic Data Systems which involves analyzing, processing and maintaining EDI orders, POS and Promotions data for their products within US and Canada Market for South Land Corporation, Japan.

Environment: C, Pro *C, PL/SQL, SQL Loader, Oracle 8.1.5, HP-UX 11.

Programmer/Analyst Feb 98 to July 98

Qwest / LCI Communications International, Dublin, OH

Part of a team in the Information Systems Department, which Reverse

Engineered the TAX modules to extract the requirements, and document, design and rewrite the existing Pro*C code into more maintainable code. And also involved in developing the Test Cases for the various requirements.

Environment: C, Pro * C, PL/SQL, Oracle 7.1, Open VMS 6.2.

Programmer/Analyst

CAESAR, UTA, Arlington, TX April 97 to Dec 97

Center for Advanced Engineering and Systems Automation Research, UTA Worked on a Military Medical Training and Evaluation tool in the position of Team Lead. This Project was developed for assisting US Marines managing the causalities on battlefield and replenishing their essential resources. This project involves the use of DAO, MAPI and OLE controls of the Visual Basic 5.0 and MS Access 97. The tool is designed to playback the sequence of events that occur at a marine exercise. The data is updated online using the Electronic mail. Various graphs were generated in Excel using OLE techniques on the fly to give the hourly resource status after action reports (AAR) were generated using crystal reports for the use of Navy Generals.

Environment: Visual Basic 5.0 and MS Access 97, Windows.

Programmer/Analyst

Designed and developed Communication Manager prototype software using front-end application software Visual Basic 4.0 and MS Access 2.0. The Communication Manager (CM) is developed to facilitate communication among programs, groups and processors. The CM also provides an interface for network manager to help him in projecting future requirements.

Environment: Visual Basic 4.0, MS Access 2.0, and Windows 95

PROJECTS:

OOA/ OOD/ C++:

Simulation of Warehouse: Written a C++ program to simulate a warehouse operation. The warehouse has three floors, and an elevator, which can go up or down to/from either floor. The first floor was used for parking and was not part of the simulation. Each of the 2nd and 3rd floors could support up to 5 customers. The two floors were represented as variables within the warehouse object, and the elevator was an embedded object within the warehouse. The customers were represented as an embedded array of pointers to customer objects (in the Warehouse object), which were dynamically allocated during the simulation. The concepts of Encapsulation, Composition were used.

Scenario Based Requirements Tool (SBRT Validation Subsystem): The SBRT validation Subsystem was designed and prototyped in VB 5.0 and MS Access 97. And then redesigned according to user feedback and implemented in C++ in UNIX environment. The concepts of Encapsulation, Association, and Aggregation were used in the implementation.

Simulation of Mini Operating System (SMOS): Involved in a team project that developed the Software Requirements Document (SRD) and Software Project Planning (SPP) Document for the SMOS. Implemented in C++. As a part of this, memory management algorithms are implemented. The concepts Of Inheritance and Polymorphism were used. This was developed in UNIX environment.

C and Data Structures:

Sorting Algorithms: Insertion Sort, Heap Sort and Quick Sort algorithms are implemented on a 300 years old text of Bible to test the running times of different Sorting Algorithms. As a part of this Binary Search algorithm is implemented to search and count the occurrence of each word in the Text. Implemented in C using UNIX.

MST Algorithms and Graphs: Implemented Prim and Krushkal Algorithms using Fibonacci and Binomial Heaps on Adjacency List representation of undirected Graphs.

Tree Data Structures: Implemented different programs in C for manipulations on tree data structures. The tree data structures include Binary Trees, Red-Black trees and B-trees. The manipulations on these data structures include insertions, deletions, breadth first search, depth first search and topological sort. UNIX environment was used.

Database:

Designed and implemented a “Geography Database System”, which maintains information about different land and water objects. The designed EER schema was mapped into a relational schema and implemented on ORACLE 7.0 and tested using sample queries in SQL’92.

Designed and implemented “Database Catalog Security Subsystem” using Oracle7.1, PL/SQL and Pro*C. The catalog keeps track of users admin and relational privileges and allows them to grant and/or create relational privileges to other users depending upon the conditions specified in the Requirements Document.

Contact this candidate