Tableau developer

Ramaswamy email: ************@*****.***

Tableau Developer Ph: 732-***-****

SUMMARY

Senior Tableau Developer with 7+ years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications and the related Database Platforms.

Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.1/8.2 and Tableau 9.

Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.

Strong understanding of project life cycle, SDLC methodologies including RUP, RAD, Waterfall and Agile.

In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.

Expertise in Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.

Excellent analytical, problem solving and Tableau and SQL debugging skills.

Organized Joint Requirement Planning sessions,Interviews and Requirement Elicitation sessions with end-users,clients, Subject Matter Experts and the technology group.

In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.

Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

Experience in using various MS office tools for analyzing, arranging and presenting data.

Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel on various environments.

Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.

Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.

Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Experience in creating and implementing interactive charts, graphs, and other user interface elements.

TECHNICAL SKILLS

Specialties

Data Visualization, Business Intelligence (BI), Software Management, Data Collection.

BI Tools

Tableau 6.0/7.0/8.1/8.2/9, Tableau Desktop, Tableau Server, Cognos, Crystal Reports, Qlikview

Relational Databases

MS SQL Server 2005/2008/2012/2014, Oracle 7/8/8i/9i/10g/11g/12c, MS Access.

Tools and Packages

SQL Server Management studio, Toad, Microsoft Visual Studio

Languages

SQL, PL/SQL, HTML, XML

office suite

MS PowerPoint, MS Excel, MS Word, MS Visio, Star Office, Open Office

Operating Systems

Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7/8

EDUCATION

Bachelor of Engineering, Manipal Institute of Technology, Karnataka, India.

EXPERIENCE

Sr. Tableau Report Developer Jul 2014 – Present

NCP Solutions, Birmingham, AL

NCP solutions, is a leading provider for best-in-class integrated payment solutions, marketing services, printing and electronic services. It provides product and services to nearly 12,500 financial and commercial clients. Involved in Tableau Server administration, maintenance, Design and development of the Tableau Dashboard.

Responsibilities:

Involved in translating the business questions and business requirements to actual and final dashboard technical requirements

Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time

Building the customized and interactive dashboards using multiple data sources

Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in

Tableau.

Gathered user requirements, analyzed and designed software solution based on the requirements.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created worksheets and dashboards by using custom queries and multiple tables.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Effectively used data blending feature in tableau.

Defined best practices for Tableau report development.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Developing Standard and Create reports using Tableau Desktop.

Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.

Creating DB views for the reporting purpose.

Preparing Report Mapping Documents as per Specifications.

Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.

Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype 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.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

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.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Environment: BI Applications, Tableau 8.1/8.2/9.0, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access.

Senior Tableau Developer

ACI Worldwide, Austin, TX Apr 2013 – Jun 2014

ACI Worldwide powers electronic payments for financial institutions and retailers around the world. Project involves a combination of analyzing sales data, product category, knowledge of compensation practices and operational expenses. Published Dashboards on Tableau Server for the user community to access through Web Portal.

Responsibilities:

Developed various dashboards illustrating data visualizations using Tableau Desktop

Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.

Defined best practices for Tableau report development.

Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.

Created drill through reports in dashboard.

Involved in creating data blending in case of merging different data sources.

Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.

Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

Worked on Datazen and had a good knowledge in creating the dashboard which best suites the requirement.

Understanding of relational database structures, theories, principles, and practices.

Monitored Application Server and Tableau Data server activity to track performance and system availability

The ability to interact professionally with a diverse group, including executives, managers, and LOB.

Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2008.

Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated

Involved in license management SLA's with Tableau support.

Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.

Environment: Tableau Desktop 8.0/8.1, Tableau server, Oracle SQL developer, SQL Server 2008/2012, Oracle 10g/11g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007

Tableau Developer

Covance, Princeton, NJ Jan 2012 – Apr 2013

Covance, with headquarters in Princeton, New Jersey, is one of the world’s largest and most comprehensive drug development services companies, with annual revenues greater than $2 billion, employees in more than 60 countries, and more than 11,000 employees worldwide. The project was to create and analyze reports as well as dashboards using Tableau.

Responsibilities:

Liaison for project managers, managers, directors, and stakeholders.

Requirements gathering and analysis including data analysis, gap analysis (AS-IS to TO-BE), and documentation for end users.

Conducted gap analysis for re-engineering, and upgrading the current system where ever necessary.

Developed, derived and clarified functional specifications and Use cases.

Analysis of Business requirements and site specifications to create Business Requirement Document (BRD) and Design Document (Functional and Technical).

Eliciting and translating business and/or technical needs in to relevant documentation for assigned initiatives/projects.

Designed the conceptual and business process models.

Implementation of new systems including the integration of the new system with existing systems.

Verifying installed systems to ensure that they adequately meet user requirements.

Physical design of data record data files and databases.

Developed mappings and workflows in Informatica to extract data files used as source for various Tableau reports.

Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Involved in writing Test Cases, procedures, reports and approval of software release.

Monitoring the project during Development phase and involved in User acceptance testing (UAT) once the change requests are released from system testing.

Designed and Developed Complex Active reports and Dashboards with different data visualizations using Tableau desktop on customer data.

Developed Technical requirements, design requirements and user acceptance documentation by placing Screen shots of actual Report and tested report in documentation.

Deployment of defect free code while managing the timeline set for the project.

Environment: Tableau 7.0/8.0, Teradata, Oracle 11g, SQL Server 2008, TOAD, PLSQL Developer, SQL Developer, SAS, Informatica, MS VISIO, Microsoft (Word, Access, Excel, Outlook)

SQL Server BI Developer

Medfin India Pvt Ltd, India Jul 2009 – Dec 2011

MedFin India is a leading provider of Healthcare Business Process Outsourcing services to the Healthcare Providers. Project involved creation of customized reports that carries all the specific information per requirements along with assistance in analysis and data interpretations anytime for the client's convenience.

Responsibilities:

Developed the project using agile methodologies in the team and take initiative to break down requirements.

Developed packages in SSIS platform by using various tasks and transformations and configuring as per requirements.

Involved in requirement gathering and analysis of source systems, database architecture of the HSN database

Managing periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Created databases and database objects like tables, stored procedures, views, triggers, rules, defaults, user defined data types and functions.

Created design of initial package, keeping in view and implementing appropriate SSIS controls.

Created drill-through reports, parameterized reports and linked reports using SSRS 2005

Generated reports in the form of tabular, matrix and chart forms.

Rendered the reports in the form PDF, Excel, .CSV and XML formats

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server BI (SSIS, SSRS, SSAS), TSQL, TFS, XML and Windows Server 2003

SQL Server BI Developer

ICICI Bank, India May 2008 – Jun 2009

ICICI Bank is a multinational banking and financial services company, offers a wide range of banking products and financial services for corporate and retail customers through a variety of delivery channels and specialised subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management. This Project involved in creating a data mart for fixed deposits, savings bank and other loans modules reporting system using Microsoft SQL server 2008/2005, SQL server Integration services (ETL-SSIS packages), SQL server analysis services (SSAS cubes), SQL server reporting services (SSRS reports) Operational\BI(analysis). And the data mart is used to integrate data from day-to-day transactions to track and analyse the transactions from an actual and forecasting perspective. This data mart also provides their field services team with daily reports on different Transactions -related metrics so they can continually refine their services efforts.

Responsibilities:

Team member of the BI module and involved in analysis of business requirements template, decomposition matrix, dimensionality modelling and ETL strategy.

Utilizing the Kimball- Star/Snowflake schemas and slowly changing dimensions.

Worked on Microsoft SQL Server 2005 Tools-SQL Server Integration services (SSIS), SQL Server analysis services (SSAS) and SQL Server reporting services (SSRS).

Responsible for extracting the data from different source feeds like Flat file, XML, OLE DB, and Excel.

Created packages by using sources, destinations and transformations using SSIS designer.

Connected to different types of sources to extract data and destinations to load data using Connection manager.

Defined the data Sources, data Source views, dimensions, cubes within the Business Intelligence Development Studio (BIDS) using SSAS.

Administration and development of data warehouse\data marts and OLAP cubes

Used Business Intelligence Development Studio, Management Studio for developing SSIS, SSAS, and SSRS.

Involved in the creation of SSRS reports using with\without wizards.

Performed parameterized reports, reports bursting, and scorecards.

Involved in performing drill down the data, calculations, sort the data, add groups, subtotals, and colour code the business data exceptions.

Troubleshooting ETL, OLAP analysis and reporting process failures.

Environment: MS SQL Server 2008/2005, MySQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).

Contact this candidate