Interpret the business logic required to turn a complex idea into a sustainable value add process.An eye for detail, good data intuition, and a passion for data quality.

Got data? Good. Is it messy and confusing? Great.Is it stored in the most obscure places and ways? Even better!Working with varies stakeholders to deliver measurable and meaningful results from beginning to end. Tasks include project requirement gathering, business rules documentation, data gathering, data modeling, ERD design, building data warehouse table structure DML DDL, implementing indexes, query performance tuning/optimizing, design, build SSIS ETL packages, deploy work product to varies environments, scheduling jobs, custom dynamic email generation, Tableau dashboards, and more. A sample of the tools and services used SQL Service Integration Services (SSIS)SQL Service Reporting Services (SSRS)SQL Service Management Studio (SSMS)SQL Server Data Tools (SSDT)SQL Server 2008, 2014Team Foundation Server (TFS)Visual StudioTableau 10C#.NetGoogle AdWords APIBing Ads APIREST API backend interface

Visualize data from in-house data warehouse using T-SQL, Tableau, SQL Server Reporting Services (SSRS), CUBEs. Manage multiple projects with respect to priority, changing/flexible timelines simultaneously based on end users or managements needs. Provide ad-hoc request support with prompt and timely response. Other technical skills, T-SQL Stored Procedures, T-SQL Dynamic Query, Open Query, MDX Query, MDX Microsoft Analysis Services.

• Assist in the preparing presentation material for executive team leaders and board of directors relating to real estate acquisitions.• Provide back office support from pre-search to the closing of potential properties that assist our acquisition specialist in the field. Locate potential properties using online sources such as CoStar, research objectionable uses, zoning, ordinances, competitors, score/rank potential sites with the use of Nielsen Prime Location tool, conceptual site layout designs, household demographic information for traffic analysis/study, and more.• Work alongside in-house Architect to manage, parametric model, and provide analytic insight for a portfolio of over 3,000,000 SQFT real estate; AutoDesk Revit.• Create data visualizations and dashboards utilizing Tableau to assist with business decision making based on portfolio data and internal data sets.• Maintain and oversee the archiving of real estate related transaction documents both physically and digitally using OnBase document management.Sample of software tools used frequently: Tableau, AutoDesk Revit, Adobe Creative Suite (Photoshop, Illustrator, InDesign), CoStar, Nielsen, Google Earth Pro, SQL (basic).

• Portfolio: Single family homes• Providing rental housing in downtown Grand Rapids, MI near the Grand Valley State University campus since 2007.

• Provide internal and external technology support for Charter Schools Office employees and visitors• Provide hands on training for teachers and administration at 36 Charter Schools.• Maintain office equipment inventory, department website, purchasing of equipment, and perform general administrative duties.• Implemented and maintain online CRM, event registration system, and e-newsletter software and databases.

• Performed computer repair, general troubleshooting, and new computer installs to campus of 1,000+ faculty and staff

Provide assistance in preparing appraisal reports using ACT! software. Task include the researching of current as well as past real estate sales on single and 2-4 unit multi-family housing. Also, perform calculations on current market supply/demand for target neighborhood and forecast possible DOM (Days On Market). Ultimately providing the data that is required to make an accurate and honest appraisal value of a property based on current market data.