SUMMARY

• 8+ years of extensive work experience in the field of Information Technology implementing Data warehousing, Decision Support Systems.
• Full life cycle implementation experience encompasses Business Requirements definition, Data Analysis, Data Warehouse Architecture, Deployment, Logical and Physical Data Modeling, Gap Analysis, Data Conversion, Validation, Testing Methodologies (unit, integration, stress, and bug tracking and fixing), Designing and Developing ETL modules, Building various types of Operational Data Stores (ODS), Documentation, Production Migration, Post Implementation Support, Assessment and Enhancement and Refinements for various Business Intelligence Applications.
• Very good experience in RDBMS such as Oracle, Teradata, DB2, SQL Server.
• Experience in operating systems such as UNIX, AIX, HP - UX, and Windows NT/2000/ 98/95.
• Well versed with the MicroStrategy product suite namely MicroStrategy Desktop, MicroStrategy Intelligence server, MicroStrategy Architect, MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Mobile, MicroStrategy Dashboards and MicroStrategy Narrowcast Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Extensively worked on MicroStrategy system administration in setting up the Metadata, configure the Intelligence server, creating users, user groups, security filters, roles & privileges and Performance tuning of the reports.
• Expertise in working with very large databases like Teradata, Oracle, SQL Server, DB2 with MicroStrategy Suite.
• Created complex Reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Designing Data Marts using different multidimensional modelling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modelling.
• Handled Slowly Changing dimensions in a Data warehouse depending on the changes in business dimensions.
• Worked with Stored Procedures and Functions in PL/SQL and also constructed complex SQL queries to troubleshoot the queries.
• Wealth of experience in building Data Warehouse solutions utilizing Ralph Kimball and Bill Inmon’s Methodologies (Star, Snowflake, & dimensional data modeling)
• Well versed with the Extraction Transformation and Loading (ETL) processes.
• Demonstrated ability to work effectively with all levels of staff, customers and other IT personnel
• Capable of translating complex business needs into technical solutions (i.e. ability to understand the users' requirements).
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• 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 modelling.
• Intensive experience and exposure to all aspects of MicroStrategy application such as Administration, Architecting and Development.
• Quick learner, ability to work in groups or alone, ability to work on tight schedules.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.

TECHNICAL SKILLS

BI Tools: MicroStrategy10.x/9.x/8.x/7.x (Micro Strategy Desktop/ Web), SQL Server Reporting Services, OBIEE, Web focus.

Data Modeling Tools: Erwin Tools

ETL Tools: Composite, Informatica Power Center 9.1, SQL Server Integration Services

Testing Tools: ALM, HP Quality Center, HP UFT/ Quick Test Professional, Test Director, Load Runner.

Operating Systems: Windows 10/ 8/7/Vista/XP, Windows NT, UNIX, Linux.

Programming: C, C++, SQL, PL/SQL

Scripting Language: HTML, CSS,Java

RDBMS: Oracle 12c/11g/10g, Toad9.1, SQL Server 2008 R2, 2012 and DB2, Netezza7.2.x

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket RI

Microstrategy Architect/Developer

Responsibilities:

• Involved in Analyzing, developing and migrating of retail and pharmacy reports.
• Extensively worked in migrating SSRS, OBIEE, WEB FOCUS reportstoMicroStrategy reports
• Highly analytical in developing the methods and measures to meet requirements and solve any issues that arise in development phase.
• Possesses excellent communication, documentation and organization skills with the ability to adapt to a new environment & meet stringent deadlines.
• 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.
• Worked on upgrading and testing the MicroStrategy project created in Micro Strategy version 9.4.1 to Version 10.2,10.3
• Involved indocumentationandend-user trainingon using of existing templates forAdhocreporting.
• Created and implemented MicroStrategy Reports by creating Schema and Public Objects like attributes facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Developed free form SQLreports to meet user requirements.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Created Intelligent Cubes to speed up the process of data retrieval and used Dynamic Sourcing.
• Worked extensively on Performance tuning to reduce the run time of MicroStrategy, reports drastically by changing the VLDB properties, reducing the number of SQL passes, additional index creation etc.
• Improved the performance of the report by configuring ODBC connection while using multisource.
• Created Dynamic Dashboards showing Company’s yearly performance using various graphs and widgets.
• Created Logical Views for developing reports used in MicroStrategy environment.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Environment: MicroStrategy 10.2, 10.3 Product Suite (Architect, Developer, Web, Distribution services, Object Manager), SQL Server 2008R2,2012, Visual Studio 2008, Report Manager, Windows 2010, Composite, Oracle 11g, Toad, OBIEE 10.1.3.3.

Confidential, Charlotte NC

Microstrategy Architect/Developer

Responsibilities:

• Gathering requirements with end users, understanding business requirements, product demonstration and product support using MicroStrategy.
• Extensively worked in migrating SSRS reportstoMicroStrategy reports
• Worked on upgrading the MicroStrategy project created in Micro Strategy version 9.4.1 to Version 10.2
• Created and usedprompts, consolidations, filtersand otherobjectsusingDesktop in developing user specific reports.
• Created Data Mart Reports using Complex Filters and Compound Metrics.
• Developed advanced reports using features such asprompts, filters, consolidated elements.
• Developedgrid reports, templates, graph reports, report services documents, dashboardsusingDesktop
• Developed manyfree form SQLreports 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.
• Creating solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Generating periodical reports based on the statistical analysis of the data from various time frames using MicroStrategy Reporting
• Analyzed and created business intelligence reports in bothSSRSandMicroStrategyaccording to business requirements.
• Consolidated existingSSRS reportstoMicroStrategyreports 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.
• Created several different types of reports (Mailing Labels, Web Page Style, Cascading, Drill Across/Drill Through, Business, Ranking, etc.) withcomplex formattingutilizing Desktop.
• Scheduled reports, report services documents and dashboards using Schedule Manager.
• 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 indocumentationandend-user trainingon using of existing templates for Adhocreporting.
• Build reports with view filters and derived metrics on a report for further analysis of report which reduced Database load and improved response time to end users.

Environment: MicroStrategy 10.2 Product Suite (Architect, Developer, Web, Distribution services, Object Manager), SQL Server 2008R2,2012, Visual Studio 2008, Report Manager, Windows 2010, Composite, Oracle 11g, Toad.

Confidential, San Jose CA.

MicroStrategy Architect/Developer.

Responsibilities:

• Worked with the end users and business analysts in gathering the requirements.
• Generated MicroStrategy Reports by creating Schema and Public Object like attributes facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Experience with Object manager and Enterprise manager to maintain object throughout the project life cycle and improving performance of the system.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Used MicroStrategy Developer to build schema objects Hierarchies, Transformations, Attributes, Facts and Relationships as a function of the logical model.
• Created reports based on segmentation analysis and risk management.
• Worked on healthcare effectiveness dashboard to analyze measures.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Applied OLAP and statistical functions for analyzing the differences in the revenue generated by a particular segment of customers.
• Optimized Query Performance by using VLDB settings at report and project levels
• Created Dynamic Dashboards showing Company’s yearly performance using various graphs and widgets.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in MicroStrategy environment.

Environment: MicroStrategy 9.4.1 Product Suite (Architect, Developer, Web, Distribution services, Object Manager), Teradata, SQL Server 2008 R2, TD SQL Assistant, Windows 8.

Confidential, Jersey City, NJ

MicroStrategy Architect/ Developer/Admin.

Responsibilities:

• Involved in Requirements gathering by interacting with the Business Users.
• Generated and implemented MicroStrategy Reports by creating Schema and Public Objects like attributes facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Designed Prompts and Filters to generate reports in grid and graph mode.
• Created Intelligent Cubes to speed up the process of data retrieval and used Dynamic Sourcing.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• Created new users, roles, privileges, shared folders, access controls Lists using Security Roles in MicroStrategy.
• Created various subscriptions and schedules.
• Worked extensively on Performance tuning to reduce the run time of MicroStrategy, reports drastically by changing the VLDB properties, reducing the number of SQL passes, additional index creation etc.
• Improved the performance of the report by configuring ODBC connection while using multisource.
• Created Dynamic Dashboards showing Company’s yearly performance using various graphs and widgets.
• Created several Custom tables and Views for developing reports used in MicroStrategy environment.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Environment: MicroStrategy 9.4.1 Product Suite (Architect, Developer, Web, Object Manager, Enterprise Manager, Command Manager), Composite, Oracle 11g, Toad, Informatica power center, Windows 7.

Confidential, Allegan, MI

MicroStrategy Architect/ Developer

Responsibilities:

• Constructed reports with view filters and derived metrics on a report for further analysis of report which reduced Database load and improved response time to end users.
• Participated in the end user meetings to get the business requirements from users to create reports.
• Created Conceptual Approach and Detail Design Documents for the reports for the acceptance and including installing, configuring, and administration of MicroStrategy tools.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to the business needs.
• Communicated with the business, Data Modelling team and ETL team in various levels for the stabilization of the reports.
• Communicated with business for gathering information’s, designing, developing, administrating and maintaining MicroStrategy based reporting applications.
• Involved in performance enhancement and tuning of MicroStrategy projects for better performance, accurate SQL and report.
• Extensively Created Metrics, Prompts, Transformations and Filters to generate reports for the Business Analysis.
• Created reports for Daily, Weekly, Monthly, Quarterly and yearly for various transactions of Business.
• Extensively worked in developing Report Services Documents, HTML Documents according to Business Requirements
• Development of Dashboards and scorecards for management reporting using Document Services.
• Conducted Unit/System/User Acceptance testing on the MicroStrategy objects Developed.
• Experienced in managing reporting teams, platforms, and cross team projects.
• Implemented drill functionality on the reports using Drill Maps.

Environment: MicroStrategy 9.2.1/8.1.2 (Architect, Desktop, Web, Distribution services, Object Manager), Informatica, Oracle 11g, Teradata, HTML & DHTML, Windows XP.

Confidential, Chicago, IL

MicroStrategy Architect/ Developer.

Responsibilities:

• Worked with team of MicroStrategy developersandETL Team for onsite and offshore. Extensively involved in Data modeling, ETL Mapping, Administrator tasks, Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.
• High user interaction, understanding their requirement
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Developed the reports against Star Schema and Snow-Flake Schema.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
• Actively participated in developing Report Delivery Schedules
• Created various Monthly DynamicDashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.

Environment: MicroStrategy 9.1(Desktop, Web, Narrowcast Server, Intelligence Server) Teradata V2, Aster Data, Oracle 10g/11g, Erwin Data Modeler 4.1, Informatica Designer 6.0, Windows 2000/NT.

Confidential, Columbus, OH

MicroStrategy Architect/ Developer.

Responsibilities:

• High user interaction, understanding their requirement.
• Extensively worked in creating and integrating Microstrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Huge amount of performance improvement done on existing documents by using main strength of MicroStrategy like report cache and intelligent cubes.
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Extensive administrative experience creating user, setting up privileges. Security access to metrics and attribute level.
• Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services
• Actively participated in developing Report Delivery Schedules.
• Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• High end experience with OLAP services. Understanding of MicroStrategy architect and its data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, ETL process, metadata, project source and project.
• Expertise in creating complex reports like Drill Down and Sub Reports and implementing Conditional Formatting, Interactive Sorting, Grouping and Filtering.
• Developed the reports against Star Schema and Snow-Flake Schema.

Environment: MicroStrategy 9.0.2(Desktop, Administrator, Architect, IntelligenceServer, Web, Agent), Informatica, Object Manager, Teradata V2R5, SQL Server, Oracle10g, Erwin, Informatica 6.2, MS SQL Server, DTS, Teradata, Windows

Confidential

MicroStrategy Developer

Responsibilities:

• Full Life cycle project Development
• Gathered the Reporting requirements from business user and created BRD (Business Requirement documents) for SDLC process.
• Built Logical Views in MicroStrategy 9.0.1 to combine warehouse tables at runtime during report execution.
• Developed highly prompted report builder for flexible but controlled ad-hoc reporting. Set up user friendly web options such as hierarchical browsing, since 90% of the end users access the tool through MicroStrategy Web
• Implemented a 3-tier reporting architecture with MicroStrategy Intelligence Server with star schema to fit reporting, query and business analysis requirements.
• Utilized many advanced VLDB settings to achieve execution efficiency and to meet reporting requirements.
• Architected the project. Created Reports and Report Services Documents. Created Narrowcast Services
• Created schema objects like Attributes, Facts, Hierarchies, Transformations and Public Objects like Metrics, Filters, prompts, Consolidations, Custom Groups, Drill maps and Templates
• Analyzed and developed partitioning and indexing strategies for performance improvement.

Environment: MicroStrategy 9.0.1/8.1.2 Product Suite (Architect, Desktop, Web, Narrowcast Server, Object Manager, Enterprise Manager), Teradata, SQL Server 2008, Toad, Windows NT.