Sales Management

LINDA A. GECEWICZ - TROTT

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

Canton, Georgia 30115

770-***-**** or 404-***-**** (*******@*********.*** )

OBJECTIVE: Experienced software engineer with extensive industry experience seeks opportunity to use strong analytical, technical,

project management and people skills.

SUMMARY: Particular strength and knowledge in ERP and Database Applications used in an analytical and dynamic business

environment. Experience includes design, development and implementation of enterprise applications, data warehouse and relational/4th

generation databases including core Financials, Payroll, HR, consolidation, reporting, modeling and analysis and extensive conversion and

interface experience. Technically proficient in PeopleSoft including Financials, HR and Front Office. People Soft 9.0, People Tools 8.49

Application Designer, PeopleCode, Process Scheduler, Application Engine, Component Interface, Web Service Calls, Data Mover, Work

Flow, SQL/SQR, DB2 for z/OS, ORACLE 9.01, UNIX Scripts, ADP Enterprise, Windows MS Office, Crystal, Appworx Enterprise

Scheduling, Mercury Quality Center. Client - Server technology. Mainframe Legacy Systems including VM/CMS, z/OS, JCL, NOMAD

EDUCATION: MBA, Finance - Hofstra University, New York, 1989

BS, Accounting - State University of NY at Albany, New York, 1982

EXPERIENCE

6/2008 –Present: Independent Consultant, SOUTHERN COMPANY, Atlanta, GA

PeopleSoft technical consultant participating on the PeopleSoft 8.8 to 9.0 Upgrade for Payroll and HCM including fit gap analysis for on line

and batch objects. Test plans, testing, development of customizations for online Components and objects, Component Interfaces, Business

Interlink, Web Services and batch objects including SQR reports and in/outbound interfaces, Cobol and Unix shells.

1/2008 –May 2008: Independent Consultant, AFFILIATED COMPUTER SERVICES (ACS), Atlanta, GA

PeopleSoft technical development of interfaces from third party vendors to streamline Glaxo Smith-Kline’s new hire recruitment, transfers,

promotions and position management activities. Developed Application Engine jobs and Component Interfaces to load recruits, position

changes, promotions and transfers. Performed unit testing and assist in system testing, script development, execution, technical trouble

shooting and resolution. Participated in weekly project management meetings to establish and monitor project tasks, milestones and identify

risks. Provided weekly status reports and updates to the issues log to identify issues, assignment and resolution expectations.

10/2007 – 1/2008: Independent Consultant, RANDSTAD USA, Marietta, GA

Developed and tested a custom online time entry and approval system for 1099 contractors including, PeopleCode, Application Engine, and

SQR interface development. Wrote batch interface to the Cisco CRS phone time entry system to provide online HR and customers review

and approval of 1099 timesheets from multiple sources. Developed batch timecard creation program which created invoices for 1099

contractor timesheets used as input to the Billing system. Collaborated with functional team and other technical consultants to successfully

gather requirements, communicate issues and risks, build and test the new 1099 application.

5/2007 – 10/2007: Independent Consultant, AFFILIATED COMPUTER SERVICES (ACS), Atlanta, GA

PeopleSoft Technical Developer for ACS on it’s “Lift and Shift” implementation of Glaxo Smith Kline’s (GSK) PeopleSoft HR

application. Identification of high risk application architecture iand setup alternative archtecture for the hosted application including UNIX

directory setup, source code, database links and the Appworx job scheduler. Configured Appworx users, security and jobs for ACS

developers and testers. Performed unit and system testing, to troubleshoot issues and implement resolutions. Teamed with the PeopleSoft

Version 9x Upgrade team to create compare report analyses to identify all GSK customizations and new PS objects in the current version

and use fit/gap analysis to assess version 9 functionality relative to the business requirements. Supported all ACS testing including HR,

payroll and benefit jobs and interfaces.

1/2007 – 5/2007: Independent Consultant, ACCENTURE, Atlanta, GA

PeopleSoft Technical Developer working for Accenture on a $1B contract with Unilever to globally outsource HR functions and operations

under its “One Unilever” initiatives. Responsible for Employee Self Service redesign and customizations providing a more robust ESS front

end. The Global ESS solutions development included creation of customized components, pages, peoplecode, test plans for unit testing and

user system testing. Developed SQR interface and report programs including the SAP to Peoplesoft Payslip PDF file Interface to load

payslip images to PeopleSoft for user viewing. Analyzed source and target platform to identify file transfer, storage and management

alternatives. Technical development included UNIX system calls for file management and front end PDF Employee Payslip displays

through Employee Self Service hyperlinks.

6/2006 – 1/2007: Independent Consultant, RANDSTAD USA, Marietta, GA

Responsible for ongoing development of data warehouse interfaces and reports including data extracts from HR, Front Office and Financial

applications to enable key performance indicator analysis and tracking including the creation of the Operational Activity Report. Teamed

with the Hyperion BI technical team to develop PeopleSoft revenue, cost and customer extracts and hierarchies and the development of

multi-dimensional OLAP cubes to support corporate information analysis, dashboards, scorecarding, data integration, business event

management, and reporting. Participated in the implementation and development of new corporate holiday and service bonus business

process and payroll application providing a more consistent, objective and systematic policy providing a cost savings in excess of $10M.

Used a fit/gap analysis to identify and implement the best practice business solution. Created custom People Tool projects, tables,

components and SQRs that automatically check employee eligibility and create PS payroll holiday or bonus pay lines for eligible employees

if all eligibility requirements are met. Developed and delivered self service portions of this program for talent to track and manage their

hours

9/2004 – 5/2006: Independent Consultant, ADP Inc. Alpharetta, GA

Clients include: Case New Holland, Hormel, Allegheny Technologies, Spirit Aerosystems, EG&G/LSI

Collaborated with technical and functional team members to develop and execute the conversion of several Allegheny Tech locations and

systems including Ceridian and PCPW to the ATI enterprise wide system. Provided business analysis for conversion of each location

including development of data mapping, translation, and control and validation procedures . Created SQR conversion programs to map and

convert payroll information into delivered HR core tables and customized Enterprise tables including client documentation, data validation

and verification. Developed plant payroll inbound and outbound SQR interfaces including processing changes for application to process and

track payroll for Canadian pay groups. Wrote inbound and outbound interfaces for corporate offices for quarterly and year end

consolidation and control reporting. Inbound and outbound Worker’s Compensation interfaces to trace employee worker’s compensation

cases.

3/2003 –9/2004: Technical Consultant, ADP, Alpharetta GA

Technical team member on ADP Enterprise client automation project. Implemented automation parameters, scripts and error handling

procedures for new client’s customized payroll front ends, reports and interfaces. Reengineered existing client’s payroll SQR processes

including inbound and outbound interfaces to conform to automation and error handling standards.

7/2000 – 2/2003: Technical Consultant, INTERCONTINENTAL HOTELS GROUP, Atlanta, GA

PeopleSoft Financials technical design and development in a DB2 for z/OS environment. Customized GL, AP and AR modules including

PeopleSoft Application Engine processes for voucher edit/post/pay, stored statements, SQR, people code, Process Scheduler and batch JCL

Process Scheduler shells. Developed, implemented and completed the GL conversion of European/UK Hotel Financials from JD Edwards,

SAP Hyperion and ACOM using batch FTP, SQR and Data Mover scripts to map and load all GL data. Developed GL interfaces for periodic

inbound/outbound actual, budget and forecast data for Hyperion, Adaytum, ACOM and SAP systems. Modified GL and AP interfaces and

spreadsheet uploads including data translation, AP control groups, EDI mapping, voucher load and edit batch jobs.

3/1999 – 7/2000: Technical Lead, THE HUNTER GROUP, Atlanta, GA

Managed the delivery of PeopleSoft 7.5 customizations and support relating to the State of Georgia DOAS PRISM project. Developed

PeopleSoft customizations to Order Management, Billing, Inventory and Projects modules including customized PeopleSoft tables, people

code, process scheduler definitions and components. Responsible for quality control reviews, approvals and scheduling of technical

PeopleSoft projects and migrations. Teamed with client management and DBAs to prioritize development, upgrades and fixes.

Programmed interfaces between PeopleSoft and third-party software vendors such as Peregrine including technical specifications, program

development using SQR and Process Scheduler. Created legacy system data conversion SQR programs including data mapping, validation

and documentation.

9/1998 – 3/1999: Senior Consultant, THE HUNTER GROUP, Atlanta, GA

Member of the development team at State of Georgia DOAS for its PHOENIX PeopleSoft Financials implementation. Participated in the

implementation Asset Management, Purchasing and Accounts Payables modules and Bank Reconciliation processes for over 78 state

agencies. Worked with development team and users in identifying user requirements and coordinating development activities. Provided

technical development and support of batch and online customization and People Tools objects including panels, panel groups, menus,

process definitions, messages, queries, records, fields, indexes, people code and translate values. Provided administration, reporting,

analysis and support including SQR, Crystal and PeopleSoft Queries and SQR/Infopac interfaces for report collection and distribution.

Developed inbound and outbound data interfaces to and from other client source systems. Developed batch conversion programs and

performed data conversions including translations, reformatting, parallel testing, data verification and project management

9/1997 – 9/1998: Systems Consultant, BELL SOUTH CELLULAR, Atlanta, GA

Revenue Accounting Systems design, development and support in NOMAD DB2 for z/OS environment. Developed and maintained new and

existing batch and on-line data interfaces feeding revenue and accounting information from corporate transaction systems. Developed SQR

programs to create monthly accounting transactions, postings, reports and perform data reconciliation. Developed and maintained General

Ledger transaction interfaces for the JD Edwards System. Identified Y2K exposure and developed system modifications and test plans.

Performed Y2K testing in a parallel testing environment. Developed procedures and interfaces to support the convergent billing effort

combining cellular and land line billing.

9/1996 – 9/1997: Systems Consultant, CERIDIAN, Atlanta, GA

Participated in the development and delivery of a table driven relational payroll reporting system using NOMAD/DB2 and SQL. Developed

and maintained data interfaces from the Tesseract system to the summarized reporting system providing summarized payroll data including

earnings, taxes, benefits and deductions. Optimized batch payroll system performance and tuning in NOMAD/DB2, SQL and job flow.

Developed programs and converted DB2 table driven client payroll profiles and dynamic reporting to COBOL using Tesseract files and

batch utilities for data access and reporting in order to improve payroll turn-around time from 20-30 hours to about 3-4 hours.

2/1994 – 12/1995: SOUTHERN COMPANY, GEORGIA POWER and GULF POWER, Atlanta, GA

Conversion of legacy HR Employee Information System from NOMAD/VM to PeopleSoft/DB2 environment including development of

legacy extracts and SQR load programs. Parallel system testing, data validation and report verification. SQR/SQL and SQLTalk procedure

development to access, PeopleSoft HR reporting including organizational, job-related, payroll, benefits and benefits plan reporting.

PeopleSoft ad hoc report generation using Query and SQR/SQL to perform comparison analysis and reporting between market data/salary

surveys and internal employee information and transactions. Performed statistical reporting and EEO/Department of Labor compliance

reporting for HR management. Developed and implemented enhancements and modifications to the legacy HRIS relational reporting and

analysis database using NOMAD2/VM. Supported marketing systems including Industrial Billing System support, maintenance and

conversion to window-driven shared multi-user application including front-end server and user execs. Development and support of data

interfaces and reports for IT’s Project Management and Time Accounting Systems in NOMAD.

1/1993 – 12/1993: PFIZER, INC., Independent Systems Consultant, New York, New York

NOMAD application development for the pharmaceutical group’s Sales and Marketing Data Tracking, Reporting and Analysis Systems.

Developed user interfaces for on-line data access, updates and reporting. Developed, scheduled and monitored batch procedure for mass

maintenance activities. Developed enhancements to marketing systems for compliance with FDA marketing regulations. Supported and

performed periodic maintenance on multi-user multi-million record drug samples system used to manage sample distribution, representative

inventories and client transactions for numerous products across all corporate divisions. Supported and performed database maintenance and

enhancements to the Speaker System that tracks, manages and reports on doctor/speaker engagements, speaker rees, and speaker program

budgeting and invoicing.

5/1989 – 12/1992: MUST SOFTWARE INTERNATIONAL, Professional Services Consultant: Clients Include:

4/1992 – 12/1992: AMERICAN EXPRESS, TRAVEL RELATED SERVICES, New York, New York

Designed, developed and implemented a worldwide NOMAD/DB2 accounting/financial consolidations, reporting analysis and control

database in NOMAD/DB2 in a TSO environment including window-driven online user interfaces for GL submissions and JCL batch

processing. Developed batch accounting validations, reversals, correcting entries and processes that run as part of the GL submissions jobs

for worldwide business groups. Developed, tested and implemented DB2 performance improvements

11/1989 – 4/1992: GEORGIA PACIFIC CORPORATION, Atlanta, Georgia

Designed, developed and implemented the Printing Paper division sales and marketing databases in NOMAD/DB2 for management

reporting and analysis including price trend analysis, production planning, American Paper Institute reporting, merchant sales, customer

service support, metro area sales and freight distribution and mill performance. Developed and implemented data interfaces to load source

systems data into management databases

5/1989 – 10/1989: RHONE POULENC, New Brunswick, New Jersey

Developed a window-Driven user budget, planning and financial reporting and consolidations system in NOMAD in a VM environment.

User training course development and delivery. Developed User and System documentation manuals.

Primary Consultant for Technical Development and Support on an as needed basis at client sites:

AT&T, Basking Ridge, New Jersey, NABISCO, New Jersey Parsippany NJ

5/1988 – 5/1989: LEVER BROTHERS COMPANY, Manager, Forecasting, New York, NY

Established, developed and managed a PC based Physical Sales and Production Forecast System for the Food Division's $400M of consumer

sales used by operations and distribution for production, scheduling, capacity planning, inventory management, distribution, packaging and

commodity buying. Coordinated, evaluated, consolidated volume estimates from Sales, Marketing and Operations departments. Primary

liaison between Finance and Data Processing for financial data and reporting requirement. Performed special projects for the VP of

Finance/Controller.

4/1983 - 5/1988: EMERSON ELECTRIC CO., Information Center Consultant, Long Island, NY

Designed, developed, implemented and managed cost effective user applications for flexible analysis, reporting and consolidation using 4th

Generation mainframe and PC databases and technologies. Primary liaison between Data Processing and functional user groups provided

software consulting assistance. Developed and delivered software and applications training to users in Finance, Marketing, Personnel and

QA. Developed and performed software evaluations and feasibility studies designed to formulate management information requirements

and strategies. Evaluation resulted in the purchase of NOMAD and the formation of a Corporate Information Center. Developed and

implemented a consolidated system for reporting and analysis of backlog, new business awards, gross profits and manpower planning, cash

forecasting, overhead budgets and progress billing preparation.

1981 – 1982: IBM, Administrative Account Representative, Albany, NY

Administered Cash Applications, resolved customer conflicts regarding AR, investment tax credits and rental billings for the Northern NY

branch. Acted as liaison between branch management, customers and field engineers. Performed special projects for Branch Manager and

Sales Reps

Contact this candidate