Sr.workday Consultant - Technical Lead Resume
Trenton, NJ
SUMMARY:
- Experienced Software Engineer with extensive practice in computer science and technology engineering. Over Nine years of IT experience in software design, development and implementation of various commercial applications in Workday, PeopleSoft, Oracle and Visual Basic
- Strong experience in Creating Complex Reports such as Expense Reports, Benefit Reports, Compensation Reports, Payroll Employee information reports using Workday Report Writer and BIRT Report designer.
- Created Complex, Advanced and Medium Integrations using Workday Studio, EIB, Core Connectors, Cloud Connectors and Document Transformation tools
- Subject Matter Expert in HCM like Core HR, Base Benefits, Compensation, Work Force Administration, Position Management, NA Payroll, Payroll Interface, Benefits Administration, Time Tracking Absence Management
- Experience on Workday Data Conversion project and converted data from Legacy systems and populated the iLoad templates.
- Strong Experience in XML, XSLT, MVEL and Java Script.
- Functional Experience in Workday Financial modules like General Ledger, Accounts Payables, Accounts Receivables, Asset Management, Procurement and Treasury.
- Experience in Creating SOAP, REST web services in Integrations.
- Created Test Plans and Test cases for Integrations, Business Processes and Functional Configuration.
TECHNICAL SKILLS:
Languages: Java, XSLT, MVEL, Java Script, C++.
Databases: Oracle 10g DB, MS - Access.
Platforms: Windows, Linux.
Visual Tools: MS Office, Rational Rose
Designing Languages: UML,HTML
PROFESSIONAL EXPERIENCE:
Confidential, Trenton, NJ
Sr.Workday Consultant - Technical Lead
Responsibilities:
- Involved in Development, Enhancement, Upgrade, Maintenance of HR, Benefits, and Payroll.
- Lead the Technical team supporting Integrations, Reporting, and Production Issues in Workday.
- Designed and built inbound and outbound studio integrations with RaaS reports.
- Developed several reports using Workday Report Writer like Salary Changes, Severance, Payroll Earnings, Medical Enrollments, LTD Participants, Med, Dent, Vision, Salary plan etc reports as part of Implementation.
- Developed Payroll Integrations ADP Tax Monthly, ADP Tax Quarterly using Workday Studio
- Developed Several EIB inbound and outbound integrations.
- Created several custom reports and exposed as web services for several vendor files.
- Configured Cloud connectors for Benefits Integrations for Vanguard, Cigna Dental, and Blue Cross IL Medical and send the files over to vendor.
- Involved in Business Process configurations like Staffing, Core Compensation, and Payroll Interfaces etc.
- Created XSLT scripts for Integrations to transform XML data.
- Created Custom Security Groups and Custom security Roles.
- Provided Mentorship and Design documents for Reports and Integrations.
Environment: Workday 22/23, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer, Oxygen
Confidential, Chicago, IL
Sr.Workday Consultant - Integrations Lead
Responsibilities:
- Involved in Development, Enhancement, Upgrade, and Maintenance of HR, Benefits, and Payroll.
- Lead the Technical team supporting Integrations, Reporting, and Production Issues in Workday.
- Designed and built inbound and outbound studio integrations with RaaS reports.
- Developed Payroll Integrations ADP PCPW for U.S., ADP Pay@Work for Canada using Workday Studio.
- Configured Cloud connectors for Benefits Integrations for Superior Vision, Delta Dental and COBRA Enrollment for ADP.
- Developed Interface for Benefits provider Desjardin using Integration Template for Document Transformation.
- Created Custom G/L Integration from Workday using Journal Lines data source to send the Post payroll result to Lawson Financial system.
- Build Active Directory Integration with Courion and Granted access to 2 Public Web-Services to update the Username and Primary work e-mail address in Workday.
- Developed several Payroll, Tax, Accounting reports like Payroll Pre-Complete G/L Journal entry Audit, FICA Tax and Expense Audit, Work er US Tax elections etc.
- Created XSLT scripts for Integrations to transform XML data.
- Created Several Custom Reports and calc fields for Core HR, Payroll and Benefits.
- Created Custom Security Groups and Custom security Roles.
- Created several custom reports and exposed as web services for several vendor files.
- Provided Mentorship and Design documents for Reports and Integrations.
Environment: Workday 20/21, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer, Oxygen
Confidential, Atlanta, GA
Workday Consultant - Integrations Lead
Responsibilities:
- Lead consultant for extracting data from PeopleSoft HRMS 8.9 and transforming 22,000 workers into Workday iload/EIB format
- Performed fit-gap analysis for HR setup, configurations and data mapping
- Utilized Workday testing methodology for system development and implementation, developed detail Test strategy, plans and scripts to test specific HCM business process in Workday HCM.
- Developed multi-dimensional reports and analytics with the ability to drill down to transaction-level details.
- Configured outbound Benefit Interfaces using workday cloud Connect for Benefits.
- Developed SOAP Web Services Concur Expense Management using EIB and Workday Report Writer.
- Created Custom report for Benefits and made it as RaaS and scheduled it using EIB.
- Created Inbound EIB to update Benefit Annual Rates using Web Service.
- Developed test scripts for other outside systems that interface with Workday: Benefit interface with vendors, Time & Labor interface with Kronos system and Payroll Interface with PeopleSoft Payroll system.
- Provided mentorship for creating Reports and Calculated fields.
Environment: Workday 19/20, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer, Oxygen
Confidential, ORLANDO, FL
Workday Implementation and Support
Responsibilities:
- Created EIB’s (Enterprise Interface Builder) involving custom XSLT transformation as per requirements.
- Created several custom reports for Payroll, Benefits, and Core HR reports.
- Created User-Based security groups and assigned users.
- Developed Several EIB inbound and outbound integrations.
- Experience with building Cloud Connect for Benefits for BCBS and other for third party vendors
- Creating Business Processes, Custom Reports, and Calculated Fields as per client specifications.
- Configuring secure document deliveries to various vendors ftp servers.
- Scheduling Integration to generate output at particular intervals.
Environment: Workday 15, 16, 17, 18, Workday Studio, EIB, Workday Report Writer, XSLT, XML, Web Services
Report Writer
Confidential, Denver, CO
Responsibilities:
- Involved in analysis, customization and implementation of HR/Benefits/Payroll modules
- Involved in the data mappings, and data conversion of Legacy system data (.CSV file) to PeopleSoftHRMS tables using App Engine programs and SQRs.
- Involved in the design, development and testing of all HR, Payroll, Benefits.
- Used Application Engine, People Code and SQR extensively to create processes, outbound files and reports.
- Worked on reports to calculate billable hours based on hours filled and these reports are used to calculate LOP.
- Customized the email templates for Time and Labor approval, request and reminder mails.
- Created setup data for Time and Labor and HCM using data mover scripts and excel to CI.
- Customized existing position data component.
- Involved feasibility analysis to develop Portal Involved feasibility analysis to develop Portal application.
- Designing the Pagelets, Navigation collections, content management and dashboard.
- Designing the Navigation collections by adding PeopleSoftand non - PeopleSoftlinks.
- Configure the Tabs, Home Page in PeopleSoftportal.
- Developed a custom PeopleSoftWorkflow Routing Page that configures Department Backup, Fiscal, Fiscal Backup, and Parent Department Approvers that the AWE Workflow SQL User list will use for Routing Workflow and Escalation.
- Involved in developing new People Code and customizing existing People Code based on user requirements.
- Creating new XMLP and PS Query Reports
- Developed custom PeopleSoftFluid Applications using People tools.
- Used to configure Fluid Mode People Tools settings, Web profile settings and Tile options
- PeopleSoftHCM application upgrade from 9.0 to 9.2.
- Develop conversion and/or load programs to support software upgrades, re-defined business processes and Integration of new businesses where necessary
- Development of Reports using SQR and crystal reports, Application Engine, People Code.
- Providing Quick internal & external links to users based on the roles
- Developed auto approval process, It will approve leaves of associate if Manager is not approved leaves by cutoff date.
- Developed audit records for core absence records
- Created new process for Long Leave and Maternity Long Leave reports it is used by variable pay calculations based on revenue enablers.
- Coordinates employee payroll request between unions and payroll for employees on leave of absence.
- Implements FMLA/Leave of Absence Database to process all leave of absence request within Octo and Quickbase.
- Created upload functionality for medical leaves for employee/manager and Admin Login.
- Worked for yearend logic for applying leave.
- Provided new functionality on HR Login page to apply leaves on previous months.
- Worked in creating Leave without pay, Leave taken, Project wise and department wise Leave related SQR reports.
- Performance tuned SQL, SQR & PeopleSoftprograms using Application packages.
- Automated PeopleSoftmigrations using Phire application.
- Extensive knowledge in writing and executing SQL queries, triggers and packages
- Created test case scenarios and managed the test cases using HPQC.
- Performed data conversions, report writing, report customizations, page customizations and People Code programming. Developed conversions programs to load Payroll and Benefit tables in PeopleSoft using SQR and Import manager.
- Maintaining Data Migration related Quality Documents, best practices and lessons learnt
- Supporting Data Migration central team during the SIT, UAT and Go-Live phases during local country roll-outs
- Involved in setting up the Security, which contains creation of permission lists, Roles, assigning Roles to the User Profiles.
Environment: PeopleSoftv9.0/9.2 Application Engine, PeopleSoftFluid Applications, AWE, SQR, PS Query, XML publisher, Workflow, SQR, People Code, Oracle 11i, UNIX/Windows NT, People Tools 8.55.