SUMMARY:

• Around 11+ years of experience in Software development using Oracle Technologies that includes Complete System Development Life Cycle from Analysis and Design to Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Expertise in Database Design and Development using Oracle 11g/10g/9i/8i, Web deployment using Oracle 9iAS, PL/SQL, Reports 10g/9i/6i, Forms 10g/9i/6i, Oracle SQL Loader and SQL Server 7.0.
• Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Experience with Oracle Supplied Packages such as DBMS SQL,DBMS JOB and UTL FILE.
• Extensive Experience in Oracle tools like SQL*Plus, SQL * Loader, Toad, SQL Navigator, SQL Developer, PL/SQL Developer and Data Loader, and Data Modeler.
• Worked on Financial modules like AP, GL, AR modules in a product called Orion and developing various reports for this product feature.
• Involved in Tuning the PL/SQL code using Explain plan to improve the performance of the reports created using reports builder
• Experience in Oracle Forms and Reports Development.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8i/9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008, DB2/UDB, Teradata, SAP Tables and MS Access.

ETL Tools: Informatica ( Powercenter 5.1/6.2/7.1/8.6.1/9.1.0, Powermart 5.1, Power Connect/Power Exchange for SAP R/3, Mainframe and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Reporting Tools: Business Objects Developer Suite 5.1/BO XIR2, Cognos Suite, Cognos Report Net 1.1MR2, Crystal Reports, Oracle Reports 2.5

Operating Systems: UNIX(Sun Solaris, LINUX, UNIX), Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL, Unix shell scripts, Java, XML, C and Cobol.

Other Tools: AutoSys, Control - M, PVCS, WIN CVS, Informatica Data Quality, B2B Data Transformation, Informatica Power Exchange.

PROFESSIONAL EXPERIENCE:

Confidential, AUSTIN, TX

ORACLE PL/SQL DEVELOPER/CONSULTANT

Responsibilities:

• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL
• Involved in development of interface programs to import parts information to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers, extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
• Involved in development of shell scripts to send invoices to customer through mailing.
• Worked with developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF and AUTOTRACE.
• Developed scripts for checking oracle errors in alert log and trace files.
• Also created forms and reports for web and paper based using oracle forms and reports developer.

SENIOR ORACLE DEVELOPER

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• 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.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• 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.

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Provide on call and daily production support of APEX applications and Oracle PL/SQL ETL processes.
• Manage User Acceptance Testing of new applications and new versions of existing applications.
• Manage the packaging and release of applications to the training, UAT and production environments
• Involved in the continuous enhancements and fixing of production problems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
• Developed UNIX Shell scripts to automate repetitive database processes.

ORACLE DEVELOPER

Responsibilities:

• Analyzed requirements and contributed to data model design.
• Created multiple database objects for new application: tables, sequences, views, materialized views, PL/SQL packages, stored procedures, triggers, synonyms, collections, types and indexes.
• Fixed bugs, applied patches and participated in release planning.
• Tuned SQL and PL/SQL to improve database performance.
• Worked closely with C .NET application developers.
• Created framework for PL/SQL instrumentation. Written project documentation.
• Created multiple SQL, PL/SQL, Perl, and Unix shell scripts for database application maintenance.
• Performed load/stress, contention tests for performance and locking problems prevention in versioning.

ORACLE CONSULTANT

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Worked on developing a financial application system to handle all the bank transactions using SQL,PL/SQL,Developer 2000(Forms4.5 and Reports2.5) on Windows environment.
• Worked to maintain the system application design using Designer2000 tools.
• Used SQL*Loader to load the database from flat files.
• Created new Tables, Indexes, and Sequences where needed.
• Created database triggers for data security & Consistency.