Aveek RoyChowdhury

• Defined their Data Platform Architecture on Azure leveraging PaaS Services like Databricks , Azure Data Factory , Azure Data Lake , Azure SQL , CosmosDB , Azure Cognitive Search , Azure Purview etc.
• Defined their Data Ingestion and Processing Architecture and implemented them using metadata driven generic frameworks.
• Defined the Data Quality and Reconciliation Framework.
• Designed the Consolidated Data Model and Consumption Layer Data Model

Tools & Technologies : Azure Data Lake , Azure Data Factory , Databricks , Cosmos DB , Azure cognitive Search

Senior Solutions Architect (Data and Analytics ) - Banking , Financial Services and Insurance - US East

• Support Technical Sales and Pre-sales related activities like response to RFIs and RFPs , Present CIO and CDO directs on TCS's capabilities and experiences in Data and Analytics
• Support critical and large Data Estate Modernization engagements from Architecture and Design.
• Understand and explore Future Trends in terms of Architecture , Technology and Processes and create POVs on them.
• Create Frameworks, Solutions and Accelerators in Data and Analytics Space

Snowflake Proof Of Technology:

• Compared workload performance between existing Databases and Snowflake under similar kind of Loads.
• Estimated required Snowflake Warehouse size to deliver better query performance than the existing Databases like Teradata , Greenplum , DB2 etc.
• Tested Data Sharing capabilities of Snowflake.
• Tuned Snowflake parameters to reduce queuing of queries
• Tuned existing queries to gain performance in Snowflake and record that learning for future migrations

• Defined the Platform Architecture for ingesting Data from On-Premise Databases to Cloud for Analytical Data Plane ( Data Lake ) and Operational Data Plane (Microservices).
• Defined the Ingestion architecture for Data Lake using Spark on AWS EMR which will be able to handle schema changes in the source and will be able to store history of SCD tables in a easily consumable form.
• Designed a framework to capture Technical Metadata to Glue Catalog and then push it to Collibra.
• Designed the Reconciliation and Data Quality framework.
• Designed a Metadata driven generic data processing Framework

Tools & Technologies : AWS S3 , AWS EMR , AWS Glue Catalog , Collibra , DynamoDB , AWS Lambda , Kinesis , Qlik Replicate (Attunity)

Big Data Architect for GE D&A Platform

• Designed Solutions for multiple use cases for different business functions like Sourcing and Finance.
• Designed solution to leverage Machine Learning techniques for mastering supplier data.
• Designed and optimized solution to ingest data from multitude of databases in near realtime into Hadoop and Greenplum using a log based replication tool HVR.
• Developed a solution to measure platform yield and availability using Grafana , Spring Batch , My SQL.
• Established and secured enterprise-wide data analytics structures.

Tools & Technologies : Hortonworks Hadoop , Greenplum , HVR , Apache Spark , Presto , Denodo , Grafana , Talend

Multiple Engagements :

• Outage & Parts Flow Simulation Engine for GE Power , GE Aviation and GE Oil and Gas. Design and Development of the Core simulation engine was owned by me. Engine was developed in Java.
• A Workflow backed web application to digitize the Condition Based Maintenance for Turbines for GE Power with numerous REST based integration points with other enterprise systems.
• Distributed Data Platform for GE Power using Hadoop , Greenplum , HVR , Talend and Tableau