SUMMARY

• Versatile IT consultant with over 5 years of experience as a MicroStrategy Developer/Architect in healthcare, gaming, retail, finance and logistics sectors . A self - starter who enjoys working in a team environment, and who also works very well independently. Well reputed among superiors, colleagues, and associates for analytical, project management, problem solving, team building and leadership skills, as well as for commitment and work ethic.
• Over 5 years of strong experience using MicroStrategy 10.1/9.4.1/9.3/9.2 (Desktop, Intelligence Server, Architect, Object Manager, Integrity Manager, Web, Mobile and Narrowcast Server)
• Highly experienced in gathering and documenting business requirements, creating business and functional documents.
• Extensively worked in creating MicroStrategy Reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Expert UI designer specialized in developing visually stunning MicroStrategy Dashboards using Report Service
• Developed MicroStrategy mobile applications using mobile platform
• Highly experienced in fine tuning reports by applying MicroStrategy analytical and database optimizations.
• Expert in building Intelligent Cubes for supporting reports and dashboards as well as developing ad-hoc reports
• Good understanding in setting up Narrowcast Server concepts
• Strong SQL skills.
• Proficient in working with Star Schema and Snow Flake schema.
• Good experience in building Tableau workbooks, Data Sources, Views and Dashboard
• Good knowledge on Informatica Power Center 9.6.1 on mappings and workflows.
• Excellent communication, presentation and interpersonal skills.

TECHNICAL SKILLS

BI Tools: MicroStrategy 10.1, 9.4.1, 9.3, 9.2, 9.0/8.x (Administrator, Desktop, Intelligence ServerWeb, Visual Insight, Object Manager, Integrity Manager, Narrowcast Server, ArchitectEnterprise Manager, Distribution Services, MicroStrategy Office), Tableau10.1, 10.3, ERWINCognos Reporting Suite, Informatica 9.6.1

Database Tool: SQL Server, Oracle, DB2, Vertica, Teradata 14x, 15.10

Languages: C, C++, SQL, Java

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential

Microstrategy/Tableau Developer - Lead

Responsibilities:

• Lead transition process from Confidential to Infosys for Microstrategy
• Only Microstrategy Developer for the project responsible for all the development
• Created Ad-hoc reports by gathering specific requirements from the different business units (Oncology, Radiology, WHC, etc.)
• Interacted with users from different functional teams across the organization in gathering requirements for developing Sales dashboard and Performance Index Healthcare dashboards
• Worked closely with Offshore Admin team in building Attributes, facts, Hierarchies across different BU’s
• Built various MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Created report services documents for IC(Incentive Compensation) records and Sales analysis.
• Worked on the Excel formatting, macros and templates of the documents which are used in different services.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Extensive Testing and Data validation of Reports before delivering it as Business takes important decisions on data we provide.
• Used Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
• Experience in using Teradata utilities such as Fastload, Multiload and Fast Export.
• Developed complex dashboards in Tableau as a part of MDM-Tableau uplift project from scratch.
• Gathered requirements from different stake holders from MDM team to develop 30 dashboards across multiple Business Units.
• Performed as onsite Admin for Tableau, scheduling refreshes for dashboards, granting end users access, managing user groups, migrating groups from old domain to new domain(Active Directory Migration Project)
• Involved in giving demos/Presentations and training to end users on using Microstrategy Web
• 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
• Created status reports and used Jira for tracking the issues and Data Service Request(DSR’s) from Business users.

Environment: MicroStrategy 9.4.1 (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services), Teradata 14.10, 15.10, Tableau 10.1,10.2, 10.3,Informatica 9.6.1, Jira, Windows 7

Confidential, NY

MicroStrategy Admin/ Developer

Responsibilities:

• Administered MicroStrategy environments and formulated end user groups.
• Worked with Narrowcast server for sending reports via email to a large executive distribution group.
• Handled end user licenses for initiatives.
• Implemented Nested Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Used the Object Manager to move the objects from one Environment to other in MicroStrategy. And duplicated the project to various other environments when required.
• Involved in creating user groups and security filters for users and assign privileges.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Wrote specification for the development.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Optimized the performance of the MicroStrategy platform by implementing suitable report design processes, and SQL tuning.
• Built visually stunning dashboards as per the requirement of end user.
• Upgraded MicroStrategy from 9.4.1 to 10.1

Environment: MicroStrategy 10.1/9.4.1 (MicroStrategy Admin, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Object Manager, MicroStrategy Integrity Manager, MicroStrategy Intelligence Server), DB2, Windows 7

Confidential, Verona, NY

MicroStrategy Developer/Architect

Responsibilities:

• Migration of reports from Cognos to MicroStrategy
• Worked on advanced MicroStrategy Reports concepts by creating attributes, facts, metrics, filters, Custom groups and templates using MicroStrategy Desktop
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Analyzed and developed the new objects in Dev environment. Migrated them to QA environment after unit testing
• Created complex Logical Views in MicroStrategy
• Worked with Pass through Functions like Apply Simple, Apply Comparison & Customized attribute Qualification Filters
• Designed and built schema objects using MicroStrategy Architect
• Hands on knowledge on upgrading Microstrategy from 9.4.1 to 10.1
• Performed as a lead in educating the end users of Supply Chain, Retail, Finance and Gaming departments making them understand the importance and usage of Documents and Dashboards as its their first time using Microstrategy
• Working with Business Users to fix reports which required minor changes.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Built Documents and visually stunning dashboards as per the requirement of end users.
• Worked on developing Expression and Table based Transformation.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Created Schedules for the reports and documents suggested by the End Users.
• Involved in migration of projects from Dev to UAT and UAT to PROD.

Environment: MicroStrategy 10.1/9.4.1 (MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Object Manager, MicroStrategy Intelligence Server), DB2, AS/400, Windows 7.

Confidential

MicroStrategy Developer

Responsibilities:

• Worked with business analysts to baseline the reporting requirements.
• Hands on the dimension model with Data Modelling team to close out the gaps in the model to best use the underlying tables needed for BI layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with Microstrategy architect to develop schema objects such as, attribute, facts, hierarchies and transformations etc.
• Profusely used Microstrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups and consolidations .
• Created drill maps for end users to drill down and recover data.
• Worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Tuned and improved the performance of the dashboards using VLDB properties, database tuning and using cubes.
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Designed and Developed Microstrategy Dashboards using customized Widgets.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.

Environment: MicroStrategy 9.3(Desktop, Intelligence Server, Web, Administrator, OLAP Services, MicroStrategy Project Manager, Narrowcast Server), DB2 9.5, Windows 2003 Server, Windows XP, Oracle