Sumit Saha Email and Phone Number
Sumit Saha work email
- Valid
- Valid
Sumit Saha personal email
- Valid
- Valid
Innovative and task driven professional with more than 13 years of experience as Enterprise Cloud Data Architect and Data Engineer specializing in Data Modeling, Data Warehousing, Data Analysis, Data Profiling, Cross Platform Data Integration, ETL, Data Analytics, Data Migration and Database Development.I have extensive knowledge in data design and development on AWS Cloud and MS Azure Cloud data platform as well as on on-premise technologies. I have experience in leading teams of Data Analytics Platform (DAP) and other enterprise initiatives like Enterprise Data Warehouse (EDW).• Extensively worked on OLTP, OLAP, ODS and EDW Implementation Projects.• Extensive experience in both Relational and Dimensional Data Modeling and Data Mart with creating Conceptual, Logical and Physical Design of Database and Normalization, Star/Snowflake schema and DW Architecture.• Experienced in design and development on ETL tools like AWS Glue, Azure Data Factory, ODI.• Experience in owning Business Intelligence, Analytics and various components of Data Warehouse.• AWS Certified Developer Associate with detailed knowledge on various AWS Services like S3, EC2, DynamoDB, Redshift, Glue, RDS, Lambda, Athena and many more.• Experience in SQLDW in Microsoft Azure platform along with other Azure Services like Azure Data Factory, Databricks, Cosmos DB, Stream Analytics, SQL DB etc.• Experience and in-depth knowledge of Big Data/MPP platforms like Teradata, Azure SQLDW, AWS Redshift• Developing and maintaining data pipelines and workflows for marketing data analytics and metrics.• Adequate experience in object-oriented Python coding for ETL Pipeline.• Expertise in writing, debugging and performance tuning Complex SQL in wide range of databases.• Quite proficient in different RDBMS like Oracle, SQL Server, DB2 and MPP System like Teradata.• Experience in Data Analysis, Data transformation, source to target Data mapping, Master and Reference data management, and Data Cleansing.• Exposure in Snowflake and BI Tools like Power BI and Qlik.
-
Sr. Data ArchitectAdobe Nov 2021 - PresentSan Jose, Ca, Us -
Data Architect/Data EngineerCognizant Jul 2018 - Nov 2021Teaneck, New Jersey, Us• Architecture evaluation from a wide range of Cloud services and performing MVP to validate architecture choices• Worked with project management, business teams and departments to assess and refine requirements to design BI solutions for Analytics• AWS Certified Developer Associate with detailed knowledge on various AWS Services like S3, EC2, DynamoDB, Redshift, Glue, RDS, Lambda, Athena and many more.• Experience in SQLDW in Microsoft Azure platform along with other Azure Services like Azure Data Factory, Databricks, Cosmos DB, Stream Analytics, SQL DB etc.• In-depth knowledge of Big Data/MPP platforms like Teradata, Azure SQLDW, AWS Redshift• Creating Data Mart for Product Analytics Dashboard and performance optimization• Object-oriented Python coding for ETL Pipeline.• Building Pipelines for Data Analytics platform/Data Lake• Data ingestion involving various mechanisms such as API call, remote source location and vendor interfaces using multiple data formats.• Define Global transactional common format for various subject areas to build the Data Warehouse Layer (DWL) of the EDW.• Manage a large team of data modelers and ETL developers responsible to develop on top of EDW• Responsible for reviewing deliverables, monitoring progress, setting up best practices, standards and design document templates -
Sr. Data Modeler/Data ArchitectCognizant Dec 2016 - Jun 2018Teaneck, New Jersey, Us• Enterprise Data Modeler on MDM and EDW initiatives.• Design discussions and assured functional specifications are delivered in all phases of SDLC in an Agile Environment.• Create data model to integrate master data from different systems.• Define global transactional architecture for various subject areas.• Conceptual/logical/physical data model level using ERwin.• Data Profiling, Data Cleansing, De-duplicating the data, Data Governance and maintain best practices.• Preparing source to target mapping document for ETL development.• Manage a large team of data modelers and ETL developers responsible to development as per the design.• Responsible for reviewing deliverables, monitoring progress, setting up best practices, standards and design document templates
-
Migration/Etl LeadCognizant Sep 2015 - Dec 2016Teaneck, New Jersey, Us• Responsible for designing and creating databases.• Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of the legacy application.• Design of data pipeline in ODI for Oracle migration.• Worked on Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing• Performed Data Analysis and extensive Data validation by writing several complex SQL queries.• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area. • Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).• Manage a team of ETL developers responsible to develop and deliver the pipelines for migration.
-
Data Modeler/Data AnalystCognizant May 2013 - Sep 2015Teaneck, New Jersey, Us• Requirements gathering, business analysis and project coordination.• Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.• Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment.• Developed Conceptual Model, Logical Model & Physical Model using Erwin based on requirements analysis.• Gathered and documented requirements of a Qlikview application from users and deliver data model.• Generated Data dictionary reports for publishing on the internal site and giving access to different users.• Maintained Reference Data from different source system.• Written SQL queries to extract data from Database for analysis Purposes.• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.• Assisted Reporting developers in building Reports.• Performed Data Validation / Data Reconciliation between disparate source and target systems for various projects.• Extensively worked on flat files & mainframe files.• Involved working on different set of layers of Business Intelligence Infrastructure.
-
Data ModelerCognizant Nov 2011 - Apr 2013Teaneck, New Jersey, Us• Requirements gathering, business analysis and project coordination.• Developed Conceptual Model, Logical Model & Physical Model using Erwin based on requirements analysis.• Performed the Data Analysis, Data Quality, Data Cleansing checks before and after loading the data.• Performed analysis of the respective subject areas.• Generated Data dictionary reports for publishing on the internal site and giving access to different users.• Prepared source to target mapping document for ETL development.• Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).• Generated DDL and wrote DML statements for creating, altering tables and views.• Extensively worked on flat files & mainframe files.
-
Oracle DeveloperCognizant Dec 2008 - Oct 2011Teaneck, New Jersey, Us• Requirement gathering & requirement analysis.• Writing complex SQL queries.• Develop PL/SQL functions, procedures, triggers etc. • Maintain Oracle codebase in the database.• SQL performance tuning• Unit testing & bug fixing.• Performed Enhancement of existing codebases.
Sumit Saha Education Details
-
Jadavpur UniversityComputer Application -
University Of CalcuttaComputer Science
Frequently Asked Questions about Sumit Saha
What company does Sumit Saha work for?
Sumit Saha works for Adobe
What is Sumit Saha's role at the current company?
Sumit Saha's current role is AEP Cloud Data Architect | Sr. Data Modeler.
What is Sumit Saha's email address?
Sumit Saha's email address is su****@****ant.com
What schools did Sumit Saha attend?
Sumit Saha attended Jadavpur University, University Of Calcutta.
Who are Sumit Saha's colleagues?
Sumit Saha's colleagues are Amit Rathaur, Jamela Mae Angeles, Valerie Martina, Ken Klingler, Uriel Rivas, Elmaddin Gudratli, Indra Laksmana.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial