SUMMARY

• Around 12 years of experience in Information Technology.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader.
• Expertise in leading a team of 5 resources.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Experience in building Datamarts for a Commercial Lending Banking product.
• Experience in using Crystal Reports for MIS. Reports.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages,SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Expertise in Query Tuning.
• Good understanding of oracle Data Dictionary, RDBMS and Normalization Techniques.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review.
• Functional knowledge in individual and group General Ledger, Account Receivables, Banking and Telecom domain.
• Experience working with Production and Development environment.
• Experienced in Query Optimization, Debugging, and Tuning and Improvising performance of the applications.
• Experience in working with Sequence and Indexes.
• Proficient in working with Hints and Table Partitioning.
• Hands-on experience with Oracle Reports, SQL, PL/SQL, Open Interfaces, and APIs.
• Good Understanding of GUI using JavaScript, HTML, DHTML, XML,COLD FUSION 8.0
• Thorough knowledge in software processes and involved in all phases of development life cycle
• Involved in developing Forms and Reports using Oracle9i, 10g (ORACLE 10g AS).
• Involved in preparing Integration test, Database Test for TOAD.
• Experience in Unit and Integration Testing.
• Knowledge in UNIX, and Shell Scripting.
• Knowledge of DB2 Database
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills and a Very Good Team Player

TECHNICAL SKILLS

Operating System: Windows XP/ NT/95/98/2000, UNIX.

Languages: SQL, PL/SQL, UNIX Shell Script, JavaScript, HTML, Cold Fusion.

RDBMS: Oracle 10g, 9i, 8i, SQL server 2000/2005.

GUI: Oracle Pl/Sql Developer Suite, Reports 9/10

Data base tools: TOAD, SQL*Plus, SQL*Loader,Workflow, SQL Navigator.

PROFESSIONAL EXPERIENCE

Confidential, TN

Oracle Lead

Responsibilities:

• Designing the DB structure for the entire application.
• Developed database objects including tables, Indexes, packages and procedures for the application
• Application Query tuning for better performance by adding hints, moving the business logic to procedures etc.
• Created SQL*Loader scripts to load data into temporary staging tables
• Developing package for the Application and Demo data loads.
• Worked with offshore team member in loading data to staging area. Provided all business rules for the database for loading data.
• Supported for code integration and system integration testing for this application
• Involved in handling the changes in compiling scripts according to the database changes

Confidential, GA

Sr. Oracle Pl/Sql Developer

Responsibilities:

• Leading a Team of 10 resources.
• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data. knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments..
• Supported for code integration and system integration testing for this application.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Involved in handling the changes in compiling scripts according to the database changes
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Responsible for performing code reviews
• Created SQL*Loader scripts to load data into temporary staging tables
• Utilized SQL*Loader to load flat files into database tables

Environment: Oracle 10g, SQL Server Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS,SQL Developer.

Confidential, Atlanta, GA

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Documentation HLD and LLD which includes all Business requirements and technical specifications.
• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for staging and E-Product catalog Databases and staging database. knowledge and experience in structured systems analysis and design techniques
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
• Used Explain Plan, HINTS for performance tuning of sql, pl/sql queries.
• Worked with ETL team and architect to build data model for staging area.
• Worked with business experts to understand the source data in web service systems.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.

Environment: Oracle 10g, Oracle Reports 10g, SQL, PL/SQL, Toad, Oracle RDBMS, Erwin, SQL Developer.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Involved in Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design.
• Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Worked on various backend Procedures and Functions using PL/SQL.
• Developed the forms and Reports as per the requirements.
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams using Oracle Designer.
• Involved in Shell scripts to automate the loading, balancing and extraction process
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Managing Version Control Tool like Clear Case and Start Team.

Environment: Oracle 9i/10g, PL/SQL, SQL*Loader, TOAD, Java, HTML, MS Office

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 9i, PL/SQL, TOAD and Windows 2000 server

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Data modeling for client specific requirements.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements "on the fly" at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Made timely changes and fixes to all the modules on reported problems from the database administrator.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 8, PL/SQL, TOAD and Windows 2000 server