Comcast BusinessFinancial Reporting Analyst
Jan. 2016 - Feb. 2018Greater Chicago AreaConsolidating heavy OBIEE data extractions of AP OBI, Project inquiry, PO inquiry, Capital acceleration and Capital expenditure to be migrated into excel for analysis and report rationalization for key leadership meetings Supported the Sr. Project Manager with creating project charters, deployment, project plans, scheduling, and forecast timelines Created and automated tracking templates for project milestones throughout the project lifecycle to monitor projects in real-time allowing specialist to stay of schedule with completing task, resolving scheduling conflicts and effectively managing budget Successfully created a purchase order submittal and allocation process that allowed management to see financial exposure, decrease the turnaround time for allocating po’s to projects by 35%, and forecast for future funds to be requested Developed high level project status reports and tracking for all projects in the region providing management business insights, trends, and patterns Strategically model data to provide performance indicators, improve current operations determine root cause of project conflicts Successfully designed and developed interactive dashboard tool for quick analysis of forecasting, revenue variance, po reconciliation and vendor management Acted as a liaison between software consultants and management to build canned reports in Tableau providing high level operation reports Successfully developed SQL queries in ad-hoc environment for report creation to gain insight on new business initiatives, gain lead-time on sourcing for project cost estimates, regional growth and revenue Created real time queries in SQL for data extraction into excel for custom report generating and automated templates for routine reports Innovatively modeled data via Power Pivot(excel) directly from SQL server efficiently saving time for report generation and manipulation