Business Intelligence Analyst Resume

SUMMARY:

SKILL:

EXPERIENCE:

Confidential

Business Intelligence Analyst

Responsibilities:

Develop Data Vault data models using WhereScape Red and 3D
Develop SSIS, SSRS, and SSAS (tabular model) solutions for Micron users.
Generate Star Schemas using SSIS to populate dashboards and source Analysis Services tabular models.
Create and publish Analysis Services Tabular Models making use of DAX formulas.
Provide reports to stakeholders utilizing SSRS. Use subscriptions, graphing, drill - down techniques, variable data sources, and variable data sets.
Worked in an Agile environment using Jira
Federal Case Management system which tracks progress and status for all current and prior Vocational Rehabilitation clients.
Inventory/POS system for 6 stores.
P&L system for external food service vendors that the commission manages.
Real time budget reporting systems.
Ad-hoc user driven financial query systems.
Windows SharePoint collaboration systems.

Confidential

Business Systems Analyst

Responsibilities:

Developing business requirements and use cases.
Generating technical requirements for development team in India.
Participating in and leading peer reviews with the business teams, technical teams, and development teams.Designed a data warehouse with SQL Server and Analysis Services using HP’s online printer supply ordering system as the data source of the data warehouse. This included:
Transformed data daily into the SQL Server data warehouse from an Oracle based Linux system using Microsoft Data Transformation Services (DTS).
Employed MS Analysis services to refresh multiple OLAP cubes.
Developed Excel pivot reports to be accessed through an IIS web server.Designed and implemented a budget/forecast tool. This system used EXCEL templates for inputting forecast information from the field. This included:
Extracting, Translating, and Loading (ETL) data into a data warehouse format using Kimball methodology.
Using MS Analysis Services to generate multi-dimensional OLAP cubes.
Using Excel pivot reports to extract and present the data from the databases in multiple formats.