SUMMARY

• About 12 years of Financial/IT experience in full Software Development Life Cycle (SDLC) specializing in the areas of business requirement analysis, design and implementation using MicroStrategy.
• Also have strong technical, logical, people managing and multi - tasking skills.
• 12 years of experience in the Financial/IT industry and specialized experience in Performing financial analysis and oversight.
• Experience in the IT industry and specialized experience in Business Intelligence - Expertise includes mainly in MicroStrategy 8.x/9.x/10.x/11.x and its components (Desktop, Web, Mobile, Object Manager and other utilities).
• Very strong experience in designing, building and deploying MicroStrategy reports and dashboards.
• Good understanding of Data Warehousing Concepts and good knowledge of ETL process.
• Good Understanding of Logical and Physical Models.
• Experience in developing Schema objects and Application objects.
• Experienced in creating and integrating MicroStrategy reports and objects like (Attributes, Facts, Filters, Metrics, Prompts, Templates, Consolidation and Custom Groups).
• Expertise in developing Scorecards & Dynamic Dashboards and good experience in using Report Services.
• Good experience using Intelligent Cubes, Multisource, Visual Insights in MicroStrategy
• Experience in using Object Manager, Enterprise Manager, Command and Integrity Manager.
• Experience in using VLDB properties for performance tuning and also worked with DBA in troubleshooting.
• Expertise in working with large databases on Oracle, Teradata, SQL Server with MicroStrategy Suite.
• Good experience in training the users and resolving the issues.
• Highly motivated with the liability to work effective with teams as well as independently.
• Recognized for the dedication and liability to achieve results.
• Self-Motivated team player and have experience in all phase of the System’s Life Cycle including Analysis, Design, Coding, Testing, Implementation and Support.

TECHNICAL SKILLS

Databases: Oracle 11g, SQL Server 2008 r2, Teradata.

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows NT/2003/2000/XP/98

Utilities: SQL*Loader, Oracle Wrap, FTP, SFTP.

Tools: MicroStrategy 10.4, 10.3, 10.1, 9.X (Desktop, Web, Mobile, Narrowcast Object ManagerEnterprise Manager, Integrity Manager), SQL Server DTS, Eclipse, Ab initio.

OS: Unix, Red Hat Linux, Confidential AIX 5.2/5.3, HP-UX, Windows NT/20X/9X, Windows XP, Windows/ 2003.

Project Management: Microsoft Office Project.

PROFESSIONAL EXPERIENCE

Confidential, El Segundo CA

MicroStrategy Consultant

Responsibilities:

• Providing technical leadership for the entire MicroStrategy environment including Architecture, best practices, processes and development standards.
• Maintains active relationships with customers to determine business requirements, leads requirement and design review meetings
• Architecting MicroStrategy projects from end to end.
• Worked on performance tuning and troubleshooting.
• Worked on metadata creation, creating report specifications, integration, test planning, testing and implementation support.
• Experitise on Report and Dashboard development
• Strong Analytical skills and able to work independently and guide the team.
• Oversees issue resolution and implementation of alternatives across enterprise initiatives.
• Good understanding of database design, optimal query design, ETL and data management backgrounds.

Confidential, Herndon VA

MicroStrategy Consultant

Responsibilities:

• Extensive client interaction and analyzed requirements on MicroStrategy to be able to perform Report and Dashboard development.
• Developed different Reports according to the requirements.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to- one, one-to- many and many-to- many between different attributes.
• Designed various Dashboards reports, which provide practical ability for business user to design and refine their own reports without programming.
• Involved in Micro Strategy report development including creation of metrics, filters, and prompts.
• Performance tuning of the MicroStrategy reports that includes changing required VLDB properties, tuning SQLs generated by MicroStrategy, etc.
• Worked with Database Administrators to provide requirements for necessary back end tables and also to help fine tune the queries being generated by MicroStrategy.
• Created links on metrics to open up a new detailed report when clicked on it.
• Developed MicroStrategy Dynamic Dashboards using several controls and worked on widgets.
• Added ESRI maps Visualization on Dashboard and used it as a Filter to make desired section.
• Customized the drilling options specific to the reports, using drill map editor to give access to more detailed and supplemental information.
• Support the objects migration from Dev to QA and QA to Production by creating Packages through Object Manager.
• Created Test cases to perform the Testing on Dashboard.
• Worked with testers and end client to maintain the smooth and successful transition of Testing Phase.
• MicroStrategy Version Upgrade 10.2 - 10.4.

Environment: MicroStrategy Product Suite 10.2/10.4 (Desktop, Web), SQL Server

Confidential, Richmond, VA

MicroStrategy Consultant

Responsibilities:

• Responsible for Upgrading MicroStrategy Version 9.4 to 10.4.
• Created Migration Environment and DSN.
• Installed and Configured the MicroStrategy Version 10.4 in environments from DEV to QA & Production.
• Created Users, roles & privileges in the MicroStrategy Environment using the Administrator.
• Responsible for maintaining I server.
• Used the Object Manager to migrate objects to different environments.
• Involved in Testing and Data validation of Reports.
• Involved in End-User training, Support and Maintenance
• Was responsible for Job Monitoring and maintaining the cache on the I Server.
• Configured Operational Manager.
• Performed complete production support for the MicroStrategy Environment, maintaining I server, weekly reboots of the I server etc.
• Fixed Defects and performed Integrity Manager Test for existing projects.

Environment: MicroStrategy Product Suite 9.4.1/10.4 (Desktop, Web), SQL Server

Confidential, Herndon VA

MicroStrategy Consultant

Responsibilities:

• Extensive interaction with Business Manager, Users and team on daily basis.
• Participated in Agile development projects delivering functional releases to business stakeholders on an iterative schedule.
• Maintained the work pace and accomplish the task as per sprint deadline.
• Worked closely with Business Analyst to gather and refine the requirement.
• Involved in Development of Dashboard with Visual Insights involving Maps, Grid, and Graph.
• Involved in Research and Development to define the road map for further implementation.
• Extensively worked on creating and Enhancing MicroStrategy Advanced Reports.
• Created MicroStrategy objects with reference to the Baseline SQL and also modified the MicroStrategy objects to adopt and match the results from baseline SQL.
• Created and Modified various Public Object - Custom Group, Template, Drill Maps.
• Customized the drilling options specific to the reports, using drill map editor to give access to more detailed and supplemental information.
• Supported MicroStrategy Upgrade from 9.4.1 to 10.1, followed by bug fix Upgrade to 10.2.
• Analyze Materialized Views, to support the further enhancement/creation of MicroStrategy Reports.
• Worked with Database Administrators to provide requirements for necessary back end tables and to visualize the required Architecture to design the Reports.
• Maintained the documentation for all the metadata in MicroStrategy to enable all the required stakeholders to understand the existing state of the MicroStrategy project.
• Worked on VLDB Properties, Confidential Report Level as well as Attribute Level to tweak the generated SQL.
• Worked on Installation and Configuration of Version upgrade MicroStrategy 9.4 to 10.2. Created DSN, Establish Metadata Connections, Installed Operating Manager.
• Identifying the issues and approach to fix, after testing the Reports/Documents using Integrity Manager.

Environment: MicroStrategy Product Suite 9.4.1/10.1/10.2 (Desktop, Web), Oracle 11g

Confidential, Mclean, VA

MicroStrategy Consultant/ Data Analyst

Responsibilities:

• Developed, Modified and Created complex performance metrics for Servicer Performance Portfolio. Maintained pace of the project to finish on time and on budget.
• Created Datamart reports with multi-SQL passes running in hundreds and generating aggregate tables.
• Developed Intelligent Cubes for performance enhancements and application responsiveness.
• Developed complex SQL queries to validate MicroStrategy results.
• Developed detailed test cases to validate metrics, filters and overall aesthetics of the external facing application.
• Worked within the Business Team to analyze the requirement and define the further roadmap for IT Team.
• Worked closely with Business Analyst to gather and refine the requirement.
• Research and Development to define the road map for further implementation.
• Developed Scorecard with multiple KPI, Selectors, Hyperlinks and other Objects.
• Extensively worked on creating and integrating MicroStrategy Advanced Reports.
• Involved in customizing Grids, Graphs and formatting Report.
• Developed, Modified and Created Compound Metrics, Compound Filters and other Public Objects.
• Involved in UAT with writing Test Cases, Documentation and also performed in test case execution.
• Assisted with UAT, troubleshooting, debugging issues.
• Also involved in writing Requirement Traceability Matrix (RTM).
• Extensive interaction with Senior Director, Director and Manager.
• Worked in a team environment and play a role in all the phases of SDLC.

Environment: MicroStrategy Product Suite 9.3.0 (Desktop, Architect, Web), Microsoft SQL Server 2008 R2.

Confidential, Richmond, VA

Data & Financial Analyst

Responsibilities:

• design and development life cycle. designing Dimensional and Multidimensional Modeling using star and snowflake schema.
• Created complex reports which were built on level metrics, advanced filter and prompts.
• Created schema objects such as Facts, Dimensions, and Attributes.
• Designed schema and public objects using Pass Through functions (Apply Simple, Apply Comparison etc.)
• Designed and created different MicroStrategy objects such as advanced Metrics, Filters, Prompts, Consolidations and Custom Groups.
• Performed Administrator duties such as creating new users and groups and moved report objects under one user using Object Manager.
• Analyzed and developed the new objects in Test environment and after testing the objects and reports, migrated to Production Environment using Object Manager.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Validated end user report requests using SQL and MicroStrategy tools.
• Created various Projects and maintained different Project Sources.
• Created Relationship Filters based on Existing Model.
• Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters etc.
• Prepared Documentation and User Guides to identify the various Attributes, Metrics and Reports needed from Business.
• Created and tested highly interactive and complex reports in MicroStrategy Desktop & Web.
• Collected reporting design requirements from various departments and also created reports and dashboards as per business requirements and analyzed users’ feedback to make enhancements to the newly created reports and documents, from time to time.

Confidential

MicroStrategy Consultant

Responsibilities:

• Meetings with business users to discuss and finalize the requirements and design of the reports.
• Developed different reports according to the requirements.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, one-to-many and many-to-many between different attributes.
• Designed various Dashboards reports, which provide practical ability for business user to design and refine their own reports without programming.
• Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports
• Performed routine administrator tasks during absence of MicroStrategy administrator.
• Extensively worked with Object Manager to migrate the MicroStrategy Objects from development to QA and then to production environment.
• Used several new controls for Dashboards like time series slider, radio buttons, and drop-down menus for the flash version of the dashboards in 9.0
• Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies. upgrading MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports. creating crystal reports.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user training for the MicroStrategy Desktop/Web.

Environment: MicroStrategy 9.0/8.1.2 Product Suite (Architect, Desktop, Web, Object Manager) Oracle 10g