OVERVIEW
Summary

• A total of over 11 years of IT experience with 6 years of strong experience in Peoplesoft HCM 8.9 and over 5 years of experience in Mainframe technology
• Specializing in Peoplesoft HR, Benefits, Benefits Administration, Payroll, ELM and Portal applications
• Gained experience full suite of Peopletools, including Peoplecode, Application Designer, Application Engine, Process Scheduler, Tree Manager, Integration Broker, Component Interface, File Layout, Application Packages, PS Query, Data Mover and Crystal Reports
• Extremely proficient using SQR to create reports and interfaces
• Involved in various levels of testing including Unit/System/Integration and User Acceptance Testing
• Five years of extensive experience in Peoplesoft implementation, upgrade & support activities including creating technical specifications, development, customizations, testing, production support, coordination with functional users, technical team management and project coordination
• Full understanding of SDLC methodologies and full life-cycle project experience
• Strong communication skills combined with a positive attitude make me a key team player, demonstrated leadership ability to resolve issues, drive projects, and meet deadlines, highly adaptable individual, motivated to develop successful solutions, a versatile team player with excellent communication and interpersonal skills

EDUCATION

• Post Graduate Diploma in Computer Applications
• Master of Science, M.Sc.,

SKILL SETS

ERP: Peoplesoft HR/NA Payroll/Payroll Interface/Benefits/Benefits Administration/Workforce Administration/Time and Labor/Self Service/ELM/Finance/Portal/ePay/eRecruit/eProfile/ eBenefits

LANG/TECH: Peoplecode/SQR/COBOL/SQL/PS Query/File Layout/XML/HTML/Application Designer/Application Engine/Integration Broker/Data Mover/ Configuration Manager/Process Scheduler/Process Monitor/Message Catalog/Crystal Reports/Change Assistant/Object Security
JCL/COBOL/DB2/CICS/ROSCOE/EZTRIEVE/BASIC/PASCAL/C++/VB/Fox-Pro/UNIX/Rapid
SQL/SQL Plus/ PL/I

DATABASE: DB2/Sybase/SQL Server/IMS DB/Oracle 9i/10g

TOOLS: TOAD/Test Director/Remedy/WOM/PVCS/STAT/Taleo/Zoniac/CATS/Lotus Notes/File Aid/DBX/EXT/SPUFI/QMF/Revolve-2000/VIASOFT/TSO ISPF

CERTIFICATIONS

• Certification in Peoplesoft HCM 8.9/Integration Tools Release 8.48 Ed 3
• Certificate of accomplishment in Mainframe
• Diploma in RDBMS – Sybase, Power Builder V4.0
• Diploma in Desktop Publishing – Ventura & PageMaker
• Proficiency in UNIX, C, OOPS and C++

EXPERIENCE
Confidential,MN October 2008 – September 2009
Techno Functional Analysis
Role: Techno Functional Consultant
Confidential, provides business consulting services to companies seeking solutions for everyday business needs. My involvement towards this start up company was to focus on the business growth and management of recruiting activities and project consulting.
Accomplishments

• Involved in the development and customization of portal application changes including creation of Short Cut Collections, Pagelets, adding links to Left Navigation and Security set up
• Worked on customization of COBOL programs – added garnishment array to check print program, tax update changes to load deductions array program which included Federal and MetLife changes and others
• Coordinated the business activities
• preparation of business plan
• website
• client interactions
• Power point presentations, Video conferencing and others

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN, Self-Service), Peopletools 8.48 (Application Engine, Peoplecode, PS Query, Application Designer), SQR, ORACLE 10g, Talent Acquisition Management tools (CATS, TALEO, ZONIAC), SQL. COBOL, Business Plan Toolkit, Illustrator, HTML, MS Project, Visio, MS Office 2007

Confidential,MN December 2007 – September 2008
Peoplesoft Implementation
Role: Senior Applications Analyst
Confidential,is a government organization that provides services to the community residents. It uses Peoplesoft technology for ERP needs. Multiple projects were on progress including upgrade, implementation of Time and Labor, Self-Service and ELM applications. My involvement was towards development, support and coordination of these modules.
Accomplishments

• Peoplesoft development and support for implementations/upgrades/customizations of HRMS 8.9, ELM 9.0, Portal 8.9 and Self-Service 8.9 applications
• Coordinated, developed and executed the project steps for year end W2 wage reporting and tax filing
• Customized the payroll compensation self-service application to add flexibility to the users to select their voluntary charitable contributions towards multiple agencies
• Involved in the development and customization of portal application changes including creation of Short Cut Collections, Pagelets, adding links to Left Navigation and Security set up
• Coordinated an integration of multiple systems - HCM, ELM, WFD and others to consolidate the fire and police skills information to prepare for the emergency situations during Republican National Convention
• Involved in the integration of HRIS with Finance applications including integration between Time and Labor to Project costing, Payroll to General Ledger and Payroll to Accounts Payable
• Involved with monitoring and trouble shooting integration broker messages
• Gained knowledge on ELM integration with HCM 8.9 through configuration setup tasks, Full/Incremental sync step processes, issue resolution and technical documentation
• Worked on discontinuation of employee benefits when library was detached from the City
• Worked on testing Peopletools and payroll run during Peoplesoft 8.9 upgrade
• Familiarity with T&L bare bone implementation
• Supported the biweekly payroll processing by monitoring/running payroll jobs, working with UNISYS on payroll job submissions and through resolving issues
• Updated the payroll process run document with necessary updates from the functional analysts

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN/TL, Benefits Administration, ELM, Finance, Self-Service –ESS, MSS, ePay, eProfile, eBenefits), Peopletools 8.48 (Integration Broker, Application Package, Component Interface, File-Layout, Application Engine, Peoplecode, PS Query, Application Designer), SQR, Oracle 9i/10g, MS Project, Visio, HTML, XML, JAVA, UNIX, COBOL, SQL Plus, TOAD

Confidential,IL August 2007 - November 2007
Peoplesoft Support
Role: Peoplesoft Developer
Confidential,is an IT division of NYC advertising agency. NYC acquired another advertising company called Leo Burnett and its agencies that use the shared service HR Processing (Starcom, Capps Digital, Planworks). NYC was using Payroll Interface whereas Leo Burnett was in NA payroll system. This project was about Payroll consolidation. I was involved with the Fit-Gap analysis, customizations of SQR and Peoplecode.
Accomplishments

• Participated in Fit-Gap analysis sessions and made necessary contributions to the Gaps documentation which included Decentralized data entry, Position management, SETID, Annual and Semi-monthly salary amounts, Expatriate employees, Security, Action/Reason codes, Benefits Interfaces, Payroll reports, Earning details, Department ID, Banking codes and others
• Worked on table mapping for the conversion
• Customized online pages and SQR programs based on the conversion rules
• Developed SQR program and customized online pages and Peoplecode for Position Management to add flexibility to Employee/Supervisor relationships through override mechanisms and to distinguish between default approver, T&E approver and Performance reviewer

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN, Benefits Administration), Peopletools 8.48 (Peoplecode, Application Designer), SQR, SQL Server

Confidential,MN May 2007 - July 2007
Peoplesoft Support
Role: Portal Application Owner
Confidential,is involved in retail business. I provided support as “Portal Application owner” to the Enterprise portal applications.
Accomplishments

• Gained experience working as “Portal Application Owner”
• Supported the daily Portal process flow in production
• Worked on Portal Short Cut collections and Portal Pagelets
• Customization of iScript and created new JAVA servlets for Portal document import and display
• Customized HTML objects to give better look and feel of framesets
• Added portal links to the Self-Service pages for “HR Zone & Pay and Benefits”
• Worked on development and customization of Peoplecode, XML, HTML, JAVA scripts and iScript towards Portal implementation
• Resolved content check-in errors and infrastructure issues

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN, Self-Service, Portal), Peopletools 8.48 (Peoplecode, Application Package, Style Sheet, XML, HTML, iScript, Application Engine, Application Designer), SQR, DB2, UNIX, STAT, Remedy, Test Director, WOM

Confidential,WI November 2006 - April 2007
Peoplesoft Development
Role: Peoplesoft Developer
Confidential, is an educational institution providing educational services to the students. They wanted to automate and streamline payroll processes within Peoplesoft 8.0 application. I was on a contract to perform this major assignment. In addition, I worked on few additional projects identified as part of payroll optimization.
Accomplishments

• Expert document analysis of various HR, Payroll, Benefits and Time & Labor business processes
• Prepared project steps towards payroll optimization
• Created the design for the payroll optimization
• Worked on development and customization of SQR programs for annual, quarterly and monthly tax reporting, unemployment insurance, conversion of output from control register, deduction registers in to spreadsheets as per the format specified by the users, garnishments, new hire report, employment verification report for loan purposes, inclusion of banking FTP processes and others
• Created benefits interfaces for HUMANA and DELTA Dental
• Worked on W2 outsourcing for monetary benefits and to increase efficiency
• Made changes to the online pages and Peoplecode
• Consolidated and created new run control pages for various phases of the payroll process including pay sheet creation, pay calc and pay confirm
• Created component interfaces including object oriented programming and automated their entire payroll

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN, Self-Service), Peopletools 8.48 (Peoplecode, Component Interface, Application Designer), SQR, SQL Server

Confidential,NY January 2006 - October 2006
Peoplesoft Development
Role: Senior Peoplesoft Developer
Confidential,is a financial advisor to companies, governments and investors around the globe. I was responsible for Peoplesoft development and customization activities. I was also involved with SQR optimization.
Accomplishments

• Provided production support to HR, Payroll and Benefits applications
• Developed a full life cycle implementation of the Employee Relations and Compliance Issue tracking modules
• Worked efficiently on proration SQR module towards optimization effort and reduced its run time from 2 hours to 10 minutes. In addition, I discovered many bugs in the bonus and reward calculations and programmatically corrected them after getting the necessary clarifications on the process from the functional analysts
• Prepared technical documentation of SQR optimization and passed on to the team for their knowledge. In addition, I delivered a power point presentation to the director, functional and technical leads and the technical team
• Worked on SQR reports that included ADP employee list load, LOA tracking, payroll actives & terms listing and compensation summary report
• Worked on customizations of SQR related to ADP payroll interface
• Worked on HR, Payroll and Benefits related Peoplecode changes for multiple projects including employee covenant agreement, LDAP, Job information page customization and others

Project Technologies/ Products
Peoplesoft 8.0 (HRMS – HR/PY/BN, Benefits Administration), Peopletools 8.19 (Component Interface, Peoplecode, Application Designer), SQR, Sybase, Rapid SQL, UNIX

Confidential,MN September 2005 - December 2005
Peoplesoft Development
Role: Peoplesoft Developer
Confidential,is one of the world’s largest third party logistics (3PL) providers. Their business is centered around freight transportation, logistics and fresh produce sourcing. My involvement was towards creating SQR programs for their Peoplesoft reporting and Interface needs. My additional involvement was towards setting up pay check printing process.
Accomplishments

• Installed MICR fonts on the printer for Paycheck printing and customized the print check SQR program to suit online and batch printing as per the Functional requirement
• Reviewed the pay check print SQR program thoroughly and prepared the necessary technical documentation
• Prepared several SQR and PS Query reports including reports to update yearly BAS activity, Profit sharing YTD by department, COBRA eligibility, Service award eligibility and others
• Created SQR interfaces for MetLife, VSP and UHC Medical coverage

Project Technologies/ Products
Peoplesoft 8.9 (HCM – HR/PY/BN, Benefits Administration), Peopletools 8.47 (Peoplecode, Application Designer), SQR, SQL Server

Confidential,MN October 2004 - August 2005
Peoplesoft Development
Role: Senior Peoplesoft Developer
Confidential,is involved in retail business. They went for Peoplesoft 8.8 implementation with different teams dedicated to work on various modules. I was the Team lead for 15 team members for the Reporting team.
Accomplishments

• Coordinated the HRMS reporting team effectively including onsite-offshore coordination
• Tracked the daily progress and updated the management accordingly
• Delivered successfully 225 SQR reports as a team lead on HRMS applications (HR/PY/BN/TL)
• Prepared JCL for running Application Engine and SQR
• Trained the team on JCL job submission process and issue resolution
• Created SQR reports which including 30/60/90 day report, New Hire report, LOA activity, Payroll registers, Monthly employer taxes, LTD arrears, Life premium journal, Grandfathering and others
• Worked on customization of Application Engine program for step increase process

Project Technologies/ Products
Peoplesoft 8.8 (HCM – HR/PY/BN/TL, Benefits Administration), Peopletools 8.47 (PS Query, Application Engine, Peoplecode), SQR, SQL, STAT, Test Director, Remedy, WOM, UNIX, COBOL, PVCS, JCL, DB2

Confidential,Bloomington, IL May 1999 - September 2004
Mainframe/Peoplesoft Development
Role: Systems Analyst
Confidential,is a major insurance company supporting auto, home, life and other insurance needs. This project was about mainframe application support and Peoplesoft Implementation.
Accomplishments

• Worked as Project coordinator for 55 team members to convert all State/Division based auto insurance applications to office based auto insurance processing
• Development and support of batch Household Review system on mainframe based auto insurance applications
• Worked on claims processing, multi car discount, auto rating and guaranteed renewal application changes
• Attended Peoplesoft training in HRMS and Finance on V8.0
• Customized and developed various reports under Finance module using SQR, crystal report, PL/SQL which included duplicate voucher report, data extracts for vendor and payment information and others
• Involved in database conversion from Legacy system into Peoplesoft using SQL, SQR and DB2

Project Technologies/ Products
Peoplesoft 8.8 (HCM – HR/PY/BN), Peopletools 8.43 (Application Designer, Peoplecode), SQR, Lotus Notes, Oracle 9i, JCL, IMS, DB2, COBOL, RMS, DBX, EXT, MS Project, Crystal Report

Tennesse Healthcare, Nashville, TN February 1998 - April 1999
System Development
Role: Mainframe Developer/Team Lead
Tennessee Healthcare is an organization to provide health insurance services to the society. This project was about making Y2K changes to their Mainframe applications and enhancements to their existing systems.
Accomplishments

• Worked on maintenance of back-end recipient subsystem
• Worked on Y2K changes
• Coded system enhancement for annual benefits enrollment
• Worked on making changes for printing different benefit letters
• Involved in Query analysis for year-end program

Project Technologies/ Products
COBOL, DB2, JCL, MVS, ROSCOE, EZTRIEVE