SUMMARY:

• 14 years of experience in Data Warehousing and Business Intelligence systems.
• Expert MicroStrategy Architect (Creating a Project and building Schema Objects) and MicroStrategy Developer (Building application objects, developing Reports Documents, Dashboards and Visual Insight)
• Expert MicroStrategy Dashboard Developer building multi layout dynamic dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph
• MicroStrategy Administrator Experience in Creating User Groups, Security Roles and usage statistics using Enterprise Manager
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Distributed Services.
• Participated in designing of Multidimensional Modeling regulating Star and Snowflake Schemas, Physical and Logical data modeling.
• Expert in Database development skills using SQL, PL/SQL, stored procedures and stored functions
• Experience in data warehouses hosted in Oracle 10g, Netezza, Teradata, SQL Server 2005
• Proven ability to anticipate customer needs and ensure that those needs are delivered
• Highly skilled in client interaction and gathering data requirements, understanding Business Dataflow and Data relations

TECHNICAL SKILLS:

BI Tools: MicroStrategy 10.x/9.x/8.x (Administrator, Architect and Desktop)

Language: SQL, PL/SQL, Unix Shell Scripting, Visual Basic

Databases: Oracle 10g, Netezza, Teradata, SQL Server

DB Client: TOAD 9.0, Netezza Performance Server 4.0.2, Teradata SQL Assist

Data Modelling Tools: ERWIN, MS Visio, Toad

OS/Environments: Windows (10, NT, 2000, XP), UNIX (AIX), LINUX

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

MicroStrategy Consultant

• Interacted with Business users to determine new report requirements and analyzed end user needs
• Built both Schema Objects (Attributes, Facts and Hierarchies) and Public Objects (Metrics, Filters, Prompts, Cubes, Reports and Documents)
• Developed several Documents and Dashboards for Store Operations and Finance Analytics.
• Built iPad specific Associate Sales and Productivity dashboards for near real time usage.
• Set up burst distribution schedules for distribution of the Store Operation reports for every store.
• Wrote SQL queries to determine data quality and data gap analysis when loading POS data.
• Created multiple packages for migration to higher environment.
• Led many training sessions to seamlessly transfer the users into using the new system.

Environment: MicroStrategy Desktop 10.4, MicroStrategy Intelligence Server 10.4, SAP Hana DB

Confidential, Richmond, Virginia

MicroStrategy Consultant

• Worked on transforming Legacy reports into MicroStrategy reports, gathering requirements and building new reports and dashboards .
• Created both Schema Objects (Attributes, Facts and Hierarchies) and Public Objects (Metrics, Filters, Prompts, Cubes, Reports and Dashboards) for the new project
• Designed and developed performance dashboards to improve Machine Utilization, Material Management, Procurement, Equipment acquisition and Financial reports
• Identified data issues and worked with the various teams to fix them in the source systems.
• Worked on gathering and analyzing business requirements for agile BI solutions
• Set up Intelligent Cubes execution and email delivery of Scorecard type dashboards for department heads using both time and event triggers
• Provided configuration and maintenance support for users and accounts
• Trained users on the data available, the reports, documents and self - service Visual Insight dashboards.

Environment: MicroStrategy Desktop 10.4, MicroStrategy Intelligence Server 10.4, SQL Server.

Confidential, Columbus, Ohio

MicroStrategy Architect

• Interacted with users to determine requirements and analyzed end user needs
• Worked with DWH team to design data models using Multidimension, Star and Snowflake Schema.
• Built both Schema Objects (Attributes, Facts and Hierarchies) and Public Objects (Metrics, Filters, Prompts, Cubes, Reports and Dashboards)
• Created multi layout Dashboards with panel stacks, panels, selectors and grids using multiple datasets
• Built mobile dashboards for iPhone and iPad for executive usage
• Built several visual insights dashboards using network graphs for interactive analysis of the attachment rate and frequency of items sold
• Implemented security filters and connection mapping to maintain security among users
• Implemented dynamic sourcing for the reports and incremental daily refresh in cubes for increased report performance
• Extensively worked with VLDB settings for performance tuning of reports and cube optimization
• Used Distribution services for daily cube subscriptions and Report Email subscriptions

Environment: MicroStrategy Desktop 10.3, MicroStrategy Intelligence Server 10.3, Teradata.

Confidential, Phoenix, AZ

Sr MicroStrategy Architect/ Data Architect

• Analyzed existing international loyalty coalition data and determined reporting needs for product launch in the US market
• Extensively involved in data modeling with DWH team to create Star and Snowflake Schema
• Wrote complex SQLs to determine data quality and data gap analysis
• Created both Schema objects (Attributes, Facts, Hierarchies, etc.) and Public objects (Metrics, Compound Metrics, Filters, Custom Groups, Consolidations, Prompt Filters and Reports) and Configuration Objects (Project, DB Instance, Users, User Groups, Security Role)
• Developed 100+ Intelligent Cubes based on user specifications to increase report performance
• Created several multi layout Dashboards using panel stacks, panels, selectors and grids
• Implemented mobile version of scorecards and dashboards for Executive Level Reporting
• Developed several visual insight dashboards and trained analysts to use them during offer campaigns
• Created custom reports using Freeform SQL reports and used the datasets in multiple Dashboards
• Extensively worked with VLDB settings for performance tuning of reports and cube optimization
• Used Distribution services for daily cube subscriptions and Report Email subscriptions
• Designed and modified existing architecture to implement security filter and roles for each partner based on user login to enable self-service reports
• Extensively used Integrity Manger to test reports and cubes after redesign of security model
• Worked on MicroStrategy Administration creating new users, security roles, privileges and ACL’s
• Used Administrator tools Project Merge and Object Manager to move objects across environments
• Developed and maintained online Data Dictionary Dashboard to track KPI definitions
• Used Enterprise Manager for user login tracking, report usage trends and cube analysis
• Extensively performed end to end regression testing during the upgrade of MicroStrategy project from MicroStrategy 9.4.1 to 10.4.1

Environment: MicroStrategy Desktop 9.3, 9.4.1, 10.4, MicroStrategy Intelligence Server 9.3, 9.4.1, 10.4, Oracle 11g.

Confidential, Plano, TX

Sr MicroStrategy Architect

• Created Attributes, Facts, Hierarchies and Relationship between various Attributes to develop perfect logical models for a reporting environment
• Created application objects such as Metrics, Compound Metrics, Filters, Custom Groups, Consolidations, Templates, Auto Prompt Filters and OLAP Reports
• Extensively built MicroStrategy Dynamic Dashboards in the Flash Mode using several controls like fish eye, slider, etc. and widgets like Gauge, heat map
• Built several Intelligent Cubes to improve report and dashboard performance
• Created dashboards with multiple datasets for users to slice the data at the spend analysis across various categories and facility level
• Configured MicroStrategy Distribution Services to enable delivery of reports to email address
• Developed different kinds of Pass-Through Functions for use in time filters and metrics
• Modified several VLDB settings at the report and metric level to customize MicroStrategy SQL generation to improve report performance and execution time
• Collaborated with business partners to define requirements and reporting specifications and provide technical report assistance
• Worked with the ETL team and business operational teams to understand data sources and implement new requirements
• Excellent at writing complex SQLs to perform data validation in Reports

Environment: MicroStrategy 9.3 (Architect, Desktop, Administration, Narrowcast Services) MS Office 2013, Teradata SQL Assistant 12.0, Teradata 13.10

Confidential, Charlotte, NC

MicroStrategy Architect

• Created Schema Objects (Attributes, Facts, Hierarchies) and Public Objects (Metrics, Compound Metrics, Filters, Custom Groups, Consolidations, Templates, Prompt Filters and OLAP Reports)
• Worked with ETL and DBA’s to finalize table structures for MicroStrategy reports
• Created Transformations (table based, expression based) for use in comparative reports
• Developed several Documents and Scorecards for product trend analysis
• Worked in onsite-offshore model and led a 4 for application support and enhancement
• Involved in troubleshooting and resolving MicroStrategy production issues
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy
• Created schedules for caching the regular monthly reports and monitored the same to completion
• Created users, user groups, security filters and assigned privileges to those groups
• Maintained folder level access and setup ACL for the folders in the project
• Involved in testing the project when the backend was changed from Oracle10g to Netezza 4.0 and made necessary schema and public object changes
• Extensively used Integrity Manager to test report SQL and data during MicroStrategy upgrade
• Used Object Manager to migrate objects across environments
• Used Enterprise Manager to build reports for report usage trends

Environment: MicroStrategy Desktop 9.0, 8.1.2, MicroStrategy Intelligence Server 9.0, 8.1.2, MicroStrategy Administration 9.0, 8.1.2, MS Office 2003, Oracle 10g, Netezza 4.0.

Confidential, Charlotte, NC

PL/SQL Developer

• Designed table structures, developed scripts to create tables, views and indexes using TOAD
• Created PL/SQL Packages which contain procedures, functions,, exceptions to load daily, data into the database tables incorporating business rules and constraints
• Created numerous simple to complex queries involving self-join, correlated subqueries, functions, and dynamic sql
• Optimized PL/SQL Blocks and SQL statements by analyzing the execution plan to improve application performance
• Integrated the mailing system to alert various groups on the status of data processing
• Experienced in using AutoSys tool to set up scheduled jobs within a Windows environment that run Oracle PL/SQL

Environment: Toad 7.2, Oracle 9i- SQL & PL/SQL, Sun Solaris / Windows XP

Confidential

PL/SQL Developer/Team Lead

• Involved in product maintenance, analyzed bugs and developed patches to resolve production issues
• Implemented functional rollouts of several modules and trained the users in the same
• Designed a knowledge portal about the various applications in Wholesale Banking
• Led a team of 3 Interns who were involved in the enhancement of the portal
• Involved in Testing and Change Management during the Release of every project
• Business Continuity Co-coordinator and in charge of the Disaster Recovery Drills for the application

Environment: Oracle 9i, VB 6.0, Java, JSP, Oracle Reports: PHP, HTML, CSS, Oracle 9i, Apache