Gerson Berena

• A highly resourceful professional with years of experience focused on end to end system implementation , development , business requirement gathering , business analysis, production support and enhancements of Oracle Retail software solutions for various US major retailers • A skilled professional with extensive technical and functional knowledge in Oracle Retail modules on merchandising, finance , supply chain management, warehouse distribution, inventory, sales audit, pricing and allocation. • Experience on business relationship building with clients, technical and functional design creation, business requirements gathering, data conversion, integration , data mapping, production support, systems development, unit testing, system testing, and integration testing. • Advanced knowledge of Oracle SQL and Data Analysis , Oracle PLSQL programming, MS SQL, Oracle Forms, UNIX, KSH Shell Scripting, API test scripts, middleware, PL/SQL , build oracle reports and forms, oracle SQL performance tuning • Involved in all phases ( (design, development, migration and production support ) of the Software Development Life Cycle (SDLC), both waterfall and agile development Life Cycle (SDLC) model • Experienced in Unit testing, system testing, integration, user acceptance testing, oracle retail industry standards, QA testing • Oracle database design experience, data flow diagrams , complex SQL queries, API programming, UNIX coding, ETL , EDI, XML file and flat file extraction, Data Architecture and frameworks knowledge, Microsoft SQL server , developing codes for complex projects ,designs, integration, test automation • Experience on technical and functional design documentation , software design , building complex data sets, relational databases , complex database programs, business requirement gathering, data conversion process, data conversion strategy, integration strategy, production support work and various testing phases