Sql Developer Resume
Okemos, MI
PROFESSIONAL SUMMARY:
- Over 12+ years of IT experience in Analysis, Design, Development and Deployment, Re - Engineering, Coding and testing in n-tier system.
- Worked with industry leaders - Credit-Suisse, Confidential, Confidential, North Western Mutual, Confidential, Michigan & Connecticut State Gov., Confidential, Confidential . Veteran’s Administration (VA) and Confidential .
- Solid experience in implementing applications for global operations in diverse industries using Design Patterns e.g. MVC, Factory, Session Facade, Observer, and DAO.
- Diverse experience utilizing Java tools in N-tier architecture applications including J2EE, EJB 2.0, JDBC 2.0, JSP 2.0, Servlets 2.3, Java 1.8, Spring 4.3.2, Hibernate, SOAP 1.2, JAC-RS 2.0 and Structs2 technologies.
- Experienced with Application servers and web servers like Web logic Application Server (9.2.2, 10.3.5, 12c), Apache Tomcat 2.8.2 and Java Web Server.
- Heavy experience of designing and developing applications using J2EE Specifications.
- Proficiency in design and implementation of Object Oriented concepts and J2EE design patterns.
- Excellent problem solving skills to rapidly troubleshooting/diagnose and resolve complex technical issues.
- Extensive use of SQL, PL/SQL, procedures, functions, triggers and Oracle 11g.
- Used version control tools like SCM, CVS, SVN, GIT/STASH, Jenkins and Bamboo for pragmatic locking, synchronization and automatically reconciling and merging multiple changes made concurrently via distributed parallel programming.
- Experienced in deploying & administrating J2EE applications on WebLogic Server (9.2.2, 10.3.5,12c) and Web- Sphere 7.0, JBoss 5.x and Tomcat 7
- Experienced in developing cross-browser web applications using HTML, DHTML, CSS, XML and JavaScript.
- Project planning, estimation, tracking and preparation of various technical / project documents.
- Strong work experience in Web based application development, Database programming, distributed computing, Server side programming and Client Server computing in multi-threaded software systems using Java and J2EE.
- Excellent communication, interpersonal and presentation skills. Self-starter, customer focused, detail oriented.
PROFESSIONAL EXPERIENCE:
Confidential, OKEMOS, MI
Responsibilities:
- Develop soap based service to locate dentist for selected network in the given area like county, Zip code and state. Used XML, JAXB, XSLT and FOP to generate PDF.
- Develop the rest services for benefits, rates, contracts, Fees and Products using JAX-RS 2.0 API (Jersey ), JSON.
- Authenticating BMT application via SecureAuth login page using Spring Security, OAuth 2.0 and LDAP.
- Used SCRUM for agile development, involves in discussing requirements, estimating stories and grooming cards.
- Design and implementation of Spring-Security for the application for authentication process against LDAP, J2EE pre-authentication, and Database.
- Developed unit and functional test cases using Junit.
- Identify process bottlenecks, constraints, and improvements to enhance the design of the process and continue value cycle
- Providing recommendations for release management, technical support for procedures and application development.
Environment: JAVA 1.8, Spring (AOP, IOC, MVC, Security) 4.3.2, Spring Boot 1.5.1, Micro services, Rest web service (Jersey), GIT, Jenkins, Operating Systems (Windows 7 & Server 2003) WebLogic-Server 12c, JRE 1.8, Oracle 11g
SQL Developer
Confidential, Hines, IL
Responsibilities:
- Work with the project leadership to document the project requirements & scope.
- Elicit requirements using interviews, document analysis, requirements workshops, storyboards, surveys, site visits, business process descriptions, use cases, scenarios, event lists, business analysis, competitive product analysis, task and workflow analysis, and/or viewpoints.
- Conduct requirements meetings and document detailed minutes and action items.
- Identifying requirements for specific work products controlled by client work tracking artifacts and analyze, design and develop code for that requirement.
- Created new web application (Alice) with multiple functional components EPA, Lite Viewer, Deliver web service, Extract web service and Barcode Scanner app.
- Used spring boot for easier configuration of Spring Rest controller, Angular JS and Spring Security.
- For authentication and authorization used spring security and kerberos protocol to communicate with windows for reading security tokens data.
- Implemented REST-based Deliver services with AngularJS
- Used Spring DAO Spring Transaction API for transaction management.
- Used AngulareJs message module for Client side validation and spring validation framework for server side validation.
- Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
- Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Environment: Spring (AOP, IOC, MVC, Security) 4.3.2, Spring Boot 1.5.1, Rest web service (Jersey), AngularJs 1.5, Operating Systems (Windows 7 & Server 2003) WebLogic-Server 12c, JRE 1.8, Oracle 11g
SQL Developer
Confidential, Westlake, TX
Responsibilities:
- Involves in enhancement & production support.
- Implemented Java EE components using Spring MVC, Spring IOC, Spring transactions and Spring security modules.
- SVN to GIT/STASH Migration.
- Mavenize Payment-Hub Components
- Automating the deployment process using Jenkins and U-deploy.
- Develop and conduct the organizational readiness assessment plan and approach
- Involves in prioritizing the sprint backlog, grooming stories and estimating the effort to implement User Stories.
Environment: Web2.0/Ajax based, Operating Systems (Linux - RHEL 6.x / OEL 6.x, Windows Server 2008) Tomcat-Server 2.8.2, JRE 1.7, Spring (AOP, IOC, MVC) 3.0.5, Oracle Database 11.2.0.4, WebSphere MQ 7.5
Oracle SQL Developer
Confidential, Lake Mary, FL
Responsibilities:
- Analysis, design and develop code for Correspondence.
- Writing Batch jobs for automatic trigger using SpringBatch framework to extract data from database and load into corresponding App tables. Get the data from app table using Spring Jdbc template and generate report.
- Screen development for worker generated trigger designed and developed using JSP, GWT (Widgets and panels: Flex Table, Grid, Cell Table, Cell Browser, Suggest Box ), JavaBeans, HTML, CSS and JavaScript and AJAX.
- Develop & Test applications using Junit.
- Develop and conduct the organizational readiness assessment plan and approach
- Complete Technical Designs for assigned activities.
- Define courseware development standards.
- Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator. Generated server side PL/SQLscripts for data manipulation and validation and materialized views for remote instances.
- Assess, develop and deliver the communications among team members and display proficiency with the modules and tools used for the Correspondence Project such as Java, J2EE, Spring, Birt reporting system, My eclipse, SVN and Apache Maven
Environment: Java 1.6, J2EE, Spring (AOP, IOC, MVC) 3.0.5, Spring Batch, Rest web service, WebSphere application server 7.0, Log4j, Oracle 11g, Windows XP
Oracle SQL Developer
Confidential, Lansing, MI
Responsibilities:
- Analysis, design and develop the Admin Tool project
- Writing GWT code to create presentation layer using GWT widgets and event handlers.
- Maintain and enhance the Admin Tool.
- Complete Technical Designs for assigned activities.
- Develop & test applications as assigned.
- Ensure all the requirements are translated in technical terms.
- Interacting with Managers and gather requirements from the feature requests.
- Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
- Display proficiency with the modules and toots used for the Admin Tool Project such as Java, J2EE, GWT (Widgets and panels: Flex Table, Grid, Cell Table, Cell Browser, Suggest Box ), Spring, Birt reporting system, JBOSS application server, Apache Tomcat, My eclipse, SVN and Apache Maven
Environment: Java 1.6, J2EE, Spring (AOP, IOC, MVC) 3.0.5, GWT 2.4.0, JBoss application server 5.x, BIRT Report 3.7.0, Log4j, maven 2.7, Oracle 11g, Windows XP
SQL Developer
Confidential, Westlake - TX
Responsibilities:
- Understanding the business requirements and map them with current project technologies to develop the feed.
- Mapping the COBOL data elements with oracles tables and writing stored procedures to invoke data.
- Writing the program to generate feed using java, j2ee and generate data for feed by using ibatis to communicate between java & oracle.
- Experience in Implementing API's in Java Multi-Threaded Environment
- Writing the beans and mapper xml’s to communicate to with oracle procedures.
- Writing criteria builders to filter the data by applying specific where clause using java programs.
- Build and deploy the project using ant build.
- Coordinating with business users for signoff after generating the file in specific format as per requirement.
Environment: Java 1.6 (Multithreading, Data Structure, Collection API), J2EE, Spring (AOP, IOC, MVC) 3.0.2, mybatis 3.0.1, Log4j 1.2.15, Tomcat 7, Oracle 11g, Windows XP
Pl/SQL Developer
Confidential, Denver, CO
Responsibilities:
- Work with the systems development team and process team to plan, design, and test/implement IT solutions in EDIP.
- Migrated NPAC web service to from WebLogic version 9.2.2 to 10.3.3.
- Improved the Data Model performance by using Second level caches with Hibernate.
- Added new internal porting operation to NPAC Web service to create and activate service.
- Designed and implemented the Hibernate Domain Model for the services.
- Designed and integrated the full scale Hibernate / Spring / EJB persistence solution with the application architectures.
- Designed WSDL's and elaborated type definitions schemas based on corporate standards, integration and security specifications.
- Build and Deploy with Ant and Maven
- Implemented the web services and associated business modules integration
- Elaborated use cases, interface definitions and web services specifications in collaboration with Business and System Analysts and Architecture Group
- Document major projects for technical and functional design.
Environment: Java 1.5, J2EE, Spring (AOP, IOC, MVC) 3.0.2, Hibernate 3.3.2, Soap based Web service, Log4j 1.2.15, Apache Digester, Bea WebLogic Server 9.2 and 10.3.3, Oracle 10, Windows XP
Pl/SQL Developer
Confidential, Milwaukee, WI
Responsibilities:
- Worked as Onsite Coordinator to coordinate the development and project planning activities between Onsite team in USA and Offshore team in India.
- I was actively involved during the requirement gathering phase for this project. During this phase, I was required to understand business requirement from business users, map them to the technology and processes, discuss the functional and technical solution to business users and obtain timely sign off.
- Integrating CSI application with US bank vendor for ISA bill payment and with OneSource for Tax information.
- Design and Coding of User Interfaces using J2EE, JSP and Servlet.
- Analyzing new opportunities for my group. This includes daily interaction with business users to get the call data and understand the various problems faced by the field technicians in the field.
- Involved in Testing and designed UML class diagrams, collaboration diagrams sequential diagrams using Visio.
- Design and Coding of communication module with MQ Series.
- Coding the business tier which includes the DAO pattern and delegates using JDK 1.5 APIs.
- Deployment of application to UAT, production environments, resolving issues with other deployment and testing groups.
- Co-developed the core messaging module using Web Services, SOAP APIs.
- Packaging and Deployment of product on Web sphere 7.0 using ANT scripts.
Environment: Java 1.5, J2EE, Log4j, Apache Digester, IBM Web Sphere Server 7.0, IBM MQ, Windows XP
Confidential, Milwaukee WI
Responsibilities:
- Responsible for understanding and documenting financial business processes
- Handled the processing of XML files using SAX/DOM parsers.
- Extensively used JAXB parsers to parse XML into objects
- Execution of multiple threads concurrently using Executor Service
- Responsible for development of XML Schema for message communication
- Worked on data access objects (DAO) to access the data from MQ Series, Informatica generated XML files.
- Responsible for creation of Process and Data access beans
- Responsible for using a PGP encryption and writing shell scripts to FTP data files.
- Worked on Unit, Integration and Load Testing
- Worked in QA/Staging and UAT/CAT phases
Environment: Java 1.5(Multithreading, Data Structure, Collection API), J2EE, Log4j, Apache Digester, SAX/DOM, Ant, Sun Solaris, Windows XP
Confidential, Boston, MA
Responsibilities:
- Managing a development team of 5-members as Senior Software Engineer and working as Onsite Coordinator.
- Analyze each problem to design the work-flow which supports the solution to the problem.
- Design and Coding of various JAVA modules for generating Risk reports.
- Design and Coding of the XML based Business Rule Engine using SPRING APIs.
- Coding the business tier which includes the business objects and delegates using JDK 1.5 APIs.
- Pulling data from ftp location to and updating the database. For this develop/ modified different scripts in UNIX and Data marshaling done through different kettle jobs.
- Converting data as .csr file so that Algo engine understand and generating reports used Java Program to write business logic and JSP’s to represent the information.
- Updating the information in Jira for every deployment.
- Enhance & maintain existing system keeping in mind zero outage for end users.
- Provide production support after major production release and work on break fixes (if any).
- Conduct weekly meeting with client and provide updates on the progress of work. Discuss on enhancing existing system and pipelined projects.
- Ensure that the project matches CMMI Level 5 requirements and fits appropriately in metrics. Resolve noncompliance (if any).
Environment: Java 5, Spring MVC Spring (AOP, IOC, MVC ) 3.0.2, Front Controller, IOC, JSP, JSTL, Custom Tags, HTML, CSS, XML, Java Script, Oracle 9i, PL/SQL, DB Objects like Stored Procedures, Triggers, Views, Functions etc, Log4J, UNIX Box Windows XP.
Software Development
Confidential
Responsibilities:
- Creating Use Case by capturing screens from existing system.
- Discussing with client about actual requirement and understanding the existing flow.
- Developing the html pages by using use case & taking sign-off .Once done converting them into Jsp pages and modified JSP’s with struct2 UI tags.
- Used Façade pattern to hide backend service calls.
- Reviewing the work done by junior team member and helping out to achieve goals.
- Interacting with counter parts of team member for getting WSDL files.
- Read WSDL files by populating data in Java Beans and represent it through JSP pages.
- Updating the information to respective manager & other team members.
- Developing existing system with new look & feel, keeping in mind zero outage for end users.
- Conduct weekly meeting with client and provide updates on the progress of work. Discuss on enhancing existing system and pipelined projects.
- Ensure that the project matches CMMI Level 5 requirements and fits appropriately in metrics. Resolve noncompliance (if any).
- Co-developed the core messaging module using Web Services, SOAP, and Apache Axis APIs.
Environment: Java 1.4, struct2, JSP, JSTL, Custom Tags, HTML, CSS, Java Script, log4J, Windows XP.
Confidential
Responsibilities:
- Understand the requirements thoroughly by interacting with the client.
- Collecting raw Data from upstream system by marshaling Data using Informatica to update Prime View database. For this modified/ enhanced the mapping and workflow.
- Coding the persistence module using JDBC, SQL/PLSQL and SYBASE.
- Preparing the Proof of Concept and the Presentations to demonstrate the solution to the business users.
- Modified / created stored procedure in Sybase to filter data per requirement.
- Writing XML to format dynamic data representation.
- Writing Beans and Java classes to read data from xml
- Analyzing and Enhancing the Code.
- Involved in Web to Web Testing with Automation and Manual.
- Daily interacting with the client about work status.
- SCM handling - Release management activities, mentoring the team.
- Estimation and scheduling work.Informatica:
- Created different mappings and enhancement on existing mappings for loading the data into Sybase and Oracle database.
- Designed various mappings for extracting data from various sources like relational tables and flat files.
- Using Designer to create source definitions, design targets, create mapping and developtransformations.
- Prepare UTC’s and Review the UTC’s.
- Development work related with the approved change requests
- Involved in Unit Testing to get signoffs from client on the QCs(change requests).
- Worked with the onsite team on performance tuning front by supplying the required statistics on long running jobs with suspected bottlenecks after series of runs.
- Involved in resolving production support issues.
Environment: Java 1.4, Servlet, JSP, JSTL, Java, Perl, Informatica, HTML, CSS, Java Script, log4J, Windows XP. BEA WebLogic 6.1, 7.0, Informatica server
