Michael Snodgrass
******************@*****.***
Phone: 312-***-**** 2848 N. Sawyer Ave.
Chicago, IL 60618
* *****’ experience with Oracle EBS (11i, R12.1, and R12.1.3); AP/ GL/ AR/ iProcurement/ iSupplier/ Cash
SKILLS
Management/ Purchasing/ Imaging and Process Management/ UPK Implementation and Tutorial development
Business Requirements and Process Design gathering and documentation (SDLC) including, but not limited to,
EBS integrated Oracle module extensions.
Database Reporting - KPI and Dashboard development; Advanced SQL analysis/ Oracle BI Discoverer
Administrator 10g / Oracle BI (OBIEE) 10g and 11g
EDI P2P Vendor on-boarding and Implementation Project Management; Documents - 850, 855, 810 and 820
Banking Product Project Management and Interface Implementations
o ACH/BAI2
o Procurement Card - POS and Corporate “Ghost” Accounts
Advanced skills with MS Excel / VBA, MS Office Suite, Visio – Process Flow and Virtual Architecture Diagrams
Purdue University
EDUCATION
B.S., Business Management w/ a minor in Marketing
Senior Business Analyst, Forsythe Technology, Inc. 06/12-05/13
EXPERIENCE
Subject Matter Expert for Oracle EBS Financials and Financial Solutions
o Member of Forsythe’s Oracle e-Business Application team. My primary focus was to work closely
with business leads across the organization to identify process improvement opportunities and drive
enhancements that would deliver efficiencies over existing business practices.
o Resolved multiple longstanding (6+ month) accounting and reconciliation issues within my first 2
months of employment reducing the amount of time of period close.
o Acted as Lead Business Analyst for AR/GL/Cash Applications modules and bank statement
reconciliation interfaces for upgrade of Oracle EBS release from R11.5.10 to R12.1.3.
ITIL lead for EBS
o Supported analysis and resolution of level 2 support requests. Documented resolution
steps/workarounds, categorized issues for future reference and identified the need to escalate/identify
as potential process changes and/or as recurring problems to coordinate and resolve.
o Lead Change Management for Financial Quarterly Release Projects. Worked with business leads
coordinating AS-IS and Future State as well as Scope and Solution Requirements documentation. Met
with IT stakeholders (Front End/Interface Developers/DBA’s) to determine time and resource
allocations needed to deliver the solution within the project timeline. Managed the project from
development through unit testing, user acceptance testing (UAT), implementation, and post -
implementation analysis/stabilization. Aided in the training/onboarding of these new solutions with the
user population.
Oracle Multi-User UPK Pro 11.1 Implementation
o Held sessions with responsible stakeholders on the business side to understand their requirements and
provide content publication and administration options, and asses potential to leverage our existing
enterprise document hosting product to streamline user/group access rights to content.
o Coordinated Apps server and Database Infrastructure requirements and architecture diagrams to assess
our current capacity.
o Document implementation steps and issues as a means to expedite issues with our internal Operations
team and our 3rd party offsite DBA’s
Business Systems Analyst, Chicago Public Schools 04/08-06/12
Subject Matter Expert for Oracle EBS Financials
o Analyzed and identified system issues within EBS and documentation of bug scenarios to expedite the
turnaround of Oracle SRs and resolution.
o Addressed module configurations and accounting setups in sub-ledgers and General Ledger; security
and cross validation rules, etc. to ensure the quality of interfaced accounting entries and minimize
manual reclassification entries that would delay period close.
Project Managed EDI Procure to Pay implementations
o Targeted vendors of the highest document volume and greatest strain on our AP Entry Clerks.
o On-boarded 4 new vendors resulting in the automation of an additional 25% of our AP invoice line
volume.
o Managed and supported our Vendor EDI Invoice population which constituted 40% of our AP invoice
line volume.
o Coordinated with vendors to resolve and reduce EDI Invoice exception scenarios in addition to billing,
punch out, and catalog issues.
Coordinated and Implemented seeded and extended application and interface design
o Gathered and documented Business/Technical requirements, Unit/UAT testing scenarios, and
implementation approach with internal IT leads, business users, and vendors to develop custom Oracle
module extensions and interfaces streamline processes with high overhead in human capital.
o Developed requirements and coordinated transmission testing/process validation for outbound
NACHA inbound BAI2 Cash Management Automated Reconciliation process with multiple major
banking institutions.
Created self-service learning tutorials via Oracle UPK and provided End User training/ongoing
application support.
Organized with EBS Financials end users to document business requirements, system testing scenarios,
and issue resolution for upgrades and change requests.
o HP Quality Center Software used for major upgrades/patches.
Acted in role of voting board member and author of RFP Technology Scope of Services for Procurement
Card and Consolidated Banking vendor contract award recommendations.
o Upon contract award I continued in the role of Project Manager for the business/technical transition
and implementation of these new vendor products/business processes and their interfaces with our
ERP.
Data Analyst, The NPD Group 5/07-03/08
Administrated the activity scheduling and production of client databases; delivered on time, and with one
hundred percent accuracy, every period of release.
Tested design changes to our online panelist survey. Coordinated with product management team in
assessing the data impact of survey modifications.
Data and Information Manager, JCC’s of Chicago 01/05-05/07
Responsible for the creation and management of organization’s client and accounting databases,
producing quarterly and ad-hoc reports identifying changing trends in the client population.
Implemented an internal accounting / inventory system to closely track the distribution of goods and
services across organizational programs.