Todd D. Wonnell

**** ** **** ***

Coconut Creek, FL 33073

954-***-****

aczsmw@r.postjobfree.com

I am self-motivated individual with more than 15 years information technology experience I have the ability to quickly adapt, assimilate, and apply new skills sets to successfully meet job requirements. I am seeking an employment opportunity where my past work experience will have the maximum value added contribution to the organization's profitability.

Work Experience

Managed Care of North America, Ft Lauderdale, Florida - Reporting Analyst/ BI Developer 03/12 –12/16

*Respond to business units reporting requests

*Interpret customer business needs and translate them into business requirements and the BI product

*Write custom reports using SQL and BI Tools (Toad, Pentaho PDI, Report Designer)

*Build file transfer interfaces using Pentaho PDI

*Build reports, dashboards, and other data tools that enable self-service for business users

*Collaborate with developers and subject matter experts to establish technical vision and analyze tradeoffs

between usability and performance needs

*Show a keen eye for detail and the ability to adhere to deadlines within a fast-paced environment

*Participate in testing products and processes to identify requirement defects, to meet standards, and to ensure *effectiveness

*Provide system documentation and relevant data dictionary for help with data quality or data access performance issues

Technical Environment:

PostgreSQL 9.0, PGAdmin 1.4 TOAD 8.1, Pentaho PDI (Kettle) Pentaho Report Designer 7.2-8.3

Pivotal Tracker, Microsoft Office

GSIG REO Brokerage, Boca Raton, Florida - Real Estate Sales Agent 03/09 – 07/12

*Oversee the advertising of properties for web & print media

*Communicated with clients to understand their needs and preferences

*Created property reports for clients

*Coordinated appointment schedules with prospective buyers and sellers to show them properties

*Prepared purchase and leases contracts packages for clients

*Administered bulk purchase of properties for investor clients.

*Negotiated sales and leasing terms between buyers, property owners and listing agents

*Acted as liaison between Buyer’s and Title Company’s and Attorney’s to facilitate the closing of properties

*Ensured that the legal formalities are completed prior to closing dates

*Performed BPO analysis for Bank Asset Managers

*Detailed knowledge of FL Real Estate Laws and procedures concerning sales and leasing of properties

*Detailed knowledge of South Florida Real Estate Market and Trends

*Analyzed sales and leasing trends to determine marketing strategy

*Conducted marketing activities to generate client leads

Technical Tools:

Microsoft Office, Adobe Acrobat Pro Extended

Philips Electronics, Palm Beach Gardens, Florida – Contract Systems Analyst/Developer 09/08 – 03/09

*Developed conversion processes for migration from PeopleSoft the ADP Global View.

*Developed/ Maintained PeopleSoft SQR process for HRMS, Benefits Administration, and Payroll.

*Developed/ Maintained Unix Shell Scripts for Batch Processing.

*Developed/ Maintained PeopleSoft online applications for HRMS, Benefits Administration, and Payroll.

*Developed/ Maintain PeopleSoft PeopleCode applications for HRMS, Benefits Administration, and Payroll.

*Investigate and troubleshoot production issues relating to PeopleSoft’s HRMS, Benefits, Payroll processing.

*Troubleshoot PeopleSoft SQR programs currently in production

*Troubleshoot PeopleSoft PeopleCode currently in production.

*Troubleshoot PeopleSoft Online applications currently in production.

*Develop Ad hoc SQL queries per department requests.

Technical Environment:

Oracle 10G, PeopleSoft 8.8 HRIS, system (North American Payroll, Benefits)

PeopleTools (8.47) App Designer, PS Query, SQR, PeopleCode, TOAD, ADP Global View

Jarden Corporation, Boca Raton, Florida – Systems Analyst/Developer 08/07 – 08/08

*Developed/ Maintained PeopleSoft online applications for HRMS, Benefits Administration, and Payroll.

*Developed/ Maintain PeopleSoft PeopleCode applications for HRMS, Benefits Administration, and Payroll.

*Developed/ Maintain PeopleSoft Application Engine processes for HRMS, Benefits Administration, and Payroll.

*Investigate and troubleshoot production issues relating to PeopleSoft’s HRMS, Benefits, Payroll processing.

*Troubleshoot PeopleSoft SQR programs currently in production

*Troubleshoot PeopleSoft PeopleCode currently in production.

*Troubleshoot PeopleSoft Online applications currently in production.

*Troubleshoot PeopleSoft Application and Batch servers.

*Troubleshoot Application Messaging /Integration Broker issues.

*Develop Ad hoc SQL queries per department requests.

*Perform on call production support rotation.

Technical Environment:

Oracle 10G, PeopleSoft 8.9 HRIS, system (North American Payroll, Benefits)

PeopleTools (8.47) App Designer, PS Query, SQR, PeopleCode, TOAD

Office Depot, Delray Beach, Florida – Systems Analyst/Developer 08/06 – 08/07

*Technical Lead for the Smith Barney stock administration system interface.

*Developed/ Maintained Global PeopleSoft HRMS processes.

*Developed/ Maintained PeopleSoft online applications for HRMS, Benefits Admin, and Payroll.

*Developed/ Maintain PeopleSoft PeopleCode applications for HRMS, Benefits Admin, and Payroll.

*Developed/ Maintain PeopleSoft Application Engine processes for HRMS, Ben Admin, and Payroll.

*Investigate and troubleshoot production issues relating to PeopleSoft’s HRMS, Benefits, Payroll processing.

*Troubleshoot PeopleSoft SQR programs currently in production

*Troubleshoot PeopleSoft PeopleCode currently in production.

*Troubleshoot PeopleSoft Online applications currently in production.

*Troubleshoot PeopleSoft Application and Batch servers.

*Troubleshoot Application Messaging /Integration Broker issues.

*Develop Ad hoc SQL queries per department requests.

*Perform on call production support rotation.

Technical Environment:

Oracle 9i,10G, PeopleSoft 8.9 HRIS, system (North American Payroll, Benefits)

PeopleTools (8.47) App Designer, PS Query, SQR, PeopleCode, TOAD

IAP World Services, Cape Canaveral, Florida – Systems Analyst/Developer 09/05 – 08/06

*Developed/ Maintain HRMS, Benefits Administration Payroll Interface processes.

*Developed/ Maintain PeopleSoft page applications for HRMS, Benefits Admin, and Payroll Interface.

*Developed/ Maintain PeopleSoft PeopleCode applications for HRMS, Benefits Admin, Payroll Interface.

*Investigate and troubleshoot production issues relating to PeopleSoft’s HRMS, Benefits, Payroll processing.

*Troubleshoot PeopleSoft SQR programs currently in production

*Troubleshoot PeopleSoft PeopleCode currently in production.

*Troubleshoot PeopleSoft Online applications currently in production.

*Troubleshoot PeopleSoft Application and Batch servers.

*Troubleshoot Application Messaging issues.

Technical Environment:

Oracle 8i,9i PeopleSoft (HRMS, Benefits Administration Payroll Interface) 8.8

PeopleTools (8.4) App Designer, PS Query, SQR, PeopleCode,Crystal Reports, TOAD, Helpstar

Spherion Corporation, Ft Lauderdale, Florida – Contract Systems Analyst/Developer 03/04 – 3/05

Assigned to the Spherion’s Project Meteor – PS Level 2 Support Team.

*Investigate and troubleshoot production issues relating to PeopleSoft’s Front Office processing.

*Investigate and troubleshoot production issues relating to PeopleSoft’s HRMS processing.

*Investigate and troubleshoot production issues relating to PeopleSoft’s Time and Labor & Payroll processing.

*Developed SQR programs for Payroll processing requirements

*Troubleshoot PeopleSoft SQR programs currently in production

*Troubleshoot PeopleSoft Cobol programs currently in production

*Troubleshoot PeopleSoft Application Engine programs currently in production.

*Troubleshoot PeopleSoft PeopleCode currently in production.

*Develop Ad hoc SQL queries per department requests.

*Perform on call production support rotation.

Technical Environment:

UDB DB2/6000, PeopleSoft HRMS 8.3 (Base Benefits, Time and Labor, Payroll ) Front Office 8 Vantive, Rational ClearQuest PeopleTools 8.3 & 8.44(App Designer, Query, App Engine), PS COBOL, PS Query, SQR, Crystal Reports,WinSQL,

QCI Inc., Des Moines, Iowa – Contract Systems Analyst/Developer 08/03 – 11/03

Assigned to the ADP’s West Des Moines facility for open enrollment season

*Created /modified ADP‘s HRizon/ PeopleSoft SQR to clients open enrollment requirements

*Tested/ debugged newly developed and existing HRizon/ PeopleSoft SQR programs currently in production

*Modified/Developed Unix shell scripts processes to comply with system changes.

*Performed data validation checks to ensure data integrity during and after testing

Technical Environment:

Oracle 8i, Unix, SQR, SQL, TOAD,,HRizon, PeopleSoft Benefit Admin 7.5, PeopleTools 7.5, PVCS

Heartland Community College, Normal, Illinois – Database Analyst/Developer 11/01 – 4/03

Implemented PeopleSoft’s HRMS/Base Benefits 7.6 system:

*Participated in fit gap analysis of legacy system and PeopleSoft HRMS w/ functional users to determine business processes.

*Participated in installation table configuration for PeopleSoft HRMS per functional users requirements.

*Set up and loaded PeopleSoft HRMS Control Table data in system (ie. Job Codes, Dept Codes, Position Mgt Info).

*Exported, converted, corrected employee data from legacy system.

*Coordinated Database creation and backup procedures for new PeopleSoft HRMS environment.

*Coordinated set-up of Application Server for new PeopleSoft HRMS environment.

*Developed SQA processes to load employee data into HRMS system.

*Researched and resolved PeopleSoft HRMS employee data loading errors.

*Performed data validation checks to ensure data integrity during and after loading.

*Trained HR staff in the navigation and functionality of the HRMS system.

*Test and debug newly developed and existing programs currently in production.

*Gathered requirements from HR staff for reporting requirements.

*Created SQR reports for HR reporting.

*Created run controls tables & panels for HR SQR reports.

*Setup daily processes for HR reporting tables.

*Researched and resolved PeopleSoft HRMS system errors.

Preliminary Implementation PeopleSoft 8.4 General Ledger System:

*Participated in Financial fit gap analysis w/ functional users.

*Participated in Financial installation table configuration.

*Participated in control table set-up

*Developed queries for data control table validation checks.

*Researched and resolved GL installation system errors.

Worked on PeopleSoft’s Student Administrations 7.6 system:

*Trained SA staff in the navigation and functionality of the SA system.

*Gathered requirements functional users for reporting and system enhancements.

*Developed SQR/ Crystal reports/ process per functional user’s requirements.

*Enhanced existing SQR/ Crystal reports/ process, and per functional user’s requirements.

*Created run controls tables & panels for SQR processes.

*Created custom PeopleSoft panels to supplement HCC requirements.

*Developed SQL queries PS Query for adhoc reporting.

*Trained users in the navigation and functionality of the SA system.

*Researched SA system errors by running traces, researching run control logs, on SQR/COBOL/

Application Engine.

*Filed cases w/ PeopleSoft’s Global Support to resolve system issues.

*Applied & coordinated patches and fixes as needed.

*Setup daily processes on the Process Scheduler.

*Developed new / maintained existing HCC ASP web pages to supplement SA system

deficiencies.

Other:

*Lead programmer in the Educators Academy website re-engineering project.

*Created/Modified SQL Server 7/2000 Tables

*Created/Enhanced SQL Server 7/2000 DTS packages

*Established table relationships and Keys

*Maintained/Modified Access database applications

*Produced/Transmitted files for state reporting requirements.

*Provided on call support rotation

Technical Environment:

SQL Server 7 & 2000 Enterprise, SQL, PeopleSoft SA 7.6, HRMS 7.6, GL 8.4., PeopleTools 7.6 & 8.4, PS Query,

Process Scheduler, SQR, Query Analyzer, Access, ASP, VBScript, HTML, JavaScript, Visual Studio,

SQA Robot, PeopleCode, Crystal Reports.

HITS, East Peoria, Illinois – Oracle Analyst /Developer 05/01 – 11/01

Assigned to the AES, Power Direct/Cilco - Database Conversion project

*Analyzed data conversion maps.

*Developed PL/SQL procedures Oracle Procedure Builder.

*Tested PL/SQL procedures.

*Performed data validation checks to ensure data integrity during and after loading

*Developed customized Oracle Forms for project

*Developed customized Oracle Reports for project

*Performed daily system ftp uploads.

*Developed SQL-Loader scripts to load data into the database.

*Developed ASP/Web based billing application to enhance functionality.

*Test and debug newly developed and existing programs currently in production.

Technical Environment:

Oracle 8i, AIX, SQL Server 2000, Enterprise Manager, Query Analyzer, ASP,VBScript, Visual Studio, SQL,

PL/SQL, Oracle Procedure Builder,, Oracle Forms 6i & Reports 6i, Oracle Developer/ Designer 2000

Metris Inc, Champaign, Illinois - Business Applications Analyst 05/99 – 05/01

Performed program conversions from mainframe processing to midrange processing environments.

*Designed, developed IBM OS/390 COBOL programs/processes.

*Enhanced, modified existing IBM OS/390 COBOL programs/processes to comply with system changes.

*Coded, enhanced IBM OS/390 JCL process as needed for system processing requirements.

*Designed, developed IBM AS/400 COBOL programs/processes.

*Enhanced, modified existing IBM AS/400 COBOL programs/processes to comply with system changes.

*Coded, enhanced IBM AS/400 CL process as needed for system processing requirements.

*Created, enhanced IBM AS/400 DDS definitions as needed for system processing requirements.

*Used AS/400 Query to create reports for internal departments.

Developed systems for RMS Group.

*Lead programmer for developing AS/400 based Lexis/Nexis information system.

*Lead programmer for developing multi-platform Credit Bureau information system.

Other:

*Test and debug newly developed and existing programs currently in production.

*Maintained/created System Documentation for existing/new OS/390 and AS/400 systems.

*Provided on call support rotation.

Technical Environment:

OS/390,AS/400, ISAM, DB2/400, TSO, ISPF, COBOL, COBOL/400, SQL,CL, JCL,IBM Utilities, FileAid, Panvalet,

Illinois State University, Normal, Illinois 1992 - 1999

MAPII - Systems Analyst/Developer 01/96 – 05/99

*Maintained and enhanced existing batch IBM OS/390 COBOL systems

*Maintained and enhanced existing online IBM OS/390 COBOL systems.

*Developed new batch IBM OS/390 COBOL programs/processes to support the new and existing system designs.

*Communicated with users to obtain information necessary for designs of new systems.

*Test and debug newly developed and existing programs currently in production.

*Documented system processes both new and old programs

*Provide assistance and training of new personnel and coop students and support co-workers as needed.

*Provided 24/7 on call support for assigned systems.

Technical Environment:

MVS, OS/390, VSAM, DB2, CICS,COBOL, JCL, TSO, ISPF, IBM Utilities,QMF/Spufi, SQL, REXX, Code-1,

EDI

PSPI – Database Systems Analyst/Developer 07/94 – 01/96

*Interfaced both internal and external organization to provide Alumni Information requests.

*Developed adhoc reports using IBM DB2 Query Management Facility (QMF) interface.

*Maintained and enhanced existing reports using IBM DB2 Query Management Facility (QMF) interface.

*Developed online screens using REXX.

*Performed system access security for new/current users.

*Performed on-site training of new/current users of functional interface of the Alumni Information System

*Performed system integrity/maintenance.

Technical Environment:

MVS, DB2, CICS, TSO, JCL, ISPF, QMF/Spufi, SQL, REXX,Code-1

Education:

Bachelor of Science Computer Information Systems, May 2001

Illinois State University, Normal, Illinois

Bachelor of Science Financial Management/Industrial Marketing, May 1989

Southern Illinois University, Carbondale, Illinois

Associate of Science in Business and Liberal Arts, May 1986

Lincoln Land Community College, Springfield, Illinois

Technical Training:

PeopleSoft University Certificate of Completion

General Ledger 8.4 11/02

PeopleTools II 8.4 11/02

PeopleTools I Delta 7.6 to 8.4 11/02

Human Resources 7.6 03/02

Intro to Benefits 7.6 03/02

PeopleTools I 7.6 12/01

Contact this candidate