| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Business Intelligence ProfessionalStreet Address
EMAIL AVAILABLE PHONE NUMBER AVAILABLESummaryAccomplished 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 ExperienceBI Specialist DeLallos Mount Pleasant, PA Sep 2021 Feb 2024Primary 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 AnalyticsProgrammer Analyst Carrier Logistics, Inc. Long Island, NY Aug 2020 Feb 2021Developed 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 2020Led 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 Levins 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 2016Developed 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.EducationBachelors of Science, Computer Science and Mathematics California University of PennsylvaniaRelevant SkillsData 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 DB2Integration & Reporting: EDI Integration (810, 850, 855's - EcUtopia & Gentran Inbound/Outbound), Reservation/Appointment (C3 Integration), XPO/Billing Logistics Integration, INCONTACT (Outbound/Inbound Caller/Dialers) |
