Sostatus tech full#

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.Hands on experience with EDI ISA and GS segments, VAN/FTP/SFTP/AS2 connections and EDI providers.Developed custom package to process Ship from Store (SFS) and Buy Online Pick UP In Store (BOPIS) order requests in RMS.Hands on experience with Electronic Data Interchange documents EDI850, EDI860, EDI846, EDI810, EDI810, EDI855, EDI997, EDI852 documents.Hands on experience in U.S Customs and Border Protection HTS yearly upload into RMS.Have Worked with Oracle Retail Sales Audit ( ReSA), Oracle Retail Price Management ( RPM) and Oracle Retail Invoice Matching ( ReIM) teams and their corresponding integrations.Monitored the production logs during the warranty period and took care of fixing the high severity issues in the expected SLA.Reviewed and provided feedback to offshore team on their developments and enforced Coding standards.Cut over design, planning and coordination to ensure very minimal impact to business operations.Involved in continuous enhancements and fixing of production issues.Developed PLSQL scripts using Pragma Autonomous Transaction to avoid mutating problem in database trigger.Experience in application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.Developed PLSQL scripts using Bulk Collections for easy retrieval of data, by reducing context switching between SQL and PL/SQL.Developed several UNIX shell Scripts to call SQL Loader to load data from flat files into DB according to project and client requirements.Identified integration gaps between systems and provided solutions.Developed technical and functional design documents according to client needs.Direct communication with business team to gather client requirements.Software: Oracle Forms Builder, UC4, SVN, Microsoft Office, Putty, WINSCP, TOAD, IBM Inflight Scripting Languages: Unix shell Scripting, Java Script, HTML, XML Languages: Pro*C, SQL, PLSQL, Python, C++, C Expertise in RMS forms security, New User creation, New Role creation, Role assignment, Security user group Maintenance and User Attribute Maintenance.ДЄpplications: Oracle Retail Merchandising System, Oracle Retail Integration Bus, BI Publisher, Electronic Data Interchange.Experience in Stock Ledger, Inventory adjustment, Stock Count, Wholesale order creation and Future cost process.Expertise in Custom flex attribute setup (CFAS).Experience in foundation data modules like Org Hierarchy, Merch Hierarchy, Item, Supplier, Store, Warehouse, Location list, Item list, User defined attributes, Cost change.Experience in Purchasing, Shipping, Transfers and Receiving modules.Expertise in developing forms using Oracle Forms Builder.Experience in creating Pro*C scripts to call Database Objects according to the needs of the project.Experience in creating Shell Scripts to invoke SQL scripts and schedule them using Crontab.Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.Experience in extracting data from DB into flat text files using UTL FILE package.Experience in using Bulk Collect and FORALL to reduce context switching between SQL and PL/SQL engines.Experience in building ER diagrams for tables.Experience in Python scripting for data transfer and manipulation.Experience in designing and maintaining data extraction & transformation processes ( ETL ).Experience in Range and Hash partition techniques and Performance Tuning.Expertise in Ref Cursor, External Tables, Dynamic SQL and Exception handling.Experience in Oracle supplied packages like DBMS JOB, DBMS LOB and DBMS SQL.Experience in developing materialized views.Expertise in Stored Procedures, Functions, Packages, Triggers, Indexes and Types.8 Years of IT experience in analysis, design, implementation and testing to implement Oracle Retail Merchandising System (ORMS) using Oracle Relational Database Management System (RDBMS).