Mohammad Amirbayat

Summary

Business Intelligence Consultant with twelve years of experience; Expertise in design, development and implementation of Business Intelligence solutions, with a combination of technical, functional and managerial skills as well as business insight and critical analysis. Background includes requirements and analysis, knowledge in the BI and ERP solutions, big data, data visualization, business processes and performance management. Demonstrated ability to understand complex business issues, build relationships with clients, and work effectively with project team.

Areas of Expertise

Technical Skills: MicroStrategy Desktop, Architect, Web, Intelligence Server, Cognos, Business Objects, Crystal Reports, SSIS, SSRS, SQL, Microsoft SQL Server, SQL Plus, Oracle, Hadoop/Hive, RDBMS, OLAP, SAP Webi, Informatica, PeopleSoft Financials, MS Project, C++, C#, ISIO and Erwin

Functional Skills: Functional and Technical Specification Design, Agile Project Management, Requirements and Analysis, Proposal Writing and Training

Certifications: MicroStrategy Reporting, Architect and Administration, IBM Cognos Report and Query Studio, Microsoft Business Intelligence Suite and Crystal Reports

MicroStrategy Skills:

•7+ years of overall experience. Certified in Reporting, Architect and Administration.

•Experience in creating MicroStrategy Schema and application objects such as Logical tables, attributes, facts, Hierarchies, metrics, prompts, filters, consolidations, and custom groups

•Experience in Report Services, Dynamic Dashboard, Report development, visualization and working with the full life cycle development process, which includes analysis, design, development, and testing

•Ability to create simple to complex Schema Objects as per the requirements and experience in working with complex MicroStrategy reports using advanced filters, level metrics, transformation metrics and using pass-through functions in the schema objects

•Experience in implementing MicroStrategy security model Experience in Object Manager, Enterprise Manager, Command Manager, System manager and experience in performance tuning of various Reports and Dashboards using VLDB Properties

Education/Certifications

University of Virginia – Bachelor Science in IT and Management, May 2005, Charlottesville, VA

Experiences

AT&T, Los Angeles, CA 10/18-05/19

MicroStrategy Consultant

•Lead development of MicroStrategy 10.11 objects, reports and dossiers

•Lead testing, deployment, UAT and performance tuning efforts

•Assisted in MicroStrategy platform data integration with Hadoop/Hive

•Provided functional and technical assistance to the development team including offshore and shared services

Technologies: MicroStrategy, Hive/Hadoop, RDBMS, OLAP, SQL, Oracle, Web

American Red Cross, Washington DC 08/16-08/18

MicroStrategy Consultant

•Designed, developed, maintained and distributed analytical reports, dossiers and performance scorecards using MicroStrategy 10.x products

•Performed data analysis tasks, troubleshoot complex SQL queries, design views and store procedures in Oracle 11g environment

Technologies: MicroStrategy, RDBMS, OLAP, SQL, Oracle, Web

Corporation for National and Community Service (AmeriCorps), Columbia, MD 03/15-06/16

MicroStrategy Consultant

•Designed, developed and maintained analytical reports, performance dashboards and scorecards in MicroStrategy 9.x Desktop and Web

•Distributed reports using MicroStrategy Web and Distribution Services

•Administered MicroStrategy platforms, managed users accounts, performed capacity control and troubleshooting tasks, as well as performance system upgrade

•Read, write and run SQL queries and store procedures in Oracle 10g environment

Technologies: MicroStrategy, RDBMS, OLAP, SQL, Oracle, Web

American Psychiatric Association, Arlington, VA 02/12-03/13

Cognos/Crystal Report Consultant

•Developed Financial and Analytic reports using Crystal Reports and IBM Cognos Product in SAP Web Intelligence environment – Webi

•Direct, organize and lead projects in the implementation and use of BI software tools

•Assisted in ETL processes and integration efforts for merging BI platforms with enterprise systems and applications

Technologies: Cognos, Crystal Report, RDBMS, OLAP, SQL, SAP Webi, SQL Server

Transportation Security Administration (TSA) U.S. Dept. of Homeland Security, Arlington, VA

MicroStrategy Consultant 01/10-01/12

•Created reports on passengers, baggage screening, equipment acquisition and financial data using MicroStrategy Desktop OLAP environment

•Designed and developed performance dashboards to improve wait time and screening process

•Provided configuration and maintenance support for users and business accounts

•Worked with SQL Server DBA in creating and maintaing views and store procedures

Technologies: Cognos, Crystal Report, RDBMS, OLAP, SQL, SQL Server

MicroStrategy Consultant, Arlington, VA 09/06-12/09

Client 1: Bank of America

•Performed requirements gathering and analysis, design, development, testing, end user acceptance, implementation and post production support of BI projects

•Built analytics and reports using MicroStrategy BI products and customized solutions using SDK

Client 2: Unites States House of Representatives

•Developed “Balanced Scorecard” applications using MicroStrategy to enhance monitoring of organization’s key performance indicators

•Conducted requirement gathering meetings and designed functional and technical requirements document

•Developed financial reports using PeopleSoft Financials

Technologies: MicroStrategy, SDK, RDBMS, OLAP, SQL, SQL Server

Unites States Department of Education, Reston, VA 06/05-08/06

Cognos/BI Consultant

•Designed and developed reports and analytics using Cognos/Framework Manager

•Supported ETL processes for data migration from the legacy to new data warehouse

•Assisted in deployment and standardization of the new operational reports

Technologies: Cognos, RDBMS, OLAP, SQL, Oracle

Contact this candidate