Resume
Login
Email

Data Warehouse ETL specialist/Lead/Sr Programmer

Location:
San Francisco, California, 94583, United States
Posted:
August 27, 2009   all resumes
Email:
q2iuwu@r.postjobfree.com
Contact Info:
***********@*******.*** ***-***-****


RAO KALVAKOTA
Southern California
510-***-**** (cell)
q2iuwu@r.postjobfree.com

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)