Avishkar Meshram

About Avishkar Meshram

Data Engineering SME with 22+ years of leadership experience in executing large scale Data Engineering solutions along with adoption of Modern Databases, NoSQL, Big Data, AI/ML, Business Intelligence and Cloud Infrastructure.• Ex-Co-Founder & CTO of TaskLance.com - Niche Technology Experts’ Marketplace which allows companies to Connect Gigs and execute Independent Projects with 30% reduction in project costs and 35% effieciency than traditional timelines.• Played various roles such as Enterprise Data Architect, Data Solution Architect and Big Data Architect, Delivery Management, DBA, Database & Business Intelligence Architect.• Well versed with Data Strategy, Technology Consulting, Service delivery management, Capability building, Delivery excellence and Customer engagement.• • Design & implemented Record Vault - Real time data Insights to capture, manage and analyze real-time operations data and improve productivity, profitability and compliance of their customers. • Defined and designed Cloud Migration strategy implemented best practices and meticulous planning to migrate 1200+ databases from SQL server VM to Azure SQL Managed Instance.• Implemented AI based Test coverage framework to leverage NLP to use application logs as a feature for Machine learning model to provide Positive and Negative Test cases which improved the QA and Dev productivity by 30% and also reduced defect rate by 40%• Designed & Delivered Enterprise Application platform for Fortune 500 Bank to provide Data Governance using Cloudera Data Platform, Apache Spark. • Designed and implemented back-end storage, querying mechanism, Dashboard and Reporting using Java, ReactJS, Elasticsearch and MongoDB for network threat protection based on Deep learning platform. • Created Fashion Product Recommender POC, leveraging Generative AI technologies to enable Semantic Search and discover similar items significantly enhancing the both Online and Offline Fashion Retail experience.• Design & Implement Traceability and Risk Prediction Platform using Apache Spark and Neo4j for the Food supply chain using advanced analytics and machine learning models. • Hands on experience of including Relational databases, DWH, Data Lake, Delta Lake( Databricks), Big Data Technologies,NOSQL Databases, Business Intelligence (QlikView, PowerBI, Tableau) and cloud technology (AWS, Azure).• Author of Data Engineering blog- https://avishkarm.blogspot.com/• Angel Investor in Edtech Software company and Snack foods company

Experience

1. Principal Architect (Data Engineering)

   Xoriant

   Sep 2018 — Present · Mumbai, IN

   Design & Implemented Record Vault - Real time data Insights for leading Plant Management Platform to capture, manage and analyze real-time operations data and improve productivity, profitability and compliance of their customers. Record Vault ingest the data from multiple data sources using Azure Data Factory and load data into Azure Synapse Analytics and providing Near real time reports and dashboards using Logi Analytics• Designed & Delivered Enterprise Application platform for leading global bank to provide Data Governance using Cloudera Data Platform, Apache Spark. It includes discovering Golden Source Data, develop a data model and create a pipeline ingest data coming from different sources and loading of structured and unstructured data in Data Lake and analyzing data using Hive and Qlikview.• Designed and implemented back-end storage, querying mechanism, Dashboard and Reporting using Java, ReactJS, Elasticsearch and MongoDB for Deep learning platform to detect network threats. It uses MongoDB to hold petabytes of data for source of truth and Elasticsearch to provide search and Analytics capability.• Successfully strategized and driven Database Migration projects from On-Premise to Cloud using AWS/Azure Data Pipeline and Data migration services.• Provided logical, physical, and dimensional data modeling expertise, including models for Business Intelligence Analysts. • Took ownership of SME and Single Point of Contact for Product Development, Data modeling, Database Design, technical deliveries and project management• Own all database activities right from Requirements Analysis, Database Design, Implementation, Data Loading, Performance Tuning, Operation, testing and Maintenance.• Project management activities - Build project plan, Client calls and demo, conduct daily scrum, review end user documentation and client deliveries, weekly status reports.

Education

• Veermata Jijabai Technological Institute (VJTI)

  Master's Degree, Computer

  2000 — 2002

• Visvesvaraya National Institute of Technology

  Engineer's Degree, Computer

  1994 — 1998