Melody Jones

• Developed Looker dashboards using Snowflake, Big Query, and LookML
• Created derived tables, views, and calculated measures for visualizations
• Worked with the Data Science and Data Services teams to integrate new data sources.
• Supported the migration from Snowflake to Big Query (GCP), collaborating with contractors and the Data Services team, performing knowledge transfer, testing, troubleshooting code and issues, conducting analysis and research, identifying bugs and provided possible solutions, administered reports and folders in Development and Production environments
• Tracked tasks using the Jira sprint board
• Attended daily scrum meetings, sprint planning, grooming, and retrospectives

• Developed Looker dashboards and reports leveraging Redshift
• Implemented improvements to existing LookML code
• Resolved support tickets and performed data analysis
• Tracked tasks using Kanban board

• Supported a major client project as part of a team
• Built Looker dashboards using Snowflake and developed LookML
• Created derived tables, views, and calculated measures for visualizations
• Handled adhoc requests and peer reviews
• Participated in daily scrum, sprint planning, grooming, and retrospectives

Business and Technical Strategy
· Served as primary stakeholder contact and managed cross-organizational partnerships

· Led technical strategy and architectural design for analytics platforms

· Collaborated with Program Data Repository team on data requirements, enhancements, and technical issues

· Defined project timelines and strategic plans for Tableau dashboard team

· Oversaw QC and data governance for analytics platforms

Team Leadership
· Provided leadership and guidance for the work and professional development of Tableau Business Analysts

· Facilitated Agile development processes with Tableau Business Analysts, including daily standups, bi-weekly sprint planning, bi-weekly sprint backlog grooming, JIRA board maintenance, scheduling, and participation in stakeholder demos

· Developed and maintained high-level plans, Gantt charts, and product roadmaps for dashboards, including timelines and product requirement documents

· Collected initial requirements from product stakeholders and develop detailed product requirements documentation (PRD).

· Partnered with product stakeholders and business analysts to create detailed mockups

· Conducted review and approval meetings with product stakeholders

· Ensured that quality control measures are implemented

· Assisted with collecting and confirming requirements for ongoing feature development of published dashboards

Improvements Made
· Identified several things with Tableau that needed to be improved on, including an upgrade to the Tableau server

· Initiated the project to upgrade the server and assisted cross teams as the project manager

· Identified performance issues with data sources and dashboards

· Documented an optimization and improvement plan around our data sources and dashboards

· Wrote up policies and procedures for our team that did not exist around dashboard best practices and standards, quality control, and deployment plan to improve quality and processes

· Successfully managed projects that delivered new dashboards

· Made optimization improvements with several dashboards based on re-design of filters, improvement to data sources, or to the dashboards

• Supported monthly Clinical Operations KPI metrics and improved KPI processes impacting staffing decisions
• Delivered analytics and interactive Tableau dashboards for clinical operations
• Conducted data analysis and developed UDFs, stored procedures, and views for SSRS reports and Tableau dashboards
• Built and maintained Tableau KPI dashboards for the Provider Assessment project to inform provider performance decisions
• Developed provider scheduling dashboards to analyze shift data and identify facility staffing needs

• Collaborated with marketing and business teams to deliver analytics and Power BI dashboards
• Collected business requirements from stakeholders for dashboard development
• Conducted user acceptance testing (UAT) alongside business users
• Developed ETL packages using SSIS to facilitate data import and export for project objectives and Power BI support
• Utilized T-SQL for developing stored procedures, user-defined functions, and performing ad hoc analyses
• Applied Data Vault modeling methods and enhanced databases during new data integration for various projects
• Participated in Kanban processes, attended daily scrum meetings, and contributed to backlog grooming sessions
• Authored user stories to address identified business needs

• Developed complex T-SQL across multiple systems to generate operational reports using SSRS
• Collaborated with business stakeholders to collect requirements for standard and ad hoc reports
• Created ad hoc queries and reports to provide ongoing analytical support to various business owners
• Designed stored procedures and user-defined functions to facilitate reporting
• Conducted data analysis and resolved issues
• Participated in user acceptance testing with business users

• Served as the primary report developer for the BCBSA project utilizing SSRS and Power BI
• Assisted in implementing report security through integration with third-party application login credentials
• Developed stored procedures and user-defined functions to support reporting needs
• Collaborated with business stakeholders to gather and define requirements for reports

• Created SSRS reports and stored procedures using data from Cactus, Salesforce, and Televox applications.
• Maintained and developed SSIS packages as needed for clients
• Worked with business stakeholders to collect requirements for reporting
• Delivered ad hoc reports and addressed data-related issues
• Updated reporting processes and resolved identified problems

• Led a POC to select a new Business Intelligence tool
• Implemented and configured distributed Tableau Server environments for development and production, managing projects, permissions, extracts, and schedules.
• Built Tableau dashboards from diverse data sources
• Supported Tableau Desktop and Server users
• Created user stories and use cases in JIRA to address business needs
• Participated in daily standups, story sizing, backlog grooming, sprint planning, demos, and retrospectives
• Gathered and analyzed reporting requirements
• Conducted UAT with business users
• Developed ETL packages using SSIS for reporting
• Upgraded SSRS server from SQL Server 2005 to 2008 R2
• Migrated operational reports to a new data warehouse; developed stored procedures, UDFs, views, and SSRS reports using BIDS 2010 & SQL Server 2012
• Established a SharePoint portal for SSRS reports, configuring groups, permissions, libraries, and data sources