Key role as a developer support with responsibility of troubleshooting issues in the system through SQL Server Management Studio, Visual Studio 2019, VS Code, Chrome tools and other integrated development environments (IDE) to conduct analysis of SQL, C#, and VB.Net code as well as to determine the cause of the issue while creating a script using T-SQL to resolve the problem Identification issue as well as preparation and submission of detailed document with explanation of the cause, relevant code, UI pages, scripts, and steps to replicate or determine the issues within the front-endAccountability in writing scripts for updating, deleting, and entering data to the system or database and other scripts to support access to one-time and up-to-date reports in the system by all usersApplication of technical proficiency in utilizing Salesforce in communicating with the requester; Azure in storing code repositories; as well as Microsoft teams to facilitate team communications Administration of delegated tickets and obtainment of consistent ranking as top 2 or 3 for each week in a team of nine Recipient of remarkable recognition from assigned mentor for completing given tasks with little to no support

Thorough evaluation of database objects for potential optimizationsFull control of a reporting database in establishing procedures that included execution of extract, transform, load (ETL) procedure from a transactional databaseFulfillment of key assignments including assessment, , resolving, testing, and initiating T-SQL code as well as writing T-SQL scripts for ad-hoc reportsClose interaction with other teams in completing a taskResponsibility in coaching teammate in T-SQL, its strategies, proper syntax styles, tips and tricks for better performing queries, and overall use of the language.Integral role in optimizing slow-running stored procedures

Utilization of Atlassian products such as Jira Service Desk, Confluence/wiki, Bit bucket, and OpsGenie as well as Git version control, Trello, and Microsoft productsDevelopment and amendment of stored procedures for consuming files of different formats including pdf, xls, xlsx, csv, and txt; for files, web reports, and business logic development; as well as for user authentication and system functionalityDocumentation of accomplished tasks and coordination with requestors, specifiers, and clients

Active involvement in handling and accomplishing Visual Studio Team Foundation Server (TFS) database project as well as in managing structure and SQL Server Integration Services (SSIS) maintenance throughout the Software Development Life Cycle (SDLC)Application of industry expertise in creating various technological solutions such as:-T-SQL views and queries for Power BI reporting;-New SQL database as a service in Azure along with tables, relationships, views, and user accounts for a new research project;-Tables, functions, views, stored procedures, and other database objects through T-SQL for requests and projects in accordance with a scrum framework; and-SSIS packages and T-SQL jobs in regulating business processes, reporting, and exports and importsUtilization of T-SQL in drafting and submitting reports for the business as well as C# in SSIS with Script Task and Smartsheet application programming interface (API) in syncing an Excel spreadsheet stored in SharePoint with SmartSheetDevelopment of solution for any data issues and discrepancies while upholding data integrity through the use of SQL Server Management StudioFormulation of all database objects through SSMS and database projects in TFSExpert management of timelines and expectations for projects, requests, and incidents by monitoring in Visual Studio Team Services (VSTS)Pivotal role in defining and driving automation and reporting opportunities while creating effective solutions to maximize business productivityDelivery of support to .NET Development Team with regard to code changes in compliance with continuous integration and continuous delivery with SOLID principlesDriving force behind the improvement of executions and load from 50% to 75% on multiple database objects through initiation of execution plan analysis

Establishment and strengthening of long-term business relationship with IT vendors Assessment of problem data to fully understand all support problems and offer appropriate solutionsOrganization of problem documentations and resolution procedures for reference proceduresAdherence to standard operating procedures as well as service level agreements.Performance of applications, hardware, and software installation, configuration, and administration, such as Office 365 Accountability in setting up accounts, personal computers, and workstations for new employeesEndowment of assistance in designing and improving IT systemsOrganization and facilitation of IT-related trainings to new hires, users, and technical teamsInstitution of employee termination procedures from all systemsDelivery of on-time and precise customer support tickets, thereby obtaining 98% customer satisfaction rating at the end of the year with more than 200 tickets

Proper handling of DotNetNuke tickets and user interface (UI) tickets for code changesKeen monitoring and assessment of senior developers in creating applicationsStrict compliance with strict process of change approval and releaseAccomplishment of set-forth learning path by the chief information officer