Business Intelligence Sql Server

Angela McDonough

Business Intelligence Professional

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

**********@*****.*** 724-***-****

Summary

Accomplished Business Intelligence Specialist with 15 years of experience in delivering data-driven solutions for the manufacturing and retail sectors. Expert in Cognos Analytics; experience includes integration of multiple data sources used in reports, dashboards, and workspaces including: last year/this year comparisons for gross profit, gross margin, and revenue, dynamic queries to produce rolling 3 years of data, and employee load, pick, and replenishment rates. Initiated hourly notifications of Sales Flash information in comparison to the same day of week last year. Implementation of Cognos security for Consumers, Report writers and Cognos Admins interfacing with LDAP & Active Directory. Thorough knowledge of Framework manager: creation of models with three sections: Raw Data pulled from the data sources, Design & Modification view (including star-schema relationships) and then pointers/shortcuts to the query subjects/folders for the Presentation views. I am well versed at creating and publishing packages along with change tracking models. I have a proven track record of optimizing queries for performance enhancements, data validation/auditing tools, and all aspects of data governance. Lastly, I am familiar with separate environments for development, test, and production; full software development life cycle, financial reporting, and an understanding of business procure-to-pay.

Professional Experience

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

●Primary role was to maintain models and publish packages within Cognos Framework as the data source for creating complex reports, workspaces, & dashboards in Cognos Analytics.

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

●Spearheaded the development and maintenance of SQL Server Data-Warehouse jobs for an atomic concept model, enhancing data accuracy and reporting efficiency with dynamic auditing from raw data to transformation to destination using measurements and counts.

●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.

●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

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 - Novice, Cognos Analytics & Framework Manager (Expert)

●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