Data Analyst

SHERROD L. HAYNES

**** ***** ******** ****** **** 2 Chicago, IL 60615 C: 773-***-**** **************@*****.***

PROFESSIONAL SUMMARY

Highly analytical, deadline-driven Reporting Analysts who completes business administration and reporting activities with accuracy and speed. My diverse background in business administration has allowed me to gain knowledge, skills and experience which has transformed me into an innovative reporting analyst. I have the ability to take data from any database, translate, query and manipulate into rational and readable reports and dashboards. I have the autonomy, moxie, hustle and resilience to tackle task with ease and sense of urgency all while completing deliverables to management and having fun doing what I love!

SKILLS

ØTableau

ØPolaris

ØSQL(Intermediate)

ØOracle

ØOBII

ØSAP

ØMS Word (Advanced)

ØMS Excel 2010- 13

(Advanced) Pivot tables, V-Lookups, Nested V-Lookups, If & Sum If statements, Count IF statements, Creating links, Match formulas, Validating cells, creating advanced formulas, recording/running macros, VBA coding

ØMS Power Point

(Advanced) Inserting video/audio, Braking slides into section, Inserting tables, Customizing slide transitions on a timer, Inserting excel spreadsheets, Uploading presentation to public workspaces

ØMS Outlook(Advanced)

ØSharePoint

(Advanced) Creating libraries, creating folders for organization, administrator gatekeeper, creating workflow for task, gatekeeping reports and trackers on team share site, Creating alerts for document's

ØVisio

ØPeopleSoft

WORK HISTORY

Financial Reporting Analyst, 01/2016 to Current

Comcast Business Addison, IL

Report to and support the Regional Construction Manager and Director of Construction

Developed forecasting tools and dashboards to analyze revenue variance, business pipeline and industry trends

Consolidated financial data and materials for key leadership meetings

Acted as a liaison between Polaris consultants and management to help develop canned reports in Tableau

Work as a liaisons between Sr. Management and consultants to develop Polaris database for project management

Worked with consulting team to build schemas for caned reports in Polaris server

Created tables in Polaris server for query creation

Created custom queries for weekly report generating

Linked tables for query creation and report generation

Problem solved to find broken code in Polaris server (ad-hoc)

Reviewed and analyzed project spending throughout project life cycle

Built and maintained databases for forecasting future financial performance

Developed spreadsheet models for diverse projects and analysis

Generate weekly routine financial forecasting reports for all regional projects

Heavy OBIEE data analysis of AP OBI, Projects Inquiry, PO Inquiry OBI, CAR Inquiry, and CAPEX OBI to be migrated with other databases for report analysis and generation

Generated routine Variance analysis reports

Use Oracle Business Intelligence (OBIEE) databases to track project spend for report forecasting and budgeting,

vendor PO allocating and reconciliation and create Capital Acceleration Request

Support Sr. Project Manager to create CAR\'s (Capital Acceleration Request) for project funding

Heavy OBIEE AP report generating for vendor PO invoicing and billing Used V-lookups in Excel to reconcile vendor and contractors discrepancies

Request funds needed to support vendor POVs Allocate funds to POVs for Capital Projects

Moved funds from WIP(Work in Progress) budget to approved POVs

Created a process for submitting PO for vendor work orders •

Created PO trackers, ad-hoc SQL queries for project exposure, spend and pre-forecasting

Maintain and Manage SharePoint Site create, edit, and upload documents for team sharing in SharePoint

Create links and alerts for file management in Share Point

Use Share Point to add new and revised documents to Workflow status

Create new folders in SharePoint for organizing documents by task, projects, group assignments

Generate high level status reports for Division Management

Project Coordinator & Reporting Analysts, 06/2015 to 01/2016 SAC Wireless Chicago, IL

Report directly to Director/Project Manager tracking project milestones and overall project status

Supporting the Program Director/Project Manager, Team leads, and Site Development Specialist(lawyers)

Heavy correspondence & report generating for clients (regional management) on program status updates

2

ØFormatted Contracts/ Created Templates, Researched for business proposals and bids

ØPrepared a heavy amount of reports, business letter, memos and company e-mails, Completed special projects for other members of the executive team

Ø Managed calendar, order office supplies and booked meeting space

EDUCATION

College of DuPage / Benedictine University (2013 -2018)

Major: Business Management

Minor: Information Systems

I am currently enrolled in College of DuPage in a 3+1 bachelors program with Benedictine

University.

Contact this candidate