SUMMARY

• Over 7+ years of IT experience in analysis, design and development of data warehousing and oracle related applications.
• Experienced in data modeling (Entity - Relationship and Dimensional Model) and logical and physical database design.
• Designed and Developed interfaces and conversion programs using API'S to integrate Oracle Applications modules to import data from Legacy systems and external systems into Oracle Applications using PL/SQL, SQL*Loader, UTL FILE.
• Written Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Well-versed with Advance PL/SQL concepts, UNIX Shell Scripting and Windows scripting.
• Proficient in developing Forms and Reports using Oracle Forms 6i, 10g Reports 6i, 10g Discoverer 10g/4i, BI Publisher. Deploying them to various instances, coordinating with DBA’s and testing analysts.
• Customized forms and reports as per clients requirement.
• Exposure to Data-Modeling Techniques using Data-Modeling Tools.
• Hands-on experience in business analysis, design, development, testing and implementation of Oracle Client/Server and Web based Applications.
• Managed and Tuned Databases on UNIX and Windows platforms.
• Experienced in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities.
• Used SQL*loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into Base Tables.
• Strong familiarity with AIM standards and worked on MD50, MD70, CV60 and CV80.
• Profound noledge and experience in new features like Analytic functions, Bulk Bind, Merge, Case and PL/SQL supplied packages.
• Expertise in working with Oracle 9i/10g, TOAD, SQL * Loader, Forms 6i/10g and Reports 6i/10g, Reports Discoverer 4i/10g, PL/SQL, SQL, BI/XML Publisher 5.6.2/5.6.3.
• Proven ability to plan, coordinate and implement Software Development Life Cycle processes.
• Managed Release cycles in Development, Testing and Production environments
• Strong business, analytical and technical problem solving skills.
• Quick learner & Self-directed, consistently updating with emerging trends in the industry.

TECHNICAL SKILLS

ERP: Oracle Applications EBS,R12, 11i

Databases: Oracle 10g/9i/8i, Oracle Forms & Reports 9i/10g, Performance tuningUnix, MS SQL Server 2000, SQL Server, MS Access 2000, SQL*Plus, SQL*Loader, Oracle Release 12.

PL/SQL: PL/SQL, SQL, MS SQL, SQL*PLUS, DBMS Packages, T-SQL, Oracle database design, table creations, development of Stored Procedures, Functions, Triggers, Complex Packages, Cursors, Materialized views, Indexes, Partitions in TOAD, PL/SQL Developer, SQL*Plus.

BI & Reporting: Oracle Reports 10g/9i/6i, Data reports, Oracle Discoverer, BI/XML Publisher 5.6.2

Languages: SQL, PL/SQL, C, C++, VB, Java.

Scripting: Unix Script, Perl Script.

OS: LINUX, Windows 2000, 2003, XP, 7,8.

PROFESSIONAL EXPERIENCE

Confidential, Racine, WI

Oracle PL/SQL developer

Responsibilities:

• Involved in SDLC gathering requirements from end users. Participated in system analysis and data modeling.
• Participated in code walkthroughs and review sessions with the development team.
• Coordinated with off-shore team by providing noledge transfer, walkthrough development documents with off-shore team.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using functions and cursors for common utilities. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Automated scripts by scheduling control-M jobs, by using Unix Shell scripts and windows scripting for improvement in performance of reporting.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Utilized SQL*loader to load data from external system and developed PL/SQL programs to dump the data from staging tables into Base Tables
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, REF CURSORS.
• Worked on oracle PL/SQL collections VARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Encapsulated error handling and use of autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails.

Environment: Oracle 10g, PL/SQL, SQL *Plus, Toad 9.7.2, Erwin 4.0, UNIX Shell Scripts, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Confidential, Chicago, IL

Oracle PL/SQL developer

Responsibilities:

• Designed/developed tables, views, materialized view, stored procedures, packages and functions
• Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically (UTL MAIL).
• Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Automated the processing of Banking functions like Creation of New Accounts, Deletion of Accounts, Daily transactions like deposit and withdrawal on money using various means like cash or check using Oracle Forms 4.5 and Reports 2.5 and generated various reports like the monthly account statement, daily transaction report etc.
• Involved in Registration/Migration of concurrent programs, executables, Creation of Responsibilities, request Groups, Menus, value sets, Request Sets, Forms, Functions in System Administration & AOL.
• Created lexical parameters, bind parameters, formula columns, summary columns and place holder columns in reports.
• Extensively used triggers like Report triggers(Before Parameter Form Report, After Parameter Form Report, Before Report Trigger, Between Pages Trigger, After Report Trigger), Layout triggers, Data triggers in reports.
• Created Value sets for report parameters and registered in application.
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Experience in customization of XML Publisher reports for Oracle Purchasing.
• Registered user defined tables into applications using Exec.ad dd.register table.
• Prepared test cases helped and QA team in running various test cases during Integration and System testing.

Environment: Oracle 10g, PL/SQL, SQL *Plus, Toad 9.7.2, Erwin 4.0, UNIX Shell Scripts, SQL Loader, Oracle reports 10g, Oracle Forms 10g.

Confidential, Edison, NJ

Oracle PL/SQL developer

Responsibilities:

• Worked on PL/SQL tables, array structures as a part of oracle collections for implementing business rules and for performance tuning.
• Created new database objects like tables, views, indexes and database links.
• Generated SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created the.
• Created several PL/SQL packages, stored procedures, functions, materialized views and partitioning tables.
• Written many database triggers for automatically updating the tables.
• Developed several Procedures and Database Triggers as per Business requirement.
• Imported Items from legacy system into Oracle Inventory (INV) base tables using the Standard Item Interface program. Developed Item conversion program for assigning Items to Item category set and Categories.
• Worked with defining accounting and descriptive flex fields, writing validations to custom forms.
• Utilized Oracle Forms 9i for GUI development and Oracle Report 9i for report generation with inline view and lexical parameters
• Responsible for tasks including enhancing, adding new behavior, fixing bugs and rewriting some of the business functionality
• Developed UNIX shell scripts to spawn the Loader job for daily load of data
• Developed new custom reports using Oracle XML Publisher.
• Written UNIX shell scripts, analyzed tables and indexes for performance tuning.
• Customized the standard forms in application modules using CUSTOM.PLL for hiding the fields, changing the visual attributes & prompts of the fields

Environment: Oracle 10g, SQL, PL/SQL, SQL Loader, Windows XP, TOAD 9.7.2, Oracle Forms 10g, Oracle Reports 10g.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Involved in the design, data modeling, development and testing phases of various projects and enhancements.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries),
• Wrote Stored Procedures, Functions, Packages in SQL*Plus.
• Written many database triggers for automatically updating the tables.
• Worked in creation of Sequences for automatic generation of voucher numbers.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the 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.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for the Audit Trail using Oracle 9i as backend.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Ensured that weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Creating Test scripts for the generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working noledge of PL/SQL and UNIX in Production Support.
• Post production support, Performance tuning and Query optimization for Reports and Interfaces using Explain plan.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Windows XP, UNIX shell scripts, TOAD 7.6, Erwin 4.0, Oracle Reports 6i.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Automated routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically (UTL MAIL)
• Involved in all the stages of Software Development life cycle (SDLC) - design, development, analysis, testing and deployment of application.
• Requirement Analysis, coordinating with customers to understand business issues related with the system.
• Generated SQL and PL/SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Creating synonyms to mask the owner of the object and easy management of privileges
• Automated accessing data from web using UTL HTTP
• Data extraction from files to intermediate tables using UTL FILE/DBMS FILE TRANSFER
• Involved in partitioning of very large tables using List and Range Partitioning
• Involved in transferring the data between servers using Data Pump, Export & Import
• Writing several PL/SQL subprograms (stored procedures, functions and packages) using PL/SQL records, PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records
• Involved in the maintenance and enhancement of the application

Environment: Oracle 9i, UNIX Shell Scripts, SQL*Loader, TOAD, SQL*PLUS, Windows