Sql Server Microsoft Office

Abhinav Khare

Summary:

** **** ***** ** ******** experience in Sharepoint/.net Applications development, analysis, design, testing and implementation of various Internet, intranet and client-server applications. the software industry with the development of multi-tiered client/server and intranet applications.

Expertise in Web Application development using C#, VB .Net, ASP.NET, ADO.NET, ASP, XML, HTML and knowledge of Web forms.

Extensive experience in developing collaboration portals using MOSS 2007/SharePoint 2010, Windows Sharepoint services 3.0/2.0.

Expertise in the areas such as application design, and development

Extensive experience in ASP, VB Script, Java Script, VB 6.0, MS SQL Server 2000/2005, COM/DCOM, ADO.

Extensively worked on Front-end tools Visual Studio .Net 2005, 2008, 2012 and Visual Studio 6.0.

Over 5years hands on experience in portal solutions with Microsoft Sharepoint technologies working knowledge and experience in installation configuration administration and customization of intranet and extranet portal built on MOSS 2007 and SPS 2003.

Experience in Branding corporate portal by creating and manipulating site definitions. Worked Extensively with Sharepoint Designer-2010/2013, to maintain consistency in the look and feel of the Sharepoint Portal. I have worked as Sharepoint Developer and Administrator.

Excellent Client Support service skills.

Excellent ability to multitask and prioritize in fast paced environments.

People oriented with a courteous, professional, and customer-focused attitude.

Extensive experience in developing custom solutions for the portal like Web parts, Custom Web pages and Workflow solutions using VS.Net 3.0/4.0.

Experience in creating services using Sharepoint Object model for performance improvement.

Experience with Market making and smart order routing applications.

Technical Skills:

SharePoint Technologies

Microsoft Office SharePoint Server 2007/2010/2013, SharePoint Portal Server 2003, WSS 3.0/2.0, SharePoint Designer

Languages

C#, Visual Basic 6.0

Microsoft .Net

WebForms, ADO.Net, ASP.NET, Remoting, Web service, Reflection, Window Services.

Web Development

ASP.NE, ASP, JavaScript, HTML, VB Script, VB,IIS 5.0/6.0

Design

Visio 2003 / Microsoft Project 2003/2010.

Development Tools

Visual Studio 2005, 2008, 2012 Visual Studio 6.0,Sql-Server2005

OS

Windows Server 2003, Windows XP, Windows 95 / 98 / NT 4.0 / 2000,Linux,Sun Solaris

Databases

SQL Server 2005/2000, Orale9i/11g, MS-SQL 2000, MS-Access 97/2000.

Office Technology

InfoPath 2007/2010, MS Office 2007, MS Office 2003

SCM Tools

Microsoft Visual SourceSafe, Clear Case

Tools and Technologies

ADO, XML, Shell Script, ActiveX, COM/DCOM, SQL DMO, MS Office SDK, Source Offsite, Visual Studio Installer, Automated Build Studio, Crystal Reports,Sql-Server2005

Professional Experience:

Credit Suisse, NY March2012 – Till Date

Sharepoint Technical Lead/ Architect

Project Title: ARMS

Description: This is an Account Relationship Management System where regional manager can create the account for his/her clients on the basis of his/her asset values. In this system Manager can also plan his/her customer’s investments and can also do the investment on behalf of the clients. Here we also capture all personal information of the clients.

Responsibilities:

Created the governance and policies for different environments. Also created the topology for the new infrastructure.

Performed data analysis part for giving the data feed to another system.

I also build the server for SSRS and BI team which windows 2012 and Sql Server 2012.

I was also responsible to coordinate with different teams which includes offshore.

I also lead a team and responsible for their performance review.

Created several complex SQL queries and finding out the requested business data.

Designs, develops, and implements processes, systems, technology to enhance the technical support function.

Lead resources operations from India and work with other stakeholders across the globe.

Be responsible for accurate reporting and SLA compliance as deemed appropriate.

Branded the portal by customizing the site definitions and the team sites to give the corporate look and feel.

Responsible for DR plan and it’s execution of all web and DB server owned by our division.

Designed and deployed SharePoint Server Farm/Infrastructure with Failover, redundancy and disaster recovery planning. Provided Capacity planning, Architecture and Taxonomy, researched and resolved issues related to User access level, Index, Query and Search Servers.

Environment: Microsoft project 2010, Microsoft Office SharePoint Server 2010/2013, Windows SharePoint Services 3.0,SSRS, SSAS, SharePoint Designer 2007, InfoPath 2007,ASP .NET, Web Services, Linq query, C#, Visual Studio .NET 2010/2012, Microsoft Team Foundation Server, MS SQL Server 2012, IIS 6.0.

HBO, NY Jan2010–Feb2012

Senior Programmer/Support Analyst

Project Title: IT Contract

Description: This application used for newly vendor request for any H/W or S/W in which project manager and senior management do the budgeting and planning for whole IT department. This request has been approved Mgmt., Legal and Account deppt.through this application. IT DBA and administrator are also users and they are maintaining their server status and configuration.

Responsibilities:

Responsible for form designing using Win Forms.

Responsible for writing the validation control using C#.Net.

Plan and developed the organization of documents, Identify document management roles, Plan how content moves between locations, Plan content control, Plan workflows, templates to use for each type of document.

Worked on metadata to provide for each type of document, where to stored documents at each stage of a document's life cycle, Design control access to a document at each stage of its life cycle.

InfoPath forms for internal departments and implemented as content types. Deployed and configured Sites Collections, sites, lists and web parts.

Designed custom Web Parts, converted XML and XSL to XSLT views by C# & ASP.net in Visual Studio 2008 and deployed via Solution packages.

Design reports from SSRS and SSAS system for implementing BI. Created multiple interfaces saving these reports in different formats like (Ms-Excel and MS-Word) for component reusability. Progress reviews, task allocation of resources and preparing estimates.

Used Excel services in BI

Used KPI to display various reports and goal using dashboards in Web Parts as a part of BI

Developed stored procedures and SQL queries in Sql-Server using DDL and DML statements.

Performed installation and configuration of the SharePoint Server 2007 along with office 2007.

Created master pages and corresponding content pages to change the look and feel of sites. I have also created the Site template and list templates.

Used SharePoint Designer 2007 for branding and customizing SharePoint Server 2007 by modifying Master Pages.

Created custom Site definitions based on default STS site definition (team site) for individual order’s page and for master order’s page.

Designed Content management for author and publish contents. Created Content types.

Designing, deployment and administration of SharePoint/MOSS 2007/2010 server farm consist of Web Front End, Database, Search, Index and Query Server on Windows Server 2003, IIS, and managing Central Administration Site.

Designed and deployed SharePoint Server Farm/Infrastructure with Failover, redundancy and disaster recovery planning. Provided Capacity planning, Architecture and Taxonomy, researched and resolved issues related to User access level, Index, Query and Search Servers.

Worked with the ribbon UI for Customizing share point pages and sites.

Environment: Windows Server 2008, Share Point 2010, Microsoft Office SharePoint Server 2007, Windows SharePoint Services 3.0,SSRS, SSAS, SharePoint Designer 2007, InfoPath 2007,ASP .NET, Web Services, Linq query, C#, Visual Studio .NET 2008, MS SQL Server 2005, IIS 6.0.

E*Trade Financial, VA Jan 2006 – Nov 2009

Support Engg.

Project Title: Collection Management System

Description: The Collection Systems focuses on the tracking and management of Delinquent customers. The system helps to queue up cases based on client risk Profiles and then allocates the cases to collectors based on user-defined logic. The system helps builds Customer delinquency history that can be used in the setting up

of credit parameters forfuture product offerings. The system also aids in building databases of negative list/default customers.

Responsibilities:

Installation and Administration of SharePoint Portal Server 2003

Migrated various SPS 2003 sites to MOSS 2007. All Libraries and list using gradual upgrade migration method.

Created Team Sites, Document Libraries, Lists, Security Groups and Users.

Developed dash boards for various departments, developed custom Web Parts for the dash boards.

Configured indexes and searches for the SPS Portal

Server maintained backup and restore mechanism for the portal site.

Designing, deployment and administration of SharePoint/MOSS 2007 server farm consist of Web Front End, Database, Search, Index and Query Server on Windows Server 2003, IIS, and managing Central Administration Site.

Designed and deployed SharePoint Server Farm/Infrastructure with Failover, redundancy and disaster recovery planning. Provided Capacity planning, Architecture and Taxonomy, researched and resolved issues related to User access level, Index, Query and Search Servers

Developed expertise in understanding the Support processes.

Recommended utilization of Ctrl M Jobs which feeds the Production/UAT DB daily from external sources (Pershing, Reuters).

Managed security on the portal and through, created different security groups with different accesses. Also used audience targeting for confidential data and information of users.

Created lookup fields to link to list items. Implemented complex solutions using event handlers (Lists, Items).

Responsible for software upgrades and patching, new SharePoint contents site branding by master pages, responding to end-user questions, concerns, and requests from the Help Desk, assisted business users in the creation and management of their team sites.

Environment: Beta version of MOSS 2007, Share Point Portal Server 2003, WSS 2.0, SQL Server Reporting Services, Windows Server 2003, SQL Server 2005, Windows Server 2003, Microsoft Office SharePoint portal server, InfoPath 2007, Windows SharePoint Services 2.0, ASP .NET, C#, Visual Studio .NET 2005, MS SQL Server 2005, IIS 6.0.

Fidelity Investments, MA Feb 2003 – Dec 2005

Senior Programmer Analyst

Project Title: FIMC Reporting System

Description: Reporting system is developed by FIMC team for UTS/WSTS system, FIMC Engg., Pace System, Adlex system. This reporting system shows the reports for all these system for the reviewing of the senior management. User can get a quick look for reviewing their team’s task and performance.

Responsibilities:

Installation and Administration of SharePoint Portal Server 2003.

Migrated various WSS 2.0 sites to SPS 2003.

Created Team Sites, Document Libraries, Lists, Security Groups and Users.

Developed dash boards for various departments, developed custom Web Parts for the dash boards.

Configured indexes and searches for the SPS Portal Server maintained backup and restore mechanism for the portal site.

Supported and trained end users on WSS and SharePoint Portal Server, and provide strategic guidance on best practices for utilizing its functionality

Responsible for GUI designing using ASP.Net.

Created Interface that automatically updates the status of the exported contracts.

Created multiple interfaces saving these reports in different formats like (Ms-Excel and MS-Word) for component reusability.

Involved in progress reviews, task allocation of resources and preparing estimates.

Architected, developed, and deployed enterprise-scale SOA solution that enables consumer applications to read and write to/from legacy data historians

Determining cost and feasibility of architecting a solution that will provide Audience Targeting to a mixed user base in an intranet, extranet, and internet environment

Architected and developed a SharePoint portal sites which enables employees to collaborate, share and access documents and information efficiently.

Developed custom WebParts making use of the SharePoint object model

Developed WebService consumed by SharePoint XML WebServices data view WebParts

Assisted client personnel with advanced SharePoint topics.

Worked through a list of issues presented by client and mentored individuals on technical aspects of SharePoint implementation.

Provided daily support on SharePoint, Security, Document Libraries, and Lists to employees.

Environment: Share Point Portal Server 2003, WSS 2.0, SQL Server Reporting Services, Windows Server 2003, SQL Server 2000

Project Tile: Future Dated Transaction System (FDTS)

Description: The Future Dated Transaction System is an intranet-based application

that facilitates the user to enter the future dated transactions of type CASA to CASA,

GL to CASA and CASA to GL. Each day it will generate the Hand-Off file (delimited

file) of the approved transaction of that business date. This Handoff file goes to

another system as an input.

Responsibilities:

Developed the User interface using WinForms.

Developed the code behind logic in C#.NET.

Used ADO.NET to code a data layer.

Generated reporting services graphs and reports to view the survey data.

Involved in reviewing the stored procedures and database schemas.

Involved as a team member for the system development proposal.

Involved as a team in developing the software requirement specifications, test cases and designing modules.

Environment: C#.NET, SQL Server 2000, ADO.Net, Windows 2000, ASP.NET

Shinsei Bank, Japan Oct 2001 – Jan 2003

System Analyst

Title: Defined Benefit and Defined Contribution

Description: In Defined Benefit, we have multiple applications like Net Benefit, VRS, and DBDesktop and similarly we have multiple applications in Defined-contributions like Commando, Predator etc. All these DC applications are based on IIS, ASP and .Net

Responsibilities:

Responsible for getting the work from Fidelity US to India.

Requirement gathering for the work.

Attending meeting with Client on Work on weekly basis

Analyzing Data at Database level using SQL’s.

Creation of different Procedures and functions.

Wrote Shell Scripts for automating the routine task and create new tools fro deploying the applications.

Providing Application / Product Support to the worldwide clientele on applications like Defined Benefit, Net Benefit, and Defined Contribution which present the information related to client savings and price of stocks in Mutual Fund.

Maintaining a good cycle time for closing of the problems by the worldwide clients.

Creating Jobs on Control-M

Developed many reports using scripting language which are now in production within the given time frame. I have also optimized the SQL query for performance improvement of the report.

Created reports using Java Script functions .It improves the performance of the report as well as the loading time of the report from the web.

Environment: ASP.Net, C#, VSS, Oracle8i, IIS 5.0 Web server, Windows XP/2000

General Electrical Consumer Finance, India April 2000 – August 2001

Developer

Project Tile: L’Eagle System

Description:The L-Eagle software is an automated system, which will provide a complete solution to all the processing’s involved in legal tracking of delinquent cases for recovery. The software will cater to those cases where recovery of money is not possible without a legal processing.

Responsibilities:

Responsible for Gathering & Analyzing functional requirements with P.S. team.

Responsible for GUI Design using ASP (Java Script and VB Script)..

Design and Coding of business objects, façade, Interfaces and Remoting using VB.

Created customized reports using Crystal Reports 11.0 and deploying them on Business Object Server.

Used VSS tool for change control and bug tracking.

Used Automated Build Studio for building and deployment of the application.

Involved in Unit Testing, Debugging and code review process.

Used Visual Source Safe for version control.

Maintenance and support for the products as per the client’s requests.

Environment: ASP3.0, VB Script and Java Script, VSS, IIS 5.0 Web server

Educational Qualification: Master in Computer Applications, India

Contact this candidate