Unnati Ghodki

Fremont, CA (ready to relocate) +1-669-***-**** ad21ii@r.postjobfree.com LinkedIn Tableau GitHub EDUCATION

Northeastern University, Boston, MA December 2023

Master of Science, Data Analytics Engineering, GPA - 3.8 Certifications - GCP (Cloud Digital Leader), Tableau Desktop Specialist, AZ-900 Azure Fundamental, Avanade Scrum Foundation Courses: Business Intelligence (BI), Data Engineering, Statistics (Descriptive and inferential), Data Modeling, and Data Visualization Activities: NU Toastmasters, NU Music Club (Vocalist), Grad Research and Teaching Assistant, Women in Data Science, and GHC’23 WORK EXPERIENCE

Assistant Data Analyst June 2022 - September 2023

Northeastern University Boston, MA

• Assisted 30+ data leaders in ensuring data compliance, governance, and quality, creating ad hoc reports with SQL & Excel

• Promoted user engagement on the BI platform by extracting insights from creating Tableau dashboards querying MySQL Financial Analyst (Co-op) July 2022 - December 2022 LEAF - Local Enterprise Assistance Fund Boston, MA

• Gained a 15% increase in revenue and improved performance by analyzing sales, revenues, P&L statements, and raw data

• Strategized 10-year revenue projection, building forecasting models using Excel (VBA) & Python with market research

• Developed and maintained database by extracting and manipulating data for 90k+ small businesses from web & Salesforce Business Intelligence Developer (Finance & Accounting) December 2018 - July 2021 Accenture Solutions Pvt. Ltd. Bangalore, India

• Collaborated and brainstormed with operations stakeholders, cross-functional teams, and managers to gather, define, and document analytics requirements for 50+ actionable visualizations and KPIs

• Automated day-to-day reporting tasks for operations, building ETL pipeline and data models with SSIS, SSRS, batch scripting, relational databases, SQL, and Power BI while increasing reporting accuracy by 18%

• Optimized reporting performance by 75% by planning, architecting, and building a reporting data warehouse and models on MS SQL Server for data sources, i.e., SFTP, CSV, RDMS, JSON, etc., ensuring seamless integration

• Increased 25% productivity by delivering 25+ stunning and informative reports and dashboards to SMEs and key business users for system enhancements and providing research, analysis, and problem resolution

• Presented findings to clients and trained 150+ end users on new systems while streamlining processes and fine-tuning strategies for continuous improvements, optimal performance, and abiding by SLAs

• Led a team of 2 and served as a Point of Contact/SME for reporting and analysis concerns for various end-to-end projects Business Intelligence Associate (Finance & Accounting) October 2017 - November 2018 Accenture Solutions Pvt. Ltd. Bangalore, India

• Built and deployed 20+ changes using complex SQL scripts while documenting processes and providing customer support

• Developed functions, views, and stored procedures using T-SQL, promoting code reusability and best practices for team

• Helped 20+ team members in troubleshooting SQL routines, optimizing queries, and conducting root cause analysis Awards: FY21 TechStar - for bringing innovation in projects and Associate of the Month for better customer experiences PROJECTS

Utility Management (PostgreSQL, MySQL, SQL, Talend, ETL, Tableau, Data Warehouse)

• Analyzed and developed data model and warehouse for analyzing high energy consumption facilities and expenditures

• Optimized utility consumption by building a pipeline having OLTP (RDBS), OLAP, and data cubes for strategic decisions Git-Hub Data Analysis (GCP, Google BigQuery, SQL, ELT, Python, Tableau, Data Warehouse)

• Built data pipeline using BigQuery and Cloud Data Storage (Bucket), performing 10+ data transformations using Python

• Designed Cloud Function for data wrangling & triggering pipeline using Cron Scheduler, Pub-Sub, and BigQuery as sink House Sale Price Prediction (Python, Data Mining, Machine Learning, Regression Analysis)

• Engineered and transformed variables by using correlation heatmap, PCA, encoding, and combining categories

• Achieved 87% R2 by forecasting Boston housing sale price with Linear Regression, Random Forest, and Decision Trees YouTube Video Analytics on AWS (S3, QuickSight, Tableau, Glue, Lambda, Athena)

• Orchestrated end-to-end data management pipeline, integrating data from various sources, performing statistical analysis

• Reduced processing time by 30%, ensuring data confidentiality with scalable and secure cloud-based data infrastructure NLP (Natural Language Processing) Python Package (Python, GitHub, Visual Studio)

• Developed Python modules having classes and methods: PorterStemmer, Preprocessing, Naïve Bayes, and ModelEvaluation

• Created unit tests and full project implementation script to classify labeled Twitter samples with 60% accuracy SKILLS AND CERTIFICATIONS

Databases: Microsoft SQL Server, MySQL, NoSQL, PostgreSQL, MS Access Analytics Tools: SSIS, SSRS, Google Sheets, Microsoft Excel, R Studio, Salesforce, AWS, GCP, SPSS Programming Languages: R, SQL, T-SQL, Python(NumPy, Pandas, Scikit, ggplot, matplotlib, scipy, statsmodel), DAX Data Visualization: Power BI, Tableau, SSRS, Spotfire, Google Data Studio (Looker), Advanced Excel COMMUNITY SERVICE & INTERESTS

• Co-op Career Peer (Northeastern University); mentoring college students with resumes, cover letters, and mock interviews

• Received ACE (Accenture Celebrates Excellence) Big Heart Award for leading URIDU(CSR project) from Accenture front