Resume 3

Technical Summary:

• 10 years experience in developing full life cycle systems.
• 9 years experience as a DBA/developer/Data warehousing
• 5 years experience in developing web applications.
• 3 years experience in a Lead Technical Role.
• Over 9 Years both in Oracle and UNIX Development Experience

These include Billing and Rating, Manufacturing, Financial and Project Accounting Systems. Application software expertise includes strong programming skills using Oracle, PL/SQL, Oracle Forms, Oracle Reports, Oracle Web Server, Pro*C, Data Warehouse, SYBASE, T-SQL, C, C++, Java, JavaScript, ASP. Developed numerous UNIX shell scripts to automate backup and recovery of ORACLE and SYBASE databases. Strong report writing skills using SQR and ORACLE Reports. Developed a Reporting module, which involved creating 165 major business reports. Performed extensive Oracle and Sybase Database Administration. Thorough understanding of Project Accounting and financial applications.

Technical Skills:

• Client/Server: Oracle 7.3, Oracle 8i, Oracle 9iAS, PL/SQL, webdb, SQLPlus, Pro*C, Developer 2000, Designer 6i, Designer 2000, Oracle Forms/Reports 6/6i , SYBASE, T-SQL, APT-SQL, VB 5.0, SQR, FRX, SQL*Loader

• Web Development: Oracle Web Server, Java, JavaScript, HTML, ASP, Visual Interdev, CGI, Perl, and WebSQL

• Programming Languages: C, C++, Unix, Java, Perl, RS/6000, HP9000, DOS, Windows 3.1, Windows 95, and Windows NT

Technical Experience:

Responsibilities:

• Used Oracle Designer 6i to perform data modeling.
• Documented Tech Specs for the proposed data base design.
• Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.
• Performed the set up the VSS source code architecture for the client.
• Performed code reviews.
• Used SQL Navigator to reverse engineer the model of the legacy applications.
• Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.

Tools/Environment: Sun Solaris, Oracle 8i, 8.0, 7.3 , Oracle Enterprise Manager, Developer 2000, Actuate, SQL, PL/SQL, CGI & Perl

Data Modeling

• Performed extensive data modeling using Designer 6i for the data warehousing application.
• Primary tasks accomplished using Designer 6i include:
• Modeling the business requirements
• Diagrammatic representation of business processes
• Define and represent entities, functions and flows between the entities
• Using the transformers to generate initial designs
• Re-visit the proposed/implemented designs to improvise/change existing business requirements.

Data Warehousing

• Designed the data warehouse application. Responsibilities included collecting user requirements, performing feasibility analysis, proposing functional and technical specifications, developing code per the specifications, distributing tasks among team members, doing code reviews, facilitate source code control.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Developed test plan, test cases and test scripts to thoroughly test the data warehousing application.
• Developed Actuate Reports and Oracle Reports to fulfill the reporting needs of the users.
• Developed webdb codes to web enable reports.
• Used XML to display the reports/forms.
• Developed several front-end screens using Forms 6i. Used OLE objects to facilitate the uploading/downloading of spreadsheets/datafiles between forms/reports and the network drives on users PCs.

Database development

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers.
• Enforced database integrity using primary keys and foreign keys.
• Created PL/SQL functions to facilitate business functions and calculations
• Used Informatica s power mart to link different data sources.

Database Administration

• Installed and configured oracle 7.3 and oracle 8i.
• Configured tnsnames and Sqlnet files
• Created instances, schemas, users, profiles and roles.
• Managed users, privileges and roles

Completely designed and developed the Oracle 8 based database application for Sun Microsystems. This database serves as a storehouse of information for Sun Microsystems for their financial and accounting information. This database is primarily used by the accounting departments of Sun to make journal entries, keep track of account payables and receivables, and make journal postings to the General ledger.

The database consists of about 1000 base tables and several views, Procedures, packages, triggers. Coded several stored procedures, triggers and packages to incorporate the business logic into the application. Used Oracle DBMS packages to carry out dynamic SQL processing. Developed generic Oracle functions for business computations. Performed query analysis and enhanced Query performance by taking advantage of Oracle s indexing features and table partitioning features. Developed SQL Loader scripts to load flat files into Oracle database. Scheduled Cron jobs to perform automatic extraction of the data. Developed Oracle reports using Reports 2.5.

Responsibilities also included:

• Formulating
• Writing scripts to create tables and views
• Developing PL/SQL procedures, packages, triggers, functions
• Developing Kshell UNIX scripts to import, export operations
• Monitoring the query performance using explain plans
• Developing Oracle reports

Tools/Environment:
Oracle 8.0 was used as the backend for this system. Used constraints as well as triggers to enforce the referential integrity. The front end screens were developed in. Developed Java application to enhance the capabilities of the system. Front-end validations were handled by JavaScript while the server side validations were carried out using VBScript.

Involved in the design and development of the new Service order entry module of AT&T local services. This module serves as a tool for AT&T local services to create and manage the service plans of the customers. This system can be used to view existing service plans, accept new customer orders, and modify service plans. The backend database used for this application is Oracle 8.0. Developed several PL/SQL stored procedures to carry out the backend processing.

Performed table layout analysis and design with emphasis on referential integrity. Developed scripts to create the tables in Oracle. Developed PL/SQL routines to extract data from VMS database and load it into the Oracle database.

Performed performance tuning of the overall system by eliminating redundant joins, creating indexes, removing redundant code. Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases. Monitored user profiles, roles and privileges for the Sybase database.

This web enabled part of the billing and rating module enables the customers as well as AT&T employees to view the previous bills, run reports, check account balances etc. Used JDK1.2 to develop the applications. JavaScript was used to perform the client side validations.

This utility was developed completely in Perl and C. The raw data is captured from existing AT&T billing files and then the date fields were aged.

Application Development

Developed a new FINANCIALS module for Yokogawa Industrial Automation, Inc. This entire system was developed in ORACLE 7.3. Coded several stored procedures, functions and triggers to process the financial transactions. Developed screens for the end users to access these processes. These screens were developed using Forms 4.5. Also provided Internet and intranet access for the users to access these screens. Performed web programming using Oracle Web Server to make these forms web compatible. Used SQL*Loader to load flat files into the database. Developed UNIX scripts to automate some of the batch processes. Developed several reports in SQR and ORACLE Reports. Some of these reports include Financial Account Activity, Trial Balance, and Audit Trail Activity etc. Developed UNIX cron jobs to run these reports on a nightly basis. This financials module comprised of the Accounts Payable, Accounts Receivable and General Ledger sub Modules. Some of the main transactions include:

• Creating and approving AR invoices
• Creating and approving AP invoices
• Posting invoices to sub ledger
• Consolidating sub ledger entries and posting to General Ledger
• Payment of checks

Reports Module

Developed several reports about 165 to be precise using SQR and also Oracle Reports. These reports provide the user detailed as well as summarized information of different transactions belonging to different Modules. These reports include daily downloads, normal hard copy print outs, as well as user initiated dynamic web reports.

Developed a new Web Based reporting system that interfaces with Oracle 8.0 server. This developed reporting system uses SQR to interact with Oracle 8.0 server. The retrieved results are then formatted into a web compatible screen. The entire web development for this reporting system was carried out on Oracle s web server. Several Perl, CGI, JavaScript scripts had to develop to achieve this.

Inventory Management Module

The objective of developed module is to enable the Organization to manage its inventories on both quantitative and qualitative levels. The Inventory Management process supports the Inventory Production and the Order Entry processes by providing critical information on the current levels of finished goods.

• Data Modeling
• Database Design
• Tables Layout Design
• User Requirement Study
• Designing User Interface
• Coding PL/SQL Procedures, Functions, Triggers

Developing Screens

The entire system was developed using Oracle 7.3, Developer 2000, and Forms 4.5, Oracle Reports on UNIX platform. Some of the tasks accomplished by this module include ability to create inventory part definitions and stocking locations, ability to retrieve availability information, perform inventory movements, and setup replenishment Processes etc.

Developed scripts using Perl 5.0 to automate the interfacing between different platforms. These scripts run the nightly batch processes required to carry out the routine posting of the financial transactions. Also these scripts make use of the extensive formatting capabilities provided by Perl to import and export the daily downloads.

UNIX Scripts - Worked extensively on the UNIX platform. Developed several UNIX scripts mainly in K shell. These scripts were developed to Perform several different tasks.

Developed UNIX scripts that automate the process of the posting the Inventory transactions to the General Ledger Developed UNIX script that prints the financial reports automatically on a daily, weekly and also monthly basis. Developed several scripts that facilitate the source code control for Oracles procedures. These scripts perform version control as well as source code control

Data Warehouse Design

This application serves as a storehouse of information for the client. The system was developed using Oracle Web Application Server 3.0, Oracle 7.3, Forms 4.5, Oracle Reports, Oracle Graphics, and OLE Embedded Objects. Developed about 30 PL/SQL stored procedures and functions to process the data based upon the user requests. Developed Pro*C and UNIX routines to load the data into the warehouse on a nightly basis. Used PL/SQL cursors to process the rows one at a time. Used SQL*Loader to load data in flat files into tables.

Responsibilities included requirements gathering and analysis, rapid Application development, development of a decision support framework Subject area modeling driving toward measure/dimensional modeling , and source system/data store analysis. Also responsible for the development of audit procedures and process for the loading of the Data Warehouse.

Developed an application serves a tool for Vendors in maintaining their U.P.C. catalog Developed web based on-line Vendor Catalog Maintenance for Vendors. This information. The Vendor would be able to load/modify U.P.Cs in the catalog.

This application also provides vendors with an ability to maintain access to retailers and also maintain their account information. This application was aimed towards major Vendors such as Sears, Dillards etc., a Sybase Product, as the database interface to interface with DB2 and Sybase Servers. The developed WebSQL HTML files execute a large number of Perl scripts. These Perl scripts were developed essentially to access and format the data that has been retrieved from the server using WebSQL. This application, due to the complexity involved, uses a large number of front-end validations. All the front-end Form processing/validations were carried out using JavaScript.

Performed intensive testing of various functionalities of Sybase SQL Server 11.

Responsibilities Included: Formulating assertions These are normally based upon the documentation provided by Sybase to its customers. The test developers would then develop code to test these assertions.

These developed strategies would then be used by test developers to develop the test code.

• Developed numerous scripts to test different functional aspects of SQL
• Server using the formulated assertions and underlying strategy pertaining to the assertion.

These test scripts were developed using Tcl Tool Command Language in conjunction with a testing environment called QuaSR Quality System Reengineering developed internally at Sybase.

These self-analyzing tests intelligence and analysis provided in the test scripts itself also ensure easy readability, easy maintenance and provide enough diagnostic information in case of test failure. Reporting bugs in case of any test failures encountered using a standard Bug Tracking System.

UNIX Experience: As part of the job duties at Sybase Inc., developed several UNIX scripts. These scripts were essentially developed to perform source code control of the code.

Designed and developed an On-Line Purchase Parts Maintenance system for the accounting department of B&W. This system serves as a tool for the management to track the purchase requirements for different departments, track quotations, generate batch reports of comparative statements, invoice discrepancies, purchase orders and scheduling payments. The developed system was also linked to the inventory management and financial accounting departments. This system was developed using SYBASE on UNIX with APT-SQL as the front-end. Coded routines using SQR to generate the batch reports for this system. Extensively involved in the CIIM 9.0 Foundation Project. The main aim of this project was to optimize the performance of the system to make the process more efficient and effective. Apart from process efficiency, emphasis was on standardizing the code to improve readability, consistency, ease of future modifications and current state of technology.

Responsibilities included rewriting major portion of the code for the accounts payable and purchasing modules and also enhancing the front-ends. The entire coding was done in SYBASE, T-SQL and SQR.

Involved in the design, development and implementation of General Ledger and Accounts Payable Modules of Sybase based Avalon 9.0 product. The Avalon product has about 1000 tables and more than 5000 routines to support the system. Responsibilities included:

• User requirement study System analysis and design
• Application development Testing and implementation
• Optimization and performance improvement of existing database design

Assisted with the analysis, programming and implementation of a Sybase/T-SQL based Order Processing System for a local bicycle manufacturing company. Technical accomplishments include the design and integration of the Order Scheduling and Purchase Accounting systems Assisted with the analysis and programming of a SYBASE/Power Builder based Library Management System. Responsibilities included rewriting and upgrading the already existing APT front-end screens with Power Builder screens

As a Software Consultant for a Industrial Waste Management firm, was Involved in the following: Computerization of various engineering projects involving engineering feasibility analysis, life cycle modeling, coding, debugging and technical support. Applications development using SYBASE, ORACLE, PRO*C. Also provided hardware and system support for the data center.

Education: