Oracle Developer
Resume:
Rajeev Dhakal
************@*******.***
SUMMARY
. 10+ years experience in Software Development including system
analysis, design, data modeling, development, unit testing and
deployment of desktop, Client-Server database applications with
Oracle, SQL Server, Access, and other Database such as dBase, FoxPro,
Clipper, and Cobol.
. Expertise in Visual Basic 6.0, Java, ASP.NET, VB.NET,
HTML/DHTML/XML/WML, CSS, IIS, Developer 2000, Oracle 10g/11i
Suite,Oracle, SQL and PL/SQL.
. Extensive working knowledge of Banking, Insurance, Tax, VAT System.
. Extensive experience in different relational databases including SQL
Server, Oracle, and MS Access.
. Strong in writing software applications using database features
including stored procedures, triggers, views, and constraints.
. Experience in ADO, ADO.NET, ODBC, Access Reports, Crystal Report.
. Experience in OO methodologies, Design Principles, Design Patterns and
frameworks, Rational Rose unified process (RUP) and unified modeling
language (UML).
. Extensive knowledge and exposure in Software development Cycle,
Application/System Design, Business Analysis, Data Analysis, Microsoft
Exchange Server, Business Intelligence.
EDUCATION
. Master of Computer Science, Maharishi University of Management,
Fairfield, Iowa
. Bachelor of Computer Engineering, D.Y.Patil College of Engineering and
Technology, Kolhapur, India
. India Senior School Certificate, Manav Bharti Indian International
School, New Delhi, India
. Indian Certificate of Secondary Examination, Goethals Memorial School,
Kurseong, India
PROFESSIONAL EXPERIENCE
USDA March 2010-Till Date
Sr. Programmer Analyst
Project: I-web/NRM
Synopsis: Multiple platform projects with Oracle being the main database as
well as Data Warehouse platform. Application were developed using Oracle 10
suite (Forms, Reports, Discoverer, J developer),JAVA, Jasper reports and
mobile framework platform application. The application consists of an
integrated set of forms, reports, and map products that supports entry,
edit, and retrieval of activity information. Infra also interfaces with
several external systems to meet data sharing and financial reporting
goals. Infra transmits daily feeds of permit billing and grant and
agreement financial information to the Foundation Financial Information
System .Infra also transmits real property information to the UDSA's
Corporate Property Automated Information System.
Role:
. Was the main lead programmer for,Infra,Timber Information Manager
(TIM), Natural Resource Information System (NRIS),Roads and
Engineering
. Analyzed,Developed various modules for the various team.
. Enhanced the existing the system.
. Played and active role in the development of POSS for TIM.
. Involved in the planning, system design and testing.
. Documented the various process and developed test case scenario.
. Responsible for emergency fixes and release.
. Played an active role in requirement gathering, analyzing business
rule and developing developing business logic.
. Developed function, procedure and packages for TIM, RANGE, NRM, SUDS.
. Played an active role in the POSS integration test across various
system/module.
. Took active part in code review and logic integration.
. Was in-charge of TIM application
. Developed multiple reports using Oracle Report Builder, Oracle
Discoverer.
. Provided use case, test case to testing team.
. Interacted with end users on regular basis.
. Developed, integrated DFD, SFD, flowchart.
Environment: Oracle Suite 10g,11g,Oracle 10g,11g Unix, LAN, Toad, Oracle
Forms, Oracle Reports, JAVA, J developer, Jasper Reports,Discoverer,SQL
Developer, ERWIN.
Census Bureau November 2007- March 2010
Sr. Oracle Programmer Analyst
Project: CARMN/ROSCO
Synopsis: Oracle platform application. Developed using Oracle Forms,
Reports, PL/SQL, and The backend uses Korn-shell scripting, as well as Pro
C, C, C++program units. Data are gathered thru various applications and
then fed into CARMN CARMN is mainly a reporting application and CARMN 1139
is a user interactive application.
Role:
. Analysed,Developed various modules for CARMN-1139.
. Enhanced the existing CARMN application.
. Enhanced the various backend program units.
. Have developed various view and materialized view for CARMN, CARMN-
1139.
. Have played a major role in redesigning of the program unit as well
as the logic governing it.
. Involved in ROs, FRs discussion group.
. In charge of and monitors and maintaining various application CARM,
CARMN 1139,DAD, NFC, WINFRED, WEBTA, CAMS and NFC Payroll.
. Have documented the process as well as the application.
. Written test case for the Software Test Team.
. Analysed,Developed various scripts for data correction in various
applications.
. Was in charge of Data copy for new fiscal year.
. Responsible for analysis of production issues and fixing it.
. Involved in production support, risk analysis, production issues
analysis.
. Wrote complex Package, Procedures, Function and triggers to build
up the audit log tables for critical data updates.
. Played an active role in requirement gathering, analyzing business
rule and developing developing business logic.
. Was in charge of developing the CARMN, Audit system and CARMN11-39
functional as well as business rule.
. Was in charge of developing the requirement, design document as
well as all technical documents.
. Analyzed, Developed test case scenario for the application.
. Was in charge of data as well as system analysis.
. Analyzed, Developed business intelligence rule for the system.
Environment: Oracle Suite 10g,11g,Oracle V9.0,10g,11 Unix, LAN, Toad,
Oracle Forms, Oracle Reports, Discoverer, C, Pro C, C++,MS Excel, MS
Access,HTML,XML,JAVA,J Scripts.
Washington Mutual March 2007- November 2007
http://wamucardservices.com
Senior Production Support Programmer Analyst/ Manager
Project: Washington Mutual Card Services (WMCS)
Synopsis: Multi platform application software, which tracks the life cycle
of Credit Card and all corresponding transaction. Also gathers data about
payment, PTP, SIF, PIF, Statements etc .Had many applications running some
of them are as TSY, PROPHIT, GEM, I smart.
Role:
. Was in charge of Agency Management Department.
. Was in charge of developing and verifying the business rules/logics
for the credit card services.
. Was in charge of production support 24/7.
. Played active roles in data analysis and process management.
. Involved in risk management as well as data management.
. Involved in production support, risk analysis, production issues
analysis.
. Supported various application built on various platform.
. Involved in creating and managing various online process monitoring
and distribution.
. Responsible for analysis and fixing Production issues for the Agency
Management.
. Involved in providing and exchanging the business rules and the logic
for the various process developed between various other departments.
. Database Tuning and Performance Management.
. Involved in providing various Oracle and Crystal Reports.
. Creating the test environment for Business users testing and training.
(UAT).
. Developed BI.
. Developed and documented business process.
. Involved in database architecture design.
. In charge of documenting the business process.
. Involved in decision making process.
. In charge of developing system requirement and technical document.
Environment: Siebel, Rumba, Visual Studio, Visual Basic, MFC,Oracle V8& 9,
Microsoft Access, Visual Basic, MS Studio, Crystal Reports, Discoverer,
UNIX, LAN, Toad, Oracle,MS Excel, MS Access, XML,XML Publisher.
State Government of PA June2005 -June2007
Oracle Programmer Analyst
Project: State Workers Insurance Fund (SWIF), Scranton, PA
Synopsis: Power Comp System is application software, which tracks the life
cycle of Policy and all corresponding Claims. Also gathers data about
Audits, Legal, Loss Control and Accounting. Customized specially for
Department of Labor and Industry (L&I). SWIF has eight district offices
throughout the Commonwealth of PA. These offices are linked to the head
office by a state of the art integrated computer system that processes all
aspects of SWIF's operation from underwriting, to claims processing and
payments to clients, legal and statistics.
Role:
. Was in charge of Accounting Department reports.
. Was in charge of developing and verifying the business
rules/logics fro the accounting
. Involved in preparing the specifications and requirements for the
reports
. Involved in creating Oracle report for the modules such as Policy
maintenance, Audits, Accounts receivables, claims, Loss time
/Medical claims entry & others.
. Involved in developing PL/SQL procedures used in live-electronic
data transmission for different government agencies like PCRB -
Pennsylvania Compensation Rating Bureau, BWC -Bureau of Workers
Comp, WCRI - Workers comp rating institute, CIB - Claim Index
Bureau, L& I etc
. Involved in providing and exchanging the business rules and the
logic for the various reports developed between various other
departments
. Wrote complex Package, Procedures, Function and triggers to build
up the audit log tables for critical data updates.
. Database Tuning and tuning the reports.
. Unit& Integration Testing.
. Creating the test environment for Business users, testing and
training.
. In charge of requirement gathering, building the business
process/logic.
. Actively involved in the system design, data analyst.
Environment: PowerBuilder V6.5 & V 7.0, PFC, Oracle V8.0,9i Unix, Oracle
Forms, Oracle Reports, Oracle Discoverer, Toad, ERWIN Oracle,SQL Loader,
Mainframe.
Yash Solutions Feb 2005 - May2005 http://www.yashsolutions.com/
Oracle Programmer Analyst
Project: State Workers Insurance Fund (SWIF), Scranton, PA
Synopsis: Modernizing of mainframe workers' compensation software system to
PowerBuilder and Oracle by customizing the third party software
Power Comp, which resides on multiple IBM RS6000 midrange systems.
The system contains multiple modules that are Policy, Claims & Sys
admin.
Role:
. Involved as Programmer/Analysts & Co-coordinator in the modernizing
of mainframe worker's compensation software system to PowerBuilder
and Oracle by customizing the third party software.
. Involved in the writing Interface and extraction routine for
electronic transfer of files from/to different Bureaus on Oracle
database using SQL, PL/SQL, Stored Procedures and Triggers.
. Involved in documenting business/functional/design requirements.
. Responsible for Object Oriented Analysis and design techniques.
. Responsible for analysis and building Oracle reports for Policy and
claim module as per user requirements.
. Involved in developing PL/SQL procedures used in live-electronic
data transmission for different government agencies like PCRB -
Pennsylvania Compensation Rating Bureau, BWC -Bureau of Workers
Comp, WCRI - Workers comp rating institute, CIB - Claim Index
Bureau, L& I etc.
Environment: Oracle V8.0 UNIX, LAN, Toad, Oracle Report, Oracle Discoverer,
and Windows 95/98/2000/NT/XP
Professional Computer System Pvt. Ltd. Katmandu, Nepal. June 2000-May 2004
http://www.pcs.com.np/
His Majesty Government Of Nepal June 2000- May 2003
Analyst/Developer
Project: Value Added Tax (VAT)
Synopsis: One of the biggest integrated online projects for government of
Nepal. Provides information of taxpayers from registration to assessment of
tax and payment. Developed using Oracle as back end and Developer/2000 as
front end. Consisted of central database in Windows NT 4.0 server. System
includes both local and wide area networks.
Role:
. Developing PL/SQL interface programs for transferring Customer data.
. Developing Complex PL/SQL Procedures and Packages for data validation
per business requirement.
. Developing control files for SQL *Loader, and loaded data into
database tables from flat files.
. Developed modules like return, refund, and filing period of tax, batch
entry and others.
. Developed procedures, which calculate interest and penalties, date
conversions (English and Nepali calendars).
. Developed reports and forms using Developer/2000
. Manually converted forms 4.5 to 6i.
. Performed unit and integration testing.
. Developed some new reports using Oracle report 6i
. Updated changes and fixes on reports as from the user community.
. Worked as support engineer/DBA for a year
. Provided training to the staff.
. Actively involved in the system analysis and process management.
. Involved in requirement gathering, analysis and process
implementation.
. Involved in writing and designing the process, system document.
. Played an important role in database design and implementation.
. Played an active role in SDLC.
Environment: Oracle V8.0 UNIX Oracle, Reports, Oracle Forms and Windows
NT/2000
His Majesty Government Of Nepal May 2003- May 2004
Analyst/Developer
Project: Inland Revenue System
Synopsis: This was an upgrading project. The existing system was being
upgraded from FoxPro to Oracle. Developed using Oracle as back end and
Developer/2000 as front end. Consisted of central database in Windows 2000
server.
Role:
. Analyzing and documenting the existing report logic.
. Collecting users requirements.
. Developed modules like return, refund, and filing period of tax, batch
entry and others.
. Developed reports and forms using Developer/2000 (Oracle 6i)
. Performed unit and integration testing.
. Provided production support.
. Provided training to the staff.
. Documented the process.
. Developed Test case scenario.
Environment: Oracle V8.0 Unix, Toad, Oracle, Reports, Oracle
Forms,Discoverer, and Windows 2000/XP
Automation of Park Avenue, Maharashtra, India Jan 1998- August 1999
Analyst/Developer
Synopsis: Worked as team lead and helped to change Park Avenue Shop to
computerized one. Duration of one year. Developed using Oracle and
Developer 2000.
Role:
. System analyst and programmer.
. Studied and analyzed different business rules and applied to
application.
. Developed and designed modules related to daily transactions.
. Developed and designed form for regular transaction and inventory
control.
. Developed regular reports using Oracle Reports (2.5).
. Provided hardware and software support for six months
. Actively involved in the system analysis and process management.
. Involved in requirement gathering, analysis and process
implementation.
. Involved in writing and designing the process, system document.
. Played an important role in database design and implementation.
. Played an active role in SDLC.
Environment: Oracle V8.0 Oracle, Reports, Oracle Forms, Discoverer and
Windows NT/2000
Other Projects:
. Developed Ticketing Software for the Bus Terminal in Kathmandu
. Developed Travel Agency Accounting Software for a Travel Agent in
Kathmandu
. Developed Accounting Software for Colleges in Kathmandu
Graduate Projects
Project: E-Bazaar:
Synopsis: E-Bazaar is an application that simulates the online shopping
experience. Included features like shopping cart, card verification,
product managements, and order management, state management.
Role:
. Developed applying software engineering methodologies.
. Followed Rational Unified Process (RUP).
. Practice the XP principles like test driven development, refactoring,
pair programming. Development was done considering the better software
. Implemented design pattern.
Environment: Java, JDBC, Swing, Eclipse, Rational Rose, CVS etc
Project: Framework for the Accounting domain applicable for Banking and
Credit Card application
Synopsis: This framework for the accounting domain (with limited
specification). Then it was applied in credit card application and banking
application. Framework development was done using the software engineering
best practices like using common design patterns.
Role:
. Developed applying software engineering methodologies.
. Used software engineering better practices like design patterns
. Used Rational Unified Process to create UML.
Environment: Java, swing, JDBC, Eclipse, Rational Rose, CVS
Project: Library Management system
Synopsis: Library management system for library domain was developed
using the j2ee technology. Enterprise java beans are used for the various
purpose (for entity, state, messaging). Enterprise architectures were
applied.
Role:
. Requirement and analysis.
. Design using Rational unified process
. Development of entity beans and session beans
. Implementation and documentation
Environment: Java, swing, JDBC, Eclipse, Rational Rose, CVS
PROFESSIONAL TRAINING
. Web based applications: Develop web-based applications with ASP and
ASP.NET
. Introduction to Oracle and Developer 2000.
. Novell Netware.
. Certification in Computer Hardware and Maintenance.
. Introduction to E-Commerce Concept and Features.
. Introduction to Oracle Apps (E-Business Suite (DBA))
. Marketing Technique & Selling skills.
. Technical Writing Skill.
. Enterprise Architecture.
. Oracle Apps Functional.
Contact this candidate