SUMMARY: TECHNICAL SKILLS:

BI TOOLS: MicroStrategy Desktop 10.2/9.4.1/9.3.1/9. x/8.x, MicroStrategy Architect, MicroStrategy Web, MicroStrategy Intelligent Server, MicroStrategy Narrow Cast Server, Distribution Services, Integrity Manager, Enterprise Manager, Project Source Manager, Connectivity Wizard, Object Manager, SSRS, Tableau

DATA MODELING TOOLS: rwin data modeler.

DATABASES: Oracle 11g/10g/9i/8i, MS SQL server 2000/2005/2008/2012, MS Access, TeradataV14/V13, DB2, Netezza, UDB V9.7/9.5, Big data.

OPERATING SYSTEM: Window Server 2000/2003/2008, Unix, Linux

Query Tools: SQL server management studio, AQT, Aginity, Win SQL,SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, CA

SR. MSTR Developer

Responsibilities:

• Designed the Microstratergy Project schema/Architecture and involved in suggesting changes to the Logical Data Model as per the Business rules and implementing the same in the Microstratergy Project Schema.
• Responsible for documenting the Functional & Technical Design documents. Responsible for complete Functional Analysis and Data Warehouse for regular Releases and Projects, which requires frequent interaction with the Business Users.
• Created and modified attributes, facts, hierarchies and transformation objects as part of the development work for a project.
• Created reports using Prompts, Filters, Advanced filters, Custom Groups and Consolidations.
• Confirmed that proper relationships are established between the attributes to restrict any improper SQL query joins.
• Ensured that the Logical size of the tables are properly set to facilitate the selection of the right tables by SQL engine for a given query.
• Created complex reports using free form SQL.
• Good in creating workflows using system manager and automating them.
• Developed Dashboards that provide users a highly graphical, summary view of key metrics.
• Had good experience in creating Transaction services Dashboards.
• Created Dashboards in both the interactive and flash mode.
• Used several widgets for Dashboard reporting.
• Created advanced panel selectors and inserted them in a grid view.
• Tested all the reports by running queries against the warehouse - using SQL Developer.
• Played a key role in User Acceptance testing of the reports.
• Worked with data analysts also.
• Extensively used Distribution Services to deliver reports directly to business users through Email & History List.
• Extensively worked on MicroStrategy Web and MicroStrategy Mobile configurations
• Customized web interface using SDK.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Microstrategy SDK customizations.
• Used Report Services to generate Documents for exporting to Excel & PDF.

Environment: s:MicroStrategy 10.2(Administrator, Architect, Desktop, Web, Intelligence Server, Mobile, Command Manager, Microstrategy SDK, Object Manager, System Manager), Oracle.

Confidential, WI

Microstrategy Developer/Architect

Responsibilities:

• Involved in gathering business requirements and documenting specifications.
• Functional Analysis for all the Data Marts and Data Warehouse for regular Releases and Projects.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (Time Series Slider, ESRI Maps, Graph Matrix) both in flash and interactive modes
• Created and modified attributes, facts, hierarchies and transformation objects as part of the development work for a project.
• Created complex reports using advanced objects like transformational metrics, advanced filters, advanced metrics
• Heavily worked on testing and validating the data and involved in optimizing SQL, troubleshooting reports using VLDB properties
• Set up schedules for various Reporting Objects, Cache clearing and Intelligent Cube refresh.
• Created subscriptions for Delivery of reports using Distribution Services
• Providing support for the production issues and QA.
• Created multi-layered Dynamic Enterprise Dashboards using panels, panel selectors, and widgets like Time Series Slider, Heat Map, Map & Gauge and grids/graphs using multiple datasets.
• Creation of Intelligent cubes and schedule full refresh and incremental refresh.
• Created complex reports using free form SQL.
• Experience in customer requirement gathering, Requirement analysis, Design and Development of complex and Interactive Dashboards.
• Expertise in Microstratergy Architecture involving certain of schema objects such as attributes, facts, user Hierarchies and Transformations and advanced schema design involving logical views, role attributes, and advanced hierarchies.
• Migrated objects from DEV to QA by creating packages through Object manager.
• Synchronizing the Schedules.
• Worked with Erwin in designing the schema for database views.
• Worked on the Data marts and Data Warehouse.
• Installing and Configuring MicroStrategy suite including MicroStrategy Desktop, Intelligence Server, Web/Mobile, and Narrowcast Server on Windows and Linux Environments.
• Installing of Database Driver in Server.
• Monitoring the Services and Backups.

Environment: MicroStrategy 9.4.1 (Administrator, Architect, Desktop, Web, Mobile, Object Manager, EnterpriseManager), Oracle, Erwin, Big data(Hadoop).

Confidential, Raleigh, NC.

Microstrategy Developer

Responsibilities:

• Generated and implemented schema objects and Application Objects by creating Facts, Attributes, Hierarchies, Reports, Filters, Metrics and Templates using MicroStrategy Desktop and Architect.
• Using advanced objects like transformational metrics, advanced filters, advanced metrics created complex reports.
• Created ad-hoc reports by drilling up, down, within and across Hierarchies.
• Documents are generated using Report Services.
• Created multi-layered Dynamic Enterprise Dashboards using panels, panel selectors, and widgets like Time Series Slider, Heat Map, Map & Gauge and grids/graphs using multiple datasets.
• To hide objects from showing up on the Documents/Dashboards Conditional Formatting is used.
• Created Intelligent Cubes based on the ad-hoc requests to initiate Self-Serve reporting.
• Created complex reports using Free Form SQL.
• Experience in design & development of Report Service Documents (Web and Mobile), Visual Insights Dashboards with multiple datasets.
• Worked on the analysis of data.
• Involved in streamlining the MicroStrategy Development process.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Extensively worked on MicroStrategy Web and MicroStrategy Mobile configurations
• Involved in Proof of Concept testing, User training and business development proposals.
• Anchor proof of concept for Big Data (Hadoop) & Salesforce integration with Microstrategy.

Environment: MicroStrategy 9.3.0/9.0.0 (Desktop, Architect, Mobile, Administrator, Web, OLAP), Teradata V13, Windows Server 2008 R2, Big data(Hadoop).

Confidential

Microstrategy Developer

Responsibilities:

• Defined Facts, Attributes, Hierarchies and Relationships.
• Involved in managing objects between different environments by using object manager.
• Generated Metrics, Prompts, Filters, Custom Groups and Consolidations for the report development.
• Creation of Intelligent cubes and sharing to reduce the database load and decreasing the report execution by using the Cube Services.
• Designed Dashboards summarizing key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents.
• Developed reports enabling Data Drilling across multiple Dimensions using Desktop and Web. Graphs and Alerts were used to support the Reporting process.
• Created advanced panel selectors and inserted them in a grid view.
• Extensively used report services to create Dynamic Dashboards using panel stacks, selectors, and widgets in flash mode.
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets (time series slider, gauges, bubble graphs) both in flash and Interactive modes.
• Have used several new controls for Dashboards like time series slider, radio buttons, and drop down menus.
• For Dashboard reporting used Several Widgets.
• Created subscriptions for Delivery of reports using Distribution Services.
• Worked on the testing and validating the data and Involved in SQL troubleshooting reports using VLDB properties.
• Fixed defects and performed upgrades for existing projects.
• Created subscriptions for Delivery of reports using Distribution Services.

Environment: MicroStrategy 9.2.1 (Administrator, Architect, Desktop, Object Manager), Netezza, Informatica 8.6, Windows XP Professional 2003.

Confidential

Jr. BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Upgraded MS SQL Server 2000 databases to 2005, using detach/attach, backup and recovery and by replication.
• Developed and maintained a combined data store for reporting purposes.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of the report.
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Tuned SQL queries using execution plans for better performance.
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance.
• Used Query for ad hoc Reports and Users design Custom Queries.
• Analyzed reports and fixed bugs in stored procedures.
• Documented and prepared project status report updates and audit reports

Environment: MS SQL Server 2005, MS SQL Server 2005 Reporting Service, MS SQL Server Integration Services 2005, BIDS, Erwin, T-SQL, Windows XP