Sql Oracle

Tejaswini Pardeshi

* **** ******,

Malden, MA - *2148

E-Mail: **********@*****.***

SUMMARY

. 6 years of Technical experience in Analysis, Design, Data Modeling,

Development and Implementation of Client/Server based Business

Applications.

. Experience with providing cost effective solutions using Oracle ERP

and related technologies. Experience spans across Implementations,

Data Conversions, Customization and Testing of Reports and Forms in

Oracle Financials.

. Strong skills in Oracle 9i/8i, SQL, PL/SQL, SQL*Loader.

. Experience in testing developed code for unit as well as integrated

levels.

. Experience in ETL using XML, shell scripts, SQL*Loader scripts.

. Can work effectively as part of a team or in an independent

environment.

. Excellent problem-solving and trouble-shooting capabilities.

. Excellent interpersonal, communication and presentation skills.

SKILLS

ERP: Oracle Financials of versions 11i

(11.5.10/11.5.9)

(AP, AR, GL, OM, PO, Install-Base, iStore, iMeter, AOL, Sys

Admin)

Databases: Oracle 9i/8i, MS Access, Sybase 11.0.2, SQL

Server 2005

Oracle Tools: SQL*PLUS, SQL*Loader

GUI Tools: Developer 2000, Visual Basic 6.0/5.0, .NET

Languages: SQL, PL/SQL, C, D2K, and C with embedded SQL

Platform: HP-UNIX, Windows 98/NT, MS-DOS and Tandem

IDE: TOAD

EDUCATION

MS in Computer Science, Lamar University, Beaumont, Texas

Master of Computer Applications (MCA), SNDT Women's University, Mumbai,

India

Bachelors of Science (Mathematics), Mumbai University, India

EXPERIENCE

Symantec Corp, Cupertino, California Feb

07-Present

Financial Programmer Analyst

Description: Extensive Oracle PL/SQL coding according to various business

requirements in customization of Oracle ERP. Day to day working with

Revenue Accounting, Financial Planning and Analysis teams worldwide to

support their needs in revenue recognition process.

Responsibilities:

. Production support for all existing custom revenue recognition tools

created for revenue accounting users.

. Extensive oracle Pl/SQL development, testing and fine tuning.

. Use of GL, AP, PO, OM modules of Oracle E-Business Suit in day to day

development.

. Creating reports in Excel 2003/2007 according to user needs and

modifying existing reports using macros.

. Create upload templates using excel for getting validated data in the

web tools.

. Use VBA for creating complex Excel reports.

. Follow SOX practices during data processes, report developments.

. Modify and test existing web tools using .NET, JavaScript.

. Creating ad-hoc queries according to user needs.

. QA (Quality Assurance) for web tools developed for existing web tools.

. Creating technical design documents, test cases, QA documents.

. Well versed with business processes involved in revenue recognition.

. Participated in integration of data to main database after

acquisition.

. Hands on experience with SQL Server 2005 for writing queries for data

reconciliation while porting data from SQL Server to Oracle.

Environment:

Oracle Apps 11.5.10 (AR/GL/OM), PL/SQL, SQL*Plus, SQL*Loader, TOAD, UNIX,

SQL server 2005.

Premier IT Solutions, Dallas, Texas Jan

05 - Jan 07

Technical Consultant

Description: Conversion of data for Oracle Financials 11.5.10 from 11.03,

development and post-production support for various Oracle Applications 11i

versions.

Responsibilities:

. Conversion for customers, banks from 11.03 and legacy system to

11.5.10 for AR module.

. Conversion for AP invoices and invoice payments from 11.03 to Oracle

Apps for AP module.

. Data cleaning activities to make sure that valid data is converted.

. Development of PL/SQL package for auto registration of C-level

customers.

. Development of PL/SQL package for creation of service request (SR) for

customers and sales online.

. Involved in requirement gathering meetings with business.

. Worked in InstallBase, CRM module while developing PL/SQL procedures

as per business requirements.

. Creating MD-50 (for functional requirements), MD-70 (technical

details) and MD-40(test scripts) documents for all the requirements

gathered by business.

. Involved in developing on the fly queries as per business

requirements.

. Financial statements for GL module were to be created specific to

client requirements. Involved in generating consolidated statement of

net cost financial report.

. Involved in design documentation and test documentations for reports.

. Involved in preparing mapping documentation for invoices conversion

for AP module.

. Involved in creating value sets using data loader utility.

. Migrating value sets using FNDLOAD utility.

. Used cross-validation and value set features while implementing

descriptive flex fields to customize sales order entry form to capture

additional customer information.

. Customized several reports in AR to fit the complex need of the

customer.

. Used UNIX shell programming for tracking the information of Interfaces

into log files.

. Preparing test cases and test scripts for testing of the code

developed.

. Testing the code at unit and integrated levels.

Environment:

Oracle Apps 11.5.10 (AR/AP/GL/PO/OM), Oracle 10g, PL/SQL, SQL*Plus,

SQL*Loader, TOAD, UNIX

CMC Limited, Mumbai, INDIA

Jan 01 - Aug 02

Software Engineer

Description: CMC was responsible for developing web based application for

MSEB (Maharashtra State Electricity Board). The GUI was developed in Java

and the backend was in Sybase 11.0.2. BOLT is an online trading system

being used at the Stock Exchange, Mumbai (popularly known as BSE, [Bombay

Stock Exchange]). I was involved in the maintenance phase of the project.

Responsibilities:

. Involved in designing of database and migrating data from legacy

system to the main database.

. Extensively involved in writing t-sql stored procedures and

functions for different functionalities.

. Writing ad-hoc queries for client use and simple reporting

purposes.

. Involved in testing the application and launching it at the client

side.

. Involved in preparing the test cases depending on the requirements

and testing the application for those test cases.

. Involved in writing code in C with embedded SQL for press release

of indices from BSE.

. Involved in making changes in the code of match servers according

to the changes suggested by client.

. Extensively tested the changes made and transferred them on live

servers.

Environment: Java and Sybase 11.0.2 (T-SQL), Tandem Himalaya S-Series with

Guardian operating system and Non-stop SQL RDBMS server, Microsoft Visual

C++ 5.0

Contact this candidate