KAMAL ABDUL NAZAR BASHEER AHAMED

Customer: Citibank - Customer Management, Consumer Technology
Projects: Customer Offer Palette System
Centralized Offer Palette (COP) maintains all the Customer Offers centrally and interacts with various customer touch-points to have continuous and consistent dialogue with the customers
COP system serves as the single Campaign and Offer Base for both Card as well as Banking systems. This is a strategic initiative to have single source base for both the systems. COP also supports the real time interface with various Touch Point systems and Cross Sell facility between Banking and Card products. In doing so, it allows Business Users across Citibank to introduce and deploy relevant marketing campaigns and offers at the right time for the right reasons based on customer contact history, personal profile and propensity without compromising Citibank’s standard guidelines and protocols.

Roles & Responsibilities includes:-
• Oracle Database Performance Tuning
• SQL and PLSQL Tuning
• Architecting Databases/Systems for High Performance
• Architecture Assessment for Performance
• Performance Engineering of Applications
• Application Workload Management
• Data Capacity Planning
• Oracle 11i E-Business Suite Performance Tuning
• Troubleshooting Performance Problems

Customer:
Excelacom develops product "Century" for various section of telecommunication(BSS) Domain. .It has the US Telecom giants like COMCAST Cables, Puertorico Telecom as his top Clients. Century product includes CUSTOMER management, Service Orchesterisation, product frame work, Inventory Management system, contract management and sales force automation.
Roles & Responsibilities:-
• Developing the Packages, Stored Procedures, functions and relevant Oracle Objects for the Product Development as per the Business Requirements.
• Developing the Complex Sql queries for the Product Development .
• Production Support from the Database side.
• Tuning the Sql queries and Oracle objects with the necessary indexes.
• Installing and deploying the product's Database for the product(century suite) demo to the new client.
• Creating, optimizing and presenting the Data Model.
• Sql support to java developers.
• Trouble-shoot performance issues and bugs within PL/SQL packages.
• Concentrated on optimizing tables to telecom clients and involved in design of the database
• Create and maintain schema for new architecture, modify the package for new design.
• Use oracle technology to improve performance like bulk collect, dbms jobs etc
• Re architecture the Data Model based on the Requirement change and to implement that in PL/SQL coding level.
• Perform POC to new and improve architecture by using recommended oracle functions.
• Understanding and Collecting Database Change Requirements directly from the Client via Direct Client Interaction.
• Importing and Exporting Oracle Dumps as per the Production needs.
• Writing and executing the Test Cases to Test the Oracle Objects.

Working as Database Architect - Oracle, PL/SQL for Client Network Services India Pvt Ltd E-Cams - MEDICIAD MANAGEMENT INFORMATION SYSTEM - Oracle Apps Financial Management sub-system for Department of Health and Mental Hygiene (DHMH), Meryland State- USA.

• Attending Business requirement meeting for MMIS- Finance sub-system with stack holders/ tech leads.
• Analysis and design of Data Model and DB design with business analyst and subject matter experts.
• Creating High level Design, Detail Design documents, Design Specifications for the enhanced functionality in Finance Module.
• Participate in code reviews and ensure the code written complies with the company standards and policies. Write PLSQL/SQL code to meet the requirements and maintain coding standards
• Working extensively for the following Oracle Financial sub-system’s modules :-
A/P Transaction creation, A/P Transaction for Triage Cash Receipt Refunds, A/P Transaction Creation for Gross Adjustments.
A/R Transaction Creation, A/R Transaction Creation for Gross Adjustments and Interest Debit Memo.
A/P A/R Netting Transactions
FMIS Payment Transaction Creation
Hold/Release Vendor
Hold/Release A/P Transactions
Cancel/Reissue Payments
Manage A/R Transaction
Triage Cash Receipts
Apply Cash Receipt to A/R in Financials
Unapply Cash Receipt from A/R in Financials
Issue Refund
Maintain Form 1099 Information
Generate Recipient EOB


Software/Tools used: Oracle 11g, PL/SQL, Oracle -SQL Developer tool, ERWIN, MYSQL

May '2008- June'2012 Renault-Nissan Technologies, Chennai, INDIA Architect - Oracle DB Solutions
Working as Senior Architect -Oracle, PL/SQL and ETL-Datastage Solutions, for Renault-Nissan's OLTP and OLAP applications developed in Oracle/PL/SQL/IBM-Datastage 8.0.
• 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.
• Contributed to Data Warehousing project by reviewing and approving conforming dimensions and fact tables.
• Conducted extensive training programs in Relational Database Design/ ETL- DW Concepts and IBM-Ascential Datastage courses for the application development teams.
Software/Tools used: Oracle 10g/11g, PL/SQL, TOAD, IBM-Ascential Datastage 7.5 /8.0, ERWIN, MYSQL

Jun '2007- Apr '2008 Dubai Port World - Dubai, United Arab Emirates (UAE) Senior Oracle Developer

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)
• Provided Data Definition Language (DDL) scripts, physical model diagrams and metadata documentation to DBAs, application developers and clients.
• Reviewed, modified and approved the logical data models (ERwin), physical database designs (DB2), and DDL scripts for all database change requests for multiple releases that impacted CTMS interface.
Software/Tools used: Oracle 9i, PL/SQL, TOAD

Feb '2006- Apr '2007 Emirates IT Group - Dubai, United Arab Emirates (UAE) IT-Consultant


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 Ministry of Health - Oman Senior Software Engineer


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

Mar '1997- Jun '2004 COGNIZANT TECHNOLOGY SOLUTIONS - CHENNAI, UK Software Associate


1. Worked as Technical Consultant from Cognizant Technology Solutions 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


2. Worked as Technical Consultant Technology Solutions 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

3. Worked as Technical Consultant from Cognizant Technology Solutions 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
4. Worked as Software Associate for IMS- Health, UK - XPONENT system from Cognizant Technology Solutions - Chennai, INDIA.

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
5. Worked as Software Associate for AC Nielson- Greece - House Hold Processing System from Cognizant Technology Solutions - Chennai, INDIA.

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
6. Worked as Software Associate for AC Nielson- Italy - Trade*MIS System from Cognizant Technology Solutions - Chennai, INDIA.
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.