Pallavi Gainewar

Delivered enterprise reporting and analytics solutions, covering data analysis, data modeling, dashboard development, and cloud data platform support. Developed and supported Snowflake-based data preparation and transformation for reporting. Built and operated Airflow workflows for scheduling and automation, and used Python for validation and reporting support. Tuned performance and maintained technical and dashboard documentation in coordination with stakeholders.

Supported an asset management program with data analysis, data modeling, and dashboard development using Qlik and Power BI. Analyzed data from reporting databases and data marts, then implemented models and analytics-ready structures for reporting. Used Python libraries for analysis support and performed performance testing and optimization. Maintained project and dashboard documentation and coordinated with business users.

Built dashboard and reporting solutions for a wealth cost system with a focus on requirement gathering and source data analysis. Developed data models and dashboards using Qlik Sense and Tableau, and performed performance testing and optimization. Contributed to dashboard administration/security and maintained dashboard documentation. Supported reporting execution using ETL and automation components referenced in the project stack.

Supported credit risk and market risk teams by turning reporting data into actionable dashboards and reports. Gathered requirements with business users, designed QlikView/Qlik Sense architecture, and developed dashboard assets including data models and QVD generation processes. Managed NPrinting and dashboard server administration, including optimization and security implementation. Maintained technical and functional documentation throughout delivery and support activities.

Developed and maintained QlikView dashboards and scheduled ad hoc reporting for GST billing monitoring. Validated dashboard data against SQL Server sources, and performed performance testing to ensure reliable delivery. Implemented publishing, scheduling, and security requirements for dashboard operations. Prepared and maintained project documentation while working closely with business users.

Created dashboard data sources by defining SQL Server procedures, tables, and views based on business requirements. Built data models for Qlik and Power BI dashboards and developed QlikView dashboard deliverables. Managed dashboard publishing, scheduling, and security controls for ongoing operations. Supported dashboard stability by handling monitoring tasks and investigating shell script issues.

Worked on credit risk and reporting programs, translating business requirements into specifications and dashboard deliverables. Loaded data into source systems using Informatica PowerCenter and supported workflow deployments to production. Developed and scheduled QlikView dashboards and monitored job execution, including troubleshooting shell script issues. Also supported data modeling and reporting components across related projects, including dimensional modeling and cube development.

Developed CRM-related reporting assets using Crystal Reports and BO/related tooling, based on gathered requirements. Wrote and maintained procedures and queries against Oracle and SQL Server to support report data delivery. Built data transfer and loading jobs using SSIS and Informatica, and supported report delivery through testing and issue resolution. Performed optimization and performance tuning in Unix-based environments.