EXPERIENCE SUMMARY:

• 13+ Years of Solid Software development experience of working with Design, Analysis and Development of Internet, Intranet, Database and Multi Tiered Client - Server Applications. Strong exposure to all phases of Software development life cycle (SDLC).
• Expertise in Developing Applications using various technologies e.q Java, J2EE, JSP, Servlets, Java Beans, JDBC, XML, Eclipse, IntelliJ Idea, WebSphere, Spring, HTML, RESTful, Ajax, CSS, Java Script, Apache Tomcat, iPlanet, CVS, SVN, JNDI, Unix, Oracle, SQL, PL/SQL, SQL Server and Informatica.
• Specialize in the full stack, from deployment and backend services to front-end development.
• Energetic self-starter with excellent Investigative, Communicational, Analytical, creative and Organizational skills; Capable of adapting to new work environment and technologies in short term with a proven track record of producing outstanding results for client satisfaction.
• Strong understanding of J2EE design patterns like MVC, Data Access Object, Data Transfer Object and Singleton.
• Extensively work on Application Servers like SunOne7.0, WSAD 5.x, Tomcat App Server, JBOSS and IBM WebSphere 7.0/8.5.
• Extensively worked on UI layer and client side validations using HTML, CSS, JSP, JSTL, JavaScript, AJAX, JQuery and Dojo Toolkit.
• Extensive experience in Open Source Frameworks such as spring (IOC, MVC, JDBC Template, Security), Jakarta POI and Log4J (logging Framework).
• Lead the project team, including Requirement gathering, General Design, estimations for efforts, Signoff’s, managing project schedules, Implementation plan and communication to management.
• Imparted technical direction and guidance to the development team to create designs, develop systems, resolve issues and manage development schedule.
• Strong Database Development, Data Integration, ETL Development, Conversion & Data Migration experience using Oracle, SQL, PL/SQL, Unix and Informatica.
• Testing and debugging the project for proper functionality and documenting by modules. Integrated sub modules from other members of the team.
• Technical documentation of different lifecycle deliverables and user manuals.
• Experience in Logical & Physical Database Design, Development using Erwin.
• Experience in Dos batch programming, UNIX shell scripting and Scheduling using Autosys & TWS.
• Conscious towards coding Standards and Documentations.
• Well-organized, efficient, quick learner with excellent ability to plan, organize, prioritize work and to meet on time the deadlines.

TECHNICAL HIGHLIGHTS:

Internet-Technologies: Java, J2EE, Servlets, JSP, HTML, Spring, JavaScript, JDBC, JNDI, Java Beans, CSS, DOJO Toolkit, JQuery, Web Services, Ajax, Log4J, REST, JSON, Hibernate

Framework: MVC

Version Control: PVCS, VSS, SVN, CVS

Web/Application Servers: Apache Tomcat, iPlanet, SunOne7.0, IBM Web Sphere 7.0/8.5

IDE/ Protocols: Eclipse, IntelliJ Idea, WSAD, PL/SQL Developer, Toad, Oracle SQL Developer

Databases: Oracle 8i/9i/10g/11g, SQL, PL/SQL, MySQL, MongoDB, SQL Server, MS Access

Operating System: Windows XP/2000/NT, UNIX, Linux

Scheduler: Autosys, TWS

Applications: Model N, E-Procurement, Lawson

ETL Tools: Informatica 7.1/8.6, SSIS

Reporting: OBIEE, BMC

Miscellaneous: FTP, SFTP, FileZilla, Putty, SQL* Loader, Log4J, Jakarta POI, Maven, Jfreechart, Microsoft Visio, Jira, Service Now

PROFESSIONAL EXPERIENCE:

Confidential

Senior Programmer Analyst

Akron, OH

• Worked on Requirement gathering, Analysis, General Design, Detailed Design, Development, Testing and Supported UAT on multiple projects including Dash Board (Real Time Statistics), QC Tracking System, Supply Order System, Eplus implementation, Recall Processing Improvements, New Store Staging etc.
• Developed Complex Programs, Applications and maintain/support existing Applications using Java, J2EE, MVC Framework, JDBC, JSP, HTML, Servlet, Java Script, Dojo Toolkit, JQuery, IBM WebSphere, CSS, Java Beans, Oracle, PL/SQL and Shell script.
• Designed and Developed Java/J2EE Web based QC Tracking System to capture the QC activities and provide dashboards/reports for management to monitor the team’s progress throughout the day, to have historical data for future planning and resource estimation using Java, J2EE, JSP, Servlets, Spring JQuery, RESTful Web Services, AJAX, HTML, CSS, IBM WebSphere, Java Script and Oracle at backend.
• Designed and Developed Dash Board Web based Application to provide near Real Time statistics to track pick progress and provide projections. Application was built using Java, J2EE, JSP, Servlet, HTML, spring, Spring JDBC, Spring Security, Dojo Toolkit, JQuery, Java Script, Rest Full Web Services, and Ajax.
• Designed and Developed Java/J2EE web based Supply Order System for ordering supplies by store, home office and Third party vendors. System replaced existing POS command based system used by stores to order supplies and built using Java, J2EE, JSP, Servlets, spring, Spring JDBC, Spring Security, HTML, CSS, JQuery, RESTful web Services, AJAX, JavaScript and Oracle as backend. Application was built on existing Lawson ERP system.
• Worked on developing Job Estimation view for Custom Jewelry system for actual product manufacturing for Vendors, CASSi usage drill down reporting from Corporate Level to Store Level involving various type of visualization of figures in Charts.
• Extensively worked on implementing Procure-to-Pay system in Sterling across multiple departments by understanding existing business processes, mapping the same in EPLUS system and building interfaces between Eplus and existing Lawson system (system of records for Inventory & Payments).
• Utilized JQuery based components e.g TableSorter, jqGrid.
• Developed the User Interfaces using HTML, CSS, JSP, JavaScript, Dojo, JQuery and Tiles etc.
• Lead the project team, including Requirement gathering, General Design, estimations for efforts, Signoff’s, managing project schedules, Implementation plan and communication to management.
• Translated business requirements into effective and efficient computer systems at the subsystem level by creating detailed level specification document.
• Performed viability analysis on various Eplus interfaces for Procurement/Purchasing department e.g. Inbound PO, Inbound Invoices, and Non PO Invoices.
• Responsible for creating document required as per the SDLC e.g. Detailed Design, Technical specifications, Unit test suite/case and Unit test log.
• Created Unit and System Test plans and executed to test the functionality of the various projects and Supported User Acceptance testing.

Tools: Java, J2EE, JSP, Servlets, Java Beans, JDBC, Java Script, HTML, CSS, DOJO Toolkit, JQuery, Jfreechart, Log4J, IBM WebSphere, RESTful Web Services, AJAX, Maven, Spring Security, Spring JDBC Template, Oracle 9i/10g/11g, SQL, PL/SQL, Oracle SQL Developer, PL/SQL Developer, SQL* Loader, BMC, TWS & Autosys, UNIX, Putty, FTP,SFTP, Microsoft Visio, Microsoft Project Plan, E-Procurement, Lawson, CVS & SVN.

Principal Consultant

Confidential, Lake Forest, IL

• Worked on Requirement gathering, Analysis, documentation, development and Testing.
• Created document required in different phases as per the SDLC e.g. Technical specifications, code review, Unit test plans & unit test results.
• Developed ongoing interfaces and build programs for conversions.
• Developed/Coded complex application Interfaces and conversion program using Oracle 9i/10g, SQL Server 2008, SQL, PL/SQL, T-SQL, DTS, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, Autosys, Model N, TOAD, Batch and UNIX scripting.
• Created unit test plan & unit test result document and executed test plans to test the functionality of the various modules/interfaces.
• Supported the Integration testing between various systems.
• Developed complex data extraction program and transformed into required file format using PL/SQL, SQL and DTS packages.
• Designed data extraction and conversion strategies from E&Y tool (SQL Server database).
• Designed and oversaw data verification and validation process by providing various ad-hoc extracts from legacy systems as well as from E&Y for business.
• Handled all database development, Data extraction, Conversions, Verification and validations for multiple projects eq Phoenix, GPSC & Chexs.
• Worked as Single point of contact for all Oracle database related development & extraction activities.
• Designed and developed database objects in Oracle database for the application & interfaces.
• Develop and maintain Oracle database objects E.Q. tables, views, Procedure, Functions, Package, and database triggers.
• Developed Autosys jobs code for scheduling ongoing interfaces.

Tools: Oracle 9i/10g, SQL Server 2008, SQL, PL/SQL, T-SQL, DTS, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, Autosys, Model N, EDI, UNIX, Batch, TOAD, FTP

Senior Software Engineer

Confidential, Overland Park, KS

• Worked on Requirement gathering, Analysis, Design, documentation, development and Testing.
• Translate business requirements into effective and efficient computer systems at module level by creating technical specification document.
• Contributed in Complex Application development, Conversion and data Integration using Java, J2EE, JSP, Servlets, Java Beans, JDBC, MVC, HTML, CSS, Java Script, Unix, Batch scripting, Oracle9i/10g, SQL, PL/SQL, Informatica 7.1/8.6, XML, SQL* Loader, Unix, Autosys, TWS, IBM Mainframe JCL, Jakarta POI, PVCS, VSS, SVN, eBuilder, Kintana, Log4j, Jtest and application server iPlanet, SunOne.
• Created unit test plan document and executed test plans to test the functionality of the application.
• Developed documentation as required in different phases of Software Development Life cycle process.
• Worked as full stack Java developer, from deployment and backend services to front-end development.
• Worked on setting up test data/scenarios in staging environment to support User acceptance testing.
• Worked on various application module e.g Treaty/Facultative contracts, Manual booking, Process Automation application, Reports from End to End on building graphical user interface, writing business logic in service layer and writing backend code.
• Implemented the applications by moving Oracle, Java and Informatica code to production.
• Developed external Interfaces involving high data volume to import and export.
• Developed ETL processes and Data integration and Data conversion program using Oracle PL/SQL, Informatica.
• Worked on Integration of new business source into application reviewing source system, deciding data acquisition strategy, ETL development, Web Application Changes, Testing and stored procedure/function changes/creation.
• Developed Complex Reports using Java, JSP, and Servlets and used Jakarta POI API for exporting reports in excel format.
• Written PL/SQL procedures, functions & packages to implement various functionalities in application E.Q. Treaty add/update, Fac contract add/update, Manual loss booking, Manual premium booking.
• Extensively used TOAD, Oracle SQL developer & PL/SQL Developer to create database objects E.Q. tables, views, procedures, function and database triggers during the course of development.
• Worked on implementing coding standards in Java and Database code suggested by Application Quality/ team.
• Worked on rewriting & changing the existing application procedures to increase performance.
• Worked with Business group to advice on Design and work/time estimation.
• Responsible for writing Batch scripting and UNIX shell scripting.
• Documented business rules, functional and technical designs and test cases.
• Written DAO for fetching data from database and Involved in writing complex queries using sql.
• Worked on Reports to generate the Reports in web & Excel form Using Java, JSP, Servlets, Java Beans, JDBC and Jakarta Poi and written scripts to populate the month end reporting tables using Informatica.
• Developed complex Month end closing reports using Java, JSP, Java Beans and SQL.

Tools: Java, J2EE, JSP, Servlets, DAO, MVC, JavaScript, JDBC, Hibernate, Connection Pooling, HTML, XML, SAX/DOM, CSS, iPlanet/Sun One 7, Log4J, Jakarta POI for excel sheet generations, Informatica 7.1/8.6, Oracle 9i/10g, PL/SQL, SQL* Loader, Oracle SQL Developer, PL/SQL Developer, JTEST, Hammurapi, PVCS, VSS, eBuilder, Kintana and Maximo.

Confidential

Software Engineer

• Worked on Analysis & Design, coding, and testing. Developed documentation as per the Software Development Life Cycle.
• Developed applications using Java, JSP, Servlets, Java Beans, HTML, XML, XSLT, JDBC, Oracle, SQL, Java Script, SQL, Apache Tomcat, Mysql and SQL Server 2000.
• Implemented the MVC architecture for the J2EE framework compliant to the Sun Specification (n tier framework).
• Developed complex SQL queries to fetch data from various tables and to fulfill the reporting requirements.
• Written Intermediate Java Servlet to capture the posted form data and further process it on server side.
• Created and maintained Oracle database objects E.Q. tables, views, synonyms and database triggers and extensively used SQL * Plus and Toad for same.
• Used Explain plan and worked on tuning of complex & time taking queries.
• Designed Front end screens using HTML, CSS, JSP and Java Script.
• Developed Dao for the Module having Complex SQL Statement.
• Configured application and Deployed on Apache tomcat as per the MVC framework.
• Worked on creating constraints E.Q. Primary key, foreign key, and Check constraint to implement business rules.
• Involved in designing tables and their properties and programming JDBC connectivity.
• Created unit test document and executed test plans to test the functionality of the application.
• Setup test data/scenarios and assisted in User Acceptance testing.
• Used request/response objects to capture the data coming from client forms.
• Developed Server-Side Java Servlets to capture the posted form data/ Session object and further process it on the server side.

Tools: Java2.0, Servlets, JSP, JDBC, HTML, XML, XSLT, JavaScript, Java Beans, Apache Tomcat, My Sql, SQL Server 2000, Netscape Communicator and Internet Explorer 4.x browsers

Confidential

Junior Programmer

• Developed Complex Applications using Java, JSP, Servlets, Java Beans and JDBC, HTML, Java Script, Oracle, XML, SQL * Plus, Jrun, SQL and My SQL.
• Worked on Implementing the MVC architecture for the J2EE framework compliant to the Sun Specification (n tier framework).
• Designed and Coded Front end screen using HTML, JSP, Flash and Java Script.
• Written complex SQL queries to fetch data from various tables for reporting.
• Developed Server-Side Servlets and JSP to capture the posted form data/ Session object and further process it on the server side.
• Develop Database objects like table, view, triggers and indexes using Oracle * Plus.
• Used request/response objects to capture the data coming from client forms.
• Used Type-4 (Thin Client) JDBC drivers to access data from Oracle database.
• Written JAVA classes to generate questions in XML format from the database.
• Developed client side validations using JavaScript and written Java classes to Implement JDBC connectivity.
• Created Unit test scripts and executed test plans to check the functionality of the application and assisted in Integration testing.

Tools: Java2.0, Servlets, JSP, JDBC, Flash 5.0, XML, Oracle 8, Jrun3.1, Java Script. CSS, Oracle SQL* Plus, Netscape Communicator and Internet Explorer 4.x browsers

Confidential

Java Developer

• Developed Application using Java, JSP, Servlets, Java Beans, HTML, Java Script, CSS, SQL and Mysql database.
• Designed and coded HTML and JSP pages and done form validations using client side javascript.
• Involved in creation of Tables, Views, Synonyms, triggers and constraints.
• Coded application module using Java, JSP, HTML, CSS, Java Beans, SQL and Mysql.
• Worked on generating various reports using JSP, Java Beans and SQL.
• Developed DAO for the modules having complex sql statements to interact with database.
• Written sql queries for generating reports.
• Done client side form validations using javascript.
• Worked on Unit testing.
• Develop JSP/Servlets for handling request/response objects.
• Created style sheets using CSS.

Tools: Java, JSP, JDBC, Servlet, Java Beans, HTML, JavaScript, Mysql, CSS, Apache tomcat, Internet Explorer 4.x browsers