Sharmila Mohan Email & Phone Number

Keller, Tx, Us

Westlake, Texas

Fort Wayne, Indiana

▪ Lead a team of 11 Business Intelligence Developers ▪ Scrum Master for BI team bi-weekly Sprint▪ Lead team members in development of reports, dashboards, data extracts, ad hoc queries, and other BI solutions ensuring consistent documentation and change control conformity ▪ Work with clinical and business stakeholders to gather and analyze requirements, design specifications, and ensure user acceptance testing and complete delivery of reporting/analysis solution using Epic’s Clarity database, Caboodle data warehouse, Tableau, SQL, Crystal Reports, RW SQL and other business intelligence platforms ▪ Lead the work effort of the team and provide feedback to Manager and team ▪ Involved in project management and team resource assignments for all projects▪ Lead weekly team meetings to review team members workload and review/assign current reporting backlog▪ Lead quarterly Epic Upgrades for BI – Reporting Content ▪ Participate in weekly meetings to review incoming report requests, identify best reporting tool for requests and assign to appropriate reporting queue using Cherwell (ticketing system)▪ Streamline existing processes, create appropriate process improvement documents, and disseminate information to team▪ Experience building complex dashboards using clinical databases, HR databases, and various other data sources

Fort Wayne, Indiana

Huntington, West Virginia Area

Charleston, West Virginia Area

-Developed Requirements Traceability Matrix based on requirements gathered during discovery sessions-Developed test plans, test cases and test scripts-Conducted User Acceptance Testing (UAT) and maintained defects reports-Created Functional Design Documents and Technical Design Documents-Assisted trainers during training of UAT testers-Assisted end users during first wave roll-out of document imaging solution

Gainesville, Florida

-Developed new reports generated from the Medical Management Platform and maintained existing reports for Medical Operations using Microsoft SQL 2005/2008 and Crystal Reports-Worked with end users to determine reporting and data extraction needs by gathering business requirements and documenting all processes-Designed, configured, and tested letters, including but not limited to denials, initiative notifications, case management letters, On Call notifications, and other general communications in Crystal Reports-Ensured that confidential PHI (protected health information) member data was not included in reports generated for outside entities -Assisted in configuring the Medical Management Platform to provide consistent, accurate and useful data for the management of members and medical programs-Conducted routine gap analysis to evaluate for opportunities to design and implement new or revised reports that effectively support Medical Operations departmental and individual performance initiatives-Reviewed & evaluated reports for regulatory compliance, accuracy, and redundancy -Made recommendations for improvement opportunities, created business rules, validations and audit tools in an effort to maximize data integrity in new and existing applications-Established process for ad-hoc report request submissions -Assisted in the conversion of data from existing system to new systems during implementation-Developed specification documents in accordance with regulatory requirements such as NCQA and CMS-Conducted regression testing to ensure Medical Management Platform functioned correctly after software upgrades

Gainesville, Florida

-Extracted and cleaned medical records data and clinical trials data using SAS -Analyzed data using statistical methods for research publications-Created prediction models using data mining algorithms via SAS Enterprise Miner

-Developed and maintained FOCUS and SAS programs to extract files and report on data from mainframe Student Information Systems (SIS) and Human Resource Systems (HRS)-Prepared, analyzed, and summarized information into reports in response to ad hoc requests from Oklahoma State University administrators, faculty, students, and from agencies outside Oklahoma State University-Prepared periodic management reports such as the Student Profile book, Mini Fact Sheet, Big 12 Data Exchange, Tuition and Fees, and the Common Data Set, as well as various national surveys (e.g. U.S. News Best Colleges Survey, ACT, Princeton Review, Peterson’s, etc)-Developed and implemented recommendations for maintaining efficient and streamlined FOCUS and SAS programs-Developed demographic and benchmarking reports-Coordinated and completed multiple projects simultaneously and met project deadlines-Liaised with co-workers and other university officials to gather data for projects-Taught Faculty and Staff how to create and run reports using FOCUS programming language in the IBM mainframe-Organized and conducted FOCUS User Group meetings for FOCUS users at Oklahoma State University A & M System

Master Of Science, Management Information Systems

Bachelor Of Science, Management Information Systems