Open to opportunities

Puja Roy

@pujaroy

Message

Data Analytics & Reporting Engineer delivering scalable BI, faster SQL warehousing, and enterprise dashboards.

United States

Message

What I'm looking for

I’m looking for an enterprise role where I can lead reporting/analytics delivery, optimize data pipelines and SQL performance, and grow dashboards in Tableau/Cognos while partnering with stakeholders to define KPIs.

I’m a results-driven Data Analytics & Reporting Engineer with 14 years of experience designing, developing, and supporting enterprise data warehouse, business intelligence, and analytics solutions. I turn complex requirements into data-informed decisions by partnering closely with executive leadership and cross-functional teams.

I’ve delivered measurable impact—reducing reporting latency by 60% through ETL workflow redesign and automating data refresh with Python scripts and cron jobs. I also optimized complex queries and introduced materialized views, cutting runtime from hours to minutes on large financial datasets.

On the BI side, I’ve built and shipped 40+ executive dashboards using Tableau and Power BI, and migrated 15+ legacy reports from Cognos to Tableau with dynamic parameters and row-level security. I administer Tableau Server environments, handling upgrades, migrations, backups, extract refresh schedules, permissions, and troubleshooting.

From data warehousing to governance, I lead requirements gathering, reconciliation, and data quality assurance to keep reporting accurate and timely. I’ve trained 20+ functional users on self-service analytics in Tableau and Workday, and I bring a practical, performance-focused approach to every Agile/SDLC delivery.

Experience

Work history, roles, and key accomplishments

Current

Data Analytics & Reporting Engineer

Current

Montclair State University

Jan 2019 - Present (7 years 7 months)

Led development and support of enterprise reporting and analytics solutions using Oracle 12c, Tableau, Cognos Analytics, and SQL Server. Designed and optimized SQL/PL-SQL for performance, built executive dashboards, administered Tableau Server, integrated enterprise systems into centralized repositories, and supported census reporting with end-user training.

Oracle 12C SQL Server SQL Pl SQL Tableau Cognos Workato SQL Optimization Data Integration Data Validation Data Modeling KPI Reporting

Technical Support & Data Analyst

GEP Worldwide

Jan 2018 - Jan 2019 (1 year)

Provided production support and data analysis for enterprise procurement applications, using SQL scripts to address client-reported issues. Automated data validation and reporting with SQL and Python and supported testing, root-cause analysis, and cloud analytics initiatives on Microsoft Azure.

SQL Python Azure Production Support UAT Support Root Cause Analysis Data Validation Report Automation

Data Warehouse Analyst & Lead SQL Dev

General Electric via Tata Consultancy Services Ltd.

Jan 2012 - Jan 2017 (5 years)

Led end-to-end development of enterprise data warehouse solutions supporting financial and operational reporting. Developed ETL processes with SSIS, built T-SQL stored procedures/functions/views/triggers, created SAP Business Objects reports, and designed 3NF/dimensional data models while coordinating across SDLC teams and mentoring junior developers.

SSIS T SQL Stored Procedures Functions Views Triggers ETL Development Data Modeling Dimensional Models

Education

Degrees, certifications, and relevant coursework

Montclair State University

Master of Science (Business Analytics), Business Analytics

Earned an MS in Business Analytics with coursework covering logical/physical/dimensional data modeling, data warehousing, and Agile/Waterfall SDLC methodologies.