Sandeep

ac4yq7@r.postjobfree.com

860-***-****

PROFESSIONAL SUMMARY:

5+ years of experience in Information Technology in Tableau Desktop, Tableau Server, BI Publisher, requirement gathering, Analysis and development of software applications.

Has good experience working as a developer, 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, Bars, Lines and Pies, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within the Tableau Server.

Created and maintained various reporting dashboards to consolidate multiple views for internal and external purposes.

Extensive knowledge in Dimensional data modeling, Star Schema, Snow-Flake Schema, Normalization, Physical and Logical modeling.

Created Tableau Data Extracts for making visualizations perform better and improve the dashboard.

Utilized all Tableau tools including Tableau Desktop, Tableau Public, and Tableau Reader.

Experienced in creating Oracle BI Publisher Report Templates and reports using BI Publisher Desktop Edition.

Wrote SQL scripts and queries to extract data from various data sources into the BI tool, Visualization tool, and Excel reports.

Experienced with creating database triggers, views, packages and stored procedure in T-SQL.

Worked as SSRS Reports Developer and SQL Server Developer in support of Service Management System.

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

Developed various operational Drill-through and Drill-down reports using SSRS.

Wrote SQL scripts and queries to extract data from various data sources into the SSRS, Visualization tool, and Excel reports.

Involved in all stages of the software development cycle gathering requirements, design, specification, coding, debugging, testing (test plan and test execution), integration and system testing, documentation and maintenance of the programs.

PROFESSIONAL EXPERIENCE:

Client: Adaptive Insights, Palo Alto,CA Nov 2016– Till Date

Role: Tableau Developer

Responsibilities:

Analyzed and understood the process flow to provide solution for the proposed requirement change.

Identified the area of the code where the fix needs to be done and prepared necessary technical development documents.

Provided fix for a dataflow which was successfully implemented and accepted by the business.

Designed standardized DataMart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL developers, DBAs, Data Modelers to implement the same in Development, Test and Production environment.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server, creating new schedules and checking the tasks daily on the server.

Developed few sample dashboards using Tableau to present the data with excellent visualization and got the approval from users.

Used Tableau to create visual interactive dashboards using calculations, parameters and workbooks for decision making.

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.

Scheduled Cron Jobs and had extensive experience in writing, editing and troubleshooting various Refresh Cron Jobs using PUTTY.

Writing various queries to pull the data required to verify the Metrics calculations form backend.

Successfully extracted data and completed data conversion for legacy systems

Performed rigorous unit testing for the code change in development and stage environments.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Given training/demos to users on Tableau Desktop for development.

Included finalized model from data mining team to OLAP cubes created by real-time data to test the efficiency of the model.

Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

Created Data Connections, Published on Tableau Server for usage with Operational or Monitoring Dashboards.

Granting Permission to User's and maintaining the User List and updated Server Architecture for scheduling Tasks.

Environment: Oracle 11g Ex, Toad 12.1, PUTTY, Windows 7, Tableau Desktop 10.4, Tableau Server 10.4, Informatica 9.6, Java Script API, MS Office Suite (Word, Excel, PowerPoint)

Client: World Emblem Atlanta GA May 2015 – Oct 2016

Role:Tableau Developer

Responsibilities:

Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development.

Experience with the technologies like, Hadoop, SQL in writing custom SQL and working with large data sets and optimize performance within Tableau.

Responsible for creating reporting data model as per the requirements. Experienced in constructing UX (User Experience) frameworks for desktop and mobile platforms.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse

Development assisting users in creating and modifying worksheets and data visualization dashboards.

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

Expert in creating a dual-axis bar chart with multiple measures.

Extensively involved in creating graphs by using measures and dimensions data from various databases.

Advanced Tableau experience from dashboard design and development. Expertized with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions

Blended data from multiple databases into one report from each database for data validation.

Preparing Dashboards using calculations, parameters in Tableau.

Installed and configured Tableau desktop 9.0 along with silent mode features and migrated Tableau reports from 8.3 to 9.0 Version.

Worked on several projects in parallel and Build the Dashboards in Agile Approach and utilized offshore team for the Dashboard build.

Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement.

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.

Created Relationships, actions, calculated fields, sorting, groupings, live connections, in-memory in both tableau and Excel.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Worked with the customers to resolve various issues associated with the reports.

Environment: Tableau Server, Tableau Desktop, MYSQL Server, Informatica 9.1, SSIS, Excel, TSQL, UNIX, Hadoop, SQL, Visual Studio

Client: Siemas Healthcare Oct 2012 – Apr 2015

Role: BI Developer

Responsibilities:

Worked as BI developer responsible for developing and maintaining Tableau dashboards.

Integrated Business Objects and SAP Business Intelligence as data sources for Tableau.

Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.

Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.

Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.

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

Reviewed Business requirements and prepared the dashboards as per the requirements

Extracted data from different sources connecting them and used the same to create dashboard

Modified the existing dashboard as per the user requirements Used Tableau Desktop for creating different interactive views and dashboards.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Created various types of charts to provide better visualization.

Used Tableau Desktop created Interactive reporting dashboards by combining multiple views.

Wrote UNIX and SQL scripts for pre & post session processes and to automate daily loads.

Performed unit test/integrated testing scenarios which were used to obtain the UAT's.

Developed narratives that describe the technical process in business terms.

Communicated on daily basis with stakeholders and clients on Tableau related activities.

Environment: Tableau 8.0, 7.0 Sap 7, Business Objects 4.0, Oracle 10g, Crystal Reports 2008,

MS Office Suite

Contact this candidate