Shivani Nachu

•Developed and enhanced complex Oracle PL/SQL procedures, packages, and functions to automate retail commission calculations for high-volume transaction systems. • Lead end-to-end design and implementation of Oracle CPQ Cloud solutions for complex quoting and pricing workflows across financial product lines. • Developed robust configuration and commerce rules, including Recommendation, Constraint, and Hiding rules supported by BML and BMQL scripting. • Created advanced Data Tables, pricing matrices, guided selling flows, and BOM structures for scalable product configuration. • Built custom integrations between Oracle CPQ and Salesforce using REST, SOAP, XML, and XSLT mappings to support real-time quote synchronization. • Designed and enhanced Document Designer templates and Document Engine logic for automated quote, proposal, and contract generation. • Implemented approval workflows, profile-based access controls, and multi-step CPQ commerce flows. • Supported CI/CD automation, code reviews, and best practice governance to ensure high-quality deployments. • Provided technical documentation, design specifications, deployment planning, and production support planning. • Mentored junior developers and coordinated with cross-functional business teams across onshore/offshore. • Delivered SDLC activities including design, development, unit/system testing, UAT support, deployment, and ongoing production support. • Integrated Oracle Autonomous Database features with Schwab’s microservices architecture for enhanced data scalability and autonomous tuning. • Built data APIs using RESTful services connected to Oracle backends, facilitating faster and secure financial transactions across Schwab’s digital platforms. • Worked closely with AWS architects to design hybrid cloud data solutions using Amazon S3, AWS Glue, and Athena for extended reporting capabilities.

• Designed, developed, and maintained PL/SQL procedures, packages, and triggers to support high-performance healthcare applications, ensuring compliance with HIPAA standards. • Implemented CPQ Configuration Models for healthcare plans, product bundles, policies, and subscription models. • Built complex commerce processes including pricing logic, actions, constraints, approval flows, and multi-stage quote lifecycle configurations. • Developed reusable BML libraries and optimized BMQL queries for faster rule execution and cleaner configuration designs. • Designed CPQ–Salesforce integration patterns including account sync, quote sync, pricing sync, and document transfers. • Authored detailed technical documentation, system design specifications, and deployment runbooks. • Created dynamic templates using Document Designer and integrated digital signature capabilities. • Performed performance optimizations across Configuration and Commerce engines, reducing rule execution time by up to 30%. • Authored detailed technical documentation, system design specifications, and deployment runbooks. • Led the migration of legacy Oracle workloads to Amazon RDS for Oracle and AWS Aurora, optimizing cost and performance in a secure cloud-native environment. • Integrated Oracle solutions with AWS Lambda, Amazon S3, and AWS CloudWatch, ensuring seamless processing of claims data and proactive monitoring. • Created comprehensive data models, ER diagrams, and entity relationships using Oracle SQL Developer Data Modeler to reflect real-world healthcare workflows. • Delivered high-availability and disaster recovery strategies using Oracle Data Guard across multiple regions in AWS to ensure continuous service for critical applications. • Developed and fine-tuned complex SQL queries to extract, transform, and analyze large datasets for population health reporting and predictive modeling.

• Designed CPQ configuration flows for retail subscription, membership, and product bundles. • Integrated Oracle CPQ with Salesforce CRM and internal order management systems using SOAP/REST APIs. • Developed complex Data Tables, pricing rules, and CPQ commerce actions supporting end-to-end quoting automation. • Enhanced guided selling experiences using BML-driven recommendations and validation logic. • Built XSLT-based transformations and XML-driven templates for quote, offer, and agreement generation. • Created documentation for CPQ configuration, integration patterns, workflow design, and approval setups. • Developed and maintained complex Oracle PL/SQL code including stored procedures, functions, triggers, and materialized views, improving batch performance by over 30%. • Designed solutions with high availability and disaster recovery using Azure Site Recovery and Oracle Data Guard, ensuring minimal downtime during maintenance windows. • Worked in Agile and DevOps environments, collaborating with cross-functional teams using JIRA, Bitbucket, and Azure DevOps, delivering bi-weekly sprints. • Implemented and enforced data security protocols including encryption and role-based access control (RBAC) in Oracle and Azure environments. • Provided production support and troubleshooting for complex retail transactions, order processing, and inventory control systems with critical SLAs. • Developed Oracle RESTful Web Services for integrating mobile retail applications with backend systems, enhancing user experience and real-time inventory access. • Created dynamic reports and dashboards using Power BI and Oracle BI Publisher, enabling Costco stakeholders to make data-driven decisions. • Conducted code reviews, mentored junior developers, and provided technical leadership to ensure adherence to best practices and coding standards. • Played a key role in the data archival and retention strategy using Azure Data Lake and Oracle partitioning, improving system scalability.

• Supported CPQ configuration and rule enhancements for financial product quoting engines. • Implemented constraint rules, attribute mapping, and Data Table-driven calculations. • Integrated CPQ workflows with banking internal systems using XML and API-based data exchange. • Coordinated UAT, code reviews, sprint planning, and cross-team collaboration. • Performed data modeling and database design using ERwin and Oracle tools, ensuring database normalization and performance optimization across financial applications. • Developed and fine-tuned SQL queries to support real-time reporting and analytics for critical banking transactions and compliance needs. • Migrated on-premise databases to AWS RDS (Relational Database Service), reducing infrastructure overhead and improving scalability. • Utilized AWS Lambda and S3 for automation tasks related to data ingestion and archival processes in a secure banking environment. • Developed RESTful APIs to connect Oracle backend with AWS-hosted services, leveraging API Gateway and AWS Lambda for serverless integration. • Conducted data validation and reconciliation processes using Oracle SQL Developer, ensuring accuracy across customer and transaction datasets. • Coordinated with infrastructure teams to manage Oracle database deployments on Linux servers and supported patching and upgrades. • Contributed to disaster recovery and backup strategies, using Oracle RMAN and AWS S3 buckets, aligning with banking sector resiliency standards. • Documented all code changes and environment configurations using Confluence and JIRA, promoting traceability and team collaboration.

• Designed and developed PL/SQL stored procedures, packages, triggers, and functions to support the business logic of enterprise-level telecom applications. • Contributed to CPQ-adjacent systems involving quote management, offer eligibility, product configuration, and XML-driven workflows. • Built configuration rules, approval routing logic, and pricing structures used by telecom quoting platforms. • Involved in the development and tuning of complex SQL queries, focusing on performance improvement across large volumes of customer and billing data. • Conducted thorough unit testing and debugging of PL/SQL code using tools like TOAD and SQL*Plus, ensuring data integrity and process accuracy. • Collaborated with QA teams to develop and implement test cases for data validation and backend verification using Unix Shell Scripting. • Implemented materialized views, indexes, and partitions to enhance data retrieval performance in high-traffic telecom applications. • Managed version control and deployment of database code using CVS and Subversion (SVN) in coordination with development and DevOps teams. • Developed and maintained complex reports using Oracle Reports and BI Publisher, supporting business analytics and decision-making. • Provided L2 and L3 support for critical database environments during peak hours, ensuring 24/7 uptime compliance with telecom SLAs. • Participated in regular code reviews, peer programming, and performance tuning sessions, sharing Oracle best practices within the team. • Documented technical specifications, data mappings, and architecture diagrams, contributing to knowledge sharing and project handover initiatives.