MicroStrategy BI/Analytics Developer

Skills

Employment History:

Confidential

Sr. MicroStrategy Architect/Lead

Responsibilities

• Evaluated functional and technical business requirements for Incident Reporting Project in Rx Data Warehouse Management Team.
• Provided leadership and direction for MicroStrategy portion of project using MicroStrategy, Teradata and Oracle.
• Teradata is being used as data warehouse with a variety of databases, applications and flat files as data sources.
• Primary responsibility is to review, update and maintain MicroStrategy related system architecture to build a MicroStrategy suite of applications.
• Transformed requirements into MicroStrategy solutions that efficiently enable expected application, reporting, and analytic capabilities to support the business and strategic initiatives of the enterprise
• Provided development of integrated MicroStrategy solutions, review and validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use
• Founded opportunities in the areas of user experience as well as innovative ways R D to deliver powerful analytical insight.
• Implementation and testing of enterprise wide MSTR BI applications.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Contributed to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
• Designed Report and development of MicroStrategy BI.
• Worked with team lead and business analyst to provide support and contribution in preparing critical User Acceptance scenarios.
• Functional analysis and development of MSTR BI technical design documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Deployed/migrated product in QA and production environment using Object Manager served as the subject matter expert for systems in production - helping to ensure a stable, robust production environment
• Served as Microstrategy developer for the full lifecycle of the data-warehousing project from requirement gathering, analysis, and modeling from business to rollout.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Trained QA Teams on work and usage of Integrity Manager and effective uses of Baselines for comparison.
• Communicated across a diverse workforce to ensure work transitions effectively without interruption or incident.
• Designed and developed database objects like tables, views and procedures in Oracle and Teradata environments.
• Performed Import and export of data across DEV and QA environments from PROD.
• Created Database Instances and connection mapping for access to proper warehouses and users
• Involved in Customer Support, Maintenance Performance tuning of the project.
• Demonstrated Complete MicroStrategy Suite Reports, Dashboards and Report Builder for end users.
• Interacted with business users on regular basis to know requirements and provide technical assistance regarding problems and help with the tool.
• Had extensive experience with MS Office, Project, Visio.

Environment: MicroStrategy 9.3 Desktop, Web, Administration , Integrity Manager, Command Manager, User Manager, Teradata 14, Teradata Studio Express, Teradata Client 13.10, Oracle 11g, Linux, Oracle SQL developer, Windows, Ms-Office, Visio.

Confidential

Sr. MicroStrategy Admin/Architect

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements for DPS-Portfolio Optimization Project.
• Created MSTR Prelim and Detail design documents based on the business requirements.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management.
• Administered the object change management process: Object migration across the various environments using Object Manager or Project Merge.
• Functional analysis and development of MSTR BI technical design documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Provided Support for QA, UAT Environments and DR fixes.
• Involved in the lifecycle of VDM Fraud Dashboard Reports KPIs Project, DPS-Portfolio Optimization Project and VDM Prepaid Cardholder Data Integration.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations for VDM Fraud Dashboard Reports KPIs Project.
• Designed Report and development of MicroStrategy BI
• Created Schema Objects and Public Objects with Command Manager.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Implementation and testing of enterprise wide MSTR BI applications.
• Worked the Production issues queue, provided full support to our business intelligence community
• Created Time Triggered and Event Triggered Schedules, Events and Subscriptions for the Intelligent Cubes reports. Created batch files using command manager script to Trigger events.
• Added Nodes to VLDB XML file for creating new VLDB Options
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Extensively worked on Intelligent Cube Reports for Creating Dashboards. Monitored and Governed Intelligent Cube for better Performance.
• Created Logical Tables in Microstrategy to meet the Complex end user requirements.
• Extensively used Pass through Functions
• Validate reporting results against requirements. Troubleshoot and analyze data issues within reports
• Served as Microstrategy developer for the full lifecycle of the data-warehousing project from requirement gathering, analysis, and modeling from business to rollout.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Extensive Experience in MicroStrategy Mobile platform
• Expertise in Integrity Manger. Trained QA Team on Integrity manager Usage. Compared report and IServer performances in DB2 and Oracle Databases.
• Prioritize and multi-task concurrent projects Effective in resolving all clients and development issues
• Coordinated the Onsite and Offshore team to resolve issues.
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries.
• Had extensive experience with MS Office, Project, Visio.

Environment: MicroStrategy 9.0.2/9.2.1 Desktop, Administrator, Web , MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Integrity Manager, Ms-Office, Visio, DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential

Sr. MicroStrategy Architect

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand the requirements and produce the report design specifications and estimates of the project.
• Worked for the lifecycle of GBSC Global Balance Score Cards for all the three Releases for the finance team.
• Created Front End STM for the Reports for acceptance.
• Architected schema objects such as attributes, facts and transformations.
• Created various MicroStrategy objects such as Metrics simple and compound , Filters, Prompts, Custom Groups, Consolidations, etc.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Functional analysis and development of MSTR BI technical design documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Designed Report and development of MicroStrategy BI
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Worked on Root Cause and Fix for various dashboards raised by users and testers as Jira bugs for CS Reporting.
• Served as Microstrategy developer for the full lifecycle of the data-warehousing project from requirement gathering, analysis, and modeling from business to rollout
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Micro strategy IServer Tuning for performance.
• Implementation and testing of enterprise wide MSTR BI applications.
• Performance tuning of SQL for long running reports.
• Created various event based Schedules.
• Deploying Flash Widgets on Servers and Uploading the New ones from Support site.
• Created reports with various object prompts to generate various Ad hoc reports.
• Worked with Erwin in designing the schema for database views.
• Created various Report Services Documents with various transformation metrics to report on CSF Month, CSF Quarter, CSF Year, Prev Month, Prev Quarter, SMLY, and SQLY.
• Created various Monthly, Quarterly and Yearly Dynamic Dashboard documents for Finance people with multiple panel stacks, selectors and customized widgets.
• Created various Narrowcast reports, subscriptions and schedules.
• Developed Freeform SQL Reports, Standard Reports and Dashboard Reports.
• Analysis and Troubleshooting of the SQL generated by MicroStrategy.
• Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Had extensive experience with MS Office, Project, Visio.
• Worked on the issues caused by the dashboards after migrating to version 9.3

Environment: MicroStrategy 9.3/ 9.2.1 Desktop, Administrator, Web , MicroStrategy Architect, MicroStrategy Intelligence Server, Ms-Office, Visio, MicroStrategy Narrowcast Server, Teradata 13, Oracle, Windows, MAC OS X

Confidential

MicroStrategy Architect / Lead

Responsibilities:

• Involved in the complete life cycle of the project from gathering business requirements, creating architecture for the business for Canned Reporting and Ad-Hoc reporting for Price Analysis reports.
• Involved in Establishing ODBC connections to multiple DBs.
• Created new Project and project sources and worked on getting tables from the Data Mart into the MicroStrategy environment using the Warehouse catalog.
• Worked extensively on creating Metrics, Prompts, Filters, Custom Groups and Consolidations for complex reports.
• Configured Very Large Database VLDB Properties at different levels report, metric, project and database Instance
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing the SQL using the VLDB properties
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Served as Microstrategy developer for the full lifecycle of the data-warehousing project from requirement gathering, analysis, and modeling from business to rollout
• Used Teradata SQL assistant extensively to test and debug MicroStrategy reports as a key step in data validation.
• Functional analysis and development of MSTR BI technical design documents to gather and record business requirements on how they want to use mobile, web and office tool set.
• Implementation and testing of enterprise wide MSTR BI applications.
• Extensively built Flash Dashboards for multiple Business Clients the dashboards used custom widgets, panels, selectors and flash visualizations.
• Designed Report and development of MicroStrategy BI.
• Extensively used MicroStrategy Desktop and Web to enable users to run pre-defined sales and inventory reports, build their own customized reports and download information into Excel spreadsheets.
• Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.
• Extensively worked on various formatting issues in MicroStrategy Web and Excel
• Created personalized reports for end-users by creating various templates, filters and trained for the efficient use of MicroStrategy Web interface.
• Created reports using Intelligent Cubes.
• Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools
• Created new user group and added new users to the group and assigned security privileges
• Used Object manager to move objects between Dev, QA and Prod Environments.
• Performed Administration tasks User Management, Cache Management, Schedule Management, etc.
• Participate in daily status and monthly planning meetings.
• Had extensive experience with MS Office, Project, Visio.
• Train and mentor Offshore Team in the use of MicroStrategy software and techniques.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.2.1, MicroStrategy Web, MicroStrategy Intelligence Server, Ms-Office, Visio , Integrity Manager, Object Manager, Teradata, Erwin Data Modeler, Windows XP professional and Windows NT.