Oracle Sql

Title:Cryptographic Technician / Technical Control Supervisor

abpsj4@r.postjobfree.com

Document

Source below

NAME: Keerat Singh

ADDRESS: **** ****** *****

CITY: Carmel

STATE/PROVINCE: IN

ZIP/POSTAL CODE: 46032

COUNTRY: USA

EMAIL: abpsj4@r.postjobfree.com

PHONE: 317-***-****

CANDIDATE ID: 109922

CITIZENSHIP: US

Citizen

EDUCATION: Master Degree

EXPERIENCE: 8

WILL RELOCATE: Yes

RELOCATION INFO: Any State or City in US and CANADA.

JOB WANTED: Contract

RATE NEEDED: Open

HOMEPAGE:

COMMENTS: Mr. Singh has over 7+ years experience in information technology (Six years in

US). Mr. Singh roles have included but are not limited to batch and on-line programming,

systems analysis, systems programming, technical consulting, technical requirement

definition, technical documentation and database analysis/administration primarily on IBM

Mainframe and PC platform environments. His hardware diversity is complemented with

extensive systems programming/internals expertise. He has performed these functions alone

and part of a team.

Versatile and flexible; enjoy executing difficult technical work under time pressures.

Positively accepted "unsolvable" technical challenges. Have worked consistently, reliable

HOTSKILLS: Oracle DB 7.x =7+ yrs, PL/SQL =7+ yrs, UNIX =7+ yrs, TOAD =3+ yrs, SQL

Loader =7+ yrs, SQL Navigator =2+ yrs, Oracle 8i =1+ yrs, PVCS =3+ yrs,Oracle

Application 10.7/11-i=3+years

ESUME

EDUCATION:

Degree

in Master of Business Administration from University Of Punjab,

Jullundhar, India.

Postgraduate Diploma

in Computer Applications from Priyadarshini Institute of

Computer Aided Knowledge,

New Delhi, India.

Degree

in Bachelor of Computer Applications from University Of Delhi, New Delhi,

India.

Degree in Development of Client Server Applications using Oracle 7.3, Forms 4.5

and Reports

2.3 from University of California at Los Angeles, California.

Certificate in Extending Oracle Applications from Oracle Education, Houston, TX.

Certificate in Oracle Application Manufacturing/Functional Foundation from

Oracle Education from Los Angeles, California.

Certificate in Advance Unix from IUPUI, Indianapolis, Indiana.

Certificate in Intro to Database Administration from IUPUI, Indianapolis,

Indiana.

Certificate in Advanced PL/SQL from IUPUI, Indianapolis, Indiana.

Certificate in Advance Datastage (ETL Tool) from Ardent Software (Informix),

California.

BUSINESS APPLICATIONS:

Oracle Application 10.7 Character base

Oracle Application 10.7 Smart Client (SC)

Oracle Application 11.3

Oracle Application 11-i

HARDWARE:

IBM 30XX IBM PC Compatibles

Internal Modems XEROX and AFP Printers

External Modems CD-ROM

PC Pentiums HP-UNIX

Solaris

SOFTWARE:

SQL DOS

MS ACCESS Windows NT 4.0

WINDOWS/ WIN 95/98 UNIX

Oracle8-I, 8.0, 7.3, 7.x DbaseIV

Forms 4.x/6.0/6-i Reports 2.x/6.0/6-i

MS Office Lotus 123

SQL Loader vi Editor

MS Outlook WINDOWS 2000

Vertex

LANGUAGES:

BASIC Pascal

COBOL FORTRAN

SQL PL/SQL

BUSINESS & APPLICATION EXPERIENCE:

ENGAGEMENT

: Aug01 to PresentTechnical Leader-Semi Apps. DBA:

CLIENT: AAMES Home Loans. Los Angeles, California.

Performed as Technical Leader/Semi Application DBA on this 11i upgrade project.

Installed 11-I software on WINDOWS 2000 server and worked with Oracle

Corporation to resolve installation issues. Have performed tables analysis for

11i structure versus 10.7(NCA). Wrote 11-i analysiss spreadsheets and reports

for users for future references. Wrote custom menus and reports in Oracle

Application modules including Account Payables, Purchasing, GL, Account

Receivables, I-Procurement, Fixed Assets and Projects. Setup responsibilities,

users, custom menus, fiscal periods and printers on new 11i install mirroring

to old 10.7 system. Wrote complete upgrade plan according to the requirements.

Wrote test plans, design documents & business requirements, testing the

developed solutions. Performed troubleshooting Oracle technical issues

including operating system related problems, system analysis, and data

conversions.

Significant Accomplishment: Successful install of 11-I software on Windows 2000

server. Wrote complete upgrade plan according to business requirements.

Technical Environment: Oracle Database 7.3/8i, Oracle Applications

10.7(NCA)/11-i, Reports 6-i, SQL, PL/SQL, TOAD & MS WORD/EXCEL/POWER POINT.

ENGAGEMENT

: Mar01 to Aug'01Sr. System Analyst :

CLIENT: INTERLOGIX Inc

. (Casi-Rusco) Boca Raton, FL.

Development technical team member on this 11i upgrade project. Have performed

tables analysis for 11i structure versus 10.7(SC). Wrote 11-i analysiss

spreadsheets and reports for users for future references. Performed upgraded

freight charges analysis and order reconciliation for BSAs (Business System

Analyst/Functional). Wrote Custom Forms and Reports in Developer 2000 Suite 6i.

Migrated the Reports/Forms to PVCS and Development/Test instances. Wrote

customizations and assisted in upgrading Oracle Application modules including

Order Management, Bill of Materials, Payables, Purchasing, GL, WIP, Receivables

and Inventory using PL/SQL. Job involved lot of user interaction. Have worked

with local and remote users. Gathered information from users and wrote

functional specification as well technical specifications. Wrote test plans,

design documents & business requirements, testing the developed solutions.

Performed troubleshooting Oracle technical issues including operating system

related problems, doing data analysis, system analysis, and data conversions.

Also performed the Unit and QA testing.

Significant Accomplishment: Extensive creation and writing of Reports and Forms

in Suite 6-i.

Technical Environment: Oracle Database 7.3/8i, Oracle Applications 10.7/11-i,

Forms/Reports 6-i, SQL, PL/SQL, UNIX/vi editor, PVCS, TOAD & MS WORD.

ENGAGEMENT:

Dec00

to Mar01Sr. System Analyst:

CLIENT: RETEK, Cincinnati, Ohio.

Wrote Custom reports and forms in Developer 2000 suite 6.0. Made lots of

enhancement in existing forms and reports. Migrate the reports/forms to PVCS

and Development/Test/Prod. Worked with Oracle Application modules including

WIP, Order Entry, Bill of Materials, Payables, Purchasing, Receivables and

Inventory. Wrote test plans, design documents, system requirements. Unit and QA

testing. User/Customers training and user support. Job involved in plenty of

user interaction.

Significant Accomplishment: Was substantial in writing reports in Suite 6.0.

Technical Environment: Oracle Database 7.3/8i, Oracle Applications 11.03,

Forms/Reports 6.0, SQL, PL/SQL, UNIX/vi editor, PVCS, TOAD, MS WORD &

SQL*Loader

ENGAGEMENT

: Oct00 to Dec00Sr. System Analyst Manu/Shipping unit:

CLIENT: GEMPLUS, Montgomery Ville, PA.

Wrote Custom Interfaces and Order Import Interface. Develop the custom reports.

Migrate the reports to Development/Test/Prod. Have done the analysis work

between 10.7 to 11.0 upgrades Worked with Oracle Application modules including

WIP, Order Entry, Bill of Materials, Payables, Purchasing, Receivables and

Inventory. Wrote test plans, design documents, system requirements. Data

Modeling, Database / Schema design of CUSTOM application databases. Unit and

integrated testing. User/Customers training and user support. Job involved in

plenty of user interaction.

Significant Accomplishment: Was substantial in writing interfaces data migration

from 10.7 to V11 in Oracle environment.

Technical Environment: Oracle Database 7.3/8.0, Oracle Applications

10.7Character Base/11.03, Reports 2.3, SQL, PL/SQL, UNIX, PVCS, SQL Navigator,

TOAD, MS WORD & SQL*Loader.

ENGAGEMENT

: July00 to Sep00Sr. System Analyst Manufacturer/Shipping unit:

CLIENT: Alcoa Fujikura Ltd

., Greenville, South Carolina.

Wrote Interfaces, Functional and Technical Specifications for different

divisions. Develop the hand full of forms and reports. Migrate the

forms/reports to Development/Test/Prod. Have done the analysis work between

10.7 to 11.0 upgrades and defined hand full of DFFs in 11.0 version after

comparing in 10.7. Worked with Oracle Application modules including WIP, Order

Entry, Bill of Materials, Receivables and Inventory. Wrote test plans, design

documents, system requirements. Data Modeling, Database / Schema design of

CUSTOM application databases. Unit and integrated testing. User/Customers

training and user support. Job involved in plenty of user interaction.

Significant Accomplishment: Was substantial in writing interfaces data transfer

from sub-units to cooperate in Oracle environment.

Technical Environment: Oracle Database 7.3/8.0, Oracle Applications

10.7SC/11.0, Reports 2.3, SQL, PL/SQL, UNIX, SQL Navigator, TOAD, MS WORD &

SQL*Loader.

ENGAGEMENT:

Nov99

to June00/Data Modeler/ Sr. System Analyst / Production

Support for Global Data Availability Group:

CLIENT: Eli Lilly & Company, Indianapolis, Indiana.

Involved in Initial Business Needs and requirements. Writing Stored Procedures,

Functions and Triggers using PL / SQL and SQL*Plus to add functionality and

data Lots of testing on custom objects, triggers and monitoring incoming data.

Wrote test plans, design documents, system requirements. Unit and integrated

testing. User/Customers training and user support. Job involved in plenty of

user interaction. Developed PL/SQL and Unix Shell Batch jobs for initial

Conversion and Weekly Updates. Data Modeling, Database / Schema design of

application database, Space requirements. Movements within the database.

Loading database from 2 Dimensional files using SQL*Loader. Also Consulting

with Customer and Users to understand Business issues. Development and

Documenting the Assumptions used in decision-making process of the project.

Significant Accomplishment: Was substantial in Production Support and monitoring

batch jobs in Oracle environment.

Technical Environment: Oracle Database 8.0, SQL, PL/SQL, UNIX, Shell and CRON

Scripting TOAD, SQL Navigator, MS WORD & SQL*Loader.

ENGAGEMENT:

Nov98

to Oct99Senior System Analyst for Manufacturer/Shipping

units:

CLIENT: Herff Jones Inc

. Indianapolis, Indiana.

Have done the life cycle of Implementation (including conversion, development

and knowledge transfer). Wrote Interfaces, Functional and Technical

Specifications. Develop the forms and reports. Worked with Oracle Application

modules including WIP, Order Entry, Bill of Materials, Receivables, Inventory

and Vertex software. Wrote SALESREPS, PRICE-LIST, CUTOMER UPDATE, BILLTOSHIPTO,

SUPPLIARS, COA VALUES, COA SEGMENT AND CUSTOMER Interfaces. Wrote test plans,

design documents, system requirements. Data Modeling, Database / Schema design

of CUSTOM application databases. Unit and integrated testing. User/Customers

training and user support. Job involved in plenty of user interaction.

Significant Accomplishment: Was substantial in converting data from Mainframe to

Oracle environment.

Technical Environment: Oracle Database 7.3, Oracle Applications 10.7, Reports

2.3, SQL, PL/SQL, UNIX, SQL Navigator, TOAD, MS WORD & SQL*Loader.

ENGAGEMENT

: Jan98 to Oct98System Analyst / Developer

for Marketing &

Consulting Company:

COMPUTER RESOLUTIONS INC, IT CONSULTING COMPANY,

LOS ANGELES, CALIFORNIA.

Analyst / Developer

for Marketing & Consulting Company: To remain competitive in

the delivery of Consulting and Marketing Services in CA and AZ, this group

needed highly integrated Management Information System (MIS). As Analyst /

Developer, Designed and developed several forms, Wrote custom Reports. Created

enhancements to existing Screens and Stored procedures to achieve new

functionality. Helped in documenting the enhancements, Designing and

Implementing the server side Business Rules using PL/SQL packages, stored

procedures and Triggers.

Significant Accomplishment: Was substantial in Converting data from Mainframe to

Oracle environment.

Technical Environment: Oracle 7.3, Forms 4.5, Reports 2.3, SQL, PL/SQL, UNIX,

and MS Outlook.

ENGAGEMENT:

May96

to Dec97Programmer / Analyst for Hunter Douglas:

CLIENT: HUNTER DOUGLAS INC. HOUSEHOLD PRODUCTS NATIONAL LEVEL, LOS ANGELES, CA.

In On Line Order Entry System the application keeps track of various orders

pertaining to a list of approved customers for the products manufactured.

Orders are entered online (CTI was used), checking with inventory, work in

progress and production schedule. Invoices are raised against the orders and

sent to the customer along with the shipment once the goods are shipped. This

application used to interface with already existing Inventory application,

which was developed in Oracle Applications (Using Financials modules). Was

Involved in Designing Numerous Forms, Reports, Writing Stored Procedures,

Functions and Triggers using PL / SQL and SQL*Plus to add functionality and

data movements within the database. Loading database from 2 Dimensional files

using SQL*Loader. Also Consulting with Customer and Users to understand

Business

Issues. Development and Documenting the Assumptions used in decision-making

process of the project.

Significant Accomplishment: System improved overall performance and users Order

Entry Time was reduced significantly due to added functionality at Front and

Back end.

Technical Environment: Oracle 7.3, Forms 4.5, Reports 2.3, SQL, PL / SQL, UNIX,

SQL*Loader.

ENGAGEMENT

: Jan96 to May96System Analyst

CLIENT: NORTHRIDGE CELLULAR MANUFACTURING AND SALES, LOS ANGELES, CA.

System Analyst

at Inventory Management Control System for a cellular

manufacturing and Marketing Company. This system was developed to calculate the

materials required as an extension to the Inventory Management module. The

software consists of BOM, Material Planning, Shop floor data collection and

re-order point. Wrote user manuals, Design documents and PL / SQL stored

procedures. Design the Forms for keying in the Product details / Product

movements. Created Menus.

Significant Accomplishment: The front end improved productivity for users

significantly.

Technical Environment: Screens were created using Forms 4.5 to enter Product

information. Database used was Oracle 7.3 with PL / SQL mounted on UNIX

(Solaris).

ENGAGEMENT

: Feb95 to Dec95Software EngineerINFOSYS CORP, IT CONSULTING COMPANY, LOS ANGELES, CA.

For Inventory Control System for leading Computer and Consumer Electronics

Manufacturing Group. This system was developed to monitor inventory levels and

material usage at various stages. The software includes the definition of

various warehouses, plants, stock locations and Item definitions etc. PL / SQL

and SQL*Plus were used to develop stored procedures and triggers. Forms were

developed to insert,

update, delete and query the database. Was involved in Writing PL / SQL stored

procedures and Functions, Creation of Forms and Writing Reports.

Significant Accomplishment: Greater Security and Control over Database was

achieved with added stored Procedures and Functions.

Technical Environment: PL / SQL and SQL*Plus were used to develop stored

procedures and functions. Oracle 7.x, Forms 4.0 and UNIX.

ENGAGEMENT

: Mar94 to Jan95Developer/ProgrammerANZ Grindleys International Bank

(India).

Developer/Programmer at Banking Software for ANZ Grindlays bank. The application

was used to store the particulars of account holders, carry out daily

transactions, generate monthly statements and statements at the end of fiscal

year. Was involved in the design and development of modules for new accounts

and General Accounts Information.

Significant Accomplishment: Was involved in Interacting with users and getting

their requirements. Bridged communication gap between Users and technical team

making it easy for Users and Technical people both.

Technical Environment: Oracle 7.0, Forms 4.0, Reports 2.0, PL / SQL, UNIX,

MSOffice, Lotus 123.

Contact this candidate