SEARCH

Principal Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
PRINCIPAL
Core Qualifications
  • Proficient in SQL, Oracle, Visual Basic Application, Access, Excel
Experience
March 2013
to
Current
CONSTELLATION NEW ENERGYHouston, TXPrincipal
  • Acted as point of contact on the Pricing system conversion to REPS for ERCOT and CAISO markets.
  • Provided business requirements and seed data, as well as performing various testing and validation to ensure smooth transition.
  • Maintain ERCOT, CAISO, and Oregon market expertise.
  • Perform necessary validations and updates to pricing models and inputs.
  • Participate in RFP process and perform complex deal structuring, such as Blend and Extend and product restructuring.
  • Develop and maintain Pricing Dashboard that houses various functions including pricing queue, cost deck breakdown, account information, add/delete premium calculation, capacity cost calculation, and historical energy curves comparison.
  • Continuously involve in various joint projects with other business groups, including but not limited to Early Termination Fee automation project with IT and Customer Retention group.
March 2008
to
March 2013
CONSTELLATION NEW ENERGYHouston, TXSenior Analyst
  • Collaborated with IT on the company wide system conversion to SMIS and later to SIEBEL/Lodestar.
  • Designed and maintained SQL-based, highly automated pre-deal and pricing infrastructures.
  • Created auto-run queues and user friendly front-end to increase accuracy, efficiency, and reduce human errors.
  • Acted as a subject matter expertise for ownership of pricing/supply databases, data generation, and process/deal flow.
  • Developed automated reporting front ends for various ad-hoc requests from Management regarding prospective customers, closed deals, renewal customers, sales volumes, and margins.
  • Developed various Excel/VBA based pricing tools for better efficiency and accuracy in pricing.
  • Automated pricing for gas locks, fixed heat rate, product restructuring, and blend/extend to flow seamlessly through SIEBEL/Lodestar.
May 2004
to
March 2008
CONSTELLATION NEW ENERGYHouston, TXPricing Analyst
  • Facilitated retail energy pricing and product structuring for Sales in ERCOT and CAISO.
  • Analyzed outcome for data accuracy, consistency to market movement, and profitability.
  • Communicated pricing decision logic to Sales to enhance understanding.
  • Worked with Supply team to create an automated forward curve generation process.
  • Developed a system to produce portfolio valuation and net open positions in power and gas to enable risk hedging strategy.
  • Designed a database that centralizes balancing energy market price information from ERCOT.
  • Generated various queries, reports and processes from the dataset for Sales and external customers.
  • Processed ERCOT settlements and invoices.
  • Updated pricing scalars based on this information for accuracy and competitiveness.
  • Supported Finance and Audit group in monthly close financial reports in accordance with Sarbanes-Oxley requirements.
September 2002
to
May 2004
SPRINTOverland Park, KSFinancial Analyst
  • Risk Strategy and Credit Operations - Acquisition Strategy Performed ROI analysis on risk segmentation and deposit optimization strategies used at the point of customer acquisitions.
  • Constructed performance and financial forecast on new credit and fraud models.
  • Implemented two (2) new customer acquisition models into production, which resulted in 32% and 30% reduction in annual fraud and churn rate.
  • Collaborated with other departments in the development of business cases to support various credits and billing projects.
  • Achieved a higher new subscriber growth rate than the established baseline of 172,000.
  • Coordinated the development of various Oracle databases capturing information on Sprint PCS applications and activations.
  • Project resulted in an annual cost saving of approximately $100,000.
August 2000
to
August 2002
UNIVERSITY OF OKLAHOMA Michael F. Price College of BusinessNorman, OKResearch Assistant
  • Developed financial simulation model to track returns and risks of investment portfolios.
  • Gathered necessary data, performed data analysis, and provided statistical assistance to support various academic researches.
May 1998
to
August 2000
HARRISON GYPSUM COMPANYLindsay, OKFinancial Analyst
  • Performed audit on fixed assets depreciation expenses for efficiency improvement and cost reduction.
  • Produced depreciation schedules for internal book and tax reporting purposes.
  • Implemented FAS for Windows software for on-going tracking of depreciation expenses.
  • Analyzed user requirements, procedures, and solved problems to automate processing.
  • Created user manuals and trained employees on using the depreciation system.
Education
05/2001
University of OklahomaMBA: Finance and MISGPA: GPA: 3.68/4.00Finance and MIS GPA: 3.68/4.00
Recipient of summer study grant at Consortium of International MBA in Asolo, Italy, Summer 2000.GPA: Michael F. Price Scholarship, Frakes Memorial Scholarship.Michael F. Price Scholarship, Frakes Memorial Scholarship.
05/1998
University of Oklahoma, OKBBA: FinanceGPA: GPA: 4.00/4.00Finance GPA: 4.00/4.00
Skills
academic, acquisitions, ad, automate, automation, billing, book, conversion, cost reduction, Credit, data analysis, databases, database, Excel/VBA, Finance, financial, financial reports, fixed assets, logic, market, MBA, Access, Excel, Windows, 2000, optimization, Oracle, Pricing, processes, reporting, retail, RFP, Sales, Sarbanes-Oxley, settlements, SIEBEL, simulation, SQL, Strategy, tax, user manuals, validation, valuation, Visual Basic
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • CONSTELLATION NEW ENERGY
  • SPRINT
  • UNIVERSITY OF OKLAHOMA Michael F. Price College of Business
  • HARRISON GYPSUM COMPANY

School Attended

  • University of Oklahoma
  • University of Oklahoma, OK

Job Titles Held:

  • Principal
  • Senior Analyst
  • Pricing Analyst
  • Financial Analyst
  • Research Assistant

Degrees

  • MBA : Finance and MIS
    Recipient of summer study grant at Consortium of International MBA in Asolo, Italy, Summer 2000.
    BBA : Finance

Similar Resumes

View All
Principal-resume-sample

Principal

Vermilion Design Group

Ankeny, Iowa