Oracle Data

APARNA KASTURI

314-***-**** A KASTURI ****@ GMAIL . COM

PROFESSIONAL SUMMARY

Result-oriented and motivated business analyst offers over four years experience in business

analysis, process design, full life cycle implementation including requirement gathering, design,

development, implementation, testing and user training.

CAREER SYNOPSIS

SR ORACLE TECHNO FUNCTIONAL CONSULTANT

NATIONAL EXPRESS CORPORATION, DOWNERS GROVE, IL Dec’08-Sep’09

Gathered business requirements, performed GAP analysis and developed Oracle HR application

to perform business transactions such as employee payroll execution and employee benefits

reporting.

Key Accomplishments

Prepared functional design and technical design documents for HR Payroll and Benefits

business processes

Developed an interface for loading garnishments and payroll taxes from third party

payroll system.

Extracted life events and employee benefits data from Oracle ERP tables and loaded data

to intermediate tables for outbound interfaces.

Developed reports for HR and Payroll business in Oracle HR module.

Developed open interfaces for data conversion and data validation using PL/SQL.

Created temp tables in Oracle to load the data and wrote control file for the transfer of the

data through Sql*Loader.

BUSINESS SYSTEMS ANALYST

METRO, ST LOUIS, MO Nov’07-Aug’08

Reviewed business process procedures and implemented systems to improve operational

efficiencies across multiple functional areas. Trained end users on business transactions and

reports.

Key Accomplishments

Gathered business requirements and developed Accounts Receivable reports that include

billing history report in Oracle ERP application.

Developed custom dunning letters for Metro. Created dunning letter format using oracle

forms.

Wrote SQL programs to run weekly extracts from payroll provider database and third

party benefits database.

Configured position hierarchy for the Metro organizational structure. Worked with the

payroll manager to prepare an Org chart for each individual department and loaded the

hierarchy into oracle application.

Provided training to business users in Oracle HRMS transactions and custom reports.

ORACLE TECHNO FUNCTIONAL CONSULTANT

CITY OF PHILADELPHIA, PHILADELPHIA, PA Mar’07-Nov’07

Developed interfaces and loaded payroll data and GL balances.

Gathered business requirements and developed custom reports in Oracle 10g for HR and

Payroll departments. Some of the Reports include Position management, Report of

Separation, Report of Appointment, Assignment status report.

Created Oracle Discoverer Business Areas and Custom Folders for AR, AP, OM and GL

modules.

BUSINESS SYSTEMS ANALYST

INDUS IT VALLEY INC, ST LOUIS, MO Nov’06- Feb’07

Developed back feed Payroll Interface that compares third party data file with Oracle

Payroll information and resolves differences to keep both systems in sync.

Prepared functional design and technical design documents for HR Payroll and Benefits

business processes.

Computed paid hours and wages per each work location using PL/SQL package.

BUSINESS SYSTEMS ANALYST

HI TECH COMPUTERS, INDIA Jan’03-July’04

Extracted data for business continuity and validated data with the business requirements.

Developed and implemented reports, interfaces, conversions and extracts (RICE Objects)

in Oracle Human Resource Module. Created several reports, such as reconciliation of

balances against the legacy balances. Worked on reports such as Tabular, Form, Group

Above, Group Left, and Matrix etc.

Involved in testing business processes and transition to production environment.

Developed PL/SQL inbound and outbound interface programs in Oracle HR, Payroll and

Standard Benefits modules.

EDUCATION

M.S. Electrical Engineering, George Mason University, Fairfax, VA

B.E. Electrical Engineering, Osmania University, Hyderabad, India

Contact this candidate