Yamini Govindaraj

• Successfully led the migration of Oracle EBS to Workday Financials with a team of five.

Workday roles:

• Developed and modified Workday custom reports and calculated fields for diverse business requirements.
• Enabled workday reports as RAAS for access by downstream and third-party applications.
• Created and modified inbound and outbound EIBs, using custom reports, Workday web services, and XSLT transformations.
• Designed Workday Studio integration for complex file processing requirements within Workday applications.
• Conducted a security analysis, creating ISU and ISSG, and assigning domain policies accordingly.
• Modified integrations involving document transformation and core connector concepts to optimize data fields.
• Involved in BIRT report modification and customized the report needed for the client.
• Worked in XML, complex XSLT transformations, fixed integration failure issues, and data issues.
• Proposed innovative solutions using Workday integrations to improve the client's application experience.

Oracle PL/SQL Roles:

• Developed tables, constraints, functions, procedures, packages, SQL Loader scripts, and Unix shell scripts.
• Provided technical design and analysis for replicating functional requirements in new integration.
• Proposed solutions for critical requirements while guiding team members on existing workflows.
• Facilitated daily status calls with clients to update on development progress.
• Coordinated cross-team meetings to ensure effective integration testing, and issue resolution.
• Executed phased production deployment for 250 DB and UNIX components, without omissions.

• Served as sole Oracle SQL & PL/SQL Developer, managing all technical development tasks.
• Ramped up quickly on functional aspects of applications and guided team members effectively.
• Took ownership of application management, coding, testing, and implementing changes rapidly.
• Conducted thorough root cause analysis for issues reported by warehouse users.
• Configured Big Brother monitoring tool to set alerts for production-related issues.
• Established new Cron jobs using crontab for production task automation.
• Implemented enhancements through development of Oracle Stored Procedures, Functions, and Packages.
• Created new reports in Oracle Apex for business accessibility.
• Worked in Oracle HTTP Server – mod_plsql module and analyzed the existing authentication mechanism of the PL/SQL web application.
• Worked as the only database resource, and completely took responsibility for all server migration tasks of both application and database servers.
• Independently researched the Oracle HTTP Server installation, successfully installed it on the application server, updated the configurations, connected to the database 12c, and configured the PL/SQL web application.
• Experience in installing the Oracle client in application servers.
• Worked extensively on fixing many database defects, such as setting the logs path in utl_file_dir, identifying nls_date_format, increasing SGA space, compiling all DB objects, and identifying deprecated DB packages in 12C during database migration.
• Identified application schemas and provided a migration plan to the DBA team, checking for invalid objects after creating application schemas, and comparing object counts between databases.
• Identified all the DB users and their roles, grants, and validated them in new databases, ensuring that existing and new database data are identical.
• Effectively used data dictionary views to compare DB objects, object privileges, SYS privileges granted to users, objects, and roles.
• Involved in the application server migration task by setting up environment variables, analyzing the list of software installed, modifying the configuration file for Apache, OHS, and Oracle Apex, and testing Cron jobs.
• Successfully completed the server migration for DEV, UAT, and PROD environments, and received a lot of appreciation from management.
• Handled the transition for 18 new applications from the client, shared knowledge with offshore teams, and became the application SME for most of the apps.

• Developed and tested Oracle stored procedures, functions, and packages for Case Management application.
• Executed code changes by modifying reference data, disabling menu options in Oracle Forms, and debugging.
• Conducted requirement gathering, analysis, technical documentation preparation, development, and testing processes.
• Created procedures using REF cursors to enable front-end applications to retrieve database data.
• Coordinated with team members across multiple interfaces to ensure quality deliverables throughout project phases.
• Developed and modified Perl and SQL scripts to enhance functionality.
• Generated numerous reports using SQL queries, significantly reducing effort for business users.
• Facilitated effective collaboration during interface testing to ensure smooth progress and continuous support.