Sql Server Sales

Divyanshu Kshatriya

Cell: - 203-***-****

E-Mail:- abpz2n@r.postjobfree.com

Professional Summary

7+ Years of experience including System Analysis, Design, Development, Debugging and Deployment of Web and Windows applications using Microsoft Technologies.Extensive Experience with design and development using Visual Studio 2010/2008/2005 and .Net Framework 4.0/3.5/2.0/1.1, .Net CLR, C#, VB.Net, ADO. Net, ASP. Net, Web Services, Silverlight, Localization, WWF, WPF, WCF, LINQ and AJAX plus XML applications.Extensive Experience as a Sharepoint Developer with roles involving Installation, Configuration, Development and Deployment of Sharepoint 2010, MOSS 2007 and WSS 3.0.Implemented Sharepoint 2010 features such as BCS, Silverlight Web part, Sandboxed Solutions, Ribbon Customization, Service Applications, External lists, tagging and REST data services for ATOM Data Feeds.Strong experience in creating and deploying Web-parts, their Event Receivers, using CAML query, Custom Content Types, Features using SP Object Model in addition to presentation layer formed by HTML, CSS, Master Pages, Theme and Site Definition.Conversant using Central Administration and STSADM tool as well as PowerShell to deploy/retract solution package, activate/deactivate or install/uninstall features and Backup/Restore.Experience with using Shared Services for Advanced Search with Managed property and Scope.Used and worked with ECM for Web & Document management and provided Security features like Site Permission, Roles Definitions and SSO for SharePoint Services.Worked with the Out of Box Workflows besides tailor made Workflows (Sequential and State Machine) for versatile the business requirements.Experience with but not restricted to Quest and Bamboo web parts, DocAve Backup and Recovery along with BDCMetaMen for XML synthesis.Long term Experience working with InfoPath forms and integrating KPI’s and Excel Reports on Dashboard pages using PerformancePoint Services for monitoring, reviews and audits.Good Understanding of Sharepoint Upgrade or Migration to new farm and Cloud Computing.Experience working with Active Directory and User Profile Management by adding users, granting them permissions and importing the same in Sharepoint.Immense work with databases such as SQL Server 2008/2005 for writing SQL queries, triggers, views, cursors and stored procedures over and above creating reports using Crystal Reports and SSRS.

Skill Set

Programming Languages

C, C++, C#, Visual Basic 2005, PHP

Markup/Scripting Languages

HTML, XHTML, XML, XAML, CSS, AJAX, JavaScript

Sharepoint Technologies

SP Server 2010, MOSS 2007, WSS 3.0, Fast Search Server

Microsoft Technologies

ASP.Net, ADO.Net, WPF, WCF, IIS, Silverlight

Framework Technologies

.Net Framework 4.0/3.5/2.0/1.1

Databases

SQL Server 2008/2005/2000, MS-Access

Software/Tools Worked

SP Designer 2010/2007, Visual Studio 2010/2008/2005/2003, MS Office 2010/2007, Crystal Reports XI, Expressions Blend 4.0/3.0, jQuery AJAX toolkit, TFS/VSS, ADDS, Adobe products (Dreamweaver, Flash and Photoshop)

Operating Systems

Windows Server 2008-R2/2003, Windows 7/Vista/XP

Microsoft CertificationsMCTS: MOSS 2007, Application Development.MCTS: SharePoint 2010, Application Development.

Career Progression

KPMG Grand Rapids, MI June 2012 to Till Date

Sr. Sharepoint Developer

KPMG is the leading provider of audit, tax and advisory services and gives industry insights to help organizations negotiate risks and perform in the dynamic and challenging environments in which they do business. KPMG LLP, the audit, tax and advisory firm, is the U.S. member firm of KPMG International. KPMG International’s member firms have 145,000 professionals, including more than 8,000 partners, in 152 countries.

KPMG maintains different SharePoint Enterprise farms for its external facing site and for providing access to the SharePoint applications to its fortune 500 clients. KPMG has recently acquired EquaTerra Inc. who was well known for their auditing solution called ‘Equasis 4.0’. The product has been redesigned to meet the new requirements/addition to the product by adding multilingual support, removing user dependency, providing the built-in validation and workflow engine and using automation. In addition, the product has been revamped into different services as Advisory Workplace (AWP) and Governance Workplace (GWP) with a new branding and UI.

Responsibilities:-Involved in architecture and development of GWP with development and maintenance for AWP Sharepoint features.Devoted to the simplification of uploading data from Microsoft excel file uploaded in a document library to the designated Sharepoint list by creating a workflow engine and upload wizard.Generating required lists on the feature activation with designated content types including site columns, several views and deleting the same on retracting with multilingual support.Developing the upload wizard to track changes of the user by generating the Sharepoint lists on the fly for each user with session and file information.Extending the Validation Engine to check if the lists are created with proper specifications, implementing the combined key concept and other specifications like if item already exists. Extensive use of jqgrid for the list display and providing the inline editing for the uploaded data or for updating list data.Implementation of modified codeplex solutions like the SPFilteredLookup for getting filtered data from a look up in another list, SPServices to handle queries at client side and EPPlus.dll to work with Excel Packages and workbooks.Creating web part pages and application pages for the AWP and implementing the loading control until the validation and business logic layer is completed.Use of reflection to implement the business logic assembly functions for continuous changing and.Worked in an agile environment within sprints to deliver solutions on time.

Environment:-

Sharepoint Server 2010 Enterprise, Visual Studio 2010, Team foundation Server 2010, Sharepoint Designer 2010, SQL Server 2012, Oracle VM Virtual Box,

General Motors Warren, MI August 2011 to May 2012

Sharepoint Architect / Developer

General Motors is an American multinational automotive corporation headquartered in Detroit, Michigan and the world's largest automaker, by sales. GM does business in 157 countries including producing cars and trucks in 31 countries, and sells and services these vehicles through the following brands: Buick, Cadillac, Chevrolet, GMC, Opel, Vauxhall, and Holden, as well as two joint ventures in China. GM has its own subsidiary which provides vehicle safety, security and information services called ‘OnStar’.

GM maintains SharePoint environment (both Standard and Enterprise) as an intranet infrastructure. With a base of 202,000 employees and triple more (Contractors, Joint Ventures, Consultants and Vendors) users is one of the biggest multi-farm environments spanning across continents. They wanted multiple solutions deployed contributing to keep track of incidents/expenses, keeping track of job postings/transfer/shift change, management of keys and for the testing of the manufacturing parts. Each of these sandboxed solutions needed to be personalized to mix and match the plant/research/quality requirements to help them work efficiently. Farm Level solutions were also provided to get data from external systems.

Responsibilities :-Involved in development and maintenance of Sharepoint Server 2010 applications involving different Farms including Standard and Enterprise CAL’s.Devoted to the personalization, maintenance, support and upgrade of the self-developed applications, web parts, event receivers and workflows for the tools mentioned above.Designing and approval of solutions and workflows strategy to several teams before their solution enters production at farm level.Extended Sharepoint support to the end users in the form of Open office Hour’s where users can walk-in and gets a detailed know-how on the subject.Extensive use of InfoPath forms compatible with both, client and browse-enabled for input from users.Organized workshops for end-users to give proper understanding and use of both OOTB and designer workflows along with help on creation of InfoPath forms. Used OOTB controls to develop the required tools and rolling out small tools as templates to be used across farm.Interacted with the Business owners to understand the evolving requirements and accommodating the same thus by adjusting the architecture of the solution.Published web-services (Full Trust Proxy) to extract the data from the external systems and imbibing the same in the solution.Stored-Procedure, Views and triggers to add additional information to an external database and use the data for development of Sharepoint applications.Wrote documents like design, technical, deployment and End User guide for each solution.Created Unit Test Cases and performed manual testing as well.

Environment :-

Sharepoint Server 2010 Enterprise and Sharepoint Server 2010 Standard, Sharepoint Designer 2010, SQL Server 2008 R2 Datacenter, Visual Studio 2010.

Microsoft Corporation Redmond, WA May 2011 to July 2011

Fast & Sharepoint Developer (SDE)

Microsoft provides comprehensive software, services, and IT solutions to people and companies around the globe. Since its founding in 1975, the company has grown into a multibillion-dollar organization that in 2010 ranked 36 in the Fortune 500 and 115 in the Fortune Global 500.

Microsoft Retail wanted a solution that can help them search faster, efficiently and accept updates many times a day. Before this solution, they themselves being the software giant were using 3rd party solution called Adam. The existing system had many failure points with complications in deploying and updating. Most of the users were external retailers so we gave them a solution that is very presentable and used Fast Search Server for Sharepoint in the backend.

Responsibilities :-Involved in installation, configuration and maintenance of Sharepoint Server 2010 and Fast Search Server 2010 on various environments including DIT and SIT. Moreover, contributed to design and development of the Solution.Designed the search strategy to overcome the difficulty of Classification in both Filter and Refiners and layout to deliver both browsing and searching user experience.Developed the searching abilities using the Fast Search Server using its advanced capabilities like the use of FQL, custom Property Extraction and XRANK.Enhanced the solution by providing integration with the Live-ID authentication in collaboration with Active Directory user support for Microsoft domains using the Security Token Service.Use of Windows Azure caching services to periodically push images to the cloud and pull the images using another publish service.Used Telerik Controls for Silverlight like the Tree view Control, Masked Textbox and Loading/Busy Control etc. to give better feel for the Silverlight UI.Extensively used PowerShell snapin for fast to create Managed Properties and for Sharepoint to create One-click Deployment in addition to Back-up and Crawling.Leveraged the custom BDC model for BCS to help crawling and creation of index.Used WCF Services to defeat the problem of Cross-domain and helped the Silverlight to interact with the Business Layer.Large use of LINQ objects for the IEnumerable objects of Silverlight MVVM model and XML conversions as data packet.Special business requirement of showing None in refiners to be shown where no information is available so they can be proactive to provide the missing information.Worked on translation of information returned from Fast Search Server response to make it user understandable.Extraction of Information with inclusion of additional data using the Stored-Procedure.Provided the application its Master Pages along with CSS.Wrote Test Automation and Unit test cases.

Environment :-

Sharepoint Server 2010 Enterprise, Fast Search Server for Sharepoint 2010, Sharepoint Designer 2010, SQL Server 2008 R2 Datacenter, Visual Studio 2010, Windows Azure SDK, Microsoft Test Manager 2010.

Lerner Publishing Group Minneapolis, MN April 2010 to April 2011

Sharepoint Developer/ Administrator

Lerner Publishing Group is one of the nation’s largest independently owned children’s publishers with more than 4,000 books in print. They publish nonfiction and fiction books for pre-school to young adult readers and for libraries, classrooms and homes across the country.

Lerner Publishing Group wanted to enter market of digital marketing and create a more engaging experience for customers comprising mainly of primarily librarians and educators who earlier relied on printed catalogs and placed orders using the phone, fax, or mail. They used SharePoint Server 2010 for their new website, which includes e-commerce functionality and connects to book title management and pricing systems. As early feedback has been positive and the publisher has been focusing to expand direct-to-consumer sales promotion.

Responsibilities :-Involved in design and development for building the intranet and internet application.Worked on Sharepoint Designer to create Master Pages, CSS and Page Layout for the branding of the product by providing unique look.Designed and developed Custom data driven web parts and connected web parts (Farm Level and Sandboxed) using CAML and LINQ queries along with configurable Web parts to connect to third-party social networking sites, such as Twitter, Facebook.Provided Customized Ribbon, menu, dialog box and navigation using the JavaScript.Integration with Non-Microsoft products as a back-end information System e.g. UNISON (ERP) and TurboWYNK (Book Title Management System) over and above provided Searching capabilities and use of Business Objects to incorporate into current lists using BCS optimizing business performance.Created custom InfoPath 2010 forms to collect feedback from the customers and published them to SharePoint form Library and integrated the same to the Workflows for evaluation.Additionally, creating out of box Workflows for Approval, Review and other business needs.Enhanced and extended the SharePoint Server 2010 environment along with integrating e-commerce functionality through Microsoft Commerce Server 2009.Administrative responsibilities include regularly performed Backups and if required Restore using DocAve, installing features and providing RSS feeds.Developed and managed the forums, blogs and posts for their blogging site.Developed separate section of intranet site for easy Content Management and Mass Updates from the pricing system.Developed Customized Advanced Search, Search Results, and Core Search Results Web parts as with the FAST Search Server for different parameters like Books, Authors and Grade etc.Addition of Rich previewing tools, full reviews, awards, descriptions, and book features for the each Book listing in the Document Library which provides uniqueness to the product.Building Extranet for the sales team integrated to show KPI’s and reports for sales reports, customer order status, marketing collateral, commission’s information using the Dashboard with the BI tools.Involved in preparing various Technical and deployment (VDD) documents.

Environment :-

Sharepoint Server 2010, Sharepoint Designer 2010, Commerce Server 2009, SQL Server 2008 Enterprise, Visual Studio 2010.

MediaNews Group Denver, CO August 2009 to February 2010

Sharepoint Developer

MediaNews Group is the second largest Media Company in the United States. Driven by their deep heritage in newspapers, MediaNews Group provides the highest quality news and media content to their audience base.

MediaNews Group wanted to provide online offerings of news, e-editions, mobile websites, email programs and social media feeds. They aim to extend that reach for even higher market penetration and unifying the user base. The whole rebranding of the MediaNews needed to be performed along with its subsidies i.e. local websites. They also needed notification service for the customers.

Responsibilities :-Involved in the development of internet site of MediaNews and extranet site for collaboration between its localized newspaper sites.Largely used the modified XSL contained Content Query Web Part and the Data view Web Part to combine the data and view the information as data is spanned over a very large geographical area and different networks.Created Several Connectable Web parts by creating custom interface for sales and marketing team.Developed Page templates and List templates, Site Columns and Content types for code reuse.Actively used KPI’s to demonstrate the Sales of every region derived using the Excel Services.Amplified use of Bamboo Web Part ‘Chart Plus’ to represent the Dashboard data into representational form of Bar, Stacked Bar, Line, Area, Stacked Area, Pie, Bubble and Gantt Charts.Created remote logging using Forms Authentication. Built Feature Receivers & Event Receivers for the list level events.Generated reports for analysis of market growth, production and profits using SSRS and showed monthly growth for the Dashboards.Used Out-of-Box Approval and Feedback Workflows furthermore built timeline based approval workflows to reflect the status of the weekly editorials.Use of BDC to get the data from the external data source systems.Dedicated ample time to provide customized Web Parts and navigation to MySite. Moreover demonstrated and provided training to the employees for the site use and interpreting data.Designed and created InfoPath Forms to receive the draft user articles.Created WSP to deploy the Features along with the installation steps.

Environment :-

MOSS 2007, Windows Server 2003 R2, ADDS, Visual Studio 2008, SQL Server 2008.

FICO February 2009 to June 2009

Sharepoint Developer

FICO is the leader in Decision Management, transforming business by making every decision count. They use predictive analytics to help businesses automate, improve and connect decisions across organizational silos and customer lifecycles.

FICO had Outdated Web Site, Inefficient Content Management and different IT environments for its Web site and its intranet. They had different IT teams maintaining the internet and intranet solutions. Their very own website was hard-coded with ASP with virtually no dynamic content exception ‘Contact us’ page. They were huge delay in publishing the content as it needed IT help. They decided for migration to MOSS 2007, thereby standardizing same IT infrastructure across intranet and Internet environments.

Responsibilities :-Participated from ground up including configuration and deployment of MOSS 2007of the portal.Extended the Enterprise advance search to provide fruitful results resulting in annual savings of $40K.Designed and developed Site, Sub-Sites, Document Workspace, Document Libraries, Calendar, Task, Lists, List Views, Navigation and custom lists to provide sync between employees in the organization.Implemented the ‘Impersonation’ in web parts to show user statistics and contribute to site.Enhanced security by implementing custom permission level, groups, Item level Security and Audience.Provided customized Alerts and Announcements on the internet portal for general viewings.Incorporated the well appreciated Graphical Interface into the Sharepoint environment as a Master Page and designed workflows to automate the business processes using Sharepoint Designer.Created Site Permission, Roles Definitions and Audiences for the security of end product.Used the Administration tools including Central Administration and command-line tool STSADM used to maintain SharePoint farm.Created extensive search capabilities including quick and more advanced search with multi-faceted filters.Custom development of multiple web parts using LINQ queries.Integrated Report Center and viewer web parts to display activity reports.

Environment :-

MOSS 2007, Windows Server 2003 R2, Visual Studio 2008, Sharepoint Designer, SQL Server 2008.

Montefiore Medical Center, NYC NY October 2008 to January 2009

Sharepoint Developer

Montefiore Medical Center serves the community by healing, teaching and researching for advancement of the health. Their vision is to be premier academic medical center that transforms health and enriches lives.

Montefiore Medical Center wanted Content management system to log their researches. They wanted to quickly deliver medical and statistical data on treatments and outcomes to help doctors improve the quality of care and services. Earlier a team had to extract charts, compile data, conduct an analysis and then write up and distribute the results. It was reduced to a great length by the use of ‘Clinical Looking Glass’ solution.

Responsibilities :-Introduced in the development of the MOSS 2007 solution and helped them it integrating with a working ASP.Net website.Developed and maintained wiki site where the analysis reports are stored. Furthermore a copy of the uploaded file is also sent to Record Center.Developed several custom Search Results Web Parts which provides results from specified Search Scope to help physician get pre-compile data either by diseases or by symptoms.Involved in showing Excel reports in Excel Web Access Web part from trusted file locations.Collaborated in the generation of Site Definition, Content Types and KPI lists.Customized UI with the SharePoint Designer and built Page Layout.Redirection to Google Search results by using the GET Method and Integrated Google Book Search for advanced area of interest.Designed web services using WCF to access business data in SOA.Implemented LINQ & CAML queries on different data sources as well as lists.Implemented form authentication of the patients to log and check their due and maintained their profile.

Environment :-

Visual Studio Team System 2008 Team Suite, MOSS 2007, Team Foundation Server, Windows Server 2008, IIS 7.0, .NET Framework 3.5.

Vana Services Bangalore, INDIA July 2007 to June 2008

.Net/Sharepoint Developer

Vana Services is engaged in the development, production and marketing of Microsoft Sharepoint and related products with precise execution and quality delivery of solutions. They aim to be the best provider for Sharepoint based solutions.

Responsibilities:-Involved in development, deployment and debugging using flow development on the various projects performed by the company.Primarily designed and developed Custom web parts.Developed both synchronous and asynchronous Event Receivers to perform data validation and to ensure data integrity.Involved in development of BDC connected layer to access backend LOB across different platforms for fetching data.Used Excel Services to display alerts and indicators.Use of personalization by the creation of different skins and Themes/Master Pages.Facilitated the SSO and Customized Login Control

Contact this candidate