Sql Server Full-Stack Developer
Resume:
Bhavika Ben
***********@*****.***
Summary:
Over 8 years of experience in designing, developing, and testing n - Tier Client/Server Web-based Applications using Microsoft .NET Framework and SQL Server with Agile and Waterfall Development Methodology.
Involved in use of Angular 2.0 technologies to include Node.js, LESS and additional technologies to ensure current migration from Angular JS 1.6 to Angular 2.0.
Deploying ASP.Net Core web application and API to ECS Fargate using an Azure DevOps pipeline.
Outstanding .NET Full-Stack Developer with proven expertise in all phases of SDLC.
Expert in Microsoft Technologies like C#, ASP.NET 5.0/4.5/4.0, MVC 5.0/4.0, Entity Framework 6.0/5.0/4.0, ADO.NET, SQL Server 2014/2012/2008 R2, WCF 4.5/4.0, Web API RESTful Services, IIS 7.0/6.0.
Deployed the project to Window Azure cloud platform, including host and SQL server deployment and local SQL.
Experienced in migrating on premise storage to Microsoft Azure using Azure Site Recovery and Azure backups and deployed Azure IaaS virtual machines (VMs) and Cloud services (PaaS role instances) into secure VNets and subnets.
4+ years of experience in Azure for system Deploying, Operating and Maintaining compute, network and storage in the Microsoft Azure environment using Microsoft Technologies.
Expert in developing data layer using Entity Framework, ADO.NET, and LINQ.
Strong experience in creating and consuming RESTful and SOAP Web Services.
Strong experience in developing SQL queries, functions, stored procedures, triggers, and views.
Expert in RDBMS include SQL Server 2014/2012/2008 R2 and Oracle 11g.
Proficient in storing and exchanging data using XML and JSON formats.
Experience in designing and implementing Single Page Application with Angular.
Extensive experience in developing UI screens using HTML5, CSS3, JavaScript.
Strong ability in Responsive Web Design using jQuery, AJAX, Bootstrap.
Proven ability in reports development and business intelligence solution using SSRS and SSIS.
Excellent experience in OOPS and Design Patterns like Singleton, Factory, etc. & UML.
Experience in creating loosely coupled classes using Dependency Injection.
Experienced in MVC and MVVM design pattern.
Strong experience in Test-driven development using MS Unit Testing and NUnit.
Knowledge of deploying and implementing Cloud solutions using Microsoft Azure.
Knowledge of using Continuous Integration / Continuous Deployment (CI-CD) tools as Jenkins.
Experience in version control with Git & TFS 2015/2013/2012.
Experience in bug tracking, issue tracking using Jira.
Self-motivated team player with a passion for solving analytical problems and thirst for new technologies.
Education:
Bachelors in Computer Science Engineering from India.
Technical Skills:
Programming languages:
C, C++, C#, SQL, T-SQL, PL/SQL, VB 6.0, and Core Java
Markup languages:
XML, XAML, XSL, XSLT, XMLHTTP, XMLDOM, HTML5, DHTML, CSS
Scripting languages:
JavaScript, jQuery, Ajax, AngularJS, NodeJS, ExpressJS, ReactJS, RequireJS, EmberJS, TypeScript
.Net Technologies and Frame works:
Microsoft .NET framework, ASP.NET MVC 3.5/4/5, MVVM, ASP.NET Web forms, ASP, Microservices, JQUERY, IIS Web Server, WPF, WCF Services, SharePoint, NHibernate
Servers:
Microsoft IIS (7.5 / 7.0 / 6.0 / 5.1)
Databases:
MS SQL SERVER (2012 / 2008 R2 /2008/2005), NoSQL (Azure Cosmos DB), Oracle (9i/10g/11g), MS-Access 2010
Reporting Tool:
Crystal Reports (2010 / 9 / 8.5 / 8), SQL Server Reporting Services (SSRS)
Operating Systems:
Windows and Unix
Testing Tools:
NUnit, MS Unit
Development Tools:
Visual Studio 2013/2012/2010, Team Foundation Server, Visual Source Safe (VSS), SVN, JIRA
Professional Experience:
Professional Experience:
Client: Paymentus Holdings, Charlotte, NC
Role: Sr. Dot Net Developer Nov 2022 to Till Date
Responsibilities:
Worked in Agile Scrum methodology and delivered accepted functionality in each sprint.
Played key role in feature implementation and enhancement, code refactoring and defect fixing.
Designed and developed Hybrid-Single Page Application using C# 5.0, .NET Framework 4.5, ASP.NET MVC 5, and AngularJS 1.5.
Involved in developing the Business Layer in C#.NET, where all the Business Objects are written in developing the whole Application.
Agile development is characterized by iterative and incremental progress. The project is divided into small, manageable units called iterations, and each iteration results in a potentially shippable product increment.
Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#.NET.
Developed various abstract classes, interfaces, classes to construct the business logic using C#.
Implemented Dependency Injection in .Net Core 3.1 Microservice Architecture applications.
Trouble shooter end-user issues in O365, such as issues related to Azure AD, Exchange, SharePoint, Teams.
Consumed SOAP APIs from enterprise customer system and RESTful APIs provided by other applications in the portfolio, also created W&C RESTful APIs.
Participated in UI design with Master Pages in MVC 5 and improved layout with HTML5, Bootstrap, and CSS3.
Used AngularJS, JavaScript to develop templates, controllers, and directives.
Used RequireJS JavaScript library to dynamically load ASP.NET bundles.
Used Math.net library to implement methods and algorithms for numerical computations.
Provided database connectivity using Entity Framework 6.0, LINQ, designed stored procedures and views at the back end.
Setup of Multi-Factor Authentication between the Azure and Ping Federated with AD on-perm passwords.
Setup In tune software deployment to allow users to authenticate to Azure Tenant.
Contributed to data migration from Oracle DB to SQL Server using PL/SQL and T/SQL.
Generated data migration and transformation using SSIS and built reports with SSRS.
Used OWIN interface to decouple server and application.
Worked on ReactJs components, forms and worked on setting up environment.
Used JSON web token to do user authentication and secure information exchange.
Used Dapper for Object relational mapping (ORM).
Responsible for merging the code using TFS.
Designed and Developed Web API, Logging and Monitoring for Microservices.
Used SOAP UI for testing generated XML
Developed SQL stored procedures and complex queries in SQL Server 2012.
Used Git for version controls and code merges.
Worked with Angular 4 routing, Lazy loading and ReactJS Forms to develop the client-side application.
Developed Web Application using C#, ASP. Net MVC 5, SQL Server 2012, HTML5, and CSS3.
Used Repository and Factory design pattern to develop reusable code.
Designed unit testing module with NUnit to test the application performance and availability
Heavily involved in code review, build and deployment with GIT, Jenkins.
Environment: .NET Framework 4.5, Visual Studio 2015, C# 5.0, ASP.NET 4.5, MVC 5.0, Entity Framework 6.0, Web API 2, SQL Server 2014, HTML5, CSS3, JavaScript, AngularJS 1.5, AJAX, IIS 7, LINQ, SSIS, SSRS, Git, Agile, Jenkins, NUnit
Client: United Rentals, Stamford, CT
Role: Sr. Dot Net Developer Jan 2021 to Oct 2022
Responsibilities:
Participated in the design and development of new change requests, project enhancements and the life cycle.
Involved in developing applications from scratch using MVC5, AngularJS, D3.JS, HTML5, JavaScript, CSS, jQuery 2.1.3 and Bootstrap
Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files, etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
Develop new applications using .Net Core APIs, Angular 7/9, C#, Azure SQL DB, Entity Framework Core, SQL 2016.
Used Key Features of AngularJS for responsive User interface (UI).
Using RAZOR view engine to generate Views/ Pages
Worked on enhancing and deploying the SSIS Packages from development server to production server.
Incorporated new functionality and additional fields for LEAF application.
Worked on the existing forms apart from creating new forms using .NET code.
Used ASP.Net input Validation controls for client side validation.
Used ASP.NET for integrating various functionalities like schema validation, credential validation, business logic application in WCF.
Developed backend systems (C#) using .NET Core, Code First, and SQL Server 2014 in Azure.
Used JSON for standardized data exchange format for Ajax-style web applications
UsedCore 3.1 as type-safe object oriented programming
Involved in Developing a Restful API that provides Configuration Management data
Implemented the entire back end of the application in C#.NET, using various object oriented features.
Used Oracle database for storing all the data through the application and migrated the historical data using SSIS.
Used Entity Framework as an interface from data access layer and database
Created Multithreaded ASP.NET Applications for concurrent users.
Used GITHUB (private Git repo) for version control
Created reports for weekly and monthly schedules using Crystal Reports.
Environment: VisualStudio2010IDE, C#, ASP.NET, ADO.NET, XML, MVC5, HTML5, CSS3, IIS, SOAP UI, Crystal Reports, JSON, WCF, WCF RIA Services, .NET Framework 4.0/3.5, Entity Framework, WebForms, Restful API, AngularJS, Bootstrap, GITHUB, Web Services, and ORACLE
Client: BroadSpire, Inc., Santa Clarita, CA
Role: Dot Net Engineer Jun 2020 to Dec 2020
Responsibilities:
Involved in a day-day Scrum Software development methodology and Test Driven Development TDD.
Extensively worked in Entity Data Model for implementing Business logic and Data Layer using Entity Framework 4.0.
Highly Involved in Creating Structure and UML Diagrams (Structure Diagrams, Logical Diagrams, and Use Case Diagrams) in assistance with Business Analyst.
Developed Application layer using ASP. Net, Server controls, HTML Controls and Validation controls.
Developed Application using .NET Framework 4.5, Object Oriented Principles (OOP), and n-Tier Architecture.
Effectively created easy to use, reusable controls and Master Pages and integrated them into ASP.NET web pages with MVC 4.0.
Designed Graphical User Interface (GUI) for various web pages using HTML, CSS, JavaScript and jQuery.
Working on Azure Operational Insights. Azure Operational Insights is an online service allows you to Collect, combine, correlate, and visualize all machine data. It is Infrastructure as a service (Ia As/PaaS/SaaS) tailored for IT operations teams. Part of Cloud and Data Center Management Team.
Effectively used jQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.
Created Inbound and outbound WCF services / Web Services have been created to integrate with email client and support applications using C#.Net
Wrote Data Access Layer Methods, T-SQL Queries, Store Procedures, and SQL User Defined functions for fetching Transaction details, Customer Details, and Product Configuration data.
Heavily used LINQ to SQL to retrieve data about Customers & Transactions.
Worked on Azure IaaS, VM Protection, Express Route, Azure File Storage, Azure G-Series, and Key Vault, Azure Virtual Machines UI Design based on HTML5, CSS3, jQuery, Bootstrap and Angular JS.
Developed DAL using LINQ Data context object with ADO.NET Entity Framework for LINQ, invoked DB tables and stored procedures and Implemented LINQ Lambda Expressions to query in memory expressions.
Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.
Involved in Unit testing, Modular testing, Integration testing and successful integration of modules and multiple layers in the system.
Used Microsoft Test Manager in Visual Studio for running Action recorded Test Cases and Regression Tests.
Environment: C#.Net, Object Oriented Methodologies, Visual Studio 2012, SQL Server 2008, ADO.NET, .NET Framework 4.5, HTML, CSS, JQUERY, Bootstrap, Web Service, WCF, XAML, LINQ, IIS 6.0, MS VISIO(UML), N-UNIT, n-tier architecture, Agile Methodology, Team Foundation Server (TFS), MVC 4.0.
Client: Paycom Software, Oklahoma City, OK
Role: C# / Dot Net Developer Jan 2019 to May 2020
Responsibilities:
Coordinated with other technical teams, laboratory researchers, and biostatisticians to ensure compatibility with modules and applications.
Architected and implemented numerous backend web services using C#.NET.
Developed controllers and action methods for user interaction logic using C#.NET.
Used ASP.NET Forms Authentication and Role based Authorization to implement application security.
Experience in Windows Azure Service Bus, and Windows Azure Document Database.
Using Azure Cloud services performed various web operations in Azure App Service.
Designed and developed UI using XHTML, CSS2, jQuery and Razor Views.
Implemented form validation using JavaScript.
Invoked WCF REST Services using jQuery AJAX.
Designed web UI using ASP.NET, HTML, JavaScript, CSS, Web Forms and AJAX controls.
Used SQL queries to develop Views, Functions, Triggers, and Indexes using SQL Server 2012.
Used ADO.NET Entity Framework 5 for database access, jQuery and manipulation.
Used Repository Pattern and Factory pattern for reusability of Data Access Logic for all modules.
Generated data migration and transformation using SSIS.
Environment: .NET Framework 4.0, Visual Studio 2010, C#, ASP.NET MVC4, SQL Server 2012, Entity Framework 4.0, XHTML, CSS2, JavaScript, jQuery, AJAX, JSON, SSIS, SSRS, TFS, IIS7
Client: BMC Software, India
Role: Software Engineer Nov 2016 to Dec 2018
Responsibilities:
Involved in requirements gathering, analysis, conceptual design, detailed design, development, and system testing using Waterfall Methodology.
Implemented N-Tire architecture.
Prepared Functional Specifications, Design Specifications document, and UML Diagrams.
Utilized Layout Page to define common site template.
Designed and documented Web Application including JSON data formats and API versioning strategy.
Used View Bag, Temp Data and View Model to display data. Displayed results in table format.
Applied ASP.NET MVC routing using convention-based and attribute-based routing as well as routing with passing parameters.
Used Windows Communication Foundation (WCF) service to connect the front end to the database.
Implemented Model Bindings to retrieve data from user input to the controller.
Added validations for required input filed and checked input type for login and registration page.
Utilized Data Access Layer for data retrieving, querying, storage and manipulation.
Worked on ADO.NET Data Reader, Data Adapter, Data Set and Data View to provide a connection to the database.
Set up required functions in the Service layer with data annotations.
Conducted Partial Class for code maintainability and further merging convincing.
Environment: Visual Studio 2012, SQL Server 2012, ASP. NET 4.0, WCF, MVC4, C#, HTML5, JavaScript, CSS, SSRS
Contact this candidate