David S. Email & Phone Number

Pennsylvania, United States

Utilizing the Azure platform and Fabric, responsible for the architecture and implementation of data pipelines that ingest, transform and deliver data from multiple sources to end users and businesses partners.

Irvine, Ca

• Developed, tested, and deployed standard reports and dashboards based on business requirement document specifications.• Engaged with business users to gather, define, and document reporting requirements.• Created complex SQL queries, database objects and Azure pipelines to pull and manage data.• Collaborated with support team to assist client stakeholders with emergent technical issues and develop effective solutions.• Conceived, developed, and implemented a wide range of BI solutions.• Reviewed and improved performance of SQL server.• Analyzed code and corrected errors to optimize output.• Assisted solution providers with definition and implementation of technical and business strategies.• Developed and managed enterprise-wide data analytics environments.• Generated standard or custom reports summarizing business, financial or economic data.• Trained non-technical users and answered technical support questions.• Assisted clients with requirements analysis, documentation, business analysis and logical data modeling.• Provided technical support for existing reports, dashboards, or other tools.

Greater Atlanta Area

• Work closely with project manager to provide Business Intelligence solutions to clients in the manufacturing industry who use Microsoft Dynamics AX and D365 Finance and Operations• Transform complex business logic into SQL queries and stored procedures for Business Intelligence reporting.• Implemented D365 entity extraction to Azure SQL Server utilizing Bring Your Own Database (BYODB) solution• Experience configuring D365 to use custom Power BI reports and dashboards.• Design and Create SSAS Tabular models using star or snowflake schema for use with Power BI• Implement client requested changes and updates to SSAS tabular models to improve data accuracy and reliability.• Create calculated columns and measures in Power BI using DAX functions.• Assist client in the implementation of data access security utilizing row level security in Power BI reports.• Assist client with install and configuration of enterprise data gateway in Power BI service.• Create and configure client's App Workspaces in Power BI service according to business requirements.• Designed and enhanced SSIS packages which pull from different data sources for client ETL processes.• Developed Windows Forms .NET application to allow input of sample data to be displayed in Power BI reports.• Work cohesively with client System Administration team to ensure smooth project handoff.

Tampa, Fl

• Responsible for maintaining, updating, and troubleshooting over 200 SSRS reports used within the ConnectWise software application which supply critical, analytical business data to the end user.• Developed method for report localization so report headers and labels are dynamically multi-lingual.• Work closely with BA and QA teams to ensure reports conform to business requirements, design specifications and return expected results.• Utilizing report specifications create complex stored procedures, functions, views and RDLs for integration into application using SQL Server Management Studio and SQL Server Data Tools. • Responsible for analyzing, optimizing and improving stored procedure execution times through query tuning and applying indexes where required.• Assist team members with troubleshooting customer report and SSRS installation issues.• Kept education and documentation team up-to-date on report specification and functionality changes.• Utilizing Code Collaborator, perform SQL code reviews as required.• Work with and respond to customer trouble tickets to resolve any reporting discrepancies.• Create adhoc reports to collect and analyze performance data for various levels of the management team.

Palm Harbor, Fl

Developed and maintained SSRS reports for flahgship Virtual One Stop application used in many states for providing job searches to the public.Worked with customer's IT team to resolve any reporting issues.Using specifications from BA team, work to develop and refine new reports, add functionality to reports and tune current SQL queries for current reports.

Tampa, Fl

Utilizing SQL Server Integration Services (SSIS), SQL stored procedures, views, and VB.NET created automated controlled substance reporting system which gathers dispensed prescription data; , formats data per individual state requirements, and submits the file via SFTP or FTPS enabling the company to more easily meet the reporting requirements of the states the company ships to.Utilizing SQL Server Integration Services (SSIS), SQL stored procedures, views, and VB.NET created package which automatically downloads, unzips, and updates the database with the most recent drug NDC information on a weekly basis. Responsible for managing current reporting system and the creation of SSRS reports for Pharmacy, Customer Service, Sales & Marketing, Finance, and Senior Management allowing them to track product sales trends, monitor and increase productivity, and make informed business decisions.Utilizing VB.NET and SQL stored procedures, views, and functions implement feature requests, bug fixes and modifications to internal pharmacy management system used across two locations and four separate divisions (Brachytherapy, Nuclear Pharmacy, Pain Pharmacy, and Custom Pharmacy).Created multiple Reporting Services reports to monitor the transfer of customers from newly; old system to the company's current system.

Assisted in implementing and modifying Act Soft's CometTracker application to allow forwarding of orders sent to phones by writing custom stored procedures and DTS packages.Created Online Active Rental and Online Utilization reports in VB.NET allowing customers and sales team to view currently rented products, billing data, and clinical information by facility for an entire chain, region, district, or individual facility.Created Trouble Ticket tracking system in VB.NET for the IT department allowing employees to login and submit new requests, and view the status of submitted requests. Includes search page allowing users to search for and view previously closed tickets. System also includes a small user management tool to add/delete user accounts, set passwords, and set access levels. This system allows the IT department to more effectively manage and utilize its resources.Responsible for designing and automating custom reports for internal and external customers in Crystal Reports and Excel utilizing SQL stored procedures and DTS packages.Created Opportunity Report workbook in Excel which automatically pulls the most current information from the database when opened allowing the Sales Support team and National Director of Sales to gauge current and future sales strategies.

Created, Updated and Revised documentation for Production Control process manuals.Verified and staged code from the development environment (NT) to production (Unix) environment for testing and release using Version Manager and Kintana/ITG where attention to detail is critical.Created and modified SQL reports using TOAD and Crystal Reports.

Ft. Campbell, Ky

• As a Fully Mission Qualified (FMQ) Crew Member performed mission critical flight duties as required.• Responsible for supervision and training of Company’s new mechanics.• Remove and install aircraft subsystem assemblies such as engine, rotors, gearboxes, transmissions, flight controls and associated components.• Responsible for coordinating and performing scheduled and unscheduled maintenance of assigned aircraft.