Sumit Saha Email & Phone Number

San Jose, Ca, Us

Teaneck, 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

Teaneck, 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

Teaneck, 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.

Teaneck, 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.

Teaneck, 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.

Teaneck, 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.

Master Of Computer Applications (Mca), Computer Application

Bachelor Of Science (B.Sc.), Computer Science