Post Job Free

Resume

Sign in

Sql Server Project

Location:
Enterprise, MS
Posted:
January 24, 2013

Contact this candidate

Resume:

SURENDER KUMAR Contact Info: abqdv4@r.postjobfree.com ; abqdv4@r.postjobfree.com

Career Profile: SharePoint 2010 ASP.net 4.0, 3.5 and 2.0Over 12 years of professional IT experience in Microsoft Technologies.Extensive experience in developing SharePoint Development, Web Applications, Web Services and Win form.Expertise in all phases of Software Development Life Cycle (SDLC), HLD, LLD, designing, coding and testing. Extensive exp. in experience based methodologies including SCRUM, Extreme Programming, FDD, TDD models. Extensive exp. in architecture design, N-tier, 3-tier, MVC, Enterprise MS Application Blocks, BizTalk 2006.Extensive exp. With SharePoint Web part, Smart part development, Visual Studio version 2010/2008, 2005.Extensive exp. With Windows Communication Foundation, Windows Presentation Foundation XAML and Workflow.Extensive experience XML, XML DOM, XSLT, XSL, Java Script, Jscript, VB Script, Ajax and XPATH programming.Expertise in working with Microsoft SQL Server version 2005 and 2000 and MS Access. Expertise in working with T-SQL programming constructs Stored Procedures, Triggers, Views and Functions.Extensive exp. In Database Design and Normalization, Performance Optimization using SQL Profiler. Crystal Report.Expertise in drawing of Use cases, Object diagrams, Activity diagram, Class diagram using Microsoft Visio, Prosa Tool.Extensive experience in MVC, Factory, Bridge, Observer, Singleton Pattern architecture.Extensive knowledge in Telecom, Insurance, Travel, Marine, SEO and Government sector.Extensive experience in Google appliance customization for SharePoint site content crawls.Extensive experience in Object-oriented analysis and design.Extensive experience in Principles of service oriented architecture. Extensive experience in WSDL/SOAP/ REST.

TECHNICAL SKILLS SUMMARY

Languages & Tools:

C# 3.5/2.0 / 2.0 / 1.0, VB.Net, ASP.Net, HTML, XML, JavaScript, VBScript, MS Access, Crystal Reports, SQL Reporting 2005, Dundas Charting Report, Style Sheet / Flash, Ajax toolkit. Project Server / ADO.net

Application Servers

BizTalk Server, SharePoint portal server, Docushare, Commerce Server, IIS.

Database:

SQL Server 2008, 2005, 2000, 7.0, MS Access.

Operating System:

Windows 2000 Server, Advance Server, Professional, Linux

Design Patterns:

MVC, Factory, Bridge, Observer, Singleton.

CMM Level Process:

HLD, LLD, SDLC

UML Diagram:

Use Cases, Activity Diagram, Class Diagram, Collaboration Diagram, and Deployment Diagram using VISIO.

Domain:

Telecom, Travel, Search Engine Optimization, Marine, Insurance

Testing Tools

Visual Studio 2010 Team System Test tools, NUnit

Architectures:

MVC, Factory, WPF, WWF, WCF Pattern & Practice

EDUCATIONAL QUALIFICATIONS

B. Tech (Computer Science) – Institute of Electronics and Telecommunication Engineers, New Delhi, India

CERTIFICATIONS

Description

Date

562 TS: Microsoft .NET Framework 3.5, ASP.NET Application Development

May 26, 2010

536 TS: Microsoft .NET Framework - Application Development Foundation

May 15, 2010

564 PRO: Designing and Developing ASP.NET Applications using Microsoft .NET Framework 3.5

May 08, 2010

631 TS: Windows SharePoint Services 3.0, Configuring

Nov 21, 2008

630 Microsoft Office SharePoint Server 2007, Configuring

Oct 17, 2008

315 Developing and Implementing Web Applications with Microsoft Visual C# .NET

Feb 09, 2008

215 Installing, Configuring, and Administering Microsoft Windows 2000 Server

Mar 24, 2005

Six Sigma Yellow Belt Certified in September 03, 2007 from More Stream University

Mar 24, 2005

DNIIT Professional Certification in IT – National Institute of Information Technology

2001 to 2003

CAREER PROFESSIONAL EXPERIENCE

Project: MCSCS Toronto, ON

Client: MCSCS (Contract)

Duration: Jan/2012 to Till date Role: SharePoint Consultant Corporate Portfolio MCSCS

Project Description: Serving MCSCS on their projects CCM, Corporate Portfolio. Migrating old content from SharePoint 2007 to 2010. Develop Manager toolkit web part which connect with Cognos through query vision. Customize SharePoint 2010 master pages.

Responsibilities:Work with stake holders and business site users. Responsible for SharePoint template customization.Responsible for manage SharePoint sites collection and subsite.

Environment: SharePoint 2010, VS 2010, SQL Server 2008, SQL 2008 Reporting, Development methodologies used SCRUM.

Project: G2B Calgary, AB

Client: Enbridge Oil & Gas Pipelines (Contract)

Duration: Aug/2011 to Dec /2011 Role: BI/DW Lead

Project Description: Working on G2B BI project is a great exposure. I have designed and developed high availability BI farm. Biggest QA farm has total 12 servers in farm. QA farm has two front and server, two app server, two central admin server, two analysis server, two SQL server 2008 boxes has implemented with mirroring and clustering. In addition of QA HA BI farm i have designed and developed Intake 4 node farm, SIT 4 node farm, Sandbox one 4 node farm Sandbox two 4 node farm,

All above mentioned business intelligence farm does have wide variety of SSRS, Power pivot, Performance point, SSAS reporting implemented. I used cubes, data mart etc to generate our reports. I also used oracle client for reporting. I have also used SSIS to integrate other databases data in reporting.

Responsibilities:Work with stake holders and business site users. Install and configure HA QA farm.Install and configure Intake farm.Install and configure SIT farm.Install and configure Sandbox farm 1.Install and configure Sandbox farm 2.Design and develop report in SSRS using report builder 3.0Develop XML, XSD based web file for processing.Use C# 4.0 for object programming with MVC model.Use OSAP and Rest based web services for development.Use Enterprise messaging bus and service registry and repository.Use SOA based framework for development.

Environment: SharePoint 2010, VS 2010, SQL Server 2008, SQL 2008 Reporting, Development methodologies used SCRUM.

Project: SharePoint Migration from 2003, 2007 to 2010 Edmonton, AB

Client: Acrodex (Contract)

Duration: May/2011 to Jul/2011 Role: Sr. SharePoint Lead

Project Description: Acrodex has SharePoint content on 2003 and 2007 server. All custom solution and out of the box content need to migrate to 2010 server. It was a project requirement to plan all taxonomy and governance. As part of migration it was a requirement to change look and feel based on 2010 out of the box.

Responsibilities:Gather all migration requirements.Work with stake holders and business site users for SharePoint site content filtering. Install SharePoint 2010 and configure its claim based authentication. Configure all SharePoint 2010 services. Install Doc Ave Migration suite and configure for Migration. Design HLD & LLD of SharePoint solution architecture.Customized SharePoint based on multi host header mapping.Configured Alternate access mapping in SharePoint.Responsible for SDPS for various clients. Provide demo based on SDPS sessions.

Environment: SharePoint 2010, VS 2010, SQL Server 2008, SQL 2008 Reporting, Development methodologies used SCRUM.

Project: USDA Department of Agriculture Washington DC

Client: USDA Department of Agriculture Agencies

Duration: Aug/2009 to Apri/2011 Role: Sr. SharePoint Lead

Project Description: Serving USDA agencies. I have developed lots of dashboard in dundas for various site collections. I also developed many smart part based on agencies and sub division requirement’s. I also developed many master pages, layout pages, web part pages and content types. I also enhanced existing micro sites based on WSS 3.0 model. I also handle migration of sites from development to production. I also developed 4 tier workflow process using SharePoint designer. I also developed custom image zoom in utility for SharePoint. I also developed USDA agencies KPI dashboard. I also had done backup and restore of site, list and document library template from one site collection to another. I also used stsadm command for import and export site collection from development to production.

SharePoint 2010 work: I also started using SharePoint 2010 from June 2010. Used SharePoint 2010 claim based authentication. Created Site collection in 2010. Customized Master page in 2010. Features implemented in 2010

Application Management, Manage Servers in Farm, Web Analytic, Security, and Configure alternate access mappings.

Below are the list of SharePoint web part developed.

FOIA Request, Dynamic WHL liaison org. chart, Agency division issue tracker application web part, WYWO application, ARRA financial application, Agency migration application, EMS QA Application, H1N1 Silver light Bing map application, HQ Tandberg media services Google map web part, Federal leave transfer application, Inventory Tracker application, MS Contacts application, Multiple document upload web part for FBA zone in SharePoint, OES Tracking number tool, OSEC Scheduling application, SharePoint FBA calendar sync with outlook tool, Working Capital Fund application, Worked Nintex web parts in Site Collection.

Responsibilities:Requirement gathering of business process and technical environment.Create & deploy custom site definition & list definition on various farms.Create content type for various layout developments.Develop master pages for various layout types.Created custom web part that dynamically gathered site usage in one report for SharePoint application. Created features and solutions for web parts, custom workflows and event receivers.Responsible for backup and restore the data in the SharePoint sites. Developed Smart part, Web part, Custom event listener types and WSP solution packages.SharePoint security configuration and other farm level configuration.Configure SharePoint for Active directory access & Form based user access.Developed SharePoint Site Map tool for advance customization.Developed Custom bread crumb tool for SharePoint.Developed most pages hit web part and most article view web part for SharePoint.Configure SharePoint document library for support web part pages versioning.Configure web.config file for support of custom asp net membership provider. Use C# 4.0 for object programming with MVC model.Use OSAP and Rest based web services for development.Use Enterprise messaging bus and service registry and repository.Use SOA based framework for development.

Environment: MOSS 2007/2010, VS 2010, SQL Server 2008, SQL Server 2008, XAML.

Project: Re-Develop NCSC public facing site Williamsburg VA

Client: NCSC

Duration: Feb/2009 to July/2009 Role: Sr. SharePoint Lead

Project Description: Re-design of old NCSC site from ASP and HTML pages to SharePoint dynamic pages. NCSC having 80000 old technology pages which need to migrate to SharePoint. I have developed around 30 web part, smart part, and event listener wsp solution. I also developed 3 Trier workflow approval process for SharePoint pages. I also customized Google appliances for crawl SharePoint sites & many micro site’s. I also developed page publishing layout content type. I also developed 4 master pages. I also developed custom site map which used asp.net site map. Mode of authentication in NCSC site is Windows and Forms. I have also done work on setup content path deployment jobs. Design security parameters which involve host header and security ISA configuration settings based on Alternate access mapping. Configure secure socket layer for admin web pages.

Responsibilities:Requirement gathering of business process and technical environment.Develop master pages for various layout types. Created features and solutions for web parts, custom workflows and event receivers.Developed Custom Search web parts, Connected web parts and packaged into solution.Design multi tier architecture based on web front end server, enterprise server, Google appliance connector.Developed Smart part, Web part, Custom event listener types and WSP solution packages.SharePoint security configuration and other farm level configuration.Configure SharePoint for Active directory access & Form based user access.Configure web.config file for support of custom asp net membership provider. Customized Google Appliances box for SharePoint site crawl.Used Business Object to handle SharePoint user’s security roles and permissions.Customize master pages & template look and feel.Configuring and implementing security with the GSA.Install & Configure SharePoint GSA connector. Use C# 4.0 for object programming with MVC model.Use OSAP and Rest based web services for development.

Environment: MOSS, VS 2008, SQL Server 2005, Development methodologies used SCRUM.

Project: NOC (Network Operation Center) Orange County CA

Client: Lumen

Duration: July/2008 to Jan/2009 Role: Sr. SharePoint Lead

Project Description: NOC (Network Operation Controller) is a product used to maintain network devices. NOC forms developed in Smart Part and deployed in SharePoint. NOC having wide variety integration with other NOC products like: - N-Able, IP-Monitor, MS Operation Manager 2007, Altiris. In addition this product having lots of reports which developed in SQL Reporting services. I also developed Silver light navigation page which deployed in SharePoint. I have also used Google maps API for SQL based data need to present on Google maps. I also developed smart part which used to display report from SQL 2005 reporting service. I also implemented/designed Livelink based document management solution.

Responsibilities:Third party product API study and integrate with SharePoint.Custom web parts, templates, Custom List Types and objects, solution packages and features. Responsible for configuration and customization of Search features and solutions.Display Devices information from N-Able, MS Operation Manager,Customize SharePoint search based on Manage Property.Design and Develop Dash-board which link to other site collection.Develop Data Transform package tool for transfer data from one type to another.Design ER diagram, Network load balancing diagrams.Normalize database from 1st to 3rd normal forms.Prepare test cases, automated test cases using NUnit,Customize web part for target user.Live link Administration/Development and Integration of SharePoint with Live link.

Environment: MOSS, VS 2008, SQL Server 2005, SQL Server 2005 Reporting.

Project: TAM bugs fixing (Insurance Product) Chicago IL

Client: Applied Systems Inc

Duration: April 2008 to June 2008 Role: Sr. SharePoint Lead

Project Description: TAM Product is for insurance industry. This product is in development stage. It contains all feature of insurance domain like: Policy creation, Client, Broker, Employee, security management Binder certificate, configuration setup, Accounts, Ledger, and Custom Reports. Thick & Thin client application developed using smart framework.

Responsibilities:Develop WEB BASED REPORTING for Thin client application using dot net charting control, Crystal Report, SQL ServerDevelop Data Transform package tool for transfer data from one type to another.Migration of Advance Revelation data into the new designed SQL server database.Responsible for fixing PMGs (Program Modification Group) and PMR (Program Modification Request).Perform unit testing of PMGs and PMRs before code check in to VSS.Prepare effort estimation, WBS on activities.Research on new development controls based on Smart framework.Develop printer tools based on Smart framework.Develop Virtual List View controls based on Smart framework.Create and Configure SSIS package for data transferInvolve in Win form development. Smart Framework control development

Environment: VB.net, SQL Server 2005, Win forms, Crystal Report, SQL Reporting, MS Visio, XML Parser, IIS 6.0.

Project: Intranet SharePoint Deployment South Plainfield New Jersey

Client: VAM

Duration: Dec 2007 to March 2008 Role: Sr. SharePoint Lead

Project Description: This project is used to design internal intranet site of SharePoint. SharePoint site include team site with document, List, Web Part feature. SharePoint site connected with Business Catalog services. I also developed User entry form in WPF which allow user to enter information. Entered information process through WCF services and pass that information to BizTalk rule engine. I also developed various InfoPath forms for collecting HR and Consultant related data. I also developed WCF service which called from SharePoint workflow and pass data to BizTalk rule engine.

Responsibilities: Creating and Configure Web part for SharePoint team sites.Creating and Configure XML based BDC (Business Catalog connectivity) from Custom databases. Creating custom workflow using SharePoint workflow template. Configure Admin site configuration in various level including Form Authentication, Security configuration, Create all documentations like: development design document, functional document etc.Configure SharePoint list & document libraries for InfoPath form services.Query creates in CAML for SharePoint document library & Lists. Work with the technical leads, business analysts, and project managers to translate design into product,Communicate with BizTalk using SharePoint workflow and WCF service.Workflow process using BizTalk rules engine.

Environment: Win 2000, ASP.NET 2.0 with C#/ JavaScript / HTML / Style Sheet / Microsoft SQL Server 2005, InfoPath,

Project: Docushare Collaboration Pune INDIA

Client: Avaya

Duration: June 2007 to Dec 2007 Role: Pre-Sales Analyst / Architect

Project Description:

This project is used to develop a client interface using variety of workflow created. Integration using Docushare COM API. This project divides in 2 parts. AP and TE. Account Payable, Travel and Expense. Around 2 Window services created to pull data from FTP and Shared Drive in AP and around 4 Window service Travel and Expense. All countries in world they upload their zip files in ftp. Window service pulls data from FTP automatically and unzipped automatically

Responsibilities: Created tables, stored procedures, constraints, triggers, views and indexes using SQL server. Involved in coding with proper layers and architecture. Involved in testing of screens. Responsible for creating graphical reports.Components developed in C# Window services 2 in AP and 4 in TEResponsible for overall estimate & WBS.Communicate client based in Singapore to provide up-to-date information on project.Responsible for configure NUnit configure.Responsible for UAT to work with client on various test cases.Responsible for performance tuning of application.Transfer document to Docushare using BizTalk orchestration.

Environment: Win 2000, ASP.NET 2.0 with C#/ JavaScript / HTML / Style Sheet / Microsoft SQL Server 2005. VS 2005, IIS 6.0.

Project: CMS (Collaboration Management System) Offshore INDIA

Client: Soltius

Duration: Jan 2007 to May 2007 Role: Sr. SharePoint Developer / Leader

Project Description: This program is for connecting all zone groups of Soltius in INDIA and abroad. System also used to Involved in the Decision Making depending on the Approvals from various business teams there are Investors, Trustees, Financial Consultants, Borrowers, Service Providers and Decisions are made on some of the Business Teams or the Whole Group. SharePoint workflows made the task easy for all the business units to track the tasks and review the history of the approvals. We also used Commerce server 2007 to make shopping cart dynamic and integrated with MOSS.

Responsibilities: Requirement gathering and documentation.Involved in Creation of custom activities using SharePoint object model. Created Association Form, Initiation Forms and Action Forms using InfoPath 2007.Created Solution packages for deployment of content types and workflows.Integrate Commerce Server with Other LOB (lines of business, or backend business) Systems.Day to day data migration from existing E-Commerce system to Microsoft Commerce server.Involve in customizations of the Commerce Server Management Tools.Strong understanding of business requirements and familiarity with commerce technologies.End to end knowledge of designing systems, developing applications and deploying applications.Extensive experience of Commerce Server and SharePoint to manage and deploy content with commerce featureWorking on API structures that utilize Commerce Server and SharePoint stack.

Environment: Windows2003 Environment, Visual Studio 2005, SharePoint Designer SharePoint Portal 2007.

Project: SEO Toolkit (SEACH ENGINE OPTIMIZATION) London UK (Off shore)

Client: Visit Britain

Duration: Sep 2006 to Dec 2006 Role: Sr. Developer

Project Description:

This program is for Visit Britain SEO optimization toolkit. Purpose of this program is to analyze site in terms of keyword generation, site ranking, web analyze, optimize web pages for search engines.

Responsibilities:Created tables, stored procedures, constraints, triggers, views and indexes using SQL server. Involved in coding with proper layers and architecture.Involved in testing of screens.Responsible for creating graphical reports. Competitor Site Ranking Tool.

Environment: Win 2000, ASP.NET 2.0 with C#/ JavaScript / HTML / Style Sheet / Microsoft SQL Server 2005.

Project: Intranet Site Management System (ISMS) Australia (Off shore)

Client: R Design

Duration: March 2006 to Aug 2006 Role: Sr. Developer / Architect

Project Description: Program is used for various department related site. SharePoint system is used to configure all sharing data centrally from one location. All department employees can submit their expense & timesheet information from SharePoint team site. SharePoint workflow created to process their request and their respective manager approves it.

Responsibilities:Creating and Configure Web part for SharePoint team sites.Configure Admin site configuration in various level including Form Authentication, Modify web part pages, Master pages for custom look & feel.Created tables, stored procedures, constraints, triggers, views and indexes using SQL server. Involved in coding with proper layers and architecture. Involved in testing of screens.Responsible for creating graphical reports.Responsible for overall estimate & WBS.

Environment: Win 2000, ASP.NET 2.0 with C#/ JavaScript / HTML / Style Sheet / Microsoft SQL Server 2005.

Project: SPECTRUM Reporting System New Jersey USA (Off shore)

Client: TSI New Jersey

Duration: May 2003 to Jan 2006 Role: Sr. Developer / Leader

Project Description: This is a special program I developed with help of my team. This Program is very useful for Telecom Company to monitor all Departments (MICROWAVE, BTS/RF, SITE ACQUISTION, PROCUREMENT, WAREHOSUE, RIGGING, and AIR CONDITION). These all department’s involved. Beauty of this Program to get available Graphics report to available for General Manager’s to see the progress of completion of sites. Some of the other project has been worked with TSI area: Data Mining, KPI (Key performance indicator), and Switch Subscriber call tracking system, Flight schedule entry system, HLR Mining, TSI/AWCC Corporate Website, and SPECTRUM Reporting System

Responsibilities:



Contact this candidate