Sql Developer Services Specialist

Sumathi Bandari

Software Developer / Full Stack Developer

Email: *******.********@*****.*** / Phone: +1-848-***-**** LinkedIn: https:// www.linkedin.com/in/sumathi-bandari-7982a4a1/ PROFESSIONAL SUMMARY

• 8+ years of experience in the all phases of Software Development Life Cycle (SDLC), including Analysis, Design, Development and Testing of Client-Server and Web-based n-tier Architecture for windows and web applications with exposure to diverse business domains.

• Proficient domains knowledge – Manufacturing Execution System (MES) and Tolling.

• Experience with agile software development methodology and Test-Driven Development including SCRUM.

• Hands on development Experience on UI frameworks such as Angular 4/7/9/11, jQuery, React JS, RxJS, NgRX, Vue.js.

• Excellent design and development experience on Client/Server technologies like Microsoft .NET Framework, Using XML in .NET, C#, Microservices, ASP .NET, Entity Framework, LINQ, ADO. Net, WEB API RESTful service, .Net Core Angular, WPF, MS Project, Microsoft Office System, Word.

• Expert in Angular code optimization, reusability and performance improvement.

• Experience in working with Angular 4/7/9/11, ReactJS, NgRx, Dev Extreme, Kendo UI, Prime NG, Signal- R, JavaScript, jQuery, react-bootstrap components, and AJAX in ASP.NET for asynchronous communication and better user experience.

• Built Confidential tools using Angular, RXJS and NGRX platforms.

• Hands on experience on customization of DevExpress, Chart JS libraries.

• Good Experience in building User Interactive Web pages by using web technologies React/Redux.

• Used Microservices architecture, based services interacting through a combination of REST.

• Extensive experience in creating and consuming RESTful and SOAP Web Services.

• Solid work experience in designing and developing Web API, WCF, and Web Services.

• Experience in developing Dot Net WinForms /Web applications using C#/Asp. Net.

• Exposure to ASP.NET Web Forms, win forms, Web Services, and State Management, caching features, configuring optimizations, and securing the web application.

• Designed and Implemented application using ADO.NET objects like Dataset, Data Table, and Data Adapter for manipulating, retrieving, storing, and displaying data from SQL Server.

• Good experience of database design and development that involves ER Modeling, Relational database schema, Functional dependencies, Normalization of tables, writing queries using SQL, writing Stored Procedures, Functions and Triggers using SQL, Oracle.

• Experience as an Oracle PL/SQL developer in analysis, design and implementation of business applications and worked on oracles supplied packages, Dynamic SQL, Records and tables PL/SQL

• Expertise in Client server application development using Oracle 12C+ /11g/10g/9i and SQL*LOADER.

• Worked on creating database objects like tables, materialized views, procedures and packages using Oracle tools like Toad. PL/SQL Developer and SQL*plus,

• Hands on experience in Amazon EC2 Container services, Docker and Autoscaling.

• Specialization in Unit & System Level Integration & Testing (which includes Software Test Plan (STP) development, review and execution).

• Experience on securing the application with Role Based Access Control (RBAC) system by using UAA and Key clock

• Extensive knowledge on load balancing techniques such as Nginx, Haproxy, Elastic Load Balancer (ELB)

• Experience on working with caching techniques like Radis, Lazy Cache.

• Involved in implementing the circuit breaker patterns in microservices by using Hytrix Library.

• Highly experienced in developing Functional Requirement (FRD) & Technical Design Documents

(TDD/SDD).

• Working knowledge of Windows, Linux, Docker, AWS, Microsoft Azure, and other platforms.

• Knowledge of important web development tools such as Reactide, React Site, Code Sandbox, Storybook and others

• Experience with Application Blocks such as User Interface Application Blocks, Log4Net and Database Application Blocks, Entity frameworks.

• As an onsite representative at client location, successfully proposed, planned and deployed complex project.

• Collaborate with QA team to define test cases, metrics, and resolve questions about test results.

• Releasing build with brief notes about the fixes for every QA trail and stay in touch with quality analyst to get the up-to-date status on bugs, parallelly connecting with them to get more details about the defects to resolve them quickly.

• Analyzed code and utilized debugging tools to troubleshoot issues and implemented new debugging processes to improve efficiency and accuracy.

• Demonstrate the new features developed to the end client and other teams to ensure design and implementation are on the right track and meet the business requirements.

• Performed Unit Testing of the developed component and windows forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved.

• Implemented agile methodology in the associated project.

• Developing and implementing production plans and schedules to meet customer demands and Monitoring production metrics and identifying opportunities for improvement

• Troubleshooting production issues and implementing corrective actions.

• Recommend business process flow improvements and clearly communicate problem/resolution process to project management.

• Possess an in-depth understanding of project life cycle processes and methodologies.

• Makes design recommendations towards the development of new code or reuse of existing code. TECHNICAL SKILLS

Languages : C#, JavaScript, LINQ

UI Frameworks : Angular 4/7/8/9/11/14, Vue.js, ReactJS, Redux, Bootstrap Web Technologies : HTML, JavaScript, AJAX, CSS, Angular Libraries : DevExpress, Prime NG, Kendo UI, RXJS, NGRX

.NET Frameworks : Microsoft .NET Framework 4.6, 4.5, 3.x, .NET Core Authentication Tools : Active directory, Cloud Foundry, UAA, Key Clock, SSO SAML UX Mockup Tools : Zipline, In-Vision, Adobe XD

Database : MySQL, Couch DB, Oracle 12C+ /11g/10g/9i Build & Deployment : TFS builds, GIT, GIT hub Actions, Jenkins, Docker, Kubernetes, AWS EC2, EKS Message Queus : Rabbit MQ, Kafka

IDE : Microsoft Visual Studio, Microsoft Visual Studio Code, Visual Basic, SSMS DevOps : Docker, Kubernetes, Git, Ansible, Maven, Gradle, Jenkins (CICD Pipeline), Portainer Operating systems : Linux, Windows

Agile Tools : JIRA, TFS, Rally, Confluence

EDUCATION

• Bachelor of Technology in Computers Science and Engineering PROFESSIONAL EXPERIENCE

GE Digital, Engineering Manufacturing Services July 2020 to April 2023 Client: Tusaş Engine Industries

Role: Service Engineer

Description:

Tusaş Engine Industries (TEI) is an aerospace engine manufacturer and a global design center dedicated to the production of engines and critical engine parts for commercial and military aircraft. Which uses MES Product tracks and documents the transformation of raw materials to finished goods. It has several manufacturing units which are operated by a variety of modules, since it is a military engine manufacturer, so the software deployed environment is on prem and secured. The core modules are Workbench, Engineering Disposition, Recording sheet, DPRV, CAV, Digital Factory, Nonconformance management and so on. Responsibilities:

• Worked in Requirement Gathering from client and Proof of concepts (POC).

• Involved in creating application architecture documents to provide deliverables in line with architectural requirements.

• Involved in application design (low level design and high-level design artifacts) and responsible for planning, estimating, requirements gathering, design and development of web applications and enhancements to existing applications using Angular.

• Collaborate with Project Managers, Application Developers, QA Analysts, and Business Users in the development of web applications as needed for the business process.

• Involved in User Interface development and defect fixes using Angular, Typescript, HTML, XML, JSON, CSS and Bootstrap.

• Implemented NGRX store to maintain the state of single page applications. NGRX was utilized to store the results after angular injector observable retrieved data from back end.

• Actively participate in building and creating docker images for respective applications and services.

• Create new configurations for every scratch application and bind them with existing applications.

• Deploying the solution by connecting to the Linux environment and checking the space before deploying the solution.

• Maintaining the logs status and tracking the applications up to date.

• Deploy the QA verified solution in customer environment and maintaining on daily basis.

• Worked on Integrating the Users from Active Directory (AD), SSO, and Key clock to Cloud Foundry UAA .

• Extensively worked on advanced concepts of NET Core, .NET Framework such as Filters, Models, etc.

• Create the user scopes and assign them to groups based on their roles.

• Get the client’s API’s and integrate them with the developed API’s.

• Use of UX design systems like Adobe and Zipline to develop pixel perfect UI screens.

• Active use of swagger documentation and share it to the customer IT team for their reference.

• Worked on optimizing backend SQL performance issues and server-side issues.

• Worked on Oracle supplied packages such as DBMS_SQL/JOB and UTL_FILE.

• Extensively used key Oracle performance related features such as Query optimizer, Execution plans and Indexes.

• Perform code-reviews and deployments artifacts to make sure the best practices are implemented.

• Attend meetings with clients to understand and convert the business requirements to the technical capabilities.

• Participate in Daily Stand-Up meeting to report daily status and to know about potential challenges as well as to coordinate efforts to resolve difficult and/or time-consuming issues.

• Interacting with all teammates to provide help for their development and staying aligned with the progress going on the project.

• Release a build with brief notes about the fixes for every QA trail and stay in touch with quality analyst to get the up-to-date status on bugs, parallelly connecting with them to get more details about the defects to resolve them quickly.

• Demonstrate the new features developed to the client and other teams to ensure design and implementation are on the right track and meet the business requirements.

• Monitoring the Applications with PORTAINER, Monitoring system, with these we will get production down alerts through emails.

• Communicated effectively with team members to provide updates on debugging progress.

• Overseeing the manufacturing process and ensuring that products are produced efficiently and to high standards.

• User Kubernetes to orchestrate the deployment, Scaling and Management of docker Container.

• Capturing the Events modified using RabbitMQ, Kafka, Signal R and syncing the data in the newer system. Environment: Angular 11/14, Type Script, HTML, JSON, CSS, DevExtreme, RXJS, NGRX, Microsoft Logging, Signal R, ASP.NET, .NET Core, Microservices, Docker, Kubernetes, IIS, Restful Web Services, Jenkins, RabbitMQ, Kafka, MySQL, Couch DB, Oracle 12c+/10g/11g, Swagger, Postman, ADOBE XD, Zipline, JavaScript, UAA, AD, Key clock, Git, RedHat, Ubuntu 18.04 Visual Studio Code, Visual Studio, Forti Client, JEERA, HaProxy. Client: Kellogg’s March 2020 – July 2020

Role: Services specialist -1

Description:

Kellogg's is an American multinational food manufacturing company which produces cereal and convenience foods. GE Owned MES Product that tracks and documents the transformation of raw materials to finished goods. The product operates across multiple function areas, for example: management of product definitions across the product life cycle, resource scheduling, order execution and dispatch, production analysis and downtime management for overall equipment effectiveness (OEE), product quality, or materials track and trace. Responsibilities:

• Understanding the business requirements of the Client with Proof of Concepts (POC).

• Enveloped requirements come from the customer, analyzing the complexity and time with the teammates for the estimates.

• Implemented the freeze requirements from scratch using Angular as the Key UI framework also NodeJS as a server-side REST API.

• Performed customizations on Open-Source UI library (Dev Extreme), based on inputs from the UI mockup screens.

• Implemented and Secured API end points with O auth authentication.

• Hands on Experience in using angular components, forms events and creating interactive using two-way data flow, virtual DOM.

• Implemented standard code structure for code reusability and ease understanding.

• Analyzed, the Implementation of services with 3-tier architecture, for scalable and maintainable solution.

• Implemented messaging listeners on active MQ, routing functionalities and invoking corresponding REST services using NodeJS.

• Implemented logging for Angular application using NGX-LOGGER open-source library.

• Created routes and topics in different modules for proper message transmissions.

• Tested the REST end points by using POSTMAN and Dapper Dox to validate the API response.

• Perform code-reviews and deployments artifacts to make sure the best practices are implemented.

• Maintaining the code version control using GIT.

• Participate in Daily Stand-Up meeting to report daily status and to know about potential challenges as well as to coordinate efforts to resolve difficult and/or time-consuming issues.

• Interacting with all teammates to provide help for their development and staying aligned with the progress going on the project.

• Research for Open-source libraries for the development and helping the teammates for their logic implementation

• Code and Deploy Node JS applications on-prime.

• Extensive use of UX design tools like ADOBE, IN-VISION to develop pixel perfect UI screens.

• Commanded on various IDE/tool like Visual Studio Code, Visual Studio, POSTMAN.

• Extensively worked with performance tuning for Oracle RDBMS using Explain Plan and Hints. Worked with Query Optimizer, Dynamic SQL, Collections and Exception handling

• Connect with Manager and TL to explain the development progress and roadblocks as immediately when struck with dependencies

• Provide Documentation and structure about the developed solution.

• Training the Intern developers to understand the domain and new features. Environment: Node JS, Angular, Dev Express, In-vision, Adobe, Kendo UI, JEERA, Rally, Cloud Foundry, Visual studio code, HTML5, CSS3, JavaScript, Type Script, Angular 10/9, RXJS, NGRX, Karma, Jasmine, Oracle 10g/11g. Toll plus India PVT LTD November 2019 – March 2020 Project: M50

Role: Software Engineer

Description:

M50 motorway is a C-shaped orbital motorway in Dublin and the busiest motorway which is developed to meet the tolling need in Ireland. It is the most famous, hated, used, congested, upgraded and most essential road in Ireland. With 8 lanes for much of its length, it's by far the biggest road. Which has the advanced tooling system with various core modules like Account management, zip cash account, customer services, External web, Audit and System Administration.

Responsibilities:

• Involved in the complete Software Development Life Cycle including Requirement Analysis, Design, Implementation, Testing and Production Support. Used Agile approaches, Including Business-Driven Development (BDD).

• Worked Extensively with Angular CLI for creating components, Services, pipes, Directives.

• Utilize Jasmine, Karma, Gulp, Grunt and NPM to build and test applications.

• Developed .NET applications using MVC, MVVM patterns for writing reusable User Interface UI and encapsulating the functionalities.

• Designed and developed major module of UI using latest Angular Framework and took ownership for the functional features of the same.

• Involving in handling ASP.NET client-side state management (view state, cookies and query strings) and server-side state management (application state, session state and profile properties).

• Designing Crystal reports and integrating them with the application.

• Developed XML Web Services and WCF services common for various applications using.

• NET Framework and Hosting the WCF based service on IIS

• Developed N-tier distributed .NET applications using SOAP based Web services.

• Used LINQ to Entities to do CRUD operations and made use of Lambda Expressions for retrieving data proficiently.

• Utilize Jasmine, Karma, Gulp, Grunt and NPM to build and test applications.

• Designing the complex modules of the application using software design paradigms and software development principles SOLID UML Class and Sequence diagrams

• Implemented client-side validations using JavaScript and jQuery for AJAX Implementation and validations.

• Designed different components using C with extensive use of Object-Oriented Programming Techniques OOPS like interfaces, polymorphism, abstract classes etc.

• Performed Unit Testing of the developed component and windows forms and worked closely with manual testers and automation testers, User Acceptance testers for ensuring the desired functionality is achieved.

• Provided hands-on technical governance on all aspects of production support

• Responded to service tickets and service requests within established time-based requirements.

• Coordinated with internal and external Client resources to isolate and troubleshoot issues resulting with service disruption and outage.

• Used Microsoft Team Foundation Server TFS as Agile tool.

• Used GIT for version controlling.

• Communicated effectively and timely with peers and management. Environment: Angular 8, HTML5, CSS3, JavaScript, Type Script, Angular 10, Karma, Jasmine. C#, .NET framework, Rabbit MQ, Kafka, .NET Core, VB.NET, SQL Server, NoSQL Server, Visual Studio Code, Visual Studio 2012, GIT, SVN, Team Foundation Server (TFS).

Project: NTTA January 2019 – November 2019

Role: Software Engineer

Description:

The North Texas Tollway Authority (NTTA) is an organization that maintains and operates toll roads, bridges, and tunnels in the North Texas area. The North Texas Tollway Authority has been connecting North Texans for 25 years, serving one of the fastest growing metro areas in the US. NTTA serves more than 14 million drivers through safe, well-maintained roads, which has brought significant and continued economic growth and development. NTTA were the first tolling agency in the US to use electronic tolling technology with the Toll Tag. This Product has been specifically developed to meet the tolling need the services including TBOS, Account management, Zip Cash Account Management, Inventory Management collections, and customer services, External web, Audit, System Administration.

Responsibilities:

• Analyze user needs and software requirements to determine feasibility of design within time and cost constraints. Consult with customers or other departments on project status, proposals, or technical issues, such as software system design or maintenance.

• Design, develop and modify software systems, using scientific analysis and mathematical models to predict and measure outcomes and consequences of design.

• Interacting with business system analysts to understand the requirements to ensure that the right set of UI modules has been built by the acceptance criteria.

• Developed single page application using Angular 6/7, Typescript, HTML5, CSS3, and Bootstrap.

• Built the Responsive Web pages using Bootstrap and Media queries. That could serve different kinds of devices like mobile, tablets and desktops etc.

• Transformed the response using Angular 6/7 observables. Used CSS3, Bootstrap, to make the application responsive and Rich.

• Used ADO.NET for retrieving, querying, storage, and data manipulation to perform the CRUD (Create, Retrieve, Update, and Delete) operations on the database.

• Worked on database and .NET application performance tuning to reduce the request processing load on server and having excellent .NET application and database debugging

• skills on SCALE UP and SCALE OUT applications.

• Developed database objects such as tables, views, stored procedures, triggers and user defined functions for database operations in SQL Server.

• Develop or direct software system testing or validation procedures, programming, or documentation.

• Analyze project data to determine specifications or requirements and development in a test-driven environment with hands on experience in implementing well designed, formatted, readable and testable code.

• Collaborate with others to resolve information technology constraints by integrating, interpreted details specific to a module or sub-block of code from a variety of sources to troubleshoot issues and find solutions.

• Design software applications and have a deep understanding of programming languages and the software development life- cycle, as well as excellent analytical abilities and problem-solving skills. Environment: Angular 4/7, HTML5, CSS3, JavaScript, Type Script, Karma, Jasmine. C#, .NET framework, .NET Core

,Rabbit MQ, SQL Server, NoSQL Server, Visual Studio Code, Visual Studio 2012, GIT, SVN, Team Foundation Server

(TFS).

Project: RCTC August 2018– Dec 2018

Role: Software Trainee

Description:

RCTC Product has been specifically developed to meet the tolling needs. The core modules of RCTC are as follows: External web, Customer Service, Toll/Traffic Violation Center, Plaza Operation, Video Tolling, Accounting and Finance, Audit, System Administration, Transaction and Payment Processing. Responsibilities:

• Designed and Developed User Interface web forms (dynamic & static pages) using ASP.NET, HTML, JavaScript, CSS, XML, and custom web controls and user controls.

• Deep understanding of JavaScript and jQuery.

• Developed Web Application to replace the existing and legacy Website using Angular Framework.

• Implemented Model View Controller (MVC) Design Pattern using Angular.

• Used Node.js as the package manager for development workflow dependent plugins.

• Used Angular controllers to update entity models and Tasks database

• Created reports to create, deploy, and manage reports using TFS Report.

• Debug the application using Firebug to traverse the documents and manipulated the Nodes using DOM and DOM Functions using Firefox and IE Developer Tool bar for IE.

• Building Sitecore components that involve working with .NET platform with C# as the programming language.

• Implemented the online application by using Web Services, RESTful, Servlets, ASP.NET.

• Debugged and modified software components by analyzing the customer functional requirements.

• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

• JavaScript is used for data validations.

• Implemented GUI pages by using Angular, JavaScript, HTML, CSS, and AJAX.

• Collaborate with others to resolve information technology constraints by integrating, interpreted details specific to a module or sub-block of code from a variety of sources to troubleshoot issues and find solutions.

• Design software applications and have a deep understanding of programming languages and the software development life- cycle, as well as excellent analytical abilities and problem-solving skills.

• Involved in daily SCRUM meetings to keep track of the project status.

• Used GIT version control for the Development.

Environment: ASP.NET (Web Forms), C#, N UNIT, WCF, HTML, JavaScript, SQL Server 2008, Visual Studio 2012, Visual Studio Code, GIT.

Project: CTRMA March 2015 – August 2018

Role: Software Trainee

Description:

The CTRMA implemented express toll lanes along a stretch of MoPac (Loop 1) in Austin. These managed lanes offer a reliable travel option for commuters and utilize dynamic pricing to maintain optimal traffic flow. The primary goal of the CTRMA is to improve mobility and reduce congestion in Central Texas through the construction and operation of toll roads, managed lanes, and other transportation infrastructure projects CTRMA Product has been specifically developed to meet the Pay By-Mail services including invoicing and processing (video billing), violations processing, collections, and customer services, External web, Transaction and Payment Processing, Finance.

Responsibilities:

• Developed Single Page Application using Angular and C# as a back-end service with cutting edge HTML5 and CS3 techniques.

• Ensure that the industry standards and coding practices are developed and thoroughly enforced.

• Involved in code reviews and pair programming.

• Designed different components using C with extensive use of Object Oriented

• Programming Techniques OOPS like interfaces, polymorphism, abstract classes etc.

• Collaborate with Product Owners, Business Analysts and US counterparts to identify, gather and refine requirements

• Designed and developed applications in cross browser platform to ensure browser compatibility.

• Ensure that the industry standards and coding practices are developed and thoroughly enforced.

• Involved in code reviews and pair programming.

• Designed different components using C with extensive use of Object-Oriented Programming Techniques OOPS like interfaces, polymorphism, abstract classes etc.

• Collaborate with Product Owners, Business Analysts and US counterparts to identify, gather and refine requirements

• Designed Templates, based on requirements using JavaScript and CSS.

• Created custom directories for data manipulation and two-way data binding by following standard formats.

• Integrated with backend code for high interactive AJAX based application.

• Worked through cross browser compatibility issues with layout and styles for all new CSS that was Implemented.

Environment: Angular 4, HTML5, CSS3, JavaScript, Type Script, Karma, Jasmine. C#, .NET framework, Rabbit MQ, SQL Server, Visual Studio Code, Visual Studio 2012, GIT, SVN, Team Foundation Server (TFS) ASP.NET (Web Forms), C#, N UNIT, WCF, SQL Server 2008.

Contact this candidate