Summary

• Nine years of IT experience in software designing, coding and implementing with major focus on Business Intelligence tools, Data Warehousing and Database Applications.
• Excellent exposure to software development life cycle SDLC .
• Experience in user training and creation of accurate documentation.
• Experience in developing Views , Dashboards publishing them using tableau server Tableau Desktop, Server
• Good Knowledge in Database development skills like SQL, PL/SQL, stored procedures, stored functions, packages, and triggers.
• Good experience in working with large databases like Oracle, TeraData, Netezza with MicroStrategy Suite.
• Experience in using VLDB properties for performance tuning and also worked with DBA in troubleshooting.
• Experience in using Object Manager, Enterprise Manager, and Command Manager.
• Experience in developing Dashboards Scorecards for iPad and iPhone.
• Expertise in developing Scorecards Dynamic Dashboards and good experience in using Report Services.
• Expertise in creating and integrating MicroStrategy reports and objects like Attributes, Facts, Filters, Metrics, Prompts, Templates, Consolidation and Custom Groups .
• Expertise in developing Schema objects and Application objects.
• Good Understanding of Logical and Physical Models
• Strong in Data Warehousing Concepts and good knowledge in ETL process
• Strong experience in designing, building and deploying MicroStrategy reports and dashboards using different databases.
• Proficient experience using MicroStrategy 9.x/8.x product suites including MicroStrategy Desktop, Web, Intelligence Server, Architect, Administrator and Narrowcast Server
• Over 8 years of experience with Business Intelligence tool Micro Strategy, in Sales and Retail business area.
• Strong business and analytical skills including direct support of end user/power user reporting
• Involved in various business operations and helped the organizations to achieve cost-effective production with increased quality, efficiency and satisfied customer service.
• Expertise in gathering requirements, from the business users and translating Business needs into end-user applications.
• Worked closely with the Administrator and DBA resolving issues
• Good experience in training the users and helped them by resolving the issues.
• Highly motivated with the liability to work effective with teams as well as independently.
• MicroStrategy Certified Report Developer 9.0.1 ,8.0.1
• MicroStrategy Certified Project Designer 9.0.1 ,8.0.1
• Technology
• OLAP Tools : MicroStrategy 9.3/9.0.2/8.1.0
• Architect, Desktop, Web, Object Manager, Administrator, Narrowcast Server, Mobile Server iPad, iPhone , Tableau 8/7 Desktop, Server
• ETL Tools : Informatica 6.2, Data Stage
• Databases : Teradata 12/13, Oracle 8i/9i/10g, DB2, Netezza
• Languages : SQL, PL/SQL
• Tools : Visual Basic 6.0, Control-M
• Operating Systems : Windows 7/XP/2000/NT, Linux
• Others : HTML 4.0, DHTML, XML, VB Script, Java Script

Professional Experience

Confidential

Sr.MicroStrategy Consultant

Roles and Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Developed architectural framework for MicroStrategy components.
• Designed a Snow Flake Schema to fit reporting, query and business analysis requirements.
• Coordinated with clients to analyze business needs.
• Prepared technical and functional requirements for MicroStrategy architecture.
• Involved in design and development of semantic layer and view definition which supports schema objects in architect.
• Worked closely with Data Architects to provide business inputs and to make sure the structure is setup as per the requirements.
• Created MicroStrategy reporting semantic view layer for better usability of data columns.
• Extensively developed MicroStrategy Schema objects and Application objects.
• Extensively worked in developing complex Dashboards, Report Service documents according to Business Requirements
• Designed MicroStrategy Schema objects and Application objects by creating Facts, Attributes, hierarchies, reports, filters and templates using MicroStrategy Desktop and Architect.
• Extensively worked on creating Metrics, Derived Metrics and Filters for Complex Reports.
• Expertise in using SQL Engine Bypass Functions like Apply Simple and Apply Comparison.
• Fine-tuned the SQL's by running the Explain Plan and making use of Indexes.
• Modified the auto-generated SQL according to the reporting needs using appropriate VLDB settings.
• Created advanced level metrics, prompts and transformations for the project.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Created links on metrics to open up a new detailed reports when clicked on it.
• Used apply functions to execute the database specific function in the metrics and filters.
• Used sections in the report services documents to create related reports and printer-friendly documents.
• Extensively created packages to migrated objects from one environment to another by using object manager.
• Worked with offshore and onsite teams to validate the requirements and assure user acceptance, to determine the technical solutions for the applications.
• Identified problem areas and provided corrective actions
• Assisted in building and deploying MicroStrategy components on web and mobile. .
• Trained business users on the major functionality of dashboards and reports.
• Played a key role in supporting business users and end users to provide solutions on the major functional and data issues
• Involved in the Defect fix of Post-Implementation of the Reports.
• Converted MicroStrategy reports to Tableau views and dashboards
• Created more interactive dashboards using Tableau.

Environment: MicroStrategy 9.3 Desktop, Architect, Web, Object Manager, Administrator , Tableau 7.0 Desktop Server , Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL , Linux

Confidential

Roles and Responsibilities:

• Involved in design and development of MerchLink Analytics shared web portal for Merchandizing users who access various key area Home, Financial, Category, Supplier and My Reports using MicroStrategy Dashboards.
• Worked closely with business teams for better understanding of their needs and also the business processes.
• Gathered requirements, analyzed, designed, coded and then implemented the solutions for merchandising applications.
• Worked closely with Data Architects to provide business inputs and to make sure the structure is setup as per the requirements.
• Created MicroStrategy reporting semantic view layer for better usability of data columns.
• Extensively developed MicroStrategy Schema objects and Application objects.
• Created Intelligence Cubes for better performance and rendering gigabytes of data into the dashboards
• Extensively tuned Intelligent cubes for the better performance of the Dashboards and Reports
• Created complex level dashboards which includes hundreds of objects and containers to render in flash mode
• Created dashboards and related reports for the Enterprise level applications built at Home Depot for iPad and iPhone devices
• Created complex and compound metrics to get the required result as per the business requirements.
• Created complex time filters for the trend graphs to work static with desired time period.
• Created Base formulas Templates as a best practice.
• Implemented the Object prompts to pass attributes dynamically through the dashboards depending on the level of the user.
• Created advanced level metrics, prompts and transformations for the project.
• Effectively used the VLDB settings for Join types, Max rows, Query optimization etc.
• Created links on metrics to open up a new detailed reports when clicked on it.
• Used apply functions to execute the database specific function in the metrics and filters.
• Used sections in the report services documents to create related reports and printer-friendly documents.
• Extensively created packages to migrated objects from one environment to another by using object manager.
• Worked with offshore and onsite teams to validate the requirements and assure user acceptance, to determine the technical solutions for the applications.
• Trained business users on the major functionality of dashboards and reports.
• Played a key role in supporting business users and end users to provide solutions on the major functional and data issues.

Environment: MicroStrategy 9.0.2 Desktop, Architect, Web, Object Manager , Tableau 7.0 Desktop Server , Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL , Linux

Confidential

Roles and Responsibilities:

• Worked with the Source Systems to have a clear understanding of the data flow and interacted with the users to collect the business requirements.
• Created the requirements documentation for the MicroStrategy Projects and also documented the requirements in MicroStrategy Environment.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• Used Advanced Prompts, Non-Aggregately Metrics, Transformation metrics and Level Metrics for complex reports.
• Created several base formulas using existing facts in MicroStrategy Desktop that can be reused to build number of Metrics.
• Customized reports, documents and deployed them to MicroStrategy Narrowcast Server.
• Worked on MicroStrategy Narrowcast to deliver the Weekly and Monthly Reports.
• Generated the Reports, which includes the public and schema objects using the MicroStrategy Components.
• Developed Customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy.
• Desktop with features of Drilling options drill down, drill up and drill anywhere .
• Performed the administration tasks like Tuning, Caching, specifying Query Governing, Thresholds, and Report Optimization.
• Performed testing of all reports for the final deployment.

Environment: MicroStrategy 9.0.2 Desktop, Architect, Web, Object Manager , Tableau 7.0 Desktop Server , Teradata 13.10, Ab Initio, HP Quality Center 10/9, SQL , Linux ,

Confidential

Roles Responsibilities:

• Actively took part in the brainstorming sessions to understand business process.
• Involved in documenting the business process by identifying the requirements.
• Involved in making training recommendation and provided tech training to the power users.
• Lead the project and coordinated with onsite and offshore team

Involved in MicroStrategy Intelligence Server performance monitoring, creating log files and managing cache expiry times.

• Created required views based on the requirement while creating the schema objects.
• Involved in MicroStrategy Architectural Design, Developed Schema objects and Application objects
• Developed Static and Ad-hoc reports using Prompts, Metrics, Filters, Custom Groups, Consolidations and Transformations.
• Created interactive Dynamic Dashboards and Scorecards for different level of users with drill down capabilities.
• Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics.
• Created different Transformations for comparison with the offset data.
• Prepared Unit Test cases for the Reports Developed.
• Ensured deliverables are prepared to satisfy the project requirements, cost and schedule
• Provided Annual and quarterly benchmark statistics
• Providing technical support troubleshooting report design monitor system usage and proactive troubleshooting
• Optimized reports and Dashboards to improve the performance.

Roles Responsibilities:

Confidential

Environment: MicroStrategy 8.0.1 Architect, Desktop, Web , Teradata, SQL, DataStage

• Responsible to build Schema and Application objects.
• Coded test SQLs and analyzed results
• Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics.
• Created Advanced Metrics Conditional, Level, Rank and Transformation Metrics .
• Written complex SQL queries against the database while Unit testing.
• Worked on the performance tuning of the MicroStrategy reports and dashboards after implementation.
• Extensively developed Dashboards and Scorecards for visualization.
• Involved in Testing and Tuning of reports.
• Involved in documentation of MicroStrategy Objects Process flow.
• er of office furniture, personal computers, printers and consumer electronics. They believe in selling recycled and eco-friendly products. This project builds Corporate Data to suit requirements of Data warehouse for providing sales analysis and purchase analysis for taking business decisions by identifying key financial metrics like amount sold, quantity sold and revenue.

Environment: MicroStrategy Web, Informatica, Oracle

Confidential

Environment: Visual Basic, Oracle, PL/SQL

Roles Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables
• Modified and updated existing custom forms to adapt to new database schema
• Created SQL scripts for conversion of legacy data including validations and then load it into the tables
• Created descriptive flex fields as per the user requirements
• Handling errors using Exceptions.