SUMMARY

• Over 7+ years IT Experience in teh 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 wif different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.
• Fine tuning of teh 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 TEMPeffective querying.
• Expertise in Integrity Manager.
• Implemented Unit Test Cases (UTC) and necessary Test Plans to ensure teh successful execution of teh 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, Bothell, Washington

MicroStrategy Sr. Developer

Responsibilities:

• Involved in meetings wif business users to discuss and finalize teh requirements and design of teh reports.
• Developed different reports according to teh 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 wifout 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 teh 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 wif Object Manager to migrate teh MicroStrategy Objects from development to QA and tan to production environment.
• Used several new controls for Dash boards like time series slider, radio buttons, and drop down menus for teh flash version of teh dashboards in 9.4.
• Tested all teh reports by running queries against teh warehouse using Query man. Also compared those queries wif teh MicroStrategy SQL engine generated queries.
• Created Ad-hoc Reports by drilling up, down, wif across hierarchies.
• Developed Auto Prompt Filters dat gave user a choice of different filtering criteria each time they run teh reports.
• Generated Freeform SQL reports writing SQL queries against different databases.
• Provided Business user training for teh 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

Micro Strategy Developer / Administrator

Responsibilities:

• Worked on Restructuring, Re-architecting and Deploying MicroStrategy projects to align wif EDW 2.0.
• Involved in business requirements gathering for Supply Chain, Store Ops, Customer/Marketing, Finance/Sales Audit, Loss Prevention, Human Resources, and Logistics departments.
• Used teh related subject areas in Teradata Retail Logical Data Model and developed physical data model.
• Upgraded teh MicroStrategy environment from v9.2.1 to v9.3.1 and upgraded teh projects metadata. Moved teh MicroStrategy Metadata to robust system.
• Created a new Enterprise MicroStrategy project dat consists of teh modeled subject areas.
• Developed useful existing reports and created dashboards wif Key Performance Indicators
• Created Customer behavior dynamic Dashboards and Spending Pattern Scorecards involving graphs and statistical calculations
• Migrated teh MicroStrategy objects from Development to Test system for user testing and to Production system
• Configured teh Enterprise Manager to analyze teh user traffic and teh projects/reports dat are being used.
• Worked wif users to determine which projects are required moving forward
• Interacted wif 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 wif 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 teh MicroStrategy objects necessary for teh 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 wif VLDB properties.
• Created teh Data mart reports based on specific requirements and running teh 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 teh interactive & flash mode.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Created ad-hoc reports by drilling up, down, wifin 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 teh narrowcast environment and created services using subscription sets, schedules, Information objects.
• Create a test plan, perform unit test and send teh test plan along wif teh 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 teh 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 teh relationship between teh attributes, facts and other objects wifin MicroStrategy.
• Defined Hierarchies and drill functionality wifin 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 wif different teams to deploy teh 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 wif Narrowcast reports and other similar issues wif 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 wif teh Business Analysts to understand teh report requirements
• Prepared teh Design Documents as per teh report requirements
• Creating required Attributes, Facts, Metrics, Custom Groups, Hierarchies and templates
• Created teh application objects: filters, metrics, and prompts
• Developed teh Reports as per teh Design Documents
• Extensively used teh report data options to create teh report as per teh requirements
• Manually Running teh Failed services and Monitoring teh Jobs and Tracing teh Log Files.
• Notifying teh MicroStrategy Users for all teh Updations, Release Schedules and System Maintenance period.
• Performed teh report data manipulations using various options like: data pivoting, page by, sorting, totals, thresholds, etc.,
• Validating teh reports as per teh user requirements (Unit Testing)
• Provided teh 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 teh BI solution development methodology based on industry best practices.
• Worked wif PeopleSoft MicroStrategy dashboarding and BI solution including Metadata, Data Sources and reports.
• Developed technology specifications and ensured dat 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 dat 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 teh performance of teh platform.
• Developed standard OLAP features such as intelligent cubes (me 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 teh 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.