VIJAY KUMAR YADA Mobile: +91-964*******
Email:
**.********@****.***
Professional Objective
* ***** ** ** ********** as Technical consultant. Proficient in the
software development life cycle from Analysis, Design and Development. I
have extensively worked on module Penta ISF.
Professional Summary
. Expertise in Implementation, Customization and Conversion of
various modules.
. Having Technical Knowledge in Database (Oracle - SQL,PL/SQL,
PostgreSQL), Oracle Forms and Reports
. Responsible for understanding and analyzing the Reports.
. Expertise in Development and Customization of Forms & Reports.
. Good Exposure on Oracle SQL, PLSQL, & Reports
. Experience in writing Stored Procedures, Functions, Packages &
Triggers using SQL*Plus and PL/SQL.
. Very well to preparing the unit test case
. Writing the Internal Documents
Professional Experience
. Currently working as a Sr. Oracle Developer in Aetins Software Pvt.
Ltd from October 2011.
. Worked as a Technical Consultant for Kapil Chit Funds Pvt. Ltd.,
Secundrabad from June 2009 to September 2011.
Educational Qualifications
. MCA from Kakatiya University.
. B.Sc (M.Ele. CS.) from Kakatiya University
Technical Skills Summary
Languages SQL, PL/SQL, C, JAVA, VB6.0
Database Oracle 8i/9i, PostgreSQL.
GUI Oracle Forms and Reports, Crystal Reports
Operating Systems Windows, Unix.
Project Details
Project 1:
Project Name : HLA
Client : Hong Leong Assurance Berhad
Technologies : Oracle Forms, Reports, SQL-PL/SQL, Windows.
Project Type : Implementation and Support
Scope:
Hong Leong Assurance Berhad (HLA) is one of the largest insurance
companies in Malaysia. It is a well-established and respected Malaysian
brand offering financial planning and protection solutions to meet the
various needs of Malaysians at different cycles of their lives. Commitment
to the customer is the key to HLA's success, where service is provided
through a large network of branches, agents and brokers throughout the
country as well as ban assurance and alternative distribution channels.
Responsibilities:
1. Involved in development of Forms and Reports Creation.
2. Defining Database.
3. Coordination with the Package.
4. Created PL/SQL Packages, Procedures, Functions as per the requirement.
5. Involved in the development and customization of the following Forms
6. Unit testing and preparing internal documents.
7. Solving the Issues
Forms:
1. Customized General Enquiry Screen Form
2. Customized policy servicing for Premium Deposit to Cash Dividend
Form
3. Customized policy servicing for CSV (Cash Surrender Value) master
setup Form
4. Customized the Policy serving for Loan process
5. Customized the Granting Loan and Recovering the existing loan(s).
Project 2:
Project Name : EAGLE
Client : Aviva Life Assurance, Malaysia
Technologies : Oracle Forms, Reports, SQL-PL/SQL, Windows.
Project Type : Implementation and Support
Scope:
Takaful in a nutshell means 'joint guarantee'. Its basic idea is where
a group of people agree to a contract and cooperate to assist each other in
the event of misfortune of a participant. All parties to a contract must
conduct in accordance to the utmost good-faith principles. The
transactional aspect of Takaful is subject to Islamic law. In keeping with
the practice of mutual cooperation and mutual guarantee, Takaful embraces
the approach of assistance within the participants of the group.
Responsibilities:
1. Involved in development of Forms and Reports Creation.
2. Defining Database.
3. Coordination with the Package.
4. Created PL/SQL Packages, Procedures, Functions as per the requirement.
5. Involved in the development and customization of the following Forms
6. Solving the Issues
Forms:
1. Developed Loading the excel data into forms for Group exit policies
2. Customized Nomination Form
Reports:
1. Developed the Gratuity Payments Report.
Project 3:
Project Name : Easy Chit Management System
Client : Kapil Group
Duration : June 2009 to till date
Technologies : VB6.0, PostgreSQL, Windows, and Seagate Crystal
Reports
Project Type : Implementation
Scope:
Kapil Chit funds is a 28 year old private limited company registered
in the year 1981. Kapil traces its humble beginning in a rented premise
near clock tower in Karimnagar town. Kapil is now today a part of the
larger Kapil group which has interest in Bread Manufacturing, Real Estate,
Cancer Hospital and Marketing of other financial products, Plastics,
Medicinal and aromatic plants etc. The company today has over 200 offices
across Andhra Pradesh. The turnover of the company was exceed 1,000 crores.
Over the years, we have satisfactorily given service to over 4,00,000
subscribers. Over 2000 people work every day, at various levels in the
organization helping the company grow and nourish, thereby helping
themselves climb up the value chain.
Responsibilities:
1. Involved in development of Forms and Reports Creation.
2. Defining Database.
3. Coordination with the Package.
4. Created PL/SQL Packages, Procedures, Functions as per the requirement.
5. Involved in the development and customization of the following reports
6. Solving the Issues
Forms:
1. Designed and Developed By TR Management, TR Delay Report Form
2. Designed and Developed Journal Voucher Form
3. Designed and Developed By Bank Setup, Cheque Management, and Cheque
Enquiry.
4. Designed and Developed By Journal Voucher Entry Form and JV list.
Reports:
1. Developed the TR Book Issue, Missing, Received and Stock Report.
2. Developed the Specimen(s) Report
3. Developed the Subscriber Account Report
4. Developed the Cheque Enquiry Report
5. Developed the Chit Payment Report
6. Developed the Journal Voucher Report.
Project 4:
Project Name : House Held Computing Management
Client : Kapil Group
Duration : May 2011 to till date
Technologies : VB6.0, PostgreSQL, Windows, and Seagate Crystal
Reports
Project Type : Implementation
Scope:
Kapil Chit funds is a 28 year old private limited company registered
in the year 1981. Kapil traces its humble beginning in a rented premise
near clock tower in Karimnagar town. Kapil is now today a part of the
larger Kapil group which has interest in Bread Manufacturing, Real Estate,
Cancer Hospital and Marketing of other financial products, Plastics,
Medicinal and aromatic plants etc. The company today has over 200 offices
across Andhra Pradesh. The turnover of the company was exceed 1,000 crores.
Over the years, we have satisfactorily given service to over 4,00,000
subscribers. Over 2000 people work every day, at various levels in the
organization helping the company grow and nourish, thereby helping
themselves climb up the value chain.
Responsibilities:
1. Involved in development of Forms and Reports Creation.
2. Defining Database.
3. Coordination with the Package.
4. Created PL/SQL Packages, Procedures, Functions as per the requirement.
Forms:
1. Designed and Developed By Uploading and Downloading
2. Designed and Developed User Management like User Creation, Changing
Password and allocation of machine
3. Designed and Developed By Journal Voucher Entry Form and JV list.
4. Assigning the Machine Number.
Reports:
1. Developed the Unit Wise Report on date.
2. Developed the Downloaded Receipts Report