Data Architect, Oracle Application DBA,- 15 years of IT Experience

KAMAL ABDUL NAZAR.B

PLOT *&*, DOOR:B-F*, PARKVIEW APARTMENTS,

BHARATHI PARK STREET, BHARATHI NAGAR,

SELAIYUR, CHENNAI, TAMILNADU STATE,

INDIA. PIN CODE: 600073

Mobile: +91-978******* E-mail: ***************@*****.**.**

DATA ARCHITECT / SENIOR ORACLE TECHNICAL CONSULTANT

– ORACLE, PL/SQL , ETL-DATASTAGE

Experienced Data Architect with thorough knowledge of all design methodologies and in particular of OLTP Relational and Dimensional Data Modeling. Competent in all stages of the project lifecycle, from business analysis and data modeling to ETL architectures and analytic applications.

Can play one or more roles as Data Architect, Data Modeler, Oracle Database designer and Project Leader. Able to work as individual contributor in all aspects.

PROFESSIONAL PROFILE

After completing a Masters degree in Computer Applications (MCA) in Bharadidasan University, Tamilnadu state, India, worked for 15 years with companies including Cognizant, Renault-Nissan Technologies, Emirates Airlines-UAE, Dubai Port World-UAE and Ministry of Health-Oman. I am currently working at Renault-Nissan Technologies & Business India Private limited as Data Architect – Oracle DB solutions and worked in leading projects in a broad range of areas including complex international environments.

––

Developed a series of courses on Oracle , SQL & PL/SQL, IBM-Ascential Datastage DW design that constitute a compendium of the best methodologies, using case studies from own experience.

––

Good balance of technical and management skills, with proven ability to lead complex, globally distributed teams and deliver projects on time and on budget.

PERSONAL DETAILS

Nationality INDIAN

Spoken Languages Tamil (mother tongue), English (fluent)

EDUCATION

MCA Masters degree in Computer Applications – MCA, Bharathidasan University, April 1993

B.Sc – Physics Batchelor degree in Science – Bharathidasan University, April 1990

AREAS OF EXPERTISE – TECHNICAL

Oracle , PL/SQL • Expert in Database Architecture, Database Development, and Data Modelling.

• Wrote PL/SQL stored procedures and triggers to implement business requirements.

• Expert in PL/SQL, SQL and Oracle database development including stored procedures, database triggers and database packages.

• Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features..

• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.

• Made use of the REF CURSORS in stored procedures for report generation.

• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.

• Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers.

• Extensively worked with DML Triggers.

• Created UNIX shell scripts to invoke the SQL scripts which are run daily.

• Involved in creating stored procedures and packages with DYNAMIC SQL.

• Involved in writing complex SQL statements.

• Well versed in troubleshoot, optimize and improve existing database applications and database objects.

• Involved in analyzing the schema, so that the cost’s can be efficiently utilized by the optimizer.

• Involved in creating Schema comparison reports between Development, Integration and Production databases.

• Involved in creating user roles.

• Created database links to access data from remote databases.

• Well versed in Analyze, Design, develop, and implement database applications and database objects and writing/updating code documentation, implementation instructions and integration tests for applications. Produce technical documentation in accordance with SDLC guidelines.

Data Warehouse Design

• Solid experience and knowledge in ETL and Data warehousing concepts.

• Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)

• Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables

• Working as lead data modeler for Renault-Nissan's Data Warehousing applications such as RUBICS and CO2 developed in IBM-Datastage 8.0 to build dimensional star schema models that integrate their OLTP systems into a Data Warehouse of Data Marts to facilitate building integrated reports for Renault's clients.

• Has been teaching data warehouse design courses to many project teams.

• Architecture experience, job design knowledge and performance tuning experience on IBM Datastage 7.x / 8.x tool.

• Experienced to translate reporting and analytical needs into technical solutions

Data Modeling

• Experienced in Normalized Database Design and Modelling.(Logical and Physical design of database)

• Experience with data flow diagrams, data dictionary techniques, E-R modelling and design techniques, database normalization theory.

• Experience in physical and logical data modelling.

• Utilized Erwin Data Modeler and Erwin Model Manager to create document and publish the metadata, logical data models, physical models and first-cut physical design for database change requests. Used Erwin to forward and reverse engineer databases, complete compare designs and generate reports.

• Possess excellent technical and analytical skills with clear understanding of the difference in design goals of ER Modeling for OLTP and Dimension Modeling for OLAP.

• Experienced in Normalized Database Design and Modelling. (Logical and Physical design of database).

ETL- Datastage Extensive knowledge of ETL architectures and techniques, coming from hands-on experience in Renault ETL projects in IBM-Ascential Datastage 7.5 / 8.0

Oracle, Developer 2000 Extensively worked in Oracle Forms, Reports.

Operating Systems Has extensive knowledge of both Unix and Windows.

Unix/Linux Extensive usage on many different projects since 1994, including writing shell scripts for Oracle DMLs and Datastage job executions.

PROFESSIONAL EXPERIENCE SUMMARY

2008-Present Data Architect – OLTP/ DWH - OLAP

Architect / data modeller / DB Tech leader for primary organizations such as Renault-Nissan Technologies, Dubai Port World and Emirates Airlines.

• Managed database change requests for existing and new development for Oracle server databases. Worked with Subject Matter Experts, Business Analysts, DBA and application developers to ensure reliable database designs that met the business requirements.

• Working as lead data modeller for Renault-Nissan's Data Warehousing applications such as RUBICS and CO2 developed in IBM-Datastage 8.0 to build dimensional star schema models that integrate their OLTP systems into a Data Warehouse of Data Marts to facilitate building integrated reports for Renault's clients.

• Performed database capacity planning, sizing in terms of its physical data growth and scalability in terms of expansion of business scopes.

• Done extensive SQL and oracle instance performance tuning

• Facilitated JAD sessions Renault's business associates and with their supplier clients to capture business requirements for RUCBIS data warehousing project in order to design their conceptual and logical data modelling phases.

• Created and maintained the Data Administration Standard, Database Administration Procedure and Creating or Modifying Production Database Procedure documents.

1996-2007 Senior Software Engineer / Project Tech Leader (permanent employee)

Worked on many software projects as engineer, analyst and project leader with consulting and computer companies: Systems & Management (largest consulting companies such Cognizant Technology Solutions, Emirates Airlines, Dubai-Port world).

PROFESSIONAL EXPERIENCE

May '2008- At present Oracle, ETL Data Architect / Data modeller

Renault-Nissan Technologies Joint ventured collaboration of two automobile giants in Indian operations

Working as Data Architect for Renault-Nissan's Data Warehousing applications such as RUBICS and CO2 developed in IBM-Datastage 8.0 to build dimensional star schema models that integrate their OLTP systems into a Data Warehouse of Data Marts to facilitate building integrated reports for Renault's clients.

• Participated in creating customer interface documents for Requirements and Functional Specifications.

• Participated in mapping the incoming data from various sources to the appropriate database tables

• Participated in customer user acceptance testing and data validation.

• Created new database tables and changed existing tables in Oracle9i using Erwin to model and generate database SQL

• Created and updated ETL jobs using DataStage.

• Documented procedures to put the database and ETL changes into production.

• Updated the logical data model, modeled the physical database, created user requested views for reporting, and added indexes for performance

• Created SQL for new reports and views.

• Updated the logical data model, modeled the physical database, and created user requested views for reporting, and created database triggers and sequences in Erwin.

• Oracle database administration (application focus)

• Created the database in Oracle 10g/11g in development and test environments.

Software/Tools used: Oracle 10g/11g, PL/SQL, TOAD, IBM-Ascential Datastage 7.5 /8.0, ERWIN, MYSQL

Jun '2007- Apr '2008 Technical Consultant – Oracle, PL/SQL solutions

Dubai Port World –UAE Dubai Port Authority

Worked as Senior Oracle, PL/SQL tech lead and created a data interface has been done in CTMS using Oracle Advanced Queues to communicate and propagate the Vessel Voyage info and its Terminal Working Schedules info my means of Queue messages. Extensive design work done at both CTMS and Marine system to bridge this data interface, in order to transfer the Vessel voyages/ crane bookings/Terminal working schedules between CTMS and PROMIS system.

• Participated in creating customer interface documents for Requirements and Functional Specifications.

• Involved in Data Model, Database design, Derived Oracle Queues with its payload object types, involved in extensive PL/SQL coding and screen design in Oracle.

• Designed and constructed a PL/SQL application interface, including functions such as enhanced error handling, asynchronous message queuing, batch queuing of PL/SQL jobs, auditing, and more.

• Oracle database administration (application focus)

Software/Tools used: Oracle 9i, PL/SQL, TOAD

Feb '2006 – Apr' 2007 Oracle Technical Consultant

Emirates IT Group Emirates Airlines – UAE

Worked as Technical Consultant with Data Architect role for Emirates Airport's authority to handle DNATA/ EMIRATES-Resource Management System/ Flight Real Time Control system major enhancements for the following:-

• Identified data and business requirements discrepancies between the DN-RMS and EK-RMS and Ensemble databases and proposed resolutions to eliminate the discrepancies.

• Integration of RMS modules such as Plan Control, Real time control, Report Control and Roster control into one menu interface using VB 6 coding and achieved high security in terms of user’s access roles, availability of RTC processes and auditing of user’s GUI sessions and user’s right management. RTC- Tasks Statistics data collection.

• Extensively written PL/SQL packages for its batch processes.

• Writing UNIX and Oracle scripts for business needs, as needed. Perform SQL and PL/SQL custom coding and code troubleshooting when needed.

• Conducted training sessions for DNATA and EK Airport users of this system, wrote documentation, to utilize the modules in conjunction with various sub modules of the RTC system.

Software/Tools used: Oracle 9i , PL/SQL, Visual Basic 6.0, TOAD, ERWIN, CCC Harvest (version control tool), Hyperion reporting tool, Linux Shell scripting

Sep '2004- Jan '2006 Senior Software Engineer (Oracle Technical Consultant)

Ministry of Health , Oman

Worked for the Al-Shifa general stores and purchase order system development, to cater the purchase and indent procurement needs of various MOH’s institutions such as Hospitals/Health Centers/Clinics/Poly Clinics etc. This application contains two sub-systems with its screen wise business functions such as Purchase module (Demands, Request for Purchase, Tender/Quotation, Supplier's Quoted prices and Supplier's Items selection and Local Purchase Order) and Stores module (Item Master, Trade master, Staff Master, User Location, Indent, Receipt Voucher and Issue Voucher).

• Involved as Technical consultant for Purchase sub-system's screen design in Oracle – Developer 2000 (Forms & Reports).

• Deeply involved in writing the required PL/SQL packages for the all of the Store and Purchase modules.

• Reverse engineered the legacy Store's system (written in FoxPro) database to Oracle 9i and created all detail design document and the logical & physical database design documents for future enhancements.

• Written UNIX and oracle scripts for business needs, as needed. Perform SQL and PL/SQL custom coding and code troubleshooting when needed.

Software/Tools used: Oracle 8i/9i, PL/SQL, TOAD, ERWIN, CCC Harvest (version control tool), Hyperion reporting tool, Linux Shell scripting

Jun '2001 – Jan '2007 Technical Consultant (Oracle, Developer 2000, PL/SQL)

COGNIZANT TECHNOLOGY SOLUTIONS Worked as Technical Consultant from Cognizant for IMS- Health , London – UK

IMS Health-UK is basically a pharmacy data processing and providing genuine and accurate decision making capability to its clients around Europe

Worked for Falcon OLAP Cube production system conventionally written in Oracle, PL/SQL, and D2K to generate the OLAP cubes for IMS - Pharmacy/Sales territory related data.

Wrote Loader/Converter module to convert by means of Star schema as splitting the data by dimensions such as GEOGRAPHY, MEASURES, PRODUCT, PERIOD and FACTS by means of data marts especially usable for the concerned pharmacy client in a natural and well-understood way to organize multidimensional data in relational database.

• Worked as Cognizant’s consultant IMS Health – London Office, involved in Falcon Cube production application’s new modules analysis, requirements collection, data model, Logical and physical database design, Forms (Screen) development and coding , PL/SQL coding and production support.

• Had very good exposures to Production support, problem finding and bug fixing, learned a solid knowledge about MS OLAP multi-dimensional cubes generation.

• Creating Microsoft OLAP Cubes, Customer lists, User Lists, Road maps, Brick Maps which much usable for IMS Client’s representatives.

• Worked in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL).

Software/Tools used: Oracle 8i/9i, Developer 2000 (Forms & Reports), PL/SQL, TOAD, ERWIN and Linux Shell scripting

Nov '2000 – Apr '2001 Senior Software Engineer (Oracle, Developer 2000, PL/SQL)

COGNIZANT TECHNOLOGY SOLUTIONS Worked as Technical Consultant from Cognizant for Computer Sciences Corp, Luton – UK

Worked for British Home stores – Purchase and Stores system development activities supported by CSC-UK and it involved various modules like Contracts, Purchase orders, Items creation, Admin and many more as per the retail Line of Business.

Retek - This is basically a Retail Product used by British Home stores in UK. It is supported by CSC-UK and it involved various modules like Contracts, Purchase orders, Items creation, Admin and many more as per the retail Line of Business.

• Involved in ORACLE - DEVEOPER 2000 FORMS screen design, Construction, Reviews, Technical assistance to the team in "OPTION SETUP" Project.

• Worked as team player and involved in the bug fixing, application’s enhancement activities, PLSQL and Forms coding and application tuning and prepared MIS reports.

Software/Tools used: Oracle 8i/9i, Developer 2000 (Forms & Reports), PL/SQL, TOAD, ERWIN and Linux Shell scripting

Jun '2000 – Aug '2000 Software Engineer (Oracle Designer 2000, PL/SQL)

COGNIZANT TECHNOLOGY SOLUTIONS Worked as Technical Consultant from Cognizant for Automated Data Processing Services – San Dimas – CA, USA

Work has been assigned to evaluate the existing database objects and its metadata models such as its logical data model, Function hierarchy diagram, business process models and the data flow model in their new Oracle 8i database. Metadata has been migrated from Oracle Designer 6.0 version to 6i.

Software/Tools used: Oracle 8i/9i, Oracle Designer 2000, PL/SQL and TOAD

Dec '1999 – May '2000 Software Engineer (Oracle ,PL/SQL)

COGNIZANT TECHNOLOGY SOLUTIONS Worked for IMS- Health UK – XPONENT system

XPONENT is a new Pan-European Pharmacy data processing system. It is built to support doctor-linked prescription reporting business for all IMS - European countries. All data necessary for the required evaluations are collected from front-end systems and processed through the application to get the desired results. To enrich this general definition, an open data warehouse data model is provided as the centre of the application.

• The key role of this project involved in writing batch processes (PL/SQL packages), Module tuning and SQL statements tuning for the major modules such as doctor-linked, dispensed-product, prescription data and aggregated doctor information.

Software/Tools used: Oracle 8i/9i , Oracle Designer 2000, PL/SQL and TOAD

May '1999 – Nov '1999 Software Associate (Oracle ,PL/SQL, ERWIN)

COGNIZANT TECHNOLOGY SOLUTIONS Worked for AC-Nielson's Greece – House Hold Processing System

HHP System was reengineered from IBM-Mainframe to ORACLE 7.3, Visual FoxPro 5.0, AIX - UNIX- based solution for the following reasons:-

1. To provide a truly Client/Server architecture, 2. To enable processing of multiple clients /periods at the same time by enabling ORACLE Parallel Server option, 3. Enhance the efficiency of the existing system in certain critical areas identified by AC Nielsen Italy & Greece, 4.To provide flexibility in period processing, 5.To Standardize on the interface available between the different modules of the HHP system and adopting the Standard European Coding conventions.

• Involved in Logical Database Design, Physical Database Design, ORACLE Database designs, Instance set-up, instance tuning, Coding & Tuning of PL/SQL stored procedures, Database Administration & Support, Database related activities through out the development cycle and Software Configuration Management - Co-coordinator

May '1997 – Nov '1999 Software Associate (Oracle ,PL/SQL, ERWIN)

COGNIZANT TECHNOLOGY SOLUTIONS Worked for AC-Nielson's Italy – Trade*MIS

Trade*MIS was developed to enable the Client Trade division business of AC Nielson Research media to meet the evolving needs of their customers rapidly, supporting a wide range of high quality business information. The project involved re-engineering the Consolidation Engine segment of the Trade*MIS system from SAS to C-codes and to improve performance of the system.

• Involved as Application DBA, created conceptual, Logical data model using ERWIN data model tool.

• Created physical database Design, DDL scripts.

• Involved in extensive PL/SQL coding and performance tuning.

• Involved in SQL tuning, & Support for Database related activities through out the development cycle.

Contact this candidate