Clarity PPM Developer - Infosys - Nissan group of Americas
(2024-09)
- Developed modern UI resource profile requests and custom objects for PO/PR reports, enhancing functionality and user experience.
- Automated data loading from Excel/text files into Clarity PPM.
- Managed key modules including Investments (RTB), Portfolio, Demand, Resource, Finance (Actual Upload), and Project Management (Timesheets).
- Designed object lookups and integrated processes; created portlets with complex queries
- Implemented workflow automation via on-demand/auto-start processes based on business requirements.
- Prepared test plan documents and share with UAT team before deployment to production.
- Enhanced error handling with GEL logs and audit trails for compliance tracking.
- Developed SQL queries, Rest Soap, XML and GEL scripts to automate and optimize data workflows.
CA Clarity PPM Consultant - Infosys - Telstra Telecommunication
(2023-02 - 2024-07)
- Designed and implemented Clarity PPM solutions including objects, lookups, processes, and group rights.
- Built on-demand and auto-start processes to meet specific business requirements, improving process responsiveness.
- Migrated projects from Classic UI to Modern UX (MUX), enhancing usability and aligning with modern standards.
Oracle SQL and PLSQL Developer - Iglitz technology - Nevada state bank company
(2021-08 - 2022-12)
- Created stored procedures, functions, packages, collections, triggers, and object types to implement complex business logic.
- Written SQL queries using Inner/Outer joins, Union All, Intersect, and Minus operators for advanced data analysis.
- Developed DB objects including tables, views, sequences, and synonyms to support application requirements.
- Built PL/SQL packages leveraging REF Cursor and Collections for efficient data handling.
- Maintained security and data integrity using constraints and triggers.
- Created and debugged stored procedures, triggers, and views to optimize workflows.
- Prepared test plans, conducted unit testing, and provided implementation/maintenance support.
- Handled errors using exception handling for easier debugging and user-friendly error messages.
Oracle SQL and PLSQL support and development - Iglitz technology - Arch Insurance Company
(2019-06 - 2021-08)
- Created tables, stored procedures, functions, cursors, views, indexes, and utilized SQL*Loader as per requirements.
- Developed SQL queries for efficient data manipulation.
- Resolved errors and warnings during job development to ensure smooth execution.
