Sql Project

SAHANA SARKAR PAUL

******.****@*****.***

Phone: 858-***-****

SUMMARY

• 6.5 years of rich and varied experience in field of Oracle Apps(11i and R12) implementation and support

projects

• Worked on multiple implementation covering Requirement Analysis, Setups, Functional Specification for

Customizations, Testing, User Training and Post Implementation support

• Experience in Oracle EBS and its implementation like Up-gradation, Offshore support, Enhancements,

Integration, Problem Solving, Trouble Shooting and Training

• Good Techno Functional experience in INV(complete Inventory Setup and Planning), HRMS,

OM,Advanced Pricing, TCA(Trading Community Architecture),GL, AP, AR, PO(Setup and P2P flow) and FA

• Strong working knowledge of Oracle application Object Library (AOL) and System Administration

(SYSADMIN).

• Extensive working experience in developing PL/SQL Package, Data Modeling, Database Triggers, Forms

and Reports, Workflow Builder, XML Publisher/BI Publisher, Discoverer Reports, Performance Tuning and

Form Personalization and OAF Personalization.

• Experienced in developing batch programs by using PL/SQL and Unix shell scripts and in using Export,

Import and SQL*Loader Utilities for loading data from flat files into Oracle tables

• Tuned SQL queries using EXPLAIN PLAN, optimizer Hints and TKPROF utility, Indexes leading to

significant improvement in system response time and efficiency.

• Used bulk binding techniques like BULK-COLLECT and FORALL

• Worked in Query tuning, Oracle Scheduler, Profiler, Explain plan and TKPROF .

• Development experience of ETL processes using custom PL/SQL.

• Strong working knowledge of Microsoft Excel Database analysis tools, Data Validation, FTP utilities.

• Experienced in using the Ref-Cursors, PL/SQL Tables, Materialized Views, Table partitioning, Arrays,

Indexes and Dynamic SQL's.

• Working Experience in Oracle Job Scheduling and Monitoring and Oracle Alerts

• Knowledge of JAVA and OAF.

• Working experience of Unit Testing and UAT testing.

• Working knowledge of preparing BRD, FDD, UAT, Technical Design Document.

• Possess good analytical skills, Quick learner and is a great team player

• Knowledge of SDLC phases.

• Experience of leading team.

TECHNICAL SKILLS

Oracle Applications R11i, R12, Inventory (INV) setup, HRMS, Purchase Order (PO),

Application Technology

Order Management (OM –Order to Cash), SLA, Accounts Payable (AP),

Accounts Receivable (AR),General Ledger (GL), Procure to Pay (P2P),HRMS

Oracle 9i/10g

Database

Oracle Reports 6i, Oracle Forms 6i/10g

Reporting Tools

SQL, PL/SQL,JAVA, Unix Shell Scripting

Languages

TOAD, SQL * Plus, SQL * Loader, XML Publisher/BI Publisher, Discoverer, SVN,

Tools

Workflow builder

MS Word, Excel, Power Point, Visio

Office Tools

Microsoft Windows

Operating System

PROJECT SUMMARY

Client: Star point

Feb 2015 - Present

Role: Technology Analyst (Techno-Functional)

Location: San Jose, CA

Project: This Enhancement Project provides a common platform for financial accounting system that uses Oracle EBS

Financials R12.

Responsibilities:

• Extensively work experience on Oracle SQL, PL/SQL, SQL*Plus

• Form and OAF Personalization, Package creation and Performance Tuning

• Restructuring sql queries of views particularly where clauses and joins. Used explain plan, sql tracing and

tkprof to examine access path and other activity generated by sql. Gather tables stats and applied optimizer hints as

needed.

• Developing simple to complex sql queries based on users’ requirements. Utilizing Oracle’s Analytical

functions.

• Extensively used dynamic sql and utilized bulk collections and direct path load to speed up certain data load

process. Used Oracle specific feature such as ref cursor and analytic functions.

• Developed Custom report to display specific customer and customer account data using XML

Publisher 10g as per the client’s template.

• Developed simplified innovative solutions for complex business process to eliminate waste in resource

• Written PL/SQL Stored Procedures, Functions and Packages to implement business rules into the application

• Created Setup documentation for Inventory.

• Writing PL/SQL code for ETL process.

• HRMS(Employee, Jobs, Position) data Setup.

• Created Periodic Alert when invoice get stuck.

• AME Approval Setup for Invoice.

• Define Price list and Define Advance Price Modifier(Advanced Pricing) to issue coupon or discount

on particular item or category.

Client: BOEING

Sept 2012- July2013

Role: Technology Analyst (Techno-Functional)

Location: Bangalore India

Project: This Project provides a common platform for financial accounting system that uses Oracle EBS Financials R12.

Environment: Oracle Applications Release 12.1.3 (AP, GL, AR, FA), PL/SQL, TOAD and XML/BI Publisher

Responsibilities:

• Extensively work experience on Oracle SQL, PL/SQL, SQL*Plus

• Developed many complex FA XML Publisher Reports

• Developed a complex custom XML/BI Publisher report on Fixed Asset Depreciation and also performed Unit

testing and UAT testing, Data setup

• Customized a XML/BI Publisher Report to add company logo.

• Worked on Form Personalization, Package creation and Performance Tuning

• Form personalization on Invoice Form to disable DFF and in distribution window to mandate few DFF fields

based on some condition and to show proper restriction message for both general and PO matched screen, Unit

testing and data setup.

• Developed complex Pl/SQL packages on AP, AR module.

• Month end Activities on (AP,AR,GL)

• Worked on Procure-to-Pay (P2P) cycle for creation of requisitions, purchase orders and receipts. Created invoices

in AP and finally posted the Payments into GL.

• Responsible in creating new suppliers.

• Developed Interface program for Customer data Migration.

• Developed UNIX shell scripts to perform a nightly refresh of the test system from Production instance .

• Developed custom supplier conversion program for doing supplier conversion in r12 from flat file to staging

table and post validation staging table to interface tables. Also test the full flow of conversion and interface of supplier

data.

• Developed Sales by Customer Ship-To Location report that shows the sales information with corresponding

order number, invoice number, Item number, and PO and customer ship-to location

• Written PL/SQL Stored Procedures, Functions and Packages to implement business rules into the application

• Created Setup documentation for FA

• Develop a tool using Unix Shell scripts and Pl/Sql which will read the inventory set up data from data files and will

insert data to the staging tables and post Validation will insert into Inventory base table. The tool was accepted at project

level as well as organization level.

• Writing Unix Shell scripts for Inbound out bound programs.

• Involved in technical design, development and support for ‘Order to Cash’ and ‘Procure to Pay’ processes.

• Developed packages to validate and to load data from the staging table to interface tables related to Procure to Pay.

• Functional documentation for Configurations (Setups), User Training Documents and Customization Documents

• Engaged in Requirement gathering (BR-100), Solution Design (Process Documents), ‘UAT’

• Interaction with several other dependent teams for getting the data and the required info to get things going.

• Mentored my team as senior team member and took bottom up responsibility to build up a good repository for

knowledge documents and reusable documents which helped on timely delivery of the deliverables

• Customized OAF pages including Personalizations and Extensions.

• Extensively used dynamic sql and utilized bulk collections and direct path load to speed up certain data load process.

Used Oracle specific feature such as ref cursor and analytic functions

Client: MOTOROLA

Sept 2011- Sept 2012

Role: Technology Analyst(PL/SQL Developer)

Location: Bangalore, India.

Environment: Oracle Applications Release 12.1.3 (INV, OM, PO, AP), Forms 10g and TOAD

Responsibilities:

• Worked on AP Custom Form using Oracle Form 10g

• Set up Training on Forms.

• Worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)

• Performed system-admin activities like creation, maintenance or users, creating responsibilities, menu maintenance

and creation of requests.

• Worked on couple of performance tuning projects. Worked on query analysis, data gathering and analysis and work

towards the solution of the performance issue.

• Responsible for analysis and reviewing of design document, test case document.

• Migrated several forms and reports from 6i to 10g

• Created Periodic Alert when invoice get stuck.

• Experience with complete Order to Cash cycle (Quoting, Order Management, Inventory, Advanced Pricing, Shipping

Execution, Account Receivables, Account Payables and General Ledger) and Procure to pay cycle.

Client: SONY

March 2010-Sept 2011

Role: Technology Analyst (PL/SQL Developer)

Location: Bangalore, India

Project: GLOBAL ORCLE (Oracle Application Implementation)

Environment: Oracle Applications Release 11.5.10 SCM (PO, WIP, INV, BOM), Forms 6i, Repot 6i, PL/SQL, SQL * Loader and

TOAD

Responsibilities:

• Worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)

• Worked on different types of temp tables, Advanced pl/sql, Exception handling.

• Responsibilities also include providing production support for all issues – standard and custom

• Timely communication with the end-user to understand their issues and fix it as per severity

• Performed system-admin activities like creation, maintenance or users, creating responsibilities, menu

maintenance and creation of requests

• Interact with the on-site team for technical design and integration testing with detailed design documents and

unit test plan

• Worked on Job Scheduling and Monitoring, Creating Alerts, Performance Tuning, Form Personalization.

• Month end setup.

• Developed Order Close or Cancel report

• Developed Interface of Sales Orders Import in OM after actively participating in the preparation of

the conversion mapping documents.

• Developed a custom Form to Approve the Purchase Orders in Bulk. Also user can see all the related

reference document details on clicking the Detail button. We have used folder functionality.

• KIT setup for Sales Order transactions.

• Writing Unix Shell scripts to modify the CSV file data.

• Full ATO process setup and testing

• Developed custom reports as per requirement using Oracle Reports 6i

• Used SQL*Loader for loading the data into the staging table, developed PL/SQL packages to validate and

load into the interface tables

• Developed packages to validate and to load data from the staging table to interface tables Created setup

document for Inventory, WIP and BOM.

• Set up training on Form Personalization, Oracle Apps and Pl/SQL

• Responsible for analysis and reviewing of design document, test case document.

Client: SONY

March 2009-March 2010

Role: Senior System Engineer (PL/SQL Developer)

Project: FTV (This project provides Oracle Apps SCM Solution to Planning, Purchasing, Manufacturing, Forecasting

and Shipping solutions. This was a Support/Maintenance project.)

Environment: Oracle Applications Release 11.5.10.2 (INV and Customized modules), PL/SQL, SQL * Loader and TOAD

Responsibilities:

• Extensively worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)

• Worked on Inventory Setup

• Used SQL *Loader tool to transfer the data from Flat Files to the tables

• Responsibilities also include providing production support for all issues – standard and custom

• Took bottom up responsibility for offshore team.

• Developed Simplified innovative solutions for complex business process to eliminate waste in resources

• Extensively worked on Performance Tuning. As a team achieved 85% of performance improvement of existing

system.

• Extensively used dynamic sql and utilized bulk collections and direct path load to speed up certain data load process.

Used Oracle specific feature such as ref cursor and analytic functions

Client: SONY

Feb 2008-Mar 2009

Role: Software Engineer(PL/SQL Developer)

Project: ISemicon (provides robust solution for Planning, Purchasing, Manufacturing, and Forecasting, Sales, Shipping,

Logistic and Financial requirements of SONY)

Responsibilities:

• Extensively worked Developing Complex forms in WIP, WMS using Oracle Forms 6i.

• Worked on folder functionality in form.

• Developed Reports using Discoverer Tool

• Developed many Packages in BOM, WIP,PO and WMS

• Developed custom reports as per requirement using Oracle Reports 6i

• Extensively worked on Oracle SQL, PL/SQL, SQL*Plus (Package creation and Modification)

• Interact with the on-site team for technical design and integration testing with detailed design documents and unit

test plan

Infosys Fresher Training

Oct 2007-Jan 2008

CGPA: 4.9 out of 5

OTHER RESPONSIBILITY:

Mentoring team, arranging and taking training sessions, published BOKs (Book-of-knowledge) and tools to Infosys KM

(Knowledge Management) portal, also was KM anchor for SONY project

RECOGNITION:

• Always appreciated by the client and onsite counter parts

• Received 1+ in performance evaluation and token-of-appreciation from BOEING

EDUCATION

Bachelor of Technology in Computer Science (2007) International Institute of Technology, Kolkata, India

Contact this candidate