Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
Tempe, AZ
Posted:
January 22, 2024

Contact this candidate

Resume:

Lakshma Reddy Ganta ad2z1b@r.postjobfree.com

Sr. Full stack .NET Developer www.linkedin.com/in/lakshmaganta +1-660-***-****

Summary:

8+ years of software development experience in web-based applications including requirement gathering, analysis, design, development, integration, implementation, and deployment using Microsoft .NET Technologies.

8+ years of experience in C#, ASP.NET Core, MVC, ADO.NET, Entity framework, and databases like SQL Server and Oracle.

Strong expertise in browser-based technologies like HTML, CSS, Bootstrap, JavaScript, jQuery, Angular JS, Angular and React.

Demonstrating expertise in Telerik Controls, particularly Kendo UI, I possess adeptness in effectively utilizing these tools alongside Angular to optimize the functionality of grids, drop-downs, textboxes, and sorting operations.

Proficient in developing N-Tier distributed .NET applications using Windows Communication Foundation (WCF) for SOAP based services Web API for RESTful Services.

Proficient in designing and optimizing complex SQL Server databases, developing efficient stored procedures, functions, Cursors, triggers, and implementing effective indexing strategies for superior performance and data integrity.

In-depth knowledge in SQL Server, Oracle database and SQL Server integration Services (SSIS), SQL Server Reporting Server (SSRS) and Crystal Reports.

Expertise in using ADO.NET objects such as Connection Object, Command Object, Data Reader Object, Dataset Object and Data Adapter Object.

Experience in detail-oriented and results-driven with a strong background in finance, tax, and accounting, seeking to leverage technical skills to create innovative solutions for financial and accounting processes.

Good Experience in Test-Driven Development (TDD) and proficient in designing and implementing robust Unit and Integration tests to ensure code quality, functionality, and maintainability throughout the development process.

Proficient in seamless web application deployment on Internet Information Services (IIS), optimizing performance and ensuring error-free launches.

Technical Skills:

.NET Technologies

C#, .NET Core, ASP.NET, RAZOR, ADO.NET, ENTITY FRAMEWORK, Dapper, LINQ, WCF, Web API

Languages

C#, VB.NET, Python

Client/Browser Technologies

HTML, CSS, JavaScript, jQuery, JSON, AJAX, HTML5, Kendo UI, Bootstrap, AngularJS, Angular

Databases

MS SQL Server, T-SQL, Oracle, PL-SQL, SSRS, SSIS, Crystal Reports

Design Methodologies

MVC, Micro Services, SOA, Singleton, Factory Method Pattern

Tools & IDE

Visual Studio, Visual Studio Code, SOAP UI, Ready API, ReSharper, Rally, Fiddler, Jira, Azure DevOps, PyCharm, Swagger, Fiddler, Postman

Version Control

TFS, GIT

Educational Qualifications:

Master of Science in Computer Science

University of Central Missouri, Warrensburg, MO, USA (Aug 2013- Dec 2014)

Bachelor’s in Information Technology

SSIET, JNTUK, India (2007-11)

Professional Experience:

Deloitte Consulting LLP, Gilbert, AZ Nov 2021 – Present

Sr. Solution Specialist (Sr. Full stack .NET developer)

Responsibilities:

Involving in Software development life cycle like requirement analysis, design, implementation, and testing.

Working on Agile Methodology (Scrum) to meet timelines with quality deliverables, providing user story updates using Jira.

Working on Angular to build the UI components, modules and single pages using Telerik controls for displaying the JSON data.

Developed .NET core-based web applications for financial data management, enabling real-time access to financial information for cross-functional teams.

Coding the .NET application business logic and database logic using Entity Framework, LINQ queries and Repository Pattern.

Creating RESTFUL services using Web API, built HTTP services and formatted responses using web API’s.

Implemented API versioning and documented APIs using tools like Swagger and Azure API Management Developer Portal.

Utilizing Angular CLI to streamline the process of creating, developing, serving, and testing applications.

Implementing RESTful APIs for inter-service communication, enabling efficient data exchange between microservices and promoting a modular and maintainable system.

Implemented authentication and authorization mechanisms to ensure data privacy and compliance with financial regulations.

Creating Angular components, service, directives, custom pipes, and filters to build UI components.

Utilizing Bootstrap for responsive web design, as well as Telerik controls, specifically Kendo UI, to create grids, textboxes, and dropdowns.

Integrated secure payment gateways and financial APIs to enable online transactions and streamline payment processing.

Implemented authentication and authorization mechanisms, like OAuth and JWT, to secure microservices and control access to sensitive functionalities.

Created/Modified Stored Procedures, Functions, Triggers and Views in both SQL server and Oracle DB and effectively used within the application and developed complex SQL queries.

Developing Unit and Integration tests by using MS Test.

Configure and set up CI/CD pipelines using Azure DevOps to automate the build, testing, and deployment processes and involve in creating release pipelines, managing build agents, and ensuring smooth deployments.

Working on distributed version control system/Subversion called GIT and comfortable with feature branches, rebasing, merging.

Apollo Insurance Solutions Group, El Segundo, CA Apr 2020 – Nov 2021

Senior Full stack .NET Developer

Responsibilities:

Analyze the application design, write efficient software programs, and support the entire life cycle of software development including testing and implementation.

Interface with management, business analysts, project managers, architects and other developers and internal customers to understand requirements and develop solutions according to the business requirement.

Assisted in tax planning and compliance efforts, ensuring accurate and timely submission of tax returns.

Created/Modified applications using C# and ASP.NET CORE, MVC, ADO.NET and Entity Framework.

Extensively used C#.NET for development and design of the Business Logic and Data Access Layers use of Generics, Events, Properties and Anonymous methods.

Developed Web Service Application Programming Interface (Web API) for exposing functionalities to client applications.

Designed and developed remote client access using Web Services (REST) to allow for synchronizing of data at remote sites and the main data site.

Collaborated with accounting teams to reconcile financial statements and identify and rectify discrepancies.

Created and hosted the WCF services and integrated them with UI components.

Developing the backend application using the SOAP services hosted by other applications and consuming them in the application.

Developed Web Api's and UI components for preparing financial statements, including balance sheets, income statements, and cash flow, taxonomy statements used for assets and investments.

Utilized Entity Framework technology extensively for data retrieving, querying, storing, and manipulation using LINQ statements, views, User Defined functions, stored Procedures for inserting/updating/deleting the data into the relational tables.

Used third-party controls like Kendo UI and worked on Angular 10 with HTML5 and Bootstrap.

Created Stored Procedures for generating reports by using SQL Server 2012 Reporting Services (SSRS), Triggers, and Views for performance tuning and retrieval of data.

Hosted and deployed Web Apps and Web APIs on IIS, ensuring seamless availability and performance.

American Airlines, Tempe, AZ Aug 2015 – Mar 2020

Application Developer

Responsibilities:

Working in agile methodology to work closely with business and gather requirements.

Working in design and development of web application using ASP.NET, ADO.NET, C#, MVC, Entity Framework.

Writing a broad range of regular expressions to parse the raw data and transform that through different layers in the project and display the data on UI.

Crafted dynamic UIs and custom views utilizing MVC, HTML, JSON, and CSS. Seamlessly integrating business layer objects and external content to deliver engaging user experiences.

Adaptively worked in an agile environment, adeptly transformed all project UI code from AngularJS to Angular through regular implementations and ensuring smooth transitions without impacting regular production releases.

Performing application-level tracing, debugging, testing and state maintenance.

Proficiently utilized SQL Server and Oracle databases to present information in alignment with specific project requirements.

Primary development responsibility for .NET application UI with technologies like JavaScript, jQuery, AngularJS, Angular6, Kendo UI, CSS3, HTML, HTML5, bootstrap, JSON and working on single page applications, specifically on AngularJS.

Developing the application with latest tools like Visual Studio 2017, Visual Studio Code, GitHub, TFS, SoapUI, Ready API, SQL Server 2012, Fiddler4, Rally and ReSharper.

Involving and active participation in developing, maintaining, and utilizing all team’s front-end code in mono repository and collaborating with technical team to review the code and verifying the performance.

Working in Angular 7 and adding unit tests for each functionality to make more robust code.

Ensure deployments roll out smoothly for different environments and provide appropriate support to the customer groups.



Contact this candidate