Vishnu Sangishetty
Hyderabad
Summary
Oracle Fusion HCM and Oracle EBS HRMS consultant with over 10 plus years of IT experience in requirement analysis, implementation, and production support for HR modules, including global HR, payroll, and talent management. Recognized for enhancing productivity and efficiency in project execution. Expertise in business process optimization, risk management, and stakeholder engagement. Strong problem-solving and communication skills facilitate successful project outcomes and organizational improvements.
Overview
10
10
years of professional experience
Work History
Package Consultant – Oracle HCM
IBM India Pvt Ltd
Hyderabad
12.2021 - Current
- Identified business requirements and aligned them with Oracle Cloud/Fusion HCM functionality to ensure effective system utilization.
- Experience in Implementation and Support in Oracle Recruit module.
- Experience in Oracle Core HR Redwood migration using HCM Redwood Personalization Helper tool.
- Executed data migration using HCM data loaders to ensure accurate data transfer.
- Data Loading using HCM Data loader (HDL) which includes the Workforce structure data, Worker, Work relationships data, Performance Ratings, Salary, AOL's, Roles etc.
- Experience in Oracle HCM Application Security.
- Gained expertise in element configuration and element entries load processes for improved system functionality.
- Created BI Publisher reports tailored to client requirements, enhancing data visibility and decision-making.
- Customized the Sandbox environment by modifying labels and URLs for user-friendliness.
- Coordinating with Oracle for SRs, new product releases and upgrades.
- Executed post-production to test refresh activities for testing and development instances.
- Worked on Learning History data load, Create and Delete Goals using HCM Data Loaders.
- Reported progress and status to higher management on all business-related deliverables, facilitating informed decision-making.
- Hermes International is a French luxury design house and manufacturer established in 1837. It specializes in leather goods, silk goods, lifestyle accessories, home furnishings, perfumery, jewellery, watches and ready-to-wear. Since the 1950s, its logo has been a depiction of a ducal horse-drawn carriage. Hermes sales compose about 30% leather goods, 15% clothes, 12% scarves, and 43% other wares. It operates in 50 countries and sells its products in 306 exclusive stores worldwide.
Package Consultant – Oracle HCM
IBM India Pvt Ltd
12.2021 - 10.2023
- Gathered and documented business requirements from stakeholders to ensure alignment with project development goals.
- Developed different OTBI reports based on client requirements.
- Developed BI Publisher Reports based on client requirements.
- Loaded data into Fusion HCM using HCM Data Loader Tool, including workforce structure, worker data, work relationships, jobs, and positions.
- Created Reference Data Sets (RDS), Lookups, DFFs, and KFFs.
- Coordinated team efforts to resolve testing phase issues and escalated critical incidents to Oracle management for prompt resolution.
- International Airlines Group (IAG) is one of the world’s largest airline groups with 548 aircraft flying to 274 destinations and carrying almost 95 million passengers each year. Formed in January 2011, IAG is the parent company of Aer Lingus, British Airways (BA), Iberia and Vueling. British Airways (BA) is the UK’s largest international airline and one of the world’s leading global premium carriers. Its principal place of business is London, the world’s largest premium travel market, with significant presence at Heathrow, Gatwick and London City airports.
Oracle HRMS Techno Functional Consultant
4PI Info Tech Pvt Ltd
Virginia
04.2020 - 11.2021
- Developed procedures, functions, and packages in PL/SQL.
- Defining concurrent programs, executable, forms, request set, value sets.
- Demonstrated technical expertise in developing RICE components to enhance software functionality.
- Developed workflow functions, notifications, and attributes using Workflow Builder tool to streamline processes.
- Created XML Publisher reports.
- Prepared functional and technical documents, including MD50, MD70, and migration document MD120, to facilitate project clarity and alignment.
- Collaborated with Oracle Support to resolve production issues and bugs for Sev1 and Sev2 service requests, ensuring minimal disruption to operations.
- Loudoun County Public Schools (LCPS) is a branch of the Loudoun County Virginia, United States government, and administers public schools in the county. LCPS educated approximately 84,000 students per year. LCG is nothing but Loudoun County Government and the population estimated at 413,538. Loudoun County was established in 1757 from Fairfax County. Loudoun County is located in the Commonwealth of Virginia in the United States.
Software Developer
Tata Consultancy Services
Hyderabad
02.2016 - 04.2020
- Utilized APIs to import employee, assignment, and element data from legacy system into Oracle applications HRMS base tables for streamlined data management.
- Developed procedures, functions, and packages in advanced PL/SQL to enhance system capabilities.
- Debugged and fixed issues in PL/SQL custom packages to ensure system reliability.
- Writing API scripts to load legacy system data into Oracle Applications.
- Defining SIT’s, EIT’s, UDT’s, Flex fields, Value Sets, Concurrent Programs and Executables.
- Personalized forms to meet user requirements.
- Preparing BR100, Technical, Functional documents and user manual.
- Assisted in creating elements and links to define formula results and functions.
- APSRTC and TSRTC is a state-owned corporation that runs transport services within the Indian state of Andhra Pradesh and Telangana. TSRTC was formed in 2014 by splitting the Andhra Pradesh State Road Transport Corporation. It serves about 89.4 lakh passengers every day, having three zones and Services operating through 196 depots. For these we are using oracle apps r12 to handle different modules like HRMS, SCM, Finance and a few custom module-like operations.
Education
MTech -
Nova College of Engineering And Technology
01-2015
BTech -
Visvesvaraya College of Engineering And Technology
01-2013
Skills
- HCM data management
- Fusion HCM - Global HR, Compensation, Learning and Talent Modules
- Oracle ERP
- BIP and OTBI reports
- SQL and PL/SQL
- Data integration tools
- Redwood and Visual Builder Studio (VBS)
- AI Agent Studio
Disclaimer
I hereby clarify that information provided above is true to my belief and knowledge.
Personal Information
- Date of Birth: 05/10/91
- Nationality: Indian
Languages
- English
- Hindi
- Telugu
Timeline
Package Consultant – Oracle HCM
IBM India Pvt Ltd
12.2021 - Current
Package Consultant – Oracle HCM
IBM India Pvt Ltd
12.2021 - 10.2023
Oracle HRMS Techno Functional Consultant
4PI Info Tech Pvt Ltd
04.2020 - 11.2021
Software Developer
Tata Consultancy Services
02.2016 - 04.2020
MTech -
Nova College of Engineering And Technology
BTech -
Visvesvaraya College of Engineering And Technology