Prayash Khadka

*** ********* ***, *********, **, 06825

469-***-****

adkaf0@r.postjobfree.com

https://www.linkedin.com/in/prayash-khadka/

Professional Summary:

● Over 10+ 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).

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

● Proficient in using VISIO for detail designed database process flow . 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.

Work Experience:

ETC (Electronic Transaction Consultant), Richardson, TX (Jun 2014-Till Date) Oracle / Software Programmer (Employee)

I. Toll Processing and Billing

The purpose of this project is to facilitate NTTA and handle all the toll processing.Working together with our toll authority customers,ETC has created the RITE Solution, the most innovative and user - friendly toll revenue collection and management system in the industry. The RITE Solution is an impressive suite of enterprise roadside solutions and back office business applications incorporating high - level process automations that streamlines customer service account management, violation-loss recovery, and accounting. This solution also provides extensive reporting which enhances authorities’ internal control systems. The RITE® Solution provides features for achieving diverse roadside toll collection, operational effectiveness and efficiency, reliable financial reporting, and compliance with laws, regulations, and policies. Deployed individually or as an entire suite, each module is fully customizable to meet each authority’s specific requirements.

Responsibilities:

● Working as a SME and prime oracle developer for the NTTA project.

● Participated in Business Requirements walkthrough and made necessary suggestions.

● Working with business analysts to get the requirements and prepare software specifications based on business requirement documents.

● Wrote detailed design documents for the developers and guided throughout the development process.

● Wrote PL/SQL package, triggers, procedures, functions.

● Developed a new way of creating the builds for deployment of the software in different environments.

Programming Languages Unix Shell Programming, JIL (Job Instruction Language), Python Basic Knowledge.

Operating Systems Windows 95/98/2k/NT/XP, UNIX PLATFORM Data Modeling Tools Erwin

Test Management Hp Quality Center

Version Control SVN, Eclipse

● Worked extensively with Oracle Collections (index-by tables, associative array, and nested table), Record Type, and Cursors.

● Optimized SQL to bring down execution time.

● Incorporated the new changes in existing packages.

● Optimized SQL and Packages to bring down execution time. Partition the dynamic label tables for performance improvement.

● Fixed defect during testing phase and supported the production support team in production Issue.

Technologies used: Oracle 11g, PL/SQL, SQL, TOAD, and SQL*PLUS, Oracle SQL Developer, AutoSys, Crontab, MS Excel.

ARI Intellifleet Rewrite, Mt Laurel, NJ (Jan2013- May 2014) Oracle / Software Programmer (Contractor)

Fleet Management

Intellifleet is the platform used by ARI's 600+ highly skilled call center agents in the US, Canada, Mexico (and future in Europe) to drive ARI's fleet management business. It can predict maintenance schedules, repair costs through the data intelligence of cars, trucks, and railroad vehicles. It supplies the lowest cost parts to the repair shop, to reduce their customers’ costs by at least 50%. It recommends the best repair shops: by tracking costs and vehicle downtime and through subjective ratings. Intellifleet runs on Oracle 11g and MS .NET 4.0. Responsibilities:

● Worked as the prime Oracle developer.

● Wrote new PL/SQL packages, procedures, functions, and Triggers to support new business rules. 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.

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

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

● Developed installation script and collaborated with DBA' to deploy in SKU Production servers. Technologies used: Oracle 10g, PL/SQL, SQL, TOAD, and SQL*PLUS. System Engineering Service (World Pay), Colorado (Feb 2011- Dec 2012) Oracle / Software Programmer (Contractor)

World Pay(Migration from Sybase to Oracle)

The project was for migration and development of databases from the 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.

Contact this candidate