SUMMARY

• Over 7+ years of IT experience as an Oracle PL/SQL Developer in Analysis and Implementation of Business Applications using Oracle Relational Database Management System Programming experience in Oracle 11g, 10g, 9i, 8i, SQL, PL/SQL and Performance tuning.
• Extensive work experience in Client - Server application development using Oracle 11g/10g/9i/8i, Forms 9i/6i, Reports 10g/9i/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Discoverer 9.1, Oracle Import and Export Utilities.
• Used Oracle Apex to design Web pages, Forms and Reports
• Experience with LOB datatypes by working on large blocks of data.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Worked as ADBA having experience in implementation and maintenance of database design, creation of database objects, Procedures, functions and triggers.
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through WSDL.
• Created BI reports using Oracle APEX
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experience in Financial Analysis and Financial Reporting.
• Expertise skills in using the tools TOAD 9.0.1, SQL * Loader, Oracle SQL Developer
• Data Transformation using Informatica.
• Designed and developed custom built applications using different Oracle products
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation and Data retrieval module documentation
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTP applications.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms Reports and working in an AGILE team .
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Extensive experience in using Cursors and Ref-cursors for processing of data .
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V-arrays, Records and Types.
• Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
• Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
• Extensive usage of Oracle collections and standard API’s like DBMS LOB, UTL FILE etc for business logic in user defined API’s.
• Expertise in dealing with complex data models and object relational database mapping, while producing complex reports
• Good Exposure to UNIX shell scripting.
• Expertise in developing outbound and inbound interfaces.
• Hands on experience in Data migration (ETL) across different databases via SQL scripts.
• Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
• Experience in requirement gathering, gap-analysis and solution design.
• Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
• Hands on experience as support engineer in a production support environment.
• Thorough understanding and exposure to software lifecycle development in both waterfall and agile methodologies.
• Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
• Great team player and ability to work collaboratively and independently as required.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows

Database: Oracle 9i/10g/11g, MS SQL Server and MS Access

Tools: Oracle APEX, SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i, Erwin r7.1/7.2

ERP: Oracle Applications R12.

Languages: SQL, PL/SQL, JAVA, HTML, XML, PERL 5.8 and shell scripting

Tracker Apps: BMC Remedy, BugZilla

Version control: PVCS

Office Tools: MS Office and Generic text editors.

PROFESSIONAL EXPERIENCE

Confidential, Long Island, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved inOracle development (Data Base) by creating OraclePL/SQL Functions, StoredProcedures, Triggers, Packages, Recordsand Collections.
• Created .SQL scripts to handle new processes.
• Extensively worked in data transaction, transformation, loading data from various sources like Oracle, SQL server and Flat files.
• Worked in creating various critical business reports like describing the financial status of the company
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through WSDL.
• Developed Perl scripts to automate frequent reports for the users
• Developed wrapper scripts in Unix shell script for the AUTOSYS batch jobs
• Worked as ADBA having experience in implementation and maintenance of database design, creation of database objects, Procedures, functions and triggers.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Used to monitor Application related jobs and data replication activities
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• CreatedRecords, Tables, Objects, Collections, Views,Materialized viewsand Global temporary tables(Nested Tables and Varrays), and performed Error Handling.
• Extensively usedCursors, Ref Cursors, Dynamic SQL and Functions.
• Participated inPerformance TuningusingExplain Plan.
• Created dashboard report using ORACLE APEX
• Designed and developed custom built applications using different Oracle products
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation and Data retrieval module documentation
• Application framework design with respect to convenience of the end user
• Application diagnosis and performance tuning and Generating reports for clients
• Used HINTS to improve performance of the SQL
• Involved in development of process usingSQL* LOADER, PL/SQL Package.
• Runbatch jobsfor loading database tables fromFlat Files using SQL*Loader
• Extensively used TOAD, SQL PLUS, SQL Developer and PLSQL developer for programming purposes.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Created numerous forms as in process for application development.
• Designed CUSTOM forms and reports in order to meet the Business requirements.
• Fixed Bugs during development/testing and Production phases.
• CreatedUNIX Shell scriptsfor Batch processing and job scheduling.
• Demand forecasting and workforce scheduling has been done by using Click.
• Fixed errors ad hoc reports using Discoverer 10g.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values usingDiscoverer 10g.
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved indatabase modelingand database design
• Involved in interacting with the end-user (client) togather business requirements.
• Involved inTechnical Documentation,Unit test,Integration Testand writing the Test plan.
• Involved in 24/7 on call production support.
• Used Team tracker to track development progress.
• Used PVCS Serena for Version Management.
• Used Toad Comparison Utility for identifying the changes in packages, procedures.
• Used Forms Compare tool to compare the difference between forms.

Environment:, Oracle 11g (SQL, PL/SQL), Forms 10g, Reports 10g, SQL *Loader, Toad, Perl Scripting, Unix Scripts, HTML.

Confidential, Hopewell, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in requirements analysis, development, technical requirement specification, database design and testing phase of the project.
• Extensive work experience in Client-Server application development using Oracle 11g/10g/9i/8i, Forms 9i/6i, Reports 10g/9i/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Discoverer 9.1, Oracle Import and Export Utilities.
• Responded to ad hoc report/information requests from customers within given time.
• Developed Perl and Shell scripts for upload of data feed into database
• Developed reports in Perl for our end users
• Interacted with various cross functional application teams and shared perspective for change request management and areas of improvement in future releases.
• Worked on developing the database objects i.e., developed scripts for table creation, views, indexes, sequences, materialized views, nested tables, user defined types, bulk collect in oracle collection, Procedures, Packages and functions.
• Wrote complex SQL statements using joins, sub queries, Hierarchical Queries, inline views and oracle analytical functions and Aggregate Functions.
• Transform and load of source data into Oracle database usingOracle external tablesand PL/SQL stored procedures.
• Modify existing scripts to createMaterialized Viewsof data merged from multiple staging tables.
• Authored PL/SQL API’s for CUD (create, update, delete) matrix for various tables and additional business logic.
• Defined ref cursors which would be called from UI.
• Created Users, Admins accounts for team mates, Oracle Apex Applications from Scratch.
• Created sign in and signup process for the user login and Custom authorization and authentication for the application.
• Created documentation, design and implemented rich user interfaces using Oracle Apex and Created Different Themes using JQuery template.
• Used Collection, Dynamic actions, different Plug-in, notifications for extra features and more functionality.
• Create database triggers for automatic data validation and audit mechanism.
• Performed one time seed data setup by collecting information from various in house applications using SQL*Loader.
• Created different database indexes like B-Tree index, Bitmap (Non Unique) and function based indexes in the new data model.
• Performed PLSQL tuning using BULK COLLECTIONS, Optimizer hints, Histograms, TKPROF, Explain Plan, PLSQL Profiling.
• Automate data management and reporting processes.
• Performed unit anduser acceptancetesting.
• Generate, Review andAnalyze Explain Plans.
• Performed data backup usingimporting,exporting, and linking to various data systems.
• CreatedSQL*Loaderscripts to load data into the temporary tables.
• Worked with internal and external IT SOX compliance team and provided requested data for metrics and compliance needs.
• Gatekeeper for Quality initiatives with migration team to ensure that code is “Production Ready”.

Environment: Oracle Forms 10g, Reports 10g, Oracle 11g, Oracle Apex, PL/SQL, SQL, XML, Ant, Perl Scripting, Shell Script, UNIX and Windows.

Confidential, Newark, DE.

Oracle PL/SQL Developer

Responsibilities:

• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Extensive work experience in Client-Server application development using Oracle 11g/10g/9i/8i, Forms 9i/6i, Reports 10g/9i/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Discoverer 9.1, Oracle Import and Export Utilities
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• Used Materialized View and refresh Process to provide data to downstream Application.
• Developed Oracle PL/SQL code based on requests raised by changes in business logic, norms and standards
• Developed PL/SQL stored procedures & functions using REF cursors & collections.
• Involved in creating Pseudo code documents for writing stored procedures.
• Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
• Involved in writing CTL files (control files) for SQL*Loader to load the policy data from Flat files in to oracle tables.
• Performed SQL tuning using Auto Trace, Explain Plan, and Hints.
• Involved in Importing and exporting the Tables, Users and Schemas.
• Involved in migrating from mainframes to oracle 10g.
• Designed the queues and their underlying queue table using an object type implementation in order to pass XML messages

Environment: Oracle 10g (SQL, PL/SQL), Forms 10g, Reports 10g, SQL *Loader, Toad, Perl Scripts, HTML and Linux.

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Extensively used sub queries and joins while writing stored procedures.
• Involved in extensive coding using Oracle PL/SQL.
• Used Oracle Forms 10g to design and develop the interface for the system.
• Created Packages to automate transactions from the Oracle Forms.
• Designed, developed various reports using Reports 10g.
• Tuned and Optimized the SQL statements using Explain Plan and SQL trace utilities.
• Created Shell scripts to automate the loading of data from Text files to Oracle tables.
• Used bulk collections for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• SQL*Loader was used to load the data from the flat files to database tables.
• Developed batch jobs, shell scripts to automate file transfers, data cleansing, loading and final data processing.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Used UTL File Packages to Load data from Excel Sheet to Oracle tables.
• Performed the unit testing for procedures, functions and packages.

Environment: Oracle 10g, Oracle Enterprise manager, UNIX Shell Scripting, SQL, PL/SQL, TOAD, SQL* Loader.

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Materialized Views, Triggers, Sequences, Collections.
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data.
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
• Interacted with clients in remote locations to verify customer requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in full project life cycle like Designed, developed, implemented, maintained and tested the application.
• Ensure conformance to code standards and documentation requirements.
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures.
• Developed Triggers to enforce complex business rules and to audit changes to data.
• Created database links to connect remote database.
• Create temporary table in a Stored Procedures.
• Tuned SQL statements and Procedures using Explain Plan and TKPROF.

Environment: Oracle 9i, Oracle Forms and Reports 10g, SQL*Plus, TOAD, SQL, PL/SQL, Shell scripting, Serena version control system, BugZilla, Linux, Windows Server 2003, Windows XP.