Page * of *

SUBHASHREE SAHOO

Phone : +91-84-310-*****

Email: adb22h@r.postjobfree.com

Professional Experience:

1. I have 7.5 years of programming experience as an ORACLE PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System

2. Knowledgeable Oracle Developer Skilled in Data Collection, Analysis and Management. Works well under pressure and consistently meets deadlines and targets while delivering high quality work

3. Highly Skilled software development professional bringing more than 6.5 years in software Design, Development and Integration. Advanced knowledge of Oracle SQL, PL/SQL

4. Involved in all phases of SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

5. Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical Functions, Materialized Views, Query Rewrite and Transportable table spaces

6. Experience in Data Warehouse concepts ETL

7. Created Tables, Views, Constraints, Indexes

8. Developed complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL

9. Experience in Oracle supplied packages, Dynamic Sql, Records and PL/SQL Tables. Loaded Data into Oracle Tables using SSIS.

10. Partitions large tables using Range partition technique. Experience with Oracle supplied Packages such as DBMS_SQL,DBMS_JOBS,UTL_FILE 11. Worked extensively on Ref Cursor, External Tables and Collections 12. Expertise in Dynamic Sql, Collections and Exception Handling. 13. Experience in SQL Performance Tuning using Cost Based Optimization 14. Good knowledge of key oracle performance related features such as Query Optimizer, Execution Plans and Indexes. Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

15. Proficient in understanding Business Requirement and Technical requirements 16. Analysis of client requirements and design document preparation 17. Hands-on experience with SQL, PL/SQL, web service, pentaho and Oracle Forms. 18. Experience in Coding and Unit Testing.

19. Experience in System Test Plan and Test Cases preparation, test execution and test support

20. Experience in working effectively within a team as well as individual contributor 21. Knowledge on UNIX Shell Scripting

22. Knowledge on SQL SERVER,SSIS

23. Basic knowledge of BDF Composer

24. Basic knowledge of Scala

Page 2 of 9

Technical Skills:

Front end : Forms and reports development using (10G, 11G) Tools. Back end : SQL developer, TOAD, Netezza

Languages : Oracle 9i, 10g, 11g,12c, forms, web services, ETL(pentaho). Scripting :UNIX

Educational Qualification:

B.Tech in Computer Science from KISD under BPUT Orissa with 70% Work Experience:

Currently working as Lead Developer at PWC SDC,Bangalore from August-2018 to till now

Previously worked as Sr Developer, IMS Health (IQVIA), Bangalore from January-17 to May-2018

Previously worked as Software engineer at Alshaya India, Bangalore from September- 14 to December 2016

Previously worked as Software Engineer at L&T INFOTECH, Bangalore from June-12 to September 2014.

Project Description:

Project Name : South Jersey Industries

Technologies : Oracle 12c,Maximo, SQL SERVER, SSIS Scripting : Maximo

Tools : SQL Developer, TOAD, JIRA,CORE FTP,TFS(Code checkin),SQL SERVER(Job scheduling), SSIS

Responsibilities:

Working on data conversion for SJI which involves data analysis, data mapping and data sanitation.

Involved in preparing pre validation scripts in order to ensure data quality is being maintained.

Handled end to end conversion task and prepared scripts for various critical loads.

Improved load performance by developing the PLSQL procedures and packages.

Wrote conversion scripts using SQL PLSQL, Stored Procedures, Functions and Packages to migrate data from Sql Server Database to Oracle Database

Involved in the requirement study, design and development.

Preparation of Technical Specification documents.

Created procedures, functions, packages, triggers and cursors Page 3 of 9

Customized Jobs on SSIS tool for conversion of data for fitment in target environment ( from sql server to oracle server)

Working on SSIS tool to create job to build high performance data integration solution including extraction, transformation from different sources to oracle server.

Working closely with clients to establish problem specifications and system designs

Wrote packages to fetch complex data from different sources(database server tables, excel files, flat files) in remote database using joins, subqueries and database links Project Name : Product Request System

Technologies : Oracle 12c,Netezza

Scripting : UNIX

Tools : SQL Developer, TOAD, JIRA,CORE FTP,SFTP, Harvest(Code checkin),cybermation(Job scheduling)

Project Description:

The IMS Product Request System (PRS) is used to enter and maintain data extraction orders for various data production deliverables.

When a User enters PRS they are in the Home module. At this point a User typically wants to add a new Request or view an existing Request.

Add a New Request - To add a new Request, click the “New Request” menu item in the Primary Navigation section of the page. A new browser window will be launched with the Request subsystem and will be defaulted to the Main Module in new mode. Edit an Existing Request - To edit an existing Request, click the “Search” menu item in the Primary Navigation section of the page.

A new browser window will be launched with the Request subsystem and will be defaulted to the Main Module in view mode.

From the Request Subsystem browser, the “Next” button will navigate the User to each module as indicated in the following Module flow diagram.

User can also navigate to any of the modules by clicking any of the Request Navigation links from the Left Navigation section.

Responsibilities:

Involved in the requirement study, design and development.

Preparation of Technical Specification documents.

Created procedures, functions, packages, triggers and cursors

Developed Advance PLSQL packages,procedures,Triggers,functions,Indexes and Collections to Implement business logic

Worked on UNIX Shell Script for generating xml report file for client

Providing support, Handling tickets and bug fixing Page 4 of 9

Involved in performance tuning to improve the performance of the query

Involved in preparation of unit test cases.

Involved in debugging of PL/SQL objects

Participate in client validation testing after a coordinated/cross application code push to production.

Responsible for executing and monitoring jobs according to established 24/7 schedule

Project Name : Query Builder Merge

Technologies : Oracle 12c,Netezza

Scriptig : UNIX

Tools : SQL Developer, TOAD, JIRA, CORE FTP,SFTP, GIT(Code check- in),cybermation(Job scheduling)

Responsibilities:

Involved in coding of procedures, functions, packages, triggers and cursors

Worked on metadata set up using metadata UI

Worked on UNIX Shell Script for Metadata import and export

Involved in preparation of unit test cases.

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Participate in client validation testing after a coordinated/cross application code push to production.

Responsible for executing and monitoring jobs according to established 24/7 schedule

Project Name : Ecommerce MAC Mena

Client Name : MAC USA, MAC UAE, M.H. Alshaya (Middle East North Africa) Third Party Vendor : Aramex

Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 4

Project Description:

This is a Ecommerce project for MAC Brand USA, MAC UAE and Middle East North Africa. New enhancements for Ecom MAC MENA for ship to store order, retail order and pay on delivery order in COMS where we are calling different web services through postman application for creating order, generating pick, payment settlement, dispatching order, delivering, cancelling order and returning. While dispatching, our system calls aramex web service for creating shipment, tracking shipment, generating awb number, and downloading URL for label to print on the top of the parcel for Aramex Integration. This Project involves different systems like-

Coms: Customer Order Management System- Facilities creation of customer orders and its execution. The system supports both retails and account customers and has got integration with ARESPOS (point of sale) as payment gateway. Auto integration with oracle Financials is available in case of account customer. Page 5 of 9

AIMS: ASN and Item Master System – Central repository for defining supplier, brand, country, cost center, costing matrix, item master, ASN and the like. MAGENTO: Magento is a feature-rich e-commerce platform solution that offers merchants complete flexibility and control over the functionality of their online channel. WMS: Ware house management system supports ASN (advance shipping notes), its receipts GRN (goods receiving notes), warehouse store transfers and inter country transfers. ARAMEX: Courier system. Aramex shipping API provides wide range of functionalities which enables our system and applications to integrate directly with aramex system Responsibilities:

Involved in preparing HLD, SRS, and guideline documents.

Involved in the requirement study, design and development.

Preparation of Technical Specification documents.

Providing support, Handling tickets and bug fixing.

Involved in coding using web service, migrating from oracle 10g to 11g, creating oracle wallets for installing certificates related to web service.

Involved in coding of procedures, functions, packages, triggers and cursors

Involved in preparation of unit test cases.

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project

Participate in code review and client validation testing after a coordinated/cross application code push to production.

Responsible for executing and monitoring jobs according to established 24/7 schedule

Project Name : Body shop Turkey

Client Name : Body shop, Turkey

Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 3

Project Description:

Body shop turkey is the project in COMS for creating order through xml format for body shop brand in turkey and send the order to DHL and magento. Here I am generating payment report, finance report for all order including cancelled order and return order and resending order files to DHL and magento in case of order files are not transferred to DHL & Magento due to network failure, we are generating error mail using Pentaho

Responsibilities:

Involved in preparing HLD, SRS, and guideline documents.

Involved in coding of procedures, functions, packages, triggers and cursors

Created package for resending files to magento and dhl, finance reports, payment reports

Created transformation in pentaho for file movements from magento to DHL and DHL to magento

Created transformations for sending automated mail for consolidating orders to DHL and magento

Involved in preparation of unit test cases.

Page 6 of 9

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project

Participate in code review and client validation testing after a coordinated/cross application code push to production.

Responsible for executing and monitoring jobs according to established 24/7 schedule

Project Name : MARS Integration

Client Name : MARS team, Russia

Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 3

Project Description:

MARS is Russian data warehouse system. This project perspective is to send ecommerce order related

(web store order) feeds from coms to mars system. Mainly this is a reporting purpose project to send 7 interface feeds to MARS system i.e. order, order status, order sales and return, ecommerce parcels feed, ecommerce sales service feed, ecommerce location mater feed, and ecommerce item master feed.

Responsibilities:

Involved in preparing HLD, SRS, and guideline documents.

Involved in the requirement study, design and development.

Preparation of Technical Specification documents.

Providing support, Handling tickets and bug fixing.

Created core package.

Involved in coding of procedures, functions, packages, triggers and cursors

Involved in preparation of unit test cases.

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project

Participate in code review and client validation testing after a coordinated/cross application code push to production.

Responsible for executing and monitoring jobs according to established 24/7 schedule

Project Name : Starbucks

Client Name : M.H Alshaya Kuwait

Vendor : starbucks

Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 4

Responsibilities:

Involved in preparing SRS, and guideline documents. Page 7 of 9

Created package for aims-coms master data interface synchronization.

Involved in coding of procedures, functions, packages, triggers and cursors

Involved in preparation of unit test cases.

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project Project Name : Carton receiving report to DWH

Client Name : M.H Alshaya Kuwait

Vendor : Next, H&M, Victoria Secret, American eagle, Mother Care Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 2

Project Description:

This is a project for generating carton receiving report to DWH. This is enhancement project of Transfer Management. This report contains all carton status and status changes feeds. Responsibilities:

Involved in coding of procedures, functions, packages, triggers and cursors

Involved in preparation of unit test cases.

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project Project Name : Transfer Management

Client Name : M.H Alshaya Kuwait

Vendor : Next, H&M, Victoria Secret, American eagle, Mother Care Technologies : Oracle 11g, 10g, SQL, PL/SQL, web services, Forms, reports Platform : Windows 2000/XP.

Team Size : 4

Project Description:

Transfer Management is a new project which tracks and provides visibility for transfers between intercompany locations, inter country locations, local ware house to local stores and local store to local store. This involves TM System which controls AP feed, In-transit adjustment feed Responsibilities:

Involved in preparing SRS, and guideline documents.

Involved in coding of procedures, functions, packages, triggers and cursors

Created core package to call web service while carton is scanned at GFM scanner and marked the carton to different status like Received, misdirected, missing, carton lost at source etc.

Created package to send mail notification in case of carton is missing or lost to the respective stores.

Involved in preparation of unit test cases.

Involved in preparation of Test Plan, Test Case and Test logs Page 8 of 9

Involved in debugging of PL/SQL objects

Involved in code review and peer review across our team

Involved in Query optimization to improve the performance of the query

Involved in preparing rollout kit for the project Project Name : Electronic Banking Application (EBA) Enhancements Technologies : Oracle 11g, SQL, PL/SQL

Platform : Window 9x/2000/NT

Team Size : 13

Project Description:

The EBA is a secured electronic banking application for Bank of Athens customers in Cape Town. It provides the user with all normal banking functionalities including Automatic Payments, Account Deposit Information System, Credit card Transaction, Account reconciliation etc. The objective of the project is to work on minor to medium scale enhancement projects on this application.

Responsibilities:

Involved in coding, unit testing of procedures, functions, packages, triggers and cursors

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging of PL/SQL objects

Project Title : Customer Information Management (CIM) Team Size : 11

Platform : Unix/Window 9x/2000/NT

Technologies : Oracle, SQL, PL SQL

Project Description:

This system helps us to capturing customer information, maintaining account information, and provides customer service. This system gathering all the information about customers account like saving, fixed, recurring deposits etc.This system have various types of facility like customer to deposit and withdraw money from his account and giving loans to the customer. The objective of the project is to work on enhancements and user requests on this application.

Responsibilities:

Involved in coding, unit testing of procedures, functions, packages, triggers and cursors

Involved in preparation of Test Plan, Test Case and Test logs

Involved in debugging PL/SQL objects

Involved in code review and peer review across our team Personal Detail:

Marital status: Single

Language : English, Hindi, Oriya

Hobbies : Listening music, decorating Home, reading novels Declaration:

I here by declare that the information furnished above is true to the best of my knowledge.

Page 9 of 9

Bangalore (Subhashree Sahoo)

Date:

Contact this candidate