• Analyzed existing ADP provided product, client Data and business processes to recommended appropriate solution(s).
• Consult directly with Clients and Vendors to implement the agreed upon solution(s) for their existing ADP product.
• Create service request tickets in order to send files to development for configuration changes or creation of client file.
• Serve as a trusted advisor to clients to analyze specific Vendor to Client File layouts to provide a job estimate/quote to the client for their change request.
• Serve as a subject matter expert for ADP provided products/solutions to further APD’s business development goals and promote high level customer satisfaction.
• Used SFTP/FTP internal system tools to imported and pushed files to assigned third party vendor servers per client agreements.
• Use ADP internal tool that allows data extraction to produce files to send to other systems. Examples include delimited files to vendor or client with options of csv, pipe delimited, tab delimited, fixed width, etc.
• Manage various amounts of projects with full ownership of setting up client meetings, setting deadlines and target dates throughout the implementation process.
• Consult with clients and vendors to understand data requirements and vendor file layouts in order to translate data and create file.

• Reviewed analysis documents prepared by the Defined Contribution Client Technology Analyst and configured plans based on client request/change. Completed high level testing to ensure no defects are in the code.
• Executed test plans through various phases of testing.  Created test participants and performed various scenarios to make sure all expectations are being met.
• Reviewed all configuration accurately to make sure results reflected requirements, and has zero negative impact to existing provisions.
• Analyzed issues/defects and debugs the system when configuration is not producing expected results.
• Researched issues to determine if source of error is within the test data, test plan, or configuration.
• Reviewed all configuration and issues before migrating changes from Test environment to production.

• Created and executed test scripts, cases, and scenarios to ensure applications meet business requirements fulfill end-user requirements, and identify systems issues.
• Worked with Lead Programmer Analyst (LPA) and the Benefits Service Manager to clarify per client plan requirements
• Analyzed client data requirements and vendor file layout to accommodate any issues or changes needed per client request.
• Used SFTP/FTP internal system tools to imported and pushed files to assigned third party vendor servers per client agreements
• Assisted with the deployment (or migration) of new files and/or system updates into the production environment.
• Coordinated the work of aligned setup analysts, monitor task completion, and communicate team schedule and status.

Details of Daily task consist of:

1. Using SQL language to write queries to pull information or perform specific functions in our DB2 database.
2. Using Statistical Analysis System (SAS) language to pull participant data information and create SAS jobs in our Mainframe system.
3. Using Job Control Language (JCL) in our Mainframe environment to run client specific batch jobs.  JCL is a script language that is used on Mainframe operating systems.

• Understanding Healthcare Plan Requirements and having in-depth knowledge of Health Benefits per client customization.
• Responsible for configuring and testing files against our proprietary Core Benefit Administration (CBA) System based on analysis documents of client requirements.
• Configuring involved using graphical user interface tools to customize code to fix system defects or update the system per change orders
• Supported production environment (defects/issues) and executed workflow and defect management.
• Executed test plans through various phases of testing.  Created test participants and performed various scenarios to make sure all expectations are being met.
• Analyzed client data requirements and vendor file layouts and translated those requirements into file interface specifications to begin implementation.
• Used SFTP/FTP internal system tools to imported and pushed files to assigned third party vendor servers per client agreements.