Sr. BI Architect/Datawarehouse Resume Beverly Hills, CA - Hire IT People

SUMMARY

Over 20 years of experience in business analysis across different industries.
Working knowledge of various platforms and software (Microstrategy, Tableau, Looker, IBM AS/400, DB2/UDB, MS SQL Server, Oracle, Teradata, Netezza, Amazon Redshift).
20+ years of experience in data warehousing and ETL processing.
20+ years of extensive work with all components of MicroStrategy.

PROFESSIONAL EXPERIENCE

Confidential, Beverly Hills, CA

Sr. BI Architect/Datawarehouse

Environment: Amazon Redshift, Netezza, Oracle, Teradata, SQL Server, Tableau, MicroStrategy.

Responsibilities:

Manage a team of onside and offshore datawarehouse developers.
Design and Develop “Movies Anywhere” datawarehous project (Microstrategy, Tableau, Amazon Redshift, Informatica).
Design and Develop “FOX Fast” datawarehouse project (Microstrategy, Amazon Redshift).
Design and Develop “Digital” datawarehouse project (Microstrategy, Amazon Redshift).
Datawarehouse Modeler, Microstrategy architect, Microstregy team lead, Microstrategy developer roles - migration from Netezza to Amazon Redshift.
Design and Develop Category Management and Competitor Intelligence Analysis projects for multiple retailers, ……
Instrumental in architecting the retailer POS forecast project.
Install and configure complete MicroStrategy Business Intelligence Suite of products (Desktop, IS, Web, Narrowcast)
Design a data model, create a project, and define complex objects containing custom sub-queries.
Create and validate advanced reports covering sales, inventory, shipments and AC Neilson analysis.
Define users and user groups with a custom-level data access.
Organize and conduct user training.
Responsible for the MicroStrategy project architecture, Projects administration and advance reports creation.

Confidential, Santa Monica, CA

Sr. Data Warehouse Developer

Environment: Oracle 9i, MicroStrategy 7.5.1 (Desktop, Web, Administrator)

Responsibilities:

Performed complete MicroStrategy software installation and configuration (Desktop, Server, and Web).
Designed a data model, created a project, defined complex objects containing custom sub-queries.
Create and validate advanced reports covering sales and labor analysis.
Define users and user groups with a custom-level data access.
Organize and perform user training.
Responsible for the MicroStrategy project architecture, metadata cleanup and recovery.

Confidential, Orange, CA

System Specialist

Environment: DB2/UDB, MS SQL Server 7, MicroStrategy 7.1-7.2 (Desktop, Web, Administrator, Narrowcast Server)

Responsibilities:

Analyze and document user requirements, create advanced analytics and reports.
Alter the existing database structure and schema objects in order to support complex rules and dependencies required by business model.
Resolve numerous data issues that occur in the process of merging data from multiple sources.
Design a multi-level security system.
Ensure accuracy of the information and a high level of system performance.
Responsible for data warehouse architecture, metadata cleanup and recovery.

Confidential, Glendale, CA

Sr. Data Warehouse Consultant

Responsibilities:

Performed a research on analytics in audit and financial opportunities areas.
Created and formatted metrics and reports designed to simplify process management, identify overpayments, under-deductions, financial opportunities, etc.
Configured the system for the web access.
Prepared and delivered a final presentation to the client.