SUMMARY

• Over 8+ years of professional experience in implementing Business Intelligence, using Micro Strategy and Business Objects.
• Development experience in MicroStrategy Suite (Intelligence Server, Administrator, Architect and Development (Desktop and Web) and Object Manager).
• Good experience in creating logical tables, attributes, facts, relationship and hierarchies using project creation interfaces (Project Creation assistant, architecture and schema objects editor).
• Comprehensively worked in creating complex reports in MicroStrategy Desktop and integrating MicroStrategy reports and Schema with the Data warehouse.
• Strong experience in designing and developing MicroStrategy Reports, Schema objects,Application Objects, Configuration objects.
• Expertise in creating documents using multiple datasets and on Intelligence cubes. Good in formatting and arranging the objects.Also, having knowledge on dynamic dashboard creation like panel stack, panels and selectors.
• Experience in MSTR dashboard designing and document performance considerations. Good exposure on 9.3.0 component (Narrowcast, User security & management, Object Manager)
• Good experience in MSTR Administration like securities, users and group creation, system monitor, cache(Reports, documents and intelligence cube) and configuration objects(schedules and subscriptions)
• Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases in Oracle 11i, DB2, SQL Server 2000.
• Experience in Microstrategy schema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation and testing.

TECHNICAL SKILLS:

OLAP Tools:Micro Strategy9.0/9.3 (Administrator, Architect, Intelligence Server,

Desktop, Web and Report Services), SAP BO BJ 3.1/4.0, Tableau and BO excel Analysis.

ETL Tools:BODS 4.1 and OWB

Databases:SAP HANA DB, Oracle 11i, SQL Server 2000 and MS Access

Programming Languages:PL/SQL and Java/J2ee

Web:HTML, DHTML and JavaScript

Operating Systems:UNIX, Linux, Microsoft Windows XP and 7, MS - DOS

PROFESSIONAL EXPERIENCE:

Business Analyst

Responsibilities:

• Monitor scheduled reports through Instance Manager
• Deletion of long running reports and/or paused report to maintain load balance
• Monitor the BOXI application servers availability
• Schedule Crystal/WEBI reoccurring reports through Info view
• Maintaining user groups and securities like creating new users and giving appropriate privileges through Central Management Console(CMC)
• Monthly maintenance of BOXI application servers involved server downtime and re-booting using Central Configuration Manager(CCM)
• Resolve any unplanned production downtimes on critical priority
• Maintenance of different Universes to meet new requirements
• Resolve all customer issues raised through MKS Integrity ticket logging system
• Prepare monthly ticket tracking metrics
• Changed/added report logic for existing reports

Environment: Business Objects XI R2.0 InfoView, Web Intelligence, Administrative tools like CMC, CCM, Universe Designer, Instance Manager, Query Builder and Oracle 10g

Senior Microstrategy Consultant

Responsibilities:

• Created attributes, facts and Metrics for reporting’s and used them in reports and document creation.
• Creating custom groups and used them in document/dashboard creation.
• Used the features of OLAP services in MSTR documents.
• Created MSTR dashboards and visual insight using HANA Models and logical tables.
• Created multiple dynamic dashboards and used the optimization techniques for dashboard.
• Involved in MSTR architecture designing and physical data warehouse designing.
• Used object Manager features to migrate from one server to another server.
• Identify the production bugs and replicate the same in Dev and Stage and implement the code change through change management
• Involved in Code migration from dev to stage and stage to production
• scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies

Environment: Micro Strategy 9.3, SAP HANA 1.X, BOBI and Business Objects Data Services 4.0

Microstrategy Developer

Responsibilities:

• Involved in collecting the business requirements and documenting the specifications.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• 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.
• Worked as a support resource for other related projects and was responsible for re-architecting required changes and checking the report results in QA.
• Tested all the reports by running queries against the warehouse using Sql Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Used SQL joins to evaluate the combined record and then produce the record sets.
• Responsible documentation and configuration of Enterprise Manager for logging statistics and reporting purposes.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Worked along with MicroStrategy Knowledge Base to troubleshoot some Report related issues.

Environment:MicroStrategy 8.0.2/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Server, Oracle 9i, SQL Navigator.

BO Developer

Responsibilities:

• Responsible for gathering and refining business requirements from the Business users.
• Created universe design for webi reporting.
• Extensively worked on creating web I reports.
• Involved in admin tasks like user and group creation
• Identified production bugs and resolved them through change management process
• Contacted the SAP Bo for any production issues and upgraded to latest versions.

Environment:Business Objects XI R2.0 InfoView, Web Intelligence, Administrative tools like CMC, CCM, Universe Designer, Instance Manager, Query Builder and Oracle 10g.