.

button-1-175-who

.

relationary_sm

Creator

My name is Grant Morgan Czerepak. I am the founding CEO of White Hex Corporation a thinking company. I am an IT professional with over 25 years experience in database technology specifically in the area database theory. I have lived and worked in nine cities across Canada, the United States as well as in Singapore. I am always for hire.  If you would like me to share my knowledge and experience with you through a speaking engagement, seminar or consulting I would be more than happy to make arrangements with you. Visit my “where” page for contact info.

Curricula Vitae

Present Founding CEO

White Hex Corporation, Winnipeg, Canada

White Hex Corporation exists to create competitive advantage for its clients.  We started in Information Technology and we are extending across the disciplines.

White Hex Corporation is being established to create a team of generalists with design skills across the disciplines to tackle design problems.

White Hex Corporation has a living methodology that sees governing principles that extend from creativity all the way to fulfillment of a buyer’s purchase.

Since I have established my business, I have taken on a variety of clients providing general services until I could finalize my business strategy for the long term.

Client: HermanNelson.com, Winnipeg, MB

Aerotech Herman Nelson is a global supplier of portable aircraft HVAC.

* Recruited, Interviewed and Hired Sales Team.

* Conceived and directed implementation of “quote request cart” for website

* Directed website enhancements

* Directed Google Adwords campaign and hired employee to optimize performance

* Conducted email campaigns to opt-in customers

* Registered company in United Nations Global Marketplace

* Registered company in Marketing Agents National Association

* Hired engineer to develop next generation of portable heating units

Client: BirdFluInsider.com, Winnipeg, MB

Bird Flu Insider was a leading website providing balanced reporting on the subject.

* Researched and Compiled Content

* Designed and Developed Website

* Perform Regular Website Maintenance

* Publication: Planning for Bird Flu: A Balanced Perspective for Family and Business, 106 pp. available on amazon.com

Client: Gilcris.com, Winnipeg, MB

Gilcris Enterprises specialized in importing John Deere Tractors from Europe for resale in Canada.

* Maintained website

Client: IndianTrailOutfitters.ca, Arborg, MB

Indian Trail Outfitters was a leading hunting guide and outfitting service for central Manitoba, Canada.

* Designed and Developed Website (site no longer active)

Client: StephensEdge.com

Stephen’s Edge is a city painting contractor noted for client referrals.

* Performed a variety of site enhancements

MS Office, SiteSell, HTML, JavaScript, CSS, DBDesigner4, MySQL

2008.06 – 2008.11 System Analyst Supervisor Great-West Life Assurance Company, Winnipeg, Canada

http://www.greatwestlife.com

Great-West Life is one of the largest Insurance and Financial companies in Canada.

Currently, they are undertaking a ten year project to migrate from their legacy systems onto an SOA with an innovative business model.

On discussion with the Senior Architect I independently worked on development of an alternate data architecture and schema to address limitations in system modification.

The solution involved a six dimensional meta-layer that pemitted the definition of entities, associations and values.

At this point my model is being prepared for presentation to senior management.

During this project I was assigned to supervise the work other data modelers on other GWL projects.

Erwin, Enterprise Architect, MS Office, Visio

2007.11 System Analyst

Great West Life Assurance Company, Winnipeg, Canada

Worked as a Senior Database Analyst/Designer creating logical models for a major Group Life Assurance initiative by Great-West Life

Erwin, Enterprise Architect, MS Office, Visio

2007.07 Data Analyst

Healthcare Employees Pension Plan– Manitoba (HEPP), Winnipeg, Canada

http://www.hepp.mb.ca

HEPP is the Pension and Benefits provider to the employees of over 700 healthcare facilities in the province of Manitoba. HEPP has recently changed its IT infrastructure from being served by outside consultants to a fully internal Information Services team. HEPP employed me to perform several responsibilities:

* Data modeling and impact analysis for changes to the HEPP database.

* Assisting data administrators by providing reports on the current status of the database regarding the posting of payroll data to the database.

* Advising on the adoption of business modeling methods and the purchase of business modeling software

* Ad hoc analysis and reporting as required

* Ad hoc maintenance of database and processes as required

Oracle 9i, TOAD, Erwin, SeaPine TestTrack Pro, Testrack TCM, Surround SCM

2004.08 Data Analyst

Prolink Inc, MacLean, VA

FreddieMac is a mortgage and housing company created by the United States federal government to enable middle income families to purchase homes. Freddie Mac engaged Prolink to provide a data modeler for one of several data analysis teams. In the course of my employment at FreddieMac I worked with a development team to create a data model for a rate matrix system, document the new model in the corporate data dictionary and gather metadata information. I resigned due to personal reasons.

Project: FreddieMac

* Worked in conjunction with programmers, DBAs and Data Analysis team to develop logical data models for Freddie Mac’s internal applications

Oracle 9, ERWin, ISO/IEEE 11179

2003.11 Data Analyst Fahrenheit Technologies Inc, Richmond, VA

Project: IT Analysis and Reporting Methods REMAP

CapitalOne, Richmond, VA

CapitalOne is a major credit card company in the United States.

CapitalOne engaged Fahrenheit Technologies to provide my services to the IT Analysis and Reporting Methods team to work on a Inmon based data warehouse. Emphasis was placed on denormalizing tables into structures that could support predefined reporting requirements.

* Worked with team to extend capabilities of the Project Reporting and Analysis Warehouse

* Recorded and converted findings into data models

* Merged ERWin Model with MS Visio model

* Tested REMAP extension Microstrategy reports

Oracle 9i, Toad, MS SQL Server 2000, ERWin, MS Visio, MS Office

Project: TDM Data Scrubbing

CapitalOne, Richmond, VA

* Scrubbed test data in over ten corporate Oracle databases for offshore projects

* Documented data scrubbing plans and results

* Wrote manual for Client Model Test Data Generator application

* Trained in Java in order to maintain Test Data Generator

Oracle 9, Toad, Unix, MS Office, Java

2002.02 Senior Data Modeler

Information Services Group Inc, Harrisburg, PA

Project: Construction Documentation System

Pennsylvania Turnpike Commission

The Pennsylvania Turnpike is an interstate highway cutting east-west across the state of Pennsylvania and is maintained by the Pennsylvania Turnpike Commission. The commission engaged ISG to define, design, develop and deploy a construction documentation system that would enable inspectors to collect construction inspection data in the field on laptops and then synchronize their laptop databases at stations at various points along the turnpike.

* Analyzed existing system at client offices and construction sites

* Developed logical and physical modeling standards

* Designed logical data model in ER/Studio

* Designed physical data model in MS DBE with Developer

* Communicated status regularly in semi-formal environment

ER/Studio, MS DBE, MS Office

Project: SIF Data Model

Schools Interoperability Framework, Washington, DC

The Schools Interoperability Framework engaged ISG to work in conjunction with them to incorporate data modeling into the planning of a database standard for a national model. I was assigned the job of studying the various applications documenting their data models and then merging these data models into a composite whole.

* Designed a preliminary logical data model based on the integration of eight school management software platform

* Presented data model concepts and data model at SIF conference in Washington, DC

ERWin

Project: XML Informal Traininng

Preparation for Bid (Internal)

* Trained in XML with fellow database specialists in preparation for a potential project requiring an understanding of the technology

Project: HIPAA Compliance Database

HIPAA Compliance Assessment Practice (Internal)

* Worked with company consultant to develop database application to record HIPAA compliance criteria met by company clients

MS Access

Project: Data Modeling Concepts Presentation

Central Pennsylvania Computing Professionals

* Presented IDEF1X notation and Normalization concepts

Project: Chapter Creation

DAMA Central Pennsylvania

* Coordinated founding of DAMA Chapter

2000.11 Senior Data Modeler

Food.com, San Francisco, CA

The founders of food.com had succeeded in patenting the process of locating restaurants in the vicinity of a customer through geolocation. The food.com website would ask for a customers address information including postal code, determine the geolocation by postal code, determine the restaurants within a given radius, make those restaurant’s menus available for delivery or take out orders, capture the order and notify the restaurant. Food.com served the entire continental United States.

Food.com has since changed its business model and has sold its URL.

* Created Conceptual, logical and physical data models and DDL

* Enhanced layout of data model for better communication

* Data Migration from MS SQL Server to Oracle 8i

* Oracle Database Administration and Support

* Purchased the company fussball table

Oracle 8i, DB/Artisan, ER/Studio, Toad, SQL*Plus, Unix, Windows NT, MS Office

1999.08 Senior Consultant

Proxicom Inc, San Francisco, CA

Project: Food World Data Warehouse ETL Team

National Product Diaries (NPD), New York, NY

National Product Diaries is one of the largest aggregators of product consumption statistics in the United States. NPD engaged Proxicom in the multiphased development of a Kimball dimensional data warehouse that would span several product “worlds.

* Trained in Informatica

* Designed, developed and unit tested transformations from source to ODS and from ODS to DDS

Informatica, MS Office

Project: GE Venture Mine

GE Capital, San Francisco, CA

* Designed logical data model according to analyst specifications

* Developed physical data model with developer revisions

* Deployed physical data model for Oracle 8i platform

* Installed and configured Oracle 8I RDBMS and created database

* Administrated database during the course of development

Oracle 8i, ERWin

1996.01 Senior Consultant

LGS Group Inc, Winnipeg, MB

Project: Order Entry System Support

Canadian Pacific Railway

* Tested progressive releases of Oracle 7 order entry application

* Provided 24/7 production support

* Documented system and releases both in text and graphically

Oracle 8i, ERWin, Visio, MQ Series, MS Office

Project: Roundup Ready Website

Monsanto

* Performed Quality Assurance and testing of website for licensing Roundup ready canola seed

Project: Corporate Financial Management Systems

Great-West Life Assurance Company

Designed and developed an MS Access database and application for the 1999 Branch Office Statistics System. Used by regional Vice-Presidents for negotiating budgets nationally.

* Assisted actuaries in transitioning applications from MS Excel to MS Access

* Provided technical support for MS Access and MS Excel

MS Access, MS Office

Project: Disaster Financial Assistance System (DFA)

Manitoba Emergency Management Organization, Government of Manitoba

* With an internal DFA team produced design specifications including a Data Dictionary, ERDs, Data Flow Diagrams, Process Flow Charts and presentation material.

* Authored a successful funding request to the Manitoba government’s IT branch for this system.

MS Access, Visio, MS Office

Project: Cardia Fundraising Data Model

Heart and Stroke Foundation of Manitoba

* Lead team to produce a conceptual, logical and physical enterprise data model for the not for profit agency

* Performed a variety of MS Access programming tasks

ERWin, MS SQLServer, MS Access

Project: LGS System Migration

Internal

* Voluntarily took responsibility to dismantle and reassemble all systems during relocation of Manitoba corporate office

* Tasks included rewiring LAN

Project: Route Manager

Cargill

* Consulted with Cargill Route Master team on project estimates, Visual Basic programming, interface design and client/server database issues.

* Designed and coded EDI component in Visual Basic with Sybase host.

Sybase, Visual Basic, EDI

Project: Manitoba Oil and Gas Well Information Systems (MOGWIS)

Petroleum Branch, Manitoba Energy and Mines, Government of Manitoba

* Developed graphic user interface for MOGWIS application using Oracle Forms.

* Designed data model

Oracle 7, Oracle Forms, Oracle Reports, ERWin, MS Office

1994.11 Consultant

Information Technology Works, Winnipeg, Canada

* Designed and developed a customer service support system for PC vendor.

SQL Server, Visual Basic, MS Access, MS Office

1994.04 Consultant

Softworks Technology, Singapore

* Designed test generators for secondary school mathematics courses

* Developed marketing strategy for a scalable database application systems

Progress, MS Access, Visual Basic, MS Office

1992.08 Database Administrator

Technical Services, University of Winnipeg, Winnipeg, Canada

* Provided technical support on database issues to faculty and staff

* Supervised student employee performing software research

* Assisted faculty in using Oracle for research purposes

* Researched new Windows based databases

Oracle 6, Rbase4, WordPerfect 5.0, Stanford Graphics

1991.06 Business Systems Analyst

Manitoba Telephone System, Winnipeg, Canada

* Migrated corporate Financial Management Information System MSDOS Oracle 5 system to Unix Oracle 6 System.

* Optimized and performed monthly processing

Oracle 5, Oracle 6, Unix, Norton Utilities

1990.03 Project Leader

SW International Systems (Singapore) Pte Ltd, Singapore

* Lead programming team in development and installation of software for 5 Singapore hospitals

* Negotiated cooperative agreement between SWI and PC hardware manufacturer

* Initiated migration of application user interfaces from text to graphics

* Prepared course material for training in SAGA development tools

* Taught introductory course in Unix

* Performed Unix system administration on company server

* Interviewed and hired team members

Informix, Unix, C, SAGA, Harvard Graphics, MSDOS

1989.06 Business Systems Programmer/Analyst

Microtel Pacific Research, Vancouver, BC

* Designed and developed user interface for internal project management system as well as textual and graphic reports

* Developed flowcharting system for Oracle Forms

* Trained in Oracle 6 Database Administration

Oracle 5, Oracle 6, Unix, MSDOS, Harvard Graphics, LATex

1986.05 – 1988.09 Programmer/Analyst

Federal Department of Transport, Government of Canada, Winnipeg, Canada

* Radar Modernization Project Management Team

* Analyzed, Designed and Developed Financial Rollup Program for Team

* Trained clerical staff member in Lotus 123

* Wrote report on RAMP central region project team’s workload advising the addition of clerical position to team. Recommendation accepted.

* Self-taught dataflow diagramming

Dbase III plus, Lotus 123, WordStar

1987-88 Lab Instructor

Land Based Information Systems Lab, University of Winnipeg, Winnipeg, Canada

* Taught Honors students how to develop facility GIS applications

* Wrote 150 page manual to support MapInfo training

Informap III, Oracle 5, WordPerfect 5.0, DEC VAX/VMS

1987-88 Intern Instructor

Writing Program, University of Winnipeg, Winnipeg, Canada

* Taught English composition to students referred by professors

* Applied both personal instruction and computer assists

* Developed computer assisted composition lifecycle

* Wrote 50 page report evaluating the benefits of installing a LAN

1987-88 Teaching Assistant

University of Winnipeg Continuing Education, Winnipeg, Canada

* Assisted in teaching WordPerfect, dBase III plus, Lotus 123 to bank employees

EDUCATION AND PROFESSIONAL DEVELOPMENT Bachelor of Science 1990.04 Business Computing, University of Winnipeg Certifications 2003.07 Data Modeling Concepts, Master’s Certificate, Top 2 Percent Brainbench.com Additional Courses 2000.06 Informatica: Power Mart & Power Center 1999.09 Business Objects: Reporter, Designer, Supervisor 1999.02 Lotus Notes R4: Basics and Beyond 1998.04 Microsoft Windows Architecture for Developers 1992.09 Toastmasters International, Leadership Program 1991.09 Unix System Overview and Fundamentals 1990.07 SISIR Quality for Software Workshop Publications 2006.02 Planning for Bird Flu 106pp. 1989.04 GIS: Facility Mapping Fundamentals, 150pp. COMMUNITY WORK 2006 to Present, Volunteer Counselor, Mood Disorders Organization of Manitoba 2006 President, Manitoba Morning Toastmasters RECREATION Winnipeg Symphony Orchestra, Manitoba Theatre Centre, Movies, Music, Reading, All-Season Hiking

Advertisements
Comments Off on
%d bloggers like this: