Resume

Data Analyst

Location:

Union City, CA

Salary:

80000

Posted:

April 14, 2021

Contact this candidate

Resume:

KEERTHIKA SINGARAVELU

Email: adlots@r.postjobfree.com Mobile: +1-669-***-****

Location: Union City, California – 94587

OVERVIEW:

Over 4+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.

Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

End to end experience in designing and deploying data visualizations using Tableau.

Deployed the reports and Scheduled Reports for the use of end users and customers.

Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.

Extensive experience working in Windows, UNIX, LINUX environments.

Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.

Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star- schema, Snowflake schema using fact and dimension tables and relational databases

(Oracle), Mainframes, MS Access and client/server applications.

Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.

Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.

Professional in writing complex Formulas, Sub Reports, Summary Reports.

Installation, configuration and administration of Crystal reports and SAP BO.

In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment.

Strong working knowledge in software development methodologies like Rational Unified Process (RUP), Agile, Waterfall across the span of various projects.

Excellent data-analysis skills and ability to translate specifications into a working Universe and Report.

PROFESSIONAL EXPERIENCES:

CareSource Dayton, OH Aug 2019 – Present Data Analyst

Track the incremental $s identified for Kick Payments that have been unaccounted for in past CareSource processes (SAS, SQL).

Identify and quantify data issues within the organization and assist in the development plans to resolve Claims Encounters data issues.

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

Created drill through reports in dashboard.

Created dashboards by extracting data from different sources using parameters, sets, groups and calculations.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating calculated fields, mapping and hierarchies.

Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Server in all the environments.

Created incremental refreshes for data sources on Tableau server.

Monitored VizQL server, Application Server and data server activity to track performance and system stability.

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

Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.

Created report schedules, data connections, projects, groups in Tableau server.

Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Involved in creation and updates of several SQL Index, Views, Complex Stored Procedures, triggers and appropriate User defined functions.

Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

ENVIRONMENT: Tableau Server 8.1/8.2, Tableau Desktop 9.0, 9.0.1, 9.0.2, 8.1/8.2, Windows Server Standard R2, Excel, SQL Server management studio, MS SQL Server 2008R2, UNIX. UVA Health System Charlottesville, VA NOV 2017 –July 2019 Data Analyst

Excellent understanding of Core Java concepts like Multi-Threading, Exception-Handling, Collections, Generics and Serialization.

Involved in creating dashboards by extracting data from different sources.

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating a dual-axis bar chart with multiple measures and also used small multiples.