SUMMARY:

• Sr. PeopleSoft HCM Technical Consultant with around 6 years of experience in all phases of software development life cycle including Requirement Gathering, Fit - Gap Analysis, Design, Development & Testing.
• Strong development skills in Customizations/Enhancements of HCM/HRMS modules like Core HR, NA Payroll, Benefits and Self Service.
• Highly expertise in usingPeople Tools, Peoplecode, Application Engine, File Layout,Component Interface, Application Packages, Integration Broker, Web Services, and Data Mover.
• Extensively worked with PS SQL and proficient TOAD/SQL developertools.
• Created specifications and programmed interfaces to and from PeopleSoftsystem to satisfy business requirements.
• Specialized in data extraction interfaces and conversion from legacy to PeopleSoftapplications.
• Proficient in customizing and developing various reports usingXML Publisher, SQR and PS Query.
• Expert level troubleshooting skills to identify, diagnose, and resolve problems involving all aspects of functional and technical PeopleSoft system.
• Excellent communication and written skills, capable of working closely with users, able to rapidly translate layman's requests into technical specifications.

TECHNICAL SKILLS:

PEOPLESOFT: PeopleSoft HRMS/HCM - Core HR, NA Payroll, Benefits, Self Service, Absence Management, Time and Labor 8.8/ 8.9/9.0/9.1

PEOPLETOOLS: People Tools 8.49/8.51/8.52 - Application Designer, Application Engine, Component Interfaces, PeopleCode Debugger, Import Manager, Security Administrator, Object Security, Maintain Security, Workflow, Integration Broker, Application Package, Application Messaging, Webservices, XML Publisher, Process Scheduler, Process Monitor, Data Movers, Upgrade Assistant, File Layout, PeopleSoft Test Framework (PTF), STAT

REPORTING TOOLS: SQR, PS Query, Crystal Reports and ETL Tools

LANGUAGES: PeopleCode, SQL, PL/SQL and Java

DATABASES: Oracle 11g, 10g, 9i, SQL Server, MS Access 2007

OS: MS DOS, Windows-XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential - Dallas, TX

Sr. PeopleSoft HCM Developer

Responsibilities:

• Designed and Developed conversion interfaces for NA Payroll - General Deductions, Tax Distribution, Federal/State Tax, Garnishment, Direct Deposit and Additional Pay
• Created HR interfaces for Affiliates and Position management for one time data load.
• Development of Benefit Interfaces for loading employee health benefits data.
• Created Payroll/Benefits related reports using PS Query/XML Publisher.
• Combined Peoplesoft delivered Budget/Combo edit check IB between HCM and Finance.
• Worked on Excel to CI for Department and Position data load.
• Member of Team involved in Analysis of Peoplesoft NA Payroll process, CA process for creating customized Commitment Accounting Module.
• Creation of technical, design and test cases documents for different implementation projects involved with at UNC.
• Finance to HCM Vendor/Project and CA related Service operation tables data sync.
• Worked as a part of reporting team creating several Payroll/Benefits reports using Query and XML.

Confidential . - Dallas, TX

Sr. PeopleSoft HCM/FSCM Integration

Responsibilities:

• Designed and developed Integration Broker/ Web Services for HCM - Personal Data and Health Benefits
• Did end to end peoplesoft demo setup for PS FIN 9.1/PS HCM 9.1/ PTools 8.52
• Created Peoplesoft Test Framework(PTF) Bolt-On application integrated with Delivered Oracle PTF for assigning and managing Peoplesoft Testing.
• Designed and developed Integration Broker/ Web Services for FIN - Accounts Payable with FileNet P8.5x.

Confidential - Dallas, TX

Sr. PeopleSoft HCM Developer

Responsibilities:

• Responsible for design analysis, technical specifications, development, implementation, support, and maintenance of PeopleSoft HCM 9.1/PTOOLS 8.51.
• Develop custom reports utilizing XML, SQR, and File Layout with Application Engine.
• DevelopedInterfaces using AE to create or extract data from feed files like loading data in eCert system, premium remittance data feed for OEB.
• Developed/Enhanced SQR Programs scheduled to run monthly to submit Personal and Payroll data to State HRIS.
• Assisted performance tuning several COBOL, App Engine, and SQR processes, including several modifications to be adapted by PeopleSoft.
• Customized the Self Service Transactions Pages. Additional fields and component People Code was written to enhance the functionality to meet customer requirement.
• Customized HCM 9.1 Administer Workforce applications to add functionalities related to auto increment of GL PAY TYPE field in Job data.
• Configured security controls for User setup, Page permission access, Data permission access, and Role setup.
• Developed new feature for the Lone Star Interface to calculate Hazardous and Longitivity pay for State employees
• PeopleSoft Test Framework Implementation (Peopletools 8.51/Peopletools 8.52).

Confidential

Sr. PeopleSoft HCM Developer

Responsibilities:

• Developed on-line customizations, custom interface programs for Benefits, Payroll.
• Set up Integration Broker services(such as gateways, nodes, services and service Operations etc) for automatic updates between HR and FIN applications.
• Provided programming and analysis support for customizations made to HR, Benefits and Payroll modules.
• Reviewed and improved performance for online and batch routines, including App Engine, SQR, and PeopleCode routines.
• Responsible for the development and maintenance of inbound and outbound interfaces.
• Participated in unit testing, system testing, functional testing, user acceptance testing
• Documented system customization changes.
• Mentor and Monitored Junior Developers and offshore resources.

Confidential

Sr. PeopleSoft HCM Developer

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HCM for HR, Payroll and Base Benefits modules.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Developed number of interface reports using SQR to bridge communication between database - PeopleSoft and external applications.
• Responsible for functional and technical specifications for customized Benefits interface programs to meet plan change requirements.
• Developed Application Engine programs to create flat files for new outbound benefits interfaces.
• Identifying and fixing Job and Personal data of employees.
• Developed customized Benefits reports for Open Enrollment, New Hires, and Employee Benefits.
• Provided production support for Benefits, Payroll and HR systems.
• Designed PS query structure to reduce client efforts for duplicated activities.

Confidential - Richardson, TX

PeopleSoft HCM Developer

Responsibilities:

• Developed AE Interfaces to create and extract data from compliance feed to e-learning, process to sync comp time, Windstar foreign worker taxation feed, calculate international student work wages and hrs and send them to respective managers.
• Customized HCM 9.0 applications for adding reopen functionality in absence management system, providing functionality to user to enhance and update preferred name through self service.
• Design SQR reports to enhance the HR Accounting Line and update it with employee current details.
• Perform database level and Sql level performance tuning to increase the response time of various processes and jobs.
• Developed FTP interface to store different FTP paths as per the PeopleSoft environment and making it possible to create / extract flat files for execution of AE dynamically without modifying the app engine at different database instances.
• Involved in Data mapping for legacy data conversion.
• Developed, modified and debugged PeopleCode and Application engine programs.
• Used Process Scheduler to schedule SQR, Application Engine, PS-Query and Crystal reports.

Confidential - Plano, TX

Business Analyst

Responsibilities:

• Spearheaded cross-functional team consisting of sales and production personnel to assess existing technologies and business processes.
• Assumed responsibility in data modeling, business modeling, and business logic mapping adhered to database principles.
• Facilitated market research in determining new business needs and in creating business case development.
• Demonstrated analyst skills in interviewing business and technical leaders to gather and clarify business requirements.

Confidential

PeopleSoft HCM Developer

Responsibilities:

• Designed end user forms for table change requests and streamlined approval workflow process for the same.
• Created and modified Components, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• Design and Developed Employee Allocation system which involved linking the location transfer with allocation based on temporary, permanent or intercity transfer, analyzing auto assignment cancellation process when employee is made inactive, facility to have department and grade wise list of unassigned employees and link for assigning them to buffer project only, implementing the validation for assignment dates, Service Order dates.
• Creating the new workflows for allocation and visa/passport expiry process, reports for attrition data, location wise base data.
• Developed reminder mail flows for new address updating when employee goes onsite, reminder mails to employee who has not updated the skills since last 6 months in the system.
• Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• Developed PS queries and crystal reports for benefits and HR reporting.
• Conducted system and unit quality assurance testing. Created program and system workflow documentation.
• Responsible for designing a system that reported employee HRMS data changes through a workflow process.
• Responsible for system architectural (conceptual) design, logical and physical database design, programming and testing.
• Workflow data changes were reported to specific people based on event type, location and employee type.
• Modified custom Payroll and Benefits PeopleCode and SQRs to meet specifications to allow for multi-company setup.