Technical Skills

Web Technologies

HTML XML ASP.NET WCF MVC ADO.NET SSRS Entity Framework

Languages

C VB.NET SQL

Scripting Languages

Java Script JQuery Ajax JSON

Databases

SQL Server 2012 IBM DB2 v9 Oracle 10g

Development Environment

Visual Studio 2013

Tools

TFS VSS SVN Mercury Quality Center Aprimo Marketing 7.6 WinSQL PVCS Hp Load Runner PL/SQL Developer

Project Title

• Database Platform and Operation Tools
• This project involved development of various homegrown tools to facilitate DBA s day to day tasks. Tools developed during my tenure are
• - DBIS Database Inventory management System
• - Defect Tracker Tool to manage end to end defect life cycle.
• - Backup Reporting Tool Tool to report and update DB backup status from various systems.
• - CIGARS A survey tool for DB creation.
• - Database Operations Dashboard A reporting tool to consolidate operations data from various systems.

Client

Confidential

Domain

Confidential

Project Duration

Confidential

Role

.NET Lead

Environment

.Net Framework 4.5/4.0 ASP.NET C MVC 4.0 Entity Framework 4.1 TFS SQL Server 2012 SSRS 2008

Responsibilities

• Interacted with analysts project managers and project sponsors to understand their pain areas and proposed appropriate solutions.
• Involved in complete SDLC of the project and full stack application development.
• Wrote technical design documents and did effort scoping of projects/modules.
• Designed and developed UI using Razor view engine ASP.NET JQuery CSS3 AJAX and MVC 4.0
• Created model classes and developed middle tier controller and factory components.
• Created application s data access layer using Entity framework database first approach and LINQ.
• Developed employee look-up BLUES WCF service using wsHttpBinding.
• Designed application s data model and wrote scripts to create tables stored procedures views and triggers.
• Developed various reports critical to business using SSRS.
• Used SQL Tools such as Query Analyzer and SQL Profiler for optimization of report queries.
• Used Team Foundation Server for source code version control.
• Performed thorough application testing before each delivery.
• Gave knowledge sharing sessions to end users about usage of new tools.

Project Title

PlanChexx and ServiceChexx

Planchexx application is used by Ecolab clients to define cleaning procedures.Cleaning procedures are detailed instructions defining the steps to be followed along with the chemical products to be used to perform a cleaning task.

The application also provides functionality to setup cleaning products associate responsibilities area and Item for respective clients and facilities and a mechanism to generate Cleaning Procedure Reports in PDF format.

ServiceChexx application is used by Ecolab field users for administering the field user s Tasks Projects and prepare Service Reports.

These applications are used globally by Ecolab s Food Beverage Division.

Client

Confidential

Domain

Confidential

Project Duration

Confidential

Role

Module Lead

Environment

.Net Framework 2.0 / 3.5 ASP.NET with VB.net WCF ASP SQL Server 2008 SSRS

Responsibilities

• Interacting with client for requirement gathering clarifications and proposing designs.
• Writing technical design documentation and effort estimation.
• Development of modules as per the new enhancements in functionality.
• Preparing and executing unit test cases.
• Preparing SSRS Reports required by business.

Project Title

Humana Enterprise Architecture

Humana s Enterprise Architecture Applications Support and maintenance initiative deals with the support and enhancement of various multi-platform/technology applications. One such application is eHub that primarily deals with Claims processing and remittance in HIPAA compliant X12 format. This system gets the claims data from provider processes it and sends it to clearing house and also handles the communication from clearing house. Other Applications under the EA umbrella are Turn Centre Wizard TCW Enterprise Turn Point eTp Humbuild Enterprise Architecture Portal Management EAPM PCI Data Vault Enterprise Logging etc

Client

Confidential

Domain

Confidential

Project Duration

Confidential

Role

Module Lead

Environment

.Net Framework 2.0 / 3.5 ASP.NET with C / VB.net SQL Server 2008 PL/SQL SSIS

Responsibilities

• List of activities include Support and Enhancements
• Provide necessary support coverage and perform application monitoring.
• Development of modules as per the new enhancements in functionality.
• Handling Break Fixes or any incidents which require fixing the source code or data within agreed upon SLA
• Handle ad-hoc or non-production reporting.
• Provide response to business queries pre-development consulting and analysis on service desk tickets

Project Title

Amex By Invitation Only

This portal was built to provide an online ticketing system for the booking of events for American express privileged customers. The system provides functionality for ticket booking billing generation of Invitation letters etc.

Client

Confidential

Domain

Confidential

Project Duration

Confidential

Role

Senior Programmer

Environment

.Net Framework 2.0 ASP.NET with VB.Net SQL Server 2005 Hp Load Runner

Responsibilities

• Development of new modules as per the requirements.
• Fixing of Defects in AT SIT and UAT
• Execution of Test Scripts.
• Deployment of code on servers.
• Daily status reporting to onshore team.
• Creation and modification of SQL stored procedures.
• Creating and executing Load Test scripts on Load Runner.
• Providing warranty support and resolution of tickets within SLA s.
• Individually responsible for knowledge transition and hand over of the complete application to another organization.

Project Title

Amex Campaign Management

This portal is used to generate several kinds of advertisement campaigns for the American Express credit cards. The system handled the complete workflow of the campaign right from the creation till the distribution.

Client

Confidential

Domain

Confidential

Project Duration

Confidential

Role

Senior Programmer

Team Size

40-50

Environment

.Net Framework 1.1 ASP.NET with C JavaScript Oracle 10g Aprimo Marketing 7.6

Responsibilities

• Interacting with client for requirements gathering and analysis.
• Participate and assist team in design decisions.
• Creating design documents.
• Development of components according to the requirements.
• Designing of Workflows using Aprimo tools.
• Creation and execution of SQL scripts.
• Deployment of code on servers.

Project Title

One Beacon Insurance

OneBeacon Insurance Group s underwriting companies offer a range of specialty and personal insurance products. One Beacon Insurance is an implementation of Accenture s claim component solution using AICS architecture. The project caters to all the needs of the insurance sector.

Domain

Confidential

Project Duration

Confidential

Role

Programmer

Environment

.Net Framework 2.0 ASP.NET with VB.Net IBM DB2 v9 AICS 6.1

Responsibilities

• Development of claims components having 3-tier architecture with independent Data Access Layer Business Logic Layer and User Interface Layer.
• Execution of Unit Tests.
• Analysis and implementation of SQL queries in IBM DB2 v9.
• Migration of components from VB to VB.Net.
• Fixing of defects during Application Testing phase.
• Interacting with onsite client for resolving issues.