Main page

8. Oracle Developer

• Over five years of professional programming experience with ORACLE under multiple platforms and environments
• RDBMS: Oracle Server 8, Oracle Server 7, PostgreSQL
• Web servers & tools: Oracle Application Server 4.7, Oracle WEBDB 2.1
• Development environments: Oracle Developer 6.0, Oracle Designer 6.0, Borland Delphi 4.0, Logic Works ERWIN, SQL Navigator
• Programming languages: SQL, PL/SQL, C, Pascal, HTML, PHP
• Operating System: Unix (Sun Solaris 2.6, HP UX, SINIX), Windows NT 4.0, Windows 95/98

EXPERIENCE

• ER modeling, design of application modules.
• Developed and created modules and reports using Developer/2000 for HR modules.
• Development of user-defined functions and procedures.
• Optimizing SQL-code and tuning the modules.
  Development Environment: Oracle Server 7, OracleDeveloper 6.0

• Over 6 years of experience in information systems, including analysis, data modeling, design, database development, DBA activities.
• Experience and Expertise in OAS and ODS technologies
• Experienced with client/server, host based systems and e-commerce application development with industry experiene in Mutual Fund, Investments, Finance, Banking, Accounting, Manufacturing, & Sales and Marketing
• Fluency in C, C++, and FORTE programming
• Experience and knowledge with OOP's and has applied these techniques in several client project
• Experience and knowledge with Visual J++ (COM Development)
• Experienceand knowledge with Active Server Pages
• Experience and knowledge with COLD FUSION
• Experience and knowledge of full Oracle product set (8,7,6), including SQL Forms 3, 4.x and 5.x, SQL Plus, SQL
• Report, SQL
• Menu, SQL
• ReportWriter, PL/SQL.
• Experience and knowledge of Sybase IV, X, XI
• Knowledge of SQL Server 6.5
• Strong clien/server developer, with solid experience in both back-end and front end design and development
• Strong technical abilities, together with sound analytic, problem solving and design skills.
• Strong Unix background, coupled with solid expertise using C
• Extensive user training experience in individual and classroom settings
• Familiar with client/server architectures and networking environments including TCP/IP, Unix and Windows NT
• Ability to work within, and comfortable with, time and budget constraints of project production cycles
• Sun Certified Java Programmer (JDK 2.0)
• Oracle Certified Application Developer (Release 2.0) Microsoft Certified for SQL Server 6.5, Windows 95

Technical Summary

ORACLE

• ORACLE 8i, 7, 6
• DEVELOPER 2000
• PL/SQL
• SQL*FORMS
• SQL*REPORTWRITER
• SQL*PLUS
• SQL*LOADER
• SQL*MENU
• SQL*NET
• DEVELOPER 6.0

GUI FRONT END DEVELOPMENT TOOLS

• FORTE
• C++
• VISUAL BASIC
• VISUAL C++ WITH MFC
• POWER BUILDER
• VISUAL J++ (COM Development)
• COLD FUSION

OPERATING SYSTEMS

• UNIX
• SUN SOLARIS
• NOVELL NetWare
• Windows NT
• Windows 9x
• MS-VISUAL INTERDEV
• ORACLE APPLICATION SERVER

INTERNET

• JAVA, JavaScript
• HTML
• MS-IIS 4.0
• Netscape Enterprise Server 3.5.1
• ASP

DATABASE

• ORACLE
• MS-SQL SERVER
• SYBASE

REPORTS/GRAPHICS

• SQL*PLUS
• CRYSTAL REPORTS
• DEVELOPER 2000 REPORTS
• HARDWARE
• HP
• SUN
• IBM
• PC'S
• TANDEM

OBJECT ORIENTED EXPERIENCE

• OO ANALYSIS
• OO DESIGN
• OO PROGRAMMING

LANGUAGES/Other

• 3GL C EXPRESS 'O' BUILDER
• C++ dBASE, FOXPRO
• FOCUS
• CLIPPER
• MS-OFFICE
• EXPERT SYSTEMS
• WORD-PERFECT

SKILL SET: Oracle, Erwin 3.5, Sybase, Java, FORTE, C++, Developer 2000, Oracle Developer 6.0, Oracle Application Server 4.0.8.1, COLD FUSION, Unix Shell Programming, Win NT. Project Details

Project 1 - Web-based Enterprise Management Solutions
Client - *Название компании*, MA (Sep '00 - Till Date)
Sr. E-Commerce/Oracle Consultant

In 1998 *Название компании* was established to pioneer the transformation of research management practices around the world. Through their internal domain expertise and strategic alliances with leaders in industry, technology, science, and government, the Company has emerged as the primary source of knowledge management solutions for the 21st Century research community. Enterprise-wide deployment of solution sets provides the following benefits:

• Reduced Development Lead Times and Expense
• Dynamic Real Time Activity Monitoring and Management
• Standardization of Data Input, Review, and Distribution
• Increased Development Velocity, Capacity, and Integrity
• Maximized Outcomes Success

Rajnish's responsibilities included:

• Understanding, analyzing and defining the client requirements.
• Assisting senior team members in data modeling and e-commerce application deployment.
• Defining the scope and project plan for application analysis, development, implementation and testing process.
• Defining requirements and prototypes for COM objects to be written for different modules.
• Oracle 8i Integration with COM and ASP.
• Developing backend database objects in Oracle 8i.
• Familiar with source management of Clear Case 2.5.

Project 2 - Thin Client Project
Client - *Название компании*, Canada (Feb '2000 - Sep '2000)
(Adminsource London (UK))
Team Leader

The client *Название компании* is one of Canada's oldest and most broadly diversified wealth management companies, with assets under management in excess of $15 billion on behalf of over 700,000 Canadians. With portfolio management teams headquartered in Toronto, Dublin, and Singapore, expertise spans the globe with investment advisors strategically located in key foreign mrkets - each renowned for their specialized skill and distinctive management style. *Название компании* bought a software company in UK called Adminsource and the project was to provide Oracle Internet Solution to Adminsource. The project involves migrating a typical Oracle based client/server environment to Web based environment using Oracle Web Technologies. The existing application is to be migrated using OAS 4.0.8.0, and Oracle Developer 6.0. Rajnish's responsibilities included:

Environment Sun Solaris, Erwin 3.5, Oracle 8.0, OAS 4.0.8.1, ODS, Developer 6.0, MS-Word, MS-Project., Clear Case 2.5.

Project 3 - *Название компании*-*Название компании* Intranet Project
Client - *Название компании*, Canada (Jan '2000 - Feb '2000)
Sr. Developer/Application Analyst

The client *Название компании* is one of Canada's oldest and most broadly diversified wealth management companies, with assets under management in excess of $15 billion on behalf of over 700,000 Canadians. With portfolio management teams headquartered in Toronto, Dublin, and Singapore, expertise spans the globe with investment advisors strategically located in key foreign markets - each renowned fr their specialized skill and distinctive management style. The new web project was to be developed on the basis of the existing *Название компании* web site, but it was suppose to be more customized with new approach and with some new functionality for the use of *Название компании* Bank only. The new web site area was to be restricted for only to be used by *Название компании* employees. Rajnish's responsibilities included:

Environment Sun Solaris, Oracle 7.3, CFML, Cold Fusion Application Server 4.0, Homesite, JavaScript, HTML, and MS-Word, Clear Case 2.5.

Project 4 - Security Management System (S.M.S)
Client - *Название компании* (Oct'98 - Oct'99)
Sr. Developer/Application Analyst

The client *Название компании* is a leading financial institution, employing 4,300 individuals located in 140 offices across Canada, in the U.S., as well as in 10 international locations. The firm is recognized as a leader in the areas of personal finance, economic and equity research, investment banking, institutional equity and capital markets. The project Securities Management System (S.M.S.) is a business-critical brokerage application that automates the firm's trade settlements and secrities processing. The major features / components of the Securities Management System include:

Rajnish's responsibilities included:

Environment Sun Solaris, FORTE, Oracle, Win NT, Express'O' Builder

Project 5 -Training Institute Automation
Client - *Название компании*. (1997 -1998), Delhi India.
Developer/Application Analyst

*Название компании* is a multinational company involved in high-end software training courses for software professionals. The new project was suppose to computerize the following modules:

Rajnish's responsibilities included:

Environment: Oracle 7.1, Developer 2000 (1.5), Unix, Win NT, Win 95, Ms-Office

Project 6 - Manufacturing and Distribution Process Management System
Client - *Название компании* (1996 -1997), Delhi India.
Developer/Application Analyst

*Название компании* is a nationwide manufacturer and distributor of all kind of wire products. The new project was suppose to computerize the following modules:

Raw Item Tracking Including :

• Purchase :
• Purchase Return :
• Manufacturing :
• Cost Analysis :
• Manufacturing Plan

Final Item Tracking Including :

• Production Planning and Control :
• Scrap Hndling : Sales Decision :
• Distribution

Accounts Handling For Clients And Suppliers Rajnish's responsibilities included:

Environment: Unix, Oracle 7.1, C, Reports 2.5

Project 7 - Courier Process Automation System
Client - *Название компании* (1995 -1996), Delhi India.
Contract Programmer/Analyst

*Название компании* is a nationwide courier delivering company based In Delhi India. The new project was suppose to computerize the following modules:

Environment: Unix, Sybase IV, APT Workbench

Project 8 - Inventory and Accounting Management System
Client - *Название компании*(1994 -1995), Delhi India.
Contract Programmer

*Название компании* is involved in trading and distribution of electronic products. The project was suppose to computerize the following modules:

Rajnish's responsibilities included:

• Developing PL/SQL packages for server side processing
• Creating and maintaining database objects.
• Developing Forms and Reports using Developer 2000 (1.5)
• Developing PL/SQL objects for client side validation

Environment: Unix, Oracle 7.0, and Developer 2000

OBJECTIVE

Oracle Applications Developer & Administrator with US college degree and solid background in various programming languages and platforms, pursuing a career with a U.S. software company. Very proficient with Oracle Developer/2000, SQL and PL/SQL, Oracle 8, installing and administering Oracle Financials 11.0 (GL, AP, AR, CE, FA). Work philosophy includes integrity, discipline, quality, hard work positive attitude, team involvement and leadership.

TARGET JOB

• Desired Job Type: Employee,
• Contractor Salary: Prevailing market wages
• Site Location: No preference
• Description of My Ideal Job: Part of a dynamic team, developing new software solutions using cutting-edge technologies.
• Date of Availability: Two weeks
• Company Size: No preference
• Company Category: Computers Software
• Description of My Ideal Company: Technology-oriented company that is committed to taking advantage of new technologies to serve their customers and employees. Must be willing to offer U.S. work permit sponsorship.

TARGET LOCATIONS

• Preferred Location: U.S. - any state
• Willing to Relocate: Yes

WORK EXPERIENCE

2/2000 - *Название компании*, Romania
Oracle Applications Developer & Administrator

• Leader of the technical team who successfully completed the implementatin of the Oracle Applications 11.0 Financials package (GL, AP, AR, CE) at the largest privately owned Romanian Oil Company.
• Develop in-house customizations (reports and forms) of the Oracle Applications 11.0 Financials package (using Oracle Developer/2000).
• Create procedures and triggers for data manipulation & data import programs.
• Administer Oracle Applications and Oracle8 Database (management, optimization, backup, updates, troubleshooting, etc)
• several instances.
• Install and maintain Bilingual Oracle Financials installation, Multi-Org and Multiple Reporting Currencies.
• Perform troubleshooting and problem resolution involved in installing Oracle Applications patches and upgrades.
• Integrate Oracle Applications with other products (existing ERP software modules, Oracle Financial Analyzer, Human Resources Management Systems, Track-It!, cost control systems).

1/2000 - 2/2000 *Название компании*, Romania
Software Solutions Consultant

• Industry solutions analysis for network-connected systems: analyze specific printing industry needs; analyze software products (both Romanian and international) and create/propose customized solutions to include Xerox printers and Xerox or third-party software.
• Consulting role for all contracts that involved mid-range to high-speed/high-volume network-connected printers.
• Technical support role for all sales and marketing agents.
• Create customized software solutions for high-speed/high-volume printing machines used by major telecommunications companies.

10/1999 - 1/2000 *Название компании*, Romania
Assistant Information Systems Manager

• Network configuration and maintenance in Novell, SCO UNIX and Windows NT systems.
• Maintenance and assistance at the server and user level in all Microsoft Windows 95 & 98 programs (MS Office, cc:Mail, etc.) and hotel-specific applications (i.e. Fidelio, Micros, OnCommand).
• Personal project under development: design and creation of a Cost Control program for the hotel (programming language: Visual Basic 6.0 and Microsoft Access 2000).

EDUCATION

12/2000 Prometric Bucharest, Romania
Application Developer OCP - Certification
Pursuing certification, passing first two tests taken. Estimating successful OCP completion by end of March 2001.

2/2000 - 4/2000 Oracle Romania Bucharest, Romania
Instructor-Led Oracle Certification Courses for Developer v6/6i
(SQL, PL/SQL, Forms, Reports); Oracle Financials Courses (GL, AP, AR); Oracle Express Courses.

9/1998 - 7/1999 U.S. Air Force Laughlin AFB, TX, US
Military Pilot License
Completed military flying school with outstanding results (one of the three Romanian pilots to ever graduate a U.S. military flying school).

6/1994 - 5/1998 U.S. Air Force Academy Colorado Springs, CO, US
Bachelor of Science in Computer Science
Major in Computer Science. Minor in Mathematics. Overall GPA of 3.06 (graduated on Dean's and Commandant's Honor List). Held several leadership positions, including Squadron Operations Officer and Flight Commander. First Romanian to ever graduate from this honorable institution.

OTHER PROJECTS

1/1997 - 4/1998 U.S. Air Force Academy Colorado Springs, CO, US

The design and implementation of a large Oracle database and all related applications at US Air Force Academy. Part of the implementation team consisting of 30 computer scientists. All work was done in Oracle 8 (Designer/2000, Developer/2000, SQL) on Windows95 and Unix platforms.

WORK STATUS U.S.A.

I require sponsorship to work in this country.

SKILLS

ADDITIONAL INFORMATION

Excellent English language skills (both oral and written).
Perfectly adapted to the American way of life (5 years in the U.S.).
Additional references available upon request.

Summary

• Over Six years have been working on the database design, development, testing, integration and implementation of custom solutions using various database software and tools, including ORACLE APPLICATIONS Release 11.x/10.7 NCA Multi-Org/10.6.x, ORACLE 8i/8.0/7.x/6, Developer/2000 (Forms, Reports, Graphics), Designer/2000 , FSG reports and Pro*C, PL/SQL. Since last four years involved in the implementation project of Oracle Application.
• Experiencein customizing the, Oracle Payables, Oracle Receivables, Project Accounting, Order Entry and General Ledger , Purchasing, Oracle Inventory modules and AOL, and Oracle development tools.
• Experience in analyzing the business requirements, Fit -Gap analysis, Data Mapping with the user community and developing the Open Interfaces.
• Designed and developed In bound and out bound Interfaces for Oracle Applications.
• Exerience in conversion of data into Oracle Applications.
• Experience in Supporting the Production Systems in Oracle Financials and Manufacturing modules.

Technical Skills

• Hardware: HP-UX server, IBM compatible PC, IBM RS/6000 Sun Sparc Station, WindowsNT
• Software: Oracle Applications 10.7 multi org GUI and Character Version (AP, AR, GL ,PA and OE), Applications Object Library (AOL) & Alerts, Oracle Forms 4.5, Oracle Reports 2.5, SQL Plus 3.x, PL/SQL 2.x, C, Shell Scripts, SQL Loader, Crystal Reports, Discoverer 2000,Toad, SQL Navigator, Chain Link, Smart dB workbench and HTML,Training Done on JAVA recently.
• Database: ORACLE 8i/8.0/7.x/6, MS Access 2.0
• Operating system: Windows 3.1, Windows95, WindowsNT, Unix SVR4, Novell Netware 4.10
• Education: Bachelor of Engineering

Professional Experience

*Название компании*═SystemAnalyst═May▓2000 -Till Present

Involved as active team member of *Название компании* with SPN project development led by Earnest &Young LLP in USA. This implementation for the project══is the implementation of Oracle Applications integration of the entire SAP Module lucent acquisitions world wide with Oracle Applications.
═
Responsibilities included Involved in the complete life cycle of Customer Conversion design to implementation and, development and integration of custom applications with Oracle Applications. User interaction provided guidance to the team members in all the related areas. Designed and developed interfaces for integration with
other database.

Written invoice collection Process, IBUY, EDI and various printing programs for invoice presentation according business requirements of *Название компании*.

*Название компании*. System Analyst Aug▒ 98 to Apr▓2000

Involved in customization of Accounts Payable module, which included drafting implementation strategy after preliminary understanding of the organization▓s information needs, ascertaining the invoice processing cycle and integrating Legacy system into Oracle Payables with the intention of phasing out the legacy data feed in future. I was also involved in custom module Compensation Detail developed an interface between Mckinsey▓s Payroll Systems and Oracle Financials system globally. I was also the member of the Coexistence team involved in the design and development of the Coexistence model for stream lining all the concurrent processes across all the modules including General Ledger, Accounts Payable, Oracle Receivable and Project Accounting for closing the transaction at the month end.

Integrating legacy system data feed with Oracle Payables involved in data analysis, creating data mapping diagrams for forward and backward tracking of data and identifying the parameters needed for mapping with Oracle Payables interface tables. Created PL/SQL scripts to upload Invoice data from various sources into Oracle Payables. Created Generic Validation routines in PL/SQL to validate data from different feeds before transferring to Payables interface tables. The Generic Validation routines were developed so that the same routines could be used for different Payable installations.═ Registered all the PL/SQL scripts as Concurrent Programs to enable users to schedule and run programs from Standard Report Submission. Designed, developed and integrated Forms and Reports into Oracle Payables module using Oracle Forms 4.5, Reports 2.5 and Application Object Library. Reports were developed to capture exceptions and Forms were developed to facilitate on-line validation and correction of invoice data. Enabled Descriptive Flexfield Segments to transfer additional invoice specific information to Oracle Payables.═ Setup Report Sets to initiated the Payable Invoice Import process and AutoApprovals, Build and Format Payments process from Standard Report Submission. Developed a PL/SQL script to reconcile Oracle Payables data with Legacy System data and transfer back payment and posting details for each paid invoice. Set up new Vendors, Payable and Vendor Quickcodes, Payment Terms, Currencies, Rates, Payment Program, various Format Programs and Bank Accounts .

Involved in production support for Accounts Payable, responsibilities included job scheduling, data uploading, payment processing, check printing and invoice posting. Data upload involved creating Shell scripts to FTP files from one server to another and invoke SQL Loader to load data═ into Oracle tables. Created new Responsibilities for users having specific access requirements associated with their job titles.

Involved in integrating Accounts Receivable System from a legacy system to Oracle Receivable through Oracle Invoice Import Open Interface and Oracle Customer Master Open Interface. Created Shell Scripts, PL/SQL scripts to upload data from Mainframe Flat file into Oracle Receivable Interface tables. Also involved in developing a process to interface Oracle Receivable to Citibank Netting System. Created PL/SQL scripts to transmit Invoice information and receive Payment information to and from Citibank, process positive and negative transactions through LockBox. Developed Open Item custom reports using Reports 2.5 which shows negative invoice amounts, adjustments, and partial payments. Developed test cases to test an Oracle Receivable Patch for Foreign Currencies rounding bug at Invoice Import. Created various test data and processed through the Receivable cycle up to General Ledger analyzing and checking data integrity at the table level. Involved in supporting the Receivable module for Accounts Receivable Department, which included job scheduling, data uploading, processing Receipts through bank, posting Invoices and Receipts to General Ledger and reconciling the amount.

I was also the member of the Coexistence team involved in the Design and Development of the Coexistence model. This Model consists of two modules namely Inbound Coexistence and Outbound Coexistence. Inbound coexistence is used to convert the data entered in the legacy systems (IBM Mainframes) into the Oracle Financials Applications. Outbound coexistence is used to extract the data from Oracle Financials and send it to the Legacy Systems for reconciliation. As a technical analyst involved in the development of various programs in the areas of Project Accounting, Accounts Receivables, Accounts Payables and General Ledger, that are being used in the implementation of the coexistence model. Also actively involved in Stream line all the processes automating the routine jobs like submitting the monthly reports and running the concurrent programs and extensively worked with the open interfaces which are used to import the legacy data.

Involved in exhaustive testing, trouble shooting and debugging for database packages, functions, procedures, triggers etc

Involved, as a part of a team, in setting up of General Ledger module which consists of creating Accounting FlexField structure and segments, Chart of Accounts using Account Hierarchy Editor, Cross-Validation Rules for dynamic inserts, Security Rules for restricting access to segment values, setting up Accounting Calendar and Currency, defined Shorthand Alias, Set of Books, Familiarity on FSG reports and Master/Detail Budgets. Defined Currency, Currency rate and Daily currency rate to facilitate the processing of accounting transactions in foreign currency. Created manual journal batch for transactions in Canadian dollars, run and posted revaluation journal, reconciled revaluation journal using the foreign currency General Ledger Report. Created Recurring Journals for transactions that occur every accounting period.

I was also involved in custom module Compensation Detail Developed═ an interface between Mckinsey▓s Payroll Systems and Oracle Financials system globally. Provides online access to compensation-related information for 120 offices worldwide. Transfers compensation-related information to and from AP, GL, LAAS (loans and advances) and PSRP systems. Developed reports and forms and implemented security system to view confidential information like salary by offices and the management level.Developped gl reconsilation screen with compensation detail which will run through Cron process every month .═ I was also involved in user support and enhancements and bug fixing.

*Название компании* Senior Developer/Analyst. May▓ 98 to Jul▓98

Responsibilities:
Assessing the initial requirements, conducting feasibility study and preparing specifications, Analyze, design and documentation of the Insertion process for Standard and Blanket Purchase order into Oracle Purchasing Module using Smart*DB workbench tool.═ Conversion also involved of loading Vendors from the legacy that will be shared within Oracle Payables and Purchasing Modules also converted the projects and expenditures from legacy into Project Accounting using the AIM methodology. Testing and fine-tuning the system. Loaded Vendor and employee information from the legacy system that is shared in all other modules .

*Название компании* Senior Developer/Analyst.Oct ▒ 97 to Apr▓98

Environment:═══ Dec Alpha 1000, Oracle Application 10.7SC

*Название компании* Sr Software Engineer Aug▓ 93 to Sep ▒97
═

*Название компании* Sr.Software Engineer ═Jun▓96 to Sep ▒97

Environment:═══ Sun OS Enterprise 5.6, Oracle Application 10.7 SC

*Название компании* Software Engineer Aug▓ 93 to May ▒96

Involved in design development for various in house projects.

*Название компании* Jan ▒95 -May ▒96

Environment: ORACLE 7.1, Forms 4.5, Report Writer 2.5 on LAN and UNIX, Pro* C, PL/SQL

Responsibilities: This system is designed to monitor and record all stores transactions.═ It generates reports like ABC Analysis, High stock value list and Items below re-order level. Responsible for the design, development, coding and testing.═ Wrote stored procedures, triggers and packages. Responsible for the Database Administration such as logical & physical database design, creation of table spaces and application tuning. Extensively used Designer/2000, Developer/2000, and PL/SQL.

*Название компании*═Aug▓ 93 to Dec▓95

Environment:═══ ORACLE 7. 1, Forms 4.5, Report Writer 2.5 and UNIX

Responsibilities: This system was developed to automate the HR functions in an organization.═ Involved in heavy user Developing the front end user interface using Forms 4.5. Creating various employee reports, e.g. total wages paid per month or per week, total over time claimed absenteeism etc.

OBJECTIVE

Looking for an opportunity in ERP domain that utilizes my functional and technical skills of Oracle Financials, Oracle database and Developer/2000 programming.

PROFILE

ERP consultant (MBA background) with experience of conducting business process & systems analysis, working on Oracle Financials Release 11 and developing accounting systems using Oracle Developer 2000. Oracle Certified Professional (Financial); Almost 3 years diversified and extensive experience of Oracle database programming, Developer/2000 application development and ERP implementations; Exceptional communication and interpersonal skills and proposal writing ability. Good project management skills and effective team working aptitude.

OCP-Oracle Financials Track Passed Financial Management (GL+FA), Procurement (AP+PO+CM) and Applied Technology, completing the certification.

SKILL SET

SOFT SKILLS

1. Effective interpersonal and communication ability.
2. Excellent Project management skills.
3. Proposal-writing Skills.
   
4. Good negotiation and selling skills.

PROFESSIONAL EXPERIENCE

*Название компании* CONSULTANT (Feb 98 till present)
(SENIOR ORACLE APPLICATIONS CONSULTANT)

(A) *Название компании* (June 00 till present)
As Senior Oracle Financials Consultant
Environment: MS Windows NT

• Responsible for the implementation of modules of Oracle General Ledger and Oracle Payables Rel 11.
• Conducted thorough analysis of the relevant required process flows using Oracle Application Implementation Methodology (AIM) Ver. 3. It included preparing deliverables such as Current business Baseline, Gap Analysis documents, and Current Architecture etc. to ascertain the existing problems, future business needs and multi-organization issues.
• Involved from the design of Chart of Accounts to defining value sets, Set of Books, Currencies, Calendar, FSGs, Budgets, Payment Terms, Pay-groups, Suppliers, Supplier Sites, Distribution Sets, Options, Invoice entry, Expense reports, and Cash-Control features.
• Involved in supervising the customization of some forms in Oracle General Ledger and Oracle Payables using Forms 4.5 and Reports 2.5.
• Responsible for testing of new systems and their documentation.
  
• Conducted training for the end-user to familiarize with the functionality of Oracle Financials.

(B) *Название компании*(Feb-00-Jun 00)
As Senior Financials Consultant
Environment: MS Windows NT

• Responsible for the Implementation of Oracle Fixed Assets at the Company.
• Conducted the Current Business Baseline and Gap Analysis of the Client's Business.
• Set up the Oracle Assets module which involved Category and Location Flexfield, Depreciation Calendar, Quick Codes Types, Prorate Calendar/Conventions, set up Asset Corporate Books, Tax Books and Budget Books.
• Used Mass Addition Interface to bring the Legacy data into Oracle Assets Tables.

(C) *Название компании* (July 99 - Jan 00)
As Oracle Financials Consultant
Environment: MS Windows NT

• Responsible for creating and implementing strategy for Oracle General Ledger and Oracle Payables Rel 10.7 implementations.
• Studied the current business processes and prepared the Current Business Baseline and Gap Analysis documents.
• Setup Accounting Flexfields Structure, Set of Books, Calendar, Currency, reports on FSG, Vendors, Vendor Reports, Matching Option and Payables options.
• Managed the testing of new system.
• Trained End-users to use Oracle Financials. Provided functoinal/technical support for the new implementation.
  

(D) *Название компании* (Jan 99- May 99)
As A Programmer Analyst

• Active part of team that developed complete accounting system meeting the financial reporting requirements of the company.
• Studied the current business of the client and involved in preparation of implementation strategy.
• Prepared data-modeling of different processes.
• Involved in designing the screens on Forms 4.5 and ascertaining the reporting requirements of the organization and developing them on Reports 2.5.

(E)*Название компании* (May 98-Oct 98)
As A Programmer Analyst

• Prepared a complete information management system for Sun Education Centre (an educational concern).
• The system maintained all the details of the students, different courses , available instructors and the previous and current data of test-grades.

PROFESSIONAL DEVELOPMENT

1. OCP(Financials) - Procurement Track.
2. Oracle Diploma for Application Developer
   (Oracle Developer/2000, Data Modeling, Erwin, SQL, PL/SQL, Forms 4.5 x,
   Reports 2.5 x ,Graphics 2.5 x, Discoverer/2000 3.x)
3. Oracle 8 DBA
4. Unix, Sun Solaris including Unix Shell programming
5. Rational Rose, Designer 2000
6. Advanced Modeling Concepts including UML.

ON THE JOB TRAINING

• Oracle Financials- ( ILT Training Release 11); General Ledger- Fixed Assets- Oracle Purchasing- Oracle Payable
• Work Flow, System Administration, Alerts, Oracle Applications DBA overview and Fine Tuning.

EDUCATION

Institute of Business Administration, Karachi.
Master of Business Administration/Bachelor of Business Administration(1997)

REFERENCES

Available on request

TECHNICAL SKILLS

MS-Dos, Unix, Windows 95/NT, Novell 3.x, Cobol, FoxPro 2.5, MS-Office, Clipper 5.x, Oracle 7.x, Oracle 8.x, Oracle Manufacturing 10.7, SQL Server 6.5/7.0, Developer 2000, Visual Basic 5.0, MS-Access, Crystal Reports, Java 1.2, JDBC, Java Servlets, Java Web Server, Crystal Reports, VB Script, Windows Host Script and Mercator

Sun Certified Java 2 Programmer
Brain Bench SQL Server 7.0 DBA

7/00- Present *Название компании*
SoftwareDeveloper
Engineering Automation

Tools: Oracle Apps 10.7, Oracle Manufacturing, PL-SQL, Forms 4.5, and Reports 2.5

Description:
Oracle Applications 10.7 allows only one item, Bill of Material and Routings to copy from one organization to another organization at a time. To enable the users to copy items, Bill of Material's and Routings in bulk from one organization to another organization using the Oracle Interface programs, we developed some backend PL SQL code to transfer all the items into interface tables as per the user requirements. Developed Front End Forms using Forms 4.5 to capture the user requirements and validated the items and other interfaces with the destination organization. Role includes Testing of Interfaces, loading data into interface tables. Developed data capturing code and transferring the data in the destination organization.

6/00-7/00 *Название компании*
Software Developer.
Customization and development of Oracle Application Reports.

Tools: Oracle 8.x, PL-SQL, Reports 2.5, Oracle Apps 11.x

Description:
Designed and developed Margin and production periodical reports using reports 2.5. Created Stored procedures, tables and indexes in the database to store the data. Customized the old reports and registered the new reports in the Oracle Application Server.

3/99 - 6/00 *Название компании*
Software Developer.

Online Policy Processing System for Insurance Carriers
Tools: Java (JDK 1.2), Java Servlets, EJB, Java Script, JDBC, HTML, Java Web Server and Oracle 8.x
Description:
To enable the carriers to process the Insurance policies for the consumers ITSA develops Online Policy and Quote System for Home and Auto Insurance needs. Developed Servlets and HTML scripts on the server side to connect and communicate withthe Oracle Database Server and send the response back to the carriers where the policy is being processed. Developed Servlets, HTML scripts and java objects to process the data in the database using JDBC.

Carrier Feeds Interface Reports
Tools: Oracle 8.x, PL-SQL, SQL Navigator, VB Script, Windows Host Script, and Mercator
Description:
To enable Carriers to access their Policies into their financial and other systems, ITSA develops Electronic Interface Documents from their Transactional and ODS Data and transmits the electronic files to Carriers using different transfer methods. Developed Data Conversion procedures, functions, Tables, Mercator Type Trees and Maps to generate the Electronic documents and automated the processes using VB script and Windows Host Scripting to run at different intervals and to save the generated files in the assigned systems to enable the transfer process to carriers.

Operational Data Store
Tools: Oracle 8.x, SQL, PL-SQL, SQL Navigator, Java 1.2 and DBC.
Description: ITSA Develops Internet based tools for comparative rating of insurance products offered by various insurance carriers. The technology enables insurance agents to assess risk and offer comparative quotes from various insurance carriers and issue insurance policies on line. The agents also service the policies through online billing, collection and processing claims. The transactional database was designed to enable quick adoption to carrier requirements and stored data as tagged question - answer pairs. However this was not suited for reporting to statistical agencies and carriers. Hence we developed an Operational Data Store (ODS) aimed at redesigning and normalizing the database for quick retrieval.

Designed and Developed Stored Procedures, Functions, Creating Tables, Indexes, Triggers and Scripts for uploading from the Transaction Database to ODS. Tuning of the Database and Applications to speed up the process. Creating appropriate security for carriers to access only reevant data. Maintenance of ODS.

Developed Applets using Java 1.2 and JDBC to help business analysts to enter the required data into the metadata tables. Business Analysts will enter the question detail id, column name and table name to which it is associated in ODS so that the next process can pick that column from the transactional system and put the data in the ODS.

09/98 - 2/99 *Название компании*

SQL Server System Administration and Customer Support for HR product
Tools: SQL Server 6.5, Visual Basic 5.0, and Crystal Reports, Transact SQL
Description:
The product Searcher is a Human resources product developed in Visual Basic 5.0 using SQL Server 6.5 as the backend. Designed and developed reports using Crystal Reports and SQL Server 6.5 in the backend as per the requirements of Customers. Role includes System Administration, Database Creation and maintenance, Installation,Training and trouble shooting at client sites and client specific reports using crystal reports.

7/98 - 09/98 *Название компании*
Programmer-Analyst.

Data Migration from Unix Files to Oracle 7.3 and SQL Server 6.5
Tools: SQL, PL-SQL, SQL Loader, BCP and Transact-SQL
Description:
The data in the flat files were separated by a delimiter ~ and Tab. The Data was converted into different tables using SQL-Loader, PL-SQL for Oracle and BCP, Transact-SQL for SQL Server 6.5. Primary and Foreign Key Relations were taken care before migrating the data.

1/95 - 6/98 *Название компании*
Senior Programmer

Environment: Oracle 7.3 with Developer 2000, Clipper 5.x, FoxPro 2.5, Forms 4.5 and Reports 2.5, Novell 3.x and Windows NT
CompanyProfile: The Company has 3 units in different locations. Each Unit is logically segregated as a different warehouse. Security was provided for transactions between the warehouses and also a unique transaction number was required to be generated depending on the place of transaction.

Ware Hose Maintenance (Raw Materials)
RDBMS Used: Oracle 7.3 GUI: Developer 2000 (Forms 4.5, Reports 2.5)
Description:
This project enables the user to keep track of information of raw material present in the stores. The basic idea of the system is to give the details of the raw materials. Role includes Database design, writing Stored Procedures, Creating Database Triggers, and Generation of Forms, Reports and Menu's.

Warehouse Maintenance (Finished Goods)
RDBMS Used: Oracle 7.3 GUI: Developer 2000 (Forms 4.5, Reports 2.5).
Description:
This project enables the user to keep track of information regarding product dispatches. The basic idea of the system is to maintain the up to date details of the products such as lot number, bag number and date of manufacturing. Role includes Database Design, Writing Stored Procedures, Creating Database Triggers, implementation and Data Conversion from DBF files to Oracle Database.

Material Management System
RDBMS Used: Oracle 7.3 GUI: Developer2000 (Forms 4.5, Reports 2.5)
Description:
This project enables the user to keep the track of information regarding daily consumables and engineering materials present in the stores. The basic idea of the system is to maintain the details of the materials present in the stores. The different types of transactions allowed in the project are receipts, Issues, Transfers and Rejections of the materials, Supplier Details, Purchase Order Details, Pending Orders. Role includes Database Design, Writing Stored Procedures, Creating Database Triggers, implementation and Data Conversion from DBF files to Oracle Database.

Payroll Accounting System
RDBMS Used: Oracle 7.3 GUI: Developer 2000 (Forms 4.5, Reports 2.5)
Description:
This project enables the employer to keep track of employee's details. The basic idea of the system is to reduce the written work of the personnel department and to maintain up to date details of the employees. Role includes Database Design, Writing Store Procedures, Creating Database Triggers, implementation and Data Conversion from DBF files to Oracle Database and Report Generation.

Production Management System
Software Used: FoxPro 2.5
Description:
This project enables the user to keep track of information regarding the machine wise and worker wise production in various departments. The basic idea of the project is to reduce the written work of the production department people so that they can concentrate on the quality of the product. Role includes Screen Generation, Report Generation, Coding, Testing and implementation.

Finance Management System
Software Used: Clipper 5.x
Description:
This project enables the user to keep track of the cash flow in different accounts and developed under the Novell 3.x Platform. This system includes Cash and Bank voucher generation, Daily Cash and Bank Books, Trial Balance generation and integrated with the Inventory an Payroll. Roll includes menu generation, writing functions and procedures, array manipulation and coding and database design using NETLIB and Clipper Tools. 5/90 - 12/94 Venkateshwara Hatcheries Ltd. Programmer Analyst Environment: IBM-PC's, COBOL, FoxPro, Clipper and Novell 3.x

Payroll Management System
Software Used: FoxPro 2.5
Description:
This project enables the employer to keep track of employee's details. This system was converted from COBOL to FoxPro 2.5, as there were not many modules except the master maintenance in COBOL. The basic idea of the system is to reduce the written work of the personnel department and to maintain up to date details of the employees.

Sales Management System
Software Used: FoxPro 2.5
Description:
This project enables the user to keep track of sales details. The basic idea of the system is to maintain the up to date details of the customers and to keep trac of the sales schedules, Sales representatives efficiency's, Production planning as per the sales schedules, Delivery ticket maintenance, and Order Booking and Pending Order maintenance.

Provident Fund Management
Software Used: FoxPro 2.5
Description: This project enables the user to keep track of Provident Fund Details. The basic idea of the system is to maintain up to date details of the employee's provident fund deducted from their salaries and also of the employer contribution paid to the fund monthly. This system maintains the different types of loans taken by the members from their accounts and the repayments made by the members from time to time.

Production Management System:
Software Used: Clipper 5.x, Platform: Novell 3.x
Description:
This project enables the production department people to keep track of different farms and to reduce the documentation work of the production people so tat they can concentrate on the production efficiency. This project maintains the shed and farm maintenance, daily egg collection, egg hatching, egg classification, chicks generated from hatchery, farm wise feed and medicines consumption, and mortality rate of birds in different farms. Role includes developing popup menus, reports, Writing Functions and Procedures, Array manipulation and coding. Used Network functions and Environment Snippets, Event Trapping using NETLIB Functions, General Functions and Snippets.

First Class Bachelor of Science with optional Mathematics, Physics and Chemistry
Post Graduate Diploma in Computer Applications
Console Operator-cum-Program Assistant
Certificate Certificate Course in VISUAL BASIC - 5.0

More than 6 Years Experience in Software Development. Strong in Oracle Developer 2000. Worked through the SDLC. Extensive Coding and Trouble Shooting Experience. Approx. 2 years experience in Oracle Applications. Confident of handling Customizations, Migrations and Technical Support in Oracle Apps.

TECHNICAL SKILLS

• HW/OS : Pentium Server with Pentium nodes. Windows NT / Novell NetWare / Windows 95-98 / MS DOS/AIX
• Software: Oracle 8.x/7.x, Developer 2000
• Languages: SQL, PL/SQL, SQL*Loader, C, COBOL, PASCAL, BASIC
• ERP : Oracle Applications 11.x; 10.7SC Modules : AR , AOL , OE , AP , GL , INV , PA
• DBA : Oracle 7.x

PROFESSIONAL EXPERIENCE

• Technical Consultant *Название компании* Jul 00 to till Date
• Associate Consultant (Technical ) *Название компании* Feb 99 to June 00
• Software Executive *Название компании* Oct'96 to Feb'99
• Computer Engineer *Название компании* Apr'95 to May'96
• Computer In-charge *Название компании* Jan'94 to Mar'95 JOB

RESPONSIBILITIES

• Customization of Reports in various Oracle Applications Modules
• Upgradation preparation for Oracle Apps & Migration.
• Data Conversion from legacy System (Using SQL Loader)
• Registration of reports, tables and procedures. Creation of concurrent programs for Oracle Applications Reports.
• Creation of new key and descriptive flexfield through AOL and registration of the same in Oracle Application.
• Creation of new flexfield structures, Users, Responsibilities, Request Groups and Data Groups.
• Defining Value Sets and attaching them to report parameters & flexfield segments.
• Training Organization for team members. Environment : Oracle Applications Rel 10.7 SC on Oracle Server 7.3

PROJECT DETAILS:

Title : Oracle Financial Support Jul 00 - Till Date
Client : *Название компании*

The client *Название компании* is a Govt. Body . Their all major activities like finanace, budgets , projects and Inventory are taken care by Oracle Financial System .The major work included customizations and technical support . Also upgrade preparation was done from 10.7 SC to Release 11.0.3 N C A .

Title: On Site Customization & Migration of Oracle Financial Jan 00 - Jun 00
Client : *Название компании*

The client *Название компании* is a major player world over in Financial Services. The project was of Migration from Release 10.7 SC to Release 11.0.3 N C A. Migration of customized reports was handled by me. It included re registering the reports , modifications in existing ones. Also there was a requirement of AP Interface from a third party system.

Title : Offshore Developent of Oracle Application Reports Feb 99 - Dec 99
Client : *Название компании*

Involved in the development / customization of Oracle Applications Reports. Customized reports in AR, AP, OE & GL modules. The work included getting the specs and converting them into deliverables. Name of the reports customized are :

Role: Technical consultant

• Migration & Customization of existing reports , development of new reports.
• Preparation of Program Specification and testing.

Environment: Pentium server with Pentium nodes ,Win NT server, Win-95, Oracle Applications 10.7/11, Oracle7.x/8.x, Developer2000

Title : Short Term Solution (MRP Soln.) Jun - Jan 99
Client : *Название компании*

The implementation follows the centralized control system using the production centres in network for the purchase and issue of materials to the Production centres All requisitions are sent to the Branch Office which raises the Purchase rder and sends it to the Production Centres through online transaction network. reports for the Purchase department were Vendor Report (Material Type coded, non-coded, Material wise,Alphabetical Listing etc.)

Role: Purchase Module (Reports and form/module level testing)
Environment: Oracle Work group Server on win-NT,Developer 2000 as front end.

Title : Integrated Footwear Business Solution Dec. 97-June. 98
Client : *Название компании*

This is a Product targeted to Shoe Manufacturing Industries initially for Production Planning, Inventory and related Purchase activities. This is unique of this kind and was exhibited successfully in Shoe Fairs at Chennai & Delhi.

Role: Programmer/Project Leader
Environment: VB5.0/Oracle7.x and MSAccess on Windows NT

Title : Fixed & Recurring Deposit System Sept.-Nov. 1997
Client : *Название компании*

This software aims to automize the activities of Bajaj Capital Limited a financial company. Starting from the investment by diffrent customers for various companies to the maturity or renewal of the investment, each and every activity was taken care of. Sub-broker maintenance, their commissions and discount were calculated by the system. Various reports were generated like sub-broker business report, bounced cheque MIS, fresh/renewal bill etc.

Role: Project Leader/System Analyst
Environment: Oracle Work Group server on Win-NT, Visual Basic 5.0 as front end.

Title : Candidate Information System Oct.-Dec. 1998
Client : In house Project

This system maintained all the details of the prospective employees for company's offices and Clients in the USA. Candidates seeking appointment overseas. The package takes care of Personal Information, Educational Details, Technical Knowledge and Work Experience of the candidate along with advertisement processing, Interview, Appointment, Resume Bank and Visa Processing. Different search Queries and Reports were done to facilitate the managementas Candidates List in VB/Oracle with 4 years of experience aged not more than 28 etc.

Role: Design/Development/Reports
Environment: Oracle 7.1 with Developer 2000 ,Pentium Server on Windows NT.

Title : Project Tracking System Oct . 96 - July 97
Client : *Название компании*

This is a complete MRP soln for the company manufacturing cement plant equipments. The software tracks all operations starting from the sales dept. to project order, bill of material, indent generation, material procurement, work order processing and human resource, spares & Service etc.

Role: Coding(Inventory Module), Manual Writing.
Environment: Oracle 7 with forms3.0 reports 1.1 on UNIX (Novell Netware3.12)

Title : Medical Care Management System Oct. 95 - Jan. 96
Client : *Название компании*

This system kept track of all the activities going on in the nursing home like Registration of Patients, Prescription, Room Allotment, Medicinal Stock details,Diagnostic Aid Services, Ancilliary Units, Appointmets etc..

Role: Analyst/Programmer
Environment: Oracle 7 with forms 4.0

Title : Inventory Management System Jul. 95 - Sep. 95
Client : *Название компании*

In this system Indents and Purchase Orders were inputs. It consisted of Material Inwarding, Material Issue, generation of stock details, Inspection, Rejection etc.

Role: Programmer
Environment: Oracle 7 with forms4.0

Title : Annual Maintenance Contract Dec. 94 - Feb. 95
Client : *Название компании* .

This system keeps track of all the systems installed by the company and under Annual Maintenance Contract Scheme, Repayment Schedule, AMC expire date, Maintenance Cost incurred by the company.

Role: Programmer
Environment: Oracle 7 with forms 4.0

QUALIFICATIONS

B. Tech. from B. I. T., Sindri India ( Vinobabhave University ) in Computer Science & Engineering

EDUCATION & CERIFICATIONS

Oracle Certified Professional (Application Developer) Release 6.0/6i 2000
Oracle Certified Professional (Application Developer) Release 2 1998
Oracle Certified Professional (Application Developer) Release 11998
Oracle Masters Certificates:

• Applications Administrator
• Applications Developer (Developer 2000 R1.3)
• Applications Developer (Developer 2000 R2.0) 1998

B.B.A. Information Management 1992
A.A. Information Management 1988
University of North Dakota, Grand Forks, ND 58201

I/T PROFESSIONAL EXPERIENCE

Lead Oracle Application Developer--Independent Consultant 1998-present
*Название компании*

Provide consulting service on an independent contract to the *Название компании* National Information Center in Eagan, MN. I am the lead programmer on a project to enhance the National Training Database. The National Training Database was designed and implemented as the first ORACLE database enabled web application at the MNIBSSC. This application has now grown to over 20 million rows, over 50 database tables, approximately 40 reports, over 100,000 lines of code, and the end users adding approximately 20,000 records per business day. This growth has placed the National Training Database as one of the most highly used systems at the MNIBSSC. In addition to the tasks and accomplishments listed, I mentor other programmers on ORACLE coding techniques for ORACLE reports, PL/SQL, and forms products and serve as the only ORACLE instructor for employees at MNIBSSC.

Lead SQL Server/Web Application Developer--Independent Consultant 1999- present
*Название компании*

Worked in collaboration with Mike Barker and Associates in creating the WWW.******.COM, WWW.*******.COM, WWW.********.COM, AND WWW.*******.COM websites. These websites are a central job posting repository targeting specific industries in the UK. This is comparable to the Monster.com or Dice.com sites we have here in the US. When a company is looking for a specific resource in a specific industry, they will register with that website, pay the registration fee and post their jobs within the website. Candidates are free to browse the site and apply for any of the postings listed. In addition, I created a site administrator utility which allows the web master to delete postings and users from the database as needed. The pages were created by the user using MS Frontpage. I then made the appropriate visual changes and coordinate the links using HTML and Frontpage. Most importantly, however, I designed and created the tables that will store the user and job posting information in an MS SQL Server V.7 environment. I also created the code behind the pages using to add uers (thus, updating the SQL Server tables) to the system, verify users upon login, allow for the display of valid job postings on the job posting pages by selecting the appropriate information from the SQL Server tables. This was all done using SQL, VBScript and Active Server Pages, MS Frontpage, and HTML.

ORACLE Instructor--Independent Consultant 1998-present
*Название компании*

• I*Название компании* - Oracle Education Partner
  • Developer 2000 Build Forms I (Release 2.1)
  • Developer 2000 Build Reports (Release 2.1)
  • Introduction to Oracle: SQL and PL/SQL (Oracle 8 & 8i)
• *Название компании* - Oracle Education Partner
  • Introduction to Oracle - SQL and PL/SQL
• *Название компании*
  • Oracle Foundations - SQL and PL/SQL
  • Designing Oracle Forms I Release 2.1
• *Название компании*
  • Developer 2000 Build Reports (Release 2.1)

Senior ORACLE Instructor - Core Technologies 1997-1998
*Название компании*

Prepare and instruct customers in the following areas to include both on-site and education Center teaches:

• Introduction to Oracle - SQL and PL/SQL using Procedure Builder and SQL Plus
• Developer 2000 Release 1.3 Forms I (v.4.5)
• Developer 2000 Release 1.3 Forms II (v.4.5)
• Developer 2000 Release 2.1 Forms I (v.5.0)
• Developer 2000 Release 2.1 Forms II (v.5.0)
• Developer 2000 Release 1.3 Reports (v.2.5)
• Developer 2000 Release 2.1 Reports (v.3.0)
• PL/SQL Program Units
• Advanced SQL for Oracle/7 and Oracle/8

In addition to ILT, other accomplishments within this position include:

• Mini-session Presenter at the 1998 Midwest Oracle Users Group (MOUG) meeting in Chicago
• Assist customers with curriculum plan, suggesting next logical training path
• Acted as Sr. Co-Instructor for all classes in my curriculum
• Mentor for Jr. Instructors
• Member of Oracle Education's Quality Club

ORACLE Deveoper 1996-1997
*Название компании*

*Название компании* is a primary provider/manufacturer of hearing aids throughout the world. There are approximately 12 international sites. Starkey (U.S.) operates on a Unix/Oracle 7/Oracle Applications (10.6) platform with the international sites following suit via their on-going international project scheduled to be completed by 1998.

• Primary Report Developer for the customization of the Starkey Billing Statement for the international sites. International travel was necessary to speak with users and develop end product.
• Development, customization and support of reports contained in the Manufacturing, Purchasing and Financial Modules of the Oracle Application package using Oracle Reports 2.0 and 2.5.
• Conversion of reports developed in Reports 2.5 to Reports 2.0 for successful use within the Oracle Applications.
• Registration of Reports within the Oracle Applications.
• Evaluate users' needs regarding report canges and make appropriate recommendations to management.

Project Administrator -- ORACLE Report Writer 1994-1996
*Название компании*

*Название компании* is a dynamic semiconductor design and manufacturing facility primarily operating in a client/server technical environment using a Unix/Oracle/Avalon platform with an HP 9000 host. The primary duty of this position is to act as a liaison between the user community and management. It is my responsibility to gather information, analyze situations and make recommendations for change which will accommodate both groups. In this role, I need to take technical language and present it in a fashion that is both understandable and logical, as well as visually appealing.

• Develop Access database, forms and reports
• Develop reports using Oracle Reports 2.0
• Collect report specifications and requirements from users for development of reports
• Collect data and prepare project plan for report writing ctivities
• Coordinate project teams to evaluate new software to fit users' needs and make appropriate recommendations to management
• Develop I.S. budget and Purchase Order tracking system for management
• User support of 'desktop' software
• Develop training program for the MS-Mail Program and administer training
• Format and maintain monthly I.S. Department metrics and performance charts

LANGUAGES AND TOOLS USED

• Oracle Database V7.0, 8.0, 8I
• Oracle Developer 2000 Reports V6.0
• Oracle Developer 2000 Reports V6i
• Oracle Developer 2000 Reports V3.0
• Oracle Developer 2000 Reports V2.5
• Oracle Developer 2000 Forms V6.0
• Oracle Developer 2000 Forms V5.0
• Oracle Developer 2000 Forms V4.5
• Oracle Developer 2000 Procedure Builder V6.0
• Oracle Developer 2000 Procedure Builder V2.5
• Oracle Browser V3.0
• Oracle Designer 2000
• Oracle Web DB Oracle SQL Plus - all versions
• PL/SQL
• SQL
• HTML
• VBScript
• Active Server Pages
• MS Frontpage
• MS Office

Seventeen years' experience in Information Processing with steadily increasing responsibility and proven performance in system analysis, management, programming, design, maintenance, procurement developer instruction and implementation; ORACLE tools and PL/SQL applications development (Financial, Military, Telephony, Construction, Inventory, Publishing, Accounting and Imaging); network and hardware configuration design, procurement and maintenance; Joint Application Design (JAD) and information engineering utilizing CASE; tools evaluation in conjunction with such suppliers as IBM (OS/2), ALDUS, etc.; and technical requirements development, documentation and training (both in English and Spanish). Recognized for dedication to quality and innovation in developing custom applications. Additional skills in developing and delivering training initiatives nd project management. WORK

*Название компании*, Oracle Database Analyst, 5/00 to PRESENT
*Название компании*, Senior Business Systems Analyst, 2/00 to 5/00
*Название компании*, Principal Consultant, 11/98 to 2/00
*Название компании*, Systems Project Administrator, 03/98 - 10/98
*Название компании*, Programmer III, 01/96 - 03/98
*Название компании*, Senior Systems Analyst, Inc., 09/94 - 12/95
*Название компании*, Systems Engineer, 10/90 - 08/94
*Название компании*, PC Programmer, 02/90 - 09/90
*Название компании*, Systems Analyst, 06/89 - 01/90
*Название компании*, Engineering Technician, 03/83 - 06/89

SKILLS HIGHLIGHT:

Oracle Products:
ORACLE Designer/2000 (since 1.0)/ORACLE CASEDICT 5.0
ORACLE SQL*LoaderORACLE SQL*Forms (since 2.x)
ORACLE SQL +, PL/SQLORACLE SQL*Reportwriter (since 1.0)
ORACLE Developer/2000 (since 1.0)
Oracle RDBMS (8x,7x,6x,5x) WAS/OAS/IAS Web Toolkit

Other Products:
ADW Knowledgeware CASECold Fusion
Visual BasicCrystal Reports
WINBATCHCSS (Cascading Style Sheets)
NetscapeInternet Explorer

Management Skills:
Project leader; Task Planning, Source Control, Delegation & Monitoring, Technical
mentoring

Operating Systems:
Unix, Windows NT/98, Novel Netware, IBM MVS, DEC VAX/VMS, OS/2, DOS
Hardware:
SUN Solaris, IBM, DEC VAX

PROJECT EXPERIENCE:

5/17/200 - PRESENT
*Название компании* Consulting

Skills

Work Experience

12/99 - Current (08 + months) : *Название компании*.

Description : The Supreme Court's project Court Appointed Counsel(CAC) initiates two workflow processes by approving monetary amounts for payment to appointed Attorneys and to legal staff . In addition , the Court prepares/tracks other data items relating to the Status of Automatic Appeals and the Status of appointments of Counsel for the Direct Appeals and Habeas Corpus petitions.

Duties :

• Solely Designed and Developed the CAC system .
• Designed and created the Database Structure. Developed
• the highly interactive Application Forms.
• Designed and Developed the Conversions of Data from the Legacy ystem to Oracle.
• Developed Data Analysis Reports to help the Court for Budgeting and Forecast of Monetary Flow.
• Involved in Production Support of the Court Appellate Project.
• Prepared User documentation and gave User Training
• Prepared Functional Design , Technical Design and Implementation Documents.

The Project invovled development of two modules namely :

1) Administrators Invoice Summary and Detail : This application consists of the Billing System which is used by the Court to make the payments based on the Invoice Claims by the Court appointed Attorneys. The Invoice Detail Form is used to enter the details of the hourly billing based on each of the Indigent Criminal Appellant and case number for the particular contract and invoice number during the billing period.

2) Cummulative Hours Claim Form : This application consists Attorney's cummulative hours accumulated for the claims submited by the attorney for the hourly billing for various categories like record review , record correction etc. The Automatic Appeals Cumulative Hours Claim Forms are submitted by appointed counsel to the Supreme Court is reviewed by the Automatic Appeals Clerk for an award of payment. Involved in exporting data from the current system to Accounts Payable module and also run the concurrent manager job in Accounts Payable module.

Environment : Oracle Developer 2000 Forms 5.0 , Reports 3.0 , SQL/PLSQL , Sql loader , Data Warehousing Tool Informatica 4.0 , Business Objects 4.0. Oracle Applications Release 11 Accounts Receivables module.

08/98 - 07/99 (Duration: 08 months) : *Название компании*.

Description : Airtouch Communications converted multiple legacy systems to Shared Services Install on Oracle Applications Release 11.1.1. Duties involved in design and build of multiple interfaces and conversions in Oracle General Ledger, Oracle Inventory, Oracl Puchasing modules.

Oracle to GL Tax Software system : Involved in the design and development of GL tax Information from Oracle Applications to legacy Tax Software system. Designed and created mapping from source Oracle Tables to Target fixed format flat file by using Oracle Enterprise Data Management system (EDMS). The task involved to generate Tax Data into a flat file to FTP to the legacy system. The Tax data contained accounting GL balance information grouped according to the code combination segments information .The Concurrent Program developed for the system allows the user to enter the specific segments like Company, Managed Unit, Cost Center, Location, Natural Account, Sub - account ,Product code. The program also checks for validation requirements specified by the user to generate the required Flat file. The program also involved in generating the Report grouped according to the managed uit to cross check the Tax information in an easier manner and also validation purposes for the legacy Tax system.

Oracle Receipts to Cambar Interface: Cambar is a legacy system containing only legacy inventory , Order Entry and General ledger system. The program involves extraction of Receipts data into a Fixed Format flat file and FTP to the Cambar system. The Receipts for the Cambar items is handled in the Oracle Receivables module at the Airtouch Cellular even though the physical inventory is routed and maintained at the Cambar system. The Decrement and Increment of the Inventory for Cambar items is performed by applying Miscellaneous issue and receipts and then the concurrent process is run using the standard Inventory Manager Job. Involved in the Module Technical design of Oracle Puchase Orders to GERS legacy point of sales system and updating the accounts information in General Ledger module and also modifying changes to the interfaces in the Purchasing module interfaes .

Oracle Inventory Conversions : Extensively Involved in the Conversions and validations of data from legacy system to Oracle Inventory module for different market regions . Involved in conversions of legacy data for Inventory Stock Locators.

Environment : Oracle Applications Release 11.1.1 ,Oracle EDMS, Unix Sun Solaris,Developer 2000( Forms 4.5,Reports 2.5, PL/SQL 3.3.1) , Designer 2000.

References: *Name*, Team Leader, *Название компании*. *Name*, Functional Team, *Название компании*. *Name* , Project Director, *Название компании*.

01/98 - 08/98 (Duration: 7 months) : *Название компании*.

Description: Hearst is a Publishing and Distribution Company which is involved in Publishing magazines and books and also a Distributor for Bookstore Super Chains like Barnes and Noble, Towers ,Borders. The existing application is currently running on a Mainframe system, and only part of the Mainframe sytem is being replaced by the Oracle Applications Modules containing AR,OE,GL and a Customs Returns Module.

Responsibilities included in developing Interfaces , Customisation and Implementation of Oracle Applications 10.7 Smart Client (SC) in Accounts Receivable (AR) Module.Used AIM ( Application Implementation Methodology) to develop the application using Requirement Analysis , Module Functional Design, Module Technical Design,Conversion and Mapping , Module Installations Instructions , Integration Fit Analysis. Also used PVCS for Version Control, Naming Standards , Check-in and Check-out.

Used Designer 2000 to reverse engineer programs to generate Forms and Reports and design primary and foreign key relationship between Tables and Views to generate customized customer information for the User. Duties included Design , Build and Installation instructions of the Oracle Application Modules.

Outbound Interfaces from Oracle Applications to Legacy Mainframe Systems. n-Demand Customer Interface to legacy system : Used Informatica GUI Interfaces tool to design the mappings for generating customer Bill to and Ship to information of new and updated customers from Oracle Tables to generate the Flat files for the mainframe system.The Informatica batch sessions are created for the mappings in the Informatica Server manager to generate the customer information . A UNIX job scheduler is used to run the batch programs daily and FTP them to the Mainframe system.

ICD Magazines and Distribution System : Written Database Triggers in PL/SQL to generate the new inserts and updates , using the Before-Insert and Update Triggers and calling a Package to generate the specific information required by the user. Customized the 'Forecast Entries' screen or Forms in the Oracle MRP module which is used to enter and modify the data in the forecast details screen.The Screen was modified in order to enter the forecast detail lines or assign the allotment quantity ad edition for every customer and Ship to location. It was also required to move some of the attributes from the DFF for the user to enter data like the customer name , edition Description etc . The allotments and edition information needs to be assigned to the customer and ship to location in order to have a complete forecast. The descriptive flex fields are enabled but not displayed in the descriptive flexfields . A package , local to the module was created and the procedures in that package are called in various triggers to maintain the exact functionality.Written Triggers at the Form level , Block level and other triggers.

Environment : Oracle Applications 10.7 SC , Informatica 4.0, Unix SunOS 5.5.1,Developer 2000( Forms 4.5,Reports 2.5, PL/SQL 3.3.1) , Designer 2000.

References : *Name*, Team Leader , *Название компании* Consulting. *Name* ,Team member, *Название компании*. *Name*, Project Manager, *Название компании*

10/ 96 - 11/97 (Duration: 3 months): *Название компании*

Description : Implementation Of Oracle Applications. The implementation is carried out for Biological E. Ltd, an established pharmaceutical company. Migration of the Inventory Module running on Oracle 7.x to Oracle Applications.

Responsibilities : Involved in system study of existing legacy system in terms of functionality, Reporting requirements, GUI Interface, etc. Interaction with User Groups for Feature enhancement requests to be made to the new Oracle Applications system. Involved in database conversion by developing Interface programs using SQL*Loader and PL/SQL programs for loading interim tables from datafiles. Design and customize Flexfields to support existing codification. Customize Oracle Application forms to support the functionality provided by legacy GUI screens. For GUI Screens from the legacy system, where there was no mapping to Oracle Application Forms, then developed new forms and inegrate these with Oracle Applications using AOL .

Environment: Oracle Applications 10.6, Application Object Library, RDBMS 7.3,SQL*PLUS 3.1, PL/SQL 2.1,Reports 2.5.

01/ 96 - 10/96(Duration: 9 months) : *Название компании*

Description :Share Transfer System. The Share Transfer System is menu driven, flexible and perfect decision making system.The main module of the share transfer system is the transfer module. The seller and buyer details make the input to the system. The execution of the module is carried out in a series of steps as descirbed below :

• Checklist & Mismatch : validates the data with the masters and generates error report.
• Buyer's extraction : Generates folio numbers for non-existing buyers and extracts existing buyer's information.
• Memorandum of transfers : Reports are generated for the approval of the board of directors and these reports help the committee to take further decisions.
• Updating of Masters : Approvedtransfers by the committee are updated to the masters.
• Deed History : Auditing of the complete data is done here.
• Generate Reports: Generate Reports for various purposes like Control sheet, Sticker, Covering letter, Pincode wise distribution of share holders report, Status wise distribution, Top 'n' share holders of a given company, Stop transfer report , Address labels.

Responsibities : Design data model consisting of generic modules after careful analysis of functions, processes and activities performed by the organization. Design Database using Normalization Techniques and following Enterprise Rules. Create Database Procedures and Functions to enhance performance and improve Response time. Involved in documenting the project Share Transfer System covering the complete Software cycle by following the sound principles of Software Engineering. The Documentation covered Structured Analysis, E Diagrams, System Design, Central Repository, Data Dictionary, Source Code Document, Package Body Program Units, Performance and Tuning , User Manual

Environment :Developer / 2000 (Forms 4.5, Reports 2.5,Graphics 2.5 ), PL/SQL 2.1, SQL*Plus 3.1.

04/95 - 01/96 (Duration: 8 months) : *Название компании*

Description :Material Resources Management System. The stores management system is developed to monitor the proceedings of the stores. The system consists of three modules namely Master maintenance, Daily transactions, Reports. Master maintenance:

1. Performs the maintenance of master tables.
2. Takes care of insertion, updating and deletion of data of the master tables.
3. data capture is done through user friendly input screens with on-line verification facilities.
4. various checks and controls have been incorporated to ensure data
5. consistency and data security.

Daily transactions:

1. This module maintains the transaction forms. The system classifies the ites to be consumable or non-consumable depending on the items. This module generates important transactional reports which are described below.
2. stores issue voucher or tools issue voucher is generated depending on the item.
3. purchase order is raised whenever an item is below the reorder level.
4. goods received receipt is generated, once the goods are supplied by the supplier.
5. transactions are reflected into the corresponding masters.

Reports and Graphs:

1. This module generates flexible, statistical and decision-making reports and graphs which are described below. These give the detailed information of status of the stores.
2. decision making reports like vendor rating is generated.
3. daily, weekly, monthly reports showing the consumption of all the departments are generated.

Environment :Developer / 2000 ( Forms 4.5, Reports 2.5, Graphics 2.5 ), PL/SQL 2.1, SQL*Plus 3.1.

01/95 - 04/95 (3 months) : *Название компании*

Description :Production Planningand Control Package The system marks the division between the part of the production system based on forecasts and planning and the part based on the client orders. The package is developed so as to ensure flexibility in dealing with the customer order decoupling point.The system does anonymous procurement and produces to stock or production is oriented to fulfilling specific client orders based on four types of modules as given below :

• Make - To - Stock
• Assemble - To Order
• Make - To - Order
• Engineer - To - Order

Environment: Developer / 2000 ( Forms 4.5, Reports 2.5, Graphics 2.5 ), PL/SQL 2.1,SQL*Plus 3.1.

6/94 - 01/95(7 months) : *Название компании*

Description : Accounts Receivable System This system is used for adjustment of invoice amounts against the checks received from the clients and for generating invoice reports. Adjustment of invoice amounts includes linking and designing invoices against the checks and updating the credit balance in the databas. Specific duties included designing the database schema for the check and invoice details, designing and developing the check details screens, invoice screen and other related screens like editing the invoices for a check.

Environment : Oracle 6.0 , Forms 3.0 , Reports 2.0, PL/SQL , SQL Plus.

Education

• Graduate in Systems Management from Frontier (1 Year Program), 1995
• B.S (Mechanical Engineering), Nagpur University, May 1994.

References Contact :

• *Name*: xxx-xxx-xxxx (*Название компании* Project on Oracle Applications ).
• *Name*: xxx-xxx-xxxx (*Название компании*Project on Oracle Applications).
• *Name*: xxx-xxx-xxxx (*Название компании* project on Oracle Developer 2000).
• *Name*::xxx-xxx-xxxx (*Название компании* project on Oracle Developer 2000).

Reference Letters : Can provide them upon request.

TECHNICAL SKILLS:

• Programming Languages/Tools: PL/SQL, Developer/2000, SQL*Plus, XML, Microsoft
  BizTalk Framework, Visual Basic, Crystal Reports
• Software: Microsoft Office Suite
• Databases: Oracle 7-8i, Microsoft SQL Server 7-2000, Microsoft Access
• Operating Systems: Unix, Windows (NT/95-2000 Advanced Server)

PROFESSIONAL EXPERIENCE:

September 1999 √ *Название компании* Practice Lead

Managed structured team of 6-8 engineers responsible for projects centering on internal and external, application to application, data integration. Established company policies on integration related skillset inventories, and topical research. Negotiated and established strategic partner relationships for Xqsite, and it▓s clients. Initiated and maintained vendor and other third-party relationships. Responsible for project staffing, employee reviews, and resource scheduling.

Guided clients during integration implementation engagements. Educated and instructed client personnel on integration technologies, methodologies, and best practices. Led Microsoft BizTalk Framework implementation for startup filtration industry, supply-chain market hub. Objective of implementation to establish information flow between internal back-office applications, and then to external partners, and customers.

October 1998 √ November 1999 *Название компании* Contract Oracle Consultant

With leading service provider:

Solely responsible for the highly visible design, development, and implementation of an Oracle system to replace a critical mainframe based workers compensation and general liability system. Incorporated development of this system with an enterprise wide Oracle Financials installation. Led team of 4 client developers during implementation of intranet based time-entry system for remote location personnel. Performed remote training for facility managers. Acted as mentor to client interns during summer internship program. Performed as project lead on several other implementations, upgrades, and research projects.

October 1996 √ October 1998 *Название компании* Consultant

With Chicago branch of a major insurance carrier:

Assisted in development of Intranet based interface to a database metrics repository. Interface provided means to enter information into, and analyze accumulated data measuring the performance and physical makeup of division databases. Utilized patrol application to monitor servers and databases to insure compliance to defined standards. Created parameters within the application written with Patrol▓s PSL scripting language to expand on the inherent functionality of the packaged software. Delivered informal training sessions to clients on such topics as the Oracle Data Dictionary, HTML, and Forms 4.5 Trigger.
With Chicago-based communications manufacturer:

Implemented customer/factory order translation package, which seamlessly exploded conglomerate customer order items, triggered required factory manufacturing processes, and regrouped information for single customer invoicing. Wrote system to supplant outdated procedure of receiving incoming vendor supplied parts, distributing them to their proper areas, or flagging them for inspection if necessary, and tracking their movement within SAP inventory tracking software.

Created universal defect entry interface to standardize tracking of manufacturing defects throughout the division. Incorporated flexibility to allow entry of specific information based on manufacturing area. Designed and coded system to incorporate component substitutions, additions, and deletions as per administrator designations, business rules, or part shortages as units were prepared for allocation within SAP. Assisted in actualization of a major order repository for national and overseas divisions. Reengineered and wrote alternative process for back-end factory processes to replace fragmented system which consistently crashed, or produced erroneous part movement information. Designed in expandability factors to allow for future replacement of remaining parallel processes. Increased performance of processes by a factor of five. Created front and back end interfaces and processes for a new shipping system that automated process of designated shipping methods and carriers while tracking whole or partial order shipments. Played consistent role as coach to employees learning the Oracle system.

With nationwide television broadcasting network:

Continuous role designing, enhancing, and tuning company▓s asset management system. System purpose was to track inventory and scheduling, amortization of assets, broadcast history, change audits, and other station information.

EDUCATION:

May 1993 Northern Illinois University
Bachelor of Science DeKalb, IL
Major: Applied Computer Science
Minor: Business Administration

More than Nine Years of experience in design, development, testing and maintenance of business applications, financial and manufacturing systems using Oracle under UNIX Environments. Has Four and half years experience in installation, administration, customization of ORACLE Applications and well versed in data conversions and interfaces.

• Hardware:Sun Ultra SPARC, HCL Magnum, IBM PC Clones
• Software:ORACLE Ver. 8i, 8.0 & 7.X, Oracle Designer/2000, Developer/2000, Oracle Discoverer/2000, Forms 4.5/4.0/3.0/2.3, Reports 2.5, SQL*ReportWriter 2.0/1.1, SQL*Reports 1.1, SQL*Plus 8.0/3.x, Pro*C 1.1, PL/SQL 8/2.x, SQLMenu 5., SQL Navigator 3.0
• Languages:C, COBOL, PASCAL
• CASE TOOLS: Turbo Analyst 3.1, Relational Designer 2.0
• Oracle Applications: Oracle Applications 11i,11.0,10.7.0,Oracle Apps Client 10SC PROD 16, 10SC PROD 17,10.7 NCA, GL, AR, AP, OE, FA,Oracle Purchasing, WIP,Oracle Inventory,Oracle BOM, Oracle Project Accounting,AOL, Alerts, Zooms and Sys. Admin
• Operating Systems:UNIX, Windows NT, MS-DOS, MS-Windows 3.X / 95 / 98

Work Experience:

Oct 1999 - Present Oracle Applications Consultant at *Название компании*
Working in production Support Team for *Название компании*Financial Systems ******* facility (Oracle AP,GL).

Responsibilities include:

• Development and Customization of Vendors Import program including SQL*Loader and SQL*Scripts for Data Conversion.
• Development and Customization of EDI General Invoice Imprt program.
• Development & Customization of Oracle Reports 2.5 in AP module(Invoive monthly Activity Extract,vendors List,Duplicate vendors List, Cycle Time Reports,Invoice register etc.).
• Development of New Forms and Registering with AOL
• Submission of Reports and Report sets to AOL.
• Creation of Concurrent Programs,Executables and Value Sets.
• Creation of Descriptive Flexfields.
• Creation of several SQL*Scripts for delimeted output files and registering with Apps.
• Tech Support for End users & Training for End users.

Environment: Sun Solaris,UNIX, Windows 95/NT, Oracle 8i&7.3.4,Oracle Developer 2000,Oracle Applications 11i &10.7.0 SC161,Oracle Appls Client 10.7 NCA(Oracle AP,GL,AOL)

Jun 1999 - Sep 1999 Oracle Applications Consultant at *Название компании*
Working in Development and Customization of Custom Interfaces,Oracle Open Interfaces,Oracle Reports 2.5 ,racle Browser 2.0 reports(Oracle AR, AP,GL).

Responsibilities include:

• Development and Customization of Custom Interfaces for own business process and link to oracle open Interfaces for AP & AR modules.
• Creation of database Triggers on Interface tables in AP & AR modules .
• Development of procedures for Post process programs.
• Development & Customization of Oracle Reports 2.5 in AR module(Invoive, Commercial Invoice etc.).  Submission of Reports and Report sets to AOL.
•  Creation of Concurrent Programs,Executables and Value Sets.

Environment: Sun Solaris,UNIX, Windows 95/NT, Oracle 8.0,Oracle Developer 2000,Oracle Discoverer ver 3.1,Oracle Applications 11.0 (GL, AR, AP,AOL)

Nov 1998 - May 1999 Oracle Applications Consultant for *Название компании*
Working in Development of data Conversions and open Interfaces.Development and Customization of Oracle Reports 2.5 (Oracle OE,AR,INV and BOM).

Responsibilitie include:

• Development of Data Conversion from legacy system to Oracle Apps for Loading of Items and worked on items Open Interface.Writing of PL/SQL scripts for validating items and control files for loading into temp tables.
• Development of data Conversion from legacy sys to oracle Apps for Loading of BOM's and Importing of BOM's(Open interface).Creation of Control files for Sql*Loader and writing of PL/SQL scripts for validating Bill of materials.
• Development & Customization of Oracle Reports 2.5 in OE module(Sales Order Acknowledgement,Customer Quote,Pick Slip,Pack Slip,Milestone Billing Report,Margin Analysis Report).
• Development & Customization of Oracle Reports 2.5 in AR module(Invoive, Export Addendum).
• Submission of Reports and Report sets to AOL.
• Creation of Concurrent Programs,Executables and Value Sets.

• Training for end users.

Environment: Sun Solaris,UNIX, Window 95/NT,Oracle Developer 2000, Oracle Applications 10.7.0SC17 (OE,AR,INV,BOM,AOL)

Apr 1998 - Oct 1998 Oracle Applications Consultant for *Название компании*
Working in Development and Customization of Oracle Forms 4.5,Design and Development of Data Conversiosns,Development and Customization of Oracle Reports 2.5(Oracle Purchasing, Order Entry ,WIP and Oracle Project Accounting Modules). Work involved writing PL/SQL processes to provide enhancements to existing functionality provided by Oracle, as required by the client. A new process was created to update labor rates to actual rates automatically, which is used to calculate project cost. A view was created to give the client the ability to report on the updated information. Worked on development of Data conversion from legacy system to Oracle Apps(Transactions for benefits,over time and labor charges from Payroll system and running Trans Import in Project Accounting module). Also created views nd new reports in Project Accounting module to enable client the ability to report on each employee's utilization.

Responsibilities include:

• Design and Development of Data Coversions in PO module(Suppliers Conversion, Auto Source rules Conversion, Buy history Conversion, Quote History Conversion,Demand History Conversion).
• Development of Control files for loading data Using Sql*Loader,Development PL/SQL Scripts for Processing input data and validating with Apps tables.preparation of Documentation on Data Conversions.
• Development and Customization of Oracle Forms 4.5 in PO module(Buy History - Po Inquiry,Buy History Description & Quote History Description) and in OE module(Manual Shipper Info Screen).
• Registering of Forms with AOL and Menu Creation
• Development of Oracle Reports 2.5 in OE module(Manual Shipper Info,sales Order Ack, pick Slip, Pack slip, sales Quotation, Daily Shipment report, daily Outstanding Short Lead report,Bruggedaily Shipments Report) and in WIP module(Discrete Job pick list Report).
• Development of Oracle Reports 2.5(Auto Time Reports and Expense Reorts(Detail/Summary) of employees).  Submission of Reports and Concurrent Programs.
• Training for end users.

Environment: Sun Solaris,HP 9000, UNIX, Windows 95, Developer 2000,Oracle Applications 10.7.0SC16 (PO, OE,WIP,Oracle Project Accounting,AOL)

Sep 1997 - Mar 1998 Oracle Applications Consultant for *Название компании*
Working in Development and Customization of Oracle Zooms, alerts and Forms 2.3 in Oracle Purchasing and Payables (Packaging Business System Project).

Responsibilities include:

• Development and Customization of Oracle Zooms
• Development and Customization of Oracle Alerts
• Development and Customization of Oracle Forms 2.3
• Preparation of Functional Spes and Technical Specifications for Zooms and Alerts

Environment: HP 9000, UNIX, Windows 95, Oracle Applications 10.7 (PO, AP)

April 1997 - Jul 1997 Oracle Applications Consultant at *Название компании*
Working in Development and Customization of Oracle Forms 4.5 in Oracle Cooperative Applications Project.

Responsibilities included:

• Development and Customization of Oracle Forms 4.5
• Forms registering with AOL  Coding of Stored Procedures for making Orders official
• Development of Database triggers for various processes
• Writing Support Plan for Orders
• Development of domain tables forms
• Preparation of documents on Oracle Screens.

Environment: HP 9000, Windows NT/95, Oracle Applications 10.7, 10SC Prod 16.1 (OE, AR), Dev/2000 Dec

1996 - April 1997 Oracle Applications Consultant IBM GS Project at *Название компании*
Worked in Design and Developmet of FA interface in Fixed Assets module. Worked extensively in Oracle Reports 2.0.

Responsibilities included :

• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
• Creating control files for SQL*Loader
• Writing PL/SQL blocks for validation of data
• Preparation of Technical specs for conversion
• Development and Customization of Reports
• Development of Zooms and Oracle Alerts

Environment : Sun Ultra SPARC, Windows NT/95, Oracle Applications 10.6., Developer/2000

Sep 1996 - Nov 1996 *Название компании* Oracle Applications Consultant
Worked in Design and Development of GL, AP and AR interfaces. Worked extensively in Oracle Reports 2.0 & Forms 2.3.

Responsibilities included :

• Data conversion from flat file to intermediate tables using SQL*Loader, Data mapping
• Creating control files for SQL*Loader
• Writing PL/SQL blocks for validation of data
• Preparation of Technical specs for conversion
• Development and Customization of Reports
• Report submission with concurrent managers
• Customization of forms and registering with AOL

Environment: HP 9000, Windows NT/95, Oracle Applications 10.6 (GL,AP,AR), Developer/2000

May 1996 - Aug 1996 *Название компании* Consultant DBA - Oracle Applications
Completed installing Oracle Applications 10.6.1 and 10 SC Prod 13. Was responsible for maintenance and support for Oracle Applications. Extensively worked in Oracle Forms and Reports.

Responsibilities included :

• Assigning table spaces, index spaces and other installation/configuration parameters. Well versed in all aspects of installation of Oracle Applications include identifying installation bugs, using patches for bugs, etc.
• Regular maintenance, trouble shooting and user support
• Development/Customization of screns using Forms 4.5 / 2.3 and registering them with AOL.
• Design, Development, Customization of reports using Reports 2.0
• Worked in implementation of GL, AR, AP, FA, OE, Payroll and Personnel modules of Oracle Financials

Environment: Sun Ultra SPARC, Windows NT/95, Oracle Applications 10.6.1 10SC Prod 13, Developer/2000

March '95 - March '96 *Название компании* Systems Analyst/DBA Worked in a 20 member team in Design,
Development and testing of integrated system having five modules : Payroll, Personnel, Production Planning and Control, Purchase Management System, Marketing Information System and Financial Information System.

Responsibilities included :

• Low Level Design and Development
• Preparation of Functional and Design Specifications
• Development of Forms 4.5 and Reports 2.5
• Implementation, Maintenance and DBA Activities

Environment: SCO Unix, Oracle 7.1, Forms 4.5, Reports 2.5

Sep '94 - Mar 95 *Название компании* Programmer/Analyst
The Personnel and Payroll System includes the following modules : Payroll, Master File Maintenance, Transactions and Reports.
The responsibilities included design, development and maintenance of the system in a two-member team.
Environment: UNIX, Oracle 6.0, Report Writer 2.0/1.1, Pro*C.

Jul '93 - Aug '94 *Название компании* Programmer/Analyst
The Marketing Management System includes the following modules : Master file maintenance, Transactions, Reports and Maintenance System.
The responsibilities included design, development and maintenance of the system in a two-member team.
Environment: UNIX, Oracle 6.0, Forms 3.0, Report Writer 1.1, Pro*C.

Jun '92 - Jun '93 *Название компании* Programmer/Analyst The Purchase Management System includes the following modules : Master File Maintenance, Transactions and Reports.
The responsibilities include design, development and maintenance of the syste in a two-member team.
Environment: UNIX, Oracle 6.0, Forms 3.0, Report Writer 1.1, Pro*C.

Feb '91 - May '92 *Название компании* Programmer/Analyst
The production planning and control system includes the following modules : Planning, Production, Quality Control and Master Maintenance.
Environment: UNIX, Oracle 5.1, Forms 2.3, Pro*C

Education

: B.S. in Computer Science and Engineering

: Oracle 7.X DBA Tata UniSys Ltd., India Oracle Applications, India

Summary of qualifications
==========================
Proven technical and consulting experience specializing in Oracle packaged and custom applications. Expert level skills in Oracle based complete product-cycle web development, interfacing and migrating legacy systems and performance analysis of Oracle transactions. Oracle Certified Application Developer Professional.

Major accomplishments include applications integration projects at Fortune 500 companies such as Kodak, Digital, Quantum, Compaq and TriValley. Volunteering a website dedicated to helping Oracle DBA's and Developers : http://www.SQLsniffer.com

Ideal Position: Utilizing my current skills with Oracle JSP, Oracle Applications Server, Java, JDBC, SQLJ, EJB, Oracle Jdeveloper, PL/SQL, Oracle8i and Java InstallShield. I enjoy development and have extensive Oracle resources in-house.

Professional experience
=======================
1995 - Present Technical Consultant *Название компании*

Oracle applications consulting assignments for a variety of Bay Area clients
including :

• Tri-Valley Growers, an 800M dollar cooperative. Tri-Valley purchased a new suite of Oracle package called Oracle CPG, comprising Oracle Manufacturing, Oracle Financials, and Manugistics. My responsibility was two-fold : interface and migrate legacy data to Oracle applications, and hotlink Oracle applications to feed other applications running on diverse platforms and databases such as Sybase. I recommended the use of Oracle Interface products. My role was both hands-on development and orienting their IT department to carry out future integration works. Oracle running on Unix platform.
• Design project at Metropolitan Transportation Commission : Design a custom application to control budgetary allocations. Oracle running on NT platform.
• ABP, Las Vegas: An Oracle CPG integration project : Licensed and supported interface and report solutions for Oracle Process manufacturing implementation.
• FutureVision : A start-up company developing an Online Gaming based on Oracle and Java technologies. Helped design the Oracle and Java foundation. Involved use of Java, Javascript and HTML.
• World Yellow Pages : Helped web performance review for this start-up.
• Quantum Corp, a world leader in computer storage media. Developed and supported a Global Sales Forecasting System. The system was installed at over 30 global sites and co-ordinated using Oracle replication technology.
• Volunteering a website dedicated to helping Oracle DBA's and Developers : http://www.SQLsniffer.com. Serving Oracle-Java technologies.

1994 - 1995 *Название компании* Senior Consultant

Responsible for the integration of Oracle manufacturing and financial applications at Compaq. Direct Plus Order Entry and Financials Application : Setup, Customization and Maintenance of Oracle enterprise financials application.

1992 - 1994 *Название компании* Consultant

Digital: Bell South's Intelligent Messaging Services System : Management, Design and development of very-large Oracle database application.

Kodak: Intra-company Communication Systems Services : Design and Development of Oracle based system including database tuning and forms

Education
Masters in Technology
Oracle Certified Application Developer

Memberships
International Oracle Users Group
Active member at Oracle Forums

Others
Permanent Resident of US

Over 8 years of experience as a Database Administration and Analyst/ Programmer, primarily in the ORACLE environment. Very strong in the design and tuning of Oracle database, Configuration of Oracle Server 8/8i, Oracle Application 10.7/11.0, Oracle Application server for production, test and development environment. Has extensive experience with:

EDUCATION

TECHNICAL ENVIRONMENT

HARDWARE: HP-9000, IBM RS 6000, Compaq Alpha, Sun Enterprise 420R / 220R Server

O/S: Sun Solaris, AIX, HP-UX, Digital Unix, Windows NT, Sco-Unix, Digital Alpha Openvms

SOFTWARE: Oracle Server, Oracle Application Server, WebDB, Oracle Developer 6i, Oracle Designer, Oracle Developer, Oracle Enterprise Manager, Dbartisan, Erwin, SqlBacktrack, Appworx, Autosys, Radley Caras

LANGUAGE: PL/SQL, Pro*C, C++, JAVA, Perl, HTML

APPLICATIONS: Oracle Financial, Manufacturing

MAJOR ASSIGNMENTS

Oct 2000 - Date
As a Database Administrator with *Название компании*.
I am involved in providing support for Oracle Application and Database for Production environment as well as Test and Development environent.
I am involved in Implementation Change in Production, Installation, upgrade and maintenance of Oracle Server and Oracle Application software.
I am involved in Database tuning Including Application Code (SQL Tuning), Making Strategy for Backup and Recovery of Database. Upgrade of Oracle Database from Oracle 7.3 to Oracle 8i on Digital Unix Server.
I am coordinating with Development and test team to implement change in Production environment. Setup standard for new environment and making guidelines for Configuration of environment for Oracle Application and Oracle Server.
Environment: Digital Unix, Oracle Server 8i, Oracle Application 11.0.3, Oracle Developer 6I, and Oracle Enterprise Manager 2.1. PL-SQL, Appworx, Autosys, Radley CARaS 6.3.

June 2000 - Sep 2000
As a Database Administrator with *Название компании*.
I was involved in Implementation of Oracle database in Production Environment and Database tuning Including Application Code (SQL Code Tuning). Making Stratey for Backup and Recovery of Database. Upgrade of Oracle Database from Oracle 8 to Oracle 8i on HP 9000 Server. Was coordinating with Application Support team to implement change in Production environment. Setup standard for new environment and making guidelines for Database Configuration and installation of Oracle Server 8i and Oracle Developer 6i.
Environment: HP - 9000, Oracle Server 8i, Oracle Developer 6i Oracle Enterprise Manager 2.1. PL-SQL

February 1999 - May 2000
As a Database Administrator with technology services group of *Название компании*.
I was responsible to provide 24*7 Hours support for Oracle Application and database running on production environment as well as support for test and development environment. Was responsible to co-ordinate with other DBA and team member for planing and scheduling activities related with Oracle database. Was involved in setup standard and making guidelines for database configuration and installation of Oracle server and Oracle sftware.
I was responsible to provide support for Oracle Application as Application DBA.I was responsible for implementation of changes in production database, tuning of oracle database, recovery of database as well as making strategy for backup of production database.
I was involved in migration of Oracle database from Digital VAX environment to Y2K compliant environment.
I was involved in upgrade of oracle database with Oracle Server 8i, Migration of Oracle 7 database to Oracle 8i database.
Environment: Compaq Alpha, HP-9000, Oracle Server 8i, Sun Solaris 2.7 Oracle Enterprise Manager 2.0, Oracle Application 10.7

January 1998 - January 1999
As a Database Administrator with Database Computing Group of *Название компании*.
I was involved in Physical database design of oracle database, Datawarehouse, Oracle Server Installation, Configuration and tuning of oracle database.
I was Involved in design and setup of Very Large Oracle database, Partition of table and index, as well as making strategy or data transfer from OLTP database to Datawarehouse. Population of Datamarts. Was involved in implementation of database in production, Change control, Making strategy for Replication of data in other location, Parallel server configuration, Replication, Setup and Configuration of Web Application server. Writing scripts for Database administration, for Sql*Loader, Backup, Import, export, Stored procedures, functions and triggers. Migration of Oracle Database from Oracle 7.0 to Oracle 8.0.
I was involved in providing 24*7 Hour pager support to Production Oracle Database.
Environment: Sun Ultra 6000, Enterprise 10000, IBM RS-6000, HP-9000, Oracle Server 8, Oracle Application server, Oracle Developer Server, Oracle Enterprise Manager, Solaris, AIX, HP-UX, NT, Designer 2000, PL/SQL, Pro*C

January 1997 - December 1997
As a Database Administrator with database group of *Название компании*,
I was involved in database design for integration of databse related with fidelity subject area. Was involved in project to integrate all fidelity subject areas into one database for centralized information and setup of a data warehouse. Worked on parallel server configuration and distributed database. Was responsible for implementation of database in production, Change Control. Was also involved in database admin activities like writing scripts for database administration, backup strategy for the database, installation of OracleSoftware, Configuration of Database and tuning parameters for better performance of the Oracle database. Writing Procedure, function and trigger, writing scripts for Oracle database population (such as Loader, backup, import, export, etc.).
Environment: SUN ULTRA 6000/4000/3000, Solaris, Oracle Server 7.3 Designer 2000, PL/SQL, Pro*C

May 1995 - December 1996
As a Database Administrator with Oracle Support Group of *Название компании*,
I was involved in Oracledatabase support for various clients. I was involved in maintenance of Pro*C Program, Physical Database design, Installation of Oracle software, Configuration of Database, performance tuning of Oracle database, writing Procedure, function and trigger, writing scripts for Oracle database administration (such as Loader, backup, import, export, etc.).
Environment: Oracle Server 7, SQL*Forms, Pro*C

July 1992- April 1995 As an Analyst/Programmer with *Название компании*.
I worked for various software development projects mostly on Oracle environment with following clients.
I was involved in Design and Development of software, Program testing and debugging, Implementation of Software, Maintenance of Software.

*Название компании 1*., *Название компании 2*, *Название компании 3*, *Название компании 4*
Environment: Oracle Server 6, Pro*C, Sql*Reportwritter, Sql*Forms, PL-SQL.

Experience

*Название компании*
Senior Software Development Analyst ...June 1997 - present
Responsible for design, development, coding, and testing of financial applications supporting users in the Financial Department

• Application Object Library, General ledger, Accounts Receivable, Accounts Payable, Fixed Assets, and Purchasing
• Utilizes the following applications and skills:
  • PL/SQL
  • SQL / SQL*Plus
  • Application Object Library
  • Report Writer
  • UNIX Scripts
  • C
  • Oracle Developer Reports
  • Oracle Developer Forms
  • Oracle Designer
  • Relational Database concepts
  • Oracle Financial Analyzer
  • Express Programming Language
• Perform analysis, design, coding, testing, and maintenance of applications to support user requirements
• Review and analyze user needs and develop and implement programs to meet department requirements
• Provide application support through technical and consulting services for new business initiatives

*Название компании*
3C052 Comm Systems Computer Programming Specialist ...June 1993 - June 1997

• Installed Relational Database end user software for Oracle 7.0 on client PCs
• Used oracle tools, SQL*PLUS, and SQL*DBA to alter all aspects of an operational database
• Analyzed user requirements for feasibility, interaction with other systems, and resource requirements
• Developed Reports for database users using Oracle Developer 2000 Reports 2.5
• Monitored user accounts to ensure users had correct access to required data
• Developed graphical user interface applications in Oracle Developer 2000 Forms 4.5
• Monitored all software enhancements and modifications
• Validated and tested all contractor support software deliveries
• Conducts software testing and customer product acceptance, training, and satisfaction feedback sessions
• Assisted database administrator, trouble shooting and resolving software deficiencies in applications already in use on operational database systems
  Responded to on-call requests for immediate repair of on-line database software
• Trained new applications developers and database administrators in the use of various tools

Education

• Bachelors of Science in Management of Information Systems with a background in:
  • C / C++
  • Java
  • Windows 2000 Administration
  • Visual Basic
  • UNIX Administration
• Military Specialty training in the 3C032 A Communications System Programmer career field
• Oracle Computer Based Training (CBT) tools completed:
  • Introduction to Oracle
  • SQL*Plus
  • PL/SQL
  • Oracle Developer 2000 Reports 2.5
  • Oracle Developer 2000 Forms 4.5
  • Applications Tuning

SUMMARY

Five (5) Years of IT full life-cycle development experience working as Oracle Database Administrator (Oracle DBA). Involved in Oracle Server Installations (8.1.6/8.1.5-8i/8.0.5/8.0.4/7.3.4.3), Upgrades, Capacity Planning, Performance Tuning (Using Scripts), Backup & Recovery, Security Administration, Development, Data Modeling, Troubleshooting and Coding for optimized functioning. Extensive experience using PL/SQL (8.x & 2.x) Programming, Developer/2000(Forms (4.5), Forms 2.3, Reports (2.5)), Designer/2000, Discoverer/2000, ERWIN, OEM and other Oracle Tools

Extensive experience as Oracle Database Administration on Development and Production Systems Administration, Analysis, Design and Implementation of many Business Applications in Oracle on Different Platforms Experience working with Very Large databases of size more than 100GB Database Installation, Upgradation/migration and Configuration Experience as Oracle Applications DBA & SAP (All Modules) Supporting Production Systems on 24X7. Experience with .COM Companies and Oracle Web Applications. Excellent communication and interpersonal skills

TOOLS and SKILLS

Hardware IBM 704 Server Pentium Pro 200 MHz, IBM PC Nodes, HP9000, RS6000, SUN SPARC, Digital Alpha Server 2100 A, COMPAQ PROLIANT

OS Windows-95, Windows NT 4.0, SCO UNIX Open server 5.0, DEC UNIX 3.2G, HP-UX 10.2, AIX, SUN SOLARIS 2.x

Data Base Oracle 6.x/Oracle7.x/Oracle 8.0.x, Oracle 8i (8.1.5) Client Server Tools Developer 2000 (Forms (4.5), Reports (2.5)), Designer/2000, Discoverer/2000 (Oracle Browser 2.0), SQL* Forms (2.3), Delphi 5.0

DBA Tools Oracle Enterprise Manager (OEM), Humming Bird, PC Anywhere, SQL-TOAD, SQL-Navigator, SQL-Station, DB-Artisian, SQL*PRO, SQL* Loader, TKPROF, UTLBSTAT/UTLESTAT, Export/Import, SharePlex (Replication & Live Re-Org Tool), E Loader

Web Tools WebDB, Java, HTML, XML, BugsEye 2.6.0.26

Version Control Visual Source Safe, PVCS Management Tools

Data Modeling ERWIN/ERX 3.5.2, ER Studio, Visio Standard 5.0, Designer 2000 and Other 3rd Party Tools

Languages/Products PL/SQL 2.x, Developer 2000 (Forms (4.5/3.0), Reports (2.5/1.1)), Delphi 3.0, SQL*DBA, SQL*PLUS, SQL*NET, SQL* Menu 5.0, PASCAL, FORTRAN, COBOL, UNIX Shell Programming, Cron Processes, Shell Scripting, Csh and Ksh

ERP Oracle Applications (11.0.2/10.7/10.6 & 10.7 NCA), Oracle Applications 10 Smart Client (10SC), Client Production (16.0/16.1/15) SAP 3.1 h, 4.0 b (FICO, MM, SD, PP, HR and BASIS)

WORK EXPERIENCE

04/00 - Present *Название компании*
(Oracle DBA/Data Architect (Production, Development & Testing)

As a Lead DBA Maintaining around 20 Oracle Servers (OLTP, DSS & Hybrid) in different locations on different platforms Like UNIX and Windows NT/2000. The Database Size ranges from 10GB to 300GB. Some of the Servers has Oracle Applications 10.7, SAP 4.0b, Web DB, JAVA, EJB, JRUN, BugsEye, InterMedia Text and Context Servers etc