SOWMYA RAVICHANDRAN
San Jose,CA
Overview
10
10
years of professional experience
6
6
years of post-secondary education
1
1
Certification
Work History
Data Analyst
City Of Palo Alto
Palo Alto, CA
06.2023 - Current
- Fire Dashboard: By tracking key performance indicators (KPIs) like response time, dispatch, arrival, time on scene, duration of incident and resource utilization, leveraging Power BI, DAX, created data models, transformed data into actionable insights and reduced median duration of emergency call by 4%
- Building Dashboard - Designed 8 ad hoc SQL queries to fetch data from SQL Server with 1M records, normalized and developed data model, visualized state of plan review, problems with building permits, inspection services and improved overall decision making for building approvals to less than 2 days
- Asset Management Dashboard: By projecting assets of all business processes using SQL Server, SharePoint, Microsoft Power Automate and Power BI DAX, it was feasible to prevent repeat purchases which saved ~$250K, expensive issues, and data loss
- Code Enforcement Dashboard - Enforcement of property maintenance, zoning, and building codes were visualized to improve turnaround time using SQL queries, Power BI, DAX and SQL Server which reduced number of lawsuits raised against city
Data Analyst
Pacific Gas and Electric Company, PG&E
San Ramon, CA
03.2023 - 06.2023
- Designed dashboard to project vegetation management field tech audit results using Tableau
- Fetched data from ArcGIS Online (AGOL), combined and cleansed data using Tableau Prep Builder, MS Excel, Power Query, VLOOKUP, Pivot Table for business intelligence
- Automated data sampling process using python pandas, reducing manual effort (error prone) which takes 3-man days to 20 minutes with error-free sampled data for auditing
- Analyzed data for any discrepancies or duplicates, presented weekly and quarterly results from dashboard to leadership team
Cloud Spend Data Analyst
Autodesk, Inc
San Francisco, CA
05.2022 - 12.2022
- Built Azure data factory pipeline to extract spending related data using cost management export API and created customized dashboards using Power BI and DAX to project overall spending
- Cloud Cost Management dashboard clearly showcased resources which were over utilized and helped cut down expenses by 12%
- Categorized vendors to monitor overall spending within company, fetched, analyzed, and cleansed vendor data from SQL server using SQL queries
- Python libraries, Selenium, Excel Power Query, v-lookup, Power-Pivot, and projected results using Tableau
- Worked in billing and revenue data, interacting with engineering, sales, and finance departments to assure data accuracy, supporting informed decision- making
Quality Data Analyst
Oracle Financial Software Services
Bengaluru, Karnataka
01.2016 - 12.2019
- Utilized Data Management Tools (ETL) internal to Oracle to standardize and integrate various source system financial data into single standard format for data analysis and built quality checks to reduce data loss by 60%
- Extensive experience working on SQL, creating stored procedures, views, window functions, CTEs, sub-queries
- In-depth knowledge in ER modeling, schema design and dimensional data modeling (star and snowflake schema) building dimension and fact tables
- Acquired valuable knowledge in Selenium using Python and TestNG framework for automating cross-browser, data-driven, and API (JSON and XML) testing
- Gained experience with CHEF programming along with Jenkins to effectively automate CI/CD pipelines for periodic application deployment
- Collaborated and contributed to Agile SCRUM teams, fostering efficient and iterative development processes
Catalog Data Analyst
Amazon Development Services
Chennai, Tamil Nadu
08.2014 - 03.2015
- Handled day-to-day volumes of catalog data provided by vendors to ensure if SLAs are met as per quality standards using excel power query and macro
- Understand and correctly use Amazon’s Retail Systems Platform (RSP) to support vendors for onboarding their new products on website
- Delivered various Tableau dashboards for tracking new vendors, procurement of products, supply chain costs by category vs sales, day to day orders
- Inventory details, tracking debarred vendors, and implementing new strategies increased profit by 23%
- Had to dive deep into problem, perform ‘Root Cause Analysis’ and identify constraints to recommend solution based on available information
- Interacted with stakeholders to understand requirements and road map to help them meet their goals
- ACADEMIC PROJECTS
- Sea Level Rise Prediction using LiDAR: Predicted Sea Level Rise using python libraries, CNN-LSTM model, ArcGIS, Big Query and Tableau GitHub Link
- Job Location Suggestion: Developed AdaBoost model to recommend job location to seekers using pandas, scikit-learn and Streamlit libraries GitHub Link
- Housing Market Trend: Projected US market trends from 2016-2021 using AWS S3, Glue,Redshift, SageMaker, Tableau, Tableau Prep Builder GitHub Link
Education
Master of Science - Data Analytics
San Jose State University
San Jose, CA 01.2021 - 12.2022
B.E - Computer Science Engineering
Kgisl Institute of Technology
India 08.2010 - 05.2014
Skills
Python(Pandas, Numpy, Sklearn, Matplotlib), SQL , Advanced Excel (Power Query, Power Pivot, V-Lookup), Power Automate,
Jupyter Notebook, Lucid Charts, ArcGIS, MS Office
Strong Verbal &Written Communication, Interpersonal, Teamwork
Data Modeling
Technical Analysis
Data formatting
Data Validation
ETL processes
Data profiling
Analytical Problem Solving
Clear and Concise Communication
SQL
Statistical Analysis
Use Cases
Data Analysis
Data Storytelling
Data Cleaning
Data Acquisition
Requirements Analysis
AWS, GCP, Azure, Looker, Tableau, Power BI DAX
HTML, CSS, JavaScript, TestNG, Selenium, Jenkins, Jira
Certification
Microsoft Certified in Web Development
Timeline
Data Analyst
City Of Palo Alto
06.2023 - Current
Data Analyst
Pacific Gas and Electric Company, PG&E
03.2023 - 06.2023
Cloud Spend Data Analyst
Autodesk, Inc
05.2022 - 12.2022
Master of Science - Data Analytics
San Jose State University
01.2021 - 12.2022
Quality Data Analyst
Oracle Financial Software Services
01.2016 - 12.2019
Catalog Data Analyst
Amazon Development Services
08.2014 - 03.2015
B.E - Computer Science Engineering
Kgisl Institute of Technology
08.2010 - 05.2014
Microsoft Certified in Web Development