Site hosted by Angelfire.com: Build your free website today!

Scott Smith

2733 NW Thurman #2

Portland, Or. 97201

Home Phone: (971)-544-0306

Cell Phone: (503)-410-9030

Email ssmith971@hotmail.com

OBJECTIVE:            

To secure a position where I am challenged, further developing analytical and technical skills, by providing positive I.T. solutions for internal and external customers using structured and intuitive processes and advancing technology to achieve company/departmental goals in a timely and efficient manner.

TECHNICAL SKILLS:

Programming Languages:

Ř      Microsoft Visual Basic, ISQL, PLSQL, TSQL, Focus, SAS, SPSS, Basic, HTML, Javascript, UNIX Script (Kornshell/Bourne).

Machines/Operating Systems/Utilities:

Ř      Windows NT/95/98/ME/2000/XP, Macintosh OS, DOS, OS/2, UNIX, Syncsort, NDM, CMS, IBM RS/6000, OS390, HP9000, VAX/Alpha and VAX/Open VMS.

Networks/Network Protocols:

Ř      Novell NetWare/Intranetware, Windows NT, TCP/IP, ODBC, Banyan Vines and ISPX.

Database Systems:

Ř      Oracle, Sybase ASE/IQ, MS SQL Server, MS Access, FoxBASE/FoxPro, VAX/RDB, DB2, Paradox, EssBase, Informix and Terradata.

Data Warehousing/Architecture/OLAP Tools:

Ř      ErWin, Silver Run, ER Studio, Ardent Datastage, Decision Point, Business Objects Reporter/Designer and Administrator, Cognos Impromptu/Powerplay and Transformer, Actuate, Brio, Crystal Reports, TOAD/SQL Navigator, DB Artisan.

P.C. Applications:

Ř      Microsoft Excel/Word/PowerPoint/Query/Visual Source Safe/Binder/Outlook/Mail and Exchange Server, SQL Advantage, SQL Plus, Sybase Open Client, Lotus Notes, TAO, FileMaker Pro, Symantec ACT, Adobe PageMaker/PhotoShop, Visio, Pillar, Attachmate Extra/KeaTerm, Hummingbird Exceed and Irma.

EXPERIENCE:

Data Warehousing Consultant Meridian Technology Group (10/1/2001)-(06/17/2002)

 

Nike America’s Project Manager:

 

Provided technical consultation for design and optimization of Nike’s Latin America data warehouse. Completed Cognos Impromptu and Powerplay development in an Oracle 8/AIX environment. Performed database optimization, schema enhancements catalog development and revised 32 Impromptu reports for additional functionality and performance enhancements.

 

Worked with end users to compile technical assessment for reporting needs. Interacted with end users and technical leads to provide OLAP functionality.

 

Data Warehousing Consultant Vanderhouwen & Assoc(1/1/2001)-8/2001

Provided technical consultation for design and implementation of corporate data warehouse and technical architecture in an Oracle 8i/AIX environment. Compiled needs assessment and business area requirements. Interacted with end users and technical staff to deliver necessary data structure to support transactional and reporting environments.

 

Contract with CNF as a Data Architect:

 

·        Database architecture using Erwin/Visual Analyst.

·        Created and managed outbound vehicle movement database schema for General Motors.

·        EDI Data mapping.

·        Business Area Requirements.

·        End user reporting and exposure needs.

·        Supply chain management environment.

·        Schema volumetric testing.

·        Schema design enhancements to existing data models.

·        Participated in Vector’s OLAP tool vendor selection

 

 

Actuarial Systems Developer, Wellpoint Health Networks (05/98 – 06/2000)

Acted as an Actuarial Systems Developer/Data Architect for the Corporate Actuarial Data Warehouse team. Served as the liaison between Actuarial Systems and the Corporate Actuaries gathering user requirements and aiding the technical team in the design process in multiple phases of development. Responsible for the extraction and compilation of the business area requirements for the corporate actuarial business intelligence needs and subsequent Cognos Impromptu Reports and data cubes for distribution to the appropriate Actuaries and Executive Staff.

 

·        Stored procedure and program development using Sybase ASE.

·        Corporate data architecture.

·        Cognos administration and development.

·        MS Access application development

·        Metadata creation/storage and maintenance.

·        Performance tuning and data training.

 

Senior Systems Analyst, Foundation Health Systems (02/96 – 04/98)

Served as part of an I.S. team that developed and implemented the Foundation Health Systems data warehouse/data mart for the membership reporting process.

·        Participated in the user requirements, design, testing and implementation of a 200+ user data warehouse and data mart.

·        Compiled technical specs for Migration from Cognos environment to Business Objects.

·        Served as the Business Objects Administrator and Designer.

·        Maintained data model in ErWin

·        Performed user tool and data training pre and post implementation

 

Decision Support Analyst, Health Net (01/94 – 01/96)

Participated in the development, programming, testing and implementation of a Mobile Office/Sales Automation System using Visual Basic and MS SQL Server. Provided application development and Ad-Hoc reporting using SQL, Focus, and Cognos Impromptu to support the upper management decision making process.

 

·        Successfully rolled out sales automation system to 500+ sales force.

·        Developed VBA/RDB application to support standardized Ad-Hoc queries for regional analysts, reducing turn around time for data.

·        Provided technical support/data expertise to regional analysts.

·        Created regional pricing algorithm/application for underwriting in Visual Basic/Paradox.

 

Senior Marketing Analyst, Health Net Special Accounts (01/90 – 12/93)

Produced group renewal profiles and detailed analysis of medical loss ratios, age/sex distribution, premiums and encounter data for Account Managers, Sales Force and upper management using multiple Ad-Hoc tools and multiple programming languages.

·        Developed automated age/sex factor application using VBA saving the underwriters time and money while expediting the rating process.

·        Provided valuable trending data on renewing group policies.

·        Served as a technical liaison between Sales and Marketing and Actuarial departments.

·        Acted as direct support for Sales and Marketing, performing competitive analysis for new sales and group renewals.

EDUCATION:

1981 – 1985 Newbury Park H.S., Newbury Park, Ca. Diploma/College Prep.

            1987 – 1988 Moorpark J.C., Moorpark Ca. General Education/Computer Science

ADDITIONAL CLASSES/SEMINARS:

            1994: HIAA accredited

            1997: Business Objects Administrator Training

            1999: Cognos Advanced Developer Training

            1999: Advanced UNIX/Comp. U.S.A.

            1999: American Health Care Accredited

            2000: GoldMine Service and Support Certified

            2000: Oracle Web Development Class (LTU)