Bhavin A. Email & Phone Number

London, Gb

London, United Kingdom

Redhill, United Kingdom

London, United Kingdom

Responsible for the development, testing and support of the system using Oracle (and it's tool sets - SQL, PL/SQL, Forms, Reports) which is developed to agreed quality standards and timescales within a structured development framework.

London, United Kingdom

Working as an Oracle Consultant within Systems Integration - Oracle Practice area of Atos UK.Working with small and large teams on assignments ranging from a few weeks to being a member of the large team on a long running project/programme for system deployment.Senior Oracle Consultant - Client: Highways England - Confirm to Oracle Interface Project• Key member of a team in reviewing and understanding the requirements from the functional consultant & technical lead.• Built SQL script to extract data from Oracle Apps and produced .csv/file using PL/SQL routine.• Built script to create staging tables.• Built SQL*LOADER or CTL script to import data from flat data file into staging table.• Built interface using PL/SQL routines.• Defined and registered concurrent program to execute from Oracle Apps (eBusiness).• Involved in unit testing and creation of UTP and Technical Design Docs.• Mentored junior developers in database design and development of SQL, PL/SQL coding.Oracle Consultant – Client : DVSA - Oracle Financial & HR Upgrade Project• Key member of a team in reviewing and understanding business requirements from the project manager & technical lead.• Built PL/SQL routines for Supplier API.• Involved in analysis and diagnosing the Oracle BI Discoverer Reports (finance & HR Reports).• Involved in fixing SQL queries for the Oracle BI Discoverer Reports (finance & HR Reports).• Created analysis spreadsheet for the discoverer reports.

London, United Kingdom

Lead Oracle Developer - ATOS Internal Projects (Digital Prototype Unit ->Risk Management for Bids, Marketing Accounts Dashboard, Project Matrix)• Key member of a team in analysis & design activities.• Involved in development of the system using Oracle APEX v5.0 (includes Dashboard, Forms, IR/Classic Reports & Charts).• Involved in writing SQL & PL/SQL scripts.• Design and development of database objects viz. Tables, Views, Triggers and Sequences.• Involved in Unit Testing and technical documentation.• Delivered project using agile methodology. Lead Oracle Developer - NS&I (T&I Program, DCM-Data Anonymization Project)• Key member of a team in reviewing data masking activities.• Collaborating across teams to understand and progress data masking initiative.• Built data anonymization routines or amending existing code using Oracle SQL and PL/SQL scripts to suits the demand of the new data.• Worked closely with the other members of the project team and attending regular team meetings.• Compliance with security measures in place to ensure that work is carried out in accordance with security norms.• Involved in Unit Testing and technical documentation before deliver to central test.• Carried out any other task associated with the role as reasonably requested (e.g. Configuration Management, ODM analysis, etc).

London, United Kingdom

Lead Oracle Developer - Munich Re Plc (IT Simplicity Prog, Report Writer Replacement Project)• Involved in analysis, redevelopment and delivery of the critical report system.• Analysis, tuning and re-writing SQL queries.• Created new and modified PL/SQL routines (Packages, Functions, and Procedures) as per standard.• Unit testing and technical documentation.Oracle Developer – Client: Natural England - Genesis Project• Involved in analysis, development and delivery of the critical system.• Built & maintain new and existing Oracle Discoverer Reports and Oracle Apex forms & reports.• Built SQL & PL/SQL scripts inc. Procedures/Functions, Packages etc.• Involved in creation of ref data patches to update the portal for new releases.• Produced various documents e.g. Unit Test Plan, Evidences & Review Record documents as per the standard.• Involved in impact analysis and development estimation.• Involved in communication and discussion with client to ascertain further information and to provide guidance.• Ensuring that the above is completed in line with Atos/NE project standard.

Croydon, United Kingdom

Home Office - UKBA (ICW Prog, iDecide Project).Responsibilities:• Provided 2nd Line production support (2LS) for a large SOA/BPM composite application implemented using a various Oracle products: (inc OPA v10g, OSB v10g, BPM v10g, Weblogic Server 10g, Siebel 8.1, Oracle11g Database) as directed through Service Desk and supporting process.• Analyzed and resolved incidents to agreed SLAs.• Impact assessments on changes• Supporting build & test of the fixes• Prepared technical documents that helps team members and new joiners.

London, United Kingdom

Internal Projects - Oracle Resource Planner (ORP), Risk Management for Bids, Marketing Accounts Dashboard and Project MetricsMain duties included:• Key member of a team in analysis & design activities.• Involved in development of the system using Oracle APEX v5.0 (includes Dashboard, Forms, IR/Classic Reports & Charts).• Involved in writing SQL & PL/SQL scripts.• Design and development of database objects viz. Tables, Views, Triggers and Sequences.• Involved in Unit Testing and technical documentation.• Mentored junior developers in development of SQL, PL/SQL and Apex coding.• Delivered project using agile methodology.

Crowthorne, Berkshire, United Kingdom

In this role I was working on the design and development of their main application to support the business using mainly Oracle 10g Rel 2, SQL, PL/SQL, Oracle Apex v3.2/4.0 and Oracle Designer. Responsibilities:• Reviewed and understood the business requirements from the technical team leader.• Involved in development and creation of the system using Oracle APEX v3.2, SQL scripts PL/SQL stored procedures.• SQL performance tuning using Explain Plan. • Executed Unit Testing and Component Testing as per standard.• Provided support for handling all database changes, design changes etc. and update code as necessary.

London

I worked on the development of their bespoke applications using mainly Oracle database 10g, SQL and server side PL/SQL development.Responsibilities:· Developed scripts using Oracle SQL & PL/SQL to support the .NET functionality. · Involved in creation of detail technical design and unit test plan.· SQL performance tuning using Explain Plan and Oracle 10g SQL Tuning Advisor.

United Kingdom - Nationwide

I acquired a wealth of Oracle experience from a series of short-term contract roles working for leading organisations across a variety of industry sectors including Financial Services and manufacturing. Clients include:• Network Rail, London• IBM (for BACS Ltd.), London• Standard Life Assurance, Edinburgh• Cattles Group Plc, Hull• Homeowners Society, Harrogate• L-Systems, Reading• SEMA Group Plc, Nottingham• Prudential Financial Services, Reading• ESIS, Nottingham• ICL UK (for Haringey Council), London• Liverpool Victoria (LV=), Bournemouth• Alsthom Gas Turbines Ltd, LeicesterDuring these contract opportunities, I performed a diverse set of activities that included:• Reviewing and understanding Business and System Spec written by Business Analyst.• Reviewing System Use Cases developed by Business Analyst that reflect to System Spec.• Writing SQL scripts, PL/SQL packages procedures / functions, creating forms using Oracle Forms and creating reports using Oracle Reports Builder.• Using XML Spy to re-engineer XML Schema (XSD) for XML documents generated from Report Builder.• Writing detailed Technical Design specifications for each report and package procedure or function.• Writing Unit Test Plans as per project standards.• Generating test data and files and test data cleansing.• SQL performance tuning using Explain Plan and TKProf.• Executing Unit Testing and Component Testing as per standard.• Provide support for handling all database changes, design changes etc. and update code as necessary.• Involve in Defect Management – assessing defects, implement fixes against defects and release. • Providing full support during different phases of Testing (Component Testing, SIT, OAT and UAT).• Mentoring and helping new joiners/junior members of the project as and when required.

Vadodara Area, India

Oracle Forms, Reports, SQL, PL/SQL and Oracle Designer.

Post Graduate Diploma In System Management, Information Technology, Computing

Bachelor Of Commerce (B.Com), Accounting, Costing & Auditing