SUMMARY:

• Detail Oriented Sr. Oracle Developer with expertise in database application design, development, maintenance, and support; SQL, stored procedure programming and UI implementation; and data analysis, extraction, and reporting.
• Acknowledged for excellent problem solving skill, statistical information collection, and rigorous logical thinking abilities.
• Has +14 years of professional experience and business knowledge, providing internal and external customers with innovative and qualitative services.

TECHNICAL SKILLS:

RDBMS: Oracle 11g / 10g, MS Access

Database Tools: Oracle FORMS/REPORTS, Oracle SQL LOADER, TOAD, Oracle SQL DEVELOPER, CRYSTAL REPORT, EXCEL

Language: SQL, PL/SQL, Pro*C, C++, UNIX script, HTML, Python

Platforms: Windows XP/NT, Linux, AIX, Fusion Middleware

Defect Tracking Tools: Clear Case, Salesforce CRM

PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

Sr. Oracle PL/SQL developer

• Designed and developed an application in oracle packages and procedures for a travel agency to automatically extract, consolidate, and load the digital media data from multiple sources daily. The automation saves client $650K in operational expenses on manually pulling, calculating, and merging data within a multiple - tab excel sheet. It improves the data accuracy by eliminating errors from human beings as well.
• Designed database tables, constraints and indexes; Created view to display limited consolidated data on excel via ODBC for Business Analyst; Created oracle directory for data files which are then directly loaded through external tables; Created materialized view to feed the massive historical data to OBIEE system; Utilized Oracle UTL MAIL package to send out emails from PL/SQL.
• Tuned existing packages and SQL queries. Grant privileges to different users. Helped QA teams to identify test cases for digital media campaign portal.
• Developed an ETL application using Stambia, shell script, and Python for double click market to extract online hotel booking activity which is used to feed into an OBIEE system for converted revenue and ROAS reporting, campaign strategy management, and business trend analysis.

Sr. Oracle Developer

• Designed and developed an application using Oracle Forms for Chicago City business consultants to enter email addresses while processing a Chicago business license application or changing current applications.
• Highly engaged in database and application design, developed stored procedures and functions to generate different type of emails.
• Assisted team members to identify and fix issues in packages or procedures, fully supported client UAT (user acceptance testing) to ensure the application fulfils all the functional requirements and is deployed on time.

Senior Programmer Analyst

• Fully on-site supported client’s complex CIS Banner utility billing system of hundreds of Oracle Form User interfaces/modules including GL, AR, AP, and Inventory, etc. Maintained its millions of customer accounts 24x7 and the processes, which include posting water meter readings, generating charges and bills, and receiving and applying payments. Designed and implemented new functionality for customer’s special business needs.
• Provided client and its 3rd vendors’ business management solutions by developing many accurate, analytical data reports used for water supply budget planning, revenue forecasting and tracking, workforce management and bad data correction.
• Optimized SQL queries to improve the processing time of some from a few hours to less than 30 minutes and others from not running successfully to finish in few hours.

Senior Technical Consultant

• Served 25 of 79 clients in the energy and utility industry as a customer advocate, providing functional and technical support on their issues and defects of CIS applications ranging from client-server release 3.2 to web-server 4.2.
• Remotely accessed via a variety of VPN connections into customer systems to analyse, isolate and identify each issue existing in the processes written in Oracle Pro*C, the user interfaces developed in Oracle Form, the packages written in Oracle PL/SQL, or the customers’ data. These processes included automated meter reading to complex charging, billing, payment receiving and applying, and regulatory credit and debt collecting.
• Documented detailed steps onto Salesforce CRM system to re-create baseline defects and locate these defects in the codes. Leveraged defect corrections and performed regression testing to ensure zero negative impact to existing functions of customized CIS software application.
• Tracked every logged baseline defect, contacted clients on the status of fixing, requested code delivery in a timely and complete manner, and finally followed up with clients on the solutions provided.

Senior Technical Consultant

• Accountable for SCT/Indus/Ventyx’s top multimillion revenue business for 7 consecutive years by providing DOWM 24x7 support of CIS Banner application, operational service and continuous business solutions and product functionality enhancements.
• Developed 320+ CIS Banner standard-format reports and ad-hoc reports by using various programming languages/tools including Oracle Pro*C, PL/SQL, Microsoft Access, Excel and Crystal Reports. These reports provided DOWM’s management team the statistical factors for the upcoming year’s budget and the need to revise charge rates.
• Added 908 new charge rates for 2008, 2009 and 2010 respectively, prorated water and sewer charges for the middle period rate changes through SQL scripts, integrated 60,620 senior accounts with Cook County data to re-qualify sewer exemption eligibility, and re-identified all meter modules and their reading instructions.
• Developed interfaces utilizing Oracle Forms Developer and processes to enhance the baseline function of CIS Banner system. These enhancements include Lien interfaces, FPC Foreclosure Application Forms, letter extract processes written in Oracle Pro*C, and Lien reports to improve DOWM’s financial performance.
• Coordinated with DOWM 3rd party vendors on both base and expanded services. Created customer phone contacts to BSG (BSG Training & Consulting, Inc. ) on service order posting and shutoff, which increased 30% of payments on past dues. Provided meter reports to PMI on Automated Meter Reading enhancement project to manage field workforce efficiency and bad debt collection reports to law firms.