PROFESSIONAL SUMMARY:

• Over 10 years of software development experience with strong object - oriented analysis, designing and programming skills including 2 years of experience in Enterprise Service Bus (ESB) projects using MuleSoft and 6 years of data integration using SSIS
• Strong Mule ESB experience with implementing Service-Oriented Architecture (SOA) and Enterprise Application Integration (EAI) using Mule Server 3.x
• Strong application integration experience using MuleSoft ESB with Connectors, transformations, Routing, Exception Handling and Messaging using WebSphere
• Extensively worked on AnyPoint Studio on designing and implementing Mule Services
• Experience in DataWeave language to transform data from and to the formats XML, JSON, JAVA & CSV
• Experience in MuleSoft AnyPoint API platform on designing and implementing RAML based APIs
• Participated in deployment of Mule ESB applications in On-Premise cluster server using CloudHub
• Experience in Jenkins, Bitbucket and Maven build tools for building and deploying application
• Involved in unit testing and writing the Munit Test cases for the mule flows and Exception handling
• Good hands on experience using mule connectors like Salesforce, File, Database, JMS, SMTP and other connectors as a part of integration usage
• 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
• 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

Version Control Systems: Bitbucket, TFS, Git, SourceTree

Other Technologies: C#.Net, Oracle, SQL Server Reporting Services, SQL Server Analysis Services (SSAS), Tableau, Allegro, ASP.Net, 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, Tableau Advanced Training

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Mule Integration Developer

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
• 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, oauth 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

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

Confidential, Dallas, Texas

ETL Developer

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
• Deployments and Unit testing

Environment: SSIS, SQL Server 2012, TFS.

Confidential, Dallas, Texas

Lead ETL Developer

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

Environment: SSIS, SQL Server 2012, Allegro, SQL Server Database tools, Octopus Deploy, TFS

Confidential, Peapack, New Jersey

BI Architect

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

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

Confidential

Sr. .Net Developer

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

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

Confidential

Sr. .Net Developer

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

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

Confidential

.Net Developer

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

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

Confidential

.Net Developer

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

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

Confidential

.Net Developer

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

Environment: s: C#.Net, SQL Server 2005, Microsoft Dexterity

Confidential

.Net Developer

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

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