SUMMARY:

• 7+years of experience as Data warehouse/Business Intelligence Consultant.
• Having good experience in Retail, Finance and Health care Domains.
• Experience on MicroStrategy Project Design and Implementing MicroStrategy Projects 9.X, 10.X
• Expertise in Creating Schema Objects (facts, attributes, Hierarchies, Transformations)
• Expertise in Developing User Objects (filters, prompts, metrics, Custom Groups, Consolidations, Searches) to develop Documents and reports.
• Created Complex Dashboards and mobile Dashboards.
• Created Intelligent Cubes for improving the Performance.
• Expertise in using Pass - Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Expertise in creating Dashboard Reports to view personalized reports based on user requirements. Expertise in creating Hyper Links in Documents.
• Expertise in Administration tasks like creating user accounts, assigning privileges and Security Filters.
• Good in report developing, testing, deploying reporting solutions, scheduling the reports in MicroStrategy and manage the application’s users, groups, and integrations with active directory.
• Expertise in Migration of MicroStrategy Environment from 9.3.1 to 9.4.1
• Expertise in Using Administrative tools like Object manager, Command manager, Integrity manager and Enterprise manager
• Exposure in dealing with variety of Databases like Teradata, Oracle, Netezza, Sql Server
• Excellent knowledge and experience in creating Star and snowflake Schema.
• Strong knowledge and understanding of SQL and ability to write SQL queries.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Excellent team player with good analytical, communication and interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence Reporting Tools: MicroStrategy 9.X/8.X (Desktop, Architect, Web, Mobile, Office Narrowcast Server, Intelligence server)

Databases: Teradata 13.1/14.1, Oracle 10g/9i, Netezza, Sql Server

Languages: SQL, PL/SQL, XML, HTML, C, C++

Operating Systems: Windows XP/NT/2008/2003, UNIX, LINUX

Tools: and Utilities:: SQL Assistance, Data Stage, Talend, Toad, ERWIN, SQL Developer, SQL Loader, Query Analyzer.

PROFESSIONAL EXPERIENCE:

Sr. MicroStrategy Developer

Confidential, Atlanta, GA

• Experience in Analysis, Design, Development, Testing and Implementation (all phases of software development life cycle - SDLC).
• Designed the MicroStrategy Project Schema/Architecture and involved in suggesting changes to the Logical Data Model as per the Business Requests and implementing the same in the MicroStrategy Project Schema.
• Created attributes, facts, hierarchies and transformation objects as part of the development requirement for project.
• Ensured proper relationships were established between the attributes to avoid any improper SQL query joins.
• Created reports using Prompts, Filters, Advanced filters, Custom Groups and Consolidations.
• Developed Dashboards that provide users a highly graphical, summary view of key metrics.
• Created new and innovative dashboards based on the latest version.
• Have used various Visualizations for Dashboard reporting.
• Extensively used Report Services to generate Documents for exporting to Excel & PDF.
• Created Intelligent ICubes for Improving the performance.
• Performance Tuning of Reports and Dashboards at MSTR and DB Level
• Automated ICubes refresh based on ETL Jobs using Autosys Scheduler.
• Played a key role in User Acceptance Testing of the reports.
• Tested all the reports by running queries against the warehouse-using SQL Developer.
• Used Distribution Services to deliver reports directly to business users through Email & History List.
• Worked with Object Manager to migrate objects from lower environments to higher environments.
• Provided technical walk through to various stake holders.
• Coordinate with ETL and Data Modeling team to ensure all the requirements are met.

Environment: MicroStrategy 10.x (Architect, Developer, Object Manager,), Informatica Power Center, Oracle.

Sr. MicroStrategy Developer

Confidential, Sacramento, C.A

• Involving in the design and development of logical and physical schema.
• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables such as reports, dashboards and visualizations.
• Worked as a MicroStrategy Architect and created best suited solutions to the existing system.
• Created different Schema Objects like Attributes, Facts, Transformations, and Hierarchies by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets and MicroStrategy Visual Insights.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Using Auto Prompts filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Worked with end users along with Business Analysts to build reports and dynamic dashboards.
• Worked with the DBA & ETL Team on issues of database performance and security.
• Prepare opportunity analysis report and business modeling for priority basis.
• Responsible for ensuring quality and standard in all the research activities.
• Determines which analytics approaches are best-suited for a particular desired result.
• Conducted Data validation testing to ensure data quality.

Environment: MicroStrategy 9.x, 10.x (Architect, Developer, Object Manager,), Informatica Power Center, SQL Server, Sales force.

MicroStrategy Developer

Confidential, Irving, TX

• Worked with business analysts to baseline the reporting requirements.
• Worked with data modeling team on the dimension model to close out the gaps in the model to best use the underlying tables needed for BI layer.
• Worked with data architects on data needed for testing the reports and dashboards.
• Extensively worked with MicroStrategy architect to develop schema objects such as, attribute, facts, hierarchies, consolidations and transformations etc.
• Extensively used MicroStrategy Desktop to develop application objects such as reports, metrics, filters, prompts, custom groups etc.
• Created drill maps for end users to drill down and recover data.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.
• Involved in Informatica development besides MicroStrategy role
• Involved in troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Designed and Developed MicroStrategy Dashboards using customized Widgets.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Worked extensively with Business Analyst to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.

Environment: MicroStrategy 9.3.1 & 9.4.1, Informatica, Oracle 11g, SQL Server 2008, Main Frames, Windows.

Confidential

MicroStrategy Developer

• Participated in the development and implementation of complex MSTR Reports using MicroStrategy Product suite.
• Created MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and Architect like Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution by using Cube Services.
• Used SQL tuning techniques to marry MicroStrategy Schema & Teradata view layers for better performance
• Hands-on development of complex dashboards & reports using Multisource option.
• Created Dashboards with panel stacks, grids, graphs, widgets both in flash and interactive modes.
• Performed Regression testing of the core reports using Integrity Manager Post deployment.
• Architected objects and developed strategic reports integrating multiple country data for International Business groups
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Deployed Custom Restaurant Group & Custom Item Group functionality using Filters, Prompts & search objects functions.
• Involved in performance tuning of MicroStrategy reports, by optimizing the SQL using VLDB properties.

Environment: MicroStrategy 9.4.1/9.3.1 (Administrator, Architect, Desktop, Object Manager), Teradata 14.10, SQL Server, Talend 5.6, Windows XP Professional

MicroStrategy Developer

Confidential

Responsibilities:

• Application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the Micro strategy objects necessary for the deliverable.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Attended weekly project and team meetings and provided status on the assigned tasks.
• Created project plans for development of MicroStrategy projects.
• Extensively used INFORMATICA Power center 8.6 client to extract data from sequential files, Oracle databases and loaded into a single data warehouse repository in SQL Server.
• Developed PL/SQL Business Functions, which were used with MicroStrategy Reports.
• Designed and translated Logical Data Models into various Physical Warehouse Schemas.
• Partnering with our business clients to understand the business analysis to be performed and subsequent required reports.
• Wrote Stored Procedures to encapsulate Business processes.
• The Projects in Project Sources were connected to the Data warehouse and Metadata Repository through a 3-Tier Architecture involving MicroStrategy Intelligence Server
• Checked all the reports available in previous project, Scan data were developed with same or more functionality in EDW.
• Experience in using Teradata utilities such as Fast load, Multi load and Fast Export.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Analyzed the user requirements and project specifications to identify entities.
• Implemented infrastructure and software architecture modifications, best practices, and naming standards resulting in quicker delivery to the business and accelerating the software development lifecycle.

Environment: MicroStrategy (Desktop, Intelligence Server, Web), SQL Server 2000 and Windows.