SUMMARY:

• An IT professional with more than 9+ years of experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g, 11g & 12c in Production, Staging, Development environments.
• Extensive domain knowledge in Investment Banking, Retail and Insurance industries.
• Over 5 years of experience in Data Migration, Data warehousing and ETL(extraction, transformation and loading operations).
• Over 5 years of experience in UNIX Shell - Scripting.
• Extensive experience in creating XML files to store data and making them available when necessary.
• Strong work experience in Query construction, Stored Procedures, Triggers and User Defined Functions using SQL, PL/SQL.
• Mastery of PL/SQL programming, using features such as Records, Collections, Bulk Bind, Ref. Cursors, and Dynamic SQL.
• Experience in using ERWin data modeling tool for creating data models and relational schema.
• Expert knowledge of new features in Oracle 11g, such as Virtual Columns, Flashback Table, PIVOT and UNPIVOT queries.
• Well experienced in performance tuning, using various Oracle utilities, including EXPLAIN PLAN, Hints, SQL TRACE, TKProf and DBMS Profiler to identify bottlenecks and provide solutions.
• Experience in organizing and managing routine jobs by using packages like DBMS SCHEDULER to schedule tasks.
• Experience in Oracle backups, generally through Export and Import utilities(Full, User, and Table).
• Expertise in Data Migration using Database link, SQL*Loader and UTL File Utilities.
• Experience in database administrative tasks like installation and configuration of database, creating database, partitioning of database, creating indexes.
• Experience in creating mappings using Informatica.
• Self-motivated with good analytical, problem solving and presentation skills.
• Excellent team player with enthusiastic, strong initiative and ability to accept responsibilities and meet tough deadlines.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripts, C, PHP, JCL, VBScript

RDBMS: Oracle 12c/11g/10g/9i/8i/8.0/7.0, MS-SQL Server 2000/2005, MySQL.

ETL Tools: Informatica 9.5, IBM Datastage.

GUI: Oracle Forms & Reports 11g, SQL*Loader.

Database Tools: SQL PLUS, TOAD, and SQL developer Teradata.

Operating Systems: Windows XP/7, Windows Server 2008 and Linux (Redhat/Ubuntu).

PROFESSIONAL EXPERIENCE:

Confidential, Bloomfield, CT

Oracle PL/SQL Developer

Responsibilities:

• Responsible for requirements gathering, analysis, design and development of any enhancements in the application.
• Created and maintained database objects like Tables, Views, Materialized views, and Synonyms to support business requirements.
• Developed Stored Procedures, Functions, Triggers and Packages to meet the business requirements and update the existing objects based on change requests.
• Utilized database links to accommodate cross-database transactions.
• Extensively used PL/SQL Collections and Records, Partition methods for oracle tables and indexes.
• Worked with Bulk Collect to improve the performance of fetching data.
• Handled errors using Named System Exceptions such as INVALID NUMBER, NO DATA FOUND and PRAGMA EXCEPTION INIT.
• Created aggregate materialized views in Data Warehouse.
• Performed Oracle Performance tuning using SQL TRACE and EXPLAIN PLAN.
• Designed and developed data loading processes using PL/SQL and UNIX Shell scripts.
• Involved in developing ETL Process to load the data from different sources.
• Used SQL*Loader and external table to successfully massive data migration.
• Used AUTONOMOUS TRANSACTION PRAGMA to log the status when error occurred.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Used various Shell Scripts and Scheduled jobs on Crontab in UNIX environment on a routine basis.
• Worked on SQLPLUS and SQLLDR calls from shell scripts.
• Organized and managed routine jobs using packages like DBMS SCHEDULER to schedule tasks.
• Performed Unit Testing on the scripts and ensured all the exceptions were handled according to the business logic.
• Worked on Slowly Changing Dimensions to handle the incremental load of the Dimension data.
• Transferred data using FTP (File Transfer Protocol) and storing the back-ups of data using SCP (Secured Copy).
• Documented the whole process flow, PL/SQL packages, locations and descriptions, and possible error messages.
• Provided knowledge to other team members about the new technology and allocation of tasks to the team.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 12c, Teradata. Oracle 11g, SQL* Plus.

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Analyzed data needs for customized reports and mapped data requirements.
• Managing tables, indexes, constraints, views, sequences, synonyms and stored program units.
• Developed Stored Procedures, Functions, Views, Materialized View and Triggers.
• Modeled the Data Warehousing Data marts using Star Schema.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• Troubleshoot performance issues within packages and stored procedures using Explain plan and DBMS OUTPUT.
• Created corn jobs calling UNIX scripts to download and manipulate files and to generate the XML Reports.
• Automated the scripts to monitor the system performance on a daily basis.
• Designed the overall architecture for Data Migration based on functional requirement.
• Created test scripts for validation of transaction records into interface tables.
• Wrote technical specifications for all the procedures developed in the module. Maintained log files during analysis and reported any performance defects subsequently.
• Participated in design discussions with the application architects and suggested design changes to improve database performance.
• Wrote complex queries and sub queries to do analysis work and generated reports to validate results.

Environment: Oracle 11g, UNIX, TOAD, PL/SQL, SQL*PLUS, Teradata, SQL, SQL*Loader.

Confidential, NJ

Oracle PL/SQL - ETL Developer

Responsibilities:

• Involved in maintaining and updating the procedure for ETL process.
• Involved in interacting with the business team to gather and model business requirements.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, and synonyms to meet the business requirements.
• Modified existing SQL code.
• Executed upload and load procedures to check the data feed was loaded correctly into the tables.
• Wrote UNIX shell scripts to automate processes like data load and sent notification mails.
• Modified the existing forms and reports and registered those in the application.
• Modeled the Data Warehousing Data marts using Star Schema.
• Directly interacted with users and helped in the development of functional specifications.
• Coordinated with the front-end design team to provide them with necessary stored procedures, packages and necessary data.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 11g, UNIX, Erwin, SQL* Plus, and Oracle Forms.

Confidential, Valhalla, NY

Oracle PL/SQL Developer

Responsibilities:

• Created data warehouse objects - Fact tables, dimension tables, table partitions, sub-partitions, normal and bitmap indexes, summary tables, materialized views, stored packages, functions and procedures with parallel queries, making indexes unusable and rebuilding local indexes for partition exchange loading (PEL).
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Extracted data into Oracle table using SQL*Loader.
• Used Bulk Collect, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Developed and modified PL/SQL packages, functions, and procedures.
• Wrote complex SQL script, analytical function.
• Improved query performance by query optimization - tracing the query execution plan (explain plan).
• Created SDLC Documentation.
• Prepared Shell scripts for ETL to run in batch.
• Did analysis and functional design, along with a thorough knowledge of relational database concepts and design.

Environment: Oracle Application Server 11g, TOAD, UNIX.

Confidential, East Hanover, NJ

Oracle PL/SQL Developer

Responsibilities:

• Involved in designing and developing data warehouse for the corporate data repository.
• Created and maintained Database Objects (Tables, Views, Indexes, Sequences, Database triggers, stored procedures).
• Modified existing codes and developed PL/SQL packages to perform certain specialized functions / enhancement on oracle application.
• Defined indexes on various tables to improve the performance of the queries for reporting purpose.
• Developed SQL* loader scripts to load data in the custom tables.
• Run batch jobs for loading database tables from flat files using SQL* Loader.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries for various reports.
• Developed and optimized of SQL queries using TOAD, Explain Plan utilities.
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Tuned SQL queries and performed refinement of the database using tools like EXPLAIN PLAN and TKProf to improve the system response, time and efficiency significantly.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Worked closely with users and developers team to resolve issues in the developed reports.

Environment: Oracle 10g/11g, SQL, PL/SQL, SQL*Plus, SQL* Loader, TOAD, Erwin 7.2, UNIX, Shell scripts.

Confidential, Boston, MA

Oracle PL/SQL Developer

Responsibilities:

• Gathered development requirements from client’s functional team and functional design specification documents.
• Created logical and physical database objects - table spaces, tables, indexes, referential integrity constraints, and triggers to development needs.
• Performed logical database design.
• Responsible for the development of pipelined functions using ref cursors and PL/SQL stored procedures as per client requirement.
• Optimized the Oracle PL/SQL queries by Performance Tuning.
• Fine-tuning of PL/SQL Stored Procedures using Hints in EXPLAIN PLAN.
• Worked on enhancement of existing pipelined functions and packages.
• Authored the technical design documents for the given functional design.
• Responsible for developing technical components for the following Oracle Applications modules: Custom Char Resolve, Conversion Resolve, Upc Resolve, Scope Resolve, View/SubTotal Resolve, Hierarch Resolve.
• Tested codes developed by self and team.
• Fixed bugs while in production with top priority.

Environment: Oracle 10/11g Database, PL/SQL Developer-5.1, SQL*Loader, TOAD.