SUMMARY

• 8 years of IT experience as an Oracle PL/SQL Developer in Analysis and Implementation of Business Applications using Oracle Relational Database Management System Programming experience in Oracle 11g, 10g, 9i, 8i, SQL, PL/SQL and Performance tuning.
• Extensive work experience in Client - Server application development using Oracle 11g/10g/9i/8i, Forms 9i/6i, Reports 10g/9i/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Discoverer 9.1, Oracle Import and Export Utilities.
• Used Oracle Apex to design Web pages, Forms and Reports
• Experience with LOB datatypes by working on large blocks of data.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Experience in implementation and maintenance of database design, creation of database objects, Procedures, functions and triggers.
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through WSDL.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experience in Financial Analysis and Financial Reporting.
• Expertise skills in using the tools TOAD 9.0.1, SQL * Loader, Oracle SQL Developer
• Data Transformation using Informatica.
• Designed and developed custom built applications using different Oracle products
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation and Data retrieval module documentation
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Extensive working knowledge in developing Database Triggers, Stored Procedures, Functions for developing Forms Reports and working in an AGILE team .
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Extensive experience in using Cursors and Ref-cursors for processing of data .
• Good Knowledge on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V-arrays, Records and Types.
• Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
• Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
• Extensive usage of Oracle collections and standard API’s like DBMS LOB, UTL FILE etc for business logic in user defined API’s.
• Expertise in dealing with complex data models and object relational database mapping, while producing complex reports
• Good Exposure to UNIX shell scripting.
• Expertise in developing outbound and inbound interfaces.
• Hands on experience in Data migration (ETL) across different databases via SQL scripts.
• Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
• Experience in requirement gathering, gap-analysis and solution design.
• Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
• Hands on experience as support engineer in a production support environment.
• Thorough understanding and exposure to software lifecycle development in both waterfall and agile methodologies.
• Possess strong communication and problem solving skills developed through a variety of projects over a period of time.
• Great team player and ability to work collaboratively and independently as required.

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows

Database: Oracle 9i/10g/11g, MS SQL Server and MS Access

Tools: Oracle APEX, SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, Oracle Forms and Reports 10g/9i/6i, Erwin r7.1/7.2

ERP: Oracle Applications R12.

Languages: SQL, PL/SQL, JAVA, HTML, XML, PERL 5.8 and shell scripting

Tracker Apps: BMC Remedy, BugZilla

Version control: PVCS

Office Tools: MS Office and Generic text editors.

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Senior Oracle PL/SQL Developer

Responsibilities:

• Involved in Oracle development (Data Base) by creating Oracle PL/SQL Functions, Stored Procedures, Triggers, Packages, Records and Collections.
• Created .SQL scripts to handle new processes.
• Extensively worked in data transaction, transformation, loading data from various sources like Oracle, SQL server and Flat files.
• Worked in creating various critical business reports like describing the financial status of the company
• Strong experience in writing Perl scripts covering data feed handling, implementing business logic, communicating with web-services through WSDL.
• Developed Perl scripts to automate frequent reports for the users
• Developed wrapper scripts in Unix shell script for the AUTOSYS batch jobs
• Worked as ADBA having experience in implementation and maintenance of database design, creation of database objects, Procedures, functions and triggers.
• Worked with project team to deliver OLAP solutions to provide robust high availability and performance.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Used to monitor Application related jobs and data replication activities
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• Created Records, Tables, Objects, Collections, Views, Materialized views and Global temporary tables (Nested Tables and Varrays), and performed Error Handling.
• Extensively used Cursors, Ref Cursors, Dynamic SQL and Functions.
• Participated in Performance Tuning using Explain Plan.
• Designed and developed custom built applications using different Oracle products
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation and Data retrieval module documentation
• Application framework design with respect to convenience of the end user
• Application diagnosis and performance tuning and generating reports for clients
• Used HINTS to improve performance of the SQL
• Involved in development of process using SQL* LOADER, PL/SQL Package.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader
• Extensively used TOAD, SQL PLUS, SQL Developer and PLSQL developer for programming purposes.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Created numerous forms as in process for application development.
• Designed CUSTOM forms and reports in order to meet the Business requirements.
• Fixed Bugs during development/testing and Production phases.
• Created UNIX Shell scripts for Batch processing and job scheduling.
• Demand forecasting and workforce scheduling has been done by using Click.
• Fixed errors ad hoc reports using Discoverer 10g.
• Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 10g.
• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Involved in database modeling and database design
• Involved in interacting with the end-user (client) to gather business requirements.
• Involved in Technical Documentation, Unit test, Integration Test and writing the Test plan.
• Involved in 24/7 on call production support.
• Used Team tracker to track development progress.
• Used Toad Comparison Utility for identifying the changes in packages, procedures.
• Used Forms Compare tool to compare the difference between forms.

Environment: Oracle 11g (SQL, PL/SQL), Forms 10g, Reports 10g, SQL *Loader, Toad, Perl Scripting, Unix Scripts, HTML.

Confidential, Orange County CA

Oracle PL/SQL Developer

Responsibilities:

• Developed Complex SQL queries and written various dynamic SQL’s throughout the projects for adhoc report generation.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Involved in the migration projects by migrating the data in old structure to new structures.
• 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.
• Developed Shell scripts and schedule data loading as overnight job in cron utility.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Designed workflows to do the Extract, Transformation and Load of data.
• Actively involved in requirement gathering and review meetings.
• Analyzing the data model to understand the relationships.
• Determining the criteria for archiving and purge of each application.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Experience in writing Files using procedures for logging result.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
• Used SQL Loader to upload the information into the database and using UTL FILE package to write data to files.
• Logical and Physical data modeling using ERwin, Dimensional, Relational/ OLTP modeling.
• Used PL/SQL, SQLLoader as part of ETL process to populate the operational data store.

Environment: Oracle 11gR2 RAC, Toad 9.0, Visual Safe Source, Oracle Application Server10g, SQL Developer, SQL*Plus, SQL *Loader, Putty, Winscp, UNIX Korn and Shell Scripting, XML, Windows 7

Confidential, SFO CA

PL/SQL Developer

Responsibilities:

• Handling the data requests from multiple clients.
• Handling complex sql scripts for data retrieval.
• Generating files based on daily requests.
• Using UNIX for file transfer to client side.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Performing DML operations for daily activities.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java

Confidential

Sr. Oracle PL/SQL Developer

Responsibilities:

• Assisted Confidential lines of business with developing compliance and maintainable technology solutions that extend existing application functionality and offer new application features to help business maximize their revenue goals.
• Involved in Data Extraction, Transformation and Loading (ETL Process) from source to target and worked on windows batch scripting, scheduling jobs and monitoring logs.
• Loaded data into oracle tables using SQL*Loader.
• Used Informatica Workflow Manager to create workflows, database connections and batches to run the mappings.
• Developed Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Involved in troubleshooting performance issues and bugs with packages, forms and reports using dbms output, Forms Debugger and Explain Plan.
• Designed Web-based ASP.NET Internet application linked to firm-side SQL databases.
• Involved in writing programs for converting Legacy data into Oracle HRMS system.
• Using packages, functions, Pro*C developed a massive custom batch program for transactional data.
• Used advanced Bulk technologies (FOR ALL, BULK COLLECT) to improve performance.
• Wrote UNIX Shell Scripts to process files on daily basis like renaming the file, extracting data from the file, unzipping the file and loading them into base tables.
• Developed and published cubes to Cognos Upfront Portal.
• Involved in implementing agile methodologies.

Environment: s: Oracle 11g, SQL*Plus, SQL*Loader, TOAD, Cognos, ASP.NET, ERWIN, Oracle HRMS, Oracle OLAP, UNIX, Informatica 9.1/8.6, Cognos, Pro*C, Oracle Forms, Crystal Reports, BI Publisher, SQL Developer, Shell Scripts, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers .
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Involved in database Performance Tuning and monitoring.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions forpurposed solution and User Acceptance Testing

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Java.