Niranjan Sapkal

Experience

• 

  Reliance Digital Retail Ltd.

  Jul 2012 - Nov 2013

  Department Manager

  Responsible for sales of the department, managing inventory, handling team of 6 sales associates, report generation and report checking

• 

  Business Development Bureau (India) Private Limited

  Nov 2013 - Aug 2016

  -- Communicating with clients to understand and document the business objectives-- Preparing database of the respondents which needs to be covered during the study-- Designing and assisting in the development of questionnaires-- Collecting secondary and primary data-- Collect, analyze and present research findings to senior management-- Preparing presentations, reports and graphical illustrations of research findings-- Respond to client questions in a professional manner-- Active support for the development of business strategies and plans contributing to the growth of the business Show less

  • Senior Market Research Executive

    Jan 2015 - Aug 2016

  • Market Research Executive

    Nov 2013 - Dec 2014
• 

  Credence Research Limited

  Aug 2016 - Dec 2018

  Senior Research Analyst

  - Communicating with clients to understand and document the business objectives- Designing research questionnaires- Interpreting data, writing reports, appropriate research methodology, techniques to conduct primary interviews- Preparing database of the respondents which needs to be covered during the study- Collecting secondary data, primary data and summarized large database to give bird’s eye view to derive suggestions, making actionable recommendations and conclusions for CXO level management- Preparing presentations, reports and graphical illustrations of research findings in PPT format- Compile and circulate daily and weekly project status update report- Active support for the development of business strategies and plans contributing to the growth of the business Show less

• 

  12th Wonder

  Jan 2019 - Sept 2020

  Principal Consultant

  - Responsible to execute consulting projects and leading and mentoring a team of 13 associates- Experience in analyzing the collated data to bring out key insights to the client- Using NLP ( Natural Language Processing ) techniques to integrate NEWS APIs with in-house tool- Selecting the most appropriate research methodology and techniques for market estimations- Represent findings using Tableau dashboard- Interpreting data and writing reports in both PPT and word format- Active support for the development of business strategies and plans contributing to the growth of the business- Involved in handling pre-sales and post sales queries along with developing proposals with business development team- Responsible for maintaining all qualitative and quantitative parameters of the project Show less

• 

  VCreaTek Consulting Services Pvt Ltd

  Oct 2020 - now

  Worked as a senior technical consultant for Kenvue Inc. (Part of the J&J Family of Companies). Over the past ~4 years successfully delivered over 25 projects of varying scales, focusing on Point of Sale (POS) and Supply Chain data- Collaborated closely with stakeholders from various business units to understand business objectives, project requirements, timelines, and dependencies.- Actively participated in project sessions to analyze Business Requirements Documents (BRDs) and converted them into technical documents for the DevOps team, including Solution Architecture and Technical Architecture- Coordinated effectively with onshore and offshore DevOps teams, providing guidance throughout all project phases- Proactively communicated project milestones, risks, issues, and timelines with stakeholders- Ensured User Acceptance Testing (UAT) sign-offs from business teams and facilitated the seamless deployment of business solutions from development to production environments- Played a pivotal role in the development and maintenance of the Extraction, Transformation, and Load (ETL) processes, leveraging various tools and technologies to populate data warehouse tables- Tracking sprint by sprint team’s velocity and maintaining healthy backlog in Jira for all projects for devops team.- Imported data from SQL Server, Azure SQL, SharePoint, and Snowflake databases into Power BI Show less - Strategic Planning and Implementation: Collaborated closely with business leaders to define project objectives, KPIs, and actionable strategies based on analytical insights and market trends.- Agile Project Delivery: Successfully delivered tailored digital solutions within agile teams, improving project delivery speed by 20%.- Stakeholder Collaboration: Facilitated calls and meetings with stakeholders to document business processes and requirements, leading to a 25% reduction in project scope changes.- Documentation and Analysis: Conducted detailed gap analysis, process flow documentation, and maintained traceability matrices to support strategy and solution development.- Product Backlog Management: Assisted in managing product backlogs, translating requirements into actionable user stories, enhancing project clarity and execution.- Data Analytics and Visualization: Developed 50+ dashboards using Power BI and Tableau, providing critical business insights that contributed to a significant increase in data-driven decision-making.- Advanced Data Manipulation: Utilized Python and SQL for ETL processes, resulting in a 35% improvement in data processing efficiency.- Process Optimization: Streamlined complex business processes using Alteryx, Python, Power Automate, Power BI achieving annual cost savings of 15000+ analyst hours.- Team Leadership: Led a team in the development of data warehouse to visualization solutions, coordinating with onshore and offshore teams to ensure project alignment and timely delivery.- Show less -Collaborated with stakeholders from various departments to comprehensively understand project requirements, actively participating in project sessions to dissect Business Requirements Documents (BRDs).- Contributed to discussions on effort estimation and business needs, conducting gap analyses, maintaining traceability matrices, and crafting process flows.- Played a pivotal role in the development and maintenance of the Extraction, Transformation, and Load (ETL) process, leveraging various tools and technologies to populate data warehouse tables.- Orchestrated coordination among onshore/offshore application teams, providing guidance throughout all project phases.- Provided leadership and direction to the ETL team, overseeing coding and graph development for data warehouse applications based on technical specifications.- Managed a query tracking sheet to facilitate daily communication of issues and queries with clients and offshore teams.- Actively engaged in discussions with business users, architects, application BAs, and Tech Leads to refine BRDs.- Imported data from SQL Server DBs, Azure SQL DBs, and Snowflake DBs into Power BI or Tableau, generating reports to address business needs.- Employed DAX queries and SQL queries to create computed columns in Power BI and Tableau.- Published Power BI reports in designated workspaces and made dashboards accessible via web services and mobile apps.- Leveraged Power BI and Tableau to explore data through various visualizations, ensuring comprehensive data analysis.- Utilized Power BI Gateways to maintain the currency of dashboards and reports.- Installed and configured Gateways in Power BI Services to facilitate seamless data transfer.- Leveraged Alteryx extensively for ETL activities, implementing processes to extract data from diverse sources (SQL Server, Snowflake Server, Excel, CSV, Web Scraping), and scheduling workflows.- Show less Data Integration:ETL Processes: Develop and maintain ETL (Extract, Transform, Load) pipelines to ensure data is correctly extracted from various sources, transformed into a usable format, and loaded into target systems.Data Integration: Combine data from disparate sources into a cohesive data repository.Data Quality Management:Data Cleaning: Implement processes for cleaning and validating data to ensure accuracy and completeness.Data Governance: Establish and enforce data governance policies and procedures to ensure data quality and compliance.Performance Optimization:Optimize Queries: Improve the performance of database queries and data processing tasks.System Tuning: Monitor and tune database and data processing systems for optimal performance. Show less

  • Associate Director

    Jul 2024 - now

  • Senior Business Consultant

    Jul 2023 - Jun 2024

  • Business Consultant

    Jun 2022 - Jul 2023

  • Senior Data Engineer

    Jul 2021 - Jun 2022

  • Data Engineer

    Oct 2020 - Jun 2021
• 

  VCreaTek Consulting Services Pvt Ltd

  -

  Associate Director