Project Manager Supply Chain

Mohammad Mahboob Rahmani

Email: **********@*****.***

Accomplished individual with business, technical and functional retail

experience delivering custom I.T. solutions. Multiple years of leading executive

steering committee meetings, functional workshops, clarifying business

r equirements, performing gap analysis and w r iting functional requirements.

Verifiable track record of redesigning processes to improve productivity and

i ncrease RO I. Flexibility to adapt to given need. Experience being liaison

between user community and I.T. community. Solid vendor management

experience especially negotiations and setting fi rm expectations. Strong

i nterpersonal skills recognized by peers that translate into making them more

p roductive.

• Career highlighted by I T management and functional roles at industry

l eaders Cap Gemini E rnst & Young and Zale Corporation

• Managed I nitiatives ranging from $2M to $3M leveraging project

m anagement methodologies and proven best practices.

• Consistently improved business processes to increase revenue and reduce

costs.

Additional areas of expertise:

R etail I ndustry Experience Supply Chain Expertise (technical and functional)

R etail Analytics

P rocess improvement Solid Oracle Retail Foundation concepts

B usiness Development

Budget and cost planning P roject Management

T eam Development

Education

Master of Business Administration in Information Technology, University of Dallas at I rving.

A ugust 1997.

Bachelor of Business Administration in Management Information Systems, University of

Texas at Austin. May 1994.

Summa ry of Experience

Oracle Retail/Retek Experience of 10+ years

RMS (Retail Merchandising Suite) of more than 1.5 years ( interfaces integration and with

t hat saw functional areas as well)

Played a key role (both functional and technical) in RETEK upgrade implementation.

Functional/business process knowledge of RMS (RETEK) in particular i tem set-up, p ricing,

purchasing, inventory, stock ledger, replenishment and Allocation.

RPAS (Oracle Retail Predictive Application Server) experience of more than 1/2 a year where I

p rovided required data from other systems so RPAS had what it needed and create Purchase

O rders.

Ability to lead sessions, development workshop materials and understand and explain

application functionality.

Experience with Supply Chain in Retail for 10+ years

Business Analyst/Solution Architect for over 10+ years

Successful FLC Implementations (2 successful p rojects amounting to USD 3 million or so ).

W ith this led the 3 WMS implementations and integration with RETEK.

HEAD OF THE I.T. DEPARTMENT managing marketing and software development.

BUSINESS OBJECTS XI R2 (Data Warehouse – Business Intelligence) upgrade

i mplementation as a Project Manager.

Excellent in Relational Data modeling.

Expertise in Data warehouse implementation.

ARTHUR (Financial Planning) implementation as a Project Manager.

Oracle Utilities (SQL*Loader, Oracle Export/Import, Pre-Compiler Embedded SQL Pro*C/C+

+).

Development of complex stored procedures and t riggers (PL/SQL).

RDBMS Performance Tuning utilizing TKProf, SQL Analyzer, Explain Plan, and other SQL

t uning techniques.

Complex Oracle Reports 2.5/3/6i and Forms 4.5/5/6i development.

UNIX Korn Shell Scripting.

•

P rofessional Development / t raining

Oracle R12 Essentials Class for ERP implementers.

Enterprise DBA: Architecture and Administration

Performance Tuning

Certifications

Oracle Certified Professional – Database Administrator Track

Honors

Dean’s list, University of Texas at Austin

ROCK STARZ Award (Zale Corporation)

OTACE (On Time Above Client Expectation) Award from Cap Gemini Ernst & Young couple

years in a row.

Others

U.S. Citizen

Excellent communication and wri tten skills (English)

Has the background, discipline, commitment, problem solving, and can offer excellence in

subject expertise to accomplish an outstanding work and be a definite asset to any company.

Ability to assimilate new information, techniques, and processes into technical skills, and am

very comfortable in learning new concepts.

Self-motivated, Self-directed, Ability to work in fast-paced environment, Team Player.

P rofessional Experience

Head of Department (Marketing and Software Development).

Softnology Systems – Fort Lauderdale, Florida (December 2011 - P resent)

Reporting to CEO, brought on to enhance business development efforts and

m anage I.T. projects. Oversee all functions including business development,

m arketing, and software development.

Increased revenues of software development by 200% since joining.

Implemented project management methodologies to improve customer satisfaction

which ensured repeat business.

Planned and implemented company’s new website and major change in direction of

company’s focus. (WWW.SOFTNOLOGY.COM)

Transitioned firm to mobile development (android) and are close to having the fi rst

application available online.

Designed and provided blue prints to create company’s own products on SAAS basis

r unning on Cloud (www.SaaS-HRMS.com and www.Saas-I MS.com)

Envisioned and then deployed a B2C portal (WWW.SHOPWIDUS.COM) to allow web presence for

business that don’t have one now.

Became one of the very few companies in the world to have own products on SAAS basis in

t he market.

Consultant (ERP Support).

CSAPL (June 2011 – Nov 2011)

Reporting to CFO, recruited to develop processes to assist with the Month end

c losing issues.

Resolved issues related to Month end closing of Oracle ERP system.

Worked with users to implement/automate procedures to assist with their day to day

activities.

Implemented barcoding system to allow for faster t ransition in the manufacturing

p rocess.

Build KPI dashboards to give visibility to the management.

Lead Consultant (Retail Management System -- interfaces).

z ale corporation – i rving, Texas (September 2007 – May 2011)

Lead consultant, specializing in Oracle Retek (RMS) foundation concepts and

I nterfaces. Assigned to this task based on proven skills in analysis, business

u nderstanding and r apport with the user community.

Designed, coded, tested and Implemented the new Interfaces from RMS (RETEK) to/from

a ll the other systems such as the MOVE (Warehousing System) and Planning system

(RPAS)

Wrote, tested, and performed problem resolution on current programs and systems

d iscovered during the nightly batch process in accordance with established procedures

and specifications.

Supported the nightly batch cycle for RETEK and BUSINESS OBJECTS.

Designed new processes to help the customers/users do their job efficiently.

Build new reports and modify existing reports as per user requirement using the Oracle

Report Builder tool.

I.T. Manager (Business In telligence).

z ale corporation – i rving, Texas (September 2006 – July 2007)

Reporting to CIO, managed $2M budget and coordinated transition of the

existing Business Objects software from the obsolete versions to the new BOXI R2

version. Implementation was simultaneously done for 750 users including Head

office personnel and Regional managers on the road.

Successfully delivered the project on time and budget.

Implemented the Windows AD authentication for the fi rst time for Business Intelligence.

Managed 5 direct reports both functional and technical.

Successfully managed SLA’s (service level agreement) that were defined for the team.

M ade sure that all the Financial Corporate reporting was up on t ime.

Met User Managers to understand their requirements and streamline tasks for the team.

Brought enthusiasm and motivation to the team which was lacking in both areas.

Did bi-yearly reviews for all the team members.

Provided weekly status report of all the team activities, issues resolved to the Managing

D irector.

Planned next steps for the team to stay in line with the technology.

Senior System Analyst and Database Administrator

z ale corporation – i rving, Texas (October 2005 – August 2006)

Senior Systems Analyst, specializing in interviewing business and technical

leaders in the organizations to gather and clar ify business requirements.

A uthored functional requirements and led the development efforts.

Led three FLC implementations of MOVE (WMS).

Handled internal customers/ users calls and assure that all merchandise left the

warehouse on time for delivery at the stores.

Trained new team members to cover all the supply chain concepts and explain all the

technicalities for working on the team.

Designed new processes to help the customers/users do their job efficiently.

Designed new process for reporting total time for merchandise from entering the dock to

shipment to stores. This new process helped management identify lags in the process as

t his extra time was making the company lose money by holding inventory longer then

needed. Net effect of cost reduction of 20%.

Implemented the gold receiving system. This project was to ensure that all receiving of

Gold products is done in accordance to the Gold rate of when the invoice was cut rather

t hen when the PO was cut. Added alerts when the calculations did not meet the required

t hreshold. Resulted in slashing costs up to 30% specially during the gold f luctuation

t imes.

Proactively, wrote a lot of new processes to prevent failures such as:

Process to check the size available in some important directories ($outbound/

$inbound) and if the size is not enough, the primary point of contact will be paged to

t ake some actions and add more space before starting the load process.

Process to scan Oracle Instance Alerts on ORA-00600 which is an internal Oracle

p rocess failure and page the primary DBA when it occurred to fix the problem before the

i nstance shutdown.

Project Manager

Z ale Corporation -- i rving, Texas (September 2002 – October 2004)

Project Manager, reporting to Sr. VP of planning, successfully implemented the

$1.3 M il l ion upgrade for the Arthur Planning System on time and on budget.

Reported project’s progress to the Executive Steering committee on monthly

b asis. Very highly visible project as it related to the Merchandise and Financial

p lanning of the company.

Implemented on time and budget and was awarded ROCK STARZ award.

Upgrade included moving from ESSBASE and Windows NT system (a 2 tier architecture)

to ORACLE, Unix, and Windows NT system (a 3 tier architecture).

Kept the management up to date on the progress of the project via weekly status reports.

Managed JDA (Arthur Software’s vendor) resources while at Zale Corporation.

Took lead role as a main technical resource (expert) on the project.

Wrote lots of new procedures in PL/SQL to improve the t iming of the data loads. Reduce

t he load time 3 folds with the new procedures.

Senior Consultant -- Cap Gemini Ernst & Young dallas, Texas.

C lient: Zale Corporation (July 1996 – April 1997

A ugust 1997 - September 2002)

Senior Systems Analyst, specializing in Oracle database and RETEK

a pplication. Assigned to engagements based on skills in database, business

a nalysis, deep understanding of business processes and customer interaction.

Regarded as one of the top consultants from Cap Gemini E &Y.

PROJECT: Oracle Database and Oracle Developer upgrade for Retek

Converted all the RETEK forms and reports to the new version of Developer 2000 and

tested them. Also made sure that all the problems related to this are fixed and tested.

Assisted the DBA with database issues including importing the data from the existing

database (7.3.2 ) and importing the data into the new database (8.1.6).

Worked with the DBA in resolving the tuning issues with some scripts. Were able to gain

90% efficiency in some of the scripts i.e. before the upgrade the same script was taking 8

h rs to run and after the upgrade the script was running in 45 to 60 minutes. This was a

result of coming up with the strategy to create partitions on the tables (big ones) and also

r unning explain plans on the scripts to make sure the correct indexes are being utilized

Developed robust PL/SQL packages to enhance report development, interfaces, and to

reduce code redundancy.

Migrated Data using SQL* Loader

Scheduled jobs and wrote Shell scripts

Planned future requirement of the database

Created and configured database for development, staging and production environments

Received OTACE (On time above client expectation) award from the company for the work

on the upgrade.

PROJECT: Integration of new company systems into existing Retek

Responsible for analysis and requirements of the entire integration project.

Zale bought a Canadian Company and wanted to integrate Canadian based company’s

systems into current systems. The analysis involved not only integration requirements

but also multi currency issues.

Responsible for writing systems requirement documentation. Also developed Oracle

Forms screens for very complex procedures and tested them.

Created test cases for various process which included SKU Setup, Purchase Order setup,

P ricing.

Responsibility: Support analyst for Retek System

Responsible for providing maintenance and support for Retek system.

Responsible for meeting with users to derive new solutions to not only enhance the

f unctionality of the system but also help users in their day to day activities.

Responsible for supporting MACS system (Mail order catalog system writ ten in MPE

operating system), providing support and interacting with the vendor for problems.

Senior Consultant – Cap Gemini Ernst & Young. dallas, Texas.

C lient: Sabre Corporation (May 1997 – July 1997)

PROJECT: Y2K Project Auditor

Responsible for certifying all documentation of systems affected by using 2 digit year as it

related to the Y2K.

Responsible for meeting with the managers and users who prepared this documentation

and make sure that all audits are done correctly.

Created Audit checklists which was used by other auditors too to complete their tasks..

Senior Consultant – Cap Gemini Ernst & Young. dallas, Texas.

C lient: First Data Resources. (May 1995 – June 1996

PROJECT: Conversion of legacy system’s processes from mainframe to client/server.

Responsible for leading the Interface team which had the task of creating all interfaces

f rom mainframe to/from Client Server.

Responsible for gathering all the information from users and translating them into

business and technical requirements for users and the team.

Responsible for keeping management up to date on the status of the team.

Responsible for redesigning the Debit system for processing of all t ransactions coming

t hrough ATM. Streamlined the process so the response time was reduced from

u nacceptable times to acceptable times.

Contact this candidate