Data Engineer Senior
Resume:
Sutirtha Roy
E: ********.*******@*****.***
Professional Summary
Results-driven Senior Data Engineer with 19+ years of experience designing, developing, and optimizing large-scale data architectures, ETL pipelines, and cloud-based solutions. Expertise in Big Data, Cloud Computing (GCP), Data Warehousing, and Business Intelligence. Strong background in Agile development, database optimization, and process automation, with a proven ability to lead cross-functional teams and deliver high-impact data solutions. Passionate about enhancing data-driven decision-making through robust, scalable systems.
Core Competencies
Big Data & Cloud Technologies: GCP, Big Query, GCS, Google Cloud Functions
Data Engineering & ETL Pipelines: Oracle Data Integrator (ODI), Apache Airflow, PL/SQL
Database Design & Performance Optimization: Oracle, Sybase, SQL Tuning, Data Modeling
Business Intelligence & Analytics: Cognos,, Oracle Discoverer
Agile & Project Management: Agile/Scrum, Risk Management, Cross-Functional Collaboration
Data Security & Compliance: Governance, Secure Access Controls, Data Quality Management
Professional Experience
Google LLC, Sunnyvale, CA
Senior Data Engineer Technical Lead
May 2021 – Present
Designed and implemented scalable ETL pipelines for enterprise-wide data integration and analytics.
Spearheaded automation of document processing workflows, reducing manual effort by 70%.
Optimized data pipelines, cutting failure rates from 12.5% to 0.4% YoY using proactive monitoring solutions.
Developed cloud-native solutions leveraging BigQuery, GCS, and Python, ensuring high availability and reliability.
Led cross-functional collaboration between engineering, product, and finance teams to enhance contract data management accuracy to 85%+.
Alphabet Inc. (Google Finance Operations)
Lead Data Engineer
Jan 2016 – May 2024
Architected Google Core Reporting Engine (GCORE), a high-availability data warehouse that reduced financial reporting time by 70%.
Designed and maintained secure, scalable financial data pipelines, supporting over 1,000+ financial analysts and executives.
Integrated financial data from SAP, Oracle, and BigQuery, creating a unified analytics platform.
Established best practices in data governance and compliance, ensuring seamless data security enforcement.
ASCENA Retail, Somerset, NJ
ETL Lead Data Architect
Sep 2014 – Jul 2016
Optimized ETL workflows, reducing batch execution time by 30% through query tuning and parallel processing.
Led Retail Management Systems (RMS) transformation, ensuring high data integrity and reliability.
Designed data models and reporting solutions using Oracle, ODI, and Cognos BI.
NYK Business Systems Americas, Secaucus, NJ
Business Intelligence & ETL Lead
Feb 2012 – Sep 2014
Developed scalable BI solutions, integrating data from Sybase, Oracle, and Cognos BI.
Led a team of 8 developers, ensuring seamless ETL and analytics development.
Standardized data pipelines, reducing manual intervention and enhancing data processing efficiency.
British Telecom, U.K,
Sr. ETL/Integration Developer
Jun 2010 to Feb 2012
Designed and developed a centralized data warehouse, extracting data from heterogeneous source systems, transforming it per business logic, and loading it into the target environment using Oracle Data Integrator (ODI).
Developed workflow automation to streamline ETL processes and enable real-time reporting using OBIEE, improving system transparency and reducing data processing time by 30%.
Designed automated monitoring solutions to track data quality, pipeline failures, and performance, ensuring 99.9% uptime for reporting systems.
Optimized query performance and indexing, enhancing data retrieval speed by 40%.
Senior Data Engineer Oracle Corporation, India
Oct 2006 – Jun 2010
Project Orion and Business Transformation
Led the ETL development for data migration from legacy systems to Oracle databases using ODI.
Designed and optimized data pipelines, reducing failure rates from 12.5% to 0.4% YoY.
Automated reporting workflows, saving 1,500+ manual work hours per year.
Managed data security protocols, ensuring compliance with industry standards.
Technologies Used: Oracle 10g, ODI, OBIEE, TOAD, SQL, PL/SQL
ETL Developer BOSS Lab (B-SOURCE), Switzerland
Dec 2005 – Oct 2006
Project: Data Migration Strategy
Migrated data from ADABAS to Oracle RDBMS, ensuring smooth transition during platform upgrade.
Designed ETL mappings to automate data extraction, transformation, and loading.
Conducted performance tuning to improve query execution by 40%.
Developed data reconciliation scripts to validate migration accuracy.
Technologies Used: Oracle 9i/10g, OWB, SQL, Data Modeling, ETL Testing
Education
Bachelor of Engineering (Electronics & Communication)
Technical Skills
Cloud Platforms: GCP, Big Query, GCS, Terraform
ETL & Data Engineering: Oracle Data Integrator (ODI), Apache Airflow, PL/SQL, Python
Big Data & Analytics: SQL, Pandas
Reporting & BI:, Cognos
Version Control & CI/CD: Git, Jenkins
OS & Servers: Unix, Windows Server
Certifications & Training
Google Cloud Professional Data Engineer Training (2023)
Oracle Data Integrator Developer/Admin (Oracle, 2010)
Agile & Scrum Master Training
Key Achievements
Designed and implemented ETL pipelines processing petabyte-scale datasets with 99.9% uptime.
Reduced ETL execution times by 40%+ through SQL optimization and parallel processing.
Automated key business workflows, saving 1,500+ manual work hours per year.
Developed scalable data governance frameworks, ensuring 100% compliance with security policies.
Contact this candidate