SUMMARY

• Over Twenty plus years of Experience in Functional and Technical areas in Oracle HCM Modules and Relational Database Management Systems (RDBMS) and Client/Server environment.
• Extensive Knowledge in Oracle, PL/SQL and strong application expertise in Oracle HRMS.
• Extensive experience in Implementation, Migration, Customization and Support of various modules in Oracle Applications within HCM
• Extensive experience in gathering requirements, analysis, design, development and deployment.
• Exposure to AGILE methodology
• Hands - on experience in Data Conversion, Report Generation and Developing Interfaces within several modules in Oracle Applications
• Worked on Design, Development, and Post implementation maintenance and support of Oracle Applications E-Business Suite.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions).
• Strong understanding of business flows, underlying technical architecture and table structure of Oracle E-Business Suite.
• Supported the production system with day-to-day issues and worked with business users and Oracle Support as required.
• Extensively experienced in Oracle PL/SQL Development i.e. Stored Procedures, Packages, Functions & Triggers.
• Having experience in implementations of life cycle process including analysis, design, development and testing.
• Worked as a Technical/Functional lead for some of the projects. Provided Guidance to Junior Associates. Strong Relationship with Business Analysts, Client Service Managers and Quality Assurance teams.
• Good analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Good functional understanding/Configuration experience on HCM Modules.
• Ability to interact with individuals at all levels and Accustomed to working under tight schedules.
• Incorporated best practices in Development work environment in all the phases of project lifecycle to in corporate Company’s norms and coding standards.

TECHNICAL SKILLS

• SQL and PL/SQL procedures
• Sql Loader
• WEBADI
• Fast Formulas
• Custom concurrent programs
• Discoverer and BI Publisher reporting

PROFESSIONAL EXPERIENCE

Sr. Software Engineer

Confidential

Responsibilities:

• Design and Developed Cloud HCM extracts for Benefits Vendors
• Created multiple OTBI and BI Publisher reports to support Business Needs
• Automated the process to assigning Benefit groups to New Hires
• Created Fast Formulas for post election rule for Voluntary Life Coverages
• Created new benefit plans and set up eligibility profiles
• Involved in set up integrations between Cloud HCM and EBS
• Support recurring activities - Benefits Open Enrollment, Merit/Bonus cycle, quarterly performance reviews
• Provided Day to Day support for Business users
• Mass upload of data using HDL and Spreadsheet loaders

Sr. Systems Business Analyst

Confidential

Responsibilities:

• Involved in Requirements gathering for Aetna deductions extract
• Lead the Conversion Team for four New Acquisitions for HR and Benefits
• Created New BI Publisher and OTBI Reports for various reporting requirements
• Created New Benefit plans for Medical and Vision
• Created variable rate profiles for part time Employees and added to Standard Rates
• Created Benefit Group for Grand Fathered Employees to provide benefits who works less than 20 hours
• Configured Open Enrollment for Year 2017, 2018, 2019 and 2020 for Two Companies from beginning to end like Changing the dates for all plans, update the rates for different plans and option combos, set up enrollment period and scheduling jobs
• Involved in making plan option changes for Compensation, Removing Lumpsum and High Performance options from Merit Plan and some modifications on worksheet
• Configured and posted Compensation Merit Cycles for 2018 and 2019
• Create New Fast Formulas and made existing Fast Formulas Changes for Benefits Eligibility
• Mass upload of grade changes thru HDL for all active Employees
• Involved in conversion life cycle from Oracle EBS to Oracle HCM
• Supported ongoing HR/Benefits users for their day to day Production Issues
• Supported Taleo Production Issues

Principal Consultant

Confidential

Responsibilities:

• Responsible to maintain and enhance the Custom GL process.
• Responsible to design and develop the Fast Formulae in OTL to meet different requirements in terms of validations.
• Responsible to configure the system for the Sick Leave Policy in the Accruals and also to restrict the users from entering Sick Leave when they are on unpaid leave.
• Implemented the New PTO Accrual plan based on Unions
• Design and Developed interfaces which sends employees data to Identity Management and other Third Party Vendors.
• Responsible to create new Discoverer Reports based on User requirements
• Responsible to design and Develop interfaces inbound/outbound for Benefits Module which handles benefit eligibility.
• Troubleshoot issues in Payroll and OTL modules during regular payroll processing. Execute onetime data scripts to fix any data issues related to HR, Payroll and OTL modules.
• Responsible to rollout and testing of all Oracle and Vertex updates and ensure that Oracle HCM system is at the current patch level.
• Year End Payroll support.
• Created New Benefit Plans and Options as per the business needs
• Created New option and added to all existing plans
• Created New Standard Rates for the New option
• Configured and Supported Open Enrollment from end to end for the Benefitted Employees.
• Techno-Functional consultant designing and developing customizations and extensions using SQL, PL/SQL, Fast Formulas in HR and Payroll.

Senior Software Engineer

Confidential

Responsibilities:

• Implemented Absence Management and Paid Time Off applications by leading business process sessions, fit/gap analysis, configuration, functional design, and project management activities
• Developed fast formulas, interfaces and reports in Oracle HR, Payroll modules by authoring technical design documents, unit test plans and conducting unit tests
• Collaborated with executive leadership team to streamline existing complex Paid Time Off policies that are based on legacy application to map them into Oracle
• Performed systems analysis and provided solutions for around 200 enhancement projects across seven clients in Oracle HR, Payroll modules.
• Managed a team of four people through the implementation by assigning day-to-day tasks, conducting reviews, guiding them through the milestones, maintaining project plan and providing status reports.
• Played a crucial role of being the single point of contact for Business, Development, Quality Assurance, Project Management teams and lead the projects for successful completion.
• Lead a team of business analysts in documenting functional requirements for over 180 custom components (conversions, interfaces, reports and extensions. Developed a framework to capture business requirements to minimize back and forth communication with developers.
• Conducted training sessions to train business users with skills required to use and maintain HRMS applications.
• Client support for various operations related to HR and Payroll.
• Working as Lead for Work Intake and Deconversion Projects.
• Participation in team project planning.
• Involved in Code reviews and Unit test plan reviews with Other team Members.
• Self-directed archival and versioning of code using Clear Case Management Tool
• Conducted training sessions to train business users with skills required to use and maintain HRMS applications.

Software Engineer

Confidential

Responsibilities:

• Responsible for supporting Oracle HR & Payroll applications Rel 11, 11i and Oracle 8, 9i.
• Job duties include troubleshooting incidents, bugs on custom code, Fast Formulas, Fixing Production Issues.
• Supporting 7 Production HR/Payroll clients for their payroll runs
• Identify Root Cause and resolve technical issues and communicate to the team.

System Analyst

Confidential

Responsibilities:

• Designed and developed Financial Accounting system for Confidential corporation.
• This system was developed to maintain various types of transactions like receipt -vouchers, payment vouchers, journal vouchers and cash vouchers.
• Apart from queries various types of reports like trail balance, profit and loss account, balance sheet, general - ledger, opening /closing balance.