.: Shannon's Resume'
embracing change
....working as a team
........balanced technology
............partnership management
Motivated Database Engineer with over 10 years of Microsoft Solutions Development. Recognized for assessing operational needs and developing solutions to save costs, improve revenues, and drive customer satisfaction. Resourceful and well-organized with excellent leadership and team building record..
EDUCATION - Purdue University
PORTFOLIO
EPIC – Decision Support Kaufman Hall Data Automation Created a scalable data automation solution that pulls data from EPIC’s Clarity and Caboodle databases for targeted hospital billing (HB) and professional billing (HB) data. The solution provides several business-driven options for both daily and custom extracts. Users can choose the start and end date for the extract and the source of the range, Service Date, Post Date, or Last Updated Date. Users can also turn on or off any one of the custom 30 extracts. There is also the option to have the extracts export to one text file for each or 10 load balanced files for each. Finally, the solution uses SFTP to send to Kaufman Hall for loading into their database. Kaufman Hall is a web-excel style ad-hoc reporting tool. Technology: Developed in Microsoft SQL Server using SSIS and Stored Procedures. Users: 12 NextGen - Centralized Data Warehouse and Data Automation I worked on a team of two people, myself and an architect, to develop a custom data warehouse for over 50 Planned Parenthood affiliates. Based on the architect’s design, I developed tables, queries, SSIS packages, stored procedures, and functions to support the intake of data files, normalized the data, conformed the data, and then populated our star schema data warehouse. I was also tasked with extensive raw data analysis and worked with business representatives to determine the appropriate business rules for handling data issues. When needed I built self-evaluation, self-healing, QA checks, logging and alerts into the solution. Technology: Developed in Microsoft SQL Server using SSIS and Stored Procedures. Users: 200 🏆Confidential – Data Automation and Integration I signed a confidentiality agreement for this solution. I can share the solution design and technology, but I am not allowed to share the content or the organization. For this solution I created a scalable data automation solution that pulls data from multiple sources. These sources were a mix of FTP files (text, csv, and XML), direct connection to cloud services (AWS, Azure, and Google), and the use of API data transfers. Extensive raw data analysis was required to create a stable and predictable integration process that was self-evaluating and self-healing. Data was then normalized, conformed and pulled into a custom data warehouse. Additional data marts, certified data report repositories, and OLAP solutions were developed. Logging and alerts were also built into the solution. I worked with business report writing teams to train them on how to find and use data from the certified data report repositories and OLAP cubes. I also trained their IT department to support the solution going forward. I build maintenance features into the solution to help make the transition even easier. I also provided comprehensive user and technical documentation. Technology: Developed in Microsoft SQL Server using SSIS and Stored Procedures. Users: 12 Recognition: Bonus 🏆Supplier Quality Rating System Solution provided user interface and automation for Nestle Ice Cream manufacturing plant raw material receiving department to look up and enter quality criteria for raw materials. Specifications for each raw material could be reviewed using this system and staff could enter quality inspection and testing results for each raw material received. A rating for each supplier was calculated based on these results. Suppliers are notified of their rating status and any off grade traced back to the raw material they sent. They were charged the cost of the off grade. Technology: Beta Version Developed in Microsoft Access | Final Version Developed in Visual Studio .net with Microsoft SQL Server using SSIS, Stored Procedures. Users: 144 users across 6 manufacturing plants and corporate Recognition: Hall of Fame Award 🏆Quality Systems Management This solution provided work flow-based guidance and data entry for the entire Haagen-Dazs manufacturing plant. Modules o Formula Batch Index and Specifications o Production Scheduling o Production Workflow and Specifications o QA/QC SPC Collection and Reporting o Micro/Environmental Management and Reporting o Off-Grade Tracking and Reporting o Labor Tracking and Reporting o Safety and Employee Training Tracking and Reporting Technology: Beta Version Developed in Microsoft Access | Final Version Developed in Visual Studio .net with Microsoft SQL Server using SSIS, Stored Procedures. Users: 220 Recognition: Change Master Award FMLA Tracking and Reporting Provided HR the ability to leverage People Soft data and track California FMLA criteria, generate standardized letters when needed, and generate reports. Technology: Beta Version Developed in Microsoft Access | Final Version Developed in Visual Studio .net with a Microsoft SQL back end using SSIS, stored procedures and functions. Users: 5 Activity Based Costing for Distribution (ABCD) Received data from various third-party sources, SAP, and Oracle financials. This data was then combined, normalized, calculated and aggregated for use in a star schema data repository and then processed into an analysis services OLAP cube. Technology: Developed in Microsoft SQL Server using SSIS, SSAS, Stored Procedures. Calculations Performed in SAP Metify and the final cube was leveraged by SAP BPC for reporting and analysis. Users: 500 Drill-able Profit and Loss Reporting Tool Using data provided by Oracle Financials and some third-party sources data was combined, normalized, calculated and aggregated for use in a star schema data repository and then processed into an analysis services OLAP cube. Technology: Developed in Microsoft SQL Server using SSIS, SSAS, Stored Procedures. The final cube was leveraged by SAP BPC for reporting and analysis. Users: 25 Sales Pricing Tool Received data from various third-party sources, B-Loyal, and Great Plains. Combined the data, normalized, calculated and aggregated for use in a star schema data repository and then processed into an analysis services OLAP cube. The data was also in a custom web-based user interface, that I also designed and developed, to allow sales people based all over the world to create sales pricing scenarios. Once they landed on a scenario they were happy with they submitted it using this solution to corporate sales for approval. The workflow then sent the approved sales pricing to strategy and planning for budgeting. Technology: Developed in Visual Studio .net with Microsoft SQL Server using SSIS, Stored Procedures. Users: 50 Productivity Tracking and Reporting Tool Using data from a centralized data warehouse and text files submitted from 50 affiliates across the United States I combined the data, normalized, calculated and aggregated for use in a data repository. Using Tableau, reports were generated to provided government submissions of productivity data. The files were submitted through an asp.net web-based user interface that provided real-time feedback on the data being submitted. Any violations to required business rules were instantly reported to the user and the file rejected. Technology: Developed in Visual Studio .net and Microsoft SQL Server using SSIS and Stored Procedures. Users: 100 Youth Service Bureau Clinician Management A full office workflow management tool that included reception scripts and scheduling, clinician appointment management and notes, billing, statistic calculations and government reporting. Technology: Developed in Microsoft Access with a Microsoft SQL back end using SSIS, stored procedures and functions. Users: 25 Chalk Talks Demo Working with a start-up company we established business requirements and I designed and developed a fully functional demo for converting educational seminars recorded as sound or video into searchable text. The solution was then circulated to collect investors and ultimately redeveloped into an enterprise web-based platform. Technology: Beta Version Developed in Microsoft Access Users: 5 Several Healthcare Data Warehouses and Certified Data Repositories o Nestle / Dreyer’s Grand Ice Cream o Voxent / Planned Parenthood o Francis Ford Coppola Presents o UC Davis o UMC Las Vegas o Improvisations o Fast HRMS o Tulare Youth Service Bureau o OTC Find o Streamliner Numerous Automated Data Integration Solutions o Nestle / Dreyer’s Grand Ice Cream o Voxent / Planned Parenthood o Francis Ford Coppola Presents o UC Davis o UMC Las Vegas o Improvisations o Fast HRMS o Tulare Youth Service Bureau o OTC Find o Streamliner |
||||
