Ashish Gupta
Oracle HCM Cloud Lead
Contact no: 646-***-****
Email ID: ***********.***@*****.***
PROFESSIONAL SUMMARY:
●Over 8+ plus years of Professional experience as an Oracle Cloud HCM/ Oracle Application Core HR Oracle Fusion Cloud HCM Cloud (Global HR, Payroll, Absence Management, Talenet Management), Compensation Management (benefits, Incentive and Total Compensation).
●Interacted with clients during the implementation process, involved in requirement gathering, preparing AIM and OUM documentation, business requirement documents, understanding current business process and mapping with Oracle cloud and EBS Applications.
●Excellent experience in Data loading into Oracle HCM Cloud using HCM Data Loader Tool which includes the Workforce structure data, Worker data, Work relationships data.
●Handled Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance.
●Experience in Creating BI Reports, Analytic & Dashboards using Fusion HCM OBIEE.
●Strong experience in Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud, Support & Maintenance.
●Good experience in engaging Oracle team on SR's and critical issues during the HCM Cloud implementation and ongoing Support for quick resolutions.
●Expert in identifying obstacles and issues, troubleshooting and working with team members to derive viable solutions.
●Experience in implementing Oracle applications using AIM/OUM methodology document templates.
●Experience on Fusion HCM Cloud and ability to configure Global HR, Oracle Advanced Benefits, Compensation Workbench, Talent, assigning duties to users, adding new approvals on transactions and Integrating with Oracle HCM Cloud, File/Worksheets based loaders for HCM components
●Import candidates (ready to hire) from Taleo recruiting to Cloud (Fusion) HCM using Import OracleTaleo recruiting Cloud Service Data Process.
●Expertise in Configurations, Personalization, Fusion Data Security, File - based loaders (FBL), Spreadsheet loader, Payroll Batch Loader, OTBI Reports, BI Publisher reports, HCM Extracts, Workflows and approval configuration, Fast Formulas for Benefits and payroll modules.
●Good Expertise and implementation experience on Fusion HCM Offerings: Talent Management, Workforce Deployment (Core HR), Workforce Development (Goal Management, Performance Management, Talent Review and Succession), Absence Management, and, Security.
●Implemented Oracle Fusion HCM, Talent Management, Compensation Management, Employee Self Service, Manager Self Service, Workflows and approvals, Reports and Analytics, Email Alerts/Notifications, Application Customization, Data Migration, etc.
●Have worked on implementation, production support, ongoing support (trouble shooting) and enhancement activities on oracle e-business suite applications (r12.1.1, r12.1.3, r12.2.4).
●Expertise in Oracle Payroll configuration with Oracle Time and Labor and Oracle Benefit modules in Multi-Org environments.
●Experience in managing HR data requests and Assemble, analyse and format data into useable reports.
●Implementation and support of Oracle EBS HRMS and Oracle Cloud HCM Talent management.
PROFESSIONAL EXPERIENCE:
Senior Oracle HCM Cloud Lead
April 2019 - Present
Wells Fargo, San Francisco CA
Responsibilities:
●Oracle Fusion HCM Cloud responsible for Implementation Support / Configuration of Oracle Fusion HCM Global Payroll, Absence, Performance Management and Workforce Modeling modules.
●Complete understanding of Oracle Apps Implementation in R12 and 11i and Upgrade Projects from 11i to R12. Performed several end-to-end implementations, upgrades as well as conducting conference room pilot (CRP), providing post production support, end user training and documentation.
●Conducted CRP1 sessions to demo the out of box functionality on Oracle EBS Core-HR, Payroll and Performance Management modules.
●Developed HCM Extracts/OBI Reports/OTBI Analytics for Global HR, PeopleSoft Payroll Interface and Fusion Benefits.
●Implemented Core HR-HCM, Performance, profile, Goal, Time and Labor & Benefits module and Taleo Recruit related all the transaction like Transfer, Termination, Promotion etc.
●Gather Core HR (Enterprise), Compensation, Absence business requirements (BRD) and map them to Oracle HCM Cloud functionality.
●Involved in the Integration & support to ADP applications used by client (e-TIME and Payforce) with Oracle (11i and R12).
●Developed functional designs in support of global system implementations. Recently completed Oracle HR implementation for Singapore.
●Configurations related to Absence Management and Talent Management.
●Identified business requirements for Core HCM, Absence, compensation, Performance and map them to Oracle HCM Cloud Application functionality.
●Conversant with Oracle e-Business Suite R12 - Core HR, Payroll and HR Self-Service, Oracle HCM cloud - Core HR modules with expertise in providing functional solutions for Oracle Applications and technology-based solutions for enhancing functional efficiency of the organization & achieving business excellence.
●Developed BI Reports/OTBI in Oracle Fusion Cloud and scheduled the reports with to be delivered to Email and FTP sites.
●Prepared several OTBI reports including customized reports for most HCM modules and Involved in raising SR with oracle & interacting with oracle team to solve SR related issues.
●Use Oracle Fusion Functional Setup Manager (FSM) to implement enhancements.
●Build Custom Security to Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles at APM, OIM and Security Console.
●Developed OTBI reports for HR users to view and validate employee data using existing subject areas.
●Excel in Oracle Human Resource business process mapping for Hiring, payroll administration, absence management, performance management, benefits administration, time management, termination processes.
●Payroll balance configuration and conversion, year-end and mid-year balance adjustment, execution of payroll processes, generation of Payslip, W2 and government reports for Oracle Payroll.
●Writing and modification of Fast formulas used in Oracle Payroll.
●Configuring and set up of OBIEE Security configuring object level and database level security.
●Managed configurations, process mapping, and issue remediation for Core HR, Employee/Manager Self Service, and Absence Management in an implementation and Provided functional design for all Absence Management Fast Formulas.
●Experienced in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
●Expertise in Oracle Payroll compensation management, Salary review, designing of especial earning rules using Fast formulas.
●Developed an OTL report to identify missing time cards and approve them using a custom program.
●Performed maintenance on existing HCM configurations and worked with the users and define standards on using Descriptive Flex fields from reporting and integration perspective.
●Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
●Determined all Cloud Global HR and Absence Management requirements for an ERP implementation project where a Mass Global Transfer was to occur.
Oracle HCM Cloud Consultant
January 2017 – April 2019
Nike, Beaverton OR
Responsibilities:
●Develop daily and weekly reports & Dashboards for various HR related metric like employee headcount, terminations, salary changes, department changes, Band changes & etc.
●Performed gap analysis between business requirements and Fusion Compensation and Benefits functionality
●Worked on Core HR, Absence Management, Talent Management, Payroll modules.
●Proficient with Subject areas in preparing Adhoc report with OTBI for Core-HR, Payroll, & Benefits modules
●Extracted high Volume of HCM data from Oracle Fusion HCM database in CSV format.
●Implemented Workforce and Compensation in Oracle Cloud for the company.
●Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.
●Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits
●Created custom actions to track changes to Human Capital Management (HCM) records.
●Created calendar events, work patterns and work schedules.
●Designed HCM Extracts for Inbound & Outbound Interfaces using FBL and HDL familiar with FusionCloud data model and build various BIP in fusion cloud environment.
●Involved in preparation of Test Cases, Test Scripts for the Global HR, Benefits, Talent and Global Compensation.
●Developed custom reports using Business Objects in Oracle-Taleo for leadership, human resources, and talent acquisition teams.
●Build Custom Security to Oracle HCM Cloud which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.
●Customized management self-service for viewing and updating multiple employee status data. RMS modules HR, Advance Benefits, OTL and Payroll.
●Worked on Oracle HCM modules Core HR, SSHR, Performance Management, iRecruitment and Compensation Workbench.
●Involved in data conversion effort to facilitate superior quality of data from Oracle EBS to Oracle Fusion HCM.
●Developed the Fast formulas for Applaud time entry, Accrual plans and Input validations- Approval setup for the leaves based on the leave types.
●Setup HCM Cloud security profiles, role mapping and role provisioning.
●Configured the high-level Benefits in the system, Life Events, Programs, Plan Types, Options, Plans, Eligibility Profiles, Collapsing Rules and etc.
●Proficient in preparing E-Text template & RTF file formats for Payroll, Benefits, Core-HR & Compensation modules.
●Shared knowledge to continually improve implementation methodology for Oracle HCM Cloud Fusion project.
●Developed fast formulas for Benefit and Payroll requirement.
●Customized OTBI reports, Payroll Extracts, HCM Extracts to feed the information to third party systems and downstream systems.
Oracle HCM Consultant
November 2013 – December 2016
Bank of America, Charlotte NC
Responsibilities:
●Work cross-functionally with different teams to ensure effective execution of Oracle HCM Software such as Oracle HCM Fusion & Taleo Applications.
●Functional, Integration, Technical and Transitions lead for Oracle Taleo/Fusion implementations.
●Performed active role in analyzing, designing, testing and implementing several interfaces/ customizations to implement core HR.
●Mainly involved in upgrading the system by performing the pre-upgrade and post upgrade steps.
●Involved in feasible analysis and setup for Standard and Customized workflow as per business requirement.
●Strong Exposure to Data Conversion and migration include HRMS, Payroll, Oracle Advanced Benefits (OAB), Oracle Time & Labor (OTL), modules to Oracle Applications using Oracle API.
●Implemented Performance Management by creating roles for eligible participants to access the performance document to provide feedback.
●An Outbound interface from Oracle HRMS to the Oracle Taleo. The interface primary handles all candidate data who are hired with different nationality.
●Analyzed and implemented several Oracle provided patches provided to fix the bugs in Production Environment and upgrade instances.
●Tested and maintained Oracle payroll module software for enhancements and complete new conversions.
●As primary HCM resource identified business requirements and performed tasks required for configuring Oracle HR.
●Set up payroll elements, element links and grades required for salary entry; created Extra Information types and elements to accommodate various allowances and data points.
●Coordinated user testing; worked with DBA's and Developers to facilitate transition of interfaces for Payroll and benefits to pristine environment.
●Working with ADP resources to upgrade payroll software from PCPW to Payforce and provided support for Payforce, ETime and ADP Connection.
●Setup and maintained enterprise and workforce structures and involved in the designing of payroll inbound and outbound interfaces.
●Worked with user's team to resolve pain points with the HRMS application.
Oracle Business Analyst
July 2011 – November 2013
Cigna, Bloomfield CT
Responsibilities:
●Involved in implementation of Oracle Accounts Payable and account standardization, Core setup includes Financial and Payable Options, EBtax setup including Regime to Rate flow, Configuration owner, Tax Rules and Tax automation.
●Designed and developed integration broker interfaces for inbound/outbound interfaces.
●Worked in development and implementation of Position Management module of PeopleAdmin 7 used to create electronic database of position descriptions and track position and salary change actions electronically.
●Conducted JAD sessions for requirement feasibility and risk analysis with various stakeholders to identify critical and high-risk areas of the application.
●Responsible for writing Business and Functional Requirement Documents (BRD's and FRD's) to initiate business transformation projects.
●Involved in setting up the delivered Excel to CI utility to load the data into Asset Management staging tables, AP ship to Locations.
●Reduced the overall ETL time by SQL Query performance Tuning.
●Worked on PeopleTools, PeopleCode, Application Designer, Application Packages, Application Engine, Component Interface, File Layout, Application Messaging, Integration Broker, Security, Tree Manager, PS Query, Process Scheduler, Data Mover, Import Manager, Workflow (AWE), Upgrade and Change Assistant, SQR, Crystal Reports and XML Publisher.
●Worked with business to understand the requirements. Preparing BRD, Functional specs, Solution Design Document and Process flow diagrams.
●Involved in handling modules like Core HRMS, NA Payroll, Time and Labour and Benefits Administration and other PeopleSoft bolt on modules like Leave Management System (LMS) and Operators Time Tracking System (OTS).
●Assisted all the stakeholders throughout the SDLC life cycle from the requirements perspective.
Business Analyst
April 2009 – July 2011
Abbott Laboratories, Chicago IL
●Assisted senior project manager and the project team with day to day project planning, scheduling, reporting and coordination tasks.
●Scheduled and facilitated weekly status report meeting for the Project Team and for key Stakeholders.
●Conducted Business Reviews, User Interviews, weekly/ Monthly meetings with Business Users, SME’s.
●Utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
●Prepared process flow/activity diagram for existing system using MS Visio and re-engineer the design based on business requirements
●Analyzed Requirements and created Business Requirements Document (BRD), Functional Requirements document (FSD) and Use Case Specifications using Requisite Pro
●Prepared system requirement specifications (SRS), system design document (SDS), traceability matrix (RTM),and testing strategy
●Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, using UML and Business Process Modeling.
●Provided recommendations for Process improvements and prepared functional requirements specifications for Configuration and program changes.
●Incorporated User Stories in different release plans for the sprints in Scrum process.
●Re-engineered system workflows for off shore developments the development ran through onsite-offshore business model.
●Involved in analyzing requirements, creating prototypes/wire frames and User Interface (UI) Diagram.
●Gathered Business requirements for Integration points and mapped them with Functional requirements.
●Designed new reports and also improvements to existing ones.
●Coordinated lean events for process improvements.
●Created AS-IS and TO-BE business process flow diagrams, Integrate process flow diagrams to show end-to-end business model and business process mapping including swim lanes.
●Guided development teams to break down large and complex user story into simplified versions for execution.
●Used JIRA for tracking bugs and issues.
●Performed Data Analysis of existing data through SQL and MS Access.
●Worked to create Data Mapping Documents and worked with business to write transformation rules through SQL.
Education Details
Bachelor’s Degree June 2002 – June 2005
Don Bosco College, Kathmandu (Nepal)
Master’s Degree March 2007 – March 2009
Everest University, Orlando FL