CAREER SUMMARY:

Over 22 years of experience in the software industry and over 17 years of experience with PeopleSoft HCM, Financials, CRM and Distribution. Strong background in Project Management, Infrastructure, Architecture, Security, PeopleSoft, PeopleTools, 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 FDIC. 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 PeopleSoft Security Administrator, I was responsible for all aspects of managing and monitoring access to PeopleSoft resources, including PeopleSoft 9.1 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, 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.0 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.1, CRM and Financials , Campus Solutions, SCM Order Management and Inventory , PeopleTools, Peoplecode, SQL, XML Publisher, Structured Query Report SQR , Crystal, nvision, Application Engine, Integration Technologies Integration Broker, Business Interlinks, LDAP, and Component Interface , XML publisher, Quest 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: UNIX, DOS, Windows 2003/NT XP, SUN Solaris, IBM MVS/OS390 , VAX/VMS, IBM PC Compatibles, SUN SPARC, Unisys ES 7000 WebLogic, and WebSphere.

EMPLOYMENT:

Confidential

Senior Peoplesoft

• As a Senior PeopleSoft Consultant to the United States Treasury, the largest US government PeopleSoft implementation serving over 200,000 employees across 68 sub agencies, 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, in Jan, 2012
• Implemented HR, personal information, Job Information , ESS and MSS functionality, defined roles, access control, routing rules, 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 for DOL, USAID, NIST, BEA and data conversion analysis/mapping repository, conversion programs in Oct, 2012
• Collaborated with colleagues to create data conversion strategy plan and project plan.
• 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

Confidential

Senior Peoplesoft

• 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.

Confidential

Systems Architect

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, IBM MVS/OS390 , Web Logic, and Web Sphere, and Unisys ES .

• 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.
• 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.
• Written 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 . Modify 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.
• Doing 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 advise 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.

Confidential

Senior Developer

• 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.

Confidential

Technical Lead/Architect:

• 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 NASD 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.

Confidential

PeopleSoft Lead Consultant:

• 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. Oct 96 Sep 98 Fannie Senior PeopleSoft/Technical Consultant: Customize, implement, enhance, and support PeopleSoft financial applications. The FannieMae 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 FannieMae 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.: Performed tasks in support of requirements, design and development of collateral loan assessment system using C and Sybase DB libraries on SUN/Solaris system. Responsible for full life cycle development which involves systems analysis, system design and integration. Provided technical assistance, systems management to the project, evaluated and made recommendations on software to business managers and the team. Above system is envisaged to make the entire collateral loan assessment faster and easier.