Post Job Free

Resume

Sign in

Lead Data Analyst Manager

Location:
Ottawa, ON, Canada
Posted:
January 11, 2021

Contact this candidate

Resume:

RESHMA YEWLE

+1-832-***-**** • adjclu@r.postjobfree.com • Ontario • www.linkedin.com/in/ryewle

Multilingual Supply Chain professional and Confirmed Permanent Resident of Canada (COPR) awaiting landing, currently in the US, with experience in analytics, procurement, supplier and contract management with two Master’s degrees, seeking opportunities in planning, purchasing and vendor management in Ontario WORK EXPERIENCE

Prime Healthcare, Top 15 US Health System September 2019-Present Lead Supply Chain Analyst Dallas, Texas

• Led a team of analysts during the $350 million acquisition of a healthcare system by Prime to consult C-Suite on adopting over 1,000 supplies, purchased services and capital procurement contracts

• Presented an analysis of a $9 million Request for Proposal (RFP) award for secondary distribution of laboratory products containing price, product portfolio, GPO volume optimization and service levels metrics to C-Suite

• Improved visibility of costs and savings opportunities by developing an automated financial expense model collating multiple, large datasets containing $500 million of annual purchasing spend across 45 hospitals

• Recommended changes to Prime’s office supplies formulary by evaluating historical usage, facility-specific requirements and vendor limitations to reduce small order fees and $850k of non-formulary, off-contract spend

• Captured cost savings for CRM and DES (coronary) categories by conducting market basket contract analytics

• Liaised with Value Analysis Committee to execute GPO contract conversions, promote utilization and compliance

• Audited physical inventory counts and built comparative inventory position reports to increase turnover of high dollar volume manufacturers and retire slow moving, obsolete (SLOB) products BroadJump LLC, Healthcare Supply Chain Consulting June 2017-September 2019 Healthcare Supply Chain Data Analyst - Tech Ops Dallas, Texas

• Enabled the acquisition of 10 new, mid-large client hospital contracts by managing 60, multi-million row RDBMS T-SQL databases, executing ETL processes, writing queries and stored procedures for custom spend reporting

• Designed Lawson and Meditech ERP data scripts matching new software specifications to broaden operational analysis while collaborating with sales-client managers, internal product development and client IT teams

• Reduced turnaround time of secure file transfer processes (SFTP) by 30% by reorganizing analysts’ workflow

• Identified savings initiatives via industry benchmarking, expenditure and utilization trend analysis formulated using statistics, comparative pricing research and BroadJump’s spend recognition engine

• Boosted AI recognition tool by devising global rules on data integrity and supporting QA with UI design, testing

• Researched and classified over 3000 Physicians Preference (PPI) items to augment med-surg product catalog Medtronic- Diabetes, Continuous Glucose Monitoring May 2016 - August 2016 Supply Chain/Ops Graduate intern - Consumables Northridge, California

• Represented the supply chain team in a Make vs Buy decision by analyzing costs, resources, process-mapping value chain flows and coordinating with internal departments, proposed vendor and contracted 3PL provider

• Revamped the returns materials (from Puerto Rico to Northridge) authorization process thus creating new SOP

• Built analytics dashboards showing inventory and purchasing spend KPI’s, build and price variances (PPV)

• Created PO’s in SAP, ensured FDA compliance and released shipments to production as an R&D chemicals buyer

• Designed risk- capacity assessment supplier scorecards, updated backorder and product availability metrics to improve CGM consumables service levels

• Conducted AQL sampling and fish-bone analysis in a CAPA investigation to remedy supplier quality defects Swift MultiPrint & Packaging Pvt. Ltd, Corrugated Box Manufacturing May 2014 – July 2015 Specialist, Supplier & Inventory Control Mumbai, India

• Translated client specifications into prototypes for client and CEO approval by production scheduling tasks

• Streamlined vendor management by building supplier profiles, scorecards and implementing RFX processes

• Reduced order quantities by 15% by tracking inventory levels and employing lean root-cause analysis techniques EDUCATION

The University of Texas at Dallas-Naveen Jindal School of Management May 2017 Master of Science in Supply Chain Management, Certified in Transportation and Logistics (CTL) GPA: 3.9 Scholar of High Distinction, Dean’s Impact Scholarship University of Mumbai, Mumbai, India March 2014

Master of Arts in Economics GPA: 3.5

Narsee Monjee Institute of Management Studies, Mumbai, India July 2011 Bachelor of Business Administration GPA: 3.4

ADDITIONAL INFORMATION

• Technical skills: SQL (Joins, Subqueries, Temp tables), Lawson MMIS, SAP APO, Advanced Excel (Lookups, Pivots, Macros), MS Office (Project, Visio, PowerBI), Tableau, Smartsheets

• Manager and Tutor of the Graduate Mathematics - Statistics Lab at UT Dallas from January to May 2016

• Communications Officer of the Supply Chain Leadership Council, UT Dallas from September 2015 to May 2016

• Honor Societies: Beta Gamma Sigma, Phi Kappa Phi, Golden Key International



Contact this candidate