Candidates About

 

Kartikey Sharma

Oracle EBS Functional Consultant

OBJECTIVE                                                                                                                                                 

To become a Leading Software Professional by Continuously Reinventing my Capabilities and growing along with an organization and hence contributing effectively to the Software Industry. I am also willing to be part of innovative team that provides challenges and possibilities to utilize my skills and creativeness.

 SKILLS                                                                                                                                  

Oracle :	Oracle E-business suite R12/11.5.10 version
Oracle Modules:	Accounts Payable (AP), Accounts Receivable (AR), Oracle General Ledger (GL), Project Accounting (PA), Fixed Assets (FA), Oracle Purchasing (PO), PRM (Project Resource Management), SLA
Languages:	SQL, PL/SQL, Unix
Others:	PowerPoint, MS-Word, MS-Excel, MS-PowerPoint, Kofax /170, SharePoint, JIRA
Oracle Tools:	Oracle - Developer 2000/6i (Forms, Reports), Toad 6.0/8.0/9.0, XML Publisher, Workflow Builder

PROFESSIONAL SUMMARY

                                                                                                                                                                                     

 

·         10 years of strong experience as an Oracle ERP functional Consultant and worked as a Functional Analyst in Implementations, Upgrade, customization and Post Production Support of Oracle ERP version R12/11i.

·         Strong technical and functional knowledge of Oracle R12 SLA, Oracle Projects Billing, Costing and Accounting  (PA),General Ledger (GL), Accounts Receivable (AR).

·         Good working exposure in Accounts Payables (AP), Purchasing (PO), I-Expenses, I-Procurement, Fixed Assets (FA), Project Resource Management (PRM)

·         Strong experience in business requirement analysis, testing (unit/integration/system) and designing of functional data process flow charts.

·         Performed the standard configuration and setups for Oracle Projects, Account Receivable, and General Ledger for multiple operating units which include -- functional solution architecture, functional detail design, technical design, development, coding, testing, end-user training, post-implementation support and customization.

·         Strong proven experience in release management and handling scope prioritization meetings with major business stakeholder.

·         Actively participated in Oracle ERP R12 upgrade, fully understood the new and enhanced functionality delivered by the upgrade, became familiar with the upgrade test scripts, and provided reliable post-upgrade support.

·         Analyzed As-Is and To-Be process Oracle R12 upgrade, involved in Solution Design, functional setups, CRP-I, CRP-II, SITs, UAT-1 & 2 with business stakeholders. Specifically the current and future Month End Close Processes for GL and Revenue Recognition team.

·         Strong understanding of integration of Oracle Applications modules, Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.

·         Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.

·         Handled multiple releases, big scope items and designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.

·         Wide experience in functional setups, creating data and process flow diagrams for Contract to Cash (C2C) and Procure to Pay (P2P) business cycle.

·         Strong management, organizational and communication skills displayed during communication with clients, project stakeholders, key users, technical team and project status/review meetings.

·         Strong hands on experience and prepared multiple Business Requirement Documents (BRD100) technical design documents (MD50, MD70), conducted impact analysis, final cutover management for customizations and for multiple releases/scope items.

·         Designed the Functional solution to the Key Gaps through Interface, Extension, Customization, Reports.

·         Collaboration with the Business users & Stakeholders during the various stages of project lifecycle.

·         Experience with Oracle AIM/SDLC methodology, worked on Waterfall and Agile methodology, business process and Fit Gap Analysis. Document and analyze "as is" and "to be" process flows covering all the functionality to satisfy business need and requirements.

·         Extensive and proven Experience in onshore - offshore models and providing onsite technical and functional support to various business teams.

·         Expertise in post implementation support, prepared training manuals and also trained end users.

·         Well versed with Application tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms, Oracle*Reports, Workflow, Discoverer, XML publisher, Data loader, Web ADI.

·         Wide experience on business process flows and strong understanding of technical architecture and table structure of Oracle ERP R12/11i.

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

·         Interpersonal skills, good communication skills, and quick adaption to new applications and technologies.

·         Self-motivated, can work independently or as a part of team, follows through and completes tasks with a minimum of oversight.

·         Having Strong analytical and problem-solving skills to troubleshoot and resolve production issues in a timely manner. Demonstrated creativity and flexibility to manage complex tasks and develop innovative solutions.

·         Excellent verbal and written communication skills and able to do multitasking. Ability to interact with people at all levels and good presentation skills.

 

WORK HISTORY

                                                                                                                                                                                   

Sapient corporation                                                                                                  Boston, MA

Consultant oracle application                                                                           Aug 12 – Present

                                                                                                                                                                                    

Role: Business System Analyst

Project: Oracle 11i/R12 Support

 

Responsibilities:

·         Leading the offshore technical & functional team and working in multiple time zones for implementing the Functional and technical solutions under PA, GL, AP, AR, and FA modules.

·         Providing functional support to US, CANADA, GERMANY & UK finance users to achieve their daily business goals and deliverables.

·         2012-2016 Independently handled almost 550+ business requirements which include new enhancements, bugs, data pull activities, and user knowledge related issue and system issues.

·         2012-1016, deriving end to end solution, successfully rolled out approx. 400 scope items in various Oracle module (PA,GL,AP,AR,FA).  Additionally managed approx. 40 monthly releases and 15 big scope items. These items were mostly logged by various onshore business teams.

·         Involved in upgrading custom reports, developing new reports and customizing standard reports in PA, AR, GL, FA and AP Analyzing the issues on Production System and resolving them.

·         Performed routine fixes for P2P issues in setup of users, responsibilities, suppliers, requisitions, purchase orders, receiving, invoicing, payments.

·         Prepared BR100, MD50, MD70, impact analysis, carrying out SITs, Test cases review, Users Acceptance Test (UAT), go-live activities, trainings and Post implementation support.

·         Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization.

·         Provided Training & Conducted Practice & Additional Business Requirements sessions as per business requirements.

·         Actively involved with business team while doing the Month End, Quarter End and Year End Close process.

·         Assisting and resolving issue related to Interface cleanup activities, FSG modifications, Auto Accounting rules modifications, PID creation issue, GL import, WebADI data upload, Labor costing and Billing, Timecard exceptions, AME modification for various payable categories, Stuck Expense reports, bank setups, Misc. transactions upload issue in PA, Auto Accounting issue debug, depreciation and create accounting issue in fixed asset, Project Costing and Billing related issue, intercompany transactions, GL reconciliations, account & cost center related issues, Intercompany system, Revaluation and Translation.

·         Successfully accomplished and resolved various SOX compliance issue and successfully handled external Audit through recommendation, system customization & modifications, Adhoc system data.

·         Successfully accomplished many big releases. Few big milestones are (2015-16):

Ø  New Revenue Recognitions and forecast generation solution (Staffing Based Revenue); Journal Approval solution in General Ledger; Defined formulas for Mass Allocation and Recurring Journals in GL; Accounting improvement (new auto accounting rules, accounts, expenditure types);  Enabling 5^th segment in all COA for new trading partner; 2 new operating unit setups; FSG Cleanup; Intergroup revenue generation and new forecast logic, New AME rollout;

 

Sapient corporation                                                                                                  Boston, MA

Consultant oracle application                                                                            JUN-13 – JUL14

 

Role: Business System Analyst

Project: Oracle R12 Implementation

 

Responsibilities:

·         Actively participated in Oracle R12 upgrades, fully understand new and enhanced functionality delivered by the upgrade, become familiar with the upgrade test scripts, and provide reliable post-upgrade support.

·         Providing onsite production support for 11i and in parallel performing additional duties for R12 implementation which include business requirements gathering , gap analysis , creating  business process flow diagram for existing (11i) and new version (R12).

·         Analyzed As-Is and To-Be process, involved in Solution Design, functional setups verification in PA, AR & GL. Specifically the current and future Month End Close Processes for GL and Revenue Recognition team.

·         Defining/maintaining data access set for multiple OU/responsibilities, data migration activities, custom report requirements, FSG Update, New COA mapping.

·         Successfully completed the CEMLI analysis (Configuration, Extension, Modification, Localization, and Integration) analysis process.

·         Requirement gathering from Revenue team about accounting options, methods of accounting, realized gain / loss account.

·         Worked with cross-functional groups (Procure to Pay cycle) for cross functional issues raised by US Account payable, I-Expense and PO teams.

·         Designed & developed training material and provided training for all levels of users on new functionalities configured. Documented the best practices, issue resolution approach and root cause analysis.

·         Assisted users in month end closing process, reconciliation, generating month end reports. 

·         Worked with Oracle Support (Metalink) on high-priority production support issues which came under R12 UAT & SITs. Worked with Oracle Support engineers and Duty Managers to avoid delays in issue resolution and successfully resolved all issues in time.

·         Worked with Dev Team to analyze and research Oracle patches, identify the need for regression testing, coordinate testing tasks with business team and follow existing internal SOX practices for deployment of code changes, configuration modifications and patches to Production

·         Documented the adhoc business requirements, current and future Processes specific to AR, PA & GL, wish-list from top managements and preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports (RICE) for all P1 & P2 issue.

·         Provided full support to business users and analyzed, understood business users strategic direction, issues, and project goals in order to deliver exemplary customer service to clients. Provided full support in UAT from minor P4 issue to major P1 issues.

·         Successfully derived various R12 specific SITs (System Integration Testing), UAT (User Acceptance Testing), Test cases preparations and other logistics like User’s availability, desired system configurations.

·         Running defect triage meeting, maintaining all bug, issues, queries in RS3 and reporting the same to Manager and ensuring proper closure of all, addressing and resolving issue which came in CRP1, CRP2 and UAT for US users.

Sapient corporation                                                                                                  Delhi, India

Sr. Consultant oracle application                                                                    APR-07 – MAY-12

 

Projects:

Ø  Interface Cleanup and exception reporting

Ø  New operating unit Setups

Ø  New Business Unit Data Migrations

Ø  Legacy system retirement for PID creation

Ø  Labor cost and Billing Improvement

 

Role: Oracle Analyst- Track lead

Responsibilities:

·          Worked as a functional analyst covering the Oracle Projects and Receivables modules.

·          Interacted with clients to understand the present business process and gathering of business requirements

·          Designed and implemented end to end solution for Interface cleanup and exception reporting between various sub module (PA, AR, and AP) and GL. Its Include Time card data, Labor Data, Misc. batch Data, Revenue Data, Expense Report Data and defined governance model for same.

·          Operational efficiency increased by 4 hours and saved the external vendor cost approx. $150k.

·         As a part of team successfully implemented 6 operating units .Individually implemented PA, AR, GL modules for the same.

·         Implemented some key features of Project Accounting such as rate schedule, transaction control and auto-accounting rules, Implementation of labor cost rate schedules.

·         Did all AR Setups like Defined AR System Options Transaction Types, Payment Terms, Tax Rules, Auto Accounting Rules, Transaction Batch Sources, Distribution Sets, Transaction Activities, Auto Cash Rule Sets, Receipt Sources

·         Performed the standard configuration and setups for project billing like Setting-up New Project Template, Auto accounting Rules, defining expenditure types, payment terms, bill rate schedule, Auto-accounting set-up, etc. Setup of expenditure categories and expenditure types. .

·         Performed the data collection, data migration activities and successfully migrated 3000 Internal PIDs from legacy system to Oracle.

·         Conducted Business Process Review and fit-gap analysis to fulfill business requirements.

·         Prepared BR100, MD50. Responsible for business Sign off, QC and UAT sign off.

·         Performed end-to-end unit testing for respective module and did the test case review, UAT scenarios, and UAT sign off and successfully roll out on Production.

Project:

Ø  Revenue Recognition and forecast generation Process

Ø  Billing Automation Process & AR Invoice Automations

Ø  Half day billing

Ø  New Billing CAP types

 

Role: Oracle Analyst

Responsibilities:

 

·     5 New accounting treatment were defined and according to that system will generated the revenue and forecast for the PIDs.

·     Designed the new Time and Labor accounting treatment for revenue generation which is completely based on Labor (Time card Data)

·     Registered the Concurrent Programs, Forms, Reports and Requests Sets in AOL and System Administration

·     Implemented new billing cycle and assign this to PID so that Invoices can be generated on every month’s fixed day for different project type.

·     New CAP type logics defined for billing team and modified billing pkgs.

·     Single handedly explored possibilities to generate LABOR & EXPENSE Invoices from Oracle itself and generate them in PDF format.

·     Developed new Final Invoice RDF (Summary & Detail) reports which can print the different PDF layout based on user setup.

·     Converted existing Oracle Reports to XML/BI Publisher Report through Oracle’s desktop XML Publisher tool

·     Involved in kick off meetings, requirement gathering session with business; drafted the requirements with proposed solutions and presented the same.

·     Prepared the BR100, MD50/70, POC, Impact analysis documents.

·     Responsible for getting business sign offs, managing SITs, QA,UAT TARs, performing daily checkpoints, send status report to manager, prepared the cutover and final rollout on Production.

 

Project:  Oracle Production Support

Role: Oracle Analyst

Responsibilities:

 

·         Responsible for Support and Release Activities for the Oracle EBS.

·         Successfully handled and resolved daily support and enhancement tickets, worked with business leads to establish priorities and managed to deliver the same.

·         Provided initial functional analysis of issues reported and resolving the cases through user education or standard functionality options wherever possible.

·         Ensure support tickets are resolved in a timely and efficient manner.

·         Designed customizations, enhancements and configuration changes for new requests both inside and outside a standard release cycle.

·         Ensure user requirements are met, owning multiple steps in the standard SDLC (Software Delivery Lifecycle): Business Requirements, Functional Design, System Testing and Deployment.

·         Study user operations and identify areas of potential improvement or possible problems and document requirements for improving operations. Streamline functions and processes with Oracle EBS.

 

EDUCATION

                                                                                                                                                                                   

BACHELOR OF ENGINEERING (B.E.) in COMPUTER SCIENCE                                                                   JAIPUR, INDIA

                                                                                                                                                     JAN 2001 – JUL 2005

REWARDS

                                                                                                                                                                                   

·         Winner of “Star Performer” for ‘Billing Automation Process & AR Invoice Automations’ project.

·         Winner of “Star Performer” for ‘Interface Cleanup and exception reporting’ project.

·         Winner of “Creative excellence” award for Daily Support activities.

·         TOP RANKED in all the APPRAISALS cycle.

 

CERTIFICATIONS/TRAININGS

                                                                                                                                                                                   

·         11i/2.6 Implement oracle workflow Ed3 certification

·         R12.x Oracle