Prasad Ugale Email & Phone Number

Jersey City, Nj, Us

Greater New York City Area

Buffalo, New York, United States

MGQ 201 - Mentored 100+ undergraduate students in foundational concepts of Statistics and MS Excel by conducting weekly lectures, facilitating grading, and providing additional support to improve their academic performance

New York, United States

New York, United States

- Analyzed claims data to identify providers’ prescribing patterns, and uncovered key insights on variations in drug prescriptions for similar treatments, assessing the effectiveness of economical alternatives- Utilized Pandas and SQL for data cleaning and pre-processing of claims and members data, ensuring HIPAA compliance, and leveraged Tableau for comprehensive data analysis- Successfully identified cost-effective alternatives, driving a 30% reduction in treatment costs, consulted… Show more - Analyzed claims data to identify providers’ prescribing patterns, and uncovered key insights on variations in drug prescriptions for similar treatments, assessing the effectiveness of economical alternatives- Utilized Pandas and SQL for data cleaning and pre-processing of claims and members data, ensuring HIPAA compliance, and leveraged Tableau for comprehensive data analysis- Successfully identified cost-effective alternatives, driving a 30% reduction in treatment costs, consulted implementation of lower-cost alternatives enhancing the patient and provider experience Show less

Pune, Maharashtra, India

- Data Quality & Governance: Consulted with U.S. clients, & led a team of 5, to develop an in-house end-to-end Data Quality Framework to monitor data quality, created benchmarks, SOP’s & set triggers for reporting data issues & assisted client with issue resolution, operations, business reviews, stakeholder communication, documentation, creating ~$230 M impact- Growth Strategy & Marketing: Analyzed the patient level data, understood the patient journey for oncology drugs & uncovered factors… Show more - Data Quality & Governance: Consulted with U.S. clients, & led a team of 5, to develop an in-house end-to-end Data Quality Framework to monitor data quality, created benchmarks, SOP’s & set triggers for reporting data issues & assisted client with issue resolution, operations, business reviews, stakeholder communication, documentation, creating ~$230 M impact- Growth Strategy & Marketing: Analyzed the patient level data, understood the patient journey for oncology drugs & uncovered factors responsible for patient discontinuity at different treatment stages & provided actionable insights to client- Data Analysis and Automation: Led the Value & Access team of 4, where we analyzed large pharmacy claims data to monitor revenue leakages by detecting fraudulent claims; touched $3 B revenue, & automated the process using Alteryx, SQL & Tableau- Strategic Consulting: Led the Strategy & Analytics team of 3, where we assessed drug coverages across insurance plans & payers in the U.S. with client competitors leveraging statistical analysis to provide strategic insights on a monthly basis- Opportunity Identification & Solution Delivery: Identified cross-dataset validation opportunity across Managed Markets datasets, led the end-to-end project, from requirement gathering, development, SIT, & UAT, accommodated continuous changes; leveraged SQL, Alteryx & Tableau to monitor KPIs; implementation resulted in optimization of operations by ~30%- ModelN Processing: Assisted clients with claims adjudication & reporting on ModelN; submitted invoices, generated ROSI, PQAs, tracked disputed claims & payment discrepancies, maintained logs, drafted SOP, ensuring timely customer payment- Training & Business Development: Onboarded 10 new team members across Argentina, India & US on various projects, created project proposals, financials, ROI models, & comprehensive learning plans which reduced the onboarding time by 50% Show less

Pune, Maharashtra, India

- Data Modelling, Client Communication & Forecasting: Consulted with U.S. clients and led a team of 3, for a forecasting project where we built forecasting models using time series techniques, using historical sales & seasonality indexes, created tableau dashboards to assist clients with inventory planning for big 3, & specialty distributors, creating an impact of ~430 M- GTM Support: Assisted clients during drugs launches & acquisitions, by ensuring seamless data transition through data… Show more - Data Modelling, Client Communication & Forecasting: Consulted with U.S. clients and led a team of 3, for a forecasting project where we built forecasting models using time series techniques, using historical sales & seasonality indexes, created tableau dashboards to assist clients with inventory planning for big 3, & specialty distributors, creating an impact of ~430 M- GTM Support: Assisted clients during drugs launches & acquisitions, by ensuring seamless data transition through data pipeline, data quality, accommodating new drugs into database, & providing advanced analytics and strategy support- Process Enhancement & Stakeholder Management: Handled complex data issues, by fixing data lag, data losses, inconsistent metric definitions & formats, etc. during the source-aggregator-consumer flow, collaborated with stakeholders for updating contracts, & implemented best data quality practices & policies, to make data more usable, robust, compliant, and trusted- Agile Project Management: Assisted in client’s database technology transition from Azure to AWS by developing 20 Alteryx workflows which reconciled data across legacy & new systems; collaborated with cross functional business, technical, product & end users teams, ensured timely delivery, accommodated risk managements, customer feedback, and performed SIT & UAT- Analytical Ability & Problem Solving: Analyzed the pattern of reimbursement claims of the Medical Reps to detect fraudulent claims to increase the client revenue & automated the detection process by developing Alteryx Workflows & Tableau reports Show less

Aurangabad Area, India

- As a Planning Engineer at Mumbai Nagpur Super-communication Expressway, estimated the materials requirements, and cost of the civil structures and monitored the progress of civil structures and roadlayouts for client billing purposes- Analyzed the on-site requirements of the construction materials and helped in procuring them to ensure timely completion of the structures and road laying

Master Of Science - Ms, Business Analytics

Relevant coursework: - Predictive Analytics - Prescriptive Analytics - Data Visualization - Health Care Analytics - Marketing Research.

Bachelor Of Technology, Civil Engineering

Training and Placement Secretary: - Part of a 25-member team to interact with potential recruiters involving 150 firms for 1200 students.