Kapil Kumar Email & Phone Number

Delhi, India

I have been extensively involved in improving our data management and analysis processes, with a focus on the following key areas:Understanding API Data:• Delved deep into API data structures, ensuring comprehensive comprehension of incoming data formats and schemas.• Python Code Development for JSON Data Parsing.• Developed robust Python scripts to efficiently parse JSON data into structured columns, enhancing data accessibility and usability.Database Management:• Designed and implemented optimized database tables, meticulously defining data types to ensure data integrity and efficiency. • Successfully inserted and managed data within the databases, streamlining data storage and retrieval processes.Integration and Automation:• Utilized Python to integrate APIs from various tools such as Rista, Rannkly, Cropster, and Shopify, enabling seamless data flow between systems.• Implemented workflow management and automation using Airflow, enhancing efficiency and reducing manual intervention in repetitive tasks.Reporting and Visualization:• Developed comprehensive reports catering to various levels of granularity, including online/offline, overall, suchali, muhavra, cafe-level, city-level, and zone-level.• Utilized Tableau for creating interactive dashboards presenting key metrics such as net sale, gross sale, orders, growth %, AOV,projected sale, and various comparative analyses (day on day, month on month, etc).Data Manipulation and Process Flow:• Streamlined data manipulation and process flow across multiple data sources using Python, ensuring data consistency andreliability.Real-Time Data Analysis:• Responded promptly to the dynamic needs of different verticals such as Finance, Marketing, and Café Operations by providing real-time data analysis and insights.database management.• Excel Sheets & Google Sheets for data integration and analysis.• Tableau for creating interactive and insightful visualizations.

New Delhi, Delhi, India

As a Business Analyst at Blue Tokai Coffee Roasters, I drive data-driven decision-making and optimize business operations through comprehensive analysis and strategic insights.Data Analysis and Reporting:• Analyze sales, marketing, and operational data to identify trends and areas for improvement.• Create detailed reports and dashboards for stakeholders.• Conduct market research and competitive analysis.Process Improvement:• Collaborate with cross-functional teams to streamline business processes.• Identify inefficiencies and recommend solutions to enhance productivity and reduce costs.• Implement and monitor process changes.Project Management:• Lead and manage business projects from initiation to completion.• Coordinate with departments to ensure projects are completed on time and within scope.• Develop project plans, timelines, and milestones.Stakeholder Communication:• Communicate findings and recommendations to senior management and other stakeholders.• Prepare presentations and reports for executive-level meetings.• Act as a liaison between technical teams and business units.Customer Insights:• Gather and analyze customer feedback to understand needs and preferences.• Use customer insights to inform product development and marketing strategies.• Monitor customer satisfaction and retention metrics.Key Achievements:• Identified market trends that led to the launch of a new product line, increasing sales by 15%.• Implemented a new data analytics platform, improving reporting accuracy and reducing analysis time by 30%.• Led a project to revamp the supply chain process, reducing delivery times by 20% and cutting costs by 10%.

Mumbai, Maharashtra, India

• Received multiple appreciation certificates and the R&R winner award from the current organization (WhiteHat Jr).• Coordinated statistical data analysis, design, and information flow.• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders, providing concise explanations of the best placement for needed resources.• Produced monthly reports using advanced Excel spreadsheet functions.• Participated in requirements meetings and data mapping sessions to understand business needs.• Conducted ad-hoc analyses on operations data upon request, using the corporate Business Intelligence tool and customizing queries.• Automated reports to be directly shared via email and WhatsApp.• Developed tables, views, and materialized views using SQL.

• Quickly learned new skills and applied them to daily tasks, enhancing efficiency and productivity.• Accurately and efficiently performed day-to-day duties.• Demonstrated respect, friendliness, and a willingness to help whenever needed.• Worked flexible hours, including nights, weekends, and holidays.• Managed the planning and development of designs and procedures for metric reports.• Developed new reports and delegated tasks to team members.• Investigated and conducted studies on product forecasts, demand, and capital.• Created multiple dashboards to enhance visibility and track various revenue and conversion metrics, serving users from the frontline to central organization leaders.

Gurugram, Haryana, India

• Got PPO from OYO exemplary performance• Successfully interpreted data to derive conclusions for managerial action and strategy.• Utilized statistical techniques for hypothesis testing to validate data and interpretations.• Presented data and conclusions to the team to enhance strategies and operations.• Proposed solutions to improve system efficiencies and reduce overall expenses.

Gurgaon

• Exceptional attention to detail.• Proficient in multitasking efficiently.• Strong written and verbal communication abilities.• Capable of performing repetitive tasks with high accuracy.• Comfortable working independently with minimal supervision.

B.A. Programme

Graduated with a B.A. Programme degree, majoring in English, Hindi, Political Science, History, and Sociology. Proficient in critical.

Doeacc 'O' Level, Computer/Information Technology Administration And Management, B+

Activities and Societies: Developed and designed a website for NSIC (National Small Industries Corporation) as a project, utilizing HTML..