A dynamic, team-spirited and performance-driven professional offering 7 years of experience in Designing, Developing and Coding using Oracle Developer Suite10g, Oracle Forms 6i, Reports 6i, Crystal Reports, Oracle 9i and Oracle 10G.11g,12c
Demonstrated excellence in Client/Server Technology using Oracle Developer Suite 10g, Developer 2000 and Crystal Reports as Front End with Oracle 9i & 10g as Back-End
Expert in Migration oracle forms 6i to 10g,11g,12c and Modernize Forms
Skilled at creating Database Objects such as Tables, Views, Procedures, Functions, Triggers, Packages,
Good exposure in upgrading SQL forms to D2k Forms and developing New Forms &Reports in D2k
Ability in writing SQL queries,procedures,functions & triggers in Oracle Database
Expertise in providing End User and Production Support
Deep understanding of technology with focus on delivering business solutions
Adept at maintaining focus on achieving bottom-line results while formulating and implementing advanced business solutions to meet a diversity of needs
Overview
14
14
years of professional experience
1
1
Language
Work History
Software Developer
Gati-kintetsu Express Private Limited
09.2021 - Current
Projects Handled:
Project#1: GEMS ( GATI Enterprises Management System) .
Responsibility: Creating & Altering of Packages,Procedures , Triggers & Sequences In Oracle Database 12c.
Completed necessary Development Changes to support oracle forms technology Upgrade project, migrating Oracle Forms Application Forms 6i to Forms 12c.
Created Dblinks between Oracle Ebs Server and Oracle forms server.
Bug Fixation in Oracle Packages and Procedures.
Configuration of UTIL_SMTP and UTIL_MAIL.
Solution Provided for Direct print from Oracle Forms Application 12c.
File Transfer between Client and server.
Reports Auto mail Scheduling.
JVM Creation in WebLogic server
Call JSP Files through forms
Software Developer
BINDU PHARMACEUTICALS
07.2019 - 02.2021
Projects Handled:
Project#1: ERP ( Production Management System) .
Software/Platform: Oracle 10g Forms And Reports
Team Size: 1
Description: Data Migration From Excel TO Oracle Data Base, New Application Development
Batch Production Process , Stores Issue, Despatch Module,Production Planning
Lab Analysis Log Records Etc.
FRELANCER
AARUSH CREATIONS
01.2019 - 12.2020
Projects Handled:
Project#1: Sales Management System.
Software/Platform: Oracle 11g Forms And Reports
Team Size: 2
Description: Application New Development, Designing Modernize Forms Sales Module,Wms.
Software Developer
ION EXCHANGE (i) PVT LTD
01.2016 - 12.2018
Projects Handled:
Project#1: Business Strategy Management System.
Software/Platform: Oracle 10g Forms And Reports,Oracle 10g , 10g Database
Team Size: 3
Description:
Designed and implemented client-server application using Oracle Forms Builder.
Developed Menus in such way that users can access the forms through menus
Development of Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases.
Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
Designed and Developed Forms for tracking the account details of the customer.
Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
Generated barcodes and EAN numbers based on sales codes and size
Efficiently designed MRP and EAN stickers
Software Engineer
IL & FS SECURITY SERVICES LIMITED
01.2015 - 06.2016
Projects Handled:
Project#1: NSDL Module Support New Development.
Software/Platform: Oracle 11g Forms And Reports,Oracle 12c .
Team Size: 3
Description: Depository Participant Management System (DPMS)
Application handles the entire lifecycle of depository operations of the IL&FS Security Services
A Client-server architecture based back-office system designed for Depository Participants of NSDL (National Securities Depository Limited, India) to streamline their back-office operations from various branches so that it can be done in a systematic and organized manner.
Junior Developer
POKARNA LTD
01.2012 - 12.2014
Projects Handled:
Project#1: Material Management (Fabric & Trims).
Software/Platform: Developer Suite 10g, Oracle 10g
Team Size: 2
Description: MM is an Organizational concept, Which has the authority & responsibility of all activities with the flow of materials in the oraganisation
Operations involved in the flow of materials are – Purchasing,Inventory, Receiving,Storing & production Issues.
Responsibilities:
Designed Oracle forms and reports on user requirements
Developed Oracle procedures and functions to meet functional requirements
Conversion of data from legacy system to new system
Coordinated with Functional staff in the development
Project#2: ACCOUNTS MODULE.
Software/Platform: Developer Suite 10g, Oracle 10g
Team Size: 4
Description: Accounting module is an application software that records & processes accounting transactions within functional modules such as accounts payable, accounts receivable, payroll, and trial balance
It functions as an accounting information system
It was developed in-house by the company or organization.
Responsibilities:
Designed Oracle forms and reports on user requirements
Developed Oracle procedures and functions to meet functional requirements
Conversion of data from legacy system to new system
Coordinated with Functional staff in the development
Project#3: WAREHOUSE MANAGEMENT SYSTEM (WMS)
Software/Platform: Developer Suite 10g, Oracle 10g
Team Size: 4
Description: A Warehouse Management System is a key part of storage of materials within a warehouse and processes the associated transactions, including shipping, receiving the materials
The main objective of a Warehouse Management System is to provide a set of computerized procedures to handle the receipt of stock and returns into a warehouse.
Responsibilities:
Designed Oracle forms and reports on user requirements
Developed Oracle procedures and functions to meet functional requirements
Generated barcodes and EAN numbers based on sales codes and sizes
Efficiently designed MRP and EAN stickers
Project#4: RETAIL OUTLET MODULE (ROL)
Software/Platform: Developer Suite 10g, Oracle 10g
Team Size: 4
Description: Retail Outlet Module has Brand Master, Product Master, Product fit master, sales master
The warehouse departmentsends the stock through outward to outlets
They take the stock through scan inward
They scaneach and every item barcode
Sales person enters the customer name and scans the sales codes it display size, brand, product code and MRP of the particular sales code.
Responsibilities:
Instrumental in designing, developing and coding of Oracle forms and reports
Generated barcodes of every sales code
Coordinated with Functional staff in the development
Warehouse asst
POKARNA LTD
01.2010 - 12.2012
Responsibilities:
Excellent Knowledge in System Related activities such as Excel, Power point, MS-Word MS-Outlook , MS-DOS
Can Ensure Control Of Records And Documents.
Taking care of Goods returns Unloading, verification, and separate stacking till update the same in system etc
And Maintaining GRN (Goods Return Note ) Statements and Submission of Good Return Details with in 24 hours to the Excise Department.
Maintaining good rapport with the sub ordinates & seniors
Preparing/Billing all types of Invoice like, Stock Transfers and MBO(Multi Brand Outlet like,Pantaloons,Futures Supply,Pokarna Fashions Etc ) invoices
Taking care of All Inwward and Outward Goods as per system updations.
Maintaining records/Data for WH Transactions on daily basis.
Taking care of Daily Dispatches and Sending Despatched Details to the Management.
Perfect in All Warehouse Transactions in System.
Mantaining Ground lever staffs and Helpers
Can Run any Required Report Required By Managemennt and Make Presentations.