Company Confidential o Analyze client’s requirements and create functional and technical specifications for a web site and database to support their proposed business model.o Analyze reporting needs model a data structure and create a normalized database and maintain referential integrity in PostgreSQL Modeled data from the existing database s store/Excel files into the redesigned database. Using ERDPlus Company Confidentialo Analyzed legacy HRIS systems and mapped to new Workday implementation.o Wrote extract and transformation code to extract data into a format which could be imported.

 Prepared benefit plans for clients in Swift, along with the import and export of client data. Devised tools in VB.Net & Microsoft Excel to provide support to client 1094-C and 1095-C Affordable Care Act (ACA) reporting.

 Rendered expert support to Banner system, an enterprise resource planning (ERP) for higher education within an Oracle 11g environment. Drafted reports, while aiding users through Access in preparing their own reports. Maintained and enhanced VBA inside Microsoft Access databases. Provided assistance in the integration of the Oracle Business Intelligence Enterprise Edition. Streamlined business processes for college administrative functions through the development of Microsoft Office automations.

 Managed all human resource information system (HRIS) for more than 4,000 employees across Canada and the United States. Drafted and disseminated audit and management reports, while developing custom integrations to 3rd party vendors using VB.Net and Oracle and administering the ADP to SAP data conversion and transformation project. Aided the yearly performance and compensation project along with the new company acquisitions and conversions. Offered expert support to technical aspects of the Human Resources Department. Established and monitored SLAs for SaaS vendors and was actively involved in resolving issues as they occurred. Worked with senior management to establish and automate KPI’s in regard to payroll, compensation, benefits, talent acquisition and the company wide performance management system. Notable Projects Project Name: SAP Implementation Role: Human Capital Management Data Lead Project Name: Defined Contribution/Defined Benefit Implementation Role: JP Morgan 401K and Pension Integration Technical Lead Project Name: Employee Benefit Portal Implementation Role: BenefitFocus Enrollment Integration Technical Lead Project Name: Performance Management and Evaluation System Role: Performance Management and Evaluation System Technical Lead Project Name: Organization Visualization and Management Role: OrgPlus Implementation Lead Project Name: Human Resources (HR) Reporting Role: Technical Lead and Developer

 Participated in a four-person development team, responsible for the creation of a Windows- based Payroll and HR product utilizing various development languages, such as VB.Net, VB6, Crystal Reports, Microsoft SQL Server, and Microsoft Access. Conducted interviews with customers on the creation of custom add-ons and interfaces, while devising the required functions, technical specifications, and test scripts. Demonstrated expertise in FinalBuilder and InstallShield Developer through the design and maintenance of an automated build process and installation package.

Performed Y2K testing and remediation of MS Access applications.Performed maintenance and enhancement of existing MS Access applications used by Auto Finance, Mortgage Marketing, Human Resources.Built MS Access applications used by the internal sales division and the Y2K project.

Claims, Underwriting, Complaince, IT