My Analytics Portfolio
Work & Volunteering Experiences
Alder Home Security
Marketing Data Analyst
-
Designing scalable Power BI Reporting for Sales, Spend, CPA metrics helping executive leadership in improved partnership decision-making.
-
Led and mentored BI team for migration of 50+ Dashboards [DOMO to PowerBI] optimizing underlying SQL [CTE, Joins] data processing by 40%.
-
Wrote SQL, Python code for Leads generated from Affiliates/Channel Partners for calls assessment, campaign performance & pain points.
-
Scheduled 25+ SQL procedures to send customer insights, product backorders, consumer behavior, pricing emails to senior management.
-
Streamlined E-commerce engagement & traffic data in advertising funnel using Attribution Model, SSIS for transformation across databases.
Reach Financial [Previously Liberty Lending]
Business Data Analyst
-
Designed 30+ comprehensive SF Analytics & Tableau Dashboards for loan consolidation, revenue, amortization metrics for finance managers.
-
Developed scripts to query data from multiple sources using Virtual Machines, Salesforce APIs for meaningful data-driven Finance Reports.
-
Used AWS EC2 instance to schedule 20-25 scripts on production server while compiling task log files for tracking failure and success.
-
Delivered ad hoc business needs, ambiguous requests by developing Salesforce Recipes or Python scripts with automated reporting, completion notification functionality, scheduling tasks for many cross-functional teams like Go-To-Market, Product Growth & Operations Strategy.
-
Optimized infrastructure & robust ETL pipelines from python scripts, using Salesforce Recipe, workflows, Snowflake warehouses to automate data ingestion & manipulation, saving time by 25% deprecating manual processes for complex and large application, transaction level datasets.
-
Translated business requirements to data solutions & roadmap, maintained Data Quality & Accuracy by debugging bugs, discrepancies.
San Jose State University
Graduate Research & Teaching Assistant
-
Utilized D3.js library to design a dynamic heatmap visualizing Covid 19 cases worldwide in Visual Studio Code environment
-
Created an interactive data-driven web-based JavaScript viz and animation for projection mapping on CA Wildfires
-
Facilitated consolidation of excel data files and generating and populating data parameters for weather dataset
-
Taught students NLP, Web Scraping, Linear Modelling, SQL database in R and collaborated events at Girls Plus Data
KPMG Virtual Internship
Data Analytics Consulting Virtual Internship
Responsibilities
Data Quality Assessment
1) Analyzed Data Accuracy, Validity, and Consistency issues using Excel so as to effectively assess any underlying data quality issues within the dataset.
2) Understood the data quality issues and communicated those issues effectively with the client i.e. Sprocket Central via Email.
Data Insights
1) Explored data modeling for the customer demographics, new customer, and transaction data to understand the various trends and focus parameters for creating an effective customer targetting strategy.
2) Created a temporary strategy presentation for finalizing the top 1000 customers to be targeted by Sprocket Central Pty Ltd and to further conduct a more thorough analysis.
Data Insights and Presentation
1) Established RFM model in Excel by creating the three impacting parameters, i.e. Recency, Frequency, and Monetary.
2) Calculating and Visualized an RFM score for appropriate segmentation of Customers into more targeted customer titles in Excel and in Tableau.
3) Created a Tableau Dashboard having 2 data tabs with essential deliverables like profit over list prices, customers segmentation into targeted titles, High profit, and high customer count industries, and so on. This was proposed to Sprocket Central Pt Ltd for further analysis, audience targeting, and customer retention.
Infinite Options
Data Analyst Intern
Responsibilities
-
Web Team (Feed the Hungry, Prep to your Door, Serving Fresh) :
-
Modified schema, optimized MySQL joins & queries, performed Zappa Updates for API generation on the use case.
-
Created Tableau Dashboards analyzing donations, orders, inventory against React Viz before website integration.
-
Preprocessed scalable data pipeline by assessing client needs by streamlining data population, trends & insights.
-
Migration of DynamoDB queries to MYSQL AWS- RDS and integration with API endpoints using Postman
-
-
Mobile Team (Feed the Hungry) :
-
Feature Prioritization & Pushed API’s in mobile app with buttons for color-coded button filtering for food type
-
Edited the front-end visuals i.e. Headers, interactive button icons, and slider functionality in the FTH Mobile app
-
Identified and facilitated Geocoding of location & pins on maps using Xamarin forms for foodbanks & customers
-
Hooked login page to AWS database and published apps via developer account for iOS and android play store
-
Girls Plus Data
Headquarters Event Manager [Volunteering]
Responsibilities
-
Created campaigns for data-oriented educational events on Eventzilla and coordinated with the events team about setting up registration functionalities.
-
Coordinate with the website team about event rosters and social media teams on an effective online marketing campaign.
-
Helped facilitate the difficult transition of an in-person event setup to an interactive online.
-
Conducted online date-oriented virtual events with data leaders in the industry like Looker [Google Cloud] and Thoughtspot.
-
Currently working on registration optimization page for eventzilla.
Engineering Management Student Association [EMSA]
Co-Founder and Operations Head [Volunteering]
Responsibilities
Engineering Management Student Association (EMSA) is an officially recognized organization at SJSU, exclusively for Engineering Management students! With Dr. Minnie Patel as our advisor, the goal of EMSA is to help the students' network better, meet alumni and fellow students, and get tips and advice on how to make the most of their time here at SJSU.
Atlas Copco GECIA
Industrial Data Intern
Responsibities
-
Designed & automated an Excel classification tool, Tableau dashboard allocating HS codes which led to 30% savings in cost
-
Analyze correlations of various companies nps data for collaborating with them and thus generating new revenue streams
-
Preprocessed scalable data pipeline by assessing client needs and by streamlining data population, trends and insights
-
Worked on Multiple ETL jobs, using git and designed data models using predictive analytics and data warehousing
Zacq Technologies
Industrial Data Intern
Responsibities
-
Identified KPI’s, prioritized features and performed A/B and Multivariate testing before designing prototypes
-
Used CRISP-DM and provided customer reports after extracting, analyzing, visualizing data using statistical tools
-
Created Power BI dashboards for monitoring in customer success team and epics, user stories, logging defects using Jira.
-
Executed ad-hoc requests and spearheaded data aggregation on customer behavior creating an increase of 30% in revenue