Puja Roy

Working as a Data Analyst and Report Developer at Montclair State University since March 2019. Have end-to-end experience in Software Requirement Analysis, Estimation, Documentations, ETL Development, Execution and Management, Defect Resolution, BI Reporting, Implementation/Deployment, Support/Enhancement and Maintenance. Have in-depth knowledge in Extract, Transform and Load (ETL) development using SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) and Oracle SQL Developer. Designed conceptual data model based on the requirement, Interacted with non-technical end Users to understand the business logics. Modeled the logical and physical diagram of the future state, Delivered BRD and the low level Design document. Discuss and develop Data model, data flow and data mapping with the development team. Discuss and Develop Conceptual Data Model Integrate multiple data Models and create a Single Unified Model Translated and assembled business requirements into detailed, production-level technical Specifications, detailing new features and enhancements to existing business functionality. Experience in database design which includes the concept of fact and dimension. Experience in debugging, fixing, query optimization and performance tuning. Software Development Life Cycle - Waterfall and Agile Methodologies Unit Testing of T-SQL and PL/SQL code by creating test data. Experience in reporting using SAP Business Objects, IBM Cognos Analytics and SAS Enterprise Guide. Troubleshooting of Production issues within SLA. Excellent oral and written communication skill. Adaptable to change, Strong Attitude, Creativity and Analytical approach to problem solving and Highly task oriented. Ability to handle multiple assignments with critical deadlines and changing priorities. Create and refine data visualization and interactive dashboards using Tableau, Power BI, SQL Server Reporting, and other software. Efficient in implementing Normalization to 3NF/ De-normalization techniques for optimum performance in relational and dimensional database environment Created the data models for OLTP (online transaction processing) and OLAP (online analytical processing) systems. Engaged in data profiling to integrate data from different sources and Performed the gap Analysis and impact analysis. Assisted DBAs on support needs and provided guidance on architectural issues. Participate in the maintenance and development of online web reporting capabilities. Work closely with clients from academic and administrative units to define requirements and Solutions and provide decision support consultations. Partner with IT staff to develop efficient data structures, provide access to data and participate in Data conversion and data migration efforts. Collaborate with financial analysts on complex analyses. Document best practices, processes, utilities, and reports. Experience working in JIRA, Confluence, Service-Now. Facilitated QA for developing test plans and test cases for unit, system, and Enterprise testing. Collaborated on the data mapping document from source-to-target and the data quality Assessments for the source data. Leveraging analytics and large amounts of data. Data exploration, data cleaning, implementation of advanced statistical and machine learning algorithms.

• Reduced reporting latency by 60% by redesigning ETL workflows in SQL and automating data refresh schedules via Python scripts and cron jobs.
• Delivered 40+ executive dashboards in Tableau and Power BI that provided near real-time insights into financial and operational KPIs.
• Built scalable data pipelines integrating data from Workday, Salesforce, and Banner into centralized analytics marts using SQL and SSIS.
• Optimized complex queries and introduced materialized views, reducing runtime from hours to minutes on large financial datasets.
• Collaborated with business stakeholders to define data quality metrics, increasing trust in analytics deliverables and enabling faster decision-making.
• Implemented error-handling and audit logs for ETL jobs, reducing manual data correction effort by 35%.
• Migrated 15+ legacy reports from Cognos to Tableau, introducing dynamic parameters and row-level security for secure data access.
• Automated data validation checks with Python and SQL scripts, preventing recurring reconciliation issues between source and reporting systems.
• Trained 20+ functional users on self-service analytics using Tableau and Workday reporting tools, improving report turnaround time.

• Microsoft Certified Professional - 70-461
• Big Data & Hadoop
• BI SAS Foundation
• Cloud Computing