SUMMARY:

• Over 6+ years of IT experience in software development, documentation, designing and requirement gathering with major focus around Business Intelligence, Data Warehousing and Database Applications
• Proficient in using MicroStrategy Developer, MicroStrategy Intelligence Server, MicroStrategy Distribution Services, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web Elements .
• Proven expertise in Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema
• Very good knowledge of OLTP and OLAP source systems
• Expertise in creating Schema Objects such as Facts, Attributes, Hierarchies and Transformations
• Provided complex Reports in MicroStrategy Desktop and MicroStrategy Web using Templates, Filters, Prompts, Consolidations and Custom Groups
• Proficient in developing complex Filters and Transformations using Pass - Through Expressions like Apply Simple and Apply Comparison
• Expertise in Creating Document from multiple Datasets like Map Application Diagram, Grid and graph and also created custom Dashboards and scorecards using Report Services
• Expertise with intelligent cubes
• Efficient in migration of Projects / Objects between different environments.
• Experienced in using Administration tools like Job Monitor, User Manager, Cache Manager, Object Manager, Schedule manager
• Very proficient in working with large Databases in Oracle, Teradata and SQL Server
• Hands on experience using Informatica Power Center to create transformations, mappings for the ETL’s
• Used Erwin to generate logical & Physical models of the Data Warehouse Structures.
• Ability to adjust to new and challenging situations with experience in handling high pressure situations and problem solving
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS:

OLAP Tools: MicroStrategy10.4/9.4.1, 9.3.0, 9.0.1, 8.1.1, 8.0.x (8.0.1, 8.0.2, 8.0.3)

ETL Tools: Informatica, SQL Server DTS, Data stage

Data Modeling:: Erwin 4.0/3.5.2,Designer 2000

Databases:: Teradata, Oracle 11g/10g/9i/8.i, SQL Server, MS Access, MySQL

Languages:: C, C++, SQL, PL/SQL, T-SQL

Operating Systems:: MS-DOS, UNIX, Linux, and Windows

PROFESSIONAL EXPERIENCE:

Confidential, Oakbrook,IL

Responsibilities:

• Involved in the documentation of technical specifications of the Sales and Inventory Project.
• Worked with Connectivity Configuration Wizard to configure the Metadata connectivity information, metadata DSN name etc.
• Created microstrategy reports using microstartegy office using macro’s by eliminating narrowcast server.
• Created different Project Sources for different environments like production, testing and development.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards)
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating MicroStrategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created Ad-hoc reports by gathering specific requirements from the different users.
• Involved in the troubleshooting and Performance Tuning of the reports using VLDB properties.
• Created Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Extensively worked on Question objects so that different user will subscribe to the messages reports that are user specific to that particular user.
• Worked on the excel formatting, macros and templates of the documents which are used in different services.
• Interacted with users from different functional teams across the organization in gathering requirements for developing departmental dashboards and Key Performance Index corporate dashboards
• Involved extensively in the overall life cycle of the Data Warehouse integration project.

Environment: MicroStrategy 10.4/9.4.1 Administrator,MicroStrategy office, Architect, Desktop, Object Manager, Enterprise Manager, MicroStrategy ODBC test tool, Teradata, Narrowcast Server and Windows XP Professional.

Confidential, IN

MicroStrategy Consultant

Responsibilities:

• Involved in gathering requirements from the users and documenting the specifications.
• Developed Multidimensional Model, Logical Model by studying the source systems and business requirements.
• Involved in and provided solutions for complex Time Dimension related issues and analysis.
• Created Schema Objects Attributes, Facts for different MicroStrategy projects
• Generated reporting object like Metrics, Filters, Prompts, Reports, Custom groups & Consolidations
• Extensively used Micro Strategy Report Services to generate Report Documents.
• Created executive dashboards for high level management with KPI’s by presenting them in visually intuitive, easy-to-read, interactive documents.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data
• Customized reports, Documents and deployed them to Micro Strategy web.
• Substantially worked on Advanced Prompts, Conditional Transformation Metrics and Level Metrics to create complex reports
• Built various Security Filters at the Group and User level to Limit data
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Implemented OLAP functionality within report service documents to enhance performance.
• Created various schedules both Time and Event based to schedule History, Cache jobs on a daily and weekly basis
• Involved in Installation, configuration and Administration of I-server, Web and Narrowcast server
• Involved in the Unit, System and Integration testing across all the projects.
• Identified Object, Report and dashboard defects and entered defects into SharePoint portal and resolved them based on defect severity and priority.
• Worked with the DBA to do daily backups of the Metadata on a nightly basis.
• Involved in Administration tasks like creating users, assigning privileges, caching, specifying Query Governing Thresholds, and Report optimization
• Wrote Command manager Scripts and used them in batch file to automate the Administrative Jobs on a daily and weekly basis
• Actively Used Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment
• Evaluate data through SAS systems and interpret into relevant statistics
• Worked with SAS programmers on monthly/Quaterly reports.
• Created the Metadata & Statistic tables for the Micro Strategy projects on Oracle database.
• Worked with ETL team to collabarate on data warehouse loads for front end reporting.

Environment: MicroStartegy 10.3,MicroStrategy 9.4.1 (Developer, Administrator, Intelligence Server, Web), MicroStrategy Architect, MicroStrategy Command Manager, MicroStrategy Object Manager. Windows, Oracle.

Confidential, DE

MicroStrategy Consultant

Responsibilities:

• Responsible for gathering the business requirements from the users, and analyzing the Report Specifications and needs of the end users.
• Worked closely with the users (Departments) for the initial requirements during the Warehouse Design and Dimensional modeling
• Involved in creating reports to meet the needs of the end users and business analysts.
• Generated and implemented Micro Strategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Micro Strategy Desktop and Architect.
• Involved in creating Micro Strategy Prompts, Filters, Templates, Consolidations and Custom groups in an enterprise data warehouse team environment.
• Involved in Micro Strategy Administrative tasks like creating users and groups, Prioritization of the reports and jobs, idling the Projects etc.
• Created security roles and security filters and assigned them to groups and users to meet the corporate requirements.
• Used Object Manager to manage the complete life cycle of a project, which involved moving the project from Development to Testing to Production.
• Acquired good knowledge of Command Manager and involved in running various scripts to creating users and groups.
• Involved in Designing Ad-hoc Reports, Scorecards, Dashboards, Freeform SQL Reports and Graphical Reports etc.
• Involved in Functional Testing and Tuning of the Micro Strategy Reports.
• Involved in upgrading Micro Strategy environment from 9.2.1 to 9.3.
• Created baseline for the projects and Used Integrity manager for comparing the reports and sql.
• Successfully tested and migrated 33 projects to 9.3
• Involved in the data validation process by validating data from the source system and Data warehouse
• Checked for discrepancies in data and investigated the cause by validating with the metric used.
• Interacted with the ETL team and the users to minimize the occurrence of Data Discrepancy
• Optimized query for the report by analyzing the SQL generated
• Fine-tuned VLDB properties for better query performance

Environment: MicroStrategy Desktop 9.3, MicroStrategy Web, MicroStrategy Narrowcast Server, Unix Oracle10g.

Confidential, NY

MicroStrategy Consultant

Responsibilities:

• Analysed existing systems and gathered requirements.
• Extensively Created Attributes, Facts for different MicroStrategy projects
• Implemented star schema for data warehouse for logical/physical data modelling and dimensional modelling
• Implemented OLAP functionality within report service documents to enhance performance.
• Took the advantage of various features like widgets and selectors to provide more user friendly and interactive Dashboards.
• Played a substantial role in architecting Fact columns and development of Hierarchies with related Attributes required for reporting.
• Developed Security Roles to limit Options, Objects and data across the Server and Projects level
• Involved in Installation, configuration and Administration of I-server, Web and Narrowcast server
• Generated base formulae, mathematical expressions using existing facts in MicroStrategy desktop, which was used to build numerous other metrics.
• Developed a test plan to upgrade to 9.0.1 by doing various tests WRT Reports, FFSQL Reports, Documents and Dashboards.
• Identify Object, Report and dashboard defects and entered defects into SharePoint portal and resolved them based on defect severity and priority.
• Involved in Administration tasks like creating users, assigning privileges, caching, specifying Query Governing Thresholds, and Report optimization
• Actively Used Object Manager to deploy the MicroStrategy Objects from the development stage to the Test stage and then to the Production environment

Environment: MicroStrategy Desktop 9.0.1,9.0, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, UNIX, Oracle 10g

Confidential, MD

MicroStrategy/Crystal Reports Consultant

Responsibilities:

• Analysed existing systems and gathered requirements.
• Reviewed and evaluated user needs.
• Worked with source systems to understand the data flow and interacting with user groups to collect the business requirements.
• Implemented star schema for data warehouse for logical/physical data modelling and dimensional modelling.
• Played a substantial role in architecting Fact columns and development of Hierarchies with related Attributes required for reporting.
• Enabled the end users to generate ad-hoc report by drilling up, down, within and across dimension or anywhere by Creating advanced grid reports, consisting of data analysis by combining a template with Filters.
• Involved in creating users in MicroStrategy Desktop for testing the reports.
• Optimized Query efficiency for high performance reports and dashboards.
• Generated base formulae, mathematical expressions using existing facts in MicroStrategy desktop, which was used to build numerous other metrics.
• Implemented Caching strategies for high performance BI.
• Used Object Manager or duplication feature to promote development object into test project and finally to production.
• Identified the various attributes, metrics and reports needed from business group and involved users.
• Designed and developed dashboards for executive and senior sales management.
• Provided access to the Data warehouse to a much larger audience by using Narrowcast Server. The report delivery has been personalized as per user requirements.
• Helped in ETL testing for dimensions and fact table

Environment: MicroStrategy 9.0, (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) SQL Server, Informatica, XSL & HTML