Data Warehouse ETL specialist/Lead/Sr Programmer

RAO KALVAKOTA

Southern California

510-***-**** (cell)

***********@*******.***

PROFESSIONAL SUMMARY

• Over 17 years of IT experience. 7+ years in ETL development, business intelligence, Data warehousing applications

• Solid experience in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.

• Experience in integration of various data sources like SQL Server, IBM Redbrick, Oracle, Flat files into the staging area

• Successful background in analysis, design, programming, debugging, testing, support and implementation of applications using Redbrick Warehouse, Oracle, SQL Server, Informatica PowerCenter, PL/SQL, SQL*Loader, and Shell scripting environments

• Strong experience with data mapping and data modeling

• Good Experience and understanding of Normal forms, Dimensional data modeling using Star schema/snowflake modeling, FACT & Dimension tables

TECHNOLOGICAL ENVIRONMENTS

Unix (SOLARIS/HP/AIX), OS/390, Z/OS, Windows NT/2000/XP, ORACLE 10g/8i/9.0, MS SQL Server 2000/7.0, IBM Redbrick 6.1, DB2, Business Objects Web Intelligence Infoview,

Informatica PowerCenter 5.1/7.1, PL/SQL, ERwin 3.5, PL/SQL, SQL*Plus, SQL*Loader, TOAD, Shell Script, Control-M, QMF, SPUFI, Platinum tools, Endevor, MS Project, MS Visio

EXPERIENCE

Longs Drugs, Walnut Creek, CA March 2006 – May 2009

Senior Programmer Analyst, Business Intelligence (Sales & Inventory Data Warehouse)

• Worked closely with business users to gather and understand business and systems requirements and supported Finance and Marketing business.

• Created high-level functional and technical specifications.

• Used ERwin to create and or modify Sales & Inventory data model.

• Conducted and participated in specification reviews and code walkthrough meetings.

• Designed and developed ETL code using Informatica mappings/workflows, Redbrick exports, Oracle Stored procedures, Views, External Tables, Triggers, SQL*Loader and shell scripts to extract, transform and load data. Used Control-M to automate batch jobs.

• Created test plans and test cases. Conducted unit test, system test and user acceptance testing. Used Informatica Debugger Wizard to find bottlenecks at source, transformation, and target levels.

• Created change requests and participated in change request assessments in support of promoting changes to production.

• Provided rotational 24x7 on call and production support. Tracked trouble tickets in Remedy.

• Led small team activities. Supervised 3 to 4 consultant. Used Business Objects WEBI, Toad and DBVisualizer to support ad hoc data user requests.

• Researched issues to find the root cause, recommended, and implemented solutions.

• Instrumental in the design, development, testing and support of Perpetual Inventory subject area in the existing star schema.

• Redesigned 26 weeks of sales for planogrammed items to improve performance by 30%.

• Led design, development, testing and implementation of a Flexible Spending Account data model for analysis, assessment and reporting in a secured environment in support of PCI (Payment Card Industry) compliance.

Environment: Informatica PowerCenter7.1, Oracle 10g/9i, IBM Redbrick Warehouse 6.1, HP Unix, Shell scripts, Remedy, Toad, DBVisualizer, ERwin, MS Office, Sql Plus, SQL*Loader, DBVisualizer, Business Objects XI WEBI InfoView, JDA Data Manager, Control-M (job scheduler).

Levi & Strauss, CA

Consultant (IT Analyst Programmer/Offshore Coordinator) Jan 2006 – March 2006

• Created high level technical and program specifications.

• Built interfaces from Mainframe to Unix system

• Designed Informatica mappings & workflows to load data into data warehouse.

• Coordinated with offshore development & testing team.

Environment: Cobol II, DB2, JCL, MVS, Informatica PowerCenter 5.1, Unix, Oracle 9i, Test Director

UnitedHealth Group, CT

Consultant (IT Analyst Programmer/Offshore Coordinator) June 2005 – Jan 2006

• Created high level technical specifications and program specifications.

• Collaborated on development of an HMO gateway for acquired health care companies and business partners.

• Integrated claims processing, billing, enrollment, member management, and other systems into the UnitedHealth environment.

• Created data mapping documents and transformation rules

• Coordinated with offshore development/testing team

Environment: Cobol II, DB2, IMS, JCL, Informatica PowerCenter 5.1, Solaris, Teradata, BTEQ scripts

VISA International, CA July 2004 – March 2005

Technical Consultant

• Created functional and technical documentation and program specifications.

• Collaborated on development of a Document Control System for credit card transaction dispute resolution.

• Analyzed and tuned DB2 stored procedures in ‘C’ to optimize execution time.

Environment: Cobol II, DB2, JCL, ‘C’, NDM

GAP Inc, CA Nov 2003 – Feb 2004

Technical Consultant

• Created functional, technical documentation, and program specification.

• Integrated legacy Perpetual and Financial Inventory data into the Retek Merchandising System for Organization hierarchy.

• Designed and developed PL/SQL procedures to load and process data transmission from mainframe to AIX server (Oracle database).

• Participated in unit, system, integration, volume, and UAT

• Created wrapper scripts on AIX system.

Environment: Cobol II, DB2, JCL, Oracle 9i, AIX

Target Corporation, CA Oct 2001 – Oct 2003

Technical Consultant (Common Instocks Data Warehouse)

• Worked with business analyst and client representatives to design functional and technical specifications.

• Developed enhancements for Partner Performance Management and Inventory Stock Data Warehouse System for inventory management.

• Extracted raw data off of DB2 systems, gathered other supporting data, applied business rules, performed aggregation to be loaded into Non-Stop SQL data warehouse.

• Wrote and maintained test plans, test cases, and reviewed test plans/test cases.

• Supported on call rotation

Environment: Cobol II, DB2, Easytrieve, JCL, SPUFI, QMF, Fileaid, Syncsort, MVS, Tandem, TACL, Non-Stop SQL

VISA International, CA Aug 1999 – Oct 2001

Technical Consultant

• Designed, developed functional enhancements (COBOL II, embedded SQL) for a complex major Credit Fraud Reporting System.

• Developed Interactive maps in CICS

• Coded and implemented Syncsort & Shell scripts on Unix.

Environment: Cobol II, DB2, JCL, CICS, MVS

Target Corporation, CA Nov 1996 – June 1999

Technical Consultant (Common Instocks Data Warehouse)

• Worked with business analyst and client representatives to design functional and technical specifications as part of General Merchandise system.

• Extracted raw data off of DB2 systems, gathered supportive data, applied business rules, performed aggregation to be loaded into various levels of facts

• Wrote and maintained test plans, test cases, and reviewed test plans/test cases.

• Supported on call rotation

Environment: Cobol II, DB2, Easytrieve, JCL, Syncsort, MVS, Tandem, TACL, Non-Stop SQL

Previous Work Experience July 1991 - October 1996

India, Programmer Analyst

EDUCATION - Master of Science, Computer Science (India)

Contact this candidate