Theresa A. Sembler
Port Washington, NY 11050
Home: 516-***-**** / Cell: (516) 313- 2555
Email: ********@*******.***
Summary
Extensive valuable experience working as a Programmer Analyst. Known for
ability to analyze and solve problems, work closely with management,
outside consultants, and project teams. Strong experience with conversions
of hardware and software programs, which includes testing, implementing,
writing of manuals and training users in new HR and payroll systems.
TECHNICAL SKILLS
> Database - IDMS (supports Cyborg), Oracle, Microsoft Access.
> Desktop - Excel, Word, Seagate Crystal Reports, Internet Explorer,
Microsoft Outlook, Zipitfast, SQL, Cobol, HTML, CSS, JavaScript,
Dreamweaver, ASP.NET 4.0, (C#)
> Operating Systems - Unix, IBM MVS,
> Client Server - Windows XP, 2007; MS DOS, Novell NetWare
EDUCATION
B.S. - Information Systems Management - 1988; YORK COLLEGE, Jamaica, NY
(Including post-graduate courses at Queens College in calculus and
Pascal)
Certificate - Website Programming - Hofstra University, Hempstead, NY
Expected completion date: December 2010
Additional Training:
> Cyborg Solutions Series: Human Resources Module, Benefits Module,
English Language, Flexible Benefits Module.
> Cyborg System Report Generator Training.
> PeopleSoft, PeopleTools 7.5 Query Basics, Excel, Word, Access,
Easytrieve.
> American Management Association: Writing Procedure Manuals,
Flexible Benefit Plans, and Business Writing.
EXPERIENCE
HRIS Coordinator
Pratt Institute, Brooklyn, NY: Sep 2005 - 2008.
> Implemented Time & Leave module on the Colleague System.
> Created Query Reports for Human Rescourses Department to gather
information on employee attendance to determine benefits and
provide part-time and full-time faculty workload information to
department heads.
> Trained HR Staff to interface with the Time & Leave Module.
> Investigated and evaluated Package Evaluation Strategy for Website
Recruitment and Performace Management software products.
Programmer Analyst
HUMANIC SOLUTIONS, Melville, NY: 2002 - 2004.
> Maintained savings, pension, and benefits interface file; modified
the English Language and COBOL programs, Seagate Crystal reports,
and SQL to comply with company plan rules.
> Worked closely with the client, third-party vendor, and service
team during testing to identify issues and recommend solutions.
> Participated in biweekly conference calls with the benefits team to
identify issues and determine actions to be taken.
Sr. Analyst, Computer Applications
BAE SYSTEMS, Syosset, NY: 1998 - 2002.
> Processed weekly payroll, applying tax updates and software fixes
to the system.
> Validated payroll register and verified general-ledger files that
were fed into Costpoint; provided EEO, salary and other reports for
Human Resources.
> Key member of Cyborg system migration team - VAX to Mainframe.
Wrote payroll procedure manual, trained staff to run payroll
onsite, provided technical support offsite.
> Worked closely with consultants to update Cyborg to version 3.0.
Tested pay runs and batch reports; modified Cyborg generators and
English language programs for Y2K code.
> Assigned to work with consultant to install Paybase 16 and
troubleshoot printing problems; trained payroll staff to use
application to print checks.
> Wrote JCL code to create direct deposit and payroll checks to a
file for Paybase 32; coordinated training classes for users.
> Performed year-end W2 processing, applied tax updates, created year-
end tax file.
> Appointed to key position on major project to convert from Cyborg
to PeopleSoft. Determined business rules and data mapping from
Cyborg to PeopleSoft. Created employee personnel data files and
payroll data files using COBOL language code for the payroll test
and production run. Participated in weekly conference call with
conversion team to identify issues and determine actions to be
taken.
Programmer-Analyst
CITY UNIVERSITY OF NEW YORK Research Foundation, New York, NY:
1997 - 1998.
> Team member on the Time and Leave project for Payroll and Human
Resources departments.
> Worked closely with Human Resources Director, Vice President of
Finance, Payroll Manager, and HR administrators to conduct an
analysis of the HR time and leave process.
> Analyzed testing and provided feedback on Time and Leave programs
designed by outside consultant.
> Evaluated changes to HRIS recommended by users.
> Programmed custom reports and online screens using English
language.
> Implemented benefits plan for pre-tax deductions.
> Resolved erroneous payroll deductions on benefits and savings file
interface.
Programmer-Analyst
GREENPOINT SAVINGS BANK, Flushing, NY: 1989 - 1997.
> Implemented the Cyborg Solutions Series and its Flexible Benefits
module.
> Developed programs for EEO compliance, benefits administration, and
other areas of Human Resources.
> Created procedure manuals; designed new hire forms used to update
Cyborg.
> Automated the merit review process, benefits open enrollment, and
EEO.
> Conducted the annual disaster recovery procedure.
> Trained staff in use of computer equipment.
> Troubleshot hardware and software problems; installed new software.
> Created and maintained payroll reports for statistical purposes.