MuleSoft Certified Developer

MuleSoft Certified Platform Architect

Vishal Varshney

Integration Architect

Email id: adlkel@r.postjobfree.com

Mobile No: +1-973-***-****

Experience Summary

15+ years of experience as Integration Architect, Consultant, Developer and Administrator using MuleSoft, Microsoft BizTalk Server and Azure Logic Apps

Expertise in modelling & building RAML based APIs using Any point Platform.

Proven experience in the field of Service Oriented Architecture, API Management and Security Architectures.

Own delivery of service-based architecture for projects and providing end –to-end solutions using detailed designs.

Expertise in MuleSoft Cloud hub and Hybrid deployment model.

Expertise in various Mule Technologies: MuleSoft Anypoint Platform, Mule Anypoint Studio, Mule ESB, DataWeave language, Mule Connectors, Mule Filters, Mule Flow Control, Mule Runtime Engine, MUnit, Monitoring and various others.

Experience in setting up VPC, VPN and Dedicated Load Balancer on cloud hub.

Experience in DEVOPS tool like Octopus, Gitlab and Jenkins

Good knowledge in setting up policies like client secret enforcement, OAUTH, JWT, Spike Control and many others.

Good knowledge on working with various AWS services like EC2, block storage, S3, Route53, VPC, Load Balancer, RDN, SNS, SES, SQS and few others.

Experience with designing systems involving Azure logic apps, Event Grid, Azure Service Bus, Azure Functions, Azure schedulers, Load Balancers and Blobs.

Good knowledge on securing data using SSL/TLS protocol.

Hands on experience in development of C#.Net component and SQL Server artifacts, XSLT, PowerShell, XML, EDI and JSON artifacts.

Experience in various business domains such as Insurance, Education, Oil and Petroleum, Real Estate, ERP.

Proficiency in analyzing and translating business requirements into technical requirements and architecture.

Experience in working with offshore teams with various international Time zones.

Data Warehousing – Involved in Analysis/Design/Development of SSIS projects.

Excellent communication, interpersonal skills, self-motivated, quick learner, and team leader.

Basic understanding of Apigee API management.

7+ Years of experience executing projects, Onshore in USA, and UK

Technical skill

Tool and Technologies

MuleSoft Anypoint Studio, Platform (RAML Design using Design Center, APIManager, Runtime Manager, API Monitoring), Microsoft BizTalk Server, Azure Logic Apps, Event Grids, Azure Service Bus, Schedulers, Blobs, PowerShell Script, Azure Infrastructure and SSIS

Source Safe

VSO, TFS, GIT, GitLab

Languages

C #, VB.Net, PL/SQL, XSLT, Java Script.

QC Tools

Jira, HPQC, VSO

API Testing tool

Postman, SOAPUI

Data Format

XML, JSON, FLAT FILES, EDI, ANSI ASC X12, IDOCS

DevOps

Octopus and Jenkins

Design

Visio, Lucid chart

Databases

SQL server, Oracle, My SQL

Cloud Environment

AWS, Azure

Key Projects

Project 1:

LFG STAFF AUG – EDMA

This Project is to Automate Under writing Process for various Internal (E-Interview) and Partner Marketers (Policy Genius and LTCG). Under this Project UI application from these Marketers will consume multiple MuleSoft API’s (40 +) in order to accomplish automated Underwriting Process. This automation will help Underwriter to evaluate the Insurance details of end users in shortest turnaround time. This will ultimately help them issuing the policy faster and with most accurate information.

LFG has a very complex Landscape having multiple systems which are connected internally and externally over internet to various third-party vendors via a very secure and encrypted integration channel using MuleSoft API’s. This integration is built over Micro services Pattern.

Organization

Mindtree

Client

Lincoln National Corporation

Contribution

Migration of Mule 3 to Mule 4.

Design and solution document for MuleSoft APIs to automate various underwriters Medical interview processes for their marketers like Policy genius, LTCG and E-Interview

Understand and define architecture for any future third party integration for Lincoln New business applications.

Develop Orchestration flows and Complex DataWeave transformations related to these APIs.

Unit testing of MuleSoft API using MUnit.

Deployment automation process using CI/CD concepts.

Data logging and tracking in accordance with various Industry compliance.

Design logging and Exception Framework

Encryption of sensitive data at rest.

Implement security for API’s using OAUTH 2.0, Client secret enforcement and various other governance policies.

Coordination with client business, vendors and technical team

Production support of any existing Integration using multiple third-party reporting, tracking and Visualization tool.

Tools and Technologies

MuleSoft Anypoint Studio, Anypoint Platform, RAML Design, Java Script, Oracle, Gitlab, Jenkin CI/CD Pipelines, SPLUNK, AppDynamics, Visio, Windows

Role and Team size

Integration Architect

5

Project 2:

SGU Integration

This is a data Integration/synchronization Project for University’s internal systems like Salesforce CRM, Banner ERP and PostGrad Oracle databases. This integration will sync Application and Applicant, Alumni information across these systems using MuleSoft API Led connectivity. This project has leveraged Cloudhub, MuleSoft IPAAS offering

Organization

Mindtree

Client

Confidential.

Contribution

Defining and documenting API Landscape for overall project

Designing and developing Batch Integration process, using

1)Reliability pattern

oObject Store v2

oVM queues.

oReconciliation tables.

2)Exception handling, logging and email notification.

3)Salesforce and Database Connectors

Designing API definition and data model using RAML

Governance and API Securities using API Manger

Proposals, estimations and pre-Sales activities

Setting up Cloud infrastructure.

Gap Analysis and determining the functionality of Downstream Oracle Stored Procedures

Tools and Technologies

MuleSoft 4, AnypointStudio: 7.x, Cloud hub AnyPoint Platform, RAML design, Salesforce Connectors Oracle database, Jira

Role and Team size

Integration Architect

7

Project 3:

“PSIC AMS”

Company has it complex integrated environment connecting its various Duck Creek suits namely Policy, Billing, Claim applications, Its Legacy System and third party vendors using Microsoft BizTalk Server and few Azure component on Azure infrastructure. Project is to do application maintenance and support of existing application and maintaining Azure environment. Later got extended for development of new interface/Integrations.

Organization

Mindtree

Client

Insurance company, Anaheim CA

Contribution

Architects Integration solutions using Microsoft BizTalk Server, C#.Net, SQL Server, Azure Schedulers/Blobs/Logic Apps, Azure Infrastructure Management, XSLT, XML, PowerShell scripts and security certificates.

As an SME and architect, I control complete integration needs of customer and help them integrating their applications within organization and with their third-party trading partners. I am responsible for architecting/designing these integrations, creating technical design documents and handling all development and security needs.

Good Understanding in deploying code using BizTalk Deployment Framework and Octopus

Provide maintenance and support (L2, L3) for the current applications in production.

Coordination with business users, trading partners, business analyst and different Pacific Specialty teams for day-to-day business needs to ensure smooth functionality of project- I leads the complete Integration requirements of customer, I am required to interact with all the application owners and business representative to understand business issues and provide explanation and support.

Incident and Problem Management.

Unit testing to ensure quality code is delivered.

Work allocation and coordination with offshore technical team---I also manage an offshore team, I am required to coordinate with them, allocate work, explaining business requirements, help with new developments and bug fixing.

Ensure development code quality (Code review), review test cases and improve application performance—I am responsible for the overall deliverables and hence need to ensure quality and timely delivery by performing necessary steps.

Effectively track and communicate work status and progress to appropriate audience through weekly status reports & monthly status reports.

POC on converting BizTalk Integrations to MuleSoft API

Tools and Technologies

Microsoft BizTalk server, Azure Logic Apps, Azure Schedulers, Azure Blobs, Azure SQL, SQL server, Azure Infrastructure, MuleSoft, PowerShell Script, JSON, XML, XSLT, Flat File, EDI schemas, Octopus(Deployment), TFS/VSO, GitHub.

Role and Team size

Integration Architect

21

Project 4:

“AmTrust Consulting and Redesign”

The objective of this engagement was to understand Integration Architecture/ Interface/ Environments, perform gap analysis, recommend solution to address the existing issues and provide implementation plan.

Second phase was to design/develop BizTalk interface and promote it to Production.

Help in building BizTalk infrastructure.

Organization

Mindtree

Contribution

Review Inventory of all the services and existing issues/challenges

Understanding Current Integration landscape, interfaces and environment.

Document the understanding of current Integration landscape.

Document any gaps in architecture, design, code and environment.

Based on the GAP analysis, provide recommended solution to address the issues and challenges in the current integration.

Technical interaction with Trading Partners in order to understand their System design and data format.

Document & present the recommendations.

Designed a highly de coupled system with loosely coupled artifacts for easy maintainability.

Developed TSD - Technical Specification documents for all projects

Development of BizTalk interface using schemas, XSLT, map, pipeline and Orchestrations.

Used WCF Custom adapter using SQL binding, File, AS2(EDI /Non-EDI Messages) Adapters

Used Business Rule Engine to create Dynamic Rule by calling many .Net functions, removed all hard coding by calling functions to retrieve SSO Configuration data.

Design and developed pipeline component for unzipping file and adding namespaces.

Installing certificates and configuring them for signing, Encrypting/Decryption

Configuring SSO Application configuration tool to store SSO information and later use it for storing configuration data. Design BizTalk interface to lookup for configuration from SSO database

Design BAM Activity and configuring them using Tracking profile editor for configuration of milestone and data.

Created Parties for receiving and sending AS2 data with partners.

Design many SQL procedure and table for retrieving data using concept like change tracking.

Designed and wrote SQL Procedures for saving and updating data.

Worked on designing the architecture for UAT and Production BizTalk servers.

Help infrastructure team to install BizTalk server in load balancing environment.

Worked with DBA team for high availability of Sql server by enabling clustering of SQL Servers.

Instruct and coordinated infrastructure team to configure Master secret server failover clustering

Responsible to design the BizTalk integration platform for Multiple Host & Host instances and configured Adapter handlers in clustered BizTalk Server Production environment

Interacting with DBA for to give permissions to various level of BizTalk team for case/incident support, Host and Host Instances creation

Installing Private and client certificate in MMC

Designed and developed Domain user groups and accounts to use multi-computer environments

Help infrastructure team to use BizTalk monitoring tool to monitor higher BizTalk environment.

Tools and Technologies

BizTalk Server, SQl Server, EDI, XML, C#, VB.Net. SSIS.

Role and Team size

Role: Consulting and Integration Architect.

4

Project 5:

“CIT Upgradation”

CIT provides lending, leasing and treasury management services to small and middle market businesses and the transportation sector

This is upgradation project where all the existing CIT system using .Net, BizTalk Server, SQL Server got upgraded to latest versions.

CIT uses BizTalk server for integrating its business with its trading partner and internal systems. Various projects and environment using BizTalk server 2006 R2 got upgraded to 2013 R2.

In addition to normal upgrade of projects and environment, few new frameworks were developed to ensure better tracking, maintainability and code got changed where ever applicable.

Organization

Mindtree

Contribution

Feasibility analysis of current system to be upgraded

POC to ensure the possibility of upgradation due to big gap in the version of BizTalk to be upgraded.( requirement was to upgrade from BizTalk 2006 r2 to 2013 r2)

Analysis for design improvement related to BizTalk and related artifacts in C# and SQL. Analysis of overall deployment process and create a better deployment plan

Documentation to capture all feasibility study and guide lines for BizTalk upgrade.

Migration of BizTalk applications from Microsoft BizTalk Server 2006R2 to BizTalk server 2013 R2

Developed custom components when out of box BizTalk functionality does not support the requirement.

Act as liaison between CIT and the Offsite technical team. Also, handle client meetings and set priorities and settle application-related issues

Derived technical specifications from business requirement and co-ordinate with offshore/Onsite team.

Provided technical solutions to handle complex business and technical challenges.

Ensure development code quality, review test cases and improve application performance.

Ensure that any critical issues with significant impact to the project are highlighted to the management.

Built application documentation and also worked with the CIT service providers to ensure smooth deployment in various environments.

Effectively track and communicate work status and progress to appropriate audience through Weekly Status Reports & Monthly Status Reports.

Worked on upgradation of around 50 applications.

Designed new mapping and Orchestration for few interface,

Worked on Pop3,SMTP, File, SFTP,WCF-SQL,HTTP, WCF custom adapter with basic http binding

Redesign few Store Procedure

Wrote Pipeline component for receiving Excel file, adding namespace to incoming message.

Redesigned rule using Business Rule engine

Wrote PowerShell script for creation of folder, Gacing dll,Code deployment and generating MSI and binding for any BizTalk environment

Tools and Technologies

BizTalk Server 2006R2,BizTalk 2013 r2, Team Foundation Server, Visual C#, Orchestration Designer, SQL Server 2014, EDI/XML Schemas, Visual Studio .NET 2012 Windows Server 2012, Service Now.

Role and Team size

Role: Integration Architect

Project 6:

“Realogy Property Management”

Realogy is one of the largest real estate franchisors. It has diversified business model that also includes real estate brokerage, relocation and title services for both residential and commercial properties.

Worked as an Integration Architect to design and develop the entire workflow process for property listing module and later did similar design and development for other modules.

Organization

Mindtree

Contribution

Designed and created BizTalk applications / Architecture workflow designs in Visio.

Analyzed and detail out technical requirements.

Developed functional and technical specification document.

Review test cases

Conducted code Review.

Conduct Architect reviews

Ensured overall consistency and integrity of technical requirements.

Worked on 15 development flows using Orchestration, Mapping/XSLT, BRE, custom C#.NET component.

Worked on concept like debatching, Correlations, Sequential Convoys

Used SSO configuration for saving configuration data.

Used WCF custom, WCF-SQL, WCF-BasicHTTP, File, SFTP and AS2 adapter

Worked on configuration of client certificate.

Used BAM for Tracking BizTalk miles stones and data

Automate BizTalk deployment using WMI script.

Worked on SSIS Packages with SSIS 2012, implemented exception handling using Event handlers

Worked on different types of transformations available in SSIS like Lookup, conditional split, aggregator, derived column, script component and others.

Act as a liaison between the business team and the project team

Conducted periodic meeting with the onsite team

Schedule, support and co-ordinate User Acceptance Testing and complete sign-off

Configure test, Sandbox, simulation and production and postproduction environments.

Well versed with of BizTalkMgmtDb and BizTalkMsgBoxDb in clustered environment in order to large batch file processing based on the requirement.

Used BizTalk Administrator Console to monitor the flow of messages in the BizTalk process.

Tools and Technologies

BizTalk Server 2009, BizTalk Server 2010 and 2013r2, c#, SQl 2008, 2014, SSIS

Role and Team size

Role: Integration Architect

25

Project 7: “Shell GSAP”

Royal Dutch Shell plc commonly known as Shell, is an Anglo-Dutch multinational oil and gas company headquartered in the Netherlands and incorporated in the United Kingdom.[2] It is one of the six oil and gas "supermajors" and the fifth-largest company in the world measured by 2015/16 revenues (and the largest based in Europe).[1] Shell was first in the 2013 Fortune Global 500 list of the world's largest companies.

Organization

IBM

Contribution

Understanding the requirements from functional team and business experts across the Globe, suggesting an Integration solution and technology used (e.g., BizTalk Server, SSIS & Control M).

Wrote technical specification for BizTalk, SSIS and Control M

Designing the interface, writes technical specification for BizTalk, SSIS and Control M.

Work assignment to offshore team

Tracking the development of offshore team and clarify the technical and functional queries.

Doing error analysis for the project issues.

Scoping with functional team.

Developing BizTalk interfaces and Custom C# code used in project development.

Adapters used: File, FTP, SFTP, SMTP, HTTP, WCF Custom adapter (with SAP, Oracle and SQL Binding), WCF-Basic HTTP, Pop3, AS2-X12(Order and Invoice) and AS2 with Binary data(Non –EDI)

Debatching of incoming message using Pipeline component and at times using Orchestration

Writing XSLT

Composing and developing business rule using Business Rule Engine (BRE)

Certificate configuration for trading partner.

Developing orchestration using concepts like Singleton/Aggregator Patterns, and Correlation, calling Orchestration.

Configuring Parties for trading Partner.

Writing Custom .net and pipeline component

Developed ETL Packages using SSIS.

Implemented Logging, Error handling by using Event Handler.

Wrote Stored Procedures, cursors and indexes.

Tools and Technologies

BizTalk Server 2006 R2, SAP (for testing), Visual C#, SSIS, Control-M, EDI/XML Schemas, SQL Server, HPQC, VSS.

Role and

Team size

Senior Developer/Team Lead/Onsite Coordinator (London, 2 years) 1500

Project 8

“Patni HRMS”

Patni computer system was India’s first IT service company later acquired by IGATE and now Capgemini.

This Project was integration of Patni internal HRMS system

Organization

Patni Computer systems later IGATE and now Capgemini.

Contribution

Developed numerous schemas related to flat files and XML, Developed custom pipelines, and workflows using orchestrations

Developed Business Rule using business rule engine in an orchestration.

Worked on adapters like MSMQ,HTTP,SQL,FILE,SOAP Adapter

Many third party web services were consume e.g. INS Zoom web service was consumed to utilize their Visa related application with Patni HRMS system

Publishing orchestration as a web service.

Calling dot net component in an orchestration

Creating a custom Pipeline component.

Creating a custom functoid.

Have used correlation in an orchestration.

Production Support:

In Production Support, I was responsible for:

Monitoring various work flows through various tracking mechanism

Responsible for Real time Production support and fixing of the issues

BizTalk Server Upgradation from BizTalk 2004 to 2006:

I was actively involved in various task related to upgradation and migration of BizTalk 2004 to 2006.It involved following tasks:

Server set ups for BizTalk 2006, its upgradation in development and production environment.

Incorporating different load balancing concept (installation of BizTalk in group, testing the flows with NLBS), testing the working of SQl Servers in clusters

Implemented Master secret server failover clustering.

Coordination with Microsoft on Upgradation issue and creating high available environment

Tools and Technologies

BizTalk Server 2004/2006, MSMQ, Http, SQL, File, FTP, SFTP, XML, XSLT, ASP.NET, C#, Visual SourceSafe, SQL Server 2000/2005.

Role and Team size

Role: Sr. Software Engineer

100

Project 9: “RT out sourcing HRMS”

Development of RT outsourcing HRMS system

Contribution

Developed the logic for manager’s request form for interview

HR admin allocating the resource to fulfil the employment request and finally closing the position for which interview is conducted.

Worked on leave management module that takes care of leave adjustment and accrual of leave for employee.

Worked on Timesheet creation and payroll processing logic development. I have done coding and form designing for the same.

Tools and Technologies

ASP.NET, VB.Net, SQL Server, HR2 Engine (Product).

Role and Team size

Role: Developer.

4

Project 10: “CWC space allocation system”

The objective of this project is to develop Central Warehousing Corporation Ltd, space allocation system

Contribution

Development related to space allocation module with in ASP.NET, VB.Net and SQL Server

This module helps allocation of the space with various withholdings in the warehouses of CWC spread across the country. Thus, the portal helped in the effective utilization of the space as per the capacity, providing the user with the exact scenario prevailing

Tools and Technologies

ASP.NET, VB.Net, SQL Server.

Role and Team size

Role: Developer

Team Size: 5

Education

Year of passing

Degree

Major

2005

MCA.

Information Technology

Special achievements

Numerous Master mind and un-stoppable award from Mindtree.

Appreciation from PSIC,Management, CIO and Mindtree Top management

Contact this candidate