Manager Developer

KALYAN

Sr. Microstrategy Consultant

****************@*****.*** 214-***-****

Summary:

8+ years of Professional experience which includes Design, Development and implementation of MicroStrategy applications with proficiency in creating Attribute, Facts, Template, Filter, Prompts, Metric, Reports, Documents and Dashboards using MicroStrategy 10.4/10/9.4.1/9.3/9.2.1 and other lower versions.

Full life cycle implementation of MicroStrategy applications, which includes Business requirements definition, Create Schema Objects and Public Objects, Move them from Dev to QA and from QA to Production environment.

Extensive knowledge on SQL/PLSQL.

Strong ability to analyze and debug SQL and recognize Micro Strategy query improvements.

Good Exposure, Some Hands-on Experience working with URL APIs and Good Knowledge on SDK.

Worked on SDK modules like Web SDK, Mobile SDK, Narrow Cast Server SDK, Intelligence Server SDK etc.

Ability in handling MicroStrategy administrator tasks: object migration, User creation, ACL and Security Filters.

Expertise in Defining MicroStrategy Narrow Cast Server objects like Service, Schedule, Subscription set and Information Objects.

Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations).

Expertise in Developing Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports.

Expertise in creating MicroStrategy documents, Grid reports, dashboards for various business environments.

Experienced in building solutions to enable self-service BI by architecting Adhoc Microstrategy schema.

Experience in Performance Optimization of MSTR Reports, using Intelligent Cubes for better performance and to reduce the load on Database.

Experience in SQL coding, ability to understand and write complex SQL using Stored Procedures, Joins, Views, Triggers and Indexing strategies.

Supported various testing phases Unit testing, Performance Testing and UAT.

Experience on VLDB Properties for performance tuning.

Expertise in the concepts of Data Warehousing, Data marts, ER Modeling, Dimensional Modeling, Facts and Dimensional Tables.

Involved in training Business users on MicroStrategy Reporting, providing necessary documents and Support.

Good understanding of ETL technologies like DataStage and Informatica.

Good knowledge of MicroStrategy Web and Web Administration.

Expertise in creating interactive Dashboard, Scorecards and Documents based on user requirements.

Worked on customizing and optimizing the query performance of report using VLDB properties.

Good knowledge in Star schema and Snowflake Schema.

Involved in the complete software development life cycle (SDLC).

Experience in creating time series transformations like YTD, MTD, LY etc. using Transformations.

Well-Organized, Energetic, Quick learner, Team Player. Ability to adjust to new and challenging situations.

Excellent analytical, programming, written, verbal, communication and interpersonal skills and Leadership Qualities.

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

Extensively involved in Optimization of Data Migration, ETL Processes.

Access provided to users by connecting LDAP directory (SSL and Clear Text) to I-Server.

Created drill maps for end users to drill down and recover data.

Technical Skills:

BI TOOLS

MicroStrategy Desktop 10.4/10/9.4.1/9.3/9.2.1/8.X, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy Narrow Cast Server, Distribution Services, Integrity Manager, Enterprise Manager, Project Source Manager, Connectivity Wizard, Object Manager.

ETL TOOLS

Data Stage, SSIS, Informatica.

DATA MODELING TOOLS

Erwin, Toad

DATABASES

SQL Server2005/2008, Teradata

PROGRAMMING LANGUAGES

HTML, XML

OPERATING SYSTEMS

Window Server XP/2000/2008/2010

Query Tools

SQL server management studio, SQL Developer

Professional Experience:

Client: Cisco Systems, SanJose, CA

Duration: Jan 2016 to Till Date

Role: Sr. Microstrategy Developer

Cisco Systems, Inc. (known as Cisco) is an American multinational technology conglomerate headquartered in San José, California, in the center of Silicon Valley, that develops, manufactures, and sells networking hardware, telecommunications equipment, and other high-technology services and products.

Responsibilities:

Architected schema objects such as attributes, facts and transformations.

Designed and Developed Reports and Templates (Standard and Ad Hoc) using complex Filters, compound Metrics and Prompts.

Created reports with various object prompts to generate various Ad hoc reports.

Gathered business requirements for Disney business banking risk reporting.

Worked closely with Enterprise Architecture team to understand database models and architecture.

Exposure in dealing with variety of Relational Databases like Oracle, SQL Server.

Involved in creation of schema objects (facts, attributes, hierarchies, transformations) and application objects (filters, prompts, metrics, custom groups, consolidations, reports).

Used pass-through functions (apply simple and apply comp) in attributes and filters definitions.

Used several widgets for Dashboard reporting.

Involved in Creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics.

Created new and updated old customizations in Web using SDK.

Provided support to consultants, Technical Support engineers in creating and troubleshooting Microstrategy SDK customizations.

Worked on upgrading the Microstrategy project created in Microstrategy version 9.4.1 to Version 10.4.

Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.

Used the Object Manager to migrate the objects from Development to UAT/Production environment in MicroStrategy.

Used Information windows extensively on iPad based dashboards for better interactivity and navigation.

Used MicroStrategy Distribution Manager for automation of reports that saved many man hours every day and helped departments focus on data analysis instead of data generation. This helped in accuracy and integrity of data presentation.

Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like Apply Simple, Apply Comparison to overcome complex logic in creating objects.

Enhanced existing dashboards and scorecards using KPIs and enabling drill functionality.

Created and deployed Mobile/IPad Dashboards.

Used free form SQL editor for complex report creation.

Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.

Environment: MicroStrategy 10.4, 10, Web, SDK, Teradata, Oracle 11g, SQL, PL/SQL, T-SQL, MS Office 2010, Windows 7 Professional, iOS.

Client: American Heart Association

Duration: Oct 2014 to Dec 2015

Role: Microstrategy Architect / Developer

The American Heart Association (AHA) is a non-profit organization in the United States that fosters appropriate cardiac care in an effort to reduce disability and deaths caused by cardiovascular disease and stroke.

Responsibilities:

Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.

Extensively used Pass-through (Apply Functions) expressions to pass special functions.

Used the Microsoft windows performance monitors to supplement Administration monitors in MicroStrategy intelligence server.

Understood and created a project in a 4-tier via MicroStrategy web.

Involved in implementing the Full Life Cycle of the project starting with gathering requirements from the business users and documenting the specifications to delivering the end reporting solutions.

Performed data analysis, data mapping, gap analysis, data integration from multiple sources, created data dictionary.

Designed and Developed Reports and Templates (Standard and Ad Hoc) using Complex Filters, Prompts and Compound Metrics.

Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents Using high volume datasets. Using I-cubes improved performance of the RS documents significantly.

Utilized Eclipse to test the function of Microstrategy Web based on Web SDK.

Worked Closely with SDK Developer in Finding Issue on CSS files and Suggested Code Modification required.

Obtained report and report-runs from Microstrategy SDK History List by using Web SDK, and displayed them on user web page, implemented relevant functionality.

Added instrumentation to the Creative Toolset, an API that controls several ad formats.

Currently instrumenting the IMA SDK, which controls ad playback of most Google video ad

formats.

Widely used VLDB properties to set default criteria at project level and also at individual report levels to overcome performance issues.

Performed migration of objects from DEV Environment to QA and then to Production using Microstrategy Object Manager.

Customize the interface of Microstrategy Web with Microstrategy SDK by creating new plugins. Utilize pageConfig.xml and styleCatalog.xml files. Build image carousel using JavaScript and jQuery to enable users to preview the dashboards or reports while hovering over icons of dashboards or reports before running them.

Also, tuned ODBC driver to improve data transfer rates between database and MicroStrategy servers located at different physical locations.

Also, worked as ETL support contact supporting Informatica mappings to load data into data warehouse.

Depending on the requirement, used database specific MicroStrategy OLAP pass through functions like ApplySimple and Apply Comparison to overcome complex logic in creating objects.

Experience working in various environments with change management, defect tracking and status reporting processes.

Created and deployed Mobile/IPad Dashboards.

Used free form SQL editor for complex report creation.

Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.

Environment: MicroStrategy Architect/Desktop/Web 9.0.2, Teradata, DataStage, MS Office, Tableau.

Client: UMB Bank

Duration: Jan 2014 to Sep 2014

Role: Microstrategy Architect / Developer

UMB Financial Corporation is an American financial services company based in Kansas City, Missouri, offering complete banking, payment solutions, asset servicing and institutional investment management to customers.

Responsibilities:

Architected schema objects such as MicroStrategy Attributes, Facts, Transformations and Hierarchies.

Extensively created filters, prompts, consolidations and custom groups to generate canned reports, ad hoc reports, documents and dashboards.

Involved in meetings with Business units to understand the requirements, translated them into Microstrategy design documents.

Worked closely with business to access requirements and translate them into technical requirements. Worked with data warehouse teams to build physical data model to meet all data requirements.

Designed and built MicroStrategy project architecture to satisfy the requirements from stakeholders. Developed complex metrics, built reports and pixel perfect documents.

Enabled Ad Hoc reporting to users by building Report Builder, Visual Insight templates and enabling the slicing and dicing of data by providing drill maps to end users.

Used Enterprise Manager project to create Statistic reports to analyze the license usage, busy hour, Reports executed by Project & user. Reports helped to track the tool usage effectively to improve the platform further.

Used the Object Manager to migrate the objects from Development to UAT/Production Environment in MicroStrategy.

Actively involved in the Implementation of Novell LDAP authentication for Microstrategy Products.

Involved in complete Data Warehouse life cycle. Analyzed the business requirements and created system requirement specification (SRS) document to support the business needs.

Served as technical expert providing input to application design, performance tuning. Provided best practices and recommendations for robust and scalable BI environment.

Used Distribution Manager, Narrowcast server to schedule the reports to user’s email, file locations.

Involved in end user training.

Environment: MicroStrategy9.0.1/9.2.1 Desktop, Web, MicroStrategy Intelligence Server 9, Distribution Services, Netezza, DataStage, Aginity, SharePoint, Clarity, Citrix, QC, Mainframes, Linux server.

Client: Bio-Rad Laboratories, Hercules, CA

Duration: Apr 2013 to Dec 2013

Role: MicroStrategy Developer

Bio-Rad Laboratories, Inc. was founded in 1952 in Berkeley, California. The company was initially engaged in the development and production of specialty chemicals used in biochemical, pharmaceutical, and other life science research applications. Today, Bio-Rad manufactures and supplies life science research, healthcare, analytical chemistry, and other markets with products and systems used to separate complex chemical and biological materials and to identify, analyze, and purify their components.

Responsibilities:

Developed most of the Schema Objects such as the Tables, Facts, Attributes, Hierarchies and Transformations.

Involved in development of the Public Objects such as Filters, Prompts, Metrics, Templates, Drill maps necessary for producing the Client Reports and Scorecards.

Extensively worked on building all the Scorecards and Dashboards using MicroStrategy Report Services.

Used MicroStrategy Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment.

Created advanced Grid reports, consisting of data analysis by combining a template with filters. The end-users could generate Ad-Hoc report by drilling up, down, within and across dimension or anywhere.

Developed a web course and took several classes to train the end users to efficiently use MicroStrategy.

Created several data marts using MicroStrategy for different tools to access large datasets.

Widely used VLDB properties to set default criteria at project level and also at individual report levels to overcome performance issues.

Worked with the DBA on issues of database performance and security.

Highly interacted with the Testing group to make them better understand various operational reports and Business Performance Measurements functionalities.

Designed an efficient BIDashboard for the Company Executives, through efficient use of MicroStrategy Report Services.

Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to ProductionEnvironment.

Environment: MicroStrategy 9,9.4.1 (Desktop, Administrator, Web), SQL server, MicroStrategy Intelligence Server, Distribution Services, Oracle 11g, Netezza, Windows server 2008.

Client: Limited Brands, Columbus, OH

Duration: Oct 2012 to Mar 2013

Role: Microstrategy Developer

L Brands Inc. (formerly known as Limited Brands Inc and The Limited Inc.) is an American fashion retailer based in Columbus, Ohio. Its flagship brands include Victoria's Secret and Bath & Body Works.

Responsibilities:

Developing MicroStrategy Schema/Public objects, Application objects, Delivery objects including Metrics, Metric properties (Dimensionality, Filter, Transformation), Filter objects including securityfilters, Reports (complex, Ad hoc, Parameter-driven, Personalized, indicator,

Set analysis, What-ifanalysis, Data-mining, Datamartreports, etc.).

Created very complexreports eg: Market-Basket Analysis involving interactive web and windows interface.

Created User requirement document for realizing MicroStrategyobjects to be integrated in the report.

Created logicaldatamodels, recognize source tables and columns, to build, Attributes, Facts,

Hierarchies and Relationships necessary to create a MicroStrategy project.

Created Intelligence Cubes in MicroStrategy to overcome performance issues related to Report Service Documents Using high volume datasets. Using I-cubes improved performance of the RS documents significantly.

Ensures the testing and verification of new reporting processes.

Using MicroStrategy Web to offer interactive reporting to the end users through a web browser.

Perform administrative tasks like User Creation and assign Privileges.

Work with MicroStrategy Object Manager to move objects among the development to Testing environments.

Create Drilling path and implement those into reports such that user can Drill across different System and User hierarchies.

Create and implement Transformations in Reports.

Enhanced existing dashboards and scorecards using KPIs and enabling drill functionality.

Unit testing of Microstrategy reports and troubleshooting the production issues.

Create a wide variety of fully interactive scorecards, Dashboards, Documents and Enterprise Reports.

Environment: MicroStrategy8.4/9.0 (Desktop, Administrator, Web), SQL server, MicroStrategy Intelligence Server 9, Distribution Services, Oracle 11g, Netezza, AQT, EPM, Windows server 2008.

Client: KPIT Cummins, Pune, India

Duration: Feb 2010 to Sep 2012

Role: Microstrategy Developer

KPIT Technologies (formerly KPIT Cummins Infosystems Ltd) is Indian Multinational corporation with registered office in Pune, Maharashtra, India. Popularly known as KPIT, the company provides product engineering services and solutions, IT consulting services and technologies. Headquartered in Pune, India.

Responsibilities:

Effectively participated in Agile SDLC methodologies working with cross functional teams. Successfully demonstrated multitasking capabilities by involving in multiple projects and support initiatives.

Worked closely with data architects to evolve Charter communications Enterprise datawarehouse that supported reporting applications.

Involved in meetings with Business units to understand the requirements, translated them into Microstrategy design documents.

Worked on SDK in Modifying and over writing Existing Plugins. Adding Extra Plugins where required.

Worked Closely with SDK Developer in Finding Issue on CSS files and Suggested Code Modification required.

Used SDK for web customization.

Created reports with various objectprompts to generate various Ad Hoc reports.

Implemented the user defined MicroStrategy objects like customgroups and consolidations according to the requirement.

Developed Metrics, Filters, prompts to achieve the functionality of the canned reports and created advanced objects like DerivedMetrics, CompoundMetrics.

Developed MicroStrategy dynamic dashboards in the Flash Mode using several controls and worked extensively on widgets.

Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.

Involved extensively in the overall lifecycle of the Data Warehouse integration project.

Environment: MicroStrategy 8.0 (Desktop, Administrator, Web), SQL server, MicroStrategy Intelligence Server 9, Distribution Services, Oracle 11g, Netezza, AQT, EPM, Windows server 2008.

Client: ByteAlpha Solutions, Hyderabad, India

Duration: Jun 2008 to Jan 2010

Role: Microstrategy Developer

ByteAlpha Solutions is a Hyderabad based IT development company.

Responsibilities:

Responsible for gathering and refining business requirements from the Business users.

Troubleshooting of reports, SQL statements and report performance to ensure that the system is continually running at peak performance.

Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.

Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.

Created facts, dimensions, and attributes using MicroStrategy Architect.

Created metrics, filters, and templates for the reports.

Designed Dashboards using the selectors radio buttons, check boxes, panels, slider and button bar etc. summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.

Served as technical expert providing input to application design, performance tuning. Provided best practices and recommendations for robust and scalable BI environment.

Involved in end user training.

Unit testing of MSTR reports and troubleshooting the production issues.

Involved in Informatica development besides MicroStrategy role.

Environment: MicroStrategy 7.X/8.X, Oracle8i and Windows 2000.

Contact this candidate