SUMMARY

• Over six years of professional experience in Analysis, design, development, testing and implementation of business requirements wif Microsoft technologies including SQL Server 2012/2014/2016 , SharePoint server 2010/ 2013 and ASP.NET.
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Excellent in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Data Extraction, Transformation, and Loading (ETL) from various sources using SQL Server Integration Services and Bulk Copy Program (BCP).
• Capable of using Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Involved in extracting data from multiple data sources into Power BI application
• Hands on experience to create Out of the Box SharePoint solutions which includes creating and customizing site Collections, sites, pages, Document Libraries, Lists, Views, Content Types, Web Part, and workflows.
• Experience in developing and customizing SharePoint applications using different tools such as SharePoint Designer, InfoPath Designer and Visual Studio.
• Strongunderstanding and implementation of OOPs concepts.
• Good insight in Azure cloud technology
• Excellent problem-solving skill and ability to work in team.

TECHNICAL SKILLS

Programming Languages: T-SQL, C#, JavaWeb Programming HTML, CSS, XML, JAVA SCRIPT, J QUERY, Telerik (Kendo UI)

Web Server: Internet Information Server (IIS) 7.0/6.0/5.0, Apache Tomcat

RDBMS: SQL Server 2008/ 2012/2014/2016

Frameworks: .net framework 2.0/3.0/3.5/4.0 , Spring framework

Operating Systems: Windows Server 2008/2012, Linux, DOS

Tools: Microsoft Visual Studio 2015/2010/2008 , Microsoft SharePoint, Designer 2013/2010Microsoft InfoPath 2013/2010, office 365, Team foundation Server (TFS), Git HubEclipse

PROFESSIONAL EXPERIENCE

SQL Developer/BI Developer

Confidential, Tysons Corner, VA

Responsibilities:

• Participate in project planning sessions wif business analysts and team members to analyze business requirements and translate into working model.
• Use Agile practices and Test-Driven Development techniques to provide reliable, working software early and often.
• Troubleshoot issues inJava and database objects like Procedures, Functions, Triggers, Indexes & Views and implement necessary code changes to meet client requirements.
• Use CoreJava to develop Business Logic.
• Extensively develop stored procedures, Functions, views, triggers andIndexes and other SQL objects as per business requirements.
• Writing complex queries using Joins, Sub-Queries, CTE and Cursers.
• Troubleshoot issues in database objects like procedures, functions, packages, Triggers, Indexes, views and implement necessary code changes to meet client requirements.
• Design and Develop summary and detail parameterized Quality reports according to business requirement using Report Builder and SQL Server Reporting Service (SSRS)
• Creating and automating the regular SQL Jobs.
• Extract data(report) from SQLserver 2016 result set and generate CSV, Excel, PDF, and fixed width text file using java code and drop it in different server like SFTP drop zone.
• Write SQL queries to read data from source databases to analyses source system after joining multiple tables.
• Create some SSIS packagesto import and export data from various data sources using SSDT.
• Use GitHub for source Code repository and version control tool.
• Use IBM Rational and Rally software extensively to track the day-to-day scrum activities and to tracking the Project Stories in AGILE Methodology.

Environment: Microsoft SQL Server 2016, Microsoft SQL Server Integration Service (SSIS), Microsoft SQL Server Reporting Service (SSRS), Report Builder 3.0, Visual Studio 2017, Java 11, Eclipse, GitHub, IBM Rational Dashboard, Rally Software, Visio

SharePoint Developer/Administrator

Confidential, Washington DC

Responsibilities:

• Designed and developed new SharePoint Portal Site to improve collaboration among employees.
• Configured web application, Created Site collections, Sites, Lists, Document Libraries, pages, Views to collaborate users.
• Performed Import and Export operations to move content and migrate sites to a different site collection as per the reorganization.
• Designed, developed, and published InfoPath 2010 forms to work wif lists, libraries and forms, and attached it wif workflow.
• Designed powerful custom workflow (list, reusable, and site) using SharePoint Designer to automate business process.
• Created content types for different document libraries wif various metadata fields associated wif each content type.
• Used visual studio to develop, debug, package and deploy both sandbox and farm solutions.
• Designed and maintained unique looks and feel of sites using SharePoint Designer, HTML, CSS, JavaScript, and jQuery.
• Used BCS services to connect to SQL server and display data(report) in SharePoint List.
• Worked on migration from SharePoint2010/2013 to SharePoint Online and troubleshoot issues after Migration.
• Involved on Upgrading SharePoint 2010 to 2013 through performing an inventory audit count using PowerShell.
• Use third-party tools like Sharegate and Metalogix for migration.
• Post Clean Up work like changing connections for InfoPath forms after migration
• Maintained Active Directory users and groups for implementing security.
• Used PowerShell to activate and deactivate SharePoint features.
• Managed SharePoint Security.
• Diagnose, troubleshoot, and resolve SharePoint related technical issue.

Environment: Microsoft Office SharePoint Server 2010,2013, Office 365, .Net Framework 3.5/2.0, ASP.NET, C#, HTML5, CSS3, JavaScript, jQuery, MS Visual Studio 2010/2012, SharePoint Designer 2010/13, InfoPath 2010, Microsoft SQL Server 2014/16.

Application Developer

Confidential, Herndon, VA

Responsibilities:

• Involved in all phases of Software Development Life Cycle including requirements gathering, design, development, testing, implementation, and postproduction support.
• Developed custom SharePoint pages, page layout and Web part page by using html5, CSS3 JavaScript and Kendo UI controls.
• Perform client side and server-side validation using JavaScript, jQuery, and C# code.
• Created REST data services using C# code and consume it from client side.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, T-SQL script for applications.
• Involved in functional and Integration testing of different modules.
• Used MS Team Foundation Server 2012 (TFS) for source controlling and issue management.
• Provided day-to-day end user support in a highly collaborative team environment.

Environment: C#, ASP.NET, JavaScript, jQuery, Kendo UI, HTML 5, CSS 3 .Net Framework 4.5, Visual Studio 2015, Microsoft SQL Server 2014, Team foundation Server (TFS)2012, SharePoint Server 2013, SharePoint Designer 2013, CA Agile Central (Rally)

SQL Developer

Confidential, Maryland

Responsibilities:

• Created prototype of the application for demo before developing the application.
• Creation of database objects like tables, views, function, Constraints, Triggers, and procedures using T-SQL.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Export or Import data from other data sources like flat files using Import/Export through SSMS and Bulk Copy Program (BCP utility).
• Developed reports using SQL Server Reporting Service (SSRS)
• Supported team in resolving SSRS and T-SQL related issues and Proficiency in creating different types of reports.
• Installed and configured edition of SQL Server 2008/2012 like Enterprise edition
• Migrated new database structures, such as tables, indexes, and stored procedures from development to the production environment.
• Responsible for creating technical and user document for the developed Solutions.

Environment: Microsoft SQL Server 2016, Microsoft SQL Server Reporting Service (SSRS), Visual Studio 2010, Window Server 2012