Syed Hamid Resume Oct09

Syed Hamid [email protected]; Mississauga, L5W 1P7; 905 696 0222 JDE technical developer with 15+ years of working in IT, recently completed Oracle database certification (OCA). Interested to work as Junior JDE Business Analyst beside technical assignment. PROFESSIONAL BACKGROUND

• • • • • • • • •

Completed Oracle Database 10g Administrator Certified Associate (OCA) and Crystal Reports XI Over 15 years of experience in IT areas such as development and maintenance of applications, reports (UBE), data conversion, Z Process and generating email from applications (Forms). Expert in fine tuning and optimizing tables, indexes and business views, develop NER based Business Function and maintain C based BSFN. Worked towards converting three legacy companies to JDE 8.9 with over 40% customization due to the business requirement. Involve in data load through Auto Pilot, load test and performance test (Agriliance MN, USA). Involved in testing for migrating from AS400 SQL based to iSeries with DB2 based JDE 8.11 environment with Flint Energy Edmonton, AB. Involved on task and module level user acceptance in SNC Lavalin Profac Toronto, ON. Work with acceptance testing, functional testing, integration testing, load testing, performance testing and stress testing in different projects. Knowledge of test planning and management tool and UML. Excellent in communicating directly with users (over 600 locations in US); troubleshooting, log, document resolution and close issues/ticket in Remedy and Heat (Agriliance MN, USA). Strong analytical and problem solving abilities; provides innovative solutions by thinking outside the box and work step beyond to assure project completion. Deliver first rate results under tight deadlines, self-starter requiring minimal supervision. Equally productive on solo projects or as part of a team, Flexible when faced with changing priorities.

• • • TECHNICAL SKILLS • Extensive experience in using JDE tools in interactive and batch applications; OMW, TDA, RDA, Form Design (FDA), BSFN, NER, C BSVW, Processing Option Design, TC, UTB, UDC, UBE, Interactive Applications (IV), Menu design, Debugger (Debug) & Visual C++ Debugger on AS400 & iSeries, SQL, DB2 and Create Form. • Worked with JDE One World versions from XE (B7333), 8.9 (Enterprise One) and SP1 (8.11) Finance (GL/AP/AR), Sales Order, Procurement and Order-to-Cash in Distribution, Manufacturing, Oil & Gas industries. Also worked on Payroll, Facility Management, Asset Management, Preventive Maintenance, CSC reporting, HR and Interfaces (Z process) in Facility and Manufacturing industries. • Legacy: IDMS, DB2, IMS, ADSO, COBOL, ADSALIVE, DBOL, DME, DMLO, IDD, OLQ, OLQ, MENU, MAPC, ROSCOE, JCL, TSO/ISPF, FTP, HEAT, REMEDY, MVS, OS/390 • Receiving training on SAP BI (Business Intelligence), data extraction (ETL), administrator work bench. Navigation with reports, business context queries, query and OLAP basics. Worked with EDS on project with Service Alberta (Jan 12, 2009 To Sep 30, 2009) as contractor. (Z/OS, PeopleSoft, SQL, DARS, CASPOOL, FAX and FTP) • Single resource on project provided support to Service Alberta Business Support on all technical issues, daily operations and ad-hoc requests, watch daily system maintenance reports, provided user support to Alberta Registries offices on CASPOOL for land title and name search reports, BES (Fax, Aprea and SPIN) • Worked with ZEKE for batch job scheduler also schedule adhoc jobs in ZEKE • Provided support to Applications, FTP, DARS Replication between legacy and SQL project (SPIN), coordinated with other support groups (current legacy applications are under development on PeopleSoft, SQL and WEB based applications). • Provided training to EDS employees and smoothly hand over the project.

Ontario Canada (Apr 2008-To-Oct 2008; Realty, Facility Management and Manufacturing; Contracts):

1

Syed Hamid [email protected]; Mississauga, L5W 1P7; 905 696 0222 Analyst Programmer (AS400, 8.9 at SNC Lavalin Profac) (One World 8.9 and XE (B7333)): • Develop financial reports both new and created from template (Tabular or Group), using Account Master (F0901), Account Balance (F0902), Business Unit Master (F0006), Columns heading (F83110) and Company Constant (F0010). • Developed over 30 reports on Realty, CSC, Preventive Maintenance and Finance. Developed several CSV reports with over 75 columns with options to update Work Order Parts List using business view joined with Work Order Part List (F3111), Work Order Master File (F4801), F1755 Maintenance Request Master also fetch info from Asset Master (F1201); added all these report to Reports Menu. Create version override to provide different set of Data Selection, Report Layout and Event Rules. Tax Prepaid report: Shows the monthly actual amounts of certain Prepaid Tax Object Accounts. The report also gives an annual total, starting with the specified company; the Object Account gives further details by Business Unit and Property Tax Roll ID (Sub ledger Type X). Totaling is done at the Business Unit, Object Account and Company levels. # of re-classes due to exceptions: To provides a summary of all re-class work order type = CR (WO change Request Re-Class) with related details from the service requests. Alarm Monitoring Activity Report: Provide a summary by date range with the occurrences of an alarm monitoring system has been triggered where the CSC will receive a communication to either log the occurrence which the majority requires action by dispatching an assignee from the Assignment table which resources either internal or external to Nexacor and approved as first response. Item master used and Average Cost: Report provides summary by SCU, Company, Facility/Property Manager, region or facility which automatically provides an average cost over different suppliers or comparison across different SCU. Assignee Weekly Statement Open Work Orders Report: To provides a statement of open work orders and or service requests by status. Report will be run by business solutions, integration services and customer support center. Fixed Fee Work Orders according to entitlement: Provided a summary of all fixed fee work orders with related details from the service requests. • Lease Analysis: Report will give the number of Active Leases under management by SCU, by Lease Type, By Lease Category on a specific date, the total rentable managed and the annual rent obligation for these leases. The information will be useful to prepare a RFP, or submit quarterly activity report to Corporate, to balance portfolio between Lease Administrator. Realty Month End: This report lists current monthly and ytd actual and budget figures for all rent revenue, rent expense, and leasing expense accounts. Items are listed by co, b/u, obj acct, sub acct, sub ledger. Actual (AA) amounts provided for prior month, current month, and ytd periods. Budget (BA) amounts provided for current month and ytd periods. Monthly Expense: A monthly Expense Report that shows Monthly Actual compared with YTD and Annual Budget amounts. The YTD Actual and Annual Budget amounts have a calculated Variance. Property Tax Roll ID: To provide a monthly breakdown of specified Prepaid Tax accounts by Property Tax Roll ID. This report shows the monthly actual amounts of certain Prepaid Tax Object Accounts. The report also gives an annual total. Starting with the specified Company, this report by Object Account gives further details by Business Unit and Property Tax Roll ID (Sub ledger Type X). Totaling is done at the Business Unit, Object Account and Company levels. • Open Work Order Aging Report provides summary of the open work orders and the Request Capture. Report contains details from Work Order (F4801) and Parts Detail. • Customer Satisfaction Survey and complaints Report summarizes Complaints, Complaints by Service Code Level, Complaints by Assignee and total request count. Service complaints that have been complete and use to calculate KPI (Key Performance Indicator); key table is the Service Request (F1755). • AR Open Summary and Detail (Tabular) Report: To produce tenant A/R report, either summary or detail, with aging. The Summary report is submitted to the client on a monthly basis. The Detail report is used for collections purposes. The A/R Detail Report will produce itemized tenant A/R, listing original and open amounts with aging, for every outstanding charge in tenant A/R. G/L offset accounts and invoice dates will be displayed, as well as Remark field from A/R ledger which explains reason for billing. Itemized amounts will be grouped by tenant for each b/u location in specified company, ending with grand total for given company. • Working with AP forms for French vocabulary override. • Developed reports to provide visibility for the orders that are in the quote process (bid still open) and completed. Open Quotes (UQ (quote for contract)) 140/150 Report and Closed Quotes (UQ) 150/160. SINGLE EVENT CLOSED QUOTE (OQ) 150/160 RELEASE QUOTE TO PO AGING REPORT. Also

2

Syed Hamid [email protected]; Mississauga, L5W 1P7; 905 696 0222

•

• • • • • •

provide visibility to the Global Contract Status – the amount remaining open on the Contract Blanket Order (UB) and the order numbers (OG) that have been released from the blanket order. UB Orders (00/DT) Blanket for contracts; OG Order (00/DT) Global Purchase Orders Add Property Manager (use RP30) to business view and report template on Preventive Maintenance Plan Report and Asset Master Report. Working around the columnar report template logic by creating another driver section to have Property Manager in Heading. Corrected reports version override to print property manager. Created reports, French version with version override; source of specs was to reviewing from other environment. Developed pre-short shipment report to highlight the potential shorts in advance (manufacturing). Developed daily attainment percentage based on period from processing options, also included Re-Work (WR) to weekly creation of Production Plan Summary. Developed EFT Advice report reviewed by AR, to reconcile payment received. The EFT process designed similar to the Print Debit/Credit Memo that already exists and also can be run (called) from the EFT – Remittance Advice application. Enhanced Raw Material Inter-company Transfer Receiving Process through the PO Tally Sheet to add more columns. Enhanced Average Weekly Movement by adding a column on the MRP. Enhanced sales history spread sheet for future orders shipment by adding options to fetch Sales Orders on customer’s item ranges.

Flint Energy Services, Edmonton, AB (Mar 2007 – Jan 2008, AS400 and iSeries JDE 8.11) Lead JDE Developer (Finance, procurement in service industry with One World 8.11 (SP1)): • Worked on time entry project, user were dealing with the limitation of data entry upload and to load over 8000 transactions was great a challenge and time consuming process. The solution I developed was to atomize the load. Thus Developed TC programs to load the Z file which went through the Z-process R05116Z1I and set the custom version to be run by user for loading the data to table F06116. User is able to verify the load via P051121 and view the error report generated by the process. • Developed several custom applications (converted legacy functionality to JDE). Performed business analysis, developed, tested and implemented new Contractor Application in JDE; application includes new tables, forms, UDC values and data items. • Designed and Developed payroll check using Create!Form Designer and Director; part of team in development of AP Check during the training. • Developed Bank File Matching; uploaded data from Excel and populate an interim table, copied to F09505, deleted processed records from the interim and F09505, and changed R09510. • Modified Time Entry application (P051121) to accept company’s pay types for Salary. Determined and loaded a new custom table for all pay types used towards salaried employees that are in the list permitted during the time entry and changed the hard coding accordingly to verify Grid column with the new table (GC Pay (PDBA). • Worked with custom program for “CLAC Pension, Health & Welfare Report”; replaced Processing Options for period number. Add new column Total Hours, Sum of Reg Hrs, OT Hours, Pay Type, Permit Fee, Admin Fee, Training, Education, Dues, H&W, EE RRSP and Co RRSP. • Worked with Supplemental Data, training expiry dates and Employee roster reports for adding data types (TA,TC, TK…) UDC Codes (TC804…) to Data Selections and columns in report. • Worked for GL Daily Trial Balance and created application to load legacy info into an interim table, mapped the converted fields, address book values for the F0911 component of AP and AR. • Worked on short projects in time accounting, HR, Payroll, and GL modules. • Developed skills on functional process on JDE financials and procurement module. American Achievement Corporation, Austin, TX (Aug 2006 – Mar 2007, AS400 JDE 8.11) JDE Lead Analyst (Order to Cash in distribution industry (One World 8.9)) • Worked with daily issues and production support, developed functional skills on order to cash module in distribution (retail and whole sale) industry. • Completed customizing Pick Slip program combined the R42521 and R42522 functions per company requirement.

3

Syed Hamid [email protected]; Mississauga, L5W 1P7; 905 696 0222 • Worked in support of Order to Cash applications from Z-Process. Completed testing, document issues,

corrected (code changes) to External Interfaces project. External Interfaces creates Z-Files through table conversion programs and use JDE standard functionality to update Address Book (R01010Z), Contact Information (Custom Program), Customer Master (R03010Z), Sales Orders (R47011) and Payment Files (Custom Program). Correct table conversion programs for Address, Customer, Sales Order and Payment on different issues. Complete the assignment before time. • Worked with payment process and changed code to pre-payment reconciliation report and payment. • Worked with Address Book process, new set up for vendor, employee, company and items • Mentored a developer on improving JDE technical skills.

Agriliance LLC, Inver Grove Heights, MN (Feb 2002 – Jul 2006, Legacy and JDE 8.9) Business Analyst / JDE Developer (OTC, procurement, finance in distribution industry (One World 8.9)) • Managed corporate legacy systems operations, daily issues and production support, developed functional skills on sales order and procurement modules in distribution (retail and whole sale) environment. • Worked in support of conversion of legacy data to JDE for sales order, invoice, receipts and purchase orders; unloaded as text file from legacy, loaded to JDE by TC programs and developed forms to browse legacy history. • Developed AIMS dispute invoices system, involved in business analysis and design, developed program to run in auto system and pick dispute invoices and load to JDE table. • Developed dispute invoices forms and linked to customer ledger inquiry (P03B2002) by creating row exit. Data was received three times a day and loaded by TC program to Dispute table (Dispute Interface). Dispute invoices inquired or entered on dispute table (Custom Form) and update matching original documents in the ledger (F03B11) with payment status and code. Also developed dispute invoice reporting and one time fix for deduction codes and description (UDC Codes). • Proficient in changing the Delivery Ticket / BOL (pick ticket,R42520 & R42521), Invoices R42565, developed Purchase Order Re-Price program (AutoSys job) using P4310 functionality via EditLine per Agriliance requirement. • Worked under Debug, Applications like P4210 & P4310. • Customized and created (over 50, Columnar, group, tabular, financial reports (with smart fields)) most complex and critical reports and version level report. • Corrected several programs after changing Business View. • Developed several Mass Update programs (Proof and Update Mode) for Item (F401) and Item Branch (F4102) supported by operational manuals. • Performed code change with most of the JDE modules implemented finance (GL, AR and AP), OTR and procurement (PO, purchase order and catalog re-pricing) • Troubleshoot; support and log issues after communicating directly with users in over 600 Agriliance retail locations in US. PDM Set-up • Vendor/Employee set-up • Customer (Shipping, Billing) set-up • Factory Set up; Customer/Vendor - Factory relationship • G Code (R/M), F Code and Brites Code set-up: Set-up involves creating Item Master, Item Branch, UOM, BOM, Routing, Tray Print, Cost Comp (XE, XG, XH) and Stimulate Cost • Material (R & P Codes) set-up: Set-up involves creating the Item Master, Item Branch Cost (Routing Setup) • Running Cost Roll-Up Process

•

• • • •

•

EDUCATION and PROFESSIONAL DEVELOPMENT COURSES Bachelor’s (Mathematics) Completed Oracle Database 10g Administrator Certified Associate (OCA) Crystal Reports XI PeopleSoft Certificates for JDE Report Writing and Application Development (instructor led) TeamCain Certificate for Create!Form IBM certificates on COBOL language, DL1 and Operating Systems

4

Syed Hamid [email protected]; Mississauga, L5W 1P7; 905 696 0222 •

IDMS Programming and Design from ADV-ORGA of Germany Reference from Agriliance, American Achievement, SNC Lavalin Profac and others will be available upon request.

5