We provide IT Staff Augmentation Services!

Technical Business Consultant Resume

Phoenix, AZ

PROFESSIONAL SUMMARY:

  • A Career Consultant and Educator dedicated to the success of individuals and teams.
  • 20+ years experience as a Business/Systems/Data Analyst/Developer/QA/Trainer covering the system development life cycle, (SDLC) including root cause analysis, process flow, and UAT
  • 10+ years experience customization of Oracle ERP, with many companies on several projects/applications.
  • Experience with PL/SQL, Forms, Reports, ETL, using Microsoft Office Suite of Products (Word, Excel, PowerPoint, etc.)
  • Broad experience includes end user and customer interaction/support, functional leadership, personnel training, production and application support, Business Analysis and technical requirements documentation, and technical support/solutions.
  • In recent years has been a registered Substitute Teacher for Paradise Valley School district due to his passion / dedication to Teaching/Training/Mentoring at all levels.
  • Previously held Top Secret - Confidential Security Clearance.

SKILL:

  • System Life Cycle Dev. Oracle Financials/App. Devel. PL/SQL Tools
  • Requirements Analysis Database Design & Devel. End User Training
  • Technical Support/Testing Oracle Forms & Reports QA / Project Mgmt.
  • WebMethods/UNIX Windows 7/XP/ App. Support HP/Mercury Quality Center

TECHNICAL SKILLS:

HARDWARE: HP3000/9000, VAX/VMS, Pyramid, AT&T 3B2, Wang VS/PC, AS400, Xterm, IBM-4361,3090, PC/XT, Lanier, Inforex, & Vista-PC, SunOS, Sparkstation, UNISYS 5000, 6000, Datapoint - 8800/ 6600 series.

SOFTWARE: WebMethods, FTP, Oracle Financials 9,10,11 - AOL, General Ledger, Financial Statement Generator (FSG), Accounts Payable, Accounts Receivable, Fixed Assets, Project Accounting, Purchasing, ORACLE Database 10G, 7, 6, & 5 Forms & Reports 6i, PL/SQL, SQLForms, SQLPlus, SQLReportwriter, SQLMenu, SQLLoader, TCP/IP, Quicksilver XML Publishing-Interleaf, Multimate, Supercalc, Lotus 1-2-3, WordPerfect, Crystal Reports, Windows XP, Windows 7, Microsoft Office Suite-Word, Excel, PowerPoint, Outlook, UNIX/vi, Norton, QDOS, Multiplan, Datascan, Peoplesoft, Infomaker, CM21, Adobe Acrobat. Oracle Toad 8.6, SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, TortoiseSVN, WANG, M204, HP Quality Center, Rational ClearQuest, ECS Payment Monitor, Support Services, Putty, ETL, Active Directory, T-SQL, XML, EDI/ANSI 820, SAPIDoc, Oracle Next Generation Desktop

OP SYSTEMS: UNIX, MVS/XA, Wang VS, RMS, DOS, PC-DOS,Windows OS, MAC

PROFESSIONAL EXPERIENCE:

TECHNICAL BUSINESS CONSULTANT

Confidential, Phoenix, AZ

Responsibilities:

  • Software used included Microsoft SQL Server Management Studio SSIS 2008/T-SQL, Microsoft Office Suite - Excel, Outlook, Word, Windows 7, Citrix, UltraEdit, Remedy

CUSTOMER SERVICE REP. TRAINER

Confidential, Scottsdale, AZ

Responsibilities:

  • Instruct in the function of an Oracle Next Generation Desktop on Microsoft Windows 7 & XP.
  • Provided training/assistance on Medicare, Webchat, elearning & Marketplace related materials.
  • Provided daily reports and updates in Excel on classroom/training for General Dynamics.
  • Provided assistance in production customer support and limited technical support.
  • Provided assistance in overviews for adherence to ISO 9001, HIPAA, SOP and other standards.

ONLINE TECH SUPPORT

Confidential, Phoenix, AZ

Responsibilities:

  • Provide Technical Support with the audio & visual classroom for teachers, students & parents.
  • Accessing Blackboard Collaborate and Elluminate while updating personnel database records.

QUALITY ASSURANCE/UAT

Confidential, Chandler, AZ

Responsibilities:

  • Develop, execute and document end-to-end testing, plans/results encompassing the implementation of new clients, and enhancement of existing clients.
  • Modify, test and verify setup/configurations on WebMethods Trading Network /Developer.
  • Coordinate testing with Key Engineers/Bus. Analysis/Developers and Product Support.
  • Test input files for domestic and international ACH, Wire, Transfer & Check payment types.
  • Analyze and verify client requirements, mapping within Design Specifications Documents.
  • Perform FTP transfer, migration, processing and test of client data in a Unix platform.
  • Assist in coordination of client implementation, gap analysis and IT troubleshooting.
  • Validate format and mapping of XML, EDI/ANSI 820, SAPIDoc, Flat & Delimited files.
  • Coordinate access of Wire lines and associated return conformations among clients.
  • Access Oracle databases, HP/Mercury Quality Center Rational Clear Quest Defect tracking, ECS Payment Monitor, Support Services, SharePoint, PAC2000, Putty & java routers.

BUSINESS ANALYST/DATA ANALYST

Confidential, Scottsdale, AZ

Responsibilities:

  • Provided system expertise, ETL, gap analysis, and liaison activities for business accounts.
  • Provided data analysis & data mapping of client extract data feeds into a central DataWarehouse.
  • Performed Oracle 10g database object creation & validation w/TOAD & SQL Server.
  • Coordinated data migration/testing and resolution of database/application issues.
  • Developed Oracle stored procedures/functions/queries using SQLPlus and T - SQL.
  • Provided system quality assurance, IT troubleshooting & user acceptance testing (UAT).
  • Assisted with production support activities ensuring solution enhanced business processes.
  • Provided ICD9 mapping under HIPAA compliance for accounts.
  • Provided subject matter expertise (SME) for business accounts, sometimes telecommuting.
  • Utilized Microsoft applications in Word, Excel, Outlook, PowerPoint, Visio and Project.
  • Accessed the work environment remotely on occasion via telecommunications.

SYSTEMS ANALYST - Consultant

Confidential, Phoenix, AZ

Responsibilities:

  • Provided engineering services, support, technical writing & documentation w/Quicksilver
  • XML (Interleaf) using CM21/ACM configuration software in a VAX environment.
  • Performed Boeing 737 Database element validation.

STOCK DAYTRADER

Confidential, Phoenix, AZ

Responsibilities:

  • Design, development, testing, implementation and documentation of applications to meet business requirements using Oracle Financials Smart Client modules 10.7
  • Performed functional requirements analysis, gap analysis, IT troubleshooting and customization of Oracle Financials
  • Forms and Reports in A/R, A/P, G/L, F/A, & P/O modules.
  • Coordinated business specifications to create detailed design applications
  • Development of FSG/Oracle Reports, PL/SQL functions/procedures.

SYSTEMS ANALYST - Consultant

Confidential, Sunnyvale, CA

Responsibilities:

  • Implementation of Oracle Financials A/R Module in a Unix environment.
  • Provided functional and technical assistance in the conversion of Oracle Financials
  • A/R, G/L and custom billing, developing Forms, FSG Reports, and PL/SQL procedures.
  • Managed Reporting dept. - Coordinated personnel, task and reporting requirements.
  • Provided Liaison duties translating requirements between management and design team.

SYSTEMS ANALYST

Confidential, New Orleans, LA

Responsibilities:

  • Supervised the implementation of Oracle Financial Modules and an AS400 conversion project.
  • Managed A/R and P/A Oracle development projects and personnel.
  • Development of AOL, SQLForms, PL/SQL procedures and Oracle/Crystal Reports.
  • Analyzed & documented proposed and completed modifications or enhancements

PROGRAMMER/ANALYST

Confidential, Coral Gables, FL

Responsibilities:

  • Assisted MIS Department in the technical requirements/development of Oracle Financials.
  • Development of Accounts Payable applications w/interfaces to Purchasing.
  • Providing support in AOL, SQLForms, PL/SQL & SQLReportwriter.
  • Supporting G/L, A/R, & P/O modules and Peoplesoft conversion/reports/queries.

PROGRAMMER/ANALYST

Confidential, Boynton Beach, FL

Responsibilities:

  • Technical requirements analysis for an Oracle Financials conversion in a unix environment.
  • Design, development, testing and implementation of program applications.
  • Development of interface/conversion programs in G/L, A/P & F/A modules.
  • Provided support in AOL, SQLForms, PL/SQL, Pro C & Oracle Reports.

PROGRAMMER/ANALYST

Confidential, Atlanta, GA

Responsibilities:

  • Analysis of system requirements and program specifications.
  • Development of SQLForms/Pro C report programs with embedded SQL.

PROGRAMMER/ANALYST

Confidential, Atlanta, GA

Responsibilities:

  • Providing DBA/system analysis and product recommendations.
  • Development of DBA, SQLForms, SQLMenu, SQR & SQLReports.

SYSTEMS ANALYST

Confidential, Silver Spring, MD

Responsibilities:

  • Provided system analysis, development, and testing of Oracle business applications.
  • Development was done on a Unisys 6000 and Wang VS using ORACLE and Windows.
  • Analysis, Code & Test of SQLForms and SQLReports programs.
  • Modifications of Shell scripts & Pro C applications.

Hire Now