Gary W. McSorley

4 programming language courses

                Basic

Fortran

COBOL

                Pascal I & II

5 SAP training courses

                FIN110 – Financials 1

                BC410 – Introduction to ABAP

                PLM115 – Basic Data for Process Industry

                AC505 – Product Cost Planning

                AC520 – Product Cost Controlling

SAP EXPERIENCE

June, 2010 – November, 2010

Johns Manville Corp.                                                                       SAP CO-PC Functional Consultant

• Post Go Live Production Support and Stabilization for 15 Insulation Division locations. Included training users on Product Costing and month end transactions. Training and verification of SAP processes including including creation and execution of assessments, indirect activity allocations, recosting at actual using the Material Ledger.
• Responsible for accuracy of Master Data of all Costing and integrated MM data. Trained SuperUsers on use of automated upload transactions and reconciliation of data for Cost Center planning.Included use of mass maintenance and LSMW transactions, SE16 and SQVI transaction for quick analysisof master data.
• Maintenance of Costing Sheet configuration changes and annual rate updates.
• Creation of functional specs for reports and customized transactions.

March, 2009 – April, 2010

ACH Food Companies                                                                      SAP CO-PC Functional Consultant

• Wave 1B COPA rebuild project. Original design was so granular that the system could notcomplete the COPA assessments. Team member during change of design to fewer business groups and business segments. Redesigned P&L layout from full detail P&L to contribution margin P&L to greatly reduce the amount of time that it took for assessments to run.
• Created upload program for COPA assessments, with developer, using RFC to map COPAfields to input files.
• Team member of complete delete, rebuild, and reconciliation of COPA data for B, D, and Frecord types.
• Became more familiar with BW/BI as reconciliation tool for Sales doc, and assessment reconciliation.
• Assisted with Report Writer report creation for some reports.
• Create, validate, and execute all FICO test scripts in HP Quality Center v.10

April 2008 – February 2009

Itelligence Group                                                                                SAP CO-PC Functional Consultant

• FICO Lead for Blueprint, design, build, and test phases of ECC 6.0 implementation

of global corporate manufacturing firm.

• Use of SAP Cockpit and Solution manager to reduce implementation time of project.
• Product Costing including Costing Variants, Cost component structure, Valuation classes

and automatic account determination, Costing sheet including manufacturing overhead, shipping

distribution adder, overhead keys and groups for purchased and raw material handling overhead.

Costing run sequence design.

• Product Cost planning including planning profiles and layouts, integrated Excel and file description

for automated plan upload. Distribution key creation. Assessment and distribution cycles and segments.

Activity type master data and integration points to PP module.

• Internal Orders including Settlement profile, Order types, Allocation structure and corresponding

source and secondary cost elements. Integration with Fixed Asset module for Assets Under Construction.

• Credit and Risk Management including Credit Control Area, Company Code assignment for centralized

Credit Management, dynamic credit check config. LSMW load of legacy customer credit limits.

• Accounts Payable including House banks, check lots, reason codes, payment terms and methods,

payment program Configuration, and paying company code data.

• Responsible for writing queries for master data verification of legacy data.
• Use of existing LSWM’s for Fixed Asset, GL, and Open AP and AR uploads.

October 2007 – March 2008

Titan Technology Partners                                                                             CO-PC Functional Consultant

• Creation of LSMW’s for master data conversion, and legacy transactional inputs.
• Writing of functional specifications for ABAP RICEF report objects.
• CO testing during unit, assembly, integration, and user acceptance test.
• Requirements gathering for customer requirements.
• Perform SAP Product Cost configuration, and master data verification.
• Use of SAP version ECC 5.0.

August 2006 – July 2007

Accenture                                                                                                             CO-PC Experienced Analyst

• Using such tools as Mercury Quality Center, Star Team, and Caliber to prepare Product Costing test scripts for System and Assembly test passes 1 and 2 on Accenture’s Pepsi One Up project.
• Writing of functional specifications for ABAP RICEF report objects.
• Material ledger configuration for plant activation, distribution of inventory differences, and multiple valuations for transfer pricing.
• Product Cost configuration for product costing, and transfer pricing cost runs.
• Master data verification and error identification.
• Mentoring/teaching analysts in how to prepare functional specifications and general SAP questions.
• Perform SAP Product Cost configuration, master data verification, and all functional requirements in PCP.
• Use of SAP version ECC 6.0

August 2005-June 2006

International Paper                                                                                                       

IT Business Analyst                          

• Team member of global implementation for CO (Product Costing) in SCM environment using version 4.7.
• Writing functional specifications for ABAP programmers.
• Master data conversion planning, verification and error identification.
• Heavy experience in the CO module with a focus on product cost, profit center accounting, cost center accounting, and integration of CO with other modules such as MM, PP, and SD.
• Product Costing including fully absorbed planning and costing model. Integrated Activity Based Costing design oftemplates, business processes and structures, activity types and SKF’s, plan and actual allocation cycles.
• SECATT preparation for master data scripts.
• Creation of master data including assessments, distributions, cost centers, profit centers, SCMA’s for periodend close routines.
• Implementation, prototyping, testing, analysis, of all business requirements and designs.
• Liaison for all security issues between CO team and Basis.

Karl Schmidt Unisia                                                                                          Applications Administrator           

May 2004 – August 2005

• Team member in the implementation, testing, and training for the SAP upgrade from 4.6Bto 4.7 Enterprise platform.
• Responsible for supporting the Accounting department for both the FI and CO modules.
• Accounts Payable including House banks, check lots, reason codes, payment terms and methods,
• payment program Configuration, and paying company code data.
• Performed all month end transactions including WIP, variances, and settlement
•  Responsible for annual standard cost roll preparation for BCF product line using KP06, KP26, KP46,
• Allocation transactions, cost splitting, and price calculation. Preparation and updates to costing sheets.
• Provide system information and configuration changes as required for the Accounting group.
• SECATT preparation for master data scripts.

Self-Employed                                                                                                                    Consultant                                           

October  2002 – May 2004             

 Small business accounting software installation, training, consulting, automation and tax preparation.

 Pierburg,Inc        

Contract Consultant                                         

March  2002- September 2002

• Worked with International automotive company and their consultants to design, implement, test, and train   
• Employees on use of SAP CO module. Established and entered all Product Cost Planning requirements and  data.
• Automated month end processes using a variety of MIS skills including ABAP Query workbench, SE16,
•  Monarch, Access and  Excel

Solutia, Inc.                                                                                                          Senior Cost Analyst                          

2000-November 2001

·    Prepared actual vs. standard cost analysis, yield analysis, and analysis of variances & forecasting.

·   100M budget and annual standard cost roll preparation for BCF product line using KP06, KP26, KP46,

     allocation transactions, cost splitting, and price calculation.

·   Performed all month end transactions including WIP, variances, and settlement

·   Identification of system implementation errors

     Identified BOM yield errors resulting in improvements in SAP that saved the company 500k inventory shrink.

Cooper Power Systems                                                                                     Cost Accountant

1990 – 2000

Used product cost transactions to determine activity rates and cost over 21,000 materials.

Managed inventory balances and administered compliance to established internal control policies.

Developed conversion plan and migrated master data in conjunction with implementation of AP R3 software.

Establish and analyze annual standard cost roll preparation for BCF product line using KP06,   KP26, P46,

allocation transactions, cost splitting, and price calculation.

Settle and analyze production orders.  Monitor variances to budget and recommend methods to improve      profitability.

Instrumental in implementation of finished goods production to sales comparisons recognizing annual savings of $40,000 due to elimination of historical inventory shrinkage.

Coordinate, audit and analyze annual physical inventory and WIP inventories.

Administered company internal control policies relative to areas of responsibility.

Used SE16 and other transactions to determine data needed for reports for Accounting and other departments.