Sales Data

Jenny Jiang

CAREER OBJECTIVE

. To obtain a Data Analyst position

SUMMARY OF QUALIFICATIONS

. Strong educational background in Computer Science (BS) and E-Commerce(MS)

. Extensive knowledge and experience with Microsoft Excel, Access, SQL

Server and Oracle with strong SQL skills

Advanced expertise in relational database concepts - Microsoft Certified

IT Professional - SQL Server 2005 Database Administrator & Oracle 9i

PL/SQL Developer Certified Associate

. Strong ability to meet deadlines, multi-task, identify and use

appropriate technology to solve business problems

. Excellent interpersonal skills with positive attitude

. Ambitious and hardworking with a commitment to excellence

. A highly motivated and detail-oriented individual

. Effectively able to work with diverse group of people

TECHNICAL SKILLS

. Languages - C/C++, Java, Visual Basic, Unix Shell Scripting, HTML,

CSS, Java Script,

VB Script, CGI/Perl, PHP, JSP, JDBC, ODBC, ASP

. RDBMS - MS Access 2003, SQL Server 2005, Oracle 8i/9i (SQL,

PL/SQL, SQL* PLUS), MySQL

. Tools - Oracle Developer 2000 (Forms, Reports), TOAD, ERWIN

. Applications - MS Office 2003, MS Project, SoftImage 3D

. Operating Systems - DOS, Windows 95/98/NT/ 2000/XP, UNIX (AIX), Linux,

OS/400

. Networks - Ethernet, LAN/WAN, TCP/IP, HTTP, Client/Server,

Internet/Intranet

EXPERIENCE

BlueShield (San Francisco, CA) Oct 2009 - Present

Sr. Data Analyst

. Collecting/Extracting data from various application databases (MS Access,

SQL Server & Oracle) by running SQL queries and from mainframe data

stores.

. Manipulating and massaging the data for further analysis using MS Excel

(Macros, VB Scripting, Pivot Table, vlookup, Charts & Graphs)

. Responsible for data analysis to support Network Management's Business

Readiness work, in preparation for a large-scale system conversion

MEDTRONIC INC. (Sunnyvale, CA) Apr 2007 - Jun 2009

Sales Data Analyst

. Supported Sales KACES system and maintained the Sales database (SQL

Server 2005)

. Supported sales reporting requirements of Sales Department as needed

. Gathered and translated business requirements into queries

. Created reports to support the data/information requirements of the

sales organization from KACES by using tools such as SQL, T-SQL, MS

Access and MS excel (Macro, Pivot Table and vlookup)

. Handled ad hoc information requests from the field using data sources

from Enterprise and external databases by building complex data

queries and stored procedures

. Maintained sales commission database and analyzed and reviewed sales data

for commission payment eligibility, in support of current and proposed

compensation and incentives structures

. Developed ad-hoc queries for consistency and validity to assure that data

is accurate and clean

. Used ERWIN for Logical and Physical database Modeling

. Made sales adjustments in SAP

. Administered KACES user account set up and maintenance

. Performed end-user training and helping with the user inquiries

. Worked with IT developers to define business requirements and perform

data analysis and provide recommendations for the new system or

improvements and redesign of the existing system

. Tested the changes that are made by IT in the dev system thoroughly

before the new projects were pushed to the production environment

. Provided report specifications to programmers and prototyping reports to

be put into production assigned.

STRYKER ENDOSCOPY. (San Jose, CA) Sep 2006 - Apr 2007

Data Analyst

. Worked at Sales Reporting Team. Proficient with database, SQL, Microsoft

Access, and Excel with Oracle Applications 11i knowledge (OM, Incentive,

Service Contracts module)

. Standardized historical customer data information, building of

spreadsheets and analytical databases, comparison and reconciliation of

information, and development of reports, and analyzing the data

discrepancy between the old system (AS400) and the new system (Oracle

Application 11i)

. Responsible for data cleaning and file matching projects to validate the

data collected against the source data from Oracle ERP system and the

legacy system on daily basis

. Built ad-hoc report/data extract for sales reporting team periodically

upon request in MS Excel (Vlookup, Pivot table, etc) and MS Access

UNIVERSITY HEALTH NETWORK (TORONTO, CANADA) Jan 2005 - Aug

2006

Data Analyst - SHARED HEALTHCARE SUPPLY SERVICES

. Debugged, modified and enhanced various tables, forms, queries, and

reports in MS Access and MS Excel

. Developed and maintained MS Access database to track the purchasing data,

such as contracts, contract owners, and buyers

. Worked with Contract Specialists or Buyers who provide Excel Purchasing

Vendor Item Load Sheets which are to be loaded to the database to

identify, analyze, and resolve complex issues related to data quality and

data relationship

. Validated and modified data format, as required, ensuring data to be

loaded to the system is clean, involving putting Excel file in Access and

running queries to identify new/old vendor items, placing item type at

the front of the description, etc. and ensures that all information is

loaded within the established timeframes

. Developed various automation tools utilizing Microsoft Access 2002, SQL

and Microsoft Excel(Pivot Table, vlookup and other functions) to clean

and reformat Vendor Item data, in preparation for upload or manual entry

. Uploaded data properly into the applicable database through SMARTSTREAM

. Provided Ms Access database reports to extract useful data for vendor,

vendor Item, and Purchase Order info, etc. Some of its key performance

indicators include:

. Number of items added or revised to file;

. Expiry dates of items;

. Price variance reports between the catalogue and purchase order;

. Number of items in the supplier file;

. Expired items used on purchase orders;

. Percentage of purchase orders through EDI;

. Percentage of purchase orders matched to the item file; and

. Number of items in the supplier file

. Assisted in Functionality testing for e-Requisition system which is used

to load requisition to suppliers' EDI system.

ORACLE CORP. (CHINA) Jan 2001- Jan 2002

Technical Engineer

. Provided on-site technical support and trouble-shooting

. Provided application prototyping/development/migration. Projects included

Railway MIS for State Railway Bureau. Ticketing system for Civil Aviation

Administration of China (CAAC). Inventory Management System for ShangHai

HuaLian Supermarket. (Platforms: Oracle Forms 6i, PL/SQL, C/C++ and

Oracle 8i/IBM AIX)

. Carried out Oracle database performance benchmarking. Performance testing

for pre-defined transactions on different UNIX platforms for China

Customs. Wrote the benchmark program in C/C++ and SQL. (Platform: IBM

RS6000 / AIX, HP 9000/827 / HP UX, DEC ALPHA 2100 / Digital UNIX and SUN

2000E / Solaris, NT clients)

. Completed billing software design/development/testing/implementation/ for

Beijing telecom in SDLC, wrote the specification of business requirement,

system analysis, design and development for each phase of the billing

process, such as CDR Loading, call rating, feature billing, packaging,

invoice delivery, etc. (Platform: C/C++, SQL, PL/SQL, Oracle Forms and

Oracle8i/HP-UX)

. Delivered presentation/seminar in Oracle marketing events such as Chinese

Oracle User Conference (COUC)

. Prepared technical marketing proposal

. Provided on-site customer training of Oracle tools

COURSE PROJECTS

1. ORACLE Database Application & Java project at TAMUC Dec. 2003

. Drew Entity-Relationship (E/R) diagrams for the database application

. Produced relational schemas from the E/R diagram by using ORACLE SQL

. Experimented sub-queries, aggregates, set operations to insert,

delete, update and retrieve the data

. Wrote ORACLE PL/SQL programs to perform complex database transactions.

Examples included computing aggregates from one relation and use those

aggregates to modify values in that or other relations

. Created Java Server Pages (JSP) with JDBC-ODBC code to update and

query the customer and order tables, operations include creatin4g an

HTML login form to enter username and password, and reporting and

maintaining customer and order data. Tomcat was used as the

JSP/Servlet Java Container, Apache as static web server, and Oracle 9i

as the database

Web Design for a Shopping Cart at TAMUC Dec. 2003

. Developed E-commerce Web pages for software products in Unix (AIX 4)

. Implemented HTML/DHTML/XML code by using CSS

. Developed user registration, order processing and tax/charge

components of application to sell products and services over the

Internet

. Designed and implemented web-database CGI interfaces in PERL with

MySQL to create dynamic HTML pages, functions include secure sign-in

and sign-out process, item insertion, deletion, and update to shopping

cart, checkout process, and email confirmation to customer. Other

technologies used include Java Applet, VB Script, PHP, ASP, and MS

Access

. Implemented the JavaScript code to provide a variety of client-side

functions, such as interface design, data entry validation, and logout

confirmation

EDUCATION & CERTIFICATION

Microsoft Certified IT Professional - SQL Server 2005 Database

Administrator

Oracle 9i PL/SQL Developer Certified Associate

M.S. E-Commerce

Texas A&M University, Commerce, Texas, USA

(Overall GPA 3.9 / 4.0)

B. S. Computer Engineering

Shanghai University, Shanghai, China

(Overall GPA 3.8 /4.0)

REFERENCES

Available upon request

Contact this candidate