Nikhil Goyal

Nikhil Goyal

Data Warehouse Engineer / Project Engineer

Followers of Nikhil Goyal152 followers
location of Nikhil GoyalJaipur, Rajasthan, India

Connect with Nikhil Goyal to Send Message

Connect

Connect with Nikhil Goyal to Send Message

Connect
  • Timeline

  • About me

    Data Warehouse Architect

  • Education

    • Rajasthan Technical University

      2006 - 2010
      Bachelor of Technology (B.Tech.) Electrical, Electronics and Communications Engineering
    • Subodh Public School

      2005 - 2006
      Higher education science and maths 72
  • Experience

    • Wipro

      Nov 2010 - Jun 2014
      Data Warehouse Engineer / Project Engineer

      - Implemented 30+ releases in production environment including 10 Major releases.- Worked in close consultation with clients/tech teams to propose and implement solutions.- Created Custom scripts to automate daily/weekly/monthly reports.- Monitoring of batch flow in various UNIX servers (IBM AIX).

    • Accenture

      Jul 2014 - Aug 2016
      Senior Software Developer / Data Archietect

      - Developed and Enhanced 10+ Shell Scripts, 8 PLSQ Objects.- Successfully migrated ~1 billion data for the Loyalty platform upgrade.- Decommissioned 200+ processes and 150+ database objects as part of the legacy marketing system decommission.- Coached and trained 5 new associates.- Mentored 400+ new joiners.

    • Accenture

      Apr 2019 - now

      - Leading various application like GIDW, DataMart, RS, GEARS, BAARS.- Provided design solution to many new projects.- Conducted design thinking sessions and collaborated with key stakeholders to developed 100+ new process for new Vitech Platform in GIDW.- Redesigned Hadoop File transfer process which resulted in saving ~6000 hours per year.- Tuned SQL scripts for critical Actuarial report to save ~4000 hours per years.- Working as a scrum master for any new enhancements of GEARS and BARRS applications.- Managing 30 members of resources.- Involved in planning, executing, monitoring, controlling of project.- Ensuring the business-critical data loads and reports are delivered on schedule without failure.- Mentored 20 new joiners.- Delivered 30 major releases with focus on improving system processes. Show less - Analyze, Design, build and Deployed the code base for Greenfield Project using Unix Shell Scripting and PLSQL Objects, SQL*Loader, etc.- Worked in close consultation with clients and identified function, non functional details for new interfaces- Developed 20+ PLSQL Objects as well as 30+ Shell Scripts.- Design and developed the Custom BIP utility as well as the Batch manager utility.- Developed Custom tools to reduce manual efforts and automate the process namely, o FileSystem Space Monitoring tool o Monitor Daemon process is active or not. o Automated the Deployment Process saving 95% manual efforts.- Conducted peer code reviews, mentored and coached 5 new developers. Show less

      • Data Warehouse Architect / Associate Manager

        Sept 2020 - now
      • Senior Team Lead

        Sept 2016 - Aug 2020
      • Development Team Lead

        Apr 2019 - Jul 2020
  • Licenses & Certifications

  • Honors & Awards

    • Awarded to Nikhil Goyal
      High Five Award Wipro Aug 2012