SUMMARY

• 7+ years of rigorous IT experience, leveraging expertise in Data Warehousing, Data Modeling, ETL and BI (MicroStrategy) tools.
• Experience in all aspects of Software Development Life Cycle (SDLC).
• Interacted wif teh Business Users to understand teh Business flow and teh operations of teh Source (OLTP) systems.
• Gathered and documented business requirements for existing and future business systems.
• Efficiently provided Business Intelligence Solution using MicroStrategy suite which includes MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy Desktop etc.
• Involved in training Business Users on MicroStrategy OLAP Services (such as view filter and derived metric).
• Hands on experience using MicroStrategy tools like MicroStrategy Architect, and MicroStrategy Administrator, Command Manger, Object Manger etc.
• Created MicroStrategy User Accounts and User Groups wif different Security Roles and assigned various Security Filters.
• Implemented security in various methods like Security filters, Table Based Security, System Prompts.
• Used MicroStrategy tools like Object Manager and Project merge to compare projects and migrate teh objects/projects between two Servers.
• Created and modified MicroStrategy Schema objects (such as Attributes, Facts, hierarchies etc.), Public Objects (such as Reports, Metrics, Filters, Prompts, Templates, Consolidations, Custom groups etc.) and Configuration Objects (such as project, user, security filter etc.) using MicroStrategy desktop.
• Extensively created MicroStrategy Dashboards & Score Cards which includes features of Adobe Flash version like Radio Buttons, Fish Eye, Slider and other selectors.
• Specialized in designing Report Service Documents wif multiple datasets.
• Extensively used MicroStrategy Narrowcast Server for delivering reports (Static & Dynamic Subscription Sets) and Business solutions on web, wireless devices.
• Experience in Data modeling techniques like star and snowflake schemas using Erwin tool
• Good Knowledge on data extraction and transformation (ETL) process and had exposure on tools like Informatica Power Center 7.0
• Exposure in dealing wif variety of Relational Databases like Teradata, Oracle, DB2, SQL server.
• Writing complex SQL queries, cursors, stored procedures, UDF and triggers.
• Excellent domain noledge in Supply Planning and Demand Planning
• Good experience in customer facing roles
• Involved in job scheduling, monitoring and production support in a 24/7 environment
• Excellent communication skills and ability to work in group as well as independently wif minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

OLAP Tools: MicroStrategy 9.0.1/8.1/8.0/7.5/7 i/7.x, Informatica, Business Objects, SQL Server 2005, Integration/Analysis/Reporting Services, Data Integrator

Data Modeling: Erwin, Microsoft Visio

RDBMS: Oracle 10g/9i/8i, SQL Server 2005/2000/7.0, Teradata V2/R4/R5, MySQL

Operating Systems: Windows 2003/2000/98, Linux Red Hat 7.x, 8.x

Languages: SQL, PL/SQL

Web Technologies: .NET, JavaScript, HTML

Microsoft Apps: MS Word, MS Excel, MS Power Point, MS Access

PROFESSIONAL EXPERIENCE

Confidential, CA

MicroStrategy Developer

Responsibilities:

• Worked on three different financial projects starting from creating teh fact tables and dimension tables till teh creation of teh Report service document.
• Administered two MicroStrategy Development systems and one production system. Responsibilities included schema design, creating new users, assigning security model standards, performing object migration/report publication, tuning server settings, tuning SQL, and scheduling weekly maintenance tasks on teh metadata.
• Worked one - on-one wif business users in developing report requirements, specifications and design.
• Up on Special Request from teh users new tables are added to teh existing schema for teh Transformation purpose and created Application objects on top of them for teh MicroStrategy Reports.
• In order to support teh special reports a new reporting table created in schema.
• Designed and Developed Schema tables, Attributes, facts, Hierarchies, metrics, filters, prompts, Custom groups, Consolidations, reports
• Created teh transformation tables and developed schema and public objects on top of them to include in teh reports which can compare current month vs. prior month, current quarter vs. prior quarter & prior Yr quarter, current Year vs. prior year.
• Created Report Service Documents for HR and Finance Projects.
• Used Advanced Prompts, Non- Aggregately Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports
• Involved in creating teh Technical Documentation for Developers and Check lists for teh users for teh MicroStrategy Project.
• Developing customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent wif features of Drilling options.
• Developed reports for teh pricing data warehouse which compared business pricing strategies to local competitors. Reporting included category management, executive summaries and price difference.
• Supporting production environment. Responsibilities include providing 24-hour support for teh MicroStrategy servers, troubleshooting report issues, performing MicroStrategy upgrades.
• Provided technical support for MicroStrategy Web, Architect, and Desktop Designer users, for issues involving connectivity, object moves, and report execution.
• Responsible for Administration tasks include creating users and applying access to projects, creating/ duplicating teh projects and migrating objects from development environment.
• Scheduled teh Narrowcast server in such a way dat teh users will get teh reports in teh first week of every month.
• Created custom dash boarding using widgets like time series sliders.
• Created dash boards which evaluates and compares data for Current and Prior months, quarters, years and made available in Interactive mode, Flash mode and PDF mode.
• Received appreciations from Business users for creating Dashboards looks and feel like their sample reports.
• Included Collapsible columns and Drilling in Dashboard which TEMPhas teh ability to expand, collapse and drill to other reports.

Environment: MicroStrategy 9, 8.1 (Administrator, Architect, Desktop, Web, Narrowcast Server, Object Manager, Enterprise Manager, Office, Report Services), Teradata, Windows NT

Confidential, CA

Micro Strategy Administrator/Developer

Responsibilities:

• Full life cycle of teh project TEMPhas been implemented starting wif teh gathering requirements from users and documenting teh specifications.
• Gathered and documented business requirements for existing and future business systems.
• Worked wif teh source systems to has a comprehensive understanding of teh data flow and interacted wif teh users to collect teh Business requirements
• Captured business requirements for reconciliation reports and designed metrics in MicroStrategy.
• Installed MicroStrategy on Linux environment, defined teh metadata using MicroStrategy Configuration wizard.
• Specified configuration settings for every node in a clustered environment.
• Implemented security at various levels like - Project Source Level, Project Level and Object Level.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect
• Had experience in configuring MicroStrategy logins wif client LDAP accounts and Windows accounts.
• Specified ODBC architecture and requirements for teh MicroStrategy environment. Created ODBC connections to teh metadata and teh data ware house.
• Skilled in assessing, analyzing, designing Supply Chain Business Processes wif a focus on Enterprise Planning, Demand and Forecast Planning, Inventory Control, Procurement and Order Management
• Created and defined teh project level security settings, identified and modified teh user authentication mode options, created users and groups, and created and maintain security roles.
• Used teh Administration monitors in MicroStrategy intelligence server to oversee project operations.
• Identifying teh cache types, configure cache settings and schedule reports to execute automatically.
• Worked extensively on complex reporting needs which involved creating like Consolidations and Custom Groups.
• Used Advanced Prompts, Metrics, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Created Transformations for using tables for YTD, MTD and WTD analysis.
• Used teh Object Manager to move teh objects from Development to Production Environment in MicroStrategy.
• Clearly understanding teh procedures for grouping and sorting records in a MicroStrategy report service documents dat you created as Reports which is WYSIWYG.
• Used features like Hyperlinks, drilling and advanced metric calculations in creating reports wif dynamic Dash boarding.
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds, and Report Optimization.
• Extensively used teh Dash boards to provide Report services
• Supported teh Reports developed and given Production support.
• Extensively used Report services for creating Dash Boards.
• Upgraded MSTR Projects from 8.0.3 to 8.1.0/8.1.1
• Configured and implemented Narrowcaster for report Distribution
• Configured teh Enterprise Manager for statistical reporting purposes

Environment: MicroStrategy 8.1.x, 8.0.2 /7.5(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Teradata, Oracle 10g, SQL Server.

Confidential, Philadelphia PA

MicroStrategy Consultant

Responsibilities:

• Designed and Developed Customized Attributes, Hierarchies, Facts, Metrics, Filters, Prompts, Custom Groups, Consolidations and Reports.
• Extensively used Pass-through (Apply Functions) expressions to pass special functions.
• Used teh Microsoft windows performance monitors to supplement Administration monitors in MicroStrategy intelligence server.
• Understood and created a project in a 4-tier via MicroStrategy web.
• Identified teh purpose of governing and set server and project level governors.
• Created teh default start up mode for MicroStrategy intelligent server, listed and defined teh multiple methods for manually starting and stopping MicroStrategy Intelligent server.
• Designed, Developed and altered html Document objects placing multiple reports on it in Grid as well as Graph View applying XSL and XML formatting for each in teh process of automating IT Dashboard reports.
• Tested all teh reports by running queries against teh warehouse-using TOAD. Also compared those queries wif teh MicroStrategy SQL engine generated queries.
• Reduced teh run time for teh reports by monitoring teh VLDB properties like star join, query and sub query optimizations for oracle 9i and SQL hints.
• Configured MicroStrategy logins wif LDAP accounts.
• Played a key role in User Acceptance Testing of teh reports.
• Created transformations using transformations by tables for YTD (Year to date), MTD (Month to date) and WTD (Week to date) analysis.
• Used MicroStrategy Narrowcast Server to monitor teh business data and alert teh users to unexpected exceptions and trends.
• Designed and used MicroStrategy report services extensively to generate reports.
• Clear understanding of procedures for grouping and sorting records in a MicroStrategy report services documents.
• Used advanced properties of report services like creating hyperlinks, drilling, using datasets, advanced metric calculation and so on.

Environment: MicroStrategy 8.0.2/7.5.2, MicroStrategy Desktop, MicroStrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, Informatica, Oracle 9i, Oracle SQL Developer, Windows XP/2000.

Confidential, Titusville, NJ

Micro Strategy Developer

Responsibilities:

• Developed a 3-tier client/server product in teh corporation for use by teh merchandising department to access a relational Oracle database in a multidimensional way (ROLAP) using MicroStrategy’s DSS tool suite of products in a heterogeneous networked environment.
• Designed teh MicroStrategy Architectural Documents for teh Projects
• Created Reports using complex Filters and Compound Metrics and Prompts.
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent dat can be re-used to build any number of metrics.
• Developing customized and Ad-hoc reports using Templates, Metrics and Filters for Business analysis using MicroStrategy Agent wif features of Drilling options drill up, drill down and drill anywhere.
• Developed SQL queries as needed against development and production databases for quick-action ad hoc reporting and data quality analysis.
• Performed testing of all reports for teh final deployment.
• Used MicroStrategy Narrowcast Server to provide self-subscription capabilities and to deliver personalized content to teh subscribers. Involved in installation and configuration of teh Narrowcast Server and perform various tasks to has teh subscription and other features to work.

Environment: MicroStrategy 8/7.1.2 Product Suite, Oracle 9i, Informatica, Toad, Windows XP.