We provide IT Staff Augmentation Services!

.net And Sql Developer - Senior Associate Resume

4.00/5 (Submit Your Rating)

Tulsa, OklahomA

SUMMARY

  • Around 14 years of IT experience in Analysis, Design, Development, Implementation and Testing of Web Based and Client - Server applications using .NET technologies..
  • Technical expertise in Microsoft Technologies such as .Net C#, .Net Core, ASP.Net, MVC, Entity Framework, SQL Server, SSRS, JAVA SCRIPT, IIS, SSRS, Crystal Reports and NService Bus and RabbitMQ.
  • Extensive experience in developing, debugging multi-tier applications using different SDLC methodologies like Agile, SCRUM and Waterfall.
  • Hands on experience in design and development of applications using Object Oriented Programming (OOPS) concepts.
  • Experienced in Object Relational Mapping (ORM) using Entity framework andLINQ.
  • Proficient in developing N-tier distributed .NET applications using Windows Communication Foundation (WCF).
  • Strong analytical and conceptual skills in database design, development and writing Confidential -SQL for implementing stored procedures, functions and triggers in MS SQL Server 2016.
  • Strong experience in developing Stored Procedures, Functions, SQL script performance tuning and implementation of data integrity using Confidential -SQL.
  • Experience in code review and unit testing using NUnit.
  • Expertise in Client/Server (Win Forms) and Web Based (Web Forms, ASP. NET) application development.
  • Experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, Interface and design patterns like Singleton, and Dependency Injection.
  • Experience using Configuration Team Foundation Server (TFS) and Azure Dev Ops (ADO).
  • Excellent Written, Analytical Skills, Verbal Communication skills and Problem-Solving skills.

TECHNICAL SKILLS

Languages: C#, SQL, Confidential -SQL, HTML, XML, CSS

Database: Sql Server 2016, MongoDB 5.0

.Net Technologies: .NET Framework 4.7, Core 2.1, ASP.NET, ADO.NET, WCF, MVC, LINQ, Entity Framework

Messaging Queue’s: NServiceBus & RabbitMQ

Version Control Tools: TFS, Git, SVN

Collaborative Tools: Microsoft Teams, Office 365, SharePoint.

Reporting Services: SSRS, Crystal Report

Deployment Tools: Jenkins, UDeploy

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, Oklahoma

.Net and SQL Developer - Senior Associate

Responsibilities:

  • Involved in the completeSoftware Development Life Cycle (SDLC)including Analysis, Design, Implementation, Testing and Maintenance withAgile Methodology.
  • Developing and Integrating new WCF service in Existing code and transfers the request to downstream through ServiceBus and RabbitMQ.
  • Design, build, and maintain efficient, reusable, and reliable code.
  • Designed and developedEntity Framework Code as messaging queue transaction and communication technology to the client-side.
  • ImplementedLINQ Queryoperations likeGrouping,OrderingandFilteringoperations to access database for search of season based WeatherNorm data.
  • Involved in Branching and Merging of required modules from various projects.
  • Designed database inSQL Serverand createdstored procedures,functions,viewsto reduce the complication of front-end SQL queries.
  • Used Joins, CTE’s to write complex queries.
  • Worked onTFSforversion control, Code Review and for automatic builds and continuous Integration.
  • Developing Console applications using .net Core to Automate and monitor the jobs, Windows Service, WebScraping tool and implemented in scheduler job and Control - M jobs.
  • PerformedUnit testingusingNUnit,Integration Testing,Performance TestingandSystem Testing.
  • Debug the programs and fix the problems and providing applications support in resolving Support tickets, identifying deficiencies, troubleshooting and resolving software problems.
  • Deploying the application in Dev, QA and Production using Jenkins and UDeploy tool.

Environment: C#, Asp.Net, .Net 4.5, .Net Core, Web Api, MVC, Jscript, SQL Server 2016, WCF, Entity Framework, NServiceBus, RabbitMQ, Jenkins, UDeploy and TFS & AzureDevOps.

Confidential

Technical Lead - Senior Associate

Responsibilities:

  • Monitor and troubleshooting the issues related to OPUS applications, User access, Store/Channel/SubChannel config issues, Register setup, Store Setup, Relocation and closure of store access.
  • Monitoring and performing the health check of the applications and generate the reports based on the requirements and the business needs.

Environment: Oracle 11g, SQL Server, TOAD 12.8, VMWare, AOTS Remedy, Retail Commander, Sharepoint.

Confidential

Specialization Sr., Engineers

Responsibilities:

  • Maintaining and enhancing the applications and managing the team and coordinating the international teams and outages.
  • Handled the production application issues and Database issues and identify the long running jobs and fixed the issues.
  • Involving the deployments, testing and post production validations and diagnosing the application issues.
  • Query optimization, Client/Server connectivity issues, DB consistency check and tracking long running query and resolving the performance issues in DB, CPU and I/O Memory checks.
  • Decide on escalations to avoid production downtime for quick turnaround.
  • Monitoring and performing the health check of the applications and generate the reports based on the requirements and the business needs.
  • Utilize standard corporate tools to records the changes, Service Requests, Problem tickets and the Root Cause.

Environment: C#, Asp.Net, WCF, IIS, BizTalk, ServiceBus, SQL Server, Service Manager, Connect IT Service.

Confidential

.Net Programmer

Responsibilities:

  • Involved in all the phases of SDLC and Agile scrum Methodology.
  • Responsible for handling the Branch code, Release Documents, Empty DB and DB Backup.
  • Implemented 3-tier architecture including Presentation Interface (UI), Business Logic Layer (BLL) and Data Access Layer (DAL).
  • Develop Master Pages using C#.NET to create a consistent layout for the pages.
  • Developed the application using ASP.NET 4.0, C#, JavaScript, ADO.NET, Webforms and Visual Studio.Net.
  • Performed client and server validations using Validation Controls and used JavaScript for client side validations.
  • Used ADO.NET objects like Dataset, Data Adapters for handling database activities.
  • Created tables, stored procedures, functions (UDFs), views, cursor and triggers in the data.
  • Used existing stored procedures to manipulate the database and to apply the business logic according to user specification.
  • Created the MSI Installshield deployment package.
  • Deployment of application in Test and Production server.

Environment: C#, Asp.Net, WCF, IIS, AJAX, XML, JavaScript, JQuery, HTML, CSS, InstallShield 12.0, SQL Server.

Confidential

SQL Data Analyst

Responsibilities:

  • To maintain the complete keened data and migrated the data from different categories and loaded to DTS.
  • Prepared the data for email campaign, advertisers paid list and generated the reports to sales team.
  • Created the TSQL queries SP’s, Views, Cursors, DML and DDL performed QA and Production.

Environment: SQL Server 2008 R2, 2005

Confidential

.Net Programmer

Responsibilities:

  • Developed the web applications and with C#, Asp.Net and SQL
  • Created the Confidential - SQL queries, Views and SQL functions and crystal reports.
  • Post deployment support and released code in production.

Environment: C#, Asp.Net, Ado.Net, Ajax, XML, JavaScript, IIS, Crystal Report, SQL Server

Confidential

.Net Junior Software Executive

Responsibilities:

  • Involved in project enhancement and Software development.
  • Developed the Web and Window applications using and enhancement projects and Bug fixes.
  • Created the SQL queries, Views and SQL functions.
  • Deployment in prod and Post deployment support.

Environment: C#, ADO.Net, Windows Forms, XML, FTP, Web Forms, XML, Java Script, IIS and SQL Server.

We'd love your feedback!