DATABASE ANALYST/BI DEVELOPER

Goal oriented, award winning IT and Finance professional with M.S. in

Finance and demonstrated success as a database analyst and BI developer

with over 5 years Oracle, SQL and data loading experience. Professional

experience of most advanced Oracle 11g Database server installation, user

account setup, SQL, sqlplus, SQL*Loader design and create tables, views,

triggers, partitions, complex stored procedures, functions, index and other

database objects. Managing the delivery of Business Intelligence solutions

through all stages of the software development life cycle and developing of

complex ETL, cube, and management reports. Development of intuitive and

visually appealing user interfaces for management reporting Coordinates

development activities with developers, analysts, and consultants

Documentation of the entire Business Intelligence solution Experience in

SSIS, SSAS and SSRS on SQL 2008 R2 Platforms and deploying and using

reporting servers in SharePoint 2010. Proficiency with Advanced Excel and

MS Access. Experienced in all facets of retail bank operations and

corporation accounting. Proven organizational skills, problem resolution

capabilities, independent work abilities, and propensity to quickly learn

new tasks. Fluent in Chinese.

PROFESSIONAL EXPERIENCE

SITUS ASSET MANAGEMENT LLC

Jan, 2013 - Present

Houston, TX

BI Reporting Developer

o Developed numerous reports for mortgage industry including Loan

Performance analyst, Delinquency, Investor Remittance, Insurance, Tax,

unapplied Balances and payoff. Worked with SQL database. Written complex

stored procedure, user defined functions and view for generating

different kind of reports including Matrix Report, Parameter Report, and

Drill down Report, Dash Board and Charts.

o Designed and developed Business Intelligence solutions including ETL

packages of extracting data from database tables into flat files and

excel sheet, load these flat files into database tables using Oracle SQL

loader or SSIS on SQL Server. Load data in to Data Warehouse Dim and

Fact tables. Data Marts and Data warehouses.

o Migrated data from various data sources, including flat files, Excel

workbooks, databases (SQL,Oracle, My SQL,DB2,Sybase,TeraData) and many

other sources.

o Used and integrated both Advanced Excel and Access to store Excel data

in a structured, Relational database. Used Excel Pivot tables with

Access data. Reported Access data using the Excel presentation layer

Move data between Excel and Access using VBA, ADO and SQL.

o Created a high-Performance cubing technology and built hierarchies for

giving users the means to find the data quickly. Used data-mining

algorithms for providing a power decision support mechanism by marketing

departments, customer relationship management groups, finance/credit

departments, human resources and other.

o Used PerformancePoint to design KPIS, scorecards, reports and dashboards

to help business monitor and analyze its performance and understand

company and regional goals across the entire organization.

Oracle College

March, 2009 - 2012

San Francisco, CA

Database Analyst and BI Developer

(Consulting)

o Consulting projects for Bechtel, the world's No 1 Choice for

engineering, construction and project management. Directly connected end

users for finance and accounting department. Managed over 400 financial

reports per month globally. Updated reports and debugged report issues

and provide guidance and recommending alternative.

o Gathered globally multiple data sources into SQL database for analyzing

business requirements and provided solutions for specific business

issues, using data-mining to analyze marketing data, created KPI from

different sources.

o Written complex stored procedure and ad-hoc queries (utilizing, for

example: cursors, loops, inner joins, left joins, temp tables, user

defined functions, indexes, denormalization, etc.)

o Successfully deployed and used Reporting Servers in SharePoint 2010.

Built performance Point Dashboards and deployed and used Power pivot in

SharePoint.

o Analyzed data using advanced SQL like single row and group functions,

multi table joins, subqueries, and set operations.

o Created CUBE database with SSAS from data Warehouse data sources; used

MDX retrieve data from cubes; used KPI creating metrics.

o Generated varieties kind of business reports use SQL with Oracle

sqlplus, SSRS in SQL Server, or Crystal Report 2008, included Matrix

Report, Parameter Report, and Drill down Report, Dash Board and Charts.

o Created, Managed and explored data mining models; used MDX to manage

mining models and to create complex queries.

o Turned complex questions into simple data reports and KPIs that help

evaluate the business and product performance. Successfully built

useful self-service dashboards for various persons, for analysis of

product, customer and opportunities and market trends.

o Created faster cash flow by designing and analyzing new market data.

Working with the sales department, implemented new sales plans and

agreements with customers. Additional results included increased control

of inventory.

o Eliminated 15% customer shipping cost by analyzing supply chain data

demanding more efficient organization and planning. Investigated,

researched and handled negotiations with frozen shipping company for fee

reduction. Process continues to be used by company. Additional results

included more sales and customer satisfaction.

COLUMBIA TECHNOLOGY CORPORATION,

45 Broadway, New York, NY 10006

Mar, 2007 -Mar, 2009

Business Analyst

o Designed, developed and support ETL processes for data staging,

extraction, transformation and loading of fact and dimension tables,

data cleansing, Extract finance data from database, access data in

local data files and data warehouse, generated different financial

reports and filter reports using parameter files in Crystal Report.

o Managed all aspects of business/operations accounting including A/R,

A/P, reports, GL, payroll, commission and financial statement.

Monitored company procedures and establish new ones as business

changes.

o Analyzed data using advanced SQL like single row and group functions,

multi table joins, sub-queries, and set operations. Written complex

stored procedure and ad-hoc queries (utilizing, for example: cursors,

loops, inner joins, left joins, temp tables, user defined functions,

indexes, denormalization, etc.)

o Reduced the time required to produce budget and annual financial

planning by using SSAS, cube and data mining. Presented efficient

financial data and forecast trends to CPA. Generated useful

information from history and financial model. Used advanced SQL

queries for generating reports with SSRS.

CHINA MERCHANTS BANK;

Nov 1993- Jun, 2000

Shenzhen, China

Manager of Loan & Marketing Department

o Designed, implemented, and closed US$12M commercial loan generating

US$4.5M in profit over 6 years; resulted in attracting additional high

profile and net worth clients and recognition as best, first, and

largest housing loan in bank's history.

o Established business relationship with Shenzhen Financial Bureau and

successfully absorbed government deposits through personal efficiency,

professionalism, and integrity.

o Developed and closed US$100M in loans, comprising 30% of department's

total business Generated US$10M in profits while maintaining zero loss

throughout entire 7-year tenure.

o Recognized for outstanding contributions and stellar performance. With

multiple awards including Outstanding Sales Person in Savings Account

Acquisition (2000), Ten Most outstanding

Employees (1999), Outstanding Young Woman in Professional

Achievement (1998) and Ten Most

Outstanding Staff in Credit Loan Management (1997).

SKILLS

o Database: Oracle 10g,11g, SQL, sqlplus, SQL*Loader, My SQL,

o Reporting: Crystal Report XI, 2008, MS Access, MSBI-SSIS,SSAS and

SSRS

o Language: HTMI, PHP, PL/SQL

o Internet: Apache Web Server

o MS Office: Word, Excel (PowerPivot, Vlookup,Macro), PowerPoint,

Outlook, Access.

o Accounting Software: Advanced QuickBooks ( Fund E-Z

EDUCATION & TRAINING

Oracle 11g, SQL2008, MSBI-SSIS, SSAS and SSRS. Crystal Report XI,

2008

Master of Science in Finance - George Washington University;

Washington, D.C. (2006)

Bachelor of Arts in Finance - Zhongnan University of Economics

and Law; Wuhan, China

Contact this candidate