Resume 11

SUMMARY:

• More than Six years of strong IT experience in the field of software designing and developing using Oracle 9i ,Oracle 8i / 8 , 11i, Oracle 7.0/7.3, Oracle Web Forms 6i, Oracle Web Reports 6i ,Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Graphics 2.5, GL, AR, FA, AP,PO, Oracle Workflow ,Pro * C, Sql * Forms 3.0, SQL PLUS and PL/SQL, Import and Export under Unix, and Windows NT environment that involves system study and analysis, design, coding, preparation of user manual, testing and debugging of software , implementation and training for users.

• Proficiency in PL/SQL 8.0 programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT. Developed SQL Reports using SQL*PLUS.

• Developed several packages using VBA, Visual Basic 6.0, Crystal Reports 8.0, SQL Server 6.5 and MS Access.

• Good experience with VBScript, ASP, HTML, Java Script, JDBC, Servlet, Jdeveloper, RMI, Java Swing, SQLJ, Visual FoxPro 6.0. Good knowledge of Cobol and C programming.

TECHNICAL SKILLS:

• Internet Technologies : HTML, Java Script, JDBC, XML, Servlet, RMI, Java Swing, Jdeveloper, ASP, Perl , JSP

• Databases : Oracle 7.0/7.3, Oracle 8,8i, Oracle 9i, SQL-Server v 6.5, SQL PLUS 3.10, PL/SQL 2.0, 2.3,8.0 MS-Access v7.0, Oracle 11i, Oracle Server Pages

• Programming Languages : Cobol, C, C++, Pro*C

• GUI Tools : Visual Basic v6.0, Developer 2000, Designer 2000/6i, Discoverer 2000, Forms 4.5, Reports 2.5, Graphics 2.5 , Forms 6i, Reports 6i , Power Builder 6.5, Crystal Reports 8.0, VBA

• ERP : Oracle Applications-Financials Rel. 11i GL, AR, FA, AP, Oracle Workflow

• DBMS : Visual FoxPro v6.0

• Operating Systems : Windows 98/95, Windows NT/XP, Unix

• Applicatons : MS Office 2000 ,MS Word , MS Excel, MS Access, MS Powerpoint, MS Project , Lotus 1-2-3

PROJECT EXPERIENCE:

• Involved actively in full life cycle of he project which includes screen design, table design, preparation of user manual, preparation of test plans and development of the program using Developer 2000, Designer 6i & Discoverer.
• Interaction with Development Team in fine Tuning the SQL and PL/SQL 8.0 Codes.
• Implementation of Oracle & Application Software Patches.
• Designed and implemented the extract, transformation, and load of source data into the data warehouse and data marts. This included developing and building the transformation processes using Ardent Data Stage along with custom PL/SQL.
• Used Oracle Portal 3.0 to develop a customer tracking system
• Conversion of existing Forms 5 to Forms 6i and Reports to Reports 6i.
• Developed Forms using Forms 6i and custom reports were generated using Reports 6i.
• Writing database creation scripts & PL/SQL 8.0 server side stored procedures, functions and triggers, SQL*Net installation and configuration.
• The front end consists of Oracle Web forms which allow the user to login and enter the input processing information, such as file name, date, month and year and submit the form for the load process.
• Used Oracle InterMedia, which enables to manage documents, images, audio and video for full Text Search.
• Graphical representation was depicted used Graphics.
• Developed a web application for Customer Signups for internet service using PL/SQL packages , JavaScript, JDeveloper and Html.
• Creation of Users, Roles & Privileges, Table/Index/ Rollback Segments and Constraints.
• Loaded Oracle tables from flat files using SQL *Loader.
• Maintaining a Test & Development Databases.
• Effective use of Oracle Designer 6i ,Developer 2000 & Discoverer for generating .pdf reports according to the client s requirements.
• Developed Test Plans and test cases for coding.
• Provided User Training and dealt with customers of various degrees of computer knowledge.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT.
• Developed SQL Reports using SQL*PLUS.

Scope of the Project: AARP is a nonprofit, nonpartisan membership organization for people 50 and over. AARP provides information and resources; advocate on legislative, consumer, and legal issues; assist members to serve their communities; and offer a wide range of unique benefits, special products, and services for its members.

Environment: Oracle Designer 6i , Oracle Developer 2000 , Discoverer 2000, Oracle 8i/9iAS,11i SQL*Plus, PL SQL 8.0, Oracle Web Forms 6i, Oracle Web Reports 6i, ASP, JavaScript, HTML ,Oracle Portal, Jdeveloper, Windows 95/98/2000/NT-4.0/XP, UNIX HP-UX, Solaris .

• Responsible for converting vendors, sites and contacts from a legacy system into Oracle Payables 11i.
• Provided support of applications to team member.
• Used Discoverer 2000 to set-up ad-hoc queries and reports.
• The package has been designed using Oracle Financial Modules GL, AP, AR, FA .
• Developed Test Plans and Test cases for coding.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers including standard packages like DBMS_SQL, DBMS_PIPE, DBMS_JOBS, UTIL_FILE, DBMS_OUTPUT.
• Developed SQL Reports using SQL*PLUS.
• Actively involved in the design and development of a number of custom applications centered around purchase order billing and administration applications. These applications were designed using Unix scripts, SQL*Menu 5.0, SQL*Loader 1.0 and PL/SQL.
• Extensively used Forms/Reports 6i to customize 11i Forms and Reports then attach it to the 11i Application.
• Analysis and design of data flow between the various components.
• Redesigned existing Reports to Oracle Web Reports 6i and 30 new Reports.
• Used FSG to build GL Reports.
• Involved in the implementation of the software.
• Developed Sub Reports & added parameters in Crystal Reports 8.0
• More than 15 Reports were created in Crystal Reports 8.0.
• Fixed reports that weren t working using Oracle Reports, SQR & Crystal Reports 8.0
• Oracle Financials modules include General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets, Cash Management, Order Entry and Inventory.

Project Details: Mostek has implemented the customized packages such as Vehicle invoicing, Spare parts billing, Payroll etc for its Maruthi and Bajaj Dealers.

Environment: The software was developed using Windows 98/ Windows NT/Unix, Pro*C, Oracle Financial Modules GL, AP, AR, FA ., Oracle 11i,8i Forms 6i, Reports 6i, Crystal Reports 8.0

• Table design, screen design and development of the program using Designer 2000,Developer 2000, SQL * PLUS and PL/SQL 2.3.
• Developed Forms and Reports using Forms 4.5 and Reports 2.5. Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Prepared the design specification documents, test plan for all the above modules.
• Provided support of applications to team members.
• Provided User Training.
• Oracle 8 was used as backend.
• Developed SQL Reports using SQL*PLUS.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Analysis and design of data flow between the various components.
• Provided support in the implementation of the project.
• Used SQR, Report writer 2.5 & Crystal Reports 7.0 to generate reports.
• Inventory reports were developed using Crystal Reports 7.0.
• Graphical representation was depicted used Graphics 2.5.

Project Details: The project was undertaken to deliver a proper systematic maintenance of Nightingales Home Health Services. The package was developed to maintain the duty timings of the doctors, nurses and other staff, doctors and other technical staff attendance details, lab maintenance, purchase of new equipments, availability and occupation of beds and rooms, supplier details who supply the medicines and equipment to the lab, stock details in the pharmacy and maintenance of accounts which includes the payments to the staff and the payment made by the patients.

Environment: The software was developed using Windows 98/NT/Unix, Pro*C, Designer 2000, Developer 2000, Forms 4.5, Report writer 2.5, Graphics 2.5 , Crystal Reports , Oracle 8.

• Screen design, preparation of user manual and development of the program using Developer 2000,Forms 4.5, Report writer 2.5, Graphics 2.5, SQL * PLUS and PL/SQL 2.3.
• Provided User Training.
• Prepared the design specification documents, test plan for all the above modules.
• Oracle 7.1 was used as Backend.
• Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Used PL/SQL programming to develop Stored Procedures/Functions and Database triggers.
• Provided support in the implementation of the project.
• Analysis and design of data flow between the various components.

Project Details: It involves the maintenance of customer details who belonged to regular/ordinary category, marketing executive s details and the target assigned to them every month, rate details which describes the various rates assigned to various destinations like local, domestic and international, contract details with various companies .

Environment: The software was developed using Win 98/Unix, Pro*C, Dev/2000 , Forms 4.5, Report writer 2.5, Graphics 2.5 as Front-end and Oracle 7.1 as Backend.

• Development of the program using Developer 2000, SQL * PLUS and PL/SQL.
• Used Oracle 7.1 as Backend.
• Developed database procedures, functions and Packages.
• Developed database triggers and stored procedures using PL/SQL cursors and tables .
• Developed Forms and Reports using Forms 4.5 and Reports 2.5. Developed database triggers and stored procedures using PL/SQL cursors and tables and DBMS_SQL.
• Developed data entry screens and generated code.
• Developed Master-Detail forms for master tables and transaction tables.
• Analysis and design of data flow between the various components.
• Developed SQL Reports using SQL*PLUS.

Project Details: The software was delivered for the maintenance of sales executive s details and the target to be achieved by them every month, customer s details. The project highlights the maintenance of pager master which involves the details of pager booking and issuing date, pager type which the customer is interested in i.e. numeric/alpha numeric and the payment mode i.e. bi-monthly, monthly, quarterly, fortnightly, yearly .

Environment: The software was developed using Win 98/ Unix , Pro*C, Developer 2000, Forms 4.5, Reports 2.5, Graphics 2.5, SQL*PLUS and PL/SQL 2.3. Oracle 7.1 was used as Backend.

• Table and screen design and development of the program using Visual Basic 6.0 and MS-Access.
• Developed data entry screens and generated code.
• Developed Master-Detail forms for master tables and transaction tables.
• Prepared the design specification documents, test plan for all the above modules.
• Extensively used Crystal Reports for generation of Reports.

Project Details: The System study included to give a better management in Controlling the Student admissions, Course management, Student fee collections, Generation of fee receipts, customized Stock maintenance of books, stationeries, lab equipments, purchase of new lab equipments and maintenance of accounts which includes the payments to the staffs, suppliers of lab equipments, suppliers of stationeries and furniture. Staffs details such as staff attendance, staff leave details, classes and subjects handled, payroll were also dealt with. Developed custom VBA application for Excel that creates templates from spreadsheets and updates master XL files.

Environment: The package was developed using VBA, Excel 97, Visual Basic 6.0 , Crystal Reports, MS-Access 97 ,Win/98.

• Preparation of user manual and development of the program using Visual Basic 6.0 as Front end and SQL Server 6.5 as Backend.
• Developed data entry screens and generated code.
• Prepared the design specification documents, test plan for all the above modules.
• Crystal Reports was used to generate the reports.

Project Details: This software was developed to maintain the admission and discharge of patients. It also deals with the Inventory that includes receipts, issues and returns. Doctors, staffs schedule, and their duty lists were also maintained.

Environment: The package was developed for the Hospital using Visual Basic 6.0 ,Crystal Reports and SQL Server 6.5, Win/98

• Development of the program using Visual Basic 5.0 , SQL Server 6.5 .
• Developed Reports using Crystal Reports.

Project Details: The software was developed to maintain the library in a customized way. The maintenance included member details which was categorized into regular and ordinary, their membership details, books available in the library, books issue details, books return details, stock maintenance, book supplier details, payment to the suppliers, generation of receipts for the membership payment and issue of receipts for the fine amounts.

Environment: The software was developed in Visual Basic 5.0 , Crystal Reports, Ms Access.

ACHIEVEMENT:

Certified by Brainbench Oracle Developer 2000.

TRAINING UNDERGONE:

Diploma in Systems Management from NIIT, Chennai, India.
Diploma in RDBMS from Software Solutions Integrated Limited, Chennai, India.
Certificate Course in Advanced Java from Amionics, Chennai, India.

EDUCATION:

Master of Arts Public Administration from University of Madras, Chennai, India.
Bachelor of Arts English Literature from Justice Basheer Ahmed Sayeed Women s College, Chennai, India.