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/10.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 DataWarehouse 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 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, Oaks, PA

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Worked with end users, internal management and team members to understand and clarify reporting requirements / needs.
• 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.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau.
• Creating customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle 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 several 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.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• 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.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• 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/8.x, Cognos 10.2,Teradata 15,Oracle 12c/11g, Hive, Hbase, BigQuery, Agile-Scrum, Java API, Putty,UC4, Microsoft Office.

Confidential, Fort Worth, TX

Sr. Tableau Developer/ Sr. Data Analyst

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.
• Blendeddata frommultiple databases into one report by selecting primary keysfrom each databasefor data validation.
• 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/Online) 8.x, Oracle 11i, Toad, SQL Server, SQL BI Suite (SSIS, SSRS), Java API, SharePoint, MS Visio, Teradata, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential - Woonsocket, RI

Sr. Tableau Developer/Sr. Data Analyst

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Built analytical models to illustrate the financial and service impact of proposed enhancements - including modifications to supply chain processes, ordering strategies, replenishment calculation changes, and operational improvement strategies.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• 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.
• 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.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Implemented best practices and standards in developing Tableau reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on the backend database development which was the source data for the tableau.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau server, allowing end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: Tableau 8.x/7.0, Tableau Server 8.0/7.0, Oracle 10g,SQL BI Suite (SSIS, SSRS), Teradata, Toad, SQL, Share Point, Agile-Scrum, Rally, JavaScript.

Confidential, Deerfield, IL

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Partnered with peers internal and external to the team to assess and recommend opportunities to derive additional Business Value out of existing Data Marts.
• Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Identify key business metrics measurements and develop methods to represent data in support of the measurements.
• Provide guidance and insight on data visualization and dashboard design best practices in Tableau
• Created different views in workbook to visually analyze data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• 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
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Maintain thorough and rigorous documentation related to all ETL changes, Metadata, database server configuration, operation, and database change management.

Environment: Tableau (Desktop/Server) 8.x, Teradata, SQL Server, Oracle,Toad, Teradata SQL Assistant, JavaScript API, Putty, Quality Center, Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Memphis, TN

Sr. Data Analyst/ MicroStrategy Developer

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
• Participated in review, sign-off and communication of all changes or modifications to reports.
• Analyzed and developed partitioning and indexing strategies for performance improvement.
• Worked on Change control, attending the CAB meetings and laying out the important changes to the organization.
• Worked with end users to improve the new reports and make additional changes as required.
• Prepared personalized reports to end-users by including page-by and thresholds.
• Validated end user report requests using SQL and MicroStrategy tools.
• Configure reports for end users in Desktop, MicroStrategyWeb, and Narrowcast Server.
• Create Dashboards and Documents using Flex, Flash and Widgets.
• Created the Data mart reports based on specific requirements and running the existing Data mart reports for weekly and monthly loads.
• Involved in Developing Reports by using Free Hand SQL Queries in MicroStrategy Desktop.
• Creation of Intelligent cubes and sharing to reduce the database load and decreasing the report execution time by using the cube services.
• Created ad-hocreports by drilling up, down, within and across Hierarchies.
• Designed Components, Templates, Filters to generate Reports in grid and graph mode.
• Autopromptfilter feature gave end-user a choice of different filtering criteria each time they run the report.
• Created transformations (Table Based and Expression Based) for ITD (Inception to date), YTD (Year to date), QTD (Quarter to date), MTD (Month to date) and WTD (Week to date) analysis.
• Involved in creation of Data mart Reports, Partition Mappings and Aggregate tables to improve performance of reports.
• Involved in optimization of code and tuning queries for performance.
• Applied Teradata Application Utilities and Teradata SQL. Also Fine-tuned SQL using Teradata.

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

Confidential, Commerce, CA

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

Systems Analyst

Responsibilities:

• Analyzed business requirements from BRD document and worked closely with end Users to get exact business requirements.
• Designed and Developed Interfaces using Interface Manager and creating procedures, functions, packages.
• 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 users.
• 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)