Ashok Pramanik
Kolkata,West Bengal
Summary
Highly accomplished Lead Data Engineer with 11 years of extensive experience in data engineering, SQL Server development, and data architecture. Demonstrated expertise in building data warehouses (DWH), designing OLTP databases, and leading large-scale data engineering projects. Proficient in cloud-based technologies including Microsoft Azure and Google Cloud. Certified Google Professional Data Engineer and Accenture Certified Data Architect. Strong background in machine learning, deep learning (DNNs, YOLO V8), and generative AI (LangChain for RAG and LLM fine-tuning). Proven leadership in managing teams and driving agile project development.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior BI Developer
Accenture
03.2017 - 11.2017
- Led the development of ETL pipelines using SSIS and SQL Server for analyzing vast amounts of employee punch data for a major insurance provider
- Created reports with SSRS and SQL stored procedures to deliver actionable insights
Senior Data Engineer
Accenture
12.2017 - 11.2018
- iValet Project: Designed ADF pipelines to integrate data from multiple sources like Workday and Salesforce into a centralized DWH, improving data accessibility.
Senior Data Engineer
Accenture
12.2018 - 05.2019
- Operational Data Store (ODS):Architected an ODS for processing terabytes of user transaction data using Azure Databricks and PySpark, enabling near-real-time data availability through APIs and stored procedures
Lead Data Engineer
Accenture
06.2019 - 05.2020
- vNext Platform: Led a team of 14 in developing a large-scale platform managing thousands of users’ activities, using Azure SQL Managed Instance, Python, and PySpark. Supported real-time data updates through microservices and detailed reporting.
Lead Data Engineer
Accenture
06.2020 - 02.2021
- VoiceGen Project: Built an on-device speech-to-text detection system using TensorFlow and DNNs, with TensorFlow Lite for inferencing and Apache Airflow for data orchestration.
Lead Data Engineer
Accenture
03.2022 - 08.2022
- Intelligent Observation Capture: Implemented image analysis in a mobile app using YOLO V8 to detect compliance with trash placement policies. Automated the review process, significantly reducing manual verification.
Data Architect
Accenture
09.2022 - 02.2023
- User Tracking System: Created a real-time user tracking solution with Google Pub/Sub and BigQuery, integrating generative AI models for enhanced path detection and analytics.
Lead Data Engineer
Accenture
03.2023 - 09.2023
- Automatic Scheduling: Here we have implemented a GEN AI solutions to detect the shortest path for user to travel and also assigned the users in shortest paths. Implemented a GEN AI solution to detect the shortest path for users to travel and assigned the users in shortest paths
Lead Data Engineer
Accenture
10.2023 - 12.2023
- Budget Predictions: Here we built a ML model to predict budgets for a major services vendor in US wherein earlier the budget calculation was a manual process.
Data Architect
Accenture
07.2024 - Current
- Intelligent Data Platform: Architected a comprehensive lakehouse solution with DWH and data lakes for a service provider, assessing multiple technologies and finalizing Microsoft Fabric for its capabilities.
Data Architect
Accenture
01.2024 - 06.2024
- Customer Data Platform (CDP): Designed a CDP for managing customer data from various real estate systems, using Synapse with a medallion architecture and Azure Purview for governance. Maintained high data quality and reliability.
Data Engineer
MAQ SOFTWARE
09.2016 - 03.2017
- Developed data transfer processes with SSIS and ADF v1, ensuring smooth integration between on-premises and cloud systems
- Created interactive Power BI dashboards using advanced DAX queries for comprehensive data visualization
- Contributed to the development of a support ticketing platform for a major client, optimizing data handling and response
Software Developer
SKYTECH Solutions (now TCG DIGITAL)
09.2013 - 09.2016
- Developed robust ETL pipelines using SSIS and created high-performance stored procedures for automating data load processes
- Managed and processed terabytes of data for a major airline client, optimizing data pipeline efficiency and reliability
- Enhanced reporting workflows, improving data accessibility and reducing processing times
- Developed robust ETL pipelines using Pentaho Data Integration to load data into Elasticsearch
Education
Bachelor of Science - Computer Science & Engineering
West Bengal University of Technologies
Kolkata05-2012
Skills
- OS: Linux, Windows
- Cloud: Microsoft Azure, Google Cloud
- ETL & ELT Tools: Azure Data Factory, SSIS, Pentaho Data Integration
- Programming Languages: SQL, Python
- Data & AI : Microsoft SQL Server, Azure SQL Managed Instance, MySQL, PostGre SQL, Azure Databricks, Azure Synapse Analytics, Microsoft Fabric, Pyspark, Power BI, Tenforflow, Keras, Scikit-learn, Gen AI, Langchain, Pandas AI, Azure Open AI
Certification
- Certified Google Professional Data Engineer
- Accenture Certified Data Architect
- Accenture Certified Technology Architect Associate
Accomplishments
- Led a multi-terabyte DWH project, significantly improving enterprise reporting.
- Reduced system response time by 30% through real-time data processing.
- Implemented advanced ML models for high-accuracy object detection.
- Enhanced data retrieval processes using fine-tuned LLMs, increasing productivity.
Affiliations
- Active member of data engineering and AI professional networks.
- Regular participant and speaker at industry conferences.
Awards
- Spot Award, TCG Digital, 03/01/15
- Star Performer of the Year, Pramati Technologies, 04/01/19
- Gold Class Award, Pramati Technologies, 03/01/21
- Pinnacle Award, Accenture, 01/01/24
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Bengali
Bilingual or Proficient (C2)
Timeline
Data Architect
Accenture
07.2024 - Current
Data Architect
Accenture
01.2024 - 06.2024
Lead Data Engineer
Accenture
10.2023 - 12.2023
Lead Data Engineer
Accenture
03.2023 - 09.2023
Data Architect
Accenture
09.2022 - 02.2023
Lead Data Engineer
Accenture
03.2022 - 08.2022
Lead Data Engineer
Accenture
06.2020 - 02.2021
Lead Data Engineer
Accenture
06.2019 - 05.2020
Senior Data Engineer
Accenture
12.2018 - 05.2019
Senior Data Engineer
Accenture
12.2017 - 11.2018
Senior BI Developer
Accenture
03.2017 - 11.2017
Data Engineer
MAQ SOFTWARE
09.2016 - 03.2017
Software Developer
SKYTECH Solutions (now TCG DIGITAL)
09.2013 - 09.2016
Bachelor of Science - Computer Science & Engineering
West Bengal University of Technologies
Similar Profiles
Mohammed Zaid BangiMohammed Zaid Bangi
Middleware Administrator at AccentureMiddleware Administrator at Accenture
JESWIN JAINJESWIN JAIN
Performance Tester at AccenturePerformance Tester at Accenture
Amanjot Kaur LambaAmanjot Kaur Lamba
Workday Integration Consultant at AccentureWorkday Integration Consultant at Accenture
Sumit PatilSumit Patil
SAP Security and GRC Consultant at AccentureSAP Security and GRC Consultant at Accenture
Trideep MondolTrideep Mondol
Senior Customer Service Representative at Teleminds Infotech Private LtdSenior Customer Service Representative at Teleminds Infotech Private Ltd