Oracle Manager
Resume:
IMRAN AHMED SIDDIQUI
Contact: Mobile:+92-333-******* Email:*********@*****.***
PROFILE SUMMARY
. Qualified, experienced and trained information technology
professional. 10+ years of full life-cycle development/implementation
and Database Administration experience building complex OLTP solutions
with Oracle technologies.
. Holding qualification of MBA-Management Information System and
Certification in Oracle DBA.
. Involved in all phases of full Development life-cycle. Requirements
Definition, GAP Analysis, Process Modeling, Data Modeling, Report
Mapping, Application Configuration, System Testing, Procedure
Development, User Training. Possess a solid track in design, analysis,
development, implementing, and support as well as leading and
motivating technical professional in order to achieve high levels of
performance.
. Involved in Full life-cycle implementation of Oracle E-business Suite
R12 - HRMS and Payroll Module (Core HR, Self Service (SSHR), OLM
(Including I-Learning), Oracle I-recruitment, Oracle Time and Labor
(OTL), and Payroll (including Fast Formulas)), Support for Complete
payroll cycle with Pay Processing, Retro Pay, Costing and Transfer to
GL
. Have good understanding of system development/implementation
methodology including Oracle AIM methodology and documentation.
Prepare BBD, BR100, TPD, Test Scripts, MD50 and MD70, User Manual etc.
Conduct CRP, SIT, UAT and user training sessions supplemented with AIM
documentation.
. Installing, Configuration and Administration of Oracle Database, Up-
gradation and Migration of Oracle Databases. Perform backup and
Recovery using User-Managed backup scripting, using RMAN and using
Export/Import and Data Pump.
QUALIFICATION
Masters of Business Administration (Management Information System)
1998
Newport University, Karachi Campus, Pakistan
Bachelor of Commerce, Karachi University, Pakistan
1994
Oracle Database 10g training from TECHNO-ED, Karachi, Pakistan
2013
RHEL Linux 5 Essential training from TECHNO-ED, Karachi, Pakistan
2012
RHEL Linux 5 System Administration training from TECHNO-ED, Karachi,
Pakistan 2012
RHEL Linux 5 Network Services and Security Administration training from
TECHNO-ED, Karachi, Pakistan 2013
Oracle ERP HRMS & Payroll Training, FocusThread Limited, United Kingdom
2010
Oracle Workflow Training, FocusThread Limited, United Kingdom
2010
Diploma in E-Commerce, Union College of Computer Science, Karachi, Pakistan
2000
Diploma in Computer Science (Software), PETROMAN, Karachi, Pakistan
1994
CERTIFICATION
. Oracle Certified Professional (OCP) Oracle10g DBA TRACK
2013
. Oracle Certified Professional (OCP) Oracle8 DBA TRACK
2003
. Brain Bench Certification in Oracle Database Administration (DBA)
2003
TECHNICAL SKILLS
Operating Systems RedHat Linux 4 & 5, Windows 9.x, 2000, NT4, XP, SCO UNIX V Rel
3.2 Ver 4.2, Novell NetWare
DBMS/RDBMS: Oracle 11g, 10g, 9i, 8i, 8, MS Access & FoxPro
Development Oracle Developer (10g & 6i), PL/SQL Developer, TOAD, PL/SQL,
Language/Tools SQL, SQL Plus, Packages, Procedures, Functions, Database
Triggers, SQL Loader, Import-Export, XML publisher, Oracle
Discoverer, Oracle Designer, Erwin etc
Other Components Workflows/Workflow Builder, AME, Oracle Alerts (ALR), Dynamic
triggers, Application Object Library (AOL/FND), Concurrent
Manager (CM), Fast Formulas, Oracle API's, UserHooks, WebAdi,
Task Flows, Forms Configurator & Custom Forms, Form
Personalization, FlexFields etc
Others MS Excel, MS Word, MS Power Point, MS Outlook, MS Project,
Visual Studio, etc
PROFESSIONAL EXPERIENCE
Technical Support Analyst
Oct 2012 - till dated
Ora-Tech Systems (Pvt.) Ltd., Karachi - Pakistan
Ora-Tech Systems has been partnered with Oracle Software Corporation since 1990,
and was the first ever partner in the region to attain Certified Advantage Partner
status. With over 18 years of experience on Oracle and an installation base of over
700+ local & international customers. My Responsibilities includes:
Perform analysis of database requirements, including configuration, system, and
scope of database. Design, review and modeling across platforms. Provide reliable,
innovative and cost effective IT solutions catering to the needs of individual,
small & medium size businesses and enterprise customers. Responsible for the
implementation, planning, configuration, installation and ongoing management of all
oracle databases.
Install and Configure Oracle Enterprise Linux 4 & 5 on enterprise servers
Install Oracle VM server and manager on linux and its configuration for
virtualization.
Install and configure Oracle Data Guard.
Install Oracle database version 8i, 9i, 10g and 11g on Windows, UNIX & Linux
platforms
Responsible for maintenance and support for company 24/7production database..
Perform physical database design at the object level, create DDL scripts, define
database snapshots, table partitions, and backup/recovery strategy for Oracle
10g/11g databases
Provide technical expertise in applications designing, such as in the creation and
tuning of queries, stored procedures, functions and database Triggers.
Perform and Monitor daily incremental and weekly backup using Oracle utility RMAN.
Oracle database tuning and administration including security management, instance
performance monitoring (TKPROF, AWR, ASH), table space utilization, schema object
management, database capacity planning, *bottlenecks* and *offensive* SQL activity
monitoring and resolution.
Perform and Monitor Daily and weekly full/incremental backup and Recovery using
RMAN and Data Pump, Also use Sql-Loader and External Tables for importing and
reading Data.
Migration of Database from old version to latest version.
Implementation of Oracle Data Guard (Physical/Logical/Active/Broker) Technology on
Windows and UNIX family.
Configuring Oracle Enterprise Manager Repository and recreation of Oracle
Enterprise Manager Repository.
Close interaction with Oracle Support to ensure system is running smoothly. Test,
Setup and Implements suggestions/recommendations by Oracle in Test, Development and
in Production environment.
Configure user quota, Group quota, File permissions, Group Permissions, User
permissions on Linux. Scheduling the auto backup tasks of Oracle database using
crontab and job Scheduler
Oracle E-Business Suite Techno-Functional
Aug 2008-Sep 2011
Oger AbuDhabi L.L.C. Abu Dhabi, UAE
Oger Abu Dhabi is a subsidiary of Saudi Oger, one of the largest
construction group in Middle East, Oger Abu Dhabi have projects running in
different cities of UAE.
. Involved in complete setup of HR & Payroll which includes setup of Key
Flex Fields, Descriptive Flex Fields, setting up business group,
Special Information Types, Location, Organization, Job, Position,
Grade, Grade Rate, People Group, Address, Payroll, Payment Method,
Element, Element Link, Global Values, Formula Results, User Define
Functions, Table Structure, Table Values, Oracle Menus, Security
Setup. Expertise in design and development of interface, custom
process, concurrent program, payroll calculation functions, fast
formulas, Alerts, AME, Workflow.
. Proficient in SQL and writing PL/SQL stored procedures and functions,
Procedures, packages, database triggers and SQL Loader scripts and
using Oracle standard APi's.
. Developed various custom functions which are used in the payroll
calculation, Creating & linking various earnings & deductions elements
& writing calculation rules using Oracle Fast Formula.
. Customizing the standard PTO accruals to meet business requirements
such as Leave Encashment, Promotions, and Carryover process.
. Support for Complete payroll cycle with Pay Processing, Advance Pay,
Proration, Retro Pay, Developed custom Costing process including
Project Costing and Transfer to GL.
. Prepare and Migrate Master Data and Transactional Data from legacy
systems into Oracle HRMS and Payroll using Data Load API's and Data
Loader.
. Developed different functional requirement and embedded them in API's
USERHOOK, also using Oracle Alerts, Dynamic Triggers and Task Flows
etc. Customized the standard Oracle Workflow process and as well as
creating new Workflows.
. Oracle Time and Labor (OTL) module implementation including
configuration, training and support.
. Oracle learning Management and I-Recruitment module implementation
including setup, training and support.
. Close interaction with Oracle Support to ensure system is running
smoothly. Test, Setup and Implements suggestions/recommendations by
Oracle in Test and in Production environment.
. Coordinate with Oracle DBA's & System administrators for resolving
internal technical issues.
. Design and develop the code for RICE components (Reports, Interfaces/
Implementation, Customization and Enhancements) as per the functional
requirement.
. Review functional design, create the technical specifications, develop
code, unit and integration testing and user acceptance testing. Train
applications users to ensure the correct and proper use of business
systems by conducting CRP, SIT, UAT and prepare the documentation and
user guides for the implemented solution. For e.g. BR100, MD050,
MD070, User Manual etc
Senior Software Engineer/Team Leader Feb 2006-July 2008
Mercator (Emirates Group) Dubai, UAE.
It's an IT Company of Emirates Group, developing and Supporting different
Software's for Airline and other Businesses, primarily for Emirates
Airline. Working as a contract Employee of Bitech International LLC. CRIS,
Customer Relationship Information System is an application designed to
support the skywards Frequent Flyer Programmed and Business Rewards. CRIS
Application is currently implemented in Emirates Airline, Srilankan
Airline, Philippine Airlines, Jet Airways, Kazakhstan Airline (Air Astana)
& Etisalat (Non Airline).
. Involved in Gap Analyzing, Designing and managing the team for
Development and Implementation of Customer Loyalty Programme for SME
(Small & medium Enterprises), also integrate it with CRIS, technology
used is Oracle 9i database and Dot Net Framework.
. Creating System Requirement Specifications (SRS), Technical Design
Document (TDD), Statement of Work (SOW), User Test plans (UTP) and
Integration Testing documents, involved in estimation and planning,
supervise UAT sign-offs, involved in Implementations including
Configuration management, preparing Release Notes etc
. Involved in converting the CRIS (Customer Relationship Information
System) Front-End from Developer6i to PL/SQL API's for Dot Net
Framework by gathering the requirements, getting the business
knowledge and understanding the current application. Where necessary,
responsible for the development and unit testing of application
programs (interfaces conversions, reports, or workflows).
. Additionally, working as a Configuration Analyst using All-Fusion
Harvest.
. Supporting Systems in Oracle Developer6i as a Front End and Oracle 9i
Database and Oracle Discoverer as a Reporting Tool and PL/SQL
Developer Tool
Software Developer/Analyst July 2004-Jan 2006
Emirates Transport Dubai, UAE.
. It's a Vehicle transportation and Vehicle maintenance corporation
owned by the federal government. Having more than 4500 employees and
branches all over the country.
. Involved in Migration Systems from Client/Server to Web Technology
(Developer10g).
. Involved in making the Systems Integration with each others, involve
in making Single Signing-On, involved in defining security standards
and forms standards, involved in Data collection and analysis, Data
Modeling and Logical and Physical Designing & Development.
. Design and Developed I.T Job Management System which give information
about the Development/Analyst Team, What are the job Completed, what
are the pending Jobs etc Coordinate and provide day to day Oracle
Applications techno-functional to end users while also providing end
user training as needed based on new solutions implemented
. Works with functional team to understand business requirements and
translates them into technical specifications. Where necessary,
responsible for the development and unit testing of application
programs (interfaces, conversions, reports, or workflows)
. Provide database technical expertise to applications, such as in the
creation and tuning of queries, stored procedures, functions and
database Triggers.
. Building and Managing Systems in Oracle Developer6i/10g as Front End
and Oracle 8i/9i as a backend Database and Oracle Designer 10g as a
Case Tool and Oracle Discoverer as a Reporting Tool, such as
Purchases, Human Resource & Payroll, I.T Job Management etc
Software Developer/Analyst April 2003-June 2004
SATAL Telecom Dubai, UAE.
. Involve in Analyzing, Developing, Managing, Implementing and Database
Administration.
. Data Collection and analysis, Data Modeling, Logical and Physical
Designing & Development.
. Work with end users to facilitate issue resolution, troubleshooting
functional application issues, developing creative solutions to
support the business needs.
. Building and Managing Systems in Oracle Developer6i as Front End and
Oracle 8i as a backend Database such as Financials, Inventory,
Purchases, Human Resource, Payroll, Fixed Assets, School Management
Systems. All modules are fully integrated
Team Leader / System Analyst Sept 2002-Feb 2003
Innoventure Pakistan Pvt Ltd, Karachi,
Pakistan
. Prepare I.T plans for development, enhancement, upgrade and support
activities.
. Involved in Analyzing, Designing, Development and Management of
Software as well as leading and motivating technical professional in
order to achieve high levels of performance.
. Develop and Implement policies and procedures throughout the software
development life cycle to maximize the efficiency, effectiveness and
overall quality of software products and information systems. Analyze
management and business requirement to support business activities.
. Build Systems in Oracle Developer6i as Front End and Oracle 8i as
backend Database such as Financials, Inventory, Purchases, Credit
Sales, Cash Sales, and Point of Sales, Restaurant Management. This
system performs all business functions in real time. All modules are
fully integrated and have consistent user interface. It is Multi
Company and Multi Currency
System Analyst / Team Leader Feb 2000-Aug 2002
Millennium Software Pvt Ltd, Karachi,
Pakistan
. Participate in all phases of project development. Working
independently on software development projects and as part of a team
with the added responsibility of assignment and allocation of tasks
to team members.
. Playing a key role in preparation of procedures, policies,
development methodology and standards for the I.T Department.
. Primary responsibility is to Analyze, Design, Develop and Implement
Software's. Implemented Software systems which are built on Windows NT
as an OS, Oracle 8i as a back-end and Oracle Developer6i as a front-
end, such as Financial Systems, Security Systems, Human Resource
Information Systems, Payrolls, Sales, Procurement, Inventory and Plant-
Engineering Systems
Programmer Oct 1996-Sep 1998
Alpha Insurance Company LTD, Karachi,
Pakistan
. Upgrade the Financial Accounting Package using Developer2000 (Forms
4.5, Report Writer 2.5) as a front-end and Oracle 7.3 for Workgroup
as a database under Windows NT Platform.
. Developed & Implement Financial Accounting Package, Medical Insurance
System and Fixed Assets Tracking System using Developer2000 (Forms
4.5, Report Writer 2.5) as a front-end and Oracle 7.3 for Workgroup
as a database under Windows NT Platform.
. Developed, Integrated Claims, Co-Insurance Module with Insurance
System, Upgraded different Forms-Reports in Forms 3.0, Report Writer
1.2, Menu 5 on Oracle 6 of Insurance System
Contact this candidate