KARAN GIGOO

Boston, MA 857-***-**** ad2ma1@r.postjobfree.com LinkedIn Website

EDUCATION

Northeastern University, Boston, MA Sept 2021 - April 2023

Master of Analytics

Savitribai Phule Pune University, Pune, India June 2015 - May 2019

Bachelor of Engineering in Computer Engineering

PROFESSIONAL EXPERIENCE

Data Analyst Intern Thought Byte Inc. Nutley, NJ July 2022 – Sept 2022

•Redesigned 5+ reports in Tableau, adding additional charts mapping sales of areas of high profitability.

•Transformed SQL script in SSMS to extract data from multiple sources, resulting in a 12% improvement in data accessibility.

•Performed visual analysis in Tableau, tracking lost RFID saving the company up to $100,000 in revenue.

•Automated Python-based EDA for outlier detection, elevating Tableau's visual analysis capabilities.

Data Analyst Propellex Solutions Pune, India Jun 2020 – Jun 2021

•Migrated data from the client server using MySQL reenforcing data flowing and data cleaning.

•Automated data cleaning in Python with the help of a string tokenizer to improve data readability by 90%.

•Developed an ETL pipeline from MySQL to Amazon RDS using a flat file increase in data processing efficiency by 20%.

•Utilized VLOOKUP to segregate outliers from data, tracking 1500 water pumps working with 50 % efficiency.

Assistant Systems Engineer Tata Consultancy Services Bangalore, India July 2019 – June 2020

•Managed and Governed 5+ financial databases in SQL reducing the risk of database failure.

•Reported findings to the Database Administrator in Excel, reporting a reduction in monthly anomalies by 12%.

•Normalized the data identifying data inconsistencies implemented data quality processes, reducing errors by 10%.

•Provided critical data support monthly using data driven insights enhancing business decisions.

SKILLS

•Analytical Tools : Python, R, Scala, PySpark, Tableau, Power BI, Qlik

•Database: MySQL, SSMS, SQL, Oracle

•Tools: Microsoft Excel, Microsoft PowerPoint, Microsoft Office, Jira

•Cloud: AWS, RDS, S3

•Methodologies : Agile, Waterfall

PROJECTS

Maritime Analysis using Binary Classification

•Developed predictive models in Python to extract hours of the day, predicting whether the vessel would be on time or not.

•Integrated weather and shipping data in SQL for maritime analysis, improving data integrity by 10%.

•Suggested registration errors and automated scheduling corrections, reducing the delay in vessel docking by 15 mins.

Nashville Housing

•Developed classification algorithms to segregate based on house valuation using feature extraction categorizing houses above $500,000.

•Performed exploratory data analysis using VIF and PCAs to extract KPIs based in Python using pandas and matplotlib.

•Visualized benchmarking metrics in Tableau and provided strategic methods of investment targeting households with the right values.

ACADEMIC PUBLICATION

•Devised a model for image recognition and calorie detection based on RGB single food item segregation.

•Utilized CNN and deep neural network and performed benchmarking metrics.

•Link: https://ieeexplore.ieee.org/document/9016694

Contact this candidate