Post Job Free

Resume

Sign in

Software Development Sql Server

Location:
Elkhorn, NE
Posted:
February 11, 2024

Contact this candidate

Resume:

Gopala Raju Penmetsa

+1-402-***-****

ad3j34@r.postjobfree.com

Summary

15+ years of experience in the design and development of applications and integrations in Microsoft technologies.

Experience in desktop, web, and mobile hybrid applications with Angular

Building Angular applications for Enterprise level applications

Used Angular directives and created custom directives and used them in SPA.

Extensive experience in developing various applications using Visual Studio.NET technologies like Angular, C#, .NET Framework (4.8), VB.Net, ADO.NET, ASP.NET/.NET core, .Net Web Services, XML, XAML, J-Query, HTML, CSS, Angular JS, MS SQL Server, MY SQL, Azure, SQLite, Windows Presentation Forms, REST API’s, GitHub, MVVM, and JavaScript, Mango DB, Azure logic app, function app, azure service bus, blob storage, Azure Redis cache.

Proven mentor and trainer, skilled at communicating with all organizational levels and cross-functional teams to develop a shared vision and foster a culture of excellence.

Experience in working in an Agile Software Development environment with teams located all over the world.

Highly motivated with excellent team-building skills and problem-solving skills.

Manage and coordinate the offshore team.

Sound understanding of design patterns and programming paradigms along with Agile Software Development methodologies which lead to successful projects.

Experience in ORM LINQ (Entity Framework). Experience in Visio documentation tool.

Experience in Integration testing, writing Test cases, Test plans, Bug analysis, and fixes.

Good team player with excellent communication and interpersonal skills, and the ability to work individually or as part of a team.

Highlights

• C# .NET

• Data Binding

• WPF

• MVC, MVVM

• LINQ

• ODATA

• Design Patterns

• Windows Forms

• WCF RIA Services

• SQL Server 2008/2010/22013

• Agile development methodologies

• Entity Framework 6.0

• TFS, GitHub

• Power Platform

• Logic Apps

• Azure storage

• JavaScript

• Angular, Angular JS

• ASP .NET MVC5

• XML, JSON, AJAX

• REST-based Web Services using WCF.

• SOA (Service Oriented Architecture)

• Web API

• HTML5

• CSS, SCSS, UX/UI & Bootstrap

• jQuery

• Jasmine, Karma

• MS Azure – App Services

• Azure SQL

• Function apps

• Ngrx, RxJs

Education: Master of Computer Application (MCA), Madras University, Chennai, India, 2004. Employers:

InEight Inc. has been working as senior technical lead from Sep 2019 to till date.

Prokarma Softech Pvt Ltd/INC worked as senior technical lead from Feb 2017 to Sep 2019.

Meridiansoft, Inc. worked as team lead from Feb 2016 to Dec 2016.

Capgemini India Pvt Ltd. worked as a Senior Consultant from Nov 2014 to Feb 2016.

Motivity Labs worked as a technical lead from Jan 2014 to Sep 2014.

Prime KI Software Solutions Pvt Ltd worked as a team lead from Oct 2011 to Jan 2014

Kensium Solutions Pvt. Ltd. Worked as a senior associate from Nov 2007 to Sept 2011.

Mashcom Pvt. Ltd. Worked as a software engineer from Jan 2005 to Oct 2007. Projects Experience

Client: Kiewit – InEight, Omaha, NE Sep 2022 – till date Project Name: Schedule Role: Full stack developer Project Description

InEight Schedule is the only construction scheduling software designed specifically to improve project predictability and performance. Leverage AI to accelerate plan development and quality. Ensure buy-in with collaborative planning. Account for and mitigate risk to drive certainty in execution. This is how InEight Schedule delivers better plans, faster.

• Use history as the basis of new plans.

• Rapidly detail plan and calibrate your schedule by accepting AI suggestions.

• Achieve consensus on schedule durations and cost so the team has a plan they believe in

• Complete visibility into project risk profiles enhancing analysis at the bid phase and every phase through project closeout.

• Align construction execution for the team in the field with the timeline defined in your schedule. Technologies: .NET core, Angular, typescript, C#, ASP.NET Web API OData, SQL server, Azure logic app, function app, azure service bus, blob storage, Azure Redis cache, Xunit, Jasmin and SCRUM methodology.

Designing and implementing complex Angular applications

Resolving technical issues

Keeping up to date with the latest Angular technologies

Participating in code reviews

Writing unit tests

Participating in code deployments

Working with other teams to ensure that Angular applications meet the needs of the business

Setting up and maintaining CI/CD pipelines

Managing infrastructure resources

Troubleshooting issues in the application or deployment processes

Collaborating with development and operations teams

Ensuring security and compliance

Client: Kiewit – InEight, Omaha, NE Sep 2017 – Nov 2022 Project Name: Change Role: Technical Lead

Project Description

InEight® Change provides every stakeholder with a continuous view of overall project progress or the status of any individual issue to facilitate communication in time to avoid or accommodate potential change orders. InEight Change manages impacts on budget and profit and assures the correct actions are taken to comply with every approved change.

When used with InEight Contract, you have full access to contract data to incorporate change into subcontractor scope or tie issues to subcontractor performance. Technologies: .NET Framework 4.6, C#, ASP.NET Web API OData, ASP.NET MVC5, jQuery, AngularJS, SQL server 2016, Visual Studio 2017, Azure logic app, function app, azure service bus, blob storage, Azure Redis cache and SCRUM methodology

Own one or more modules of the project under development

Speak with customers/ BAs to gather & understand requirements, estimate, design, implement & review code using multiple frameworks that should meet functional & non-functional requirements.

Flexible in working under changing and different work settings.

Accurate time accounting and reporting of own work.

Promptly escalate issues, that affect product delivery and quality that are beyond the scope of influence and report the same to the reporting manager.

Pay high attention to detail in all work.

Quality, on-time delivery of agreed deliverables

Take up the responsibility of the entire Project.

Carefully analyze the project and rectify the errors found in the process.

Undergoing the process of analysis to fulfill the requirement of system-wide.

Developing the detailed design structure after understanding the requirements and the design.

Implementing the best practices and coding standards of the project.

Keep on asking for reviews and feedback from your peers.

Reporting for all the weekly tasks in the form of accurate and detailed reports.

To keep a check on the whole system, conduct the testing and integration testing for the entire system.

Working on identifying the project risk and planning mitigation action with the PM at the project level.

Leaders should be proactive while reacting to surprises and should have written explanations for the same.

The Lead also has to assist and guide the Project Lead/PM/BA in project coordination.

To ensure that the Team is working as per the listed procedures, the Lead should conduct the FIR- Process check master.

Lead should also work on constantly increasing the productivity of the team and reducing the waste on the other end.

A Tech Lead should inspire all the other team members, a Lead who is looked upon by all the members.

Client: Kiewit – InEight, Scottsdale, AZ Apr’2016 – Aug’ 2016 Project Name: Core Role: Developer

Project Description

To solve this problem, InfinyD consolidates data from disparate sources to create a single project platform that can be leveraged across the project lifecycle. Not a design tool, InfinyD instead links business data into a project information model that federates every object that needs to be manufactured, installed or constructed. With InfinyD, project teams share a model that becomes enriched with relevant project data, ensuring better communication, alignment, and efficiency. By collecting relevant project data during project execution, the turnover process is streamlined, and owners can then more efficiently perform ongoing maintenance.

Technologies: .NET Framework 4.6, C#, ASP.NET Web API OData, ASP.NET MVC5, jQuery, AngularJS, SQL server 2014, Visual Studio 2013 and SCRUM methodology

Interstellar is a cloud-based solution that eliminates risk by having hardware and software managed and protected in the cloud, plus enables delivery of software to remote locations – such as field job sites, at home, or at the hotel – without any downloads or plug-ins; most importantly, it eliminates the burden and worries of managing technology infrastructure, allowing customers to focus exclusively on core business construction.

Coordinate with business analysts, gathering requirements and converting them into business solutions.

Use ASP.NET Web API for creating various OData services.

Use Entity Framework 5 for database interaction with the Repository.

Practice Agile Methodology to review the progress of the project in sprints and be involved in a daily scrum with the client.

Create responsive web pages with AngularJS and Bootstrap

Use AngularJS for client-side one-way and two-way data bindings to build dynamic views of data.

Create and Use AngularJS factories, and services for CRUD operation.

Use AngularJS directives and create custom directives.

Develop a Responsive UI layer utilizing semantic HTML5, AngularJS, and REST API architecture while adhering to the latest web UI standards, design patterns, and best practices.

Develop Single Page Application (SPA) apps using AngularJS.

Use Azure ESB solution as a communication channel among different software modules.

Test and troubleshoot defects.

Use LINQ to aggregate data from repository layers.

Use collections, interfaces, and abstract classes to implement the project and also worked with the Exception Handling

Use ASP.NET MVC Data annotations to enforce data validation.

Use Team Foundation Server (TFS) for version control.

Review the codes of other team members to ensure standards and practices are being followed.

Perform unit, functional, and integration testing. Client: Deloitte, Chicago, IL Nov’2014 – Feb 2016. Project Name: DRMS Role: Technical Lead

Technologies: AngularJS, Bootstrap (CSS), ASP.NET, MVC5, WCF, Restful services, Entity framework, SSIS, IIS 7.5 and SQL server 2012.

About Client

Deloitte” is the brand under which tens of thousands of dedicated professionals in independent firms throughout the world collaborate to provide audit, consulting, financial advisory, risk management, and tax services to selected clients. Each member firm provides services in a particular geographic area and is subject to the laws and professional regulations of the particular country or countries in which it operates. Project Description

Deloitte Risk Management System (DRMS) is a global cross-functional system that is used by Deloitte member firms for automating and managing the client and engagement acceptance/continuance. Modules: DRMS, DAS, DTX, DCCS and Services (4.0 & 3.5). Responsibilities:

Involved in gathering requirements and creation of functional specifications for the project, based on the existing use cases and new use cases proposed by the client.

Involved throughout in Software Development Life Cycle (SDLC) process.

Experience with all phases of SDLC in Agile (SCRUM) methodologies.

Implemented IOC (Inversion of Control) through Structure map.

Used C#.Net to implement business logic.

Developing WEBAPI Restful Service.

Involved in Database Design, created all kinds of objects like tables and T-SQL views, stored procedures, and triggers.

Used Try, Catch, and finally blocks to catch exceptions thrown.

Utilized Master pages, Themes, Navigation controls, and Authentication to design secure web pages using ASP.NET MVC and built highly responsive and interactive AJAX-enabled Web applications using the AJAX Tool kit.

GUI development using C#. NET, ASP. Net MVC, HTML5, CSS3, AJAX, JQuery and JQuery Mobile.

Created several ASP.NET pages using ASP.NET, C#, ADO.NET, LINQ (Entity Framework), and SQL Server 2008R2.

Designed reports using SSRS and called them in Web Application.

Used Entity Framework as an ORM tool to map classes with tables to enable working with rows as objects.

Experience in working on CSS3 settings and improving the HTML5 element's style behavior for the UI display.

Used LINQ to retrieve the data from the backend through Entity framework.

Transferred data to the front end in JSON format.

Developed database objects such as tables, views, PL-SQL stored procedures, and user-defined functions for database operations in SQL SERVER 2008 standard edition.

Followed TDD (Test Driven Development) when implementing Web Service for the budget approval process.

Used Visual Source Safe (TFS) for source control.

Code review of other team members to ensure standards and practices are being followed.

Unit, Functional, and Integration Testing.

Client: Vertafore, Bothell, WA Jan’2014 – Oct’2014 Project Name: Engage Role: Technical Lead

Technologies: ASP.NET, C#, MVC4, WCF, ENTITY FRAMEWORK AND SQL SERVER 2008. About Client

Vertafore is a top provider of software for the insurance industry. We create award-winning solutions to boost productivity, lower costs, and help agents and carriers grow their businesses. We’re leading the shift to cloud computing and mobile applications. Along with our Bothell, Wash. office, we are located in East Lansing, Conyers, Pulaski, and Windsor, among other cities nationwide. Project Description

The Engage management system is the most flexible and powerful management system available today, designed specifically to help large agencies, MGAs, bankers, and national brokers simplify workflow, increase productivity, enhance customer service, and control operating costs. Engage is also the only enterprise-level solution that can be easily customized to meet the demands of large, complex organizations providing access to remote users, connecting and managing multiple offices, integrating with an acquired company, and much more. Modules: Engage Services, Client Portal, Common Carriers Responsibilities:

Created several ASP.NET pages using ASP.NET, C#, ADO.NET, LINQ, and SQL Server 2008.

Designed User Controls for document upload, Comments Input, Multi Select Dropdown with Textbox, and Risk Question Control, which was used heavily across the application.

Created Business Layer/Data Access Layer using C#, ADO.NET, LINQ, and SQL Server 2008.

Practiced Agile Methodology to review the progress of the project in monthly sprints.

Preparing SRS, URS, Traceability matrix, and User guide Documents.

Leading the Team, Scheduling, Conducting meetings, Client interaction, and Project delivery.

Developing client screens using ASPX and HTML5.

GUI development using C#. NET, ASP. Net, HTML5, CSS3, AJAX, and jQuery Mobile.

Created several ASP.NET pages using ASP.NET, C#, ADO.NET, LINQ (Entity Framework) and SQL Server 2008.

Designed and implemented the UI with extensive use of JavaScript, jQuery, and Ajax.

Designed reports using SSRS and called them in Web Application.

Worked on Performance-related Issues in SQL Server database.

Developed WCF services to save/get the data for UI screen using C# and LINQ.

Used CSS classes/skins for client-side control UI formatting and provided the same look and feel throughout the application.

Developing Mobile web applications for Android, IOS, WebOS, Blackberry, and win7.

Code review of other team members to ensure standards and practices are being followed.

Unit and Integration Testing.

Used Microsoft Team Foundation Server TFS for source repository and version control.

Started working on migrating ASP.NET application to ASP.NET MVC application.

Created Windows applications in Win Forms, C#, and LINQ-SQL. Client: Nationwide Mutual Insurance Company Nov’2011 – Dec’2013 Project Name: Harleysville Group Role: Team Lead Technologies: ASP.NET, C#, MVC AND SQL SERVER 2008. About Client

Harleysville was Founded 1917 from the state of Pennsylvania with Mutual Auto Theft Insurance. In 1933, that company was merged with the Auto Theft Company, then, in 1956, the company's name was changed to Harleysville Mutual Insurance Company. In 1960, Harleysville Life Insurance Company was established to offer life insurance and related financial services. Project Description

Harleysville using legacy technologies like classic ASP, VB 6.0, and VB script since 1998. Nowadays Harleysville migration the code to the latest technologies like .Net 4.0, C# (MVC), WCF, jQuery, XML & XSLT.

Harleysville supports two types of service 1. Personal Lines 2. Commercial Lines. This company has multiple vendors like us. We are giving support for commercial line policies CAU, WC, PRP, GL, BOP, and LIA.

Modules: Supports legacy system defects fixing, CL 2.0 browser Agnostics jQuery, Agents Uploads, Testing.

Responsibilities

Worked closely with members of the development team through the full systems lifecycle including requirements capture, design, development, testing, and deployment.

Developed 3-tier logic for various classes, modules, and Web forms in ASP.NET 2.0 using C#.NET as a code behind the language.

Used ASP.NET 2.0 Server controls, User Controls, and HTML controls.

Created (BLL) Business Logic Layer and Presentation layer in Visual Studio .NET 2005 and C#.NET.

Designed Web-Form, User Interface with HTML and Cascading Style Sheets (CSS).

Practiced SDLC Waterfall Methodology to review the progress of the project.

Designed and created Relational database tables using Normalization, managed clustered and non-clustered indexes, and implemented Relationships b/w tables.

Used Object Oriented Programming (OOPs) to make it more efficient.

Used ADO.NET to get the data from the database and send it back.

Worked on MS SQL Procedures, indexes, Functions, cursors, etc., and Created/Altered Tables using SQL Server 2005.

Created stored procedures for inserting, deleting, and updating screen data into the database using SQL Server 2005.

Used the built-in mechanisms of SQL Server 2005 for data integrity like Default, Not Null, Check, Unique, Primary Key, and Foreign Key, etc.

Created Stored Procedures, Triggers, and Views to perform automated rules, updating to related tables Using SQL Server.

Developing client screens using ASPX/XSL

Client: Krohn & Moss, Ltd., India Nov’2007 – Oct’2011 Project Name: PNC Workflow Role: Team Lead

Technologies: ASP.NET, C#, MVC3, WCF, ENTITY FRAMEWORK AND SQL SERVER 2008. About Client

The law firm of Krohn & Moss, Consumer Law Center®, was founded in 1995 by attorneys Adam Krohn and Greg Moss, to provide legal representation to consumers with defective vehicles and products. Since its inception, the Krohn & Moss lemon law and warranty law practice group has expanded from Illinois to include 8 additional states: Ohio, Indiana, Arizona, Wisconsin, Missouri, Florida, and California. In 1998, our consumer fraud practice opened, concentrating on auto fraud claims such as odometer setbacks, auto dealer financing scams, and vehicle history misrepresentations. In 2002, FCRA (Fair Credit Reporting Act) and FDCPA (Fair Debt Collection Practices Act) violations became an additional focus of the firm, in our efforts to assist victimized consumers with credit reporting and debt collection issues. Thousands of clients later, Krohn & Moss Consumer Law Center® has arbitrated, settled, and litigated cases that have had a profound impact on consumer protection law.

Project Description

This application is used for a law form internal work process. From the internet end users submit leads to this website then office people use this data and proceed accordingly. Your lemon law rights: This website is used for those who have vehicle-related problems those people submit their details on the website.

We stop debt collectors: This website is used for those who have finance-related problems those people submit their details on the website.

Your collection rights: This is a blog site using commenting on the posts. Used for posting articles. Lemon Law America: This is a lemon law-related site. In these fifty states status is available. For each state forms and lawyers are also available.

Modules: Customer Fraud, FCRA, FCDCPA, Lemon Law and TCPA. Responsibilities:

Designed and developed user interface using ASP.NET and C#.NET.

Developed user controls and validation controls using ASP.NET. Creation of screens and coding.

Worked closely with members of the development team through the full systems lifecycle including requirements capture, design, development, testing, and deployment.

Was involved in all the stages of development from the Design to the Maintenance.

Implemented business logic as .NET Framework assemblies using C#.NET.

Used ADO.NET and related data objects such as Data Adapter, Data Reader, Data Set, and Data Table for consistent access to SQL data sources.

Coded Stored Procedures that contained joins and were used in ADO.NET for creating, updating, or deleting the data and even performing some information-related tasks with multiple tables.

Created stored procedures for inserting, deleting, and updating screen data into the database using SQL Server 2000.

Used the built-in mechanisms of SQL Server 2000 for data integrity like Default, Not Null, Check, Unique, Primary Key, and Foreign Key, etc.

Created Stored Procedures, Triggers, and Views to perform automated rules, updating to related tables Using SQL Server.

MASHCOM Technologies, India Feb’2006 – Nov’2007

Project Name: SCRM portal Role: Developer

Technologies: ASP.NET, C#, AND SQL SERVER 2000.

About Client

The requirements will be prioritized based on our customers' needs. Manufacturers can download a seed code to be used to start pill coding numbers. Specific information will be requested from the manufacturer. Including the type of pill, machine, etc. When the pharmacist is dispensing the pill, the pharmacist will need to link the Code and/or bar code and/or other information on the unit dose with the patient Rx# and the Pharmacy ID#. When the prescriber prescribes, a patient is told of the tracking ability of his pills A LEP

(Law enforcement Personnel) may call into SCRM. SCRM will ask for the l (LEP) Name, ID, etc. SCRM will record the conversation and may bio-metrically authenticate the users. SCRM may ask the Prescriber if they want to add other information.

Project Description

This portal is used to track pharmaceutical information and generate reports for raw materials, production, stock, and expenses. SCRM Admin provides affordable, easy-to-use medical billing tools that help medical billing and healthcare professionals improve how they manage their business and increase revenue. SCRM uses our practice management software for our robust scheduling capabilities and the ability to integrate with their chosen EHR software. Medical billing companies rely on our software to take advantage of the revenue cycle capabilities. Billing companies track receivables for multiple client accounts and locations and also track which employees made changes to accounts. Our software is compatible with the needs of hospital-based physicians, labs, and other medical facilities. Our scalable pricing means as your business grows, our prices adjust.

Modules: SCRM in the portal, SCRM out portal, and SCRM admin portal. Responsibilities:

Requirement study and analysis

Developing Class libraries for the data access layer.

Designed and developed user interface using ASP.NET and C#.NET.

Developed user controls and validation controls using ASP.NET. Creation of screens and coding.

Involving DB designs.

Writing Stored Procedures and views.

Unit testing and Integration testing

Certifications: Microsoft Certified: Azure Data Fundamentals, DAT201x: Querying Data with Transact- SQL



Contact this candidate