SUMMARY

• 9+ years of extensive IT experience in analysis, design and development of data warehouse and Business Intelligence using MicroStrategy reporting tool suite.
• Strong experience in Business intelligence project development and implementation using MicroStrategy 8.X/9.X, MicroStrategy Desktop, MicroStrategy Intelligence
• Server, MicroStrategy Web, MicroStrategy Enterprise Manager, MicroStrategy Mobile and Narrowcast Server.
• Working experience in many industrial sectors like Banking and Finance, Retail, Health Care.
• Good knowledge in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Extensively worked in Designing Schema like creating Attributes, Facts, Hierarchies, Transformations and developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, Consolidations as per the user requirements.
• Extensively worked on creating Transformations (Table Based) for Time Series Analysis.
• Good knowledge on using Pass - Through functions like Apply Simple, Apply Comparison by using Pass-Through Expressions in MicroStrategy.
• Expertise with Intelligent cubes and Visual Insights
• Hands-on experience working with VLDB and Optimization of query performance
• Experience in creation of Dynamic Enterprise Dashboards, Scorecards (KPI's) using nested panels, report hyperlinks, various Widgets and Selectors for better understanding of Business trends.
• Worked on implementing Command Manager scripts, Enterprise Manager, Integrity Manager and Object Manager.
• Proficient with different database systems like Oracle, Teradata, SQL Server, Netezza and MS Access.
• Experience in all phases of Software Development Life Cycle (SDLC) including business requirements gathering, Design, Development, Testing, and Implementation of Client-Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.
• Experienced working on MicroStrategy administrative tasks such as User management, Security and Project Duplication
• Experienced in using MicroStrategy Object Manager to migrate the objects/projects between different environments.
• Documentation in accordance with the Company/Client standards and processes.
• Have ability to meet deadlines and handle multiple tasks.
• Excellent communication & interpersonal skills with abilities in resolving complex software issues.

TECHNICAL SKILLS

BI Tools: MicroStrategy 9.x/8.x, (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, Report Services, Enterprise Manager, MicroStrategy Mobile, Distribution Services, Integrity Manager, Administrator, Architect ) TableauRDBMS Oracle … MS SQL Server … Teradata … Netezza, Sybase 12.x/11.x, MS Access

Operation Systems: Windows XP/2008, Redhat Linux, MS DOS

Tools: TOAD, Teradata SQL Assistant and AGINITY

Office Tools: MS-Office …

Languages: C, C++, PL/SQL,Java

Web Technologies: HTML, DHTML, and XML

PROFESSIONAL EXPERIENCE

MicroStrategy Consultant

Confidential, Radnor, PA

Responsibilities:

• I am responsible for handing end to end including ETL monitoring and Creating, Modifying ETL flow based on Requirements. Creating Data transformation, on-demand Reports and dashboards, that help to measure and analyze workforce performance and eliminate any surprises
• Developed and supporting Reports Like Budget Variance Report, Labor Effectiveness Report, Schedule VS Budget, Punch to Schedule Report, Schedule Edits Analysis, Schedule Effectiveness Report
• Designed Developed and Supporting advanced standard Dashboards like Store performance, Labor Effectiveness as well as Visual Insight Dashboards Like Schedule Adherence, Schedule Edits, Overspend, Store Performance ranking, Forecast accuracy
• Created Ad-Hoc Reports using Report templet
• Responsible for analyses of business processes to identify functional gaps and points of external integration
• Map business processes to Kronos Workforce Analytics functionalities
• Provided advice to business SME's to analyze, design and deliver Kronos Workforce Analytics functionalities
• Involved in upgrading Workforce Central and Workforce Analytics from V7 to V8 and responsible for end to end Project including plan, design, testing and launch efficient information on Kronos systems in support of core organizational functions for Workforce Analytics (MicroStrategy)
• Involved in creating Dashboards using Tableau
• In Agile environment, attended daily standup meetings, reviewed user stories.
• Designed, developed created Test plan and tested based on BRD and User Stories
• Did data setup and worked with Retail business to complete Business validation and end user testing
• Ability to handle multiple tasks under tight deadlines, according to priorities set

MicroStrategy Consultant

Confidential, Conshohocken, PA

Responsibilities:

• Developed Standard as well as Ad-Hoc Reports (Visual Insights Analysis) like Agency Rollup Reports, Claims Reports, Region Call-center analysis Reports, Agent Base Commission Statements.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, heat maps, bubble graphs) both in flash and Interactive modes.
• Gathering new user requirements and performing analysis of available/needed resources.
• Documenting improvisations and needed approvals based on the raw sources.
• Co-ordinating with ETL Team on the need of necessary tables/columns as per the new requirements.
• Responding to tickets raised by the users related to reports and performance.
• Generated reports using Advanced Metric objects, Filters, Prompts to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by Drill-Up, Drill-Down, and Drill-Across Hierarchies
• Involved in setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Worked with the end users to finalize the Dashboard layouts and also worked on fine detail formatting for a desired look and feel
• Created the Application objects like Filters, Metrics, Prompts, Custom Groups, Consolidations and Templates.
• Worked in MicroStrategy Administrator to create new users, roles, privileges, shared folders.
• Created Schema objects such as Attributes, Facts, Hierarchies and Transformations
• Worked on subscription sets, schedules, cache management for Distribution Services.
• Worked on the Excel formatting, and templates of the documents which are used in different services.
• Created Base Formulas and used it along with the metrics.
• Created intelligent cubes and reduced the database load and decreasing the report execution by using the Cube Services.
• Involved in the troubleshooting and performance tuning of the reports.
• Involved in Data Validation by Querying in Toad and Teradata SQL.
• Involved in Testing, Data validation of Reports and End - User Training

Environment: MicroStrategy 9.x (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Integrity Manager, MicroStrategy Enterprise Manager) Redhat Linux 5.4, Teradata, Netezza

MicroStrategy Consultant

Confidential, Atlanta, GA

Responsibilities:

• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects.
• Interact with Business Users, Subject Matter Experts and Business Analysts in gathering requirements and translate them into report specifications for the MicroStrategy Platform.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and involved in creating reports scalable to large volumes of data.
• Developed Dynamic Dashboards both in interactive & flash mode using various Widgets and Selectors, documents for summary level reporting with large datasets.
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created advanced dynamic dashboards for iPhone, iPad using MicroStrategy mobile.
• Worked extensively on complex reporting needs which involved creating Consolidations and Custom Groups.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created different Transformations such as Prior Period, Quarter-to-Date, Last year and effectively used them within the metrics to get previous period related data.
• Involved in upgrade activities from 9.0.2 to 9.2.1
• Used the VLDB properties for Performance tuning of the reports and significantly reduced the report run time. Also, used OLAP services like Derived metrics, View filters wherever necessary.
• Responsible for Unit Testing of the reports.
• Implemented Document performance optimizations and Troubleshooting document Performance.
• Involved extensively in Database Performance tuning
• Set-up a training lab since there were users of varying levels of knowledge about MicroStrategy. Advanced users used the desktop version while other used the web.

Environment: MicroStrategy 9.2.1/9.0.2 , Desktop, Object Manager, MicroStrategy Architect, MicroStrategy Administration, MicroStrategy Integrity Manager, DB2, Oracle.