Erp Analyst Resume Profile
SUMMARY
- Key member in a project implementation for a leading resorts company in Florida USD 640,000
- Seasoned HCM consultant with over 10 years of experience with ERP-PeopleSoft suite and BI tools
- Instrumental in PeopleSoft functional solution design, scope, fit gap analysis, requirements gathering, quality management, performance improvement, process reengineering, change management, global implementations, and production support.
- Expertise in modules North American Payroll, PeopleSoft Time and Labor, Recruiting TAM and CG , Global Payroll, Security Configuration, Workforce Administration and Self Service.
- Certified in North American Payroll FPC by American Payroll Association.
- Showcased product features and vendor capabilities to client teams pre-implementation phase
- Led a 6 person team for a 7 month implementation and eventual roll out to other properties in Bahamas, Paris and South Africa.
- HR Process redesign with recruiter teams and payroll members
- Post graduate diploma in Management from one of India's top management schools.
- Key member in 3 successful implementations, 1 upgrade and 3 production support projects.
- Involved in all aspects of ERP implementations From RFP response and project scoping to areas such as presales and user training.
- Strong experience in designing user interfaces and data migration programs through use of Application Engine, SQR, Component Interface and File Layouts.
- Highly proficient in analysis and resolution of technical and functional issues associated with delivered PeopleSoft programs.
- Clientele include 3 Fortune 500 and S P 500 companies, a leading investment bank and an international resorts provider.
TECHNICAL SKILLS
ERP Suites | PeopleSoft HCM, JD Edwards |
Tools used | Cognos Report Studio, MS Office suite |
PeopleTools | Peopletools 8.47x, 8.x and 7.5, Object Based Peoplecode, Peoplecode ,SQL/SQR for PeopleSoft, Crystal Reports for PeopleSoft, Process Scheduler, PeopleSoft HRMS, PeopleSoft Portals, Application Engine, Application Messaging, HTML ACCESS, WebClient, iClient |
Technologies | Integration Broker, App Messaging, Component Interface, Business Interlinks |
Operating Systems | Windows 3.1, Windows NT, Windows 95, Windows 2000, UNIX Sun Solaris, HP AIX |
Database | Oracle 10g, 9i, 8i, 8, 7 , SQL Server, SQL Anywhere |
Modules | Core HCM, Workforce Administration, NA Payroll, Global Payroll, TAM and CG, Time and Labor, Security Administration |
PROFESSIONAL EXPERIENCE
Confidential
Responsibilities
- ERP Analyst with expertise in PeopleSoft NA Payroll and Time and Labor modules
- Upgrade workshop Analysis of all pain points, customizations to redesign for 9.2
- Involved in database and platform migration across vendors.
- Performance tuning for Payroll Calculation SQL tuning of Payroll jobs
- Automation of all payroll interfaces custom DDP and Check print processes.
- Work on issues/enhancements with current processes in CPS
- Compensation Work on redesign of step progression and compensation rules for teachers
- COBOL analysis Prepare flow documents for delivered T L pay sheet load program
- Bolt on customization for viewing teacher evaluation ratings in PeopleSoft
- Analyze payroll issues Look at incorporating best practices for the customer
- Integration of PeopleSoft HR with Taleo for hiring of teachers across CPS Schools
- Application support and maintenance Job Scheduling, Level 2 support for critical system issues on a rotation basis.
- Benefits Administration Modify and enhance interfaces for leave and short term disability.
Confidential
Responsibilities
- Technical consultant for PeopleSoft Recruiting TAM CG for the University of Connecticut
- Develop/Design custom pages, records and peoplecode based on user requirements.
- Create custom PS queries, SQL statements and reports for business users.
- Work on issues/enhancements with approvals and workflow Application packages related peoplecode.
- PeopleSoft Branding Work on enhancing UConn look and feel on the PeopleSoft Application Work on stylesheets, HTML and modifying branding app packages.
- Custom solution of developing online reports initiated by javascript and peoplecode.
- Use PeopleSoft connected queries to build complex reports online with XML publisher.
- Created a custom interview evaluation component for a 360 degree view on interview evaluations for all candidates for a specific job opening.
- Student Administration Created SQR reports for student billing and invoice fees report.
- Work on enhancements to interview approval process workflow for UConn.
Confidential
Responsibilities
- Technical analyst for PeopleSoft Time and Labor for Hartford Insurance
- Analyze the PeopleSoft Time Admin application engine program and prepare support documentation
- Create custom PS queries, SQL statements and reports for operations team in case of ongoing support and for time load process
- Prepare Business Requirements Document for new enhancements highlighting design approach and impacts on existing system.
- Review test cases and unit test plans for application testing by vendor teams
- Technical and functional analysis for support issues and document resolutions and fixes.
- Analyze custom peoplecode and test various scenarios for online transactions. Suggest peoplecode modifications as part of fixes or enhancements.
- Analyze SQR reports for errors in employee T L data or report lay out issues.
- Create new SQR Reports for T L reporting requirements.
- Prepare technical design documents for new AWE processes including details for cross reference record, App classes required, Approval process involved, steps and path criteria.
- Customize delivered TL delegation functionality to include proxy id and manager id.
- Test workflow modifications in AWE and approval processes as well as email configuration.
- Built test data in the database to via PeopleSoft panels/pages to test different scenarios.
- Created technical and functional specifications for enhancements from The Hartford.
- Created test scripts for system and integration testing for new interfaces.
- Use Integration Broker, Component Interface and PeopleSoft Rapid Time Sheet Entry page for integration with TCD and swipe devices.
Confidential
Consulting
- Structuring PeopleSoft solution approaches, business process reengineering and understanding of business problems.
- Retrofit of core HR SQR programs for 9.1 upgrade.
- Redesign of existing people code customizations.
- Tune SQR programs and Crystal Reports to redesign long running queries and enhance run performance.
- Draft RFP responses for client proposals.
- Modify application engine programs used for data migration. Incorporate custom logic into the data migration programs as per customer requests.
- Perform package evaluation, prepare compliance statements and roll out plans for proposed solution.
- Perform resource and effort estimations for new developments.
- Modify and design new PeopleSoft queries and Crystal Reports.
- Integration Broker Examine channel messages, debug IB issues related to 3rd party integration.
- Analyze PeopleSoft 8.8 security changes performed by Boeing and re-design the same application engine programs in PeopleSoft 9.1
- Redesign 8.8 workflow notifications and map them to delivered 9.1 Approval processes and drop existing customizations.
Confidential
Technology Management
- Manage software products at the reconciliations division at ICICI.
- Showcase product features to various operations divisions and increase usage across departments.
- Comparative research of industry products to identify areas of improvement/pain points.
Vendor Management
- Prepare weekly and monthly status reports resource utilization, change requests in progress for business and technology forums.
- Analyze change requests, prioritize and allocate among vendor resources.
- Track deployment and evaluation of change requests from scoping and feasibility to final closure.
- Suggest architectural improvements on system/database design so as to better handle future business requirements.
- Resource budgeting for each financial year based on anticipatory requirements.
Confidential
Responsibilities Activities as PeopleSoft Consultant:
- Prepare project plan and effort estimations.
- Use SQL/PL SQL tools for data migration of core HR data from PeopleSoft to IDM
- Involved in study of client business processes, end-user training, identifying critical gaps and design of solutions/workarounds.
- Set quality and process guidelines, communication protocols and configuration management as part of HCM ERP implementation for AIG corporate.
- Requirements gathering and preparation of file templates.
- IB and Web services to integrate AIG PeopleSoft site to their Java IDM application
- Create detailed design documents for the SQR interfaces.
- Code and test plan reviews.
- End user training for teams in Hong Kong, China and Nan Shan.
- Data integration Using Java to CI templates to move date from custom web application to PeopleSoft.
- Employee Self-Service and Manager Self-Service Debug issues related to set-up, Reports Manager, Manager unable to access their reportees.
- Peoplecode fixes for online page enhancements
- Prepare training material for junior team members on various PeopleTools Integration Broker, Component Interface, Application Engine, PeopleCode and SQR
- Conducted PeopleSoft Upgrade Workshop Perform Tools Upgrade, Understanding Compare Reports and Installation of Patches and Fixes.
Client Engagement
- Coordinated among project managers at APAC region to ensure parallel execution of interfaces.
- Spearheaded a solution accelerators team to develop new ideas in speeding implementation.
- Presented recommendations for product enhancements and designed solutions/workarounds.
- Achieved 40 process improvement and savings of USD 800,000 for the client.
- Solution architect for new projects in PeopleSoft for AIG