SUMMARY

• Around 6 years of experience as a BI Data analyst using Tableau Desktop.
• Used BI tools like Tableau to create data visualization and dashboards for teh client to present a visual picture and trend analysis.
• Expertise in designing and creating various analytical reports and Dashboards to halp users to identify critical KPIs and facilitate strategic planning in teh organization.
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Para meters etc. in Tableau.
• Created various Tableau Reports that includes Charts, Filters, Scorecards, Drilldown and Drill - Through, Cascade, and Parameterized reports that involved conditional formatting.
• Experience in Data analysis, with good data modeling exposure
• Proficient in SQL databases MS SQL, MySQL. Hands-on experience in UNIX and Linux Kernels.
• Efficient in using apache Hive and hive query language.
• Used Hive to analyze data by writing SQL like queries called HiveQL.
• Experienced in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers.
• Highly skilled creating visualizations using Tableau, and Python libraries like ggplot2, Matplotlib for creating dashboards.
• Strong skills in writing technical and functional documents defined by teh business requirements.
• Good knowledge in various stages of SDLC (Software Development Life Cycle), Software Testing Life Cycle (STLC).
• Having experienced in Agile Methodologies, Scrum stories and sprints experience along with data analytics, data wrangling and Excel data extracts.
• Adequate knowledge on R Studio, Tableau and SSIS/SSRS tools.
• Strong understanding of Agile and Scrum Software Development Life Cycle Methodologies.
• Excellent analytical and communication skills with ability to interact with individuals at all levels.

TECHNICAL SKILLS

Programming: R, SQL, Python.

Tools: R Studio, MS/MySQL, Hive, Google Analytics, Tableau, Jira, Visio, SSIS/SSRS, AB initio.

Others: Dimensionality Reduction, Data validation, CRM (Wealth Box), MS Office (Excel-Advanced, Power BI, SharePoint, Access, etc.), AWS (EC2, S3), Gantt Charts, UAT Testing, RCA (Risk Capital Analytics).

PROFESSIONAL EXPERIENCE

Confidential, CA

Tableau Data Analyst

Responsibilities:

• Responsible for managing 55,000 active accounts and 80,000 active user profiles and tracking their deals using salesforce.
• Used SQL queries at teh custom SQL level to pull teh data in Tableau desktop and validated teh results in Tableau by running SQL queries.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Creating multiple workbooks and dashboards using Calculated fields, Quick table calculations, Custom hierarchies & Parameters to meet teh business needs.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand teh data on teh fly with teh usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for daily increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Performed A/B testing using LRI metric.
• Analyzed reports and trends and provided recommendations on territory planning on a quarterly basis.
• Designed aesthetically pleasing, engaging, and efficient visualizations, reports on teh LCP Churn data.

Confidential, Malvern, PA

BI(Tableau) Data Analyst

Responsibilities:

• As a BI Analyst responsible for analyzing key risk factors and conducting clinical research by evaluating products, reviewing market size and trends, identifying new population, characterizing disease population for Renal diseases by deriving data insights.
• Responsible for building dashboards, interactive charts, monitor ETL processes and Application integration tasks for patient’s medical claim, demographics data and therapy data to analyze trends and fore caste KPI.
• Built dashboards for measures with a forecast, trend line, and reference lines.
• Designed and developed 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.
• Combine Data sources by Joining Multiple Tables and using Data Blending.
• Experience in creating Filters, quick filters, table calculations, calculated measures and parameters.
• Great understanding of SDLC methodologies such as Waterfall and Agile (specifically SCRUM).
• Worked on customer retention algorithm by analyzing data with teh support of Excel and Tableau.
• Performed hypothesis testing to analyze and validate trends among different groups.
• Implemented exploratory data analysis and provided impactful insights using tableau.

Confidential

Data Analyst

Responsibilities:

• Experienced in Analyzing large and complex data sets using SQL, Tableau, Power Bi, Excel, Access. Gathered requirements from stakeholders, designed an efficient interactive BI Dashboard through use of Tableau.
• Experienced in Tableau Desktop/Server in creating highly interactive Data Visualization Reports and Dashboards using complex functionalities such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Involved in creating dashboards by extracting data from different sources.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Generated and analyzed quarterly and yearly business summary reports through Tableau, Excel, and R
• Created solution driven dashboards by developing different chart types including Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Scatter Plots, Box plots, facet grids and Histograms in Tableau and R studio.
• Performed SQL database operations to ensure quantity and quality of data and translated teh data into reports.
• Identified teh risks and compliance for mutual funds by monitoring market performance and fundamental factors before making recommendations to clients.
• Used JIRA Agile methodology extensively to track teh day to day scrum activities.