SUMMARY

• Over 10+ years of programming experience as an Oracle Developer/ PL/SQL Developer in Analysis, Design, Data Modelling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Worked in most phases of SDLC (Software Development Life Cycle) those include Project Requirements Analysis, Estimates, Design, Developing, Testing, Deployment, Support and Maintenance for Defect Fixes/Change Requests (CR)/ New work requests (NWR) wif timely delivery against aggressive deadlines.
• Experienced in interacting wif Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Experience in Installing Software's and Configuring Databases.
• Installed/Configured and Maintained the Oracle Real Application Cluster Database.
• Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager),
• Created primary database storage structures (Table spaces), primary objects (Tables, Views and Indexes) and created users, Roles and Profiles.
• Experience wifData flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADand SQL*LOADER..
• Proficient in advance features of Oracle 11g/12c for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL
• Written backend Procedures, Functions, Packages and Triggers using PL/SQL and Data Modeling.
• Customized and developed Forms and reports using Forms9i/6i.
• Capable of maintaining multiple databases independently.
• Experience in Performance Tuning (me/O, Memory & SQL Tuning etc) by working in development area using STATSPACK and AWR reports as the main tool to tune SQL queries
• Controlling Access: Granting and revoking permissions to users, groups and roles on various objects.
• Also involved in exporting and importing of data using utilities like Export, Import, Data Pump Export and Data Pump Import.
• Experience in latest features like Flash-Back Recovery, ASM, ADDM, and ASSM.

TECHNICAL SKILLS:

Databases: Oracle 12C, 11g, 10g & 9i.

Languages: PL/SQL, SQL

Third Party Tools: SQL Developer, PLSQL Developer, Toad, Oracle Report Builder 6i,11g, CA Erwin

Operating System: Windows 2007/2003/XP, NT

Tools Handled: BMC Remedy, MySMI, HP WAH Application, Splint Ware Scheduler, Accurev 6

Document Repositories: ShareNet, KMSites (KEDB, KMDB)

PROFESSIONAL EXPERIENCE

Confidential, Berkeley Heights-NJ

Lead Oracle Developer

Environment: CA Erwin, Oracle 11g, 12C, Informatica, UNIX, PL/SQL Developer, SQL Developer, Toad, Oracle Forms 9i/11g KMSites (KEDB, KMDB)

Responsibilities:

• Involved in full development cycle ofPlanning, Analysis, Design, Development, TestingandImplementation.
• Interacted wif end users and functional architects for mapping the legacy data to the Oracle tables.
• Gathered Business Requirements and worked wif the users and stakeholders
• Designed logical and physical data models for star and snowflake schemas usingErwin.
• Designed Data Modeling, Design Specifications and to analyzeDependencies
• Wrote sequences for automatic generation of unique keys to supportprimary and foreign keyconstraints in data conversions
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Responsible for creating and modifying the PL/ SQL stored procedures, function, packages, Cursor, Ref Cursor and Triggers according to the business requirement.
• Developed materialized views for data replication in distributed environments.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Used Explain Plan and TKPROF for analyzing performance for database objects, tuning and optimizing PL/SQL code.
• Migrated PL/SQL Code from Oracle 10g to 11g and implemented Object types
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.
• Implemented PL/SQL to perform application security and batch job scheduling.
• 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.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Created some Custom reports for the end users to check the details and errors.
• Developed and modified a number ofCustom Formsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied
• Created LLD, HLD, and Unit Testing, SIT, UAT and Implementation plan documents.

Confidential, Franklin-TN

Lead Oracle Developer

Environment: CA Erwin, Oracle 11g, SQL Developer, TOAD, Oracle Reports Builder 11g, Informatic Power Center.

Responsibilities:

• Re-Designing of existing VIMS NNA (USA) application as per the Confidential Canada (NCI) requirements.
• Responsible for design and development of DB objects for different modules as per Confidential Canada requirements Payment Module, Geo module and Qualification Module.
• Exporting/Importing the 11G Databases through export/import data pumps.
• Develops, produces and maintains structural design of databases based upon logical data models and business requirements.
• Coordinates and aligns wif application team and ETL team.
• Create, edit and delete schema objects.
• Extensively used Oracle Enterprise Manager to monitor the multiple instances, SQL loader for loading data to databases, export/import utilities for data transfer between schemas/databases.
• Create, Edit and debug PL/SQL program units.
• Executing SQL statements. Manipulate and export data.
• Develops data migration/conversion techniques for upgrades. Evaluates database integration, integrity, and security.
• Local Database Administration.
• Performed capacity planning, provided backup strategy for remote production database.
• Produce and maintain program code and documentation me.e. preparing and submitting Logical Data Modeling (LDM),Physical Data Modeling (PDM) Documents to the Client.
• Experience in preparing source to target mappings and design documents using Data Warehouse Dimensional modeling.
• Created Master scripts to load data into Master Tables.
• Performed database recovery in various scenarios ensuring least downtime.
• Performed health checks on the database at periodic intervals.
• Tuned database performance using awr, statspack, custom scripts.
• Analyzed explain plans extracted from OEM/trace (tkprof)/plan table.

Confidential, Boston -MA

Sr. Oracle Developer

Environment: Oracle Reports Builder 11g, Oracle 11g, PL/SQL Developer, Lotus Notes 8.5, ShareNet, KMSites (KEDB, KMDB)

Responsibilities:

• As a Production Support DB - Interacting wif Business Development groups for maintenance and enhancement of the database as per the Service Level Agreement..
• Analyzed the Functional Specification provided by the Architect and created Technical Specs documents for all the mappings
• Analyzed and fixed the data discrepancies between various systems and identified bad data caused due the data migration from various legacy systems.
• Created PL/SQL Stored Procedures, Functions, Packages, and Triggers, extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects to improve performance.
• Exporting/Importing the 11G Databases through export/import data pumps.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Effectively used Triggers to track the user profile updates and to send the messages to downstream systems.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Coordinate wif offshore team and client, update daily status reporting to client.
• Monitored 24x7 production instances; supported over 10 development / QA instances.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred..
• Extensively used Oracle Enterprise Manager to monitor the multiple instances, SQL loader for loading data to databases, export/import utilities for data transfer between schemas/databases.
• Managed user accounts and ensured security of databases using roles and privileges.
• Responsible for monitoring the scheduled JOBS and fixing the issues encountered.
• Supporting EQSYS server which used to generate the Excel Reports for users.
• Handling report Failures during the Batch Run and fixing it.
• Interacted wif front end developers and worked accordingly to facilitate report requirements.
• As per user requirements generated reports from the data base and maintained customer viewpoint.
• Created new forms based on UI (User Interface) requirements.
• Changed pre-existing forms to enhance screen functionality.
• Changed forms to incorporate new parameters for data blocks.
• Created new form triggers (like when-validate-trigger) to handle customer input validations base on one or several combination of conditions.
• Developed automated scripts to execute pl/sql packages and procedures.
• Created different Fact and Dimension tables to increase the performance of complex SQL queries dat are used in reporting.

Confidential, Irving-TX

Project Engineer

Environment: Windows XP/2007, Oracle 10g,11g, 9i, PL/SQL, SQL, Core java, Jquery,BMC Remedy, HP WAH Application

Responsibilities:

• Developed Oracle Application using the System Development Life Cycle (SDLC) stages and AGILE methodology.
• Analyzed and designed solutions based on stakeholder requirements.
• Designed Conceptual and Physical Database Model (CDM - PDM):
• Defined primary key, foreign key, secondary keys, cardinality, and indexes to provide direct and quick access to rows and columns frequently used in the search conditions.
• Performance Database normalization process
• Improve the performance of the slow SQL queries by implementing proper Index, using FORALL and BULKCOLLECT
• Used merge statement and parallel hints to update table wif complex and nested queries
• Fine tuned queries to optimize the application performance.
• Daily Production support /Database Maintenance wif/wifout Grid Control.
• Scripts/Automation of daily support/maintenance/monitoring activities using Shell, SQL and PL/SQL scripting.
• Participated in Database Design / Application meeting as DBA representative, Created physical & Logical models using ERWIN, created schema generation scripts, installed & maintained database objects.
• Created database link between two databases to access the table data from one local database to remote database using distributed database feature. Created snapshots for some most queried tables to get the most refreshed data. Planned and installed replication of database also.
• Improved query performance by analyzing query by creating indexes and using hints.
• Responsible for Maintaining the application availability, performance and fixing the database issues
• Done root cause analysis to identify the designing problems specific to SQL queries
• Resolved issues wif critical MLS batch jobs like GR confirmation, Inventory reports, Ware house reservations, Invoices and shipments
• Performing Unit testing at various levels for Pre-PROD and Production environment.
• Ensuring the change implementation in all pre-production and production environments.
• Updating code check in to the code repository on time

Confidential, Auburn Hills-MI

Oracle Developer

Environment: Windows NT 3.5 server workstation, FTP server, Oracle 9i,10g,11g, Service Manager 7, HP Connect-IT, Mail System - MAPI, NAIP systems

Responsibilities:

• Provide Oracle DB support for multiple large databases in production, development and test environments.
• Refreshing development/test database from production using Export/Import & RMAN backups.
• Loaded the data into database tables using SQL*loader from TXT and CSV files.
• Wrote SQL Loader control file for flat file data from other departments and scheduled them in UNIX to load every night in Production Environment.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Created/modified oracle procedures, packages and functions to move the change data across multiple environments using Database links.
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF, Utilities, hints provided by oracle.
• Expertise in performing Data export, Import and various operations using TOAD.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Created MSS FTP connections on new servers. Set system environment variables and updated registry values
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Created database tables and the sequence used for generating unique identifiers
• Removing duplicate entries for data bases, updating the server names and ports, checking MLS and MSS table spaces
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Written unit test cases and executed them to test the functionality of the data bases
• Used various LOVS (List of Values) and record groups at various points in runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Performed root cause analysis, and make recommendations for the remediation of data quality issues.
• Interacting wif Testing team and service delivery team and resolve their functional needs.

Confidential

Oracle Developer

Environment: Windows NT 3.5 server workstation, FTP server, Oracle 9i,10, Service Manager 7, BMC Remedy, SDWF

Responsibilities:

• Involved in development and unit testing.
• Development task creating database objects like tables, indexes, sequences, constraints on tables, their respective synonyms and sequences.
• Development task includes coding change requests into SQL queries, Views.
• Also developed coding logic into PLSQL procedures, triggers and functions.
• Also involved in creating database objects like tables, indexes, sequences, constraints on tables, synonyms etc.
• Involved in restructuring existing package code.
• Developed and modified a number ofFormsand for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
• Wrote Scripts forData loadingandDDL Scripts.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Involved in creating release specific deliverables, including all the database changes.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc