.Net/ Sql Lead Developer

Experience Summary

** ***** ** **********, ************* in .Net, ASP.Net, SQL Server, Oracle and PL-SQL. Proficient in analysis, designing, architecting, development, managing complete life cycle of the complex distributed multi-tier enterprise application which includes initiating, planning, scheduling, monitoring & controlling and execution.

Exceptional abilities in project design and management with the organizational and supervisory skills to assure success. Delegates and monitors work to meat and beat deadlines. Excellent communication, documentation, problem solving and decision-making skills.

Outstanding motivator and builder of teams. Works well in both team environments and individual assignments.

Very good exposure and experience in C#, VB.Net, ASP.Net, ADO.Net, C++, WCF, LINQ, MS SQL Server 2000, MS SQL Server 2005/2008/2012, Oracle, SSRS, Crystal Reports and Entity Framework and Telerik controls.

Consistently met deadlines for database creation and implementation projects while working with software development and client service teams to further improve the product.

Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, Functions).

Demonstrated ability to adapt to company's evolving environment by learning quickly and taking on expanded roles by implementing new procedures and improving existing ones.

Extensive exposure in the Insurance and Finance domain and good exposure in development methodologies such as waterfall, iterative model and agile development methodology.

Strong exposure in OOAD concepts and. Net related technologies such as Ajax, JavaScript, jQuery, Angular JS, XML, HTML, CSS and .Net Design Patterns.

Very good exposure in Windows and Web applications & good Knowledge in MVC Framework.

Microsoft Certified Professional in C# & MS SQL Server.

Education

Title of the Degree with Branch

College/University

Year of Passing

BACHELOR’S DEGREE

(Computer Science & Engineering)

AWH Engineering College/ Calicut University

2005

Pre-Degree

Mar Ivanios College/Kerala University

2001

X

CPHSS Kadakkal / Board of Kerala

1999

Technical Skills

Operating Systems

Windows 2000, 2003, Vista, Windows XP, Windows 7

Technologies

.NET framework 2.0/3.0/3.5/4.0/4.5 ASP.NET, ADO.NET, MVC Framework

Languages

C#, VB.Net, C, C++

RDBMS

MS SQL Server /2005/2008/2012, Oracle

Tools and Utilities

Visual Studio 2005/2008/2010/2013,

SVN, TFS (Team Foundation Server),

VSS, Visio

Employment History

Name of the Company

Designation

Address of the employer

From

To

Duration(Years)

Cognizant

Senior Associate

Cognizant Kochi

(Athulya, TCP & CNC)

July 2012

Dec 2017

7 years

Phoenix, Arizona, United States

October 2010

March 2012

WellsFargo

Senior Developer

Tempe, Arizona, United States

July 2010

Sep 2010

3 Months

UST Global

Senior Software Engineer

Techno park, Trivandrum, Kerala

Apr 2006

Oct 2009

3.6 years

Project Profile

Project Name

ProC – GM- Visa Petition

Technology

ASP.Net(C#), Visual Studio 2013, Sql Server 2012, TFS, Windows Service

Project Abstract

ProC application is developed to reduce the effort of generating the petition document for the GM team. ProC integrate with different upstream applications, consolidates all the information and generates the required documents which is needed to submit to USCIS. Since it’s a continuation application for Visa petition, the same needs to be linked with other data repository systems.

Client Description

Cognizant Technology Solutions:

Cognizant is an American multinational corporation that provides IT services, including digital, technology, consulting, and operations services. It is headquartered in Teaneck, New Jersey, United States. Cognizant is listed in the NASDAQ-100 and the S&P 500 indices.

It made an initial public offering in 1998, after a series of corporate splits and restructures of its parent companies. It was the first software services firm listed on the NASDAQ. During the dot com bust, it grew by accepting the application maintenance work that the bigger players were unwilling to perform. Gradually, it ventured into application development, complex systems integration and consulting work. Cognizant had a period of fast growth during the 2000s, becoming a Fortune 500 company in 2011.In 2015, and the Fortune magazine named it as the world's fourth most admired IT services company.

Role

As a team lead, I was part of below responsibilities.

Understanding the business rules of the application and involving in all the phases of SDLC.

Implementation of the new functionalities in the application including design, doing the enhancements in page design and Coding based on the business rules.

Designed database, tables and views structure for the application.

Optimized query performance and populated test data

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Performed quality assurance and testing of SQL server environment

Assisted clients in using implemented software projects

Helped the team/team members in resolving the technical issues and provided various suggestions for improving the performance.

Project Duration

18 Months

Project Name

Affinion Voyager V2E

Technology

Visual Studio 2010, Oracle 11g, Tortoise Subversion, Soap UI, Fxcop, Nuget.

Project Abstract

Affinion identified the need to move to a global member-servicing platform to support important operations of the business. Helix is a platform that is being built to replace Siebel implementation in Europe. The platform provides services to customers and clients through an application stack that includes web services, batch processing, internal and external servicing tools, and reporting.

The Helix platform incorporates the following project delivery streams:

Voyager (Implementation in Europe, and other international markets)

Enterprise (Implementation in the U.S.)

Voyager services are present in the Web Services layer developed as part of the Helix platform. The focus of this project is to consolidate all Affinion information using one CRM-servicing platform and replace the following CRM solutions used in international markets.

V2E (Version 2 Enhanced) is a custom developed framework that hosts all the websites of Affinion. It was developed to separate the concerns of presentation and business logic. This was to improve scalability of the application. As a part of change in the database models and framework, the online application is migrated and revamped into Helix framework.

Client Description

Affinion International:

Affinion Group is the global leader in the designing, marketing and servicing of comprehensive customer engagement and loyalty solutions that enhance and extend the relationship of millions of consumers with many of the largest and most respected companies in the world. Affinion provides programs in subscription-based lifestyle services and personal protection, point’s program management, insurance and other areas that help generate increased customer loyalty and significant incremental revenue for more than 5,550 marketing partners worldwide.

Role

As a team lead, I was part of below responsibilities.

Getting knowledge of the Siebel framework and the Helix framework.

Understanding the business rules of the application and involving in all the phases of SDLC.

Implementation of the new functionalities in the application including design, doing the enhancements in page design and Coding based on the business rules.

Developed Manual unit test cases & Automated MS Test and executed the test cases.

Performed “Code review” for the entire team for all the changes done.

Helped the team/team members in resolving the technical issues and provided various suggestions for improving the performance.

Project Duration

18 Months

Project Name

Trade Rebalance Application Rewrite

Technology

C# Dot Net version 4.5, SQL server 2008, WCF, VB6, Crystal Reports, SVN

Project Abstract

The scope of the assignment is to upgrade Trade Rebalance application from VB6 to a .NET smart client application. Trade Rebalance application deals with the rebalance process which will be accessed by the Trading Team of Kaspick. The Rebalance process is a rule-based process that analyzes the current portfolio positions against pre-established target positions for each portfolio. The result of this process is a set of trade transactions, subject to minimum trade constraints, that will bring the portfolio into balance with their investment allocations.

Existing VB6 application uses VC++ APIs to perform the trade rebalance process. This VC++ API calls retained the new dot net application. Trade rebalance application also interacts with other vendor applications like AXYS to get the latest market price of the trades.

Highlights of the Trade Rebalance application rewrite project

• Executed the project using scrum agile methodology.

• Load data from other master database using stored procedures.

• Load data from external systems using Imex.exe and rep32.exe utilities

• Framework design using Dot net windows CAB shell architecture.

• UI design using Dot net forms and third-party controls like DevExpress and Far point spread.

• WCF framework implementation for performing all the database operations.

• Reports generation using crystal reports.

Client Description

KASPICK & COMPANY

Kaspick & Company provides comprehensive support to the planned giving programs of many of the nation's leading academic, religious, medical, environmental, and social service organizations. Their mission is to help the clients to materially improve the value of their programs by providing sophisticated asset management, high quality gift administration, informative reporting, and expert program consulting.

Role

To gather the requirements from the existing application and new changes from the BRD.

To prepare Design Documents for the application and estimates for the application rewrite.

Coding and automated unit testing of the application.

Coordinate the integration testing and deployment.

Monitoring, support in QA and UAT phase.

Project Duration

18 Months

Project Name

AMEX_ARC

Technology

Visual Studio 2008, C#, ASP.Net, MS SQL Server 2005, Telerik AJAX toolkit, Entity Framework, ADO.Net, LINQ, SVN, AJAX, JavaScript, JQuery, HTML, XML, CSS.

Project Abstract

Project involves developing a system to create model inventory capability that meets regulatory and industry standards. This will facilitate and streamline the validation Group.

The application will provide the functionality to generate the request, Search the existing request, Access control, Workflow Management, Scheduling ability and will have to be integrated with existing Amex systems.

Client Description

American Express

American Express Company is a diversified global financial services company headquartered in New York City best known for its credit card, charge card, and traveler's cheque businesses.

Role

Analyzing the requirements for the new system.

Working with Cognizant’s architects and client’s team in designing and developing the new system using Microsoft Technologies and C# as a programming language.

Developed the web application using Visual Studio 2008 (.Net Framework 3.5), SQL Server 2005, Entity Framework, LINQ, XML, CSS etc

Involved in Database Design, Schema and Table Design Using SQL Server 2005.

Involved in all phases of the project and involved for providing customer support.

Project Duration

20 Months

Project Name

Server Management Program (SMP)

Technology

Visual Studio 2008, SQL Server 2005.

Project Abstract

The purpose of this project is to manage the server risk and activity information of the Service Delivery Team.

The data stores are used to store and manage the Service Delivery Team (SDT) server risk and activity information.

SMP Risk Register – The SMP Risk Register is a repository of server related risks impacting the SDT.

SMP Activity Inventory – The SMP Activity Inventory is a repository of the remediation activities for addressing the identified SDT server risks. These activities may be associated with one or more of the risks in the SMP Risk Register.

The document storage is used to store and manage documents created by the Server Management Program Office (SMPO), as well artefacts and evidence documents resulting from activities performed by the SDTs

Client Description

Wells Fargo

Wells Fargo & Company is an American multinational diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit card.

Role

Developed the application using Visual Studio 2008 (.Net Framework 3.5), TFS, Microsoft Visio, SQL Server 2005, XML, XSLT

Developed a centralized data store for risk records (referred to as the SMP Risk Register).

Developed a centralized data store for activity records (referred to as the SMP Activity Inventory).

Developed a web-based UI for managing the risk and activity records using Telerik controls, Java Script, AJAX and CSS.

Project Duration

3 Months

Project Name

Clinical Operations

Technology

Visual Studio 2008, C#, ASP.Net, Oracle, PL-SQL, MS Visual Source Safe, Microsoft Visio, AJAX, JavaScript, HTML, XML, XSD, CSS, Windows Service

Project Abstract

The purpose of this clinical operations project is to consolidate business operations in the Clinical area by integrating current systems utilized in Legacy Anthem and Legacy Well Point. The aim of this project is to replace the existing application in clinical operations such as Therapeutic Interchange (TI) portion of the Cost of Care (CoC), Medication Therapy Management Program (MTMP), Refill Reminder, and Retrospective Drug Utilization Review (RDUR) Quality of Care (QoC) Intervention.

Client Description

WellPoint

WellPoint, Inc. is the largest health plan company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc. and began trading its common stock under the WLP symbol.

Role

Developed the application using Visual Studio 2008 and SQL Server 2005

Written the business layer source code using three-tier architecture (MVC) in C#.

Involved in Database Design, Schema, Table and View Design Using Oracle.

Involved in creating Stored Procedures and Functions and full life cycle of the project.

Project Duration

18 Months

Project Name

Dash Board Metrics

Technology

C#, .NET Framework 3.5, WCF, Ajax, SQL server 2005

Project Abstract

WellPoint is looking for continuous improvement in the ability of UST Global to deliver software applications with improved performance in - quality, productivity, schedule, effort and cost. A metrics program along with an automated metrics dashboard tool can ensure continuous improvement in software development through a number of project tracking mechanisms. The metrics program would also lead to a standard metrics definition in the Account and help the project team in decision-making using the data driven approach. The purpose of the project is to have a Dash Board to collect the Metrics required by the Client.

Client Description

WellPoint

WellPoint, Inc. is the largest health plan company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc. and began trading its common stock under the WLP symbol.

Role

Involved in Analysis and Design of the system.

Prepared the Technical design document.

Developed the Use Cases, Class Diagrams

Developed front end (Presentation layer) using Java Script, AJAX, and CSS etc…

Written the business layer source code using three-tier architecture (MVC) in C#.

Project Duration

6 Months

Project Name

LGM Letter Generation

Technology

C#, .NET Framework 2.0, Oracle, PL-SQL

Project Abstract

This application is Automatic letter generation system, which generates insurance claim’s letter; the letter template structure will be stored in Database. Based on the user preference, letter will be created either in batch process or real time. This system has very high-performance requirement like the ability to generate 15,000 letters per day. After generation of the letter, transmission modes are checked from the database and send to appropriate queue, from there, letter is sending to different transmission modes like fax and print. Generally, a letter contains LOGO, recipient address and medical reference details.

Client Description

WellPoint

WellPoint, Inc. is the largest health plan company in the Blue Cross and Blue Shield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc. and began trading its common stock under the WLP symbol.

Role

Developed the application using Visual Studio 2005 (.Net Framework 2.0)

Involved in creating a windows service application, which run in back ground for checking the database for starting some batch jobs.

Involved in Database Design, Schema and Table Design Using Oracle.

Involved in iterative development process and delivery process.

Implemented system logging, XML parsing, Mail sending options etc.

Written Unit test cases for unit testing and bug fixing.

Consumed Web Services using WSDL and SOAP.

Project Duration

18 Months

Contact Details

Email Id: *****.***@*****.***

+1-407-***-**** (M)

Contact this candidate