.net And Sql Developer - Senior Associate Resume
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.