SUMMARY

• Over 9+ years of IT experience in Data Warehousing, Data Modeling and Business Intelligence applications.
• Expertise in implementing projects using MicroStrategy ( 10.7/10.4/10.2/9.4.1/9.3.1/9.2.1/9.0.2/8. x) - Desktop, Web, Intelligence Server, Architect, VI, Mobile and Narrowcast Server.
• 8+ years of experience in MicroStrategy suite (Desktop, OLAP services, Reporting Services, Dashboards and Score cards).
• Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
• 5+ Years of experiences in Tableau (2019/2018/10.5/10.3/10.2/10/9. X/8.X) - Desktop, Server.
• Experience with Data Modeling, designing Data Marts using Star Schema and Snow Flake Schema, Physical and Logical Tables.
• Experience working on MicroStrategy Semantic modeling.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensively worked on creating complex reports and dashboards that included advance metrics, relationship filters, dynamic filters, advance prompts, templates, custom groups and consolidations.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Expert in MicroStrategy Architecting such as creating Schema objects (Facts, Attributes, Hierarchies, Transformations) and Public Objects (Metrics, Filters, Prompts, Custom groups, Consolidations, Drill maps and Templates.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards in Tableau.
• Experience working in Dash boarding and Scorecards using MicroStrategy Reporting Suite.
• Extensively worked on Visual Insights for data discovery, data analysis and dashboard prototyping using files based and database sources.
• Extensively worked on creating and publishing Intelligence Cubes.
• Extensive experience Tableau Desktop, Public, Mobile, and Server
• Experience in data extraction and transformation (ETL) using Informatica Power Center 8.1, 8.6, 9.1.
• Extensive experience working in an agile development and Waterfall environment.
• Extensive experience in dealing with a variety of Relational Databases like Teradata, Oracle, DB2, and SQL server.
• Experience in creating Stored Procedures, Triggers, Functions, and Transact SQL, including the use of nested table expressions, unions, multi-table joins, scalar functions, outer joins and derived columns.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools: MicroStrategy (11.X, 10.7/10.4/10.2/9.4.1/9.3.1/9.2.1/9.0.2/8. x/7.x), Tableau, IBM Cognos, SSRS, SSAS, Power BI.

Databases: Oracle 8i, 9i, 10g, 11g, Teradata V2R4/V2R5/R6, MS SQL Server 2005, 2008, 2012, DB2, NETEZZA, MS Access.

Domains: - Compliances, AML, AB&C, Treasury, Finance and Regulatory Reporting.

Programming Languages: C, Java, JavaScript, SQL, PL/SQL, C#, VB, HTML, DHTML.

Modeling Tools: UML, MS Visio, Case Studio.

Operating Systems: UNIX, Linux, Microsoft Windows NT/XP/ 2000/2003/2008 , Vista, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Microstrategy Consultant

Responsibilities:

• Worked with multiple Business Users to discuss and finalize.
• Worked with Data modeling team and Data Architect on logical data models, recognize source tables to build MicroStrategy schema objects including Attributes, Facts, Hierarchies and Relationships.
• Created various public Objects Filters, Matrix according to the requirements.
• Converted existing reports and dashboards from Crystal Reports and SSRS to MicroStrategy.
• Trained Business users on MicroStrategy VI
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Created Microstrategy FTP connections and delivery system.
• Used MicroStrategy cubes to create data visualizations in Tableau.
• Designed and documented the entire Architecture of Power bi Poc.
• Created multi layered analyses using layers and panels for showing KPIs using MicroStrategy Visual Insights.
• Hand full experience with Narrowcast which includes creation of Services, Information Objects, Subscription Set, Publication and Schedules as per the requirement.
• Used Cube Advisor to determine the best practices for supporting dynamic sourcing for existing project.
• Tested all the reports by running queries against the warehouse using TOAD. Also Compared those queries with the MicroStrategy SQL engine generated queries.
• Exported data from Teradata using Fast Export utility.
• Experience in using Teradata utilities such as Fastload, Multiload and Fast Export.

Environment: MicroStrategy 10.11 (Architect, Desktop, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager), SQL Server developer.

Confidential, Charlotte, NC

Microstrategy Consultant

Responsibilities:

• As a part of COE worked with multiple Teams and Business User to discuss and finalize requirements for the datasets to be used in Dynamic Dashboards and provide best practice whenever required.
• Worked with multiple Business Users to discuss and finalize layouts and designs of Dynamic Dashboards.
• Worked with Data modeling team on logical data models, recognize source tables to build MicroStrategy schema objects including Attributes, Facts, Hierarchies and Relationships.
• Created various public Objects Filters, Matrix, Custom Groups and Consolidations according to the requirements.
• Converted existing reports and dashboards from Tableau and QlikView to MicroStrategy.
• Developed working mockups for business users to help them D3 visualize the final solution.
• Trained Business users on MicroStrategy VI and MicroStrategy office.
• Installation, maintenance and administration of Tableau Servers.
• Experience in Marks, Publisher and Security in Tableau.
• Experience with Tableau for Data Acquisition and data visualizations for client and customers
• Work on creating Tableau visualize for Treasury as POC and trained users on Tableau.
• Expertise in Tableau Analysis
• Experience in BI interactive Dashboards and Tableau Publisher.
• Used MicroStrategy cubes to create data visualizations in Tableau.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Designed and documented the entire Architecture of Power bi Poc
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.. .
• Installed and configured Enterprise gateway and Personal gateway in Power bi service.
• Created Workspace and content packs for business users to view the developed reports.
• Scheduled Automatic refresh and scheduling refresh in power bi service.
• Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.
• Created intelligent cubes, datasets with derived elements and cube-based dashboards.
• Created various Metrics as Conditional Metrics, Nested Metrics and Level Metrics as recommended.
• Created user specific Narrowcast Reports.
• Have been part of Daily/Weekly team meetings with various teams to provided requirements and track the progress of the project.
• Provided Data Analysis ensuring the data is authentic.
• Worked with data modeling team in creating Semantic Layers for optimization of reports.

Environment: MicroStrategy 10.2/10.4/10.11 (Architect, Desktop, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager), Tableau 10.3/10.5/2018/2019 , Oracle 11, IBM Netezza, SQL Server, Toad Datapoint, SQL developer, JAMS.

Confidential, Fort mill, SC

MicroStrategy Consultant

Responsibilities:

• Worked with business team as a Technical SME in creating Business solutions.
• Developed working mockups with sample data for business users to help them visualize the final solution.
• Analyzed existing warehouse schema and reports to create gap analysis.
• Developed reports and dashboards using multi-sourcing.
• Developed reports in power point and excel using MicroStrategy office Plugin.
• Created intelligent cubes, datasets with derived elements and cube-based dashboards.
• Implemented various workarounds like Hierarchies Prompts in cube-based data sets, hiding un-hiding using conditional formatting, table driven security datasets with system prompts.
• Defined best practices for Tableau report development.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Worked with data modeling team in creating Semantic Layers for optimization of reports.
• Converted existing reports and dashboards from Tableau and QlikView to MicroStrategy.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.X
• Created complex metrics using pass through functions, conditional statements, and level dimensionality.
• Created custom Enterprise Manger Dashboards for advanced usage analysis.
• Created Migration packages, integrity manager test cases for validation.
• Created user specific Narrowcast reports and PDF dashboards.
• Converted Flash dashboards to express mode/Interactive.
• Worked on maintenance task like updating reports and dashboards, remapping attributes and facts, etc.
• Developed quick Ad-Hoc reports for business analyses, VI dashboards sourced from MicroStrategy datasets, external data like Excel, CSV, and Custom SQL for senior Leadership.

Environment: MicroStrategy 9.3.1/9.4.1/10.2/10.4/10.7 (Architect, Desktop, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager) Tableau 8.3/8.2/8.1/ 8.2/8.1 , Oracle 10g, 11, SQL developer.