SUMMARY

• Around 6 years of professional Expertise in Microstrategy 10.X/9.x/8.x suite using Microstrategy Desktop, Microstrategy Web, Microstrategy Intelligence Server, Microstrategy Object Manager, Microstrategy Command Manager, Microstrategy Report Services, Microstrategy Rs D ocuments/Dashboards, Microstrategy Architect
• Evangelist of agile/scrum principles and methodology
• Certified Scrum Master and MicroStrategy Certified Specialist Analyst
• 2 years of agile environment experience and worked as scrum master internally
• Good understanding of data warehousing concepts such as schemas, grains, facts and dimensions, different kinds of dimensions, conceptual, logical and physical model.
• Involve in architecture and design of solution leads module level design and implementation
• Having good experience in working on Public Objects (Metrics, Filters, Drill Maps, Prompts, Custom Groups, Consolidations, Reports and Documents).
• Having good Knowledge in creating Schema Objects (Attributes, Facts, Hierarchies and Transformations).
• Hands on experience and knowledge in the Dashboard design/development. Created interactive dashboards with multi - panels, selectors and widgets.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Expertise in Mobile, Visualization, SQL, FreeForm SQL,Transactions Services
• Worked on automation of Cube publishing in MicroStrategy using Scheduling

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy 10.x(Architect, Object Manager, Command Manager, Enterprise Manager, Visualization, Transaction Services), Tableau (Beginner)

Data Modeling ETL Tool: Normalized, De-normalized, Star and Snow Flake Schemas, Fact Tables, Lookup Tables and Drill hierarchy Informatica 9.1 SQL Scripts

Scripts Databases: MS-SQL Server 2008 R2, Oracle9i, Oracle10g,PostgreSql, Toad, Redshift, Netezza HTML, CSS and Java Script, R (Beginner)

Internet Technologies: Alteryx(Beginner)

Data Preparation Tool: C, C++,Java, SQL, Python(Beginner)

Programming Languages: Windows 7, Linux Cent OS

Operating Systems: Confidential Remedy IT Service Management System, Rally

Helpdesk Systems: Mobile/I-Pad/I-Phone App Development

PROFESSIONAL EXPERIENCE

Confidential

Applications Developer

Responsibilities:

• Analysis of Metasheet and design the schema by understanding various scenarios
• Gap analysis for LDM and DDL
• Involve in architecture and design of solution leads module level design and implementation
• Create bulk attributes and metrics using command manager scripts
• Enhance ETL by suggesting various scenarios for renewal rate calculations and communicate to ETL members

Confidential

Applications Developer

Responsibilities:

• This is ESO Executive Summary iPhone application built using excel data source and MicroStrategy reporting tool. Alteryx is used as data preparation tool in this project.
• This application developed for 5 screens -Executive Summary, Financial Performance, Customer Experience, Product Innovation & Growth Strategy

Environment: MicroStrategy 10.3, Alteryx

Confidential

Applications Developer

Responsibilities:

• This application makes the EDW the adjusted spend source going forward. The adjustment tool also greatly reduces time required for FP&A to identify and apply spend adjustments using Transaction services.

Environment: MicroStrategy 10.3, Netezza, Transaction Serivces

Confidential

Assoc Application Developer

Responsibilities:

• Involving in requirements gathering and clarifications from TSA & Analyses the BO Reports
• Analysis of mockups and performed gap analysis for the BO2M project
• Worked with VLDB properties to improve the performance of reports.
• Developed schema with proper parent-child relationships
• Developed Reports same as BO, Work on RSD, Dashboards, VI
• Involved in Report data manipulations like Data Pivoting, Page-By, Sorting, Total, Thresholds etc.
• Created complex filters with advanced qualification involving 'ApplySimple' and 'ApplyComparison' functions.
• Worked on understanding reports of SAP Business Objects, Crystal Reports and converting into MicroStrategy Layer
• Creating Mobile Dashboard with HTML containers.
• Experience in integrating MicroStrategy functionality into other applications (portal Integration): Displaying MicroStrategy Data within Salesforce

Confidential

MicroStrategy Senior Developer / Associate Consultant

Responsibilities:

• Involving in requirements gathering and clarifications from client/Product Manager
• Providing estimated timesheet and plan for the project, Analysis of mockups and performed gap analysis for the ITSM project
• Developed schema with proper parent-child relationships
• Built complex reports and done data testing & Created a MicroStrategy Mobile Apps and Dashboards with proper look and feel
• Performed Smoke and unit testing for the complete Dashboard and Apps, Fixed the schema, dashboard, performance related issues Providing solutions for various ad-hoc request

Confidential

MicroStrategy Developer / Senior Associate

Responsibilities:

• Worked from onsite location for client, involving in requirements gathering and clarifications from client, Designed Dashboard Mockups and developed dashboards
• Developed schema and application objects in MicroStrategy
• Implemented Manual SQL scripting for Data Testing, ETL and validation on Oracle DB, Fixed the schema, dashboard, performance related issues
• Helped ETL Team in designing tables in warehouse

Confidential

MicroStrategy Developer / QA

Responsibilities:

• Involved in requirements gathering and clarifications from client
• Created data dictionary of business terms
• Performed gap analysis for the project
• Created Source to Target mapping document by checking complex SQLs
• Developed schema and application objects in MicroStrategy
• Created functional testing scenarios for Mobile app
• Created Adhoc reports for testing data of reports of MicroStrategy app

Confidential

MicroStrategy Administrator / Developer

Responsibilities:

• Analyzed data load strategy with possible scenarios
• Analyzed requirements for the Dashboard and list reports to be developed
• Worked on scripts for data loading
• Created functional test cases document of list reports and dashboard
• Performed POC for Report Services Document having multiple headers and documented the findings
• Worked on Collapsible Sections with jQuery using MSTR HTML Container
• Worked on hiding Toolbar Items for document using HTML Container

Environment: MicroStrategy 9.2.1 m GA, Oracle 10g, Oracle 11g

Confidential

MicroStrategy Administrator / Developer

Responsibilities:

• Gathered and analyzed requirements
• Developed schema and application objects in MicroStrategy
• Performed ETL scripting for oracle Database (Staging Area) since source was “.csv” file
• Designed Dashboard Mockups and developed dashboards
• Prepared unit test cases document and performed smoke and unit testing
• Implemented Manual SQL scripting for Data Testing, ETL and validation on Oracle 10g DB
• Worked on MicroStrategy Object Manager for migration of various MicroStrategy objects
• Configured Mobile server and Intelligence server
• Created a MicroStrategy Mobile App with proper look and feel
• Worked on optimizing the performance of the dashboard using Enterprise Manager, Diagnostic tool
• Fixed the schema, dashboard, performance related issues

Confidential

MicroStrategy Developer

Responsibilities:

• Worked on setting up Mobile Configurations
• Developed Mobile App and implemented automatic switching of App from landscape to portrait view without changed in formatting
• Worked on look and feel of the App
• Learnt and implemented BFSI domain knowledge

Market Basket Analysis

Confidential

• Worked on optimizing the performance of the dashboard
• Reduced the 72 number of datasets to 17 by aggregating the datasets in short span of time
• Changed the Data load scripts
• Fixed the complex issues raised by MicroStrategy and delivered the high-performance dashboard
• Restored the database from one machine to another machine SQL Server using scripts
• Worked on setting up Mobile Configurations
• Developed Mobile App and implemented automatic switching of App from landscape to portrait view without changed in formatting
• Learnt and implemented BFSI domain knowledge
• Developed some MicroStrategy Reports using MicroStrategy Desktop
• Developed some schema and application objects in MicroStrategy
• Learnt and implemented BFSI domain knowledge

Confidential

MicroStrategy Developer

Responsibilities:

• Analyzed the data and suggest reports/dashboards which can be built to do better risk management
• Developed schema and application objects in MicroStrategy
• Developed reports with complex graphs developed dashboards, App
• Performed Smoke and unit testing for the complete Dashboard
• Implemented Manual SQL scripting for Data Testing, ETL and validation on Postgre SQL
• Worked on MicroStrategy Object Manager for migration of various MicroStrategy objects
• Learned and implemented banking domain knowledge

Confidential

Data Warehousing Associate

Responsibilities:

• SQL Essentials course and project
• Introduction to Data Warehousing and concepts
• Web Programming Basics - HTML, CSS and JavaScript
• Data Quality courses and project
• ETL Concepts, latest trends
• Data Integration project using Informatica 9.1
• MicroStrategy Business Intelligence Platform - MicroStrategy Certified Engineer (MCE) training. Courses: Reporting Essentials, Project Design, Advanced Reporting, Enterprise Reporting, Dynamic Enterprise Dashboards, Intelligence Server Administration, Enterprise Manager, Command Manager, Object Manager, Web Report Design and Analysis, Development Standards
• Consulting Skills Training including communication skills, project management, time management and client management