SUMMARY:

• MicroStrategy professional with almost 7+ years of result - driven experience in Data Modeling, Designing, Architecting Data Warehouses and BI applications in diverse industrial sectors like manufacturing, pharmaceutical, banking, retail and insurance.
• Full life cycle implementation encompassing Business requirements definition, Deployment, Data Warehouse Architecture, Data Analysis, Logical and Physical Data Modeling and Validations.
• Experienced in all the products of MicroStrategy Product Suite namely MicroStrategy Desktop, Intelligence Server, Administrator, Architect, Web, Command manager, Object manager, Enterprise manager and Narrowcast Server.
• Adequate knowledge of fundamental Data Warehousing concepts such as Entity Relational modeling, Dimensional modeling, Star and Snowflake schemas, modeling Data marts.
• Experienced in Data Analysis, Identification of Dimensions, Facts and Hierarchies.
• Expertise in creating Schema Objects (Attributes, Facts, Hierarchies, Transformations) and Public Objects (metrics, filters, prompts, Custom Groups, Consolidations, Templates) to develop Documents and reports.
• Have used Level Metrics, Conditional Metric, Advance Filter (relationship and using ApplySimple) and Advanced prompt.
• Expertise in using Pass-Through Expressions like ApplySimple, ApplyComparison etc. to develop complex Filters and Transformations.
• Creation of Custom groups, Consolidations, Drill maps, Documents, Scorecards, OLAP Reports and Dashboards in order to cater the business needs.
• Expertise in implementation of MicroStrategy Office solution to build Excel based reports.
• Very good experience in interacting with the clients and understanding business application, business data flow and data relations from them.
• Very good experience in working with very large databases on Oracle, Teradata, SQL Server, DB2 with MicroStrategy Suite.
• Experienced in developing Ad-hoc interfaces enabling end-users to generate their own reports.
• High proficiency with Informatica, and have experience utilizing its products to move flat-files from various sources to Data Warehouse as a part of ETL processes.
• Experience in Troubleshooting Microstrategy Implementations using ScanMD and MDDoctor and performing production support.
• Strong working knowledge of SQL, ability to understand and write complex SQL queries using Stored Procedures, Joins, Views, Triggers and Indexing strategies.
• Expertise in test planning and testing methodology for Quality Assurance validation of MicroStrategy configuration, reports and other output.
• Excellent multitasking capability, efficiently plan and ability to meet deadlines.
• Excellent problem solving skills with strong technical background and good interpersonal skills.
• Ability to work under minimum supervision and have the ability to grasp technical concepts quickly.

TECHNICAL SKILLS:

Business Intelligence Tools: MicroStrategy 9.0/8.1.x/7.5.x (Desktop, Architect, Intelligence Server, ProjectBuilder, Narrowcast Server, Distribution services, OLAP services, RS Documents,Score Cards, Dashboards, SDK, Command Manager, Enterprise Manager,Object Manager), Business Objects Web Intelligence

ETL Tools: Informatica 8.1/7.1/6.2, DataStage 7.5Operating Systems: Windows NT4 Server 2000/XP-Pro/Vista/7, UNIX/ LINUX, Solaris, AIX

Languages: C & C++, SQL, PL/SQL, TSQL, VB 6, VB.NET, HTML 4.0

Utilities: ERwin 4.0/3.5.x/3.0, Microsoft Visio 2002, SQL Assistance, WinDDI

Database: Oracle 10g/9i/8i/8.0, IBM DB2, MS Access 2003/2007, SQL server 2000/2005/2008, Teradata V2R5.

PROFESSIONAL EXPERIENCE:

Confidential, St Petersburg, FL

MicroStrategy Developer

Responsibilities:

• Performed customer Requirements Gathering, requirements Analysis, Design, Development, Testing, end User Acceptance Presentations of BI Projects.
• Ensures the testing and verification of new reporting processes
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser.
• Worked extensively on creating MicroStrategy Objects like Metrics, Compound Metrics, Facts, Filters, Custom Group, Consolidation, Attributes, Hierarchies and Prompts for MicroStrategy reports using MicroStrategy Architect.
• Performed Administrator tasks like User Creation and Creating Privileges
• Scheduled and Delivered Reports to Business Users in Desktop and Web via Narrowcast Server.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Created Advanced filter, Advanced metrics, Advanced Prompts to create complex reports.
• Created Drilling reports across different within the Hierarchy and other hierarchies.
• Created Transformations for using in comparative reports like revenue this year to last year.
• Involved in troubleshooting of MicroStrategy Prompts, Filters, Templates, Consolidations, Custom Groups objects in an Enterprise data warehouse team environment.
• Created Intelligent Cube to decrease the Load on server while users watching same reports same time.
• Taken advantages of VLDB properties like star join, query and sub query optimization to optimize the query.
• Automated and improved existing manual processes and Optimizing the server platforms using Caching and Scheduling.
• Created reports using MDX Data source and Free Form SQL.
• Worked with DBA to provide requirements for necessary back end tables.
• Worked with Database Architect and ETL Developer for Data availability and data model related issues by providing solutions that support MicroStrategy application.
• Extensively worked in both Ad-hoc and standard reporting Environments and Involved in creating reports scalable to large volumes of data.
• Created a wide variety of fully interactive scorecards, dashboards, and enterprise reports.
• Created dynamic dashboard using Widget, Panels, Selectors, Map, Graphs and Grid.
• Involved in the ongoing delivery of migrating client mini-data warehouses or functional data-marts from Oracle environment to Teradata.

Environment: MicroStrategy 9.0.1 (Desktop, Architect, Intelligent Server, Web, Narrowcast Server, Object Manager,Teradata 13, SQL Assistant, Db2,Oracle 10, PL/SQL,LINUX, Windows XP Professional, UNIX.

Confidential, Wilmington, DE

MicroStrategy Developer

Responsibilities:

• Gathered requirements from Business users, Stake holders for the project.
• Followed Full Software Development Life Cycle Process (SDLC) of Initiation, Planning, Analysis, Design, Construction, System Testing and Implementation.
• Creation and modification of Schema Objects (Attributes, Facts, Hierarchies and Transformations) as per the data model.
• Proposed naming standards for Attributes, Metrics and Filters to make easy for Business users.
• Applied OLAP and statistical functions for analyzing the differences in the revenue generated by a particular segment of customers.
• Created Transformation metrics to compare monthly, quarterly and annual sales.
• Prepared documentations related to the MicroStrategy Project implementation.
• Created various Hierarchies which allow users to drill on reports.
• Developed Public objects like Metrics, Custom Groups, Consolidations, Prompts, Templates and Filters as per requirements.
• Involved in creation of Advanced Metrics like Conditional, Level, Non-Aggregation, Rank and Transformation Metrics.
• Used Pass-Through functions in MicroStrategy like the ApplySimple & ApplyComparison whenever necessary.
• Tested all reports by running queries against the database.
• Coordinated with Database Architect and ETL developers for data availability and data model related issues by providing solutions that support MicroStrategy application.
• Developed various Ad-Hoc reports and Canned reports for the users.
• Used Auto Prompts Filter feature to give the end-user a choice of different filtering criteria each time they run the report.
• Involved in to improve performance tuning including Microstrategy schemas, individual reports and leveraging intelligent server
• Used Enterprise Manager to check the performance of the reports and usage of objects.
• Used Object Manager to Migrate Microstrategy object from Development environment to production and Quality Assurance Environment.
• Created Static and Dynamic Dashboards using various widgets according to the requirement.
• Provided Data Access to Executives, Managers (Casual users) and Business Analysts (Power Users). Worked as a link between Business and Technical groups.
• Scheduled reports through the MicroStrategy Narrowcast server and created services to deliver a wide range of personalized information to users through email and other file services.
• Extensively used report services to create Dashboards to create summary level reports using multiple Datasets.

Environment: MicroStrategy 9.0(Desktop, Architect, Web, Object Manager, Command Manager, Integrity Manager, Enterprise Manager, SDK), Microstrategy Intelligence Server 9.0, Microstrategy Narrowcast Server 9.0, ERwin 4.0, Oracle 9i/10g, Informatica 8.1/7.1, Window XP-Professional, Windows NT4, AIX v6.1 Unix

Confidential, Baltimore, MD

MicroStrategy Developer

Responsibilities:

• Gathers information from existing systems, analyzes program and time requirements. Assists project manager in preparing time estimates and justification for assigned tasks.
• Involved in meetings with business users to discuss and finalize the requirements and design of different reports according to the requirements.
• 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.
• Interacted with DBA and Data Modeler to build Dimensional Data Modeling (Star Schema and Snow-Flake Schema).
• Worked on Migration of report form existing business environment to Microstrategy environment.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy Desktop.
• Performed routine administrator tasks during absence of MicroStrategy administrator like setting User security filters on some of the MicroStrategy Objects and restarting the Intelligence Server.
• Created Users, Roles & Privileges using the MicroStrategy Desktop (Administrator).
• Extensively worked with Object Manager to migrate the MicroStrategy Objects from development to QA and then to production environment.
• Used several new controls for Dashboards like Time series slider, Radio buttons, and Drop down menus for the flash version of the Dashboards in 9.0
• Tested all the reports by running queries against the warehouse using Queryman. Also compared those queries with the MicroStrategy SQL engine generated queries.
• Resolved attribute role problems in Data models by developing table Aliases and Attribute Role recognition methods in VLDB settings.
• Created Ad-hoc Reports by drilling up, down, with across hierarchies.
• Developed Auto Prompt Filters that gave user a choice of different filtering criteria each time they run the reports.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing, Thresholds and Report Optimization.
• Extensively used Integrity Manager to test reports when upgraded from MicroStrategy 8.1.2 to MicroStrategy 9.0.
• Provided access to MicroStrategy Reports via Microsoft Excel using MicroStrategy Office.
• Used MicroStrategy Narrowcast Server to deliver reports directly to business users by various delivery methods.
• Generated Freeform SQL reports writing SQL queries for complex reports.
• Involved in troubleshooting of reports and eliminating cross joins in the SQL to produce correct results.

Environment: MicroStrategy 9.0/8.1.2 (MicroStrategy Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, OLAP Services, Project Manager, Intelligence Server), Teradata V2R5, Query Man, UNIX, SMTP, IIS, Windows XP- Professional, MS Office, IBM Web sphere Server

Confidential

SQL Developer

Responsibilities:

• Performed System Analysis, Dataflow Diagram, Entity Relationship Diagram (ERD) and Created tables.
• Prepared prototype screens and reports and set standards.
• Involved in the Design and Development of the product.
• Developed various user interfaces and report presentation mainly for on-line analysis using Oracle
• Forms 4.0, Reports 2.0 and interfaces between them.
• Responsible for writing Stored Procedures using PL/SQL and designing the reports.
• Used PL/SQL extensively for writing Functions and Database Triggers.
• Performed Database testing & maintaining the data by using the procedures.
• Designed and validated the Forms according to client requirement by using VB.
• Performing Data Transfer/Migration using Export/Import.
• Involved in developing cross- and report generation programs.

Environment: MS-SQL Server 2000, Developer 2000(Forms 4.0, Reports 2.0), SQL, PL/SQL and UNIX, Windows

Confidential

SQL Developer

Responsibilities:

• Design/Implement/Optimize SQL Code, queries, indexes, stored procedures, views, functions related to the application
• Developed data migration procedures and policy
• Worked with architecture, application development and support to achieve a reliable, top performing environment that meets current and future business objectives
• Train and develop technical support staff to better utilize database environment
• Endured that the code is written keeping in mind any security issues such as SQL Injection
• Develop reports in SQL Server Reporting Services
• Creating SQL applications to facilitate current and future business objectives