SUMMARY:

• 12+ years of Professional experience in Design, Development, administration and Implementation of MicroStrategy applications with proficiency in Creating Schema objects such as Attributes, Facts, Logical Table, Hierarchy and Public objects such as filters, prompts, metrics, reports, documents and Dashboards using MicroStrategy 10.5/10.4/10.2/9.4.1/9.3/9.2.1 versions.
• Expert in creating Schema objects such as Logical Tables, Facts, Attributes, Hierarchies and Transformations.
• Extensive experience in creating MicroStrategy Application Objects such as Template, Filters, Metrics, Prompts, Custom Groups and Consolidations, Report, Document, Dashboard and Visualization dashboard.
• Experience creating dashboard for iPhone and iPad.
• Experience in creating MicroStrategy Dossier.
• Expertise in creating Intelligent Cubes.
• Expertise in creating projects.
• Expertise in migration of objects from DEV to TEST and TEST to PROD using MicroStrategy Object Manager.
• Expertise in using MicroStrategy Integrity Manager to test and compare two reports in different environments and others.
• Worked on customizing and optimizing the query performance.
• Familiar with Data Management Systems such as SQL Server, Oracle and Teradata.
• Strong working knowledge of SQL, ability to understand and write complex SQL queries.
• Experience as Informatica ETL developer to use business logic to create mapping, use different transformation, create workflow and migrate the code.
• Well - Organized, Energetic, Quick learner, Team Player. Ability to adjust to new and challenging situations.
• Excellent analytical, programming, written, verbal, communication and interpersonal skills and Leadership Qualities.
• Knowledge in creating visualization dashboard using Tableau 10.4.
• Knowledge in creating predictive metric, Forecast and Trend in Tableau.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 2019 V 11.1, 10.5/10.4/10.2/9.3/9.2.1/9.0 (Developer, Desktop, Architect, Distribution services, OLAP services, Object Manager and Integrity Manager).

Tableau 10.4.: TERADATA Database Version 15.10.05.04

SQL Navigator 7.5: PL SQL Developer 12

ETL Tool - Informatica 10.1.1: (PowerCenter Repository Manager, PowerCenter Designer, PowerCenter Workflow Manager and PowerCenter Workflow Monitor).

RDBMS: Oracle 11g/10g/9i/8i/8.0, MS Access 2003/2007, SQL server 2000/2005/2008 , Teradata 15.10.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Informatica ETL Developer

Responsibilities:

• Confidential has upgraded MicroStrategy V 10.4 to MicroStrategy V 11.1
• Building Dossiers and Reports using MicroStrategy 2019 V 11.1.
• Convert OBIEE reports into MicroStrategy.
• Connect to Oracle BI Discoverer Plus for Oracle Business Intelligence 11g.
• Run the report into Oracle SQL Discoverer to understand the report and then retrieve the SQL.
• Work with senior ETL and datawarehouse developer to resolve the structure and data issue in the tables.
• Talk to Business user and document the requirement for the reports and dashboard.
• Work with Database data modeler to create logical and physical model.
• Work with senior ETL resource to create views in the database and remove the cross join and any other issues in physical schema.
• Create the semantic layer in MicroStrategy such as attributes, facts, hierarchy, logical table and transformation as needed.
• Create the entire report component such as filter, prompt, metric and others as required.
• Convert the Oracle Discoverer report into MicroStrategy and perform unit testing.
• Create the document/dashboard.
• Create MicroStrategy visualization dashboard using version 10.4.
• Create the dashboard for iPhone and iPad
• Run the SQL into SQL Navigator 7.5 or PLSQL Developer12 to test the data.
• Move the reports and other objects from DEV to QA environment using Object Manager for testing.
• Use integrity manager to compare reports in different projects.
• Work as an Informatica ETL Developer to create mapping and workflow.
• Update tickets in JIRA.
• Attend daily scrum and other meetings.
• Provide MicroStrategy training to users and team members as needed.

Confidential, Jacksonville, FL

Sr. MicroStrategy Developer

Responsibilities:

• Login to Decision studio and run the reports to understand the look and feel of report and validate the data.
• Login remotely to Business Object machine and launch Business Object 6.5, Go to Billing Datamart universe, edit the data provider and find out all the objects involved into that report. Check the placement of the objects into SAP BO reports, check their formula in formula bar.
• Create the equal number of reports into MicroStrategy whatever involved in BO reports and name them same.
• Create the MicroStrategy documents by including all those reports.
• Create the Link on Employee ID of Payroll summary document to dynamically pass the value of Employee Id to open the another document of Employee Earning history.
• Join stand up scrum meeting, update JIRA and others.

Confidential, Charlotte, NC

MicroStrategy Architect/Developer

Responsibilities:

• Worked with managers to get all the access related to this project.
• Created role based Date dimension tables.
• Created Day, week, month, quarter and year attribute for all dimension tables.
• Created hierarchy.
• Created Date attribute new description form using ApplySimple formula after validating that formula in Teradata database.
• Participated in all Sprint meetings.
• Updated all JIRA tickets.

Confidential, Wilmington, DE

Sr. MicroStrategy Architect / Developer

Responsibilities:

• Involved in conceptual, logical, physical and semantic modelling.
• Work with different stakeholders to understand the business logic and accordingly work with my DBA to bring different tables into my project Database Instance Associate Monitoring Reporting and Analytics. After that DBA creates the view and bring the necessary columns in view.
• I migrate the necessary Tables from database instance to the list of Tables being used in the project. If any Tables in the project tables get updated than I update the structure of those tables and save the configuration.
• In the ongoing process, as per the report/dashboard requirement I suggest/ask DBA to create different columns in the views.
• Provided logical modelling of Time dimension table to DBA for Time dimension table to be created in the Project database.
• Create Attribute, Facts, Hierarchy and Transformations as required.
• Create Filters, Prompts, metrics and dataset as per requirement.
• Create intelligent cube for the users to create reports and visualization based on that.
• Publish, Edit and Republish the cube as necessary.
• Use Report filter and View filter as per the requirement to filter the data.
• Change the metric join type to outer join from the default inner join based on the report requirement.
• Check the performance of the report and use the report optimization as necessary.
• Being the Admin of Enterprise Administration site, I manage users list (add or remove) in Group Management of different Groups such as AMRA Basic Web Users, AMRA Power Web Users, AMRA Power Web Users - Detail.
• I manage ACL Confidential different levels.
• I work with COE team/DGadmin group to resolve any microstrategy issues by creating work request on Nexus such as Enable user privilege on Microstrategy Web 10.4 for AMRA Power Web Users - Detail to enable user privilege to create visualizations using Visualization Gallery, update project configuration to expire History List and cache after 24 hrs. Instead of 750 hrs, remove the setting of cache to be created per DB connection, Establish or remove LDAP Groups in Customer admin, enable the permission to create security filter and others.
• Work with ARM team to set up UAT user onboarding through ARM.
• Working with Odin team to migrate our Project dashboard in Odin environment.
• Work with different team for dashboard socialization.
• Work with UAT team to understand the bug raised by them and fix the bug.
• Support in UAT and PROD migration and testing.
• Participate in all sprint and other meetings.

Environment: MicroStrategy 10.4, Teradata Database Version 15.10.05.04 , Teradata SQL Assistant (The W - APRTERA)

Confidential, Pennington, NJ

Sr. MicroStrategy Architect / Developer

Responsibilities:

• Look Confidential the OBIEE reports and prompts, run the report, generate the SQL, evaluate the SQL and convert the same report into Microstrategy by creating the same Attribute, Fact, Metric, Filter and Prompts.
• Involved in data modelling to create the necessary attributes and their relationships.
• By using the SQL generated by OBIEE report, work into OBIEE .rpd file to find the Physical and Presentation layer column name and find out which tables these columns are coming from.
• Bring those tables into our project via Warehouse Catalog. If tables are not available in warehouse catalog then update the SQL of Data Dictionary of the required tables to bring it into Warehouse Catalog.
• Create Logical Tables, Attribute, Facts, Hierarchy and Transformations as required.
• Create Filters, Prompts and Reports.
• Create freeform SQL report.
• Create intelligent cube and create report from the cube.
• Publish, Edit and Republish the cube as necessary.
• Create Filter, Prompts, Custom Groups, Consolidation and Derived Elements as required.
• Use Report filter and View filter as per the requirement to filter the data.
• Check the performance of the report and use the report optimization as necessary.
• Provide guidelines of mobile dashboard to managers.
• Talk to Admin for any permission issues.
• Talk to ETL and DBA for Data related issues.
• Use JIRA to create a ticket for MicroStrategy related issues.
• Participate in all sprint and other meetings.

Environment: MicroStrategy 10.2/9.4.1, Toad 11.1, Oracle 11.2 R2.

Confidential, Warren, NJ

Sr. MicroStrategy Developer / Architect

Responsibilities:

• Performed customer Requirements Gathering, requirements Analysis, Design and Development of Schema objects, Report creation, Dashboard development, Testing and end User Acceptance Presentations of BI Projects.
• Using MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Work extensively on creating MicroStrategy Schema and Application Objects such as Attributes, Facts, Transformations, Logical Tables, Simple Metrics, Compound Metrics, Level Metrics, Filters, Custom Group, Consolidation, Hierarchies and Prompts for MicroStrategy reports using MicroStrategy Architect.
• Used Microstrategy Install shield wizard to install the Microstrategy application.
• Used the configuration wizard to configure intelligent server, Create Metadata, History List, and Statistics Repository Tables.
• Upgrade to MicroStrategy environment from 9.2.1 to 9.3.0.
• Used License manager to activate the license.
• Performed User Creation, Create Event, Schedule and Subscription. Create Devices, Transmitters and Contacts. Used Intelligent Cube Monitor to monitor the cube.
• Work with MicroStrategy Object Manager to move objects among the Development and testing environments.
• Worked in command manager to create the command script, copied and paste those script in notepad and saved it as batch file and provided it to ETL team.
• Design Advance filter, Advance metrics and Advance Prompts to create complex reports.
• Create Drilling path and implement those into reports such that user can Drill across different System and User hierarchies.
• Involved in troubleshooting of Metrics, Prompts, Filters, Templates, Consolidations, and Custom Groups objects in an Enterprise data warehouse team environment.
• Create Intelligent Cube and use that in reports to decrease the workload on database.
• Work on VLDB properties such as Joins, Query Optimization, Metrics (Null Check and Zero Check), Select/Insert and Tables.
• Suggest and provide requirements to DBA for necessary changes in database.
• Work with Database Architect and ETL Developer for Data availability and data model related issues by providing solutions that support MicroStrategy application.

Environment: MicroStrategy 9.2.1 (Desktop, Architect, Intelligent Server, Web, Object Manager), Teradata 13.

Confidential, NYC

Sr. MicroStrategy Developer

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Designed Dashboards using the new selectors radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Worked on the MSTR Narrowcast module to build Information Objects, Question Objects, Static Subscription sets, Services and Schedules to have the reports delivered to business users.
• Performed routine administrator tasks during absence of MicroStrategy administrator.
• Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors, and customized widgets for the mobile interfaces.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Involved in upgrading MicroStrategy v9.0.1 to MicroStrategy v9.2.1.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports.
• Performed testing of all reports for the final deployment.
• Responsible for various administration tasks like Tuning, Caching, Thresholds and Report Optimization.
• Extensively used Integrity Manager to test reports during the upgrade.
• Provided Business user training for the MicroStrategy Desktop/Web.

Environment: MicroStrategy v9.2.1, Teradata 12.0, Oracle 11g, Windows XP.

Confidential, Middletown, NJ

MicroStrategy Developer

Responsibilities:

• Reduced intelligence server pressure by increasing number of Database connection threads in optimal way.
• Assisted in Project setup (Installing, Configuring, Managing and controlling) and Project Lifecycle management.
• Periodic maintenance of Intelligence server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Created Transformations like YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Involved in making enhancements to logical and physical database designs for the BI Architecture.
• Involved in managing objects between different environments by using object manager.
• Created various Narrowcast Services to deliver reports to users by various delivery methods.
• Used MicroStrategy Enterprise Manager to see the usage of reports and their performance.
• Configured, Managed clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
• Best Practices using standardized methodology for coding, development, test and implementation process.

Environment: MicroStrategy v9.0.2/Oracle, Red Hat Linux

Confidential, Roseland, NJ

MicroStrategy Developer

Responsibilities:

• Involved in analysis, design and construction of the Metadata.
• Designed and developed logical data model for MicroStrategy reporting environment.
• Identified source tables and columns required to create MicroStrategy project.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.0.3 to MicroStrategy 8.1.
• Improved the performance of the reports by changing VLDB properties.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Developed different transformations, which help business users to compare present data with previous year’s data in reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
• Performed Daily Checks for Job Monitor, user sessions and Cache Monitor to keep the system stable.
• Actively participated in developing Report Delivery Schedules. Modified VLDB Settings to tune the reports for faster execution.
• Implemented Narrowcast tasks like service designs, subscription, scheduling and administration.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 8.1/8.0.3, Teradata V2R6.1.1, SQL Server 2005, Windows XP, Erwin.