SUMMARY:

• 9+years’ IT Experience with well acquainted in performing as MicroStrategy Developer and Architect with strong domain knowledge of Communication, Financial, Pharmaceutical and Retail.
• Extensive experience as MicroStrategy Developer building projects and creating reports and dashboards using MicroStrategy 10.x/9.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Architect, Distribution services and OLAP services.
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Facts, Prompts, Templates, Consolidation and Custom Groups).
• Extensive knowledge on Metrics, Graphs, Data group, Explore the data, Visualize the data, Drill Through the data, Adhoc reports.
• Experience in MicroStrategy schema & application layer, report analysis &report services (dynamic dashboards) design, development, implementation, migration and testing.
• Well versed in developing interactive Dashboards and Scorecards.
• Experience in Micro Strategy mobile supporting both Android and IOS platforms.
• Involved in Upgrades from MicroStrategy 9.x to 10.x on Windows platform.
• In - depth understanding of designing physical Data Models using MicroStrategy Architect.
• Hands-on experience working with VLDB and Optimization of query performance.
• Performance Optimization, performance monitoring, configuring and tuning experience in MicroStrategy Business Intelligence tool suite (Intelligence server, Web) and in database.
• Knowledge and understanding of MicroStrategy Software Development Kit (SDK).
• Interacted with MicroStrategy SDK Modules.
• Pro-active involvement in continuous performance improvements for existing OLAP systems.
• Working Experience in installing and Configuring MicroStrategy 10.x/9.x, MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Intelligence Server.
• Experience includes implementing all phases of the System Development Life Cycle (SDLC), including Business Requirements Gathering, Design, Development, Testing, and Implementation of Client-Server, Multi-tier, Web, Data Modeling and Data Warehousing/OLAP/Business Intelligence Applications.
• Dedicated, detail oriented and extremely hard working with extensive technical skills.
• Well-Organized, Quick learner, Self-motivated Team Player and have experience in all phases of the Systems Life Cycle including Project Definition, Analysis, Design, Coding, Testing, Implementation and Support.
• Created security role for every environment.
• Created security filters for the school users to view their respective reports.

TECHNICAL SKILLS:

BI Tools: MicroStrategy10/9.x/8.x (Administrator, Architect, Desktop, Web, Intelligence Server, Narrowcast Server, Report Services and OLAP Services)

Databases: Teradata 14.0,V2R4.1,Oracle12c,11g,11i,SQL Server (2005/2008), IBM DB2, MS Access 2000 and V2R6.0, Informix

Data Modeling: Microsoft Visio, Erwin 4.5

ETL Tool: SSIS, Pentaho

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

Web: HTML, DHTML, XML, XSL, JavaScript, MS Office.

OS: Windows7/ XP/2003/2000,UNIX and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota, MN

MicroStrategy Architect

Responsibilities:

• Responsible for gathering and refining business requirements from the business users.
• Extensively worked on multiple projects including Client Journey, Reconciliation and Transactions Support etc.
• Involved in meetings to discuss and suggest on the data model to be created in the DB to support reporting in MicroStrategy.
• Migrated reporting from SSRS to MicroStrategy with a source system change from DB2 to Teradata.
• Utilized Eclipse to test the function of Microstrategy Web based on Web SDK.
• Created views in SQL Server and also logical views in MicroStrategy to support varying requirements from the business users.
• Developing Multidimensional Model (Logical Model) by studying the source systems and business requirements.
• Created the Metadata and Statistic tables for the project on SQL Server database.
• Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies.
• Responsible for creating Metrics, Filters, Custom Groups, Prompts using MicroStrategy Desktop and Web.
• Created interactive dashboards and Visual Insights that the users can use and analyze various claims that are processed or being processed.
• Involved in troubleshooting MicroStrategy prompts, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Exploited the use of Analytical Engine bypass functions like Apply Simple& Apply Comparison effectively whenever necessary.
• Worked on MicroStrategy Transaction services to allow the users update fields.
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, and week to year and effectively used them with the metrics.
• Worked on SDK in Modifying and over writing Existing Plugins. Adding Extra Plugins where required.
• Optimized Query Performance by using VLDB settings.
• Modeling and populating the business rules using mappings into the Repository for Metadata management.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Resolved issues that the users encounter and submit through Ticketing system ServiceNow.
• Worked in an onsite-offshore model with developers working from US, Canada and India.

Environment: MicroStrategy 10.4.1/9.4.1, Desktop, SDK, Web, Object Manager, Intelligence Server, Enterprise Manager, SQL Server, Teradata, SSIS, Windows 7, Microsoft Office.

Confidential, Wilton, CT

BI Developer/Architect - Micro Strategy

Responsibilities:

• Gather report requirements from users.
• Created Application Design Documents.
• Collaborate 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 Schema Objects like Facts, Attributes and User Hierarchies in Microstrategy Architect. Also used Table Aliases in Architect to define different roles for an AT&T Employee.
• Used SDK for web customization.
• Created heterogeneous and homogeneous attributes.
• Defined relationships between attributes in System Hierarchy. Also created User Hierarchies to suffice drilling & browsing needs.
• Built Complex Reports using advanced reporting functions like Level Metrics, Conditional Metrics and Transformation Metrics.
• Created Dashboards with multiple attribute element selectors, metric selectors and metric condition selectors.
• Created Summary Dashboards and linked it to Drill-down dashboards using Edit Links and also Hyperlinks. Also used HTML code on Dashboard and created links.
• 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.
• Created various graphs like Pie Charts, Vertical Clustered Bar charts and Bar-Line charts.
• Optimized report SQL using VLDB properties.
• Used the Object Manager to move the objects from Development to Staging and Staging to Production Environment.
• Created Object Prompts & Value Prompts and used them in Unit/Revenue Dashboards.
• Involved in upgrading the MSTR environment from 9.4.1 to 10.3
• Tested the functionality in 10.3 in comparison to 9.x. Made use of new HTML5 widgets in 10.3 to design dashboards.
• Worked with Offshore Testing team and assisted them with creating test cases.
• Provided post production support for users & resolved defects during the QA and UAT process.

Environment: MicroStrategy 10.3/9.4.1x, Desktop, SDK, Web, Object Manager, Intelligence Server, Enterprise Manager, SQL Server, Windows 7, Microsoft Office.

Confidential, Commerce, CA

MicroStrategy Developer

Responsibilities:

• Involved in business requirements gathering for Supply Chain, Store Ops, Customer/Marketing, Finance/Sales Audit, Loss Prevention, Human Resources departments.
• Integrated various client specific reports into MicroStrategy by combining data coming various data sources.
• Involved in all phases of the Project from requirement gathering to Production release.
• Involved in resolving the issues on some of the ad hoc reports by implementing a data validation.
• Built reports that helped the users in prioritizing their orders which helped in improving their service level.
• Built service level scorecards at various levels in Business ( Buyer, Category Manager and Vendor).
• Developed useful existing reports and created dashboards with Key Performance Indicators.
• Created Customer behavior dynamic Dashboards and Spending pattern Scorecards involving graphs and statistical calculations
• Migrated the MicroStrategy objects from Development to Test system for user testing and to Production system
• Configured the Enterprise Manager to analyze the user traffic and the projects/reports that are being used.
• Worked with users to determine which projects are required moving forward
• Interacted with DBA team in tuning queries by collecting statistics, creating indexes
• Followed best practices and created standards document for MicroStrategy project development

Environment: MicroStrategy 10/9.3.1, Desktop, Web, Intelligence Server, Narrowcast Server, DB2, Informix, Visio 2013, Windows 7, Microsoft Office.

Confidential, Orlando, FL

Sr. MicroStrategy Developer

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 Microstrategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Microstrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• 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.
• Created security role for every environment.
• Created security filters for the school users to view their respective reports.

Environment: MicroStrategy 9.3.1 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows 7.

Confidential, Atlanta GA

MicroStrategy Developer/ Architect

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the Micro Strategy platform.
• Involved in Dimensional Modeling by selecting the business process and choosing the dimensions and facts.
• Took part in full data warehousing application lifecycle starting from creating logical and physical data model.
• Identifying and modifying source tables and columns in the warehouse required creating the Micro Strategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Created logical data models to recognize source tables and columns, to build Micro Strategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create Micro Strategy project.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports. Worked on Teradata.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Generated reports for the cooperation for Assets period to period.
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export / print functionality and drilling options like simple and advanced.
• Delivered documents for Financial Analysis, Statements and Summary, Customer lifetime value and Customer loyalty.
• Developed Flash Dashboards & Scorecards in Micro Strategy 9 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.
• Added new users to groups and assigning them security privileges.
• Proactively created report formats and delivered personalized messages from the BI platform through Micro Strategy Narrowcast Server to a wide range of users.

Environment: MicroStrategy 9/9.3.1/9.2x, ERWIN 4.0, TOAD 7.0, Informatica Power Center, Oracle 11i, Windows XP.

Confidential, San Diego, CA

MicroStrategy Developer

Responsibilities:

• 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.
• 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.
• Involved in JAD (Joint Application and Design) sessions and GAP analysis sessions to understand existing reports and convert Cognos reports into Microstrategy by creating corresponding Attributes, Metrics, Filters and Prompts.
• Involved in migration of Cognos reports into Microstrategy Reports.
• Involved in designing of schema objects like Attributes, Facts, Hierarchies and Transformations from data warehouse.
• Expertise in using Apply simple Function in Attributes and Metrics to make manipulations to values.
• Responsible in developing of public objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Reports) on top of Schema Objects.
• Responsible for the creation of metrics like Compound metric, Derived Metric, Filter Metric and Transformation metric to generate more complex Microstrategy reports in an efficient way.
• Involved in creation of logical views and Freeform Sql Reports to translate Freeform Sql Cognos Reports into Microstrategy Reports.
• Expertise in developing Microstrategy reports by combining multiple Cognos reports based on functionality and usability of reports.
• Used Apply Simple and Apply Comparison functions to develop Advanced Filters and Transformations.
• Involved in creation of reports at Aggregate Level as well as Detail Level Tables to retrieve data in an efficient way.
• Involved in setting of VLDB Properties to improve performance of reports as well as passing hints to the SQL queries.
• Expertise in developing dashboard reports in Microstrategy by combining multiple reports in Cognos by using selectors.
• Involved in development of reports on Sap Cubes.
• Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window.
• Involved in creation of Users/User Groups and assigning appropriate privileges through User Manager in Administration.
• Involved preparing Test Plans, Test Conditions for developed reports and uploaded test conditions into the Quality Center and Pass those conditions into the Test Lab.

Environment: Microstrategy 9.0.2,Architect,Web Intelligence, Object Manager, Cognos 8.4.1,Framework Manager, Query Studio, Report Studio, Informatica 8.6.1, Teradata 12, DB2 8.x/9.1, Oracle 10GR2,SAP, SQL, PL/SQL, Windows NT and UNIX.

Confidential, Austin TX

MicroStrategy Developer

Responsibilities:

• Active team member and participated in BI team meetings to discuss the user requirements and convert them into MSTR scorecard and dashboards
• Involved with off shore team for development and job responsibilities sharing.
• Created Low Level Design documents (LLD’s) and High Level Design Documents (HLD’s) as per the user requirements.
• Designed the Logical Data Model based on the Physical Data Model to design the Schema.
• Created Schema objects and public objects as per the requirement and also worked on creating the views on database side when needed
• Worked with MicroStrategy Integrity Manager for testing and comparing reports with V8 to V9
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Facts, Filters, Metrics, Prompts, Templates etc)
• Created ad-hoc reports and freeform SQL reports depending on user requirement.
• Created Interactive Dashboards and Flash Analysis in MicroStrategy Desktop for display in Web.
• Extensively used OLAP services to optimize memory usage and reduce number of hits to database. Hence improved performance.
• Proposed solutions in team meetings involving DAs, ETL and SAs for better reporting standards
• Worked extensively on Advanced Metrics, Advanced Filters, Advanced Prompts, Drill Maps etc
• Worked with MSTR Transformation to leverage MTD and YTD metric
• Fixed the defects created by the testing team within given time.
• Updating Object Mapping document and RLM document for future references.
• Mentoring team members and shared knowledge with them to improve team standards. Assigning work as per the skill sets of team members.
• Worked on debugging complex reports by identifying the issues and doing appropriate enhancements
• Involved in Code Optimization and Query Tuning to improve performance of the reports. Depending on scenario sometimes indexing the database tables with the help of DBA.
• Testing MSTR reports in different environments (DEV, UAT and PROD) for consistency.
• Set up report level security for different users.
• Analyzed the data warehouse data and detected the data quality issues and recommended corrective courses of action
• Involved in UAT Testing Defect resolution.

Environment: MicroStrategy 8, Oracle 10g, MS Office, Quality Center.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed business requirements from BRD document and worked closely with end Users to get exact business requirements.
• Designed and Developed Interfaces using Interface Manager and creating procedures, functions, packages.
• Synchronizing data between Cashin and IM/RM system. Integration testing for complete flow.
• Comfortably worked in a production environment with change management, defect tracking and status reporting processes.
• Played an important role in Analysis, Design, Development, Testing, Documentation, Implementation, Maintenance and Performance tuning of the project.
• Participated in daily status and monthly planning meetings.
• Involved in deployment of product, 8 months on-site support, Production support and client Interactions.

Environment: CMS Tools, Oracle 10g (PL/SQL), Power Builder, Oracle 10G reports, Report 6i