Oracle Developer Resume
5.00/5 (Submit Your Rating)
SUMMARY
- Overall 12+ years of professional experience in Oracle agile PLM Implementation and Data Migration.
- Integral part of multiple End - to-End Agile PLM implementations for manufacturing/bio-technology and pharma domain.
- Extensive knowledge with the structure of Clinical / Commercial Items and FRRV data and Artwork process of pharma domain.
- Expertise in PLM domain predominantly with product collaboration (PC), portfolio management (PPM), governance and compliance (PG&C)
- Experience in both on-site and remote based techno functional support for Agile PLM development and production projects.
- Implementation and support PLM integration with ERP/OPLA and downstream systems
- Expertise in business analysis and understanding the business requirement.
- Experience in translating business requirements to functional specifications, Design /Technical specifications, Test scripts and Validation test cases
- Develop business test cases and coordinate with business users to perform the dry run testing, UAT, SIT and delivery validation, document the testing results and approval sign off
- Participate in Quality team project audit and monthly audit.
- Co-ordinate the defect and RCA discussion to close the defects and Non-conformance raised during audit
- Expertise in Data migration and Data validation of varying scales and complexities across multiple sites
- Expertise in SDK and Groovy Scripting for Process Extension / Events customization development, enhancements and maintenance
- Expertise in Agile admin configuration of Classes, Workflows / approval routings, Lists, Criteria, Roles, Privileges, design and implementation of ACP and ACS
- Working knowledge with Oracle Agile PLM databases and schema
- Experience in handling AIS support / maintenance for PLM integration with ERP and downstream systems.
- Experience in developing B2B interfaces using SOAP web services
- Experience in Agile User Training on various modules.
- Experience in Dry run, UAT, CRP and hyper care support
- Good communication skills, interpersonal skills, self-motivated, quick learner.
- Experience in leading and managing teams and handled multiple roles including Technical/Team Lead, Lead Developer, Business Analyst and Manager.
- Extensive experience with complete SDLC lifecycle development which includes requirement gathering, analysis, design, development, deployment, hyper care and production support.
- Experience in preparing/performing unit test cases, Business Test scripts, test data and performing validation
- Experience in performing and coordinating UAT, SIT and CRP sessions
- Experienced in using version control tool SVN
- Experience in using J2EE Application Servers such as Web Logic, Web sphere 8.2 and Web Servers such as Tomcat
PROFESSIONAL EXPERIENCE
Confidential
Oracle Developer
Responsibilities:
- Existing Attribute study/consolidation
- Setting up of new Subclasses and Attributes
- Creating /modifying roles/privileges
- Disabling existing subclass/attributes
- Modifying /removing existing roles/privileges
- Testing and Validating the Agile Content packages to ensure the ERP is aligned with the new subclass/attribute model
- Modifying existing process extensions to align with new class structure
- Preparing / Validating / Testing ACP and IQs.
- Perform dry run of ACP and IQs and co-ordinate with business for dry run testing
- Perform QA and Production deployment
- Co-ordinate and support UAT and CRP sessions.
- Provide hyper care support and fixes.
Confidential
Oracle Developer
Responsibilities:
- Single handedly handling complete End-to End Data Migration for Clinical and Commercial products including FRRV from multiple source systems EBS, PDH and MDM into Agile
- Develop scripts in MS Access to
- Import data into staging MS DB
- Validate and filter invalid records
- Apply Data transformation
- Data enrichment
- Split and translate FRRV (from EBS) into Agile loadable Formula, Recipe, Validity Rule, Routing and BOM
- Migration activity includes
- Data Study, identifying correct source for each component/attribute
- Prepare Data Migration Plan and Strategy
- Design and implement Agile configuration/settings to facilitate data load
- Data file preparation, Data Filter and Cleansing, Data Transformation and enrichment
- Perform multiple dry runs of Data load, validate, apply fixes and prepare mitigation plan for fall outs
- Provide data load statistics
- Perform complete validation on post load in validation and production instances
- Provide hyper care support and post-production fixes.
- Preparing / Validating / Testing ACP and IQs
- Perform QA and Production deployment
- Participating in UAT and CRP sessions
- Provide hyper care support and fixes.
- Align the technical and design document deliverables with ITQ process guidelines
Confidential
Oracle Developer
Responsibilities:
- Configuration of Agile PPM Activities, Gates and Project, workflows
- Requirement gathering, design and implementation of multiple PPM customizations in Process extension and Event framework for
- Creating new Artwork Project
- Appending and structuring new Artwork Items in the existing project based on associated Change Orders and Plans
- Create multiple business validation checks on the project workflow
- Automating the addition of custom approvers/reviewers on the workflow based on Attribute values
- Automatically start the next required tasks in the schedule when current is completed
- Invoking the third-party tool for reviewing and annotating the Artwork File through their custom API calls
- Roles/Privilege/Criteria/User/User Group / Functional Teams / Job functions configuration
- Developing web service integration between PLM and 3rd party File Inspect / Annotation tool
- Performing ACP from moving the changes to multiple instances
- Preparing / Validating / Testing ACP and IQs
- Participating in UAT and CRP sessions
- Provide hyper care support and fixes.
Confidential
Oracle Developer
Responsibilities:
- Coordinate with Business on requirement gathering and translate them to functional and technical specifications
- Implementation of process extension customizations both SDK and Groovy scripting to support Quality Reports and business validations
- Build code, co-ordinate with UAT, bug fix, deployment and post-deployment support
- Build test scripts for validating the business requirement
- Coordinate with business to validate and document the test results in UAT, SIT and post implementation
- Roles/Privilege administration for end users
- Manage/coordinate Document and Change Management sign off for the functional and technical deliverables
- Coordinated with client to resolve issues as part of production support
Confidential
Oracle Developer
Responsibilities:
- Involved in multiple use case and requirement discussion and involved in decision making process.
- Technical end-to-end implementation of Event framework and process extension utilities like CCB Matrix, Label language translation to increase the TAT for Business team
- Develop test cases and coordinate with business users to perform the dry run testing, UAT, SIT and postproduction validation, document the testing results and approval sign-off
- Migration activity including Data Study, prepare Data Migration Plan and Strategy, Data Filter and Cleansing, perform multiple iteration of Data load, provide data load statistics, co-ordinate Customer verification.
- Performed system study (SKU, BOM Structure, Attributes, Integration) and suggest ideas to improve the overall performance and maintenance of PLM tool
- Coordinated with client to resolve user issues pertaining to data load, access/privileges and training
Confidential
Oracle Developer
Responsibilities:
- Techno-Functional Lead role in Agile PLM upgrade.
- Prepared and conducted design and solution workshops with the customer and ensure all stakeholders are aligned with the proposed solution
- Co-ordinating/ translating the business requirements to functional specifications, Design /Technical specifications and Validation test cases
- End to end implementation of multiple Process Extensions for validations and reports.
- Co-ordinate with Business to validate the delivery, document the test results and perform sign off
- Manage/ maintain the project documentation including the Functional specifications, Design specifications, Requirement Tracker, Validation Test Scripts, Test Result, Defect Log, Installation Run book.
- Co-ordinate with Quality team audit activity for monthly audit and project audit. Provide the necessary fix and correction for the Non-conformance and Quality defects raised during audit.
- Participate and provide closure to the RCA session for the defects and NCs raised during audit.
- Provided high level solutions for the requirements and coordinating with the team to provide to the appropriate solution.
- Development Lead for data migration team of the project with the responsibilities of managing the tasks of the data migration team members, mentoring and assisting them on the project activities, regular status reporting to the Team Management and coordinating with various teams like Client Business Team, Support Team, PMO and End User.
- Expertise in Data Migration including comprising large scale data across multiple sites at Flex
- Migration activity includes
- Data Study Identify source and format and data consolidation
- Prepare Data Migration Plan and Strategy
- Design and implement Agile configuration/settings to facilitate data load
- Data file preparation, Data Filter and Cleansing, Data Transformation
- Perform multiple dry runs of Data load, validate, apply fixes and prepare mitigation plan for fall outs
- Provide data load statistics
- Provide hyper care support and post-production fixes.
- Prepare validation test cases and test samples and coordinate with business for validation and approval
- Developed/ lead multiple custom process extension in SDK and groovy scripting
- Developed/ lead multiple process extension reports to support the application business team
- Lead multiple end-to-end performance enhancement projects for various integration utilities related to Manufacturer and Design Files data.
- Developed end-to-end web-services for B2B integration
- Maintenance of the PLM Server environments including the installation
- Managed the periodic synchronization of the data and configuration of Production instance to other environments using ACP
- Develop test cases and coordinate with business users to perform the dry run testing, UAT, SIT and post production validation, document the testing results and approval routing
- Design and Configuration of Data Model and Security Model requirements
- On boarding of end users over multiple iterations based on the department / functions / sites / geographies by coordinating with the relevant stakeholders of each region / department
- Handled multiple work streams like Release Development, Daily Data loading, Support tickets
- Worked with the end users through focus group session and clarifying their queries
- Team Management and Reporting
- Provided 24/7 production support
- Mentored the junior members of the team and monitor their progress to achieve the project objectives
- Conducted Process improvement and Knowledge sharing sessions