SUMMARY:

• More than 16 years of Professional Experience as Sr. Oracle Application Developer/ PL/SQL Developer role.
• Worked on all phases of software development lifecycle (SDLC) as a Sr. Oracle Programmer Analyst /Sr. Oracle Developer and proficient in Requirement Study, Analysis, Database Design, Development, Integration, Implementation, Maintenance, Performance tuning, and System Integration Testing.
• Extensive experience in PL/SQL Stored Procedures, Functions, Packages, triggers and complex SQL to develop robust, reliable and high - performance solutions.
• Proficiency with development in Oracle Forms, Oracle Reports, Entity Relation Data Base Design, Data Modeling, Creation of Tables, Creating Primary& Foreign Keys, Views, Materialized Views.
• Extensive experience in creating and maintaining databases which includes configuration, query optimization and de-normalization
• Working with clients to identify system issues and make improvements for functionality changes.
• Worked with web technology, java, html5, style sheets, and ruby on rails, Sinatra frame works.
• Worked in Oracle E-Business suite R12, Oracle 11g, 10g, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers.
• Worked as Apps DBA in Enterprise Performance Archival Solutions using IBM OPTIM tool to archive periodical data and restore to cloud environment for future queries and purging from the production the archived data’s to improve the performance of the applications.
• Strong understanding of Oracle locking and transaction mechanisms in multi-session environments.
• Good understanding of SQL performance tuning techniques including query plan understanding and management, SQL tracing, DB stats, indexing techniques, using AWR reports.
• Experience with managing and resolving problems on production system.
• Experience with Database access methods and simple SQL constructs.
• Experience with ORM tools (Hibernate, JPA)
• Experience in Core Java, web service (RESTfulAPI’s/SOAP), XML, HTML web page application programs
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.
• Hands on experience to work with agile / scrum process.
• Worked on various reporting service tool like Micro-strategy, cypress, crystal reports, Business Intelligence, XML Publisher Reports.
• Self starter, highly motivated, technically sound, good team player, problem solver and quick learner. Ability to perform Confidential a high level, meet deadlines.
• Ability to communicate effectively and clearly between teams and resolve issues quickly.
• Strong Skills in SQL Queries.
• Expertise in Oracle tools like TOAD, to create stored procedures.
• Experience in Query Performance Tuning
• Writing Ad-hoc Reports to provide statistical information to the business.
• Strong Skills in PL/SQL Programming to maintain Entity Data Integrity and Referential Data Integrity by authoring Database Triggers, Stored Procedures and Functions.
• Expertise in Oracle tools like SQL*Loader, ETL, Export and Import.
• Strong working knowledge in all oracle objects like DB Links, Synonyms and Materialized Views
• Extensive experience in using Cursors, Ref-cursors, V arrays, nested tables and Dynamic SQL.
• Involved in creating and maintaining users, roles and granting and revoking privileges.
• Working efficiently with SQL and PLSQL tuning using explain-plans, indexes, hints and reusability.
• Strong Skills in Forms, Reports, BI Publisher Reports (DW) for ERP.
• Creation of Data Base, Data Analysis, Normalization, Table Design, Entity Relationship Modeling, maintain Entity Data Integrity and -Referential Data Integrity by authoring Database Triggers, Stored Procedures and Functions, Development, UA Testing, Implementation, Maintenance and Support for Large volume of metadata.
• Expertise in Oracle tools like SQL*Loader, ETL, informatica,Export and Import, TOAD, Forms 10g, Reports 10g.
• Strong working knowledge in all oracle objects like DB Links, Synonyms and Materialized Views
• Involved in creating and maintaining users, roles and granting and revoking privileges.
• Skills in making any kind of analytical, statistical, matrix reports.
• DBA skills to support the system in creating tables, roles, views, materialized views, indexes, primary &foreign keys.

TECHNICAL SKILLS:

• Oracle Developer (Forms and Reports)
• Oracle SQL and PL/SQL
• ETL, SQL Loader
• Oracle Database 8i
• Oracle Database 9i
• Oracle Database 10g
• Oracle Database 11g
• Oracle Database 12C
• Unix
• Ruby on Rails
• HTML,CSS, Javascript, MVC, Jquery, ActiveRecord,Rspec, Heroku, Bit Bucket, MySQL, SQLite3,Git, SVN, Stash8 months (academic)

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle Application Developer/ PL/SQL Developer

Responsibilities:

• Developed and maintained in-house front-back end applications using Oracle Forms 10G, Oracle Reports 6i, Oracle SQL, Oracle PL/SQL queries for Great Lake Gas Transmission and Northern Border & Bison Pipeline for NAESB 3.0/FERC 809 Projects.
• Developed and maintained back-end applications using PL/SQL packages, functions, procedures and triggers, shell script.
• Created web-deployed forms and reports for clients using Oracle Portal, ASP.NET, HTML and Java script embedded in PL/SQL, PL/SQL code calling Java APIs, Oracle Reports generated by Oracle Reports 6i and SQL*Plus.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Extensive use of Oracle materialized views for faster query performance.
• Experience in Core Java, web service (RESTfulAPI’s/SOAP), XML, HTML web page application programs
• Participated in agile / scrum meetings

Environment: Oracle 10g, Oracle Forms 10g, Reports 6i, TOAD, Informatica, PL/SQL cartridge, Java, Java script, HTML..ASP

Confidential, CA

Sr. Oracle Application Developer/PL/SQL Developer

Responsibilities:

• Developed and maintained applications using Oracle Forms, Oracle Reports, Toad, Oracle SQL, PL/SQL packages, functions, procedures and triggers, shell script.
• Created web-deployed forms and reports for clients using Oracle Portal, ASP.NET, HTML and Java script embedded in PL/SQL, PL/SQL code calling Java APIs, Oracle Reports generated by Oracle Reports 9i and SQL*Plus.
• Wrote shell scripts that emailed SQL reports to clients.
• Populate Data to Database using Data Loader, ETL Tools.
• Involved in production support for the entire decision support team, which involved working on ticket queues and on-call support for most of existing production systems.
• Use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Developed SQL Loader scripts for bulk data loads as part of daily data extraction
• Experience performing data migration using data loader, ETL tools, Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Experience in Core Java, web service (RESTful API’s/SOAP), XML, HTML web page application programs
• Participated in agile / scrum meetings.
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.
• Participated in a 24x7 on-call production support rotation.

Environment: Oracle 9i, putty telnet, Oracle Forms 9i, Reports 9i, TOAD,PL/SQL Developer, Java, Java script, HTML

Confidential, Mountain View, CA

Sr. Oracle Application Developer/ PL/SQL Developer

Responsibilities:

• Involved in production support for the entire decision support team, which involved working on ticket queues and on-call support for most of existing production systems.
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.
• Responsible for creating and modifying the PL/SQL procedures, functions, triggers according to the business requirement - new tickets (enhancements).
• Populate Data to Database using Data Loader, ETL Tools.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors.
• Developed SQL Loader scripts for bulk data loads as part of daily data extraction.
• Responsible for creating indexes to increase performance and complex SQL queries for joining multiple tables.
• Tuned and Optimized the SQL statements to improve the performance of the application using Explain Plan and SQL trace utilities.
• Agile environment, with constantly shifting priorities and business needs. Provided best practices in database related issues to application team.
• Responsible in developing Reports as part as new enhancement.
• Experience performing data migration using data loader, ETL tools, Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Involved in writing Design Requirement and BRD.
• Involved in writing Test documentation and performing unit, integration tests for the same modules in the existing application.

Environment: Oracle 10g, PL/SQL Developer, TOAD, SQL*Plus, Oracle Report Developer 10g, Oracle Application Server, Java, JSP.

Confidential, BOTHELL WA

Oracle Application Database Administrator

Responsibilities:

• Implement Enterprise Data Management using IBM Info Sphere Optim tool for Data Archive (Performance Archive) and Data Purge.
• Database population using SQL*Loader.
• Data population using IBM Websphere DataStage
• Experience performing data migration using data loader, ETL tools, Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Created the lookup tables used to mask the actual table or file with Optim
• Designed workflows to do the Extract, Transformation and Load of data.
• Create OPTIM Environments, Directories and DB Aliases for Oracle.
• Configure Optim Archive / TDM environment in both windows and UNIX environment
• Performance tuning and benchmarking SQL Queries
• Convert flat files and csv files into relational model to use with Optim
• Create and test Optim extract, archive, convert, insert jobs
• Responsible for scheduling Optim extract and load jobs
• Installed and maintain Optim, Optim connect and Discovery Center in production and QA environments.
• Create Optim access definitions, archive requests, columns mappings, table mappings and apply transformation functions .
• Implemented Test Data Management and Data sub setting services for Oracle Database.
• Manage RAC environment for Day to Day Database administrator, Performance Tuning.
• Refreshed development and test databases with production data.
• Expertise in Oracle Enterprise Manager (OEM), TOAD
• Managed application support, maintenance, created logical and physical data layout, table re-organization, installing patches, upgrades, monitoring and tuning of databases.
• Create and maintain materialized views.
• Worked in Oracle E-Business suite R12, Oracle 11g, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers
• Experience to define security role profiles, responsibilities to business groups, providing accessibility levels to the users.
• Experience in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN.
• Analyzed database performance and tuned database, resulted in improved performance of system
• Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
• Implemented backup and recovery procedures; established disaster recovery and high availability plans.
• Knowledge in automating unix jobs using UC4 automation tool.

Environment: Production Linux servers, Stage Linux Servers, Windows Servers, RDBMS - ERP System, Teradata, Enterprise Archive Systems, Optim Tool, Webtool. Flat files, Oracle 10g/11g, Oracle SQL, PL/SQL, TOAD

Confidential

Sr. Oracle Application Analyst / PL/SQL Developer

Technology: Oracle database and Oracle Developer tools

Responsibilities:

• Requirements gathering, Analyzing, Designing and developing the application.
• Played a major role in DB Design and creation of objects both Confidential the clinic database and central database.
• Writing Unix Shell Scripts.
• Experience performing data migration using data loader, ETL tools, Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Extensive use of Oracle materialized views for faster query performance.
• Pl/SQL scripting to synchronize the data between the clinic database and central database.
• Managed a team of 4 to develop and rollout this application to all the centers.
• Scheduled a Train-the-Trainers Program to train Doctors, Nurses, Health Inspectors
• Successfully rolled out the application with all the necessary objects/scripts, as indicated in point.3, in place.
• Worked in Oracle E-Business suite R12, 10g, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers
• Experience to define security system role profiles, responsibilities to business groups, providing accessibility levels to the users.

Environment: EBS Suite R12, Oracle 10g, Oracle8i, SQL, PL/SQL, SQL* Plus, SQL * Loader, Forms 10g/6i, Reports 10g/6i, TOAD, DBA, Unix, Linux.

Confidential

Sr. Oracle Application/ PL/SQL Developer

Responsibilities:

• Requirements gathering, Analyzing, Designing and developing the application.
• Played a major role in DB Design and creation of objects both Confidential the Kuwait schema as well as Jordan, Oman, Lebanon database.
• Developed Forms& Reports by Developer Tools, BI Publisher Reports, Micro strategy Reports, Ad-hoc Excel / PDF Reports.
• Created database objects like tables, views, procedures, packages using Oracle tools like TOAD, SQL Loader, SQL, and PL/SQL.
• Developed complex queries, functions, procedures and triggers using Pl/Sql.
• Created various SQL and PL/SQL scripts for verification of the required functionalities used in forms, reports.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Experience performing data migration using data loader, ETL tools, Informatica.
• Experience with UML, Use cases, Asset Management Tool (TFS)
• Experience in Core Java, web service (RESTful API’s/SOAP), XML, HTML web page application programs
• Involved in the preparation of user Requirements and functional specification of the systems.
• Run Batch files for loading database tables from flat files using SQL loader.
• Created indexes on tables and Optimizing Stored Procedure queries.
• Involved in customization of Oracle Forms 4.5/6i/8i/9i/10g/11g, Oracle Reports versions 2.5/6i,8i/9i/10g/11g.
• Customization of Business Intelligence Reports to RMS, SIM, POS dashboards.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance, WritingUNIX Shell Scripts.
• Migration of Oracle Forms 6i to Forms 8i/9i/10g/11g, Reports 6i to Reports 8i/9i/10g/11g.
• Worked in Oracle E-Business suite R12, Oracle 11g, 10g, PL/SQL, SQL, TOAD, UNIX, Linux, Sun Solaris, Windows servers.
• Experience to define security system role profiles, responsibilities to business groups, providing table data accessibility levels to the users.

Environment: Oracle EBS Suite, SCMADS Application Package, RDBMS, RETEK Retail Merchandise System, Point of Sale System, Store Inventory Management System, Relational Data Warehouse, Flat files, Oracle 6i/ Oracle 8i/ Oracle 9i/ Oracle 10g/ Oracle 11g, E-Business suite R12, TOAD, Oracle SQL, PL/SQL, Oracle Forms 4.5, Forms 6i, Forms 8i, Forms 9i, Forms 10g, Forms 11g, Oracle Reports 2.5, Reports 6i, Reports9i, Reports 10g, Reports 11g/ BI Publisher Desktop, Micro strategy Desktop, Unix, Linux.