Rakesh Kuchana
Senior Associate - Projects
Hire this person
Send a job offer directly to this candidate
About
Senior Data Engineer with 5+ years building production cloud data platforms on AWS and Snowflake, backed by 16+ years across IT, analytics and financial reporting. Hands-on with Python, PySpark, SQL, Airflow and dbt experienced in insurance and retail domains where reconciliation accuracy, regulatory reporting and auditability. Comfortable owning a pipeline end to end, from ingestion and encryption through orchestration, CI/CD and production support.
Experience
Senior Associate - Projects at Cognizant Technology Solutions India Pvt Ltd (2021-09 – Present)
- Travelers Indemnity project (03/2023 to Present): Data Engineer specializing in AWS S3 data lakes for the insurance domain, focusing on ETL pipelines, data reconciliation, and compliance-ready data management.
- Integrated S3 with Athena, Glue, and Redshift to deliver regulatory reporting and actuarial insights.
- Developed shell scripts and Python automation for file monitoring, missing raw file alerts, and dynamic Excel reporting updates.
- Designed and maintained CI/CD pipelines using Jenkins and UrbanCode Deploy (UCD) alongside Git version control.
- Scheduled and managed Autosys jobs, optimizing dependencies and execution schedules to handle raw financial data efficiently.
- JLP (John Lewis Partnership) project (18 months): Developed and maintained Snowflake-based data pipelines and complex SQL/Python procedures for high-performance data processing.
- Configured and managed Airflow DAGs for data workflows, integrating cloud-based storage services (AWS, Azure Data Lake Storage, and Google BigQuery).
- Implemented file transfer workflows from SFTP to GCS, handling trigger files, decryption, re-encryption with Cloud KMS, and staging into Snowflake curated layers.
- Built data marts in the consume layer from un-nested curated data to support Looker visualization teams.
- Processed and analyzed large datasets stored in HDFS using PySpark applications and Spark-submit.
Python Developer at IBM India Private Limited (2021-01 – 2021-09)
- Developed code in PyCharm and executed scripts in Unidata to retrieve required details.
- Managed user stories on Azure DevOps and participated in daily scrum meetings.
- Handled production support alerts by running SQL queries in databases and restarting servers via Linux commands.
- Generated demographic reports from the IBM Cognos tool and automated batch file movements.
Senior Analyst at IBM India Private Limited (2013-06 – 2021-01)
- Generated reports using the IBM Cognos tool per client requirements.
- Managed daily, weekly, and monthly reports in Salesforce for management dashboards and team productivity tracking.
Senior Process Associate in US Tax at Thomson Reuters (2010-07 – 2013-05)
- Updated sales tax tools daily with revised tax rates.
- Generated comprehensive reporting deliverables for the entire team.
Education
MBA in Finance & HR – ICFAI National College, Hyderabad (2005 – 2007)
B.Com in Computers – Osmania University, Hyderabad (2002 – 2005)