Pooja Virutkar

🔷 BEATS – Bell ExpressVu Asset Tracking System

Client: Bell Canada, Duration: Oct 2022 – Present, Team Size: 7.

• Captured serialized equipment movement from Kafka and ensured real-time validation via the BMF application.
• Designed and updated SDS documents based on functional and business requirements.
• Developed and optimized PL/SQL procedures, functions, triggers, and packages for inventory tracking.
• Automated feed ingestion via DataStage jobs; processed staging tables with stored procedures.
• Led performance tuning and resolved database bottlenecks, improving efficiency and reliability.
• Executed deployment cycles with Method of Procedure (MOP) documents and post-release validations.
• Collaborated with DevOps and Infrastructure teams to ensure zero-downtime releases.
• Guided code reviews, mentored team members, and enforced standards for scalable development.

🔷 Personal Investment & Banking Migration

Client: Fidelity Investments, Duration: Nov 2021 – Oct 2022, Team Size: 9.

• Migrated legacy database objects to AWS DynamoDB using DMS setup.
• Validated migrated datasets with the Nifi tool and decommissioned outdated DB artifacts.
• Developed PL/SQL components for cloud compatibility, and coordinated environment deployments.
• Delivered bug fixes, status reports, and participated in daily agile stand-ups.
• Supported migration activities with structured testing plans, and production rollouts.

🔷 Global Cash Management – Investments & Banking

Client: Fidelity Investments, Duration: Aug 2021 – Nov 2021, Team Size: 9.

• Handled daily feed data for financial transactions via ETL pipelines using Informatica.
• Transformed and loaded market data into target tables after validation with accounting teams.
• Refactored Oracle packages, procedures, and views; unit tested using the utPLSQL framework.
• Used scripting tools to automate enhancements and maintain consistent performance.
• Delivered bug fixes, and maintained regular communication with the PM through daily updates.
• Mentored junior developers, fostering professional growth and enhancing team productivity.

• ✅Designed, developed, and supported database systems for SmartOffice CRM, a solution for insurance agents to manage client relationships and policy tracking.
• ⚙️Built and executed upgrade packages in dev environments, coordinated final deployments with DBAs to QA and production environments.
• 🔍Performed log analysis, corrected failure records, and ensured database consistency post-deployment.
• 🧱 Created and modified DB objects such as tables, views, indexes, and constraints as per evolving client requirements.
• 🚀Deployed updates to client environments, followed through with testing and validation to ensure system integrity.
• 🔧Diagnosed and resolved bugs and performance issues, ensuring seamless application functionality.
• 📄Provided daily status updates to project managers on progress, challenges, and resolutions.

• 🧠 Gathered and analyzed client requirements across sales, purchase, finance, and export modules to design tailored ERP workflows.
• 🧱 Developed and optimized backend logic using triggers, functions, procedures, and packages to ensure smooth integration across modules.
• 🧩 Designed and deployed GUI forms and reports in Oracle Forms & Reports 10g based on business needs, followed by thorough testing cycles.
• 🔃 Ensured existing system flows remained uninterrupted during new feature additions and screen deployments.
• 🔐Managed user access rights and database roles, maintaining daily backups for data integrity and recovery.
• 🛠️ Performed regular database updates, schema changes, and object modifications like tables, indexes, and constraints to support evolving functionality.
• ⚙️Conducted log analysis and resolved failure records during upgrade executions, ensuring database consistency and client satisfaction.
• 🤝 Acted as a primary point of contact for database-related troubleshooting and support throughout the development lifecycle.

• 🧠Collaborated with clients to understand business requirements for sales, purchase, finance, and export modules within the ERP system.
• 🏭 Supported comprehensive resource planning for manufacturing workflows, including RM/FM inventory, FG production, cost calculation, and mass stock tracking.
• 🧱 Developed new screens and maintained smooth flow in ERP modules without impacting existing functionality.
• 🔍 Analyzed and designed data structures and GUI based on detailed client discussions and business logic.
• 🔄 Built and updated Oracle Forms and Reports to match changing user needs and financial workflows.
• 🔧Optimized and enhanced PL/SQL objects—procedures, triggers, and functions for better performance and modularity.
• 🔐Managed user creation and access control, including assigning roles and maintaining database backups on a daily basis.
• 🛠️ Played a key role in the implementation, support, and troubleshooting of the ERP software across client deployments.