Pl Sql Java Developer

Shyamala Janani Devi Sarvodhaya Dhayanithi

Backend Java Developer

Email: **********@*****.***

PhoneNo: +1-973-***-****

PROFESSIONAL SUMMARY:

● 8+yrs of developmental and production support experience in Java technologies

● Microsoft certified in Azure Fundamentals(AZ-900)

● Strong knowledge in retail, financial and health care services domain

● Provided production support for mission critical java applications, ensuring high system availability and performance.

● Investigated and resolved complex technical issues by analyzing system logs, performing root cause analysis, and implementing appropriate solutions

● Experience in all phases of SDLC including analysis, design, coding and testing, expertise in integration using Java and J2EE architecture

● Responsible for designing, implementing, and maintaining complex software systems with stringent up-time requirements

● Experience in communicating with different stakeholders including product owners, external vendors, end users on ticket status and resolution timelines

● Experience in implementing SCRUM and KANBAN agile methodology

● Experience in issue triaging including scenario replication, log and code analysis

● Expertise in requirements and systems analysis through deployment using SDLC and agile methodologies

● Expertise in J2EE Technologies, which are JSP, Servlets, JDBC, Java Script, Spring MVC, Hibernate, spring boot, spring batch

● Expertise in Eclipse, IntelliJ, STS IDEs

● Experienced with J2EE standard compatible Application Servers including JBoss, Apache Tomcat Deployment process and Integration

● Worked extensively in J2EE JSP, Servlets, JDBC, spring MVC, Hibernate and XML and well versed with Oracle database, OS Concepts

● Experienced in design and development of MongoDB database schema from scratch

● Experience using Spring Framework modules like Spring Core container for Dependency Injection, Application context, and Spring ORM

● Excellent handle in Hibernate O/R mapping tool

● Experience in SOAP and Jersey implemented RESTful web services

● Good knowledge and experience in search engines like Apache SOLR and Google Search Appliance(GSA)

● Experience in developing test cases and test plans besides involving in Unit testing, Integration testing and User Acceptance Testing extensively

● Knowledge in building java application using tools like ANT, Maven

● Efficient team member with excellent work/time management skills, excellent communication and interpersonal skills

TECHNICAL SKILLS:

Languages: Java 1.8, J2EE

J2EE Technologies: Spring (IOC, Batch, AOP, Security, MVC, Spring Boot), Hibernate, REST, SOAP, Servlets, JSP, JDBC, groovy, Junit.

Application/Web server: Apache Tomcat, JBoss.

Database: Oracle9i/10g, MySQL, SQL Server, MS Access, Mongo IDE: Eclipse, IntelliJ, Net Beans, Spring Tool Suite Tools: CSS, Jira, Jenkins, PostMan, Bugzilla, SQL Developer, GitHub, Toad, confluence, Swagger

Web Technologies: XML, CSS, JSP, HTML, JavaScript, HQL, SQL, REST, HTTP, SOAP, WSDL.

PROFESSIONAL EXPERIENCE:

Cygnus Professionals Jun 2022 - Present

Java Technical Support Engineer Location: USA

Project: Supporting a suite of clinical and pharmacy applications – TLC(The Little Clinic)

● Supporting application users in understanding the configuration and functionality of the application as and when they raise an incident

● Coordinate activities and resources between onshore and offshore teams to ensure seamless project execution and delivery.

● Facilitate effective communication and collaboration by serving as the primary point of contact for onshore and offshore team members

● Following Kanban methodology

● Support and monitor applications during scheduled maintenance window for DB/ Windows/ Network level activities

● Issue triaging including scenario replication, log and code analysis

● End-To-End issue triaging and analysis (where upstream applications exist)

● Engage DBA, Network, Windows Engineering teams on bridge call as needed to resolve issues

● Communication with different stakeholders including product owners, external vendors, end users on ticket status and resolution timelines

● Monitor alerts (Dynatrace/ Azure/ Kibana log alerts)

● Monitor scheduled batch jobs using SSMS and ADF pipelines in Azure portal

● Worked with cross-functional teams to identify and address system vulnerabilities, applying security patches and updates as required

● Documented support processes, troubleshooting steps and resolutions for future reference and knowledge sharing

● Participated in on-call rotations to provide 24/7 support, ensuring prompt incident response and resolution.

Environment: Java 1.8, Spring Boot, Restful web service, Pl/SQL, Perl Script, IntelliJ, SSMS, Postman, GitHub, JIRA, Dynatrace, Kibana echo logging, Azure Logging, ServiceNow, Infra VCore

Infosys Dec 2021 – Present

Backend Java Developer Location: USA

Project: Working for a banking application – Ca$H(Clearing and Settlement Hub) which creates settlement entries and actual money movement between general ledger accounts for the real time payment and does the hard posting on customer accounts.

● Configured java 8 objects with backend database tables using ORM mapping in hibernate end to end application on spring boot framework (REST API application/Spring Data JPA using CRUD repository

● Extensively followed SCRUM methodology

● Accessed third parties using REST principles

● Worked on Spring Batch to generate report for the production support team to check the health of the application and database post deployment

● During development life cycle took advantage of JIRA for task and bug tracking purposes

● Used Junit for unit testing the business logic code in java

● Worked with Oracle for executing queries and stored procedures for testing data persistence. Assisted in production support.

Environment: Java 1.8, Kafka, Drool Rule Engine, Junit, JavaScript, Pl/SQL, Spring Boot, Hibernate, Spring Batch, IntelliJ, SQL developer, Postman, Bitbucket, Restful webservice, JSON, JIRA, Maven, SOAPUI, WinSCP, putty, Splunk, Swagger ANZ Bank, Capgemini Dec 2014 – May 2016

Backend Java Developer Location: NZ & India

Project: This project is mainly for providing business services to manage credit sale related functions across channels. Credit card would be offered through holistic credit decision(HCD) after interacting with various third parties in validating applicant’s identity.

● Work to produce SOAP web services (WSDL, XML, XSD, JAXB) using Apache CXF in Service Oriented Architecture (SOA). Also worked in consuming the SOAP web services

● Develop application on spring 3.x framework by utilizing its features like Spring Dependency injection, Spring Beans, Spring JDBC, Spring Web flow using Spring MVC

● Accessed third parties using REST principles

● During development life cycle took advantage of JIRA for task and bug tracking purposes

● Used Junit for unit testing the business logic code in java

● Used groovy fixtures to unit test the soap webservices across third parties

● Use Eclipse to view and modify spring configuration XML files, Java source and test classes, global JavaScript, CSS and XSLT files using JAVA

● Designing and building RESTful, JSON, and XML services platforms to integrate partners for payment, fraud risk, and payout, enabling rapid expansion to countries by normalizing regional payments and dynamically optimizing routing

● Develop the application using Spring framework. The views are programmed using JSP pages with the spring tag library, Entity and Java classes and web implementation controllers are Spring

● Use common Unix/Linux commands to verify log files in the Apache Tomcat Servers

● Benefited during debugging and troubleshooting from the use of tools such as WinSCP to retrieve and view logs, Beyond Compare.

● Use Jenkins Continuous Integration for automatic builds and Automated Release Management (ARM) jobs to push code into QA

● During development life cycle took advantage of Jira for task and bug tracking purposes

● Use SVN as source control tool and RMI tool for the connection

● Use Oracle database and worked on creating tables using SQL queries

● Implement Java Persistence API through Hibernate Environment: Java 1.7, JSP, Junit, XML, XSD, XSLT, JDBC, SQL, HQL, Pl/SQL Spring MVC, Hibernate 3.0, Eclipse, Oracle Toad, SOAP-UI, SVN, Restful webservice, JSON, JIRA, Maven, SOAPUI 4.5.1.

Standard Chartered Bank, Capgemini Jan 2014– Dec 2014 Senior Developer/Production Support specialist Location: India Project: This project is mainly for identifying and risk rating the customers dynamically based on the transactions behavior, nature of business and income of the customers. DETICA is the KYC tool used.

● Developing, testing and providing internal documentation of complex software solutions in Backend environment

● Worked in the Scope’s KYC tool DETICA, on Dynamic Risk Review(DRR) module

● Proactively monitoring the operations of the production system and helping in resolving any live problems

● Developed shell scripts for batch job and reconciliation scripts

● Debugged and fine-tuned stored procedures and database queries to enhance system performance using SQL and PL/SQL

● Managed open tickets and resolution times to ticket SLA’s using BMC Remedy tool

● Review the production support issues assigned, do due diligence troubleshooting, root-cause analysis, and provide resolution in a timely manner

● Utilized unix commands and shell scripting for administration, maintenance and troubleshooting

● Manage the incident process to ensure issues are recorded, tracked, resolved and follow ups are done in a timely manner

● Take ownership of issue reported by the customer and ensure that it is resolved quickly effectively or escalated to the next level with relevant data as in a timely manner

● Set the right expectations with the customer and keep communication flowing at appropriate intervals.

Environment: Unix, Pl/SQL, SQL query, Putty, Toad, BMC Remedy AIMIA, Infosys Jul 2013 – Jan 2014

Java/J2EE Developer Location: India

Project: AIMIA is a global leader in Loyalty Management. This project is for customizing the AIMIA product to the different RETAIL clients who have signed up for AIMIA. This allows the users to redeem their credit points during checkout and use it as a payment method for completing their order.

● Involved in complete development of Agile Development Methodology/SCRUM and tested the application in each iteration

● Developed web Application Using Core Java, spring, Hibernate

● Developed the application using Servlets and JSP for the presentation layer

● Created and consumed WSDL for soap based web services

● Used RESTful web services to expose certain functionalities of the application

● Used jersey implementation for restful web services

● Created hibernate-config.xml and configured the hibernate2.0 for the application

● Configured hibernate with spring

● Used Spring Dependency Injection feature for Bean wiring

● Used spring integration with hibernate

● Created Object-Relational mapping using Hibernate3.0

● Used Hibernate Query Language HQL to query the database for complex data

● Used JavaScript for the client side validations

● Implemented spring transaction management for some database transactions

● Used log4j to capture the log that includes runtime exceptions and debug

● Used agile software development methodology on spring framework

● Used Singleton Pattern in manager objects to maintain only one object of them in memory

● Used log4j for writing into Application and Error logs

● Involve in DAO Data Access Objects to retrieve data from database

● Architectural, technical and functional understanding of the interfacing modules. Involved in different activities like design, deployment, unit testing and test case creation. Build and release co-ordination for different modules.

● Defect fixing of the errors caught in the development, unit testing and QA phase

● Used Eclipse3.0 as IDE and SVN as version control system.

● Used Sonar quality tool and did bug fixes

● Worked on Mongo no sql db

Environment: Java, J2EE, JDBC, JSP, Servlets, Spring3.0, Hibernate3.0, UNIX, putty6.0, Apache Tomcat, oracle11g, Eclipse, VPN client, Maven, Subversion, WINSCP, Restful Web service, MongoDB

Carphone warehouse - IMACS, Infosys Nov 2012 – June 2013

Senior Software Developer Location: UK and India

Project: Carphone Warehouse provides insurance for the handsets bought in the store or via online

● Worked on Query optimization, functions, stored procedures and other database objects

● Preparing builds, deploy and Co-ordinate with the release management team to ensure that the proper process is followed during the release

● Interacting with clients for gathering business requirements

● Interacting with the clients for the new enhancements to be done

● Providing End-to-End support for the testing activities during System Testing, UAT Environment: Oracle, Toad, Pl/SQL

Carphone warehouse – ecommerce website, Infosys Jan 2011 – Oct 2012 Backend Java Developer Location: UK and India

Project: Carphone Warehouse is the largest retailer of mobile phones in UK. This project is for revamping of the Carphone Warehouse site in look and feel. Implementation of better search and load mechanism for loading the products in the site.

● Accessed SOLR Db using RESTful webservices

● Analyze the data stored in Oracle 10g database via Oracle SQL Developer and retrieved the desired data in the code through Hibernate persistence layer via HQL and PL/SQL

● Used Solr no SQL dB that contains critical data for the website that are loaded using batch process

● During development life cycle took advantage of JIRA for task and bug tracking purposes

● Used Junit for unit testing the business logic code in java

● Use Eclipse to view and modify spring configuration XML files, Java source and test classes, global JavaScript, CSS and XSLT files using JAVA

● Use common Unix command to verify log files in the Apache Tomcat Servers using putty

● Benefited during debugging and troubleshooting from the use of tools such as WinSCP to retrieve and view logs, Beyond Compare.

● During development life cycle took advantage of Jira for task and bug tracking purposes.

● Use SVN version control tool.

● Use Oracle database and worked on creating staging table and plsql program to create batch job procedure to load SOLR DB.

● Involved in writing the database integration code using Hibernate Leveraging the AOP features of spring framework to handle exceptions.

● Implement Java Persistence API through Hibernate.

● Used Postman client for testing Restful web services Environment: Java 1.6, JSP, CSS, JavaScript Junit, XML, JDBC, SQL, HQL, Spring MVC, Hibernate 3.0, Oracle Toad, SOAP-UI, SVN, Eclipse, JIRA, Maven, Solr, GSA, JSON, Restful webservice, Postman, putty, WinSCP

Morrisons, Infosys May 2010 – Dec 2010

Software Developer Location: India

Project: Morrisons is one of the largest chains of supermarket in UK. This project is for ATG-PIM integration. PIM is the product master and we handled the movement of products from PIM to ATG and loading the same in ATG and deploying it.

● Worked on ATG e-commerce framework

● Integrated ATG DB with Morrisons legacy database PIM

● PIM is the product master and we handled the movement of products from PIM to ATG and loading the same in ATG and deploying it.

● Created staging tables for importing data from PIM

● Involved in end to end testing of the application

● Provided support for the QA team

Environment: ATG 10.0, Java 1.6, Oracle Toad, ATG Commerce module Infosys Training and Internal Projects Jun 2009 – Apr 2010 Software Developer Location: India

Project: Commerce Reference Store is the internal project application developed for client Demo’s in Infosys. Worked in internationalization and profile sections. Created solution accelerators such as OpenId Integration using third party system known as Janrain.

● Worked on ATG e-commerce framework – Commerce Reference Store Module

● Worked on Internationalization and profile sections of the CRS module

● Created solution accelerators such as OpenId integration using third party system known as Janrain

● Involved in unit testing of the application

● Involved in the migration of code from ATG 9.0 to 10.0 Environment: ATG 10.0, Java 1.6, Oracle Toad, ATG Commerce module Education:

Bachelor of Technology - Information Technology, India Jun 2005 - May2009 Certification:

Microsoft Azure Fundamentals (AZ-900) Mar 2023

Contact this candidate