FEMI KWESI
Summary
Dedicated and detail-oriented professional eager to learn while leveraging my strong analytical skill, technical skill, stakeholder management skill, organizational skill, strategic planning abilities, and collaborative mindset to excel in a project management role. I am Committed to driving project efficiency by leading a collaborative team to contribute to the success and growth of a dynamic organization.
Overview
9
9
years of professional experience
1
1
Certificate
Work History
Business Insight Analyst Revenue Cycle
CONIFER HEALTH SOLUTIONS
REMOTE
09.2022 - 07.2024
- Led the collaboration of stakeholders to elicit requirements and determine project scope
- Successfully led the re-coding of stored procedures and query optimization projects which improved runtime by over 85%
- Successfully led three stakeholders in defining the project scope, work-breakdown structure and schedule in the creation of a data gathering application to write back data to a database which improved the process by 90%
- Led various reporting project teams of junior analysts from implementation to delivery providing mentorship, assigning tasks, monitoring progress and removing road-blocks while ensuring timely delivery of deliverables
- Facilitated Sprint Planning and stand-ups
- Collaborated with teams to successfully implement a star schema to harmonize over 10 complex disparate reporting projects into one leading to improved customer experience
- Used python and sql server integration to extract, transform and load flat files into databases and from database to database ultimately improving the automation process
- Automated the process of loading over 50 million rows of data in chunks from source to destination daily
- Work closely with business users, performing exploratory data analysis and presenting findings.
Data Analyst
FIELD POINTE GROUP
REMOTE
12.2021 - 09.2022
- Successfully managed the vendor selection process
- Identified key performance indicators and metrics to be tracked company wide, created reports and dashboards to monitor project progress and help stakeholders make decisions
- Closely monitored projects to ensure on-time and under budget deliveries
- Successfully manage the relationships with vendors
- Create Power BI reports and Dashboards to manage end to end project plans and monitor the progress of data projects
- Assist the project manager in Identifying potential project risks and proactively mitigate them
- Work with Leadership to develop key performance indicators to measure their impacts on business decisions and drive business goals
- Assist in developing project budgets
- Successfully migrated reports in excel into dashboards that provided leadership with actionable insights
- Led a team of 5 sql developers to cut projected time for reporting into a few minutes by developing automated reports and ETL using power BI
- Led the Implementation of 2 fully functional data schema and 8+ data flow optimization processes for reporting purposes improving run-time by 70%
- Led data engineers to build and maintain self-service BI tools for stakeholders' company wide
- Led the gathering of requirements, identification of stakeholders and project scope, kept a track of issues in the issues log and documented project requirements for analytical report and data projects
- Led requirements gathering, scope identification meetings and data mapping sessions to understand business use cases
- Developed data governance policies.
Business Systems Analyst
MCKEE HOMES
FAYETTEVILLE, NC
09.2019 - 12.2021
- As the business systems analyst, I led the systems administration for the enterprise resource planning software (ECI Marks System), business, data analysis reporting to support business processes across the company
- Led the collaboration of stakeholders in determining project scope, risk and how to mitigate them, what deliverables should look like at the close of the project
- Variance analysis and cost management to ensure projects do not go over budget and report findings to the project manager and stakeholders
- Interact with stakeholders, to understand reporting requirements and transform them into technical specifications
- Successfully led a team in the creation of a project invoice review process identifying double payments to vendors saving the Company an average of $8,000 weekly in double pay
- Working closely with business users, performing exploratory data analysis and presenting findings
- Successfully led the implementation and delivery of a cloud-based interactive lot inventory management software for 60 active communities on budget ($100,000 budget) using an adaptive approach
- Successfully led the integration of a cloud-based interactive lot inventory management software with an enterprise resource planning tool leading to an increase in operational efficiency and customer leads
- Successfully resolved conflict between cross-functional teams in the adoption of new processes and tools by highlighting benefits, training and continuous engagement
- Worked with Leadership to develop key performance indicators to measure their impacts on business decisions, and drive business goals
- Collaborating with stakeholders on how to use the ERP to improve business processes and add functionality
- Led the creation of an application to automate weekly cash requirement, requests and approval which significantly reduced approval time
- Entered project invoices into the ERP
- Successfully led the development of a database to track various metrics giving more visibility to project performance
- Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and dashboards
- Extensively used clustered bar charts, Gantt charts, clustered Column charts, donut charts, hierarchy slicers, waterfall charts, scatter charts, area charts, KPI's on power BI reports
- Led the selection of vendors for budget forecasting tools
- Created and maintained an excel budgeting tool for over 50 communities with active construction in each of them
- Analyzed project progress and adapted scope or project schedule to achieve on time project delivery to stakeholders.
Power BI/SQL/MSBI Developer
MAC HAGEN
FAYETTEVILLE, NC
03.2015 - 09.2019
- As the Data Technical product owner, I served as the main point of contact for data across partner services, which is part of the wider Infotainment team, a sub-department of Technology
- Led the interaction of business users, business analysts to elicit requirements, determine project scope, identified risk and transformed requirements into technical specifications
- Report project risk and escalated issues through the appropriate channel
- Interpreted healthcare data to identify trends and patterns using Excel
- Designed and developed functional dashboards and reports to improve operational efficiency
- Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway
- Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports
- Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
- Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
- Scheduling and running jobs in the background, taking regular backups of the systems and recover data during failures.
Education
Master of Business Administration (Thesis) - International Business -
BABCOCK UNIVERSITY
01.2016
Bachelor of Science - Business Administration -
BABCOCK UNIVERSITY
01.2004
Skills
- BI Reporting Tools
- Power BI
- Tableau
- Microsoft Excel
- Power Query
- Microstrategy
- SharePoint
- SSRS
- Project Management Tools
- JIRA
- Click-up
- Data Integration (ETL) Tools
- SSIS
- Scripting/Languages
- SQL
- Python
- Methodologies
- Agile
- Scrum
- Waterfall
- Variance Analysis
- Project Documentation
- Risk Management
- Cost Control
- Creating Budgets
- Requirements Gathering
- Vendor/Relationship Management
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Certification
Microsoft: Analyzing and visualization of Data using Power BI DAX201x, 2019
References
References available upon request.
Timeline
Business Insight Analyst Revenue Cycle
CONIFER HEALTH SOLUTIONS
09.2022 - 07.2024
Data Analyst
FIELD POINTE GROUP
12.2021 - 09.2022
Business Systems Analyst
MCKEE HOMES
09.2019 - 12.2021
Power BI/SQL/MSBI Developer
MAC HAGEN
03.2015 - 09.2019
Master of Business Administration (Thesis) - International Business -
BABCOCK UNIVERSITY
Bachelor of Science - Business Administration -
BABCOCK UNIVERSITY
Similar Profiles
ELLAINE G. LEGASPIELLAINE G. LEGASPI
AR Director at Conifer Health SolutionsAR Director at Conifer Health Solutions
Erica HernandezErica Hernandez
Patient Access Representative at Conifer Health SolutionsPatient Access Representative at Conifer Health Solutions
BRITTNEY BROWNBRITTNEY BROWN
Patient Care Coordinator | Team Lead at Conifer Health SolutionsPatient Care Coordinator | Team Lead at Conifer Health Solutions
Tiyada G. TaylorTiyada G. Taylor
Patient Account Representative at Conifer Health Solutions LLCPatient Account Representative at Conifer Health Solutions LLC
Mindi-jo YoungMindi-jo Young
Revenue Cycle Business Analyst at WVU MedicineRevenue Cycle Business Analyst at WVU Medicine