Roopachandran Chandran

As a Data Engineer, I played a pivotal role in designing and implementing robust data pipelines for a large-scale analytics project. My responsibilities included:

• Data Ingestion: Leveraging technologies like Cloud Pub/Sub, Cloud Dataflow, and Apache Beam, I developed efficient pipelines to ingest and process terabytes of data daily from Teradata and Oracle sources.
• ETL and Data Transformation: Utilizing tools such as Cloud Dataprep and Dataflow, I transformed raw data into structured datasets, ensuring data quality and consistency for analysis.
• Data Modeling: I designed optimized data models on BigQuery to support complex analytical queries and reporting requirements.
• Real-time Analytics: Implemented real-time streaming analytics solutions using Cloud Dataflow and BigQuery streaming inserts to provide immediate insights.
• Technology Stack: Proficient in a wide range of technologies, including Oracle, Teradata, Hive, Pyspark, Google BigQuery, Looker, Tableau, Apache Nifi, DBT, and Google Cloud.
• Collaboration: Worked closely with cross-functional teams to understand business needs and deliver effective data solutions on GCP.
• Migration: Led the migration of data from Teradata to Google BigQuery and Hadoop Hive, utilizing tools like PySpark and TPT/Bteq scripts.

This experience has equipped me with a strong foundation in data engineering and a deep understanding of cloud-based data solutions.

Data Engineering Lead at Verizon

• SQL Performance Tuning and Data Modeling: Led SQL performance optimization initiatives and designed robust data models for critical applications.
• Large-Scale Data Management: Managed and analyzed over half a billion records, overseeing storage, data analysis, and manipulation.
• Process Optimization and Performance Improvement: Successfully consolidated processes, resulting in a 65% reduction in objects maintained and a 50% performance boost.
• Team Leadership and Collaboration: Led regular meetings, supervised quality assurance, and collaborated with data scientists on machine learning models.
• Web Reporting and Stakeholder Management: Managed a web reporting application with 100+ reports for 10,000+ users, serving as the primary point of contact for stakeholders and customers.
• Technical Expertise: Proficient in Oracle PL/SQL, Cassandra, K2View, Python, Datastage, and ETL job tuning.

Key Achievements:

• Developed PL/SQL programs and created DB objects.
• Implemented materialized views and logs.
• Maintained and monitored Datastage jobs.
• Collaborated with data scientists on machine learning models

• Worked as a Contractor for Verizon Technologies from Mastech Inc using technologies like Datastage, Oracle PLSQL, Unix Shell Scripting

Company Overview: FedEx is a global leader in transportation, logistics, and e-commerce solutions. We offer a comprehensive suite of services to individuals and businesses worldwide, enabling seamless movement of goods and information.

Agile Methodology:

• Proficient in Agile development methodologies, including Scrum and Kanban.
• Collaborated with cross-functional teams to deliver high-quality solutions within tight deadlines.

Business Analysis and Requirements Gathering:

• Conducted in-depth analysis of the FLAGS application to identify functional gaps and inefficiencies.
• Developed comprehensive business requirements documents based on identified needs and stakeholder input.

Data Modeling and Database Design:

• Redesigned the FLAGS application's data model using SQL Developer Data Modeler to optimize performance and scalability.
• Developed PL/SQL programs and created essential database objects, including tables, indexes, packages, procedures, functions, triggers, and views.
• Implemented materialized views and logs to enhance data accessibility and performance.
• Collaborated with data modelers and source system teams to understand data feeds, ensuring data integrity and consistency.

Database Optimization and Performance Tuning:

• Conducted performance tuning and optimization of database objects and queries in the Oracle environment.
• Implemented strategies to improve query execution times and resource utilization.

Reporting and Analytics:

• Created new reports using Tibco Spotfire to provide valuable insights into business operations and performance.

Application Database Administration:

• Contributed to application database administration tasks, including user creation, tablespace management, and import/export operations.

Key Skills:

• Agile methodologies
• Business analysis
• Data modeling
• PL/SQL
• SQL Developer Data Modeler
• Database optimization

By incorporating these enhancements, the revised experience highlights your technical skills, problem-solving abilities, and contributions to the team

Company Overview: General Motors (GM) is a global automotive leader headquartered in the United States.

Key Responsibilities:

• Data Warehouse Analysis and Optimization:Assessed DWH system performance and identified areas for improvement.
  Documented recommendations to enhance ETL job efficiency and reduce data redundancy.
  
• Database Development and Management:Created PL/SQL programs and database objects (tables, indexes, packages, procedures, functions, triggers, and views).
  Optimized long-running queries within procedures, packages, and materialized views.
  Designed stage tables to accommodate data from new source systems.
  Performed application DBA tasks, including user and tablespace creation and job scheduling using Crontab.
  
• Data Mapping and ETL Development:Developed source-to-target field mapping matrices, detailing business rules, transformation logic, and table load strategies.
  Collaborated with ETL developers to ensure efficient data extraction, transformation, and loading.
  
• Performance Optimization:Tuned ETL jobs and Oracle SQL scripts, including table partitioning strategies, parallel read hints, and indexing.
  

Company Overview: DirecTV is a leading provider of satellite television services in the United States.

Key Responsibilities:

• Project Management: Managed project estimation, documentation, and development processes.
• Technical Design: Prepared detailed design documents for project implementation.
• Database Optimization: Performed SQL performance tuning and optimization to improve query execution times.
• Tool Configuration: Configured the Comergent tool for project-specific requirements.
• Client Communication: Participated in daily status and review meetings with clients to ensure project alignment and progress.
• Team Support: Provided technical assistance and guidance to team members.
• Quality Assurance: Developed and reviewed test cases, prepared test data, and documented test results to ensure code quality and functionality.

Company Overview: ORION is an enterprise resource planning (ERP) solution developed by 3i-Infotech Ltd.

Key Responsibilities:

• Module Development: Developed a new forecasting module within the ORION product, tailored to the specific needs of RED Entertainment and integrated with their sales processes.
• Module Implementation: Successfully implemented the forecasting module at the client site and provided comprehensive user training.
• Report Development: Created new reports in D2K to address customer-specific requirements and support business operations.
• Technical Training: Trained the technical team at RED Entertainment on Discoverer reporting tools and developed and deployed over 10 reports within the Discoverer environment.