Deepika Verma

I, Deepika Verma is a qualified and seasoned IT professional with 14+ years of professional experience executing projects in BFSI, Retail, Medical and Telecom domain.

✓ 8+ years of experience in Oracle Developer and software applications development using Oracle Forms and Reports, advanced Oracle PL/SQL, SQL and UNIX Shell scripting

✓ 4+ Years of experience as Data Analyst

✓ 5+ years of experience in Data Migration Expert

✓ Strong SQL skills, ability to understand business processes & analyze complex data sets, to trace data quality and fraudulent data issues in source systems.

✓ Expert in developing PL/SQL procedures, functions, packages and triggers using features like bulk collection, bulk binding, bulk exceptions, records, collections, objects, ref cursors, materialized views and dynamic SQL

✓ Exposure to the complete life cycle of projects from Planning, Requirement analysis, design, development, testing, deployment and support of projects

✓ Handled service delivery to client in offshore & Onsite model including cross functional supervision

DEVELOPMENT PROJECTS

1. GST &

• IRIS (KL) - 7Eleven (Malaysia) - Data Migration &

• GST Implementation

1. 7Eleven (KL, Malaysia) the Project is divided into two phases. The first phase includes the implementation of GST feature in current system and Second phase is for Data Migration from current system to SAP using Oracle. Report generation (using Oracle SQL) for Data Matching and Data Analysis is also part of the project for project closure. 
2. Citi Bank (Germany) Objective of project is to replaces the existing CIP application of Citibank Germany with Citibank EBS, a product of fidelity that automates the 'Core' functions of a bank. The project is one of the biggest rollouts in Europe.
3. RBS (UK), The Project is based on Data Migration, the purpose of project was to migrate the selective data to other database for generation of auto reporting.
4. 4Medica (US), The intermediate requirement in project is based to migrate and load data from different interfaces to system.

1. Acxiom (Noida, India) - Data Extraction, Data Validation and Report Generation as an Oracle Data Analyst. 
2. 7Eleven (KL, Malaysia) - Data Migration &

   • GST Implementation, the project includes Writing SQL queries for Reporting, Data Extraction, Data Analysis &

   • Data Matching of migrated Data from current system to SAP.

3. RBS (UK), The Project is based on Data Migration, In Testing phase Writing &

   • Tuning SQL queries for Data Verification was part of project scope.

4. Reliance Info-solutions (telecom &

   • Petroleum), Project includes Data Extraction, Data Analysis &

   • Query Tuning for Decision Support System (DSS) which predicts vital information to Business Users to make timely & accurate information for business growth leading to effective & efficient operations to gain a competitive edge in marketplace to collect data from multiple sources, summarizes data for business needs.

1. 4Medica (US), As a QA lead monitoring all QA activities were the part of Role 
2. Citi Bank (Germany) Objective of project is to replaces the existing CIP application of Citibank Germany with Citibank EBS, a product of fidelity that automates the 'Core' functions of a bank. The project is one of the biggest rollouts in Europe.

1. 7Eleven (KL, Malaysia) - Data Migration &

   • GST Implementation

2. RBS (UK), Data Migration Project for Group Risk Data Warehousing (GRDW)
3. AXA(Japan), Non-Life Insurance quotation creation and renewal application.
4. ONGC (India Govt), Integrated Material Management Systems (IMMS)

1. Acxiom (Noida India), Data Extraction, Data Validation, Report Generation.
2. 4Medica (US), is web-based Integrated Health Record (IHR), designed to create easy access to real-time, patient-centric, multi-organizational, multi-modality clinical lab data from multiple inpatient & outpatient sources.
3. JPMorgan Chase (UK), Global Liquidity Project
4. Solera Inc (US), AUDATEX Non-Life Insurance Project.

• Certificate Course in Foundation of Data Science
• MCA (master's in computer applications)
• PGDPM (Post Graduate Diploma in Personnel Management)
• BSc (In Computer Science)