Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Sr. Technology & Governance Operations Analyst
Health Care Service CorporationSr. Technology & Governance Operations Analyst
Jul. 2022Chicago, Illinois, United States
Lead Business Analyst & Sr. Technical Product Manager
Oak Street HealthLead Business Analyst & Sr. Technical Product Manager
Feb. 2020 - Jul. 2022Chicago, IL
Business Analyst
Blue Cross and Blue Shield of Illinois, Montana, New Mexico, Oklahoma & TexasBusiness Analyst
May. 2019 - Feb. 2020Chicago,ILWorking as a business analyst where my primary responsibilities include: *Mapping data attributes from source systems to report output *Defining metric calculations *Eliciting requirements *Documenting requirements *Creating UAT Plans for multiple source systems *Conducting UAT *Creating test Scenarios * Use Teradata SQL Assistant to test code and logical calculations from reports
Data Governance: InTake PM & Business Analyst
Northern Trust CorporationData Governance: InTake PM & Business Analyst
Mar. 2018 - Apr. 2019Chicago,IL
Financial Reporting Analyst
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
Jr. Project Manager & Reporting Analyst
SAC Wireless, A Nokia CompanyJr. Project Manager & Reporting Analyst
Apr. 2015 - Jan. 2016Chicago,ILIn this role I supported the Director/Project Management by taking ownership of coordinating project implementations and reporting analytics thru: Collaborated with sales team to track leads coming up the pipeline for new business Collaborated with PM and team leads to create project charters, timelines and milestones Creatively created project milestone trackers to keep management , leads and specialist informed of target dates to complete milestones Effectively designed reports detailing schedule conflicts, unknown task dependencies, and job cancellations Created reports in excel using V-lookups to find new sites deployed to PM and to reconcile backhaul discrepancies Worked with accounting to request and ensure delivery of Purchase Orders and Check request are received with a sense of urgency Consistently kept open mediums of communication with vendors and suppliers to ensure deliverables are received per terms and on schedule Ensured new vendors and existing, insurance was in compliance for work allocation and billing Strategically created series of high level project status insights and tracking for Sr. Management and clients Prioritized report circulation for Management, Team, and Clients Relied on ad-hoc environment to gather and compile difficult data for report creation Created custom reports for Forecasting, Budget vs. Actual variance, and resource allocation tracking
Global Engineering Project Coordinator/Analyst
UOPGlobal Engineering Project Coordinator/Analyst
Jan. 2014 - May. 2015Des Plaines,ILCoordinated lead time initiatives for new work coming up the pipeline Partnered with Sr. Pm to create project charter Collaborated with project pm’s to create Gantt charts in order to determine scheduling, resources needed and task dependencies Designed infrastructure reports to ensure sustainability of project resources and budgets in SAP Successfully conducted qualitative data analysis reports for creating vendor risk management analysis and reporting for global project management use Coordinated statistical data analysis, design and information flow for pm’s in global offices reporting to Sr. PM Worded with procurement to create effective and efficient vendor/supplier management tracking of terms, materials, po’s, returns and billing Coordinated requirements meetings and data mapping sessions to understand business needs
Executive Administration
Kellogg CompanyExecutive Administration
Jun. 2013 - Jan. 2014Oakbrook, ILIn this role I supported the Sr. VP of IT Strategies, VP of Work-space Development, Dir. Of Governance & Lead PM thru collaborative efforts of: Managing all of their daily schedules and itineraries Heavy meeting coordination of booking travel, meeting space, catering lunch, town halls and team building events Effectively managed documents and reports for teams via SharePoint for transparent information sharing Corresponded with division managers on behalf of VP’s for team coordination of weekly and monthly report collection and consolidation Created PowerPoint presentations for meetings Created expense reports in Excel by division Acted as a main point of contact for external consultants and contractors setting them up with security passes, equipment and work tools, and work space
Administration (Contract)
Leiberman Management ServicesAdministration (Contract)
Sep. 2012 - Nov. 2012Elk Grove Village, ILIn this role I supported the CFO/COO by providing administrative assistance thru: Email management and correspondences of behalf of CFO as directed Managed heavy meeting logistics and lunch arrangements Extensive meeting minutes used to create follow up reports for action items Lent assistance to construction department processing vendor applications Corresponded with vendors to settle and give aid in the application process to become a certified vendor with company Processed vendor applications Process vendor work orders for payment and managed accounts via QuickBooks to cut checks for AP
Administrative Assistant
Bolton DevelopmentAdministrative Assistant
Jun. 2007 - Jan. 2012Chicago,ILIn this role I supported the Construction Developer as his EX and office manager by: Owned the responsibility of being the main point of contact of between developer and clients Managing and maintaining all company and client files Managed all vendor accounts thru AP and all client accounts thru AR by way of QuickBooks Processed payroll for staff and managed office expenses Managed calendar of Developer and Architect Formatted and edited contracts Conducted research for proposals and bids Wrote business letters, memos and company e-mails on behalf of developer
Receptionist
World Image DesignReceptionist
Feb. 2003 - Jun. 2007Assisted in team projects • Answered phones and directed calls • Prepared, maintained and updated files • Created file systems • Created business letter and reports • Handled meeting minutes, itinerary and meeting agendas • Prepared and created power point presentations

Requests

Touchpoint image
0
Looking for a Job
Administration Roles
Touchpoint image
0
Looking for a Job
Project Support & Technical Services Expertise
Touchpoint image
0
Personal Pitch
Virtual Assistant for Executive and Technical Support
Intch is a Professional Networking App for the Future of Work
300k+ people
130+ countries
AI matching
See more people like Sherrod on Intch
Customer Service
1791323 people
22
Data Entry
16
Senior Pricing Analyst @ Saia Inc.
20
Operations Manager @ Global Limousine of WNY
Customer ServiceCustomer Success Manager
230178 people
17
Assistant manager
15
Operations and project manager
16
Accounting Manager