Pranay Pranay

• Ensuring highest data quality through accurate creation of Master data for reporting through data checks for marketplace. 
•  Automation of Google Sheets for cross-functioning dept. and analyze data proactively to drive business processes and business strategies 
•  Supporting customer insights & merchandising teams in their varied daily business by providing performance analysis and market insights to build strategies •
• Designed max order quantity for SKUs based on various analysis to reduce the operations time and increase revenue by 28%. 
• Design strategy with OKR setting in response to company capabilities, changing customer needs and the competitive market context

Dear Hiring Manager,

I am writing to express my keen interest in the available Data Analyst position at your esteemed company. Having reviewed the job description, I believe that my skills and experiences align well with the requirements of the role.

With an MBA degree in interdisciplinary management from HTW Berlin and a successful completion of my master's thesis on intelligent process automation for SMBs, I possess a strong foundation in business analysis and strategic decision-making. My previous role as a Commercial Operations Analyst at Gorillas allowed me to develop and maintain KPIs, make data-driven strategic decisions, and improve reporting processes. I also collaborated with stakeholders and internal teams, as well as suppliers such as Alnatura and PepsiCo., to ensure the highest data quality and support business growth.

In my role as a Business Analyst at Axel Springer NMT, I gained experience in creating visual dashboards, conducting forecasting and risk management, and performing data analysis for renowned products like BILD, WELT, and SportBILD. I also managed and improved ETL pipelines and utilized SQL queries for A/B testing and analysis. These experiences have honed my analytical skills and ability to provide actionable insights.

Furthermore, my internships at Deutsche Telekom and Viacom CBS Networks International equipped me with valuable knowledge in strategy, business development, and market analysis in both B2B and B2C environments. I possess technical proficiency in Excel, SQL, and Looker, and I am adept at translating complex data into compelling stories. My problem-solving skills, attention to detail, and collaborative nature make me an effective contributor to project management.

I am eager to contribute my expertise and learn from a company of your stature. I am confident that my skills and experiences make me an ideal fit for the position, and I would be delighted to discuss further how I can add value to your team.

Thank you for considering my application. I look forward to the opportunity to discuss my qualifications in more detail.

Best regards,

Pranay

Ensuring Data Quality: The analyst was responsible for maintaining the highest data quality by accurately creating master data for reporting. They performed data checks for the marketplace to ensure accuracy and reliability.

Automation and Data Analysis: They automated Google Sheets to facilitate cross-functional collaboration within different departments. Additionally, they analyzed data proactively to drive business processes and strategies. This involved leveraging data insights to make informed decisions and optimize operations.

Supporting Customer Insights and Merchandising: The analyst supported the customer insights and merchandising teams in their daily operations. They provided performance analysis and market insights to help these teams develop effective strategies. This likely involved analyzing customer behavior, market trends, and competitive intelligence.

Optimization of Operations: The analyst designed maximum order quantities for different Stock Keeping Units (SKUs) based on various analyses. This initiative aimed to streamline operations and reduce processing time. As a result, it led to a significant increase in revenue by 28%.

Strategy Development: The analyst collaborated with the company's stakeholders to design strategies aligned with Objectives and Key Results (OKRs). They considered the company's capabilities, changing customer needs, and the competitive market context to develop effective strategies that drove growth and success.

Overall, the Commercial Operations Analyst played a vital role in ensuring data accuracy, driving data-based decision-making, supporting teams with insights and analysis, optimizing operations, and contributing to strategic planning based on company goals and market dynamics.