Pankaj V

MicroStrategy/Tableau Developer

Email id: acyyh7@r.postjobfree.com

Ph No: 908-***-****

Professional Summary:

MicroStrategy:

Over 8 years of Business Intelligence (BI)/ IT experience with experience in MicroStrategy Suite (MicroStrategy Intelligence Server, MicroStrategy Architect, Desktop, Web, Narrowcast Server, Object Manager), Tableau (Tableau Server and Desktop), Qlikview, Spotfire.

Over 5 years of experience in implementing end to end MicroStrategy solutions for organizations.

Sound knowledge of Databases (Oracle, Vertica and Teradata)

Good experience of working with Narrowcast servers on NT servers and mapping to Client servers.

Hands-on experience in MicroStrategy server administration and maintenance.

Experience in Migrating objects between different environment Dev, Test and Prod

Experience working with the full project life cycle development process, involving analysis, design, development, implementation, and testing phases.

Rich experience in MicroStrategy product namely MicroStrategy Intelligence Server, MicroStrategy Desktop, MicroStrategy Web and MicroStrategy distribution services, Dashboard design and development, responsible for report-development.

Over 5 years of experience in gathering technical requirements, analysis, project modelling, dimensional modelling and ER modelling.

Good experience building Objects like Hierarchies, Attributes, Facts and Transformations and Portal Integration.

Experience in creating public objects like Filters, Metrics, Prompts, Custom groups, Flash Widgets and Consolidations.

Developed Prompts to give end users a choice of different filtering criteria each time.

Experience in creation of reports by using Drill maps and Templates.

Worked in both Ad-hoc and standard reporting environments and involved in creating Reports scalable to large volumes of data.

Worked with the development of the MicroStrategy Implementation Plan and Agile Development.

Good working experience on Designing Simple and Dynamic Dashboards.

Experience in creating security filters for end user to access data based on their Privilege.

Experience in optimize reports using VLDB properties at different levels.

Used Pass through functions at different objects like attributes, facts and metrics

Good Working experience on MicroStrategy Intelligent cubes.

Good working experience in MSTR mobile application development and deployment.

Good experience in the project run and cutover plan. Participated in the execution of the deployment tasks through MSTR.

Good Working experience on MSTR Administration like (User Creation, Security Role, Security filters).

Tableau:

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

End to end experience in designing and deploying data visualizations using Tableau.

Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

Using excel sheet, flat files, CSV files to generate Tableau adhoc reports.

Proficient in Document Management Software MS Office, MS Visio.

Knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

Creating and visualizing dashboards using Tableau Desktop.

Generation of Tableau combination charts using Tableau visualization software.

Data blending implementation on EMPI databases and generated interactive dashboards.

Creating adhoc reports to users in Tableau by connecting various data sources.

Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, SQL*loader.

Development IDE includes SQL-Developer, Toad and Edit plus.

Rich experience in using Oracle 8i/9i/10g, SQL, MYSQL, SQL Server databases.

Profound knowledge of application object design, dashboard design and portal delivery techniques

Education:

Bachelor of Technology in Computer Science from JNTU, Hyderabad India

Technical Skills:

MicroStrategy 9.x/8.x (Architect, Desktop, Web, Narrowcast Server, Object Manager, Command Manager & Enterprise Manager), Tableau V6/V7/V8, Oracle 10g/9i/8i, MS ACCESS, Teradata, DB2 8.0, SQL Server 2000/05, Informatica Power Center 8.6.1, Power Mart 6.2/5.1, Windows NT/2000/XP/ME/95/98, XP.

Professional Experience:

Client: Facebook, Fremont, CA Jun 2015 - Present

BI Engineer

Responsibilities:

Provided Reporting Support for the Sales personnel of Revenue Analytics team within the company.

Worked with business stakeholders of the SMB (Small and Medium Business) to perform solution architecture and gathered technical requirements, technical design, development, testing and QA tasks.

Worked with the Business stakeholders of the Publisher AdTech (Audience Network and LiveRail) within Facebook and performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.

Worked on MicroStrategy mobile platform for mobile application development for the Sales Portal App within Facebook.

Worked with the Small and Medium Business (SMB) Marketing Business Analysts to create efficient and insightful Microstrategy dashboards and reporting solutions for the Campaign Level Marketing strategy.

Extensively used data blending and Level of Detail (LOD) expressions for building Complicated Insights Dashboards in Tableau.

Worked with the Sales Operations team for Atlas to develop a feasible solution for the Sales reporting using Tableau.

Provided Microstrategy development support and training for Users within Facebook.

Worked on generating various dashboards on Tableau Server using HP Vertica, Hive and Salesforce.

Used VLDB settings in reports and cubes to increase the dashboard and cube refresh performance

Environment: MicroStrategy 9.2/9.1, MicroStrategy Intelligent server 9.2, Tableau 9.3/10.1, Oracle 11g database, Vertica, Teradata, PL/SQL, Oracle Stored-procedures/functions, Java 1.5, MySQL, Toad, XML, Git, JIRA, SQL-Developer

Client: GEICO, Chevy Chase, MD Mar 2014 – Jun 2015

MicroStrategy Developer

Responsibilities:

Microstrategy:

Worked with business stakeholders to perform solution architecture and gathered technical requirements, technical design, development, testing and QA tasks.

Performed Requirement Analysis to collect various business measures and attributes to develop a reliable Star Schema and required Facts and Attributes.

Worked extensively with databases DB2, Teradata for the project

Worked on MicroStrategy mobile platform for mobile application development.

Prepared dashboards and reports with complex logic involving analytical functions and compound metrics.

Created MicroStrategy Schema and Public Objects.

Prepared documentation and user guides to identify the various Attributes, Metrics and Reports needed from business.

Developed various Simple and Compound Metrics, Attributes, Facts, Hierarchies, Prompts, Filters, Consolidation and Custom groups etc.

Generated reports using Advanced Metric objects, Filters, Prompts and integrating with Data ware house.

Created customized Templates to facilitate the End users to create customized reports by choosing Filters, Metrics and Report Attributes and Intelligent Cubes.

Created customized Auto Styles to allow reports in MicroStrategy Desktop and MicroStrategy Web to apply customized formats and created Dynamic Dashboard, Flash Widget design.

Performed Object Migration from development to QA.

Performed Unit Testing of the reports and Dashboards.

Involved in creating dashboards by extracting data from different sources.

Created dashboard using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating calculated fields, mapping and hierarchies.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different sources.

Involved in creating a dual-axis bar chart with multiple measures.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Tableau:

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Extensively used data blending in Tableau.

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Server in all the environments.

Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.

Administered user, user groups, and scheduled instances for reports in Tableau.

Performed report generation using Sequel server reporting services (SSRS).

Used VLDB settings in the reports to achieve required results.

Experienced in full-life cycle process including Development, analysis, design and testing

Created various types of graphs and widgets (Waterfall, Heat Map etc.)

Environment: MicroStrategy 9.2/9.1, MicroStrategy Intelligent server 9.2, Tableau 9.0, Oracle 11g database, SQL, Teradata, PL/SQL, Oracle Stored-procedures/functions, Java 1.5, MySQL, Toad, XML, Git, JIRA, SQL-Developer, Unix Scripting, Pentaho Business Analyst.

Client: Mayo Clinic, Rochester, MN Aug 2013 – Mar 2014

MicroStrategy Developer

Responsibilities:

MicroStrategy:

Worked with team of MicroStrategy developers and ETL Team for onsite and offshore. Extensively involved in Data modeling, ETL Mapping, Administrator tasks, Interaction with Business user to understand the raw requirement then converting into technical specification and then starting design and development process.

High user interaction, understanding their requirement

Good working experience with Agile development

Highly interactive and complex report in MicroStrategy Desktop and web and provide production support.

Administrative experience creating user, setting up privileges. Security access to metrics and attribute level

Develop the reports against Star Schema and Snow-Flake Schema.

Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse.

Extensive use of dynamic dashboard and scorecard to predict the trend in market and very interactive presentation and use of data. MicroStrategy web (View, interactive, Editable and flash mode), Subscription feature to improve the performance and mobility of the group.

Experience with OLAP services. Understanding of MicroStrategy architect and its data flow. Experienced in troubleshooting in problems related to I-server, data warehouse, ETL process, metadata, project source and project.

Created of Intelligent Cubes and shared to reduce the database load and decreasing the report execution time by using the cube services

Actively participated in developing Report Delivery Schedules

Tableau:

Created various Monthly Dynamic Dashboard documents for field marketing people with multiple panel stacks, selectors and customized widgets

Involved in creating dashboards and reports in Tableau 6.1.

Created interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Created dashboard using parameters, sets, groups and calculations.

Created drill down and drill up in worksheets.

Involved in creating a dual-axis bar chart with multiple measures.

Created report schedules on Tableau server.

Created incremental refreshes for data sources on Tableau server.

Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1

Created and assisted users in Tableau dashboard development.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Defined and created procedures to install Tableau desktop in silent mode.

Defined best practices for Tableau report development.

Extensively used Tabadmin and TabCMD commands in creating backups and restoring backups of Tableau repository.

Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.

Involved in writing complex SQL queries using table joins (inner and outer).

Environment: Tableau Server V6/V7, Tableau Desktop V6/V7, MicroStrategy 9.0.1(Desktop, Web, Narrowcast Server, Intelligence Server) Teradata V2, Aster Data, Oracle 10g/11g, Erwin Data Modeler 4.1, Informatica Designer 6.0, Windows 2000/NT.

Client: Integra Telecom, Phoenix, AZ Jun 2012 – Aug 2013

MicroStrategy Administrator

Responsibilities:

Administered MicroStrategy environments and formulated user groups.

Handled user licenses for projects.

Managed backup of Metadata.

Supervised report delivery and established project schemas.

Worked on Agile development tools like JIRA and LeanKit.

Formulated grid, graph, document and dashboard reports.

Remote Support for OSS5.2, Trouble shooting of OSS, Fault Management of BSS and OSS.

Worked on Testing Client-Server Billing Framework for OSS/BSS.

Created ad-hoc reports by drilling up, down, within and across Hierarchies.

Generated different types of reports as per the client's requirement, using various objects.

Validating the data with report result by writing SQL queries.

Prepared test case and tested the reports.

Compared the reports with the expected results of the clients. Gone through various levels of dimensionalities to execute the reports with different result set.

Involved in troubleshooting MicroStrategy Report Objects.

Responsible to Identify and mitigation of project level risk to avoid delay in deliverables.

Responsible for maintaining and writing the DB application in Oracle 9i.

Develop/Support SQL queries/stored procedures.

Designing databases from user requirements and technical staff feedback.

Extensively worked on writing the PL/SQL like Oracle stored-procedures, function, cursors, and triggers.

Involved in gathering functional requirement from Business Analysts for the report generation.

Involved in the SQL-tuning, performance/Query optimization for the application using SQL-Joins and Indexes. Improved Query-performance by converting them from sub-queries to use SQL-Joins.

As a quality engineer was involved in regression testing the application. Also, involved in integration testing from end-to-end.

Environment: MicroStrategy 8i/9.2, MicroStrategy Intelligent server 9.2, Oracle 11g database, SQL, PL/SQL, Oracle Stored-procedures/functions, Toad, SQL-Developer, Unix Scripting

Persistent Systems, Hyderabad, India Jan 2009 – Jun 2012

MicroStrategy Developer

Responsibilities:

Designed and developed presentation objects, reports, and dashboards for delivery of BI solutions.

Defined, implemented and refined the BI solution development methodology based on industry best practices.

Worked with PeopleSoft MicroStrategy dashboarding and BI solution including Metadata, Data Sources and reports.

Developed technology specifications and ensured that any new technology solutions are designed for optimal access and usefulness, and leverage existing technologies when possible.

Applied architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability, and manageability.

Configured, maintained, and administered MicroStrategy models, packages, reports, and dashboards.

Monitored and supported multiple jobs, scripts, and events.

Deployed and supported MicroStrategy reports, ad-hoc packages, and In-memory cubes.

Continually monitored and tuned the performance of the platform.

Developed standard OLAP features such as intelligent cubes (I Cubes), data aggregation, derived metrics, Banding, Aliasing, Page by, Pivoting, Sorting, Thresholds and Subtotals.

Trained different types of end users on MicroStrategy desktop and Web; supported huge number of users.

Worked extensively on MicroStrategy Narrowcast Server to deliver scheduled reports using Static and Dynamic Subscriptions.

Optimized tables, views and SQL definitions using indexing to enhance performance.

Worked on Setting up user accounts, building security models and privileges, migration of objects from different environments, and performance monitoring of the MicroStrategy tool.

Environment: MicroStrategy 8.2.1/8i Product Suite (Desktop, Object Manager, Enterprise Manager, Narrowcast Server, Command Manager, Web, Mobile), TeradataV2R6, Oracle 11g, DB2, DataStage, Informatica 8.6.1, Windows NT, UNIX and Toad.

Contact this candidate