Power Bi Data Analyst

OLUWADAMILARE ALADE

Preferred name (Gabriel)

Houston, TX 77036 *******.*******@*****.*** 281-***-****

PROFESSIONAL SUMMARY

●Skilled Data Analyst with a track record of driving business growth through ambitious strategies that increase sales, market share, and market penetration.

●3+ years of SQL, BI production, and scripting experience, as well as a 2016 SSMS developer with a strong understanding of Power BI and Tableau

●3+ years ETL (Knime, Altryx)/SQL(Teradata) in developing, researching, creating, and reporting using Microsoft SSMS 2008 – 2016 versions, SSAS, SSIS, SSRS, and Microsoft Visual Studio (Power BI) for designing packages, triggers, and indexes, AWS Solution Architect, ServiceNow (Administration)

●3+ years of Tableau, Power BI, Qlik, and SSRA experience

●5 years of Office 365 (Advance Excel, Power Query, Visio, Word, etc.) experience with Agile (SCRUM) methodology

AREAS OF EXPERTISE

MS-SQL Server 2008 - 2016 Oracle 10g DBMS SQL Server Integration Services SSRS SSAS Data Analysis/Transformation Services MS Office Suite MS Project/MS Visio SharePoint SIX SIGMA SCRUM SQL Visual Studio SQL Management Studio Oracle RDBMS JIRA SAP ERP SAS Data Visualization Presentation Skills Machine Learning Technical Writing Skills Strong Communication Skills Store Procedure Excellent Attention to Detail Ability to Set & Meet Deadlines Excellent Team Player Fast Learner and Self-Starter Program/Project Planning Quality Assurance/UAT Dashboard Tableau Power BI Ad-Hoc Reporting Smartsheet Salesforce Smartsheet Power Pivot Power Automate Confluence Power Query Advance Excel FBDI Power Pivot VBA (Visual Basic Application) Dynamics 365

PROFESSIONAL EXPERIENCE

BUSINESS ANALYST II April 2023 – Present

RCA (Research and Cost Accounting)

RICE UNIVERSITY – Houston TX

Bi-weekly LD (Labor Distribution) report to determine failed transactions, fix errors, and resubmission for processing.

Processing NIH (National Institutes of Health) NLM (National Library of Medicine) trainee invoices for payments as well as tracing unpaid invoices and balancing reports.

Writing complex power queries to automate monthly reports and supporting other team members on advanced excel formulas and functions.

Working closely with the high-level team members on auditing, chart of account, service centers and general ledgers.

Updating awards/project team members, PI waiver eligibility set up, maintaining PPM (Project Portfolio Management) grants, and closing monthly PPM.

Creating new sponsors to set up new awards/projects for university trainees.

Creating annual fringe benefit report based on salaries, medical, insurance and sabbaticals and future prediction rates for the faculty, staffs, and allocations.

Supporting the DevOps team on projects using Jira, in the test environment before going into productions.

Updating iO (ImagineOne) dashboards, training the departments on how to access the dashboard and rendering support as needed.

Using python to clean data and upload the processed data into a spreadsheet build dashboard visualization.

Annual HERD (Higher Education Research and Development), PI credit, and Organization credit reports to determine if credits are properly shared among departments or need updating.

Using python codes to automate functions e.g., sending error messages to necessary individuals to act on.

Responsibilities

Setting up new requisition on a yearly basis for new and returning trainees to generate PO# (Purchase Order) for awards/projects as directed by SPARC.

Updating and maintaining old reports to match current budgets and accounts.

Major support and POC (Point of Contact) to the department and faculty on PI (Principal Investigator) credit and Organization credit reports.

Collaborate closely with cross-functional teams to deliver cutting-edge solutions that enhance contact center operations.

Oracle dashboard request maintenance and updates for the departments.

Automating reports using VBA codes and training team members on how to create automated reports using VBA codes.

Major POC on advance excel formulas and pivot tables. Perform system analysis, troubleshooting, and debugging to identify and resolve issues.

Managing and processing non labor cost transfers, cost transfers, PPM service centers cost transfer for the departments and service centers.

Invoice tracking, validation, and processing for grant research students.

Processing Cost transfers, from POET to POET (Project to Projects), POET to-from COA (Project to or from Chart of Account) and PPM Service centers cost transfers (Project Portfolio Management).

Automates a biweekly report using VBA codes to reduce the time spent on the report processing to less than 2 minutes using a button click.

DATA ANALYST Feb 2022 – March 2023

PACCAR ENGINE COMPANY – Columbus MS

Managing and analyzing SCADA data to monitor the performance of each OP (operation) machine.

Writing and maintaining SQL custom queries to build dashboards in tableau using live datasets.

Assists in the management of data, ensuring data integrity is at the forefront of all processes.

Monitoring production performance of each shift; build dashboard using the data directly from the CMO DB (Computer Monitoring Operations Database) to determine if daily targets are met by each shift.

HSE (Health, safety, and environment) assessment, monitoring and follow up for each production team member.

Tracking the MTBF (Mean Time Between Failure) of each OP machine using Tableau Prep builder and Tableau desktop at each workstation and machine level.

Promotes the optimization of plant processes and equipment to maximize efficiency while meeting operational and regulatory requirements. Supports linkage between plant processes and plant/unit financial and operating goals, and regulatory requirements.

Supporting other production departments by building dashboards to track their performance using KPI’s.

Using tableau prep builder for data cleaning and tableau desktop to build dashboards, accessing data directly from databases.

Contribute to strategic business problem discussions with internal project teams and develop quantitative methods to best answer and quantify business impact.

Creates revisions to existing programs, systems, and procedures.

Serve as the Principal ServiceNow application developer responsible for implementing GRC/IRM solution design using best industry practices.

Design and develop solutions within the ServiceNow environment to include new or modifications to applications, forms, flow, workflow, UI policies, UI actions, Business Rules, ACLs, UI Builder, and any other configurations required to support client processes.

Responsibilities:

Build interactive reports and dashboards.

Working with other analyst departments to source datasets as well as brush ups/updates and train as needed.

Create and update queries, reports and dashboards as needed, especially when there is a newly generated dataset from newly installed OP machines.

Monitoring production performance by creating power automate that launches a web browser, access URL, take screenshot and save, attach saved screenshot to an email and send to production leads and managers.

Integrating data into database using SAP standard interface or custom development. Moving data from one location to another specifying the location.

Develop ServiceNow solutions and push developments from DEV to TEST to PROD using Agile methodologies.

DATA ANALYST/BUSINESS ANALYST May 2020 – Feb. 2022

HD SUPPLY – Remote Houston TX

Validating Go Forward products (SKUs) to reach final decision. (If the product should be discontinued)

Managing sales representatives, sales representative’s managers and customer’s order records based on given Source Orgs and SKUs.

Writing and managing complex SQL queries on snowflakes as well as updating table(s) records.

Exporting data from different snowflake tables for further ETL process, manipulations, and pivoting.

Solving complex SQL problems for team members (data types, functional usages, separators etc.)

Supporting other teams by providing complex SQL queries to return results based on business requirement.

Using tableau and power BI to build dashboards, accessing data directly from snowflake.

Collaborated with various ECO teams for smooth transition of Remedy (Pac2000) to ServiceNow

Supported Thought-Logic through documenting JD Edwards integration to Salesforce (SFDC) process and data testing.

Managing store procedure Boss2 database, writing and updating the SQL queries.

Identifies and recommends internal and external data sources, compiles/mines data from multiple, cross business sources; recommends and participates in the development of complex analysis designs using statistical and/or financial analysis, predictive modeling, process documentation, comparative analysis, customer/demographic analysis.

Collaborating with other analytics teams; integrating data, analyzing data and reporting.

Responsibilities:

Requirement gathering documentation (Epics, User Story, Use Cases, Mock-Up’s, Wireframes etc.)

Troubleshoot reports and queries as needed.

Build interactive reports and dashboards.

Work with the departmental managers to understand the current processes and systems.

Accessing snowflake data from tableau for further visualization analyses; building dashboards, using calculated fields as needed etc.

Working with large data, importing, and exporting to and from snowflake.

Working with the departmental team leads to understanding the current processes and systems.

Gather data from different sources, data entry and data upkeep.

Performing ETL processing for further analyses (Excel).

Pivoting and building dashboard.

DATA ANALYST/ASSET MANAGEMENT July 2019 – May 2020

PCG CONSULTING GROUP – Remote, Houston TX

Major Accomplishments:

Collaborated with various ECO teams for smooth transition of Remedy (Pac2000) to ServiceNow

Supported PCG through defining, refining, documenting, and managing the build process for software development, processes, and Value-Added services.

Complete all administrative processing requirements associated with maintenance duties, such as requisitioning of parts and materials, processing of maintenance orders, recording of labor time, etc.

Responsible for consulting with partners to identify and define business requirements and translate business needs into complex analysis designs and recommendations.

Identifies and recommends internal and external data sources, compiles/mines data from multiple, cross business sources; recommends and participates in the development of complex analysis designs using statistical and/or financial analysis, predictive modeling, process documentation, comparative analysis, customer/demographic analysis.

Responsibilities:

Serve as a leader by providing work direction, monitor work progress and adherence to asset management policies and procedures.

Working closely with the HR department by extracting agents daily shift to capture active hours worked using excel formulars to calculate each agent’s daily pay.

Demonstrated expertise in interpreting large sets of data and able to consolidate data across multiple sources into usable reports for print management and compliance.

Managing projects using Jira

Documenting requirements elicitation and architecture information for Core banking application integration and customization (Finacle Banking solution)

Pull data from SQL/ Tableau/Power BI, clean up the data, check for duplicate and compare the data to ELCMS.

Manage, create test cases, and execute customer testing on integrations, enhancements and/or fixes.

Managed multiple projects with outside resources, 3rd party consultants and vendors.

Work with the departmental managers to understand the current processes and systems.

Conduct time-in-motion studies and facilitate focus group sessions to identify areas within the process or system that require improvement.

Troubleshoot reports and queries as needed.

Using smart-sheet logic to manipulate reports base on the business requirement.

Major concentration on ETL process, extraction, transformation and loading, cleaning data and formatting process highly important in my day-to-day activities.

Using python for ETL process and plotting graphs as well as using several libraries.

DATA ANALYST/BUSINESS ANALYST July 2018 – July 2019

RML AUTOS– Irving, TX

Operate analytical and statistical tools such as SSAS, SSIS, and Tableau/Power BI, gather, extract, manipulate, analyze, and model data.

Discover new data sources and techniques for better data collection, interpretation, and reporting.

Generate Complex reports to document and evaluate system operations involving everyday data sets.

Experience with MS-SQL Server T-SQL production and performance tuning for reporting required queries.

Knowledge of data warehouse techniques, methods, logging, and dimensional modeling

Use Tableau to design and build business intelligence and data analysis reports to provide business insights.

Day-to-day problem-solving, reporting, communication, and interpersonal skills, as well as the ability to handle time and tasks while working in a variety of (technical/business) settings and provide end-user training.

Built deep cross-organizational partnerships, partnering with teams to further exploit data to obtain market insights that affect business decisions.

Worked individually with the customer and was proactive in the implementation of deliverables.

Using PowerPoint, provide HR Team with ongoing, deadline-driven assistance for employees and benefits-related parts on VIC.

Configure and update reports on the status of agreed-upon success metrics for the Planner, Team Leader, and Department Head using PowerPoint regularly.

Taking existing data from a separate document and inputting it into Excel

Created managements report in Excel that became the company standard for recording financial information.

Work with users and report developers to develop functional specifications and data mapping for reports developments and system developments.

Working with smart-sheet app logics to manipulate data, using conditional statement to format cell and as well to share file with team, add team member to roles as required.

Major concentration on ETL process, extraction, transformation and loading, cleaning data and formatting process highly important in my day-to-day activities.

Using python for ETL process and plotting graphs as well as using several libraries.

EDUCATION

Schools Years

OLABISI ONABNAJO UNIVERSITY – (BSc.) Mass Communication 2010

LAGOS CITY COMPUTER SCHOOL- Data Analytics 2004

RICE UNIVERSITY- Data Analytics (associate degree) 2020

PROGRAMMING HUB – SQL DBSM 2020

CERTIFICATIONS

Microsoft Certified Technology Specialist – SQL Server 2016

Agile (Scrum)

ITIL Foundation Framework

Help Desk Certification

Scrum Product Owner

Tableau

Power BI

REFRENCES

TOBI ALAPO River Spring Health

646-***-**** Senior Data Analyst

JENNIFER LYNN PCG Consulting Group

918-***-**** Lead Data Analyst

DAVID AYANKOYA Energy Transfer

346-***-**** Lead BI Developer

JUSTIN NOH Thought-Logic

****@*******-*****.*** Team Lead

LUKE DAFFRON PACCAR Engine Company

662-***-**** Supervisor

****.*******@******.***

Teia Wright RICE UNIVERSITY

713-***-**** Ass. Cont. for RCA

*******@****.***

Contact this candidate