Ashish Kumar Pandey

About Ashish Kumar Pandey

12+ years of Digital Project Delivery, Product and DB Design Development with a demonstrated history of working in multiple domains like Healthcare, HCM, Insurance, Mining & Metals and Retail industry.Well versed in Stakeholder Management & business requirement gathering with a strong focus on delivering end to end solutions.Have spearheaded the delivery of several large scale development & digital transformation projects and demonstrated technical problem-solving capabilities.Dynamic & composed change agent, I am passionate about identifying & solving issues related to the digital domain, by means of analysis and innovation.Key Competencies:+ Program & Project Management+ Requirement Analysis+ Data Analysis+ GCP Architecture + Agile Methodologies+ Team Management+ Communication and Negotiation+ Vendor ManagementKey Achievements:a) Core team member in driving the Agile Transformation Program aimed at helping the organization adopt the agile operating model with an objective to combine velocity & adaptability with stability and efficiency.b) Development of Datalake on GCP platform for maintaining single version of truth for processing and analytics. i. Finalizing Architecture and flow of data from L1 and L2 system to GCP ii. Creation of 200+ BODS JOBS for data transfer from L1, L2 systems to Staging locations in cloud Program for transferring data from Cloud Storage to BigQueryc) Development of dashboards in tableau for higher management with near real-time access.d) DB Design & Performance review i. Design review of 300+ ERDs for various projects(Oracle+MS SQL + BigQuery) ii. Query performance improvement via explain plan (MS SQL) Central Master DB and Central Transactional DB performance monitoring via AWR reports (Oracle)e) Designed & implemented Augmented Reality for integrated Remote Operations Center, to see real-time data from sensors over live CCTV video remotely.f) Hyper Automation of Key IT processes - i. PO Dashboard and program for automating daily reports (Saves 4 FTEs hour daily). ii. Self service password tool to reset the password of employees from various sub-systems.g) Architecture and development of Camera monitoring tool to see the up-time and Quality of CCTV cameras for surveillance and security along with automated dashboards.Please contact me at a••••••••@gmail.com to find out how I might contribute and add value to your organization.

Experience

1. Manager - Technology and Analytics

   Majid Al Futtaim

   May 2024 — Present · Indore, IN

   Enable Audit, Fraud and Forensics team to conduct data backed audits and improve processes in retail and properties space.

Education

• Bangalore University

  Bachelor of computer Applications, Computers

  2006 — 2009

• Christ University, Bangalore

  MCA, Computers

  2009 — 2012

Skills

• Sql Server
• Unix
• Core Java
• Programming
• Sql
• Linux
• Databases
• Oracle
• C#
• .net
• Java Enterprise Edition
• C++
• Microsoft Sql Server
• Visual Basic
• Windows
• Eclipse
• Pl/Sql
• Javascript
• Software Development
• Java
• Jsp
• Mysql