SUMMARY:

• Around 6+ years of IT experience in various fields like Data Warehousing, Business Intelligence, Database applications and Client server programming.
• Strong experience in MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, Web, Narrowcast Server, Distribution Services, Mobile).
• Extensively worked in creating and integrating MicroStrategy Reports and Objects (Attributes, Filters, Metrics, Facts, Prompts and Hierarchies) with the Data Warehouse.
• Expertise in creating complex reports in MicroStrategy Desktop using features like Templates, Filters, Prompts, Consolidations and Custom Groups.
• Developed various Micro Strategy Narrowcast Server Objects like Service, Schedule, Publication, Information objects, Information Source and Subscription etc.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server.
• Knowledge in Tableau.
• Participated in various migration works to tableau.
• Got trained and gained extensive knowledge in reporting tableau
• Create highly interactive MicroStrategy dashboards by using Visual Insights that replaced legacy reports
• Produce Ad - Hoc queries and reports as needed along with providing on-going analytical support for these requests with metrics, attributes, relationship filters, and prompts to support reporting
• Perform detailed data analysis, validation, and identify data quality issues to ensure consistency across all environments.
• Used SDK for customization of various dashboards by using Java.
• Implemented Mobile versions of Dashboards for iPad and iPhone.
• Created Transaction Services Microstrategy Dashboards.
• Delivered visualizations and Widgets including Bubble Grids, ESRI Maps, Heat maps, Time Series, Waterfall graphs, Micro charts in Microstrategy Dashbnoards.
• Provided Calendar, Geography, Demographics, and Economics enhancements to client data models.
• Developed basic and user-specified Metrics (level and conditional) in the object model of Microstrategy.
• Created drill maps for end users to drill down and recover data.
• Designing and executing Application objects and Schema objects using MicroStrategy Desktop.
• Water fall and Agile software development life cycle process to data development projects
• Expertise in creating Microstrategy custom Dash Boards and Scorecards using Flash and DHTML.
• Experience in configuring the Microstrategy Intelligence Server and pointing the database instances in both development & Production environments.
• Experience in designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Physical and logical data modeling.
• Expertise in using MicroStrategy Report Services to generate electronic snapshots of business data and present them in a visually appealing and intuitive format.
• Experience in setting up VLDB properties at different levels to customize SQL generation by MicroStrategy.
• Collaboration with team members and also being actively involved in learning opportunities for better solutions.
• Good experience in RDBMS - Netezza, DB2Teradata, Oracle, SQL server and
• Build E-R Relationships using E-R Charts and Data Modeling Tools.
• Worked on upgrading the MicroStrategy project created in MicroStrategy version 8.x to version 9.4.1 and also 10.1 version.
• Involved in process of data movement from DB2
• Worked extensively on Visual Insights, which help in analyzing the data quickly.
• Very well versed with Data Warehousing concepts.
• Performance monitoring and tuning experience for all MicroStrategy reports and dashboards.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.
• Applied Teradata Application Utilities and Teradata SQL . Also Fine tuned SQL using Teradata.
• Strong experience in understanding Business Applications, Business Dataflow and Data relations. Exception ability to quickly master new concepts and capable of working in-group as well as independently.
• Extensive knowledge of SQL,PL/SQL and worked on very large databases in Teradata V2R5/V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2005/2008

TECHNICAL SKILLS:

BI Tools: MicroStrategy Desktop10.4, 9.x/ MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligence Server, Administrator, Report Services, Command Manager, Object manager Enterprise ManagerRDBMS: Oracle 9i/10g, MS Access, MS SQL Server, MySQL.

Languages: SQL, PL/SQL, Netezza.

OLAP Tools: MS SQL Analysis Services, DB2 OLAP Crystal Reports

Operating Systems: Windows, UNIX, Linux

Other Tools & S/W: Microsoft Office, GIS

Interpersonal Skills: Great knowledge and Experience in Communication Skills, Prepared and conducted many seminars. Committed to development of self and team

PROFESSIONAL EXPERIENCE:

Confidential, NH

MicroStrategy Developer/Admin

Responsibilities:

• Mapped all the columns of table using Architect according to the user requirement.
• Analysed and documented the need of all data needed for the transition of Liberty Mutual to Linclon Financial.
• Involved in various business and technical discussions to dicuss the direction.
• Worked closely with ETL people to make sure the data is in the right type needed for reporting.
• Created cubes to make sure the performance is up right.
• Scheduled the cube and monitored it daily and weekly.
• Added metrics to the cube often according to the business requirments.
• Created reports filters,hierarchies, custom groups and consolidations.
• Also created advanced objects like derived metrics, compound metrics.
• Worked on creating various metrics for measuring satisfactory and unsatisfactory measures.
• Builded documents from scratch to export them as PDF and Excel formats.
• Created BarGraphs, Pie, Ring Chart for data visualization, so that business can make quick decisions.
• Created complex document with 8 graphs including 5 ring charts and 2 bar graphs and a pie.
• Worked extensively on Visual Insight Dashboards, by co-ordinating with stake holders.
• Created Data Sources names for various connections.
• Worked as an Admin for creating schdules and scheduling cubes.
• Administered MicroStrategy environments and formulated user groups.
• Monitored Cache and user groups and security privilages.
• Performed various testing using Microstrategy Tools to make sure all the business is delivered right.
• Worked on various levels of tickets to make Mstr system stable.

Environment: MicroStrategy 10.4 (Developer,MstrWeb,Object Manager,Architect,Enterprise Manager), Informatica, Hive, SQL, Netezza, AWS, Windows

Confidential, Atlanta, GA

MicroStrategy Developer/Admin

Responsibilities:

• Involved in design/development life cycle including gathering requirements, user interaction and report design and development.
• Co Ordinated with internal & External Stake Holders.
• Developed Metrics, Filters, prompts to achieve the functionality of the canned reports
• Created advanced objects like Derived Metrics, Compound Metrics.
• Extensively worked on building Schema in Microstrategy
• Designed and developed OLAP cubes and dimensional models.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Experience in using Java program in Command manager to automate the process.
• Validated end user requirements using MicroStrategy tools.
• Experience in Managing & Coordinating both Offshore and Onshore teams.
• Performed various SDK customizations to ensure clients user friendly operations by using various scripts in Java.
• Created OLAP cubes using SSAS and starch schema techniques.
• Worked closely with all aspects of the Business Intelligence group in order to deliver the required solutions in a timely manner.
• Creation of Microstrategy Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Create, maintain and modify Attributes, Metrics, Filters, Facts, and Hierarchies.
• Use the Warehouse Catalog to move and update tables in Microstrategy.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Converted existing interactive reports with prompts to non-prompted reports for Narrow casting.
• Create Parent/Child relationships and set up dynamic attributes.
• Set dimensionality, conditions, filtering and grouping on metrics.
• Monitoring the cubes load based on daily, weekly.
• Hands on experience in deployments using Object Manager.
• Worked with the DBA on issues of database performance and security.
• Worked with ETL experts in discussing and analyzing data load issues.
• Analyzed and created documents for easy usage of User Manager.
• Worked on administrative tasks like User Groups, Roles, Privileges, Cache Management.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser. Proactively created report formats and delivered personalized messages from the Data warehouse.
• Actively participated in creation of Dashboards for Revenue recognition, Claims processing and employee Performance.
• Created Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.
• Involved in various forms of testing before deployment.
• Performed smoke testing and QA testing.
• Involved extensively in the overall lifecycle of the Data Warehouse integration project.
• Generated different kinds of Pass-Through Functions and used for time filters like current month and previous year etc.
• Created different Project Sources for different environments like production, testing and development.
• Participated in Microstrategy Upgrade 10.1 from version 9.4.1
• Well versed in installation, configuration and Project creation and tuning of MicroStrategy Business Intelligence.
• Extensively worked on delivering reports and business intelligence solutions on the web using MicroStrategy Narrowcast Server& Distribution servers.
• Generated reports using Advanced Metric objects, Filters, Prompts and also created Customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes.
• Administered MicroStrategy environments and formulated user groups.
• Handled user licenses for projects and Managed backup of Metadata.
• Extensively worked on Desktop to create Applications Objects, Reports and Dashboards (Documents & Scorecards).
• Extensively worked on MicroStrategy Defects to make system stable

Environment: MicroStrategy 10.1 (Developer, Object Manager, Enterprise Manager), Informatica, Oracle 10g, SQL, Netezza, HTML, Windows

Confidential,Columbus, Indiana

MicroStrategy Developer/Admin

Responsibilities:

• Responsible for understanding the business requirements from the users and analyzing the report specification documents.
• Worked on converting Teradata reports in SQL to MicroStrategy reports and documents.
• Analyzed logical data models, understand data warehouse tables and columns, map the columns to the MicroStrategy project by creating public objects.
• Identified the Source tables and columns required to create the MicroStrategy Project, thereby achieving a logical mapping of the physical data warehouse in the MicroStrategy Metadata Repository.
• Expertise in reporting through visualization.
• Designed MicroStrategy Schema objects and Application objects using MicroStrategy Desktop and maintained data dictionary for the project.
• Worked extensively in creating complex reports using simple metrics, compound metrics, relationship filters.
• Analysing data models and recommending.
• Worked with an agile framework involving rapid prototyping and quick, iterative dashboard development and enhancement.
• Created highly interactive MicroStrategy dashboards by using Visual Insights that replaced legacy reports.
• Validated Hadoop migration using and transformation process with Hive.
• Creating step by step solutions for movement and transformation of data using Hive and Scala.
• Worked on creation of views for the creation of MicroStrategy objects.
• Created Dashboards through report services document through MicroStrategy Desktop.
• Worked in Market Basket analysis with Relationship filters.
• Created design and technical specification documents for realizing MicroStrategy objects to be integrated in the report.
• Demonstrated the Dashboard reports and documents to the users.

Environment: MicroStrategy 9.4.1 (Desktop, Object Manager, Enterprise Manager), QlikView, Informatica, Oracle 10g, SQL, Teradata, HTML, Windows.

Confidential, Boston, MA

MicroStrategy Developer/Admin

Responsibilities:

• Involved in gathering of business requirements.
• Architected schema objects such as attributes, facts and transformations.
• Created a DB instance for MicroStrategy and added all the tables, table prefixes and updated the table structure required for the Project.
• Created various MicroStrategy objects such as Metrics (simple and compound), Filters, Prompts, Custom Groups, Consolidations, etc.
• Worked with MicroStrategy Object Manager to move objects among the Development, Testing and Production environments.
• Involved in testing of the entire project when Teradata is upgraded from V2.5 to V2.6.
• Involved in upgrade process of MicroStrategy 8.1.2 to 9.0.
• Writing BAT file to call Command manager to execute Service.
• Created custom attribute functionalities using OLAP services.
• Set Up MicroStrategy and Windows Performance Counters and Log them to Text or CSV for Performance Tracking.
• Worked on creating the Visual Insights including the various widgets and demonstrated to the business users.
• Perform Daily Checks for job Monitor, user sessions and Cache Monitor to keep the system stable.
• Micro strategy Intelligent Server Tuning for performance.
• Creation of Intelligent Cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Created additional visualizations to display the data in multiple ways.
• Modified, rearranged or resized visualizations in a quick dashboard.
• Involved in creating services and objects in Narrowcast server.
• Used Narrowcast Sever for timely delivery of report for authorized users.
• Created various event based Schedules.
• Actively participated in developing Report Delivery Schedules.
• Created reports with various object prompts to generate various Ad hoc reports.
• Worked with Erwin in designing the schema for database views.
• Actively participated in creation of Dashboards for Revenue recognition, Claims processing and employee Performance.
• Created Dynamic Dashboard documents for Field marketing people with multiple panel stacks, selectors and customized widgets.

Environment: MicroStrategy 8.1 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) MicroStrategy Narrowcast server, ETL, OLAP, Windows Server 2003, MicroStrategy Dashboard, Teradata.

Confidential -New York, NY

MicroStrategy Consultant

Responsibilities:

• Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
• Created and maintained Business Documents for reporting and Coordinated with business users and report development team for all reporting changes.
• Designed and developed different types of reports as per the requirements.
• Developed Transformations (table based, formula based) to be used for comparative analysis like loans this year to last year (year to date and month to date).
• Deployed MicroStrategy Desktop in designing the MicroStrategy projects. The business rules of the data warehouse were implemented into MicroStrategy Architecture.
• Worked with Pass-through functions, like Apply Simple in defining the attributes, facts and metrics.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser. Proactively created report formats and delivered personalized messages from the Data warehouse.
• Developed scorecards and dashboards that provide users a highly graphical, summary view of key metrics.
• Developed thorough understanding of the project’s technical details (e.g. call flow, billing, provisioning, operations, etc.); uncovered and assessed project’s risk and dependencies.
• Worked extensively with Intelligent Cubes in developing the dashboards to increase the performance.
• Created attributes, Consolidations and derived metrics on the reports from Intelligent Cubes.
• Designed Dashboards using selectors & widgets and summarized key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Created report services documents to personalize the reports as per user requirements, which included combination of several sets of individual grid reports, customizing and formatting.
• Created users and user groups, and granted them access to different projects based on the security.
• Created Dynamic Subscriptions for users to be able to receive reports via email.
• Prepared data migration plans including migration risk, milestones, quality and business sign-off details.
• Worked with end users in solving the current financial Issues.
• Extensively worked with end-users to resolve the issues faced during day-to-day activities.
• Integration with the User Interface application built for Chase client.

Environment: MicroStrategy Desktop 8.1.1, MicroStrategy Intelligence Server, MicroStrategy Web, Narrowcast Administrator, Oracle 10g, Oracle Data Integrator, MS SQL Server

Confidential

MicroStrategy Consultant

Responsibilities:

• Involved in the complete Life cycle of the Project and in the data analysis process.
• Participated in the end user meetings to obtain the business requirements for creating reports.
• Involved in Data-Modeling Analysis like Creation of Snowflake schema, report structure based on the user requirements.
• Installing, Configuring of all MicroStrategy products including MicroStrategy Desktop, Administrator, Intelligence Server, Web Server.
• Used Advanced Filters, Conditional, Transformation and Level Metrics for creating complex reports.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Designed an efficient BI Dashboard for the Company Executives, through efficient use of MicroStrategy Report Services.
• Converted the previously created web flash dashboards to IPad dashboards with swipe and tap functionality using MicroStrategy Mobile Server.
• Developed MicroStrategy Schema objects and Application objects such as Facts, Attributes, Transformations and Hierarchies.
• Created all possible Metrics, for enabling the end users to generate customized reports by creating their own Templates and Filters, Administrated MicroStrategy Intelligence Server and Web Server.
• Responsible for the end Users training for the MicroStrategy Web interface.
• Involved in Implementation of Security layer for MicroStrategy.
• Involved in creating users in MicroStrategy Desktop for testing the reports on the Web interface.

Environment: MicroStrategy 8.1.2 Product Suite (Architect, Desktop, Web, Object Manager) Oracle 10g

Confidential

SQL Developer

Responsibilities:

• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
• Created stored procedures and triggers, which were used to implement business rules.
• Helped in integration of the front end with the SQL Server backend.
• Written triggers, stored procedures and manipulated the data using DDL and DML functions.
• Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)
• According to the business requirements made the documentation of the performed tasks.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users

Environment: MicroStrategy 7.1.0/8.0 (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Informatics Power center, Oracle, Toad, Windows NT.