EXPERTISE:

• Around 6 years of IT experience in Business Requirements Gathering, Application Design, Data Modeling, Development, Implementation and Testing of Client/Server applications, with a sound working knowledge in Data Warehousing/Business Intelligence systems for Financial, Pharmaceutical, Retail and Health Care industries.
• Experienced in developing reports in Visual Studio and deploying them to Report Manager.
• Experienced in MicroStrategy DSS Suite namely MicroStrategy Desktop Designer, MicroStrategy Intelligence Server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web and MicroStrategy Narrowcast Server.
• Installed and configured various components of MicroStrategy at Enterprise Level.
• Experienced in migratingCognosreports and SSRS reports to MicroStrategy reports.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experienced in gathering requirements with end users, understanding business requirements, product demonstration and product support using MicroStrategy as a BI tool.
• Acquired experience with the full life cycle of Software Development (Planning, Analysis Design, Deployment, Testing, Integration and Support).
• Extensive knowledge in creating MicroStrategy Objects (Facts, Attributes, Filters, Metrics, Prompts, Hierarchies, Consolidation, Functions) using the Data warehouse.
• Experienced in migration of objects between different environments using Object Manager.
• Strong knowledge in SQL, MicroStrategy Query Trouble shooting, Performance Tuning using VLDB Settings.
• Proficient in SQL* plus and PL/SQL. Extensive experience with SQL and sound working knowledge of Oracle Database (including stored procedures and SQL programming).
• Excellent skills in advanced Report Authoring which includes Conditional Formatting, using Filters.
• Good Communication and Interpersonal Skills, resulting in excellent rapport with employees and executive management.
• Quick learner and adaptive to any environment.

TECHNICAL SKILLS

BI Tools Microsoft SQL Services Reporting Services, MicroStrategy 9.0, 8.1.1, 8.1.2, 7.0/7.2.3/7.2.4/7.5.1/7.5.3 (MicroStrategy Desktop Designer, MicroStrategy Architect, Object Manager, NarrowCast Server, Administrator), Cognos 8.
Data Modeling Tools Erwin, Transformer.
Reporting Tools MicroStrategy, Cognos Reporting tools, SQL* Plus, Microsoft SQL Server Reporting Services.
ETL Tools Informatica 7.1.3, Informatica 8.1.2
RDBMSOracle Database 11g/10g/9i/8i, SQL Server2005/2008/2010, MS Access, DB2, Netezza
Languages PL/SQL, SQL, C, C++, Java, VB
Web Technologies Microsoft IIS, HTML
Operating Systems Unix, Linux, Windows 95/ 98/ NT/ 2000/ XP/7

EDUCATION:

Bachelors of Computer Science & Engineering
Masters in Management Information Systems

PROFESSIONAL EXPERIENCE:

Confidential
Duluth,GA
Role: Business Intelligence Reporting Analyst Jan'12-Present
Confidential, provides workers\' compensation and auto insurance carriers, third party administrators (TPAs), managed care organizations (MCOs), government agencies and self-insured employers with outcome-focused, customer-driven solutions. Utilizing market-leading technology, Healthcare Solutions is redefining the management of claims related expenses. It delivers demonstrated benefits and savings complemented by deep industry expertise. This project involved in migration of existing SSRS reports to MicroStrategy reports.

Responsibilities:

• Worked with various internal departments (Pharmacy-Operations, Specialty Services, Finance, Account Management and Marketing) to understand, gather and analyze Business Requirements.
• Involved in user sign-off meeting to lock business requirements.
• Developed and ran scripts in command manager to create facts, attributes, and metrics.
• Created and used prompts, consolidations, filters and other objects using Desktop Designer in developing user specific reports.
• Developed advanced reports using features such as prompts, filters, consolidated elements.
• Developed grid reports, templates, graph reports, report services documents, dashboards using Desktop Designer.
• Developed many free form SQL reports to meet user requirements.
• Responsible for performance tuning of SQL queries/reports by changing VLDP properties, caching reports, identifying columns for index creation, working with DBAs on temp segment allocation issues, creating summary tables, reducing the number of tables in join conditions.
• Analyzed and created business intelligence reports in both SSRS and MicroStrategy according to business requirements.
• Consolidated existing SSRS reports to MicroStrategy reports without losing the functionality.
• Worked closely with the MicroStrategy Admin team during the project migrations and fixing the metadata issues.
• Migrated objects and projects between Environments.
• Created subscriptions to email reports to various groups and individuals.
• Served as a liaison between the development & business requirements teams and between development and QA teams.
• Conducted data validation testing to ensure data quality.
• Involved in documentation and end-user training on using of existing templates for Ad hoc reporting.

Environment: MicroStrategy 9.0.2(Desktop Designer, Architect, Object Manager, Administrator, Office, Distribution Services, Intelligent Server), SQL Server 2008, Visual Studio 2008, Report Manager, IIS 6.0, Windows 2008.

Confidential
Columbia, MD Jun'11-Dec'11
Role: Business Intelligence Consultant
Confidential, is a leading customer relationship marketing agency. Merkle offer's quantitative, information-based solutions that maximize return on marketing investment (ROMI). This project involved in providing BI reporting solutions to Bose using MicroStrategy as a BI tool.

Responsibilities:

• Participated in requirements gathering process to bridge gap between user needs and tool functionalities.
• Analyzed and defined required attributes and hierarchies, and determined solutions to design issues.
• Created new projects and project objects in MicroStrategy for analytical reporting.
• Refine reporting requirements, designed and developed client specific dashboards and assigned privileges for end users to access them.
• Developed new reports in Desktop Designer upon requests from business users.
• Developed standard templates in Desktop Designer for developing reports.
• Created grid reports, graph reports, drill down and drill through reports.
• Involved in applying conditional formatting to reports.
• Migrated objects and projects between environments.
• Optimization and Performance Tuning of queries and reports using VLDB properties.
• Developed scripts for creating, modifying and deleting users, security roles.
• Scheduled periodic refreshes of reports using Scheduler.
• Documented functional and technicaldesignspecification and user guides.
• Coordinated training sessions and demonstrated MicroStrategy tools to End-users.

Environment: MicroStrategy 9.0.2(Desktop Designer, Architect, Intelligent Server), Netezza, Aginity Workbench, SQL Server 2008/2010,Informatica 8.1.2, Putty, IIS 6.0.

Confidential
Lockheed Martin, Windsor Mill, MD Apr'08-Apr'11
Role: Business Intelligence Data Analyst
Confidential, provides critical reporting and analysis on the Center for Medicare Medicaid's (CMS) Medicare contact center operations. Lockheed Martin (LM) has been tasked with continuing the on-going development of the National Data Warehouse and maintenance as an efficient and cost-effective data warehouse and reporting solution that provides timely, accurate, consistent, comprehensive, and relevant information at all times. This project involved in migrating existing Cognos Reports to MicroStrategy Reports.

Responsibilities:

• Worked closely with users & requirement analyst in gathering and documenting the business requirements.
• Participated in review, sign-off and communication of all changes or modifications to specification documents.
• Analyzed existing Cognos reports and documented the Report Design Documents to build reports MicroStrategy.
• Involved in Security Administration for setting up users, groups and roles and creating access permissions through User Manager.
• Deployment of the objects, reports and projects from Development to Test and Production environments using Object Manager and Project Merge.
• Involved in identifying and creating numerous MicroStrategy Attributes, Hierarchies, Facts - Metrics, Filters (Security Filters), Prompts, Drill Maps, Custom Groups, Consolidations, Auto Styles, Search Objects, Transformations and Templates using MicroStrategy Desktop Designer.
• Analyzed and converted existing Cognos reports to MicroStrategy Reports.
• Consolidated existing Cognos reports (around 300 reports) to MicroStrategy reports(around 100 reports).
• Designed and developed numerous new reports including Portal Landing Page, which includes key performance indicators (KPI) of the client.
• Developed simple, Ad hoc reports and advanced reports using MicroStrategy Desktop Designer.
• Created grid reports, charts, templates, report services documents with multiple prompts and filters.
• Designed and developed dashboards with rich formatting based on user requirements and assigned privileges for end users to access dashboards.
• Involved in applying conditional formatting, created object prompts and value prompts to generate user specific reports.
• Created various linked reports like drill through and drill across.
• Involved in scheduling the reports and creating jobs through Schedule Manager.
• Developed report templates in Desktop Designer by which users can create Ad hoc reports.
• Prepared the document templates for MicroStrategy reports and documented the existing and new reports.
• Served as a liaison between the developer team and the QA team.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Optimized queries for the better performance of the reports.
• Involved in unit testing, regression testing and validation of reports to ensure data quality and report quality.
• Took a lead part in weekly developers meeting for the enhancements of existing reports.
• Provided Production Support.

Environment: MicroStrategy 9.0/8.1.2(Desktop Designer, Architect, Object Manager), Cognos 8.1, Informatica 7.1.3, Informatica 8.1.2, Oracle 10g, Oracle 11g, Siebel, MS-Access, Unix, MKS.

Confidential, PCS Division San Francisco, CA Aug'07-Mar'08
Role: Sr. MicroStrategy Developer
Confidential, is one of leading financial institutions in USA with operations in various areas like Banking, Stock Markets, and Mortgage etc. This project is to build Reports on a Data mart (Brokerage Data mart) which gives analytical data for Brokerage related operations of Wells Fargo's stock broking division. This project involved in migrating existing Hyperion Interactive Reports to MicroStrategy Reports.

Responsibilities:

• Involved in gathering and analyzing Business requirements.
• Involved in the Installation and Configuration of Development ( & Test) and Production servers.
• Creating and Applying Security and User Authentication to the various User Groups through User Manager.
• Ran scripts to create facts, attributes, metrics in Command Manager.
• Analyzed existing Hyperion Interactive reports and documented the Design Documents to build reports MicroStrategy.
• Build various MicroStrategy objects(Attributes, Facts, Metrics etc).
• Involved in creation of advanced reports using MicroStrategy Desktop Designer.
• Migrated Hyperion Interactive reports to MicroStrategy reports.
• Developed Grid reports, Templates with multiple prompts, cascading prompts and Filters.
• Created dashboard, report services documents with complex formatting.
• Created Dashboards for a better understanding of the business performance metrics.
• Created and applied attribute filters, metric filters, consolidations and functions to generate user specific reports.
• Used different types of Transformation metrics in creating client detailed reports.
• Created several different types of reports (Mailing Labels, Web Page Style, Cascading, Dill Across / Drill Through, Business, Ranking, etc…) with complex formatting utilizing Desktop Designer.
• Scheduled reports, report services documents and dashboards using Schedule Manager.
• Distributed reports to different users and users groups using NarrowCast.
• Designed several folders and assigned privileges according to user specifications.
• Used object manager, project merge to perform migrations.
• Worked heavily on performance tuning to reduce the run time of MicroStrategy reports and improved the performance of reports by changing the VLDB settings, reducing the number of SQL passes, additional index creation, etc.
• Trained users on navigation and creating simple reports using templates and used to provide on call support for the users.
• Given production support.

Environment: MicroStrategy 8.1.2(DesktopDesigner, Architect, Object Manager), Hyperion Interactive Reporting, Informatica 7.1.3, Oracle 10g, Oracle 9i, DB2, Windows 2000, PL/SQL, Web Services, GUI, LDAP.

Confidential, India May'04 - Dec'05
Role: MicroStrategy Developer
Manufacturing Resources Planning includes modules such as Purchases, Sales and Stores for Reddy Labs Purchases module efficiently monitors purchase requisition inquiries, quotations, purchase order and tracking pending order supplies and follow-ups. It provides facility for purchase indent, authorization of intent, order preparation, order amendment and various reports. This module provides the information about the status of sales order information. Stores module takes care of effectively Inventory management by regulating process of receipt and issue of items at stores.

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation, development, testing to production of end user reports.
• Participated in requirements gathering process to bridge gap between user needs and tool functionalities.
• Analyzed and defined required attributes and hierarchies, and determined solutions to design issues.
• Created new projects and project objects in MicroStrategy for analytical reporting.
• Refine reporting requirements, designed and developed client specific dashboards and assigned privileges for end users to access them.
• Developed new reports in Desktop Designer upon requests from business users.
• Developed standard templates in Desktop Designer for developing reports.
• Created grid reports, graph reports, drill down and drill through reports.
• Involved in applying conditional formatting to reports.
• Migrated objects and projects between environments using Object Manager and Project Merge.
• Optimization and Performance Tuning of queries and reports using VLDB properties.
• Developed scripts for creating, modifying and deleting users, security roles.
• Scheduled periodic refreshes of reports using Schedule Manager.
• Documented functional and technicaldesignspecification and user guides.
• Coordinated training sessions and demonstrated MicroStrategy tools to End-users.

Environment: MicroStrategy 7.5.3, SQL Server 2005, Windows 2003, IIS 6.0, Web Services, GUI, LDAP.