PL/SQL developer
Resume:
Profile Objective Summary
• Having *+ years of IT Experience with Retail and Finance domain.
• Roles during my career as Associate Project, Software Engineer and Lead Engineer.
• Specializes in coding ORACLE SQL, PL/SQL and UNIX Shell scripting.
• Proficient in PLSQL and creation and modification of database objects like Tables, Packages, Procedures, Functions, Triggers, views etc.
• Vast experience using PL/SQL collections, Ref cursors and Dynamic SQL.
• Experience in owning, complete lifecycle of database development
• Having knowledge of SQL performance tuning and optimization.
• Involved in fixing production issues.
• Experience in using TOAD, PL/SQL Developer and Oracle developer
• Excellent code debugging.
• Familiarity with Oracle Utilities SQL*Loader
• Exposure writing complex SQL Queries.
• Oracle certified SQL developer certificate on year 2010
Job History
Lead Engineer: December 2007 – January 2012 at HCL Technology (Client-IRI)
Associate Projects: September 2006 - December 2007 at Covansys India Pvt. Ltd (Client -PayPal an eBay company)
Technical Skill Summary
Primary Skill : SQL, PL/SQL and UNIX HP UX
Secondary Skill : Shell script
Operating Systems : Linux and windows XP
Tools : PL/SQL developer, TOAD, ClearCase, Remedy
Databases : Oracle 10g
Academic Education
MCA from Khallikote (Auto.) College, Berhampur University, Odisha on year 2005 with 82%.
B.Sc. (Physics Hon.) from Berhampur University, Odisha on year 2001 with 63%.
Intermediate (PCMB) from CHSE Odisha on year 1998 with 65%.
10th from BSE Odisha on year 1996 with 75%.
Project Engagement Overview
DESCRIPTION ABOUT CLIENT: IRI
Information Resources, Inc is established 1979. It’s headquarter is in Chicago, US. IRI collects the data by various means & uses the data to provide CPG manufacturers, brokers, retailers, and wholesalers with information and services critical to their sales and marketing.
In the World, IRI falls third in managing huge volume of data, following the Companies National Service Agency (first) and Wall mart (second) .The volume of data is in terms of Terabytes (TB)
IRI Competitors are AC Nielsen, Market facts, NFO World group.
IRI’s Clients are:P & G, Kraft, Coca Cola,Ralston,General Mills,Tropicana,Pepsi & Co, Philip Morris
Project #1:
Name : DATACOL
Client : IRI
Period : Feb 2011 to Dec 2011
Environment : Oracle 10g (PLSQL) and Vb.Net
Team Size : 2
Description:
The aim of DATACOL (Data collector) Application development is to help user to create and/or manage data collectors and to manage data collected by them.
Role/Responsibility:
• Interacted with client to understand the requirements.
• Developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Extensively used Ref cursor, PL/SQL Collection and dynamic sql.
• Handled file using UTL_FILE package.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace
• Prepared and setup of testing environment for QA team in the platform.
• Fixed database issues.
• Prepared root cause analysis for problems occurred.
• Documented all PL/SQL code and user guide for future reference.
• Sent the status report.
Project #2:
Name : PROTRANS
Client : IRI
Period : May 2010 to Dec 2010
Environnent : Oracle 10g (PLSQL) and Vb.Net
Team Size : 2
Description: The aim of PROTRANS (product Transcodification) Application development is to help user to keycat the product and to automate the Keycating process.
Since all the data will not come from stores, we may have to depend on external data source. One of the data source is A3 (Aqua). IRI takes form A3 which is a third party to manage all prospectus data. Since the data coming from A3 may not follow the same structure as followed in IRI Protrans can be used to map the incoming data. PROTRANS Application is to help user to keycat the product and to automate the Keycating process. This application will also help in the process of automating the A3 data management. This application can also used for other purpose as:
It is used to track all item (local items) for which not associated with any standard UPC.
It is used to track all bundled item.
It is be used to manages all the data coming from A3.
Role/Responsibility:
• Interact with client to understand the requirement.
• Developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Extensively used Ref cursor, PL/SQL Collection and dynamic sql.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace
• Prepared and setup of testing environment for QA team in the platform.
• Fixed database issues
• Documented all PL/SQL code and user guide for future reference.
• Sent the status report.
Project #3:
Name : Automated Feature Coding (AFC)
Client : IRI
Period : Dec 2009 to Feb 2010
Environment : Oracle, Pro*C, Shell Script
Team Size : 1
Role : Query rewrite and support
Description: AFC is one of the applications in IRI business which helps in determining the effect of an advertisement on a particular product .AFC helps IRI in providing business solutions and services to its end clients by giving them the analysis of causal data. Causal data deals with causes (features) and their respective effects (movement of items). AFC collects the causal data from newspapers, in-store mailers, displays, print media, etc… AFC is a client server application.
Role/Responsibility:
• Interact with client to understand the requirement.
• Developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Loaded the file into database using SQL LOADER.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace.
• Generated report using shell script.
• Prepared and setup of testing environment for QA team in the platform.
• Fixed database issues
• Documented all PL/SQL procedures and user guide.
• Sent the status report.
Project #4:
Name : RJRSOR
Client : IRI
Period : June 2009 to Sep 2009
Environment : Oracle and PL/SQL
Team Size : 1
Role : Coding and Unit Testing
Environment : Shell Script and PL/SQL
Description : This process identifies stores in Oracle DB for stores in the VC_CANDIDATE_STAGING . The store selection criteria from Oracle database handles the exclusion of audit stores, stores already assigned in the rjr_sample_master_table, stores reduced the RJ09 reduction files and stores waiting for approval in the potential_matches table. After our process has completed and identified potential new sample stores, we will put these stores into the potential_matches table. The user will be able to review the potential matches via the GUI.
Role/Responsibility:
• Interacted with client to understand the requirement.
• Developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Loaded the file into database using SQL LOADER.
• Written shell script to generate report and send it to user by email as attached. Previously that was written in SAS programming and submitted by user manually. I took challenge to learn SAS and to implement in PL/SQL.
• Prepared and setup of testing environment for QA team in the platform.
• Fixed database issues
• Documented all PL/SQL code and shell script for future reference.
• Sent the status report.
Project #5:
Name : Snapshot Automation Tool.
Client : IRI
Period : Mar 2009 to May 2009
Team Size : 1
Role : Coding and Unit Testing
Environment : Shell Script and PL/SQL
Description: There are three types of snapshot reports in PROJ. These snapshots are created by the user manually when needed. I have written PLSQL code to do auto report generation and ftp it to Main Frame.
Clean snapshot: Created monthly after clean processing is complete. Clean processing begins the 2nd or 3rd Thursday of each month. The snapshot is ftp’d to the MF as: PROJSYS.PM.CLEAN.<MMMYY>
Live snapshot (monthly): Monthly after the clean session is promoted to the live tables. The snapshot is ftp’d to the MF as: PROJSYS.PM.LIVE.<MMMYY>.PROD
Weekly Live snapshot: Created weekly after the completion of weekly Capstone load (i.e. Wednesday afternoon). The snapshot is ftp’d to the MF as: PROJSYS.PM.LIVE.W<xxxx>
Role/Responsibility:
• Interacted with client to understand the requirement.
• Developed database tables, triggers, cursors, procedures, functions and packages to meet business requirements.
• Loaded the file into database using SQL LOADER.
• Written shell script to generate report and send it to user by email as attached.
• Prepared and setup of testing environment for QA team in the platform.
• Fixed database issues
• Documented all PL/SQL code and shell script for future reference.
• Sent the status report.
Project#6:
Name : NA Outlier Identification
Client : IRI
Period : Dec 2008 to Feb 2009
Environment : Pro*C, UNIX
Team Size : 1
Role : Coding and Debugging
Description :
Description: To identify those stores deemed outliers from Philip Morris TRP Universe in an effort to bring stability to an extremely volatile segment.
Responsibility: I have written shell script and Pro*C code to implement the requirement.
Project #7:
Name : Unix Data Loading (UDL)
Client : IRI
Period : Jan 2008 to Nov 2008
Environment : C,SQL, Pro*C, Shell Script
Team Size : 3
Role : support
Description : UDL-Unix Data Loading is one of the prominent DMS applications developed by IRI for Quality Processing of Retailer’s data . The sub applications under UDL are.
Philip Morris –Cigarette data processing
AuditC – Processing of Audit data
RCG- Retailer’s Comm Gateway
RxPulse-Processing data related to medicines weekly once
Responsibility: I have involved in some PMR for change request and involved in solving tickets.
DESCRIPTION ABOUT CLIENT: PayPal
PayPal provides the safer, easier way to pay and get paid online services. The service allows anyone to pay in any way they prefer, including through credit cards, bank accounts, buyer credit or account balances, without sharing financial information. PayPal enables global ecommerce by making payments possible across different locations, currencies, and languages. Located in San Jose, California, PayPal was founded in 1998 and was acquired by eBay in 2002.
PROJECT DETAILS:
Project #1:
Name : Money Market Fund (MMF)
Organization : Covansys (PayPal an eBay company)
Period : Sep 2007 to Nov 2007
Environment : C++, Unix and Oracle
Team Size : 4
Role : Coding and Unit Testing
Description :
This feature is an umbrella for fixes around the User’s experience of accessing and storing their PayPal Money Market Fund (MMF) information. Currently the User Experience is inconsistent when compared to other Financial Products in terms of how the User’s information should be presented and made available for the user for reference. The user flow should be intuitive and provide ease of use, and should follow a standard, structured account management interface.
Project #2:
Name : Pinless Debit
Organization : Covansys (PayPal an eBay company)
Period : Apr 2007 to Aug 2007
Environment : C++, Unix and Oracle
Team Size : 5
Role : Coding and Unit Testing
Description :
In this project we are not required to enter pin number for the Debit card. If the user is a PayPal user then he must have a paypal account and password. By using this PayPal account he can use the debit card associated with that account with out using the pin number. In this case we are using different network for Debit card and Credit card.
Project #3:
Name : Smart Logo.
Organization : Covansys (PayPal an eBay company)
Period : Nov 2006 to Mar 2007
Environment : C++, Unix and Oracle
Team Size : 5
Role : Coding and Unit Testing
Description :
Smart Logo is a logo that is present in the eBay site in the items description part. It is help full to the buyer to make payment at the time of seeing the items description. There are two ways to insert logo in paypal site.
1) Manual Logo Insertion
2) Automatic Logo Insertion
In the case of Manual the seller can insert Smart Logo only on selected Items description. But in the case of Automatic, seller can insert Logo automatically by making Automatic Logo Insertion “on” in the PayPal site.
Personal Information
Contact Number : 979*******
Email : *********.********@*****.***
Date of Birth : May 07, 1981
Marital status : Married
Declaration
It is hereby declared that the above statements given herein are true to the best of my knowledge and belief.
Date: Nirupama Panigrahi
Place:
Contact this candidate