Data Analyst

ANIKET SAHANE

469-***-****; *************@*****.***; www.linkedin.com/in/aniketsahane/

PROFESSIONAL EXPERIENCE

ATOS Global IT Solutions & Services, Pune, India April 2016 – July 2019 Software Engineer, Team Lead

• Automated manual SQL query reports on Crystal report and scheduled it with SAP Central management Console, reducing time and extra manual effort by 40% and awarded by the client for the efforts

• Designed batch jobs based on PL/SQL which were used to run multiple queries in single file, reducing manual process of the query run on SQL developer and also reduces run time by 50%

• Migrated data from 80 plus traditional spreadsheet to SQL backend table achieving the 60% efficiency by reducing 5 days of the manual intervention of cleaning and structuring the data

• Automated MS Excel - based “Reporting Dashboard” using VBA and reduced 60% manual workload

• Maintained more than 100 plus project data for ClearQuest, HPALM, RTC tools data in Oracle database

• Supervised 5 team members and provided knowledge sessions on SQL and PL/SQL ACADEMIC PROJECT

Dashboard and Visualizations of Grocery prices using Tableau, UT Dallas September 2019 – December 2019

• Explored the grocery prices data-sets with 15,000+ records and created a dashboard displaying variation in product prices across countries for data visualization and using interactive stories, interpreted strong inferences from dashboards & gathered insights to indicate least & most expensive gross prices in 8 countries House price prediction analysis using Python, UT Dallas October 2019 – November 2019

• Processed data by checking for missing values and transforming features into appropriate learning modeling

• Manipulated dataset with NumPy library and used matplotlib for visualization to get more insights

• Applied Linear Regression algorithm in Scikit-learn to predict the house price for upcoming projects Exploring 67 years of LEGO using Python, UT Dallas October 2019 – November 2019

• Analyzed a fascinating dataset on every single Lego block that has ever been built using Python. The database of Lego blocks is provided by Rebrickable and the data was in CSV format

• Processed data to plot graphs using matplotlib library for visualization to derive conclusion from the Dataset. Product Profitability Analysis & Visualization using Power BI, UT Dallas August 2019 – November 2019

• Connected disparate datasets of different products, transformed and cleaned the data into a data model and created charts and graphs to provided visuals to get valuable insights about the products. EDUCATION

The University of Texas at Dallas May 2021

M.S., Information Technology & Management GPA 4.0

Mumbai Education Trust, IIT, Mumbai, India August 2015 – January 2016 Post Graduate-Diploma in Center for Development in Advanced Computing (CDAC) GPA 3.7 Pillai’s HOC college of Engineering and Technology, IIT, Mumbai University, India August 2011 – May 2015 B.E., Electronics and Telecommunication GPA 3.6

CERTIFICATIONS & TECHNICAL SKILLS

Certifications: Oracle SQL, PL/SQL, Python, Tableau, Google Analytics, Google Ads Fundamentals, Sci-Kit, PowerBI BI & Visualization Tools: Tableau, R Studio, Power BI, SAP LUMIRA, SAP Crystal Reports, HANA Studio, SQL Server MS Excel: VLOOKUP, Pivot Tables, Slicing & Dicing, Statistical Analysis Programming: SQL, PL/SQL, Python (NumPy, Pandas & Matplotlib), R, Shell Script, Core Java, C, C++, VBA, SharePoint Databases: ORACLE, MS SQL, MYSQL

Contact this candidate