SUMMARY:

• Over 7 plus years of experience in Data warehousing, Business Intelligence systems, OLAP environments and tools.
• In - depth knowledge of fundamental data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front and back room architectures, security and deployment.
• Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Handling slowly changing dimensions in a data warehouse depending on the user needs.
• Extensive experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Working closely with the business to gather, review, validate and document the business requirements.
• Team lead experience with Documentation and developing Dashboard reports .
• Worked on SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• A self motivated team player with exceptional communication skills .

TECHNICAL SKILLS:

OLAP/Business Intelligence/Reporting tools: MicroStrategy Desktop 10.6,10.4,9.2.1, 9.0.x, 8.x, 7.5, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, MicroStrategy Object Manager, MicroStrategy Mobile.

Operating systems: Windows 98/NT/2000/XP/Vista/7

Databases: SQL Server 2008/2008R2/2012/2014, Oracle 11/10g/9i/8i/8.0/7.0, MS Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.NET, ASP.NET (C#), Java

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Germantown, MD

Sr. MicroStrategy Developer / Data Analyst

Responsibilities:

• Successfully implemented the POC to show the capabilities of MicroStrategy to the end Client
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Extensively worked on XQuery to get the Data from PerfWarden (Source)
• Responsible for creating the Intelligent Cube’s by using XQuery
• Extensively worked on MSTR BI Suite to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Developed customized reports to depict the usage and performance of reports, User activity and Cache analysis
• Worked on Active QOS, VOIP and Active path documents to show the benefits of having Active Path Service for the customers
• Created Network Level and Site Level Documents to show the performance of Network to the Customers
• Worked on Various VI Dashboards to show the Performance of their Network
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.

Environment: MicroStrategy 10.4/10.6 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, XQuery, Hadoop(Hive).

Confidential, Washington DC

Sr. MicroStrategy Developer

Responsibilities:

• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created different Project Sources for different environments like production, testing and development.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• 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 creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created DataMart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, Information objects.
• Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
• Worked on the excel formatting, macros and templates of the documents which are used in different services.
• Exported data from Teradata using Fast Export utility.
• Experience in using Teradata utilities such as Fast load, Multi load and Fast Export.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 9.0/9.0.1/10.4 Administrator, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Teradata, Narrowcast Server SQL Server 2012/2014, Toad and Windows XP Professional.

Confidential, New York, NY

Sr. MicroStrategy Developer

Responsibilities:

• Involved 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.
• Configured Enterprise Manger and developed customized reports to depict the usage and performance of reports, User activity and Cache analysis.
• Created report services documents for guest count and Sales analysis.
• Developed a web course and took several classes to train the end users to efficiently use MSTR.
• Created several data marts using MSTR for different tools to access large datasets.
• Involved in Upgrade of MicroStrategy environment from 8.1 to 9
• Created Subscription sets, documents, publications and services for delivery of reports through Narrowcast.
• Validated end user requirements using Microstrategy tools.
• Created Question Objects for Personalized execution.
• Extensively involved in Troubleshooting of Narrowcast services delivery.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.

Environment: SQL Server 2008R2/2012 Enterprise Edition, MicroStrategy 9/8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager)

Confidential, New York, NY

MicroStrategy Developer Domain: Financial

Responsibilities:

• Effectively Tuned MicroStrategy implementation for greater performance based on recommendations from internal testing.
• Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.
• Experienced administrative capabilities; Project Setup (Installing, configuring, managing and controlling) and Project Lifecycle Management.
• Perform periodic Health Checks of the Intelligence Server and Narrowcast server installation in all environments to determine the current state of server parameters, performance, as well as identify potential issues and limitations.
• Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.
• Migration planning and implementation with all supported service packs, hot fixes, and patches.
• Configure, Manage clustering of Multiple Intelligence server nodes and web server nodes to implement automatic failover, load balancing and boost the performance and scalability.
• Best practices using standardized methodology for coding, development, test and implementation processes.
• Create and manage MicroStrategy application objects, schema objects and configuration objects.
• Embed hand-crafted SQL statements directly into the MicroStrategy BI platform using The Freeform SQL editor.
• Define/Create system hierarchy/user-defined hierarchy and controlling (lock, limit and filter out) the attribute elements in hierarchy.

Environment: MicroStrategy Suit 9.0.1, IBM DB2/AIX64 9.1.3, Service Centre 5.1, Windows 2000/2003.

Confidential, NJ

Microstrategy Developer

Responsibilities:

• Created advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to the business needs.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Implemented drill functionality on the reports using Drill Maps.
• Created dynamic dashboards to improve marketing by product, customer, geographic and promotion analysis.
• Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop.
• Worked extensively on developing Metrics and Compound Metrics, Complex Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.0. eveloped Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis.
• Created Transformations like YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Involved in the creation of Data mart Reports, Partition Mappings.

Environment: MicroStrategy 8.0 (MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 10g, Windows XP

Confidential,

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Scheduled cube processing from staging database tables using SQL Server Agent.
• Wrote MDX queries and expressions for use in front-end BI applications and created KPI objects in line with requirements.
• Optimized cubes for better query performance and processed cubes to perform incremental updates.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with drill-down, drill-through, and drop-down menu options as well as parameterized and linked reports.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly, and quarterly reports including current status.
• Created report models, standard report subscriptions, and data-driven report subscriptions.
• Created report snapshots and cache for better performance.
• Created user-defined functions in SSRS using VBScript.
• Generated test data and tested database to meet functionality deliverables in project documentation and specifications.
• Provided knowledge transfer to company’s SQL developers.
• Created several materialized views and UDFs to be accessed by new front-end applications.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance database performance.
• Optimized performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs, and system stored procedures.
• Successfully tested all tasks in staging, and stored all versions of data using Team Foundation Server.

Environment: SQL Server 2008R2/2008/2005, Business Intelligence Development Studio (BIDS) 2008, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Analysis Services (SSAS) 2008, Windows Server 2003, HealthCare database, Oracle 9i, DB2, SharePoint Server, Team Foundation Server.