SUMMARY

• 8 + years of IT experience in Data Warehousing, Data Architecture and Data Modeling, using MicroStrategy Platform, Informatica, SQL Server and Erwin.
• 8 + years of strong experience using MicroStrategy Suite: Command Manager, Object Manager, Enterprise Manager, Administrator, Architect, Desktop, Web, and Narrowcast Server.
• 2 + years of experience in designing, developing, documenting and supporting Tableau Desktop.
• Participated in designing of Multidimensional Modeling in MicroStrategy, regulating Star and Snowflake Schemas.
• Handling slowly changing dimensional Modeling in a data warehouse depending on teh user’s needs.
• Proficient Knowledge in creating Schema Objects(Attributes, Facts, Transformations, Hierarchies, Partition Mappings) using teh Data warehouse.
• Expert at creating complex and efficient Reports using Custom Groups, Consolidation, Prompts, Filters and Bypass Functions.
• Expertise with most of teh Widgets and Selectors used in teh reports service documents and extensively worked on creating highly interactive Dashboards.
• Extensively worked on MicroStrategy Administration that includes Intelligence Server Administration, configuration of Memory settings, Performance monitoring and VLDB Settings.
• Good exposure in Tableau Desktop, Tableau Reader, Tableau online and Tableau Server.
• Expert in Database development skills using SQL, PL/SQL, stored procedures, stored functions, packages, and triggers.
• Experience in understanding Business Applications, Business Dataflow and Data relations from them. Exception ability to quickly master new concepts and capable of working in - group as well as independently.

TECHNICAL SKILLS

OLAP Tools: MicroStrategy, Tableau and Power BI

ETL Tools: Informatica and SQL Server

Data Modeling: Erwin 4.0

RDBMS: Teradata, Netezza Twinfin, Oracle, MS SQL Server and Hive

Languages: SQL, PL/SQL, T-SQL and HTML

Operating Systems: Windows, UNIX and Linux.

PROFESSIONAL EXPERIENCE

Confidential, North Brunswick, NJ

Sr. MicroStrategy Developer

Responsibilities:

• Analysis, design development and implementation of new reporting requirements and providing estimates to support timelines and deliverables.
• Designing and building Microstrategy schema objects and public objects by creating facts, attributes, hierarchies, reports, filters, and metrics using Microstrategy Desktop.
• Designing Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run teh report.
• Designing advanced Dashboards/Documents both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools and designing Visual Insight reports.
• Validating report results against requirement deliverables for accuracy.
• Troubleshooting and analyze data issues within reports.
• Troubleshooting teh performance issues with creating and scheduling cubes and caches.
• Creating complex reporting objects using Relationship filters, Metrics, Nested Prompts, Hierarchy Filters, Consolidations and Custom Groups, Free form SQL reports.
• Providing knowledge to users both in MSTR Desktop and Web.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Environment: MicroStrategy 10.4/10.3, Architect, Desktop, Web, Visual Insight, Tableau 10.3, Hive, Hadoop and SQL Server.

MicroStrategy Architect

Responsibilities:

• Involved in gathering Business requirements and determining teh appropriate facts, attributes and metrics.
• Responsible for teh Creation of Schema Objects like Attributes, Facts, Hierarchies and Transformations Public Objects like Reports, Documents, Metrics, Filters, Prompts, Custom Groups & Consolidations and other public objects.
• Report manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.
• Created Dashboards both in GRID/GRAPH modes using Panel stacks, panels, selectors and other functional tools.
• Design and deploy complex scorecards and dynamic dashboards covering key performance indicators by using different widgets trough MicroStrategy Desktop and Web.
• Created Analysis dashboards by using MicroStrategy Visual Insight to explore and understand teh data using intuitive data visualizations.
• Created custom drill maps as required in reports for drill through functionality.
• Developed basic and user-specified Metrics (level, conditional, compound).
• Provided proactive Production support for MicroStrategy and other BI/Analytics applications by resolution of issues in a timely manner.
• Implemented Microstrategy Integrity Manager to monitor teh metadata object changes across all teh development environments.
• Modifying teh privileges to teh users for teh projects like enabling/disabling POWER USERS and other Standard User privileges.
• Supporting teh existing projects and enhancing teh reports on requirement.
• Providing knowledge to Users both in MSTR Desktop and Web.
• Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau.
• Developed Tableau workbooks to perform YTD, QTD and MTD type of analysis.

Environment: MicroStrategy9.4.1, Architect, Desktop, Web, Visual Insight, Tableau 9.3.x and Oracle Toad.

Confidential

MicroStrategy Consultant

Responsibilities:

• Gathered and analyzed relevant data and created schema that fit reporting requirements. Defined fact and dimension tables, created aggregate table for performance.
• Performed Requirement Analysis to collect various business measures and attributes to develop a reliableStar Schema as per business logic.
• Responsible for creating Application objects using MicroStrategy Desktop and Web.
• Creating advanced metrics (level, conditional), filters, consolidations, custom groups and Reports.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run teh reports.
• Responsible for creating Reports and Dashboards/Documents, based on requirements.
• Design and deploy complex scorecards and dynamic dashboards covering key performance indicators by using different widgets trough MicroStrategy Desktop and Web.
• Designing and developing visually appealing, informative Mobile Dashboards for tablets and phone devices (android and iOS).
• Worked with MicroStrategy Technical Support, to find teh solutions and workaround for Product Related Issues.

Environment: MicroStrategy9.4.1, Architect, Desktop, Web, Oracle Toad.

Confidential

MicroStrategy Consultant

Responsibilities:

• Designing and building Microstrategy schema objects and public objects by creating facts, attributes, hierarchies, reports, filters, and metrics using Microstrategy Desktop.
• Interfaced with project managers during requirements phases to estimate time and effort associated with new project requests.
• Design and deploy complex scorecards and dynamic dashboards covering key performance indicators by using different widgets trough MicroStrategy Desktop and Web.
• All teh development and testing followed by Agile movement process.
• Interacted with and supervised report developers and architects on offshore.
• Provided technical leadership for teh solution delivery teams. Involved in teh mentoring and of report developers.
• Participated in performance and quality assurance reviews of new and existing reports and environments.
• Used Object Manager to deploy teh objects across teh Environments.
• Worked on Microstrategy Integrity Manager to monitor teh metadata object changes across all teh environments.
• Created teh user test cases on look and fell after web portal SDK customizations.
• Coordinated teh Onsite-Offshore model of project execution.

Environment: MicroStrategy9.4.1, Architect, Desktop, Web, Visual Insight, Oracle Toad and Netezza.

Confidential, Charlotte, NC

MicroStrategy Architect

Responsibilities:

• Worked extensively with Business Analyst and Business Users to gather requirements and documented MicroStrategy Design Document, Data Mapping Document, and Business Requirement Document.
• Created LLD’s for teh design of new reports based on teh requirements from teh users.
• Created three types of reports like standard reports, ad-hoc reports and Freeform SQL reports and also involved in optimization of teh schema and tuning queries for performance.
• Crated Intelligent Cubes for (ROLAP services) better and faster response for reports and documents as per teh user requirements.
• Design and deploy complex scorecards and dynamic dashboards covering key performance indicators by using different widgets trough MicroStrategy Desktop and Web.
• Created Analysis dashboards by using MicroStrategy Visual Insight to explore and understand teh data using intuitive data visualizations.
• Embedded MicroStrategy reports, documents and scorecards in SharePoint portal.
• Participate in test planning and test script definitions for Reports and Dashboards.
• Involved in managing projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Collaborates with teh offshore team to deliver teh designed solutions within teh allocated time frame.
• Involved in installations and configurations of MicroStrategy application and its components to teh users.

Environment: MicroStrategy9.3/9.2.1, Architect, Desktop, Web, Visual Insight, Oracle Toad, SQL Server 2008, SharePoint 2010.

Confidential, Charlotte, NC

MicroStrategy Report Developer

Responsibilities:

• Created Application objects like Metrics, Filters and advanced objects like Derived metrics, Compound metrics, Consolidations, Custom Groups.
• Extensively involved in teh conversion of Teradata specific reports to reports that will be used for Netezza by using all teh features of MSTR version 9.2.1.
• Created LLD’s for teh design of new reports based on teh existing reports used in teh environment.
• Generated different kinds of Pass-Through Functions and used time filters like current month and previous year for BI reporting.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Created Ad-hoc reports by gathering specific requirements from different users.
• Designed an efficient BI Dashboard for teh Company Executives, through efficient use of MicroStrategy Report Services.
• Involved in teh troubleshooting and Performance Tuning of teh reports.
• Collaborated with different technical resources in teh team to ensure TEMPeffective and efficient development, delivery and deployment of reports.
• Interacted with and supervised report developers at offshore.
• Created test scripts based on teh business scenarios to optimize different MicroStrategy reports being delivered to teh end users.
• Involved in SDK portal integration testing and created test cases as per teh web customizations.
• Involved in teh analysis of teh source system data and played a key role in User Acceptance Testing of teh reports.

Environment: MicroStrategy 9.1.2/9.2.1 , Architect, Desktop, Oracle Toad, Object Manager, Integrity Manager, Netezza and Teradata.

Confidential, Grand Rapids, MI

MicroStrategy Consultant

Responsibilities:

• Analyzed existing systems and gathered requirements, reviewed and evaluated user needs.
• Involved in dimensional modelling and recommended appropriate changes to teh snowflake schema based on teh reporting requirements.
• Created and implemented advanced MicroStrategy reports by creating attributes, hierarchies and facts to meet teh in-house Business Requirements.
• Created reports for sales and marketing with teh drill down methodology in all options.
• Extensively used filters, consolidations, transformations and custom groups to generate reports for Business analysis.
• Created Market Basket Analysis reports to analyze provide insight into wat customers buy together most often.
• Upgraded MicroStrategy environment from version 8.1.2 to 9.
• Involved in troubleshooting MicroStrategy reports by optimizing teh SQL using VLDB properties.
• Created Transformations (table based, formula based) for allowing comparative analysis.
• Created intelligent cubes and published reports on MicroStrategy Web.
• Used ScanMD and MD Doctor frequently to detect and fix logical and physical metadata inconsistencies respectively.
• Used Command Manager Scripts for user role creation etc.
• Created users, roles and privileges using MicroStrategy Desktop.

Environment: MicroStrategy 8.1/9.0.1/9.2.1/9.3.0 (Administrator, Desktop, Architect, Web, Command Manager, Object Manager, Narrowcast Server, Enterprise Manager), Teradata and SQL Server 2008.