SUMMARY

• 11+ years of IT experience in Analysis, Design, Development, Testing and Implementation of various applications in OLTP, Client/Server OLAP environment using BI tools
• Extensive experience with design and development of Tableau visualization solutions.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau reader in various versions ofTableau (7.x/8.x/9.x) and VizQL, SQL, PL SQL and UNIX shell scripting.
• Experience in business process analysis/modeling, business requirements, and developing High level Designs and Prototypes for Business applications.
• Support and maintain Project Data Models at multiple levels of detail and functionality (conceptual, logical, physical and subject - level) in developing star schema and snowflake schema.
• 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.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• Experience in aggregating data and configuring reports from different data sources using data blending.
• Proficient in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Experienced in working with data modelers to translate business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Good expertise in building dashboards and stories based on the available data points.
• Expertise in Agile Scrum Methodology to implement project life cycles of reports design and development
• Good knowledge on Embedded views of Tableau with web applications to integrate reports
• 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.
• Excellent analytical, problem solving, communication and time management skills.
• Received applause awards for the contribution to the project and team terrific awards for playing my part as an effective team member during my tenure in the projects.

TECHNICAL SKILLS

BI Tools: Tableau7.x, 8.x, Business Intelligence consumer Services, (BICS), Web Intelligence 4.0, Dashboard designer Query Designer, MS Office (Excel, Access etc.)

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated Services

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Oracle 9i, SQL Server, Sybase, MS Access, SQL Server

Document management: HP Quality center 10.0

Defect management tool: ERwin, ER Studio, MS Visio

Languages: C, C++, HTML, SQL, PL/SQL, XML

Data modeling: ERwin, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Sr.Tableau Developer/ Data Analyst

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• 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.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Used geographic view which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Worked on drill through reports by creating HTML references.
• Created various actions in database 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.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same onTableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• 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.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Actively tracking schedule, clear and crisp communications with key resources, stake holders and SMEs to keep everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau(Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, Share Point, Agile-Scrum, UNIX, MS VISIO, Microsoft Office Suite.

Confidential - Taylor, TX

Sr.Tableau Developer

Responsibilities:

• Gathered business requirements from end users, analyzed and documented the same for various reporting needs.
• Analyze complex data from various data repositories and become familiar with user base locations.
• 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.
• Created line charts to display trends over a period of time and tied it with bar charts to show revenue growth based on users upgrading to additional features of the mobile app additionally adding filter to choose between business and personal users.
• 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.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• 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 on Tableau Server for weekly and monthly increments of the user counts.
• Integrated dashboards with live Connection in Microsoft PowerPoint using Live Web add on.
• Blended data from multiple databases into one report by selecting primary key's from each database for 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.
• Executed and tested required queries and reports before publishing.
• 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, MS SQL Server, SQL BI Suite (SSIS, SSRS), SharePoint, MS Visio, Microsoft Office Suite( Word, Excel, PowerPoint).

Confidential - Bloomsburg, PA

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.
• Involved in troubleshooting and performance tuning of reports and resolving issues within TableauServer and Reports.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Use MS Excel, Word, Access, and Power Point to process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Published views and dashboards in Tableau Server for auditor review.

Environment: TableauServer 7,TableauDesktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, Oracle 11g, Toad, MS Office, Visual Studio 2010.

Confidential - Greenwood Village, CO

Tableau Developer/ Data Analyst

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel, Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive, parametrized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Validated the reports before publish reports to Tableau server, troubleshoot Tableau reports, dashboards, etc
• Involved in troubleshooting and performance tuning of reports and resolving issues within TableauServer and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business.

Environment: Tableau(Desktop /Server), Oracle, SQL Server, DB2, SSIS, SQL, Toad, UNIX, MS VISIO, Control-M, Erwin, MS Office Suite (Word, Excel, PowerPoint.

Confidential - New York City, NY

Tableau Developer/Admin

Responsibilities:

• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams and created Technical Design Document from the functional specification documents.
• Utilized Tableau Analytics to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value.
• Designed a Tableau Architecture and installed Tableau on Cloud based on number of Business Users.
• Generated visuals in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Design and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau and provided these visuals in Tableau online and Reader to Stake Holders.
• Generated context filters and used performance actions while handling huge volume of data.
• Created multiple Adhoc dashboards in Tableau in order to represent the status like strength and weakness etc. for the business users at a glance.
• Created dashboards for financial department such as accounts payable, accounts receivables, Cash management and Asset management for Finance Team.
• Developed dashboard related to Asset management department for asset category and subcategory, depreciation and asset retirement.
• Worked on Python scripts to convert CSV files to flat files to ingest the data for ETL.
• Worked on Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle).
• Created tables, views, materialized views with indexes in SQL Server to tune the performance.
• Installed and Monitored of Tableau Server (Dev and Prod) on AWS Environment.
• Installed the Tableau Server on the EC2 instances and configure the instances as primary and worker servers.
• Implemented AWS security features in Tableau Server to enable a single report or dashboard to securely serve the needs of a broad and diverse user base, including both internal and external users
• Created incremental refreshes for data sources on Tableau server.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups ofTableau repository.
• Created report schedules, data connections, projects, groups in Tableau server.
• Administered users, user groups, and scheduled instances for reports in Tableau.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Used Java Script API to customize the views, selects, filters, date and time.

Environment: Tableau9.0,Tableauv8.2 (TableauDesktop,TableauReader,TableauOnline andTableauServer), Oracle12g (SQL, PL/SQL), SQL Server 2008, Python 2.7.

Confidential - Plano, TX

Tableau Developer

Responsibilities:

• Installed enterprise version Tableau server in a clustered environment, maintaining high availability of the server and supporting 2000+ users
• Strong in report development, server side management, deployments, upgrades, capacity expansion planning for Tableau projects.
• Utilized JavaScript API to integrate Tableau visualizations with web applications.
• Administered Tableau server for publishing workbooks and maintaining security, groups & backups.
• Worked closely with business users migrating workbooks from one environment to another and closely worked with them provided them ways to improve performance and recommended Tableausuggested ways.
• Created reports using Teradata, Oracle and SQL.
• Created dashboard using parameters, sets, groups and calculations and drill down and drill up in worksheets
• Using Tableau Desktop created Interactive reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within TableauServer and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: TableauDesktop 8.1.6/8.2 /9.0 , TableauServer, Oracle SQL Server, Teradata, MS Access, Windows Server 2008 R2, MS Office Suite, JavaScript.

Confidential

BI Consultant

Responsibilities:

• To develop custom reports for all Clinical phases.
• Created complex filters using parameters, query related items.
• Handled Complex Queries as separate Query Subjects.
• Updated various database changes into the Framework manger model.
• To work with Sales and Distribution Team to develop better client demonstrations.
• To Design process functionalities for Quarterly audits.
• To design Syndicated Data reports for internal drug intelligence database.
• Delivered Software functionalities for Global Data Integrated Platform.
• Collecting data from various journals and giving meaning to the data by analyzing and structuring.
• Created reports Using Quick table calculations and business calculations like Year over Year growth, Running Total, Rank etc.
• Dealing with Metadata and creating, generating reports quarterly wise, validating the data with sales team.
• Contacting the sales and finance team working on managing metadata for checking routine management tasks.
• Sending the visualized data to clients as an overview of our company products.
• Collecting basic information of Principal Investigators, doing research of the data collected and inserting in a tool.
• To work in tandem with the Sales and Distribution teams to develop better client demonstrations and ensure better client handling.

Environment: MS Excel, Oracle 9i, Windows 2003, UNIX, Linux.