Summary

• Fourteen years as enterprise I.T. Analyst, including three consulting assignments at a Fortune 100 entertainment company. Business Analyst for the most-attended theme park worldwide. Three years deploying and maintaining BusinessObjects reports and universe in that environment.
• More than twelve years Microsoft SQL analysis experience, including scripts, Data Warehousing, SQL Server Reporting Services SSRS , and Extract/Transform/Load ETL using SQL Server Integration Services SSIS .
• Seven years Unified Modeling Language UML diagramming. Focus on Use Cases, Activity Diagrams and Sequence Diagrams using Rational Software Modeler RSM , RequisitePro, SoDA, Visio, and ClearCase.
• Eight years providing data architect, data analyst and data administrator services using ER/Studio and ERwin. Three years test plan and test case development. Planned and documented HP Quality Center tests.

Technical Skills

EXPERIENCE

Confidential

BUSINESS ANALYST/DATA ARCHITECT

• Media/tools: Embarcadero E/R Studio, Microsoft SQL Server, WordPress, Camtasia, Mockup Screens, Bubbl.Us Mind Map
• Documented requirements for JobKettle.com. Created screen mock-ups. Designed the SQL databaser. Populated 47 tables with data from .CSV, spreadsheet and SQL files. Currently doing data analysis and application testing.
• Developed a WordPress blog at WageScope.com and authored 22 blog posts. Produced demonstration videos. Tested JobKettle.com. Documented issues and wrote a plan for phased enhancements.

Sr. Business Analyst Consultant

Confidential

Technical

Environment: Waterfall SDLC with Microsoft Visio/SQL Server/Project/Embarcadero ER/Studio

• Analyzed requirements, developed the data architecture and documented screen layouts and use cases for Race to the Top RTTT teacher evaluation. Coordinated offshore development. Conducted User Acceptance Testing UAT and training with school principals, teachers, and district leaders. Initiated and designed weekly reporting. Provided Level 2 support.
• Gathered requirements, developed the data architecture and implemented a Microsoft SQL Server database for K12 Exceptional Student Services. Documented the design and coordinated offshore development. Wrote documentation and User Acceptance Test UAT materials. Designed SSRS reports. Conducted UAT. Provided Level 2 support.

Business Analyst Consultant

Confidential

Technical

Environment: Microsoft Visio/SharePoint

Documented over 250 functional and business requirements for a Content Management System.

Business Analyst Consultant

Confidential

Technical Environment: Waterfall SDLC using Vignette, Microsoft Visio/SharePoint, HP Quality Center

Gathered requirements and prepared Common Methods LCM technical and end-user documents for an enterprise content management team. Wrote a Service Level Agreement and Production Support/Deployment Procedures.

Process Analyst

Confidential

Technical Environment: Microsoft SQL Server 2008/SharePoint/OneNote/Visio/UML 2.0, Embarcadero ER/Studio

Documented business processes and reviewed with department executives. Wrote a requirements document for business process migration. Documented Agile/SCRUM methodology procedures. Analyzed Business Intelligence reporting needs.

PROJECT MANAGER / Sr. BUSINESS ANALYST

Confidential

Technical Environment: Microsoft SQL Server/SSIS/SSAS/Visio, Google Analytics, Embarcadero ER/Studio

Designed web pages and online SQL Server databases using SQL Server Management Studio. Designed data movement in Microsoft SQL SSIS and reports in SSRS. Performed Search Engine Optimization SEO and social media marketing.

Sr. Business Analyst Consultant

Confidential

Technical Environment: Waterfall SDLC using Business bjects Microsoft Visio, Embarcadero ER/Studio

Documented BusinessObjects reports, data elements and metadata for a Disney Vacation Club project. Gathered requirements and created a Conceptual Data Model in Embarcadero ER/Studio to represent 38 use cases and 17 reports.

Sr. Business Analyst Consultant

Confidential

• Technical Environment: Agile and Waterfall SDLY using Microsoft Visio/Embarcadero ER/Studio, BBX Business Basic
• Documented functional, data and business rule requirements for reservation system upgrades. Designed a rules engine strategy to automate inbound changes to inventory. Prepared Vision/Requirements documents, including UML diagrams.
• Diagrammed workflow in Visio. Wrote user guides for Crystal Reports applications. Wrote report specifications.

Sr. Business Analyst Consultant

Confidential

Technical Environment: Rational Suite: RSM/RequisitePro/SoDA/ClearCase, Microsoft SharePoint/Visio/Office

• Authored Life Cycle Methodology LCM deliverables, including UML diagrams, data models and requirements from Rational RequisitePro. Wrote requirements documentation for Disney's Honeymoon Registry.
• Documented AS400 configuration procedures and Services-Oriented Architecture SOA components. Wrote the documentation set SRA/SDS, TSD, Test Plans, Deployment Guide and more for a enterprise messaging hub.

Sr. Application Developer II

Business Analyst Consultant

Confidential

Technical Environment: Microsoft Access/Visio/ASP./Office, Embarcadero ER/Studio, Oracle, HTML, ArcGIS

• Wrote SQL queries. Created data models. Planned test strategies, authored scripts and led regression and release testing. Wrote the User Guide. Documented a Feasibility Study. Documented requirements for a dashboard reporting application.
• Authored Use Cases, workflow diagrams, and training materials for an emergency response system. Wrote HTML help.

INTERNET DESIGNER / Analyst

Confidential

Technical Environment: Microsoft ASP.NET, SQL Server, HTML, Embarcadero ER/Studio

Collaborated on design of a real estate school marketing and registration web product. Documented website requirements.

Confidential

IT Analyst/data architecture/BSA

Confidential

FINANCIAL Systems SUPPORT / ANALYST

Technical Environment: MS SQL Server, BusinessObjects, Oracle, Embarcadero ER/Studio, ERwin, CaliberRM,

• Provided Data Architecture services. Built and maintained a BusinessObjects universe for metadata management. Maintained the Central Data Warehouse CDW . Data Architect for the I.T. Security Data Mart.
• As Business Solutions Analyst BSA for Magic Kingdom Park, initiated technology projects for over 300 Managers and Executives. Project Lead for Disney's Golf Reservation System. Taught Traditions I for Disney University.