Oracle ERP, SQL/PLSQL
Shermila Abbu
Product Owner
Summary
Systematic Product Owner with a detail-oriented and thorough approach to defining requirements, outlining specifications, and working with team members to bring to life high-quality products for customers. Good planner and problem-solver with in-depth understanding of standard and customized products. Ready to offer 14 years of experience and take on a dynamic new position.
SaaS & Software Subscription Model | Enterprise Licensing agreements |MSP Business Model | Buying Program Commercialization |New Product Introduction| Offer Constructs | Hybrid (Cloud Managed Hardware) Model | Hardware OEM & Services Business | Business Platform Optimization |Channels and Distribution Selling|
Overview
14
14
years of professional experience
4
4
years of post-secondary education
Work History
Product Owner
Cisco Systems, Inc.
San Jose, CA
04.2020 - Current
- Work with Enterprise Agreement, solution and offer product management to define policies, business processes and business requirements in support of implementation of solutions, products, and services into Enterprise Agreement framework
- Understand and align offer pricing, product and support structure, monetization model and global deployment approach.
- Support definition of all other parts of offer or solution lifecycle, including term changes, periodic adjustments, and true forwards, in term offer evolution, end of term management and underlying product or service end of life management.
- Work across legal, finance, global tax and customs, export compliance, supply chain operations and other functional groups, to ensure operational process are understood and implemented accurately.
- Ensure corporate established policies and processes are followed, establishing new processes and policies where needed.
Business Systems & Operations Analyst
Cisco Systems, Inc [C].
San Jose, CA
03.2019 - 03.2020
- Facilitate operational execution and scalability of incubation software offers with focus on emerging software offers and buying programs
- Focal point for data and trend analyses of end-to-end Quote to Cash and delivery/fulfillment processes for various software offers for business optimization and influence go to market strategies
- Coordinated with Pricing, Deal, Customer Success Management, Business Transformation, and IT teams to develop and provide guidance on scalable processes with B2B partners
- Managed improvement efforts from issue and gap identification to development of process, policy, and capability resolution to increase automation and minimize manual touch
- Analyze business operations and provide strategic planning and optimize business processes to close large multi-million-dollar deals
- Scale operations through process optimization, automation through IT capabilities and ensure policy decisions enforced by business
ERP Techno Functional
Symantec [C]
Mountain View, CA
09.2016 - 02.2019
- Analyzed and optimized internal Revenue recognition tool.
- Performed Gap analysis and identify potential requirements from issues/bugs reported by customers.
- Designed functional and technical documents, assist with testing business processes and test scenarios to validate setups, customizations, and process changes.
- Developed the integration code using PL/SQL & advance PL/SQL concepts
- Developed Revenue Reports for business users using Microsoft VBA (Visual basic for applications), RDF & XML (rtf and excel templates).
- Created reports for oracle bookings and billings reconciliation with RevPro.
- Supported Month, Quarter & Year end activities. Assist Business team with the reports for the revenue team to reconcile and close the account books.
ERP Techno Functional
NetApp [C]
Mountain View, CA
03.2016 - 08.2016
- Analyzed existing database, ERP Eco systems and integrated applications with ERP.
- Connect with DBA teams on requirements and challenges for database migration and server upgradation.
- Facilitated the Development and QA teams to test complete ERP Core functionality & also its interfaces with other application within NetApp ecosystem to validate the application performance.
- Coordinated QA team on integration, load, and performance testing of new servers.
- Worked with actual Business users on UAT.
Oracle Developer/Systems Analyst
Cisco Systems, Inc [C].
San Jose, CA
04.2012 - 02.2016
- Developed and delivered components to meet company business processes.
- Followed standard methodologies on PL/SQL coding to write clean and self-documenting code.
- Created, debugged, and modified Stored Procedures, Triggers, Tables, Views and User-defined Functions.
- Collaborated with other developers and performance engineers to enhance supportability and identify performance bottlenecks
- Liaised with end users and functional analysts to perform unit, system, and regression testing
- Provided technical expertise to support daily operations in Oracle applications
- Conducted data modeling, performance, and integration testing
Oracle Developer
Tech Mahindra
Hyderabad, TG
06.2007 - 03.2012
- Gathered and documented Functional and Technical requirements to determine capabilities to be delivered
- Performed gap analysis and impact analysis by analyzing of existing database.
- Assisted DBAs on support needs and worked with development teams with loading and extracting data (ETL).
- Collaborated on data-mapping document from source-to-target and data quality assessments of source data.
- Authored code fixes and enhancements for inclusion in future code releases and patches
- Facilitated QA for developing test plans and test cases for unit, system, and integration testing.
- Created back-end Packages in PL/SQL - Created, debugged, and modified Stored Procedures, Triggers, Tables, Views, User-Defined Functions, Pl/SQL tables, Bulk Binds and Bulk Collect.
- Maintained data integrity and security using Integrity Constraints and Triggers.
- Drafted documentation to detail development, logic, and testing processes
- Used interpersonal and communication skills in interactions, enriching team collaboration, customer relationships on projects
Education
Bachelor of Science -
JNTU
Hyderabad 09.2003 - 05.2007
Skills
Channels/Route to Market- Direct End Customer, 1-Tier Partner/Re-seller, 2-Tier Distribution
Offers: Hardware Products, Software Licenses, Software bundles, Services
Software systems Development Methodology - Waterfall, Agile
Data gathering and analysis: Oracle SQL, SAP BO, MS Excel -VLOOKUP ,Pivot tables
Quality Management: HP Quality Center, Rally
Software
Oracle Forms and Reports
Business Objects, Tableau, Microsoft VBA (Visual basic for applications), RDF & XML (rtf and excel templates)
Oracle Install Base, Oracle Service Contract, User Defined Attributes framework
Microsoft tools, SharePoint, Rally, Aha!
Timeline
Product Owner
Cisco Systems, Inc.
04.2020 - Current
Business Systems & Operations Analyst
Cisco Systems, Inc [C].
03.2019 - 03.2020
ERP Techno Functional
Symantec [C]
09.2016 - 02.2019
ERP Techno Functional
NetApp [C]
03.2016 - 08.2016
Oracle Developer/Systems Analyst
Cisco Systems, Inc [C].
04.2012 - 02.2016
Oracle Developer
Tech Mahindra
06.2007 - 03.2012
Bachelor of Science -
JNTU
09.2003 - 05.2007