SUMMARY:

• About 9 years of Information Systems experience bifurcating 3.5 years experience in Pakistan and 5.5 years experience in United Arab Emirates across a variety of industries like 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 CRM Application Administrator, Oracle Database Administrator, Development Lead, Software Engineer, Senior Developer, and CRM Consultant.
• Having vast experience to work in a Multicultural environment with cross organizational tactics. Mostly worked from client side as a client representative with various MNCs and Siebel CRM vendors.
• Having extensive hands on experience on analysis, design, development, database administration, application administration, system administration, deployments, support and maintenance of various applications.
• About 5 years of Siebel Administration experience including installation, configuration, maintenance and deployments.
• Handled Siebel Environments with more than 15 Application Servers, Clustered Gateway and Load Balanced web servers.
• Extensively worked on Siebel versions 8.0.x/8.1.x/8.2.2 on HP - UX B11.23/31(ia64), Windows 2003/2008 server platforms.
• S trong knowledge of Siebel Architecture, worked on various Siebel Product lines including Public Sector, Call Center, eServices.
• Designing managing and deploying Siebel High Availability Architecture.
• Designing managing and deploying Disaster Recovery Plan for Siebel CRM Applications.
• Extensively worked on Siebel Performance Optimization, tuning and troubleshooting based on thorough DBA skills.
• Executing the release cycles and carrying out migrations for DEV, SIT, UAT, training, and production environments.
• Expert in Implementing internal & external SSO with MS Active Directory, Oracle HTTP server and OID on Linux Environment.
• Integrating Siebel Application with:
• ININ (Interactive Intelligence) Customer Interaction Center® (CIC) for contact center automation.
• Oracle BI Publisher 10g/11g, Documentum 6.5/6.6, TIBCO using JMS Queues and Microsoft Exchange Server.
• Microsoft 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.
• Exposure of writing the scripts to automate the admin tasks for Siebel Servers. Proficient in Data Migration, EIM, and Jobs.
• More than 8 years of DBA experience including installation, configuration, administration, maintenance and support.
• Oracle 8/8i/9i/10g/11g Database on HP-UX B11.23/31(ia64), Linux, and Windows platforms.
• Extensively worked as Siebel DBA. Designing and managing Oracle Database High Availability architecture.
• Experience with Data Guard, RAC, RMAN, ASM, Standby DB, OEM, Grid Control, Flashback, Database Vault, and HS.
• Analysis, designing, coding, development, unit testing, implementation, deployment and support.
• Oracle SQL (Advance SQL including DQL, DML, DDL, TCL, DCL), SQL Loader.
• Oracle PL/SQL (To create triggers, packages, procedures and functions using advance and up graded techniques).
• Oracle Developer 2000 6i/9i/10g (Oracle Forms & Reports).
• About 3 years of OBIEE experience including installation, administration, maintenance, support and basic development.
• Extensively worked on OBIEE 10g (10.1.3.4) and 11g (11.1.1.6) on HP-UX & Windows environments.
• Excellent Windows & Unix shell scripting skills to automate application and database administration tasks.
• In-depth knowledge of Offshore Development Model, Resource Management, Change Management, Vendor Management, IT Infrastructure Architecture and Support, Technical Leadership and Team Facilitation within Multicultural environment.

PROFESSIONAL EXPERIENCE:

Confidential

Siebel System Administrator

IT ENVIRONMENT: Siebel 8.0.x/8.1.x/8.2.2, Oracle Database 10gR2, 11gR2, Windows Server 2003, 2008, HP-UX Itanium 11i (v11.23/v11.31) ia64, Microsoft Visual Source Safe, OBIEE & BI Publisher 10g (10.1.3.4), 11g (11.1.1.6).

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.

Application Object Manager

Confidential

Responsibilities:

• Responsible for handling more than 4 Siebel environments for each above Siebel project which includes POC, Development, System Integration Testing (SIT), and User Acceptance Test.
• 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.
• 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.
• Additionally, Responsible for the Administration, Management and Performance Tuning of Siebel Databases which includes POC, Development, SIT, and User Acceptance Test(UAT).
• 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.

Confidential

Siebel Administrator, DBA

IT ENVIRONMENT: Siebel version 8.0.0/8.0.0.5/8.0.0.8 , Windows 2003 R2, HPUX Itanium 11i (v11.23/31), Oracle Databases 10gR2, Actuate and BI Pusblisher10g as a Reporting Tool, Microsoft Visual Source Safe.

Responsibilities:

• 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:
• 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 includes 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.
• Responsible for Administration, installation, configuration 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.

Confidential

Software Engineer

ENVIRONMENT: Oracle 10g Database on Red Hat Linux AS4, Oracle SQL/PLSQL, Oracle Developer 6i, VB/ASP.NET

Responsibilities:

• 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
• Version 2A/2B Development and Enhancements
• Air Astana Implementation
• Etisalat Implementation
• Web Services Development for EK IBE SME Booking Engine and CRIS Support
• Customer Loyalty Program for SME (Small & Medium Enterprises)
• Corporate 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.
• Administered, Installed, configured and maintained the databases on Windows and Linux platforms required for development and testing usage specially for Air Astana Project.

Confidential

Senior Developer

ENVIRONMENT: Oracle 9i Database on Red Hat Linux AS4, Oracle Developer 2000 6i, Oracle Discoverer, FoxPro2.6.

Responsibilities:

• Created project plans, schedules, business models and 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 ProcurementandHRMS/Payroll Modules.
• Worked on various assigned tasks and in-house business applications like:
• 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.
• 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 implemented backup and recovery of Oracle Databases.
• Created shell scripts to schedule and automated online and offline backups.
• Created PL/SQL procedures to send regular backup status emails and mobile messages.
• Worked closely with the Database Developers to ensure adherence of the database guidelines, standards and procedures.
• Configured & managed Oracle Heterogeneous Services.
• Creating materialized views, database jobs, database links, permanent table spaces, temporary table spaces, undo table spaces, adding data-files, temporary tables, external tables, indexes, partition tables, PL/SQL API’s, external procedures, Java API’s etc.
• Creating and managing users, roles and granting their privileges.
• Optimized SQL queries for better performance.