PREM ANAND

Professional Summary:

• Around ** years of Experience in IT with 15 years of Oracle ERP Experience.

• 18 Years of Database Administration Experience

• Have completed more than 30 Full Cycle Oracle ERP Implementations

• Has Done extensive Oracle Applications, Database Administration, Project Management, Applications, Database, Middle Tier, Network, Systems, Solutions Architecture, and, Infrastructure and Applications Implementation, Database Administration, Security Design,RAC,OID and Operation Readiness.

• Has lead various teams in Oracle Applications, DSS, DW and DBA projects.

• Managed numerous databases for 11.x, 10.x,9.x,8.x,7.x,6.x,5.x,4.x

• Has Designed for Logical and Physical Databases for various projects.

• Implemented financial and manufacturing modules.

• Has done extensive Unix [Solaris and HP] and NT system management.

• Has over 21 years of diversified experience in systems implementation, database administration, project management and program management. Has managed numerous projects covering a wide variety of industries and business practices. He has extensive experience in the technology, management and execution of large full life-cycle system development projects, as well as mid-sized rapid implementation projects.

• For the past 13 years since joining Oracle, Mr. Anand has managed several Oracle applications implementation and upgrade projects for a variety of clients. He has a strong knowledge of Oracle applications and Oracle’s implementation methodology.

• Expertise in Implementation, Integration, Development, Migration, Legacy Conversions, Customization, testing, tuning and migration of Oracle Financials & Distribution modules which include OM, AR, TCA, GL, AP, PO, FA, INV,MRP, Shipping, Quoting, Install Base, Planning, pricing, Work Flow, PA, AOL and System Administration.

• Expertise in developing interfaces using Oracle Standards and Oracle APIs.

• Expertise in functional and technical design of interfaces.

• Developed and customized forms and reports as per the business requirement.

• Excellent Knowledge in Data model in 10.x and 11.x

• Datamart, Oracle FUSION and Data Mining Expert

• Experience in Oracle BPEL Process Manager, BPEL Console, SOA architecture, Web Logic, Oracle Fusion Middleware, AIA and OA Framework.

• Excellent knowledge in SQL, PL/SQL, Developer 2000, Forms 6i,9i,10g, Reports6i,9i,10g, Workflow, Discoverer and Database Design with Oracle.

• Experience in Oracle RDBMS and its tools SQL, PL/SQL, SQL* Loader, SQL*Plus, SQL Navigator and TOAD.

• Experience in writing Stored Procedures, Triggers and Cursors in Oracle for various conversion programs.

• Strong Conceptual, Business and Analytical skills. Highly motivated team player with immense ability to grasp new concepts and apply them.

• Excellent Communication, Interpersonal Skills and Leadership Qualities.

• Has demonstrated extensive technical/database management and application delivery, understanding of business vision, process development.

• Ability to work as a team member and/or lead technical efforts in a cross-functional matrixed environment.

• Worked closely with others in team environment to achieve common goals and SLA’s.

• Strong presentation, communication, and teamwork skills.

• Excellent leadership skills, as well as both oral and written communication skills.

• Capable of working under high pressure and a good team player who can be flexible and work individually.

• Presented a paper in 1998 Oracle Open World - “6th Dimension of accessing extern programs with Oracle Database”

• Currently writing a book on Technology and Architecture

EDUCATION:

Bachelor of Engineering, India. – Madras University.

Masters in Computer Applications, Madras

Technical Skills

CAPABILITIES

Methods & Techniques

• Oracle Application Implementation Methodology (AIM) 3.0, 2.0

• Program/Project Management

• Oracle’s Project Management Method (PJM) • Oracle Custom Development Methodology (CDM)

• Business Process Reengineering

• Data Conversion

• Oracle Database Administration

Applications

• Assets

• Oracle Foundation (AOL)

• General Ledger

• Human Resources

• Receivables

• Supply Chain Planning

• Order Management

• ISupplier

• Customer Relationship Management

• ISupport

• Inventory

• Advance Shipping & Planning

• Service

• Sales

• Oracle Projects

• Financials

• Supply Chain Management(SCM)

• Manufacturing • Inventory

• Payables

• Payroll

• Purchasing

• Oracle Benefits

• IProcurement

• Projects

• Daily Business Intelligence

• Portal

• Financials Family

• Taxware

• Call Center

• Bill Of Materials

• EDI

• Oracle Marketplace Exchange

• PLM

Databases

• Oracle 11.x,10g, 9.x, Oracle8.x, Oracle7.x, Oracle6.x, Oracle 5.x

• 10GRAC

• mySQL

• OPS

• Sybase

• DB2

• SQL Server

Tools

Oracle Applications versions R12,11i, 11.x, 10.7 (NCA, SC, char.)

Kintana

SQL*Plus, SQL*Loader, SQL*Net, Oracle Forms, Oracle Reports, Designer, Oracle Enterprise Manager

MS Project, MS Word, MS Excel, Visio, Exceed

10gAS,9i AS 2.0/1.x, OID, Data Guard, Veritas Cluster, Sun Cluster, OMB, iFS, OEM 2.x/9I, iStudio, EJB, BC4J, OC4J, Jdeveloper 2.x/3.x/4.x, Portal DB, Java, XML, Oracle Applications [Applications] server 3.x/4.x, Designer, Repository 6I, Reports server 9i/6i/6.0/3.0, Developer 9i/6i/6.0/2.1 server, Oracle Express Administrator (OEA) 2.1/6.x, Oracle Express Objects (OEO) 2.0.1/6.x, Discoverer 3.x, 4.x, Oracle Express Server 6.X, Personal Express (pcExpress) 5.0.1/6.x,

Netegrity Site Minder, Oracle Internet Directory 3.x/9.x, Expert, C, C++, Pro*C, Sql*Loader, Java (JDK) 1.2/1.7/2, Oracle Financial Analyzer (OFA) 6.X, Shell Programming, OEM 1.x/2.x/8i/9i/10g, HTML,JSP, Java Servlets, XML, OAG, Perl, Datamart, Business Intelligence, Wall Street Office Suite of Reports and Portfolio Manangment

Hardware & Operating Systems

• SUN- SunFire, E15K, 12K, 10K, IBM RS/6000, Dec Alpha, HP Super domes, HP 9000, IBM PC and compatibles,

• Linux

• UNIX (HP Unix, AIX, Sun Solaris, DEC Unix), Windows (XP, 2000, NT, 98, 95, 3.x), Novell Netware, MS-DOS

• Mac System

• OS/2,VAX VMS

Industries

• State and Provincial Government

• Federal Government

• Utilities

• Networking

• Architecture & Engineering

• Finance

• Manufacturing

• Telecom

• High Technology

• Retail • Internet and Dot coms

• Healthcare

• Tech - Hardware and Software

• Retail

• Insurance

• Banking

• Telecom

Professional Experience:

Employer: Tech Ambience

Duration: June 2004 – Current

Role: DBA and Technical Architect

Projects:

• Tech Ambience: Working as Oracle Applications DBA and Solution specialist.

• L3 Communications: Worked as Lead and Manager to upgrade R12

• Upgraded and maintained Oracle RAC, Oracle Fusion, Data Mart and Data Warehouse

• Used Oracle ERP R12 and Wall Street Office Suite of Reports and Portfolio Management to manage $250B of assets for consortium of Private Equity Group.

• Brodart: Worked as Architect and DBA for Release R12 Oracle ERP

• GE Unison Industries: Worked as Technical Manager for database administration for the new Oracle R12 Applications with RAC for their enterprise architecture. Managed 30 people (7 onsite and 23 offshore).

• For Tetratech, Los Angeles: Worked as APPS DBA and implemented R12 with 10g database in AIX along with hot standby, RAC,ASM, RMAN backup & Recovery, storage management, training of 12 and 10g db, Overall security and administration on IBM AIX.

• For Florida State Government, FL: Worked as DBA and implemented RAC 10G on Windows NT platform and HP storage.

• For Markwins, Los Angeles: Worked as DBA and Implemented R12 Cloning for sun solaris to a Reporting Instance.

Employer: Oracle Corporation

Duration: August 1997 – June 2004

Role: Technical Director

Projects:

• For Xilinx, San Jose: Worked as APPS DBA and upgraded 11i production instance.

• For Aramark, Los Angeles: Worked as DBA and produced TA.130 for performance of their 11i instance on HP dome.

• For UTStarcom, Alameda,CA: Worked as Technical, Infrastructure and Architecture Manager reporting to the CIO for 11.5.9 implementation of GL, AP, FA, PA, PO, iP, OM,ASCP, BIS,iS and Portal for this global telecom company. Implemented multi-language global design, ASM, Veritas Cluster management, network design and implementation, storage management, data guard, hot standby,OID, RAC, Disaster & Recovery solution, Failover solution, High Availability solution, Business continuity Planning, overseeing apps installation and maintenance, conversion and integration, backup and recovery, performance and network engineering, portal design, workflow, and reporting, single, Data Center Operation Readiness, Discoverer installation and administration, RMAN procedures, Fax, PO and Printing administration, OEM, Chart of Accounts Design, Rapid Cloning, Instance Strategy, at least 1000 pages of Technical Documentation (TA.10, TA.15, TA.20, TA.30, TA.50,TA.60.TA.80,TA.110,TA.120, TA.130,TA.150, MD.050). Also leading Technical and Functional consultants for the project.

• For GAP Inc, San Bruno,CA: Worked as Technical, Infrastructure and Architecture Manager for 11.5.8 implementation of GL, AP, FA, PA, PO, iP, iE, DBI,iS and Portal for this global Retail company in IBM AIX platform. Implemented multi-language global design, Veritas Cluster management, storage management, data guard, hot standby, single sign on with Oracle Internet Directory and Netegrity Site Minder, apps installation and maintenance, conversion and integration, backup and recovery, performance and network engineering, portal design, workflow, internet punchouts to external catalogs, data warehousing and reporting, single, Data Center Operation Readiness, BCV splits from Production OLTP to Reporting Instance, OFA and Express design, installation and administration, Discoverer installation and administration, RMAN procedures, Fax, PO and Printing administration, OEM, Chart of Accounts Design,RAC, Rapid Cloning, Instance Strategy, at least 1000 pages of Technical Documentation (TA.10, TA.20, TA.30, TA.50,TA.60.TA.80,TA.110,TA.120, TA.130,TA.150) and Identity Management

• For SBC, San Francisco: Worked as Project Manager, Architect and APPS DBA, in this big Telecom Company, for implementing Oracle Applications 11.5.4 Payables, GL, Receivables and Projects. Managed the Project, and implemented Veritas cluster management,OID,ASM and RAC. Installed applications environment, and, performed cloning, backup and recovery strategies, performance tuning [server, middle tier, db, sql and index tuning, client tuning et all], and provided production support

• For Bellsouth, Atlanta: Worked as DBA Manager for this Telecom Giant in East, implementing 11i Apps – CRM, SDP, iStore, S4Comm, OM, CSC, and iSupport which includes maintenance of 20 apps instances, supervising custom development, application of adpatches, cloning of apps env and overseeing a team of consultants, and implementation of the custom application OID.

• For Expanets, Tampa, FL : Worked as APPS DBA. For 11.5.4 upgrade – CRM, OM, Inventory, Shipping, ASCP Was also responsible for backup, support, module and system integration, and testing of the application.

• For Adelphia Communications, Coudersport,PA: Worked as Project Manager, Architect and DBA for nearly 12 systems in a cable company. Also, worked as Project Manager for Migration, Data Warehouse and Network Db tuning for Oracle Consulting group. Was actively involved in overall project management, Overall storage management, and, installed numerous APPS modules [GL, AP, AR, Call Center, CRM, iSupport] and 8i install, wrote documents for migration of db [7.x to 8i V2] - strategies, data center operation readiness, contingency plan, replication, advance queues, OCI, migration of db, performed tuning for the entire server systems, created Hot Standby db for the client [automatic process] and RMAN. Implemented Replication for 3 servers, created change plan [management] strategies for the client using OEM, and implemented failover strategies and recommendations, supported day-to-day DBA activities and installed multiple pipelined OMS servers and OEM Clients, and, created testing strategies for all the production systems and process modeling for the all process.

• For Bellsouth Atlanta(Different 11i instance): Worked as Apps Technical Manager for Oracle Applications 11.5.4 upgrade – CRM, Sales and Comp, iSupport, Service for Comms, iStore, OM, Inventory, CSC and custom modules. Responsible for 11.5.4 and 8.1.7.1 upgrade.

• Installed and configured 3 multi-tier instances of 11.03 on HP - which included OAS, 8i, APPL_TOP & supply chain products.

• Implemented numerous 10.x and 9.x applications

• Worked in WebDB, Java classes, JavaScript, XML, Jdeveloper, 8i and JDBC for an 11i project. Worked in cluster management for IBM.

• For APS, Phoenix, AZ: Worked as a DBA for 9iAS custom portal applications.

• For Nortel Networks, Raleigh/Durham, NC: Worked as Oracle Technical DBA for 9iAS portal for Nortel’s Real Estate group. Responsible for 9iAS setup, configuration, development, module and system integration, implementation, and, performance tuning.

• For Expanets, Tampa, FL:

Worked as APPS Technical lead DBA. For 11.5.4 upgrade – CRM,OM,Inventory,Shipping,ASCP .Was also responsible for backup, support, module and system integration, and testing of the application.

• For Duke Energy, Houston, TX:

Worked as Lead Architect for installing, configuring and testing 9iAS[portal DB, Jdeveloper, BC4J, EJB, XML, JAVA, OC4J, Forms Server, Reports Server et.]. Used Oracle Designer for process, logical and physical Modeling of the application.

• For BellSouth, Atlanta, GA:

Worked as Technical Lead DBA Manager for Bellsouth 11i Apps – CRM, SDP, iStore, S4Comm, OM, CSC, iSupport – which includes maintenance of 20 apps instances, custom development, application of adpatches, cloning of apps env and overseeing a team of consultants, and implementation of the custom application.

• For Adelphia Communications, Coudersport, PA:

Worked as Project DBA Manager for nearly 12 systems. Also, worked as Project Manager for Migration, Data Warehouse and Network Db tuning for Oracle Consulting group in Adelphia.

Worked for this client for more than a year.

Installed numerous APPS modules [GL,AP,AR,Call Centre,CRM,iSupport] and 8i install, wrote documents for migration of db [7.x to 8i V2] - strategies, contingency plan, replication, advance queues, OCI, migration of db, migrated 12 systems from 7.x to 8.1.6.2.1.

Performed Tuning for the entire server system of Adelphia.

Created Hot Standby db for the client [automatic process].

Created RMAN scripts and implemented in the client production servers.

Implemented Replication for 3 servers.

Created change plan [management] strategies for the client using OEM.

Created new 8.x features like partitioning, iot, function based indexes etc.

Created new data migration strategies like transportable tablespaces, etc

Created data mart for the client.

Created Oracle parallel server env.

Implemented failover strategies and recommendations.

Supported day-to-day DBA activities.

Installed multiple pipelined OMS servers and OEM Clients.

Created testing strategies for all the production systems and created process modeling for the Process

• For Bellsouth, Atlanta:

Installed and configured 3 multi-tier instances of 11.03 on HP - which included OAS, 8i, APPL_TOP & supply chain products.

• For Milwaukee Public Schools, Milwaukee:

Performing tuning, using OEM and custom scripts, was done for their HP production server and EMC disk array. Tuning was done on database server, SQL and applications. The production server was made faster for 500 average user system and all bottlenecks for the application [Student management System] were rectified. Day-to-Day DBA activities were done.

For AT&T, New Jersey:

Lead the team for Technical Architecture for a Web based [OLTP] project called UNAD. UNAD, which was the first network provisioning software over the internet in states, ran against 8i and used Oracle applications server (4.0.7.1) and reports server (6.0) for its launch. Created and maintained development dB, test dB and production dB, the application server and created the reports server for different groups. The responsibilities included maintenance of application and reports server, creating templates for API’s, reports and HTML scripts, writing specifications for owner management, network provisioning, forecast and cma, and, writing code for certain modules.

The project had various modules – Network provisioning, c&ma, forecasting and owner management. The system deals with forecasting of cable systems, provisioning network elements and management of owners like ITSC, OSWF, NA and single or joint owners.

Things done for the project:

1. Wrote shell program for production change plan and maintained day-to-day DBA activities

2. Backup procedures using RMAN

3. Designed the security of the entire application

4. Design of the system was done by Oracle Designer

5. Configuring cluster environment over 2 nodes

6. Created monitoring scripts for reports server, application server and db

7. Created business specs, detailed specs for modules

8. Wrote web based pl/sql packages

9. Wrote templates for pl/sql and reports

10. Performance tuning

11. Creation and maintenance of development, test and production databases

12. Failover strategy

13. Decryption and encryption of db application passwords

14. Created bug tracking system

15. Testing

16. Documentation

For Raytheon Engineers and Contractors, Chicago:

Lead oracle team for 2 plants for Y2k conversion - Avon and North Lawrence.

The client for the plants was Kraft foods. All the plants had equipment and code

Which was not Y2k complaint.

The goal was to provide hardware and software, which will run the plant next century.

The front end used was Rs/View,Rs/Sql and Rs/Linx. The back end was oracle 8.0.5.

Things done for the project are:

1. Study of the existing system and maintenance of day-to-day DBA activities

2. Created Business process flow using Oracle Designer

3. Created functional flow using Oracle Designer

4. Created logical database design using Oracle Designer

5. Created physical database using Oracle Designer

6. Converted legacy data from INGRES and imported to oracle using sql loader

7. Created data files, rollback segments and tuned the base system

8. Created test environment

9. Created Pl/Sql packages for data move

10. Created reports [in business objects] and support [maintenance] programs in VB

11. Worked with the front end for the system integration

12. Setting up the NT front end server

13. Setting up the NT clients

14. Setting up the HP Unix [for oracle]

15. Hardware setup

16. Integration

17. Testing strategies were created and implemented

18. Documented the process

For the AVON plant [which is essentially a weigh system], sends weigh data from the

PLC units to the Oracle database through Rs/View and Rs/Sql. This system is capable

of sending nearly 1000 records every 90 seconds.

This data instance is the application database instance.

Every four hours a cron job runs at the Unix four and transfers the data for the previous

four hour period to another different schema [called MES repository] through Pl/sql where

data is stored for certain amount of time.

The data transfer between the front end [RS/View] and the oracle db was done through

Rs/Sql and Net OCI.

The reports were done in business objects and integrated with the front end.

• For Lucent Technologies, IL:

Conversion Strategy, estimation and Conversion Approach for their current system.

• For National Ins., Columbus, Ohio:

Supported the data modeling team in designer 2000. Created standards for Business Process, Logical design and Database design in Designer 2000. Created Process modeling diagrams and ERD for their forthcoming projects.

Responsibilities include requirements analysis; project planning, management and database design. The project was to build a financial DSS system for various levels of management in the organization using Oracle Financial Analyzer 6.0.1.1 and Oracle Express Server 6.1.0.1.2 that will ensure data integrity, analysis and forecasting.

• For Oracle Corporation, Los Angeles:

Assisted in the development of extensions to the Enterprise Data Management [EDMS] software package that is marketed by Oracle Services. The extensions analyze PL/SQL, Pro*C, and Forms 2.3, 3.0, 4.0, and 4.5 code for year 2000 issues. The development environment was Designer 2000, Pro*C and forms 4.5 on Windows 95 and NT.

This project was an impact analysis tool creation, which analyses a form build in

Oracle forms 2.3,3.0,4.0 and 4.5 and stores the form control variables, base variables,

Pl/Sql variables and Stored procedure variables [which has Date Format] in the Designer/2000 Repository.

An API report was created to access the tables and views of the Designer/2000 and

give them in a tabular format.

• For NorthWestern Mutual Life, Milwaukee, WI:

Lead a team for Individual Life [Insurance] Custom Development and supported other teams [Group and Premiums].

Designed and Created 9 forms and 5000 lines of code of Pl/Sql, which involved Oracle, Sybase and Mainframe Databases. Day-to-day DBA activities were performed.

The main form ‘NBIENTRY’ - which is the app entry, had 18 canvases and had a reference of nearly 6 other forms. A user can enter the app entry screen through the launch screen, [a common screen for all the entire app], which assigns an individual contract for a particular group contract.

The form was built against 2 sets of views. Before validation of data, the user can

come through one set of tables and after validation they can come through another set of tables.

This was done because the client had data in Oracle [normalized and non-normalized tables] and in Sybase [normalized data tables]. For this variation, private synonyms were used to switch the data back and forth. Private synonyms will be created at runtime for that particular schema. Hence only one set of blocks was created in the forms for both variations.

The user can enter the app [which is saved and updated in both oracle and Sybase

Databases through ‘OMNI’]. There are nearly 100 business [screen] rules against the entries.

Once the app is entered and saved by the user, they can validate the entered data.

Once the user has validated his data, lifecycles, created by an insurance product

called ‘AMARTA’, will be started immediately from the Unix server.

After couple of automatic tasks , the user can once again enter the same app entry [now with a Different set of tables] and make corrections or additions to his entry. There are around 200-250 Business backend business rules that check the entry at the automatic task level. If there is any error, errors are captured and displayed once the user comes back to the entry point.

In all there are around 12 automatic tasks and 10 manual tasks. 5 different forms were

created for the manual tasks.

Helped creating backend business rules and scheduler reports.

• For Global Lead Tracking Team, Oracle Corporation, San Francisco:

Created functional and technical methods using CDM and AIM techniques for the team of developers And designers. Created and modified three forms in Forms 3.0.

The existing system, which was used for the marketing and sales purpose, had to be modified Due to unformatted loop. Created different canvases for relocation of nodes, which included both parent and child entries.

Responsibilities include system architecture and data modeling, managing the product development team. System also included Discoverer 3.1, Designer 2 and Express Server 6.2.

Employer: RPM Systems

Duration: May 1996 – August 1997

Role: Technical Manager

Projects:

For Guarantee Life Insurance Co, Omaha.

Maintained day-to-day DBA activities.

Developed Life Insurance - RGO System [Custom Development]. This application processed insurance true products like dental, ltd, life, wi and voluntary products for life, dental, ltd and wi. Created 15,000 lines of code in stored procedures, packages and database triggers for a present system of insurance coverage. Created and converted 150 forms under Forms 4.5.7 and also created 45 reports under Reports 2.5.5, which will launch the entire RGO system under Windows. The regional offices (Houston, Kansas and Dallas) were connected to the head office using the direct connect and frame relay, and successfully implemented the application, which resided in the 3-tier setup of the server (of the head office) available.

Created 14 Proposal reports, which are called from the forms depending on the coverage and ratings the user selected. These reports can be proposed or re-proposed by Underwriters or brokers. The system will allow only the underwriter to edit the proposed reports and the other users can just view the reports. The system allows the user to print, fax, e-mail and save as a web [.htm or .pdf format].

For John Deere, Iowa.

Maintained day-to-day DBA activities.

Converted from SQL*Forms 3.0 to Forms 4.5 and created 90 Forms and 8 reports for the John Deere Production floor department. As part of the conversion, I created 4000 lines of Procedures for a maintenance code, which runs on a daily basis. This application was successfully implemented for Windows95, Sun Solaris 2.5 and Mac System Operating systems.

For Expansion Systems, LA.

Maintained day-to-day DBA activities.

Implemented an Internet Order Entry Service System. This system was designed for IDT, US and Videotron, Canada, which provide internet services. This system takes orders from customers in the order entry, which includes all the information including credit card number. The credit card information is then sent to the bank for authorization through a daemon. The Customer Service interface module also accesses a customer's information through customer service, which had access level controls, billing, tax exemption, resources, subscriber credit, email resources, account notes, provisions for canceling, suspending and reinstating of an account. Created templates for the entire system, 11 forms and 7 reports using Developer/2000, Designer/2000 and Reports 2.5.

Employer: Celltech Systems

Duration: August 1995 – May 1996

Role: Sr. Consultant

Projects:

Celltech Systems

Maintained day-to-day DBA activities.

Developed a Training System for banks to train their employees for various customized courses. System consisted of 24 forms and 8 reports. This system helps the user to customize employee training information, report their need using different select criteria and parameters. This system also helps the user to select and print confidential reports (single or batch) based on their security permission they have.

Implementation of inventory, order entry, purchasing, GL, AR and custom modules. Designed and custom developed modules in the Cellular Billing System. This fully integrated package has features like Customer Registration, rating/billing of customer calls, customer payments, allocation of various features/facilities to customers, leasing of equipment's to customers etc. This is developed using GUI standards. It has interfaces to the Oracle Inventory, Purchasing, General Ledger and Accounts Payable modules. Was also in-charge of designing and developing the prototype for the Master maintenance module screens along with involvement in Quality assurance and documentation of standards. Designed and developed 42 forms and 14 reports, which also included the invoice processing, purchasing, accounts payments, customers payments, installment records, mode of payments, customer preferences and calling plan details. This system was originally written for Unix users. Since the product was a very big success, the entire product was converted to Mac, Windows and OS/2 environments.

Employer: Krea Technology

Duration: Dec 1989 – August 1995

Role: DBA

Projects:

Maintained day-to-day DBA activities.

Was a DBA in development of a Banking System. This system was basically developed for banks-loan department and credit card services. The system also had on-line daemon process services and loan status. This system also had registration of the loans through the process. The System was developed to monitor the activities like receiving and processing of loan applications, monthly/bimonthly recovery of loans, generation of various reports and documenting all the activities and tracking the process.

Designed and developed a payroll system for major government institutions which takes care of all payroll information including tax, paid vacation, holidays, advances etc. This system was successfully implemented for 3 major state government departments in India.

Designed and developed a Shipping System, which covers a line of activities like registrations, details, taxation, transportation, invoicing and other related activities like payment procedures, reminders etc. This system covers Order Entry, Issue of work orders, Generation of Pre & Post Shipment Documents, payments, post - export documentation etc.

Contact this candidate