SUMMARY:

• 8+ years of experience in Microstrategy Suite (Microstrategy Desktop, Architect, Web, Narrowcast Server, Object Manager, System Manager).
• Good experience with other BI tools like Tableau, Business Objects
• Good experience on Migration of reports from Business Objects, Tableau to Microstrategy
• 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.
• Good experience with Microstrategy Visual Insight reports.
• Experienced in using Project Merge, Object Manager and Enterprise Manager.
• Proficient in designing reports through Microstrategy Desktop with optimal usage of key features like Advanced filters, Filters, Prompts, Transformations, Custom Groups, Consolidations.
• Good experience in Microstrategy Report Service Documents and Dashboards.
• Good experience in Narrowcast Server and Distribution Services.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the Cube Services.
• Used VLDB Properties such as Joins, Query Optimization, Metrics (Null check and Zero check), Select/Insert and Tables.
• Worked with large databases like Teradata, Oracle.
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users’ requirements).
• Created Analytic based selectors’ grid/graphs that control other grid/graphs through a panel stack, inserting as many panels as needed within a panel stack.
• 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

Data Modelling Tools: Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Bellevue, WA

Report Developer

Responsibilities:

• Majorly involved in understanding the data model from scratch required to generate the reports.
• Analyzing the existing Excel based reports and transforming them to Microstrategy reports.
• Created Dashboards with interactive views, trends, ad - hoc reporting and drill-downs.
• Extensively designed, developed and tested reports and dashboards using best practices for Microstrategy Report Development.
• Involved in writing complete SQLs required for reporting based on requirement.
• Hands on writing complex calculations and using the same logic in different ways.
• Developed dashboards that provide clear visualizations of various industry specific KPIs.
• End to end experience in designing and deploying the dashboards in Microstrategy.
• Closely working with stakeholders in gathring project requirements.
• Closely working with existing devlopers and project lead to understand the application functionality.
• Generated context filters and used performance actions while handling huge volumes of data.
• Experience in modifying existing reports and dashboards and analyzing it to develop better visualizations with more detail.
• Ability to work quickly and under tight delivery deadlines with focus on detail.
• Working under Agile methodology to deliver the changes to business

Environment: Microstrategy 10.2, Oracle 9i

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 a physical data model based on logical design
• Developed macros in Teradata to load the data from base tables to Businesslayer tables
• Developed the Tableau Dashboard to report the KPIs of all the products and Player segmentation
• Automated the dashboard to Exec’s on daily basis
• Worked under Agile methodology to deliver the changes to business

Environment: Tableau 9.1, Informatica, Teradata 13

Confidential

MicroStrategy Architect and Administrator

Responsibilities:

• 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
• 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

Confidential

MicroStrategy Architect and Administrator

Responsibilities:

• Involved in identifying new business reporting requirements and translating them into database requirements
• Identified the existing reporting needs and ensure that they all delivered in the new business layer
• Discussed the new model with various business users and ensured that all their requirements are met in the new model
• Created a new project in MicroStrategy as per the new business layer
• Created new folder structures, User groups and security filters
• Developed schema objects needed for report development needs
• Ensured all reporting standards are met
• Developed Intelligent Cubes as part of optimizing the load on Data warehouse and support faster data retrieval
• Worked under Agile methodology to deliver the changes to business

Environment: Microstrategy 9.4, Informatica, Teradata 13

Confidential

Sr. MicroStrategy Developer, Admin

Responsibilities:

• Played key role in understaing the reports in Business Objects and identifying the business logic
• Mapped business objects understandings in Microstrategy requirements
• Developed a reporting schema based on the understanding
• Developed and proposed the data model for new business layer
• Set up new project for this purpose and developed new schema from scratch
• Designed and deployed security access in MicroStrategy
• Ensured all reporting standards are met
• Developed RSD’s as per the user requirements

Environment: Microstrategy 9, Informatica, Teradata 12

Confidential

Sr. MicroStrategy Developer

Responsibilities:

• Played key role in Requirement Analysis and design discussions
• Involved with the database team to get the US data in Eastern Timezone
• Set up a new project for this purpose and developed new schema from scratch
• Designed and developed security access in Microstrategy
• Created all the reports based on Partners requirements
• Set up Narrowcast report delivery to the partners to receive the reports

Environment: Microstrategy 9, Informatica, Teradata 12

Confidential

Sr. MicroStrategy Developer

Responsibilities:

• Developed schema objects needed for report development needs
• Restricted user access and applied security based on the reporting requirements
• Developed static reports as per the report layout for partners
• Developed daily Dashboards with revenues and gaming activity
• Developed RSD’s to report the monthly invoices for finance teams
• Developed various public objects needed for building the reports
• Set up Narrowcast report delivery to the users to receive the reports

Environment: Microstrategy 9, Informatica, Teradata 12

Confidential

MicroStrategy Developer

Responsibilities:

• Developed static reports as per the report layout suggested by business users
• Developed various public objects needed for building the reports
• Set up Narrowcast report delivery to the business users to receive the reports automatically

Environment: Microstrategy 8, Informatica, Teradata