Email: acxl4n@r.postjobfree.com

Smitha George

(Permanent Resident of Canada) Mobile: 604-***-****

**** ******* ******, *******, **, V5H2Z2 https://ca.linkedin.com/in/smitha-george-96783798

Summary

10+ years of experience in analysis, design, development, implementation and support of Oracle

E-business Suite (11i and R12 EBS).

Experienced in Implementation and customization of oracle 11i and R12-Account Payables ( AP),

General Ledger (GL), Account Receivables ( AR), Cash Management (CE), Oracle Internet

Expenses (iExpense), iSupplier, iProcurement, Fixed Assets (FA), Project Accounting (PA),

Purchase Order (PO), Human Resource Management System ( HRMS), Oracle learning

Management (OLM), Inventory (INV) and Cost Management (CM).

Expertise in implementation and customization of RICEWF components.

Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.

Proficient in personalizing Oracle 10g forms and customizing XML/BI Publisher reports.

Experience in the preparation of Functional Design, Technical Design documents and System test

scripts for Extensions, Data Conversion/Migrations, Inbound/Outbound interfaces, SOA

interfaces, Oracle Reports, Workflows, Informatica and OBIEE.

Expertise in System Administrator activities like managing concurrent managers, application user

setup, defining responsibilities, value sets, flex fields, registering menus, forms, reports,

concurrent programs, profile options as per the requirement.

Worked on creating SQL*Loader control programs and PL/SQL validation scripts.

Experience in developing UNIX Shell scripts for loading data into staging tables.

Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL

Trace etc.

Experienced in implementation of Oracle R12 Ledger setups, Sub Ledger Accounting (SLA),

AP Payment formatters and localizations.

Time and resource estimation of assigned work items, Coordinating and leading work items

among offshore resources.

Experience in Agile methodology

Experience

Accenture Services (pvt) Ltd from October 2005 to till date

Skills

Operating Systems UNIX, Windows XP and Windows NT

Languages SQL, PL/SQL, XML, Java, Unix shell scripting

ERP Oracle E-Business Suite (EBS) 11.0.3, 11.5.10.2, 12.0.4,

12.1.1, 12.1.2, 12.1.3 (AP, GL, AR, CE, iExpense,

iProcurement, FA, PA, PO, HRMS, OLM, iSupplier, INV,

CM)

Developer Tools Jdeveloper, XML Publisher, OBIEE, Informatica, SQL *

Loader, Data loader, SQL * Plus, Toad 11.5.x, Forms

6i/10g, Reports 6i/9i/10g, tkprof, Workflow builder, Oracle

Discoverer, Desktop Integration

Framework Oracle Application Framework (OAF)

Database Oracle 8i/9i/10g/11g r2

Project Mgmt & Quality Express One, Accenture ADM, Quality Center, PVCS,

Methods Harvest, Prism, IT Unified Process, SVN.

Certification \ Awards

Certified in Oracle 11i E-business suite essentials for implementers

Received ACE award (Accenture Celebrates Excellence) in Outperformer category.

Certified in Pathways to Leadership program by Accenture

Education

Post Graduate in Computer Applications

(G.R.Damodaran College of Science, Bharathiar University, India) 2002-2005

Graduate in Computer Science

(AWH College of science, Calicut University, India) 1999-2002

Project Experience

Company : Accenture Services (pvt) Ltd.

Client : Best Buy Canada

Project : Market Place

EBS version : 12.1.3

Modules : GL, AP, AR

Role : Oracle Financial Technical Consultant, Team Lead

Duration : May 2015 Till date

Best Buy, is a specialty retailer of consumer electronics in the Canada. Worked in the onshore

development team on GL, AP and AR modules. Responsibilities include preparation of functional and

technical specifications based on requirement gathered from business team. Responsible for all the

deliverables pertaining to design, build and test for all the assignments.

Tasks Accomplished:

Participated in business analysis to gather and evaluate client requirements and translated these

requirements to specific design documents.

Designed and developed interface to automate data feed from OFIN to Cognos TM1 via

INFORMATICA as part of Cognos upgrade project

Upgraded VFTS (Vendor Funding Tracking System) from Oracle forms 9i to 11g to fix issues in

e-email functionality

Designed interface to import marketplace invoices from CSPARC to Oracle (AP & GL)

Remediated service accounts(Oracle product accounts) for SOX project using FNDCPASS and

ALLORACLE

Company : Accenture Services (pvt) Ltd.

Client : AT&T

Project : R12 Upgrade, FA Enhancements, Bell South Merger, Mobility Merger

EBS version : 11.5.10.2, 12.1.1, 12.1.2

Modules : AP, GL, CE, FA, iSupplier, iExpenses, iProcurement, PA

Role : Oracle Financial Technical Consultant, Team Lead

Duration : Nov 2009 Apr 2015

AT&T is the largest telecommunications company in the US. It provides telecommunications services and

products domestically and internationally. These products and services include local exchange, wireless

communications, long distance, data/broadband and internet, telecommunications equipment, managed

networking, and directory advertising and publishing.

Project: International Consolidation and R-12 Upgrade

Tasks Accomplished:

Designed and developed punchout setups from iProcurement to supplier site.

Implementation of R12 payment formatters for 16 countries.

Extended the oracle client extension IBY package.

Did functional setups such as Payment process profile and payment process request template.

Customized ATT Custom employee form.

Creation of a document, layout and mapping for journal using R12 GL Web ADI.

Modification of existing 11i AP Reports to be compatible with R12 AP.

Developed GL outbound interface to handle record layout problems with international characters

as source system had UTF8-encoded data.

Using Data loader loaded the GL segment values through front end.

Project: FA Enhancements

Tasks Accomplished:

Designed and developed an inbound interface that loads the cost adjustment data file from

mobility oracle FA to CFAS. Created a unix driver program that sql loads and validates the data.

Project : AT&T & Mobility Merger

Tasks Accomplished:

Worked with the business to design PA Mega entry form.

Designed and developed

Outbound interface that sends a file with AP invoice details to other oracle systems.

Inbound interface to load the GL daily rates from the treasury system into the ATT system.

Inbound interface that updates data into credit card tables using bfile processing.

Modified pa conversion programs (sql, pl/sql, unix shell) to extract, translate/validate and convert

projects, key members, tasks, classifications, budgets and expenditures for expense and capital

data for Mobility.

Developed a new bank statement processing for files coming from citi and deutsche using SWIFT

940 format.

Company : Accenture Services (pvt) Ltd.

Client : US Steel

Project : CAE

EBS version : 12.1.1

Modules : SCM, CM, Projects

Role : Oracle Technical Analyst/ Senior EBS Developer

Duration : Nov 2007 Oct 2009

US Steel, is the largest fully integrated steel producer in the United States. United States Steel

Corporation (USS) is implementing an ERP system, Oracle eBusiness Suite, to streamline production and

business operations in the areas of Manufacturing, Accounting, and Human Resources, Procurement and

Order to Cash.

Tasks Accomplished:

Interacted with clients for gathering requirements and seeking clarifications.

Design Technical Design Documents.

Design, development and testing of complex SCM Interface, PL/SQL Extensions, XML

publisher reports, oracle Forms and reports 10g.

Worked on personalization of Oracle forms 10g

Worked extensively on XML publisher reports

Generating LDT's and involved in migration process.

Analyzing the defect, estimate the hours and fixing the issues.

Experience in Tuning SQL statements to improve execution performance using TKPROF,

SQL Trace etc.

Company : Accenture Services (pvt) Ltd.

Client : Best Buy US

Project : Payroll project

EBS version : 11i

Modules : HRMS

Role : Oracle Technical Analyst/ EBS Developer

Duration : Nov 2006 Oct 2007

Best Buy, is a specialty retailer of consumer electronics in the United States. Worked in the offshore

development team for Interfaces. Responsibilities include preparation of technical specifications from the

functional specifications received from the Client team. Responsible for all the deliverables pertaining to

design, build and test for all the assignments.

Tasks Accomplished:

Designed and developed event and periodic alerts on OLM module to send the

notifications to delegates and managers about the upcoming training details.

Fixed defects arising out of Product Testing.

Development of outbound interface to find the expense elements that were paid in the

Payroll Run, and update the Interface Staging table with the correct check date, payment

amount, and status and recycle count information.

Development of inbound interface for Oracle A/P and Payroll

Performed Assembly and Integration testing

Creation of installation and migration documents

Company : Accenture Services (pvt) Ltd.

Client : CARILLION

Project : Financial and HRMS implementation project

EBS version : 11i

Modules : GL,PO,AP,OLM,HRMS

Role : EBS Developer

Duration : Oct 2005 - Oct 2006

Carillion plc is a British-based construction-services business. I worked in the offshore development team

for Conversions, Interfaces. Responsibilities include development of Conversion, Interface programs and

Alerts.

Tasks Accomplished:

PO Receipts conversion - This task is to import legacy Return Materials into Oracle Applications.

Wrote a custom program to transfer data from flat file to custom staging table, then transferred to

interface table after validations and successfully loaded data into base tables.

Inbound interface (IPO-09) to import requisition transactions to Oracle Applications. Used SQL

Loader to load the Requisition data into temporary table and developed a Concurrent Program

(Custom PL/SQL Program) to validate the requisition data and put into Oracle Purchasing.

Developed outbound and inbound interfaces based on the design provided for oracle financial

modules.

REFERENCES ARE AVAILABLE UPON REQUEST

Contact this candidate