Sindhuja Rathod
San Antonio,TX
Summary
- Around 9+ years of experience in working with Tableau Desktop, Tableau Server, and Tableau Reader in various versions of Tableau 2019.x/10.x/9.x/8.x/7. x.
- Performed data analysis, statistical analysis, and predictive analysis and generated reports listings, and graphs using Excel, SSRS, and Tableau.
- Experienced in utilizing the Salesforce Data Export feature to export data in CSV format.
- Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps, etc.
- Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
- Collaborated with business teams to gather requirements and customized OBIEE reports to meet user-specific needs, ensuring data accuracy and relevance.
- Developed and deployed BI Publisher reports and templates for financial, operational, and management reporting, automating the generation of formatted documents.
- Experience in enhancing Tableau Solutions including debugging, monitoring, and troubleshooting issues/tickets.
- Outstanding knowledge & working experience of slice & dice SSRS, Power BI & Alteryx.
- Assist end users with problems installing the Power BI desktop, installing and configuring the Personal and OnPremises gateway, connecting to data sources, and adding different users.
- Adept at utilizing advanced DAX (Data Analysis Expressions) and Power Query for sophisticated data modeling and manipulation within Power BI.
- Collaborated with business analysts and ITSM teams to define reporting requirements for ServiceNow data, ensuring Power BI reports meet organizational objectives.
- Built interactive and dynamic Qlik Sense dashboards to provide real-time insights into customer data, enabling stakeholders to explore key metrics like customer acquisition, engagement, and lifetime value.
- Experience in writing TSQL (DDL, DML, AND DCL), developing/creating new database objects such as tables, views, indexes, complex stored procedures, function (UDF), cursors, and triggers, locking issues, BCP, common table expressions (CTEs).
- Created different report visualizations using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformations inside the edit query to clean-up the data.
- Excellent knowledge of all the phases of the Software Development Life Cycle (SDLC).
- Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion, and researching complex data problems via API
- Possesses deep knowledge of machine learning, mathematical modeling, and operations research, and is proficient in R, Python, SAS, and relational databases.
- Utilizes SQL, Numpy, Pandas, and Scikit-learn extensively for Data Analysis and Model Development.
- Hands-on Experience working with Azure Data Lake Analytics to analyze structured, and non-structured data from various sources.
Overview
11
11
years of professional experience
Work History
Senior Data Analyst
USAA
06.2022 - Current
- Installed and configured Tableau Server on various environments including Windows and Linux
- Implemented best practices for server configuration to optimize performance and ensure scalability
- Implemented Looker data transformations using LookML, SQL, and advanced functions to clean, aggregate, and prepare data for analysis, ensuring data accuracy and consistency
- Created and managed user accounts, groups, and permissions to control access to Tableau resources
- Provided training and support to users on Tableau Server functionality, including publishing, sharing, and collaboration features
- Strong experience in connecting Tableau to Salesforce using Tableau Salesforce connector
- Demonstrated ability to select relevant Salesforce data for analysis and visualization within the Tableau environment
- Designed various prototypes of dashboards using Tableau and Power BI, which would give the ability to the users to plug and play the dashboards
- Created Dynamic Dashboards showing the Company's yearly performance using various graphs
- Created several Custom tables, Views, and Aggregations for developing reports used in the Power BI data layer environment
- Involved in gathering requirements, conducting analysis, designing solutions, overseeing development, managing changes, and facilitating deployments
- Extracted data from heterogeneous sources, and applied intricate business logic to normalize raw network data, enabling BI teams to detect anomalies effectively
- Utilized SSIS Data Flow tasks to transform complex data structures, handling data cleansing, aggregations, and joins to support accurate reporting in Power BI
- Responsible for assessing the changes going to PROD and fine-tune Tableau server processes
- Reduced data transfer costs by optimizing queries and storage usage in AWS cloud environments
- Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
- Utilized SQL queries to extract, transform, and analyze CRM data, identifying trends and patterns to support strategic decision-making and business growth initiatives
- Using a query editor in Power BI performed certain operations like fetching data from different files
- Created reports utilizing SSRS, Excel services, and Power BI and deployed them on SharePoint Server as per business requirements
- Created Power BI Reports using the Tabular SSAS models as source data in Power BI Desktop and published service reports
- Responsible for Go-Live
- Once the production data is tested positive for no issues the project and its dashboards will set to go live for the intended audience
- Worked on importing custom visualizations and used various data visualizations with Power BI
- Environment: Tableau (Desktop/ Server), Power BI, SSRS, Hadoop, SQL, Oracle, Facets, Informatica, Agile, Jira, Snow, SSMS, Toad
Senior Data Analyst
MetLife
08.2020 - 05.2022
- Understand the Requirements and Functionality of the application from specifications
- Integrated Tableau Server with other enterprise systems such as Active Directory, LDAP, and SAML for single sign-on and user authentication
- Wrote SQL scripts for data cleansing and transformation, converting raw data into structured formats suitable for analysis, ensuring consistency and accuracy across different data sources
- Optimized SSIS performance by using techniques like buffer management, parallel processing, and efficient data flow configurations, reducing ETL execution times and enhancing overall system efficiency
- Designed both logical and physical data models for transactional and reporting databases, ensuring that data structures were optimized for performance and scalability
- Designed and implemented normalized and denormalized database schemas using ANSI SQL standards to support efficient data modeling and data integrity
- Integrated BI Publisher with Oracle EBS (Enterprise Business Suite) and other data sources to deliver comprehensive and accurate reports to business users
- Engaged in ER Modeling, Dimensional Modeling (including Star Schema and Snowflake Schema), Data Warehousing, and proficient use of OLAP tools
- Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets
- Created customer journey dashboards using Power BI and Qlik Sense to visualize customer behavior, track key performance indicators (KPIs) like customer satisfaction, retention, and NPS, and measure the impact of journey optimizations on business outcomes
- Leveraged Power BI's DAX (Data Analysis Expressions) to create custom metrics and calculations based on ServiceNow data, such as average resolution time, SLA breaches, and incident volume trends
- Mapped source data from operational systems to target data structures, ensuring that data transformations were aligned with business rules and reporting requirements
- Optimized report performance by implementing efficient DAX queries and reducing calculation redundancies, resulting in faster data refresh times and improved user experience
- Contributed to the development and maintenance of Looker development best practices and standards, ensuring consistency and scalability across LookML projects
- Responsible for managing operations and support across the Big Data Analytics platform, Splunk, and Tableau visualizations
- Expert in Power BI modelling, data storytelling and knowledge of how people make decisions with data
- Performed the role of MS Power BI subject matter expert
- Environment: Tableau (Desktop/ Server), BOBJ, Looker (Lookml Development/Desktop/ Admin, Server), Hadoop, HANA
Data Analyst
Change Healthcare
03.2018 - 07.2020
- I performed Data Analysis, Data Modeling, Data Migration and data profiling using complex SQL on various source systems including Oracle and Teradata
- Translated business requirements into working logical and physical data models for Data warehouses, Data marts and OLAP applications
- Used forward engineering to create a physical data model with DDL that best suits the requirements of the Logical Data Model
- Generated and reviewed reports to analyze Data using different Excel formats
- Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN
- Validated and updated the appropriate LDM's to process mappings, screen designs, use cases, business object models, and system object models as they evolve and change
- Troubleshooting, resolving and escalating data-related issues and validating Data to improve Data quality
- Participated in the testing of procedures and Data, utilizing PL/SQL, to ensure the integrity and quality of Data in the Data warehouse
- Report on trends that come up to identify changes within the systems using Access and Crystal Reports
- Maintained Excel workbooks, such as development of pivot tables, exporting Data from external SQL databases, producing reports and updating spreadsheet information
- Extracted Data from DB2, and COBOL Files and converted to Analytic SAS Datasets
- Performed Data Analysis and extensive Data validation by writing several complex SQL queries
- Designed and developed use cases, activity diagrams, and sequence diagrams using UML
- Extensively involved in the modelling and development of Reporting Data Warehousing System
- Designed the database tables & created table and column-level constraints using the suggested naming conventions for constraint keys
- Used ETL tools to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc
- Developed stored procedures and triggers
- Wrote packages, procedures, functions, and exceptions using PL/SQL
- Reviewed the database programming for triggers, exceptions, functions, packages, and procedures
- Involved in the testing phase right from the Unit testing to the User Acceptance testing
- Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle
- Environment: Erwin 4, MS Visio, Oracle 10g, SQL Server 2000, Business Object Data Integrator R2
Data Analyst
Abbott Laboratories
04.2014 - 11.2017
- Interacted with business to collect and understand Requirements
- Translated the business needs into system requirements by communicating with the business on the nontechnical level and with the System Analyst on a technical level
- Built interactive Power BI dashboards that visualized ServiceNow ticket lifecycle, response times, resolution trends, and customer satisfaction metrics for improved decision-making
- Integrated Sigma with other BI tools like Tableau and Power BI for enhanced reporting and visualization options, optimizing data accessibility across platforms
- Arranged walkthrough sessions with the user group to confirm that all the requirements have been captured and obtained sign-off on the requirements documents
- Created customized report templates in BI Publisher, improving report formatting and ensuring data accuracy for executive-level decision-making
- Identified the key facts and dimensions necessary to support the business requirements
- Develop the logical dimensional models
- Utilized Redshift's SQL functions and Windows functions to create custom reports and dashboards for data analysis
- Proficient in using data modeling tools such as Erwin, IBM InfoSphere Data Architect, and Microsoft SQL Server Management Studio (SSMS) for creating and managing data models
- Conducted and participated in JAD sessions with the users, modelers, and developers to resolve issues
- Performed source data quality assessments and created source-to-target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS
- Created Data Definitions and helped maintain the Metadata repository
- Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization
- Building, publishing, and customizing interactive reports and dashboards, and report scheduling using Tableau server
- Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel
- Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010
Education
Bachelor of Science - Electrical, Electronics And Communications Engineering
Geethanjali College of Engineering And Technology
Hyderabad, Telangana 05-2014
Skills
- OLAP/Reporting Tools
- SSRS
- SSAS
- MDX
- Tableau
- Power BI
- Programming languages
- C
- SQL
- PL/SQL
- T-SQL
- JAVA
- Batch scripting
- R
- Python
- Relational Databases
- SQL Server database 2014/2012/2008 R2/2005
- Oracle 11g
- SQL Server
- Azure
- MS Access
- Operating Systems
- Windows XP/Vista/7/8 and 10
- Windows 2003/2008R2/2012 Server
- SQL Server Tools
- Microsoft Visual Studio 2010/2013/2015
- SQL server management studio
- ETL Tools
- Informatica
- SSIS
- Alteryx
- Frontend Tools
- Microsoft Project
- Microsoft Office
- Document Management
- Visual Source Safe 60
- Share point
- Ultra Edit
- Documentum
- Google Sheets
- Other Tools
- MS Office 2003/2007/2010 and 2013
- Power Pivot
- Power Builder
- GIT
- CI-CD
- Jupyter Notebook
- Data Warehousing & BI
- Star Schema
- Snowflake schema
- Facts and Dimensions tables
- SAS
- Splunk
Timeline
Senior Data Analyst
USAA
06.2022 - Current
Senior Data Analyst
MetLife
08.2020 - 05.2022
Data Analyst
Change Healthcare
03.2018 - 07.2020
Data Analyst
Abbott Laboratories
04.2014 - 11.2017
Bachelor of Science - Electrical, Electronics And Communications Engineering
Geethanjali College of Engineering And Technology
Similar Profiles
Jeremy FalknerJeremy Falkner
Associate Auto Adjuster at USAAAssociate Auto Adjuster at USAA
Marcy CastilloMarcy Castillo
Claims Adjuster - Fire, Theft & Vandalism at USAAClaims Adjuster - Fire, Theft & Vandalism at USAA
David JusinoDavid Jusino
Property Claims Adjuster at USAAProperty Claims Adjuster at USAA
Jordan HoffmannJordan Hoffmann
Insurance Professional at USAAInsurance Professional at USAA
Collin DoanCollin Doan
Sales Associate at Sams Club DistributionSales Associate at Sams Club Distribution