Brian Denis Castelino

Brian Denis Castelino

Data Analyst | Product Analyst | AI/ML Enthusiast
Open To Relocate, United States of America.

About

Highly analytical Data Analyst with 4+ years of experience in optimizing AdTech performance through data-driven solutions and advanced analytics. Proven ability to automate complex workflows, implement A/B testing, and leverage AI/ML for impactful insights, driving significant improvements in efficiency, accuracy, and client retention. Seeking to apply expertise in data modeling, engineering, and AI to solve complex business challenges.

Education

George Mason University
Fairfax, VA, United States of America

Masters of Science

Data Modeling/Warehousing and Database Administration

Grade: 3.8/4

University of Mumbai
Mumbai, Maharashtra, India

Bachelor of Engineering

Information Technology

Work

George Mason University – SEOR Dept
|

Graduate Teaching Assistant

Fairfax, VA, US

Contract

Summary

Led weekly sessions for 40+ students, focusing on Excel modeling and Python-based interactive labs to enhance learning outcomes.

Highlights

Guided 40+ students weekly in Excel modeling using Frontline Solver simulations, boosting student accuracy in linear and mixed-integer optimization problems by 30%.

Facilitated interactive Gurobi labs in Python, elevating student engagement scores by 20% through hands-on learning experiences.

Media.Net Software Services Pvt. Ltd.
|

Senior Product Analyst

Mumbai, Maharashtra, India

Full-Time

Summary

Collaborated with cross-functional teams to deliver data-driven AdTech solutions, enhancing performance and optimizing campaigns.

Highlights

Implemented 10+ weekly A/B testing environments using in-house tools, boosting recommendation accuracy by 50% and increasing campaign ROI by 70%.

Automated key workflows using Python, Excel, and SQL, decreasing manual effort by 50% and improving data clarity.

Directed end-to-end execution of 5+ initiatives via Jira and Confluence, achieving 100% on-time delivery.

Mentored 10 junior analysts in ETL design, SQL querying, and business reporting, increasing team productivity by 40%.

Media.Net Software Services Pvt. Ltd.
|

Product Analyst

Mumbai, Maharashtra, India

Full-Time

Summary

Developed automated data ingestion and transformation procedures for ad-serving data, improving delivery and client retention.

Highlights

Developed stored procedures to automate ingestion and transformation of 5+ GB of ad-serving data into SQL Server using Python and Excel, reducing batch processing time by 50%.

Collaborated with engineering to integrate new ad platforms via REST APIs, increasing impression delivery by 20%.

Delivered weekly campaign performance insights and optimization reports to 10+ clients using Tableau/Excel, boosting client retention by 10%.

Skills

Artificial Intelligence (AI)

LangChain, Faiss, LLMs, AI-powered RAG, VectorDB, Hugging Face, Prompt Engineering.

Cloud Platforms

AWS (S3, Lambda, RDS, Glue, DynamoDB, SageMaker), GCP (BigQuery, Vertex AI), Azure Data Factory.

Data Engineering

ETL Pipeline, Apache Airflow, Beam, Spark, Kafka, dbt, Snowflake, Databricks, Redshift, Delta Lake.

Databases

MS SQL Server, MySQL, PostgreSQL, MongoDB, Hive, Oracle, Elasticsearch, Redis, NoSQL, Airtable.

Libraries & Frameworks

Pandas, NumPy, Scipy, PyTorch, TensorFlow, scikit-learn, XGBoost, LightGBM, spaCy, NLTK, R.

Business Reporting

Google Data Studio, Power BI, Tableau, Looker, Salesforce, Excel (Pivot Tables, Macros), MS Office.