Dorcas Njoki Gatari
Hazelwood,MO
Summary
Results-driven project manager and analyst with expertise in business analysis, project management, advanced data analysis, financial modeling, and market research. Proven track record of developing and implementing strategic initiatives to drive growth and profitability. Skilled at leading cross-functional teams for delivering innovative solutions in fast-paced environments.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Associate Financial Project Manager
Charter Communications
Maryland Heights, MO
09.2023 - Current
- Designed and implemented accurate forecasting plans through Tableau to ensure that all project spending was in line with the business spend limit of 2%, whilst meeting prescribed operational targets.
- Managed financial details and project spending, presenting findings to the financial department, achieving a 98% adherence to budgetary constraints across projects.
- Managed end-to-end SOWs to ensure adherence to accuracy and compliance requirements during the entire project lifecycle.
- Revamped onboarding procedures for employees and contractors using IDM and Fieldglass, resulting in improved hiring processes.
- Worked in the Ariba SAP system to ensure invoices were accurately accrued and processed on time.
- Presented finalized budget trackers to VPs, highlighting project favorability and unfavorability, leading to annual adjustments of 5% in project costs.
- Streamlined service delivery and incident management processes by successfully implementing Cherwell for IT Service Management.
- Utilized Jira to meticulously track projects and time, configure workflows, and generate reports for optimal resource utilization, leading to a 20% enhancement in project timeline compliance
- Developed insightful Tableau reports by integrating onboarding requests, organization charts and financial trackers, instrumental in achieving $500,000 savings per year.
- Escalated and resolved critical project issues through effective communication with executive leadership.
- Maintained stakeholder relationships for project alignment and high satisfaction levels.
- Boosted team productivity by utilizing Smartsheet and SharePoint for efficient management of projects. Reduced the overhead costs on projects by 25%.
- Standardized processes, enhanced compliance, and trained new hires through the creation and updating of SOPs.
- Presented findings from data analysis in a clear, concise manner that was easily understood by stakeholders at all levels of the organization.
Billing Ops Tech Analyst I
Charter Communications
Maryland Heights, MO
09.2021 - 09.2023
- Extracted, manipulated and analyzed data from multiple databases within the billing department using SQL, leading to comprehensive reports that supported data-driven decision-making.
- Optimized SQL scripts and workflows to enhance query efficiency and improve data accuracy
- Designed and developed Tableau dashboards, offering real-time insights for tracking key performance metrics.
- Effectively handled billing-related issues through the use of JIRA, successfully resolving macro file tickets and significantly reducing ticket resolution time by 40%
- Implemented billing software standards and processes to enhance efficiency.
- Gathered, analyzed, and validated complex systems requirements for seamless integration and functionality of billing systems and reporting needs with a 98% accuracy
- Led and oversaw the revamp of the internal task management system (TMS), used by a team of 125 employees. Implemented over 20 new job features resulting in a significant reduction of save/load time by 20% and improved overall operational efficiency by 15%.
- Managed and executed successful migration scripts from ICOMS to CSG, facilitating seamless transitions and minimizing billing disruptions.
- Facilitated effective communication channels among different entities, enhancing the understanding of billing requisites and organizational goals.
- Provided reports and updates on billing operations and project progress to senior management for informed decision-making
Business Systems Analyst I
Charter Communications
Maryland Heights, MO
02.2020 - 06.2021
- Managed nationwide purchase order requests and vendor communications. Monitored company shipments via multiple carriers to Charter locations across the nation.
- Supported the Purchasing Director, Manager, and Buyers by creating documents and setting up the SharePoint database for easy access to departmental documents
- Maintained accurate records of open purchase orders and delivered products with prompt adjustments
- Utilized Tableau dashboard reports to relay bi-monthly purchase analysis findings to upper management
- Collaborated with project managers to ensure timely acquisition of equipment, labor, and software for new Spectrum mobile stores opening nationwide.
- Enhanced project execution by creating clear and efficient executive summaries for contractors' work orders
- Maintained a record of submitted and tracked Cherwell tickets for IT and service management purposes.
- Enhanced data accuracy and process efficiency by utilizing Oracle for financial and procurement operations.
- Oversaw supplier relationships, attending meetings to negotiate contracts and monitor compliance with agreed terms.
Investor Services Representative Intern
TD Ameritrade
Maryville, MO
09.2019 - 01.2020
- Successfully boosted revenue through implementation of cross-selling methods
- Documented customer interactions and relationships through the use of CRM systems.
- Managed stock levels to meet target capital objectives based on business requirements.
- Conducted informative sales pitches to prospective investors, fostering mutual partnerships
- Researched and analyzed investment portfolios to ensure accuracy of data.
- Prepared financial statements, documents, reports, and presentations in accordance with company standards.
- Reviewed customer requests for account information updates or modifications and ensured accuracy of data entered into system.
Direct Support Professional
Community Choice
Olive, MO
10.2016 - 12.2019
- Monitored progress and documented any patient health status changes, keeping healthcare team updated
Education
Master of Business Administration - emphasis in Project Management
Lindenwood University
05.2023
Bachelor of Business Administration - emphasis in Finance
University of Missouri- St Louis
12.2019
Skills
- Proficient in MS Office (Excel - VLOOKUP Pivot, MS Projects, and Vision)
- Project Management
- SAP software
- Data Analysis
- Project Accounting
- Cash Management
- SQL developer
- Agile Development
- Oracle Financials (AP, AR, GL, CM)
- Oracle UIM
- Tableau
- Power BI
- JavaScript
- JIRA
- Financial Analysis
- Task Management System (TMS)
- Data Visualization
- Billing Systems Proficiency (ICOMS and CSG Billing Systems)
- Financial Project Management
- SOW Lifecycle Management
- Budget Tracking
- Portfolio and Project management
- Spreadsheet/SharePoint balancing
- Troubleshooting
- Workforce management
- Stakeholder Communication (Oral & Written)
- Relationship Building
- Analytics and data interpretation
- Multitasking
- Prioritization
- Analytical Problem-Solving
- Work Planning
- Scheduling
- Vendor Management
- Team Leadership
- Collaboration
- ERP Systems
- Process Improvement
- SOP Creation
- Data Interpretation
- Insights
- Organizational Skills
- Project tracking
- Cost Control
- Compliance Monitoring
- Forecasting
Certification
- Data Science with SQL and Tableau Certificate, ECornell, 2024
- Project Management Institute (PMI) Certification, In Progress
Timeline
Associate Financial Project Manager
Charter Communications
09.2023 - Current
Billing Ops Tech Analyst I
Charter Communications
09.2021 - 09.2023
Business Systems Analyst I
Charter Communications
02.2020 - 06.2021
Investor Services Representative Intern
TD Ameritrade
09.2019 - 01.2020
Direct Support Professional
Community Choice
10.2016 - 12.2019
Master of Business Administration - emphasis in Project Management
Lindenwood University
Bachelor of Business Administration - emphasis in Finance
University of Missouri- St Louis
- Data Science with SQL and Tableau Certificate, ECornell, 2024
- Project Management Institute (PMI) Certification, In Progress
Similar Profiles
Maria GonzalezMaria Gonzalez
Customer Service Rep 2 at Charter CommunicationsCustomer Service Rep 2 at Charter Communications
John RinkavageJohn Rinkavage
Field Technician at Charter CommunicationsField Technician at Charter Communications
Christina BoatengChristina Boateng
Technical Support Representative at Charter CommunicationsTechnical Support Representative at Charter Communications