Nehaa Malhotra Email: ac1cq9@r.postjobfree.com

SQL, SSIS, SSRS, .Net 4.0 C#, ASP.Net Mobile: 425-***-****

Professional Summary:

Valid L2 visa along with Authorized Work Permit.

7+ years of experience in programming and development.

Knowledge of SQL, SSIS, SSRS, .Net Framework, C#, ASP.NET with team leading exposure.

Experience of working with US and non – US clients where I had direct interaction with customers which helped me sharpen my technical skills and getting accustomed to different styles of working.

Strong knowledge and use of full lifecycle development methodologies, standards and procedures

Excellent written and verbal communication and interpersonal skills

Experience Summary:

Sr. Software Engineer – SQL Developer at UnitedHealth Group February’2012 – Dec’2015

Sr. Software Engineer at JK Technosoft Ltd. January’2009 – January’2012

Technical Skills:

Platform

Dot Net 4.0, ASP.NET, C#, AJAX, WCF, Web Services

Programming Language

C#, VB.Net, VB, JavaScript and C++

Microsoft Technologies

ASP.NET, ADO.NET, AJAX

Database

SQL Server 2008 R2, SQL Server 2005, MS – Access, MySQL

Source Versioning Control Tools

Team Foundation System (TFS), Tortoise CVS, Visual Source Safe

Development Tools

Visual Studio 2012, Visual Studio 2010, Visual Studio 2008, Visual Studio 2005, Visual Studio 2003, Business Development Studio

Web Tools

HTML, Java Script, JSP, XML, VB Script, JQuery

Reporting Tool

SSRS

SQL Tools

SSIS

Project Summary:

1.ODAR (Overpayment Down Adjustment and Recovery Tracking System)

Duration

February’2012 – December’2015

Team Size

12

Client

UnitedHealth Group

Description

A tool to track Overpayments of claims from Identifications to Recovery & Closure.

ODAR is an integrated web application that provides features like: Manually and automatically load detailed overpayment claims, feed information to external identification & recovery vendors through the Vendor Process Optimization process, sophisticated claims search functionality, a comprehensive accounts receivable system that can track recoveries, appeals tracking and resolution, a module for tracking actions taken against the claims through the ICM module and finally a fully automated letters process.

Technologies/ Tools

C#.NET 4.0, Design Patterns, ASP.NET, WCF, SQL Server 2008 R2, SSIS, SSRS

Responsibilities

Involved in SRS and Requirement Analysis.

As a Developer member was involved in Design and Coding.

Also involved in development of SSIS packages and SSRS reports.

Working on HPSM tickets and production issues as well.

Unit testing and Defect fixing in QAT period.

2.IMPAC/MDS/Help Desk Tickets

Duration

May’2011 – January’2012

Team Size

10

Client

Mansfield Oil, US

Description

IMPAC/MDS - SSRS Reports are to be created to provide customized data to various clients of Mansfield.

Various SSIS packages and windows services are also developed to automate schedules and jobs.

Provide Production Support for real-time issues.

Technologies/ Tools

C#.NET 3.5, ASP.NET, SQL, SSRS, SSIS

Responsibilities

Involved in SRS and Requirement Analysis.

Worked On Business Layer.

As a Developer member was involved in Design and Coding and creation of SSIS packages and SSRS reports.

Tested the application in accordance with the team members to achieve a high quality product.

3.IMB (Integrated Mail Barcode)

Duration

October’2010 – January’2012

Team Size

6

Client

Berkheimer Outsourcing, US

Description

This project is divided into two parts:

BlackBox application:

The BlackBox application is used to update the print files generated from the various Berkheimer Systems and generate Output PrintFile and Inserter spray files with the correct IMB and 2DBarCode. It will also generate and store the ACS (Address Correction service) data which will be used by the Foxtrot application in order to update the appropriate application’s database’s mailing records. Additionally it will log and report on postage details and client identifier for all print files based on the type of work being processed.

IMB Website:

It allows the admin users to create and maintain the data

needed by the BlackBox application and functionality is provided to queue

jobs for BlackBox processing and maintain it.

Technologies/ Tools

Asp.Net 3.5 (C#), Ajax, SQL 2008, JavaScript, TFS

Responsibilities

Involved in SRS and Requirement Analysis.

Worked On Business Layer.

As a Developer member was involved in Design and Coding.

Tested the application in accordance with the team members to achieve a high quality product

4.SCAR

Duration

May’2010 – November’2010

Team Size

4

Client

Remy Inc. USA

Description

The SCAR (Supplier Corrective Action & Performance Measurement) global application is a web base application, which can be accessed via the Internet through any browser software. One of the objectives for this application is to improve corrective action response times and clarify communications with the suppliers, which leads to the improvement of overall quality. Reporting functionality is also provided to the user.

Technologies/ Tools

ASP.Net 2.0 (VB.NET/ADO.NET), MS SQL Server 2005, JavaScript, VSS 6.0, Ajax, Team Foundation Server 2005

Responsibilities

Involved in SRS and Requirement Analysis.

Worked On Business Layer.

As a Developer member was involved in Design and Coding.

Tested the application to achieve a high quality product.

5.PPAP

Duration

March’2010 – October’2010

Team Size

5

Client

Remy Inc. USA

Description

The Remy PPAP (Production Part Approval Process) tracking system is a web-based system that is accessible from any internet connection worldwide. It provides a means for creating, completing, reviewing, and approving PPAP information for any supplier submission to any global Remy location. The system includes a workflow mechanism that routes individual PPAP(s) through a collaborative authoring and approval process from beginning to final PPAP status assignment and notification. It is a role-based system that presents the appropriate information to each user based on their assigned role or roles.

Technologies/ Tools

ASP.Net 2.0 (VB.NET/ADO.NET), MS SQL Server 2005, JavaScript, VSS 6.0

Responsibilities

Involved in SRS and Requirement Analysis.

Worked On Business Layer

As a Developer member was involved in Design and Coding.

Tested the application to achieve a high quality product.

6.MAISON BLANC

Duration

November’2009 – March’2010

Team Size

8

Client

Maison Blanc Restaurants, UK

Description

Maison Blanc (Bakery in UK) is a web content management system that will allow the site admin to add, update and delete content of website, to create new pages, modifying existing ones based on their roles. It has a public interface for public users to view contents of website and another for admin roles who manages the content of the website. It is also a CRMS that will capture and analyze data from the end user for the purpose of gathering feedback and business marketing. Maison Blanc was developed using DotNetNuke core framework, a free open source content management system.

Technologies/ Tools

ASP.Net 2.0 (C#), MS SQL Server 2005, DotNetNuke

Responsibilities

Understanding architecture and exploring functionality of DotNetNuke (An open source content management system).

Created and designed new modules with enhanced functionalities.

Tweaking the existing functionality of DotNetNuke to meet the business requirements.

Involved in Creation & Coding of Business Layers.

Involved in writing scripts for creation of tables, stored procedures, and functions in MS SQL server.

Tested the application to maintain the overall quality of the product.

7.PLATFORM SHORT SEA SHIPPING (PLATSSS)

Duration

August’2009 – October’2009

Team Size

4

Client

INNOVATION STRATEGIES, SPAIN

Description

PLATSSS (Platform short sea shipping) is windows cum web based application. This is a Ship Management project in which reservations are made against a particular ship that will travel over a line from source to destination. This project manages creation,

manipulation, and deletion of organizations, users of organization, profiles of users, schedules for trips, lines, reservations of trips etc. with proper permissions implemented. Understanding of SSAS packages, querying the existing cubes to fetch data (using MDX query) and show the results in tabular format.

Technologies/ Tools

Dev Express 6.3, MS SQL Server 2005, C#. NET 2.0, Web Services

Responsibilities

Understanding architecture and functionality of Dev Express 6.3 (An open source third party.net controls (toolkit)).

Created and designed new modules with enhanced functionalities.

Involved in tweaking and exploring functionality of Dev Express.

Involved in Creation & Coding of Business, UI, and Data access layers as well as Web service methods.

Involved in writing scripts for creation of tables, and various types of queries, using MS SQL server.

Tested the application to achieve a high quality product.

8.CRM

Duration

May’2009 – August’2009

Team Size

12

Client

JK Technosoft Pvt. Ltd.

Description

Customer relationship management (CRM) was implemented for managing the company’s interactions with customers, clients and sales prospects. It allows the user to organize, automate, and synchronize business processes principally sales activities, but also those for marketing, customer service, and technical support.

The salient features of CRM:

Progress database was used for the database.

Web services were used to retrieve data from the database.

Creation, Modification and Deletion of Accounts.

Creation, Modification and Deletion of Contacts.

Creation, Modification and Deletion of Tasks.

Linking of accounts with contacts and assigning of tasks.

Tracking of tasks.

Technologies/ Tools

.Net 3.5, Web Services, Progress Database.

Responsibilities

Understanding the Functionality and Scope of the Application.

Development of new modules (Accounts, Contacts and Task Management)

Tested the application to maintain the overall quality of the product.

Educational & Credentials:

Microsoft Certified Technology Specialist - .NET Framework 4, Web Applications

MCA, 2009 - Secured 83.54% from Guru Govind Singh Indraprastha University (GGSIPU), Delhi, India

BCA, 2006 - Secured 77.57% from Guru Govind Singh Indraprastha University (GGSIPU), Delhi, India

12th, 2003 - Secured 69.6% from Bal Bharti Public School, Brij Vihar, Ghaziabad, U.P. (CBSE), India

10th, 2001 - Secured 76.4% from Bal Bharti Public School, Brij Vihar, Ghaziabad, U.P. (CBSE), India

Strengths:

I have been involved in variety of assignments that enhanced my knowledge. I strongly believe in progressive designing with a different flavor of creativity in the entire project I undertake with full swing & support of my team members, so to utilize the time in the right direction with an excellent analytical, creative approach.

Strong sense of aesthetics and attention to details, highly organized and self-starter with proficient analytical skills and broader approach to achieve solutions.

Strong Hand in Analyzing, Designing and coding for the project.

Process Oriented: Always believe in automation of the routine task to get in action to put things in “process” to streamline. Strongly believes that the manpower is for creative & innovative work not for the stereotype work.

Initiative: Willing to try new ways and open to change.

Perseverance: Willing to put in additional time and effort on a given task in order to complete it in accordance with highest standards.

References: Available on request

Contact this candidate