Mohan V Email & Phone Number

New York, Ny, Us

Orchestrated large-scale data warehousing solutions using AWS Redshift, GCP BigQuery, and S3, facilitating scalable data access for complex analytics workloads across multiple business units.

Constructed and managed a global data repository on AWS S3 and Redshift, enabling centralized analytics and seamless reporting for international business units.Developed and streamlined ETL workflows using AWS Glue, processing over 50 million daily records to support scalable data warehousing for cross-departmental reporting needs.Utilized Fivetran for seamless data ingestion and synchronization across cloud applications, reducing manual ETL effort by 50% and enhancing data flow consistency from SaaS sources.Engineered hybrid data pipelines with Apache Kafka, GCP Pub/Sub, and AWS Kinesis, improving data delivery times and decreasing data lag by 35% to ensure up-to-date analytics.Leveraged AWS Athena for efficient SQL querying on S3-stored data, reducing infrastructure complexity and facilitating ad-hoc analysis on over 500 million records without added operational costs.Implemented Apache Zookeeper for robust Kafka cluster management, achieving high fault tolerance and reducing service outages by 40% for consistent data streaming.Designed advanced Snowflake and Redshift schemas, improving large-scale data retrieval speeds by 45% and optimizing query performance for real-time reporting.Developed intuitive Power BI and Tableau dashboards to visualize KPI metrics, empowering product and marketing teams with actionable insights for strategic decisions.Collaborated with engineering, operations, and data teams to refine data flows, decreasing ETL runtime by 20% and strengthening data integrity across reporting frameworks.Supported API-based integrations for cross-system data synchronization, fostering improved collaboration and real-time data sharing between analytics and operations teams.Enhanced distributed storage efficiencies on Elasticsearch and Cassandra, optimizing cluster performance to accelerate indexing and improve query response times across data-driven applications

Constructed data workflows for both batch and real-time processing using Azure Data Factory, GCP Composer, and Snowflake, accelerating data throughput and cutting processing times by 50%.Developed cross-functional ETL pipelines for integrating datasets from diverse sources, enhancing data consistency and minimizing discrepancies across internal and external systems.Developed scalable distributed data architectures leveraging GCP Dataproc, Hadoop, Spark, and Kafka, managing over 100 million records daily to enhance data accessibility and system performance.Optimized data schema structures to support robust analytics and reporting functions, boosting query efficiency by 30% and reducing computational load.Engineered API-centric data intake frameworks for CRM and external platform integrations, enabling real-time access to mission-critical data across the organization.Partnered with product, finance, and analytics teams to develop interactive Power BI and Tableau dashboards, empowering stakeholders with dynamic insights and fostering data-driven strategies.Instituted a proactive data governance model, ensuring data accuracy, access controls, and regulatory compliance to meet industry standards and safeguard information integrity.Automated data quality checks and validation processes within Azure Data Factory, increasing data accuracy by 40% and reducing manual intervention in data cleansing workflows.Implemented data partitioning and indexing strategies on Snowflake and Hadoop clusters, enhancing query performance and ensuring efficient resource allocation for large-scale analytics.Deployed robust monitoring and alerting systems for data pipeline health using Apache Airflow and custom scripts, minimizing downtime and enabling rapid response to data processing issues across environments.

B.E, Mechanical Engineering

Master Of Science, Information Systems Technology