SUMMARY

• 8 years IT Experience and well acquainted as MicroStrategy Developer, Architect and Administrator using MicroStrategy tool Suite 10.x/9.x with Strong Domain Knowledge of Communication in Financial (Bank and Insurance), Healthcare, Retail Services.
• Comprehensive working Knowledge with MicroStrategy Desktop, MicroStrategy Architect, Microstrategy Web, MicroStrategy Narrowcast Server and OLAP Services Environment.
• Extensive Experience in Software Analysis, Design, Development and Production Support of business intelligence application using MicroStrategy.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Experience in Microstrategy Architect, Office, Narrowcast, User security & management, Object Manager & designing reports (grid, drilldown, ad hoc, OLAP cube) and dashboards in Microstrategy 9 & Microstrategy 10.3
• Solid experience in business requirements analysis, proof - of-concept design, development, testing and documentation of EnterpriseData Integration, Business Intelligence applications, Master Data Management (MDM), Data Quality and Data Governance.
• Extensive experience in developing Business Intelligence applications for cross-functional teams on multiple projects and across multiple environments using MicroStrategy.
• Strong technical knowledge of Data Warehousing concepts, Dimensional, Logical and Physical data modeling, Star and Snow Flake Schemas, Slowly Changing Dimensions and ROLAP/MOLAP.
• Expertise in building MicroStrategy Business Intelligence Projects and creating Schema and Application Objects like Attributes, Facts, Hierarchies, Filters, Metrics, Prompts, Reports, Documents, dynamic Dashboards for day-to-day fact-based decision making and ad-hoc analysis.
• Hands on experience in MicroStrategy System Administration and Architecture including Intelligence Server installation and configuration, setting up the Metadata, creating users, user groups, Object Manager migration, Enterprise Manager monitoring and performance tuning.
• 6 years of experience in developing SQL, PL/SQL procedures, views, triggers and other components on databases such as Oracle, SQL Server, Teradata and Netezza, DB2.
• Good working knowledge of Extraction, Transformation, and Loading of data from different sources using ETL tools such as Informatica, Oracle Warehouse Builder.
• Working familiarity with full Software Development Life Cycle (SDLC) of Data Warehousing and Business Intelligence projects using various development methodologies like Agile and Waterfall.
• Experience in developing commercial enterprise applicationsusingASP.Net, C#, Java Script, SQL and PL/SQL.
• Experience in domains like Retail, Financial Services, Pharmaceutical, Government, Insurance and Manufacturing and functional knowledge in deploying business intelligence thinking in areas related to Sales, Store Operations, Marketing, Supply Chain and Distribution Management, Finance, Market Research, Investor Relations, Strategic Insights & Analysis and Resource Planning.
• Dedicated team player with strong analytical, presentation, training and project management skills along with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Business Intelligence Reporting Tools: MicroStrategy Intelligence Server 10.x/9.x/8.x, MicroStrategy Architect 10.x/9.x/8.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Report Services, MicroStrategy Distribution Services, MicroStrategy Mobile, MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Office, MicroStrategy Object Manager, MicroStrategy Command Manager, Narrowcast Server

Databases: Oracle, SQL Server 2012/08R2/05, Teradata, Netezza, DB2, MS Access IBM DB2, MS Access 2000 and Teradata V2R4.1, V2R6.0 Programming SQL, PL/SQL, ASP .Net, ADO .Net, C#, XML, Java Script and HTML

ETLTools/ Packages: Informatica, Oracle WH Builder, Master Data Management, SSH

Data Modeling: Erwin, Microsoft Visio, Dimensional and Relational Modeling, Star and Snow-Flake Schemas, Slowly Changing Dimensions, Logical and Physical Modeling.

Languages: C, Java, SQL, PL/SQL, Transact SQL

Web: HTML, DHTML, XML, XSL, JSP, JavaScript, Microsoft Front Page, Excel and Home Site 4.0.

Environment: s: Windows Server, Linux 5 Windows 7/8, Apache Tomcat, VMware, Bourne Shell.

PROFESSIONAL EXPERIENCE

Confidential, Camden, NJ

Sr. Microstrategy Developer/ Architect

Responsibilities:

• Involved in the meetings with business users to discuss and finalize the requirements and design of the reports
• Migrated various reports and objects to MSTR 10.X from SAP HANA.
• Created several Schema and Public objects as per the Business rules.
• Created logical data models to recognize source tables and columns to build MicroStrategy Schema Objects including attributes, Facts Hierarchies and Relationships necessary to create Microstrategy Project.
• Generated reports for the cooperation for assets period to period.
• Generated Key Performance Indicators KPI metrics to metrics.
• Developed Flash Dashboards & Scorecards in Micro Strategy 10 using Widgets and Selectors for summary level reporting.
• Managed projects through entire Systems Development Life Cycle, including creating timely thorough status reports and leading status meetings.
• Proactively created report formats and delivered personalized messages from the BI platform through Micro Strategy Narrowcast Server to a wide range of users.
• Developed and maintained the reporting solutions for the release and deployment between enterprise environments -QA and production migrations of MicroStrategy objects.
• Worked closely with business users and other development teams in all stages of the BIdevelopmentlifecycle.
• Involved in report trouble shooting/Performance using VLDB properties.
• Assisted with user support and training and creation of Adhocdata warehouse queriesasneeded.
• Expertise in developing Microstrategy reports by combining multiple reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Performedinstalling, configuring,andadministeringMicroStrategyIntelligenceServer, Web Server, and Mobile Serve.
• Also involved in migration using Object Manager.
• Worked on Performancetuningandstresstestinginitiatives.
• ParticipatedandcontributedtotheBIstrategy.

Environment: MicroStrategy 10.3 (Architect, Intelligence server, Web, Web Universal, Desktop), SAP HANA, Oracle DB, Report Services, Teradata, SQL Server, Windows Server 8.

Confidential, Richmond, VA

Sr. Microstrategy Developer

Responsibilities:

• Worked closely with data warehouse and ETL teams on designing flexible and scalable data models for ROLAP across all enterprise data assets.
• Co-ordinated meetings with clients and business users to discuss and understand requirements.
• Involved in discussion with data modelers to understand data modeling of existing schema.
• Involved in the complete Life Cycle of the project.
• Worked with client to gather requirements and prepared technical specifications documents.
• Responsible for the preparation and presentation of proto-type reports to end users and get acceptance to develop reports.
• Responsible for gathering requirements from Business User and creating mockups.
• Worked with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Created Application Objects like Metrics, Filters, Prompts and Reports using Microstrategy Desktop.
• Created Intelligent Cubes, Intelligence cube reports, View Filters and Derived Metrics.
• Created transformations using Transformations by tables and expressions for Time Series Analysis.
• Created Schema Objects like Facts, Attributes and Hierarchies in Microstrategy Architect and dealt with the MSTR Administration.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics and Transformation Metrics.
• Created Advanced Filters like Attribute-to-Attribute comparison filters, Joint Element List filters and Relationship filters.
• Worked closely with various teams across the organization to identify and solve business challenges utilizing large structured datasets.
• Created Stored Procedures to support reports.
• Created Dashboards with multiple attribute element selectors, metric selectors and metric condition selectors.
• Used various selector styles like Button Bar, Radio button, Check Box, Drop Down, List Box and Link Bar. Also used Analytic-Based selectors in Dashboards.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.
• Created and deployed Mobile/IPad Dashboards.
• Provided post production support for users & resolved defects during the QA and UAT process.

Environment: MicroStrategy 9.2.1 (Architect, Intelligence server, Web, Web Universal, Narrowcast server, Desktop), Report Services, Oracle 10g, Teradata, Toad,SQL Server, ERWIN, Windows Server 8.

Confidential, CO

Microstrategy Report Developer

Responsibilities:

• Analyzed the business requirements identifying the requirements reviewing and communicating with business.
• Worked with Data Architect and Admin in Designing the DataModel.
• Installation of Microstrategy Desktop and creating a Microstrategy project.
• Creating Attributes, Facts and relationship between attributes using Microstrategy Architect.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Generated and implemented Microstrategy reports by creating projects, Attributes, Hierarchies, Metrics, filters, and Templates using Microstrategy Architect.
• Created Dashboards using SAP Business objects Xcelcius Dashboards parallel.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects XI connected to Oracle data source.
• Source filed the require data for the company’s objectives as an Microstrategy Admin.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics, Derived Metrics and Advanced Filters.
• Analyzed and developedthe new objects in Dev environment and after testing the objects and reports migrated to Production Environment
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Defining Drill Hierarchies and creating relationship between attributes.
• Made auto prompt filter feature to give the end user an option of various filtering criteria each time they run the report.
• Created reports using complex filters and compound metrics and prompts.
• Creating reports from intelligent cubes, DataMart Reports.
• Strong knowledge in creatingIntelligent Cubes which will give the performance when executing the reports and also enabling Dynamic Sourcing for specific cubes.
• Worked on Creating Security Roles, Microstrategy User Groups and Users, assigning security roles to Users and Groups.
• Involved in creating security filters to end users to access data based on their privileges.
• Created services using Subscription sets, Schedules, and Information Objects.
• Designed and developed the Dynamic dashboards.
• Created Datasets for the Dynamic dashboards using various selectors, panels and widgets.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Experience in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects architecture, software deployment, infrastructure maintenance, business objects and system administration, BOE Security, Universe/Report/Dashboard development, documentation, Production Support and user trainingin this project.

Environment: Microstrategy 9.2.1, Report Services, Microstrategy Desktop, Microstrategy Web, Mobile, Microstrategy Dashboards, MS-Excel, Toad, Oracle 10g.

Confidential, Gaithersburg, MD

Sr. Microstrategy Consultant/ Admin

Responsibilities:

• Involved in Full product life cycle like configuring the intelligence server by providing the server definition.
• Setup the project sources, creating projects, duplicating projects, moving projects, deploying projects, mapping the warehouse catalog, creating metadata tables and statistics tables, creating necessary MicroStrategy objects.
• Designed, developed and architected a MicroStrategy project that accesses prescriber, hospital and sales representative information and generates reports for the sales operations department.
• Involved in collecting the business requirements and documenting the specifications.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Created complex filters with advanced qualification involving 'ApplySimple' and 'ApplyComparison' functions.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Gathered requirements from the users and defined KPI's to build scorecards and dashboards.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Created advanced grid reports, consisting of data analysis by combining a template with filters.
• Worked as a support resource for other related projects and was responsible for re-architecting required changes and checking the report results in QA.
• Involved in project migration application of contents like users, groups and reports using duplicating wizard.
• Tested all the reports by running queries against the warehouse usingSql Navigator. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Worked with Narrowcast configuration and involved in administration issues.
• Responsible documentation and configuration of Enterprise Manager for logging statistics and advanced reporting purposes.
• Reduced the time taken for the reports to run by taking advantages of VLDB properties like join, query and sub query optimizations.
• Upgradation of Microstrategy 8.1 version to Microstrategy 9.0 by keeping a backup of metadata.

Environment: MicroStrategy Desktop 8.1.1/9.0.1 , MicroStrategy Object Manager, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy SDK, Dashboards, Adobe Flex, SQL Server 2008, Teradata V2R6.0, Erwin 4.5 and Windows 2003.

Confidential, Chicago, IL

Microstrategy Developer

Responsibilities:

• Involved in Requirements gathering by interacting with the nationwide Internet Business Users.
• Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
• Generated and implemented MicroStrategy Reports by creating Schema and Public Object 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.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment.
• Developed the single sign on universal login integrating the MicroStrategy metadata password with SiteMinder.
• Created Aggregate Tables, Control Tables and Staging tables in Teradata.
• 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.
• Created complex custom groups using hierarchy to overcome the restriction of MicroStrategy where total on columns and average on rows cannot be calculated at the same time.
• Created Report Services Documents out of existing reports and customized them to reflect the Company's logos and color palette.
• Designed various prototypes of dashboards using MicroStrategy, which would give ability to the users to drill down to claim (lowest) level.
• 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.
• Experienced in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom Group objects in an enterprise data warehouse team environment.
• Extensively worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Environment: MicroStrategy Desktop 9, MicroStrategy Web, MicroStrategy Administration, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MS SQL Server 2003, Windows XP.

Confidential

Data Warehouse Developer

Responsibilities:

• Migrated large volumes of ETL data from legacy systems to Oracle database.
• Extensively designed Data mapping and filtering.
• Enhancements and Functional Specifications.
• Consolidation, Cleansing, Integration, ETL, and customization of data.
• Optimized Query Performance, Session Performance and Reliability.
• Created complex procedures.
• Database connectivity is done using ODBC.
• Preparation of Unit Test Plans.
• Verification of functional specifications and review of deliverables.
• Complex SQL queries are used for data retrieval.
• Maintain and followed established client Software Development Life Cycle (SDLC) methodologies on all projects
• Migration of reports from Crystal Reports to Business Objects.

Environment: Informatica Power Center 5.1, Business Objects, Erwin Tool 3.2, Shell Scripting, Crystal Reports 6.5, Oracle 8i, COBOL.