Business Intelligence Analyst Resume

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).

TECHNICAL 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

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential

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

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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship