SUMMARY:

• 5 years experiences of SQL Server 2012, Access 2013 database, strong skills in data loading and reporting tools such as: SSIS, SSAS, and SSRS.
• Experienced in Power BI, SAP Crystal Reports 2011, Webfocus, Oracle 12c, SharePoint, Agile Scrum SDLC methodology; knowledge in Cognos Analytics, Tableau, Hadoop/MongoDB, etc.
• Strong data manage and reporting experience on quantitative analysis.
• Strong business sense support by accounting and statistic experiences.
• Professional experience of most advanced SQL Server 2012 Database server installation, login and user creation, role and permission configuration. Involved in logical and physical design of the database and data warehouse.
• Proven advanced SQL queries skills including multi - table joins, self-join, single row function, group functions, subqueries, set operations, CTE, Triggers, Stored Procedures, Scripts.
• Professional experience on load a variety of data sources into SQL server database tables.
• Experienced in high performance data integration solutions-Microsoft SQL Server Integration Service (SSIS), designed/developed ETL packages and loaded data into warehouse.
• Built cube, created KPI, used MDX query designer to build matrix reports.
• Generated Report using SQL queries, SSRS, PowerBI, advanced Excel /Access, Crystal Reports, Webfocus and SQLplus.
• Robust MS Access and advanced Excel skills with Pivot tables, Macro and VBA.
• Data accuracy and detail oriented with a rigorous technical and business logical, critical thinker, strong analysis skill with excellent diagnostic and problem-solving capabilities.
• Expert in managing high volumes and complex work, with the ability to multi-task in a demand environment.
• Independently capable with strong communication and interpersonal skills, responsible, reliable, hard worker and comfortable working in a team.
• Strong ability to communicate technical information in simple, clear non-technical expression.
• Intelligent curiosity, sharp in learning and comprehending new systems and methods with passion on data field.

TECHNICAL SKILLS:

Database: SQL Server 2012, MSBI (SSAS and SSIS) 2012, Access 2013, Oracle 12C

Reporting: MSBI (SSRS) 2012, Access 2013, PowerBI, SAP Crystal Reports 2011

Language: SQL, T-SQL, Excel Visual Basic

MS Office: Word, Excel, PowerPoint, Access

EXPERIENCE:

Confidential

BI developer/ Data Analyst

Responsibilities:

• Got business requirement from end users and generated all kinds of reports( including ad hoc reports), such as created Tabular Reports for the product sold detail or the employee information; Matrix Reports for sales which aggregated data by region and year; Parameter Control Reports for filter the report data or control the report appearance such as showing only the year and the region the users enter; Cascading Parameter Reports for filter data hierarchically to manage large amount of report data; List reports for grouping all information for each customer; Dynamic Reports for displaying selected columns/fields dynamically; Procedure Report for passing multi valued parameter to stored procedure; the Pareto Chart to highlight the most important among a (typically large) set of factors; Dashboard Reports with drill down drill through functions, etc. As well, in the report processing, involved in publishing/deploying reports to website or different environment, managed reports, reports subscription/delivering, and also monitored reports, involved in writing EXPRESSION, such like IIF, SWITCH, SPLIT, CEILING, RUNNING VALUE, LOOKUP function.
• Successfully extracted data from a large volume financial flat file table, loaded to staging table, transferred data using such single row function,, trim, upper, case function, substring, convert function, as well window function etc., and load into data mart/Data warehouse; from data mart/data warehouse, created cube, sliced and diced the financial data in numerous ways, added dimension hierarchies, edited the cube for KPI and provided progress indicators against a goal, increased sales by 10%, increased the customer base by 20%, also increased average order amounts by 15% over the same period from the previous year; queried the data by MDX to generate the matrix reports, presented company financial operation performance using dash board.
• Did data mining by using SSAS data mining wizard to help decision making, e.g. used the decision tree algorithm mining the customer to see who is most likely to purchase the product, queried the mining model prediction to predict unknown customer buying behave, used the predict probability function to get the probability of the given customer s purchasing a product, query results view by DMX. Used the time series algorithm to predict the sales inventory or staffing levels need to be 3 days from now.
• Involved Oracle data warehouse migration to Star Schema SQL Server data warehouse, loaded dimension tables and fact tables.
• Dynamically extracted multiple files from folders and loaded to database tables, as well renamed those files to archive to new folder using SSIS package, deployed the SSIS project to SQL Server Management Studio to schedule job.
• Dynamically used BCP/Batch file extract out data from databases into flat files.
• Created log file/log table for audit data.
• Did deduping using group function, subquery or temp table. Updated the inventory using the Merge Statement, adjust credit Amounts with a WHILE Loop and IF…ELSE statement, used Trigger watching the vender table to update the format.
• Designed Navigation Form making financial reports automation by using Macro, VBA in Access. Also automatically pull data from different data sources into spreadsheets. Created financial pivot table monthly/annually in excel, generated Dynamic Excel report-Financial Quarterly comparison using advanced Excel skills, such as Vlookup, IF function.
• Helped DBA in performance tuning, such like remind DBA to analyze tables getting statistics used by the query optimizer, check execution plan, execution log and turn on trace, and try to write the query more efficiency for better performance.
• Have experiences in using Power Query, Power Pivot to create reports, connected to SQL Server by using different data sources (SQL Statement, View, Function, Stored Procedure), setting filters/cascading filters, grouping, sorting, creating custom columns, reordering columns, using query formulas.
• Duplicated Power Query report using report code M-Code and M-code basics, experienced in Multi Filter Generator, query folding, merging in Power Query, and managing parameter, also converting SSRS report to Power Query report.
• Experienced in Power BI Desktop, connecting to data, transforming and shaping data, modelling data, creating reports, using visualization, page and report-level filters, creating interactive dashboard, drill down/drill through dash board and using DAX.
• Have efficiently used all kinds of Experts in CR, such as Template Expert for format, Select Expert for selecting specific records/ formatting section/inserting parameter, Group Sort Expert for Top N etc., DB Export for linking multiple tables to reports.
• Used CR formula to conditionally format fields and sections, used formula syntax for calculation/ date calculation/date convert/date compare, created string formulas for the customer table, added bookmarks to formula, used ChrW(13), IF function, Is Null test in CR.
• Imported/Exported a Parameter Field Pick List, used Dynamic Parameter with cascading values for hierarchy filter (e.g. by Category/sub category/ product), Date Parameter for select date from calendar, Parameter for TOP N, Max, Min or Sorting.
• Created running total (Real total & line counting), variables, image, linked/unlinked sub report in CR, etc.
• Used Stand Report Wizard for analysis showing top N sales/adding graphs/applying predefined style, used Blank Report Wizard for customization, and used Cross-Tab Wizard for creating a summarized/sliced view of the data.
• Created cross tab reports, customized group name field by formula in Cross-Tab Expert, added advanced (customized) chart/drill down chart to reports.
• Exported a report to different formats, published/distributed CR with CRD.

Confidential

Financial Analyst/ Accounting Assistant

Responsibilities:

• Processed all the accounting records, dealt with depreciation calculations, foreign currency transactions and bank reconciliations.
• Managed accounting monthly, quarterly and year end processes, prepared the trial balance sheet and financial statements.
• Conducted inventory/cost/revenue analysis, analyzed and summarized information and trends for management reports.
• Developed budget plan, performed the statement and variance analysis.
• Facilitated communication with the internal and external auditor.