• Perform Ad hoc data analyses for PAIN franchises- Extract, combine, summarize, and visualize data from multiple data sources- Process and analyze data using SAS, Tableau Prep, SQL, Python, R and Excel• Develop and maintain Tableau dashboards for executive leadership• Performed duties as Sales Ops analyst for Radiofrequency Ablation franchise (RF)- Produced monthly and quarterly sales reports and visualizations for RF- Updated and maintained RF Anaplan modules and lists

• Performed Ad hoc data analyses- Pulled, summarized, and visualized Sales Ops data from Tableau Server, SalesForce, and AWS data sources.- Processed and analyzed data using SAS EG, Tableau, R, Python and Excel.• Tracked progress for Management by Objectives goals and calculated payouts on a quarterly basis.• Analyzed new, lost, and existing physician data by various categories.• Matched National Provider Identifiers to physician records in SalesForce. - Used SAS EG to clean and join name and city/state data.- Utilized Python to perform fuzzy string and double metaphone name matching.• Analyzed physician level time series data to determine which doctors switched between products• Analyzed territory level campaign event data to identify correlation between event growth and trial growth.

• Performed inspection readiness activities.- Reviewed Amgen Trial Master File (TMF) content related to Interactive Response Technology (IRT) for completeness and accuracy.- Filed documents and made corrections to TMF where needed.• Produced reports for the IRT team.- Generated and processed Excel reports from Veeva eTMF and MERIT systems.- Utilized Tableau Prep to extract, clean, and join various data sets.- Created Tableau visualizations.• Helped with IRT SharePoint site development and maintenance.

• Performed trending and statistical analysis on complaint data to monitor the performance of devices in the field.- Generated control charts and alert limits to monitor complaint rates and detect signals.- Identified signals and conducted investigations regarding potential non-conformances.- Performed survival analysis in SAS to track product reliability.- Performed risk ratio analysis and hypothesis testing to compare performance between products.• Produced reports for upper level management and divisional complaint review meetings.- Pulled data from multiple reporting systems (SAP, NetRM, TrackWise).- Cleaned and analyzed data.• Used SQL to extract, join, and summarize complaint data via Hue Impala.• Conducted ad-hoc analyses with complaint data in support of Marketing, Regulatory, Clinical, and R&D departments.• Provided data analysis for abstracts and posters presented at industry conferences.• Used SAS to automate a time-consuming process for generating random samples of complaint data for internal audits.• Created and maintained MS Access databases which housed surgery and sales information.• Tested/validated SAS reports for the global complaint management system.

• Produced weekly, monthly, and quarterly reports for senior level staff.- Created marketing summary reports using SAS, which displayed quote, new policy, and conversion rate statistics.- Forecasted gift card take rates for the Go Green program.• Generated comprehensive summary reports for the states in the West Region.- Utilized SQL and Cognos Query Studio to query multiple databases for quote, policy, and loss data.- Performed analysis using Excel pivot tables that pulled data from Oracle sources and computed a variety of custom statistics for different population segments.• Assisted West Region actuaries with rate changes and filings.

• Developed statistical models for forecasting the monthly peak electric load for the entire Pacific Gas & Electric (PG&E) service territory.- Produced multiple regression models using historic load, temperature, and economic data.- Evaluated model performance and used the best model to generate a 10 year forecast.• Provided analytical support for the Planning Reserve Margin modeling effort.- Used regression analysis to model seasonal loads associated with extreme weather events.• Used SAS to compute benchmark temperature statistics from simulated weather data as produced by a study from the National Center for Atmospheric Research.- Generated system-level temperature statistics from 900 daily simulations of 60 years of weather data.- Performed regression analysis to produce temperature benchmarks for a 10 year forecast horizon.• Produced customer count and energy usage forecasts for a Demand Response study.- Employed exponential smoothing models to project customer counts and usage by class and region.• Served a temporary assignment in the Market Risk Management Department.- Assisted the group with model validation.

• Produced operational metrics, statistics, graphical output, and ad-hoc analyses for upper and executive level management.- Used SAS to query and manipulate large volumes of data from Oracle databases.- Provided analysis of cycle-time metrics to help identify bottlenecks and drive process improvement.• Developed resource forecasting tools using SAS. - Used both historic and planning data to project clinical site initiations and close-outs for the site monitoring force. This tool simulated various workload scenarios which aided in the determination of appropriate resourcing strategies.- Automated a resource modeler that was used to forecast staffing needs for a department of over 200 full-time & 60 temporary employees. This forecast had previously taken hours to generate manually. • Lead SAS programmer for the Global Study Tracker, a daily report used within the Research & Development organization to track the progress of all Global Development studies.- Used extensively by upper management to track the lifecycle of all Amgen studies.- Unified the process and identified gaps in data for the following departments and systems: Clinical Supply Chain Management (clinical drug supply shipment), Contracts Management Group (pricing and contracts), Clinical Field Operations (planned and actual site monitoring visits), Clinical Research Services (global site enrollment status), Clinical Trial Operations (tracked key regulatory milestones dates), Interactive Voice Response System (subject data feed).

• Analyzed operational clinical data for the Biological Samples Management department.• Developed Global Patient Enrollment Forecasting tool.

• Taught discussion sections, averaging 30 students per class.• Taught calculus for biology, economics, and engineering majors, as well as basic linear algebra and probability theory.