SUMMARY

• Accomplished results oriented PLSQL/Oracle Developer with 7+ years of extensive experience in Design, Development, Administration, Testing, Authoring Documentation and Support.
• Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, and Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
• Highly Proficient in developing and customizing Oracle Forms and Reports using Oracle Forms 11g/10g/9i, Reports 11g/10g/9i, XML Publisher using SQL, PL/SQL.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 9i/10g and Oracle Forms builder 1/10g respectively.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Involved in Migrating the Data fromOracledatabase and Optimizing the database performance.
• Generated complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Proficient in loading data from flat files into database tables using SQL*Loader scripts.
• Functioned with Arrays, Records, Oracle SQL and Exception Handling.
• Revamped Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, Oracle hints, DBMS PROFILER, DBMS STATS.
• Worked with tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus, External tables and UTL FILE.
• Automating data loading, extraction, reports generation using UNIX Shell scripting.
• Experience in handling very large data files using Export - Import Utilities and SQL*Loader.
• Worked on Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Good knowledge working with Teradata SQL Assistant and Query man.
• Efficient in creating Test cases and performed data validation and process testing for application moving into production.
• Strong Business Intelligence Skills with experience in Oracle reports and Business Objects.
• Experience in building new Oracle Forms and customizing them.
• Expert in generating reports using Oracle Reports Builder, XML Publisher.
• Adept in using Oracle Tools like SQL* Plus, Toad, SQL Developer, SQL Loader, Data Loader, SQL navigator.
• Created and setupOracle databases 12c.Created Container database and Pluggable databases.
• Utilized Informatica debugger for trouble-shooting and to test the data flow
• Involved in all phases of the Software Development Life Cycle from analysis, design, development, testing, implementation & maintenance with timely delivery against aggressive deadlines.
• Expertise in Designing, developing & Fine-tuning data Migration and data-retrieval scripts.
• Expertise in writing Conversion and Interface programs using advanced utilities like Bulk load, SQL*Loader, UTL FILE, External Tables and DBMS UTILITY.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
• Used Normalizer transformations, XML Transformations, XXLT.
• Strengthened and structured to work efficiently in both independent and team work environments.

TECHNICAL SKILLS

Operating Systems: DOS, Windows XP/NT, Vista,7, UNIX

Languages: SQL, T-SQL, PLSQL, C

GUI’s Technologies: Developer2000 (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Oracle Designer 2000, Crystal Reports 9/10, Discoverer10g, Oracle APEX

Databases: Oracle8i/9i/10g/11g, SQL server 2000, Oracle XML DB, MS Access TERADATA

Utilities: SSIS, SQL* Plus, SQL* Loader, SQL Navigator, Toad, SQL Developer UTL FILE

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia PA

PL/SQL Developer

Responsibilities:

• Developed notifications for different payment plans. Also Worked on Queue Processing and Shell Scripting.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Responsible for Developing and Testing of client application code related to applications.
• Created and generated various Database objects like tables, views, materialized Views, Procedures, Functions, partitioning tables, indexes, sequences, synonyms using TOAD.
• Involved in writing PL/SQL packages, procedures, functions and complex queries.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Web Service integration with oracle, Batch process designing and Bulk data loading process creation.
• Data mapping process initialized and Architect the internal data structure for reporting.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance. Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer
• Performed extensive defect fixing and support during the client pre-production testing phase, identifying issues and tracking them through HP quality center.
• Wrote generic PL/SQL code modules (PL/SQL Libraries) for Reports to handle data manipulations on client.
• Worked on Informatica PowerCenter for Extraction, Transformation and Loading process.
• Designed and implemented client-server application using Oracle Forms Builder.
• Proactively tuned SQL queries leading to significant improvement in system response time and efficiency.
• Used TERADATA utilities FASTLOAD, MULTILOAD, TPUMP to load data.
• Wrote FASTEXPORT scripts to export data from TERADATA DATABASE TO GENERATE FILES.
• Developed UNIX scripts for transmitting files from the secure server to the customer specified server, using various FTP batch processes.
• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Performed Informatica Code Migration from Development/SysTest/QA.
• Migrated forms from 9i to 11g and recompiled them for validating any decommissioned features.
• Developed UNIX Shell Scripts with embedded SQL*Loader, expdp/Impdp calls and PL/SQL statements to extract data in the form of flat files for data loading and migration.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Created and monitored the Oracle DBMS JOBS as a part of weekly tasks.

Environment: Oracle Database 9i/11g, Informatica Power Center 9.0, Windows 7, SQL Developer, Forms Builder 10g, Reports Builder 10g, XML, SQL, PLSQL, Unix Shell Scripting, Perforce, WINSCP, PUTTY, TERADATA R12/R13, TERADATA SQL Assistant.

Confidential, SFO, CA

Sr. Oracle Developer

Responsibilities:

• Implemented B2B (business to business) and B2C (business to customer) software change requests involving full software development life cycle (SDLC) by performing design.
• Created Database objects such as Tables, Views, and Sequences.And Designed database objects such as tables, indexes, constraints, sequences and synonyms.
• Developedoracledatabase procedures, functions, packages and triggers.
• Developed PLSQL code extensively using Cursors, Ref Cursors,OracleCollections, PLSQL Record Object Types, Associative Arrays, Variable Arrays, Nested Tables, passing the table types as parameters, reading, modifying these table types, Exception Handling techniques.
• Developed several Oracle reports usingOracleReport Builder in Inv, AP, AR, PO and OM Modules.
• Developed newOracleForms as per client requirements.
• Worked on complex Informatica mappings, mapplets, reusable transformations, workflows and worklets using various tasks to facilitate daily, weekly and monthly loading of data.
• Customized the existed forms usingOracleForm Builder.
• Customized the existed reports usingOracleReport Builder.
• Analyze, review code, perform bug fixings to optimize the performance.
• Extensively used various IDE's SQLdeveloper, SQL PLUS tools/utilities for compiling/debugging the code.
• Normalized data fields to meet the business requirements and specifications to build a data marts for various departments into a metadata.
• Developed ETL scripts to enable weekly processing of 2-4 GB data sets into data warehouse.
• Identified issue and developed a procedure for modifying the problem which resulted in the better quality of critical tables by eliminating the possibility of entering replacement data in a Data Warehouse.
• Created and maintained the Data Model Repository as per company standards.
• Responsible for gathering business change requests and after extensive analysis determine (and document) scope of technical changes and implementation strategy.
• Extensively developed PLSQL code with cursors, Ref Cursors,OracleCollections, PLSQL Record Object Types to load XML data and process.
• Extensively used object types, associative/variable arrays, nested tables, passing the table types as parameters, reading, modifying these table types.
• Designed new tables to integrate with the existing schemas and created constraints, indexes, sequences and synonyms.
• Worked on performance tuning of the SQL queries to improve data conversion process.
• Modification to existingoraclestored procedures and functions to improve the performance by rewriting the SQL using bind variables and indexing the columns.
• Wrote customized API's to capture the run-time SQL generated through dynamic SQL.
• Created highly re-usable, robust, highly performing SQL queries using analytical functions.
• Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
• Identify the time taking SQL queries in Cursors and do performance tuning using Explain Plan, TKPROF.
• Maintained all of database service code and versions as central Repository.
• Maintained projects deliverables in a central Repository using on CA Clarity operational support systems.

Environment: Oracle11g/10g, Informatica PowerCenter 8.6.0, SQL, PL/SQL,OracleDeveloperSuite, SQL plus, SQLDeveloper, Windows XP.

Confidential, Long Island, NY

Sr. Oracle Developer/ Oracle Administrator

Responsibilities:

• Responsible for Migrating the Data fromOracledatabase (PRODUCTION) to other database for company usage.
• Involved in SQL and PL/SQL performance tuning using EXPLAIN PLAN and DBMS PROFILER.
• 24/7 production support.
• Installing and Upgrading theoracleserver and application tools
• Responsible for writing PL/SQL Packages, Functions, Procedures, Collections and cursors
• Importing and exporting the schemas using Datapump and Maintained Schema Objects.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Responsible for running the DML and DDL scripts in UAT and PRODCUTION.
• Wrote PL/SQL scripts for bulk data upload, data analysis and correction.
• Worked on Perl scripts to transfer files using FTP to all the UNIX servers at one time.
• Automatic email generation was used to monitor various back-end processes.
• Loading the data from large files intoOracletables using SQL*Loader, PL/SQL
• Responsible for creating Control files for SQL*Loader.
• Creating primary objects (tables, views and indexes) once the application developers design an application.
• Enrolling the users and maintaining security.
• Controlling and monitoring user’s access to database.
• Monitoring and optimizing the database performance.
• Hands on experience withoracleExport and Import Utility tools to migrate data through different environments.ConfiguredOEM 12cmonitoring .Created rules to send out mission critical alerts from production database. Installed, setup and configured Oracle Enterprise Manager Cloud Control 12c for administration, performance tuning, monitoring and alerts.
• 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.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Designed and brainstormed Database upgrade from 11g to 12c in Single Instance to Multi-Tenancy.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Monitoring, Resolving and testing the customer'soracledeployments usingOracleEnterprise Manager.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Wrote SQL queries for business teams for reconciliation purpose.

Environment: Oracle11g, UNIX, SQL, PL/SQL, SQL Loader, UNIX shell script, XML, Toad 12.6, SQLDeveloper

Confidential, Overland Park, Kansas

Sr. Oracle Developer

Responsibilities:

• Extensively utilized the application object library to register SQL*LOADER programs, PL/SQL procedures, forms and reports.
• Giving Training Sessions for Client.
• Advise functional people at requirement time regarding custom components finalization.
• Worked on Form Personalization for Different Requirements.
• Contributed in analysis, design and coding of Oracle processes in PL/SQLto build packages.
• Design and Development of data validation, load processes, test cases usingPL/SQL, Stored Procedures, Functions, Triggers, Cursors using Oracle 10g.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Developed Ref Cursors to accommodate the business rules.
• CreatedTables, Views, Materialized views, and constraints.
• Designed and developed the Forms and Reports for the user Interface.
• Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using form builder 9i.
• Expertise in setting up UNIX Cron jobs.
• Troubleshot errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Developed Grouping report and matrix reports using oracle reports 9i report builder.
• Involved in testing backend SQL queries for query optimization.
• DevelopedUNIX scriptsusingVI editorto create FTP Jobs and to schedule the jobs.
• Creating the concurrent programs and registering the functions to the oracle applications (EBS).

Environment: Oracle Database 10g, Oracle EBS R12/11i, Windows XP, UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 10g, XML, SQL, PLSQL, WinSCP, Putty.

Confidential

PLSQL Developer

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.
• Used Materialized views in places where the data does not change very frequently.
• Developed UNIX shell scripts for batch jobs.
• Designed and developed Oracle Monthly Reports.
• Extensively used Oracle ETL process for address data cleansing.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Developed Email Routing logic for validating, classifying and processing the incoming emails to Email Center.

Environment: Oracle Database 9i, PL/SQL Developer, TOAD, Forms Builder 6i, Reports Builder 6i Workflow Builder 2.6.3.5, PVCS

Confidential

Oracle Developer

Responsibilities:

• Responsible for interacting with Business Users and other development teams for gathering requirements.
• Developed Functional and Technical Specifications.
• Involved in creating SQL loader scripts to load the data from the flat file received from 3rd party vendors into oracle tables.
• Involved in writing PL/SQL program using UTL FILE package.
• Involved in Unit testing, System testing and UAT.
• Worked as production support specialist and resolved production related issues.
• Developed Functions & Procedures to manipulate the data and to load to the tables.
• Used Oracle Advanced concepts like types, PL/SQL tables and V-Arrays and dynamic SQL in generating the complex extracts from database.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Involved in the creation of database objects like tables, views, stored procedures, functions, Indexes for new requirements.
• Involved in creating users and requests, schedules in Oracle Apps for all interfaces.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Developed ETL mappings, transformations using Informatica Power Center
• Involved in Development and Unit Testing.
• Involved in Coding, Data conversion and Implementation.
• Designed front end screens in Pro*C
• Extensively involved in writing SQL queries (Sub queries and Join conditions).
• Developed customer and order packages to process all customers and orders.
• Created database objects like views, stored procedures and functions.
• Prepared Unit test plans and developed Technical Specifications.

Environment: Pro*C, Oracle 9i/8i, UNIX Shell Scripting, Solaris, TOAD.