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

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

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

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

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

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

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.