PROFESSIONAL SUMMARY:

• Having 7+ years of OracleFusion Applications Suite (R10/R11) experience in supporting applications development, configuration enhancements, setups, process design of HCM - Core HR,Payroll,Absence Management, Talent management
• 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.
• Experience in Full Life Cycle Implementation projects which includes expertise from Requirement Gathering, GAP Analysis, Database & Application Design & Development, Implementation, Pilot Testing, Impact Analysis, User Training, Go-live & Production Support.
• Extensive experience in Oracle Application modules like General ledger(GL), Accounts Payables(AP), Accounts Receivables(AR), Advance Global Intercompany System (AGIS), Cash Management(CM), e-Business Tax and Vertex
• Hands on experience in supporting Oracle Application Modules Fixed Assets (FA), Purchasing Order (PO), Order Management (OM), Advance Collections.
• Good functional knowledge in "Procure to Pay" and "Order to Cash" business flows.
• Good understanding of (AIM and OUM) on documents: BP075, BR100, MD050, MD070, RD060etc.,
• Specialized in Financial module, has effectively streamlined operations at various client locations (India and USA) and won several client recommendations.
• 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 membersand also can adapt easily to new concepts and responsibilities.
• 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 theIT 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, AccountsReceivable,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:

Confidential, St.Louis,MO

Senior Oracle EBS Financials Functional Consultant

Responsibilities:

• Worked on Core HR, Absence Management, Talent Management, Payroll modules.
• End to end Implementation of module - AGIS (Advance Global Intercompany System) for APAC, EMEA and NALA regions.
• Worked with Oracle (on SR's) closely, created 19 Service requests with oracle on various patches, bug fixes and enhancements requests with Oracle for AGIS.
• Worked with business users and IT on Requirement gathering for intercompany solutions (on 170 entities).
• Identified delta setups and Documented BR100, MD050, BP075
• Configured delta setups like organizations, security, system options, Transaction types, assignments, customer and supplier associations, customer and supplies along with their site creations etc.
• Tested the end-to-end process through WEBADI and normal AGIS process.
• Created new Legal entities, Legers and OU's for APAC, EMEA and NALA Regions.
• Defined new secondary ledgers and their mapping for (12 countries).
• Defined document sequencing, Accounting sequencing and reporting sequencing for the secondary ledgers and tested end to end.
• Changed subledger accounting options from Detail to Summary for all Ledgers (65).
• Worked on FA Tax books conversion for the newly acquired acquisition assets (around 14000 assets).
• Provided the solution and converted tax book through FA TAX INTERFACE.
• Liaison as functional consultant with business users, OBIEE development team for the newly developed AGIS and GL custom reports (worked on Requirement gathering, MD050, testing etc.).
• Conducted CRP1, CRP2, SIT & User Acceptance Testing (UAT) and getting sign off.

Environment: Oracle Financials 12.1.1: AGIS, GL and FA.

Confidential, St. Louis, Chicago

Oracle Fusion HCM Techno-Functional Consultant

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)

Confidential, San Francisco

Oracle Fusion HCM Techno-Functional Consultant

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.

Confidential, NY

Oracle Applications Techno-Functional Consultant

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.

Confidential, CA

Oracle Applications Techno-Functional Consultant

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

Confidential, MI

Oracle Applications Techno-Functional Consultant

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

Confidential, MI

Oracle Applications Techno-Functional Consultant

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.