Ramaswamy K
Chennai,TN
Summary
Results-driven BI architect with extensive experience in data warehousing and ETL processes. Proven expertise in on-premises and cloud data warehouses, including Teradata, Snowflake, and BigQuery, ensures secure and reliable data solutions. Demonstrated leadership in managing medium-sized teams to successfully execute support and enhancement projects that consistently meet client expectations. Strong domain knowledge in the retail sector, particularly in sales and promotions, facilitates alignment of data strategies with business objectives.
Overview
24
24
years of professional experience
Work History
Consultant
Tata Consultancy Services
08.2018 - Current
- Delivered a migration from on prem to cloud for a major speciality retailer(Teradata to Snowflake)
- Led a team of 9 to deliver the above
- Conceptualized 2 accelerators which helped in delivering the project faster(saved at least 25% effort)
- Obtained CSI of 100%
- Currently working in Big Query and Google cloud in a major retailer
- Total snowflake experience of 5 years and Google cloud experience of 1 year
Associate Consultant
Tata Consultancy Services
06.2010 - 08.2018
- Weekly meetings with customer for prioritization of work and status updates
- Delivered design and architecture for a £125mn corporate initiative and drove the implementation for the same
- Addressed long standing issues which caused regular problems and reduced ticket volume
- Worked on forecasting report which went to CEO of speciality retailer to improve accuracy. Accuracy improved by 70%
- Worked on peak season initiatives to ensure data availability for executive team to enable decision making and ensured the same
- Ensured data availably at 9 am for executive teams while initially it was available only at 3 pm
- Worked on the project which was the first dashboard for the company and delivered the same. Was awarded best project for the same
- Co ordinated the testing efforts for upgrade
- Worked on disaster recovery when system had a production server crash and brought system back up to normal
Assistant Consultant
Tata Consultancy Services
05.2008 - 05.2010
- Worked on the ETL process of a leading insurance company and reduced the ETL cycle from more than 24 hours to 6 hours
IT Analyst
Tata Consultancy Services
06.2006 - 05.2008
- Worked in pre sales providing inputs to teams and working on customer proposals
- Worked on performance optimization and reduced query execution time from 9 hours to 1.5 hours
Software Engineer
Infosys Technologies Ltd
07.2001 - 04.2004
- Worked on the first Teradata project in the company in Chennai
- Reduced query execution time from 1.5 hrs to 15 minutes
Education
PGDM -
XLRI
04.2006
B.Tech - Civil Engg
IT-BHU
04.2001
Skills
- Proficient in Snowflake, BigQuery, and Teradata
- Experience with GitHub in continuous integration and delivery
- Experience in Microstrategy data reporting
- Minor Skills: Mainframe(JCL, Cobol), Unix Shell scripting, Databricks
Timeline
Consultant
Tata Consultancy Services
08.2018 - Current
Associate Consultant
Tata Consultancy Services
06.2010 - 08.2018
Assistant Consultant
Tata Consultancy Services
05.2008 - 05.2010
IT Analyst
Tata Consultancy Services
06.2006 - 05.2008
Software Engineer
Infosys Technologies Ltd
07.2001 - 04.2004
B.Tech - Civil Engg
IT-BHU
PGDM -
XLRI
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Venkadesh Kumar SVenkadesh Kumar S
Associate Consultant at Capgemini Technology ServicesAssociate Consultant at Capgemini Technology Services