Sql Server Marketing Cloud

Sujatha Perumal

314-***-****/*********@*****.***

https://www.linkedin.com/in/sujatha-perumal/

SUMMARY

Professional with around 5 years of of working experience in Design, Development and support of Software applications using Java, J2EE, Mulesoft Development.

Worked effectively using several connectors like HTTP, Database, File, FTP, Salesforce Marketing Cloud, Kafka, SFTP, VM connectors, Salesforce as part of integration usage.

Experience in building Mule Flows with error Handling strategies, Message Filters, Validators, Data Weave transformations and JMS.

Experience using various Mule components like Scatter Gather, Async scope, Choice Router.

Handled the Exception’s by using On Error Continue, On Error Propagate, Global Error Handler, raise error and Try Block.

Developed RAML based Restful API’s and SOAP web services.

Experience in using PGP keys for encryption and decryption.

Deployed applications to AWS and RTF.

Worked with Rest Web Service development for both Xml and JSON datatypes using Advanced Rest Client, Postman, SoapUI.

Proficient in SQL, PL/SQL programming, MySql, MS SQL Server, Oracle 11g.

Experience with continuous integration and continuous deployment using Jenkins pipelines.

Experience in build tools like Maven, Gradle, log4j for logging.

Hands on experience in developing Microservices, REST API’s, Web applications, GUI development.

Effectively used security standards like Basic, OAuth2.0, OpenID connect.

Very good knowledge with mocking APIs, implementing munit test suites.

Experience in developing Restful webservices, Springboot, MVC methodology.

Extensive working experience with NodeJS, JDBC, JSP, HTML, DHTML, Bootstrap, CSS, Thymeleaf, Javascript, TypeScript, Hibernate, MySql.

Experience in Unit testing and generating Test cases for web applications.

EDUCATION

Master of Technology - Computer Science Engineering with 85% from SRM University, Chennai, India.

TECHNICAL SKILLS

IDE

Intellij, Eclipse, Visual Studio Code

Languages

Java 8, J2EE, C, C++

Frameworks

Spring Boot, Spring MVC, Angular, Jasmine, TDD

Database

Oracle 11g, SQL Server, My SQL

Database Tools

Toad, SQL developer, DB Visualiser

Version Control

Git, BitBucket, Tortoise, SVN

Skills

HTML, XML, Javascript, TypeScript, BootStrap, CSS, React, Angular, JSP, Junit, Maven,

Node.js, Confluence, JIRA, Anypoint Studio, Dataweave

CERTIFICATIONS

Mulesoft Certified Integration Associate

Mulesoft Certified Developer – Level 1(Mule 4)

LaunchCode(LC101), St.Louis, MO

J2EE Certified by Lemuria Technologies

PROFESSIONAL EXPERIENCE

July 2021 – May 2025 Software Developer, Cognizant

Directv is an American multichannel video programming distributor based in EI Segundo, California. Built various APIs to create, modify, update appointment, check available time slot for technician.

Responsibilities:

Collaborate closely with product managers, engineers, and customer success teams to ensure integrations align with product requirements and enhance client experiences.

Involved in PI plannings with client.

Develop and maintain comprehensive API documentation for internal and external developers.

Conduct code walkthroughs to ensure the quality of programs developed by team.

Participate in the team’s on call support rotation.

Implemented Open ID connect, register application to forgerock and used those access token to call Mule APIs.

Used DCP UI, to deploy application.

Applied various policies in api manager like OpenId connect, Client Id Enforcement etc.

Implement and enforce authentication, authorization and security protocols to protect data.

Proactively monitor integration performance within our product, identify and implement enhancements to optimize efficiency, reliability, and the overall customer experience

Remote testing performed using postman.

Used Splunk for log analysis for any product issues.

Worked with Message queues to publish/consume data.

Involved in Code Review, applying coding standards.

Worked with updating ICD’s to sync with our task worked.

Involved in reviewing existing APIs and suggested enhancements

Environment: Anypoint Studio 7.16, Java, Springboot, Anypoint platform, ADLS, SecureFx, Salesforce, Apache Kafka, Azure Devops, TortoiseGit, MySQL, SAP, AWS, AzureServiceBus, Message Queues

Highlights

Received client appreciations for accomplishing the projects on time.

Zoetis, a pharmaceutical company, as the world’s leading animal health company, Zoetis stand by those raising and caring for animals worldwide from livestock farmers to veterinarians and pet owners. Built applications to create or update product details in Salsify with SKU ID and other product details.

Responsibilities:

Worked on creating apis to connect with SAP, Salesforce and Database

Designed configuration according to different development requirements.

Developed multiple integrations like moving files from SFTP/FTP source to target SFTP/FTP servers.

Worked with reading file data from source folder of SFTP server, decrypting the file and writing the data to destination SFTP servers. Once write is success move it to archive, incase of any error move to error folder

Implemented integrations to retrieve data from SFMC data extension table, injecting data into SFMC

To secure client ID, secrets, SFTP username, password details used Harshicorp vault to protect sensitive data

Implemented integrations to create SNOW tickets based on error types with various priority tickets

Worked with Message queues to publish/consume data.

Developed common-utility-framework to handle all type of errors, for all integrations.

Perform end to end testing, to ensure integration is working exactly as expected hadling error scenarios too.

Environment: Anypoint Studio 7.6.0, Mule ESB 4, Java, Spring Boot, JSP, HTML, CSS, Bootstrap, Javascript, Mockito, Log4j, Apcahe Tomcat, Putty, Splunk, Postman, Git, SQL, Dynatrace, junit, Microsoft sql server management studio, Salesforce, Azure storage explorer, Jenkins, Eclipse

June 2020 – July2021 Software Developer, LaunchCode(Cognizant)

Humana Inc. is an American health insurance company based in Louisville, U.S. They wanted to build applications which flows the user data from salesforce marketing cloud to third party services vise-versa for marketing communication purpose. In 2021, the company ranked 41 on the Fortune 500 list, which made it the highest ranked (by revenues) company based in Kentucky. It has been the third largest health insurance in the nation.

Responsibilities:

Involved in requirement analysis and estimate the changes.

Implemented integrations to retrieve data from SFMC data extension table, injecting data into SFMC

Troubleshoot issues in higher environments using dynatrace and splunk queries to support the consumers of the application.

Developed MuleSoft ESB projects for the services with synchronous and asynchronous mule flows.

Designed Munit test suites to perform code coverage for the Mule applications.

Worked in migrating integrations from On- Premises applications to Runtime Fabric.

Worked On Production Issue and provided solutions.

Hands on experience with access management, by providing access to specific AD groups with certain permissions

Analysed splunk logs to fix the defects.

Environment: Anypoint Studio 7.6.0, Mule ESB 4, DataWeave 2.0, Anypoint platform, ADLS, SecureFx, Salesforce, Apache Kafka, Azure Devops, TortoiseGit, MySQL, SAP, AWS, AzureServiceBus, Message Queues

Contact this candidate