We provide IT Staff Augmentation Services!

Pl/sql, Database Developer Resume

0/5 (Submit Your Rating)

Tampa, FL

SUMMARY

  • Having 7 years of experience in Information Technology with Java/Spring MVC, Spring BOOT and SQL/PLSQL development.
  • Experience in planning and executing all phases of Software Development Life Cycle starting from Requirements gathering to Production Support and Maintenance.
  • Experience in designing developing and deploying n - tier web applications and client/server applications using JAVA, J2EE technologies and Web Technologies for enterprise applications.
  • Hands-on experience in PL/SQL, Database Jobs
  • Experienced in Micro services using Spring BOOT
  • Deploying micro services in cloud foundry and AWS environment
  • Developed process flows using Bonita(BPM process management)
  • Experienced in Jenkins, SONARQUBE and cloud foundry.
  • Used the scale up concept in cloud foundry to increase the number of instance in Cloud foundry
  • Porting the logs of cloud foundry into Logstash and ELK
  • Code coverage using JACACO
  • Experience in writing Hibernate jobs and writing HQL(Hibernate Query Language)
  • Expertise in Creating web pages using HTML,CSS and JavaScript, Jquery, Ajax and Angular JS2
  • Worked on logging mechanism like SPLUNK and Elastic Search Logstash Kibana(ELK)
  • Worked on CI/CD model using Jenkins and Ansible to deployment in cloud foundry after code checkin in Stash
  • Developed micro services in Node js, groovy and spring boot
  • Done a POC in RESTLET, developed a sample POC
  • Worked on Scraping mainframe screens using Jagacy3270 Api
  • Experience writing Web Services (REST, SOAP)
  • Able to create webpages using JSF and JSP and used for reports generations
  • Profound experience in web based application development using Java Beans, JNDI, Servlets, JSP, XML, Web Services, and JDBC.
  • Extensive experience in MVC Framework based web applications like struts, springs.
  • High-level Expertise in Object Oriented Design, Analysis, and Modeling based on Unified modeling language. (UML)
  • Experience in working with waterfall and Agile software development methodologies.
  • Proficiency with web servers/servlet containers and application servers like Apache Tomcat, IBM Web Sphere, Web Logic.
  • Working knowledge in using XML Parsing (SAX, DOM, JAXB, and STAX), XSL, XSLT, SOAP, HTML, DHTML, and JavaScript, JUnit, and Web services.
  • Good exposure on RDBMS concepts and proficiency in using relational databases such as Oracle 11g and Data base jobs in SQL/PLSQL.
  • Experience in using different modules of the spring framework like Inversion of Control, Data Access, and Transaction Management, Model-View-Controller modules.
  • Good exposure on version controlling tools like GIT and Subversion (SVN).
  • PoC Experience with Mongo DB with Java

TECHNICAL SKILLS

RDBMS: Oracle 11g

Languages: JAVA, XML, HTML, SQL/PLSQL, UML

Enterprise Tech: J2EE, JMS, JDBC, Servlets, JSP, XSLT, DTD, Schemas and Design Patterns, Spring Core,Spring MVC, Spring Boot, Micro Services

Web Technologies: JSP, J2EE, Struts, and Hibernate, Web services (WSDL, REST and SOAP)

Web/App Servers: JBOSS, Tomcat, Apache, WEBLOGIC

IDE: SQL Developer, spring tool suite.

OS: Windows XP / NT / 9, UNIX

Special Software: JUNIT, LOG4J, ONESTASH, ONEJIRA

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Responsibilities:

  • Access Provisioning Controller (APC) system is a centralized regional (access) workflow manager which monitors the provisioning activities/tasks and tracks the major milestones by interacting with various systems, each aimed to carry out specific tasks Extract Module responsible for generating user requested reports and extract reports.
  • This system acts as a central controller for all the provisioning systems from order receipt to signaling the billing system to charge for the service once after service is provisioned.
  • This system tracks pre-build, pre-provisioning to Test and Turn-up critical milestones and address the fallouts from each critical milestone.
  • Developed micro service to scrape main frame screen, providing it as an interface for other systems to interact with main frame using jagacy.
  • Deployed the micro service in the Cloud foundry
  • Developed an automated the Jenkins job which will be deployed in development environment and will be in the UAT environment using CI/CD (Continuous integration and continuous deployment)
  • Integrated micro service with Sonar qube
  • Developed custom actuators to stop the restart the micro service
  • Used active spring profiling to deploy the same micro service in different environments eg: DEV, UAT,PROD
  • Client Side Load Balancing with Ribbon and Spring Cloud
  • Performingbug fixesand coordinating with the testing team for all the updates and changes.
  • Written a micro service using RESTLET

Environment: Linux, Java, HTML, Spring Boot, Micro service, Hibernate, Ajax, JQuery, Junit, Shell Scripting, Maven, REST/SOAP WebServices.

Confidential, Webster, NY

Responsibilities:

  • As part of Tata consulting practice, implemented Architecture and detailed Design of CTC Pahse3 Wave1&2 changes into EIPP.
  • Produced the High-Level design document with Use Cases, Component diagrams and sequence diagrams.
  • Discussions with business on multiple iterations created the system test strategy and test plan and produced the prototype with the technical design.
  • Architecture and detailed Design of CTC Pahse3 Wave1&2 changes into EIPP.
  • Produced the High-Level design document with Use Cases, Component diagrams and sequence diagrams.
  • Designed and developed end-to-end Wave1&2 phase changes.
  • Discussions with business on multiple iterations created the system test strategy and test plan and produced the prototype with the technical design.
  • Designing the application and writing the technical design document and the application flow.
  • Mentoring the technical team, work allocation and code review
  • Coordinated activities between onsite and offshore
  • Extensively involved in writing Oracle Stored Procedures and Database Views as part of a package on Oracle using SQL Developer.
  • Performance analysis and tuning the application services.
  • Weekly status meetings with the customers
  • Batch Server Services framework designed using Spring Batch frame work. This module contains Data Loader, Batch Processing, Extract sub modules.
  • Data Loader is responsible for loading Invoices, User Data.
  • Batch Processing is responsible for processing of business logic such as notifications, payment processing.
  • Extract Module responsible for generating user requested reports and extract reports.
  • As part of CTC Phase3 Wave2 implementation, Implementing Data loader to process invoice feed files and user data.

Environment: Windows 7,Linux, Java, J2EE, Spring, Ajax, JSON, JQuery, XML, XSL, REST Web services, Junit, Shell Scripting, Maven, Ant.

Confidential

Responsibilities:

  • Involved in requirements gathering
  • Managed Project deliverables assigned to me within time limits without compromise on the quality
  • Worked as core java and Hibernate developer in the project
  • Involved in the billing functionality as it is a Utility Project
  • Experienced in scheduling Batch Job Streams. Configured Job Streams as per the Account's Business process.
  • Handled all the possible failures that can stall Job Streams
  • (Error Handling, Stuck Handling, Thread Pool Shutdown/Restart).
  • Made use of most of the components provided by Framework.
  • Provided support to the application and resolved tickets raised by the Client
  • Involved in writing SQL and PLSQL scripts which are used in JDBC
  • Involved in writing Algorithms, Batch Jobs and JBS in OUAF for Oracle CC&B
  • Well experienced with UI maps, Service Scripts, Business Services, Query Zones, portals, BPA Scripts, Plug in Scripts, Case types, To do’s.
  • Configured Database Jobs which executes Stored Procedures which in turn triggers CCB Job Streams from Database.

Environment: Linux, Java, J2EE, Oracle CC&B,Hibernate, OUAF (Oracle Utilities Application framework), SQL/PLSQL, Junit, Weblogic Server.

We'd love your feedback!