SUMMARY

• Over 9 years of programming experience as an Oracle Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Experience in Data Extraction, Transformation and Loading (ETL) processes.
• Experience in Client - Server application development using Oracle PL/SQL, SQL *PLUS, Designer 2000, Developer 2000.
• Extensive experience in Oracle RDBMS design and developing stored procedures, packages, triggers, cursors using SQL and PL/SQL.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Extensively worked on developing Forms, Menus and Reports.
• Proficient in developing and customizing reports using Oracle Reports versions 6i & 9i and Discoverer 9i/10g BI Publisher.
• Expertise in tuning of procedures, packages and SQL statements and experienced in using Control -M job scheduling tool.
• Expertise in data modeling, normalization, database design, data loading, data retrieval, modification, and archival techniques.
• Experience creating SQL*Loader control programs and PL/SQL validation scripts for validating data and pre-import processing legacy data from feeder systems to Oracle.
• Used SQL* Loader and UTL FILE Packages for data conversion and interfaces.
• In depth experience in developing complex Database Triggers, Stored Procedures, Functions and Packages.
• Experience in using SQL, PL/SQL stored procedures, indexes, materialized views, shell scripting, partitioned and non-portioned tables, packages and triggers for improved performance.
• Involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Involved in programming, debugging, and unit and system integration testing of modules.
• Good knowledge on Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in analyzing and validating data migrations from the old system to highly relational database system.
• Worked in teams, involved in requirements study and design and development of database for oracle applications.
• Strong technical and functional competence and willingness to do whatever it takes to get the job done.
• Adaptable to different client situations and a quick study in the learning of new skills and methods.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000, DOS, UNIX, LINUX, AIX, SOLARIS

Programming Languages: SQL, PL/SQL, UNIX scripting, Java, C, C++

Web Technologies: HTML, DHTML, XML, JSP

Tools: TOAD, PL/SQL Developer, SQL Navigator, SQL*Developer, SQL Tools, Erwin, Data Transformation Services, Discoverer BI Publisher, Control M 8, Informatica 9.1

Utilities: SQL LOADER, UTL FILE, DBMS SQL, DBMS Packages, Rational Team Concert 5.0.2 Eclipse Client

Database: Oracle MS SQL Server, MS Access 2000

PROFESSIONAL EXPERIENCE

Confidential - Pennington, NJ

Senior PL/SQL Developer

Responsibilities:

• Worked as a primary point of contact for all Database design and development activities
• Involved in implementing business logic with Oracle-stored procedures, functions and triggers using PL/SQL.
• Involved in walk-through sessions with business users during the Analysis, Design, and development phase, written PL/SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created and maintained tables, procedures, functions, and packages, and update, delete, and insert statements and compile them.
• Involved in the Golden Gate setup for bi-directional data replication
• Involved in performance tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Worked with architects, Business Analysts, ETL developers, and QA testers to translate data requirements into the physical schema definitions for Oracle.
• Written Custom SQL scripts, Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions.
• Code review to ensure that the existing code is complaint with the coding standards.
• Deployment of the code from IBM Rational Clear case to other environments using IBM Rational Build Forge
• Bug Fixing and Defect resolution from the code logic using Oracle SQL Developer IDE
• Involved in Importing and exporting the Tables, Users, and Schemas.
• Responsible for Unit Testing and Integration testing of PL/SQL Packages, Procedures, Functions and Triggers.
• Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Expertise in DBA concepts like creating tables, table space, Grants to users.
• Used Clear case tool to manage various versions of the procedures and functions of the application.
• Provided Production Support, problem resolutions and bug fixing, actively involved in resolving the issues and coordinating with business users and resolving the issues.

Environment: Oracle 12c/11g, SQL, PL/SQL, SQL Developer, PL/SQL Developer, Toad, Unix, Windows 2007, MS- Excel 2013, IBM Rational Clear case tool, IBM Rational Build Forge, Notepad++.

Confidential, Eden Prairie, MN

Oracle Developer

Responsibilities:

• Analysis and gathering of new business requirements from the business resources.
• Worked thoroughly on coding and debugging of stored procedures, functions, packages and other Oracle objects to implement Business Rules.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Modified the existing procedures according to the new enhancements.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Was responsible for data partitioning.
• Extensively used Nested tables, PL/SQL tables to code Procedures and Functions.
• Worked on Business Objects and Crystal Reports.
• Generated new reports also modified existing reports as per the Business Rules.
• Was responsible for database connection with respect to the reports and scheduled reports as per requirement.
• Involved in job creation and scheduling new jobs with respect to Autosys job Scheduler.
• Worked with OM (Operations and Maintenance) team for migration process from Autosys jobs to Tivoli.
• Modified SQL statements to increase the overall performance as a part of performance tuning.
• Created indexes and nested tables as a part of tuning.
• Used SVN Tortise for code submission.
• Coordinated with the offshore development team who were part of IRADS.
• Interacted with production support team regarding production issues and release plans.
• Documented and transferred knowledge regarding the various projects.

Environment: Oracle 10g/11g, SAP Business Objects R2 and R4, Crystal Reports XI, PLSQL Developer, Toad, Autosys, UNIX, SSH, Teamtrack and SVN Tortise.

Confidential, Juno Beach, FL

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Reviewed and provided feedback on Requirements, Functional Specifications, Data Models, Design Documents to ensure the quality of SDLC deliverables and the quality of tests to be developed from the Preparation
• Developed reusable components and rule based engines for improving productivity using Oracle PL/SQL
• Worked on a JavaScript library that provides client-side processing of HTML Templates
• Programmed Oracle PL/SQL procedures for processing and analyzing raw data
• Created Multi-tier applications using Perl to parse data received from forms on a web page
• Provided design and implementation of Oracle 11g database schemas and stored procedures with PL/SQL wrote Unix shell script programming for automated background processes
• Automated SQL tasks through Perl DBI
• Developed materialized views and stored procedures and performed basic query optimization for these Oracle databases
• Implemented procedures to install and deploy large numbers of Linux / Unix servers
• Fixed many Unix KSH scripts for issues related to batch uploading
• Developed, tested and optimized Oracle queries and PL/SQL code for the migration of large datasets
• Worked on Stream processing for the obvious way to run SQL queries
• Created business continuation/disaster recovery plans and processes for a financial services firm's middleware operational team
• Developed mirror SQL Server databases using Microsoft Access
• Created complex functions, stored procedures and packages, Triggers by using Oracle PL/SQL
• Generated SQL and Oracle PL/SQL scripts to install, create and drop trading exchange connection database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms
• Created many batch scripts using Unix KSH scripting and scheduled in Cron Tab
• Designed and developed Oracle PL/SQL scripts for Data Import/Export
• Wrote Perl scripts with debugging features and syntax highlighting
• Performed threshold evaluation of a set of Metrics associated with the specified internal metric name
• Wrote packages using Oracle PL/SQL to access data from the database and write into and extract from flat files using SQL* Loader utility
• Created Oracle 11g Stored Procedures, indexes, materialized views, Triggers, Functions, Packages and Cursors using SQL and PL/SQL
• Wrote shell script to automate health check of the user data
• Built Complex SQL queries with unions and sub-queries
• Designed and developed Unix scripts for creating, dropping tables which are used for scheduling the jobs
• Created a session to migrate user-defined metrics (UDMs) to Metric extensions for targets
• Configured Unix systems for in applications to ensure proper functionality
• Provided production support and maintained data
• Fine-tuned database procedures and Oracle PL/SQL scripts for performance tuning
• Responsible for production support engineer also monitor ticket queues and resolve technical operation issues.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, VB 6, SQL Navigator, Crystal Reports, TOAD.

Confidential, East Syracuse, NY

Oracle PL/SQL Developer

RESPONSIBILITIES:

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Designed logical and physical data models for star and snowflake schemas using Erwin.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL query for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
• Created some Custom reports and Forms for the end users to check the details and errors.

Environment: Oracle 9i, 10g, SQL*Plus, PL/SQL, Erwin 4.1, Oracle Designer 2000, Windows 2000, Toad.

Oracle Developer

RESPONSIBILITIES:

• Worked on various interfaces and conversions during this project.
• Designed an interface program using the SQL* Loader program for importing the capital budget information from legacy systems and run the BUDGET import program for loading the data into base tables.
• Developed Packages to validate raw data from Flat Files and insert into tables.
• Involved in the data transfer, coding using PL/SQL Stored Procedures and Packages.
• Developed and integrated number of interface programs for porting legacy data into Oracle Database using SQL, PL/SQL and SQL*Loader as a tool.
• Designed and Developed PL/SQL Packages to import legacy information into Oracle.
• Converted pricing information from legacy systems into Oracle applications using SQL*Loader and pricing API.
• Documented all the conversions according to the AIM documentation standards.
• Designed and developed conversions to sustain Business Rules and Flow.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.
• Used PL/SQL Tables and Records in payroll generation process.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Involved in database development by creating PL/SQL Functions, Procedures, and Packages, Cursors, Error handling and views.
• Customized Customer Transaction Analysis Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report.
• Writing after Parameters Triggers for the Validation of the data.
• Developed various reports like Change order budget distribution report, Change Proposal Request, Change Position Report and AR History by project, Auto Status Report and Invoice Register Report.
• Developed Forms for mass update of customer profiles and profile amounts.
• Customized the Bills Receivable Transaction Batches form.
• Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process
• Defined Concurrent programs, Executable and Request Sets for the SQL scripts and attach the same to proper request group.
• Involved in Troubleshooting production problems and worked effectively with other team members to identify and address problems.
• Involved in Creating oracle database, tables, materialized view, objects with storage parameters based on quarterly growth requirements of the system.
• Altered, modified, Partitioned, dropped, created Database objects daily on a 24 X 7 production, Development, testing environments using TOAD and OEM.
• Worked with MD.050, MD.070 and CV.060 documents for Development work done.
• Involved in design, coding, development, documentation and post production support.

Environment: Oracle Database 9i, Oracle Forms 6i, Oracle Reports 6i, Windows 2000, Windows NT, UNIX, TOAD, Oracle SQL Developer, PLSQL Developer, Putty, Microsoft Outlook, Microsoft office 2000.

Database Developer

RESPONSIBILITIES:

• Worked as a programmer and effectively created Oracle PL/SQL programming using Packages, Procedures, functions, triggers, materialized views and views.
• Extensively worked on Oracle Report 6i & Form 6i and Pro*C for various enhancements.
• Worked on various report migration from Pro*C to oracle 6i.
• Re-write the exiting program with oracle new features such as Dynamic SQL, PL/SQL tables and collections.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Wrote many simple and complex ad-hoc reports using SQL Plus and SQL Navigator for the business users.
• Processed data Using both implicit cursors and explicit cursors and their attributes.
• Implemented complex SQLs using joins, sub queries and correlated sub queries.
• Prepare Unit test Cases based on Functional Requirements. Create templates for status reports, test summary and defect reports.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i and Reports 6i, Pro*C, Window 2000/2003.