phData

Design and implement enterprise-level data models and reports, optimizing data workflows to support scalable analytics solutions.

Assist in establishing robust Power BI governance frameworks, ensuring data security, compliance, and consistency across the enterprise.

Lead Power BI training sessions, empowering users with the skills to build reports and use dashboards for decision-making.

Developed comprehensive documentation on Power BI, providing detailed user guides and best practices to enhance self-service analytics capabilities.

Sr. Analytics Consultant | Partner Tech Lead

Conatus Forever

𝗗𝘂𝗯𝘀𝗮𝗱𝗼 𝗔𝘂𝘁𝗼𝗺𝗮𝘁𝗶𝗼𝗻 𝗮𝗻𝗱 𝗥𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴: Lead the development and execution of a small business initiative focused on the capture and management of client information.  Engineered automated processes for real-time updates on client service statuses.

Business Intelligence and Automation Engineer

R+L Global Logistics

●	Designed and implemented an automated financial statement reporting system utilizing Power BI. 

●	Developed C# scripting automation in Tabular Editor 3 to increase DAX authoring speeds by 10-fold.

●	Optimized Power BI reports using Tabular Editor 3’s best practice analyzer which helped reduce model sizes by 50% and ensure dimensional modeling best practices.

●	Wrote a PowerShell script that automated the creation of 5 usage metric reports in less than 30 seconds.

●	Support business systems by analyzing workflow processes and implementing continuous quality improvements.

●	Developed enterprise-level operational reports from end to end.

Business Intelligence Analyst

Packt

Book: 𝗖𝗿𝗮𝗰𝗸𝗶𝗻𝗴 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄

𝗘𝗧𝗟 (Extract, Transform, Load): Critically reviewed chapters on ETL processes, ensuring accurate and up-to-date methodologies were presented for efficient data handling.

𝗗𝗮𝘁𝗮 𝗚𝗼𝘃𝗲𝗿𝗻𝗮𝗻𝗰𝗲: Assessed content on data governance, emphasizing the importance of quality, privacy, and regulatory compliance in data management.

𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗦𝗲𝗰𝘂𝗿𝗶𝘁𝘆: Provided insights on securing databases, ensuring contemporary security practices and threats are accurately represented.

𝗗𝗮𝘁𝗮 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: Reviewed the comprehensive approach to managing data effectively, including storage, archiving, and retrieval.

𝗥𝗲𝗹𝗮𝘁𝗶𝗼𝗻𝗮𝗹 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲𝘀: Evaluated explanations on the design, implementation, and optimization of relational databases.

Book: 𝗕𝗲𝗰𝗼𝗺𝗶𝗻𝗴 𝗮 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁

𝗗𝗮𝘁𝗮 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻: Evaluated and provided critical feedback on the presentation of data visualization techniques, ensuring clarity and accuracy for an entry-level audience.

𝗦𝘁𝗮𝘁𝗶𝘀𝘁𝗶𝗰𝘀: Reviewed statistical content for accuracy and relevance, ensuring complex concepts were communicated in an accessible manner for aspiring data analysts.

𝗣𝘆𝘁𝗵𝗼𝗻 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝗺𝗶𝗻𝗴: Assessed Python chapters for technical correctness and practical relevance, ensuring examples and code snippets align with current industry practices.

𝗦𝗤𝗟 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲 𝗠𝗮𝗻𝗮𝗴𝗲𝗺𝗲𝗻𝘁: Reviewed SQL sections, verifying the up-to-dateness and effectiveness of database management and querying techniques presented in the book.

Technical Reviewer

Data Science for All by Correlation One

● Lead data curation initiatives for data sourcing, data profiling and data wrangling in python. 

● Develop and manage detailed project schedules and work plans.

● Performed linear regression modeling to predict admission and discharge rates on the Substance Abuse and Mental Health Archive client-level data.

● Conducted hypothesis testing on the Pennsylvania Department of Health statistics data to identify significant differences in mean substance abuse-related death rates between men and women.

● Lead the creation of a multi-page interactive front-end dashboard to explain substance abuse-related death rates in the northeast region of the USA.

Team Lead | Data Science Fellow

FGC Enterprise

●Create executive-level dashboards using Excel to help guide the business in increasing sales by 10% from Jun-22 to Aug-22.

●	Conducted an ANOVA test using Excel’s Data Analyst toolpak to identify significant differences in client subscriptions from different social media post types.

●Automate google sheets tables through Google’s API to store ad hoc customer data.

●Developed quarterly sales projections reports using macros in excel which reduced reporting time by 10 hours a week.

●Conduct business-specific research to identify competitive advantages.

Business Intelligence Intern

Oriana House, Inc.

●	Developed an automatic billet management application using dynamic formulas in excel to assist the Lead Operations Supervisor in employee management.

●	Performed ETL and data pre-processing in STATA which helped reduce data cleaning time by 50%.

●	Created dynamic dashboards using Excel’s power features when creating agency-wide performance reports.

●	Increased residential supervisor promotions by 100% during my first quarter at the McDonnell Correction Facility.

●	Assisted a caseworker in improving their corrections skill usage by 80% within 4 months.

Quality Improvement Specialist

●	I Maintained agency standards by achieving an average correction utilized skills of 80%.

●	I Passed 100% of quality assurance audits to assist Oriana House, Inc (OHI) with meeting the Bureau of Community Sanctions (BCS) standards.

●	On average, I managed over 35 client programming plans at once throughout the year.

●	On average, I completed 20-25 court reports per month.

●	Over 50% of my caseload received correctional reward points for behavior development.

Case Management Specialist

Residential Supervisor

DialAmerica

Telesales Representative

Total Quality Logistics

Logistics Account Executive

Vector Marketing

Direct Sales Representative

The Business Engineer | Certified Power BI Data Analyst | DS4A Alumni

Inspired by the dedication of my mother, the guidance of my high school football coach, and the support of my sisters, I have been on a relentless journey of continuous development—one without an endpoint in sight.

I’m fueled by my drive to succeed and opportunity to produce for my family. 

Let's connect and ride the wave of life together, inspiring and supporting each other as we strive for greatness.

Taplio

Hakeem Lawrence's Linkedin Analytics

Hakeem Lawrence, MSBA

Want to drive more opportunities from LinkedIn?