SUMMARY:

• Experienced Business Intelligence Professional with over 20 years of experience in business analysis, information systems development, financial analysis, marketing and operations. Possess diverse business experiences that drive technical solutions and produces results. Effective in developing technical solutions at enterprise and mid - level firms.
• Excellent communication and interpersonal skills to work independently as well as in team settings; comfortable interfacing with all organizational levels.
• Seasoned IT Professional with a unique business perspective that includes: customer focus/market awareness, financial acumen, database development, and operations management; gained through MBA, international work assignments and experience with Fortune 500 corporations.
• Eager to develop innovative business intelligence systems which drive decisions leading to outstanding results.

TECHNICAL SKILLS:

Technologies: Microsoft SQL Server 2005, 2008, 2012 Integration Services (SSIS), Analysis Services (SSAS), Master Data Services (MDS) and Reporting Services (SSRS), Microsoft Office SharePoint Server 2007.

Databases: Microsoft SQL Server 2000, 2005, 20008, Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP).

Software: Microsoft Visual Studio .NET 2005, 2008, 2010 Microsoft SQL Server Business Intelligence Development Studio (BIDS), Microsoft Visual Source Safe, Microsoft Visio, Microsoft Office (Word, Excel, Power Point), Crystal Reports, Adobe Photoshop, Adobe Illustrator.

Languages: ASP.NET, HTML, CSS, TSQL, MDX, MS Visual Basic Scripting, MS Visual Basic .Net

PROFESSIONAL EXPERIENCE:

Independent Business Intelligence Consultant

Confidential, Austin, TX

Responsibilities:

• Full data warehousing analysis, architecture, and implementation including: Data Modeling (Kimball methodology), Business Analysis, Relational Database Development, Multidimensional Database Development - OLAP, ETL (Extract, Transform and Load) Procedures, Data Validation and Cleansing, Master Data Services, Report Development, Dashboard Development.
• Data warehousing business analysis and implementation strategy.
• Served as lead technical architect for banking solution including data analysis, data architecture, ETL design/implementation and technical requirements documentation.

Confidential, Austin, TX

Responsibilities:

• Provided data warehouse production support and backup database administrator support.
• ETL Architecture and development for systems implementation.
• ETL maintenance and development using SSIS and SQL.
• Data analysis and research support.

Senior Business Intelligence Consultant

Confidential, San Antonio, TX

Responsibilities:

• Senior Business Intelligence Consultant for Confidential
• Full data warehousing analysis, design, and implementation including: Data Modeling, Business Analysis, Relational Database Development, Multidimensional Database Development - OLAP, ETL (Extract, Transform and Load) Procedures, Data Validation and Cleansing, Report Development, Dashboard Development.
• Industry work in telecommunications, insurance, professional services, banking, consumer products and government.

Independent Business Intelligence Consultant

Confidential, Austin, TX

Responsibilities:

• Completed end-to-end corporate level BI dashboard solution for an insurance company including ETL, data sources (OLAP and relational), PerformancePoint, SharePoint, Reporting Services, Excel Services.
• Provided data modeling and ETL packages for a state government agency’s decision support system.

Data Warehouse Architect/Modeler

Confidential, Austin, TX

Responsibilities:

• Conducted enterprise data warehouse analysis and modeling, using Kimball methodology, at a Fortune 500 semiconductor company.
• Worked toward documenting data flows, creating source to target mappings and consolidating data into dimensional models.
• Designed and implemented SQL Server 2008 data warehouse components including schemas, tables, views, stored procedures, and functions.
• Provided implementation strategies for Microsoft Business Intelligence tools including SQL Server Reporting Services reports, PerformancePoint dashboards and Confidential analytical tools.

Solutions Developer/Consultant - Business Intelligence

Confidential, Dallas, TX

Responsibilities:

• Business Intelligence developer and consultant specializing in Microsoft technologies for Confidential (jointly owned by Accenture and Microsoft).
• Assisted enterprise level customers in designing and implementing Business Intelligence strategies that fit their unique requirements and provide a complete, integrated view of their overall organizational health.
• Designed, developed and tested BI solutions using the most current Microsoft technologies including the development of data warehousing schema (relational and multidimensional), extract/transform/load (ETL) procedures and BI end products such as dashboards, scorecards, key performance indicators (KPIs) and managerial reporting, financial reporting and operational reporting.

Master’s Program - Business Intelligence

Confidential, Parsippany, NJ

Responsibilities:

• Implemented a Business Intelligence solution for a fictitious national construction company.
• Consolidated data sources into a SQL Server 2005 database. SQL Server Integration Services was used to define data imports, build scheduling packages, define integration flow, log data error exceptions and orphaned data, implement maintenance plans and send notification emails.
• Created OLAP cubes, dimensions and business critical KPIs using SQL Server Analysis Services for analytical performance. Created MDX queries according to business requirements.
• Developed detail and summary reports including line and pie charts, trend analysis 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 .
• Created score cards with executive summary dashboards using MS Office Performance Point Server 2007 Dashboard Designer that display performance monitoring measures with data from a SQL Server 2005 OLAP data source and deployed them to SharePoint sites.
• Created score cards with advanced dashboards using MS Office Performance Point Server 2007 Dashboard Designer offering executive summary measures with data extracts from a SQL Server 2005 OLAP data sources and deployed them to SharePoint sites.

Senior Business Analyst

Confidential, Tampa, FL

Responsibilities:

• Used Microsoft Reporting Services and Microsoft SQL Server 2000 tools to streamline and standardize sales reporting process resulting in cost savings, improved accuracy, and increased availability of information.
• Created enterprise wide Key Performance Indicator (KPI) reporting with drill through and parameter features which allowed end-users to make more effective business decisions.
• Developed business requirements for and participated in project management of enterprise-wide business intelligence (managerial reporting and scorecard analysis) system including user acceptance testing and post deployment .
• Provided detailed performance analytics to division, regional, and corporate executives for $5.8B Fortune 200 Company.

Specialist, Business Analyst

Confidential, Clearwater, FL

Responsibilities:

• Utilized financial insight and technical skills to provide financial analysis for co-location product ($500M annual revenue) including variance, trend, forecast, journal entries, and ad hoc requests.
• Designed and developed MS Access OLAP cube and MS Excel analysis tools that streamlined reporting processes and increased productivity - received performance .
• Developed financial models and provided upper level management with insight for decision making.
• Provided financial and analytical support to the Wholesale Markets Account Management team, including support of incurred expenses, the Sales Incentive Compensation Plan, revenue reporting support, and various added requests.

Real Estate Agent

Confidential, Austin, TX

Responsibilities:

• Independent Buyer and Seller agent for commercial and residential real estate including sales and leasing.

Senior Market Analyst

Confidential, Austin, TX

Responsibilities:

• Owned the Operational Strategic Planning Process and led senior management to customer driven opportunities.
• Identified market opportunities using target consumer groups, submarket ps, and supply/demand data.
• Assisted land acquisition functions by providing targeted consumer group supply and demand metrics and product pace/price forecasts for feasibility process.
• Assisted sales & marketing with product selection, product development, and pricing analysis.
• Conducted market research activities including market analysis, site validation studies, buyer/shopper/rejecter studies, livability studies, and customer focus groups.
• Received "Difference Maker of the Quarter" for Q2 2006.

Operations Manager

Confidential, Clearwater, FL

Responsibilities:

• Chosen for selective program to develop professionals for upper level management.
• Led teams of 15-25 employees in both call center and field operations that exceeded performance standards while meeting expense objectives.
• Created Microsoft Access database for cable maintenance tracking system which enabled department to shift from paper-based tracking system, to efficiently analyze network integrity, and to control costs.

Purchasing/Warehousing Manager

Confidential

Responsibilities:

• Responsible for purchasing and warehousing for multi-million dollar construction business
• Managed selection and implementation of information systems project (hardware and software) that allowed the accurate tracking of items and minimization of unit costs.
• Utilized personal flexibility and interpersonal skills to supervise team of 15 Russian nationals.

Assistant Project Manager

Confidential, Addison, IL

Responsibilities:

• Conducted market research including for implementation of joint-venture construction materials supply business 
• Played key role in forming management’s decision not to invest which protected several million dollars in potential loss.

Intelligence - Signals Interceptor

Confidential

Responsibilities:

• Achieved rank of sergeant and led troops in army policy, conduct and discipline.
• Received Good Conduct Medal, National Defense Service Ribbon, Professional Leadership Development Ribbon, German Sports Badge, Expert Marksman and Grenade Qualifications. Honorable discharge.