Profile:

8 years of experience in Software Development life-cycle and implementing in Data Warehouse, Business Intelligence, Client/Server Technologies and E-Commerce Applications for Financial Industry, Retail Industry, Nutrition products industry and Oil Gas Industry. Over 6 years of experience in using MicroStrategy Suite Intelligence Server, Administrator, Mobile, Architect, Desktop, Web and Narrowcast Server .

Qualifications Summary:

• Experience in Visual Insight Services and Mobile Dashboards.
• Worked closely with the business to gather, review, validate and document the Business Requirements.
• Expertise in Using Administrative tools like Object manager, Command manager, Integrity manager and Enterprise manager.
• Worked with very complex data models for reporting in BI environment with multiple Dimensional data.
• Worked extensively on Oracle and SQL Server Database Environments.
• Intensive experience and exposure to all aspects of MicroStrategy application such as Administration, Architecting and Development.
• Expertise in using Pass-Through Expressions like Apply Simple and Apply Comparison to develop complex Filters and Transformations.
• Prototyped, Developed Deployed BI Mobile iPhone and iPad solutions.
• Worked on delivering reports and business intelligence solutions on the Web using MicroStrategy Narrowcast Server and Distribution Services.
• Expertise in creating Dynamic Dashboard Reports to view personalized reports based on user requirements.
• Expertise in Developing User Objects filters, prompts, metrics, Custom Groups, Consolidations to develop Documents and reports.
• Expertise in Administration tasks like creating user accounts, assigning privileges and Security Filters.
• Expertise in Creating Schema Objects facts, attributes, Hierarchies, Transformations .
• Experience in Data Modeling and BI implementation with Database tuning.
• 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.
• Extensive experience in Agile software development and SCRUM methodology
• Familiarity in writing, uploading and passing test cases in HP Quality Center.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Excellent team player with good analytical, communication and interpersonal skills.

Professional Experience:

Confidential

Role: Sr. MicroStrategy Developer

Responsibilities:

• Involved in creating/replicating reports in MicroStrategy based on existing Crystal Reports.
• Interacting with users from different functional teams across the organization in gathering requirements for developing departmental documents.
• Creating Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters.
• Created Hierarchical prompts, nested prompts, object prompts.
• Created customized Custom Groups with complex filters and Relationship filters.
• Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both MicroStrategy Desktop and MicroStrategy Web.
• Created Ad-hoc reports with dynamic prompt answers for the end users to generate.
• Worked with the MicroStrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues.
• Used the VLDB properties for performance tuning and SQL optimization.
• Created Transformations like Last Month to This Month and also created the required transformation tables.
• Used MicroStrategy functions such as ApplySimple and ApplyComparision in metric calculations.
• Coordinating with ETL/DBA team in implementing new requirements/logic and schema design.
• Writing, uploading and executing test cases in HP Quality Center under Agile environment. Raise the defects from the test results and track the defects for its closure.
• Attend training sessions or self-directed study of AML industry news and trends to stay up to date on latest AML regulations and requirements.
• Tracking and maintaining reports development process using RALLY Software.
• Good understanding and experience with standard System Development Life Cycles, such as Waterfall and Agile.
• Migrated reports between different environments using Object Manager and package method.

Environment: MicroStrategy 9.2.1/9.0.2 Desktop, Administrator, Architect, Intelligence Server, Web , Object Manager, HP Quality Center 10.0/11.5, SQL Server 2008, Crystal Reports v10, Windows XP/Windows 7, Rally Software, Agile Methodologies.

Confidential

Role: MicroStrategy Consultant

Responsibilities:

• Created new Facts, Attributes and attribute form expressions, Hierarchies as needed in the Project.
• Worked extensively on creating Application Objects like Nested Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
• Worked on advanced visualizations like interactive heat maps and bubble charts and grid of graphs.
• Created daily, weekly, monthly reports and dashboards for iPhone, iPad using MicroStrategy mobile.
• Excellent Experience in designing, developing and performance tuning MicroStrategy reports and documents.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Extensively used Distribution Services of MicroStrategy 9 to deliver documents and dashboards to End users.
• Created numerous MicroStrategy objects like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Created Transformations table based, formula based for using in comparative reports like sales this year to sales last year.
• Involved in creating security filters to end users to access data based on their privileges.
• Created logical data models, recognized source tables and columns, to build Attributes, Facts, Hierarchies and Relationships, necessary to create a MicroStrategy project.

Environment: MicroStrategy Suite 9.0.2, MicroStrategy Mobile Application for iPad and iPhone,

Report Services, Netezza, Dashboards, Enterprise Manager, Unix, MS-Excel, SQL Server 2008, Windows XP.

Confidential

Role: MicroStrategy Developer

Responsibilities:

• Gathered and analyzed business requirements from application users and business managers.
• Created three types of reports to show the users Enterprise Reports, Dashboard Analysis Reports, Ad-hoc Reports.
• Managing Schema Objects and application objects across the project by using Object Manager.
• Involved in the creation of Data mart Reports, Partition Mappings and Aggregate Tables to improve performance of Enterprise Reports.
• Expertise in customize SQL query by setting VLDB properties at different levels Database Instance, Report and Metric.
• Created Administration Tasks like creating User Accounts, Assigning Privileges and applied Security Filters.
• Created transformations for rolling time period reporting and trending of prescription counts. Created Advanced Filters, Advanced Prompts, Advanced Report Designs and Drill Maps.
• Used SQL Developer extensively to test and debug MicroStrategy reports as a key step in data validation.
• Involved in migration of Business Objects Documents to MicroStrategy Documents.
• Created services using Subscription sets, Schedules, user groups.
• Involved in setting Result Caches, Object Caches to improve performance of the report.

Environment: MicroStrategy Desktop 8.1.2, MicroStrategy Architect 8.1.2, MicroStrategy Intelligence Server 8.1.2, MicroStrategy Web 8.1.2, SQL, SQL Loader, Oracle 10gR2.

Confidential

Role: MicroStrategy Reports Developer

Responsibilities:

• Gathering Requirements, created mockups and developed an extensive collection of interactive Dashboards using MicroStrategy Report Services for distribution to executives, VIPs and field sales teams.
• Created a complete replacement for the existing Excel based Reporting and distribution system using MicroStrategy Office.
• Developed Schema Objects Facts, Attributes, Hierarchies, and Transformations using MicroStrategy Architect.
• Extensively used Filters, Templates, Consolidations, Transformations and Custom Groups to generate reports for business analysis using MicroStrategy. Developed Metrics, Derived Metrics, Compound Metrics and level Metrics for complex reports.
• Created transformations for rolling time period reporting and trending of prescription counts. Created Advanced Filters, Advanced Prompts, Advanced Report Designs and Drill Maps.
• Used SQL Server extensively to test and debug MicroStrategy reports as a key step in data validation.

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server 8.1.1, MicroStrategy Web 8.1.1, Oracle 10gR2, MS Office, Excel Macros, and Windows XP.

Confidential

Role: Jr. PL/ SQL Developer

Responsibilities:

• Performed business analysis for assessing the user requirement regarding the format and content of the reports.
• Writing complex SQL Queries and PL/SQL procedures for developing the reports.
• Designed some complex reports as per the users requirement.
• Developed several packages, stored procedures, functions, database triggers.
• Developed extract reports to upload information to the management sales monitoring system.
• Performed documentation of the modules and reports generated.

Environment: Oracle 9i, Oracle, PL/SQL, Oracle Developer Suit 9i, Reports 6i, Windows XP, UNIX.