SUMMARY

• Sr. Oracle HR Data Analyst with extensive experience in ensuring all HR data is accurate.
• Expert understanding of HR terminology and working with Oracle HR Interface. Proven experience working with Excel.
• Possesses impeccable communication skills. No issue with travel to London. Lives local to Arlington VA.

TECHNICAL SKILLS

Oracle HRMS: Oracle HR, Oracle Time and Labor, and Compensation Workbench modules (some Benefits and Payroll experience as they interact with Core HR and Time and Labor). Strong understanding of database concepts, tables and familiarity with programming & querying tools to include Oracle Developer, TOAD with light PL/SQL. MS Office Suite to include Access (advanced level Word, Excel to include vlookups, pivot tables & PowerPoint), Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Sr. Oracle HR Data Analyst

Responsibilities:

• Performed Validation of data for 90,000 global Employees daily to include weekly validations and imports for correction of data
• Performing Excel vlookup and pivot tables for identifying data issues and inconsistencies from multiple HRIS systems to SumTotal talent management systems
• Coordinate with HRIS Departments globally for Oracle systems to feed correct data elements to Insight and Interface to SumTotal
• Reports and form designs for Performance Management and Compensation plans
• Meeting with global HRIS Management and Vendor to plan and test Reports, Forms and new or changed Compensation Plans
• Running weekly reports for Organizations to determine performance worksteps in the performance process
• Perform as the Systems Administrator for SumTotal system to include: Assigning responsibilities based on geography and role of the employee, password resets and ticketing system for helpdesk issues with logon problems.
• Helpdesk ownership - perform manual correction detection through ticketing system in coordinated efforts with DBA’s and Developers to determine issues with SSO and passwords to keep them in synch.
• Perform data imports to correct data and keep data in synch weekly and on demand basis
• Work with Open Office to prep files for creating text imports into Sumtotal
• Break fix and analysis for duplicate accounts and account rejects from weekly uploads

Confidential, VA

Senior Oracle HRIS Data Analyst

Responsibilities:

• Conversion leadership to include running data extracts, creation of vlookups, creation of pivot tables for validation of HR data between systems
• Assistant Project Manager for implementation of Oracle HRMS - including implementing Core HR, Payroll, Time & Labor, and Compensation Workbench
• Universal Productivity Kit (UPK) Developer
• Consulted for implementation of Oracle Time and Labor
• Assistance with Core HR Workstructures and configuration designs
• Functional Lead for Compensation Workbench module
• Work with consultants and The County towards implementation of ERP HRMS system
• Attend workshop meetings for input and design configurations for conference room pilots and agile development of The County’s business processes in the new system
• Writing functional specifications for the technical team to deliver
• Training and documentation
• Functional System Administrator duties
• RBAC (roll based security control) set up and assistance
• Senior HRIS Analyst Support beyond project go-live
• User Acceptance Testing activities

Confidential, VA

Sr. Oracle HRMS Data Analyst

Responsibilities:

• Develop best practices and setups for data conversion during implementation of Oracle 12i for Human Resources & Time and Labor modules primarily and assist with other HRMS modules as needed.
• Assisted with interfaces and design setups for processing timecards to state payroll system and Oracle Projects
• Functional Lead Analyst for implementation of Oracle HR (shared instance) and Time & Labor modules for deployment of Oracle HRMS R12 ERP system to replace The VEC ( Confidential ’s) internal financial system with time & labor.
• Meeting with VEC staff and Subject Matter Experts to develop best practice system design, preparation of analysis documentation, developing overhead presentations and presenting material for understanding and training of HRMS system.
• Performed UAT testing and assistance in helping client to develop test scripts and how to document findings and consult with them for regression testing methodologies and practices.
• Implementation and system setups to include, (prototype, development, test & production) instances.
• Woredk with client to develop interfaces from Statewide HR systems to Oracle HR, and to interface time from OTL time collection to Statewide Payroll system and then to Projects and Grants.
• Technical writing and document preparation
• Assistance with implementation of Oracle Projects & Grants
• Project Management and writing Business Analysis Documentation.
• Post go-live production support to the Confidential

Confidential, VA

Sr. Oracle HR Analyst

Responsibilities:

• Analyst for Oracle Time & Labor module for deployment of Oracle HRMS 12 ERP system to replace The Confidential ’s legacy system.
• Assistance with interfaces and design setups for processing timecards to payroll system.
• Meeting with City IT staff and Subject Matter Experts to develop best practice system design, preparation of analysis documentation, developing overhead presentations and presenting material for understanding and training of HRMS system.
• UAT testing and assistance in helping client to develop test scripts and how to document findings and consult with them for regression testing methodologies and practices.
• Implementation and system setups
• Work with client to develop interfaces for time collection, including time clocks.
• Administered technical writing skills for development of procedural documentation using MS Visio and other MS suite software.
• Other client support and error handling as needed
• Assistance in designing and developing reporting specifications
• Assistance with implementation of Oracle Projects & Grants
• Project Management and writing Business Analysis Documentation.

Confidential

Oracle HRMS Data Analyst

Responsibilities:

• Worked with Consultants, County IT Staff and Departmental Agency Heads & Key Officials to develop best practices and setups for data conversion during implementation of Oracle 11i for HR modules.
• Ran processes biweekly for timecard transfer to payroll.
• Held a lead role in managing projects for user acceptance testing.
• Oversee approval process to ensure all timecards and interfaces are completed and transferred to payroll.
• Developed Shifts, Work Plans, and Rotation Schedules for entire population of General Government to include creation of timecard templates for 32 departments across the County.
• Created time entry rules, preferences, helped to design and test interface for Fire Roster system. Extensive work, development and training of all Emergency Operations Employees (Fire, Sheriff, Police).
• Worked with consultants and internal Information Technology Department to design and develop various reports utilizing Oracle Discoverer 10g, PL/SQL, Oracle Developer, Access, Excel and other various software tools.
• Served as a Functional Administrator for Oracle HRMS system.
• Creation of databases for use of tracking and reporting statistics.
• Administered technical writing skills for development of procedural documentation using MS Visio and other software.
• Worked with Information Technology Department to better the system and assist in development of SQL queries in order to assist users with data extracts.
• Documentation, Flowcharting and Technical Writing for detailed technical specifications.