SUMMARY:

• Over 11+ years of hands on experience with Business Intelligence (BI) Project Development and Implementation Using MicroStrategy 10.x/9.x/8.x product suites
• 3 years of experience in analysis & testing with emphasis on Black Box testing, ETL testing, Backend Database testing, Data testing, functional testing, GUI testing, system testing, regression testing, load and performance testing.
• Strong experience using MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Object Manager, Command Manager, SDK, Report Services)
• Involved in Projects Full Life Cycle Development of Data Warehousing, Project Planning, Business Requirement Analysis, Data Analysis, Logical Data Modeling, setting up Physical Schema, Data Marts, OLAP, Reporting and Security
• Extensively worked in creating Story cards, gathering requirements for Interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements and Agile software development
• Worked with very complex data models for reporting in BI environment with multi - dimensional data.
• Expertise in working on Direct Project Source (Two-Tier) and Server Project Source (Three-Tier)
• Good Experience in Creating Schema Objects which include Facts, Attributes, Hierarchies, and Transformations to develop User Objects
• Good Knowledge in Developing Application Objects such as filters, prompts, metrics, Custom Groups, Consolidations, Drill Maps, Templates, Searches to develop documents and Reports
• Hands on Experience in Creating Documents from multiple Datasets like Map Application Diagram, Grid and Graph
• Capable of verifying MicroStrategy reports by writing complex SQL statements with joins, aggregate functions, and filter & search criteria to verify the integrity and correctness of the report outputs
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi-dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Expertise in Creating Hyper Links in Documents and Drill Reports
• System Optimization, performance monitoring and tuning experience in Multiple BI applications.
• Extensively worked, in Creating Interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements
• Fine Tuning of the MicroStrategy Reports using Data Mart Reports, Aggregatable Tables and Intelligent Cubes and involved in troubleshooting MicroStrategy Reports, by optimizing the SQL using VLDB
• Experience in working with MicroStrategy Multisource
• Experience in building Data Model & interpretation
• Proficient in using variety of Relational Databases like Teradata, Oracle, DB2, and SQL server
• Strong SQL skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support
• Specialized in Developing Stored Procedures, Functions, Packages and Database triggers using Oracle, SQL and PL/SQL
• Designed interactive and visually stunning Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Micro charts Widgets and Grid/Graph combinations
• Ability to use ERWin for Dimensional modeling and Entity - Relationship Modeling
• Experience in understanding Business Applications, Business Dataflow and Data relations
• Ability to quickly master new concepts and capable of working in-group as well as independently
• Actively involved with business users and stake holders gathering business requirements
• Excellent multitasking capability, efficiently planning and prioritizing projects with strong technical and business management skills
• Excellent communication, presentation, leadership and interpersonal skills

TECHNICAL SKILLS:

Languages: Mainframe, Visual Basic, Cold Fusion, JavaScript, Java, JSP, SAS, XML

Databases: RDBMS Oracle 9i/10g/11i/12c, MS Access, Netezza, Teradata, MS SQLServer 2000/2005/2008, DB2, DB2 UDB

Operating System: Windows, UNIX/Linux, MVS

Querying Tools: SQL Developer, TOAD, Squirrel, QMF, SPUFI, Dev Partner, Rapid SQL

ETL Tools: Data Stage, Informatica

BI Reporting Tools: Micro Strategy 10.x/9.x/8.x/7.x (Desktop, Web Server, Mobile,Intelligence Server), Tableau 10.0, Business Objects, Cognos

Microsoft Tools: MS-Office, MS Project, MS Visio

Automation Tools: HP Mercury Tools (QTP, QC), IBM Rational Tools (Robot, ClearCase,ClearQuest, ReqPro, DOORS)

PROFESSIONAL EXPERIENCE:

Confidential, Reston VA

Sr. MicroStrategy Developer

Responsibilities:

• Gather requirements by interacting with senior managers and users for design of reports
• Participate in BI team meetings to discuss the user requirements
• Created logical data models to recognize source tables and columns, to build MicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project
• Create Complex grid reports with drill capabilities
• Generate grid and graph reports by using appropriate Facts, Attributes, Compound metrics, Level Metrics, Advance filter
• Created reports with various object prompts to generate various Ad-hoc reports
• Design Interactive Dashboards in MicroStrategy Web to assess company performance and monitor the overall goals of the business.
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and Business analysis requirements.
• Create standardized reports (Canned reports) and Report Services documents for users.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports
• Used Transformations (table based, formula based) for comparative reports
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the Systems stable
• Responsible for design and development of Narrowcast Services, Schedules, Subscription sets, documents for narrowcasting reports to file server via email
• Involved in Production support, trouble-shooting and fixing of reports performance Issues
• Troubleshoot and resolve data quality, technical, and performance related issues within reports and metrics within MicroStrategy.
• Involved with Users to test the functionality of the reports and check for data discrepancies by comparing the data from the reports to the database
• Participated in user training on Web Professional and data execution in the Web environment, and also documented the general design of the reports
• Proficient at managing projects through entire systems development life cycle, including creating timely based status reports and leading status meetings

Environment: MicroStrategy 10.1/10.2 (Architect, Intelligence Server, SDK, Enterprise manager, Web, Web Universal and Narrowcast server, Desktop), Report Services, SQL Server 2005

Sr. MicroStrategy Developer

Responsibilities:

• 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 troubleshooting MicroStrategy Web Reports, optimizing the SQL using the VLDB Properties.
• Took part in design and development of Data marts and integrating them with Data warehouse.
• Worked on Building Multidimensional Model, like multiple data sources including data warehouses, data marts, operational databases, and departmental databases.
• Worked on Creating Security Roles, MicroStrategy User Groups and Users, assigning security roles to Users and Groups.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• 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.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• 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/9.4(Desktop, Intelligence Server, Web, Agent), Object Manager, Teradata, SQL Server, Windows, Actuate eReport Designer Professional, Oracle10g, Erwin, Informatica

MicroStrategy Developer

Responsibilities:

• Currently involved in requirement gathering, design, implement and test a new EDW being developed by the data warehouse team
• Working on implementing MicroStrategy Schema Objects and Application Objects like Attributes, Hierarchies, Filters, and Metrics using MicroStrategy Desktop to create reports and dashboards for the business users
• Extensively working in delivering reports through MicroStrategy Office. Delivered formatted and conditional formatted reports through MicroStrategy Office
• Involved in troubleshooting MicroStrategy Reports, by optimizing the SQL using VLDB properties for creating complex reports using Advanced Filters, Compound Metrics, Conditional, Transformation and Level Metrics
• Current responsibility involves managing and maintaining the MicroStrategy Intelligence
• Server and MicroStrategy Web Server, also providing administration tasks like User Creation, Creating Security roles, Access Control Lists (ACL)
• Used Object Manager to migrate the MicroStrategy objects from Dev/QA environment to Production environment

Environment: Micro Strategy 9.1/9.2.1m/9.3 (Desk top, Object Manager, WEB, Enterprise Manager), Oracle, DB2, MS Visio, Windows 7.

MicroStrategy Developer

Responsibilities:

• Participate in the end user meetings to obtain the business requirements for creating reports
• Assist DBA’s in creating views and making changes in the Database as required for the
• MicroStrategy Environment
• Work on MicroStrategy Reports by creating Custom Groups, Attributes, Hierarchies, Filters, Metrics, Compound Metrics and Filters for complex reports
• Develop Report Service Documents and dynamic dashboards using new data sets and
• Widgets
• Implement proactive, personalized information delivery services using Micro Strategy Narrowcast Server
• Created different objects that define Narrowcast Server services, including content Information Objects, Documents, Subscription Sets, and Schedules
• Troubleshoot MicroStrategy prompt, filter, template, consolidation, and custom group objects in an enterprise data warehouse team environment
• Optimize the performance of the reports using the VLDB properties in Micro Strategy
• Co-ordinate with off-shore development team, delegating tasks and providing directions for fast deliverables
• Coordinate with business, data modeling and ETL team at various levels for stabilization of reports
• Worked with Business end users to conduct regular demos for report functionality in MSTR Web, MSTR Office, Power Point and Excel
• Work with testers and business users to ensure completeness and accuracy of reports data

Environment: Micro Strategy 9.1/9.2.1/9.3 (Desk top, Object Manager, WEB, Enterprise Manager, Narrowcast), Oracle, DB2, MS Visio, Windows 7

MicroStrategy Developer

Responsibilities:

• Involved in analysis, design and construction of the Metadata.
• Designed and developed logical data model for MicroStrategy reporting environment.
• Identified source tables and columns required to create MicroStrategy project.
• Improved the performance of the reports by changing VLDB properties.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Developed different transformations which help business users to compare present data with previous year’s data in reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Modified the information displayed on the Prompt Question page by changing the layout definition file used by the prompt style that is applied.
• Performed Daily Checks for Job Monitor, user sessions and Cache Monitor to keep the system stable.
• Actively participated in developing Report Delivery Schedules. Modified VLDB Settings to tune the reports for faster execution.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 8.0.3/9.0, Teradata, SQL Server 2005, Windows XP, Erwin

MicroStrategy Developer

Responsibilities:

• Worked extensively in setting up of the Integrity Manager, by setting up the prompt responses provided by the Business users for prompted reports
• Involved in performing a full database backup of the original Metadata repository before the Upgrade
• Used Enterprise Manager Statistics to get the details of every object in a project as well as detailed list of report requirements
• Involved in migration of the Web universal and testing the report execution from Web with the new features added in the new version
• Worked on MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator
• Performed Administration tasks like User Creation, Creating Security roles, Access Control Lists (ACL)
• Worked closely with the QA team to compare the reports present in the production and development environments of the 8.1 version against the reports migrated into the development, QA, Production and DR environments in the 9.x version on the UNIX platform
• Used Object Manager to migrate the MicroStrategy objects from Dev/QA environment to Production environment

Environment: MicroStrategy 8.1.2/9.0 (Administrator, Architect, Desktop, Object Manager, Enterprise Manager), Informatica, Oracle 10g, SQL Server 2005, Erwin Data Modeler, UNIX, Windows NT, Windows

ETL / Automation Test Lead

Responsibilities:

• Analyzed system specifications documents.
• Developed project plans using a top-down approach.
• Document all test cases using TestDirector 7.5.
• Verify the functionality of integrated, multi-environment enterprise solutions using QuickTest Pro 6.0.
• Perform Unit, Integration, System and Regression testing activities.
• Performed manual and automated testing as well as white box and black box testing.
• Bug tracking and defect reporting features of TestDirector were utilized to track, maintain and close Defects.
• Developed automated regression test suites using QuickTest Pro 6.0.
• Involved in Functional, System, Integration, Data Validation, User Acceptance, Scalability, Performance, Stress and Load Testing.
• Performed Load/ Performance testing using LoadRunner.
• Involved in various phases of the Rational Unified Process(RUP).
• Coordinated with development team regarding bug reporting and verifying code fixes.
• Involved extensively in database testing using SQL scripts.