OBJECTIVE
Data Warehouse Developer/Business Intelligence Analyst/Database Analyst/Financial Analyst/ Reporting Engineer

SUMMARY

• Bachelor of Arts in Economics, extensive experience on SQL Server, Oracle, Access database.
• Strong data management and reporting skills on qualitative and quantitative analysis.
• Professional experience of advanced SQL Server Management Studio (SSMS), including database server installation, login and user creation, role and permission configuration.
• Professional experience on load variety of large volume data files into SQL server database tables, migrate and map Oracle tables into SQL Server database tables and generate Report with Crystal Report, Excel.
• Professional experience on high performance data integration solutions-Microsoft SQL Server integration Service (SSIS), including Extraction, Transformation, and Load (ETL) packages.
• Professional experience on Microsoft SQL Server Analysis Service (SSAS), creating Cube, Key Performance Index (KPI), and data mining methodsto generate reports withMicrosoft SQL Server Report Service (SSRS).
• Robust MS Access and Excel skills including Pivot Table/Chart.
• Clear documentation on the process of technical work.
• Excellent auditing and reporting capabilities on business operationprocess (data) to support multi-levels decision making.
• In-depth experience on Customer Relationship Management (CRM).
• Outstanding parallel and multi-dimension analysis skills financial data from major competitors, industries, economy entities and global economy.
• Excellent team player with good verbal, written communication and interpersonal skills.
• Proven ability to approach problems effectively, to prioritize and complete multiple tasks in a timely manner.
• A quick learner, initiator and hard worker.

COMPUTER SKILLS
Database: Access 2010, SSMS2008/2012, SSIS, SSAS, Oracle SQL 10g/11g/11gR2
Reporting: Excel, Access 2007, SSRS, Crystal Report 2008
Language: SQL, T-SQL, MDX, Visual Basic
Internet: MS SharePoint
MS Office: Word, Excel, PowerPoint, Access, STAT
Selected Achievement on Business Intelligence

• De-normalized Data Warehouse(DW) design with star schema and transformed DW from ERD (Entity Relationship Diagram). Modeled and created different types of dimension tables and fact tables, and bulk insert and data flow insert into data warehouse from source database and added primary key, foreign key and index.
• Established projects in SQL Server 2008/2012 SSIS, created ETL packages to extract multiple table data files from local/remote/SQL Server/Oracle database/ Excel/Flat files, and from other sources into staging tables; reformatted& inserted the cleansed data into destination files; audited the ending row counts, updated logs, and deployed SSIS packages and solutions into production system.
• Developed projects in SQL Server 2008/2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships, generated KPIs, deployed to SSRS and SharePoint, and exported cube for Pivot Table/Chart and data mining in Excel(SSAS). Processed various data-mining methods to generate solutions in BIDS, deployed them to SSAS instance, trained and queried the model using Multi-Dimensional Expression (MDX).
• Generated variety of business reports in SQL Server 2008/2012 SSRS including matrix report, parameter report, dashboard and drill-up/down function; built reports from various resources including database/Analysis Services cube(MDX designer)/DW; configured report server, deployed reports on SSRS and SharePoint web server and maintained reports.
• Customized SharePoint 2010 including Performance Points and drill up/down Dashboards, Power Pivot Gallery, document library; integrated reports from Excel, Access, SSRS and Crystal Report.

Selected Achievements on SQL Server 2008/2012 Database& Oracle SQL 10g/11g/11gR2 Database

• Configured SQL Server 2008 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.
• Normalized database design to generate ERD, created database tables with various constraints including primary key, foreign key, etc.
• Loaded data from flat data files into SQL Server 2012 database tables using bcp, bulk insert, and table export/import; loaded data from flat data files and excel sheet into Oracle database using SQLLoader and SQL Developer.
• Extracted data from SQL Server 2012 database tables and Oracle database tables into flat data files and Excel sheet.
• Power user of advanced SQL queries with multi-table joins, group functions, sub queries, set operations and T-SQL/PL/SQL functions.
• Generated variety of business reports using SQL Server 2012 SQL query, SSRS, Crystal Report 2008 and Excel 2010 Power Pivot table.

WORK EXPERIENCE
Business Intelligence Analyst (May 2010- Present)
IT consulting firm providing IT services and solutions to businesses in US

• Successfully migrated many SQL Server database tables into Oracle database, loaded large amount of data from flat file or table into databases; analyzed data use advanced SQL to generate all sorts of business reports with SQL and Crystal Report.
• Independently designed, built, and de-bugging processes for internet marketing campaign.Using SSIS ETL packages to load large volume of data to database tables, writing stored procedures and advanced SQL to generate reports for analyzing and evaluating data to meet functional and non-functional business activities.
• Developed reports using SSAS and SSRS including KPI, matrix and parameter reports.

Personal Research Project on Investment (2007-2011)

• Built multiple advanced models scaling from individual product up to global economy through multi-dimensions matrix analyzing (hierarchy/attributes relationship) on market force and data pattern with different time phases.
• A manuscript of approximate 400,000 words with acute insights.

Foreign Currency Analyst and Trader (2002 – 2003)
Confidential,Beijing, China

• Analyzed the exchange rate trends over 7 major currencies (US dollar, Canadian dollar, Australian dollar, Euro, Japanese Yen,Swiss Franc and British Pound) tied to the macro economies and stock markets in these countriesusing financial database and information system.
• Generated daily / weekly/ monthly portfolio strategies and reports with Microsoft Excel, and faxed to the clients of three classes (Platinum, Gold, Silver) in banks, investment institutions and import/export companies.
• Provided real-time trading consulting service to Platinum clients, based on client’s risk-taking preference, and traced the feedback to adjust clients’ trading strategy.
• Trained new team members on technical analysts (Chinese Edition,“Technical Analysis methods of Futures Markets” by John J. Murphy and “Japanese Candle Charting Techniques” by Steve Nison).

Stock Analysis & Information Database Application Instructor (2001- 2002)
Confidential,Beijing, China (One of largest companies on financial markets’ data collection, transformation, compression, management and mining)

• Downloaded, installed the information database applications, and created user accounts for clients. Extracted real-time data of stocks, commodities, currency, bonds, global major stock market indexes and real-time news from the remote database center to user’s computers and backed up the data.
• Used powerful technical functions to analyze the trend of selected stock prices in the finance market and generated reports for clients’ trading strategies.
• Used information resources to discover the most valuable company by parallel researchon different financial reports.
• Presented lectures to employees and clients located in ten major cities in China Northeastern, e.g. Beijing, Shenyang, Dandong, Dalian, Yingkou, Panjin, Changchun, Chaoyang, Jilin, Liaoyang.( multi-group communication skills)
• On-site instruction and technical support to solve clients’ practical problems.
• Standardized the course lectures to improve the training efficiency.

Market Director (1998 – 2000)
Confidential,Qingdao, China

• One to One Customer Relationship Management; collected potential client’s information, categorized clients, and generated follow-up plans for on-site visit.Analyzed client’s feedbacks, discovered the client’s goals, dug the incentive of the purchasing, and made a final strategy to match the client’s demand, and offered other related services to keep their loyalty.
• Provided reports of the various commodity markets(cooper, soybean, green bean, red bean, and peanut) to clients as the reference for their trading decisions.
• Used WPS Office Excel 1997 to record, analyzed and trackedthese client’s information.

Auditor /Accounting (1994 – 1998)

• Confidential,Worked with cashiers team to monitor business operation process (data) and to audit the daily revenues and transactions from all of business departments (room rentals, room services, Chinese/Western/Japanese/Korean/Thai/Donglaishun restaurants, two banquets rooms, lobby/low bars, bowling, casino, entertainment, physical therapy, two shopping centers, business center, car rental, travel agents, laundry, telephone connections, etc., which can total up to 25,000 transactions daily.
• Collected and extracted all daily revenue data and large volume receiptsand records from the front operational system to local staging database system.
• Audited all transactions on both materialized and computer-end data in staging database on a daily basis. Checked the unmatched data items and solved them with casher team.
• Released and uploaded accurate, complete,and consistent data from local staging database system to internal accounting system for further financial analysis.
• Generated multi-level performance reports, and provided to CEOs to support their overall strategies, to business department managers and team leaders tomonitor their departmental operations, and to human resource department toevaluateemployee benefits management.
• Backed up both materialized data and computer-end data on a daily basis, and archived the reports and audited records.
• Responsible for any ad hoc queries and reports for computer and materialized data from any departmentmanagers.
• Worked with the audit team using Visual FoxPro Language to generate local staging audit and report system.
• Cooperated with the IT department team to upgrade new operation system of the whole hotel within 2months, and configured the connection of operation system and local staging system to tested and guarantee that auditing process is correct, effective and smooth.

EDUCATION

• University of Calgary
• Bachelor of Arts in Economics
• Core courses: Behavior Experiments, Game Theory, Statistic, Intermediate Economics Matrix (Statistics), Intermediate Accounting (I&II), Intermediate Micro/Macro-Economics, International Trade/ Economics.
• LEAP, Learning English for Academic Purpose, “Distinguished Student Award” as the president in themulti-culture class.
• Diploma in Marketing