PROFILE SUMMARY

• 7 years of IT professional experience in Oracle SQL, PL/SQL application development and production support of various oracle based applications involving designing, developing, configuring, maintaining the oracle9/10g/11g/12c databases environment
• Ability to quickly learn new IT tools and techniques, adapt to changing client needs and to communicate at all levels of personnel and productively work in a team environment

technical summary

• Experience includes developing PL/SQL packages, PL/SQL procedures
• Experience includes writing complex SQL queries, PL/SQL code for search operations
• Experienced in creating stored procedures, functions, triggers, views, materialized views, db links, constraints and query rewriting
• Data migration between Oracle 10g and 11g using export/import utility and PL/SQL procedures
• Experienced in writing cursor for loops, ref cursors and BULK COLLECT, PL/SQL collections in PL/SQL procedures
• Experienced in creating indexes and sequences on tables based on performance analysis
• Created db links, constraints
• Experience in writing MOD PL/SQL packages, web reports using Oracle Web Tool Kit HTF, HTP, OWA UTIL packages and utilities
• Worked on PL/SQL transactions, PL/SQL tables, associative arrays index by tables
• Involved in generating various reports in Oracle Business Intelligence Publisher OBIP
• Designed UI using MOD PL/SQL forms, JSP and servlets
• Worked on data export and import utilities using SQL Developer and TOAD
• Worked on various scheduled jobs using DBMS JOBS in Oracle 11g
• Experience in SQL query tuning and optimization of PL/SQL code for better performance
• Experience in relational databases normalization
• Experience in using TOAD, SQL Navigator, SQL Developer, Netbeans, Eclipse
• Experience in using Apache Tomcat, Apache Ant,
• Experience in writing java servlets for web applications using jdbc connectivity for Oracle 11g
• Knowledge of perl cgi scripts and linux shell scripts
• Involved in client side validations using javascript and AJAX, jquery scripts
• Experienced in writing automatic build scripts using ANT to deploy applications on dev, test and prod environments.
• Worked closely with Development/Functional/Network teams to resolve issues
• Knowledgeable in IT security continuous monitoring, procedures, policies, controls for network and software applications
• Installed, configured and maintained JIRA for the development and client users
• Complete software lifecycle experience in multi - tiered and multi-server application architecture using PL/SQL on UNIX/LINUX platforms
• Ability to understand complex business rules and translate into system design

TECHNICAL SKILLS:

Languages

SQL, PL/SQL, Java, C, PERL, XML, Bash, Korn Shell.

Databases

Oracle 9i/10g/11g, MySQL, SQL Server 2000/2005/2008

Software / Tools

Oracle SQL Developer, Oracle JDeveloper, TOAD, SQL Plus, SQL Navigator, SQL Loader, Oracle BI Publisher OBIP, Apache Lucene, Apache Ant, JDBC, Google Web Toolkit GWT, Oracle Web Toolkit OWT, Putty, Apache Tomcat, Eclipse, komodo edit, MS Visio, Export Import, Erwin, APEX, Data pump 10g, Explain plan, TKPROF, JIRA, Netbeans, TortoiseSVN, Beyond Compare, TK REQ

Operating Systems

Linux RHEL 5/6, Ubuntu 10.04/12/04, Unix, Sun Solaris, Windows Server 2003/2005, Windows 7/8.

Web Technologies

HTML, CSS, DHTML, Jquery, JavaScript, JSP/Servlets, MOD PL/SQL.

WORK Experience:

Confidential

Environment: Oracle 11g, JavaScript, JQuery, Oracle PL/SQL, Oracle SQL Loader,

Role: Application Developer

Responsibilities:

• Excellent communication skills as team member and great attention to detail to understand customer requirements
• Developed and designed user friendly UI interfaces according to the client requirements using JavaScript, html, PL/SQL packages and PL/SQL procedures, JSP, servlets.
• Created Tables and Queries, Packages, Stored Procedures in Oracle 11g using TOAD.
• Extensively involved in creating indexes, query tuning in writing inline Oracle SQL queries for better performance.
• Implemented cursor for loops, ref cursors for data management modules.
• Worked on data export and import wizards using SQL Developer and TOAD.
• Used DBMS JOBS for different scheduled jobs running at different times in Oracle 11g.
• Developed and written complex PL/SQL code for various search operations.
• Involved in connecting frontend JSP forms to access the Oracle 11g database.
• Implemented validations for various user entries in JSP forms.
• Worked on SQL Queries, stored procedures, functions, triggers, views and involved in developing workflow models for several projects.
• Responsible as JIRA administrator, workflows management, permission schemes for issue management in various projects.
• Involved in release and build processes of various java and perl cgi modules.
• Implemented Ant build files to automate build processes on dev, test and production environments.
• Knowledgeable in IT security continuous monitoring, procedures, policies, controls for network and software applications.
• Experienced in using version control systems exclusively using Subversion for code changes.
• Responsible for webmaster role to manage the content on
• Performed quality assurance of various software products in NGS as member of QA team.
• Involved in every stage of application development and gained valuable experience in full Software Development Life Cycle.

Confidential

Environment: Oracle 11g, JavaScript, JQuery, Oracle PL/SQL, Oracle SQL Loader,

Role: Oracle Developer

Responsibilities:

• Great attention to detail with customers to understand the application requirements, needs and objectives.
• Developed and designed user friendly UI interfaces according to the client requirements using JavaScript, html, PL/SQL packages and PL/SQL procedures.
• Created Tables and Queries, Packages, Stored Procedures in Oracle 11g using SQL Navigator.
• Extensively involved in creating indexes, sequences on tables and performed sql query tuning for better performance.
• Used various types of explicit cursors for complex data operations to display grid structure on mod pl/sql forms.
• Involved in connecting frontend mod PL/SQL forms to access the Oracle 11g database.
• Implemented user credential login functionality using PL/SQL procedures.
• Implemented client-side validations for various user entries in mod pl/sql forms.
• Implemented PL/SQL collections, associative arrays index by tables for creating mod pl/sql reports for patient data.
• Implemented autonomous transactions for logging activities.
• Implemented User defined exceptions without halting the programs.
• Implemented BULK COLLECT, cursor for loops, ref cursors for data management modules.
• Worked on data export and import wizards from SQL Navigator.
• Used DBMS JOBS for different scheduled jobs running at different times in Oracle 11g.
• Developed and written complex PL/SQL code for various search operations and used Oracle Web Tool Kit HTF, HTP, OWA UTIL packages and utilities.
• Worked on SQL Queries, stored procedures, functions, triggers, and views and involved in developing Data Models for several modules.
• Identified and resolved integration, functional and usability issues prior to deployment.
• Involved in generating various reports in MOD PL/SQL web reports according to various input parameters using various data models and SQL Queries.
• Involved in gathering client requirements in biweekly meetings and made presentation on developed modules
• Involved in every stage of application development.

Confidential

Environment: Oracle 11g, Java, JSP, JavaScript, Oracle PL/SQL, Oracle SQL

Role: Oracle Developer.

Responsibilities:

• Extensively involved in all stages of Software Development Life Cycle including design, implementation, testing, deployment and support.
• Developed and designed user friendly UI interfaces according to the client requirements using JavaScript, JSP, PL/SQL packages, and PL/SQL tables.
• Involved in connecting JSP and Mod PL/SQL frontend forms to access the Oracle 11g database.
• Writing Java classes for PDF file uploads and storing them into oracle database using BLOB's.
• Data migration between Oracle 10g and 11g environments using Export/import utility.
• Created Tables and Queries, Stored Procedures in Oracle 11g using TOAD 10.0.
• Used REF cursors to cursor queries based on User input via the web interface.
• Implemented BULK COLLECT, cursor for loops, ref cursors for retrieval data modules.
• Implemented JavaScript client-side validations for various user entries in mod pl/sql forms.
• Worked on loading external data files into Oracle 10g database using SQL Loader.
• Developed and written complex PL/SQL code for various search operations and used Oracle Web Tool Kit HTF, HTP, OWA UTIL packages and utilities.
• Worked on SQL Queries, stored procedures, functions, triggers, views and involved in developing Data Models for several modules.
• Involved in generating various reports in Oracle Business Intelligence Publisher OBIP according to various input parameters using various data models and SQL Queries.
• Involved in every stage of product development and maintenance of whole application.

Confidential

Environment: Oracle 10g, PERL, SQL Loader, Visual Studio 2008, ASP.NET, JavaScript, VSS,

Role: Database Analyst / Oracle DBA

Responsibilities:

• Created and modified UNIX shell scripts to monitor and administer oracle application instances.
• Created generic script to start and stop services.
• Involved in Logical and Physical Database design.
• Data migration between different Unix/Linux environments using Export/import utility.
• Extensively involved in writing shell scripts and perl scripts for document management.
• Worked on loading external data files into Oracle 10g database using SQL Loader.
• Responsible for database backup and recovery.
• Developed and written PL/SQL packages for various search operations.
• Involved in using TOAD to extract the data from SQL queries.
• Provide support during User Acceptance Testing UAT .
• Granted Permissions to End-Users according to their level of access to database Objects.
• Designed and developed Oracle forms applications to collect document Inventory information using Oracle forms 4.5
• Used Oracle Web Toolkit to create web based Inventory control system.
• Involved in implementation of crystal reports.
• Provide various reports of Student record data base using Oracle BI publisher.
• Provided on call support on weekends and after hours.
• Involved in every stage of product development and maintenance of whole application.

Confidential

Environment: Eclipse, My SQL 5, Apache Tomcat, Apache Lucene, Java, JSP

Role: Web Server Administrator/Research Assistant

Responsibilities:

• Involved in Full software development life cycle including design, development, implementation and analysis.
• Involved in writing Singleton, Factory and Facade design patterns.
• Designed Java application architecture and analyzed software development process and implemented alternative technologies.
• Created Java Server Pages with user friendly GUI.
• Responsible for writing JavaScript, HTML code for Java Server Pages.
• Wrote SQL queries for MySQL data base connectivity.
• Usedcore concepts like Collections, Auto-Boxing, Var-args.
• Wrote PL/SQL queries to fetch data from My SQL data base.
• Optimized PL/SQL queriesfor better retrieval time of search.
• Responsible for generating graphical data of the search results.
• Developed bar charts using Google Web Toolkit.
• Created technical design and analysis documentation.
• Implemented new concept of Indexing to enhance search performance.
• Involved in client side validations using JavaScript.
• Worked on variouscore classes of Apache Lucene, writing functions.
• Developed build.xml using Apache ANT for automating the software build process.
• Build various shell scripts in TC shell/kornshell to generate different search patterns for further analyses.
• Implemented AJAX tools for partial UI page refresh.
• Used Log4J to capture the log and runtime exceptions.
• Involved in the deployment of whole application.