SUMMARY

• Having Seven - year background in diverse facets of .NET (Web/Windows) development, SharePoint development, SQL Server technologies like MS SQL Server 2008R2/2012 suite of products like SSRS, SSIS, encompassing analysis, design, development, testing UAT, Production and Post-production Support for globally reputed customers of different line of business including Insurance, Transportation & Logistics from the market leading service providers like Computer
• In-depth knowledge of various platforms, software systems, and servers.
• Installing, Configuring, Administrating, Maintaining and Troubleshooting Microsoft SharePoint 2013/2010.
• Experience in SharePoint 2010/2013 online (Office 365) development and Administration.
• Expertise in creating ASP.NET MVC, InfoPath and HTML Web Parts using SharePoint Designer 2010/2013, Visual Studio 2010 and InfoPath 2010/2013.
• Expertise in designing and building Work Flows using SharePoint Designer 2010/2013 and Visual Studio 2010.
• Creating KPIs, Score Cards and Dashboards from Cubes using Performance Point Services (PPS).
• Extensive experience in deploying solutions insandbox environment
• Proficient in working with Business Connectivity Service(BCS)to integrate LOB data from back-end server application to SP2010 Server.
• Experience with administration of search engines and relevancy tuning- Thorough understanding of search features in FAST Search for SharePoint 2010.
• Expertise in configuring Search, SSO, Excel Services, and User Profile Management in SP 2010.
• Extensive programming experience using ASP.NET 4.0/3.5/2.0, .NET(C#, VB), and SQL Server 2012/2008R2.
• Building Confidential (DNN) web content management system with ASP.NET, HTML, CSS, JavaScript, and AJAX.
• Expertise in developingWebServices using WCF, SOAP, WSDL, UDDI.
• Expertise in hosting and managing the Web Sites in IIS 7.0 and experience in Windows Server 2008 R2.
• Specialized in working with Team Foundation Server 2010(TFS) for Source Code Version Control.
• Expertise in Transact-SQL - Queries, Stored Procedures, Views, Functions, Triggers, creating Indexes, MDX Queries (Querying Cubes) and Open Query using linked servers
• Strong experience in Object Oriented Programming (OOP) and methodologies
• Expertise in Creating Score Cards, Ad-hoc, Parameterized Reports, and drill down reports using different objects in SQL Server Reporting Services (SSRS 2008R2).
• Expertise in Creating SQL Server Integration Services (SSIS 2008R2) Packages for Data Transformations and Loading
• Experience in Kofax Capture, Kofax Transformation Module and administrating Kofax Markview for AP.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2012.
• Hands on Experience in Kalido Master Data Management (MDM).
• Good Knowledge on working with Business Intelligencefeatures ofSharePoint Server 2010like Excel Services, Report Center and, External Data Sources.
• Experience with software development life cycle (SDLC) and Project Management Methodologies.

TECHNICAL SKILLS:

IDE: Microsoft Visual Studio 2013/2010/2008 , Visual Basic 6.0

SharePoint: SharePoint Server 2013/2010, SharePoint Online 2013/2010(Office 365), MOSS2007, SharePoint Designer, Dashboard Designer, Office 2010, Active Directory, SharePoint PowerShell and Axceler.

Core Skills: .NET 4.0, C#, VB, ADO.NET, LINQ, T-SQL, MDX, XML, XAML, COM/COM+, MVC, OOP, Visual Basic 6.0.

Web Development: ASP.NET MVC 4.0, HTML5, CSS3, JQUERY, Ajax, JavaScript, VBScript, XML, XSL, XSLT, WCF, REST, SOAP, WSDL, UDDI

Databases: Microsoft SQL Server 2012/2008R2/2005, Oracle 11g, MS Access 97-2010

Tools: SQL Server Reporting Server (SSRS), SQL Server Integration Services (SSIS), Mercury Gate Edge/MOJO,Kalido MDM and IBM MQ

Web Servers: IIS 7.5/7.0, Oracle Web Logic 11g

Version Control: Team Foundation Server TFS 2010, Visual Source Safe (VSS)

Financial Product: Markview Accounts Payable for SAP with Transformation 8.0, Kofax Advisor 3.5, Kofax Capture 10.0, Kofax Transformation Module 5.5.

Development Methodologies: Agile, Scrum and Waterfall

Platforms: Windows Server 2012, Windows Server 2008R2, Windows 7/XP

Others: JIRA, Remedy, TOAD, MS Excel 2010, MS Visio 2010

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

SharePoint 2013 Development

Responsibilities:

• Responsive Branding (Mobile, Tablet and Desktop) for SharePoint Enterprise Search Center, MySite, Community Portal and Publishing Sites.
• Sandbox Solutions with Custom Master Pages, CSS and JavaScript are created.
• Developed SharePoint App to allow users to dynamically create Publishing pages (with page content as Word Document) for the User Documentation documents in the Site Libraries.
• Modified the Search Refiner Control Display Template.
• Developed PowerShell script to move the SharePoint Library content along with metadata and folder structure to another site library.
• Configured the Search Application in SharePoint 2013
• Created SharePoint Enterprise Search Site
• Crawled the SharePoint Contents and Intranet website (Site Core) Contents to show in the search results.
• Mapping the Crawled properties to Managed properties to show in the search refiners.
• New vertical is created to display the Intranet content in the Search results.
• Result Source is created for Intranet Results and transformed query to filter the content.
• Promoted Results and Result blocks are implemented for better search optimization.
• Suggested the business users to implement search engine optimization techniques in the Intranet Site to get better SharePoint search results.

Environment: SharePoint 2013, Microsoft Visual Studio 2013, SharePoint Designer 2013.

Confidential, Dublin, OH

SharePoint 2013 Migration O

Responsibilities:

• Researched for all the Farm solutions and Sand box solutions installed in SharePoint 2010.
• Reviewed the existing Custom solutions and made the .Framework and code changes to make sure it will work in SharePoint 2013.
• As Visual Upgrade is deprecated in SharePoint 2013, planned for new Master Pages and CSS to match the company branding.
• Documented Site Features for each Web Applications to avoid issues.
• Used same domain group to use existing Service Accounts.
• Sites and sub-sites were created to facilitate the end user of different departments
• Used SharePoint Designer for site customizations to add the Hit count to the page .Edited the master page to display sites for the sub-sites global navigation.
• Created Site columns, Content Types, Lists and Document libraries to different departments and assigned different permission levels according to the requirements
• Developed different types of Views, Alerts according to the business requirements.
• Created Custom ASP.NET, InfoPath and HTML Web Parts.
• Created Content Query web parts to display content from anywhere in your site collection.
• Created InfoPath 2010 forms for user entry using xml, web services, and stored procedures to save the data to SQL Server 2012.
• Modified the existing InfoPath forms which are using SQL SOAP End Points to web services as SOAP End points are deprecated in SQL Server 2012.
• Developed several Performance Point Dashboard, Scorecard, KPI and Reports using dashboard designer getting data from cubes (Analysis Services),
• Extensively worked in Excel Services for displaying various data on Dashboard.
• Responsible for the systems administration of the Pacer SharePoint Intranet. Activities include SharePoint system administration, patching/upgrades, configuration, security, site monitoring and performance tuning, migration of files from share drive to SharePoint library and support. Works with members of the technology team and other departments to define departmental intranet sites.
• Worked extensively with Central Administration portion to perform server reports, manage errors, logging,web applications, site collections and optimizations.
• SharePoint governance is done using Axceler tool.
• Administered SharePoint using PowerShell scripting for installing services, database backup and retrieving the data like user permissions, lists etc.
• Set up SSO integration, configured search, and search scopes
• Extensively knowledge of all features of FAST Search for SharePoint 2010 and how to optimize the user search experience.
• Configured and administered User Profile Service and User Profile Synchronization Service for User profiles, Profile synchronization and Audiences.
• Used Active Directory for creating User, groups and integrated with Central Admin.
• Created a permission matrix for the user access.
• Trained the information workers on creating sites, document libraries, lists, assigning permission to sites, sub-sites, folders, lists and documents (item level security)
• Created documents with screen shots for Creating / editing sites, sub-sites and documentation for adding the documents to each document libraries.
• Created SharePoint groups and assigned different permission levels to different sites.
• Four types of Backup were taken (SQL, STSADM, Share Point designer and Central administration).
• Configured Power Pivot, Power View and PerformancePoint Services (PPS) features for SharePoint 2010.
• Created Power Pivot Gallery to provide rich preview and document management for published Excel workbooks and Reporting Services reports that contain Power Pivot data.
• Exported Lists between different sites using Central Administration.

Environment: Windows 2008 R2, SQL Server 2012, Active Directory, IIS, Microsoft Office SharePoint 2010, Microsoft Exchange Server 2010, Microsoft Visual Studio .NET 2010, SharePoint Designer 2010, Dashboard Designer 2010, InfoPath 2010, PowerShell, Excel 2010 with Power Pivot add-in, Axceler, JIRA and Remedy

Confidential

Web Developer

Responsibilities:

• Worked extensively with Marketing Team for Websites branding.
• Rebranding the Pacer Websites to Confidential using CSS.
• Modifying the Website content and developing new modules such as Quote, Load Tender Forms for Operations Team.
• Extend the Confidential Framework via custom module creation using SQL Server, C#, & Visual Studio 2010
• Meet with business users to determine and create UI/UX needs for web applications
• Design and convert layouts to Confidential skins utilizing CSS, JQuery, ASP.Net & HTML
• Used various DNN modules, and created customized modules for Pacer website.
• Used third party Modules like Coding staff, Iweb (interactive Web)
• Used CKEditor provider for HTML Editor for Confidential .
• Fixing various DNN version IE9 compatible issues
• Worked on DFS file replication on both servers.
• Used HTML Keywords for each page and Sitemap.xml for better search optimization.
• Google Analytics is used to view Page analytics information.

Environment: Microsoft Visual Studio 2010, Confidential, ASP.NET 3.5, HTML, CSS, JQuery, Coding staff modules, Web modules, Windows 2008 R2, SQL

Confidential

SSRS/SSIS Developer

Responsibilities:

• Worked in creating Stored Procedures, tables, views, joins and statements for applications. Developed T-SQL code for the application.
• Extensively used T-SQL to manipulate and architect to produce results for users.
• Worked with development teams in the design of physical databases and in modification.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Created Tabular reports, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created and developed query for Drill Down and AD Hoc Reports using SSRS.
• Created complex reports using MDX QUERY by querying the multidimensional objects such as Cubes and using OPEN QUERY by querying different systems like AS400 using linked server.
• Conversion of Customer Daily Tracing and Drop Reports from Microsoft Access97-2003 to SSRS reports: Rewriting the logic from Access to SSRS and creating Report Email subscriptions for around 200 customers using shared subscriptions in SharePoint.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Used TFS (Team Foundation Server) for source control.
• JIRA for Agile Project Management, updating Issues during Unit Testing and Project status.
• Fixing the production issues and closing the tickets in Remedy.
• Developed multiple windows service applications to automate the process of saving the data from EDI systems using multiple flat files stored in network locations to the Markview Oracle database by calling Oracle API, using Oracle PL/SQL Packages and Stored Procedures to save the data to the tables.
• Developed windows forms for user to view/edit the data using data grids.
• Worked on virtualization of SharePoint Web, APP and Database Servers with Network and DBA Teams to migrate from San Jose to Chicago.
• Worked on virtualization of Reporting Server with Network and DBA Teams to migrate from San Jose to Chicago.
• Restored the Report Server Instance settings for SharePoint Integrated Mode and Native Mode.
• Upgrade of Pacer Web and database servers from Windows Server 2008 R2 to Windows Server 2012 R2.
• Created Application Pools, Websites, modifying the Connection strings and settings in IIS.

Confidential

SharePoint 2007 Developer

Responsibilities:

• Responsible for creating new custom site templates, site definitions, list definitions for provisioning custom sites
• Created custom actions, custom navigation using WSS object model
• Created custom workflows in C#.NET and SharePoint Designer and custom Task Forms in InfoPath 2007
• Worked on extending custom field controls and created FilteredLookupList control by extending SPField class. The control provides n number of hierarchical dependent dropdown list for lookup values in a List
• Created custom dashboards for showing workflow status which included task completed, pending and finished for approval workflows
• Created Custom Content Types to Document Information Panel for Microsoft Word to accept information to be stored inside the list library
• Developing Logical Access Reporting Web Part that allows Manager to see who has access to what sites along with User Permissions under the site collection
• Coded in WSS object model to extend and build Custom Actions, ECB menus to show custom links
• Customizing XSLT for Data Views in SharePoint Designer
• Worked on customization of DispForm.aspx, EditForm.aspx and NewForm.aspx in SharePoint Designer
• Customized search user interface by editing and customizing the XSLT of search results web part on search.aspx page
• Created a new Publishing Portal for Intranet users, created custom master pages for the portal
• Responsible for providing the requirements and client interaction.
• Responsible for conducting weekly meetings with development team.
• Participated in Quality processes such as requirements reviews and documentation.
• Serve as project lead to analyze business and application to make sure all the functionality been captured.

Environment: Microsoft Visio 2007, Microsoft Visual Studio 2010, Microsoft Visual Basic 6.0, MS Word 2007

Confidential

ASP.Net Developer, Visual Basic 6.0

Responsibilities:

• Requirement gathering, client interaction.
• Responsible for conducting weekly meetings with development team.
• Develop proprietary solutions to helping Underwriting Account Teams to establish reinsurance on new business and renewal policies.
• Participation in design discussions.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Serve as project lead to build custom tools for position, profit and loss, exposure reporting, investment modeling, risk management, pricing.
• Designed ASP.NET applications linked to firm-wide SQL databases.
• Created web services for interacting with CORE system for verifying the Reinsurer details.
• Used IBM MQ to communicate with CESAR Mainframe system to retrieve Reinsurer amount details through XML.
• Used Transact-SQL - Queries, Stored Procedures, Views, Functions, Created Triggers and Indexes,
• Writing test cases and doing unit testing.
• Used TFS (Team Foundation Server) for project management and source control.

Environment: ASP.Net, SQL Server 2008, Visual Basic 6.0, IBM MQ, COM, COM+ and TFS.

Confidential

.Net (Web/Windows Developer)

Responsibilities:

• Requirement gathering, client interaction.
• Participation in design discussions.
• Participating and conducting weekly meetings with development team.
• Developed new windows forms and made changes to the existing system according to the requirements.
• Designed ASP.NET applications linked to firm-wide SQL databases.
• Created web services for interacting with other systems.
• Develop proprietary solutions to helping underwriters with Workers Compensation, Loss/Expense Rating and Pricing of the risk and the profitability projections
• Used ADO.Net for accessing data sources such as SQL Server2008/05, MS Access2007
• Created SQL queries for backfill data
• Creation and implementation of canned reports in SSRS 2008.
• Generated the weekly, monthly, and quarterly reports by using SSRS.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Serve as Team member to build custom tools for position, profit and loss, exposure reporting, investment modeling, risk management, pricing.
• Designed VB.NET applications linked to firm-wide SQL databases.
• Used Transact-SQL - Queries, Stored Procedures, Views, Functions, Created Triggers and Indexes,
• Writing test cases and doing unit testing.
• Used TFS (Team Foundation Server) for project management and source control.

Environment: ASP.NET, VB.Net, Visual Basic 6.0, Sql Server 2008, SSRS 2008, TFS 2008 and MS Access.

Confidential

VB6.0 Developer

Responsibilities:

• Requirement gathering, client interaction.
• Responsible for conducting weekly meetings with development team.
• Develop proprietary solutions to helping underwriters with Workers Compensation.
• Participation in design discussions.
• Participated in Quality processes such as design reviews, code reviews, version control and documentation.
• Serve as project lead to build custom tools for position, profit and loss, exposure reporting, investment modeling, risk management, pricing.
• Designed VB applications linked to firm-wide SQL databases.
• Used RDO (Remote Data Objects) to connect to MS Access.
• Writing test cases and doing unit testing.
• Used TFS (Team Foundation Server) for project management and source control.

Environment: Visual Studio 2010, Visual Basic 6.0, Sql Server 2005, TFS and MS Access 97 - 2003.