Deepti Bahel

• Collaborate with the marketing analytics team to build data pipelines using Azure Data Factory.
• Streamlined data collection methods to improve quality control measures and minimize errors in analysis results.
• Developed custom data analytics solutions, leading to improved operational performance and strategic planning.
• Enhanced data-driven decision-making by implementing machine learning models in python to predict the conversion rate on websites. and algorithms.
• Created a customer segmentation model for the loyal customers based on customer behaviour attributes using sckit library in python.

• Collaborated with HR Business Partners to understand different KPIs and metrics.
• Designed and developed dashboards for human capital - performance management metrics using MS Access and VBA, shortening review cycle by 50%.
• Utilized SAS,Oracle, MS ACCESS, Excel and VBA for data intelligence and analytics.

• Collaborated with cross-functional teams to design innovative business intelligence solutions.
• Developed Operational Metrics Dashboard in PLX which helps in measuring the performance of the workforce, which helped in improved the workforce productivity by 10%.
• Identified the key metrics for productivity measurement.
• Streamlined the data collection process by automating the sql scripts and data pipelines and identifying the gaps in data.
• · Develop dashboards in Looker to report key learning metrics to senior management.
• Refractor the existing data pipeline codes to reduce the query execution time by 30%. Deprecate old and redundant tables in Google BIgQuery.
• Create training material and documentation for Cookbook on Looker Views and Google BigQuery datasets.

Client: First Tech Federal Credit Union

• Work with data engineers and program managers of First Federal Credit Union to understand the customer needs and concerns regarding Oracle database migration to Snowflake.
• Created source to target mapping dashboard in Tableau to streamline the data mapping process.
• Performed Exploratory Data Analytics (EDA) on customer financial data using Snowflake.
• Automate and optimize the data quality check process by creating alteryx workflows, reducing the manual time by 70%.
• Create business stories in Jira to report various data quality issues.
• Created a comprehensive documentation and checklist focussing on the Data Governance around different loan products and mortgages to streamline the database testing process.
• Mentored and managed teammates by conducting training sessions on Zoom and creating training material.

Client: Google

• Collaborate with the Supply Chain team of Google to build internal tools and processes using PLX and Google BigQuery, providing better proactive detection and reactive support of data issues.
• Collect, clean and manipulate data from 6+ different sources using Google BigQuery, optimize SQL queries for ad-hoc analysis.
• Consolidate data from different sources and present the findings of analysis to the Senior management team to drive the inventory management process. This led to overall improvement of 5% in the inventory management workflow.

Client: Wayfair

• Collaborate with the Transportation team of Wayfair to develop and design KPI’s and metrics for measuring the performance of different carriers.
• Conducted statistical analysis and tests to measure the carrier performance, with 75% improvement in model accuracy.
• Designed and developed Carrier Performance tracking Dashboard using Google Data Studio to measure the performance of different carriers. Consolidate data from different sources and present the findings of analysis to the Senior management team to drive the inventory management process. This led to a 5% decrease in transportation cost.
• Migrated complex SQL queries from SQL Server to Google BigQuery and built a dashboard using Tableau.

Client: First Tech Federal Credit Union

• Work with data engineers and program managers of First Federal Credit Union to understand the customer needs and concerns regarding Oracle database migration to Snowflake.
• Successfully conducted quality checks on 100+ objects.
• Created source to target mapping dashboard in Tableau to streamline the data mapping process.
• Performed Exploratory Data Analytics (EDA) on customer financial data using Snowflake.

• Create roadmap for new product launch.

Client: Google

• Collaborate with the engineering team and program managers of Google to build internal tools and processes, providing better proactive detection and reactive support of data issues.
• Led version control of dashboards and data pipelines by reviewing codes of other team members.
• Collect, clean and manipulate data from 6+ different sources using SQL, optimize SQL queries for ad-hoc analysis and present insights to senior management.
• Developed SLA tracker dashboard using Tableau and PLX to measure the efficiency of the team, reducing 6-7 hours of manual work on a weekly basis.
• · Migrated 10+ dashboards from Google Data Studio to more interactive Tableau dashboards. This involved adding filters, parameters and calculations in the tableau.

Client : American Honda

• Collaborated with vendors, administrators and owners of third-party databases to establish data mapping plans and methods, enabling the sharing of data.
• Design, develop and enhance dashboards by writing or editing SAS, SQL queries, stored procedures or functions, reducing automobile defect rate for American Honda.
• Modernized old windows applications (SQL Server 2004, SAS 9.2, Windows 2004) to latest platform (SQL Server 2012, SAS 9.4, Windows 2012) by creating inventory of existing code structure, automating the process to compare production and test codes in QA process, and ensuring smooth functioning of UI apps and data integrity at end of migration.
• Created roadmap for migration of windows applications (SQL Server 2004, sas 9.2, Windows 2004).

• Developed an innovative model for ETL using VBA and SQLG to update, consolidate, manipulate and report loan application data in SQL and automate emails, reducing processing time by 95%.

• Mentored and coached 6 teammates on SQL and VBA and improved the manual process of creating deliverables, saving 98% time originally spent and redirected focus to quality of analysis and recommendations.
• Created interactive dashboards using tableau for PayPal to analyze customer data and identify optimal website navigation paths to enhance customer experience and reduce customer drop-offs by 6%. This project involved designing and running A/B testing experiments on variant and control groups.
• ·Create tableau based dashboards for the sales team of a leading fmcg company to track revenue. This project involves collecting data from salesforce, cleaning and consolidating the data and presenting the dashboard to the client. As a result, revenue increased by 3% annually.
• Honored with “Client Appreciation” awards for initiating value creation by proactively identifying process improvements and driving change for Philippines based Telecom company (Globe Telecom).

• Analyzed marketing campaign data using SWOT methodology for a leading pharma company resulting in Improving the customer lifetime value score by 8%.