SUMMARY:

• MS of Management Information System with 5 years’ experience of SQL Server 2008/2012, Oracle 10g/11g, Access 2007/2010/2013 database and Data Loading and Reporting tools such as: SSIS, SSRS and Crystal Reports 2008/2011.
• Strong data management and reporting experience on quantitative analysis.
• Professional experience in creating reports based on business requirements by using SSRS, Crystal Reports and Tableau.
• 2+ years’ experience with Tableau Desktop, Tableau Server and Tableau online.
• Experience on high performance data integration solutions - Microsoft SQL Server Integration Service (SSIS), including extraction, transformation, and load (ETL) packages for data warehousing.
• Professional experience in communicating with business users to understand their needs and then translate them into solutions which deliver business values.
• Robust MS Access and Excel 2013 skills with Power View and Power Pivot tables.
• Professional experience on load variety of large volume data files into SQL server 2008/2012 database tables.
• Professional experience of most advanced SQL Server 2012 Database server installation, login and user creation, role and permission configuration.
• Professional experience on load variety of large volume data files into SQL server 2008/2012 database tables.
• Deep knowledge and hands on experience in Accounting and Finance.
• Strong team player with great verbal, written communication and interpersonal skills.
• Proven ability to approach problems effectively, prioritize and complete multiple tasks.
• Hands on experience with agile business intelligence development.
• Quick learner, take initiator, and hard worker.
• Willing to take responsibilities.
• Fluency in both spoken and written English and Chinese (Mandarin).
• 2+ years of experience in Tableau Desktop by developing reports (dashboards, views, worksheets, data sources), by publishing views, worksheets, etc. from Tableau desktop to Tableau Server, and by setting user permissions, data security in Tableau Server.
• Develop, design interactive dashboards, data visualization, and story board.
• Proficient in design views with various kinds of charts such as TreeMap, Scatter plots, dual map
• Barinbar, Waterfall, Lollipop, etc.
• Creating Tableau Calculations (Table Calculations, Hide Columns, Creating/Using ParameterTotals)
• Translate business requirements into sustainable and efficient visualizations and reporting.
• Extract data from RedShift and other platforms using SQL and put into a form conducive to answer business questions in Tableau.
• Administer user permissions and organize the growing number of projects, user groups and workbooks such that they best satisfy the business needs of diverse groups for our client.
• Design, update and administer the metadata of the Tableau workbooks, so that descriptions of data are consistent and reliable across multiple projects and workbooks.
• Administer user permissions and organize the growing number of projects, user groups and workbooks such that they best satisfy the business needs of diverse groups such as strategymarketing, finance, real estate, credit and merchandising.
• Used Tableau to extract digital marketing data from Google Analytics and to design viewsworksheets and dashboards to analyze potential online visits patterns, etc.
• Techniques from Tableau such as aggregates, hierarchies, charts, box plots, mapping, filtersquick filters, context filter, data blending, table calculations, trend lines, forecast analyticscalculated measures were used in all the projects.
• Created ETL packages using SQL Server 2008/2012 SSIS Designer to extract data from flat file, reformat the data, and insert the reformatted data into fact table, loaded different types of dimension and fact tables into data warehouse, deployed SSIS packages and solutions into production system using SSDT or BIDS.
• Developed projects using SQL Server 2008/2012 SSAS, created data source/data source view/cube with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions; created data-mining solutions in BIDS or SSDT, deployed them to SSAS instance, trained the model and queried the model using DMX.
• Generated variety of business reports using SQL Server 2008/2012 SSRS, Tableau including matrix report, parameter report, dashboard with charts and drill down function; built reports from Analysis Services cube using MDX query designer; configured report server and deployed reports on web server and SharePoint.
• Interfaced with business users to understand their needs and then translated them into technical solutions which can deliver business value.
• Configured SQL Server 2008/2012 and Oracle SQL 10g/11g/11gR2 database parameter files to adjust the memory usage and file size.
• Created database tables with various constraints including primary key, foreign key, etc.. Loaded data from flat data files into SQL Server 2008/2012 database tables using bcp, bulk insert, and table export/import; loaded data from flat data files and excel sheet into Oracle database using SQL*Loader and SQL Developer.
• Extracted data from SQL Server 2008/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, Window functions, CTE, subqueries, set operations and T-SQL or PL/SQL functions.
• Generated variety of business reports using SQL Server 2008/2012 sql query, SSRS, Crystal Report 2008/2011, Tableau 8/ 8.3/9.0 and Excel 2013 Power Pivot, Power Query, Power View.

COMPUTER SKILLS:

Database: SQL Server 2008/2012, Oracle 10g/11g, MSBI 2008/2012, SSIS, Access 2007/2010/2013

Reporting: Tableau 8.1/8.3/9.0, Access 2007/2010/2013 , SSRS 2008/2012, Crystal Reports 2008/2011

Language: SQL, Excel Visual Basic

Internet: HTML, Google analytics.

MS Office: Word, Excel, PowerPoint, Access, Hands on experience and robust skills in Tableau 8/ 8.3/9.0, Hands on experience in OBIEE, Hadoop/Hive, OpenQuery from Teradata in SQL Server environment, Working Knowledge in C# and XML and MongoD.

WORKING EXPERIENCE:

Business Intelligence Analyst

Confidential, San Bruno, CA

Responsibilities:

• Help our clients get insights by using Tableau to analyze potential business expansion in developing projects.
• Query data in Hadoop Hive, put them in RDMS and generate reports by Tableau
• Assisting in the design and support of ETL jobs and SSIS packages.
• Gathering, analyzing and defining business requirements and translate them into technical solutions which can deliver business values.
• Generating reports by Tableau, SSRS and T-SQL, Crystal Report.
• Creating KPIs to improve corporate profitability measures using SSAS
• Installing and configuring SQL Server 2012 instances for data warehouse implementation
• Assisting in the development and implementation of data warehouse and data marts.

Data Analyst

Confidential, San Bruno, CA

Responsibilities:

• Manipulated, cleansed & processed data using Excel, Access, SQL and SSIS components.
• Responsible for extracting, loading and validation of the company’s manufacturing data
• Interviewed business users to get business requirements.
• Analyzed raw data, drew conclusions & developed recommendations.
• Used SSIS tasks and wrote T-SQL scripts to transform data for data loads and extracts.
• Involved in designing data warehouse for reporting purpose.
• Designed cubes by SSAS and analyzed business information.
• Generated business reports by SSRS and Crystal reports based on business requirements.

Reporting Analyst

Confidential

Responsibilities:

• Prepared various statistical data analysis reports by Excel for corporate clients, provided ad-hoc updates and modified report templates as required
• Scripted VBA code which helped managers to store client meeting activity information in automated way
• Created complex formulas and conditions to convert raw data in business information, applied vlookup function to merge or filter information from various data set for reporting and statistics gathering purposes
• Efficiently used PivotTables and Lists to summaries required statistics, helped decision makers to review progress and draw future plans
• Created interactive statistics generating module in MS Access to publish reports, this helped timely distribution of dashboards and business statistics while maintaining data accuracy

Web/Database analyst

Confidential, Redwood City, CA

Responsibilities:

• Assisted in creating and maintaining E-commerce web site by using HTML
• Performed analysis and presented results using SQL, MS Access, Excel and Visual Basic Scripts.