SUMMARY

• Seven years of experience with databases such as Oracle, SQL Server, MySQL and Mongo DB and in writing SQL and PL/SQL queries, stored procedures, Triggers, Cursors, Functions, Report, Form and Exception Handling for back end development.
• Good knowledge on RDBMS.
• Experienced in Unix and Linux platform.
• Worked on QA and UAT Database
• Good working knowledge on development and management tools like SQL*PLUS, SQL Developer, VI, Toad, MongoVUE, Edit*PLUS, Eclipse, MyEclipse and Netbean.
• Experience with Linux Command and Shell Scripting.
• Experienced with version managements system SVN
• More than six years of IT experience in various roles such as Database Developer, Programmer Analyst involving complete SDLC life cycle: Database Design, Testing and Implementation.
• Strong experience in development and deployment of production to Apache Tomcat, JBOSS, WebLogic Server in Linux and Windows environment.
• Experienced in major Java Technologies (JavaBeans, Servlets, JSP, JDBC, Web services).
• Experienced in developing enterprise applications using open source Technologies such as Maven, Log4j and jUnit.
• Solid communicator with exceptional team - building skills, dedicated, self-motivated achiever and ability to work independently and perform well within cross-functional team.

TECHNICAL SKILLS

Operating Systems: Windows Server2003, NT, XP, Windows7 and Linux.

Database Technologies: SQL, PL/SQL, JAVA, Shell Script, MongoDB Query, Endaca API. VB

Databases: Oracle 9i/10g/11g, MySql5, Sql Server2008, MS Access

Application Servers: Apache Tomcat, JBoss, Web Logic

Design Patterns: MVC, DAO, Factory, Proxy, Singleton

IDE’S, Build/Development: SQL*PLUS, Sql Developer, VIM, Toad, Eclipse, MyEclipse, EditPlus, Ant, Maven, SVN

Application: HP QuickTest Professional, HP LoadRunner, Adobe Photoshop, 3D Max

PROFESSIONAL EXPERIENCE

Developer

Confidential, Reading, PA

Responsibilities:

• Created Oracle Tables, Views, Constrains, Index, Sequences with SQL queries.
• Used PL/SQL to create stored procedures for Entity Summary Pages.
• Writing Backend Procedures, Functions, Triggers, Packages, Report and Form in PL/SQL.
• Involving in J2EE application development.
• Implement store procedure call in JDBC.
• Offering SQL query for Cold Fusion front-end page directly.
• Handling Exception and Runtime Error.
• Troubleshooting experience in debugging and fixed the wrong data or data missing problem for both Oracle Database and Mongo DB.
• Involved in data migration from Oracle database to Mongo DB.
• Implemented SQL and PL/SQL store procedures for Magnolia CMS project.
• Worked on Tuning the SQL Queries for better performance and troubleshooting development problems.
• Worked on QA and UAT Database
• Experienced in installing, creating Oracle databases in different platforms like Red Hat Linux, Unix and Windows.
• Using Linux Command and Shell scripts to check Linux and JBoss Server performance and log file.
• Took production deployment call.
• Working with Java Developer to check and improve data quality.
• Written database triggers for automatic updating the tables and views.
• Designed and implemented schema.
• Worked with entity-relationship diagrams (ERMs) to create technical/system design documents.
• Assisted in preparing the test Plan, Test Cases for the functional testing

Environment: Java1.7, Oracle11g, Mongo DB, Access 2003, SpringMVC, Servlets, ColdFusion, Magnolia CMS, Java script, JSP, JQuery, Ajax, CSS, HTML, XML, Eclipse, Tomcat5, RedHat5.

Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Facilitated sessions to gather User Requirements and Business Requirements from Business User Group to document Functional Requirement Specification, Technical Requirement Specification that provided appropriate scope of work for Technical team to develop overall system.
• Writing SQL queries to Create tables, update, delete and search entries.
• Used PL/SQL queries and stored procedures to generate report and form.
• Used MVC and DAO design patterns for business logic.
• Involved in development of model & view layer using Hibernate framework.
• Involved in data migration from legacy system into updated application database.
• Developed the Custom Form and Customized the existing form as per the client requirement.
• Offered SQL query for frontend script like JQuery.
• Data migration and conversion done utilizing Oracle utilities: SQL Loader
• Written bash shell scripts that were used for checking Network status, Disk space, Virtual Memory, Shared Memory and Control processes.
• Customized standard reports to include project information.
• Extensive experience with Jboss development platform and J2EE application development lifecycle.
• Extensively used Java script, CSS, HTML, HTML 5 for developing visually appealing User Interface pages of the web modules.

Environment: Core Java, J2EE, Eclipse 3.3, JDBC, PL/SQL, Ajax, Oracle11g, Hibernate3.0, Spring3.0, RedHat5.4, Web Services, BEA Weblogic Server 8.1, Apache Tomcat 5, EJB3.0, SOAP1.1/1.2, JSP, JSLT, CSS, JMS, Struts 2.0, XML.

Developer

Confidential, Pittsburgh, PA

Responsibilities:

• Responsible for writing complex SQL and PL/SQL queries for writing stored procedures and triggers.
• Experience in database performance tuning and query optimization.
• Extensively used SQL *Loader to load Data from flat files to Database tables in Oracle.
• Implemented persistence layer using Hibernate to store the persistence data into Oracle and MySQL database.
• Involving in Data Access Object (DAO) development process to realize data manipulation function based on pattern.
• Used SVN (Subversion) to maintain and enhance source code.
• Followed the Rational Rose (UML) for Full System Development Life Cycle.
• Created Data Flow Diagrams, Flow Charts, ER-Diagrams and Work Flow Diagrams in Requirement Collection
• Was assigned the task of deploying the application different working environments.
• Developed Front-end using HTML, JavaScript, CSS, AJAX, Jquery.
• Deployed the applications on Apache Tomcat Server.

Environment: Java1.5, Oracle11g, MySQL5, Struts. Hibernate, Spring, Servlets, Java script, JSP, JQuery, Ajax, CSS, HTML, Microsoft Visio, XML, Eclipse, Junit4, Tomcat5, Windows7.

Developer

Confidential

Responsibilities:

• Developed the DAO Layer to connect with backend Database Oracle
• Implement JDBC to call SQL and PL/SQL procedure to contact
• Implemented the application using the concrete principles laid down by MVC design patterns.
• User interface was designed using HTML, CSS, and JavaScript.
• Implemented JSP, Servlets, and Java Beans to develop Interface.
• Developed XML documents and worked on DTD/Schemas.
• Used SVN for version control across common source code used by developers.
• Worked with Testing team for quality assurance of all web design projects, including web usability, accessibility, testing and debugging.
• Deployed the applications on WebLogic Server.

Environment: Java1.5, Oracle10g, Windows NT, HTML, XML/XSLT, DTD, JSP, Servlets, Struts2, Hibernate, spring, Eclipse, Junit4, SOAP, WebLogic Server 9, Redhat5.

UI Developer/ Tester

Confidential

Responsibilities:

• Wrote and executed SQL scripts and stored procedures to validate data, which flows to the end user with the actual data in the Database.
• Involved in developing User Interface using HTML
• Developed CSS files for front end UI.
• Front-end validations of HTML forms were done in JavaScript
• Developed dynamic pages with JSP.
• Frequently used Entity Relationship model (E-R model) to design database foundation
• Involved in preparation of Manual and Automation Test Plan.
• Preparing, Executing and reviewing Test Plans and Test cases.
• Performed various tests such as positive, negative to check business functionality manually.
• Automating Functional and Regression Test Cases using HP QuickTest Professional (QTP).
• Create and execute HP LoadRunnerautomation scripts.
• Performed Smoke testing for various builds before accepting into the QA environments.
• Preparing Test Reports and keep track of defects

Environment: Java1.5, Oracle10g, Windows XP, Windows NT, HTML, JSP, Redhat5, Eclipse, SQL, PL/SQL, SQL*Plus, Microsoft Visio, FrontPage, Junit4, HP QuickTest Professional, HP LoadRunner.