Urmila Phadake

Total 22 years of experience. 14 Years in software development and 8 years in customer/technical support

10 Years 8 months of experience in Oracle, PL/SQL
10 Years of experience in Java Technologies
2 Years experience in JavaScript, ReactJS, Redux and redux-saga.
2 Years experience in AngularJS, Jenkins, Terraform, Kubernetes, Docker.

• Received the Individual Excellency award – 2008
• Received the Individual Excellency award – 2009
• Received the Sweepstakes Award – 2010
• Received the X-tra Miler Award – 2011
• Received the Gold Award for Unmatched Team – 2012 and 2013
• Received Bravo Award for Individual Excellency - 2019
• Received Shine Award for Q1 - 2023-2024

1. License Manager

Description: License Manager is a spring boot application using AngularJS for frontend and MariaDB database. It is used to create, manage and deploy licenses for all Safe Fleet software products and devices.

Responsibilities:

Implemented full stack multiple features of license manager like create/edit customer, device, tenants, licenses

Modernized the monolithic license manager to microservice architecture to decouple UI and backend developments

Implemented unit and integration test cases and did documentation

Participated in requirement analysis, design and planning

Coordinated for unit and integration testing with QA team

Coordinated among Onsite & Offshore team members

Skills Used: Java 8 and 17, Spring, Spring Boot, MariaDB, AngularJS, JIRA, Confluence, Scrum, Git, Maven, Jenkins, Terraform, Kubernetes, Lens

2. AIP Console – Architecture Checker and Transactions

Description: AIP Console is a web application which provides the services required to configure and run AIP (Application Intelligence Platform) analyses remotely. AIP Console discovers the technologies used in the code, adds the needed extensions, sets up the schema and runs the analyzer without the need for any manual intervention.

Responsibilities:

Implemented full stack multiple features into AIP console for Architecture checker and transactions module like create, read, edit architecture model, set engine that generates objects for each architecture layer, check model to show violations, show bookmarks for violations in source code

Implemented unit and integration test cases and did documentation

Participated in requirement analysis, design and planning

Coordinated for unit and integration testing with QA team

Coordinated among Onsite & Offshore team members

Skills Used: Java 8, Spring, Spring Boot, Postgres, SQL, ReactJS, Redux, Redux-saga, JIRA, Confluence, Scrum, Git, Maven, Jenkins

3. Hewitt@work Time & Attendance Module Process Clock Data

Description : In Time and Attendance Module of Hewitt@workapplication Process Clock Data is used to process the employee's swipes, leaves and COA applications and arrive at the employee's attendance for a day.

Responsibilities:

Implemented the entire logic in PL/SQL package (which was in java on UI side and taking 5-6 hours for employee count of 3000 for one month) within short time provided for the project. The process after converting to PL/SQL procedure took only 15mins and it was achieved 100% error free.

Involved in the customer issue related to time taken for processing clock data.

Participated in analysing the issue, planning and implementing the solution

Participated in regular project status meetings

Coordinated for testing with QA team for the entire year payroll

Skills Used: PL/SQL, SQL, Oracle 12c, Java, Test Planning, JIRA, Agile, SVN, Microsoft Excel, Notepad

4. Hewittpay China Payroll Process Module

Description: HewittpayChina is a web-based payroll application used by Aon Hewitt that services the payroll processing needs of various clients across China. Payroll Management involves various activities like calculation on salaries, arrears, reimbursements, managing loans, taxes.

Responsibilities:

Implemented parallel processing which reduced processing time from 32 hours to 10 hours for a client with 16000 employee count thus achieved 70% reduction in process time.

Participated in regular project status meetings

Coordinated for testing with QA team and DB team

Coordinated among Onsite & Offshore team members

Skills Used: PL/SQL, SQL, Oracle 12c, SVN, Agile

5. Hewitt@work Leave Module

Description: Hewitt@work is an application that provides HR solutions. Leave Module is used by clients for applying and approving Leaves online.

Responsibilities:

Automated year end process to calculate leave balance and leaves carried forward during year end. This was greatly appreciated by clients as their time spent on manual activity was reduced and the process now takes only 15-30 minutes for the yearend process.

Developed reports like Leave Balance Report, Leave Details Report, and Annual Leave Balance Report.

Participated in analysing the year end issues, planning and implementing the solution

Participated in regular project status meetings

Coordinated for testing with QA team

Supported the payroll processing team during year end process

Skills Used: PL/SQL, SQL, Oracle 11g, Java, SVN, Microsoft Excel

6. AonHewitt Web Upload Module

Description: Web upload module is used by clients to upload payroll related data in hrworkwaysindiaapplication. Data from hrworkwaysindia(client side) is then transferred to hewittpay application(production side) into different payroll related input tables. This data is then used for payroll processing. Web upload reduced operation team's time and also client's dependency on our operation team as client can directly upload the data at their end.

Responsibilities:

Implemented the PL/SQL procedure to transfer data by creating mapping and generating dynamic queries to select data from client uploaded tables and to insert data into payroll related input tables.

Participated in requirement analysis and design planning

Participated in regular project status meetings

Coordinated for testing with QA team and migration team

Skills Used: PL/SQL, SQL, Oracle 12c, SVN

7. Hewitt@Work Online Attendance Module

Description: Hewitt@work is an application that provides HR solutions. Online Attendance Module is used by clients for marking attendance, attendance regularization online.

Responsibilities:

•Implemented auto population of leave data and integrated Leave Module and Online Attendance Module.

•Implemented auto population of Weekly off and Legal Holidays by schedulers.

•Developed reports for the module like Attendance Report, LOP/LOPR Report, Leave Report, Auto Enrollment Report.

•Involved in requirement analysis, design and implementation

•Participated in regular project status meetings

•Participated in smoke testing

Skills Used: PL/SQL, Oracle 11g, Java, Microsoft Excel, Agile, SVN

8. AonHewitt Cost-Centre wise Salary Report

Description: Cost-Centre wise Salary Report provides the breakup of an employee's salary based on the cost centre he was working.

Responsibilities:

Developed the PL/SQL package to identify the different effective dates and cost centrecodes for an employee for a particular month from the multiple data uploaded in the job history table and then each pay component was split between the cost centre.

Involved in writing complex SQL queries and performance tunning

Participated in testing with the migration and payroll processing teams

Participated in regular project status meetings

Skills Used: PL/SQL, SQL, Oracle 10g, SVN