Peoplesoft Senior Consultant
Chandrasekhararao Botcha
Email: adx1q2@r.postjobfree.com
Mobile: +1-302-***-****
Experience:
I'm a Senior Consultant with 13 years of experience in Peoplesoft Application Development, Enhancements, Upgrade, Support and Implementation for FSCM Related modules like Billing, Account Receivables, Customer Contracts, eprocurement Requisition, Purchase Order, Accounts Payables, General Ledger, Project Costing, Asset Management and Travel & Expense. I was involved in Oracle Cloud conversion project. Over the course of my career, I have demonstrated solid skills in the development of custom applications, implementation of Peoplesoft applications as a Technical Consultant and functional analyst. In these roles, I participated in all aspects of the development lifecycle contributing to the success of multiple mandates ranging in size for a number of major companies. My knowledge and skills in implementation of the PeopleSoft Application allowed me to take on the technical role for implementation of the New PeopleSoft Application.
Professional Summary:
Extensively Worked with PeopleTools like Application Designer, Application Engine, People Code, Integration Broker, File Layout, Sqr, Component Interface, AWE, Page Field Configurator and Event Mapping.
Good understanding of Database mainly Oracle 10g,SQL Developer, DB2 and Toad.
Involved in Performance tuning of applications like Application engine and Sqr programs.
Experience with People Code events, built-in functions and Methods.
Developed various Application Engine Programs as per the business requirements.
Experience in develop, tracing and debugging the SQR,Application Engine and People Code.
Modified People Code as per the requirements to implement the customer’s business rules and validations.
Worked on AWE to enable workflow for eprocurement Requisition and Purchase Order modules.
Worked on Page Field Configurator and Event Mapping as part of business requirement.
Worked on data conversions project to load the data from Peoplesoft to Oracle cloud.
Developed multiple component interfaces as part of Customer Contracts business requirement.
Involved and worked with various objects related retrofitting and fit gap analysis (part of 9.2 Upgrade).
Worked on Project Resource data to upload the relevant tables with using EXCEL to CI.
Developed, customized and modified existing records, pages, components and menus using Application Designer to meet the Business requirements of the client and expectations of the END-USER.
Extensively worked with Bug-fixing of customized applications.
Having experience in working for production support projects.
Troubleshooting issues and perform root cause analysis.
Involved in Creating New PS Queries as per requirement of end-user.
Having experience of Creating new jobs and scheduling the jobs.
Prepared Unit Test documents based on SR documents and thoroughly tested the same.
Excellent experience in system analysis activities for gathering requirements from clients, evaluating, and suggesting viable technology-based solutions to the client.
Gathered the multiple functional requirements from client and converting into technical design and developed the application.
Ability to work independently and as a part of a team with an ability to deliver within short deadlines.
A team player with strong communication, interpersonal, relationship management, analytical, and problem-solving skills, and a detail-oriented approach.
Education:
1.Bachelor of Technology in Computer Science (CSE) from Jawaharlal Nehru Technological University in 2010.
PEOPLESOFT TECHINICAL EXPOSURE:
Development Tools:
Application Designer
People Code
Application Engine
Administration Tools:
PS Security
Tree Manager
Analytic Tools:
PS Query
Process Scheduler
SQR Reports
Integration Tools:
Component Interface
File Layout
Excel to CI utility
Integration Broker
Project Summary:
PROJECT PROFILE 1:
Project Domain
IT
Project Title and Location
PNC Bank.Pittsburg, PA
Role
Techno Functional Consultant
Duration
Jul/2022 – Tilldate
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.2 PUM 33- Purchase Order, Accounts Payables, Accounts Receivables, Billing and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface,File Layout and Mainframes
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
DB2
Tools :
PeopleTools 8.59
O/s :
Windows XP Professional
Project Description:
The PNC Financial Services Group, Inc. is an American bank holding company and financial services corporation based in Pittsburgh, Pennsylvania. The Scope of project, PeopleSoft application development, interface developments and systemware reports generation using sqrs for Accounts payables, Project Costing, Asset Management and General ledger modules upon the business requirements/needs.
Also, Oracle cloud conversion from PeopleSoft. As part of project, gathered the conversion mapping details for Accounts Payables, Project Costing, Asset Management and General Ledger from Oracle cloud team and developed couple of conversion Application Engines processes to load the data into Oracle Cloud. Also developed couple of sqls to pull the data from Peoplesoft and load it into Oracle cloud by using delivered templates. As part of this project, also worked on decommissioning of PeopleSoft application components and batch processes schedules.
Roles & Responsibilities:
Extensively worked with Application Designer to Creating New Record Definitions, Pages, Components and Menus.
Involved in creating Application Engine Programs, File layout object for reading and writing from flat files by adding new sections, steps and action through Application Designer.
Design and develop complex Page, Interfaces and Reports as part of enhancement activity.
Create Technical Design Documents (TDDs) to recommend and implement system enhancements and process improvements for business applications projects.
Create application engine for interface and schedule it in Mainframe system.
Data extract for legacy data analysis.
Create SQR for data extract and sent it to external system for processing.
Work on SharePoint, Jira, Stat, Toad, SQL Developer, Putty and other tools as part of development.
Responsible for migrating the project into higher environment via project migration tools.
Work closely with business team to gather requirement and support on going prod issues.
Review of the SQL Scripts and suggesting modification in the scripts for performance.
Prepared Unit Test Plans and testing evidence document as a proof for the work done.
Created New PS Queries as part of Business requirement.
Modified People Code as per the requirements to implement the customer’s business rules and validations.
Involved in Performance tuning of applications like Application engine programs and sqr programs.
Customized Pages, Records, Components and Menu’s according to the requirements of end-user using Application Designer.
Worked on Application Designer for creating Run Control Records, Views, Pages and Components.
PROJECT PROFILE 2:
Project Domain
IT
Project Title and Location
State Farm. Bloomington,IL
Role
Senior Developer
Duration
Oct/2019 – Jul/2022
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.2 PUM 33- eProc Requisitions,Purchase Order, Accounts Payables and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface,File Layout,AWE,Page Field Configurtor,Event Mapping and Mainframes
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
DB2
Tools :
PeopleTools 8.57
O/s :
Windows XP Professional
Project Description:
State Farm is a large group of insurance and financial services companies throughout the United States with corporate headquarters in Bloomington, Illinois. The group's main business is State Farm Mutual Automobile Insurance Company, a mutual insurance firm that also owns the other State Farm companies. State Farm is ranked No. 36 on the 2018 Fortune 500 list of the largest United States corporations by total revenue.
Roles & Responsibilities:
Involved in gathering the various functional requirements and converted into technical design and developed the application as per the business requirement.
Extensively worked with Application Engine for various business requirements.
Involved and worked on AWE to enable workflow for eProcurement Requisition and Purchase Order.
Worked on Page Field Configurator to make few fields label change,make required fields and make complete page read only.
Worked on Event Mapping to write custom validations in eProcurement Requisition as part of business requirement.
Created various technical documents based on Business requirements.
Prepared Unit Test documents based on SR documents and thoroughly tested the same.
Worked on customizing the bolt on based as per business requirement.
Worded on component interface to load the data in requestor setup.
Worked upon the changes involved in SQR and Application engine programs.
Extensive work done customize the pages, Reports, creating job and jobsets.
Extensive work done write sqls to get various approvers as part of AWE.
Worked upon the changes involved in PS Queries.
PROJECT PROFILE 3:
Project Domain
IT
Project Title and Location
ANZ Bank Melbourne,AUS
Role
Techno Functional Consultant
Duration
Aug/2018 – Oct/2019
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.2 - Requisitions,Purchase Order, Accounts Payables and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface and File Layout.
Reporting Tools
Sqr and PS Query
Environment
(with skill versions)
Database :
DB2
Tools :
PeopleTools 8.56
O/s :
Windows XP Professional
Project Description
The Australia and New Zealand Banking Group Limited (ANZ) is an Australian multinational banking and financial services company headquartered in Melbourne.It is Australia's second-largest bank by assets and third-largest bank by market capitalization ANZ is one of the big four Australian banks, along with the Commonwealth Bank, National Australia Bank (NAB) and Westpac.Australian operations make up the largest part of ANZ's business, with commercial and retail banking dominating. ANZ is also the largest bank in New Zealand, where the legal entity became known as ANZ National Bank Limited in 2003 and changed to ANZ Bank New Zealand Limited in 2012.
Roles & Responsibilities:
Involved and worked with various objects related retrofitting and fit gap analysis under FSCM modules (Billing,AccountsPayables,CustomerContracts,Purchasingand Travel and Expense).
Extensively worked with compare reports to analyse and retrofit missed and changed objects respectively.
Involved and worked on Delivered Sqrretrofitting as part of 9.2 upgrade as per the Business Requirement.
Creating various SR documents based on Business requirements.
Prepared Unit Test documents based on SR documents and thoroughly tested the same.
Worked with Audits for missing and changing objects (SYSAUDIT and DDAUDIT).
Worked on GL Accounts to upload the GL Accounts related data to relevant tables with using EXCEL to CI.
Extensively worked with Application Engine,BI Publisher and PS Query Fit Gap analysis.
Worked upon the changes involved in SQR and Application engine programs.
PROJECT PROFILE 4:
Project Domain
IT
Project Title and Location
CGI Internal Project. Bangalore, IND
Role
Senior Developer
Duration
Oct/2016 – Jul/2018
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.2 - Requisitions,Purchase Order, Accounts Payables and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface, Integration Broker and File Layout.
Reporting Tools
Sqr and PS Query
Environment
(with skill versions)
Database :
Sql Developer
Tools :
PeopleTools 8.54
O/s :
Windows XP Professional
Project Description:
It is an internal project for CGI Customers. Project is in Canada and offshore people working from Bangalore for project. CGI is upgrading the project from application 8.0 application to 9.2.
As part of this project analyzed the existing 8.0 system and went through couple of meetings with LOB to finalize the new requirements. The functional documents were prepared and reviewed by a business team. Also prepared technical documents and the business required functionality was implemented in 9.2 application by retrofit of 9.2 application according to the requirements. Also developed new application engines, reports as additionally to fulfill the business needs.
Roles & Responsibilities:
Extensively worked with Application Designer to Creating New Record Definitions, Pages, Components and Menus.
Involved in creating Application Engine Programs, File layout object for reading and writing from flat files by adding new sections, steps and action through Application Designer.
Extensively worked with SQR for generating customization reports.
Extensively worked with Integration Broker to Integrate the to 9.1 RM data to 9.2 finance.
Involved to retrofit the billing delivered application and modified delivered application engine according to the business requirement. .
Finding the root causes and providing the functional solutions.
Prepared Technical Documenting PeopleSoft Application.
Extensively worked with Component Interface to load the Contracts Staging data which is reading from flat XLS file and loaded into Contract Components.
Prepared Unit Test Plans and testing evidence document as a proof for the work done.
Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval.
Created New PS Queries as part of Business requirement.
Modified People Code as per the requirements to implement the customer’s business rules and validations.
Involved in Performance tuning of applications like Application engine programs and sqr programs.
Customized Pages, Records, Components and Menu’s according to the requirements of end-user using Application Designer.
Worked on Application Designer for creating Run Control Records, Views, Pages and
Components.
PROJECT PROFILE 5
Project Domain
IT
Project Title and Location
United Services Automobile Association (USAA) PeopleSoft Application Upgrade and Enhancement. San Antonio, TX.
Role
Senior Developer
Duration
Sep/2013 –Mar/2014
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.2 –Requisitions, Purchase Order, Accounts Payables,AM,PC and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface, and File Layout.
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
Sql Developer
Tools :
PeopleTools 8.52
O/s :
Windows XP Professional
Roles & Responsibilities:
Creating various SR documents based on Business requirements.
Prepared Unit Test documents based on SR documents and thoroughly tested the same.
Worked with Audits for missing and changing objects (SYSAUDIT and DDAUDIT).
Worked on GL Accounts to upload the GL Accounts related data to relevant tables with using EXCEL to CI.
Involved and worked with various objects related retrofitting and fit gap analysis under FSCM modules (Billing,AccountsPayables,CustomerContracts,Purchasingand Travel and Expense).
Extensively worked with compare reports to analyse and retrofit missed and changed objects respectively.
Involved and worked on Delivered Sqrretrofitting as part of 9.2 upgrade as per the Business Requirement.
Extensively worked with Application Engine,BI Publisher and PS Query Fit Gap analysis.
Worked upon the changes involved in SQR and Application engine programs.
PROJECT PROFILE 6:
Project Domain
IT
Project Title and Location
Standard chartered bank.Chennai, IND
Role
Senior Developer
Duration
Mar/2014 –Sep/2016
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.0 – Billing,Accounts Receivables, Requisitions, Purchase Order, Accounts Payables and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface, and File Layout.
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
Sql Developer
Tools :
PeopleTools 8.51
O/s :
Windows XP Professional
Project Description:
Scope International Pvt. Ltd is a wholly owned subsidiary of Standard Chartered Bank. Scope International has it’s Operations in India, Malaysia and Tianjin. The Principal Business of Scope is to provide support to the Standard Chartered Bank entities globally. The support includes Transaction Processing, Software Development, Implementation, System Support, IT and Infrastructure support.
The Business processes are complex and revenue recognition has posed a significant challenge for the management. The nature of services provided to SCB entities (customers of Scope international) are heterogeneous. PeopleSoft enterprise solution is implemented in Scope and also majority of the SCB entities.
Standard Chartered for over 150 years in some of the world's fastest-growing markets aim to lead the way in Asia, Africa and the Middle East. It is leading international banking group committed to building a sustainable business over the long-term. They provide a wide-range of products and services for personal and business customers across 70 markets
Roles & Responsibilities:
Extensively worked with Application Designer to Creating New Record Definitions, Pages, Components and Menus.
Involved in creating Application Engine Programs, File layout object for reading and writing from flat files by adding new sections, steps and action through Application Designer.
Extensively worked with SQR for generating customization reports.
Finding the root causes and providing the functional solutions.
Prepared Technical Documenting PeopleSoft Application.
Involved in testing the individual components like Page, People Code.
Prepared Unit Test Plans and testing evidence document as a proof for the work done.
Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval.
Involved in Creating New PS Querys.
Modified People Code as per the requirements to implement the customer’s business rules and validations.
Involved in Performance tuning of applications like Application engine programs and sqr programs.
Customized Pages, Records, Components and Menu’s according to the requirements of end-user using Application Designer.
Worked on Application Designer for creating Run Control Records, Views, Pages and Components.
Having experience on solving user support issues for Billing and Account Receivables modules.
PROJECT PROFILE 7:
Project Domain
IT
Project Title and Location
Oracle FinancialSoftware Services, Bangalore, IND
Role
Support Analyst
Duration
Jun/2012 –Aug/2013
PeopleSoft Application Version and Modules
PeopleSoft FSCM 9.0 – Customer Contracts, Billing,Accounts Receivables, and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface, and File Layout.
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
Sql Developer
Tools :
PeopleTools 8.51
O/s :
Windows XP Professional
Project Description:
Oracle Financial Services Software Limited, majority owned by Oracle, is a world leader in providing IT solutions to the financial services industry. Oracle is the world’s largest enterprise software vendor. Oracle’s customers include ten of the top ten global banks, ten of the top ten insurance companies, ten of the top ten securities firms, five of the top five mutual fund companies and four of the top five stock exchanges.
With the experience of delivering value-based IT solutions to over 900 financial institutions in over 135 countries, Oracle Financial Services Software understands the specific challenges that financial institutions face: the need for building customer intimacy and competitive advantage through cost-effective solutions while, simultaneously, adhering to the stringent demands of a dynamic regulatory environment.
Oracle Financial Services Software offers financial services institutions the world's most comprehensive and contemporary banking applications and technology footprint that addresses their complex IT and business requirements.
Oracle Financial Services Software Limited was formerly i-flex® solutions limited.
Roles & Responsibilities:
Worked on Application Designer to Creating New Record Definitions, Pages, Components and Menus.
Extensively worked with SQR for generating customization reports.
Finding the root causes and providing the functional solutions.
Developed and made the code changes to meet the functional requirements.
Having experience on solving Production support issues for Billing and Account Receivables modules.
Involved in testing the individual components like Page, People Code.
Submitted processes to the Process Scheduler to run daily tasks at a specific time to run process recursively at a specific interval.
Involved in Creating New PS Querys.
Modified People Code as per the requirements to implement the customer’s business rules and validations.
Involved in Performance tuning of applications like Application engine programs and Other People Code programs.
Constant monitoring and performance tuning to enhance the system.
Suggesting Value adds and Process Improvements
Customized Pages, Records, Components and Menu’s according to the requirements of end-user using Application Designer.
Worked on Application Designer for creating Run Control Records, Views, Pages and Components.
PROJECT PROFILE 8:
Project Domain
IT
Project Title and Location
Cincinnati Children's Hospital,USA
Role
Programmer Analyst
Duration
July/2010 –Jun/2011
PeopleSoft Application Version and Modules
PeopleSoft FSCM 8.9 – Requisition,Accounts Payables, and General Ledger
Programming Languages
Application Designer,App Engine,People Code,Component Interface, and File Layout.
Reporting Tools
Sqr,BI Publisher and PS Query
Environment
(with skill versions)
Database :
Sql Developer
Tools :
PeopleTools 8.49
O/s :
Windows XP Professional
Project Description:
ERP Gadget consolidates commonly required features users need during their transactional processing into a convenient toolbar that can easily be deployed anywhere. You can easily configure ERP Gadget to include common functionality and processing that your users require every day. ERP Gadget s biggest advantage is that it can be configured to meet your business requirements while avoiding customizations to the standard PeopleSoft objects.
Features of ERP Gadget include:
With Simple configuration you can include only those actions you want.
Works on any standard PeopleSoft page or include it on your customized pages or on a Smart Docs page.
Contribution
Extensively worked with application designer to create new record definitions, pages, components, menus .
Developed, customized, and modified existing records, pages, components, menus, and Sub-records using Application Designer to meet the Business requirements of the client and expectations of the END-USER.
Dealt with designing, coding, developing and debugging new and existing reports, interfaces using people tools, SQL and People Code.
Involved in Configuring the ERP Gadget for the PeopleSoft delivered pages like purchase order, Voucher.
Designed Technical Documenting PeopleSoft Application.
Worked on Application Designer for creating Run Control Records, Views, Pages and Components.
Used People code to implement the required business rules and to validate the data entry process.
Prepared Unit Test Plans and testing evidence document as proof for the work done.
Added new functionality to the existing Pages using Application Designer according to the requirements of the client.
Professional Strenghts
Have high grasping ability through project experience, observation and training process.
Hardworking and dedicated worker, believe in team spirit and be it in participation.
Knack of Planning, which has enabled me to systematically meet simultaneous deadlines, without being overwhelmed.
Efficient in communicating my thoughts and planning to teammates and superiors, thereby progressing towards unified goals.
Personal Details
Name
Chandrasekhararao Botcha
Date of Birth
06/12/1987(mm/dd/yyyy)
Personal Email Id
adx1q2@r.postjobfree.com
Present Location
Charlotte,NC,USA
Contact Number