Prateek SINHA

– Led the design, automation, and governance of end-to-end data infrastructure and analytics pipelines to support real-time insights, regulatory reporting, and strategic alignment across business units to support strategic decision-making and operational efficiency. – Designed and managed end-to-end data infrastructure across Rudderstack, Braze, Amplitude, Snowflake, AWS S3, AWS Redshift, AWS (Lamda and Glue), Salesforce, and SAP, supporting cross-platform event streaming and analytics. – Built real-time data pipelines from mobile apps, CRM systems, and backend services into Snowflake and CDP (Rudderstack), ensuring enterprise MarTech deployment and success. – Architected and deployed large-scale ETL / Reverse ETL pipelines on AWS & Snowflake using Apache Airflow (managed) and native AWS services. Ingested 1B+ records/month from iOS/Android apps, React web, Salesforce CRM, Rudderstack CDP, and Braze into Amazon Redshift (primary warehouse) with S3 as the data lake layer. – Designed Airflow DAGs with Python/Bash operators, sensors, retries, SLAs and idempotent backfills, integrated with CloudWatch and Grafana for logging and alerting ~45% reduction in pipeline failure resolution time. – Scripted and owned all native pipeline-level transformations including GDPR compliant hashing, HIPAA-compliant PHI/PII data transformations using DBT-style multi-layer models (raw staging → curated core → BI-ready marts) on Redshift – Maintained enterprise Data Glossary and KPI definitions, aligning Marketing, Sales, Compliance, and Product teams on key metrics. – Built and maintained DBT pipelines for data transformation, implementing tests, documentation standards and lineage tracking across 30+ models and deployed Airflow and data pipelines using Docker containers and Kubernetes, achieving automated scaling and 40% improvement in resource utilization

– Drove data strategy and performance analytics to optimize platform growth, regulatory compliance, and investor insights. – Built end-to-end multi-layer ETL pipelines on GCP: Composer, Google Analytics, GTM, DAGS, BigQuery: Implemented partition strategies (date-based) and clustering (high-cardinality columns) with 60% reduction in query latency, migrated legacy infrastructure to cloud. – Built cross-platform dashboards (BigQuery, Tableau) for Platform analytics for marketplace traffic seasonality and monitoring with Tableau and Looker Studio and establishing ETL pipelines with PostgreSQL, BigQuery and Google Cloud enabling a 300% increase in fund listings through actionable visibility. – Automated compliance reporting workflows using Python and REST APIs, reducing processing time from 21 days to <4 hours, enhancing regulatory auditability and operational efficiency.

– Spearheaded data-driven pricing strategy and analytics across European markets by designing dynamic models, optimizing data processes, and delivering actionable insights to support product rollout, revenue growth, and M&A decisions. – Designed and implemented a dynamic B2C pricing model based on a logarithmic curve, incorporating variables such as competitor pricing, seasonality, proximity to transport, and promotions, leading to increased commercial margins and roll-out across multiple markets using Python (Pandas, scikit-learn) and AWS (Glue, Redshift, S3, Lambda). – Conducted competitive benchmarking and industry mapping across 7 European countries to support pricing and market entry decisions. – Built a Python-based pricing engine using AWS (Glue, Redshift, S3) to process structured datasets and simulate pricing behaviors; Designed AWS Glue (serverless Spark) ETL pipelines to extract from multiple sources, transform via distributed jobs, load into Redshift. – Delivered analytical reports and cash flow forecasts for stakeholders and supported due diligence efforts for M&A evaluations, factoring in traffic, spend patterns, and demand elasticity.

– Led strategic and operational initiatives across investor relations, compliance, and driving cross-functional team performance in finance, healthcare, and data-driven sectors. – Held cross-functional leadership roles, managing investor relations, compliance, and multi-sector project delivery across private equity, healthcare, and data infrastructure – Acted as contact point for all investor relations issues and corporate communications – Involved in Fund Compliance team and raised capital of US$ 1 Million via Singapore Private Equity. – Reported to Managing Director and Director (Finance) on a regular basis with Investment Analysis and Financial Statements based on performance of assets and revenue per mbps of data (KPI analysis)

– Led a multi-sector division involved in raising capital, delivering revenue-generating projects, and driving cross-functional team performance in healthcare projects. – Led multi-domain team of 25 across medical tourism and finance consulting. – Delivered INR 1.5 million revenue within 3 months of project commencement. – Managed lead generation, client interfacing, patient operations, end-to-end patient-care ecosystem and business development.