Melanie Mcdaniel Email & Phone Number

Centennial, Colorado, United States

• Interviewed business owners surrounding capabilities to create data requirements for business- centric Data Marts for self-explanatory querying. • Coordinated with on-shore and off-shore team members to provide technical direction regarding the mart builds and testing results to ensure accuracy.• Authored a lineage document of the requested data including source file, intermediate stage/scrub tables, transformations, calculations, definitions, format and valid values to assist in traceability.• Created and ran SQL validation scripts against the Data Marts to ensure correct and consistent information before handing off for UAT.• Utilized SAPs Information Services tool to provide users with this information (Metapedia) and created jobs to validate incoming data integrity (Data Insights) to avoid hidden data issues.• Assisted business teams dedicated to the customer journey to act as a data liaison for capabilities, questions and queries surrounding the EDW to avoid interruptions to the development team.

Centennial, Colorado

• Implemented upgrades for version releases and fixes from SAP to ensure a supported release.• Opened tickets and worked with SAP engineers regarding issues with our deployment to avoid delays in report deliveries and missing SLAs.• Monitored and tracked test and production servers for issues that could interrupt availability.• Created a standard document to assist in gathering requirements for reporting requests including a sample report, frequency, distribution and ownership to avoid misinterpretations.• Developed, augmented and maintained Reports and Universes according to requirements, improvements and fixes from users.• Authored and provided end user training in WebIntelligence (Webi) to promote a better understanding of the data in the Universes and self-service.• Instituted a BI Help Desk to respond quickly to user issues including slow refreshing reports, unexpected results, query questions, new requests and general support.• Maintained constant contact with report owners regarding report relevance, accuracy and deprecation to maintain a clean deployment.• Collaborated with members of the EDW team on new data requirements, report triggers and availability (SLA) of incoming data to comply with dynamic reporting needs.

Centennial, Colorado, United States

• Provided resource forecasting for projects so that timelines and budgets could be established, monitored and met.• Conducted project meetings to ensure tasks were being completed and roadblocks removed.• Utilized Microsoft Project for visibility into progress, milestones and dependencies for ease of reporting to stakeholders.