Sql Server Project

TEJAS PATEL

EXPERIENCE SUMMARY

Over ** years of experience in (SDLC) Software Development life cycle like Analysis, Design, Coding, Testing,

Implementation and maintenance of Client/Server and Web based Applications.

• Extensive experience to work for various clients in Financial, Health Care, Automotive,

Manufacturing, Government and Educational sectors for the web based & Service based Applications Using

Microsoft Technologies and other technologies.

• Over 8 years of experience in portal solutions with Microsoft SharePoint Technologies

working knowledge and experience in installation, configuration administration and customization of intranet,

internet facing and extranet portals built on MOSS 2007 and SharePoint Server 2010/2013.

• Architect and design SharePoint 2010/2013 server Farm and Identify opportunity for additional and

enhanced capacities to exiting solution that increase user productivity, as well as effectiveness and efficiencies of

Business Process.

• Architect and Design search topology and enhance search performance and security. Optimize SharePoint

Performance and trouble shooting.

• Expertise in designing and developing applications using Microsoft .Net Technologies (VB.Net, ASP.Net,

ADO.Net, .NET COM interoperability, Localization, MS Application Block) WF, WCF, LINQ, AJAX, XML/XSLT

and Web Services.

• Experience with N-tier web application development, deployment, and integration, testing, trouble-shooting,

tuning.

• Experience with Object Oriented Analysis & Design and Design Patterns using UML Methodologies,

Rational Rose and MS Visio.

• Experience in all stages of Project Life Cycle with QA Management, Team Management and

Documentation (Class diagram, Use Case Diagram and Generate Soda report for Unite test cases) and UAT.

• Programming with .NET Framework: complete Back end to Windows and Web Forms front end Enterprise

integration technologies (Microsoft BizTalk, MSMQ, Web Services, Remoting) Microsoft Enterprise Content

Management and Collaboration technologies (MOSS 2007/SharePoint 2010/2013)

• Experience to build Business Connectivity Data Model to display data from line-of-business (LOB)

application via Web services or databases on the SharePoint Server Portal using object model and also used

Business Data Web Parts, Business Data in Lists, Business Data Actions, Business Data Search etc.

• Actively worked on Server Side Object Model and CSOM of SharePoint and PowerShell.Worked with

SharePoint web services, and custom web services for sharing the information from SharePoint across various

system or applications.

• Experience of writing scripts, Database Design and Developed Constraints, Indexes, Views and

Triggers in SQL Server 2000/2005/2008 R2/2012. Including Writing Views, Stored Procedures, Functions,

Cursors and Triggers SPQuery in CAML for search and accessing data from various databases like SQL Server,

MySQL and Oracle 10g.

• MVC application migration from ASP.Net for plant floor apps.

• Quick learner that expends extensive efforts to stay informed of new technologies with desire to grow in

server-side and distributed technologies. Highly organized with the ability to manage multiple projects and meet

deadlines. Extensive capability to grasp the subject matter soon.

• Excellent team player, good communication and interpersonal skills with solid team leading capabilities,

logical and analytical approach. A conscientious professional committed to excellence and continuous improvement.

Recognized for assertiveness and diligence.

TECHNICAL EXPERTIES

SharePoint Server 2013/2010, Microsoft Office SharePoint Server 2007 – WSS 3.0

Microsoft Office Portals &

Technologies SharePoint Portal Server 2003 – WSS 2.0

Languages C#.Net, VB.Net, ASP.Net, VB 6.0,Java 1.4, TSQL, PL/SQL

ASP.NET, AJAX Web Services, WCF, ADO.Net, Java Script, CSS, VB Script, ASP, DHTML,

Web Development

PHP,SOAP, COM/DCOM, HTML 5

Web Server IIS 5.0/6.0/7.0, Apache

Korn/Bourne/C-shell, JavaScript, JQuery,VBScript, Ajax, Action Script(Adobe)

Script

Winforms, MS Visual Studio.Net 2003/ 2005/2008/2010, SharePoint Designer, MS-Office,

GUI Tool:

Visio, InfoPath, Team Foundation Server, Basic Understanding of Biz talk Server

Mobile Application: Windows Mobile 6 Application, HTML Website, Basic Xcode development for IOS Application.

Databases MS SQL Server 2000/05/08 R2, DB2, MySQL, MS Access, Oracle 10g

Reporting Tools SQL Reporting Services 2005/2008, Crystal Reports 8.0, Dundas Charting, Cognos 9.0

Patterns MVC,MS Application block, Unity Framework, Entity Framework

and Frameworks

Windows Server 2003/2008 R2, Windows Vista, Win 98/NT/2000/XP/7, UNIX, Linux Red Hat

Operating Systems

/ Fedora, Windows CE/Mobile 6

Version Control Tools Visual SourceSafe 6.0, Visual SourceSafe 2005, PVCS, TFS2010, Sub version

Analysis Service, Reporting services, Integration Service, BitzTalk 2003, Cognos 9.0: Query

BI Tools

& Reporting, Statistica 10, Performance Point, Excel Power Pivot, Project Server 2010

Methodology Agile, Waterfall

XML Technologies XML, XSL, XSLT, MS XML

Telerik ASP.NET AJAX,Nintex Workflow 2010, DocAve 4.5/5.0 by AvePoint, EmpowerID (AD

Additional Technology & & Security), NewsGator, SQL Navigator Dev, ApexSQL, Orion, Adobe Photoshop CS5,

Tools Iconics64, Toad, Nunit, FxCop, Dream weaver, Silverlight 3.0, PowerShell, Bamboo WebPart

2007/2010, TMG 2010, FIS CFS Designer 13.0, Xenomorph Timescape

EDUCATION

Bachelor of Engineering in Information Technology from L. D. Collage of Engineering, Gujarat University, India

TRAINING AND CERTIFICATION

• ABAB/4 SAP Training

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

70-667 TS: Configuring Microsoft SharePoint 2010

PROFESSIONAL EXPERIENCE

Bank of Tokyo MUFG, Jersey City, NJ Jan 2013 – Present

ROLE: SR. SHAREPOINT CONSULTANT

Japan based Major Financial Group and one of the Emerging Banking in North America.

Responsibilities:

• Interface with stakeholders to understand needs, train and evangelize SharePoint

• Setup, install, configure, and maintain SharePoint services on servers, including the web front end,

indexing, and some aspects of maintaining database servers.

• Help architect and implement SSO to other applications using SharePoint best practices.

• Configuring User Profile with different data source and mapping attributes.

• Architect search indexing and crawl manage property with security-trimmed in search result.

• Involve in development of Document Service architecture using Entity Framework ECM Solution, document

handler and FAST search architecture.

• Worked on claim base event hander Authentication for customer Common Entitlement provider.

• Worked on FIS Designer installation, architect and Design different custom reports.

• Build unit test cases and Design, installation and governance Document documentation.

• Design and Developed Team Site Request using custom pages and State- Machine workflow.

• Prepare PowerShell scripts for solution deployment, verification, features, User Profile, search and custom features

for schedule task.

• Enhancing feature for Corporate Directory after UB Bank merging using different component BCS, User Profile,

JQuery, C#, REST API Web Service and Search Service.

• Working on Xenomorph Timescape Product installation and configuration on SharePoint 2013 Kerberos

Authentication.

• Build out-of-box custom cross-Request access form using JQuery.

Environment: Windows Server 2012/2008 R2, SharePoint Server 2010/2013, SharePoint Designer 2010/2013,

Access 2010 with VB modules, C#, CSS, MS SQL Server 2010 R2,SSRS IIS 7, JQuery, FIS CFS Designer/Intuition

13.0, Xenomorph Timescape, PowerShell 3.0, Entity Framework

Catalent Pharma Solutions. Somerset, NJ May 2012 – Dec 2012

ROLE: SR. SHAREPOINT ADMINISTRATOR

Catalent Pharm Solution is leading Pharmaceutical Company, has a wide range of capabilities in the fields of molecular

biology, vector biology, cell line development, biopharmaceutical manufacturing, protein biochemistry, Clinical Trial, Packaging

and quality systems

Responsibilities:

• Analyze SharePoint 2007 infrastructure, Architecture and design detailed migration plan to SharePoint 2010 which

include customization, enterprise branding and third-part tools.

• Design and architect extranet environment for using ISA server authentication.

• Development and detail documentation of process, maintenance, administration and support associated with

extranet, Intranet SharePoint environment and Active directory including server farm maintenance, scheduled

backups and security management.

• Identify opportunity for additional and enhanced capabilities to existing solutions that increase user productivity, as

well as effectiveness and efficiency of business process.

• Leading team, architect and design custom applications using latest Business Intelligent tools and generate reports

for better discussion making for end uses.

• Administration and maintenance of different SharePoint, database and Reporting intranet and extranet

environments.

• Installed and Configured SharePoint Fast search and implement different features using JQuery.

Environment: Windows Server 2008 R2, SharePoint Server 2010, SharePoint Designer 2010, Access 2010 with VB

modules, InfoPath 2010, C#, CSS, ASP.NET, MS SQL Server 2008 R2,SSRS IIS 7, JQuery, Nintex Workflows 2010,

Bamboo WebPart 2007/2010, ISA 2006, TMG 2010, Powershell, Project Server 2010

Merck & Co, Inc, Cokesburry, NJ Oct 2011- May 2012

ROLE: LEAD SHAREPOINT DEVELOPER/ ADMIN

Merck is a global pharmaceutical and chemical company based in New Jersey. Worked for ECCE Factory team provides

architect and design solutions for Merck internal users.

Responsibilities:

• Responsible for architect, design solution and Define Process Flow for “ VCT (Valuation Custom Tool)” based on

legacy custom Access client application.

• Requirement gathering, write design specification, design Custom security and approval process flow for application.

• Developed conditional InfoPath Form and custom code to calculate different types of methods (8) based on different

shipped Material using VSTO. Different views based on user access level.

• Create custom security list with user details using User Profile Service and Currency conversion (Merck Internal

Service) to display different converted currency based on selected to Ship country to ship Invoice in international

sites.

• Developed Item level security in Form library and Search custom list to manage security based on different user

access level.

• Worked on normalization, developed store procedures and Views in application database in SQL Server.

• Developed External Lists from SQL Server database using customize BCS Model.

• Developed and Manage External list and store data back to SQL Server data base using ODBC and Object Model.

• Worked on Full-Trust Proxy development for Sandbox solution and client Object Model

• Worked on customize Sequential Work flow for approval process and form published section.

• Define back up policies for Database and Data retention policy for VCT Forms.

• Developed Admin and user section sub sites to manage Configuration data and Form data.

• Developed application page for dashboard view on home screen and custom web part to display VCT Stream.

• Responsible to manage mange Site collection and create/Published form and solutions packages to Dev and Test

Environment.

Environment: Windows Server 2008 R2, SharePoint Server 2010, SharePoint Designer 2010, Access 2010 with VB

modules, InfoPath 2010, C#, CSS, ASP.NET, ADO.NET, MS SQL Server 2008 R2, IIS 7, MS Project Server 2010,

Nintex Workflows 2010

Horizon BCBS, Newark, NJ July 2011 – Oct 2011

ROLE: SR. SHAREPOINT DEVELOPER/ ADMIN

Horizon BCBS is leader in health insurance provider in New Jersey State. Worked for Data Management team under EDW to

provide solution for Internal Team Projects.

Responsibilities:

• Responsible for architect, design solution and Define Process Flow for “ DBA Request” and migration from Lotus

note legacy Application.

• Collect requirements from Users (DBA, BSA and Data Modeler) and responsible for writing BRD, TRD and Schedule

Project Plan documents.

• Used InfoPath2010 form service to design DDL Changes Request form and used C# to develop State Machine

Workflows for Approval process and OM model.

• Used BCS to fetch CQ (ClearQuest) project list data (DB2) to external list, used SPQuery and allow user to

maintain Project status within team.

• Design, branding and configure document/Form template for Data Management Team Portal based on existing

MOSS2007 Portal.

• Design and developed customize timer job for Due date alerts.

• Define Term store, Document retentions / allocation policy and Pool Calendar approval process.

Environment: Windows Server 2008 R2, SharePoint Server 2010, SharePoint Designer 2010, DB2, Lotus Notes,

InfoPath 2010, Microsoft SharePoint Portal 2007, C#, CSS, ASP.NET, ADO.NET, MS SQL Server 2008 R2, Internet

Information Server 7, MS Project 2010.

American Axle Manufacturing (AAM), Detroit, MI April 07 –July 2011

ROLE: SR. SHAREPOINT DEVELOPER/ ADMIN

AAM is the world leader in the design, engineering, testing, validation and manufacturing of driveline, Drivetrain and chassis

systems, related components, and metal formed products.

Responsibilities:

• Involved in Design and architecture of IPF Build out process, Design and analysis of third part tools (Telerik) for

ASP.Net AJAX.

• Installed and configured Microsoft SharePoint Server 2010, Microsoft SharePoint Foundation 2010, and And

FAST Search Server 2010.

• Work on Workbench Vault to access MySQL.

• Responsible for designing and writing Governance policy Document for SP2010, deploy solutions on farm, hotfix,

update and performance monitoring. Manage Security and permissions.

• Experience to configure Forefront Protection with SharePoint 2010.

• Responsible for Configuration and Administration of MOSS environments including configuring SSP’s indexing

and crawling rules, defining crawling,BDC and search scopes.

• Integrated SharePoint 2007 with SQL 2008 Reporting services to render reports using SharePoint front end.

• Customized SharePoint list events by implementing custom list event handlers.

• Providing Support for Web Content Management, Site Creation, Branding and customization for the New MOSS

portal. Communicate with company top level managers and user for their SharePoint related problem or requirement

on daily bases as SharePoint Administrator and Support.

• Prepare deployment strategy for any new developed applications using current infrastructure.

• Hands on experience in administering fault tolerant server farms with multiple tiers and load balancing.

• Involved in redesigning the SharePoint architecture into a scalable solutions to support the future growth of

organization.

• Developed custom Web Pages using ASP.NET, C# and SharePoint API and integrated them with SharePoint using

Visual Studio Tools for Application (VSTA).

• Developed Search Web Part with used Microsoft Full Text Search query and performed XSLT transformation on

query result to extend out of box SharePoint portal search.

• Developed workflows using Visual Studio, InfoPath and SharePoint Designer to automate manual business

process.

• Integrated ASP.NET pages with the portal site using the SharePoint Object Model and the WSS Object Model.

• Involved in creating stored procedures, Triggers, Cursors, User Defined Functions (UDFs) and complex SQL

queries for SQL Server 2008.

• Developed Dashboard for Production Data analysis on using Performance Point and SSAS cubes.

• Performed various operations and application management tasks including error reporting and logging creating

and extending web applications, creating site collections and defining quota templates.

• Responsible for taking Scheduled backup for all site collection / SSP on daily/Weekly bases using Batch file with

STSADM.exe, and encrypt those backup file for security purpose, also Restore any site as an when required for

Important document or request comes from Helpdesk.

Environment: Windows Server 2008 R2, SharePoint 2010, Microsoft SharePoint Portal 2007, InfoPath 2007/2010,

Windows SharePoint Services 3.0, SharePoint Designer 2007,Pefomance Point, C#.NET, CSS, ASP.NET, ADO.NET, MS

SQL Server 2005/2008 R2, Internet Information Server 6/7, MS Project Server 2003/2010.

A) IPF – (INTEGRATED PLANT FLOOR SYSTEM)

IPF is an integrated application with different Corporate and Plant floor systems. Provides different modules,

Responsibilities:

• Involve in critical production support and live application support.

• Development documentation which includes Requirement Analysis, Project scope, Project Analysis, Database

Design, Coding, Unit testing, writing detailed design specification and User manuals.

• Analyzed the user requirements and translated them into system requirements.

• Development applications using ASP.Net 3.5, VB.Net, C# and Reporting services 2008.

• Development of Personalize Dashboard.

• Security module – Authentication from LDAP and Authorized from Security module

• Using XML/XSLT for dynamic templates

• Complex SQL statements, stored procedures are used to implement business logic using SQL Server 2008.

• Involved in systems testing and Quality assurance and support of application

• Developed GUI using ASP.Net and JavaScript to perform Client Side Validations in the application.

• Developed middle tier components for implementing Business Logic.

• Architect design LDAP for corporate level authentication.

• Using WCF and JQuery for dashboard application.

• Interacted with QAs actively for System Integration Testing and User Acceptance Testing (UAT) and created the user

documentation.

• On side support, User Training and production support.

• Developed Windows Mobile application and web application to display real-time QIS, FIS and Inventory data.

Environment: IIS 6.0/7.0, ASP.NET 3.5, VB.NET, MS SQL 2008, VS 2008, XML,XSLT, AJAX, Workflow Foundation, LINQ

B) QISIIR /QIS/FIS/EAS (Quality and Alert messaging Applications)

Responsibilities:

• Provided expertise in gathering high level as well as detailed requirements.

• Experienced on Windows CE and Windows Mobile Development for RFID read/write on Motorola Scanner.

• Using classic ASP and VB script and Excel Macros programming using VB script.

• Designed and developed web based front-end using ASP .NET and Ajax; data collection and data cleansing

engine using VB .NET, XML, XSLT, and XML Schema to collect data from multiple plant floor databases.

• Designed and developed data evaluation engine using .NET to evaluate collected data against the client specs;

also designed alerting system to alert plant engineers if any manufactured parts are out of the specifications.

• Designed and developed authentication and role based authorization system using .NET’s inbuilt security model.

• Integrated all modules to perform application integration testing, UAT.

Environment: IIS 6.0, ASP.NET 3.0, VB.NET, MS SQL 2005,VS2005, VS2008, XML,XSLT, SQLXMLBULKLOAD 4.0,

Iconics64, LDAP, Nunit, Toad

NationalCity Corporation, Troy, MI April 06 –April 07

ROLE: SR. SHAREPOINT DEVELOPER / ADMIN

NationalCity was major regional bank in Midwest and requirements of a targeted portfolio of employees. The project created

an efficient organizational scheme for the files and made them available through a Share Point-based intranet and provided

Versioning of documents, grouping, custom webparts and retention policy of documents.

Responsibilities:

• Installed and configured MOSS 2007 across a medium server farm including Database Server and Search and

Indexing Server.

• Involved in Content migration of SharePoint 2003 to MOSS 2007. Moving content and configuration changes

from Staging Environment to Production Environment.

• Performed server operations and application management tasks (including backup and restore, error reporting,

logging, and creating and extending web applications and creating site collections).

• Responsible for Administration and maintaining the forms and site collections

Participate in escalation and support activities. Deploy and configure sites, lists and web parts

• Created custom master pages with security-trimmed UI that overrides the behavior of out-of-box permission

levels.

• Created list definitions and site columns using Features and built into a custom site definition to provision the

sites.

• Designed browser-enabled InfoPath form and published to Workflow enabled form library using InfoPath Form

Services.

• Created custom workflow activities in Visual Studio 2005 and expose them as actions in SharePoint Designer

2007

• Built security-trimmed UI using audience targeting and implemented role-based security using SharePoint

security groups and custom permission levels.

• Created a bar graph that displays the percentage of RFQ/RFP items by their status using Data View Web Part

and custom XSLT.

• Customized SharePoint Search results using XSLT to provide custom output look and manipulate item URL.

• Created a custom event handler to restrict users from deleting RFQ/RFP items from the form library and

deployed it using Feature.

• Performed SharePoint administrative tasks in the portal including Search administration, User Profile update,

Audience membership, backup/restore, and user access management.

• Built a prototype solution to demonstrate Web content management features in MOSS 2007.

• Managed Site collections and developed custom sites templates.

Environment: Windows XP, ASP.NET, VB.NET, C#. NET, XML, XSLT, IIS, SQL Server 2005, Microsoft Reports, .NET

Framework3.0,WSS 3.0, Microsoft Office SharePoint Server 2007 (MOSS 2007), SharePoint Designer 2007, Web

Services, SQL Server 2005

Aryans InfoTech Pvt. Ltd. Ahmadabad Jan 05 –April 06

ROLE: SR .NET DEVELOPER / SHARE POINT DEVELOPER

ARYANS Info is a fast growing software development and technology consulting company headquartered at

Ahmadabad, Gujarat, India.

Responsibilities:

• Applied corporate look and feel to Share Point Portal and WSS sites by branding them using FrontPage 2003,

CSS and XML files.

• Created Custom forms in InfoPath to conduct surveys with in the marketing department. The data in the forms was

utilized effectively by means of Share Point form library.

• Implemented cross page connections using Front Page 2003. Also Filtered data using the web part connection

wizard.

• Ensure secure access of SharePoint sites and lists by implementing role based security using site groups and

assigning permissions to them

• Customized SharePoint sited by changing layout and themes

• Created personal sites for different planners and sales

• Performing application upgrades and code migration between environments

• Wrote complex SQL statements and implemented stored procedures to execute month-end batch jobs.

• Responsible for training end-users on system functionality.

Environment: SharePoint server 2003, ASP.Net 1.1/2.0, Web Services,Framework 1.0, SQL Server 2005, Microsoft

Application Block.

Client: Govt. School of Indore, India

Project: e’ Cole

Role: Dot Net Developer

The Application developed for maintain the students and staff details which maintain in centralize database (Three Tier

Applications). It is customizing project. As per necessity form and modules can be enable/disable. Maintain session for better

performance and better database backup. It contain following modules

Responsibilities:

• As a developer I was involved in production support and development of the application.

• Complex SQL statements, stored procedures are used to implement business logic.

• Database backup as per years using application.

• Whole library module developed.

• Testing application on live environment.

• Used Crystal report to create reports.

• Responsible for training end-users on system functionality.

Environment: VB.Net, ADO.Net, ASP.Net 1.0, MS SQL Server 2000, Visual Studio 2003

AQest Newsletter

It is a site of Newsletter. Worked on manipulates newsletter details and creates new letters. Using ADO.Net. Send newsletters

for new products to clients and consumers.

Responsibilities:

• Responsible for writing detailed design specifications, development and Unit testing.

• Used User control for different templates using XML and XSLT.

• Payment Gateway (Paypal) and shopping cart solutions

• Support and upgrade application.

• Unit testing and Application testing.

Environment: SQL2000, ASP.Net 1.0, Flash 6, Visio

Confluence Solutions Pvt. Ltd, India Sep 03 –Dec 04

ROLE: .NET DEVELOPER

Web Mail system for the mail server Spear Mail which includes general mail routines like compose, forward, delete and move

Also support attachments of data and Address book.

Responsibilities:

• As a developer I was involved in technical design and development of the application.

• Attachment Files and restricted more than 10 MB attachments.

• Using session and classes maintain user status.

• Create domain for every user.

• Restricted Spam mail, Block users, Keywords.

• Maintain Address book as per Alphabetical order and there Details.

Environment: ASP.Net, ADO.Net, MS SQL Server, Visual Studio 2003, XML, Web Services

Adani Exports Ltd. Jan 03 –Aug 03

ROLE: ASP /.NET DEVELOPER (TRAINEE)

Project: ONLINE LEAVE APPLICATION-HR Module

Designed, developed and implemented a web base based application covering organization Payroll and HR functions. This

application tool was developed for automating salary, business and tax accounting. A minimum amount of essential

information is just enough to be entered (e.g. for payroll accounting all deductions, income tax and other dues are calculated

automatically). This tool supports bi-lingual report generation.

Responsibilities:

• Used JavaScript for Client side validation and Oracle 8i for backend validation.

• Developed server-side coding in HTML, DHTML, JavaScript, and CSS using Visual Interdev.

• Developed code in VB to generate the Salary sleep and text calculation online.

• Involved in resolving browser compatibility and version compatibility problems.

• Involved in the deployment of the project components.

• Used Crystal report to create reports.

• Responsible for training end-users on system functionality.

Environment: VB, ADO, ASP, Oracle 8i, Visual Studio 2003, JavaScript, HTML, DHTML, CSS

Availability:

Immediate

References available upon request

Contact this candidate