Joy Sweeney Email & Phone Number

Lynnwood, Washington, United States

Weybridge, United Kingdom

• Designed and developed RPA processes for Sony Global Finance Accounting bringing together elements from SAP, Blue Prism 6, Excel, VBA & Process Runner.
• Liaised with global finance operations teams to automate debit note and other O2C processes.
• End-to-end process design & development including documentation, SIT & UAT.
• Use of SAP automation including Process Runner and dynamic spying.
• Organized training for remote teams and mentored RPA developers in the business.
• Support for existing automation processes, liaison with offshore teams on troubleshooting and debugging.

London, United Kingdom

Designed a packaging information database for all finished products. The responsibilities included gathering stakeholder requirements, designing the database structure and deploying the database into production, then linking the database to the team's master data and designing reporting capabilities. Designed and building reports showing sales and forecast.

London, United Kingdom

• Prepared quarterly global consolidated consumer products sales & forecasting report. Data was collected and consolidated from multiple SAP BI reports and Qlik as well as from user input from the 60 Consumer Health.
• Worked with supply planning managers to automate an open order book report using VBA to bring together elements from SAP BI, Qlik, and user inputs.
• Collected, validated and consolidated SKU and manufacturing formulation data to optimize stock holding.

London, United Kingdom

• Created Global Stockout/Low Stock report combining information from GSK SOLS application, SAP and user input and legacy applications. Worked with supply planning managers and data teams from both London and Nyon.
• Created automated reports and advised on data quality for Global 'On Time / In Full' sales reporting. Worked with Global Supply Chain Issue Management and supply chain analysts to create and harmonize information from.
• Created a robust and standardized template for capturing 'On Time / In Full' sales data to replace the previous process of 60 markets each sending weekly data in different formats and with different levels of data.

London, United Kingdom

• Enabled management to make decisions through supply of reliable reports generated from complete and accurate data.
• Extracted data from systems -12,000 SKUs. Worked with supply planners to clean / append to ensure correct information for each SKU. Formatted the data for upload.
• Worked to raise ticket requests, monitor progress, validate finished product.
• Designed and developed insightful management reports using SAP and BI reporting tools to drive better decisions in production volumes, reserve stock levels and marketing activities.
• Worked with stakeholders to improve ease of use and reliability of the data.
• Worked across teams to automate and streamline reporting processes.

Kingston Upon Thames, United Kingdom

• Designed and implemented insightful KPIs for management from large volumes of call center data.
• Applied advanced excel skills and Visual Basic for Applications knowledge (VBA) to generate automated and customized reporting of these KPIs.

New York City

• Managed content for Footlocker's Extranet site (used by 3rd party construction companies for new Footlocker store builds).
• Worked with multiple parties both internal and external to ensure the extranet site content was complete, accurate & available.
• Demonstrated attention to detail and an ability to meet tight deadlines.

Cranbury, NJ

• Designed and operated an effective merchandise replenishment system. My tasks included preparing SKU data using MS Excel for migration from a legacy system to a new ERP system.
• Worked with 3rd party vendors, warehousing and store managers to understand their stock reporting and order fulfilment needs and to help ensure that Utrecht minimized its working capital.
• Main contact point for external auditors on stock matters and I worked with all levels of management using data to help improve inventory management.