Hr System Analyst
Waterfront
• Worked on ERP HR System Epicor HCM (Human Capital Management) and iVantage (old version of HCM) solutions.• Development of HR Benefits and Payroll reports using Crystal and SSRS and Access • Designed and developed UMCD application using Access.• Report development and editing scripts inbounding data from users and format out bounding it in the Report format.• Worked on Onboarding, requirements gathering and data analysis from the Business side Certification. • Training Users and debugging workflow.• Data collection, data analysis, documentation and presentation.• Designed and developed SSRS, SSIS,Crystal Reports using Crystal 10 and 11.• Generated Reports in different formats.• Maintained and created Tables, SQL Query working on SQL Server Database 2005 and 2008.• Supported with administrative, systems, and business operations problems, Participated in • Business Objects 4.1 Installation, Upgrade, Deployment• Processing Receipts/Direct Shipments and Generating Advance Shipment Notifications • Invoice Resolution & Payment and order management• Microsoft Excel for analysis• Database:o Core employee information, job, pay and status information o Employee qualifications, Salary administration o Benefit administration, Absence tracking o Standard reporting, Candidate tracking o Self-Service — employee/manager, Employee data history tracking o Flexible report-writing tools, Front-end customization tools o Intuitive user interface, Integrated talent management o Automated open enrollment, Knowledgeable and timely support o Dependent Age Benefits Report