Jul 2023 – Aug 2023 · 1 mo · Delhi, India · Remote

• 1. Assisted with operations, including managing the inventory, consultation tables, prescriptions data, lab tests and doctors' data.
• 2. Managed the prescription and medicine inventory.
• 3. Scraped months of data listings from MYDBR(data base) 3 times faster than previous algorithms, creating a comprehensive database of product information.
• 4. Helped develop a new business plan for a new product launch.
• 5. Worked extra hours and days to complete projects on time, meeting all deadlines.
• 6. Fixed medicine inventory for the streamlining of data retrieval, improving the accuracy of reports by 56%.
• 7. Created a live tracker for the medicine inventory and merged it with an Excel sheet, providing real-time updates on inventory levels.
• 8. Implemented advanced Excel tools in Excel reports, making them more visually appealing and informative.
• 9. Provided all the reports with visual graphs for better understanding to stakeholders, increasing the impact of the reports.
• 10. Project Leadership: Provided valuable contributions as part of a team, working closely with the company founders and VP. Facilitated the successful completion of a project resulting in a business plan with an anticipated yearly income of 2Cr+.

Dec 2022 – Feb 2023 · 2 mos · Noida, Uttar Pradesh, India · On-site

• Achievements during the Internship
• During the internship, Satvick was able to apply knowledge learned in coursework to real-world data analysis problems. He actively supported the data analytics team with exceptional analytical and technical skills. Satvick has shown utmost dedication, a strong work ethic, and passion for data analysis, and has contributed significantly to various projects.
• The following are the details of the accomplished tasks and responsibilities:
• 1. Collaborated with the data analytics team members in data analysis and interpretation.
• 2. Conducted research and analysed various data sets for specific projects
• 3. Contributed to the development of data-driven strategies and solutions.
• 4. Conducted quality control and quality assurance checks for data accuracy and consistency.
• 5. Assisted in the creation of project reports and presentations for stakeholders.
• 6. Worked with different data visualization tools including Tableau and PowerBI
• 7. Conducted data analyses to answer various business questions and provided data-driven insights to aid in better decision-making for the company.
• Summary of Internship
• Satvick consistently demonstrated exceptional communication, problem-solving, reporting, strategy, and collaboration skills during his Data Analyst internship. He efficiently tackled complex projects under tight deadlines without compromising quality. Satvick exhibited a collaborative mindset and consistently sought opportunities to contribute to the organization. His exceptional technical skills and stellar performance make him a highly sought-after candidate in the field of data analytics.
• Skills Used are -
• Python
• SQL
• Excel
• Power BI
• Data Cleaning
• Data analysis and Visualization

Sep 2021 – Aug 2022 · 11 mos · Delhi, India · On-site

• college society--
• 1- Participated in lectures, events, competitions,
• 2- Completed cleanliness drives and awareness campaigns about nature and related interdisciplinary fields.

Jan 2019 – Sep 2023 · 4 yrs 8 mos · India · Remote