Melvin Bernard

Extensive hands-on experience in providing end-to-end implementation of Cloud data solutions using IDMC in Azure. 17 years IT experience in Design, Development, Migration, Maintenance, Enhancements and Production Support of Application-to-Application Integration projects for IPaaS Architecture Implementation Hands on experience in Informatica IDMC-Data Integration, Application integration, Cloud Integration hub, Mass Ingestion, B2B , Databricks MLflow REST APIs and Snowflake.

Experience in implementing projects using Agile Scrum/Waterfall methodology. IT Experience in various industries like Investment Banking and financial services, Healthcare.

Experience in developing Enterprise Cloud solutions using IPaaS and IaC applications in Azure using IDMC, Azure Storage , AKS , Azure Key Vault , CosmosDB , Snowflake-Snowpipe , and Data sharing.

Experience implementing Azure DevOps and CI/CD using AzureRepo YAML , Terraform and Git Experience implementing Salesforce Application Data with Snowflake Warehouse using IDMC Integration and Azure Services. Knowledge on Erwin Data modeler, POSTMAN, SOAP UI. Knowledge in API, SOAP,REST,XML,JSON,WSDL and SWAGGER, EDI, X12 Knowledge and experience in data warehouse development life cycle, Snowflake Dynamic tables, fact and dimension table modeling of data, Incremental loads/Change Data Capture (CDC) and slowly changing dimensions across projects.

Experience working with different functional teams such as vendor support team, business users, support teams, and offshore team. Excellent communication & interpersonal skills with strong analytical, team building, problem solving and organizational abilities.

Cloud Solutions Consultant - Office of Technology and Innovation (OTI), City of New York

(2021-08)

• Design, develop, implement, and provide architectural oversight of technical solutions for Enterprise Cloud (Azure GOV and Commercial Cloud) Applications.
• implement Pub/Sub architecture using Azure Service Bus, Event Hub and Grids, Azure Resource Management , AKS , Azure Key Vault, CosmosDB , YAML and Terraform based CI/CD , IDMS Cloud Application Integration and IDMC Data Integration , Snowpipe , Snowflake Data sharing.
• Integrated different Applications and implemented automated business processes by developing various IDMC assets in CAI , CDI ,Mass Ingestion, B2B and Administrator etc.
• Developed Realtime Synchronization from SAP SuccessFactor ,OneStream, Workforce, Microsoft Dynamics etc to load and synchronize on-prem DB and Cloud ERP for MDA Space.
• Developed Realtime Application Integrations processes and Service connectors in IDMC to Integrate Apache Kafka (read, write and to move messages between various Kafka topics) and integrate with Fluent Ecommerce APIs for real-time Orders management.
• Implemented Integrations with several Ultipro (UKG Pro) SOAP/REST APIs and UKG Dimensions REST APIs by setting up Service Connectors to pull whole payload or required data from UKG Pro, UKG Dimensions.
• Implemented Integrations with OneStream APIs by setting up Service Connectors to pull whole payload or required data from OneStream.
• Implemented Integrations with Workforce and Microsoft Dynamics CRM (Power platform) APIs by setting up Service Connectors to pull whole payload or required data from Workforce and Microsoft Dynamics.
• Experience setting up IBM MQ in IDMC Secure Agent, creating required bindings, enabling Messaging services for IDMC Application Integration, and setting up queues and Listeners.
• Very well experience in Implementing Enterprise Service Bus architecture using the components and assets developed using IDMC CDI / IDMC CAI Combination.
• Experience setting up service connectors and process objects using WSDL files for SOAP APIs and SWAGGER files for REST API Integrations.
• Implemented App connectors in IDMC CAI to connect to Databases and setting up File monitoring, File Writing (XML,JSON,text,CSV), Delimited content writing tasks in FTP/SFTP locations.
• Experience using various X-queries, functions and Utilities for file format conversion like XML to JSON and vice-versa, data encoding/decoding and for data analyzing , cleansing and transformation in IDMC CAI.
• Developed IDMC CAI processes and Service Connectors to Azure Log Analytics Data collector API to log Security Incidents to perform real-time Security Incident Event Management.
• Developed IDMC CAI processes using SOAP / REST API service connectors to integrate various different on-prem, Cloud based applications.
• Developed various Process and sub-processes in IDMC Application Integration using various steps like Assignment, Service , Create, Throw, Jump etc.
• Created mappings, mapping tasks, Synchronization tasks, Hierarchical Schemas, Lookups, taskflow in IDMC Data Integration.
• Worked with Hierarchy parser, Hierarchy Builder and Webservice transformations in IDMC Cloud Data Integration.
• Developed Rule logics and Verifications in IDMC Data quality module which can be used in various CDI mappings.
• Created IDMC CAI processes that use service connectors for Informatica REST API and developed Terraform and YAML scripts which will invoke the Informatica REST based IDMC CAI processes to perform CI/CD.
• Created BPEL process using custom Java programs/Java scripts in Informatica process developer and integrated them in IDMC CAI.
• Hands on experience in setting up Microsoft Azure Document DB, Azure Cosmos DB SQL API, Azure Data Lake Gen2, Microsoft Azure Blog Storage V3, Cloud Integration Hub, Databricks Delta, WSConsumer , Webservice ,REST V2, FTP,SFTP , ADVANCE SFTP V2 , Salesforce OAuth , ODATA , Snowflake Oauth2.0 and Keypair connections in IDMC.
• Created Business services that will use REST V2 Connection created from SWAGGER JSON files that can be used in the Webservice transformation in CDI to make Realtime calls to IDMC CAI process.
• Hands on experience on IDMC B2B Gateway, B2B partner, Inbound processing and Outbound processing mappings , B2B REST APIs 940 , 944 , 945 EDI X12 and 997 Ack.
• Experience exposing Data integration taskflows as API and invoking these APIs.
• Published Process and Expose APIs.
• Created managed APIs , Configured Oauth and JWT Authentication policies for the managed APIs using IDMC APIM to Manage and monitor API usage.
• Creation of Security and notification Integration in snowflake
• Configure SSO authentication with Azure AD to Snowflake
• Creation of storage integration and configuring Azure Container for Loading Data
• Creation of file formats and external stage in snowflake
• Generation SAS token to grant Snowflake access to objects in your storage account
• Creation of snowpipe to load data from files automatically as soon as they are available in a stage
• Automating Snowpipe for Microsoft Azure Blob Storage using REST APIs
• Triggering Snowpipe data loads automatically using Microsoft Azure Event Grid messages for Blob storage events.
• Creation of IICS CAI process to invoke Snowpipe REST endpoints to load data and retrieve load history.
• Enabling Snowpipe Error Notification.
• Creation of Azure YAML and Python PIP based CI/CD pipelines to migrate snowflake objects between different snowflake account.
• Snowflake security events data (SIEM) integration via RESTful API through IICS CAI into Azure Gov Log Analytics Workspace for subsequent consumption by Azure Sentinel.
• Conversion of On-prem Powercenter transformations and SQL Overrides to dbt models to push transformations to snowflake

Senior Application Software Engineer (Cloud Integrations Developer) - Centene Corporation - St. Louis, MO, USA

(2017-10 - 2021-08)

(Cognizant Technology Solutions US Corp)

• Worked extensively with business analysts in gathering requirements and translating the business/functional requirements into technical requirements.
• Analyzed business needs and requirements, determined the optimal approach for obtaining data from diverse source system platforms.
• Developed Informatica Cloud Data Integration mapping and taskflows to extract, transform and load data between on-premises DBs, and Snowflake Enterprise cloud warehouse.
• Developed Realtime Data synchronization with Salesforce through Informatica cloud Rest API to load and synchronize on-prem DB with changes in Salesforce.
• Worked with Hierarchy parser transformation to load XML and JSON files into re

Master of Technology - CS - SRM University

Bachelor of Technology - IT - SRM University