Erp Analyst Iv-technical Lead. Resume
2.00/5 (Submit Your Rating)
Louisville, K
SUMMARY
- 15+ years of IT experience and 13 years of continuous experience in PeopleSoft Financials/SCM, CRM, Campus Solutions and HR.
- Technical lead for FIN/SCM and CRM Upgrades.
- Lead Developer in Campus Solutions.
- Strong skills in Technical and Functional Analysis, Design, Development, Implementation & Maintenance of PeopleSoft in Multi - Tier Environment using PeopleSoft 8.x/9.x.
- Experience in working with PeopleTools- Application Designer, Application Engine, Application Messaging, Application Packages, Integration Broker, File Parser, Population Selection, PeopleCode, Process Scheduler, SQR and Data Mover.
- Experience in PSQuery, Connected Query, XML Publisher
- Experience in Fit Gap Analysis, Current System Business Process, Process Flows, Security, Issues, Defects, Reports information and mapping to Future system with certain definitions like Gap, Adequate, In Adequate.
- Experience in creating Row level and Component level security by creating Permission lists and Roles.
- Experience inproviding Technical and Functional DesignSolutions, Business Rules, Data Requirements, Reports, Interfaces, Security Requirements, Conversion Requirements.
- Excellent proven Leadership skills acquired being a senior member and handling multiple tasks at work.
TECHNICAL SKILLS
- Peoplesoft Financials
- SCM, CS, CRM, HR
- Implementations
- Upgrades
- Maintenance
- Application Support
- ePro/Purchasing
- Strategic Sourcing
- Accounts Payable
- AR/Billing
- Asset Management/Inventory
- Commitment Control
- General Ledger
- Admissions
- Financial Aid
- Student Financials
- Student Records
- Campus CommunityCRM(9.2)
- Help DeskOLMHR(9.2)
- Payroll/Benefits
- Recruiting
- Time and Labor.
- Application Designer
- Integration Broker
- Component Interface
- Change Assistant
- Data Mover
- AWEProcess Scheduler
- Application Engine
- Activity Guide
- WorkCenterPUM
- Integration Broker
- Application Messaging
- File Parser
- Population Select
- Webservices
- ExcelToCI
- SOAP, REST
- BI Publisher
- PS Query
- Connected Queries
- Pivot Grids
PROFESSIONAL EXPERIENCE
Confidential
ERP Analyst IV-Technical lead.
Responsibilities:
- Lead Developer in Campus Solutions for applying Bundles and day to day Maintenance.
- Led the financial Application suite upgrade from 9.0 to 9.2 PUM 9, PeopleTools 8.50 to 8.54.07.
- Lead developer for implementing SciQuest for SCM PO/ePro.
- Streamlined the financial year end process for the Fiscal year 2006 and continuously monitored it for the next years.
- Led the financial Application suite upgrade from 8.9 to 9.0, PeopleTools 8.47 to 8.48 accompanied by database platform change from DB2 to Oracle.
- Led HCM Tax updates projects.
- Led the Strategic sourcing module implementation, created a custom workflow from the scratch for this implementation.
- Worked as lead developer in implementing and upgrading CRM HelpDesk, OLM modules.
- Designed and developed a process which maintains the Integration Broker activities like Pausing and Un Pausing service operation, sending alerts for failures.
- Integrated the payroll checks and EFTs of HR to Financials which eliminated the manual reconciliation.
- Well experienced in integrating PeopleSoft with third party applications like SciQuest, SLATE, PayPoint, ExpertNet as SOAP based Web services.
- Extensively worked on integrating CS to FIN, HCM to FIN, CS to CRM applications using Integration broker Synchronous and Asynchronous messages.
- Customized Admissions web services(AAWS) to integrate to CRM, HCM, FSCM modules from Campus Solutions.
- Created bolt on Applications, like Repackaging, IB Maintenance, FASTER load for Financial Aid in Campus Solutions.
- Configure row level security for new business units.
- Extensively worked on customizing App Engines, Component Interfaces, Queries, SQRs, Pages, to meet the day to day requirements and enhancements.
- Customized delivered and custom SQLs for better performance in every upgrade.
- Integrated Online Admissions Application which integrates with PeopleSoft Campus Solutions using AAWS (Admissions Application Web Service)
- Implemented an affiliation (CARE), with the Activity guide and Work Center to streamline the application review process for administrative users.
- CS to CRM: Test Scores, Application data.
- Bio Demo, Job Information from HR to CS, FIN, CRM.
- Affiliations from CS to HR and CRM
- Financial SciQuest Integration.
- Loaded incoming FASTER data into the FASTER suspense tables using File Parser.
- Used ExceltoCI for loading Asset Management data.WorkFlow:
- Implemented the Custom Workflow for Quick Invoice Approval using AWE framework.
- Designed and Developed the Requisition Work Flow
- Designed the Travel and Expenses W/F.Reporting (SQR/XMLP/nVisions)
- Modified and Cloned POPO05.sqr
- Created the BI Publisher report on Billing Invoices with Dynamic Images for CS Student Financials.
- Created the BI Publisher report Collection reports for CS Student Financials.
- Other Miscellaneous reports using SQRs/XMLP.Fluid
- Modified the Tile appearance and adjusted the Group boxes for the Student Self Service.
- Managed the fluid display with CSS (Cascaded Style Sheets).
- Configured the search pages in Fluid User Interface related to Self Service.Leadership
- Worked closely with functional analysts to meet the day to demands of the University, which includes customizing the delivered objects and creating new custom objects.
- First point of contact for junior developers, worked with them if they are behind deadline.Papers Submitted
- Building seamless applications with Activity Guides, Work Centers, Affiliations and AAWS
- Lessons learnt from PeopleSoft upgrade to 8.54/9.2 PUM 9 from 8.50/9.1
- AAWS Orchestration on Service Bus and Integration to CRM OLM
- Capturing Admission Application Web Service (AAWS) Errors
- Integration Broker Maintenance(streamlined the IB maintenance with a custom bolt on Process )
Confidential, MN
Responsibilities:
- Developed customized Procurement Card (PCard) application which is complete replacement of delivered PCard Application. Using this Application user can request, cancel PCard and he can change the parameters (Limit, Account, Dept, ShiptoID) of PCard.
- Designed workflow for three Approvals related to PCard, request will sit in approver’s worklist and also sends an email with the link directing to approval page.
- Designed and Developed inbound and outbound interfaces with GE Bank sending and receiving transactions related to PCard.
- Designed and Developed reports related to PCard (Invalid PCardHolder/Manager Report, Department Change report, Monthly Manager report)
- Converted the existing PCard users from Lotus notes into PeopleSoft.
- Configured security for PCard by creating roles for Approver, Reviewer, Tax and administrator.
- Working Closely with I2 and Ariba People in Solving the Production issues related to PeopleSoft SCM and Financials modules Viz ePro, Inventory, Purchasing
- Tracking, Documenting and resolving the Issues in well-defined pattern.
- Worked on Integrating the PeopleSoft modules(ePro, Inventory, Purchasing) with i2 by accepting XML document using Integration Broker.
Confidential, FL
Implementation of PeopleSoft Financials
Responsibilities:
- Converted the Voucher Information from Infinium (Legacy System) for duplicate invoice checking.
- Enhanced the delivered the VENDOR conversion program(VNDR IMPORT) to meet the Business requirements.
- Converted the 1099 VENDOR Balances Information
- Converted the Financial and Physical Asset Information into Staging tables and then into AM tables.
- Developed and also given Production Support for GL Hyperion through which the Wackenhut sends the monthly General Ledger data to Group 4, the parent company of Wackenhut
- Developed an Interface to read the unprocessed invoice information from a 3rd part Systems (Martin Lamar, Air Borne, GELCO)
- Developed a Custom Process to get the default Chart of Accounts based on whether the requisition type is Billable or Non-billable in eProcurement.
- Performing customizations in eProcurement to transparently include inventory items in search category and also by Item ID that’s already in stock.
- Customized the POS1 Crystal Report for Positive pay.
- Customized fineft23.sqc, which is used by fin2025 sqr for ACH payments.
- Customized CHECK3 Crystal for AP checks according to the Business requirement and made the signature and MICR fonts to print on the check by passing the exact control characters.
- Customized the PAY003 (Payroll Checks) Pay Advice(DDP003.sqr) according to the business requirement and made the Signature, LOGOS and MICR fonts to print on it.
- Developed a custom batch program that will read the last confirmed payroll and advance 80% of net pay using an advance pay earnings code.
- Developed a Custom program where the Project fields(Project BU, Activity ID, Source Type, Category, Sub-Category) to automatically default onto eProcurement Requisistion and onto the Voucher when entered online
- Used Integration Broker to publish the Vendor information form PS Financials to PS HRMS
- Developed a Custom program that makes the Asset Update process needs to be driven by department. By which we can ensure that the departments are not updating incorrect assets with in their departments.
- Developed SQR Reports in AP (Checks by Dept, TAX Report) and AM(Asset Listing Report, Weapons Report)
- Involved in creating PS/nVision layouts & Report request for Income Statement Report,
- Developed and customized Run Control Panels, Components, Menus and Records using People Tools like Application Designer, Application Engine.
Confidential, Louisville,K
Implementation of PeopleSoft Financials
Responsibilities:
- Worked closely with Functional team in analyzing, fixing and troubleshooting the problems in Design and Development.
- Involved in developing Interfaces, Reports, Conversions and Enhancements.
- Responsible for Evaluating PeopleSoft Enterprise Portal 8.4 with Application Bundle 7.*
- Involved in customizing the Portal Interface using predefined template HTML objects, predefined homepage HTML objects, template pagelets and portal Headers.
- Designed and Developed the Spec to extract data from the Flat file, which contains the GEAC transactions from the Payroll Wage Attachment system, and stages the data in the AP staging tables.
- Involved in conversion of over one billion vouchers from Legacy to PeopleSoft using AppEngine in AP
- Developed custom SQR reports to generate the invoice out of recoverable voucher and sent it to Billing and then to AR.
- Written a SQR report which shows stores that have on hand inventory quantities outside an allowable tolerance for the period and the tolerances differ by brands.
- Written an APP Engine interface which produces text files that contain inventory confirmation or inventory error email messages.
- Developed a Component interface for VCHR QUICK PNL and VCHR EXPRESS Components to load the data from any flat file or user input using a Excel to CI Tool.
- Designed and Developed the Spec for the Interface that sends check information for Client Vendors and Prime source (Legacy Systems) using SQR in AP
- Designed and Developed an Enhancement Spec that will read the payment information from PeopleSoft AP Payment tables for Garnishment Invoices and send it to Payroll System.
- Designed and Developed the Spec for the Interface that sends check information for Client Vendors and Prime source (Legacy Systems) using SQR in AP
- Designed and Developed an Enhancement Spec that will read the payment information from PeopleSoft AP Payment tables for Garnishment Invoices and send it to Payroll System.
- Performed data mapping by analyzing the existing system.
- Developed queries to run through Query Manager for report reconciliation using PS Query.
- Developed unit test plans for GL, AP, AR and Billing Modules.
Junior Linux Administrator
Confidential
Responsibilities:
- Extensively worked on building new Linux servers/workstations, installations, migrations and troubleshooting the hardware and software issues.
- Developed RPM packages.
- Used Legato Networker for database backup on to Digital Linear Tapes.
- Simulated high performance network of 50 clients in a LAN based environment. Also responsible for ongoing administration and maintenance of the network.
- Installed and Configured the Windows NT Servers 4.0 & Windows NT Workstations Networked together as Primary Domain Controller, Backup Domain Controller and Client. Establishing Trust Relationship between different Domains and maintained System Security.
- Configured SAMBA for accessing NT drives on Linux BOX. Installing Patches and Packages.
- Written shell scripts for the optimal network performance and incorporating scripts onto all machines in the network.
- Configured NFS and Automounting to serve home directories and other application/tools like to the users in the network.