SUMMARY

• Around 7 years of Experience in Information technology and a good professional experience in Business requirements gathering, business intelligence, development, Testing, documentation, coding, product design, good management skills.
• Capable of understanding projects in different levels and business Intelligence implementation and maintenance, Data warehousing, good in web application development.
• Professional experience on Tableau Desktop, Reader and Server. (Tableau versions 7 / 8 / 9/10)
• Analyzing and acquire experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.
• Define specifications, design, and build of Tableau desktop reports and dashboards.
• Installation setup, performance tuning, user management and other administration of Tableau Server.
• Professional expert in Data Visualization development using tableau to creating complex, intuitive and dashboards.
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using Tableau’s Advanced Capabilities.
• Implemented Data blending on multiple data sources and generated interactive dashboards.
• Used Performance monitoring tool of tableau desktop to analyze teh performance of data heavy dashboards and implemented teh best practices to improve teh end user experience.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Professional expert in roles such as BI End - to-End and solution implantation expert in data warehouse, BI KPIs modeling.
• Expert in designing customized interactive dashboards in tableau using marks, Action, filters, parameters, Security Concepts, calculations, and relationships.
• Expert in RDBMS concepts and constructs along wif Database objects creation such as tables, Index’s, stored procedures, Views, user Defined functions, Triggers, and cursors.
• Extensive knowledge in creating Tableau scorecards, bar graphs, dashboards using stack bars, geographical maps, scattered plots, Gantt charts using show me functionality.
• Good experience in Software Development Life Cycle like project documentation design, testing and production development.
• 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 teh end user requirement.
• Involved in teh installation of Tableau Server Application software, Tableau Desktop 8.0.
• Expert in Tableau Administration Tool for configuration, adding users, managing licenses, and data connections, scheduling tasks.
• Good experience on Databases skills wif testing complex SQL & PL/SQL queries.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform and Loading (ETL) using DTS and SSIS.
• Expert in generating Drill down and Drill through reports wif Drop down menu option, sorting teh data, defining subtotals in SSRS. Proficient in handling parameterized reports in SSRS.
• Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling
• Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server
• Extensive Dimensional Modelling experience in Star Schema/Snowflake schema design, Fact, and Dimensions tables.
• Having knowledge onETLtools likeInformaticaand all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer).
• Extensive knowledge on various Internet-related platforms wif specialization in SQL, PL/SQL, VB, HTML, DHTML, and XML.1
• Good communication skills, collaboration & is building skills, ready to work wif new team employees, flexible to work in different project levels.

TECHNICAL SKILLS

Programming languages: Java, C/C++, Data structures, SQL, PL/SQL, Python.

BI Tool(s): Tableau Desktop 10.X+, Tableau Server 10.5+, Tableau Public, Power BI, QuickBase

Databases: MySQL, SQL Server, Oracle, AWS RDS

Java/J2EE Technologies: JDBC, Servlets, JSP

Web Technologies: HTML, CSS, JavaScript, Bootstrap, AngularJS, Ajax, NodeJS, ExpressJS

Cloud Platforms: AWS (EC2, S3, VPC, ROUTE53, IAM, DynamoDB, RDS, Redshift, Kinesis, Athena, Quick Sight, Glue Cloud Formation, SNS, SES, SWF)

CI/CD TOOLS: Git, GitHub, Bitbucket, Jenkins, Docker, chef, puppet

Operating Systems: WINDOWS 10/8/Vista/ XP, LINUX, Ubuntu

Development IDEs: NetBeans, Eclipse IDE, Python (IDLE), PyCharm, ATOM

Packages: Microsoft Office, putty, MS Visual Studio, WEKA tool.

PROFESSIONAL EXPERIENCE

Confidential, Eden Prairie, MN

Tableau Developer/Business Intelligence

Responsibilities:

• Captured requirements by white boarding wif Product Managers
• Developed clutter free Tableau dashboards for various product lines and departments
• Set up tableau data sources and refresh schedules in server
• Played many key roles in this project like Developer, Analyst, Level 3 (L3) support.
• Designed clean, easy to use, intuitive dashboards considering end user needs
• TEMPEffectively utilized Tableau features like parameters, calculated fields, filters to provide efficient data visualization solutions to teh customer.
• TEMPEffectively used Tableau Marks to visualize data
• Used Custom SQL to manage complex data requirements from legacy systems and OLTP/OLAP systems
• Upgraded teh existing server version to Tableau 10.4 and successfully migrated existing workbooks and data sources
• Worked extensively in creating dashboards using Tableau Desktop and published them on Tableau Server. Involved in teh administrative tasks of Tableau server like installations, upgrades, user & user groups creation and set up of security features
• Tableau dashboard layouts were TEMPeffectively used to give interactive visual analysis experience to teh end user.
• Handled teh huge data volume by using Tableau extracts
• Used advanced concepts - blending, LOD to meet teh customer requirements
• Used dashboard filter actions, forecasting, table calculations to meet user requirements.
• Design visually interactive and actionable dashboards using data visualization tools. Scheduled data refresh on Tableau Server for daily and monthly increments
• Experience in setting up and using background image as Map
• Worked wif teh data architects and ETL team to finalize teh data model and transformations for teh data mart
• Assisted QA team in understanding business process and helped them in successful completion of Unit Testing and Integration Testing
• Defined and used best practices for Tableau UI design
• Coordinate wif user to gather teh reporting requirements.
• Involved in building teh ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Extracted teh data from teh flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down menu option and Parameterized using Tableau.
• Extraction, Transformation and Loading (ETL) of data by using SSIS.
• Perform ad hoc analysis and assist in building dashboards to support management business decisions.
• Extracted source data from flat files, Oracle and loaded to Dimensions in Oracle.

Environment: Tableau Server, Tableau 9.x, Tableau 10.4, ETL, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Irving, Texas

Tableau Developer

Responsibilities:

• Gathered Business Requirements from stake holders, interacted wif teh Users, Project Manager and IT teams to get a better understanding of teh project goals.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Performed gap analysis of teh data and reviewing teh requirements.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Involved in defining teh whole project life cycle, following agile methodology. Analyzed business requirements and segregated them into high level and low-level priorities.
• Created reports and visualizations for teh financial and sales team and helped teh team in fixing teh data discrepancies.
• Developed complex queries in Teradata and Oracle to meet teh business requirements and to extract teh data into Tableau.
• Found innovative ways to design graphs and charts visually exciting, and aesthetically pleasing, while at teh same time maintaining teh accuracy of teh core information content that is being communicated.
• Created complex dashboards on YTD, QTD, MTD data to provide powerful insight of teh Sales and Financial metrics.
• Extensively used data blending, embed functionalities in Tableau.
• Responsible for query performance tuning.
• Creating logical calculation and calculated fields wherever needed.
• Created various business metrics, filters and parameters for teh reports using Tableau desktop.
• Created various actions on teh dashboards for dynamic and interactive view of teh reports.
• Developed business dashboards using Tableau desktop and published on teh Tableau server and setting access privileges to teh business users and stake holders.
• Restricted data for Particular users using row level security and user filters.
• Scheduled frequency and time to refresh data when sources are publishing or extracted to server.
• Worked on Performance tuning of report wif huge queries using concurrent query execution for better performance of report.
• Supported teh published reports and responsible for all teh technical documentation.
• Extracted reports from Business Objects and migrated teh data to Tableau reports.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Environment: Tableau Desktop 2021.1.4, 2020.3.6, 2019.2, 10.5.3, Tableau Server 2021.1.1, 10.5.3, Teradata, Oracle, SQL Server, Toad, SQL Assistant, Business Objects BI4.0 6, MS Visual Studio Professional, JavaScript, MS Access, TWB Auditor, TabMigrate, Erwin, SharePoint.

Confidential, Chicago, IL

Tableau Developer/Admin

Responsibilities:

• Created action filters, Parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
• Converted Excel Reports to Tableau Dashboard wif High Visualization and Good Flexibility.
• Developed formatted, complex reusable formula reports.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Flat file, Excel to MS SQL Server using SSIS.
• SQL Server 2008 RDBMS database development using T-SQL programming, Views, queries, Stored Procedures.
• Created SSIS packages to load teh data from Text File to staging server and then to Data warehouse from staging server.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS, Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created affinity analysis dashboard and Radical charts for better understanding data.
• Used Trend Lines, Reference Lines and statistical techniques to describe data.
• Created various views in Tableau-like Tree-maps, Heat Maps, Scatter plots, Radical chart Geographic maps, Line chart, Pie charts and etc.,
• Created Financial reports, Demographics. This reports explains teh Company profit and employee relationships and we calculated using norm for comparison.
• Set up required processes for Background Tasks, Data Engine, DataServer, VizQLServer, ApplicationServer, Repository and Gateway inTableauServer.
• Perform cleansing teh redundant log files inTableauServer. Used parameters and input controls to give users control over certain values.
• Use Tab Admin commands to change configuration required forTableauServer.
• Implemented Data blending wif multiple data sources on a single worksheet for data analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Analyzed, manipulated and updated Database using SQL.
• ServerInstallation and Configuration ofTableau9.2 for Development, QA, UAT and Production, in a clustered Environment, along wif Load/Gateway Balancers and Active Directories
• Created AD/SAML Authentications in tableau sever.
• PerformTableauServerback up to negate disaster recovery.
• Involved inBusinessProcess Redesign and its documentation.
• Prepared theBusinessRequirement Document (BRD) and functional requirement document (FRD) for teh enhancement of teh existing services.
• Writing SQL queries for data validation by using join conditions.
• Created SQL Documentation for Benchmark queries and implemented new methods for better performance.
• Provided support for Tableau developed objects and understand tool administration.
• Involved to create Documentation for debugging report for Tableau.
• Developed teh table documentation for Tableau Dashboards. Wrote SQL queries for custom reports.
• Created functions, stored procedures, triggers and constraints using SQL.
• Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
• Recovered teh backups of SQLServerproduction databases in testserverenvironment.
• Analyzed poorly performing SQL queries to improve application performance.

Environment: Tableau Desktop 10.1.3/9.3, Tableau server 10.1.3/9.3, Microsoft SQL Server 2012, SSIS, SSRS, SSAS, T-SQL, MS Excel, MS Access, Windows 2007 server.

Confidential

Tableau Developer

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Schedule data refresh on Tableau Server for weekly and monthly data updates based on business change to ensure that teh views and dashboards to display data accurately.
• Created trend lines, statistics, groups, hierarchies, and sets to create detail level summary report and Dashboards using KPI's.
• Worked extensively wif advance analysis actions, LODs (FIXED, INCLUDE, EXCLUDE) functions, table calculations and parameters.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Define best practices for Tableau report development and TEMPeffectively used data blending feature in tableau.
• Evaluated bug fixes and identified teh changes from tableau 10.3 to 10.4 and digested teh customer accordingly.
• Perform Trouble Shooting, Performance tuning of reports and resolving issues wifin Tableau Desktop/Server Reports.
• Migrate existing Cognos Reports to Tableau Dashboards.
• Developed power shell scripts to email tableau dashboards as PDF attachments to teh users using tabcmd utility on monthly basis.
• Analyze user and business requirements by attending periodic meetings for changes in teh application requirements and documents. platform, directly from Tableau to access cloud data warehouse and quickly performs visual analysis.
• Perform data cleansing, formatting and consolidating multiple data files in SAS to generate reports for Web Analysis.
• Training and Mentoring peers in teh dashboard development and communicating best practices in tableau.

Environment: Tableau Desktop 10.2/ 10.4, Tableau Server 10.2/ 10.4, SAS 9.4, Cognos 10.2.2, IBM Big Insights and Netezza.

Confidential

Tableau Consultant

Responsibilities:

• Developed dashboards inTableauDesktop and published them on toTableauServer that allowed end users to understand teh data wif teh usage of quick filters.
• Participated in meetings, reviews, and user group discussions as well as communicating wif business groups.
• Worked closely wif all teams wifin teh organization to understand business processes, gather requirements, understand complexities and end goals to come up wif teh best plan of execution.
• Worked wif Business Analysts and Business users to understand teh user requirements, layout of developed applications.
• Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop to provide better data visualization.
• Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
• Developed and reviewed custom SQL queries wif use of joins clauses (inner, left, right, full) inTableaudesktop to validate and reconcile data.
• Used Custom SQL for joining teh tables, and selecting teh required Data.
• Creating users, groups, projects, Data connections, settings as atableau siteadministrator.
• Created Data Connections, published onTableauServer for usage wif Operational/Monitoring Dashboards.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand teh data on teh fly wif quick filters to filter needed information.

Environment: Tableau Desktop 10, Tableau server 10, MySQL Workbench, Sequel Pro, Jira, Mac sierra, Microsoft Excel 2012, Microsoft office 2012.