Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
Generic

Rohini Tadimeti

Summary

Data Analyst & Application Engineer with 10 years of expertise in ETL development and big data processing, specializing in data visualization and Analysis. Proficient in SQL, Python, Tableau and PowerBI with extensive experience in modern data warehousing and cloud migration. Demonstrated success in optimizing data pipelines and automating CI/CD processes to improve deployment reliability. Skilled in collaborating with diverse teams to drive data-driven business outcomes.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Sr. Data Analyst and Application Developer

Capital One
Plano
12.2024 - Current
  • Analyzed auto loan funding workflows to identify delays and inefficiencies using SQL and Python.
  • Built interactive Tableau dashboards to monitor key metrics including funding turnaround time, document rejection rates, and dealer performance.
  • Collaborated with operations, product, and engineering teams to drive data-driven process improvements, resulting in reduced delays and improved SLA compliance.
  • Developed automated reporting tools for real-time tracking of funding KPIs across multiple dealer channels.
  • Presented actionable insights and performance trends to senior stakeholders, influencing strategic operations decisions.
  • Expert in generating on-demand and scheduled reports for business analysis or management decision using Tableau and
    POWER BI. Periodic reporting is done on a daily, weekly, monthly, and quarterly basis.
  • Strong analytical skills; support operations through analysis of key performance indicators and trends.
  • Created various types of charts such as Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop, Power BI, and Excel to provide better data visualization.
  • Solid knowledge of Power BI and Tableau Desktop report performance optimization.
  • Created Excel reports, Dashboards & Performing Data validation activity using VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map, and Heat Map.
  • Expert on maintaining and managing Microsoft Power BI and Tableau reports, dashboards, and publishing to the end users for Executive level Business Decision.
  • Experienced in managing users, groups, sites, permissions, and roles on Tableau server. · Superior multi-language communication skills (French, Amharic) - market analysis on product design and segmentation.
  • Thrives in high-pressure environments, budget forecasting, management, and strong team player skills. · Communicated with users, other technical teams, and senior management to collect requirements and describe data modelling decisions and data visualization strategies.
  • Data blending implemented on databases and generated interactive dashboards.
  • Created ad-hoc reports to users in Tableau by connecting various data sources.
  • Handled Tableau admin activities granting access, managing extracts and installations.
  • Generated Dashboards with Quick filters, Parameters, and sets to handle views more efficiently.
  • Published workbooks by creating user filters so that only appropriate teams can view them.
  • Analyzed the source data and handled efficiently by modifying the data types.
  • Used Excel sheet, flat files, CSV files to generate Tableau ad-hoc reports.
  • Generated context filters and used performance actions while handling huge volume of data.
  • Generated Tableau dashboards for sales with forecast and reference lines.
  • Generated Tableau dashboards with combination charts for clear understanding.
  • Created SSIS packages to migrate data from different data sources to data warehouses. Successfully extracted transformed and loaded data into the data warehouse.
  • Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.
  • Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task, and Script Task in SSIS Designer.
  • Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.
  • Involved in enhancing and deploying the SSIS Packages from the development server to the production server.
  • Work on SSIS performance tuning using error handling, event handling, and re-running of failed SSIS packages using checkpoints and scripting with VB.net in SSIS.
  • Perform the Unit testing after the development, Support QA, and UAT testing as requested.
  • Designed and implemented ETL job restart ability using checkpoints and optimal package design techniques in SSIS.
  • Identify data quality issues and support Data governance by participating in necessary activities.
  • Writing Python scripts to get data from different sources like Oracle Database/JSON/API.
  • Imported Data into Power BI using Direct/ Live Query based on Table size and created lookup tables to maintain Relationships.
  • Create and customize simple data visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges, and single-number cards.
  • Use JIRA to make the development organization faster, leaner, and more agile to get on track with the User stories and to improve iteration planning practices.
  • Agile scrum team environment, 2-week sprints, daily stand-up, team player, and collaborative.

Previous Project

Charles Schwab - NGOMS & QuotePlant
Omaha
12.2023 - 11.2024
  • Designed and developed interactive Tableau dashboards to monitor key business performance metrics, resulting in reduction in decision-making time.
  • Wrote complex SQL queries utilizing joins, sub-queries, and common table expressions (CTEs) to acquire business-related data.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, and database links formatted the results into reports, and kept logs.
  • Created Stored Procedures to transform the Data & worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Participated in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
  • Performed tune to optimize SQL queries using SQL Profiler and Query Analyzer.
  • Worked on Creating, Modifying, and updating the Views and Functions.
  • Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
  • Developed dynamic and complex worksheets and embedded into dashboards.
  • Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications.
  • Prepared dashboards using calculated fields, parameters, groups, sets, and hierarchies in Tableau
  • Previous Project: Next Gen Order Management System (Trading Application)

Senior Data Analyst

Charles Schwab
Omaha
02.2019 - 10.2024
  • Client: Charles Schwab Financial Services

Senior Data Analyst

Advisor Services Technology (AST –RBS)
08.2023 - 12.2023
  • Created and maintained SQL queries for pulling datasets from a database, ensuring data accuracy and consistency across reports.
  • Utilized Tableau Desktop for data blending across multiple databases, creating interactive, visually compelling dashboards, and views tailored to business needs.
  • Wrote complex SQL queries to extract, aggregate, and analyze data from multiple databases, improving reporting accuracy and efficiency.
  • Automated routine reports and data extraction processes, reducing manual effort by and improving data reliability.
  • Collaborated with business teams to understand requirements, translated business questions into technical queries, and provided actionable insights for marketing and sales teams.
  • Conducted A/B testing and statistical analysis on marketing campaigns to measure effectiveness
  • Provided training to junior analysts on SQL and Tableau best practices.
  • Assisted in building dynamic Tableau dashboards for real-time reporting, enabling executives to monitor performance metrics.
  • Cleaned and transformed raw data using SQL and some automated scripts, preparing it for analysis and visualization.
  • Performed exploratory data analysis (EDA) on sales data to identify trends and patterns that informed decision-making.
  • Project #2: Advisor Services Technology (AST – RBS – Retirement Business Services)

Application Development Analyst

Retirement Planning Services (RPS)
02.2019 - 08.2023
  • Gathered and analyzed requirements from data analysts and business lines, translating them into technical specifications
    for Tableau dashboard development.
  • Utilized Tableau Desktop for data blending across multiple databases, creating interactive and visually compelling
    dashboards and views tailored to business needs.
     Developed and maintained multiple scorecards and dashboards, using a variety of visualizations such as heat maps, scatter
    plots, trend lines, and KPIs to deliver insights at a glance.
     Performed ongoing data analysis on a daily, weekly, and monthly basis, ensuring dashboards were live and up-to-date,
    providing real-time insights for decision-makers.
     Actively contributed to the generation and refinement of new KPIs in Tableau Scorecards, allowing for more accurate
    tracking of business performance metrics.
     Worked closely with data manipulation teams to collect, clean, and structure data for optimal Tableau performance and
    accuracy.
     Identified and introduced new metrics and enhanced existing KPIs, continuously improving the quality of insights provided
    through dashboards.
     Extensively validated data using Excel as a preliminary step, ensuring consistency and accuracy before integrating into
    Tableau.
     Converted legacy Excel reports into dynamic Tableau reports, enhancing data visualization and user engagement.
     Created advanced Tableau functionalities such as action filters, parameters, and calculated sets to enable user-driven
    insights within dashboards.
     Leveraged Tableau’s data blending, filtering, and hierarchy features to provide a multi-dimensional view of the data,
    enabling deep-dive analysis.
     Defined and implemented best practices for Tableau report development, optimizing performance, readability, and data
    integrity.
     Developed custom SQL queries to pull data directly into Tableau, resolving inconsistencies, and improving data accuracy and
    accessibility.
     Conducted thorough testing of SQL queries and Tableau reports before deployment, ensuring reliability and completeness.
     Converted complex metric insights into visually intuitive Tableau reports, making data easier to interpret for stakeholders.
     Assisted end users with hands-on support, helping them create and modify Tableau worksheets and dashboards tailored to
    their unique needs.
     Integrated data from Teradata and other relational databases into Tableau, meeting various BI reporting requirements.
     Provided continuous support and troubleshooting for Tableau BI applications, ensuring uninterrupted access to data
    insights in production environments.
     Secured the Tableau server environment by configuring security settings, managing access controls, and integrating AWS
    Direct Connect for enhanced data security.
     Collaborated with Tableau Business Lines to manage and oversee Production, Test, and Development environments,
    ensuring data consistency and application stability.

Software Engineer

EY
07.2017 - 01.2019
  • Developed software solutions using Agile methodologies and best practices.
  • Collaborated with cross-functional teams to gather requirements and deliver projects.
  • Utilized version control systems for efficient code management and collaboration.
  • Implemented code reviews to ensure quality and maintainability of software.
  • Troubleshot and resolved software defects in a timely manner to enhance performance.
  • Assisted in testing processes to verify functionality and improve user experience.

Software Engineer

IBM
08.2014 - 05.2017
  • Implemented code reviews to ensure quality and maintainability of software.
  • Collaborated with cross-functional teams to gather requirements and deliver projects.
  • Troubleshot and resolved software defects in a timely manner to enhance performance.
  • Utilized version control systems for efficient code management and collaboration.
  • Documented technical specifications and user manuals for ongoing projects and applications.
  • Assisted in testing processes to verify functionality and improve user experience.

Education

Bachelor's - Computer Science

G.Pulla Reddy Engineering College
JNTU Anantapur
05-2014

Skills

  • Programming languages: Python, SQL, Java, Scala
  • Big data and cloud technologies: Apache Spark, Hadoop, AWS (Redshift, Glue, S3, Lambda, EMR, Athena, Kinesis), Azure (Data Factory, Synapse, Databricks, Cosmos DB)
  • Databases and data warehouses: Snowflake, PostgreSQL, MySQL, Oracle, SQL Server, MongoDB, Cassandra, DynamoDB
  • ETL and streaming technologies: Apache Kafka, Apache Flink, DBT, Azure Data Factory, Apache Airflow
  • Business intelligence and visualization: Tableau, Power BI, Matplotlib, Seaborn
  • DevOps and CI/CD: Terraform, Kubernetes, Docker, Jenkins
  • Data governance and security: Data masking, role-based access control (RBAC), GDPR
  • Machine learning and AI: TensorFlow, PyTorch
  • Workflow orchestration: Apache Airflow
  • Infrastructure and monitoring: ELK Stack (Elasticsearch), CloudWatch
  • Operating systems: Linux (Ubuntu), Windows

Certification

  • Splunk Enterprise
  • Google Cloud Platform Associate Cloud Engineer. (GCP)

Accomplishments

  • Client appreciation for creating a critical dashboards
  • Client appreciation for creating Splunk dashboard and managing those analysis metrics
  • Received written appreciation from Business leadership and Client manager for managing critical deliverables of the work within timeline.

Timeline

Sr. Data Analyst and Application Developer

Capital One
12.2024 - Current

Previous Project

Charles Schwab - NGOMS & QuotePlant
12.2023 - 11.2024

Senior Data Analyst

Advisor Services Technology (AST –RBS)
08.2023 - 12.2023

Application Development Analyst

Retirement Planning Services (RPS)
02.2019 - 08.2023

Senior Data Analyst

Charles Schwab
02.2019 - 10.2024

Software Engineer

EY
07.2017 - 01.2019

Software Engineer

IBM
08.2014 - 05.2017

Bachelor's - Computer Science

G.Pulla Reddy Engineering College
Rohini Tadimeti