Senior Business Intelligence Analyst
Innopak LLC
Delaware, OH
2022.08 - Current
Sean E. Phillips
Data Engineer
Springfield,IL
Summary
Adaptive Business Intelligence Professional having 7+ years experience with various ERPs, Database Technologies, ETL Tools and Microsoft Power Platform Stack. Seeking work as a consultant or full-time data engineer at a top company.
Work History
Business Systems Intelligence Analyst
ValueHealth LLC
Leawood, KS
02.2021 - 06.2022
- Designed ETL solutions for 10+ EHR and 3rd party systems, including REST and Database sources leveraging Informatica Intelligent Cloud Services
- Maintained and enhanced legacy SSIS ETL packages .
- Created 4 QlikSense dashboards which provided company insights into operations.
- Migrated business logic from NETEZZA SQL to POSTGRESQL equivalent.
- Generated data models in POSTGRESQL for consumption into QlikSense dashboards
Business Intelligence Analyst 2
MCPc Inc.
Cleveland , Ohio
06.2018 - 02.2021
- Managed 70+ client-facing Power BI Service workspaces and reports, ensuring data quality.
- Developed and maintained 10+ internal, operational Power BI Service workspaces across departments.
- Collaborated on 5+ SLA reports with service managers to ensure client success,
- Curated SSRS reports consumed by business development and sales teams.
- Integrated multiple LOB applications into Power BI desktop reports.
- Developed Power App for printer selection based on Warehouse location for procurement team
- Leveraged Azure Logic Apps and Azure Service Bus as part of ETL of Sales estimates which populated as part of nightly Power BI scorecards
- Secured Power BI Service environment adhering to best practices and utilizing Row Level Security and Azure Active Directory Security Groups.
- Enabled 4x throughput of warehouse shipping department by automating integration between ERP and FedEx systems.
Business Analyst NOC/SOC
MCPc Inc.
Cleveland, OH
12.2017 - 06.2018
- Visualized case and call statistics in Power BI for th department.
- Co-developed internal KPIs with management for Power BI reports.
- Conducted interviews with business users to collect information and requirements.
- Reviewed files, records and other documents to better prepare Call Center for case responses.
- Mapped-out activities to identify gaps and remediate inefficiencies.
- Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
OSC Analyst 2
MCPc Inc.
Cleveland, OH
01.2017 - 12.2017
- Generated 1st generation of internal Power BI metrics and reports for calls department, including call statistics and KPI performance.
- Superbly handled 20+ customer problem tickets per day with CSAT score of over 90%.
- Resolved process flow problems, improved operations and provided exceptional client support.
OSC Analyst 1
MCPc Inc.
Cleveland, OH
04.2016 - 01.2017
- Migrated 60+ customers onto new Knowledge Base system, plus designed initial customer landing pages with each customers' section.
- Curated 20+ customer KBs with updated SOPs and best practices.
- Maintained excellent customer satisfaction score of over 90%.
- Diagnosed, troubleshot and resolved network and system problems.
Education
MBA - Finance
Cleveland State University
Cleveland, OH08.2018
BBA - Information Systems Technology
Cleveland State University
Cleveland, OH06.2016
High School Diploma -
Westlake High School
Westlake, OH06.2012
Skills
- Data Visualization
- Data Analysis
- Database Management
- Data Modeling
- Data Interpretation
- KPI reporting
- Systems Analysis
- Information Gathering
- Communication
- Project Tracking
- Operations analysis
- Self starting on new initiatives
Technologies
- Power BI Desktop & Service
- SSIS
- SSRS
- QlikSense
- DAX
- T-SQL
- Azure SQL
- Azure Data Factory
- Azure Active Directory
- Azure Service Bus
- Azure Logic Apps
- Power Platform
- PostgreSQL
- SQL Server
- Excel
- C#
- .NET Core
- VB
Other Experience
Small Business Owner at Unlimited Brilliance LLC 2019 - Current
- Own and operate life-coaching and personal development business.
- Filed appropriate forms and documents with Secretary of State of Ohio.
- Aligned branding initiatives and sales strategies with client goals.
- Earned $5,000 in year one of business.
IT Intern at MCPc Inc. 2014 to 2016
- Saved $50,000 in net profit through audit and cancellation of old telecomm lines.
- Contributed to team-based IT projects by lending assessment and management services.
- Aided problem resolution measures and suggested patches and hardware, software and network troubleshooting alternatives.
- Resolved issues and escalated problems with knowledgeable support and quality service.
Certification
- Data Modeling for Power BI Video Course (126 videos, 10+ hours)
- Power BI Dashboard Design Video Course (107 videos, 6+ hours)
Timeline
Senior Business Intelligence Analyst
Innopak LLC
2022.08 - Current
Business Systems Intelligence Analyst
ValueHealth LLC
02.2021 - 06.2022
Business Intelligence Analyst 2
MCPc Inc.
06.2018 - 02.2021
Business Analyst NOC/SOC
MCPc Inc.
12.2017 - 06.2018
OSC Analyst 2
MCPc Inc.
01.2017 - 12.2017
OSC Analyst 1
MCPc Inc.
04.2016 - 01.2017
MBA - Finance
Cleveland State University
BBA - Information Systems Technology
Cleveland State University
High School Diploma -
Westlake High School
Similar Profiles
Stacey MangumStacey Mangum
Store Manager at Gunsmoke Firearms LLC Formerly Hi-Caliber LLCStore Manager at Gunsmoke Firearms LLC Formerly Hi-Caliber LLC
Emma LuvianoEmma Luviano
Billing Manager at KDT LLC & KIDS DC, LLCBilling Manager at KDT LLC & KIDS DC, LLC
Kyle HornerKyle Horner
CSR & Logistics Coordinator at Global Plastics, LLC. - MGI International, LLC.CSR & Logistics Coordinator at Global Plastics, LLC. - MGI International, LLC.
Gosia WrayGosia Wray
General Manager (Progressed From Lobby Attendant) at Wyndham City CentreGeneral Manager (Progressed From Lobby Attendant) at Wyndham City Centre
Kelsey AlexanderKelsey Alexander
Customer Service Representative at Insurance King AgencyCustomer Service Representative at Insurance King Agency