SUMMARY

• With 6.5 years of experience in analysis, design, development, integration and testing of Object Oriented, Middleware and web based Enterprise applications using TIBCO, Java/J2EE, PL/SQL and Client - Server technologies.
• Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Triggers, Packages and using the latest features to optimize performance.
• Extensive hands-on experience Core Java, JDBC, J2EE (JSP, Servlets), Hibernate, Spring MVC REST, JavaScript, jQuery, HTML5 and CSS.
• Expertise in Client-Server application development using Oracle PL/SQL, SQL *PLUS, TOAD and SQL*LOADER, SQL Developer, DB2, TOAD
• Motivated, Energetic, hardworking Innovative and team player with excellent communication, Analytical problem solving and trouble shooting skills.
• Proficient in Java/J2EE Design Patterns including singleton, Factory, Session Façade, ModelViewController (MVC), DataAccessObject (DAO). Well versed with core Java concepts like collections, multithreading and serialization.
• Experience in software development Life Cycle that includes requirements definition, analysis, design, development, testing, training, implementation and support of application software using SOA.
• Proficient in Object-Oriented Concepts & Software Engineering Methodologies like Waterfall and Agile methodologies like Scrum and Kanban.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, materialized Views, and Query Re-Write.
• Proficient in advance features of Oracle 11g /10g for PL/SQL programming like using cursor variables, Reference Cursors, VARRAYS, Nested tables, Dynamic SQL, Bulk Binds, Inline views, Global Temporary Tables.
• Experience in application and database Fine-tuning using Explain Plan, SQL Trace and TKPROF
• Involved in preparing FS (Functional Specification), CDD (Customer Design Document), HLD (High Level Design), LLD (Low Level Design) and UTP (Unit Test Plan).
• Experienced in all stages of Software development life cycle starting from gathering Business specifications, analysis, design, development, testing and implementation of projects using various methodologies Waterfall, Agile, Scrum.
• Experience in J2EE technologies, including Servlets, JSP, JSF and JDBC, HTML5, Spring (batch, boot & cloud), Spring MVC, Multi-Thread Programming
• Worked on Application Servers like JBoss and Servlet Engine like Apache Tomcat
• Expertise in using development tools like Eclipse IDE and Netbeans, TOAD, SQL Server.
• Extensive experience in working with Windows, UNIX, and LINUX platforms.
• Expertise in using source control tools, mainly Rational Clear Case and hands-on experience with TFS (Team Foundation Server).

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Solaris, Linux

Languages: Java, SQL, PL/SQL.

Web Technologies: HTML, XHTML, CSS, XML, JSP and JSTL

Application Frameworks: JDK, J2EE, Log4j, Spring, Hibernate, MVC

Design Patterns: MVC, Singleton, DAO Factory

Scripting Techniques: JavaScript, AJAX, JQuery.

Frameworks: Struts, JSF, Spring.

Tools: /IDE: Eclipse, Netbeans, TOAD, SQL DBX, SQL Loader, IBM DB2

Application Servers: JBOSS EAP, Web logic Application Server and Web Sphere Application Server 6.1, Apache Tomcat

Databases: Oracle 10g, 11g, MS-SQL Server 2005/2008, Sybase ASE, DB2

Version Control: IBM Rational Clear Case, TFS (Team Foundation Server), GitHub

Middleware Technology: TIBCO (Active database, BW), Java Messaging Service (JMS)

Testing: JConsole, Junit, Selenium

PROFESSIONAL EXPERIENCE

Confidential

Solution Architect/ Lead Developer

Responsibilities:

• Developed a real time integrated energy commodities trading data repository (ODS) in Oracle 11g, Java and XSLT to streamline reporting of trading activities.
• Worked with the Business analysts for requirements gathering, business analysis, testing and project coordination
• Implemented a Rules Engine and Simple Event processor for real time reporting of primary economic terms to the Swap Data repository (SDR) using JDBC, Oracle and JMS.
• Architected a solution in Java and Oracle 11g database to send out paperless confirmations on agreed terms to the trading parties.
• Performed extensive SQL query and Java code optimizations for large datasets.
• Improved Dodd Frank regulatory reporting system performance by 40% through extensive SQL query and code optimizations. This helped processing of nearly 30, 000 large data sets in an hour.
• Creating design and implantation/deployment instructions document.
• Extensively involved in writing SQL queries in DB2, Sybase and PL/SQL programming.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Coordinated with offshore teams located in India to manage and deliver the plan/assign work for the team.
• Worked on a POC for implementing an ESB for the trading platform services using JBoss Fuse and JBoss EAP 6.2.1
• Worked on POC for developing services with multithreading to handle and process multiple messages using Java, Spring.
• Used Apache ANT for compiling, building and deploying the project.
• Used log4j logging framework, developed, and maintained various test cases and performed unit testing using JUnit.
• Documented the architecture of the system in detail.
• Attending Scrum meeting on a daily basis with whole team about the status, issues, showstoppers and other non-functional aspects.

Confidential

Senior Systems Engineer

Responsibilities:

• Designed and developed a SDK in Java using openadaptor toolkit to provide an open source based solution for Enterprise Application Integration.
• Created a web based monitoring and reporting solution using Java Mail API, JDBC and JMS to track exceptions and unprocessed messages.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL in Oracle and maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Developed database objects, functions, and stored procedures in DB2
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Used Maven plugins for developing applications in Java, JSF.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed extensive peer reviews and unit testing before integrating code on to source control.
• Developed an application in Java, JSPs and UNIX shell scripts to monitor critical integration services and notify administrators in case of failures, reducing support costs and effort by 25%. Deployed the application using JBOSS server.
• Collaborated efficiently with global teams in the integration and release management.
• Used JConsole for performance testing of integration services.

Confidential

Systems Engineer

Responsibilities:

• Created an Exam creation and evaluation portal using HTML, JavaScript with Oracle back end to align the users to the processes of NAGP. Used JBOSS server for deployment.
• Used Servlets for dynamic generation of login, logout and web pages. Designed in Singleton Patterns.
• Developed TIBCO Active Database Adapters and TIBCO Business Work processes for the NAGP Applications.
• Wrote XSLT files in Map Force to assist in Integration and transformation of data from different databases.
• Worked on the enhancements, code fixes, debugging and testing of the Integration Layer.
• Database design and developing stored procedures and SQL queries in PL/SQL.
• Database design and developing stored procedures in DB2
• Developed various complex stored procedures, packages, interfaces and triggers in Oracle PL/SQL and DB2
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Responsible for the system user interface creation.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Designing and developing adapters using TIBCO ADBs.
• Developing ECMA scripts, configuring TIBCO IMs.
• Mentored new team members for development activities, standards and introducing the trading domain.