SUMMARY:

• Acompetent and experienced developer / database architect / product architect / solution architect, with around 12 years of experience in IT industries and 9 years experience in retail and commercial lending products design and 1.5 years in Clinical Database setup and development.

  Expertise in building SRS (System Requirement Specification), product implementation, database development, data migration, SQL/PLSQL programming, SQL/PLSQL tuning, ETL activity and system integration.

TECHNICAL SKILLS:

Operating System: Windows, Linux

Databases: Oracle 9i, Oracle 10g, Oracle 11g and Oracle 12c

Job Scheduling: Batch Files, CRON, Oracle Job Scheduler

Internet Server Application: IBM WebSphere

Languages: SQL, PL/SQL, XML, UML, Shell Scripting

Front end Tools: Oracle Forms 11g and VB 6.0

Reporting Tools: Oracle Reports 11g, SAP Crystal Reports and BIRT Reports

Other Tools: MS Project, MS Visio

Oracle Supporting Tools: Oracle SQL Developer, PL/SQL Developer, TOAD, SQL Loader

Version Control: VSS and Tortoise SVN

PROFESSIONAL EXPERIENCE:

Confidential, Birmingham

Senior Software Engineer

Responsibilities:

• Performed Kastle system development / customization activity using Oracle SQL, PL/SQL database store procedure (Procedure, Function, Packages, Trigger etc.).
• Performed proof of concept (POC) for new prospects.
• Implemented the Kastle ULS (Universal Lending Solution) products (Retails & commercial lending) to leading banks in United Kingdom.
• Used Complex PL/SQL like external tables, XML objects, cursors, Bulk Collect, Collections, Global Temp Tables etc.
• Followed CBO (Cost Based Optimizer) for SQL tuning, used optimizer hints, created various indexes, partitions, tablespaces, compression technique for better performance.
• Used AWR report to tune the oracle procedure and functions.
• Used Oracle job scheduler for daily automated tasks processing.
• Written procedures and functions for reports.
• Used Oracle materialized view for better performance to generate reports.
• Installed Kastle application at client server using Oracle data pump for import and export the database backup and EAR file on IBM WebSphere.
• Facilitate the data archival activities using the Oracle Database link.
• Developed exception handling technique and effective historical data management.
• Produced Entity Relationship Diagrams (ERDs) (database modelling), High & Middle level design documents.
• Integrating customer’s legacy system with Kastle ULS products using oracle external tables, DB link, UTL packages and web service.
• Performed data migration activities created SQL & PLSQL scripts to populate the data into target system.
• Troubleshooting the live issues and providing solution or workaround.
• Fix existing bugs in the application under production and supply the Root Cause Analysis (RCA).
• Responsible for Unit Testing, Integrated System Test and User Acceptance Test
• Conduct proof of concept (POC) for pre - sales activities.
• Conduct the requirement gathering workshops and making sure that all the high level requirements are covered based on the scope defined.
• Applied use case methodology in system analysis to identify, clarify, and organize system requirements.
• Produced System Requirement Specification documents to confirm the business requirements and target system design.
• Manage changes to the requirements using versioning the requirements and assigning them MoSCoW priorities.
• Worked agile practice team to produce SRSs.
• Producing requirement traceability matrix to make sure all requirements is covered and avoid any possibilities of scope creep.
• Responsible for identifying, analysing, measuring and managing project risks. Producing the RAID (Risk, Assumption, Issue and Dependency Log) to effectively manage the risk.
• Facilitate the KT sessions between onshore and offshore team.
• Making sure that SOPs are followed during process.
• Leading the defects triage meetings and solving the issue and managing the conflicts between team.

Confidential

Senior Software Engineer

Responsibilities:

• Developed the Clinical Database Management (CDM) application using oracle forms 6i, reports 6i.
• Designed study application using oracle developer 6i based on the Case Report Form (CRF).
• Writing PL/SQL procedures and functions validation based on the study protocol to validate clinical data entered from data entry application.
• Designed various module i.e. data entry, data quality check, medical coding, clinical data validation, edit checks on clinical data and reports.
• Designed the audit trail module using DB triggers.
• Uploading new versions of medical dictionary i.e. MedDRA, WHO Drug to the CDM application.
• Responsible for Unit Testing, Integrated System Test and User Acceptance Test.
• Performance tuning of CDM application.
• Lead the clinical database setup and application development department.
• Lead technical discussions with the users and take ownership for delivery of module(s).
• Part of the Innovation group to identify new systems/processes.

Confidential

Database Developer

Responsibilities:

• Involved in Database objects creation i.e. tables, views, triggers, stored procedures, testing & debugging.
• Responsible for Unit Testing and Integrated System Test.