Chetan Amare

Chetan Amare

Followers of Chetan Amare175 followers
location of Chetan AmareMumbai, Maharashtra, India

Connect with Chetan Amare to Send Message

Connect

Connect with Chetan Amare to Send Message

Connect
  • Timeline

  • About me

    Data Analytics and Business Intelligence Professional | Driving Data-Driven Insights for Business Growth | Expertise in Data Visualization & Analysis | Leveraging Data to Inform Strategic Decision-Making

  • Education

    • K.J. Somaiya Institute Of Management Studies and Research

      2007 - 2010
      Master of Computer Applications (M.C.A.) Information Technology Distinction
  • Experience

    • Accenture

      Jul 2010 - Dec 2014

      - Played a pivotal role in the Management DART project, developing SSIS packages, SSRS reports, and Excel tools.- Provided key support for web development activities, including code reviews and deployments.- Facilitated knowledge transition sessions for newly hired resources and the operation team.- Contributed to the development of the Capture DART application, involving complex database architecture for project tracking.- Participated in core web development activities and utilized Web Service Factory for web service development.- Created Excel tools for Operations team, boosting productivity by 15%.- Led knowledge transition sessions, cutting onboarding time by 25% and improving team efficiency. Show less - Played a pivotal role in the Management DART project, developing SSIS packages, SSRS reports, and Excel tools.- Provided key support for web development activities, including code reviews and deployments.- Facilitated knowledge transition sessions for newly hired resources and the operation team.- Contributed to the development of the Capture DART application, involving complex database architecture for project tracking.- Participated in core web development activities and utilized Web Service Factory for web service development.- Created Excel tools for Operations team, boosting productivity by 15%.- Led knowledge transition sessions, cutting onboarding time by 25% and improving team efficiency. Show less

      • Developer and Module Lead

        Oct 2011 - Dec 2014
      • Developer

        Jul 2010 - Oct 2011
    • EY

      Dec 2014 - May 2015
      Data Analyst

      - Conducted data cleansing, formatting, and loading tasks using Excel and SQL.- Prepared queries for defined fraudulent scenarios and presented output in Excel format.

    • Tech Mahindra

      May 2015 - Sept 2017
      Module Lead and Senior Developer

      - Led an 8-member team at SEBI BI Solutions, ensuring timely project delivery and adherence to quality standards.- Conducted dimensional database modeling for Registration and Complaint modules.- Developed SSIS packages to process data from multiple sources to SQL Server and IBM DB2.- Designed and deployed SSAS Cubes, improving data processing speed and efficiency by 25%.- Participated in core web development activities, reducing post-deployment issues by 20% and enhancing code quality.- Facilitated knowledge transition for new team members, reducing onboarding time by 30% and boosting team productivity. Show less

    • TORM

      Sept 2017 - Jul 2022
      Data Analyst Manager

      - Led the creation of reports and dashboards for the technical division at Torm Shipping, serving 8 departments and providing insights into vessel parameters.- Engaged with stakeholders to gather requirements, conduct report UAT, and finalize report/dashboard delivery, proposing innovative solutions utilizing existing data.- Executed data extraction, transformation, and loading processes into Power BI/SSRS reports and datasets.- Utilized MDX, DAX queries, and complex SQL queries for data extraction from SSAS cubes and tabular models.- Integrated Power BI reports into SharePoint Online, boosting accessibility and utilization by stakeholders by 30%.- Contributed to core web development, reducing deployment errors by 20% and improving code quality.- Led knowledge transition sessions, cutting onboarding time by 25% for new hires. Show less

    • Comscore, Inc.

      Aug 2022 - now
      Data Analysis Manager

      - Led creation of custom reports and dashboards for high-revenue clients, enhancing data visualization and decision-making.- Engaged with stakeholders to gather requirements, conduct UAT, and deliver innovative solutions using existing data.- Documented requirements and managed resources for report-related tasks, including ETL processes.- Executed data extraction, transformation, and loading processes into Power BI/SSRS reports, improving report generation time by 20%.- Developed MDX, DAX queries, and complex SQL queries for data extraction, enhancing data retrieval efficiency by 15%.- Managed a team of 5 resources, reducing project turnaround time by 25% through oversight of development activities.- Conducted knowledge transition sessions, reducing onboarding time by 30% and enhancing team productivity. Show less

  • Licenses & Certifications

    • Microsoft Certified: Power BI Data Analyst Associate

      Microsoft
      May 2024
      View certificate certificate
    • Project Management Professional (PMP)

      Project Management Institute
      Sept 2024
      View certificate certificate
    • Microsoft Certified: Azure Fundamentals

      Microsoft
      Jun 2024
      View certificate certificate
    • Microsoft Certified Technology Specialist (MCTS) : Business Intelligence

      Microsoft