SUMMARY

• Nine years of experience in Analysis, Design, Development, testing and Implementation of major business applications in different environments as Oracle developer.
• Extensive experience in Oracle 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms 6i/9i and Reports 6i/9i, Visual Basic 6.0, DB2, TOAD, SQL Navigator, Designer 2000, Oracle Portal (WebDB) and SQL*Plus in Unix, Linux and Windows environments.
• Proficient in writing and implementing SQL Queries (DDL, DML, DCL), Stored Procedures, Views, Triggers and Cursors in Oracle database.
• Strong experience in developing Oracle PL/SQL packages,stored procedures,functions and bulk Collections.
• Expertise in using SQL utility tools: SQL*Loader, TOAD, SQL*PLUS, SQL navigator.
• Good working and conceptual knowledge of Pro *C, C/C++, Java, Servlets and,XML and HTML.
• Excellent working knowledge in Unix shell scripting.
• Experience developing applications using Apex 3/0/3.2/4.0/5.0.
• Experience in developing, enhancing, modifying and/or maintaining applications using perl and shell scripting
• Hands on experience in Oracle Forms6i/9i and Reports 6i/9i.
• Developed and customized several Oracle Forms and Reports using Forms/Reports builder, XML publisher and Discoverer as per client specifications.
• Knowledge in Data warehousing concepts and physical and logical data modeling.
• Experience in Business Intelligence tools (OLAP, ACTUATE) and using ETL tools(INFORMATICA).
• Expertise in handling errors in PL/SQL program using Exceptional Handlers.
• Hands on experience with Version control systems (PCVS, SUBVERSION).
• Experience working in Waterfall and Agile software development methodologies.
• Experienced in Tuning SQL Statements and PL/SQL Procedures for enhancing the load performance of applications in various schemas across databases.
• Experience in troubleshooting problems, debugging and defect/bug fixing.
• Exposure to complete Software Development Life cycle (SDLC) such as client relationships/interactions, business requirements, project scheduling, data modeling, development (DEV), test (UAT), build/release, product support (PROD) environments.
• Highly motivated, quality minded developer, with proven ability to deliver applications against tight deadlines.
• Possess good interpersonal, analytical presentation Skills, ability to work in Self - managed and Team environments.

TECHNICAL SKILLS

Database: Oracle 11g/10g/9.x/8i/7.x, SQL Server 6.5/7.0, MS Access 7.0, DB2 8.0

Operating System: MS-DOS, Linux, UNIX, Windows XP/ NT/2000/ME

Languages/Utilities: SQL, PL-SQL, C, C++, Java, UML, Unix shell scripting

Web Technologies: HTML, Java, JDBC, EJB, Servlets, XML, JSP

Tools: Oracle Forms9i/6i/4.5 and Reports9i/6i/3/2.5, APEX, SQL*Plus, SQL*Loader,Toad, InformaticaPowerCenter/PowerMart5.1/6.1/6.2, Erwin, Actuate, Designer2000,Discoverer3x/4x, Autosys, MSOffice.

PROFESSIONAL EXPERIENCE

Confidential, MD

Senior Oracle Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Created/Designed new tables, views, queries for new enhancement in the application using TOAD.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client.
• Developed Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, functions, and triggers and handled errors using Exceptions.
• Used APEX to Design and develop User Interface forms and reports.
• Developed different types of interactive reports, SQL reports and charts based on the user requirements in APEX
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Developed several pages in the Apex application that is used for reporting and request form feeder
• Implemented JQuery tabs, auto complete feature, popup alerts and date pickers in Apex
• Used Authorization Schemes functionality of APEX to set up security on the screens in the application based on user roles.
• Created custom PL/SQL procedures to read data from flat files and load to Oracle database using SQL * Loader.
• Used Subversion SVN source control to Checkin and checkout the code.
• Developed Unix shell scipts for FTP'ng files from different servers.
• Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the code portable to any platform.
• Wrote complex SQL queries including inline queries and subqueries for faster data retrieval from multiple tables.
• Developed and customized month end reports using reports builder 10g.
• Managed Defects and Enhancements through HP Quality center.
• Involved in Production support, releases and troubleshooting the defects.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Plus, Oracle Apex 5.0, SQL*Loader, UNIX, TOAD, Oracle reports 9i/10g, CVS, Windows XP.

Confidential, Royersford, PA

Senior Oracle Developer

Responsibilities:

• Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, exception handling.
• Developed complex SQL and PL/SQL queries using joins, sub queries, and correlated sub queries.
• Involved in different phases of System Development Life Cycle (SDLC).
• Responsible for preparing detailed design documents based on the business requirements.
• Developed PL/SQL programs such as triggers, procedures, functions and packages.
• Extensively utilized the Application Object Library (AOL) to Register PL/SQL Procedures, forms and reports.
• Involved in loading external client files into database tables using sql loader.
• Developed and customized forms including Tabular, Mailing Label, Matrix & Matrix with groups.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction­Transformation­Loading (ETL) process, using SQL*Loader and
• PL/SQL package UTL FILE.
• Involved in the maintenance and Production support of existing application.

Environment: Oracle Database 10g, UNIX, SQL Navigator, SQL*Loader, Oracle Forms/Reports, PL/SQL, ETL, UNIX, Shell Scripts.

Confidential, Montvale, NJ

Oracle Forms Developer

Responsibilities:

• Gathering the requirements from Business analysts for MHS to Retail Merchandise system conversion implementation.
• Developed New Interfaces using PL/SQL packages, Procedures, Functions and triggers as per the requirement.
• Created Databse tables, Views, synonyms, indexes, sequences and database directories.
• Used External tables and Sql loader to load files into database staging tables.
• Developed New Forms for the Warehouse Inventory Management using Oracle forms 10g.
• Customising Purchase order and Receipts history forms for inventory status.
• Developed and tested UNIX shell scripts to call the PL/SQL packages and ftp the reports to client server.
• Worked on performance tuning and testing of Oracle PL/SQL Packages, procedures and triggers of various applications.
• Created/Modified Indexes as necessary to increase the performance.
• Used Hints, Joins and advanced SQL Programming techniques like analytical techniques and WITH statement to increase the performance of the reports.
• Involved in Productions support and debugging the application by quickly analyzing the root cause.
• Code Version control using PVCS.
• Extensively used Crontab in UNIX environment for scheduling batch jobs.

Environment: Oracle10g, PL/SQL, UNIX, Oracle Forms10g, TOAD, SQL*Loader, External Tables, PVCS, Performance tuning, unix shell scripting, Windows XP.

Confidential, Columbus,OH

Oracle Developer

Responsibilities:

• Interacted with the business users, collected the business requirements and analysed it based on Software Development Life Cycle standards.
• Worked with the Business Analyst to define business needs and delivered the comprehensive technical specifications.
• Modified the database, added new tables, and views to accommodate a new functionality as per the user requirements.
• Involved in load processing of the external client eligibility file into database tables using sql loader.
• Created and modified pl/sql programs, packages and procedures for specific client load program.
• Optimized and tuned PL/SQL reports to reduce the load process.
• Automating data loading, extraction and report generation using UNIX shell scripting.
• Used Quality centre and RTC (Rational team concert) for project management, planning, process track and project reporting.
• Developed batch programs using UNIX shell scripts to generate daily, weekly & monthly ATP reports
• Used Maestro Scheduling tools to schedule and run Oracle Batch jobs.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Worked on application development projects as well as enhancements and maintenance of existing applications.
• Used Subversion for check in and checkout of source code from Tag, branch of the svn repository.
• Conducts code reviews of application components developed by other staff for standards adherence, efficiency and use of best practices.
• Performed performance tuning of ATP reports using optimization techniques and hints.
• Modified Join queries for effective cost optimization and used bulk collections for better performance.
• Supported operations during the build/deployment of a new release to the Integration,QA and Production environments.
• Performed Unit test, System integration test to make sure the deliverables are match with business requirement.
• Responsible for handling production support tickets and defect fixing.

Environment: Oracle 9i/10g, SQLPLUS, PL/SQL, UNIX, SQL*Loader, Quality Centre, Lotus Notes,Tortoise Subversion, Maestro, JAVA, Performance tuning, unix shell scripting, Windows XP, Solaris and HP-9000.

Confidential, Mason, OH

Oracle Lead developer

Responsibilities:

• Designed and Modified Database tables, Keys, Indexes, Triggers, Oracle Packages, Procedures and Functions.
• Extracted, Transformed and Loaded OLTP data from sources like Delimited Flat files into the Staging area and Transformed the data according the business requirement and then Loaded into the Oracle Database
• Involved in developing and maintaining the sales data mart for Data warehouse.
• Designed and developed Load programs and packages usingPL/SQL.
• Involved in creatingpartitioning,indexeson partitions to improve the performance of data warehouse tables.
• Extensively involved inperformancetuning SQLscripts.
• Usedexternal tablesfor Data Conversions and to load the flat files from other different sources.
• UsedExplain Plain and hintsfor performance tuning.
• Involved inunit testingof the packages and developed objects.
• Modifiedshell scriptsfor executing batch jobs.
• Reviewed data transformation rules and provided technical suggestions in data transformation logic.

Environment: Oracle9i, PL/SQL, DataWarehouse, TOAD, Apex, Externaltables, Shell Scripting, Unix, Windows.

Confidential, New York

Oracle Developer

Responsibilities:

• Designed and implemented the login management tables.
• Implemented Security by creating different Users, and assigning Roles to Users.
• Involved in Design and Development of data entry screens.
• Created Data Structures including Tables and Views, and applied referential integrity.
• Participated in designing of data conversion/interface with the use of SQL*Loader, and Open Interface.
• Created Form level objects i.e. Libraries, property classes.
• Created Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed SQL*loader scripts to load data in the custom tables.
• Create stored procedures using dynamic SQL based on J2EE user parameters.
• Developed PL /SQL code for updating payment terms.
• Developed UNIX shell scripts for extracting data from flat files and loading them using SQL loader, importing and exporting databases.
• Responsible for loading and processing client data feeds into an Oracle 8i database using Perl.
• Developed contact database application using Perl scripting.
• Created and tested numerous Reports using Actuate reporting tool.
• Involved in documentation of User requirements and Testing of developed modules.
• Worked in the Production Support team and fixed high priority bugs.
• Developed SQL scripts to create database tables, synonyms, sequences, and also created users, roles, and granted privileges to them.

Environment: Oracle 10g, Java, Developer/2000, Actuate, PL/SQL, Shell scripts, Perl, SQL *Loader, Unix and Windows 2003

Confidential, Lake Forest, IL

Oracle Developer

Responsibilities:

• Created forms/reports using oracle forms/reports 10gsuite.
• Created screens like Create Inventory, Physical Inventory and Check Stock Inventory.
• Stored images of Products using the BLOB datatype.
• Developed PL/SQL procedures for new reports and changes to current reports as per the client requirements.
• Maintained and developed user requested features to a web based Warehouse Catering System.The system allowed users to schedule,edit, and manage the corporation's entire upcoming warehouse catering events
• Installed Informatica software on the Client systems and configured Informatica Server
• Wrote procedures and functions using TOAD to update the inventory module from the order entry module once orders were confirmed.
• Created sessions, database connections and batches using Informatica server manager.
• Tuned the Performance for ETL jobs by tuning the SQL used in Transformations
• Created Unix Shell scripts for automating the execution process.
• Involved in Migration of data from production to the test environment with our development engine.
• Used AUTOSYS Tool to Schedule the ETL jobs daily, Weekly and monthly based on the business requirement.
• Responsible for design and development of other modules such as Shipping, Sales and Invoicing.
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client in the SDI module, and performance tuning of the Oracle database.
• Other functions included Problem Analysis & Solution, Providing and performing Impact Analysis for any changes to be done on a program, and coordinating the team during integration testing

Environment: Oracle 10g/9i, Oracle Forms/Reports 9i;DB2, Informatica Power Center/Power Mart 5.1/6.1/6.2; PL/SQL; SQL;TOAD; SQL*Plus;SQL*Loader; Autosys; Windows XP; Unix

Confidential

Oracle & VB Developer

Responsibilities:

• Involved in System Requirement Specification
• Involved in Project Planning
• Involved Database design(conceptual, logical and physical)
• Developed front end screens in C and VB.
• Involved in writing various stored procedures, functions, packages
• Involved in writing triggers and scripts based on the business requirements
• Involved in performance tuning of the database.
• Used various optimization techniques as well as hints
• Created Front-end interface using VB forms.
• Extensively used ADO Programming model.
• Did VB programming and Reporting using Crystal Reports.
• Build different formulas, Created Groups and used sub-reports based on the business requirements
• Involved in various reports developed based on different criteria’s.
• Involved in Collecting sample data and did testing of the system.
• Did performance tuning of application.

Environment: SQL, PL/SQL, UNIX, SQL Server, Flat Files, Windows 2000/NT,C, VB 6.0, Crystal Reports, ADO.

Confidential

Oracle analyst/programmer

Responsibilities:

• Responsible for requirements analysis, design and development of the system.
• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Developed Management login tables using C language.
• Designed and developed Modules using Object Oriented Design in C.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements
• Develop and maintain scripts for monitoring, troubleshooting and administration of the databases.
• Used Shell Scripts to interact with Server from 4d-jobs (UNIX) tool.
• Developing and Tuning SQL, PL/SQL triggers and stored procedures
• Tuning database and SQL statements and schemes for optimal performance.
• Involved design and development of user interfaces using Visual Basic.
• Designed and enhanced the GUI using Visual Basic tools like input fields, buttons, menus etc.
• Tested programs to ensure proper functionality through unit testing.

Environment: Oracle 9i, C, SQL, PL/SQL, SQL*Loader, UNIX, Shell Scripting, SQL*PLUS, Visual Basic 6.0