SUMMARY

• 8+ years of extensive experience in Microstrategy Suite ( Microstrategy Desktop, Architect, Web, Narrowcast Server, Object Manager, System Manager ) as a Developer, Architect, Administrator, Tableau in Enterprise Environment, in Tableau 9.0 and 10.0 as a Developer.
• Good experience with other BI tools like Tableau, Business Objects
• Good experience on Migration of reports from Business Objects to Microstrategy to Tableau.
• Experience in working with the full project life cycle development process, involving analysis, design, development, implementation and testing phases
• Experience in migrating objects between Development, Testing and Production environments.
• Work closely with ETL/DBA teams to troubleshoot data issues and enhance database performance.
• Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards, scorecards, freeform SQL reports, objects ( Attributes, Logical Views, Filters, Metrics, Transformations, Hierarchies, Drill maps, Facts and Prompts ).
• Extensive experience in designing and developing interactive Dynamic Dashboards using Report Service Objects like Panels, Selectors, Grouping and Grid/Graph combinations.
• Extensive knowledge in various reporting objects like Facts, Attributs, Hierarchies, Transformations, Filters, Prompts Calculated Fields, Sets, Groups, Parameters etc in Tableau .
• Designed and Developed Interactive Tableau Dashboards and Reports, Recommending dashboard enhancements per Tableau Visualization features.
• Worked with large databases like Teradata, Oracle .
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/dashboards.
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users’ requirements).
• Have good understanding of Tableau Architecture, Design Development and End user experience.
• Ability to work in multiple projects simultaneously and independently as well as in a team environment.
• Good knowledge and understanding on data warehouse concepts.

TECHNICAL SKILLS

Reporting tools: MicroStrategy 10.x, 9.x, Tableau 9.x

Operating Systems: WINDOWS 8, XP, 2003, 2008, 2012, Solaris

Data warehouse: Teradata, Oracle

Etl Tools: Informatica

Date Modelling Tools: Erwin

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Microstrategy Developer

Responsibilities:

• Majorly involved in understanding the data model from scratch required to generate the Dashboards.
• Designed various templates to overcome the existing dashboard issues and presented to Business.
• Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval.
• Developed the dashboards based on Business inputs to overcome all the issues with existing GM Walk dashboards and data model.
• Involved in writing complete SQLs required for reporting based on requirement.
• Worked with Business Analysts to build reports and dynamic dashboards
• Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.4, PostgreSQL 10.7

Confidential, San Jose, CA

Microstrategy Developer

Responsibilities:

• Majorly involved in understanding the data model from scratch required to generate the reports.
• Developed the Schema objects required for the project like Facts, Attributes, and Transformations, Fact Extensions.
• Developed metrics, filters, prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval
• Validated end user requirements using MicroStrategy tools Involved in design/development life cycle including gathering requirements, user interaction and report design and development
• Involved in writing complete SQLs required for reporting based on requirement.
• Worked with Business Analysts to build reports and dynamic dashboards
• Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.4, Teradata 16

Confidential

Sr. Tableau Developer

Responsibilities:

• Involved in identifying the business requirements and translating them into logical design
• Presented the logical data model to the business and incorporated their suggestions
• Created customized Tableau Dashboards, integrating custom SQL from Teradata and performing Data blending in Reports.
• Developed macros in Teradata to load the data from base tables to Businesslayer tables
• Monitoring Teradata SQLs on production using Teradata Viewpoint and provided immediate fixes as required.
• Developed the Tableau Dashboard to report the KPIs of all the products and Player segmentation
• Automated the dashboard to Exec’s on daily basis
• Experience with high volume datasets from various sources like Teradata Tables, Text files, XML targets.
• Worked under Agile methodology to deliver the changes to business

Environment: Tableau 9.1, Informatica, Teradata 13

Confidential

MicroStrategy Architect and Administrator

Responsibilities:

• Played a key role in gathering Funtionally and Technical requirements as we have to report multiple Timezones and multiple Currencies including regulated markets like US, Spain, Denmark, France etc.
• Involved in identifying the gaps and and business reporting requirements and translating them into database requirements.
• Involved in discussions with various partners like PMU, Danskespil, Borgata for reporting in various Timezone’s and various currencies from a single project in Microstrategy.
• Involved in decision making on how to proceed to bring the various Timezone’s data into one database
• Set up new folder structures, User groups and security filters
• Developed schema objects needed for report development needs
• Ensured Row Level Security at database level to access single Timezone data at any point of time
• Developed various Interactive Dashboards including various widgets, Panels, Selectors, Grouping and Grid/Graph Combinations.
• Ensured there shouldn’t be data duplication because of various Timezones
• Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.1, Informatica, Teradata 13