Ashish Pandey

Ashish pandey

bookmark on deepenrich
location of Ashish PandeyMumbai, Maharashtra, India
Phone number of Ashish Pandey+91 xxxx xxxxx
Followers of Ashish Pandey580 followers
  • Timeline

    Oct 2010 - Dec 2013

    Senior Software Engineer

    L&T Infotech
    Mumbai Area, India
    Dec 2013 - Jan 2015

    Senior Software Engineer

    CitiusTech
    Nov 2016 - Jul 2021

    Manager

    Deloitte
    Mumbai, Maharashtra, India
    Current Company
    Aug 2021 - now

    Senior Manager

    Unifeeder
  • About me

    Senior Manager at Unifeeder | Ex- Deloitte

  • Education

    • Gla institute of technology & management

      2005 - 2009
      Bachelor of technology (b.tech.) electrical, electronics and communications engineering honours degree in engineering

      Activities and Societies: Cultural Fest Organization Committee Member and Participant. Electronics and Communication Engineering

    • Sunbeam school, bhagwanpur, varanasi

      2002 - 2004
      Higher secondary science

      HSC

  • Experience

    • L&t infotech

      Oct 2010 - Dec 2013

      My Job Profile consist of:-Analysis and feasibility check as per Requirement.-Coding and Design changes based on timeline.-Comprehensive Database Management consisting of Bulk Data Load along with Data Migration.-Imparting technical training to a group of professionals.-Documentation based on Quality Process followed in the company.-Test Case preparation and Unit Testing.-Peer Review of the deliverable.-Movement of deliverable to Testing and Staging Environment.-Production Release Activities.-Regular meetings with customer for providing updates and discussion.-Onshore-Offshore model followed for Co-ordination.-Knowledge Transfer to the other Team Members. Show less

      • Senior Software Engineer

        Nov 2010 - Dec 2013
      • Senior Software Engineer

        Oct 2010 - Dec 2013
    • Citiustech

      Dec 2013 - Jan 2015
      Senior software engineer

      - Requirement Gathering from the client- ETL Development and Dashboard Reporting using SSRS and Tableau- Complex SQL query development comprising of Store Procedure, Indexing, Functions and Cursor.- Training a group of professionals on technical tools.- Regular Scrum meeting with the client to provide updates.- Proof of Concept on Bigdata Database Apache Cassandra.- Proof of Concept on Microsoft 365 and Power BI.

    • Deloitte

      Nov 2016 - Jul 2021

      • Comprehensive Database Management consisting of bulk data load along with Data Migration. • Querying and mining large data sets using TSQL to discover transaction patterns, uncover anomalies and filter for targeted information.• Reconciliation of General Entries using Audit Command Language.• Analysis of Financial data related to Payroll and HR.• Developed visually compelling dashboards using Tableau that communicate the relevant insights to stakeholders in an easily consumable manner.• Automating some of the existing procedures using TSQL and VBA Macro to increase productivity.• Mentoring other team members on existing assignments by providing them training and quality check on the work performed. Show less 1. Worked on a mortgage fraud project for a leading bank in Canada.Analyze the data to identify the key stories that are related to mortgage fraud using IBM CFM infrastructure. Used tools like IBM ODM and IBM i2 Analyst notebook to discover the key insights.2. Analyzing Market Performance of an Insurance Client based on the Campaigns created using data from Google Analytics and Social Data feeds. Data wrangling to make the data more useful to discover key insights using an in-house Deloitte tool.3. Fraud Investigation for a Retail customer going through big hacking issue of reward point of customers being stolen. Identifying the pattern of stolen reward point along with suggesting approaches to payback the customers. Show less

      • Manager

        Jun 2020 - Jul 2021
      • Deputy Manager

        Dec 2017 - May 2020
      • Assistant Manager

        Feb 2015 - Dec 2017
      • Analyst

        Nov 2016 - Apr 2017
    • Unifeeder

      Aug 2021 - now
      Senior manager
  • Licenses & Certifications

    • Collibra expert i

      Collibra
      May 2019
    • Microsoft certified: azure data engineer associate

      Microsoft
      Jan 2020
      View certificate certificate
    • Mcts in bids 2008

      Microsoft
      Jun 2014
    • Exam 467: designing business intelligence solutions with microsoft sql server

      Microsoft
      Dec 2014
      View certificate certificate
    • Exam 466: implementing data models and reports with microsoft sql server

      Microsoft
      Sept 2014
      View certificate certificate
    • Collibra expert ii

      Collibra
      Jun 2019
  • Honors & Awards

    • Awarded to Ashish Pandey
      Star of the Quarter Deloitte December 1, 2017