Manikandan M
MANAGER, IT Analyst
Thoraipakkam
Summary
- Over 10 years of IT experience in Data Warehousing, ETL Development, and Business Intelligence, specializing in Snowflake & Teradata.
- Expertise in designing scalable, cloud-based data solutions, including data modeling, ingestion, transformation, and security in Snowflake.
- Strong experience in optimizing data pipelines, performance tuning, and automation using Snowflake best practices.
- Skilled in writing complex SQL queries, stored procedures, recursive queries, and advanced analytics functions within Snowflake and Teradata.
- Experience in data governance, security, and access management within Snowflake, AWS, and Teradata environments.
- Proven leadership experience managing teams, mentoring junior developers, and ensuring timely project deliveries.
- Strong knowledge in Banking and Retail domains, implementing FSLDM and RLDM data models.
- Adept at stakeholder management, translating business requirements into scalable data solutions, and driving business intelligence initiatives.
- Self-driven, adaptable, and quick to learn new technologies.
Overview
10
10
years of professional experience
4
4
years of post-secondary education
3
3
Languages
Work History
IT Analyst-Manager
Capgemini
03.2022 - Current
- Leading end-to-end data warehousing solutions using Snowflake, ensuring performance, security, and scalability
- Managing and mentoring teams as a Technical Lead – Data Warehousing, Development, and Solution Specialist
- Designing modern data architecture and implementing data pipelines using Snowflake, AWS, and ETL frameworks
- Driving data migration from on-premises Teradata to Snowflake, optimizing storage and query performance
- Automating ETL processes using Snowflake Streams, Tasks, and Stored Procedures
- Collaborating with stakeholders to define data governance, security policies, and access controls
- Performance tuning of Snowflake queries, optimizing compute costs and improving data processing efficiency
- Integrating third-party tools like DBT, Informatica, and Airflow for seamless data transformations
- Ensuring adherence to best practices for cloud data security and compliance
Senior Associate
Cognizant
04.2020 - 03.2022
- Developed data warehouse solutions, transitioning from Teradata to Snowflake for regulatory reporting
- Designed and optimized ETL workflows, improving data ingestion and transformation processes
- Implemented automated data validation checks in Snowflake to ensure data accuracy and consistency
- Created stored procedures and functions in Snowflake for handling business rules and transformations
- Provided impact assessments and performance tuning recommendations before production deployment
- Built dashboards and reports to visualize regulatory compliance metrics
- Client: KBC Bank, Belgium
- Project: Teradata Development (Rainbow – IFRS17)
- Tools: Teradata 15.10, UNIX, Snowflake
- Team Size: 10
Senior Software Engineer
HCL
09.2018 - 04.2020
- Led data integration projects, designing robust ETL pipelines to migrate data from multiple sources to Teradata/Snowflake
- Developed and optimized SQL queries for better performance and reduced execution time
- Implemented data security policies to comply with enterprise standards
- Provided production support and performance tuning to improve system efficiency
- Managed business intelligence reports and enhanced data visualization capabilities
- Client: True Value, US
- Project: Teradata Development (Customer Focused Vision)
- Tools: Teradata 15.10, UNIX, Snowflake
- Team Size: 10
Associate Consultant
Capgemini
03.2015 - 08.2018
- Worked on production support, monitoring, and troubleshooting data warehouse processes
- Provided emergency fixes and permanent solutions to recurring issues
- Automated data processing scripts to optimize performance and reduce manual effort
- Created data reconciliation frameworks to ensure data accuracy across systems
- Designed data pipelines to transition from Teradata to Snowflake, improving performance and scalability
- Conducted team training sessions and technical knowledge transfers
- Assisted in defining cloud data strategies for NORDEA’s next-generation data warehouse
- Client: NORDEA Bank
- Project: Application Maintenance (Business Reporting)
- Tools: Teradata 15.10, UNIX, Snowflake
- Team Size: 15
Education
Bachelor of Engineering -
VEL TECH HIGHTECH Dr.RR & Dr.SR Engineering College (Anna University)
Chennai 01.2010 - 03.2014
Skills
- Snowflake
- Teradata 16
- Informatica
- ETL Framework
- Data Modeling
- SQL
- UNIX
- Basic Python
Achievements Recognitions
- Recognized as a Star Performer at Capgemini (2016) for defect-free project deliveries.
- Received Bonus in all quarters of 2017 for outstanding performance.
- Successfully led cloud migration and implemented Teradata Vantage AWS server migration.
- Spearheaded the migration of legacy ETL processes to Snowflake, improving processing speed by 40%.
- Optimized Snowflake compute usage, reducing cloud costs by 30%.
Disclaimer
I hereby declare that the information provided is true and correct to the best of my knowledge.
Education Certifications
- Bachelor of Engineering, VEL TECH HIGHTECH Dr.RR & Dr.SR Engineering College (Anna University), 2014
- Snowflake SnowPro Certification, Ongoing
- Teradata 14 Certified Professional
- Safe Agile 6 Certified
Timeline
IT Analyst-Manager
Capgemini
03.2022 - Current
Senior Associate
Cognizant
04.2020 - 03.2022
Senior Software Engineer
HCL
09.2018 - 04.2020
Associate Consultant
Capgemini
03.2015 - 08.2018
Bachelor of Engineering -
VEL TECH HIGHTECH Dr.RR & Dr.SR Engineering College (Anna University)
01.2010 - 03.2014