SUMMARY

• Over 7+ years IT Experience in the Analysis, Design, Development and Implementation of Relational Database, OLTP and OLAP Tools like (Micro Strategy 9.x/8.x) and oracle.
• Experienced in using Micro Strategy Tool Suites including (MicroStrategy Intelligence Server, Narrowcast Server, Desktop and Web).
• Experienced in installation,configuration,Project creation and tuning of MicroStrategy Business Intelligence.
• Very good understanding of Data Warehouse Architecture and Designing.
• Experience in working on Direct Project Source and Server Project source.
• Involved in Creation of Schema Objects (facts, attributes, Hierarchies, Transformations) to Develop User Objects.
• Expertise in developing Public Objects (filters, prompts, metric, custom groups, consolidation, searches) to develop documents and reports.
• Knowledge in using Informatica Power Center 7.x. Knowledge in html, java.
• Expertise in Creating Document from multiple Datasets like Map Application Diagram, Grid and graph.
• Expertise in creating Hyper Links in Documents and Drill Reports.
• Experience in creating advanced Custom Filters by using Pass - Through Expressions in Micro Strategy.
• Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.
• Experienced with different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• Fine tuning of the MicroStrategy reports using Data Mart Reports, Partition Mappings and Aggregate tables.
• Experience in Intelligent cubes implementation
• Involved in Administration tools like Object Manager and Command Manager.
• Knowledge in Data Modeling using ERWIN 9.0.x, Data mart and OLAP for business analysis using star & snowflake schemas, for faster and effective querying.
• Expertise in Integrity Manager.
• Implemented Unit Test Cases (UTC) and necessary Test Plans to ensure the successful execution of the data loading processes.
• Actively involved in providing training to end-users

TECHNICAL SKILLS

BI Tools: MicroStrategy v9.4.1, v9.3.1, v9.2.1, v9.1.0, v9.0.2, v8.0.3/8.1 (MicroStrategy Administrator, MicroStrategy Desktop, MicroStrategy Intelligence Server, MicroStrategy Web, MicroStrategy Narrowcast Server, MicroStrategy OLAP Services, MicroStrategy Architect, MicroStrategy Distribution Services, MicroStrategy Office, Narrowcast Server), Cognos, Business Objects.

Platforms: Windows NT 4.0 /NT Server/2000/XP Pro/2003 Server, UNIX.

Data Modeling: Erwin 4.0/3.5.2, ER Diagrams.

Databases: Oracle 10g, 9i/ 8i, Teradata, MS SQL Server, Access, DB2, Netezza.

Languages: C++, C#, SQL/PLSQL.

Web Servers: Apache/Tomcat, IIS, Web Sphere.

PROFESSIONAL EXPERIENCE

Confidential,Washington

MicroStrategy Sr. Developer

Responsibilities:

• Involved in meetings with business users to discuss and finalize the requirements and design of the reports.
• Developed 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.
• Designed various Dashboards/Scorecards reports, which provide practical ability for business user to design and refine their own reports without programming.
• Managed, Trained and guided junior MicroStrategy Developers of team size 5.
• Created Security roles, Security Filters and assigned them to groups and users to meet the corporate requirements.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.4.
• Performed routine administrator tasks during absence of MicroStrategy 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 Dash boards like time series slider, radio buttons, and drop down menus for the flash version of the dashboards in 9.4.
• Tested all the reports by running queries against the warehouse using Query man. Also compared those queries with the MicroStrategy SQL engine generated queries.
• 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.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user training for the MicroStrategy Desktop/Web.

Environment: Micro Strategy 9.4.1/9.3.1 (Micro Strategy Administrator, Micro Strategy Architect, Micro Strategy Desktop, Micro Strategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Teradata 14.0, Oracle 12c/11g, UNIX, Windows XP.

Confidential, Parsippany, NJ

MicroStrategy Developer / Administrator

Responsibilities:

• Worked on Restructuring, Re-architecting and Deploying MicroStrategy projects to align with EDW 2.0.
• Involved in business requirements gathering for Supply Chain, Store Ops, Customer/Marketing, Finance/Sales Audit, Loss Prevention, Human Resources, Logistics departments.
• Used the related subject areas in Teradata Retail Logical Data Model and developed physical data model.
• Upgraded the MicroStrategy environment from v9.2.1 to v9.3.1 and upgraded the projects metadata. Moved the MicroStrategy Metadata to robust system.
• Created a new Enterprise MicroStrategy project that consists of the modeled subject areas.
• Developed useful existing reports and created dashboards with Key Performance Indicators
• Created Customer behavior dynamic Dashboards and Spending Pattern Scorecards involving graphs and statistical calculations
• Migrated the MicroStrategy objects from Development to Test system for user testing and to Production system
• Configured the Enterprise Manager to analyze the user traffic and the projects/reports that are being used.
• Worked with users to determine which projects are required moving forward
• Interacted with DBA team in tuning queries by collecting statistics, creating indexes
• Followed best practices and created standards document for MicroStrategy project development

Environment: MicroStrategy 9.3.1/9.2x, Desktop, Web, Intelligence Server, Narrowcast Server, Teradata 13, Erwin r9, Visio 2013, Windows XP.

Confidential, Atlanta, GA

Sr. MicroStrategy Developer

Responsibilities:

• Interacted with Business Analysts, Business Users and Managers for Gathering, Analyzing, Documenting Business Requirements, Functional Requirements and Data Specifications.
• Involved in Creating Schema Objects (facts, attributes, hierarchies, Transformation) and application objects (filters, prompts, metrics, consolidations, custom groups, reports) needed to create the MicroStrategy objects necessary for the deliverable.
• Created transformational metrics (Sales, Sales Target, Market Share, and Growth) to compare monthly, quarterly and annual sales.
• Extensively worked in developing Metrics, Derived metrics, Compound metrics and Filters for complex reports.
• Created advanced metrics (level, conditional), filters, consolidations, custom groups and reports with VLDB properties.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Creating Dashboard Reports to view personalized reports based on user requirements
• Created different kind of Dashboards like traditional performance summery, traditional metric, dynamic content in both the interactive & flash mode.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Used ApplySimple and ApplyComparison functions to develop complex Filters and Transformations.
• Involved in creation of Data Mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Involved in optimization of code and tuning queries for performance.
• Set-up the narrowcast environment and created services using subscription sets, schedules, Information objects.
• Create a test plan, perform unit test and send the test plan along with the files generated for QA.
• Worked extensively in Micro Strategy Administration like Creation of new users, roles, privileges, shared folders, access controls Lists.
• Involved in creating Security filters to end users to access data Based on their privileges.
• Responsible for keeping team members on track toward completing the terms of goals.
• Provided post production support to end-users.

Environment: MicroStrategy 9.2.1/9.0x, Desktop Reports, Narrowcast server, Oracle 11g, SQL Server 2008/12, SQL, PL/SQL, DB2, TOA

Confidential, Princeton, NJ

MicroStrategy Sr. Consultant

Responsibilities:

• Developed MicroStrategy schema and applications objects such as attributes, metrics, prompts, filters, templates, compound metrics, custom groups and consolidation, security Filters and transformation Metrics.
• Defined the relationship between the attributes, facts and other objects within MicroStrategy.
• Defined Hierarchies and drill functionality within MicroStrategy.
• Designed, developed and maintained MicroStrategy reports using standard features such as sort, rank, report filters, view filters, drill up, drill down and prompts.
• Developed complex MicroStrategy reports using advanced filters, conditional formatting, transformation metrics, level metrics and custom groups.
• Troubleshoot and tuned MicroStrategy reports to determine and fix data issues, incorrect joins, incorrect results and performance issues.
• Coordinated with different teams to deploy the MicroStrategy changes between environments.
• Implemented user level security, object security, user roles and groups, create, modify and delete users, govern thresholds, set up distribution services using Narrowcast Server, install and configure MicroStrategy Desktop.
• Troubleshoot performance alerts, application availability alerts, system utilization alerts, delivery issues with Narrowcast reports and other similar issues with Intelligence Server, Narrowcast Server, Web Server and Mobile Server.

Environment: MicroStrategy 8.1.2 Product Suite (Administrator, Architect, Desktop, Object Manager, Enterprise Manager, Narrowcast Server,), Teradata, SQL Server 2008, Informatica, Windows NT, UNIX and Toad.

Confidential

MicroStrategy Developer

Responsibilities:

• Worked with the Business Analysts to understand the report requirements
• Prepared the Design Documents as per the report requirements
• Creating required Attributes, Facts, Metrics, Custom Groups, Hierarchies and templates
• Created the application objects: filters, metrics, and prompts
• Developed the Reports as per the Design Documents
• Extensively used the report data options to create the report as per the requirements
• Manually Running the Failed services and Monitoring the Jobs and Tracing the Log Files.
• Notifying the MicroStrategy Users for all the Updations, Release Schedules and System Maintenance period.
• Performed the report data manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.,
• Validating the reports as per the user requirements (Unit Testing)
• Provided the training to end users
• Object migration different environments like Dev, UAT and PROD.
• Created a services, Users and Subscription sets in Narrowcast Server.
• Delivered reports to users using various delivery methods in Narrowcast Server.
• Scheduled reports and Report Services documents using MicroStrategy.
• Created users, user groups and roles to manage security.
• Created several Security Roles according to user group requirements and assigning security roles to user groups.

Environment: MicroStrategy 8.1, 9.0.2, DB2, Informatics, Windows Xp, Remedy

Confidential

MicroStrategy Developer

Responsibilities:

• Designed and developed presentation objects, reports, and dashboards for delivery of BI solutions.
• Defined, implemented and refined the BI solution development methodology based on industry best practices.
• Worked with PeopleSoft MicroStrategy dashboarding and BI solution including Metadata, Data Sources and reports.
• Developed technology specifications and ensured that any new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible.
• Applied architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability.
• Configured, maintained, and administered MicroStrategy models, packages, reports, and dashboards.
• Monitored and supported multiple jobs, scripts, and events.
• Deployed and supported MicroStrategy reports, ad-hoc packages, and In-memory cubes.
• Continually monitored and tuned the performance of the platform.
• Developed standard OLAP features such as intelligent cubes (I Cubes), data aggregation, derived metrics, Banding, Aliasing, Page by, Pivoting, Sorting, Thresholds and Subtotals.
• Trained different types of end users on MicroStrategy desktop and Web; supported huge number of users.
• Worked extensively on MicroStrategy Narrowcast Server to deliver scheduled reports using Static and Dynamic Subscriptions.
• Optimized tables, views and SQL definitions using indexing to enhance performance.
• Worked on Setting up user accounts, building security models and privileges, migration of objects from different environments, and performance monitoring of the MicroStrategy tool.

Environment: MicroStrategy 8.2.1/8i Product Suite (Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Command Manager, Web, Mobile), TeradataV2R6, Oracle 11g, DB2, Data Stage, Informatica 8.6.1, Windows NT, UNIX and Toad.