SUMMARY:

• Software professional with 8 years of experience in the analysis, design and development of Data warehouse and Business Intelligence applications.
• Experience in Data Warehousing concepts such as Dimensional Modeling, Star Schema, Snowflake Schema, Data Marts, OLAP, Fact and Dimension Tables.
• Strong technical knowledge in Microsoft SQL server and SQL Server Integration Services(SSIS).
• Efficiently provided Business Intelligence Solution using MicroStrategy Reporting Suite Which Includes Developer, Web, Mobile, Visual Insights, Intelligence server, Architect, reporting services, OLAP, Narrowcast, Distribution Services, Administrator, Enterprise Manager, Object Manager, Integrity Manager & Tools.
• Specialized in developing stored procedures, functions, packages and database triggers using Oracle SQL and PL/SQL. Proficient in using Oracle 10g/11g, SQL Server 2000/2005.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, database instances, users, user groups, security role etc.) using Microstrategy Developer.

TECHNICAL SKILL:

BI Tools: Microstrategy 10.x/9.x/8.x (Developer/Desktop, Report Services, ETL, Web, Mobile, Architect, Administrator, Intelligence Server, Enterprise Manager, Distribution Services, Object Manager, Integrity Manager, Command Manager), Tableau (Desktop, Server)

Tools: / Utilities: Teradata SQL Assistant, Toad, SQL Developer, Razor SQL

Operating Systems: Windows 8/7/XP/NT/2000UNIX (AIX, Solaris, SCO - UX, HP-UX)

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. MicroStrategy Consultant

Responsibilities:

• Responsible for converting business specifications into technical specifications.
• Developing, Maintaining, Enhancement, testing and leverage the enterprise Reports based on user needs.
• Designed and developed advanced grid reports, documents, Web & Mobile dashboard Applications for different Marketing & Sales users.
• Used Integrity Manager to test backend SQL and Data between Projects.
• Created Dynamic Web, Mobile & Visual Insights Dashboards using features like Panel Stacks, Selectors, Information Windows and Widgets like Time Series Slider, Interactive Bubble Chart, Thermometer, ESRI Map, Data Cloud, Heat Map etc.
• Created Dynamic Dashboards showing Daily/Weekly/Monthly/Yearly performance metrics using various graphs and widgets.
• Created Customer Insights, Sales Insights prompt based report to support various business users.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, database instances, users, user groups, security role etc.) using MicroStrategy Developer and/or Web.
• Worked on reducing SQL passes and making sure the facts pointing to the right tables using VLDB properties.
• Created complex metrics involving MTD/YTD Transformations and Level Dimensionality.
• Troubleshooting MicroStrategy objects like Attributes, Facts, Transformations, Metrics, Prompts, Filters, Templates, Consolidations, and Custom Group.
• Created Intelligent Cubs to improve performance.
• Created Sales Trending Dashboard, Campaign Analysis Dashboard and Customer Analysis Dashboard for Marketing & Sales departments.
• Used Distribution Services for timely distribution of reports to users.
• Worked in Microstrategy Administration creating new users, roles, privileges, shared folders, access controls list.
• Developed PL/SQL scripts for ETL (Extraction, Transformation & Loading).
• Used the VLDB properties for performance tuning and SQL optimization.
• Created Free-Form SQL reports for short-term reports, ad-hoc requests that are not supported by existing schema model.
• Used Object Manager to create packages to promote code from one environment to other.
• Responsible for providing on time deliverable solutions.
• Installed and configured all Microstrategy products including Intelligence Server, Microstrategy Desktop, Object Manager, Command Manager, Web and Microstrategy Narrowcast on Servers and mapping to Client machines.
• Configured Enterprise Manager 9.4.1
• Suggested Database Schematic Changes to Database Administrators to improve MicroStrategy repots performance.
• Worked with the DBA on issues of database performance and security.
• Provided best solutions to meet client’s requirements not compromising data integrity look & feel of the applications, better end user experience & performance.

Environment: MicroStrategy Reporting Suite 10.1/9.4 (Intelligence Server, Developer, Architect, Web, Mobile, ETL, Object Manager, Enterprise Manager, Integrity Manager & Tools), Teradata, Oracle Exadata, PL/SQL, Windows 7

Confidential, Arcadia, WI

Sr. MicroStrategy Consultant

Responsibilities:

• Extensively involved in Data modeling, Administrator tasks, Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.
• Narrowcast services development, complete automation of services using page by execution for performance and Use of prompt answering of Narrowcast services.
• High user interaction, understanding their requirement.
• Involved in creation of logical views and Freeform SQL Report.
• Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.
• Administrative experience creating user, setting up privileges. Security access to metrics and attribute level.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.
• Extensive use of dynamic dashboard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.
• Develop Standard as well as Ad-Hoc Reports (Visual Insights Analysis) using MicroStrategy BI platform.
• Experience with Object manager and Enterprise manager to maintain object throughout the project life cycle and improving performance of the system.
• Experience with OLAP services. Understanding of MicroStrategy architect and its data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, metadata, project source and project.
• Involved in Performance tuning of SQL for long running reports.
• Involved in various back end ETL development tasks, UAT testing and Production Support.
• Actively participated in developing Report Delivery Schedules.
• Created various Monthly Dynamic Dashboard documents for GBCR with multiple panel stacks, selectors and customized widgets
• 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.

Environment: MicroStrategy Architect 9.4,9.3,9.2.1, MicroStrategy Desktop 9.4,9.3,9.2.1, MicroStrategy Web 9.4,9.3,9.2.1, Narrowcast Server, ETL, SQL server, PL/SQL, ORACLE 10g/11g, Netezza, Informatica Designer 6.0, Windows 2000/NT.

Confidential, Mc Lean, VA

Sr. Microstrategy Developer

Responsibilities:

• Responsible for converting Business Requirement Document (BRD) & Functional requirement document (FRD) into Technical Traceability & Mapping document for technical team for development purpose.
• Responsible for interacting with end users & Business Analysts on a regular basis to capture mapping gaps.
• Performed Requirement Analysis to collect various business measures.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, Hierarchies, Transformations etc.), Application Objects (such as Reports, Documents, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups, Derived Elements etc.)
• Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics and pass through functions.
• Created several Engagement Documents (Decks) with multiple layouts (Slides) to support business needs.
• Design and creation of reports transformation and derived metrics filter objects prompts drill maps user Hierarchies dynamic custom groups consolidations Worked with DBA's to tune SQL generated by MicroStrategy reports and to collect DB statistics and in creation of additional indexes if necessary Designed dynamic dashboards for easy data magnification.
• Used Distribution Services for timely distribution of reports to users.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Worked in Microstrategy Administration creating new users, roles, privileges, shared folders, access controls in Development Environment.
• Worked in writing SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Responsible for coordinating with offshore testing team to share the mapping documents and see the progress of testing process.
• Responsible for populating the Aggregate Summary table in RUBY Database to support Engagement Decks by Oracle packages.

Environment: MicroStrategy Reporting Suite 9.2 (Intelligence Server, Developer/ Desktop, Architect, Web, Mobile, Object Manager, Enterprise Manager, Integrity Manager & Tools), Oracle, Windows 7

Confidential, Malvern, PA

Sr. MicroStrategy Consultant

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Responsible for gathering and refining business requirements from the Business users.
• Architecting the MicroStrategy Projects which involved in creating the Attributes, Facts and Hierarchies.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports and created advanced objects like Derived Metrics, Compound Metrics and Derived Elements.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Created Ethnic Dashboards & Churn Dashboards for Marketing vertical from scratch.
• Created Customer & Sales Insights prompt based report to meet the requirements of several Marketing & Sales vertical users.
• Worked on BAU tasks and enhancements to the existing reports.
• Heavily worked with the end users to finalize the Dashboard layouts and worked on fine detail formatting for a desired look and feel.
• Used pass-through functions like Apply Simple & Apply Comparison whenever necessary.
• Created different Transformations to get the last year actual transactions, week to day, week to period, week to quarter, week to year and effectively used them with the metrics.
• Optimized Query Performance by using VLDB settings.
• Worked on standardizing Microstrategy environment.
• Used the Object Manager to migrate objects to different environments.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Troubleshooting inconsistencies in the Metadata using ScanMD.
• Involved in giving demos/Presentations to end-users and other developers in MicroStrategy Desktop and Web.

Environment: MicroStrategy Reporting Suite 9 (Intelligence Server, Developer, Architect, Web, Mobile, Object Manager, Enterprise Manager, Integrity Manager & Tools), PL/SQL, Teradata, Windows 7

Confidential, Columbus, OH

Sr. MicroStrategy Developer

Responsibilities:

• Mainly focused on Maintaining optimal performance of business intelligence application, performance monitoring, capacity planning, and tuning of multiple projects.
• Created Schema Objects, developed application objects extensively worked on Dashboard creation.
• Ownership of project schemas and all aspects of MicroStrategy Administration functions for projects, servers, user & security administration.
• Migrated Objects between different environments using Object Manager. Created and executed scripts using Command Manager.
• Creating, Modifying the Security filters. Security roles, User connection monitor, DB Instance modification, Job prioritization changes as per the requests.
• As an administrator created users, Duplicated projects, Involved in Migration of projects.
• Developed Metrics, Filters, Prompts to achieve the functionality of the canned reports
• Created advanced objects like Derived Metrics, Compound Metrics.
• Developed Microstrategy Dynamic Dashboards in various modes and worked extensively on widgets.
• Created logical data models by recognizing the source tables and columns, to build Attributes, Facts, Hierarchies and Relationships that are necessary to create a MicroStrategy project.
• Created logical data models to recognize source tables and columns, to build MicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Extensively used MicroStrategy administration tools include: MicroStrategy Command Manager, MicroStrategy Enterprise Manager, and MicroStrategy Object Manager, Job Monitor.
• Worked on MicroStrategy Enterprise Manager to collect and analyze statistics on subscription usage and delivery success using out-of-the-box fully functioning BI application.

Environment: MSTR 8.1.2 HF 5 and MSTR 9.0.2 HF4, UDB database, UNIX OS, PROD - Cluster 3 environment, Informatica 8.1