SCOTT HARRIS
303-***-**** **** Sea Pines Way, Lantana, FL, 33462
PROFESSIONAL SUMMARY
Project Coordinator 8+ years of experience managing project scope, tracking project progress, identifying risks and issues throughout the project lifecycle, and assisting in the creation of mitigation strategies and contingency plans to ensure timely project closure, payment, and reconciliation. Proven track record of success, ensuring the completion of assigned project deliverables in dynamic and complex environments. Expertise in the construction, public utility, financial services as well as the home mortgage, and commodity reporting industries. Data Analyst with 13+ years of experience providing technical expertise and support to multiple business units, ensuring that overall data standards, data quality, and data availability fully support the company’s goals. Possesses a strong understanding of industry trends and experience collecting business data, analyzing information, creating reports, and developing improvement and enhancement solutions based on findings. KEY QUALIFICATIONS
Data Analytics: advanced data mining; data formatting; data science research methods; experimental design & analysis; data warehousing; variance reporting.
Project Management & Coordination: scope development; cost management (budgeting); risk management; quality management; resource management; requisition process; time management; scheduling; negotiation; decision making. Settlement: invoice reconciliation; contract management; customer relations. Soft Skills: critical thinking; leadership skills; problem-solving skills; team player; organization skills; strong interpersonal communication skills.
Software: SQL, MS Office (MS Excel, Access); IBM WEBI Business system; SAP; Passport software. PROFESSIONAL EXPERIENCE
DATA ANALYST
IMPRIVA, Las Vegas, Nevada February 2020 – April 2020
Interpret data, analyze results using statistical techniques and provide ongoing reports
Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
Acquire data from primary or secondary data sources and maintain databases/data systems
Identify, analyze, and interpret trends or patterns in complex data sets
Filter and “clean” data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems
Work with management to prioritize business and information needs
Locate and define new process improvement opportunities SETTLEMENT SPECIALIST/DATA ANALYST
NextEra Energy Resources, Juno Beach, FL November 2015- May 2019
Managed the reconciliation and settlement of third-party energy suppliers’ purchases and sales by preparing and processing 70+ settlement invoices monthly.
Reconciled assigned accounts, researched discrepancies, reviewed contracts to calculate and confirmed revenue and costs for the various deals when needed, and worked directly with customers and traders to resolve differences through detailed data analysis.
Ensured prompt payment to and from counterparties by reviewing and verifying all open A/R and A/P and analyzing real-time data using Excel. Liaised with the IT department to troubleshoot and correct data issues enabling the company to collect 40M+ monthly in invoices in a timely manner.
Prepared and analyzed closing reports, assisted with ad hoc requests, processed settlement invoices/purchase statements and provided management with explanations (volumetric/valuation) for estimate to actual variances.
Trained new employees entering the department on running and analyzing weekly and monthly Excel reports.
Reconciled renewable energy credits managing accruals, inventory, and deliveries related to assigned deals. RESEARCH ANALYST/PROJECT MANAGER October 2013 - November 2015 S&P Global, Platts, Denver, CO
Managed end-to-end 4 to 6 research projects average monthly for multinational companies worldwide in the energy, steel, and petrochemical sectors, ensuring that the deliverable meets expected high-quality standards of analysis and timeliness.
Developed relationships with high-value data sources and ensured verification of the accuracy of the data collected and reports by performing testing, evaluation of completeness, and incorporation into a proprietary database system.
Led a cross-functional team, including sales and data group management professionals, to meet the client’s research requirements and ensure ongoing strategic alignment and prioritization. Built and managed the relationship with third party companies and guided them on collecting relevant data from online sites, company contacts, interviews, industry conferences, and the company filed reports for S&P clients.
Maintained ongoing dataset metrics such as price, demand, import, export, and asset tracker as per client’s request.
Leveraged existing data management processes to implement and maintain the optimal strategy for collecting, loading, reviewing, and delivering relevant content to internal and external customers.
Worked with data group management to implement sector-specific quality assurance programs for content. Conducted market assessment of available and relevant content to be delivered as part of oil (or another sector) core market fundamental data.
FINANCIAL DATA ANALYST February 2012 - October 2013 Specialized Loan Servicing, Littleton, CO
Prepared and analyzed daily activity reports tracking home mortgages moving through the new business operation including explaining any fluctuations. Prepared daily, weekly, monthly performance reports for investors tracking application volumes.
Helped the company to make informed business decisions by creating complex ad hoc reports using SQL and Access to summarize current and projected financial information. Performed trend data analysis understanding the general direction of the market facilitating projections and assessments of the company's financial health.
Checked data for correctness through monitoring and auditing data loads of the business to a consolidated data warehouse.
CONSTRUCTION PROJECT COORDINATOR
Xcel Energy, Denver, CO August 2005 - February 2012
Assisted the Project Manager in providing tracking of project plans, identified potential gaps, and developed closure plans. Ensured the successful completion of assigned project deliverables and milestones.
Tracked and prepared project control metrics including Earned Value, Cost Performance Index (CPI), Schedule Performance Index (SPI), project costs to date, cost and schedule variance, and resource allocation and utilization. Verified and approved funding for short and long term above and below ground construction projects considered by Xcel.
Assisted PM on implementing overall project scope, schedule, cost, and risk management. Performed project-level cost tracking and reconciliation, including operation and maintenance of expenditures to ensure association with the correct accounts through IBM WEBI Business system and Passport software.
Analyzed and researched open work orders & created corrective journal entries in J.D. Edwards to move incorrect capital and O&M charges to the correct accounts ensuring minimal AFUDC charges and correct accounting for SOX compliance.
Maintained an accurate count of all street light projects in the PSCO, SPS, NSPM and NSPW regions ensuring correct counts and costs.
Compiled charges and prepared invoices for billable assistance to other utility companies to ensure a timely accounting process.
EDUCATION
Masters Degree in Business Management, Colorado State University, Colorado Springs, CO (Change Management)
Bachelors Degree, Sociology, The Ohio State University, Columbus, OH
PMP Certification, PMI Institute. Expected completion on September 1st PROFESSIONAL DEVELOPMENT - OCCUPATIONAL LICENSES & CERTIFICATES
Six Sigma Yellow Belt, Six Sigma December 2016
Photovoltaic Certification, Arapahoe Community College January 2010
NERC System Operator, NERC July 2002