SUMMARY

• Senior Microstrategy Developer with 8+ years of experience in implementation of Microstrategy suite, reporting services, OLAP environments and tools, along with strong analytical skills.
• Experience in MicroStrategy tool Suite with MicroStrategy Intelligence Server, MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, Microstrategy schematic modeling, MicroStrategy OLAP Provider, MicroStrategy Web services, Microstrategy Narrowcast Server,.
• Ability to manage project across multiple locations and cross - functional departments, Strong documentation and reporting skills.
• Have hands-on experience in SaaS, PaaS, IaaS, DaaS, SDLC (Agile/SCRUM framework - sprint planning, daily SRUM meeting, product/sprint backlog, sprint review, and sprint retrospective).
• Skilled in populating warehouse catalog, creating attributes, facts, transformations and hierarchies and application objects such as metrics, filters and prompts.
• Expert in designing Schema, Public Objects, Reports, Dashboards, Scorecards in MicroStrategy.
• Experienced with different kinds of Dashboards like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• Adept in Dash Boarding and Documents, worked extensively on panel stacks, widgets and customized the web.
• Created bulk objects using MicroStrategy Command Manager.
• Well versed with the Extraction Transformation and Loading (ETL) processes.
• Involved in the complete software development life cycle (SDLC).
• Strong SQL Skills related to information retrieval and analysis.
• Experience in Designing Data Marts using different multi-dimensional modeling techniques such as Star Schema and Snowflake Schema, FACT and Dimensional tables, Logical and Physical data modeling.
• Involved at all stages of the data warehousing project, setting up the schema and architecture, developing reports, security and deploying to end users.
• Experience in implementing Slowly Changing Dimensions and Strong skills of working with databases like SQL Server, Oracle 11/10g/9i, PL/SQL, Composite Start Studio 7.0, DB2, Netezza, Teradata.
• Experienced in Agile/ Sprints and Waterfall Process.
• Team player with good interpersonal and communication skills and the ability to work in a team environment.
• Adjust to new and challenging situations with experience in handling pressure situations and problem solving.
• Excellent multitasking capability, efficiently plan and prioritize projects with strong technical and business management skills.

TECHNICAL SKILLS

Business Intelligence Tools: MicroStrategy 9.x, 10.x Datastage.8.x

MicroStrategy Components: MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Architect

DB Programming: SQL, PL/SQL

Databases: Oracle 8i/9i, Netezza, Teradata, DB2

Operating Systems: WINDOWS 9x/2000/NT/XP

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Microstrategy Lead Developer

Responsibilities:

• Worked with Product owner and business analyst to define requirements as per user’s requests.
• Extensively worked and developed grid/documents to enable decision-makers to choose the condition for reports and to as view reports in various perspectives.
• Used analytical and governing settings in VLDB properties to tune the SQL and to calculate the metrics in dealing with the nulls and zeroes in data.
• Extensive experience with MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy product suites (Architect, Desktop, Object Manager, and Web).
• Worked with MicroStrategy Architect to build attributes, facts and dimensions and developed perfect logical models for reporting environment.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Involved in giving demos/presentations to end-users and training other developers in MicroStrategy Desktop and Web.
• Interacted with staff for originating, handling, processing, and receiving reports to identify problems and for gathering suggestions for improvements.
• Involved in creating user groups and security filters for users and to assign privileges.
• Involved in study of existing operational systems, data modeling and analysis.
• Involved in scope definition, requirements gathering analysis, logical and creating the physical database physical model.
• Used Netezza to check the ETL process for both composite views and ETL data.
• Involved in preparing detailed design, design reviews, building DataStage jobs, and code reviews.
• Translated business requirements into ETL parallel jobs to maximize object reuse and parallelism and performance.
• Involved in various back end ETL development tasks and Production Support.
• Generated and implemented MicroStrategy schema objects and application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates, using MicroStrategy Desktop and Architect.
• Worked on Microstrategy Dashboard for Executives which giving KPI’s for making business decisions.
• Worked on Dash Boarding and Documents on a daily basis, worked extensively on panel stacks, widgets, and customized the web.
• Worked on Tidal Application environment creating services using subscription sets, schedules, Information objects.
• Performed Administration tasks, like User Creation, Session Handling, Creating Security roles, Analyzing Report performance, administered all aspects of web and intelligence server.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and MicroStrategy Administrator reporting basics using MicroStrategy Desktop and MicroStrategy Web.

Environment: MS SQL Server, Oracle 11, SQL, PL/SQL, UNIX, PuTTy0 .6, Netezza, Composite Start Studio7.0, MicroStrategy 9.4.1, 10.x (Web, Desktop), Windows 2008, MicroStrategy Intelligence Server 9.2.1, Teradata 13.

Confidential, Irving TX

Sr. Microstrategy Lead Developer/Business Analytics

Responsibilities:

• Worked with business requirements subject matter experts to identify and understand requirements and produce the report design specification.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and Zeroes in data.
• Extensive experience with MicroStrategy BI suite. Expertise in building projects and creating reports using MicroStrategy product suites (Architect, Desktop, Object Manager, and Web).
• Created Transformations (table based, formula based) for using in comparative reports like sales of various pharmaceutical products this year to last year (year to date and month to date).
• Utilized MicroStrategy Architect to build attributes facts and dimensions, as well as logical models.
• Involved in trouble shooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Involved in giving demos and presentations to end-users; trained other developers in MicroStrategy Desktop.
• Developed metrics, filters and prompts to choose the condition for reports and view reports.
• Interacted with staff originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements
• Involved in creating user groups and security filters for users and assign privileges.
• Involved in study of existing operational systems, data modelling and analysis.
• Involved in scope definition, requirements gathering analysis, designing logical and physical models and database creation.
• Prepared code reviews and detailed designs.
• Generated and implemented MicroStrategy Schema objects and application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect
• Analysis made with MSFT SSAS Tabular for revenue analysis and Category analysis.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy v9.3.1 to MicroStrategy v9.4.1.
• Used MicroStrategy Narrowcast server to deliver reports directly to business users by various delivery methods.
• Provided Business user training for the MicroStrategy Desktop/Web.
• Created the Metadata & Statistic tables for the MicroStrategy projects.

Environment: MicroStrategy 9.4.1/9.3.1 (MicroStrategy Developer, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 13.0, Oracle 11g, UNIX, Windows7.

Confidential, Charlotte NC

Microstrategy Lead Developer

Responsibilities:

• Expertise in OLTP/OLAP System Study, developing database schemas such as star schema and snowflake schema used in relational, dimensional and multidimensional modelling.
• Expertise in creating document from multiple datasets.
• Expertise in creating documents and drill reports.
• Implemented security for different users to view reports for their regions using security filters.
• Experience in creating complex reports in MicroStrategy Desktop using features such as Templates, Transformations, complex filters, Custom Groups and Consolidations.
• Extensively worked on creating and integrating MicroStrategy reports, dashboards, and objects (Attributes, Facts, Metrics, Filters and Prompts) intelligent cubes, and Security filters.
• Involved in designing Ad-hoc Reports, Scorecards, Dashboards and Graphical Reports. Managed user profiles, access and privileges.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Exposure in dealing with a variety of relational databases including Oracle and SQL Server.
• Extensive work experience with Ad hoc reporting using SQL queries and standard reporting environment.
• Extensive experience and knowledge with data warehousing concepts such as dimensional modeling (star schema & snow flake schema), data marts, fact and dimensional tables.
• Expertise in defining MicroStrategy Narrow cast server objects such as service, schedule, subscription set and information objects.
• Developed complex SQL queries and involved in setting up VLDB properties for performance
• Troubleshooting of MicroStrategy application issues internally and with vendor
• Hands-on experience using Datastage 8.x to create transformations and mapping for ETL.
• Experience in operating systems such as UNIX and Windows NT/2000/ 98/95.

Environment: MicroStrategy 9.0.1 (Web, Desktop), MicroStrategy Intelligence Server 9.0.1, Teradata, UNIX

Confidential, Charlotte, NC

Sr. Microstrategy Developer

Responsibilities:

• Worked as a MicroStrategy Analyst in team of three for design and development in the marketing department for insurance domain project.
• Created logical data models, recognize source tables and columns, to build MicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Responsible for data modelling, including star schema modelling, and snowflake modelling.
• Created joins and relationship according to the data model schema.
• Conducted meetings to gather user and business requirements and also carried out quality reviews with the users and created documentation for the same.
• Identified and modified source tables and columns in the warehouse required to create the MicroStrategy project.
• Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Extensively worked in developing metrics (Compound metrics), filters, custom groups and consolidations for complex reports.
• Designed templates and 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.
• Used transformations for comparative reports like claims this year to last year (year to date and month to date).
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Created technical design documents, source to target mapping based on the business requirements.
• Developed customized and ad-hoc reports using templates, metrics and filters for business analysis using MicroStrategy.
• Desktop with features of drilling options (drill down, drill up and drill anywhere).
• Involved in the extraction, transformation and loading of the source data to the target Teradata database.
• Involved in source data analysis, documented data scenarios to build data for the test bed.
• Worked closely with SMEs to understand the business and document the business requirements.
• Worked extensively on different stages including Transformer, Aggregator, Merge, Join, Copy, Lookup, Lookup File set, Filter, Change Capture, Oracle Enterprise, Column Generator, etc., for data cleansing and transformation.
• Handled slowly changing dimensions, surrogate key assignment and change data capture using change capture, transformer stages

Environment: MicroStrategy Architect 9.0.1, MicroStrategy Intelligence Server 9.0.1, MicroStrategy Web 9.0.1, MicroStrategy Narrowcast Server 9.0.1, MicroStrategy OLAP Provider, Oracle 10g and UNIX.

Confidential, Los Angeles CA

Microstrategy Developer

Responsibilities:

• Involved in data modelling/Microstrategy architecture and creating database views/schema objects.
• Extensively created Microstrategy objects such as facts, attributes, metrics, filters, prompts, etc.
• Developed, customized various reports using templates, metrics, filters, prompts, custom groups, consolidations and transformations.
• Used MicroStrategy desktop (templates, filters, and metrics) to generate advanced reports in grid, Graph, and SQL mode, consisting of data analysis by combining a template with filters.
• Worked in report services, developed dashboards and scorecards for visualization.
• Created and published intelligence cubes for improving the performance of reports.
• Used several new controls for dashboards such as time series slider, radio buttons and dropdown menus for the flash version of the dashboards.
• Performed administration tasks such as creating users/user groups/ security filters and monitoring user Sessions/jobs/migrations to different environments.
• Excellent experience configuring VLDB properties to fine-tune reports.
• Worked with SQL by extensively using joins, sub queries and advanced functions.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidations and custom groups
• Designed and developed the reporting layer by creating schema that fit reporting requirements.
• Involved in MicroStrategy architectural design, developed schema objects and application objects
• Developed static and ad-hoc reports.
• Created interactive dynamic dashboards and scorecards for different level of users with drill down capabilities.
• Improved query performance by using parallelism and creating Indexes, hints and partitions.
• Performed data driven testing for multiple sets of data.
• Created SQL scripts to query system views and tables to validate the database and got performance related statistics.
• Used materialized views in places where the data did not change very frequently.
• Worked with user groups and business users in defining requirements.
• Performed analysis on customer/sales/products data using complex SQL queries.

Environment: Microstrategy 8.1 (Administrator, Desktop, Architect, Intelligence Server, Narrowcast Server, Web), Oracle, Toad, Erwin, Informatica 6.2, MS SQL Server, DTS, DB2, Terada, Windows, UNIX.