OMKAR R JAGTAP
Sr. Data Engineer
Pune,MH
Summary
Accomplished AWS and SAP Certified Data Engineer with extensive experience in end-to-end implementation, migration, and support projects. Expertise in data modeling, financial reporting, and analytics, combined with a deep understanding of AWS services and SAP tools. Proven track record in leading cross-functional global teams to deliver scalable, GenAI-driven solutions that meet complex business needs. Committed to leveraging technical skills and collaborative leadership to drive innovation and enhance data-driven decision-making.
Overview
14
14
years of professional experience
6
6
Certifications
Work History
Sr. Data Engineer
Barclays
07.2018 - Current
- Led the architecture, design, and development of an intelligent, LLM-powered SDLC automation platform aimed at accelerating software delivery and reducing manual effort.
- Architected a scalable, microservices-based, agentic workflow platform.
- Designed and implemented multi-agent orchestration systems using AutoGen/LangChain frameworks.
- Built intelligent agent communication protocols with supervisor-worker patterns.
- Developed state management systems for complex workflow transitions and phase tracking.
- Implemented dynamic agent routing and task delegation based on workflow requirements.
- Integrated multiple LLM models (GPT, Claude, etc.) for specialized workflow tasks.
- Implemented prompt engineering strategies for consistent agent behavior and output quality.
- Built context-aware memory management systems for agent knowledge retention.
- Modularized the solution into FastAPI-based microservices (JIRA, Confluence, Draw.io) deployed on Amazon EKS with secure, containerized components.
- Engineered an NLP-driven pipeline to convert unstructured business inputs into structured artifacts, serving as the source for downstream automation.
- Implemented CI/CD pipelines for automated agent testing and deployment, and built monitoring and logging systems for agent performance tracking.
- Built an end-to-end security architecture with authentication, authorization, audit logging, and data encryption for enterprise workflow compliance.
- Acted as a cross-functional leader, working across DevOps, analytics, LLM teams, and product owners—matrix reporting into both engineering and business leadership.
- Integrated enterprise data sources such as Athena, Redshift, and SAP BW/4HANA with LLM-powered summarization pipelines, enabling advanced analytics and data science use cases—blending SAP expertise with modern AI/ML stacks to deliver scalable enterprise automation.
- Led SAP BW/4HANA data modeling and migration, from source design to Composite Providers, query creation (RKF/CKF), ABAP routines, and reconciliation. Enabled reporting via Lumira and SAC. Optimized BW/4HANA performance, resolved data tiering/shadow table issues, implemented Hive/Spark SDA extraction, and delivered secure BPC 11.0 migration aligned with Barclays’ standards.
Sr. Application Development Specialist
Accenture
03.2015 - 07.2018
- Optimized standard data sources, LO cockpit, and generic data sources, improving system performance by implementing best practices and tuning techniques.
- Developed and configured Info Objects, Info Cubes, DSO Objects, transformations, and Process Chains aligned with business requirements and data modeling standards.
- Implemented automated flat file loading mechanisms, eliminating support team dependencies, and reducing service requests by 40%.
- Created and optimized process chains with automated alert mechanisms for failure notifications, ensuring a 99% data load success rate.
- Developed reporting layer components, including Calculated Key Figures (CKF), Restricted Key Figures (RKF), formulas, and variables for executive dashboards.
- Managed business-critical data loads and performed data analysis using Analysis Process Designer (APD) to ensure data integrity.
- Led the SAP BW 3.x to 7.x migration project, ensuring zero data loss and minimal downtime during cutover activities.
- Implemented a POC for HANA DB data provisioning using SAP Landscape Transformation (SLT) for real-time data replication.
- Eliminated QL tool dependencies for BW triggers, achieving cost savings, and reducing manual intervention by 60%.
- Performed comprehensive data validation and reconciliation between BW reports and SAP ECC source systems, ensuring 99.9% data accuracy.
- Collaborated with DevOps teams to design real-time monitoring dashboards (SAP 360-style) for process chain status tracking and error visualization.
- Currently leading an offshore technical team of 8+ members while providing 24/7 support across Asia, the UK, the USA, and Canada time zones.
Consultant
Yash Technologies Pvt Ltd
03.2013 - 03.2018
- Utilized the SAP Data Monitor tool to oversee enterprise data loads, identifying and resolving critical errors, including source system failures, PSA write errors, and Info Package startup issues, with a 95% first-time resolution rate.
- Performed comprehensive error debugging and root cause analysis for data upload failures, implementing corrective measures to prevent recurring issues, and maintain data integrity.
- Maintained a high-availability production SAP BW environment, ensuring 99.7% system uptime through proactive monitoring and preventive maintenance activities.
- Executed data cleansing and error handling procedures for Persistent Staging Area (PSA) data, ensuring accurate data transfer from PSA to Operational Data Store (ODS) objects.
- Managed staged data processing in ODS before transferring to Info Cubes, implementing best practices for data transformation and validation workflows.
- Improved ODS object performance by 30% through the strategic creation of secondary indexes and database optimization techniques.
- Created and maintained process chains for Info Packages with daily and weekly scheduling requirements, ensuring seamless, automated data processing.
- Analyzed the Info Package performance patterns and identified the root causes for frequent failures, implementing preventive solutions.
- Implemented advanced performance tuning strategies, including aggregate creation, table partitioning, and data compression, achieving a 40% improvement in query response times.
- Performed extensive data validation and reconciliation activities, comparing BW datasets with source SAP systems, ensuring 99.9% data accuracy.
- Updated and maintained technical specifications and unit testing (UT) documentation, ensuring compliance with organizational standards, and facilitating knowledge transfer.
- Collaborated effectively with multiple support groups, including Basis, Security, and Application teams, to resolve complex technical issues and implement system enhancements.
- Implemented minor system enhancements during support activities, improving system functionality and user experience based on business requirements.
Graduate Engineer
Gazprom Marketing & Trading
11.2011 - 03.2012
- Monitored and managed daily and monthly data loads across multiple business applications, delivering automated status reports to over 50 business stakeholders, with 99.8% SLA compliance.
- Maintained and optimized complex process chains for enterprise data warehouse operations, ensuring seamless data flow across the SAP BW landscape with minimal downtime.
- Resolved critical data load failures, process chain errors, and database tablespace issues within defined SLA timelines, maintaining system availability above 99.5%.
- Led change management initiatives for SAP BW system modifications, coordinating with cross-functional teams to implement business-driven enhancements, while maintaining system stability.
- Managed a portfolio of 10+ concurrent SAP BW projects, including system upgrades, performance optimizations, and new data source integrations, delivering projects on time and within budget.
- Developed comprehensive error log documentation and best practice guidelines, reducing incident resolution time by 35%, and improving team efficiency.
- Partnered with the SAP Basis team to optimize system resource allocation and enhance platform stability, resulting in a 25% improvement in query performance.
- Executed automated housekeeping chains and data archival processes, maintaining optimal system performance and storage utilization.
- Conducted systematic optimization of SAP BW Flow, Info Cubes, reports, and Integrated Planning (IP) objects, improving end-user response times by 40%.
- Managed end-to-end data warehouse operations, supporting critical business processes across Finance, Sales, and Supply Chain domains.
- Collaborated with business users, IT teams, and external vendors to deliver data solutions aligned with organizational objectives, and compliance requirements.
Education
M.S - Computer Science
Coventry University
Coventry,UK09-2011
B.E - Computer Engineering
Pune University
Pune, India05-2010
Skills
Python, CrewAI, Autogen ,LangChain, AWS Bedrock other AWS services , FAISS,RAG pipelines, BAM(RBAC)Ad-hoc , FASTAPI
Gitlab CI/CD, Jenkins ,PyTest, Docker,EKS Streamlit, Plotly-Dash, NICEGUI
SAP : SAP BW4HANA / SAP Analytic Cloud , Analysis for Office, Lumira 21 , SAP BO Dashboard, SAP BW 3x to 7x
Other: Hadoop 41 – Hue Editor , snowflake, Groovy script, CSS,HTML
Certification
Qualification and Certification
Blogs
- Blog and Project Video URL
- AI-Powered Data Insights : https://www.linkedin.com/posts/omkarjagtap_in-my-latest-poc-i-built-an-ai-powered-analytics-activity-7302767326280482816-ZogT?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAVEiWMBpPgjG1gk4zQ0iTIwWlvcXpSfFC4
- Projects : https://github.com/jagtapom
- Https://www.youtube.com/watch?v=IFomIcFfdjI
- Http://technocracy-society.blogspot.in/ https://in.linkedin.com/in/omkarjagtap
Accomplishments
Demonstrating Our Value of Service and for Empower,
High Delivery Performance and Effective Collaboration Award, Embraces change with agility and adaptability.
Received Service Excellence Award from Client (CTO of Linde AM project) and
Accenture ACE Award.
HACKATHON Winner Campus 2025 : Link
Timeline
Sr. Data Engineer
Barclays
07.2018 - Current
Sr. Application Development Specialist
Accenture
03.2015 - 07.2018
Consultant
Yash Technologies Pvt Ltd
03.2013 - 03.2018
Graduate Engineer
Gazprom Marketing & Trading
11.2011 - 03.2012
M.S - Computer Science
Coventry University
B.E - Computer Engineering
Pune University