|
|
|
|
|
|
|
|
|
OVERVIEW: Raza Haider has a total of 6 years of experience in Oracle Applications:
ü 4+ years of functional & technical experience in Oracle Financials, Supply Chain & Self Service
ü 1+ year of technical/development experience in HRMS 10.7 SC and custom-application
ü 4 full 11i implementations and 2 upgrades to 11i (11.5.7)
ü Excellent understanding of Oracle ERP: Implementation methodology (AIM), functional processes, database objects (tables and views etc.) and Oracle tools
ü Hands-on experience of system development efforts including: requirements definition, system design, implementation, multi-org, upgrade, gap analysis, system testing, creating setup/test scripts, utilizing Fast Forward approach, and production support.
ü Accustomed to tight schedules and delivery under deadlines
ü Bachelors with double major in MIS and Accounting
ü Possesses excellent communication, inter-personal, team related and analytical skills
ü US Citizen
SKILLS: Oracle ERP (11i):
ü Functional: CA, GL, FA, AP, FSG, ADI, INV, PO, iProcurement, iExpense, Sys Admin, RXI Designer, and some AR/iReceivable
ü Technical: 11i/11.0.3/10.7 SC – GL, PO, AP, AR and INV reporting
ü Technical: HRMS 10.7 SC/11 – HR and Payroll balances reporting
ü Tools: Oracle Developer 2000 (Oracle Reports 2.5 and 6.1), Oracle Folders, Account Hierarchy Editor, Financial Implementation Wizard, Smart DB 4.1, SQL Navigator and DataLoad
ü Database/Languages: RDBMS, SQL, PL/SQL and SQL*Loader
ü Industries: Utilities, consulting, manufacturing and B2B
ü Operating Systems: Windows 95/98/NT/2000/XP
ü Other Products: Microsoft Word/Excel/PowerPoint
Positions Held:
Mar 02 - Present MidAmerican Energy Holding Company, Des Moines, Iowa
MidAmerican (MEHC) is a global leader in the production of energy from diversified fuel sources including geothermal, natural gas, hydroelectric, nuclear and coal. MEHC has worldwide operation – USA (multiple sites), UK, Philippines, Australia and Poland.
Role: Sr. Application Systems Analyst – Functional/Technical
Currently working on various functional and technical 11i projects including:
§ iProcurement – Designed and implemented iProcurement. Tailored many web pages to accommodate business requirements. Developed new LOVs for the accounting structure. Prepared setup and test documents. Demonstrated the key functionalities to the main users, IT staff and upper management.
§ iExpense – Developed expense report templates, expense report processes (AP & OIE), and modified excel templates. Configured key profile options and setups to invoke manager (spending) approval workflow process
§ Supply Based Management (INV/PO) – Streamlined inventory replenishment by introducing and configuring Min-Max Planning and ASR/ASL (Automatic Sourcing Rules & Approved Supplier List) for 5 different power plants.
§ Inventory – Built and initialized ABC Classes and Cycle Count definitions for 4 different subsidiaries. These daily/periodic cycle count procedures adjust asset values and post correct inventory amounts to GL. Also prepared setup/test documents and provided training to the warehouse supervisors.
§ GL Reports (6i) – Developed custom reports to assist management and tax auditors including:
- Developed a new GL account analysis report w/ sub-ledger details (AP, AR and PO). The purpose was to retrieve (drilldown) certain information against any GL account combination.
- Re-designed a “Customized Trial Balance” report based on summary balances. This report calculated “Beginning Balances”, “Period Activities” and “Ending Balances” for YTD, QTD and PTD dimensions.
NNG Implementation – Feb-03
MidAmerican recently acquired (web link) NNG (Northern Natural Gas) – an Enron/Dynegy pipeline and converted its SAP system to Oracle 11i.
§ Implementation team consisted of Accenture Consulting, the MidAmerican employees and a consultant (myself)
§ NNG was added to the existing 11i system with a new Set of Book with GL, AR, AP, CM, PO and INV
§ Responsible for configuring the system
§ Led and coordinated all setups in TEST & PROD
Oracle 11i Upgrade – Dec-02
§ Successfully completed an upgrade from 11.0.3 to 11i (11.5.7)
§ Performed multiple upgrade duties including:
- Gap fit analysis
- Multi-Org configuration
- Functional setups/testing for AP, GL, PO, and INV
- Custom report migration using Reports 6i
- Planning coordinator and support for boot camp training conducted by Oracle education.
- Assistance and support to the end-users
Also performed/performing additional functional/technical assignments in various capacities including:
§ PO – Debugged numerous stuck/pending requisitions and purchase orders in Workflow
§ AP – Responsible for configuring the AP prepayment functionality for the Philippines operations including the documentation and assistance
§ GL – FSG, ADI, Multi-Currency, Translation, Rollup Groups, Inter-company, Cross Validation & Security Rules and some Consolidation
§ iReceivables – Part of the DEMO team in OAUG at Atlanta
§ AR – Supported invoice interface program
§ RXI Administration Tool – Developed and published a number of RXI reports
§ System Administration duties in various capacity
§ Built a number of new and debugged existing AP/PO/GL reports using Reports 6i
§ On Call Support - once a month for a week
- Provide Oracle Applications Help Desk support to about 350 users (US and abroad)
Sep 98 - Dec 01 PORT Consulting, Inc., Jacksonville, FL
PORT provides Oracle support and services for new implementations, upgrades, new modules, assessments, virtual administration and hosting, custom web applications, training, and managed application services.
Projects:
Sep 01 - Dec 01 Internal Project – 11i Implementation (Fast Forward)
Role: Sr. Analyst – Functional & Technical Consultant
Responsibilities:
§ Functional consultant for Fixed Assets, Payables, ADI and Purchasing
§ Prepared setup and test documents
§ Performed a comprehensive unit and system integration testing
§ Created request sets
(Spent about 40% of my time for this project)
Application Desktop Integrator (ADI):
§ Part of the Oracle financial implementation team to migrate data from a legacy Oracle system to a new Oracle 11i application
§ Created ADI templates to keep the GL balances.
§ Extracted the legacy GL balances (using SQL) and then populated them in to the ADI templates
§ Restructured the parent-child relationship of Chart of Accounts using Account Hierarchy Editor
Payables:
§ Performed the general setup of payables as per business requirements
§ Defined the various payment terms, purchase order-matching tolerances, banks, and suppliers/sites
§ Classified financial options and payable options that are specific to Accounts Payables
Fixed Assets:
Defined:
§ Key Flexfield Structures: Key, Category, and Location
§ Fiscal years and calendar
§ Asset categories, and calendar periods
§ System controls
§ Asset Security by Books
§ Prorate convention
§ Book controls (corporate books)
§ Salvage limits and locations
§ ADI (excel) template to create mass additions
Purchasing:
§ Defined and assigned Approval Groups
§ Defined PO Item Categories (Key Flexfield) structure
§ Defined Purchasing, Receiving, and System Options
§ Scheduled ‘Workflow Background Processor’, ‘Receiving Transaction Process’ and ‘Send Notifications for Purchasing Documents’
Aug 01 – Aug 01 Proudfoot Consulting, Inc. – Upgrade to 11i
Role: Sr. Analyst – Functional & Technical
This was an upgraded from 10.7 to 11i. I was assigned to the project for three/four weeks and was responsible for:
§ Performing gap fit analysis for GL and FA
§ Assisting and assuring that GL and FA (11i) had been properly configured
§ Preparing setup and test documents
§ Performing a complete GL / FA unit and system integration testing
§ Debugging and compiling 10.7 reports in 11i environment
§ Developing 3 new Oracle reports for the client using Reports 6.1
May 01 – Dec 01 Etura and Applied Digital Solutions – 11i Production Support
Role: Sr. Analyst – Functional & Technical
Performed post-production support duties including:
§ Providing support to the users on the regular basis regarding their financial 11i systems. The issues covered GL, AP, PO, GL, FA, AR and System Administration modules
§ Opening and tracking iTARs (Technical Assistance Requests) with Oracle as required
(Spent about 60% of my time for this project)
Apr 01 – May 01 Etura Premier, LLC – 11i Implementation ((Fast Forward)
Role: Analyst – Functional & Technical
§ Responsible for setting up Common Applications, General Ledger, Oracle Payables and Fixed Assets
§ Determined user requirements using a questionnaire documents
§ Used Financial Implementation Wizard to complete the setups
§ Prepared setup and test documents for each module
§ Performed a comprehensive unit and system integration testing for each module
Common Applications:
§ Defined required value sets and Key Flexfield structures, including Accounting Flexfield for each module
§ Loaded Chart of Accounts using SQL Loader
§ Defined accounting calendar and a Set of Book
§ Created organization hierarchy
§ Setup multi-org structure and their parameters
General Ledger:
§ Uploaded the data from the legacy system to Oracle General Ledger using ADI
§ Created budget organizations and budgets
§ Defined KFF security rules, cross validation rules, recurring journals, accrual (reverse) JEs, and intercompany accounting etc
Fixed Assets:
Defined:
§ Key Flexfield Structures: Key, Category, and Location
§ Asset categories, calendar periods, System Controls, Book Controls (corporate books), Prorate Convention and Fiscal years and calendar
§ ADI (excel) template to create mass additions
Oracle Payables:
§ Developed the design document following the AIM methodology
§ Documented and input set-up parameters for Oracle payables
§ Involved in the setups for the accounts payable
§ Involved in defining payment terms, purchase order tolerances, invoice holds, defining invoice approval codes
§ Defined the financial options and payable options relating to Oracle payables
Feb 00 – Apr 01 Applied Digital Solutions, Inc. – 11i Implementation (multi-org)
Role: Business Analyst – Functional
§ A multi-org environment (11 companies) within a single Set of Book
§ Responsible for setting up Common Applications, Common Financials, General Ledger, System Administration and Fixed Assets
Common Application:
Defined and Tested:
§ The required value sets and the Key Flexfield structures including Accounting Flexfield
§ Calendar and Set of Books
§ Multi-org, org-hierarchy and their parameters
General Ledger:
§ Involved in a range of setup phases including: ADI, budget, KFF security rules, cross validation rules, recurring journals, accrual (reverse) JEs, and intercompany accounting etc
Fixed Assets:
Defined and Tested:
§ The required value sets and the Key Flexfield structures, asset locations, asset calendar, Book Controls (only corporate books), Prorate Conventions, Asset Categories, mass additions, leases and asset security etc.
System Administration:
§ Built new security rules and assigned them to the Responsibilities
§ Created new responsibilities and assigned them to the users
§ Created new menus and assigned them to the Responsibilities
§ Developed new request sets and scheduled them accordingly
Dec 99 – Jan 00 Alliance Mortgage, Inc. – 10.7 SC Report Customization
Role: Programmer/Developer – Technical
Upgraded about 12 customized GL and AP reports (using Reports 2.5). These reports were outdated due to Alliance's upgrading of the Oracle Financials
Jun 99 – Dec 99 Jacksonville Electric Authority – HRMS 10.7 SC Report Development
Role: Programmer/Developer – Technical
§ Developed and registered new HRMS custom reports as needed, using Oracle Reports 2.5, Excel, and SQL Navigator
§ Gathered requirements from the users for reporting purposes
§ Worked on the ‘JEA Incentive Payment Plan for 1999’ interface project. Developed a package in order to calculate and generate bonus amounts for eligible employees (approximately 2700). The database package retrieved and processed specific payroll data and produced incentive payments.
§ Used Oracle Balance Views to get balance
Jan 99 – May 99 Florida Rock Industries - HRMS 11.0.3 Data Conversion
Role: Programmer/Developer – Technical
§ Validated and cleansed the HR legacy system during conversion to Oracle HRMS/Payroll system
§ Loaded data, using SmartDB, into the appropriate staging tables, where it was then loaded into the Oracle system
§ Created new interfaces/flat files (payroll balances), again using SmartDB
§ Developed new reports using Report 2.5
Sep 98 – Dec 98 Internal Project – Reporting
Role: Developer – Technical
§ Provided support to the internal time entry system and developed various new Oracle reports and forms.
Apr 98 – Jun 98 Horizon Health Services, Buffalo, NY
Development of custom reports and forms to serve customer needs.
1985 – 1989 Central Piedmont College, Charlotte, NC
Assisted students with lab exercises in their use of COBOL, CICS, and JCL
1985 – 1996 Worked at various non-professional jobs in order to support my family, while continuing to study and prepare for a career in Information Technology (North Carolina and Florida).
EDUCATION:
2000 – 2003 Oracle 11i training in various modules
1997 Post Graduate Certification – MIS (Oracle), I.B.O.S.S., Pakistan
1985 – 1990 Associate in Applied Science, MIS, Central Piedmont College, Charlotte, NC
1984 – 1985 Certification in MIS, College of Data Processing, London, England
1979 – 1983 BA (double major) in Economics/Accounting, University of Punjab, Pakistan
REFERENCES: Available upon request
