OBJECTIVE:

• An exceptionally experienced Oracle PL/SQL Developer / Oracle Database Developer / Oracle Database Architect with 17+ years of hands - on experience of designing, developing, and maintaining application systems under Unix/Linux, using SQL, PL/SQL, Unix Shell Scripts, Oracle Databases, and many other Oracle facilities. Solid and hands-on experience of query performance tuning. Excels in programming innovation, especially with using Oracle techniques creatively to resolve system performance issues. A good team player with great capability to work individually. Understands and learns new technologies at a fast pace.

SUMMARY:

• 17+ years of experience in OLTP system analysis, design, and development of large-scale business applications using Oracle/Unix/Linux technologies.
• 15+ years of experience with manipulating large Oracle Databases (2+ billion records, 2+ TB in size, several hundreds of concurrent application users).
• Expert knowledge of Oracle Database, Oracle PL/SQL programming and extensive SQL skills.
• Excellent understanding of entity relationship, data modeling, and relational database structure.
• Strong experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex datasets in Oracle Databases.
• Excellent skills of writing queries in both SQL and PL/SQL to collect data, analyze data, and generate data for reporting.
• Plenty of experience of performing development DBA tasks, like creating database objects, creating users, managing user privileges, session monitoring, query tuning, etc.
• Solid and proven experience and skills of optimizing SQL queries by analyzing Execution Plan, rewriting SQL queries adopting more efficient access paths, and adjusting database structure when necessary.
• Good analytical skills and extreme sensitivity to defects, faults and bugs in software systems. Good trouble shooting and problem solving skills.
• Motivated, well-organized, energetic, detail oriented, proactive, team focused and fast learning. Always willing to learn and apply new technologies into work.
• Good spoken and written communication skills.

TECHNICAL SKILLS:

Operating Systems: 9+ years of Red Hat Linux 7+ years of Unix 6+ years of Windows 7/8/10

Programming Languages: 17+ years of SQL, PL/SQL 9+ years of Unix Shell Scripting 8+ years of C, Pro*C Knowledge of C++, Java, JavaScript, HTML, XML, Weblogic, Python, and R

Databases & Tools: 17+ years of Oracle Database (Oracle 8i/9i/10g/11g/12c) 17+ years of SQL*PLUS, Oracle SQL Developer 9+ years of Embarcadero DBArtisan, SVN, JIRA, HP Quality Centre 9+ years of Toad, PL/SQL Developer, SQL*Loader, Oracle Import/Export/Data Pump, Oracle Enterprise Manager 1+ years of MS SQL Server, SSMS, SSAS, SSIS, TFS, Share Point, Team Site Knowledge of Tableau SDLC Methodologies 9+ years Agile 8+ years Waterfall

PROFESSIONAL EXPERIENCE:

Business Intelligence Analyst

Confidential

Responsibilities:

• Worked as a member of HRIS BI team to develop and maintain an HR data warehouse system on MS SQL Server; to develop, deploy and maintain reports on SSRS server.
• Worked with clients to gather requirements, create definitions and specifications, and translate those into data models, ETL packages (SSIS) and reports (SSRS).
• Designed, developed, and maintained ETL packages and jobs, cubes, reports, subscriptions, dashboards and other BI content.
• Administered MS SQL Server databases including security, user permissions, performance and usage monitoring.
• Wrote technical and user documentation; troubleshot issues with reports, data sources, performance, etc.

Lead Software Developer (PL/SQL)

Confidential

Responsibilities:

• Worked as a member of Software Development team to build Airfare Insight - an application system for airline companies to manage their fare generation, distribution, and monitoring.
• Gathered and analyzed business requirements from both internal and external customers. Clarified and resolved conflicting requirements.
• Designed and developed AMAR (Auto Match Auto Response) report engine for fare data analysis. AMAR automatically extracts OAL (Other Airlines) fares from subscriptions, analyzes both OAL fares and OWN (Own Airlines) fares, resolves rule conditions for OAL/OWN fares, compares OWN fares against OAL fares, and presents the matching fares to users. AMAR helps customers quickly identify competitor Airline fare changes, and find the most compatible OWN fares that can be used to respond to OAL fare changes.
• Wrote design/implementation documents and user manuals for AMAR.
• Developed new versions of Airfare Insight as part of an Agile SCRUM team, development work including data loading, static data synchronizing, package revising, new component design, table structure design, backend business logic design and implementation, code writing/debugging, fixing bugs and defects, performance tuning, etc.
• Installed various Airfare Insight versions for new customers, and upgraded / migrated old Airfare Insight systems to new NGAI versions for existing customers.
• Designed, developed and maintained report and feed components, like Online Sales Report, Change Summary Report, Pros Feed, and RA Feed (Revenue Accounting).
• Provided extensive technical support to Customer Support Team, including investigating on issues raised by customers, identifying root causes, presenting solutions, writing/testing bug-fix scripts, preparing/releasing database patches, participating in conference calls with customers, etc.
• Tutored new employees on business knowledge, Insight database structure, and Oracle technical skills.
• Developed Multi-Threading technique to improve performance of Pros Feed.
• Made a significant improvement of the performance of AFD queries.
• Participated in a workshop on web application security covering topics like SQL-Injection, Cross Site Scripting, Denial of Service, etc.

Test Data Analyst

Confidential

Responsibilities:

• Worked as a member of Data Fulfillment team in the data conversion phase for the Imagine project.
• Collected, analyzed and clarified test data requirements from various submitting groups.
• Created 1000+ queries in SQL and PL/SQL to extract and analyze data across several data marts (Customer, Order, Billing, Collection, Bill Presentment, etc.).
• Executed queries within small time windows in large scale Oracle databases (thousands of tables residing in each of the hundreds of schemas) to extract accounts qualified for data requirements.
• Generated reports on data analysis results, like Identified Accounts Report, Missing Accounts Report, and Accounts Cross- Report.
• Delivered high quality data mining results to downstream consumers in a timely manner.
• Created, maintained and upgraded a requirement independent Package Framework in PL/SQL, in order to organize and manage 1000+ queries more effectively and run them in large scale Oracle databases more efficiently. This Package Framework supported running queries in individual or combination of several modes, such as Validating Mode, Tracking Mode, Reserving Mode, Statistics Mode, and Parallel Mode. This Package Framework was also able to control and monitor query running (Bill Cycle control, Runtime Limit control, Start/Stop control, etc.) and log query running status and exit messages.
• Established specifications and templates for coding queries run by the Package Framework.
• Created several tools in PL/SQL for checking query compliance with coding specifications.

Senior Oracle Developer/Technical Support

Confidential

Responsibilities:

• Worked as a member of an on-site Technical Support team to provide various technical services for our client Harbin Telecommunications Company.
• Gathered business analysis requirements from the client.
• Wrote queries and packages in SQL and PL/SQL to implement business analysis requirements.
• Analyzed transactional/aggregated data to resolve data integrity issues, like data missing, data mismatching, and data duplication.
• Produced reports at various aspects like Usage, Billing, Payment, etc. using SQL and PL/SQL.
• Enhanced a report's performance by 2000% faster by rewriting the whole report using a much more efficient data accessing path.
• Enhanced an event-synchronization module's performance by 500% using combination of Views, Triggers and Unix Shell programming, without changing any source code of this module.
• Developed a smart tool in PL/SQL consisting of several procedures working together to analyze data across two databases to find out data mismatch, which was approved and adopted by the Technical Support Group in UTStarcom Headquarter in China and used in many other installations in other branches of UTStarcom in China.

System Analyst/Senior Oracle Developer

Confidential

Responsibilities:

• Supervised and guided a 12-people team working in good collaboration on the project of Local Billing and Customer Care System for a telecommunication client.
• Gathered business requirements from the client and translated business logics into technical design and specifications.
• Documented business processes, system design, module design, and component/interface specifications.
• Designed OLTP database structure (tables, indexes, views, users, privileges etc.)
• Produced daily/weekly/monthly reports on business operation using C and Pro*C.
• Produced and revised the user manuals and technical support manuals.
• Eliminated the deadlocks between key modules by specifying the order of operations in the modules against several tables, which were manipulated by some SQL statements in a unit of transaction.
• Eradicated the resource contest and enhanced the efficiency of application by redefining tables and distributing records in one big table into several tables.
• Optimized lots of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and created and modified some Oracle Database objects to make sure all SQL statement could be executed in the most efficient ways.

Software Developer

Confidential

Responsibilities:

• Created PL/SQL procedures and functions.
• Created Views in Oracle Database.
• Created query scripts using SQL.
• Participated in integrating and testing the two application systems.
• Produced and revised user manuals for end users.