George Pond

Code3w, Inc.

Project Manager/Business Analyst
Co-Owner

Orlando, FL   11/08 — Present

• Gathered requirements for a .Microsoft NET/SQL-based Customer Relationship Management (CRM) system.  Confirmed requirements with the client.  Using Embarcadero ER/Studio, developed logical and physical data models and scripts.
• Developed Extract, Transform and Load procedures in Microsoft SSIS to populate an online database.  Maintained two online databases using SQL Server Management Studio.
• Currently designing web pages for a next-generation CRM system, www.MyGuestSurvey.com.  Wrote system documentation.

SetFocus

Online Learner

Orlando, FL   3/09 — 5/09

• Completed 10 weeks of hands-on Data Warehousing and Business Intelligence training.
• Delivered four projects in ETL Development, OLAP cube design, data warehouse reporting and SharePoint/Performance Point Server publishing.  Wrote Transact/SQL and MDX (dimensional) queries.

TEKSystems / Walt Disney World Co.

Sr. Business Analyst Consultant

Orlando, FL   8/08 — 11/08

• Analyzing and documenting BusinessObjects/Business Intelligence reports, data elements and metadata for a Disney Vacation Club project.
• Developed a report layout template.
• Documented report requirements based on interviews with management and other business users.
• Gathered metadata and created a Conceptual Data Model in Embarcadero ER/Studio to represent 38 use cases and 17 reports.
• Collaborated with other Business Analysts and the project Data Architect to verify and standardize data elements.

TEKSystems / Starwood Vacation Ownership

Sr. Business Analyst Consultant

Orlando, FL   8/07 — 7/08

• Documented functional, data and business rule requirements for reservation system upgrades. Designed rules engine strategy currently being developed to automate inbound changes to inventory. Documented business-to-business (B2B) payment automation.
• Prepared a vision document for automating B2B transactions. Developed conceptual and logical models. Mapped data elements between external exchange companies and corporate applications. Diagramed workflow and business rules. Wrote functional requirements.
• Documented software test plans. Wrote a user guide for in-house Crystal Reports applications.
• Documented requirements in UML and text use cases for an interval ownership inventory system. Wrote report specifications.   Performed system tests. Developed a user guide for administrative and security functions.

Aquent / Walt Disney World Co.

Sr. Business Analyst (Consultant and Cast)

Lake Buena Vista, FL   8/06 — 8/07

• Authored Life Cycle Methodology (LCM) deliverables containing UML diagrams (Class, Use Case, Activity and Sequence Diagrams).  Wrote requirements and design documents for Disney's Honeymoon Registry, an n-tiered internet ecommerce application, including IBM Rational middleware core services.
• Documented AS400 configuration procedures.  Wrote production support documentation for Services-Oriented Architecture (SOA)/Model-Drive Architecture (MDA) components.
• Documented Mercury test plans and results for a messaging (middleware) EAI Hub.  Developed several LCM deliverable documents for that project.  Performed technical edits.  Extracted diagrams, object definitions and properties from Rational Software Modeler files using Rational SoDA.

iCST

Data Modeler (Subcontractor)

Portland, ME   6/06 — 7/06

• Updated ER/Studio and Microsoft Visio logical and physical models for an environmental surface water database.
• Edited and expanded a data dictionary and metadata repository.  Wrote reports and presentations.

TEKSystems / PBS&J

Business Analyst (Consultant and Employee)

Orlando, FL   8/05 — 4/06

• Created data models and documented metadata for a federally-funded Evacuation Planning application.  Planned test strategies, authored scripts and led regression and user acceptance testing.  Documented a feasibility study.
• Documented Systems Requirement Specifications (SRS) for a systems integration and dashboard reporting application.
• Developed a test plan for a public utilities workflow application.  Authored Use Cases, workflow diagrams and training materials for an emergency response Geographic Information System (GIS).  Wrote HTML help.

Code3w, Inc.

Co-Owner / Internet Designer / Analyst

Orlando, FL   4/05 — 8/05

• Collaborated on design of a real estate school marketing and registration web product.  Consulted on a real estate school custom website.  Designed ASP .NET user interfaces.  Set up a secure ecommerce site.

Walt Disney World Co.

I.T. Analyst (Data Architect) / Business Systems Analyst
Financial Systems Support Analyst

Lake Buena Vista, FL   7/97 — 4/05

• Provided data architecture services in the Information Technology Division.  Developed data models and class diagrams.  Documented business rules.  Data Architect for a Distributed Supply Chain implementation, including mainframe system feeds, handheld/wireless devices and workstation interfaces.  Mapped source-to-target data flows.  Maintained the Central Data Warehouse (CDW) and Sales and Marketing Data Mart (SMART).  Data Architect for an I.T. Security Data Mart.
• As Business Solutions Analyst for Magic Kingdom Park, initiated technology projects for over 300 Managers and Executives.  Articulated the business case and delivered presentations.  Developed plans and schedules.
• Completed requirements, then took over as Project Lead for Disney's Golf Reservation System.  Developed test strategies and supervised script writing.  Planned and conducted data migration from the legacy system.  Led application roll-out.

Education

MA/Human Resource Development

George Washington University

BA/Music Education

Boston University

Business Intelligence/Data Warehousing

SetFocus

Data Modeling Workshop

Inteq

Download .PDF Resume

Follow georgepond at http://twitter.com

Home | Profile | Experience | Data Warehouse Tour | Contact