Learn Data Skills
Beta
Subramanian Kaushik Gurumoorthy

Subramanian Kaushik Gurumoorthy

Data Architect

Tata Consultancy Services | Toronto,Canada

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Data whisperer, turning numbers into captivating stories.

My Work

Take a look at my latest work.

DataLab

Competition - crowdfunding marketing

1Upvotes
DataLab

Course Notes: Joining Data with pandas

DataLab

World Population Data

DataLab

Competition - crowdfunding marketing

1Upvotes

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Teradata Teradata 12 certified technical specialist

Teradata Teradata 12 SQL Exam

Teradata Teradata 12 Certified Technical Specialist

Oracle Oracle Database SQL Certified Expert

Oracle Oracle PL/SQL Developer Certified Associate

Oracle Oracle Forms Developer Certified Professional

IBM Deep Learning Essentials

Datastax Apache Cassandra 3.x Developer Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate SQL
Data Manipulation with pandas

My Work Experience

Where I've interned and worked during my career.

Tata Consultancy Services | Jun 2023 - Jun 2025

Data Architect - Corporate Finance Data Migration

 Discovery of data assets: Identified and cataloged 10,000+ data assets across on-prem Netezza databases, SSIS pipelines, and SQL Server apps  Implemented config driven migration framework: Utilized a Python-based configuration generator with JSON/YAML templates to automate mapping rules for ingesting CSV, TSV, and fixed-width files into Redshift tables  Planned phased migration of deliveries: Defined a schema-driven migration roadmap using a homegrown data lineage discovery tool to trace table and column-level dependencies  Implemented cloud-native architecture: Contributed to the implementation of a scalable data Lakehouse using Amazon S3 for raw and curated zones, AWS Glue for transformation workflows, and Redshift as the enterprise query layer  Enhanced of data security: Implemented fine-grained access control using IAM roles and resource policies; enforced field-level encryption and decryption through in-built transformation functions within AWS Glue jobs, ensuring compliance  Built and deployed test data framework: Developed a reusable Python- based test data generation engine using the Faker library to simulate realistic datasets for functional and regression testing, reducing QA cycles by 30% and eliminating dependency on production data.  Planned releases and managed deployment: Led and coordinated 12+ manual deployment cycles, resolving codebase and repository dependencies to ensure smooth migration and validation of configuration scripts across environments without impacting production availability.  Recruited key talent: Partnered with delivery leadership to define role specs, screen cloud architects and data engineers, and onboard the team required to deliver the multi-phase migration roadmap  Validated post-migration accuracy: Built a Python-based reconciliation framework to compare statistics and sampled values between source (Netezza) and target (Redshift) to ensure integrity after each deployment.
Show More

Tata Consultancy Services | Jan 2020 - Jun 2023

Technical Architect – Corporate Technology / Market Risk

 Architected Data Mart: Led the design and implementation of a scalable SQL Server–based data mart to consolidate data from real estate and housekeeping systems, enabling centralized reporting and operational insights.  Gathered business requirements: Conducted sessions with business users and facility teams to capture KPIs, data sources, and reporting goals; translated them into ETL logic and technical specifications.  Modeled a unified data model: Developed logical and physical models using SQL Server Management Studio (SSMS) and ER modeling techniques, applying star schema design to unify disparate operational datasets.  Enabled self-service reporting: Created reusable SQL views and governed reporting layers to support business access through Power BI and SSRS, improving turnaround for ad hoc and scheduled reporting  Planned releases and managed deployment: Coordinated change requests, UAT validations, and manual deployments due to interdependent repositories, ensuring seamless rollout without user disruption  Delivered strategic dashboards to Business users: Designed and published real-time dashboards and paginated reports in Power BI and SSRS to provide actionable insights to business users  Provided warranty support and defect resolution: Supported stabilization phase post-deployment by addressing reported issues, fixing defects, and optimizing ETL performance for production workloads.

Tata Consultancy Services | Jun 2018 - Dec 2019

Senior Datawarehouse Administrator – Performance Center of Excellence

 Query Performance Tuning - Optimized complex SQL queries by analyzing execution plans, minimizing data redistribution, and leveraging zone maps and statistics.  Workload Management - Monitored concurrent user sessions and workload queues to ensure balanced resource allocation and query prioritization.  Distribution Key Design - Reviewed and implemented appropriate distribution keys to prevent data skew and enhance parallel processing performance.  Capacity Optimization – Helped IDP team to ensure that the growth of data is contained and not beyond a particular capacity before migration to a new appliance  System Monitoring & Alerts - Used IBM Netezza Admin Tools to monitor system health, disk usage, and CPU bottlenecks; configured alerts for proactive issue resolution.  Automation & Tooling - Created a custom utility to auto-generate statistics, trigger groom operations, and handle ad hoc data movement in and out of Netezza  Audit Reporting - Generated audit reports highlighting misuse of shared or unauthorized credentials and communicated findings to management for policy reinforcement  Team Onboarding & Training - Mentored and trained new team members on Netezza administrative best practices, internal tools, and operational procedures to ensure consistent team productivity and knowledge continuity

Tata Consultancy Services | Aug 2017 - May 2018

Technical Architect

Geek squad reporting and analytics team (Internal IT – Bestbuy Geek Squad) is involved in designing and deploying reporting models/reports to be used by the business users. They have deployed more than 100+ metrics and being used by business users. To streamline/standardize the metrics, GSRA team involved TCS , which would help in building a single mart layer for all the Services related operations of Bestbuy. Project involves 1. Dimensional modeling 2. Restructuring existing solution 3. Physical database design 4. ETL development 5. Reporting data models development

Tata Consultancy Services | May 2016 - Aug 2017

Senior Datawarehouse Administrator

 Teradata Administration - Led administration of Teradata systems (3 Enterprise Grade Appliance), managing workload distribution, user access, and performance tuning  Teradata Data Operations & Backup - Directed high-volume data operations and backup routines on Teradata  Teradata Performance Optimization - Monitored and tuned Teradata performance, resolving skewed queries and optimizing spool usage to maintain SLA compliance.  PDW Capacity Planning - Managed PDW resource planning, forecasting compute/storage needs and optimizing MPP performance across nodes  Netezza Operations & Data Integration - Led Netezza platform operations, executing NZLOAD/NZMIGRATE for ingestion and migrations; upgraded and stabilized environments post-deployment.  Netezza Security & Backup Administration - Administered Netezza security and recovery, enforcing access policies and managing backups through NetBackup integration.  Cross-Platform Performance Tuning - Tuned workloads across platforms, reducing ETL and batch runtimes by over 30% through SQL and pipeline optimization.  Team Leadership & Resource Management - Managed team of 8+ DBAs and support engineers, overseeing daily operations, resource planning, mentoring, and performance evaluations.  Project & Environment Delivery - Led project delivery and lifecycle management, coordinating environment builds, patch planning, and support transitions across Teradata, PDW, and Netezza platforms.  Critical Incident Resolution - Drove critical issue resolution via war rooms, coordinating with infrastructure, vendor, and business teams for root cause analysis and fast-track recovery.  Platform Maintenance & Upgrades - Executed system maintenance and version upgrades, planning and implementing Teradata, Netezza, and PDW upgrades with rollback strategies and regression testing.  Documentation & Compliance Support - Maintained technical documentation and audit compliance, delivering SOPs, DR plans, and infrastructure reports

Tata Consultancy Services | Sep 2013 - May 2016

Datawarehouse administrator

 Led administration of Teradata systems (3 Enterprise Grade Appliance), managing workload distribution, user access, and performance tuning using SQL Assistant, Viewpoint, and Teradata Administrator  Directed high-volume data operations and backup routines on Teradata using BTEQ, FastLoad, MultiLoad, TARA, and ARC, aligned with enterprise recovery policies.  Monitored and tuned Teradata performance, resolving skewed queries and optimizing spool usage to maintain SLA compliance. . Managed PDW resource planning, forecasting compute/storage needs and optimizing MPP performance across nodes  Led Netezza platform operations, executing NZLOAD/NZMIGRATE for ingestion and migrations; upgraded and stabilized environments post- deployment.  Administered Netezza security and recovery, enforcing access policies and managing backups through NetBackup integration.  Tuned workloads across platforms, reducing ETL and batch runtimes by over 30% through SQL and pipeline optimization.  Managed team of 5+ DBAs and support engineers, overseeing daily operations, resource planning, mentoring, and performance evaluations.  Led project delivery and lifecycle management, coordinating environment builds, patch planning, and support transitions across Teradata, PDW, and Netezza platforms.  Drove critical issue resolution via war rooms, coordinating with infrastructure, vendor, and business teams for root cause analysis and fast-track recovery.  Executed system maintenance and version upgrades, planning and implementing Teradata, Netezza, and PDW upgrades with rollback strategies and regression testing.  Maintained technical documentation and audit compliance, delivering SOPs, DR plans, and infrastructure reports to support internal and external reviews

Cognizant Technology Solutions | Jan 2010 - Sep 2013

Teradata Technical Specialist

N/A

Cognizant Technology Solutions | Mar 2012 - Dec 2012

Onshore coordinator

Responsiblities * Gathering requirements from clients and maintaining a teradata test data repository * Coordinating and managing multiple teams * Status reporting to stakeholders on Daily, weekly basis

iGATE Global solutions LTD | Oct 2008 - Jan 2010

Sr Software Engineer

Description This project was aimed at migrating all the JAVA web services used in NACS to .NET web services. This project required to complete the migration of all the JAVA web services consumed by NACS to .NET web services. Highlights Nominated for the prestigious 'CEO' award for the year 2008 Solution Environment UTL_HTTP built in Package, Oracle forms 6i,Oracle database 10g

iGATE Global Solutions | Jun 2007 - Jan 2010

Software Engineer

Project ---------- “New Assistance Computerized system” (NACS) using Oracle Forms 6i Customer -------------- Mondial – France Period ---------- June 2007 – Jan 2010 Work Location --------------------- Chennai Domain ----------- Health-care , Insurance Description ---------------- NACS is a Client\Server application developed by Oracle France. NACS assists users at Mondial to handle all the “assistance cases” from their clients. It helps to handle all the business process from data entry to Invoice and tracking the Invoice. It is being used in Asian countries like Japan, Thailand, Singapore and European countries like Belgium, Germany, Austria, Portugal Responsibilities ---------------------- Creating the physical database design and business logic implementation. Generating the database and Forms from Oracle designer Customizing the form fields using Oracle Forms developer Using Oracle translation builder for building Multi lingual form application Solution Environment ------------------------------- Oracle forms 6i and Oracle 10g, 8i

My Education

Take a look at my formal education

Master of Science - MS, Data science and Analytics  · (SeptemberToronto Metropolitan University | 2021
Bachelor of Engineering - BE, Electronics and CommunicationAnna University | 2007

About Me

Subramanian Kaushik Gurumoorthy

Accomplished Data architect and Technology Leader with 18+ years of experience Skilled in architecting enterprise data solutions, leading cross-functional teams, and driving business-aligned outcomes across finance, retail and insurance domains

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free