Sr Hr Business Analyst Resume
Irvine, TX
SUMMARY
- I have 15 years of IT experience cross functionally and globally. Extensively experienced with Oracle PeopleSoft in Human Resources Management and Financials. Key areas being data processing, data cleanup, business systems implementation (configurations / conversions / design/ development / test / support) and functional / technical documentation, product / module workshops, client workshops / Fit - Gap sessions and BPM’s, QA, Production support and product upgrades both functionally and technically.
- I am an Oracle PeopleSoft certified and dealt with multiple PeopleSoft life cycle implementations, support and upgrades
- Also a UPK master certified with Oracle University class instructor in the past
- Dealt with multiple PS versions from 7x to 9.2
- Specialist in Modules: Core HR / Payroll: Setup to processing and debugging Payroll, and Tax updates / Benefits and Ben Admin: Setup to processing, multiple open enrolments, health liability, ACA, and extensive work ex with vendors (Fidelity) / Time & Labor / PI / Absences / TAM & CG and ePerformance
- Financial Modules: Experienced in FSCM, GL, AP
- Technical knowhow and experienced in writing complex queries and can debug SQR’s & Cobol’s
- Has 10 plus years’ in leading projects, 3 years including project management, multiple project workshops, implementations and post go live support. Extensive experience on complete project life cycles, played a significant role in product discussions, scope analysis, presentations, communications with business, onshore-off shore coordination’s, team building, team motivational sessions and people management in large projects with more than 20 sized multiple teams, has handled multiple business entities and companies in project implementations and worked on Quality and Project Management processes like Agile, CMMI-5, ISO, Six Sigma, COBIT quality procedures and S-Ox requirements.
- PeopleSoft HCM Manager, Lead & Business Analyst & Test Lead all projects
- Extensive HR business processes knowledge, with functional proficiency in Self Services (ESS/MSS), Feasibility Study, Requirements Gathering and Analysis etc.
- Experienced in industry verticals: Healthcare, Public Sector, Higher Ed, Utilities, Aerospace, Specialty materials, Automobiles, Pharmacy and Medicals, IT, Banking and Finance, Insurance, Retail, Telecom, Infrastructure, etc.
- Worked on SQL, XML, SharePoint, Siebel CRM and Exact target, Taleo, STAT tool, Clear Quest, HP Quality Center and defect management tool like Test Director. Knowledge of Successfactors.
- Skilled in Quality Assurance Unit, System, Regression and User Acceptance Testing, Test Script, Test Plan and Test Scenario creation; and End User training
- Certified PeopleSoft HCM, ITIL Certified and UPK master certified
- Above all experienced as HRG worked in all areas of Human Resources
PROFESSIONAL EXPERIENCE
Confidential - Irvine, TX
Sr HR Business Analyst
Responsibilities:
- Surveyed UCPath SharePoint for Legacy FSPD’s / FDD’s and TDD’s as part of analysis for UCI data mappings
- Assisted in FSPD aligning to business process as part of CRP’s
- Assisted team in providing CSD’s from past experience and guided them for process improvements
- As a HR BA, identified and mapped source to target field in HR - Used DDODS / ODS for source of data (UCOP for HR)
- Identified hr API mappings for School of Medicine
- Identified field to field mappings in Core HR - part of API (tier n interfaces)
- Created issues in JIRA tool and followed up till closure
- Used EDL / Datawarehouse for in-house reports and queries, which helped in field to field mappings
- Used Metadata mapping documents from UCPath. Attended Metadata sessions (data walkthroughs)
- Helped to create SQL for Tree Trim (PS Tree model) to aid in creating Org Hierarchy
- Assisted ETL team with any PeopleSoft data requirements and guided through PeopleSoft process flows
- Prepared Test Plans and Metrics for Proposed Testing and saved in Sharepoint
- Also parallel handled Report requirements from Campus and Medical Center
- Surveyed, Schools, Human Resources, Payroll and Accounting, MAABOs, and CPOs for report requirements
- Analyzed reports and consolidated reports, presented consolidated reports and spec'd out to the development team for development of reports
- Part of Project management, created MS Project Plan and altered as required and aligned it to UCPath project plan
- Hosted sessions amongst business and in-house teams for reporting
- Assisted GL team in any specific Payroll / HR mappings
- Above work is not limited to, worked with central team and campus units as well
Confidential
PeopleSoft and Workday
Responsibilities:
- Lead the day to day PeopleSoft Payroll support, debugged issues and wrote sql queries for critical business reports
- Helped in PSHUP, file process to upload any late Payroll (errors)
- Applied Tax Updates to Payroll (CA)
- Assigned support tickets to respective analysts and functionally and technically assisted when and where needed
- Lead Benefits Open Enrolment, Vendor (Fedelity) management
- Monitored projects and assisted team when needed and helped in timely implementation
- Helped in issues related to I/B and O/B interfaces with vendorsGathered requirements for legacy and target system data mapping for conversion from business, and mapped data (fields) to target from PS
- Assisted in Workday conversion design mappings and conversion design documents from source system (PS)
- Assisted technical resource in technical specifications for mappings
- Lead project testing and implementation with 2 member team
- Lead Team calls and communications, guided team members in effective communications, system issues and installations
- Helped cross team communications (HRIS, HRIT, HRSS, User groups)
- Modules included; Core HR, NA Payroll, Benefits, PS Security
- Applications included; PeopleSoft, Taleo, Staffhub, Cherwell CRM tool
Confidential
PeopleSoft Merger Project Lead and Test Lead
Responsibilities:
- Analyzed Business requirements and provided custom solutions to development teams.
- Assisted with portions of the functional design, analysis & implementation for the HR / Payroll Conversion Program.
- Created functional design specification documents and coordinating & conducting system integration, conversion, and user acceptance testing.
- Lead the analysis and QA for portions of the HR/Payroll Systems
- Test Lead - Prepared individual test plan for HR and NA Payroll, test SIT and helped in UAT
- Worked with HR IT and the project implementation management team.
- Planed, coordinated with cross business area teams and managed HR Systems testing for data conversions, data validation processes, in addition to working with business areas and IT to achieve system re-engineering, system updates & change initiatives.
- Debugged Payroll issues, patch udates, tax updates through service now.
- Acted as a proactive interface between the internal HR global business partners and the IT technical resources ensuring the success & accuracy of HR Systems initiatives, data conversions, new upload programs, non-HR business area initiatives and system changes requiring a high level of complexity.
- Provide guidance to HR Business Partners and Analysts for identifying & implementing system solutions.
- Managing onshore and offshore team in delegating tasks and complete end to end testing till go live
Confidential
PeopleSoft Analyst
Responsibilities:
- Involved in System Testing of PeopleSoft HCM System. Participated in the Integration Testing of different modules in PeopleSoft application.
- Involved in the testing of the Benefits Administration process for Open Enrollment, Snap and Event maintenance. Complete understanding of the Benefits.
- Administration process from scheduling to enrollment.
- Tested employee changes include direct deposit account info, Hire date, Birth date and Benefits date.
- Involved in testing of overtime pay, over payment & adjustments.
- Involved in testing of Earnings and Deductions within the Payroll process.
- Extensively involved in Black Box testing, White Box Testing and also in unit testing.
- Involved in creating test scripts and testing various customizations/enhancements with benefits modules and regression testing during benefits open enrollment cycle
- Tested new interfaces to extract the Benefits and Balance related data - Benefit Enroll, Benefit Mapping and Dependents Data, Balance Data Includes YTD and QTD Information.
- Involved in setup and testing various set of benefits rules for benefits administration modules
- Tested various programs to validate the data coming in flat files from different health care providers and to load that data into HR and Benefit tables using Component Interfaces.
- Tested the customizations involved in MSS, ESS and eBenefits Self Service applications
- Held the role of Absence Management and Time and Labor consultant on a PS 9.1 pre-implementation phase for County.
- Also worked closely with the Legacy Payroll Technical Team to review the Legacy system and create a data mapping matrix of all fields and when possible identify PeopleSoft fields and records and existing rules in the legacy system and categorize in which modules the rule would be handled in PeopleSoft.
- Created Absence and Time and Labor rules and built a sample framework with MDC specific data and requirements and demonstrated the capabilities to the technical team as well as HR and Payroll users
- Majority of work includes in recording and testing the batch stuff and running the scripts. Involved in running of SQRs in UNIX environment.
- Involved in testing various Inbound and Outbound Interfaces for transmitting employee Data to Benefits vendors and for receiving Data to process them and insert into various PeopleSoft Tables.
- Tested SQR Programs to Load the Employees Benefit data from Web Site database to Relevant PeopleSoft database after the enrolment period is over.
- Extensively analyzed results for North American Payroll.
- Updated test plans and test cases for Functional Upgrade tests
- Involved in testing of General Deduction Conversion-To Validate the Deduction Records are inserted into the PeopleSoft deduction Table
- Tested Creating & Printing online checks - This test case creates an online check for an employee. After it has been created it can be Printed or Deleted
- Created/Used SQL queries to access data from different tables for backend testing.
- Documented and reported bugs found out during the testing process in Test Director
Confidential
PeopleSoft Lead
Responsibilities:
- Manager for global payroll workshops with team of 6 consultants
- Lead region wise for Colombia, Middle East and Canada scope and implementations for GP
- Successfully completed Fit Gaps and Conceptual solutions delivered
- Worked with business senior management and business partners to gather and document business requirements and to develop project scope and approach and helped in PS Single instance architecture
- Road map and implementation approach for 9.1 delivered for multiple regions
- Scope study included - As Is state, To Be state, PeopleSoft and client interfaces design, To Be system demos
- Received best consultant appreciation from client
Confidential
PeopleSoft Lead
Responsibilities:
- Designed, developed, tested and supported Quarterly releases in NA Payroll for CERIDIAN
- Lead every release, supported issues, documented release packages, tested prerelease (unit, regression, database and version)
- Successfully completed 2011 year end release and regression tested (11E and 11F) and worked on 12 A
- Worked with senior management and business partners to gather and document business requirements and to develop project scope and approach, created functional and technical design documents, test cases, test plan, release documents, installation guides
- Worked multiple scenarios on payroll cycles, pay process, garnishments and check printing, also well versed on retro pay
- Few areas worked - Tow new Ohio CCA/RITA city identification XML tag, WA SUI zero hours reason code XML tag, three new xml tags, W2box12DD and W2box12EE for yearly extract
- Puerto Rico 3 new fields, EETAXRATETYPE for PA locals, US unemployment report - employee received wages for 12th of month of quarter, Pennsylvania Act 32
- Rimini street tax updates tested with releases as well (non Oracle supported PeopleSoft versions)
Confidential, New Jersey
PeopleSoft Lead and Business Analyst
Responsibilities:
- Worked as a Business Analyst for HRG and Technology group
- Gathered requirements for enhancements in ePerformance, created business requirements documents, supported technical team in development and tested pre and regression at every release
- Managed mid-year and year end performance cycles, opened and closed cycles, core role played in communicating with business and employees
- Dealt on complete life cycle of ePerformance
- Helped on project planning and identification of team roles/responsibilities
- Adhered to Honeywell quality standards, followed release schedules, gate reviews prerelease, designed future release calendars
- Lead testing, regression tested prerelease, 100% success rate maintained
- Weekly reports (PS Query and few customized SQL reports) sent to Chairman on a regular basis - for organizational metrics
- Extensively used SharePoint, TD, Exact Target, mercury monitoring tool for business purposes
- Regularly monitored support issues, interfaces, internal and external PeopleSoft interfaces
- Helped in Benefits applications closely monitoring Unix shells, and ran adhoc reports for HRG’s
- Supported benefit plans, including but not limited to all Health Plans, Retiree Benefits, Tuition Reimbursement, Workman’s Compensation claim inquiries, LOA, STD, LTD, and Life Insurance, also provided BRD’s and technical feasibility study for smoking cessation plan implementation
- Participated in the annual benefits open enrollment process, including planning staff member communications, coordinating tasks internally and with external partners. Assisted with preparing materials and presenting benefits plan changes to associates. Coordinated the update of the benefits system
- Administered, researched, and made recommendations and improved current process or redesigned other non-medical employee programs (i.e. Tuition Reimbursement, Health Club Reimbursement, Day Care Discounts, Unemployment and Workers Compensation) provided the most robust, cost effective benefit programs
- Utilized HRIS and vendor systems to streamline the processing and record keeping of associate employment and benefit information. Processed associate and benefit plan data changes to ensure an accurate and complete database. Troubleshooter and resolved any processing or systems issues with IT
- Responsible for leading “train the trainer” sessions.
- Acted as business lead for 9.1 reimplementation - ePerformance and Benefits system
- Led weekly organizational change management meetings to discuss business transformation opportunities across the system
- Responsible for training end-users and put together a quick reference manual
Confidential
PeopleSoft Lead
Responsibilities:
- Functional lead for successful upgrade of PI to 9.1
- Worked with base and post versions of Payroll Interface 8.3 to 9.1
- Checked and added few configurations in the latest version (9.1) post upgrade
- Extensively studied and implemented source and target
- Prepared Test Script and conducted Unit Testing
- Worked on the configuration setups
- Worked on Security setup and also on HCM to GL configurations
- Created design specifications for all mapped tables and general data cleansing jobs, writing and testing of conversion scripts for ADP and PS tables.
- Interfaced with external payroll system (ADP) for calculations
- Debugged Cobol errors with the help of technical team and helped technical with configuration understandings and process flows
Confidential
Senior PeopleSoft TAM Lead
Responsibilities:
- Was a Senior consultant on a 9.1 TAM and CG implementation
- Provided project-planning assistance to review project plan and associated tasks, deliverables and milestones and help the program management team keep the project on track throughout the engagement
- Provided subject matter expertise and drive process quality assurance, and defined and recommended areas for improvement in the business, and guide the business in the establishment of effective and efficient business practices.
- Performed business process mapping, gap analysis, functional requirements, definition, interviewed stakeholders, facilitating business requirements, analyzing, and documenting system reporting requirements, and created detailed functional design and system configuration specifications for recruitment and HR.
- Prepared Conceptual Solutions Document, Configuration Scripts, FDD
- Worked on the Workflow (Notifications / Emails and work list) delivered and setup workflows, configured, security setup
- Supervised UAT process; worked with users, SMEs and BPOs on test scripts and test data.
- Responsible for reporting as needed by various departments using PS Query and reporting tools such XML and Excel as well as modified delivered PS Query for ad hoc reporting
- Provided weekly status update to users and IS support staff at the production support team meeting.
Confidential
PeopleSoft Lead
Responsibilities:
- Analyzed client requirements conducted workshops for the modules Onsite, USA (workshops with the SME’s and Vice Presidents of departments)
- Extensive study of the Source and Target (legacy with the standard version
- Performed and participated in Fit/Gap analysis against PeopleSoft delivered capability / Experienced with Requirements Definition, mapping and gap-analysis.
- Prepared CSD, assisting the client in the Data Configuration Documents, Data Conversion Scripts, Prepared Test Cases, Security Matrix
- Configured pretest environment in PS V 9.0 for Base Benefits and Automated benefits
- Configured plans (medical, dental, vision, insurance plans and tested, pre deployment and post deployment on different servers)
- Verified plans and vendors, benefits programs and rules configured
- Helped in Conversion, Supported all testing activities including the creation of test scripts for System, UAT and Integration testing, Post Conversion Testing, System Test
- Suggested an implemented reports for Retirees and other Benefits plan holders (PS Query
- working knowledge of government laws and regulations that impact the benefits areas, such as HIPAA, FMLA, IRS Code 125, ADA, ERISA, COBRA and USERRA
Confidential
PeopleSoft Support Lead
Responsibilities:
- Supported for a year and half for the base module of 8.0 SP1 inventory
- Reviewed client'scurrent business process design for inventory application tracking and day to day issues
- Level 2 support, with optimal quality and adhered to SOP and timelines
- Onshore inventory and stock checks performed and crossed with system
- Interfaced and maintained with external weights and measurement system
- Pharmaceutical quality measures were kept in mind throughout support and critical deadlines were maintained
- Technical issues handled in terms of cognos and reports
- Marketed successfully and presented version 9.0 inventory module
Confidential
PeopleSoft Lead
Responsibilities:
- Conducted requirement gathering, documented current set up for HCM, and global payroll and AM
- Reviewed current functionalities in line with client’s current HRIS initiatives including improving their current data quality, correcting problems with existing interfaces, assessing options for global rollout of PeopleSoft once on the COE (8.9)
- Conducted Fit Gap Analysis of current set up tables and all custom tables.
- Created requirements, technical specification and design specification and reviewed with client during JAD sessions prior to hand off to IT development staff.
- Worked closely with the system users and formed ways to enhance the end user experience, and bolster end user training capabilities. Created several quick reference guides for FAQs.
- Processed bi-weekly payroll for sample employees and 4 companies on a rotating schedule
- Verified new employee data, payroll changes, and related paperwork; Reviewed payroll reports during payroll run and analyzed and resolved problems.
- Assisted with and explained to Business Owners and Super Users questions regarding payroll, Troubleshot and problem-solved payroll issues.
- Assisted with testing of tax updates and tested thoroughly prerelease, UAT and regression
- Held the role of Senior Absence Management consultant for the Belgian Federal Government.
- Joined during the development phase of the project and led 3 fellow developers, trained them on specific Abs Mgt functionalities when needed and ensured of good rules development standards.
- Ensured the cleanup and validity of the overall framework and migration of elements in preparation for Integration Testing.
Confidential
PeopleSoft Manager
Responsibilities:
- Closely liaised with Customer, Account Management and Service Delivery and optimized the delivery and support of PeopleSoft technologies
- Managed support activities of different PS HRMS modules implemented (WFA, Position Management, Recruitment, Payroll, ELM), involved more than 12 companies and multiple business units with hundreds of departments
- Tracked and meted Business Unit (BU) Queries
- Team management: Lead and Helped the team in regular and critical issues, monitoring and mentoring
- Structured the process as per the SLA
- Weekly and Monthly reported to the customer in terms of achievement and issues related to the support process
- Daily tracked issues and delegated them to team.
- Helped customer in Strategic HR systems and in tuning with PS HRMS
- Trained customer in PS HRMS aspects when and where required
- Kept Account Manager informed about the progress and issues
Confidential
Functional Consultant
Responsibilities:
- Analyzed the current and future requirements of Customers Legacy System
- All together gathered the requirements of HRMS systems at onsite
- Understood the requirements and captured them in the Fit Gap, As Is and To Be, URD
- Initialized the required team from Satyam
- Man power budgeted with the Customer
- Prepared Project Plan in MS PP
- Understood and Implemented the Project Management within the Quality Process (Six Sigma) of Customer which include periodic Audits
- Prepared and delegated the tasks to the technical, functional, DBA’s and Reporting team
- Client and Customer discussions to understand and delegate the requirements
- Developed functional specification document for Data Conversion
- Configured and set-up of the system
- Dealt with complete testing life cycle of the project
- Created Quality Plan Strategy and control document
Confidential
PeopleSoft Senior Consultant
Responsibilities:
- Participated in the design phase of implementation after the analysts have completed the requirement gathering, supervised the team in the JAD session, managed each consultant and their deliverables, and reviewed plans and configuration strategy.
- Managed the configuration of eRecruit, Recruitment, Workforce Admin, Training, Competency Management, eBenefits, Ben Admin, Career Planning, Performance Management, and ePerformance, modules both from the front end and the back end.
- Worked with the technical lead to load the configuration values from the back end.
- Analyzed and determined the values to configure via the front end starting from the Setid, business units to the transaction tables.
- Tracked global assignments and System change requests.
- Served as a solutions manager, conducted business and functional analysis and wrote detailed functional and technical solution specifications
- Provided functional application support and administration services for PeopleSoft HCM, eBenefits, Ben Administration, eRecruit, Recruit Workforce, Payroll, Payroll Interface and related interfaces; and recommend the design or redesign of production programs.
- Served as a liaison between key users, internal/external customers and vendors, developers and DBA staff to identify and implement best practices.
- Performed troubleshooting for reported issues and log and track
- Provided software administration services; to assist with user documentation and training; and to provide guidance to other analysts.
- Responsible for ensuring the timeliness, appropriateness, applicability and quality of each aspect of a project or application and for recognizing conflicts and producing solutions for a variety of problems.
- Responsible for instructing, directing, or checking the work of other analysts or team members and act as a team leader for projects.
- Provided guidance to the customer on system requirements; advises of work around in terms of cost, time, availability of equipment and personnel
- Assisted in the feasibility review of user proposals to detect any significant omissions and errors, interpret business and technical process requirements and overall impact analysis of implementation and changes, and determines strategies for deployment of changes to the production environment.
Confidential
PeopleSoft T&L Consultant
Responsibilities:
- Extensive Fit Gap analysis between the source and target versions.
- Understood the existing Time and Labor 7.5, which is almost 80% customized and having large dependency on external interfaces and mapping the existing functionality and requirements to the new version and existing customizations were kept in mind during upgrade
- Lead the Requirement Analysis discussions with the client and educated the client on new version.
- Worked Security of T&L, roles and responsibilities.
- FDD and TDD documents created and maintained
- Small to complex queries written for extracts
- Responsible for time delivery of the requirements with adherence to quality standards.
Confidential
Human Resources Generalist
Responsibilities:
- Developed strong business relationships with managers and consulted regularly with senior level management regarding the development and administrations of strategic HR services, processes, and procedures.
- Managed the activities of multi-state payroll tax reporting system.
- Administered bi-weekly payroll, quarterly and year-end reporting and reconciliation.
- Conducted new hire orientations to ensure employees gain an understanding of company policies/protocols and benefits.
- Processed and audited monthly billings for insurance, Cobra and bi-weekly 401(k) contributions match and deferral, loan repayments.
- Developed cost-effective recruitment sources and assist managers with recruitment research sources, websites.
- Provided statistics to managing partners for quarterly reports as it relates to turnover ratio and costs of new hire.
- Responsible for developing and maintaining all job descriptions, employee classifications and performance evaluations.
- Fielded HR questions from managers and employees at all levels, becoming a business partner with each manager and counseling them on human resource issues.
- Handled employee relation issues and served as a mediator between employees and management.
- Formulated and recommended Human Resources policies and objectives for the company with regard to hiring, retaining and termination of employees.
- Maintained the employee handbook of the company. Established policies and procedures for hiring, including background checks and drug testing.
- Level 3 support of PeopleSoft HCM module (WFA) and Business Objects