SUMMARY:

• A self - motivated Consultant with over 25+ years of experience as an information technology professional. I have extensive experience within ERP Technology working with On-Premise ERP (Peoplesoft) and transitioning to Cloud ERP (Workday), with a strong technical aptitude across a variety of platforms.
• IT experience in implementation of HCM (Human Capital Management) applications using cloud solution and ERP technologies.
• Experience as Workday Techno Functional Consultant and involved in two full cycle implementation project.
• Extensively worked on all phases of the Workday implementation lifecycle namely - Requirement gathering, Analysis, Design, Development and Testing.
• Experience in designing Workday integrations.
• Created Supervisory Organization, Re-Organization, Matrix Organization, Sub ordinate Organization, Locations, Positions, Region, Cost centers, Staffing models, Jobs, Position and Compensation
• Extensively worked on Payroll Interfaces and have designed and developed integrations in Connector, Connector.
• Experience in inbound/outbound integrations Using Core Connector, Workday Studio, managing business processes, working with EIB, Report Writer, Creating Workday Calculated Fields and Custom Reports.
• 2 years of experience with XML, XPATH/Document Transformation and XSLT.
• Experience in implementation of software applications using Client/Server and ERP technologies in customization and implementation of PeopleSoft Applications in HCM (Human Capital Management)
• Good understanding of business process and strong background in PeopleSoft HRMS modules like Core HR, Base Benefits, Time & Labor and North American Payroll.
• Extensive experience with development tools and possess in-depth knowledge of PeopleSoft applications.
• Experience with web service integrations (SOAP, REST, WSDL, and XML).
• Collaborated on client engagement strategy to drive entry into risk-driven project methodology, improving accuracy of project definition, sizing estimates, and yearly resource budget planning.
• Improved client relationships and project predictability through shared business and technical perspectives, agreed project roles, risk assessment, use cases, transparent business-aligned development efforts, and time-boxed delivery.
• Collaborated with team members to design and implement enhancements for projects.
• Good problem solving, client interaction, training and team building skills.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level.
• Good coordination skills with different teams to resolve Development and Quality Assurance related issues.
• Collaborated with Human Resource Department to ensure smooth work flow and efficient organization operations.
• Created a decision matrix spreadsheet to evaluate various approaches to designing Security Permission Lists and Roles
• Brainstormed development team evolution strategy and deployed best practices.
• Served as leader during Peoplesoft tax patch implementation

TECHNICAL SKILLS:

• EIB
• Report Writer
• Workday
• Core Connector
• Studio
• ACA go-live
• Analytical Skills
• Banking
• Benefits budget planning business process business processes
• Consultant
• Consulting client
• Data conversion data warehouse
• DBA databases database debugging delivery designing documentation
• Engineer
• ERP functional
• Government
• Human Resource
• Human Resources
• HR
• DB2
• IMS
• Leadership mainframes access
• Microsoft Access
• Works
• ESS
• NoSql
• ODS
• Oracle
• Developer
• PL SQL
• PL/SQL
• Payroll
• PeopleCode
• PeopleSoft
• Peoplesoft 9.0
• Peoplesoft 9.1
• Peoplesoft 9.2
• Peopletools
• Peopletools 8.5.2 processes
• Process Improvement
• Programming reporting
• Requirement
• Requirements Analysis risk assessment
• SDLC
• Scripts sql
• SQL server
• SQR strategy system administrator system administration tables tax
• Technical Training
• TOAD troubleshooting
• UNIX upgrade utilities validation view
• Workflow
• XSLT year- end
• EDI
• Web Services
• XML
• XSLT
• Java
• DT

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Senior Consultant

Responsibilities:

• Created different staffing models, defining hiring restrictions to Job Management, Position Management and Headcount Management.
• Created various security groups like User based security groups, Role based security groups and Job based security groups.
• Developed Custom Reports, Advanced Reports and Calculated fields.
• Designed and build both inbound and outbound EIB integrations in various segments of Workday system EIB, Core Connector, Cloud Connector and Workday Studio.
• Experience in generating Custom Reports, Custom fields.
• Analyzed client’s HR/Payroll business needs through client working sessions and supported development of new business processes and a future state design.
• Hands on Workday systems integration experience building custom integrations using Workday Studio, Cloud Connect and Document Transformation.
• Creating the new business processes and notifications in deployment and sandbox tenants based on the designed business flow diagrams
• Day to day support of Workday Integration issues.
• 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.
• Used delivered 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.
• Designed and developed a set of integrations to integrate Workday HR with external systems.
• Participate in the design of major features from initial requirements through customer acceptance.

Senior Consultant

Responsibilities:

• Created ETL process for converting data from Peoplesoft to Workday
• Consulted with functional team members to develop business requirements
• Translated business requirements into technical requirements
• Developed extraction programs using SQR/App Engine for reconciliation process.
• Responsible for leading the data cleaning and transformation effort for conversion.
• Created technical design, data mapping and trouble-shooting issues.
• Unit-testing of all conversion and validation scripts.
• Prioritize conflicting demands with little supervision.
• Facilitated discussions on data requirements, conversion methodology and data validation.
• Worked on the transformation using XSLT.
• Worked with Workday Custom Reports and Calculated field
• Worked on the change detection logic for different types of Customized Calculated Field
• Created EIB (Enterprise Interface Builder) inbound/outbound integrations
• Experience creating Business Process like Hire Employee, and Termination Employee for testing scenarios
• Transferred data to/from tenants to SFTP, FTP Server (Using Document Delivery/Document Retrieval)
• Created different types of Supervisory Org, Position and Profiles for testing the data

Senior Consultant /PM

Responsibilities:

• Led team of consultants and users to define the current state of the reporting system.
• Maintained Security Matrix
• Addressed functionality and requirements related to upgrade from Peoplesoft 9.0 to 9.2
• Analyzed the functionality for Portal framework, Dashboards and WorkCenters delivered in Peoplesoft HCM 9.2
• Responsible for the final deliverables and knowledge transfer to the customer.
• Detailed the existing environment, including sample reports, reporting frequencies, structures of PS 9.0 ODS tables and PS 9.2 ODS tables, tables in the HRDB, and procedures used to develop HR Reporting schema
• Defined archive procedure for COTS systems for post go-live

Senior Consultant

Responsibilities:

• Responsible for gathering requirements and designing new vendor feed interfaces between PeopleSoft and 3rd Party vendors.
• Worked as a lead for large scale 9.1 HCM data conversion effort to convert a organization which supported 7 universities.
• Granted Roles/Permissions to Users
• Gathered functional requirements and converted to technical requirements
• Setup and update Row Level Security in HCM modules
• Enhanced, improved and modified other existing inbound and outbound vendor interfaces.
• Conducted Security Review for HCM 9.1 Implementation
• Reviewed Row-Level (Data Security) and provided recommendations
• Developed Security Matrix for tracking access, security updates, and auditing Performing analysis of Roles/Permission List usage to reduce redundancy Developed Security Analysis reports and matrices
• Trained staff - PeopleSoft Security Administration and Troubleshooting
• Created PeopleSoft object customizations (such as Pages, Components, Records, Menus, etc) using Application Designer.
• Served as lead during tax patch implementation compare reports and retrofits.
• Responsible for Creating Test Scripts/Test Scenarios, and performing/facilitating Unit Testing, System Testing and User Acceptance Testing after upgrade.
• Worked with DBA to review compare reports and upgrade documentation.
• Responsible for migrating object between database instances using STAT.

Senior Consultant

Responsibilities:

• Responsibilities included functional design and review for PeopleSoft Application data conversions, interfaces, custom reporting, and custom application.
• Developed of new stored procedures, functions using Oracle PL SQL Write and/or review requirements/specifications
• Used TOAD, SQL*Plus, PL/SQL Developer and UNIX utilities.
• Lead data conversions efforts Developed conversion programs using PeopleSoft technologies like SQR, Component Interface, Application Engine Handled low level system administrator duties
• Worked with Payroll ACH interface files for IAT employee records and compliance.
• Modified payroll and benefits objects and reports for year- end processing.
• Gathered analysis for development of vendor interfaces
• Coordinated with systems partners to finalize designs and confirm requirements

Senior Peoplesoft/Security Administer

Responsibilities:

• Configured and maintained security in all PeopleSoft production, test and development instances
• Granted Roles/Permissions to Users
• Maintained Security Matrix
• Created and updated user access per approved access requests, including roles, row level security setup and update objects with roles, permission list, query trees and access groups to the business needs.
• Setup and update Row Level Security in HCM and FSCM (Financial) modules
• Configured and maintain security user profile sync between HCM, Financial and ELM applications
• Setup and monitor dynamic roles where possible to improve and automate security maintenance
• Worked with IT and Project teams to provide oversight on data and system security including Integration Broker and Interfaces
• Analyzed, evaluate and develop solutions for business system needs and objectives for the user community based on established security best practices
• Communicated all security issues related to business system administration. This includes collaborating with functional and technical owners on incident management, problem management, escalation management and resource management
• Resolved application and functional security issues Assist with maintaining security integrity over the production and non-production environments Manage the testing and migration of security objects from the non-production environments to the production environment
• Worked with internal and external audit teams and provide proper documentations for compliance and audit reporting
• Ran daily, weekly and other periodic access reports and take action per established process
• Ensure helpdesk tickets assigned to ERP Security are resolved and closed in a timely manner
• Produced technical documentation on security processes and procedures

Senior Peoplesoft Developer

Responsibilities:

• Responsible for gathering requirements and designing new vendor feed interfaces between PeopleSoft and 3rd Party vendors.
• Designed new vendor feed interfaces between PeopleSoft and 3rd Party Vendors.
• Enhanced, improved and modified other existing inbound and outbound vendor interfaces using SQR.
• Created PeopleSoft object customizations (such as Pages, Components, Records, Menus, etc) using Application Designer. Also, created custom process definitions.
• Served as lead during tax patch implementation compare reports and retrofits.
• Responsible for Creating Test Scripts/Test Scenarios, and performing/facilitating Unit Testing, System Testing, and User Acceptance Testing after upgrade.
• Worked with DBA to review compare reports and upgrade documentation.
• Use Peopletools to create projects to move through objects through the environments.
• Updated pay-line information for deduction Implemented and maintained process to view Payroll on-line checks and online W2's. Maintained control and management of changes necessary for PeopleSoft by using Phire.

Senior Peoplesoft Developer

Responsibilities:

• Led team of five employees providing support for PeopleSoft Human Resources systems serving 22,000 employees.
• Responsibilities included gather business requirements and analyzing requirements to apply system solutions to business process.
• Worked rotating on-call for Time & Labor issues.
• Assisted the client in enhancing and improving the existing Open Enrollment approach.
• Worked on modifying/creating vendor feed, benefit reports, identifying and resolving issues, identifying alternative approaches and formulating recommendations.
• Gathered user requirements Designed and Developed customizations using PeopleSoft Application tools (Application Designer: Components, Pages, Records, Views, Query Manager, etc).
• Created custom reports for various modules such as HR, Base Benefits, Payroll, etc.
• Performed Unit Testing, System Testing, and Parallel Testing.
• Performed low level system administration duties