Data Sql Server

Varun Reddy Phone: +1-802-***-****

Dot NET Full Stack Developer *.*********@*****.***

PROFESSIONAL SUMMARY:

Professional IT Experience of 5 years in analysis, design, development, testing and maintenance of complex Software and Database Applications

Sound Knowledge of Object Oriented Language Principles (Inheritance, Polymorphism, Abstraction and Interfaces).

Extensive Knowledge in developing web applications using Angular, ASP.NET, ASP.NET MVC, ASP.NET Web API, WCF, Entity Framework, ADO.NET, Dapper, MS SQL Server, LINQ, HTML5, CSS3.

Has strong understanding in .NET Framework features for designing and developing new application.

Hands-on experience in developing web applications, windows applications on .NET Framework using C# languages.

Substantial experience with ASP.NET Core.

Designed and developed various Web forms using HTML, CSS, Bootstrap and JavaScript, Angular JS.

Extensively used Angular 7, 5 & 4 features such as directives, filters, two-way data binding, services, templates, routing, MVC, and dependency injection to build single-page applications in a clean and maintainable way.

Effectively used jQuery a concise JavaScript Library for traversing HTML5 document, event handling and AJAX interactions.

Expertise in developing Single Page Application using AngularJS framework.

Developed single page web applications using Angular CLI.

Extensively worked on Angular JS framework in ASP pages to run as Offline Application in browser that avoid IIS dependency installation and configuration.

Experience in implementing the MVC design pattern to standardize the application architecture.

Created Request/Response handlers in Web API.

Worked with Web API’s to provide services to HTTP request and created RESTful services.

Good Experience in developing applications using Microservices.

Experience with ORM and its related components Entity Framework, Language Integrated Query(LINQ) and retrieve data from different data sources (LINQ to Objects, LINQ to XML and LINQ to SQL), ASP.NET provides and typed datasets.

Good understanding of Database schema design and SQL, T-SQL, Stored Procedures, Functions, Triggers, Indexes, Views and Joins.

Used SSRS and SSIS tools for building reports.

Implemented AWS Auto scaling groups, Elastic Load Balancing, S3, EBS, EFS, Route 53, VPC, SNS, CloudWatch and ec2 under AWS.

Worked directly with the Azure Product team in tracking and resolving defects.

Experienced in Gitlab CI for End-to-End automation.

In-depth knowledge of XML and XSLT data and processing tools.

Good Experience in creating the test cases and performing Unit testing on applications using different testing tools like N Unit, X Unit etc.

Good understanding of Software Development Life Cycle (SDLC) in Agile methodology and other interactive software process model.

Great desire to learn latest technologies and ready to take up challenges.

Ability to prioritize tasks and execute them to perfection and able to work in high pressure environment.

Team player with excellent communication and written skills with exemplary analytical and problem solving.

Huron Consulting Group, Lake Oswego, OR October 2018 to till date

Dot NET Full Stack Developer

Responsibilities:

Designed, developed and enhanced the application in .NET Framework 4.6.2 and .NET Core 2.2.

Designed, developed, maintained Application using C#, WCF, ASP.NET 4.5, MVC 5, ASP.NET Web API, JavaScript, Angular 5 & 7, HTML, CSS.

Used JavaScript, HTML5, CSS3, NodeJS and Angular 5 & 7for frontend development.

Created Restful API services and tested them using POSTMAN.

Involved in the designing and implementation of a database on SQL Server 2017. Worked on creating tables, SQL Queries, Views and Stored Procedures/functions to process these data.

Implemented ngx-dropdownlist in Angular 5 Using it we can select multiple items in a drop-down list at a time.

Used Amazon Web Services (AWS) services like S3 buckets, EC2 instances.

Dropped .csv file into S3 bucket making use of Angular 5 & 7.

Developed AWS Lambda functions code in C# using .NET Core 2.0 for HTTP client implementation.

Made use of Xlsx Workbook libraries in TypeScript to convert.xlsx, .xls file to.csv.

Used Dapper methodology for making transactions between front end and database.

Used Web API as an ideal platform in building RESTful applications and to build HTTP based services.

Created shared API to share user’s information’s with other teams who integrate with our application.

Made use of Role based authentication in the application to restrict certain users to view only certain pages. So that only Admins, Super admins can have access to sensitive data transactions and to monitor lower level users activities.

Using API’s (Application Programming Interface) for business transactions to protect data loss while making calls from front end to databases. By including JSON tokens in the calls so that any third party calls can be prevented from accessing the data.

Hosted WCF services on IIS and tested WCF services using WCF Test client.

Used S3 buckets to store files and Each Client has a single bucket and created folder structure for different environment(QA, UAT, Prod) by using this approach we were able to reduce the buckets count.

Used Wave, Axe and NVDA tools and fixed many issues related with 508 compliance.

Migrated SSRS reports from SQL Server 2012 to SQL Server 2016.

Migrated from TFS(Team Foundation Server) to VSTS.

Deployed the application in GOV Cloud with the help of DevOps team

Setting up the build process in Azure DevOps by adding jobs like (visual studio build, Unit test build, Database build, publishing Artifacts) to agent.

Setting up the release by deploying the artifacts files to the server using Agent in Azure DevOps.

Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model.

Identified and added environment variables in release pipeline whose values change from environment to environment like (UAT, Local, QA, Dev and Production).

Worked with version control systems like GIT and used Source code management client tools like VSTS and TFS.

Responsible in fixing critical bugs in product.

Prepared technical documentation.

Worked in Agile Methodology to meet customers’ expectations, timelines with quality deliverables

Involved in supporting and maintenance for legacy production systems.

Environment: Visual Studio2017, C#, ASP.NET MVC 5.0, Dapper, WCF, Web API, Angular 5 & 7, Microsoft Enterprise Library, IIS 7.0, HTML 5, XML, Restful Web Services, Azure Devops, AWS.

Sherwin Williams, Minneapolis, MN July 2017 to September 2018

DOT NET Full Stack Developer

Responsibilities:

Designed, developed and enhanced the application in .NET Framework 4.5.

Experience in Web application designing and development using HTML, CSS, Angular 4,5&7 handle services in ASP.NET and database SQL Server.

Created Angular Components, Scope, Model, View, Services etc., which Isolate scopes performance operation in UI.

Designed, developed, maintained Application using C#, WCF, ASP.NET 4.5, MVC 5, ASP.NET Web API, JavaScript, Angular 4, HTML, CSS.

Used JavaScript, HTML5, CSS3 and Angular 4 for frontend development.

Develop new features and reusable components from designs and wireframes using Angular JS.

Engineered REST-ful APIs using Azure mobile services and ASP.NET Web API 2 with attributes routing to expose data to the clients.

Developed Components like Controllers, Models, Views, Layout and Action Filters in ASP.NET MVC 4.0

Used Web API as an ideal platform in building RESTful applications.

Created Web APIs using ASP.NET Web API allow new web/client projects to leverage reusable data.

Worked with HTML5, CSS3, JSON, JavaScript, Angular 4 for developing user interface.

Used various bootstrap components like accordion, date picker, time picker, alert, buttons, modal components.

Used Razor syntax in creating ASP.NET MVC application by reducing the coding aspect.

Developed and deploying WCF Services and XML Web Services.

Designed container based microservices architecture. Implemented scalable message queue based transaction flow and SQL log shipping for concurrency among all data centers.

Extended a custom domain drive microservices architecture build on top of Web API’s and HTTP protocols.

Implemented high availability with Azure Classic and Azure Resource Manager deployment models.

Implemented Entity Framework Migration to enforce the frequent changes in Conceptual layer changes to database.

Virtualizing physical services using VMware Converter Management of VMware VDI environment VMware Administrator: creating templates, deploying machines, maintaining/updating Virtual environments, restoring backups as necessary.

Used N-tire architecture for presentation layer, the business and DAL(Data Access Layer).

Setting up VMware Motion for High Availability.

Configure & Setup Azure Hybrid Connection to pull data from SAP Systems

Build Data Sync job on Windows Azure to synchronize data from SQL 2012 to SQL Azure.

Mapped workloads to the capabilities of Microsoft Azure for public, private and hybrid clouds.

Responsible in fixing critical bugs in product.

Involved in the designing and implementation of a database on SQL Server 2012. Worked on creating tables, SQL Queries, Views and Stored Procedures/functions to process these data.

Used SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer

XML and XSLT to design templates that will help in storing, transporting and displaying information on web browsers.

Prepared WCF Services layer to handle client-services interactions. Involved package creation and deployment.

Created and consumed ASP.NET Web services and implemented REST full Web API/WCF services for service layer, created Action filters and Exception filters to implement REST API.

Interacting with QA teams to review and develop data standards, data exchange, XML data standard, and data sharing model

Object oriented technology was extensively used for developing re-usable components using C#.NET.

Used AGILE Model, Test-Driven Development (TDD) and Object-oriented design patterns to write testable code which can be easily maintained.

Worked with version control systems like GIT and used Source code management client tools like GitHub, Git Lab.

Followed N-Tier architecture and worked on several layers in the same.

Fixing Assembly issues and deployment issues in Visual Studio 2017.

Created automated Unit test plans and performed Unit testing modules according to the requirements and development with N-Unit testing.

Review the test cases, scenarios and prepared bug report.

Prepared technical documentation.

Environment: Visual Studio2017, C#, ASP.NET MVC 5.0, Entity Framework 6.0, WCF, Web API, Angular 4, Microsoft Enterprise Library, IIS 7.0, HTML 5, XML, Restful Web Services, Microsoft Windows Azure, LINQ to Entities, SQL Server 2012.

Home BancShares(Centennial Bank), Conway, AR August 2016 to June 2017

DOT NET Full Stack Developer

Responsibilities:

Collaborated with existing development team to maintain internal ASP.NET websites application.

Designed class, Use Case, Sequence diagram using MS Visio.

Developed Applications using C#.NET, MVC, Object Oriented Principles.

Used front-end web development tools like CSS, JavaScript, HTML and jQuery.

Involved in implementing the logic using C# and OOPS Concepts.

Used LINQ to query against strongly typed collections of objects and Entity Framework 4.0.

Developed data driven business logic using C#.

Writing JavaScript, jQuery, JSON and AJAX to handle validations and dynamic page updates.

Used Web API as an ideal platform in building Restful application.

Integrated third part APIs into the current system.

Used jQuery libraries for more productive web design.

Used ASP.NET MVC page controller pattern to add functionality to individual pages such as to accept input from page request, invoke the required actions on controller.

Implemented View Model patterns / in creating and managing Views, Partial Views, View Model, Web APIs using ASP.NET MVC, custom errors.

Integrate XML, XSLT and other types of programming into databases and applications

Created and hosted WCF Services and used different bindings to make it available to different types of clients.

Experience with the features of Angular 2 such as directives, modules and routing

Highly used Angular 2 router to build single page application for navigate through the different status and multiple modals.

Utilized TFS for source control and CI build.

Responsible in developing Stored Procedures, Views, Indexes, Scripts for database transactions on SQL server 2012. Involved in Troubleshooting and Debugging of the application within Stipulated time.

Created the link servers to pull data from different data sources and used them in the stored procedure which will be executing on the schedule basis through SQL agent.

Performed data transformations using SQL Server Integration Services (SSIS) and SSRS via the implemented enhancements for better performance.

Automation of Database refresh activity for SQL Server on EC2.

Provisioning of Compute, Storage, Network and Database resources on AWS.

SQL Scripting based on SQL Server and AWS-RedShift.

Worked on Auto Scaling for providing high availability of applications and EC2 instances based on the load of applications by using Cloud Watch in AWS.

Utilized EBS to store persistent data and mitigate failure by using snapshots.

Configured S3 versioning and lifecycle policies to backup files and archive file.

Responsible for code build, release and configuration on Amazon EC2.

Enterprise N-tier software agent using Windows Communication Foundation (WCF) web service hosted on IIS.

Conducted comprehensive testing of developed objects in development and QA environments, including regression testing before any changes are released to the Production environment.

Worked in Agile Methodology to meet customers expectations, timelines with quality deliverables.

Environment: ASP.Net, C++, MVC 3.0/4.0, C#, Entity Framework, Visual Studio 2010, SQL Server 2012, Microsoft Visio, SSRS, SSIS, Web Servers, n-Tier Architecture, WCF, JavaScript, jQuery, AJAX, HTML, CSS.

GGK Tech, Hyderabad, India May 2015 to June 2016

.NET Developer

Responsibilities

Developed different data loaders for the implementation team to load the data from legacy systems into the application.

Create dynamic views using AngularJS.

Developed UI using HTML, CSS, Bootstrap, jQuery and JSP for interactive cross browser functionality and complex user interface.

Used AngularJS to handle client interaction.

Extensive experience in developing Web applications using MVC and Web API.

Developed applications using VB.NET, .NET Framework 3.5, Object Oriented Principles and N-Tier Architecture.

Developed and maintained Web Forms with ASP.NET, AngularJS, Silverlight, IIS 6.0/5.0 and C#.NET.

Worked on Telerik and Kendo Controls for Dropdowns, Grids and Progress bars.

Implemented PowerShell scripts that automated creations of contacts from Active Directory users and updating of address books -increasing productivity and efficiency.

Involved in hosting the WCF based services on IIS 6.0/5.0 and testing the service using the tool, WCF client.

Designed graphical user interface for various web pages using AJAX, HTML, CSS, JavaScript, Bootstrap and Silverlight.

Created and used Stored Procedures, Views, Joins, Triggers, Index’s in SQL Server 2008 R2.

Developed custom reports using SSRS.

Imported SQL Azure database to a local SQL Server using SSIS/SSRS.

Followed Agile Methodology to produce high Quality software and satisfy the customer.

Used Agile Methodologies for development through TDD, continuous integration, stand-up meetings.

Involved in supporting and maintenance for legacy production systems. Actively involved in bug fixes and enhancements postproduction as per the client’s requirement.

Environment: .NET Framework 3.5, Visual Studios 2012, ASP.NET, Web API, ASP.Net MVC, C#, IIS 6.0/5.0, Azure, JavaScript, AngularJS, jQuery, MS SQL Server 2008 R2.

Contact this candidate