Consultant Development Sql Server Oracle .Net

Harry Idachi (***)

***-**** *******@*****.***

Synopsis:

A technologist and consultant specialized in web and windows application

development using ASP.NET, VB.NET, C#.NET, ASP, VB, VBScript, AJAX,

JavaScript, Oracle, SQL Server, Access, IIS, DHTML, HTML, Web Services,

XML, DevExpress, COM, SOAP, PL/SQL, and T-SQL on Windows and UNIX.

Summary of Computer Skills:

Languages: VB.NET, C#.NET, VB, HTML, C++, Assembler, PL/1, COBOL

Databases: Oracle 6 - 11g, SQL Server 6.5 - 2005, Sybase, DB2, MS-

Access, IMS, DMSII

DB Related: PL/SQL, T-SQL, ISQL, PL/SQL, Enterprise Manager, TOAD, UML

Web Server: IIS Administration

Web Development: ASP.NET, .NET Framework 1.1 - 4.0, ASP, HTML, DHTML,

AJAX, CSS, MVC

Development Tool: Visual Studio 2010, 2008, 2005, 2003, Visual InterDev

Scripting: VBScript, JavaScript, UNIX Shell Scripts, GML Scripts

OS: Windows, Windows Server 200x, UNIX (HP-UX, Sun, AIX), MVS, OS/2

Configuration Tool: Visual SourceSafe, SVN

Software Design: Object Oriented Programming, Agile, Waterfall

Data Access: ADO.NET, ADO, DAO, RDO

TP Monitor: CICS/ESA/MVS/VSE, CICS/6000, IMS DC

Hardware: IBM PC, HP-9000, Sun Micro, IBM RS/6000, IBM ES/9000, 30xx,

40xx, B6800

Other Skills: Sharepoint, DevExpress, Infragistics, Photoshop, XML, RSS,

Business Objects Crystal Reports, REXX, CLIST, vi Editor,

eXceed, WinRunner, DB2-Expert, MQM, ODBC, COM, SNA LU6.2,

TCP/IP, CSP, Telon, JCL, WFL

Education:

B.S. in Mathematics and Minor in Accounting, Jacksonville State University,

Jacksonville, Ala.

Completed UC Berkeley Extension courses in Oracle, Using UNIX OS, OO

Programming using C++, C Language Programming, PL/1, Assembler, OS

Concepts, etc. (GPA - 4.0+).

Experience:

Novartis / Chiron, Emeryville, CA

________ 4/98 - Present

As a Consultant / Employee, Responsible for design, development and

implementation of the many large-scale intranet applications for

Informatics Groups for Novartis Corp. These intranet applications include

NETT (Novartis Early Target Tracking) websites for various Disease Areas,

CLM (Contract Lifecycle Management system), and genomic applications such

as SVD (shRNA Validation Database), Gene Central, Onc*Base, Annotations,

Affy, SASSY, MASSY, CMCC, Cell Line Characterization DB, Baculovirus

Expression, Protein Expression Database, Tissue DB, Sequence DB, HySeq

Differential Expression, Candidates DB, Functional Validation, Pathways,

Human Kinome, GeneSeq, ISH/IHC DB, and Security Web Services. These web

applications provide instant access to valuable information for the

Scientific Research community as well as for the Finance, Operations, and

Legal departments at Novartis. These web applications were developed using

ASP.NET, VB.NET, C#.NET, ASP, MVC, VBScript, JavaScript, AJAX, DHTML, XML,

DevExpress, Crystal Reports, RSS, PL/SQL, .NET Framework 1.1 - 4.0, Visual

Studio 2003 thru 2010, Visual Interdev, ADO.NET, and ADO with IIS 5.0 / 6.0

on Windows 200x servers and Oracle 9i/10/11g on Sun OS, MS SQL Server 200x,

and MS Access.

Designed, developed, and implemented the various windows applications such

as Translational medicine Tissue Database (TMTD), AffyArray, MicroArray,

ISHDB, Hyseq, Sample Tracking, and Sequence Conversion applications as well

as Security Web Services and COM components. These windows applications

and COM component were developed utilizing VB.NET, VB6, ADO.Net, Oracle, MS

Access, PL/SQL, Oracle Packages, Procedures, Functions and various Active X

controls.

Harry Idachi

Levi Strauss & Co., San Francisco, CA

_7/2000 - 12/2001

As a Consultant, responsible for design, development, and implementation of

the Levi's corporate intranet applications such as GED (Global Executive

Database), CARS (Country Assessment), and CBD (Customer Business

Development). These web applications were developed using ASP, VBScript,

JavaScript, DHTML, MS SQL Server 6.5, ADO, Visual Interdev 6.0, and IIS 4.

LookSmart Ltd., San Francisco, CA _ _ ____

_______ 11/98 - 01/99

As a Consultant, participated in development of the Advertisement

Management Reporting application for the LookSmart Ltd., www.looksmart.com.

This intranet application provided the advertisement reports for the

marketing group of LookSmart and was developed utilizing ASP 2.0, DHTML,

VBScript/JavaScript, Visual Interdev 6.0, MS SQL Server 6.5, ADO, Store

Procedures, Transact SQL, Crystal Web Reports 7.0, IIS 4 on Windows NT4.0

Server.

Levi Strauss & Co., San Francisco, CA

_4/98 - 12/98

As a Consultant, responsible for making the Retail Replenishment (RR)

systems Year 2000 compliant. This project involved analysis, modification,

testing and implementation of Y2K fixes to the RR systems as well as

conducting baseline and future date testing and creation of test scripts.

The RR systems utilized VB 4, Oracle 7.3 on HP-UX, WinRunner 2000, and

PL/SQL, UNIX Shell Scripts, and MS Access.

International Totalizing Systems, Inc. Bradford, MA

_ 11/97 - 04/98

As a Consultant, designed and developed the Pay Telephone Monitoring System

(ITSDB) for International Totalizing Systems, Inc. (ITS). This system

consisted of 35+ screens developed with Visual Basic 5, MS SQL Server 6.5,

RDO, and various Active X controls.

GMAC Commercial Mortgage Corporation, San Francisco, CA

_ 02/98 - 03/98

As a Consultant, designed, developed and implemented the Due Diligence

Tracking System (DDTS) for GMAC Commercial Mortgage Corporation.

Utilized Visual Basic 5, Access 97, Crystal Reports, and various Active X

controls.

Charles Schwab and Company, San Francisco, CA

_ 10/97 - 03/98

As a Consultant, assumed responsibility for design and development of the

Commissions Calculator and the System Administrator applications, part of

the Flexible Commission System (FLEX) or Electronic Brokerage Technology

(EBT) group of Charles Schwab and Company.

Designed and developed the Class Builder application to automate generation

of the FLEX OLE Wrapper COM objects to interface with the Sentry/Middleware

data service components. These objects were referenced by the FLEX VB

applications to access DB2 data on the Host CICS/MVS.

Utilized Visual Basic 4 / 32, various Active X controls, COM, Access, and

OOP on NT 4.0.

Instep Technologies, Inc., Pleasanton, CA _

__ 4/97 - 2/98

As a Consultant, designed, developed and implemented the new Insurance

Administration System for DMC Insurance Administrators, Inc., Employee

Benefit Specialists Company. This comprehensive system consisted of 60+

screens developed using Visual Basic 5, Access 97, Crystal Reports, Active

X controls, and Windows NT 4.0 workstation.

Developed a front-end GUI application for Catalog Marketing software,

Envision Software, Inc. using Visual Basic 4 / 32, Oracle Objects for OLE,

Object-Oriented design and Oracle 7.3 Server.

Designed and developed Compensation system for JewelWay International

utilizing PL/SQL, Visual Basic 4 /32, Oracle Objects for OLE, and Oracle7.3

on Windows NT 4.0 platform.

Harry Idachi

Chevron Corporation., San Ramon, CA _

__2/97 - 4/97

As a Consultant, analyzed, defined requirements, developed and implemented

performance improvement fixes to the ACD Scheduler System, Help Desk

Appointment Scheduling system as well as development of Vantive PlusPlus

system, tool for the Vantive developers to manage Oracle Objects for

Chevron Information Technology (CITC). These systems utilized Visual Basic

3, 4 and 5, PL/SQL, ODBC, SQL*Net and Oracle 7.2 on HP-UX platform.

Wells Fargo Bank, San Francisco, CA

__ 03/96 - 10/96

As a Consultant, responsible for design and development of a front-end GUI

application for the Statement Utility System (SUS) which allows Wells Fargo

users to design and to build the consolidated statements for WFB customers.

It utilized Visual Basic 3, Access and Custom Controls.

Levi Strauss & Co., San Francisco, CA

___ 10/94 - 1/97

As a Consultant, designed, developed and implemented the Forecasting and

Inventory Planning and Stage One Software applications of Retail

Replenishment (RR) system. This successful client/server RR application

provided business analysts, forecasters and customers with the weekly unit

sales forecasts and the inventory planned orders as well as tools to

generate the forecast parameters and seasonality factors. The RR system

consisted of 100+ screens utilizing Visual Basic 3/4, Access, OLE, Crystal

Reports, ODBC, SQL*Net, Oracle Store Procedures/Packages, Shell Scripts,

Oracle 7.1 on HP-UX, SAS for Windows, VBX and Wise Installation.

Kaiser Permanente, Walnut Creek, CA __

__ 09/93 - 09/94

As a Consultant, designed, developed and implemented major on-line Clinical

Data Repository (CDR) system which captures clinical data from the various

OS such as Tandem, DEC, IMS/DB to synchronize with the CDR DB2 database.

Also responsible for development of Clinical Info System which provided

online presentation of the CDR data utilizing CICS/ESA, DB2/SQL, MQM, and

COBOLII

Participated in a client/server prototype development project for the

Distributed CDR. Responsible for development of UNIX processes on RS-

6000/UNIX platform to provide the VB clients with the CDR clinical data on

the Sybase SQL Server on RS-6000/AIX or the CDR DB2 database on MVS system.

Utilized C, VB3, Transact SQL, UNIX Scripts, TCP/IP, LU6.2, Visual and

Sybase SQL Server.

Levi Strauss & Co., San Francisco, CA ___

09/91 - 08/93

As a Consultant, designed, developed and implemented the Sundries Inventory

System, Levi Advanced Replenishment System (LARS), Electronic Purchase

Order Management System (EPOMS) which are part of the Levi's Advance

Business System (LABS) project. Utilized Telon, CICS, DB2/SQL, XDB,

COBOLII and MicroFocus under OS/2, Windows and MVS/XA.

Kaiser Permanente, Walnut Creek, CA ____

05/91 - 09/91

As a Consultant, designed, developed and implemented the new Claims

Adjudication Tracking System utilizing CICS, DB2/SQL, and COBOLII. Also,

responsible for development of tools such as Compile Panels, DB2 Catalog

Query and Dynamic SQL Panels using DMS, REXX and CLIST.

Levi Strauss & Co., San Francisco, CA _ ___

01/90 - 05/91

As a Consultant, responsible for major system enhancements and maintenance

to Master Billing and Order Status Inquiry Systems as well as design,

development and implementation of Consolidated Paper Invoices utilizing

CICS, DB2/SQL, IMS/DB and COBOLII.

Harry Idachi

Peter R. Johnson & Associates, Richmond, CA _ ___

__ 01/89 - 01/90

As a Consultant, Designed and developed Replenishment Management, Purchase

Order Management and Stock Allocation Systems utilizing CSP/AD/AE,

CICS/MVS, COBOLII, VSAM, and DB2/SQL. Also, Analyzed, defined

requirements, and developed interface between RMS and IBM INFOREM II

(Inventory Forecast and Replenishment Modules II) software.

Firemans Fund Insurance Co., San Rafael, CA _____

10/87 - 12/88

As a Consultant, responsible for the major system enhancements to Premium

Audit Processing System, Ocean Marine Cargo System and Mailing Address

System of Commercial Insurance group. Utilized IMS DB/DC, Intersolv's APS,

DB2/SQL and COBOLII.

Bank of America, Concord, CA ___

06/86 - 09/87

As a Consultant, responsible for the major system development,

enhancements, installation and production support for Deposit Accounting

System of International Banking System. Utilized IMS DB/DC and COBOLII on

the IBM 30xx environment.

Sunguard Shareholder System (formerly AFS/Sundata), San Mateo, CA

10/84 - 06/86

As a Senior Business Analyst and Programmer, responsible for design and

development of the key on-line Mutual Fund Transaction Control System for

the Investor Software as well as development and implementation of various

common modules. Utilized IMS DB/DC and COBOLII.

Control Data Corporation, Campbell, CA

03/84 - 10/84

As a Consultant, designed and developed Customer Information System of a

large integrated Banking System for Control Data Corporation, Campbell, CA.

Utilized CICS/VS, IMS/DB and COBOL on the IBM 3033 under MVS/SP.

Western Community Money Center, Walnut Creek, CA

06/83 - 02/84

As a System Analyst and Programmer, responsible for application analysis

and programming projects supporting IBM Commercial Bank Application System

and CIF System with special emphasis on Savings and Demand Deposit Account

on-line systems utilizing CICS/VSE, DL/1, VSAM and COBOL on the IBM 4341

under DOS/VSE.

Bay View Federal Savings & Loan, San Mateo, CA

04/81 - 06/83

As a System Analyst and Programmer, responsible for major enhancements and

software maintenance of Demand Deposit Account, Time Deposit Account and

Mortgage Loan applications of Bank Information System which utilized

GEMCOS, DMSII and COBOL on the Burroughs 6800.

Qualification Supplement

Active member of Bay Area Software Forum, and EBIG (East Bay IT Group).

Regularly attends Microsoft Technical conferences such as TechEd, and

VSLive.

Completed courses in the Microsoft .NET Training, Object-Oriented Design

and Development Using VB, Powersoft's Getting to Client/Server

PowerBuilder, IBM DB2 Application Programming, and DB2 DBA Workshop.

Contact this candidate