Ajinkya Tekale

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.

• 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.

• 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, tableau Hospitality, In this project, I assisted client in improving revenue management, optimizing marketing efforts and enhancing guest experience with effective data analysis. The components of hospitality such as business operations, marketing, occupancy rate and departments benefited from data-driven insights., MySQL, and Excel, PowerBI.