SUMMARY

• 8 years of experience in full Software Development Life Cycle (SDLC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.
• 7 years of Experience in MicroStrategy 8.x/9.x/10.x.
• Experience with Microstrategy Logical models and Reports adhering to all necessary business rules.
• Implementation of best - practices in terms of design, development and documentation standards.
• Created reports for end users in Microstrategy Desktop and Microstrategy Web.
• Installing configuring of all Microstrategy Products including Microstrategy Desktop, Administrator, Intelligence server, Web server.
• Extensive working experience with Microstrategy 8.x/9.x, Microstrategy Desktop, Microstrategy Web, Microstrategy Architect, Integrity Manager, Command Manager.
• Expert in Creating MicroStrategy reports, Dynamic dashboards, Generic cubes and implementing MicroStrategy projects.
• Expertise in developing reports by using Freeform SQL Queries and Logical Views in MicroStrategy Desktop.
• Fine tuning of the MicroStrategy reports using Data mart Reports, Aggregate tables and Intelligent Cubes.
• In-depth knowledge of fundamental data warehousing concepts such as ER modeling, Dimensional modeling, Kimball, Star and Snowflake schemas, modeling data marts, creating semantic layers, security and deployment.
• Extensively involved in Optimization of Data Migration, ETL Processes.
• Used Advanced Prompts, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Sound knowledge of n-Tier client/server architecture.
• Experience in creating new user accounts, assigning groups and security privileges.
• Expertise in migrating objects from development, QA and production using Object Manager.
• Very solid understanding of Oracle and SQL Server with respect to enterprise Data Warehouses.
• Strong analytical and problem solving skills.
• Team player and self-starter with good communication skills and ability to work independently and as a part of the team. Experience in working in big projects.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.
• Good leadership qualities with experience in training developers, advising technical groups on coding best practices.

TECHNICAL SKILLS

BI Tools: MicroStrategy Desktop 10.x/9.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy OLAP Services, MicroStrategy DSS Suite

Data Modeling: ER Studio 8/7.x, Erwin Data Modeler 4.0/3.5.2, MS Visio

ETL Tools: Informatica Power Mart 7.1/6.0, Ab Initio 1.1/1.0, Ascential DataStage 7.0/6.0

Databases: ORACLE 10g/9i/8i, Teradata V2R4.1, Netezza, SQL Server 6.5/7/2000, IBM DB2, MS Access 2000

Programming Languages: Visual Basic 6.0, SQL, PL/SQL, T-SQL, Shell Scripting, Pascal

Web Language: HTML, DHTML, XML, XSL, Microsoft Front Page, Home Site 4.0, Javaand toolsVB Script, ASP, JSP, Script

Operating Systems: MAC OS/OS X, MS-DOS, UNIX, WinNT, Window XP/ 2003/2000/98 and Linux

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

MicroStrategy Architect/Lead

Responsibilities:

• Worked with the ETL team and business operational teams to understand data sources and implement new requirements for DPS-Portfolio Optimization Project.
• Created MSTR Prelim and Detail design documents based on the business requirements.
• Developed and implemented complex MicroStrategy reports, Dashboards and Visualizations for VDM Fraud Dashboard Reports &KPIs Project.
• Created/Updated MicroStrategy schemas, reports, dynamic dashboards as per the requirements.
• Involved in the lifecycle of VDM Fraud Dashboard Reports &KPIs Project, DPS-Portfolio Optimization Project and VDM Prepaid Cardholder Data Integration.
• 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
• 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 Manger. 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.

Environment: MicroStrategy 9.4.1 (Desktop, Administrator, Web), Tableau, QlikView, DB2, Oracle, Windows, TOAD for DB2 4.7

Confidential, Houston, TX

Sr. MicroStrategy Lead

Responsibilities:

• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development.
• Designed Dashboards in 9.4.1/9.3.0 summarizing key business indicators (KPI’s) by presenting them in visually intuitive, easy-to-read, interactive documents.
• Multi panel Dashboards with information about Transactions, Offers and Events, Attributes, Links to detail report was Designed and Implemented using 13 datasets.
• Worked on the performance tuning of the MicroStrategy reports.
• Development experience with visual insight, dashboards, and mobile.
• Visual Insight - Created analysis and added visualizations using the data from existing reports and Intelligent Cubes (I-cube).
• Microstrategy Mobile - Created Dashboards for Business Leaders, Business Managers to access on IPhone and IPad.
• Managed mobile reports on Microstrategy Mobile and also provided administration of the Microstrategy environment.
• Worked with Data modeling and Database Admin and provided specification for Data Mart Design.
• Worked with ETL Team to define the mapping between the operational database and the warehouse.
• Created reports with various object prompts to generate various Ad hoc reports.
• Trained other team members and business users on various functionalities of MicroStrategy tool suite.
• Created Enterprise Manager Reports & dashboards to analyze customer usage of the reports and average run time of the reports.
• Used Command Manager for bulk user creation and automating schedules.
• Used Object manager to deploy MicroStrategy objects from development in to test and production environments. Performed the role of a backup administrator.
• Troubleshooting report and data issues and supporting the users in problem resolution.
• Defined and developed use case documents and worked with users on user acceptance testing.
• Used MicroStrategy Administrator for accurate information regarding system usage and performance.

Environment: MicroStrategy 9.4.1 Administrator, Desktop, Architect, Web, Visual Insight, Intelligence Server, Administrator and Object Manager, Narrowcast Sever, Command Manager, Oracle

Confidential, Columbus, OH

Sr. MicroStrategy Architect

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Was in Retail team, extensively worked on creating weekly, monthly and yearly sales reports.
• Involved in Dimensional Modeling by selecting the business process, declaring the grain, and choosing the dimensions and facts.
• Created a DB instance for Microstrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Architected schema objects such as Facts, Attributes, Hierarchies and Transformations.
• Analyzed and developed Application Objects (Metrics, Reports, Documents, filters, prompts) using MicroStrategy Desktop and MicroStrategy web interfaces.
• Created metrics (simple, nested & compound), advanced filters, advanced prompts, advanced report designs and drill maps.
• Involved in migration of Business Objects documents to Micro Strategy documents.
• Developed Intelligent Cubes in version 9.x to slice and dice the data.
• Tuning MicroStrategy Intelligence Server for better performance
• Worked as backup administrator in charge of adding new users to groups and assigning them security privileges.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Involved in defining and designing the Report Templates.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Created three types of reports to show the users - Enterprise reports, Dashboard analysis reports, Ad-hoc reports.
• Implemented OLAP Functions like Apply Simple, Apply Comparison for the complicated filters, attributes and metrics.
• Understand the type of schemas that best support MicroStrategy in different scenarios
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Analysis and Troubleshooting of the SQL generated by Microstrategy
• Developed dashboards/ scorecards for quick and easy visualization.

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.2.1, MicroStrategy Web, MicroStrategy Intelligence Server, Integrity Manager, Object Manager, Teradata V13, Erwin Data Modeler, Windows XP.

Confidential, Houston, TX

Sr. BI Architect

Responsibilities:

• Gathered requirements, created mockups and developed an extensive collection of interactive dashboards using MicroStrategy Report Services for distribution to executives, VPs and field sales teams.
• Created Semantic Layers for understanding the data and generated reports.
• Created a complete replacement for the existing Excel based reporting and distribution system using MicroStrategy Office.
• Developed schema objects (facts, attributes, hierarchies, transformations) using MicroStrategy Architect.
• Extensively used filters, templates, consolidations, transformations and custom groups to generate reports for business analysis using MicroStrategy 8i.
• Developed metrics, derived metrics, compound metrics and level metrics for complex reports.
• Created transformations for rolling time period reporting and trending of prescription counts. Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Created several base formulas (mathematical expressions) using existing facts that can be re-used to build any number of metrics, KPI’s in reports.
• Involved in troubleshooting MicroStrategy Prompts, Filters, Templates, Consolidations, and Custom groups in an enterprise data warehouse team environment.
• Analyzed and developed partitioning and indexing strategies for performance improvement.
• Designed and developed various database objects like tables, views, snapshots, procedures, SQL queries etc., in Oracle, SQL server and Teradata.
• Created Database Instances and connection mapping for access to proper warehouses and users
• Used pass-through database authentication to link Microstrategy user to database users.
• Involved in Customer Support and Maintenance & Performance Tuning of reports
• Imparted user training towards the implementation phase of the project and performed knowledge transfer.
• Documented entire work accomplished for future reference and maintenance purposes

Environment: MicroStrategy Architect, MicroStrategy Desktop 9.X, MicroStrategy Web, Narrowcast Server, MicroStrategy Intelligence Server, Teradata V12, Oracle 11g, Window and UNIX.

Confidential, Boston, MA

MicroStrategy Consultant

Responsibilities:

• Worked with business requirement analysts in gathering business requirements and analyzing report specification documents.
• Extensively worked on creating weekly, monthly and yearly sales reports and created dashboard and scoreboard reports for easy visualization.
• Involved in Dimensional Modeling by choosing the business process, stating the grain, and selecting the dimensions and facts.
• Developed Schema Objects like Facts, Attributes, Hierarchies and Transformations using MicroStrategy Architect.
• Analyzed and developed Application Objects like Metrics, Reports, Documents, filters and prompts using MicroStrategy Desktop and web interfaces.
• Created simple, nested & compound metrics.
• Created advanced filters, advanced prompts, advanced report designs and drill maps.
• Involved in slice and dice of data by developing Intelligent Cubes in version 9.x.
• Involved in tuning MicroStrategy Intelligence Server for better performance.
• Worked as backup administrator in charge in adding new users to groups and assigning them security privileges.
• Used MicroStrategy Report Services to generate Report Documents.
• Created various Monthly Dynamic Dashboard documents using features like multiple panel stacks, selectors and customized widgets.
• Created types of reports including Enterprise reports, Dashboard analysis reports and Ad-hoc reports to show the end users.
• Understand the type of schemas that best support MicroStrategy in different scenarios.

Environment: MicroStrategy Reporting Suite 9.X (Intelligence Server, Desktop, Architect, Web, Object Manager, Enterprise Manager, Integrity Manager & Tools), Oracle 9i, Teradata V2R6/V2R5,MS SQL Server 2008/2005, Windows XP.

Confidential, NC

MicroStrategy Consultant

Responsibilities:

• Involved in gathering of business/user requirements.
• Architected schema objects such as attributes, facts and transformations.
• Worked with back end Database Administrators to provide requirements for necessary back end tables
• Worked extensively in MicroStrategy Administration like creation of new users, roles, privileges, shared folders, access controls lists.
• Developed basic and user-specified Metrics (level, conditional, compound).
• Created Consolidations and Custom Groups as per the requirement.
• Used MicroStrategy functions such as Apply Simple and Apply Comparison in metric calculations.
• Developed Filters (relationship, comparison) for complex reports.
• Created drill maps for end users to drill down and recover data.
• Created a Database Instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
• Involved in upgrade process of MicroStrategy 8.1.2 to 9.0.1.
• Created custom attribute functionalities using OLAP, MOLAP services.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Configured Very Large Database (VLDB) Properties at different levels (report, metric, project and database instance).
• Performed Daily Checks for job monitor, user sessions and cache monitor to keep the system stable.
• Performed Micro strategy Intelligent Server Tuning for performance.
• Created Intelligent Cubes and performed sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Used Narrowcast Server for timely delivery of report for authorized users. Created various event based Schedules.
• Actively participated in developing Report Delivery Schedules.
• Created various Monthly Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: MicroStrategy 8.1.2/9.0.1 , Intelligent Server, Narrowcast Server, OLAP/MOLAP Services, MicroStrategy Desktop, MicroStrategy Web, IBM DB2, Teradata V2R5/V2R6, Windows.

Confidential

Microstrategy Developer

Responsibilities:

• Worked with the source systems to have a clear understanding of the data flow and interacted with the users to collect business requirements.
• Created the requirements Documentation for the MicroStrategy projects and also documented the MicroStrategy Environment and DW environment.
• Created semantic layers for understanding the data and generated reports.
• Created Reports using Complex Filters, Compound Metrics and Prompts.
• Used Advanced Prompts, Non Aggregatable Metrics, Conditional Metrics, Transformation Metrics and Level Metrics for creating complex reports.
• Used Customer, Product, Payment, Geographic and Time dimensions and generated complex reports.
• Created several base formulas (mathematical expressions) using existing facts that can be re-used to build any number of metrics, KPI’s in reports.
• Tuned reports performance as per the requirement.
• Customized reports, Documents and deployed them to MicroStrategy web.
• Developed 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 .
• Developed prompts to give end users a choice of different filtering criteria each time they run the report.
• Configured MicroStrategy Mobile and modified existing dashboards to work on iPad and iPhones.
• Performed testing of all reports for the final deployment.
• Imparted user training towards the implementation phase of the project and performed knowledge transfer.
• Documented entire work accomplished for future reference and maintenance purposes.

Environment: MicroStrategy 8.X, Intelligent Server, Narrowcast Server, OLAP Services, MicroStrategy Desktop, Architect, Administrator, Mobile, MicroStrategy Web, SQL Server 2005/2008, Teradata, Oracle 8i, Windows 2008 Server.Tools