Experience Details:

Role: Technical consultant.

Responsibilities:

• Support the Finance and SCM system on day to day issues.
• Worked on Subsystem to GL System Reconciliation.
• Resolved lot of issue in Procurement Contracts.
• Worked on Enhancements in Finance and SCM.

Technical Environment:

PeopleSoft Applications: PeopleSoft FSCM 9.1

People Tools: 8.53.09

Application Designer, People Code, Application Engine, File Layout, Component Interface, Application Packages, Integration Broker, AWE, XML Publisher, SQR, PS Query.

Database: Oracle.

Confidential

Role: Technical consultant.

Responsibilities:

• Develop the reports using PS Query and XML Publisher Reports.
• Help the team in Excel to CI Uploads.
• Give PS Query training to end users.
• Support AP and Payroll Modules.

Technical Environment:

PeopleSoft Applications: PeopleSoft FSCM 9.2, PeopleSoft HCM 9.1

People Tools: 8.53.06, 8.52.12

Application Designer, People Code, Component Interface, XML Publisher, PS Query

Database: Oracle.

Role: Technical consultant.

Responsibilities:

• Co-ordinated with offshore team.
• Worked on IMS21 replacement enhancement. Consumed WebService from Sharepoint and moved peoplesoft GL, AP, AR attachments to sharepoint.
• Worked on in-house print checks. Providing CFO signature based on Business Unit.
• Worked on custom positive pay file for Wells Fargo bank.
• Worked on Project Costing enhancement where project should not be made inactive if there is any open requisitions, purchase orders or pending payments.
• Working on concur integration with PeopleSoft. Concur is a third party tool which is used for travel and expenses.
• Tuned queries as they are taking lot of time in Production.
• Solved critical issues in Production like

1. AM DEPR CALC failure because of not populating in service date by user as part of Mass transfer of assets.
2. Multiple issues in Excel to CI upload on GL, AP and AM modules.
3. In E-Procurement, count search results are not accurate if verity search is used. Also, verity index page is showing different pages through Add and Update modes.
4. Fixed the process which is going to send data to Hyperion database.
5. Fixed the issues in Mass Change program of AP which will update the vouchers in process flag if process fails.

• Wrote scripts as business needs to execute in Production.

Technical Environment:

PeopleSoft Applications: PeopleSoft FSCM 9.1

People Tools: 8.51.07

Application Designer, People Code, Application Engine, , File Layout, Component Interface, Application Packages, Integration Broker, XML Publisher, SQR, PS Query, Crystal Report, nVision, Change Assistant

Other Tools: UC4 and Phire.

Database: Oracle.

Role: Technical consultant.

Responsibilities:

• Need to do reconciliation of data in PeopleSoft FSCM and HCM systems. Find out the root cause of data inconsistency by analyzing the processes and related tables. Generate error files data inconsistency information , Processes to fix data issues.
• Reconcile the data between paycheck tables like PAY CHECK, PAY EARNINGS, PAY DEDUCTION, PAY TAX with paycheck distribution tables like PAY ERN DISTRIB, PAY DED DISTRIB and PAY TAX DISTRIB.
• After that reconciliation of distribution tables data with HR ACCTG LINE of HR Database.
• Reconciliation of HR ACCTG LINE of HR database with HR ACCTG LINE of FSCM database.

Technical Environment:

PeopleSoft Applications: PeopleSoft Finance 9.1 and PeopleSoft HCM 9.1

People Tools: 8.51

Application Designer, People Code, Application Engine, , File Layout, Component Interface, Application Packages, Integration Broker, XML Publisher, SQR, PS Query, Crystal Report, nVision, Change Assistant

Database: Oracle.

Role: Technical consultant.

Responsibilities:

• Working as a HCM Technical lead developer.
• Retrofitted the customizations and added new functionality based on new enhancement requirements in Core HR Workforce Admin , Position Management, Payroll, Benefits, Benefit Administration, Time Labor.
• Worked closely with the business users in gathering the requirements and documenting them and creating technical specs for the same.
• Helped Admin on Upgrade process and running scripts through Change Assistant.
• Some of the items worked in Ensco are
• Retrofitted Pay Advice and Pay Check Program in addition to the retrofits related to customizations, reports and interfaces.
• Applied tax updates.
• Worked on new interfaces like Contractor data import from Rigs into HCM system, HCM System to Finance and ELM systems, Sending back Contract data with emplid's contingent worker ids to preferred vendors. Also, Audit report on Contractors which can be viewed by HRIS team and offshore Rig teams.

Technical Environment:

PeopleSoft Applications: PeopleSoft HCM 8.9/9.1, Finance 8.9/9.1.

People Tools: Tools 8.49 and 8.52

Application Designer, People Code, Application Engine, File Layout, Component Interface, Application Packages, AWE, Integration Broker, XML Publisher, SQR, PS Query, Crystal Report.

Database: SQL server.

Role: Technical Consultant.

Responsibilities:

• Worked as a Technical Lead Developer on EPM and Finance side.
• Worked on conversions, interfaces, Reports and enhancements for EPM and Finance. Involved in design of templates and methodology to integrate PS EPM information with BlackLine on Demand.
• Worked on enhancement for BlackLine Integration. Client is using Blackline to do Account Reconciliation. Every day, Account information need to send BlackLine on Cloud. As per client needs, Account reconciliation needs to be done at various levels like Account, Subaccount, Deptid, Project, Product based on Account type. Custom page is going to hold which level of reconciliation to be done for each account. Also, created other pages to maintain Setid, Account Range, Year and Month information for which data to be extracted.
• Worked on Bloomberg Exchange Rate interface. App Engine program is going to send SOAP message to get exchange rates. After getting rates, those will be loaded into PS RT RATE TBL based on CURR QUOTE TBL.
• Worked on GL Conversion to bring ledger balances into finance system from Constellation Energy Group.
• Created multiple temp tables in EPM system to support parallel processing.
• Performed extensive debugging and performance tuning of various processes. Well versed in utilizing tools and utilities provided by PeopleSoft Debugger, tracing etc for trouble shooting issues on PeopleCode, Application Engine, COBOL, SQR's Online.

Technical Environment:

PeopleSoft Applications: PeopleSoft EPM 8.8, PeopleSoft Finance 8.9

People Tools: Tools 8.49

Application Designer, People Code, Application Engine, File Layout, Application Packages, Integration Broker, PS Query

Database: Oracle

Role: Technical Consultant.

Responsibilities:

• Created lot of reports using XMLP using Connected Queries and XML files.
• Developed around 20 nVision Reports in Finance GL module which have lot of VBA Macros. Provided some of the report names below.
• Pledging and Repos Report - This return provides the Office of the Superintendent of Financial Institutions with information relating to the nature and extent of pledging undertaken by the deposit-taking institution.
• Details of Operating Expenses Corporate IFRS - This report provides a more detailed view of Total Non-Interest Expenses. The level of detail is still summarized and does not show details at the detailed account level. It reflects day-over-day adjustments.
• Details of Fee and Commission Income and Other Operating Income Corporate IFRS - This report provides a more detailed view of Other Operating Income. The level of detail is still summarized and does not show details at the detailed account level. It reflects day-over-day adjustments.
• Profit Close Out - Subsidiaries Report - Identify the subs profit closeout from minor currency to reporting currency.

Technical Environment:

PeopleSoft Applications: PeopleSoft FSCM 9.1

People Tools: Tools 8.50

PS nVision, PS Query, Excel VBA

Database: Oracle