|
Work Experience
|
|
BUSINESS INTELLIGENCE LEAD
|
Dallas, TX
|
|
RBA Consulting
|
6/2011 - Present
|
|
Brought in to build Business Intelligence service line, assess scope of BI offerings, and work with sales and Microsoft BI teams to support clients. Developed sales demo and presented to prospective customer in cooperation with sales team. Key results: - Designed and developed report health dashboard for publicly traded, multi-billion dollar corporation.
- Created proposal and Statement of Work for an international corporation regarding full scale BI implementation.
- Gathered and translated business requirements from subject matter experts and end users into technical specifications.
-
|
|
DATA WAREHOUSE ARCHITECT and BI SOLUTION DEVELOPER
|
Dallas, TX
|
|
AmWINS Insurance Brokerage (formerly Colemont insurance Brokerage) through Max-Sys Solutions
|
12/2009 - Present
|
|
Designed and developed star schema based data warehouse and ETL process. Worked with Business Development team to gather requirements and create OLAP cube in SSAS 2008. Created reporting model for self-service enterprise use for consumption through Performance Point and Sharepoint. Developed numerous reports in SSRS to replace existing Excel based reporting solution. Key results: - Evaluated existing BI solution, identified areas for improvement, and suggested new data model and reporting solution that involved integration of both self-service and IT developed reports.
- Developed OLAP cube containing 18 years worth of sales data. Included multiple dimensions and measure groups, complex date related calculated fields, KPIs, and conditional formatting.
- Designed and developed data warehouse based on operational systems and optimized for enterprise wide reporting. Data warehouse was designed using SQL Server 2008 and pulled data from servers running SQL Server 2000, 2005, and 2008.
Assignments: - Colemont Insurance Brokers: 12/2009 to Present
-
|
|
BI DATA WAREHOUSE and REPORT DEVELOPER
|
Dallas, TX and Birmingham, AL
|
|
ZeroChaos
|
5/2009 - 12/2009
|
|
Developed full scale reporting solutions using SQL Server 2008 and SSRS 2008 which included the design and development of a warehouse database; complete ETL process; and reporting suite. Gathered requirements from various users on projects involving multiple companies. Documented design work and provided data dictionary and multiple templates for report developer who would inherit the product. Key results: - Created a reporting suite for finance department for financial client.
- Assembled and converted business requirements from multiple developers and users spanning across more than one company into technical specifications and data warehouse design.
- Trained report writer on how to use Star Schema Data Warehouse and SSRS 2008
Assignments: - IBM/Imagine Solutions/Regions Financial Corp: 5/2009 to 10/2009
-
|
|
MANAGER OF DATA STRATEGY AND MODELING
|
Dallas, TX
|
|
Broadlane, Inc.
|
3/2007 - 4/2009
|
|
Responsibilities included developing a business centric data warehouse model which replaced an archival structure as source of BI reporting. Developed process for incorporating data into a scalable reporting environment designed to facilitate end-user business requirements. Managed adopted process which allowed IT projects an avenue for satisfying reporting requests while integrating new data into warehouse environment. Liaison with IT BI group to facilitate Microsoft and Cognos based solutions and with executive level staff to create data strategy to be adopted company wide. Key results: - Created a reporting suite for finance department that made live data readily available.
- The same data was previously only available as a static data set that was created once a month by two managers and a director over the course of 3 days each month. At the company's average rate of $50/hour for internal employees, this one reporting suite saved $3,600 a month ($43,200 a year).
- Created a dahboard for analysis group using benchmarked data that was delivered to external customers
- The same data had previously been the sole responsibility of one full time manager. This dashboard enabled the manager to take on new projects and responsibilities while still having the benchmark reports available for customer use. At the company's average rate of $50/hour for internal employees, this one dashboard saved $102,000 a year.
- Designed multi-dimensional SQL database structures for numerous projects using common dimensions within a singular data warehouse environment.
- Created OLAP cubes in SQL Server Analysis Services 2005 & 2008 for company wide use. The data being compared in the cubes had never been available together in the same application previously.
- Developed analytical and reporting solutions using SSRS 2005/2008 (Reporting Services), SSAS 2005/2008 (Analysis Services), and Cognos 7/8.
- Gathered and translated business requirements from subject matter experts and end users into technical specifications and data warehouse design.
- Directed multiple teams to create a comprehensive data structure and strategy for company.
- Managed and directed upgrade from Cognos 7 to 8 and later from Cognos 8 to SSRS 2008.
- Documented CMMI Level II Process for gathering business requirements and integrating data with warehouse.
-
|
|
TEAM LEAD FOR SUPPLY CHAIN DATA MANAGEMENT
|
Dallas, TX
|
|
Broadlane, Inc.
|
11/2005 - 2/2007
|
|
Responsibilities included directing team of developers which focused on the analytics and improvement of healthcare supply chain related data issues. Developed improved applications, more effective procedures, and data handling processes. Personal initiative in expanding job description has led to concurrent responsibilities included handling all incoming customer item masters, continued development of contract and pricing diagnostics of item masters and accounts payable information, and facilitation and support of multiple cleansing, quality assurance, and maintenance teams. Key results: - Directed team and collaborated with other departments in the development of processes to improve item master integrity which helped to identify ordering errors, contract disputes, and providers paying the wrong prices for their supplies.
- Streamlined a process (previously requiring 40+ contractors) to be effectively completed by a team of 4 full time employees. At an average rate of $65/hour for contracted resources and $50/hour for internal, this saved the company $19,200/day ($2,448,000 over the remaining 6 month period of project).
- Managed data flow and facilitated successful completion schedules for highly critical data management project.
- Researched, developed, and established internal application for multiple customer item masters and accounts purchasing data which reported purchasing price discrepancies, errors within contracting matrix, item master integrity, unrecognized vendors and products, and side by side comparisons of each customer. Functionality of this application beneficially affected multiple departments, improved recognition rates of vendors, products, and contracts, and led to increased savings and revenue.
- Advised as subject matter expert and helped direct large scale proprietary software development which was implemented for all customer cleansing and maintenance groups within company.
- Created training material and taught classes on MS Access 2003, MS Enterprise Manager 2000, MS Query Analyzer 2000, Dataflux Power Studio 7.0, and other proprietary applications.
- Organized regularly scheduled focus groups for the purpose of improving inter-departmental relationships and proactive process improvements.
-
|
|
TEAM LEAD FOR ITEM MASTER QUALITY ASSURANCE ANALYSIS
|
Dallas, TX
|
|
Broadlane, Inc.
|
8/2004 - 11/2005
|
|
Quality assurance analyst with solid knowledge of healthcare related vendor and product knowledge. Extended job responsibilities to include interactive support for multiple customer related groups and India outsource provider. Key results: - Developed improvements and process standardization for quality assurance regarding item master cleansing projects.
- Partnered with research analysis teams to develop application which housed the item master quality assurance review environment.
- Enabled offshore provider to effectively maintain continuous data interaction between disconnected networks and databases.
- Supported migration of cleansing and maintenance processes and databases from MS Access based architecture to SQL Server 2000 environment with total database structure and application enhancements.
- Asked to assess underperforming data management group and made recommendations for procedure and structural improvements resulting in process reorganization and change in position and responsibilities.
-
|
|
ANALYST FOR ITEM MASTER RESEARCH, CLEANING and ANALYSIS
|
Dallas, TX
|
|
Broadlane, Inc.
|
12/2003 - 8/2004
|
|
Healthcare related product and vendor research analyst. Extended job responsibilities to include acquisition of information regarding vendor websites, vendor research and classification, and documentation of current processes and procedures. Key results: - Researched healthcare and related products for item master maintenance and cleansing initiatives.
- Created comprehensive Access and SQL database of vendor websites which became a standard resource for multiple groups
- Investigated manufacturer, distributor, and service vendors and maintained classification and relational information in both internal and customer databases.
- Defined basis for ETL (extract, transform, and load) procedures for major customers.
- Partnered with coworkers, customers, and vendors to meet and exceed scheduled SLAs.
- Collaborated and managed the creation of training documentation for item master cleansing, vendor research, and customer database import procedures.
-
|