Anuj Upadhyay

"CareerGuide.com is an ed-tech company offering career counseling, psychometric tests, and expert advice for students and professionals. I analyze traffic data to optimize user engagement and improve website content, providing insights that enhance the overall user experience. Collaborating with cross-functional teams, I drive data-driven decision-making to support the platform's goals."

• Partnered directly with the executive team as the first data hire to formulate and report on KPIs across their web properties that received 1M visitors using SQL and Google Sheets.
• Built a lead scoring machine learning model for the sales team to predict customer behavior, resulting in a 32% increase in sales.
• Developed root cause reports to address problems with web traffic visits, successfully revealing insights that boosted traffic by 50%.
• Compiled reports using Excel spreadsheets, Power Query, and Power BI for data visualization.
• Maintained documentation of all the processes related to Data Analysis.

"Intellipaat is a prominent training provider known for virtual programs in data science, machine learning, and other advanced technologies. Their hands-on learning approach prepares learners for careers in the tech industry with practical skills and certifications. I personally undertook a virtual internship with Intellipaat in data science and machine learning, enhancing my expertise in these areas."

• Built machine learning models for classification and regression problems.
• Utilized SQL expertise to develop complex subqueries, stored procedures, and user-defined functions
  UDFs for efficient data retrieval and manipulation in database systems.
• Leveraged Python's numpy, pandas, and matplotlib libraries to analyze, preprocess, and visualize
  large datasets, facilitating data-driven decision-making processes.
• Implemented advanced analytics and machine learning algorithms to derive actionable insights from
  data,contributing to predictive modeling and optimization tasks.
• Designed and optimized Power BI reports using Power Query and DAX expressions to transform raw data into insightful visualizations, enabling stakeholders to make informed business decisions.

"The brand provides fast fashion for young women across three continents through EBOs, Store-in-Store Outlets, an official e-commerce website and other online marketplaces"

• Led a team of 5 employees in managing day-to-day operations, optimizing sales, and enhancing customer satisfaction.
• Developed and implemented data-driven strategies to optimize sales, inventory management, and customer satisfaction, resulting in a 15% increase in revenue within the first year.
• Collaborated with the marketing team to develop and execute effective marketing campaigns, leveraging customer data insights fetched from SQL databases and visualized in Power BI to tailor messaging and offers to specific customer segments.
• Drafted detailed reports on store performance for upper management review using Power BI.
• Conducted regular meetings with staff members to discuss performance issues or new initiatives.
• Drafted detailed reports on store performance for upper management review.

• Oversaw retail operations to ensure all stations were operating efficiently and maintaining customer service standards.
• Analyzed financial data to identify areas of improvement for profitability using Power BI for visualization and Power Query for data manipulation.
• Developed strategies for increasing sales and improving customer service.
• Conducted inventory management activities such as receiving shipments and maintaining stock levels.
• Organized merchandise displays according to seasonal promotions or special events.

• Delegated work to staff, setting priorities and goals.
• Provided leadership, insight, and mentoring to newly hired employees to supply knowledge of various company programs.
• Collaborated with the sales team to drive revenue growth.
• Managed budgets, financial forecasting, and analysis using MS Excel for data manipulation and analysis.
• Ensured compliance with all safety regulations throughout the store premises.
• Used MS PowerPoint for data presentation and to create compelling reports and presentations.

• Ensured timely processing of invoices for payment.
• Managed daily office operations and administrative tasks efficiently.
• Performed data entry tasks to ensure record accuracy.
• Kept office equipment functional and supplies well-stocked to promote efficient operations.