Margaret Wong Ma

acgg77@r.postjobfree.com

SUMMARY

. Over 15 years of software development experience with

proven track record to significantly increase company

revenue, substantially reduce costs, streamline

processes, and improve operation efficiency.

. Extensive experience in software development life

cycle, data analysis, data modeling, data

warehousing, reporting, testing, documentation and

staff training.

. Excellent programming skills in SQL, PL/SQL,

Packages, Stored Procedures, Triggers, Perl, Oracle

Forms and Reports, Crystal Reports, Unix Shell

Script, C and Pro*C.

. Proficient in application performance tuning and

query optimization.

. Strong analytical, problem solving and trouble-

shooting skills.

. Detail oriented, self-motivated team player.

. Strong written and verbal communication skills.

Technical SKILLS

Languages: SQL, PL/SQL, Perl, C, Pro*C, Unix Shell Script, php, Microsoft

Visual Basic

Databases: ORACLE 11g/10g/9i, Sybase, MS SQL Server, MS Access, FoxBASE

Development Tools: PL/SQL Developer, Toad, SQL Navigator, Rapid SQL,

Crystal Reports 11,

Oracle Forms, Oracle Report Writer

Operating Systems: Unix, Windows 7, Linux x86, AIX, HP-UX 9/10, Solaris 2.8

Other: ERwin, AccuRev Software Configuration Management System, JIRA,

SugarCRM,

AppWorx job scheduling utility, Perforce source control utility,

MS Project, MS Excel

and MS Word

EDUCATION

University of California, Berkeley

B.A., Computer Science

PROFESSIONAL EXPERIENCE

Cybersource, a Visa company, Foster City, CA

July 2012 - July 2014

Database Engineer

Worked with application teams to create database access layers, accurately

estimated the amount of development effort required to implement new

software; researched and recommended new software or software techniques to

improve efficiency in the department and the application. Worked with large

volumes of data with sub-second response and applied extensive knowledge of

SQL tuning techniques.

. As a key member of a project group, successfully implemented a nine

month project utilizing

stored procedures, functions, PL/SQL and SQL to design and develop

business applications.

. Enhanced and maintained existing database objects and set up

configuration elements for online transaction processing.

. Collaborated with application developers to create database access

layers for payment transactions, batch processing and authentication

processing.

. Contributed to the successful implementation of Data Center Migration

Project.

ATP (Aircraft Technical Publishers), Brisbane, CA

Sep 2009 - July 2012

IT Business System Analyst/Developer

Within a few months of employment, quickly became one of the key members in

the business application group. Collaborating with several business units

within the company, successfully implemented a nine month project

significantly increased company revenue. Being nominated and got elected

to receive two Wings Awards as an outstanding employee for successfully

implemented several company initiatives.

. Proficient in writing SQL, PL/SQL, stored procedures and using Oracle

Development Tools to design and develop internal business

applications.

. Automated mission critical data syncing processes to improve data

visibility and operation efficiency for Sales and Accounting

department.

. Developed and maintained complex Subscription and Ordering System,

Product Document Publication System, Revision Services System,

Business Process Reporting System and SugarCRM.

. Provided superior internal customer support across all business units.

Epocrates, San Mateo, CA

Jan 2007 - July 2009

Business Intelligence Report Analyst

As a Business Intelligence Report Analyst, provided intelligent multi-

dimensional data analysis and reports to multiple business units.

Spearheaded effort to automate and standardize reporting process and data

presentation. By automating many Excel reports to Crystal reports, doubled

Client Services and Customer Advocate department efficiency. Received two

awards for completing two separate reporting projects within a short period

of time.

. Experienced in writing SQL, PL/SQL, stored procedures and using

Crystal Reports to design and develop dashboard reports for executive

teams as well as for external clients on Oracle 10g to support better

business decision.

. Coordinated with Data Warehouse team to design User Data Mart for

corporate reporting.

. Wrote design specifications and functional specifications for

reporting formulary health plan subscription, handheld application

usage and drug lookup metrics for external clients.

. Automated and improved numerous key periodic report generation

processes.

Argonaut Insurance Company (Argonaut Group), Menlo Park, CA

Feb 1999 - Jan 2007

Programmer Analyst/Senior Software Engineer

As a technical lead, was responsible for enhancing and maintaining a

complex in-house Workers Compensation software application (AIS Deductible

System) interfacing with Premium, Claims, Accounts Receivable, Oracle

Financials General Ledger and Loss Analysis systems. By successfully

integrating multiple software applications, my tireless effort contributed

to substantially reduce costs and streamline many business processes.

. Proficient in implementing software solution using PL/SQL, Oracle

Developer/2000 (Reports 6.0 and Forms 6.0), Perl, Packages, Stored

Procedures, Unix Shell Scripts, Pro*C, Oracle development tools in

ORACLE 9i.

. Defined application features, wrote functional specifications and

detailed design documents.

. Developed comprehensive test cases on all application development for

quality assurance.

Contact this candidate