3+ years of work experience in field of Data Analytics.

Sumeet Gaglani Boston, MA *******.*@************.*** 857-***-****

https://linkedin.com/in/sumeet-gaglani https://github.com/Sumeet942/ PROFESSIONAL EXPERIENCE

Business Intelligence Engineer- Bristol Myers Squibb, Devens, MA Jul 2019 – Dec 2019

− Created and monitored critical KPI’s like hazardous waste and water usage which saved $30,000 for the organization

− Eliminated 26 hours of weekly manual work by locating and extracting timestamp using pattern index in SQL and visualized it in Spotfire for Quality assurance purpose

− Managed employee resource and key metrics across 12 departments by designing dashboards in Spotfire for leaders

− Increased query performance by 20% by reducing joins, indexing and removing unwanted columns in SQL server

− Eliminated 20 hours of weekly manual work by cleaning text using NLP techniques like tokenizing and lemmatization to identify key words and build dashboard for optimized process insights Data Analyst – Netmagic Solutions, Mumbai, India Sept 2016 – July 2018

− Implemented A/B testing for clients to understand what campaigns are working best for them and increase their sales

− Normalized databases for clients to maintain referential integrity and avoid any anomalies using MySQL workbench

− Maintained data quality by integrating, cleaning and removing duplicate data from multiple sources using SSIS

− Optimized data storage in Hive by setting up partition on year, manipulating complex data structures like map, array and cleaned data string using custom SerDe files

− Identified root cause by building actionable data reports for Sales team, PMs and customers in Tableau

− Enhanced data storage by selecting appropriate storage according to data for clients to support analytical projects CERTIFICATIONS and SKILLS

Certifications Tableau Data Analyst, ITILv3 foundation Programming and Query Skills Python, SQL

Databases Hive, MySQL, SQL Server, Oracle, Postgres, Redshift Data Skills Data Visualization, Data Warehousing, Data Pipelining, Data Governance Data Integration/ BI Tools Talend, Tableau, Power BI, Spotfire Python Packages NLTK, NumPy, Pandas, Matplotlib

Cloud technology AWS Sagemaker, S3, EMR, QuickSight, Azure Databricks ACADEMIC PROJECT

Big Data RFM Analysis [Azure Databricks, NLP] Summer 2020

− Clustered and segmented customers based on Recency, Frequency and Monetary analysis in Azure Databricks

− Increased model accuracy by 8% by implemented feature importance and creating additional labels

− Plotted and visualized the results of different algorithms used such as KNN and Random forest using matplotlib library Zlymo Market Analytics [AWS Sagemaker, S3, AWS Glue, Redshift] Spring 2020

− Identified impact of different channels, campaign and promotion on products by creating a click though rate analytic dashboard in Tableau

− Built data pipeline to generate sales insights by collecting metadata in AWS glue and loading to redshift Business Intelligence and Data Warehousing [Talend, Tableau, Power BI] Spring 2019

− Built a Data warehouse by designing Facts and Dimensions in star schema and loaded data in SQL server

− Developed dashboards in Tableau for managing inventory of products, campaign analysis and reject analysis

− By allocating appropriate ram and parallelizing jobs built a performance tuned Data pipeline in Talend Hospital Management Database [MySql, ER/Studio] Fall 2018

− Normalized database till 3NF to eliminate update, delete and insert anomalies

− Built complex SQL queries - trigger, stored procedure and views to retrieve data efficiently

− Empowered ease of architecture readability by building the EER model using the reverse engineering in MySQL EDUCATION

Master of Science in Information Systems Northeastern University, Boston, MA Aug 2020 Coursework: Data Warehousing, Business Intelligence, Data Science Engineering Methods and Tools, Database Management and Design, Cybersecurity, Algorithmic Digital Marketing Bachelors in Electronics and Telecommunication K.J Somaiya College of Engineering, India May 2016

Contact this candidate