Saransh A.

Responsible for the Partner Analytics domain at Prime Video, owning data and infrastructure across TVOD, subscriptions, playback, and performance reporting. This involves working across AWS Glue, Apache Iceberg, EMR-Serverless, ClickHouse, Athena, Lambda, Step Functions, and DynamoDB - delivering data products that power partner-facing APIs, self-serve dashboards, and ML pipelines.

https://www.dataengineerthings.org/team/

Responsible for large-scale data infrastructure and analytics for AWS products like EC2 and Container services, spanning ETL orchestration, compliance, data modeling, and compute optimization on petabyte-scale datasets. Worked across Redshift, Athena, Apache Iceberg, Kinesis, EMR-Serverless, S3, Lambda, SQS, SNS, and CDK.

Business Intelligence Systems

• Working on creating an ETL pipeline & database for querying, displaying and generating reports for ~ 65,000 K-12 teachers and administrative staff • Refactoring stored procedures and SQL code, by understanding stakeholder requirements to access filtered data at a granular level

• Built a scalable tool automating SEC filing’s data ingestion, saving 2600+ manual hours/year, & reducing cost of services by $165k/year • Assisted in the creation of the product roadmap by prioritizing features, creating product requirement documents, defining user stories, and coordinating with cross-functional teams such as engineering, design, and marketing, and content team • Conducted in-depth market analysis, customer surveys & interviews, gaining valuable insights into user needs and preferences • Worked with leadership to develop dynamic Weekly Operational Report (WOR) using Tableau & SQL, to monitor tool’s performance and metrics such as accuracy, manual hours saved, number of data-points/file automated, etc. • Collaborated with Sales & Marketing teams to prepare GTM collaterals to showcase product offering, features and future vision

• Statistically analyzed error logs & geospatial (GIS data) for more than 120k users to enhance customer experience & satisfaction • Generated Power BI dashboards to track & resolve issues by performing root cause analysis, reduced complaints by 13%

Specialization : Product Management and Business Intelligence Courses: IMT 580 Management & Strategic Leadership IMT 573 Data Science I: Theoretical Foundations IMT 500 Foundations Of Information Management IMT 543 Relational Database Management Systems IMT 574 Data Science II: Machine Learning and Econometrics IMT 550 Policy And Ethics In Information Management