Pooja Dodia Email & Phone Number

North Chicago, Illinois, United States

I partnered with stakeholders, partners, and technical teams to thoroughly study processes, identify areas for improvement, and define requirements. As a change agent, I successfully led major business-critical transformations within the enterprise, utilizing user story creation and conducting user story reviews. I also developed prototypes to gather valuable feedback from stakeholders, ensuring realistic simulations and validating assumptions with clients. Furthermore, I actively contributed to client business review sessions, influencing decisions regarding the use of technology to support their objectives. My responsibilities included authoring analysis artifacts such as business requirements, use cases, supplemental specifications, and UI design specifications.During this time, I leveraged business intelligence (BI) tools to create reports and dashboards that provided key metrics for increased executive visibility into process inefficiencies and areas of improvement. I played a vital role in supporting pre and post-launch implementation activities by conducting regular demos, overviews, and training sessions for business users. Additionally, I was responsible for reviewing, analyzing, and testing new software applications and equipment, while also leading upgrades and rollouts, including a significant server migration project from Abbott to AbbVie datacenter. To further strengthen my technical expertise, I actively participated in industry network seminars and webinars, staying informed about the latest BI trends and best practices.

North Chicago, Illinois, United States

I successfully gathered and assessed requirements, collaborated closely with business users, and prepared essential documents such as BRDs, FRDs, and Technical Design Documents. Working in tandem with the Cognos Admin team, I facilitated the installation and configuration of the complete Cognos BI Suite, encompassing components like Business Insight, Advanced, Report Studio, Query Studio, Analysis Studio, Event Studio, and Metric Studio.One of my notable achievements was replacing 30 manual Excel reports with dynamic Ad-Hoc reports using Cognos Query Studio. This transition eliminated the need for users to manually run SQL queries, streamlining the data retrieval and analysis process. Additionally, I leveraged Cognos Framework Manager to create a comprehensive Snowflake data model, significantly enhancing analysis, decision-making, and overall productivity.To improve efficiency, I implemented automated report deliveries via email and leveraged Cognos Connection to distribute outputs to business executives, saving valuable time and enhancing operational efficiency. Security was also a priority, and I successfully implemented row-level and package-level access control based on Product Division and Products using Framework Manager Security.Within Cognos Event Studio, I generated SQL/MDX queries, developed agents, and integrated specific tasks to run reports based on predetermined business criteria. I demonstrated expertise in deploying, migrating, assessing, and fine-tuning models, packages, reports, and cubes across multiple environments, ensuring smooth transitions from Development to QA and ultimately to the Production environment.Furthermore, I customized Cognos Connection to optimize the user experience by implementing report scheduling, maintenance, and security features, defining user, group, and role-based access control to ensure data security and appropriate access levels.

Mundelein, Il

I was actively involved in data management and governance, employing the "Build, Fix, and Sustain" methodology to ensure data health check for clients. I played a pivotal role in driving implementation efforts at country, regional, and global levels, adhering to UNSPSC standards. Additionally, I conducted regular monthly meetings to provide updates, identify areas for improvement, and assess business processes and historical data.I was responsible for collecting and analyzing key performance indicator (KPI) results, actively engaging in continuous improvement activities to enhance data management practices. To streamline problem and incident management tracking processes, I utilized MS Access database, maintaining accurate records and procedures. Furthermore, I effectively communicated problem resolutions and their consequences to client teams while overseeing overall analytic projects.In a leadership capacity, I led a team of 15 junior offshore resources, fostering collaboration and coordination with internal and external stakeholders to effectively manage data logistics and ensure successful project outcomes.

Education record

Salesforce Admin And Developer Course

Bachelor'S Degree, Zoology/Animal Biology