Business Intelligence Information Technology
Resume:
Professional Summary
●Over *+ Years of experience in the field of Information Technology with an emphasis on Business Intelligence Tools such as Tableau 2019.2/2019.1/10.5/10.1/9.3/9.1/8.1.
●Extensive experience with design and development of Tableau visualization solutions.
●Extensive experience in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau Reader in various versions of Tableau (8.x/9.x/10.x) and SQL, PL SQL and UNIX shell scripting.
●Experience with Tableau reporting/data visualization tool Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
●Experience in gathering and writing detailed business requirement and translating them into technical specifications/ System Requirement Specifications (SRS) and design identifying interface and business process specifications.
●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.
●Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trials and Density Chart. Making sure the team delivers reports as per the requirements.
●Extensive experience in acquiring data from multiple data sources, joining them and preparing the Dashboards with the data.
●Experience in Confidential -SQL (DDL, DML and DCL), Creating, developing new database objects by like Tables, Views, Indexes, Complex stored procedures, function (UDF), cursors, and triggers common table expressions (CTEs) SQL using SQLSERVER 2000/2005/2008 R2/2012.
●Proficient Knowledge in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Joins, Keys and Data Import/Export.
●Good Experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
●Having experience in designing customized interactive dashboards in Tableau using Marks, action, filters, parameter, security concepts, calculations and relationships.
●Worked on analyzing large sets of data using various techniques such as quantitative analysis, advanced analytics, and statistical modeling to find solutions.
●Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and statistic datasets.
●Having experience in forecasting future growth and projecting it by developing reports to show in detail.
●Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytics and problem-solving skills.
●Mastered in using Filters, sorts, groups and sets, reference lines, Bands and Boxes in different kinds of charts.
●In depth knowledge in Tableau advance analysis features like Actions, Calculations, Forecasting, Parameters and Trend Lines.
●Mastered the ability to design and deploy rich Graphic Visualizations Parameters using Tableau.
●Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
●Experienced in translating the business solutions to non-technical stakeholders through analysis findings.
●Responsible to monitor performance and optimize SQL queries for maximum efficiency.
●Created complex queries and performed data analysis
●Worked on Tableau python code for integration and wrote multiple python programs
●Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownership, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server
Technical Skills:
Business Intelligence
Tableau 2019.1,10.1,9.3/9.1/8.2
Languages
PL/SQL, SQL*PLUS
RDBMS
Vertica, Splunk, Oracle 12/11/10/9i, DB2 8.2, SQL Server 2016/2012/2008, MS Access, SYBASE 12.5, Teradata
Operating Systems
Windows, Red Hat Linux
Certifications
Certified on SQL and Relational Databases from IBM.
Certified on Introduction to Databases and SQL Querying from Udemy
Certified on Data Visualization and Communication with Tableau provided by Duke University.
Certified Tableau Desktop Specialist
Experience
Bank of the West, CA November 2022 – Till Date
Role: Data Analyst
Responsibilities:
Working of Data Migration by Analyzing the database, tables and attributes in Oracle.
Database Mapping by writing complex sql queries and checking against the actual versus derived.
Develop Dashboards on Business KPI’s to track business performance.
Performing Data Modeling in Tableau Desktop.
Publishing Workbooks and Data Sources to Tableau Development and QA Sites.
Refreshing Extracts on Development and QA Functionalities.
Monitoring the status of extract schedules on Testing environment.
Resolving any data or performance issues related to workbooks and data Sources.
Wells Fargo, Charlotte November 2021- November 2022
Role: Data Analyst
Responsibilities:
Worked on Customer Issue Tracking system to understand the process of business flow.
Gathered the data from numerous sources and connected on SAS to identify and resolve issues.
Performed ETL process on collected data to render influenced business decisions considering the data Insights.
Analyzed the data using statistical techniques and provided reports.
Designed and Implemented the dashboards by organizing the sources and data systems.
Processed confidential data and statistical values as requested by the management.
Supported the team efforts and taken the process to next level by deep analysis on tableau and power bi.
Design, build and track KPI metrics to provided deeper data analytics to support optimization and growth.
Experienced in handling complex data by handling adhoc SQL Queries and provided data driven solutions.
Reported the solution on data modeling and visualization with required specifications, which reduced the manual effort by 5%.
Detailed Reporting incorporating the data from multiple sources to perform joins, blend and relationship to synchronize the various dimensions of data.
Created presentations and reports based on recommendations and findings.
Interpreted banking information on Approvals and Denials, analyzed the performance over the period to ensure organizational growth.
Automated the internal process of Issue files process through SQL code generation and analytical calculations.
Maintained data refresh on dashboards and KPI’s to present the visual insights with the current data.
Identified current trends and patterns using key performance indicators and metrics.
Provided visual Insights on cohert and segmentation analysis to analyze customers perception or views over a certain period.
Evaluated the changes and incorporate those changes to enhance reports and structures.
Calculated the YTD, MTD, QTD using descriptive analysis and shown the current trends on banking information.
Extensively used advance chart visualizations like Pareto chart, Heat maps and density maps to assist business users in solving complex problems.
Handled sophisticated calculations and functions to manipulate complex data to show time series analysis.
Had a glimpse of R-Integration to merge the data and supported advanced analytics.
Environment: Tableau Desktop 2020.4.1, 10.2, Tableau Server 2020.3.3, Microsoft SQL Server, SAS.
Boeing, Miami, FL November 2019- November 2021
Role: Tableau Developer
Responsibilities:
Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
Effectively utilized features and Best Practices of Tableau and visual analytics to maximize impact and utility of visualization products.
Involved in the Data warehouse, Data modeling based on the client requirements.
Designed standardized Data Mart with aggregated data, calculated metrics to suffice the source data need for various Tableau Reports and worked with ETL, DBAs, Data Modelers to implement the same in Development, Test and Production environment.
Built a single page application on React Native that made the end users as a portal with one stop shop to browse through the report building, publishing customized interactive reports and dashboards, report scheduling using Alteryx in Tableau Server.
Worked on creating the Alteryx workflows to trigger Tableau data sources.
Worked in Production Support Environment QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Managed a repository of re-usable data visualization templates and views.
Supported Activities to document, evolve, and communicate artifacts developed using Tableau.
Automated key reports using Tableau and it is used by Executives of the Organization.
Documented, Implemented, and deployed tableau server on Windows, and TSM commands
Extensively worked on metadata in Tableau desktop to modify data types, rename fields, joins, refresh data and change extract data options to prepare data sources to be used by users.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts and publishing them to tableau server and tableau Online.
Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
Extensively used SQL in data profiling, modelling, and mining of data.
Experience in using tabadmin tools and tabcmd for setting up security profiles for various user groups and users.
Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.
Created different views in workbook to visually analyze the data.
Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
Developed Tableau visualizations and dashboards using Tableau Desktop.
Developed Tableau workbooks from multiple data sources using Data Blending.
Environment: Tableau Desktop 2019.4.1, 10.2, Tableau Server 2020.3.3, Microsoft SQL Server.
USA Bluebook, Waukegan, IL August 2018 – Oct 2019
Role: Tableau Developer
Responsibilities:
Involved in Gathering and Technical for Decision Business requirements. Interacting with the Business Analyst, client team.
Pulled the Data from Splunk, Vertica DB Through Tableau Connections and Effectively used the Tableau Data Blending and join Features.
Pulling the Data From DB, Designing, Development and Publishing of the Report/Dashboard into the Tableau Server through both Live and Extract connection through the Best practices.
Worked on Quality Assurance of User Interface and Database of Dashboard.
Worked on the performance Tuning /Optimization Technique of Tableau Dashboard.
Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
Technical oversight of the entire Tableau Online infrastructure from user setup to performance tuning.
Performance tuning of workbooks, data sources, and providing best practices for user community
Provided production support for Tableau users.
Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, and pivot tables.
Worked across departments to identify and understand key business questions and standardize key metrics and measure.
Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau. Created Workbooks and dashboards for analyzing statistical billing data using Tableau.
Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
Created adhoc dashboard to the Users according to the Requirements.
Responsible to monitor performance and optimize SQL queries for maximum efficiency. Tuned SQL queries using execution plans for better performance.
Created complex queries and performed data analysis between dashboards Vs. data base.
Environment: Tableau 2019.1, MS SQL 2016/2012, Oracle, Windows Server.
General Electric December 2012- March 2015
Role: Tableau Developer/Data Analyst
Responsibilities:
Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of Tableau Servers.
Designed, developed, and published customized interactive reports /dashboards and scheduled data refreshes for reports on Tableau Online.
Created adhoc reports to users in Tableau by connecting to excel sheet, flat files, and CSV files.
Created action filters, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
Effectively used data blending feature in Tableau.
Provided guidance and insight on data visualization and dashboard design best practices for Tableau report development.
Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data.
Developed and reviewed SQL queries with use of joins clauses in Tableau Desktop to validate static and dynamic data for data validation.
Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
Technical oversight of the entire Tableau Online infrastructure from user setup to performance tuning.
Performance tuning of workbooks, data sources, and providing best practices for user community.
Provided production support for Tableau users.
Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
As a Tableau Developer, using Tableau for Data Analysis, Digging the data for source, systems analysis and deeply diving the data for Predictive findings and for various data Analysis.
Developing predictive statistical models using statistical analysis and other predictive modeling techniques.
Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Waterfall charts, funnel charts etc., to assist business users in solving complex problems.
Analyzing the data of patterns, trends and fashions of various KPIs, Measures using various graphs, charts, and pivot tables.
Worked across departments to identify and understand key business questions and standardize key metrics and measure.
Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
Created calculated fields, parameters and action filters for building dashboards and worksheets in tableau.
Created Workbooks and dashboards for analyzing statistical billing data using Tableau.
Created multiple visualizations like Heat Maps, Bar Graphs and Bullet Graphs.
Defined best practices for Tableau report development.
Involved in Migration of reports from BO -> Tableau.
Worked on Tableau python code for integration and wrote multiple python programs.
Environment: Tableau 10.5/10.1/9.3, MS SQL 2016/2012, Oracle, Python, Windows Server.
Chevron, Houston TX April 2012 - December 2012
Role: Tableau Developer/Data Analyst
Responsibilities:
Participated in Tableau server from 8.0 to 9.1 in DEV and QA along with Migration of reports.
Experience in designing and developing multiple analytical reports from multiple data sources by data blending on a single worksheet in Tableau Desktop.
Used advance features of Tableau software like, link data from various sources, merged on one dashboard and to filter data in multiple views at once.
Published the created dashboard reports in tableau server.
Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static datasets.
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.
Published views and dashboards in Tableau Server for auditor review.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
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.
Participated in Preparing Detailed technical documents from the functional specifications.
Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters for on demand healthcare information.
Creating users, groups, projects, Data connections, settings as a tableau site administrator.
Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
Used data blending on databases and developed interactive dashboards.
Administered and provided production support for Enterprise-wide Tableau application consisting of multiple key functional business domains.
Created Report templates, bar graphs and pie charts based on the financial data using Tableau.
Tested Dashboard for data accuracy and Functionality.
Environment: Tableau 9.1/8.0 Desktop, MS SQL 2012, Teradata, Oracle, DB2, Facets
Education
Master’s in Business Administration (HR & Systems) Anna University 2012
Bachelor’s in computer technology, Anna University, PSG College of Technology 2010
Contact this candidate