SUMMARY

• Over 14 years of experience as a Technical /Functional Consultant / Technical Lead /Developer/Integration consultant which includes design, development, implementation, testing and support of the peoplesoft applications including PeopleSoft HR/Payroll/ Campus Solutions/ Financials / Time and Labor / CRM / Staffing
• Well - versed with Web Methodologies and languages like Java, JavaScript, XML, XSLT, WebServices, Visual Basic, ASP, HTML, DHTML, CSS, IIS, Web Server etc.
• Knowledge of BigData and Hadoop.
• Ability to adapt to a rapidly changing industry and work environment.
• Excellent skills in systems analysis, data modeling, design and development using fast and efficient algorithms, extensive validation tests and quality assurance.
• Design, development, implementation, upgrade, customization and testing of HRMS/FIN applications utilizing PeopleSoft 8.x/9.x
• Extensively worked on PeopleSoft HR, Payroll and Benefits modules.
• PeopleSoft Campus Solutions/Student Administration (CS) 8.0, 8.9, 9.0: Admissions, Campus Community, Financial Aid, Student Financials, Student Records
• Functional and Technical PeopleSoft HRMS/FIN development, updating and maintaining customized PeopleCode and PeopleTools objects.
• Experienced with People Soft CRM Module
• Experienced with Kronos Workforce Connect
• Well-versed with Microsoft .NET Technologies.
• Technically strong with Time and Labor in the development of Interfaces and reports.
• Experience in People Soft Internet Architecture (PIA) and People Tools. 
• Wrote and maintained various SQR processes and reports which supported the customization of the system.
• Designed and developed work products for all stages of the system development life cycle.
• Well experienced in Customizations of Workflow in various HR/Financial Modules.
• Well experienced in Customizations of CIs, Application Engine and  Application Packages
• Proficient in PeopleSoft reporting tools such as Crystal, nVision and SQR reports.
• Hands-on experience with Data Mover,
• Install, Develop and Test the Integration Broker.

PEOPLESOFT TECHNICAL ENVIRONMENT

Languages:  Java, JavaScript, Visual Basic, XML, XSLT, Webservices, ASP, HTML, DHTML, Waba, Cobol, Fortran, Pascal, C, C++

Reporting Tools: PS/Query, Crystal Reports, SQR, nVision and MS-Excel.

MainFrames : DB2, CICS, JCL, MVS, VSAM, COBOL Microsoft .NET Technologies C#, VB.NET, ASP.NET

ADDITIONAL PROFESSIONAL EXPERIENCE

Confidential

Houston, TX

HR/Portal/Integration Consultant

Environment: PeopleSoft 9.1 ((HRMS), Integration Broker, PS/Query, PL/SQL, Oracle9i, HTML, ASP, XML, XSLT, JavaScript, VBScript, Peoplesoft IScript, Webservices, WorkFlow.

Responsibilities:

• Install, Develop and Test the Complete Integration Broker Piece.
• Created and Installed the Messaging Servers, Gateways, and Nodes etc.
• Developed Message Channels, Messages.
• Setting up of the Connectors, Listening Connectors and Target Connectors.
• Setting up Synchronous and Asynchronous Transactions.
• Developed SOAP XML Doc to publish for the third party database.
• Created a Web Service Component for the Third Party Database using C#
• Publishing the XML doc to Third Party and Getting reply back from third party in XML.
• Updating the Third Party Database Real Time using IB.
• Responsible for creating the Component Interfaces, Business Interlinks,    Components and the Pages
• Develop and Test interfaces to third Parties and external applications using COM, Peoplesoft APIs, Visual Basic, ASP.
• Displaying the Peoplesoft Fields Data dynamically on the fly in to a government       I9  PDF Form using Peoplesoft IScript.
• Creating of the server side scripting using ASP, VBScript, Javascript and HTML and interacting it with the Peoplesoft Programs.
• Extensively used Peoplesoft IScript Functionality.
• Creating the link between the Peoplesoft Programs and the Outside Environment Programs.
• Responsible for creating the Business Maps, Activities, Steps involved in the process.
• Have done the complete WorkFlow.
• Customizations and Enhancement to the HR module.
• Customization & creation of several Fields, Records, Pages, Components & Menus using Application Designer.
• Extensively used peoplecode.
• Providing technical support for existing applications
• Have written (SQR) programs as per user requirements
• Creating the weblib records and assigning the security.
• Assigning of the permission lists.
• Worked  with functional analysts in improving processes
• Creating the roles and giving permissions to the roles
• Use Query Manager for the output of the Role Query.
• Passing data from the Peoplesoft Page to the ASP Pages and Vice Versa.

Katy, TX.

Peoplesoft Consultant

Environment: PeopleSoft 8.9 ((HRMS, Payroll, ePerformance, MSS, ESS, CG, TAM, Position Management, Peoplesoft Internet Architecture (PIA)), Kronos PeopleTools 8.43, Peoplesoft Scripting, SQR 4.x, PS/Query, PL/SQL, Oracle9i.

Responsibilities:

• Served as the single point of contact for the Business, for gathering requirements.
• Design, Development, Customization and Testing for the Upgrade
• Includes day-to-day support, design, development and testing of the PS HCM Module
• Applying PeopleSoft Tax updates and maintaining and supporting the Peoplesoft HR/Payroll.
• Production support of the Peoplesoft Application
• Customizing the application  as per the business needs
• Heavily wrote SQRs and peoplecode
• Responsible for Creating the Compare Reports
• Have done the complete WorkFlow.
• Customizations and Enhancement to the HR module.
• Customization & creation of several Fields, Records, Pages, Components & Menus using Application Designer.
• Extensively used peoplecode.
• Garnishment processing experience.
• Providing technical support for existing applications
• Have written (SQR) programs as per user requirements
• Supporting payroll, troubleshooting payroll problems, running  payroll interfaces both inbound and outbound. Providing on-call support for payroll shops for twenty three entities when the payroll is run bi-weekly
• Skilled in payroll systems (i.e. PeopleSoft HCM, ADP, etc.)
• SQR and PeopleTools programming skills were used to modify the PeopleSoft Direct Deposit Interface SQR.  These skills were also used to develop the following interfaces:
• Experience with multi-state payroll processing, including federal, state & local tax
• Outbound State And Federal Tax data interfaces
• Inbound  PeopleSoft benefits Pension Data Interface
• Interface to create payroll data for Tax Credits
• Developed Query using PS QUERY for STD with Pay and Deductions
• Developed RetroActive Deduction Report
• Created and modified the SQRs to retrofit the 8.8 functionality
• Calculate the YTD Earnings and Taxes as a Single Company.
• Creating and Modifying the Component Interfaces, Components and the Pages
• Used the peoplesoft delivered functionality where ever required
• Heavily worked on the work flow design and development
• Excellent customer service & verbal/written communication skills.
• Automated Time & Attendance System Kronos experience.

Peoplesoft Techno Functional Consultant

Environment: PeopleSoft 9.0 ((HRMS, Payroll, Peoplesoft Internet Architecture (PIA)), PeopleTools, Peoplesoft Scripting, SQR 4.x, PS/Query, PL/SQL, Oracle9i

Responsibilities:

• This is Conversion project of the Payroll from ADP to Peoplesoft System.
• Worked as a member on the  PeopleSoft Payroll Implementation team.
• Overseeing and developing  functional specifications.
• Configuration and setup of control tables.
• Overseeing the Mapping Documents from ADP to Peoplesoft.
• Trouble shooting and Fixing the Problems arising from Testing.
• Assisting management and system owners with process analysis to define problems and appropriate solutions affecting process improvements.
• Customizing the modules in order to satisfy user needs. Customization includes modifying existing PeopleSoft objects like records, menus, Creating new objects
• Applying PeopleSoft supplied bugs and fixes.
• Preparing the Change Requests and estimating the time requirements.
• Performance tuning the SQLs to make sure that the SQRs are  running without any performance issues.
• Have developed the main SQR program of the conversion TAX BALANCE.
• Creating the Mapping docs for Conversion etc.

Dallas TX.

Peoplesoft Technical Consultant

Environment: PeopleSoft 8.9((HRMS, Payroll, ePerformance, MSS, ESS, CG, TAM, Position Management, Peoplesoft Internet Architecture (PIA)), Kronos PeopleTools 8.43, Peoplesoft Scripting, SQR 4.x, PS/Query, PL/SQL, Oracle9i, WindowsXP

Responsibilities:

• Implemented very complex projects here at Cingular Wireless which includes the Bonus/Merit System, United Way, United Auction etc.
• Developed/Modified several Java, JSP, ASP, ASP.NET pages of various applications.
• Recognized with ERP Employee Impact Award by the VP of the company.
• Responsible for Implementing SOX standards for the Bonus Merit System.
• Worked  on the upgrade team to migrate the customizations and new enhancements to version 8.8/8.9. Retrofitted People Code, SQR to accommodate new customizations to meet Business requirements.
• Team Member for Upgrading to peoplesoft 8.8/8.9
• Served as the single point of contact for the Business, for gathering requirements and scooping the AT&T Cingular merger impact on Current Applications.
• Design, Development, Customization and Testing for the Upgrade 8.8/8.9
• Responsible for Creating the Compare Reports
• Supporting payroll, troubleshooting payroll problems, running  payroll interfaces both inbound and outbound. Providing on-call support for payroll shops for twenty three entities when the payroll is run bi-weekly
• SQR and PeopleTools programming skills were used to modify the PeopleSoft Direct Deposit Interface SQR.  These skills were also used to develop the following interfaces:
• Outbound State And Federal Tax data interfaces
• Inbound  PeopleSoft benefits Pension Data Interface
• Interface to create payroll data for Tax Credits
• Developed Query using PS QUERY for STD with Pay and Deductions
• Developed RetroActive Deduction Report
• Bringing AT & T employees on Cingular Payroll
• Converting AT and T contractors into Cingular System
• Created and modified the SQRs to retrofit the 8.8 functionality
• Calculate the YTD Earnings and Taxes as a Single Company.
• Creating and Modifying the Component Interfaces, Components and the Pages
• Used the peoplesoft 8.8/8.9 delivered functionality where ever required
• Heavily worked on the work flow design and development
• Creating roles and assigning security
• Creating a single W2 for the employees
• Designed the user interface for processes
• Involved in the technical architecture meeting
• Worked with the functional users to best use the 8.8/8.9delivered functionality.
• Used process scheduler to run the processes and reports through PeopleSoft and used process monitor to view the status of the reports.
• Wrote several payroll interface SQRs
• Heavily used people code
• Processed, updated, audited and monitored various HR and PeopleSoft Personnel Action Forms to ensure accuracy of all employee records.
• Created Application Engines Programs and modified existing ones.
• Developed application engine programs using SQL and Peoplecode to customize business rules for Cingular Wireless.
• Performed system analysis and wrote requirements for customizing rules for compliance with union contract agreements.
• Wrote SQRs, developed pages, components and process definitions for Time and Labor reports and processes.
• Developed and Tested PeopleSoft Components.
• Working with Kronos tables including Workgroups, Schedules, Permission lists, Time Reporting Codes and Rule Programs.
• Developed and tested rules and exceptions for Kronos.
• Worked with the Peoplesoft, Kronos and Web Teams.

Chicago, IL.  

Peoplesoft Technical Consultant

Environment:PeopleSoft 8.9((HRMS, Payroll, ePerformance, MSS, ESS, CG, TAM, Position Management, Peoplesoft Internet Architecture (PIA)), Kronos PeopleTools 8.43, Peoplesoft Scripting, SQR 4.x, PS/Query, PL/SQL, Oracle9i, WindowsXP

Responsibilities:

• Worked directly on numerous customization technical tasks in an effort to effectively meet timelines and project milestones.
• Using Oracle PL/SQL and People Code, developed a process to determine student Home Campus depending on majority enrollment and academic career.
• A significant bolt-on the Candidate Gateway that customizes how applicant attachments are uploaded and stored in HCM.
• Merging of student financial aid awards in Campus Solutions with HCM data T L Payable Time and Payroll Pay Earnings, for computation and complex reporting of work study earnings.
• An Application Engine AE program to consolidate and load university bookstore sales transaction data to the General Ledger in PeopleSoft Financials.
• Data conversion, using SQR and Data Mover, of student academic data from a non-PeopleSoft legacy system into PeopleSoft Campus Solutions.
• Technical tasks included development and implementation of a custom Class Roster, custom Grade Roster, several customizations to Schedule of Classes and Schedule New Course Components, determination of Aggregate Attendance, custom Student Bio-Demo pages and sub-pages
• Customization of Student Billing
• Developed/Modified several Java, JSP, ASP, ASP.NET pages of various applications.

Dallas, TX

Techno/Functional

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR and Payroll modules and ATS modules for staffing.
• • Created and modified Components, File Layouts, Pages, Records, Fields, Process Definitions and registering Components in Portal, Menu and Permission Lists.
• • Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• • Involved in online changes to the delivered pages, components, menus and translate values.
• • Developed an Application Engine Programs like Blue cross blue shield and HRIS Premiums Interface.
• • Developed and modified People Code to implement specific business rules and validations to enable the system to perform the business process.
• • Developed an application engine program using File Layouts to load New Hire interface file with all New Hired employees’ information after each day and load them into the people soft tables.
• • Worked on interface programs for migrating data from other systems to People Soft.
• • Also involved in acquiring Specifications from the functional team and modifying the SQR’s as per the SPECS.
• • Extensively used process scheduler for scheduling recurring process for conditional Scheduling of successive process for setting up the reports to run at specific time and implementation of batch processing.
• • Used File Layout Definition to get data from the legacy system to people soft tables.
• • Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• • Active role in changing the SQRs as per the change requests from the users.
• • Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• • Handled bundles for the process of solving the issues in the enhancements.
• • Conducted meetings with the Users and the testing team and involved in discussing their problems and helped them out in finding the proper solutions for their requirements.

Irving, TX        

VB/ASP Consultant

Environment: Microsoft ASP.NET, Microsoft C#.NET, Microsoft .NET Framework SDK, Microsoft OWC, MDAC, DHTML, JScript, XML, Teradata, Microsoft SQL Server, Microsoft Analysis Services, Microsoft Data Analyzer and Oracle.

Responsibilities:

• Managing the complete Project from scratch to finish. inception to completion
• Scheduling the team meeting every week for the progress, status and hurdles in the project.
• Attended Requirements, Functional and Technical meetings.
• Involved in JAD sessions with the Verizons business solutions and enterprise solutions groups
• Requirements gathering and documentation; Design Process flow diagrams
• Identify Business Functions and grouping related functions together
• Identify Business improvement opportunities (BIO) ; Identify Business Questions (BQ)
• Prioritize BIOs and identify business questions related to each BIO
• Worked closely with client-users to identify and refine business questions and functional requirements
• Designing the dynamic Front-end for aEDW using asp.net, OWC, XML, DHTML
• Deployed an application layer/middle tier (EDGE-Enterprise Data Gathering Engine) components for aEDW using C#.net, XML, MDAC, Sql server, Teradata macros, IIS
• Solely designed and developed Business Intelligence Analytics reports and Canned reports that using OWC components, ASP.NET, C#, that connects directly to the multi-dimensional OLAP cubes in the Analysis services of Sql server
• Incorporated excellent Pivot reporting and Pivot charting ability that would help in assessment of Verizons LOBs (Line of Businesses) decision support systems using .Net charting, Chart FX, MSOLAP, .NET SDK, Data Analyzer
• Implemented slicing n dicing analysis, visual reporting and dashboard information needs using .NET SDK, Data Analyzer, Sharepoint portal, Mappoint, Commerce server, Biztalk server and IIS
• Designed and developed Adhoc reporting using ASP.NET and Microsoft Office Web Components.
• Implemented the export reports functionality to PowerPoint, Excel, PDF and Microsoft Word
• Implemented the send reports email functionality where in the report is directly exported to Microsoft Outlook or Lotus Notes
• Implemented Upload and Download files Functionality and dynamic creation of Local Cubes functionality

Chicago, IL

Financial Consultant

Environment: PeopleTools 8.42 (GL, AP, AR, PO, Inventory & Billing), Application Designer, PeopleCode, Application Engine, PS/Query, Data Mover, Crystal Reports, PSnVision, SQR, SQL Server2000, Windows 2000.

Responsibilities:

• Part of upgrade team to migrate the customizations and new
• Converting Accounting entries to PeopleSoft Journals, defining Journal Generator Templates, transferring journals to General Ledger.
• Involved in customization of Journal Entry, Voucher Entry, Maintaining Vendors, Buying agreements and Requisitioning items using Application designer and PeopleCode.
• Customized GLS9002.sqr that loads data from flat files into journal entry data. Used Load Lookup feature of SQR to tune performance here.
• Involved in customization of Chatfield as per the requirement of the end users.
• Modified Journal entry page by adding a field called JRNL PREFIX to improve performance in retrieving data.
• Customized Journal Entry Detail Report, FIN2001.sqr to show correct Chatfield values.
• Tested the interfacing between General Ledger, Accounts Receivables, Accounts Payable & Billing modules to ensure that the data is accurately interfaced. Customized Records, Pages, Menus based on user specifications using People Tools and People Code.
• Troubleshoot (AR UPDATE) Application Engine process; causing negative amount validation error while updating item tables. Customized AR30003.SQR, AR30004.SQR to print the number of disputed items for each customer along with the number of disputed items for the business unit, order number, PO references and the reports.
• Customized AP MATCHING process to perform Matching validation among receipts, PO and invoices and a Match exception crystal report APY1090 to view the disputed values that are populated after running Matching process.
• Created reports for daily cash book payments and receipts, ledgers for individual accounts, monthly suspense payments and receipts, and monthly account statements.

Dallas, TX     

Technical Consultant

Environment: PeopleSoft 8.0/7.5 ((HR, Payroll Administration, Benefits Administration, Base Benefits, Peoplesoft Internet Architecture (PIA)), SQR 4.x, PeopleTools7.5, PS/Query, nVision, PL/SQL, Oracle8i,WindowsNT4.0, HTML  

Responsibilities:

• Worked with the upgrade team to migrate the customizations and new enhancements to HRMS 8.0.
• Worked with 8.0 related tools like Internet Options, converting panels to pages, panel groups to components. Worked with HTML area, Push Buttons, Hyper link controls and Scroll Controls during page design
• Implemented the Business Process Design for Benefit Admin. (Workflow).
• Upgradation, Customization & creation of several Fields, Records, Panels, Panel Groups & Menus using Application Designer.
• Modification & Testing of (SQR) programs as per user requirements
• Developed & modified complex HR & Payroll module, SQR reports to suit the  needs of an organization. Also Interfaced PS/Query with Crystal Reports for Adhoc reports.
• Involved in implementation of PeopleSoft Human Resources & Base Benefits.
• Used process scheduler to run the processes and reports through PeopleSoft panels and used process monitor to view the status of the reports.
• Analysis and development of specifications for incentive compensation programs.
• Created SQL objects in SQL Editor and migrated to production database.
• Performed system tests, on-site installation and on-site training for end user.

Plano, TX                 

PeopleSoft Technical Consultant

Environment:  PeopleSoft HRMS 7.5, PeopleTools 7.52 (Application Designer, Peoplecode,  PeopleTools), SQR, Oracle 8.x, HP-UX, Windows NT

Responsibilities:

• Conversion and integration of legacy data into an existing HRMS implementation as well as custom reporting and processes. 
• Identified data conversion abnormalities and streamlining correction procedures. 
• Completed design and construction of interfaces using SQR, SQL and PeopleTools. 
• Assisted the clients in testing and implementing each interface. Authored technical documentation for end-users.
• Customization of payroll processes, human resources reports, data conversion, as well as panel modifications using SQR and PeopleTools. 
• Produced benefit eligibility reports for new employees through corporate acquisitions. 
• Accountable for the direct deposit transmittal, paycheck printing and payroll reporting capabilities of the system.

Syracuse NY   

PeopleSoft Consultant

Environment: PeopleSoft HRMS 6.0/7.0, PeopleTools, SQR, Oracle 7.x, Bea Tuxedo, HP- UX, Windows NT

Responsibilities:

• Gap Analysis & User Interaction.
• System Analysis, Design and Development of Panels and Reports.
• Generating SQRs for reporting, Creation of new panels and Customization of existing panels using data designer, panel designer and menu designer, Importing of data into the client database.
• Analysis, Design & Development
• Unit and Systems testing
• Study of the then existing PeopleSoft HRMS version 6 on NT Platform.
• All the changes required to migrate this system to UNIX platform, Oracle database and PeopleSoft version 7 with option to run in either three tier or two tier mode were documented.
• Installation of PeopleSoft v7 on Oracle 7 (UNIX) Three tier mode
• Installation of Oracle database version 7.
• Bea Tuxedo was installed for each instance of the database.
• Data mover was used to migrate all the data from the PeopleSoft version 6 on SQLBase to PeopleSoft version 7 on Oracle 7.