Developer Oracle

Prayash Khadka

Professional Summary:

• Around 4+ 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, Native Dynamic

SQL, Bulk Binds, Materialized views, Inline views).

• Strong skills at analyzing dimensions and fact tables and associated measures and implementing star and

snowflake schemas.

• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF.

• 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.

Education:

Bachelor in Information and Technology (Kathmandu University, Nepal)

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

Work Experience:

ARI, New Jersey (Jul 2013-Till Date)

Oracle Developer

Accident Management

The purpose of this project was to develop application for accident management and jobs for notification

that would send the notification to clients and driver regarding the preliminary maintenance of vehicle.

Responsibilities:

• Involved in creation of data model for accident management and preliminary maintenance

notifications.

• Wrote jobs for preliminary maintenance notification that would send the notifications.

• Wrote packages and procedure to support application.

• Wrote new PL/SQL packages, procedures, functions and Triggers to support new business rule.

• Work extensively with XML and HTML, Record Type, Cursors, and Regular Expression.

• Wrote Package for Data migration.

• Optimized PL/SQL package to bring down execution time.

• Fixed the Production Bugs and defects and did the production support.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, PL/SQL Developer, Oracle SQL

Developer, MS Excel, Microsoft Visual Studio

Cigna, Florida (Jan 2013-Jul 2013)

Oracle Developer

Dental IT

The purpose of this project was to create a data-mart and to add a new service to help users to get

the provider preference information by passing the claim or address provided by providers.

Responsibilities:

• Worked with business analyst to get the requirements and prepare software specification based on

Business requirement documents.

• Deigned logical and physical model of data-mart and the process of getting data.

• Learned SQR and wrote SQR procedure to read the comma delimited files and load directly into

the tables.

• Created tables, indexes, sequence, triggers, database link and synonyms in the schema.

• Wrote PL/SQL procedure to load data into data-mart across the database and added the job to UC4

chain for daily load of data.

• Wrote PL/SQL procedure and packages that returns the provider preferences data and the status for

particular preference.

• Used PL/SQL type object heavily in the program.

• Created test data for validation of project and mocking of data was done.

• Unit tested whole program and also fixed the defect during the testing phase.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys, MS

Excel

Comcast, Colorado (May 2012-Dec 2012)

Oracle Developer

Linear Advertisement Effectiveness

The purpose of this project was to create a database which could calculate the effectiveness of a

Particular advertisement targeted to the customer.

Responsibilities:

• Worked with business analyst to get the requirements and prepare software specification based on

business requirement documents

• 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.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys,

Crontab, MS Excel

System Engineering Service, Colorado (Aug 2011-Apr 2012)

Oracle Develop

World Pay, UK (Migration from Sybase to Oracle)

• 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.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys, MS

Excel, Crontab.

Paychex Inc., Webster, NY (Dec 2010-May 2011)

Oracle Developer

I. Transaction Tax Verification

The purpose of this project was to facilitate the tax verification for stock options. Before final tax

is finalized, it will get hold up in queue. The default tax information is sent to fidelity. After getting tax

feed from fidelity, tax table was updated and exercise record gets out of queue. It also has web form which

allows plan sponsor to manipulate the tax and approve exercise. Exercises are visible to users depending

on rules and restriction assigned to users.

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 various Reports, Customized existing reports according to the functional specifications

including Invoice and Expense reports .

• 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.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, SQL*PLUS, Oracle SQL Developer, autosys, Crontab,

MS Excel

II. Retirement Date Calculation

Retirement Date Calculation is a retirement date calculation engine. It calculates retirement date

based on retirement rule setup through web interface.

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.

Burlington Coat Factory, Edgewater Park, NJ (July2009- Aug 2010)

Oracle Developer

3WayMatch and Overshipment

The purpose of this project is to match purchase order with invoice by sku quantity and price,

create a debit for matched invoices and detect invoices with overshipments.

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.

• 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.

Technologies used: Oracle 10g, PL/SQL, SQL, TOAD, SQL*PLUS

Contact this candidate