Dibyajyoti Sarkar Email & Phone Number

Vernier, Ge, Ch

Geneva, Switzerland

• Work with the data analysis team and the business stakeholders to define business and systems requirements for new releases to enrich the data warehouse• Develop self-service usage of the data warehouse through communication, change management actions and any other means• Assess and cultivate long-term goals for data warehousing in conjunction with data users, business managers, and other key stakeholders• Coordinate external resources on-site or off-shore for the delivery of the Corporate Data Warehouse releases according to the plans and budget• Coordinate and work with other IT teams to develop database architectures, coding standards, and quality assurance policies and procedures• Plan and implement capacity and resource expansion to ensure data warehouse scalability• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets• Manage the implementation, deployment, monitoring, maintenance, upgrade, and support of the Corporate Data Warehouse and DataHub, including data architecture, data integration, high availability, security, and data privacy• Coordinate operations staffing, including selection, supervision, scheduling, development, and evaluation of consultants across multiple locations• Ensure change management practices conform to organization wide standards• Major Skills – Data Management & Data Quality, Database Modelling, Data Warehouse and Datamarts, MS-SQL, Tableau, SOA/ Web Services, Data Lake, Big data, Dell Boomi, Salesforce, Oracle Fusion, EPM, Coupa

Geneva, Switzerland

• Act as Lead and focal point from Data Services and Analytics Services for IT Business Partners and Business teams for the applications they are responsible for.• Ensure systems stability including the transition to new enhancements introduced and integration to other systems.• Monitor workflow processes, troubleshooting, setup and performance.• Test application upgrades and patching within agreed parameters.• Manage regular feedback with the IT Solutions Delivery Teams and Product vendors to ensure system functionality and resolution of issues within agreed SLA.• Manage the respective application environments, cloning, refreshes, production configuration and system administration activities.• Manage and execute/ oversee month-end activities on the various applications while ensuring compliance to audit requirements.• Manage, coordinate and work with product vendor support teams for any production issues.• Guide the IT Solutions Delivery and Application Support teams on any systems related issues. • Prepare weekly and monthly reports for review by the Data Services and Analytics Services Managers, that will include elements like incidents, changes, emergency changes, SLAs on tickets/uptimes etc, overview of P1 issues, risks & mitigations, audit compliance status etc.• Act as key liaison from IT for annual external IT audits.• Verify and conduct sanity checking of new system releases including the test and sign-off of essential configurations an custom developments.• Plan, test and deploy Application /Database upgrades and patches by working closely with the IT Solution Delivery teams Team Leads and IT Business Partners.• Act as the escalation point for issues to the 3rd party application providers.• Manage, plan and align administration activities for the various applications they are responsible to ensure all month end/quarterly activities are executed successfully on time.

Geneva, Switzerland

• Manage projects and initiatives in Switzerland for a non-profit organization leading team of developers and analysts• Manage implementation, deployment, monitoring, maintenance, upgrade, and support of data warehouse • Assess data warehousing long-term goals, coordinate with business stakeholders, organization performance and progress with stakeholders• Work on new initiatives and prospects, staffing, including selection, supervision and evaluation of consultants • Major Skills – Project Management, Stakeholder Management, Risk Assessment, RFQ and RFP preparation

Geneva Area, Switzerland

• Coordination of external resources on-site and off-shore for the delivery of the Corporate Data warehouse releases according to the plans and budget ensuring scalability• Assist analysts and stakeholders to define business and systems requirements for new releases to enrich the data warehouse• Assess and cultivate long-term goals for data warehousing in conjunction with data users, business managers, and other key stakeholders through Steering Committee meetings• Develop self-service usage of the data warehouse through communication and change management actions• Manage the implementation, deployment, monitoring, maintenance, upgrade, and support of the Corporate Data warehouse and DataHub• Coordinate operations staffing, including selection, supervision, scheduling, development, and evaluation of consultants across multiple locations• Major Skills – Project and Stakeholder Management, Data Management, Project Planning and Budget Estimation, Risk Assessment and Mitigation, Smartsheets, MDS, MS Teams, SPARX EA

Geneva, Switzerland

• Manage projects and initiatives in Switzerland for a non-profit organization leading team of developers and analysts• Manage implementation, deployment, monitoring, maintenance, upgrade, and support of data warehouse • Assess data warehousing long-term goals, coordinate with business stakeholders, organization performance and progress with stakeholders• Work on new initiatives and prospects, staffing, including selection, supervision and evaluation of consultants • Major Skills – Project Management, Stakeholder Management, Risk Assessment, RFQ and RFP preparation

Santa Clara, California

Involved in Cat, Kitten and Dog Socialization along with assistance during social events.

San Jose, California

Tech Mentor at Willow Glen Branch Library.FLC Computer Tutor and Chess Club Leader at Seven Trees Branch Library.

Kolkata, West Bengal, India

• Led projects internationally from Europe and Philippines as Solution Architect• Performed data analysis activities along with POCs for different clients as Data Architect using EBX, Denodo, etc• Created different data models and some customization to industry standard models to tailor to customer-needs• Major Skills - Application Design, Data Modeling, Solution Design, EBX, Sparx EA, Informatica, Denodo, Jira

Zürich Area, Switzerland

Project Description:Involved in multiple projects and activities as a part of this role. The task of this role was mainly focussed toward the improvement of information sharing across various applications in the Admin and Operations division of the organisation. It was also to evaluate various new tools and share findings on each of them with recommendations if any.• Responsible for the end-to-end Solution Architecture and Information Management work-stream of a major program• Prepared different documentation depicting the roadmap and integration process for different applications within the program• Performed multiple and extensive POCs on Denodo to support Data Virtualization recommendations made• Prepared a Business Information Catalog for the program to have a platform to standardize metric and attribute definition and ownership• Prepared data model for various minor requirements (projects) being developed under the program• Prepared data model and solution design for the Legal and Compliance application• Designed various Tableau reports and visualizations as a part of the delivery for finalizing mock-ups• Tuning and writing SQL and PLSQL codes for supporting the needs of the Information Usage work-stream

Zürich Area, Switzerland

Project Description:Led a team to build the new HR Datawarehouse for Headcount Reporting and to ensure scalability to cater to future business needs. This project also aimed to deliver the first automated DWH system to improve reporting quality and standardise information and data shared across the organisation.Roles & Responsibilities:• Responsible for the end-to-end ETL Architecture of the application• Discussed with SMEs on various incoming data from various source system and their harmonization• Took initiative to analyze source system data analysis and check on data quality• Prepared the data model using Data Vault technique to ensure a scalable and adaptive model to cater to future business enhancements• Performed data validation and proposed business rules changes during the initial data load tests to avoid future manual intervention• Onshore coordination and project management in the initial period of the project

Manila

Project Description:Involved with a team to build a new application for the integration of information from different applications within the existing application landscape. Market-standard data model was customised to cater to the business requirement. Owned the end-to-end Solution architecture and design delivery, along with SME discussion and meetings as a part of requirement gathering. Defined the ETL and BI architecture and reviewing of the high level mapping and reporting documents. Roles & Responsibilities:• Responsible for the end-to-end Solution Architecture of the application• Was heavily involved as a part of requirement gathering and SME discussions to understand business background and details of every application• Performed extensive source system and data analysis along with data quality activities• Responsible for defining the infrastructure architecture to be used for the new application along with capacity planning • Responsible for defining the ETL and BI architecture layers. Also prepared highly detailed mapping documents as a part of the activity based on the finding from source system analysis• Onshore coordination and project management in the initial period of the project

Mumbai Area, India

• Led multiple projects from Europe in the role• Performed requirement gathering and application design for multiple projects• Designed Data Modeling and Application Landscape on interaction of different in-house applications• Designed various near-real-time solutions in ETL using Ab Initio and MSBI along with XML and MQ processing• Major Skills - ETL and BI Architecture Design, Ab Initio, MSBI, SQL Server, DB2, XML, Data Modeling, Kanban

Bangalore Area, India

• Led multiple projects from Europe in the role• Performed requirement gathering and application design for multiple projects• Designed Data Modeling and Application Landscape on interaction of different in-house applications• Designed various near-real-time solutions in ETL using Ab Initio and MSBI along with XML and MQ processing• Major Skills - ETL and BI Architecture Design, Ab Initio, MSBI, SQL Server, DB2, XML, Data Modeling, Kanban

Ipswich, United Kingdom

Project Description:Led transition (hand-over) of Human Capital Benefits Management Information (HCB-MI) application aimed to cover reporting needs for MNC team. Enriching/enhancing the application by adding new reporting areas/dashboards. Led team of MSBI developers, DOT NET developers, QA analysts and Data Analyst from onshore. Designed the enhancements on the existing solution providing additional business value. Assisted in building/extending testing strategy and approach. SPoC for contacting client teams around the globe to initiate data analysis activity to gather additional business information.Roles & Responsibilities:• iGATE Technical Lead for entire implementation and enhancement• Led a team of four developers, four data analyst and one QA lead from onshore• Performed business requirement gathering and converting them to technical requirements for reporting needs• Created in solution and high level design• Led the data analysis activities coordinating with business users around the globe

Gent Area, Belgium

Project Description:Implementing CRM system for Prospect to Loyal Customer Care (PLCC) with real time data exchange capabilities for providing better overview to end customers at dealer locations all over Europe. System designed with extensive error reporting and semi-automated reject handling mechanisms. Interaction with various platforms like mainframe, SAP via different file formats like CSV, XML, TXT, etc. Roles & Responsibilities:• iGATE SPOC for entire implementation and engagement• Led a team of four at onshore• Involved in technical requirement analysis and solution designing• Prepared Hub design and data handling strategies• Prepared Technical and Functional specifications• Data profiling and source system analysis

Gent Area, Belgium

Project Description:Digital Platform was a system built to feed data from various systems to new Pan European Honda website. Data exchange via XML and Web Service. Implementation was done for various product lines and ranges. Data validation and correction was made possible for users prior to publishing in the website.Roles & Responsibilities:• Single point of contact for entire implementation and engagement• Led a development and testing team of five from onshore• Involved in requirement analysis and solution designing and testing• Prepared ETL flow layouts and metadata management process• Prepared High Level and Functional Design specifications• Prepared logical data model

Gent Area, Belgium

Project Description:Master Data Management (MDM) deals with creating master data for Cars business and then sending it to multiple downstream application. The system acts as a single version of master information avoiding multiple maintanence of the same data. The system involves a User Interface application with Ab Initio as ETL processor where multiple validation steps and business rules involving bulk processing are involved. Data sent out is in form of XML through MQ.Responsibilities:• Leading a team of six while at onshore related to Ab Initio• Discussing on the ETL standard processing to be followed. Deciding standards and designing ETL flow and metadata management process• Preparing High Level and Functional Design, including improvements in data modelling based on the business understanding• Created the staging data models and process flow for the project• Preparing Low Level Design and Unit Test Case template for the project• Instrumental in review activities and creating reusable code pieces in the project• Designed and developed complex business implementation using XML and MQ

Gent Area, Belgium

Project Description:This project essentially targeted at creating a well-defined architecture to cater to business needs. As a part of this project, we are implementing Data Marts sequentially based on subject area and corresponding functional area. Scope of the project includes design, development, implementation and creation of data mart.Responsibilities:• Initially provided Proposal for Solution Roadmap definition and implementation• Worked on providing estimation and deciding on the schedule for the project• Leading a team of four from offshore related to Ab Initio• Providing required assistance to the Data Modeler and Architects in the creation of the Logical and Physical Data Model• Creating the High Level Design and System Requirement Specification from ETL perspective• Discussing with architects on the probable data management and data security processes to be followed as the part of the project. Also, documenting the modeling standards to be followed along with the naming conventions to be used• Discussing on the ETL standard processing to be followed. Also, working with the architects on the metadata management process

Gent Area, Belgium

Project Description:This project essentially targeted at reducing usage of Mainframe and COBOL ETL. As a part of this project, we are migrating the existing COBOL ETL process to Ab Initio graphs. Additionally, based on the need, tables are being migrated from DB2 to UDB database. The primary process aims at handling the data for the Warranty System and subsequent processing of the same. The challenge mainly has been in understanding the COBOL programs and documenting them in terms of ETL Low Level designs.Responsibilities: • Worked on providing estimation• Leading a team of six from while at onshore• Reviewing of the High & Low Level designs• Maintaining all the metrics and following all the quality standards and Ab Initio best practices• Providing technical assistance to the team during development from onshore• Reviewing and developing Ab Initio graphs. Creating and implementing generic solutions through Ab Initio graphs• Working alongside consultants from Ab Initio and client ETL architects during the code review phase, providing clarifications and design considerations when asked upon• Discussing possible road-blocks and mitigating issues raised by the client management

Bengaluru Area, India

Project Description: This project essentially targeted at reducing usage of Mainframe and COBOL ETL and also creating a well-defined architecture to cater to business needs. As a part of the PoC, we worked on the ETA (Expected Time of Arrival) subject area. Scope of the project includes design, development, implementation and creation of data mart.Responsibilities:• Leading a team of three from offshore• Taking the bottom line responsibility on the deliverables and meeting the deadlines• Maintaining all the metrics and following all the quality standards and also creating checklists• Providing technical assistance to the team• Developing Ab Initio graphs• Preparing UTC and ITC for the project and conducting the same• High and Low Level Design documentation along with Conceptual and Logical Data Model

Mysuru Area, India

Project Description:This project needed an integrated data mart to be built for financial reporting purpose. Currently reporting was done by fetching data from different source systems. Project needed to pull data from 17 different sources, reconcile data and load data to a new data mart. This involves various data quality check, validations and reconciliation of financial data. Scope of the project includes design, development, implementation and maintenance of data mart.Responsibilities:• Leading a team of four from offshore• Taking the bottom line responsibility on the deliverables and meeting the deadlines• Maintaining all the metrics and following all the quality standards• Providing technical assistance to the team• Review of the development• Coding (Ab Initio, UNIX shell)• Requirement gathering and Design documentation• Analyze, design, implement and maintain high volume data warehouse ETL applications

Mysuru Area, India

Project Description: An Ab Initio based application was developed by migrating the SSIS packages. This application is one of the key applications for a leading banking client in US. This Ab Initio application involves Extraction, Transformation and Loading. After loading, there are several reports created in form of CSV files which helps the higher management of the client to take decisions on various products offered to the customers.Responsibilities:• Coding Ab Initio graphs, UNIX shell scripts and performing reviews• Requirement gathering and Design documentation• Dependency analysis while migration• Improved predictability and business competitiveness in clients business

Mysuru Area, India

Project Description:Incoming data is uploaded into EDM based on the various business rules and underlying transformations. The data pushed into the database is extremely critical as a lot of downstreamapplications are dependent on it. Also, data was required to be populated in a downstream database after another set of transformations. Also, another set of downstream applications were dependent on the data from this database.Responsibilities:• Coding Ab Initio graphs, UNIX shell scripts and performing reviews• Requirement gathering and Design documentation• Dependency analysis while migration• Providing technical assistance to the team• Review of the development

Mysuru Area, India

• Assisted in requirement gathering for different projects• Developed multiple Ab Initio graphs and reusable mappings• Created high level and low level design documents• Major skills - ETL, Ab Initio, PLSQL, SQL, OWB and Oracle DB

Bhubaneshwar Area, India

Project Description: To install, configure and implement Investran to capture Limited Partnership accounting information and to automate Limited Partnership Data from the existing spreadsheet System of Record (SOR) and provide accurate reporting data.Responsibilities: • Developing UNIX shell scripts and PL SQL packages for daily load processing• Development, Requirement gathering, designing, data modeling• Taking the bottom line responsibility on the deliverables and meeting the deadlines• Maintaining all the metrics and following all the quality standards• Providing technical assistance to the team• Review of the development• Leading the development team of 2 members

Bhubaneshwar Area, India

Project Description: Gather requirements for the release of a new insurance product. Design mock-ups a part of the output team to finalize on the layouts of the individual pages of the product taking into consideration, the plans and riders available in the different states in US.Responsibilities:• Design mock-ups comparing with other available project• Requirement gathering and Solution design analysis• Came up with a different requirement gathering template for the client• Awarded and appreciated for performance in the project from client and Infosys end

Professional Degree In Data Science, Data Science, 97.8%

Activities and Societies: - Fundamental R programming skills - Statistical concepts such as probability, inference, and modeling and how.

Bachelor Of Technology, Applied Electronics And Instrumentation, 7.46

Activities and Societies: Quiz, Athletics, Event Hosting, Event Management Studied Electronics and Instrumentation Engineering.

High School Graduation (Isc And Icse), Science, 83%

Activities and Societies: Quiz, Debate, Singing, Dancing, Drama, Elocution, Athlectics, Event Hosting Studied Secondary and Higher.