SUMMARY

• Over 7 years of strong technical experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL and Unix Shell Scripting that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Strong programming experience in creating Procedures, Packages, Cursors, Functions, Triggers and other database objects using SQL and PL/SQL.
• Proficient in writing and tuning complex SQL statements.
• Extensive experience in using Oracle utility tools like SQL*Loader on UNIX platforms.
• Extensive experiences in writing UNIX shell scripting.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating external tables to manage data which is store at the OS level.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning
• Expertise in technologies like Business Objects, Business Objects Dashboards, Informatica, and COGNOS
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Experience in retrieving data from Business Objects Universes, Personal Data Files, and Stored Procedures.
• Experience in creating SQL*Loader scripts to load data into temporary staging tables.
• Experience in ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications.
• Involved in designing Oracle Forms 6i/10g and Reports 6i/10g by interacting directly with End Users and Business Analyst.
• Expertise in design and development of Interface Programs.
• Knowledge of SDLC life cycle, concepts and worked on different stages of the life cycle.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS - SQL Server, DB2, MS Access, MySQL

Scripting: UNIX Shell Script, SQL, PL/SQL, Unix DB2, T-SQL

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

GUI Tools: Reports 6i/10g, Forms 6i/10g

ETL Tools: Informatica PowerCenter

Reporting Tool: Business Objects, Crystal Reports, Cognos

Other Tools: SQL*Plus, SQL*loader, SQL Developer, TOAD, Clear Quest

Operating Systems: UNIX, Linux, Windows Vista/2000/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

Oracle Developer

Responsibilities:

• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Read data from flat files to oracle tables using SQL*loader.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Depending on the requirements, designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures.
• Used TOAD, SQL developer, Rapid SQL tools for faster application design and developments.
• Prepared all designs and code for various Cognos reporting objects and ensure compliance to all best business practices in industry.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in database development by creating Oracle PL/SQL Packages, Procedures, and Functions, Ref cursors, Error handling and Triggers.
• Developed Shell Scripts to automate the process of transmission of files between the Oracle Applications and External system.
• Created control files for SQL*Loader and DDL/DML scripts for user/role management and data loading.
• Coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Interaction with development team in fine tuning the SQL and PL/SQL code by creating indexes, re-writing queries and analyzing table’s data to update statistics

Environment: Oracle 11g, PL/SQL, SQL* loader, PL/SQL Developer, Oracle Forms 9i/10g and Reports 9i/10g, UNIX, Windows 2003, Toad.

Confidential, Reston, VA

Oracle Developer

Responsibilities:

• Used Oracle as back-end database and SQL to validate the data in the output Tables/ Flat files are correctly populated.
• Involved in exporting data from SQL Server into Oracle by generating flat files and then loading data into Oracle database using SQL*loader.
• Involved in database development by creating Oracle PL/SQL Packages, Procedures, and Functions, Ref cursors, Error handling and Triggers.
• Wrote procedures to parse XML data and store in database tables.
• Utilized SQL*Loader to load flat files into database tables.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the data warehouse for Oracle 10g database.
• Involved in developing UNIX shell scripts required for maintaining the data Models and processing job.
• Worked on Oracle Enterprise Manager to look into performance issues.
• Interacted with the business users and collected the requirements.
• Involved in validating the database privileges, developed complex SQL statements reports.
• Loaded data from different Sources into Temp data backup environment using UTL FILE.
• Developed various Complex Queries, Views for Generating SQL Reports.
• Involved in customizing some reports with the user specifications using Oracle Reports.
• Using SQL trace utility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.

Environment: Oracle 9i/10g, SQL*Loader, Oracle Reports 9i, MS Excel, UNIX, MS SQL Server 2000, UNIX, Explain Plan, TOAD

Confidential, Northwales, PA

PLSQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Reduced processing times of SQL queries, night batch jobs by reviewing PL/SQL code, modifying database parameters.
• Developed validation programs to validate the data before importing into the sales table.
• Monitor database and system backups, developed Oracle Stored procedures, functions, packages, and triggers that pull data for reports.
• Involved in developing ETL Process to Load the Data from different sources.
• Involved in tuning SQL queries by using quest control tools and manual by EXPLAIN PLAN.
• Involved in developing UNIX shell scripts for Loading Database Tables.
• Loading data from flat files into database tables using SQL* Loader.
• Writing scripts for Data Staging, Loading and cleanup process.
• Used Unix Shell Scripts and developed PL/SQL procedures and functions to extract and load data for month-end batch processing.
• Involved in the development of new procedures, functions, and triggers and also updating the old ones based on the change requests.
• Tuned queries, structure of the code and performed refinement of the database design leading to significant improvement in system response time.
• Extensively used cursors, cursor for loops to fetch the data from different tables.
• Loading data into the intermediate tables using UTL FILE and SQL*Loader.
• Used SQL*Loader to load the large volumes of data into the central database.
• Utilized tools like TOAD during development of the application.

Environment: Oracle 10g/9i, Developer9i (Forms 9i, Reports 9i), PL/SQL, SQL*Loader, SQL Navigator, Toad, Windows NT/2000, UNIX (Sun Solaris).

Confidential

PLSQL Developer

Responsibilities:

• Involved in writing Oracle PL/SQL Stored Procedures and Oracle Packages.
• Created database objects like tables, views, synonyms, indexes, and sequences
• Created, debugged and modified Stored Procedures, Functions, Packages, Triggers, Tables, Views and User defined functions etc.
• Designed and developed new forms and Reports. Customized existing Forms and Reports.
• Coordinate with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed and executed various scripts which are useful in the Data Conversion.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• Actively gathered requirements with business users.
• Involved in the maintenance and enhancement of the application.
• Created Master Screens using Oracle Forms for customer information system.
• Used shell scripting to change and modify data.
• Wrote Oracle Stored Procedures, Database triggers for automated data updates.
• Fine tuned SQL Queries using explain plan, hints for maximum efficiency and performance
• Written Unix Shell Scripts to automate Export, import and loading requirements for Data Transfer between Different Systems.
• Early stages involved working as part of a team to analyze data from customer and providing documentation and reports.

Environment: SQL, PL/SQL, Oracle8i, SQL Loader, MS-Word, MS-Excel, SQL Developer, Net Term,.

Confidential

PLSQL Developer

Responsibilities:

• Involved in SQL Tuning by creation of indexes, rebuilding indexes, and clusters.
• Developed packages and stored procedures using PL/SQL.
• Designed and developed forms and Reports using Forms, Reports.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Used SQL Loader to load data from various resources.
• Used shell scripting to change and modify data.
• Utilized tools like SQL Developer during development of the application.
• Unit testing and System testing with test cases.
• Early stages involved working as part of a team to analyze data from customer and providing documentation and reports.

Environment: SQL, PL/SQL, Oracle8i, SQL Loader, MS-Word, MS-Excel, SQL Developer, Net Term, WS-FTP.