Jayanth Ramachandran Pathaneni

Business Analyst

Hyderabad, Telangana, India3 yrs experience
Highly Stable

Key Highlights

  • Expert in SQL and database management.
  • Proven track record in data integrity and reporting efficiency.
  • Strong collaboration skills with stakeholders for data solutions.
Stackforce AI infers this person is a Data Analyst and Database Administrator specializing in SaaS environments.

Contact

Skills

Core Skills

SqlDatabase ManagementQuery OptimizationData Warehousing ConceptsData Validation

Other Skills

ExcelData AnalysisETLKPI AnalysisPerformance TuningData ModelingData CleansingPower BIServiceNowJiraGitMicrosoft Power BIBackup & Recovery SystemsAutomation and ScriptingRequirement Gathering & Business Analysis (BRD/FRD)

About

Data delays, performance bottlenecks, and inconsistent reporting can disrupt critical business decisions — I focus on solving these through data analysis, SQL optimization, and database administration. I’m a Data Analyst and Database Administrator with hands-on experience working across MySQL, PostgreSQL, and Oracle environments. My core focus is on managing data end-to-end — from extraction and transformation to validation, performance tuning, and reporting — ensuring high data accuracy, availability, and efficiency. In my role, I design and execute complex SQL queries using joins, subqueries, CTEs, and window functions to analyze large datasets and generate business insights. I perform data profiling, cleansing, and validation to maintain data integrity and consistency across systems. From a database administration perspective, I work on query optimization, indexing strategies, execution plan analysis, and performance tuning to improve query efficiency and reduce latency. I also monitor database health, troubleshoot performance issues, and support production environments by resolving data discrepancies, handling incidents, and ensuring minimal downtime. Additionally, I have experience supporting ETL workflows, validating source-to-target data loads, and working with data warehouse concepts such as star schema, dimensional modeling, and ERD design. I collaborate closely with stakeholders to understand reporting requirements, perform KPI analysis, and translate business needs into scalable data solutions. I am currently looking to further expand my expertise in ETL tools, data engineering, and advanced database management while contributing to data-driven decision-making and high-performance systems. If you’re looking for someone who combines strong SQL expertise, database administration skills, and analytical problem-solving — let’s connect.

Experience

Hcltech

Data Analyst | SQL & Database Support

Mar 2023Present · 3 yrs · Chennai, Tamil Nadu, India · Hybrid

  • Developed complex SQL queries to extract and transform large datasets using joins, aggregations, and window functions, improving reporting efficiency by ~30%.
  • Validated datasets and performed KPI reconciliation using SQL and Excel, reducing data inconsistencies by ~25% across reports.
  • Optimized query performance through indexing and execution plan analysis, reducing query execution time by up to 40%.
  • Designed reusable Excel-based reporting models and templates, improving report generation turnaround time by ~20%.
  • Analyzed data discrepancies by comparing source and target systems using SQL, ensuring high data integrity and accuracy for business reporting.
  • Supported data workflows aligned with ETL processes by validating data loads and transformation logic, minimizing reporting errors and production issues.
  • Collaborated with stakeholders to gather business requirements and translated them into technical solutions using BRD/FRD documentation, enhancing requirement clarity and delivery accuracy.
  • Documented data transformation logic, schema definitions, and business rules, improving knowledge sharing and reducing onboarding time for new team members.
  • Identified and resolved production data issues by performing root cause analysis using SQL queries and logs, reducing issue resolution time (TAT).
  • Database Performance Optimization
  • Improved query performance by implementing indexing and optimizing joins, reducing execution time from ~8s to ~2s (~75% improvement)
  • Data Warehouse Reporting
  • Developed star schema data model for reporting using SQL, improving query simplicity and dashboard performance
  • ERD & Schema Validation
  • Redesigned database schema using normalization techniques, reducing redundancy and improving data consistency
SQLExcelQuery OptimizationData AnalysisETLData Validation+2

Education

KL University

Bachelors of Technology(B.Tech) in Computer Science and Engineering

Jul 2018Jun 2022

NARAYANA JUNIOR COLLEGE --Rajahmundry , Andhra pradesh

INTERMEDIATE

Jun 2016Apr 2018

NALANDA VIDYALAY, Ahmedabad, Gujarat

SSC(10TH CLASS)

Jun 2015Mar 2016

upGrad.com

Professional Certificate Program in Business Analytics & Consulting in association with PwC academy — Business Consulting

Jul 2025Present

Stackforce found 100+ more professionals with Sql & Database Management

Explore similar profiles based on matching skills and experience