Summary
Overview
Work History
Education
Skills
Languages
Projects
Roles and Responsibilities
DISCLAIMER
Timeline
Generic

Ajinkya Tekale

Pune

Summary

Diligent Data Analyst with 2+ years of experience, possessing extensive knowledge of data analytics tools such as Power BI, Tableau, SQL, Advanced Excel, and statistical modeling. Expertise lies in sales, retail, and analytics. Strong problem-solving abilities and result-oriented work methods facilitate business growth through data analytics and optimization.

Overview

3
3
years of professional experience

Work History

Jr. Data Analyst

Landmark Techedge Pvt. Ltd.
06.2022 - Current
  • Generated standard and custom reports to provide insights into business performance.
  • Implemented business intelligence solutions to increase operational efficiency.
  • Provided technical support for troubleshooting analytics and reporting issues.
  • Managed approximately 15 incoming calls, emails and faxes per day from customers.

Data Analyst Intern

Landmark Techedge Pvt. Ltd.
10.2021 - 04.2022
  • Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
  • Monitored and controlled data upload, checking for successful data import and quality.
  • Streamlined data collection processes by implementing efficient data mining techniques.

Education

BE Mechanical -

KJCOE
06.2021

Skills

  • Advance Excel
  • Pivot Tables, VBA
  • Vlookup, Hlookup
  • SumIfs, Date Functions
  • Power BI, Macros
  • Tableau
  • MySQL
  • Python
  • Data Validations
  • Google Analytics
  • Optimization Techniques
  • Market Analysis
  • KPI Tracking
  • Dashboards

Languages

SQL
Python
R Language

Projects

  • CRM, In this project, I performed sales analytics for a
    renowned clothing brand's retail business. Analyzed shopping
    and purchase trends of the consumer base and target
    demographic data. Developed an automated sales metrics
    dashboard to monitor sales, growth and market share for
    different categories. Tableau, MySQL, Excel, Agile.
  • OEM, In this project, I developed an interactive dashboard to
    provide visibility to scrap and defective parts. Provided
    visibility to the sales team for decision support and automated
    them to reduce manual time spent in data gathering., Excel,
    Power BI.

Roles and Responsibilities

  • Prepare interactive visualization to provide real-time insights
    using Tableau Desktop.
  • Identifying Key performance indicators (KPI's) and building
    reports around them.
  • Automated daily tasks using analytical tools to reduce process
    lead time.
  • Data Validation and data preprocessing to maintain data
    integrity and facilitating accurate data for impactful analytical
    insights using excel, SQL, Python.
  • Interaction with business stakeholder to understand business
    need and provide analytical expertise.
  • Create calculations and derive fields based on the business
    requirements and analysis such as aggregations, conditional
    statements and mathematical calculations.
  • Develop Database queries such as stored procedures, views,
    functions, etc. using SQL.
  • Creating appropriate documentation that allows stakeholders
    to understand the steps of the data analysis process and
    duplicate or replicate the analysis if necessary.
    Keeping up with industry trends and best practices in data
    analysis.

DISCLAIMER

I Hereby declare that the details and information given above are
complete and true to the best of my knowledge.

Timeline

Jr. Data Analyst

Landmark Techedge Pvt. Ltd.
06.2022 - Current

Data Analyst Intern

Landmark Techedge Pvt. Ltd.
10.2021 - 04.2022

BE Mechanical -

KJCOE
Ajinkya Tekale