- Strong Techinical/Functional Expertise on Retail application like ORMS, ReSA, RIB and RPM , ORPOS- Knowledge of Data Flow across application RMS-RPM-SIM-POS-ReSA-Stock Ledger.- Experience On Discount Rules (Standard/Workaround)-ORPM/ORPOS.- Strong knowledge of Database Oracle 11g, PL/SQL , Oracle forms, Pro*C , Core java- Experience on UC4 Batch scheduling and Worked on Oracle Retail Batches to debug & provide the solution in case of failures.- Worked on Data conversion

Job Profile:- Working on various commodity market data-sets such as Energy Markets, weather, gas, oil etc.- Analyzing historical data & performing QA checks on data by writing PL/SQL scripts.- Communicating vendors about discrepancies.Technology and tools involved: Oracle 10g, MIMIC, XMIM (Analytic tools)

Key deliverables:- Understanding data fields pertinent to various kinds of portfolios and process used by clients to accumulate and retrieve the data.- Establishing and defining standards and specifications for converting information from data files into formats suitable for analyzing and performing exploratory data analysis.- Handling data integration services including ETL design, data cleansing and data migration.- Designing and implementing ODS / Data Marts and Data Warehouses.- Managing OLAP Cubes design, development, analytical queries, report generation, performance dashboard design and development.- Mapping clients requirements and coordinating with them throughout the project lifecycle to verify whether the proposed Dashboard meet the required objectives.