Sql Server .Net
Resume:
Nehaa Malhotra Email: *****.********@*****.***
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