Jim Caley Email & Phone Number

Dayton, Oh, Us

Dayton, Ohio, United States

Serving as legacy subject matter expert for a project to convert a mainframe-based Customer service and billing system to SAP utilities solution. Leveraging specific expertise in Ohio PIPP program to facilitate test data set-up and verification.

Baltimore, Maryland, United States

Served as a designer and SME for large project team converting CIMS (Customer/1) to Oracle CC&B. Wrote and validated SQL code to access legacy data staged in Oracle to transform to Oracle CC&B database. Worked closely with offshore development group programming and executing ETL's in Informatica.

Dayton, Ohio Area

Performed enhancements and application support for AEP's MACSS (Customer/1) credit and collections agile team. Analyze complex problem tickets and business requests, and implement modifications using COBOL, mainframe, Db2, SQL and JCL. Create detailed testing and support documentation. Serve as technical and functional subject matter expert for offshore support and development groups. Key contributor to project teams and sprints using Agile methodology.

Remote

Project and production support roles for Westar and Dayton Power & Light

Greater Atlanta Area

Project Manager for data conversion from legacy Customer Information System (mainframe/Db2) and legacy front-office database (SQL), to Oracle CC&B database. Served on PMO and provided scope analysis, team staffing recommendations, estimates, and budgets. Performed data mapping and design for Informatica processes to stage and convert data. Implemented and tested data conversion processes. Provided guidance to development resources to build conversion process. Performed QA testing using SQL Developer and CC&B online application to validate converted data.

Dayton, Ohio Area

Itineris (formerly Crimson Oak Consulting), helps electric, gas and water utilities improve customer service and decrease IT maintenance costs through Legacy CIS extension strategies, consulting services and UMAX™, an out-of-the-box CIS Solution. Served as solution architect for a data conversion project to migrate data from mainframe/Db2 to a SQL server-based application using Informatica. Served as US product manager for UMAX.

Dayton, Ohio Area

Clients & Projects:Dayton Power & Light - 2008 through 2011 - Performed production maintenance and support tasks for outsourced CIS application. Managed successful implementation of a major CIS enhancement project to meet Ohio PIPP reform (PIPP Plus) requirements 2010 through 2011.AGL - 2005 through 2008 - performed programming and testing for CIS enhancements resulting from M&A activity. ONEOK - 2003 through 2005 - performed analysis, design, programming & testing for 2 separate CIS conversions. Developed and monitored audit controls verification for both cutovers. Dominion / Virginia Power - 2002 through 2003 - Designed and implemented a business intelligence solution for credit/collections business unit. Transformed mainframe-based CIS data into Oracle database suited for BI analysis, designed Cognos cubes & reports.Illinois Power - 2001 through 2002 - Performed analysis and design for repeatable data conversion process. Led software selection for ETL solution.

Formerly CMSI, formerly Pathways Consulting. Served in a variety of roles from Project Management to design, build and testing for various clients in the utility industry. Led business development activities and managed relationships with clients. Interviewed and hired candidates to fill project roles for staff augmentation and projects.

Houston, Texas, United States

Performed design and programming for Customer/1 implementation at Florida Power Corp and Southern Company. Formerly Andersen Consulting.

Mba

Bba

Activities and Societies: Phi Delta Theta fraternity