James M. Shaffer

**** ********** *****

Denton, TX 76210

aceuc7@r.postjobfree.com

940-***-****-h

972-***-****-m

Summary

I have spent 17 years in a Corporate Environment working on Business

Systems Analysis, QA software Testing, Business Requirements

gathering, and Project Management for IT projects. In addition, I have

strong development experience with applications and reporting.

. Ad-Hoc Reporting Experience with SQL, Perl, BI, and Access

. Experience with Three Software Implementations including Oracle R12

EBS and SAP ERP 6.0

. Technical Lead for ETL redesign for data warehouse project using SQL,

Shell scripts, and Perl

. Technical Lead for AMI Reporting project using Oracle OWB and Oracle

BI

. Technical Lead for SAP ERP implementation for ISU/ECC 6

. Technical Lead for the Finance Group for the R12 Oracle EBS Business

Upgrade Team

. Lead for Enterprise job scheduling application implementation of

Appworx & UC4

. Solution Architect for Oracle/Treasury Cash Reconciliation Project

. Lead for Data Conversion projects using ODI, SQL, and Perl

. 13 years in Analysis, Design and Development of Oracle Applications

. 10 Years of experience in the implementation, design, customizations

and extensions in Oracle Financials

. 9 years of experience in Application Development

. Experience developing Oracle Reports 9i/10g/11g

. Experience in Oracle Ware House Builder and OBIEE

. Strong in ETL tuning and Migrations, Data Warehousing and Data

Modeling

Experience

Atmos Energy

Senior Application Analyst

Jun-2006 to Present

. Create and Maintain Development Project Plan for SAP Implementation

Project

. Team Lead for SAP Project Confirm & Approve, Analyze & Design,

Develop & Test Phase

. Reviewed & Wrote Business Process Design Documents

. Develop reports using BI and Analysis Process Designer

. Develop custom code within customer exists and enhancements in BADI's

and user exits within application forms, such as PWB forms.

. Oversaw and setup the job scheduling application for the SAP Batch

jobs within UC4.

. In depth working experience creating and modifying UC4 processes.

. Analyze Functional Requirements and Produce Technical Requirement

Documents

. Create ABAP Programs, Reports, Interfaces, & Smart Forms within SAP

ECC/ISU

. Triage, Track & Report Defects and Fixes within HP Quality center, and

modify SAP Code

. Technical Lead for the Finance Group for the Oracle EBS Business

Upgrade Team

. Supported numerous components such as Device Management, Work

Management, Customer Service, Billing and Invoicing, and FICA.

. Participated in Oracle R12 Upgrade Strategy and Planning workshop

. Configuration experience in Billing, WM, Device & Meter reading.

. Setup Batch programs within SAP and their variants. Oversaw all job

scheduling with SAP.

. Lead & Developed work on Software Change Requests, Trouble Call

Tickets & IT Projects

. Participated in Data Conversion Projects for New Acquisitions

. Lead Oracle Data Warehouse Project and ETL redesign for Oracle GL &

Financial Department

. Maintain OWB, PL/SQL & Perl programs for ETL in Oracle Data Warehouse

. Create Oracle Reports using Developer 2000 and 10g

. Make Changes to Oracle Forms using Developer 2000 and 10g

. Oversaw and setup the job scheduling application for the production

Batch jobs within UC4.

. Lead role in migration of automation jobs from APPWORX to UC4

upgrade/migration.

. Create, Maintain, and Update new and existing Reports using Perl or

Pro C

. Perform troubleshooting to resolve Billing related issues within

Oracle Database

. Coordinate with Lead Developers/Analyst in Business Unit's and IT to

achieve common goals and objectives. Provide Mentoring for Junior

Analyst.

. Completed Hyperion 9 Essbase Bootcamp and Developer Certification for

Hyperion Upgrade

. Develop, Produce, Analyze, & Maintain Data in Oracle Database via SQL,

Perl, or Oracle Reports

. Perform data analysis/validation and error clean-up via SQL or Perl

queries for Oracle GL Interface

. Develop, document, and perform tests on all changes to Database and

track in HP Quality Center

. Develop AMI OBIEE Reports for Business users based on Functional

Requirements

. Develop Oracle APEX Reports for Business users based on Functional

Requirements

. Communicate with users to assist with problem solving and issue

resolution

. Solution Architect for Oracle Treasury Cash Reconciliation Project,

maintain Development Project Plan

Atmos Energy

Systems Analyst

Oct-2000 to Dec-2005

. Created & worked on Software Change Request's, HEAT Tickets,

& IT Projects with GENL, Adjustments, Bad Debt, Reporting,

Data-Mart, MVG conversion, Louisiana Hurricane Accounts,

Kansas Rate Division Consolidation, Deposits, & other functions

. Participated in the LGS, MVG, & TXU Conversion Project by managing

and assisting on Rates, BD, GL, Reporting, Conversion Strategy,

Premise Conversion, & Tax/ZipUtil mapping

. Maintain CIS & GL Database Tables and GLCL codes for mapping to GL

Chart of Accounts in the Oracle Financial Databases

. Research and resolve issues arising or escalating from BU and Call

Center

. Lead for the Billing & Finance Group for the 11i Oracle EBS

Business Upgrade Team.

. Sr. Analyst for the Billing & Finance Group for the 10g Oracle

Upgrade

. Experience building critical business Appworx workflows

. Lead role in migration of automation jobs to Appworxs

. Coordinate with other Analyst in BU's and IT to achieve common

goals

and objectives

. Develop, Produce, and Analyze Daily, Weekly, and Monthly Reporting

for Management and to meet customer's daily needs via SQL or Access

. Perform data analysis/validation and clean-up via SQL and/or Access

queries

. Develop, document, and perform tests on all changes to Database

. Created Design Documents and Developed Test Scripts for Application

changes

. Communicate with users to assist with problem solving and

resolution

Previous Experience

NET2000 Communications - Manager, Accounting Operations

NET-TEL Communications - Credit Manager and Accounts Payable and Receivable

Manager

Independent Financial Services and Insurance Agent

Jackson Hewitt Tax Offices - Tax Preparer

H & R Block - Tax Preparer

A-COM, Inc - Staff Accountant Accounts Payable

Craven Tire & Automotive Corporation - Staff Accountant Accounts Payable

Mobil Oil Corporation - Administrative Services Representative

United States Marine Corps - Section Leader

Education

Strayer University: BS, Business Administration/Accounting -

1996

Strayer University: Associates in Arts, Marketing - 1992

The Marine Corps Institute: USMC - 1993 - Fundamentals of

Leadership

Oracle Training University: 2005-2010 - XML, SQL, Advanced

PL/SQL,

OWB, Reports & Forms, APEX, OBIEE, Hyperion Essbase

Certification

HP Training University: 2005-2006 - UNIX fundamentals & shell

scripting

Global Knowledge: 2007-2008 -

IT Project Management, ITIL V3 Foundations Certification, MYSQL

SAP Training University: 2011-2014 - ABAP Enhancements,

ABAP Workbench & Fundamentals, Smartforms, Intermediate ABAP

Computer Skills

Oracle App., SQL, Perl, ProC, Oracle Reports, Hyperion ESSBASE, OBIEE,

APEX, SAP ECC/ISU, ABAP, Banner, Oracle Warehouse Builder, Access,

Excel, Advantage, UNIX, LINUX, HP Quality Center, Lotus, APPWORX, UC4,

MYSQL, Crystal Reports, MS Project, Word, WordPerfect, DOS, HEAT, PVCS

Tracker, Citrix, Peachtree, Quicken, Intuit, PowerPoint, TaxCut,

TaxPro, TurboTax, IX Plus, GEAC/Concord, Manage, RealWorld,

Counterpoint, Phone Maintenance System, Microsoft, DOS & Windows based

Application Software's

Contact this candidate