Dhruv Jain CRCR

adhvwh@r.postjobfree.com 513-***-**** www.linkedin.com/in/DhruvKJain github.com/jainda09 SUMMARY

Data Analyst experienced in Healthcare Finance, E-commerce and Market Research data reporting, visualizations and data management in both Agile and Waterfall methodologies. SKILLS and HIGHLIGHTS

• Tools and Technologies: Tableau, SAS, SAP Business Objects, SSMS, SSIS, Hadoop, Hive, Informatica, Microstrategy, RStudio, MS Office Suite prominently Excel, MS SharePoint, Jira, STRATA.

• Languages – R, SQL, Python

• Databases: RSQLite, MySQL, MongoDB, MS SQL SERVER WORK EXPERIENCE

Data Analyst, Revenue Cycle at Ensemble Health Partners September 2019 -Current As a part of Payment Integrity Analytics team, responsible for data management, design, build and delivery of reports for various departments in the Payment Integrity Team using technologies like Stored Procedures powering Excel Reports, STRATA, Business Object and “Power BI”

• Implement and maintain daily, weekly, monthly and ad hoc reporting needs for the audit team using complicated Macros, PIVOT tables and advanced formulae involving mathematical and statistical calculations and by using functions in Excel.

• In charge for auditing from daily task reports to complete overview for the auditing bodies and prepare various reports specific to clients including insurance companies, hospitals and government organizations.

• Develop Interactive Reports using Complex T-SQL queries with multiple aggregation calculations and Stored procedures to support scheduled and ad-hoc data reports using SAP Business Objects and STRATA JAZZ

• Design analytical models in MS ACCESS integrating multiple databases to retrieve data in an efficient way.

• Retrieving data from varied sources like EPIC, MOCHA SOFT and other healthcare systems and convert business processes and requirement into analytical and report friendly model in compliance with HIPAA regulations.

• Automate and Mange Reports Delivery to “Microsoft SharePoint” using “Microsoft Flow” and

“Microsoft Power Automate”.

• Migrate Reports to Microsoft AZURE and other Office 365 products such as Excel, PowerPoint Presentation and Power BI using complex PowerPivot and DAX programming.

• Document Standard Operating Procedures (SOP) for Designing, Building, Maintaining and Efficient Delivery of Reports.

• Assist other departments in using HIPAA Compliance tools and help them navigate the compliance process including testing and QA of those tools.

• Research New and Efficient techniques for data reporting and data management. Data Analyst, Data Operations at Winsupply May 2019 -August 2019

• Working with all departments of Winsupply for E-Commerce platform as a part of Data Operations as needed to gather requirements for enhancements to existing solutions or gather requirements for brand new solutions including software solutions, processes and implementations. Dhruv Jain CRCR

adhvwh@r.postjobfree.com 513-***-**** www.linkedin.com/in/DhruvKJain github.com/jainda09

• Designing and Developing ad hoc reports using Tableau for the Data Operations team after extraction of data from Data management tools like Informatica and SAP ERP.

• Managed to migrate SAP data into Informatica using SAP Business Objects as an ETL development process, which is further processed for analytical reporting.

• Maintaining Existing SQL Code and monitor its performance and contribute to its Improvement

• Developing macros to determine the type of products and their classification before implementing in MDM database and e-Commerce website.

• Responsible for Data Collection, cleaning, validation and analysis using Excel and presentations using PowerPoint for Clients during new product development and implementation stage with experience in end to end project management.

• Involved in QA of the products before and after migrating to Informatica using macros. Jr. Data Analyst, Market Research at Reliable Field Solutions May 2015-June2017

• Analyze Market Research Survey Data and performed market research and segmentation analysis for clients using SAS, R, SQL and Excel, get the potential target customers and identify the market trend and opportunities. Also worked on internal side of HR data related to freelancers and employees who conducted research for the clients.

• Involved in designing, building, maintaining and troubleshooting daily, weekly, and monthly reports and dashboards tools like Tableau or Microstrategy and scheduling them to run at specific time.

• Hands-on experience in creating solution driven dashboards by developing different chart types including Crosstab, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs and Histograms in Tableau Desktop.

• Involved in developing code to clean and validate data collected from multiple data sources like SQL server, MySQL, Flat files (Excel, CSV, TSV) and Access Database.

• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations using process testing cycle before migrating to Tableau for visualizations.

• Developed comprehensive reports based on marketing, sales trends, and demographic data analysis.

• Managed and developed reports that aligned and simplified monthly business reviews, annual planning, and forecasting processes. Created technical documentation and presented information to senior management including ad-hoc analysis and reporting as per user requests for managerial meetings and discussions.

PROJECTS

Data Visualization of research on Hospitals in USA Jan 2019-April 2019 Created Visualizations and tried implementing Tableau as interactive interface design based on the hospital data to see which hospitals to be preferred depending on the situations or also to help people to choose the best serving hospitals for them.

Embedding SQLite Databases Feb 2018-May 2018

R was used to communicate with SQLite databases: using the RSQLite package and using the sqldf package. Used RSQLite to map data from flat databases to relational databases. Normalization of data using sqldf and dbplyr packages into R data frames which were imported into databases. Dhruv Jain CRCR

adhvwh@r.postjobfree.com 513-***-**** www.linkedin.com/in/DhruvKJain github.com/jainda09 MANET Attack Simulation, Final Year B. Eng Project June 2016-May 2017 The different attacks, responsible for network and packet losses were simulated for analysis in Wireless ad- hoc networks using NS-2 simulator. Modified AODV, OLSR and other ad-hoc protocol were also implemented using TCl scripting in a Linux environment.

EDUCATION

Master of Engineering, Computer Science August 2017 -April 2019 University of Cincinnati, Cincinnati, Ohio

Bachelor of Engineering, Electronics and Telecom Engineering July 2013-June 2017 K.J.Somaiya College of Engineering

CERTIFICATIONS

HFMA’S Certified Revenue Cycle Representative (CRCR) 2019-2022 Healthcare Financial Management Association

HIPAA Education and Security 2019

Bon Secours Mercy Health

Diploma in Project Management 2020

Alison Learning and Education

REFERENCES

John Hunter, Manager, Payment Integrity Analytics, adhvwh@r.postjobfree.com,513-***-****

Contact this candidate