SUMMARY:

• I used Hybrid of AGILE and WATERFALL for Design, Development and Testing. I have worked mainly with Progress/OpenEdge (Version 4.0 - to - Version 10.1C) since 1985. I am QAD Trainer/QAD - Techno-Functional - Consultant. I worked on customization of OpenEdge QAD ERP System for Confidential, Confidential, Confidential and UNILIVER. I wrote RETAIL SYSTEM using AS400 RPG programs as system specifications and CLYMAN ERP system using COBOL as system specification. I worked on enhancement and customization of Confidential retail system twice. I also worked on migration of OpenEdge QAD ERP to AS400 MoveX and OpenEdge RMS ERP to SQL Server 2003. I worked on COMENG bespoke OpenEdge ERP system as well as interfacing it with OpenEdge UNIBIS Financials. I did Customization and Support of INFOPLUS and TITAN ERP System for Confidential . My expertise are in Business/System Analysis, Testing, OpenEdge Development, Database Administration, Performance tuning, Manage, maintain and support APACHE, TOMCAT, CLIENT, ADMIN, WEBSPEED, NAMED, APP, DATABASE, HA, Replication, DR, Roll Forward and Fail-Over Servers using best industry practices. Install, Update/Patch and Maintain OpenEdge Servers. Test and Release in Production. Monitor Application Performance and Tune Servers. I have Clear and precise Communications, Team Work, SDLC standards and RDBMS fundamentals. I also have Extensive expertise in HP-UX, Solaris, AIX, PERL, KSH,
• AWK and SAN storage systems. Provide interfaces with SQL Servers, COGNOS, CRYSTAL REPORTS, Access, Excel, Word and Pivot table reports. Experience in HP Open view Service Desk/Service Manager (SM7), HP Mercury Quality Centre. I am expert OpenEdge DBA, OpenEdge FATHOM with extensive expertise in VST tables and OpenEdge Schema/meta-Schema. My main objective is to provide best and timely service to my customers, I expect and Demand the best and provide as such. I might add that I have worked with QAD and Mahindra Satyam at QANTAS. In fact, I can safely claim that I was providing support over and above what QAD and Satyam could provide.
• If I could not do it - Satyam/QAD will not be able to do it except where software code is concern as I do not had access to it. Difficult to say without full audit, but past experience suggests that I can tune-up and improve performance what SCP Ardmona has at this moment. At QANTAS, I managed to cut IBM backup time by 17 Hours. I managed to get resorted from 6 hours to 1.75 Hours. I managed and completed full DR and FailOver test and was able to deliver system in less than two hours - with Full TVT/PVT.

TECHNICAL SKILLS:

Technical: QAD Techno-Functional Consultant, Admin, Progress Developer, DBA and Trainer Extensive Expertise in Progress/OpenEdge GUI/ABL/4GL/CHUI and PERL/KSH and SQL SOX, COGNOS, BI, ETL, ERD. ERP, DBA-Oracle/Progress/SQL, QAD-ERP, Migration Persistent Procedures, Retail, POS, Supply Chain, Logistics, FMCG, Payroll, Transformaci n QAD Financial and MRP - & Support, SQL Server, Word, Excel, VBA, ACCESS Visio, PPT, MS-Project, AIX, Linux & HP UNIX, PERL, PHP, AWK, SCRIPTING, Apache, Tomcat Managed 5 ERP migrations Progress/Oracle. Implemented and Managed QAD Enterprise ERP Extensive Expertise in Progress/OpenEdge Database Administration and Support Project Manager & Migration - Managed Migration Process, Procedures, Scripts and Documentation Data Analysis, Data Quality Management, data objects, Data Extraction, Data Cleansing, Data Validation, Data reconciliation and Business verification, Data Management Best Practices

PROFESSIONAL EXPERIENCE:

Confidential

Project Manager - Deliver Turnkey Licensing System, BI, Oracle

Responsibilities:

• QAD Trainer/QAD - Techno-Functional - Consultant - Experience
• Consultant - OpenEdge DBA, BA - Performance Improvement
• ResponsibilitiesManage OpenEdge DBA and Performance Improvement. Client has most of IT functions in-house e.g. OS, Hardware, Networking and Application Support. Document and plan for OpenEdge Upgrade from 10.1C - to - 11.2
• Business Analysis of Core System for performance issues. Define and document Business Process.
• Create and Develop tools for performance monitoring and improvement.
• Support a user base of 2600 and over 3 TB of Databases. Liaison with Progress Software Corporation and software vendors
• Support CyberQuery
• Conduct Root Cause Analysis - RCA.
• Managed and Support SONIC, APACHE, TOMCAT, CLIENT, ADMIN, WEBSPEED, NAMED, APP, DATABASE, HA, Replication, DR, Roll Forward Servers and best industry practices.
• Document and plan for OpenEdge Upgrade from 10.1C to 11.2.
• Test and Release in Production.
• Monitor Application Performance and Tune Servers.
• Clear understanding of Communications, Team Work, SDLC standards, dbtool and RDBMS fundamentals.
• Specify, design and develop 4GL/ABL VST Table code to extract data from OpenEdge FATHOM and Production Databases to monitor and manage Performance and System Alerting.
• I also have Extensive expertise in Solaris, PERL, KSH, AWK and SAN storage systems. Provide Excel, Word and Pivot table reports.
• Experience in up.time5, HP Open view Service Desk/Service Manager (SM7).

Confidential

QAD-Techno-Functional - Consultant

Responsibilities:

• ResponsibilitiesSupport and Consultancy QAD-Techno-Functional. I have extensive Functional expertise in Finance, Manufacturing, Purchasing, Sales, Commercial and Supply Chain Logistics. Supported ERP and used hybrid of Agile and waterfall methods. Create and Maintain Quality Assurance procedures and documentation. Insure required corporate standards are met. Interfaced EDI, SQL, QAD, and BI and pro-actively manage the system performance. Managed After-Imaging, Roll-Forward databases, High Availability System and Dash Board. Data Analysis, Data Cleansing and Maintain Data Integrity. Export of data to Excel, management reports, charts and Pivot tables. SMS and eMail alerts for QAD databases and System Health monitoring. Managed, Used and assisted business in Testing, Simulation, and System Tuning.

Confidential

Technical Lead - Business Analyst Titan ERP

Responsibilities:

• Supported ERP and used hybrid of Agile and waterfall methods. Create and Maintain Quality Assurance procedures and documentation. Insure required corporate standards are met. Interfaced EDI, SQL, Progress, Oracle, Excel, BI, Billing system and pro-actively manage the system performance. Export of data to Excel, management reports, charts and Pivot tables. Exported and Loaded data to SQL and Oracle migration to new system Perform duties of ERP DBA. SMS and eMail alerts for TITAN databases and System Health monitoring. Managed, Used and assisted business in Testing, Simulation and .

Confidential

Business Analyst/Developer - WINDOWS

Responsibilities:

• Functional Decomposition, Analysis, Point estimation, ERDs, Data Analysis, Mapping, Validation, Analyse, Design and Specify, Develop & Test Child Care Management System. I Developed Scripts and Packages to Implemented Payroll, Group s, BAS, On-Line lodgement EDI Interfaces to/from CentreLink System.
• I Used Hybrid of Agile and Waterfall methods for design and development of applications. Discuss, analyse, and prepare proposals and specifications for Child Care System. Conduct Reviews of Business Requirements, Database Design & CentreLink Interface. I Designed, Programmed, Tested Excel Front End, VB scripts, Access Back End. Designed & programmed buttons to Print, Update and Enquire various UI. For testing manual procedures were used to create Project Plans, Requirements Management, Business and Technical Components, Test Plans, Test Sets, Defects Management and Reporting. These were needed as CentreLink will not allow until it is proven using set of criteria supplied by CentreLink.

Confidential

Developer/Tester - WINDOWS, Mercury Quality Centre

Responsibilities:

• Conducted Business Analysis and documentation of Item Master requirement and development of Item Master in Progress/OpenEdge. Data Analysis and Data Cleansing, Maintain Data Integrity Development Testing, Design and Specification of Item Management - Specialty Stores - Liquor, Supermarkets and Petrol, Business Requirement of Item Master. Prepare & Keep TEST BED up-to-date. Apply Patches to TEST BED, Prepare testing procedures, scripts, System and Regression Testing of RF and Barcodes. Follow-up Regression Testing using Mercury Quality Centre. Provide Test results, provide integrated system for release.

Confidential

QAD-Techno-Functional - Consultant

Responsibilities:

• Support and Consultancy QAD-Techno-Functional. Functional expertise in MFG/Pro eB2 Finance, Manufacturing Commercial and Supply Chain, Analysis, Designed and Development of Enhanced Financial, Functional expertise in Sales, Purchasing, Finance, Manufacturing Commercial and Supply Chain,
• Analysis, Designed and Development of Enhanced Financial, Manufacturing and Supply Chain Module, Knowledge of Technical architecture of QAD Enterprise ERP. Support QAD Enterprise. Extract and load data from Progress QAD-ERP system to COGNOS BI System. Maintain and Support Quality assurance of container manufacturing units in Australia and New Zealand.

Confidential

QAD Trainer/QAD-Techno-Functional - Consultant

Responsibilities:

• Support and Consultancy QAD-Techno-Functional and DBA. Create and Maintain Quality Assurance documentation. Insure Production matches Quality and Requirement. Functional expertise in Finance, Manufacturing Commercial and Supply Chain, Analysis, Designed and Development of Enhanced Financial, Functional expertise in Sales, Invoicing, Purchasing, Finance, Manufacturing, Commercial and Supply Chain, Analysis, Designed and Development of Enhanced Financial, Manufacturing and Supply Chain Module, Knowledge of Technical architecture of QAD Enterprise ERP. Support QAD ERP Enterprise. Extract and load data from QAD Enterprise ERP to Crystal Report for Business Intelligence. Data Analysis and Data Cleansing, Maintain Data Integrity. Fix major issues of Invoicing and Invoice printing.

Confidential

Business Analyst - Progress ERP Consultant - HP-UX

Responsibilities:

• Enhance, Maintain and Support RMS ERP System, Progress/OpenEdge. Extract, transform and Load data from RMS ERP System to SQL ERP System. Perform Data Analysis and Data Cleansing, Maintain Data Integrity and perform SIT and Regression Testing of RMS and SQL System. Support Finance, MRP, and Invoicing and Purchasing Business users. Provide support and maintain database backup and recovery procedures.

Confidential

QAD Trainer/QAD-Techno-Functional - Consultant

Responsibilities:

• Support and Consultancy QAD-Techno-Functional. Design, Develop and Implement Y2K and GST Solution and Upgraded QAD-MFG/Pro. Designed and maintain Quality Assurance and Waste Management System. Functional expertise in Quality Assurance, Sales, Invoicing, Purchasing, Finance, Manufacturing
• Commercial and Supply Chain, Analysis, Knowledge of Technical architecture of QAD Enterprise ERP, Business Analyst and Supporting QAD Enterprise. Conduct Stake Holder interviews to insure that Production and Quality matches requirements. Interface EDI, Excel, QAD-ERP and BI, SAP, ORACALE, BPCS, WOODMASONS LOGITICS, MERCIALICS, MS-Access Waste Management System. Prepare & Keep TEST BED up-to-date. Apply Patches to TEST BED, UNIX & QAD-ERP Administration. Provide support to local business users as well as support Regional Business Users located in Singapore and Confidential HO Management located in LONDON. Manage printing and MRP and reports, print management functionality for Business Users.

Confidential

QAD Trainer/QAD-Techno-Functional - Consultant

Responsibilities:

• Support and Consultancy QAD-Techno-Functional. Design, Develop and Implement Y2K and GST Solution and Upgraded QAD-MFG/Pro. Designed and maintain EDI and CORVUE BI System interfaces. Functional expertise in Quality Assurance, Sales, Invoicing, Purchasing, Finance, Manufacturing,
• Commercial and Supply Chain, Analysis, Knowledge of Technical architecture of QAD Enterprise ERP, Business Analyst and Supporting QAD Enterprise. Conduct Stake Holder interviews to insure that Production and Quality matches requirements. Interface Excel, QAD-ERP and Jet Forms. Prepare & Keep TEST BED up-to-date. Apply Patches to TEST BED, UNIX & QAD-ERP Administration

Confidential

Project Manager

Responsibilities:

• Managed a team of 2 Business Analysts, 13 Developers, Oracle DBA, Test and UAT Teams and managed external vendors. I also Designed, Developed and Programmed Remote Implementation and Monitoring procedures and Scripts.

Confidential

Business Analyst Progress/OpenEdge CRM - HP-UX

Responsibilities:

• Support, Analysis, Design, Programming and Enhancement of CRM and IVR System using Progress/OpenEdge 4GL/CHUI. Design and develop Interface for CRM, Sales, Purchasing and Billing to Oracle Billing System. I also Designed EDI interface for Sales, Purchase and Billing System.