| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateTrevorPenickStreet Address Regency LanePHONE NUMBER AVAILABLEEMAIL AVAILABLELINKEDIN LINK AVAILABLESr. SAP Analyst with 25 years of experience in implementations and go-live support. IT and Business expertise in global finance and controlling, financial solution delivery, global and local accounting/controlling, and BW Query design, agile development, business planning, financial data management, data analytics, and user training. Specialized focus in digital and accounting forensics, incident management, threat hunting and applicable framework usage/development.SkillsProgramming languages: SAP ABAP, Python, SQL, PHP, HTML, BashDatabases: MS Access, SQL, SQLite, ADB, Snowflake, S4/HanaOffice Tools: MS Word, Excel, MS Project, MS Outlook, MS Visio, JIRA, HP-ALM, HP Solution Manager, Workday, Cornerstone, ServiceNow, SAP Business Explorer, SAP Business Objects Analyzer, Microsoft Power BI, AzureMethodologies: Agile Scrum, Six Sigma, Continuous Improvement, OSINT, Project Management, CRM, SAP ActivateEnvironment: SAP R/3, ECC, ERP, Net Weaver, SAP Business One, SAP S/4HANA, SAP BW, SAP BW 2.0, SAP Fiori, SAP UI5, Tableau, Ubuntu Linux, Kali-Linux, Parrot OS, Metasploit, MITRE Att&CKSAP Module Expertise FICO, SD/LE, IM/WM, MM, PP, QM, ECC, UI5, S/4HANAExperience5/2023 9/2023Lead SAP Analyst - AmericasThe Maag GroupProject Integration manager set the ground work for the migration of newly acquired company SAP Activate MethodologySupported existing SAP Business One instance as we made preparations, both technical and process oriented, for the migration to S/4Hana.Collected requirements from all workstreams via deep dives into all day-to-day activities across all workstreams including E2P, PTP, RTR, and PTP. Within these workstreams modules of ECC and S/4Hana such as Integrated Business Planning (IBT), Production Planning/Detailed Scheduling (PP/DS), Inventory and Warehouse Management, Sales and Distribution, Finance, and Materials Management to name a few; more importantly, I mapped out all integration points between them all.Provided insight into existing SAP functionality the client wasnt aware of due to lack of training.Travelled to Germany for IT Leadership conference, and then on to Germany and Italy to assess process gaps that would need to be closed globally as the journey to S/4Hana progressed1/2023 4/2023SAP Project Manager Implementations/MigrationsGyansysProject Manager ticket backlog/triageSAP Activate Methodology10/2022 1/2023Sr. Business Analyst finance/logistics/operationsAmerisource Bergen / VenteraCollected requirements and developed/enhanced power BI finance dashboards used by sales solutions analysts to make business decisions.created functional/technical specs for aforementioned solutionswrote test scripts and engaged business users during SAT/UAT sessionsintroduced Python and r predictive analytic functionalities for business specific metrics in power bicoordinated data modelling upgrades to power bi pulling information from multiple data sources that incorporated current best practices for performance and sustainabilityagile scrum development environment basedSystemss4 Hana (Fi/Co, SD/LE)s4/Hana BW 2.oMicrosoft Power Biworkdayservice nowJiraMS teams/outlook/SharePoint11/2021 8/2022Sr. Business/Sytems Analyst (III)Nutrien Ag Solutionscompiled fi reporting catalog for s4/Hana integrationcreated system landscape dashboard in PowerBI that enabled client to understand key integration points for reporting and analytics.worked on co-existence team to ensure harmonization between branches going live on sap and those on legacy systems as it pertains to fi/co reporting, as well as SAP ECC transactional config/functionality including interdependencies between co-existing solutions like High-Radius for AR processing. This included defining reason codes for over/under payment. I was responsible for creating a reason code that could be used by the lockbox via a reason-code-conversion-version.wrote sop and user stories for new s4/Hana branch level users.headed up requirements gathering for reporting needs in the following workstreams: r2r, s2d, p2p, f2p, marketing (sales and analytics), and customer loan programs. (SAP CML)9/2019 6/2021Global Business Process SpecialistRoche Diagnostics, Indianapolis, IN12 SAP S/4 Hana lifecycle implementation(s) (Gloire for Americas)oProject managementFit-Gap and requirements gatheringResource budgeting/reportingoFICO ReportingManaged/coordinated SAT/UATDeveloped effective FI/CO User TrainingoPart of the leadership committee for go/no-go deployment decisions at all stages of implementation my input weighed heavily in such decisions.oOn/off-site support for Hyper-careTableau (SAP BW Data Source)SAP FI/CO BW Query Designer (Business Objects Analyzer and Business Explorer)Company Level FI/CO Data Management (R/3, S/4 Hana, and BW)FI/CO Global Reporting (Consolidation and EOM Accounting)Requirements gathering from finance business users for BW Financial report development/enhancement.Translating report functional specifications into requirement papers for ITConducting International Training NALA/EMEA/APACBW FI/CO Reporting and SAP R/3 + S/4 HANAHeavy Accounting Analysis and Report and transactional development across all of the following:oActuals CostingoCost Center Accounting/PlanningoInternal OrdersoProduct Cost PlanningoSales and Business StatementsoFixed AssetsoGeneral LegeroAccounts Payable/ReceivablesoFinancial Supply Chain ManagementoInstrument PlacementoProduction PlanningoProject ManagementBest Practice Sales Planning data provisioning for 3, 5 and 10 year FI planningCreated custom Business Planning SolutionsCreated custom EOM consolidation Solutions.Was in charge of delivering and customizing FI diagnostic information solutions for NAM/LATAMSupported the planning/Submission process (both in the business and IT spaces) for:oCapital Expenditures (Depreciation/PP&E)oProfit and Loss (planning and adjustments)oNet Operating AssetsoCost of Goods Sold (Price Planning/Service Planning/Regent Planning)oCost CenterSales Plan (multiple sales planning types i.e. Zero-based/Historic/Linear Growth, Top Down, etc)11/2015 9/2019Sr. ERP Analyst - Financial Application SolutionsRoche Diagnostics, Indianapolis INFinancial Applications Supported:oglobal consolidated reporting/planning,olocal level company FI reporting,oGRRP (research/dev project cost planning)oSales/Business PlanningSAP Business Warehouse (BW)Local level FI reporting data provisioning and supportDiagnostic Information Systems Global market level FI reporting data provisioning4/2014 11/2015Sr. SAP Consultant IM/WM EWM/WMSRoche Diagnostics, Indianapolis IN1-3rd level technical support for IM/WM (+MM/SD) SAP Modules as well as supporting S4/Hana Fit-Gap management, BW reporting11/2012 4/2014SME Systems Analyst SAP SD/OTC/LE/PM/FiCo/APO/QMCaterpillar Inc., Peoria ILSAP Data MigrationSource to Target mapping, Data Cleansing/Transformation/Modelling/Business Rule Development and SAT as an SME for the following modules:oD/LEoIM/WMoPPoQMoMMoPMoFI/SCOUAT/05/2012 09/2012Sr. SAP Consultant SD/LEJohnson Controls, Geneva ILPost Go-Live Support (Hypercare)Business Process MappingoPPoSD/LEoIM/WMSD/LE trainingLE Process Trouble-Shooting and Incident resolution05/2007 2/2012Vendor Managed Inventory Analyst / Demand PlannerUnilver North America, Trumble CTEDI/ALE IBM AS400 > SAP ECCoKrogeroFred MeyeroH.E.B.oFrysSAP Query Development05/2006 4/2007SR. Customer Service AnalystUnilever North America, Lisle ILFacilitated monthly Super-Valu, HEB, and Kroger Sales/Finance/CS meetings.Provided critical insight on KPI's, created action items/processes to close gaps.oSAP ECCoAS40008/2002 05/2006Vendor Managed Inventory AnalystUnilever North America, Lisle ILSafewaySchnucksHy-VeeH.E.B.02/2002 08/2002Co-Managed Inventory AnalystUnilever North America, Lisle ILWeekly forecasting for four Wal-Mart Distribution CentersManaging of Unilever inventory presence (regular/promotional events)5/2000 3/2002Customer Service Representative / VMI AnalystUnilever North America, Lisle ILVendor Managed Inventory for Ralphs and Vons Grocery chainsoSAP R/3oAS400oVAX01/1999 - 05/2000Account AdministratorINX International, West Chicago ILDeveloped and managed consignment processing for customer on-sight ink production.Trained colleagues on SAP prior to SAP Go-LivesProvided Pre/Post-Go-Live SAP support to INX branches across the country- SAP R/3Accomplishments2014-2015 - Brought into Roche on long-term contract to backfill in-house support who were moved onto a global SAP harmonization project.Maintained optimal service levels for 2nd/3rd level IM/WM support for all NAM/LATAM for over 20 affiliates who remained on old SAP R/3 Instance.Manually updated ABAP code responsible or communicating between SAP and a local-level labeling software after new key figures were configured in SAP by local IT an issue not captured in fit-gap session on the topic but that disabled the sites ability to ship product.Saved project team weeks of projected (and budgeted) manual set-up of hundreds of warehouse locations by, first doing so in about five minutes using a functionality in the IM/WM module they were unaware of and then training them on how to do so themselves.Was offered permanent role on Global Finance Applications Solutions team as a result of accomplishments in the IM/WM space.2015-2021 Roche Diagnostics FT EmployeePresented new suite of Finance BW reports to Sr. Leadership team after taking over development and promotion of these reports over from project team that was recently disbanded. VP of finance requested to global leadership that I be appointed as the single representative to local level accounting of all global FI Reporting content.Also appointed as FI Application Solutions representative as Information Manager for NAM/LATAM to the BI/BO team to ensure all initiatives at the local level were in alignment or were brought into alignment with global analytics.Assigned to the Gloire for Americas (GfA) SAP Harmonization team to support the FICO Reporting (BW) Stream as BPM responsible for my areas support from Fit-Gap to Post-Go-live support.Created test-scripts and conducted both SAT and UAT sessions for 9 different implementations in the course of the GfA project.Updated and maintained the Local Level Reporting Manual (which used our BW data) which became critical tool for all my FI users in running and reconciling financial reports across all accounting areas.Created a framework of easy to consume work-instructions based on my first years most common incident tickets this frame work (later transformed into a web-based tool) reduced my ticket load by over 80%After two years in role, I was tasked with creating our teams vision/mission statement and roll-out plan and methodology to ensure our team evolved with the division and remained relevant and high-value.Drove the evolution of our training, authorization models, and our overall brandHave conducted onsite training in over eight countries across the globe, including Singapore, Panama, Argentina, Germany and Switzerland.During pandemic adapted training modules and training schedules from on-demand training to monthly offerings covering FI report content/usage and basic/advanced trainings for our front-end applications (BOA/BeX)For the entirety of my time in role, I maintained optimal service levels in covering first level support tickets, solicited new enhancements from users to improve our reports, and advocated for my users to the Change Management team to have such enhancements implemented.Participated in Data Reconciliation Automation Project to ensure data integrity between SAP R/3 and BW across all accounting areas. (AR/AP/FA/GL/Sales/Cost Center) which we then created daily broadcast for IT / Users to investigate.Often brought onto side projects unrelated to finance by IT teams across multiple divisionsIT Security and breach investigations authorization profiles analyzed and refined based on roles and responsibilities.Master Data ManagementOSINT Collected valuable intel, documented and handed over to applicable leadership/legal department for subsequent actionEducationSome CollegeCollege of DuPage Graphic Arts Tech 1998 - 2000University of Phoenix Online Accountancy 2003 2004Languages:German FluentSpanish FluentProfessional ReferencesCraig TacketBPM Transformation & Deployment Lead (Former Director of Financial Shared Services Center)Roche Services and Solutions - Roche Diagnostics Indianapolis, INEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEMartin BanzerApplication Service Champion - Dia Finance Excellence FinExRoche Diagnostics International Ltd Rotkreuz SwitzerlandEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLEStephanie WeinsteinDirector, Finance - Roche Tissue Diagnostics Tucson, AZEmail: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLE |
