SUMMARY

I am a IT Professional with 14 years industry experience with a broad scope of knowledge from a business perspective to hands on programming and methodologies. I have a proven track record of success in full life cycle data movement projects and have a broad skill set to offer. I am currently seeking a contract or full time position where my skills can be a key in the success of any opportunity while expanding my knowledge of the complex and fast moving IT industry.

SKILLSET

Programming Languages:

Ø       Visual Basic 4/5/6, SQL, Focus, SAS, SPSS, Basic, HTML, Java, UNIX Scripting (Kornshell/Bourne).

Machines/Operating Systems/Utilities:

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

Networks/Network Protocols:

Ø       Novell NetWare/Intranetware, Windows Products, TCP/IP, ODBC, Banyan Vines and ISPX.

Database Systems:

Ø       Oracle 7.x/8.x/9i, Sybase ASE/IQ, MS SQL Server 6.5/7.x/2000, MS Access, FoxBASE/FoxPro, VAX/RDB, DB2/UDB, Paradox 9.x, EssBase, Informix, Terradata, Unify.

Data Warehousing/Architecture/OLAP Tools and ETL:

Ø       Erwin 3.5/4, Silverrun, ER Studio, DB Artisan, Ardent Datastage, Informatica 5/6/7, Decision Point, Business Objects Reporter/Designer/Document Agent/Webi/Administrator, Cognos Impromptu/Powerplay/Transformer/Report Net, Actuate, Brio, Crystal Reports, Microsoft Analysis Server, Quest Products.

P.C. Applications:

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

Data Warehousing Methodolgies:

Ø       First through fourth normal form data modeling for data warehousing systems, Data Warehousing life cycles and modeling techniques, Star Schema methodology (Kimball), OLAP design and implementation, ETL methodology.

EXPERIENCE

Freightliner/Daimler Chrysler, Portland, OR                                                         4/2003 -11/20/2004

Cognos Developer/Data Architect

Implemented corporate Cognos architecture, oversaw and created best practices for corporate enterprise wide installation. Responsible for Cognos development for corporate reporting for the TREAD act reporting/government compliance. Responsible for Cognos management and BI implementation

·         Created data mart architecture to support analysis and XML extracts

·         Scripted XML extracts from data marts using Informatica

·         Created Microsoft Analysis Server cubes to be used in conjunction with Cognos products and other tools.

·         Authored and designed data marts and Cognos power cubes to support the Freightliner NHTSA “TREAD Early Warning Government Compliance” mandate.

·         Developed Cognos Impromptu catalogs and reports to support detailed reporting for the aforementioned.

·         Deployed and customized Cognos upfront reports.

·         Administrator for the Freightliner Cognos environment.

The Oregon Clinic, Portland, OR                                                                                3/2003 -4/2003

Database/Reporting Consultant

Consulting with The Oregon Clinic L.L.P. to enhance current financial reporting capabilities. Enhancing current month end reporting process and examining optional transactional systems to support business needs.

·         Completed review of existing transactional systems and reporting processes.

·         Provided interim solutions for month end financial reporting using a VB/Access platform vs. manual extraction and compilation.

·         Recommended long term solution and software vendor(s)

Jantzen/Perry Ellis, Portland, OR                                                                               11/2002 -2/2003

Business Objects Developer/Consultant

Responsible for Business Objects universe and report development. Performed Modifications to existing universe structure and reports. Created Ad-Hoc data extracts where conventional Business Objects report would not suffice.

·         Completed Business Objects catalog development.

·         Completed Business Objects report development and deployment.

·         Compiled business area requirements for new report functionality.

NIKE, Beaverton, OR                                                                                                      10/2001 -7/2002

Data Warehousing Consultant/Project Manger

Provided technical consultation for design optimization and leadership of Nike’s Latin America’s data warehouse and Cognos Impromptu/Powerplay environment in an Oracle 8/AIX platform. Database optimization, schema enhancements and Cognos catalog development and deployment. Completed decision point entry data analysis for implementation into existing data schema. Developed PowerPlay cubes for EIS reporting needs.

·         Database reverse engineering.

·         Database enhancements and performance enhancements.

·         Cognos catalog, cube and report development and deployment.

·         Project management over Latin America’s region.

CNF/Vector, Portland, OR                                                                                             1/2001-9/2001

Data Warehousing Consultant / Data Architect

Provided technical consultation for design and implementation of corporate data warehouse and technical/data architecure in an Oracle 8i/AIX environment, needs assessment and business area requirements in the supply chain management industry.

·         Database architecture using Erwin/Visual Analyst.

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

·         Created Order management schema for GM project.

·         EDI Data mapping.

·         Business Area Requirements.

·         End user reporting and exposure needs.

·         Supply chain management environment.

·         Schema volumetric analysis.

·         Schema design enhancements to existing data models.

·          

Wellpoint Health Networks, Westlake Village, CA                                                    05/98 – 09/2000

Actuarial Systems Developer

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 subsequently developing the data cubes for distribution to the appropriate Actuaries and Executive Staff.

·         Stored procedure and program development using Sybase ASE.

·         Corporate data architecture transactional systems and data marts.

·         Cognos administration and development. Powerplay and Impromptu catalog, report and Cube development.

·         MS Access application development including distributed VBA Apps.

·         Metadata creation/storage and maintenance.

·         Performance tuning and data training.

Foundation Health Systems, Woodland Hills, CA                                               02/96 – 04/98

Senior Systems Analyst

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.

·         Oversaw technical staff of 20+ core team members and coordinated JAD sessions.

·         Served as the Business Objects Administrator and Designer.

·         Brio and Cognos report development.

·         Maintained data model in ErWin

·         Performed user tool and data training pre and post implementation

Health Net, Woodland Hills, CA                                                                                01/94 – 01/96

Decision Support Analyst

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 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 and SAS\SPSS.

Health Net Special Accounts, Woodland Hills, CA                                             01/90 – 12/93

Senior Marketing Analyst

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

                1996: HIPAA accredited.

                1997: Business Objects Administrator Training.

                1998: HIPC Administrative training.

                1999: Centers for learning: Health Care Administration and IT Development.

                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).

                2002: SAP/BI/B2B development Oracle Corp. Seattle.

2004:  Cognos ReportNet Developer and Administration Course.