Business Intelligence Analyst Resume
5.00/5 (Submit Your Rating)
Maple Grove, MN
AREAS OF EXPERTISE
- SQL Server TSQL
- Database Administration Training
- Management and Leadership Skills for First - time Supervisors and Managers
- Cloud Security
PROFESSIONAL EXPERIENCE
BUSINESS INTELLIGENCE ANALYST
Confidential, Maple Grove, MN
Responsibilities:
- Developed, published and scheduled Power BI visual reports, dashboards and KPI scorecards using Power BI desktop per business needs/requirements
- Modelled a customer satisfaction dashboard, improving visibility of customer touchpoint and consulted regional directors on how to scale up
- Segmented customers using clustering analysis on purchase patterns
- Regular feed reporting to the executive committee on product sales
- Utilized SSIS to extract data from 3rd party tools and perform data cleansing, transformation and loading into the data warehouse
- Executed dashboard setups and data manipulation using DAX
- Cloud experience in Azure Data and Analytics services
BUSINESS INTELLIGENCE ANALYST
Confidential, Mounds View, MN
Responsibilities:
- Built automated reports and dashboards with Power BI and other reporting tools.
- Created and managed database objects such as tables, views, indexes, stored procedures, and triggers & maintaining referential Integrity
- Created reports as per business requirements and support the development of performance dashboards that encompass key metrics that can be run daily, weekly or monthly
- Tested report results, employing test plans and automated testing where possible
- Worked closely with other developers, UX designers, and data engineers
- Worked with business analysts to identify gaps in current processes and help develop requirements for better enhancements
DATA ANALYST
Confidential, Arden Hills, MN
Responsibilities:
- Made simple and powerful charts, drill - downs leveraging appropriate analytical and graphing components
- I was able to optimize dashboard performance to handle large volumes of data
- Conducted unit testing and troubleshooting
- Tested report results, employing test plans and automated testing where possible
- Wrote T-SQL or other queries, understanding relational databases and data linking
- Crafted and executed ad hoc queries upon request for data
Database Administrator
Confidential, Mounds View, MN
Responsibilities:
- Installed, configured and maintained all relational database instances across development, staging, and production environments.
- Restored databases as service outages occur, including after hours and weekends
- Maximized performance through effective hardware purchases, server configuration changes, or index/query changes
- Minimized false alarms by appropriately configuring database monitoring utilities
- Ensured database server topology, configuration, and maintenance are designed and executed to meet SLA objectives