SUMMARY:

• Professional experience developing and maintenance of Enterprise BI Reporting applications using MicroStrategy. Leverage diverse experience and highly effective communication skills to provide critical and constructive guidance to customers, steering them towards a long - term path for success. Experienced architecting the MicroStrategy semantic layer in accordance with modeling conditions and reporting efficiencies.

TECHNICAL SKILLS:

Trainings: Tableau Desktop and Public (advanced), AWS.

Languages: HTML, DHTML, XML, XSL, Java Script, SQL, PL/SQL, and C.

OS: MS-DOS, Windows 95, and 98, 2k, XP & NT, UNIX, Sun Solaris 7-8.

Databases: Oracle 8i/9i/11g, SQL Server 6.5/7.0/2000, IBM-DB2, Teradata, MySQL

WORK EXPERIENCE:

MicroStrategy Consultant

Confidential - Charlotte, NC

Responsibilities:

• Support conduct management Insight reporting using MicroStrategy and Tableau
• Develop Publics objects for each project representing key dimensions, metrics, and different level of aggregations, cubes...
• Develop Reporting showing cases, case type, allegations, Type of allegations, Investigators, and Milestone for Conduct Management Portfolio.
• Develop datasets for dashboards Producing.
• Develop dynamic dashboards with selectors, links, Widgets, grid/graphs visualizations, Information window, etc.
• Optimize the MicroStrategy generated queries through database views, summary tables, and VLDB functions.
• Work with admin team to migrate reports and documents to UAT and PROD.
• Perform data analysis using Teradata, conduct unit testing and work closely with testers UAT, QA, QC using Teradata and PROD support to meet business requirement.

MicroStrategy Consultant

Confidential - Charlotte, NC

Responsibilities:

• Support Management of strategic risk reporting using Microstrategy
• Develop the schema layer for each project representing key dimensions, metrics, and different level of aggregations.
• Develop Reporting showing Opened Issues, Closed Issues, Issues Source, Issues root cause, Issues Owner, Correctives Actions and Milestone for Issue Management Risk Program.
• Develop dynamic dashboards with selectors, links, Widgets, grid/graphs visualizations, Information window, etc.
• Optimize the microstrategy generated queries through database indexes, summary tables, and VLDB functions.
• Conversion of Reports into Microstrategy from SSRS and Tableau, freeform SQL using Teradata and Schema Based.
• Created standard procedures best practices from scratch (naming convention, Folder structure, dashboard and visualization standards.
• Perform data analysis using Teradata.
• Conduct unit testing and work closely with testers UAT, QA, QC using Teradata and PROD support to meet business requirement.

Microstrategy Consultant

Confidential - Charlotte, NC

Responsibilities:

• Supported the wholesale group with Seal, Sales, Merchandising and Pricing reporting using Microstrategy.
• Developed the schema layer for each project representing key dimensions, metrics, and different level of aggregations.
• Developed grid and dashboards showing sales volume, price points for American tire products. Created dynamic dashboard with selectors, links, grid/graphs visualizations.
• Developed datasets for dashboards Producing.
• Worked with admin team to migrate reports and scorecards to QA, UAT and PROD.
• Optimize the microstrategy generated queries through database indexes, summary tables, and VLDB functions.

Microstrategy Consultant

Confidential - Fort Mill, SC

Responsibilities:

• Support various MicroStrategy customers within Citi with technical implementation in all phases of microstrategy reporting projects.
• Build the project microstrategy semantic layer (attributes, facts, hierarchies).
• Leverage Microstrategy architecting tools to implement complex database cases such as left outer joins, role recognition attributes, aggregate tables while creating efficient SQL queries to the databases.
• Implement drill down capabilities through custom hierarchies.
• Promote report performance optimization through indexes, table partitions (DB or MSTR), and the use of aggregate tables.
• Build cubes bearing in mind cube growth (indexes). Implement best practices in designing reports such as reference versus inferred filters, caching, folder nomenclature,
• Worked both in waterfall and agile environments.
• Perform data analysis using Teradata, conduct unit testing and work closely with testers UAT, QA, QC using Teradata.
• Worked with admin team to migrate reports to QA and PROD.
• Optimize the MicroStrategy generated queries through database indexes, summary tables, and VLDB functions

Microstrategy Consultant

Confidential - Atlanta, GA

Responsibilities:

• Supported sales management group with Microstrategy reporting. Developed reports around consumer sales, point of sale performance, default, deposits amount, other ratios.
• Gathered requirements from Business users, Stake holders for the project.
• Understanding client business needs and coming up with a reporting solution.
• Provide estimates for the reporting requirement.
• Creation and modification of Schema Objects (Attributes, Facts, Hierarchies and Transformations) as per the data model.
• Proposed naming standards for Attributes, Metrics and Filters to make easy for Business users.
• Created various Hierarchies which allow users to drill on reports.
• Developed Public objects such as reports/dashboards, Metrics, Custom Groups, Consolidations, Prompts, Templates and Filters as per requirements.

Customer Support Analyst

Confidential - Orlando, Florida

Responsibilities:

• Performed daily server maintenance, which included user set up, troubleshot SQL databases, file and print server troubleshooting (both hardware and software), disk usage tracking, and service pack testing and installation.
• Handled open service requests that are dispatched, implemented fixes (writing SQL scripts to create database objects like tables, views and sequences, checking network connections).
• Database and Operating System troubleshooting and problem resolution to environments including SQL, Oracle, Windows.