PROFESSIONAL PROFILE :

• Over 7+ years of strong experience in MicroStrategy 9.x/8.x/7.x, MicroStrategy Desktop, Microstrategy Report Services, MicroStrategy Web, MicroStrategy Intelligence server,
• Familiar with Intelligence Server and Narrowcast Server installation and configuration process
• Knowledgeable in business functionality for developing multidimensional modeling (Data Modeling).
• Delivered reports in Desktop and Web and via Narrowcast Server to multiple users
• Experience in Schema design and creating Schema objects using Star and Snowflake (Hierarchies, Attributes and Facts, Transformations).
• Excellent experience in Microstrategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.
• Extensive experience on all types of Microstrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Proficient in SQL Command, Joins, Metadata, creating Simple Metrics, Compound Metrics, applying Transformation, using Prompts, Filters
• Good understanding of RDBMS – Teradata, Oracle, and SQL server
• Experience in using Project Merge, Object Manager, and Enterprise Manager.
• Extensive Microstrategy development hands on experience with Desktop, Architect, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider, Data Mart and Web components
• Excellent experience configuring VLDB properties to fine-tune reports.
• Exceptional ability to quickly master new concepts and capable of working in group as well as independently with excellent communication skills.
• Experience working in a structured, multi-person development environment.
• Experience training non-technical users and providing customer support.

Technical Skills:

Business Intelligence Tools:

MicroStrategy Desktop 7x/8x/9.0 (Microstrategy Desktop, Microstrategy Web and Web Universal, Microstrategy Intelligence Server, Report Services Documents, Dynamic Dashboards, Microstrategy Narrowcast Server, Enterprise Manager)

Databases:

Oracle 8i/9i/10g, TeraData, Sql Server, Ms-Access

Languages:

SQL, PL/SQL, HTML, XML

Platforms and Web Servers:

Windows NT/95/98/2000/2003, MS-DOS, Internet Information Server (IIS) 5.x.

PROFESSIONAL EXPERIENCE:

Confidential, Sept 2012 – Present

Micro Strategy Developer

SeaPass develops and markets Straight-Through Processing solutions, which enable Insurance Carriers and Agents to transmit and receive data in real-time by leveraging existing systems to interact automatically. The real-time STP solutions of SeaPass lead to reduced costs, more business opportunities, better client service, shorter sales’ cycles and successful transactions across all lines of business.

Responsibilities:

• Met regularly with Business Team to discuss requirements and designs of reports and documents
• Collected data and analyzed them based on report requirements before designing Schema and defining Schema objects such as Facts and Attributes
• Designed and developed Complex Reports and Dashboards using MicroStrategy Desktop and Web
• Implemented Application/Public objects like metrics, prompts, filters, reports, and documents
• Created Schema Objects such as attributes, facts, hierarchies and defined relationships between attributes. Designed Simple Metrics and Compound Metrics to use in reports
• Built regular reports in grids, graphs, dashboards as well as in Flash and DHTML view
• Designed Adhoc Reports, used prompts and trained/ assisted end-users to navigate reports
• Analyzed reports and provided information and intelligence to make critical business decisions
• Extensively used Prompts, Filters, and Drill features in reports to provide more feasibility to end-users
• Designed Customized Templates to facilitate the end users to create customized reports by choosing Filters, Metrics and Report Attributes
• Used System Hierarchy, User Hierarchy, and Drill Maps as per clients requirements
• Created Base formulas, Deals, and Allowances to use with the Metrics.Involved in Functional Testing and Tuning of MicroStrategy Reports
• Used Report Cache sharing and Data mart reports to enhance report response time
• Involved in Query optimizations using VLDB properties
• Worked collaboratively with ETL team and Data Warehouse team
• Provide training to BI TEAM to create Report , Document, filter, prompt and Derive metrics on web for their requirement by using attributes and metrics.
• Troubleshoot and Debuging Reports and Documents for web users.

Environment: Micro Strategy 9.2.1 (Architect, Intelligence server, Web, Web Universal, Desktop), Report Services, SQL 2008.

Confidential,NJ Feb 2011 – August 2012

Senior Micro Strategy Developer

Vonage is a leading voice communication company with assets to the tune of 156 billion approx. MicroStrategy software is the heart of Business intelligence at Vonage used to track financial, sales and customer activity in order to make decisions that improve business performance and strengthen customer relationships. As a MicroStrategy Developer, I was heavily involved in supporting the analysis of the organization, customer activity, and leveraged finance activities.

Responsibilities:

• Gather requirements by interacting with senior managers and users for design of reports.
• Participate in BI team meetings to discuss the user requirements.
• Create logical data models, recognize source tables and columns, and build Schema objects, Application objects necessary for creation of a MicroStrategy project.
• Create Complex grid reports with OLAP and drill capabilities.
• Architected schema objects such as Attributes, Facts and Transformations.
• Generate grid and graph reports by using appropriate Facts, Attributes,, Level Metrics, Advance filter.
• Created reports with various object prompts to generate various Ad hoc reports.
• Design Interactive Dashboards in MicroStrategy Web to assess company’s performance and monitor the overall goals of the business.
• Implemented different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements.
• Create standardized reports (Canned reports) and Report Services documents for users.
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the inner join, outer join, nulls and zeroes
• Performed creating Derived metrics, compound metrics using apply simple. Apply complex, smart metrics, enabling dynamic aggregation.
• Used Transformations (table based, formula based) for comparative reports for Investment Operations.
• Production support, trouble-shooting and fixing of reports was done in record time.

Environment: MicroStrategy 9.1 (Architect, Intelligence server, SDK, Web, Web Universal, Narrowcast server, Desktop), Report Services, Oracle 10G , PL/ SQL , Toad for Oracle version 8.6.1, Informatica Power center 8.1.1, SQL Server 2005, ERWIN, Microsoft Visual SourceSafe 6.0 and Windows Server 2003

Confidential,OH Dec 2009 – Jan 2011

Sr Microstrategy Report Developer

Nationwide Insurance is one of the largest insurance and financial services companies in the world providing a full range of personalized insurance and financial services, including auto insurance, motorcycle, boat, homeowners, life insurance, farm, commercial insurance, administrative services, annuities, mortgages, mutual funds, pensions, long-term savings plans and health and productivity services.

Responsibilities:

• Extensively involved in interacting with the users and gathering the requirements, and analyzed the needs of the end users.
• Involved in implementing the star and snowflake schemas to fit reporting, querying and business requirements analysis.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up tables, Indexes and views.
• Designed Interactive Dashboards in MicroStrategy Web to assess company’s performance and monitored the overall goals of the business.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using MicroStrategy Desktop and MicroStrategy web.
• Created Facts, Attributes and Hierarchies using the MicroStrategy Architect.
• Developed various Metrics, filters, consolidations, custom groups and prompts to give decision makers a handy tool to choose the criteria for reports and view information from different perspectives.
• Involved in customization of MicroStrategy Web.
• Involved in designing Templates to generate Reports in grid and graph mode and used filters with prompts to give the end-user a choice of different filtering criteria each time they run the report along with different custom groups.
• Involved in creating various transformations to analyze different metric values in this year to last year using MicroStrategy Architect.
• Involved in performing various analysis using the MicroStrategy Desktop.
• Created complex n-level nested prompts, filters and reports to enable business analysis
• Optimized the performance of the Microstrategy platform by implementing suitable report design processes, SQL tuning, VLDB settings
• Designed Freeform SQL reports for meeting specific needs.
• Production support, trouble-shooting and fixing of reports was done in record time

Environment: Micro Strategy 9.x/8.5 (Architect, Intelligence server, Web, Web Universal, Narrowcast server, Desktop), Report Services, , and Windows Server 2003, PL SQL

Confidential,NJ Sep 2008 – Nov 2009

MicroStrategy Developer

Citibank, a major international bank, is the consumer bankingarm of financial services giant Citigroup. Citigroup is the third largest bank holding company in the United States by domestic deposits. In addition to the standard banking transactions, Citibank offers insurance,credit card and investment products. I worked on developing projects from the scratch to end which includes requirements, data modeling, reports, documents and maintained the project.

Responsibilities:

• Involved in collecting and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Generated reports for the cooperation for Assets period to period.
• Delivered documents for Financial Analysis, Statements and Summary, Customer lifetime value and Customer loyalty.
• Generated Key Performance Indicators (KPI) metrics and other metrics.
• Createdlogical data models to recognize source tables and columns, to buildMicroStrategy Schema objects including Attributes, Facts, Hierarchies and Relationshipsnecessary to createMicroStrategyproject.
• Team member for the upgrade from 8.0.1 to 9.0
• Developed Flash Dashboards & Scorecards in MicroStrategy 9 using Widgets and Selectors for summary level reporting
• Created joins and relationship according to the data model Schema.
• Identify and modified source tables and columns in the warehouse required creating the MicroStrategy project. Studied and modified the attributes, facts and hierarchies based on the requirement. Used MicroStrategy Desktop for creating various application objects.
• Tested report layouts, validated the SQL query, prompt ordering prompt defaults, security filters, export/print functionality and drilling options like simple and advanced.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations for complex reports.
• Used Transformations for comparative reports like claims this year to last year (year to date and month to date).
• Proactively created report formats and delivered personalized messages from the BI platform through MicroStrategy Narrowcast Server to a wide range of users.
• Involved in various back end ETL development tasks and Production Support.

Environment: MicroStrategy 8.0.1/, MicroStrategy Desktop 8.x/9, SDK, MicroStrategy Web 8.x/9, MicroStrategy Intelligence Server 8.x/9, MicroStrategy Narrowcast Server , IIS, SSL, ERWIN 4.0, TOAD 7.0, Microsoft Visual SourceSafe 6, Informatica Power Center 5.1, Teradata V2R5, Oracle 11i, Windows XP.

Confidential,IL Feb 2007 – Aug 2008

MicroStrategy Report Developer

McDonald\'s is the leading global foodservice retailer with more than 33,500 local restaurants serving nearly 68 million people in 119 countries each day. McDonald\'s uses a joint data warehouse and intranet application system based on MicroStrategy’s DSS server, a relational On-Line Analytical Processing (OLAP) server optimized for very large database (VLDB) analysis. The company uses MicroStrategy Business Intelligence Platform for enterprise reporting and analyzing human resource and category management reporting as well as financial reporting

Responsibilities:

• Worked on requirements gathering from the clients and estimation of efforts including analysis of existing system and analysis of data.
• Designed and developed the environment to generate reports. Extensively worked on Logical Data Modeling, Installing and setting up of Microstrategy Intelligence server and Web servers. Involved inClustering of servers. Developed DTS packages to populate SQL Server warehouse and Oracle databases..
• Created Metrics, Prompts, Filters, Custom Groups and Transformations for the report development.
• Created Complex metrics, Nested Filters, Nested Prompts Custom Drill Maps, Templates for Graphs and Templates for Drilled reports
• Created ad-hoc reports in Grid & Graph mode consisting of data analysis by combining a template with filters using MicroStrategy desktop and web.
• Used apply functions like apply simple to meet the report requirements wherever necessary.
• Extensively used report services to create dashboards to create summary level reports using multiple datasets.
• Used analytical and governing settings in VLDB properties to tune the SQL and metrics involving nulls and zeroes.
• Extensively worked on Dashboards and have utilized the new features to convert the dashboards into Flash mode.
• Used several new controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Used several widgets for Dashboard like Funnel, Gauge, Heat maps for reporting.
• Worked extensively with the compliance officer to finalize the dashboard layouts and also worked on fine detail formatting for a desired look and feel.
• Created logical views in Microstrategy for complex report creations situations.
• Created advanced grid reports, consisting of data analysis by combining a template with filters. The end-users were able to generate ad-hoc report by drilling up, down, within and across dimension or anywhere.
• Provided access to the Data Warehouse to a much larger audience by using Narrowcast Server. The reports and Information have been personalized as per the user requirements
• Performing all the administration tasks like Monitoring and Analyzing the system usage and managing the projects. And using the Command Manager to purge the caches on database loads.
• Used free form SQL editor for complex report creation to get the data from the Data warehouse
• Fixed Defects and performed upgrades for existing projects.