SUMMARY

• 13+ years of Professional Experience as Sr. Analyst Programmer in Oracle Application Development.
• 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.
• Writing PL/SQL Stored Procedures, Functions, Packages and triggers.
• Proficiency with development in Oracle Forms, Oracle Reports, Entity Relation Data Base Design, 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 frame work.
• 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.
• Hands on experience to work with agile / scrum process.
• Worked on various reporting service tool like Micro-strategy, 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 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, 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, 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
• Oracle Database 8i
• Oracle Database 9i
• Oracle Database 10g
• Oracle Database 11g
• Unix
• Ruby on Rails
• HTML
• CSS
• Java script
• MVC
• J query
• Active Record
• Rspec
• Heroku
• Bit Bucket
• MySQL
• SQLite3
• Git
• SVN
• Stash

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr. Oracle Application Developer

Responsibilities:

• Developed and maintained in-house front-back end applications using Oracle Forms 10G, Oracle Reports 10G, 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 reports for clients using Oracle Portal, ASP.NET, HTML and Java script embedded in PL/SQL, Oracle Reports generated by Oracle Reports 9i and SQL*Plus.
• Created web-deployed forms for clients using Oracle Portal, HTML and Java script embedded in PL/SQL, ASP.net, PL/SQL code calling Java APIs.
• Responsible for creating and modifying the PL/SQL procedures, functions, triggers according to the business requirement - new tickets (enhancements).
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• 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.
• Participated in agile / scrum meetings

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

Confidential, CA

Sr. Oracle Application Developer

Responsibilities:

• Developed and maintained in-house front-end applications using Oracle Forms, Oracle Reports, Oracle SQL, OraclePL/SQL.
• Developed and maintained back-end applications using PL/SQL packages, functions, procedures and triggers, shell script.
• Created web-deployed reports for clients using Oracle Portal, HTML and Java script embedded in PL/SQL, Excel Reports generated by Oracle Reports 9i and SQL*Plus.
• Created web-deployed forms for clients using Oracle Portal, HTML and Java script embedded in PL/SQL, CGI-Perl, PL/SQL code calling Java APIs.
• Wrote shell scripts that emailed SQL reports to clients.
• Optimized existing front-end and back-end scripts.
• 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.
• Responsible for creating and modifying the PL/SQL procedures, functions, triggers according to the business requirement - new tickets (enhancements).
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• 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.
• Developed SQL Loader scripts for bulk data loads as part of daily data extraction
• Participated in agile / scrum meetings
• Participated in a 24x7 on-call production support rotation.

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

Confidential, Mountain View, CA

Sr. Oracle Application 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.
• Responsible for creating and modifying the PL/SQL procedures, functions, triggers according to the business requirement - new tickets (enhancements).
• Extensive use of PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• 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.
• 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.
• 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

Application Database Administrator

Responsibilities:

• Worked in 24x7 production environment and provided on-call and day-to-day support.
• Implement Enterprise Data Management using IBM Info Sphere Optim tool for Data Archive (Performance Archive) and Data Purge.
• Database population using SQL*Loader.
• 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.
• 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, Web tool. Flat files, Oracle 10g/11g, Oracle SQL, PL/SQL, TOAD

Confidential

Sr. PROGRAMMER ANALYST / DBA

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.
• 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.

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

Confidential

Sr. PROGRAMMER ANALYST /DBA

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.
• 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, Writing UNIX Shell Scripts.
• Migration of Oracle Forms 6i to Forms 8i/9i/10g/11g, Reports 6i to Reports 8i/9i/10g/11g.

Environment: SCMADS Application Package, RDBMS, RETEK Retail Merchandise System, Point of Sale System, Store Inventory Management System, Relational Data Warehouse, Flat files, Oracle 6i/ 8i/ 9i/10g/11g, 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.