Project Manager

Khalid Soufny

**** ****** ***** **. *******, Florida 32832

Home: 407-***-**** Cell: 321-***-**** Email: *******@*******.***

AREAS OF EXPERTISE:

• Significant experience in Pharma Industry (FDA Compliance full

practice)

• Significant experience in data integration and merge of various data

sources

• PHI and HIPAA compliance

• Business Intelligence and data warehousing

• Project Management (Preparation for certification in progress)

• Mergers and acquisitions data integration

• IT Service Management and change Management

• B2B data exchange

• Manage relationships and contracts with IT Solutions and Services

providers

• Request for proposals for infrastructures and software packages

implementation

• Retail automation

• Databases architecture and design, Data Modeling

• Systems Analysis and Design (practiced full SDLC )

EXPERIENCE:

Curascript – Orlando (Florida) – (April 2008 - Now)

Scrum Master/Technical Team Lead - Pharma Analytics Group

Lead the Pharma BI and Analytics Group to support existing reporting

and deliver new reporting requirements to the Business and external

PHARMA Clients (Scheringplough, Pfizer, Novartis, Roche This

represents a multi-million source of revenue for Curascript.

Managed and lead a very successful delivery of the Wellpoint Single

System Data migration project as part of the acquisition of Precision

Rx Division of Wellpoint (very High Profile Project).

Designed and Developed an Operational Data Store which consolidate

patient assistance programs Data for Pharma Clients (DepuyMitek,

Genentech, Wyeth, ScheringPlough). This Data Store is used as a

reporting platform to build Business Objects Universes to provide

reports to Account Managers and Pharma Clients.

Reverse engineered and documented the ATLAS application (Mail

Order Pharmacy ) database for NGPR (Next Generation Reporting)

and Curascript PHARMACY ODS.

Wyndham Vacation Ownership Group – Orlando (Florida) – (August 2004 – April 2008)

Team Lead - Sr. Systems Software Engineer

Responsible for providing technical expertise in enterprise data

warehousing and business intelligence and reporting projects.

Special projects :

• Campaign Management Weekly Data incremental update and Quarterly Hygiene ( data

providers : Melley and Donnelley)

• CallCenter Dialer interface to Central Reservations System donotcall data

• SOX Compliance implementation

• Migration from Hyperion Performance Suite 6.5 to Hyperion

Performance Suite 8.3.2 SP4 and to HPS System 9

• Lead the upgrade from informatica PowerCenter 7.3.1 to

PowerCenter 8.3.1 for three thousands informatica workflows

Wyeth Canada Inc – Saint Laurent (Quebec) – (October 2000 – August 2004)

Sr. Project Leader

Responsible for coordinating the development efforts on the Oracle

technology infrastructure, Informatica data extraction tools and

Hyperion Performance Suite Reporting System for Montreal and

Markham locations on all business intelligence and data warehousing

projects.

Special projects :

Designed and developed datamarts for the followings KPIs using Informatica Power Center

(ETL) and Hyperion Performance Suite Reporting System (Reports):

• Adherence to schedule (Source: JDE Manufacturing)

• Vendor Performance Analysis (Source: JDE Manufacturing)

• Manufacturing Investigations Reports (Source: Trackwise) :

New MIRs, Investigations Completion, Line Clearance and Line Clearance

failures, Investigations Commitments, First Time Quality

• Work Order Follow-up (Source JD-Edwards AS400)

• Responsible for the administration and monitoring of the

development, test and production databases on an ongoing basis.

• Hyperion (Brio) Intelligence Suite Server Administrator

• Informatica Power Center 6.2.2 Server Administrator

• Installation and Validation of STARLIMS and Empower Application

Software

• LIMS and Empower Certified Administrator

• Upgrade of oracle database from 8.1.7 to 9.2 at the enterprise level

Oracle Corporation Montreal-Quebec. (October 1998 to October 2000)

Principal consultant

Provided technical expertise on oracle databases, duties include :

Data Base and SQL Performance tuning

Database engineering and design

Disaster recovery

Replication and standby database design and implementation

Oracle fail safe installation and configuration

Centrale Laitière (Milk Factory) Group ONA Casablanca, Morocco (February 1995 to July

1998)

Project Leader

I managed a project concerning the automation of the ‘MILK

PRODUCTION DIVISION’. The project consisted of the following

phases:

• Study and Analysis of the existing system.

• Define the new system’s requirements.

• Design a prototype of the new system.

• Validate the prototype with upper management and the concerned

business users.

• Programmed, tested and implemented the new system.

• Train the users and supervise a team of three analysts and two

programmers.

Uniconsult (Consulting Firm) Group ONA Casablanca, Morocco (October 1991 to

January 1995)

Senior Systems Analyst

Managed the delivery of a large scale retail automation project which

included software and infrastructure for network and hardware (servers, cash registers, electronic scales, barcode printers, hand held

portable inventory material) at two Retail stores ‘MARJANE RABAT

and MARJANE CASABLANCA’. The project consisted of the following

phases:

• Identify the specific requirements for the Business of Retail

Management;

• Prepare a Request For Proposal (RFP) document for the hardware

and software to be installed at the BACK-OFFICE and FRONT-

OFFICE (Cash Registers);

• Supervised the Installation of the network infrastructure

• Install and customize the software package GOLD-SHOP (Back-

Office) and FRONT-MANAGER (POS);

• Develop the interfaces between the back office and several other

components (bare coding printers, scales, inventory mobile

computers)

• Supervise a team of one analyst and two programmers.

WAFA SYSTEMES (Consulting Firm) Group WAFA BANK Casablanca, Maroc (December

1988 to October 1991)

Systems Analyst

I worked on a project concerning a conversion and deployment of a

Banking Information Systems package from NCR ITX material to a

UNIX system V environment using RM-COBOL. This system has been

implemented in several Banks in NORTH AFRICA.

EDUCATION: National University, San Diego, CA - School of Science and Engineering

Master of Science Software Engineering, June 1988 (GPA=3.75)

Bachelor of Science Computer Science, April 1987 (GPA=3.69)

TECHNICAL SUMMARY: SQL SERVER INTEGRATION SERVICES SSIS, Business Object,

Informatica, Hyperion Performance Suite, TomCat, PeopleSoft Financial, GOLD SHOP ( ERP Retail),

ORACLE V6, V7, V8i, V9i, V10g, V11i, SQLSERVER, DB2 and BD400, Oracle Enterprise Manager

2.0.4, Oracle Discover 3.1, Oracle Applications Server 4.0.8, Designer 2000, RPG 400, ‘C’, PRO*C, SQL,

PL/SQL, SQLOADER, COBOL, MSACCESS, ADA. HP UX 11, SUN SOLARIS UNIX 2.5, IBM

RS6000 AIX, COMPAQ DIGITALUNIX, WINDOWS NT, WINDOWS XP, WINDOWS 2000,

WINDOWS 2003, XPLANER, REMEDY, CVS, MERCURY QUALITY CENTER

Contact this candidate