Project Sql Server
Resume:
D ipti Nagare
*****.******@*****.***
SUMMARY
• 9+ years of experience in software development as a Microsoft Application Developer
• Good work experience in Design, Development and Implementation of Web, Client/Server and
Windows applications.
• Excellent working knowledge on ASP.NET 1.x/2.0/3.x/4.0, ADO.NET, C#, Visual Studio 2003,
2005, 2008, 2010, SharePoint 2010, InfoPath
• Experience in the complete Software development life cycle: Requirement gathering, System
Analysis & Design, Development, Testing, Deployment, End User Training and Documentation
• Experience developing SSIS package using BIDS
• Experience with major databases such as SQL Server 2000/05/08, Oracle
• Efficiently worked on version controlling system like VSS.
• Good knowledge on Design patterns like MVC, Singleton, MVP
• Good understanding of Object Oriented Design (OOD) methodologies.
• Self-motivated Individual with excellent problem solving, written and oral communication skills
and have ability to work individually and in team environment.
• Ability to quickly learn new technology and adapt to new environments.
TECHNICAL SKILLS
Languages C#, ASP.Net, VB, ASP, PHP
Web Technologies IIS 7/2005, SharePoint Server 2003,2010, InfoPath, JavaScript, JQuery
Frameworks .net 1.x/2.0/3.x/4.0
SOA Web Services (SOAP, WSDL), WCF
IDEs Visual Studio 2008/10, BIDS
Version Control VSS
Databases SQL Server 2008/05/10, Oracle and MySQL
Operating Systems Windows
EDUCATION & CERTIFICATION
• Bachelor of Engineering in Computer Science, India
• Microsoft Certified Technology Specialist (MCTS)
PROFESSIONAL EXPERIENCE
Cognizant Technology Solutions July 2007 – July 2013
Senior Associate
Client: Nestle USA, Glendale, CA
Project: Nusa OS&D Tool (Oct 2012 – Jul 2013)
The purpose of this project was to build an OS&D website for all the OS&D user groups (OS&D central,
Customer Service, Inventory Control, and NDC/3PL) to raise and track the claims. The new web based
application helped to divide the claim administration activities as per group and set the claim workflow
based on the OS&D type. This new approach provided greater claim visibility, better management and
control over the claims.
Roles and Responsibilities:
• Prepared SOW and involved in requirement gathering, architecture level design and
estimation of work
• Document HLD’s and business requirements and developed Prototype
• Developed SSIS packages to load data feed from SAP into SQL database
• Developed crystal report to display certificate of destruction and freight claim reports
• Developed and executed Unit test cases and system test cases
• Implemented functions, stored procedures, user defined tables on SQL server
• Monitor project progress and performance, kept track of risks, SCM document, Status
reports, RCA document and defect tracking using cognizant tool
• Ensure quality of all deliverables and attend audit for project delivery
• Involved in configuration and deployment of application
• Provided production support and developed enhancements as support activities
ENVIRONMENT: ASP.net 3.5, Ajax, JavaScript, JQuery, SQL Server 2008, SSIS, VS 2008
Client: Nestle USA, Glendale, CA
Project: E-HR SharePoint migration (Jul 2012 – Dec 2012)
As part of this project 3 existing .net applications were developed in SharePoint 2010 and InfoPath
forms. This included below 3 applications:
BEQ- Business ethics Questionnaire
I.
Lobbying Disclosure
I I.
180 Feed Up
I I I.
Roles and Responsibilities:
• Communicate with CMP team and give them complete understanding of existing applications
• Developed InfoPath forms, custom webpart, workflows and migration scripts
• Deployed SharePoint site, InfoPath forms, web parts to client server and performed system
testing on client server
• Bug fixing, production support and executed migration scripts on production server
• Performance tuning for execution of InfoPath forms
• Ensure quality of all deliverables and attend audit for project delivery
ENVIRONMENT: SharePoint 2010, InfoPath Form, SharePoint Designer, ASP.net 3.5, Ajax, JavaScript,
JQuery, SQL Server 2010, VS 2010
Client: Nestle USA, Glendale, CA
Project: E-HR Identity Management (Apr 2012 – Dec 2012)
Through this project, it was desired to identify the recurring issues with e-HR application in order to design
a permanent solution leading to a secure yet user friendly environment for Nestle USA employees.
Roles and Responsibilities:
• Worked on WCF, DB Encryption using transparent data encryption (TDE)
• Prepared screen for rule creation for user access to the application
• Monitor project progress, quality of all deliverables and performance
ENVIRONMENT: ASP.net 3.5/4.0, Ajax, JavaScript, SQL Server 2008, SSIS, VS 2010
Client: Nestle USA, Glendale, CA
Project: Export trade tool (Nov 2011 – Mar 2012)
This project was to build a web application customized as per EMD International business needs to
manage their Pricing, Trade Funds and Accruals. The key objective of this project was to build a robust
tool that will help the EMD International to:
Effectively manage Material Pricing and manage trade funds
I.
Manage trade accruals and Payments
I I.
Provide views to generate Reports
I I I.
Roles and Responsibilities:
• Complete development of the project using waterfall model
• Created SSIS packages for nightly jobs and Performance tuning of SSIS packages
• Created screen having nested grids and mass data upload features
• Autosuggest search functionalities were implemented using JavaScript
• Monitor project progress, performance and ensure quality of all deliverables
ENVIRONMENT: ASP.net 2.0, Ajax, JavaScript, SQL Server 2008, SSIS, VS 2008, BIDS
Client: Nestle USA, Glendale, CA
Project: Innovation Tool (Jan 2011 – Oct 2011)
Innovation tool was developed for the core Acquisition team members and Stream leads in NUSA
Division, Nestlé USA. This tool primarily enabled the core Acquisition team members and Stream leads to
generate IT project integration costs (as per GLOBE template) through the various phases in the life-cycle
of a typical acquisition
Roles and Responsibilities:
• Prepared deck and provided KT sessions to the Nestle Business teams
• Created SSIS packages and dynamic Excel template for One time data load in the tool
• Provided support to the tool and incorporated enhancements as per clients request
• Performance tuning of Gantt chart report
• Monitor project progress, performance and ensure quality of all deliverables
ENVIRONMENT: ASP.net 2.0, Ajax, JavaScript, SQL Server 2008, SSIS, VS 2008, BIDS
Client: Nestle USA, Glendale, CA
Project: Labor Performance Reporting (Oct 2010 – Jan 2011)
Labor Performance Reporting is a performance based labor tracking system. It generates reports based
on historical information out of a centralized database. Finance team uses LPR to compare budgeted
amounts vs. actual. Data that is generated out of LPR is used to analyze factory performance.
Roles and Responsibilities:
• Development of UI
• Development of stored procedures using SQL
• Monitor project progress, performance and attend audit for project delivery
• Production support to client
ENVIRONMENT: ASP.net 2.0, Ajax, JavaScript, SQL Server 2008, SSIS, VS 2008
Client: Nestle USA, Glendale, CA
Project: CM2 (Jul 2010 – Sep 2010)
In CM2 project the main goal was to get rid of VPN connection that agencies are using to integrate with
CM2 Nestle staging environment. This was to be done without making any code changes on the websites
consumed by the CM2 system currently.
Roles and Responsibilities:
• Create the web service to get rid of VPN
• Coordinate with the onsite team to get the requirements
• Help the onsite to understand and deploy the new web service
ENVIRONMENT: ASP.net 2.0, Ajax, JavaScript, SQL Server 2008, SSIS, VS 2008
Client: Nestle USA, Oakland, CA
Project: Dreyers FPSUI Development (Feb 2010 – Jun 2010)
Finite Production Scheduling project is an application that stores key data along with facilitating user-
interaction with the stored data. In addition to the input data, data that is produced by PPO is stored and
archived. It is more than just a database that stores data; FPS is an application that has a user-interface,
with user privileges as well as basic form/data entry validation.
Roles and Responsibilities:
• Involved in the development and implementation of the entire application.
• Monitor project progress and performance
ENVIRONMENT: ASP.net 1.0, Ajax, JavaScript, SQL Server 2000, SSIS, VS 2003
Client: P2 Energy Solutions, Houston, TX
Project: P2ES (Jul 2007 – Jan 2010)
P2 Energy Solutions is the oil and gas sector's largest owner and provider of enterprise solutions
encompassing financial and operational software, implementation, integration and outsourcing services,
mapping data and storage systems.
Roles and Responsibilities:
• Coordinate with Cognizant on-site team for escalation and/or resolution of technical issues
• Develop modules using MVP pattern, VSTS 2008
• Ensure quality of all deliverables and manage C2 and attend audit for project delivery
• Manage Bug fixing Team
ENVIRONMENT: ASP.net 1.0, JavaScript, SQL Server 2000, VSTS 2003
Nucsoft Ltd, UK May 2007 – July 2007
Sr. Developer
Client: CTN Communications, UK
Project: Mangroupplc.com (May 2007 – Jul 2007)
The Man Group plc Corporate is a multi-functional, Content Management System, which will allow easy
site, updates and management through both content and imagery updates. The CMS developed allows
additional pages to be easily incorporated into the site. In addition, any external links or standalone
functionality throughout the site are also built within the CMS to allow simple updates to occur.
Roles and Responsibilities:
• Created CMS for whole site
• Involved in development of all admin side pages containing CMS
• Created different types of templates
ENVIRONMENT: ASP.net 1.1, JavaScript, VS 2003, SQL Server 2000
Nucsoft Ltd Jan 2006 – Apr 2007
Team Lead
Project: Faces4Singles.com
Faces4Singles is a worldwide dating and matrimonial site. In this members can contact each other and
send private messages. Also, members can upload photos with password protected.
Roles and Responsibilities:
• Involved in the development and implementation of the entire system.
• Worked with the database using ADO.NET class libraries.
• Implemented a 3-tier architecture system clearly separating the business logic from
presentation layer.
ENVIRONMENT: ASP.net 1.1, JavaScript, VS 2003, SQL Server 2000, MySQL
Emaginationz Solution Pvt Ltd Sep 2004 – Dec 2005
Developer
Developed various E-Commerce websites using ASP, PHP, SQL Server 2000
Computree InfoTech Ltd Sep 2003 – Aug 2004
Developer
Project: Jewelsonfire.com
This project's main objective was to provide utilities to the user to view select and purchase the jewelry
online. The payments for all the purchases are made through a secure payment gateway. There was also
an advanced search for a user to get the filtered output
Roles and Responsibilities:
• Involved in the complete Software Development Life Cycle (SDLC) of the project
• Understanding of overall project, design of database, analyzing, designing and developing
ENVIRONMENT: VB, ASP, SQL Server 2000, VSS, IIS 6.0
Contact this candidate