Sam Castillo Email & Phone Number

New Braunfels, Tx, Us

• Provide vision, leadership, direction, oversight and support for all Human Resource Information Systems including payroll, benefits, recruiting, onboarding, talent management and training. • Manage all operational aspects of the Human Resources information process.• Ensure timely and accurate processing, and reporting analysis with documented HR data.• Maintain current knowledge of business including, vision, goals, direction and strategy to provide meaningful reporting analysis aligned with business needs.• Review existing system of record utilization, and develop recommendations for process improvements to maximize the system functionality and user productivity.• Act as project lead for Cornerstone LMS project working with senior business leaders to ensure content validity.• Lead the paperless conversion of the benefits department to include data capture that is compliant with the Healthcare Reform Act.• Access the recruiting module to streamline the application and candidate screening process to provide managers a more targeted list.• Partner with technology resources to support upgrades, testing and other projects.• Collaborate with Chief Legal Officer to ensure database configuration and management reporting maximizes the system as well with recruiting, benefits, payroll to ensure compliance with all regulatory agencies.

Key Projects:• Develop business requirements as needed for HR and Payroll HRIS Systems. Requirements include both business process requirements and business rules governing data management and interfaces. • Responsible for business analyst support for the configuration and customization of the Time and Attendance, HR and Payroll System.• Architected, designed and developed interfaces to pass demographic data between the HRIS systems to third party vendors.• Lead efforts in the creation of application and training materials for end-users.• Develop project charter, schedules and presentations for project management materials.• Responsible for the design and development of analytic and transaction data structure for large HR/financial data sets with Excel.• Lead the implementation of Comdata, a third party company used for payroll cards.

Irving, Texas, Us

• Successfully managing a HRIS Team consisting of programmers, administrators and Report Writers.• Responsible for writing technical, functional specifications for the system life cycle of a project. This includes planning documents, design documents, technical documents and test plans.• Created and established testing and documenting Sarbanes–Oxley compliance controls for the use our enterprise solutions. This includes the creation of quarterly Attestation Reports for all levels of management.• Lead short-term and long-term enterprise wide strategy and planning efforts to define and deploy additional HR applications (third party systems and/or internal systems) while managing key stakeholder relationships with management sponsors, internal users, and external business partners.• Primary liaison with HR leadership for entity planning and implementation efforts. Coordinate on-going entity project training and testing needs.• Worked collaboratively with key stakeholders to determine areas of optimization deconstruct issues and develop a solution approach.• In partnership with IT, Accounting/Payroll and other key operational departments, designing, integrating, delivering and evaluating all core HR Information Services and transactions regarding internal employees including Compensation, Benefits, Leave Management, Performance Management/Talent Management, and applicant tracking etc.

Arlington, Tx, Us

• Created and maintained a Purchasing application that created over 50 million dollars on the first year of usage by the Purchasing Department. The application keeps track of bided building materials used to build a home. • Manage the rollout of customized Payroll and Benefits SQR reports to end-date benefits deductions and stop direct deposits accounts.• Managed a team to implement an aggressive time line given by Human Recourses to upgrade from PCPW to ADP Enterprise 4. The upgrade consisted of a new production environment, new testing environment and new development environment. The three new environments also required a separate ACOMM server to process manual checks for payroll.• Managed the handling of all client inquires for ADP proprietary software issues and interfaces including Lotus Notes.• Managed and implemented modifications to the ADP 4 Enterprise application using the E-Builder, E-Code, Tree Manager, Query Tool, Report Smith, SQR, Process Monitor, Process Scheduler, Data Mover, Import Manager, Security Administrator, and Object Security. As a Senior Programmer I was tasked to work on complex systems program analysis and systems development assignments. These tasks included standards, coding, testing, and documenting the changes.

Us

• Developed a Human Resources Policies and Practices Lotus Notes/Domino Intranet application used by 98,000 GTE employees. This application is used in conjunction with a Word template written in Visual Basic used for creating new or revised GTE Policies and Practices. The Word template is downloadable from the system to create a document and is routed from originator to a Focal Points to approve its contents. Once approved the word document is converted to PDF format and stored in one of twelve different databases.• Maintained CyberTrax – a wholesale Intranet application used at various intervals throughout the year in which GTE will receive orders from large backbone ISPs such as UUNet and ANS. CyberTrax has generates over a hundred million dollar in revenues where sales coordinators, technical support staff, engineers, network planners, and many other process participants to can share a single coordination point using Lotus Notes and the Intranet via Domino. Its inventory management features help coordinate the need for new equipment with new capacity requested by GTE’s customers. Its reporting features help management track sales growth and improve the overall process by identifying key points of success and failure. CyberTrax is a key enabler to GTE becoming the industry leader in providing these services.

Oceanside, Ca, Us

• Developed an Employee Phone Program Database that facilitates a streamlined process expected to save PrimeCo approximately $800,000 annually. The database is a user-friendly application complete with workflow used to automate and improve the timeliness from the previous manual process. Employees are allowed to order new digital phones and accessories once every three years if certain criteria’s are meet. Once an order is submitted in the database, a database administrator can approve or decline an order and notify the submitter with a status electronically. • Designed and developed a database used by Human Resources to track all new and current employees’ personal information. This database has one front navigator that links to fourteen different databases. One of the databases is a Job Posting Database with a build-in internal job application with direct data dump from PeopleSoft. This database is a complete workflow database allowing the submitters current manager to approve or decline their application then route an application to Human Resources, and finally route to the Hiring Manager to approve/decline or hire the applicant.

• Prepared instruction materials, supervise classrooms, teach/evaluate students. • Prepared in and conducted parent-teacher conferences, advising parents on student’s progress and how to best reinforce education. • Served as mentor and role model in assisting students to reach their goals.• Prepared instruction materials, supervised classrooms, and taught/evaluated students.• Emphasized building self-esteem and character through developing realistic expectations and high standards.