SUMMARY:

• 10+ years of experience as Senior Oracle developer, Involved in complete SDLC in terms of architecture, analysis, design, development, testing, implementation and maintenance phases of application software in the Client/Server and web based environments.
• Good Understanding in Oracle Architecture, experience in database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers) and built - in Oracle packages.
• Strong experience in Database Objects (Tables, Views, and Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database Links and Types) and Bulk collects/Inserts, Cursors, Analytical functions, Dynamic SQL, Exception Handling.
• Experience in usage of Oracle Developer Suite (Oracle Forms, Reports) for developing end user screens and reports.
• Expert in developing scripts to create and modify Database objects like Tables, Indexes, Views, synonyms, sequences etc.
• Developed/customized UNIX shell scripts to automate routine DBA tasks.
• Used SQL*Loader, PL/SQL procedures, Import/Export Wizard to facilitate data import/export from staging tables to production tables.
• Possess good development skills in developing web based applications especially using APEX. Worked in all phases of APEX application development including exporting the application into different environments (dev, uat and PROD ).
• Experience in providing the Impact analysis on application based enhancements proposed by Functional team.
• Experience in providing technical support and preparing technical documents for the end user.
• Assisted in User Acceptance Testing including data validation, data integrity, functional testing, integration testing, regression testing and system testing.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS:

Database: Oracle 9i, 11g, 12c and SQL Server

Tools: SQL*Plus, SQL*Loader, TOAD, SQL Developer, APEX (3.2/4.1& 5).

GUIs: Developer Suite (Forms 6i/11g/12c, Reports 6i/11g/12c)

Operating Systems: Windows NT/XP/2K/2003

Languages: SQL, PL/SQL, UNIX Shell programming

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle Consultant

Responsibilities:

• Handling modules related to project development for reverse logistics application that includes analyzing, developing, debugging, unit testing and deployment.
• Design and develop application code in Oracle PL/SQL spread across multiple databases and schemas.
• Front end application developed and maintained in Forms and Reports 6i migrating to 11g and now to 12c.
• Maintained and developed APEX application for facilities which require intern solutions.
• Store data in RDBMS from orders in XML using DBMS XMLDOM and upgraded to XML Tables for parsing.
• Created batch job for uploading PDF files from application server and store in DB and display the same on Form 11g using WEB UTIL.
• Developed complex front end forms using stacks, tabs and trees.
• Worked with wide range of enhancements for client in all facilities.
• Monitor DB for query overheads reported by DBA’s and fine tune to optimize performance.
• Identified unused objects in application and data base to perform cleanup for better transparency and performance.
• Worked extensively with barcode reports and dynamic report objects.
• Detecting and fixing application buds reported by users/QA resources related to live systems or new enhancements.
• Documented changes related to application design, new features and modified systems stored in online repository access centrally.

Oracle Developer

Environnent: Oracle 10g, 11g, SQL, PL/SQL, APEX 3.2/4.1, SQL * Plus, SQL Navigator, TOAD, Subversion, Microsoft Visio, Unix, Shell Scripting, Microsoft Office

Responsibilities:

• Worked on creation of a Utility in PL/SQL for centralization of the Email Management system which is used for monitoring the email traffic from all the applications and generating the weekly reports.
• Involved in the code review and documentation of best practices which are like creating database, developing PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.
• Worked as a team member in migration of DBMS jobs and CRON jobs into Control-M job scheduling tool.
• Worked on ETL (Extraction, transformation and loading) using PL/SQL to Extract, transform and load data into data warehouse (RDW System).
• Maintained and enhanced custom ETL code using PL/SQL, Oracle SQL.
• Responsible for UNIX shell scripting for creating new Programs and utilities, updating existing capability as per business request.
• Identifying and fixing the production support issues for various applications.
• Improved the existing PL/SQL code for an application to handle large emails.
• Written complex SQL statements using joins, sub queries, and correlated sub queries.
• Created user registration/verification process which includes validations on user entry, sending automated emails to concerned parties.
• Used PL/SQL to drive the functionality of APEX form inputs.
• Worked on the documentation of remediation plans for all the APEX applications.

Oracle Developer

Environnent: Oracle 10g, 11g, SQL, PL/SQL, XML, APEX 3.2/4.1, HTML, SQL * Plus, SQL Navigator, TOAD, Subversion, Microsoft Visio, Unix, Shell Scripting, Microsoft Office

Responsibilities:

• Gathered requirements from Business partners and wrote technical designs.
• Created Stored Procedures for data transformation purpose. Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Analyzed code and documented technical designs, data model diagrams, process flow diagrams, data flow diagrams as per industry documentation standards.
• Customized Auto Cash Rules Report, Transaction Detail Reports using Reports 10g.
• Design and developed many complex reports in Salary, Overtime, Bonus and other benefit by using reports 10g.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links.
• Used JavaScript for certain page validations and for custom functionality.
• Developed custom APEX authentication schema and authorization schemas for different user groups.
• Used java script validations to load validated data into database after logging appropriate error, warning and informational messages.
• Designed Oracle Objects including Triggers, Stored Procedures, and Sequences that helped in automating various operations in the database.
• Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables.

Oracle Production Support

Environment: Oracle 10g, Toad, Oracle Developer Suite, Pl/SQL developer, SQL

Responsibilities:

• Reviewed functional specs for phase I of the project and build technical specs accordingly.
• Create new and/or modify existing Oracle PL/SQL stored packages and procedures using multiple databases to feed the data into the Crystal Reports more efficiently. Strong PL/SQL skills are required.
• Used advanced SQL features like Inline views, Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and analytical functions
• Enhance performance of existing processes by changing record-by-record processing into bulk processing using BULK COLLECT and FORALL statements.
• Developed Custom Reports according to the client and Modified existing reports according to the changes of requirements.
• Develop core validation packages and persist layer packages using dynamic SQL to validate and load data from XML and CSV files.
• Created various database objects like tables, views, sequences, functions, and indexes
• Responsible for coding, debugging, and trouble-shooting.
• Responsible for application unit testing, Production Support, Version Control, Production Staging, implementation, Planning and Training

Oracle PL/SQL & APEX Developer

Environment: Oracle 10g, Oracle APEX 3.1.1, 3.2, SQL, PL/SQL, TOAD, MS-Visio

Responsibilities:

• Involved in functional and technical requirement gathering.
• Was hired as a the only APEX developer for the project that includes all data collection (Oracle 11g), documentation (APEX architecture, CONOPS, Technical requirements), build an application for the department child nutrition that shows custom reports, student information (FS benefits) and admin tool for the school administrators to add/drop/edit student information, unit testing,
• Created custom and interactive reports enabling the user for various print and download options on the data which has been set for batch matching process.
• Created custom side bars for easy navigation, java script validations on any delete and edit actions, LOV’s and bread crumbs.
• Created search filed to search in multiple columns by combining columns in one Index.
• Created dynamic regions based on different authorizations with the help of function returning a SQL.
• Unit tested and deployed the application using application packager.

Developer/Analyst

Environment: Oracle 9i, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, TOAD, APEX 2.2, UNIX, ETL

Responsibilities:

• Involved in SDLC i.e. plan and coordinate database design, development, implementation, maintenance, and user support of clinical systems using Oracle 9i
• Programmed, tested, and documented databases in accordance with programming standards and validation procedures using triggers and stored procedures
• Briefly used Power Center/Mart to design multiple mappings with embedded business logic.
• Assisted APEX DBA in creating users, managing work spaces and monitor user activities
• Created USERS and WORKSPACES in the application and managed the workspace.
• Interacted with end users and direct customers in requirement gathering process
• Involved in extracting and loading data from various Inventory platforms to Oracle using Integrator (ETL)
• Developed user friendly GUI using Oracle Developer 2000 Forms and Reports
• Generated reports like list of the vendors, their supply schedule, actual deliveries and Inventory level to be maintained periodically using Oracle Reports