SUMMARY:

• 7+ years of extensive work experience in the field of Information Technology specialized in business applications and business intelligence by utilizing MicroStrategy as a data analytics tool.
• Extensively worked in developing DW applications using MicroStrategy Desktop, Web, Administrator, Narrowcast Server, and Intelligence Server.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Custom Groups and consolidations) with the data warehouse.
• Designing Data Marts using different multidimensional modeling techniques such as Star Schema and Snowflake Schema, Fact and Dimensional tables, Logical and Physical data modeling.
• Expertise in interacting with the clients and understanding business application, business data flow and data relations from them.
• Created complex reports in MicroStrategy including freeform SQL reports, data mart reports, etc.
• Experience in creation of Dashboards and Scorecards which helps in better understanding of the Business trends.
• Experience in Data Modeling using ERWIN3.x/4.0, DataMart and OLAP for business analysis using star&snowflake schemas, for faster and effective querying.
• Experience with integrating MicroStrategy with heterogeneous data sources and the implementation of dynamic sourcing.
• Handled Slowly Changing dimensions in the Data warehouse depending on the changes in business dimensions.
• Decent database development skills using SQL, PL/SQL, stored procedures, stored functions, packages and triggers.
• Very good experience in working with very large databases on Oracle, SQL Server with Micro strategy Suite. Strong SQL skills in SQL server and Oracle environment.
• Experience in developing and deploying MicroStrategy mobile apps on Apple IOS/iPad, Android, Windows and/or similar other devices.
• Involved in Product Support on Call Support on rotation basis.
• Excellent communication, presentation, interpersonal and great learning skills.

TECHNICAL SKILLS:

Business Intelligence/OLAP: MicroStrategy 10.11/10.4/9.4.1/9. x /8.x / (MicroStrategy Desktop, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Intelligence Server, MicroStrategy Narrowcast Server, SAP Business Objects, IBM Cognos, Microsoft Excel

Database: SQL Server - 2000/2005, ORACLE 11g/10g/9i/8i, MS-Access

Big Data Technologies: Apache Hadoop (HDFS/MapReduce), HIVE, HUE

Tools: Crystal Report, Microsoft-Office, Microsoft Visio

ETL Tools: Informatica8.1/7.1/6.2,Ab Initio

Data Modeling: ERWIN Platinum4.1.4

Programming Languages: C, C++, JavaScript, SQL, PL/SQL, Shell Scripting

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2005 Server, UNIX

Others: HTML4.0, DHTML, XML, LDAP, VBScript, JavaScript, MS Office, Macromedia Dreamweaver, Macromedia Fireworks, Macromedia Flash, Microsoft FrontPage

PROFESSIONAL EXPERIENCE:

Confidential, Tampa, Florida

MicroStrategy Consultant

Responsibilities:

• Co-ordination with functional team and business analysts in understanding the business requirements.
• Production support for existing projects in PROD environment.
• Closely works with senior management and understand the business to provide a better solution in data analytics.
• Extensively worked on MicroStrategy Report Service Documents (RSD), dashboards and Visual Insight (VI) dashboards.
• Developed intelligent cubes, Freeform SQL reports and used them as a source for dashboards.
• Migration of objects and projects between environments using Object Manager tool.
• Created logical view with in MicroStrategy environment for some requirements without having dependency on ETL team and DBAs.
• Experience in graph development and ability to read, analyze and understand the Ab initio code with various components.
• Good understanding of migration activities and processes.
• Good knowledge of UNIX and SQL.
• Good understanding of analyzing the code to identify Graphs, Psets, Plan/Conduct>IT for project source files, tables etc.
• Optimize the performance at report level, metric level and at dashboard level.
• Perform UNIT testing, Regression testing and UAT support for new projects.
• Conversion of multiple projects from SAP BO universe/IBM Cognos into MicroStrategy.
• Solution to complex schema designs while converting projects from SAP BO into MicroStrategy and IBM Cognos to MicroStrategy.
• Created complex nested metrics using different functions like ApplyAgg, ApplySimple and Case statements in reports. Also created on the fly derived metrics in a dashboard to improve performance.
• Created transformations for time based comparison data like YTD, PYTD, MTD, YoY and MoM.
• Extensively worked on all available prompt filters in MicroStrategy which provide flexibility to users to choose inputs to reports and dashboards.
• Created mobile dashboards for Android and IOS devices.
• Currently working on a POC using R modelling in MicroStrategy using as an input for computational graphs.
• Extensively worked on MicroStrategy tools like Object Manager, Enterprise Manager and Command Manager.
• Implemented URL API and links to pass selected parameter from source to target documents.
• Have been working on an in-house reporting tool call Inquiry Frame Work (IFW), which is a primary reporting tool for our application that has closed to 2000 strong user base.
• Integrated IFW application with TIBCO Jaspersoft for visualizations and crosstab reports.
• TIBCO Jaspersoft heavily uses JavaScript for creating xml files, which are used in IFW application for visualizations.
• Extensively worked with support teams on MicroStrategy upgrades, server patches, server reboots or any other software related issues.
• Currently working on a BI tool Suite evaluation POC, which involves creating a POC project on multiple BI tools like Power BI, Qlikview & TIBCO Spotfire and present it to the senior management?
• Scope of the POC extends to scalability, licensing cost, self service capability and optimal performance.

Environment: MicroStrategy (10.11/10.4/9.4.1 ), Oracle 11g, Sql server 2008/2012, Windows 2008, Ab initio, TIBCO Jaspersoft, Power BI, Qlikview, TIBCO Spotfire .

Confidential, Jacksonville, Florida

MicroStrategy Consultant

Responsibilities:

• Participate in analysis and design sessions, and based on findings design and build effective and high performing analytic solutions that are in accordance with business customer priorities and business intelligence/data warehousing best practices.
• Review reporting requirements and prepare technical specifications documentation.
• Works in Agile model by participating in daily SCRUM meetings.
• Review and extend reporting standards.
• Develop report objects.
• Worked with team on Install and configure App tier/Web tier. Configure I server to metadata and DWH.
• Worked on other MicroStrategy tools like Command Manager, Integrity Manager, Object Manager, and Enterprise Manager for different project activities.
• Design and build reports and dashboards.
• Create Freeform SQL reports and Freeform XQuery reports using Web Services.
• Assist in functional and system testing of integrated reporting applications, Dashboards, and KPIs.
• Design and code MicroStrategy, including plug-ins that meets product specifications and development schedule.
• Install and configure MicroStrategy Intelligence server both in Windows and Linux environments.
• Support defect cycles.
• Training users on Visual Insight.
• Knowledge transfer for content build and best practices.
• Prototype/POC development to enable client specific and general go-to market solutions.
• Design and deliver end-user training and training materials. Troubleshoot problems.
• Collaborate with Database Architect on data warehouse elements that affect software reports and dashboards and works with them to resolve incompatibilities.

Environment: MicroStrategy (9.4.1), Oracle 11g, Sql server 2008/2012, Windows 2008, Informatica.

Confidential, Overland Park, Kansas

MicroStrategy Architect/ Developer

Responsibilities:

• Understanding the business requirements and implement the solution in MicroStrategy.
• Involve in data modelling phase and understand the table structures, data types and hierarchies.
• Experienced knowledge in different types of data modeling, like- star schema modeling, snow flake modeling.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect.
• Design and develop Reports with challenging requirements.
• Extensively worked in developing Metrics (Dimensional metrics, Compound metrics), Filters, Custom groups and Consolidations in reports.
• Designed Templates and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Used Transformations for comparative reports like claims this year to last year (year to date, month to date and month to month).
• 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.
• Used several controls for dashboards like time series slider, radio buttons and dropdown menus for the Flash version of the dashboards.
• Used several widgets for Dashboard reporting.
• Deployed ESRI maps into Enterprise dashboards.
• 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.
• 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. Build intelligent cubes on top of free form SQL reports and use it as a source for dashboards.
• Created and maintained attributes, metrics, filters, prompts and reports. Maintained security for all users. Created database views. Coordinated and deployed MicroStrategy report changes to the Production environment.
• Currently working on converting reports from Business objects (SAP BO XI 3.1) into MicroStrategy by creating free form SQL reports.

Environment: Microstrategy 9.4.1(Desktop, Web, Architect, Administration, MSTR Tools), Object Manager, Command Manager, Oracle 11g, Windows 2008.

Confidential, Dallas, Texas

MicroStrategy Architect/ Developer

Responsibilities:

• Served as Primary Micro Strategy developer for developing enterprise dashboards.
• Designed and developed Dashboards using MicroStrategy Report Service Documents.
• As per business requirement, Designed developed and maintained MicroStrategy based reports.
• Created Enterprise Manager Reports for various analyses.
• Configuration of Narrowcast server and Involved in various Narrowcast tasks like creating Documents, service designs, subscription, administration and scheduling.
• Created Attributes, Metrics, security filters and other report objects, drilling, defined hierarchies using Micro Strategy Desktop.
• Used MicroStrategy functions such as ApplySimple, ApplyComparision & ApplyAgg in the metric calculations and used in different reports.
• Experience in using Project Merge, Object Manager, and Enterprise Manager.
• Excellent experience configuring VLDB properties to fine-tune reports.

Environment: Microstrategy 9.4.1(Desktop, Web, Architect, Administration, MSTR Tools), Object Manager, Command Manager, Oracle 11g, Windows 2008.

Confidential, St. Louis, Missouri

MicroStrategy Architect/Developer (Big Data Analytics)

Responsibilities:

• Involved in all SDLC of the project.
• Involved in deploying Oracle data warehouse into HDFS using SKOOP.
• Understanding the Map Reduce algorithm on huge volumes of data in HDFS.
• Involved in requirement gathering, Analyze and understand the business requirements for report and dashboard development.
• Skilled in coordinating with the Business Groups, End User’s to gather requirements and analyzing the business process, implement the business application and making necessary changes to Application objects and Schema objects.
• Expert at Planning, analysis, design and development of complex reports and scorecards for several business units.
• Through knowledge Dimensional Modeling like Star schema and Snowflake schema.
• Experience in designing the logical model by creating Schema objects (attributes, facts, hierarchies, transformations
• Experience in creating Applications objects like filters, metrics, prompts, reports, report services documents.
• Experience in using OLAP Services like View filters, derived elements, derived metrics, Intelligent Cubes.
• Experience in designing, developing, debugging and enhancing reports by following business rules using MicroStrategy desktop and MicroStrategy web.
• Worked on MicroStrategy administration including intelligence server administration, configuration of memory settings, performance monitoring and VLDB settings.
• Experience in creating complex filters with advanced qualifications involving the bypass functions.
• Experience in creating time series transformations like YTD, MTD, LY, PY etc. using Transformations.
• Experienced in working with different databases like Oracle, DB2 and SQL Server.
• Experience in writing and troubleshooting SQL for report development as well as testing.
• Extensive knowledge in end to end development of software products from requirement analysis to system study, designing, coding testing, de bugging, documentation and implementation.
• Experience in Creating Visual insight dashboards in MicroStrategy Web.
• Experience in designing data visualizations using Visual Insight and also trained super users by creating their own dashboards using this tool.
• Excellent communication, interpersonal and management skills.
• Team oriented, self-motivated and a disciplined individual.

Environment: Microstrategy 9.4.1(Desktop, Web, Architect, Administration, MSTR Tools), Big Data Hadoop, Cloudera manager, Hue, Hive and Impala, Oracle 11g, Windows 2008.

Confidential, Green bay, Wisconsin

MicroStrategy Architect/Developer

Responsibilities:

• Involved in the complete Life Cycle of the project.
• Interacted with the data modeling team for the Logical and Physical model design.
• Involved in designing the Conceptual model.
• Involved in creating the Aggregate tables considering both the Technical Feasibility and Business Feasibility to improve reports performance.
• Created Attributes, Facts, Dimensional Hierarchies and all the public objects like Metrics, Custom groups, prompts and filters.
• Created Hierarchical prompts, nested prompts, object prompts.
• Created Cubes to assist the quick analysis for the Demand and Deployment Team. In turn reduced a large amount of load on the MicroStrategy and Database.
• Experienced in performance tuning of the reports and the environment.
• Involved along with Oracle DBAs to create partitioned tables and indexes to improve the overall report performance.
• Worked on District Manager Mobile Dashboards for Better, quick and best Analysis of store performance.
• Developed Dashboards using widgets and selectors for summary level reporting.
• Designed Visual Insight dashboards using map visualizations and have trained users on creating one. MicroStrategy data can be viewed on Google Maps and visualized in MicroStrategy web using DHTML, in Visual Insight, an iPad.
• Created Dashboards using report services documents. Applied custom fonts on dashboards using SDK.
• Developed Dynamic Dashboards and Scorecard reports.
• Developed departmental dashboards for different brands and Key Performance Index corporate dashboards.
• Migrated Narrocast Services to Distribution Services.
• Created customized Custom Groups with complex filters and Relationship filters.
• Created Complex reports for analysis (like Market Basket analysis) with custom groups, Transformations and complex filters.
• Designed efficient BI Dynamic Dashboards for the business users with dynamic prompt answers and with multiple data sets in both Microstrategy Desktop and MicroStrategy Web.
• Created Ad-hoc reports with dynamic prompt answers for the end users to generate.
• Worked with the Microstrategy technical support to troubleshoot the dynamic display of prompts in the web mode and some other Report related issues
• Used the VLDB properties for performance tuning and SQL optimization.
• Created Transformations like Last Month to This Month and also created the required transformation tables.
• Experience in analysis the explain plans of SQL and analyzing the indexes in the process of tuning the reports.
• Coordinating with offshore team during migrations and any production support issues.
• Working on Confidential for support.
• Performed the ETL, UAT and System tests on the warehouse tables and the reports.

Environment: MicroStrategy 9.0.1/9.2.1/9.3/9.4/9.4.1 (Desktop, Administrator, Architect, Intelligence Server, Web), Microstrategy, Object Manager, Teradata, Informatica, SQL Server, Windows

Confidential, Plano, Texas

MicroStrategy Developer

Responsibilities:

• Gathering requirements from business users and analysts.
• Has worked on MicroStrategy 9.3 cloud and have down POC with 9.3.1.
• Worked with the business analyst and executives to understand requirements for the Executive dashboard and designed the prototype.
• Collaborate with database architect and ETL developers to aid in the design of efficient and robust data structures for reporting and analysis.
• Involved with ETL team in fixing complex data modeling issues like slowly changing dimensions and designing physical schema model.
• Architected the Schema for the project by creating facts, attributes, and hierarchies.
• Created the application objects metrics, filters, Prompts and Reports using MicroStrategy Desktop to meet report requirements.
• Created daily, monthly reports and dashboards for iPhone, iPad using MicroStrategy mobile.
• Designed interactive and Dynamic Dashboards using Report Services objects like Waterfall, Graph Matrix, Gauges, Widgets and Grid/Graph combinations.
• Dashboard design--Utilized standard templates and added panels.
• Trained business users in creating Visual Insight quick dashboard allowing the user to perform cross analysis over a more complex data structure which spans across different sources, OLAP services & intelligent cube design for advanced analytics and Trend analysis reporting.
• Developed the OLAP services by creating the cubes, view filters and derived elements to improve the performance of the Executive dashboards.
• Extensively used filters, prompts, custom groups, consolidations and transformations to generate reports for business analysis.
• Respond to business users inquires directly to provide technical support and best-practice report consulting.
• Perform code review and unit, system, regression testing.
• Involved in Performance tuning of SQL for long running reports.
• Unit/System Testing & validation of reports using Complex SQL, PL/SQL scripts.
• Defined advanced prompt expressions to create Hierarchy prompt, prompt-in-prompt and nested prompts.
• Customize the web dashboards using SDK using preexisting plugins.
• Created Aggregate Tables, Control Tables and Staging tables in Teradata.
• Provide optimum performance and scalability through Multi-pass SQL, Aggregate tables and VLDB settings.

Environment: MicroStrategy 9.3, Architect, Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, SSIS, Teradata, Windows NT and UNIX.

Confidential, Flint, Michigan

MicroStrategy Developer

Responsibilities:

• Interacted with the Business Analysts and Enterprise users.
• Collected information from business users for finalizing system and reporting requirements.
• Analyzed and lead the development work of MicroStrategy Environment.
• Involved in architecting the schema objects Attributes, Facts, Hierarchies.
• Extensively giving mock-ups to the Enterprise user to better understand the reporting analysis and also making their life easier.
• Designed the configuration objects Filters, Base Metrics, Derived Metrics, Templates and Reports.
• Involved in working with centers for Medicaid/Medicare Services (CMS). Have experience on Medicaid claim processing.
• Analyzed the best way of approaching towards the reporting with minimum amount of maintenance effort, QA work and also giving the flexibility to the users to pick and choose whatever data they like from different key tables.
• Assisted the team in integrating the current project with new Enterprise analytics.
• Optimized query performance by updating VLDB (very large database) properties and by modifying cache behavior.
• Involved in development interactive dashboards and scorecards for high level management.
• Designed reports and documents for iPad, iPhone and Blackberry.
• Customized the drilling options specific to the reports using drill map editor to give access to more detailed and supplemental information.
• Customized reports using Custom Groups and Consolidations.
• Designed Compound metrics and Complex filters and Time filters.
• Developed various Prompts supporting end users to interactively choose different filtering criterion.
• Set up new security filters for the user roles to limit the access to the data.
• Configured Data Marts in MicroStrategy Desktop to update tables in database.
• Optimized query performance by updating VLDB properties at project level and report level.
• Performed optimizations using Report Data Options.
• Have developed dashboards on different versions iPhone for different screen sizes.
• Used MicroStrategy Web to offer interactive reporting to the end users through a web browser
• Extensively used Microstrategy Web to enable users to run-predefined sales and inventory reports for building their own customized reports.
• Unit tested the reports developed by the other developers.

Environment: MicroStrategy 9.2.1, Architect, Web Intelligence, Object Manager, Integrity manager, Configuration Wizard, Informatica 9, Report Studio 8, SSIS, Windows NT and UNIX.

Confidential, Dallas, Texas

SQL Developer

Responsibilities:

• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Implemented a Database design using Designer/2000 in an Oracle 7.3 environment.
• Designed the database based on requirements of the system.
• Designed the User interface for forms with developer 2000 features.
• Generated necessary reports periodically using Reports.
• Created the database, table spaces, tables, indexes and other database objects.
• Loaded the data into the Oracle database using SQL Loader
• Responsible for performing various database administration duties using advanced querying tools and PL/SQL scripting techniques, Procedures.
• Responsible for troubleshooting various aspects of the client/server architecture in both a UNIX and an Oracle setting.

Environment: Oracle7.3, PL/SQL, SQL, Developer 2000 Forms 4.5, Reports3.0, UNIX and Windows 95