Peter Huffaker Email & Phone Number

Reconciliation of off-net facility inventory to vendor invoice for financial reporting and month end close processes. Use Oracle's Brio/Hyperion to interface with databases for initial data mining. Manual reconciliation and data validation activity is performed in MS Excel to create templates to be uploaded into the supporting databases. TOAD and SQL Server 2008 are used to write code and access the production Oracle and SQL Server databases, to validate reporting data and to with the dbas to improve back-end support. We partner with Access Management Organization, Financial Planning and Analysis and Management Reporting and Business Intelligence teams to create, quality check and validate reporting accuracy.

Working in ticketing console environment to facilitate resolution of defects we have researched. Working in Clarify, Siebel 6.3, Siebel 7.8, CircuitVision, Telcordia Network Engineer, 3 Kenan billing environments. Stakeholder management, process mapping and research related to data and voice fiber circuits, dark fiber IRU contract and term compliance. Using SQL Server and TOAD to gather and format data and Visio, Excel, Word, and Outlook to report findings. Meetings with stakeholders, fix agents, process owners and smes.

Appointed Principal in January 2010. I have performed bass in nearly every concert of the 10 seasons the LTSO has existed and I enjoy working with musicians who desire to improve theri skill set.

Still one of my passions! Music keeps you young and humble if you let it.

I was in transition with over 10 years’ experience in Telecom ranging from Collections toFinancial Reporting to Project Management to System Analyst to Billing Analysis.I possess soft skills to relate with people at many levels from the janitor to the C-level and the customer.I am able to extract, format and report on data from data warehouses and other sources.I am self-directing, work well in a team, enjoy problem solving and root cause analysis, am a quicklife-long-learner and can balance detail with the big picture.I am advanced to expert in all MS Office apps and many data extraction/manipulation tools, ProjectServer, Visio, HP Service Desk, Ops Console and more.

System Analyst - IT Specialized BillingMaintained Group Mailboxes and delivered hundreds of email and voice responses each week. Delivered more than 10,000 usage reports per month on Enterprise Accounts billing in excess of $2Bil per year. SME on electronic billing products in SMARTCD, Data Direct, EDI and eBA formats. Assisted Sales Support in cross-functional solutions to complex Enterprise Account issues and questions.Technical Project ManagerManaged a team of SAS Programmers and Statisticians on delivery of time sensitive support for pro-active marketing initiatives targeted to reduce voluntary churn which contributed to an overall reduction of churn to 1.42% by July 2005. Was a System Administrator of a MS Project Server iteration through which we tracked upwards of 150 Projects run by 3 teams.Financial Reporting ManagerMy team successfully compiled and delivered a monthly Management Book to our local VP, Treasury HQ and the CFO with visibility up to and including CEO. It was a dashboard presentation assembled using many tools including SQL Server DTS packages, SQL queries, SQL*Plus, Excel macros, graphs and charts, Word docs, imported to and finalized in PowerPoint with some animation and audio. The M-book was a reliable source for the Treasury team's financial forecasting of cash flow.I Project Managed the creation of an involuntary churn forecasting tool which presented a view of involuntary churn numbers' effect on the present and the near future cash flow.I oversaw the compilation and distribution of data used to create daily lists of Outstanding Collectable Contactable (OCC) regional accounts Results included an incremental decrease on Days Sales Outstanding (DSO).My responsibilities also included managing the Outside Collection Agency (OCA) reporting which allowed the OCA managers to exceed goals to increase cash flow by exposing underperforming agencies' and moving uncollected debt portfolios to the highest achieving agencies.

Played bass and toured with Les Miserables 3rd Nat'l Tour for about 18 months straight. Left the Company and moved to Colorado to transition to my job as "Dad" for my amazing son, Anthony.

Responsible for the bass studio consisting of undergraduate level students in this Liberal Arts school. Conducted weekly Master Class and private lessons with a bass students. Adjudicated all string department student juries for the3 semesters I taught there.Led a small jazz combo each semester and guided them through beginning and intermediate improvisational concepts.Performed for the student body with the Millikin University Faculty Jazz Combo.

Education record

Bachelor Of Music, Music, General Education

Activities and Societies: Abe Luboff was my bass instructor. While in the CSULB Orchestra, we backed up the Carpenters on what turned out.