Project Manager Business Intelligence
Resume:
PATRICK E AZRIA
Fort Lauderdale, FL *****
******@*******.***
EXECUTIVE SUMMARY
IT Executive/Solution Architect/Project Manager/Application Consultant with broad technical and functional expertise. Possess a variety of analytical, researching, problem-solving and soft skills with a history of achieving results.
EXPERTISE
Business Intelligence/Data Modeling/Reporting/Budgeting, Sales (billing, pricing, contracts, order management, master data, CRM), Purchasing (material management and Logistics), Finance (accounting, budgeting, financial reporting), user Interface and systems integration.
TECHNICAL EXPERTISE
SAP Core Modules (Sales & Distribution, Material Management, Finance), IS Oil
Business Intelligence (HANA Studio, BW, BW-Modeling Tools, IP-Integrated Planning, BPC Embedded, SEM-BPS)
Reporting (Analysis for Office, Business Explorer, BEx Analyzer, Lumira, Crystal Reports, ABAP Queries, Power BI).
INDUSTRIES
Oil & Gas, Life Sciences, Entertainment, Consumer Products, Insurance, Chemicals, Textile, Electronics, Public Sector, Retail, Software, Utility.
CLIENTS
Sony Music Entertainment, Warner Bros, AIG SunAmerica, Pasteur Merieux, Island Energy Services, Kellogg’s, Amtrak, City of San Diego, Nissan, Par Pacific Holding, Tesoro Petroleum, Celanese, Black & Decker, Abbott Medical Optics, Degussa, Southern California Edison, NBC Universal, SAP America.
CERTIFICATIONS
2012 – SAP HANA Studio Data Modeling/Solution Manager
2006 – SAP SEM-BPS (Business Planning and Simulation)
1998 – SAP SD (Sales & Distribution)
EDUCATION
1992-1995: Master’s in Sciences of Management (Marseille’s Business School)
1990-1992: Degree in International Business (Marseille, France)
OTHER
Citizenship: US & FRANCE
Languages: English, French, Spanish, Italian
EXPERIENCE
SONY MUSIC ENTERTAINMENT – 08/2018-07/2020
Financial Planning Solution Architect/Project Manager (London, Miami)
I extended the UK existing Financial Planning Model to Latin America (12 more countries). Collected requirements from the users, configured Integrated Planning and performed the end user training.
Solution Architect/Planning Technical Lead (London, Miami, Paris, New York)
Together with the BW team, I redesigned and configured from scratch a new Global Financial Planning solution (BPC Embedded/Integrated Planning/HANA Studio).
The solution was successfully deployed in over 50 countries for 200 users and dramatically improved the financial planning process worldwide.
Trained end-users in France, UK, US and LATAM and supported users.
ISLAND ENERGY SERVICES (Hawaii) – 01/2017-01/2018
As the Business Intelligence Solution Architect and Team Lead, I lead the development efforts and defined the BI landscape and BI strategy for the company (HANA Studio, BW, Integrated Planning). Deployed approximately 50 datasets used by over 30 users. I also, collected users’ requirements, coordinated user acceptance testing, production support and users training.
Examples of datasets: regulatory reports, financial statements, accounting, billing, inventory, third party systems reporting, master data, inventory reconciliations, financial budgeting and planning.
Configured and lead development team for TMW (Rack Automation System) to automate the creation of fuel rack terminal transactions in SAP.
This solution automates the creation of transactions corresponding to 90,000 bills of lading/year.
PAR PACIFIC HOLDING (Hawaii, Texas) – 05/2014-12/2016:
Solution Architect/Project Manager
Over a period of 2.5 years, I assisted Par Pacific in numerous critical projects following the acquisition of the Hawaiian refinery: New SAP implementation, Business Acquisition, Upgrades, Special projects.
Process Optimization: Retail, Billing & Pricing, Contracts,
Rack Automation System Trained and Lead off-shore team for daily tasks.
Created and coordinated deployment of daily monitoring reports.
Collected requirements and coordinated deployment of company wise solution for Regulatory Reports (dozens of reports submitted periodically)
Configured and lead development team for TMW solution (Rack Automation System). This solution automates the creation of transactions corresponding to 150,000 bills of lading/year.
Delivered various SAP trainings.
AIG SUNAMERICA (California) – 04/2012-03/2013 & 10/2007-02/2009
Planning Solution Architect & BI Consultant
Audited and redesigned the existing financial planning models.
This reduced dramatically the periodic maintenance, data inconsistency problems and removed cumbersome ABAP code that was a risk factor for the company.
Designed and implemented the Tax Provision solution for the Tax Department (BW-Integrated Planning).
This solution dramatically simplified the creation of quarterly tax provision workbooks combining actual data and manual entries. It enabled the use of one single workbook for multiple legal entities, quarters, versions through the usage of a prompt.
Configured BW in various BW projects/upgrades.
Delivered various trainings (Business Objects WEBI, IDT, Explorer, Analysis for Office, BPC).
SAP AMERICA (USA, Germany) – 08/2010-03/2012
Business Planning Consultant
Reviewed the planning solution and provided technical recommendations (Sales volumes for Kellogg’s) and Sales Volumes Planning (Nissan).
Built a Sales Forecasting Model (BW-Integrated Planning and Web Application Designer) for SAP America.
Implemented the PBF solution (Public Budget Formulation) for City of San Diego and Amtrak.
WARNER BROS, California – 07/2009-02/2010
As a Planning Consultant, I documented the existing planning Tax Optimization Tool and provided alternative technical designs.
ABBOTT MEDICAL OPTICS, California – 05/2009-06/2009 & 06/2010-07/2010
As a Financial Planning Consultant, I configured, maintained and optimized the existing BPS solution.
NBC UNIVERSAL, California – 02/2007-06/2007
As a Financial Planning Consultant, I configured, maintained and optimized the existing BPS solution.
TESORO PETROLEUM, Texas – 06/2004-03/2006
As a Financial Planning and Business Intelligence Specialist, I configured, maintained and optimized the existing BPS and BW solutions.
VARIOUS COMPANIES – 06/1998-04/2004
SAP Sales & Distribution/Material management Technical Lead
Celanese in Dallas (Chemicals), Tesoro Petroleum in San Antonio (Oil), Degussa/Evonik Industries AG in Paris (Construction Chemicals), DMC In Lille (Textile), Sanofi Pasteur in Lyon and Rome (Pharmaceuticals), Black & Decker in Lyon and Milan (Electronics), Thomson Multimedia in Paris (Electronics)
.
Contact this candidate