Business intelligence
Build dashboards that put the right numbers in one place so managers can spot issues and follow trends.
I’m Jerin Abraham. I work with forecasting, reporting, and business data to help teams see what’s happening and decide what to do next.
I work with teams that need to plan staffing, track performance, and understand costs. My job is to make the numbers easier to use, whether that means building a report or explaining what changed.
Build dashboards that put the right numbers in one place so managers can spot issues and follow trends.
Cut down on repeat work by cleaning up data pulls and making recurring reports easier to update.
Look at labor spending, overtime, and demand to explain budget changes and find places to save.
Estimate workload and staffing needs, then test what happens when demand changes.
These four examples show how I’d work through common business questions. They use made-up data, not reports from my employers.
One place to check volume, service levels, and team performance instead of jumping between separate reports.
Download project overview ↓An example of how I’d organize source files, check the numbers, and build a report that’s easier to refresh.
Download project overview ↓A sample cost review that compares planned hours with actual hours and shows where overtime affects spending.
Download project overview ↓A simple staffing model that shows how many people a team may need when workload rises or falls.
Download project overview ↓The project images use sample data. They aren’t actual company dashboards or confidential reports.
Move the slider to see how a change in work volume affects the estimated number of employees needed.
For this example, the team starts with 10,000 tasks a month and each employee handles 400. Staffing is rounded up.
Pick a team and a time period. The charts and totals will update so you can compare workload, staffing performance, and costs. All data here is made up.
Interactive report · Made-up data
Monthly work volume
Percent meeting the sample service goal
Choose a team and quarter to see what changes.
This is a demo with made-up monthly numbers. It isn’t based on private employer data or real business results.
I start with the question the business needs answered, not the chart. Click through the five steps to see how I’d go from raw data to a recommendation.
I’d talk to the people using the report and find out what decision they need to make. We’d agree on which numbers matter.
A short plan with the question, measures, and goal.
Here’s what a cleaner reporting process could look like. It’s a made-up example, not a claim about a specific company.
Most of my experience is in workforce planning, but the same skills apply in other settings. Teams in retail, finance, healthcare, and technology all need better forecasts, cost reporting, and ways to track results.
Look at past demand, estimate busier periods, and plan enough coverage without overspending.
Forecasting · Labor cost modeling · KPI dashboardsI’ve spent more than five years working with data in busy operations teams. I like figuring out why a number changed, checking the details, and explaining the answer in a way that makes sense to everyone in the room.
At Optimum and 1-800-Flowers, I’ve worked on forecasts, staffing plans, reporting, and labor costs. I’m looking to keep growing in business and operations analytics, including roles outside workforce management.
These examples come from my actual work experience, not the sample projects above.
Automated recurring reporting at Optimum and saved about four hours of manual work each week.
Helped cut labor and overtime costs by 15% at 1-800-Flowers while meeting performance goals.
Scheduled and supported training efforts at 1-800-Flowers that raised completion from 20% to 97%.
I’ve worked with staffing, budgets, reports, and day-to-day performance. Here’s where I’ve done that work.
OptimumOptimumI build staffing and workload forecasts for multiple sites, create Power BI reports for leadership, and review differences between forecasts and actual results. I also work with Finance and Operations on staffing plans, budgets, and cost questions.
I built short- and long-term forecasts, planned for busy seasons, and adjusted schedules to better match workload. I also tracked KPIs and reported staffing and labor cost trends to managers and senior leaders.
These are the tools and skills I’ve used to build reports, plan staffing, and answer business questions.
CUNY Brooklyn College · May 2019
Power BI · Tableau · SAS · Advanced Excel · Power Query · Financial modeling
SQL (working knowledge) · MS Access · Data modeling · Reporting automation · Database development
Forecasting · Scenario analysis · Capacity planning · Labor cost analysis · KPI performance management
Verint · Aceyus · PeopleSoft · Alvaria · Genesys · Cisco · Sprinklr · Jira
If you’re hiring for a business analyst, operations analyst, or planning role, I’d be happy to talk. You can call, email, or reach out on LinkedIn.