Oracle ERP Techno-Functional Specialist

PROFESSIONAL SUMMARY

. * years of experience in Oracle ERP, currently playing the role of

Module Lead at client location (US).

. Work includes Techno-Functional consulting in, design and development

of customizations and extensions, testing, documentation and training

for Implementation and Support projects

. Expertise in Oracle ERP Financials (11i and R12), Oracle Discoverer,

Oracle Developer Suite (Forms and Reports) technologies, SQL and

PL/SQL

. Excellent knowledge of core architecture of Oracle Applications

(Application Object Library) and related technologies.

. Experience in developing new interfaces into Oracle Financials across

modules, guiding business with Accounting and Journals setup, other

custom setups, using techniques of SQL Loader and APIs to get data

into Oracle.

. Have worked on development of concurrent programs, Oracle Forms and

Reports, XML Publisher reports, Oracle Workflow to automate processes;

used Values Sets, Descriptive FlexFields, profile options to enhance

flexibility of programs;

. Developed Oracle Discoverer (10g and 11g) reports and guided users

with usage of these reports and converting requirements to solutions.

. Work on month-end Close Processes with businesses.

. Driven and worked on the requirements of Balance Sheet submissions

(GL), Delivery Receipts, Invoice Prints, Check Prints (AP, AR and OM),

Depreciation Reports and Layered Accounting (FA)

. Extensive experience in writing queries, stored procedures, functions,

packages & triggers using SQL/ PLSQL for customization and new

solutions.

. Fixed performance related issue by use on techniques such as Dynamic

SQLs, index, Optimizer Hints, and redesigning the logics of cursors

and loops.

. Hand-on experience on data warehousing tools like Oracle Warehouse

Builder and concepts of ETL

. Experience in Onsite-Offshore model. Have worked both from offshore as

well as onsite. Currently playing the role of Module Lead handling

businesses across 3 different instances from onsite (US).

. OPN Certified Professional in Oracle General Ledger and Account

Receivable Essentials

. Six Sigma Green Belt

. Highly process oriented and quality conscious; worked on CMMI

compliant project

. Conducted technical training on Oracle Developer Suite

. Have additionally performed other roles like Configuration Controller,

PQA, Compliance and Security Auditor, Shift Planner, Employee

Engagement SPOC beyond regular project roles

. Excellent communication and presentation skills (worked as a TV

Channel English News Presenter during college days)

. Quick learner of any new subject.

EDUCATION

Degree University/Board

Master of Science (Software Annamalai University (India)

Engineering)

Bachelor of Science (Computer University of Madras (India)

Science)

XII (Higher Secondary) Tamil Nadu State Board (India)

X (Matriculation) Tamil Nadu State Board (India)

EXPERIENCE

Organization Role Duration

HCL Technologies Technical Consultant Dec '06 - Mar '11

Ltd.

Tata Consultancy I.T Analyst Apr '11 - Till date

Services

TECHNICAL SKILLS

ERP Oracle Application - Financial (11i and R12)

Databases Oracle 9i, Oracle 10g

Programming SQL, PL/SQL, UNIX Shell Script, XML

Languages

Development Tools Oracle Discoverer, Oracle Forms & Reports 6i/10g,

Oracle Workflow, Oracle Warehouse Builder, OBIEE,

XML Publisher, JDeveloper

Utilities StarTeam, PVCS (Version Control tools),

Open Pursuit, Remedy, Clarify (Ticketing tools),

AllFusion Harvest (Migration tool), WinSCP

Operating Systems Windows, UNIX

Process and Object Oriented Programming, RDBMS, CMMI, ETL,

Concepts Configuration Management, Project Quality Analyst

TRAININGS ATTENDED

Technical Process Related

11i10 Applications Developer - PQA (Process Quality

Oracle Implementation Champion Analyst)

Certificate

Oracle Applications Framework (OAF) Configuration Management

Overview - Application Development PVCS (Polytron Version

Framework (ADF) Control System)

R12 Readiness Programmes for Oracle CMMI Process and Role

Financials based training

Oracle Developer Suite (Forms and

Reports 6i)

Oracle Applications R12 - Boot Camp

TRAININGS CONDUCTED

Topic Duration Audience

Oracle Developer 6 days (April Associate Consultants

Suite 2010)

EXTERNAL CERTIFICATION

Course Institute

J2EE Technologies NIIT- Chennai

(Java, JDBC, JavaBeans, Servlet, JSP

Applications, EJB)

Oracle Partner Network : Oracle EBS R12.1 Oracle

General Ledger Essentials

Oracle Partner Network : Oracle EBS R12.1 Oracle

Receivables Essentials

PROJECT EXPERIENCE

Project # 1

Client: GE Capital

Project: Global Oracle Application

Duration: Apr 2011 - Till Date (2 years 10 months)

Team Size: 40

Description

GE Capital is a worldwide provider of leases, direct loans and a wide

variety of financial and equipment management services, headquartered

in Norwalk, Connecticut, USA.

Oracle Applications Global Support is a project with the Technical Support

and Enhancements/ Upgrade of Oracle Financial Applications (11i and R12),

Unix, SQL - PLSQL, across multiple businesses spread over four production

instances. The project is on a 24X7 support with team from across the globe

(Japan, Australia, UK, India, US).

Role and Key Highlight

Onsite (Apr 2013 - till date): 11 months

. One of the Module Leads at onsite (Techno-functional role)

. Business interaction - Work with Controllership, Super Users and Users

to understand business needs and transforming them to solutions with

technical expertise

. Designing new interfaces - Interacting with legacy system owners and

designing solutions for various inbound or outbound interfaces into

Oracle Applications system; highlight being leading the interface from

Travel & Living Expenses into GL and Corporate Freight expense into

GL.

. Production Support and Enhancements - Handling everyday technical

issues across modules like General Ledger, Fixed Assets, Account

Receivables, and Oracle Discoverer

. Month-end close process - Support the business for month-end

activities and issues of close.

. Worked on transition from Oracle Apps 11i to R12. Assisted users with

UAT and support during the R12 upgrade

. Application Maintenance - Performance, Oracle Apps System

Administrative activities, outage management, support tech refreshes,

plan migration of instances between servers

. Change management and Incident Management (Production issues,

Requests, Problems)

. Leading Project Initiatives across instances - Disaster Recover

Testing, ILM (Life Cycle Management of historical data), various audit

related activities

. Value additions - Process Improvement and code optimizations.

. Ensuring compliance as per S-Ox and other guidelines across the team.

. Reporting to client management on project updates

. Team Management - mentoring, supervising, guiding, and taking

ownership of the team

. Knowledge Sharing - Conducting sessions for the entire team spread

across locations on technical or functional topics

Offshore (Apr 2011 - Mar 2013): 2 years

. Production Support for Oracle Applications and other supporting

technologies, interfaces, solving issues in modules of Account

Receivables, General Ledger, Fixed Assets

. Customizations and Enhancements on Oracle Applications' work products,

Oracle Discoverer, interfaces through the SDLC life cycle,

documentation of technical designs, testing, migration.

. Onboarding of new-joinees and responsibility of knowledge sharing

sessions

. Shift Planning and coordination for the 40 member team across

locations

. Being the Compliance and Security Lead at account level, conducted

various I.T. audits and training across the 110 member account (group

of multiple projects for the customer).

Project # 2

Client: Union Bank of India (Onsite)

Project: Oracle Financial Services Analytical Application (implementation)

Duration: Aug 2010 - Mar 2011 (8 months)

Team Size: 12

Description

Union Bank of India is one of the largest state-owned banks in India.

This project was an OFSAA implementation for MFTP (Matched Fund Transfer

Pricing), ALM (Asset Liability Management), and Profitability module for

India operations at UBI.

Technologies and tools used - OFSAA (analytics), OWB (ETL), OBIEE (for

reporting), SQL and PLSQL (for customizations)

Role and Key Highlight

. Carried out the requirement gathering during the initial phase of this

project along with the domain experts and the functional team. And

this involved mapping of data required by OFSAA and identifying its

equivalent at the various source systems of the bank.

. Involved in designing and documenting strategies and logics for

Extraction, Transformation and Loading data from the source to the

target (OFSAA) database

. Developed an end-to-end POC for a product line (from ETL to reporting

using OBIEE)

. Worked on the core development of ETL of data using OWB.

Project # 3

Client: Elsevier Ltd

Project: Oracle EBusiness Development and Support

Duration: Jun 2008 - May 2010 (24 months)

Team Size: 15

Description

Elsevier is the world's largest publisher of medical and scientific

literature. Based in Amsterdam, the company has substantial operations in

the United Kingdom, USA and elsewhere.

This project was for the Corporate Business Systems (CBS) division of

Elsevier for the package application support and maintenance of Oracle

Financials version 11.5.10 and the interfaces.

For Oracle Financials - Technical support and enhancements using PL/SQL,

SQL, Oracle Reports, XML Publisher, Oracle Forms, Oracle Workflow

Role and Key Highlights

. Carried out developments through the life cycle beginning from

Requirements Analysis, preparing the Technical Designs (MD70),

Migration Documents (MD120), performing extensive Unit Testing and

Peer Review on the work products

. Enhancements and customizations and solving technical issues of

modules like AP, AR, GL, IEX, OM and PO on work products like Oracle

Reports, XML Publisher, Workflow, PL/SQL package, shell script.

. Worked exclusively on India Localization to develop cheque printing

report, taking part in requirements gathering with the user, creating

functional test cases and providing alternatives wherever possible

. Supported the various inbound interfaces by way of fixing of bugs,

troubleshooting production failures, daily monitoring for modules of

Accounts Payables, Accounts Receivables, General Ledger, CRM, and

Purchasing.

. All deliverables by adhered to norms, on-time every-time, zero defect

delivery in addition to providing additional and/or alternate

solutions

. Supported the Project Manager in organizing CMMI Level 3 compliance

across the team on various Process Areas. Ideated and worked on

process improvements solutions

Project #4

Client: HBOS (Halifax Bank of Scotland)

Project: Oracle Financials Implementation

Duration: Jul 2007 - Apr 2008 (10 months)

Team Size: 30

Description

HBOS plc is one of the largest banking and insurance group in the United

Kingdom. This project is for the Cash Flow Finance (CFF) division of HBOS

to implement Oracle Financials version 11.5.10 to replace their existing

PeopleSoft system. For Oracle Financials Implementation, development work

involved design and build using PL/SQL, SQL, Oracle Forms, and Oracle

Workflow

Role and Key Highlights

. Contributed to Design and Development of the custom bolt-on

application (Cash Flow Finance module) which captures cash flow

finance of the bank and transfers the details to General Ledger of E-

Business Suite.

. Worked on Technical Design (MD70), development and preparation of Unit

Test Cases for custom Forms of Manual Charges & Refunds process,

Credit Protection Process and Reserves Process highlight being Product

Configuration Set Up.

. Database design process involved definition and creation of scripts

for tables, view, index, sequence etc.

. Worked on custom Workflows highlight being Refunds (multiple) Approval

Notification workflow

. Besides a Technical Consultant, also performed the role of a

Configuration Controller for the Configuration Management activities

in the project

.

Project # 5

Client: EMC2

Project: Oracle Support and Maintenance

Duration: Jan 2007 - May 2007 (5 months)

Team Size: 3 members

Description

EMC Corporation is a U.S. Fortune 500 and S&P 500 provider of information

infrastructure systems, software and services. HCL had been rendering

support for Oracle Applications, data warehouse databases and

administration of other tools.

Role and Key Highlights

. This was a high responsibility role involving migrations of Oracle

database objects to the test and production data warehousing

environments (12 databases).

. Resolve and troubleshoot technical issues faced by team and customer.

. Also involved in customization of Oracle Apps Reports.

. Co-ordinated the cross-training programme with the client counter-part

and single-handedly executed the Knowledge Transfer activity for

client

OTHER ACTIVITIES

Employee Engagement - Leading the Fun@Work initiative at account level

(group of multiple projects for customer - 110 members), conducted and

participated in various employee engagement activities for colleagues.

Event Management: Organising and conducting many large scale employee

engagement events for the business unit at HCL.

News Presenter: Part-time English News Presenter during college for a

leading channel (Jaya TV)

Cultural Secretary at College: Cultural Secretary college during the

academic year 2004-2005 during which I was involved in organizing a lot of

symposiums and cultural events for the college.

School Pupil Leader: Girls' School Pupil Leader during the academic year

2001-2002.

ACCOMPLISHMENTS

Pride of the Month: For the support and outstanding contribution to team,

Pride of the Month was awarded in TCS.

Star Performer of the Month: Star Performer of the Month in Nov '07 for my

contributions and presentations in the knowledge sharing sessions across

practice.

O2 Award: For the consistency in annual appraisal reviews. was coveted with

the O2 Award (Double Outstanding).

Best Outgoing Student Award (College): recipient of this award for the

period 2003-2006 at both College and Department level.

Best All Rounder (School: recipient of this award in school for overall

performance in the year 2001-2002

Best Orator: Recipient of "Best Orator in School" award for the academic

year 2001-02

[pic]

AKSHITA JAIN

+1-203-***-**** (M) ? ***********@*****.***

[pic]

Contact this candidate