Davion Waites Email & Phone Number

Dallas, Texas, United States

• Collaborate closely with cross-functional teams to understand operational and analytical requirements, identifying critical performance metrics. • Work with both technical and non-technical staff to refine project deliverables through iterative processes anddeliver comprehensive Power BI training sessions that result in a 95% increase in user proficiency and significantly enhance end-user support.• I provided detailed summaries and comprehensive information to meet client agreements. I successfully transformed nearly 50 on-the-fly query reports into dynamic Power BI presentations, making data easier to visualize and access. Some reports involved integrating data from external sources beyond our usual data warehouse.• Designed and developed customized extract, transform, and load (ETL) applications using SSIS per client specifications, resolving complex business issues and proposing long-term solutions to prevent recurring problems.• Enhanced the performance of slow-running reports, ETL processes, and stored procedures through optimization techniques, ensuring database performance, data integrity, and security.• Conducted data analysis, provided insights via visualization, and promptly troubleshooted issues while staying current with SQL and Power BI best practices.• Implementing CI/CD pipelines for automated builds, testing, and deployments of Service Fabric applications.• Staying updated with the latest features, updates, and best practices in Microsoft Service Fabric and related Azure technologies.• Provided ongoing support by promptly resolving issues and collaborating with the team to maintain seamless project functionality.• Demonstrated commitment to delivering effective solutions and support, leading to significant performance improvements.• Provided round-the-clock on-call and emergency support and administration for critical applications.• Provide training and support to end-users on BI tools and solutions.

• Addressed slow-running queries by implementing optimizations to enhance efficiency and overall speed. Simultaneously, played a key role in creating and maintaining critical processes, ensuring their seamless operation.• Collaborating with stakeholders to understand reporting requirements and translating them into actionable reports and dashboards.• Designed and implemented sophisticated SSIS packages incorporating a diverse array of transformations and tasks, including Sequence Containers, Script tasks, For Loop, For Each Loop Containers, Execute SQL Tasks, Send Mail tasks, File System tasks, Conditional Split transformations, Data Conversion transformations, Derived Column transformations, Lookup transformations, Merge Join transformations, Union All transformations.• Utilized various source and destination components such as Flat files, OLE DB, Excel, and XML in SSIS packages to facilitate data integration and transformation.• Developed and maintained reports using Power BI, improving data visibility and accessibility for stakeholders.• Worked with teams from different departments to identify and solve data-related issues.• Created user-friendly, interactive reports and dashboards by developing calculated fields, parameters, and filters.• Defined and implemented standards and best practices for dashboards and related technologies to maintain consistency and quality.• Collaborated within an Agile/SCRUM framework and followed the Software Development Life Cycle (SDLC) methodology.• Monitoring and optimizing SQL databases, SSRS reports, Power BI dashboards, and ETL processes for performance and reliability

Carrollton, Texas, United States

• Engaged extensively with clients to convert raw data into valuable insights and actionable intelligence, enabling strategic business decisions. Implemented streamlined reporting solutions that allowed users to easily access and customize data filters, empowering them to independently navigate and analyze information without depending heavily on technical support.• Collaborated with subject matter experts (SMEs) to deeply understand source data complexities, enhancing insight into the information landscape. Worked closely with power users to refine reporting needs, ensuring the delivery of customized and accurate reporting solutions.• Facilitated the seamless and accurate transfer of data across the network. Diligently investigated and promptly resolved any irregularities affecting diverse audit reports, arising from alterations in interconnected systems.• I played a pivotal role in creating and maintaining Stored Procedures. I designed and implemented essential database components, including Stored Procedures, Triggers, Functions, Tables, and Views. • I utilized optimized T-SQL code and strategic SQL joins to ensure efficient data retrieval processes.• I skillfully developed a variety of reports in SSRS, utilizing data from Analysis Services Cubes and relational databases. Managed the entire lifecycle of SSRS reports, including implementing parameterization, caching, drill-down/drill-through functionality, linked reports, click-through reports, and Sub Reports.• Documenting SQL scripts, SSRS reports, Power BI dashboards, and ETL workflows for reference and knowledge sharing.