OBJECTIVE:

• Seeking a position to utilize my skills and abilities in the Data Warehousing field which will offer me professional growth as well as learning opportunities
• To contribute to the growth of the organization by being a key - participant in all required areas

SUMMARY:

• Experience with all aspects of project development life cycle from analysis, modeling, design, development, implementation and testing through till supporting
• Close to 4 yrs. experience in Telecom domain
• Experience in performance tuning of Teradata SQL
• Automation of reporting processes using VBA
• Comprehensive problem solving abilities
• Excellent verbal and written communication skills
• Ability to deal with people diplomatically
• Hard working
• Team facilitator

TECHNICAL SKILLS:

Databases: Teradata V2R5/V2R6, Oracle 9i, MS Access, SQL Server

Tools:, Utilities& Applications: Teradata tools and utilities (FastLoad, FastExport, Multiload & Visual

Explain, Teradata Value Analyzer (TVA), TCRM), Toad (Oracle)

Business Intelligence: Cognos 8.2 (Transformer/Powerplay), Crystal Reports

ETL Tool: Informatica Powercenter (Beginners level)

Operating Systems: Windows 95/98/2000 Server/XP, Citrix, UNIX

Languages: PL/SQL, C, C++

GUI Development: Visual Basic 6.0, Developer 2000, VB.Net VBA (MS Access & MS Excel)

Middleware: COM/DCOM

PROFESSIONAL EXPERIENCE:

Confidential

Technical Consultant (DATA WAREHOUSING)

Responsibilities:

• I have been primarily involved in working for our client Confidential Telecom in Australia in developing their Teradata warehouse and various data marts used by the end user and reporting applications. I have also been involved in customization development and support of Teradata CRM and Teradata Value Analyzer applications at

Confidential

Programmer Analyst (DATAWAREHOUSING)

Responsibilities:

• Lines of businesses (LOB’s) by doing analysis of legacy data gathered from various sources put into a single data warehouse (Teradata Warehouse). Analysis was done using diverse analysis tools like SAS, SPSS, Cognos, and Excel. Work also engaged into loading data into various data marts and fetching data using Teradata tools to generate various
• Business Intelligence reports. (See project details towards the end)

Confidential

Programmer/Team Leader/DBA

Responsibilities:

• Worked in various e-governance projects developed using Visual Basic, .NET, SQL Server Oracle and Crystal Reports. My various roles in this company involved me in designing coding, testing, debugging, system administration and Database Administration.

Confidential

Responsibilities:

• Received 2 rewards from client ( Confidential Telecom) for work in TCRM and TVA
• Trained peers on TVA application & DB
• Was ed the best employee in year 2007
• Engaged in junior associates in Teradata tools and utilities
• Engaged in associates in Client ETL Architecture
• Passed 3 Teradata s, becoming Advanced Teradata Certified Professional
• Got a mid-year internal review rating of 4.19 on 5, which was the highest in Knowledge Services department till April 2006
• Got a VOC (Voice Of Customer) rating of 4.5 on 5
• Nominated for star of the month (September 05)
• Designated as the Quality SPOC for the team
• Assigned to give various internal presentations and s on Teradata SQL

Confidential

Responsibilities:

• Promoted from Junior Programmer to a Team Leader to DBA in just 2 years
• Was a key participant in getting the company ISO certified
• Single handedly implemented BOSS (Brihanmumbai Octroi Software System) along with setting up DB, Network and communication protocols at 5 key Octroi Collection Points in Mumbai including Sahar Airport and docks

Confidential

Solution Designer, Developer & Tester

Responsibilities:

• This project deals with migration and adding more features to the existing SQL

Confidential

Team Lead

Responsibilities:

• This project deals with 2 Teradata applications which are being used by Confidential .

Confidential

ETL Designer & Developer

Responsibilities:

• Confidential is the 2nd largest telecom company in Australia. This project dealt with loading data from 16 different sources into the central warehouse, which is then used to do transformations then within the IDW environment.

Confidential

ETL Developer

Responsibilities:

• Confidential is one of the largest Telecom company in the United
• States. This project phase dealt with getting the CDR data from the source systems to the EDW. I was involved in writing the BTEQ and mload scripts to load the data into the Staging area of EDW.

Confidential

Database & UI Programmer

Responsibilities:

• Client being the biggest online travel agencies has to keep its prices competitive which needs to be changed every now and then due to market trends. These prices are devised using a formulated set of rules deployed under a unique release ID. The target of this project was to create software which takes various releases as inputs and compares them and creates a variety of graphical reports which portray which rule will maximize the revenues pertaining to a particular market (Origin and Destination). This facilitates the client to make a sound judgment about which rule should be deployed onto a particular market keeping the price competitive. This process was earlier done manually and took more than a week to get the final results of analysis or just 2 releases. And now with the process automated it takes a few minutes to compare as many releases as needed. So this project enables the client to do this analysis more frequently and deploy new better rules with more effect resulting in much greater ROI.

Confidential

Database Programmer and Designer

Responsibilities:

• Project was to create a tool in MS Excel which will gather a small amount of summary data (of client and its closest competitor) from Teradata warehouse which will then be used in analyzing the company’s booking numbers with the change in seasonal trends by calculating the various standard measures like Price

Confidential

Database Programmer

Responsibilities:

• The goal was to develop a report in Cognos Reportnet which will give an insight on all Lines of Businesses (LOB’s). I was responsible for creating the script for pulling the data from Teradata warehouse and creating OLAP cubes which were used for creating a BI report in Cognos.

Confidential

Designer and Programmer

Responsibilities:

• DC report which compares competitiveness among different competitors and determines the areas where improvements are required.

Confidential

Team Leader and DBA

Responsibilities:

• Octroi collection posts in and around Mumbai. It’s contracted to be installed at 64 locations in Mumbai including Sahar Airport, Docks and all major railway stations.
• This faced us with the biggest challenge of designing the database such that the central server farm could take a 24 X 7 work load from all locations connected through a fiber optic cable network. The final product contained more than 15 modules, 135 UI forms and 250 reports. I was involved as a team leader and senior programmer during the development phase and then as a DBA during the installation and on site support.

Confidential

Junior Programmer

Responsibilities:

• Project was developed for the Confidential and involved the computerization of the various Tax collection systems. I was involved in coding, testing and debugging of all the modules.