Sql Server .Net

MANISH V. EMMANUEL

804-***-**** (cell)

**********@*****.***

PROFESSIONAL SUMMARY

8+ years’ experience in Microsoft Technologies and Software Development Life Cycle.

Strong IT experience in analysis, design, development, testing and maintenance of product/business applications including Web Applications, Windows Applications, Web Services and Windows Services.

Proficient in developing applications using ASP.NET, C#,VB.Net, dotnet framework 4.5/4.0/3.5/2.0,WCF, Windows Services, Web Api, Ajax, ADO.NET, Java Script, JQuery, HTML, CSS, Bootstrap, XML and HL7 standards.

Proficient in writing and deploying rules using Corticon (Business Rule Management System)

Strong analytical and conceptual skills in database design, development, stored procedure and triggers in SQL Server 2005 / 2008 R2/ 2012, SSIS and SSRS

Working experience on RESTful Programming using HTTP verbs for CRUD operations

Experience with Data Accessing using Data Adapter, Data Reader and Dataset in ADO.NET

Experience on Test driven development using MOQ

Experienced in creating reports using Crystal Reports and SQL Reporting Services

Good understanding of .NET architectural design patterns such as MVC, MVP.

Experience in Development methodologies like Agile and Waterfall models

LINQ experience to work with Datasets, Objects, Entities as well as Entity Framework

Hands-on developer and innovator, who have capability to learn, evaluate and implement new technology quickly

A team player who can share and learn from others, but at the same time be able to work very independently

Strong analytical & logical abilities in business analysis & technical documentation.

Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical stakeholders

TECHNICAL SKILLS

Hardware /Platforms

Windows 9x/NT/2000/XP/Win 7.

Technology

.NET 2.0/3.5/4.0/4.5, ASP.NET, ADO.NET, WCF, WEB

API, SSIS, SSRS, Entity Framework

Programming Languages

C#, VB.NET, T-SQL, XSLT, XML,

Databases

SQL Server 2005/2008 R2/2012

Scripting Languages

JavaScript, HTML, JQuery

Version Control Systems

IBM Rational Clear Case, TFS, TortoiseSVN

Tools

Corticon 5.5, MOQ, Dev Express, Infragistics

Standards

Architecture/Design Pattern

Health Level Seven (HL7)

Two/Three Tier, MVC 4

PROFESSIONAL EXPERIENCE

Employer: Deloitte Consulting LLP Client: State of Delaware

Sr. Solution Engineer Nov 2014 – Till Date

Project Summary: ARMS (Audit Recovery Management Service) is a web application designed to manage cases related to potential incidents of fraud or abuse of the state’s benefits, and to handle the recovery process for potential over payment of benefits.

Responsibilities:

Involved in requirement gathering from the state of Delaware.

Did the documentation of the functional/requirement specifications.

Created an understanding document of the business logic present in COBOL.

Converted business logic from COBOL to C#.Net

Extensively used JQuery for client side validations.

LINQ with ADO.NET Entity Framework was used for data manipulation and CRUD operation

Designed and implemented new tables (SQL Server 2012 Management Studio).

Worked with Complex T-SQL queries to get the desired result from database tables

Created Web API (Restful service) services as a middle layer for communication between UI and database

Created and validated Models and Controllers of Web API.

Used Bootstrap in order to maintain page layouts, colors and fonts, in throughout the application.

Developed various rules as part of the rule engine using Corticon and deployed the same.

Created User Control as part of common screen which was reused on various other screens

Interacted with various external services as part of various data validations.

Performed Unit Testing on the code and create unit test scripts using Microsoft test.

Maintained the code and set up builds in TFS.

Environment: .Net framework 4.5, Visual Studio 2013, ASP.NET, C#, Entity Framework, Bootstrap, Corticon 5.5, JQuery, SQL Server 2012, HTML, Web Api services.

Employer: Cognizant Technology Solutions Client: Xerox Business Services

Sr. Developer Jan 2013 – Nov 2014

Project Summary: CyberFormance is an Analytical portal developed in order to assist the clinical business analysts to perform certain day-to-day tasks to identify the key factors that impact the customer’s business. The application is combination various individual system components. This is deployed at common server and shared to multiple clients. Some of key features are its intuitive UI that depicts the trend as graphs and charts apart from normal reports.

Responsibilities:

Involved in requirement gathering.

Implemented MVC design & architectural pattern to isolate business logic from user interface.

Extensively utilized MVC features in the development, like Partial views where necessitated, custom control for meeting specific UI requirements, etc.

Developed business logic and code behind using C#.Net

Extensively used JQuery for client side validations.

Designed and implemented new tables and stored procedures (SQL Server 2008 Management Studio).

Worked with Complex T-SQL queries to get the desired result from database tables

Created WCF web services as a middle layer for communication between UI and database

Developed common Cascade Style Sheet (CSS) in order to maintain page layouts, colors and fonts, in throughout the application.

Developed Unit test plan and Unit test scripts

Involved in bug fixing and performance-tuning of the application.

Environment: .Net framework 4.0, Visual Studio 2010, ASP.NET, C#, MVC, ADO.NET, JQuery, SQL Server 2008, HTML, WCF Web services.

Employer: Cognizant Technology Solutions Client: Aetna - Medicity Inc.

Sr. Developer June 2012 – Dec 2012

Project Summary: Nexus Manager was a web application that was a key building block in setting up an HIE (Healthcare Information Exchange). It connects various Hospital Systems using HL7 messages as the source of data. It then converts the HL7 message to human readable format and saves it to a global database.

Responsibilities:

Gathered Business Requirements and User Specifications from business.

Prepared Technical design documents based on the Business flow

Developed interfaces and business logic using C# as code behind, to decode various types of HL7 messages.

Designed database tables using Normalization according to the requirements specified.

Developed new or updated existing stored procedure in order to save the corresponding values received as part of HL7 message.

Created WCF web services as a middle layer.

Developed unit test plan, unit test scripts and performed unit testing.

Involved in resolving production issues on priority basis

Supported users during testing phase and troubleshooting issues

Environment: .Net framework 3.5, Visual Studio 2008, ASP.NET, C#, ADO.NET, SQL Server 2008, HTML, WCF Web services.

Employer: Cognizant Technology Solutions Client: Aetna Inc.

Sr. Developer April 2012 – June 2012

Project Summary: The WorkAbility was a leading claim & absence management system which provided one-stop solution for disability & absence management. This web application was enhanced to include WKAB Mobility application, which aimed at creating a mobile specific version of the WorkAbility application. This allowed users to have a customized and enhanced experience when the website is used through mobile phones.

Responsibilities:

Created various ASP.Net pages for the WKAB Mobility application and integrated it with the existing application

Developed the business logic and code behind using c# .NET

Used JQuery for client side validation.

Written Stored Procedures and function’s to validate the data at backend and to execute the desired result at front end.

Implemented WCF services as one of the application layer.

Implemented Mobile Detection Logic in the application

Co-ordinated with the UI team to design and create the wireframes and visual design screens.

Implemented and coded same functionalities in mobile website keeping existing desktop website as a reference

Environment: .Net framework 3.5, Visual Studio 2008, ASP.NET, C#, ADO.NET, JQuery, SQL Server 2008, HTML, WCF Web services.

Employer: Cognizant Technology Solutions Client: Molina Healthcare

Sr. Developer Oct 2011 – April 2012

Project Summary: The ePortal was a web application which enabled an already contracted Molina provider or members to register on the e-portal. The ePortal application’s main modules included Claim submission, Service request submission, and Member eligibility validation and provider search.

Responsibilities:

Involved in the requirement gathering and preparation of the Detail Design Documents.

Effectively used Model-View-Controller MVC Façade Architectural pattern to decouple Data Access Logic and Business Logic from data presentation and user interaction.

Involved in designing and coding using ASP.NET, ADO.NET, C#, and HTML.

Worked extensively on web application using various UI controls like Grid View, Tree View and Menu controller.

Implemented WCF services as one of the application layer.

Involved in most of the major module of the applications and delivered the complete products in very less turn over time which highly appreciated by client and organization.

Was part of the architectural design team and helped the team for taking decisions on various components like logging, exception handling etc., that could be used in the application.

Developed database tables, views, stored procedures in SQL Server 2008

Involved in creating statistical analysis reports using SQL Server Reporting Services (SSRS).

Involved in Unit Testing and defect Fixes

Involved in warranty support and production support

Environment: .Net framework 3.5, Visual Studio 2008, ASP.NET, C#, ADO.NET, JQuery, SQL Server 2008, HTML, SSRS, WCF Web services.

Employer: Cognizant Technology Solutions Client: Aetna Inc.

Sr. Developer / Developer Jan 2010 – Oct 2011

Project Summary: Case Tracking Tool was a windows application developed using VB.net, which was used to track enterprise wide case installation milestones. Currently each Market segment within Aetna has its own version of the tool, which is used to track the cases. The intent of the CTT tool was to consolidate all such tools within Aetna and give a unified portal.

Responsibilities:

Developed business logic and code behind using VB.Net

Extensively worked with ADO.Net built-in objects like Data Adapter, Data Set and Data Reader etc to communicate with the database.

Developed database tables, views, stored procedures in SQL Server 2005

Involved in analysis, design, development, testing, implementation and post production support of the project.

Interacted with external vendor for feeds that was consumed by CTT.

Involved in daily status meeting with client

Analyzed the requirements and designed the Functional flow of the System.

Handled complex modules of project.

Ensured coding standards are strictly adhered to Aetna standards.

Environment: .Net framework 2.0, Visual Studio 2005, VB.NET, ADO.NET, SQL Server 2005.

Jeevan Infotech India (Pvt) Ltd.

Developer Oct 2008 – Dec 2009

Project Summary: Process control system was a web application used by Textile industries. The module consisted of all the process done in Knitting, Dyeing and printing. Second project was Yellow Pages which was also a web application. It sent advertisement to potential customer using the details entered by data entry operator. My last project was Asset Management System which was a web application that maintained the asset of a company. Some of the main modules of this project were Auto generation of maintenance schedule, Item Stock, Spares sales, asset transfer, mileage checkup etc.

Responsibilities:

Developed GUI and business logic using C# on .Net architecture

Extensively implemented Data Grids for displaying data, User Controls for detail view, and editable Data Grids for data manipulation in the presentation layer.

Design and implement new, and update existing, tables and stored procedures using SQL Server 2005.

Developed various reports using crystal reports.

Designed and executed test cases for unit testing

Environment: .Net framework 2.0, Visual Studio 2005, C#, ADO.NET, SQL Server 2005, Crystal Report.

Ebonite Décor L.L.C

Developer Oct 2007 – Oct 2008

Project Summary: Online Trading Management (OTM) was a web application used for trading purpose. OTM mainly had 4 modules which were Invoice, Sales, Purchase, and Stock.

Responsibilities:

Developed business and data access layer using C# and ADO.NET.

Written Stored Procedures, Views and Triggers to validate the data at backend and to execute the desired result at front end

Developed various Crystal Reports

Assisted in preparing various technical documents

Environment: .Net framework 2.0, Visual Studio 2005, C#, ADO.NET, SQL Server 2005, Crystal Report.

ACHIEVEMENTS

Received “Applause Award” from Deloitte Consulting LLP for exceptional work towards successful delivery of the project.

Received “Associate of the Month” award twice from Cognizant Technology Solution for excellent performance towards deliverables

EDUCATION

Bachelor of Engineering in Electronics and Communications, 2006

Karunya Institute of Technology and Science, Coimbatore, India

VISA

Green Card

Contact this candidate