We provide IT Staff Augmentation Services!

Independent Consultant Resume

3.00/5 (Submit Your Rating)

Clarkston, GA

Confidential - Independent Consultant - Novemeber 2011 to present

Lead functional consultant managing implementation of R12.1 Oracle Time and Labor for US exempt and non-exempt employees. Develop work breakdown structure changes and project plans. Write weekly status updates of tasks and timeline for client management. Lead detailed requirements gathering with Payroll staff for US operations. Document business and setup requirements, along with ADP interface and conversion mapping. Document test scripts, solution flows and training materials. Lead key end users through setup phase, unit, and integration testing phases. Document ongoing issues and provide functional/technical support to troubleshooting teams. Manage off shore technical resource for development of custom functionality. Assist client staff with SR management and issue resolution. Support OTL setup, testing, and issue resolution. Configure absence management functionality to support HR and OTL.

Confidential - Independent Consultant - February 2011 to November 2011

HR Lead for global implementation of Oracle R12 HCM. Modules implemented include core HR, OTL, ESS, MSS, and Discoverer with interfaces to and from ADP for payroll. Developed both in and outbound ADP interfaces, as well as a custom BEE explosion process to convert total hours worked into appropriate pay types per client rules. Progamatically converted employees and employee history. Managed a team of five using AIM to produce such deliverables as BR30, CV70, MD50, MD70, and BR100 documents. Performed as a key resource for coordinating the HR, OTL and OAB system setup, and testing cycles. Planned and led the execution of multiple testing cycles across the HR, OTL, and OAB modules. Supported Change Management resources with the development of the end user training materials for all modules. Developed custom security solution to address client's complex SOX regulations. Migrated security objects using custom shell script and FNDLOAD. Developed custom WebADI integrators to support HCM configurations across instances. Provide ongoing support after go live. Led upgrade from 12.1.1 to 12.1.3.

Confidential - Independent Consultant - April 2010 to February 2011

HR Lead for global implementation of Oracle R12 HCM. Modules implemented include core HR, OSB, Compensation Workbench, TPM, ESS, MSS, and Discoverer. Developed following interfaces to third parties: ADP PCPW, Kronos, Blue Cross Blue Shield, MetLife, United HealthCare, and Active Directory. Manage a team of ten using AIM to produce such deliverables as BR30, CV70, MD50, MD70, and BR100 documents. Completely configured above modules. Lead Conference Room Pilot sessions with users. Developed and delivered end user training. Assisted users in identification of UAT scenarios. Resolved identified issues. Developed Discoverer reports and third party interfaces. Provide ongoing support after go live. Managed and configured application for both mid-year and year end Open Enrollment projects.

Confidential - Independent Consultant - Sept 2009 to April 2010

HR Lead for consolidation of the Canadian business operations Oracle instance into the existing US business operations Oracle instance. This was effectively a new CAN install of Oracle Payroll, HR, ESS/MSS, Compensation Workbench, and Oracle Standard Benefits using the ePrentise Instance Consolidaiton tool. Additionally the implementation must support interfaces to numerous third parties including, but not limited to: Kronos, MyTime, PeopleClick, SuccessFactors, AETNA, United HealthCare, and Merrill Lynch. Managed a team of eight. Create work plans and estimates for all HRMS functional and technical activities. Develop appropriate AIM documents to support reports, interfaces, conversions, and extensions. Remeidate existing code to ensure it worked in new multi-org environment. Developed test plans and test scripts for consolidation. Developed custom "regression runner" tool to programmatically submit concurrent processes and compare before/after consolidation results. Tested custom and seeded processes to verify consolidation. Upgraded existing Discoverer 4i implementation to 10g. Redeveloped existing EUL and workbooks to support apps mode security model and reusability. Used HP Quality Center and PPM to manage testing efforts and day to day project operations respectively.

Confidential - Independent Consultant - June 2009 to Sept 2009

Lead technical consultant for implementation of Oracle Time and Labor for US exempt and Canadian exempt/non-exempt employees using PMI and PMBOK principles. Led detailed requirements gathering with Payroll staff for US and Canada operations. Developed custom code to interface with ADP PCPW and data conversions. Led key end users through setup phase, unit, and integration testing phases. Documented setup, installation, and configuration steps for technical personnel. Supported Time and Labor setup, testing, and issue resolution. Developed custom functions, fast formulas, and PL/SQL packages to augment absence management and on-call functionality to support HR and OTL. Provided weekly status updates of tasks and timeline.

Confidential - Independent Consultant - January 2009 to June 2009

HR Lead for R12 implementation of Oracle eBusiness Suite. Led detailed requirements gathering with HR/Payroll staff for US operations using PMI and PMBOK principles. Documented test scripts, solution flows and training materials. Led key end users through setup phase, unit, and integration testing phases Documented ongoing issues and provided functional/technical support. Developed BR30, CV70, MD50, and BR100 documents for Core HR, ESS, MSS, TPM (Talent and Performance Management), and ADP Connection configuration. Managed offshore team of technical resources who performed employee/employee history conversions. Configured and personalized Core HR, ESS, MSS, TPM, and ADP Connection application. Personally converted full range of TPM and PTO data with PL/SQL. Assisted functional and technical staff with TAR management and issue resolution. Issued weekly status updates of tasks, timeline, and work breakdown structure changes to the organization level management moving the project.. Configured AME and workflow for custom approvals routing. Using Oracle BI Publisher I developed custom OIC reports and AP checks.

Confidential - Independent Consultant - September 2008 to January 2009

Functional Lead for HR implementation for Benefits Open Enrollment, Executive Compensation, and Performance Management utilizing Oracle R12 and SuccessFactors. Led client business requirements sessions. Performed Fit/Gap analysis of requirements to the applications. Set up custom responsibilities and security profiles based on requirements. Perform Self-Service personalizations. Conduct Conference Room Pilot sessions validating business requirements. Create business requirement documentation, setup documentation, test scripts, and business flows documentation as client deliverables. Serve as a liaison and knowledge champion between IT and the Human Resources department. Develop and manage project plans. Prepare project status reports and reported project progress to Executive Steering Committees.

Confidential - Metropolitan Atlanta Rapid Transit Authority - Independent Consultant - December 2006 to September 2008

Program Director for the $70 million Business Transformation Program (Oracle's eBusiness ERP suite 11.5.10 - FinApps/HRMS/SCM/Public Sector Budgeting, Optram Catbase, and Maximus FA Suite) replacing MARTA's legacy business systems (finance, human resources and maintenance) with an integrated suite of applications which was completed on schedule and within budget using PMI and PMBOK principles. Managed Service Delivery in organization consisting of both "in sourced" and "outsourced" teams (team sizes typically range up to 90 individuals). Responsible for managing customer expectations, resolving conflicts to balance client and company needs, quality assurance, training utilizing Oracle's UPK toolset, implementation, integration and go-live, clarifying and driving project commitments as well as establishing and maintaining clear chains of accountability. Provide escalation management considering business needs against technical constraints, while encouraging risk-taking behavior to maximize business benefit. Review all related system and environment changes and take appropriate actions to ensure system environment stability and performance Service Level Objectives are maintained

Managed and report project budget status. Monitored and controlled project using HP PPM, HP Quality Center, and MS Project Server. Closed out project and archived project deliverables using MS Sharepoint. Oversaw development and management of project deliverables such as communications plan, organizational change management plan, risk mitigation strategy and plan, QA plan, traceability matrix, RACI charts, project plans, and master project schedules including development of WBS. Developed project charter, stakeholder analysis, business case, status reports, and led C-Level executive briefings.

Mentored and managed the development, implementation, and support teams in a way that allows transition between the teams and opportunity to rotate appropriately into the "build" team as required. Provided managerial oversight for all development projects composed of system enhancement releases to applications and "break-fix" issues. Managed the areas of cost-reduction, cost-containment, customer service and expedient delivery of IT solutions by developing and adhering to labor expense, capital labor and training budgets. Developed Service Level Agreements (SLA). Maintain relationship management activities with outsourcer. Developed/managed project schedules. Interviewed and hired staff. Reported progress to executive management. Managed vendor contracts and overall budget. In addition to PD responsibilities, I personally customized the paycheck and deposit advice using Oracle's BI (formerly XML) Publisher product and customized PL/SQL.

Confidential - Independent Consultant - June 2003 to December 2006

Program Director for HR outsourcing effort migrating from Oracle/Peoplesoft HRMS applications to ADP Comprehensive Outsourcing Solution (Payroll/Benefits/HR/Time and Attendance/ESS - rebranded PeopleSoft and Kronos). Managed project budget of $12 million and staff of 40+ employees and contractors using PMI and PMBOK principles. . Wrote and presented business case to executive management. Reported progress status to executive management. Developed short and long term strategies for assimilation of data from these disparate system into a common delivery platform. Wrote numerous SQR/PLSQL/Unix scripts to extract HRMS data from the Oracle/PeopleSoft applications and interface with the ADP COS model. Produced client W2's, other government magnetic reports, and wrote PL/SQL scripst to make over 20,000 balance adjustments to resolve employee W2 balance problems for 2003, 2004, and 2005 Payroll year end.

Program Manager for legacy Oracle 11i HR/Payroll/OAB/OTL implementation. Developed and delivered end user training, along with desktop operating instructions. Executed project work plans to achieve technical and infrastructure deliverables including patching/upgrades, testing requirements/strategy, and instance change management. Managed the process of application and design setups, customizations, interfaces, reports design and execution. Served as the escalation point for function/scope change control for HRIS projects. Upgraded Noetix Views from version 4 to version 5. Administered Discoverer EUL for Noetix Views and Custom Views. Implemented Discoverer 4.x including client edition, Viewer, and Plus. Modified existing Discoverer setup to run in Apps Security mode. Gathered and documented client requirement using AIM for Oracle Advance Benefits (OAB) and Oracle Time and Labor (OTL). Setup and configured Self Service Benefits (SSBEN) for automated 2004, 2005, 2006 Benefits Open Enrollment. Setup and configured OTL utilizing Itermec timeclock. Developed custom time store to handle the challenges of manufacturing policies using PL/SQL

Confidential - Independent Consultant - February 2003 to June 2003

Technical lead for Self Service HR 4.2 implementation. . Gathered and documented client requirement using AIM . Designed custom solutions and workflows to address identified gaps. Support of production Oracle 11i payroll system with custom web front end for employee and time entry. Created custom deposit advice report. Created EIT to support Chick-Fil-A's new hire reporting system and modified seeded New Hire State report to meet CFA's requirements. Modified custom web front end to support Indiana employee county tax withholding bug. Enhanced application taskflow to improve navigation. Wrote GL to AP interface to create invoices for employee health insurance costs. Developed GL journal import interface for restaurants/health insurance carriers. Coded Financials reports using Scribe SQR.

Confidential - Independent Consultant - November 2002 to February 2003

Functional and Technical Lead for Red Hat's global Oracle HR/ADP Payroll 11i implementation. Gathered and documented client requirement using AIM. Setup key flexfields such as jobs, grades, costing, SITs, and positions, as well as descriptive flexfields Defined following work structures: organizations, locations, grade ranges, GREs, salary basis, organization hierarchies, position hierarchies, payrolls, elements, element links. Upgraded Self Service Human Resources (SSHR) from version 3.4.to 4.2. Modified seeded workflows and created custom workflows to support client requirements. Implemented Oracle Approval Manager to replace Alerts and some workflows for standard approval processing. Implemented Oracle Standard Benefits (OSB) to support SSBEN and SSHR. Successfully implemented and setup ADP interface to provide automated interface between Oracle HR and ADP Payroll. Modified delivered ADP views to meet client requirements.

Developed custom views and scripts to automate interfaces to numerous benefit carriers and ADP using PL/SQL. Converted data from production 11.03 instance to EBO (Oracle.com) 11i instance running under Red Hat Linux using Oracle APIs and custom code to add employees and addresses, update person and address information, update assignments and assignment history including custom costing, create contacts and dependents, create phone entries, create positions and jobs, create SITs, load salary proposals including history, add W4 information, add personal payment methods, load element entries with dependents, terminate employees, and programmatically linking elements using PL/SQL.

Confidential - Senior Manager - August 2000 to November 2002

Successfully directed the upgrade of Oracle HR, Financials, and CRM modules from 11.03 to 11i on time and 28% under budget. This $300,000 savings was accomplished without external consultants. Served as Technical and Functional Team Lead for HR. Supervised formal user testing using Mercury WinRunner and LoadRunner. Directed functional team leaders in resolving issues associated with the application/database setup. Applied upgrade patches using ADPATCH utility and monitored progress of patches with ADCTRL utility. Recompiled schema objects using ADADMIN utility. Personally remediated all HR interfaces, packages, forms, reports, and Discoverer workbooks from 11.03 to 11i. Upgraded Noetix Views from 2.2 (11.03) to 4.3 (11i). Developed and delivered end user training, along with desktop operating instructions for Oracle 11.03 and 11i application.

Served as Project Manager for US, EMEA, and APJ rollouts of Oracle HR/Financials/Purchasing/OTA 11.03. Completed on time and on budget. Personally setup descriptive flexfields, key flexfields , as well as organizations, locations, grades and grade ranges, locations, GREs, jobs, positions, salary basis, organization hierarchies, position hierarchies, payrolls, elements, and element links. Authored user's guide and conducted end user training. Developed project estimates and plans. Directed technical team leaders in resolving issues associated with the application/database, setup, or legacy data conversion. The OTA implementation was global and included over 900 training activities and 2000 training events.

Programmatically converted the full range of Oracle HRMS data using PL/SQL - adding employees and addresses, updating person and address information, updating assignments (with and without assignment history) and creating secondary assignments including custom costing, creating contacts and dependents, creating phone entries, creating positions and jobs, creating SITs, creating and updating salary proposals, adding W4 information, adding personal payment methods, loading element entries with dependents, terminating employees, deleting employees and programatically linking elements.
Installed Discoverer with Noetix views in Applications Security Mode. Administered Discoverer End User Layer for Datamart purposes - wrote many custom views to support this Datamart and created custom business areas. Installed and setup end user Discoverer client software. Successfully implemented and setup ADP Connection to provide automated interface between Oracle HR and ADP Payroll. Developed custom views and scripts to automate interfaces to numerous benefit carriers and ADP.

Installed, configured, and customized Oracle Self Service Human Resources. Completed mandatory setup tasks and workflow setup. Extended base functionality by implementing various optional workflow features and modifying source HTML within the application. Added client related links to SSHR home page. Customized existing forms and developed custom forms to meet client requirements using Developer/2000. Designed and created custom table to support client extensions to the base application. Registered custom applications in the Oracle Application. Wrote custom reports to meet client specifications using Developer/2000, PL/SQL, Crystal Reports, and Discoverer.

Confidential - Principal Consultant/Senior Principal Consultant - November 1997 to August 2000

Served as the Technical Project Manager during the conversion and production implementation of 12 client engagements in various market spaces. Implemented Oracle modules include: Fixed Assets, Accounts Receiveables, Accounts Payables, General Ledger, Inventory, Cash Management, Order Entry, Human Resources, Payroll, Training Administration, Self Service Human Resources, Public Sector Budgeting, and Purchasing utilizing both Oracle 7.x and 8.x for version 10.7 and 11.03. Developed project plans, estimates, schedules, and status reports for conversion and implementation. Provided manday estimate to customer for HRMS conversion and balance initialization. Also in the capacity of Technical Project Manager, developed business requirements, data mapping documents, test scripts, and application views using PL/SQL for implementation of a corporate DataMart that stores various HR history for thousands of employees. Managed systems testing for Oracle Purchasing and Accounts Payable modules. OTA implementation included 1000 training activities and 3000 training events. Developed and delivered end user training, along with desktop operating instructions for Oracle 10.7 and 11.03.applications.

Wrote custom packages/procedures to convert various legacy applications data such as PeopleSoft, ADP, Ceridian, SAP, GEAC, and Abra using PL/SQL. This custom code called Oracle HR APIs for creation and maintenance of employees and their addresses, updating primary/secondary assignments, adding salaries, terminating employees, creating positions, creating jobs, creating personal pay methods, creation and updating of W4 data, creation of multiple phone numbers, creating secondary assignments, creation of contacts and dependents, creation of SITs, linking and creation of element entries including dependent and contact data, and balance initialization. This wrapper code cleansed data as necessary to ensure that the data was loaded correctly. Also converted legacy employee costing data into Oracle HRMS tables in mass with custom scripts and developed automated means of maintaining position hierarchy for purchasing purposes as job and position changes occur in the normal course of business. Developed custom PL/SQL scripts to rollover employee accrual balances from prior to current year. Using these same procedures as a starting point, designed and coded processes to automatically dock an employee for negative accrual balances.

Wrote database triggers and stored procedures for multiple HR application tables to maintain custom staging tables for the purpose of creating custom interfaces and audit trails using PL/SQL. Developed interface scripts between Oracle applications and various outside entities including: Winstar time keeping system, Paymaxx payroll application, ADP payroll, Ceridian payroll, SAP Payroll, Alabama State Education interfaces, various insurance carriers, and Texas State Agencies. Produced client W2s, federal and state magnetic reports, and SQWL reports and files. Used SQL*Loader to populate inbound tables. Developed custom PL/SQL scripts/procedures/packages to allow mass element balance and tax balance adjustments of employee pay data. Modified seeded fast formulas and developed custom fast formulas to meet client requirements. Customized seed Oracle reports such as Check Writer, Deposit Advice, and New Hire State Report.

Developed custom PL/SQL procedures to convert bank supplied reconciliation data into Oracle Cash Management open interface format to support monthly bank reconciliation. Converted legacy Vendors into Oracle Suppliers using custom developed PL/SQL packages. Converted legacy balance sheet data into Oracle General Ledger open interface format to accomplish balance sheet conversion. Developed RFP responses by developing the proposed workplan and schedule for project completion using Project Workbench, Project Modeler, and AIM. Completed CV20 (data strategy document) and CV50 (data mapping document) for client HR conversions. Modified AIM document template to include identification of appropriate API and parameter for legacy columns. Supervised formal user testing using Mercury WinRunner and LoadRunner

Confidential - Technical Manager, Product Delivery/Director - Applications Planning and Development - April 1991 to November 1997

Directed technical project management, control, and reporting for computer projects in the National Home Office (NHO) Computer Systems and Services department requiring enterprise wide implementation. Directed national helpdesk for the Society serving over 4000 users nationwide. Responsible for 11 server Novell, Token Ring/Ethernet network with over 250 nodes utilizing SPX and TCP/IP for Internet connectivity.

Responsible for all Lotus Notes application development and coordination of the development/integration of other purchased, developed, or modified enterprise application systems. Directed the successful implementation of 121 server Lotus Notes network for the Society. These enterprise applications fed the Society's DB2 data warehouse containing such objects as: customer, patient, applicant, cancer, donor, volunteer, employee information. Using Notes and SAS as a front end DSS, with D2B and Sybase as the database engine, we provided full drill down availability of Society data. Developed Society's Web Site which provides DataMart access to the general population, as well as internal access to more proprietary information.

Interviewed, hired, and managed contractors and consultants for multiple, concurrent development engagements. Responsible for project schedules and budgets. Tailored STRADIS methodology using Methods Architect to fit the needs of the Society. These customized Routes and Method Parameters were then used by Project Modeler to plan, profile, and estimate project schedules. Reduced applications backlog by 26 percent by introducing Notes programming standards, project management tools (Project Workbench/Project Modeler), and STRADIS as a standard development methodology.
Successfully managed customization of third party HR-1 package to include addition of: open benefit enrollment module for employees; retiree open benefit enrollment; billing and third party interfaces; retiree and vested terminated employee tracking; and various management reports. Used Project Workbench to manage the engagement. Managed the completion of the $90 million Grants Management system (ATP.2) to a successful and early (six weeks) completion utilizing Project Workbench and Method/1.

Confidential - Planning Specialist/Systems Architect - July 1989 to April 1991

Served as an internal consultant for Contel Information Services. Responsible for assisting project vice presidents and directors in all planning and control activities. Drafted Enterprise Business Model for Telephone Sector organization - Contel's largest operational unit. Administered and controlled $500 million, 120+ employees Billing Information System and Service Information System projects using Project Workbench, Method/1, dBase 3, and Clipper. Designed and developed automated project modeling tool to aid in project estimating, planning, and scheduling. Evaluated both IBM RISC and RT processors, operating under AIX, as well as several optical disk solutions and recommended several potential applications of these technologies.

Confidential - Supervisor, Nuclear Information Systems - March 1986 to July 1989

Directed all data processing efforts for Farley Nuclear Plant - whose assets and revenues are equivalent to a Fortune 500 company. Oversaw a staff of 18 personnel who provided technical, client, and operational support to users of an IBM 3081 mainframe and PC\'s. Successfully directed development and
start - up of $11 million online integrated information system for the areas of: work order tracking; repetitive tasking; records management; inventory control; requisition tracking and procurement; project management; and administrative systems. Responsible for yearly operational budget of $1.5 million. Successfully converted existing ASYNC communications network to SNA/VTAM communications network providing estimated annual benefit of $1.1 million. Negotiated and managed upgrade of existing IBM 3083 - EX1 processor to 3081 - K48 processor, resulting in net cash flow of $300,000.

Confidential - Management Information Systems Supervisor - July 1984 to March 1986

Guided all data processing efforts for Hatch Nuclear Power Plant. Managed a staff of 15 personnel who provided technical, client, and operational support to approximately 500 customers. Managed $3 million project that researched and developed plant spare parts database. Developed and implemented disaster recovery plan. Created quality assurance methodologies and procedures for applications development and user acceptance testing.

Confidential - Junior Analyst to Senior MIS Analyst - July 1978 to July 1984

Accountable for: Planning, designing, coding, testing, installing, and supporting information systems. Prepared hardware and software request for quotes and evaluated such proposals. Developed, presented, and managed project budgets. Formulated work plans and schedules.

EDUCATION

MBA

AWARDS/CERTIFICATIONS

Oracle State and Local Government - East Region Consultant of the Quarter Q1 1998-1999
Oracle Commercial - Highest Utilization 1999-2000
Oracle State and Local Government - HR/Payroll Consultant of the Quarter Q3 2000-2001
Project Management Institute, Project Management Professional (PMP) October 2004
Six Sigma Project Owner August 2005
Six Sigma Green Belt July 2007
ITIL Foundation September 2012

SKILL HIGHLIGHTS

Oracle Products:

Oracle HR/Payroll/BEN

Oracle Accounts Payable

Oracle Purchasing

Compensation Workbench

PL/SQL with Procedure Builder

Oracle Cash Management

Oracle General Ledger

Oracle Forms 4.5/6i

Oracle Discoverer 3i/4i/10g

Oracle Accounts Receiveables

Oracle SQL*Loader

Oracle Alert

Oracle Reports 2.5/6i

Oracle BI Publisher

Oracle Public Sector Budgeting

Oracle BI Publisher

Oracle AME

Oracle Order Entry

Oracle ESS/MSS/TPM

Oracle Performance Management

Oracle SQL*Plus

Oracle Time and Labor

Oracle Inventory

Oracle Talent Management

Other Products:
Lotus SmartSuite, Lotus Notes, Wordperfect, Visio, ERWIN Data Modeler, Microsoft Office, SQL Navigator, TOAD, Noetix Views, UltraEdit, ADP Connection, OnNet, Crystal Reports, WinRunner, LoadRunner, Star Office, TORA, Business Objects, PL/Developer, PeopleSoft Enterprise HR 4-8, Kronos Workforce/ADP eTime, ReportSmith, ADP PCPW, ADP Payforce, InfoRouter, Sharepoint

Operating Systems/ Communications:
Windows 3.1/95/98/NT/2000/XP Pro/Vista/7, VM/CMS 5.x, MVS, OS/2 3.x, HP-UX 10.20, Sun Solaris 2.5, Novell, Red Hat Linux 7.2, 8.0, RCS

Languages:
COBOL, Powerbuilder, Lotus Notes/Approach, HTML, DataEase, Advanced Revelation, FORTRAN, dBase III/Clipper, PL/SQL, SAS, Scribe SQR

Databases:
IDMS 10.x, Watcom, DB2, IMS, Sybase SQL Anywhere, Oracle 11.x, Oracle 10.x, Oracle 9.x, Oracle 8.x, Oracle 7.x

Management/Leadership/ Specialty Skills:
ABT Project Workbench/ Modeler/Methods Architect, Planview, Microsoft Project, Primavera, JAD Facilitation, Yourdon, Data Modeling, Systems Analysis, HP Project Portfolio Manager, HP Quality Center

Life Cycle Expertise/ Methodologies:
Oracle Application Implementation Methodology (AIM), Method/1, STRADIS, IEF (James Martin), Six Sigma Project Management

We'd love your feedback!