SUMMARY

• 10+ years of core experience in Data warehousing & Business Intelligence/Business Analytics software.
• Expertise has been concentrated in all the phases like Architect, Design, and Development& Administration of Microstrategy suite.
• Strong experience with products ofMicroStrategy9x suite namely Desktop, Web, Command Manager, Object Manager, Enterprise Manager and Narrowcast Server.
• Proficient in all phases of the Report development lifecycle, including requirements gathering, Design, Development, System Testing and User Acceptance & Support.
• Good understanding of concepts such as Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables, OLTP and OLAP systems.
• Extensive hands on experience architecting a Microstrategy project and building reports and dashboards
• Design, developing, deploying, maintaining and integrating complex Microstrategy reports, dashboards using Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, users, user groups, security filter etc.) using MicroStrategy desktop.
• Highly experienced in developing Transaction services screen that allow users to take action on a decision from directly within a MicroStrategy application by inserting, updating, or deleting rows in the underlying data source.
• Good at writing complex SQL Queries in Teradata to perform Data Validation and Graph validation to make sure test results matched back to expected results based on the user needs.
• Hands on experience in Project Migrations between DEV / UAT & PROD environments.
• Experienced in Enterprise Manager Setup & Statistics Report Development.
• Experience in developing Security Filters, Access Control Lists, Security Roles and assigning privileges.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, caching, security and scalability issues suited for Teradata.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services.
• Extensively worked on performance tuning to reduce the run time of Microstrategy reports.
• Extensively used Microstrategy Visual Insight to create reports and dashboards using the data stored in Hive Tables by connecting through Hortonworks Hadoop, Amazon Web services EC2/S3.
• Extensively used Hue application to run HIVE and Cloudera Impala queries for unit testing.
• Extensively used Hadoop Map Reduce Job tracker to monitor the jobs.
• Created customized reports using various chart types like text tables, bar, pie, Heat maps, line charts, Area charts, scatter plot, dual combinations charts in Tableau.
• Developed views using advanced calculations like filters, Parameters, Actions, Table calculations, Logical calculations, date calculations, and Trend Lines.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in modeling and developing logical/physical data models using entity - relationship modeling tools like ERWIN.
• Experience in performing System, Functionality, User Acceptance, Integration and Regression testing.
• Strong knowledge and understanding of SQL and ability to write SQL queries.
• Able to handle different projects concurrently and Lead experience.
• Good Working Knowledge in Agile Project management (Scrum process).

TECHNICAL SKILLS

BI Tools: Microstrategy 8.x, 9.x,10.x Tableau 7, 8.x.

Databases: Teradata 13, 14, Sybase IQ, Netezza, Oracle 10g, Oracle Exadata, SQL Server2008, MS Access

Big Data: Hortonworks Hadoop, Amazon Web services EC2/S3.

DataModeling Tools: ErwinR8

Scripting: Python, Windows Powershell

Operating system: Windows98/2000/XP/7, Windows Server2003, Linux/Uinx

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

Microstrategy Architect

Responsibilities:

• Worked as part of an agile team and participate in backlog grooming and sprint planning sessions
• Extensive use of Rally as SDLC Agile management tool
• Create technical user stories based on the business requirements and acceptance criteria
• Develop technical design based on business requirement documents which include module definition and mapping documents.
• Played an important role in coordination with the entire team and managing the time estimates for the project.
• Mentor the team by providing technical solutions
• Develop data mapping documents of reports to gain better idea of business requirements
• Responsible for setting up the Microstrategy project and database instance configurations
• Create transaction services documents to enable write back functionality to the tables
• Create business process approval using transaction services to push data to upstream applications
• Write stored procedures for the write back functionality of reports from Microstrategy
• Create Schema objects, Public objects, and Configuration objects
• Build objects like Attributes, facts, hierarchies, Drill maps, Reports, filters, metrics, prompts, consolidations, custom groups and Documents based on schema objects.
• Develop dashboards that use selectors and panel stacks
• Develop reports and trained users on how to use them with Visual Insight
• Design and develop complex filters for various complex reports with advanced qualifications involving pass-through functions
• Create Ad Hoc reports using object prompts
• Train users on the various analytical features in Microstrategy
• Create Freeform SQL reports
• Create trending reports with Month over Month and Quarter over Quarter data
• Used several MicroStrategy features to fine tune the reports. Worked with Very Large Database (VLDB) Properties at different levels like report and metric to tune the report to get desired results.
• Created reports using Intelligent Cubes.
• Extensively involved in troubleshooting the MicroStrategy Objects like Reports, filters, metrics, consolidations, custom groups, prompts and templates.
• Responsible for object migration across environments
• Responsible for creation of user groups and users
• Estimate and coordinate the testing efforts for version/server upgrade
• Impact analysis and assessment for all the downstream reporting applications
• Provided continuous support for the project team
• Involved extensively in troubleshooting and resolving all outstanding issues.

Environment: Microstrategy 9.4.1,10.4 Oracle 10g, Oracle Exadata, Windows 7

Confidential, Minneapolis MN

Microstrategy Consultant

Responsibilities:

• Gathering requirements and understanding the source systems to implement DW/BI.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Extensively worked on Logical Data Modeling.
• Created logical views in Microstrategy for complex report creations situations.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Created Intelligent Cubes to enhance the performance of the reports and dashboards.
• Worked on Distribution Services enabling the delivery of reports, dashboards and documents to History Lists, email addresses and file servers.
• Extensively worked on achieving the performance using In-Memory BI, Improving Dashboard Performance, Improving Query Performance, Improving Caching Performance and Project Tuning.
• Handling and documenting the releases happened in the Project.
• Testing reports thorough MicroStrategy web to verify that reports are migrated properly from development to testing and Production.
• Enabled the UAT team by designing user acceptance test cases accommodating all the real life scenarios and endued the testing team for validating and testing the application.
• Prepared User guide documents, Design Documents and Unit test case documents.

Environment: Microstrategy 9.3.1, Teradata 14, Windows 7

Confidential, Oakbrook, IL

Technical Lead

Responsibilities:

• Gathering requirements and understanding the source systems to implement DW/BI.
• Data Analysis and providing recommendations to higher management.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators (KPI).
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and
• Design process for various Sources and Targets.
• Developed and reviewed SQL queries to validate data.
• Using Tableau extract to perform offline analysis.
• Blended data from multiple data sources by using linking feature in Tableau Desktop.
• Developed views using advanced calculations like Table calculations, Logical calculations, date calculations, and Trend Lines.
• Developed Views and interactive Dashboards using Parameters, Filters, Actions, Bar/Bullet/Dual Axis charts, Area/Geo/Heat maps, scatter plots/Bubble Charts etc., in Tableau Desktop.
• Developed multiple Views and combined them into Dashboards for interactivity by providing
• Quick Filter and Parameters for further data drilling capability.
• Creating Users, Groups, Projects, Sites, and Permissions in Tableau Server.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Providing training to Business users in using Tableau.

Environment: Tableau 7, 8.x., Teradata 14, Horton Hadoop Hive, Amazon EC2/S3, Windows 7

Confidential, Oakbrook, IL

Technical Lead

Responsibilities:

• Participating in meetings and interactions with Confidential ’s team for status updates, discussions for business requirements
• Requirements Gathering & analysis for enhancement of Reports using Microstrategy.
• Creating technical/design specification’s to be used for development/coding for Break fixing
• Microstrategy Report analysis.
• Analyzing the business logic of the application.
• Reporting or Escalation of Issues/Concerns /Achievements related to the project.
• Responding data related queries raised by end user.
• Suggestions provided for performance improvement.
• Break fixing critical production issues (Reports) as well as data issues.
• Change management process to migrateMicroStrategyprojects and objects between QA, UAT, andProduction environments by creating and applying packages and undo packages for roll backprocedures.
• Automating the user reports for the client so they have data available to do their analysis on a timely and efficient manner.
• Implement user level security, object security, user roles and groups, create, modify and delete users, govern thresholds, set up distribution services using Narrowcast Server, install and configure MicroStrategy Desktop.
• Creation and maintenance of report schedules using Distribution services and Narrowcast server.

Environment: Microstrategy 9.3.1, Teradata 13, Windows 7

Confidential, SFO, CA

Programmer Analyst

Responsibilities:

• Gathering business requirements, established functional specifications, translated them to design specifications.
• Participating in Sprint meetings with QA, DB teams, Product Manager, Project manager etc.
• Used MicroStrategy Desktop to generate MSTR Reports.
• Identified and Created Application objects like Metrics, Prompts Filters, Custom Groups, and Consolidations using Micro Strategy Desktop.
• Identified and Created Schema objects like Attributes, Facts for the report development using MicroStrategy Desktop.
• Developed Dashboards for easy analysis of the data.
• Created ad-hoc reports and report templates for end users.
• Using Object Manager promoted the objects from Development to Testing and using package in 9.x.

Environment: Microstrategy8.x/9.x, Sql Server 2008, Sybase IQ, Windows 2003 Server

Confidential, SFO, CA

Programmer

Responsibilities:

• Gathering business requirements, established functional specifications, translated them to design specifications.
• Participating in Sprint meetings with QA, DB teams, Product Manager, Project manager etc.
• Used MicroStrategy Desktop to generate MSTR Reports.
• Identified and Created Application objects like Metrics, Prompts Filters, Custom Groups, and
• Consolidations using Micro Strategy Desktop.
• Identified and Created Schema objects like Attributes, Facts for the report development using
• MicroStrategy Desktop.
• Developed Dashboards for easy analysis of the data.
• Created Templates to maintain a standard interface for the reports.
• Created ad-hoc reports and report templates for end users.
• Using Object Manager promoted the objects from Development to Testing and using package in 9.x.

Environment: Microstrategy8.x, Netezza, MS SQL Server, Windows 2003 Server