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.