Rutuja Narendra Pabale

617-***-**** ad3bpo@r.postjobfree.com https://www.linkedin.com/in/rutujapabale/ PROFESSIONAL EXPERIENCE

CVS Health Data Platform & Cloud Implementation Intern May 2023 – Aug 2023

• Worked with the cross-functional team to design a flexible ingestion framework in Google cloud, providing a data platform for data ingestion from multiple sources/clients to deliver a common data model and data layers to deliver projects & products.

• Designed and set up data ingestion (ETL) pipelines using Apache Spark on Google Cloud Dataproc, from the GCP Landing bucket into organized formats for downstream analytics use.

• Applied advanced business rules and executed rigorous data validation checks using Python scripts, ensuring the accuracy and integrity of the data flow from the staging environment to the landing zone in BigQuery.

• Optimized Pub/Sub-triggered Cloud Function, reducing data processing latency by 15% and enhancing data pipeline reliability.

• Gained experience on how to use Google cloud monitoring and Logging and addressed bottlenecks in data ingestion workflows.

• Prepared end to end documentation for Electronic Data Interchange (EDI) process for Risk Adjustment Project.

• Collaborated with the data science team to craft a comprehensive visualization board using Tableau assessing the effectiveness of a vaccine drive campaign, ultimately contributing to a substantial reduction in insurance claims for the company. The Delivery Company Business Analyst Jul 2020 - Dec 2021

• Planned and executed a subscription model for active customers, aligning with the company's business strategy and leading to a 30% increase in orders and enhanced recurring revenue streams.

• Implemented CRM tools to strategically manage client relationships, resulting in an impressive 45% increase in customer retention rates.

• Leveraged Excel proficiency to streamline data cleaning and analysis processes, resulting in a substantial 20% decrease in common client issues.

• Assisted in developing KPIs, and tracked KPI progress with data visualizations using Tableau for KPIs that reduced manual reporting by 10 hours weekly.

• Conducted requirement gathering and gap analysis to align business solutions with project scope, identifying "As is" and "To be" processes, potential risks, outcomes, and advantages.

• Collaborated with Marketing & Sales teams to execute A/B testing, resulting in a 12% increase in orders and a 24% boost in revenue YoY.

• Studied market trends and user feedback, extrapolated data in Excel to understand customer needs, and presented key insights to stakeholders.

• Managed a team of 5, using JIRA to monitor resource allocation, track progress, identify bottlenecks, and ensure on-time deliveries.

• Executed effective change management strategies to facilitate seamless transitions in business processes, leading to enhanced client satisfaction.

• Presented data-driven insights to senior leaders, resulting in the implementation of cost-saving measures that saved $50,000 annually. HyNest Co-Founder & Managing Director May 2020 - Dec 2021

• Co-founded a mission-driven product company specializing in disposable antimicrobial products with a commitment to reduce waste by at least 10%.

• Formulated and executed a visionary product strategy and roadmap, resulting in a remarkable 56% quarter-over-quarter (QoQ) revenue growth.

• Managed all aspects of the company including new product development, IT, marketing, sales and recruiting.

• Collaborated closely with design and marketing teams, achieving an impressive 80% improvement in user experience and brand engagement.

• Managed vendor relationships for product needs, skillfully negotiating contracts, leading to a 5% reduction in product costs.

• Streamlined the supply chain by optimizing inventory levels and reorder points, ensuring product availability while reducing holding costs by 12%. ACADEMIC PROJECT EXPERIENCE

Covid Vaccination in The United States – Tableau, SQL, Excel (Mar 2023)

• Spearheaded an extensive data analysis initiative focused on Covid vaccination, meticulously investigating 200k records using Excel's advanced tools, including Pivot Tables, Macros, VLOOKUP, and various calculation functions, for efficient data extraction and analysis.

• Utilized Tableau, SQL and statistical modeling techniques to gather, organize, and present datasets for impactful visualizations and performed regression analysis, resulting in a determination of a 54% nationwide survival rate. Movie Recommendation System – Tableau, Python (April 2023)

• Prepped IMDB and Rotten Tomatoes data and used K-nearest-neighbors in scikit-learn to build an improved movie recommendation system

• Saved an average of 17 minutes on movie selection relative to previous methodology

• Built visualizations in Tableau to show how ratings changed and how the model performed over time. Identifying Dangerous Commercial Truck Drivers - Big Data, Tableau (Sept 2023)

• Spearheaded the utilization of Big Data technologies, including Hadoop and Hive, to ingest and analyze commercial truck driver data, enabling data- driven insights into risk factors and identifying high-risk areas, such as San Bernardino

• Seamlessly integrated HDFS with Tableau via a JDBC driver, facilitating comprehensive data visualization and analysis for informed decision-making Toxic Comment Classification- Deep Learning, Text Classification, Python (Nov 2023)

• Trained 7 classification models to build a multilabel classification problem to classify hate comments in different classes like toxic, severe toxic, threats, etc. from the social media comments.

• Achieved 97% accuracy in Multinominal Naïve Bayes, Logistic Regression, and Binary Relevance with SVM. EDUCATION

The University of Texas at Dallas

Master of Science, Information Technology and Management Savitribai Phule Pune University

Bachelor of Engineering, Computer Science

SKILLS AND TOOLS

Technical Skills: Python, R, SQL, AWS

Tools: Google & Adobe analytics, Power BI, Tableau, Excel Certification: AWS Cloud Practitioner, Google Data Analyst Professional

Contact this candidate