Siddhartha Datta
Stockholm
Summary
A seasoned transformation Leader with Enterprise data architect experience in the domain of Data Engineering and Analytics with extensive technical, consulting & delivery experience in Data
modernization programs & future analytics Roadmaps.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Enterprise Data Architect
LTIMindtree Limited
11.2022 - Current
- Provide Enterprise Architecture for analytics solutions based on the business goals and appropriate data visualization to support the goals.
- Defining and executing data strategy for clients, focused on high-quality strategy, definition, and delivery of data solutions.
- Integrating data with marketing scenarios like segmentation, targeting, consumer 360 view, etc.
- Provide inputs to define and execute strategic roadmap for enterprise data architecture by identifying the current landscape and future business goals.
- Full-fledged contribution towards data platform capabilities to overcome new data problems and challenges leveraging cloud platforms.
- Provide technical assessment and recommendations to transform & modernize existing data & analytics platform thus minimizing technical debt.
- Demonstrated knowledge and hands-on experience with AWS solutions including S3, Kinesis, Lambda, EMR, DynamoDB, Redshift, Spark, RDS and frameworks such as Hortonworks and/or Cloudera.
- Unified disparate data structures and operating environments during revamps of processing facilities, data centers and more.
- Designed internal process improvements to automate repetitive tasks, shortening data delivery times.
PRINCIPAL ASSOCIATE- DIGITAL PLATFORM
MOL INFORMATION TECHNOLOGY PRIVATE LIMITED
02.2020 - 11.2022
- Plan, Design & Build Analytics & Modern Data Platform- Establish Data Product Architecture.
- Implementing data security in Data warehouse spaces like Azure Synapse Analytics, Amazon Redshift, Snowflake- Data Access Control, Encryption, Data Loss Protection, etc.
- Plan, perform and oversee data and database migrations for data platform modernization projects.
- Designed, architected, and developed Analytics solutions for Dashboard and report for various users and departments (Sales, Finance, Customer Support, etc.)
- Build and own automation and monitoring frameworks that capture metrics and operational KPIs for data pipeline quality and performance.
- Provide leadership and management to a team of data engineers, dbas, & data analysts managing processes and their flow of work, vetting their designs, and mentoring them to realize their full potential.
- Architect and help establish standard data practices like governance and address other non-functional issues like data security, privacy, and quality.
- Contribute to designing & managing data models, data dictionaries, and metadata repositories to ensure data consistency, accuracy, and standardization across the organization.
SR. TECHNICAL ARCHITECT- DATA
MINDTREE Limited
12.2016 - 02.2020
- Architect and design ETL from multiple sources into Elastic Search, DynamoDB and Redshift.
- Managed build phase and quality assure code to ensure fulfilling requirements and adhering to ETL, Spark (Scala) integration.
- Design documents and artifacts with reference architecture, best practices, identify and enforce AWS architectural best practices.
- Played a vital role of chief architect responsible for ETL architecture and strategy in Azure Data Services Platform
- Design and maintain the overall architecture for the product(s)/platform(s) in alignment with enterprise on the AWS Platform
- Planning, designing, and architecting – Modern Enterprise Datawarehouse in cloud platform - AWS Redshift & Azure Synapse Analytics.
- Design and implement data security and privacy measures to ensure compliance with relevant regulations and industry standards.
TECHNICAL MANAGER-Data & Cloud
HCL Technologies Limited
11.2011 - 12.2016
- Designed and developed ETL, replication schemes, and query optimization techniques that supported highly-varied (structured, semi-structured, and unstructured) and high-velocity (near real-time) data processing and delivery.
- Ensured the data architecture is optimized for large dataset acquisition, analysis, storage, cleansing, transformation, and reclamation
- Develop standards and methodologies for benchmarking, performance, evaluation, testing, data security and data privacy
- Set goals for unified data management practices such as meta-data management, provenance management, governance, stewardship, data quality and lifecycle management.
- In data modeling and data architect role for enterprise data modeling across multi-subject areas
- Research, analyze, recommend, and select technical approaches for solving difficult and challenging development and integration problems.
- Architects solutions that deep telemetry capabilities to provide ongoing success and performance metrics
- Demonstrated knowledge and hands-on experience with AWS solutions including S3, Kinesis, Lambda, EMR, DynamoDB, Redshift, Spark, RDS and frameworks such as Hortonworks and/or Cloudera.
SENIOR DATABASE ANALYST
Bank Of America
08.2008 - 11.2011
- Created and updated database designs and data models.
- Modified databases to meet needs and goals determined during planning process.
- Conducted tests to identify issues and make necessary modifications.
- Implemented BI solution framework for business intelligence projects.
- Developed, tested & implemented a robust database backup and recovery strategy with client
- assistance.
- Conducted root cause and analysis for database incidents and problems
- Complied with standard security-related procedures that are based on established best practices
- and conformity to company policy and adjusted to accommodate Client
Sr Specialist Systems
HCL Technologies Limited
11.2008 - 08.2009
- Designing, developing, testing and deploying BI solutions, including data warehouses, ETL, reporting, data analytics and data visualizations
- Creating and maintaining documentation, such as data dictionaries, user guides and system diagrams
- Evaluating business requirements, developing solutions and providing technical guidance
- Performing data analysis and developing data models to support business decisions
- Monitoring and tuning database systems to ensure performance and scalability
- Developing and implementing strategies for data acquisition, storage and security
- Identifying opportunities to improve BI systems and processes
- Collaborating with stakeholders to develop and deploy BI solutions
Project Engineer
Wipro Technologies Limited
03.2005 - 10.2008
- Developing and implementing strategies for data acquisition, storage and security
- Identifying opportunities to improve BI systems and processes
- Collaborating with stakeholders to develop and deploy BI solutions
- Analyze and troubleshoot the SQL Server processes and jobs
- Monitoring the Disk Space of all the Servers; Database auditing, monitoring of various database
- activities, working proactively on performance issues.
- Monitor the Log Space for successful execution of all the specified procedures
- Troubleshoot SQL issues and escalating issues as appropriate
- Cluster management, LS troubleshooting, DB Mirroring etc
- Monitoring the Server and query performance closely to ensure database productivity
- Monitor and maintain the SQL jobs running on various boxes
- Monitor the Log shipping between Productions – Reporting as well as Production –UAT boxes
- Work on the Development and Test teams in applying bug and hot fixes in both UAT and production environments
DATABASE ADMINISTRATOR-Developer
Innerinfosys.com -
01.2004 - 01.2005
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Created and implemented database designs and data models.
- Created and updated database designs and data models.
- Tested programs and databases to identify issues and make necessary modifications.
Education
Accountancy
University of Calcutta
Kolkata, West Bengal06.2004
C, C++, JAVA, OOP & RDBMS,
APTECH COMPUTER EDUCATION - Diploma in Software
Kolkata, West Bengal 06.2004
Skills
Programming Languages:
Java, Python, Scala, SQL, PL/SQL, C, PySpark, CLI, Power Shell
Cloud Platforms:
Amazon Web Services, Azure Cloud
Big Data Framework:
Hadoop, HBase, Map Reduce, Cloudera, Presto, Hive, Flink, Spark, Storm, Kafka
Multi-Platform Databases (Relational, Non-Relational & In-Memory):
MS-SQL Server, Oracle, MySQL, PostgreSQL, RDS, Azure Data Services, HBase, Cassandra, MongoDB
Data & Analytics:
Databricks, Azure Synapse, Teradata, Redshift, Snowflake
Data security and encryption
Data product architecture: Centralized and Distributed environments Data Governance Data Protection (EUDPR, GDPR, CCPA, HIPAA, SOX, FISMA)
Master Data Management
Accomplishments
Built end to end modern data platform, establishing Data Product Architecture (centralized & distributed environments).
Architected end to end market sentimental project leveraging Big Data Technology stack.
Modernized Teradata on premise environment to AWS cloud platform.
Realtime Data streaming project leveraging AWS data stack.
Contributed to CDPs as chief architect for designing & organizing customer data sources & create individual centralized profiles.
AWS serverless data analytics pipeline project part of Serverless Full Stack Data Analytics Engineering on AWS Cloud
Certification
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS)
Microsoft Certified Technology Specialists in Microsoft SQL Server 2008 (MCTS)
Microsoft Certified IT Professional 2008
Microsoft Certified Solutions Associate 2012
Microsoft Certified Professional (MCP)
Microsoft Certified Microsoft Azure Solutions Architect Expert
Databricks Partner Training Accreditation- Solutions Architect Essentials
Additional Information
DOB- 1st Aug 1981
Gender- Male
Nationality- Indian
Visa Detail
Work Permit- Sweden
US B1 Visa
Timeline
Enterprise Data Architect
LTIMindtree Limited
11.2022 - Current
PRINCIPAL ASSOCIATE- DIGITAL PLATFORM
MOL INFORMATION TECHNOLOGY PRIVATE LIMITED
02.2020 - 11.2022
SR. TECHNICAL ARCHITECT- DATA
MINDTREE Limited
12.2016 - 02.2020
TECHNICAL MANAGER-Data & Cloud
HCL Technologies Limited
11.2011 - 12.2016
Sr Specialist Systems
HCL Technologies Limited
11.2008 - 08.2009
SENIOR DATABASE ANALYST
Bank Of America
08.2008 - 11.2011
Project Engineer
Wipro Technologies Limited
03.2005 - 10.2008
DATABASE ADMINISTRATOR-Developer
Innerinfosys.com -
01.2004 - 01.2005
Accountancy
University of Calcutta
C, C++, JAVA, OOP & RDBMS,
APTECH COMPUTER EDUCATION - Diploma in Software
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS)
Microsoft Certified Technology Specialists in Microsoft SQL Server 2008 (MCTS)
Microsoft Certified IT Professional 2008
Microsoft Certified Solutions Associate 2012
Microsoft Certified Professional (MCP)
Microsoft Certified Microsoft Azure Solutions Architect Expert
Databricks Partner Training Accreditation- Solutions Architect Essentials
Similar Profiles
Manish Kumar ChauhanManish Kumar Chauhan
Specialist-Software Engineering at LTIMindtree LimitedSpecialist-Software Engineering at LTIMindtree Limited
NAVEEN KUMAR PAVIRALANAVEEN KUMAR PAVIRALA
SAP ABAP Consultant at LTIMINDTREE LIMITEDSAP ABAP Consultant at LTIMINDTREE LIMITED
Chethan Kumar NChethan Kumar N
Senior Software Cloud Engineer at LTIMindtree LimitedSenior Software Cloud Engineer at LTIMindtree Limited