SUMMARY

• Over 7+ years of IT experience with 6 years of Microstrategy - Analysis, design and implementation, Reporting tools, OLAP environments and tools, along with strong analytical skills.
• Well versed with the Microstrategy product suite namely Desktop, Intelligence server, Architect, Administrator, Web, Report Services, Dashboards and Narrowcast Server.
• Active involvements in projects dealing with Microstrategy object manager, Enterprise manager and Command manager.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Extensive Experience in creation of Dashboards and scorecards which helps in better understanding of the Business trends.
• Expert in Designing Data Marts using different multi dimensional modeling techniques such as Star Schema and Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modeling.
• Strong skills of working with databases like Oracle, Teradata, SQL Server and IBM DB2.
• Involved with the full life cycle development of the data warehouse project.
• Strong troubleshooting capabilities in Microstrategy Desktop.
• System Optimization, performance monitoring and tuning experience in Multiple Environments.
• In-depth knowledge of fundamental data warehousing concepts such as entity relational modeling, dimensional modeling, star and snowflake schemas, modeling data marts
• High-end database experience using Oracle 10g/9i/8i, MS SQL Server 2005, DB2, Retek, MS Access 7.0/2000, Teradata, SQL, PL/SQL, SQL*Plus, SQL*Loader, Developer 2000, Win 3.x/95/98/2000, Win NT 4.0.
• Very strong SQL skills with knowledge of Stored Procedures, Triggers, Functions, and Transact SQL, including the use of nested table expressions, unions, multi-table joins, scalar functions, outer joins and derived columns.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Excellent analytical, communication and interpersonal skills and also a versatile team player with proven problem solving skills.

TECHNICAL SKILLS

• Business Intelligence Microstrategy Desktop9/ 8.x.x/7.5.2/7i/7.0 Microstrategy Architect, Microstrategy Web, Microstrategy Intelligent Server, Microstrategy OLAP Services, Microstrategy Narrowcast server, Microstrategy DSS
• Databases Oracle 11G/10G/9i/8i, DB2, SQL Server 2005/2000, Netezza.

Related tools

• ETL Tools DataStage, Informatica Power Center
• Operating Systems AIX, Sun Solaris, Linux 6.2/7.0,Windows 2003, 2000, 95, 98, XP,

Windows NT 4.0, MS DOS.

• Server Environment Web Logic 8, Apache 1.3x, IBM Websphere and Tomcat 4.0x/4.1x
• Languages SQL, PL/SQL, Java, Asp.net, C, C++, Java
• Web Technologies HTML, DHTML, CSS, CGI- PERL, VB-Script. JSP, EJB, Javascript
• Front End Tools TOAD, PL/SQL developer, SQL Developer
• Scripting Languages UNIX Shell and Perl Scripting.

PROFESSIONAL EXPEREINCE:

Confidential,Phoenix, AZ Apr’ 2010 – till date
Sr. Microstrategy Developer

Description: The client is one of the biggest Financial Company with wide range of businesses like Brokerage, Project Consulting, Investment Consulting and Venture Capital Investing etc The objective of the project is development of data mart and Reporting System to analyze the expenses incurred on Legal Services based on different regions / divisions etc The data is obtained from disparate sources like flat files, relational tables and Ms-Access tables The data is extracted from the sources using Informatica as the ETL tool and thus obtained data is used in the reports, which are developed using Microstrategy.

Responsibilities:

• Gathered and analyzed business requirements from clients and end users.
• Worked closely with data modeling and ETL teams to develop the data model.
• Used Microstrategy Desktop 9.1 to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Created various Narrowcast reports and schedules.
• Designed advanced Dash Boards, scorecards and report which helped the Managers at higher level to easily analyze the companies performances.
• Created profitability analysis reports based on account, product and customer.
• Created reports based on segmentation analysis and risk management.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Documented all Microstrategy objects like reports, prompts, filters and metrics for user reference. Developed reports for Microstrategy Web users. Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
• Created KPIs and Metrics to analyze the existing system usage and performance using Enterprise Manager Tool.
• Created Complex Filters (Relationship Filters, Dynamic Filters, Embedded Filters, Custom Filters), Compound Metrics with dimensionality.

Environment: Microstrategy 9.1, Narrowcast server 9.1, Microstrategy Desktop, Microstrategy Web, Command Manager, Object Manager, IBM DB2, SQL server 2005, Informatica8.6, Windows XP.

Sr. Microstrategy Developer

Description: The project involved the development of the Virginia Case Management System. This is a java based statewide web application which keeps track of all child care vendors that are registered and authorized to provide services for children throughout the state and information about families living in each area.

Responsibilities:

• Extensively worked in creating complex filters, dynamic filters.
• Involved in creating complex dashboards using widgets and creating fish eye selectors.
• Worked in creating different types of micro charts in dashboards.
• Created custom drill maps as required in reports for drill through functionality.
• Involved in configuring Microstrategy 9.0.1 Suite (Desktop, web application etc…).
• Worked with Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance).
• Created Freeform SQL for generating different complex reports.
• Created several different types of reports (Drill across, Drill through, Business ranking, etc) with complex formatting utilizing Desktop Designer.
• Involved in Testing of reports and Migrated Microstrategy 9 projects from development to acceptance and to production.
• Worked on performance tuning to reduce the runtime of MicroStrategy reports and improved the performance of reports by changing the VLDB Settings, reducing the number of SQL passes, addition index creation etc.
• Worked with back end Database Administrators to provide requirements for necessary back end tables.
• Used Narrowcast Sever for timely delivery of report.
• Created services using subscription sets, schedules, objects.

Environment: Microstrategy 9.0.1, Intelligence Server, Narrowcast Server, OLAP Services, Microstrategy Desktop, Microstrategy Web, Object Manager, Command Manager, Netezza, PL/SQL, Oracle 11g, Informatica Power Center.

Confidential,OH Oct’ 2007-Dec’ 2008
Microstrategy Developer

Limited Brands selected the Microstrategy Business Intelligence Platform as its strategic enterprise reporting and analysis standard. Limited Brands sells women’s intimate apparel, personal care and beauty products, and women’s and men’s apparel under various trade names through its specialty retail stores and direct response (catalogue and e-commerce) businesses. Limited Brands currently uses Microstrategy for calculating the yearly performances and various functional specifications.

Responsibilities:

• Responsible for identifying the business entities and the relations to build an Enterprise Business Model for the Warehouse.
• Created Metadata development for the Microstrategy projects and creating subscription book repositories in Narrowcast Server.
• Designed the Microstrategy projects which involved in creating the Attribute, Facts, and Hierarchies.
• Responsible for creating Metrics, Filters, Custom Groups, Attributes to Attribute Qualification prompts using Microstrategy Agent for report Document.
• Used VLDC settings for the reports when required.
• Developed and customized Ad-hoc reports using templates.
• Created complex compound metrics at different dimensionalities to count the items sold at different store level.
• Responsible for organizing the meeting with the business users to learn about the reporting needs.
• Created Dynamic Dashboards showing organizations yearly performance and analyze the sales, revenue, profits using various graphs and widgets.
• Involved in Administration tasks like creating users, assigning privileges, catching, specifying query governing thresholds, and report optimization.
• Responsible for testing the reports and recording the test cases.

Environment: Microstrategy 8.1.2, Microstrategy Web, DataStage, Object Manager, Command Manager, Narrowcast Server, Microstrategy Architect, SQL SERVER 2005.

Confidential,TX Jul’2006 – Sep’2007
Microstrategy Developer
Description: Friedman’s is a retail Jeweler with more than 500 store locations throughout the Southeastern region with more than 90,000 products in their lineup. Friedman’s recently acquired the Crescent Jewelers and moved their head office from Atlanta, GA to Dallas TX. They use Microstrategy for all their reporting needs.
Responsibilities:

• 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.
• Generated and implemented Microstrategy Application objects by, reports, filters, metrics and templates using Microstrategy
• Responsible for gathering the business requirements from the users, and analyzing the Report Specifications and needs of the end users.
• Creation of Intelligent cubes and sharing to reduce the database load and decreasing the report execution by using the Cube Services.
• Designed reports like Map Application Reports, Adhoc Reports.
• Took help of MicroStrategy Knowledgebase to troubleshoot some Report related issues.
• Used Report cache sharing and Data mart reports to enhance the Report response time.

Environment: Microstrategy Version 8.0.2, Intelligence Server, Desktop, Web, Narrowcast Server, Object Manager, Command Manager, SQL Server 2000.

Microstrategy Developer

Description: Univar USA is a leading chemical distributor in the United States, providing more chemicals and related chemical distribution in the marketplace.

Responsibilities:

• Created the Metadata & Statistic tables for the Microstrategy Projects on a SQL Server Database and was also involved in performance tuning tasks.
• Generated and implemented Microstrategy Schema Objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop and Architect.
• For comparative studies, created reusable Transformation objects that enabled time-series analysis.
• For complex reporting needs, worked extensively on creating Metrics and Compound Metrics, Filters, Custom Groups and Consolidations.
• Customized the Microstrategy Web interface and the Intelligence Server settings for the project.
• Created new users, roles, privileges, shared folders, and access controls lists using security roles as a Microstrategy Administrator.
• Upgraded the Microstrategy Projects from Microstrategy 7i to 7.5.
• Used the Object Manager to move the objects from Development to Production Environment in Microstrategy.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Configured the Enterprise Manager for statistical reporting purposes.
• Responsible for the creation and configuration of the Narrowcast system.
• 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.
• Extensively used Narrowcast Server for personalized report distribution.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.

Environment: Environment: Microstrategy 7.5/7.2.3 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, MDX Adapter) Teradata V2R4, SQL Server, Informatica 6.2

EDUCATION: Bachelors’ in Information Technology