Experience Summary

• 8+ years ORACLE from Turnkey solutions to commissioning.
• 7+ years PL/SQL includes Procedures, Functions, Triggers, Packages, Ref - cursors, built-in Packages and Collections with Object.
• 2+ years XML file loading.
• 2+ years Data Conversions/Migration.
• 2+ years SQL Performance Tuning.

Technical Expertise

SQL, PL/SQL, C, C++, C#, Visual Basic

Databases:

Oracle, SQL Server

Tools: Toad, SQL Developer, Developer 2000

OOAD:

UML

Design Tools:

Visio, Project

Operating Systems:

Windows, Unix, Linux

Work Experience

Confidential,NY 2 yrs +

PL/SQL Developer

Confidential,New York is the premier provider of business process optimization and intelligence management technology supporting health insurers’ commercial, Medicare and Medicaid lines of business.

• Assisted Team Lead in designing insurance and medical service providers’ database.
• Created database objects -tables, indexes, views etc required for those service providers and clients.
• Wrote stored procedures to manipulate tables with providers and clients information.
• Created database objects -tables, indexes, views required for medical service providers and patients.
• Wrote stored procedures to manipulate tables with medical service providers and patients’ information.
• Created packages to manipulate providers’ claims - extracting XML files.
• Customized the application for around 20 clients.
• Provided production support to clients’ databases.
• Fixed different bugs and change requests from time to time.
• Executed EXPLAIN PLAN for SQL query optimization and tuning.
• Created Users\' Manual.

Environment: Oracle Database 11g, 10g R2, SQL including ANSI standard SQL, PL/SQL, Package, procedures, functions, triggers, cursors, Linux, Vista, TOAD.

Confidential,NY 1 yr

PL/SQL Developer

Confidential,is a Stock company that was incorporated in . It is a Fire & Casualty insurance company.

• Based on the existing design, developed company’s employees’ Advanced Loan Disbursement Systems (ALDS) to phase out existing non-computerized Loan Registers.
• Worked for development of company’s Claim Department dealing with Coverage, claims, payment, rejection, adjudication etc.
• Created/maintained Tables, indexes, Views and sequences required for new ALDS systems and others.
• Created input forms using Visual basic.
• Wrote stored procedures and functions to calculate according to business rules.
• Created packages to retrieve and store data for the input forms and batch processes.
• Created triggers to support transactions.
• Wrote ETL procedures to load previous disbursed loans into ALDS systems.
• Carried out a training of personnel to operate ALDS package.

Environment: Oracle Database 9i,10g R2, SQL including ANSI standard SQL, PL/SQL, Package, procedures, functions, triggers, cursors, Linux, TOAD, Microsoft Visio. Visual basic

Confidential, Valhalla, NY 7/ 1 yr

PL/SQL Developer

Confidential, is a global food and beverage company with brands that stand for quality and are respected household names—Pepsi-Cola, Lay\'s, Quaker Oats, Tropicana and Gatorade, to name but a few.

• Identified and gathered requirements.
• Interviewed data experts to find out what data exists and where it resides.
• Collected data existed mostly in the form of Excel Sheets and text files.
• Mapped the existing schema table columns with new schema table columns. To do this I had to design for split, merge, transform the existing database and load to the new database. To do this I created packages for the ETL.
• Created script for changes and assisted DBA to implement schema changes based on new requirements.
• Used external table and direct path load method to speed up ETL Procedures.
• Went through development, testing, QA, UAT and finally Production.

Environment: Oracle Database 9i,10g R2, SQL including ANSI standard SQL, PL/SQL, Package, procedures, functions, triggers, cursors, Linux, TOAD, Microsoft Visio. Visual basic

Confidential, Bangladesh 2 yr

Oracle Database Designer

Confidential,is a microcredit provider to the poorest women in Bangladesh. GB received the Nobel Peace Prize in 2006. It has 2,565 branches in Bangladesh. Total number of borrowers is 8.35 million.

• Involved in from turnkey solution to commissioning.
• .Carried out preliminary investigation with questionnaire on GrameenBank Loan Management Systems (GBLMS) to identify all existing systems and subsystems (input-processing- outputs)
• Prepared a questionnaire to capture information from GBLMS existing users.
• Determined requirements of new system, GrameenBanker
• Carried out economic, technical and operational feasibilities (low cost).
• Designed prototype GrameenBanker software based on one computer firstly (designed input required, output reports, file structure, Program designed (flow charts, programs using Oracle), data validation procedures using PL/SQL, time required for data entry).
• Installed GrameenBanker
• Created schema for GrameenBanker
• Developed front-end application using Oracle Forms 4.5 and Reports 2.5.
• Performed tests (using normal and abnormal data)
• Showed output reports
• Made GrameenBanker fully operational and commissioned

Environment: Oracle Database 9i, SQL, PL/SQL, Package, procedures, functions, triggers, cursors

Forms and Reports, Linux

Confidential, Bangladesh 1 yr+

Database Administrator, PL/SQL Developer

Confidential,Bangladesh provides land-line telephone services

• Studied existing manual systems, identified shortcomings, proposed for new computerized systems.
• Designed and documented system requirements for new proposed Telephone Billing Software.
• Designed database schema and created database objects.
• Installed oracle software and created database
• Installed and maintained Real Application Cluster (RAC)
• Connected client to database server through Oracle SQL* Net Services using local naming (tnsname.ora)
• Altered/dropped/switched/renamed/viewed schemas, different tablespaces/ undo tablespaces created/altered/dropped users’ privileges
• Created /altered/dropped tables, views, constraints, sequences
• Wrote procedures, functions, triggers, cursors and packages including providing access privileges for objects.
• Imported external flat files into database using oracle loader used troubleshooting tools to ping, tnsping, trace file and logfiles
• Executed system and SQL performance issues using statspack, explain plan, hints and indexes
• Used data moving utilities to export/import databases, schemas, tables, tablespaces
• Confirmed data protection against corruptions and data loss using Data Guard
• Took physical and logical backup
• Recovered data in case of data corruption.
• Performed testing, debugging and deployment in production.
• Rendered support services to the users.
• Environment: Linux, Oracle 9i, PL/SQL, Oracle Forms and Reports

Confidential, Bangladesh 1 yr+

DBA Support., Oracle Developer

Confidential,is a multinational second industrial gas British based company spread over six continents of the world. Bangladesh is one of these.

• Collected, analyzed and documented system requirement for BOC Location Management System - that maintains BOC depot location and their sales, customer, products, credit, collection activities.
• Designed Database with Oracle Designer 2000.
• Developed the system that maintains BOC offices at different locations.
• Performed Logical and physical Data Modeling.
• Developed front-end application using Oracle Forms 4.5 and Reports 2.5.
• Created PL/SQL procedures, functions and batch scripts.
• Altered/dropped tables, views, constraints, sequences.
• Created procedures, functions, triggers, cursors and packages
• Provided privileges for objects. imported external flat files into database using oracle loader used troubleshooting tools to ping, tnsping, trace file and logfiles executed system and SQL performance issues using statspack, explain plan, hints and indexes used data moving utilities to export/import databases, schemas, tables, tablespaces
• Took backup and restoring data
• Provided training to the users.

Environment: Red Hat Linux 9, Oracle 9i, PL/SQL, Forms and Reports