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.

Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations for VDM Fraud Dashboard Reports KPIs Project.

Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.

Extensive Experience in MicroStrategy Mobile, Web platform and used Office tools

Involved in the lifecycle of VDM Fraud Dashboard Reports KPIs Project, DPS-Portfolio Optimization Project and VDM Prepaid Cardholder Data Integration.

Provided Support for QA, UAT Environments and DR fixes.

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.

Administered the object change management process: Object migration across the various environments using Object Manager or Project Merge.

Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management.

• Designed Report and development of MicroStrategy BI

Worked the Production issues queue, provided full support to our business intelligence community

Implementation and testing of enterprise wide MSTR BI applications.

Had experience in implementing end to end MSTR BI/Analytics solutions for large organizations

Created Schema Objects and Public Objects with Command Manager.

• 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.