Angela McDonough

Business Intelligence Professional

**** ********** **, **********, ** 15478

ad4u4k@r.postjobfree.com 724-***-****

Summary

Accomplished Business Intelligence Specialist with 15 years of experience in delivering data-driven solutions for the manufacturing and retail sectors. Expert in data warehousing, analytics, and BI tool implementation, with a proven track record of enhancing decision-making and business performance. Skilled in leading cross-functional teams and managing complex projects, such as the Big-Bang Project for store setup and a direct-ship corporate initiative. Seeking a challenging BI/Analytical position to leverage my expertise in data management, reporting, and strategic analytics.

Professional Experience

BI Specialist DeLallo’s Mount Pleasant, PA Sep 2021 – Feb 2024

● Spearheaded the development and maintenance of SQL Server Data-Warehouse jobs for an atomic concept model, enhancing data accuracy and reporting efficiency.

● Designed and implemented complex dynamic logic for Employee Pick Loading reports, reducing operational analysis time by 10 hours a week and enabling more informed performance management decisions.

● Automated the workload analysis by creating a forecasting model that delivered customer/employee picks and replenished products, improving inventory management and customer satisfaction.

● Streamlined user setup, data sources, and group scheduling in Cognos, optimizing report distribution and access control.

● Developed ETL logic utilizing complex views in IBM i to feed the data warehouse for a CMS Project, ensuring data consistency and integrity.

● Automated processes using SQL Job Management for data sources used in Cognos Analytics, enabling efficient data comparison and dashboard reporting. Programmer Analyst Carrier Logistics, Inc. Long Island, NY Aug 2020 – Feb 2021

● Developed and maintained Progress 4GL code for over 25 clients, ensuring seamless operation of ERP platforms.

● Spearheaded the creation and implementation of comprehensive documentation protocols for accounting workflows, technical documentation, data tables, and processes, addressing a critical gap in organizational knowledge management.

BI Specialist/Report Writer Levin Furniture/Wolf Furniture Smithton, PA Apr 2016 – Mar 2020

● Led the development and maintenance of SQL Server Data-Warehouse jobs, Oracle procedures, and packages, enhancing data management capabilities.

● Successfully migrated from SQL Server 2005/Visual Studio to 2017, ensuring system modernization and compatibility.

● Created custom interfaces between 3rd party software and ERP systems, streamlining data integration and reporting processes.

● Played a key role in the Big-Bang Project, setting up 14 Wolf stores in 3 months and converting them to Levin’s business layout.

● Managed the direct-ship main corporate initiative, collaborating with multiple vendors to set up EDI documents and automate statuses to the ERP system with delivery notifications, enhancing supply chain efficiency and customer satisfaction.

Data Warehouse Specialist HarbisonWalker International Moon PA Nov 2008 - Mar 2016

● Developed and maintained the BI Oracle Data-Warehouse, including ETL scripts, job schedules, and PL/SQL functions & procedures.

● Completed migration from Progress/QADBI to Oracle Data-warehouse/COGNOS BI-Tools, enhancing reporting capabilities.

● Designed and implemented an auditing tool to monitor data integrity between system interfaces, ensuring data accuracy.

Education

Bachelor’s of Science, Computer Science and Mathematics California University of Pennsylvania Relevant Skills

● Data Warehousing/BI Tools: Oracle SQL, Warehouse Builder, PL-SQL, SQL Server Management Studio (SSIS - Novice, SSRS - Expert), Power BI, Cognos Analytics & Framework Manager

● ERP Systems: Manufacturing (Syteline, QAD, S2K), Retail (Gers, Loft), WMS (Red-Prairie)

● Programming & Development: Visual C#/.NET, Microsoft Visual Studio (Enterprise), UNIX/Linux O/S, IBM i SQL for DB2

● Integration & Reporting: EDI Integration (810, 850, 855's - EcUtopia & Gentran Inbound/Outbound), Reservation/Appointment (C3 Integration), XPO/Billing Logistics Integration, INCONTACT

(Outbound/Inbound Caller/Dialers)

Contact this candidate