SUMMARY:

• I am a Microsoft SharePoint Certified Technology Specialist (MCTS) with 10 years of experience in proven track record of exploring latest technology and available resources to offer superior and timely solutions.
• SharePoint/ SQL Database Administration specializing in operational support in a multi - DBMS environment.
• Demonstrates flexibility in supporting several platforms, Customer focused, self-motivated, and strategic. You will find that I have a very curious personality with a desire to understand how just about everything works.
• Migrated complex farms with DB Attach, and using tools like Doc Ave, Metalogix, Sharegate from 2007 to 2010, and 2013, and office 365.
• Building Solutions using Nintex Workflow 2010/2013, and Nintex Forms 2010/2013 in SharePoint 2010/2013 on premise and office 365.
• I can write PowerShell, batch (DOS), VB scripts. Configuring and fine tuning SSRS, SSAS, SQL MDS, SQL DQS and write SQL/TS-SQL queries
• Designing SharePoint sites (masterpages/layouts/CSS), create sample solutions using C#, HTML, debug the code, creating event receivers, workflows, site definitions, timer jobs using Visual Studio.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, HTML, XML, CSS, .net

Database: MS-SQL Server 2000/ 2005/2008/ 2012/ 2014, Microsoft Access

Operating System: Windows 9x/2000/XP /Home Vista/7/ 10

Web application Tools: SharePoint 2007/ 2010/ 2013/ 2016

PROFESSIONAL EXPERIENCE:

Confidential, Mclean, VA

SharePoint Team Lead

Responsibilities:

• SharePoint Administration:Solid exprience installation of SharePoint version 3.0, 2007, 2010, and 2013 and installing third party solutions. Including SQL server Administration.
• Maintanance of existing farms, applying fixes, upgrades, service applications configuratons
• Health Monitoring of the servers, threshold limits, Storage capacity/enhancing, backup/restore
• Load Balancer configurations and monitoring
• ADFS, Search and workflow manager configurations and troubleshooting
• Metalogix, Doc Ave and Sharegate tools expertise to govern SharePoint
• Generated STSADM/Power Shell utilities for various requirements
• Managed SharePoint Security and SP2007 SP2 security break issue, and information policy management
• Configuring BCS and service accounts
• IIS Web farm Framework installation and maintenance
• Develop data loss prevention and retention policies for Office 365 in alignment with DGS Media Protection and Sanitization Policy.
• Identify appropriate security policies to ensure compliance with HIPAA and IRS 1075 security requirements.
• Developed Questionnaire for assessing SharePoint farms to Migrate
• Analyzing the 2007 farm topology, architecture, software/utility versions, and focusing on the improvisation with migrations in the target farms
• Specialized to assess the environments in 2007 and 2010 and segregate the components which can be migrated and which can't
• Providing side by side comparison's with tools DocAve, Metalogix, Sharegate etc., tools Vs Service purchase options, each Tool has its own limitations and advantages
• Double hop Migration from 2007 to 2013 and handling FAB40
• Setting up staging farms to run Pilot Migration with complex components and assessing the migration outcomes
• Migrated selective site collections to Office 365 using tools
• Optimizing the farm with SharePoint governance for security permissions, document versions, list item versions, threshold limits for lists, document libraries, BDC content, scheduled backup's, offsite back up's etc. Set up Infrastructure for SharePoint 2013 on premise App Model with S2S protocols
• Developed Project Plan for Migration with Major Mile Stones
• Customized Master Pages using HTML5 and CSS3.0 responsive design
• Expertise Using Design Manager customization of master pages
• Defining, enhancing and implementing branding standards for the organization
• Using Jquery/JqueryUI libraries, SharePoint Designer, Site Templates, Page Layouts, Web Templates, Site Definitions

Environment:

• MOSS 2007/2010
• MS SQL Server 2008 R2
• T-SQL
• SQL Server Management Studio
• CSS
• Microsoft Visual Studio 2005/2008
• Active Directory.

Confidential, Bethesda MD

Database & SharePoint Developer/Administrator

Responsibilities:

• Administration of Microsoft SQL Servers on Windows XP Platform and Windows 7 Platform.
• Developed Custom Web Parts, Event handlers, Workflows, Timer job, Custom Actions for SharePoint Designer Workflow using ASP.NET (C#) with SharePoint API and CAML Queries
• Implemented the Custom InfoPath forms in 2007 for Digital Signature workflows
• Implemented the custom Event handlers on list / library and sandbox solutions
• Routine Hourly, daily, weekly and monthly database backups and rebuilding indexes and running of update statistics on PROD databases.
• Did database normalization and setup primary key, foreign key and unique constrains. Wrote scripts to create tables and indexed views.
• Built SSIS Packages import export from different types of files as well as to transfer data in and out of the Extract, Stage and Production Servers.
• Wrote and tested stored procedures, functions, triggers, T-SQL queries using query analyzer in SQL SERVER to update views, tables used in different stages of reporting.
• Created Cubes, dimensions, measures and define calculated members using SSAS.
• Maintenance plan for Database Backups weekly, bi- weekly and monthly plans into Disk.
• Responsible to give permissions to internal users and create new users in Database as well as SharePoint website.
• Maintaining of Users and Roles by providing Security to databases using Windows Authentication.
• Develop reports using SSRS depending on the client’s needs.
• Experience in writing Distributed Queries between SQL Servers.
• Expert in implementing business logic and procedure in backend using complex Stored Procedures and effective Functions.
• Extensive knowledge in Tuning T-SQL queries (DDL and DML) to improve the database performance and availability.
• Expert level skills in Objects creation such as Tables and Views, User created Data Types, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Full Reporting Life Cycle Support using MS SQL Server Reporting Services (SSRS).
• Expert in extracting and transforming data using DTS Import/Export, DTS Packages, SSIS, Bulk Insert and BCP (SSIS).
• System monitoring and log analysis.
• Troubleshooting SharePoint 2010 application issues.
• Administration of load balanced environment of high availability farm.

Environment:

• MS SQL Server 2005/2008
• T-SQL
• SQL Server Management Studio
• MOSS 2007/2010
• WinCVS
• Eclipse
• CSS
• Microsoft Visual Studio 2005/2008
• Active Directory.

Software Developer/Administrator

Confidential, Fairfax VA

Responsibilities:

• Delivered the final Report using the Request Handler.
• Responsible for data model changes for new requirements.
• Responsible for writing T/SQL procedures for the AVS application.
• Created and maintained reports for AVS based on business requirements.
• Responsible for updating SharePoint site collection with the newly created reports.
• Maintained data sources for the SharePoint site collection.
• Responsible for administering the database and tuning the DB.
• Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.

Environment:

• MS SQL Server 2005/2008
• T-SQL
• SQL Server Management Studio
• SQL Server Profiler
• MS Excel
• Windows XP/7
• Java 5
• Jboss
• WinCVS
• Eclipse
• Java script
• Microsoft Visual Studio 2005/2008
• .NET Framework 2.0.

Software Developer/Administrator

Confidential, Reston VA

Responsibilities:

• Installation & configuration SQL 2005 & 2008 on Windows XP & 7, apply SP and security fix.
• Routine Hourly, daily, weekly and monthly database backups and rebuilding indexes and running of update statistics on PROD databases.
• Migrated databases from SQL Server2005 to SQL Server 2008.
• Migrated Databases from Dev to Integ and Integ to Local UAT and Local UAT to Client UAT.
• Designing new application including table design and new modules and handling them independently.
• Involved in documentation of the whole process.
• Performed Query Optimization, Performance Tuning by using SQL Profiler and Index Tuning Wizards.
• Established log shipping between Primary sever and Stand by Server.
• Maintaining of Users and Roles by providing Security to databases using Windows Authentication.
• Monitoring Server Performance Activities such as Batch Jobs and DTS packages, User Sessions for Blocking and deadlocking.
• Maintenance of Change control and version control for the database objects and Scripts.
• Prepared standards for Backup and recovery procedures.
• Database code reviews and prepared standards for Stored Procedures/tables/UDFs/Triggers/Views.
• Created tables, views, indexes, functions, stored procedures, triggers, DBLinks, cursors and packages.
• Developed procedures to convert data from one DB to other by applying business rules.
• Created procedures to load data from external files to database by creating and dropping temporary tables, using the dynamic SQL. Tuning Queries, created necessary indexes.
• Created trigger’s to track the details of the users who created and obsolete the Items and Added new triggers and edited the existing ones to incorporate new requirements.
• Applying DB patches on DEV/TEST/UAT (User Acceptance Testing) Production servers.
• Converted DTS packages, SSIS used in the legacy system for XIRR return calculation to SSIS packages. Created SSIS, DTS packages to import data from various sources.
• Created SSIS Packages to import and export data from Excel, Access, SQL Server 2005/2008 and Text files.
• Trouble shooting of maintenance jobs on Prod & DR (Disaster Recovery) servers.
• Enhanced a module which generates reports in .pdf, .xls
• Selected the required information using the Data Provider which is connected to the source of the data.
• Delivered the final Report using the Request Handler.
• Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.

Environment:

• MS SQL Server 2005/2008
• T-SQL
• SQL Server Management Studio
• SQL Server Profiler
• MS Excel
• Windows XP/7
• Java 5
• Jboss
• WinCVS
• Eclipse
• Java script
• Microsoft Visual Studio 2005/2008
• .NET Framework 2.0.

Confidential, Alpharetta,GA

Software Developer/Administrator

Responsibilities:

• Administration of Microsoft SQL Servers on Windows 2003 Platform.
• Installation & configuration SQL 2000 & 2005 on Windows 2003, apply SP and security fix.
• Scheduling SQL Server Agent Tasks to Routine Hourly, daily, weekly and monthly database backups and rebuilding indexes and running of update statistics on PROD databases.
• Migrated databases from SQL Server2000 to SQL Server 2005.
• Migrated Databases from Dev to Test and to UAT.
• Coordinated with business analysts to affect database changes necessary to meet business requirements.
• Designed ETL packages for different heterogeneous data sources (SQL Server, Flat Files, and XMLs etc).
• Worked extensively on ETL - Data Extraction, Transformation, Loading with Oracle, Teradata and SQL Server using SQL Server 2005 / 2000 DTS.
• Converted DTS packages, SSIS used in the legacy system for XIRR return calculation to SSIS packages. Created SSIS, DTS packages to import data from various sources.
• Setup & Monitoring of Replication agents and trouble shooting while any issues found.
• Trouble shooting of maintenance jobs on Prod & DR servers.
• Created both automated and manual reports using SSRS (SQL Server Reporting Services).
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.
• Did database normalization and setup primary key, foreign key, and unique constrains. Wrote scripts to create tables and indexed views.
• Created the RDL for the Report from the Report Processor .Translated the expanded Report Layout into the Requested Output format using Renderer.
• Delivered the final Report using the Request Handler.
• Collect Source data from Confidential Database
• Provide Weekly Status Reporting and conduct Monthly PMO reviews
• Run master Stored Procedure in its entirely to determine speed and perform other performance tuning needed
• Implemented a very new command prompt utility T-sql cmd which is supported by SQL Server 2005 to execute the Transact - SQL(T-SQL) batches, stored procedures and to handle errors

Environment:

• MS SQL Server 2000/2005
• T-SQL
• SQL Server Management Studio
• SQL Server Profiler
• MS Excel
• Windows XP
• ASP.NET2.0
• C#.NET
• ADO.NET
• Microsoft Visual Studio 2005
• .NET Framework 2.0.

SQL Developer

Confidential

Responsibilities:

• Designed and analyzed the SQL Server database and involved in gathering the user-requirements
• Developed logical and physical design of database for project on basis of user requirements
• Created look up tables to match the students login with their password.
• Converted Logical Database Diagram into Physical Schema using the balanced Normalization in 2nd and 3rd Normal Form for highest performance.
• Created jobs which will alert the librarian when the student does not return the book before the due date
• Created stored procedures, which returns the information of the student based on his library card number.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Implemented DTS packages to Extra, Transform, Load from Flat files, Oracle 8i into SQL Server 2000. Data migration (import & export - BCP) from Text to SQL Server.
• Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored proc and maximized the readability of such Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Performed data conversions from flat files into a normalized database structure.
• Configured Server for sending automatic mails to the respective people when a DTS process fails or succeeds.
• Monitoring Server Performance Activities such as Batch Jobs and DTS packages, User Sessions for Blocking and deadlocking.
• Created development and test databases and migrated to production.
• Created and managed indexes, which enabled quick searches and retrieval of information requested.

Environment:

• SQL Server 2000 (Query Analyzer
• Enterprise Manager
• DTS Designer
• SQL Profiler
• Index Tuning Wizard)
• SAS
• MS Access
• ASP.NET2.0
• ADO.NET
• Microsoft Visual Stuidio.NET 2005
• .NET Framework 2.0.

Confidential

Internship

Responsibilities:

• Developed Business Components to populate data on pages and update backend MS SQL Server 2000.
• Designed Tables and Views and created stored procedures and T-SQL Statements in MS SQL Server 2000.Perform Unit Test and Integration Test.
• Below are the projects that I worked for Confidential . Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
• Worked on DTS Package, DTS Import/Export for transferring data from Database.
• Created DTS packages using Active X Task to migrate data from heterogeneous data sources such as MS Access, Excel etc.
• Generated different reports using MS SQL Server Reporting Services.
• Involved in re-designing of database to create de-normalized reporting schema for better throughput.