Project Sql Server

Mamta Gakkhar Trehan ************@*****.***

***** ********* **. 408-***-****(M)

Cupertino, CA 95014 408-***-****(H)

Professional Summary:

• Over 7 years of professional experience in all stages of the SDLC (Software Development Life Cycle)

involving studying of the user requirements, analyzing, designing, implementation, testing, deployment,

documentation of project development and management.

• Experience in Sharepoint Server 2010/2007(Configuring Webparts,Features,Web Content

Management,Service Applications,Workflows),Infopath 2010,Sharepoint Designer 2010.Involved

in development for Sharepoint 2007/2010.Created Webparts,Features,Farm Solutions,Event

Handling,Workflows In Sharepoint 2010 in Sharepoint Designer and Visual Studio 2010.Worked

in Powershell Scripts.Created Site Collections/Subsites/Managing Document

Libraries/Lists.Experience in Querying Lists using CAML and Linq.Used SP Metal.exe to create

the Entities in VS2010.Created Application pages/Customize Master pages for Sharepoint sites.

• Experience in latest Microsoft technologies like WCF, ASP.NET and LINQ.

Worked and created REST based services as well as SOAP based services.

•

Good experience in 3 tier architecture.

•

Very good hands on experience with data access technologies like LINQ to SQL, ODBC, OLEDB,

•

ADO and ADO.NET.

• Proficient in Web Services creation, testing (WSDL, SOAP), discovering (DISCO), remote and

security.

• Good Team Player with excellent communication, analytical, verbal and writing skills along with strong

management, organizational and mentoring skills.

Technical Skills:

Languages: C#, LINQ, ASP.Net, MVC 2.0/3.0,WCF,REST,Visual Basic 6.0, Shell Scripting

Web Development ASP.NET 4.0/3.5/2.0, AJAX, JavaScript, JQuery,HTML,CSS, XML;

Technologies WCF, XML Web Services, ADO.NET,SharePoint Server Side Object Model

Development Visual Studio 2010/ 2008/2003, Visual Source Safe 6.0

Tools/IDE

RDBMS/Data SQL Server 2000/2005/2008, Oracle 8.0/9i,Microsoft Access 2003, DB2 8.0/9/0

Management

Operating Microsoft Windows 2000 Advanced Server/ 2003 Server/Professional/XP/9x/NT, Unix 6.0, IIS

Systems/Servers 5.0/6.0

Portals/Case tools SharePoint Server/Foundation 2010, Microsoft Visio 2003/2007

Development Agile/Scrum, Test Driven Development, Waterfall methodology.

Methodologies

Certifications:

Microsoft Office Specialist for Sharepoint 2010

Microsoft Office Specialist Certified

Cisco Network Academy Cisco Network Administrator Certification

PR 101 .Net Foundation Certification, PR 201 .Net Basic

Internal Certification to Infosys

Programming Certification, PR 301 .Net Advance

Programming

rofessional Experience

P :

Designation:Sharepoint Developer

Nov 2012 Till,Federal Reserve Bank of San Francisco,San Francisco (CA)

Designation:Senior Software Engineer

Feb 2010 Mar 2012,Triton Tek Business Solutions Mohali (India)

Designation:Senior Software Engineer

May 2006 Jan 2010,Infosys Technologies Ltd,Bangalore

Designation: Product Developer

Dec 2004 – May 2006, Opelin Laboratories Pvt. Ltd. New Delhi (Acquired by Hewlett Packard Packard in Feb

2008)

Designation: Technical Support Engineer

Jan 2004 Nov 2004, IBM Daksh. Gurgaon

Designation: Research Associate

Jul 2003 – Dec 2003, Corporate Catalysts.New Delhi

Project: Intranet Applications for Business Users

Project Duration:Nov 19 2012 Till

Client: Fedral Reserve Bank of San Francisco

Implementation of Excel plug in to upload the contacts data associated with events to database and shows the

data on intranet site for business users to manage/create/update/delete the data.

Responsibilities:

• Gathered Requirements from the Business users and worked with them to set the

specification and design of the application.

• Create and maintain functional specifications (Use case diagrams and Class diagrams).

• Creation of External Content types using Business Connectivity Model.

• Managing the Service Applications in Central Administration in SharePoint 2010.

• Customizing the view of external list based on user requirements using Javascript and

XSLTListViewWebpart.

• Creation of Sandboxed Solution for Business Users giving them an opportunity to deploy on

their site to view all the site content types/list content types/list column and site content types

publish from InfoPath forms.

• Created Mock ups for internal application using Axure RP 6.5

• Configured Reporting Services for Web application in Central Administration.

• Created Reports using SQL Server Report Builder 3.0

• Created Infopath form using Microsoft Infopath 2010 and published in Sharepoint library.

• Created sandboxed solution using Sandboxed Visual Webpart,Custom Action in VS2010.

Environment: JQuery, Javascript,Visual studio 2010, WCF, SQL Server 2008,HTML,CSS,Entity

Framework,Sharepoint Server 2010,Sharepoint Designer, Business Connectivity Service Model,Axure RP

6.5,Microsoft Infopath Designer 2010,Sharepoint Manager.

Project: TZ Cloud bridge

Project Duration:Oct 2011 Feb 2012

Client: TZ Chicago, Illinois

Implementation of cloud bridge project which works on microcontroller. Because microcontroller hardware has

very less memory so complete solution was built using JQuery and AJAX was used. It is a web app to manage

locks installed at data centers. Locks have Ethernet port the one end so site user can pass instructions to the

locks using a unique identification number over the internet. It also reads status of temperature

and humidity sensors embed on the locks and pass instructions accordingly

Responsibilities:

Gathered Requirements from the Business analyst and worked with them to set the

•

specification and design of the application.

• Create and maintain functional specifications (Use case diagrams and Class diagrams).

• Designed and Developed Html pages using HTML controls for developing the front end

application using Visual Studio 2010 and developed CSS.

• Created Windows Communication foundation (WCF) Services using REST Architectural

Design Pattern using VS.Net 2010 and Consumed WCF Services from ASP.Net web applications.

• Created View and Domain entities using Object Relational Mapping techniques with

LINQ to SQL.

• Writing AJAX calls to microcontroller layer.

• Implementation of JQGrid in various scripts.

• Making common layer for AJAX based operations.

• Created Stubs so that AJAX calls should return data from Stub layer instead of actual

hardware.

• Implementation of Repository Pattern.

• Perform version controlling using Microsoft Team Foundation Server (TFS).

• Designed application using MVC kind of model where scripts files are separated from HTML.

• Used some part of backbone like backbone collections.

Environment: JQuery, JQGRID plugin, Visual studio 2010, WCF, REST,SQL Server

2008,HTML,CSS,ORM(LINQ to SQL),Windows Server 2003,LINQ Data Source, JavaScript.

Project: RGConsultants (www.rgconsultant.net)

Project Duration: May 2011 Sept 2011

Client: R&G Consultants Chicago, Illinois

Client provides support and services to local education agencies.They have pioneered the Mediciad Billing Fee

for Service Programs in Illinois.

Responsibilities:

• Worked as Team Lead with 3 member team.

• Maintained project documentation as per CMMi 3 methodologies.

• Actively participated in conversion of High Level Requirement (HLR) into Detail Level

Requirement (DLR).

• Participated in writing use case specification document

• Involved in interaction with business analyst in requirement tracking and implementing.

• Involved in development cycle including high level design, data design, coding, testing, and

creation of functional documentation.

• Write tables, views, stored procedure objects in T SQL for SQL Server 20058 database

• Implementation of Telerik Grid Control to display data in Views.

• Created Web Based Fee Service in WCF.

• Creation of View Models and usage of Repository Pattern.

• N Unit and Microsoft .Net testing framework is used for testing the project solutions to deal

with all the test cases

Environment:Visual Studio 2008,ASP.Net MVC2.0,Linq,C#,SqlServer 2008,Unity Application Block,WCF.

Project: Saint Vincent Website(

http://www.saintvincent in.org/

)

Project Duration: Dec 2010 April 2011

Client:Saint Vincent

This project was static website earlier mostly build in html. I moved this website to Sharepoint 2007 and I had

to override Sharepoint default menuprovider.

Responsibilities:

Creation of master pages.

•

Creation of share point pages.

•

Creation of Web part and user control using ASP.Net 3.5

•

Deployment of packages for client demos.

•

Project: Bosch

Project Duration: Feb 2010 Nov 2010

Client:Bosch United States

In this project we need to create one subsite for bosch. We had to develop various web parts which talks to

Bosch ASP.NET web services and fetch product details. Then we hosted these webparts in the Share point

pages.

Responsibilities:

• Develop Web parts as per requirement.

• Deploying Webparts in the Sharepoint.

• Creating Sharepoint pages.

Project: GAPCIORP

Project Duration: July 2009 Dec 2009

Client: GAP San Francisco

Reporting Tools like 3month3years,ARRT and Project ONE used by the client for the generation of various

reports based on the requirement. Reports generated from these tools provide the information about the

forecasting, product details in different categories like clothing, apparel etc.

Responsibilities:

Involved in development of applications and unit testing of 3month3year reporting tool.

•

Created forms in Visual Basic 6.0 and wrote Queries and Stored Procedures inMicrosoft

•

Access 2003.

• Involved in writing formulas in MS Excel 2003 for 3month3year Reporting tool.

Involved in development of applications for ARRT(Act Receipt Roll up Tool).

•

Report Generation of ProjectOne Reporting tool by creating the forms in Visual Basic 6.0.

•

Involved in the System documentation of 3month3year tool and created flow diagrams

•

in MS VISIO.

Environment: Visual Basic 6.0, MS Excel 2003,MS Access 2003 and Microsoft Visio 2007,Windows 2003

Server.

Project: Internal portal for Infosys’s GAP Account

Project Duration:Jan 2009 June 2009

Client:Infosys Bangalore

GAP Academy website is being used for the internal purposes for GAP Account to maintain the information

related to all the projects in GAP, latest updates in the Accounts, Directory Structure for placing important

documents and Content Management.

Responsibilities:

• Involved in maintenance and general administration of the portal.

• Developed Web pages using Web Parts in the portal and new websites throughMicrosoft

Office Share Point Server (2007).

• Involved in updating the web pages by editing the web parts with the latest information about

the various accounts on the portal.

• Involved in Knowledge Management on the portal by uploading the various documents

related to each account and maintaining the directory structure and creation of new users and

providing each users permissions to access the directories based on their Roles.

• System Documentation about the GAP Portal by creating flow charts using MS Visio.

Environment: Microsoft Office Share Point Server 2007,SQL Server 2005

Project: Waitrose Deliver

Project Duration: April 2008 Nov 2008

Client: John Lewis (London)

I worked at the client location for 8 months in London. The John Lewis Partnership acquired Waitrose and

opened first Waitrose supermarket in 1955.Waitrose has an E commerce Waitrose Deliver Website. This

website is used by customers to do online shopping in Waitrose stores across UK.Project was to do the

maintenance, administration and production support for the Waitrose website

Responsibilities:

• Maintenance, administration and production support of E Commerce Website Waitrose

Deliver. Solving tickets in production support.

• Involved in enhancement and development of Unix scripts for the websites of their batch

processess run overnight.

• Involved in replacement of one of their servers by updating the scripts and infrastructure.

• Deployed SSL certificates on their website.

• Involved in Knowledge Transfers to the new people joining the team and did

documentation for the newly added scripts.

Environment: UNIX 6.0, Web Sphere, Shell Scripting (K shell), DB2 8.0/ 9.0.

Project: Customer Data Support

Project Duration: Sept2007 March 2008

Client: Boots plc. (Nottingham)

I worked at the client location for 5 months in Nottingham and 3 months in Infosys (Bangalore). Boots has

centralized database CDAS (Customers Data Analytical System) for their Stores in UK.All the information

about the boots products buy, sold and inventory management is managed in this database

Responsibilities:

• Involved during initial transition of project at onsite for the Production Support

Of CDAS (Customer Data Analytical System) Central Repository of Boots for their Store Data.

• Development of various applications in Unix Shell scripting and solving the tickets in

production supports.

• Added new functionality to the existing projects of boots and development new scripts for the

automation of the projects which was earlier done manually.

• Involved in Knowledge Transfers to the team at offshore (Infosys Bangalore) during

transition phase.

• Involved in the yearly activity of Boots (Campaign Management) by extracting the data

about their active customers and creation of the promotional codes for them by running the

scripts.

• Leading the team of 4 at offshore.

Environment: Unix 6.0, Shell Scripting (K shell), DB2 8.0, Visual Basic 6.0

Project: Storeline

Project Duration: Jan 2007 Aug 2007

Client: Tesco,HSC Bangalore (India)

I worked at the client location for 6 months. Tesco is a biggest retailer of UK in grocery and general

merchandising .They have store across UK,Asia and North America.

Responsibilities:

• Involved in System Testing for (Front end and Back End) Applications

• Involved in Writing Test Scripts for System Testing and Integration Testing

Reviewed the Test Scripts and managed the folder structure in Visual Source Safe.

•

Involved in Build and Deployment of code of client servers.

•

Environment: Visual Basic 6.0,SQL Server 2000,Visual Source Safe 6.0

Project: SWB Cap I

Project Duration: May 2006 Jan 2007

Client: Ericsson (Sweden)

Ericsson is a leading mobile company in Europe. The project was to develop an intranet website for the client

where client has access to detailed information about the products, search for the products, Inventory

management and information about their suppliers.

Responsibilities:

Involved in 3 tier structure of the project by writing the presentation, business and data

•

access layer.

• Involved in Unit and System testing and created use cases and test scripts.

• Responsible for writing the System documentation for the phase 2 of the project.

• Created Store Procedures and Queries in Oracle 9i.

• Involved in creation of XML Web Services for the project.

• Developed Asp.net 2.0 web controls, user and custom controls in C#.

• Created tables, functions, stored procedures using PL/SQL in Oracle 9i

• Performed version controlling using Visual Source Safe.

Environment: ASP.Net 2.0, Oracle 9i,Visual Source Safe (VSS) 6.0.,Visual Studio 2005

EDUCATION

B Tech in Computer Science and IT (Aggregate: 72%)

1999– 2003 M.I.M.I.T. (Under Punjab Technical Univ.) Malout, Punjab

Senior Secondary School Examination, Punjab School Education Board, (PCM: 80%)

1999 DAV College (Abohar, Punjab)

School Certificate Examination, Central Board of Secondary Education Board,

(Aggregate: 75%)

1997 DAV Sr.Sec.School (Abohar, Punjab)

Additional Information

• Part of Awarded as ‘Best Spirited Team’ in Infosys and on Client Location(Tesco).

• Secretary of Indian Society of Technical Education in College

• Won Silver Medal in Science Test Organized By National Open Talent Society.

• Best Actress in School for Continuous Two Years.

• Won Third Prize in Debate in Inter School Competition

• Member of IT Club in College.

Contact this candidate