Patrick Northcraft Email & Phone Number

Toledo, Oh, Us

Toledo, Oh, Us

San Francisco, California, Us

- Leveraged Groovy scripting to automate both day-to-day and administrative tasks, with processes seeing up to 70,00% runtime improvements- Integrated new models, such as Weighted Rule of 40 Forecasting and Reporting (SaaS KPI), into the EPM Cloud model- Coordinated OCI Gen2 migration and migration to Enterprise licensing, and managed cutovers to both Redwood and Forms 2.0- Improved EPM Cloud application performance by analyzing cube distributions/structures and applying changes that maintain the core functional uses, but more efficiently- Aided in facilitating Enterprise Data Management go-live for EPM Cloud and Fusion ERP- Implemented Narrative Reporting deployment for standardized C-Suite/S-Team reporting- Analyzed and standardized datasets for Oracle Analytics Cloud (OAC) deployments- Built and maintained multiple OAC dashboards/workbooks and implemented new features upon release- Architected and developed a complete rebuild of our PBCS instance to move from a corporate consolidation tool to an operational planning model, complete with line-item, driver based forecasting, position-based workforce planning, and consolidations/allocations in an ASO cube- Architected and developed a Freeform application to manage daily revenue ARR forecasting for short-term forecasts based on various time-series trailing averages - Received CFO Org "They Win, We Win" award for building new functionality that aided end users- Saved over 2,000 working hours across FP&A by streamlining system processes and adding new functionality- Developed complex Alteryx workflows (ETL tool) leveraging API and database connections to create almost-real time data warehouse updates

Philadelphia, Pennsylvania, Us

- Administer massive Oracle EPBCS environment for over 3,000 end users- Designed and implemented a new standalone cube and business process for a new line of business within a large existing environment- Create a streamlined end user interface of forms, dashboards, and navigation flows to facilitate simple end user data entry that allows for entire financial models to be calculated without extra interaction- Leverage Groovy Business Rule capabilities to allow for optimized calculation scope and execution based on various business requirements, reducing calculation runtimes by up to 90%- Share knowledge and educate peers on team through regular “show-and-tells” along with various LinkedIn blog posts- Coordinate and implement technical and functional overhauls for existing models when organizational needs arose- Coordinate and share knowledge regarding latest Oracle patches and upcoming functionality- Leverage EPM Automate scripting to streamline monthly maintenance processes- Within two weeks of starting, fully redesigned a business unit's model to meet new functional requirements while also optimizing technical processing- Optimize performance of standard BSO, hybrid BSO, and ASO cubes by following best practices and applying through trial and error- Experience managing and modifying Oracle EPBCS Planning modules for business-specific requirements (Financials, Workforce, Capital)

Austin, Texas, Us

- Aid in designing and implementing customer support model for the State & Local Government business unit- Collaborate with Product Management and Development to ensure creation of a minimum viable product- Engage with multiple NetSuite professionals for training on NetSuite Planning & Budgeting product

Chicago, Il, Us

- Oracle 2021 Planning Specialist Certified- Leveraged knowledge of Oracle EPM (EPBCS) toolset to resolve client pain points and streamline business processes- Leveraged knowing of Oracle middleware to handle large data interfaces to and from Oracle EPM tools- Optimized EPM application performance through robust understanding of database and scripting processes- Managed and served as lead developer on process optimization effort at a Fortune 50 Oil & Gas company- Served as lead developer and led requirements sessions on a major foreign government sales cycle- Aided in college recruitment, internal knowledge sharing workshops, and building process accelerators- Gained proficiency in creation and maintenance of all EPM Cloud/EPBCS artifact types, including Web Forms, Business Rules/Calc Scripts/Groovy, Data Management, EPRCS/Narrative Reporting, Financial/Managerial Reporting, Smart View, and LCMs- Configured and Implemented EPM Cloud/EPBCS "modules" for Workforce, Capital, Projects, and Financials

Findlay, Ohio, Us

- Leverage various technological solutions to optimize marketing decision making and maximize customer value- Work with large SQL datasets in Tableau to identify trends in customer loyalty program- Technically promoted to this role, but did not fully transition

Findlay, Ohio, Us

- Organize and serve on business technical lead on upgrade from Hyperion Planning 11.1.2.4 to 11.2.4- Perform analysis and identify areas of optimization for Hybrid BSO/ASO Essbase to ensure best user experience and optimal technical resource allocation.- Administer financial forecasting and budgeting system, Hyperion Planning, through managing SQL Server databases and Essbase cubes• Build and optimize various user reports, both ad hoc through Smart View and through Financial Reporting- Utilize business rules, rulesets, scripts, menus, and planning forms to build out a 24-month rolling forecast and a 3-year business plan after a major acquisition• Leverage MAXL, batch, and Jython scripting to automate data loads and archiving processes- Leverage understanding of dimension sparsity and calculation script optimization to dramatically reduce processing time for monthly forecasting model, from 45 minutes to 5 minutes- Took Oracle Essbase and Hyperion Planning Virtual training courses- Enhance end user knowledge through one-on-one and group training courses- Gained proficiency in creation and maintenance of all Hyperion Planning artifacts/components, including data forms, business rules, FDMEE, Financial Reporting, Smart View, Shared Services, Essbase Administration Services, Substitution Variables, MaxL and Windows BAT scripts

Findlay, Ohio, Us

Financial Accounting, Global Procurement, Credit and Treasury Support- Coordinate legacy data archive project, with end goal of decommissioning legacy system, saving $4.5MM in annual service fees.- Developed automated means of exporting data from Hyperion Planning and importing into SQL by using a combination of Hyperion Business Rules and other middleware tools.- Designed and developed 7 SAP interfaces, along with 20 back-end automated processes, to feed critical financial data to Hyperion Planning and Budgeting Cloud Solution (PBCS).- Administered and maintained 3 distributed, clustered Windows 2012 server environments (Dev, QA, Production) for our Hyperion application suite.- Utilize Tableau as a data visualization and analytics tool to build dashboards for credit monitors to better understand customer trends.- Gained functional and technical knowledge regarding SAP BW on HANA through building BEx queries and building technical specifications for multiple process chains and ABAP program variants.

Toledo, Oh, Us

Findlay, Ohio, Us

- Received Lean Six Sigma Green Belt Training and initiated a project to analyze dock performance, with an estimated savings of over $1MM- Integrated current team reporting and dashboards with new Tableau visualization tools to streamline managerial updates and ease information flow- Developed production database utilizing SQL and stored procedures to house and manipulate performance commitment data for Tableau visualization integration

- Familiarize with concepts/best practices of web site design through independent research- Develop an ASP.NET MVC web application from scratch, utilizing C#, Razor, jQuery, HTML5, CSS3, and SQL- Built theoretical online member tracking system for a student organization to keep record of community service

Toledo, Oh, Us

- Evaluate coursework of over 40 individuals- Impart knowledge of professional skills and development to students- Coordinate with instructor to complete any supplemental tasks as needed

- Impress importance of discipline and integrity on a band of 60 students- Empower individual growth and expression through practice and diligence- Emphasize the skill of turning individual success into superb team execution.

Findlay, Ohio, Us

- Utilized SQL and VBA/macros to consolidate annual Disaster Recovery test results- Administered and controlled thousands of SAP security roles for a Fortune 25 company- Introduced new testing automation system to streamline system integration for 200+ test cases

- Worked in MS Access and Oracle SQL*PLUS and SQL Developer- Developed a database system individually for UT College of Communication and the Arts Music Library as an Honors term project- Demonstrated teamwork by effectively managing a team of peers to build a personnel tracking system for the Gamma Eta Chapter of Alpha Kappa Psi as a term project

Bentonville, Arkansas, Us

- Manage a fast and dynamic shopping environment- Tender transactions with various mediums of currency- Efficiently cash out hundreds of customers on a daily basis

Riverside, California, Us

- Increase written communication effectiveness and skills- Emphasize and grows my personal interest in mobile development- Gain up to date knowledge on technological advances and developments

- Worked in a high-speed, dynamic environment- Experienced working with a tight-knit group of passionate people- Managed the environment of the professional chefs

Master Of Applied Business Analytics

Bachelor Of Business Administration (Bba), Management Information Systems, General

Instrumental Music Minor, Trumpet

High School/Secondary Diplomas And Certificates