Debashis Basu

Experience

• 

  IBM Global Services

  Jan 2005 - Jan 2008

  System Engineer

  System Engineer - IBM Global Services India (2005 - 2008)~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Projects:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: British Petroleum, UKFunctional area: Retail and Supply ChainProject: DART Australia Upgrade This assignment involved Australia functionality upgraded from Release3 to Release4 and inclusion of Franchise functionality in Retail in AU. Involved as Informatica Lead in DART Australia Upgrade project. Team Size: 3Project: DART UK DOFO Implementation Involved as a senior developer in designing and developing Informatica objects. Objective of this project was to implement Dealer Owned Franchise Operated Retail model.Project: BP Retail DART US Franchise Involved as a Single Point of Contact for Informatica team in DART US Franchise – BP Retail. Team Size: 4Project: BP Retail DART UK Retrofit Involved as a senior developer in designing and developing Informatica objects.Project: BP Retail DART ANZ Involved as an application developer in developing Informatica objects. Also involved as an application developer in designing and developing a data cleansing and conversion tool (DC Tool) in MS Access.Project: BP Retail DART DITM Involved as an application developer in developing Informatica objects.----------------------------------------------------------------------------------------Client: Nestle, SwitzerlandFunctional area: FMCGProject: Nestle Globe Involved as an application developer in developing Informatica objects. Show less

• 

  IBM India Private Limited

  Jul 2008 - Dec 2017

  - Finalizing ETL Architecture and design patterns in coordination with Client teams.- Participating in source system workshops with client source system teams and - Getting clarifications on requirements during requirement gathering phase by interacting with Business Analysts from client side.- Designing ETL standards, strategies and frameworks.- Preparing High Level Design and Low Level Design.Projects :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: Turkish Airlines, TurkeyProject: Turkish Airlines CRM Program [May 2015 – Till date]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: Finnair, FinlandProject: Finnair Delfoi [Jan 2014 – Apr 2015]~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: IESO, CanadaProject: IESO [Feb 2014– Aug 2014] Show less Data Specialist - Informatica PowerCenterSpecialization in SAP-Informatica integrationSenior Quality PractitionerProjects :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: Medtronic, USAFunctional area: Medical instruments and therapiesProject: Medtronic BAOThis assignment involves implantation and enhancement of Data Integration solution for Medtronic.Involved as Informatica EAI Off-shore Team Lead in Medtronic BAO project. Team size: 4 Show less Data Specialist - Informatica PowerCenterSpecialization in SAP-Informatica integration Senior Quality Practitioner~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Advisory System Analyst - IBM India Private Limited (2010 - 2012)Senior System Engineer - IBM India Private Limited (2008 - 2010)Projects :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Client: Medtronic, USAFunctional area: Medical instruments and therapies Project: Medtronic BI This assignment involves implantation and enhancement of Data warehousing solution for Medtronic. Involved as Informatica EDW Team Lead and On-site coordinator in Medtronic BI project. Working from US client location. Team size: 8-----------------------------------------------Client: British Petroleum, UKFunctional area: Retail and Supply ChainProject: UK Central Replenishment This assignment involved implantation of Central Replenishment process for BP Retail. Involved as Informatica Development and Integration Lead in DART UK Central Replenishment project. Team Size: 5Project: BP DART Reportage This assignment involved developing BP DART Reportage, a bunch of reports to help operation team. Involved as Informatica Lead in BP DART Reportage project. Team Size: 5 Show less

  • Data Warehouse Architect

    Jan 2014 - Dec 2017

  • Senior System Analyst

    Jul 2012 - Dec 2013

  • Advisory System Analyst

    Jul 2008 - Jun 2012
• 

  IBM

  Jan 2018 - Aug 2018

  Data Integration Architect and Airline SME

  Project: Emirates Group – Quantum Program This assignment involves SAP Vanilla Implementation and Transformation in the area of Procurement & Logistics, Finance and Human Capital Management for dnata (an Emirates Group Company for Ground services, Catering services and Travel Operations) and Emirates Airlines.Position: Data Integration Architect and Business AnalystContribution: Working as an Airline SME and Data Integration Architect for:• Assessing the As Is Systems and Integration landscape of the 60+ Legal Entities• Work with Functional team to come up with a Proposed To Be landscape• Work with Functional team and the Legal Entity SPOC to identify the To Be Interfaces• Line of business covered: Airport Operations, Airline Catering Services and Travel Operations• Functional areas covered: Finance, Sales and Distribution (OTC), Procurement and Logistics, Human Capital Management• Managed engagement with the legal entities spanning across globeWork Environment comprised of SAP S/4 HANA, SAP SuccessFactor, SAP Ariba, SAP Field Glass, SAP Concur, IBP, BPC, GRC, Mindtouch, Enable Now, IDM, Workforce, BO Data Services, HANA Cloud Platform, HANA Cloud Integrator and SnapLogic-iPaaS. Show less

• 

  IBM India Private Limited

  Sept 2018 - now

  Project: Pearson Education, North AmericasThis assignment involves Application Data Migration for Rights and Royalties from RAS (Mainframe based application) to Fadel IPM (Java and Oracle based application) and migration of other business processes to Oracle RSS and EBS. Rights and Royalties being one of the most complex functionalities in publishing industry, this involves very high complex designs in ETL and Database level.Working as Data Architect for:• Assessing scope of migration• Preparing Data Migration Strategy• Designing ETL Architecture including Audit and Reconciliation Framework• Coordinating with the Target Application team (Fadel) the Offshore Development Team • Line of business covered: Rights and Royalties• Functional areas covered: Vendor Master, Product Master, Author Deals, Subright Deals, Sales, AccrualsWork Environment comprised of RAS (Mainframe based application), Fadel IPM (Java and Oracle based application), Oracle RSS and EBS, Oracle Managed Cloud Services (OMCS) and Informatica PowerCenter. Show less

  • Data Architect

    Dec 2019 - now

  • Data Architect

    Sept 2018 - Nov 2019