Roi Real Estate Excel

Document Sample
Roi Real Estate Excel Powered By Docstoc
					                                            Mark Wabol
                                         3730 S. Martingale RD
                                           Gilbert, AZ 85297
                                            (480) 226-5847

Detail oriented Business Intelligence Professional using SQL Server 2005 and Microsoft
Technologies. Proven track record of developing and implementing successful applications and projects to
support business objectives. Demonstrated leadership abilities and teamwork skills as well as the ability
to accomplish tasks under minimal direction and supervision.

Microsoft Technologies:
SQL Server 2005 Integration Services (SSIS), SQL Server 2005 Analysis Services (SSAS), SQL Server
2005 Reporting Services (SSRS), Microsoft Office SharePoint Server 2007(MOSS), Microsoft Office
Performance Point Server 2007, Microsoft Visio, Visual Studio 2003, Crystal Reports, Visual Studio 2008,
Dreamweaver, Photoshop, Fireworks

MS SQL Server 2005

Visual Studio .NET 2005, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2003,
Visual Studio .NET 2008

SetFocus, LLC.                           Parsippany, NJ                  Feb/09 - April/09
Master’s Program – Business Intelligence
    Implemented a Labor Analysis Business Intelligence solution for a fictitious national construction
    Existing data from diverse data sources were consolidated into a uniform SQL Server 2005
      database.     SQL Server Integration Services was used to define imports of the data, build
      scheduling packages, to define integration flow, log data error exceptions and orphaned data and
      to define Database Maintenance Plans and send emails.
    Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis
      Services representing aggregations in several different ways - hierarchically and using custom
      groupings that the company will use to analyze performance. Created several MDX queries
      according to business requirements.
    Developed several detail and summary reports including line and pie charts, trend analysis reports
      and sub-reports according to business requirements using SQL Server Reporting Services.
    Implemented business intelligence dashboards using MOSS 2007 Report Center and Excel Services
      producing different summary results based on user view and role membership.
    Created score cards with executive summary dashboards using MS Office Performance Point Server
      2007 Dashboard Designer that display performance monitoring measures for sales, sales trends,
      and book return rates for a fictitious book publisher deriving data from a SQL Server 2005 OLAP
      data source and deployed them to SharePoint sites. The dashboards also contain drill-down
      capabilities to view book sales by book category and customer, through summary reports and sales
      trend charts.
    Created score cards with advanced set of dashboards using MS Office Performance Point Server
      2007 Dashboard Designer that feature executive summary measures for revenue, overhead costs,
      material purchases, labor and profitability trends for a fictitious construction company extracting
      data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites. The
      dashboards also contain pages to view performance by employee, by region, and by quarter
      enabling end-users to make filter selections.

Fast Trax/DTG Training Systems          Phoenix, AZ                   8/04 - 2/09
Software Engineer
    Developed application for real estate investment ROI (Return on Investment) analysis with an
      HTML based training module
          o Determined user requirements, created user interface, developed logic and algorithms
             based on market conditions to calculate ROI, targeted toward the retail market.
    Application developed in VB6 and ported to VB.Net. Then added the HTML training module
    Investigated and resolved client issues
    Provided updates for bug fixes and product enhancement
    Researched and implemented copy protection into application
    Ported application to Mac OSX 10.4 with xCode (ObjectiveC) and Interface Builder

WIA (Wealth Intelligence Academy)                                    1/03 - 11/06
     Designed and developed custom websites for clients to support their real estate investing business.
     Held onsite customer meetings, working one-on-one and with small groups, training on creative
       real estate investing techniques
     Assessed individual’s strengths and provided feedback, additional training, and facilitated field
       exercises to ensure a valued experience

NCS Pearson                               Mesa, AZ                  3/01 - 8/02
Software Test Automation
    Created scripts in Silktest for automated software testing
    Participated in code reviews
    Performed manual testing for the company's SASI software on PC and Mac
    Maintained Test Records program for tracking results of manual tests with VB6/MS Access

Sea Ray Boats, Inc.                       Phoenix, AZ               1/91 - 3/01
    Responsible for hiring, training, and managing the manufacturing team
    Ensure quality standards met and product delivery timelines were met

ISO 9000 Coordinator / Lead Auditor, Phoenix Facility
    Oversaw the maintenance and ongoing development of the ISO 9000 quality system
    Maintain company compliance with ISO 9002
    Created Internal Audit System
    Designed Internal Audit Database in MS Access for scheduling and recording results and status of
    Developed and implemented Corrective Action database in MS Access
    Created and implemented document control system
    Created document control database in MS Access
    Developed calibration system & status/schedule database in MS Access
    Converted all documentation from Mac to PC

ISO 9000 Implementation Manager
    Responsible for interpreting the ISO Standards as they applied to business requirements
    Created and implemented an ISO 9000 compliant quality system to achieve business objectives
    Guided implementation team in defining business requirements and to develop and implement all
      system procedures and support documentation
    Worked extensively with MS Word, Excel, MS Access (PC/Mac)
    Led facility to achieve unconditional ISO 9002 certification.

University of Phoenix                  Phoenix, AZ
Bachelors of Science, Information Technology - Overall GPA 3.94

Shared By:
Description: Roi Real Estate Excel document sample