SUMMARY

• Over 9 years of extensive experience in analysis, design, development, implementation and testing of client/server applications, programming languages, query and reporting tools and customer support.
• Experience with Retail, Staffing and Insurance, Education and Banking Industries
• Worked as a module lead in charge of deliverables pertaining to HR.
• Worked extensively on Production enhancement analysis and design.
• Lead the full life cycle for testing of various Interfaces across HR, Benefits and Payroll.
• Extensive experience on Peoplesoft HCM 9.1
• Extensive experience in PeopleSoft HRMS (HR, Payroll, Payroll Interface Benefits, and Benefit Administration, TAM) 7.0/7.5/8.0/8.3/8.8/9.1 and Major Upgrade from 7.5 to 8.0/8.3 and 8.9 to 9.1.
• Have sound knowledge in analyzing and designing PeopleSoft HCM applications.
• Expertise in PeopleSoft includes Functional analysis and design, Upgrades, Data Conversion processes and Interfaces for PeopleSoft applications to bridge with the Legacy Systems.
• Expertise in customizing modules, which include HR, Benefits, Payroll and Benefit administration, Campus Solutions, Recruiting, TAMS and Candidate Gateway.
• Experience in analyzing and designing eModules like eRecruit, ePay, eBenefits.
• Business analysis and strategic analysis in designing PeopleSoft systems from scratch.
• Extensive experiences in Databases like ORACLE, Microsoft SQL Server, and DB2.
• Extensive working knowledge of the Quality Center and MS Office Tools.
• Strong problem solving skills and experience to obtain solutions for complex problems under strict deadlines.
• Excellent experience in defining, documenting and evaluation of business requirement.
• Excellent in offshore coordination, Testing, Documentation, End - Users Training, Leadership and Knowledge Transfer.
• Good communication Skills and Excellent Team player that lead the team with a positive approach to problem solving and working within various areas.
• Microsoft Certified Visual Basic and Oracle Professional

TECHNICAL SKILLS

Development Tools: PeopleCode/Application Designer, Interface Design, and Application Engine processes, Workflow

Data Integration Tools: Component Interface, App Messaging / Integration Broker Messaging

Administration Tools: PeopleTools, Process Scheduler, Financial Components

Database Tools: SQL Tools, Toad, Query Analyze

Reporting Tools: SQR, Crystal Reports, PS Query

Testing Tools: Load Runner, Quick Test Pro, WinRunner

Bug Reporting Tools: Quality Center, Test Director, Clear Quest

Programming Languages: .NET Framework (ASP, C#, VB.NET), PL/SQL, Visual Basic, C, C#, Java, Java script, VB script, XML, HTML, (MS Office), Lotus Notes, SourceForge

Operating Systems: Windows, Unix

Databases: Sybase, Oracle, Microsoft SQL Server, DB2

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

PeopleSoft Functional Consultant/Business Analyst

Environment: PeopleSoft 8.9, 9.1 HCM, Oracle, MS Office, Control-M

Responsibilities:

• Worked closely with the business during Upgrade to gather requirements and provide solution design of HR/Benefits/Payroll business processes
• Gathered business requirements, prepared functional specifications, setup, implemented and provided support to test MDA AWE and T&L AWE for PeopleSoft 9.1
• Performed Fit/Gap analysis of various HR/Benefits/Payroll processes and interfaces between Peoplesoft 8.9 and 9.1
• Designed Benefit Interfaces for LTD, VSP, AAS, FSA and for various 401(k) and Pension Interfaces
• Provided support to Users during Open Enrollment and post Open Enrollment activities
• Worked extensively on SQL queries during testing phase of HR/Benefits/Payroll reporting and Interface data extraction
• Documented the HR/Benefits/Payroll Functional Requirements from the business to carry forward customizations from PeopleSfot 8.9 to 9.1
• Participated in Triage defect management meetings to analyze the enhancements needed in Production
• Designed Functional Specifications to upgrade ePay, eProfile, eDevelopment, eBenefits, eRecruit from Peoplesfot 8.9 to 9.1
• Designed functional specifications and tested out enhancements in Recruiting/TAMS/CGI modules in 9.1
• Setup Workforce Administration, Base Benefit Programs and Plans, and Benefits Administration
• Provided support setting up Payroll Tables, Payroll processing and Kronos Interface
• Extensive experience in conducting root cause analysis for issues in production
• Support updating HR/Benefits/Payroll functional requirements for any incidents reported in production
• Provide guidance to technical teams to create Technical Designs based on the analysis conducted
• Prepared Test Plans, Test Scenarios, Test Cases and performed extensive regression, functional and system integration testing.
• Provided training and coordinated with Users during UAT
• Worked extensively on PS Query generating required reports for validation
• Coordinated with external vendors during testing, managed defects and conducted root cause analysis
• Participated in functional and technical design reviews of HR/Benefits/Payroll processes. Suggested process and functionality improvements
• Communicated with the Business, Technical and Testing teams to implement solutions designed
• Identified problem areas and discrepancies, performed root cause analysis, reported and tracked defects and reviewed and validated fixes
• Identified ‘managed exceptions,’ made recommendations based on available resources, cost and time criteria
• .Responsible for coordination of all HR/Benefit/Payroll deliverables
• Coordinate development efforts from initiation, through implementation, QA testing and deployment into production
• Coordinated migrations for all the testing phases

Confidential, TX

PeopleSoft Business Analyst/QA Lead

Environment: PeopleSoft 8.9, 9.1 HRMS, Oracle, MS Office

Responsibilities:

• Worked with the Business to gather requirements and provide solution for their HR related Production Issues
• Conducted Triage meetings to prioritize and resolve issues
• Provided detailed analysis and design for new enhancement requests related to AWE
• Setup and configured Core HR Setup, Benefits, Payroll tables and AWE Configuration
• Gathered business requirements during Fit/Gap analysis of various HR/Benefits/payroll interfaces
• Designed and documented, enhancements and identified flaws during data migration from Perot Systems, HR direct to PeopleSoft 9.1 in Core HR, Global Payroll and Benefits
• Provided data mapping and strategy documents for the issues identified
• Worked extensively on the global payroll ADP outbound interface
• Worked extensively on the benefits Aon Hewitt outbound interface
• Reviewed documents BRS and SRS for global payroll and benefit outbound interfaces
• Performed detailed analysis on data consistency across Perot Systems, HR direct and PeopleSoft 9.1
• Gained access to environments and folders and coordinated with the offshore teams
• Responsible for providing status report to the stakeholders and senior management.
• Validated the configuration changes and analyzed the upstream/downstream impacts
• Identified system/integration issues and co-ordinated with technical teams to close these issues
• Provided effective communication at senior, management, technical and business levels presenting technical approaches and recommendations related to solving integration problems
• Coordinated development efforts from initiation, through implementation, QA testing and deployment into production
• Worked with project teams to discuss requirements, set expectations and solve problems utilizing standard technologies and tool sets
• Manage HR applications, integration specifications, test plans, and support strategies.
• Provided training on the global payroll processes and benefits processes to offshore teams
• Assisted in UAT and provided them with the business processes for the different enhancements
• Provided flexibility and timely support to the enhancements effort and production issues.

Confidential, MN

PeopleSoft Functional Consultant/Business Analyst

Environment: PeopleSoft 8.9, 9.1 HRMS, FSCM, Oracle 10g, Toad, Mercury Quality Center

Responsibilities:

• Performed Fit/Gap analysis and gathered requirements from the business and translated them into configuration decisions
• Documented BRS and SRS and assisted the QA team in developing various test cases for PeopleSoft Payroll, and Campus Solutions
• Configured various Payroll Setup tables, and Campus Solutions Setup tables and processes according to client requirements
• Documented and provided support for Payroll processing, and Campus Solutions applications
• Documented and provided support for enhancements in the Benefits and configured Benefits Setup tables
• Prepared BRS for the Auto Eval application implementation and enhancements
• Documeted functional equirements from the business for eRecruit, TAMS and Candidate Gateway implemenation
• Gathered and documented business requirements for implementing Integration Broker which interfaces the CRM, other third party modules and Student Admission module.
• Worked with Business to gather requirements and provide a solution for their Open issues on payroll processing
• Understand the As-is process and worked on gathering the required information on the existing setup and configuration of the system and proposed changes needed.
• Designed program flow and system documentation using Visio
• Provided support to migrate enhancements to Production
• Assisted UAT team with their scripts and provided them with the business processes for the different enhancements under way
• Attended team meetings that included business users and development teams for HR enhancements
• Provided and strategy documents for the issues identified and provided walkthrough’s of the suggested changes
• Provided flexibility and timely support to the enhancements effort

Confidential, Boca Raton, FL

PeopleSoft Functional Consultant/Business Analyst

Environment: PeopleSoft 8.9,9.0 HRMS, Oracle 10g, Toad, Mercury Quality Center

Responsibilities:

• Working with Business and top level executives to gather requirements and provide solution for their new ERP system analysis that includes Core HR, and Payroll
• Interacted with all levels of business and provided solutions based on the assessment of the clients current system.
• Validated the end to end business processes and design document of the clients existing system.
• Acted as a Liaison between the business and IT to gather Business requirement.
• Perform detail analysis on the current system and design a more efficient business process based on the requirement gathered.
• Involved in decision making interviews with top level executives for approval process and presentations.
• Lead meetings with Business to present the new Business process based on the gathered requirements.
• Provided blue print of each Business process requirement gathered.
• Provide walkthrough’s based on the assessment to address the potential benefits of the new system.
• Involved in strategy meetings to formulate the project plan and issues during the new implementation.
• Analyzed busines requirements, actively contributed to the fit/gap analysis meetings with SME’s and development.
• Involved in analyzing business requirements and writing functional specifications as per the business specifications.
• Configured various Core Payroll tables, compensation and earnings codes tables, deduction codes table, pay calendar table, garnishment table, vendor tables and tax tables and provided support for Payroll process implementation
• Docmented functional specifications relating to Core HR processes such as employee hire, rehire, termination and setting up personal action reasons as needed based on business requirements
• Designed an validated various payroll reports & post payroll processes.
• Coordinated the UAT, made sure the business users have all the scripts and was a liaison between the developers and the business users for all the issues that come up during UAT.
• Actively involved in walkthroughs and meetings discussing modification and enhancement requests.

Confidential, Coraopolis, PA

PeopleSoft Functional Consultant/Business Analyst

Environment: PeopleSoft 8.9/9.0 HRMS (North American Payroll), WorkForce Administration, and FMS (GL), PeopleTools 8.49, Oracle, Quality Center, QTP, Load Runner, SQL Navigator, Unix, LDAP

Responsibilities:

• Performed Fit/Gap analysis and gathering of requirements and translated them into configuration decisions.
• Documented and Analyzed the BRS and SRS for PeopleSoft HRMS Payroll (NA and Canada) & FMS (GL), Security, Interfaces
• Configured various setup Payroll tables and processes according to client requirements
• Evaluated and customized existing interfaces, processes and reports to work under 9.0
• Ensured that the appropriate information was available to Field and PGH management to support the management consolidation project
• Provided extensive support for PeopleSoft HRMS,North American and Canadian Payroll, Workforce Administration, Benefits Administration, Financials (GL).
• Documented Data Changes for existing and new system interfaces
• Gathered Business requirements to configure secuity so CDAS statements for contractors domiciled out of HD and GR Term.’s could be accessed
• Responsible for designing Payroll Interface to make sure that CDAS continues to feed data to FIN and GL application at term. level
• Independently performed Security Tests (Secuirty Trees - Dept Security, GR Managed Security, Row Level, LDAP, Permission Lists, Roles, User Profiles)
• Identified and fixed the issues in security during various test moves to production.
• Assisted Integration, and Regression tests for custom developed code with high complexity level, Supported and Certified to Production
• Designed customizations for several pages, SQR’s, Crystal reports, Queries and Batch Processes (App Engines)
• Extensively documented several Workflow’s for the IC and ISP models
• Implemented Data Conversion for OE changes
• Designed various functional documents as per client specifications for worlflow and payroll interfaces
• Coordinated the UAT, made sure the business users have all the scripts and was a liaison between the developers and the business users for all the issues that came up during UAT
• Actively involved in walkthroughs and meetings discussing modification and enhancement requests

Confidential, Greensboro, NC

PeopleSoft Functional Consultant/Business Analyst

Environment: PeopleSoft HCM 7.5, 8.8, PeopleTools 8.43, Oracle, MS Office

Responsibilities:

• Analyzed Business Requirements for new and enhanced version of PeopleSoft HRMS for Benefits Administration and eBenefits module
• Maintained SQR interfaces to bottom line application by which the Paychecks are printed after pay confirmation process. The check print file contains check information from the paycheck, pay earnings; pay other earnings, pay deduction, pay tax, and the pay distribution tables. The pay Calendar was used to select a confirmed payroll.
• Worked on setting up core payroll tables, compensation and earnings codes table, deduction codes table, pay calendar table, garnishment table, vendor tables and tax tables
• Involved in identifying a business solution pertaining to Workforce Administration processes like employee hire, rehire, termination and setting up personal action reasons as needed based on business requirements
• Coordinated interface requirements gathering and testing data being imported from the legacy AS/400 system to the Peoplesoft system.
• Designed functional specifications and tested a Component Interface process to load the data for the New-Hire employees. This process integrated with the existing online New-Hire process and eliminated the SQR which was used to populate the PeopleSoft Records
• Gathered business requirements and designed functional specifications for the New Hire workflow approval process which had multiple levels of approval
• Supported the testing team to test delivered payroll process and its functionality as per business requirements
• Documented customization of payroll reports & post payroll processes
• Set up employee pay data that include personal data, job data, benefits data, federal, state/provincial, and local tax information, general and benefit deductions
• Set up eligibility rules and geographic location eligibility rules for automation of open enrollment and event maintenance process
• Worked extensively on Benefits Administration process such as open enrollment and On Demand event maintenance and eBenefits
• Worked on the JMS API which was used to send enrollment data to the third party claims system
• Provided extensive support to technical and testing teams
• Conducted meetings with the Business, Development and testing teams and provided with weekly status reports
• Assisted UAT team with their scripts and provided them with the business processes for the different enhancements under way
• Attended team meetings that included business users and development teams for HR enhancements
• Provided flexibility and timely support to the enhancements effort and production tickets

Confidential, Blue Bell, PA

Business Analyst

Environment: PeopleSoft HRMS 8.8, Oracle, MS Office

Responsibilities:

• Gathered business requirements and and provide solution design of HR/Benefits/Payroll business process.
• Handled the data clean-up for open enrollment 2009 like Out of Sequence events, Closing Open Events and reprocessing the unprocessed rows by debugging the issues
• Created queries using PSQUERY for production support and identify data errors
• Setup flat rate table, deduction codes, tuning eligibility rules & event rules
• Created custom benefit programs and setting it up based on the changes required
• Worked extensively on PeopleSoft HRMS 8.9 for Benefits Administration modules which included Open Enrollment and On Demand event maintenance
• Debugged Configurations and Re-configured the old configuration for the new open enrollment
• Helped in UAT testing activities assisting in developing test strategy.
• Analyzed issues, fixing errors while running open enrollment. Resolved payroll deduction issues as per the benefit program setups as a part of production support.
• Extensive experience in conducting root cause analysis for issues in production.
• Support updating HR/Benefits functional requirements for any incidents reported in production.
• Provided guidance to technical teams to create tech designs based on the analysis conducted.
• Worked extensively on PS Query generating required reports for validation
• Extensively handled the workflow events which are triggered from job data and their impact on Ben Admin.
• Worked on Security for better handling of the Benefits system as per the client’s security structures
• Provided the project manager with a weekly project status that included the progress of the project and the issues faced
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Created documentation including word documents, excel files and UPK files

Confidential, Madison, WI

Business Analyst

Environment: PeopleSoft HRMS 7.5, 8.0, FMS 7.5, 8.0, Microsoft SQL Server, MS Office

Responsibilities:

• Involved in developing Functional Rquirements after meeting with the Business
• Conducted Fit-Gap Analysis and developed detailed documentation of proposed solutions regarding HRMS 8.0 .
• Setting core Payroll tables, compensation and earnings tables, deduction tables, pay calendar tables, garnishment tables, vendor tables and tax tables
• Worked closely with Business clients during implementation to gather requirements and provide solution design of Payroll interfaces.
• Configured Workforce Administration tables Company, Job Codes, Departments
• Worked to setup transactions in e-Pay self service module. Assisted in testing direct deposit, paycheck and W-2 tax forms transactions.
• Worked on FMS (Purchasing, AP, AR, Billing, GL), Security, Interfaces
• Involved in preparing various test strategy /plans for multiple releases.
• Worked on REQ and PO Amount Approval Workflow that requires 2 chains of approval based on PO coming from approved and non-approved requests.
• Worked on several customizaqtions in HR/Payroll/Benefits in PeopleSoft
• Supervised and led a QA team of contractors. Mentored and trained new employees
• Involved in analysis of various HR and Benefit Business process based on Upstream and Downstream requirements.
• Created System Flow diagrams using Microsoft Visio
• Developed documentation necessary for the new implementation across various regions as per client requirement.
• Interacted extensively with technical and testing teams and prepared weekly reports

Confidential

Programmer & Business Analyst

Environment: Windows 95/98, UNIX, Visual Basic 5.0, VB Script, Oracle 7xNekkanti Sea Foods is one of the leading seafood suppliers in south India. Apart from being a Technical Support, my role was to collect and analyze data to evaluate existing and potential markets for canned seafood industry and develop and enhance the Visual Basic application to fulfil client requirements. I was also involved in communicating with prospective clients.

Responsibilities:

• Created SQL scripts to schedule the Backup jobs.
• Developed, designed and maintained the portal of the company.
• Designed the database-template interface to manage the content of the Website.
• Created views to protect critical information from normal users.
• Created several forms like Sales Order form in Visual Basic.
• Experience in debugging, design, development, testing and implementation of the application.
• Strong back-end data manipulation using SQL.
• Solid front-end background using Microsoft s standards for form controls, structured coding, naming convention, error trapping, and documentation.