SUMMARY

• Over 5+ years of extensive experience as a software developer in Oracle based applications.
• Experienced with all Software Development Life Cycle - Design, Development, Testing, Deployment, Maintenance, Support and Enhancement.
• Professional expertise in Oracle 10g/11g.
• Professional expertise in SQL and PL/SQL programming, developing database triggers, Functions, Procedures, Packages using the latest features (Oracle Collections, Autonomous Transactions, Materialized views, Inline views).
• Strong skills at analyzing dimensions and fact tables and associated measures and implementing star and snowflake schema.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export.
• Participated in collecting the requirements, analyzing the System Requirements.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experienced in using Explain Plan for SQL tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Extensively used UNIX shell Scripts for automating batch programs.
• Proficient in working with UNIX shell scripts using AWK on UNIX using PUTTY Environment.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Fast and self-studying learner of new and required technologies.
• Possess excellent Interpersonal, Communication and written skills

TECHNICAL SKILLS

Databases: Oracle (11g, 10g)

Development tools: TOAD, SQL*PLUS, Import/Export utility, Oracle Net Manager, Oracle Enterprise Manager

Database Languages: PL/SQL, SQL.

Programming Languages: UNIX Shell Programming, JIL (Job Instruction Language)

Operating Systems: Windows 95/98/2k/NT/XP, UNIX PLATFORM

Data Modeling Tools: Erwin

Test Management: Hp Quality Center

Version Control: SVN.

PROFESSIONAL EXPERIENCE

Confidential, Colorado

Oracle Developer

Responsibilities:

• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents
• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• Deigned logical and physical model of database for calculating advertisement effectiveness.
• Created tables, indexes and sequence in the schema.
• Exported data from same database and also from another database using database link.
• Created test data for validation of project and mocking of data was done.
• Wrote PL/SQL procedure to update customer revenue table.
• Wrote SQL to calculate different metrics for calculating advertisement effectiveness.

Environment: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys, Crontab, MS Excel

Confidential, Colorado

Oracle Developer

Responsibilities:

• Actively participated in migration and development of Sybase to Oracle.
• Converted Sybase code to Oracle both for reporting and non- reporting procedure.
• Worked extensively with Oracle Collections (index-by tables, associative array and nested table), Record Type and Cursors.
• Developed SQL scripts, packages and procedures for validating business rules while loading and updating data.
• Modified the existing packages and procedures and apply the changes as required by the business users
• Loaded data to database using oracle tools like SQL* loader and external tables to load data from various external files like text and excel files.
• Extensively used Stored Procedures in PowerBuilder as a data source for data windows.
• Wrote unit test for testing and validation of the procedure.
• Wrote XML files for reporting procedure.
• Significant use of database technology SQL-Loader, Oracle SQL-plus, SQL-Developer.

Confidential, NY

Oracle Developer

Responsibilities:

• Worked as the prime Oracle developer.
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Wrote PL/SQL package, triggers, procedures, functions.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed various Reports, Customized existing reports according to the functional specifications.
• Worked extensively with Oracle Collections (index-by tables, associative array and nested table), Record Type, Cursors
• Developed new feeds to generate tax outbound feed to fidelity.
• Optimized SQL to bring down execution time.

Environment: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys, Crontab, MS Excel

Confidential

Responsibilities:

• Worked as the prime Oracle developer.
• Analyze the existing code for necessary changes.
• Wrote PL/SQL package /procedures.
• Incorporated the new changes in existing packages.
• Wrote UNIX script to kick off the batch process.
• Optimized SQL and Packages to bring down execution time. Partition the dynamic label tables for performance improvement.
• Fixed defect during testing phase.

Environment: Oracle 10g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer

Confidential, Edgewater Park, NJ

Oracle Developer

Responsibilities:

• Worked as the prime Oracle developer.
• Wrote new PL/SQL packages, procedures, functions and Triggers to support new business rule. Work extensively with Oracle Collections (index-by tables, associative array and nested table), Record Type, Cursors, and Regular Expression.
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Maintaining and enhancing PowerBuilder based applications.
• Optimized PL/SQL package to bring down execution time.
• Developed installation script and collaborate with DBA' to deploy in SKU Production servers.

Environment: Oracle 10g, PL/SQL, SQL, TOAD, SQL*PLUS

Confidential

Oracle / Software Programmer

Responsibilities:

• Worked as an Oracle Programmer on Hospital Management applications.
• Developed database Triggers, Stored Procedures and packages.
• Developed SQL*Plus reports to allow the manager to analyze the data directly accessing Oracle Server.
• Design and implementation of stored procedures and triggers for automating tasks.
• Managed User, Role and Privilege.
• Production Support.

Environment: Oracle 10g, PL/SQL, SQL, TOAD, SQL*PLUS