Professional Summary:

Microsoft Certified Professional with more than 7 years of experience in Analysis, Design, Development, Implementation Internet Applications, Client Server Applications and deep technical understanding of SharePoint Online-Office 365, On-Premise versions SharePoint 2010/2013 and MOSS 2007.

More than 5 years of data analytical experience in Non-Profits Healthcare organization

Extensive experience designing, developing, deploying, and supporting custom built and third party applications for Microsoft Office SharePoint (MOSS) 2007, 2010 and Office365 SharePoint Online environments.

Proficient in Installation, Configuration, Creating/managing sites and sites collection, site templates, Web Content Management (WCM), custom web parts, Event Receivers, Master Pages, Page layouts, Lists, document libraries, InfoPath, Workflows, Business Data Catalog (BDC), Business Intelligence (BI), Backup/restore.

Experience working with Microsoft SQL Server 2000, 2005, 2008, 2012, 2014 and 2016.

Experience in staging, massaging, and loading disparate source data

Strong PL/SQL, T-SQL skills.

Experience with SQL Server Integration Services (SSIS) for Extraction, Transformation and Loading (ETL) purposes.

Experience in creating logical and physical ERD using Microsoft Visio 2010.

Experience with Visual Basic language, implemented on .NET Framework.

Experience with Visual Source Safe for handling SQL Objects.

Experience in creating reports using SQL Server Reporting Services (SSRS) and MS Access Reports.

Create logical and dynamic user interfaces using HTML, JavaScript, ASP.NET, MVC, C# and CSS.

Possesses strong logical ability to solve problems and have good communication skills

Use of BCP Utility for bulk copies data between an instance of MSSQL and a data file in a user specified format.

BCP tool use for large number of data load from files to Microsoft SQL Server tables and export the data from tables to the data files.

SharePoint Site Development gather requirements, customized, extend, Best Practices, Train End Users, project management experience with large support staff.

SharePoint administration – Document user requirements, responsible for provisioning enterprise collaboration solutions. Supported Federal Security model consistent with NIST (National …) standards. Troubleshoot network, database, and connectivity issues. Supporting patching and migration of SharePoint platform components.

Created Sites, site collections, content types, custom lists and Libraries. Experience in Installing, Configuring, Administrating, Maintaining and Troubleshooting

SharePoint 2010 Development, hand on experience with SharePoint Designer and Business Intelligence- KPIs, Scorecards, Filter, Dashboards and site web parts including excel services deployment.

SharePoint 2010 customizations, Branding and site configuration, site administration, usage analytics, data view web parts, custom content types, custom workflows, and InfoPath forms. Proficient in creating and deploying forms using InfoPath and creating workflows.

Education:

University of Maryland University College, Rockville, MD, Computer Science BS, Cum Laude (GPA 4.0)

Computer Skills:

Languages:

T-SQL, C, Java

Operating Systems:

Windows 7/10/Vista/XP/2000/NT

Application Software:

MS Office, Office 365

Web Development:

SharePoint, VBScript, HTML

Database:

MS Access, SQL Server 2005/2008/2012/2014/2016, MySQL

Reporting Software:

Development Environment:

SSRS, Access Reports

Visual Studio 2008/2010/2012, Visual Basics, Team foundation Server

Certification:

Microsoft Certification: Designing and Developing Microsoft SharePoint 2010 Applications

Microsoft Certification: MCSA SQL Server 2012

Microsoft Certification: Microsoft SQL Server 2008, Database Development

Microsoft Certification: Microsoft SQL Server 2008, Implementation and Maintenance

Montgomery College: MSSQL Developer

Montgomery College: SharePoint Developer

Professional Experience:

February 2015- National Association of Community Health Centers, Bethesda, MD

Present SharePoint Developer / SQL Developer

Design, build, deploy and support custom SharePoint applications, sandbox and app solutions

Develop server side code using .NET technologies with VB.net, C# and/or ASP.NET

Develop client side code for web applications using HTML, jQuery, JavaScript, and CSS other technologies

Develop web parts, features, SP Apps, InfoPath forms, timer jobs, and applications for SharePoint 2013 using the SharePoint Client Site Object Model and Server Side Object Model

Create, modify, administrate, and support SharePoint site collections with multiple sites

Build custom workflows in SharePoint Designer and Visual Studio

Build custom forms, including integration with back-end databases

Led and assisted end users on portal development, including graphics, branding, layout, and navigations

Customize sites, including setting up security, designing site structure and maintaining content types

Create SQL Relational Database for National Medical Data statewide and import data every year for reporting purpose

Perform maintenance operations & Creation/review documentation

Handle support incidents escalated through helpdesk, monitor and improve server performance, plan and carry out server maintenance such as patching and upgrade

Use strong communications and interpersonal skills

September 2014- URS - Arlington, VA

January 2015 Web Developer / SQL Developer

Created and modified SharePoint site collections with multiple sites, unique navigational elements, custom content types and site columns, site pages, web part pages, workflows, retention policies, and governance policies for multiple clients.

Implemented and created governance plans, project management guidelines, deployment and development methodologies (DevOps) to reduce error, increase implementation times and quicken SharePoint development

Built and integrated KPIs, Scorecards, and Dashboards through Dashboard Designer. Collaborated and managed information through Business Intelligence in site pages

Used Analytical SQL Cubes for creating and integrating KPIs AND Scorecards in SharePoint site

Maintained and implemented site pages on .NET Framework as per the client requests

Developed and maintained SQL Server databases including creating multiple stored procedures for the database to manipulate data on the Client’s web-page

Quality checked and ran testing for the coded procedures and analyzes the outputs as per the requirements

Documented and maintained existing databases

Attended Client side meetings and ensured the project works are updated as per the client’s business requirements

April 2013- Brillient Corporation - IRS, Washington, DC

August 2014 SQL Developer / Financial Analyst

Developed and maintained SQL Server databases for National Level Program

Led in documenting and maintaining existing databases

Created Stored Procedures (large numbers) for coding the Program based criteria

Created processes for automating and scheduling purposes

Created ETL using SSIS to import and extract data to and from csv, excel, and access

for National Level Project

Ran testing for the coded procedures and analyze the outputs as per the requirements

Created temp-tables, views, triggers as per the requirements

Built Cubes for analysis purposes

Used Cubes for query and reporting services in excel and SharePoint BI

Frequent backed up and restored for the database for regular testing and updates

Detached and attached database to different server

Data cleanup and tuning

BCP Utility for migration of large number of data from data files to SQL Server Database tables and from tables to data files

Created dynamic interface using HTML and CSS

Advanced Excel functions project work for metadata at Internal Revenue Services (IRS) that included data transfer, manipulation and data reliability

Created and modified SharePoint site collections with multiple sites, unique navigational elements, custom content types and site columns, site pages, web part pages, workflows, retention policies, and governance policies

Built customized forms with InfoPath and Designer and SharePoint application pages

Developed, deployed, and maintained various workflows based on the business needs and requirements

Work Environment: SQL, SharePoint, HTML, VBScript, UNIX, C#

June 2012 – VFS Global Services Inc., Washington, DC

April 2013 Data Management Officer

Developed and maintained SQL Server databases for passport and consular services

Assisted in documenting existing databases

Created ETL using SSIS to import and extract data

Created stored procedures, views, triggers as per needs

Created processes for automating and scheduling purposes

Involved in tuning and optimizing SQL queries

Updated the data-dictionary for the databases

Actively helped other team members to troubleshoot data issues

Work Environment: SQL, HTML, VBScript, C#, Java

August 2008 – Walmart, Germantown, MD

June 2012 Claims Office Associate / Data Analyst

Responsible for designing and implementing Claims data for legal and store inventory purpose.

Maintained and ensured the accuracy of legal claims data

Built and maintained the excel worksheets for complex queries through advanced excel functions for data analysis

Created access database packages for automation of periodic data loads/updates

Created various reports using MS Access and MS Excel

Created and maintained daily, weekly and monthly reports MS Excel

Assisted in data de-duplication

Involved in data analysis to find issues or find information to suitable data granularity

Work Environment: Excel, Access, MS Word

Public Trust Level Security Clearance Completed (Active).

References: Available upon request

Contact this candidate