TECHNICAL SKILLS:

Microsoft SQL Server: RDBMS 7.0 to 2016; SSAS 2000 to 2016; SSRS 2005 to 2016. SSIS 2005 to 2016. Conducted a 3 - week SQL Server 2005 proof-of-concept at the Microsoft Technology Center in Dallas. SSRS Course 6236; PASS 2014 Presenter, 2011 & 2012 Attendee, Tech Ed 2005 (BI track).

Azure Cloud: HDInsight/Hive; SQL Server; Power BI; Confidential, Azure AD

Cognos: PowerPlay 6.5 to 8.4 (Enterprise Server, Web, Windows, Excel, and Transformer); Impromptu 5 to 7.4; IWR 5 to 7.4; Access Manager, Architect to 7.1; Confidential Query 6; CognosScript; Confidential Visualizer 7; ReportNet 1.01 to 1.1 MR3; Confidential 8.0 - 10.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Confidential Planning 7.3; Confidential Finance 7.3; DecisionStream 7.2. Received CornerStone Training ( Confidential non-public classes), Received Confidential Public Training in Confidential Planning, PowerPlay Transformer, Impromptu, IWR. Attended 2004 and 2006 User Conferences

Business Objects: Designer 6.5 to XI R3; WebIntelligence (6.5 to XI R3); Crystal Enterprise 10 to XI; Crystal Reports 10 to 2011; OLAPIntelligence/CAP 10 to XI; EPM/Application Foundation 6.5 to XI R2; InfoView 6.5 to XI R3, Business View Manager 10 - XI R3 . Received training from Business Objects in Enterprise Administration XI, Security Administration XI, WebIntelligence Design XI. Attended 2004 and 2005 User Conference

Hyperion: Essbase 6.1 to 7.1. Received training from OLAP123 in Essbase Development 6.x and 7.x

Additional Software: Tableau (client and server), DocXpress, Visual Studio 2010 - 2017; SharePoint 2003 - 2013; Trillium Quality; ClearCase; Sun ONE Directory Server; Control-M; Microsoft IIS; MS Office 95 to 365 (Access, Word, Excel, PowerPoint, and Publisher); ACT ; Adobe Photoshop 3.5 to CS4; Adobe PageMaker 6.5; MS Project 98-2010; Visio; Lotus Notes; Windows Client 3.x-10, Windows Server NT - 2012 R2; MS-DOS; FrontPage 2000; Macromedia Dreamweaver; Oracle 8-11g.; DB2; Sybase; Teradata; ModelRight; Embarcadero ERStudio 7; Toad thru 12.10; SQL Navigator; Oracle Enterprise Manager; PL/SQL Developer; SQL+; UNIX AIX; HPUX; Sun Solaris; F5 Big IP

Hardware: Familiarity with enterprise hardware planning and virtualization

EXPERIENCE:

Confidential

AVP of Business Intelligence

Responsibilities:

• Tool evaluation for implementation of a business intelligence and data warehouse ecosystem
• Implementation of a full stack SQL Server 2016 BI/DW solution
• Creation of standards and practices documentation for cube, report, ETL, and data warehouse design, development, deployment, and troubleshooting
• Creation of dashboards and a digital signage solution for displaying corporate metrics throughout headquarters
• Management of the BI/DW team and application development team
• Assist with application development efforts, troubleshooting, etc.
• Assist with the upgrade and migration from TFS 2008 to Confidential

Confidential

BI Developer

Responsibilities:

• Troubleshooting and remediation of Integration Services issues
• Modification of existing metrics and dashboards
• Worked with executives to create strategic reports

Confidential

Principal Consultant

Responsibilities:

• Led consulting efforts, providing architectural design, direction, and guidance
• Managed onshore, remote, and offshore resources on projects
• Designed, developed, and delivered BI and data - related solutions
• Sales support and pre-sales presentations for managers to C-level

Confidential

Business Intelligence Lead

Responsibilities:

• Mentor and assist developers on the business intelligence and ETL teams
• Assist with tool evaluations and implementations, including Tableau 8.4 and DocXpress
• Member of the data warehouse architecture working group
• Develop cubes, reports, dashboards, ETL, stored procedures, views, tables, automation scripts, and batch utilities
• Perform deployments and troubleshooting
• Developing dynamic SSAS processing and partitioning framework using SQL Server RDBMS and SSIS
• Assist with supporting the BI platforms
• Perform code reviews to ensure appropriate practices and procedures are followed

Confidential

Business Intelligence Manager

Responsibilities:

• Managed the enterprise business intelligence team
• Responsible for convincing IT executive management to convert the enterprise BI implementation from Confidential to SQL Server/SharePoint solution to better align technology stacks across the enterprise
• Prototyped and developed operational and executive dashboarding solutions using native SQL Server Reporting Services feature/functionality
• Architecture, installation, and configuration of clustered SQL 2012 environments
• Developed SharePoint homepages that integrate PerformancePoint reporting for business units
• Created and conducted presentations of Microsoft BI solutions to IT and business users
• Worked with key business users to drive utilization of Microsoft BI solutions
• Manage project workloads and delegated responsibilities to team members
• Develop and deploy Analysis Services cubes, utilizing partitions, calculations, and actions to enhance the user experience

Confidential

Consultant - Writer

Responsibilities:

• Business intelligence consulting
• Writing a novel and short stories

Confidential

Business Intelligence Architect

Responsibilities:

• Tasked with setting direction of business intelligence solution
• Created training and conducted weekly education sessions for developers
• Designed template models for use by developers
• Created best practices for data model, semantic layer, and reporting
• Created critical client reports

Confidential

Business Intelligence Developer/Platform Administrator/Project Lead

Responsibilities:

• Project lead on data mart projects, with responsibilities including physical model development, source to target mappi ngs, assisting with ETL development, reporting and analytics requirements gathering, working with application technology groups and business customers, and ongoing support
• Developed Universes, including restriction sets for row level security and Crystal Reports on Universes for data mart projects
• Development of reporting for SAP HCM in Crystal 2008 deployed via Business Objects Enterprise
• Assisted with custom database design elements of the HCM RapidMart
• Developed Business Views for use with dynamic parameters and Crystal reporting
• Platform administrator for SQL Server 2008 BI environment, including installation and DBA duties
• Backup administrator for Business Objects Enterprise and Data Services
• Upgrade and migration of SQL Server 2005 to 2008
• Development and enhancement of Analysis Services cubes
• Development of security and audit system using SSIS, SSRS, and SQL Server RDBMS, including relational database design spanning metadata for multiple BI platforms
• Development of ETL, database, and reporting to assist customers with data validation efforts from legacy to replacement systems using SSIS and SQL RDBMS
• Deployed and supported SAS 9.2 environment for proof of concept
• Platform administrator for Confidential BI environment
• Crystal Report XI and 2008 development

Confidential

Business Intelligence Senior Developer/Analyst

Responsibilities:

• Developed Analysis Services 2005 cubes for international rollout
• Developed Confidential Framework Manager models for international rollout
• Taught Analysis Services and Confidential classes to users in China
• Developed teaching materials and documentation
• Assisted with relational modeling of a data mart
• Created Integration Services packages for data mart ETL
• Created Reporting Services reports
• Created reports in Query Studio, Report Studio, and Analysis Studio
• Lead developer on proof of concept initiative for PerformancePoint 2007
• Installation and configuration of Confidential 8.2 environment
• Integrated reporting with Office 2007

Confidential

Business Intelligence Lead/Manager

Responsibilities:

• Led business intelligence and data warehouse project efforts
• Managed team and projects
• Worked with customers to develop requirements for reports, analytics, and data marts
• Assisted with developing the budget for BI and data warehouse needs
• Project manager and lead engineer for development of overall enterprise data security strategy, architecture, and implementation
• Project manager and lead engineer for development of overall business intelligence strategy, architecture, standards, processes, and procedures
• Lead engineer for development of overall enterprise data warehousing strategy and implementation
• Responsible for licensing analysis, vendor relations, and assisting with negotiations
• Development and production implementation of ReportNet 1.1 MR3 on Windows and Cogonos Planning 7.3
• Logical data modeling for human resources data mart
• Administration of Confidential BI (PowerPlay, ReportNet), Confidential DecisionStream UNIX, Confidential Finance, and Confidential Planning platforms
• Responsible for SOX compliancy documentation of Confidential platforms
• Evaluation and implementation of the Confidential 8 platform
• Planned upgrade and migration from Confidential 1.1/7.3 to Confidential 8
• Evaluation of Microsoft SQL Server 2005 and Microsoft Office business intelligence solutions, including Analysis Services and Reporting Services development (currently migrating to Analysis Services 2005)
• Evaluation of data profiling, data quality, and data modeling tools
• Development of automation and auditing solutions for the Confidential platforms
• Maintenance and enhancement of existing SQL Server 2000 Analysis Services cubes

Confidential

Technical Architect/BI Administrator

Responsibilities:

• Recommended strategic direction of tools and development of BI
• Architected BI platforms and environments
• Defined best practices and developed strategic roadmaps for tool utilization
• Member of the technology advisory board
• Worked with technical architects from other IT groups to ensure cooperation and compliance with technology stacks and standards
• Project manager and lead developer for SQL Server 2005 POC, including a 3 week on-site evaluation at the Microsoft Technology Center in Dallas
• Researched and evaluated BI-related tools for master data management, data profiling, dashboarding, scorecarding, and other functions
• Performed financial analysis of licensing and maintenance costs of BI platforms in use and under evaluation
• Implementation and administration of Business Objects EPM environment
• Developed Universes and WebIntelligence reports for dashboarding
• Mentored junior business intelligence developers
• Helped design multi-platform enterprise data security solution
• Administration of the enterprise Confidential environment
• Implementation and administration of SQL Server Analysis Services environment

Confidential

Senior Consultant

Responsibilities:

• Essbase consulting and development
• Data analysis and validation
• Simple ETL processes

Confidential

Confidential Architect/Administrator/Business Analyst

Responsibilities:

• Installed, upgraded, and migrated multi-server Confidential 7.1 environment
• Assisted with development of several datamarts
• Architected and installed multi-server Confidential 7.1 implementation
• Designed and created cubes and reports, including sub-reports and drill-through
• Designed and implemented automation scripts
• Designed and implemented integrated Confidential and database security
• Interviewed end users and report developers to determine needs
• Assisted with architecture and infrastructure requirements
• Systems analysis to support upgrades and modifications
• Produced discovery documentation to capture findings and present recommendations
• Assisted with troubleshooting and maintenance issues
• Provided technical and business analyses to assist with tool selection

Confidential

Confidential Architect/ Confidential Administrator

Responsibilities:

• Built Confidential BI Enterprise reporting solution for production, development, training, and test environments consisting of over 20 servers, including 3 Windows 2000 clusters and UNIX servers (high-availability multi-server production environment, multi-server development environment, multi-server test environment)
• Performed troubleshooting and maintenance duties for Confidential software on UNIX and Windows platforms
• Performed troubleshooting and maintenance of Windows servers including OS, IIS, and cluster services
• Published cubes, reports, queries, and visualizations to Confidential Upfront
• Developed cubes, reports, catalogs, architect models, queries, and visualizations
• Developed custom CognosScript and Javascript solutions

Confidential

Confidential Architect/BI Reporting Team Technical Lead

Responsibilities:

• Ran and maintained a reporting and analysis system supporting several hundred clients and produced thousands of reports per month.
• Constructed multi-server Business Intelligence environment consisting of 8 total servers including Upfront, IWR, PowerPlay Transformer, PowerPlay Enterprise Server, Impromptu, Access Manager, Confidential Query, Netscape Directory Server, and IIS (built against an Oracle datawarehouse).
• Built architecture for development and production environments
• Constructed multi-server IWR environments
• Developed project plans for BI rollout
• Built stand-alone servers with the full Confidential product suite for conventions and demonstration purposes.
• Customized Upfront portal
• Created CognosScript macros for report automation
• Built Confidential Query proof-of-concept and demonstration models
• Automated cube promotions from stage to production
• Created Access Manager security environment
• Troubleshooting and maintenance of BI development and production environments (including version control, file management, and promotions from development to production).
• Created Impromptu catalogs and Architect models
• Created iqd and mdl files for cube generation
• Created Impromptu reports against source and datawarehouse systems
• Assisted with development of prototype for second-generation datawarehouse and BI reporting.
• Assisted with database security implementation
• Designed and built small office network for a mortgage brokerage firm

Confidential

Confidential Engineer

Responsibilities:

• Business Intelligence project planning
• Assisting with datawarehouse development
• Confidential Business Intelligence suite installation and maintenance
• Constructing multi-server development and production environments
• Writing standard reports in Impromptu and building PowerPlay cubes
• Creation and maintenance of Upfront web portal
• Automation of processes through the use of macros

Confidential, Irving, TX

Consultant

Responsibilities:

• Enterprise-wide software installations of Confidential suite
• Designing cubes, catalogs, and reports for several large companies
• Instituting security via LDAP and database security
• Instructing classes in several Confidential technologies

Confidential, Alexandria, VA and Arlington, TX

Financial/Systems Consultant

Responsibilities:

• Financial analysis of multi-family tax credit properties
• Assisted with strategic planning and business development
• Performed HR management duties such as hiring and policy-making
• Project manager for real estate finance projects ranging in dollar value from $4 million to $60 million
• Managed investment projects and staff
• Researched and wrote investment proposals for multi-million dollar projects
• IT Administrator responsible for all office systems
• Performed troubleshooting, Help Desk, and software evaluation duties
• Built and administered web sites for consulting firms