Vimalraj Subramanian

Integration Developer

Professional Summary

Have 14+ years of software development experience with strong programming skills including 3+ years of application integration experience using MuleSoft and 6+ years of data integration experience using SSIS and 10+ years of Data Management experience using SQL Server

Strong application integration experience using MuleSoft ESB with Connectors, transformations, Routing, Exception Handling and Messaging using WebSphere and RabbitMQ

Experience in AnyPoint CloudHub platform on designing and implementing RAML based APIs

Good hands-on in designing & implementing Mule Services in Mule 3 & Mule 4 using Anypoint Studio

Experience in DataWeave language to transform data from and to the formats JSON, JAVA, XML & CSV

Good hands-on experience using mule connectors like Salesforce, File, Database, JMS, SFTP and other connectors as a part of integration usage

Experience in Jenkins, Bitbucket and Maven build tools for building and deploying application

Expertise in designing and deployment of ETL packages using SSIS including performance tuning, error handling using event handlers, restart ability and logging

Extensive experience in SQL Server 2008 & 2012, T-SQL skills including stored procedures, views, user defined functions, cursors, triggers, query tuning and statistics

Proficient in designing and deployment of reports using SSRS, experience in building tabular, matrix, chart, parametric and linked reports using report designer

Experience in data migration and performance tuning of Data Warehouses

Proficient in OOPS implementation, windows forms using C# and designing websites using ASP.Net

Experience in all phases of SDLC (analysis, design, development, testing and deployment) and highly competent in gathering user requirements and converting them into software requirement specifications

TECHNICAL SKILLS:

Primary Technologies • MuleSoft ESB, SQL Server Integration Services (SSIS), SQL Server 2014

Version Control Systems • Bitbucket, TFS, GitLab, JIRA, SourceTree

Other Technologies • C#.Net, Oracle, SQL Server Reporting Services, SQL Server Analysis

Services (SSAS), Tableau, Allegro, ASP.Net, Java, Microsoft Dexterity

Automation/Build Tools • Maven, Jenkins

Testing Tools • SOAP UI, Postman, ARC, Test-Driven Development using Munit

Key Industries • Healthcare, Life-Sciences & Energy

Professional Training • Anypoint Platform Development Advanced (Mule 3), Bootcamp

on Big Data Analytics, Mobile Application using Xamarin Forms

EDUCATION & CERTIFICATIONS:

Bachelor of Technology, Anna University, 2005

Mulesoft Certified Developer (Mule 4)

MCTS in SQL Server Intelligence Development and Maintenance, MCTS in .Net Framework

PROFESSIONAL EXPERIENCE:

Employer : Amba Systems Duration : March 2019 – Present

Employer : Accenture Duration : June 2010 – Feb 2019

Employer : CareVoyant Technologies Duration : June 2005 – May 2010

CLIENT: Confidential Mar 2019 – Present

Role: Mule Integration Developer

Build REST API’s and Enterprise services for electronic enrollment, group services and subscriber portal applications using Mule ESB

Responsibilities:

Developed RAML based API’s and the integration between DB2 database & salesforce application using mule connectors like HTTP, File, Database, Salesforce and transformed data using Data weave

Migrated subscriber portal API’s from Mule 3 to Mule 4, designed and implemented Experience, Process & System API’s as part of client’s new standards and handled logging and exceptions

Used Domain project model for all proxy and services applications and Achieved application security using Secure Property Placeholder

Developed custom java component using Apache POI to create excel document and format data in spreadsheets

Developed application using SFTP connector to retrieve files from SFTP server and upload it into salesforce using content document API

Used salesforce platform events to receive and publish events for enrollment application

Written database queries to retrieve and process data from iSeries AS400 and SOQL queries to retrieve and update data/objects in Salesforce

Configured REST API’s using Anypoint API Manager and publish it in Private/Public exchange

Used Maven for build and deploying the applications and Jenkins for Continuous Integration and Continuous Development and Maintained software through version control with GitLab

Involved in QA, UAT and Production bug fixes and resolution

Environments: Mule 3.9, RAML, Maven, GitLab, Jenkins, Cloud Hub, Salesforce, Java, DB2, JIRA, Postman.

CLIENT: Confidential Mar 2017 – Feb 2019

Role: Mule Integration Developer

Build REST API’s and Enterprise services for esign, claims and fax applications using Mule Anypoint platform

Responsibilities:

Developed RAML based API’s & mule ESB services using enterprise integration patterns and connectors like HTTP, WMQ, File, Database, Data Weave, Transformers for integrating various applications

Integrated API’s, Salesforce application, database’s and various in-house applications

Extensively worked on routing and transformation, Creating API led connectivity and enabling communication between cloud and legacy systems and implemented logging & error handling strategies

Used Poll along with watermarking for triggering data from SFDC and start the application process

Used Domain project model for all proxy and services applications and Achieved application security using https and Secure Property Placeholder

Deployed mule applications in on-premise cluster environment through Any point cloud hub

Used Maven for build and deploying the applications and Jenkins for Continuous Integration and Continuous Development and Maintained software through version control with Bitbucket

Worked on technical specification documents for the services implemented

Implemented Test driven development approach and performed unit testing using Munit for code coverage and tested services using Postman and ARC

Involved in QA, UAT and Production defects and worked widely with mule API & Services administration, Bug fixes & Resolution and implemented change requests

Environments: Mule 3.8, RAML, Munit, WebSphere, Maven, Bitbucket, Jenkins, Cloud Hub, Salesforce, Oracle, Connect Now.

CLIENT: Confidential Nov 2016 – Feb 2017

Role: SSIS Integration Developer

Migrate orders data using SQL Server.

Archive eCommerce application database using SSIS

Administered database servers in Non-Prod environment

Responsibilities:

Design and development of data migration using sql scripts and stored procedures

Developed Data Archival solution for eCommerce application database using SSIS Object model

Performed DBA activities in Non-Prod environments like Deployment, Performance tuning, configured and fixed Cluster(Always-On) & Replication issues

Environments SSIS, SQL Server 2014, TFS.

CLIENT: Confidential Aug 2015 – Nov 2016

Role: ETL Architect

Migrate Zainet application data to Allegro system using SSIS & Allegro Web Services

Responsibilities:

Design and development of data migration using SSIS transformations and SOAP Web services

Developed database project for Allegro objects using SQL Server database tools and proof of concept for continuous integration using octopus deploy for DevOps team

Designed data warehouse solution for Retail Interface

Environments SSIS, SQL Server 2012, Allegro, SQL Server Database tools, Octopus Deploy, TFS

CLIENT: Confidential Jun 2010 – Jun 2015

Role: MSBI Architect

Design and develop data warehouse solution for Tax systems & Insight Intelligence systems (IIS) for analysis and reporting using SQL Server Business Intelligence tools and Tableau

Responsibilities:

Develop SSIS packages to handle year end activities, trigger cubes and collecting Active Directory information for IIS systems

Develop SSAS Cubes, Dimensions, Facts, data source views and deploy and process SSAS objects for IIS Systems

Coordinate with SQL Server migration team to upgrade all BI servers from SQL server 2008 R2 to SQL Server 2012

Develop Dashboard, Tablix reports, Charts, Linked reports, Drill-through and Drill-down reports using SSRS

Create website for executing dashboards to reduce the manual effort as a continuous improvement activity using ASP.Net

Involve in Microsoft Health check session and implemented the recommendations

Design Tax data warehouse that includes designing fact and dimension tables in SQL server 2005 & 2008 R2

Design SSIS packages to extract data from multiple source, perform relevant transformations such as aggregate, lookup, script component, joins and load data into fact and dimension tables using Star and Snowflake schemas and Slowly Changing Dimensions

Create materialized views for reporting purposes and tune SSIS packages / SQL queries for optimal performance

Configure and deploy packages using SSIS configurations, setup logging, error and event handling and package transactions; implement scalability and reusability

Setup Zoetis Data Warehouse for new business

Environments: SQL Server 2012, SSRS, SSAS, ASP.Net, TFS, Tableau, Oracle, Dimensions, HP Service Center

Carevoyant Clinical Product – Form Based Assessment Aug 2009 – May 2010

Role: Sr. .Net Developer

Develop form-based clinical assessment tool using C#

Responsibilities:

Led development team of programmers and ran mentoring sessions

Interact with BA’s, understand the requirements and translate the business requirements to data mapping specs

Involved in design documents, estimations for low level design, build, test and deployment

Implemented windows forms using 3-tier architecture, OOPS concepts and interfaces

Designed tree-based forms using XML DOM features

Used ADO.Net features extensively to interact with SQL Server databases

Designed reports for print functionalities available in windows forms

Assigned work, tracked efforts and assisted resources to translate the requirement to code

Performed code reviews and document review findings and guide developers to fix it

Performed unit testing, integration testing and prepared implementation plan

Environments: C#.Net, XML, SQL Server 2005, Microsoft Dexterity, Crystal Reports, TFS

Carevoyant Clinical Product – System Utilities Oct 2008 – Jun 2009

Role: Sr. .Net Developer

Develop system utilities and resource explorer to upgrade the database objects using C# and ASP.Net

Responsibilities:

Designed and Developed windows forms using singleton pattern

Developed web pages and implemented master pages’ concepts and CSS for styling the Web pages

Used .Net Validation Controls for server-side validations and JavaScript for client-side validations.

Involved in writing data access layers with C# and ADO.Net and used Grid Views extensively

Prepared unit test cases performed unit testing and fixed application issues reported by QA

Environments: C#, ASP.Net, SQL Server 2005, Microsoft Dexterity, Crystal Reports, TFS

Carevoyant Clinical Product – Physician Portal Mar 2008 – Sep 2008

Role: .Net Developer

Develop portal application for providers using C# and ASP.Net

Responsibilities:

Developed web pages and implemented master pages concepts and CSS for styling the Web pages

Used .Net Validation Controls for server-side validations and JSP for client-side validations.

Involved in writing data access layers with C# and ADO.Net and used Grid Views extensively

Prepared unit test cases, performed unit testing and fixed application issues reported by QA

Environments: C#.Net, ASP.Net, SQL Server 2005, SQL Server Reporting Services, TFS

Carevoyant Clinical Product – Employee Management Jun 2007 – Feb 2008

Role: .Net Developer

Develop a web-based application for employee management using ASP.Net

Responsibilities:

Used ADO.Net Database Connectivity for storage and retrieval of data from database and generics functions and Infragistics Grid controls for data operations

Created Stored Procedures, Views, user defined functions and Complex T-SQL queries in SQL Server

Prepared unit test cases and perform unit and integration testing

Strict adherence to peer review checklist during development

Environments: ASP.Net, Infragistics, SQL Server 2005, Microsoft Dexterity

Carevoyant Clinical Product – Menu Security Jun 2006 – May 2007

Role: .Net Developer

Develop add-in to populate menu items dynamically using C#

Responsibilities:

Designed and developed windows forms and custom controls and plugged in into dexterity forms

Created tables and indexes and written stored procedures, functions and views.

Used dataset, data view, and data adapter to manipulate and display data.

Developed reports like tabular, sub reports based on user customization

Deliver code as per quality and coding standards and perform testing as per quality standards.

Gave presentations to user groups on usage and technical project functionalities

Environments: C#.Net, SQL Server 2005, Microsoft Dexterity

Carevoyant Clinical Product – OASIS Analyzer Sep 2005 – May 2006

Role: .Net Developer

Develop web-based form to analyze OASIS clinical elements using ASP.Net

Responsibilities:

Designed & developed web user interface and used server controls such as data grid & validation controls

Used java script for client-side validations and cascading style sheets in web pages

Coding according to the logic and guidelines prescribed for the module

Delivered code and performed testing as per quality and coding standards

Environments: ASP.Net, SQL Server 2005, Microsoft Dexterity

Contact Information

Name : Vimalraj Subramanian

City : Dallas, Texas

Email : adda1k@r.postjobfree.com

Phone : 405-***-****

LinkedIn: https://www.linkedin.com/in/vimalrajs/

Contact this candidate