Home

AKHILA - .Net Developer

[email protected]

Location: Texas City, Texas, USA

Relocation:

Visa:

PROFESSIONAL SUMMARY Over 7+ years of experience with a robust understanding of variousSoftware Development Life Cycle methodologies, starting from initiation to implementation, have collaborated with different stakeholders, gathered requirements, created artifacts, performed different analysis, handled change requests, performed Testing and assisted in successful deployment. Demonstrated ability to work actively using Agile methodologies (SCRUM-TDD) and waterfall methodologies in multi-tier web-based architecture. Proficient in Object Oriented Design/Development (OOD), Object Oriented Analysis and Design (OOAD), Model View Control (MVC) and Singleton design patterns. Experience developing front-end UI with extensive use of HTML/HTML5, CSS/CSS3, Java Script, jQuery, LESS, Bootstrap, AJAX and Kendo UI and working with AngularJS for validating the server controls. Extensively Worked extensively on ADO.NET to access and manipulate database such as SQL Server and Oracle and used Entity Framework as an object relational mapping for all the MVC applications. Extensively worked on C# advanced topics LINQ, Lambda Expressions, Exception Handling, extension methods and Generics. Experience working with HTML Helper classes, Partial classes, Layouts, Entity Framework and Action Filters in MVC. Experience in developing and consuming Web Services using Web API, REST and SOAP Services where communication of data is done in XML and JSON formats. Good Understanding and developing experience with ASP.NET core. Expertise in UML which includes creating Use-Case diagrams, Class diagrams, Interaction diagrams (Sequence diagrams, Activity diagrams and Collaboration diagrams) using designer tools like MS Visio. Experience in designing and development of applications using MVC (Model view Controller), MVMM (Model View, View Model), Singleton design patterns, Factory Design Patterns. Experience in deploying the applications on IAAS, PAAS of Microsoft Azure. Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins. Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2012/2008. Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services. Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors. Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger. Created and maintaining SSIS Package (ETL) to Extract and Transform data from Flat File or CSV, and to load into Staging Database. Hands on Experience using Team Foundation Server (TFS)and GitHub for Version Control. Expertise working with tools N-Unit, JIRA, Rally. Excellent experience in onsite-offshore model interacting with clients and Onsite managers. Experience with Microsoft Azure services. Responsible for monitoring the work of team members and entering the tasks and monitoring the time in SCRUM Portal. Ability to conceptualize, document, and communicate project ideas and plans. Possess Strong business &application analysis skills. Ability to work under pressure individually and/or in a team with minimal supervision. Effective team player having excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines. TECHNICAL SKILLS Languages C#, C, T-SQL, PL/SQL .Net Technologies ASP.NET 2.0/3.5/4.0/4.5, ADO.NET, LINQ, C#.NET, .Net Framework 2.0/3.5/4.0/4.5, WebAPI, ASP.NET Core. Web Technologies HTML, CSS, AJAX, JQUERY, Web Services, REST, SOAP,AngularJS, XML, WebAPI, JSON Data bases SQL Server 2012/2019, Oracle 9i/10g Front-End Technologies HTML5, CSS3, JavaScript, Angular 8/9/10, Bootstrap GU/IDE Microsoft Visual Studio 2015/2017/2019 Operating System Windows 2007/2010, UNIX Reporting & ETL SSIS, SSRS Version Controls TFS, GITHUB EDUCATIONAL QUALIFICATIONS: Master s in software engineering- December 2016 Bachelor s in information technology- May 2015 PROFESSIONAL EXPERIENCE Gexa Energy, Houston, TX(SEP 2022 Present) Role: .Net Developer Responsibilities Participated in daily scrum and weekly meetings with business and architects to meet requirements and deadlines. Worked on designing ASP.Net web applications using .Net framework, C# and Model, View, Controller (MVC). Created and enhanced REST services using ASP.Net web API and used postman to test them. Involved in writing the Stored Procedures, Views, Tables and Functions in T-SQL. Maintained state of webpages by using View State and Session memory objects. Developed ASP.NETcore Web APIs to interact to query databases and retrieve data in JSON format.Also involved in pretesting using POSTMAN. Designed and developed user interface using HTML5, CSS3. Implemented JWT security to provide authentication and authorization to secure WEBAPI. Implemented various Angular JS directives, filters, routing, and services to implement better application functionality and performance. Designed database in SQL server and created storedprocedures, functions, views to reduce the complication of frontend queries and improve performance. Used GITHUB for version control. Worked on debugging and fixing the production issues and involved in maintenance of applications. EnvironmentVisual studio 2019, C#, MVC, ASP.NET core, LINQ, JSON, HTML5, CSS3, Bootstrap, Angular, T-SQL, NUNIT, TFS. Advantasure, Richmond, VA(SEP 2019 -AUG2022) Role: .Net Developer Responsibilities Responsible for designing ASP.Net application using .Net framework, C#. Implemented REST services using ASP.Net web API and used postman to test them. Extensive experience in Entity Framework and ADO.Net to access data services from database as well as code first and data base first approaches. Making changes to existing web applications according to the feedback received from the end users or clients. Performing extensive software testing and stringent quality checks as per the QC guidelines to ensure an error free as well as optimum final product to the user. Experience in responsive UI design and tools such as HTML4/5, CSS3, Bootstrap, Ajax and Angular. Improve the UI using Angular 8 and created re-useable components and custom modules, Custom directives, Pipes and services using Angular. Involved in writing the Stored Procedures, Views, Tables and Functions for interaction with the Oracle database. Writing & updating T-SQL, PL/SQL, Stored procedures, views, cursors, and functions based on the requirements documented. Developed web applicationsusing ASP.NET coreand deployed in Microsoft Azure. Migrated PLSQL databases to Windows Azure Database and updated connection string accordingly. Used Team Foundation Server (TFS) for version control. EnvironmentVisual studio 2015, ADO.NET, C#, MVC 5, ASP.NET core, LINQ, AJAX, XML, JSON, HTML5, CSS3, Bootstrap, Angular, T-SQL, NUNIT, TFS. BrownGreer, Richmond, VA(Nov 2018 JUL 2019) Role: SR. .Net Developer Responsibilities Responsible for designing ASP.Net application using .Net framework, C# and Model, View, Controller (MVC). Extensive experience in Entity Framework and ADO.Net to access data services from database as well as code first and data base first approaches. Experience in responsive UI design and tools such as HTML4/5, CSS3, Bootstrap, Ajax and AngularJS Worked on Asp.net security features using filters such as Authentication and Authorization. Developed interactive pages of the application using ASP.NET Web Forms pages with C# for the code behind modules. Extensively Used. ASP. NET 4.5 controls like Master Page Templates, Menu Controls, Grid View Controls and File Upload Controls. Implemented controls like DataGrid view, data view, list view, list box etc. and bind the data to the controls using binding source. Design and implement database schema import data and build stored procedures on SQL Azure. Used Angular as framework to create a Single Page Application (SPA) which can bind data to specific views and synchronize data with server. Developed and consumed RESTful web services using Web API and used jQuery, AJAX to call WebAPI Service methods and used postman to test them. Analyze functional capabilities and limitations of out of box application and make wise decisions to reduce amount of custom code developed. Used C#, ASP.NET, AJAX Toolkit controls like Script Manager, Update Panel and Modal Popup Extender within some web pages. Used ADO.Net and LINQ for Consistent access to SQL data source. Good experience in Amazon Web Services (AWS) environment and good knowledge of AWS services. Configure Azure cloud service for end -point deployment and deployed WCF, REST services on Azure cloud. Used Team Foundation Server (TFS) for version control. Environment Visual studio 2015, Azure SQL SERVER 2016, ADO.NET, C#, Java, MVC 5, LINQ, AJAX, XML, JSON, HTML5, CSS3, Bootstrap, Angular, Azure Devops, T-SQL, Eclipse, NUNIT, TFS. Bank of America, Charlotte, NC(MAY2018 OCT2018) Role: .Net Developer Responsibilities Worked on Agile Methodology (SAFe Framework) to meet timelines with quality deliverables. Developed the UI using HTML5, JavaScript, CSS3 to build dynamic pages and Used ADO.NET for database connectivity and retrieving data from SQL server and Oracle server. Worked extensively with MVC Features such as Action Filters, View Model and Model Binder. Experience in building flexible UI, more user interactive and user-friendly web pages, reusable classes, functions using ASP.NET, C#, AJAX and JavaScript for client-side validation. Implemented Angular JS controllers, directives, components, factory, service resources, and routings. Leveraged Angular JS for page scripting, AJAX calls and JSON for passing objects from Controller to View and vice versa. Utilized Entity framework extensively for data retrieving, querying, storage and manipulation using LINQ. Developed the windows service in C# to make the process to run continuously without user interaction. Implemented REST services using ASP.Net web API and used postman to test them. Extensively used XML and JSON Serialization for transferring the data from controller to view. Configured IBM MQ Queue Mangers, Queues and Channels. Developed Windows service in C# to process the JSON data from IBM MQ. Developed Orchestration to implement Dynamic mapping and Routing Mechanism. Involved in developing the web service in JAVA to connect to Actimize tool. Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. Involved in writing the Stored Procedures, Views, Tables and Functions for interaction with the Oracle database. Writing & updating T-SQL, PL/SQL, Stored procedures, views, cursors and functions based on the requirements documented. Implemented Unit Testing, Integration Testing using NUNIT. Used Log4net for logging the errors and maintained versions of source code using TFS. EnvironmentVisual studio 2017, SQL SERVER 2016, ADO.NET, C#, Java, MVC 5, LINQ, AJAX, XML, JSON, HTML5, CSS3, Angular JS, T-SQL, SSIS, IBM MQ, Eclipse, Oracle 11g, NUNIT, log4net, TFS. Bank of America, Addison, TX(SEP 2017 Oct 2018) Role: .Net Developer Responsibilities Responsible for ETL Operation which extracts the data from heterogeneous sources to relational data warehouses and staging databases using complex stored procedures and SSIS. Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files to SQL Server Database. Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS. Experience in data migration from old databases and different databases to main database. Writing & updating T-SQL, PL/SQL, Stored procedures, views, cursors and functions based on the requirements documented. Using Jenkins AWS Code Deploy plugin to deploy to AWS. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data. Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task. Performed T-SQL tuning and optimization of queries for reports that took longer execution. time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server R2. Developed the UI using HTML5, JavaScript, CSS3 to build dynamic pages and Used ADO.NET for database connectivity and retrieving data from SQL server. Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance. EnvironmentVisual studio 2015, SQL SERVER 2014, HTML5, CSS3, T-SQL, SSIS, SSRS. HCL Global Systems (May 2016 AUG 2017) Role: .Net Developer Responsibilities Involved in complete Life Cycle including Analysis, Design, Development and Testing. Worked on Agile Methodology this includes Daily Scrum, Retrospectives and used JIRA as management tool. Designed and developed user interface using HTML5, CSS3, MVC and Bootstrap and Used LESS preprocessor to develop and write CSS code. Designed user interface using ASP.NET web forms and implemented application logic using C#.NET and maintained uniformity among all web pages in GUI and designed Master Pages and themes. Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing the table structures. Created SSIS Packages using Pivot Transformation, Execute SQL Task, Data Flow Task, to import data into the data warehouse. Involved in Performance tuning for SQL procedures and application queries. Created Web Services using WCF, RESTful web Services to support the SSRS reports. Created RESTful services using ASP.NET Web API to expose the analytics data to the clients. Used AngularJS, a web browser JavaScript framework fully client-side library to build single page web applications using MVVM patterns. Implemented Data Access Layer using Entity Framework and LINQ. Deployed and maintained ASP.NET applications running at IIS 6.0. Developed MVC Web APIsto interact to query databases and retrieve data in JSON format and display data in the client side using Ajax and AngularJS. Created custom events in the Event Log and Tracing information inside the orchestration for tracking purpose. Used Angular JS to handle events triggered by clients and send request to server. Working on dependency binding and declarative tracking using Node.js. Implemented the sorting and paging for all the grid views using AJAX. Created Dependency Properties and Routed events in C# and Implemented Triggers in XAML. Experience with Kendo UI, jQuery UI and front-end JavaScript Frameworks. Used AJAX based Telerik controls to develop the presentation layer and make the application more presentable and to implement different UI functionalities. Involved in Deployment and Troubleshooting issues in applications. Responsible for maintaining versions of source code using Team Foundation Server 2010. EnvironmentVisual Studio 2015, C#, ASP.Net 4.5, MVC 5, WCF, jQuery, Kendo UI, AJAX, ADO.Net, TFS 2015/2013, IIS 6.0, SSIS, JavaScript, LINQ, XML, HTML5, CSS, MVVM, SQL Server 2008/2012, SSRS Keywords: cprogramm csharp user interface message queue javascript microsoft procedural language North Carolina Texas Virginia