Manager Oracle
Resume:
M U H A M M A D W A S E E M
Address
**** ******** ****, *********** ** L5A 4C4
Mobile
Home
******.******@*****.***
http://ca.linkedin.com/in/waseemharoon
P R O F I L E S U M M A R Y
15+ years of Information Systems experience bifurcating 2.5 years’ experience in Canada (Ontario Government), 8.5 years’ experience in UAE (Dubai and Abu Dhabi) and 3.5 years’ experience in Pakistan across a variety of industries like Transportation, Judiciary, Customs Administration, Aviation, and Textile Manufacturing wherein worked on different product lines, horizontal and vertical applications specially Public Sector, eServices, Call Center, Manufacturing, Supply Chain, Procurement, Finance, Accounts, HRMS, and Payroll. Worked in the capacity of Siebel Systems Administrator, Oracle Databases Administrator, Oracle Development Lead, Software Engineer, Senior Oracle Developer, and CRM Consultant.
Strong experience in Vendor Management while working in a multicultural environment with cross-organizational collaboration and Teamwork. Mostly worked from client side as a Technical Leader while assisting various MNCs and Siebel CRM vendors like Infosys Canada, Wipro, Capgemini, Speridian Technologies (United States), Hyperlink/HCL, Maverick Systems, Esquire Systems, Oracle Dubai, GTS, GTFS, Mind Tree, Info Gain, Info Vista and Oracle Advanced Customer Support Services (from Germany, France and Egypt).
In-depth knowledge of Offshore Development Model, Resource Management, Change Management, Vendor Management, IT Infrastructure Architecture and Support, Technical Leadership and Team Facilitation within a Multicultural environment.
Earned Bachelor’s degree in Computer Science and accomplished two major certifications: Siebel 8 Consultant Certified Expert and Oracle Certified Professional Database Administrator. Hands on experience in analysis, design, development, database administration, applications / systems administration, deployments, support and maintenance of various applications.
T E C H N I C A L S K I L L S & K E Y C O M P E T E N C I E S
Siebel CRM Applications Administration / Technical Architect (Highlights)
About 10 years of extensive experience in Siebel Systems Administration and Siebel Technical Architecture.
Experience includes planning, execution, building, pre-requisites, installation, configuration, maintenance, error diagnosis, troubleshooting, code migration, deployments and up-gradation.
Experienced in Siebel technical architecture analysis, capacity planning and sizing review of Large Siebel environments.
Handled Siebel Environments with 15+ Application Servers, Clustered Siebel Gateway and Load Balanced web servers.
Extensively worked on Siebel versions 8.0.0.x/8.1.1.x/8.2.2.x on HP-UX, IBM AIX, Linux and Windows Servers.
Expert in implementing internal & external SSO with MS Active Directory and Oracle Internet Directory on Linux Environment.
Successfully Upgraded Siebel versions from 8.0.0.0 to 8.0.0.5/8.0.0.11; 8.1.1.0 to 8.1.1.7/8.1.1.11 (Incremental Repository Merge); 8.2.2.0 to 8.2.2.4 (IRM - Incremental Repository Merge); Upgraded Siebel IP 2014 (8.1.1.14/8.2.2.14). Upgraded Siebel 8.2.2.4 to Siebel IP 2015.
Successfully Upgraded Siebel versions from 8.1.1.11 to IP 2016 (+IRM) for Ontario Ministry of Education (CSC).
Designed and deployed Siebel High Availability Architecture and Disaster Recovery Plan for Production Environments.
Strong knowledge of Siebel Architecture, worked on various Siebel Product lines specially Public Sector (High Interactivity), Call Center (High Interactivity) and Public Sector eService (Standard Interactivity).
Extensively worked on Siebel Performance Optimization, tuning and troubleshooting based on thorough Oracle DBA skills.
Installed, configured and extensively used Germain Monitoring Tool for Siebel CRM Applications in order to troubleshoot.
Planned and executed the release cycles by carrying out the deployments and migrations using SQLs, ADM and EIM.
Integrating Siebel Application with:
oOEDQ, OPA, Oracle BI Publisher 10g/11g
oININ (Interactive Intelligence) Customer Interaction Center® (CIC) for contact center automation.
oDocumentum 6.5/6.6, TIBCO using JMS Queues and Microsoft Exchange Server.
oMicrosoft Active Directory, Oracle Internet Directory (OID), and IBM LDAP server.
Strong technical skills with the ability to coordinate and manage Siebel Go-Live activities and release tasks with the assurance of comprehensive deployment plan and step-wise strategy. Expertise in configuring Siebel Open UI features.
Exposure of shell scripting to automate the admin tasks for Siebel Servers.
Proficient in Data Migration Activities, EIM scripts, Shell scripting and Batch Jobs.
Worked with Siebel Expert Services for the Performance and Tuning of Siebel applications and databases.
Conducting regular deployments of OPA and OEDQ.
Oracle Database Administration (Highlights)
More than 10 years of DBA experience including installation, configuration, administration, maintenance and support.
Oracle 8/8i/9i/10g/11g Databases on HP-UX, AIX, Linux, and Windows platforms.
Extensively worked as Siebel DBA including performance tuning, backup recovery, cloning and Character set migration.
Designing and managing Oracle Databases with High Availability architecture.
Experience with Data Guard / Standby DB, RAC, RMAN, ASM, OEM, Grid Control, Flashback, Database Vault, and HS.
Excellent Windows & UNIX shell scripting skills to automate application and database administration tasks.
Oracle Business Intelligence Enterprise Edition (Highlights)
About 10 years of OBIEE (BIP and Analytics) experience including installation, administration, maintenance, support and basic development.
Collaborated and used as a Reporting tool for Siebel CRM Applications.
Extensively worked and upgraded OBIEE/BIP 10g (10.1.3.4) to 11g (11.1.1.6/7) on HP-UX, IBM AIX, Linux and Windows.
Oracle Applications Designing & Development (Highlights)
More than 8 years of application designing and development experience.
Analysis, designing, coding, development, unit testing, implementation, deployment and support.
Oracle SQL (Advance SQL including DQL, DML, DDL, TCL, DCL), SQL Loader. Oracle Developer 6i/9i/10g.
Oracle PL/SQL (To create triggers, packages, procedures and functions using advance and up graded techniques).
E X P E R I E N C E
COMPANY NAME
DESIGNATION
ROLES
FROM
TO
Ontario Ministry of Education via Speridian
Sr. Siebel Administrator
Sr. Siebel Administrator
Oct-2017
Current
Ontario Ministry of Transportation
Siebel Middleware Specialist
Siebel Administrator
Sep-2015
Aug-2017
Emirate of Abu Dhabi Judicial Department
Siebel Systems Engineer
Siebel Technical Architect
Jul-2010
Jul-2015
Dubai Customs, Government of Dubai
Development DBA
Siebel Administrator, DBA
May-2008
Jun-2010
Emirates Airline via Bi-Tech International LLC
Software Engineer
IT/CRM Consultant, DBA
Apr-2007
Apr-2008
Lucky Tex (Karachi, Pakistan)
Senior Developer
Development Lead, DBA
Sep-2003
Apr-2007
A C A D E M I C Q U A L I F I C A T I O N
YEAR
TITLE
EXAMINATION BOARD / UNIVERSITY
1999
2001
Bachelor of Computer Science/Equivalency - WES Canada
Shah Abdul Latif University, Khairpur, Pakistan
1996
1998
Higher Secondary Certificate Examination
Board of Intermediate Education, Karachi, Pakistan
1994
1996
Secondary School Certificate Examination
Board of Secondary Education, Karachi, Pakistan
T R A I N I N G S & C E R T I F I C A T I O N S (T E C H N I C A L)
YEAR
CERTIFICATES / TRAININGS
CERTIFICATE AWARDING AUTHORITY
2010
2012
Siebel 8 Consultant Certified Expert
Pearson VUE / Oracle University Dubai, UAE.
2002
2003
Oracle 8i Certified Professional - DBA
Oracle Corporation, U.S.A.
2010
2010
Oracle Web Logic Server 9/10: Clustering & Administration
Oracle University - UAE Academy, Abu Dhabi
2013
2013
Oracle Business Intelligence (Repositories & UI Designing)
Oracle University - UAE Academy, Abu Dhabi
P E R S O N A L D E V E L O P M E N T C O U R C E S
YEAR
TRAINING TITLES
INSTITUTE
2010
2010
Self & Time Management
Global Union Training & Consulting, Dubai
2010
2010
Creative Problem Solving & Decision Making
Global Union Training & Consulting, Dubai
2010
2010
Effective Interpersonal & Communication Skills
Bright Vision Management Consultancies, Dubai
E X P E R I E N C E D E T A I L S
Employer
Ontario Ministry of Education (CSC) via Speridian Technologies
Designation
Sr. Siebel Administrator
Duration
October 2017 – Current
Type
Contract (Hourly)
Industry Type
Education – Ministry
Website
http://www.edu.gov.on.ca
Technology Used
Siebel 8.1.1.11 IP2013 (SIA) / IP2015 (SIA) / IP2016 (SIA), Oracle Database 12c, Oracle BI Publisher and Analytics 11g/12c, Oracle Fusion Middleware 12c, Oracle WebLogic 12c, Oracle Internet Directory 12c, Adobe Life Cycle
WebSphere Application Server, Microsoft Windows Server 2012 R2
Currently working as a team member of Speridian Technologies LLC. to work for Ontario Ministry of Education - CSC (I&IT Community & Services Cluster)’s Operations Team.
Project Name
App Object Managers
Version
Lang
Vendor
CMOD – Case Management On Demand
Public Sector & eService
Siebel IP 2013/2016
ENU/FRA
Speridian Technologies LLC.
ICMS – Integrated Case Management System
Public Sector & eService
Siebel IP 2015/2016
ENU/FRA
Speridian Technologies LLC.
Responsibilities:
Currently deputed to work with Ontario Ministry of Education (I&IT Community and Services Cluster) as Sr. Siebel Administration on a Solution Delivery Project to Upgrade Siebel Environments.
Upgrading the Siebel Environments for both CMOD (Case Management On Demand) and ICMS (Integrated Case Management System).
Upgrading CMOD Siebel Environments (DEV, SIT, UAT, PPE, PRODUCTION) from 8.1 to IP2016.
Upgrading ICMS Siebel Environments (DEV, SIT, UAT, PPE, PRODUCTION) from IP2015 to IP2016.
Business Applications includes:
oGlobal Experience Ontario (CMOD-GEO)
oLand Use Planning Information Network (CMOD-LUPIN)
oInvestigations and Enforcement Unit (CMOD-IEU)
oOntario Honours and Awards Secretariat (CMOD-OHAS)
oOntario Immigrant Nominee Program (CMOD-OINP)
oQualification and Registration Tracking System (CMOD-QUARTS)
oICMS Application
Siebel IP 2016 Upgrade Installation, configuration and Administration
Oracle BI Publisher 12c Installation, configuration and Administration
Configuring all the Business Applications on Siebel Platform.
Integration of Siebel Applications with OID, BI Publisher (SSO), Adobe Life Cycle, Java Applications deployed on WebSphere Application Server, CCPAY for Credit Card Payments, PCLookup for Postal Code Lookups, Go-Secure and ONe-Key.
Employer
Ontario Ministry of Transportation (MTO) – ON, Canada
Designation
Siebel Middleware Specialist
Duration
September 2015 – Current
Type
Contract (Hourly)
Industry Type
Transportation – Ministry
Website
http://www.mto.gov.on.ca
Technology Used
Siebel Version 8.x IP 2013/2015, Oracle Database 12c, IBM AIX, BI Publisher 11g, OEDQ, OPA.
Currently working as a team member of TECHNICAL SUPPORT OFFICE (TSO).
Project Name
Application Object Manager
Version
Lang
Vendors
Road User Safety Modernization Program (RUSMP)
Public Sector & eService
Siebel IP 2013/2015
ENU/FRA
Infosys Canada.
Registration and Licensing System of Ontario (RLSO)
Public Sector & eService
Siebel IP 2013/2015
ENU/FRA
Infosys Canada.
Responsibilities:
Installation, Configuration, Administration, Monitoring and Deployment of Siebel Applications developed for Carriers Registration.
Successfully Upgraded Siebel 8.2.2.4 to Siebel IP 2015. Now exploring, preparing and experiencing Siebel IP 2016 Upgrade.
Performance & Tuning of Siebel Applications & their Databases
Production (RLSO) Incidents Analysis & Troubleshooting
Attending Stabilization Calls and providing on-call technical analysis.
QA Support, Analysis & Troubleshooting
Conducting Package Review before the Code Drops
Siebel, OEDQ, OPA and BI Publisher Deployments; RCR Monitoring & Analysis
Data Migration through EIM scripts and Informatica.
Reviewed & Prepared Technical Documents and implemented Single Sign On, Go Secure and One-Key.
Administration, Configuration & Deployment of FSA and AA Applications built in-house for monitoring purposes.
Performing Sanity Testing after all the Deployments
Reviewing Operational Documents, Build Books and Run Books.
Employer
Emirate of Abu Dhabi Judicial Department – ADJD (Abu Dhabi, UAE)
Designation
Sr. Siebel Systems Engineer (Roles: Siebel Technical Architect / Sr. Oracle DBA)
Duration
July 2010 – Current
Type
Direct Contract (Full Time)
Industry Type
Judiciary
Website
http://www.adjd.gov.ae
Technology Used
Siebel 8.0.x/8.1.x/8.2.x, Oracle Database 10gR2, 11gR2, Windows Server 2003, 2008, HP-UX Itanium 11i (v11.23/v11.31) ia64, IBM AIX, Microsoft Visual Source Safe, OBIEE & BI Publisher 10g (10.1.3.4), 11g-11.1.1.6/7
Responsibilities:
Analyze, identify, define and design the Siebel infrastructure requirements based on Siebel standard architecture.
Responsible for installation, configuration, administration, up gradation, troubleshooting and deployment of below Siebel Projects.
Project Name
Application Object Manager
Version
Language
Vendors
Public Prosecution System (PPS)
Public Sector & eService
Siebel 8.1.1.7/11 SIA
ENU & ARA
Speridian, USA
Attestation System
Public Sector
Siebel 8.1.1.7/11 SIA
ENU & ARA
In-House
Notary Public System (NPS)
Public Sector & eServices
Siebel 8.0.0.0/11 SIA
ENU & ARA
In-House
Marriage Agreement System
Public Sector
Siebel 8.1.1.7/11 SIA
ENU & ARA
In-House
Embracing Islam
Public Sector
Siebel 8.1.1.7/11 SIA
ENU & ARA
In-House
Family Guidance
Public Sector
Siebel 8.1.1.7/11 SIA
ENU & ARA
In-House
CRM Project
Call Center
Siebel 8.2.2.0/4 SIA
ENU & ARA
In-House
Responsible for handling more than 4 Siebel environments for each above Siebel project which includes POC, Development, System Integration Testing (SIT), User Acceptance Test and Production.
Designed and implemented High Availability Architecture and Disaster Recovery Plans for Siebel Applications.
Configuring, managing and monitoring the Siebel server and its components. Also insuring that the Web Server, Gateway and Enterprise Servers are up and running. Upgraded Siebel Environments from 8.1.1 to 8.1.1.7 and from 8.0.0 to 8.0.0.11.
Assisting and coordinating with vendors (onsite and offshore development teams) with the best ideas of deploying solutions.
Compiling changed objects using Siebel Tools, applying and activating schema changes, exporting/importing Siebel Repository, applying DDL sync and pushing SRF into the requested environment along with browser scripts. Deploying BIP Reports along with Symbolic URLs. Using ADM as a best practice for master data migration.
Involved in applying governing methodology upon Siebel on-going projects and helping development team in organizing, collecting, and defining the deployment artifacts to have a comprehensive deployment plan document (DPD) along with defined rollback strategy. Upgraded Siebel 8.1.1.0 to 8.1.1.7/11; 8.2.2.0 to 8.2.2.4 (By using Incremental Repository Merge)
Perform code migrations and other infrastructure and deployment activities based on Deployment Plan Document.
Administration includes: Registering Siebel employees and mobile clients, generating new database, running DB extracts for remote client nodes, removing and re-generating the triggers and executing EIM jobs.
Deploying, publishing and activating Siebel workflows and creating workflow policies into the server.
Keeping an eye and resolving the performance issues of Siebel Applications and their Databases.
Debugging, Troubleshooting, and following-up with Oracle support to resolve Siebel and Database related issues.
Successfully configured Siebel Application Single Sign On (SSO) using Windows NT Domain Authentication for internal users.
Successfully configured Single-Sign-On (SSO) for external users coming through Portal without having any third party tool.
Successfully configured Dual Siebel Enterprises under one Siebel Gateway Server on HP UX Itanium .
Successfully Cloned Siebel Production Environment for UAT and Hot Fixing as well as Separated NPS Application from CMS Project.
Successfully Integrated Microsoft Visual Source Safe with Siebel tool to maintain the versioning of changed objects.
Successfully Installed Siebel 8.2.2 on Linux and Windows platforms.
Successfully Integrated Siebel Application with ININ (Interactive Intelligence) CIC for contact center automation.
Currently exploring and implementing Siebel Universal Customer Master (UCM).
Successfully installed and configured Oracle UCM and Enterprise Database Quality.
Started data cleansing using Oracle Enterprise Data Quality (EDQ) Tool and integrating the same with Siebel UCM.
Grasping the knowledge and understanding of UCM Data quality Manger, Survivorship rules and Data Model of Siebel UCM.
Exploring Siebel UCM, its Data model, UCM Functionalities like BDM, Conflicts, Suspects, D&B and its overall data processing.
Responsibilities as Database Administration:
Additionally, Responsible for the Administration, Configuration, Backup & Recover, Performance Tuning and Maintenance of Siebel Databases which includes POC, Development, SIT, User Acceptance Test (UAT) and Production environments.
PL/SQL Development:
Analyzed, designed, developed and implemented the solution for AMANAT’s e-Payment System in order to enable Credit Card payment option through Kiosk Machines. Technology used: Oracle SQL, PL/SQL, packages (functions and procedures), DQL, DML, DDL, TCL, DCL etc.
Employer
Dubai Customs – (Government of Dubai, UAE)
Designation
Sr. Development DBA (Roles: Siebel Admin, Oracle DBA)
Duration
May 2008 – Jun 2010
Employment Type
Permanent (Full Time)
Industry Type
Ports and Customs Administration
Website
http://www.dubaicustoms.ae
Technology Used
Siebel versions 8.0.0/8.0.0.5/8.0.0.8, Windows 2003 R2, HPUX Itanium 11i (v11.23/31), Oracle Database 10gR2, Actuate and BI Pusblisher10g as a Reporting Tool, Microsoft Visual Source Safe.
Responsibilities as Siebel Administrator: Recipient of "Certificate of Delivery Excellence" by Dubai Customs.
Analyzing the Siebel Infrastructure requirements, understanding the scope and feasibility, Producing infrastructure designs that meet Siebel standards and Business requirements.
Provide engineering leadership and oversight on infrastructure optimization and its deployment.
Responsible for the installation, configuration, administration, troubleshooting and deployment of below Siebel CRM based projects to carrying out all the administration and deployment activities at the enterprise level:
Project Name
Application Object Manager
Version
Language
Vendors
EEPG
Public Sector
Siebel SIA 8.0.0.5
ENU & ARA
Wipro
Case Management
Public Sector
Siebel SIA 8.0.0.5
ENU & ARA
Wipro
Collection & Collation (CNC)
Public Sector
Siebel SIA 8.0.0.8
ENU & ARA
HyperLink/HCL
Enterprise Client Registration (ECR)
Public Sector & eService
Siebel SIA 8.0.0.8
ENU & ARA
Wipro
New Risk Engine (NRE)
Public Sector
Siebel SIA 8.0.0.8
ENU & ARA
HyperLink/HCL
Post Audit Clearance (POA)
Public Sector
Siebel SIA 8.0.0.8
ENU & ARA
Capgemini
Responsible for more than 6 Siebel Environments for each above Siebel project which includes Interim-POC, Development, System Integration Testing (SIT), B2B, Training, User Acceptance Test and Production.
Single handedly Installed and configured 11 Node Siebel productions Environment with 4 Siebel Application Servers having native load balancing, Clustered the Siebel Gateway Servers and three Load balanced Siebel web servers including Apache Web Server 2.0.58 (32-bit) on HPUX Itanium. This includes English & Arabic language Packs.
Applied application upgrades and patches to existing Siebel Enterprises and SWSE.
Manage and monitor Siebel Components, and Siebel Tasks also insuring Web server, Gateway and Enterprise Servers are up and running. Installed & configured Actuate Report Server.
Providing support to Siebel Foundation and vendor’s onsite Development Team.
Implemented various phases of SDLC for RMP (Reform and Modernization Program) Projects.
Compiling configured objects using Siebel Tools. Applying and activating DLL changes.
Responsibilities include migrations and all the deployment tasks for Siebel projects.
Administration includes dedicated user creation of mobile clients, creating employees, Generate New Database and database extract after every buildup.
Used Siebel Application Deployment Manager as a best practice to insert required Master Data.
Raising and updating Service Request (SR) on Oracle Support and attending the web conference to resolve the issues.
Implemented SSO with Oracle HTTP server and OID on Linux Environment.
Responsibilities as Oracle DBA:
Responsible for Administration, installation, configuration, Backup & Recover, Performance Tuning and maintenance of Oracle Databases 10g on HPUX and SQL Server on MS SQL Server 2000 on Windows platform.
Installed and configured OBIEE, OWB, Oracle DB Vault Oracle Heterogeneous Services/Transparent Gateway, Implemented Oracle Data Guard and RAC.
Worked closely with Module Leads and Java Development Team to deliver Mirsal-2 Projects mainly DPP (Declaration Processing Project) and CPP (Client Profile Project).
Analyzed and evaluated the system requirements. Developed, produced, and maintained the structural design of application based upon the logical data models, business requirements and analysis.
Coordinated and aligned the systems with program objectives by focusing on programming aspect of DB design.
Coded, documented, and tested programs and resolved related problems.
Worked extensively on Oracle SQL (DML, DDL, DCL), PL/SQL (Triggers, Packages, Procedures and Functions).
Designed, implemented and evaluated database integration, data integrity, and security.
Recommended methods of improving the performance of long running queries.
Analyze and implement the approved requests for changing the design, data and DB objects.
Employer
BITECH INTERNATIONAL L.L.C (Dubai, UAE)
Designation
Sr. Software Engineer (Role at Client: IT Consultant)
Duration
April 2007 – April 2008
Employment Type
Permanent (Full Time)
Industry Type
Information System, Aviation
Client
Emirates Airline (Mercator) – Emirates Group IT
Websites
Employer: http://www.bitechme.ae
Client: http://www.theemiratesgroup.com
Technology Used
Oracle 10g Database on Red Hat Linux AS4, Oracle SQL/PLSQL, Oracle Developer 6i, VB/ASP.NET
Introduction to CRIS:
CRIS (Customer Relation Information System) is a CRM and Customer Loyalty Program of Emirates Airline that widely covers all the aspects of Customer Relationship including Customer Data Store, Tier Management, Mileage & Reward Points Accrual, Redemption, Customer Affairs and Service Audit (CASA), Partner Program, PNR (Passenger Name Record) Database, Bookings.
The application is also interfacing with external applications like reservations systems, Booking Engine, websites, computer-telephony integration (CTI) solutions and interactive voice response (IVR) systems.
The Skywards Loyalty Program of Emirates and Sri-Lankan Airline is actually based on CRIS Application which is now being marketed by Mercator (A subsidiary of Emirates Group) to other Airlines like Philippine Airlines, Kazakhstan Airline (Air Astana) & Etisalat (Non Airline) etc.
CRM Development:
Worked closely with Technical Lead, Project Controller and Product Manager.
Responsible for the enhancements and maintenance of the system.
Involved in all phases of Development life-cycle. Requirements Definition, GAP Analysis, Process Modeling, Data Modeling, Report Mapping, Application Configuration and System Testing.
Possess a solid track in analysis, design, coding, development, implementing, and support.
Grasping business domain knowledge, gathering the system requirements, understanding the legacy application by reviewing the business logic from PL/SQL packages, procedures, functions and triggers coded in Oracle Forms and convert the same into database stored procedures as a PL/SQL APIs to be called by ASP/VB .Net and its framework.
Creating System Requirement Specifications (SRS), Technical Design Document (TDD), Statement of Work (SOW), User Test Plans (UTP), Release Notes and Integration Testing documents.
Involved in estimation and planning.
Analyzing, designing, coding and debugging the application.
Worked on various CRIS projects like
oVersion 2A/2B Development and Enhancements
oAir Astana Implementation
oEtisalat Implementation
oWeb Services Development for EK IBE SME Booking Engine and CRIS Support
oCustomer Loyalty Program for SME (Small & Medium Enterprises)
oCorporate Enrolment
Debugging and closing the defects raised by BSG (Business Support Group) Team. Supervised UAT sign-offs.
Worked extensively on Oracle 9iR2 Databases using SQL, PL/SQL, Developer 2000 (Oracle Forms and Reports), AllFusion Harvest, Linux AS4, UNIX shell scripting, Java Stored Procedures, SQL Loader, MQ Series and Oracle Enterprise Manager (OEM) Console.
Created Java Stored Procedure to call UNIX/Windows Shell Scripts from Oracle PL/SQL program unit.
Supervised UAT sign-offs, involved in Implementations including Configuration management, etc
Responsible for the development and unit testing of application programs (interfaces conversions, reports, or workflows).
Developed UNIX shell scripts to upload & download data into/from Database using SQL Loader.
CRM Enhancements:
Successfully Enhanced CRIS/Skywards Application by adding Corporate Enrolment Functionality. The Project consists on Corporate Enrolment, Membership Requests, Membership Approval & Rejection, Members Linking & De-Linking, Corporate Cancellation and Monthly Process etc.
Database Administration:
Administered, Installed configured and maintained the databases on Windows and Linux platforms required for development and testing usage especially for Air Astana Project.
Employer
LUCKY TEX (Karachi, Pakistan)
DESIGNATION
Senior Developer (Role: Development Lead / Sr. Oracle DBA)
DURATION
September 2003 – April 2007
EMPLOYEE TYPE
Permanent (Full Time)
INDUSTRY TYPE
Textile Industry (Manufacturer & Exporters of Home Furnishing Textile)
WEBSITE
http://www.luckytexonline.com
ENVIRONMENT
Oracle 9i Database on Red Hat Linux AS4, Oracle Developer 2000 6i, Oracle Discoverer, FoxPro2.6.
Joined Lucky Tex as Junior Developer and was promoted to Senior Developer within 2.5 years with the additional responsibility of Oracle DBA.
Responsibilities as Development Lead:
Created project plans, schedules, and Business models, managed the team of developers.
Developed, implemented and improved the IT policies, guidelines, and procedures.
Worked closely with upper management to develop In-house Textile ERP System.
Responsible to work as Development Team Leader for ERP Modules mainly Manufacturing, Finance & Accounts and its integration with Procurement and HRMS/Payroll Modules.
Worked on various assigned tasks and in-house business applications like :
In-House Projects
Mobile Messaging System
Warp Online System
Computer Hardware Information System
User Authentication & Authorization Module
User Authentication & Authorization Module
Barcode Implementation
Oracle Database and non-Oracle Database Connectivity
MS ISA Server’s Log Monitoring Software
Conversion of Oracle RPTs into MS Excel
Extraction of Data from web pages to DB Tables
Direct Data Retrieval from Barcode Reader Machines
Job Application Data Bank
Loom Data System
Data Replication from OLTP Server to Web DB Server
Task Assignment System
Time Management Integration with Payroll/HRMS.
During the business analysis phase of ERP Modules, involved in collecting information, understanding the requirements, Identifying, drawing and documenting each business function, activity and transaction.
Analyzed system specifications and translated system requirements to task specifications for Junior Developers and provided technical support to them throughout the project lifecycle. Analyzed, designed, developed, coordinated and supervised the development of concerned ERP Modules to form a basis for the solution of information processing problems. Prepared user and technical support manuals, provided trainings to ERP end users. Beside ERP Modules worked as a SPOC for software like Microsoft VSS, Mailer Daemon and Microsoft Active Directory. Oversaw the web designing and development of both corporate & local-intranet websites. Analyzed, designed and developed Admin Site of LOCAL INTRANET website using Oracle Forms. Created stored procedures and functions to be called by ASP/PHP. During these projects worked extensively on Oracle 8,8i & 9iR2 Databases using SQL, PL/SQL, Oracle Developer 6i (Forms, Reports and Graphics), Oracle Enterprise Manager (OEM) Console.
Created Auto-Emailing (HTML+ Oracle) DB procedures for many modules to inform business users with their regular activities.
Responsibilities as Database Administration:
During the tenure accepted the additional responsibility of Oracle Database Administrator for which successfully performed all the relevant duties. Administered, Installed, configured and maintained databases on Windows and Linux platforms required for development, testing, education and production usage. Ensured maximum uptime of all the databases along with physical standby database server. Planed and
Contact this candidate