SUMMARY

• 7+ years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments.
• Experience in financial, retail and telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Strong knowledge or UNIX/shell scripting, loading large amount of data in table.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high - transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

• Analyzed pro health database and also involved in Requirement Analysis, System Design, preparing Functional Specifications, preparing Design.
• Created the business logic in packages, extensively used functions and Pipelined functions.
• Captured all the business validations in various lookup tables.
• Developed database objects including tables, Global temp tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams.
• Wrote shell scripts to automate the loading, balancing and extraction process
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities
• Worked on various backend Procedures and Functions using PL/SQL
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Performance tuning using Explain plan, TkProf
• Executing ftp, telnet for remote access between UNIX systems
• Check the functionality of data in the front-end whether it is displaying properly or not
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.

Environment: Oracle 11g/10g, PL/SQL, SQL*Loader, TOAD, MS Office, HP-UX.

Confidential, Irvine, CA

Oracle PL/SQL Developer

Responsibilities:

• Gathered and analyzed requirements from business users.
• Created database objects like tables, synonyms, sequences and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Loader to load data into the database coming from Metavance and Standby Databases.
• Wrote complex PL/SQL packages for Customer Interfaces, Payment Interfaces and Broker Commissions for Oracle Applications.
• Used Materialized Views, Hints, SQL Trace / TKPROF, Indexes for query tuning and optimizations.
• Used BULK Collect and External Tables for improving performance on the Enterprise Data Warehouse.
• Created Test Cases, Technical Design Documents, and Install Plans and worked with Release Engineering
• Used Clear Case, Clear Quest, and SharePoint for defect creation/resolution, documentation, development tracking and Code repository.
• Worked with BOXI universe and Webi Reports along with Discoverer reports.
• Involved in PL/SQL Advanced concepts likeBulkcollectand FORALL programming.
• Collaborated with Data Warehouse Architect in writing SQL scripts, Shell Programs, Data Flows
• Worked with Oracle Forms 6i and Reports 6i.
• Used Informatica to extract data from different types of sources and load to oracle database.
• Knowledge of full life cycle implementation in building a Data Warehouse.
• Extensively used ETL methodology for supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solutions.
• Worked in ETL Tool (Informatica) to extract data from Teradata, Oracle and ASCII,
• Created Informatica Mappings to load data using transformations like Source Qualifier
• Supported development, test and the production databases.
• Used SQL Developer and TOAD to develop code.

Environment: Oracle 9i/11g, Toad 9.0, PL/SQL, SQL* Loader, UNIX, share point, Clear Quest, Forms 6i, ETL, Informatica Power Center 8.1.

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Wrote high-level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Gathered and analyzed business requirements from end users.
• Worked with applications specialists to understand the new data requirements.
• Collaborated with the DBA in creating tables required for the application.
• Used SQL*loader to load the data from the files provided by the interfacing applications.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERWIN), UAT (tests cases and results), and release notes.
• Migrated enhancement from appropriate dev Area to Test Areas/prod Areas.
• Issued Grants to the business users for appropriate DM tables to design their Universes.
• Wrote UNIX shell scripts to load data.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding the various projects.
• Attended meeting with business analyst to get new requirements for the application.

Environment: Oracle 9i/10g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica.

Confidential 

Oracle Developer

Responsibilities:

• Developed screens for item details entry, purchase order entry, sales order entry and received report entry using Forms.
• Developed reports for the same using Reports.
• Generated Complex Packages, Procedures, and Functions & Triggers using PL/SQL.
• Solved mutating problem in database triggers.
• Used Explain Plan, SQL Trace, Analyze utilities for performance tuning, query optimization
• Developed around 10 User Interface Screens, which include Master Detail Screens, Screens with multiple canvases and screens with Multiple Blocks.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into application tables from old system.
• Also used Oracle Import/Export utilities and did the testing of module.
• Assisted in monitoring the data fragmentation on data files, rollback segments and performed periodic export and import to avoid fragmentation.

Environment: Oracle 8i Forms 4.5, Reports 2.5, PL/SQL, Windows 2000.