Data Analytics Technical Support

Payal Grover ***********@*****.*** 443-***-****

Innovative Technology leader with demonstrated history of working in various domains & technologies. Proven Experience in IT Roadmap/Strategy, project delivery, Business Relationship Management and building High performing teams. Highly skilled in Analytical Skills, Requirements Analysis, Agile methodologies, Change Champion & team building.

Core Competencies

• Team Leadership & Support

• Data Analytics & Visualization

• Disease Datamart

• Software Development Lifecycle

• Process Improvement & Automation

• Creating Efficiency & Scalability

• Population Health Management

• Technical Support & Integration

• Managing Vendors Like Home Health, Hospital @ Home Etc.

• VBP, HEDIS & STAR & Compliance Reporting.

• Staff Coaching & Mentoring.

Technical Proficiencies

Data: SQL Server, Power BI (SSSIS & SSRS).

Code: .Net Core, .Net Framework, C#, Python, JavaScript, T-SQL. Data analysis Tools: Tableau, Map Point, R Programming and SAS. Certification

Certified EPIC BI Developer (Cogito, Caboodle & Clarity data models) Nov 2023. PMP Certified (June 2023).

Career Experience

Manager Health Information, Elevance Health Dec 2021- Present

• Managed, Coordinated & lead teams working on Multiple projects like Population Health Management, SNP Compliance, Hospital @ Home, KPI dashboard, Disease DataMart, STARS Reporting, Flu, Covid Reporting and Associate Dashboard Scorecard etc.

• Collaborated with the business team and build Semantic layers for reporting out in Tableau along with data analytics & ad hoc reporting needs.

• Plan Projects roadmap, align long-term and short-term goals working with Business, customers, and other stakeholders, prepare and prioritize feature requirements, interact with internal and external stakeholders/customers to gather pre- and post-release feedback.

• Lead strategic development initiatives to identify opportunities for embracing the modern shift supply and demand, and how that change is managed in software value streams. Successfully delivered Population Health dashboard & Disease DataMart upgrade Hospital @ Home project, in which legacy SSRS report was replaced with Interactive dashboard views over a period of 6 months.

• Managed successful transition from legacy server to new Server without impacting per quarter revenue involving a global team of consultants, analysts, and partners.

• Supported technical, architectural presentations/project overviews and SIPOC.

• Engaged team in team building Events & Cross training & Knowledge transfer sessions.

• Given emphasis on documentation. Mentored & lead team to follow standard document for Projects they were undertaking.

• Assigned Backlog Requests to team according to their domain knowledge & expertise with load balancing techniques.

• Resolved various conflicts on team with different Conflict management techniques.

Health Information Consultant Senior, CareMore Dec 2019- Dec 2021

• Coordinated and lead the team responsible for the delivery of new functionality /CDC guidelines on automation of COVID -19 & Flu application/dashboards.

• Collaborated with the business team and build Semantic layers for reporting out in Tableau along with data analytics & ad hoc reporting needs.

• Built a strong technology team providing strategy, development processes, and succession planning enabling self-directed teams to successfully execute against their goals within an agile environment.

• Organized teams into 3 core groups, One Group focused on Analytics needs taking requirements from business implementing data analytics & generating ad hoc reports dashboards & trends, second group focused on development collaborating with Business working on building semantic layer through SQL & SSIS packages in server, third group offshore that was working on developing /creating visualizations & drill down reports in tableau.

• Developed & implemented a project name Disease DataMart which had all diseases that members were diagnosed in past years for outreach purposes.

• Successfully Completed projects like APEX rebranding & transition of EMR system from Casper to EPIC.

• Lead, direct, and be principally responsible for the people and the software development life cycle (SDLC) process.

Advanced Data analytics Consultant, Anthem Jan 2017- Dec 2019

• Working in Automation Department of Finance. Automated & delivered many Projects using ETL resources.

• My main project was Large Claims for enterprise (East, West & Central Region). Goal of project was to automate stuff that was done manually & bring efficiency wherever we can. Also, to Standardized the process of large claims in all state & adopt best Practices. Before this process was done manually where clinical & finance department identifies Large Cases. So, Actuaries can accrue money before Claims comes in. Team used SSIS, SSRS

& SQL to automate this process. And final project was hosted using SharePoint site which not only time but was much more efficient, reliable standardized with no human errors. We were able to run process more frequently & able to identify more large cases in advanced. Reports were also customized further from this for Case Mgmt. to help reduce Inpatient days.

• Achieved the on-time and under-budget delivery of multiple compliance and regulatory features within VBP.

• Performed the Scrum Master role for the Risk Adjustment delivery Team. Facilitated Sprint Planning, Daily stand-ups, Reviews, and Sprint Retrospectives.

• Develop and maintain an expert level of knowledge of projects, capabilities, and operations of the company, the marketplace, competition, strategic positioning, threats, and direction. Achieving success with executing new products and financial opportunities.

Advanced Data Analytics Analyst, Amerigroup Sep 2015- Dec 2017

• Developed and certified VBP measures with NCQA for HEDIS 2018 for DC market. The framework had the capability of ingesting sample NCQA data set, certifying measures and reporting capabilities for health care plans. Application was built on .Net framework utilizing SQL server as backend and SSRS as reporting tool.

• Used SAS, R programming for Projections, Predictive Modelling and Map point for Clusters of providers and members.

• Implemented Heat maps using tableau dashboards for Members & Providers for outreach purposes & various campaigns running through organization.

• Developed various reports using SSIS & SSRS for Population Analysis for NCQA accreditation & for program Evaluation within company.

• Responsible for feature development across the home visits Vendors. Personnel management including hiring, mentoring, performance management. Aligned long-term and short-term goals working with product management, customers, and other stakeholders, prepare and prioritize feature goals.

• Supported technical, architectural presentations/product overviews and POCs.

Sr. Database Developer, Design a Website Aug 2009-Sep 2015

• Worked in a large team using Microsoft Visual studio 2005 Team System for Database Professionals with TFS for version control and greater co-ordination.

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDFs, indexes rules and defaults on MS SQL server.

• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, and triggers.

• Testing of applications for performance, data Integrity. Education

• Master of Science in Software Engineering

• Bachelor of Technology in Information Technology

Contact this candidate