Sumit Bera Email & Phone Number

Columbus, In, Us

Columbus, Indiana, Us

Worldwide, Oo

Roles & Responsibilities: Solution Architect – Integration Specialist• Architecture Integration Design for customer Data Hub.• Data Integration to Customer Hub-Data Ingestion using Azure Data Pipeline, Data Factory,Event Hub, data orchestration.• Process Orchestration for MDM related jobs such as Match & Merge through Data Integrationhub.• Business logic design & Implementation using API’s, managing APIs through Azure APIManagement APIM (API Gate way) to Monitor the health of APIs, identifying errors, publishAPIs to external, partner, and internal.• Data Governance & Framework design, identify users, design roles, responsibilities, Rolebased access, design Data Stewardships.• Design data quality, business rules, define business asset such as domain, glossary, catalog,process, data set, organizational data governance principal & policies to maintain the data securities. Assign owners and stakeholders for the defined business assets. • Define & Design Master Data (Customer) Update workflow & Govern the Master data and Publish to Downstream applications.• Define Technical assets, link to business metadata and built the complete Enterprise Data Lineage.• Business Asset Migration from Collibra to Informatica Cloud DG.• Managing Data Governance team members, assign and review their works.• Build predictive data modeling to get prospect customer & Loan defaulter using ML algorithm.• Building Data Pipeline, Hyper parameter Tuning, Model selection & Evaluation using Python.• Extract, clean, transform, validation, feature engineering using different tools such as AL/MLlibraries (SKlearn) and language such as SQL and python.

Teaneck, New Jersey, Us

Solution Architect – Integration Design• Connecting with Business users, leaders for requirement gatherings, fit gap analysis, system analysis and prepare technical requirement document based on that.• Integrate with Azure Active Directory for authentication and request authorizations.• Implement Order and shipment Web application & Mobile application using Micro servicesand Azure API Management APIM following Azure Cloud process orchestration. Protecting APIby adding a rate limit policy (throttling).• Developed and maintained end to end Data Integration using data pipelines with large dataset in Azure Data factory. Implemented Data Mapping, Data Transformation, Data clean up, Data flows, Data Pipeline, Data Orchestration, triggers, events, and control flows. Performed extensive debugging, Data validations, Error handling framework followed by automated deployment through Azure DevOps.Data Ingestion using Azure Data pipeline and Azure Data Factory for master data such as Product, integrate with Informatica.• Product Data Management through Informatica Product 360 and Oracle Product Hub.• Informatica MDM & Oracle MDM: Master Data Collection, Data Quality & Profiling, Data cleansing, Data Transformation & Data Validation, Data deduplication, Data Match, Merge & Update, Golden record creation and maintenance followed by Master Data sync with other consuming applications.• Data Quality: Data profiling, data quality, data transformation using Informatica IDQ, Oracle EDQ.• Data Integration: Integrate and get data from different On-premises and Cloud Data storage/appl.Microsoft Power BI. Build relationship and cardinality between different business entities• Design and develop dashboards using power BI indicating key data outcome.• Design Data Governance framework for the organization, design roles, workflow, rules,standard, Data Quality.

Master'S Degree, Data Science

Engineer’S Degree, Computer Science & Engineering

High School, Science