PROFESSIONAL SUMMARY

• Seven years of IT experience in Analysis, Design, Development, Support, Administration, and Performance tuning of applications using Oracle SQL, PL/SQL.
• Developed interface programs to import data from legacy systems and excellent skills in writing PL/SQL Stored Procedures, Functions and Packages.
• Excellent skills in application development using Oracle 11g/10g/9i/8i/7.x.
• Design and generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Materialized view and Database Triggers using SQL and PL/SQL in Oracle.
• Good experience in analysis, design of database and created ER Diagrams on Rational Rose using Normalization Techniques.
• Experience in Schema Structure design, Estimation and optimization of Data Storage.
• Experience in Performance Tuning Optimization of SQL statements using various types of Hints, Partitioning and indexes.
• Strong knowledge in Oracle Cursor management, Exception Handling and also Experience in performance tuning PL/SQL using SQL Trace, Explain Plan, TkProf, Indexing and Hints and Optimizing the Oracle reports.
• Expertise skills in using the tools TOAD 9.5, SQL Loader, Oracle SQL Developer and Oracle utilities like DBMS PIPE, UTL FILE, Exp, Imp and Data pump and also Experience in Perl and UNIX Shell Scripting.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Handled Production issues with high pace and efficiency. Optimized existing queries for better performance and less impact on the database.
• Used Materialized views in places where the data has not changed very frequently and Good understanding of the star schema.
• Implemented the business rules in writing Oracle PL/SQL functions and procedures and Wrote Queries to retrieve data in XML format from the tables.
• Involved in the design of the front end application forms 6i/9i, Reports 6i/10g and Database objects.
• Used Ref cursors and Collections, Bulk Collect and Bulk Binding for accessing the huge volume of data.
• Experience in debugging, testing and deploying the applications.
• Working knowledge of Unix Shell Scripting.
• Data Conversion from Flat files to Oracle using the Oracle SQL Loader.
• Having good knowledge in Data analysis, Data warehousing and ETL techniques.
• Worked with the users to identify the business requirements and integrated them into the front end Applications and CO-Coordinating the Offshore team.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

TECHNICAL SKILLS

Data Base : Oracle 11g/10g/9i/8i/7.x, MS Access and MS SQL Server.

Operating Systems : Unix, Solaris, Red Hat Linux, Perl, Windows 95/98/2000/NT/XP/2007.

Data Base Tools : SQL Plus, Toad 9.5, Golden Gate, Informatica, Oracle SQL

Developer, SQL loader.

Utilities : UTL FILE, DBMS PIPE, Exp, Imp and Data pump.

Tools : Oracle Forms 9i, 6i, 4.5 and Reports 10g, 6i, 2.5, ERwin, Rational

Rose.

Languages : SQL, PL/SQL, C, C , Java, J2EE and Unix Shell Scripting.

Web Technologies : HTML, CSS, Java Script and XML.

Source Control : VSS, CVS, Subversion.

Methodology : Agile, Waterfall.

PROFESSIONAL EXPERIENCE

Confidential

Role: Senior Oracle Developer

Responsibilities:

• Involved in requirement analysis, preparing functional specifications, system design, development and database administration.
• Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
• Compared methods of loading data into a SWIF data base using PL/SQL and SQL Loader.
• Involved in creating Pseudo code documents for writing stored procedures.
• Involved in implementing business logic with oracle-stored procedures, functions and triggers using PL/SQL.
• Customized few forms for the Business manages to validate the data.
• Involved in designing of logical and physical data models Using ERwin.
• Involved in writing CTL files control files for SQL Loader to load the data from flat files in to oracle tables.
• Involved in Importing and exporting the Tables, Users, Schemas.
• Involved in migrating from mainframes to Oracle 11g.
• Generated XML files for data transformation to another system, used XML parsers to parse XML data.
• Written Unix scheduling jobs to run jobs at regular intervals of time.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Database Triggers.
• Expertise in DBA concepts like creating tables, table space, Grants to users.
• Used subversion tools, SVN version management to manage various versions of the procedures and functions for of the application.
• Create Subscriptions in Data Mirror with different Mapping Types.
• Experience in development, creating complex mappings using optimization techniques for the best performance load times using Informatica.
• Developed extraction mappings to load data from Source systems to Data Warehouse.
• Experience with custom development of datawarehouse, operational data store, and OLTP systems.
• Provided Production Support, problem resolutions and bug fixing, actively involved in resolving the issues and coordinating with business users and resolving the issues.
• Loaded data in Staging and Production databases.
• Used Unix Shell Scripts for Code optimization and Performance tuning of the application.
• Designed several user documents and provided training on the user documents.

Environment: Oracle 11g SQL, PL/SQL , SQL Loader, GoldenGate, ERWin, TOAD, Rational Rose, Informatica Power center, VSS, Unix, Windows 2007/XP.

Confidential

Role: Senior Oracle Developer

Responsibilities:

• Involved in analyzing and designing of database using Normalization techniques.
• Created the ER diagrams of the database.
• Worked within the business intelligence team on existing project modules to identify where improvements need to be made in order to support new requirements and/or more efficiently support existing functionality.
• Design the database tables which are similar to the Star schema and establish the relationship between them using Erwin 4.5
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developing Database Triggers to audit the sensitive data of the table along with user information and to enforce complex business rules.
• Developed SQL Loader scripts to load data in the Staging tables.
• Developed PL/SQL stored procedures, user defined functions for complex calculations and bundle them into a stored package that could be invoked from the Forms triggers.
• Extensive work with UNIX shell scripting to check financial data, move files to respective revules directories and removes old files and creates input touch files and stop to LGD server and Worked on optimizing existing procedures and functions using PL/SQL.
• Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center.
• Coding and unit testing of Informatica mappings for various stages of ETL
• Developed Informatica workflows to load the data from the source to various staffing levels like CRF, IDS Acquire and Manage Framework and from the staging tables to the respective Dimensions and Fact table of EDW.
• Wrote Procedures and database triggers for the validation of input data and to implement business rules Developed several SQL reports for the Business Users to check the post processing rules.
• Testing all PL/SQL code for logic correction and Coordinating the offshore team and Production Support for the B2NCR Application.
• Performed Unit testing on queries, procedures and functions.
• Run on the UNIX by writing UNIX shell scripting.

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, Toad 9.0.1, Informatica, ERwin 7.2, VSS, Unix, Windows.

Confidential

Role: Senior Oracle consultant

Responsibilities:

• Involved in Requirements gathering, Data Analysis, Design and written technical design documents.
• Actively participated in the whole life cycle of the project.
• Developed and maintained a reporting database application utilized in AT Ts Global Customer Care and Provisioning System.
• Coded database triggers, packages, functions, procedures using PL/SQL and maintained the scripts for various data feeds.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Optimized and tuned PL/SQL to reduce the loading process - Utilized SQL Loader to perform bulk data loads into database tables from external data files.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Worked on Performance tuning by using Explain Plan, hints and also worked on Partition tables using the Range method.
• Involved in problem analysis and resolution, troubleshooting, performance tuning and code fixes of various Stored Procedures running in development and production environment.
• Developed and managed Standard customer reports.
• Interacted with Business users and developed ad hoc reports in excel using TOAD.
• Involved in Re-engineering of the interface process.
• Involved in developing data conversion programs using SQL Loader, PLSQL and UNIX shell scripts.
• Worked with testing team, analyzed data. Created and formatted ad hoc queries to help testers to test various reports.
• Developed Perl Shell Scripting for batch process and Production Support.

Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, Toad, MS-Access, MS-Excel, Informatica, Designer 2000, Windows and Solaris.

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in analysis, Design, Development and unit testing phases of the project.
• Involved in walk-through sessions with business users during the Analysis and Designing phase, writing PL/SQL Stored Procedures, Functions, Packages to meet the business requirements.
• Create and maintain tables, materialized views Summary Tables , procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Work with architects, designers, developers to translate data requirements into the physical schema definitions for Oracle.
• Data Load from flat files into Oracle tables using SQL Loader, and PL/SQL procedures.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly monthly.
• Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.
• Incomplete and full database recovery with experience of complex recovery scenarios.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Performed a review and analysis of database deadlocks and database performance tuning.
• Conducted code walk-through internal/peer reviews on application code and other deliverables.
• Detected and corrected bugs during system integration and user acceptance testing.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Provide oracle database technical consulting and proficiency in database architecture and administration.
• Involved in designing and implementing capacity planning, backup/recovery, tuning, and monitoring strategies.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Involved in system programming Shell and SQL to automate database pickup, monitoring and other DBA functions.

Environment: Oracle 11g/10g, PL/SQL Triggers, Procedures, Functions , SQL Loader, TOAD, SQL Developer, MS-Access, CVS, Windows XP and Linux.

Confidential

Role: Oracle Developer

Responsibilities:

• Developed database objects like Tables, Views, Indexes, Synonyms and Sequences.
• Written packages, triggers, stored procedure and functions for the following module products, catalogue, billing, shipping, rejected material, purchase orders and material receipts.
• Loaded traffic data logs into staging tables using SQL loader and shell scripts
• PL/SQL coding for Exception Handling and duplicate data maintenance.
• Used Triggers in Customizing Error conditions.
• Developed UNIX Shell Scripts and PLSQL procedures to extract and load data for month-end batch processing.
• Developed PL /SQL code for updating payment terms.
• Creation of Forms, Pop-up Menus and maintaining Master Detail relationship.
• Used various LOVS List of Values and record groups at various points in the runtime.
• Involved in the design and development of User Interfaces using Forms 6i, Reports 6i and coding modules in PL/SQL.
• Development of client side program units and sharing them between multiple applications for processing business logic in the database.
• Testing all forms, PL/SQL code for logic correction.

Environment: Oracle 7.x, SQL, PL/SQL, SQL Loader, Shell script, Subversion, Windows XP and Unix.

Confidential

Role: Software Programmer

Responsibilities:

• Create and maintain tables, materialized views Summary Tables , procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Work with architects, designers, developers to translate data requirements into the physical schema definitions for Oracle.
• Data Load from flat files into Oracle tables using SQL Loader, and PL/SQL procedures.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly monthly.
• Constant monitoring and performance tuning of the Oracle database, checking the most expensive queries.
• Incomplete and full database recovery with experience of complex recovery scenarios.
• Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL.
• Performed a review and analysis of database deadlocks and database performance tuning.
• Conducted code walk-through internal/peer reviews on application code and other deliverables.
• Detected and corrected bugs during system integration and user acceptance testing.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Provide oracle database technical consulting and proficiency in database architecture and administration.
• Involved in designing and implementing capacity planning, backup/recovery, tuning, and monitoring strategies.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Involved in system programming Shell and SQL to automate database pickup, monitoring and other DBA functions.

Environment: Oracle 8i, SQL Loader, PL/SQL, SQL Plus, TOAD, SQL Developer, CVS, Windows 2000 Server.