Swati Arora

Techno functional Lead

Saint Petersburg, FL - Email me on Indeed: indeed.com/r/Swati-Arora/a62d1c378c129d16
More than 10 years of progressive IT Experience which includes experience in Implementation, Customization,
Upgrade, Data Conversion and Support & Maintenance.
8+ years experience as a PeopleSoft HCM and HRIS Techno-Functional Consultant in the area of Core HR,
Recruitment, Base Benefits, E-performance, NA Payroll, TAM, Candidate Gateway MSS/ESS
Enriched experience of working with Global financial clients like Raymond James, Credit Suisse, Moodys
Investors, CitiGroup and RBS etc.
Involved in full length Life-Cycle implementation of PeopleSoft modules.
Sound knowledge of People Tools like Application Designer, Application Engine, People Code, Component
Interface, Data Mover, PS-Query, SQR and Process Scheduler.
Professional consulting experience includes all phases of project initiation, planning, architecture,
requirements gathering & analysis, process reengineering & mapping, functional design, development &
configuration, testing, implementation, UAT activities & error resolution, user training and post-Go-Live support.
Trouble Shooting and optimizing the SQL queries.
Very good in debugging, analytical thinking, error fixing, testing, and Performance tuning of the code.
Good Technical knowledge backed by functional domain.
Ability to work independently and also can be an integral part of small and large teams.
Received Citi Service Excellence and Bravo awards from Credit Suisse and Moodys client for excellent
performance in respective projects.
Received GBS GD Top Contributor Award for commendable performance, contribution to the success of the
organization and value added to the Client

WORK EXPERIENCE

Techno functional Lead

Raymond James - April 2014 to October 2014
The overall objective of the project involves production support and enhancement of PeopleSoft HRMS 9.1 for
People Soft Core HR modules, NA Payroll, Benefits and Benefit Administration.
Responsibilities:
Handled bundles to resolve issues & upgrade the application. Triaged various testing, production and
performance issues.
Created data mover scripts for exporting and importing important tables, like the security tables and the
configuration tables. Did manual configurations after the bundle application.
Developed test cases/scenarios for end to end test coverage and created test scripts for execution of
functional tests.
Reviewed functional specs with business sponsors for approval and coordinated in testing all the
requirements.
Worked on building PS queries and security for users on ad-hoc reports.
Helped the user build the work flow matrix which identifies the groups or person receiving notification during
approval process. Designed security as per the requirement, created Permission Lists, Roles, User Profiles,
and maintained them.

Supported developments by clearly articulating the customer's business needs while continually verifying
that the implementation approach and resulting technical developments that meets the current/future state
requirements.
Environment: PeopleSoft Core HRMS/HCM 9.1, Payroll 9.1, ESS, MSS, Base Benefits, Benefit Administration

Techno/Functional Lead
Royal Bank of Scotland - January 2013 to February 2014
The overall objective of the RBS PeopleSoft is to upgrade from 8.8 to 9.1 and to develop online objects,
Interfaces, Reports, Test execution and Defect Management for People Soft Core HR modules and to
implement TAM.
Responsibilities:
Worked as Lead Techno Functional Consultant for a team of 12 resources.
Effectively conducted workshops and training with client team.
To ensure quality of the deliverables was maintained by enforcing peer review and getting the sign off on
scenarios.
Development/Design of SQRs, Application Engines and Component Interfaces from scratch to meet the
required specifications.
Involved in creation and maintenance of Roles and Permission list for all PeopleSoft account users in the HR.
Customized and Developed People Soft pages from scratch.
Developed SQR reports for Interfaces and testing purposes.
Worked with business and functional user to understand the requirements and created the technical design
documents.
Provided solution to the team to develop the interfaces.
Ensuring schedule and effort are tracked and monitored.
Timely reporting and tracking of risk and issues.
Actively participated to Support Team towards fixing/providing solution for bugs, enhancements and Testing.
Responsible for development of all RICE items (conversion, enhancements, interfaces, reports) which
includes preparing technical design, doing build, coordinating the development, unit testing, peer review and
migration.
Used Quality Center to log bugs and run Test Scripts.
Involved in the Peer review and testing process followed to ensure zero defects.
Environment: PeopleSoft HCM 9.1, Benefits, ESS, MSS, TAM.

Senior Application Consultant

Raymond James - April 2012 to December 2012
Project involved re-implementation of PeopleSoft HRMS 9.1 as the client was using HRMS 8.8.
Objective was to re-implement People Soft Core HR modules, NA Payroll, Benefits and Benefit Administration.
Responsibilities:
Architect and designed sound/supportable technical solutions to complex business requirements.
Performed code reviews to ensure effectiveness, performance fitness, security, maintainability, and
compliance with standards.
Used CI to expose the PeopleSoft component to the third party applications.
Worked on the configuration setup for Delegation and MSS transactions.
Enrolled employees into benefit plans and setup dependent and beneficiary data.

 Worked on gathering requirements on ESS and MSS modules and designing the business process for clients
to request a requisition for open position, compensation, promotion and transfer of direct reports.
Developed System testing, Integration test Scripts with different test scenarios for Testing.
Analyzed nature of defects and provided root cause analysis to the client team.
Retrofitted and developed various Outbound and Inbound Interfaces for transmitting employee Data to
Benefits vendors and process the receiving data to insert into various PeopleSoft Tables.
Effectively communicated with team and helped functional team by means of reverse engineering process
by creating specs from application engine and SQR's to understand the functionality of existing objects by
providing them with flow charts and understanding document.
Environment: PeopleSoft HCM v9.1, SQL Server, Core HR module, PeopleTools v8.52
, ESS, MSS, Base Benefits, Benefit Administration

Business Analyst/Technical Consultant

Citigroup - January 2010 to March 2012
New Jersey , USA Jan'10 - Mar'12
Project Name: Global Billing Oracle RMB Implementation
Role: Business Analyst/Technical Consultant
The Global Billing project enabled the Global Transaction Services to move from disconnected billing
methods and systems to a consolidated billing platform, providing improved revenue capture through leakage
elimination. Implementation of Global billing was done in phases for USA, Canada and Japan.
Responsibilities:
Worked as part of onsite team, interacted with business to prepare functional requirement document.
To analyze the requirement and establish gaps and to prepare detailed functional specifications for different
components.
To prepare mapping documents for inbound and outbound interfaces.
To interact with technical team on regular basis to clarify doubts and to enable seamless testing.
To triage defects logged during different phases.
To prepare test Scripts testing by the testing Team. To coordinated with testing Team for fixing the issues
as per client satisfaction.

Tech Lead
Credit Suisse - New York, NY - June 2009 to December 2009
Credit Suisse has integrated HR department that features two main information systems, the system was
implemented by IBM team under project name OneHRIS. Production support of the OneHRIS system was
being handled by the client himself. TRPM project was aimed at guiding the client team to streamline the
process of resolving tickets by providing the root cause analysis and by providing support to clear the backlog
of the tickets.
Responsibilities:
Attended workshop with client to come up with problem management approach for the defects.
Worked as SME for clearing the backlog of the defects.
Reviewed Technical Design Document for various production support bugs and enhancement bugs.
Analyzed nature of defects and provided root cause analysis to the client team.
Conducted Knowledge transfer sessions with the client team.
Coordinated proper migration to the production environment.
Responsibility involved sending status reports and attending checkpoint calls.

Environment: PeopleSoft HCM v9.0, People Tools v8.52, Oracle 10g, Core HR module, Benefits.

Tech Lead/Functional Consultant

Credit Suisse - New York, NY - July 2007 to May 2009
Client has integrated HR department that features two main information systems. The former Credit Suisse
First Boston (CSFB) HRMS was on PeopleSoft v 7.01 and was upgraded in phase1 and the former Credit
Suisse Switzerland was on version 8.3 SP1 and was handled in phase2.. Both systems were based on
PeopleSoft technology but were implemented very differently.
The project was aimed at integrating and streamlining the HR operations of the whole group into one. The
project was a re- implementation of the legacy PeopleSoft systems to newer PeopleSoft and implementation
of new modules like eperformance, erecruiting.
Responsibilities:
Attended KT sessions as part of onshore team to understand Legacy system.
As a key member of Team involved in Data Conversion for Workforce administration module. Worked
extensively on Data conversion programs using component interface to load PeopleSoft tables from flat files.
Involved in the portal branding of credit Suisse portal for customizing the look and feel of the portal.
Worked and mentored team members in the designing of inbound and outbound interface technical
specifications and reviewed their work .Worked on the core and critical interface specifications of interfaces
Worked with client members, onsite team and offshore development team to resolve issues on specification
gathering, troubleshooting and building deliverables.
Involved in 2 full cycle of System Integration Testing and 1 cycle of User Acceptance Testing as part of onsite
team. Worked as an onsite coordinator for interfaces track.
Interacted with Clients and Vendors to get the sign-offs for various conversion issues as well as interfaces.
During phase 2 worked with Functional team in workshops for redesigning phase1 interfaces. Analyzed
Interfaces of the phase1 and provided technical inputs for the same.
Worked as technical team lead to retrofit customizations in the current system which included gap analysis,
retrofit and testing customizations.
Reviewed work and provided solutions in a best possible manner.
Prepared Test Cases and was involved in Unit Testing.
Set up calls with client/onsite team to discuss and resolve the issues.
Extensively worked on Performance Tuning and Debugging and Migrations.
Worked with onsite team in resolving SIT and UAT issues, assigning and tracking defects by using Mercury
Quality Center (MQC) tool.
Worked on the configuration setup for Talent Management and Promotions.
Established Gaps as per Client requirements and developed Functional Specs required for necessary
enhancements to the PeopleSoft functionality.
Worked with Development team for necessary enhancements done, tested and migrated from development
environment to testing environment, tested and got approved as per client needs.
Developed System testing, Integration test Scripts with different test scenarios for testing. Coordinated with
testing Team for fixing the issues as per client satisfaction.
Environment: PeopleSoft HCM v9.0, People Tools v8.52, Oracle 10g, Core HR module, Benefits,
eperformance, erecruiting.

Senior Techno- Functional Consultant

Moody's Investor Service, USA - November 2006 to June 2007
Nov'06 -June'07

Project Name: Moody's (PeopleSoft HRMS v8.8 / FIN v8.9 Implementation

Role: Senior Techno- Functional Consultant
Moody's Investors Service is among the world's most respected and widely utilized sources for credit ratings,
research and risk analysis. Moody's commitment and expertise contribute to stable, transparent and integrated
financial markets, protecting the integrity of credit. In addition to our core ratings business, Moody's provides
research data and analytic tools for assessing credit risk, and publishes market-leading credit opinions, deal
research and commentary, serving more than 9,300 customer accounts at some 2,400 institutions around the
globe. Moody's maintains offices in most of the world's major financial centers and employs approximately
3,000 people worldwide, including more than 1,000 analysts.
The Project was to upgrade PeopleSoft HRMS 8.5 to 8.8 modules e-Recruiting, e-Compensation, Self Service,
e-Profile, Position Management.
Responsibilities:
To coordinate with client members and offshore development team.
To resolve issues on specification gathering, troubleshooting and building deliverables.
Designed Technical Specifications for customizations.
Extensively worked on customization of Compensation, Recruiting, e-Profile modules using People Code
and Workflow and created customized functions for reusability across the modules.
Good knowledge on Performance Tuning and Debugging.
Worked with User profiles, Roles and Permission Lists in HRMS Applications.
Developed reports using SQR and PS Query
Involved in resolving System Integration Testing and UAT issues of the HRMS system
Coordinated migration of changed objects between various database instances.
Environment: PeopleSoft HRMS 8.8, People Tools 8.46, Sybase, e-Recruiting module, e-Compensation
module, Self Service module, e-Profile module and Position Management module.

PeopleSoft Technical Consultant

Rogers Corporation - September 2006 to November 2006
Rogers Corporation is a manufacturer of high-performance specialty material products, serving a diverse range
of markets that includes portable communication devices, communication infrastructure, consumer products,
The project is meant implement their Company's own financial and SCM processes, covering functional areas
like Accounts Payable, Accounts Receivable and SCM areas like inventory and order management.
Responsibilities:
Customized as per requirement using People Tools, People Code and SQR.
Retrofitted SQR and developed new one as per client requirements.
Fixed various problems in existing applications.
Involved in preparing documentations related to customization done.
Co-ordinated migration of objects between various database instances
Environment: PeopleSoft FSCM 8.4, People Tools 8.42, Oracle 9i

Technical Consultant
NBC Universal Los Angeles - Los Angeles, CA - August 2004 to April 2006
NBC Universal is one of the world's leading media and entertainment companies in the development,
production, and marketing of entertainment, news, and information to a global audience. NBC Universal owns
and operates a valuable portfolio of news and entertainment networks, a premier motion picture company,

significant television production operations, a leading television stations group, and world-renowned theme
parks. NBC is operational on PeopleSoft HRMS 7.51 of which HCLT India takes care of Payroll & Base Benefits
modules
Responsibilities:
Analyzed, replicated and provided resolution of the issues (System Investigation Report-SIR), which involved
comprehensive use of SQRs.
Fixed bugs in existing SQRs and coded SQR programs from scratch for generating reports to properly address
the business requirement.
Customized and developed PeopleSoft objects like records, pages and menus, views.
Created various docs like unit test case doc, Interface design doc, Report Design Doc, analysis doc etc.
Performed performance tuning of SQL Queries.
Environment: PeopleSoft HRMS 7.5, People Tools 7.5, Oracle 8

ADDITIONAL INFORMATION
Technical Proficiencies
ERP: PeopleSoft HRMS
Functional: PeopleSoft (Core HR, ePerformance, Self Service, Base Benefits, Benefit Administration), TAM
(Talent Acquisition Management), Position Management, NA Payroll).
Technical Tools: Rational Portfolio Manager, People Tools 8.52, 8.45, 8.42, 8.46, 8.49, PIA, Application
Designer, People Code, Query Manager, Application Engine, Component Interface, Report Data, Data Mover.
Reporting Tools: PS/Query, SQR
Testing Tools: Test Director, Quality Center (QC)
Database: Oracle 9i through 11G, TOAD, SQL Developer.
Platforms: Windows [] DOS, UNIX
Languages: People Code