Lead ERP Analyst

Mr. Safiul Iman SYED MUSTAFA

(Safi Mustafa)

Baltimore, Maryland

Skype ID- Safi_Iman

********@*****.***

www.linkedin.com/in/safi-mustafa

Cover Letter

I have about 16 years of PeopleSoft experience which includes consulting, a couple of installations and upgrades of PeopleSoft software applications such as application support, enterprise systems management, and system modifications and enhancements. I have done the full lifecycle of implementation processes including business requirement definition, design, testing, conversion, interfaces, reports development, and end-user training. Most of my experience comes from Public sector, Higher Education and some from the MNCs.

My Strengths

Experience – Accounts Payable (7.5, 8.2, 8.4, 8.9, 9.1 & 9.2), Purchase Orders (7.5, 8.2, 8.4, 8.9,9.1 &9.2), Commitment Control (8.4, 8.9,9.1 &9.2), General Ledger (8.4, 8.9, 9.1 & 9.2), Payroll Encumbrance (8.9), Time & Labor (8.9), Workforce management (8.9), Leave management (8.9 & 9.1), Campus Solution (8.2, 8.4, 8.9 & 9.0)

Strong Technical – PeopleTools (7.1, 8.42, 8.49, 8.50, 8.51 & 8.54) in PS Modules Financial, HRMS & Campus. Strong SQL Server 2005&2008 experience, Oracle Toad

Functional & Technical – Strong PeopleSoft Student Financial (8.2, 8.9 & 9.0)

Other Technical - MSDos files, UNIX, Java, CC++, HTML, Excel Macros, JavaScript, iScript, JCL and COBOL. Earlier experience in CodeWarrior, Palm OS, VC++, CDK 4.0. Recent Exposure in Eclipse, Android SDK, JQuery, ArcGIS, COMSOL and HTML5

Experience in all phases of the project life cycle (Fit-Gap analysis / Design / Upgrades /Testing / Implementation/ Post-Implementation Support). Exposure in Agile development methodology

Summary of Professional Experience (Recent first)

Coppin State University – March 2007- Current

Claremont Graduate University – Dec 2006 – Feb 2007

UMUC –College Park – Aug 2006 – Nov 2006

Keppel Shipyard, Singapore – Mar 2006 – May 2006

Singapore Polytechnic, Singapore – Mar 2005 – Feb 2006

Institute of Technical Education, Singapore – Nov 2004 – Jan 2005

IBM, India – June 2003 - Oct 2004

ASAP Info System (P) ltd – Jan 2002 – May 2003

Zero Wait Systems – Sep 2000 – Dec 2001

Education & Training

Currently pursuing MBA – UMUC

Masters of Accounting & Inf. Systems (UMUC -2015)

Masters of Science- Software Applications, Bharatiyar University India (2001-2003)

Bachelor of Arts- Psychology, Madras University, India (1991-1994)

Underwent corporate training in Data Warehousing, Informatica, Cognos at IBM, India

Underwent training in installation, configuration and customization of PeopleSoft 7.5 at ASAP Info system, Chennai, India

Underwent training in Client/Server applications, UNIX at Software Solutions Integrated Ltd

Vice-Captain – Soccer, Local Club in India. (1998 – 2002)

Done presentations in Alliance HEUG (2013, 2014) & Mid-Atlantic HEUG (2013)

Was a Reporting PAG member

Coppin State University – March 2007 – Present.

Role: Regular Exempt Staff

Duration: March 2007- till date..

Role: Lead ERP Analyst

Manager: Mr. Prasad Doddanna

Environment: PS Versions - (Campus Solutions – 8.9, 9.0 Financial - 8.9, 9.1 & 9.2 HCM - 9.0, 9.1) currently undergoing 9.2 upgrade

PeopleTools - 8.48, 8.50, 8.52 & 8.54 Database - SQL Server 2000, 2005, 2008 & 2014.

Software: People code, Java, XML, Fluid technology and HTML5.

Responsibility: Financials upgrade and production support, SF Functional and Technical Lead and some functional and backup support for HCM. Support third party software like OneCard, Library System, Housing, Heat and Parking.

Financial

Just upgraded Financials 9.1(8.52x) to 9.2(8.54)

Day to day production support activities in KK Ledgers, Vouchers, PO and GL

Created customized Budget page which reports on Departmental fiscal year budget with details to each transaction based on Account

Corrected the functionality of Quality PO against Service PO so that the encumbrances are liquidated correctly. This reduced a lot of work during PO rollover

Actuals/Budget reconciliation

Fit/ Gap and implemented Procurement Cards

Created customized P-Card transaction logs

Was instrumental in Implementing Asset Management

Introduced Receipts processing and three-way matching

Created SF refund processing file in Financial

Fiscal report on the student account based on all financial aid

Class cost analysis report

Customized Budget overview with Fluid and Pivot grid

9.2 Upgrade Team

Functionality SF

Identified that Coppin Tuition Calculation is not working based on the setup and fixed it by revamping the whole process

Convert existing reports to BI reports using Connected Query

Customized the Account Summary page in Student Self-service, inactivated the Tuition calculation at that level

Customized SF Bills, Dunning Letters, Collection process and Aging process to fit in Coppin’s need. Used XML Publisher along with Connected Query to achieve this. Directly dumped all these process in the Student Self Service to avoid the third parties. This saved time & money to Coppin

Corrected the Charge Priority and Payment priority mainly in context to Financial Aid

Corrected all the past accounts to either do a refund or a collection based on Coppin’s Policy

Streamlined all external posting like laptop charge, one card and health insurance waivers to post accurately in SF. Did queries to find out the miss-firing transaction on the line reversal

Revamped item type security and restricted group posting of financial aid on manual reversal and posting in SF

Created Queries to cross check the tuition posting for any given term. This checks whether all the students are charged and refunded correctly

Customized the AP refund process. Convert the SF data to fit the Financials AP process

Created query to cross check the SF Accounting transactions with Financial

Customized the 1098T report to align correct boxes and have queries cross checking the data generated

HRMS

Customized the Payroll Encumbrances for the HRMS 8.9

Customized the Leave Accrual process

Report on the Employee Liability to the University

Created a report to report the payroll to the respective managers/PIO in Department/Grants according to the tree structure

Created IB to transfer more sensible data to Financial for Payroll accounting

Technical

Experience in all PeopleTools, XML publisher, connected queries, complex PS Queries and third party reporting using SQL Server for departments like Nursing, Library, Parking, One Card, Housing and Academic Affairs.

Developed complex Excel sheet showing Pie charts, funnel reports and more using Macros through PS.

Population selections/update, Mass Assign/Release, Equation Engine and other tools used in Campus solutions.

Developed a financials budget page based on Pivot grid and Fluid to ease the budgetary concern.

Familiarity and limited development with iStrategy reports, ArcGIS systems and mobile development applications such as Eclipse, JQuery, Android SDK and HTML5.

Was involved in COMSOL Software development for one project for the Natural sciences department. The project is to develop a simulator to replicate the workings of a solar cell in an enhanced level.

Due to retention drop, there was an assessment done on the individual school’s performance in the university. The cost of class per student is measured against the revenue from that department and the schools are ranked accordingly. The school which performed the bad is given the priority on what is lacking and what needs to done to either recuperate or drop the school altogether. Student enrollment as a result of this exercise improved and the retention stabilized for the university. The whole process designed, was a collaboration process of the HR and the student records and I was one of the member in preparing the interface and technical aspect of it.

Project: Claremont Graduate University – Maintenance.

Employer: Saicon Consultants.

Client: CGU, Claremont, CA.

Duration: Dec 2006 – Feb 2007.

Role: Consultant – Individual. Manager: Mrs. Kymberlee Page.

Environment: PeopleSoft 8.1, SQL Server and Windows XP.

CGU had a need to fix some reports and had some configuration issues with Application server after tools upgrade. This contract was to fix some issues in Mass Change, develop new SQR reports, debug, develop AE processes and do set up in Academic Advisement related to academic requirement groups on grading schemes, grading basis, grade category and grade basis exception rule.

Responsibilities:

Setup & Configured the Academic Advisement module based on different grading basis, degree requirement and customization of academic program with non-degree requirement.

Developed new SQR reports on degree audit report based on student, student admission compares for different terms, checklist report for evaluation on different schools and communication process similar to letter generation for students

Developed new Application Engine program for xml flat file for third party on the current students, instructors, milestones and course for specified term.

Assisted with Designing several AE programs to improve throughput of Mass Changes for different school’s updates.

Project: University of Maryland College Park– Maintenance.

Employer: Saicon consultants.

Client: UMUC, College Park, MD.

Duration: Aug 2006 – Nov 2006.

Role: Consultant – Individual. Manager: Mrs. Lee Williams.

Environment: PeopleSoft Financial & Student Administration 8.9, Oracle & Windows XP.

UMUC or the University of Maryland University center has gone live on July 2005. The project scope included Functional Design and Development of fixes of PeopleSoft delivered processes.

Responsibilities:

Responsible for Design and development of reports in Financial Aid and some fixes in GL.

Customizing the calculation of eligibility of Pell Grants Award to GSA students based on COA.

Corrected the FA Accounting line rectification.

DRN number rectification on the Cashiering GL lines generation.

Changed the hard coded values to a setup table and realigned the whole GL line generating process.

Tested the Daily job routine to include the newly modified program.

Reports Development involved Perkins Entrance and Exit loan reporting procedure with setup done on item types for any run control page and used FTP option in reporting.

Reviewed and customized the App Messaging process of GL Cashiering to Finance for FA Accounting lines.

Project: Keppel Shipyard – Maintenance.

Employer: Keppel Shipyard.

Client: Keppel Shipyard, Singapore.

Duration: Mar 2006 – May 2006, Team Size – 5. Manager: Mrs. Jean Foo.

Environment: PeopleSoft HRMS 8.9, Oracle and Windows XP.

Keppel Shipyard is one of the leading pioneers in the ship repair/building industry employing about 10,000 employees. It has its main office in Singapore and business units in countries like Brazil, India, the Czech Republic, Vietnam, China and Hong Kong. Keppel has implemented PeopleSoft 8.8 Global Payroll, HRMS that caters for all the necessities of the HR Department.

Responsibilities:

Gathered Functional Requirements, Designed pages and links to custom pages for employee and manager self-service on e-Leave.

Designed & Customized Interfaces to the GL.

Designed and Developed CI for Salary Update in the JOB data based on the flat file feed.

Managed e-Leave system of Benefits Administration and various benefits plan involved for the employees of Keppel Shipyard.

Coordinated functional design and technical specification development.

Managed development of e-Leave, training and Administer Workforce in the HR activities.

Analysis and Preparation of Technical design documents for program enhancements/ development based on the functional design documents.

Designed and developed interfaces, reporting using Application Engines and SQR based on the specifications.

Workflow: Developed and modified workflows, in Manager Self-Service and HR Self-Service Modules, to generate work lists and send email to managers.

Designed customizations and interfaces for downstream and 3rd party systems using Application Engine.

Performed post-implementation production support.

Designed and Implemented PeopleSoft Security concepts such as row-level security for the auditors to run reports. Concepts involving new role users for level -4 report generation.

Worked with users to facilitate significant data clean-up effort.

Project: Singapore Polytechnic – Implementation.

Employer: Zenith InfoTech.

Client: Singapore Polytechnic, Singapore.

Duration: March 2005 – Feb 2006. Team Size- 7.

Role: Business Analyst. Manager: Mrs. Chang-tan Pek kin.

Environment: PeopleSoft 8.1 8.9, Oracle and Windows NT.

Singapore Polytechnic has implemented PeopleSoft v8.1 for its student administration services. It is a Singapore Government recognized polytechnic. Involved as a team member for development and is given the task of developing the module of ‘Alumni’ and maintenance of system varying from Cec (Compenant Education Center), Student Finance, Student Records, Admissions.

Understanding Client requirements and providing Technical Solutions.

Preparation & review of Test Plans related to the work product.

Preparation and review of Technical Documents and Customizations.

Application review with client and holding technical meeting.

Knowledge transfer to the client technical team.

Developed setup pages, processing, and reports for Alumni, Accreditation & CeC module.

Chatfield setup done for the new CeC module.

Maintenance of modules such as Student Records, Student Financial, Student Administration, ITP (Industrial Training Program), CeC (Continuing education center), Alumni, Accreditation.

Developed new pay template, net pay procedures for new fee payment method (SingPass) for the student financial.

Developed JPSAE Admission module of Singapore Polytechnic.

Processing functionality involves the data transfer from legacy system to PeopleSoft.

Reports are based on PS Query and SQRs.

Knowledge transfer to the Users on the developed CeC module.

SR activities with modules such as CEC (customized student records for continuing education), Admissions, Student Finance, Alumni and Accreditation.

Developed e-Payment facility called Flexi pay payment, which is introduced by Singapore Government for One Stop Bill Payment.

Development I-Scripts for transaction pages which connects to the vendor via https.

Developed Component Interface through I-scripts and workflow.

Worked with tools such as Excel macros and UNIX scripts.

UNIX batch runs with SA7 schedulers.

Project: PeopleSoft – Upgrade

Employer : Scandent Solutions.

Client: ITE, Singapore.

Duration: November 2004-Jan 2005. Team Size- 8.

Role: Team Member. Manager: Mr. Hoong Boon.

Environment: PeopleSoft Financials 8.8 (AP, PO GL), Oracle and Windows NT.

ITE is one of the reputed Technical institutes of Singapore with student strength of about 2,000-3,000. It has as many as 10 branches throughout Singapore and is recognized by the Government of Singapore. This project involved upgrading PeopleSoft from 7.2v to 8.8v.

As a Technical / Functional Business Analyst, was involved in the following activities:

Functional / Technical understanding of the client’s Business.

Functional specification and technical documents in the implementation of Enhancements & Fixes.

Documented, Designed and Developed customized error pages for user correction on the GL interfaces to PeopleSoft Financial.

Documented, Designed and Developed Enhancements and fixes in most of the modules in Requisitions and Purchasing.

Configured the Commitment Control module in setting Pre-encumbrance for Requisitions.

Ran batch processes using AutoSys for PeopleSoft on UNIX environment for client testing purposes.

Project: Sprint Outsourcing.

Employer: IBM Global Service.

Client: Sprint Telecom & Media, USA.

Duration: Feb 2004- Oct 2004.

Role: Team Member. Manager: Mr. Sandeep Halli.

Environment: PeopleSoft 8.4 Financial, Oracle, Mainframes and Windows NT.

Sprint Telecom is the second largest telecom and media company next only to AT&T in US. They have a 4-billion-dollar industry. The project involved production support for AP, AR, SCM, GL, Projects, Deduction Management and Budgets and some development work in areas relating to EPM.

Involved in application support activities like production support, working on project enhancements to fulfilling client’s requirements

Worked with Application Engine programs extensively to meet enhancement requirements. Involved in creating new Application Engine programs and migrating to the production environment

Created reports for Billing on Adhoc vendors (one-time)

Designed and Developed online pages for the errors triggered from the one-time payments for error correction by the users and resubmitting them for receivables

Customized AE which keeps tab on the under payments and generate workflow accordingly.

Developed Mappings in Informatica, ETL tool

Functional / Technical understanding of the client’s Business

Actively involved in Analysis, Specification Preparation, Coding and testing of the application

Fine tuning the N-vision reports and optimizing AEs performance

Detail designing of the technical documents on the basis of the functional documents

Worked on purchasing scorecards to evaluate the purchasing done for particular item

Debugged the payment predictor for specific vendor invoices in Receivables

Worked on the Informatica part of sprint setup in setting up the filter conditions for the existing FACT tables

Responsible for conducting intra-team sessions that included delivering training in certain areas such as warehousing

Project: Dow Jones Financial.

Employer: IBM Global Service.

Client : Dow Jones, USA.

Duration: June 2003- Jan 2004.

Role: Team Member. Manager: Mr. Kaushik Bhattacharya.

Environment: PeopleSoft 8.4 Financial (AP, GL, AM, PC), Oracle, UNIX and Windows NT.

Dow Jones & Company publishes the world’s most vital business and financial news and information. This project involved the Implementation of PeopleSoft 8.4 Financial, including Implementation of eProcurement, Accounts Payables, General Ledger, Asset Management and Project Costing. This Project used interfaces to populate data into the PeopleSoft Tree Structure for EPM to retrieve and generate reports. Cognos was used here for report printing.

Responsibilities:

As a Techno / Functional Business Analyst, was involved in the following activities.

Functional / Technical understanding of the client’s Business.

Actively involved in Analysis, Specification Preparation, Coding and testing of the application and incorporated reports using SQR.

Preparing and reviewing Test plans and Test results.

Design and development of Interfaces using Application Engine.

Project: STOCK MANAGEMENT AND DISTRIBUTION SYSTEM

Employer: ASAP Info System (p) ltd.

Client: ParkView Health System, USA.

Duration: Aug 2002 – May- 2003

Role: Team Member.

Environment: PeopleSoft Financial & HRMS v8.4, UNIX, Windows NT, SQR.

This is a leading Health Care System in the U.S. It is a surgical equipment-outsourcing firm delivering a complete range of sophisticated equipment to major hospitals. The system keeps the track of its equipment until the final delivery to the client.

Responsibilities:

As a Systems Analyst, was involved in the following activities.

Functional / Technical understanding of the client’s Business.

Actively involved in Analysis, Specification Preparation, Coding and testing of the application.

Customizing the Re-Hire Page for the specific BU.

Preparing and reviewing Test plans and Test results.

Design and development of Interfaces using Application Engine.

Incorporated reports using SQR.

Designed and Developed applications in Handheld Devices for Distribution and Purchasing Modules using Palm Applications.

Project: Recruitment & Retaining.

Client: In-House Project. (ASAP Info Systems (P) Ltd). Chennai.

Duration/Size: Jan 2002 – Jul 2002.

Role: Team Member.

Environment: PeopleSoft HRMS/Financial v7.5, Windows NT, SQR.

This was an In-House project for one of the upcoming software Organizations. It is a global outsourcing firm delivering a complete range of packaged solutions worldwide. The company has an annual growth rate of over 150% and is thriving as one of the upcoming software solution firms.

Responsibilities:

As a Techno / Functional Consultant, was involved in the following activities.

Functional / Technical understanding of the client’s Business.

Actively involved in Analysis, Specification Preparation, Coding and testing of the application.

Preparing and reviewing Test plans and Test results.

Generation of Form Letters, call letters, offer, Appointment Letters, ID Cards etc. through PeopleSoft Applications.

Customized panels for the Hiring, Rehiring procedures of the company.

Design and development of Interfaces using Application Engine.

Incorporated reports using SQR.

Non-PeopleSoft Work Experience

Product Bill Data flow and Accounting Process (PDAP) (Sep 2001-Dec 2001).

PalmMediRef 1.0 (May 2001-Aug 2001).

Tata-AIG insurance -Calculator. (Jan 2001 – Apr 2001)

Singapore E-B. (Jan 2001 –Apr 2001)

L&T –Material Listing. (Jan 2001 – Apr 2001)

Project: Product Bill Data flow and Accounting Process (PDAP) (Sep 2001-Dec 2001).

Employer: ZeroWait Systems.

Client: Hebatco Foods Pvt. Ltd., Kuwait.

Duration: (Sep 2000-Dec 2000), Team Size – 3 Members.

Role: Team Member.

Environment: Palm OS Visor, CodeWarrior & CDK 4.0.

Hebatco Foods is the leading supermarket in the Middle East. This chain-of-stores has many branches in almost all of Middle East and some in Southern Europe. The flow involves maintaining a link between ordering, delivery, invoicing and billing with the client/customer and specified concern. The dealings are maintained on the desktop with VB as the front end and Oracle as the back end. Everyday Product delivery, order, invoice and bills are updated on to the palmtop. The invoice number is bar-coded. The product is delivered to the client with all their invoice and bills printed out through symbol printers attached to the handheld on the spot. This saves time and reduces paper work. Since the items are bar-coded and scanned with Symbol scanners, the risk of delivering products to the wrong customers is zero.

The project involves two parts, the event driven palm operation part and the menu driven desktop application part with database.

The Palm Operation part involved the following.

Designing the forms and layouts using CodeWarrior constructor for Palm OS.

Creation of application specific Palm OS tables and records for Ordering, Delivery, Invoice/Bill.

Generation of Event Handling routines using C development environment.

Generated Events and codes for Supply Chain Management (SCM) of Products.

Used Complex routines for determining the total bill amount.

Developed own routines for Floating Point manipulations.

Used Symbol SDK for interfacing Symbol barcode scanners with Palm OS device for scanning the barcode.

Developed Conduits using CDK 4.0 in VC++ environment for Synchronizing data from handheld into the desktop. The desktop used MS-Access as its database.

Worked on Hotsync 4.0 for Synchronizing with STD RS232 serial signal and using the USB port.

The Desktop Part involves the following.

Designing Forms and Menus Using VB 6.0.

Creation of a Palm OS similar table in MS-Access.

Managing Security, which involves creation of roles and users.

Generating Reports.

Project: PalmMediRef 1.0 (June 2001-Aug 2001).

Employer: ZeroWait Systems.

Client: Vanderbilt University Hospital and Clinic, USA.

Duration: (June 2001-Aug 2001), Team Size – 3 Members.

Role: Team Member.

Environment: Palm OS Visor, CodeWarrior & CDK 4.0.

This Hospital-University is one of the leading institutions in USA. The intention of the project was to bring the CIMS, the medicine reference bible for medical people onto the handheld Palm device. The disease, symptoms, drugs, dosage are all provided on the palmtop for quick reference. This is very helpful for doctors, pharmacists and medical students. This prevents the overhead of remembering the drug names, disease they are linked to and dosage.

The project involved two parts, the event driven palm operation part and the menu driven desktop application part with database.

The Palm Operation part involved:

Designing the forms and layouts using CodeWarrior constructor for Palm OS

Creation of application specific Palm OS tables and records for Drugs, Disease, Symptoms, Remedies.

Generation of Event Handling routines using C development environment.

Maintaining a flow between drugs their respective disease, symptoms, and dosage.

Designing of screens which enable the user to view respective disease, symptoms, and remedies at any point of time.

Used complex search routines to search for key words.

Developed Conduits using CDK 4.0 in VC++ environment for Synchronizing data from handheld into the desktop. The desktop used MS-Access as its database.

Worked on Hotsync 4.0 for Synchronizing with STD RS232 serial signal and using the USB port.

Designing Forms and Menus Using VB 6.0 and Creation of a Palm OS similar table in MS-Access. Managing Security, which involves creation of roles and users.

Platform:

Palm OS Visor C Palm CDK4.0 & CodeWarrior.

To very similar projects involved the following with same platform and role involved.

Model project for Tata-AIG insurance.

Model project for Singapore E-B.

Model project for L&T.

Contact this candidate