Data Manager

Jaswanth Reddy

Oracle Fusion HCM Consultant

Mobile: 510-***-****

E-Mail: Jaswanthoraclehcmgmail.com

Professional Summary

Having7 years of Oracle Fusion Applications Suite (R10/R11) experience in supporting applications development, configuration enhancements, setups, process design of HCM – Core HR, Payroll, Absence Management, Talent management

Oracle Fusion CLOUD HCM:

Having 3 Years of experience in Oracle Fusion HCM Cloud. Involved in the Fusion HCM internal project.

Successfully implemented Global HR and Payroll,Absence management module

Having Strong knowledge on HR Business Process. Hierarchies.

Well versed with AIM/OUM Methodology. Created BR100’s, MD050’s& contributed towards MD070 to document configurations Functional and Technical specifications.

Experience in creation of Business Unit, Business unit set assignment in Fusion HCM.

Having good knowledge on 2-Tier and 3-Tier employment models.

Configured Elements (various types recurring and non-recurring ) and Defined Salary Basis

Having strong knowledge on ESC, Job, Position Structure Creation and Deployment.

Defined Banks, Bank branches, Bank accounts and Payment methods in Payroll.

Proven ability to complete projects on schedule, plan strategically, work with attention to detail and to use

Practical / business like approach towards problem solving.

Expert in identifying process improvements which will help business in saving time and money.

Developed effective communication skills having dealt with diversity of professionals and staff members and also can adapt easily to new concepts and responsibilities.

Oracle E Business Suite:

Functional experience with Design, Development, Implementation, Customization and Production Support of Oracle Applications.

Proficient in defining Users, Responsibilities, Creating Functions, Menus, Request sets, Request groups, Registering Concurrent programs, Lookup types and defining Value sets.

Involved in the workshops conduction and suggest Oracle offerings to the clients.

Involved in the conduction of the new technologies in the team to improve the team members skill sets according to the IT Trend.

Having experience in the task assignment to the team members and manage the task statuses and follow up the team

Members and resolve the issues raised by the client.

Experienced in customizing the transaction types using the Oracle Approval Management.

Experienced in all aspects of software development life cycle such as performing gap analysis, writing functional specifications, implementing/customizing oracle applications to suit client requirements.

Worked with oracle support, using metalink, to resolve issues using knowledge base, SR/TAR.

Worked extensively on PL/SQL in developing the queries and on open interfaces in Inventory.

Worked Effectively on TOAD on 9i and 10g Database.

Worked in Production support and involved in activities like Monitoring, trouble shooting, documenting.

Experienced in Month end closing process for financial periods.

Involved in testing the functionality as and when required during the roll outs.

Worked on ad hoc reports to provide the financial data as per business and user needs.

Experienced in designing business processes, documenting standard operating procedures and training business users in these procedures. Also training client users at various levels from clerks through superusers.

Experienced in functional testing, integrated testing, setups, design validation and conducting conference room pilot.

Excellent communication and verbal skills at both User and Management levels.

Ability to work in a team environment with matrix reporting structure, actively participate in projects meetings, walkthroughs within work groups.

Excellent track record for meeting deadlines and submitting deliverables on time.

Excellent problem solving, decision making, communication and interpersonal skills.

Technical Skills:

ERP

Oracle eBusiness Suite 11i / R12 / Oracle Fusion Applications(R10,R11)

11i/R12

HRMS (Global HRMS, Payroll, Absence Management) Purchasing, i-Procurement, Inventory, Order Management, Accounts Payable, Accounts Receivable, i-Supplier

Fusion Cloud

Core-HR, Payroll, Absence Management, Talent Management

Methodologies

Oracle AIM/OUM Methodology & Systems Development Life Cycle

Business Apps

MS- Project, Outlook, Visio, Word, Excel, PowerPoint.

Databases

MS Access, Oracle 9i, SQL Server.

Languages

C, SQL, PL/SQL

Professional Experience

Client: Centene Corporation, St.Louis, MO Oct’2016-till date

Oracle Fusion HCM Techno-Functional Consultant

Description:

Centene Corporation, a Fortune 500 company, is a diversified, multi-national healthcare enterprise that provides a portfolio of services to government-sponsored healthcare programs, focusing on under-insured and uninsured individuals.Founded as a single health plan in 1984, Centene Corporation (Centene) has established itself as a national leader in the healthcare services field.

Responsibilities:

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.

Element Configuration using Payroll Batch Loader.

Element Input Values load.

Element Eligibility Profiles load using Payroll Batch loader.

Developed HCM Extracts to to extract the data from Oracle Cloud systems in HR Achieve

Developed BI publisher reports in Absence, HR and Payroll area and developed 2 HCM extracts, one of them is a changes only extract.

Phones and Job DFF information load using FBL.

Tested Core HR, Interfaces and Reports for Rel.10 Upgrade.

Implemented Workforce Compensation in Oracle Cloud for a global company

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

Configured custom security and data roles for different employee populations

Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes.

Driving and documenting business requirements and procedures, 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.

Provided business consulting support and facilitates discovery workshops.

Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies.

Manage Enterprise HCM Information.

Set up and Maintained Enterprise structure and Workforce structures.

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Fusion with Workforce Deployment (Global HR), Workforce Development (Talent Management).

Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.

Developing 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.

Creating Oracle Fusion BI Reports and Analytics.

Streamline Recruiting & On boarding processes with Core HR applications.

Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.

Ensure that the application meets the business requirement and system goals fulfil end user requirements, and to identify and resolve system issues.

USG, St. Louis, Chicago Aug’15 –Sep'16

Oracle Fusion HCM Techno-Functional Consultant

Description:

USG Company is a publicly traded American multinational and Gypsum biotechnology corporation headquartered in Chicago, To maintain their complete business transactions they are into Oracle Fusion HCM Cloud SAAS

Responsibilities:

Data migration using HDL – HCM data loaders.

Understanding the Business requirements to be a part of the FUD (Functional Upgrade Doc), and FDD (Functional Design Doc)

Ensure that the application meets the business requirements and system goals fulfill end user requirements, and to identify and resolve system issues.

Use Oracle Fusion Functional Setup Manager (FSM) to implement Global HR.

Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies.

Manage Enterprise HCM Information.

Set up and Maintained Enterprise structure and Workforce structures

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

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

Involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.

Involved in the Functional uptake discussion, which involves not only the impact of a particular functionality on the product, but also the various changes associated with it. These sessions also include the various areas which should be changed to cater to these 'functionality' changes.

Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities

Developing HCM Extracts for Global HR, Payroll Interface and Fusion Benefits

Ensure that the application meets the business requirement and system goals, fulfill end user requirements, and to identify and resolve system issues.

Custom billing reports and reconciliation based on Time and Labor tables.

Conversion reconciliation between Legacy and PeopleSoft Canadian Payroll. Created Reconciliation reports to automate the extraction and balancing of data sources.

Design custom vacation accrual and payout application.

Create garnishment and garnishment vendor Component Interface for General Deduction conversion.

Methodology for creating Excel Spreadsheet reports from Peoplecode using Java Interfaces.

Defined tracking procedures for technical gap analysis and issues tracking

Worked with Oracle DBA team to standardize development and functional access across all upgrade instances.

Create SQL Server TSQL procedures to evaluate conversion progress.

New accrual plan for (Absence Management Setup, Self Service Personalization, Form Personalization, User Hooks)

Electronic Arts, San Francisco Apr’14 –Aug'15

Oracle Fusion HCM Techno-Functional Consultant

Description:

Electronic Arts Inc. (EA) is an American video game company headquartered in Redwood City, California. The company was a pioneer of the early home computer games industry and was notable for promoting the designers and programmers responsible for its games. Electronic Arts was the world's fourth-largest gaming company by revenue after Tencent, Sonyand Microsoft.

Responsibilities:

Oracle Fusion HCM for Core HR, Talent Management

Fusion HCM Configuration using the BR100 given by the senior HCM consultant.

Involved in extending the functionality of Core HRMS modules. Successfully Interacted with Functional Consultants, QA team, DBA team and development teams. Developed Technical MD70 specification.

Customized menus, added new concurrent requests, registered the custom applications, value sets etc. using System Administrator Module.

Involved in implementing various business process extensions of HRMS as per the business requirements.

Personalized and extended various web pages on SSHR using Oracle Applications framework. Added Custom notes as per HR Polices.

Designed the conversion of key HR, Payroll and Benefits systems from a Mainframe to an Oracle platform. Composed detailed specifications to serve the conversion process.

Configured and maintained BR100 for setting environments in production, pre production, UAT, Patch and development instances.

Created PLSQL Procedures for importing year end W2 information from companies acquired.

Customized and extended fast formulas.

Supported a diverse variety of vendor software solutions including JAT Print view plus(W2), Apollo Space Planning/ Management and Transcentive Express Stock Options.

Wrote complex SQL queries, Control files, Procedures, Triggers and Packages.

Worked on Metalink to raise and track Service Requests to Oracle.

Coordinated knowledge transfer to technical team and guided them on prevailing technical issues and general Oracle Applications issues.Configured the workflow and approval tasks for Salary Change, Promotions, Transfers, Work relationships, Change manager, Change Location, Working hours change, Termination and ICD approvals based on the business requirement to route the approvals.

Approval setup for the leaves based on the leave types

Data Conversion of Employee personal information, Assignment Information and balance information.

Masco Corporation,NY Jan’13 –Mar'14

Oracle Applications Techno-Functional Consultant

Description:

Masco Corporation is a manufacturer of products for the home improvement and new home construction markets. Comprising more than 20 companies, the Masco conglomerate operates nearly 60 manufacturing facilities in the United States and over 20 in other parts of the world.

Responsibilities:

Involved in the Multiorg Architecture

Defined Ledgers, Operating Units, Business Groups

Worked with EIT,SIT

Customized Oracle EBS Flex fields according to the requirement.

Developed Outbound interfaces to extract the data from Database

Understanding the report functionality and Analysis and Review of High Level Documents mainly MD 50s.

Customization of Developed Reports.

Registration of Concurrent programs, Attaching concurrent programs to Request Groups, Creation of Value sets, placing the reports and interfaces in the AOL directory of the server

Analysis of the specifications provided by the clients

Developed & customized several reports in modules AP, PO, INV, OM and GL.

Registering Reports.

Responsible for Conversions, Interfaces and Customizations

Involved in the development of Stored Procedures and PL/SQL Packages.

KPN Networks,CA Jun’11 –Dec'12

Oracle Applications Techno-Functional Consultant

Description :

KPN is a Dutch landline and mobile telecommunications company. KPN started as a public telecommunications company and is based in The Hague, Netherlands. The company was formerly called Koninklijke PTT Nederland, and prior to that Staatsbedrijf der Posterijen, TelegrafieenTelefonie or PTT and was the publicly owned fixed-line operator of the Netherlands. KPN took on its present form on 1 January 1989 when the PTT was privatised.

Responsibilities:

Involved in the employee data conversions

Implemented Workforce Compensation in Oracle Cloud for a global company

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

Configured custom security and data roles for different employee populations

Part of business process workshops/CRPs and requirements gathering sessions and support clients in defining relevant processes.

Driving and documenting business requirements and procedures, 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.

Provided business consulting support and facilitates discovery workshops.

Perform Starter steps like Create Implementation Users; View all data roles, Load/Manage Geographies.

Manage Enterprise HCM Information.

Set up and Maintained Enterprise structure and Workforce structures.

Data Loading/Conversions using HCM Data loader (HDL) which includes the Workforce structure data, Worker data, Work relationships data, Salary info etc.

Fusion with Workforce Deployment (Global HR), Workforce Development (Talent Management).

Configuring custom Workflow routing rules for all Manager Self-services and Employee Self-services with help of Area Responsibilities.

Developing 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.

Creating Oracle Fusion BI Reports and Analytics.

Streamline Recruiting & On boarding processes with Core HR applications.

Build Custom Security for Fusion HCM which includes Create/Modify Data roles and its Security Profiles, Job Roles, Application Roles and Duty Roles.

Ensure that the application meets the business requirement and system goals fulfil end user requirements, and to identify and resolve system issues.

Customized Oracle XML Templates in Core HR module.

Defined Security profiles according to the requirement.

Integration of oracle apps with FMW in high level Architecture

Responsible for the New enhancements and Defects

Developed new XML templates according to client requirement.

Responsible to handle the offshore team, get updates from offshore team and interact with onsite for clarifications, project updates

Wells Fargo Bank,MI,USA Jan’11 –Jun'11

Oracle Applications Techno-Functional Consultant

Description:

Wells Fargo is a bank holding company. The Company is a diversified financial services company. It has three operating segments: Community Banking, Wholesale Banking and Wealth, Brokerage and Retirement. The Company provides retail, commercial and corporate banking services through banking stores and offices, the Internet and other distribution channels to individuals, businesses and institutions in other countries.

Responsibilities:

Being a resource in the project taking Responsible of Entire ERP Objects and working on New CR customizations, Enhancements a as per user requests, perform testing and document the test cases and migration scripts to Production

Taking the whole responsibility of the Upgrading Wells Fargo Project from R11.5.10.2 to R12.0.0Working with defects based on the priority

Worked for code Integration with Java in Adapters.

Worked for OAF pages customization and Form Personalization

Colorcon,MI,USA Jun’10 –Dec'10

Oracle Applications Techno-Functional Consultant

Description:

Colorcon has a firm commitment to providing best-in-class pharmaceutical products and services to support all phsases of solid dose design and development, along with superior technical support dedicated to meeting our customers’ needs. Our focus on market issues and technology development has earned Colorcon an international reputation as a pharmaceutical supplier of choice based on superior product quality, Unparalleled technical support.

Responsibilities:

Develop and code for “Supplier Conversion" and “Supplier Bank Conversion” Program to Interface all the data from third party systems to Oracle Payables.

Design and develop code for “Customer Conversion” program by using standard TCA API’s.

Design data templates for conversion programs and Developed the PO Conversion.

Design and develop custom Discoverer, BI Publisher reports as per user’s needs.

Responsible to develop technical specifications, to perform testing and validate the solutions developed by other team members and document the test cases

Preparing Installation scripts and Code bundle to Production.

Contact this candidate