Back to Developers
Adarsh salian

Adarsh salian

DATA ANALYST

Udupi, India
70
Profile Score

Skills & Expertise (43)

Excel & Data Handling Advanced
8.6/10
3
Years Exp
Power BI Advanced
8.5/10
3
Years Exp
SQL/T-SQL Advanced
8.3/10
3
Years Exp
Python Intermediate
6.8/10
1
Years Exp
Oxygen XML Editor Data Modeling SAP CRM Data Analysis Data Validation Process Optimization SolidWorks FUSION 360 Creo Parametric Power Pivot Adobe illustrator Adobe FrameMaker Adobe InDesign Arbortext Editor Arbortext IsoDraw Inkscape SharePoint Jira Team-based workflow management Stored Procedures Advanced Excel Pivot Tables VLOOKUP/XLOOKUP Data Cleaning Reporting Basic Macros Pandas NumPy Matplotlib DAX CTEs Views Derived Tables Joins Subqueries Aggregations Power Query Power View

Work Experience

Intern

Cardolite Specialty Chemicals PVT Ltd

Present - Present

Completed a one-month internship on Cardolite, where I gained exposure to chemical manufacturing processes, learned the functioning of boilers, reactors etc, observed plant workflows, and understood how operational data and process monitoring support efficiency and decision-making.

DATA ANALYST

Cyient – Pratt & Whitney Canada – FMP Pricing Team

Jul 2023 - Present

Extract and manipulate large datasets from SAP systems, SQL Server databases, CRM platforms, SharePoint, and email sources to support pricing, financial analysis and maintenance insights. Write and execute SQL queries in SQL Server for data extraction, transformation, validation, and database maintenance. Perform advanced data cleaning, transformation, and modeling using Excel (Power Query, Power Pivot, VLOOKUP/XLOOKUP, complex formulas, Macros). Design and develop interactive Power BI dashboards and reports using DAX, Power Query, Power Pivot, and Power View to deliver actionable insights to stakeholders. Monitor and manage scheduled refreshes, troubleshoot data load failures, and resolve transformation or model-related errors to ensure reliable reporting. Maintain and optimize SQL and Excel-based source databases to improve data integrity, consistency, and reporting performance. Automate SAP and database data extraction processes using Excel VBA Macros, significantly improving efficiency and reducing manual intervention. Create customized CRM data views for efficient extraction and reporting based on business requirements. Translate business requirements into analytical solutions by modifying financial models and validating outputs to ensure alignment with client expectations. Engage in client discussions regarding engine slotting and maintenance planning, thereby exposing myself to the business conversations held by stakeholders, applying analytical precision to prevent scheduling conflicts and ensure optimized allocation. Developed intermediate-level proficiency in Python through self-driven projects and practice, utilizing libraries such as Pandas, NumPy, and Matplotlib for data cleaning, transformation, exploratory data analysis, and visualization.

Education

B.Tech in Mechanical Engineering - NMAM Institute of Technology

- · Afghanistan

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 0/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 70/100

Profile Overview

Member sinceMar 2026

Skills (43)

Excel & Data Handling Power BI SQL/T-SQL Python Oxygen XML Editor Data Modeling SAP CRM Data Analysis Data Validation +33 more