Customer Service Project
Resume:
James M. Shaffer
Denton, TX 76210
*******@*****.***
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