SUMMARY

• 8 Years of strong experience in Business Intelligence (BI) and Data Warehousing Project development and implementation using Microstrategy10.x/9.x/8.x product suites including Microstrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server etc.
• Expertise in creating and integrating Microstrategy reports, objects like Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups and generic cubes.
• Strong Experience of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi - dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Used MicroStrategy tools like Object Manager to migrate the objects/projects between MicroStrategy environments.
• Experience in creating Report Service Documents, pixel perfect Dashboards and Visual Insight analytics templates.
• Developed the semantic layer, metadata, reports, and report definitions.
• Designed interactive and visually stunning dynamic Dashboards using report services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations.
• Primary responsibility to support production platform and maintain pre-production and test server environments for MicroStrategy applications.
• Created drill maps for end users to drill down and recover data.
• Worked with Logical and physical modeling along with design and implementation.
• Expertise in migration of Projects / Objects between different environments.
• Strong hands-on experience on advanced Report Development.
• Handled Admin activities including user and user group creation/modification, project security, license maintenance, and object migrations across all environments.
• Interact with multiple user groups and maintain primary responsibility to ensure Microstrategy Web, Microstrategy Application servers are available for user needs.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Experience using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensive knowledge of T-SQL, PL/SQL and worked on very large databases in Teradata 15/14/13/VeR6/V2R5, Oracle 12c/11g/10g/9i, and MS SQL Server 2016/2014/2012/2008.
• Involved in job scheduling, monitoring and production support in a 24/7 environment.
• Provided knowledge transfer and training to personnel as per project plan.
• Supported the project manager in planning deliverable, scope, schedule and other aspects of the project.
• Excellent analytical and communication skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

PROFESSIONAL EXPERIENCE

Sr. Micro Strategy Developer

Confidential, Richmond, VA

Responsibilities:

• Involved in implementing the Full Life Cycle of the project right from requirement gathering and documenting the specifications to delivering the end reporting solutions.
• Created MicroStrategy Schema objects and Application objects by creating Attributes, Facts, User hierarchies, reports, filters and metrics using MicroStrategy Desktop.
• Resolve architecture layer issues, and work with the database team on issues at the physical table layer.
• Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, Prompts and compound Metrics.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metrics, Adhoc reports).
• Experience in creating complex reports in MicroStrategy Desktop using features like Templates, Transformations, Custom Groups and Consolidations.
• Extensively created MicroStrategy Report Services Documents, Dashboards for Web & Mobile (iPad) users.
• Create Documents in Grid and Graph mode by using MicroStrategy Report services.
• Created Report Builder, Visual Insight screens for power users to help them create their own reports, dashboards.
• Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like ApplySimple, Apply Comparison to overcome complex logic in creating objects.
• Embed handcrafted SQL statements directly into the MicroStrategy BI platform using The Freeform SQL editor.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Rebuilding the indexes at regular intervals for better performance. Monitored and modified Performance using execution plans and Index tuning.
• Widely used VLDB properties to set default criteria at project level and at individual report levels to overcome performance issues.
• Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents using high volume datasets.
• Design and develop interactive reports on top of OLAP cubes or data warehouses.
• Analyzed existing SAP Business Objects reports, documented the Technical specifications and converted SAP Business Objects reports to MicroStrategy.
• Created PL/SQL stored procedures, functions and ETL packages for moving the data from staging area to Data marts.
• Created scripts to create new tables, views, queries for new enhancements in the application using TOAD.
• Used the Object Manager to migrate the objects from DEV to UAT in Microstrategy.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in MicroStrategy Upgrade to 10.4 and then to version 10.9. Used MicroStrategy Integrity Manager for regression testing during upgrade.
• Used Narrowcast Server to automate FX TCA Order Completion reports, Aggregate reports to internal and external clients.
• Involved in MicroStrategy migration from Solaris to Linux, also database migration from Physical Oracle database to DHS Virtual hosts.
• Troubleshoot user-caused performance issues and recommend efficient prompt answers, or make report modifications to guide the user toward efficient runs.
• Troubleshoot report performance issues and make suggestions for new or tuned aggregations.

Environment: MicroStrategy 10.9/10.4/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, DB2.

Sr. Micro Strategy Developer

Confidential, Cleveland, OH

Responsibilities:

• Design and develop Microstrategy reports and Freeform SQL reports for stakeholders.
• Develop Microstrategy Report Services documents and Flash dashboards including widgets, selectors, Export link, comment widgets, graphs, checkbox, radio button etc.
• CreateMicrostrategy Schema Objects and application objects for projects.
• Hands on experience with Narrowcast services to automate the reports.
• Perform Administrative tasks such as creating user, setting up privileges. Security access to metrics and attribute level.
• Design and developMicrostrategy projects, logical data marts and table structures; and define attributes, dimensions, hierarchies and metrics.
• Create complex reports where Prompts, filters, Conditional, Transformation metrics and Level Metrics are used.
• Create consolidations and custom groups in the repots according to the requirement.
• Gather new requirements from business stakeholders and plan, conduct, develop BRDs for development sizing on a new product.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work and for assigned programs and projects.
• Work in Agile development environment where daily scrum meetings are held for deliverable, progress and updates.
• Create test plans and execution for data validity and accuracy.
• Document systems through object models, data definitions and naming conventions.
• Apply conceptualized and creative-thinking expertise toward possible reporting solutions or alternatives.

Environment:Microstrategy 9.4.1 (Architect, Desktop, Object Manager, Enterprise Manager, Integrity Manager, Command Manager, Intelligence Server, Narrowcasting), DB Visualizer, Distribution Services, Web, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, MS SQL Server, Oracle, Sybase.

Sr. Micro Strategy Developer

Confidential, San Francisco, CA

Responsibilities:

• Worked with business users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in MicroStrategy.
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis
• Developed MicroStrategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals.
• Designed Reports, Documents and Dashboards using Desktop.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics.
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in optimization of code and tuning queries for performance.
• Production Support has been provided for ongoing issues.

Environment: MicroStrategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Microstrategy Developer

Confidential, Dallas, TX

Responsibilities:

• Reviewing business and functional requirements for various modules so as to have better understanding of the overall application.
• Involved in Dimensional Data Modeling (Snow-Flake schema) Data Architecture, Business and Data Analysis.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in providing solutions for Complex Time Dimension related issues.
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Involved in creation of Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex MS reports in an efficient way.
• Creating Dashboard Reports, RS Documents to view personalized reports based on user requirements.
• Worked extensively on Complex reporting needs, which involved creating Consolidations and Custom Groups.
• Enabled the Advanced Qualification option for the Filter Editor and created Custom Expressions to build Relationship filters according to the Business logic.
• Created the Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary.
• Created different Transformations to get the last year actual transactions, Month to Date (MTD), Quarter to Date (QTD), Year to date (YTD) calculations and effectively used them with the metrics.
• Implemented Drill Maps functionality in various reports.
• Optimized Query Performance using VLDB settings.
• Created and configured the Narrowcast Server to execute and deliver reports to your emails using dynamic subscriptions.
• Worked as MicroStrategy support admin to handle some of the administrative tasks.
• Coordinate with DBAs and the ETL architects to design and create Tables in the SQL server database to improve the performance of reports.
• Involved in Data validation testing and UAT to ensure data quality. Provided post production support to end-users.

Environment: Microstrategy 9.3/9.0/8.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Windows Server, MS SQL server 2008R2, TeradataV2R5, Oracle, Toad.

Microstrategy Developer

Confidential

Responsibilities:

• In design/development life cycle including gathering requirements, user interaction and report design and development
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star and Snow flake schema with Fact and Dimension tables.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Created several data marts using MSTR for different tools to access large datasets.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked on administrative tasks like User Groups, Roles, Privileges, and Cache Management.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.x/8.x (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), Linux, Windows Server, SQL server, Oracle.

SQL BI Developer

Confidential

Responsibilities:

• Gathered business requirements from Business Analyst and translated them as technical specifications.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Created Reporting documentation by analyzing Report data and used as reference to develop reports from Data Mart.
• Implemented Logging Configuration to monitor the execution of SSIS package.
• Created package configuration to change source, destination credentials and load data as per effective date range.
• Implemented Checkpoints, to return failed package from point of failure.
• Implemented Event Handlers in SSIS package.
• Identified Attributes, Hierarchy and Created Cube, generated SSRS Reports from this Cube.
• Created Tabular-Reports, Matrix-Reports, Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated multiple Enterprise reports (SSRS) from SQL Server Data Mart and included various reporting features such as group by, drilldowns, drill through, sub-reports.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.

Environment: SQL Server 2008/2005, Erwin, Business Intelligence Studio, Visual Studio 2008, Windows XP, Linux, DB2.

TECHNICAL SKILLS

BI Tools: Micro strategy Desktop 7x/8x/9.x/10.x (Microstrategy Desktop, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services, Documents, Dynamic Dashboards, Narrowcast server & Enterprise Manager.

Database: Oracle 12c/11g/10g/9i, MS SQL server 2016/2014/2012/2008R2/2008, Teradata 15/14/13/VeR6/V2R5, MY SQL, MS Access.

ETL Tools: Informatica Power Center 9.x/8.x, SQL Server SSIS services.

Other Tools: Toad, SQL Assistant, PL/SQL Developer, MS Office, Microsoft Visio, Erwin, DB Visio.