SUMMARY

• Having 9+ years of experience in Application Development using Oracle SQL, PL/SQL.
• Experienced in interacting with 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.
• Strong Knowledge on Oracle Architecture and Database Design.
• Excellent conceptual knowledge of Oracle10g/11g, PL/SQLand SQL.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, Oracle Forms development, Oracle report development, Unit Testing, Integration Testing, End User Training, Production Support.
• Experience in designing business requirements and modeling using oracle designer.
• Experience in developing External Tables, Joins, Indexes and sequences.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace,TKPROF,Explain Plan, Indexing, Hints, Bulk Binds,BulkCollect, Creation of global temporary tablesand table partitioning.
• Extreme Use of Exception Handling methods
• Expertise in loading data from legacy systems using SQL*Loader.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5.
• Participated in collecting the requirements, analyzing the System Requirements.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Experience with Data Modeling using ERWIN 4.0/3.5.2, SQL Server, MS Access, SQL, PL/SQL, SQL Plus, Toad, and MS SQL Server, Query Analyzer.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Extensive experience in writing SQL andWebFocus to validate the database systems and for backend database validation.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge, disciplines, tasks, resources and scheduling
• Used Crystal Reports/Access to create ad - hoc reports, store data, and create queries, tables and data views
• Experience in Data warehouse/Data Mart Development Life Cycle.
• Good experience working on End-To-End implementation of data warehouse and strong understanding of Data Warehouse Concepts, ETL, Star schema, Data Modeling, experience using Normalization, Business Process Analysis, Reengineering, Dimensional Modeling, FACTS&Dimensions tables

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g.

Scripting: SQL, UNIX, PERL.

Languages: SQL, PLSQL, HTML, C#.NET, UNIX.

Tools: SQL Developer, TOAD, SQL plus.

Applications: MS Office

OS: Windows 7, Windows Vista, XP, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Participated in project planning sessions with business analysts and team members to analyze business IT Requirements and translated business requirements into working model.
• Worked extensively on Data migration for new merchant acquired by First Data from the competitors.
• Custom reports generation based on the merchants requirements.
• Involved in Initial designing and developing web pages for various merchants.
• Generation of reports and analysis.
• Enhancements in existing reports and PL/SQL blocks.
• Extensive use of performance tuning.
• Usage of Unix commands for transferring files to merchants.
• Using import and export utilities for large data transfer.
• Worked with Business in full development life cycle for Prepaid Business project.
• And involved in developing procedures, functions, packages, triggers, views, and materialize views etc.
• Involved in Performance tuning, which included creating indexes, providing Hints, modifying tables, analyze tables and estimate stats using explain plan utility.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Involved in walkthrough sessions with business users during Analysis and Designing phase.
• Writing PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQLand TOAD.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Environment: Oracle 11g, TFS, Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, .Net, UNIX, Windows XP/2000.owb 10g

Confidential, Hillsboro, OR

Sr. Oracle PL/SQL Developer

Responsibilities:

• Handling the data requests from multiple clients.
• Handling complex SQLscripts for data retrieval.
• Generating files based on daily requests.
• Using UNIX for file transfer to client side.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Performing DML operations for daily activities.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQLand PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.

Confidential, Pittsburgh, PA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Used tortoise svn version control for changing the codes.
• Making changes to the existing apex applications in the production.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java 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.
• DevelopedUNIX Shell scripts to automate table creation, execute procedures.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/SQL blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Developed SQLand PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential, Nashville, TN

Sr. PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed Stored Procedures, Functions, Packagesand SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Used Crystal Reports/Access to create ad-hoc reports, store data, and create queries, tables and data views
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Worked with java 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.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, Crystal Reports, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential, Detroit, MI

PL/SQL Developer

Responsibilities:

• Developing SQL and PL/SQL scripts for problem solving.
• Generating reports using Report builder
• Establishing onsite/offshore communication between onsite users and offshore project teams.
• Tracking and ensuring timely deliveries as per SLAs committed to the client.
• Interacting with the client and project teams to ensure issue resolution and to provide technological and businesssolutions to the clients.
• Interacted with the Business Analysts in understanding the business requirements for the project.
• Used Crystal Reports/Access to create ad-hoc reports, store data, and create queries, tables and data views
• Gathered the requirements from the users and analyzed their business needs and created SRS documents.
• Involved in SDLC including designing, coding and testing.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Using associative array from perl programming for indexing and performance issues in Unix environment.

Environment: Oracle 10g/9i/11g, SQL, PL/SQL, SQL*Loader, UNIX Shell script, Crystal Reports, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer, UNIX, JAVA, Windows XP/2000.

Confidential

Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers .
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Involved in database Performance Tuning and monitoring.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions forpurposed solution and User Acceptance Testing

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.