Post Job Free

Resume

Sign in

Oracle Developer

Location:
Alpharetta, GA
Salary:
125000
Posted:
October 03, 2018

Contact this candidate

Resume:

R E S U M E

SHAILENDRA KUMAR

Dover, NH-*****

ac69kp@r.postjobfree.com

Phone: 603-***-****(Cell)

EXPERIENCE SUMMARY/OVERVIEW

US Permanent Resident(Green Card) with Over 18+ years of extensive experience as Oracle Applications Techno-Functional Consultant Oracle HR/Payroll, financial, Coupa & Ariba application in various Capacities (Solution Architect, Project Lead/Mgr and senior developer/Engineer) in implementation, upgrade and support of Oracle e-Business Suite Applications. This includes Requirement Gathering, Process mapping, Gap analysis, User Training, system study, estimate, design, development, post implementation, maintenance and support of Oracle EBS 10.7 NCA/11i/12i/Fusion and managing Teams of various sizes working. Well versed in Agile, Waterfall methodologies/environment, Global Delivery, on shore/off shore models.

Application

Applications

#Years

EBS Version

Core HR/Payroll

18

HCM Fusion, R10/11, R12.2.5,R12.1.3, 11.x,10.7 NCA

Self-Service HR(SSHR)

15

11.X, 12.1.3, 12.2.5

Advance Benefits, OTL, Kronos,Taleo

5

11.X, 12.1.3, 12.2.5

Oracle Financial AP,AR,GL,FA,O2C, Order Mgmt

7

11.X, 12.1.3, 12.2.5

Procure to Pay

5

12.1.3, 12.2.5

iExpense, iProcurement

iSupplier.Sourcing

Contracts Core

5

11.X, 12.1.3, 12.2.5

Coupa

1

R18.0.5, R20.6.1

Ariba

1

9r1

Clients/Project Summary

Client/year

Project

EBS Version

Remarks

E*Trade

Oracle HR/Payroll

R12.1.3

Integration with ICIMS and ADP

Staples

(Jul 2017-Apr 2018)

Oracle Financial(AP,AR,GL,FA)

Coupa, Ariba

12.1.3

Support of EBS R12.1.3

Coupa R18.0.5 => R20.6.1

Ariba 9r1

Synchrony Financial (GE Capital)(Feb 2015 – Jul 2017)

Oracle HR/Payroll, Procure to pay,GL,FA,Contract, iSupplier

12.2.3

New Implementation and

R11.5.10=> R12.2.3

R12.2.3 => R12.2.5

HCM Fusion R10

Liberty Mutual (Feb 2003- Dec 2014)

Oracle HR/Payroll and Financial system R12 upgrade

12.1.3

Upgrade R11.5.10 => R12.1.3

HR Global Implementation,

Company Acquisitions/Mergers, Reorg, Business Group Consolidation, Custom Apps & Third Party Integration

Agere/Lucent(Jun 2002-Feb 2003)

HR/Payroll Implementation

R11

New Implementation R11i

PRC Inc.(Apr 2000- May 2002)

Oracle EBS Upgrade R11

R11

10.7.NCA => R11

Gaylord Ent Inc. (Oct 1999-Mar 2000)

Oracle EBS(HR/Payroll, Financial and manufacturing Implementation

R10

Maintenance and support of R10.7

Haworth Inc.(Mar 1999 – Sep 1999)

Oracle EBS(HR/Payroll, Financial and manufacturing Implementation

R10

New Implementation 10.7

Experience Summary

Solution Design and Integration with internal/external and 3rd Party systems like ADP, Hewitt, Sabrix. OSN, Coupa, Ariba, Kenexa, Corner Stone, Bravanta, ICIMS,CTI, Fircosoft etc.

Gap Analysis, Helping business in Defining roadmap, setting realistic goals/targets, work estimation, project and resource planning etc.

Requirement Gathering Working closely with business partners in defining/writing business requirement, Test strategy and Implementation plan.

Experienced in Data flow, object modeling, Case & workflow analysis, functional decomposition, customization, data migration, testing and training services involving Oracle EBS R12/ 11i/10.7 NCA versions, Fusion 10, BI/XML Publisher reports

Production Support and Change Management ensuring SLA is met

System configuration and setups like Descriptive and Key flex fields, Extra(EIT) and Special(SIT) information Types, profile Options, Task flow, Security profiles, Menu, responsibility, AME etc

Custom development and integration with 3rd Party systems within Oracle EBS suite including oracle standard & Self-services (OAF) forms, reports(standard and BI Publisher), Inbound/Outbound interfaces, Web-services, Processes etc. and HCM Fusion application

Team Lead Managing Small to mid-size on-site/offshore Teams across various projects within Oracle EBS and custom application and it’s integration with EBS.

Review of Technical, functional Design documents and sign-off

Experience in data loader(HDL), and Configuration/setups of Fusion Apps in loading/configuring Job,Employee, Salary, Salary Basis, Payroll and Benefit elements etc..

Reporting and Data Migrations (BI Publisher, OTBI, HCM Extracts etc.) within Fusion apps.

Setup/Configuration of Oracle Standard/Advance benefits fast formulas used in Oracle Payroll, Advance Benefits etc.

.Extensive experience in Customization/extension and Personalization of core HR/Payroll and SSHR and Oracle Financial applications.

Helping with Technical and application upgrade and year end processes and activities.

Support company/clients’ Merger acquisition processes by mass data upload and conversion.

Process Improvement, Tools evaluations and feasibility analysis.

Working with Oracle on service requests, issue resolution, escalation as needed.

Functional/Domain

Core Oracle HR Payroll and SSHR(Self Service HR & Oracle Core EBS(PUI)Applications)

Oracle Advance Benefits setup, Eligibility Profile, Benefit Structure, administration and enrollment process

Oracle Financials (Procure to Pay, iExpense, AP,AR,GL,PO, Fixed Assets, Projects, Contracts Core, O2C,Order Management, iProcurement, iSupplier, Sourcing)

Compensation and Benefits, On-line Appraisal and rating system

Time-Management/Attendance recording Systems.

Sales, purchase and invoicing systems.

Search systems(Library, Spot Law)

Stock/Share Management systems

Software Skills/Tools(Primary)

Development Tools

Oracle suite of Development Tools( Forms and reports (9i/6i/4.5/3,

Jdeveloper, Discoverer, BI Publisher, Oracle workflow builder, Alert. 10G

OA Framework, Kbace Kubes and Database C, Unix Shell Scripting, Oracle

Alerts, Workflow builder 2.5/2.6,3.10G, Kbace, BI/XML Publisher report,

TOAD,PL/SQL Developer, AME, Informatica, Big Data/Hadoop, Python, Machine Learning,

Application

Oracle Apps EBS Suite R12/11i,10.7 NCA (HR/Payroll, Financial), Fusion R10, Kbace, Coupa R18/20, Ariba9r1, Sabrix

Support Tools

Appworx, Service Now, Clarity

Databases

Oracle 12,11/10/9/8,7.3,6 FoxPro,sql server

Version/Migration Tools

Subversion(SVN),CVS,PVCS, Jira,Bamboo,Visual Source Safe, Apps Integrity, Applimation, Integra Codebase, BitBucket

Methodology

SSADM,Earnst & Young Methodology, SDLC, Waterfall Method

Office Product

Power Point, MS Word Excel,Visio, Project

EDUCATION : MCA (Master of Computer Application)

PROFESSIONAL EXPERIENCE

E*Trade Inc, Alpharetta,GA Since Jun 2018

Position : Sr. Developer

Project : HR/Payroll and Oracle Financial systems

Environment : Oracle Apps R12.1.3

Tools : Oracle suite of Development Tools(Forms, Reports, Jdeveloper, BI/XML Publisher, Workflow Builder),SQL*Developer

Project Overview : Integration of HR systems with ICIMS and ADP application and support Oracle financial systems AP,AR,GL. iprocurement

Staples, Framingham,MA Jul 2017 – Apr 2018

Position : Team Lead

Project : Coupa,Ariba,Oracle Financial

Environment : Oracle Apps R12.1.3, Coupa,Ariba

Tools : Oracle suite of Development Tools(Forms, Reports, Jdeveloper, BI/XML Publisher, Workflow Builder) TOAD

Project Overview : Maintenance and Support of Coupa R18/R20,Ariba 9r1,Oracle Application (HR/Payroll, AP,AR,GL,FA), production support, maintenance and enhancements. Working with Off-shore Team and Coupa (SaaS Vendor) on defect management and issue resolution.

Key Tasks/Accomplishments

Integration of Peoplesoft HR/Payroll System with Coupa and AP system

Smooth seamless upgrade of Coupa R18=>R20

Ariba Admin/Support

IDM/SIAM Integration to Coupa

Oracle Financial(AP,FA,GL)=>Coupa Integration and vice versa and enhancements

Rest APIs to Extract POs for 3rd Party Systems

Ariba & Coupa Audit Reports

Coupa Sysadmin Activity

Synchrony Financials (GE Capital) Alpharetta, GA Feb 2015 – Jul 2017

Position : Solution Architect/Lead Consultant

Project : Synchrony BTP(Buy to Pay), HCM Fusion R10

Client : Synchrony Financials, Alpharetta, GA

Environment : Oracle Apps R12.2.4, Sun Solaris, Gentran, APPWORX,SVN

Tools : Oracle suite of Development Tools(Forms, Reports, Jdeveloper, BI/XML Publisher, Workflow Builder) OA framework, PL/SQL Developer

Project Overview : Implementation of Oracle Procure to Pay(iProcurment,iSupplier,AP,AR,PO,Oracle Contract, web-center) productions support and enhancement and Implementation of HCM Fusion r10

Responsibilities :

Data Load using HDL loader, HCM Extracts and OTBI reporting in support of HCM fusion application.

Payroll setup and configurations, Extracts and OTBI reporting in support of Payroll operation and 3rd Party Intergrations

Conduct user Acceptance Testing

Solution Design and development(Conversion, Interfaces, reporting, forms(standard and OAF)

Functional/Technical Design Review and sign-off

Project Planning, Work Estimation, Task and resource allocation, Managing off-shore Team

Production support, Enhancement, Patch Review and release management

Setup Configuration (AME, Workflow, Profile, Lookups, DFFS, Setup, configurations, Menu, Functions, Responsibilities)

Key Tasks :

Conversion : HR Data(Employee, Job),Supplier, Contract, PO, Invoices, Receipts, Payments

HDL : Person, Grade, Job, Salary, Salary basis

OTBI : Person, Compensation

HCM Extract : Benefit enrollment extracts(Healthcare, 401K), Employee and Compensation Details

Interfaces : GL, Epiq, Reval, Tangoe, T360, CTI, Kelly, Metrics, Fircosoft, WorkDay, Aspera, Service now, HR3, Workday

Customization : Account Generator, PR,PO, Invoice Approvals, Form, Supplier Change History,One time location

Personalizations : In Charge of Applying all personalization to P2P Implementation

Reports : Open POs, Supplier, Contracts, Payments, Cash Forecast, hold (Invoice, Payment),Web-Center, Cycle-Time Requisition Approvals, Invoice Hold, Month End Accruals, Supplier Details, Supplier Change History, Month-End Accrual report

Integration : Sabrix (One Source) tax calculation, Web-Center

Setups/Configurations : Custom Menu, Responsibilities, Functions, DFFs, Profile, Benefit Administration

Assisted in Business process mapping and prototyping, gap analysis, solution design, HRMS setup, testing and user training.

Trianz Herndon,VA Feb 2003 – Jan 2015

Position : Sr. Consultant/Architect

Project : Liberty Gateway,Managing clients investment of Oracle E-

Biz(HR/Payroll,SSHR,iExpense) Applications

Client : Liberty Mutual, Dover, NH

Environment : Oracle Apps R12/11i, Oracle 10G, Forms/Reports 6i/9i/10g,Kbace, SSHR

3/4/5.X, Discoverer 4i/10G

Tools : Oracle suite of Development Tools (Forms, Reports, Jdeveloper, Discoverer), TOAD,

Responsibilities: Managing Oracle HR/Payroll and iexpense AP, GL application for Approx.. 40000+ employee,Non-Paid Employees, Temp/Contingent worker. Responsibilities included but not limited to

Participate in requirement meeting for each release with clients and other stake holders.

Involved in providing High level and Low level design documents, resourcing needs, risk analysis, quality control and release management and estimates.

Coordinated meetings with Project Manager, Testing groups etc. to discuss on the Project implementation, resource availability and issues / delay in completing the task.

Involved in quality reviews assuring the development team follows the coding standards, proper design & documentation etc.

Software Tool Evaluation, Configuration and Recommendation

On-site/Off-shore Co-ordination

Delivery and Software Change Control Management and Migration.

Application and Technical Upgrades

Family pack, Year-end activities for HR/Payroll systems

Custom application development and it’s integration with Oracle EBS-suite.

Changes, enhancements, bug fixing, production support

Customization, extension/personalization of E-Biz to support Liberty Mutual’s business process.

Data conversion/migration to Ensure seamless integration of Liberty’s acquisition of companies like Safeco, Ohio Causality, Prudential life and business decisions(SBU realignment, reorg etc.)

Building HR self-service and custom Data feeds warehouse.

Managing Security model and Access level within Liberty Gateway

Testing and issue resolutions during various Technical/application upgrades

Process improvements and day to day issue resolutions

Key Achievements/Milestones

ADP W2 Interface

Analysis and Design of LM W2 data and it’s integration with ADP facilitating them to print LM W2 to print and host them online.

HR Global Implementation Phase 1 & Phase 2

Implementation of multi-byte characters and process updates to support them.

Helping business in setup, defining transactions, work estimation, realistic time-line etc.

Key role in Forms, process updates to support and capture data for international employees.

Wrote API’s to load/convert employee data

R-12 Upgrade and Remediation

Gap Analysis, Implementation Review for R12 Upgrade to 12.1.3

Re-implementation of Contractor as Contingent worker

Remediation of PL/SQL based custom applications like PCM, OSPE,Ergo assessment to OAF

Re-implementation of ERGO assessment using custom workflow and notifications

Extension of Payroll Archive process, Viewing Pay slip using BI publisher.

On-shore/Off-shore Model

Played key role in setting up on-site/off-shore to enable 24/7 support model.

Task & Progress monitoring and management reporting.

Helping in process/model definition in line with Liberty’s process and Vendor Company practices.

Family Pack Upgrades(2003 thru 2013)

Re-apply customization

Break-fix

Database Upgrades

8i=>9i(2005)

9i=>10g(2009)

10g=>11g(2011)

Application Upgrades

SSHR Upgrades(3.x =>4.x) 2003, Oracle 11.5.9 Upgrades(2005)

SSHR Upgrades(Converted Several Functions in use using OAF) 2006

ATG Upgrades 2003,2005,2007,2008,2010-12

Oracle Ebiz 11i=>R12, 2012

Technical Upgrades

ATG Upgrades(2003,05,07,08,10,11,12)

JRE, Application Tools upgrades etc.

Server/Operating system upgrades

Data Conversion

To support integration of company acquisitions/mergers (Ohio Casuality, Prudential Life,Safeco, Wausau Insurance. Etc.

Business group Consolidation

Company Re-org, SBU realignment etc.

Custom Development and its Integration with Oracle Ebiz

PCM ( Liberty’s Rating System)

Non-employee Manager Self service

Job Profile System

ERGO Assessment and CRM system

EDM(E-document management)

Others

HR Self Service Data services

On-line Payslip/Proxy Pay slip implementation

On-line W-2 Implementation

Non-Employee Manager self-service implementation

Time-Tracking Workforce system implementations

Taleo Integration

Leading Consultants Inc, Wayne, PA June 2002 – Feb 2003

Position : Programmer/Analyst

Project#1 : HR & Payroll, Financial implementation(AP,AR,GL,FA)

Client : Agere Systems (Formerly Lucent Technologies), Allentown, PA

Environment : Oracle Apps 11i, Oracle 8i, Sql Navigator 4.1,Forms 6i,Reports 6i,Kbase, PVCS

Responsibilities : Being Key member of the EAD team for Mega 11i HR/Payroll implementation

Worked on following key inbound processes.

Wrote Technical Design documents for key inbound processes (i.e. TRI(Time Reporting Interface), Hewitt, Nucleus, fidelity 401K,Retro and Prior Period Corrections.)

Developed the programs for TRI and Nucleus Interfaces and common lookup package.

Setting up Xref and global Table setup to make program independent of element name Changes

Provided assistance in other key processes like United Way, Convergys, Concur, Edcor etc.

Mentored and Guided Other Junior Team Member/Staff as needed

Worked with P2P (Procure to pay) business flow including modules PO (purchase order), AP (accounts payable) and GL (general ledger), O2C (Order to Cash), OM(Order Management)

Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar

PRC Inc. Plantation,FL-33324 April 2001 – May 2002

Position : Programmer/Analyst

Role : Sr. Developer, Study, Analysis, Design, Development, Production support & upgrades

Environment : Oracle Apps 11i, Oracle 8i, Sql Navigator 3.0, Forms/reports 6i,discoverer 3.0/4.0, Kbace, Visual Source safe, Kbace, PVCS

Application : Core HR/Payroll,SSHR AP,AR,GL,Fixed Assets, Kronos, DSL

Projects(Duration)

Client

Description

HR/Payroll,SSHR,Oracle Financial

(Apr 2001 – May 2002)

Internal

Core HR/Payroll,SSHR and Financial Applications (AP.AR,GL,Fixed Assets, Iexpense), Kronos.

Oracle E-Biz upgrade(10.7 NCA -11i) May 2001 – Nov 2001

Internal

upgrading 10.7 NCA => 11i

Responsibilities : Study, Design, Development, production support

Key Tasks/Achievements

Processes/customizations : Payroll processing using Pay Group, Report set leveraging 11i multi-thread feature, Check-writer, deposit advises, Nacha File. Absence & Pay element synchronization, Element creation and end-dating automation, sick hour accruals & adjustments. Enhancement to promotion, demotion, Transfer, Change supervisor, Termination Process, Open benefit enrollment, Performance appraisal process Garnishment, Full and final process

Inbounds/outbounds : Aetna, Cigna, Prudential, JP Morgan, Solomon Smith & Barney,HSN,401K etc.

Reports and Alerts : Pre-Payment DD > $12K,Discrepeancy,Job,office dept. change

UBICS Inc. Canonsburg, PA-15317 March 1999 - April 2001

Position : System Analyst reports

Role : Sr. Developer/Consultant

Responsibilities : Study Analysis, Design & Development

Software Tools : Oracle Apps 11i, 10.7 NCA, Oracle Dev suites(Forms,,Discoverer),Oracle

workflow, Alerts, Toad,SQl Navigator, PVCS,Apps integrity,Visual Sourcesafe, Kbace

Application : Core HR/Payroll,SSHR AP,AR,GL,Fixed Assets, Kronos, DSL

Projects(Duration)

Client

Description

Prism System(Oracle HR/Payroll and Financial Application)

(Apr 2000 - Apr 2001)

PRC Inc. Plantation,FL-33324,

Oracle HCM,SSHR and Finacial Applications(AP.AR,GL,Fixed Assets,Iexpense), Kronos.

Financial and Galaxy System

( Oct 1999-Mar 2000)

Gaylord Entertainment Company, Nashville, TN-37217

Oracle Financial(AP,AR,GL) and HCM applications

NGEN (March, 1999 - Sep, 1999)

Haworth Inc., Holland, MI-49423

New Implementation of Oracle Applications(HCM,Financial & Manufacturing).

Key Tasks/Achievements :

Processes/Customization : PTO Allocation and processing(screen+Fast Formula,CM jobs), Benefit enrollment automation, Year End, Payroll processing, Workflows, Notifications, Time Management, Recruitment, Compensation and benefits, Termination, Reverse Termination, Absence Management

Inbounds/Outbounds : Cigna,Aethna, ADP, Kronos,Hewitt, 401K, Prudential, BEE,

Reports/Alerts : Vendor Aging, Trial Balance, Hidden Paycheck,Declination, Trial Balance,Earning by elements, Gross to net, Earning History(Balance,Element), Trial Balance Summary,Details,Opryland Check register, A/C Xref, Procurement Expenditure,Applicant flow,Personal Information, EEO reporting New hire, High Deposit Advices/Check Amt., Vendor Pending Payments

Data Conversion : Personic(Applicant & Employee), address, Phone, Contacts, Batch file etc.



Contact this candidate