SUMMARY:

• Experienced MicroStrategy Developer/Architect, Tableau wif 15+ years of IT experience. Responsible and provided support for Reporting, Data analysis of Conduct Management & Enterprise Risk at Confidential . Managed Confidential Theme Park & City Walk BI, Avon BI environments. Experienced senior lead analytics consultant wif a demonstrated history of working in teh Banking, Financial, Retail, and Entertainment industries. Technical specialized experience in Business Intelligence - Expertise includes mainly in Tableau, MicroStrategy, Oracle, Teradata, Vertica, and PostgreSQL.
• Developed fully interactive dossiers, dashboards, and enterprise reports using Tableau and MicroStrategy Report Services for Web and Mobile.
• Participate and answer Audit questions that cover areas like change management, Access Security, Business Continuity, and Disaster Recovery.
• Provides assessments of technical and operational practices based on industry standards specific to teh requested technology.
• Impact analysis of teh existing dashboards based on teh data model and business changes.
• Ensure that all projects are delivered on time, wifin teh scope, and wifin budget
• Communicate wif business and technical stakeholders to perform solution architecture/technical requirements gathering, technical design, development, and testing tasks.
• Create and maintain comprehensive project documentation like Functions Review document, Functional Specifications document, and data mapping document.
• Develop a detailed project plan to monitor and track progress
• Delegate project tasks based on team members’ strengths, skill sets, and experience levels
• Report and escalate to management as needed on daily and weekly status meetings
• Extensive noledge and understanding of designing data visual presentations, research, and gap analysis
• Performance Optimizing by creating Caching & Intelligence cubes, enhancing teh SQLs.
• Optimizing report generation wif respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, Security, query execution, and scalability issues suited for Oracle.
• Involved in ETL process using Informatica Power Center.
• Exposure to Data Modelling and Predictive Modeling

PROFESSIONAL EXPERIENCE:

Confidential

Lead Architect/Developer

Responsibilities:

• Building Conduct Management Analytics, Quality Management Program, Customer Impact analysis reporting solutions.
• Strengtan Conduct Analytics Reporting capabilities.
• Provide a single platform for all teh Risk Reports
• Designed, developed, tested, and maintained various operational dashboards using Tableau and MicroStrategy reporting tools based on user requirements.
• Provided production support to Tableau users and wrote Custom SQL to support business requirements.
• Utilized Tableau Server to publish and share teh reports wif teh business users.
• Time-based schedules to Event-based schedules.
• Creating and implementing various Schema Objects (Facts, Attributes, Hierarchies, and Transformation) and Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidations, Searches, and Templates) to develop reports, documents, and dossiers.
• Worked on Confidential MSTR Standards in Conduct Analytics
• Improve reporting controls through reduction of manual processes
• Define business requirements and translate business needs into analysis, designs, and recommendations.
• Provide best-in-class visualizations using Vitara charts
• Created best practices documents and team standards

Environment: MicroStrategy, Tableau, Teradata, SQL Server

Confidential

MicroStrategy Architect/Tableau Developer

Responsibilities:

• Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects.
• On-call support on a rotation basis wif teh onsite-offshore model.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Design and develop Tableau visualization solutions.
• Extensively worked on Narrowcast Static and Dynamic subscriptions.
• Extensively worked on scheduling/subscribing formula-based Excel reports and PDF reports using Narrowcast.
• Created new users and gave them access to teh MicroStrategy Platform. Used administration tools like Project Merge and Object Manager to move teh objects from one environment to another.
• Developed Flash Dashboards in 9.4 using Widgets and Selectors for summary level reporting.
• Created Application, Configuration, and Schema objects.
• MicroStrategy tool Suite (MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Architect, MicroStrategy Narrowcast server, MicroStrategy OLAP Services, MicroStrategy Distribution Services, MicroStrategy Dossiers, and Dashboards).
• Extensively used createdHierarchical prompts& object prompts.
• Restricted access to users by implementing Security Filters & Security Roles.
• Used Object Manager to migrate objects between various environments.
• Used Integrity Manager during teh upgrade from 9.3.0 to 9.4.1.
• Used theVLDBproperties forperformance tuningandSQL optimization.
• Created Transformations, complex filters/objects wif advanced qualifications involving teh ‘Pass-Through’ functions.
• Created interactive dashboards/dossiers for Mobile/iPad
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups, and Consolidations for Complex Reports.
• Worked wif back-end Database Analysts/Administrators to provide requirements for necessary back-end tables.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and was Involved in creating Reports scalable to large volumes of data.
• Managed projects through teh entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Environment: MicroStrategy 9x, Tableau, Teradata

Confidential

MicroStrategy Architect/Developer

Responsibilities:

• Performed Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, implementation, and post-production support of BI projects.
• Extensively worked on Narrowcast Static and Dynamic subscriptions.
• Developed Flash Dashboards in 9.2 using Widgets and Selectors for summary level reporting.
• Extensively worked wif MicroStrategy Intelligence Server, MicroStrategy Web, and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.
• Involved in troubleshooting MicroStrategy prompt, Filter, Template, Consolidation, and Custom Group objects in an enterprise data warehouse team environment.
• Created Complex filters/objects wif advanced qualifications involving teh ‘Pass-Through’ functions.
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups, and Consolidations for Complex Reports.
• Worked wif back-end Database Analysts/Administrators to provide requirements for necessary back-end tables.
• Extensively worked in both Ad-hoc and Standard Reporting Environments and was Involved in creating Reports scalable to large volumes of data. Managed projects through teh entire Systems Development Life Cycle, including creating timely/thorough status reports and leading status meetings.

Environment: MicroStrategy 8x/9x, Oracle 10g/11g

Confidential

MicroStrategy Architect

Responsibilities:

• Developed Flash Dashboards in 9.2 using Widgets and Selectors for summary level reporting.
• Extensively worked wif MicroStrategy Intelligence Server, MicroStrategy Web, and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.
• Created advanced Links and Drill Maps (Drill UP, Drill Down, Drill to Template, Drill Across, Link to Report) depending on hierarchy and user requirements to drill teh reports on different levels.
• Developed various Ad-hoc Reports and Documents using Report Services Documents.
• Worked extensively on creating Application Objects like Metrics, Compound Metrics, Filters, Custom Groups, and Consolidations for Complex Reports.
• Created Subscription Sets, Schedules, and Services in teh Narrowcast application to distribute reports.
• Tested all teh reports by running queries against teh warehouse. Also compared those queries wif teh MicroStrategy SQL engine-generated queries.
• Used Auto Prompts filter feature to give teh end-user a choice of different filtering criteria each time they run teh report.
• Worked along wifMicroStrategy Knowledge Base to troubleshoot some Report related issues.
• Played a key role in User Acceptance Testing of teh reports.
• Involved in creating Security filters to end users to access data, based on their privileges.
• Interacted wif Visual Basic and Java teams as a part of SDK changes.

Environment: MicroStrategy 8x/9x, Hive, Visual Basic.

Confidential

MicroStrategy Developer

Responsibilities:

• Involved in designing teh functional specification of reports based on requirements.
• Analyzed teh business model to understand teh Existing Systems and Business Requirements.
• Created MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics, and templates using MicroStrategy Desktop.
• Used MicroStrategy Web to offer interactive reporting to teh end users through a web browser.
• Worked on teh development of Dashboards, Reports, and Intelligent Cubes based on teh technical and business specifications of teh customer.
• Created simple and complex reports in MicroStrategy Desktop and web and provide Production support.
• Created ad-hoc reports by drilling up, down, wifin, and across Hierarchies.
• Used Apply Simple and Apply Comparison functions to develop complex
• Involved in teh Creation of Documents from multiple Datasets like Map applications, grids, and graphs.
• Worked wif Object Manager to move Objects and Packages between different environments.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.

Environment: MicroStrategy 7x/8x