SUMMARY

• Around Seven Years of progressive IT experience in full life cycle development gathering requirements, documentation, developing, designing, testing, implementing, and deploying BI Solutions.
• Over 6+ years of experience in using Micro Strategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web and Narrowcast Server).
• Good Knowledge on data warehouse Concepts like Star schemas, Snow flake, Dimension and Fact tables.
• Extensive experience and exposure to many aspects of Micro Strategy application such as Desktop, Web, Architect, Administration, Intelligence server, Narrowcast server, MSRS, OLAP Provider, and MSTR Office.
• Extensively worked in creating and integrating Micro Strategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data warehouse.
• Created Data Mart Reports using Complex Filters and Compound Metrics.
• Created comps66lex Reports in Micro Strategy Desktop and Web using features like templates, custom groups and consolidations.
• Extensive Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends. Also, created Custom Widget using Adobe Flex.
• Created virtual attribute elements using Consolidations to define reports on a row - by-row basis, refining the business model to meet department or individual needs without impacting the structure of the enterprise data model.
• Created drill maps and drill paths to navigate to different levels of information within a report.
• Worked extensively on creating reports using free form SQL queries in Micro strategy.
• Experience delivering reports in Desktop, Web and via the Narrowcast server.
• Experience in setting up the Micro Strategy system administration including installation and configuration, Metadata, configure the Intelligence server, creating users, user groups, security filters, roles, privileges, and security roles and also involved in migrating servers.
• Experience working with ETL developers in data extraction and transformation (ETL) using Informatica Power Center 6.x, Power Mart 6.x and Data Stage.
• Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of database flexibility, queries execution and scalability issues suited for Oracle, Teradata, DB2 and SQL Server.
• Expertise in Database development skills using SQL, PL/SQL, T-SQL for creating procedures, Functions, Triggers and other database objects.
• Created Cluster Nodes for two or more Intelligence Servers pointing into same metadata.
• Good knowledge and understanding of Software Development Life Cycle (SDLC).
• Act as a liaison between the client, Project manager, design team and the development team while representing the user through the entire process.
• Ability to examine a problem from various angles and develop appropriate solutions that successfully balance business goals, user needs, and technology constraints.
• Exceptional ability to quickly master new concepts and capable of working in-group as well as independently with excellent communication skills
• Excellent communication skills and the ability to work individually as well as in a team environment

TECHNICAL SKILLS

BI Tools: Micro Strategy v10.4, v10.1, v9.4.1, v9.3.1, v9.2.1, v9.1.0, v9.0.2, … Micro strategy Administrator, Micro Strategy Desktop, Micro Strategy Intelligence Server, Micro Strategy Web, Micro Strategy Narrowcast Server, Micro Strategy OLAP Services, Micro Strategy Architect, Micro Strategy Distribution Services, Micro Strategy Office), Narrowcast Server, Business Objects.

Database: Oracle 10g/9i/8i, MS Access, Teradata, MS SQL Server, DB2

Front End Tools: Oracle Developer 2000, Oracle Designer 2000, Visual Basic 6, SQL Navigator, Toad

Operating System: Windows 2000, Windows XP, Windows vista, Windows 7, UNIX

Languages: SQL, PL/SQL, Java

Office Tools: MS Word, Excel, MS Visio, MS Project, MS Outlook

PROFESSIONAL EXPERIENCE

Sr. Micro Strategy Developer

Confidential - Los Angeles, CA

Responsibilities:

• Worked with business users to gather requirements and prepared technical specification Documents.
• Understanding the reporting requirements and developed the reports and redesigned the legacy reports in Micro Strategy
• Involved in Dimensional Data Modeling, Data Architecture, Business and Data Analysis
• Developed Micro Strategy Schema objects and Application objects like Metrics, Filters, Prompts, Consolidations, Custom Groups and Project objects like Subtotals.
• Designed Reports, Documents and Dashboards using Desktop.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Created Transformations to calculate YTD (Year to date), MTD (Month to date) metrics
• Implemented Report Data Options, Formatting, Dynamic Dates, Advanced Sorting, Prompt Ordering, and Totals, Outline Mode based upon the business user change request during UAT Testing.
• Validated end user report requests using SQL queries and MicroStrategy tools.
• Using Object Manager to move the reports from Development Project to QA/Production Project.
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Involved in extracting the data using SSIS from OLTP to OLAP
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in optimization of code and tuning queries for performance.
• Production Support has been provided for ongoing issues.

Environment: Micro Strategy 9.4.1/9.3 (Administrator, Desktop, Web, Distribution Services, Object Manager, Command Manager, Narrowcast server), UNIX, Windows Server, SQL server.

Sr. Micro Strategy Developer

Confidential, Massachusetts

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Involved in the development of Data Models (physical/logical) using Erwin tool as KBB data and reporting requirements are completely different from the existing scenario.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Involved in development of interactive dashboards and scorecards for high level management.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Used Micro Strategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Micro Strategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Created automatic User creation on login using Task Admin and SDK.
• Creating Mobile Dashboard with HTML containers.
• Responsibilities of doing a POC, a design document and implementation of apache-tomcat integration and IIS-tomcat integration.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Involved in changing the existing Sales Organization Hierarchy, which is required to be modified as underlying data were reorganized.
• Unit tested the reports developed by the other developers.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Assisted the team in identifying the errors in the underlying data.

Environment: Micro Strategy 9.3.1 (Micro Strategy Administrator, Micro Strategy Architect, Micro Strategy Desktop, Micro Strategy Narrowcast Server, Micro Strategy Object Manager, Micro Strategy Enterprise Manager, Micro Strategy OLAP Services, sdk, tomcat, Ant, Toad for Oracle9.7.2, Micro Strategy Project Manager, Micro Strategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows 7.

Micro Strategy Developer

Confidential, Pittsburg, PA

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 different Project Sources for different environments like production, testing and development.
• Created different schema objects like Attributes, facts by using Micro-Strategy Architect of the Micro-Strategy BI Suite.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Generated reports using Advanced Metric objects, Filters, Prompts and created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Involved in creating Micro Strategy objects like Metrics (Conditional, Transformational, Dimensional, and Compound), Filters, Prompts (Filter, Object), Templates and Reports
• 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.
• Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems.
• Created Data Mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Worked in Micro Strategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Worked on Narrowcast Server Application environment creating services using subscription sets, schedules, and Information objects.
• Also, tuned ODBC driver to improve data transfer rates between database and Micro Strategy servers located at different physical locations.
• Used database specific Micro Strategy OLAP pass through functions like Apply Simple,
• Involved in production support (24/7)
• Maintained a stable platform by proactively identifying and resolving any issues or bugs.

Environment: Micro Strategy 10/9.4.1 (Intelligence Server, Administrator, Desktop/Developer, Web, Distribution Services, Visual Insight, Mobile, Object Manager, Command Manager, OLAP), UNIX, Windows Server, Oracle 11g, Sybase.

Micro Strategy Developer

Confidential

Responsibilities:

• Started with gathering requirements from the users and documenting the specifications
• Created the Report Specification document and had it signed of, after suggesting some useful alterations.
• Analyzed the source system data
• Creation of new users, roles, privileges, shared folders, access controls Lists using security roles in Micro Strategy
• Generated and implemented Micro Strategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Micro Strategy Desktop
• Created Complex Metrics forcing Dimensionality and Conditionality which are mainly used in Client scorecards, summary, detail level reports and trending related reports
• Created Complex reports for Analysis with Transformations, Custom Groups and Complex Filters
• Created Complex filters with advanced qualifications involving the 'Apply' functions
• Used Micro Strategy Narrowcast Server to monitor the business data and alert the users to unexpected exceptions and trends
• Created Report Service documents with both Grids and graphs as per user requirements
• Tuning of SQL Scripts, Analyzing the Tables, Indexes, Involved in Data cleansing.
• Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the Micro Strategy SQL engine generated queries
• 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
• Played a key role in User Acceptance Testing of the reports.

Environment: Micro Strategy 8.x.x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), SQL Server 2008, Teradata.