We provide IT Staff Augmentation Services!

Business Intelligence Analyst Resume

4.00 Rating

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'd love your feedback!