SUMMARY:

• 9+ years of experience in IT and MicroStrategy Suite (Microstrategy Intelligence Server, Microstrategy Architect, Desktop, Web, Narrowcast Server, Object Manager)
• Experience in Migrating objects between different environment Dev, Test and Prod
• Experience working with the full project life cycle development process, involving analysis, design, development, implementation, and testing phases.
• Design, developing, deploying, maintaining and integrating complex MicroStrategy reports, dashboards, scorecards, freeform SQL reports, objects (Attributes, Logical Views, Filters, Metrics Transformations, hierarchies, drill maps, Facts, and Prompts), dynamic scorecards and dashboards.
• Extensively worked with the end users in gathering the report requirements and satisfying their reporting needs
• Extensive hands on experience architecting a MicroStrategy project and building reports and dashboards
• Proficient in designing reports through Microstrategy Desktop with optimal usage of key features like Advanced filters, prompts, Transformations, custom groups, and consolidations
• Excellent communication and interpersonal skills with user and client interaction experience.
• Experience on Microstrategy OLAP services.
• Very proficient in working with large Databases in Oracle, Teradata and SQL Server
• Expertise in using pass through Expressions to develop complex filters and Transformations
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements).
• Ability to work in multiple projects simultaneously and independently as well as in a team environment
• Pro - active involvement in continuous improvement of existing systems
• Extensive experience in design and development of logical and physical schema
• Well-Organize Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle.
• Adjust to new and challenging situations with experience in handling pressure situations and problem solving.
• Communicates effectively with technical and non-technical audiences, both written and verbally. Able to present and discuss information at the appropriate level of detail and drive towards a consensus of opinion.

TECHNICAL SKILLS:

Business intelligence: Microstrategy 10.x/9.x/8.x (Architect, Desktop, Web, Narrowcast Server, Object Manager, Command Manager & Enterprise Manager)

Databases: Oracle 10g/9i/8i, My SQL, MS ACCESS, Teradata, DB2 8.0, SQL Server 2000/05.

ETL Tools: Informatica Power Center 8.6.1, DataStage, Ab Initio, Talend

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Microstrategy Developer/Architect

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements.
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Created MSTR detail design documents based on the business requirements.
• Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations.
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Created reports with various object prompts to generate various Ad hoc reports.
• Administered the object change management process: Object migration across the various environments using Object Manager and Project Duplicate.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management.
• Extensively worked on Intelligent Cube Reports for Creating Dashboards. Monitored and Governed Intelligent Cube for better Performance.
• Created Logical Tables in Microstrategy to meet the Complex end user requirements.
• Extensively used Pass through Functions.
• Validate reporting results against requirements. Troubleshoot and analyze data issues within reports
• Prioritize and multi-task concurrent projects; Effective in resolving all clients and development issues
• Performed backend testing by executing SQL Queries.
• Trained the users on developing their own VI Dashboards.

Environment: s: Microstrategy 10.3/10.6, Architect, Desktop, Web, My SQL.

Confidential, VA

Microstrategy Architect

Responsibilities:

• Responsible for administration and configuration of MicroStrategy reporting tool, metadata design, development and testing
• Interviewing the business users to understand the MSHA (Mine Safety & Health Administration) business environment for technical implementation of new business intelligence system.
• MicroStrategy 10 Enterprise Platform Installation and configuration with Oracle as a backend Database. Setup of development, testing and production environments on Microsoft 2012 servers.
• Migration and creation of 71 reports and documents in Microstrategy
• Developed the dashboards using Data Visualizations.
• Close coloration with the Data Warehouse team to build a robust semantic layer of BI for information delivery.
• Weekly meetings with functional members of the project team to capture new requirements. Understanding the root cause and coordinating with the vendor where required to troubleshoot issues.
• Metadata design and development of BI. Schema modeling of around 500 attributes and facts. Key metrics/formulae development to create an efficient semantic layer for self-service analysis
• Implementation of LDAP authentication (with Active Directory) for secure access to reports and dashboards. Additional security roles created to manage the rights and privileges of the user on the system objects.
• Migration of SQL code, configuration and tuning of SQL to migrate standalone reports of old legacy BI tool to MicroStrategy
• Interactive dashboards development for the management to show the key insights of the Mining operations. Year to year comparison and run-time filtering and drilling capability embedded in graphs

Making the training material and detailed documentation for the usage of the tool for the end user

Environment: MicroStrategy 10.0.0, Architect, Desktop, Web, Oracle Toad.

Confidential, CA

MicroStrategy Architect & Developer

Responsibilities:

• Involved in gathering Business requirements and determining the appropriate facts, attributes and metrics.
• Migrated the Reports from Actuate Tool to Microstrategy 9.2.1
• Extensively involved in building and implementing Microstrategy schema objects and public objects by creating facts, attributes, hierarchies, reports, filters, and metrics using Microstrategy Desktop.
• Interfaced with project managers during requirements phases to estimate time and effort associated with new project requests.
• Design and deploy complex and dynamic dashboards covering key performance indicators by using different widgets through MicroStrategy Desktop, Web and Mobile & Ipad .
• Participated in performance and quality assurance reviews of new and existing reports and environments.
• Used Microstrategy Object Manager to deploy the Microstrategy objects across Dev, QA and Prod Environments.
• Implemented Microstrategy Integrity Manager to monitor the metadata object changes across all the development environments.

Environment: MicroStrategy 9.2.1/9.3.0/ 9.4.1 Desktop, Architect and Web, Oracle, actuate reporting tool.

Confidential, RI

MicroStrategy Sr. Developer

Responsibilities:

• Actively participated in data gathering and requirement sessions with Business Users
• Work with a Business Analyst to document and validate Requirements
• Work with other technical resources to understand the Customer data structures and their data relationships in support of the complete BI solution
• Importing Tables/views from databases and updated in warehouse catalog with the latest structures
• Creating facts and attributes on need basis for existing and new requirement changes in reports
• Creating Hierarchies on schema objects in order to represent data at different levels
• Creating logical views on requirement basis to support data on reports
• Update the Schema after creation and changes in schema objects
• Performed OLAP services and MDX query design for advanced analytics and Trend analysis reporting
• Created the requirements Documentation for the MicroStrategy projects and documented the MicroStrategy Environment.
• Created reports based on various requirements using complex Filters, Compound Metrics and Prompts.
• Created complex reports using Advanced Prompts, Conditional, Transformation metrics and Level Metrics.
• Created the Report Specification document and had it signed of, after suggesting some useful alterations.

Environment: Microstrategy 9.2.1/8.2.1 (Desktop, Architect, Web, Narrowcast Server, Command Manager), Oracle 11g, Teradata, Informatica

Confidential, NC

Microstrategy Architect/Developer

Responsibilities:

• Involved in requirement analysis by interacting with analysts for the creation of Data marts.
• Involved in Administration tasks like creating users, assigning privileges, caching and Report optimization.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Involved in up gradation of MicroStrategy from 9.0.1 to 9.2.1
• Back up of metadata and restoration of metadata.
• Worked extensively in MicroStrategy Administration like Creation of new users, roles, privileges, shared folders and access controls Lists.
• Resolved many Production support issues
• Used Transformations to perform time series analysis over various phases and also to calculate the variance and the growth percentage trends.
• Involved in architecting Facts columns and development of hierarchies with related attributes required for reporting.
• Extensively worked in developing Metrics and compound metrics, filters for complex reports.
• Resolved many to many relationships in MicroStrategy using the relationship tables
• Implemented security for different users to view reports for their regions using security filters.
• Thorough research was done for required components and generated status reports to discuss the issues related to Warehouse tables, Metadata platform, missing columns and naming conventions etc.
• Performed System testing, Unit testing
• Used Quality Center to track of incidents and defects that are assigned and created.

Environment: Microstrategy 9.0.1/9.2.1 (Architect, Desktop, Web, Narrowcast Server, Object Manager), Oracle 11g, Informatica PowerCenter 8.6.1, SQL Server 2005, Unix, Toad 9.0, Windows XP, Quality Center 9.2.

Confidential, CA

Microstrategy Developer

Responsibilities:

• Worked with the end users and internal business analysts for data requirements gathering, design, prioritized business goals and information needs.
• Assisted Architect in creating Attributes, Facts and Transformations, and defined the Attribute relationships.
• Designed and created reports using Attributes, Facts, Metrics, Filters, Consolidations, Custom groups and Prompts.
• Developed Static and Ad-hoc reports using Prompts, Metrics, Filters, Custom Groups, Consolidations and Transformations.
• Created interactive Dynamic Dashboards and Scorecards for different users with drill down capabilities.
• Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics
• Created intelligent cubes for better performance of reports.
• Extensively worked in designing and developing Interactive Scorecards and Dashboards.
• Using the Microstrategy Excel, delivered the embedded reports to the end-users.
• Involved in creating of the templates and design of the logical model.
• Participated in review, sign-off and communication of all changes or modifications to reports
• Conducted Data validation testing to ensure data quality.
• Wrote standard and complex SQL Queries in Teradata to perform Data Validation and Graph validation to make sure test results matched back to expected results based on the user needs.
• Conducted Unit/System/User Acceptance testing on the Microstrategy objects developed.
• Providing technical support; troubleshooting report design; monitor system usage and proactive troubleshooting

Environment: Microstrategy 9.0.2/8.1.1 (Architect, Desktop, Web, Narrowcast Server, Object Manager), Teradata, Ab Initio, UNIX.

Confidential, NJ

SQL/Microstrategy Developer

Responsibilities:

• Interacting with business users for requirements gathering.
• Created schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, prompts, Consolidations, Custom Groups, Drill maps and Templates.
• Used Auto prompts filter feature to give the end user a choice of different filtering criteria each time they run the report.
• Extensively worked with Microstrategy Intelligence server and Microstrategy reporting basics using Microstrategy Desktop and Microstrategy web.
• Experience in server migration.
• Involved in Testing of Reports and Objects.
• Created all possible Metrics for users to build their own reports on Web by creating their own Templates and filters using the available Metrics.
• Documentation of MicroStrategy Objects Process flow.
• Maintenance and Support for the project and end users
• Managing schema objects and application objects across the project by using Object Manager.

Environment: MicroStrategy 8/9, Informatica7, SQL, Windows XP.