Nilesh Patil
Senior Technical Associate
Pune,MH
Summary
Business and data analyst with 4.5 years of experience across diverse industries. Proven ability to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data. Highly analytical and detailed with documented track record in full software development life cycle (SDLC) methodologies and Agile techniques.
Overview
4
4
years of post-secondary education
5
5
years of professional experience
Work History
Data Analyst
Sears Holding India Corporation
Pune, Maharashtra
09.2019 - Current
- Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.
- Developed and enhanced reports connecting to single or multiple data sources to improve performance.
- Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results.
- Performed data preparation tasks like Join, Blending and Filtering data
- Designing and development of Tableau reports for maintenance KPIs Like PM Schedule Compliance, % Planned Work, Planned Work Jobs on Hold, Estimated Hours Vs Actual Hours.
- Used different Charts, Filters, Parameters, Calculations, Table Calculations, LOD, Functions and Actions.
- Performed tableau server tasks like report Publishing, Assigning Permissions and Scheduling Extracts.
Operation Consultant
Harman Connected Services
Bangaluru, Karnataka
04.2017 - 09.2019
- Created SQL queries for reporting, maintenance, data transformations and migrations, cleansing, data scrubbing and for overlay request.
- Electronic discovery (eDiscovery) refers to any process in which electronic data is sought, located, secured, and searched with the intent of using it as evidence in a civil or criminal legal case.
- Involved in data mapping which involves analyzing externally received metadata files, analyze the metadata contents and map the data to our standard system databases table into the targeted tables applying all kinds of transformation and modification based on the business requirement.
- Developed database tables, wrote SQL queries and functions and packages as per the requirements of the project
- Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.
Junior Data Analyst
Epiq System
Pune, Maharashtra
05.2016 - 04.2017
- Analyzed existing SQL queries to identify opportunities for improvements.
- Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Presented reports to clients and teammates regarding project progress and results.
- Cleaned up and backed up data to maintain data integrity during extraction, manipulation and processing.
- Developed database objects, including tables, views and materialized views using SQL.
- Created various Excel reports to assist with pulling metrics data and presenting them to give concise understanding of best placement for needed resources.
Education
Bachelor of Science - Computer Science And Engineering
Deogiri Institute Of Engineering & Mang. Study
Aurangabad, Maharashtra 431005 08.2012 - 07.2016
Skills
SQL
Tableau
Hadoop Administrator
MS Excel
UNIX
Python
Snowflake
Google Analytics
Data analysis
Nuix
Big Data
Timeline
Data Analyst
Sears Holding India Corporation
09.2019 - Current
Operation Consultant
Harman Connected Services
04.2017 - 09.2019
Junior Data Analyst
Epiq System
05.2016 - 04.2017
Bachelor of Science - Computer Science And Engineering
Deogiri Institute Of Engineering & Mang. Study
08.2012 - 07.2016