Sudipto Dutta Email and Phone Number

Citibank is planning to expand its mobile payments and collections offering to more countries across the Sub-Saharan Africa region on a new platform. The new mobile money payments and collections platform will incorporate a third-party payments gateway service and an integration layer built on a technology stack that is compatible with the strategic “global common core” with a clearly defined migration path to the strategic platform.The solution should be able to handle high volume (Payments 1.15MM transactions & Collections 0.994MM per annum transactions), low value remittances whilst complying with transactional and velocity limits set by the relevant MMO’s and/or regulators from time to time. Responsibilities :• Managing end to end Release and coordinating with Dev, QA, Client managers and Third Party Team• Publishing Project Induction Manual, Architecture Diagram in Project Confluence Page. Onboarding New Resources and Organizing Knowledge Sharing Sessions.• Coordinating with existing Dev team top understand the Basic Core Foundation and emulate Devops Configuration.• Arranging the Daily Scrum Call and Publishing the Status Quo on Weekly Basic and Governance Deck on Monthly Basis.• Conducting Interview to hire external Candidates.

Citi GDR is a Citi hosted data repository which is used to support CCRS reporting requirements and to generate outbound files for Commercial Cards domestic and global clients' ERP and/or accounting systems.TS2 upgrade program is part of the GDR reengineering program. This program is triggered by the Citi’s upgrade to comply with TS2 processing platform of TSYS NA from the current TS1.TS2 upgrade will primarily deal with the capture of TS2 DEF inbound feeds, loading to staging layer and Outbound DataMart(ODM) as well as generation of global outbound files namely GCM,SAP,CDF & VCF, CGI, ARIBA.Sudipto have joined the project as Talend Architectand manages Outbound Delivery for GDR2 as Technical Lead. His responsibilty is to help the team to provide an efficient cost effective solutions to the client, design and develop the outbound files, review the code and test case results, managing offshore resourcses in various geographical locations (Kolkata, Chennai), arrange design and code walk through meeting with client, deployment the code in higher environment.

FleetCor Technologies, Inc provides fuel cards and workforce payment products and services. FleetCor has a Global FleetNet (GFN) fuel card processing platform to run all card programs for its customers like Caltex, Shell and chevron.As a Technical Head, he has been performing the following roles :-• Worked as lead integration developer between GFN and the various outer systems such as Dynamics AX, Atlas, Salesforce CRM, SAP ERP etc.• Understanding the general architecture and providing an optimized solution to the client to obtain the integration between two layers using Talend DM tool.• Adhering to the project quality and processes by preparing high level design document, Unit testing log etc.• Handling new on boarded team members and providing them the necessary knowledge about various technologies and architecture.

GRU ETL Build is an UBS in house developed collection of various applications GLOBAL 1, GLOBAL 2 etc. It provides various tools which can be used to provide data to the TLM applications as per the TLM acceptable format which is going to be used for reconciliation and projection into dashbaord and also helps in generating reports by extracting data from TLM database. The Business requirements/Functional Specifications of the upstream feeds are provided by the Business Analysts to the TLM Design Team who is responsible for creating the ETL Technical Specification and the Knowledge Base for the ETL Build Team. GRU gets data feeds from various upstream, verified and formatted as per the TLM reconciliation tool input format for reconciliation. As an Application lead he has been performing the following roles :-• Engaged in Knowledge transfer activities to get the overview of the architecture, processes and Involved in knowledge understanding presentation and preparing the required document for perusal.• Handling offshore captives.• Involved in shared phase with the existing team member and helping team to achieve a smooth transfer.• Working as an application lead for Global 2 application, managing the releases and coordinating with various groups (Business analyst, Design team, QA team, Developer) as and when required.

The iDWH solution is single source of consolidated data aims at providing an enterprise-wide view of the business at the PB sites. It is main source of information for reporting and analyzing Data Marts (DM), including all departments, lines of business and business functions.The iDWH system follows the concept to connect multiple backend systems to a common data platform and exposes data from various sources to global applications like the PBMA system. It strives to provide data quickly and in a format that greatly enhances the decision making process. As a Developer he has been performed the following roles :-• Engaged in various phase of Platform Improvement activity of idwh like Harmonization of FCCE workflows i.e. making a single session single workflow model, month-end decoupling for APAC & UK region, introduction of daily reporting to the client etc.• Working as a lead developer.• Developing and Modifying Informatica Mappings from a mapping specification document provided by Business Engineers.• Code review, test case review and Post Deployment Checks.• Participating in Business Walk through meeting

PB MA stands for private banking management accounting and it has two parts. One part is called MIS and other part is called RPT. MIS part of PBMA is called Data Universe. MIS Data Universe consists of mainly two layers.1. Landing Zone.2. Preparation Area.MIS Data Universe consists of three layers. INP for raw data staging ODS for base data staging and GBD for grouped base data. Roughly 250 Feeder applications deliver data into PBMA. These Feeds are composed of different files from different data sources (so-called Lieferherkünfte) that comprehend the required data for the calculation of key figures. Data are delivered in the so-called landing zone and further triggered into the so-called INP area. In a second step they are enriched and coded on the so-called ODS and GBD. GBD is referred as grouped base data and this layer contains 6 fact tables. In GBD area data comes from ODS in more aggregate form.As a Developer he is responsible for• Developing and Modifying Informatica Mappings.• Developing and Modifying PLSQL packages, Procedures and Functions.• Used Informatica workflow manager to create sessions and used MFC (in house tool of Credit Suisse) for running the PowerCenter mappings, Korn Shell Scripts and PLSQL packages. • Defining the Unit test cases in HP Quality Center.• Check in the Code in CVS with proper deployment Tag for migration and updating the COV list (deployment list) in Clear Case.• Code review, test case review and Post Deployment Checks.• Apart from all these he is responsible for Co-ordinating with the IT Project Leaders, Requirement Engineers and Configuration Management team of Credit Suisse.

The project basically works as a part of Data warehousing and deals with the millions of data that are coming from application domain of Credit Suisse. In the application there are more than 10 areas in which the bank works like Accounts, Payments, Suisse Cards etc. and they are called as different Subject Database (BDB). They all are developed on various technologies. A separate set of processes are going on to accumulate these transactional data and store them in a flat file. Input supplier is fully responsible for providing the data. These flat files are then used as a source of various Informatica mappings and workflows. There these raw data are summarized and are stored in the target tables. These summarized data are faded to the input of OLAP system which is useful for Decision Support System.• Worked for the DW Environment Setup program at Offshore which includes - Installing repository server in Unix Environment - Installing PowerCenter Server - Creating informatica users - Creating informatica groups - Creating relational connections - Creating UNIX folder structures. • Analyzed the BSDs that are sent from onsite.• Worked on Informatica Developer – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet and Transformations.• Involved in the development of Source to Target Mappings which includes almost all the transformation to fulfill the requirement.• Used most of the Transformations such as Source Qualifier, Aggregator, Lookup, Filter, Sequence generator, Update strategy, Joiner, Normalizer etc.• Used Informatica workflow manager to create sessions. Workflows to run the mappings.• Created database related scripts for PEU and ET environment like creating DDL script, defining table space, defining indexes.• Responsible for cross-review of mappings, workflows and UTC developed by others.