SUMMARY:

• 8+ years of IT experience in developing software applications using Oracle 11g/10g/9i and its products in wide range of applications including Manufacturing, Banking and Telecommunication applications.
• 4 Years Oracle Configurator implementation experience across project cycles.
• Extensive experience in Oracle Configurator developer - User Interface Design, Rules & Functional Companions.
• Solid experience working on Oracle 11g /10g/9i/8i/8.0/7.x, Developer 2000/6i, PL/SQL, UNIX.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.
• Experience in Data modeling, Data warehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM Web Sphere Data Stage 8.x/7.x .
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers.
• Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
• Used Query tuning techniques for better performance and execution through suitable indexes, primary-foreign key constraints.
• Experience in using SQL TRACE and TKPROF tools for SQL tuning.
• Designed and extensively worked on Project Documentation. Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Having experience in working with SQL Server Reporting Tools (SSRS) and SQL Server Integration Management (SSIS).
• Experienced in SQL Loader, Export and Import and enforcing security by creating roles, granting system and object privileges on the Tables and Stored procedures.
• Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
• Experienced with SQL performance tuning and optimization using execution plans.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2008, MS ACCESS 2007

Languages: SQL, PL/SQL, C, C++

Tools: TOAD, SQL Developer 3.0, Oracle Enterprise Manager 10g/11g, SQL*Plus, SQL*Loader, MS Office 2007

Scripting: Unix Shell Scripting

Operating Systems: HP-UX 11.0,UNIX, Windows 95/98/2000/NT/XP/Vista and AIX

ETL Tools: Informatica, DataStage 8

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle PL/ SQL Developer

Responsibilities:

• Supporting more than 40 instances.
• Maintenance of production database and development database, which includes table space management, user creation, privileges, roles etc.
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Maintaining archive data on appropriate storage devices.
• Tracing, troubleshooting with database performance and tuning issues.
• Export/Import of oracle databases.
• Tuning SQL queries.
• Debugging, troubleshooting Oracle PL/SQL packages, stored procedures and functions.
• Analyzing and validating database objects.
• Coordinating with team members.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Developed packages, functions, procedures, and database triggers as part of the ETL process.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Worked on complete SDLC (System Development Life Cycle) including system analysis, high level design, detailed design, developing, coding and testing.
• Creation of database objects like tables, views, procedures, packages using SQL* Plus and PL/SQL.
• Performed Data validations and mappings Confidential staging table level.
• Assessed the efficiency of the SQL statements using SQL Trace and TKPROF.
• Developed PL/SQL functions to facilitate business functions and calculations and did required modifications to the existing once.
• Performed performance tuning of the SQL queries by eliminating redundant joins, creating functional indexes, removing redundant code.

Confidential, West Des Moines, IA

Oracle PL/ SQL Developer

Responsibilities:

• Involved as a key team member for Requirement Analysis during the design phase and developed various Design documents according to the user requirements.
• Worked with Data warehouses, Data marts and subsets of data for reporting and data analysis purpose. Dealt with Data warehouse architectures and various concepts in data warehouses.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developed Job sequencer with proper job dependencies, job control stages, triggers.
• Involved in writing backend Packages extensively in PL/SQL.
• Involved in Code Reviews and preparing Unit test cases.
• Used Quest code tester for Oracle, a component of Toad used to identify and eliminate the costly bugs and functional errors and used right data model for the data mart based on the requirements.
• Used web services manager for policy management and security of service infrastructure.
• Maintained the data integrity and security using Integrity Constraints and Triggers.
• Optimized and enhanced the existing procedures and SQL statements for the better performance.
• Defining and reviewing the coding standards besides reviewing the code.
• Created, debugged and modified Stored Procedures, Triggers, Tables, Views and User-Defined Functions.
• Extensively involved in preparing Detailed Technical Documents from the functional specifications.
• Technical and Functional consultant for Configurator implementation.
• Rule writing in a way to avoid any maintenance inside Configurator structure in future.
• Resolving all Bugs and Publishing (Remote and Local) issues
• Used Key files to hide certain parameters from users and added key mapping entries to a key map file.
• Preparation of Checklists, identification of Test Cases and preparing Test Plans.
• Actively Involved in Integration and Deployment in Production Environment.
• Separating Tables and Indexes on different locations for reducing Disk I/O Contention.
• Extensively used EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE and HINTS.
• Used Bulk Binds and Bulk Collect.
• Designed Pragma Autonomous Transactions.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordination between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.

Environment: Oracle Database 11g/10g, TOAD, Microsoft Windows Server 2008 R2, UNIX, PUTTY, PVCS, WinSCP, UNIX. Data Stage 8 Enterprise Edition, SQL Server -2005/2008, Erwin Data Modeler r7/r8, PL/SQL, UNIX, Windows NT/XP.

Confidential, Jacksonville, FL

Oracle PL/ SQL Developer

Responsibilities:

• Involved in technical design documentation, development, unit testing and maintenance of internally developed applications.
• Consulted with analyst and technical staff to resolve business/technical issues and needs.
• Wrote detailed technical specifications for subsystems and identify integration points.
• Developed code for maintaining and/or enhancing the financial applications.
• Performed unit testing and debugging and set test conditions based on code specifications.
• Supported application throughout the Systems Development Life Cycle.
• Researched on production issues and provided documented analysis and sizing required to fix the issue.
• Provided support for financial jobs and related project work in the unit and integrated testing environments.

Environment: Oracle Database 11g/10g, Data Stage 8 Enterprise Edition, TOAD, SQL Navigator, XML, HTML 4, PUTTY, MS-Windows 2003.

Confidential, Irving, TX

Oracle PL/ SQL Developer

Responsibilities:

• Design Technical Specifications from Functional Specification (Detail Design) documents.
• Mapped the extracted data from source systems and load it into the target systems after applying the required transformations using ETL tool Informatica Power Center.
• Use SQL*Loader/Perl Script to load data from various sources into an Oracle database.
• Wrote PLSQL programs required to retrieve data from the Data repository using Cursors, UTL File I/O and Exception handling.
• Wrote PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Involved in Integration test, System test and Implementation.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Created numerous web based Forms and Reports.
• Designed, developed and tested Reports using Report 6i and Discoverer 4i.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts.
• Developed Forms, Packages, Triggers and Shell Scripts to load the staging table data into Traffic Mart System.
• Writing scripts to create partitions, exchange partitions, analyze for performance tuning.
• Developed packages, functions, procedures, database triggers as part of the ETL process.
• Worked with Star schema and Snow Flake schema.
• Used UTL FILE (file handler), DBMS JOB, DBMS ALERT and other utility built-in Packages in PL/SQL.
• Proficiently developed test cases in Quality Center.
• Extensively developed complex PL/SQL packages for Pricing.
• Written complex SQL using joins, sub-queries and correlated sub-queries.
• Created Informatica Mappings with PL/SQL procedures to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected and Unconnected lookups, Filters, Sequence, Router and Update strategy.
• Used debugger to test the mapping and fixed the bugs.
• Applied Performance Tuning logic to optimize session performance.
• Attended business user sessions to make changes in warehouse loads.
• Involved in production support during deployment.
• Developed shell scripts for batch processing and database transactions.
• Tuning SQL Statements, PL/SQL Packages, Triggers, Functions and Procedures.
• Application Testing and Documentation in the upgrade of Oracle 9i to 10g.
• Involved in Database performance tuning using Explain plan.

Environment: Oracle 9i/10g, Oracle Application Server 10g, PL/SQL Developer, TOAD, MS-Windows 2003, UNIX, PUTTY, PVCS, WinSCP, Unix Shell Scripting, Quality Center

Confidential

Jr. Oracle DBA/ Developer

Responsibilities:

• Installing new versions of database software and perform maintenance functions of the database.
• Compiling and debugging packages with in-house code, and assisting the developers
• Wrote Scripts to perform HOT/COLD backups.
• Participated in requirement gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) with business users using ERWin Data Modeler.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created Users and maintained security with Roles and Privileges.
• Cloning/Refreshing databases from hot/cold backups.
• Setup connectivity to databases using NET 8 for clients and server side.
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus. Created indexes to improve the system performance.
• Involving in creation of triggers and handling exceptions.
• Various stored procedures were written to achieve the back end functionality.
• Analyzed performance bottlenecks and provides appropriate solutions.
• Wrote various scripts in PERL and SHELL for database health and space checks.

Environment: C/C++, Oracle 8i, 9i, Oracle Designer, Solaris 5, Windows 2000/NT