Computer, Analyst/Programmer


[ Philippines Online Resume Listing ] [ FAQ ]

Posted by on March 30, 1998 at 10:32:35:

Graduate of BS Computer Science, 3 Years experience in the IT Field.

WORK EXPERIENCE DETAIL
----------------------
Intranet Business Systems Inc. 22 August 1996 to Present
IT Consulting Company specializing in Data Warehousing for Banks and TelCos

PROJECT 1: Primary resource for design, development, implementation, user training and support for the first company product. The product is a relational OLAP tool for dimensional datawarehouses and data marts running above Excel. The tool is Metadata Driven, developed using Visual Basic for Applications (VBA), Visual Basic 5 Enterprise, MS Access 97, MS-SQL Server 6.5 and Oracle 7.3, takes advantage of a warehouse Star Schema design, ActiveX technology (OLE Automation), ODBC and Network API and uses ODBC for remote database connectivity. Technical functions also include Query (SQL) optimization through summary navigation, Ad-Hoc and Hierarchical drills through metadata definition and multi-resultset handling.

PROJECT 2: Designed and developed a Data Warehouse/Mart CASE using Visual Basic 5 Enterprise and MS Access 97. The product is a tool for designing a star schema based dimensional data warehouse/mart
using point and click interface. It is here where the metadata of the above-mentioned OLAP tool is derived.
The main function of this tool is to define schemas and related dimensions and facts plus hierarchical
cross field and table hierarchies and aggregates, which are elements of a star schema based warehouse,
and generate appropriate DDL statements.

PROJECT 3: Involved in product enhancement and tailoring, reports definition and user training and
support for a Bank Datawarehousing system.


Information Engineering Workshops (IEWorks) 25 April 1995 to 9 August 1996
IT Consulting Company specializing in Non-life Insurance business

PROJECT 1: Involved in requirements definition, design, development and implementation of a
client-server Insurance system, using Visual Basic 4 Enterprise and Delphi for client side development under Windows 95 and SQL Server 6.0 for server database and development under Windows NT 3.51. Job details as a designer includes data gathering, data modeling using IE Advantage CASE tool and specification formation for tasked development. As a lead front-end developer of first project milestone covering implementation, user training and orientation, as a back-end developer implementing database table triggers, stored procedures and views, and as a DBA carried out database schema maintenance and user profiling.

PROJECT 2: Involved in referential table development and maintenance using Foxpro 2.6 for a multi-user Insurance system, using Foxpro 2.5 under Windows 3.11.


TECHNICAL SKILLS
----------------
Hardware
IBM PC and compatibles
Digital Alpha Server
Networking
NETBUI
TCP-IP
CASE Tool
IE Advantage
Operating System
MS Windows NT Server 3.51/4.0
MS Windows NT Workstation
MS Windows 95
MS Windows 3.1/3.11
DOS
Programming
Visual Basic 4/5 Enterprise
Visual Basic for Applications (Microsoft Office Development)
MS Access
Delphi
Transact-SQL
Oracle PL-SQL
Oracle Express Objects (Express Basic)
Foxpro 2.5/2.6 for Windows
Clipper
HTML
Database
MS SQL Server 6/6.5
Oracle 7.3
Tools
MS Office
Oracle Discoverer
Oracle Express
MS Front-page
Others
Image processing
Multimedia application development
PC hardware and software configuration
PC/Stereo/Line/CD/FM Audio Processing
Text to Speech Conversion
LAN Installation and configuration





[ Philippines Online Resume Listing ] [ FAQ ]