Client Relations Production Support

RAMA KILARU

402-***-**** - *********@*******.***

SUMMARY:

Analytical, results-driven Software Professional with over 25 years of experience in development, production support and systems integration, managing and directing teams. Expertise in PeopleSoft modules, including 20 years in implementation, upgrades, data conversion and maintenance of packages with solid knowledge of People Tools, Application Designer, Security Setup and Server Administration, Query, and People Code. 20 years of experience as PeopleSoft Technical & Functional Lead in implementation and upgrades. 20 years of testing experience with PeopleSoft modules including 6 years of PeopleSoft testing framework and automating testing processes. 9 Years of experience in Implementing and Supporting ADP Technologies EV5, EV6, Vantage, WFN. Ability to customize existing PeopleSoft reports and create new SQR, Crystal, BI Publisher and nVison reports. Superior written and interpersonal communication skills, with strong client relations skills.

PROVIDING SOLUTIONS FOR:

Documentation

User Support

Team Building

Client Relations

Upgrades & Patches

Process Improvement

Requirements Analysis

Planning & Development

Project Management

Data Conversion

TECHNICAL SKILLS:

SOFTWARE PACKAGES:

ADP Enterprise EV5, EV6, Vantage, WFN, PeopleSoft 7.0/7.5/8.x/9.x Modules, Financials (AP, AR, GL, Billing, Projects, Contracts, Expense), HRMS (HRMS, Payroll, Benefit Administration, Enterprise learning, Recruit Workforce, Time & Labor), Distribution/Material Management, SQR, PeopleSoft Testing Framework, Crystal Reports, nVision, SQL Server, Oracle, Informix, Informix – Relational Object Manager SQL Editor 2.10 TC2.

PROGRAMMING LANGUAGES:

C, COBOL, SQL, PL/SQL, Visual Basic

OPERATING SYSTEMS:

Windows (XP, 2000, 2003, 2007, 2010, 2012, NT, 95)

EXPERIENCE:

Mosaic April 2024 – Present

PeopleSoft Tech & Functional Development & Production support Lead

Worked on PeopleSoft to Oracle data conversion.

Wrote data conversion scripts using SQR, data mover and application engine.

Involved in mapping Peoplesoft data fields to oracle.

Collaborated with functional and technical teams for seamless transition from PeopleSoft to Oracle.

Providing production support to the PeopleSoft systems.

Interact with business users and work closely on day to day operations of the PeopleSoft systems.

Involved in applying critical patches to the system.

ADP May 2022 – March 2024

ADP EV5, EV6, Vantage, WFN Tech lead Implementation Consultant/Business Analyst

Working on implementing and supporting ADP technologies for multiple clients.

Interacted with ADP clients collected the business requirements and translated into functional specifications and worked with technical team to help understand the requirements and ensured the smooth implementations and code changes.

Meeting the clients on collecting the requirements and working on writing specifications and design interfaces for multiple ADP clients.

Worked on developing ADPR reports for several clients as per the requirements.

Helping the project teams on go-live tasks. Supporting the team, serving backup for the team implementation manager.

Partnered with multiple teams internally and getting the required tasks complete for the projects to get ready for go-live.

Working closely with project managers, and management helping to evaluate the risks and delivery strategies to meet the tight deadlines.

Working closely with developers and offshore team on the requirements and getting the required development tasks completed to meet the project deadlines.

Well versed in multi-tasking, adapt to changes, communicate and collaborate with all the stake holders.

Worked on submitting the new transmission requests, for the successful interface file transfers.

MOSAIC, INC., Omaha, NE 2021 – 2022

Development and Integration Lead PeopleSoft

Worked with business partners to gather business requirements on multiple complex and strategic initiatives and translated into functional specifications and worked with technical team to help understand the requirements and ensured the smooth implementations and code changes.

Provided weekly status updates on the complex and key initiatives to the management.

Worked on road map for the applications and provided inputs to the management and provided recommendations on the application road maps.

Lead and managed multiple complex projects mentored and coached team.

Worked with vendors on and collaborated with internal teams and resources on changes, fixes and updates.

Played key role in working with vendors and maintained vendor relationship. Worked on vendor selection process on some of the key applications and strategic initiatives.

Worked with business partners and team and developed on-call rotation schedule for 24/7 support. Ensured ongoing troubleshooting, support, and maintenance of applications, including 24/7 on-call coverage as required.

Meet with business partners or weekly basis on work prioritizations for the technical team.

Worked with business on work prioritization, managed and assigned the remedy tickets and service requests to appropriate resources, and worked with team managing workload to see the assigned tickets are completed in timely manner.

Provided weekly updates to business partners on outstanding remedy tickets and service requests.

Worked with business and technical teams and provided recommendation on existing process improvements.

Worked on multiple FSCM upgrades to 9.2 image 25, 31 and 34 and tools 8.54, 8.56, 8.57, 8.58

Worked with business users and gathering requirements and defining the scope of the upgrade project.

Lead technical and functional resources for the upgrade project.

Mentored and coached technical resources and provided assistance on functional related tasks to the onsite users.

Worked and helped business functional users on the core setup of the modules and helped with the new functionality setup.

Worked with technical teams, on technical design and planning the upgrade timelines.

Identifying the customizations, worked with technical team on reading the compare reports and identifying the customizations and worked with business to see if a customization can be removed with new functionality in the upgraded new release.

Worked with business users on identifying the new functionality in the new releases.

Worked on project plan for the upgrade with all the upgrade tasks and monitored that all the tasks are completed as per the project plan.

Worked with business users and project sponsors and provide the status of the project, updates and roadblocks and proposed options for the successful completion of the projects.

Worked with technical team on reapplying and migrating customizations into the target upgraded environments.

Worked with business functional users and helped in writing the functional specifications.

Worked with technical team technical specifications for the interfaces, and other customization documentation.

Worked with technical team on identifying all the required tools for the 9.2 upgrade like Tuxedo, WebLogic, Elastic search and other tools involved in the upgrade as per the PeopleSoft certification and worked with infrastructure on getting the supported operating system servers required for the upgrade.

Worked on leading the 9.2 image upgrades and tools upgrades.

Developed testing scripts for PeopleSoft testing and used PeopleSoft testing framework for automating the testing.

Scheduled the PeopleSoft testing framework scripts and reviews the testing results logs and worked with business and development teams on the testing results.

Involved in integration testing between PeopleSoft and third-party systems.

Involved in all phases of functional testing, system testing, integration and UAT testing

Creating new test scripts and testing various customizations/enhancements in FSCM modules.

Implemented test scripts and conditions during system testing cycle as per functional designs.

Suggested measures for improvement of testing process by analysis of testing procedures.

Participated in development and implementation of testing strategies, methodology and procedures.

Responsible for estimating the project cost and delivery times, managed the project delivery on time to the clients to meet the deadlines.

ADP 2015 – 2020

ADP EV5 Tech & Functional lead Implementation Consultant/Business Analyst

Interacted with ADP clients collected the business requirements and translated into functional specifications and worked with technical team to help understand the requirements and ensured the smooth implementations and code changes.

Implemented test scripts and conditions during system testing cycle as per functional designs.

Suggested measures for improvement of testing process by analysis of testing procedures.

Participated in development and implementation of testing strategies, methodology and procedures.

Worked as tech lead for the Dell project, lead the technical requirements responsible for gathering the requirements and converting about 40 interfaces into EV5

Worked on data mapping, import and export data from Dell legacy system Pro Business to EV5 enterprise.

Worked on mapping the payroll, HR and core tables for the conversion.

Worked with clients and vendors, setting up meetings to gather the requirements. Worked on multiple interfaces changes and successfully completed the delivery on time as per the client timelines.

Involved in overall implementation of the Dell payroll system into EV5

Responsible for interacting with developers and worked as liaison to gather and document functional spec as per the client and vendor requirements.

Worked on writing and developing 100’s of interfaces functional specs and helped with design and development of technical efforts.

Worked with other teams at ADP for setting up the scheduling and ftp process for the interface files. Gathering the ftp requirements and submitting the request to create the SFTP jobs.

Worked with benefits service providers and participated in designing and developing the file layout discussions and developing new interfaces.

Responsible for estimating the project cost and delivery times, managed the project delivery on time to the clients to meet the deadlines.

Worked as functional and technical business analyst for the ADP systems

Interacted with ADP clients collected the business requirements and translated into functional specifications and worked with technical team to help understand the requirements and ensured the smooth installations and code changes.

Worked on several interface modification specification as well as created functional specification for the new interfaces.

Worked with other teams at ADP for setting up the scheduling and ftp process for the interface files.

Worked with benefits service providers and participated in designing and developing the file layout discussions and developing new interfaces

Responsible for estimating the project cost and delivery times, managed the project delivery to the clients.

Scottish Re/Hannover Re, Charlotte, NC 2007 – 2015

PeopleSoft Tech & Functional Development & Production support Lead

Perform functional analysis and gather business requirements. Worked with end clients on collecting the requirements and writing functional specs and worked with offshore teams and validated delivery of the product is as per requirements.

Responsible for PeopleSoft Financials, EPM & HRMS systems and writing functional specs for the projects. Wrote HCM interfaces from and to ADP and wrote numerous custom interfaces.

Successfully managed and lead the team with FIN 9.2, EPM 9.1 and HCM 9.2 upgrade projects

Lead technical team in upgrade project from 8.4 to 8.8 and to 9.2.

Involved in project budgeting and staffing plans. Proven management skill managing large teams.

Responsible for the overall PeopleSoft implementation, including setting up Finance & HRMS payroll base tables. Responsible for day-to-day PeopleSoft functional issues and working closely with the clients/business users to address the issues.

Involved in setting up Business units, Vendors, Pay Cycles, combo edit, ledgers, trees and other setup including payroll setup, payrate, deductions, garnishments and pay sheets.

Creating the security review report for SOX purpose at the beginning of each quarter.

Responsible for moving projects into production and creating proper documentation.

Provided training to end users on functional setup, and processes.

Facilitating business policy orientation for users with internal policy/subject matter experts.

MOSAIC, INC., Omaha, NE 2002 – 2007

PeopleSoft Tech & Functional Development & Production support Lead

Involved in setting up Financials, AR, AP, Billing, GL, Contract, Grants and HRMS, Payroll, Base Benefits, Recruit Workforce, T &L, Enterprise Learning systems.

Worked with business users, helped writing functional spec and working with technical team on the development as per the specs. Wrote custom interfaces to load data from 3rd party systems.

Gather business requirements for meeting data conversion and other business needs as they currently exist in the legacy system.

Monitor and manage processes and activities in Financials, AR, AP, Billing, GL, Contract, Expense and HRMS, Payroll, Base Benefits, Recruit Workforce, T&L, Enterprise Learning systems.

Set up of nightly processes for Financials and HRMS systems.

Worked extensively with AP check printing process, applying 1099 bundles and involved in setup of Pay cycles.

Customized the AP Positive pay file process as per the client requirement.

Strong knowledge of PeopleSoft AP, AR, Billing and GL, and HRMS, Payroll, Base Benefits, Recruit Workforce, T&L, Enterprise Learning table structure.

Worked extensively on Journal batch upload process.

Familiar with all the process that runs in Financials and HRMS systems.

Knowledge of combo edit rules setup including inter/intra unit setup and combo edit process.

Provide daily production support to the end users for both Financials and HRMS systems.

Developed SQRs, Crystal Reports, new systems in PeopleSoft using People Tools, and data conversion scripts to convert data from legacy system to PeopleSoft.

Coordinate the disaster recovery process, and implement PeopleSoft application, process scheduler and web servers.

KEY PROJECTS:

Upgraded PeopleTools from 8.46.09 to 8.48.06, Involved in PeopleSoft HCM System Implementation and upgrades from 8.8 SP1 to 8.9 MP1, HRMS system from 7.5 and 8.3 to 8.8.

Installed ESX Server and built the VM workstations for testing and development environments.

Implemented PeopleSoft 8.4 Financials AP, AR, Billing, and GL modules.

Created corporate allocation reports and income statement reports as per client requirement.

PEOPLE PLUS, INC., Omaha, NE 2000 – 2002

Sr. PeopleSoft Consultant

Created new process and interfaces to load daily transactions from third party system to PeopleSoft Accounts Payables.

Provided day to day production support for Financials AP, AR, GL, Billing, Project costing and HRMS, Payroll, Base Benefits, T&L systems.

Setup, administered and maintained system security for HR and Financials, created security views to restrict data access for users and SQL scripts to copy security permissions.

Set-up Pay Cycles and ACH Process, developed new Open Liability report and tuned Voucher Register Report to increase the performance, and developed new Billing Process to resemble the client’s old ARAC system.

Developed new Sales Commission module from calculation through reporting which generated Commission payments to sales personnel.

Provided extensive daily production support to PeopleSoft end users and platform support including database, desktop and servers.

Involved in data mapping and data conversion from Legacy system to PeopleSoft system, develop SQR scripts to read the payroll & benefits data from flat files to the PeopleSoft system

Applied patches to correct OK-TO-PAY flag issues, and modified PeopleCode for customization.

PAMIDA INC., Omaha, NE 2000

Sr. PeopleSoft Consultant

Worked as a developer on PeopleSoft 7.5 Financial AP, AR, GL, Billing and HRMS modules.

Developed scripts to convert payroll history and current payroll personal data and benefits data from integral system to PeopleSoft

Developed more than 40 SQRs from the Scratch as per user requirements, developed SQR process to load the data into the PeopleSoft tables, and tested and debugged SQR’s.

Developed and customized Records, Panels and Menus, and PeopleCode processes to meet client needs.

Involved in data mapping from integral system to PeopleSoft and designed and developed the customized reports from the integral system.

RUSSELL REYNOLDS ASSOCIATES, Manhattan, NY 1999 - 2000

PeopleSoft Consultant

Worked as a developer for the PeopleSoft 7.5 AR, Billing, GL and AP modules

Developed and customized Records, Panels, Menus using People Tools Application Designer

Involved in writing the stored procedure calculating the aging report and designed in crystal reports for the user look up.

Wrote several SQR’s from the scratch as per user requirement, including the Chase interface that is the primary SQR that sends the interface files to Chase Bank from the client for the transactions

Developed SQR to get customer information from the AS400 system to the PeopleSoft and Chase interface SQR that send the interface files to Chase, and designed the customer information in AR.

CARL KARCHER ENTERPRISES (Carl’s JR, Hardee’s Food), Anaheim, CA 1998 - 1999

PeopleSoft Consultant

Implemented and customized PeopleSoft Distribution Order Management and Purchase Orders modules.

Customized panels, record definitions, menus and people code using People Tools.

Used SQA Robot to load the data to PeopleSoft.

EDUCATION:

Master of Business Administration, 2009

Bachelor of Engineering in Computer Science, 1997

TRAINING:

Attended PeopleSoft University training in PeopleTools, Sever Administration, and Workflow.

Contact this candidate