G
Gayathri Ramachandran
About
Detail
California, United States
Résumé
Jobs
verified_user
0% verified
BI DeveloperTata Consultancy Services (TCS)Jan 2023 - Dec 2023 (1 year)- Contractor - TCSDenken Solutions IncOct 2021 - Dec 2022 (1 year 3 months)• Created derived tables and views for sales KPIs including daily sales trends, YoY/ MoM growth, sales per store, and average basket size. • Performed ad hoc SQL analysis to answer business questions such as product performance by region, impact of discounts, and store-wise revenue growth. • Optimized slow-running queries by indexing, partitioning, and query rewriting, reducing execution time by up to 50%. • Developed and maintained end-to-end BI solutions in Power BI, leveraging advanced DAX, M Language, and complex data models to deliver interactive dashboards and business-critical reports. • Designed Power BI reports to track sales, product mix performance and campaign effectiveness enabling leadership to make informed, data-driven
- ETL DeveloperHCL Technologies LtdJul 2012 - Nov 2013 (1 year 5 months)• Designed and optimized SQL queries and stored procedures to extract and prepare data for reporting in Power BI and Excel.
- IJr. Data AnalystIvesia Solutions IncJul 2010 - Aug 2012 (2 years 2 months)• Collected, cleaned, and transformed datasets from SQL Server, Excel, and CSV sources to support reporting and ad-hoc analysis.
- Jr SQL DeveloperInfosys TechnologiesNov 2008 - May 2009 (7 months)• Wrote and optimized SQL queries, joins, and subqueries to retrieve and manipulate data for reporting and analysis. • Supported ETL processes by validating data loads and troubleshooting errors in staging and production environments. • Performed data cleansing and validation to ensure accuracy across business-critical datasets.
Education
verified_user
0% verified
- VBachelor of TechnologyVel Tech – Anna UniversityJan 2004 - Jan 2008 (4 years 1 month)