Post Job Free

Resume

Sign in

Asp.Net Sql Server

Location:
Springfield, IL
Posted:
January 18, 2024

Contact this candidate

Resume:

Surya Venkata Narsimha Kumar

Hanumantha Vajjala

Phone: 425-***-****

Email: ad2vvs@r.postjobfree.com

Professional Summary:

•19+ years of experience in analysis, design development of windows and web applications. Experience in design and development of n-tier applications using .NET Technologies like AZURE, WEBAPI, ASP.Net, .NET 6, ASP.NET Core, Angular 12, VUE.JS, Kendo UI, Knockout JS, jQuery, HTML5/SCSS/CSS, Microsoft Entity Framework 6, Silverlight, MVC 5, WPF, WCF, ASP.NET, C#, Win forms, Web forms, User controls, ADO.NET, LINQ.

•15 years of extensive experience in Microsoft SQL Server (2008/2012/2014) Stored Procedures, Functions & Triggers.

•Extensive experience in architecture, design and development of Client-Server and Distributed Web Applications with ASP.NET 3-Tire and N-Tire Architecture.

•Experience in SQL Server Business Intelligence including SSIS.

•Experience in XAML, XML, XSLT, XSD, AJAX, CSS, Java Script, graphic production tools like Expression Blend.

•Experience in all aspects of the Software Development Life Cycle (SDLC) including requirements, design, architecture, development, testing.

•Worked on SCRUM and AGILE methodologies.

•Excellent client interaction, technical presentation and team building skills.

•Excellent communication and analytical skills, a recognized team player.

•Self-starter and comfortable in high intensity and challenging work environment.

Education:

•Masters of Computer Science, Osmania University, India. 2002.

•Bachelor of Computer Science, Osmania University, India. 2000.

Certifications:

•AZ-204 : Microsoft Certified Azure Developer

•AZ-900 : Microsoft Azure Fundamentals

•Microsoft Enterprise Application Developer (MCPD EA)

Technical Skills:

•Cloud Computing: PCF, PCF Services, Microsoft Azure - Cloud Services (PaaS, IaaS), Storage, Web Apps, Functions, Active Directory, Application Insights, Monitoring, Logic Apps, Data Factory, Service Bus, Event Grid, Key Vault and SQL Azure, Cosmos DB.

•.NET Technologies: ASP.NET, ASP.NET Core 3.1/6, .NET 6, AUTOFAC, ADO.NET, LINQ, Entity Framework 6, EF Core 6, Fluent API, .NET assemblies, Swagger/Open API documentation, Kafka, Refit Framework., Docker, Kubernetes, IIS 10, SSL, X509 Certificates.

•Web Applications: ASP.NET MVC, Angular 12, VUE JS, PHP, HTML, CSS, SCSS

•API Services : WEB API, Web Services, WCF Services

•Windows Applications: WPF, Windows Forms

•ERP: Dynamics CRM 2011.

•Databases: SQL Server 08/12/14/16, MS Access, MySQL

•Languages: C#, VB.NET, VB6, C, java, PHP, XAML, XML, XSD and T-SQL.

•Business Intelligence: SQL Server Integration Services (SSIS).

•Business rule Engines: InRule, Drools

•Modeling Software: Visio.

•Source Control: GIT, TFS, Bitbucket, Bamboo CI/CD, Visual Source Safe 6.0/2005.

•Scripting: Power Shell, Angular 12, Node JS, JavaScript, jQuery, Knockout JS, JSON & Typescript.

Work Experience

Wells Fargo Project, Springfield, IL (Aug 22 to Current)

Role: Onsite Lead/Solution Architect

Project: Wells Fargo

Environments/ Skills Used: WEB API, C#, ASP.NET, MVC, Angular 12, ASP.NET Core 3.1, .NET 6, Kafka, Oracle, PCF/Azure, TSQL, SQL Server, AutoSys, App Dynamics, Splunk. Azure App Services, Azure Functions, Azure SQL DB, Azure Cosmos DB, Azure Event Grid, Azure Event Hub, UML, SSL, IIS 10, Visual Studio 2022, Autofac, Unit Testing, MOQ, GIT, JIRA, Bamboo for Build and Deployment, X509 Certificates, Venafi.

Projects

•1IDR, SYNCEN, IIRM, 1FMG Change Management application used for implementing data changes, using automated change management process, as per the scheduled database scripts will be execute and update data in the table as per the given insert, update, delete statements.

•9COM Communication application, this application is used for sending out scheduled email and mail communication to the bank customers.

•These projects are application migration/tech refresh projects starting with requirements gathering, application design, application development, testing, implementation, user training and post implementation support. The system will be developed using the Agile Development Methodology.

Responsibilities:

•Defining the technology architecture and creating technical specifications.

•Collaborating with stakeholders and other teams to ensure that the solution aligns with business goals and objectives.

•Providing guidance and leadership to developers and other team members throughout the implementation process.

•Ensuring that solution meets performance, scalability, and security requirements.

•Managing risk by identifying potential issues and developing contingency plans.

•Evaluating new technologies and staying up-to-date on industry trends.

•Requirements gathering, application design, application development, testing, implementation, user training and post implementation support.

•Creating technical design documents.

•Create system architecture documents.

•Created UML diagrams using Visio.

•Work on system integration.

•Coding and development using the following tools and technologies C#, ASP.NET Core, HTML, CSS, .NET 6, WEB API, JAVASCRIPT, work on multithreading of the application, Visual Studio 2022, Visual Studio 2017, GIT code repository, JIRA, Confluence. Database development using SQL SERVER 2019, Oracle Data Store, Oracle. User interface development using HTML, MVC, CSS, WEB API, .NET 6, ASP.NET Core, Entity Framework, ANGULAR 12, HTML, TYPESCRIPT.

•Work with Bamboo CI/CD.

•Jira story board creation and updates.

•Scan code for code vulnerabilities using Sonar software.

•Unit testing developed code and writing unit tests.

•Test application in development environment.

•Deploy and configure applications in cloud environment.

•Work on application security by implementing authentication and authorization, using Ping fed, OAuth tokens.

•Participate in planning meetings.

•Participate in requirement grooming meetings.

•Production deployment release preparation, approval for releases, change management meetings and certify deployment from developer side.

•Participate in daily standup meetings provide updates on tasks, stories assigned to scrum master.

Charles Schwab, Westlake, TX (Jan 21 to Aug 22)

Role: Sr. Developer

Project: DS-Bell

Environments / Skills used: ASP.Net Core 3.1, ASP.NET, HTML, C#, TSQL, ADO.NET, KAFKA, PCF, WEB API, Swagger, Open API documentation, HTML, CSS, XML, Solace PUB SUB, SignalR, X509 Certificates, Venafi.

Responsibilities:

•Work on Architecture review of the applications.

•Participated in application design review meetings.

•Created UML diagrams using Visio.

•Worked on health check and status check of Account publisher, PSR, PUC applications.

•Migrate applications to ASP.NET Core MVC, using HTML, CSS, Javascript.

•Work on Kafka integration for Account Publisher application.

•Work on enhancements, maintenance, framework upgrade and Veracode security bug fixes for the various applications maintained by the team.

•Worked on Bamboo, Harness build and deployment of the applications, in QA, PreProd &Prod.

•Worked on production release notes and deployment instruction creation for Account Publisher, Livehelp, PSR, PUC, QuotePulsing, Solace, Subscription Manager applications.

•Write unit tests.

•Worked on converting legacy PSR, PUC into PCF applications.

•Talk to stake holders and other dependent teams to unblock any integration issues.

•Fix non prod environment issues and unblock other teams.

•Participate in daily standup, retro, planning scrum activities.

•Production deployment release preparation, approval for releases, change management meetings and certify deployment from developer side.

•On call production support.

Department of Child and Family Services State of Illinois, Springfield, IL (Aug 20 to Dec 20)

Role: Full Stack Application Developer.

Project: DCFS.

Working on the child neglect and abuse reporting application. This application is a public application for the state of Illinois, it is used by public, schools and hospitals.

Environment/Skills used: Mobile Xamarin applications, MVC, C#, TSQL, HTML, CSS, Bootstrap, ADO.NET, Entity framework 4, OAuth Authentication.

Responsibilities:

•Design and development of the screens using Bootstrap, MVC and CSS.

•Involved in implementation of User Interface, Business logics, and Data Access layers.

•Create database tables and relationship between the tables.

•Create constraints on the tables.

•Create DB stored procedures and functions.

•Design and development of the API layers, using WebAPI.

•Create API validators using fluent validation.

•Code the validation rules using fluent API.

•Design and development of the service method with business logic, using Entity framework 6.

•Create domain entities.

•Create relationship between the entities.

•Configure and use auto mapper.

•HTML, CSS for creating UI screens.

•Create UI validations using jQuery and MVC.

•Create JavaScript Functions for UI validation.

•Manage the dependency between the JavaScript files.

•Work on user stories and change the progress of the stories every day.

•Unit test the developed software.

•Work on bug fixes.

•Create software component interaction diagrams using UML tools.

•Create entity diagrams using UML tools.

•Design and development of unit tests.

•Participate in sprint planning.

•Participate in sprint retrospective meetings.

•Interact with the business and stakeholders to clear any requirement gaps and confirm the software deliverables.

•Report progress of the tasks assigned daily to the scrum master.

•Interact with the team members and help them in completing their tasks.

CQuest America Inc, Springfield, IL. (April 20 to July 20)

Role: Full stack Sr. Application Developer.

Project: State of Oregon Women Infants & Children system.

Oregon WIC Program, this public health program WIC is the Special Supplemental Nutrition Program for Women, Infants and Children.

Environment / Skills used: Angular 7, HTML, C#, Typescript, Bootstrap, ADO.NET Core 3.1, Entity framework, DOTNET Core 3.1, TSQL

Responsibilities:

•Design and development of the WIC Participant, Program Management UI using Angular, Bootstrap & Typescript.

•Design and development of the API layers, using WebAPI.

•Design and development of the service method with business logic, using Entity framework Core 3.1.

• Design and development of unit tests.

State of Illinois Teacher Retirement System, Springfield, IL (April 19 to April 20)

Role: Sr. Application Developer.

Domain: Retirement.

Project: Gemini

Environment / Skills used: Azure, ADO.NET Core 2.1, MVC 5, Web API, Simple injector, VUE JS CLI, Vuetify, Typescript, TSQL, Entity framework Core.

Responsibilities:

•Design and development of the UI using VUE, Vuetify, HTML, SCSS & Typescript.

•Design and development of the API layers.

•Designed the application using Azure App Services.

•Design and development of the service method with business logic.

•Design and development of unit tests.

•Design and development of the database procedures.

Horace Mann Insurance, Springfield, IL (May 16 to April 19)

Role: Application Developer.

Domain: Insurance.

Environment / Skills used: ADO.NET Core 2.1,ASP.NET, MVC 5, HTML, JQUERY, Elasticsearch.NET NEST, LINQ, Entity Framework, Windows service, Autofac DI, C#, WEB API, SOAP UI, VSTS Unit Testing, Angular 5, TSQL

Projects: Corporate Database Management System. Auto Quick Quote, Rules Engine.

Responsibilities:

•Design of the application using software engineering concepts.

•Participate and prepare Solution design in consultation with the design architects.

•Implement POC to support the design.

•Coding of the software components and writing unit testing, using Visual Studio Tests, C#, ASP.NET, Windows Service, MVC 5, ASP.NET Core 2.0, MVC, Elasticsearch.NET NEST, WEB API, AUTOFAC, BOOTSTRAP, HTML, CSS.

•Create Business rules using Java, Drools open-source rule engine.

•Create database design of tables, using code first approach, create constrains and ensure referential integrity of relations.

•Deploying the application to the development environments.

•Coordinating and managing a team of developers.

•Prepare and update weekly status reports.

•Analyzed and created technical design document to migrate rules engine application from VB6 to .NET.

Brillio, Jersey City, NJ (Jan 14 to April 16) Client: KPMG, Montvale, NJ

Environment / Skills used: ASP.NET, MVC 5, HTML, CSS, JQUERY, Knockout JS, ADO.NET, LINQ, Entity Framework, Kendo UI Controls, C#, WCF, SQL Server 2014, TSQL, Stored Procedures, Functions.

Role: Application Developer

Projects: Liability and COD allocations.

Responsibilities:

•Analyze software programs and applications.

•Design the application components adhering to the requirement specifications. Participate/provide the inputs in the design discussions.

•Code the application components by using the software engineering principals and design patterns, new/reusable components using MVC 5, HTML5, CSS3, JQUERY, KENDO UI, WCF, Microsoft Entity Framework, ADO.NET, Internet Information Server (IIS), LINQ, TSQL, Stored Procedures, Functions, SQL Server 2014 and SSIS.

•Provide the daily status updates to my supervisors & find solutions to mitigate any blocking issues which come up during the product/component development life cycle.

•Documenting and modifying software specifications throughout the production life cycle.

•Conduct client meetings for requirements clarification or understanding.

•Give presentations on the application components designed/developed/prototype design to the client.

•Unit test the designed software components to meet the requirement specifications.

•Fix the issues which fail the unit test cases.

•Release the developed components/modules to the Software Quality Assurance (SQA)

•Maintain the application by analyzing and amend software errors in a timely and accurate fashion and provide status reports where required.

•Coordinate and manage the work with offshore development team of developers.

Accenture, Seattle, WA (Oct ‘12 –Dec 13) Client: Microsoft, Redmond, WA

Environment / Skills Used: WPF, Microsoft Dynamics CRM 2011, SQL Server 2012, Entity Framework 4.0 and WCF, ADO.NET, TSQL, C#, HTML, CSS.

Role: Computer Programmer

Projects: MSSolve

Responsibilities:

•Requirement analysis.

•Developing functional design document and Technical design document.

•Implementation of User Interface, Business logic, and Data Access Components.

•Creating l user controls, custom controls in WPF, XAML and code behind with C#.

•Developed core functionality with the Entity Framework and WCF, Microsoft dynamics CRM.

•Used third party tool XCEED to develop custom rad controls.

•Integrating the UI layer with the database layer using the WCF service.

•Retrieving data using LINQ to SQL and LINQ to Objects worked with the database using LINQ to SQL.

•Deploying the application to IIS 7.0 server and maintaining the same.

•Designed and implemented stored procedures in SQL Server 2008.

•Conduct client meetings for requirements clarification or understanding.

•Give presentations on the application components designed/developed to the client.

•Performing unit, integration and system tests.

Accenture, India, Hyderabad (March’12 –Aug’12)

Client: Microsoft, Hyderabad

Role: Sr. Software Engineer

Environment / Skills Used: .NET 4.0, C#, Silverlight 4.0, IIS 7.0, XAML, SQL Server 2008, Visual Studio 2010, Expression Designer, Expression Blend, Silverlight 5.0, WCF, .NET assemblies, ADO.NET, HTML, CSS, Java Script, IIS 7.0, VSTF .

Project: HAWK

Responsibilities:

•Involved in implementation of User Interface, Business logics, and Data Access layers.

•Created several user controls, custom controls in Silverlight and code behind with C# working within MVVM architecture using agile-scrum management approach.

•Created rich-web application using XAML.

•Created enhanced properties and events dependency properties and routed events in Silverlight.

•Implemented the project with WCF for communication.

•Worked with a third party component called XCEED One which we used to display data.

•Designed and implemented stored procedures, views in SQL Server 2008.

•Involved in performing unit, integration and system tests.

Accenture, India, Hyderabad (Nov '11 – March '12)

Client: Microsoft, Hyderabad

Environment / Skills Used: ASP.NET, HTML, CSS, Microsoft Visual Studio 2010, C#, XAML, LINQ, Enterprise Library 4.0, ADO.NET, TFS, TSQL.

Role: Sr. Software Engineer

Project: RTS

Roles & Responsibilities

•Interacted with the end Business Users in gathering the Functional & Business requirements.

•Involved in creating the Functional specs and detailed design document for the project.

•Designed ASP.NET Web Pages, user controls and localization files.

•Involved in creating the Master Pages.

•Extensively used LINQ for Querying throughout the application.

•Used Enterprise Libraries for logging and Exception Handling.

•Involved in developing Automated Test Scripts using VSTF Tests.

•Used TFS to coordinate with team member’s development.

Accenture, India, Hyderabad (Aug '11 – Oct '11)

Client: Microsoft, Hyderabad

Environment: SSIS, Microsoft Visual Studio 2010, SQL Server 2008, ADO.NET, HTML, CSS, C#, TFS.

Role: Sr. Software Engineer

Project: SDB

Responsibilities:

•Interacted with the end Business Users in gathering the Functional & Business requirements.

•Involved in creating the Functional specs and detailed design document for the project.

•Involved in implementation of Business logics, and Data Access Components using SSIS.

•Designed and implemented stored procedures in SQL Server 2008.

•Involved in performing unit, integration and system tests.

•Involved in developing Automated Test Scripts using VSTF Tests.

•Used TFS to coordinate with team member’s development.

Accenture, India, Hyderabad (May '11 – July '11)

Client: Microsoft, Hyderabad

Environment: ASP.NET, .NET Framework 4.0, SSIS, Microsoft Visual Studio 2010, SQL Server 2008, TFS, ADO.NET, HTML, CSS, C#, VB.NET, TSQL, C

Role: Sr. Software Engineer

Project: Activate Site

Responsibilities:

•Involved in Initial requirement discussions with the business during the design phase.

•Involved in developing functional design document and Technical design document.

•Involved in implementation of User Interface, Business logics, and Data Access Components.

•Involved in Bug Fixing and enhancements.

•Involved in developing Automated Test Scripts using VSTF Tests.

•Worked on creating VB.NET web applications.

•Used TFS to coordinate with team member’s development.

Accenture, India, Hyderabad (Jan ‘10 –April ‘11) Client: Microsoft, Hyderabad

Environment: WPF, WCF, XCEED Controls, SQL Server 2008, Entity Framework 4.0, ADO.NET, HTML, CSS, TSQL, C#, C

Role: Sr. Software Engineer

Project: MSQuote

Responsibilities:

•Involved in developing functional design document and design document using the requirements document.

•Worked in designing and developing User experience for the project.

•Worked in developing the business layer and data access layer using Entity Framework, C# and SQL Server.

•Designed and developed custom .NET components and user controls using WPF, XMAL and C#.

•Integrated the application with back end using WCF Services.

•Created Stored Procedures, User Defined Functions, Views, and Alter, Insert Update statements for the User Interface.

•Developed Resource Dictionaries to enable control of page layouts, colors, fonts and animations as part of client side development.

•Involved in performing unit, integration and system tests.

Accenture, India, Hyderabad (Jan‘08 –Dec’09)

Environment: ASP.NET, MVC, Entity Framework, SQL Server 2005, TSQL, HTML, CSS, C#, VB.NET, C.

Role: Software Engineer

Project: Equiniti

Responsibilities:

•Involved in developing functional design document and design document using the requirements document.

•Worked in designing and developing User experience for the project.

•Worked on MVC framework.

•Worked in developing the business layer and data access layer using Entity Framework, C# and SQL Server.

•Designed and developed custom .NET components and user controls using ASP.NET and MVC and C#.

•Integrated the application with back end using WCF Services.

•Worked on VB.NET Web Applications.

•Created Stored Procedures, User Defined Functions, Views, and Alter, Insert Update statements for the User Interface.

•Involved in performing unit, integration and system tests.

Accenture, India, Bangalore (Sept ’06 - Dec’07)

Client: DELL India, Bangalore

Environment: ASP.NET XML, XSLT, Storm Framework Controls, SQL Server 2005, HTML, CSS, VB.NET, VB.NET, C#, TSQL, C.

Role: Software Engineer

Project: ESupport http://support.dell.com/

Dell support project provides the support for the user system issues.

Responsibilities:

•Involved in requirements, reviewing and analysis.

•Involved in designing and developing the web application using Web forms.

•Used XML and XSLT to transform the pages and display the content.

•Implemented Web User Interface, Business logics, and Data Access Components using ADO.NET

•Designed and developed custom .NET components and user controls using ASP.NET and C#.

•Integrated the UI and the Database using Web Services using SOAP and XML.

•Involved in the Development of Web service to extract data from different subsystems.

•Worked on VB.NET Web Applications.

•Used C code from C# using DLL import.

•Used JQUERY, JavaScript extensively.

•Designed and implemented relational database, and stored procedures, views, and triggers in oracle.

•Developed Cascade Style Sheet (CSS) to enable control of page layouts and colors and fonts and Java Script, VB Script as part of client-side development.

•Used VSTF automated unit testing to test the applications.

Virtual Economy Pte, Hyderabad (Oct 2003 to July 2006) Role: Application Developer

Worked as Application Developer to create web applications using technologies like ASP, PHP, ASP.NET, C#, SQL Server 2000, HTML, CSS, C#, TSQL, C.

Project: Home near MRT Responsibilities:

•Involved in requirements analysis.

•Involved in designing and developing the web application using Web forms.

•Implemented Web User Interface, Business logics, and Data Access Components using ADO.NET

•Designed and developed custom .NET components and user controls using ASP.NET and C#.

•Used C code from C# using DLL import.

•Integrated the UI and the Database using Web Services using SOAP and XML.

•Involved in the Development of Web service to extract data from different subsystems.

•Used JavaScript extensively.

•Designed and implemented relational database, and stored procedures, views, and triggers in SQL Server.

•Developed Cascade Style Sheet (CSS) to enable control of page layouts and colors and fonts and Java Script, VB Script as part of client side development.

•Responsible for deployment to the production and maintenance of the application.

Fine Forge Pvt Ltd, India (Aug 2002 to Sep 2003) Role: Programmer

Worked as a Programmer, created MS Office based applications using MS Access as database. Worked on accounting application.



Contact this candidate