SUMMARY

• Sr. Microstrategy Certified consultant for over 11 years in IT industry with major focus on Business Intelligence tools, Data Warehousing and Database Applications.
• Experience in design development and implementation of Business Intelligence Reports using MicroStrategy suite (Administration Architect Desktop Web Narrowcast Server).
• Good understanding different database management systems including Oracle11g TOAD 8.6.1 SQL Server DB2 Teradata V12.0 with respect to Enterprise Data Warehouses.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes Filters
• Metrics Facts Prompts Templates Consolidation and Custom Groups) with the data warehouse.
• Performed various MicroStrategy Administration tasks like installing configuring monitoring and tuning the MicroStrategy components.
• Created bulk objects using MicroStrategy Command Manager.
• Expert in creating Report Service Documents and DASHBOARDS.
• Strong SQL Skills related to information retrieval and analysis.
• Migrated Projects/Objects across environments by duplicating and using Object Manager.
• Expert in Creating MicroStrategy Freeform SQL reports implementing MicroStrategy projects.
• Experience in Logical Data Warehouse / Data Mart designs to support required OLAP analysis.
• Experience in executing all phases of Software Development Life Cycle from Requirement Analysis to Go Live and support, meeting client SLAs and development of objects required post go - live.
• Strong development, team-leading, project management and support skills.
• Experience working with new technologies and a quick learner.
• Preparing the Technical Specification documents, Developing, Testing and Preparing UTP.
• Excellent Communication, Analytical, Problem solving and mentoring skills.
• Self-motivated individual, who works well in fast paced, high-pressure environment.
• Over 9 years industry experience as Programmer Analyst / System Analyst with solid understanding of Business Analysis, Business Process flow, Requirements gathering, Designing, and Implementation
• Work experience has given me the opportunity to acquire in depth Functional knowledge of customer’s business, process flow and procedures of various domains as well as building customer relationship skills
• In-depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as Requirement gathering, Analysis / Design, Development, Testing and Implementation / Release Management
• Interacted regularly with all teams involved in Application Maintenance and the higher management to meet the deadlines of Project milestones
• Excellent facilitator and communicator with both upper management and software developers in technical / non-technical terms
• Dedicated, detail oriented and extremely hard working Information Technology professional with an extensive technical, project and operational background within the Information Technology and Application Administration fields
• Resolved critical issues through logic and sound reasoning while focused on goals. Ability to work independently and manage business expectations with a delivery-focused approach
• Ability to build and maintain strong working relationships with cross-functional business groups, as well as technical specialists
• Experience working in complex, cross-functional and geographically dispersed team environments
• Proven ability to easily grasp and master new software or Technologies.
• A quick learner and always willing to put forth the extra effort required achieving quality and timely results
• Excels in challenging and demanding endeavors
• Successful track record in overcoming all obstacles to meet business objectives
• Highly motivated team player with excellent presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.
• An organized self-starter requiring minimal supervision and possessing keen analytical, leadership, and communication skills
• Familiarity and experience with various procedures and policies required for escalation and outage resolution with Strong documentation skills.

TECHNICAL SKILLS:

Business intelligence: MicroStrategy 8.0.1,8.0.2, 8.1.1/9.0/9.2/9.3.1/9.4, 10.1,10.2 (MicroStrategy Desktop/Web, Mobile/IPad, Intelligence Server, Narrowcast Server, Report services, Business Objects. Informatica Power Center 9.1.0

Databases: Oracle 11g/10g/9i/8i/7.x, Teradata V2R4/5, DB2, SQL Server, Access

Utilities: Oracle SQL-loader, PL SQL Developer, Aqua Studio 4.7, Visual Basic, Oracle Forms 6i, Reports 6i, Teradata Query analyzer.

Languages: C, Visual Basic 6.0, PL/SQL.

OS: Window NT/2000/98, Sun OS 5.6

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. MicroStrategy Consultant (Architect/Developer)-Tech Lead (Operations)

Environment: MicroStrategy Desktop 10.2,10.6 MicroStrategy Web 10.2,10.6 MicroStrategy Intelligence Server 10.2,10.6 (Sandbox), MSTR Enterprise Manager, MSTR Mobile, MSTR Object Manager, MSTR Command Manager, Oracle 11g

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements for HR Project.
• Created MSTR Prelim and Detail design documents based on the business requirements.
• Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations for TMBC & CPR Dashboards & Reports & KPIs in Project.
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Provided Support for QA, UAT Environments and DR fixes.
• Administered the object change management process: Object migration across the various environments using Object Manager or Project Merge.
• Handled all aspects of user security, including creation of new profiles, user change management, Security roles, and user group management
• Creating the dynamic MicroStrategy Transaction Service Documents to external users to write back the information directly to the Database.
• Worked the Production issues queue, provided full support to our business intelligence community
• Created Schema Objects and Public Objects with Command Manager.
• Created Time Triggered and Event Triggered Schedules, Events and Subscriptions for the Intelligent Cubes reports. Created batch files using command manager script to Trigger events.
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Extensively worked on Intelligent Cube Reports for Creating Dashboards. Monitored and Governed Intelligent Cube for better Performance.
• Created Logical Tables in Microstrategy to meet the Complex end user requirements.
• Extensively used Pass through Functions
• Validate reporting results against requirements. Troubleshoot and analyze data issues within reports
• Extensive Experience in MicroStrategy Mobile platform
• Expertise in Integrity Manager. Trained QA Team on Integrity manager Usage. Compared report and I-Server performances in DB2 and Oracle Databases.
• Prioritize and multi-task concurrent projects; Effective in resolving all clients and development issues
• Coordinated the Onsite and Offshore team to resolve issues.
• Created manual test cases and Performed Integrity Testing for all the reports.
• Performed backend testing by executing SQL Queries

Confidential, Charlotte, NC

Sr. MicroStrategy Consultant (Architect/Developer/Administrator)-Tech Lead

Environment: MicroStrategy Desktop 10.0.1, MicroStrategy Web 10.0.1, MicroStrategy Intelligence Server 10.0.1 (Sandbox), MSTR Enterprise Manager, MSTR Mobile, MSTR Object Manager, MSTR Command Manager, SQL Server 2012

Responsibilities:

• Actively participated in developing Entity-Relationship (ER) Diagrams, and Data Dictionaries, Gathering information from the Business Users and detailed analysis of the data.
• Understand the type of schemas that best support Microstrategy in different scenarios
• Involved in meetings with business users to discuss and finalize the requirements and design of The reports. Gathered and analyzed business requirements for replenishments and design Documentation. Prepared design documentation and spec documentation for Off Shore team to work on
• Worked on existing SSRS reports to estimate MicroStrategy effort.
• Worked in Designing Data Marts using different multi-dimensional modeling techniques such As Star Schema/Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modeling.
• Installed and Configured MicroStrategy product suite 10.0.1 on windows.
• Experience in Creating Metadata, statistics database and configuring I server to metadata in multiple environments.
• Creation of DSNs From different Sources to configure microstrategy Project.
• Create & Manage Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Analyzed logical data models, understand data warehouse tables and columns, map the Columns to the MicroStrategy project by creating Schema objects.
• Created Freeform SQL reports to use the existing Store Procedures Inside the sql Server for Producing Microstrategy Reports and dashboards with simple and cascading Prompts.
• Reverse engineered the store procedures used inside the SSRS reports by analyzing them and converting them Into Micro strategy Objects.
• Resolved attribute role problems in Data models by developing table Aliases and Attribute Role Recognition methods in VLDB settings.
• Created Attributes, Facts, Advanced qualification Filters, Custom groups, Prompts, Hierarchies, Compound metrics, filters, object prompts, custom expression filters and used pass-through Functions (apply simple and apply comp) in attributes and filters definitions.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating Complex reports.
• Created Drill down dashboards which will allow users to navigate from one dashboard to Another.
• Created Multi-layer dynamic dashboard by using panel stacks and selectors which will Provide information for all levels of hierarchy.
• Worked with clients for UAT testing and resolving report Template and Data Mismatch issues.
• Created Intelligent Cubes and shared to reduce the database load and decreasing the report Execution time by using the OLAP services.
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy like Indexing temp tables, etc. Worked on Explain Plan to reduce cost of the SQL.
• Experience in using Object Manager in deployment of Microstrategy code across multiple environments.
• Ran ScanMD and MD Doctor a lot of times to make the projects errors free while migrations to different environments.
• Used Integrity Manager to take Baselines and compare results before and after deployments in various environments.
• Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analysing Report performance, created security filters, administered all aspects of web and intelligence server.

Confidential, San Francisco, CA

Sr. MicroStrategy Report Developer/Team Lead- Direct Store Delivery Project

Environment: MicroStrategy Desktop 9.4.1, MicroStrategy Web 9.4.1, MicroStrategy Intelligence Server 9.4.1 (Sandbox), MSTR Enterprise Manager, MSTR Mobile, MSTR Object Manager MSTR Command Manager,

Responsibilities:

• Simultaneously incorporating the Direct Store Delivery Functionality into the Microstrategy report which enables users to identify DSD vs Non DSD Data on report.
• Developed reports according to the requirements in different functional areas- Orders/Shipment/Receipt.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on Interactions with the process owners & stakeholders.
• Developed Schema Objects like Facts, Attributes, and Hierarchies and assigned relationships like one-to-one, One-to-many and many-to-many between different attributes.
• Responsible for Collaborating with other teams while performing "End to End” integration testing of the project.
• Contributed in creating the data mockup while collaborating with upstream system (EDW/PROMPT) To test the “End to End” testing scenarios.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Created advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, Hierarchy prompts according to the business needs.
• Worked extensively on developing Metrics and Compound Metrics, Complex Metrics, Filters using Microstrategy 9.4.
• Worked closely with DBA’s to improve the report performance standards.
• Involved in troubleshooting Microstrategy Web Reports, and optimizing the SQL using the VLDB properties.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Developed User Manuals, and Training Manuals as per Project Specifications and timelines.

Confidential, Norwalk, CT

Sr. MicroStrategy Consultant (Developer, Architect,)

Environment: MicroStrategy Desktop 9.2.1, 9.3.1, 9.4.1 MicroStrategy Web 9.2.1,9.3.1, 9.4.1 MicroStrategy Intelligence Server 9.2.1, 9.3.1, 9.4.1 (Sandbox), MSTR Enterprise Manager, MSTR Mobile. Informatica Power Center 9.1.0

Responsibilities:

• Gathered requirements directly from the users for small reports.
• Created Complex Retail Company’s payment related reports using advanced relationship filters, Dimensional Metrics.
• Created the required views in the database and mapped into Microstrategy.
• Created reports using advanced relationship filters and by getting data from combination of different fact tables.
• Worked mainly on creating the Report services document with multi-layouts and designed to support all the export versions (Excel, PDF and Flash).
• Created Attributes and facts with complex apply Simple functions.
• Worked on changes to the existing dashboard which has almost 20 dashboard pointers using the Iframes.
• Drilling options (Drill up down across) were used to generate ad hoc reports.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Created Level metrics, advanced filters, prompts.
• Created and Deployed Multi Panel Dashboards, Multiple Images, Hyperlinks and edit links to navigate the documents between the hierarchy elements of the project .
• Successfully completed different dashboard projects (web and mobile-IPAD) to provide users the convenience of doing data analysis in a better way.
• Worked on tuning the sql to improve the performance of the existing reports.
• Developed mobile dashboards for the IPAD application and added required changes to it after moving to production environment.
• Worked with ETL Developers to resolve the data issues.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows
• Created cubes to improve the performance of reports and Report Services documents.
• Changed some of the VLDB properties (“Select Post String”, “Union Multiple Insert”, “Join”) to tune the cube’s SQL.
• Worked through entire development process including testing of the Reports, Report Services documents and migrating those objects from Dev to Prod.

Confidential, pea pack, NJ

Sr. MicroStrategy Consultant (Developer, Architect, Admin)

Environment: MicroStrategy Desktop 9.0.1, 9.0.2, 9.2.1, 9.3.1 MicroStrategy Web 9.0.1,9.0.2, 9.2.1,9.3.1 MicroStrategy Intelligence Server 9.0.1, 9.0.2, 9.2.1, 9.3.1 (Sandbox), MSTR Enterprise Manager

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates for the project.
• Designed Components, Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Consolidations Custom Groups and Prompts for the reports.
• Created Dashboards and Scorecards to provide users the convenience of doing data analysis in a better way.
• Created Data mart reports for dashboards depending upon the requirement.
• Drilling options (Drill up down across) were used to generate adhoc reports.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Documented and reviewed design documents with the team, prototyped and obtained Director feedback at early stages of design, coordinated test plans, and provided feature/functionality/usage scenarios to documentation.
• Tuning Some of the Most Complex Dashboard and Reports in TDA Reporting.
• Configured Microstrategy Mobile settings on Microstrategy Mobile Web.
• Developed customized dashboards for both IPad, and IPhone deployed them for access via VPN.
• Validated end user report requests using SQL and MicroStrategy tools.
• Created narrowcast services to email /send report service documents to a directory in PDF or excel formats.
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy like indexing temp tables, etc. Worked on Explain Plan to reduce cost of the SQL.
• Ran ScanMD a lot of times to make the projects errors free. Also sometimes did copy metadata to a testing server to validate with temporary test data.
• Assisted the DBA's and the ETL architects to design and create Tables in the Oracle database to achieve the business requirements.
• Developed and implemented Security Roles User Groups and Privileges and Object Security for the developers and End users.
• Implemented Event and Time Based Schedules. Worked with Unix Administrator to monitor jobs that would trigger based on certain conditions and fire Event Schedule to kick off reports.
• Created reports in Enterprise manager for stats analysis on concurrency of the user reports.
• Developed Excel Macros to automate formatting after exporting Reports to Microsoft Excel.
• Performing QA and production migrations of MicroStrategy objects using Object Manager.

Confidential, Providence, RI

Sr. Microstrategy Report Architect (Developer, Architect, Admin)

Environment: MicroStrategy 9.0.1(Architect, Desktop, Report services, Dashboards, Enterprise Manager), SQL Server 2008 R2 (Metadata)Our team was brought in late in the project lifecycle to provide the key reporting deliverables desired by the business. We had to very quickly assess the existing model, offer data model and data load changes needed to support the reporting that was requested by the business, and deliver a very complex set of reports and a full ad-hoc reporting environment while working with an extremely dynamic project team against an extremely aggressive timeline.

Responsibilities:

• Identified and resolved critical defects identified during production testing.
• Communicated effectively with clients as part of defect management process.
• Involved in deployment/migration activities between different Microstrategy environments.
• Performed administrative activities such as server maintenance, upgrades/patches and user management.
• Prepare detailed documentation for upgrade/patch processes.
• Assisted with performance testing for scheduled environment upgrades.
• Worked with database team to tune performance of existing reports.
• Modified VLDB properties to optimize performance of reports and force variation in default behavior of SQL engine.
• Created MTD (Month to Date) and YTD (Year to Date) reports as per the user requirement.
• Designed Low Level Design documents (LLD’s) and High Level Design Documents (HLD’s) as per the user requirements.
• Designed and Developed interactive flash Dashboard.
• Extensive Knowledge on command manager and user manager for the ad Groups reporting.
• Created Transformations (table based, formula based) for using in comparative reports like claims this year to last year (year to date and month to date).
• Used Object Manager, Command Manager and Enterprise Manager tools in MicroStrategy Administrator in tuning Business Intelligence system.
• Worked with Microstrategy Object Manager to move objects among the Development, Testing and Production environments.
• Created new users, roles, privileges, shared folders, access controls Lists by using security roles in MicroStrategy.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Created custom attribute functionalities using OLAP services.
• Design, build and maintain all MicroStrategy schema objects (attributes, facts, hierarchies).

Confidential, New York, NY

Sr. MicroStrategy Consultant (Developer, Architect, Admin)

Environment: MicroStrategy Desktop 9.0.2, MicroStrategy Web 9.0.2, MicroStrategy Intelligence Server 9.0.2 (Sandbox), SQL Query analyzer, MSTR Enterprise Manager

Responsibilities:

• Worked closely with the end users and internal business analysts for data requirements gathering design prioritized business goals and information needs.
• Generated report for web-based query using MicroStrategy Web
• Created the Technical Specification Documents for the reports for Business sign-off and acceptance.
• Used MicroStrategy Architect to create Facts Attributes Relationships and Hierarchies.
• Extensively worked in developing Metrics Derived metrics Compound metrics and Filters for complex reports.
• Worked on the performance tuning of the MicroStrategy reports.
• Analyze and develop the new objects in Dev environment and after testing the objects and reports migrated to Production Environment using Object Manager.
• Designed the MicroStrategy Architectural Documents for the Projects.
• Developed Tested and Implemented Narrowcast server objects like Documents and Schedules necessary for the generation of Narrowcast Services.
• Proactively created report formats and delivered personalized messages from the Data warehouse through MicroStrategy Narrowcast Server to a wide range of users.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Worked heavily 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.
• Using MicroStrategy excel delivered embedded reports to the end-users.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Consolidations Custom Groups and Prompts for the reports.
• Automated excel to generate Monthly and weekly status Project Reports.
• Created Dashboard and Scoreboard reports and used various Widgets for best visual effects.
• Involved in training the end users with MicroStrategy Web reports.
• Participated in review sign-off and communication of all changes or modifications to reports.
• Experience in MicroStrategy Administration like Creation of new user’s roles privileges shared folders access controls Lists.
• Knowledge of MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.

Confidential, LOUISVILLE, KY

Sr. MicroStrategy Consultant (Developer, Architect, Admin)

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Web 8.1.1, MicroStrategy Intelligence Server 8.1.1 (Sandbox), Teradata Query analyzer, MSTR Enterprise Manager

Responsibilities:

• Worked with business requirements analysts / subject matter experts to identify and understand requirements and produce the report design specification and estimates for the project.
• Designed Components, Templates, Filters to generate Reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Created logical data model, recognized source tables and columns, to build Attributes, Facts, Transformations, Hierarchies and Relationships necessary to create a MicroStrategy project.
• Created Consolidations Custom Groups and Prompts for the reports.
• Created Dashboards and Scorecards to provide users the convenience of doing data analysis in a better way.
• Drilling options (Drill up down across) were used to generate adhoc reports.
• Extensively used report services for creating summary level Enterprise Dashboards using Grid/Graphs, Gauges, Dials and Advanced Visualizations.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Validated end user report requests using SQL and MicroStrategy tools.
• Created narrowcast services to email /send report service documents to a directory in PDF or excel formats.
• Optimized the SQL performance of the reports using the VLDB properties in MicroStrategy like indexing temp tables, etc. Worked on Explain Plan to reduce cost of the SQL.
• Ran ScanMD a lot of times to make the projects errors free. Also sometimes did copy metadata to a testing server to validate with temporary test data.
• Assisted the DBA's and the ETL architects to design and create Tables in the Oracle database to achieve the business requirements.
• Developed and implemented Security Roles User Groups and Privileges and Object Security for the developers and End users.
• Implemented Event and Time Based Schedules. Worked with Unix Administrator to monitor jobs that would trigger based on certain conditions and fire Event Schedule to kick off reports.
• Created reports in Enterprise manager for stats analysis on concurrency of the user reports.
• Developed Excel Macros to automate formatting after exporting Reports to Microsoft Excel.
• Performing QA and production migrations of MicroStrategy objects using Object Manager.

Confidential, San Francisco, CA

MicroStrategy Developer and Architect

Environment: MicroStrategy 8.1.2 Product Suite (Administrator Architect Desktop Object Manager Enterprise Manager Web) Oracle 9i Toad Windows.

Responsibilities:

• Worked closely with the end users and internal business analysts for data requirements gathering design prioritized business goals and information needs.
• As an Architect created Attributes Facts Transformations and defined the Attribute relationships.
• Created Metadata shells duplicated projects created database instances tested ODBC connections loaded projects set up securities checked elements availability issues and finally concluded by running developed reports.
• Designed and created reports using Attributes Facts Metrics Filters Consolidations Custom groups and Prompts.
• Performed the Administrator during project migrations to various environments configured the Project level and I-Server settings and setting up of user accounts and privileges to meet the needs of the users.
• Worked heavily 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.
• Using MicroStrategy excel delivered embedded reports to the end-users.
• Created Dashboard and Scoreboard reports and used various Widgets for best visual effects.
• Involved in training the end users with MicroStrategy Web reports.
• Participated in review sign-off and communication of all changes or modifications to reports.
• Experience in MicroStrategy Administration like Creation of new user’s roles privileges shared folders access controls Lists.
• Involved in preparing the Unit Test cases and Test Plans for the Reports Developed.
• Provided the initial support after the project roll-out to the end users in Production.
• Used the Enterprise Manager to create and produce statistic report to optimize the MicroStrategy system.