Aadarsh K. Email & Phone Number

Noida, Uttar Pradesh, India

In my current role as a Business Analyst at HCL Healthcare, I am responsible for managing and optimizing the healthcare platform to meet client needs, ensuring data integrity, and delivering actionable insights. My expertise in SQL, Advanced Excel, and Power BI plays a crucial role in supporting key areas such as:1. Healthcare Platform Configuration: Leveraged advanced Excel and SQL to configure and maintain platform settings, ensuring seamless customization based on client-specific requirements.2. Data Management: Utilized SQL to manage and oversee data integrity, performing quality checks and supporting data migration processes to ensure smooth transitions.3. Client Onboarding: Delivered client onboarding experiences, including training on platform functionalities, using data-driven insights from Power BI dashboards to help clients understand platform performance metrics.4. Customer Issue Management: Collaborated with technical teams to resolve platform-related issues, employing SQL queries and Excel analytics to troubleshoot and analyze data inconsistencies.5. Stakeholder Liaison: Acted as the key point of contact between stakeholders and technical teams, providing reports and insights via Power BI to ensure clear communication and alignment of business goals.6. Requirement Analysis: Analyzed Business Requirements Documents (BRDs) and Product Requirements Documents (PRDs) and broke them down into actionable tasks, ensuring alignment with business objectives.7. SOP Creation: Developed and maintained Standard Operating Procedures (SOPs) for platform configuration and usage, incorporating technical documentation supported by data insights from Excel.8. Training: Conducted training sessions for users, leveraging Power BI to provide visual insights and ensuring all users are well-versed in platform functionalities.

As a Data Analytics Intern, I have to engage in a comprehensive project focused on analyzing and optimizing operations. This internship involves the use of:1. Advanced Excel to create dynamic dashboards, 2. Power Query for data transformation, 3. SQL for in-depth data analysis, and 4. DAX for advanced calculations. I have to identify key areas for improvement and deliver actionable insights that will drive future growth, giving me hands-on experience with essential data analytics tools like Power BI, MS Excel, Power Query, Power Pivot, Python and MySQL.

India

Market Analysis Expertise: Engaged in livestock market sessions to gain a comprehensive understanding of market dynamics and consumer behavior.Strategic Application: Applied theoretical knowledge to analyze market trends and develop optimized advertising strategies.Project Excellence: Demonstrated a strong commitment to excellence through the timely completion of assignments and projects.In-depth Research: Conducted thorough market research to identify emerging trends and potential opportunities.Risk Management: Acquired and applied risk management techniques to ensure the success of various campaigns.Industry Networking: Actively networked with industry experts and attended webinars to gain valuable insights and stay updated on industry developments.

Noida, Uttar Pradesh, India

Delhi, India

Worked as a Relationship Manager, Handled a portfolio of 73 Crores of HNI Customers, Maintained a relationship with them and Analyze their needs and basis on it cross sold them banking products like FDs, Insurance, Investments, Loans and many more.

Lucknow, Uttar Pradesh, India

Worked as a Sales Executive.Domestic calling process for a Telecom Products.

Diploma Of Education, Data Science And Artificial Intelligence

Bachelor Of Commerce - Bcom, Accounting And Finance