Anand Gaurav

• Currently working as Lead Software Engineer by supporting Production Support for Core HR, Compensation, Goals & Performance, Check-In's and Security Modules.
• Collaborated on all stages of the systems development lifecycle from requirements gathering to production releases.
• Involved in complete technical requirement analysis and data collection for Interfaces, Reports and Analysis from client.
• Developed several custom and integration reports using the reporting tools like OTBI (Oracle Transactional Business Intelligence), BIP (Business Intelligence Publisher).
• Have strong knowledge of the templates for developing the reports, like Excel Template, RTF template, Seeded template and e-text template.
• Hands-On experience in creating Dashboards, Prompts using OTBI as per client requirement.
• Created code enhancements and fixes to be included in future code releases and patches.
• Done extensive R&D on Security Console and Data Loaders .
• Hands on experience in using the HCM ( HCM Data Loader), HSDL ( HCM Spread Sheet Data Loader ) and PBL ( Payroll Batch Loader ).
• Created several fast formula of type Compensation Default and Override, Participation and Rate Eligibility for using them in Compensation Worksheet and Batch Loader type Fast Formula for transforming the data received from a third party and loaded the data via HDL. .
• Prepared Migration Documents and Backup Documents For Reports, Dashboard Changes, Lookups, Fast Formulas and more.
• Created and Maintained TDD (Technical Design Document).
• Participated in UAT and supported the client to resolve the issues on demand.
• Creation of Custom Security Roles for Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
• Developed complex person security profiles to support the complex custom criteria while configuring the data roles.
• Done personalization's and wrote EL Expressions using sandbox as per business requirement.
• Extended support as and when required in project, which include co-ordination with support teams, additional requirement analysis.

• Currently working as HRIS Technical Analyst by supporting Production Support for Core HR, Payroll, Benefits, Compensation, Security.

• Closely involved in gathering requirement and collecting required data for creating Interfaces, BI & OTBI Reports, Full from business.

• Interacted with Client/Business in gathering requirement and prepared requirement documents like MD050 and MD070 for technical Design, TE040 for Test Script and RD054 for Functional Design Document.

• Worked on a few Payroll inbound integrations which includes creating a Batch Loader type Fast Formula and automated this process using PBL.

• Developed Full and Changes Only Extracts.

• Developed Full Mode and changes only Extracts to integrate data with Payroll System for Equifax, ADP, Baker Tilley for modules like Core HR, Payroll, Benefits.

• Hands on experience on creating fast formulas of type Extract Rule,

• Hands on experience on HCM, PBL and HSDL data loaders for various modules like Core HR, Compensation, Benefits, Payroll.

• Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.

• Prepared Test Scenarios and Test Scripts for Core HR, MSS, ESS and Security.

• Done Personalization's using sandbox as per business requirements.

• Designed Employee & Manager Self Service and My Portrait as per the business requirement.

• Hands on experience on converting the payroll objects like Add Payroll Relationship, Update Assignment Payroll, Update Assigned Payroll, Tax Withholding, Involuntary deduction cards, Balances, External Bank Accounts, Personal Payment Methods, Loading Element Entries and Third-Party Payment Payees using both HDL.

• Created documentation on running/scheduling reports/interfaces/extracts, accessing the dashboard, migration document, test scripts etc.

• Worked on Core HR, Absence Management, Talent Management, Payroll modules.
• Configured the Absence Management module to enable the Vacation and Sick plans.
• Written Accrual fast formulas to support the vacation and sick absence plans.
• Developed new BI reports to extract the absence details and related other reports.
• Developed and configured new roles (Job, Duty and Data roles) using the Fusion Security model.
• Developed complex person security profiles, organization security profiles to support the complex custom criteria while configuring the job and data roles.
• Written a Payroll Batch Loader transformation formula to load the Element Entries.
• Created Custom reports as per client requirement across the modules Global HR, Compensation, Goal and performance management using OTBI and BI Publisher.
• Developed several Payroll reports using the Subject areas, Analysis provided in the Oracle Transactional Business Intelligence (OTBI).
• Developed HCM Extracts to extract the data from Oracle Cloud systems in HR Archive.
• Developed BI publisher reports in Absence, HR and Payroll area and developed HCM extracts.
• Conducted extensive testing cycles and solution design workshops
• Designed custom reporting and interfaces to meet client and audit requirements.
• Supported client in Oracle Cloud UI personalization's and customizations for end users.
• Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes.
• Driving and documenting business requirements and procedures to obtain sign off to ensure Client alignment of proposed solution.
• Configured HR and Absence management modules.
• Coordinating with Oracle for SRs, new product releases, upgrades/patches/fixes.
• Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
• Hands on experience in using Payroll Batch Loader (PBL) for loading Payroll related data.
• Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.
• Developed HCM Extracts for Global HR, Payroll Interface and Fusion Benefits.
• Coordinate with QA team and ensure the product is bug free and ensure all test cases and scenarios are covered.
• Created Oracle Fusion BI Reports and Analytics.
• Streamline Recruiting & On boarding processes with Core HR applications.
• Created Custom HCM extracts for extracting the payroll related data.

● Hired, trained, and managed employees, including preparing and conducting performance evaluations.

● Supervised two satellite IT locations and safeguarded operational infrastructure.

● Managed more than twenty software engineers, system administrators, QA engineers and project managers.

● Supported IT application development, application support, system integration and system administration projects, generating more than twenty-five thousand billable hours annually.

● Taught and supervised sixteen employees of my team through effective coaching, disciplined leadership, and technical skill.

● Authored RFP for purchase and implementation of Oracle ERP solutions to migrate from On-prem solutions to Oracle Cloud based system for improved productivity.

● Kept project teams on-task with proactive control of budgets, schedules, and scopes.

● Communicated with Senior Leadership and Stakeholders to support company growth and optimize processes.

● Managed implementation of application developments by collaborating with overseas technical teams.

● Delivered consistent and quality mentoring, training, and onboarding for teams of contractors and staff members.

● Connected with customers to relate any system changes and integrate customer feedback into improvement processes.

● Used clients' requirements to develop targeted solutions to fit specific needs in Oracle ERP GRC space.

● Worked closely with all stakeholders to identify business issues.

● Assessed clients' needs and created a plan of action to provide business solutions.

● Worked hard daily to promote exemplary level of tailored service to each customer, whether through email, by phone or in person.

● Recommended key updates to system software based on performance data, user feedback and integrated software enhancements.

● Handled complex problems and issues by understanding the root cause of the issue and implementing solutions.

● Assisted with the continuous improvement of IT Risk Management based on learnings from client implementation, previous experiences, and ideas.

● Tested and troubleshot application and documented issue resolutions for the development team.

● Coordinated with project managers across multiple initiatives to align development timelines, plan testing and work with client representatives.

● Leveraged Agile methodologies to move development lifecycle rapidly through initial prototyping to enterprise-quality testing and final implementation.

● Developed and maintained technical expertise in Oracle ERP and Oracle GRC.

● Managed user profiles, security access and shared file structures.

● Collaborated with development team members to create and integrate high availability solutions for mission-critical applications.

● Tested and troubleshot application and documented issue resolutions for the development team.

Managed user profiles, security access and shared file structures.

● Researched, documented, and escalated support cases to higher levels of support when unable to resolve issues using available resources.

● Developed and maintained technical expertise in Oracle EBS and PL/SQL.

● Executed scripts to communicate with back-end servers and provide real-time updates.

● Collaborated with lead consultants and developers.

Developed reports outlining Oracle ERP security risk results to facilitate management decision making.