SUMMARY:

• Experienced IT Analyst with expertise in designing, developing, deploying and supporting PeopleSoft HRMS (Core HR, Payroll, Benefits Administration, Time & Labor and Base Benefit), PeopleSoft CRM( BORM and Marketing).Proficient in development projects using Agile development methodologies. Masters in Computer Applications, with around 8 years of industry experience working with stellar organizations like Confidential, Confidential ( Confidential ) and Confidential .
• Developing HR Tools in Peoplesoft
• Troubleshooting Issues
• Gap Analysis
• Creating/Execution of Test Scripts
• Requirement Gathering
• & Supporting End Users
• Functional & Technical Documentation
• Team Building & Leadership
• UAT

TECHNICAL SKILLS:

ERP Packages: PeopleSoft HRMS 8.8, PeopleSoft HRMS 9.1, PeopleSoft CRM 8.8, PeopleSoft FSCM 9.1

ERP Modules: Core HR, Self Service and MSS modules, Benefits, Workforce administration, NA Payroll, Time & Labor, Talent & Acquisition, Learning Management System, BORM and Marketing

Languages: Peoplecode, C, C++, SQL, PL/SQL

Databases: Oracle 9i, 10g, MS Access, SQL Server

Web Related: HTML, XML

Tools: People Tools (BI Publisher, Application Engine, Application Designer, SQR, People code, PS Query, Connected Query, Crystal reports, PeopleSoft Security, Data Mover, Integration Broker, File Layout), Excel, Inform, TOAD, MS Visio, VSS & CVS version control tool

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota

PeopleSoft Analyst

Responsibilities:

• Designed and implemented reporting solutions, which helped stakeholders to manage the business better.
• Produced routine, ad - hoc reports, to respond to immediate customer request using PS Queries, SQR and BI Publisher.
• Collected, analyzed, and interpreted human resources data, and advised managers on the readiness of personnel, in order to plan and utilize human resources more effectively.
• Troubleshooting and various production support demands.
• Defines and approves security roles to PeopleSoft Human Resources.
• Trained personnel and staff on new HR System; resolved complex questions related to its functionality.
• Created personalized database solutions, which simplified routine processing and reporting for stakeholders.
• Created and modified PeopleSoft objects (fields, records, pages, menu, components, PeopleCode, etc.) using Application Designer for user requirements.
• Created and customised SQR and Application Engine processess for Benefits and Payroll business users.
• Helped customers streamline workflow activities, and effectively manage human resource information.

Confidential

PeopleSoft Techno Functional

Responsibilities:

• Worked as a Techno-Functional Consultant Core HR, Benefits, NA Payroll, Workforce Administration and Time and Labor, Account Payable, Account Receivable, Purchase Order and General Ledger.
• Liaised betweenbusiness& technology to define and analyze system requests, gathered and communicatedbusinessrequirements.
• Designed and created many report solutions using SQR, PS Query and XML Publisher.
• Created and modified PeopleSoft objects (fields, records, pages, menu, components, PeopleCode, etc.) using Application Designer for user requirements.
• Developed an automated system to upload of HRMS transactions into PeopleSoft. For this an Application Engine program and Component Interface was used to insert data into PeopleSoft HRMS Tables.
• Primary and secondary support to PeopleSoft Finance and HRMS application.
• Developed, executed and documented test plans and test cases for unit test and end-to-end software integration.
• Created and automated the reports using People tools that reduced a one-time data pull of 40000 rows of
• Worked on workflow people code, and was involved in writing people code for business events.
• Experienced in documentation of Unit and Integration Test Plans.
• Ensured all required levels of approval (dependent upon data requested) are obtained prior to processing and follow all security protocols for ensuring data privacy is maintained.
• Implemented PeopleSoft Securities that includes Business unit Security, Object Definition Security, Chart field’s and row level security.
• Implemented processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources.
• Performed Data audits & designed audit queries within the HR Management System (HRMS).
• Actively participated in the design, implementation, and testing of new PeopleSoft application modules and version releases.
• Worked closely with Benefits/ Payroll Functional Team to develop custom reports.
• Developed strong relationships with end users to effectively troubleshoot problems & recommend good solutions.
• Created numerous materials, wiki pages as well trained users for various PeopleSoft HCM 8.9 modules.
• Corrected and built more than 60 new queries for business users, which got impacted in PS Bundle & tools update.
• Developed functional and technical solutions to new and existing HR business needs such as the creation of organizational charts in MS Visio via PeopleSoft functionality.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Leadanalystfor My Ameriprise Statement, Payroll Year End Project, Benefit Enrollment, completing requirements, creating queries, review of design documents, testing and production support.
• Developed the My Ameriprise Statement report for 15000 employees comprising their whole year Benefit/ Payroll/ Compensation and Job details.

Confidential

Developer/Techno Functional Consultant

Responsibilities:

• Worked as a Techno-Functional Consultant for PeopleSoft HCM modules.
• Worked on workflow people code, and was involved in writing people code for business events.
• Troubleshooting and various production support demands.
• Created and modified PeopleSoft objects (fields, records, pages, PeopleCode, etc.) using Application Designer.
• Wrote SQR programs to develop interfaces between PeopleSoft and external systems.
• Screen design, use case development, technical design specs, unit and acceptance testing and release coordination.
• Data migration, including back-end data validation (via SQL).
• Vendor to vendor coordination as well as customization specifications and test scripts.
• Gap Analysis to compare all elements of existing "as is" with desired "to be" processes based on customer feedback.
• Customized PeopleSoft pages, records, menus, components, and People Code for user requirements.
• Involved in developing and customizing the reports using the tools PS Query SQR, and XML Publisher reports.
• Involved in documentation of Unit and Integration Test Plans.

Confidential

Developer

Responsibilities:

• Worked as a member of CRM Application Maintenance and Support Team with responsibilities ranging from managing all environments (Production, test, development etc.), managing service levels, and development of Data fixes using SQL/ PL-SQL, managing workflow processes and reporting to client.
• Performed Unit and Functional Testing.
• Liaising with stakeholders, developers and test team throughout the lifecycle of the project.
• Designed and implemented reporting solutions, which helped stakeholders to manage the business better.
• Worked with cross-functional teams (BI, database) on daily execution of projects and initiatives and facilitated requirement gathering sessions with the business team and customers to collect the business standards, security and service level requirements.
• Performed Gap Analysis to compare all elements of existing "as is" with desired "to be" processes based on customer feedback.
• Extracted, discussed, and refined User and Business Process Requirements from SMEs. Also, co-authored User and Functional Requirements for the reports.
• Managing processes/interfaces, which produce messages for downstream systems via integration broker and app messaging. Created / customized interfaces for ORBIT (PS HR), GFS (SAP Finance) and Segmentation.
• Involved in Implementation and Customization of Components, Pages and Records related to Company, Private Client and Contacts. Involved in Design, Development and Customizations of regular CRM enhancements ranging from Application engine, Crystal reports, App Messaging etc.