Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Abhijit Bose

Phoenix,AZ

Summary

Having 16+ years of software experience involving the various phases of software development cycle in SAP-ABAP, AWS cloud-based application, Redshift & Snowflake. Completed multiple end-to-end implementations & post implementations and played key role in all phases of project methodology. Hands on expertise in handling both SAP, AWS, ETL Implementation and Support projects covering all the functionalities. Develop and implement solid, scalable and flexible data lake solutions to support clients migrating and transforming from on-premise to cloud solutions, particularly Data, Data Integrations and Analytics. Define and implement standards and processes to ensure alignment with the architectural strategy and goals of the business. Hands-on expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel. Hands-on experience on Big Data model techniques using Python. Experienced with data security and data access controls and design. Expertise in Snowflake – data modelling, implementing complex stored Procedures and standard DWH and ETL/ELT concepts. Implement data handling, cleansing, and standardization procedures and business transformation rules and logic. Built modern approaches to automating data pipelines. Develop ETL/ELT pipelines in and out of data warehouse using combination of Python, IICS Snowflake, AWS & Azure tools. Proficient in writing Cloud Formation Templates (CFT) in YAML and JSON format to build the AWS services with the paradigm of Infrastructure as a Code. Leveraged code repositories and continuous integration tools. Experienced with event-driven and scheduled AWS Lambda functions to trigger various AWS resources. Extensively worked using AWS services along with wide and in depth understanding of each one of them. Proficient in AWS services like AWS glue Job, S3, CloudWatch, Code Pipe line, SNS, SQS, IAM. Experienced in implementation of Data Warehouse (Redshift & Snowflake) and ETL & ELT solutions. SAPUI5 Front End Development using JavaScript by MVC Pattern. Developed Desktop/tablet-based SAP Applications. Developing model and data provider API’s in ECC for Gateway services. Creating and consuming oData services in front end application. Data transformation of oData Services using Json format. Having Experience in SAP/Python Object Oriented programming. Experienced in Manage supply chain data and related analytics for clients by designing, producing, analyzing, continuously improving, and presenting monthly logistics and supply chain metrics, measuring operational and financial performance against customer specific objectives. Identify, prioritize, structure, and solve complex supply chain problems using data mining, analytics, and business judgment. Extensively worked for Material Management (MM), Sales & Distribution (SD), Warehouse management (WM), Finance (FI) , Plant Maintenance (PM) and After Market (AM). Involved in POC for Informatica DEI / IICS connecting different platforms. POC on setting up Azure platform for deploying Airflow & Bitbucket as code repository. Good understanding of mapping business processes and gathering requirements for new development objects from business users and convert them into technical requirements. Strong believer in teamwork, building cordial relation with people inside and outside the organization, innovative solutions for difficult programming problems, self-learner and fast learner.

Demonstrates strong analytical, communication, and teamwork skills, with proven ability to quickly adapt to new environments. Eager to contribute to team success and further develop professional skills. Brings positive attitude and commitment to continuous learning and growth.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Lead Analyst

EDW (ISC workstream)
01.2024 - Current
  • Partner with ISC leaders to define scope for EDW (what business processes, KPIs, and domains to land next); maintain a prioritized backlog aligned to council priorities and AOP.
  • Manage and optimize the end-to-end Integrated Supply Chain (ISC) data stream within the Enterprise Data Warehouse (EDW), enhancing data integrity and visibility across Inventory, Procurement, Warehouse, Logistics, and R&O process.
  • Enforce data standardization and Critical Data Elements (CDEs); ensure business definitions, policies, and metadata are captured and kept current.
  • Drive end-to-end delivery through sprints; coordinate requirements → design → dev → testing → UAT → production with clear acceptance criteria and UAT sign-offs.
  • Lead discovery with ISC SMEs; develop BRDs/epics/stories with clear business rules, data mapping, and acceptance criteria. Produce or co-own BRDs with business and technical counterparts.
  • Build test scripts, reconcile QA/PROD variances, and secure sign-offs.
  • Establish data governance for critical ISC master data elements (e.g., SKUs, Bills of Material, Supplier IDs, Plant etc.), defining ownership, stewardship, and quality standards to ensure data reliability.
  • Functionally manage a team of 20 business analysts and developers through the full software development lifecycle (SDLC) for critical supply chain solutions, ensuring project alignment with business strategy and compliance.

Lead Data Engineer

ISC KPI & EDW (AWS Cloud, Azure ,Snowflake & IICS )
01.2018 - 01.2024
  • Led project development teams in cross functional environment to deliver data solutions aimed at improving customer experience, ensuring security compliance and building an enterprise data hub.
  • Deployed a fully operational data solution into production on Snowflake DW with technologies such as Microsoft Azure, Apache Airflow, Informatica DEI, IICS, HVR.
  • Define and implemented standards and processes to ensure alignment with the architectural strategy and goals of the business.
  • Recommend and drive innovative solutions while anticipating the future direction of the business, its drivers and technology strategy.
  • Participate in POC evaluations of technologies and tools.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • Collaborate with data architects to review logical data models. Then create the Physical data models in Snowflake.
  • Create DAGs in Apache Airflow platform for orchestrating workflows.
  • Build Python and SQL scripts to implement transformation rules to load Snowflake tables.
  • Setting up AWS & Snowflake NON Prod and Prod system with Security & DBA team.
  • Built S3 buckets and managed policies for S3 buckets and used S3 bucket and Glacier for storage and backup on AWS.
  • Develop automation for app teams for deployments in multiple environments like Dev, QA, and Production.
  • Involved in designing and developing, Amazon S3, Cloud Watch, Amazon SNS, Amazon SQS, Glue Job and other services of AWS infrastructure.
  • Design and Develop AWS glue job for ETL with Python and Spark.
  • Create event-driven and scheduled AWS Lambda functions to trigger various AWS resources.
  • Automate External table partitioning with Lambda function connecting to Redshift.
  • Create CICD pipeline to deploy all AWS resources, used TFS as code repository.
  • Creating Data models and set up security for Amazon Redshift & Snowflake.
  • Work with different Data Management approach covering – Master Data Management, Data Catalog, Data profiling and Security/Access management.
  • Apply discretion and independent judgment in answering customer requests and propose appropriate solutions.
  • Engage with customers in resolving problems and coordinate implementations.

SAP Technical Lead

Repair and Overhaul Integration Project (NTT DATA)
01.2016 - 01.2018
  • Key Point of contact for onsite & Offshore for all AM and OM Developments.
  • Leading application design discussions. Translating business requirements to robust technical designs. Performing feasibility and complexity analysis and proposing best-suited solutions.
  • Development and Technical design documentation.
  • Resource management, effort estimation, development prioritization.
  • Leading discussions with SAP Users and key stakeholders for effectively resolving of the issues.

SAP Technical Lead

CQCP (NTT DATA)
01.2014 - 01.2015
  • Responsible for front end UI development using SAPUI5 Framework.
  • Developed Front end UI, in JavaScript and HTML5 under MVC architecture.
  • UI Development as to compatible for Desktop/Laptop and iPad.
  • OData Service Generations.
  • OData Service Request/Response with ECC (REST Operations).
  • Data handling using jSon Conversions.
  • Developed back end jSon Data conversions in ECC using ABAP.
  • Developed OO ABAP Model Classes to handle the business logic.
  • Developed SAP DMS Custom API’s to handle Attachments in the tool.
  • Created and Modified Services for SAP Gateway.
  • Created class and Method in SAP to accommodate the functionality.

SAP Technical Consultant

Development and support of Solocup and Dart (NTT DATA)
01.2012 - 01.2013
  • Development of Pro-forma output via Adobe form.
  • Pick list Adobe Form development.
  • Development of MQD and BMQD end to end process.
  • Extended Generated IDOC (INIVAL interface) with Implicit Enhancement point.
  • Worked MM conversion BADI for old material number as external number.
  • Developed FIFO interface for tracking pricing discrepancy.
  • Developed custom Document flow for MQD.
  • Prototype of tracing TR dependency between two different development environments.

SAP Technical Consultant

RSDC (Bristlecone)
01.2010 - 01.2012
  • Lead the interface development for Israel, Bangladesh and Central Africa (8 countries).
  • Develop Complex EDI, WMS and BANK interface.
  • Estimation and planning allocation of Effort for R7 R8 and R9 release.
  • Support deployment of regional application in AAC region.
  • Mentoring and training Junior Consultant in SAP ABAP.

SAP ABAP Developer

IBM
01.2007 - 01.2010
  • Customer master and Material master Interface with change pointers.
  • Developed file interfaces for both presentation and application server.
  • Worked on DMEE interface.
  • Develop objects on dispute management.
  • Work on various reports, enhancement, smart forms.

Education

Bachelor of Technology - Civil Engineering

Jalpaiguri Govt. Engineering college

Skills

  • Snowflake
  • Data Warehousing
  • Cloud Migration
  • Extract, Transform, Load (ETL)
  • Data Modeling
  • SAP ABAP/4
  • Informatica DEI
  • Informatica Cloud (IICS)
  • Java Script
  • SQL
  • IDOC / EDI
  • SAP User Exits/ BADI/ EP
  • OData Services
  • SAP Workflow
  • SAP UI5
  • AWS Serverless Analytics
  • AWS Glue, Lambda, S3, SQS
  • Amazon Redshift
  • Azure Functions
  • Apache Airflow
  • CICD Pipelines
  • ADLS & Blob Storage (Azure)
  • Python
  • YAML
  • Spark
  • Github, TFS, BitBucket
  • Jira
  • Tableau/Thoughtspot
  • Data Migration
  • Agile Process
  • Leading teams of varying skill sets
  • Integrating different system with various technologies
  • Strong debugging skills
  • Involved in preparation of project plan
  • Design future state architecture and strategy

Certification

AWS Solution architect Associate

Timeline

Lead Analyst

EDW (ISC workstream)
01.2024 - Current

Lead Data Engineer

ISC KPI & EDW (AWS Cloud, Azure ,Snowflake & IICS )
01.2018 - 01.2024

SAP Technical Lead

Repair and Overhaul Integration Project (NTT DATA)
01.2016 - 01.2018

SAP Technical Lead

CQCP (NTT DATA)
01.2014 - 01.2015

SAP Technical Consultant

Development and support of Solocup and Dart (NTT DATA)
01.2012 - 01.2013

SAP Technical Consultant

RSDC (Bristlecone)
01.2010 - 01.2012

SAP ABAP Developer

IBM
01.2007 - 01.2010

Bachelor of Technology - Civil Engineering

Jalpaiguri Govt. Engineering college
Abhijit Bose