Xerox HR Services became a separate company, Conduent.

Buck HR Services moved under Xerox HR Services

A third party benefits administrator for Health and Welfare (H&W), Defined Benefit (Pension) and Defined Contribution (401k) plans. (Note: ING decided to exit the H&W administration business as client contracts end) •Created detailed requirement documents for both internal and external audiences.•Performed data analysis. Created simple to complex SQL queries.•Documented technical system and database type requirements, set-up processes, and wrote various post set-up verification queries.•Conducted various issue research and input resolution – both for the overall system/processes and at the participant level.•Reviewed system code as part of issue resolution and/or technical documentation.•Actively lead and/or participated in discovery and design discussions.•Created test scenarios for use in validating system functionality meets requirements.•Worked with cross functional teams to gather requirements and to ensure client deliverables.

Led the delivery of core systems and client customization for assigned clients. Analyzed requirements, created functional and technical design specifications, created test scenarios and cases, and led development of database schema, database triggers, and event processing logic. Managed the analysis, diagnosis and resolution of reported issues.•Led the cross-client development of a baseline for proceses and code used to administer H&W plans.•Lead developer for implementation development team(s) - including assignment of tasks/work and mentoring.•Created and implemented standard design for Evidence of Insurability (EOI) processing and the overall election validation processes from requirements.•Developed standard table-driven eligibility determination, rate calculation and imputed income calculators, including coding of eligibility and rate calculators.•Designed, documented and coded core dependent eligibility verification routines.•Coded core Pension Document Management System data staging process, including hooks for client overrides.•Maintained a strong focus on code reusability and applicability across clients.•Demonstrated strong Sybase SQL skills including multiple table joins, sub-queries, case statements, unions, and group by and having clauses. Extensive experience with query analysis and optimization.•Recipient of IT Excellence Award, 2002.

Provided technical leadership, training, and direction to in-house and contract programming staff – also while migrating FBMC’s benefit administration system from a mainframe to client-server. Analyzed and improved FBMC’s client implementation and conversion process(es). Acted as a primary technical contact for clients and vendors/partners. •Demonstrated proficiency in PowerBuilder development including:-Use of non-visual objects as holders of business rules and processing standards (encapsulation). -Use of inheritance and customization of ancestor objects to create a more standard “look and feel” and a more standard development structure for programmers.•Extensive Sybase development experience including creation of complex triggers with multiple queries and table joins; creation of stored procedures and the integration of each into the PowerBuilder application.•Performed many DBA duties on a regular basis including: Creation/sizing databases, user accounts(groups, aliases, rights), ERwin diagram maintenance, definition of objects including tables, indexes, triggers, rules and of course stored procedures.•Designer/Developer of in-house inheritance structured base-class.•Performed data mapping from legacy system tables to Sybase Database tables. •Designed, documented and coded data migration stored procedures. Supervised and coordinated data/system migrations as client process was moved from mainframe.Lead Implementation Programmer •Led a team of programmers that handled all client benefit enrollments and related system customizations.•Created standards and documentation for implementation process.•Assigned implementation tasks to the team and assisted with design and coding of application customizations.•Direct contact with clients and insurance providers in all matters – including data exchange.•Designed, coded and implemented data-driven provider eligibility data export program.•Named “Employee of the Year” for 1991