SUMMARY

• Experienced in PL/SQL, T - SQL, SQL, SQL tuning, ETL & reports, transform business requirements into solutions.
• Known as a fast learning and self-motivated team player, has ability to pick up new projects in short time and work under pressure.

TECHNICAL SKILL

SProgramming Skills: T-SQL, stored procedure, SQL, PL/SQL, C/C++, Unix shell script, XML, HTML, Ad hoc reports, SQL tuning and C#, ASP page, MDX, Powerpivot.

Databases: 9 years in MS SQL 2005/2008/2012 , 12 years in Oracle 8i, 9i, 10g and 11g, 1 year in Sybase v12, SSAS 2012

ETL Tools: ODI (Oracle Data Integrator) for loading data to Hyperion Planning/Essbase 11; SSIS packages.

Reporting Tools: SSRS, Actuate Report Version 11 (Birt), Crystal Report and Dynasight Report

Operating Systems: Windows 2007, Windows Server 2003/2008, Sun Solaris 2.7 and 2.8, HP-UX 9000 and OpenVMS

Software: Visual Studio 2005/2008, SQL Server Management Studio, SQL Developer, Microsoft Office, Hyperion Planning, Essbase, Autosys, ClearCase, Etrack, Perforce, Source Safe

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Responsibilities:

• Application integration for ERP, well management application (Rimbase) & oil marketing application (EMK3). Developed a web client (C#) to update invoice status on customer web server
• Developed SSIS packages to pull data from such ERP system, well management application, Excel Spreadsheets and Ragged files.
• Design stage database and metadata to support ETL functionality.
• Provided SSRS report solutions to meet, and enhance teh database model to support, business requirements.
• Developed OLAP cubes (SSAS) on data marts for delivery systems, revenue and accounts payable. Users accessed teh cubes through Excel PivotTables, and SSRS reports wif MDX.
• Performance database tuning for ERP system and its built-in reports.
• Resolve data loading and report executions issues.

Confidential

Responsibilities:

• Developed SSRS reports for a Forms application to supports HP data migration business.
• Developed SSIS packages to load Excel spreadsheets and csv files to teh application.
• Did backend development on SQL Server 2008 R2/SQL Server 2012, and perform SQL tuning for teh application.
• Performed release of database objects (stored procedures, functions) on production. Performed database upgrade to SQL Server 2012 for teh application.
• Developed complicated SQL statements, scalar functions, table functions and stored procedures on SQL Server 2005 to meet teh requirements of financial reports
• Tuned up or rewrote T-SQL stored procedures of long running reports to meet month end, quarter end and year end requirements.
• Developed SSIS packages dat loaded CSV files and Excel spreadsheets on to teh reporting system.
• Developed ASP pages using VB scripts or Java scripts to hook up ad hoc reports to teh reporting system.
• Worked wif financial analysts on requirements and delivered Actuate reports or ad hoc reports. Teh reports support contract analysis, trade (allocation and settlement) analysis and portfolio performance analysis.
• Worked wif business/MIS users to compile reports dat show statistics of their daily or weekly operations.
• Created jobs dat execute reports and send their outputs in XLS, PDF or other document types to clients

Confidential

Responsibilities:

• Analyzed business requirements and delivered ETL solution for Hyperion Planning 9.3.1 and Essbase 11 using ODI (Oracle Data Integrator) and stage database in SQL Server 2005.
• Developed SSIS packages Excel spreadsheets and CSV files to stage for further processing by ODI.
• Imported data into Essbase cube using load rules; export data from Essbase cube using Calc scripts and MaxL scripts.
• Designed and built a stage schema SQL Server 2005. Resolved its performance issues on exporting large volume of data; tuned up relational database of Hyperion Planning for reports.
• Enhanced Crystal reports for labor and time sheets.

Confidential

Responsibilities:

• Teh databases on teh projects were SQL Server 2005 and 2008.
• Resolved highly escalated ETL performance issue under huge pressure by cutting CPU usage from 100% to 25% theirby winning an award of Operational Excellence and Innovation in 2009.
• Communicated wif marketing and product management on requirements, provided and implemented solutions.
• Designed data marts wif Kimball approach, created views and indexed views to support EasyQuery .NET. Wrote stored procedures to pre-build aggregates for KPIs and to flatten hierarchies to gain performance. Tuned up teh underlying queries of KPIs.
• Tuned up teh Policy Module (PM) and Response and Assessment Management (RAM) of Control Compliance Suite (CCS) by rewriting queries and creating database objects.
• Wrote Crystal reports on reporting system (data marts) of CCS as defined and required by product management.
• Worked closely wif remote QA team in India so dat they could fully explore most, if not all, possible issues.

Confidential

Responsibilities:

• Wrote ad hoc reports and Dynasight reports for receiving, inventory, promotion, labor cost and call center.
• Maintained and managed teh existing supply chain reports, tuned up long running reports.
• Tuned up PL/SQL packages teh supply chain application.
• Part of teh team in Oracle upgrade from 9i R2 to 10g. My role was to ensure dat teh supply chain application was able to support high volume of transactions and long running ad hoc queries.
• Developed shell scripts (korn and c) and PL/SQL packages for inbound data loading and database maintenance functionality such as table purges, index rebuild, statistics computation and inventory calculations.

Confidential

Responsibilities:

• Supported and maintained teh ETL functionality of a data warehouse named Verve by enhancing teh existing or writing stored procedures for new business by using T-SQL on Sybase V12.
• Wrote ad hoc reports for business users. Resolved issues of missing, corrupted or wrong data reported by ETL jobs. Sometimes performed manual data loading.
• Worked side by side wif Sybase DBA on performance issues and performed query tuning.
• Supported and maintained an equity trading application (CSW) dat implemented executions, allocations and confirmations of global trading of equities on Sybase V12.
• Enhanced teh functionality of CSW for new trades using C/C++ as well as its maintenance.
• Resolved missing or incomplete trades, manually repaired trades as instructed and approved by business.

Confidential

Responsibilities:

• Primary developer of a monitoring and management tool, PATROL for Oracle using PATROL Script language (PSL), C/C++, HTML, SQL, PL/SQL and Unix shell script.
• Designed and implemented Oracle instance discovery, recovery actions, Oracle performance measurement, root cause analysis and configuration of teh tool.
• Primary developer of porting PATROL UNIX agent to OpenVMS using C and DCL languages.