MicroStrategy Architect

Summary

**+ years of experience in Data Analytics, SQL, PL/SQL, ETL tool and Reporting tools

Eexcellent knowledge of the Microstrategy Suite of tools (Desktop, Mobile configuration,Narrowcast, Object Manager, Command Manager, etc), Tableau and Microsoft Power BI

Developed dashboards for web and Mobile by using different BI tools

Involved in the complete lifecycle of the projects

Strong knowledge of sprint/agile practices

Involved in the process analysis, design, development and performance optimization of Business Intelligence Reports

Knowledge of Data modeling and Object Modeling

Strong knowledge in Internet based and mobile based reporting

Strong knowledge in developing operational reporting

Strong analytical skills and attention to detail

Excellent team player

Excellent organizational and time management skills

Excellent oral and written communication skills

Quick learner, drive and motivation to gain new skills.

Having working knowledge in SAS code and SSIS.

Having experience in cloud based environment

Technical skills

OLAP Tools: Microstrategy 11.1/10.4/9.4/9.3/9.2.1/9.0.2/9.0.1/8.0.1./8.0.2/8.1 (Developer,Desktop, Web, Narrowcast, Object Manager, License Manager),SSIS, Tableau, Microsoft Power BI

Operating Systems: Windows 2003/07, Linux

Programming skills: Java, C, C++

Scripting Languages: JavaScript, VB Script, ASP

Databases : Oracle 10g/9i, Sybase IQ 12.6, SQL server 7.0/2008/2005, MS Access 97/00/XP/03,Hadoop

Microsoft Tools: MS excel, MS word, MS Visio, MS PowerPoint

Education

Master of Computer Applications, Nehru Memorial College, India

Certification

Oracle Certified Professional in SQL/PLSQL

Java Certified Developer

Professional Experience

Data Facts Inc., FEP’19-till date

Client: Audible

CARI (Customer Acquisition Retention Interface) is designed to put business intelligence in the hands of Audile’s global business users for better, faster, relevant decision making. Using Microstrategy as the enterprise BI application with four different subject areas that powers CARI, Audible team members are able access dashboards, reports and use CARI for self-service BI to answer questions.

Key Responsibilities:

Involved from requirement gathering, design and development of the Dossier, Dashboards and documents in Microstrategy.

Designed and Created Dossier to provide more visibility of the data.

Created the schema objects such as tables, attributes, facts, hierarchies, transformation, and so on.

Created complex metrics for analyzing the data.

Created templates and wizards for creation of dynamic reports.

Created client specific reports, Dossier for web on the business requirements.

Created Free form SQL report to provide the user required documents.

Suggested to use static and dynamic subscriptions to deliver the reports.

Followed industry standard best practices.

Worked closely with ETL developers in data loading and in designing of the staging and reporting tables.

Implemented performance improvement by changing VLDB settings.

Wells Fargo India Solutions Pvt Ltd,Bangalore

MicroStrategy Architect and Developer Jun’16 – Sep’17

Project: International Risk Oversight Reporting

This project provides visibility to the complete Wells Fargo International Risk data to the Risk Management. This project is designed with multiple dashboards and different data set, to provide the complete visibility of Risk data in Microstrategy BI tool .

Key Responsibilities:

Involved in data analyzing of various Risk data.

Designed and Created dashboards to provide more visibility of the data in Microstrategy.

Created all the schema objects such as tables, attributes, facts, hierarchies, transformation, and so on.

Created complex metrics for analyzing the data.

Created templates and wizards for creation of dynamic reports.

Created client specific reports, dashboards for web and mobile based on the business requirements.

Created to use static and dynamic subscriptions to deliver the reports.

Automated the report delivery to the management Team.

Designed the Schema to create ad-hoc Dashboards by the Users

Created the SSIS Package to Load the data from different excel file to Data base

Converted the SAS code into SQL procedures.

Managing the offshore Team.

Environment: MicroStrategy 9.10, SQL Server 2008,SSIS, SAS®9

PricewaterhouseCoopers software development center, Bangalore

Client: Microsoft Feb’16 – Jun’16

Project: Microsoft website usage analysis (Power BI Visualization tool)

The dashboards of this project provide the information of the website usage and cost of maintenance of the client.

Key Responsibilities:

Analyzed the data built BI dashboards in Power BI for website usage analysis and maintenance cost projection for those websites.

Worked closely with offshore team member for requirement gathering and presented the dashboards to client with off shore team member.

Environment: Power BI, SQL Server 2008

Client: Fanatics Apr’15- Feb’16

MicroStrategy Architect and Developer

Project: Fanatics Sales analysis

The client is a leading online retailer of officially licensed sports merchandise and provides the ultimate shopping experience to sports fans. The aim of the project was to analyze the client Data and requirement and create Reports, Cubes and Dash boards in MicroStrategy as per the requirement for a Client to analyze the business in easiest and best way.

Key Responsibilities:

Installed MicroStrategy Intelligent server and Web server on different windows 2008 servers.

Configured I server, web server and Project with Big data Hadoop using 32 bit Hive ODBC Connect (Cloundera) and Hive 0.11 database component.

Created configuration objects like DB Instance, users and Groups.

Involved in requirement gathering, Analyzed and understand the Client data and requirement to create report and dashboard.

Developed Schema objects like Attributes, Facts, Transformation and tables. Public Objects like Metrics, Filters, prompts, reports and dashboards.

Created OLAP Services like View filters, derived elements, derived metrics, Intelligent Cubes and published I cubes using Incremental fetch functionality for specific periods.

Created Visual Insight Dashboards in web using I cubes and I cube reports as a dataset and also Import Data functionality

Environment: MicroStrategy 9.4.1/9.4, SQL Server 2008, Oracle, Big data Hadoop

Client: Portfolio Solutions SA Jan’15 – Mar’15

Data analyst

The client is one of the biggest financial services provider and provide services to some of the most respected organizations in their industries, including one of the nation’s largest sub-prime servicers, government agencies and many lenders, servicers, investors, mortgage bankers, credit unions, financial services companies and hedge funds across the country.

Key Responsibilities:

Involved in analyzing various financial systems and sub system’s financial letters and performed reconciliation process.

Worked on tracing the Bookmarks, Conditions and Letter Logic’s from various source letters.

Performed thorough quality check to make sure the all deliverables are as per client standards and on time.

Consolidation of completed and reconciled letters and uploaded them on to SharePoint.

Interacted with onsite engagement team on daily basis

Environment: MS Excel, SQL Server 2008,

Client: PWC Mar’14 – Dec’14

Tech Lead

The aim of this project is to aggregate PWC's existing data, add new data and provide services to expand the data use and add business value. The Data Services Strategy and Roadmap project focuses on the Data Services component of the Analytics Transformation initiative, as a foundational phase designed to define core Data Services capabilities, capture business vertical requirements, establish a set of foundational Data Services use cases across practice areas, and create a centrally accessible, searchable data catalog of PwC’s data assets that are currently available (proprietary, externally procured, public, and other).

Key Responsibilities:

Interacted with the Business team in gathering the requirements

Designed and developed the dashboards that analyze Capital Markets and Company Performance insights

Developed the interactive Visualizations for greater exploration of data using Tableau

Assisted the client with adhoc analysis requests

Performance tuning of the dashboards

Environment: Tableau, SQL Server 2008

Client: Iridium

MicroStrategy Architect and Developer

Sales and Marketing Data Warehouse Jul’12 – Mar’14

The client is a Telecommunications company provides worldwide voice and data communication from hand-held satellite phones and other transceiver units. Their network is unique in that it covers the whole Earth, including poles, oceans and airways. The project involves loading the data into Data warehouse from different sources from oracle database. The data is loaded into different dimension tables, fact tables and into aggregates which is then used for reporting purpose.

Key Responsibilities:

Participated as a key player in the complete life cycle of the project.

Involved from requirement gathering, design and development of the project.

Configured mobile server to deliver the dashboard on I-phone.

Created dashboards to provide more visibility of the data.

Created all the schema objects such as tables, attributes, facts, hierarchies, transformation, and so on.

Created complex metrics for analyzing the data.

Created templates and wizards for creation of dynamic reports.

Created client specific reports, dashboards for web and mobile based on the business requirements.

Suggested to use static and dynamic subscriptions to deliver the reports.

Followed industry standard best practices.

Analyzed the data level security of the clients, and created security filters and user level security settings in MicroStrategy

Led the team to develop this project

Worked closely with Informatica developers in data loading and in designing of the staging and reporting tables.

Implemented performance improvement by changing VLDB settings and suggesting database design changes.

Environment: MicroStrategy 9.4.1/9.4, SQL Server 2008, Informatica

IBM India Private Limited

Client : Intel

MicroStrategy Designer and Developer

iCOST Jan’12 - Jul’12

Intel’s Component Inventory Cost System (iCOST) is the cost calculation engine and manages the cost associated with over 80% of Intel’s inventory. The project involved external financial reporting to stakeholders and Sales Process Analysis.

Key Responsibilities:

Guided the team and also created reports to provide more visibility of the data

Created the schema objects such as attributes, facts, transformation, and so on.

Created complex metrics for analyzing the data.

Created templates for dynamic report creation.

Created client specific reports based on the business requirements.

Environment: MicroStrategy 9.1, SQL Server 2008

Cognizant Global Services, Bangalore, India

Client: Core Logic, US

MicroStrategy - Senior Software Engineer - BI

Real estate analytical suite Oct’ 10 – Jan 12

This project provides visibility to the complete real estate data that will help the originator, broker, servicer and investor to assess the risk of the real estate market. This project is designed with multiple dashboards to cater various target audience.

Key Responsibilities:

Key player and participated in the complete life cycle of the project.

Involved in the conceptualization, design and development of the project

Created the dashboards to provide more visibility of the data

Created all the schema objects like tables, attributes, facts, hierarchies, transformation, etc

Created complex metrics for analyzing the data

Created templates and wizards for dynamic report creation

Created client specific reports based on the business requirements

Created Narrowcast services - Email and File subscriptions for multiple clients

Used both static and dynamic subscriptions for clients

Followed industry standard best practices

Analyzed the data level security of the clients and, created security filters and user level security settings in the MicroStrategy

Lead the MicroStrategy version upgrade from 8.1.0 to 9.0.2

Worked closely with the ETL developers in the data loading and designing of the staging and the reporting tables

Worked closely with the QA in developing the test cases and providing feedback for the QTP automation of the testing

Implemented performance improvement by changing VLDB settings and suggesting database design changes.

Some key functional areas included market trends, value trends and forecasts, listing trends and commercial trends. Some of the dashboards that I worked are highlighted below

HPI Dashboard Analysis - The HPI dashboard provides visibility of the change value of home price indices across a tier and geographical hierarchy. It uses tabs, widgets and graphs to show the change values for all regions providing an interactive experience to the customer.

Market Trend Dashboard analysis - This dashboard highlights the key performance indicators to identify the market trends across all geographic levels. The dashboard uses map widgets to plot the trends data in the geo spatial maps.

Environment: MicroStrategy 8.2/9.0, SQL Server 2008, Sybase IQ

Other responsibilities:

HPI Valuation Engine - This is a Windows based application developed using Visual Basic. This tool is used to evaluate the property price by taking the inputs on purchase price, purchase date and zip code.

Inspection of the data files provided by the Source Team.

Bug fixes and enhancement of the project

Support and assist QA team in Test cases.

TrueStandings Securities Dec’ 07 - Oct’ 10

TS Securities extends the insight, intelligence and experience of securities portfolio issuers, investors, analysts, traders, and insurers. It enables users to sort through large volume of data (in terabytes) and extract clear, objective reports through efficient MicroStrategy Enterprise Reporting suite. The users are given flexibility to access loan level details of data by time period or rolled up data at the securities level in a simple, easy-to-use web-based application.

Key Responsibilities:

Study and analyze the requirements and documentation

Working on project planning, estimation and reviewing test cases for functional test phase for QA team

Created the MicroStrategy schema objects and validated the table relations to ensure that business gets proper data in reports

Design and develop various reports and documents on MSTR, including ad-hoc reports

Unit testing and data validation

MSTR Narrowcast setup for the project

Enhancement, maintenance and support of the product

Coordinating with the ETL team during requirements gathering and data validation

Performed data updates monthly and ensured data availability to the users on time.

Setup the security credentials at the object level and implemented security credentials using connection mapping.

Responsible for object migration between the different environments and creation of the mapping document for the migration.

Analysis and Troubleshooting of the SQL generated by MicroStrategy

Interacting with the SDK team for web customization requirements

Responsible for all the administration activities like configuration of the Enterprise Manager, metadata, performance monitoring of the I-Servers and the web servers, etc

Monitoring and ensuring project progress and preparation of user documents, release-notes, status reports, issue logs and escalating it to different groups.

Ensuring quality norms by implementing checklists, reviews, standard templates and using best practices.

Key player in the MicroStrategy version upgrade from 8.0.2 to 8.1.0

Environment: MicroStrategy 8.0/8.1, SQL Server 2008, Sybase IQ

TrueStandings Servicing & Scorecard: Feb’ 06 – Nov’ 07

Servicing provides mortgage portfolio risk-management productivity for credit risk managers, servicers, mortgage researchers, and insurers. It enables the users to evaluate portfolios, benchmark against the market, and analyze risk through the data on over $1.3 trillion in mortgages, including prime data from nine of the top ten national servicers and subprime data from the only national subprime databank. This project gives the flexibility to the users to roll-rate estimate on their portfolio from actual and easy to use web based application. Scorecard presents the information of the servicer performance that can influence portfolio value.

Key Responsibilities:

Created complex metrics for analyzing the prime and the subprime data

Created templates and wizards for dynamic report creation.

Created standard reports with multiple prompts

Created client specific reports based on the business requirements

Analyzed the data level security of the clients and created security filters and user level security settings in the MicroStrategy

Worked closely with the QA in developing the test cases and providing feedback for the QTP automation of the testing

Created metrics, filters and prompts

Worked closely with the team lead to maintain the progress of the development

Environment: MicroStrategy 8.0/8.1, SQL Server 2008, Sybase IQ 12.6

Contact this candidate