Paula Aiello Email & Phone Number

Lockport, Il, Us

Naperville, Illinois, United States

Data Engineering and Analytics

Rosemont, Illinois, United States

✥ Improved company margins by .35 per case by implementing a pricing strategy and execution system as a core team member for enhancement and implementation of system, contributing to the pricing discovery activities, leading cross-functional teams and selection of 3rd party pricing software through the RFP process✥ Developed SOPs for business processes, refined, and supported third-party and internal developers, and created pricing validation tool.✥ Decreased administrative burden by 10% per week by automating the vendor deviations on contracts process.✥ Increased company revenue by $1,000,000 per year by implementing automated shipping charge system.✥ Drove the organization's Agile transformation by co-designing and delivering comprehensive Agile methodology and Scrum framework training to over 200 IT professionals and incoming interns.✥ Defined the project scope and functional requirements, ensuring alignment and collaboration among stakeholders from various departments to achieve cohesive and unified project outcomes in support of National and Local Sales, Revenue Management and Customer reporting projects.✥ Created vision scope, business process models, functional descriptions, workflow documents, RFI / RFP documents, prototypes, and activity diagrams.✥ Conducted requirements workshops, validated technical designs, and collaborated with QA teams on testing activities.✥ Led business analysis and architecture guild and contributed to Women in Network (WIN) employee resource group through learning / networking events in support of company-wide initiatives.✥ Increased partner satisfaction by supporting leadership of business analysis center of excellence and creating learning opportunities, tools, and templates for team cohesiveness.✥ Enhanced efficiency for independent living and short-term facility customers by developing a comprehensive system to track Key Performance Indicators and delivering detailed reports with actionable recommendations.

Schaumburg, Illinois, United States

✦ Co-lead team on pricing strategy with the Revenue Management department✦ Drove cohesiveness within the Business Analyst function through development of templates, chairing Business Analyst meetings, coordinated training, and mentored new hires. ✦ Integrated legacy systems into PepsiCo - Pepsi Beverages Company, contributing to significant revenue increases and cost reductions. ✦ Led projects that enhanced reporting accuracy, security, and efficiency for sales team. ✦ Increased forecasting capabilities through enhancements of the sales forecasting applications and supporting monthly, quarterly and year end forecasts.✦ Identified and resolved critical data discrepancies in sales forecasts.

Deerfield, Illinois, United States

✱ Supported US and global data warehouses through creation of tables, and SQL processes for data transformation. ✱ Designed data extracts ✱ Created Cognos cubes and customized logistics reports

Schaumburg, Illinois, United States

❈ Supported the ERP system through enhancements, fixes, monthly and year end processing, security and troubleshooting.❈ Led the Y2K compliance project to ensure smooth transition of the ERP system.❈ Onboarded customers on the EDI system.❈ Implemented automated systems to reduce manual processing times and costs, enhancing billing and order processing efficiency. ❈ Collaborated on solution and testing for integration of EDI orders into ERP system.❈ Led the system testing efforts and training of end-users on new systems. ❈ Eliminated consulting costs by quickly mastering systems and creating customized business reports.