Sql Server Sales
Resume:
Ruchita Srivastava
******************@*****.***
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