Pl SQL developer Resume

Pl SQL developer Resume

PUNEET KUMAR
Contact: 08130009625
E-Mail: kumar_puneet@outlook.com

OBJECTIVE:

 Overall 2.5 years of IT experience as Pl SQL developer. A highly versatile individual, hard working, motivated with a great interest in the Application development seeking challenging assignments with an organization of repute which enable me to use my skills towards achieving organization goals and objectives.

EXPERIENCE SUMMARY:

•Total 2 years and 5 monthsexperience in OracleSQL, PL/SQL, UNIX Production support and Development projects.
•Expertise in PL/SQL (Oracle 9i, Oracle 10g,Oracle 11g) programming like writingPackages,  store procedures, functions and Triggers in Oracle.
•Proficient knowledge in Data modeling and ER Diagram.
•Knowledge of DBMS & RDBMS concepts.
•Provided technical production applications support and assistance to customers.
•Having excellent domain knowledge of Retail banking like (Loan processing, Term deposit, Savings Acct, Various Reports), Treasury functions.
•2 years 5 months working experience in the client places (Orissa State Cooperative Bank,CAG(Accountant General,Assam)and West Bengal Finance Department).
•Monitoring & Giving 24*7 Application Production Support to meet the service level.
•Involved in preparation of Technical Documentation of various modules.
•Excellent interpersonal & communication skills, better understanding of client’s expectation and strong problem solving abilities.

Software skills:

ETL Tool                    :  Datastage 8.7/8.5
Operating Systems           :  Windows 2003 Server, IBM AIX , XP.
Database                :  Oracle 10G/11G, DB2,Netezza.
Languages                :  SQL and PL/SQL,Unix Shell Scripting.
Tools                       :  SQL Developer, WinSQL, JCS,TOAD, MS-Access, MS-Sharepoint, Unica .

Project #1 : Rheem Manufacturing Company

Client             :Rheem Manufacturing Compnay
Environment            :OracleR12,Windows2000
Duration          :11 months
Role             :Oracle Technical Consultant
Team Size            : 50
Tools    & Technology :TOAD, WORKFLOW, Oracle Apps, SQL PLUS, EBS,  Putty Server
Functional   Module  :Order Management, Istore,Inventory,Purchasing.
                           
Description:
Rheem Manufacturing Company is industry that manufactures and supplies coolers and heaters , convert legacy database(Customer,supplier,items information,inventory ,warehouse ) to oracle DB using oracle conversions & interfaces and also develop customized application.

Contribution :
•Development of PL/SQL ,  executable, concurrent programs, creating value sets and registering them into oracle applications
•Involved in conversions of sales order, pricing.
•Analyzing the Requirement and Developing Customised Workflow .
•Development ad Customization of PL/SQL Procedures, and Packages.
•Involved in development of PL/SQL concurrent program which will extract the data from base tables into flat files using UTL_FILE.
•Extensively involved in Designing UNIT Test cases and executing test cases.
•Creating requried setups from front end( pricing modifers &qualifiers etc).
•Resolving the defects effectively at time of Production( Warranty support).

Project #2 : Abovenet Communication inc

Client            :      Abovenet Communication
Environment           :     OracleR12,Windows2000.
Role            :      Oracle Technical Consultant.
Team Size        :      10
Tools& Technology   :      TOAD, Reports ,BI Publisher,Oracle Apps
Functional Module   :   HRMS.

Description: 
Abovenet Communication IncProvides Telecommunication Service to Customers - To maintain legacy database(Customer and Usage of Data) using oracle and also develop customized application.

Contribution:
•Involved in INBOUND HRMS integrations.
•To transfer data from legacy Table to oracle base tables using API and Concurrent Program(o2c conversions)
•Devlopment of Reports using Report Builder and BI publisher.
•Extensively involved in Designing UNIT Test cases and executing test cases.

ACADEMIC DETAILS :
•BE (Information Science) from VTU East - West Institute of Technology, Bangalore: 2010

Personal Profile:

Date of Birth        :    25th Dec 1987
Gender                :    Female
Marital Status      :    Single
Nationality         :    Indian
Languages Known        :    English, Hindi


I hereby declare that the above written particulars are true to the best of my knowledge and belief.

Date:
Place: Mumbai                                PUNEET KUMAR

0 comments:

Post a Comment