Anuj Agarwal

Anuj agarwal

bookmark on deepenrich
location of Anuj AgarwalDelhi, India
Phone number of Anuj Agarwal+91 xxxx xxxxx
Followers of Anuj Agarwal820 followers
  • Timeline

    Jun 2012 - Aug 2012

    Intern

    CMC LTD
    Jun 2013 - Aug 2013

    Intern

    Indian Oil Corp Limited
    Aug 2014 - Jun 2017

    Associate Professional:Product Developer

    DXC Technology
    Jun 2017 - Sept 2019

    Consultant

    EY
    New Delhi Area, India
    Sept 2019 - Jul 2020

    Associate Principal - BI, Analytics & Data Science

    Gartner
    Jul 2020 - Jan 2022

    Executive

    Macquarie Group
    Current Company
    Jan 2022 - now

    Business Intelligence Engineer

    Amazon
  • About me

    Business Intelligence & Analytics Professional with Expertise in Data Visualization, Automation, and Strategy Development.

  • Education

    • Guru gobind singh indraprastha university

      2010 - 2014
      Bachelor of engineering (b.eng.) computer science

      Activities and Societies: leaders for tomorrow(a college student ngo) • Secured 3rd position in inter college GGSIPU university competition of major project.• Organising Committee member of CORONA’14 managing complete technical department.• Worked with Sounds of Silence to uplift their cause and helped them in collecting phones and teaching students. • Core team member of the College Fest CORONA’13 & CORONA’12.• Secured 2nd position in CODE RUSH at CORONA’13.• Secured 1st position in BUG-D-BUG Event at Corona’12.• Designed posters and… Show more • Secured 3rd position in inter college GGSIPU university competition of major project.• Organising Committee member of CORONA’14 managing complete technical department.• Worked with Sounds of Silence to uplift their cause and helped them in collecting phones and teaching students. • Core team member of the College Fest CORONA’13 & CORONA’12.• Secured 2nd position in CODE RUSH at CORONA’13.• Secured 1st position in BUG-D-BUG Event at Corona’12.• Designed posters and banners for college fest using PHOTOSHOP.• Vice President of the college society Leaders For Tomorrow-The BPITIANS.• Organized JAVA seminar conducted by Oracle experts jointly with NIIT at Chinmaya mission. Show less

    • Guru gobind singh indraprastha university

      2010 - 2014
      Bachelor of technology (b.tech.) computer engineering first division
    • Indira gandhi national open university

      2019 - 2020
      Applied statistics (pgdast) statistics first division
  • Experience

    • Cmc ltd

      Jun 2012 - Aug 2012
      Intern

      Developed a project named Harbinger.comthe website contains various dynamic features like messaging, email, help, search etc. It is a complete woman portal where they can visit and share there ideas, maintain there profile, search for jobs etc.

    • Indian oil corp limited

      Jun 2013 - Aug 2013
      Intern

      Develop and Test a new online module

    • Dxc technology

      Aug 2014 - Jun 2017
      Associate professional:product developer

      As a seasoned data professional with a focus on development, data mining, visualization, and UAT support, I have gained extensive experience during my time at DXC.One of my notable projects involved spearheading the development of an in-house reporting tool for insurance companies. This tool was designed to help clients monitor various aspects of their business, such as customer profiling, lifetime value, and churn rates. I also oversaw the analysis and creation of business optimization and regulatory reports for AIA and SHOMPO in Malaysia, using MS SQL and SAP Business Objects (WebI).Throughout my time at DXC, I have had the opportunity to work across multiple CSC locations, including Delhi and Hyderabad. I also worked directly with clients at their Malaysia office, which allowed me to gain an in-depth understanding of their business needs and collaborate closely with different stakeholders.I am passionate about using data-driven insights to drive growth and optimize performance, and I am committed to leveraging my expertise to help organizations achieve their strategic objectives.Responsible for Development, Data Mining, Visualization & UAT support Show less

    • Ey

      Jun 2017 - Sept 2019

      As a data analytics expert at EY, I was responsible for designing and developing the in-house Risk Analytics solution 'SPECTRA.' Using advanced data analytics techniques, our team identified exceptions and red flags in our clients' business processes and analyzed their impact on the organization's performance.I have led various successful projects, including Audit Automation for two major Indian conglomerates. We dealt with common data issues to the biggest business problems in processes like Procurement, Finance, Plant & Maintenance, Gas Distribution & Inventory. Our client received the Technology Innovation Award at the IIA conference in 2019 for the project.In addition, I spearheaded the BI Implementation for a Chemical Company on SAP HANA using Power BI & Microsoft SQL Server. We automated and optimized their business reports to monitor Real-time Inventory, Sales & Collection. The reports helped the management in Demand Forecast, Sales Forecast, etc.In order to assist the sales team, I also developed business dashboards for POCs for EY customers using Power BI and Tableau. These dashboards offered insightful information and improved access to crucial data for demand and sales forecasting, assisting the sales team in acquiring new clients for my team and business.Overall, my experience at EY has given me a deep understanding of data analytics, and I'm excited to bring my expertise to new challenges and opportunities. Show less

      • Consultant

        Oct 2018 - Sept 2019
      • Associate Consultant

        Jun 2017 - Sept 2018
    • Gartner

      Sept 2019 - Jul 2020
      Associate principal - bi, analytics & data science

      As a seasoned Analytics and BI strategist with Gartner, I have helped numerous clients across the globe in designing and developing effective Analytics & BI strategies. With my expertise, I have helped our clients in designing analytics and BI roadmap for their organizations and how they can effectively increase the use of analytics for various business processes such as operation optimization, sales growth, and financial analysis.My experience includes designing a catalog of various business scenarios that clients should monitor for their effective business operations, and as per the challenges in the industry they are working. I have also helped clients in the optimization, selection, and purchase of various analytics tools like Power BI, Tableau, Alteryx, and Denodo. My team and I help clients choose the right analytics tool for efficient execution of analytics and BI projects by evaluating their analytics maturity and understanding of advanced analytics methods.To support clients with market data and research analysis, I provide them with dashboards and reports designed in Power BI and Tableau. Additionally, I have published multiple research notes on Gartner Website as an author and co-author.With my expertise, I help organizations drive value from their data, empowering them to make informed business decisions and achieve their strategic goals. Show less

    • Macquarie group

      Jul 2020 - Jan 2022
      Executive

      As an Automation Expert at Macquarie, I have led multiple automation projects using tools such as Alteryx and Power BI. My focus has been on developing solutions that automate manual processes, reduce manual intervention, and increase efficiency.Some of my notable projects include:• Process Automation for Trade Settlement: Led the automation project for Trade Settlement process using Alteryx. We automated the manual reconciliation process, which reduced the reconciliation time by 70%. We also designed Power BI dashboards to visualize trade settlements data for the management.• Streamlining Loan Application Process: Led the automation project for a loan application process using Alteryx, which included extracting data from various sources, transforming data and loading the data to the final target. This reduced the processing time by 50%, and the application processing time was reduced from 2 days to 6 hours.• Creating a Sales Dashboard: Designed a Power BI dashboard to track sales performance for various business lines. The dashboard included KPIs like sales revenue, new customer acquisition, cross-sell, and up-sell opportunities. The dashboard helped the sales team to track their performance and focus on areas where they can improve.In addition to project work, I have also mentored and trained new team members on automation techniques and tools. My expertise in automation tools, combined with my experience in various industries, has enabled me to deliver valuable solutions to my clients. Show less

    • Amazon

      Jan 2022 - now
      Business intelligence engineer

      As a Business Intelligence Engineer at Amazon, I drive strategic analysis and insights for Prime Membership across India and other developing markets. My primary focus lies in harnessing data to inform decision-making and foster business growth, ensuring our Prime services resonate with diverse customer needs and market dynamics Key Responsibilities: Data Analysis & Strategy: I gather, cleanse, and analyze extensive datasets to unveil trends in revenue, competitor sales, market dynamics, and customer engagement. Team Leadership: I oversee a dedicated team of BI analysts and developers, cultivating an environment of continuous learning and innovation. Stakeholder Engagement: I excel in translating complex data findings into actionable insights, effectively communicating key recommendations with business leaders to guide strategic decisions. Tool Mastery: I spearhead the establishment and upkeep of cutting-edge business intelligence tools, ensuring seamless operations and data integrity. Market Research: Leveraging my expertise in market research and financial analysis, I drive budget planning and identify new opportunities for business expansion Furthermore, I played a pivotal role in the successful launch of Amazon Prime Surprise in India and seven other countries, contributing significantly to a 10% yoy growth in Prime membership adoption among iOS customers. Additionally, I collaborated with product teams to enhance the Prime shopping experience, implementing a comprehensive discount strategy, personalized recommendations, and streamlined navigation for new customers acquired from non-shopping channels. These initiatives resulted in notable improvements in shopping conversion rates With a profound understanding of data visualization and modeling tools, coupled with a robust business acumen, I am committed to elevating Amazon Prime's presence in emerging markets, delivering unparalleled value to our members, and driving sustainable business success. Show less

  • Licenses & Certifications

  • Volunteer Experience

    • Member

      Issued by Leaders For Tomorrow
      Leaders For TomorrowAssociated with Anuj Agarwal