SUMMARY

• 9+ years of experience as Oracle PL/SQL, SQL Database Developer in Oracle 12c, 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Production Support Projects.
• Strong experience in Oracle (8i,9i,10g), PL/SQL, SQL, Informatica and Web applications using Oracle forms10g.
• Proficiency and expertise in migrating Database from Oracle to SQL side by side and in place migrations.
• Possess a good foundation in systems analysis, database design and expertise in requirements analysis, project management, leadership, testing/quality assurance, software development, customer service.
• Strong experience in designing and developing User Interface (UI) web applications as a Oracle forms Developer (6i, 9i,10g).
• Strong experience as PL/SQL Developer. 9 years of experience span include developing and coding Oracle forms and for backend DB programming to write complex SQL using joins, sub queries and correlated sub queries, functions, stored procedures, aggregate functions, dynamic queries, packages and triggers, table, view, metalized view (Mviews), constraints, indexes, synonyms.
• Extensive experience with PL/SQL collection using associative arrays, bulk collection and bulk bind.
• Experience with SQL Performance tuning and query optimization using explain plan.
• Experience in working with Oracle job scheduling.
• Experience in working with Oracle DB links. Implemented functionality in Oracle forms applications to copy data between databases that helped user to keep TSTA in sync as PRDA.
• Experience in Loading/Data processing using various techniques in batch processing procedures like SQLLDR to import data, External tables with various external parameters.
• Experience in handling Dynamic SQL queries using execute immediate or using Oracle package DBMS SQL.
• Having knowledge in importing, exporting full application or a particular page inAPEX.
• Extensive knowledge with Oracle PL/SQL package utility FILE UTL, DBMS SQL, DBMS OUTPUT, UTL SMTP etc.
• Experience in Unix shell scripts. Have developed Unix scripts to trigger DB objects.
• Experience with FTP TOOL through Toad and Unix command to get/put files
• Experience for Visual basic programming language. Have worked on re - development project from VB6.0 to Oracle Forms 10g.
• Experience for deploying Oracle forms, library, menu (. fmb,. pll,.mmb) in window and Unix both environments.
• Strong ETL experience of using Informatica Data Quality, Power Center, and Power Exchange & MDMHUB versions, Power Center Client tools, InformaticaDeveloper, Informatica Analyst, Informatica MDM Hub Console, and Informatica Data Director.
• Extensively used SQL Editors/Database Query tools like Toad, SQL Developer (Oracle Developer), Developer 2000, PVCS merant tracker, VSS, WinSCP, Putty, Remedy Force from Sales Force, MS-Office.
• Implemented long pending issue of customer on Character Translation DBCS project (Asian double byte character set) to handle traditional Chinese character and UDW characters (user defined characters).
• Experience with working to handle large volume data processing in ETL Project using Microsoft visual studio. Have created/supported project ETL was built in all PL/SQL code. Dimension, fact and stage tables all were getting populated using PL/SQL code.
• Experience in monitoring data load in after business hours on daily basis from other sources.
• Experience to work as a PQA/DPA to maintain quality of project.
• Extensive hands on Incident management/problem management/ DAR creation/KEDB preparation/ Dash reports.
• Experience in working for support project as L2/L3 support.
• Extensive experience in data modeling (logical and technical) and all phase of SDLC from requirement gathering, analysis, design, coding, testing, debugging, validations, deployment, documentation. Have worked on all documentation process BRD, FSD (Functional Specifications Doc), TSD(Technical Specification Doc) etc.
• Experience working with of Retails & Publishing Domain projects.
• Good written and oral communication skills and interpersonal skills with a strong ability to excel through collaboration with team members.
• Hardworking, quick learner and great work attitude.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, MySQL 5, MS SQL SERVER 2005/2008, DB2/UDB, MongoDB, SAP Tables and MS AccessOther Technologies HP Project and Portfolio Management (PPM), HP ALM/QC, Oracle E-Business Suite 12, SCM, Oracle Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), NoSQL-SQL, Oracle Applications Manager (OAM), Oracle Exadata.

Programming Languages: SQL, PL/SQL, Unix shell scripts, SAS, C/C++/C#, Perl, Power Shell XML, HTML, VB.NET

ETL Tools: IBM Info Sphere Data Stage, Informatica

Data Warehousing: Star & Snow-Flake Schema Modeling, Erwin, Sybase Power Developer, SSIS, SSRS, OWB, ODI

Dev. Tools: Windows/Linux/Mac OS Environment, Eclipse, Git, XCode, Subversion (SVN), CVS, ClearCase.

Tools: TOAD, SQL*PLUS, SQL Developer, T-SQL, SQL*Loader, Crystal Reports, Forms 6i/9i/10g, Reports 6i/9i/10g, Work Flow Builder and XML Publisher.

PROFESSIONAL EXPERIENCE

Confidential, Lewisville, TX

Oracle PL/SQL Developer

Responsibilities:

• Gather requirements for change requests with the Business team and create design documents
• Provide User Access to Business End Users to the Front-end tools after getting the required approvals
• Create PL/SQL packages for implementing Change Requests for adding new functionality to the application
• Worked as Developer for Oracle module of project and provided L2/L3 support for Oracle application’s incidents/ problems.
• Handled couple of applications for Tops. DSM, TOL based an Oracle forms, Papillion based on MS-Exel, WCC backend DB for scheduling jobs.
• Handled another unit of RDA: TOPS BI where system was designed with Microsoft SQL server fulfilling the ETL flow designed in Oracle database. Large volume of data load and report fetch, user reported data issues fixing for reports.
• Responsible to fix any bug in ETL Flow at any stage (Extraction/transformation/loading layer)
• Developed PL/SQL modules using complex queries, functions/triggers/joins/dynamic/stored procedures/queries/partitioning/collection/associative arrays a list etc.
• Responsibility to design the module and created Oracle tables with key relationship according to the design module.
• Upgraded/Migrated SQL Server 2014 toSQL2017 and migratedOracledatabases to SQL databasein test and Dev environments.
• Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
• Responsible for creating and modifying PL SQL Stored procedures and functions,Apexpages, reports, and charts, according to the business requirement by referring the SRS document.
• Involved with ETLdevelopers, for developing complex mappings, mapplets, reusable transformations using designer to integrate data from different sources like Oracle, Flat files, and SQL databases by following guidelines and loaded data successfully into target.
• Banking Reporting and Federal Filing Apex Application Upgrade, Enhancements, support.
• Performed documentation for Cluster ware installation, RACRDBMSinstallation, RAC Database creation, Grid Control installation,Oracle11g Standby Documentation.
• Responsible for all application changes as part of Oracle DB Migration from Oracle 9i to Oracle 10g version.
• Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate consolidated (fact/summary) data identified by dimensions using InformaticaETL(Power Center)tool.
• MPPis used in tracking the project and release schedules tracking the milestones and resources.
• Involved in the design of Informatica Work flows for implementing the business logic for the model execution.
• Knowledge experience with other No SQL Databases.
• Extensive in creating new tables using partitioning, stored procedures to carry logic of conversion, Dynamic SQL usage, triggers, views, varrays, associative arrays.
• Used SQL Loader and wrote control file scripts to load data from flat files to Oracle tables.
• Developed UNIX shell scripts to execute procedures and publish the files.
• Scheduled the jobs using DBMS Scheduler.
• Extensively worked for Oracle forms application enhancements/tickets to apply/verify business rule validations and process.
• Developed, documented, maintained and approved SQL Server Stored Procedures, SSIS Packages,Power Shell Scripts,and C# code.
• Optimized PL/SQL modules using explain plan and re-indexed the tables accordingly.
• Tracked, logged and timely responded to support tickets. Performed user account maintenance, managed incidents and provided resolution for end-user’s technical challenges.
• Coordinating with business users lead for the requirement gathering and estimation for change requests.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well asT-SQL code from developers and QA
• Duplicate all the non-production databases on Exadataserver according the Data Warehouse development project's requirement. Help to compress large volume partition table by usingOracle HCC (Hybrid Columnar Compression) techniques.
• Experience developing and supporting Microsoft BI and reporting capabilities (PowerPivot,PowerBI, Power View, SQL Server Reporting Services)
• Responsible for all activities related to the development, implementation, and support of ETL processes for large-scale data warehouses using Informatica Power Center andT alendtools.
• Extensively used Oracle Hints to direct the optimizer to choose an optimum query Execution Plan
• Extensively used Bulk Collection in PL/SQL Objects for improving the performance
• Handled errors using Exception Handling extensively for debugging and maintainability.
• Automated Oracle and Informatica workflows using Unix Cron Utility in Unix Environment.
• Responsible for writing Unix Shell scripts for loading data using SQL*Loader. The Control Files for the tables were created and automated through UNIX shell scripts to perform data load in to Oracle tables. Used SQL Loader and PL/SQL scripts to load data into the system application.
• Performed Data Cleansing to weed out erroneous Orders from the DWH tables
• Experience in managing large-scale, geographically-distributed database systems, including relational (oracle, SQL Server) andNoSQL(MongoDB, Cassandra) systems.
• Preparation of weekly release plan and updating the release notes.
• Implemented Integration between Extension andFacets.
• Integration of modules with mainframe.
• 24*7 on call support on need basis for production abends.
• Preparation of RCA (root cause analysis) document for SEV1 and SEV2 issues. preparation of DAR(Decision Analysis Report)
• KEDB (known error DB) preparation for repeated incidents had helped the support team for quick resolution of re-occurring issues.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, PowerBI, Informatica, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, T-SQL, CVS, MPP, U-SQL, TOAD, UNIX, Shell scripting.

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.
• Responsible for Analysis, Design, Coding, Debugging and Deployment.
• Worked with the team to design, develop, test & implement system. Creation of database objects like tables, procedures using Oracle tools like PL/SQL, TOAD. Written Stored Procedures using PL/SQL.
• Worked in preparing functional document, user document, process flow diagram and flow chart.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements.
• Created PLSQL procedure, used the DBMS SCHEDULER for automatic weakly sending emails to the users.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting upPowerBI Gateway.
• Rich experience in writing SQL queries, Views, Materialized views, cursors, collections, Ref cursor, cursor variables, System cursor, Dynamic SQL.
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Trobuleshooted performance issues and bugs within anonymous blocks, Partitioning dbms output and Explain plan.
• Expertise in developing different item types like resizable text area, data picker, number field, and new rich-text editor using OracleAPEX5.1.
• Provide analytical, complex and specialized client service analysis using Power BIdashboards
• Involved in writingT-SQL Programming for implementing Complex Stored Procedures and User Defined Functions for different tasks.
• Involved in data Migration fromOracle toSQLDatabase.
• CreatedOracledatabase objects (tables, partition tables, b-tree and bitmap indexes, constraints, views and materialized views),PL/SQLProcedures/Functions/Packages,SQLand Korn shell/Perl Scripts and develop transaction processes based on created objects to support business needs and report needs. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
• Enhancements, Support and Solution design of multiple CustomApexSolutions to support Lab Activities.
• Create various Data Mapping Repository documents as part of Metadata services (EMR)
• Short term assignment to assist Oracle in a data clean up and conversion / migration task using Oracle Warehouse Builder 10G Rel. 2, to migrate mainframe legacy to Oracle eBusiness Suite.
• Worked as an Informatica Developer to design and develop Informatica mapping, to perform the Extraction, Transform and Load process by studying the business requirement from the users and the mapping documents.
• Development, design, implementation, and supporting Supply Chain applications utilizingLogility Voyager Solutions, working with Oracle ERP implementation, completing on Oracle Applications, and managing staff of up to 7 Programmer Analysts.
• Documented, Migrated and refactored (1k+) interconnected automation jobs from System Center Orchestrator to JAMSJob Scheduler (asPowerShellScripts) with no production downtime.
• Impact Analysis on the patches received form Oracle Retek with the existingRMSsystem.
• Supported 24x7OracleProduction Databases ofRDBMS11g
• Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR).
• Developed Scripts for creation of database objects like tables, views, indexes etc.
• Provided Production Support for the application and business users.
• Experience in upgrading and migrating various versions of Mongo database on different platforms and provide solutions related to the migration toMongoDB
• Handled Configuration Management Support for Release activities.
• Involved in deployment and post-deployment support.
• Created Indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files. participated in analysis and designing ofOracleExadataServer for infrastructure and related projects. Assisted in integration ofExadataapplications into current IT actionable events and solutions
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the Informatica mappings
• Good experience onMongoDBscaling across data centers and in-depth understanding ofMongoDBHA strategies, including replica sets.
• In depth Knowledge in ER Modeling and Dimensional modeling (Star andSnowflakeSchema) building Dimension and Fact tables.
• Increased and maintained higher velocity of all development teams by coaching onAgilebest practices, resulting in 30% improvement
• Bug fixing backend Oracle in the existingRMSsystem.
• Wrote PL/SQL Database triggers to implement the business rules in the application
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Developed reports using complex queries as per client request as a part of production support.
• Provided on call support, solved the user issues and made necessary changes.

Environment: Oracle 10g, PL/SQL, UNIX, TOAD, T-SQL, PowerBI, Oracle Forms 9i/10g, Reports 9i/10g, Erwin, IBM Web Sphere Data Stage, U-SQL, MKS Integrity, CVS, SUN Solaris, MS SQL Server

Confidential, Nashua, NH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Requirements Gathering, Analysis, Design, Development, Testing, and Support.
• Created the database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes, and Analytical functions.
• Used External Tables and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Ensure development teams are practicing the coreAgile/Scrum principles.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, SQL*Trace and TKPROF.
• Effectively made use of Table Functions, generated columns, Indexes, Table Partitioning, Collections, and Materialized Views.
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding. Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.
• Worked on various tables to create Indexes to improve query performance and also partitioning large Tables.
• Worked in implementing table partitions using Range, Hash, Composite techniques.
• Good understanding of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Extensive use of Unix Shell Scripts and Autosys to automate process.
• Used Autosys to schedule the batch jobs for Intraday and End of the business day cycles.
• Worked on UNIX and Perl scripts for scheduling Autosys jobs in UAT/SIT/PFIX/PROD Environments.
• Worked on Version Control tool such as Tortoise SVN and used the JIRA bug tracking tool.
• Responsible for troubleshooting back end UAT and production issues.
• Designed and implemented the Mongo DBschema.
• Worked on troubleshooting, issue escalation, applying the patches and fixes using Change Requests.
• Worked extensively to deploy the UNIX and Perl code in Linux environment.
• Understanding the PL/SQL code for issues in the database and advice the development team with logs.
• Developed several Admin Screens in which mostly developed Interactive Reports Using APEX and Created editable Form Pages for each Row in that Interactive Reports developed and modified form Pages using oracle APEX4.2.
• Production support and involved in implementation of coding standards and Data Base change requests.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting, Oracle Warehouse Builder 11.2.0.2,Subversion (SVN), CVS, Perl.

Confidential, Charlotte, NC

PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Participated in system analysis.
• Participated in code walk throughs and review sessions with the development team.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using functions and cursors for common utilities.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Integrated packages and procedures to work with Web-Services.
• Extensively Used the DBMS XMLGEN and DBMS XMLSTORE package to generate and insert XML files in Oracle 11g.
• Performance Tuning for queries, functions and procedures for efficiency on Production environment.
• Analyzed the PROD data and developed Data Fix queries, including the cascade tables.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Experience in Creating the UAT Testing Plans and defining them inMPP.
• Developed Automated Batch Jobs to perform frequently running jobs.
• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
• Analyzing the explain plan of theMongoDBqueries creating required Indexes to boost query performance.
• Automated scripts by scheduling control-M jobs, by using PowerShell scripts and windows scripting for improvement in performance of reporting.
• Designed AutoSys based solutions for communication of issues to technical teams.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail.
• Created Oracle forms components such as object groups, property classes and visual attributes
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Worked on Oracle PL/SQL collections ARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Created new SSIS Package to extract date from legacy to SQL SERVER objects using BIDS and Visual studio 2010.
• Worked extensively on web forms and data binding controls like Grid View, Data List and drop-down boxes and Mapping page fields to the database fields.
• Designed and created complex source to target mappings (STTM) using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Forms, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Performed and Supported unit testing, system testing and UAT testing. Dealt and resolved production issues.
• Track the development of the project and review the code to maintain good quality.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails.

Environment: Oracle 11g, PL/SQL, SQL*Plus, Agile, SQL Developer, Oracle Forms and Reports, TOAD, Unix Shell Scripting.

Confidential, Hartford, CT

Oracle Developer

Responsibilities:

• Analyzed all business functionality related to back-end database interfaces and utilized PL/SQL Developer tool in developing all back-end database interfaces.
• Designed the conceptual, logical and physical model according to the requirements using Erwin.
• Worked on Logical and Physical Data Modeling to gather the business requirements and convert them into models and design the databases.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Used UTL file in packages to read/write the data from/to a flat file and SQL*Loader for migrating flat file data into target.
• Involved in OLTP Process.
• Created tables using Toad as well as created and managed roles for different users to access database objects.
• Written various Triggers, Stored Procedures to perform or automate many of the tasks.
• Optimized SQL queries used in Reports and Stored Programs (Procedures, Functions and Packages) to improve performance drastically.
• Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table and Oracle Functions and Procedures to centralize the business logic in the database.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries.
• Resolved Priority Production Support Issues and Defect Fixes.

Environment: Oracle 9i/10g, Forms 6i/10g, Perl, UNIX, shell script, SQL*LOADER, Erwin, TOAD, SQL*Loader, Toad.

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing.
• Implemented PL/SQL packages consisting of procedures and functions.
• 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.
• Extensively used cursors for fetching the rows.
• 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 design, development and Modification of PL/SQL stored procedures, functions, packages and triggers to implement business rules into the application.
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
• Extensively used cursors for fetching the rows.
• Loading data through SQL Loader and UTL FILE.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed the reports using Reports as per user requirements. Created 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.
• Interacted with business clients in the remote locations to verify customer requirements.

Environment: Oracle 10g, PL/SQL, UNIX Shell scripts, SQL Developer, TOAD, HP Quality Center, SQL *Loader, Import Export.

Confidential

Oracle Developer

Responsibilities:

• Developed various PL/SQL objects like procedures, functions, packages, Cursors, pipeline functions and triggers in accordance with the business needs.
• Created database objects like tables, views, synonyms, indexes, views, materialized views and sequences.
• Involved in interacting with the end-user (client) to gather business requirements and modeling the business requirements.
• Define and represent entities, functions and flows between the entities.
• Participated in analyzing the requirements for the logical and physical design of the database.
• Knowledge of Normalization, Data Warehousing, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Experience with merging data files coming from the customer into the existing data warehouse.
• Performed exception handling for data that did not conform to the required format.
• Implemented purging techniques on the data which is not required by the clients.
• Responsible for making the merged data in turn available to other clients.
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Presented several technical presentations on Oracle database operation.
• Scheduled html reports using UTL SMTP, UTL MAIL and DBMS SCHEDULER.
• Optimized SQL statements and PL/SQL blocks by using Oracle Hints, explain plans, profiling, collecting statistics and Trace sessions for Cost based Optimization.

Environment: Oracle 10g, PL/SQL, Oracle FMW, XML, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, SQL *Loader, Import Export.