PROFESSIONAL PROFILE:

• 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 Confidential.
• 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 DotNetNuke (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.
• Having nearly 4 years of Underwriters (commercial property-casualty Insurance) Domain Expertise and 32 Months of Transportation & Logistics Expertise.

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/MOJOKalido 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

RECENT PROJECT EXPERIENCE:

Confidential, Columbus, OH

SharePoint/.Net Consultant

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/.Net Consultant

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.
• Three tier Farm architecture is continued with Two Web Front Servers, One App Server and One Database Server.
• Installing Prerequisites, SharePoint 2013 Products in Windows Server 2012.
• Configured SharePoint 2013 Farm and created Web applications and Site collection with same type of site, port and authentication.
• Copied the backup SharePoint 2010 content Database and attached it to SharePoint 2013 database. Mounted the content databases for each web applications using PowerShell.
• Performed Site Collection Upgrade and installed sandbox solutions.
• Configured Reporting Services for all the site collections.
• Tested all the Web Applications, Service Applications and services (like User Profile Sync, Search service, Excel) to make sure they are running fine.
• Modified the Master Pages and CSS to rebrand the new SharePoint 2013 sites in SharePoint Designer.
• Created Mini Calendar web part and calendar events web part using XSLT, CSS, JQuery, web services and LINQ.
• Created/Modified Style Sheets to change look and feel of the Master Page.
• Created People search Web part.
• JIRA for Agile Project Management, updating Issues during Unit Testing and Project status.
• Fixing the production issues and closing the tickets in Remedy.

SharePoint 2010 Custom Development/ Administrator

Confidential

Responsibilities:

• Communicated and consulted with business users from Accounting, Marketing, Services, Operations, HR, and IT departments to determine site design specs, requirements, & desired functionality.
• Created different Site collections for Pacer and subsidiaries of Pacer International, Inc. like RF International Ltd. &Ocean World Lines Inc.
• 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 Data form web parts to display list data containing User alerts information for the site and libraries.
• Created Content Editor Web Part for displaying the Color Coding Custom Lists.
• Used Audience Targeting forWebParts
• Used company’s Taxonomy to use as Managed Metadata in SP 2010 Term Store Management tool to share content type across site collections, to improve navigation, browsing, search and findability.
• Exported data between Lists usingLINQ Queries.
• Implemented Out of the box Work-flow on the Documents
• 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.
• Fixing the production issues and closing the tickets in Remedy.
• 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

DotNetNuke Web Developer

Confidential

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 DotNetNuke 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 DotNetNuke 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 DotNetNuke.
• 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, DotNetNuke, ASP.NET 3.5, HTML, CSS, JQuery, Coding staff modules, Web modules, Windows 2008 R2, SQL Server 2012, IIS 7.0.

SSRS/SSIS Developer

Confidential

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.

Environment: Windows 2008 R2, Oracle 11g, Web Logic, Microsoft Visual Studio 2010, TOAD

Confidential, Schaumburg, IL

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

Environment: Windows 2008, SQL Server 2008, Active Directory, IIS, Microsoft Office SharePoint 2007, Microsoft Visual Studio .NET 2008, SharePoint designer.

Confidential

Application Analyst / SME

Responsibilities:

• 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

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.