Yogesh Bora

Worked on GCP-based data engineering and reporting solutions for regulatory and operational projects under the LUMI framework. Developed Pyspark-based ETL jobs to cleanse and aggregate data for dashboard consumption. Automated data workflows using GitHub Actions and version control for repeatable insights delivery. Ensured data quality and secure delivery with built-in SFTP, encryption, and alerting mechanisms. Additionally, worked as Data Analyst under same client, focusing on SQL-based data discovery, validation, and reporting across compliance and operational datasets.

Contributed to documentation and knowledge base updates for internal GCP best practices and data engineering workflows. Engaged in internal data initiatives and skill enhancement while awaiting client project allocation.

Led a team of 4, providing guidance and motivation for query resolution. Oversaw 30% of operations, simultaneously fulfilling the role of a Proactive data engineer. Implemented ETL process to streamline the import of data from various sources into Big Query warehouse by using SQL. Architecting and designing micro services and event-driven process leveraging Cloud Functions, pub/sub in Python. Architected and built large-scale batch data processing pipelines using Dataproc and Airflow for orchestration. Led the migration of a 100TB data warehouse from on-premises to BigQuery using Cloud Dataflow. Transformed raw data into actionable insights through optimized DAGs in Cloud Composer, driving 15 % improvement in operational efficiency for the team. Optimized end-to-end technical solutions, proactively addressing challenges, leading to a 10% decrease in project delivery time and heightened customer satisfaction. Enhanced data processing efficiency using GCP services (Big Query, Dataflow, GCE, Cloud functions, etc.), achieving a 30% improvement in issue resolution and an 8% cost reduction.

Innovated and implemented complex frameworks in Perl and Python, streamlining project development and ensuring alignment with business priorities and tight deadlines for optimal efficiency. Spearheaded the automation of product features, leading to significant sales enhancements; collaborated seamlessly with cross-functional teams to proactively address intricate technical challenges.

Led key contributions to Monolith tool development in Service Assurance, fostering collaboration with stakeholders, developers, QA, and customers for prompt resolution of intricate technical issues. Applied stringent code analysis methods to detect and rectify bugs and vulnerabilities, ensuring robust software quality and reliability in project delivery.

Identified operational inefficiencies, proposing improvements through meticulous analysis. Developed detailed project-level documentation, including proposals, sequence diagrams, and scope matrices, demonstrating strong analytical and documentation skills. Ensured data accuracy through rigorous validation and quality assurance assessments, showcasing meticulous attention to detail and commitment to maintaining high standards in process optimization and analysis.

Orchestrated end-to-end application design, assuming complete responsibility for development. Spearheaded collaboration with development team, crafting robust product support plans and prototyping initiatives. Led scaling efforts for current applications, guaranteeing adaptability to dynamic needs and sustaining optimal performance. Ensured seamless expansion by closely monitoring and enhancing application capacity in alignment with evolving requirements.

Developed and documented protocols for corrective and preventive maintenance, ensuring system compliance through meticulous procedural analysis. Managed project progress and budgets with meticulous record-keeping, ensuring transparency and accountability in maintenance operations.

Proactively resolved technical challenges by investigating and addressing root causes, ensuring swift resolutions. Conducted thorough source code analysis to rectify functionality issues and ensured compliance with system requirements. Strategically identified and implemented steps to bring systems into compliance, demonstrating a meticulous approach in maintaining optimal functionality and resolving technical issues promptly.