Vijaykumar Sirpa
Hyderabad
Summary
- Vijay Kumar Sirpa has over 16 Years of experience in Oracle Retail Domain as a Techno-Functional Consultant.
- Very Strong Knowledge in Oracle Retail Suite as a Techno Functional consultant.
- This encompasses Requirements Gathering, Analysis, Solution Design, Development, Testing, Deployment, Maintenance and Troubleshooting/Support.
- Comprehensive knowledge of Oracle Retail products such as Oracle Retail Merchandising System (ORMS), Oracle Retail Sales Audit (OReSA), and good exposure to Retail Price management (RPM) and Oracle Retail Integration Bus (ORIB).
- Worked on versions 13.2.x and 14.x, 16 and 19 for retailers in USA ,UK, Dubai, and Middle East. Worked on Oracle Retail implementation, Development, Support, and Testing Projects. Extensive experience in Oracle PL/SQL, SQL, Unix Shell scripting and ProcC
- Hands on experience in analysis and problem solving of Production support projects.
- Experience in data migration projects Data Conversion for major functionalities in Oracle Retail
- Good communication skills, interpersonal, learning and organizing skills.
- Ability to manage stress and time efficiency. A good team player with good communication skills and has an ability to work in a team.
Overview
16
16
years of professional experience
Work History
Associate Consultant
Tata Consultancy Services
08.2022 - Current
- Current role involves working on development and enhancement requirements.
- Projects runs in Agile methodology, requires close working with product owners and scrum master.
- Oracle Retail applications hosted in Azure cloud
- Development includes Oracle PLSQL, Store Procedure, Functions, Cursors, Triggers and , Unix Shell Script batch etc.
- Coordination with product owners and and analysis of requirement and converting them into technical stories, tasks , estimations.
Sr Consultant
Infosys
07.2019 - 08.2022
- worked on US based discount retailer Oracle retail complete cloud implementation project
- Implemented integrations for stock counts , inventory adjustments, purchase orders, transfers in Azure layer to process the data in both oracle retail applications and third party legacy applications and also helped team custom data load process in Azure database.
- Worked along with UAT users during UAT testing phase, guiding and helping them to use the test data and capture the results.
- Base Oracle retail issues are solved and got them implemented in various patches via communicating with Oracle support and reproducing the issue and providing required details to Oracle support.
Sr. systems analyst
Gap It services
03.2018 - 07.2019
- Lead GAP Europe support and development teams.
- Support team monitors daily incidents created by users and gives required resolution, also checks on the batch failure issues reported by monitoring team.
- Development includes mostly enhancements to existing code and working on any defects created for existing interface codes.
- used Oracle SQL. PLSQL. shell scripting and Oracle Apex
- Also worked on Implementation of v16 cloud implementation for various brands of GAP INC
Sr. Software Engineer
Tech Mahindra
08.2013 - 03.2018
- Lead the Data migration team and did successful migration from ISCM legacy system to RMS 14 version
- Worked with Oracle and business teams to finalize the legacy vs RMS mappings
- Lead the development of data migration scripts
- Creation of data migration design documentation
- Data Conversion for major functionalities in Oracle Retail such as Static data, Merchandise Hierarchy, Organization Hierarchy, Suppliers and partners, Items, Item extensions, Item Suppliers, Item location ranging, Transactional Data, RPM data conversion.
- Handling Data migration related issues in Defect triage call
- Created execution plans for migration execution for various test cycles and DRs.
- Participated in cutover meetings and executed the Final migration in production
Sr. Software Engineer
Accenture Services Ltd
09.2012 - 08.2013
- Worked as a Techno functional consultant for the RMS, ReSA.
- Trained the users and team members about all the RMS and ReSA modules.
- Written Test cases for ORMS and OReSA modules.
- Performed Design verification and Requirement verification for High level design documents and Requirements documents.
- Performed System Integration Testing for Written Test cases.
- Review Calls with Concerned Stake Holders
- Defect Management in HP QC.
- Execution of Test Scripts.
- Prepared the documents and execution process for Oracle Retail Batch Jobs for the all MOM modules.
- Interaction with the Oracle Support for Service Request (SR) resolution
Software Engineer
Zensar Technologies
10.2009 - 08.2012
- Providing techno functional support of Retail Sales audit.
- Handled Inventory, Purchasing and Transfer related issues.
- Provided solutions to business user problems in handling application.
- Suitable work around given in case of urgent matters.
- Handled ORIB hospital messages by applying SOP.
- Handled multiple projects issues Related ReSA on daily basis.
- Corrrecting data mismatch between ORMS and ReSA module.
- Bug fixing done for existing product and tested successfully.
- Created new TOTALS as per client requirement.
- Developed Reusable scripts to resolve the data discrepancy due to existing system bugs.
- Configured and made a complete chain to Load the RTLOG in RMS/RESA/GL.
- Scheduled the RMS batches as per the business requirement. Also set the customized batches in between the chain.
- Handled Change requests (CRs) and Oracle SRs.
- Developed PO EDI upload PLSQL, SQL and Unix shell script.
Education
Bachelor of Engineering - ECE
Osmania University
Hyderabad05.2009
Plus 12 -
NVR Junior College
Vijayawada05.2004
SSC -
Trinity Model Seconday School
Peddapalli05.2002
Skills
- Technical: Oracle SQL, PL/SQL,Oracle Apex,shell scripting
- Oracle Retail SaaS, On-prem
- Loader, Data Import and Export, Azure
- Databases: Oracle, Oracle DAS
- Tools: ORIHA, Automic
- Domain Knowledge: Retail
Timeline
Associate Consultant
Tata Consultancy Services
08.2022 - Current
Sr Consultant
Infosys
07.2019 - 08.2022
Sr. systems analyst
Gap It services
03.2018 - 07.2019
Sr. Software Engineer
Tech Mahindra
08.2013 - 03.2018
Sr. Software Engineer
Accenture Services Ltd
09.2012 - 08.2013
Software Engineer
Zensar Technologies
10.2009 - 08.2012
Bachelor of Engineering - ECE
Osmania University
Plus 12 -
NVR Junior College
SSC -
Trinity Model Seconday School
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Nithin SaraNithin Sara
Sr. Product Engineer at TECHMAHINDRA LTDSr. Product Engineer at TECHMAHINDRA LTD