We provide IT Staff Augmentation Services!

Senior Microstrategy Developer Resume

SUMMARY:

  • 12+ years of business intelligence and data warehousing experience
  • 12+ years of experience in all stages of the Software Development Life Cycle (SDLC) - requirements gathering, analysis, modeling, design, development, test, production and enhancement
  • 12+ years of data architecture, data marts, dimensional modeling, fact and dimensional tables, and ER modeling experience
  • 12+ years of MicroStrategy experience in:
  • Designing and creating data architect and reporting objects (attributes, facts, hierarchies, intelligent cubes, filters, metrics, prompts, templates, consolidation and custom groups, etc.)
  • Designing and creating dynamic dashboards & scorecards, and analytical reports
  • 12+ years of experience in preparing documents for user requirements, functional specification, data mapping, data modeling, technical and user
  • 8+ years of OBIEE and Oracle Discoverer experience
  • 12+ years of SQL and PL/ SQL programing experience
  • 3+ years of SSIS experience (develop and deploy SSIS packages, create and schedule jobs in SSMS)
  • 2+ years of Informatica experience
  • 2+ years of OWB experience

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy 10.4, OBIEE 10.1, Discoverer 3.1

ETL Tools: SSIS 2008, Informatica 8.6, Oracle Warehouse Builder (OWB), OADW

Databases: Oracle 10g, SQL Server 2005/2008 and 2014

Data Modeling Tool: Erwin 7

Languages: SQL, PL/SQL

Query Tools: TOAD 9.6, AQT 8.1 (Advanced Query Tool),SQL Server Management Studio

Operating Systems: UNIX AIX, Windows XP/NT/98

Productivity Tools: MS Office, VISIO, SharePoint 2003

WORK EXPERIENCE:

Senior MicroStrategy Developer

Confidential

Responsibilities:

  • Gathered and analyzed user requirements.
  • Designed the solution to address all the requirements
  • Reviewed and finalized the requirements and solutions with users.
  • Created data mapping document from data source to attributes and metrics.
  • Created presentation layer and schema objects sourced to SAP HANA view.
  • Created schema objects (logical tables, attributes, facts, hierarchies) and public objects (metrics, filters, prompts, consolidations, custom groups, reports, dashboards, Visual Insights) based on required functionalities and enhancements.
  • Created import/export packages in object manager to move objects across projects.
  • Used command manager to create metrics, filters, users and subscriptions
  • Created user guide and technical documents.

Technical Environment: MicroStrategy 10.4, SAP Hana, SQL Server, MS Office

Senior MicroStrategy Developer

Confidential

Responsibilities:

  • Modeled Snowflake schema for Affiliate project, and created presentation layer and schema objects.
  • Created schema objects (logical tables, attributes, fact, hierarchies) and presentation layer or public objects (metrics, filters, prompts, consolidations, custom groups, reports, dashboards, Visual Insights) based on required functionalities and enhancements.
  • Migrated Web queries to MicroStrategy platform using Free Form SQL.
  • Fixed the issues with TV Weekly Activity data model and ETL (stored procedures). Create schema and presentation layer objects.
  • Used bursting and cube functionality to send out subscriptions based on emails stored and maintained by users in Excel file.
  • Used MicroStrategy Transaction Services for adding different groupings for agencies, product… This helped users to analyze data from different point of views.
  • Helped with migration of RHS system by loading existing data (Excel files) to SQL Server database and used complex SQL code to transform data and create data feed for new system.
  • Created import/export packages in object manager to move objects across projects.
  • Created user guide and technical documents for above projects.

Technical Environment: MicroStrategy 10.4, Oracle 11g, SQL Server, MS Office

BI Consultant

Confidential

Responsibilities:

  • Created cubes and setup incremental refreshes for cubes
  • Created reports and dashboard based on required functionality
  • Modeled presentation layer and prepared DDL for new schema objects and created facts and attributes
  • Provided guideline for using Distribution Services and helped the team to setup subscriptions and using bursting functionality.
  • Created command manager scripts to setup user security.
  • Created technical support document
  • Developed complex views in oracle to be used as source for MicroStrategy

Technical Environment: MicroStrategy 10.4, Oracle, MS Office

Senior MicroStrategy Developer

Confidential

Responsibilities:

  • Conducted requirement gathering sessions to created business requirements document
  • Created Cubes to improve performance and used as source for Visual Insight dashboards and reports
  • Designed and created Visual Insight dashboards based on user requirements
  • Created reports and dashboards based on required functionality
  • Developed business objects (metrics, filters, prompts, consolidations, custom group,…)
  • Prepared definition and relation for schema objects and created facts, attributes, hierarchies, and transformations
  • Migrated objects across development, UAT and production environment using Object Manager
  • Performed integrity testing between projects in different environments (development, UAT and production) using Integrity Manager
  • Monitored users activities and improve their reporting experience using Enterprise Manager
  • Developed ETL processes using SSIS and SQL stored procedures

Technical Environment: MicroStrategy 9.4.1 and 10.5, SQL Server 2008 and 2014, MS Office

Senior Business Intelligence Consultant

Confidential

Responsibilities:

  • Migrating exiting Revenue Management System to JDA’s Pricing and Revenue Management solutions:
  • Created data mapping document by studying JDA data requirements and BellMedia source system and performed gap analysis.
  • Developed daily and weekly data extract in oracle PL/SQL.
  • Developed Unix scripts to FTP data files to JDA server.
  • Performance Improvement for Astra Inventory Business Area: Tuned performance by modifying existing PL/SQL procedures and database objects. Load time changed from 8 hours to 4 hours.
  • Control-M Job Management project: Changed existing ETLs and Unix scripts to pass success/failure status and message to new job scheduling system (Control-M).
  • Developed audit reports to help users with data migration process.

Technical Environment: Oracle 10g, MicroStrategy 9.4.1, Oracle Discoverer 3.1, UNIX, MS Office

Senior ETL/MicroStrategy Developer

Confidential

Responsibilities:

  • Coordinated DW/BI solution tasks with team members and delivered projects on time
  • Worked collaboratively with functional areas (technical, clinical, operational and financial departments) to document business requirements
  • Translated business requirements into data warehouse structure in functional specification documents
  • Designed and created physical and logical data mapping by coordinating with source systems experts
  • Designed logical and physical data model
  • Designed and created database objects (tables, indexes, views, constraints)
  • Developed ETL processes using SSIS and SQL stored procedures, and packages
  • Conducted unit testing and integration testing
  • Deployed SSIS packages and create jobs and schedules in SSMS
  • Created project sources, connection mappings, and projects in MicroStrategy
  • Prepared definition and relation for schema objects and created facts, attributes, hierarchies, and transformations in MicroStrategy
  • Developed business objects (metrics, filters, prompts, consolidations, custom group, drill map, template and reports) in MicroStrategy based on user requirements
  • Designed and developed complex dashboards and documents in MicroStrategy
  • Coordinated User Acceptance Testing sessions in a dedicated UAT environment
  • Created user guide documents
  • Migrated objects across development, UAT and production environment using Object Manager
  • Performed integrity testing between projects in different environments (development, UAT and production) using Integrity Manager
  • Monitored users activities and improve their reporting experience using Enterprise Manager
  • Created users and groups and assign the security for each project and objects in BI tool
  • Created subscriptions and alerts for user groups and maintained them using Command Manager scripts
  • Provided support and trouble-shooting for ETL failures and reporting issues
  • Involved in enhancement and change requests

Technical Environment: SQL Server 2008, MicroStrategy 9.4.1, Visio, MS Office

Hire Now