Pl/sql, Database Developer Resume
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.
