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

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.

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

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.
• 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

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.
• 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

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.
• 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

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.
• 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..
• 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

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.
• 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

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.
• 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

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.
• 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

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.
• 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

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.
• 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

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.
• 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

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.
• 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.
• 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.
• 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

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.
• 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 with.

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

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