PROFESSIONAL SUMMARY:

• Over 9 years of Data Warehousing experience with Business Intelligence Tableau 10.5/10.0/9.0/8.0/7.0, SAS, SQL, Microsoft Excel, Microsoft Office as a Developer/Analyst in various companies.
• Involved in creating Visualizations, Dashboards and Workbooks, Stories as needed using Tableau Desktop and publishing on Tableau Server, creating Reports with appropriate design and layout as per requirements from End user using Tableau and SAS.
• Involved in writing Complex SQL Queries and creating Custom Reports in Tableau, Testing of Tableau Reports including Data Validation with different Test scenarios before publishing on Tableau Server.
• Provided 24/7 customer support to tableau users.
• Connecting to different types of files like Excel, Microsoft Access, Text files, Statistical Files, to different Servers like Microsoft SQL Server, Oracle, My SQL, Tera data.
• Knowledge in Data Joining, Blending of data, Cross data joins from different data sources.
• Worked with Live Connections, Extract, Data Source Filters, Global Filters, Quick Filters, Parameters, Context Filters, Action Filters, Sets and Groups.
• Skilled in Tableau Desktop for Analysis and Data Visualizations; Tabular Reports, Tree Maps, Heat Maps, Scatter Plots, Line Charts, Area Charts, Dual Axis Charts, Geographic Maps, Pie Charts, different types of Bar Charts, Histograms, Water Fall Charts, Butterfly Charts, Donut Charts, Pyramid Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (LOD Calculations, Table Calculations like Percentages, Totals, Ranks) and Formatting (Annotations, Layout Containers, Labels, Mark Card Changes, Pill Colours, Number Formats) using Tableau Desktop.
• Improved Dashboards performance in Tableau using Extracts, using appropriate filters like Datasource filters and Context filters.
• Installation of Tableau Desktop.
• Knowledge of Statistical Functions like Standard Deviation, Zscore, Mean, Median, Mode, Variance, Trend Analysis with R - Squared, P-value and creation of Histograms, Scatter Plots, Box and Whisker Plots.
• Involved in Creation of SAS Datasets from raw data using joins, set, merge, creating SAS daily and monthly Reports along with charts and Graphs as per requirements from the Clients in Finance (Retail stores like JCPenney, Walmart) and extensively used Advanced SAS, Base SAS, SAS/SQL, SAS/Macro on Analysis, Design, Implementation and Testing of various projects for Financial Statement Audit.
• Quick learner and good performer both in team and independent job environments.
• The ability to analyze truly Big data at interactive speeds using Teradata.
• Extensively worked on databases like Oracle, SQL Server, and DB2.
• Having knowledge of Relational Data architecture, RDBMS Concepts which includes Relational and Dimensional Models, Datawarehousing and Tableau architecture.
• Excellent Knowledge of Financial, Retail, Insurance and Telecom Domains.
• Strong written and Verbal Communication Skills.
• Excellent Analytical, logical and Programming Skills.
• Experience in working in Water fall, Agile and Kanban models.
• Exposure to Amazon web services (AWS).
• Interacted with Business Users for discussing Business requirements, any necessary changes in requirements and Enhancements.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, Teradata

Database Tools: SQL Developer, SQL Plus, Toad, SQL Assistant

Reporting Tools: Tableau 10.5,9,8.2,8.1/8.0/7.0,SAS

Languages: PL/SQL, SQL, Unix shell scripting, C, C++

Web Tools: HTML, DHTML, XML, JAVA SCRIPT

Operating Systems: UNIX, Linux, Microsoft

Others: MS Office

PROFESSIONAL EXPERIENCE:

Confidential, Pennsylvania

Tableau Developer

Responsibilities:

• Understanding business requirements documents and developing design documents related to Dashboards Creation.
• Created YoY and QoQ comparison charts using Line Graph to better understand the performance of claims over a period. Also, used Table calculations to show %growth with respect to Profit over different years.
• Created different reports on different products in insurance, showing Performance Breakdown of different products by state, user accessible reports which tracks status of different Claims and allows users to select and view different Claim status options with Quick Filters.
• Created Tableau scorecards which provides a comprehensive snapshot of Claim Analysis like creation of bar charts and line charts showing the claims closed by week filter by associates, reports showing the average time to settle a claim, performance assessment of Customer Care associates.
• Created Critical reports which includes Fraud Analysis(Suspicion of Fraud) and identifying Anomalies in Claims using Bullet Graphs and Scatter Plots.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, forecasting, Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
• Created Crosstab reports to display underlying data based on various graphs and charts created for further data analysis.
• Worked on gathering and converting data over to Tableau using SQL/SAS/Excel data over to tableau reports and Dashboards.
• Created context filters to limit data sourced into tableau engine.
• Created parameters to give ability to users to dynamically change the filters and see resulting numbers.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server, which allowed story telling behind the growth in insurance policies with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Used trend lines extensively for correlating different KPI's for improving business performance.
• Knowledge on tabcmd and tabadmin commands.

Confidential, Seattle

Data Visualization Analyst (Tableau)

Responsibilities:

• Created Tableau dashboards and Workbooks as per Business Requirements using Tabular Reports, Stacked bars, Graphs, Scatter plots, geographical maps, Pie Charts, Bubble Charts, Word Cloud, Histogram, Area Charts, Dual Combination Charts, Heat Maps using SHOW ME functionality.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales and to track existing customer sales. Also worked on Migration Report for comparison of metrics between existing and migrated database.
• Created IVR reports, Customer Support reports showing analysis of different service requests raised and Customer Satisfaction reports showing Percentage calculations regarding Phones, Network, Support.
• Created Executive Summary Reports for comparison of Revenue across different years.
• Created Monthly and Quarterly reports showing Total, Net Postpaid and Prepaid Subscribers across different quarters, line charts tracking Average Revenue for different users by different Plan Types which helps to increase average revenue and suggestions for Cross selling, Bullet graphs showing comparison of different Product types like Software, Account, Hardware, Billing with respect to Service Calls across different years.
• Used geographic view, which clearly gives the performance of a particular state.
• Developed customized calculations when required.
• Effectively used Data Blending feature in Tableau.
• Joined several tables and also worked with Group by Folders, Group by Data Source table, hierarchies, drilling down into different levels of hierarchy including date hierarchies.
• Used Ranking feature in worksheet to highlight the Top N ranks of custom chosen dimension based on specific measure.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Used incremental and full data refreshes while working with extracts for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Performed Comparison analysis, Year wise trends for sales, profit via combination of Line/Bar charts using Tableau dual axis feature.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background Images, Maps, Trend Lines, Reference Lines, Filters, Groups, hierarchies, Sets to create detail level summary report using KPIs, Workbooks.
• Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight Action to provide rich visual interaction between the views on the sheet.

Confidential

SAS Analyst

Responsibilities:

• Responsible for performing complex analysis which is useful to understand the business (Profit/Loss or Utilization).
• Provides analytical support on products and Analyses Portfolio and/or new account vintage trends, Cohart Analysis, losses, credit criteria. Preparing Adhoc Analysis reports (Pivot tables in Excel) when management requires.
• Generating daily, weekly, monthly reports for both PLCC and Dual (Co-brand cards), writing Test Cases with different test scenarios and Data Validation.
• Understanding the business needs and generating different Reports accordingly which are useful to analyze the business effectively.
• Creation of new datasets from raw data files using Import Techniques and modifying existing datasets using Set, Merge, Sort, Update for Analysis.
• Automation of entire process SAS/Excel for complex and critical reports like Spiff reporting which has reduced the manual effort(reduced chances of errors) and increased the productivity.

Confidential

Analyst

Responsibilities:

• Extensively used the JEDAR tool to test journal entries for fraud. Served a number of clients especially for Northeast region in United States in performing SAS99 journal entry testing including error debugging and self QA.
• Extensively used SAS/Base, SAS/SQL and SAS/Macro while developing this JEDAR tool. Working with BASE SAS and SAS tools emphasizing on Analysis, Design, Development, Implementation and Testing of various projects for financial statement audit.