OBJECTIVE:

A highly motivated person with extensive experience in application development and internet technologies, seeking challenging lead assignments in delivering e - business and ERP solutions.

SUMMARY:

• Fourteen years of experience implementing ERP (Oracle/PeopleSoft) solutions for public and private sector clients.
• Over seventeen years of hands-on experience in US, Middle East & Asia Pacific supporting systems and developing applications for higher education, human resources, financials, manufacturing and sales using various applications and software tools.
• Experience in implementing and modifying with HCM, Financials, Enterprise Portal, Campus Solutions ERP Applications.
• Implementation, Upgrade, Conversion and integration leadership experience on several PeopleSoft ERP projects.
• Strong working knowledge of leading RDBMS (relational databases), SQL, PL/SQL, SQR, PeopleCode, Application Designer, Application Engine, Component Interface, Query and Seagate Crystal and Internet technologies.
• A quick learner with outstanding analytical ability and excellent communication, organizational, interpersonal and leadership skills.
• Strong client interaction and relationship management skills.

COMPUTER SKILLS:

PeopleSoft Application Tools: PeopleTools 8.51, 8.48 / 8.42 / 8.19 / 7.57 / 7.56 / 7.0 - Application Designer, Application Engine, Application Package, Component Interfaces, File Layout, Integration Broker, SOA, WSDL, Webservices, Application Messaging, Message Agent, XML Publisher, Application Workflow Engine, Workflow, HTML Access, Mass Changes, Query.

Programming Languages: PeopleCode, SQR, PL/SQL, C, Java, XML, HTML, ASP, Java Scripts and VB Scripts, GPSSH

Version Control, Help Desk, Testing tools: Stat, Clearquest, PVCS, Remedy, Loadrunner

Software, Tools and Utilities: Crystal Reports 9 & 8, Oracle Developer/2000 (Forms 4.5), Powerbuilder 5.0 / 4.0, MS-Access 7.0, SABA, Lotus Notes, MS-Office

Database Management Systems: Oracle 11g / 10i / 9i / 8.0 / 7.3, MS-SQL Server, MS-Access 7.0

Operating Systems & Environments: Windows 7, XP, 2000, NT, Linux, Unix, MS-Dos, Sun Solaris, Confidential AIX

Internet Technologies: Cold Fusion 4.0, Silver Stream, MS FrontPage.

WORK EXPERIENCE:

Solutions Architect / Principal Consultant

Confidential, Leesburg, VA

Environment: PeopleSoft Campus Solutions 9.0, PeopleTools 8.51, Oracle 11i databases.

Responsibilities:

• Currently helping transition and implement electronic payment and payment plan vendors from touchnet to ECSI.
• Review universities requirements for electronic payment and payment plans and do a fit-gap analysis on ECSI product and solutions offerings.
• Propose technical solutions and create technical requirements for changes in PeopleSoft to help integrate with ECSI.
• Create (provide) services and consume services and integrate PeopleSoft with ECSI using integration broker. Developed, unit tested, system tested and migrated projects to production.
• Automate procedures to exchange data files through third party and process them.

Confidential, Vienna, VA

Environment: PeopleSoft HCM 8.9, PeopleTools 8.47, Oracle 11i databases.

Responsibilities:

• Currently supporting Benefits/eBenefits, North America Payroll/ePay, ePerformance, Time & Labor/eTime, Absence Management, Compensation (custom) modules of HCM application.
• Review and apply all HCM tax updates.
• Design and develop conversion and interface programs for Workday from PeopleSoft.
• Created design documents and unit testing documents and performed testing for each of the projects that went through the SDLC.
• Created and modified many Application Engine, App Packages, SQRs, Cobol, PeopleCode, Component Interfaces, excel to CI, Integration Broker, PeopleCode programs during the phase of the project.

Confidential, Phoenix, AZ

Environment: PeopleSoft HCM 9.1, PeopleTools 8.50, Oracle 11i databases.

Responsibilities:

• Worked on a HCM upgrade project, retrofitting existing customizations and testing customized both new and delivered functionality.
• Customized Manager Self Service, Time & Labor, Absence Management and Payroll applications as per the client’s requirement.
• Worked on reporting strategy including new report delivery methods. Created new rowset based messages for sending data from HR to Enterprise Portal.
• Configured integration broker starting from setting-up Gateway, Nodes, Service Operations, Services, Routings etc.to make the interfaces work.
• Converted data from FileNet and created Webservices based interface from FileNet.
• Modified existing XML publisher and SQR reports for Time and Labor and Payroll.
• Modified Payroll to GL interface to change logic for updating Resource Category.
• Created an App Engine process for Payroll to update the Union Dues - General Deduction amount.
• Worked as a production support analyst in supporting a PeopleSoft project for the Absence Management, Time and Labor & Payroll modules.
• Worked with GSC to make program changes and payroll data corrections for 5000+ employees for their payroll processing to occur correctly. This was a result of upgrade/bundles applied and data issues that were in the production environment.
• Corrected PTO accrual / Leave Balance data, provided reporting and update functionality to make changes to data.

Confidential, Washington, DC

Environment: PeopleSoft HCM 8.3, PeopleTools 8.22, Oracle 10i databases.

Responsibilities:

• Worked as a analyst/developer in supporting a PeopleSoft project for the HR, North America Payroll, Benefits, Time & Labor and Absence Management modules.
• Transitioned support responsibilities from the previous contracting company. Support responsibilities include - daily HR processing, reporting, daily, weekly bi-weekly interfaces to several government agencies like DFAS, ePay, eHRI, eOPF.
• Worked on improving business processes and interfaces for the agency.

Confidential, Denver, CO

Environment: PeopleSoft HCM 9.1, PeopleTools 8.51, Oracle 11i databases.

Technical Lead for a HCM

Responsibilities:

• Worked with Business users to understand the requirements and created technical specifications for HR, North America Payroll, Time & Labor, Absence Management and Benefits.
• Worked with developers and worked with an offshore development team in leading the development efforts. Some of the development tasks included:
• Developed and customized processes for creating a Template Based Hires, Employee and Job records.
• Converting earnings to the Special Accumulators from the custom Earnings roll-up functionality / pages.
• Transition benefits deduction for the payroll from ADP (modify interface) to PS delivered Base Benefits functionality.
• Modify Paycheck and Advices to include changes to the Savings Plan deduction information.
• Modified COBRA interface to send enrolled and dependent information to 3rd party.
• Make changes to the Employee Self Service (ESS) pages: Personal Information Summary page (Name Change), Phone Number page, Emergency Contacts, View Paycheck, Direct Deposit (T4/T4A Slips), W-4 Tax Information USA (W-2/W-2c).
• Retrofit all retained customizations and retired functionality the client did not want to use.
• Worked on Workflow and Approval Workflow Engine (AWE).
• During the upgrade project modified and worked with Application Designer tools - PeopleCode, Integration Broker, Component Interfaces, Application Engine, Application Package and SQR's.

Confidential, Arlington, PA

Environment: PeopleSoft CRM 9.0, HCM 9.1 and Financials 9.1 PeopleTools 8.51, Oracle 11i databases.

Senior technical and integration Consultant

Responsibilities:

• Configured integration broker at Confidential starting from setting-up Gateway, Nodes, Service Operations, Services, Routings etc.
• Created several real time interfaces for the Confidential using Integration Broker and non-real time interfaces using file based application engine programs.
• Consumed web services and provided web services (WSLDs) based on CI and Application Packages.
• Provided web services to use Soap based and container based messages.
• Some of the integration included:
• Design and development of interfaces for the client’s billing system and fulfillment system with PeopleSoft’s CRM Order Capture, HR and Financials Application.
• Design and development of interfaces for the client’s Customer Data Model (BORM) with HCM system.
• Gathered technical requirements, created technical specifications and data mapping documents for Confidential - Integrated CRM, HCM and Core Financials Systems interfaces with external agencies.
• Created reports using XML publisher.
• Worked on PAR processing, related workflow and approval workflow engine.

Confidential, Tucson, AZ

Environment: PeopleSoft HCM 9.1 / PeopleTools 8.50, Oracle 11i databases

Technical Analyst & Developer for the PeopleSoft HCM application

Responsibilities:

• Retrofitted existing customizations from an upgrade of HCM 8.9 to 9.1 and made additional modifications to meet the university needs. Some of the upgrades to programs and customizations that were retrofitted have been listed below:
• Modified the Payroll Audit report to display Plan Type for a group of employees with a certain deduction code.
• Upgrade program/s to 9.1 that generates post-retirement dental form, TSA deduction form, FlexCash, Personal Medical form.
• Modify the current State Controller’s Office (SCO - 3rd Party) interface to discontinue using Human Resources Information Support Analysis (HR-ISA) and start using the upgraded Base Benefits tables. The interface sends enrollments and terminations of the Vision, Life and Accidental Death/Dismemberment (Life AD&D), and Long-Term Disability (LTD) benefits to the SCO.
• Create custom combined benefits summary/employee data summary page.
• Retrofitted changes to the Application Engine programs to update annual base salary, to refresh Employee table and changes to add new benefit programs, plans and plan types.
• Retrofit modifications to Payroll that would calculate Performance Bonus for hourly employees. Calculations are based on the earnings amount accrued for a fiscal year.
• Retrofitted Application Engine process to evaluate Retirement Indicators based on employees birth & service dates.
• Retrofitted all payroll interfaces with EDS.
• Customized functionality for employee self-service (ESS) modules such as eRecruit, ePay, eBenefits and eProfile.
• During the upgrade projects modified and worked with Application Designer tools - People Code, Integration Broker, Component Interfaces, Application Engine, Application Package and SQR's.
• Created reports using XML publisher.
• Created the technical design document, coding and created the test plan for the upgrade and customizations effort.

Confidential, Dulles, VA

Environment: PeopleSoft CRM 9.1 &, PeopleSoft CS 9.0, PeopleTools 8.50, Oracle 11i databases

Conversion and Integration Analyst / Developer

Responsibilities:

• Converted Person, Leads (Prospects), Worker data from Legacy to CRM PeopleSoft system.
• Converted Student Accounts, Payment Plans, Third Party Contracts, Student Groups, Academic Standing,
• Honors and Awards from Legacy Host system into CS system.
• Design and develop integration programs between Legacy Human Resources system - Abra, legacy CRM system - Talisma, Other 3rd Party organizations into PS CRM and CS systems.
• Managed application and webservers, managed code migrations via Stat and coordinated all migrations from TST to SYS, UAT, QA and TRN environments.
• Created and modified equation engines for Student Finance and Financial Aid.
• Created and modified Application Engine, Application Package, Integration Broker, Web Services SOA, PeopleCode and other objects using Application Designer to accomplish the tasks listed above.

Confidential, Minneapolis, MN

Environment: PeopleSoft HCM 9.0 (Time & Labor, Absence Management and Payroll) / PeopleTools 8.49, Oracle 12i databases

Technical Analyst & developer for the PeopleSoft HCM application

Responsibilities:

• Completed technical specifications and data mappings for development items and customizations on PeopleSoft HCM. Provided technical assistance in completing the development of projects on time. Some of the keys projects included:
• Modifying Payroll deduction interface program and developed Pay Audit reports using SQR.
• Developing Leave Accrual process to calculate and update leave balance by retrieving data from Time and Labor payable hours worked and to calculate accrued leave based on rates stored in the leave plan tables.
• Creating Faculty Compensation Survey report for American Association of University Professors (AAUP), Minnesota Higher Education Commission (MHEC).
• Creating a customized interface to calculate the encumbrance HR salaries and associated fringe expenses through the Department Budget tables and send data to GL.
• Modifying and configuring the process to enroll employees in the appropriate leave plan based on the employee’s data and rules in benefits administration table.
• Modify the PeopleSoft delivered Adjust Paid Time functionality to include the adjustment of Payable Time with the Capella custom statuses.
• Developed integration points using Integration Broker between HRMS and Student database to keep data in synch.

Confidential, Charlottesville, VA

Environment: PeopleSoft Financials, Campus Solutions 9.0 / PeopleTools 8.49, Oracle 10i databases

Technical Analyst

Responsibilities:

• Used the following development tools: Application Designer to modify existing and create new objects: Application engine, Application package, PeopleCode, Iscripts, Menus, Components, Pages, Sub-pages, Records, fields; SQR, Query, Cobol, Oracle triggers and procedures.
• Completed technical specifications and data mappings for development items and customizations. Provided technical assistance in completing the development of projects on time.
• Modifying the self service Lender Selection pages and processes.
• Developing an interface from Student Finance to General Ledger and Grants Accounting system to account for each and every financial transaction in the Campus Solutions system.
• Modifying External Award & Department Award pages and processes.
• Process to create checklists and communications based on comments reported on student’s ISIR.
• Developing an Oracle payroll interface to PeopleSoft Work Study to track hours worked and gross earnings. The development helped in accurate FISAP (Fiscal Operations Report and Application to Participate) reporting to the Department of Education.
• Developing an interface with health insurance provider Aetna.
• Integration of Enterprise Portal with an external authentication system, Netbade to allow a smooth and seamless access of different systems to the end-users.
• Modifying various Academic Advisement reports to meet the University needs. Customization involved modifying Application Packages, PeopleCode and Cobol processes.
• Conducted various testing sessions through-out the project with functional and end-users.
• Worked with trainers and functional users to help develop business process and training documentation for the modification and customization projects.

Confidential, Ithaca, NY

Environment: PeopleSoft HCM 9.0 & Campus Solutions / PeopleTools 8.45, Oracle 10i databases

PeopleSoft HCM consultant

Responsibilities:

• Used the following development tools: Application Designer to modify existing and create new objects: Application engine, Application package, Component Interfaces, File Layouts, PeopleCode, Menus, Components, Pages, Sub-pages, Records, fields; SQR, Query, Crystal Reports, N-vision.
• Completed technical specifications and data mappings for development items and customizations. Provided technical assistance in completing the development of projects on time. Some of the keys projects included:
• Designing and developing an interface process to keep employee deduction data current with State Payroll data. The process reads the State Payroll inbound files and creates or changes benefit/deduction data within Cornell’s PeopleSoft system based on deductions reported by the state.
• Create “The State Payroll Interface” process by which the results of the State Payroll calculation are transferred into the Cornell’s PeopleSoft Payroll system. This State payroll information is necessary for the Cornell PeopleSoft system to create a commitment accounting General Ledger interface file for Cornell’s financial system.
• Configuring and creating Pay Distribution records for the GL Interface. The interface file is created after Payroll has been confirmed and the Actuals Distribution after a compare with Labor Distribution is completed.
• Created a validation process to ensure that a paycheck number is not marked as cleared in the Bank Reconciliation process.
• Created business process and training documentation to support the implementation.

Senior Consultant

Confidential, Cranberry Township, PA

Environment: PeopleSoft Financials 8.4 (GL, Commitment Control), PeopleSoft Student Administration 8.1, Oracle 9i databases

Responsibilities:

• Set-up academic structure for Confidential for them to start using events functionality.
• Developed an interface between PayGov website and PeopleSoft for automated registration into events for attendees who have paid through the website.
• Convert data for prospects, areas of interest, organizations & agencies, events and registration data from Symposia database to PeopleSoft. This included analyzing data and data elements in the legacy system (Symposia), mapping these to data elements in uNET (PeopleSoft), developing conversion rules, writing sqr scripts to move data and testing.
• Set-up academic structure for Confidential for them to start using class registration and events functionality. This involved setting up program, plan, sub-plan, term, session, academic calendar, course, class, grading scheme, GPA rules, event types and events among several other Campus Community, Admissions, and Student Records related set-up
• Conducted several training sessions for in-processing and out-processing of students for Industrial College of Armed Forces (ICAF), National War College (NWC) and School for National Security Executive Education (SNSEE).
• This involved entering applications into uNET, matriculating students, creating program / plan stack, term activating students, generating user profile and welcome letters for students for in-processing processes. And involved enrolling students though a custom elective selection process, grading students, awarding degree and generating transcripts for out-processing processes.
• Completed a proposal for an interface between PayGov website and PeopleSoft for automated registration into events for attendees who have paid through the website.
• Designed and developed an online prospect / application page for prospects interested in attending events, seminars and courses offered by Confidential . This application creates new records in bio-demo, prospects, admissions data if not already present and sends a confirmation E-mail to the user.
• Made improvements to custom Security interface, LENEL and Learning Management System, Blackboard. These two applications interface with uNET using component interface, application messages, database triggers, views, sqrs and snapshot technology / processes.
• Re-engineered and customized PeopleSoft processes to meet Confidential ’s need. These include customized grade roster page, transcripts, bio-demo, bio-book (community directory), class creation process, instructor, enrolment and grade load process, batch matriculation and term activation processes.
• Proposed and implemented a solution to provide quick and easy access to all the functionality used by the end-users through several custom homepages including several self-service pages for different groups of users across the university. This change was proposed as a result of an executive decision to discontinue the use of Enterprise Portal database and proved very user friendly and a big improvement to the system.
• Developed post-conversion programs to synchronize data between legacy and PeopleSoft system.
• Developed several queries to provide information related to course, class, events, student groups, grades, GPA, active student.
• Developed reports like personnel report, JTD report, evaluation / ratings report, security clearance report for Human Resources using crystal reports 8 and sqr.

Confidential, Owings Mill, MD

Environment: PeopleSoft Financials 8.4, PeopleTools 8.42, Oracle 10i databases

Responsibilities:

• Developed and modified procedures (SQRs, SQA Robot scripts) to convert General Ledger, Purchasing, Accounts Payables, Grants data from Legacy system.
• Funds, Department Ids, Programs were converted from FMS to PeopleSoft. All ledger balances and budget summary was brought forward into PeopleSoft, including all history since the inception of the FMS system in 1997.
• Open purchase orders, journals, a list of vendors over the last 24 months and budgets, expenses, revenue, AR and fund balances related to 300 active grants were converted.
• Purchasing and voucher tables were copied into PeopleSoft with a new name to retain the history in PeopleSoft. Inquiry panels and reports were created to access historical data from the FMS system.
• Modified delivered PeopleCode to prevent direct PO from capitalizing on receipt.
• Modified Purchase Order header to automate matching based on Purchase Order type and to facilitate a smooth PO roll process.
• Made customizations to the pre-existing reports and processes: Confidential GL Journal Generator process, Depreciation Calculation process, Journal detail report and Voucher workflow process.
• Modified custom interfaces for vouchers from various internal systems.

Confidential, Chicago, IL

Environment: PeopleSoft Financials 8.4, Student Administration 8.10 / PeopleTools 8.20, Oracle 9i databases

Responsibilities:

• Completed technical specifications and data mappings for development items and customizations on PeopleSoft Financials. Provided technical assistance in completing the development of projects on time. Some of the keys projects included:
• Designing and developing vendor / voucher data conversion program to bring existing vendors and open vouchers from Legacy system to PeopleSoft. Reconciled and validated the converted data from legacy system.
• Designing and developing a complex Par Item Usage report which supports the Par Location Maintenance and Item Maintenance business processes. This report shows activity for a given item across the entire system, business unit(s), and for par locations.
• Modifying budget actuals reconciliation SQR report to reconcile budget-checking transaction activity with commitment control ledgers and general ledger actual ledgers.
• Evaluating and setting up workflow for Journal Entry Approval, Asset Transfers approval, Voucher Approval and Receivable processes.
• Extracting two independent Item master files from two separate Inventory and Purchasing systems and reloaded the Master File into a single system providing improved integration to Purchasing and General Ledger.
• Modifying the Pay Cycle Application Engine program (AP APY2015) to ensure that PS PYMNT ADVICE is populated with the correct data, in order for the crystal report to print out the payment message on the voucher.
• Automating the journal entry approval process that will assist in minimizing the erroneous transactions due to incorrect journal entries.
• Implement Self-Service for Campus Community, Student Records, Student Financials and Financial Aid modules for six colleges of City of Chicago.
• Implement credit card processing in PeopleSoft through Touchnet.
• Develop a common Business Model for PeopleSoft’s Financial Aid Business Processes used by the twenty-three Virginia Community colleges.
• Develop / modify procedures and wrote business process documents on Satisfactory Academic Progress, Return to Title Four, ISIR processing, Loan processing and Disbursement, Post Census Enrollment, Missing Information Letters to streamline Financial Aid business processes at Virginia Community College Systems.
• Provided lead technical consulting services in supporting and developing PeopleSoft Student Administration (Self-Service, Student Financials and Financial Aid) for BSU.
• Worked with Campus executives to strategize, plan and execute the project plan to implement PeopleSoft Self Service.
• Provided advice and assistance for all technical aspects of PeopleSoft implementation including: modifying PeopleSoft Internet Architecture (PIA) for a user-friendly web look, creating help pages for self-service users to navigate and use the PeopleSoft system. creating security for BSU’s Bursar’s office (Student Financials), Financial Aid Office and Self-Service users including staff and students. Modified PeopleSoft process - Application Engine and Mass change processes to create User Ids and passwords for self-service users. Created Permissions Lists and Roles for Student Financials, Financial Aid and Self Service users. developing solutions to authenticate passwords against one hierarchal database - Active Directory Services (ADS) across university wide applications using LDAP, Business Interlinks and Application Messaging. implementing Component Directory Interface to ensure data integrity (data synch) between PeopleSoft Student Admin database and ADS and to maintain directory structure. implementing credit card transactions in PeopleSoft through Cybersource.
• Setting up set-up tables for Student Financials and Financial Aid modules and testing the related functionality. developing processes (using SQR) to move set-up data for Student Financials and Financial Aid across databases. developing processes (using SQR) to convert legacy data for Student Financials.
• Developing methods to assure timely generation of billing statements, methods that provide appropriate and effective collection processes, methods to assure accurate reporting of income in financial statements.
• Implementing processes and systems that assure effective cash management. interfacing Student Financials transactions to the Financials G/L module and to other University systems including Black Board.
• Developed reports using SQR, Query and nVision for PeopleSoft Financials module.

Senior Consultant

Confidential, Fairfax, VA

Environment: PeopleSoft Student Administration 8.10 / PeopleTools 8.19, PeopleSoft Financials 8.0 / PeopleTools 8.41, PeopleSoft Enterprise Portal 8.8 / PeopleTools 8.42 on Windows 2000 Platform; Oracle 9i databases, Remedy Help Desk, Blackboard

Responsibilities:

• Provided lead technical consulting services in supporting and developing PeopleSoft Student Administration (SA - Campus Community, Student Records, Student Financials and Financial Aid), PeopleSoft Enterprise Portal (PA) and Financials (FMS - General Ledger & Accounts Payable) implementation for Confidential .
• Worked with Campus executives to strategize, plan and execute the project plan to implement PeopleSoft Internet Architecture (PIA), Enterprise Portal, SA and FMS applications.
• Performed Fit Gap analysis for the Student Records, Student Financials, Financial Aid, GL and AP module.
• Provided advice and assistance for all technical aspects of PeopleSoft implementation including: creating a one-page user interface to enable students, faculty, and staff to maintain their biographic data (self-service) and enable faculty and staff to enter, maintain, and print an individual course-offering (class section) schedule with all course meeting information. creating a process to validate attendance fulfillment requirements for students taking resident courses and on-line courses. developing solutions for faculty members to grade students and provide feedback to students. developing several workflows using Application Designer and reports for several Confidential components using Crystal Reports and Structured Query Report (SQR). interfacing Student Financials transactions to the Financials G/L module. constructing effective and efficient tuition calculation processes for Confidential . configuring single sign on and application messaging / integration gateway (application link enabling) between different PeopleSoft databases and PeopleSoft Directory Interface between PS databases and directory servers.
• Creating pageletes, creating and administering discussion boards, creating and administering security for online documents and content (document and content management) using Enterprise Portal 8.8 application. integrating and configuring homegrown application Appnet, Blackboard, outlook mail, surveys, discussion groups, pagelets and other Confidential web links into Enterprise Portal. setting security for Confidential ’s PeopleSoft Financials, Student Administration and Enterprise Portal applications. This involved creating Roles and Permissions for the all users; developing algorithm and mechanism to generate user id’s and passwords through PeopleSoft processes; and sending it via E-mail. Developed a procedure to send new passwords to those who forgot their password upon receiving authenticated request. administering PeopleSoft Web, File / Application, Batch / Process Scheduler and Database servers. upgrading the Financials application from 8.0 to 8.4 and tools from . Used the new PeopleSoft tools Upgrade assistant tool extensively. applying patches and fixes and PeopleTools and Application updates for PeopleSoft FMS, SA and PA application.
• Creating test scripts (using SQR) and SQA Rational Robot scripts to converting data Student Records and FMS data.
• Interfacing the current billing and collection system with PeopleSoft FMS in order to effectively capture all revenue streams within PeopleSoft FMS.

Senior Consultant

Confidential, Fairfax, VA

Environment: SABA, Oracle 8 on Linux platform. PVCS, Clearquest

Responsibilities:

• Served as a lead technical resource during the Block 3 phase of TADLP, focused on providing the Army an automated enterprise Learning Management System (LMS).
• Lead a team for designing and developing interfaces required between Army Training Information Architecture - Migrated” (ATIA-M) and “Army Training Resource and Requirements System” (ATTRS) and the SABA driven LMS.
• Assisted in delivering a detailed design document including data mapping and specifications for stored procedures in the SABA driven Learning Management System (LMS).
• Developed technical specifications for SABA stored procedures and APIs (Application Program Interface)
• Maintained and enhanced several portal functionalities for eArmyU, Army’s Online Education project. The key enhancements include course catalog search and enrollment via the web.
• Developed new web technologies for collection of grade data from partner schools and user agreements from students.
• In addition, created a new interface program to convert course catalog and grade data provided in flat files to PeopleSoft database.
• Created a batch process (sqr program) to create userIDs and passwords for eArmyU users.
• Migrated system from PeopleTools 7.5 to 8.1 and PeopleSoft Student Administration application from 7.6 to 8.0. Ran comparison reports highlighting the differences between eArmyU’s current production and PS Vanilla 7.6. Ran Audit reports and cleaned up the discrepancies in the database. Created Unix shell scripts to run nightly batch jobs. Applied several other patches and upgrades for Student Administration. Identified and resolved other potential areas of operational improvement, which helped eArmyU save time and resources.
• Provided support to the existing PeopleSoft and custom Student Administration processes. Used AppDesigner, PeopleCode, Query, Application Engine, Mass Change, PeopleCode, Configuration Manager, Import Manager and PeopleSoft peoplecode debugging tools in development and troubleshooting extensively.
• Designed and developed procedures to enhance the functionality of the employee’s 401K contributions for PwC. This involved maintaining a separate date for 401K calculations, and using the service date for all other benefit calculations.
• Enhanced the Leave Accrual process to maintain Earned hours and Accrued hours separately to support PwC’s policy and to allow users to enter a Payout Method and Payout Rate that would give the user flexibility of choosing a different rate than their hourly rate, for the leave accrual calculations.
• Played a technical lead role in developing a proposal for implementing solutions to provide higher education to navy sailors. The solution was to derive a sophisticated distance-learning program where sailor students received education from the various partner schools of PwC.