EPIC BI Developer with Healthcare Analytics Experience

Dhanalakshmi Guntupalli

217-***-**** *********@*****.***

**** ******* ****, ****** ******, Texas 75077

Experience Summary

More than 10 years of experience in healthcare field with multiple years in healthcare testing, data analysis and EPIC. Strong background in EpicCareInpatient, OpTime as well as Reporting.

EPIC Certified Business Intelligence Developer involved in managing EPIC System in Carle Foundation Hospital, Champaign, IL.

Expertise in design and development of various dashboards, reports utilizing crystal reporting tools.

Developed Dashboards, Visual Reports KPI Score cards Using Power BI

Connecting data source and performed data cleaning and built optimized semantic data models.

Created advanced Dax measures and calculations to support business logic and reporting needs.

Implemented row level security. And published the reports in Power BI service and created the schedules and refreshes.

Expertise in Business Intelligence Development in EPIC reporting workbench, RADAR, Slicer Dicer, Epic Components etc.

Strong knowledge and experience in Health Care industry, experienced in testing different healthcare ERP solutions such VITAL, Clear Coverage and Salesforce.com CRM.

Involved in IDPH reporting for health standards.

Specialized in analyzing the Business Requirement Documents and writing detailed test plans, test cases, and execution of test scenarios, analyzing the actual results against the expected results, creation of test data and automation of test cases for system.

Strong testing quality assurance experience in Waterfall and Agile environments.

Excellent communication skills, strong decision-making skills, organizational skills, ability to work in a team or individually and ability to pick up new skills quickly.

Certifications

EPIC: Cogito, Clinical Data Model, Clarity Data Model, Caboodle Data Model 2021, Cogito Tools Administration, Cogito SQL Badge

ITIL, Manual and QTP certified

Skills

Operating System: Windows NT/95/98/2000/XP, UNIX, Linux

Databases ORACLE, MS-Access, SQL Server, DB2

ETL Tool Informatica (as a tester and reviewer)

GUI: Visual Basic, SQL, Power Point, MS Excel and MS-Word.

Testing Tools: Team Foundation Server, VSTS, Quality Center

Project Management Tool: Daptive, Azure dev ops

Help Desk Management: Altiris

Business Intelligence Tools: Power- BI, Tableau, Crystal reports, Epic Cogito, SSRS

Education

Bachelor’s Degree: Govt college for Women

City: Guntur

State: Andhra Pradesh

Country: India

Professional Experience

Business Intelligence Developer.

Health Catalyst --Remote (USA)

April 2023 – Present

Converted most of the Excel reports into Power BI reports. Learning the new HC tools like POP Insights, SAMD, Pop Analyzer

Develop the reports using the Pop Analyzer

Design the SAMs using the SAMD, from the customized SAMS develop dashboards and reports according to the client requirements.

Designed and developed interactive and visually appealing Power BI reports and dashboards.

Translated complex business requirements into effective data visualizations to facilitate decision-making.

Created and optimized data models within Power BI to ensure accurate and efficient data analysis.

Defined relationships between data tables and implemented best practices for data modelling.

Extracted data from various sources, performed transformations, and loaded it into Power BI for analysis.

Utilized Power Query to clean, shape, and combine data from diverse data sets.

Provided ongoing support and troubleshooting for Power BI-related issues.

Collaborated with business analysts, data scientists, and other stakeholders to gather and understand business requirements.

Ensured alignment between Power BI solutions and organizational goals.

Implemented version control for Power BI projects using tools like Git.

Managed relationship with programmers and bridged communication between end users and development team.

Imported data from SQL Server DB, SAP Hana DB to Power BI to generate reports.

Published Power BI Reports in the required originations and made Power BI dashboards available to clients.

Data validation and debugging the dashboard for quality assurance.

Created and tested the RLS (Row Level Security) and understood the Power BI security layers to ensure secure data access.

Created DAX Measures and Calculated columns and Custom tables and Parameters.

Developed interactive Power BI reports and KPI Score cards to support data driven decision making.

Epic Business Intelligence Developer.

Carle Foundation Hospital, Champaign, IL

March 2020 – 2023 March

Responsible for Hospital & Emergency operations Dashboards/reports as part of the Hospital Operations team, partnering with business, Providers, Nurse Managers and department heads.

Responsible for creating reports for Epic Modules like ASAP(ED), Beaker, Behavioral Health, Bugsy, Cupid, Dorothy, EpicCare Inpatient, EpicCare Urgent Care, OpTime,Radiant, Stork, Willow.

Creating RWB reports on patient encounters, orders, medications, procedures, flowsheets, problem list, diagnosis, smart texts, admissions, discharges, Case management and compliance reports Admissions, Discharges, Transfers, Census.

Interaction with primary clients/business representatives for requirement analysis and to define business and functional specifications.

Develop SQL queries for data analysis to build up reports and dashboards for end users.

Creating several dashboards in radar for major stakeholders

Involved in creating Custom metrics, Components and Slicer Dicer Sessions.

Participating in daily meetings with team Leads, Managers, and Clinical Analysts, Physicians, Nurses and End users to discuss report requirements and show them progress on reports.

Developed SQL queries to use in Crystal reports.

Good experience with Data Handbook, Record viewer, column search, Database object search

Developed custom rules using rule editor (CER records) plugging the rule into Extensions (LPP records)

Built custom PAFs using column editor

Developed SQL Templates for RWB Reports

Built Radar Operational/Analytical Dashboards/Components/Metrics/SlicerDicer Sessions Reports for various groups and stakeholders within the hospital and for higher management.

Responsible for all phases of Reporting Decision support, data analysis, data collection summarization and validation.

Created SQL queries and views to pull the data into Power BI to develop visualizations.

Created various Reports using Power BI and involved in Performance tuning.

Created reports using complex calculations and variables.

Extensively worked with formatting the reports according to the user requirements.

Developed Dashboard reports for Project portfolios which help in better analysis for decision-making using PowerBI.

Test Analyst.

HAMP (Health Alliance Medical Plans, IL Champaign)

December 2013 – Feb 2020

Hamp provides information technology products and services for the Health Alliance Insurance division. Health Alliance sells health insurance plans and Medicare advantage plans in Illinois, Iowa, Wisconsin and Washington.

Broker & Employer Group Management Sales force portal.

Broker & Employer group management provides services for business users to create Broker

accounts, employer accounts and manage license contracts.

Responsibilities:

●Ongoing role within a small agile software product development team.

●Assures quality through continuous testing of newly developed elements while maintaining existing test suites.

●More frequent updates to the product line following agile continuous delivery needs continuous integration and attention to quality testing

●Responsible for managing broker access fields, contracts, licenses and employer group admin creation as part of QA testing & UAT support.

Hamp Mobile App (YHA)

Your Health Alliance is a mobile app used by brokers and members.

Responsibilities:

●Worked as a QA tester within the agile software development team coordinating the continuous development, integration and testing of the mobile app.

●Directory Search, Claims validation, Member benefits, Authorizations, Notifications and Employer group Insurance are the key modules of Hamp website(Healthalliance.org)

●Reviewed Business requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents for any changes to the above modules.

●Developed and execute test plans for Production and Test environments on a daily basis for the new adhoc requirements and change requests.

●Case management platform VITAL for patient care changes are validated with HAMP Medicaid Care plan members.

●Responsible for continuous quality improvement plan in accordance with Medicare, NCQA standards.

●Responsible for managing multiple QA projects at the same time.

●Worked with business and technical staff in planning, executing and documenting testing efforts.

●Worked with business users to create Functional test scenarios, test plans and User Acceptance test scenarios for Wellness Check Up and Truven Cost Calculator.

●TFS Test Manager is widely used for tracking change requests and business requirements following agile methodology. Several sprints with multiple tasks are created for each change request.

●Facilitated Business community in creating test users for UAT and coordinated the UAT testing for all the enhancements.

●Worked with CRM Tool Salesforce Creating the master Tax ids and Broker accounts, employer groups,

worked with sales force Opportunity records, and leads, cases for the NPs, wellness records

●Created objects and access fields and maintained master records.

●Worked with CAB to signoff all production defects following the CAB approval process.

●Tested several jobs of AS400 to update member tables synched with SQLServer of HAMP.

●Involved in performing manual, functional, regression and sanity testing.

●Worked with Enterprise release management to coordinate the deployment of the domain projects aligning with monthly builds and quarterly deployments following ITIL process.

Environment: Team Foundation Server, VSTS, SQLServer, BMC Service Desk, SOAPUI, Web Services, Salesforce, MobileApp, batch testing, REQBIN, SQL, AS400, MC400, Windows XP, VB, .net, J2EE, JSP, XML.

Information Technology Technical Associate.

Illinois State University IL, Normal

Duration: December 2011 to Jan 2013

Illinois State University’s Business Intelligence Technology solutions provide information technology products and services for the administrative and business functions of Illinois State University. ILSTU is a campus for approximately 20,000 students and all students will have access to BITS supporting various systems.

Responsibilities:

●Develop and execute test plans for Change Requests, FTs( Fast Tracks) software enhancements for Welcome2ISU Portal.

●Reviewed Business requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

●Developed and execute test plans for Production and Test environments on a daily basis for the new adhoc requirements.

●Responsible for managing multiple QA projects at the same time.

●Worked with business and technical staff in planning, executing and documenting testing efforts.

●Worked with business users to create Functional test scenarios, test plans and User Acceptance test scenarios.

●Facilitated Business community in creating test users for UAT and coordinated the UAT testing for all the enhancements.

●Traceability Matrix is followed in Quality Center when writing testcases.

●Written several SQL scripts in SQL Developer & QMF to create data for UAT testing.

●Conducted UAT with customers to show the complete flow of Housing & Dining for students.

●Analyze various heterogeneous data sources source to extract, transform, and load data in to target data warehouse based on the requirement specification using SSIS packages.

●Tested several jobs of Mainframes to Update DB2 tables from fall to Spring term.

●Involved in performing manual, functional, regression and sanity testing.

●Introduced SOAP UI tool for testing Web services and used JMeter for load testing web Services.

●Assertion testcases were added in SOAP UI for content testing in SOAP UI.

●Created Test templates for running ETL scripts to test extract data and report.

●Interacted with DBA’s, Operational team, Developers and discussed technical problems, reported bugs and coordinated in the process flow.

●Developed several test cases for verifying the ETL data coming from DB2 to University DB.

●Developed several Validation scripts including Format Checks, Data consistency checks and Role based Security checks.

●Worked with Enterprise release management to coordinate the deployment of the domain projects aligning with their calendars following ITIL process.

Environment: Oracle, SQLDeveloper, SOAPUI, WebServices, SQL, Tomcat, MainFrames, JCL, Windows XP, JAVA 2, J2EE, JSP, XML.

QA Analyst

Zetabytes Inc

iMotors.com, IL, Chicago

November 2009 - Aug 2011.

IMotors.com provides consumers with fast and easy tools for researching new cars, trucks, and SUVs. Consumers have access to a wealth of information about buying a new vehicle including reviews, reports and pricing, and connects them with local dealerships that can assist them in completing the transaction.

Responsibilities:

●Ability to work with the cross functional team, assign the tasks, track and monitor and provide status updates to management.

●Develop and execute test plans for Change Requests, FTs( Fast Tracks) software enhancements for Quarterly Releases.

●Developed and execute test plans for Production and Test environments on a daily basis for the new adhoc requirements.

●Worked with end users(dealers) to understand the daily activities and created UAT test scenarios based on their recommendation.

●UAT environment & Test case templates are provided to the UAT users after completing a regression.

●Involved in performing manual, functional, regression, sanity testing.

●Interacted with Web Admin’s, DBA’s, Infra Operational, Dev Infra, Developers and discussed technical problems, reported bugs and coordinated in the process flow.

●Experience in Self Care Testing – Regression, Defects, Sanity, Production Defects – Validation of User Registration process, Vehicle Search, Dealer Search and Commission modules.

●Involved in building Sanity testing scripts for all the web modules.

●Developed several Validation scripts including Format Checks, Data consistency checks and Role based Security checks.

●Tested performance/functionality before and after bug fixes for which entries are made in HP QC.

●Bouncing WebLogic Server to Support the Web Applications

●Tracking the bugs using Quality Center.

●Used SOAP UI, WebLogic task to test Web Services running on WebLogic Server.

Environment: Oracle, Toad, SQL, WebLogic, Windows XP, JAVA 2, J2EE, JSP, XML, HP Unix, HP Quality Center.

Contact this candidate