SUMMARY

• 10+ years of experience with Oracle 8i, 9i, 10g, 11g R1, 11g R2, working as Oracle Developer and Oracle Consultant, developing back - end modules, such as packages, functions, procedures, triggers, object types, views, and snapshots for multitier business applications, both Data Warehouses and OLTP systems, in SQL and PL/SQL.
• Expert in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL.
• Creating and Managing the Database Objects Such as Tables, Indexes and Views
• Good experience with DBA Routine tasks can be self-serving DBA, managing users, roles, privileges, schema and objects, developing PL/SQL triggers for user access audit.
• Experience in data loading, export/import, Data Pump and backup/restore, session monitoring, providing technical support to Oracle users, Oracle Client installation, and network environment setup.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Experience in Migration from Development Environment to SAT/INTG/LOAD/TFP AND PROD.
• Good Experience in work Environment with Different Technologies Like Java, J2ee, .Net, and Mainframe.
• Good Experience in using SQL*Loader, Export, Import and Data Pump.
• 5+ years of concentrated experience of Performance Analysis and SQL query tuning, response time reducing, while designing scalable applications from scratch and maintaining existing ones, using AWR, ADDM, Profiler, EXPLAIN PLAN, TKPROF and OEM.
• Good knowledge of key Oracle performance-related features, such as cost-based optimizer, execution plans, hints, indexes, clusters, partitioning, temporary tables, v$-views..
• Experience involving Software Design and Development of Client/Server applications and n-tier architectures.
• Good exposure in working with ETL tools like Informatica.
• Experience in working with Reporting tools like Business Objects and Crystal Reports.
• Maintenance and Documentation, configuration management.
• Experience in module development and security of the databases.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Extensive and very intense SQL coding, database modeling, and development experience for OLTP database and OLAP database.
• Experience using SQL*Navigator and TOAD for query building and analysis and manipulations of databases for checking compatibility and integrity of RDBMS.
• Fair understanding & working knowledge in UNIX - Shell Scripts.
• Experience in supporting the various production issues addressed by the users from the client side and providing them with required solutions.
• Extensive experience in working with end users and documentation of business process.

TECHNICAL SKILLS

Oracle Tools: TOAD, ORACLE SQL Developer, Oracle Jdeveloper,Putty.

Oracle Utilities: Export/Import, Data Pump,SQL*LOADER

Languages: C,C++,HTML,Shell Scripting, korn-shell,SQL, PL/SQL, T-SQL,COBOL,JCL,CICS,Java,Jsps,Servlets.Struts.

Databases: Oracle 11g/10g/9i, SQL Server, Tera Data,DB2,Netezza

Microsoft Tools: MS- Visio, MS-Office

Internet Tools: XML, XSL, JavaScript

Operating System: UNIX, Red Hat Linux, Windows 9x/XP, MVS.

ETL and Reporting TOOLS: Informatica, Data Stage,cognos,Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Oracle PL/SQL Lead

Responsibilities:

• Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Involved in Designing data models using Erwin.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance
• Developed, modified and optimized complex queries for data retrieval and modification.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Created UNIX Shell scripts to Import and Export data and user schema.
• Tuned SQL queries and complex procedures to improve performance
• Used SQL*Loader to load data from flat files into Oracle database.
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Performed Dimensional Data modeling and created Star Schema and Snow Flakes Schema data model to meet the OLAP needs (dataware housing).
• Involved in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.
• Extensively used Quality center to Run test cases and to report and track defects.
• Used Relational Clear Case for source and version control.
• Involved in Unit Testing for the application.
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment: Oracle 11g, Sun Solaris 10(UNIX), SQL, Erwin, SQL*Plus, TOAD, Quality Center, SQL*Loader, Relational Clear Case, XML, Sql Developer.

Confidential, Harrisburg, PA

Oracle Database Developer/DBA

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Study and Understand the Existing data model like logical (LDM), physical (PDM) and entity relationship diagrams (E-R).
• Created, Monitored and implemented the solutions as required in a Service Request (SR’s).
• Developed the PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support and Enhancements or changes in the Existing open systems Application.
• Worked extensively on creating tables, Indexes, Views, stored procedures, functions, triggers and packages As for the Business Logic of the application.
• Written the Complex SQL Queries As for the data Request from the client and Open System Developers.
• Written SQL and PL/SQL Involving in Tuning Complex SQL Queries For Better Performance in Database Objects.
• Extensive Usage of Toad and SQL Developer for Execution of the database Objects (Procedures and Functions) and to Develop changes or Modifications for Existing objects in Different Environments.
• Created the Control Files to load the data (Mainframe Systems) from flat files (Mainframe files) to open systems Using SQL LODER.
• Involved in creating and modifying the existing database packages stored procedures and Functions As for the Enhancements and changes for the application.
• Experience in Migration from Development Environment to SAT/INTG/LOAD/TFP AND PROD.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Performed database tuning with Stats pack and AWR Report.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Experienced in creating Materialized views and tuning them.
• Created tables, indexes, views, sequence, synonyms.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, SQL Developer, Toad, PUTTY, Informatica, Netezza, Cognos, SQL plus, PL/SQL Developer, Autosys, clearcase,mainframes,Java, .NET,Oracle Enterprise Manager (OEM), RMAN, Data Guard.

Confidential, Washington, DC

Oracle Database Developer/DBA

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Involved in the design of the flow and entity relationship diagrams.
• Created, Monitored and implemented the solutions as required in a SR‘s.
• Developed packages for inserting values into various tables.
• DBA activities including creation, management, startup and shutdown of Oracle databases, management of data files, redo log files, control files, table spaces, segments, extents and data blocks & physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles & resources and setting of init.ora parameters.
• Develop PL/SQL Stored Procedures, Packages, and Functions & Database Triggers to support the upgrades in the application.
• Performed database tuning with Stats pack and AWR.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Performed User Management, and enhanced server security using roles, profiles and privileges.
• Worked extensively on creating tables, Views, stored procedures, functions, triggers and packages using PL/SQL.
• Involved in creating and modifying the existing database packages stored procedures and triggers.
• Created tables, indexes, views, sequence, synonyms.
• Created and validated Dimensional Model based on the requirements
• Support and development of OLAP database system with Customer account information.
• Planning and implementation of security user access and privileges for database objects/application data, Control user privileges within a database.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.

Environment: Oracle 11g, Sql Navigator, Toad, PUTTY, RedHat Linux 5, Netezza, Informatica, SQL Plus, PL/SQL Developer, Autosys, java, Oracle Enterprise Manager (OEM), RMAN, Data Guard, Oracle Streams, Golden Gate.

Confidential, Plano, TX

Oracle PL/SQL Developer/DBA

Responsibilities:

• Involved extensive interaction with the users to determine their requirements.
• Requirement gathering, analysis, designing, programming and unit testing.
• Involved in the design of the flow and entity relationship diagrams.
• Created, Monitored and implemented the solutions as required in a SR‘s.
• Developed packages for inserting values into various tables.
• Using ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Worked extensively on creating tables, Views, stored procedures, functions, triggers and packages using PL/SQL.
• Developed triggers to avoid duplication of values.
• Experienced in creating Materialized views and tuning them.
• Involved in creating and modifying the existing database packages stored procedures and triggers.
• Created tables, indexes, views, sequence, synonyms.
• Created and validated Dimensional Model based on the requirements
• Support and development of OLAP database system with Customer account information.
• Planning and implementation of security user access and privileges for database objects/application data, Control user privileges within a database.
• Implemented the code involved in modifying the database records using nested queries and PL/SQL routines.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex system and application triggers using PL/SQL for data integrity and enforcing business rules.
• Improved performance of Application using PL/SQL Packages and Oracle in built Packages.
• Manipulated Complex Data types within PL/SQL using collections.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Created reusable transformations and mapplets based on the business rules to ease the development
• Used various Informatica Error handling technique to debug failed session
• Store data from flat files using SQL* Loader.
• Created global variables and cursors for procedures and functions through PL/SQL packages.
• Designed and instructed classes on Object-Oriented application design and development with Java.
• Used PVCS as version control tool to migrate the code from environment to environment.
• Checked the data for data cleansing purpose (for data consistency)
• Used TOAD for faster application design and developments.
• Extensively wrote shell scripting.
• Involved in code reviews and mentoring and transfer of knowledge to the existing staff
• Used SQL*LOADER, Fast Load, Multi Load,T-Load extensively to perform ETL processes from flat files to the staging tables.
• Involved in Performance tuning on the new databases.

Environment: Oracle 9i/10G, Informatica, Business Objects, SQL * Plus, PL/SQL, TOAD, java, Mainframes, DB2,Oracle Discoverer 10g, Crystal reports 7.5, MS Office, MS ACCESS, MS Visio, Windows XP, SOLARIS, AIX-UNIX, CITRIX, HP-UNIX .

Confidential, Miami, FL

Oracle Pl/Sql Developer/DBA

Responsibilities:

• Worked on specification requirement study and documentation with team of researchers
• Analysis of user requirements and transform into physical database structures.
• Prepared the detailed design document.
• Experience in Data Modeling using tools such as ERWIN and MS Visio.
• Using ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages using PL/SQL.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages
• Use of dynamic SQL development of shell scripts and PL/SQL stored procedures, functions, packages and Oracle Reports with different output formats like PDF XML CSV etc.
• Constant monitor performance tuning of the database.
• Constant Tuning included all SQL's in scripts.
• Test Recovery scenarios as database data was critical.
• Performed unit testing and integration testing.
• In depth knowledge in database design creation and management of schemas writing, stored procedures, functions, triggers, DDL, DML, DCL SQL query performance tuning with hints using ORACLE 8.x 9.x 10G
• Validated additional constraints on the form which calls the stored procedures and triggers for form failures.
• Developed numerous triggers rules and stored procedures under Oracle 9i utilizing PL/SQL.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages.
• Worked on UNIX Shell Scripting to migrate objects.
• Used Citrix to connect to the client system remotely.
• Involved in mentoring and transferring of the knowledge to the existing staff.
• Involved in code walk through and review sessions with the development team.
• Involved in functionality walk through and review sessions with the testing team
• Also have experience in working with SQL * Loader and UTL FILE to Convert Legacy System into data warehouse system.
• Extensively used oracle packages, stored procedures, sequences, ref-cursors, dynamic queries, UTL Files, bulk inserts, exception handling DB Links etc.

Environment: Oracle 9i/10g, Informatics, SQL * Plus, PL/SQL, TOAD, java, Mainframes,Java, Office, MS ACCESS, MS Visio, Windows XP, CITRIX, SOLARIS, AIX-UNIX, Oracle discoverer 10g .

Confidential, Dallas, TX

Oracle Pl/Sql Developer/DBA

Responsibilities:

• Responsibilities: Involved in requirements study technical analysis and database design & tasks identification.
• Good Exposer in using Data Modeling using tools such as ERWIN and MS Visio.
• Using ERWIN for Logical and Physical database modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Created tables PL/SQL procedures, functions, Triggers and packages wherever required for the application.
• Writing the stored procedures checking the code for efficiency
• Tuning SQL Queries to get the best Response Time.
• Performance tuning was extensively done using EXPLAIN PLAN and TK PROF to reduce the execution times of the queries.
• Responsible for documentation useful for training of end users on newly created applications.
• Developed Interfaces using PL/SQL.
• Worked on UNIX Shell Scripting to migrate objects.
• Develop procedures, functions, packages using Inline views, Materialized views, Dynamic Sql to create reports and views for the Hyperion planning and essbase system.

Environment: Oracle 9i/ 10g,PL/SQL, SOLARIS, AIX-UNIX, Redhat Linux, CITRIX, TOAD, MS Visual Studio, MS Office, MS Visio, Windows XP, oracle discoverer 10g

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Extensively involved in PL/SQL programming on Oracle 9i database engine.
• Provide database design support for new system development set.
• Set oracle standards for object names and usage.
• Using ERWIN for Logical and Physical database Modeling, and UML methodology and Use Case design approach using Rational Rose Unified Process.
• Worked extensively on creating tables, Views, sql stored procedures, functions, triggers and packages using PL/SQL.
• Used TOAD as an Oracle developer tool.
• Extensively worked on database cursors and collections in Oracle database.
• Proficient in using SQL * Loader to transfer data from operating system flat files to the Oracle database.
• Tuning SQL queries & use of range/list partitioning and materialized views.
• Created Korn Shell scripts for SQL Loader programs and to kick the concurrent programs as batch manager on regular basis.
• Worked on UNIX Shell Scripting to migrate objects.

Environment: Oracle 9i/10g, AIX-UNIX, SOLARIS, TOAD, SQL * PLUS, PL/SQL, Java, MS Office, Windows XP.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Historical data conversion and migration from old data warehouse (Oracle 8i/10g) to New data warehouse (Oracle 10g ) from BI analytics and Baan LN use .
• Created PL/SQL packages to extract and transform legacy data.
• Worked extensively on creating tables, Indexes, Views, stored procedures, functions, triggers and packages As for the Business Logic of the application.
• Prepared the technical specifications.
• Involved in the Design and development of script files for Tables creation, Procedures, Packages, Functions, and Triggers for the application.
• Involved in the development by working with the team under guidance of team leader in supplying customization rules and development of the project.
• Store data from flat files using SQL* Loader
• Queries are run on the metadata that is migrated to Highview as searchable indexes
• Maintenance and Updating of Oracle database
• SQL query and PL/SQL programming Performance Tuning
• Preformed the analysis to determine to what extent data cleansing is needed for the data conversion.

Environment: Oracle 8i/9i AIX-UNIX, RedHat Linux, SQL, PL/SQL, Oracle Developer suite Windows XP

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved with writing the specifications and Analyze the code and design document
• Designing the data entry forms
• End to End Software Development Life Cycle (SDLC)
• Wrote the import program for importing data from the text files into the database
• Involved in designing and developing business services components
• Involved in the design of Technical design document
• Worked extensively in Tuning SQL statements to optimize the performance.
• Extensively involved in gap analysis
• Wrote PL/SQL scripts for creation of procedures, triggers.
• Created oracle forms inbound screen, claim screen, claims report screen.
• Support of OLTP database system with claims information.
• Created stored procedures for adjudication purposes.
• Created balancing report.
• Creating Perl script for automation of data loading processes
• Performed user testing, load testing.

Environment: Oracle 8i/9i, PL/SQL Developer, J2EE (Java Servlets, JSP Java Beans), Windows XP, UNIX / LINUX.