Ayyappa Kumar Email & Phone Number

United States

Involved in Agile - Scrum methodologies to do requirements gathering, analysis and sprint planning.Involved in gathering requirements from Business, Responsible to collect daily status report from team members and update with clients.Implementation of Data Transformation Data Mapper, Routing, Schema and Data Validation.Good hands-on experience using mule connectors like DB, FTP, FILE, SFTP , Workday, Kafka, JMS,etc. as Developed insurance policy management… Show more Involved in Agile - Scrum methodologies to do requirements gathering, analysis and sprint planning.Involved in gathering requirements from Business, Responsible to collect daily status report from team members and update with clients.Implementation of Data Transformation Data Mapper, Routing, Schema and Data Validation.Good hands-on experience using mule connectors like DB, FTP, FILE, SFTP , Workday, Kafka, JMS,etc. as Developed insurance policy management systems.Implementing secure and reliable web service-based communication channels for insurance applications.Enhanced systems for claims processing, incorporating secure data exchange and compliance with industry standards. a part of integration usage.Used Mule ESB in designing the application as a middleware between the third-party system and the end systemWorked on data movement from different sources to Apache/Confluent Kafka.Gathered the records from Kafka topics and sent to Salesforce CRM.Designed and developed several mediations flows of various use cases using the MuleSoft AnyPoint Studio of Mule ESB.Integrated the AKS cluster deployment process into the CI/CD pipeline, ensuring consistent and automated deployments.Proactively addressed and resolved break-fix support issues, ensuring minimal disruption to operations.Leveraged support skills to troubleshoot and resolve API connectivity issues efficiently.Successfully deployed and maintained multiple AKS clusters supporting critical MuleSoft applications.Selected a cluster in Azure platform discussing with the Devops team. Show less

Chicago, Illinois, United States

Involved in gathering requirements, providing integration solutions based on business requirements. Initiated the adoption of Bitbucket as the version control system for MuleSoft projects.Conducted performance tuning and optimization activities to ensure efficient utilization of Apache Ignite's in-memory computing resources within MuleSoft architectures.Spearheaded the integration of Apache Ignite's in-memory data grid with MuleSoft applications to optimize data processing and… Show more Involved in gathering requirements, providing integration solutions based on business requirements. Initiated the adoption of Bitbucket as the version control system for MuleSoft projects.Conducted performance tuning and optimization activities to ensure efficient utilization of Apache Ignite's in-memory computing resources within MuleSoft architectures.Spearheaded the integration of Apache Ignite's in-memory data grid with MuleSoft applications to optimize data processing and caching functionalities.Loaded the data from Rdbms to Apache ignite using Ignite's data loading utilitiesIdentified, located, and resolved defects in the integration processes.Mapped the required fields and parameters with Salesforce for each operation based on the specific integration requirements.Obtained and processed the necessary credentials from your Workday account to authenticate API requests.Implemented the Salesforce Bulk api for asynchronous update of records.Handled the failed records after the Salesforce bulk api processMonitored the batch jobs in the Salesforce CRMBrought data from Salesforce data from diff sources and updated to different end systemsAggregreated the data from workday and salesforce records to fetch final results Managed MuleSoft administration tasks and CloudHub deployment processes. Show less

Atlanta, Georgia, United States

Participated in API Design, Implementation and Maintenance phases.Designed RESTful API with Design on AnyPoint platform and AnyPoint studio.Implemented flows and applications with AnyPoint studio and leveraged DataWeave to do message mapping.Created reusable components such as error handler, domain projects and library.Used different transformers, exception handling, testing & Security of MuleSoft ESBendpoint through OAuth.Integrated the existing systems with external… Show more Participated in API Design, Implementation and Maintenance phases.Designed RESTful API with Design on AnyPoint platform and AnyPoint studio.Implemented flows and applications with AnyPoint studio and leveraged DataWeave to do message mapping.Created reusable components such as error handler, domain projects and library.Used different transformers, exception handling, testing & Security of MuleSoft ESBendpoint through OAuth.Integrated the existing systems with external third-Party Systems.Created the MULE ESB artifacts, created flows, and configured the MULE configuration files and deployed the application.Used MMC - Mule Management Console to monitor the request and response payload.Created and consumed SOAP and REST services.Created Flows, Sub Flows, Exception strategy and DataWeave transformation in Mule configuration.Used Mule Batch processing to handle the large data and used the batch processing capabilities of DataWeave to transform large payloads.Worked on Mule flow variables, record variables, various connectors like FILE, SFTP, IMAP, HTTP, Oracle database, Salesforce.Used Java Messaging Services (JMS) and RMI for reliable and asynchronous exchange of important information and followed coding guidelines while implementing the application.Used various Atlassian toolsets like bitbucket, JIRA, and confluence.Used Jenkins for CI/CD deployment strategy.Created HTTP inbound & outbound flows Security of Mule endpoint. Show less

Hyderabad, Telangana, India

Implemented automation scripts for SQL database management, reducing the need for manual intervention and improving efficiency.Developed automation queries for SQL inventory and used Terraform to automate cloud resource deployments.Worked on database tuning, query optimization, and high availability setups, ensuring robust database performance and minimal downtime.Automated High Availability and Disaster Recovery (HADR) information, database auto-growth, and maintenance tasks… Show more Implemented automation scripts for SQL database management, reducing the need for manual intervention and improving efficiency.Developed automation queries for SQL inventory and used Terraform to automate cloud resource deployments.Worked on database tuning, query optimization, and high availability setups, ensuring robust database performance and minimal downtime.Automated High Availability and Disaster Recovery (HADR) information, database auto-growth, and maintenance tasks, ensuring seamless operations.Managed both IaaS and PaaS server offerings in the Azure portal, optimizing cloud resource usage.Developed automation queries for SQL inventory management, streamlining database operations.Created new database objects, including tables, procedures, functions, indexes, and views, in both development and production environments using T-SQL.Led a Power BI project to develop various reports, providing daily support and insights to the team.Designed cost vs. utilization metrics, resulting in savings of approximately $50K per month by optimizing resource allocation. Show less

Hyderabad, Telangana, India

and monitoring.Managed database security and high availability, implementing automation solutions to enhance overall database reliability.Designed and executed automation strategies to streamline database maintenance and reduce operational costs.Monitored and optimized SQL scripts, creating upgrade scripts for production databases and providing continuous support.Provided on-call support for both DB2 and SQL servers, ensuring swift resolution of critical issues.Utilized… Show more and monitoring.Managed database security and high availability, implementing automation solutions to enhance overall database reliability.Designed and executed automation strategies to streamline database maintenance and reduce operational costs.Monitored and optimized SQL scripts, creating upgrade scripts for production databases and providing continuous support.Provided on-call support for both DB2 and SQL servers, ensuring swift resolution of critical issues.Utilized Linux and Putty to troubleshoot and resolve DB2 database issues.Conducted comprehensive database tuning and query optimization to improve performance and efficiency.Tuned slow-running queries using tools like Profiler and Statistics IO, focusing on evaluating joins, indexes, updating statistics, and refining code.Deployed SSIS packages using SQL Integration Services Catalog, ensuring efficient data integration and processing.Automated SQL agent maintenance tasks, including data purging, index maintenance, and archival operations.Regularly performed database health checks using DBCC Commands and Dynamic Management Views (DMVs) to ensure optimal performance.Improved database performance by analyzing execution plans and tuning indexes.Configured alerts, notifications, and emails to address system errors, resource shortages, database issues, hardware failures, and security breaches. Show less