We provide IT Staff Augmentation Services!

Microstrategy Architect/developer Resume

SUMMARY:

  • IT Professional with expertise in Enterprise Data Architecture, data management, data analysis, data migration, transformation and data warehouse - BI application architecture and design.
  • Expert level in Architecture and Design of BI solution.
  • 15 years experience as a BI/Data Warehouse consultant.
  • Experience developing web-enabled document management systems and web-enabled BI applications.
  • Microsoft Certified Solutions Developer with expertise in object oriented analysis and design.
  • Professional with expertise in database analysis, design, development, mapping, migration, transformation and database performance fine-tuning.

TECHNICAL SKILLS:

  • UML
  • ErWin
  • TOGAF framework
  • Enterprise Architect
  • Rational Studio
  • MicroStrategy 6, 7.x, 8.x, 9.x, 10.x
  • SQL Server, Oracle, Teradata; Red Shift
  • DB2, VSAM files
  • Informatica
  • Crystal Reports
  • Visio
  • MS Office Suite

EXPERIENCE:

Confidential

Microstrategy Architect/Developer

Responsibilities:

  • Development of Reporting services, Documents and VI Dashboards at the company
  • Involve in Data warehouse design and implementation strategy
  • KPI Identification
  • JAD sessions with stakeholders to collect input/requirements

Confidential, Warren, NJ

Microstrategy Architect/Developer

Responsibilities:

  • Architecture and development of Reporting services at the company
  • Dashboarding
  • Data warehouse design and implementation strategy
  • JAD sessions with stakeholders to collect input/requirements
  • Prototyping solutions

Confidential

Microstrategy Architect/Developer

Responsibilities:

  • Architecture and development of Reporting services at the company
  • Datawarehouse design and implementation strategy
  • Dynamic Dashboard development
  • JAD sessions with stakeholders to collect input/requirements
  • Prototyping solutions

Confidential, Wilmington, DE

Microstrategy Architect/Developer

Responsibilities:

  • Advance reporting development and Dashboarding
  • Data mart / DW design, implementation and loading strategy
  • Work with DBA group to create supporting back end object to support reporting requirements
  • Mentor other developers in the team
  • JAD sessions with users/analysts/developers

Confidential, Campbell, CA

Microstrategy Architect/Developer

Responsibilities:

  • Business requirements translation into design
  • Dynamic Dashboarding
  • System documentation, maintenance and troubleshooting
  • Data mapping, transformation and loading design
  • Vendor Management
  • Mentoring junior team members
  • Data modeling

Confidential

Senior BI Architect

Responsibilities:

  • Business community interviewing to collect business requirements
  • Test plan and implementation
  • User issues remediation and resolution
  • Data mapping and migration to a new system architecture
  • Vendor Management
  • Business Use case development
  • Logical data modelling

Confidential

Microstrategy Architect /Developer

Responsibilities:

  • Define IS requirements to support BI implementation
  • Business community interviewing to collect business requirements
  • Transfer requirements to physical system implementation
  • Metadata creation; Report Development, Object Mapping and Enforcing Business Rules.
  • Dashboarding
  • User Training
  • Developed Enterprise Business Data Model
  • Executive Dashboard development
  • Develop BI/ EDW solution Architecture

Confidential

Microstrategy Architect/Developer

Responsibilities:

  • Transfer requirements to physical system implementation
  • Metadata creation; Report Development, Object Mapping and Enforcing Business Rules.
  • Work with DBA group to create supporting back end (Database) object to support reporting requirements
  • Mentor other developers in the team
  • JAD sessions with users/analysts

Confidential, Wilkesboro, NC

Senior Microstragey Architect

Responsibilities:

  • Define DW tables/views to support OLAP implementation by the DBA and ETL team.
  • Physical, logical and dimensional DW modeling
  • Object Mapping and Enforcing Business Rules.
  • Front End development.
  • Report Messaging

Confidential

Microstrategy / BI Manager

Responsibilities:

  • Developed, maintained and troubleshoot BI app.
  • ETL and Fine Tuning of DW sitting on SQL 2000.
  • Define table/view SQL as needed to support ROLAP implementation by the DBA and ETL team.
  • Physical, logical and dimensional DW modeling
  • Dashboard design and development
  • Message delivery system development and implementation

Confidential, Dallas, TX

Senior Data Analyst / Data Migration Consultant

Responsibilities:

  • Analysis of the present state of databases and analysis of the proprietary software acquired to serve as the common repository to unify all the different database applications. The data also had to comply with readiness for web-enabled transactions.
  • Assessment and evaluation of the new proprietary database application and its appropriateness, robustness and capacity to accommodate the data migration. Assessment of the fine-tuning and performance capability of the unifying database application.
  • Development of a data dictionary for the present database array.
  • This required development of the meta-data and assembling the meta-data into new useable form to enable editing and mapping.
  • Development of a data warehouse including design, ETL procedures and relationships to enable different databases to be unified into a central Enterprise data warehouse.
  • Development of Front End BI reporting Application, including: Object Capture, metric design, hierarchies and finally report development.
  • Used MicroStrategy 6 (Desktop Development, Web Customization and Narrowcasting (at that time under existed different name).

Confidential, Dallas, TX

Solution Architect

Responsibilities:

  • Development of front end DSS (Decision Support System) that was supposed to meet the need of variety of different users disperse across, using MicroStartegy V6.
  • Development of a browser-based document management solution designed for collaboration on documents, discussions, timesheet reporting and management decision support. This knowledge management system was in real-time.
  • All transactions were maintained on a MS Access and SQL Server databases.
  • Executive management could query the database to determine contents and changes to contents.
  • Design and development of a Web-Portal website for the VNC resellers.

Confidential, Reston, VA

Senior Data Analyst

Responsibilities:

  • Development of a MS Access database for inventory purposes and re-mediating all field databases.
  • Troubleshooting of existing databases.
  • Overseeing entire re-mediation process to ensure that all requirements were met and signing off re-mediated databases.
  • Development of BI application using Crystal Reports and MS Access reporting capabilities. Reports were for end users and executive management.
  • Monitoring Y2K transition to ensure data consistency before and after.

Confidential, Winnipeg, MB

Database Analyst / Administrator

Responsibilities:

  • Performed Data & Process Modeling for Confidential project.
  • Developed a custom application in a multi-tiered environment and designed a database to support that application.
  • Developed - Troubleshoot variety of reports for executive management.

Hire Now