PROFESSIONAL SUMMARY:

• Around 13+ years of IT experience on Enterprise level applications and Business Intelligence projects in various domains including Retail, Insurance, Health Care and Media etc. Demonstrated leadership and team work abilities with excellent communication skills.
• 8+ years of Enterprise Reporting experience using tools like Microstrategy Stack including Desktop, Intelligence Server, Web, /OLAP Provider, Architect, Enterprise Manager and Mobile and SSRS, Tableau.
• Comprehensive knowledge in MicroStrategy architecting and development, project management, security management, administration and testing. Working experience on MicroStrategy SDK development, integration, and maintenance. Ability to collaborate with data warehouse teams and ETL architects on overall design and solutions.
• Expertise in developing drill through, matrix, tabular reports, Cube Reports and VI Dashboards using BI reporting tools like SSRS, Microstrategy etc.
• Worked on integration of Oracle, MS SQL Server, Netezza, Confidential databases with Microstrategy along with developing Stored Procedures, Views.
• Working experience on assisting with QA testing, data validation and production support including system troubleshooting, performance tuning and change management. Managed user training programs in preparing user’s guide, training documentation, walk through of demos and exercises.
• Well - Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle.
• Excellent analytical with proficiency in debugging, quantitative/problem solving etc., programming, written and verbal communication skills.

TECHNICAL SKILLS:

BI/OLAP Tools: SSRS, MicroStrategy Desktop (Architect, Agent, Web, Intelligence Server, Mobile, Enterprise Manager, Distribution Services, MS - OLAP Services), TableauDatabases: Oracle, Netezza, SQL Server, Confidential, MYSQL

Utilities: TOAD, Oracle SQL- Loader, Visual Basic, SVN, Visual Source Safe, ERWIN

Languages: Java, PHP, HTML, XML, XSL, C, C++, VB Script, Flex.

ETL Tools:: Informatica, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Rancho Cordova, CA

Microstrategy Architect / Tableau Developer

• Act as primary Microstrategy Architect to lead team in set-up of the Medicare Sales Reporting Microstrategy Project.
• Responsible for overall solution design, build and test, root cause analysis and advanced performance tuning complex business processes and functionality.
• Understand the current Business Intelligence infrastructure and created a standardized approach for report development.
• As part of Sales and Integration Team, developed reports for sales department’s growth assessment needs for multiple states across the company.
• Analyze existing legacy reports in Microsoft Access to rationalize the scope of conversion efforts to Microstrategy.
• Design and develop holistic solutions to implement complex business logics and functional requirements by utilizing the full scale of Microstrategy functionality such as logical views, freeform sql, Intelligent cube, bursting, data blending, derived attributes etc.
• Developed reports and KPIs for various metrics such as New Sales, Applications, Membership, Agents calls volume, plan conversions and disenrollment summary etc.
• Manage SQL server database Objects to insure proper setup of fully and efficiently integrate with Microstrategy Project.
• Utilized Microstrategy multisource options to design and develop cubes and reports to perform complicated data retrieving job from multiple transactional databases.
• Directed power users and stakeholders to use Microstrategy to its best ability and developed high performance reports.
• Participated in implementing data quality initiatives.
• Developed Leadership and Executive summary dashboards consumed by RSDs and higher management to identify sales vs goals metrics and other analysis using Microstrategy graphs and widgets like ESRI Maps, Bubble grid, D3 etc.

Environment: MicroStrategy 10.10,, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Enterprise Manager, Office, MicroStrategy SDK, SSRS, Tableau

Confidential, Livonia, MI

Sr Microstrategy Consultant / Tableau Developer

• Enhanced existing reports by working with cross-functional teams on new requirements.
• Identified Source tables and columns required to create a MicroStrategy project, and mapped them into the project using Warehouse Catalog.
• Created Silent Installation scripts and performed installation and upgradation of Microstrategy on AWS Servers and provided step by step documentation.
• Developed Scripts to create users and verify metadata issues and worked on objects migration to different Environments using tools like Microstrategy Command Manager, Object Manager.
• Developed Command Manager Procedure and scripts to Email personalized set of reporting to set of dynamic users using Microstrategy File Bursting feature in MSTR 9.4.
• Installed and configured Microstrategy Enterprise Manager to gauge usage of reports and dashboards and tune performance accordingly.
• Optimized and Improved performance of Intelligent cube which took more than an hour to load to be loaded in 15 mins by tuning sql coding behind the cube.
• Built dashboards and reports like Campaign Health Portfolio for executives to identify KPIs such as Clicks per minute, Total Impressions, Delivered Impressions at different levels, Advertiser order Ad format, Booked Amt, %Delivered etc.
• Migrated report queries in oracle to other database platforms like mysql, Hive.
• Configured Cloudera Hive Connection in Microstrategy and developed reports using Atscale cubes.
• Migrated Microstrategy reports to Tableau using various database platforms.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created adhoc reports to users in Tableau by connecting various data sources.

Environment: MicroStrategy 9.x/10.x, Administrator, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Enterprise Manager, Office, MicroStrategy Mobile, MicroStrategy SDK, SSRS, Tableau, Hive, Atscale.

Confidential, West Borough, MA

Sr Microstrategy Consultant

• Designed and developed Cubes, reports and interactive dashboards to satisfy the users’ functional and performance requirements. Created Level Metrics and Derived Metrics to perform complicated calculations and logic tests using data from multiple databases.
• Worked on Information Delivery by developing suitable Metrics (Derived metrics, Compound metrics), Filters (prompted filters, relationship filters, Nested filters), Nested Prompts, Custom groups and Consolidations, Custom Sub-totals, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.
• Used BI tools’ Web based feature like Microstrategy Web to offer interactive reporting to the end users through a web browser. Used Visualizations to view and analyze data in different perspectives.
• Developed pixel perfect, highly efficient Dashboards highlighting KPIs as per requirements. Used various Visualizations and widgets to visually discover and understand the patterns in data.
• Installed and configured Microstrategy Mobile on Ipad and developed interactive dashboards.

Environment: MicroStrategy 9.x, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Enterprise Manager, MicroStrategy Mobile, MicroStrategy SDK

Confidential, Wilmington, DE

Microstrategy Consultant

• Collaborated with offshore team on logical model, tuning sql scripts for BI reports.
• Installed and Configured Business Intelligence tools like Microstrategy as per client requirements and created step by step documentation for the same.
• Extensively worked in developing Reports with Metrics, Level metrics, Compound metrics, Filters, Custom Groups and Consolidationsfor complex reports
• Used Pass through functions like ApplySimple, ApplyComparisonfor various complex scenarios.
• Created Ad-hoc reports in grid, graph mode, consisting of data analysis by combining a template with filters, using Micro Strategy Desktop and Web.
• Used BI tools’ Web based feature like Microstrategy Web to offer interactive reporting to the end users through a web browser. Used Visualizations to view and analyze data in different perspectives.

Environment: MicroStrategy 9.x, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Enterprise Manager.

Confidential, Raleigh, NC

Microstrategy Consultant

• Installed and Configured Business Intelligence tools like Microstrategy as per client requirements and created step by step documentation for the same.
• Helped Product Consultants and Analysts understand Business Intelligence Reporting Visualizations and Widgets and trained Business users by creating Presentations, helped Customer teams build reports on their data using BI tools like Microstrategy web & Visual Insight.
• Used MicroStrategy Web and Visualization SDK, Flex for Custom Authentication, web customizations and building visualizations.
• Worked on Information Delivery by developing suitable Metrics (Derived metrics, Compound metrics), Filters (prompted filters, relationship filters, Nested filters), Nested Prompts, Custom groups and Consolidations, Custom Sub-totals, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.
• Performed problem assessment, resolution and documentation, performance and quality validation on new and existing reports and environments.

Environment: MicroStrategy 9.x, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Command Manager, Enterprise Manager, Office, MicroStrategy SDK

Confidential, Cleveland, OH

Microstrategy Consultant

• Installed and Configured Business Intelligence tools like Microstrategy as per client requirements and created step by step documentation for the same.
• Used MicroStrategy Web and Visualization SDK for Custom Authentication, web customizations and building visualizations.
• Worked extensively on creating Application Objects like Metrics, Prompts, Filters, and Custom Groups for complex reports.
• Developed pixel perfect, highly efficient Dashboards highlighting KPIs as per requirements. Used various Visualizations and widgets to visually discover and understand the patterns in data.
• Created Report Service documents with Drilling using Hyperlinks and edit links to various detail reports and Dashboards.
• Extensively worked on Designing & Developing complex Dynamic Dashboards using Panel Stacks, Selectors, Layouts and Widgets.
• Created and published intelligent cubes leveraging reports to access cubes instead of warehouse to get faster results.

Environment: MicroStrategy 9.x, Architect, Desktop, Developer, Intelligence Server, Object Manager, Integrity Manager, Command Manager, Enterprise Manager, Office, MicroStrategy SDK.

Confidential, Detroit, MI

Sr. Developer/Test Specialist/ Data Analyst

• Responsible for performing system Integration as well as user acceptance tests and approve production migrations.
• Experience in reviewing Project Requirements, Design & Business documents. Gathered Business Requirements, Functional Requirements and Use Cases of the Project.
• Worked with development, business and various other teams in the organization in completing the test effort and understanding the functionality of various business rules of the product.
• Involved in design, development and execution of Test cases of Informatica ETL code as well as Microstrategy reports. Thorough knowledge of Datamart design and dimension tables, fact tables and subject areas involved in the design as part of testing effort.
• Executed Oracle queries to test data quality based on the various testing and logged defects found using Clear Quest tool.
• Developed Requirement Traceability Matrix and conducted Test Readiness Sessions with business analysts to ensure all requirements are mapped.
• Created Job streams that run the Informatica workflows from Tivoli Scheduler and executed them in test environment.

Environment: Informatica Power Center 8.6, Microsoft SQL Server 2005, Cognos, Unix, Tivoli Scheduler, Oracle 10g, Toad, SQL Developer etc.