Ranjani Yerramillli

• Smoother month-end closure of Amazon Transportation Finance books for NA (~$2MM per month) and EU (~$0.5MM per month).[Program Manager]

I have worked with Amazon Transportation Finance (TFS) client teams (controllership and finance operations) to understand the issues blocking the month-end closure of financial records.

Initial debugging and impact analysis were done to identify the root cause. Engaged the relevant development team in TFS, and leadership approval was obtained to prioritize the resolution, thereby ensuring a seamless month-end financial record closure. Daily status reports were shared with relevant finance, customer service, and TFS leadership to provide visibility into open issues and the PTG's progress toward resolution.

A comprehensive record of manual entries has been documented for future reference, with the objective of implementing service-level blocks to prevent the duplication of entries in the financial records.

• Project Enfield - Protection of Personal Data of Individuals[Technical Program Manager]

Identified and validated Transportation Financial System (TFS) services accessing confidential personal data from the raw services list provided by the Compliance team. Created the program plan with key program deliverables, and project milestones. Secured approvals for required SDEs bandwidth from Software Development Managers (SDMs) to execute the plan. Provided biweekly program status reports to organizational leadership.

• Managed Transportation Financial Systems key team operational and financial goals.[Program Manager]

Contributed to the financial goals of the organization by reducing service requirement costs (IMR) by 10% year over year for the fiscal year 2022-2023. Secured bandwidth to collaborate with individual SDEs of TFS teams to identify opportunities for reducing service requirement costs, thereby achieving the financial target of a $0.5 million IMR cost reduction for the fiscal year. Presented data and status updates during monthly business review meetings.

Successfully reduced the team's operational costs by 10% through analysis of data, provided detailed reports to development teams, collaborated with Software Development Managers on cost-saving initiatives, and provided weekly progress updates to the organization's leadership.

• Migration of a platform service TIPS 1.0 to TIP 2.0 [Program Manager] took up the team's goal for the year[2020-2021] to onboard carriers onto the newer service. Onboarded over 350 transportation carriers onto the new service, published a fortnightly report to leadership and customer teams with the status of migrated carriers, blockers, and issues that need prioritization. Led multiple daily calls with customer team POCs and the development team POC to get help on tickets that need assistance from the respective development team.
• Support to the development team [Support Engineer] supported development teams by addressing and fixing SAS compliance risks for services. Handled clients' team technical queries about services. Developed a knowledge base for team members to troubleshoot similar issues and provide the required support within the SLA. Addressed customer requests for TIPS UI improvements by using JavaScript and HTML.
• Improved customer satisfaction by promptly addressing support tickets and providing accurate solutions.

• Project SEA to PDX Migration: Worked on a project related to the financial goals of the team. Migrate service hosts from one regional data center to another regional data center. I collaborated with internal SDE teams for individual services with my plan. Approached the external team to order the required hosts for 16 services across the organization. Replaced the hosts in services via change management after gathering the required approvals.
• Project Nautilus: Worked on one of the organization's goals to improve customer experience. I have worked with the service development team to deliver an upgraded tool that will be used by partner teams to assess and flag risks of the transactions. I have worked on the simple UI widgets on the page and set up the required access restrictions and rights as per the roles and responsibilities of the end user.
• Oracle and JAVA8 Migration: Worked on compliance goal requirements to upgrade the existing databases and software versions. I have worked with SDEs and DBAs to migrate the service calls from legacy storage services to AWS cloud services and storage. And also to make the required configuration changes, and test the same, to enable calls to services for upgraded software.
• Worked on compliance goals of the organization, addressing policy engine risks, SAS risks for services identified by the Compliance and Security Management teams. I have developed a knowledge base and automation tools/scripts using Ruby and Python for teams to handle such risks.

• Handled maintenance of Linux systems for services (Tier-1) in the retail ordering pipeline. Ensuring 100% availability of services by setting up the right alarms and notifications.
• Maintenance of data warehouse jobs by fine-tuning SQL queries used by teams in the organization for better reporting purposes.
• Improved customer satisfaction by promptly addressing support tickets and providing accurate solutions.
• Documented technical issues and solutions for further use by the team.

• Answered customer emails to respond to questions, provide details, and resolve concerns. Always maintained an SLA for resolution at 95%.
• Increased client satisfaction by effectively managing and resolving account issues. Ensured the resolution of three customer cases per hour, with less than a 5% rate of unsatisfied query reopens from customer emails.