Business Intelligence Master’s Program

SetFocus, LLC — www.setfocus.com

August 2001 to October 2011

The SetFocus Business Intelligence Master’s Program is an intensive, hands-on, project oriented program where participants add knowledge to valuable experience; putting the Business Intelligence skill set to use in a simulated work environment.

• Implemented a Labor Analysis Business Intelligence solution for a national construction company.
• Excellent SQL and Database experience in MS SQL, Informix, Oracle, and Access Consolidated data from diverse data sources into a uniform SQL Server 2008 R2 database. Used SSIS as the ETL tool to define imports of data, build scheduling packages, define integration flow, log data error exceptions and orphaned data, define Database Maintenance Plans and send emails.
• Created cubes and dimensions to report on business critical KPIs using SSAS to represent aggregations hierarchically and in custom groupings, enabling the company to analyze performance. Created MDX queries according to business requirements.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Implemented Business Intelligence Excel Power Pivot and SharePoint resources to deliver summary results based on user view and role membership.
• Using SharePoint 2010 and Performance Point Server 2010, an MS SQL Server 2008 R2 data source, and a user friendly and accessible SharePoint interface, created and deployed score cards featuring executive summary measures for revenue, overhead costs, material purchases, labor and profitability trends and performance in aggregate or by employee, region, and/or quarter using end user filter selection.
• Key product areas used included data modeling, SSRS standard and data driven report subscriptions, SSAS analysis services processing tasks, cube processing options and roles.
• Studied and reviewed application of Kimball data warehouse methodology across various industries. Worked with data-handling scenarios such as multiple hierarchies and data-driven KPI goals, sourced either from dimension attributes or fact tables, handling Type-2 slowly changing dimensions, writing, tuning and optimizing T-SQL queries.

Experience

Family Rehabilitation and Independence Assistance, IT Recruiting Assistance
2009 to 2011

Personal support for life skills training for adaptation to blindness and return to independence.

• Assisted rehabilitation professionals with training of orientation and mobility, life skills, Braille and other adaptive skills.
• Assisted with the development of professional level presentation programs to enable persons who are not disabled to better understand how to work with and relate to persons who have disabilities.
• Provided SQL and database guidance to colleagues and assisted with recruiting for IT contracts and positions.

Conversion and Data Consultant and Analyst,
1998 to 2009
Independent Contractor to Elite and others
1996 to 1998
Elite, A Thomson Reuters Company

The world premier provider of financial, accounting and management systems for law firms and professional service firms of all sizes.

Planned, managed, processed and reviewed conversion projects, data integrity audits, and data change projects for financial and related systems in legal, professional and consulting practices. Coordinated activities of client, Elite and third party members of the implementation team.

• Wrote specification and code for consolidated T-SQL review of converted data reducing conversion review time by 20+% and assuring completeness and quality of data reviews.
• Principal analyst and coordinator for multiple conversions and data mergers for long term projects at two of the world’s largest law firms. changes.
• Presentation of T-SQL, database structure and other classes for internal staff and clients.

Education

• University of Virginia, B.A., Economics
• University of Maryland, Accounting