Sql Server Software Development

Alekya

Senior.NET Full Stack Developer

Phone: +1-551-***-****

Email: **********@*****.***

Professional Summary

Over 9+ years of experience in software development, covering functional specifications, analysis, design, modeling, development, configuration, management, and implementation of various web applications across finance, healthcare, insurance, investment, pharmacy, and e-commerce projects.

Proficiency in Microsoft .NET technologies: ASP.Net, C#, VB.Net, ADO.Net, Web Services, MVC, AJAX, Windows Services, WCF Services, OOPS, XML, XSLT, HTML, SOAP, LINQ, MS IIS, DHTML, VBScript, VSS, JavaScript, SQL Server.

Experience in designing web pages using HTML, JavaScript, CSS, jQuery, AngularJS, AJAX, Bootstrap, JSON, NodeJS, UML.

Strong experience with Web Forms and Win Forms applications using .NET Framework and Visual Studio.

Extensive knowledge of Microsoft technologies: Win-forms, Web-forms, Web Services using ASP.Net, VB.Net, C#, MVC, Entity Framework, AngularJS, ADO.NET AJAX, LINQ, WCF, WPF, Silverlight.

Experience in creating Views, Partial Views, and Sections in ASP.NET MVC, and developing Controllers, Controller Actions, Filters, and Routing.

Proficiency in MS SQL Server using SQL, SSIS, and T-SQL, including ETL processes with SSIS and DTS packages.

Responsible for making AJAX calls for UI interactions using AngularJS and processing data as JSON.

Hands-on experience in deploying applications to MS Azure Private Cloud and experience in TFS branching and merging.

Application development and deployment experience on Windows Azure platforms using different roles.

Proficiency in MS Azure Cloud Architecture (MS Azure Pack, PaaS, IaaS) assessments and Agile project management.

Working knowledge of RDBMS: MS SQL Server, Oracle 8i-12c, MS-Access.

Excellent skills in data modeling and implementing tables, views, stored procedures, functions, schemas, and triggers using T-SQL and PL/SQL.

Experience in application deployment on Windows and other platforms like UNIX, Solaris.

Expertise in working with RDBMS like DB2 and Oracle, and knowledge of directory services like LDAP.

Designed numerous WPF Forms using XAML.

Involved in projects using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Data Transformation Services (DTS).

Proficiency in databases like Oracle, MySQL, MongoDB, NoSQL.

Experience using testing tools JUnit, Selenium, Cucumber/Gherkin.

Expertise in database modeling and development using SQL, T-SQL, and PL/SQL in Oracle and SQL Server environments.

Exposure to Oracle, DB2, MySQL databases for application development using SQL Scripts, Stored Procedures.

Experience with Xamarin for iOS, Android, and Cross-Platform applications, developing with Xamarin Studio and .Net Frameworks, C#.

Excellent client handling, requirements meeting, and adaptation to new technologies/work environments. Well-organized team player with strong analytical and leadership skills.

Experience with Agile (SCRUM) methodology, Waterfall, and Test-driven development.

Proficiency in configuration and version management using SVN, TFS, GIT, and defect tracking tools like JIRA, Visual Studio Team Services, and database projects.

Technical Skills

Languages

C#, VB.Net, C++, XML, PL/SQL

Microsoft Technologies

.Net Framework 4.5 / 4.0 / 3.5 / 2.0 / 1.1 / 1.0, ADO.Net, ASP.Net 4.0 / 3.5 / 2.0 / 1.1, MVC 5/4/3, AJAX, Web Services

Frameworks

MVC Architecture, Angular, Angular 2, Typescript, Underscore, Knockout.js, Backbone JS, D3. Js ReactJS, Redux, Express, Node, Spring Framework, Hibernate

Web Technologies

HTML, HTML5, XHTML, XML, XAML, XSL, XSLT, JSON, CSS 2.0/CSS 3, Azure, Knockoutjs, AngularJS, Ajax, Web Services, Boot Strap

Databases

Oracle, MySQL, MSSQL Server, Sybase, PostgreSQL, MongoDB

IDE

Microsoft Visual Studio SQL Server Management Studio 2014, 2012

Azure Services

Azure Devops, Logic Apps, Function Apps, Blob Storage, Azure App Services, Service Fabric, Kubernetes, Azure Data Factory, Azure Service Bus, Azure Storage Explorer

Version controls

TFS, Git, SVN, Visual Source Safe

Protocols

TCP/IP, HTTP, FTP, and SOAP

Reporting Tools

SQL Server Reporting Services, Crystal Reports

Other Tools

MS Visio, NUnit, UML 2.0, MS Office, Coded UI

Database Tools

SQL Developer, DB Artisan, TOAD, MSSQL Server Management Studio

XML Technologies

DOM, SAX, JAXP, JAXB, XML-RPC and XML Beans

Educational Details: Bachelors in GNIT College, India, 2013.

Masters in University of Illinois Springfield, 2016.

Professional Experience

T. Rowe Price (Remote), Waukee, IA

Senior .NET Full Stack Developer Dec 2022 – Present

Description:

T. Rowe Price is a global investment management firm headquartered in Baltimore, Maryland. Founded in 1937 by Thomas Rowe Price, Jr., the company provides a variety of investment products and services designed to help individuals, financial intermediaries, and institutions achieve their financial goals.

Responsibilities:

Utilized Agile methodologies including SCRUM, TDD, and extreme programming to enhance collaboration and adaptability throughout project lifecycles.

Participated in multi-functional project planning sessions, analyzing requirements and providing design recommendations to stakeholders.

Developed business logic in C#.NET and ASP.NET using MVC and NoSQL databases.

Created, updated, and deployed Azure Web Application projects using Visual Studio, GitHub, and Azure Resource Manager.

Strong experience in Web Forms and Win Forms applications with .NET Framework and Visual Studio.

Implemented adaptive and responsive UI components using Bootstrap, HTML5, CSS, Ajax, JavaScript, and jQuery.

Worked on ASP.NET Core MVC, leveraging advanced concepts such as Models and Providers, and Filters.

Extensive experience in developing applications using Angular 15 and .NET Core 6.0, including Entity Framework and Dapper.

Created complex database queries, constraints, indexes, views, stored procedures, and functions using T-SQL.

Established communication between different applications using Windows Communication Foundation (WCF).

Developed applications using .NET Technologies such as ASP.NET MVC with Razor, WPF, WCF, Web Forms, Win Forms, and Web API.

Developed rich internet applications using ExtJS, focusing on creating interactive and dynamic user interfaces.

Integrated Angular for developing SPAs and creating reusable components and forms.

Handled large volumes of data during ETL processes, employing strategies such as parallel processing and data partitioning for improved performance.

Used TFS for source control management, ensuring code versioning and collaborative development.

Deployed applications and maintained databases in Microsoft Azure cloud environment.

Environment:

Test Driven Development (TDD), C# .Net, ASP. NET, MVC and NoSQL, ASP.NET, Visual Studio, GitHub and Azure Resource Manager, CSS, Bootstrap, Angular8/15/16, JavaScript and Telerik controls on the front end, VB.NET, C#, SQL Server, Twitter Bootstrap, HTML5, CSS, Ajax, JavaScript, and jQuery, SP.NET, MVC with Razor, WPF, WCF, Web Forms, Win Forms and Web API, MVC User Controls, ETL process, SQL Server, .NET, web services, Web page applications, PL/SQL, Azure Service Bus, Microsoft Azure.

Scoular, Overland Park, KS

Senior .NET Full Stack Developer May 2020 - Dec 2022

Description: Scoular is a prominent agribusiness and grain handling company based in Omaha, Nebraska, with a long history dating back to 1892. It operates across various sectors of the agricultural industry, providing a wide range of services to its clients, which include farmers, processors, and end users.

Responsibilities:

Integrated Azure services such as Azure Blob Storage, Azure Virtual Machines, and Azure Functions into application architectures to ensure scalability, reliability, and cost-effectiveness.

Developed client-side applications using Angular 2/4/6/15, HTML5, CSS3, Bootstrap 4, Typescript, AJAX, with business logic implemented in Azure Functions and Entity Framework.

Created and consumed services in Azure Web API for CRUD operations using HTTP methods (GET, POST, PUT, DELETE). Utilized Azure development skills to enhance collaboration among team members, improving document management and workflow efficiency.

Implemented real-time collaboration features in Angular Grid applications, enabling synchronized updates through Azure Functions.

Handled large volumes of data during ETL processes, leveraging Azure services for parallel processing and data partitioning.

Integrated popular NPM Packages like loads, moment.js, and ngx-bootstrap to extend functionality and improve productivity in Angular applications.

Conducted unit testing and bug fixing, utilizing Azure services like Azure Data Factory for ETL processes.

Implemented ExtJS components such as grids, forms, charts, and trees to enhance user experience.

Developed and managed ETL processes for data migration and integration using SQL Server Integration Services (SSIS).

Integrated Azure Functions with Azure Service Bus for event-driven architectures, processing incoming messages and triggering functions for further processing.

Leveraged Azure Blob Storage for storing and managing static assets like images, documents, and media files.

Focused on user-centric design, conducting usability testing and gathering feedback to improve UI/UX.

Designed intuitive navigation flows and interactive elements to facilitate user engagement.

Utilized Azure Cosmos DB for NoSQL database requirements, ensuring scalability and high performance.

Documented Azure service usage, installation instructions, and best practices to facilitate knowledge sharing and onboarding of new team members.

Integrated Azure DevOps Pipelines for continuous integration and continuous delivery of application builds.

Environment:

Angular2/4/6, HTML5, CSS3, Bootstrap 4, Typescript, AJAX, Entity Framework. CRUD, HTTP, ETL processes, API, Razor, C#, SSIS, SQL Server including complex stored procedures, T-SQL queries, DTS packages,.NET, Web services, Web page application, PL/SQL, PowerShell, REST APIs, Azure resource management, NHibernate, LINQ, WPF, WCF, DAL,MVC,ASP.NET, Azure Service Bus, Telerik Controls, Microsoft Visio, JSON, RESTFUL web services, Web API Controllers, ASP.NET MVC 5, AngularJS, CI/CD, Jenkins.

Bond-pro, Surety-Technology, Tampa, FL Feb 2017- April 2020

.NET Developer

Description:

Bond-Pro is a leading software solutions provider specializing in the surety and insurance industries. The company offers advanced automation and management software designed to streamline and enhance the operations of surety professionals, insurance companies, and agencies.

Responsibilities:

Migrated the existing email-sending service from .NET Framework 4.5 to .NET Core 6.0, documenting challenges and migration details.

Integrated existing API service calls into frontend development tasks.

Utilized AWS Lambda functions, DynamoDB, and S3 buckets for scalable and efficient solutions.

Designed and developed web-based UIs in C# using HTML Controls, Data Controls, and Web Controls.

Implemented ASP.Net Web Forms, Master Pages, Web Services, and state management techniques.

Leveraged ASP.Net AJAX for efficient communication with Web Services, reducing custom JavaScript code.

Created a robust data access layer using ADO.Net objects to communicate with SQL Server Database.

Developed Stored Procedures, Functions, and Triggers in T-SQL for data manipulation in SQL Server.

Conducted Unit, Integration, and System Testing using NUnit to ensure high software quality.

Applied Themes and CSS styles for UI design, incorporating Ajax, jQuery, and JavaScript to minimize page refresh.

Environment:

C#.NET 3.5, ASP.NET 3.5, Visual Studio 2008, HTML, CSS, jQuery, JavaScript, ADO.NET, IIS 7.0, SQL Server 2008, Windows Server 2008, Team Foundation Server 2008

Tata Consultancy Services, Hyderabad, Telangana

.NET Developer June 2013- Aug 2015

Responsibilities:

Majorly involved in creating APIs, fixing bugs, code cleanup, handling duplications, and writing test cases.

Designed and developed using Entity Framework Code-First approach with Repository Pattern and utilized RESTful Web API for client-side communication.

Implemented CRUD functionality and operations (GET, POST, PUT, DELETE) with Entity Framework in ASP.NET MVC, including sorting, filtering, and paging.

Developed Entity Models and utilized SQL Server 2016 for fast, responsive data retrieval and upgrades.

Developed modules for payroll, leave, attendance, salary, perks, and bonus calculations using ASP.Net and C#.

Implemented Forms Authentication and Authorization using ASP.Net Provider, created reusable user controls, and used ADO.Net for database connectivity and data retrieval.

Environment:

Visual Studio, C#, .NET, ASP.NET MVC, ASP.NET Web API, Entity Framework (Code First), LINQ, JSON, HTML 5, CSS 3, JavaScript, jQuery, SQL Server, NPM, Jasmine, JIRA, MVC, POSTMAN, Web Accessibility, ASP.NET MVC 5, C#, SQL Server 2012, JavaScript, HTML, CSS3, JQUERY, NUnit.

Contact this candidate