PROFESSIONAL SUMMARY:

• Senior Software Engineer with 12+ years of full stack hands - on experience in IT services industry and a proven track record in Enterprise, Business & Solutions Architecture, Technology and Business transformation using innovative techniques, Project Management (Microsoft certified .Net Technology specialist).
• Domain Experience - Mortgage Services, Banking Services, Healthcare, Human Resources, Supply chain and Asset tracking.
• Strong hands on experience in developing web applications, web Services, Win Services using ASP.Net, C#, MVC, Entity framework, ADO.NET, LINQ, AJAX, WCF services, web services, Web API, JQuery, JavaScript, CSS, HTML.
• Experience in SSIS packages and SSRS reporting tools.
• Highly proficient in design and development of SQL Server Integration Services (SSIS) packages, importing and exporting of data using various control flow tasks and data flow transformations.
• Extensive experiences in Database Design, developing Stored Procedures, Functions, Views, Triggers, and Complex Queries on SQL Server.
• Expert in T-SQL Programming, query optimization and performance tuning.
• Experience in identifying and fixing production issues, web application security vulnerabilities.
• Hands on experience in
• Troubleshooting and debugging .NET web applications and T-SQL Query optimization.
• Integration with different third-party vendors and APIs.
• Managerial Experience - Software delivery and production support, Program management, Client servicing and Vendor management, billing & estimation models, Process improvement, Operations optimization
• Development methodologies - Agile scrum practices, Waterfall, DevOps. Experience of working in Global Delivery Model meeting CMM quality standards. Experience in working with multiple vendors and geographically distributed teams.
• Behavioral competency - Assertive leader with strong analytical and reasoning skills, committed team player, excellent communicator.
• With good communication skills and client interactions, involved in many business meetings for requirements elicitation, providing valuable inputs in preparing functional documentation.
• Having strong analytical skills, object-oriented programming skills, dealt with many technical challenges, provided efficient solutions and resolved many existing performance issues.
• Good team player with excellent interpersonal communication skills. Highly motivated, quickly adapt to the situations and work in any environment either in a team or independently.

SKILL:

Tools: - Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS)

Languages: C#.Net, VB.Net, SQL, PL/SQL, Visual Basic

Technology: ASP.Net, ADO.Net, Microsoft Azure, MVC, Entity Framework, WCF, WEB API, Javascript/Jquery/Ajax, CSS3, HTML5, XML, JSON, LINQ, Bootstrap, LINQ

Database: SQL server, Informatica, Data modelling, Data Transformation, Data migration and management.

Other Tools: Visual Studio, TFS, ANTS Memory Profiler, Visual Web GUI, Autosys, Active Batch, Infragistics RAD Controls, Crystal Reports, Monarch Data Pump, Service Now, Dyna Trace, Twilio Programmable API.

WORK EXPERIENCE:

Confidential

Technical Lead

Technologies Used: SSIS, SSRS, ASP.NET, MVC, Entity Framework, C#, Twilio Gateway

Responsibilities:

• Requirements analysis, requirements gathering, discussion with various business units to make changes to their applications.
• Coordination with the vendor Twilio right from beginning of the contract, perform POC in the gateway provided.
• Involved in the Complete design of the system
• Responsible for creation of SSIS Package to migrate data from old DB to the new DB per new table structures created for this project.
• Responsible for creation of multiple SSIS package to find loan and phone numbers to send out reminders. Created Schedule process engine to validate customer time zone per TCPA guidelines and to send out notifications to the customers.
• Responsible for creation of read engine using SSIS Package and .NET Windows service to read incoming messages consistency from the vendor using their API. Once the message is read the read engine will process based on customers response and respond/update data accordingly in the system. For example, STOP/START/Any other message responses from borrower.
• Responsible for creation of SSIS package for end of the day reconciliation process to ensure we have processed all the incoming and outgoing messages.
• The package will process the loaded data by updating the consent information or to send out automated SMS response back to the customer.
• Involved in development, unit testing, deployment and production support.
• Played the role of a team lead, managed teams across locations, assign/review work and ensure it was delivered on time.
• Responsible for the overall product delivery.

Confidential

Technologies Used: HTML5, CSS, Microsoft Azure

Responsibilities:

• Coordinating with business stake holders for the requirements
• Responsible for performing POC on Azure platform.
• Responsible for creation of pages for Team, contact us, product pages.
• Responsible for setting up complete Azure environment - App Services, Creation of deployment slots for different environments, setting up default redirect pages, etc.,
• Responsible for implementation in Azure platform for all environments, QA, Staging and Production environment.
• Build and Deployment of the website using Microsoft Azure.
• Was responsible for overall delivery of the product.

Application Development and Support

Confidential

Technologies Used: ASP.NET, C#, ADO.NET Entity Framework, SQL Server 2012, SSIS, SSRS, Monarch Data Pump, Active Batch

Responsibilities:

• Creation of Low level design documents which includes class and sequence diagram using Microsoft Visio
• Development, Unit Testing
• Build and Deployment of the applications using Visual Studio Team Build, Visual Build Pro
• Automation of Functional Testing using Microsoft Test Manager Tool
• Identified web-application security related vulnerabilities using QUALYS Guard tool, WAVE Tool and provided suggestions to fix vulnerabilities.
• Responsible for creation of various SSIS packages during this period and to address failures in production. Worked with various business units in getting the issues fixed and address if there are any changes required to the SSIS package.
• Responsible for creation of SSIS Nightly process which reads files from vendors and to process them. If there are any failures send out notifications to various teams. The package was scheduled in Active batch with retry mechanism.
• Responsible for creation of SSIS Package to identify the loan population and to create a file with various TRAN Layouts to send the files to different vendors. The file will be places in a common folder and will be loaded to the vendor system using SFTP.
• Responsible for creating SSIS Package to migrate data from legacy data base to SQL Server.

Confidential

Technologies Used: ASP.NET, C#, ADO.NET Entity Framework, SQL Server 2005, SSIS, ADA Compliance

Responsibilities:

• Creation of Low level design documents which includes class &sequence diagram using Microsoft Visio
• Development and Unit Testing using ASP.NET, C#, MVC, WCF, SQL Server, SSIS and SSRS
• Build and Deployment of the applications using Visual Studio Team Build
• Performed code configurations using Microsoft Team Foundation Server
• Automation of Functional Testing using Microsoft Test Manager Tool
• Identified web-application security related vulnerabilities using QUALYS Guard tool, WAVE Tool bar
• Implemented ADA Compliance standards for Confidential and also involved in enhancing additional features for the website.
• Responsible for creation of SSIS Package to migrate data from old set of tables to new tables per standards and for optimization.
• Coordinated with multiple vendors from geographically distributed teams for a successful development, testing and deployment of the project
• In parallel played a Lead Developer in coding, leading, mentoring and reviewing the work of the team.

Confidential

Technologies Used: Informatica, UNIX, Autosys, Oracle, Clear Case

Responsibilities:

• Worked in client location, involved directly in interaction with the clients
• Involved in planning and assigning the tasks to the team
• Involved in ETL Design, development and unit testing
• Involved in preparing install plan documents, Operations Document, Release Notes Document
• Respond to the issues assigned, conduct analysis, suggest/implement work-around and close the assigned issues as per the agreed timelines / SLA
• Participated efficiently in Development, Testing Phases, create Program Specifications and unit test plans

Confidential

Technologies Used: ASP.NET MVC, C#, JQuery, SSRS, SQL Server 2008, Infragistics Rad Controls, Clear Case

Responsibilities:

• Involved in creating Design documents (SDS and SRA) by understanding and analysing existing system
• Interacted with the client to gather requirements and presented demos on the application.
• Designed the solution structure for the application, Implemented the Data Access Layer using Microsoft Enterprise Library and ADO.NET Entity Framework to communicate with SQL Server
• Implemented Infragistics RAD Grid controls in the TV Web Application

Confidential

Technologies Used: ASP.NET, C#, VSTS, SQL SERVER 2005, ANTS Profiler

Responsibilities:

• Involved in creating Design documents by understanding and analyzing the new requirements
• Involved in coding and build related activities for the application also involved in creating tables, stored procedures and functions, creation of Automated Unit Test scripts and defect fixing
• Provided production support for the project

Confidential

Technologies Used: VISUAL STUDIO 2008 (ASP.NET, C#), ADO.NET Entity Framework, LINQ, VSTS, SQL SERVER 2008, MS Enterprise Library 4.1.0, SSIS, Visual Web GUI, MS STYLE COP

Responsibilities:

• Responsible for requirements gathering, client interaction, design documentation, database design, coding and deployment of the system
• Responsible for setting up daily meetings with the team and the client to update the status of the project and to resolve the clarifications
• Responsible for setting up the local development environment using Visual Studio Team Foundation Server
• Responsible for developing Windows Services, SSIS Packages, Database Scripting using Visual Studio 2008 and SQL Server 2008
• Responsible for extending Data and Logging Application Block of Microsoft Enterprise Library 4.1.0
• Responsible for Implementing Microsoft Style Cop for coding documentation along with the Visual Studio