PROFESSIONAL SUMMARY:

• Over 9 years of experience in Designing, Analysis, Development, Implementation and Management in Business Intelligence data visualization tools with specialization in Tableau
• Experience in working with Tableau Desktop and Tableau Server in various versions of Tableau 2018.1, 10.5/10.4/10.0/9.2/9.0/8.2/8.0 as a developer and administrator.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 9.0 to 10.0 and Tableau 10.0 to 2018.1
• Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing and Support of rich Interactive Dashboards and workbooks using Tableau Desktop.
• Experience in various Phases of Software Development Life Cycle (SDLC) i.e. Analysis, Design, Development, Implementation, Testing and Distributed applications.
• Apply design patterns to develop BI solutions for delivery on web and mobile devices such as tablets and smartphones.
• Experience in Performance Tuning of reports within Tableau Server and Tableau Dashboards.
• 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 Dashboard Action, Data Source and Context Filters according to the end user requirement.
• Experience with R Integration in Tableau to identify patterns, build practical models for a deep statistical analysis and accomplish forecasting of the statistical models.
• Conducted analysis, created Use Cases, Work Flows, screen shots and PowerPoint presentations of Tableau in the Client Web Applications.
• Expertise in designing and creating various analytical reports like Performance Dashboards, Score cards and Metrics to help users to identify critical KPIs and facilitate planning in all functional areas including Order Management, Finance and Planning, Process Management, Sales/Marketing and Resource management.
• Experience in writing SQL, T - SQL/PL SQL (Stored procedures, functions and triggers) scripts for reporting, data analysis and ETL validations and to support Ad-hoc business requests.
• Excellent communication skills, with strong analytical, troubleshooting and problem solving abilities.
• Good understanding of business environment, excellent communication skill with strong analytical, trouble shooting and problem solving abilities.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop, Tableau Server, MS Excel, SSRS

Databases: Oracle, MS SQL Server, MS Access, Teradata

Languages: T-SQL, PL/SQL, HTML, CSS, Java Script

Applications: MS Office Suite

Methodology: Agile Methodology, Scrum Model

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

Tableau Developer/Analyst

Responsibilities:

• End to end management of retrade process across technical teams.
• Acquired data from TNT data sources and maintained databases using SQL Server and Teradata.
• Analysed and consolidated the integration procedure of enormous TNT customer data into Confidential system using stored procedures, functions and packages.
• Validated data to ensure the quality, validity and accuracy of content using SQL and excel.
• Extract, interpret and analyze data to identify key metrics and transform raw data into meaningful, actionable information supported by visuals.
• Involved in creating database objects like tables, views, procedures and functions using SQL to provide definition, structure and to maintain data efficiently.
• Worked closely with the Business Analyst to develop the visual analytics for the given data and make it available online and on mobile products.
• Created detailed summary report and Dashboard using KPI's like Trend Lines, Statistics, and Log Axes. Groups, hierarchies and Sets
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions - filter, highlight and URL.
• Created detailed summary report and Dashboard using KPI's like Trend Lines, Statistics, and Log Axes. Groups, hierarchies and Sets.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts, Bar Charts and Density Chart.
• Created data quality reporting inclusive of account matching and reconciliation between systems.
• Identification of new accounts versus internal linked accounts between systems negotiation.
• Weekly retrade activity reporting to follow the course of process activities to assure account linkage is done in a timely manner.

Environment: Tableau Desktop 9/10, Tableau Server 9/10, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Oracle, SQL Server, Oracle, Teradata, MS Office.

Confidential, Pittsburg, PA

Tableau Developer

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Analyzed the source systems and created Business Requirement Document (BRD)
• Deep experience with the design and development of Tableau visualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Configured different data sources using Tableau Desktop.
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Enabled Tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop 8/9, Tableau Server 8/9, Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Oracle, SQL Server, Teradata, MS Office.

Confidential, Edina, MN

Tableau Developer

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Used Data Blending, groups, combine fields, calculated fields, aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the Tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to the Tableau server.
• Created extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

Environment: Tableau Desktop 7/8, Tableau Server 7/8, SQL Server, MS Excel/Access

Confidential

SQL Developer

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from external sources.
• Extracting data from the Customer Interaction Center and creating a comma separated file (flat file) by writing SQL queries
• Coded complex SQL queries to retrieve data from the database depending on the requirement.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.
• Creating and working with GTT (Global Temporary Table).
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Performed exception handling for the procedures created
• Experience in resolving anomalies in the production database
• Gathering business requirements and designing database.
• Used SQL to build ETL process, which consolidates data from different MIS server (Oracle, SQL Server, and Teradata) and data files (Excel, txt).
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Identified and recommended data sources, mined data from multiple, cross business sources to verify business rules.
• Provided data support on campaign list selection and fulfillment file/list generation.
• Translated complex marketing needs into technical data analysis and matrix reporting requirements.

Environment: Windows 2012 Server, MS SQL Server 2008, SSRS, Teradata, Excel

Confidential

SQL Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows server 2003 server.
• Worked on client/server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Support and maintained database clustering.
• Configuring, tuning and optimizing SQL Server 2000.
• Administer tasks like managing users, roles and permissions.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS packages for data import/export and scheduling jobs for backups.
• Creating database maintenance plan for performance of SQL Server, which covers database integrity checks, update database statistics and re-indexing.
• Performed level scripting, fixing of codes and software enhancement process. provided motivation and positive work environment and ensured accurate on time completion.

Environment: Windows 2003 Server, MS SQL Server 2005, SSRS.