Oracle Software Engineer

Mayank Pathak

Mobile: - +91-783*******

Email: - ******.***@*****.***

OBJECTIVE

• To apply learned knowledge in practical situations and sharpen problem-solving skills.

• Looking for a challenging position in a renowned organization where I can contribute towards the

growth of the organization in ERP and HR Applications field using my expertise knowledge and skills.

EXPERIENCE SUMMARY

Total experience – 3Years 7Months

•

• Experienced as Oracle Finance Consultant in Oracle EBS R12. Experience includes Implementation

and technical issues in AR, AP and GL Module.

• Experience in Kronos WFC 6.2, 6.3, 7 Configuration and Implementation.

• Experience in providing Services over Cloud.

• Experienced on Kronos Module timekeeper (WTK), Scheduling, HR, Accruals, Self-service.

• Experienced in Configuring Kronos Terminal devices like 4500, In-Touch Device.

• Strong hand on configuring Workflow notification in Kronos Application.

• Strong Knowledge of PL/SQL and SQL (Both Oracle and SQL Server).

• Basic knowledge of Oracle ADF.

• Strong Knowledge of Automating Application through various technologies and software in Cloud.

• Experience in developing Crystal Reports, Oracle Reports, Kronos report.

• Experience in developing interfaces through PL/SQL application (WIM).

• Experience as Oracle HRMS Consultant in Oracle EBS R12. Experience includes resolving issues in

Core HRMS and OTL Module.

• ERP domain expertise on various Modules – AP, AR, GL, CM, Core HRMS, OTL, OSS.

• Adept at handling varied functions related to Oracle. Proven capability in meeting deadlines and

completing tasks unsupervised.

• Excellent Team Building, Leadership and Communication skills.

Page 1 of 5

PROFESSIONAL EXPERIENCE

Computer Sciences Corporation India Pvt. Ltd

Associate Software Engineer (June 2011 – 13-Dec-2013)

As an Associate software engineer understand the core business of the client and provide 24*7 supports to the

outsourcing, training and consulting.

• Worked on various projects related to implementation through PL/SQL, DBMS in Oracle EBS Finance

and HRMS.

• Strong knowledge of troubleshooting issue in all important interfaces related to Oracle Finance.

• Defined the Workflow for O2C and P2P cycles.

• Attended Training on Oracle Fusion Middleware Finance Implementation from Oracle University.

• Handle the status call, business requirement session and work efficiently with the team members on

the tasks assigned.

• Have trained and mentored new joiners in Oracle EBS Finance & HRMS skills.

• Have played a role in initiating Competency Building sessions within our team.

• Attend all the mandatory training at my level as part of CMMI level 5.

Kronos Solution India Pvt. Ltd.

Technical Specialist 2 (16-Dec-2013 to till present)

As a Technical Specialist 2 understand the Kronos WFC products insight in order to help the Kronos

customers.

• Manage the Services provided by Kronos over Cloud.

Page 2 of 5

• Gained insight knowledge of Kronos products.

• Worked on Application Health check, System Health checks, Service pack upgrades in Kronos

Products.

• Developed Interfaces through WIM in various modules of Kronos.

• Worked on various WFC configurations and have insight of end to end implementation of Kronos.

• Manage the documentation as per the rule of Incident management.

• Worked on Automation of various reports as per the requirement of Kronos Customer.

• To ensure that best practice is followed by team members while solving customer issues.

Technical Exposure

TECHNICAL

Operating System : Windows Xp,Vista,7,8, Mac OS, Linux, Android.

Languages : SQL, PL/SQL,Java, Jquery, YQL, Batch programming.

Database : Oracle11g, Sql server 2008 and 2012.

GUI : Oracle EBS, Kronos WFC, WIM, WPD, WRM Toad 7.6/9.5, SQL Developer, Eclipse,

Crystal reports, JDeveloper.

Tools and Utilities : Oracle EBS R12, Oracle Fusion Finance, Oracle EBS R12 Finance& HRMS module, Crystal

Report 11, Oracle Report, SSRS, SOAP, KITE, SD manager, PEGA.

ORGANIZATIONAL EXPERIENCE

Key Project Undertaken

Client- : Belron ( UK & France & Ireland) ( June 11 to December 13)

Project Description:

BELRON is the world's largest vehicle glass repair and replacement (VGRR) company and implemented Oracle

SCM, Financials and HRMS. Re Implementation of R12 completed in April 2012.

Role – Technical consultant

Location – Bangalore and Noida

Contribution

• Supporting existing application as a Techno Functional Consultant.

• Enhancing custom objects as per requirements.

• Enhancing existing application as per new requirements.

• Worked on migration to Oracle 11i to Oracle R12. Experience includes Customer Mass Upload

during migration and data migration of AR invoices and receipts from 11i to R12 as per the

business rules defined by business.

• Worked on issues related to Oracle Finance module and provided insight solution for issues in

given timeframe.

• Worked on Interfaces, Reports in Oracle EBS R12.

• Working on application Implementation in other projects within CSC to enhance my skills.

• Developed application to handle the Invoice printing in AP and AR.

• Worked 24*7 support for monitoring Finance, SCM, DWH jobs and provided immediate solution in

case of any failure

Page 3 of 5

Customer : Nike Worldwide ( December 13 to till date)

Project Description:

Nike is an American multinational corporation that is engaged in the design, development, manufacturing

and worldwide marketing and selling of footwear, apparel, equipment, accessories and services.

Role – Technical Specialist 2

Location - Noida, India

Contribution

• Supporting existing application as a Techno Functional Consultant.

• Worked for the development of Kronos Reports using Sql Server Reporting Services (SSRS)

by fetching the records from the database using the Sql and Plsql queries.

• The report once completed is integrated with the application called Kronos where the report is

being deployed for the actual implementation

• These are the dynamic reports which we can use for multiple stores with different search criteria.

• Development of the Kronos WFM Application.

•

Customer: Rail corp ( December 13 to till date)

Project Description:

Rail Corporation New South Wales (RailCorp) is a statutory authority of the State of New South Wales. It is

the custodian of railway real estate, infrastructure and trains. [1]

Role – Technical Specialist 2

Location - Noida, India

Contribution

• Working on the development and testing of Stored Procedure and other database objects.

• Stored Procedures are used to load data into database and to extract data from the database.

• Also working on developing SSIS packages to load data from file and validating it.

• We are using clear case which is a source control tool used to manage code.

Customer- : Ikea ( December 13 to till date)

Project Description:

IKEA is the world’s most successful mass-market retailer, selling Scandinavian-style home furnishings and

other house goods in 230 stores in 33 countries and hosting 410 million shoppers per year.

Role – Technical Specialist 2

Location - Noida, India

Contribution

• Creating database objects like procedures, functions, packages etc.

• Knowledge on developing SSIS packages which loads historical store data into database.

• Developing SSRS reports on Client requests.

• Knowledge of end to end product configuration, creating work rules, pay rules, break rules, exception rule etc. and

assigning it to employees’ profile.

Page 4 of 5

• Supporting the Kronos Product, resolving the issues raised by client and providing proper solution.

Environment –

Oracle EBS R12, Oracle Financial, Oracle Fusion, Oracle HRMS and Oracle 11g, Work Force

Central 6.3,7. Open Air, Citrix.

ACEDEMICS

B.E (2006-2010) in Information Science Engineering from Sir MVIT, Bangalore under VTU Belgaum.

MBA (2011-2013) (Finance Management) from Sikkim Manipal University.

CERTIFICATION

Completed OCA certification in Oracle 11g Pl/Sql developer.

Kronos Workforce Timekeeper, Scheduler, Accruals, HR, Terminal devices.

Kronos Product Automation tools.

Oracle Fusion Financial Implementation essentials in AR module.

ITIL V3 2011 v5 certified.

STRENGTH

I am a quick learner & good listener.

Good analytical and reasoning skills.

Amiable, Flexible and Social Person.

Committed to work towards Excellence.

Flexible to work in shifts.

A good team player.

PERSONAL DETAILS

Date of Birth : 08-12-1989

Father’s Name : Pradeep Kumar Pathak

Martial status : Unmarried

Languages Known : English, Hindi,

Permanent Address : B-45D Rajat Viihar, Noida

Present Address : B-45D Rajat Viihar, Noida

Page 5 of 5

Contact this candidate