Sr. Hrms/payroll Analyst/sr. Programmer Resume
Oakland, CA
SUMMARY
- An IT professional with 10 years of total experience in design, development and implementation of software applications
- Workday Integration and Functional Consultant, having 3+ years of experience in Global Implementation in various Workday Implementation Projects.
- Handled multiple roles Workday Consultant, ERP Systems Analyst
- Good knowledge of EIB Inbound/Outbound Integrations, Workday Studio, Report Writer and Calculated Fields
- Involved in Full Life Cycle Workday Implementation Projects for banking company from strategy phase till deployment phase.
- Experienced in prototyping and configuring integration using studio, EIB, and cloud connect from HCM, Benefits, and payroll between workday and external systems. Excellent knowledge of XSLT, XSD, Custom Reports and Birt Report.
- Experienced in Business processes mapping and Providing Ongoing Production Support for various clients, including requirements gathering, process analysis, system configuration, development of system tests, procedures, and documentation.
- Experience in working with the various phases of an implementation lifecycle and knowledge of implementation methodology.
- Experience in all phases of the Workday implementation lifecycle like - requirements gathering, Analysis, Design, Development and Testing, defect tracking, quality assurance (QA/UAT), management, reporting and documentation and implementation of business application systems. Interface heavily with Business User Groups.
- Highly experienced serving as liaison between both onshore and offshore and managing and co-ordinating during all phases of testing cycle.
- Experience in testing Workday integrations
- Providing Workday Application Support to GL, AR& APteam.
- Created AR, AP & RTR SOP’s
- ProvidingAdmin & Production Support to Finance Team
- Creating and Mapping Accounting Rules in Workday
- Interface Strategy and execution for AP, GL
- Report output Mailing strategy tocorrespondingcost center manager.
- Good understanding of Integrations including Web Services, SaaS, Workday Architecture, Business Process Framework.
- Experience in testing inbound/outbound integrations using Core Connector, Workday Studio and EIB.
- Extensively created test cases for Payroll and non-payroll Interfaces
- Worked on business process framework and well versed with areas of HCM, staffing and compensation models.
- Developed testing strategies and verification scenarios along with project Scope and Requirement documents.
- Excellent client interaction skills and proven experience in working independently as well as in a team.
TECHNICAL SKILLS
Development Tools: Workday Studio, Oxygen XML Editor,Oracle PL/SQL Developer, Oracle Forms, Toad, SQL*Plus, Power Builder 6.0
ERP System: Workday HCM, Oracle HRMS 11i/R12
Workday skills: Workday HCM, Recruiting, Benefits, Integrations, Data conversions, Report Writer, Core connectors, EIB, PICOF and Workday Studio.
Web Technologies: XSLT, XSD, WEB Services, XML, HTML
PROFESSIONAL EXPERIENCE
Confidential, Washington DC
Workday HRMS Integration Consultant
Responsibilities:
- Implementing, Configuration, Integration Development and Maintenance of both Inbound and Outbound Integrations from Workday.
- Designed and Developed multiple integrations of type PICOF, Core Connector, EIB and STUDIO integrations for both Outbound and Inbounds.
- Developed custom integrations as part of the Workday implementation project for Cost Center, Departments and Location imports using Cloud Connect, Document Transformations and EIB.
- Analyzed client’s HR/Payroll business needs through client working sessions and supported development of new business processes and a future state design.
- Part of Test Team for the HR/Payroll Workday Implementation project.
- Tracked and disseminated daily updates and concerns throughout the testing process to the implementation team, consultants and vendors.
- Created advanced excel spreadsheets for tracking test results.
- Participated in the discovery sessions with client and vendors, created the design and mapping documents and submitted the same for sign off.
- Creating the new business processes and notifications in deployment and sandbox tenants based on the designed business flow diagrams.
- Providing Workday Application Support to GL, AR& APteam.
- Created AR, AP & RTR SOP’s
- ProvidingAdmin & Production Support to Finance Team
- Creating and Mapping Accounting Rules in Workday
- Interface Strategy and execution for AP, GL
- Day to day support of Workday HCM, Security, Compensation and Reporting issues.
- Creating the new business processes and notifications in deployment and sandbox tenants based on the designed business flow diagrams.
- Experienced to work with Workday Report Writer and creating custom integrations with third party applications using Workday Cloud Connect and Enterprise Interface Builder (EIB).
- Created new integration to pull the new hires information using Core Connector Worker and Document Transformation which uses connector integrations XML Output as its data source input.
- Used delivered ETV/XTT functions from a Custom XSLT file to transform the content into a CSV file format.
- Used sequence generators, generating templates and validating inbound integration system results.
- Created and used calculated fields in reporting, business processes, integrations and other areas within Workday.
- Knowledge of Domain, Role and User based security.
- Involved in Data Conversion, Workday BP Configuration.
- Designed and developed a set of integrations to integrate Workday HR with recruiting system.
Confidential, Dallas, TX
Workday HRMS Integration Consultant
Responsibilities:
- Key role in buy decision, initial scoping, requirements gathering, design and development plans.
- Understand and assist in Workday functional configuration
- Underwent Workday training to understand the functionality and architecture
- Led building various Custom Reports (using complex calculated fields)
- Complete development of 10 integrations
- EIB development using custom XSLT and xml
- Workday Studio projects development
- Coordinated and developed various benefit integrations (Vision, Medical, Custom Payroll)
- Support of various post production issues for benefits integration Created around 10 Merit based statements, salary statements, equity award statements using Business Intelligence Reporting Tool (BIRT) in Workday Studio.
- Created around 30 Integrations using Studio, Cloud connect and EIB (Integration) to output data from workday into external systems through Studio, EIB and Cloud connect.
- Managing Data conversions, HR and Compensation related Custom Reports, BIRT Report, Security Management, Business Process configuration and, configuring the application according to customer requirements and developing system Integration .
- Help team in functional configuration and technical integration of the Workday application and updates
- Work on Workday conversion processes and tools like iload, EIB, Workday Studio etc.
- Integrated Workday with external vendor software and across multiple third parties and client's
- Develop testing strategies and verification scenarios along with project Scope and Requirements documents
- Working directly with key business and IT stakeholders to confirm requirements, consider design alternatives, facilitate design sessions and ultimately deriving Integration sign-off.
- Organizing and defining the implementation strategies to improve the effectiveness of technology across the entire client HR function.
- Developing test plan and strategy for Workday implementation engagements and advise clients on Workday testing with best practices.
- Providing performance tuning of the integrations and monitoring SIT, UAT and migration activities.
Confidential, Oakland, CA
Sr. HRMS/Payroll Analyst/Sr. Programmer
Responsibilities:
- Involved in full life cycle implementation of HR, Payroll.
- Involved in Preparing the Customer Specification Document (CSD), Development of HR user procedures.
- Involved in preparing CV10 conversion strategy and requirements documents, CV40 conversion mapping documents and MD070 Technical Design Document for INTERFACES.
- Involved in data conversion from Legacy to Oracle HRMS.
- Worked on different HR API’s like EMPLOYEE, ADDRESS to update the Employee personal details, ASSIGNMENT to create new assignments and update the assignment details, LOCATION, SIT to create and update Special Information Types, PHONE to create and update employee’s phone numbers, CONTACT to create contact of an employee, SALARY to create and update salary, PERSONAL PAYMENTS to create and update personal payments for employees, COSTING to update and create costing segments at assignment level and BALANCE ADJUSTMENT to adjust payroll balances.
- Totally involved in conversion strategy, requirement gathering and technical design in converting PAYROLL BALANCES for Q1 before Go-Live.
- Performed balance adjustments to correct missing mid-year payroll balances. Provided extensive post-production support and end-user training
- Loaded recurring employee earnings and deductions using Batch Spreadsheet Interface process
- Involved in running the complete Payroll Process beginning loading BEE batches all the way till Transferring costing to GL
- Ran PAYROLL, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import PAYROLL transactions from HRMS.
- Design and create accounting key flex fields for costing and added new segment values for Organization index code and short code as required.
- Involved in Design and Development of Conversions for Oracle Benefits.
- Developed PAYROLL FAST FORMULAS for different benefit plans.
- Involved in customizing the seeded Pay advice slip based on client’s requirement.
- Involved in developing offshore payroll interface for offshore employees, where their payroll was already run their ships. We replicated the same payroll into Oracle for generating W2’s
- Updated different element setups after go live based client’s requirements
- Some employees had issues with Gross amount. This amount was not matching on their SOE to Pay advice slip. I was involved in fixing this Issue.
- Involved in development and testing of Benefits and payroll interfaces. Developed an interface to transfer the benefits information.
- Worked on OA Framework for implementing pop list
- Worked on OA Framework to embed a Custom Screen into a standard OA Framework Screen
- Experience in extending self-service applications using OA Framework.
- Developed many custom reports like New hire/Termination Report, Employee roster Report, Audit SOX Report and Benefit Reports using DISCOVERER REPORTS, XML publisher and REPORTS 6i.
- Involved in performance tuning of PL/SQL PROCEDURES, FUNCTIONS and PACKAGES using Explain Plan and TKPROF.
- Developed Various Inbound Time and Attendance Interfaces for different Time keeping system like KRONOS,ENRICH, TPR,NS5 and Keypunch
- Developed Various Outbound Interfaces for different 3rd party system like A&B,KRONOS, PAYFLEX,NS5 and FIDELITY
- Created paycheck report using OA Framework and Java.
Confidential, Salt Lake City, UT
Sr. OTL Analyst/Sr. Programmer
Responsibilities:
- Interacted with user and collected OTL requirements from 3 different regions (African, US and LATAM).
- OTL Interface: This interface, an outbound interface for Pay Space ( A third party vendor) for Africa Region was designed to provide sum of hours entered on time card based on elements, projects, tasks.
- Wrote an ADP Outbound Interface for US.
- Wrote custom time entry rules for Eastern Europe region which validates the date entered from where custom overtime explosion fires for both regular day element and regular night element.
- Wrote custom time entry rules for African region which validates the holiday hours entered. In Africa region even after having a predefined holiday calendar. The government has to right to declare any working day as a Government holiday where a time keeper is allowed to enter only holiday hours.
- Gathered requirements from end users for the business group LATAM consisting 6 countries with unique set of Time entry rules.
- Wrote about 40 custom Time entry rules for LATAM region.
- Used WEBADI, Data loader to load time on to the timecards.
- Developed OTL Fast Formulas for the Validations required by the User.
- Developed XML Publisher Reports.
- Worked in Production Support and interacted with end users.
- Worked in Production support writing new OTL Fast formulas and modifying existing fast formulas.
- Created the User and attaching the Time Entry Rule Groups /Time Entry Rules to the user Preferences
- Worked on modifications in ADP Interface to add new fields.
- Worked on Requirement gathering and Documented MD-50, MD-70.
- Involved in Migration of the Codes Packs
- Worked on OTL Timecard Layout Customizations
- Worked on element entry, salary conversions
- Worked on the Performance Issues in the Production support.
- Developed Fast Formula to Validate Sunday Hours only on Sunday Etc.
- Customized the Oracle Workflow templates to meet the business requirements and modified the existing Workflow process to accommodate the changes.
- Involved in full length implementation of Contingent Worker Hiring process which involves customizing the seeded OAF pages and Oracle Workflow process to meet the business requirements and modified the approvals styles.
- Worked on an Inbound and Outbound Interface to run as a nightly process to send the information to vendor.
Confidential, Framingham, MA
Sr. Analyst / Sr. Programmer
Responsibilities:
- Involved in complete HR, Payroll and OAB Global implementation life cycle.
- Involved in user meetings for requirements gathering.
- Responsible for designing and developing Time Entry Interface (OTL), this interface was designed to transfer contract PAYROLL time files from time entry systems on biweekly basis.
- OTL Interface: This interface, an outbound interface, was designed to provide information about the balances of hours. It was designed to run on weekly basis.
- Interacted with the end users to discuss the business rules and come up with MD070 Design Documents.
- Involved in Design, Development and Testing of RICE components.
- Involved in Conversions like Employees, Addresses, Extra Information Types and Assignments, Element Entries, Balances etc.
- Ongoing support to HR and Payroll Systems.
- Involved in Design and Development of Conversions for Oracle Advanced Benefits.
- Developed new OAB fast formulas for Participation and Rate Eligibility, Compensation Calculation etc.
- Developed MetLife inbound and outbound interface
- Wrote OAB outbound interfaces.
- Worked on Migrating the Code, documents from instance to instance using KINTANNA.
- Created reports using XML Publisher.
- Involved in the various levels of testing.
- Post-production Support for HR, Payroll and Benefits.
- Self-service customizations using OA Framework and personalization of Self service at different levels.
- Worked in Approvals Management Engine (AME)
Confidential, Dublin, OH / Atlanta, GA
Sr. Analyst / Sr. Programmer
Responsibilities:
- Design technical specification documents for the conversions like Locations, Organizations, Jobs, Grades, Positions, Valid Grades, Employees, Addresses, Phones, Special Information Types, Assignments, Salary, Performance Reviews, Personal Payment methods, Federal Taxes, State Taxes, City Taxes, Garnishments, Provincial Taxes, Element Links, Element Entries (Earnings and Deductions), Balances etc.
- Interfaces like Master Tax (RTS & PTS), ADP Interface, Mercer 401K Inbound & Outbound, UTL 120 Interface, Identity management, TALX Employment Verification, Employee changes to Radiant/RTI, Positive pay etc.
- Fast Formulas related to PTO and Payroll.
- Developed new hire self-service pages using OAFramework and Java.
- Resolve any technical issues related to Payroll runs, Pre-payments, Costing, Check Writer, NACHA, Deposit Advice, Costing, and Transfer to GL etc.
- Post production support for HR, Payroll modules.
- Created various reports with Multi-Org functionality having the capability of checking for different Operating Units, Business Units, Departments and Cost Centers on OTL, Missed Timecard Report. Used tables from different schemas like OTL, PER, HR, etc. Customizing the Self Service Timecard to Auto-Populate the time card by updating assignment information to set the time card to yes for auto generating employees information.
Confidential, Irving, Texas
Sr.Techo-Functional Analyst / Sr. Programmer / Sr. Designer / Systems Integrator
Responsibilities:
- Designed, Developed and Tested PTO Accrual Fast Formula, PTO Balance Adjustment, Canada Trueup Earnings, 60 Day Termination Process, Employee and Contact Name change to Mixed Case, Update Federal and Province Basic Exemption Flag based on several criteria’s, Update Average Benefit Base Rate (ABBR) for Employees, Element Entry Adjustment, Populate LTC Calculated value in a SIT etc.
- Designed Developed and Tested Workers Compensation by Province Report, Newhire - Rehire Report, Commission Daily Activity Report and Management Incentive (Bonus) Report.
- Guide and Assist the developers in achieving the tasks in a timely manner.
- Customized Self-Service web page to meet the client requirement.
- Modified Work Flow so that notifications are sent as per the client requirement.
- Indentified Requirements for Absence management, documented requirements, MD050 and MD070.
- Configured the Absence management, along with the AME. Implemented Job/Grade re-structures and prepared MD50, MD70 End dated jobs, grades.
- Created new jobs, grades and valid grades.
- Customized forms through Form personalization to facilitate automatic population of bank information flex field to avoid human error.
- Developed a program to update all the active assignments.
- Designed and extended some complex rules that can’t be configured as part of OTL
- Identified requirements for Performance management and documented them.
- Creating competencies, objectives, linking competencies to qualifications and creating objective assessment templates, linking to appraisals and publishing plans.
- Worked on OAB open enrollments, iprocurement, payroll interfaces and also some discoverer reports.
- Wrote OTL Fast Formulas according to client's requirements.
- Customized accrual fast formulas for different leave types.
Confidential, Memphis, TN
Sr. Programmer & Business Analyst
Responsibilities:
- Developed and tested enrollment and rate overrides scripts.
- Developed conversion script to load the standard rates.
- Developed Eligibility Silver Script for MEDS using System extract.
- Involved in user meetings for requirements gathering.
- Developed a script and cleaned up the open action items for Beneficiaries and Dependents.
- Cleanup student status and student special information type.
- Populated Plan and option lookup values using a data loader script.
- Developed UHC system extract interface.
- Worked on open INTERFACES like batch element entry and OTL-HR data transfer.
Confidential, Coppell, Texas
Programmer Analyst
Responsibilities:
- Designed, Developed and Tested Regular Year to Date Balances, PTO Balance, and Arrear Balances Interface to ADP.
- Designed, Developed and tested a program to update 401K Eligibility in a SIT (Special information Type).
- Developed and tested reports like Language report, License report, Tax, Telephone, Personal Data, Direct Deposit, Job and Employment report.
- Created business areas with complex folder, summaries and hierarchies for various HR, and OTL modules.
- Designed all HRMS conversions like Locations, Organizations, Jobs, Grades, Employees, Applicants, Addresses, Assignments, Salary, Elements, Taxes, Balances, Personal Payment methods, Extra Information Types, Oracle Advanced Benefits etc.
- Reviewed interfaces like BCBS of TX, BCBS of MA, Boon Chapman, Cigna DMO, Eckerd Health Services, Harvard Pilgrim, Value Options, and Vision Service Plan (VSP) - Eligibility Interface Design Document etc.
- Developed code for almost all conversions like Locations, Organizations, Jobs, Grades, Employees, Applicants, Addresses, Assignments, Salary, Elements, Taxes, Balances, Personal Payment methods, Extra Information Types, Balances conversions etc.
- Developed script to migrate concurrent programs from one instance to other.
- Developed script to delete employees and test all conversions again and again.
- Also responsible for logging TAR’s, Issues, Service requests etc,