SUMMARY

• 8+ years of extensive work experience in MicroStrategy 7.X/8.X/9.X, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy Agent, MDX Adapter/OLAP/MOLAP Provider, MicroStrategy Enterprise Manager, MicroStrategy Mobile and Narrowcast Server.
• Holds certifications as CPD (Certified Project Designer), CRD (Certified Report Developer),
• Working experience in many industrial sectors like Tele Com, Retail, Health Care.
• Extensively worked on Schema Design creating Attributes, Facts, Hierarchies and Transformations.
• Experience in developing public objects like Metrics, Advanced Metrics, Filters, Advanced Filters, Prompts, Custom Groups, and Consolidations as per the user requirements.
• Worked on Pass - Through functions like Apply Simple, Apply Comparison by using Pass-Through Expressions in MicroStrategy.
• Experienced in creating/using Intelligent cubes, view reports in various reports and dashboards.
• Worked on various VLDB Settings/Properties for performance tuning of reports/dashboards.
• Experience in creation of Dynamic Enterprise Dashboards, Scorecards (KPI’s) using nested panels, report hyperlinks, various Widgets and Selectors for better understanding of Business trends.
• Implemented optimization techniques on different Dashboards and Document Objects using best practices recommended by MicroStrategy.
• Expert in Creating MicroStrategy reports, generic cubes and implementing MicroStrategy projects.
• Tuning of the MicroStrategy reports using Data Mart Reports, Aggregate tables and Intelligent Cubes.
• Worked on Conditional Metrics, Level metrics and advanced prompts for creating advanced reports.
• Knowledge on ER Diagraming, Dimension Modeling, Star Schema and Snowflake Schema.
• Experience following structured software development methodologies - Agile approaches.
• Experience with Business System Support and application support.
• Working closely with ETL developers and other leads during development and support of BI application.
• Expert in Dashboard building using Dynamic Dashboards, Intelligence Cubes, Flash, Express and PDF modes, share point Integration, MicroStrategy Web parts, I - Frames, iPad version etc .
• Provided Solution, developed and deployed MicroStrategy Dashboards on iPad/Mobile.
• Participate in the design, build, release and deployment procedures.
• Highly motivated IT professional with the extremely valuable combination of technical knowledge, interpersonal skills & business acumen.
• Participated in demo sessions and also had hands-on experience with MicroStrategy 10.1.
• Good Team member with the ability to motivate & lead team members, self motivated when it comes to development and task delivery.

TECHNICAL SKILLS

OLAP: MicroStrategy 9.x/8.x/7i/6.0 (Intelligence Server, Desktop, Web, NarrowCast Server, Architect), Business Objects 5.1.4, 4.1.6 (Designer, Business Object, Supervisor, Business miner, Web Intelligence), Tableau, Crystal Reports

Tools: Computer Associate’s ERWIN 3.5.2/4.1, MS Project, MS Excel, MS Word, MS PowerPoint, Visio, SQL*Loader

ETL: Data Stage 5.1, Informatica Power Mart 4.7.1, Power Center 1.7.1

Languages: PL/SQL, SQL, COBOL, C, JAVA, ASP

RDBMS: Oracle 7/8/8i/9i, Teradata (SQL Assistant 6.1), DB2 UDB 7.1, MS SQL Server 7.0/2000/2005 , MS Access

OS: Windows NT, Windows 3.0/3.1/95/98/ XP, UNIX, SCO, Sun Solaris 8.1

PROFESSIONAL EXPERIENCE

Confidential, Overland Park, KS

MicroStrategy Architect /Consultant

Responsibilities:

• Gathering Business requirement from Business Analyst and analyzing the requirement, and developing technical design document.
• Performed Requirement analysis to collect various business measures and attributes to develop a reliable Schema and required Facts and Attributes.
• Extensively worked with MicroStrategy Architect/Desktop to build different kinds of objects like Schema, Public and Application Objects.
• Created different types of schema objects like Attributes, facts, Hierarchies and transformations.
• Worked extensively on creating application objects like Metrics and compound metrics, Filters, Prompts, Custom groups and Consolidations.
• Developing different kind of reports (Grid/Graph) using schema and public objects based on requirement.
• Created reports with various object prompts to generate ad-hoc reports.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties at different levels.
• Developed Documents and dashboard for visualization and for understanding the business trends.
• Created drill maps and enabled drilling for end users to drill and recover data at different geo levels.
• Extensively worked on Report services to create performance dashboard reporting.
• Integrated Visual Crossing map tool with MicroStrategy environment by installing and configuring in Web server.
• Performance improvements in area of MSTR reports, dashboards while running and loading maps on web application.
• Using Object Manager to migrate MSTR objects from one environment to other as part of Production release.
• Created Report results set comparing Sql/Data from different environments by using Integrity Manager,
• To make sure there is no mismatch.
• Responsible for various administration tasks like user creation, Tuning, Caching, scheduling, Report optimization, creating groups and assigning ACL to users.
• Developed iPad version, web version from Safari browser, iPhone and iPad MicroStrategy mobile Apps.
• Used Info views/Information windows on the dashboard panel stacks.
• Developed custom dashboards to Suite for iPad and iPhones.
• Involved in Upgrade of MicroStrategy environment from 9.4.1 to 10.2 on sandbox server.
• Well versed with the new changes in MicroStrategy 10.2.
• Designed and developed a few dashboards for test functionality in MicroStrategy 10.2.

Environment: MicroStrategy 9.4.1 (Desktop, Web, Mobile Applications), MicroStrategy Architect, MicroStrategy Developer, SQL Server, SQL, Teradata, Windows, MS-Access

Confidential, Union, NJ

MicroStrategy Architect /Consultant

Responsibilities:

• Involved in the complete life cycle of the project from gathering business requirements, creating architecture for the business for Canned Reporting and Ad-Hoc reporting for Price Analysis reports.
• Responsible for various administration tasks like user creation, Tuning, Caching, scheduling, Report optimization, creating groups and assigning ACL to users.
• Provided leadership and direction for MicroStrategy portion of project using MicroStrategy, Teradata and Oracle.
• Primary responsibility is to review, update and maintain MicroStrategy related system architecture to build a MicroStrategy suite of applications.
• Transformed requirements into MicroStrategy solutions that efficiently enable expected application, reporting, and analytic capabilities to support the business and strategic initiatives of the enterprise.
• Provided development of integrated MicroStrategy solutions, review and validation of existing reporting and new solutions to ensure continuous accuracy and front end ease-of-use
• Founded opportunities in the areas of user experience as well as innovative ways (R&D) to deliver powerful analytical insight.
• Contributed to the review of test plans, test cases to ensure all requirements are covered and documents are thorough.
• Deployed/migrated product in QA and production environment using Object Manager; served as the subject matter expert for systems in production - helping to ensure a stable, robust production environment
• Trained QA Teams on work and usage of Integrity Manager and effective uses of Baselines for comparison.
• Communicated across a diverse workforce to ensure work transitions effectively without interruption or incident.
• Designed and developed database objects like tables, views and procedures in Oracle and Teradata environments.
• Involved in Customer Support, Maintenance & Performance tuning of the project.
• Demonstrated Complete MicroStrategy Suite (Reports, Dashboards and Report Builder) for end users.
• Interacted with business users on regular basis to know requirements and provide technical assistance regarding problems and help with the tool.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services involving multiple datasets.

Environment: MicroStrategy 9.3 (Desktop, Web, Administration), Integrity Manager, Command Manager, User Manager, Teradata 14, Teradata Studio Express, Teradata Client 13.10, Oracle 11g, Linux, Oracle SQL developer, Windows. DataStage.

Confidential, Raleigh, NC

MicroStrategy Developer/Consultant

Responsibilities:

• Involved in gathering of business/user requirements.
• Architected schema objects such as attributes, facts and transformations.
• Worked with back end Database Administrators to provide requirements for necessary backend tables.
• Worked extensively in MicroStrategy Administration like creation of new users, roles, privileges, shared folders, access controls lists.
• Developed basic and user-specified Metrics (level, conditional, compound).
• Created Consolidations and Custom Groups as per the requirement.
• Used MicroStrategy functions such as Apply Simple and Apply Comparison in metric calculations.
• Developed Filters (relationship, comparison) for complex reports.
• Created drill maps for end users to drill down and recover data.
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
• Involved in upgrade process of MicroStrategy 8.1.2 to 9.0.1.
• Created custom attribute functionalities using OLAP, MOLAP services.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Configured Very Large Database (VLDB) Properties at different levels.
• Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services.

Environment: MicroStrategy 8.1.2/9.0.1 , Intelligent Server, Narrowcast Server, OLAP/MOLAP Services, MicroStrategy Desktop, MicroStrategy Web, IBM DB2, Teradata V2R5/V2R6, Windows XP, Informatica Power Center, SQL Server, ER-Win.

Confidential, KY

MicroStrategy Developer/Architect

Responsibilities:

• Design and Development of MicroStrategy Schema objects like Attributes, Facts, Hierarchies and Transformations using MicroStrategy Architect.
• Developing Deployment procedures, Report/Query profile requirements.
• Developed various Auto Prompts to give end users a choice of different filtering criteria each time they run the report.
• Created several Base formulas (mathematical expressions) using existing facts in MicroStrategy Desktop that can be reused to build any number of metrics.
• Developed scripts for creating, modifying and deleting users, security roles and filters.
• Scheduled the reports, Performance enhancement, and support and resolution issues.
• Expertise in using MicroStrategy Desktop to generate Advanced Reports in grid, graph mode, consisting of Data analysis by combining a template with filters.
• The end-users were able to generate ad-hoc reports by drilling down, within and across dimension or to pre-defined Templates.

Environment: MicroStrategy 8.1.2, Oracle 8i, Ascential’s DataStage, Computer Associates Erwin 4.1 Data ModelerWindows 2000, Siebel, Business Objects, Crystal Reports, DB2.

Confidential

MicroStrategy Developer

Responsibilities:

• Served as MicroStrategy developer for the full lifecycle of the data-warehousing project from reqoirement gathering from business to rollout.
• Involved in Analyzing existing reports in different ordering and billing systems, created the design and development of the reports.
• Analyzed and consolidated similar reports developed using stored procedure, shell script and created design and developed MicroStrategy reports
• Involved in creating Dimensional Model using Erwin
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using MicroStrategy Agent (Desktop).
• Communicated with the business, Data Modeling team and ETL team in various levels for the stabilization of the reports.
• Involved in UAT and stabilize the reports after report demonstration to the business.
• Involved to move the report objects from UAT to Production using Object Manager, created security privileges to users.
• Creation of Project Design and Schema Objects in MicroStrategy Architect.
• Designed and Developed Complex and large MicroStrategy Reports in MicroStrategy Desktop.
• Designed and Developed Dashboards using MicroStrategy Report Service Documents for various products and services.
• Provided training to the users, created documents for the users, involved in customer support and stabilize the report in production environment.
• Writing complex SQL queries in Teradata to meet reporting requirements.
• Creating views and Teradata database using base tables.
• Development of dashboards and scorecards for management reporting using Report Services.
• Monitoring and ensuring of project progress and preparation of Status reports.
• Design and developed Narrowcast Services.
• Created HTML and Excel formatted documents.

Environment: MicroStrategy 8.1 (Administrator, Desktop, Architect, Intelligence Server, Narrowcast Server, Web), Oracle, Toad, Erwin, Informatica 6.2, MS SQL Server, DTS, DB2, Terada, Windows, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Implemented a Database design using Designer/2000 in an Oracle 7.3 environment.
• Designed the database based on requirements of the system.
• Designed the User interface for forms with developer 2000 features.
• Generated necessary reports periodically using Reports.
• Created the database, table spaces, tables, indexes and other database objects.
• Loaded the data into the Oracle database using SQL Loader
• Responsible for performing various database administration duties using advanced querying tools and PL/SQL scripting techniques, Procedures.
• Responsible for troubleshooting various aspects of the client/server architecture in both a UNIX and an Oracle setting.

Environment: Oracle7.3, PL/SQL, SQL, Developer 2000 Forms 4.5, Reports3.0, UNIX and Windows 95