SUMMARY

• Over 8+ Years of strong IT Experience in Business Intelligence (BI), ETL and Data Warehousing Project Development and Implementation using MicroStrategy 10.x/9.x/8.x product suites including Administrator, Intelligence Server, Architect, Desktop Designer, Security Administration, MicroStrategy Web Administration, Object Manager, Command Manager Integrity Manager, Report Services, Enterprise Manager, Narrowcast Server and Dashboards.
• Certified in MicroStrategy Advanced Analytics Reporting - 10.412
• Used a variety of other technologies, including Informatica, and self-taught Tableau & Spot fire.
• Expertise wif entire Software Development Life Cycle (SDLC) which includes requirement gathering and analysis, Design and Development, Implementation, Testing, Deployment, Production support and Maintenance, Built and Release management.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation, Custom Groups and Intelligent cubes) wif the data warehouse.
• Extensively worked on Dashboard components including Widgets, panels, selectors& layouts for a dashboard implementation, Report tuning, Report testing, Ad-hoc, Mobile and training Business Users in various OLAP services in MicroStrategy.
• Expert in creation of Report Service Documents, Scorecards and Dashboards which helps in better understanding of business trends.
• Good understanding of intelligent cubes and Visual insights, and good knowledge in Analysis, design and construction of the metadata.
• Excellent knowledge of fundamental data warehousing concepts like dimensional modeling data mart modeling, star and snow flake schemas.
• Strong experience in MicroStrategy connectivity wif several databases such as Oracle, SQL Server, Teradata, Netezza, MS Access.
• Exposure in SDK design, development, implementation.
• Experience in connecting data warehouses directly to the MicroStrategy Cloud Platform via VPN and also Uploading a backup of data warehouse data to MicroStrategy Data Warehouse Services servers.
• Experience inMicroStrategyschema & application layer, report analysis & report services (dynamic dashboards) design, development, implementation and testing.
• Experience in various Performance Tuning methods such as Aggregate Tables, Caching, VLDB settings, Partition Mapping and Creation of indexes on tables. Worked extensively on MicroStrategy mobile for IPad & iPhone on design, architecture and mobile administration.

TECHNICAL SKILLS

BI Tools: MicroStrategy Desktop, Architect, Web, Intelligence server, Administrator, Report Services, Command manager, SSRS, Tableau Desktop,Spot fire Server

ETL Tools: Microsoft SQL Server Integration Services, Informatica, Fast Loads, Multi Loads

Languages: C, C++, Java, PL/SQL and Objective-C.

Supporting Tools: MS Project, SQL Navigator, TOAD, and Adobe Flash

OLAP Tools: MicroStrategy, Oracle server.

Technologies: Servlets, Struts, Hibernate, Spring, Log4j, Web services using SOAP and RESTful, XML, JDBC, JSP and JDBC, Spring 4.x, Hibernate, JSP, MVC, Struts, Servlets, jQuery, AJAX.

Databases: Oracle11g/10g/9i, My SQL Server, Teradata 13.x/V2R6, Netezza, Sybase.

IDE: Eclipse, Intellij, Notepad++, Visual Studio, Spring Tool Suite and RAD.

PROFESSIONAL EXPERIENCE

Confidential

MicroStrategy Admin

Responsibilities:

• Responsible for gathering Business Requirements and interacted wif Business Analysts for the development of Reports as per the requirements.
• Installation and Configuration of MicroStrategy Suite.
• Created technical design, Mockup data, Object mapping document, based on the requirement document.
• Interacted wif ETL team to incorporated necessary changes in data model for MicroStrategy Reporting.
• Expertise in creating MicroStrategy dashboards, reports, applications and schema objects (Attributes Facts, Filters, Hierarchies, Metrics, Prompts, Custom Groups, and Consolidations).
• Created Adhoc reports using prompts for selection of Concept, time periods and weeks.
• Extensively worked in developing Metrics, Compound Metrics and Filters for complex reporting.
• Set up new security filters for the user roles to limit the access to the data.
• Performed troubleshooting tasks on MicroStrategy web reports, optimized query performance using the VLDB Properties.
• Created transformations for YTD (year to date), MTD (month to date), and WTD (week to date),YTM (Year to Month), PYTM (Previous Year to Month) analysis.
• Migration of projects, reports and Objects between Development, QA and Production environments using Object Manager.
• Designed, Developed and Maintained MicroStrategy Mobile Dashboards using graphs, panelstacks, selectors, widgets, swipe and tap functionality.
• Developed Dashboards in the end users prospective where the users can build their own dashboards exploring their data using data visualizations through MicroStrategy Visual Insight.
• Involved in designing and creating MicroStrategy reports for DTC (Direct to Consumers) channel, Caching and scheduling the reports to improve the response time.
• Integrated MicroStrategy 10.4 Dashboards wif SharePoint site by deploying MicroStrategy Webparts and me-Frames in Microsoft SharePoint Foundation 2013.
• Created/Passed dynamic Prompts for the SharePoint to the embedded MicroStrategy Dashboards using MicroStrategy Web URL's wif the help of JavaScript.
• Involved in testing of Reports by executing MicroStrategy-generated SQL against the database using Aqua Data Studio 4.

Environment: MicroStrategy 10.x/9.x (MicroStrategy Intelligence Server, Administrator, Desktop/Developer, MicroStrategy Web, MicroStrategy Mobile, Visual Insight, Enterprise Manager, Object Manager, Command Manager), Windows 7, Informatica 9.1, Rally, Splunk, SQL Server, Oracle 10g/9i, Teradata 13.10, SharePoint 2013, Aqua Data Studio, MS Office.

Confidential - McLean, VA

MicroStrategy Developer

Responsibilities:

• Involved in the meetings wif business users to discuss and finalize the requirements and user stories. Worked wif credit desk risk managers and gatheird reporting requirements.
• Involved in Dimensional Data Modeling (Star Schema) Data Architecture, Business and Data Analysis (customer and financial reports)
• Involved in Creation of Schema Objects (Attributes, Facts, Hierarchies and Transformations) from Warehouse Catalog and also involved in Creation of Public Objects (Filters, Prompts, Metrics, Consolidations, Custom Groups, Templates and Drill Maps) regarding in generation to customer and financial reporting.
• Involved in Setting VLDB Properties at Report, metric and database instance Levels to manage joins, metric calculations and query optimizations.
• Involved in creation of Consolidation and Custom groups to group elements of attributes based on Filter conditions.
• Expertise in using pass through functions like Apply Simple and Apply Comparison.
• Created different kinds of dashboards and documents using different controls, selectors, sliders, Links and widgets to view in different kinds of modes like DHTML, Flash mode. Worked on different document modes like design, editable mode and interactive modes.
• Involved in Creation of simple metric, compound metric, derived Metric, filter metric and Transformation metric to meet end user requirements.
• Supported end user Ad-hoc request. Responsible for troubleshooting report data.
• Created Ad-hoc reports by drilling up, down and across Hierarchies.
• Involved in partitioning the tables, indexes and management of the schema objects.
• Involved in optimization of code and tuning queries for performance.
• Involved In testing of reports and queries by test cases and test plans.

Environment: MicroStrategy 10.4/ 10.2 /9.4.1, Developer, Architect, Administrator, Reports, OLAP Services, Dashboards, Intelligent Cubes, Visual Insights, Teradata.

Confidential - NY

MicroStrategy Developer

Responsibilities:

• Used TIBCO Spotfire to analyze and obtain insights into large data sets.
• Gatheird user requirements, analyzed and designed software solution based on the requirements.
• Created visually compelling interactive reports and dashboards.
• Found the right balance between manipulating data using Spotfire versus using a programming language.
• Possess SQL and programming knowledge to deal wif data transformations and translations.
• Designed Practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in Spotfire for Analytical Projects and Data Visualization Community.
• Creating data sources, parameter information links, joins, filters in information designer for fetching data in to Spotfire as per the business needs.
• Designed and implemented real-time monitoring Dashboards for TIBCO Spotfire Server and Visualization Community.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content dat is being communicated.

Environment: TIBCO Spotfire, Spotfire Web Player, JIRA, Oracle, SQL, HTML, Python, Unix.

Confidential - Whippany, NJ

MicroStrategy Developer

Responsibilities:

• Worked on the Excel formatting, macros and templates of the documents which are used in different services.
• Customized and optimized reports for various users using MicroStrategy features like VLDB properties at Project level and report level.
• Extensive Testing and Data validation of Reports before delivering it as Business takes important decisions on data we provide.
• Used Analytical engine bypass functions like Apply Simple & Apply Comparison whenever necessary
• Experience in using Teradata utilities such as Fast load, Multiload and Fast Export.
• Developed complex dashboards in Tableau as a part of MDM-Tableau uplift project from scratch.
• Gatheird requirements from different stake holders from MDM team to develop 30 dashboards across multiple Business Units.
• Created status reports and used Jira for tracking the issues and Data Service Request(DSR's) from Business users.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), Teradata

Confidential

MicroStrategy Developer

Responsibilities:

• Worked as a MicroStrategy analyst for the financial Users to support various reporting needs for the business.
• Created Metadata & Statistic tables for MicroStrategy projects.
• Involved in Conversion of Corporate Data Model into a Warehouse Star and Snowflake Model.
• Involved in normalizing the data from source systems by identifying columns in the table, which came in as fully De-normalized flat file.
• Extensively used Metrics, Compound Metrics, Filters, Custom Groups and Consolidations.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop and Architect.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, Custom Groups and Consolidations for complex reports.
• Extensively worked on Report Services to create performance dashboard reporting.
• Created drill maps for end users to drill down and recover data.
• Created Aggregate Tables, Control Tables and Staging tables in Teradata. (Meta) Data standardization, naming convention standardization across multiple projects for an enterprise level strategy.
• Involved in using the Object Manager to move the objects from Development to Production Environment in MicroStrategy.
• Worked on Enterprise manager to generate reports in enterprise manager
• Responsible for various administration tasks like Tuning, Caching, specifying Query Governing Thresholds and Report Optimization.

Environment: MicroStrategy 8.0 (Administrator, Web, Desktop, Narrowcast Server, Object Manager, Enterprise Manager, Report Services), Teradata, SQL2000.

Confidential

Java Developer

Responsibilities:

• Deployed WAR applications in Web Logic.
• Involved in prototyping, proof of concept, design, Interface Implementation, testing and maintenance.
• Created use case diagrams, sequence diagrams, and preliminary class diagrams for the system using UML/Rational Rose.
• Designed and developed the persistence tier using Hibernate framework.
• Designed and developed front view components using JSP and HTML.
• Developed re-usable utility classes in core java for validation which are used across all modules.
• Developed UI navigation using Spring MVC architecture. (JSP, JSF, tiles, JSTL, Custom Tags).
• Created JSF components for presentation layer.
• Used JNDI to support transparent access to distributed components, directories and services
• Used Core Spring for Dependency Injection of various component layers.
• Used SOA REST (JAX-RS) web services to provide/consume the Web services from/to down-stream systems.
• Deployed and tested the application wif web server Tomcat, WebSphere.
• Developed Interactive web pages using AJAX and JavaScript.
• Worked on Report Module, generating PDF/ CSV according to template.
• Configured and tested the application wif database server MySQL.
• Developed various objects using java and HTML and DHTML to maintain well-structured GUI and to interact wif Controllers to get data from MySQL database.
• Involved in developing various reusable Helper and Utility classes using Core Java, which are being used across all the modules of the application.
• Used the built tools Maven and ANT for clubbing all source files and web content in to war files.
• Helped in database design and tuning.
• Created stored procedures, Views in the Database.

Environment: Core Java (Multithreading, Collections), JSP, JSTL, Servlets, Spring, MySQL, XML, HTML, Java Script, AJAX, SOAP, JDBC, Shell Scripting, JUnit, log4j, JMS, Apache Tomcat, WebSphere.

Confidential

JR. Oracle APPS DBA

Responsibilities:

• Handling day-to-day activities.
• Database administration of the Oracle database System.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Performing all the Database Administration activities like space management in database, user and roles administration, schema management, checking alert log of all the databases •Involved in the process of tuning and refining queries of various applications.
• Involved in the process of exploring new areas of Oracle and its products.
• Worked as Database administrator for the Human Resources database.
• Oracle 9i Database software in Linux, created database according to the requirement of Application Software, monitored and configured databases.
• Oracle Database Administration (logical & Physical database backup, database tuning)
• Daily database backup, table space administration, SQL net configurations and basic database tuning as part of maintenance activities.
• Maintenance of existing system and provided advanced level support.
• Involved in System study, Analysis, Design and Development.
• Developed back-end Stored Procedures, triggers, functions.
• Worked on import/export and SQL- loader.

Environment: Oracle 8i, 9i, RMAN, Solaris, Sql Server 2000, Windows NTz