Oracle Technology Consultant Resume
SUMMARY:
- He holds a bachelor of technology degree in computer science and engineering. He has technical expertise in PeopleSoft 9.2/9.1/9.0/8.9 and People Tools 8.49, 8.50, 8.51, 8.52, 8.53, 8.54 and 8.55.
- He has worked with tools like application designer, People Code, PS Queries, application engine, application packages, component interfaces, XMLP, Integration Broker, Approval work flow, web services, file layout, Smart HR templates and structured query report.
- Confidential has good functional understanding in Core HRMS, Benefits, Employee Self Service, Manager Self Service, Compensation, ePerformance, Enterprise Learning Management, Recruiting Solutions, North American Payroll, Time and Labor, Absence Management, Pension Administration, Accounts Payable, Accounts Receivable and General Ledger. He has a good understanding in UNIX scripts and Java scripts.
- He has served on all areas of the PeopleSoft framework such as implementation, maintenance and upgrade (Fit - Gap Analysis) including Quality assurance.
- Confidential has got technical expertise in Workday technologies such as EIBs (Enterprise interface builder), calculated fields, custom reports, Studio (for inbound and outbound) and XSLT transformations.
- And he has good functional understanding in Workday Core HCM Concepts such as Organizations Structure, Staffing Models, Jobs and Positions, Compensation, Security Group, Business Processes, Payroll, Time Tracking, Leave of Absence and Benefits
- Confidential has also worked in Oracle SOA Suite implementation project which involved solutions design, business analysis and development.
- He has got trained on ‘Oracle Fusion HCM Cloud Service Implementation’ as well.
TECHNOLOGY CAPABILITIES:
Industry Competencies: Banking, Public Sector, Electric Utility and Retail Sector
Business Competencies: HCM/FSCM 8.9, 9.1 and 9.2, Workday 30
Technical Competencies: People Tools 8.46, 8.50 8.51,8.52,8.54 and 8.55, Application Designer, PeopleCode, Application Engine, Application PackagesFile Layout, Component Interface, Workflow, Excel to CIPS Query, Data Mover Scripts, AWE, SOA Suite 11g, BPEL, web services, XMLP, Html, Java Script, Integration BrokerWork flow, Database Triggers, Workday Studio, XSLT
Functional Competencies: Core HRMS, Benefits, Employee Self Service, Manager Self Service, Compensation, ePerformance, Enterprise Learning ManagementRecruiting Solutions, North American Payroll, General Ledger Pension Administration, Accounts Payable, Accounts Receivable Time and Labor, Absence Management
Database: Oracle
Programming Languages: SQL, PeopleCode (PeopleSoft)
ERP: PeopleSoft, Oracle Fusion, Workday
Reporting tools: Workday Reporting tool, SQR and PS-Query.
PROFESSIONAL AND BUSINESS EXPERIENCE:
Confidential
Oracle Technology Consultant
Responsibilities:
- Co-ordinated with client functional and development team to review requirements in functional design documents, providing clarifications and technical feasibility of proposed solution.
- Consulting with the client functional team or end users of organizational units to analyze current operational procedures, identifying problems, and understanding specific requirements such as forms of data input, how data will be summarized and used, formats for reports, etc.
- Analyzing the key functions in the legacy systems (TDS and RCS systems), and map them to NYCHA’s current systems such as Oracle Siebel and Oracle EBS, and determining where custom requirements are needed and configurations should be made
- Identifying the data fields/elements that are being transmitted from/to the legacy systems by analyzing database triggers, stored procedures and inbound/outbound interface programs among legacy systems, Oracle systems (Siebel and EBS) and third party vendors and mapping those data fields to the corresponding future state interfaces.
- Performing Fit gap analysis and suggesting work around and customizations for gaps identified.
- Conduct executive visioning sessions, develop To-Be process flows and use cases, gather business requirements, and determine recommendations for the future state Oracle system design.
- Providing project management services as needed for the execution of the engagement
Confidential
PeopleSoft Consultant
Responsibilities:
- Co-ordinated with client functional and development team to review requirements in functional design documents, providing clarifications and technical feasibility of proposed solution.
- Provided recommendations during FIT Gap analysis / Requirement gathering phase
- Reviewed the deliverables such as SOW, Scope document, Project Plan, Functional specification documents, Technical specification documents, Test plan, Test scripts etc. and make sure all the deliverables follows industry best practices
- Attend all the functional and technical meetings and keep track of all the major milestones per the project plan
- Performed testing during various SIT and UAT cycles
- Participated in the core development process and in the software development activities (Build) and testing (Unit testing) consistent with Software Quality Review standards
- Reported on-the-ground condition of the project and highlighted numerous risks and issues, as well as provided recommended mitigation plans
Confidential
Technical Lead
Responsibilities:
- Created the Technical Design Specifications consistent with the Confidential ’s Delivery Methodology
- Determined the design approach to satisfy the Functional Requirements and to comply with the Development Standards
- Created/Modified PeopleSoft components/Pages to store Confidential Partners and their leaders information in PeopleSoft HR system
- Created App engine to automate and maintain Confidential Partners and their corresponding leader relationships using PeopleSoft Audits and Database triggers
- Created an interface to send Confidential Partners and their leader relationship details from PeopleSoft HR system to Fusion system
- Created reports using PS queries
- Performed unit and system testing.
- Remediated software code defects discovered during testing cycles
Confidential
PeopleSoft Consultant
Responsibilities:
- Co-ordinated with client functional and development team to review requirements in functional design documents, providing clarifications and technical feasibility of proposed solution.
- Provide recommendations during FIT Gap analysis / Requirement gathering phase
- Review the deliverables such as SOW, Scope document, Project Plan, Functional specification documents, Technical specification documents, Test plan, Test scripts etc. and make sure all the deliverables follows industry best practices
- Attend all the functional and technical meetings and keep track of all the major milestones per the project plan
- Perform testing during various SIT and UAT cycles
- Participated in the core development process and in the software development activities (Build) and testing (Unit testing) consistent with Software Quality Review standards
- Guided the end-users from the design phase through the configuration and testing of the new PeopleSoft Payroll and Time and Labor system.
- Reported on-the-ground condition of the project and highlighted numerous risks and issues, as well as provided recommended mitigation plans
Confidential
Technical Consultant/Onsite Coordinator
Responsibilities:
- Co-ordinated with client functional and offshore development team to review requirements in functional design documents, providing clarifications and technical feasibility of proposed solution.
- Reviewed delivered projects, objects and technical design documents.
- Reviewed test scripts for Unit and System testing.
- Managed defects by assigning them to developers for timely resolutions during SIT and UAT phases.
- Worked on IB configuration and created custom service operations for interfaces.
- Created mapping documents for HR, Benefits, Payroll and Self-service reports and queries
- Customized various SQR’s which were running using Shell scripts.
- Customized various components, pages, records, People code, app engine, PS Query based on client requirements.
- Remediated defects discovered during testing cycles
Confidential
Technical Consultant/Onsite Coordinator
Responsibilities:
- Participated in the core development process and in the software development activities (Build) and testing (Unit testing) consistent with Software Quality Review standards
- Implemented Auto Save functionality in PeopleSoft ePerformance module
- Resolved JavaScript/HTML issues related to PeopleSoft rich text editor functionality on the long edit box on the ePerformance screens
- Involved in retrofit activities of existing interfaces, enhancement and reports (SQRs, Application Engine, and Integration Broker) from 8.9 to 9.2
- Involved in Fit Gap analysis
- Performed unit and system testing.
- Involved in the direct discussion with the clients on resolving functional issues.
- Involved in customizations of HR modules.
- Developed many complex Benefits, HR and Payroll inbound and outbound interfaces.
- Created test scripts for Unit and System testing.
Confidential
Technical Consultant
Responsibilities:
- Co-ordinated with functional team to review functional configuration documents and provide technical feasibility of proposed solution.
- Worked on conversion programs to convert retiree benefits data into PeopleSoft.
- Configured, designed and developed custom MSS transaction and respective workflows using AWE.
- Configured, designed and developed custom bolt on module for retiree medical benefits. The bolt on module included set up and transaction components, processes, interfaces and conversions.
- Developed Self-service transaction components for enrolling and cancelling into retiree medical benefits bolt on module.
- Developed many complex Benefits, HR and Payroll inbound and outbound interfaces.
- Developed extensions and created respective TDDs and mapping documents for various extension requirements.
- Created test scripts for Unit and System testing.
- Involved in the direct discussion with the clients on resolving functional issues.
Confidential
Technical Consultant
Responsibilities:
- Created various interfaces among CC&B, G4, Oracle EBS and third party Vendors using oracle BPEL (SOA).
- Creating the Technical Design Specifications consistent with the Confidential ’s Delivery Methodology
- Performing unit and system testing.
- Remediating software code defects discovered during testing cycles.
Confidential
PeopleSoft Tech team Developer
Responsibilities:
- Design and Development of the SOA composite application using JDeveloper.
- Created web services using PeopleSoft.
- Created the Technical Design Specifications based on the POC's and performed unit testing.
Confidential
PeopleSoft Tech team Developer
Responsibilities:
- Participated in the core development process and in the software development activities (Build) and testing (Unit testing) consistent with Software Quality Review standards
- Configured Approval Workflow Engine workflows for approval of self-service modules such as Employee Termination.
- Created XMLP reports for employee benefit confirmation to replace the delivered BAS005 process.
- Successfully conducted the feasibility study of HIPPA process to replace the custom process in older version
- Created inbound interfaces using application engine and component interface for large batches of payroll data.
- Worked with functional teams to prepare functional configuration documents.
- Created functional, technical design and mapping documents for various requirements.
- Created test scripts for unit and system testing.
- Involved in customizations of HR and FSCM domains.
Confidential
Systems Engineer
Responsibilities:
- Performed requirement gathering.
- Planned and managed the development efforts of deliverables to the client
- Conducted impact analysis on existing pension system
- Developed the application using PeopleCode, application designer and SQR.
- Created inbound and outbound interfaces using application engine and component interface.
- Performed unit testing and provided support for conducting user acceptance testing.
- Prepared test cases, functional and technical specification documents.
- Conducted internal quality assessments.
- Provided production support.
Confidential
Systems Engineer
Responsibilities:
- Planned and managed development efforts.
- Performed requirement gathering.
- Performed application development using PeopleCode, application designer, application engine, component interface and SQR.
- Performed unit testing and provided support for conducting user acceptance testing.
- Prepared test cases, functional and technical specification documents.
- Performed internal quality assessments.
Confidential
Systems Engineer
Responsibilities:
- Involved in preparing the technical specification documents. Modified the business processes in the North American payroll and pension system as per the requirements of users.
- Interacted with core business users to gather requirements for change requests.
- Provided user support.
- Performed internal quality assessments.
- Performed unit and system integration testing.
- Prepared test cases, functional and technical specification documents.
- Monitored batch jobs and performed troubleshooting, in case of any failure.
- Identified key improvement areas in the Payroll/Pension system and automated manual processes which involved in the same.
- Worked exclusively on Application Engine and SQRs.
