OBJECTIVE

• 16 years of software experience in developing Internet Applications & Client - Server technology-based applications (2 and 3 tiers) for financial, telecommunication, sales, manufacturing, retail and marketing domains. Gained expertise in working with technologies and languages like SQL,PL/SQL, Oracle 9i,Oracle 10g,, Oracle 11g, Oracle XML Publisher, Oracle Discoverer, Oracle Forms 6i, Reports6i,Forms 10g, Reports 10 G, Forms 11g,Crystal Report, Oracle 10G, 9i Application Server, Oracle RMS,RIB,ReSA,RPM and RDM. Well organized in business analysis, problem solving, decision making, requirement gathering, defining scope, database design, scheduling, and issue/risk control.

PROFESSIONAL EXPERIENCE

Senior Oracle retail consultant

Confidential

Responsibilities:

• Analysis, research, design and write specifications for maintenance of the new allocation system
• Develop detail technical specification of business requirements.
• Develop standards, procedures and checklist to meet business requirements.
• Performance monitoring, tuning, troubleshooting, reorganization and security implementation.
• Capacity planning and design reviews. Migrations, upgrade, apply patches, backup and recovery.
• Maintain databases, design new structures/ pl/sql packages /procedures / views / function for development and data migration from production to reports.
• Modifying the existing data structure table and adding new database objects through data modeling tool and extract the script and run it in dev environment and check it into svn
• Created new Oracle forms 11g application forms for new allocation system
• Created new ETL informatica integration to SAS size profile for allocation system
• Co-operate with and provide technical support to project teams and members and associates.

Environment: Windows 10, Oracle 10G,Oracle 11g,Java,Pro C, Unix,Forms 11g, Reports11g, Oracle 11g Application Server for Linus,Oracle Retail Merchandising System(ORMS),Oracle Retail Integration Bus(ORIB),Oracle Retail Price Management System(ORPM) and Oracle Retail Sales Audit(OReSA),ETL Informatica 10.2.

Confidential, TX senior Oracle retail consultant

Responsibilities:

• Analysis, research, design and write specifications for maintenance and enhancement of modules in Oracle Retail Merchandising System (ORMS), Oracle Retail Integration Bus (ORIB), Oracle Retail Price Management System (ORPM) and Oracle Retail Sales Audit (OReSA).
• Develop detail technical specification of business requirements.
• Develop standards, procedures and checklist to meet business requirements.
• Modified the existing Purchase Order /Item application and added new screens in Oracle Forms 11g for multi po functionality
• ETL integration with WMS customer order management system
• ETL integration with TOMS order management system
• WMS integration with DHL for label printing
• Performance monitoring, tuning, troubleshooting, reorganization and security implementation.
• Created new oracle BI Publisher reports for ORMS and OWMS
• Created Oracle Analytics / build Cubes inside the Oracle RMS and created BI publisher reports for Enterprise Business operations
• Capacity planning and design reviews. Migrations, upgrade, apply patches, backup and recovery.
• Maintain databases, design new structures/ data modeling / pl/sql packages/ procedures / views / function for development and data migration from production to reports.
• Prepare the structure and relationships through data modeling tool and generate the script and move to Dev environments and check it into svn for other environment releases.
• Co-operate with and provide technical support to project teams and members and associates.

Environment: Windows 10, Oracle 10G,Oracle 11g,Java,Pro C, Unix,Forms 11g, Reports11g, Oracle 11g Application Server for Linus,Oracle Retail Merchandising System(ORMS),Oracle Retail Integration Bus(ORIB),Oracle Retail Price Management System(ORPM) and Oracle Retail Sales Audit(OReSA), ETL Informatica 10.1.,Oracle BI Publisher

Confidential senior oracle retail consultant

Responsibilities:

• Analysis, research, design and write specifications for maintenance and enhancement of modules in Oracle Retail Merchandising System (ORMS), Oracle Retail Integration Bus (ORIB), Oracle Retail Price Management System (ORPM) and Oracle Retail Sales Audit (OReSA).
• Develop detail technical specification of business requirements.
• Develop standards, procedures and checklist to meet business requirements.
• Created new Oracle Forms 10g application on top of the Oracle RMS system for Item/PO enhancement.
• Worked on integration between RMS to Legacy Merchandizing System/WMS system through ETL Informatica 10.1
• Worked on ORMA merchandizing analytics system for creating Cubes which is built in oracle data warehouse system for Enterprise daily reports
• Building oracle BI Publisher reports for purchase order system
• Performance monitoring, tuning, troubleshooting, reorganization and security implementation.
• Capacity planning and design reviews. Migrations, upgrade, apply patches, backup and recovery.
• Prepare the data warehouse structures for BI reports through data modeling tool and enhancement or customization on the existing RMS tables through data modeling tool and check it into SVN and work with DBA for moving across environments.
• Maintain databases, design new structures/ data modeling / pl/sql packages/ procedures / views / function for development and data migration from production to reports.
• Co-operate with and provide technical support to project teams and members and associates.

Environment: Windows 10, Oracle 10G,Oracle 11g,Java,Pro C, Unix,Forms 11g, Reports11g, Oracle 11g Application Server for Linus,Oracle Retail Merchandising System(ORMS),Oracle Retail Integration Bus(ORIB),Oracle Retail Price Management System(ORPM) and Oracle Retail Sales Audit(OReSA), ETL Informatica 10.1,Oracle BI Publisher.

Confidential senior software engineer

Responsibilities:

• Customization and production support on RMS,RIB,ReSA and RPM modules.
• Working on RMS inventory control customization .
• Collecting the requirements for the RMS to WMS and WMS to RMS interfacing implementation
• Design and Technical documentation for RMS, CWD and RDM interfacing implementation
• Design new dataset struction or data modeling
• Customising the oracle RMS forms and new reports for the inventory balance.
• Creation and modification on RMS and WMS messages for the reconciliation of transaction
• PO Reports creation,Transfer Form and Locatioon Form Creation and Reports.
• Working on the following Oracle RMS RIB Subscription and publishing packages and other Customes changes screen and functionalities
• Appointment Subscription Package
• PO Receipt Subscription Package
• Sample Pull adjustments
• Transfer Receipt Subscription Package
• Allocation Receipt Subscription Package
• Inventory Adjustment Subscription Package
• Stock order status Subscription Package
• Mass Return Transfer Module Enhancements
• Wholesale Module Enhancements
• Transfer Request Changes for prerequest for Transfer
• ASN Messages In/Out
• Allocations for Purchase orders
• Transfer for Multileg Functionality
• Receipt against Purchase order and Stock Orders
• Organization Hierarchy Messages
• Purchase order messages
• Vendor Messages
• Po history messages
• Items and HTS messages and new enhancements
• Adding Lot number against the backstock locations
• Creation of Transfers against Skulist.
• Packages, procedures and function creation for the ANF custom changes for the above subscription package
• Extension table creation for the RMS core tables for the RDM to SIMS and OBWIMS functionality
• Inventory balancing between different systems like RMS,CWD and RDM through Snapshot
• DTC batch program creation in shell script and pro C for Customer back order and the auto sales and returns functionality execution.
• RDMT and RIHA responsibity for RIB.
• Version control through PVCS
• Handling RIB and integration Support.

Environment: Windows XP, Oracle 10G,Forms 10g,Reports10g,Toad,, PL/SQL Developer, Pro C, Unix,Oracle 10 Application Server for Linux,Oracle RMS13,RDM.

Confidential

Associate consultant

Responsibilities:

• Implementing enhancements in the underwriting, funding and customer service screens
• Production Support to abf modules created through form 6i
• Creating packages, stored procedures,triggers,batch job creation, optimizing and tuning the codes
• Loading of client database information to the working database through the oracle utility sql loader
• Creation of ad hoc reports through the oracle discoverer and report 6i
• Batch job creation for the newly created letters and reports created in EW,EM,EN,EL package structure
• Creation of libraries pll,olb
• Getting the objects through FTP and Deploying the objects into server through Unix
• Customer service thorough the telecommunication for the loan application status and payment entry.
• Regionalization and customization of the product through the database objects usage in the region.
• Developing reports for the modules and xml publisher reports for java application
• Debugging and Testing
• Design document, Test case, SOD Documentation
• PVCS librarian

Environment: Windows XP,Unix,SQL Loader, Oracle Discoverer, Oracle 10G, form 6i,Reports 6i, Reports 10G,PL/SQL Developer, Oracle XML Publisher, Oracle 10G application Server