• 15years' experience in Systems Analysis, Design, Development and Implementation of applications for various businesses includingBuilding Efficiency Department, Pharmaceuticals/Healthcare, Telecommunications, Government Systems Schools , Supply Chain management, Insurance Systems, Retails, Trading Systems, Banking System, Business and Finance Applications
• 10 years' experience in .Net, 4 Years using MVC and 10 years using SQL Server
• Excellent command over MVC, Asp.net, C , VB.Net, Entity Framework, Linq, Knockout, AJAX/Jquery, JSON, Web API, WCF, ETL, SSIS, HTML, CSS, SQL Server, T-SQL, Oracle and PL/SQL
• Experience developing and maintaining multi-layer applications using latest Microsoft Development Tools
• Experience in Enterprise wide, multi-platform Application Development and Analysis with emphasis on Productivity, Efficiency and Maintenance
• Good understanding and hands-on experience of SDLC processes, Documentation and Task Completion
• In-depth Knowledge of latest Model View Controller Pattern,Microsoft Distributed Technologies and Service Orientated Architecture
• Knowledge of QlikView Reporting, SQL Server Reporting Services and Crystal Report
• Key area of expertise in Project development with emphasis on quality and thoroughness of Code
• Knowledge of Sales and Marketing, Business Processes and Contracts
• Understanding of performance issues in Repositories, Frameworks, Databases and Architectures
• Experienced in Project planning, Analysis, Design, Implementation and versatile team player with good communication and writing skills
• Goal oriented, team player, quick learner, and proficient in managing multiple projects simultaneously

Programming Languages MVC5, ASP.NET, C , VB.Net, EF,LINQ, Web API, WCF, T-SQL

RDBMS/Database Microsoft SQL Server 2008 R2, Oracle 9i

Development IDE Visual Studio 2013 Update 2

Frameworks .NET Framework 4.5.1

Database Tools SQL Server Integration Services, Extract Transform Load

Web Servers Internet Information Server 7.5

Application Programming Web services WCF , Web API

Interface

Operating Systems Microsoft Windows Server 2013

Reporting Tools Qlikview,SQL Server Reporting Services, Crystal Reports

Scripting AJAX/JQuery, JavaScript, JSON, REST, Knockout, CSS3

Requirement Analysis Tools Unified Modeling Language

Source Control Team Foundation Server

Professional Experience

Confidential

Programmer Analyst

Forecast

• The forecast uses repositories for selected regions / branches to load opportunities and manager is able to edit and update to the opportunities using MVC Dialog for LOB Breakup or Product Code Probability and Percentage.

Opportunity

• The changes are related to Calculation for line of business. Updated Contract Values are used for editing and reportingfor Manager in both the Screens and Reports.The repository updatedfor opportunity and Totals.

Reports

• Detailed reports consists of Branch, Region HQ for LOB Statistics / Product Rollup based on selected region. Totals are maintained on each LOB or Product Code Rollup. The entire Region/Branch is totaled in Repository after updates are made by manager on Opportunity.

Environment: MVC5, C , VB.Net, ASP.NET, Entity Framework 6.0, LINQ, C .NET, CSS, AJAX/Jquery, JSON, HTML5, CSS3 , Web Services, Visual Studio 2013 Update2, SQL Server 2008 R2

Confidential

Web and Database Developer

Responsibilities:

• Admin Forms
• Contract Request Form, Blackberry Request Form, Folder Access request Form, FTP Access request Form, VPN Access Request form, Ipad App Request Form, New User Request Form, Controller Form to integrate in Portal
• MDM Export
• Developed ETL Jobs create searchable lookup table for practitioner database maintained using SAS Data objects. The MDM Export has lookup table for various key fields like ME Number, HIN Number, Tax Identifier number and address for practitioners and Organizations.
• Weekly/Monthly Jobs
• For mapping Back office information for Hospital and Practitioners to identify Sales Targets, Developed ETL Jobs populate Weekly Call File Data, Sales Data, CMOP Data and Caremark Data.
• Aggregate Spend Management System
• Aggregate Spend Management System provides Mart and Porzio feeds for Spend Reporting required by Compliance Department. Developed Load ExcelSheet ETL Jobs to upload data from excel spread sheet into database table using various rules for bulk insert.
• Sales Reporting
• Developed Stored procedures for Sales force changes, Call Activity changes
• Model N Data Loader Application
• Model N Application provides batch driven work flow to run SSIS Jobs and Model N Data Jobs for upload of Customer, Members and Sales Data
• Salix Work Assistant
• Work assistant Portal used over intranet by network users in Salix. The Salix Work Assistant provides Security model and Menu driven interface to be able to add applications based on access level using database and Active Directory. Developed Report Inventory, Clinical Carryforward bit, Model N Web Services, HCP Search, HCO Search, and Data Loader to trigger ETL Jobs and Transfer applications for Salix Work Assistant
• SalixMDM
• Developed WinForms 2012 based data stewardship application for SAS MDM Data Objects

Environment: ASP.NET 4.0, WCF, LINQ, Telerik, C .NET, Qlikview 11, ETL, HTML5, CSS3, AJAX/Jquery, CSS, Visual Studio 2012, SSIS, SQL Server 2008 R2, Data Loader Model N Web Services for Oracle

Confidential

Module Lead

Responsibilities:

• Generate Design documents, unit testing result document, implementation in production environment
• Develop application to maintain Daily Statistical Reports forRFA's flowing into the system fromsourcesfor facility, segments, acknowledgments and billing RFA, Circuit, ASR, MRCs by means of SSIS Packages pulling from SQL Server and Oracle source into the portal production database.
• Implemented manual table for statically storing the updates by designers/planners for provisioned orders to allow them to track workflow real-time throughout the day.
• Implemented ORM using Linq-to-Sql classes with VB.Net front end
• Implemented advanced .Net charts by Oversight Manager, By Status, By Project, By MRC, by Owner with drilldown view and Telerik controls Radgrid controls, dock controls with AJAX and Javascript support
• Enhancements of the web application with new workflows for acknowledgments WISOR updating both SSIS Packages and Portal Logic
• Performed Database migration to faster database server
• Converted DTS packages to SSIS Packages
• Enhanced portal performance by SQL tuning, database normalization and Caching

Confidential

Responsibilities:

• Design, Develop, Implementation and Testing in Production Environment
• Developed application to maintain Daily Statistical Reports for service orders flowing into the system from various sourcelike Red/Blue Network.
• Implemented manual table for statically storing the updates by auditors.
• Implemented ORM using EDMX and WCF based Framework with Web Service Client Library
• Implemented advanced .Net charts Products wise audits with drilldown view with Telerik controls Radgrid controls, dock control with AJAX support

Confidential

Responsibilities:

• Design, Develop and Implementation in Production Environment
• Developed application to maintain Daily Statistical Reports for disputes flowing into the system from for Circuit Level Data.
• The portal allows storing attachments for e-mails and documents for references.
• Implemented transaction tables for statically store the updates from managers.
• Implemented advanced .Net charts for MRC's valid and rejects, by Owner, By Status and by Manager with drilldown view and Telerik controls Radgrid controls, dock with AJAX support

Confidential

Responsibilities:

• Design, Develop, Implementation and Testing inProduction Environment
• Based on Model View Controller Approach. Retrieved data using repositories and displayed using Views and Dialogs based in AJAX/Jquery.
• Implemented advanced .Net charts for MRC's valid and Dispute, by Monthly FOCed, By ECCKT with drilldown grids

Confidential

Responsibilities:

• Design, Develop, Implementation and Testing in Production Environment
• Implementation of Custom CMS based on jquery/CSS to show Portal Dashboard and drilldown views.
• Implemented advanced .Net charts with drilldown view and Telerik controls Radgrid controls with AJAX/jQuery support

Confidential

Responsibilities:

• Design, Develop and Implementation in Production Environment
• Implement various charts for Specials, Paper and Planning.
• Implemented advanced .Net charts with drilldown view and Telerik controls Radgrid controls with AJAX support

Environment: MVC4, ASP.NET 4.0,WCF, LINQ, Entity Framework 4.3, Telerik, C .NET, VB.Net,HTML5,CSS3, AJAX/JQuery, JSON, CSS,.Net Charts, Visual Studio 2010, SSRS, SSIS, SQL Server 2008 R2, Oracle 9i

Confidential

Programmer Analyst

Responsibilities:

• Generate Design documents, unit testing result document, implementation in production environment
• Developed application to maintain Client Profile, Lawoffices, attorney, invoices, account payments
• Created Windows Communication Foundation WCF Services for database entitiesincluding methods for Update
• Implemented advanced session based application id validation for each module
• Enhancements of the web application with new modules
• Implemented Single Sign On functionality.

Environment: .Net Framework 4.0, WCF, Entity Framework,ASP.NET 4.0, LINQ, Content Management, C .NET, Visual Studio 2010, JQuery, Javascript,SQL Server 2008 R2 as Database

Confidential

Programmer Analyst

Responsibilities:

• Generate Design documents, unit testing result document, implementation in production environment
• Developed application to maintain membership ledger of the students using MVC Approach.
• Developedrepositories forStudents, Locations, Grade, Membership and Attendance
• Enhancements to Web Application with new screens e.g. Tests and Scores
• Wrote SQL Queries to create tables, stored procedures.CreatedSSIS Packages for data loadersusing SQL server.
• Developed various T-SQL stored procedures for using in Linq-to-SQL class inrepositories
• Implemented reports usingSSRS

Environment: MVC3, ASP.NET 4.0, AJAX/Jquery, JSON, Entity Framework, LINQ, C .NET, WCF,Visual Studio 2010, SSRS, SSIS, SQL Server 2008 as Database

Confidential

Programmer Analyst

Responsibilities:

• Generate Design documents, unit testing result document, implementation and bug fixes in production environment
• Implemented LINQ to SQL Classes in Web Portal
• Generated reports using Reporting Services
• Developed user controls that interact with web service for 'auto-complete' functionality
• Executed complex migration tasks SSIS packages for importing score from files Third party into database

Confidential

Responsibilities:

• Analyze and document existing programs architecture of SAIS framework and document for in-house maintenance
• Generate Design documents, unit testing result document and implementation for bug fixes in production environment
• Maintain application for issues raised by call centers and business analyst
• Develop various detailed reports, modification to existing reports on SQL Server
• Maintained several different applications written using COM and T-SQL required for yearly School Funding including Student Details, School Finance and Enterprise modules.
• Developed complex maintenance batch jobs DTSX packages for database tasks. Performed Archiving of database using Integration Services tasks

Confidential

Responsibilities:

• Generate Design documents, unit testing result document, implementation and bug fixes in production environment.
• Developed custom user control to show schema of 14 tables e.g., Memberships, Attendance, Grades, Tuition details etc.., that supports for collapsible panel based on Jquery. Also developed various user controls to achieve common functionality in these multiple Wizard based screens.
• Used Details View control for ADO.NET binding
• Created Windows Communication Foundation WCF Services for Student search based on different criteria
• Developed various T-SQL stored procedures

Environment:Visual Studio 2008 C , ASP.Net, Net Framework 3.5, WCF, SSIS, ETL, Telerik ASP.net controls, AJAX/JQuery, LINQ, Application Block, IIS6.0, ASP/IIS, Windows Services, T-SQL, Microsoft SQL Server 2000 as Database

Confidential

Sr. Software Developer

Responsibilities:

• Analyze existing programs architecture for development and maintenance including support for 2 MTS servers and 1 central server
• Design, Develop, and Debug Windows services in DJIT.. The stored procedures are called from services as well as MTS components. They are scheduled in batch jobs.
• Performed optimization by re-aligning scheduled tasks and batch jobs to increase efficiency of servers and reduce timeout issues
• Actively involved in configuration of advanced call center system alert for outages in services, procedures and files based on CPU usage
• Deployed build from offshore development team in production environment for bug fixes and testing
• Interact with regional team as well as development team issues like files not flowing from other teams, region failing to process data, verifying data with other teams such as Pricing, Order, Warehouse, Invoicing, Production as well as network team.

Environment: Microsoft Visual Basic 6.0/Microsoft Visual C , Windows Services, Microsoft DNA, COM/MTS and Microsoft SQL Server 2000 as Database