Ryan Ferguson Email & Phone Number

Philadelphia, Pa, Us

Bala Cynwyd, Pa, Us

Philadelphia, Pennsylvania, Us

• Developed SAS model using PROC SQL to analyze over 34,000 rows of demographic and healthcare charges data from Medical Expenditure Panel Survey (MEPS) that results in the discovery of 90% charges to be attributed to only top 10% of consumers, with most others having no spending • Assisted research team of three on building dashboards using SAS to showcase the skew of consumer spending habits which initiated a research paper to suggest new healthcare systems for significant cost savings

Reston, Va, Us

• Created, with FIXED, LOOKUP, and INCLUDE, an advanced Tableau dashboard that revealed over 40% transactions with pricing discrepancies which was implemented to address underpricing of software packages for the purpose of recurring pricing performance evaluation• Built, in conjunction with the marketing team, a dynamic Tableau dashboard using graphs and maps to highlight performance by regions around the world to identify lacking/underdeveloped market to focus more resources on• Managed complex user permissions and data security access to company-wide Tableau Dashboards• Preparations of large data sets by joins, aggregation, and blending of data source

Philadelphia, Pa, Us

• Developed predictive models in Python with over 5-years' worth of customer booking data with variables such as time spent on a listing, number of clicks, and days from planned trip using techniques such as clustering and factor analysis that results in the discovery of booking probability model• Utilized SQL techniques such as unique key-based inner join, left join, right join, regular expression, variable drops and unique record selection to aggregate and manipulate different data sources

Philadelphia, Pa, Us

• Analyzed patient data using R with various techniques such as KNN imputation, clustering, logistic regression, and ROC curve to create a predictive model and maximize a given profit metric consisting of true positives as revenue and false negative as cost• Built a Chronic Kidney Disease (CKD) prediction model with an average sensitivity rate of 83% and awarded first prize for the most efficient statistical model using 60% less variables compared to other groups to predict CKD outcome using only five simple survey questions

Philadelphia, Pa, Us

• Developed dynamic valuation model with Excel using advanced functions such as PivotTable and Sensitivity Analysis• Delivered a successful stock pitch at Goldman Sachs within consumer staples and industrials sector using top-down approach with various financial modeling techniques such as DCF analysis and relative valuation resulting in an approved buy and sell proposal• Utilized FactSet to conduct in-depth research on over 18 different industries to identify attractive investment opportunities through analysis in factors such as macroeconomics, earnings, and multiples

Horsham, Pa, Us

• Utilized IBM Cognos TM1 (OLAP) to generate a three dimensional data to create daily reports based on insurance transactions with over 350,000 lines of data for three departments utilizing PivotTable, VLOOKUP, and SUMIF for budgeting purpose resulting in a more accurate forecast• Prepared and processed month-end journal entries including accounts payable accruals for month end close

Blue Bell, Pennsylvania, Us

• Profiled key Pharma Clients and circulated latest news to sales team via Bloomberg Terminal to assess opportunities and evaluate possible pricing to create an excel spreadsheet to track phases of different opportunities• Created PowerPoint slides for marketing managers to present new product development to potential clients• Delivered a formal training workshop for sales team on the use of the Bloomberg Terminal in profiling Pharma Clients to assess potential opportunities

Master Of Science - Ms, Business Analytics

Bachelor Of Science In Business Administration, Accounting And Finance, Minor In Software Engineering