Profile

• Thirteen years of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Extensive experience with analysis, design, development, customizations, implementation, Support and upgrade of software applications including ERP applications.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.
• Strong database skills, Object Oriented Programming and development knowledge
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player
• Dedicated, creative and self reliant
• Strong on Reporting Tools like BI Publisher, SQR, Crystal Reports, PS/Query, PeopleSoft Security and PS/nVision.
• SME in PeopleTools Application Designer, Application Engine, Upgrade Assistant, Component Interface, Integration broker, Security Administrator.
• Lead Fit/Gap analysis of the Finance processes in the PeopleSoft Version 9.2 and identified the customizations that needed to be carried forward.
• Proficient in writing complex database reports and customizing PeopleSoft Delivered SQR reports.
• Have good understanding of Functional aspects of various modules in PeopleSoft HRMS - HR, Payroll, Financials - GL, AP, eProcurement, AM

Skill Set

• ERP: Peoplesoft 8.8,9.2 , Peopletools 8.48, 8.53
• Functional Modules: Financials GL, AR, AP, AM, ePro , Global Payroll, Human Resources Management, Customer Relationship Management
• RDBMS: Oracle 11g, MS-SQL Server 2012, DB2 9.5, MS Access Development Tools: Application Designer, Process Scheduler, Tree Manager, Workflow. Integration Tools: Application Engine, Component Interface, Business Interlinks, File Layout, Application Messaging Reporting Tools: BI Publisher, PS Query, Crystal Reports, SQR, PS/N-Vision, Oracle Business Intelligence 10g R3.
• Administration Tools: Data Mover, Update Assistant, Security Administrator, Configuration Manager
• Languages / Tools: ImageNow 6.6, Visual Basic, ASP, Java script, VB script, Autosys Web 1.2,HTML, Dream Weaver, Front Page
• Processes: IBM's QMS Quality Management System
• Migration Tool: STAT 5.5

Professional Experience

Confidential

Lead Technical Consultant

• Led planning and execution of PeopleSoft Financials system upgrade from 8.8 to 9.2.
• Conducted Technical fit gap sessions to review 8.9 compare reports to identify customizations.
• Identified development to release methodology for various test moves and MTP.
• Led detailed testing planned at various stages, executed, and results were validated before releasing the system to users. Created Unit Testing Scripts and executed them.
• Worked closely with the functional team to resolve defects in Unit Testing and System Testing
• Led the development and modification of Outbound and Inbound interfaces using various tools.
• Led the efforts on mapping functional requirements to technical requirements, documentation of technical specifications and development of test cases.
• Led the development and modification of PeopleCode to implement specific business rules and validations to enable the system to perform the business process.
• Created a process in BI Publisher for 8.9 Crystal checks, retrofit customizations from 8.9 system and applied added security on Check printing. Set up the MICR Fonts on separate server which is used only for Check Printing. Restricted use of check printer only from the Check server. Implemented industry best practices for Check printing.
• Worked on Application package customizations to meet complex ePro workflow requirements.
• Created new Workcenter pagelets using queries, pivots and Components for GL, ePro and AP. Defined filters to personalize workcenters for users.
• Coordinated meetings and development efforts between different groups in setting up the inbound, outbound and archival file processing for all inbound / outbound files for the new upgraded server.
• Led the efforts for resolving and documenting post upgrade issues. Environment: PeopleSoft Financials 9.2, PeopleTools 8.53, Oracle 11g

Confidential

PeopleSoft Financials

• Determine application systems requirements for new and modified applications.
• Develop, test and implement efficient, cost-effective application solutions for business units across VNSNY.
• Provide technical instructions to the team members monitor and check their work.
• Develop project plans, complete regular status reports, attend user meetings and project status meetings to organize and plan team activities.
• Work with management of business units to identify specifications for complex business requirements, platforms and computing environments, software, hardware and tools.
• Serve as a technical resource to team members in all phases of development and implementation.
• Provide PeopleSoft Financials technical support on a daily basis.
• Develop and test new features/enhancements to the PeopleSoft and ImageNow systems.
• Provide clear documentation of enhancements made to PeopleSoft and ImageNow systems.
• Design/implement and maintain workflows for new and existing ImageNow processes.
• Work on ImageNow eForms, import Agent, output Agent, User Administration and Reporting.
• Created integration of ImageNow system with PeopleSoft, Mainframe, Sales force and FACETS systems as needed using Integration Broker and Web services call.
• Worked on Structured Non-Structured messages using IB, CI, App packages, AE transformations to addressing integration requirements. Configured maintained Gateway properties, Listening Target Connectors, Nodes, Transactions, Relationships. Used Integration Point Wizard tuned system performance.
• Configured and Setup Integration Broker for retrieving real time data from the legacy/source systems
• Integrated Direct Connect Supplier for 8.9 external vendor eProcurement website
• Supported issues in Integration using IB/CI/WSDL between FSCM and HCM systems.
• Handled both synchronous and Asynchronous integrations with multiple Third-Party systems using Web Services WSDL
• Created inbound process for external vendor Invoice processing
• 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.
• 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, AE Program to get data from the legacy system to people soft tables.

Environment: PeopleSoft Financials 8.9, ImageNow 6.6, PeopleTools 8.48, Oracle 11g, SQL Server 2008, Integration Broker, XML Publisher

Confidential

PeopleSoft

My responsibilities

• Production fixes and release works.- Includes on call support, maintaining response and resolution time.
• Test environment preparation for Development, Quality Assurance and User Acceptance Testing. This requires understanding the core issues and recreating them for testing using SQL's
• PeopleSoft User security maintenance - Granting and revoking access to peoplesoft system as per the request from Users on approval from their Managers
• To work on Peoplesoft Query Manager to create / edit peoplesoft queries as per the user requirements and grant them the correct access
• To work on SQL's and other peoplecode for new and existing programs.
• Rule and Non rule package migration
• Retrofitting of customization after Maintenance Pack is applied to the existing Global Payroll system
• To ensure the smooth running of batch jobs, all Inbound and Outbound processes through Autosys tool.
• Documentation of User requirements, Unit Testing and sign off.
• Validating the Technical Design Specification from a Functional standpoint.
• Perform end-user training for the Enterprise Portal.
• Peer review for the Technical Deliverables like design and code
• Performance tuning on the existing programs.
• User maintenance in the existing OBI reporting system
• Migration of OBI repositories between Development / Quality Assurance / User Acceptance Testing and Production environments
• Creation and maintenance of Application Information document AID for all newly implemented system.
• To ensure the smooth running of Data Conversion program if required when a new system is implemented.
• Experienced in System Development Life Cycle phases such as Requirements gathering, Documentation, Business System Analysis, Design, Development, Implementation, Integration, Testing, Quality Assurance, Production Support
• Prepare status reports, presentations and proposals, proof of concepts, Case studies
• Manage deliverables, expectations and relationship with the Senior Management by proper communication, customer satisfaction, tracking milestones, adding value and balanced approach
• Improve processes, tools, quality for user adoption and delivered results 50 faster and efficiently to make better decisions
• Supported People Soft patch and Maintenance pack apply through out the year
• Identified recurring issues, conduct root cause analysis and provided metrics as well

Confidential

• Documented and prioritized request for Change Management and Version control
• Coordinated processes for Change Management , Release Management migrations
• Migration of release objects and Post production release activities using STAT tool.
• Creation and Maintenance of User profiles in STAT
• Trainings for new Team members on how to use STAT for migration

As PeopleSoft Security Admin

• Worked on assigning appropriate roles and applicable User Preference and row level security for User Accounts
• Resolved security issues reported after implementation
• Coordinated and worked with PeopleSoft Administrator and Database Administrator to resolve issues
• Implement security for 2 major regions having employee strength of 24,000 and 2800
• Integrated OBI security with PeopleSoft security to have single sign on process

In a Lead Role

• Mentored team members, shared knowledge and performed Appraisals
• Motivated Team members and provide regular feedback
• Resolve conflicts within work stream
• Managed day to day activities
• Led projects in Onsite / Offshore model for the client
• Planned and implemented several production releases which include scoping, assigning to individual developers, getting status of fix through regular team meetings, planed for QA and UAT testing and migration to production environment.
• Conducted regular Team meetings with the Team to discuss on concerns / issues and release work
• Conducted regular Team meetings with Client Management to provide updates on issues reported, release updates and other issues
• Conducted regular meetings with Payroll processing team to discuss on issues reported for the week and their resolution status
• Assisted management with Auditing processes to achieve level A
• Planned and implemented KT sessions for the new joiners

Environment: PeopleSoft Global Payroll 9.0, Peopletools 8.48, SQR, nVision, Oracle 10.1, Sybase , Oracle Business Intelligence 10g R3, STAT 5.5

Confidential

PrPeopleSoft Project Costing

• Leading the offshore team responsible for PeopleSoft Project Costing Implementation along with the Post Production Support.
• Ensuring quality deliverables and support of the system.
• Managing the team and keeping it motivated.
• Mentoring new team members.
• Conducting meeting with Super Users to discuss pending issues.

Environment: PeopleSoft Global Payroll 9.0, PeopleTools 8.47, SQR, Oracle 10.1, Sybase Team Size : 10

Confidential

PeopleSoft

• Creation of the Data Migration Tool. This consists of reading data from flat files and loading it into 22 components using Application engine programs and Component Interfaces.
• Creation of Set Up data for each client
• Created forms in Microsoft Excel using macros to validate the 22 component values. This is used for the initial validation of files. Component interface is having more validations based on the underlying component.
• To ensure smooth running of all the Peoplesoft jobs
• Created 22 Component Interfaces for loading data to the Peoplesoft 8.48 system
• Created Application engine programs to load data from flat file to Staging tables and from Staging tables to Master tables.
• Training and support for the end users on the Tool
• Created SQR's for the Data Migration Report
• Creation of User Manual document and all other supporting documents
• Supported the newly developed system for few months to ensure smooth running to process.

Environment: PeopleSoft CRM , Peopletools 8.47,Integration Broker, SQR, Oracle, Microsoft Excel 2000 Team Size : 32

Confidential

PeopleSoft HRMS Support

• Running and monitoring batch jobs
• Maintain peoplesoft security Working on User profiles, Department changes and all access related issues. There will be request from users by email, SRS. My task involves to make sure there is proper approval in place and to grant required access.
• Support and enhancements of existing SQR's, Component Interfaces and Application engine programs. HR data is entered in external system. There are systems developed to read this data from external source and to load it to the PeopleSoft system.
• Calculation of Payroll in external systems and posting of same to the Peoplesoft system. Payroll calculation was made in several external systems. I was supporting that system as well. Majority of system was developed in MS Access and Excel files. I was supporting MS Access programming and Excel macro's.
• Creation of new systems for individual group bonus. Calculation part of bonus system was developed in MS Access as per user's request. There was Application Engine program created for reading those data and posting to PeopleSoft system
• Creation and maintenance of intranet website. Other than MS Access system, lot of users were using their internal websites for posting attendance. I was supporting all those internal websites for new requirements as well as modification of existing websites.
• Creation of reports in Excel as per user requirements.
• Support for smooth running of all Report servers / tools.

Environment: PeopleSoft Global Payroll, Peopletools 8.46, SQR, Oracle, ASP, Java Script, VB Script, SQL, IIS, Microsoft Excel 2000, Microsoft Access 2004