Power Bi Data Analyst

Olukayode Akinrimisi

PROFESSIONAL SUMMARY:

•A Power BI/Data Analyst with extensive experience in developing, building and maintaining KPI dashboards using Power BI with best practices, methods and requirements. Expertise in extracting, cleaning, and transforming data from various sources and skilled in data visualization applications with Power BI and BI stack (SSRS, SSIS,) as main tools across different domains.

•Optimizing and Performance Tuning SQL Scripts to make reports run smoothly and efficiently. I have deep experience in deploying package loggings, checkpoints, breakpoints, event handlers and data viewers and troubleshooting errors associated with SSIS package configuration.

•Created SSIS packages to Extract, Transform, and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, Slowly Changing Dimension, Merge Join, and Union.

•Experience in configuring, deploying, and publishing developed reports from Power BI to service and collaboratively working with development and project teams utilizing SDLC Methodology agile/scrum.

•Committed to new and ongoing professional development and research with the ability to learn new emerging technologies and quickly adapt, including business detail summary reports

TECHNICAL SKILLS:

Business Intelligence:

Power BI, Power Query, PowerApps & Automate, BI Desktop, Power Map, Power View, Tableau

Data Modeling:

DAX

Database:

SQL Server, SQL, T-SQL, ETL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS)

Cloud:

AWS

Tools:

Trello, SharePoint, Basecamp, Jira

Microsoft Office Tools:

Word, Excel, Power Point

Soft Skills:

Improvement recommendations, team collaboration and problem solving

CERTIFICATION:

•Microsoft Power BI Data Analyst

•AWS Solution Architect Associate

EDUCATION:

Associates Degree, Business Studies, The Polytechnic Ibadan, Nigeria

Bachelor’s Degree, Computer Information System (Major in Data Science), University of Houston Victoria

WORK HISTORY:

Colaberry Inc 1/2022 - Currently

Power BI Data Analyst

Created applicable dashboards, Tabular reports, Matrix reports, Charts, and Graphs as per customer requirements using Power BI and identified the Key Performance Indicator (KPI) measures in accordance with requirements.

Cleaned and validated imported client data from SQL Server DB, CSV Files, XML files, and EXCEL files inside Power BI Desktop

Prepared dashboards using calculated fields, parameters, calculations, groups in Power BI and developed business logic using DAX to provide custom functionality in Power BI Applications

Utilized Power BI Desktop for frontend development to create visually appealing and interactive dashboards for fund performance. Also, leveraged Power BI Service and Power Automate for backend processes, including data extraction from SQL databases, automated data refreshes, and email notifications.

Developed and maintained Power BI datasets with robust semantic models to ensure consistent data definitions and hierarchies. Enabled accurate reporting by implementing standardized calculations and fostering reliable analytics.

Built and implemented scalable solutions that aligned to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions

Colaberry Inc 11/2020 – 12/2021

System Analyst

Troubleshooting and optimized complex SQL queries and stored procedures to enhance performance. Also, developed and maintained advanced SQL stored procedures and functions to support business processes.

Optimized and fine-tuned SQL scripts to enhance performance and ensure efficient report execution. Leveraged expertise in creating and managing database objects using DDL, DML, and DQL to support complex data operations. Additionally, implemented DCL and TCL commands to maintain database security, consistency, and transaction control, ensuring robust and reliable database management.

Assisted the team in implementing critical BI systems to provide actionable insights into company data and enhance decision-making. Contributed to improving existing BI systems and developing new measures by utilizing DAX functions for dynamic and accurate data calculations, ensuring comprehensive and effective business intelligence solutions.

Colaberry Inc

Business Intelligent Developer 9/2019 – 10/2020

Designed and implemented SSIS packages for ETL processes, utilizing transformations such as Lookup, Derived Columns, and Conditional Split to cleanse and enrich data. Applied Aggregate, Pivot, and Slowly Changing Dimension transformations for summarization, reshaping, and historical tracking. Combined and unified datasets using Merge Join and Union All, ensuring efficient data integration for analytics and reporting.

Developed ETL solutions using SSIS to extract, transform, and load data, ensuring accurate and efficient delivery for analytics, dashboards, and reporting. Enabled data integration to support visualizations and business insights.

Utilized SSIS components such as For-Each Loop Container, Sequence Container, Script Task, and Execute SQL Task to meet diverse business requirements. Leveraged Variables, Expressions, Send Mail Task, FTP Task, and Package Execution Task for automation and workflow efficiency.

Developed and maintained advanced SSIS packages for ETL processes, migrating data from sources like Excel, Flat Files, CSV, XML, and OLE DB to ensure seamless data integration to support reporting and analytics requirements and automated SSIS Packages using SQL Server Agent Jobs and Configured various event- driven e-mail notification processes in SSIS packages.

Entagral Engineering & Design Services USA 6/2015 – 8/2019

Desktop Support Technician

Resolving IT support request from employees and changing configurations, settings and

Permissions to fix computer systems

Gathering and analyzing data to diagnose problems with the systems

Visit client company locations for varied onsite work, hardware installations, system updates, and infrastructure projects

Coordinate strongly with team and project manager on tasks

Perform tech support via ticketing system for clients

Obtained and evaluated information about new systems, peripherals and software technology.

Worked with various systems, software and peripherals and various types of games.

Managed end-user accounts and permissions, overseeing correct provisioning of access rights in accordance with security best practices.

Diagnosed and troubleshot hardware, software and network issues.

ValvTechnologies, Inc. Houston, TX 2/2011 – 5/2015

Manufacturing Technician

•Assemble and test different valves and actuators

•Performing R & D before assembly to ensure quality and good work performance.

•Inspect and test materials, products, and work in progress for conformance to specifications, and adjust process or assembly equipment to meet applicable standards.

•Use of PMIV, MOB, gauges for OD & ID

•Check valve, control valve, cycle isolation and V series metal seated valves.

•Record test results and inspection data, mark items for acceptance or rejection, and compare findings with specifications to ensure conformance to standards.

•Hydraulic and Pneumatic power system

•Document nonconformities on rejected products, materials, and equipment not meeting specifications.

•Cycling the actuator on electrical and mechanical aspect.

•Read and interpret documented processes, such as work orders, inspection manuals, and blueprints, and schematics to determine inspection and test procedures and develop acceptance criteria.

•Analyze and interpret customer acceptance criteria

•Apply best practices in all areas of HSE, Quality procedures, standard operating procedures and Job Safety Analysis.

•Utilization of lean manufacturing techniques in the production processes and knowledge of an ISO and GMP of manufacturing environment.

•Operated forklifts and cranes to lift and maneuver products, equipment and materials

•Uses hand tools and power tools such as drill, micrometer, caliper for calibration, Torque & wrench

•Assemble and test different valves and actuators

•Performing R & D before assembly to ensure quality and good work performance.

•Inspect and test materials, products, and work in progress for conformance to specifications, and adjust process or assembly equipment to meet applicable standards.

•Use of PMIV, MOB, gauges for OD & ID

•Check valve, control valve, cycle isolation and V series metal seated valves.

•Record test results and inspection data, mark items for acceptance or rejection, and compare findings with specifications to ensure conformance to standards.

•Hydraulic and Pneumatic power system

•Document nonconformities on rejected products, materials, and equipment not meeting specifications.

•Cycling the actuator on electrical and mechanical aspect.

•Read and interpret documented processes, such as work orders, inspection manuals, and blueprints, and schematics to determine inspection and test procedures and develop acceptance criteria.

•Analyze and interpret customer acceptance criteria

•Apply best practices in all areas of HSE, Quality procedures, standard operating procedures and Job Safety Analysis.

•Utilization of lean manufacturing techniques in the production processes and knowledge of an ISO and GMP of manufacturing environment.

•Operated forklifts and cranes to lift and maneuver products, equipment and materials

•Uses hand tools and power tools such as drill, micrometer, caliper for calibration, Torque & wrench

Skills:

Quality Control · Assembly Processes · Blueprint Reading · Electro-mechanical Troubleshooting · Mechanical Assembly · Mechanical Inspection · Quality Assurance · Manufacturing

Contact this candidate