SUMMARY:

• Over five years of experience in Data Architecture, Data Modeling, MicroStrategy Platform and Web Application development. Extensive working knowledge and best practice expertise in full MicroStrategy Product Suite including Intelligence Server, Administrator, Architect, Desktop, SDK, Web Universal, Object Manager, Enterprise Manager, Visual Insight and Mobile.
• Strong and comprehensive knowledge of OLTP and OLAP System functionalities, Database schema - Star and Snowflake schema (Dimensions and Facts) design, E-R Modeling and architecture development from different data sources. Best practice with Intelligent Cube, Dashboard design, Mobile Application, Visual Insight for enhancement of business performance.
• Extensive knowledge on using Microstrategy Web-accessible service, like Data as a service; and proficient in embedding MSTR components into HTML Page by using URL API and SDK Web plug-ins. Experience in handling projects end-to-end including analyzing requirements, schema architecture, design, build and unit testing of the reports.
• Extensive experience in Agile software development and Scrum methodology. Extensive hands on experience in software development life cycle (SDLC) in Project Definition, Analysis, Design, Development, Testing, Implementation and Support Expertise in performing MicroStrategy upgrade/installation, Intelligence Server tuning and Project Configuration including VLDB properties.
• Experience in analyzing and creating Use Case Diagrams, Activity Diagrams, Class diagrams, Sequence Diagrams, Data/Flow/Navigational flow diagrams using MS Visio; to extract Business Process Workflow, thereby helping the development team and quality assurance teams in understanding the requirements. Good at creating swim lane diagrams and As-is and To-be modeling.
• Outstanding problem solving capability and leadership competencies. Collaborated with QA testing team, prepared technical training for end users. Write up technical design documentation and provide user guide for Microstrategy application. Self-motivated team player with the ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS:

BI Tools: MicroStrategy 9.0.1, 9.2.1, 9.4.1, 10 Architect, Desktop, Web, Intelligence Server, Narrowcast Server, OLAP Services, Distribution Services, Object Manager, Command Manager, Enterprise Manager, Integrity Manager; Report Services (Dashboard), Visual Insight and Mobile BI.; Microsoft SQL Server.

ETL Tools: SQL Server Integration Services (SSIS).

Data Modeling Tools: Microsoft Visio. Erwin.

Query Tools: Microsoft SQL Server, Teradata SQL Assistant (query man), DBVisualizer v9.0.6.

Management Tools: ERP/Microsoft Dynamics, Change Management, Waterfall, Agile, CRM, PeopleSoft, ACL, SDLC, Business Process Analysis, System Integration Planning.

Web Programming: HTML, DHTML, CSS, XSL, ASP, XML, XSL, ASP, JSP, SQL, JavaScript, .NET/ASP.NET, VB.NET.

OS: Windows NT/98/2003/7, Linux.

RDBMS: Oracle, SQL Server 2005/2008, Teradata, Netezza, MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mill, MD

Microstrategy Developer

Responsibilities:

• Worked closely with business sponsors in defining report requirements, functional scope and identifying source data. Developed POC (proof of concept) reports and dashboards with Microstrategy 9.4.1 and presented to business users. Using mock-ups as an effective tool to communicate with business users regarding dashboard design, which significantly reduced development time and iterations of dashboard revisions. Provided URLs to Java team to embed the Microstrategy dashboards and download documents into HTML websites.
• Worked extensively with MicroStrategy in developing application and schema objects such as filters, prompts, metrics, custom groups and consolidations to develop reports and dashboards. Created advanced grid reports, consisting of object prompts on template and filters to allow end-users to generate ad-hoc report. Designed and developed interactive reports on top of OLAP cubes or data warehouses.
• Troubleshooting with report SQL, located data discrepancies, and located inefficient or incorrect joins that caused performance issues. Resolve architecture layer issues, and worked closely with the Database team and ETL team to investigate physical table layer issues. Experienced in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Created different transformations to get last year, quarter, month transactions, and effectively used them with the metrics. Worked on numerous enhancements to existing reports like adding and/or modifying filters, metrics, report layouts, drill functionality etc. according to the changed requirements and business logic. Worked extensively on level metrics, i.e. rolling up the metric calculation to a particular attribute on or off the report. Utilized report limits, view filters and thresholds in some reports to meet customized requirements.
• Active performance tuning to avoid the compromise of performance by utilizing MicroStrategy OLAP Services, Intelligent Cube, VLDB properties and data warehouse aggregate tables. Optimize query performance by experimenting and configuring VLDB properties in MicroStrategy such as modifying the intermediate table type and scheduling efficient report cache. Identified and utilized variety of advanced grid reports, consisting of object prompts on template and filters to allow end-users to generate ad-hoc report by dynamically selecting attributes, metrics and filters.
• Extensively worked on settings of VLDB properties at report and Metric Levels to tune the SQL and define Outer Joins between tables to get complete data from the required table and used different Query Optimization Settings specific to database to improve performance of Query. Created and modified the logical views to meet the logical data model requirements.

Confidential, Pittsburgh, PA

BI Architect/ Developer

Responsibilities:

• Made recommendations to upper management on use of MicroStrategy tools across the enterprise. Responsible for interacting with business analysts and user interface design team to get the reporting requirements and implementing them by developing complex reports and dashboards. Effectively communicated with different departments regarding Microstrategy training, troubleshooting, and operating.
• Architected MicroStrategy schema, e.g. attributes, facts and hierarchies with logical views, form group and pass-through functions. Developed advanced reports using level metrics, conditional metrics and relationship filters. Performance tuning of reports and dashboards at the report level, Intelligence Server level and database level. Worked with ETL to re-model the tables and introduce surrogate keys to implement type-II slowly changing dimension to support As-Was reporting requirement. Resolved many-to-many relationships, ragged hierarchies and recursive hierarchies’ complexities.
• Designed and developed reports, scorecards and dashboards and allow users to drill into the information to get the desired results. Conducted training program of MicroStrategy Visual Insights to help users to achieve optimal data visualization. Created large number of dashboards with layers of panels and multiple grids displayed using different widgets including Babble Grid, Fisheye Selector, Time Series Slider, Heat map, Google map, Waterfall, Microcharts Widgets, Interactive stacked/bubble Graph.
• Configured clustered Intelligence Server and Web Server. Offered plans for performance tuning of Intelligence Server and troubleshooting of Intelligence Server issues by optimizing the SQL using VLDB properties. Involved in upgrading MicroStrategy from version 9.2.1 to 9.4.1 to ensure consistency and reliability of data. Coordinated with QA testing teams and other application teams during software and systems upgrades and maintenance. Used freeform SQL editor to meet the requirements.
• Managed MicroStrategy object migration from one environment to another using Object Manager and Project Merge wizard depending on the job sizes. Assisted in preparing SLA policy to production user communities. Created security roles and security filters to maintain users privileges and data access, configured object ACLs to manage user permissions. Created and modified users to give them appropriate access to different objects.
• Utilized Microstrategy 10 Desktop to connect various data sources to build interactive dashboards. Prepared and enriched data to better facilitate analysis. To display multiple visualizations and insights using bar charts, bubble charts, line charts and combo charts, etc. Coordinated demo presentations to business users to help them better understand the functionality and visual effects of Microstrategy 10 Desktop.

Confidential, Pittsburgh, PA

Senior MicroStrategy Consultant

Responsibilities:

• Established good working relationships with power users extensively to fulfill their reporting needs and to gather reporting requirements. Interacted with DBAs to in corporate additional business data to the data warehouse for BI reporting. Trained power users with ad-hoc reports and visual insight functions, and helped end-users to understand the main hierarchies.
• Worked extensively with MicroStrategy 9.2.1 and 9.3.0 in creating MicroStrategy schema objects and application objects. Created advanced metrics (level, conditional,), advanced filters. Used advanced reporting techniques such as ApplySimple, ApplyComparison, Attribute-to-attribute filters, consolidations, custom groups to meet complex reporting requirements. Designed schema objects and developed compound and heterogeneous attributes.
• Worked on plenty of enhancements to existing reports/architecture change which involved the remapping of the existing objects to the columns in the new tables; updating or adding attributes, filters, metrics, attribute relationships and facts to efficiently support new as well as existing reporting requirements, according to the changed requirements and business logic.
• Created Data Visualization reports using Bar Graphs, Pie charts, trend lines for data analysis and use various MicroStrategy widgets including bubble chart, data cloud, fish eye selectors and slide bars. Conduct training program of MicroStrategy Visual Insights to help users to achieve optimal data visualization.
• Maintained users, groups, security roles and their associated privileges, and access control lists to ensure proper authorization and authentication of the system. Used the Object Manager to migrate the objects among Development, UAT and Production environments. Developed Narrowcast services and associated information objects, question objects, documents, schedules, and static and dynamic subscription sets.

Confidential

MicroStrategy Developer/Business Analyst

Responsibilities:

• Managed redesign of onboarding processes of Microstrategy mobile dashboard. Extensively used Agile and Scrum Methodology in the process of the project management based on SDLC. Performed Manual Testing for the functionality and the interface of the GUI application. Coordinated with end-users to schedule and support User Acceptance Testing (UAT).
• Installed and configured Microstrategy Mobile Server to mobile users for production. Set up procedures for moving objects from test to production using MicroStrategy Object Manager. Worked with the client creating complex reports that used imbedded metrics and filtering. Used MicroStrategy Architect to create attributes, hierarchies, and transformations.
• Review and update Business Requirement Documents, Functional Requirements Specification, User Interface Design Documents and Use Cases to understand the functionality and working of the custom developed application. Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system. Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations. Wrote Use cases, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Experience in Microstrategy Mobile. Good involvement in the dashboard design to make it efficient in iPad. Created iPad dashboards both in offline and online mode. Applied security authentication function on Mobile Apps through Single Sign-on form based authentication, manually configured on Mobile configuration page.
• Mobile dashboard development utilized heat map widget, micro charts widget, time series widget, data cloud widget, data selection widget, panel stacks, multiple tabs and allowing drilling from high level dashboards and scorecards to detailed reports. Created storyboard wireframe using Microstrategy Visio. Effectively used links editor, URL API, and document links to link other documents to increase the flexibility of the mobile app. Created views, layouts, information windows, element and value prompts for optimal viewing on iPad.