SUMMARY:

• Over 15 years of IT industry experience
• Experience in leading global development/support teams
• Strong experience in requirement gathering and analysis and writing functional documents.
• Good experience in SQL, PL/SQL, Oracle 10g/9i/8i, ETL development, data extraction and migration
• Working knowledge of Microsoft Sql,Microsoft Sql Server 2000,DTS package
• Well versed with UNIX shell scripting.
• Well versed with Business Intelligences tool - Business Objects (BO)
• Experienced in Database Triggers, Procedures and Functions in PL/SQL.
• Involved in full system life cycle from systems analysis, design and development.
• Well versed in development of application software in client/server environment using procedural techniques.
• Exceptional ability to quickly master new concepts, applications and technologies.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL*Plus 3.x, Pro*C, UNIX shell scripting, HTML 4.0.

Databases: Oracle 10g, 9.X, 8.x, 7.x, Microsoft Sql Server 2000, MS Access

Reporting/BI Tools: Business Objects

Operating Systems: Windows 2000/NT/98/95, UNIX Sun-Solaris.

Tools: /GUI: Informatica, Autosys, $U scheduling tool, Visual Source Safe, SQL Navigator, TOAD, PVCS, MS VISIO, MS Office, MS Excel

PROFESSIONAL EXPERIENCE:

Business Analyst

Confidential

Responsibilities:

• Responsible for requirement gathering and writing IT functional/technical documents
• Analysis and resolution of all data related production issues.
• Work within the existing application support team to help identify root cause of issues, remedial action and long-term prevention.
• Guiding and mentoring junior team members in project team.

Principle Consultant

Confidential, San Leandro, CA

Responsibilities:

• Developed custom PL/SQL (Packages, functions, procedures) and SQL code for internal projects.
• Analysis and resolution of all data related production issues.
• Guided and mentored junior team members in project team.
• Responsible for requirement gathering and writing IT functional/technical documents
• Work within the existing application to help identify root cause of issues, remedial action and long term prevention.
• Debugged, modified and compiled existing Pro*C programs.

Environment: Oracle 10g, PL/SQL, TOAD, UNIX, Pro*C, Tortoise SVN

Lead Data Support Production Engineer

Confidential, San Francisco, CA

Responsibilities:

• Analysis and resolution of all data related production issues.
• Handled global data support teams from US, UK and Singapore
• Work within the existing application support team to help identify root cause of issues, remedial action and long-term prevention.
• Identify and implement long term improvement activities to continuously improve the service provided to the business
• Help troubleshoot, and optimize data integration processes.
• Prepare/maintain documentation on all aspects of data support processes to enable knowledge transfer to other team members.
• Analyze data using SQL, Excel and other tools.
• Ensure that all timelines of loading/validating data are met.
• Build strong relationships with the business through delivery, communication and domain knowledge.
• Provide occasional weekend support for all business applications and websites supported by eBusiness.

Environment: Sybase 15.0.3, UNIX, UNIX Shell, SVN, Syabse, Informatica Power Center 8.6

ETL Developer/Analyst

Confidential, San Francisco, CA

Responsibilities:

• Responsible for requirement gathering and writing IT functional/technical documents
• Building a analytics data mart for Confidential - Confidential data using data warehousing concepts using Oracle 10g, PL/SQL
• Wrote custom PL/SQL and SQL code for data extraction and migration
• Performed code walk-thru and reviews with other team members

Environment: Oracle 10g, PL/SQL, PL/SQL developer, UNIX, Informatica Power Center 8.6.

ETL Engineer

Confidential, Sunnyvale, CA

Responsibilities:

• Was responsible for Extracting, Transforming and Loading (ETL) of actuals data for customer care group in Yahoo .
• ETL is performed using PL/SQL scripts and jobs are automated using shell scripts.

Environment: Oracle 10g, PL/SQL, TOAD, UNIX

IT Analyst/Developer

Confidential, Milpitas, CA

Responsibilities:

• Responsible for gathering functional requirements from cross-functional business users, analyzing, writing and reviewing functional design documents (FDs) with x-functional teams for functionalities to be added in Cisco Service Contract Centre (CSCC) tool.
• Developed PL/SQL packages and procedures/functions for new application
• Wrote PL/SQL and SQL code for data extraction/migration/analysis
• Worked with on-site and off-shore teams to analyze, review and unit test the developed work.
• Automated CSCC adaption metrics reports using PL/SQL, UNIX shell scripts and $U scheduling tool.
• Responsible for fine-tuning of report queries for Cisco Service Contract Centre (CSCC) Metrics reports for better performance.

Data Analyst/developer

Confidential, Milpitas, CA

Responsibilities:

• Responsible for Service data analysis for service pricing and mapping.
• Warranty management using Oracle 11i applications,
• Analysis of services and warranties provided on various Cisco product families.

Environment: Oracle Database 9.2.0.3, PL/SQL, SQL

Confidential, San Francisco, CA

Sr. Programmer Analyst

Responsibilities:

• I was responsible for gathering business requirements from different business users and writing design documents and development of many interfaces to ensure correct and timely flow of data of daily sales between Allocation, Merchandising and Retek Distribution Management (RDM) system using RDM GUI, Retek Information Bus(RIB), Oracle PL/SQL, MS SQL and UNIX.
• During time in Gymboree, I was responsible for handling various issues related with Oracle-Retek Distribution Management System(RDM) which is warehouse management system for Gymboree’s distribution center.
• Designed and developed various reports for Momentis ( which is Gymboree’s Purchase Order Management system ) using Business Objects, Microsoft Sql Server 2000, Oracle 9i and Unix shell scripts for different business users in Gymboree.

Environment: Oracle Database 9.2.0.3, PL/SQL, SQL*Loader, Pro*C, Business Objects reports, Microsoft Sql Server 2000, Perforce, Sun Solaris, Momentis, Retek distribution Management System, MS Visio.

Analyst/Developer(Contract)

Confidential, San Bruno, CA

Responsibilities:

• Implementation of GMS will provide an integrated solution supporting merchandise purchasing, pricing, inventory management, allocation, and replenishment.
• GMS will lay the foundation for Gap, Inc. to profitably manage inventory. It will enable better, faster, and smarter decisions that will allow our business, and our people, to grow.
• Contribution: Responsible for designing and writing PL/SQL scripts to Extract, Load and Transformation of data from Retek Merchandising System and other sources like inventory, distribution, forecasting into GMS Operational Data Source using Oracle 9i features like COLLECTION, BULK BINDING, BULK COLLECT, BULK INSERT using FOR ALL, External Tables, Oracle Built-in package UTL SMTP for sending emails from inside the database, dynamic sql

Environment: Oracle Database 9.2.0.3, PL/SQL, SQL*Loader, PVCS.

Data / ETL Developer

Confidential, Monterey, CA

Responsibilities:

• Responsible for creating data source for reporting purpose for Scoring Analytics & Reporting (SAR) project.
• Involved in analyzing scoring data based on race, ethnicity and gender for tests conducted by California Test Bauro ( Confidential ) for Kentucky Core Content Test. Partially involved in developing reports using SAS reporting tool.
• Personally involved in designing and developing data source using Data warehousing and Datamart concepts in Oracle 9i.
• Wrote many PL/SQL and Perl scripts to extract and map data from legacy

Developer/Analyst

Confidential, San Jose, CA

Responsibilities:

• Responsible for Oracle and Web development (PERL and PL/SQL), maintenance and support of a web based application METRO which is developed for Cisco employees worldwide to submit their expenses related to meetings, events and travel for approval.