Data Scientist Intern @ Valor Compounding Pharmacy, Berkeley, California
Duration: June 2022 - Present
Manager: Ann Olaguer, Director of Business Intelligence and Analytics, Valor Compounding Pharmacy
Roles and Responsibilities:
- Created and assisted Data Pipelines using Company’s current Data Stack of Talend, Snowflake and Tableau
- Extensively used Talend Data Studio and Pipeline Designer
- Used JSON API to extract employee shifts data from Homebase and highlighted key metrics
- Data Mining and Analysis for the Lifetime Value of a Patient
- Created Pulses for fluctuation of volume for number of prescriptions filled by top compounds to create a notification when a Rx’s (prescription) are falling below average
- Built multiple data flows using Tableau Prep for business use
- Used Google analytics data for generating key insights
- Analyzed of True Compound cost including LOA and other factors as specified for each KPI’s
- Improved custom SQL queries to reduce the data query load time
- Run Data Jobs
- Customized Tableau Server by adding Landing Page for user specific login and navigation to dashboard
- Exercised Data governance for collection and management of data
- Optimized Tableau Dashboards to ensure performance and quality of visualization
Technology Student Assistant @ Instructional Technology Services, San Diego State University
(Aug 2021 - June 2022)
Manager: Aurora Velasco, Associate Director, Instructional Technology Services
Roles and Responsibilities:
- Provide SDSU faculty, academic leaders and the SDSU community with high quality, innovative learning technology services, resources, and environments
- Collaborate with faculty to continuously improve teaching and learning with technologies
Data Scientist / Solution Engineer @ Saviant Consulting, Pune, Maharashtra, India
(April 2019 - July 2021) : Full-time
(July 2018 - April 2019) : Contract Employer (Techknomatic Services)
Manager: Rajat Khare, Vice President - Business Excellence and Operations, Saviant Consulting
Roles and Responsibilities:
- Sentiment analysis of responses by parsing the user feedback fetched from surveys & sites using LSTM
- Developed targeted campaigns/surveys in order to use users’ search queries and show them related surveys
- Received Exceptional Excellence award (July’19) for saving almost 60K USD licensing cost through improved data analysis & optimal usage of product licenses
- Predicted next word using n-gram (1,2 or 3 grams) model based on seen and unseen combinations
- Predicted sales for the window of 2 years using an ensemble of self-tuned ARIMA (ACF & PACF) and LSTM
- Conceptualized & implemented org-level ALM activity for automated reporting on SDLC phase, Engineering process, HR demographics, Resources & hiring gap analysis, Web & Sales analytics
- Performed supply-demand analysis of top business units to identify opportunities for the distribution channels of customer business
- Finalized workflows, payloads, actions and alerts on the reports from end user perspective
- Evaluated ensemble of dashboard models to optimize perplexity, accuracy and computation time
- Spearheaded and conducted training on advanced BI tools for 60 associate-level employees of reputed MNCs
Business Intelligence Consultant @ Honeywell, Pune, Maharashtra, India
(Aug 2017 - July 2018) : Contract Employer (Techknomatic Services)
Manager: Chaitanya Kelapure, Senior Project Manager, Honeywell
Roles and Responsibilities:
- Collected & analyzed business requirements covering the entire tableau DLC since past year
- Provided hierarchical access rights on specific dashboard using RLS
- Improved dashboard load performance by 30% by optimizing calculative fields & adding context filters
- Evaluated reports for what-if analysis & ABC analysis using parameters and LOD calculations
- Prepared Data cubes & Metric Sets using views, for frequently used metrics and KPIs
- Developed dashboards by establishing parameter binding with filter controls for data slicing & dicing
- Customized time-dimension & hierarchies to change aggregation levels of reports at initial load stage
- Enabled widget toggling using layers with radio-buttons, facilitated pop-ups and navigation links for multi-page reports for ease in interactivity of reports
