Post Job Free

Resume

Sign in

Sql Server Stack Developer

Location:
Katy, TX
Posted:
April 15, 2024

Contact this candidate

Resume:

LAKSHMI KONDAPI

P: 281-***-****: E: ad40tz@r.postjobfree.com

SUMMARY

•Over 15 years of professional experience in software development with design, development, quality, and deployment exposure

•Full stack developer with proven capability and experience in analysis, design, development, testing and implementation of commercial applications and web-based business solutions

•Broad, real-world experience working with large enterprise solutions to drive business requirements to technical strategy, product features and deployment in the enterprise

•Extensive experience with Web technologies like WEB API, ASP.NET, WCF & Web Services, IIS 5.0, 6.0, HTML, ASP, XML, SOAP, XSLT, VBScript, JavaScript, SSRS and SSIS

•Good hands-on knowledge of OOPS (Object Oriented Programming Structure) and Agile methodology

•Strong knowledge in Oracle/19c/12c/11.2/10g/9i/8i database designing, SQL Server, MYSQL, SQL developer, PL/SQL programming and Stored Procedures

•Strong development skills in other languages like Java and C#

•Extensive experience in web-based page and site designs using HTML, DHTML, CSS, Themes, Master Pages, Site Map, JavaScript, and AJAX

•Experience with JIRA, GitHub, Team Foundation Server (TFS), CVS

•Experience in integrating code quality tools such as SonarQube, in CI/CD pipelines.

•Exposure to configuration management tools such as Ansible and Terraform.

•Excellent experience in onsite-offshore model interacting with clients and Onsite managers

•Hands on experience with SQL Server 2016, 2014

•Worked extensively on writing Stored Procedures, Triggers, Functions, Views, and Database Design

•Created and maintained SSIS packages to Import/Export data from flat files, XML, Excel, and Oracle

•Follow the agile scrum methodology

•Experience in software unit testing and efficiency in fact-finding, root cause analysis and bugfixing

•Great team player, highly motivated, adaptive, and quick learner with excellent interpersonal, technical and communication skills

•Good at translating complex user requirements and resolving technical and functional issues.

•Strong Knowledge on SQL Server 2016/2014/2012 Business Intelligence SSRS

EDUCATION

•Masters in Computer Applications, Osmania University, Hyderabad, India

•Bachelor’s in Sciences (Maths & Physics), Osmania University, Hyderabad, India

CERTIFICATIONS

•Certified Oracle Cloud Infrastructure (OCI) professional

SKILLS

Languages

Java, J2EE, C#, SQL, PL/SQL, JavaScript, XML, HTML, CSS

Web Technologies

ASP.NET, Web API, AJAX, LINQ, JQuery, JSP, WCF, JavaScript, Web Services, HTML, XML, SAX, DOM, CSS, SOAP, XSLT

.NET Versions

.Net Core, .Net Framework s (4.0, 4.5.x, 4.6.x, 4.7.x)

Databases

SQL Server 2008/2014/2016, ORACLE 7.x/8i/9i/10g/12c

Testing Tools Cloud

JUnit, XML Unit AWS, OCI

Operating Systems

Windows, UNIX, LINUX

EXPERIENCE

Aug ’23 – present Senior Consultant, SuchiERP, Katy, TX

Supported the back-end development for an ERP application used for Small/Medium Enterprises (SME) organizations that are looking for process, cost and operational efficiency.

•Developed scalable application using Core Java resulting in increased application performance.

•Developed CRUD REST API using POST, GET, PUT and DELETE methods.

•REST Web Servies design and Api-integration, deployed via a CI/CD pipeline using Jenkins • Used POSTMAN to test API.

•Participated in Agile Methodology for application development and used JIRA as a project management tool

•Implemented version control using GIT resulting in improved code management.

•Used Eclipse extensively in development and debugging the applications.

•Involved in End-to-end integration testing and functional testing.

Environment: JDK1.8, J2EE, Spring Boot Framework, Eclipse, GIT HUB, Jenkins, Web Services, Windows 10, Angular, Ansible, Terraform, SonarQube, Native script, WAVE, WebLogic, MAVEN, POSTMAN, Oracle12c

Jan ’22 – July ‘23 Senior Consultant, Mythics, Virginia Beach, VA (Remote)

SERIO System for Entry Review and Import Operations (SERIO) - An enhanced and expanded version of the Entry Review (ER) system which incorporates OASIS Investigations Branch (IB) functionality and some functionality available in OASIS Entry Query.

•Involved in development, enhancement, improvement, bug fixing of SERIO web

•Designed and developed business logic layer for connecting clients

•Provided support during technical team meetings for designing suggestions and technologies

•Developed web services layer and implemented business logic and use cases

•Participated in code reviews, architectural reviews, and technical discussions

•Prepared, updated and maintained code standards and application architecture

•Used Rest Controller in Spring framework to create RESTful webservices

•Used Postman to test the RESTful API for HTTP requests such as GET and POST

•Analyzed, escalated, and resolved technical problems for senior members

•Implemented best practices, standards and procedures including quality and delivery methodologies

•Interacted with clients to determine their requirements and needs

•Involved in the testing before going to production

•Engage with multiple stakeholders including the quality assurance team to deliver the requirements on time

•Resolved and troubleshooted problems and complex issues

•Used GIT HUB for all the source code maintenance needs

•Worked on Jenkins to build and deploy the application on Stage and Dev Servers

•Worked on Integrating GIT into the continuous integration (CI) environment along with Jenkins

•Participated in all Production releases

Environment: JDK1.8, J2EE, Eclipse, Spring Boot Framework, GIT HUB, Jenkins, Web Services, Windows 10, Angular, Ansible, Terraform, SonarQube, Native script, WAVE, WebLogic, MAVEN, POSTMAN, Oracle12c

Jan ’08 – Jan ‘22 Senior Developer, United Airlines (Continental Airlines), Houston, TX

Passenger Name Record (PNR) Management

The PNR Management application allows customer to Shop and Reshop the reservations using the Booking Bath. Book reservation writes the reservation details passed by channels to shares and other data sources which will be used by down line services. Data from SFS Data store is needed in real time by other services to complete the award transaction end to end.

•Involved in development, enhancement, improvement, bug fixing of Digital 2.0.

•Supported Java and .Net applications

•Supported New Website Integration (Digital 2.0)

•Designed and developed business logic layer for connecting clients

•Implemented Common Service Layer Web Services for different Clients

•Provided support during technical team meetings for designing suggestions and technologies

•Developed web services layer and implemented business logic and use cases

•Participated in code reviews, architectural reviews, and technical discussions

•Prepared, updated and maintained code standards and application architecture

•Analyzed, escalated, and resolved technical problems for senior members

•Used Window Services for different applications

•Implemented best practices, standards and procedures including quality and delivery methodologies

•Interacted with clients to determine their requirements and needs

•Coordinated with architects and business analysts to determine functionalities

•Involved in the testing before going to production

•Assisted and supported other team members on multiple projects

•Engage with multiple stakeholders including the quality assurance team to deliver the requirements on time

•Resolved and troubleshooted problems and complex issues

•Wrote MSMQ processor for writing data to Oracle database

•Used Microsoft Team Foundation Server (TFS) and GIT HUB for all the source code maintenance needs

•Worked within a CI/CD environment, automating build and deployment processes resulting in improved productivity.

•Worked on Team City and CARA to build and deploy the application on Stage and Dev Servers.

•Used Kibana and Data dogs for logging and Analyzing production issues

• Deploying applications to cloud services using Amazon Web Services (AWS)

•Developed and maintained reusable NuGet libraries.

•Participated in all Production releases.

•Migrated Java legacy applications to .Net.

Environment: Java, J2EE, JBOSS, Eclipse, Couchbase database, Teradata, Oracle12c/11.2, Kibana, Data dogs, GITHUB, Visual Studio 2019/2017/2015, NET Framework 4.6, C#, .net CORE, ASP.NET, LINQ, WCF, WEB API, XML, MSMQ, JSON, TFS, Team City, CARA, Web Services, IIS, Windows 10, SQL Server 2016, AWS

Automated Ticket Reprice Engine (ATRE)

The Automated Ticket Reissue Engine (ATRE) was developed by the Enterprise Development Group of the Technology Department of Continental Airlines. The engine was created to assist ATO, CTO and reservations agents when a passenger requests a change to an E-ticketed itinerary, and that change requires the ticket to be reissued. The automation of this process cuts down the time involved from approximately 20 minutes to 15 seconds or less and creates a consistent method of calculating and collecting additional revenue.

•Involved in designing, development, enhancement, improvement, bug fixing of Automated Ticket Reprice Engine (ATRE) System

•Developed and Maintained a Web application for ATRE Stats

•Coordinated with the Users and the team to acquire requirement enhancements and to resolve the issues/bugs

•Supported the system while in production by fixing problems and handling the change requests

•Directed the development team in India during designing and programming phase

•Developed a statistical chart for ATRE System

•Automated the upgrade mall for Web, KIOS and EZR of ATRE

•Developed a dynamic web application for Day of Departure upgrade plus (DOD)

•Developed a Business Rule Engine Application (BRE) for publishing ATRE weather Policy

•Improved the performance and quality of ATRE system

•Enhanced the ATRE system depending on the user requirement

•Modify and improve the features of the ATRE to enable customer satisfaction

•Involved in the testing before going to production

•Designed database using MySQL

•Developed Stored Procedures using MySQL Query browser

•Supported .NET applications

•Responsible for full development life cycle, including design, coding, testing and deployment

•Developed dynamic ASPX web pages for Application using ASP.NET, C#.NET, XML, XSL/XSLT, HTML, JavaScript

•Used JavaScript to perform validations and catch the events on client's browser

•Involved in the ATRE Migration MySQL to SQL server

•Converted ATRE Java application to .NET

Environment: Java2, J2EE, JSP, Java Beans, Servlets, JavaScript, AJAX, QUARTZ, Struts, Model View Controller (MVC) pattern, XSL, XML, HTML, CSS, EJB, JBOSS, Eclipse, Web service, Wild fly, Cewolf charts, ICE, SHARES, .NET, C#, CVS, JQUERY, Windows Vista, Windows XP, SQL Server 2014



Contact this candidate