Proficient in SQL, Oracle, Visual Basic Application, Access, Excel
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.
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.
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.
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.
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.
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.
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.
University of Oklahoma, OKBBA: FinanceGPA: GPA: 4.00/4.00Finance GPA: 4.00/4.00
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.
Companies Worked For:
CONSTELLATION NEW ENERGY
UNIVERSITY OF OKLAHOMA Michael F. Price College of Business
HARRISON GYPSUM COMPANY
University of Oklahoma
University of Oklahoma, OK
Job Titles Held:
MBA : Finance and MIS Recipient of summer study grant at Consortium of International MBA in Asolo, Italy, Summer 2000. BBA : Finance
Create a job alert for [job role title] at [location].