PROFESSIONAL SUMMARY:

• Over Ten years of experience in software design, development and implementation of various commercial applications in Workday, PeopleSoft, Oracle and Visual Basic
• Extensively worked on Workday data conversion & Workday integrations.
• Expertise in Workday and PeopleSoft HR, North American Payroll, Benefits Administration and Base Benefits.
• Developed and Tested User Defined Workday EIB's to enable processing of large - volume transactions.
• Expertise in Workday and PeopleSoft HR, North American Payroll, Benefits Administration and Base Benefits.
• Experienced in implementing Custom Integration, Packaged Integration and Studio Integration.
• Experienced in Workday Integrations (EIB’s, Core Connector & Studio), iLoad, Data Migration and Reporting.
• Experienced in Data Migration through iLoad and spreadsheets.
• Provided Project Management Support, Team Building, Cloud Systems Architecture, Mentoring, Systems Analysis.
• Implemented Custom XSLT file to transform the content into a CSV file format. Also Experience with the various technologies involved in development (XML, XPath, XSLT, SQL, Web Services)
• Hands-On Experience in Configuring with Custom reports, Calculated fields, Workday Studio, EIBs, Core Connector, Cloud Connector (CCB), Report Design, Business form Layout, Solution Manager.
• Developed detail Test strategy, plans and scripts to test specific HCM, Advance Compensation business process in HCM and Integrations.
• Experienced in configuring EIB, building Custom Report, Calculated Fields, and configuring studio integrations using workday delivered web services.
• Extensively involved in trouble shooting and fixing problems at development, system testing and post-production stages for various HRMS modules
• Developed/Tested User Defined Workday EIB's to enable processing of large-volume transactions.
• Defines Test Strategy and Test Approach. Manages the overall test project plan, time tracking, defect management, issue resolution, and risk management.

TECHNICAL SKILLS:

ERP: Workday, PeopleSoft

IDE: Eclipse, Oxygen, Workday Studio, TOAD, DB Visualizer

Database: Oracle 10/9.x/8.x/7.x, MS SQL Server 2000 and MS Access

Operating Systems: Windows, Linux, UNIX and Mac

Software / Products: Workday, Oracle, PeopleSoft, ADP

Languages / Tools: Java, MVEL, XML, XSLT, JIRA, SOAP UI, People Code, PL/SQL, CWorkday Studio, VB, HTML

General Tools: Microsoft Excel, Microsoft Word, Microsoft PowerPoint

Reporting Tools: Workday Report Writer, WD Studio Report Designer, SQRCrystal Reports, Kronos 9

PROFESSIONAL EXPERIENCE:

Confidential, Morristown, NJ

Workday HCM Consultant

Responsibilities:

• Created Unit Test scripts, created test data by running various BPs and Tested the Integrations.
• Created advanced reports and used those reports as RAAS (report as a service) REST calls to extract data from workday to studio and use it as per the integration requirements.
• Configured Security Groups like Role Based Security, Segment Based Security and Integration based security groups.
• Created different custom reports like Advanced, Matrix, Composite Custom Reports for Benefits Audit, Time off balances and accruals using Workday Report Writer.

Confidential, Chicago, IL

Workday HCM Consultant

Responsibilities:

• Created several custom reports using Workday Report Writer and Modified Workday Standard reports according to client requirements.
• Created several custom reports and exposed as web services for several vendor files.
• Developed Several EIB inbound and outbound integrations.
• Involved in Development, Enhancement, Upgrade, and Maintenance of HR, Benefits, and Payroll.
• 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.

Confidential, Chicago, IL

Workday Integration Consultant

Responsibilities:

• Designed and built inbound and outbound studio integrations with RaaS reports.
• Developed Payroll Integrations for SJM to TIBCO to SumTotal using Workday Studio.
• Developed Several EIB inbound and outbound integrations.
• Created several custom reports and exposed as web services for several vendor files.
• Created Business processes for Employee Time Management/ Time Tracking, Created a Core Connector and Setup Custom fields for Functional purposes.
• Pay group reduction with PR as state.
• Developed several Transformation scripts using XSLT, Document Transformations (DT) using ETV and XTT functions.
• Created Performance Review template using complex WD Studio BIRT Report designer.
• Developed several custom reports using Workday Report Writer and Workday Studio BIRT and Modified Workday Standard reports according to client requirements.
• Developed Complex Workday Studio for Hire Right for Background Checking.
• Involved in Business Process configurations like Staffing, Talent management, Advance/Core Compensation, and Payroll Interfaces etc.
• Created XSLT scripts for Integrations to transform XML data.
• Created Several Custom Reports and calculated fields for Core HR, Payroll and Benefits.
• Created Custom Security Groups and Custom Security Roles.
• Provided Mentorship and Design documents for Reports and Integrations.

Environment: Workday, Workday Studio, EIB, Workday Report Writer, Document Transformation, BIRT, Cloud Connectors, XSLT, XML, Web Services, Report Writer, Oxygen Editor, SOAP UI.

Confidential, Nashville, TN

Workday Techno Functional Consultant

Responsibilities:

• Involved in Development, Enhancement, Upgrade, and Maintenance of core HR, Benefits, Time Tracking, Absence Management and Payroll.
• Build Workday Integrations for Third party Systems and Internal Systems using Workday Integration tools like EIB, WD Studio, Cloud Connectors and Document Transformation.
• Developed Fidelity 401K Integration using Workday Studio to send Employee contributions pretax amount based on Payroll Schedule.
• Configured Core Connector Worker to send Employee Changes to Internal Data Ware house system.
• Created EIB Integrations and XSLT Transformation script to send Employee FSA elections to P&A Admin Vendor.
• Developed COBRA Integrations for 18 Months and 36 Months Eligibility file for COBRA Administrator.
• Configured Security Groups like Role Based Security, Segment Based Security and Integration based security groups.
• Created different custom reports like Advanced, Matrix, Composite Custom Reports for Benefits Audit, Time off balances and accruals using Workday Report Writer.
• Worked on various enhancements related to EIB Integrations, Core Connectors, CCB, Studio Integrations and Custom Reports
• Developed multi-dimensional reports and analytics with the ability to drill down to transaction-level Details.
• Worked on Simple and advanced integration with Workday Studio and applied XSLT transformations to XML Data. Worked extensively on web service integration (SOAP, WSDL, and XML)
• Used delivered ETV/XTT functions from a Custom XSLT file to transform the content into a CSV file format
• Worked Extensively and Shared the knowledge with the team
• Created advanced reports and used those reports as RAAS (report as a service) REST calls to extract data from workday to studio and use it as per the integration requirements.
• Worked on testing the data and security issues with the data from the reporting prospective.
• Created Ad-Hoc custom reports for functional Users and Validated Data.
• Experience in using the XML, XPATH, WSDL and XSD. Ability to write XSL transformations to transform the web service (SOAP) requests to meet the requirements.
• Configured Business Process Step rules, integrations in Business processes and Notifications.
• Created Unit Test scripts, created test data by running various BPs and Tested the Integrations.

Environment: Workday 30/29, EIB, Workday Studio, XML, Web Services, XSLT 2.0, Report Writer.

Confidential, Columbus, OH

Workday Consultant

Responsibilities:

• Designed and built inbound and outbound studio integrations with RaaS reports.
• 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.
• Created Business processes for Employee Time Management/ Time Tracking, Created a Core Connector and Setup Custom fields for Functional purposes.
• Developed several custom reports using Workday Report Writer and Workday Studio BIRT and Modified Workday Standard reports according to client requirements.
• Developed Complex Workday Studio for Hire Right for Background Checking.
• Worked with client to build new reports from scratch and build a fit/gap related to the technical aspect of workday reporting.
• Configured Domain Security Policies and Created Integration System Security Groups and Segment based security groups and assigned to users.
• Involved in Business Process configurations like Staffing, Talent management, Advance/Core Compensation, and Payroll Interfaces etc.
• Created XSLT scripts for Integrations to transform XML data.
• Created Several Custom Reports and calculated fields for Core HR, Payroll and Benefits.
• Created several custom reports and exposed as web services for several vendor files.
• Created Custom Security Groups and Custom Security Roles.
• Provided Mentorship and Design documents for Reports and Integrations.

Environment: Workday, Workday Studio, EIB, Workday Report Writer, Document Transformation, BIRT, Cloud Connectors, XSLT, XML, Web Services, Report Writer, Oxygen Editor, SOAP UI.

Confidential, Baltimore, MD

Workday Consultant

Responsibilities:

• Involved in Development, Enhancement, Upgrade, and Maintenance of HR, Benefits, and Payroll.
• 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 reports for Time Tracking employee information by Creating Business Process and Core Connector integration based on the Vendor Requirement.
• 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 Counion 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, Worker US Tax elections etc.
• Created XSLT scripts for Integrations to transform XML data.
• Created Several Custom Reports and calculated 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, Enterprise Interface Builder, Workday Studio, Workday Report Writer, XSLT, XML, Web Services, Report Writer, BIRT, Oxygen XML Editor, SOAP UI.

Confidential, Cleveland, OH

Workday Consultant

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.
• Configured PICOFs to integrate with payroll vendors.
• Configured Cloud connectors for Benefits Integrations for Minnesota Life Insurance, Delta Dental, AARA Legal, Kaiser Medical etc.
• Performed arithmetic calculation in Matrix report for counting, averaging, summing, ranging between maximum and minimum.
• 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, Workday Studio, EIB, Workday Report Writer, Document Transformation, BIRT, Cloud Connectors, XSLT, XML, Web Services, Report Writer, Oxygen Editor, SOAP UI.

Confidential, Atlanta, GA

PeopleSoft Consultant with Workday Implementation and Support

Responsibilities:

• Created EIB’s (Enterprise Interface Builder) involving custom XSLT transformation as per requirements.
• Worked on Compensation Merit Process including Performance Ratings and Compensation Matrix.
• Developed the Workday Recruiting Inbound Integration from ICIMS.
• 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.
• Extensively Worked on Analyzing client's HR/Payroll business needs through client working sessions and supported development of new business processes and a future state design.
• Worked directly with client and consulting technical teams to wrap-up high priority issues on reports.
• Created complex custom reports using workday report writer for Wellness employee data, Benefits Billing cash, Cobra enrollment, Merit changes etc.
• Developed Workday Studio Outbound Integration to detect the employee changes and send that information to PeopleSoft expense module.
• 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 intervals.
• Ensure the assigned Test Cases and Test Scripts, required to test all system interfaces are completed according to the project schedule.

Environment: Workday 15, 16, 17, 18, Workday Studio, EIB, Workday Report Writer, XSLT, XML, Web Services, Report Writer.

Confidential, Washington, DC

Workday Consultant

Responsibilities:

• Involved in Implementation, Upgrade and Maintenance of PeopleSoft Core HR, Benefits, Compensation, Payroll and Time Tracking.
• Used File Layout, AE program, SQR program and DMS script, worked with data mart team to create outbound feed to Data-Mart.
• Developed & Customized PeopleSoft objects such as Fluid Pages, pages, components, records, fields etc and wrote PeopleCode at various levels such as record level, page activate, component-record level.
• Developed complex CIs, SQR processes, email notification processes, batch and scheduled processes, file transfer and data load AEs from third party inventory for data conversion and comparison activities to create flat files for validation
• Worked extensively on data conversion activities from PeopleSoft 9.0 to Workday which involves consolidation of SQR reports, SQL scripts, AE processes, and all PeopleSoft objects identifying and retaining client core functional processes, retrofitted PeopleSoft custom objects, PeopleCode, and SQRs.
• Modified the Application Engine programs, People code, SQR related to Kronons to PeopleSoft .
• Created several Queries, SQR reports for the users.
• Resolved Payroll Interface production support issues
• Loaded the Payroll Interface inbound interface data into seven different tables
• Created a customized page for the users to review receipts that are not matched before the accrual process.
• Created an App engine that closes the unmatched receipts after the user approvals from the above page.
• Create Test plan and assist with test script creation
• Developed PS to/from Kronons Demographic information and Hours/Time interfaces.
• Apply Patches, Bundles and NA TaxPatches for Demo, Dev, Test and Production Application.
• Created new benefit interfaces for various external vendors.
• Unit Test Plan, Unit Test results, migrating to QA and TEST instance.
• Load data from excel to PeopleSoft using Component Interface. Customized Application Messages. Developed Application Engine program to create interface files and send to ADP.
• Documented Impact Analysis of custom interfaces, reports and processes that are impacted due to the Benefit Setup changes in PeopleSoft 9.0 that includes Calculation Rules, Life AD/D and disability plan setup, FSA Plan setup changes, Rate configurations, dependent and beneficiary additions in the system.
• Customized Position Management pages by adding Key Position, Officer and Manager checkbox to test the Business traveler configuration changes
• Run the Payroll Interface process which include Deduction calculation, Additional Pay, Import and export application engine process and send the file to ADP
• Created and modified Pages, Reports and Inbound and Outbound Interfaces to include and exclude client requirement employee groups

Environment: PeopleSoft HCM 9.1, People Tool 8.50, Oracle, Application Engine, Application Packages, People code, Component Interface, Integration Broker, SQRs, Data mover .

Confidential, Washington, DC

Sr. PeopleSoft Consultant

Responsibilities:

• Perform requirement gathering and Fit/Gap analysis to highlight the business objectives fulfilled by delivered PeopleSoft system and the business objectives that required customization.
• As Technical Developer, was responsible for analyzing and creating technical specifications for all the customized pages and processes.
• Developed run control records and pages to get user input and added process definitions to SQR and Application Engine program.
• Used Process Scheduler to link existing and newly created SQRs to menu items and scheduled several periodic reports.
• Extensively worked on creating new objects and involved in customizing the existing People Soft objects. (Pages, Components, Menus, People Code and Process Definition)
• Disabled all Add/Update Person, and Personal Data components (like Address, Email Addresses, Phone, Ethnicity) in HR database and mapped these components from CS 9.0 database.
• Configure various Integration Broker Services like PERSON BASIC SYNC, WORKFORCE SYNC, and PERSON DIVERSITY etc. to implement Owner/Subscriber Model for external systems.
• Implemented "Approval Workflow Engine" for getting approvals for Access request from different level of management persons.
• Wrote Nightly Application Engine program to Lock/Unlock and create network accounts for Employees.
• Created several new pages, records and other PeopleSoft objects and components utilizing using Application Designer, SQR, App Engines to build a custom process within PeopleSoft .
• Created several Data Mover Scripts as part of the cut-off strategy Export and Import data.
• Build custom App. Engine program (Pre CommGen process), Purpose of the process to build the data source based on criteria and call PeopleSoft CommGen process to send out admission communication.
• Worked on HR Job Data changes like Dept Change, Job Code Change, Pay Group Change, Supervisor Change, Title Change, Salary Admin Plan Change, Hire, Rehire, Termination, Leave of Absence, Transfer and Employee Benefits Data
• Created new message integration between the systems to create/update the user profiles and grant the access to components or pages.
• Wrote technical specifications for setup pages, Online Application pages and Readmission Application Pages.
• Configured USER PROFILE sync service operation and customized handler peoplecode to sync all user profiles between CS and HR database

Environment: PeopleSoft HCM 9.1, People Tools 8.51, Application Engine, Application Packages, Component Interface, People Code, Integration Broker, SQRs, Data mover, Query manager, Oracle 10 .

Confidential, Duluth, GA

Sr. PeopleSoft Consultant

Responsibilities:

• Conducted required gathering sessions for custom requests and created functional design documents.
• Worked on Approval Workflow Engine. Customized AWE for Full Time/ Part Time Authorizations and Promotions.
• Analyzed the mapping sheet and retrofitted SQR's, and other PeopleTools objects.
• Worked on Integration Broker, Application Messaging, created WSDL for PeopleSoft pages and exposed them to be consumed by the Java front end.
• End to end Implementation of custom Hierarchy and Workflow process.
• Designed several Interfaces (outgoing and incoming) to interface data to and from the Recruitment application being used
• Used PS Query to generate the reports.
• Worked on streamlining PROD SQRs by creating run control panels for all batch SQR's for scheduling them on Process Scheduler in the nightly report run.
• Perform the Data Mapping and Data Migration activities to roll out the system across the globe over a period.
• Involved in customization of delivered functionality and development of new Pages, Components and menus using PIA in Campus Community and Admissions.
• Modified application evaluation process using existing SQR's, SQC's, Panels, Records, Views to in corporate and implement changes according to each school's formula. Analyzed production problems.
• Developed interface programs converting data into PeopleSoft tables and SQR's for corresponding validation reports.
• Ran regular compare reports between Prod & Sys environments to ensure integrity of data during migration processes.
• Created Run Control Pages and defined new Process Definitions in the Process Scheduler to run SQR Reports and Application Engine Processes
• Modified application evaluation process using existing SQR's, SQC's, Panels, Records, and Views to in corporate and implement changes according to each school's formula. Analyzed production problems.
• Debugged various application engine programs that error out during the upgrade run.

Environment: PeopleSoft HCM 9.0, People tools 8.50, People Code, Component Interface, Application Engine, Application Packages, Integration Broker, SQRs, Data mover, Query manager.