SUMMARY:

• Expert in MicroStrategy Administration and Development.
• 8+ years of rigorous IT experience, leveraging expertise in Data Warehousing, Data Modeling, ETL and BI (MicroStrategy) tools.
• Experience in all aspects of Software Development Life Cycle (SDLC).
• Interacted with the Business Users to understand the Business flow and the operations of the Source (OLTP) systems.
• Responsible for planning and executing MSTR platform upgrade from MSTR 9.4.1 to MSTR 10.1
• In - charge of operation and maintenance of MicroStrategy production and non-production environments.
• Handled all Admin activities including user and user group creation/modification, project security, license maintenance, and object migrations across all environments.
• Gathered and documented business requirements for existing and future business systems.
• Experience as Business Analyst with expertise in Finance, Insurance, processes, Business Process Engineering, Systems/ Solutions Engineering, Strategic Planning, and Systems Analysis.
• Efficiently provided Business Intelligence Solution using MicroStrategy suite which includes MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy Mobile server, MicroStrategy Desktop etc.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metric).
• Skilled in assessing, analyzing, designing Supply Chain Business Processes with a focus on Enterpris Planning, Demand and Forecast Planning, Inventory Control, Procurement and Order Management.
• Proficient in devising and implementing optimal Supply Chain Process Integration and B2B Integration
• Hands on experience using MicroStrategy tools like MicroStrategy Architect, and MicroStrategy Administrator, Command Manger, Object Manger etc.
• Created MicroStrategy User Accounts and User Groups with different Security Roles and assigned various Security Filters.
• Configured MicroStrategy authentication with LDAP and Windows authentication. Implemented security in various methods like Security filters, Table Based Security, System Prompts.
• Used MicroStrategy tools like Object Manager and Project merge to compare projects and migrate the objects/projects between two Servers.
• Led teams of 3-4 team members. This included QA professional and Support analysts.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, hierarchies etc.), Public Objects (such as Reports, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, user, security filter etc.) using Micro strategy desktop.
• Expertise in the MicroStrategy SDK and Java development; Particularly JSP & .net based Web Application development.
• Extensively created MicroStrategy Dashboards & Score Cards which includes advanced features of HTML5 version like Radio Buttons, Fish Eye, Slider and other selectors.
• Specialized in designing Report Service Documents with multiple datasets.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets) and Business solutions on web, wireless devices.
• Experience in Data modeling techniques like star and snowflake schemas using Erwin tool
• Good Knowledge on data extraction and transformation (ETL) process and had exposure on tools like Data Stage, Informatica Power Center 7.0
• Exposure in dealing with variety of Relational Databases like Teradata, Netezza, Oracle, DB2, SQL server
• Writing complex SQL queries, cursors, stored procedures, UDF and triggers.
• Excellent domain knowledge in Supply Planning and Demand Planning
• Good experience in customer facing roles
• Involved in job scheduling, monitoring and production support in a 24/7 environment
• Excellent communication skills and ability to work in group as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS:

DSS/BI Tools: Micro strategy 10.4/10.x, 9.5, 9.02,9.0.1,8.1.x/7.5/7i/7.x (Administrator, agent, web architect, narrowcast, Report services); cognos, business objects 5.0/4.1

Databases: Oracle 10g, 9i/8.0/7.x, MSSQL Server 2012, 2008, 2005, Teradata V2R6 and V2R5, Sybase IQ, Netezza,MS Access 7.0

ETL Tools: Informatica Power Center 9.6/7.1.1/6.2/5.1, Data Stage7.5.2, 7.0, Power Mart 5.1.2/4.7.1, SSIS

Data modeling tools: CA Erwin 4.0/3.5.5/3.5.2, oracle designer, Visio

Programming: SQL, PL/SQL, SQL plus, UNIX shell scripting, AWK, XML, C, C++

Tools: / Utilities: SQL * loader / Toad 7.x/8.x, Teradata Sql Assistant, WinSQL, WinSCP

Project Management Tools: Asana, JIRA 6.2/6.3.3

Operating Systems: Microsoft Windows 95/98/00/NT/XP, UNIX, Linux (RHEL 4.1/3.1), IBM AIX 4.2, 4.3

PROFESSIONAL EXPERIENCE:

Confidential, Sanfrancisco, CA

MicroStrategy Architect/ Developer

Responsibilities:

• Served as lead Principal Business Intelligence architect/designer/developer & administrator for the Overhead door data warehouse supporting over 200 users in the USA, Canada regions.
• Extensive MicroStrategy BI experience in deploying/developing MicroStrategy BI solutions. Focused on performance tuning, data warehouse architecture designing and modeling for managing large BI deployments.
• Generated MicroStrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
• Installed and configured the mobile server and Windows for iPads, iPhones & Android devices.
• Designed reports & Dashboards for mobile devices like iPads, iPhones & Androids and implemented best practices for performance optimizations.
• Developed mobile specific widgets like Data cloud, Interactive event calendar, Image layout widgets, Network Visualization widget, Time series sliders etc.
• Managed mobile subscription work flows and mobile report subscription including real time updates on blackberry device reports.
• Created several Custom tables, Views, Aggregations and Macros for developing reports used in MicroStrategy environment.
• Trouble shooting mobile connection issues and prompted reports & scorecards. Performance tuning on mobile Info popup windows for multi panel dashboards.
• Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database Instance) for optimization.
• Performed schema design, advanced dashboard creation, data modeling, report performance tuning for the customers in Financial, Retail, and Marketing etc.
• Lead a strong MicroStrategy onsite/offshore team and coordinated efforts across multiple projects in a fast-paced dynamic agile environment.
• MicroStrategy Centralized Management of multiple environments from Web and Automation using Operations Manager, Command Manager, System Manager, Enterprise Manager, IC Manager, Triggers, 24/7 alerting etc.
• Expert developer and designer of reports, dashboards and data visualizations on all platforms including mobile devices
• Adopted and acted a scrum master for the project management
• Acted as a liaison between the internal business teams and technical teams right from gathering the requirements, preparing the functional requirement documents, coordinate with the ETL teams on the requirement specifications and designed the MSTR architecture and development.
• Lead the MicroStrategy environment upgrade process on numerous occasions on development, QA and production servers, we started with MicroStrategy 9 at Overhead door and our recent upgraded version is 10.4
• Leveraged the MicroStrategy environment to users to start build their own visualizations/reports using their own data imports via different plugin futures in MicroStrategy 10 or higher versions.
• Trained users in creating VI dashboard and MicroStrategy driven data mining capabilities like Data wrangling, In Memory and live cubes etc.
• Strong knowledge on ETL Maintenance, ETL Auditing and Reporting, Data Mapping, Exception Handling, and integration of multiple sources in an enterprise environment
• Administered the servers, creating security roles & security groups, monitoring caches, create Time/Event triggers, supported the MicroStrategy office imports and plugins, Report subscriptions, Scheduled maintenance etc.
• Integrated/iframe MicroStrategy web application to Overhead Door Portal page and automated the user-creating process in MicroStrategy via command managers scripts and batch files.

  Integrating data from all sources like Google Analytics and Google Big Query, Facebook, Twitter, Salesforce into an analytics platform translated into dimensions and metrics ready for consumer reporting and visual insight.

• Build an Analytics Roadmap for your company that will take advantage of emerging disruptive technologies that impact your company's ability to understand the market

Environment: MicroStrategy 10.4/10.x (Administrator, Developer, Object Manager, Enterprise Manager, integrity Manager, Command Manager), Tableau, Informatica, SQL Server 2012, SQL Server Integration services, Dell Boomi, Work Front project management tool, TFS 2012 version control.

Confidential, Norwalk, CT

MicroStrategy Architect/ Developer

Responsibilities:

• Involved in the business interaction with the users and gathered the reports that needed to be exist in the Project.
• Involved in Database meetings and also worked closely with business users in framing the Scope Document.
• Responsible for testing the reports by writing down SQL queries.
• Created ETL technical Specification documents, which are used for developing Data, warehouse Schema.
• Created the technical specification for the reports for the user 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.
• Used MicroStrategy Web to generate Advanced Reports.
• Created Consolidations, Custom Groups and Prompts for the reports.
• Worked on the performance tuning of the MicroStrategy reports.
• Analyze and develop the new objects in Test environment and after testing the objects and reports, migrated to Production Environment.
• Hands on experience on designing and developing dashboards and score cards using the latest version 10
• Created Report Service Documents for HR and Finance Projects using Adobe Flash introduced in the latest MicroStrategy version 10
• Created custom dash boarding using widgets like time series sliders, Microcharts, Lipstick graphs etc. in HTML5.
• Created dashboards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
• Got appreciations from Business users for creating Dashboards looks and feel like their sample reports.
• Worked extensively on dynamic dashboards and scorecards using Report Services with illustrative pie-charts and graphs for different Business requirements.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.
• Designed database schemas for OLAP warehouse databases.
• Created/enhanced catalogs and set user profiles to grant user permissions for querying.
• Validated end user report requests using SQL and MicroStrategy tools.
• Triggered both static and dynamic subscriptions in MicroStrategy Narrowcast.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics
• Designing Metadata Structure using MicroStrategy Configuration Wizard
• Used MicroStrategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized content to the subscribers. Involved in installation and configuration of the Narrowcast Server and perform various tasks to have the subscription and other features to work.
• Developing customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent with features of Drilling options drill up, drill down and drill anywhere

Environment: MicroStrategy 10.0(Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, integrity Manager, Command Manager) SQL Server 2008, Teradata.

Confidential

MicroStrategy Architect/ Developer

Responsibilities:

• Participated in Business Requirement, Functional, Design and Documentation reviews.
• Worked with ETL Architect team in designing the technical specifications, which Comprises of robust retail data model structure.
• Worked closely with Business user to get sign off on the reporting requirements.
• Involved in Project management, Planning of Environments, Project Scope, Project road map, evaluated and developed alternative solution possibilities.
• Estimate the product deliverable, define and track development phase against the project plans, and manage the development risk & mitigation and report on high-level project status.
• Designed, delivered and optimized MicroStrategy applications on multiple database platform
• Estimate the product deliverable, define and track development phase against the project plans, and manage the development risk & mitigation and report on high-level project status.
• Lead the preparation of conceptual, logical, and physical design documents and coordinate design and code/application review
• Work with DBAs in tuning the supporting queries and design the presentation/analytical data warehouse layer to adapt Data Model best practices
• Worked on all MicroStrategy Schema Objects and Public objects that include attributes, facts, hierarchies, transformations, partition mappings, Advanced metric, filters, prompts, subtotals, templates, custom groups, consolidations, reports and documents.
• Designed & published MicroStrategy Intelligent cubes to deal with huge volumes of data and created view reports on top of the intelligent cubes.
• Configured and created the MicroStrategy Mobile dashboards using the Widgets like Micro charts and presented it for the Mobile users especially for Ipads and IPhones.
• Worked on Advanced VLDB settings to minimize the cubes and reports execution time, which runs against the warehouse having terabytes of data.
• Implemented advanced drilling options to go outside the cubes and create live drilling.
• Worked heavily on advanced metrics and created comparison metrics to evaluate and compare the eBay price defining parameters, which will affect decision making.
• Worked on Narrowcast/Distribution Services, OLAP Services, Enterprise Manager, and MicroStrategy Architect.
• Implemented project level security, ACLs and worked on table driven security implementation.
• Created MicroStrategy report service documents using adobe flash with all new Widgets like Bubble chart, micro charts, Heat maps etc.
• Configured Enterprise manager, Integrity manager and Command manager.
• Created Drill down dashboards that will allow users to navigate from one dashboard to another using HTML tags in attributes.
• Created and implemented pet data marts on top of the monthly reports.
• Performed the administration tasks like tuning, Caching, Governing, Thresholds, and Report optimization.
• Optimizing report generation with respect to Very Large Databases (VLDB) to make absolute use of Database Flexibility, Caching, Security and Scalability Issues suited for Teradata, Netezza, DB2, SQL Server and involved in troubleshooting Micro Strategy Web reports.
• Ability to work independently and communicate effectively with Business Analysts, ETL developers and QA team
• Involved in educating the Business users to make best use of the MicroStrategy reports.

Environment: MicroStrategy 9.0.3/9.0.1 (Administrator, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, integrity Manager) Informatica, Oracle 10g, SQL Server 2005.

Confidential

MicroStrategy Architect/ Developer

Responsibilities:

• Full life cycle of the project has been implemented starting with the gathering requirements from users and documenting the specifications.
• Involved in Gathered and documented business requirements for existing and future business systems
• Acted as a liaison between business staff and technical staff to articulate needs, issues and concern
• Worked with the source systems to have a comprehensive understanding of the data flow and interacted with the users to collect the Business requirements
• Involved in providing solutions for complex Time Dimension related issues and analysis. Collecting business requirements for reconciliation reports and designed metrics in MicroStrategy
• Installed MicroStrategy on Linux environment, defined the metadata using MicroStrategy Configuration wizard.
• Specified configuration settings for every node in a clustered environment.
• Optimization and tuning of SQL
• Agree Acceptance criteria with the customer prior to Commencing UAT.
• Enabling ad hoc queries and complex analytics with TB of data using Netezza DB
• HR warehouse maintenance and upgrade.
• Implemented security at various levels like - Project Source Level, Project Level and Object Level.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect
• Led and Involved in Project Planning, Coordination and implementing various SDLC methodologies Tested all the reports by running queries against the warehouse-using TOAD. Also compared those queries with the MicroStrategy SQL engine generated queries
• Had experience in configuring MicroStrategy logins with client LDAP accounts and Windows accounts.
• Specified ODBC architecture and requirements for the MicroStrategy environment. Created ODBC connections to the metadata and the data ware house.
• Skilled in assessing, analyzing, designing Supply Chain Business Processes with a focus on Enterprise Planning, Demand and Forecast Planning, Inventory Control, Procurement and Order Management
• Created and defined the project level security settings, identified and modified the user authentication mode options, created users and groups, and created and maintain security roles.
• Used the Administration monitors in MicroStrategy intelligence server to oversee project operations.
• Identifying the cache types, configure cache settings and schedule reports to execute automatically.
• Dentifying the purpose of job prioritization and connection management, and use the job prioritization wizard to create connections and assign priorities to them
• Used Advanced Prompts, Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
• Created Transformations for using tables for YTD, MTD and WTD analysis
• Design and implemented enterprise wide DATA MODEL using ERWIN 4.0
• Used the Object Manager to move the objects from Development to Production Environment in MicroStrategy
• Clearly understanding the procedures for grouping and sorting records in a MicroStrategy report service documents that you created as Reports which is WYSIWYG.
• Used features like Hyperlinks, drilling and advanced metric calculations in creating reports with dynamic Dash boarding using MSTR 8.1.2
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Extensively used the latest version of flash 8.1.2 Dash boarding to provide Report services
• Supported the Reports developed and given Production support for 4 months
• Extensively used Report services for creating Dash Boards.
• Upgraded MSTR Projects from 8.1.2 to 9.0
• Configured and implemented Narrowcaster for report Distribution.
• Configured the Enterprise Manager for statistical reporting purposes.

Environment: MicroStrategy9.0/ 8.1.x, 8.0.2 /7.5(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Informatica, Teradata, Oracle 10g, SQL Server 2005.