Project Customer
Resume:
LEONEL URENA
Piscataway, NJ 08854
**********@*****.***
SUMMARY
Intelligent, enthusiastic, and motivated consulting professional with 11 years of experience in developing/designing/QA testing
enhancements on the ORACLE Customer Care & Billing (CC&B) & PeopleSoft ERM software products for multiple utility
Customer Information System (CIS) implementation projects. Possess over 14 years of utility business experience along with
extensive knowledge in resolving different functional issues on the Peoplesoft CIS & CC&B applications. Involved from start to
finish on several full cycle implementations for different utility companies. Bring hands-on experience as a data conversion
support lead from legacy utility CIS systems to both the PeopleSoft ERM & CC&B products. Work well under close deadlines &
provide effective results meeting the functional needs of customers. Handle multi-tasking efficiently and adapt quickly to new
changes. Consistently shown the ability to deliver on numerous CIS implementation & post-implementation projects . Possess a
broad understanding of utility CIS solutions, demonstrate industry best practices, and execute multiple business processes.
AREAS OF STRENGTH
Utility CIS products
• Customer Care & Billing (CC&B) v1.3, v.1.5.5, v.1.5.15, v1.5.10, v.1.5.20, v2.1, v2.2, v2.3.1
• PeopleSoft ERM v8.95
• PeopleSoft CIS v7.6, v8.0, v8.8, v8.9
• CIS Plus
Programming Languages
• Java
• Micro Focus COBOL
• PLSQL
• SQL Plus
• Natural/Adabas
• Natural/DB2
Engagement Experience
• Smart Grid project design
• Problem and Incident
• Service Level Support
• CIS product Implementation Methodology
• Assessment and Planning
• Functional Testing
• Estimating Level of Effort
• System Configuration
• Interface QA testing
• Data Conversion Capacity & Performance
• Design for Custom modules
PROFESSIONAL EXPERIENCE
ORACLE Corporation, Bridgewater, NJ – Senior Principal Consultant Jan 2007 – present
Baltimore Gas and Electric Power Utility CC&B project
• Developing Architect design solutions for a number of processes to fill system gaps for a Smart Grid
implementation on the CC&B v2.3.1 product for a client with a total of 1.3 million customers.
• Working diligently to meet all customer defined requirements on the Smart Grid effort.
• Leading a group of CC&B Developers in creating viable functional & technical solutions in the CC&B
system for 2 new Smart Grid projects.
• Creating functional designs for new extensions in the CC&B product under very aggressive deadlines.
• Providing key functional support to current CC&B users on the client side as well as several
implementation partners.
• Involved in the planning/estimate effort for the Smart Grid project design wave phase.
• Applying CC&B product knowledge to create multiple viable solutions in different areas of the system,
including a focus on the use of the Configuration Tools capabilities as part of some of the functional designs.
Greystone Power Electric Utility CC&B project
• Executed detailed Quality Assurance testing for Interface customizations at the Post-Go live phase of the Greystone
Power electric utility CC&B implementation project.
• Ensured complex client requirements on CC&B product customizations were met.
• Generated test plan scenarios for delivered custom Interfaces which were provided to the client business team.
• Assisted in promotion of Interface code from System Testing to Production environment.
• Led the data conversion effort for the implementation phase & go-live of the Greystone Power CC&B project.
• Completed mapping analysis & documentation for legacy data to adhere to CC&B’s different data structure.
• Developed conversion toolkit scripts for submission of batch jobs on Unix servers which validated & transferred legacy
CIS data from Staging to Production on the CC&B product.
• Created complex SQL/PLSQL scripts and processes to validate customized conversion data.
• Analyzed conversion related issues & provided multiple resolution options to the customer.
• Successfully converted CIS data for 120,000 residential & commercial utility customer accounts.
• Consolidated customer account & premise conversion data from legacy ORCOM system to CC&B.
• Delegated a coordinated effort which delivered quality conversion data for the functional testing team.
Toronto Hydro Electric Utility CC&B project
• Led the data conversion effort for the implementation phase & go-live of the Toronto Hydro CC&B project.
• Provided functional support for toolkit processes that transferred customer CIS data from the Staging to Production level
on the CC&B product.
• Worked diligently to satisfy all customer requirements for the conversion effort.
• Applied CC&B functional knowledge to actively support multiple 3rd party implementation partners in a cooperative
environment.
• Achieved aggressive project deadlines thru extensive effort while continually providing quality work.
• Executed conversion toolkit processes to load data from Staging to Production on internal & Dress Rehearsal runs.
• Developed multiple scripts that converted legacy staging data to customized CC&B data structure tables.
• Successfully converted CIS data for 1 million residential & commercial utility customer accounts.
• Supervised extensive mapping documentation from Banner legacy system to CC&B’s complex data structure.
Enersource Hydro Mississauga Electric Utility CC&B project
• Responsible for data conversion support on the implementation phase & go-live of the Enersource Hydro Mississauga
CC&B project.
• Executed conversion toolkit processes to load data from Staging to Production on both internal & Dress Rehearsal runs.
• Provided extensive conversion functional CC&B support to both the client & 3rd party implementers.
• Delivered quality conversion data to the customer during the go-live effort while executing all processes in the expected
time window.
• Analyzed conversion related issues with the client and different implementers.
• Resolved problems successfully in an effective manner.
• Reviewed & approved mapping documentation from ORCOM legacy system to CC&B’s relational data structure.
• Successfully converted CIS data for 230,000 residential & commercial utility customer accounts.
Toronto Hydro/Enersource Hydro Mississauga Electric Utility CC&B joint project
• Part of the design team which created custom design documentations for the functional modifications required.
• Delivered numerous functional customization design documents for the CC&B product that addressed customer
requirements within project deadlines with a level of effort ranging from simple to complex.
• Analyzed international government regulatory rules affecting changes on custom modifications.
• Applied extensive knowledge of the CC&B base product to provide explanations accepted by the client.
• Worked diligently to correctly estimate design specifications for Oracle’s offshore Development team.
• Responsible for addressing changes to customized designs on several CC&B areas such as Meter Management, Deposits,
Field Activity, and Customer Information.
• Provided quick turnaround process for test planning and test execution.
• Reviewed all functional areas of the CC&B product with utility business team personnel.
• Participated in a 5 month long functional process analysis phase with over 35 members of the utility business team for the
cooperative client implementation effort.
• Served as the lead on a few of the process analysis sessions presenting for 10-15 client business team members.
• Noted & analyzed functional processes along with custom requirements from the client outside the base product
functionality.
• Analyzed gaps identified in the Discovery phase and discussed requirements which met both clients’ functional business
needs.
• Engaged utility customer on the understanding of the different areas in the CC&B system, including interval billing &
meter management.
Southern Maryland Electric Utility CC&B project
• Provided utility client CC&B system post-implementation support.
• Analyzed QA defects identified by the customer and provided successful resolutions.
• Made changes to external & internal design documentation to address new requirements.
• Communication with client on review of defect solutions.
Orlando Utilities Commission Electric Utility PeopleSoft ERM project
• Successfully executed conversion scripts & processes for the data transfer from a legacy Banner system to the PeopleSoft
ERM product for over 150,000 customer accounts.
SPL Worldgroup, Morristown, NJ – Functional Designer Aug 2004 – Dec 2006
Orlando Utilities Commission Electric Utility PeopleSoft ERM project
• Created external interface design documentation for the Orlando Utilities Commission project as part of the PeopleSoft
ERM implementation.
• Involved on extensive Gap analysis while meeting customer specific requirements.
• Traveled to offshore development side to coordinate & support Interface design & code development effort.
• Delegated on-site support to the customer for Interface deliverables as well as the entire data Conversion effort.
• Investigated functional issues on the PeopleSoft ERM product as part of the implementation & post-implementation
efforts.
Texas Utilities Electric SPL Cordaptix upgrade project
• Design work for the conversion of Customer Contact data in Siebel (CIM) application over to CC&B for the Texas
Utilities (TXU) project.
• Performed the initial technical design for Address Validation in CC&B interfacing with CODE1 software.
• Part of the team to upgrade SPL Cordaptix system from version 1.3.31 to version 1.5.10.
City of Albuquerque PeopleSoft CIS project
• Onsite design & development analyst for the data conversion process which handled the creation, testing, and billing of
Backflow Device service information for the City of Albuquerque utility.
• Handled the presentation which showed the setup for Backflow Devices in PeopleSoft CIS system to different business
team members.
• Developed modifications to the PeopleSoft CIS v8.8 letter extract process where client business requirement needs were
satisfied.
Grays Harbor Electric Utility PeopleSoft CIS project
• Provided onsite support in all functional system areas of the PeopleSoft CIS v7.6 product to the Grays Harbor Utilities
customer.
• Analyzed and resolved issues identified by the client.
• Designed & developed new Interface meter read upload process for Automated Meter Read (AMR) meters.
SPL Worldgroup, Morristown, NJ – Functional Developer Jul 1998 – Jul 2004
Cedar Falls Utility Peoplesoft CIS project
• Executed functional QA testing for configured processes.
• Developed & tested delivered COBOL plug-in modules based on internal design documentation.
• Assisted utility customer with the implementation & configuration effort of the custom plug-in code.
Jacksonville Electric Utility Peoplesoft CIS project
• Development of COBOL code for customized Pre-Paid processes.
• Responsible for analyzing, coding, and testing functional enhancements to the PeopleSoft CIS system.
• Supported implementation partner developers on custom plug-in and interface processes.
• Assisted off-short development team in packaging custom enhancements.
Philadelphia Gas Works Utility CIS Plus project
• Developed new modifications for Philadelphia Gas Works customer client through designed Change Control requests.
• Assisted with QA, migration and test documentation tasks.
• Provided functional CIS system support on outstanding issues reported by the customer.
• Developed and tested client specified software enhancements for Phase 2 of the Deregulation effort.
• Assisted with QA analysis and test document creation.
• Involved on the development and testing effort for client specified software enhancements from the Phase 1 of the
Deregulation effort.
Rocky Mount Utility CIS plus project
• Investigated and analyzed operational problems to reestablish the Billing subsystem.
• Executed analysis, development, and testing for batch processes that resolved billing issues generated by loss of data on
the client side.
Northern Kentucky Water Utility CIS plus project
• Analyzed legacy data files and validated conversion data for 2 different regions of utility customers.
• Delivered successful functional support during the eight month test and go-live period.
• Supervised full data conversion process for go-live.
Utilitcorp United CIS plus project
• Performed QA testing for custom system enhancements in an MVS environment using Natural/DB2 code.
• Developed and tested components on major enhancements implemented on the CIS Plus billing engine.
• Responsible for identifying and resolving issues on the CIS Plus system.
• Helped develop and execute procedures for code upgrade and migrations.
EDUCATION & LANGUAGES
Rutgers University, College of Engineering, New Brunswick, New Jersey
B.S., Mechanical Engineering – 1998
Fluent Languages
• English
• Spanish
CERTIFICATIONS & COURSE WORK
• Oracle CC&B Configuration Tools v2.2
• Oracle CC&B Configuration Tools v2.1
• Oracle CC&B Toolkit CC&B 2.1
• SPL Cordaptix Conversion Toolkit v1.5.5
• SPL Cordaptix Implementer training v1.5.5
• SPL Cordaptix Implementer training v1.3
• SPL Cordaptix Plug-In development v1.3 & v1.5.5
• SPL Cordaptix Credit and Collections v1.3 & v1.5.5
• SPL Cordaptix SA Relationship Configuration v1.3 & v1.5.5
• SPL Cordaptix Maintaining SA Types v1.3 & v1.5.5
• SPL Cordaptix Rate Configuration v1.3 & v1.5.5
• SPL Cordaptix Field Activity v1.3 & v1.5.5
• SPL Cordaptix Development tools v1.3 & v1.5.5
• SPL Cordaptix Overview & Technical Architecture v1.3 & v1.5.5
• PeopleSoft CIS Conversion Toolkit v8.8
• PeopleSoft CIS Implementer training v7.6
• PeopleTools training (Ver. 8.12)
Contact this candidate