CAREER SUMMARY:

• Over 30 years of experience in the software industry and over 25 years of experience with PeopleSoft HCM 9.2, Financials, CRM and Distribution.
• Strong background in Team Management, Infrastructure, Architecture, Security, PeopleSoft, PeopleTools 8.57, PeopleCode, Application Engine, Workflow, Integrated Tools, SQR, Crystal Reports, EDI Manager, AutoSys, XML Publisher, Integration Broker and Oracle/DB2.
• Experienced in the entire project life cycle of software projects. Did Analysis and Design of customizations for PeopleSoft Upgrade from 8.8 to 9.1 at Confidential . Hands on experience in PeopleSoft functional modules namely HR, PAR processing, Position Management, ESS and MSS, Payroll, Recruiting, Call Center, Field Service, Help Desk and Interactive Management, Order Management, Billing, Accounts Payable, Accounts Receivable, Project Costing, General Ledger and Purchasing.
• As Phire Admin/CM responsible for Release definitions, Migrations.
• Hands on experience with Agile and waterfall methodologies.
• As PeopleSoft Security Administrator, I was responsible for all aspects of managing and monitoring access to PeopleSoft resources, including PeopleSoft 9.2 and PeopleTools 8.57 security structure, pages, processes, queries, trees, reports, components, services, integrations, customizations, and tools.
• I have several years of experience in troubleshooting user access issues with security setup (user profiles, permissions, roles, row level security) PS cache, migrations across environments using phire/stat, synchronization of roles between PeopleSoft and LDAP, HCM and financial modules. Strong understanding of network protocols such as LDAP, SMTP, DNS, SSH, SFTP, FTP, FTPS and HTTP.
• Provided technical assistance, and systems management to the projects at IRS. Evaluated and made recommendations on how to integrate PeopleSoft 9.2 with external applications using Integration Broker, Business Interlinks and Component Interfaces.
• Good understanding of the Commercial and Federal business systems, requirements and skills to translate them into highly flexible information systems.

SKILLS:

Software: PeopleSoft ERP (HCM 9.2), PeopleTools, 8.57, Global Payroll Inteface, PeopleCode, SQL, XML Publisher, Structured Query Report (SQR), Crystal, Nvision, Application Engine, Integration Technologies (Integration Broker, Business Interlinks, LDAP, and Component Interface), XML - BI publisher, Phire, CMQuest STAT, CRM, Financials, Workflow and Server Administration), Languages (PL/SQL, SQL, HTML, JAVA, C++), Oracle, Sybase, DB2, Case Tools (Rational Tools), MS Office products, Utilities (Toad, WinSql, SqlDeveloper and AutoSys)

Operating Systems/Platforms: LINUX/ UNIX, Windows, SUN Solaris, Confidential (MVS/OS390), VAX/VMS, Confidential, SUN SPARC, Confidential ES 7000 WebLogic, and WebSphere.

EMPLOYMENT:

Senior PeopleSoft HCM Consultant/SME

Confidential

Responsibilities:

• As a Senior PeopleSoft Consultant to the Dept of State, the largest US government PeopleSoft HCM 9.2 Global Overseas Personal System(OPS) implementation serving over 100,000 employees across 176 countries worldwide, providing ongoing production maintenance and coding using PeopleSoft HCM 9.2 and PeopleTools 8.57 .
• As a key resource Designed and Developed Overseas Personnel System - Initiation, Proof of Concept, Requirements Analysis, Fit and Gap Analysis, Configuration and Setup, Design Development, Data Mapping and Conversion, Test, deployment and Stabilization.
• OPS is a PeopleSoft Portal custom application. As a Key resource was instrumental in Implementation of Global HR, Personal Information, Position management, Job Data and custom Travel management.
• As a key resource designed and developed a bolt on Custom Travel Management Message System for Confidential which facilitates and tracks global assignments.
• Developed a bolt on component to manage Overseas Business Office data and dependent data,
• Designed and Developed a Global Payroll Interface using BI publisher to Integrate OPS system with GFACS (Global Payroll) output which is a xml file for each local employee.
• Designed and developed Multiple complex BI publisher reports JF62, JF62 A, JF62 B and SF50 which are auto generated based on Employment Mechanism.
• Designed and Developed Synchronous/Asynchronous Messages using Integration Broker between OPS (Global HCM 9.2) with GEMS (Public Sector HCM 9.1) to synch up data between two systems.
• Designed developed a custom mass update component to do Mass personnel actions using Application engine programs to update Job data. Automated Bulk JF62 report generation from Mass update component using App Engine, Component interface and Integration broker Messaging to publish reports to report repository.
• Instrumental in design of Architecture and infrastructure of OPS system across environments.
• Also worked as PeopleSoft Administrator/Linux Admin/Oracle DBA for one whole year as resources left the project.
• Also worked as Release Manager/CM and Phire Admin to do migrations across environments. Have Hands on experience with Phire migration tool came up with a strategy to accommodate Data migration work bench objects.
• Involved in full life cycle of PeopleTools Upgrade from 8.54 to 8.57.

Senior PeopleSoft HCM Consultant

Confidential

Responsibilities:

• Providing ongoing production maintenance and coding for PeopleSoft HRMS Version 9.0 and PeopleSoft ePerformance 8.9 applications.
• Deployed major enhancement of HRConnect, a PeopleSoft Portal custom application. Implemented HR, Personal Information, Job Information, ESS and MSS functionality, defined roles, access control, routing rules, and worklist/email notification. Created online functionlity for pre-employment data to be reviewed, commented or submitted by HR personnel, used Pagelet Wizard, PeopleSoft HTML/XSL, PeopleCode and iScript for user interface development. Designed and developed NTE and Personnel Audit reports using XML publisher.
• Designed and developed online functionality and data conversion for DOL, USAID, NIST and BEA. Designed data-mining algorithm for table/field comparison between source database and target database. Customized Hire template using component interfaces to hire employees and contractors for USAID. Designed and developed Proxy functionality for Foreign Service Contingent workers to act as proxy to their managers on adhoc basis.
• Deployed system enhancement for data extraction/interface for USAID, CENSUS and IRS. Designed and developed generic, configurable data extract interfaces using high-performance App Engine program leveraging parameterized pre-defined queries that can be used by multiple government agencies and has the capability to produce 200MB extracted data from HR database within 30 minutes

Managing Consultant/ PeopleSoft Package Solutions Consultant

Confidential, Arlington, VA

Responsibilities:

• Involved in full life cycle of HCM upgrade from 8.8 to 9.1
• Ported from SQL Server to Oracle database on Unix platform
• Ported from NT server to Unix.
• Worked on Upgrade Analysis and retrofitting customizations.
• Worked with business groups to ensure the new release meets their business needs.
• Responsible for Security administration, Data maintenance and Trouble shooting
• Worked closely with testing team for Integrated testing.
• Redesigned 21 PAR iteration SF50 reports to display in PDF format
• Retrofitted Recruiting Module (Online objects, batch processes and Reports)
• Retrofitted Payroll Processing (SPS) (Online objects, batch processes and Reports)
• Retrofitted Organization development and Positions (Online objects, batch processes and Reports)
• Retrofitted Workforce Administration (Online objects, batch processes and Reports)
• Retrofitted Background Investigation and Security Checklist (Online objects, batch processes and Reports)
• Registering Transactions for Recruiting work flow and configuring Approval Process Definition
• Resolved performance issues on complex queries involving large tables by creating temp tables, creating rule indexes, using message utilities and loading sequence.

PeopleSoft SME (Subject Matter Expert) / Systems Architect

Confidential, New Carrolton, MD

Environment: PeopleSoft CRM 8.8/HCM 9.0, PeopleTools, PeopleCode, Security Manager, SQL, SQR, Tuxedo, Crystal, Structured Query Report (SQR), Application Engine, Integration Technologies (Business Interlinks, LDAP, Component Interface, Integration Broker), JAVA, C++, XML, Quest STAT, DB2, Rational Tools, MS Office products, Utilities (Toad, WinSql), Sun Solaris, Windows, Confidential (MVS/OS390), Web Logic, and Web Sphere, and Confidential ES.

Responsibilities:

• Developed and executed a detailed Project plan to monitor and implement A2A Automated Enrollment System for Help Desk personnel from IRS to enroll/update Application Systems on behalf of External Partners for their organization. This specific task involved Project Lifecycle Model, Data Management Plan, stakeholder involvement plan, Project Costs, Project Budget, High Level Project Schedule, Detailed Project Schedule - WBS, QA review, Peer review, and Progress Review, Milestone Deliverables, Configuration Management, Risk Management Plan and Project approvals. Followed the CMMI (Capability Maturity Model Integration), and SCAMPI-Standard CMMI Appraisal Method for Process Improvement at IRS.
• Responsible for Security administration, Data maintenance and Trouble shooting of production environment.
• Responsible for the analysis of 8.4 and 9.0 release notes and involved in the impact assessment and prepared upgrade benefits documents.
• Generated compare reports between vanilla version 9.0 and production.
• Analyzed Upgrade Compare reports and made required changes as per the business process and made recommendations to eliminate customizations, reviewed all the upgrade documents, SQR, DAT and DMS files. Provided the different approaches to retrofit the application in Core HR, and Benefits modules.
• Customization of the Candidate Gateway and Time and Labor module according to Functional Design and trouble shooting issues, retrofitting the new changes in self-service modules of eBenefits, ePerformance and ePay.
• Developed new AppEngine and Integration Broker between Ehelp and PeopleSoft CRM.
• Worked on Change Assistance for Tools Upgrade and migrations, used Data Mover to run the DMS scripts.
• Responsible for Applying Maintenance Packs Update Patches MP4 to MP9 for Application Upgrade and 8.48 Product Patch for Tools Upgrade
• Modified custom reports by table joins and including the new fields to make them run in 9.0.
• Wrote Scripts to import and export the 3rd party and legacy data using Data Mover.
• Responsible for the analysis of customized SQR Programs SQL Tuning to improve the performances for the Upgrade.
• Worked on data mapping by identifying the external source tables and fields, by identifying corresponding PeopleSoft tables like Bank, Pay Group, etc for data conversion.
• Involved in the Portal Synchronization with other integrated applications and provided security for single sign and provided row-level security for PS queries and table level access for the specific users using query access groups
• Retrofits the new changes to Departmental security and provided permissions using Tree Manager and migrated the Security Trees to PSTS, PSUAT and Production Environments and resolved security related issues.
• Created new roles and permission lists for user’s security and followed SOX methodology to migrate to production and maintained documents for audit.
• Supported Production IRS Portal issues related to Web Servers and Web Application servers involving Websphere JVMs (Mef, ITIN, Eservices) Siteminder, Etrust, MQ series and PeopleSoft.
• Provided detailed analysis, re-design and re-architecture of Transactional Transition Bridge (TTB java application) with hardware upgrade and to replace TTB with Enterprise Application Integration Broker (EAIB).
• Modified the AMDAS API to transmit the transcript and CAF requests to EAIB for transmission Via the LAP to the CPE. Actively involved with procurement of hardware and software, for Re-architecture of Eservices Suite of Applications.
• Did production support for entire suite of Eservices applications (PeopleTools and PeopleSoft) by resolving Java issues, SQL issues, DB2 patch issues, Memory Allocation issues, TTB, AMDAS and Integration broker issues. Also worked on issues related to Firewall timeout settings, tuxedo thread setting with PeopleSoft JVMs. Provided suggestions on how to schedule jobs, monitor and send notifications to SAs using process scheduler. Provide detailed upgrade path to accommodate DB2 upgrade (from 7.1 to 8.1) and zOS upgrade from v1R7 to v1R8. Worked with PeopleSoft/Oracle to get certified platform support for Websphere 5.1.1.12 on Solaris 2.8 and IIS 5.0 on Windows 2000. Documented Error reference guide to support Eservices Applications. Supporting IE group for PeopleTools software upgrade (8.43 to 8.48 and other middleware impacted products under the z/OS 1.8 and DB2 8.1 upgrade. Supporting Opnet group to enable panorama on PeopleSoft and eservices internet architecture for suite of IRS applications. Key participant in Security and Controls Audit, contingency, backup and disaster recovery plans audit by Booze Allen Hamilton. Providing technical advice on how to implement a CR to monitor TTB boxes (Solaris) and PS App Servers (Windows) using Opnet products. Provided detailed analysis, design, and deployment of disaster recovery for entire suite of Eservices Applications.

PeopleSoft Lead / Senior Developer

Confidential, VA

Responsibilities:

• Involved in full life cycle of Financials upgrade from 8.4 to 8.8
• Worked on Upgrade Analysis and retrofitting customizations.
• Worked with business groups to ensure the new release meets their business needs.
• Function as Security Administrator responsible for creating user profiles, roles, and permission lists.
• Responsible for Security administration, Data maintenance and Trouble shooting
• Worked closely with testing team for testing.
• Assisted the Auditing team with SOX compliance needs.
• Designed and Developed Automation of following CLAS (Schedule A-D reports) (12) Monthly, Quarterly and Yearly using Application Engine PeopleCode/SQL to extract data from Project Cost tables and perform calculations to store it in staging table in order to display as elements in Nvision Reports. Queried Report Definition/Element definition tables in order to get elements that need to be calculated and to build Where Clause for queries. Implemented workflow to enforce business rules on above reports.
• Resolved performance issues on complex queries involving large tables by creating temp tables, creating rule indexes, using message utilities and loading sequence.
• Designed and Developed AutoSys Jil files, run books and shell scripts to run MIDAS interface to schedule through process scheduler and archive processed files in automated mode.
• Designed and Developed SQR program to populate the raw data using arrays for the REO Disposed Loan Dataset. This raw data will be queried by Nvision reports.
• Designed and Developed CLR Reports namely Reserves and Recoveries, which have six different data sources from external systems using PeopleSoft Components, Application Engine and Nvision reports.
• Designed and Developed SQR to generate 2 summary reports and 8 detailed reports to display CDW and CLAS data. (SAS Phase 1b)
• Designed and Developed Automation of all the processes (end to end) for SAS phase 1b using Autosys and Shells scripts which trigger various programs (Application Engine programs and SQR’s) based on dependencies on CLAS as well as CDW. It also sends email with error handling, polls for file from CDW, and archives processed files in automatic mode.
• Supported test team on how to create and execute complex queries efficiently to validate requirements.

PeopleSoft Senior/Lead Developer

Confidential, MD

Modules: ICM (Marketing, Sales (Leads), Call Center, Support, Field Service, 360 degree View) and Custom modules.

Environment: PeopleSoft CRM 8.0/8.8 SP1, PeopleTools, PeopleCode, SQL, SQR, Tuxedo, Crystal, Structured Query Report (SQR), Application Engine, Integration Technologies (Business Interlinks, LDAP, Component Interface, Application Messaging), JAVA, C++, XML, Quest STAT, DB2, Rational Tools, MS Office products, Utilities (Toad, WinSql), Sun Solaris, Windows 2000, Confidential (MVS/OS390), Web Logic, and Web Sphere, and Confidential ES.

Responsibilities:

• Extensively worked on upgrade analysis.
• Worked on Fit and Gap Analysis for ICM (Indirect channel management).
• Extensively worked on Configuration/customizations.
• Coordinated, supervised and implemented PeopleSoft security in development, test, acceptance and DSRT environments. Assisted the infrastructure team to do LDAP security using third party software. I have worked as Security Administrator responsible for creating user profiles, roles, query groups and permission lists at IRS from 2001 to 2005.Worked with users and other technical members from the client organization to configure access, setup security and security migration procedures.
• Worked on migrations (using Quest Stat)
• Worked on Artifacts documents.
• Extensively helped testing team for testing.
• Responsible for full life cycle development which involves Gap Analysis, system design and integration using PeopleSoft CRM and 8.48 PeopleTools. Provided technical assistance, systems management to the project, evaluated and made recommendations on how to integrate PeopleSoft 8.14 with external applications using Business Interlinks and Component Interfaces. Designed and Developed mail merge application using PeopleSoft 8.14, Application Engine PeopleCode, Crystal reports, process scheduler and MS mail. Customized PeopleSoft delivered objects, Modify, Add PeopleCode, pages, workflow and application engine processes based on the client’s requirements.
• Worked with PeopleSoft Consulting Team to do Field level Audit when the user viewing sensitive information using PeopleSoft 8.14 Integrated Tools.
• Customized Workflow applications for Campaign management and Call Center case management by redesigning and rewriting workflow PeopleCode, events and messages as per the IRS requirements. Developed a new application TIN Matching using object PeopleCode 8.14, Application Engine, WebLogic, XML, HTML, Iscripts and integrated tools (Business Interlinks, Component interfaces and AMDAS Message Queue). Worked with PeopleSoft to resolve CRM workflow issues.
• Coordinated and supervised Migration from Development to test, and to Acceptance using Data Mover, Tree Mover and Upgrade Assistant Assisted the infrastructure team to do LDAP security using third party software. Assisted Data team to do data conversion from legacy system to PeopleSoft using SQR’s.
• Designed and developed IRS custom menu design, validation and security for external users using PeopleCode, HTML, Iscripts, Images and security manager.
• Customized process request dialog to control the access to destination types and format to enforce security regulations.
• Developed a sales lead assignment application to assign leads from one sales manager to another sales manager based on Business unit and Product ID.
• Developed and supported a new application Transcript Delivery System (TDS) using object PeopleCode 8.48, Application Engine, XML, HTML, Iscripts and integrated tools (Business Interlinks, Component interfaces, C++ and AMDAS Message Queue). Coordinated, supervised and implemented PeopleSoft security in development, test, acceptance and DSRT environments.

PeopleSoft Technical Lead / Architect

Confidential, Rockville, MD

Responsibilities:

• Did Analysis and Design of customizations to 8.1 PeopleSoft Upgrade from 7.07 for AP and Purchasing Modules.
• Above task involved low level mapping of customer’s requirements to PeopleSoft functionality, identify customizations, low-level design of processes, reports, interfaces, pages, components and SQL views.
• Reviewed and provided feedback on design documents on Upgrade for AR, AM, Billing and GL Modules using PeopleSoft 8.1 from 7.07.
• Production Support and Enhancements for Financial Systems at Confidential using PeopleSoft 7.07 and Oracle 8.0.5 in Sequent, NT and Windows environments.
• Customized PeopleSoft delivered objects, Modify, Add PeopleCode SQR's, crystal reports and application engine processes based on the SCR's in the problem tracking system.
• Doing on call Production support following on-call procedures and escalation process for PeopleSoft CRD Accounting nightly batch processes.
• Providing timely support for the following modules BI, AP, AR, GL & Purchasing. Assisted CSM achieve and maintain CMM Level 2 Compliance.
• Designed and developed software and automated batch processes. Did analysis, design and code SQR's, Sql scripts and shell scripts.
• Above tasks were accomplished using PeopleSoft, Oracle in Unix environment and MS windows on the client. Above system processes the CRD nightly data collection and Billing processes.

PeopleSoft Lead Consultant

Confidential, Rockville, MD

Responsibilities:

• Designed and Developed PeopleSoft HRMS application for Metamor Project using PeopleSoft 7.5 (HRMS) and Oracle 8.0 on HP 9000 platform.
• Responsibilities include Design of entire Benefits Business Process cycle to maintain employee benefit enrollment information and premium calculation rates and rules to use during payroll processing to calculate the correct employee and employer deductions and to setup retroactive deductions. Above task involved low level mapping of customer’s requirements to PeopleSoft functionality, identify customizations, low-level design of processes, and reports, add/modify panels, menus, fields, records, process definitions and queries.
• Also Designed and Developed 10 complex crystal reports to process Immigration data reports, I-9 report and Employee information data reports in Human Resources module.
• Above reports added to Administer Workforce process Reports menu to run from Process Scheduler by creating run control panels.
• Designed and Developed SQR processes to determine annual benefits rate factor for account Managers and Technical Recruiters.

Senior PeopleSoft / Technical Consultant

Confidential, Washington, DC

Responsibilities:

• Customize, implement, enhance, and support PeopleSoft financial applications.
• The Confidential Billing System is designed and developed using ERP software PeopleSoft 7.0 (Financials and Distribution) and Oracle 7.3 on Sun Solaris Platform.
• Responsibilities include setting up EDI Manager to process sales orders in batch mode, Accounts receivables for customer correspondence, design new panels, create new business processes, custom SQR processes to consolidate bills, new reports, develop interfaces using SQR and PL/SQL, and process type definitions.
• Designed and developed 12 crystal reports and 12 SQR processes to run in batch mode.
• Also modified PeopleSoft delivered SQR's and application Engine COBOL SQL programs to resolve issues in populate billing in EDI mode.
• Developed interfaces to process existing data from existing system to PeopleSoft application using PL/SQL and SQR. Created several new record definitions to support customer maintenance and incoming charge feeds.
• Changed various PeopleSoft panels and Modified PeopleCode programs to validate data.
• The Confidential Account Payables is designed and developed using ERP software PeopleSoft 6.0 (Financials and Distribution) and Oracle 7.3 on Sun Solaris Platform.
• Responsibilities include support production operations by resolving system issues, resolve performance issues by rewriting queries, setting up process definitions and maps for vendor item loader.
• Also developed custom SQR's to process Manual payments, Voids and Cancel checks in auto mode.
• Worked with end-users to define the requirements and designs for PeopleSoft package modifications.