Business Intelligence (BI) Analyst Resume

SUMMARY:

Accomplished & results - oriented Business Intelligence & Data Analyst with 3 years of professional experience that connects the dots between disparate & complex data sources while driving critical business insights & recommendations through the integration of technologies, data warehousing & data programming
Analyzed critical business processes that ensured data accuracy for essential Confidential reporting, measurement, analysis & forecasting
Drove cross-functional Confidential metrics development & data gathering techniques to meet stated business goals
Created internal forecasting models which aided in workforce management by aligning schedules & trends with business decision makers
Created database Stored Procedure which searches any string in all existing databases within SQL environment

TECHNICAL SKILLS:

Programming Languages: C#, R

Databases: Oracle, Azure SQL Server

ETL Tools: SSIS, Informatica, Datastage

Reporting: SSRS, Power BI, Microstrategy, IBM Cognos, Tableau

Excel: VLOOKUP, Pivot Tables, PowerPivot, PowerQuery

Big Data: Hadoop

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence (BI) Analyst

Responsibilities:

Performed forecasting analyses & insights generation to assist in critical business decision-making
Assisted in creating Workforce Management system that drove efficiencies in resource tracking & management analysis
Created innovative Business Intelligence (BI) framework through data-driven techniques
Gained experience & knowledge in creating multi-dimensional cubes used for data querying
Created SSIS packages & Power BI reports that drove business requirements
Provided guidance & expertise in web scrapping & task scheduling
Collaborated & effectively communicated with cross-functional departments to understand stakeholder requirements & data needs

Confidential

Business Intelligence (BI) Developer

Responsibilities:

Launched essential Stored Procedure to search a string in all database objects
Heavily involved with management of end-to-end User Access Logging for SSAS, SSRS & SSIS
Responsible for developing key BI features such as Stored Procedures, Views & User Defined Functions
Member of highly-driven team that created SSIS packages to migrate large amounts of disparate datasets
Created, developed & designed compelling data reports in Power BI that drove essential analysis & insights
Collaborated effectively with broad departmental teams to ensure project success & business objectives were met within stated timeframes

Confidential

Database Analyst

Responsibilities:

Executed database test cases & successfully led key troubleshooting efforts & defect resolution
Coordinated with departmental counterparts to develop effective test plans & use cases
Successfully handed critical responsibilities of supporting QA Analyst in fixing database issues to proactively meet client requirements
Executed successfully case study involving end-to-end data warehouse implementation
Created new SQL database objects such as Procedures, Functions, Packages, Triggers, Indexes & Views
Regularly presented test findings & key results to senior leadership for recommendations
Collaborated effectively with cross-functional teams to achieve organizational goals & business objectives
Actively followed all standard procedures & guidelines to document testing tasks & results
Recognized as leader for evaluating testing workflow charts, correcting database errors & modifying essential database systems
Obtained critical knowledge of data warehousing techniques & essential Business Intelligence concepts