Andrew C. Lillie
Sherwood,OR
Summary
Senior Business Consultant with expertise in project management, process improvement and financial analysis. 17 years experience designing electric utility rates and interacting with internal regulatory contacts to interpret and implement tariffs, and to advise on recommended rate design.
Overview
28
28
years of professional experience
Work History
Senior Business Consultant
PacifiCorp
08.2006 - Current
- Manage Retail Revenue Sarbanes-Oxley financial controls.
- Design and maintain 600+ electric utility rates.
- Analyze and interpret data to determine any problems or areas that need improvement.
- Train co-workers on use of Excel, Access, and SAP Business Objects for use in data reporting and analysis.
- Rates and Billing Workstream Lead for PacifiCorp's C2M implementation project.
Business Analyst
PacifiCorp
09.2003 - 08.2006
- Performed business analysis using Excel, Access and other tools.
- Applied performance data to evaluate and improve operations, target current business conditions and forecast needs.
- Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
- Developed internal controls for validating price and rate change accuracy.
Technical Trainer
PacifiCorp
10.2000 - 09.2003
- Proofread, edit and/or translate all out-going customer documents in Spanish; edit scripts for Spanish-language IVR messages.
- Application of adult learning theories.
- Updated training coursework and requirements according to group and technology changes.
Bilingual Customer Service Representative
PacifiCorp
01.1997 - 01.2000
- Assisted Spanish-speaking customers
- Created training module on using interpreters for new trainees at Portland Business Center
- Assisted in devising certification exam for bilingual (Spanish-English) employees.
Education
Master of Arts - Adult And Continuing Education
Portland State University
Portland, Or06.2007
Master of Arts - Language Interpretation And Translation
University of Puerto Rico
San Juan, PR12.1996
B.A. - Spanish Translation and Interpretation
Brigham Young University
Provo, UT1992
Skills
- Fluent in Spanish
- Proofreading skills
- Web-Based Reporting Tools
- Data analysis
- Business Process Mapping
- Staff mentoring
Languages
English
Native or Bilingual
Spanish
Full Professional
Timeline
Senior Business Consultant
PacifiCorp
08.2006 - Current
Business Analyst
PacifiCorp
09.2003 - 08.2006
Technical Trainer
PacifiCorp
10.2000 - 09.2003
Bilingual Customer Service Representative
PacifiCorp
01.1997 - 01.2000
B.A. - Spanish Translation and Interpretation
Brigham Young University
Master of Arts - Adult And Continuing Education
Portland State University
Master of Arts - Language Interpretation And Translation
University of Puerto Rico
Similar Profiles
Marie DurrantMarie Durrant
Assistant General Counsel at PacifiCorpAssistant General Counsel at PacifiCorp
Gavin MortensenGavin Mortensen
Control and Electrical Technician at PacifiCorp energiesControl and Electrical Technician at PacifiCorp energies
Robbin HannahRobbin Hannah
Haul Truck Driver at Pacificorp-Bridger CoalHaul Truck Driver at Pacificorp-Bridger Coal