Developer Customer Service
Resume:
Todd D. Wonnell
Coconut Creek, FL 33073
*******@*****.***
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