Post Job Free

Resume

Sign in

Sql Server Sales

Location:
Aston, PA
Posted:
August 26, 2014

Contact this candidate

Resume:

Ruchita Srivastava

acfl6b@r.postjobfree.com

848-***-****

Summary:

* 6 years of experience in development & support of web applications

using .NET technologies in Health Care, Retail and E-Commerce

domains and 3 years of experience in Classic ASP.

* Experienced in .NET framework 4.0/3.5/2.0, ASP.NET, C#, ADO.NET, LINQ,

WCF, JQuery, JavaScript, HTML, CSS, XML and Classic ASP 3.0.

* Extensive experience in re-engineering existing ASP 3.0 applications

to Microsoft .Net (C#).

* Experienced in using Entity Framework 4.1/5.0 Code first and Microsoft

Enterprise Library.

* Experienced in Software Development Life Cycle (SDLC), Unit Testing

using NUnit of web based applications.

* Experience in OOPS in C# and VB.Net in Web Applications.

* Experienced in Service Oriented Architecture (SOA).

* Experienced in writing Stored Procedures, Functions in Oracle 9i/10g &

SQL Server 2005/2008.

* Used the Agile/Scrum methodology to manage a rapid development

schedule.

* Managed end-to-end deployment starting from requirements gathering,

scoping, development, support tools and monitoring, and end user

support.

Technical skills:

Languages C#

Web Technologies ASP.NET 2.0/3.5, ADO.NET, Classic ASP 3.0, XML, HTML.

Distributed WCF, Web services .

Technologies

Libraries/ORM Entity Framework 4.1/5.0, Microsoft Enterprise Library.

Databases MS SQL SERVER 2005/2008/2008R2, ORACLE 8i/9i/10g.

Scripting JavaScript, VBScript, JQuery

Language

GUI/ IDE Visual Studio 2003/2005/2008/2010, Microsoft SQL Server

Management Studio TOAD and SQL Plus.

Version controls Visual source safe (VSS), Tortoise SVN, IBM Rational

Synergy

EDUCATION:

. Master of Computer Application - North Maharashtra University - India

[2004]

Professional Experience:

Employer: Abbott Laboratories (R & D) - Princeton, New Jersey

Project - Abbott Configuration Manager.

Duration - Feb 2012- Till date

Role - Engineer II

A configuration manager to facilitate the use of the i-STAT Handheld in a

point of care testing environment where the primary data management

capabilities are provided through the divisional data manager and/or other

third party vendors' data management packages. The configuration manager is

capable of running in a centralized hosted environment. ACM Project

provides a software system solution that:

Supports customization for device.

Facilitates software updates for i-STAT only

Facilitates internationalization of the i-STAT System

Responsibilities:

. Analyzed Business Requirements and segregated them into technical design

documents.

. Data Access Layer development using C#, Entity Framework 5.0 Code

first, LINQ to SQL, LINQ to XML.

. Created Business Entities using Class Library in C#.

. Using Log4Net 1.2.9.0 for Error Logging in application.

. Implemented Caching using AppFabric caching.

. Created Stored Procedures and User defined functions in SQL Server

2008R2.

. Using NUnit and RhinoMocks for Unit Testing.

. Created Wireframes in UI using Balsamiq mockup tool.

. Prepared test protocols & held peer review sessions.

. Using scrum methodology to manage a development schedule.

. Managing support activities for users during UAT.

. Created Automated Nighty build using CruiseControl.Net

. Worked according to project plan for the development releases.

Environment: ASP.NET, C#, Microsoft Visual Studio 2010 with .NET Framework

4.0, Entity Framework 4.1/5.0 Code First,

LINQ to SQL, LINQ to XML, NUnit, Mocks,

CruiseControl.Net.

Employer - Orion Systems Integrators Inc. - New Jersey

Project - Retail Construction Cost Sheet

Client - Coach Inc, NYC, NY

Duration - May 2011- Jan 2012

Role - .Net Developer

The objective of this project is to convert multiple excel spreadsheets

used to keep track of all store construction to a web based online system.

The online version allows centralized management of cost structure and

provides an overview across all projects. The new version will also allow

data to be backed up and provide multiple access levels to distinguish

between users and administrators.

The web-based application that mimics the functionalities of the current

excel file which include the main cost sheet, GC bid sheet, SBO Take off

sheet, backend data entry, cost summary, formula & freight data entry,

General Contractor Payment schedule, Millwork payment schedule (Asian and

Domestic), Loose fixtures schedule, Project checklist, PSF, and Change

Order Report. In addition, build a summary view of the Cost Sheet across

all projects.

The SBO Take off is project specific detailing what each stores will need

in term of tangible fixtures. The data sheet and formula & freight are

universal across all projects, however, they need to be date sensitive as

once a project is locked, the prices are fixed and should not be affected

by any further changes.

Responsibilities:

. Facilitated meetings with IT managers from the client side to manage

site-specific development expectations and deliverables.

. Analyzed Business Requirements and segregated them into technical design

documents.

. Front End UI development using ASP.Net 4.0, Web Forms and JQuery

. Created Business Entities using Class Library in C#.

. Created Data Access Layer using Data Application blocks of Microsoft

Enterprise Library 5.0

. Developed re-usable User Controls for multiple purposes.

. Used Infragistic controls for complex GridView functionality.

. Used Log4Net 1.2.9.0 for Error Logging in application.

. Implemented Data Caching using SQLCacheDependency.

. Created Stored Procedures, User defined functions and Inline functions

in SQL Server 2008.

. Created and scheduled SQL Jobs using SQL Server Agent.

. Prepared test cases & held peer review sessions.

. Used the Agile methodology to manage a rapid development schedule.

. Managing support activities for users during UAT.

. Worked according to project plan for the development releases.

Environment: ASP.NET, C#, Microsoft Visual Studio 2010 with .NET Framework

4.0, JQuery, ADO.NET, Microsoft Enterprise Library 5.0, Log4Net 1.2.9.0,

SQL Server 2008, T-SQL, IIS 7, VSS, Agile Methodology

Employer - Orion Systems Integrators Inc. - New Jersey

Project - UltiPro .Net Upgrade

Client - Coach Inc, NYC, NY

Duration - Jan 2011- April 2011

Role - .Net Developer

This interface is used by the HR Payroll group to calculate fixed, variable

benefits & deductions of employees. Using this interface

Users run the SQL jobs as per requirement, process the payroll and generate

output files. The output files are exported to internal groups and third

party vendors like Aetna, Fidelity, MetLife, Ceridian, Delta Dental in PA,

TALX on hourly, daily and weekly basis and processes the inbound files

which come to the HR Payroll. Coach Inc. uses this interface for its

employees in US, Canada, China, Japan, Europe and India.

Responsibilities:

. Analysis of the business processes of various vendors like TALX,

Fidelity, Metlife, Aetna and Ceridian .

. Conducted sessions/polls with the client to collect and validate the

business requirements and gain consensus of various internal groups.

. Analyzed Business Requirements and segregated them into high level and

low level Requirement documents.

. Front End UI development using ASP.Net 4.0, Web Forms, JavaScript and

AJAX tool kit controls like Autocomplete extender, Calender and Tab.

. Created Business Entities using Class Library in C#.

. Created Data Access Layer using Data Application blocks of Microsoft

Enterprise Library 5.0

. Developed re-usable User Controls for multiple purposes.

. Created reusable WCF Services.

. Implemented SOA Architecture in Application.

. Used Log4Net 1.2.9.0 for Error Logging in application.

. Implemented Data Caching and using SQLCacheDependency.

. Created Stored Procedures, User defined functions and Inline functions

in SQL Server 2008.

. Used BCP utility for Bulk upload in the export output files (.csv,

txt, .xls) in SQL Server 2008.

. Created and scheduled SQL Jobs using SQL Server Agent.

. Worked on Ultipro tool for HR Payroll

. Prepared test cases & held peer review sessions.

. Used the Agile methodology to manage a rapid development schedule.

. Managing support activities for users during UAT.

. Worked according to project plan for the development releases.

. Troubleshooting existing bugs in legacy application.

Environment: ASP.NET, C#, Microsoft Visual Studio 2010 with .NET Framework

4.0, Javascript, AJAX Control Tool Kit, WCF, SOA, ADO.NET, Microsoft

Enterprise Library 5.0, Log4Net 1.2.9.0, XML, SQL Server 2008, T-SQL, IIS

7, VSS, Agile Methodology.

Employer - Orion Systems Integrators Inc. - New Jersey

Project - eAudIT & KPMG Single Audit Tool (KSAT)

Client: KPMG LLP, Montvale, New Jersey

Duration: June 2010- Dec 2010

eAudIT

.Net Developer

KPMG provides audit, tax and advisory services and industry insight to help

organizations to negotiate risks and perform in the dynamic and challenging

environments. eAudIT, an enterprise solution to implement the audit and

advisory methodology and helps to maintain quality of audits with industry

standards and compliances. eAudIT balances prescriptive screen-driven data

entry with the more familiar forms/document-driven data entry using

InfoPath form to achieve its requirements and to support electronic

workflows, Electronic reviews, real time connectivity/ Synchronization and

team management

KPMG/Single Audit Tool (KSAT) assists compliance assurance group in KPMG to

determine major programs and related compliance requirements are in

accordance with compliance rules, audits of states, local governments and

Non-Profit Organizations. It also assists in meeting the documentation

requirements of the different compliance circulars.

Responsibilities:

. Participated in the complete SDLC of the project.

. Front End UI development using ASP.Net, JavaScript, JQuery and

AJAX. Used Ajax Tool kit for UI development.

. Extensively worked on Web form in ASP.Net

. Created Data Access Layer using ADO.Net and Microsoft Enterprise

Library 5.0

. Created Business Entities using Class Library in C#.

. Implemented SOA Architecture in Application by creating WCF

services in the application.

. Used Log4Net 1.2.9.0 for Logging in application.

. Implemented Fragment Caching for User Controls and Data Caching.

. Created backend Stored Procedures, UDF in SQL Server 2008.

. Prepared test cases and tracked the status of execution of test

cases & held peer review sessions.

. Implemented SOA Architecture in Application.

. Used the Agile methodology to manage a rapid development schedule.

. Support to users during UAT phase.

. Worked according to project plan for the development and

enhancement releases.

Environment: ASP.NET, C#, Microsoft Visual Studio 2008 with .NET Framework

3.5, Javascript, JQuery AJAX Control Tool Kit, CSS WCF, SOA, ADO.NET,

Microsoft Enterprise Library 5.0, Log4Net 1.2.9.0, SQL Server 2008, T-SQL,

IIS 7, VSS, N-Unit, Agile Methodology.

Employer - NCR Corporation India Pvt Ltd, Gurgaon, India

Client - NCR Corporation, Dayton, OH, US

Duration - Oct 2006 - Jan 2010

Role - Senior .Net Developer

NCR Import Management System [LITE] & NCR Custom Import Export

Compliance[CIEC]

Project Details:

NCR Import Management System (NIMS) Lite application is used by import

brokers (DHL, UPS and Fedex) who partner with the Import Compliance group

at NCR. They use the application to manage the NCR parts information,

Generate Invoice and send Invoices of part for approval to NCR Compliance

group. They can check the shipping status of the part through this

application. Import files come to NCR and export files goes to UPS, DHL

and Fedex. These files contains feed of the part. They use this application

to lookup NCR parts information to determine if a part exists in the NCR

NIMS database. If the part does not exist then the NIMS Parts

Classification tool is used to associate the new part with a tariff code.

The tariff codes enable U.S. Customs to track imported parts from foreign

countries. NIMS Lite also allows the brokers to create/view summary

invoices through a form or via CSV file. Summary invoices are a way for

the brokers to group multiple invoices into a single invoice.

The CIEC module of the system is used by Import Compliance group at NCR.

They use this application to lookup NCR parts information to determine if

part exists in the NCR NIMS database. Import Compliance Group approves

Invoices and send to ERP for billing process. After approval data can not

be modified and data automatically gets updated in the above NIMS LITE

system.

NCR Application Tracking System

Project Details:

Through this product NCR keep track of its Customer Applications. Every

user has unique tracking number so that they can track the status of their

applications. User can also track the status of his Job Application.

Application contain Data of all the Customer queries and customer's

applications. This application has two interfaces one for external

customers of NCR and another for NCR. Both can track the application status

but only NCR can update the status of Queries and application and after

completion Queries can be deleted. Data and queries come through Import

files from different groups.

Environment: .Net 3.5, ASP.Net 3.5/2.0, C#, JQuery,Javascript,ASP.Net

AJAX,, LINQ, Web Service, WCF, ADO.Net, T-SQL SQL Server 2000/2005, SVN,

MVC design pattern, Microsoft Enterprise Library 4.1, Log4Net., VB.Net,

ASP 3.0, VB 6.0, Java Script, VB Script, Oracle 10g, PL/SQL, VSS 6.0, TOAD

Employer: MarketRx India Pvt Ltd. - Gurgaon, India

Project: iBridge

Client: Top Pharamaceutical Companies in the US like Johnson&Johnson,

Novartis and Astrazeneca

Duration: May 2006 - Oct 2006

Role: .Net Developer

Project Details:

This product allows the users in pharamaceutical companies analytic

solution for sales and marketing of their product. It is a analytical tool

for determining sales force strategy like sales force size and structure.

Sales department uses this product for data analytics to analyze the sales

data like in which area more sales men are required, which area has more

scope of sales etc.

Environment: .Net 2.0, ASP.Net, C#, AJAX, Classic ASP, VBScript, Java

Script, Oracle 9i, PL/SQL, VSS

Employer: Himachal Futuristic Communication Ltd (R & D) - Gurgaon, India

Project: Automated Spectrum Management System

Clinet: Ministry of Communication, Government of India, India

Duration: July 2004 - May 2006

Role: .Net Developer

Project Details:

Through this project Applicant(Mobile Companies,AIR,DD) can apply for

Frequency license to Wireless planning and Coordination Wing (Ministry of

Communicaton). ASMS aims to automate the entire working of WPC, involving

the issuance of all kinds of licenses for different types of operators who

use the spectrum,assignment of frequency,site clearance,billing,monitoring

and managing the entire Indian Spectrum and Keeping in co-odination with

various international bodies of Spectrum management.ASMS would be used to

assign frequencies in Spectrum co-ordinating with the Licensing Record

Section. New Technology Group, Extended Technology Group and all other

concerned department of WPC.

Environment: Classic ASP 3.0, Java Script, HTML, CSS, Oracle 9i, PL/SQL,

VSS

Work Authorization : H1B visa



Contact this candidate