SUMMARY:

• Results - driven IT professional with exceptional knowledge on HCM implementation & Data Conversion with in HR system.
• Excellent knowledge and experience using SQL, SDLC, ETL, Advanced Excel functions
• Strong communication and organizations skills needed to be a successful member of any team.
• Possess the ability to work in a fast-paced environment while dealing with high priority activities concurrently.

TECHNICAL SKILLS:

Operating Systems, Languages and Databases: Client/Server Software HCM Implementations, ADP Enterprise v5, PeopleSoft v7.5-v9.2, UltiPro, SQL, SAP, SQL Talk, SQL Plus, Query Analyzer, Oracle Enterprise Manager, MS Enterprise Manager, ReportSmith, Crystal Reports 7-9, ADPR Reporter, SQR, Cognos, EBuilder/People Tools, ECode/People Code, Visual Basic, Microsoft Project Manager, Advanced EXEL, PowerPoint, Word, Access, Query Builder, Impromptu

Databases: Oracle 9.20, MS SQL Server 2010, MS Access 2010, SQL Base, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential

Owner / Contractor

• Implementation lead for deployment of new client into new HRIS / HCM environments
• PM Overseeing all process of conversion
• Requirements gathering, budgeting, mapping, configuration, time lines & delivery dates)
• Client assessments (training, best practices & all concerns and special needs)
• Designed technical training material for end users & training execution
• Database manipulation and data queries via SQL & BI Reporting Tools, SQR
• Data integrity / Migration / Data Manipulation / ETL
• Data conversions & table-field mapping / reporting
• Advanced Excel & Macro / Access / Visio
• Applications upgrades / Database security / New module implementation
• Security profiles & user access to HRIS apps
• Implementing plan of attach and coordinating others on project team for timely resolution and delivery
• Importing & Exporting data (Data loads via various methods (SQL / Import utilities / SQR Interfaces)
• Project cost management & scheduled project delivery deadlines, cost analyst, budgeting, resources
• Custom HR & Payroll training on-site with documentation (Live)

Confidential, Alpharetta, GA

Sr. HCM Implementation Technical Lead

• Full life cycle implementation conversion from ADP & various HCM Apps to SAP Success Factor
• 12 North America company’s migrated to Germany based HCM SAP
• Managing (ETL) data extraction, transformation & data loads
• Working closely with TK corporate (German) & N.A. companies business rules and coordinated efforts
• Utilized access & advanced xls to format specific data files for data up loads using various reporting tool for application extracts
• Worked closely with 3rd party vendors on custom interfaces requirements gathering & program updates & testing
• Heavy involvement with UAT testing and data validation from payroll parallel testing
• SharePoint was used for data uploads, error & corrections logs & updates for one point of contact
• Coordinated project staff meetings, priorities, work delegation & delivery due date.

Confidential, Franklin, TN

Senior Data Analyst (Remote)

• People Soft Reporting conversion and updates: approx 30 reports and interfaces
• 1700 employee data conversion and history through 2010. Extracted and formatted for load
• PS Query / SQR & SQL reporting tools converting Health Care data from various newly acquired sites. ETL Tool, additional data manipulation through advance excel functions work sheets files
• HR Benefit & North America Payroll / Benefits and various other Manage report & 3rd party interfaces
• File information gathering for IRS ACA Benefit report filing. Design / UAT Testing & Submission (Equifax Interface) additional formatting with advanced excel.
• Coordinating information gathering for 3rd party interface design & testing
• Automating scheduling and output distribution to respected upper management
• Testing for UAT acceptance and sign off and Go Live.

Confidential, Atlanta, GA

Business Analyst/HRM Implementation Data Specialist

• Mid-size company implementing new HRM Tool. (Orange HRM)
• Managed 5 person implementations team, Total Life Cycle
• Project Requirements Gathering, Project Plan, Budgeting, Schedules and Delivery Due dates,
• 3rd party vendors, Interfaces, Status meetings
• Data migration / extraction & loads / mapping / errors logs & fixes / UAT testing / Project updates and progression / Ad-Hoc Reporting
• Modules Implemented: Employee Info / Recruiting / On-Boarding / Job Posting / Benefits EE & Dependent / EEO / Leave of Absence & Job Title, Descriptions and Pay grade / Security

Confidential, Boston, MA

Implementation Data Analyst Consultant

• Implementing the Human Capital Management (SAP) as part of the project team
• 3rd Party vendor integrations, Development, Test and Deploy custom interfaces
• Data Extractions for loads via: People Soft Query, SQL scripts, ADPR reporting & SQR reporting
• Data validation pre & post loading SAP from ADP (Enterprise) & PeopleSoft (9.2) HRIS systems
• ACA IRS Reporting via PeopleSoft Query Builder, ADPR Reporting Tools for 2015 IRS reporting
• Payroll Parallel testing, maintaining defect log, testing, fixes and updates
• Data extraction for upload to Midware application (Time and Attendance) Payroll
• Generate SAP Payroll Reports to match ADP & People Soft reporting for data validation compare
• Data extraction via various reporting tools with advanced manipulation in Excel

Confidential, Nashville, TN

HRIS Data Conversion Analyst

• Data extraction project from ADP EV5 to Lawson’s ( Confidential Acquisition)
• Worked closely with Lawson Implementations / Confidential HRIS to establish extraction needs and data file formats, interfaces, Full data extraction
• Data pulled via SQL & BI reporting tools to create files of various field, table specifications.
• Compiled data for data loads in numerous stages, testing, comparison, error logs and fixes
• UAT and Parallel testing fixes and acceptance
• Additional data manipulation in xls utilizing advance functions & macros
• Files runs in accordance with payroll downloads for parallel testing against Lawson’s payroll runs

Confidential

HRIS Reporting Analyst

• Created & implemented high level custom reports for HR, Payroll and Management
• Redesigned, Updated, and Trouble Shot various older report to improve data consistency
• Supported District Managers report request (designed and built)
• Trained reporting help desk on advanced reporting techniques utilizing ADP Reporter, Crystal
• Develop new and maintain existing interfaces between ADP, brokers, and vendors, etc.

Confidential

HCM Data Interface & Data Specialist

• Full Data extract conversion from ADP / EV5 to SAP, data table loads
• Work closely with SAP implementations and client on extraction requirements
• Extraction data EV5 to SAP file load formats via various ADP reporting tools (SQR / SQL / ADPR)
• Employee, Benefits, Job & All Payroll, YTD & Balances extracts (Full Data Extraction as required)
• Consolidation, Mapping and additional data correction, updates & formatting in XLS & Access
• Data Table Specification for SAP formats for data loads and comparison
• Payroll Parallel testing (Transmitting, receiving and file loads
• UAT Data Testing and validation (SAP vs ADP) data comparisons

Confidential

HRIS Data / Report Analyst

• Full Reporting Conversion (ADP EV5) from Report Smith to Vantage ADPR reporting tool (275 + report)
• Implementation phase converting from ADP EV5 to ADP Vantage payroll system & data load validation
• Part of the implementation team for Confidential working on data validation & report conversion
• Analyze reports existing reports looking for inconsistency's, duplication and similarities for consolidation
• Group & merge like reports adding flexibility for multipurpose reporting
• Differences in database, table & field structure for report conversion and documentation on changes
• Full conversion including all suggestion, modification, grouping and best practices
• Custom Interfaces feeds for 3rd party vendors. i.e. (401K, Health, Unions, Non-Discrimination)
• Conducted on-site live custom training for end users (ADPR) reporting tool
• Created a reporting library for end users and set security accordingly
• Custom on-site reporting training (live) 15 HR & Payroll attendees with documentation

Confidential

HRIS Data/Report Analyst

• Upgrade from EV4 to EV5 with change in reporting tool
• Full Reporting Conversion from Report Smith to ADPR reporting tool (500 + report)
• Data validation & UAT testing, reported data inconsistence's to ADP implementations team
• Data Analyst in preparation to the implementation of Position Management
• Analyze reports looking for inconsistencies, duplication and similarities for consolidation
• Group & merge like reports adding flexibility for multipurpose reporting
• Full conversion including all suggestion, modification, grouping and best practices
• Conducted on-site live custom training for end users (ADPR) reporting tool
• Created a reporting library for end users and set security accordingly
• Custom on-site reporting training (live) 15 HR & Payroll attendees with documentation

Confidential

HRIS Data / Report Analyst

• Converted existing Report Smith Benefit reports to ADPR reporting tool (2012)Benefit reporting for prospected new provider (All benefit for estimated volume & cost analysis)
• Monthly Benefit reporting for projected bill pay to current providers (SQR interfaces / query tools)
• Reporting: Non-Discrimination / Workers Comp / 401K & Match (3rd party vendors) SQR interfaces
• Benefit Report Development
• Life Benefit Billing reports & Morgan Keegan Feed for 3rd party verification & census reporting
• Converted & Developed 8 reports from Report Smith into ADPR for yearend billing
• All Life Benefits, Direct Deposit, Morgan Keegan Stock Feed & LTD-STD Billing
• EE Data Extract from EV5 to SAP for table loads (Job, Employment, Salary & historical)

Confidential

Implementation Consultant

• HRIS Application & Database Upgrade
• ADP Enterprise from V 4.02 to V 5.3 and SQL Server Database from2000 to 2008
• Create DEVL environment for database upgrade, copy production DB to new 2008 server and restore
• Create copy of production app and apply upgrade patches from 4.02 to 5.3
• Run QA tests and start client testing, address issues and resolve
• Update all custom programs (SQR & SQL scripts for data feeds to other HR app)
• Test ADHOC reports to ensure consistency and issue free, rewrite or modify if warranted

Confidential

Implementation Consultant/Team Lead

• HRIS Full Life Cycle System Conversion (ADP Enterprise to Ceridian Work Force)
• Full data extraction & data loads from ADP Enterprise to Ceridian Latitude HRIS payroll system
• Coordinate resources for core table builds & loaded critical employee data in core tables
• Designed extractions files according to Ceridian data load spec's
• All check detail as well as year to date (balances) & history back to 2004
• Benefits current and history programs & back up access database to house history in-house
• Mapping all deduction / earnings / benefit plans / depts.-locations / job codes /company info to Ceridian plans
• Technical lead for full report conversion and 3rd party interfaces
• Full access backup database check history dating back to 2004 & reporting quarries

Confidential

Interface Development Analyst

• Implementation of SAP Benefits & New Hires from ADP Enterprise System
• Managed SAP implementation for core table build (Company / benefit plans / Departments / Deductions)
• Initial employee data loads (SAP import utility) for SAP database population
• Interface feeds from ADP to SAP on payroll by paydate after transmission
• Interface feeds from SAP to ADP on New Hires & Terminated EE’s (Daily) AutomatedDesign SQR Interfaces to maintain and sync 2 HRIS payroll database systems
• ADP Deductions changed from payroll deductions to General Deductions for SAP ease
• ADP to SAP and SAP to ADP (ADP maintained payroll while SAP maintained Benefits & New Hires)
• Interfaces new hire from SAP to ADP and benefits Deductions
• Interface from ADP to SAP to update SAP payroll deduction payroll information.
• Mirrored databases from SAP to ADP to run concurrent