Melissa L. Email & Phone Number

Dallas, Texas, Us

• Manage a team of data engineers on implementing technical strategies • Accurately plan and estimate projects• Recommend best practices for the team to follow• Maintain and develop the Engines/Pipelines and Data Extracts in Azure Data Factory and SSIS• Motivate, mentor, and set goals for a high-performance team in a dynamic, fast paced, growing environment• Coordinate directly with the stakeholders• Work with the team on proactively anticipating and resolving data integration issues across the applications and technical infrastructures

Boca Raton, Fl, Us

• Design and build the reporting foundation to support the next phase of the Company’s goal in becoming the leaders in the Dental industry. The next phase is about filling the gap that exists in the current Dental software which leads to many operational issues (billing, collections, claim tracking, scheduling and provider availability).• Using Reporting Services, build Dashboards for executives and the management team to monitor, analyze and derive actionable insights. Slicing and dicing functionality built into the report allows them to easily spot areas needing improvement with the ability to drill through to the desired level of detail and address the source of the issue.• Design and create solutions to load the Enterprise Data Warehouse real time.• Perform data profiling, build conceptual, logical and physical data models.• Research and address any questions or issues reported with data quality.• Work with the end user and provide guidance regarding reporting functionality.• Build complex interactive reports to track trends, perform gap analysis and fraud detection.• Build Financial, Operational and Incentive reporting and numerous ad-hoc reports as needed.• Create complex stored procedures for reporting and data manipulation.• Collaborate (along-side Pragmatic Works) to provide an evaluation of the current state of the Data Warehouse, propose design improvements and recommendations for adhering to best practices.• Was brought into this role by former employer at Dental One to lay the foundation for a reporting solution. This project has been completed.

Richardson, Texas, Us

• Design and build the reporting foundation to support the next phase of the Company’s goal in becoming the leaders in the Dental industry. The next phase is about filling the gap that exists in current Dental software which leads to many operational issues (billing, collections, patient status progress, scheduling and provider availability).• Design and create solutions to load the Enterprise Data Warehouse real time.• Research and address any questions or issues reported with data quality.• Using Reporting Services, build Dashboards for executives and the management team to monitor, analyze and derive actionable insights. It allows them to spot areas needing improvement with the ability to drill through to the lowest level and address the source of the issue.• Build complex interactive reports to track trends, perform gap analysis and fraud detection.• Build Financial, Operational and Incentive reporting and numerous ad-hoc reports as needed.• Create complex stored procedures for reporting or data manipulation.• Collaborate (along-side Pragmatic Works) to provide an evaluation of the current state of the Data Warehouse, propose design improvements and recommendations for adhering to best practices.• Was brought into this role by a former employer at Dental One to lay the foundation for a reporting solution. This project has been completed.

Plano, Texas, Us

• Develop and support Business Intelligence solutions to address business requirements and provide financial, marketing and operational insight to 200+ Dental One Partners, management teams and executives.• Build Dashboards and Scorecards, using SSRS 2016, to provide an at a glance view of the current state of the Enterprise. Drill through and drill down functionality provide visibility into supporting details to easily spot trouble areas.• Monitor overall reporting performance by reviewing and improving scripts, execution plans and index use.• Improve ITD reporting performance by enhancing the Tabular Model and sourcing these reports from the Model.• Build reports to show trends and outliers for various business areas (sales/claims, marketing, finance).• Support Tableau 10.2 Dashboards as needed.• On call to support, monitor and resolve issues with the ETL loads.• Kick off and monitor month end close processes and oversee their successful completion.

Dallas, Tx, Us

• Assist in the development of the Enterprise Data Warehouse and Business Intelligence solutions for analytics, management teams and executives.• As the Analysis Services 2014 Cube lead developer, timely processing and optimal performance of the cube is one of my priorities. Cubes provide various aggregation levels and are built to meet different business needs (e.g. Marketing, Product, Finance). Cubes include perspectives, KPI’s, roles, hierarchies (natural, ragged), dimensions and measure group relationships (1:n, n:n), calculations, scoping and actions.• Create MDX scripts to query the cube and generate reports.• Create complex stored procedures for reporting or data manipulation.• Build Reporting Services reports and dashboards sourcing from OLAP and OLTP databases. Reports include functionality such as drilldown, drill-through and subreports. Report items used are matrix, tables, charts, sparklines, indicators, etc.• Develop dashboards using Tableau 8.2 and publish to a Tableau server. Data sources used are refreshed hourly/daily and subscriptions are delivered on a regular basis via a pre-determined schedule that is created on the Tableau server. Sources used are the Data Warehouse, cubes and operational systems.• Consult with business partners such as marketing analysts, management and other developers to define project objectives, determine scope, identify issues and recommend solutions.

Wayne, Pa, Us

• Developed and implemented the Enterprise Data Warehouse (SQL Server 2008) consisting of three layers: Staging, Integration (3NF) and Access (dimensional). Disparate sources were integrated using SQL Server Integration Services 2008.• Optimized ETL processes by identifying and eliminating bottle necks as well as applying SSIS best practices which resulted in greatly reduced loading time.• Using SQL Server Reporting Services 2005 & 2008 developed drilldown and drill-through reports for the Financial Services branch which enabled cross-system analysis resulting in significant cost savings for the company as critical data entry errors were exposed and resource intensive processes were eliminated. • Created customized SSRS reports which are rendered via a .Net application (ERP System). The application enables users to create their own private reports by selecting or hiding parameters, fields, groupings and filters that are available in a template rdl file. Customization requires custom code in the template rdl which is used by the application to copy and piece together a new rdl (based on user selection) resulting in a new customized report.• Senior level experience using SQL Server, designing backend processes and database objects such as stored procedures, functions, views, tables, triggers, indexes, CTE’s, etc.• Managed the master data, using an in-house tool where metadata was loaded, mapped, transformation rules were documented and master data status reports were generated. This initiative was aimed to maintain data quality and the overall confidence in the data.

Dallas, Tx, Us

Designed and developed technical solutions to address business objectives. Gathered requirements, wrote functional requirements documents. Created technical design and reference documents. Researched and resolved production issues and enhancement requests. Wrote and executed test plans. Followed procedures relating to source control, change management, Sarbanes-Oxley, and project methodology. Supported 25+ applications, including "mission critical" using PowerBuilder 8.01, Sybase 12, Sql Server 2000/2005 on UNIX (AIX).