SUMMARY

• 8 years of experience in various phases of Software Development life cycle including Designing, Development, Testing and Production Support using Oracle SQL, PL/SQL, and UNIX.
• Expertise in Oracle SQL, PL/SQL, Oracle Forms and Oracle Reports
• Extensive knowledge in design and support of ETL Jobs using tools like SAP BOBJ Data Integrator, Informatica, DataStage and SSIS.
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Developed various Unix Shell Scripts to manipulate data files, set - up environment variables, custom FTP utility and file archiving.
• Extensive work experience on Oracle 11g/10g/9i/8i and SQL Server databases on UNIX, Linux and Windows enterprise platforms.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
• Experienced in using developer tools like TOAD for Oracle, DBArtisan and PL/SQL Developer.
• Strong experience with Unix Shell Scripting (KORN, Bash).
• Providing assistance in logical/physical data modeling using ERWin Data Modeler r7/r8.
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Strong understanding of object-oriented JavaScript
• Good knowledge in XML, HTML and CSS

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX

Languages: SQL, PL/SQL, Shell Scripting, XML, Delphi, C, C #, HTML 5

RDBMS: Oracle 9i/10g/11g, MS SQL Server 2003/2005/2008

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, XML Publisher

Utilities: Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, WinSCP SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, WinstonSalem, NC

Oracle Forms & Reports Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Created various Database triggers using PL/SQL.
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Developed screens and reports using OracleForms 10g/Reports 10g
• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
• Designed ETL Jobs using SAP BOBJ Data Integrator.
• Provided On-Call support for ETL and other maintenance jobs.

Environment: SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g/11g, Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g

Confidential, Plano TX

Oracle PL/SQL Developer / Data Modeler

Responsibilities:

• Wrote PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• As a team member interacted with Business Analysts, Data Architect and client representatives for requirements gathering, research and solving client specific data issues.
• Written complex SQLs and procedures using joins, sub queries and correlated sub queries. Tuned the queries and stored procedures for better performance.
• Created different schemas and maintained schema objects. Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Extensively used UTL FILE, an oracle built in function to transfer data from the source system to flat files to conversion staging area. Utilized Partitions to fine-tune SQL data load.
• Optimized SQL and PL/SQL performance using Explain Plan, SQL-Trace and TK-Prof.
• Involved in creating Database Design Relational models using ERWin Data Modeler r7.
• Designed Conceptual, Logical and Physical models for a Snowflake Schema.
• Created Surrogate and Alternate Keys.
• Used Third Normal Form (3NF) to design the Data Model.
• Worked with Data Architects in maintaining versions of Data Model in ERWin Model Manager.
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional and fact tables.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Implemented complex Interface business rules using Oracle Database Triggers constructs.
• Extensively used dynamic SQL. Used INDEXES andHINTS for better performance of queries.
• Extensively wrote UNIX Shell scripts for clean-up, logging, file manipulation and to automate the data load from SQLLDR to staging table.
• Created database tables, views, indexes and constraints Used Toad as an advanced SQL-PL/SQL editor.
• Performed functional testing for the procedures and packages.
• Involved in creating INDEXESto avoid the need for large-table, full-table scans and disk sorts and for fast retrieval of data from database objects.
• Involved in generating Web Intelligence Reports to satisfy Ad-Hoc request.
• Participated in code walk and review sessions with the Development and QA team.

Environment: Oracle 9i/10g, SQL* Plus, PL/SQL, CVS Version Control, TOAD for Oracle, SQL SERVER 2005/2008, Microsoft Visual Studio, ERWin Data Modeler r7, Windows XP, UNIX.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Creating database objects like Tables, Synonyms, Sequences and Views.
• Created and modified Procedures and Functions to suite the improved business requirements.
• Created records and nested tables in the procedures for handling of data.
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from Cursor/ Ref Cursors
• Creating and working with GTT (Global Temporary Table)
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient.
• Using Set operators in PL/SQL like Union, Union all, Intersect and Minus
• Experience with DBMS UTILITY.FORMAT CALL STACKand DBMS UTILITY.FORMAT ERROR STACK
• Performed Exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle Optimizer, Explain plan and Hints to improve the database performance
• Support for the Development, Test and Production databases

Environment: Oracle 9i (SQL, PL/SQL), Oracle Developer Suite 10g, Oracle forms 9i/11g, Oracle reports 9i/11g, TOAD 9.0, Erwin 4.0, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed /developed the screen which cross checks the data with the master details Using Forms 5.0.
• Developed the Interest Warrant Printing program using Pro*C, the program would necessarily generate a file in the designated Unix directory, but when the file is fired of to the printer it would print on a Pre-Printed stationery, the printing would happen at the exact slots allocated in the stationery for the designated columns, calibrating the form feeds, which involved extensive study of printer control sequences.
• Generating Bank Statement with the summary of all lots for both Interest/Interest for all the companies Using C, Pro*C, UNIX shell scripts, and Report Writer.
• Checking the Tablespace size for smooth transaction of the records.
• Data migration and backup of database Using Import/Export, which was performed using Shell Scripts.
• Analysis business rules and user requirements in existing systems.
• Primarily responsible for developing specs and coding Oracle Subprograms, Procedures, Functions, Triggers, UNIX scripts, which would retrieve the data and perform database checks.
• Helped DBA in tuning the database and existing applications using explain plan.
• Technical support for data mart involves creating, scheduling and maintaining various oracle objects using SQL, PL/SQL.
• Developed various number of daily, weekly and monthly reports for the business using SQL*Reports.
• Creation of users, allocating resources, granting privileges and roles.

Environment: Oracle 8i, Pro*C, UNIX, SQL*Plus