oracle sql,plsql,oracle forms and oracle reports
Resume:
B.RAGHAVENDRA
Oracle Developer
Mobile: +91-949*******
Email: ***************@*****.***
***********.*******@*****.***
CAREER OBJECTIVE
As a young professional, keen and motivated, energetic and result oriented, sincere and hardworking, I wish to seek a challenging position in software development and participate in the growth and success of the organization.
EXPERIENCE SUMMARY
3.4 years of experience in Information Technology in Analysis, design, and Development of Applications in Oracle 9i/10g Database, Developer 2000 and windows Environment.
In-depth knowledge of PL/SQL with the experience in constructing the triggers, tables, collections, functions, collections, Objects, procedures etc.
Strong exposure on Performance Tuning using Explain Plan.
Strong exposure on Oracle Developer suite 6i and 10g (Reports and Forms).
Have experience in Customization and development of Oracle Application report as per the client requirement.
Proficient in writing stored procedures, packages, triggers using PL/SQL, SQL, SQL*PLUS
Having experience in data migration using SQL*Loader and UTL_FILE package.
Excellent debugging skills.
Exceptionally good and experienced in handling the problem.
Ability to rapidly learn new concepts together with excellent interpersonal skills.
Excellent communication, organizational and presentation skills.
Excellent analytical skills, ability to take leadership, go in core of the problem, capacity of work-meeting deadlines, excellent communication and interpersonal skills across cultures and professions.
Energetic and hard working with a keen sense of reasoning.
Good Analytical and Strong interpersonal and excellent communication skills.
JOB PROFILE
Software Engineer in Wipro InfoTech, Chennai from May 2015 to till date.
Analyst Programmer in AETINS Software Pvt. Ltd (Penta soft SdnBhd), Hyderabad from Feb 2013 to May 2015.
EDUCATIONAL BACKGROUND
Bachelor of Technology from SV University, Tirupati in 2010.
TECHNICAL SKILLS
Operating Systems
RDBMS
Languages
Front End Tools
Database Management Tools
Oracle Packages
Microsoft Packages
Designing Tool
: Windows 98/XP/NT/2000
: Oracle 8i/9i/10g
: SQL, PL/SQL
: Oracle Developer 2000
: SQL*Loader, Toad, PL/SQL Developer
: UTL_FILE
: MS Word, MS Excel, MS Power Point
: Toad Data Modeler
PROJECT#1
Title : Southern Petrochemical Industries Corporation Project
Client : SPIC (Southern Petrochemical Industries Corporation Ltd., Spic Nagar)
Organization : Wipro InfoTech
Duration : Nov 2015 – Till date
Environment : Oracle 10g, Oracle Forms and Reports
Description
SPIC is a fertilizer company. Finance, HRMS, Weigh Bridge system, Receipt systems are in-house software products of SPIC. Finance department will be responsible for all the day to day transactional accounting for the business. This will include the tracking of all transactions and the management of any government reporting and to prepare the organization’s budgets and forecasts, and to report back on the progress against these throughout the year. This information can be used to plan staffing levels, asset purchases and expansions and cash needs, before they become necessary. Finance application covers all the functionalities that are carried out by Finance department i.e., preparing of journal vouchers, debit notes, credit notes, maintaining of asset addition/deletion/depreciation calculation, variance calculation and ledger processing etc. For Administration/ HR related activities the project involved Customization of the Product for the Directorate a according to their requirements and business processes for all offices. HRMS application covers all the functionalities of HR department of any organization from Employee Lifecycle to Employee Transaction. This Project contains various modules like Administrator, HR Works, Pay Roll and Time Office. The HR system maintains the Employee Master Transaction. The Time Office covers the Attendance data. The Payroll System covers the Employee Payroll process and IT details. The Receipt system maintains the Truck Incoming and Outgoing details. The Weigh Bridge System captures weight of both incoming materials and outgoing products. Data transfer to Receipt system, Bagging and PH & D Systems.
Responsibilities
Creating packages, procedures, functions using advanced pl/sql coding to implement the complex business logic.
Writing complex queries using multiple tables.
Creating triggers and error handling as per the business requirement.
Creating Materialized views for replication of data to other instances.
Developed New Forms and Reports using developer suite 6i.
Creating Materialized view for reports.
Scheduling/Monitoring of jobs processes.
Developing Forms to upload the flat file data to base tables.
Involved in Unit testing the forms and reports.
Providing 24X7 Supports.
Supporting to the existing forms and reports and enhanced the new client requirement.
Analyzing the client requirement and design the code for front end screens.
PROJECT#2
Title : Green Star Fertilizers Limited Project
Client : GSFL (Green Star Fertilizers Limited Ltd., Spic Nagar)
Organization : Wipro InfoTech
Duration : Nov 2015 – Till date
Environment : Oracle 10g, Oracle Forms and Reports
Description
GSFL is a leading manufacturer and marketer of fertilizers in India. Here, in this company we have different departments like Finance, HR, Weigh Bridge system, Receipt systems, Purchase, Distribution, and Marketing etc. Fincube, Pigeon, Activ, Phosphatics and HRmax are the applications using to maintain data base and other functionalities of all above departments.
Responsibilities
Creating packages, procedures, functions using advanced pl/sql coding to implement the complex business logic.
Writing complex queries using multiple tables.
Creating triggers and error handling as per the business requirement.
Creating Materialized views for replication of data to other instances.
Developed New Forms and Reports using developer suite 6i.
Creating Materialized view for reports.
Scheduling/Monitoring of jobs processes.
Developing Forms to upload the flat file data to base tables.
Involved in Unit testing the forms and reports.
Providing 24X7 Supports.
Supporting to the existing forms and reports and enhanced the new client requirement.
Analyzing the client requirement and design the code for front end screens.
PROJECT#3
Title : Tuticorin Alkali Chemicals and Fertilizers Limited Project
Client : TAC (Tuticorin Alkali Chemicals and Fertilizers Limited Tuticorin)
Organization : Wipro InfoTech
Duration : May 2015 – Nov 2015
Environment : Oracle 10g, Oracle Forms and Reports
Description
The company began production of soda ash, ammonium chloride and other chemicals. This Project has been developed for the Fertilizer Company consists of the s Master Management, (Customer, contract, Special Requirements, Product, Company, Unit, Rate) Monthly Planning, Daily Planning, Production Controls & analysis, Subcontract Process and Billing, Stock Details, Quality Control-Import of Chemical Properties Data Transfer From Spectro-meter Machine. Generating Test Certificate For the Finished Products & DC Wise Test certificate Generating, Quality Analysis, Pending Order Report, Plant Status Report. But I handle the HRMS, Weigh Bridge system, Receipt system and Plant operation reporting System. The HR system maintains the Employee Master Transaction. The Time Office covers the Attendance data. The Payroll System covers the Employee Payroll process and IT details. The Receipt system maintains the Truck Incoming and Outgoing details. The Weigh Bridge System captures weight of both incoming materials and outgoing products. Data transfer to Receipt system, Bagging and PH & D Systems.
Responsibilities
Creating packages, procedures, functions using advanced pl/sql coding to implement the complex business logic.
Writing complex queries using multiple tables.
Creating Materialized views for replication of data to other instances.
Developed New Forms and Reports using developer suite 6i.
Creating Materialized view for reports.
Used UTL_FILE package to read and write directly from flat files on the server.
Scheduling/Monitoring of jobs processes.
Developing Forms to upload the flat file data to base tables.
Involved in Unit testing the forms and reports.
Analyzing the client requirement and design the code for front end screens
Supporting to the existing forms and reports and enhanced the new client requirement.
PROJECT#4
Title : ISF General Insurance
Client : SABB TAKAFUL (Saudi Arabia)
Organization : AETINS Software Pvt. Ltd., (Pentasoft Sdn Bhd)
Duration : Feb 2013 – May 2015
Environment : Oracle 10g, Oracle Forms and Reports
Description
ISF General covers all major insurance classes of General Insurance. It is easy to use, customizable, comprehensive and easy to implement .ISF General is designed to meet today’s business challenges of General Insurance Organizations. It incorporates the functionalities of a futuristic insurance processing solution. With the combining experience in serving the insurance industry and in-depth understanding of the latest processing technologies, we have built a productive tool unique in its flexibility, functionality and features. It is an ‘Open Systems’ based solution, which caters for the entrepreneurial initiatives, enabling our clients to introduce new products to the market faster than ever.
Functionalities with include in the ISF General system :
• Quotations • Sport Policies • Underwriting • Cancellations
• Endorsements • Underwriting • Claims • Reinsurance
• Distribution Channels • Product Administration • MIS Reports • Accounts
• Renewals
Responsibilities
Creating packages, procedures, functions using advanced PL/SQL coding to implement the complex business logic.
Developing New Forms as per the Business Requirement by using Oracle reports 6i & 10g.
Developing Reports as per the Business Requirement by using Oracle reports 6i & 10g.
Supporting to the existing forms and reports and enhanced the new client requirement.
Analyzing the client requirement and design the code for front end screens.
Optimizing SQLs using Explain Plan. Writing the DB programs using the advance PL/SQL like collections, Object Type etc.
Developed the reports through materialized views.
Contact this candidate