Eekshana Th

Data Analyst

adyzgp@r.postjobfree.com

Contact: +1-972-****-***

Professional Summary:

* ***** ** ********** ** the IT Industry and worked on Tableau Desktop, Tableau Server and efficiently in connecting various data sources.

Professional experience on Tableau Desktop, Reader, Server, Mobile, Public. (Tableau versions 7 / 8 / 9/10)

Analyzing and acquiring experiences into large data sets, create visually compelling and actionable interactive reports and dashboards.

Involved in creating Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc. using show me functionality. Dashboards and stories as needed using Tableau Desktop and Tableau Server.

Professional expert in Data Visualization development using tableau to create complex, intuitive and dashboards.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines. Groups, hierarchies, set to create a detail level summary report and Dashboard using Tableau’s Advanced Capabilities.

Used Performance monitoring tool of tableau desktop to analyze the performance of data-heavy dashboards and implemented the best practices to improve the end-user experience.

Professional expert in roles such as BI End-to-End and solution implantation expert in the data warehouse, BI KPIs modeling.

Designed and developed crosstab, conditional, drill-down, summary, sub reports, Ad hoc reports, parameterized reports, Complex Reports.

Expert in RDBMS concepts and constructs along with Database objects creation such as tables, Index’s, stored procedures, Views, User Defined functions, Triggers, and cursors.

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.

Expert in Tableau Administration Tool for configuration, adding users, managing licenses, and data connections, scheduling tasks.

Good experience in Database skills with testing complex SQL & PL/SQL queries.

Extensive experience in extraction, transformation and loading of data directly from different Heterogeneous source systems like Flat Files, Excel, Oracle, MySQL, MS SQL Server

Having knowledge of ETL tools like Informatica and all Informatica Designer tools including (Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer).

Identifying and removing bottlenecks in order to improve the performance of dashboards and reports.

Writing and reviewing technical documentation like functional specifications, design specifications, project standards, test plans and test scripts, product documentation.

Experience troubleshooting ETL jobs, bug fixing and addressing production issues like performance tuning and enhancements.

Experience with Business Intelligence and data mining tools to perform insights analysis on varied data (E.g. Tableau, Salesforce Einstein Analytics, Microsoft Power BI).

Strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

In-depth experience in End-to-End Testing Lifecycle Phases including Test Planning, Test Design, Test Execution, and Defect Reporting. Extensive experience in Microsoft Office suite (MS Word, MS Excel, MS PowerPoint) and IAM web-based reports.

Experience in data visualization development using tableau and salesforce to create complex, intuitive and innovative dashboards.

Knowledge on tableau CRM salesforce on dashboards.

Experience with snowflake developing data warehouse models.

Technical Skills:

BI Tools:

Tableau (Desktop 7 to 10, Server, and Reader), MicroStrategy, Power BI.

Data Warehousing ETL Tools

Informatics Power Center 8, Tableau Prep

Operating Systems

Windows Family, Linux

Languages

HTML, CSS, SQL, PL/SQL, Python, R, SAS, Shell Scripting.

Databases

ORACLE 9i, 10g, 11g, 12.c, DB2, MS SQL Server 2012, HP Vertica, and MS-Access, Alteryx

Software Packages

MS-Office 2003, Microsoft Word, Excel and PowerPoint

Clinical & Provider Software

EPIC, JIVA

Source Code Repository

Git Hub

Agile

JIRA, Rally

Wiki Tool

CRM

Confluence

Salesforce

Educational Details:

Bachelor in Electronics and Communication Engineering- JNTU HYD

Certifications:

Salesforce Certified Platform App builder. (January 2022)

Professional Experience:

Client- Christus Health, Irving, Texas (Remote) Aug 2021– Till Date

Role-Data Analyst

Responsibilities:

Proactively provide technical analysis expertise and direction in developing, maintaining, and enhancing health and Wellness data needs, such as key operational and clinical metrics.

Utilize Tableau and programming skills to support the Health and Wellness division, including the development and automation of key operational workflows and clinical metrics.

Coordinate and participate in Health and Medical Management’s (HMM) technical initiatives, including the development of operational reports and technical specifications in support of all aspects of our Health Management Program.

Manage technical projects ensuring that project plan target dates are met and implemented to enhance and maintain reports.

Proactively review SAS report metadata to understand trends and provide recommendations to business users for continuous improvement and transfer to tableau report visualization.

Created Inpatient and Outpatient reports to analyze sales and revenue by a provider for management reporting and weekly/monthly Behavioral health team performance report.

Provided User Acceptance Testing (UAT) documentation for Tableau reports and provided exiting reports solution to improve performance.

Analyzed existing reports for identifying common KPI metrics to create common metadata and self-service metadata.

Promoted and supported the infrastructure of reporting and Power BI strategy, including standards and best practices.

Created interactive Commercial and Medicare Advantage, FEP Authorization trend reports.

Lead cross-functional teams/workgroups to bridge gaps between business and technical teams.

Conducting analyses to assess the budget impact of new drugs, assess adherence to policies and appropriateness of drug utilization, reimbursement by third-party payers, and other analyses to support cost-effective use of drugs.

Validate the SAS dataset and migrate SAS data sets into the SQL server to use for tableau reports.

Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Created SQL Server Reports and developed query for generating drill down and drill through reports using Power BI.

Writing SQL queries for data validation by using join conditions. Created SQL Documentation for Benchmark queries and implemented new methods for better performance.

Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.

Created company tableau chart guide template for training purposes.

Create Groups, Projects and add Users in Tableau Server.

Involved in the deployment of new dashboards to Test and Production environment.

Built different visualization and reports in tableau using snowflake data.

Recreated exiting SQL server objects in snowflake.

Experience in effectively developing SharePoint throughout the enterprise.

Strong communication and user design skills in SharePoint.

Knowledge of creating shell scripting on tableau dashboards.

HTML to create online graphical user interfaces to assist with testing trade applications on tableau dashboards.

Created python using tableau desktop with the join condition.

Developed the data warehouse using tableau server.

Knowledge of creating tableau CRM with the help of salesforce platform.

Experience with sandbox on tableau dashboards with data visualization interfaces.

Environment: Tableau Desktop 10.5, Tableau Server 10.5, SAS 7.1, Agile, Microsoft SQL Server, Snowflake JIVA, Excel, MS Office, CSV, Windows 10.

Client-Century Link\Lumen Technologies (Remote) Nov 2019 – July2021

Role- Data Analyst

Responsibilities:

Created and published Tableau data sources and Scheduled extract refresh for Daily, weekly and monthly.

Created interactive workbooks using Tableau 10 and 9.x with multiple connections to multiple data sources using data integration.

Involved in reviewing business requirements and analyzing data sources form Excel/ SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop

Administered user, user groups, and scheduled instances for reports in Tableau.

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

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

Conducted Gap Analysis, created Use Cases, workflows, screen shots and Power Point presentations for the Web Applications.

Creating Sales Growth Dashboard metrics measure the pace at which your organization's sales revenue is increasing or decreasing. Current sales revenue: The total dollar value of sales during the current time.

Created various views in Tableau like Treemaps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts, etc.

Power BI developer with skills as well to help deliver a set of dashboards.

Calculating the Average Purchase Value KPI measures the average value of each purchase order in your sales team processes.

Involved in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.

Created Ad-hoc reports by gathering specific requirements from the different users.

Involved extensively in the overall life cycle of the Data Warehouse integration project.

Generated reports using Advanced Metric objects, Filters, Prompts and also created customized templates to facilitate the End users to create customized reports by choosing Filters, Metrics and report attributes.

Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

Designed, developed and maintained daily and monthly summary, team rendering benchmark reports.

Provided support and developed high level render teams work performance with render shot links reports.

Involved in building SQL queries that were utilized in Tableau dashboards to satisfy the business's needs.

Used Git and Jira for code submissions and review process.

Developed shell and SQL scripts to apply for splits and coverage on trades that flow to Hp Vertica through different feeds.

Performed POC using Alteryx to integrate Alteryx with Tableau, with examples to illustrate how to monitor account executive performance, create trade areas, and understand buyer behavior.

Created SQL Documentation for Benchmark queries and implemented new methods for better performance.

Involved in creating Documentation for debugging reports for Tableau.

Developed the table documentation for Tableau Dashboards. Wrote SQL queries for custom reports.

Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.

Analyzed poorly performing SQL queries to improve application performance.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

Preparing Dashboards using calculations, parameters, filters, calculated fields, groups, sets and hierarchies in Tableau.

Created project documentation for future knowledge and provided 24/7-production support for Tableau users.

Working knowledge on Tableau Server / Administration.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Defined best practices for Tableau report development.

Performed data quality issue analysis using snow SQL by building analytical warehouse on snowflake.

Loading data into snowflake tables from the internal stage using snow SQL.

Experience using the solutions and features within the SharePoint frame.

Creating data visualization on shell scripting.

Created HTML reports on tableau dashboards with data visualization.

Created and developed the data warehouse using data visualization.

Creating and developing tableau salesforce CRM on data visualization.

Environment: Tableau Desktop 10.5, Tableau Server 10.5, Alteryx, Microsoft SQL Server, GitHub, Oracle 12c, Agile, Confluence, Excel, MS Office, CSV, JIRA, Windows 10.

Blue ware Technologies and Services Pvt Ltd, India May 2015–June 2019

Role-Data Analyst

Responsibilities:

Involved in the design and development of two main technological components, a Database to store data of all transactions related to each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.

Designed and developed calculator tools utilizing JavaScript, CSS, and HTML to create online graphical user interfaces to assist with testing trade applications.

Involved in database design/preparing SQL scripts to support the larger databases that involve terabytes of data.

Analyzed software application requirements, performed regression testing, executed test plans on UNIX platform and documented results.

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

Writing SQL queries for data validation by using join conditions and involved to create Documentation for debugging report for Tableau.

Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Assisted users to publish and collaborate reports via a web browser & embed Tableau view in other web applications like SharePoint.

Traced paths to various CSV files to change required property settings before test runs.

Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.

Creating interactive dashboards in spreadsheets, power points and submitting to the client.

Worked with government higher officials to identify state land and created property area maps.

Created customized reports using various chart types like text tables, bar, Area, Pie, tree maps, heat maps, line charts, pivot tables in excel and tableau.

Assisted users to publish and collaborate reports via a web browser & embed Tableau view in other web applications like SharePoint.

Involved in conducting training to a user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.

Identifying requirements by establishing a personal rapport with potential and actual clients and with other persons in a position to understand service requirements.

Maintains computer systems and programming guidelines by writing and updating policies and procedures.

Design and conduct tests for software programs.

Involved in building Custom Dashboards and reports that connect with live Salesforce Data using Salesforce connector.

Environment: MS SQL Server 2012, SQL, Jenkins, HTML, JavaScript, CSS, Oracle, Agile, PLSQL, Git, UNIX, Salesforce, Windows XP, User Acceptance Testing (UAT), Rational Clear Quest, MS Access, Jenkins, GitHub, Rational Test Manager, MS Office.

Contact this candidate