SUMMARY

• 8+ years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools
• 4+ years of extensive experience with design and development of Tableau visualization solutions.
• Certified Tableau Desktop 10 Qualified Associate with extensive experience inTableau Desktop, Tableau Server, Tableau reader in various versions of Tableau (7.x/8.x/9.x) and Vizql,Teradata, SQL and various ETL tools.
• Experience with all the modules of MicroStrategy Product Suite namely MicroStrategy Intelligence Server, Web, Dashboard, Narrowcast Server and Desktop.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.
• Efficient in identifying and analyzing Business requirements from documents and end - user discussions and deliver the data requirements necessary to support DW subject areas.
• Extensive experience on designing database using ER modeling and Normalization
• Experienced in designing richInteractive reports and dashboards integrating various reporting components from multiple sources.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. and other making use of actions, other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects like Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Parameters etc.
• Good experience on LOD expressions Comparative Sales Analysis, Customer Acquisitions, etc.
• Hands on experience in embedding Tableau reports and dashboards on external websites using Java API scripting.
• Good knowledge on Embedded views of Tableau with web applications to integrate reports.
• Good experience in MicroStrategy Reporting - Templates, Filters, Metrics, consolidations, Prompts, custom group, and Datamart optimization of reports.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed ETL Mappings.
• Experience in guiding onshore/offshore development teams to build dashboard applications, developing templates and development framework, design standards and implementation plans.
• Excellent analytical, problem solving, communication and time management skills.

TECHNICAL SKILLS

Analytical Tools: Tableau Desktop/Server, MicroStrategy, SSRS

ETL Tools: DataStage, Informatica, SSIS

Requirements Management: Microsoft Office (Word, PowerPoint Excel)

RDBMS and SQL Tools: Teradata, Oracle, SQL Server, Toad, SQL Assistant, SQL Plus

Code Management Tools: UC4, SVN, SharePoint, Quality Center

Methodologies: Kimball/Inmon, OLAP, Waterfall, Agile

Data Modeling Tools: ERwin, ER Studio, MS Visio

Operating System: Windows 2007, Unix

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

Sr. Tableau Developer

Responsibilities:

• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Use advanced data visualization tools to provide an easy to understand interface for end users to quickly identify key themes within their data.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and SQL Server and performing data blending in reports.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created various types of charts to provide better visualization.
• Stretched Tableau limits to create unconventional Tableau charts such as Grouped Bar Charts, Donut Charts, Bar-in-Bar Charts, Gantt Charts, Bubble Charts, Histograms, Bullets, Heat maps and logical calculations to create groups.
• Embedded Tableau reports/dashboards on to the external web pages.
• Provide innovative solutions, and deliver improved upon methods of data presentation by focusing on the Business need and the Business Value of the solution.
• Looked for opportunities to improve current processes or find efficiencies by applying industry best practices for BI development
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.
• Generated Test Cases for each specification in Requirement Specification Document corresponding to each module.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environment: Tableau (Desktop/Server) 10.x/9.x, Teradata, MS SQL Server, SQL, Teradata SQL Assistant, Java API, Microsoft (Word, Access, Excel, Outlook).

Confidential, Pleasanton, CA

Sr. Tableau Developer

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Created views and dashboards based on requirements and published them to Tableau Server for Business and End User teams to be reviewed.
• Designed and developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
• Served as a liaison between the business and the IT department by conducting weekly calls/meetings with stakeholders, developers, QA Team, UAT Team to document any changes and apply them to Tableau reports as needed.
• Created side by side bar chart comparison of Vendors who were into Retail along with profit revenue generated.
• Worked with DBA to extract API data into SQL Server and connected to the same from Tableau for various reporting requirements.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume of data.
• Used parameters and input controls to give users control over certain values.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle and MS Excel.
• Created Data extracts for better performance of dashboards and accessing data offline.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Created reports using Custom SQL for complex report views.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop/Server) 9.x/8.x, Oracle 11i, Toad, SQL Server, SQL BI Suite (SSIS, SSRS), Java API, SharePoint, MS Visio, Microsoft Office Suite(Word, Excel, PowerPoint).

Confidential - Indianapolis, IN

BI Data Analyst / Tableau Developer

Responsibilities:

• Analyzed various reports, dashboards, scorecards in MicroStrategy and created the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Data collection and leveraging on data manipulation teams for required data.
• Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Dashboard Visualization through Tableau BI application.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.
• Executed and tested required queries and reports before publishing.
• Working extensively using Excel to validate the data and use as the source data files.
• Hands-on development assisting users in creating and modifying worksheets.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.

Environment: Tableau (Desktop, Server),MicroStrategy, Teradata, Teradata SQL Assistant, SQL, PL/SQL, MS Project, MS Office Suite (Word, Excel, PowerPoint).

Confidential, West Chicago, IL

BI Consultant (MicroStrategy, Tableau)

Responsibilities:

• Gathered business requirements from the business users and documented the specifications
• Implemented Star Schema to fit reporting, query and business analysis requirements
• Created Derived metrics, Compound Metrics and Filters, Filter in a metric- for very complex reports
• Involved in creating new Facts, Attributes and Attribute form expressions, Hierarchies as needed in the project
• Created the design document, personalized the reports as per user requirements that included customizing and formatting
• Created Intelligent cubes to reduce the database load and decrease the report execution by using the Cube Services
• Developed Dashboards in various formats; tables, gauges and dials, for business analysis
• Created Advanced Dashboards with panel stacks, complicated grids and graphs, customized widgets both in flash and Interactive modes
• 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
• Assisted with best practices during implementation and integration of Tableau Platform
• Created several base formulas (mathematical expressions) using existing facts in MicroStrategy Agent that can be re-used to build any number of metrics
• Provided various management levels with reports, analysis time series graphs and Bar Graphs using Micro Strategy Web
• Involved in moving the objects between two projects and two different environments by using Object Manager and resolve conflicts between environments by using conflicts resolution window
• Involved in Administration tasks like creating users, assigning privileges, caching, specifying Query Governing Thresholds, and Report optimization
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.

Environment: MicroStrategy 9.x (Desktop, Web, Intelligent Server, Narrowcast Server), Oracle 10g, Tableau 7x, Informatica, SQL Server, SharePoint,.

Confidential, Houston, TX

Data Analyst/MicroStrategy Developer

Responsibilities:

• Gather Business requirements, analyze business rules, merge and consolidate, key business data, explore source systems, Data quality issues, data cleansing of wire line and wireless systems
• Experience in business functionality implementations, developing Data Models, Data Warehouses, and Data Marts from logical models as per specific business requirements.
• Used Hybrid Model concept i.e Combination of STAR schema and SNOW FLAKE schema to reduce the complexity of the data model.
• Extensively used MicroStrategy Report Services to generate Report Documents.
• Designed dynamic flash integrated Dashboards in MicroStrategy Web to assess company’s performance and monitored the overall goals of the business
• Drill maps are used in the project to allow the documents drilling from one level to another both drill up and drill down
• Strong knowledge and understanding of SQL and ability to write SQL queries.
• Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Drill Maps, Templates, Consolidation and Custom Groups) using MicroStrategy Desktop and Architect.
• Used Apply Functions in MicroStrategy like the ApplySimple&ApplyComparison whenever necessary.
• Extensively used VLDB (very Large Database) settings in MicroStrategy to tune the SQL query performance.
• Had a prominent role in creating Advanced Prompts, Metrics, Transformation Metrics and Level Metrics for making complex reports.

Environment: MicroStrategy 8.0.3/8.1.1 (Desktop, MicroStrategy Web, Object manager), DB2, Datastage 7.5.2, ERwin, ClearCase, ClearQuest, Shell Scripting, SQL and Windows 2000 Server/Professional

Confidential

Business Analyst

Responsibilities:

• Involved in requirement analysis and planning of delivering projects using Waterfall model
• Assisted developers and testing team with business cases and scenarios
• Planning and monitoring of project execution along with the senior management.
• Elicited requirements and elaborated with planning sessions to the team.
• Organized the requirements into a proper documentation and maintained development efforts
• Translated and simplified requirements to developers elaborately.
• Requirements management and communication with clients and onsite coordinators for executing projects.
• Prepared demo sessions for the development of projects to clients
• Created weekly status reports for different modules in the projects
• Used SQL, PL/SQL for database related functionality.

Environment: SQL Server, Quality Center, Windows XP, Excel Reports, MS Office Suite (Word, Excel, PowerPoint)