Pallab Jati - Data Architect, Data Evangelist Central

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

Data Evangelist CentralData Architect

Mar. 2020Langley, British Columbia, CanadaWorking as Data Architect in Agile Environment on the following aspects: • Cloud Migration of existing data Warehouse • Use of Azure Event Hub for Data Ingestion to Data Lake • Consuming Data from Data Lake using Azure Data Factory and ingest the data in Synapses. • Architecting End to end solution for Cloud based Analytics. • Architecture and Standards of Data Lake and Ingestion framework for the same. • Creating Data Pipelines using DataBricks Notebook (using Python) and Azure Data Factory. • Estimating Azure Data Technology spend for future architecture. • Creating Data Models for Enterprise Data Warehouse using Kimble Methodology and physicalizing them on Synapse. • Creating semantic layer in AAS. • Establishing Data Governance Framework by checking Integrity and Completeness of Ingested Data. • Data Analysis and profiling of problem areas and highlight the same to business stakeholders to establish a resolution for the same.

CR Technologies IncSystem Analyst

Jan. 2016 - Apr. 2017Orlando, Florida AreaWorking as Data Architect on the following aspects: • Data modelling for Source and Target Systems. • To ensure Data and Software quality using advanced tools and processes for deployment and development. • Write and Review Data Initialization Scripts • Data Cleansing and De-duping activities. • Data Profiling. • Data Extraction using ETL Tools like SSIS. • To develop new Data Models by analyzing new requirements, Use cases and Business Domain Models. • Reverse Engineering the existing application to map Source and Target Data. • To finalize deployment strategies. • Analysis of Execution Plans and fine tuning Stored Procedures for performance Improvements. • Maintaining Logical and Physical Model of existing applications using ERWIN. • To build Customer MDM model and maintenance of the same. Customer MDM implementation is based on Talend MDM. • Establishing Data Governance by moving right data sets to MDM, creating data matching and profiling jobs within and across various systems of HGV. • Participate in weekly calls with Data Stewards to help in resolution of data problems on weekly basis.

Traction on DemandData Architect

Jul. 2019 - Mar. 2020Vancouver, British Columbia, CanadaWorking as Data Architect on the following aspects: • Data modelling for New Migration needs. • Migration Strategy and mapping from Old to new platform. • Establishing a Semantic Layer for easy data consumption in reporting layer. • Data Extraction Strategies from Source system. • Data Transformation as per mapping. • Data Load to Destination Org of Salesforce using API Layer. • Driving project for technology prospective from initiation to closure. • Helping Data Developers to resolve day-to-day programming issues to ensure code quality and standard. • Stakeholder management for project. • Checking Data Quality and establishing Data Governance by implementing right picklist values in various field of CRM. • Data Analysis and profiling of problem areas and highlight the same to business stakeholders to establish a resolution for the same.

Hilton Grand VacationsData Architect

Sep. 2017 - Jul. 2019Orlando, Florida AreaPeriod: June 2018 – Till Date Project: Enterprise Data Strategy Working as Data Architect on the following aspects: Governance Strategy for Data Lake. Propose Migration Strategy from On-Prem databases to cloud based Elastic Warehouses. POC to establish effectivity of Snowflake in the organization. Integration Strategy through various options like SSIS, Azure Data Factory and Talend. Establishing Solution Architecture for Data Lake, it’s ingestion and enrichment mechanics and implementing initial use cases to establish integration patterns. Creating Data Model, mapping and Integration Recommendations to support Marketing Campaign Management using Complex Event processing through various layers of data Acquisition, ingestion and processing. Working on POC’s for Sentiment Analysis using R Studio Period: Sep 2018 – Till Date Project: Premiums and Gifting – OLTP Platform Modernization Working as Data Architect on the following aspects: Data modelling for New OLTP application. Migration Strategy and mapping from Old to new model (On-Prem databases to cloud-based Storage). Real -time data Integration Strategy to ODS and Data Lake/Data Warehouses using WSO2. Establishing a Semantic Layer for easy data consumption in reporting layer. Data Modelling for New Marts in Data Warehouse. Standing up New Solution Architecture for Data Platforms. Evaluation of Red Gate Masking Capabilities for Non-Production Environment. Period: Oct 2017 – Jun 2018 Project: HGVC Oracle Cloud Migration Worked as Data Architect on the following aspects: Data modelling for Middleware Systems. Propose Migration Strategy from Peoplesoft Data to Oracle Cloud. Propose Integration Strategy for various internal systems and external Vendor systems to Oracle Cloud which includes transformation of Human Capital, General Ledger and Accounts Payable Data through various interfaces. Hands on experience with HDL and FBDI template and integration using ETL.

Ana-Data ConsultingHadoop Architect

May. 2017 - Sep. 2017Orlando, Florida AreaWorking as Data Architect on the following aspects: • Data modelling for Source and Target Systems. • To ensure Data and Software quality using advanced tools and processes for deployment and development. • Write and Review Data Initialization Scripts • Data Cleansing and De-duping activities. • Data Profiling. • Data Extraction using ETL Tools like SSIS. • To develop new Data Models by analyzing new requirements, Use cases and Business Domain Models. • Reverse Engineering the existing application to map Source and Target Data. • To finalize deployment strategies. • Analysis of Execution Plans and fine tuning Stored Procedures for performance Improvements. • Maintaining Logical and Physical Model of existing applications using ERWIN. • To build Customer MDM model and maintenance of the same. Customer MDM implementation is based on Talend MDM. • Establishing Data Governance by moving right data sets to MDM, creating data matching and profiling jobs within and across various systems of HGV. • Participate in weekly calls with Data Stewards to help in resolution of data problems on weekly basis.

UnitedHealth GroupAssociate Architect

Feb. 2014 - Jan. 2016Gurgaon, IndiaWorking as EDW Data Architect on the following aspects: • Data modelling for EDW. • Study Industry specific data model from Oracle and Teradata and recommend implementation accordingly. • Write and Review Data Initialization Scripts • Data Cleansing and De-duping activities. • Data Profiling. • Data Extraction using ETL. • To develop new Data Models by analyzing new requirements, Use cases and Business Domain Models. • To finalize deployment strategies. • Analysis of Execution Plans and fine tuning Stored Procedures for performance Improvements. • Setting up new acquisition channel from different sources. • Building transformation rules for common format layers. • Evaluating different options in Big Data Area under Hadoop platform. • Building prototypes for future projects Complex Event Processing (CEP) using STORM and KAFKA to process Real time streaming data. All these implementations were done in Java. • Big Data Implementations using HDFS, HIVE, MAP REDUCE, FLUME, KAFKA. • Participate in Data Governance calls to establish MDM framework for need of the organization. Provide necessary feedback on data pain points and interface with business to get sign off on critical data monitoring activities.

Tata Consultancy ServicesAssociate Consultant

Sep. 2004 - Feb. 2014Gurgaon, IndiaWorked as a Sr SQL Developer and Data Architect on the following aspects: • Lead a Team of 60 talented professionals. • Data modelling for Source and Target Systems. • Write and Review Data Initialization Scripts • Data Cleansing and De-duping activities. • Data Profiling. • Data Extraction using ETL Tools like SSIS. • To develop new Data Models by analyzing new requirements, Use cases and Business Domain Models. • Reverse Engineering the existing application to map Source and Target Data. • To finalize deployment strategies. • Analysis of Execution Plans and fine tuning Stored Procedures for performance Improvements. Worked as a Project Lead and Data Architect on the following aspects: • Maintenance and Enhancements of Pegasus Data Model using Oracle Data Model. • Study Industry specific data model from Oracle and recommend implementation accordingly. • Onsite-Offshore Co-ordination. • Production support for all environments. • To find the necessary gaps in the applications or application architecture and suggest necessary changes for the same. • Understanding requirements and provide Technical Assessments and Estimations for the same. • Team Management and appraisals for 10 Associates. Worked as a Data Modeller and Java Developer on the following aspects: • Complete database design of CMS application. • Maintenance and Enhancements of APEU database components including stored Procedures and their tuning. This includes import/export of data using bcp. • Onsite-Offshore Co-ordination. • Create build and deployment scripts for CMS application. • To provide 24 X 7 production support for all environments. • To find the necessary gaps in the applications or application architecture and suggest necessary changes for the same. • Work on ORM and use hibernate to write HQLs for project. For further details on experience, Please refer my Resume.

Intch is a Professional Networking App for the Future of Work

100k+ people

130+ countries

AI matching

Get Intch if you'd like to

📝

Get Recommended to New Customers

👋

Connect with Like-Minded People

💸

Raise Capital

🚀