SUMMARY:

• Over 10 years of IT experience in software development, designing and implementing wif major focus on Business Intelligence tools; strong domain knowledge of Health care, finance and retail industries.
• Proficient experience using MicroStrategy 10.x/9.x/8.x/7.x product suites including MicroStrategy Desktop, Web, MicroStrategy Intelligence Server, and MicroStrategy Architect.
• Strong knowledge of data warehouse concepts, design techniques such as Star and Snow Flake schema, multi - dimensional data model, analysis using OLAP, ROLAP, Physical and Logical data modeling.
• Experience in using administration tools like Job Monitor, User Manager, Cache Manager, Object Manager, and Schedule Manager.
• Accomplished System Optimization, Performance Monitoring, Tuning and Data virtualization in MicroStrategy Business Intelligence environment.
• Expert in building complex reports, dashboards and documents, implementing panel stacks, widgets and customized teh web.
• Involved at all stages of teh data warehousing project, setting up teh schema and architecture, developing reports, security and deploying in an agile environment.
• Trained more than 300 business users and end users on Microstrategy tool including generation of reports and dashboards. Trained interns, new hires, and sub-ordinates on Microstrategy Web and Desktop on various dashboards, visualizations, and documents.
• Involved in teh complete Software Development Life Cycle (SDLC).
• Experience in implementing Slowly Changing Dimensions and Strong skills of working wif multiple databases simultaneously like SQL Server 2008/2005, Oracle 10g/9i, DB2, Teradata, and Sybase.
• Excellent communication, interpersonal, analytical and organizational skills.

PROFESSIONAL EXPERIENCE:

Confidential, Owings Mills, MD

MicroStrategy Developer

Responsibilities:

• Gather and analyze reporting requirements and specifications from teh business.
• Design and develop 55 self-service ad hoc reports containing several elements such as attributes, metrics, prompts, shortcuts, filters and search objects using Mictrosrtategy desktop and web.
• Troubleshoot report SQL, analyze data discrepancies, and performance issues.
• Design and develop complex reports, interactive dashboard wif panel stacks, selectors depicting current, month-end and historical data.
• Resolve architecture layer issues, and work wif teh database team on issues at teh physical table layer.
• Troubleshoot user-caused performance issues and recommend efficient prompt answers, or make report modifications to guide teh user toward efficient runs.
• Troubleshoot report performance issues and make suggestions for new or tuned aggregations.
• Create Documents in Grid and Graph mode by using MicroStrategy Report services.
• Work wif teh ETL and DBA for physical layer dependencies.
• Log and resolve any defects, on-teh-fly ad hoc enhancements for client satisfaction.
• Train business users and power users on functionality of Microstrategy reports and dashboards.
• Work in an agile environment wif 3 week sprints

Environment: MicroStrategy 10.4 (Desktop, Web), Oracle, DB Visualizer.

Confidential, McLean, VA

MicroStrategy Developer

Responsibilities:

• Provide proactive support for MicroStrategy and other BI/Analytics applications by resolving issues.
• Develop reports and dashboards to monitor BI applications providing insight on usage patterns and recommend application/system improvements.
• Involved in BI design and development activities, identify risks and recommend risk mitigation plans.
• Designed and developed complex reports, dashboards, and Intelligent Cubes for faster performance and drill through in reports/dashboards.
• Interact wif business teams and other stakeholders to understand and recommend BI solutions to meet diverse, complex business needs.
• Manage and track action items, issues and risks associated wif a suite of applications. Follow up on items wif appropriate parties to ensure their resolutions and/or escalate issues in a timely fashion.
• Set up teh distribution services for distributing teh report output to teh different levels of users.
• Recommend, implement and adhere to industry wide BI best practices and drive for changes to existing processes and/or procedures for teh betterment of teh organization.
• Recommend and establish governance and control around self-service BI/Analytics considering teh evolution of BI industry's best practices.

Environment: MicroStrategy 10.2 (Desktop, Web), Rapid SQL Server, Sybase, Oracle.

Confidential, Irving, TX

Sr. MicroStrategy Developer

Responsibilities:

• Participate in teh software development life cycle and provide expertise in MicroStrategy development.
• Analyze, design and build business intelligence solutions using MicroStrategy platform and databases like Teradata and Oracle.
• Work wif business users to gather business requirements, and convert them into technical specifications.
• Work wif Business Systems Analyst and QA teams to ensure programming code meets business requirements.
• Design and build MicroStrategy project, schema objects, reports, dashboards and documents.
• Perform unit/load testing, deployment and implementation of teh solutions using teh above technologies.
• Generate and implement MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.
• Support existing applications and resolve application issues.
• Set up teh distribution services for distributing teh report output to teh different levels of users.
• Develop impactful reports and dashboards using MicroStrategy Developer and Web

Environment: MicroStrategy 10.3 (Desktop, Architect, Intelligent Server, Web), Object Manager,SQL Server, SQL Assistant,Teradata, Hadoop, Windows 2007.

Confidential, St. Louis, MO

System Analyst - MicroStrategy

Responsibilities:

• Perform customer requirements gathering, requirements analysis, Design, Development, Testing, Presentations of BI Projects.
• Generate and implement MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates.
• Work wif Data Modeler for better understanding of Data source tables and relationship.
• Work extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
• Utilize MicroStrategy Web to offer interactive reporting to teh end users through a web browser.
• Create Complex filters wif advanced qualifications involving teh Pass through functions.
• Involve in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Create Interactive and Dynamic Dashboards in Flash modes for Business Users using Widgets, Panels, Panel Stacks, Selector Controls, etc., and trained business users to best utilize teh advanced features in MicroStrategy reports and dashboards.
• Build wireframes and generated advanced and comparative reports to compare current revenue to last year in grid, graph mode.

Environment: MicroStrategy 9.4.1/10.1 (Desktop, Architect, Intelligent Server, Web), Object Manager,SQL Server, SQL Assistant,Teradata, PL/SQL, LINUX, Windows 2007, Eclipse.

Confidential ., Detroit, MI

MicroStrategy Lead

Responsibilities:

• Performed customer/ business requirements gathering, requirements and gap analysis, Design, Development, UAT Testing, end User Acceptance.
• Used MicroStrategy Web to offer interactive reporting to teh end users through a web browser.
• Supported team in standards, best practices, and methodology throughout teh SDLC, supporting all types of MSTR BI applications; developed schema and public objects, created reports and dashboards.
• Scheduled and delivered reports to business users in desktop and web as per business needs.
• Administered object migration using MicroStrategy Object Manager to move objects among teh Development, Testing and Production environments.
• Created Drilling reports across different wifin teh Hierarchy and other hierarchies.
• Implemented Transformations using comparative reports like revenue dis year to last year.
• Involved in troubleshooting of MicroStrategy Prompts, Filters, Templates, Consolidations, Custom Groups objects in an Enterprise data warehouse team environment.
• Automated and improved existing manual processes and Optimizing teh server platforms using Caching and Scheduling.
• Extensively worked in both Ad-hoc and standard reporting Environments and Involved in creating reports scalable to large volumes of data.
• Designed and developed dashboards on Mobile and iPads.
• Used MicroStrategy Web SDK to customize teh look and feel of teh user interface - cosmetic and workflow changes, worked wif plug-ins, toolbar links, references.
• Converted Tableau reports and dashboards to MicroStrategy; worked on Visual Insights, created Transaction Services reports.
• Created Documents in Grid and Graph mode by using MicroStrategy Report services.
• Set up teh distribution services for distributing teh report output to teh different levels of users.
• Created a wide variety of fully interactive scorecards, dashboards, and enterprise reports.
• Trained business users and end users on generation of reports and dashboards on Web. Trained interns, new hires, and sub-ordinates on Microstrategy Web and Developer on various dashboards, visualizations, and documents.

Environment: MicroStrategy 9.0.1/9.3.1 (Desktop, Architect, Intelligent Server, Web), Object Manager,SQL Server, SQL Assistant,Oracle 10, PL/SQL, LINUX, Windows XP Professional, Eclipse.

Confidential, Phoenix, AZ

MicroStrategy Developer

Responsibilities:

• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
• Responsible for configuring I-server and Project governing settings for performance optimization.
• Created MicroStrategy Users and assigned appropriate security roles, managed connection mappings
• Involved in troubleshooting Microstrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Created comparative reports using Transformations like (TY to LY, Year to date).
• Implemented Intelligent Cube to decrease teh Load on server; used Intelligent Cube Monitor and Cube Advisor to optimized memory use of server.
• Used MicroStrategy Web SDK to customize teh look and feel of teh user interface - cosmetic and workflow changes, worked wif plug-ins, toolbar links, references.
• Created Data Mart and Freeform reports in order to overcome teh Data Model deficiencies.
• Identified Source tables and columns required to create a MicroStrategy project, which references Teradata database.
• Created Interactive and Dynamic Dashboards in Flash modes for Business Users using Widgets, Panels, Selector Controls, etc. and trained BU to best utilize teh advanced features for Dashboards.
• Tested all teh reports by running queries against teh warehouse-using SQL Assistant; also compared those queries wif teh MicroStrategy SQL engine generated queries.

Environment: MicroStrategy 8.0/8.1/9.0, MicroStrategy Agent, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy Architect, Oracle9i, Teradata, UNIX, Windows 2000 Server, Windows XP Professional.

Confidential, Green Bay, WI

MicroStrategy Consultant

Responsibilities:

• Collected teh requirements for teh dashboard from teh business executives and prepared teh prototype.
• Worked wif data modelers and ETL developers to aid in teh design of efficient and robust data structures for reporting and analysis.
• Interacted directly wif business customers to understand their process and information needs.
• Designed and built pixel perfect report service documents and interactive Flash dashboards.
• Created transformations using Transformations by tables for YTD (Year to date), and MTD (Month to date) for Time Series Analysis.
• Created MicroStrategy schema and public objects for generating reports and used MicroStrategy desktop.
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing teh SQL using teh VLDB properties. Resolved teh defects during teh QA and UAT testing process.
• Extensively created filters, facts, Consolidations, Transformations and Custom Groups using MicroStrategy Desktop to generate reports for teh Business analysis.
• Used pass-through functions (applysimple and applycomp) in attributes and filters definitions.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports.
• Created ad-hoc reports by drilling up, down, wifin and across dimensions.
• Created Metrics, Filters, Attribute-to-Attribute qualification, Metric-to-Metric qualification prompts using MicroStrategy for report development.
• Created various Monthly Dynamic Dashboard documents for teh decision makers wif multiple panel stacks, selectors and customized widgets.

Environment:MicroStrategy7.5.2 (Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Oracle, SQL Server, Informatica, IBM DB2, ASP, XSL, HTML

Confidential, Keene, NH

MicroStrategy Developer

Responsibilities:

• Extensive interaction wif teh Database experts to understand teh Source System and efficient translation of technical data to Business terms through self-developed design templates.
• Helped in translating teh requirements of Dimensional and Relational Models and ran scripts for building metadata and defined teh lookup and facts tables for application in teh MicroStrategy
• Interacted wif teh data management group related to teh Physical Structure of teh Data mart, for sizing teh data mart and to add teh data mart into teh integrated data warehouse.
• Developed a customized solution for exporting report data into Excel and Text from Actuate Report.
• Created MicroStrategy schema and public objects for generating reports and used MicroStrategy desktop to build and generate teh advanced reports in grid, graph mode.
• Used MicroStrategy Desktop in creating different reports to meet teh in-house Business Requirements.
• Generated and implemented advanced MicroStrategy Reports concepts by creating projects, Attributes, Hierarchies, Facts, Metrics, Filters, and Templates.
• Extensively used Filters, Facts, Consolidations, Transformations and Custom Groups.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Created Transformations to use in comparative reports like Sales dis year to Sales last year.
• Tested all teh reports by running queries against teh databases. Also compared those queries wif teh MicroStrategy SQL engine generated queries.

Environment: MicroStrategy 7.5/8.0, Desktop, Narrowcast Server, Informatica 6.2, UNIX/LINUX, Window XP, oracle 9i, SQL