Ankit Kashyap
Data Analyst
Mumbai,Maharashtra
Summary
Experienced Data Analyst with a track record of success in data management, analysis, and visualization. Highly organized and passionate about leveraging data for insights.
Overview
9
9
years of professional experience
Work History
Data Analyst
JSW Steel Ltd
Raigad
05.2020 - Current
- 3 years of experience on Power BI (Desktop and Service) & MS-SQL along with DAX.
- Worked on the Power Bi reports & dashboards with SQL Server.
- Used Table, Matrix, Bar, Card, Gauge, Slicers visualizations
- Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
- Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.
- Created New Calculated Column and Measure using DAX Expression.
- Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
- Published/shared the reports by creating Content Pack/Sharing the pbix file.
- Worked on On-Premises Gateway to refresh the data sources/creating a live connection with MS-SQL.
- Implemented Role Based Security as part of security in Power Bi.
- Experience with MS-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
- Experience in Using multiple join statements to retrieve data from multiple tables.
- Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports.
- Experience in writing Programs for implementing Stored Procedures for different tasks.
Junior Executive
JSW Steel Ltd.
Raigad
09.2014 - 04.2020
- Planning and effecting predictive & preventive maintenance schedules for equipment to increase machine uptime & equipment reliability.
- Manpower handling and Coordination with other departments.
- Making Production as per the target & maintaining the required quality as per SLA.
- Coordination for spare parts management.
- Handling shutdowns, breakdown & preventive maintenance of equipment such as centrifugal compressor (Kirloskar & Atlas Copco make), Industrial water Pumps, Soft Water Pump, Cooling Tower, Chiller Unit.
- Team Member in implementation of 5S.
- Obtaining Mix Gas ( Coke oven Gas & Blast Furnace Gas) from Mixing Station & Maintaining the required flow & pressure in order to maintain furnace temperature.
- Preparing break down analysis & Root Cause Analysis report and implementing systematic solution.
Education
Bachelor of Engineering - Mechanical Engineering
Chhatrapati Shivaji Maharaj Institute of Technolog
Navi Mumbai05.2018
Skills
- Power BI
- SQL
- MS Excel
- Data Analysis
- Data Visualization
- Statistical Analysis
- DAX
Projects
- Involved in major projects of Digitalization phase of Steel Company.
- Projects included, Online Dashboard for the following
- Raw Material Consumption Report
- Online Chemistry Calculator
- Production Loss Consolidated Report
- Daily Work Monitoring
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Data Analyst
JSW Steel Ltd
05.2020 - Current
Junior Executive
JSW Steel Ltd.
09.2014 - 04.2020
Bachelor of Engineering - Mechanical Engineering
Chhatrapati Shivaji Maharaj Institute of Technolog
Similar Profiles
Shafil ShaikShafil Shaik
Project and Piping Engineer at S.K.Construction (JSW Steel Ltd Dolvi) Clients: JSW Steel, L&T, Batliboi Engg,Project and Piping Engineer at S.K.Construction (JSW Steel Ltd Dolvi) Clients: JSW Steel, L&T, Batliboi Engg,
Krishna KKrishna K
Asst Engineer at JSW Steel LtdAsst Engineer at JSW Steel Ltd
Abhijay GauravAbhijay Gaurav
Deputy Manager at JSW Steel LtdDeputy Manager at JSW Steel Ltd
Manish KumarManish Kumar
Regional Supply Chain Manager at JSW Steel LtdRegional Supply Chain Manager at JSW Steel Ltd
VEDANT RAJESHVEDANT RAJESH
Chairperson at Centre for Social Entrepreneurship and Development (CSED)–VITChairperson at Centre for Social Entrepreneurship and Development (CSED)–VIT