SUMMARY

• Senior Business Intelligence Professional with over eight years of complete BI project life cycle experience using Tableau and Microstrategy. Team player and self - starter with good communication skills and ability to work independently and as a part of a team.
• Over three years of experience working with various versions of Tableau Desktop and Tableau Server including Tableau 7x, Tableau 8x and Tableau 9.0.
• Extensive experience in Tableau dashboard development including design and performance tuning
• Extensive Tableau experience in enterprise environment and Tableau administrationincluding server installation and configuration,technical support, troubleshooting, report design and monitoring of system administration parameters.
• Experience working withTableauagainst multiple data sources and creation of Tableau Data extracts
• Seven years of extensive working experience with MicroStrategy Suite (Intelligence Server, Administrator, Architect, Desktop, MDX Adapter/ OLAP Provider, Narrowcast Server, Report Services).
• Experience working with Tableau command line tools tabcmd and tabadmin for managing scheduled tasks, administering users and groups, troubleshooting, performance tuning, and general systems maintenance.
• Experience in data modeling with high proficiency in using Erwin for Dimensional Modeling (Star and Snowflake schemas).
• Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server.
• Experience in MicroStrategy Architectingsuch as creating Schema and Public objects (Metrics, Filters, Prompts, Facts, and Attributes).
• Proficient in developing ad-hoc and canned reports.
• Extensive knowledge of SQL, PL/SQL, stored procedures, stored functions, packages, and triggers and worked on very large databases in Netteza 4x, Teradata V2R4, Oracle 10g/9i/8i/7.x, and SQL Server 2000/7.0/6.5.
• Experience coordinating with offshoreteams.

TECHNICAL SKILLS

BI Tools: Micro Strategy (Suite 8x, 9.3x, 9.4x)Tableau 7x/8x/9.0(Desktop and Server)

Databases: Oracle10g/11g

MS SQL Server 6.5/7.0/2000/03/08/12 : Teradata v12, v13, Netezza, MS Access

Data Modeling: Erwin 4.0/3.5.2

Programming Languages: C, C++, TSQL, PL/SQL

Web: HTML, ASP

Operating Systems: Microsoft Windows 98/00/NT/XP, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr Tableau Developer

Responsibilities:

• Helped set up a Data Integration Layer which consolidated data from multiple data sources ensuring data consistency and data quality by handling basic data cleansing and standardization of data elements
• Performed Data Profiling to assess the quality of data from various sources
• Worked on the Business Intelligence tool evaluation process and presented findings and recommendations to the business. Based on this, Tableau was selected as the reporting tool for the project
• Lead a team of Developers to deliver high quality and efficient Tableau dashboards and ad-hoc reporting capabilities
• Built user-friendly visualizations using most of the Tableau Desktop features including actions, parameters, LOD calculations, filters and various others
• Optimized Tableau dashboards with a focus on usability, performance, flexibility, testability, and standardization
• Created repeatable processes for data extraction, enhancement and analysis activities in Tableau
• Helped setup and configure Tableau Server 9.0
• Trained clients in the use of Tableau Desktop and Server
• Worked with Tableau command line toolstabcmd and tabadmin for managing scheduled tasks, administering users and groups, troubleshooting, performance tuning, and general systems maintenance
• Wrote numerous views using SQL to support reporting needs

Environment: Tableau Desktop 8.3/9.0/9.2, Tableau Server 9.0, SQL Server 2008 R2/2012, ASP, HTML, Windows, Microsoft Office suite

Confidential, Atlanta, GA

Business Intelligence Consultant

Responsibilities:

• Performed complex analysis, design, test plans, testing, debugging, modification and support for MicroStrategy business intelligence system
• Provided advanced technical troubleshooting for MicroStrategy and other BI reporting platforms emphasis on root-cause analysis including data issues and SQL validation
• Developed and tuned executive dashboards for web and mobile users
• Architected schema objects and built grid reports, graphs, metrics, filters, prompts, data visualization mockups
• Managed project delivery and release migrations through standard lifecycle development while ensuring highest quality design and delivery of projects with required scope, on time and on budget
• Researched solutions to various business and technical problems, evaluate alternatives, scope appropriately and present recommendations with justification to management
• Participated in data model design reviews meant to service corporate MicroStrategy users
• Collaborated with Business Analysts to translate business requirements into technical specifications
• Provided technical advice to corporate and non- corporate developers creating MicroStrategy objects and ETL code
• Participated in project planning, milestone identifications, and resource requirement planning

Environment: MicroStrategy 9.3.1 (Administrator, Architect, Desktop, Object Manager, Web, Command Manager), Teradata, SQL Server, ASP, HTML, Windows, Microsoft Office suite

Confidential, NYC

Sr. BI (Tableau) developer

Responsibilities:

• Analyzed the business requirements, identifying the requirements, reviewing and communicating with business and getting sign offs from business
• Developed reports, dashboards, SQL queries using Tableau
• Synthesized and translate Business data needs into creative visualizations in Tableau
• Performed Tableau administration tasks like creation of users, groups, projects, workbooks and permission sets for Tableau server logons and security checks
• Tuned Tableau reports for optimized performance
• Assisted with best practices during implementation and integration of Tableau Platform
• Worked with MicroStrategy Architect to build Attributes, Hierarchies, Facts and Dimensions and developed perfect logical models for reporting environment
• Generated and implemented advanced MicroStrategy Reports concepts by creating metrics, filters, templates, consolidations, transformations and custom groups
• Solved business challenges by helping to translate the meaning of data, impact of data, and communicated the story that the deliverable tells or the problem that the deliverable solves
• Supported peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting, analysis of results, Production Support, and identification of opportunities to solve Business problems through BI

Environment: MicroStrategy 9.2x/9.3x/9.4x (Administrator, Architect, Desktop, Object Manager, Enterprise Manager), Tableau 7/8/8.1, Oracle 11g, Netezza, Teradata, SQL Server, Java, ASP, VB, .NET, XML, HTML, C, C++, Unix, Windows, Microsoft Office suite

Confidential, Columbia, MD

MicroStrategy Consultant

Responsibilities:

• Interacted with the users extensively to gather the requirements, and analyzed the needs of the end users
• Generated and implemented MicroStrategy reports by creating projects, attributes, hierarchies, metrics, filters, and templates using MicroStrategyDesktop
• Involved in Conversion of Corporate Data Model into a Warehouse Star or Snowflake Model
• Extensively worked in developing Metrics and compound metrics, filters for complex reports
• Involved in troubleshooting MicroStrategyprompt, template, consolidations, and custom group objects in an enterprise data warehouse team environment
• Created documents with both Grids and graphs as per user requirements
• Created Intelligent Cubes for performance tuning
• Used analytical and governing settings in VLDB properties to tune the SQL and for calculating the metrics in dealing with the nulls and zeroes in data
• Narrowcast Server was used extensively in the various phases of Report generation namely Self-Subscription, Profile Management, Proactive Information Delivery and alerting, Content Management and Personalization
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance

Environment: MicroStrategy9.0x/9.2x (Desktop, Web, Intelligent Server, Narrowcast Server), Oracle 10g, Informatica, ER diagrams, Data Flow diagrams, SQL Server

Confidential, Piscataway, NJ

MicroStrategy Consultant

Responsibilities:

• Involved in the design/development life cycle including gathering requirements, user interaction and report design and development. Created Reports using complex Filters and Compound Metrics and Prompts
• Working with Free-Form SQL reports to create reports that are not supported by existing schema model
• Used various apply functions like apply simple, apply comparison and also case statements to support various business requirements
• Successfully created Physical Schema, Indices including unique, secondary join upon determining which is best in terms of performances

Environment: MicroStrategy9.0(Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager), Informatica, Oracle 10g, HTML

Confidential, East Hartford CT

MicroStrategy Developer

Responsibilities:

• Assisted the project management team with the data modeling and streamlining the ETL processing
• Involved in development of the Public Objects such as Filters, Prompts, Metrics, Templates, Drill maps necessary for producing the Client Reports and Scorecards
• 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
• Was involved in educating the Corporate Workplace Executives the effectiveness of the developed MicroStrategy Reports and Scorecards and their flexibility
• Extensively worked to develop Free Form SQL reports for transactional analysis requirements

Environment: MicroStrategy 9.0x (Administrator, Architect, Desktop, Narrowcast Server, Object Manager, Enterprise Manager) Informatica Power center, Oracle, Toad, Windows NT

Confidential

MicroStrategy Report Developer

Responsibilities:

• Responsible for gathering and refining business requirements from the Business users
• Extensively worked on creating Metrics, Derived Metrics and Filters for Complex Reports
• Created reports using Advanced Metric Objects, Filters, Prompts and thus provided users with the facility to create customized reports by creating their own filters and templates
• Generated advanced reports in Grid mode and Graph mode using MicroStrategy Desktop
• Extensive data extraction from numerous DB2 data tables

Environment: MicroStrategy 8.1x (Architect, Agent, Object Manager, Web, Administrator,Enterprise Manager Narrowcast Server DB2, Teradata,Informatica, UNIX, WindowsNT)