SUMMARY

• Over 8 years of experience in Software Development.
• Experience in developing database applications using ADO.NET, Entity Framework, Microsoft SQL Server, Oracle and MS Access.
• Experience in developing T - SQL Stored Procedures.
• Experience in Tuning database objects and has experience analyzing various Dynamic Management Views to look for the root causes for performance issues.
• Experience in using Extended events and SQL Server Profiler for troubleshooting query issues.
• Experience in Configuration, Implementation and Maintenance of Transaction replication and Availability Groups.
• Experience in administrative activities comprising Database health check, Index optimization, Statistics update and Database role assignment.
• Experience using in memory tables which were introduced in SQL Server 2014.
• Hands-on experience using Query store, introduced in SQL Server 2016, to troubleshoot queries.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience with SQL Server Service Broker and asynchronous processing on SQL Server.
• Experience working on SSIS and SSRS.
• Working knowledge of all facets of .NET including: Windows Services, ASP.NET, Web Services, ADO.NET and XML
• Experience in all phases of software development cycle.
• Designed and developed applications using Microsoft ASP.NET, C#, ASP.NET MVC 5, WCF, ADO.NET, JavaScript, jQuery, Bootstrap, AngularJS, HTML5, CSS3, XML, XSL, XSLT, XSD
• Strong knowledge of OOP and RDBMS Fundamentals.
• Working knowledge of Cassandra Query Language(CQL).
• Knowledge of Python and R for data analysis.
• Hands-on experience using Splunk for analyzing logs from multiple sources
• Experience in Agile/Scrum life cycle for development
• Experience using Microsoft Visual Source Safe (VSS), Subversion (SVN), TFS (Team Foundation Server) and GIT.

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Database Developer/DBA

Responsibilities:

• Developed complex T-SQL stored procedures as per the business requirements.
• Tuned various database objects to improve performance.
• Introduced Maintenance plans to keep the database server in a healthy state.
• Introduced SQL coding standards and Mentored Team members on various technical aspects of SQL Server.
• Used Dynamic Management Views and Wait stats to recognize various objects affecting the performance of database and tuned them to improve execution times by a factor of 10.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Implemented error handling in stored procedures for graceful exit from stored procedure execution.
• Utilized Query store to troubleshoot queries.
• Utilized In memory tables to improve stored procedure performance.
• Set up replication using Publisher/Subscriber model for isolating data for reporting purposes.
• Worked on AlwaysOn availability groups, from setting up to troubleshooting issues with them.
• Worked with teams in 4 different time zones and cultures to streamline the product implementation.
• Architected and developed asynchronous solutions using SQL Server Service Broker.
• Developed reports using SSRS.
• Hands on experience with HVR for replicating data into a data lake from heterogenous data sources.
• Lead a team of 10 developers and provided mentorship to them in T-SQL Programming.

Environment: Microsoft SQL-Server 2012/2016, VB6, Java, Maven, Proficy, Cimplicity, SVN, GIT

Confidential, San Francisco, CA

Software Developer

Responsibilities:

• Developed stored procedures in T-SQL to generate monthly reports.
• Optimized and enhanced existing stored procedures to meet business requirements.
• Updated column datatypes to optimize database space utilization.
• Queried xml variables in tables to gather business critical data and later update the table design to optimize the queries hitting the table.
• Translated ColdFusion reports to SSRS Reports.
• Developed the front end of the application using ASP.NET MVC
• Consumed WCF Services and updated existing WCF Services as a part of the project.
• Used Entity Framework for data layer.
• Used Team Foundation Server for source control.
• Used Jira for tracking issues and enhancements on the system.

Environment: Asp.Net MVC, C#, AngularJS, Visual Studio, Microsoft SQL-Server 2008, Web services, WCF, Team Foundation Server(TFS), GIT

Confidential, Nashville, TN

Database Developer

Responsibilities:

• Writing T-SQL complex stored procedures, triggers, views and Assembly Functions.
• Used SSIS packages and DTS packages to transform data between various formats.
• Analyzed execution plans and tuned slow running queries.
• Used Profiler for troubleshooting issues with stored procedures.
• Tuned the database instance to efficiently utilize SQL Server.
• Worked on Migrating database from SQL Server 2000 to SQL Server 2008
• Developed reports using SSRS.
• Improved maintenance plans to make the performance optimal despite the volume growth.
• Implemented error handling in stored procedures for graceful exit from stored procedure execution.
• Developed the system using C#.NET
• Developed Web services, WCF Services to encapsulate business logic components to be used in a distributed environment using C#.
• Developed Business Layer using C# and ADO.Net, Entity Framework.
• Provided maintenance and upgrades to existing systems.
• Designed user interfaces (GUI) to meet the specific needs of users.
• Work with members of diverse technical and business teams
• Used MS Project for project tracking.
• Utilized VersionOne to manage the team's software development lifecycle including deriving product backlog items, assigning sprint work items to developers and conducting sprint review meetings
• Used Visual Source Safe/SVN for source code maintenance.
• Worked in a support environment tracking user requests using Service-Now.

Environment: Asp.Net MVC, ASP, C#, Vb.Net, Visual Studio, Entity framework, Microsoft SQL-Server 2008, Java script, Web services, WCF, HTML5, CSS3, SVN and Visual Source Safe

Confidential

Software Developer

Responsibilities:

• Analyzing User requirements and Design specifications.
• Preparing the designs using MS Visio.
• Developing the User-Interface Front-end screens using PL/Trim.
• Development on Unix Platform
• Involved in developing Data accuracy validation scripts using Excel VBA.
• Discuss any issues as a team and provide solution(s).
• Designed, developed and maintained the PL/SQL stored procedures used for retrieving and updating data in the Oracle databased
• Create Scheduler that Connects to the Database and refreshes the data at specified Intervals.
• Transferred data’s from excel to tables in database using Data Transformation Services(DTS).
• System and Integration Testing
• Maintenance and Bug-fixing.
• Using MS Project for tracking project progress.

Environment: PL/Trim, Oracle, Excel VBA, Visio, MS Project, Visual Source Safe, SharePoint server