Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Manish Ashtikar

DATA ANALYST
Pune

Summary

Detail-oriented Data Analyst with the experience of delivering business insights through SQL, Power BI, and Excel. Proficient in data modeling, dashboarding, and analytics reporting across maritime and energy sectors. Skilled in Python (Pandas) for automation and advanced data wrangling. Hands-on with Data Governance practices including metadata management, data quality checks, and lineage tracking. Quick to adapt, analytically strong, and focused on driving value through clean, reliable, and governed data.

Overview

13
13
years of professional experience
12
12
years of post-secondary education

Work History

Sr.Market Intelligence Analyst

Marcura
PUNE (REMOTE)
11.2024 - 06.2025
  • Crafted and delivered weekly, biweekly, and monthly analytical reports tailored to business needs.
  • Administered and maintained Power BI dashboards as part of daily operations, ensuring real-time visibility of key metrics.
  • Developed quantitative reports using complex SQL queries and in-depth port performance analysis, with insights presented via structured PowerPoint decks.
  • Proactively resolved data and reporting-related tickets raised by stakeholders, ensuring timely and accurate support.

MARINE SURVEY ANALYST (DATA ANALYTICS)

INCHCAPE SHIPPING SERVICES
06.2022 - 11.2024
  • Performed data governance for global bunker quantity surveys by extracting structured data from PDFs, validating anomalies, and documenting metadata.
  • Developed and maintained metadata dictionaries and business glossaries in Excel and SQL to standardize vessel data, barge information, and fuel volumes across global locations.
  • Conducted extensive data quality checks, such as outlier detection, duplicate handling, and IMO number validation, prior to ingestion into a secure SQL Server data model.
  • Established end-to-end data lineage and audit trails from raw PDFs to Power BI dashboards, ensuring traceability and compliance.
  • Automated, standardized reports highlighting vessel discrepancies, supplier compliance, and port-wise trends using Power BI.
  • Ensured data protection through the implementation of role-based access control (RBAC), and secured data ingestion pipelines with SQL authentication and audit logging.
  • Identified, analyzed, and interpreted trends and patterns in complex datasets using statistical methods to generate actionable business reports.
  • Maintained and enhanced dashboards, including the Global Marine Bunker Survey Governance Dashboard, BQS Analytics Dashboard, and BQS Commercial Dashboard.
  • Explored and implemented basic predictive algorithms on historical data to derive forward-looking insights.

Sr. DATA ANALYST

BLUETIE GLOBAL PRIVATE LIMITED
MUMBAI
06.2018 - 12.2020
  • Writing SQL queries on MSSQL to fetch data of app users, application parameters, and stakeholder requirements.
  • Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of the best placement for needed resources.
  • Data modeling in Power Query for creating reports. Directing the team of research analysts for primary research, secondary research, quantitative research, qualitative research, and performing surveys and interviews.
  • Data Analyst for manufacturing and service-based industries, such as oil and gas, shipping, metals and minerals, and automobile engineering, etc.

Data Analyst

DIGITAL LANCERS PRIVATE LIMITED.
05.2017 - 06.2018
  • Maintaining the database for scored leads and calling data. Quality checks on data were performed by the research team. Daily and weekly reporting through MS Excel on generated leads.
  • Performing data curation operations once the data is received and uploading it into the SQL Server database. Handling clients' issues with respect to data generation. Assisting the research team.
  • Creating and presenting reports by using statistical methods for respective operational teams, management, and clients.

Junior Marine Engineer

ELEKTRANS SHIPPING PRIVATE LIMITED
05.2016 - 12.2016
  • Shipping operations, knowledge of chartering operations, and maintaining the engine room logbook operations.
  • Assisting in the overhauling of H.F.O purifiers, diesel generators, water tube boilers, steam tracing operations, pumps (reciprocating, progressive, centrifugal), multi-stage high-pressure air compressors, bunkering operations, plant maintenance operations, spare parts stock management, inventory listing, rolling out requisitions, and firefighting operations.

Data Analyst

YARDI, Inc
10.2015 - 04.2016
  • U.S.-based process.
  • Creating a database of all storage facilities from various private websites and uploading it to the enterprise application. By going through the sales documents, loan documents, and relating the sales and loan cycles.
  • I gained hands-on experience with the Oracle database as we received industrial training for it.
  • The database of storage facilities consists of various parameters for research: site characteristics, property sales research, property loans research, and validation from government portals. Research also includes the previous sales, loan analysis.

Process Analyst

GALLAGHER OPERATIONS (GOSSPL)
05.2013 - 03.2014

Member of New Submissions Team for US Based 'Risk Placement Services'. Process consisted of setting up the data file through data sorting operations in TAT of 15 minutes once received from underwriters from USA. Gain the domain knowledge of Insurance process during this work tenure.

Trainee Engineer

CLEANTECH SYSTEMS PRIVATE LIMITED
08.2012 - 03.2013
  • Worked as a Trainee Engineer for a manufacturer of industrial cleaning machines based in Khed Shivapur Industrial Estate.
  • Worked closely with the Production team, the Purchase team, and later assisted the Project Engineer with the final commissioning of the machinery.

Education

SSC - Math, Science, History, Geography, English

P.JOG HIGH SCHOOL
KOTHRUD, PUNE
06.2001 - 06.2005

HSC - Math, Science, Computer Science

Mama Saheb Mohol College
KOTHRUD
08.2005 - 05.2007

Bachelor of Engineering - Mechanical

Rajarshi College of Engineering
Tathawade, Pune
08.2007 - 06.2012

Graduate Marine Engineer - Marine And Nautical

Vishwakarma Maritime College
Pune
03.2014 - 03.2015

Skills

Data analysis tools

MSSQL

PowerBi

Advanced Excel

Sea Born & Plotly

Pandas & Numpy

Python

ML

DAX

Data Story Telling

Projects

MARCURA :


  • Deep dive through SQL queries to gain the desired data set for weather conditions reports. Wind, Swell and Dry Cargo quantitative reports were created by executing above queries.


INCHCAPE SHIPPING SERVICES:


DATA GOVERNANCE & DASHBOARDING


  • As a Marine Survey Analyst, led a global data governance initiative focused on standardizing Bunker Quantity Survey (BQS) records collected from Person In-Charge (PIC) locations worldwide. Extracted critical data points from PDF files into structured tabular formats, followed by the creation of fact sheets with calculated fields to ensure consistency. Applied rigorous data validation checks to identify outliers, duplicate vessel names and IMO numbers, and inconsistencies in supplier and barge information. Established a secure SQL-based data model for governed data ingestion, enabling role-based access and audit traceability. Designed and deployed automated Power BI dashboards to monitor vessel discrepancies, supplier compliance, and vessel-supplier performance, providing actionable insights for operational and compliance stakeholders.


BQS ANALYTICS : 


  • Designed and developed a complete data solution, including database creation, data modeling, and dashboard visualization using Excel and Power BI. These dashboards catered to vessel companies, oil suppliers, and Inchcape’s internal operations team. The dashboards featured a rating system based on cost, fuel volume, and time-series analysis derived through in-depth data exploration. Key outcomes included increased business engagement from vessel companies through enhanced contract visibility and data-backed decision-making. Oil supplier relationships strengthened as our insights supported better barge evaluations. Internally, the analytics empowered Surveyors and Commercial Managers with performance-driven data, enabling them to make confident, strategic decisions.


Performed Proof of Concept work "Recommendation systems for besting costing and recommendation system for best supplier and its respective barge performers. Based on the surveys and companies past survey sales data."


@ BLUETIE PRIVATE LIMITED:


MANUFACTRING INDUSTRY COVERAGE FOR SKILLS (DATA FORM FOR APPLICATION) (ANALYSIS): 

  • Oil & Gas, Shipping, Metals & Minerals, Automobile Engineering, Chemical Plants, Power Plants, Jem’s and Jewelry manufacturing.
  • Understanding the Value Chain, connecting the industry experts and breaking down the valuable data points into useful skillset for “BlueTie” Application. This project enables the “BlueTie” application to cater the users in depth to match with the desired skill sets.


SKILLSET INSIGHTS: 


  • As these skills sets were heart and soul of application in our reporting, we use to provide insights with collab with in app team. Which help them to direct there push notification to targeted users by keeping them active.
  • (Data Science) Cost Price Analysis project for application annual and monthly subscription model performed through the 2-year data of subscribers and their behavior on application. And the Clustering of group of customer reviews by using K Means NLTK Text Mining for analysis for understanding the hidden topical patterns that are present across the collection.


@ YARDI INCH: USA SELF STORAGES: Mapping down the Self Storages which has large network. Plotting the Sales and loan chain and maintaining the database according to it.


@ GALLAGHER OPERATIONS: Part of New Submissions team and handled the incoming data for Tulsa, Lexington, Salt Lake City from Insurance Underwriters by maintain the TAT of 7 minutes.

Timeline

Sr.Market Intelligence Analyst

Marcura
11.2024 - 06.2025

MARINE SURVEY ANALYST (DATA ANALYTICS)

INCHCAPE SHIPPING SERVICES
06.2022 - 11.2024

Sr. DATA ANALYST

BLUETIE GLOBAL PRIVATE LIMITED
06.2018 - 12.2020

Data Analyst

DIGITAL LANCERS PRIVATE LIMITED.
05.2017 - 06.2018

Junior Marine Engineer

ELEKTRANS SHIPPING PRIVATE LIMITED
05.2016 - 12.2016

Data Analyst

YARDI, Inc
10.2015 - 04.2016

Graduate Marine Engineer - Marine And Nautical

Vishwakarma Maritime College
03.2014 - 03.2015

Process Analyst

GALLAGHER OPERATIONS (GOSSPL)
05.2013 - 03.2014

Trainee Engineer

CLEANTECH SYSTEMS PRIVATE LIMITED
08.2012 - 03.2013

Bachelor of Engineering - Mechanical

Rajarshi College of Engineering
08.2007 - 06.2012

HSC - Math, Science, Computer Science

Mama Saheb Mohol College
08.2005 - 05.2007

SSC - Math, Science, History, Geography, English

P.JOG HIGH SCHOOL
06.2001 - 06.2005
Manish AshtikarDATA ANALYST