Professional Profile

• Over 19 years of Software Application development and Leadership experience. Over 10 years of experience in PeopleSoft HCM 9.2/9.1/8.9.
• American Payroll Association Certified Certified Payroll Professional CPP
• Areas worked include Project management, Functional and Technical solutions for PeopleSoft North America Payroll and HR.
• In-depth working knowledge of PeopleSoft modules like HR, Payroll, ELM, Payroll Interface, Base Benefits, Benefits Administration, Person model, Employee Self service ESS and Manager Self service MSS .
• Extensively worked on PeopleSoft developing tools: SQR, Oracle SQL, PeopleSoft Application Designer, PeopleCode, Application Engine, XML Publisher, Data Mover, PS Query, Process Scheduler, Tree Manager
• Familiar with Kronos Workforce Central Time Keeping system
• Experience in Batch Processing, Upgrade, Migration and Interfaces Development.
• Lead the development team on successful implementation of various PeopleSoft HRMS enhancement requests
• Result oriented and can perform at all levels in Information Technology: Developer, Business Analyst, Tester, Lead and Manager
• Extensively worked on Mainframe technologies such as JCL, VSAM, PL/I, CMS, Nomad, DB2
• Result oriented, have strong interpersonal and written communication skills with the ability to relate well to individuals at all levels within the organization. Familiar with project management and offshoring model for software development and testing
• Experience in all phases of the complete lifecycle of the project involving Requirements, Analysis, Design, Development, Conversions, Testing and Maintenance, Application Performance, and Production Support
• Strong ability to drive Business processes for IT development and coordination
• Ability to work independently and collaboratively to accomplish assignments

Skills Summary

• Packages :PeopleSoft HCM 9.2, 9.1, 8.9, 8.3 HR/ Base Benefits/ Payroll , Oracle Incentive Compensation Oracle eBusiness Suite R12
• PeopleSoft Tools : Application Designer, Security, Application Engine, Tree Manager, Query
• Manager, File Layout, Application Upgrade Asst, Process Scheduler,
• Component Interface, Maintain Security and Data Mover.
• Reporting Tools : SQR, XML processing, nVision, PS Query and Data Reports
• Languages : PeopleCode, HTML, SQL, PL/SQL, COBOL, JCL and NOMAD
• Database : Oracle 11g and 10i, MS Access, SQL Server and DB2
• Operating System : Mainframes, UNIX, WINDOWS NT/95/98/2000 and MS DOS
• Other Tools : TIDAL, TOAD, AQT, STAT, SecureFx, PGP, Remedy and Siebel

Work Experience

Confidential

Role : Developer / Business Analyst / Support

• Gather requirements from user as per incidents or work orders
• Provide solution to cater business needs, prepare functional and technical documents.
• Support PeopleSoft HR, Payroll application
• Support customized PeopleSoft Enterprise Learning Management environment.
• Develop and support interfaces inbound and outbound,
• Closely work with PeopleSoft admins in case of migrations and issues.
• Support and provide solutions to PeopleSoft Security group.
• Help in decommissioning of applications to release resources.

Confidential

Role : Sr Technical Developer / Business Analyst / Tester

• Gather requirements, give solution to cater business needs, prepare functional and technical documents.
• Set up PeopleSoft tables.
• Create and modify SQRs, PeopleCodes to support custom functionality. Test and support UAT and help with production migrations.
• Run year end process to generate W2
• Perform tax updates.
• Fit/gap analysis.
• Give process and performance improvements
• Do payroll production support, payroll taxes, GL, Bonus runs, Stock options and dividends.
• Support Kronos time keeping system for calculated accruals.
• Provide support for internal and external audits for payroll technical.
• Write queries and report for users using SQL and SQR

PeopleSoft projects worked on Design, Develop, Test and Implement

• Print pay statement for Checks and Advices multiple pages instead of limiting to 13 lines for each section SQR Program
• Pay statement print as pdf on Employee Self Service using XML publisher ESS Page, PeopleCodes, PS Query, XML Report
• Automate nightly processes for pay sheet create, Calc, GL processes, etc. SQR Programs, Pages, PeopleCode
• Modify customized program to support Year End processes for W2 file generation for ADP - SQR Program
• Kronos accrual setup designed, and configured automated Kronos Accruals for different accrual plans Kronos, SQR Programs
• Modify custom GL process to support Incentive and Bonus Earnings SQR Programs
• Year end Accruals split for exempt and non-exempt employees Pages, SQR Programs, Kronos
• Set up/Modify Earnings codes, Deduction codes, Pay Calendars and other payroll set ups
• Work with Benefits and HR team on various projects
• Create customized PTO rates process for commissioned employees Pages, PeopleCodes, SQR Programs
• Set up automated processes with UNUM for STD payments Pages, PeopleCodes, SQR Programs, Earnings and Deduction setups
• Disaster Recovery Fund ESS Page, PeopleCodes, SQR programs, Deduction setups
• Stock Dividend earning setup Earnings Codes setup, GL Setup, SQR Programs

Confidential

Role : Sr Technical Developer

• Member of project development team and application support team.
• Gather requirements from business and convert into technical configuration for Oracle Incentive Compensation tool.
• Coordinate with various 3rd party applications for required feed and data analysis requirements.
• Write Data Interfaces from various markets.
• Design and create product, product hierarchy and classification rule sets.
• Create and update lookups, roles and pay groups.
• Create and modify expressions, formulas, plan elements and compensation plans in oracle incentive compensation.
• Create and modify UNIX scripts, SQL loader scripts, Procedures and Functions Write PL/SQL codes to support custom functionality.
• Unit test, assist in SIT, UAT and production deployments.

Confidential

Role : Business Analyst and Technical Lead

• Member of Application Support team Business Analysts, Developers, Testers and Production Support involved in Enhancement and Maintenance of PeopleSoft HRMS North America Payroll, Employee Self Service, Time Labor modules for Thomson Financials, Learning and Legal Regulatory business groups.
• Working as Business Analyst to gather user requirements and documenting changes required in Business Requirement Document - Provided solution to users on change requests. Coordinated with developers onsite and offshore , testers onsite and offshore , migrators, and security team for requirements walk-through.
• Worked on Mergers and Acquisitions and Divestitures for Thomson companies.
• Performed production support 24x7 activities on rotation basis to resolve critical production tickets. This involves analysis and fixes to PeopleCode, Application Engines, SQRs, and UNIX scripts.
• Involved in Analysis and Implementation of PeopleSoft Tax Updates. Responsibilities included generating compare reports, retrofitting customized SQR and PeopleCode, running DMS scripts, and co-ordinating with App Server group, DBA group and Migration team to implement Tax Updates in production.
• Worked as lead developer during PeopleSoft HRMS Re-hosting project to do Analysis, Design, and Develop changes / enhancements required in SQR/SQC, PeopleCodes, UNIX scripts, File Transmission process, Encryption and Decryption PGP of interface files and Documentation of new architecture and support processes.
• Worked on weekly Application Server and Process Scheduler maintenance on PeopleSoft Production instance.
• Worked on complete SDLC on PeopleSoft enhancements and projects including estimation, analysis, coding, testing SIT and UAT , security setup and migration to production environment.
• Functionally involved in setting up customized Leave Accrual process from setting up Benefit plans, Leave Rate table, Mapping of Benefit program to Benefit plans and Plan Types. Planned, wrote scripts and implemented Year End Leave Accruals split up process.
• Knowledge on Time Labor process flow.
• Worked as Team lead onsite-offshore model for offshore development team to fill in gaps of Business Requirement understanding, Estimating development timelines, providing technical solutions, and do weekly status reporting. Also help developers to get clarification from Business Analysts and users on requirements.
• Involved in Analysis and Changes required during Company Acquitions and Mergers. Coordinated to develop Component Interfaces for smooth transitions of company mergers to setup Personal data, Job data, Benefit plans, Compensation load, Balance tables setup.
• Actively involved in Knowledge Transition KT sessions with client to capture technical processes and prepared Knowledge Acquisitions Documents on same for future references for technical team.
• Lead 10 people team for PeopleSoft HRMS Knowledge Transition KT from acquiring knwledge to steady state of project.
• Prepared KT Documents so that product specific Knowledge can be retained and reused.

Confidential

Role : Senior Programmer / Analyst

• Performed design, analysis, coding, and testing of programs for various batch and on-line functions as well as unit and user support, acceptance testing, screen generation, system maintenance, production support and documentation.
• Worked as PeopleSoft Technical Production Support. This involved monitoring process scheduler jobs, fixing SQRs and PeopleCode, Support manual File Transmission interfaces, Coordinate and work with payroll operations team for day to day issues and resolutions.
• As a development Lead, gathered requirement specification from Business Analyst, designed and developed solution and stratergy for developers. Coordinate with SIT and User Acceptance Testers.
• Applied Tax Updates as per PeopleSoft release. This involved identifying and retrofitting custom code in PeopleCode, SQR and running Data Mover scripts.
• Designed and developed programs, reports with SQR for batch processing, Interfaces etc.
• Designed and created Roles, Permission list, Security groups etc as per the specifications from Bank.
• Performed PeopleCode, build/alter Records, created pages, translate values, SQL scripts and UNIX scripts.
• Managed and mentor development team.

Connfidential

• Supported Mainframe applications proprietary to Bank of America such as Key Executive Stock options Plans KESP , Take Ownership Stock plans TOS , and Human Resource International System HRIS functionally and technically.
• Performed production support, business analyst, and development support activities for applications on Nomad.
• Responsibilities include direct interaction with users to gather requirements, coding, do system integration and user acceptance testing for enhancement requests.
• Developed several Nomad programs and designed Nomad database for enhancement requests.
• Worked as second level Functional and Technical support for Mainframe applications on Nomad.
• Daily interaction with HRIS users 26 countries spread across globe to solve production tickets and resolve other day to day issues.
• Daily interaction with other critical system supports as KESP/TOS had strong dependencies with source payroll system such as PeopleSoft NA payroll and HRIS for international payroll.
• Daily interaction with stock options agents Smith Barney for solutions with several KESP and TOS plans, and other data issues when stock options are exercised.
• Handled independently 700 man hours project in KESP and TOS application during stock split and was awarded Star award from Bank of America.

Confidential

Role : Programmer

• Provide technical expertise to support various applications on Mainframe. Completed system study on existing applications that had no documentation and prepared documentation for same so that these systems can be migrated to new upgraded platforms.
• Completed system study on Cable Management application that detailed telephone cabling system to identify cubicle, building, and location by telephone number. This involved reverse engineering of COBOL and PL-1 programs, User interactions, creating and generating reports.
• Maintenance of Student Admission system on Mainframe. This involved writing new and modifying JCL and PL-1 programs.
• Modified and wrote new CICS code for modifying pages.
• Wrote reports in PL/I as per user requirements.
• Debugged and completed code analysis for making system ready for year 2000 compliant. This included analysis and providing solution for approach and code fix for JCL, PL/I, DB2, and Datasets.

Confidential

Role : Programmer

• Project involved Migration from DMS/PL-I to CICS/PL-I for existing on-line programs on Mainframe. Also to make online and batch programs Year 2000 compliant.
• Wrote and tested JCL, PL-1, COBOL codes as per given requirements. Created new CICS MAPS forms converting from DMS.
• Involved in Unit and System testing. Prepared JCLs and test data for each environment.

Confidential

Role : Programmer

• Interacted with Engineering and Textile Plant Management staff to develop and maintain Textile Packaging, Folding and Sales applications. Wrote programs in Integra RDBMS and UNIX Shell Scripting. Monitored and maintained HP UNIX servers.
• Automated and fixed the processes to avoid common issues faced by users in various Textile units. This decreased IT calls and issues by almost 80 .
• Developed online Forms, Processes, Reports for users using Intergra Forms, embedded SQL in Integra v3 and v4 language, UNIX shell scripts.