Sales Oracle

HASAN JAWAID www.linkedin.com/pub/hasan-jawaid/*/b31/a17

** ******* *** (C) 908-***-**** (H) 908-***-****

Bridgewater, NJ 08807 ***********@*****.***

SUMMARY

A versatile and respected Production and Development Data Base Administrator (DBA) with more than 10 years of experience in installing, managing and fine tuning databases (single instance, RAC, OLTP, OLAP) conforming to FDA and SOX requirements successfully. A strong team player with solid verbal, written and presentation skills which built effective partnerships with business users, senior management and other technical teams Rigorous planning and adherence to processes results in no unplanned downtime throughout the year. Diligently fine tunes transaction, data warehouse and RAC databases, ASM, queries, Linux/Unix operating system and LUN, resulting in improved performance and increased user satisfaction.

TECHNICAL SKILLS and TRAINING

Operating System: HP, RHEL, Sun OS, Windows, AIX

RDBMS: Oracle 11g, 10g, 9i, 8i. Oracle 11gR1/10g/9i/8i RAC/ASM/Data Guard

Software/Languages SQL, Pl/Sql, Packages, Triggers, Shell scripting

Utilities/Tools: RMAN, OEM, SQLBACKTRACK, Data Pump, Export/Import, Sqlloader, ERWIN, Quest (FogLight), sed, awk

Training: Oracle 11g New Features, Oracle 10g New Features, Oracle 10g Performance Tuning, Oracle 10g, Managing Terabyte Database, Backup and Recovery, Erwin

Additional: Advanced Systems Analysis (SDLC, RUP, SRS, Agile, EP), Project Management, Meeting / Training Facilitation

PROFESSIONAL EXPERIENCE

PFIZER PHARMACEUTICALS 2000 – Present

Senior Database Administrator

As a production DBA, provide database support and consulting to business application users. Support includes routine DBA tasks such as backup and recovery of full and partial databases using RMAN, performance tuning of OLTP and OLAP databases, SQL and PL/SQL code monitoring/investigating HP-UX/Linux environment/issues and shared database environments. Design star schema, fact, dimension and rollup/aggregate tables, materialized views, partition large tables, use Sql*loader and data pump to load data in the OLAP database. Install and configure oracle, RAC, data guard, RMAN, Sqlbacktrack, Erwin, Foglight, OEM.

BI activities:

• Design data warehouse

• Design dimension/fact/rollup/mapping tables

• Design Load interfaces

• Design Materialized views

• Help design load interfaces in pl/sql; sql loader

RAC related activities:

• Checking OCR for logical corruption

• Manual backup/restore of the OCR

• Checking cluster health

• Adding disk to diskgroups

• Rebalancing

• Applying patches

As an infrastructure DBA, provide detailed architecture, consulting, software engineering, implementation and support for end-to-end application/system design, conceptual and logical design of OLTP/OLAP databases, mapping tables and load interfaces, forward/reverse engineering, business continuity and disaster recovery planning and testing. Lead/participate enterprise projects, explore/investigate/recommend opportunities/areas of improvement, IT processes, change management.

Play a key role in the design, development and implementation of cost effective solutions across Pfizer, by collaborating with business users in identifying and improving business efficiencies through automation of manual activities. Led efforts in improving efficiency and effectiveness of many business applications which were critical to Pfizer operations. Provided high quality consultation to users and took full ownership of technical and non-technical issues. Engaged in project initiation, vendor selection, planning and architecture, including both logical and physical design of the database, as well as in integrating various components of the applications.

• Reduced weekly data loading duration from 12 hours to 2 hours for sales database.

• Increased database performance by 50% during peak business hours (8am – 11am).

• Implemented standards and improved overall productivity.

• Ensured prevention of data loss and disruption to service by implementing data guard and RAC.

HASAN JAWAID Page Two

Some of the impacted system are:

o Sales and Marketing online application generated daily sales information about consumer healthcare products, order and shipment status, product availability on the shelf and in the warehouse, sales promotion information and dates, etc.

o Sales and Marketing data warehouse application helped senior management in making forecasts and identifying trending sales information for managing appropriate levels of inventory. It connected with internal and external supply chain systems.

o Sales Volume Planning (Siebel 7.8) is a trade fund management application which works with Walmart, Walgreens, RiteAid and several major nationwide grocery stores and pharmacies. It provides a constant upstream and downstream flow of information about product sales, product promotion, rebates, amount paid and received with various internal and external systems.

Other Accomplishments

• Drove Enterprise Projects reducing costs and improving security, process robustness, process excellence and efficiencies in all areas of operations, e.g:

o Oracle Performance Tuning and Monitoring

o Oracle Backup Strategy, Disaster Recovery and Data Retention

o Oracle Patching and Configuration Management

MERRILL LYNCH 1997 – 2000

Database Administrator

• Maintained production, development, transactional and standby databases and data warehouses. Collaborated with different teams for setting up large databases. Performed backup, recovery and maintained standby database.

• Automated backup and monitoring jobs on autosys and provided technical assistance to junior DBAs. Performed database and sql tuning; assisted developers in writing efficient code in PL/SQL following oracle’s best practices.

• Planned, configured and deployed oracle parallel server using oracle 8.1.7 and Sun Operating system 2.7.

ORACLE CORPORATION 1996 - 1997

Senior Principal Consultant (DBA)

• Worked with clients and management in technical and consultation role;

• Identified oracle needs, proposed wide range of architectural solutions and assisted the implementation.

• Configured and deployed high availability technologies such as standby database, oracle replication and parallel server.

EDUCATION

BS, Electronics Engineering, Mechanical Engineering and Marketing, College of New Jersey

MS/MBA, Business Decision Making, New Jersey Institute of Technology, accumulating credits

Contact this candidate