A highly skilled and well versed accomplished IT professional with over 17 years of experience in the Enterprise Resources Planning in the Financials and Human Resource systems. Demonstrated expertise in planning, coordinating, leading, designing, developing, and evaluating the effectiveness of systems, infrastructure and staffing required to meet projects' needs. Results-oriented with the ability to set priorities, estimate workload, provide evaluation of projects, coordinate multiple projects and teams simultaneously, and effectively control quality, monitor progress, and customer satisfaction.
Quality Control and Process Improvement
Business Process Analysis, Reengineering, and Gap Analysis
Data Conversion Analysis, Validation and Loading
Post Implementation Support and Maintenance
PSFT HRMS 7.0 - 9.2 - Human Resources, Payroll, Base Benefits, Benefits Admin, Employee/Manager Self-Service, Time and Labor, Position Management, Personnel Action Request (PAR) Processing
PSFT FIN 7.0 - 9.2 - Accounts Payable, Purchasing, General Ledger, Asset Mgmt., Commitment Control, Accounts Receivable
PSFT FSCM 8.8 - Order Management, Billing, Inventory
PeopleSoft (7x to 9.2),
PeopleSoft DeveloperJul 2015 to Current Maven Pallet LLC － Washington, DC
Provide on-going operations and maintenance support for the PeopleSoft HCM 9.1 including Core HR, PAR Processing, Employee Self-Service, Payroll, Position Management, Recruiting, and Benefits as part of the Production Support team.
Independently design and develop a complex technical enhancement, Personal Service Contract (PSC), which entail processing positions, hiring, job data, and workflow approval.
Clone the PeopleSoft delivered Federal Job and PAR processing by utilizing Application Designer, PeopleTools, PeopleCode, BI/XML Publisher, Route Control, PS Queries and PS Security.
Analyze and collaborate with the functional team to gain an understanding of the ambiguous functional requirements.
Build test data and unit test all functional and technical requirements on the enhancement and document test results.
Carefully evaluate the impact of enhancements to various upstream and downstream integration points.
Follow migration standards, including any required installation documentation.
Ensure all codes, development and technical solutions aligns with all development standards and functional design specification.
Build a new benefit page to capture the notice of FEHB eligibility letter of benefit provided to employees.
Utilized Application Engine and File Layout to develop the FEHB 2809 Health Benefits Elections and 2810 Notice of Change Heavy use of PeopleCode with Application Engine to build the FEHB logic into the outbound interface process and developed new fields, records, page, component and menu.
PeopleSoft O&M ConsultantJan 2015 to May 2015 ARK Solutions, Inc － Washington, DC
Provided on-going operations and maintenance support for PeopleSoft Federal Financials 8.9 including Receivables, Purchasing, Accounts Payable, General Ledger and Commitment Control.
Performed accounting reconciliation of purchasing and vouchers for budget years, 2014 and 2015, from the initial budgeting and as it progressed from pre-encumbrance to encumbrance and finally to expenses.
Reviewed unit test scripts and executes test scripts by the deadlines.
Modified PeopleSoft delivered Accounts Payable and Receivable Cash Receipts Process to force entry of certain ChartFields.
Modified PeopleSoft Queries and Crystal Reports for various accounts payable and purchasing reports.
PeopleSoft Technical LeadSep 2014 to Nov 2014 BTRG － Toronto, CA
Provided lead technical expertise on the re-implementation of PeopleSoft Financials 9.2 from PeopleSoft 8.9 via managing and leading a team of four technical developers to support all aspect of technology and create custom technical solutions for the client.
Performed technical analysis on the client's "to-be" business processes and communicated solutions and options to the problems.
Estimated the level of effort for the high volume of reports, interfaces, conversions, enhancements, workflows, and forms and provided a high level overview for upper management to aid in time and resource management.
Reviewed deliverables, collaborated with the Functional Lead on solutions, identified areas of risks and supported the functional team on technical issues during fit-gap analysis.
Designed custom enhancements, conversions and interfaces when delivered functionality was not sufficient to meet the client's business needs.
Prepared and delivered presentation to the project team on the Conversion Strategy and Plan.
Developed the Migration Strategy document detailing the migration process and alternatives of each technical solution for comparison.
Analyzed the activities relating to the conversion strategy and plan which led the development of the WBS tasks for the project plan.
Collaborated with appropriate client personnel and other project teams to organize and identify integration points, infrastructure needs, security needs, environments, resource needs and other technical protocol required.
PeopleSoft O&M ConsultantJun 2014 to Aug 2014 ARK Solutions, Inc. － Washington, DC
Provided on-going operations and maintenance support for PeopleSoft Financials 8.9 including Receivables, Purchasing, Accounts Payable, General Ledger and Commitment Control.
Performed system testing of the configuration changes related to the PeopleSoft Financials 8.9 Commitment Control implementation.
Extensively investigated, analyzed and replicated system issues related to the functional setup changes made as a result of the PeopleSoft Commitment Control implementation.
Thoroughly tested the PeopleSoft Alternate Account functionality by creating requisitions, purchase orders, vouchers and GL journal entries.
Built, unit tested and system tested all enhancements to ensure functionality and functional requirements were met.
Customized the nVision Budgetary Trial Balance to display details of the Budgetary Resources and Status of Budgetary Resources.
Modified the "All Accounts Rollup" Tree structure to allow budgetary tracking to drill down to the details based on the first two digits of the account structure and updated the Budget Definition for Allotment and Apportionment Revenue.
Troubleshot issues encountered with running PeopleSoft Budget Journal Post, Journal Generator, and Budget Check and Exceptions.
PeopleSoft Technical LeadMar 2013 to May 2013 CSC － Albany, NY
Managed the PeopleSoft Financials 9.1 technical aspects, provided technical strategic direction, and collaborated with the management team to determine the scope, identify technical activities and risks, and assisted with the overall project plan.
For the NY State Health's Payment Collection Process led a seven member team that implemented the PeopleSoft Financials 9.1 system.
Partnered with infrastructure lead to manage environments for the project team and supported the needs of various project teams.
Collaborated with appropriate external teams to organize and identify integration points, infrastructure, security, and other technical protocols required.
Controlled quality by setting expectations for the development team, delegated tasks, guided and coached developers, reviewed deliverables, identified areas of risks and established risk mitigation plans.
Architectures were devised for each environment including the migration process, and development standards.
Prepared and delivered presentation to the client and the NY insurance community on the EDI 820 Payment Process.
Principal ConsultantApr 2012 to Jan 2013 EDC Consulting － McLean, VA
Part of the development team on the IPPS-A project to configure PeopleSoft HRMS 9.1 using Data Mover and SQL scripts to load foundation, Person Model and JPM data to support the functional team.
Performed comparison analysis of various PeopleSoft tools (BI Publisher, SQR, Component Interface, Application Engine, Crystal Reports), formulated alternative solutions, and selected the best solution for the complex army SRB report based on factors of speed, volume, efficiency, batch run, maintainability and the source of the report.
Designed complex custom views for each section of the army SRB report with a volume of 1.5 million soldiers.
Reviewed and provided input on the Software Development Standards and Software Development Plan.
PeopleSoft DeveloperFeb 2011 to Sep 2014 My Incite LLC － Falls Church, VA
For the PeopleSoft Financials 8.9 to 9.2 Upgrade in PeopleTools 8.53, planned, executed, researched and reviewed PeopleSoft objects and codes for business requirements and identified the gap between the systems.
Created a comparison and critic of the technical approach, thus, retaining the customizations.
Retrofitted customizations for Purchasing, Accounts Payable, General Ledger, and Supplier Procurement (sPro) and perform unit and integration test with sPro.
Designed and developed Purchase Order Dispatch by modifying the delivered XML/BI Publisher program using PeopleCode, Application Package, Application Engine, File Layout, and SQR.
As a Tier 3 Production Support team, supported and maintained the PeopleSoft Financials 9.0 systems related to Asset Management, Purchasing, Receivables, Inventory, Portal, Custom Modules Transportation, Shipping, Expendables, WMS and DPM.
Extensively investigated, analyzed and replicated issues seeking to identify root causes and improve efficiency.
Designed, developed, and implemented solutions after careful evaluation of the impact analysis to various integration points.
Collaborated and interacted with the functional team to collect more detail if needed and provided resolutions.
Developed and strengthened working relationships with the IT and financial departments, business owners, and upper management.
Provided expertise on the PeopleSoft Financials, HCM 8.9 and the custom ART systems.
Troubleshot tickets daily and determined whether it was a data, functional configuration, technical setup, or coding error.
Established and implemented solutions after identifying root causes to prevent reoccurrence and increased productivity by 10%.
Performed security control and risk assessment on the PeopleSoft Financials 8.43 system and provided recommendations to the Director of Finance and the CFO.
Constructed User Guide and Configuration Docs, for AP and Billing based on gap analysis meetings held with key personnel.
Developed a project plan, managed work efforts and project schedules, and provided strategic direction relating to PeopleSoft Financials 8.43 to upper-management.
Acted as a Benefits Administrator, serving as a liaison between the business owner and the technical team to communicate and translate business rules and requirement to the developers.
Proactively monitored data and operational integrity associated with PeopleSoft HRMS 9.1 Base Benefits and Benefits Administration.
Implemented process change management and improved productivity through automation of the benefits vendors' interface.
On a daily basis, articulated with business owners relating to benefits eligibility, dependents, beneficiary discrepancies, enrollments, vendors' interfaces, benefits exception request, life event, and the Benefits Administration COBOL process.
Devised detailed test scenarios to ensure quality is not compromise via thorough testing, tracking of defects, and confirming developers understand the business rules and requirements.
Senior Specialist ConsultantAug 2010 to Feb 2011 Deloitte LLP － Rosslyn, VA
Technical Lead for the proposal work to build solutions addressing the technical issues encountered.
Wrote and drafted various technical sections of the PeopleSoft bid proposals Technical Developer that provided functional and technical production support for PeopleSoft Financials 9.0 for the Commitment Control, General Ledger, Purchasing, Requisition, Accounts Payable, Asset Management and Accounts Receivables modules.
Developed an Application Engine program to load a delimited file which populated Commitment Control security data and rules.
Generated a gap analysis workbook by holding meetings with the clients.
Created, implemented and executed enhancements and code fixes to resolve issue utilizing Stat® for migration.
AssociateMar 2007 to Jul 2010 Booz Allen Hamilton － McLean, VA
Technical Project Manager on three simultaneous projects to manage all technical effort, customer relations, project initiating, scope definition, identifying risks, allocating and overseeing developers' tasks, manage environments for unit, quality control, and UAT testing while performing development work, coordinating and migrating work effort, and assisting with project schedules and plans.
Led the PeopleSoft HRMS Bundle upgrade from 8.8 to 8.9 for the Benefits and Self-Service area and retrofitted the customizations.
Updated delivered COBOL programs that reduced the benefits administration process run-time from 30 hours to 5 hours.
Participated and facilitated in functional meetings with business owners, by assisting in project planning to forecast the level of effort for the technical tasks (WBS), perform impact analysis, and aided in the determination of yes/no go decision for the e-Benefits implementation, Open Enrollment '10, EDI 834 HIPAA compliance, Total Rewards Statement, and Talent Management Profile.
Managed the delivery of an automated tool that aided the HR and leadership team in evaluating talent by assessing the technical solutions based on requirements, reviewing the quality of the codes, and identifying any show stopper to monitor and control the project.
Presented a plan for the development and implementation of the Benefit vendors' interfaces regulated by the Federal Government to the 834 HIPAA layouts.
Served as a Technical Expert on PeopleSoft Core HR, Benefits, Benefits Administration, Employee Self-Service, and Payroll modules, providing production support that entails gathering business requirement, data analysis to determine root causes, writing scripts for data clean-up, providing complex queries to the users' community, and modifying various SQR, Application Engine, Component Interface, COBOL and UNIX programs with FTP, PGP encryption, and SSL capabilities.
Developed, implemented and rolled-out a new functionality of the Total Reward Statement in PeopleSoft with the vendor to allow an employee to view the total benefit package the firm provides.
Increased productivity by writing and presenting the solutions to archive Payroll data for the Payroll processing.
Participated in the PeopleSoft HRMS 8.8 Open Enrollment '09 and '10 implementation and configured e-Benefits enrollment text and geographic location code for the Benefits Administration process utilizing Application Designer, PeopleCode, Application Engine, SQR, and COBOL.
For the PeopleSoft HRMS 8.8 Open Enrollment '08, performed a serious revamp to the Benefits outbound and inbound SQR interface to improve flexibility, efficiency, and maintainability that require staging of test data for unit testing and designing new PeopleSoft objects.
Managing ConsultantMar 2007 to May 2007 IBM － Fairfax, VA
Provided functional and technical production support for the PeopleSoft Financials 8.9 system on the General Ledger, Purchasing, Requisition, Accounts Payable, Asset Management, and Combo Edit modules using Application Designer.
Modified the PeopleSoft delivered Accounts Payable module and Journal Approval Workflow Process to allow four levels of approval.
Searched for reasons behind PO budget errors and compiled queries for data clean up and correct program codes.
Reconciled vouchers and purchase order discrepancies that caused negative balance.
Created detailed test scripts for Unit, UAT, and systems integration testing of custom and modified PeopleSoft functionality.
Principal ConsultantDec 2005 to Dec 2006 SRA International － Vienna, VA
As a Senior Technical Consultant, maintained data and operational integrity of PeopleSoft Financials 8.9 associated with the Budgeting, Commitment Control, Accounts Payable, Purchasing, and Entry Event area focusing on monitoring negative balances, ledgers discrepancies, budget errors, and invalid chart fields.
Conducted daily assurance and nightly batch processing through analysis of queries and reporting to identify root causes of negative amounts, ledgers that are out of sync based on the Chart Field attributes, and journals with mismatch amount.
Observed the process flows of Requisition to Purchasing to Accounts Payable to General Ledger which resulted in the reduction of data discrepancies.
Generated SQR reports to identify purchase order being reduced below the voucher amount and reversal vouchers not setup against the original purchase order caused by not checking the checkbox "Restore Encumbrance Flag".
Retrieved data from the purchase order source tables to produce queries to extract mismatch between the purchase order header and purchase order line, mismatch of purchase order and voucher, and receipts of purchase order.
Analyzed, tracked, and produced reporting including status of funds, operating expenditure plans, encumbrance spending, and other reports using SQR, Application Engine, PSJob, and Queries to ensure budgeting is in sync with transactions and ledgers are reconciled.
Identified, eliminated, and implemented process improvements on sourcing PO from a REQ and building vouchers.
Provided technical support to the functional team, created and implemented security access to PeopleSoft HRMS 8.8, and performed various DBA tasks.
Principal ConsultantJun 2005 to Nov 2005
As a member of the PeopleSoft technical support team for PeopleSoft HCM 8.9, modified PeopleSoft records and search functionality via Oracle's explain plan to improve performance and productivity of the servers.
Created Data Mover Scripts to import and export data in support of the conversion effort and data clean-up.
Modified custom programs by fixing data integrity issue in the custom Board Member application utilizing PL/SQL.
Assessed business requirement, technical design, test plans, and change requests to ensure documentation is accurate and up-to-date with respect to project standards and change management and provided weekly status to team lead and managers.
Senior PeopleSoft DeveloperSep 2003 to Jun 2005
Team Lead. Participated in numerous meetings with the functional team and the business owners to provide impact analysis on upstream/downstream processes, regarding the PeopleSoft Financials Supply Change Management (FSCM) 8.8 system and the project timeline.
Mentored, trained, and coached junior developers on PeopleSoft tools and practices and performed code reviews.
Heavily customized the Order Management Entry Process to allow the capability to compare both active and inactive contracts based on cost, selling price, and gross margin utilizing extensive PeopleCode and Application Designer.
Designed Integration Broker to interface with the High Jump barcode for the Inventory module.
Performed integration and UAT testing of custom and modified financial reports and tracked defects utilizing Mercury.
Configured and implemented the PeopleSoft HRMS 8.8 system within the Benefits, Benefits Administration, Payroll, and Time and Labor modules with a team of four consultants.
Generated periodic and quarterly Federal and State tax outbound ADP interfaces file and leave accrual process using SQR.
Saved the firm one hundred thousand dollars by researching and analyzing the Federal/State tax payment history to confirm the quality of the program and quarterly process amounts were correct and accurate.
Modified delivered SQR such as printing checks and creating direct deposits utilizing SQR, PeopleTools, PeopleCode, and SQL.
Created printable paycheck through E-Pay Self-Service and modified the page to allow employees to view current and YTD info.
Built pay check page to allow Payroll Administrator to view page as it is displayed to employees through E-Pay Self-Service.
Customized address change, phone change and emergency contact pages for E-profile Self-Service module.
PeopleSoft DeveloperMay 2003 to Aug 2003 Sierra System － Arlington, VA
Built custom SQR outbound comma-delimited files relating to wage taxes, vacation benefit, and overtime hours.
Produced test scripts and constructed system test data for integration and UAT testing of custom and modified reports for PeopleSoft HRMS 7.6 system.
Migrated the PeopleSoft objects and the programs (Query, SQR) utilizing Stat® and PeopleTools.
Systems AnalystJun 2002 to May 2003
Examined, shopping cart, education, surveys, and membership area of Association of Trial Lawyers' website to gain knowledge on the client's industry.
Gathered and developed requirements and designed documents, for various e-business areas through client meetings.
Ensured quality in the codes by thoroughly testing and working with the development team to guarantee business rules and requirements were understood.
Internally partnered with a colleague to install the demo version of the PeopleSoft Financials 8.4 system.
PeopleSoft ConsultantJan 2001 to Apr 2002 SI International － McLean, VA
Generated ad-hoc reports utilizing PeopleSoft Query to test the accuracy of complex conversion process Documented and tested GSF (Government Standard Forms) for hires and transfers for standard Personnel Action Request (PAR) transactions.
Designed and developed custom and delivered reports in SQR for PeopleSoft's 7.5 Position Management module to meet the client's needs and requirements.
Assisted with the implementation of complex headcount and full-time equivalency reporting GSF 113A and 113G Updated the design specification for new modifications.
Designed and executed the parallel test plans and documented all results.
Performed cross-reference test of actual headcount reports against the database in SQL to ensure accuracy Participated in testing utilizing SQA Robot Script Participated in migration and verification tasks such as reconciling control totals and comparing custom tables to their base table equivalents.
Bachelor of Science, Commerce MIS and AccountingMay 1998University of Virginia, McIntire School of Commerce － Charlottesville, VACommerce MIS and Accounting
Certified: Project Management Professional 2013-Present
Licensed: VA and DC State Real Estate License, 2006-Present
Software: PeopleSoft (7x to 9.2), MS Office Project, Toad, STAT®, TextPad, UltraEdit, MS Office Professional, PVCS, Visual SourceSafe, Mercury, Test Director, PowerBuilder, Quattro Pro, BPWin, ERwin, Visio
Operating Platform: MS Windows (Windows 10, Windows 8, Windows 7, Vista, XP, 2K, 98, 95, NT, 3.1), MS Windows NT/200, UNIX, MS-DOS
Databases: Oracle Suite, MS SQL Server, DB2, MS Access Programming
Technical Training: Business Analyst Boot Camp, PSFT 8.9 Benefits Administration, PSFT Integration Broker, PSFT 8.1 PeopleTools I/II, Payables I, PSFT Security, PSFT Basic and Advanced Query, PSFT Basic and Advanced Crystal Reports, Java and XML Development, Fundamentals of UNIX, Auditing Control Process, CRM Post Implementation Control Review Process