SUMMARY:

• More Than 7+ Years of IT experience in all aspects of Business Intelligence (BI) leveraging Tableau/Cognos applications with a strong background in Database development and Expertise in Full Life Cycle Development including Planning, Analysis, Design, Implementation and Maintenance using Tableau.
• 4+ years of Experience in Tableau Desktop/Server/Tableau Public/Tableau Online as developer/Analyst
• Extensive knowledge of Software Development Life Cycle (SDLC), Methodologies and Test Processes.
• Proficient in V - Model, Agile and Waterfall methodologies. experience in Tableau in creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.,
• Design and Develop Strategic/Proof of Concept (POC) dashboards using Tableau.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Expertise in using complex multiple data sources such as SQL, Flat Files, Excel and Access, Oracle, SQL Server, Teradata for designing and modeling of Tableau application.
• Experience with Tableau objects including multiple charts types, Trends, Pivoting, custom requests for Excel
• Experience in creating customized reports, filters and charts in Tableau.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Preparing Dashboards using calculations, parameters in Tableau
• Experienced and proficient in leading BI analytical platforms like Big Data management.
• Extensive knowledge in various reporting objects like Attributes, Hierarchies, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Implemented Binning & Blending concepts in my Tableau Reports
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPIs) for the top management.
• Experience in using Tableau functions (Logical, Number, String, Type Conversions, and Table Calculation) when creating the calculated fields.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Produced attractive visuals/dashboards to convey the Tableau story inside the data.
• Experience in working with Tableau development using agile Scrum methodology tuning by analyzing and comparing the turnaround times between SQL and Tableau
• Created test plans, test objectives, test strategies and test cases in the QA testing phase.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Extensively involved in Demos, Presentations, Meetings and Interaction with Senior Management
• Outstanding analytical, interpersonal, organizational, communication and problem-solving skills. Extensive experience working with senior management and client relations.

TECHNICAL SKILLS:

Reporting Package: Tableau Suite of Tools 9.x,8.1, 8.0. 7, 6, 5.1 which includes Desktop, Server, online and Public and Administration of Tableau Server, Cognos 10 Report Studio, Framework Manager, Transformer, Administration, Qlikview, Big Data management

Data Modeling: Erwin, Visio, IBM Rational Rose UML

Computer Application: MS-Word, MS-Excel, MS-Access, MS- Power Point

Databases: Oracle, SQL Server, DB2, Teradata

Operating Systems: Windows, Linux

Languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Tustin, CA

Sr. Tableau Developer/Admin

Responsibilities:

• Managing overall operations across reporting team and also work as individual contributor.
• Installation of Tableau Server on Single Server as well on the distribution environment.
• Provided the architectural design of the tableau server
• Installed Primary server and 3 Worker server in Production to improve the performance and scalability of the system.
• Configured Tableau server with Active Directory as the Authentication Source.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Create Groups and assigned users to the Groups based on the business needs.
• Create Extracts in Tableau Desktop and published to Tableau server.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Scheduled and maintained the data extracts (.tde), Content Extracts and Subscriptions on Tableau Server.
• Create the Data Source Connection (.tds) in Tableau Desktop and Published to the Server.
• Created sites on Tableau server and assigned the security permission to workbooks, Dashboards.
• Scheduled Data extracts (.tde) on the server and maintained Data source Connections .
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating new schedules and checking the tasks daily on the server.
• Created Users, Groups, and Projects, assigned the security based on the business use cases.
• Designed, developed, and managed reporting and Tableau Business Intelligence solutions to meet the business needs.
• Worked Closely with Clients and Business Users to analyze and understand business requirements and Participated in requirements gathering meetings / Sessions .
• Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes .
• Used Sheet filters to produce multiple chart types in a single view .
• Used calculated fields extensively for different logics for Trend, Extended price calculation s for the different cost types.
• Defined relationships, created actions, filters, parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel.
• Convert business requirements into story-telling viz by developing views and dashboards in Tableau Desktop and publish them to Tableau Server
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights .
• Developed several worksheets filled with Bar, Line, Pie, Maps Charts and Highlight Tables for rich visualizations and analyzing of the data.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to new plans by developing Area Maps to show details on which states were upgraded the most using Forecasting functionality
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created visualization for logistics calculation and department spend analysis.
• Documented tool to perform "chunk uploads' of big data .
• Experience in analyzing the data with Big Data.
• 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.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Involved in Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platform like web portals.

Environment: Tableau Desktop 9.0/8.0, Tableau server/Administrator, Big Data, SQL developer, Erwin r 7.1, Oracle 10g, DB2, Share-Point, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Confidential, Oklahoma City, OK

Tableau Developer

Responsibilities:

• Involved in the Requirements gathering, analyzing, and documenting business requirements and data specifications .
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Implement infographics and Dash boarding for data visualization .
• Interact professionally with diverse group of professionals in the organization including managers and executives .
• Experience in standardizing Tableau for shared service deployment.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Designed a STAR schema data model for the detailed data marts and Plan data marts involving confirmed dimensions.
• Conduct data model reviews with project team members.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement
• Created/Developed reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development .
• Developed several Viz’s using Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps for analyzing the data
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Used Advanced Excel analytical functions, e.g., Pivot tables, VLookUp, HLookUp, MATCH, INDEX ; tabulating information using multiple criteria such as, COUNTIFs, SUMIF, AVERAGEIF functions.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards
• Experience in converting OBIEE content into Tableau BI content.
• Experience in providing Tableau server and tableau desktop training.
• Experience with Teradata.
• Experienced with trouble shoot of Teradata connection.
• Testedreportsanduploadedtableaudashboardsontoserverandprovidedproductionsupportfortableau users.
• Coordinated with Development Team & Deliverables and working on high priority issues.
• Organized and conducted weekly status meeting with the IT-BI team and the end user.
• Ratios using key performance indicators, Financial highlights over the years.

Environment: Tableau server/Administrator, Tableau Desktop v6/v7, Windows Server Standard R2, Erwin 7, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

Confidential, Cedar Rapids, IOWA

Tableau Developer

Responsibilities:

• Responsible for Requirements Gathering, Data modeling and Tableau Application development.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Installation, maintenance and administration of Tableau Servers.
• Experience in Marks, Publisher and Security.
• Experience with creating Worksheets, Dash boarding and info graphics.
• Working with Multiple data Connections .
• Used Snow flake and Star Schema Designs for data modeling.
• Experience with troubleshooting.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Developed different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved in Custom Geocoding.
• Expertise in Tableau Analysis.
• Experience in BI interactive Dashboards and Tableau Publisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS.

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Interacted with Business users to identify key dimensions and measures for business performance.
• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Developed normalized Logical to design OLTP system for insurance applications.
• Designed a STAR schema data model for the detailed data marts and Plan data marts involving confirmed dimensions.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each databases.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly

Environment: Tableau 6, Cognos 8.2, Erwin, Oracle, Excel, CSVs, MS Access

Confidential

Cognos Consultant

Responsibilities:

• Created Multiple Reports with Cognos 8.1and Power Play Client.
• Created LIST, Group and Cross tab reports with Drill Through functionality
• Created business Mix and Reports for Comparison
• Created Multi-Dimensional Cubes using Power Play Transformer for multidimensional (IQD) reports.
• Drill Down and Drill Through functionalities were used in the cubes and reports
• Data retrieval, Multidimensional analysis, Power Play structure. Reporter Operations such as Sum and Average, Intersection, Exception Highlighting, Sorting, Ranking etc.
• Developed solution models for Ad-hoc reports.
• Involved in optimizing power Cubes.
• Outstanding Onsite support.

Environment: Cognos 8.1, Oracle 8i, Windows 2000, Cognos Transformer