Sql Server Project

Srinivasa Rao Madala

SharePoint Developer

Email Id: *******.*@*****.***

Phone: 347-***-****

SUMMARY:

• About 7+ years of experience in programming and development including about 5+ years of experience in SharePoint

environment

• About 5+ years of specialized experience in SharePoint that includes WSS 4.0/3.0/2.0 (Windows SharePoint Services)

and MOSS (Microsoft Office SharePoint Server) 2007, SharePoint 2010 and SharePoint 2013

• Good exposure in database analysis, modeling and programming skills using Oracle, MS SQL Server

2005/2008/2012, T-SQL and DB2

• Demonstrated expertise in analyzing business application and have good knowledge in development and debugging

applications using VB.NET, ASP.NET, C #.NET

• Working Experience on the Development and Deployment of SharePoint solutions using Visual Studio.

• Working knowledge of various SharePoint services such as – SharePoint Designer, SharePoint Feature Manager,

Event Handler Explorer, CAML Query Builder and Excel services

• Experience in designing and implementing various content types,custom Document Libraries and Lists, SharePoint

Simple, Connectable and AJAX Web Parts, customWorkflows and Workflows using SharePoint Designer, Web

User Controls and custom Templates.

• Experience in migrating content between SharePoint sites using Sharegate Migration Tool.

• Designed and developed the Custom WEB PARTS using Microsoft C#.NET and connected the web parts.

• Experience in creating workflows using Nintex workflow 2010.

• Experience in developing BI Report center in SharePoint including PerformancePoint services, creating

dashboards, KPI and Filter Webparts.

• Experience in use of STSADM or Power Shell /WSP Builder for Deployment of web parts, web applications.

• Experienced in working on Branding and Chroming portal by customizing site definition, To improve the look

and feel of User Interface used CSS, XSLT and JQuery extensively, also knowledge on creating Themes, Master

Pages and Site Definitions

• Worked on Virtual server environment such as VMware and Microsoft virtual server

• Rich knowledge about development of triggers, stored procedures and SQL queries using SQL Server Database, also

worked on integration Services and SQL Server Reporting

• Experience working on CAML, Search, Audiences, Single Sign and SharePoint Templates

Technical Skills:

Development Tools: Microsoft SharePoint Designer 2007/2010/2013,Microsoft Visual Studio 2005/2008/2010/2012, Microsoft

InfoPath 2007/2010, Nintex Workflow, Microsoft Project 2010/2007, Microsoft Office 2010/2007/2003, VMware.

Programming Languages: C# .NET, VB .NET, VB 6.0, Java, C/C++

.NET Technologies: .NET Framework, ASP .NET, Team Foundation Services (TFS), Object Oriented Programming Concepts

(OOPS)

Operating System: Windows 7/Vista/XP/2003/98, Windows Server 2008/2003, Macintosh OS

Web Technologies: HTML, XHTML, XML, XSL, XSD, XPATH, XSLT, Adobe Photoshop, CSS, JQuery, JavaScript, Microsoft

FrontPage, AJAX, and Internet Information Services (IIS)

Database Services: SQL Server 2005/2008/2012, OLEDB, LINQ, ODBC, Microsoft Access

SharePoint Related Tools/Utilities: Visual Studio Extension for 2008/2010/2012, Silverlight, WSP BUILDER, STSADM

Migration Tools: Sharegate Migration Tool

Professional Experience:

Client: RedWood Trust, Englewood, CO

SharePoint Developer, Sep 14 – Till Date

Project Description: Developing an Integrated Reporting Platform using SharePoint for Redwood Trust (RWT).

Responsibilities:

• Created a reporting site where all reports from SSRS, Tableau and excel reports are landed.

• Utilized Central Administration site to manage farm and SharePoint sites.

• Implemented search and breadcrumb functionality.

• Master page and CSS style sheets are customized to give personalized look and feel.

• Created Menu structure classifying on Departments.

• Developed and Deployed Web parts for configuring SSRS and Tableau into SharePoint.

• Created different departmental pages for displaying reports.

• User groups are created, added users into those groups and gave security on reports.

• Involved in writing test cases for the UAT.

Environment: SharePoint 2013, IIS 8.0, SQL Server 2012, Windows Server 2012, SharePoint Designer 2013, Visual

Studio 2012, PowerShell 4,, MS office 2013, JavaScript.

Client: Florida Blue, Jacksonville, FL

SharePoint Developer, July 13 – Aug 14

Project Description: Managing SharePoint Workflows using Nintex Workflow and applications to manage the naming

convention on the Database tables.

Responsibilities:

• Customized workflows in Nintex for change of approver.

• Naming tool using .Net and telerik to check and create attributes in database.

• Customized the look and feel of the site using SharePoint Designer

• Workflows are created to send an email when a request is submitted by a user.

• Validated and tested InfoPath forms used to input data into SharePoint lists.

• Responsible for the testing of workflows undergoing for task tracking on the calendar.

• Involved in testing the application developed using .net and telerik controls.

Environment: Moss 2010, IIS 6.0, SQL Server 2005, ASP.Net, SharePoint Designer 2010, Visual Studio 2010, MS office

2007, Adobe Photoshop, Telerik Controls, JavaScript.

Client: Wal-Mart, Bentonville, AR

SharePoint Developer, March 13 – July 13

Project Description: Migrating the Standards and Governance site of Wal-Mart from 2007 to 2010 and developing some

functionality.

Responsibilities:

• Designed workflows for the tracking the tasks in the SharePoint list.

• Converted and Customized Master Pages and page layouts.

• Customized CSS style sheets in SharePoint designer.

• Customized the look and feel of the site using SharePoint Designer.

• Involved in the Migration from Moss 2007 site to 2010 site including the workflows designed OOTB.

• Workflows are created to send an email when a request is submitted by a user.

• Validated and tested InfoPath forms used to input data into SharePoint lists.

• Managed excel workbooks for the reports using Excel services.

• Used J-query to implemented picture gallery and slider scripts for links bar.

• Responsible for the testing of workflows undergoing for task tracking on the calendar.

• Involved in the testing and validating the functionality in the SharePoint site.

Environment: Moss 2010, IIS 6.0, SQL Server 2005, ASP.Net, Windows Server 2003, MOSS 2007, SharePoint Designer

2007/2010, Visual Studio 2010, MS office 2007, Adobe Photoshop, AJAX, JavaScript.

Client: The Kroger Co., Cincinnati, OH

SharePoint Developer, June 12 – Jan 13

Project Description: Redesign of the Kroger website. Kroger is a grocery, multi-departmental stores, convenience stores and

jewelry stores. It has more than 25 banners. This project includes the change of appearance and also giving the customer best user

control than the previous look.

Responsibilities:

• Designed Page layouts, field controls, Custom Web Parts, .Net Controls, Event Receivers.

• Created List templates, Content templates in visual studio and deployed to the site.

• Designed Custom Page layouts and Custom Content Types as a feature in Visual Studio and deployed into

SharePoint site.

• Responsible for Creation and Customization of Site Column, List Definition, Content Type, Site Definition, Site

Template using MOSS 2010 / 2007.

• Designed and developed the Custom WEB PARTS using Microsoft C#.NET and connected the web parts.

• Customized the look and feel of the site using SharePoint Designer

• Migrating content and user permissions from Moss 2007 to SharePoint 2010 using Sharegate.

• Managed excel workbooks for the reports using Excel services.

• Developed forms in InfoPath 2010 and deployed into the site.

• Customized CSS style sheets and deployed on a SharePoint site as a custom feature.

• Used J-query to implemented picture gallery and slider scripts for links bar.

• Involved in Unit Testing, Functional Testing, Integrating Testing

Environment: Moss 2010, IIS 6.0, SQL Server 2005, ASP.Net, Windows Server 2003, MOSS 2007, SharePoint Designer,

Visual Studio 2010, Lotus Notes 8, XSLT, XML, MS office 2007, AJAX, WSS, JavaScript.

Client: Golden Rule (United Health Care), Indianapolis, IN

SharePoint Developer, Nov 11 – May 12

Project Description: Golden Rule Insurance (GRI) and American Medical Security (AMS), under the United Health Group

provide insurance products for individuals. United Health One(UHOne) in United Health Care/Golden Rule Insurance (UHC) is a

system designed to calculate benefit level, enable issuance of benefits, reprising and generate various management reports to

assist in program administration and pass information to other systems.

Responsibilities:

• Involved in designing, planning, development, customizing of Share point according to business needs

• Developed master templates, page layouts, field controls, Custom Web Parts, .Net Controls, Event Receivers

• Utilized Central Administration site to manage corporate server farm and created/extended web applications to

isolate SharePoint sites

• Created horizontal and vertical menu bars in a SharePoint site using HTML, CSS and JavaScript.

• Created custom CSS style sheets and deployed on a SharePoint site as a custom feature.

• Workflows are created using Nintex workflow 2010.

• Used business data catalog to pull the customer information from the SQL 2005 server.

• Developed Custom Page layouts and Custom Content types as features in the SharePoint site

• Implemented Form based authentication, custom login and user control development

Environment: SharePoint 2010, C#, ASP.NET, WCF, Windows Server 2003, SharePoint Designer, Visual Studio 2010, MS Lync

2010, MS Office, Adobe Photoshop, SQL Server 2005.

Client: FedEx, Dallas TX

Position: SharePoint Developer Jan 11 – Oct 11

Project Description: FedEx Corporation, together with its subsidiaries, provides transportation, e-commerce, and business

services. FedEx Trade Networks is a part of FedEx that provides end-to-end, anywhere-to-anywhere transportation and customs

clearance solutions. Currently FedEx uses packaged applications from variety of vendors as well as mainframes and custom

applications. This Integration solution acts as a platform by connecting various systems throughout FedEx global business to the

Central IT infrastructure. FedEx provides access to a growing global marketplace through a network of supply chain,

transportation, and business and related information services.

Responsibilities:

• Involved in Analysis, Design, Programming, and Testing and Documentation phases of SDLC.

• Responsible for Creation and Customization of Site Column, List Definition, Content Type, Site Definition, Site

Template using MOSS 2010 / 2007.

• Designed a New Claim registration form and other internal forms using the InfoPath 2010/2007.

• Transferred content from document repositories, discussions, and tasks to SharePoint Lists, Document Libraries.

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats

using Reporting Services (SSRS).

• Developed a web part to filter and display the details of the customer who have applied or received a claim.

• Designed and developed the Custom Reports using MS SQL Server 2008 Reporting Services.

• Implementing LINQ queries on different data sources in Silverlight applications.

• Designed and implement WCF, was used to communicate in business-to-consumer.

• Wsp solutions developed in visual studio are deployed using PowerShell scripting.

• Developed sequential workflows for modeling ongoing processes using Workflow Foundation.

• Created Excel workbooks for retrieving data from MS SQL Server and published them on the SharePoint site using

Excel Services.

• Provided Technical Support to end-users and resolved day-to-day issues regarding SharePoint usage.

Environment: MOSS 2010 / 2007, Windows SharePoint Services 4.0 / 3.0, Microsoft Visual Studio 2008, ASP.NET 3.5, C#,

WCF, Silverlight, LINQ, MS SQL Server 2008, IIIS 7.0 / 6.0, Microsoft Office 2010 / 2007, Lotus Notes 8, Microsoft Windows

Server 2008.

Client: A&P, Montvale, NJ

Position: SharePoint Developer April 10 – Dec 10

Project Description: The Great Atlantic & Pacific Tea Company is delighting customers with aisle after aisle of outstanding

products, including the finest array of fruits, vegetables, deli, and other fresh foods available anywhere. They anticipated

improving their employee performance management and issue tracking system.

Responsibilities:

• Perform a feasibility analysis of the architecture versus the existing tool to see if the architecture can be realized as a

solution.

• Performed Gap Analysis against a set of established requirements and delivered the report to the management.

Develop Employee Performance and Issue Tracking System modules.

•

Analyzed and designed the full system.

•

Monitored and scheduled the timer jobs for the job status.

•

Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using

•

SQL Server Integration Services (SSIS).

Implemented issue management system to their SharePoint 2007 Portal.

•

Created ad-hoc reports using SQL server 2005 Reporting Services (SSRS).

•

Used SharePoint Designer Workflow to implement their business logic.

•

Implemented Form Based Authentication (FBA) to their SharePoint 2007 portal and used external employee database

•

for authentication.

Accessing SQL Server 2008 from a Silverlight application using WCF

•

Created different types of InfoPath form and implemented to their SharePoint 2007 portal.

•

Implemented security policy according to their current employee hierarchy.

•

Created custom list template and implemented business logic in different list events.

•

Created different types list views.

•

Environment: MOSS 2007, Windows SharePoint Services 3.0, ASP.NET, WCF, Silverlight, Web Forms, J-Query, Windows

2003, SQL Server 2005, Lotus Notes, Adobe Photoshop, Web Service, Microsoft Visual Studio 2008

Client: Pfizer, Madison, NJ

Position: SharePoint Developer Nov 09 – April 10

Project Description: Pfizer for Professionals (PFP) is an educational application that stores all brand related information of

Pfizer. Every new brand comes with patient education material and brand education material. To support this feature, PFP

provides two access points. Product Center (everything related to brand) and Patient Education material (stores all material to

educate patients).

R esponsibilities:

• Configured and installed MOSS 2007 server.

• Designed the Workflow for various applications and workflow to be triggered on various events.

• Created web parts for each application and published them to the web site.

• Created the GUI for showing the various status (approved, picked up, rejected, etc).

• Modified dashboard which will be used by the application uses to view complete details.

• Modified the workflow platform to receive mails for the user and approver groups.

• Added InfoPath to get the data and trigger the workflow as soon as the request to buy a deal is send from end user.

• Wrote procedures to retrieve data from SQL Server 2005.

• Designed and developed forms using InfoPath to collect end user details saved in data base to use the data for some of

the web parts.

• Modified dashboard which will be used by the application uses to view complete details.

• Modified the Workflow platform to receive mails for the user and approver groups.

• Added InfoPath to get the data and trigger the workflow as soon as the request to buy a deal is send from end user.

• Used XML/XSLT to receive and send data.

Environment: Share Point 2007 / 2003, IIS 6.0, SQL Server 2005, ASP.Net, Windows Server 2003, ASP.Net 3.0,

MOSS 2007, SharePoint Designer, Info Path, Visual Studio 2005, XSLT, XML, MS office 2007, AJAX, WSS, JavaScript.

Client: Aanjaay, Chennai, India

Position: .NET Developer May 08 – Sep 09

Project Description: This Project involves all the Housing loan maintenance modules. The objective behind this Software is to

automate all loan modules and interest calculation efficiently. This software comprises of Loan module, EMI module, and Loan

Payment module. Reports are concentrated in tracing out as on date EMI Pending Report installment wise.

Responsibilities:

• Developed ASP .NET pages and Class Libraries containing code for business and data access logic using C# .NET

• Involved in creating stored procedures dynamically

• Implemented Web Services using C# and also invoking external services

• Developed database scripts, stored procedures, and triggers

• Created XML, XSL Style sheets to parse the XML Data

• Used disconnected database concept by using data set and data adapter objects in order to reduce the database traffic

and increase performance, Database transactions were also performed using data objects like command, data reader etc.

• Involved in designing of custom web parts, utilizing SPS 2003 framework, for integrated search, integrated user access

and rights management

• Worked on Web Services using C#

• Supporting the Websites and Fixing Issues

Environment: Visual Studio 2003, SPS 2003, SQL Server 2005, C#, ASP.NET, XML, IIS, Web Services

Client: Fusion Technologies, Hyderabad, India.

Position: ASP.NET Programmer April 07- May 08

Project Description: Fusion Technologies is an IT consulting and Software Services Company. We provided business

intelligence and revenue management software to healthcare practices and systems. This is an intranet based web application for

internal employees to view the medical history of all the subscribers and also their claims information.

Responsibilities:

• Developed the web pages using HTML, DHTML/Javascript and ASP.

• Successfully engaged external clients in proposal and requirements gathering meetings.

• Involved in the design, analysis and functional specification of the application.

• Worked on security issues related to user authentication and authorization.

• Prototyped various application screens.

• Developed functionality for various screens.

• Coding, Testing, Bug-fixing and integrating the system.

• Used Cascading Style Sheets for the look and feel of the application.

• Developed ASP.NET codes to connect with SQL Server database.

• Implemented various stored procedures.

• Implemented Stored Procedures and Views to improve performance.

Environment: Windows 2000, SQL Server, ASP.NET, IIS, Javascript, VB.Net.

EDUCATION:

• Bachelor of Technology, JNTU, India.

Contact this candidate