. 10+ years of experience in data analysis, business analysis, reports
development and report management, 6 + years of experience in SSIS/ETL
and 5+ years of experience in ERP application development
. Experienced with full project life cycle, Agile and/or Scrum
methodologies. Strong experience in relational database, data warehouse
design, and data modeling.
. Excellent experience in developing ETL packages using SSIS, BCP, Bulk
Insert, and other 3rd party tools to load data into different
destinations from a variety of data sources including SQL Server,
Oracle, Excel, XML, Access, and flat files.
. Advanced skill in T-SQL, PL/SQL, stored procedures, functions and
experience with MDX.
. Proficient experience in developing reports and to drill down/drill
through function with SSRS, Crystal Reports, Excel, and other report
tools including: Tabular Reports, Matrix Reports, Parameter Reports, and
KPI Reports dashboard with charts.
. Proven ability to approach problems effectively, prioritize and complete
. Experience in health care, retail, wholesale, bank, and manufacture
accounting analysis reports
. Quick learner, takes initiative, and hard worker. Willing to take
Database: SQL Server 2012/2008/2005/2000, Oracle11g, Access 2007, 2012,
BI/Data model tools: SSIS, SSAS, SSRS, Crystal Reports, SharePoint, Power
Language: SQL, T-SQL,PL/SQL, Visual Basic, JAVA, C++, C#, MDX
Application: SAP, Clinical Management, Ztax, Frx, PDI,
Microsoft Certified: MCDBA, MCSE SCJP (SUN Certified Java
CPA (Certified Public Accounting) CIA (USA Certified Internal
Auditor) (passed 4 exams of 5)
Bachelor of Science in Computer, Bachelor of
Sr.BI developer TRUONEX, Inc. (2012.9- 2014.12 )
. Created ETL packages using SSIS to extract data from SQL Server, Oracle,
XML, CSV, ADO, ODBC and cleans up the data using Data Quality Service
(DQS), Fuzzy Grouping, and transformed data using various dataflow
components (i.e.: lookup, union, merge, merge join, conditional, splits,
derived column, script component, etc.) and inserted the cleaned and
transformed data into different destinations using Change Data Capture
(CDC) for incremental loading.
. Generate periodic reports based on the statistical analysis of the data
from various time frame and division using SQL Server Reporting Services
. Increase the performance of Reports by Query Optimization, logging file
analysis, Report server setting and report schedule.
Selected three of complete projects in last two years
1. As a developer, worked with a retail company IT and sales department:
Tested and modified existing SSIS packages, created new SSIS packages,
built a SSAS cube, and developed reports
2. As a consultant, worked with a health care company IT and accounting
department: Wrote complex SQL Queries, Stored Procedures, Triggers,
and Views to resolve two application system data differential
problems. Modified current SSRS reports to increase performance.
3. System Migrations: Migrated legacy applications to new ERP system
successfully without adverse effect on business. I did project
technical data migration documentation, created ETL packages, and
migrated legacy reports.
BI developer Universal Delaware Inc., Newark, DE (2009.8-2011.4)
(Managed 46 retail gas stations)
. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived
Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task,
Data Flow Task, and Execute Package Task to import multiple source data
to data warehouse.
. Built business analysis reports, monthly KPI reports, and built daily
reports that includes: item sales, receiving, adjustments, item audits,
cash over/short, and site analyst.
. Implement Testing and troubleshooting by debugging, configuring logging,
and even handling.
Selected Work with project group to complete projects
Developed Data Center (Data warehouse) to Manage 46 gas stations data. In
the project, I developed 128 SSIS Packages to transfer to different
multiple source data, to Data Center, and I built cubes and generated 39
analysis reports. Used SQL server BI (SSIS, SSAS, and SSRS).
Sr. Systems Analyst Universal Marketing Inc. (Wholesale) New Castle, DE
. Consulted managers and users to gather and interpret functional
specifications and user requirements; analyze user requirements,
procedures, and problems to improve existing systems and workflows.
. Analyzed current system, installed and insured new ERP systems in all
. Provided expert technical consulting and effective leadership direction
across different applications that ensure valued solutions supporting
organizational objectives and priorities.
. Built ETL packages, defined integration flow, imported daily outsource
data which includes: supplier price, sales price, supplier invoice,
vendor invoices, EFT, credit card, bank statement, etc.
. Developed financial reports such as: Current Period and YTD Cash Flow,
Revenue Analysis reports, Pricing analysis reports, etc. in Crystal
Oracle Database Developer, Ritztech Co, Gaithersburg, MD (2004.11-2007.1)
Developer & Consultant for Financial System Software, DaHan Co., 65 Fujian
Rd, Nanjing, Jiangsu Province, P.R.C(1999.1-2002.5)