Data Solution Analyst

• Mar 2022 - Present

Data Analyst

• Sep 2020 - Mar 2022

− Improved productivity and communication between different teams and stakeholders, supporting a 1-week speed up on project completion rate. − Completed 100% of projects on time or ahead of schedule, including continuous business solutions improvement, − Contributed to diverse projects by designing, coding, debugging, testing, documenting, and supporting server-based applications such as Presto and Teradata. − Delivered presentations to stakeholders on data insights, including gap reporting and data quality. − Led a team of 2 in the data quality process for digital metrics, performed statistical analysis, identified trends, and developed new strategies. Show less

Data Science Intern

• Jun 2019 - Aug 2019

− Wrote 100+ complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic. − Extracted data from SQL Server into Excel spreadsheets and developed pivot tables for analysis. − Conducted Exploratory Data Analysis using Python Matplotlib. − Worked with multiple classification algorithms (Random Forest, Gradient boosting) using Python Scikit-Learn. − Wrote 100+ complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic. − Extracted data from SQL Server into Excel spreadsheets and developed pivot tables for analysis. − Conducted Exploratory Data Analysis using Python Matplotlib. − Worked with multiple classification algorithms (Random Forest, Gradient boosting) using Python Scikit-Learn.

Data Engineer Intern

• Jan 2018 - Jun 2018

● Installed and configured Hadoop Map Reduce, HDFS, developed multiple Map Reduce jobs in python for data cleaning and pre-processing. ● Performed transformations on the Hive Tables by creating new data from the existing data. ● Created Hive tables, loaded data, executed HQL queries and developed MapReduce programs to perform analytical operations on data and to generate reports. ● Developed MapReduce jobs in Python for log analysis, analytics, and data cleaning. ● Involved in creating Hive tables and working on them using HiveQL and perform data analysis using Hive and Pig. ● Design and Develop ETL Processes in AWS Glue to migrate data from external sources like S3, JSON/Parquet/Text Files into AWS Redshift. Show less

Campus Ambassador

• May 2017 - May 2018

● Operated campus support website and broadcast availability to ~400 new potential users. ● Maintained online database of 27k + internship opportunities and 50+ training and certification modules. ● Operated campus support website and broadcast availability to ~400 new potential users. ● Maintained online database of 27k + internship opportunities and 50+ training and certification modules.

Intern

• Dec 2016 - Dec 2016

Developed a completely functional website in 20 days, increasing Core View System’s web presence and traffic. Developed a completely functional website in 20 days, increasing Core View System’s web presence and traffic.