Summary:

Human Resources Consultant/HRIS Analyst/IT Project Manager with strong functional and technical skills with the ability to lead a team to project completion or function as an individual player. Expert Business Analyst that improves IT systems and business processes. Versatile IT expert with ability to quickly understand companies workflow, implement systems and exploit databases for ample reporting.

Skills:

Certified as Oracle HRMS EBS Implementation Champion

• Project Management: Oracle AIM and PM Methodology, including critical path analysis, MS Project and Visio.
• ERP MRP: Proprietary, Platinum ERP and Oracle 11i: HRMS, OTA, OTL, ESS, Finance set up and load such as: Chart of Accounts, Multiple Currencies and Set of books. Interfaces with HR legacy systems. ADP Payroll, CBIZ Millennium.
• DBMS: Btrieve, Informix, RBASE, MS Visual Foxpro, Clarion, MS Access, SQL Server, Oracle, Oracle PL/SQL
• System Administration and Support: Windows NT, Windows 2000, AS/400
• Networks: Implementation, cabling, connection hubs/switches/firewalls, workstation/server set up, administration, monitoring, etc.: Netware, Windows NT, Windows 2000. SPX/IP, TCP/IP, Appletalk, AS/400. Intranet, Internet
• Reporting Tools: COGNOS, Crystal Reports, Xtrieve, ADP Report Smith, Oracle Discoverer, SQL Reporting Services SSRS
• Programming: Excel Macros, ODBC connection for Excel report rendering, MS Visual Basic, C , Excel Macros. HTML and ASP.NET 1 2 Web programming. Oracle PL/SQL. MS SQL Server T-SQL stored procs, functions, advanced queries, etc. .
• Mainframe: Tower, HP 3000, VAX 750, AS/400.
• Operating Systems: UNIX, MPEV, BMS, AS/400, MS Windows 95-98, NT, 2000, XP, Vista 7.

Experience:

Confidential

Specific Responsibilities:

• Partner with Payroll, Benefits, Accounting, Training, IT, and third party providers to understand business objectives and provide reporting and ensure successful interfaces.
• Document workflows and processes.
• Develop and implement end-to-end solutions in a timely, accurate, and collaborative manner.
• Develop and maintain a set of standard queries and reports for end users to run design and build new reports as needed ensure HRIS data integrity and confidentiality.
• Continually educate and train key users on system and reporting functions.
• Prioritize departmental projects and request, and manage active project to deadlines.
• Set up and periodically review security needs and access for business roles and responsibilities.
• Manager HRIS vendor relationships

Confidential

• Responsible for executing project plans, customization, development, upgrading administration of the HRIS system called iVantage and reporting for Payroll and HR0.
• Sharepoint webmaster for the HR intranet site and sub-sites, content re-design, shared documents, html content updates.
• Accomplishments:
• Upgraded iVantage to 4.3 developing the necessary customizations, saving the company over 10K.
• Developed over 100 reports in MS SQL Server Reporting Services for Payroll and HR using T-SQL stored procs, functions advanced queries , ad-hoc, complex compensation, benefits, time-off, vacation, employee headcounts, etc.
• Brought iVantage in-house, validated data loads, assured users could login and trained employees in HRIS system.
• Developed customizations for the employee self-service portion of iVantage HR Connect using ASP.NET 2.0 1.0.
• Administered resumeware applicant tracking system .
• Developed and customized new interfaces from iVantage to benefits vendor Mercer , ADP and CBIZ payroll systems.
• Developed and compiled HR data utilizing Crystal Reports.
• Maintained integrity of HRIS data.
• Responsible for quarterly Board meeting HR reporting.
• Provided training for HR staff including US Domestic and Europe offices to insure maximum utilization of HRIS systems.
• Trained employees in employee and manager self service modules, including the development of training materials.
• Developed audit reports to ensure compliance with Sarbanes Oxley, HIPAA and other company controls.

Confidential

• Implemented Oracle HR and Oracle Time and Labor OTL , Discoverer 10g.
• Mapped HR and Time entry business processes.
• Developed gap analysis and Solution Design documentation, including BR100 documents for HR and OTL.
• Proposed and agreed with client the new system work structures such as Organizations, Jobs and Locations, despite an internal re-organization where DTS split it into two companies.
• Designed and set up a Global Organization Hierarchy to see people across Business Groups.
• Set up and configured HR and OTL modules multiple times for Conference Room Pilots CRP 1 2, User Acceptance Testing UAT and Training instances set up custom responsibilities, custom menus, custom forms, custom taskflows and security based on Payroll to fit the client needs .
• Conducted CRP 1 2 and UAT in US and remotely with UK office.
• Developed test plans, test scripts and did unit testing after each set up.
• Developed Training materials and conducted Training sessions for end users.
• Designed a conversion layout spreadsheet with exported information from ADP Payroll and got Client to update spreadsheet regularly due to lack of legated HR systems.
• Revised data integrity of loads in Development instance and in UAT and Go-Live instances using TOAD queries that looked exactly as the conversion layout spreadsheet.
• Agreed and developed with client a list of global and local reports and enabled Discoverer and developed HR reports.
• Logged, followed up and closed Technical Assistance Requests TARs , online-Oracle Metalink and Oracle Applications Patch Management.
• Analyzed and developed a proposal for an Oracle HR to ADP interface with time estimation and technical documentation from ADP and Oracle.
• Prepared profiles for Super User and did knowledge transfer to Super User.
• Did post-production support.

Confidential

• IT Convergence : Developed SQL views for HR and Payroll reporting for US, Mexico and Argentina in Oracle Discoverer, developed MD070 technical documentation for each report.
• Cummins : Implemented/migrated Oracle HR 10.7 to 11i 11.5.8 , OTA 10,7 To 11i, ESS MSS, Discoverer 4i using client methodology in San Luis Potosi Juarez as part of a global implementation. Business Process Mapping current to be . 10.7 data clean-up. Legacy HR, Payroll and T A systems MS Access HR Payroll, Foxpro T A, etc. Third Party Home grown data extraction data conversion. Documentation gathering, instance set up, configuration testing, test plan test scripts development, mapping, interface to Payroll and other Lotus Notes Databases Personnel Requisition, etc , systems documentation development, end-user training manuals English Spanish Conducted CRP1, CRP2, UAT, End-user Training and Post-production support.
• IT Convergence : Configuration and customization of Oracle instance, Remote demonstration of Oracle HR to IT Convergence for implementation in the company. Developed SQL stored procedures for HR data reports.
• Developed Discoverer and Oracle HR training materials for training courses.
• GCS Banco Salvadore o : HRMS fast forward initial data gathering, HR operational analysis, mapping and gap analysis for future business model using AIM Methodology. Test Training Instance customization and configuration. Interfaces, legacy data loading, data mapping, etc. towards future business model and implementation in Production Instance.
• Configuration and customization of Oracle instance for demonstration of a full implementation of Oracle HR.

Confidential

• Led infrastructure implementation and stabilization of a 70 user windows 2000 server network in the plant.
• Windows 2000 Server managing, troubleshooting and monitoring. Back up rotation configuration and managing. RAS, Internet Information Services configuration and user support.
• Led E1 for Internet Connection, email domain migration and clients' configuration. VPN connection to Corporate Office. Frame relay to Aguascalientes Plant.
• PBX managing and support.
• Led Videoconferencing project.
• Led ISA Server implementation in Windows 2000 Server.
• Led Nomipaq Payroll , Contpaq General Ledger and Adminpaq Inventory, sales purchasing migration to server, implementation, clients set up and their integration.
• Led Maincor Maintenance of Production from MAPICs software AS/400 implementation.
• Led Network expansion project in Production shop floor.

Confidential

• Implemented Oracle 11i HRMS, Employee Self Service ESS , Oracle Time Management OTM and Oracle Training Administration OTA worldwide in two full cycles: Americas and Asia/Europe.
• Committee member in decision of ERP solution SAP vs. Oracle , resulting in the implementation of Oracle 11i worldwide.
• Committee member and key member in interviews and final decision to hire a partner to implement Oracle 11i, resulting in KPMG Consulting.
• Key member in configuration meetings with Finance track defining: Business Units, Chart of Accounts, Multiple Currencies, Set of Books and Organizations structure.
• Key member in configuration meetings with Procurement track defining: Position Hierarchy and Locations structure.
• Key member in global planning of Oracle implementation as key expert in HR Latin America processes, responsible of assigning extended team members for Latin America to support implementation.
• Configured and customized Oracle HRMS.
• Inception, design, development and implementation, including CRPs, functional and technical specification docs for interfaces, Payroll interfaces, global reporting configuration in Discoverer 3i 4i, legacy data uploads, TAR's follow-up, HRMS, OTA, OTL, ESS, global security configuration and set up, WAN structure, end-user training and post-production support.

Confidential

• Redesigned HR processes.
• Led employer substitution HR program during ON Semiconductor separation from Motorola leading to a successful separation program where HR informed employees in the different shifts to chat and deliver new employer letters.
• Participated as a core team member in HR projects leading software implementation strategy for Compensation, Direct labor Certification programs and employee Linked Goal Process.
• Key HR contributor for the Payroll outsourcing project which led to significant cost savings.
• Developed web pages in the HR intranet, resulting in the improvement and ease of HR communication with indirect labor.
• Fed employee data warehouse systems called TWIN Employee Directory and IDE Individual Dignity Program .
• Managed and administered the HR appletalk network and HR/Link HR system .

Confidential

• Led Project with a team from Mexico and Costa Rica for the implementation of Latin America's Corporate Compensation web systems such as employee self-service system intranet and job evaluation system intranet , developing asp pages with a MS Access Database.
• Led year 2000 program for the Human Resources systems, resulting in a smooth transition for HR to year 2000.
• Led Software Engineering Institute SEI program documentation implementation in Latin America.
• Fed employee data warehouse systems called TWIN Employee Directory and IDE Individual Dignity Program .
• Managed and administered the HR appletalk network and HR/Link HR System .

Confidential

• Led project for legated AS/400 ERP system migration into Visual Basic/SQL running on NT which was developed by a third party vendor Softtek .
• Data uploads from DB2 databases in AS/400 into SQL Server database, parallel testing, etc.
• Managed and maintained an AS/400, Appletalk network and Windows NT LANs.

Confidential

Led a 2-week project which consisted in loading Mallinckrodt master tables data into Schering-Plough's master tables and sales. Mallinckrodt was acquired by Schering-Plough

Confidential

• Led network deployment including cabling, Server and PC connection and software installation of a 25-user Netware LAN.
• Administered LAN including Warehouses in the country.
• Led implementation of UPS Un-interruptible Power System an electric circuitry deployment for LAN protection.
• Managed third party vendors for LAN and UPS, ensuring good functionality of LAN and UPS.
• Developed, managed and implemented Backup, Contingency and Disaster Recovery Plans.
• Developed customized reports using Crystal Reports and Cognos connecting to Platinum's Btrieve Database.
• Help desk support for hardware and software MS Office, MS Access, MS Visual Basic, etc.
• Administered Microsoft Mail Network.
• Led Project implementation of the Platinum ERP system, data loading and migration of legacy data, testing, training and stabilization, resulting in a successful implementation.
• Programmed, implemented and supported Platinum ERP system and interfaces with fixed assets, tax control, etc. using CA Clipper, Clarion and MS Access.
• Installed, Managed and Supported Mexican Payroll System

Confidential

• Led network deployment including cabling, Server and PC connection and software installation of 25 user Novel Netware LAN Local Area Network .Network cabling planning and supervision.
• Led project to integrate proprietary stand-alone ERP modules AR, Inventory, AP, GL, etc into the LAN, including re-programming, data load and migration using CA Clipper, resulting in interacting transactions among modules as a real integrated system.
• Administered, managed and supported LAN, including Manufacturing Plants located in various sites across Mexico.
• Programmed, implemented and supported CA Clipper and interfacing systems such as: Payroll, General Ledger, Tax Return, Fixed Assets and Bank Book.

Confidential

• Administered, managed and Supported Novell Netware 3.11 100 user PC WAN Wide Area Network .
• Programmed, developed, implemented, integrated, managed and supported proprietary CA Clipper systems including: Treasury, Admission, Educational Credit, G/L, Payroll, etc.