SUMMARY:

• Confidential offers over 20 years experience including more than 15 years specializing in the design, development and implementation of business intelligence solutions.
• During his career he has held positions ranging from DBA to developer to technical architect to project lead to corporate director.
• Confidential brings expert level skills to all areas of a project including: requirements gathering, data architecture, database design and front - end implementation.
• Moreover, Confidential is a dedicated problem solver with demonstrated abilities for both understanding and explaining issues from business as well as technical perspectives and, his project successes are characterized by a hands-on motivational leadership style.

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 2000 Advanced Server, NT 4.0, Win 95/98

RDBMS: Oracle 9i, 8i, 8, SQL Server, DB2

OLAP Client Tools: Member MicroStrategy Beta Test Team, MicroStrategy 8, 7i, 7.0, 6.0, 5.0

Development: Data Modeling: ERWin, Visual Basic

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Business Intelligence Architect

Responsibilities:

• Review existing projects and reports for Best Practices. Develop new SQL Reports and SAS reporting
• For the Medicare Part D reporting group. Architected Teradata Schema to convert a Access DB reporting
• System to allow for future expansion Banking and
• Stored Procedures to create SAS code for data manipulation.
• Created new Tableau reports to support the daily Audit functions for Auditors and Management.

Key Technologies:

• SAS
• MicroStrategy Version 10
• Teradata
• Tableau
• Advanced Excel (Pivot Tables and VLookup)
• SQL Server Business Intelligence Stack

Confidential, Phoenix, AZ

Business Analyst / Architect

Responsibilities:

• Review existing MicroStrategy projects for Best Practices and suggest changes to procedures and security to best optimize their Business Intelligence efforts.
• Developed a Roadmap to enable them to move and secure a new Live project environment. Worked with Business Users to develop requirements for future Dashboards and the
• Requirements for a self-service Visual Insights project.
• Architected Security Filters on their data to limit the data returned according to their Job and enable users according to their roles to limit data to only show for their role

Key Technologies:

• MicroStrategy Version 10
• SQL Server Business Intelligence Stack

Confidential, Phoenix, AZ

MicroStrategy Application Architect

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds. Installed and initialized
• MicroStrategy project to add tables and to create the Schema Objects to meet the Star Architecture requirements. Met with the Marketing Business Users on
• Converting existing Excel reporting to be pulled from the Data Warehouse by BI tool. Worked with the Teradata
• DBA on designing and implementing the Views to be used by MicroStrategy. Installed and setup their initial MicroStrategy Development environment.

Key Technologies:

• MicroStrategy Version 10.2, Tableau
• Teradata 14.10

Confidential, Phoenix, AZ

Technical Lead Developer / Architect

Responsibilities:

• Spearheading project to implement Tableau Visual Insights and Self-Service Analytics Internationally.
• Uplift of MicroStrategy 9.01 to 9.41
• Analyzed Visual Insight Tools to meet specific business needs using Hadoop Big Data(Networking Visualizations)
• Creating Reports, Dashboards, and Visual Insights using Tableau for the VP of Banking to monitor the performance of the Network.
• Worked with Business Users to introduce and create dashboards for the business.
• Worked fine tuning Reports and SQL for performance enhancements
• Updated and built new Visualization Insights using Version 10 of MicroStrategy.
• Developed High Availability and Disaster Recovery Plans for MicroStrategy Environments.

Key Technologies:

• MicroStrategy 9.41, (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Delivery Services, and Narrowcast, Web Visual Insights, and Desktop Visual Insights.), MicroStrategy Version 10
• Netezza, Oracle, and Teradata 14.10
• Hadoop Big Data
• Tableau
• Advanced Excel (Pivot Tables and VLookup)
• Crystal Reports

Confidential, Las Vegas, NV

Sr. Business Intelligence Analyst

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new Reports that will be available from the various new data feeds.
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and Dashboards to provide Business Users with Analytics.
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

• MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
• SQL Server
• Tableau

Confidential, Warren, NJ

Architect

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new Reports that will be available from the various new data feeds delivered on Mobile IPads..
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and design Mobile Dashboards to provide Business Users with Analytics.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting tool and Mobile delivery.

Key Technologies:

• MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast)
• Oracle, Teradata 14.10, and SQL Server

Confidential, Costa Mesa, CA

Architect

Responsibilities:

• Led requirements gathering involving the principals of the project and business users.
• Analyze all Data and Build all MicroStrategy Schema Objects
• Build reports and Dashboards to provide Business Users with Analytics.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting tool.

Key Technologies:

• MicroStrategy 9.30 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, Mobile, and Narrowcast)
• Oracle and SQL Server

Confidential, San Francisco, CA

Architect

Responsibilities:

• Took on a special project to enable the use of LDAP server in MicroStrategy
• Worked with the MicroStrategy Administrators to define groups and user hierarchies to enable future flexibility
• Work with the Business Users to define analytics and Data Architecture required for the existing reports and the new Reports that will be available from the various new data feeds.
• Build reports and Dashboards to provide Business Users with Analytics. Rolled out for daily reporting by all stores.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new datasets of and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

• MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
• DB2 and Teradata 14.10 Database

Confidential, Chandler, AZ

Lead Developer

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new Reports that will be available from the various new data feeds.
• Build reports and Dashboards to provide Business Users with Analytics.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

• MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
• SQL Server and Teradata Database

Confidential, Richland, WA

Senior Architect / Lead Report Developer

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new
• Reports that will be available from the various new data feeds.
• Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of data and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

• MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
• Sybase Database

Confidential, Burbank, CA

Senior Architect / Lead Report Developer

Responsibilities:

• Work with the Business Users to define analytics required for the existing reports and the new Reports that will be available from the various new data feeds. Worked with ETL developers to outline new data fields.
• Build reports and Dashboards to replace and enhance current manual Excel spreadsheets.
• Client adopted and expanded Dashboards and Enterprise View Report Objects reports.
• In the Architect role I built out a new set of data from upgraded Siebel System and create new
• Reports and Dashboards using MicroStrategy as the reporting too tool.

Key Technologies:

• MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Dashboards, and Narrowcast)
• DB2 Database
• Advanced Excel

Confidential

Acting Senior Architect

Responsibilities:

• Collected reporting requirements from the business users based on the existing and new data sources.
• Review existing projects and evaluate current Schema to add new data sources.
• Architected a new set of data sources and added them to the current project. Created new Reports, Dashboards, and Scorecards using both IBM Cognos tool and MicroStrategy.

Key Technologies:

• MicroStrategy 9.02 (Desktop, Architect, Intelligence Server, Report Services, Narrowcast)
• IBM Cognos
• Teradata Database

Confidential

Acting Senior MicroStrategy Architect

Responsibilities:

• Interviewed the business users and the current project personnel to draw up a project plan for the Architectural changes requested and outlined the steps to implement them.
• Review existing projects as MicroStrategy Architect and evaluate consolidating Dimensions and removing Duplicates.
• Interpret MicroStrategy Integration Manager results to pinpoint Reports that need to be changed for new consolidated data structures I have Architected and created.
• Documented all changes and created a roadmap to the data for both before the changes and after the Architect changes for future reference.

Key Technologies:

• MicroStrategy 8.11 (Desktop, Architect, Intelligence Server, Report Services, Narrowcast)
• MicroStrategy 9 (Integration Manager)
• Teradata Database