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.• Interviewing and hiring, mentoring & training new hires.

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 data for all Consumer market SKUs.

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 markets. The process involved providing user training, liaising with IT to extract data and communicating with markets to ensure data was accurate and complete.• 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, France locations.• 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 many sources including SAP, JDA, and user input. • 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 quality. The deployment of my user template has led to more efficient and reliable service level reporting.

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.• Introduced automated reporting processes using VBA in order to streamline and standardise ways of working.• Undertook system validation and data integrity checks: Flagging up incorrect data and liaising with IT to identify root causes. • Provided ad-hoc reports to management using SAP reporting tools, BI Reports and Supply Chain Data Warehouse tools. • Documentation of 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.