Dulce Solano
Upland
Summary
Results-oriented Analyst with 15 years of extensive business experience providing project life-cycle management, reporting, documentation, operational support, and compliance in a variety of industry sectors. Strong commitment to teamwork with excellent interpersonal, organizational, and written and verbal communications skills; comfortable communicating with all levels of an organization.
Overview
14
14
years of professional experience
Work History
Senior Business Analyst – NB Contracting Estimating Team, SP&D
Progressive Specialist Staffing Group
Houston
12.2020 - Current
- Company Overview: Power Gas & Electric (PG&E) San Francisco
- Created work orders in SAP approving or denying timecards, for all OE’s working for contract companies using CMBD to process all invoices working closely with the accounting department making sure we stay in compliance according to SOX regulations for all contracts.
- Managed monthly accruals for all contract companies, reconciling actuals to forecast out monthly and provide an estimate for the and entire year. Increasing the existing Purchase Order (PO) as necessary in order to have enough funds to clear all pending invoices.
- Work closely with the New Business contracting team (SP&D) to execute project plan and ensure all projects meet their design and project deadline.
- Help support the sourcing process, working closely with the scheduling team to help minimize the design estimate project backlog. Determine estimate hours and work types best suited for contracting.
- Manage weekly project status meetings, activities for the current week, helping plan activities for the coming week, working on unresolved issues and ensuring each issue has a resolution plan.
- Manage project risks and ensure there are mitigation strategies put in place to insure we work towards achieving project yearly goals.
- Manage master tracker with over 700 design projects updating design reviews, design due dates, project statues, scheduling status dates, making sure contractors meet all deadlines and adhere to the contract on hand.
- Work closely with the fielding team to identify opportunities to better utilize fielding resources. Ensure projects are fielded promptly (within a three-day turnaround timeframe), meeting with the fielding team weekly to discuss activities scheduled for the current week, activities planned for coming weeks, unresolved issues, and risk, to ensure each has a resolution plan.
- Manage all invoices, extracting financial data for various contractors, analyzing the document for accuracy and invoice approval, coordinating with the finance department team to execute payment and monthly journal entries.
- Created and maintain financial forecast for all contract companies assigned to New Business work with PG&E for both electrical and gas projects. Making sure we stayed within our yearly budget.
- Power Gas & Electric (PG&E) San Francisco
Program/Project Analyst, Transmission Telecommunication
Southern California Edison
Rialto
10.2012 - 07.2019
- Over seven years of experience in an analytical position within T&D providing complex analytical support for major projects (West of Devers, TRTP 1-3, TRTP Seg 4-11 CPCN, Valley South Substation Project) throughout Transmission and Distribution.
- Created work orders and PREQ’s in SAP and Ariba to process all invoice and payments to contractors.
- Work closely with the Production Specialist on the crew scheduling and forecasting construction projects to ensure crews have a continuous workflow.
- Meeting completion project deadlines and providing weekly reports to senior management.
- Manage and maintain effective dialogue with clients, project team members and management to support, monitor and forecast schedule and budget performance for all telecommunication projects.
- Mitigation of issues with Project Managers, Estimators, Planners, and Field Accounting, in order to ensure project operating dates are met and material and labor cost are reviewed.
- Provide complex analytical support and recommendations for planning, scheduling, and project status.
- Manage, forecast, track, and analyze over 200 telecommunication construction projects, utility and non-utility from pre-construction to completion seeing it through the life cycle of the project, using Excel, Access database, and Work Manager to help track the crews as-built, cable, distance, acquisitions, region, budget, from inception to completion, working closely with planners, department managers, collaborating with outside business units Real Properties, Government Lands, Transmission and Distribution, Telecommunication Engineers (IT), and Outside Contractors to ensure that all operating dates are met on time and planners stayed within the project budget.
- Tracked and analyzed over 1000 underground structures (vaults, manholes) for the Deteriorated Vault Project working closely with DPMO (Distribution Project Management Organization) to ensure all structures were inspected for ECS communication cable in order to determine the necessary steps to protect the cables while the vault is being replaced by the regions within Edison.
- Provided monthly reports to senior management, and DPMO with statuses on the underground structures within the regions, completion of inspections, protect in place, and repairs for that month. Worked closely with all the regions analyst(s) to assure we met the yearly goal and stayed within the CPUC guidelines.
- Collaborate with the ECS (Edison Carrier Solutions) Crews, managing all microwave and trouble ticket outages through Crew Manager (ECS data base) making sure all projects have been projected and completed, and theews and planner man-days have been documented completed, reporting monthly to senior leadership.
- Report detailed analysis related to project budgets to Telecomm Engineers on all telecommunication utility projects using SAP, to record all Preliminary, Final, Year to Date, and Inception to Date Estimates, involving Sumitomo, Copper Cable Replacement, Transmission Network, and Client Project’s in order to manage expenditures and report an accurate forecast for future projects to the Telecomm Team monthly.
- Work with all utility planners on preliminary estimates using WOES (work order estimating system) to track all associated cost to the project.
- Working closely with all Transmission Telecom Planners and outside vendors as the lead analyst on pole loading, creating notifications through SAP for thousands of failed and passing poles to ensure all poles are repaired or replaced by project completion and GO 95 and CPUC guidelines.
- Creating Processes – currently working closely with the Process Delivery Team helping develop and establish new processes and procedures for planning using Casewise to establish flow charts and procedures, for all of planning.
- JPO – Tracked all Form 48, Form 2. Form 16, and Foreign JPAs, to verify all ECS work is completed accurately on Joint Pole.
- Job Aid – created thirty job aids for the transmission telecommunication planning team. In order to have proper training manuals for new employment.
- Process Writing – Created documentation of processes/procedures establishing formal documentation for Trans Telecom workflows collaborating with the Process and Delivery Team.
Program/Project Analyst 2, Smart Connect Project - Deployment
Southern California Edison
La Palma
04.2012 - 10.2012
- Helped managed the logistics during the Smart Connect Project, working closely with the deployment team tracking the coordination of the regions, supplies (smart reader), facilities, crews, hotels, in order to meet deployment deadlines. Reported project status to senior management using Excel, Meter Manager, extracting data from all sources, weekly.
- Created and submitted all notification requests using SAP pertaining to ESC- DVI issues and quarries to the offshore (India) team to be added, deleted, and analyzed for accuracy.
- Created and maintain financial forecast for senior management.
- Recorded all notifications, refreshes, which include MSO, POP, and Weekend refresh using Excel, and vendor database.
- Coordinate with Deployment Team and our outside Vendor (Corix) on weekend refreshes and DVI Reconciliation Report using Excel and Lotus Notes to schedule meetings and the selection of new districts to be refreshed, in order for the installation of the smart meter to be installed successfully.
- Scheduled all weekly meetings and calls with Corix, IT, and the Deployment Team through Lotus Notes and WebEx collaborating to insure we meet project deadlines.
- Manage Corix Portal Access for Edison SmartConnect Deployment team through Access data base.
- Worked with outside Vendor Itron and prepared them with a monthly list of AE meters which was generated through Meter Manager and Excel.
- Insure all Corix Invoices are validated and submitted in a timely manner, worked closely with offshore team to ensure analysis is correct and enhance customer satisfaction.
- Ensure that all required Meter Technicians on the ESC (Edison Smart Connect) have a hotel room and maintain all lodging information on a tracker using Excel.
- Work to ensure all hotel invoices from vendors are paid in a timely manner enhancing the relationships with external clients and vendors.
- Managed and processed over 200 vendor invoices monthly using SAP.
- Created work orders and PREQ’s in SAP and Ariba.
Program/Project Analyst 1
Southern California Edison
Irwindale
09.2011 - 04.2012
- Central reviewer responsible for ensuring that 98% of Non-PO Payments are processed within two days from receiving in the CSBU Non- PO payment in-box using SAP. Provided monthly reporting to supervisor running quarries through SAP and generated reports through excel.
- Responsible for collecting, analyzing, and interpreting complex data using Excel (with Pivot Tables).
- Cell box coordinator, responsible for maintaining quality assurance and submitting all cellphone, blackberry, pager request within CSBU through HP Manager Database.
- Created and maintained the Customer Service Wireless Usage Report, provided analysis of usage and cost to management.
- Collected and deactivated all cell phones, blackberries, and pagers to the management, to insure all departments within CSBU are charged accordingly.
- Access order coordinator – assisted as a back-up for all CSBU departments access orders request using Access Ordering Systems, TPX database, and approved and analyzed all User Roll request for all new and existing employees.
- CSS deactivations (SAVS), responsible for deleting and transferring access to all terminated and employee transfers.
- Communicated with all departments within CSBU through Lotus Notes, scheduled monthly meeting for the department and outside vendors.
- Order department supplies through both PREQ’s and the shopping cart ordering system.
Education
Bachelor - Business/ Concentration Project Management
University of Phoenix
Phoenix, AZ05.2013
The Augmented Leader - The Dynamic Leader Women in Negotiations
Rady Center for Executive Development - University of California, San Diego
Skills
- MSWord
- Excel
- PowerPoint
- Outlook
- Lotus Notes
- Ariba
- Access database
- CSS database
- SQL database
- SAP
- Casewise
- Work Manager
- Vendor data base
- Meter Manger
Databases Systems
- MSWord
- Excel
- PowerPoint
- Outlook
- Lotus Notes
- Ariba
- Access database
- CSS database
- SQL database
- SAP
- ARIBA
- Casewise
- Work Manager
- Vendor database (Meter Manager)
Timeline
Senior Business Analyst – NB Contracting Estimating Team, SP&D
Progressive Specialist Staffing Group
12.2020 - Current
Program/Project Analyst, Transmission Telecommunication
Southern California Edison
10.2012 - 07.2019
Program/Project Analyst 2, Smart Connect Project - Deployment
Southern California Edison
04.2012 - 10.2012
Program/Project Analyst 1
Southern California Edison
09.2011 - 04.2012
Bachelor - Business/ Concentration Project Management
University of Phoenix
The Augmented Leader - The Dynamic Leader Women in Negotiations
Rady Center for Executive Development - University of California, San Diego