Microstrategy Professional

Krishnapriya Kadati

***********@*****.***

Mobile: 571-***-****

Objective

I am currently seeking a position as Business Intelligence professional in which I can utilize my knowledge and experience to provide business insight.

Professional Summary

Over 10 years of experience in Microstrategy in Analysis, Design and Implementation of BI applications using Microstrategy 10x/9x/8x.

Worked closely with the business to Gather, Review, Validate and Document the Business Requirements.

Close experience in Business Systems and Business Requirements Analysis & Documentation especially in the Financial Industry and Telecommunications Industry.

Multi-role playing high-energy leader and a can do anything hands-on team player.

Mentored and lead peak performing on-shore/offshore global teams.

Good experience in Microstrategy, Microstrategy Distribution services, OLAP Cubes and Microstrategy mobile.

Expertise in Installing, Configuring of all Microstrategy activities including Microstrategy Desktop, Administrator, Intelligence Server, Web and Mobile.

Worked extensively on Oracle, IBM DB2 and Netezza Database Environments.

Implemented Microstrategy objects such as attributes, facts, hierarchies and complex metrics that conform to the dimensional and de-normalized data models.

Experience in Data Modeling and BI implementation with Database tuning.

Intensive experience and exposure to all aspects of Microstrategy application such as Administration, Architecting and Development.

Strong understanding of Data warehouse concepts, dimensional modeling using various Schemas and Multi-Dimensional Model with respect to query and analysis requirements.

Quick learner, ability to work in groups or alone, ability to work on tight schedules.

Team player with good interpersonal and communication skills and the ability to work in a team environment.

Core Competencies

Strategic Business & Organizational Planning

Project Design, Execution & Management

Business Process Analysis & Automation

Business Intelligence Roadmap & Strategy

Data Acquisition, Integration & Analysis

Data Modeling & Predictive Analytics

OLAP & OLTP Database Management

ETL, Dashboard & Reporting Frameworks

Systems Development Life Cycle Management

Team Development, Training & Leadership

Certifications

MicroStrategy Certified Engineer (MCE)

Educational Background

Master of Science in Computer Engineering Dec 2006

George Mason University, Fairfax, VA.

Bachelor of Engineering in Electronics & Communications

University of Madras, India. May 2004

Skill Set

Business Intelligence

MicroStrategy Desktop 10.x/9.x/8.x (Architect, Web, Intelligence Server,

Narrowcast Server/Distribution Services, Mobile, Object Manager, Command

Manager, Integrity Manager, Health Center, Visual Insight, Transactional

Services, Cloud, Express), Tableau, Cognos

ETL Tools

Informatica 8.x, 7,x and 6.0 (Power Center, Power Mart)

Databases

Oracle, Microsoft SQL Server, Netezza, MS Access, DB2 UDB and MySQL

Languages

SQL, PL/SQL, C, C++, Java, HTML, DHTML, XML, PHP

Operating Systems

Windows 10, Windows 8, Windows 7, Linux and AIX

Tools

Microsoft Office, Microsoft Office Visio, MATLAB, Toad, JIRA and SQL

Developer

Web Technologies

HTML, Macromedia Flash, Dream Weaver, Adobe Photoshop CS2

Technologies

IEEE 802.11, TCP/IP, UDP, OSI

Work Experience

Lead Data Architect June 2014 – Present

M3BI LLC., supporting American Express

Phoenix, AZ.

American Express partnered with a select set of companies in USA and launched a loyalty coalition and came out with a Rewards Card to drive closed loop marketing for partners to grow their revenues as well as to reward the customers for their spending behavior by sponsors and manufacturers.

Lead Reporting Architect for ‘Plenti’ product reporting using Microstrategy for USA.

Lead Reporting Architect for ‘Revenue Management and Billing’ project for Internal Users for Fee, Point, Financial settlement and clearing.

Managed multiple reporting projects for Business, Operations, Finance and Support departments.

Meet with business users for requirements gathering.

Communicated and managed a team of offshore resources in Germany/India on a day-to-day basis using Agile and Waterfall methodologies.

Manage resources efficiently to ensure successful delivery of BI projects on time.

Manage complete life cycle of Microstrategy from development to deployment along with technology and business partners.

Collaborated with the database administrators to identify and map database objects and fields to Microstrategy.

Participated in data modeling design sessions to create data models used as the basis for the reports and intelligent cubes.

Created logical schema model to support report and dashboards.

Created logical view tables, custom groups, consolidations, transformations and objects using pass through functions.

Created Schema and Application objects (facts, metrics, attributes, hierarchies, reports, filters, prompts and templates) using Desktop and Architect.

Developed Intelligent Cubes based on the technical and business specifications of the customer to increase performance.

Embed handcrafted SQL statements directly into the Microstrategy BI platform using The Freeform SQL editor.

Implemented project testing using Microstrategy Integrity Manger.

Microstrategy Lead BI Professional Sept 2009 – Mar 2013

Angel.com Inc., subsidiary of MicroStrategy

McLean, VA.

Genesys Telecommunications Mar 2013 – June 2014

Chantilly, VA.

(Angel.com was acquired by Genesys)

Angel.com combines business voice technologies including IVR, speech recognition, click-to-call via a cloud platform. I was involved in the Report/Dashboard Development, Administration and Design of Angel’s Analytics Suite.

Microstrategy Architect/Developer

Served as primary Microstrategy professional for the full lifecycle of the project from requirement gathering to rollout.

Provide mentorship to the peers in the areas of performance and tuning and best practices for all projects across all environments.

Run Integrity Manager to Compare/Analyze discrepancies at the Data, SQL and Graph levels before Project migrations and software upgrades.

Created logical schema model to support data marts, report and dashboards.

Created logical view tables, custom groups, consolidations, transformations and objects using 'apply simple'.

Created table-based transformations for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.

Collaborated with the database administrators and ETL developers to identify and map database objects and fields to Microstrategy.

Participated in data modeling design sessions to create data models used as the basis for the reports and intelligent cubes.

Communicated, managed and mentored a team of offshore resources on a day-to-day basis to ensure delivery.

Created Schema and Application objects (facts, metrics, attributes, hierarchies, reports, filters, prompts and templates) using Desktop and Architect.

Developed dashboards, reports on Desktop, web and mobile devices (iPad and iPhone) using templates and widgets.

Developed multi-layout visual sight analysis on Microstrategy web.

Developed Intelligent Cubes based on the technical and business specifications of the customer to increase performance.

Implemented Single Sign On to allow seamless login to Microstrategy Web Application.

Developed custom reports to show usage and performance in Enterprise Manager.

Developed Transaction Services reports on web and mobile.

Created Time-Triggered and Event-Triggered subscriptions (automated using command manager to trigger at the end of ETL).

Microstrategy Administration

Performed product upgrades from 8.x to 9.x

Configured Enterprise Manager and provided access to web and Desktop users.

Configured Health Center and used information for troubleshooting issues.

Used Object Manager and Project Merge to deploy across Development, Test and Production environments.

Used Integrity Manager to test reports and dashboards after schema changes.

User provisioning; create users, groups, security roles and security filters to comply with customer security requirements.

Used application diagnostic traces to troubleshoot problems.

Performed administration tasks; tuning, caching, setting governing parameters and report optimization.

Customized the Intelligence Server and project settings in Web and Desktop.

Configured Narrowcast Server/Distribution Services for delivering reports and dashboards.

Business Intelligence and Tech Support Lead Sept 2008 – Aug 2009

Angel.com Inc., subsidiary of MicroStrategy

McLean, VA.

Developer

Involved in the development/testing of mobile applications and a custom web site, which helped the consultants and customers to build IVRs over the web.

Mainly involved in report development based on the needs of the management and customers of angel.

Developed mockups of reports for approvals from business before the actual development commenced.

Analyzed the back end database systems to understand the required mapping of the data elements based on reporting needs.

Involved in documenting mapping of data elements, data flow, relationships and dependencies across physical tables as well as logical objects.

Involved in incorporating MSTR web into the angel site builder tool to enable single sign on access for angel’s customers to access reports, dashboards and subscribe them.

Performed functional, regression and UAT testing to make sure the reports are inline with requirements.

Suggested new reports based on user feedback that helped the upper management look at the data from other angles.

Tech Support Lead

Apply proficiency with Angel.com Site Builder toolkit to walk customers through how to build applications or Voice Sites that provide an end-to-end call center automation solution.

Train programmers how to Integrate Angel.com Voice Sites with client backend Web Service infrastructure to create dynamic, personalized interaction with callers over the phone, writing code as needed (ColdFusion, PHP, Java).

Demonstrate Angel.com Site Builder to new prospects, focused on the technical integration of an Angel Voice Site with client Web Services.

Run the Kick-Off Meeting for new clients, identifying project goals, project team roles and responsibilities, project milestones, and success criteria.

Manage several client engagements simultaneously while exceeding client expectations for each project.

Resolve technical issues for Angel.com customers via phone, email, WebEx, and online case management (salesforce.com)

BI Production Support Developer Jan 2007 – Sept 2008

TRX Inc., Vienna, VA.

Created facts, metrics, attributes, filters, and prompts for development of MicroStrategy project.

Created project plans for the development of MicroStrategy projects.

Defined and created reports in MicroStrategy 8.x for claims analysis and warehouse loading process.

Performed report and object promotion using the Microstrategy Desktop. Troubleshoot and provided fixes for reports.

Working with DBAs and Micro Strategy help desk to implement performance tuning and report optimization.

Managed MicroStrategy 8.x Intelligent and Web servers for Development, Test and Production environments.

Provide 24/7 support for a 10,000 user MicroStrategy 8.x/DB2 8.x/AIX Commercial Credit Card data warehouse.

Provide 24/7 support for a Java-Perl ETL application, which feeds a multi Tera byte data warehouse.

Build and deployed multiple backend applications in a mixed (Java, Perl, Websphere, MicroStrategy and DB2) production environment.

Conduct six-week training program for new employee starting in the Production Support.

Administration of Micro Strategy business intelligence environment.

References available upon request.

Contact this candidate