Business Intelligence Sql Server
Resume:
Guillaume Alain Porquet
********@*****.***
www.linkedin.com/in/gaporquet
Professional Experience
Data Specialist / Architect
Kimball International / Techwave - June 2024 – Current
• Architect CRM Salesforce data end-to-end solutions, ensuring seamless data integration.
• Lead the design optimizing data retrieval and accessibility of SAP Sales and Distribution into a Business Intelligence Self-Service Data Lake
• Conduct business analysis to assess data needs, translating requirements into pipeline solutions using Microsoft SQL Server Analysis Services (SSAS).
• Develop and manage data pipelining with creation of DataMarts using Microsoft SQL Server Analysis Services (SSAS) for high-performance analytics.
• Build Power BI for advanced data visualization and reporting, supporting decision-making with real-time insights and interactive dashboards. SAP Finance Data Lead
Johnson & Johnson / Techwave - July 2023 – June 2024, Secaucus, NJ
• Collaborated with Business Process Owners to gather requirements, translate them into technical strategies, and manage BW4HANA project implementations.
• Analyzed BW interfaces, proposed optimizations, and led data integration and system performance improvements, reducing data processing time by 20%.
• Created technical documentation for central finance and managed the development of BW4HANA solutions with AFO and SAC reporting layers.
• Implemented Group reporting and CIP reports, tracked construction projects, and managed financial reporting to ensure accuracy and compliance.
• Designed and deployed bridging reports between ledgers, leading to over 100 hours saved monthly in reconciliation efforts.
• Specialized in S/4HANA financial interfaces and migration with BW (I2C, A2R, Project Accounting), managing integration with ABAP customization.
•Conducted detailed business analysis to streamline Group reporting, CIP reports, and construction project tracking, ensuring compliance and data accuracy. Business Intelligence Lead
Variscale Services and Engineering Inc - May 2022 – July 2023, Secaucus, NJ
• Spearheaded the management of two concurrent BI projects, optimizing processes, improving user engagement, and achieving significant cost savings.
• Enhanced BI environments using ETL/ELT tools, leading to better data consumption and analysis across projects.
• Collaborated with project team members to ensure data integrity and availability, meeting corporate, project, and personal objectives.
• Defined BI design strategies, product specifications, development schedules, and user expectations, resulting in improved business outcomes.
• Provided actionable recommendations based on data analysis, implementing changes that improved performance and software reliability.
• Developed detailed specifications for data design, interface, and enterprise data stage, ensuring seamless integration and optimal performance.
• Leveraged Tableau Prep and Microsoft Power BI to cleanse, model, and visualize data, improving data accuracy by 40%.
Principal Consultant - Business and Data Manager
Cognizant Technology Solutions - September 2019 - March 2022
• Managed two BI projects for SealedAir and PSEG as a business analyst and project manager, achieving project goals within budget and timeline using BO and MDG.
• Analyzed and translated business requirements into technical specifications, optimizing warehouse efficiency and productivity.
• Developed a workplan for SAP to AWS data integration, ensuring seamless data migration and SAP4HANA cloud reporting performance.
• Authored UAT test scripts and test plans pre- and post-go-live, reducing risks and ensuring data quality.
• Coordinated stakeholder communication, project scope, resource allocation, and cost management as project manager, delivering projects on time. Business Lead
Sysco Food Corp / FoQus Consulting - August 2017 - February 2019
• Led SAP integration architecture from France to the US as a business analyst, including SAP S/4HANA cloud reporting, ensuring seamless data flow.
• Conducted SAP EPM BPC and BW BPS implementation, completing requirements gathering and analysis on time and within budget.
• Orchestrated integration of 12 SAP servers from France to the US, reducing data redundancy by 30% and enabling efficient data migration.
• Delivered training for 35 French-speaking users on Analysis for Office (AO), including English-French translations for executive users.
• Implemented a reporting architecture with an onshore/offshore model, reducing development costs by 25% through efficient resource management. SAP Developer / Analyst
IBM - October 2011 - March 2015
• Led SAP BW projects for five major clients, including EY, Keurig, Abbvie Pharmaceutical, and Campbell Soup, improving data accuracy and system efficiency.
• Gathered business requirements and implemented custom SAP solutions across APO, SD, FICO, MM, and BW_IP modules.
• Optimized BW systems by enhancing query performance through aggregation and indexing, improving data retrieval speed and reporting capabilities.
• Automated monthly reporting tasks using ABAP code, reducing manual data entry and processing times by 40%.
SAP Consultant
Hitachi Consulting - April 2015 - March 2017
• Managed implementations as a business analyst and project lead, supporting clients like Buckman Laboratories and Tyson Food in SAP module integration.
• Oversaw data migration for a client acquisition, ensuring efficient transition using SAP Data Services (BODS).
• Coordinated an onshore/offshore team, delivering over 30 reports in Finance and Sales, achieving a 45% budget reduction.
• Designed dashboards and reports, supporting client needs in sales, finance, and transportation.
SAP Developer
Capgemini / Coca Cola - October 2009 - July 2011
• Led SAP BI internal billing projects, improving financial reporting accuracy and billing processes.
• Collaborated with teams to identify and implement process improvements, reducing errors and enhancing data flow.
• Developed and analyzed financial reports using SAP BW, ensuring timely and accurate data delivery for stakeholders.
SAP Developer
KBTS / Heatcraft Refrigerator - August 2006 - March 2008
• Analyzed legacy SD module and identified migration requirements to SAP, ensuring smooth transition and adherence to budget.
• Developed migration strategy and collaborated with teams to ensure successful implementation, meeting project deadlines.
Education
Computer Science
Georgia State University • US, Ga, Atlanta • 2003 • 2.99 Certifications
SAP Netweaver Business Warehouse
SAP • 2011
Datawarehouse / Business Intelligence / Data Architecture Skills
• Technical Skills:
AWS, Big Query, DataBase, Data Warehouse, Data Lake, SQL Scripts, Data Migration, Data Services, C / C++, Java, ABAP,
Object Oriented, Tableau, Jira, Business Intelligence, Data Analysis, Functional Analyst, Technical Developer, Project Management,
Scrum, SAP Consultant, SAP HANA, SAP BW, SAP BO, Data Management, ETL, PowerBI, SQL, Master Data, Data Stewardship, SAP WM,
SAP SD, SAP FICO, IT Consulting, Qlik, Python, Digitalization, ERP Strategies.
• Soft Skills:
Managed Projects, Business Analyst, Liaison, Coordinating, Responsibility, Project Delivery, Milestones, and Completion.
Contact this candidate