Resume

Sign in

Data Manager

Location:
Milton, ON, Canada
Posted:
December 09, 2020

Contact this candidate

Resume:

NAUREEN ZAFAR AHMAD

**** ********* **, ******, *******. L9T 5Z4 Canada

Mobile: +1-647-***-****

Skype: naureen.zafar.ahmad

Email: adiivq@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/naureenzafarahmad

Profile

I am an ambitious Senior Business/Systems Analyst, EDW Architect, IT Project Management Professional and Senior Business Intelligence Consultant with over 20 years of diversified experience on Large Scale Implementation Projects.

I have been involved in preparing project documentation, designing, and development of IT Architecture, Integration with legacy applications, Modeling, Extraction, Authorization, Transportation, Trainings, and Development of dashboards & analytics.

I also carry Project Management and Team Management skills that include project management documentation, requirement-gathering skills, managing large-scale projects right from pre-sales presentation to writing technical proposal and project charters to carrying out implementation the project.

I have extensive subject matter expertise in IT Services Management (ITSM) and ITIL, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.

I also bring in the perspective and vision gained by the education in IT, Marketing and Business Management, having excellent interpersonal and communication skills.

Key Skills

Excellent in building client relationship

Strong in writing technical documents e.g., Data Warehouse Architecture, BI Audit Plans, BI Audit Reports, Functional & Technical Specs, Project Planning, Project Documentation, Requirement Gathering, KPI Analysis, GAP Analysis, Project Implementation, Quality Assurance & Testing, Training Plans

Solid in project management essentials of initiating, planning, executing, monitoring, and closing as well as processes, methodologies, tools, scope of management, budgeting, financial tracking, scheduling, resource management, solution identification and assessment, vendor selection, procurement, contract negotiations, and business case creation. Proficient in Waterfall, Agile, PMBOK, PMLC/ SDLC project management methodologies.

Good Knowledge of SAP HANA

Effective interpersonal, communication, analytical, technical and leadership skills

Proactive, self-motivated and a good team player

Ability to work under pressure

Quick learner, flexible and adaptable

Data Warehouse: Ralph Kimball’s Methodology

BI and Analytic Solutions: Business Objects (BO 5.0- SAP BO 4.1):SAP BO Business Intelligence Platform, SAP BO Web Intelligence, SAP BO Dashboards, SAP BO Analysis Edition for OLAP, SAP BO BI Launch pad, SAP BO BI workspaces, SAP BO Explorer, SAP Crystal Reports, Information Design Tool, Universe Design Tool, Lifecycle Management Console, Qlikview, Qliksense.

Database: Oracle 8, 8i, 9i, 10g, 11g. Sql Server.

ETL: SAP BO Data Services (BODS), SmartDB

Professional Summary

More than 20 years’ experience in full life cycle implementations, involved in all ASAP phases mainly in requirement gathering, workshops, designing, development, testing, training, transportation, go-live and post go-live support

Experience in leading BW team and BW projects for technical realization of BW/BO solutions

Experience in project management documentation mainly Project Planning, Project Documentation, Requirement Gathering, KPI Analysis, GAP Analysis, Project Implementation, Quality Assurance & Testing, Training Plans

Experience in creating ad hoc reports using Web Intelligence. Sound knowledge and expertise in creating dashboards using Dashboard Designer and Universes using Universe designer/Information Design Tool

Experience in setting up BO server, administration and integration with SSO services

Expertise in Data Modeling using Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models.

Strong Analytics/Data warehouse experience using SAP Business Objects Data Services. Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target. Strong experience in cleansing the data using Data Quality transforms. Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture. Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting. Data modelling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modelling, fact and dimension tables. Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.

Experience in creating views, tables, and data files in Oracle.

Involved in the post go-live support, which required performance tuning/optimization of the system using indices, remodelling etc.

Experience in implementing BO authorization using groups/roles and data level authorization

Good knowledge of ASAP methodology

Achievements

Implemented BI solution for SAP ECC & E&P Industry.

Data Warehouse project for E&P Aramco.

BANNER Student Registration System for group of Colleges

Hogatex Hotel Management Implementation for various reputable Hotels.

Professional Experience

Title

Company

Period

SAP Business Intelligence Specialist

Innomar Strategies

May 2019 – Jun 2020

Senior Systems Integrator

City of Toronto

Mar 2017 – Mar 2019

SAP Business Objects Consultant

TD Bank Group

Apr 2016 – Sep 2016

Manager, Technology Advisory

PWC

Jan 2015 – Dec 2015

Senior BI Consultant

Working Remotely for Xeca

Apr 2013 – Apr 2014

Senior BI Consultant/BI Team Lead

Xeca International for IT Co., Al-Khobar, KSA

May 2010 – Mar 2013

Business Objects Support Consultant

Saudi Aramco Expec via AlBilad Arabia, Dhahran, KSA

Jan 2008 – Dec 2009

IT Consultant

Saudi Business Machines, Al-Khobar, KSA

Oct 2006 – Dec 2007

Data Warehousing Consultant

Saudi ARAMCO, EDSD, Dhahran, KSA

Feb 2006 – Oct 2006

Corporate Solutions Manager

Al Mazroui & Partners LLC Abu Dhabi

Oct 2004 – Jan 2006

Freelance IT Consultant

UAE

Jul 2002 – May 2004

Systems Analyst / Project Coordinator

ADCO PDD/TSD Abu Dhabi

Feb 1998 – Jun 2002

Systems Analyst / Systems Developer

Higher Colleges of Technology, M.I.S Dept Abu Dhabi

Jul 1995 - Jan 1998

Systems Analyst / Systems Developer

EMITAC Abu Dhabi

Mar 1995 - Jun 1995

Software Engineer

Mideast Data Systems (Data General) Dubai & Abu Dhabi

May 1993 - Mar 1995

Project Details

Data Analyst / SAP Business Intelligence Specialist – Innomar Strategies. May 2019 – Jun 2020

Created System Design Specification Document based on the Business Requirements Document, which acted as a guideline for the Business Intelligence Project development.

Responsible for delivering BI solution for Financial KPI’s related to Clinics and Nursing. The data sources are related to Workday, T-rex, Scheduler, Master Data Services and home-grown solutions. IDT universe is created for this complex task, which includes some core universes in order not to duplicate the effort which has already been put in the core universes. The universe utilized quite some derived tables which utilized SQL CrossApply function which reduced ETL effort. Complex Web Intelligence (Webi) reports are developed including multi query approach in order to compare various contexts of the data for analysis. The reports have been extremely beneficial in Gap analysis in terms of knowing which nurses have capacity to take more appointments, Some other reports such as Multiple appointments at the same time slot helped in scheduling the same Nurse for multiple appointments, which lead to increasing the profit margins.

Senior Systems Integrator - SAP Business Intelligence, Enterprise Application Services

City of Toronto, TD West Tower, 200 Wellington Street West, 16th Floor, Toronto, ON, M5V 3C7

Responsibilities as Senior Systems Integrator SAP Enterprise Business Services

Mar 2018 – Mar 2019

Project Manager for Maintenance Release Cycles related to Business Intelligence, Facilities Maintenance and Real Estate modules. The tasks involved are defining scope, monitoring progress and ensuring the deployment is achieved in the allocated time.

Service Management process improvements utilizing HP Service Management and SAP Solution Manger tools, for centralized service intake for all SAP Applications used by 44 divisions of City of Toronto.

Involved in Solution Manager 7.2 functional specifications and upgrade.

Business Intelligence reporting (Webi) for statistics related to Solman Service Management.

Proving triage for all Solution Manager Service Requests / Incidents related to Business Intelligence.

Responsibilities as Technical Lead / Business Intelligence Analyst for Municipal Licensing & Standards (ML&S) Data Mart Project:

Mar 2017 – Mar 2018

Technical Lead for Municipal Licensing & Standards (ML&S) Data Mart Project, which has supervisory tasks related to team members as well as Technical Tasks such as Solution Architect, Data Modeller, hand-on developer.

Collaborating with Enterprise Business Intelligence Foundation Project in order to ascertain that the ML& S Data Mart project follows the City's BI methodology & framework.

Collaborate with City's SAP division in order to follow the technology, guidance that is in place for all SAP BI Projects.

Overseeing sustainment of ML&S DataMart Phase 1 sustainment project.

Responsible for planning & implementation of ML&S DataMart project. Worked with stakeholders in created the Business Requirements Document, translated the BRD into System Design Specification Document, which acted as a guideline for Development.

The project consisted of taking data from 3 data sources namely Licensing (home grown solution in Progress), IBMS (oracle), Chameleon (sql server). ETL via SAP Data Services (BODS), into BW on Hana database. Apart from that Vehicle for Hire data from Uber, Lyft etc. was also uploaded via Sap Data Services (BODS) into BW on Hana. Data formats included dealing with xml, json formats. Advanced DSO and composite providers were created in BW on Hana. Bex queries were created, which were consumed by WebI for various Ad-hoc reports, Analysis for OLAP to serve the self-service reporting needs of power users.

Conducted ETL Testing in terms of ensuring that extraction of data is done properly without missing out any data; Transformation phase also works successfully; In the loading stage, the data is loaded with no cut-off; All invalid data is rejected by the destination data warehouse; Replicate information is ignored. All this was achieved by creating sql scripts / reports against the source and target databased and doing the comparisons.

SAP Business Objects Consultant, Corporate Segment Technology Solutions (CSTS)

TD Bank Group, TD West Tower, 100 Wellington Street West, 2nd Floor, Toronto, ON, M5K 1A2

Apr 2016 – Sep 2016

Responsibilities:

Lead for SAP Business Objects Upgrade from BOBJ 4.1 SP5 Patch 5 to BOBJ 4.1 SP7 Patch 3 for all the BOBJ Clustered Environments on cloud & on premise.

Provide Solution Architecture and subject matter expertise to implement SAP Business Objects 4.1 as a reporting solution for the entire RISE Reporting program.

Provide experience in Data Modelling, Enterprise Infrastructure, Universes and Report development (Webi) to meet the Basel regulatory requirements for TD's Risk related reporting.

Experience with Data Services, Information Steward.

Manager, Technology Advisory

Information Management Business Intelligence Analytics

PricewaterhouseCoopers LLP http://www.pwc.com/ca/en/about-us/our-organization/office-location.html Jan 2015 – Dec 2015

Responsibilities:

Assisted in Business Development activities related to projects with respect to Business Intelligence.

Provided consultancy as a Solution Architect.

SAP Business Objects Infrastructure Setup, various Web Intelligence reports (Webi) on BW queries for Dominion Diamond Corporation. Underlying database was Sqlserver.

Designed and developed ETL routines in Business Objects Data Services (BODS), modified or created new Data Services jobs to meet project requirements. Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files.

POC implementations done using Lumira, SAP Design Studio.

Data Migration Audit for Trillium Health Partners.

Qlikview & Qliksense Agile Dashboards for various clients. Extracted data from various sources using Qlikview script editor, designed dashboards, and created various Qlikview solutions.

Qualtrics Survey development & results Dashboards for various surveys.

Dashboard development for ADP, Ontario Media Development Corporation.

Intermediate knowledge of Birst product suite, Cloud Solutions.

Client: Xenel Industrial Group, Jeddah, KSA http://www.xenel.com May 2010 – Mar 2013

Project Description: The XENEL Industrial Group (XIG) BI Project entailed a Functional Level Dashboard (Xcelsius) that provided XENEL Industries Group management easy access to the Data from XENEL constituent companies; Heavy Industries: Saudi Cable & Hidada. Petrochemicals: Alujain, Safra & NatPet. Technology: Xeca. FMCG Products Manufacturer: Zain.

Technical Environment: SAP ECC 6.0, SAP BW 7.3, BusinessObjects 4.0 suite including Web Intelligence (Webi), Dashboard, IDT and BO Mobile

Role: Senior SAP BOBJ Analyst/BI Team Lead (Full Implementation)

Company: Xeca International for IT. Co., Al-Khobar, KSA http://www.xenel.com/Home/Company/14

Responsibilities:

Led group discussions, conducted one to one interviews to elicit requirements from business unit teams and external/internal clients, and documented them in a Business Requirement Document (BRD). Created Systems Requirement Specification (SRS).

Led the project and team of 6 BI consultants for this large scale project

Allocated resources on different assignment according to their strengths

Conducted regular meetings with management and team for project status

Proposed technical solution for each individual Business Unit within this group project

Coordinated foundation of Business Warehouse by team members who implemented SAP BW

The infrastructure consisted of Oracle 10g Database.

Created Universes & canned ad-hoc reports using WebI for on-the-fly customizable analysis of data. Created dashboard layout and presented before management. Created fixed format Crystal Reports which were called from Xcelsius Dashboards for drill down analysis. Created SAP BO Explorer reports for search and exploration.

Utilized SAP BO Data Services (BODS) to extract data from excel, flat files, which was transformed & then loaded to the target tables. Various transformations such as lookup, join etc. were utilized in the workflows as needed.

Helped and supported team members on difficult situations

Trained junior resources and internees on BI platform

Gave final product demo of Xcelsius dashboard to higher management

Responsible for managing Data Centre and IT operations, in addition to capital budget preparation and oversight; IT disaster recovery; capacity planning and infrastructure; project management.

Client: Xenel Expansis, Jeddah, KSA http://www.xenel.com May 2010 – Mar 2013

Client Description: Expansis caters to the HR requirements of 6 companies (Natpet, XENEL, Safra, SCC, Hidada and Alujain) under the XENEL group umbrella. It centralizes the HR function of the group companies to provide a standardized approach to HR activities for the entire group.

Technical Environment: SAP ECC 6.0, SAP BW 7.3, BusinessObjects 4.0 suite including Web Intelligence (Webi), Xcelsius, IDT

Role: Senior SAP BOBJ Analyst/BI Team Lead (Full Implementation)

Company: Xeca International for IT. Co., Al-Khobar, KSA. http://www.xenel.com/Home/Company/14

Responsibilities:

The XENEL Industries HR BI Project comprised on the seamless integration between SAP ECC, SAP BW and SAP BusinessObjects

SAP and Non-SAP data from Natpet, XENEL, Safra and only Non-SAP data (in Excel format) from SCC, Hidada and Alujain.

SAP ECC: Created INFOSETS/INFOSET query in SAP ECC and connected to Crystal reports.

The non-SAP (Excel format) data was pulled, at regular intervals, to SAP Business Warehouse (BW).

SAP BW was used to Model and Load the Non SAP data (i.e. Excel Sheets) on scheduled intervals into SAP BW.

SAP BW carried out the Extraction, Transformation & Loading (ETL) process.

Crystal Reports was used to feed data into the Xcelsius using LiveOffice connection. Crystal Reports were based on ECC Tables / Infosets or BW Queries.

All the Xcelsius KPIs were created based on LiveOffice connection.

When user executed/refreshed the Xcelsius Dashboard, the LiveOffice refreshed the underlying Crystal Report which in turn requested fresh data from the underlying database thus forwarding the latest available data to the Dashboard.

Data Governance: Created data governance and privacy policies; Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing

Client: Saline Water Conversion Corporation (SWCC), Riyadh, KSA http://www.swcc.gov.sa/

Feb 2012 – Mar 2013

Client Description: Saline Water Conversion Corporation (SWCC) is the world’s largest water desalination corporation. With 27 desalination plants, over 5,000 kilometers of pipelines, over 9,500 employees and more than 21 billion US dollars in assets, SWCC generates desalinated potable water from the shores of the Arabian Gulf in the East and the Red Sea in the West

Technical Environment: Oracle EBS, INFOR, SAP BO 4.0 suite including Web Intelligence, Crystal Reports, Xcelsius Dashboard Designer and BO Mobile

Role: Project Manager

Company: Xeca International for IT. Co., Jeddah, KSA http://www.xenel.com/Home/Company/14

Responsibilities:

The aim of the project was to create the Corporate Performance Dashboard (Xcelsius) - system which monitors and measures the organization’s status from the perspective of Balance Scorecard.

Meeting with clients for their requirements, providing liaison between SAP KSA and client, prepared technical proposal, presented the technical proposal before business heads and explained the proposed solution

Kicked off the project, created the project documentation such as project plan, resource allocation plan, project charter, communication plan, issue escalation plan etc.

Gathered client’s requirements, corroborated in business blue print document

Created Universes to model data from various sources, which supplied data to Crystal Reports & Xcelsius Dashboards.

Daily status updates from BI team.

Resolved issues that could have resolved at my end. Escalated the severe issues to steering committee

Followed up issues resolution with Steering Committee

Client: Saudi Aramco Expec Jan 2008 – Dec 2009

Client Description: http://www.saudiaramco.com Officially the Saudi Arabian Oil Company', is a Saudi Arabian national oil and natural gas company based in Dhahran, Saudi Arabia. Saudi Aramco's value has been estimated at up to US$10 trillion in the Financial Times'', making it the world's most valuable company.

Technical Environment: Business Objects clustered installation

Role: Senior SAP Business Objects Support Consultant

Company: AlBilad Arabia, Dhahran, KSA http://www.albiladarabia.com/contactus.php

Responsibilities:

Providing Support, Trouble Shooting, Enhancing current setup related to Business Objects Enterprise R2 & 3.1 SP2, Crystal Reports XI R2 SP2 & 2008 V1 SP2, Web Intelligence & Xcelsuis.

Business Objects 3.1 SP2 is installed in a clustered mode on two Windows 2008 servers with Web Component Adapter installed on two Solaris 10 servers with Weblogic 10.3. The Weblogic 10.3 servers are running in active passive mode, being load balanced by Resonate.

Implemented AD Authentication with Kerberos along with Single Sign On via Vintella to Business Objects Enterprise.

Giving POC demonstrations on BOE, Universe Designer, Live Office, Query as a Web Service, Web Intelligence & Xcelsius.

Architected, managed, and implemented Disaster Recovery Test.

Client: Aramco, King Fahad University, Prince Muhammad University Oct 2006 – Dec 2007

Client Description: Leading Organizations in Saudi Arabia

Technical Environment: Diversified Landscape

Role: IT Consultant

Company: Saudi Business Machines, Al-Khobar, KSA http://www.sbm.com.sa/

Responsibilities:

Have been involved in preparing various Technical Solutions Proposals.

Proposal for Aramco’s Material Management Division to enable them to have a control on their Stocks at Hand, what needs to be procured from various suppliers, suppliers distribution schedule etc.,

Proposal for Implementing Business Intelligence & Data Warehousing System at King Fahd University of Petroleum & Mineral Sciences

Proposal for achieving NCAAA accreditation at Prince Mohammed University, as well as Developing & Implementing Balanced Scorecard.

Client: Saudi ARAMCO, EDSD, Dhahran, KSA Feb 2006 – Oct 2006

Technical Environment: IBM Servers running Oracle

Role: Data Warehousing Consultant

Company: Saudi Business Machines, Al-Khobar, KSA http://www.sbm.com.sa/

Responsibilities:

Prepared Data Warehousing Framework, Requirements Gathering & Dimensional Model for Prod/Inj Data Mart

Evaluated Bill Inmon’s & Ralph Kimball’s approaches & chose Kimball’s Business Dimensional Lifecycle methodology for preparing a framework document for Planning, Requirements Gathering, Implementation & Deployment phases.

Gathered requirements based on Interviews, studying analytic matrices & current reports.

Created matrix listing facts & dimensions

Implemented Dimensional Model for Production/Injection Data.

Client: Gasco, ADNOC, Abu Dhabi UAE Oct 2004 – Jan 2006

Client Description: Oil & Gas Sector clients in Abu Dhabi

Role: Senior BOBJ Analyst / Corporate Solutions Manager

Company: Al Mazroui & Partners LLC Abu Dhabi, UAE http://mazroui-it.com/

Responsibilities:

Responsible for Requirements Analysis, Technical Evaluation, POC’s & Implementation for Oil & Gas sector clients.

Following up on Leads, giving Technical Presentations, Requirements Analysis, proposing the right solution, carrying out Proof of Concept studies

Providing Training & Consultancy on Bobj tools such as CMS, Infoview, Universe Designer, Web Intelligence, Crystal Reports.

Powerful modeling of business processes and enterprise architectures & requirements-driven development of advanced systems and software using Telelogic.

Preparation of Tender specification documents. Negotiation on Service Level Agreement’s clauses with Clients.

BOBJ Analyst / Project Coordinator

ADCO PDD/TSD Abu Dhabi http://www.adco.ae Feb 1998 – Jun 2002

Responsibilities:

Oracle:

Created Procedures, Functions, Triggers & Views to implement Business Logic.

Implemented Oracle role based security, Performance Tuning & resolved Schema Inconsistencies related to Data integrity.

Installation & Configuration of Oracle Server & Tools.

Tuning & Troubleshooting the Database and the Application. Recognizing bottlenecks in the Architecture and specifying effective ways to overcome them.

Involved in Software evaluation such as Front End Tools, Reporting Tools etc.

Involved in planning future storage needs for all the Applications.

Training:

Provided training to technical staff in the following areas: Oracle, Unix, SmartDB, Business Objects, Microsoft Project, Excel etc.

Provided training on Applications used in TSD Department to end users such as: Finder, LogDB, Business Objects developed Universes & Reports

Provided Training on Data Model Specifications related to Oil & Gas Applications, Project Management Methodologies, Software Development Lifecycle, Data warehousing / Business Intelligence Methodologies.

Quality Assurance System:

Involved with Ernst & Young consultants in implementation of a practical and usable quality assurance system in DM-ITS that is supported by a performance measurement system – the so-called Performance Measured Quality System (PMQS).

Business Intelligence:

Business intelligence, integrated query & business analysis solutions.

Scenario: To satisfy the business Intelligence requirements of the E&P users from different disciplines such as Geologists, Reservoir Engineers, Petrophysists, Petroleum Engineers..Etc.

Duration: 2 yrs.

Role: Project Coordinator having a team of two designers.

H/W: Sun Enterprise 3000 (Solaris 2.6) (Mainframe)

S/W: Business Objects (5.0), Smart DB, Oracle Server 7. 3. X, Oracle Designer 6i, Microsoft Project.

Work Done: Conducted Feasibility Analysis, which consisted of studying legacy reports missing from the current system along with user requirement sessions per Data Class to understand the trends that power users look for. A pilot project was done to help in the estimation phase. Then created the project Plan to help in time scheduling, resource management & cost estimation tasks. The project consisted of 15 deliverables as per Data Class. User Acceptance & Feedback sessions followed the implementation of each deliverable. Supervised the design phase of each Universe (Meta Data Layer per Data Class). Incorporated Views / Aliases / Contexts based approach wherever deemed necessary in order to achieve the best performance. Incorporated Synonym based approach in order to achieve schema independent design. Ensured the classes and objects created followed the logical grouping as per User Requirements. Objects were classified as Measure (Semantically dynamic as they could be aggregated), Dimension or detail Objects. Created Hierarchies to help in Drill-down analysis. Quick User Guide, User Manual & System Manuals were created at the end of the project. Users were trained in their related discipline and training exercises created on the relevant Universes instead of utilizing the standard training provided by the vendor which was highly appreciated by the users. Central Repository held all Production Universes and Users were given access as per their requirement. Deployment consisted of two modes; the product was installed on the desktop as well as the web-based option.

ETL:

Scenario: Geologists, Reservoir Engineers & Petroleum Engineers were each having their own legacy database (on Ramis & Db2) and were recording the same even which had to be consolidated as one event & migrated to the Finder System.

S/W: Smart DB, Oracle SQl, PL/SQL, Forms 4.5, Reports 2.5

Reconciled & Integrated Data into Finder Data Model, sourced from legacy systems such as DB2 & Ramis. Data from complex formats was taken to a staging area so that it does not affect the production environment and time based data loading could be done on the production system. This involved rationalizing inconsistent data values, generating missing data values, correcting and validating erroneous data by reverting back to the Data Technicians, reformatting and normalizing the source data structure in the staging area to make it compatible to Finder data model. The task could be done in 1/10th of the time allocated due to utilizing the extraction, transformation & loading capabilities of SmartDB tool.

Finder Implementation:

Scenario: ADNOC, ADCO, ADMA-OPCO & ZADCO went for a joint implementation & chose FINDER E& P system provided by Geoquest (Schlumberger). The project consisted of consolidating the requirements of the above-mentioned companies.

Involved in providing Specifications related to Exploration & Production Data.

Involved in auditing the data migrated from the legacy systems by the vendor, beta testing the software as delivered by the client.

Implemented Oracle role based security, Performance Tuning & resolved Schema Inconsistencies related to Data integrity.

Implemented Geological Layer Hierarchy and bounding surface relationship for ADCO fields.

Provided user support related to Finder, LogDB, SmartMap, Cross Section, Trace Viewer etc.

Involved in De-Customization of Finder Data Model along with other OPCO’s by convincing Geoquest, Houston to incorporate local customizations in their future releases.

Other Tasks:

Implemented Unix Concurrent Usage & User Application Usage Utility using Unix Scripts.

Supervising Business Objects Designers, Geoquest Support Personnel & National graduates.

Involved in formulating Service Level Agreements with vendors, Technical Ladder for TSD, Training plans for national graduates.

Systems Analyst / Systems Developer Jul 1995 - Jan 1998

Higher Colleges of Technology, M.I.S Dept Abu Dhabi, UAE http://www.hct.ac.ae/

Responsibilities:

Banner Student Registration System:

Implemented Client Server based Banner Student Registration System used in HCT colleges all over UAE, which helped in centrally managing all Student Affairs and improved the overall efficiency of the organization apart from time & cost savings. This involved:

Client Server Application Development under Oracle 7.1 running under dual cluster Alpha/ OpenVMS V6.2 (Oracle running in parallel on both VAX nodes) (Mainframe) using Forms 4.0, Reports 2.0, Reports 2.5 & RPT communicating through Sql*Net for TCP/IP V2.0.

Analysis, Design, Development, Testing and Implementation of the required modules of a Student Registration System for the eight colleges.

Installation & Configuration of Oracle Server & Tools.

Implemented Database Cloning, utilizing the feature of Oracle to recreate a control file when no backup is available.

Training of Student Registration System staff at the Colleges.

Incorporated Reports execution in the form of Jobs Submission using Database Pipes, which allow sessions in the same Oracle instance to communicate with each other. Report jobs are submitted from the



Contact this candidate