PROFESSIONAL SUMMARY:

• Around 7 years of extensive experience as an Oracle Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS), Support and Migrations projects on different domains.
• Expertise in Software Development Life Cycle (SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms11g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Strong experience Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Worked with Arrays, Records, Dynamic SQL and Exception Handling.
• Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, SQL trace and TKPROF.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export-Import Utilities and SQL*Loader.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Experience in UNIX Shell Scripts using Korn shell for executing PL/SQL code and performing other activities in UNIX.
• Prepare/Maintain documentation on all aspects of ETL processes, definitions and mappings to support knowledge transfer to other team members.
• Exceptional experience in dealing with various databases like Oracle, DB2, SQL Server, MS Access, and Flat Files.
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE.
• Knowledge of Principles of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
• Highly organized and efficient to prioritize and manage multiple tasks.
• Proven ability to work efficiently in both independent and team work environments.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/10g/9i,, SQL Server 2005/2007, MS Access, DB2

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, .NET, XML, UNIX Shell Scripting, Perl Scripting.

Oracle Tools/ GUI: Oracle Forms and Reports 6i/9i/10g/11g, Discoverer 4i/9i/10g

Tools: TOAD, SQL DEVELOPER, PLSQL DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, UNIX/LINUX Utilities.

Version Control and Ticketing: SVN, PVCS, HP Service Manager.

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, Java Script, CSS, XML.

Windows Family, MS: DOS, Unix, Solaris

WORK EXPERIENCE:

Confidential, Malvern, PA

Oracle Developer

Responsibilities:

• Collaborated with Business Analysts and Business Objects team to gather requirements from market makers i.e. vendor about adding a new intermediary layer between ROM application and Execution Station for the orders placed through Confidential and translate the requirement into technical specifications.
• Created new stored procedures that are used by upstream application to send data to ROM database orders table and route them to different vendors by checking business rules through Routing Engine.
• Designed and Developed UNIX Shell Scripts to receive data from Enterprise DB whether an account is self-managed or managed by personal Advisory services of Confidential and store the data into ROM database through batch processing and generating reports which will be useful for business and ITS.
• Created Package and Tables that is called inside UNIX shell script for Inserting data into staging table and updating the main account table and also maintaining the history for account table.
• Created, Scheduled & Monitored control-m job with dependency on mainframe job that will send file every 30 mins and UNIX job will read that file and updates the main account table.
• Provided support to product owner ITS with Adhoc queries and creating reports for day to day orders that were executed per sec.
• Created relevant staging and target tables to load the CSV files, identified the business validation rules and SQL loader script generator application using UNIX shell scripting and PL/SQL.
• Worked on SQL* Loader to load data from flat files obtained from various files.
• Created Portals for EMM on Inquisient to filter the data for users easily using HTML & JAVA SCRIPT.
• Worked on Performance Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Worked on Upgrading of oracle databases from 11g to 12C and implemented oracle 12c standby database.
• Developed both inbound and outbound interfaces to load data into targeted database and extract data from database to flat files.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, Confidential .
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Participating in Daily status meetings to update the status of work.
• Fixing bugs, data quality monitoring and involving in production support by efficiently debugging the production issues.
• Involved in the On-Call Support.

Environment: Oracle Database 12c/11g, Windows 8, UNIX, Putty, Control-M, SQL Developer, Toad, XML, SQL, PLSQL, Unix Scripting, HP Quality Center, HTML.

Confidential, Richardson, TX

PL/SQL Developer

Responsibilities:

• Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.
• Collaborated with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.
• Coordinated with the front-end design team to provide them with the necessary stored Procedures and packages and the necessary insight into the data.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.
• Worked on Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
• Extensive querying using SQL*plus / TOAD to monitor quality and integrity of data.
• Extensively worked in performance tuning of programs, ETL procedures and processes and used debugger to troubleshoot logical errors.
• Proficient in advance features of Oracle 11g for PL/SQL programming like using cursor, variables, Reference cursors, Varray’s, nested tables, Dynamic SQL and Bulk Binds.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Participated in Daily status meetings to update the status of work.
• Worked on Scheduler to schedule Jobs/Packages for running.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Proactive tuning of SQL/PLSQL issues.
• Involved in Code Reviews and test Reviews and participated in Quality Audits.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands.
• Worked on job scheduling using DBMS SCHEDULER.
• Provided support to the User/Customer incase if they have any questions on running the Reports.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked extensively on different types of transformations like expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator, Normalizer and joiner.
• Involved in 24/7 production support as per the need basis.

Environment: Oracle Database 10g/11g, Windows 8, PL/SQL Developer, Toad, XML, SQL, PLSQL, UNIX Shell Scripting.

Confidential, Monroeville, PA

Oracle Developer

Responsibilities:

• Analyze the Business Requirements (BRD) and convert them into Technical Specification (Technical Design Document).
• Worked with Business Analysts, Business users, IT leads and system Analysts to understand the requirements and translate the requirement into technical specifications.
• Involved in all phases of Design, code, test, and debug programs of varying levels of complexity .
• Prepared technical documentation, create test plans and perform testing.
• Created PL/SQL Stored Procedures, Functions, Packages and Triggers, extensively Used cursors, ref cursors, User defined object types, Records in PL/SQL Programming.
• Expertise in developing Forms and Reports and developed PL/SQL Packages, Stored procedures, Triggers, Tables, joins, Indexes and sequences.
• Involved in writing SQL queries, PL/SQL programming and created new Packages, Procedures and modified existing procedure and queries using TOAD.
• Involved in the generation of User Interface using oracle forms by extensively creating forms as per the client requirements.
• Developed and customized existing reports and forms as per client specific requirements using Oracle Reports and Forms Builder 11g.
• Involved in Updating PL/SQL Functions, Procedures, and Packages, Cursors, for validation and loading of data based on current requirement.
• Involved in Unit testing, integration testing and supporting testing during QA and UAT phase.
• Customized Forms and Reports by changing size of the fields adding new fields into the display, changing the layout of the Report and forms appropriate.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 11g.
• 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.
• Created new reports for generating automatic weekly/Monthly Reports as per user requirement in production Support.
• Fixing bugs, Client Feeds setup and maintenance, Data loads and Data migration support.
• Involved in Unit testing, code reviewing and preparing design specification document.
• Analyzing the issues, performing extensive defect fixing in Production support through HP Service Manager.
• Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
• Debugging and Fixing Production Data.
• Involved in production release and support of PL/SQL , Oracle Forms and Reports .

Environment: Oracle Database 11g/12c, Windows 8, UNIX, SQL Developer, Toad, XML, SQL, PLSQL, Unix Shell Scripting, Forms Builder 11g, Reports builder.

Confidential

Software Engineer

Roles & Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.
• Used Materialized views in places where the data does not change very frequently.
• Developed UNIX shell scripts for batch jobs.
• Designed and developed Oracle Monthly Reports.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Tuned Procedures/SQL Queries for maximum efficient in various databased using Oracle hints for rule based optimization.
• Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Wrote Queries to retrieve data in XML format from the tables.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.
• Work collaboratively with Development, Application support and Quality Assurance teams.

Environment: Oracle Database 9i, PL/SQL Developer, TOAD, Forms Builder 6i, Reports Builder 6i Workflow Builder 2.6.3.5, PVCS.