Experience

Community Mental Health for Central Michigan

• United States
• Mental Health Care
• 1 - 100 Employee

• Data Quality Analyst

  • Nov 2018 - Present

  Perform data analysis to support decision-making with the goal of improving the quality and performance of agency activities. Utilize a variety of analytic techniques ranging from simple data aggregation to relational analyses to complex data mining related to healthcare risk factors, quality and compliance measures, utilization data, and financial data. Utilizing SQL queries to complete data visualizations and develop dashboards for clinical supervisors, teams, and administration utilizing Excel, Access, Power BI, and Logi Analytics. Participate in report preparation/analysis to meet internal and external data reporting requirements. Validate data and information including monitoring and investigating data quality issues. Examine complex data to identify historical variances, future forecasting, and outliers by building aggregate, scalar functions from SQL and creating visual basic scripts using visual studio. These variances and forecasting inform the leadership of potential performance and program issues including information on performance indicators, key performance metrics, outcome metrics, and longitudinal staff performance and clinical documentation. Actively participate in cross-functional and interdepartmental project teams and workgroups, providing process measurement and outcome measure consultation for stakeholders. Perform data analysis using tools like Power BI, R Studio, Logi Analytics, Advanced Excel – Power Pivot, SQL server, etc. Show less



West Michigan Community Mental Health

• United States
• Mental Health Care
• 1 - 100 Employee

• Business/Data Analyst

  • Jan 2018 - Oct 2018

  Worked closely with the Information Systems Team and electronic medical record (EMR) system vendor to define and grow EMR capabilities that enhance Clinical Business Intelligence for the organization. Worked with the Information Systems Team and organizational leaders, to assist in the development of internal and external dashboards to measure progress/success. Conducted end-to-end analysis of service programs from data capture to presentation; capturing and analyzing data, and report findings using a variety of statistical techniques. Provided internal and external data analysis and management for analyzing organizational performance, business modeling, strategic planning, quality initiatives, and general business operations. Conducted, studied, gathered, and analyzed data from various sources including but not limited to the internal data warehouse, and externally available research data, public data, and other data sources to develop reports, summaries, recommendations, and visual representations. Advised and assisted Service Enhancement Team and other WMCMH staff to determine the appropriate analytical methodology to meet their objectives. Utilizing statistical methods and software to develop and interpret statistical results. Formulating and maintaining, a set of benchmarks and Key Performance Indicators (KPIs) for WMCMHS with other stake holders. Analyzing new developments in data mining, data visualization, predictive analysis and statistical methodologies through research, education and training. Show less



Magus IT Solutions Pvt Ltd

• IT Services and IT Consulting
• 1 - 100 Employee

• Business Analyst

  • Dec 2013 - Mar 2015

  Gathered requirements from the business and technical end to develop the mainframe and the web portal backend. Developed Business and Functional Requirement Documents, Use Case diagrams, business flow, and Activity/State diagrams so that developers and other stakeholders can understand the business process. Gathered and analyzed user and business requirements through interviews, surveys, prototyping, and observing from account managers and UI (User Interface) of the existing proposal genera on the system. Designed and developed process flow diagrams, activity diagrams, and fishbone diagrams in MS Visio Performed Business Process Modeling using Visio. Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams and thus defining the Business Process Model and Data Process Model . Analyzed As-Is and To-Be Processes and followed Business Process Modeling (BPM) . Documented and delivered Functional Specification Documents to the project team. Documented Use cases and developed Use Case Diagrams and Activity Diagrams using MS Visio. Performed various SQL operations in order to retrieve data, add databases, and add tables. Worked on MySQL databases to understand the migration from legacy tool to new tool. Show less