BI Architect Resume

TECHNICAL SKILLS

BI Tools: MicroStrategy 9.x, MicroStrategy 8.1

Operating Systems: Windows, Linux.

RDBMS: Teradata 14.0, Oracle 11g, 11i, 9i, 10gR2, MS SQL Server Management Studio, WareScape RED. MS SQL Server Analysis Manager, MS Access

Languages: PL/SQL, HTML

Office Tools: MS Office, MS Works, MS Visio, MS Project.

Tools and concepts: Data Modeling, Quest Software’s TOAD for Oracle v.8.6, v9.0, v9.1, JDBC, Enhancing query performance with Oracle partitioned tables, TCP/IP, WAN, PL/SQL, Pivot table reports using Excel.

PROFESSIONAL EXPERIENCE

Confidential

BI Architect

Responsibilities:

Responsible for setting up MicroStrategy from base and creating architectural objects in MicroStrategy Warehouse.
Excellent understanding of Advanced Report development, workbook creations, Object development and Report/Dashboard Creations.
Excellent knowledge in MicroStrategy cubes generation, maintenance and modification.
Excellent communication skills.
Excellent Report development skills.
Responsible for creating compound metrics and specialized view for documents and dashboards.
Designed and created Workbooks or Document books for management users in MicroStrategy v9.
Designed and created intelligence cubes to provide quick static results display for sales team in MicroStrategy v9.
Extensive experience in creating architecture schema objects within MicroStrategy (attributes, facts, metrics etc).
Responsible for Object Migrations from Dev to Production environment using Object Manager.
Responsible for I - Server Maintenance and Data Warehouse Catalog.

Confidential

Developer/ Systems Analyst

Responsibilities:

Project lead for Sales, Finance and Distribution group throughout the company.
Excellent communication skills, data gathering, and translation from IT to Business and vice versa.
Excellent understanding of Data Migration, Intelligence cube, Workbook creations.
Assisted designing plan for Upgrade project from v8.1.2 to v9.0.1.
Extensive work designing MicroStrategy based reports and links for user interface such as Salesforce.com and Infosource.
Excellent knowledge in MicroStrategy cubes generation, maintenance and modification.
Assisted in creating MicroStrategy cube based report architecture, generation and maintenance.
Responsible for architecture planning and designing data structure upgrade projects such as PLP upgrades from v8 to v9 and v9 to v10.5
Responsible for creating compound metrics and specialized view for documents and dashboards.
Designed and created Workbooks or Document books for management users in MicroStrategy v9.
Designed and created intelligence cubes to provide quick static results display for sales team in MicroStrategy v9.
Extensive experience in creating architecture schema objects (attributes, facts, metrics etc).
Responsible for object and data migrations between MicroStrategy 8.1.2 and 9.0.1 (Dev, Stage, Prod Support, Production)
Responsible for Month end processes using SQL Server Management Studio and SQL Server Analysis Manger to update Tables, Database Transformation Services (DTS).
Created user accounts for Infosource User website.
Worked on troubleshooting issues for MicroStrategy v9 and v8.
Extensive architect experience in Object desigining and modifications (VLDB settings, transformations, condition for filters, compound metrics, attribute mapping) of existing and new reports and documents.
Worked in and between various MicroStrategy 8.1.2 and 9.0.1 environments (Dev, Stage, Prod etc) and web.
Created table based user account using Quest Software’s TOAD for MicroStrategy
Audited license analysis for MicroStrategy.
Modified and created narrowcast subscriptions to enhance reporting performance.
Designed, Created and Tested MicroStrategy 8.1.2 various objects (Application objects, Schema objects, filters, etc) from scratch for Product Snowflake and NIR Deck.
Architectural designing and Creation of Hyperlinks for documents and dashboards.
Excellent skills in creating new MicroStrategy Grid reports, Documents, Dashboards, Workbooks in MSTR v9 and v8.
Responsible for Installation process and worked on Quest Software’s TOAD for Oracle.
Responsible for Oracle client mass installation process.

Confidential

Consultant / MSTR Developer

Responsibilities:

Ability to Work Independently as well as a part of a team.
Worked in and between various MicroStrategy 8.1.2 environments (Dev, Stage, Prod etc) and web.
Designed, created and modified narrowcast subscriptions to enhance reporting performance.
Designed, created and Tested MicroStrategy 8.1.2 various objects (Application objects, Schema objects, filters, etc) from scratch for Product Snowflake and NIR Deck.
Created Hyperlinks for existing documents.
Modified existing Objects, Reports and Documents
Worked on troubleshooting issues in MicroStrategy 8.1.2 environment.
Created MicroStrategy Grid reports and Documents.
Worked on Quest Software’s TOAD

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship