Le (Olivia) C. Email & Phone Number

666 5Th Ave, New York, Ny 10103

Jersey City

Greater Pittsburgh Area

Worked on a multi-task project as a Application developer and database developer in Business and Information Services Division (BISD).Familiar with Agile progress via Serena VM, MS Visual Studio 2012/2013/2015 and TFS (Team foundation server).Developed complex Oracle PL/SQL code such as select queries with multiple table joins, user-defined functions, stored procedures and packages by using SQL Developer.Created and upgraded financial reports by using business intelligent tools (e.g.SSRS) and MS Excel, and also worked on debugging SSRS reports and Excel reports. Have high exposure on VBA and macro job.Maintained and tuned performance of complex PL/SQL queries, stored procedures and packages.Wrote various DDL queries, changed table structure, added/altered columns and con-strains, and introduced constraints and indexes as business user requested.Developed Bash scripts, as well as maintained and updated old scripts for newly designed functionality and changed regulation rules.Migrated Business Intelligence code and report files from Serena VM to TFS by using TFS migration tools and xml scripts.Developed and maintained Pro*C codes for various Oracle database related financial reports.Involved in Unit testing and assisted BA testing, debugging and performance tuning.Wrote technical documents such as edited user stories or technical requests and designed test plans.Familiar with different tools for Oracle PL/SQL code review process such as Serena VM, Beyond Compare, TFS (Scrum process), Notepad++, MS Access, FTP, etc.

New York City

• Lead Go Paperless task: developed whole back-end system to automatically send Email alert or SMS messages to our members if they enrolled to Go Paperless program• Created and maintained complex PL/SQL code such as functions, stored procedures, packages in Oracle Navigator and Todd• Wrote complex select statement to retrieve data from Oracle database depending on the need for bug fixing and data analyze jobs• Worked with UNIX PuTTY, and especially expert in creating, modifying shell script and scheduling Cron jobs to generate daily reports and maintain several health insurance processing in UNIX (e.g. payment processing and member data load processing)• Created Cursors and Ref cursors as a part of the procedure to retrieve selected rows• Developed other database objects such as sequences, indexes and views when needed• Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost-based Optimization• Provided Oracle database troubleshooting for HIX members enrollment processing and HMO member management• Created and rewrote exceptions and use saved exception to work on error handling• Created and scheduled daily report job by using sql*loader and export/ import database utilities for data transfers• Wrote documents such as best practice documents, business required documents, and database maintain documents• Designed DEV and QA testing scenarios and provided testing files• Managed files transformation between different develop environmentEnvironment: Oracle 11g, TOAD, Oracle Navigator, PL-SQL, UNIX/Linux, Putty, K shell, SQL Loader, MS SQL Server 2008, MS Lync, MS Communicator

Environment: Oracle 10g, Sql developer, SQL Loader, MS SQL Server 2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, MS communicator, MS Office

Beijing City, China

• Providing Market Data and calculated data to the downstream applications/business users via Database views, Flat files (nightly reports/request/response mechanisms)• Prepared test case and testing data for DEV testing and QA testing• Wrote queries including sequences, functions, stored procedure and packages• Helped in database ministration job and monitor the performance of brand new database components• Edit old packages in Oracle database and added exceptions for transactions and used saved exceptions to handle errors• Designed and developed reports using SSRS including table reports, dashboard reports, sub-reports• Loaded data from .DAT files and xml files into Oracle database by using SQL Developer• Scheduled daily report and send them via emails every day by using Shell Script and Unix Cron Job• Created and modified Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways• Wrote PL/SQL procedures to created database objects dynamically based on user inputs• Involved in Unit testing and Integration System testingEnvironment: Oracle 10g, PuTTY, SQL*PLUS, Notepad++, SQL developer, SQL Loader, MS SQL Server, SSRS, MS communicator, MS Office

Master Of Science (M.S.)

Bachelor'S Degree