Power Bi Support Analyst
Resume:
Olaoluwa Olaniyi
******.*********@*****.***
PROFESSIONAL SUMMARY
• Qualified IT professional with over 9 years of IT experience in leading Healthcare, BPO teams, defining project scopes, resource management, architecture design and development of several applications.
• Experience in Data Architecture (Conceptual, Logical, Physical data models), Dimensional Modeling
(Star Schema, Slowly Changing Dimensions, Snowflake, Conformed Dimensions, Facts, Metrics etc.) and SME in Business Intelligence (Reports, KPIs, Scorecards, Dashboards etc.)
• Expertise as Solution Architect in Self – Service BI model to design and deliver end-to-end solutions, Infrastructure sizing, deployment architecture, benchmarking, and tuning applications for Dev, QA, and Production environments.
• Experience in designing, implementing, maintaining, and testing analytical, operational reports and visualizations using Power BI and SQL Server Reporting Services (SSRS) Technologies.
• Experience with Power BI Administration including installation and configuration of Power BI Desktop, Power BI Service, On-premises gateway and troubleshooting Row-Level security to add end users to different roles.
• Experience with Power BI Tools - power bi desktop, power pivot, power query, power view, power map, power bi dashboard, calculated columns and calculated measures using DAX, data modeling.
• Demonstrated ability in employing best practices using Tableau to build advanced dashboards containing actions, calculations, parameters, maps, trend lines, hierarchies etc.
• Excellent Experience as an ETL Architect for designing different database layers, mapping designs, ETL schedules and flows to meet SLAs, error handling and auditing etc. for integrating structured & unstructured data.
• Experience with Azure data lake storage Gen2 and Azure data factory pipelines.
• Expert Level Experience in designing, developing and performance tuning various Data Warehouse applications using SQL Server Integration Services (SSIS), SQL Server Analysis Services
(Multidimensional and Tabular) and Reporting services (SSRS).
• Proficient in Power Query, MDX and DAX used to create calculated measures in Multi-dimensional OLAP and Tabular cubes.
• Expert in performance tuning of complex stored procedures and queries using Execution Plans, SQL Profiler, performance counters etc.
• Conducted daily scrum calls, sprint planning, sprint reviews, sprint retrospective sessions and poker sessions and tracked the work estimates and efforts using Jira Agile board and VSTS.
• Excellent team player with demonstrated experience of working diplomatically and collaboratively with all levels of staff to ensure successful implementation of assignments. WORK EXPERIENCE
Array Behavioral Care (New Jersey, USA) Jan 2023 – Till Date Senior Business Intelligence Analyst
• Led the Agent Performance Reporting project during all phases of Architecture, Design, Development by working with Business stakeholders, Data Stewards, cross functional and technical teams and translating the requirements into technical specs for implementing data integration, reports, and visual dashboards.
• Developed effective visual reports, KPI scorecards with themes following UX guidelines and leveraged latest features available in Power BI to guide Users through a compelling data-driven story.
• Designed and administered Power BI Service Infrastructure (workspaces, data gateways, CI/CD pipelines) and created Executive Summary, National Teams dashboards using Power BI and SSAS cubes.
• Built multiple data policing Power BI reports to validate the data between data sources which improved the data quality by 30% and reduced data inconsistencies.
• Developed templates and procedures for standardization of deliverables and conducted data usage training for non-technical staff driving a 35% increase in data literacy across various departments.
• Built and maintained effective and smart "self-healing" workflows (SQL agent jobs) for ETL and Datamart updates and developed workflows auditing infrastructure (to identify slow running code).
• Extensively used advanced DAX and MDX expressions for creating calculated measures in Tabular and MDM Cubes
• Played a vital role in sprint planning, sprint reviews, sprint retrospectives, and daily scrums with the development team, resulting in DEV, QA, and Prod.
• Led the successful implementation of a data warehousing solution, improving data accessibility and reliability.
• Led the development and implementation of the data visualization dashboards using Power BI, resulting in a 20% improvement in data accessibility for the executive team.
• Conducted in-depth data analysis to identify trends, patterns, and outliers contributing to a 15% increase in operational efficiency.
• Collaborated with cross-functional teams to gather business requirements and translate them into actionable data solutions.
• Implemented ETL processes for efficient data integration, reducing data processing time by 30%.
• Write SQL queries and create views to extract and transform data from Microsoft SQL Server databases.
• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by and OLAP
(Online Analytical Functions).
• Meet with stakeholders to gather requirements and provide data-driven recommendations.
• Collaborate with cross-functional teams to ensure data accuracy and integrity.
• Develop and maintain documentation for data sources, reports, and dashboards.
• Created DAX Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Creating and managing Power Bi Gateway and workspaces, Migrating dashboards from one environment to another.
• Created power bi reports and deployment them in shared workspaces, along with automating them using both gateway and share point (cloud services).
• Train end-users on how to use reports and dashboards to make informed decisions.
• Ensure compliance with HIPAA regulations and standards for handling protected health information
(PHI)
Pillpack by Amazon (Manchester, NH) Apr 2020 – Jan 2023 BI Analyst
• Wrote queries to gather data from different tables by using JOINs, sub-queries, correlated. sub-queries and derived tables on SQL Server platform.
• Developed and maintained data models to ensure accurate representation of business processes.
• Played a vital role in the successful implementation of a data warehousing solution improving data accessibility and reliability.
• Primarily responsible for requirement elicitation, validation and documentation for project, process improvement, automation efforts and obtaining a full and complete sign off for them.
• Effectively in constant communication stakeholders to effectively proffer and recommend solutions that meet business needs.
• Analysis of current processes, defining future state based of requirements gathered from stakeholders, performed Gap Analysis, and User Stories creation.
• Design, develop and implementation of information systems business solutions using AGILE methodology.
• Documentation and analysis of processes – creating Business Process Maps (AS IS and TO BE), Standard Operating Procedures (SOPs), Process models and Workflows.
• Led all sprint planning, sprint reviews, sprint retrospectives and daily scrums with the development team resulting in DEV, QA, and Prod.
• Wrote SQL queries that were highly tuned using concepts like Explain, Stats, CAST, and volatile tables.
• Planned, analyzed, and designed Universes using SAP Business Objects as per Business needs.
• Used Pivot tables to create reports that did dicing and slicing functions on data. Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Extract, load, model, and reconcile large amounts of data across multiple system platforms and sources.
• Created DAX Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Creating and managing Power Bi Gateway and workspaces, Migrating dashboards from one environment to another.
• Created power bi reports and deployment them in shared workspaces, along with automating them using both gateway and share point (cloud services).
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up to date with on-premises data sources.
• Experience in working with Power BI Admin Portal, and azure active directory in Azure portal.
• Good Knowledge with DAX to create measures, calculated columns, transform various data sets into enterprise data models and application specific solutions.
• Designed expressions to calculate, group, filter, parameterize, and format report contents.
• Designed for Power - BI report designs including backgrounds, buttons, and logos etc.
• Utilized multi-dimensional and tabular model in analysis services to pull and generate reports directly from in- memory from backend relational data sources.
• Creating functions in Power BI report by creating toggles, Navigation panes, drill through filters, dill down reports, data hierarchies and conditional formatting visuals.
• Delivered on-demand reports in multiple rendering formats with standard and data-driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.
• Developed Data Mapping, Performance Tuning, and Identifying Bottlenecks of sources, mappings, targets, and sessions.
New England College (Henniker, NH) May 2019 – Oct 2019 Data Analyst (Graduate Assistance)
• Data Analyst/ETL Developer Responsibilities:
• Responsible for error handling, stored procedure, creating tables, views, triggers etc.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, and Flat Files.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• Configured the Data mapping between Oracle and SQL Server.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Used SQL High for level proficiency in database manipulation.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets.
• Created User Interface Specifications and wire frames.
• Used advanced SQL concepts like OLAP, Group By and aggregate functions.
• Used complex SQL queries in advance to fetch data from other tools.
• Wrote queries to fetch data from different tables by using JOINs, Sub-queries, Correlated sub-queries and derived tables on Teradata platform.
• Work with ETL Process which includes SSAS, SSIS, and POWER BI. Worked with Business Intelligent tools like Power BI on SQL server mainframe.
• Developed stored procedures, views, triggers, executed test cases and defect management for ETL and BI system.
DEL Waste Management Company (1,000+ employees) Mar 2014 - Feb 2018 B.I Developer / Data Analyst
• Develop and maintain software and hardware installation and configuration procedures and design network structure Partner with business stakeholders to design reports, visualizations, and dashboards to support strategic decision making.
• Worked on both live and import mode to bring data to Power BI for creating reports. Used Power BI gateway to schedule daily job to refresh data and establish RLS (Row Level Security).
• Created complex SQL scripts to extract data from Oracle, SQL Server, Data Lake, and Hive to make data available for enterprise reporting.
• Design and write elastic queries to access data across database and migrate an existing Oracle Database to Azure Database using Azure Data Factory.
• Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, Drilldown, and drill through features.
• Created DAX Queries to generate calculated columns and measures in Power BI.
• Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across the same and various data sources.
• Used and created various visualizations in reports like scatter plot, box plot, Sankey chart, bar graphs, Gantt charts, trend lines, waterfall charts, statistical models, heat maps, and geo-maps end-users to utilize the full functionality of the dashboard.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Used Parameters and Quick filters, Dynamic X and Y axes using Parameters, Table Calculations.
• Solid experience in building interactive reports, dashboards, and integrating modelling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop.
• Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.
• Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.
• Supported the design, build, and maintenance of automated reporting, dashboards, and analysis to enable our team to self-service most of their regular BI data needs, allowing you to focus on answering hard, strategic, and ambiguous problems that will move the needle in terms of customer adoption.
• Delivered timely, accurate and professional technical assistance to internal colleagues. Can dive deep into how their needs can be met with existing (and new) metrics and insights to grow adoption.
• Designed and drive experiments to form actionable recommendations to grow adoption. Present to business teams in both ad-hoc forums and routine monthly and weekly business reviews to drive decisions.
• Supported the operationalization and maintenance of a customer ‘subscription funnel’ to help grow adoption by analysing customer activity across things like views and engagement time, to frequency of data exports and % of products exported vs. subscribed to.
• Developed queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting.
• Developed a deep understanding of AWS’s vast data sources and know exactly how, when, and which data to use to solve business problems.
• Defined analytical approaches and metrics strategy to uncover new customer insights.
• Built and provided reports initiated from business reporting requests.
• Developed donut charts and implemented complex features in charts like creating bar charts in the tooltip.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.
• Created DAX Queries to generate computed columns in Power BI.
• Generated computed tables in Power BI by using DAX.
• Involved in creating and optimizing stored procedures and queries.
• I am experienced in designing and developing large amounts of enterprise reports (Power BI) using the data from ETL Loads, SSAS Cubes, and various heterogeneous data sources.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
• Published Power BI Reports in the required originations and Made Power BI Dashboards in Web clients and mobile apps.
TECHNICAL SKILLS
• Database: MSSQL, TeraData, Operating Systems: RHEL, Windows, Unix Programming Languages: SQL, BI Tools- Power BI
• ETL & Data Modelling Tools- SSIS, SSMS, Azure Data Factory, ERWIN, Infomatica
• Skill in eliciting and documenting business requirements. Use of tools for requirements documentation (e.g., Jira, Confluence, Microsoft Visio).
• Knowledge of process modelling techniques (e.g., BPMN, UML). Ability to create process flowcharts and diagrams.
• System Analysis:
Understanding of system analysis concepts and techniques. Ability to assess and document system requirements.
• SDLC Experience: Understanding of Agile and Scrum principles for project management.
• Prototyping:
Skill in creating prototypes to visually represent system functionalities.
• Use Case Development:
Ability to create use cases and user stories to describe system interactions.
• Risk Analysis:
Skill in identifying and assessing project risks.
• Testing and Quality Assurance:
Understanding of testing processes and quality assurance.
• Project Management
STRENGTHS
Data Modeling & Analysis
9+ years of extensive experience in
Data collection, Dimensional modeling, Cleansing, manipulating large datasets and interpreting data trends using disparate data sources and tools.
Visualizations
Strong design skills in creating visually appealing and user-friendly data visualizations including building interactive dashboards and custom applications to provide meaningful and quick insights to the data. Team Collaboration
Exceptional ability to collaborate with cross-functional teams resulting in successful completion of projects within deadlines.
Problem Solving
Strong Problem-solving skills with excellent track record of data policing, identifying, and troubleshooting data anomalies and inconsistencies improving reliability and user experience. EDUCATION
Master of Science, in Computer Information & Systems, New England College (Henniker, NH)
(CGPA 4.0), 12/2019
Bachelor of Science, in Chemistry, University of Lagos. (Nigeria) CERTIFICATION 4/ 2009
CompTIA Security + Cert ID COMP001021644096
Contact this candidate