SUMMARY

• Over 8 Years of IT Experience in Business Intelligence (BI), Data Warehousing, Data architecture, and Data modeling using MicroStrategy 9.x/8.x Product Suites including MicroStrategy Desktop, Web, Architect, Administrator, OLAP Services, Intelligence Server etc.
• Expertise in full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
• Experience in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
• Extensively worked on creating and modifying MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.)
• Experience in creating and modifying Configuration Objects (such as project, users, user groups, security filter etc.) using Micro strategy desktop.
• Expertise with VLDB properties for Performance tuning of the reports and significant reduction of the report run
• Experience in coordinating with Database Management team, End users, Business Analysts in understanding their requirements.
• Very good understanding of Intelligence cube (i - cube), custom group and consolidation in Microstrategy.
• Involved in Trouble Shooting, Performance tuning of reports and resolving with in Business Objects Enterprise and Reports.
• Experience in performance tuning SQL queries by providing hints, obtaining explain Plan, analyzing tables and adding indices.
• Experience in validating end user report requests using SQL and Microstrategy tools
• Extensive knowledge of SQL, PL/SQL, TSQL programming and worked on very large databases like Oracle and SQL Server, Teradata.
• Experience in understanding of Business Applications, Business Dataflow and Data relations.
• Demonstrative knowledge of functional areas in Finance, Marketing, Sales and Operations, Customer Data and ability to develop complex quantitative solutions for Campaign Optimization, Customer Profiling and Segmentation
• Exceptional ability to quickly master new concepts and capable of working in group as well independently with excellent communication skills

TECHNICAL SKILLS

Database: Oracle, Teradata, SQL Server (2000/2005/2008 ), T-SQL, DTS, MS Access, PL/SQL

ETL Tools: Informatica, Data stage, SSIS

Programming Languages: SQL, C/C++, C#, HTML, JavaScript, PHP, PERL.

Scripting Languages: Unix Shell scripts, K shell, C shell.

BI/Reporting tools: MicroStrategy (8.x, 9.x, 10.x), Business Object, Hyperion Essbase, MS Excel

Operating Systems: Windows XP/2000/NT/Vista and UNIX, Solaris, Linux Red Hat

Version Control: Visual SourceSafe, Team Foundation Server(TFS)

Other Tools: SQL Plus, SQL *Loader, TOAD, Erwin, ER-Studio.

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

Sr. MicroStrategy Developer

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Performed full software development life cycle process (SDLC) of Initiation, Analysis, Design, Development, Testing, End User Acceptance presentations and Implementation.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Created advanced grid report, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Developed customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server.
• Optimized query performance by updating VLDB properties at project level and report level.
• Created Cubes and scheduled them to run weekly bases.
• Extensively worked in developing Attributes, Facts, Tables, Hierarchies, and Transformations.
• Created Transformations (table based, formula based) for using in comparative reports (year to date and month to date).
• Designed Dashboards in summarizing key business indicators by presenting them in visually intuitive, easy to read, interactive documents using the new selectors like radio buttons, check boxes, panels, slider, button bar etc.
• Worked extensively with the End Users to finalize the dashboard layouts and also worked on the fine detail formatting for a desired look and feel.
• Designing the schema layer or semantic layer for MSTR reporting and ad-hoc reporting.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes.
• Administered object migration using MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Performed Object Migrations using Object Manager from MicroStrategy toolbox
• Involved in managing Migration of MicroStrategy projects and objects from Dev to Testing and to prod.
• Troubleshoot and tune MicroStrategy reports by analyzing the generated SQL to determine data issues such as double counting, hitting incorrect fact tables, joins and insufficient data.
• Unit tested report layouts, validated the SQL query, Prompt ordering and defaults, security filters, export/print functionality and drilling options

Environment: MicroStrategy Desktop 9.x & 10.0 (MicroStrategy Administrator, MicroStrategy Narrowcast Server MicroStrategy Architect, MicroStrategy Desktop,, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows 7.

Confidential, Sacramento, CA

Sr. MicroStrategy Developer

Responsibilities:

• Responsible for understanding the business requirements from the users and analyzing the report specification documents
• Extensively worked with MicroStrategy Desktop. Extensive experience in building Filters, Consolidations, transformations and custom groups, attributes, hierarchy, metrics, schema objects and prompts to generate reports meeting the Business Analyst needs.
• Involved in writing the Functional & Technical Design documents. Responsible for complete Functional Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects.
• Understanding the Data model and identifying the tables to be used for reports
• Developed reports for MicroStrategy Web users.
• Created Metrics, Drill Maps, Filters, Templates, Hierarchies and Prompts to enable decision-makers to choose the condition for reports in MicroStrategy Desktop.
• Created Transformations (YTD, MTD, and QTD) for comparative reports to measure and extrapolate campaign results in real-time of previous similar campaigns & similar target market.
• Created Summary Dashboards and linked it to Drill-down dashboards using Edit Links and also Hyperlinks. Also used HTML code on Dashboard and created links.
• Used VLDB properties to optimize the SQL generation of the MicroStrategy reports for performance.
• Implemented OLAP cubes functionality in Query performance.
• Used various selector styles like Button Bar, Radio button, Check Box, Drop Down, List Box and Link Bar. Also used Analytic-Based selectors in Dashboards.
• Created various graphs like Pie Charts, Vertical Clustered Bar charts and Bar-Line charts for ad-hoc dashboards.
• Developed documentation for the objects and reports that are created.
• Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment.
• Used MicroStrategy Object manager to migrate the objects/projects between Development and production servers.
• Responsible for preparation of Migration documents, Schema documents and also Participated in Migration activities of MSTR objects.
• Worked Document Caches and Intelligent Cube reports to Improve Dashboard Performance.
• Set up schedules for various Reporting Objects, Cache clearing & Intelligent Cube refresh.
• Good Experience working in Agile Environment
• Extensively worked on solving issues related to security privileges and access control lists to different user groups as per the application and license privileges.

Environment: MicroStrategy 9.x, MicroStrategyDesktop, MicroStrategyWeb, MicroStrategy Report Services, MicroStrategyIntelligence Server, MicroStrategyNarrowcast Server, Informatica, Oracle 9i, Oracle SQL developer, Teradata SQL, Windows XP/2000.

Confidential, Bentonville, AR

MicroStrategy Consultant

Responsibilities:

• Worked with business requirements subject matter experts to identify and understand requirements and prepared Low Level Designs and High Level Designs for designing the reports.
• Created logical data models to recognize source tables and columns, to build Micro-Strategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in complete life cycle of multiple BI reporting projects of the group.
• Developing logical models, building hierarchies, attributes and facts, extracting tables from warehouse catalog.
• Involved in troubleshooting MicroStrategy Web Reports, prompts, filter, template, consolidations, and custom group objects, optimizing the SQL using the VLDB properties in an enterprise data warehouse team environment.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Created Dynamic sourcing reports using intelligent cubes to boost the Performance.
• Created Cubes and scheduled them to run weekly bases.
• Extensively worked on migration of objects across the environment using object manager.
• Created Integrity Manager Tests to check reports integrity before and after migration.
• Analyzing and Optimizing SQL queries for complex reports.
• Involved in optimization of code and tuning queries for performance.
• Provided Business user training for the MicroStrategy Desktop/Web.
• Created the Metadata & Statistic tables for the MicroStrategy projects.

Environment: MicroStrategy 9.3.1 & 9.2.1 (Administrator, Architect, Desktop, Web, Mobile, Object Manager, Enterprise Manager), ETL, SQL Server 2008 R2, Windows.

Confidential

MicroStrategy Developer

Responsibilities:

• Served as MicroStrategy developer for the full lifecycle of the data-warehousing project from requirement gathering from business to rollout.
• Installed and configured the complete MicroStrategy Analytics Environment
• Applied OLAP and statistical functions to calculate metrics
• Worked with a team of ETL developers to load data into enterprise data warehouse by researching and documenting source systems as well as destination tables.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Designed interactive reports with extensive use of prompts (object, value) as per user requirements in Graph and Grid form of reports.
• Created Transformations (table based, formula based) for using in comparative reports like sales this year to last year (year to date and month to date).
• Extensively created filters, prompts, consolidations and custom groups to generate canned reports, ad hoc reports, documents and dashboards
• Created Dynamic Dashboards showing Company's yearly performance using various graphs and widgets.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings.
• Used MicroStrategy SDK for various Customizations to change look and feel of MicroStrategy web and Embedding MicroStrategy functionality in external applications.
• Conducted performance testing and implemented various measures to improve Query Performance in the reports by usage of Report Caching and Aggregate Tables and VLDB Properties.
• Worked on SQL to test the scope of view based logic to deliver Metric calculation as per business requirement before physical view is created.
• Extensively worked on promotions and migrations by creating packages through Object Manager and responsible to sync objects across development sand boxes, QA and UAT projects
• Written Pre and Post SQL statements in VLDB properties of reports to improve performance of SQL query by reducing cost of query.

Environment: MicroStrategy 9.x and MicroStrategy Intelligence Server, MSTR Desktop, MSTR WEB, MSTR Mobile, SQL Server, Microsoft Excel, SQL Tools, Windows, Visual Crossing mapping, Teradata.

Confidential

SQL/ MicroStrategy Developer

Responsibilities:

• Responsible for gathering business requirements from the users and analyzing the report specification documents and needs of the business users.
• Analyzed logical data models, understand data warehouse tables and columns, map the columns to the MicroStrategy project by creating schema and public objects.
• Worked extensively on creating MicroStrategy Application Objects such as Simple Metrics, Compound Metrics, Level Metrics, Filters, Custom Group, Consolidation and Prompts.
• Used Filters, Facts, Prompts, Consolidations, Transformations and Custom Groups to generate reports for business analysis.
• Creating and modifying Public Objects to enable reporting on new and changed data elements
• Involved in Performance Tuning of longer running queries by setting appropriate VLDB properties and by applying various design techniques to minimize the number of SQL passes generated by MicroStrategy.
• Worked on MicroStrategy Object Manager to migrate objects from development environment to the test environment.
• Worked on Project Merge and User Merge Wizards..
• Using MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Performed some of the Administrative tasks like User Creation and Roles.
• Writing complex SQL queries in Teradata to meet reporting requirements.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers which were used to implement business rules.
• Create Intelligent Cube and use that in reports to decrease the workload on database.

Environment: MicroStrategy Desktop 8.x/9.x, MicroStrategy Intelligence Server, Architect, MicroStrategy Web, Administration, Report services, My SQL, Toad, and Windows.