SUMMARY

• 7 years of IT experience in various fields like Data Warehousing, Data analysis and Database applications, which include Microstrategy Platform.
• Experience in Microstrategy tool Suite (Microstrategy Intelligence Server, Microstrategy Architect, Microstrategy Desktop, Microstrategy Web)
• Experience working wif teh full project life cycle development process, involving analysis, design, development, implementation, and testing phases.
• Good experience in upgrading MicroStrategy project from one version to another version and making use of improved performance and new features. Involved in upgrading MicroStrategy version 8.1.2 to version 9.0, version 8.0.3 to version 8.1.
• Experienced using Microstrategy Integrity manager to compare reports/documents when project is moved between different environments; MicroStrategy Object manager to move objects and MicroStrategy project manager to move projects from development to testing and tan to production environment.
• Extensive experience in developing Public Objects (Filters, Prompts, Metrics, Custom Groups, Consolidation and Templates) to develop reports and knowledge of Schema Objects (Facts, Attributes, Hierarchies, and Transformations).
• Good Experience in RDBMS like Oracle, SQL Server and DBMS like MS Access.
• Extensive experience creating Reports, Documents, Dashboards and Scorecards according to client/business user requirements.
• Experienced wif teh concepts of Data Warehousing, Data Marts, Logical and Physical data modeling, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Optimized report generation wif respect to Very Large Databases (VLDB) to make absolute use of Database Flexibility, Caching, Security and Scalability Issues suited for Oracle, Teradata, DB2 and SQL Server and involved in troubleshooting MicroStrategy reports.
• Experience in full software development life cycle (SDLC) analysis, Design, Development, Documentation, Testing, Implementation and Maintenance in data warehousing environment.
• Self - initiative, excellent analytical and Communication skills and ability to work independently and as good team player.
• Ability to work in multiple projects simultaneously and independently as well as in a team environment.

TECHNICAL SKILLS

BI Tools: Microstrategy 9.4.1/9.3.1/9.3.0/9.2/9.0/8.1.2/8.1/8.0.3 (Microstrategy Desktop, Microstrategy Intelligence Server, Microstrategy Web, Microstrategy Narrowcast Server, Microstrategy OLAP Services, Microstrategy Architect)

Database Tools: Toad, SQL *Plus

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2010/2008/2005 , MS Access, MySQL

Languages: C, C++, SQL, PL/SQL

Operating Systems: Windows 8/7/Vista/XP/NT/2000

Packages: MS Office Suite (2010/2007/2003 )

PROFESSIONAL EXPERIENCE

Confidential, Buena Park, CA

Microstrategy Developer

Responsibilities:

• Developed different reports according to teh requirements.
• Worked extensively on developing Metrics and Compound Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.4.1.
• Used several new controls for Dashboards like time series slider, radio buttons, and drop down menus for teh flash version of teh dashboards in 9.3.1.
• Tested all teh reports by running queries against teh warehouse using SQL. Also compared those queries wif teh MicroStrategy SQL engine generated queries.
• Modified VLDB Settings to tune teh reports for faster execution.
• 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.
• Involved in troubleshooting of reports and eliminating cross joins in teh SQL to produce correct results.

Environment: MicroStrategy 9.3.1/9.4.1 (MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy Enterprise Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 11g, SQL * Plus, Windows.

Confidential, Houston, TX

Microstrategy Developer

Responsibilities:

• Created advanced qualification Filters, Custom groups, Prompts, Hierarchies, compound metrics, filters, object prompts, custom expression filters according to teh business needs.
• Used Advanced Prompts, Conditional, Transformation metrics and Level Metrics for creating complex reports.
• Implemented drill functionality on teh reports using Drill Maps.
• Created dynamic dashboards to improve marketing by product, customer, geographic and promotion analysis.
• Developed Reports enabling Data Drilling across multiple Dimensions using MicroStrategy Desktop.
• Worked extensively on developing Metrics and Compound Metrics, Complex Metrics, Filters, Custom Groups, Templates, Consolidations and OLAP Reports using MicroStrategy 9.2.1.
• 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.
• Developed reports and dynamic dashboards for daily, weekly and periodic sales analysis.
• Created Transformations like YTD (year to date), MTD (month to date), and WTD (week to date) analysis.
• Involved in teh creation of Data mart Reports, Partition Mappings.

Environment: MicroStrategy 9.2.1 (MicroStrategy Administrator, MicroStrategy Web, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Object Manager, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 10g, Windows XP

Confidential, Brookings, SD

Microstrategy Developer

Responsibilities:

• Implemented advanced MicroStrategy Reports concepts by creating metrics, filters, Custom groups and templates using MicroStrategy Desktop.
• Extensively used report services for creating Enterprise Dashboards summary level documents wif grids & graph combinations.
• Created Complex reports for Analysis wif Transformations, Custom Groups and Complex Filters.
• Developed different prompts to give business users a choice to filter teh data each time they run teh reports.
• Extensively used Integrity Manager to test reports
• Involved in troubleshooting MicroStrategy Web Reports, and optimizing teh SQL using teh VLDB properties
• Create Attributes, Facts for different MicroStrategy projects
• Identified teh Facts, Attributes dat goes in teh Dashboard and documented teh Technical specification.
• Insert as many panels as needed wifin a panel stack.
• Analyzed, Documented, and transformed user requirements to teh technical team.
• Created advanced Attributes, Filters and Metrics using Microstrategy Desktop.

Environment: MicroStrategy 9.0(MicroStrategy Administrator, MicroStrategy Architect, MicroStrategy Desktop, MicroStrategy Narrowcast Server, MicroStrategy Web, MicroStrategy OLAP Services, MicroStrategy Project Manager, MicroStrategy Intelligence Server), Oracle 10g, Windows XP.

Confidential, Draper, UT

MicroStrategy Developer

Responsibilities:

• Involved in gathering of business requirements from end clients and translating them into report specifications for teh MicroStrategy platforms.
• Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on teh user requirements.
• Involved in architecting Fact columns and development of Hierarchies wif related Attributes required for reporting.
• Created Transformations for comparison of sales metrics by year to date, Month to date, Quarter to date, Previous Year etc.
• Generated and implemented MicroStrategy reports by creating projects, attributes, hierarchies, metrics, filters, and templates using MicroStrategy Desktop and MicroStrategy Web.
• Worked extensively in developing Metrics, Compound Metrics, Consolidations, Custom Groups and Filters for complex reports.
• Created Dynamic dashboards to improve marketing by product, customer, geographic and promotion analysis
• Created complex metrics forcing dimensionally and conditionally.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Automated and improved existing manual processes. Optimized teh server platforms using caching, scheduling, and clustering.
• Provided access to MicroStrategy platform from a Microsoft Excel (Non- MicroStrategy Interface) by using MicroStrategy Office.
• Used Report Cache Sharing and Data Mart reports to enhance teh report response time.
• Coordinated wif business, data modeling and ETL team at various levels for stabilization of reports.
• Involved in Implementation of Security layer for MicroStrategy.

Environment: MicroStrategy 8.1, Oracle 9i.

Confidential, Brick, NJ

SQL Developer

Responsibilities:

• Worked wif Implementation team and closely moved wif end users to implement manufacturing solutions.
• Worked closely wif developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for teh system.
• Responsible for creating teh Database tables, indexes, constraints in Oracle 8i.
• Invoices are ported from teh Excel sheets to teh Oracle Database using SQL * LOADER.
• Involved in creation of PL/SQL stored procedures, Packages, Procedures, Functions, Cursors, Triggers.
• Involved in creation of SQL scripts.
• Wrote Explicit Cursors and Handling Exceptions
• Created Views and Other Database Objects
• Interacted wif teh Business users and identified teh requirements
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for teh Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied teh existing environments and accumulated teh requirements by interaction wif various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of teh system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted teh Application team in data modeling and T- SQL coding.

Environment: SQL Server 2008, Windows, T- SQL, EXCEL, Access.