We provide IT Staff Augmentation Services!

Techno Functional Lead Consultant Resume

Reading, PA

SUMMARY

  • Around 6 years of experience in System Analysis, Design, Development, Conversion, Customization, Interfacing and Implementation of Oracle Applications (Human Resources, Talent Management, Purchasing, Financials).
  • Expertise in migration/conversions, interfacing, forms and reports customizations and testing (Unit, CRP, UAT) of applications involving Oracle Applications 10.7, 11.0.3, 11.5.x, R12 which includes Human Resource (HRMS), Employee/Manager Self Service (EMSS,MSS), Compensation Work Bench (CWB), Payroll, ADP Payroll Integration, Oracle Advance Benefits (OAB), Talent Management (OTM), Oracle Learning Management (OLMS), Purchase Order (PO), Accounts Receivable (AR), Accounts Payable (AP).
  • Active participation in Application evaluation, Process flow reviews (Technical and Code Reviews) and Requirements definitions and Maintenance.
  • Identified product gaps, coordinated with Development Team by creating TAR/SR's and obtained one-off fixes. Managed and monitored TARs for several P1 Issues. Provided on site solutions and resolved showstopper issues.
  • Expert in System Administration in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities.
  • Expert inCustomization and OAF personalization of Forms, Reports, Data Conversions, Interface development, Shell Scripting and Workflow customizations.
  • Strong knowledge of Application Object Library (AOL).
  • Strong interpersonal skills, ability to interact with people at all levels.
  • Good team player in dynamic workgroup environments.

SKILLS

Oracle Applications: Human Resource (HRMS), Talent Management, Purchasing (PO), General Ledger (GL), Payables (AP), Receivables (AR), Oracle Financials (10.7, 11.0.3, 11i) Order Management (OM) and AOL. Tools : Oracle Enterprise Manager, WEBADI, TOAD, SQL*NAVIGATOR, Developer 2000/6i/9i, Discoverer 4i/9i/10G Operating Systems:Windows XP/NT/2000/98/95, DOS 6.0/3.0, UNIX, Sun Solaris Languages : C, C++, VB, VC++, Core JAVA, SQL, PL/SQL, Shell Scripting RDBMS : Oracle 9i/ 8i/8/7.3, SQL Server, and Ms-Access. Web Technologies : HTML, XML, core Java Administration : Oracle DBA, Server Manager, SQL*Loader.

PROFESSIONAL EXPERIENCE

NOV 2009 - Present

Confidential, Reading, PA Techno Functional Lead Consultant

Confidential is one of the largest transportation services companies in North America. Penske is dedicated to providing precision solutions for all the transportation needs. Confidential, L.P., headquartered in Reading, PA, is a joint venture of Penske Corporation and General Electric. A leading global transportation services provider, the company operates more than 200,000 vehicles and serves customers from nearly 1,000 locations in the United States, Canada, Mexico, South America and Europe. The company employs over 20,000 associates.

Responsibilities:-

  • Responsible for Implementation of Third party Applicant Tracking System Taleo with integration with Oracle HR systems.
  • Gathered requirements for data mappings to store candidate profiles and also manage talent management profile information.
  • Data migration from old custom application to Oracle.
  • Data Export from Oracle HR Systems to Taleo for candidate import.
  • Involved in developing interface for Organizations, Locations, Positions, Candidate profiles, Employees, Departments and Approvers.
  • Involving in building TCC scripts for integration mappings.

Environment: Oracle Applications 11.5.10.2, (HRMS, EMSS, MSS, Compensation Workbench, Advanced benefits, Payroll, I-procurement, I-Expenses, AR, AP, PO, GL), Developer 2000/6i/9i/10g, SQL*Loader, PL/SQL, Forms6i, Reports2.5/4.5, OracleBI Discoverer 10.1.2.50.050, UNIX.

Confidential, Jersey City, NJ JUL 2009 - SEP 2009 Techno Functional Lead Consultant

  • Confidential, formerly ADP Brokerage Services Group, with nearly $2.0 billion in revenues and more than 40 years of experience, is a provider of technology-based outsourcing solutions to the financial services industry. Their integrated systems and services include investor communication, securities processing, and clearing and outsourcing solutions.
  • Confidential Project includes support for setup of Performance management plans for FY10 and Production support for HRMS and compensation workbench. Involved in writing fast formulas and also performing OA Framework personalization's as per the user and business requirements.

Responsibilities:

  • Modified Existing setups and performed additional setup for setting up performance management plans for FY10.
  • Involved in setup of Rating Scales, Competency, Objective, Appraisal templates, Locations etc.,
  • Did personalization using OAF on Employee/Manager Self Service for performance management plan as per user requirement as part of fiscal year 2010.
  • Worked on gathering requirement and also rolling out Manager and Employee Self Service functionalities.
  • Involved in Workflow administration for processing Appraisals and also modifying the notification in the workflow.
  • Involved in setup of Employee Statements and open enrollments in Compensation Work Bench, OAB and writing fast formulas for eligibility criteria advance benefits of stock options are per client requirement.
  • Involved in System Administration for creating New Menus, new Responsibilities, new functions, User Authentication security system profiles, etc.
  • Provided daily support for HRMS and Compensation users.
  • Design and Developed custom report as per end-user requirement in Discoverer.
  • Interacted with DBAs in solving Production issues.
  • Involved in defining the mapping fields of recruitment system (Virtual Edge ADP).
  • Support custom interface to ADP Payroll and also Benefits.
  • Involved in Business group setups for HR business Group.
  • Identified R12 upgrade enhancements and involved in upgrade of development instances.

Environment: Oracle Applications 11.5.10.2, R12 upgrade (HRMS, EMSS, MSS, Compensation Workbench, Advanced benefits, Payroll, I-procurement, I-Expenses, AR, AP, PO, GL), Developer 2000/6i/9i/10g, SQL*Loader, PL/SQL, Forms6i, Reports2.5/4.5, OracleBI Discoverer 10.1.2.50.050, UNIX.

Oct 2007 - Jun 2009

Confidential, Reading, PA Techno Functional Lead Consultant

Confidential is one of the largest transportation services companies in North America. Penske is dedicated to providing precision solutions for all the transportation needs. Confidential, L.P., headquartered in Reading, PA, is a joint venture of Penske Corporation and General Electric. A leading global transportation services provider, the company operates more than 200,000 vehicles and serves customers from nearly 1,000 locations in the United States, Canada, Mexico, South America and Europe. The company employs over 20,000 associates.

PROJECT 1: Project Name: Upgrade Oracle Applications HRMS 11.5.10 RUP2, OTA J, and Discoverer Upgrade 10G. Project Type: Oracle Upgrade Project Role: Functional/Technical Lead Consultant Responsible for:

  • Pre Upgrade Activities:
    • Identified the new features and deprecated features.
    • Identified the changes required to the existing interfaces and shell scripts.
    • Developed IT /User Test scripts.
    • Identified the interfaced systems and the changes to be incorporated at connectivity and configuration levels.
  • Preparation of the Communication Plan and the Roll out Strategy for the Upgrade
    • Developed the Plan to communicate to all of the employees in Corp and at field about the upgrade, new changes and about the down time.
    • Designed an elaborate Roll out Strategy for the upgrade, post upgrade activities.
  • Carried out Testing
  • Post Upgrade Activities
    • Update the required changes to the interfaces.
    • Schedule of the concurrent requests and update of the shell scripts.
    • Data Synchronization for the parallel run time and the down time
    • Configuration Changes - Personalization's.
    • Responsible for the smooth operation of the application after the upgrade.

PROJECT 2:

Project Name: Data conversion of Oracle Learning Management System for GE Penske Truck Leasing Corp. from legacy system. Project Type: Oracle Conversions Role: Functional/Technical Lead Consultant Responsible for:

  • Coordinated with users for Gathering Requirements.
  • Preparation of Proposal and Project Plan for 11.5.10 OLMS
  • Studied the Legacy System and Architected the best fit Configurations to the Organization
  • Keeping in view the Organization Hierarchy, Methods followed the Training Needs and the short falls of the Legacy System and with the domain expertise, designed a best-fit Catalog Structure and the Setup Configurations required for the Maintenance Department of Oracle ERP Training Module.
  • Did data migration standard using WEBADI functionality of oracle.
  • Carried out User Acceptance Test (UAT)
  • Configured Setups in Production.
  • Documentation according to AIM Methodology.
  • Carried out Self Service Personalization's for the entire Learner Self Service, Learner Manager and Learning Administration Pages.

PROJECT 3:

Project Name: Oracle - ADP PeopleSoft Payroll Interface Project Project Type: Oracle Interface. Role: Project Manager/Functional/Technical Lead Consultant Responsible for:

  • Understanding the data flow in people soft HR/Payroll system and design and develop interface between Oracle HR system to ADP HR/Payroll People Soft ERP systems accordingly.
  • Migrating fields that are required for Payroll Information to Oracle HRMS system such as 401K Enrollment Date, State tax etc.,
  • Developed Process for Interface between Oracle and ADP for sending truly changes to ADP (PS) from oracle system for payroll processing.
  • Utilized ETL Tool for faster completion of the project.
  • Provided reports for end-user for easy troubleshooting.
  • Developed Alerts for record and Job Failures.

PROJECT 4:

Project Name: Implementation of Oracle Talent management (PCM) at Penske Truck Leasing Corp. Project Type: Oracle Implementation. Role: Functional/Technical Lead Consultant Responsible for:

  • Carried out requirement analysis for the implementation of Talent management
  • Collected all requirements through Questionnaires.
  • Prepared the Proposal and the project Plan for Oracle Talent management Implementation.
  • Made Estimation of the Cost, Effort and the Resource utility along with the Timelines.
  • Configure HRMS Setups for Objectives, Appraisals, questionnaire and Job Competencies, Performance ratings.
  • Wrote custom PLSQL fast formulas according to the business needs.
  • Did personalization's on ESS/MSS self service and extension using OAF.
  • Design the Test scripts for User Testing.
  • Configuration of Setups in Production.
  • Configured Interfaces to handle custom application feed.
  • Transition to Go Live

PROJECT 5:

Period: 04 October 2007 to till date Project Name: Penske Oracle Applications General Support Project Type: Oracle Development/Production Support Role: Functional Lead/ Technical Lead Responsible for:

  • Presently involved in oracle HRMS and payroll implementation production support
  • Preparation of discover reports and documentation for the customized codes.
  • Worked on providing self service functionality to manager and employees reducing the HRIS team efforts.
  • Involved in gather and designing absence management using oracle core functionality.
  • Fixed the general oracle bugs/issues registered by the users thru the Clientele System and carry out day to day mass updates through webADI
  • Carry out changes to interfaces to fix new requirements/bugs and created Blobs for outbound interface feeds.
  • Gathered requirements and did system design analysis for Oracle I-recruitment and also OAB for COBRA, Aetna.
  • Worked on setup of plans, Program types, and life events in OAB.
  • Build Report using view and gave access to the user's using WEBADI functionality.
  • Carried out Year End Processing for 2007 and 2008 for:Grade changes, Grade Rate changes, Assignment changes, Performance Updates, Salary Changes, Benefit Changes, and Creating New Elements and mass uploads
  • Migrated and modified discoverer reports of 9i database to 10G discoverer version.
  • Environment: Oracle Applications 11.5.10.2, (HRMS, EMSS, MSS, Compensation Workbench, Advanced benefits, Payroll, I-procurement, I-Expenses, AR, AP, PO, GL), Developer 2000/6i/9i/10g, SQL*Loader, PL/SQL, Forms6i, Reports2.5/4.5, OracleBI Discoverer 10.1.2.50.050, UNIX.

    Confidential, Boston, MA Apr 2007 - Sep 2007 Technical Lead Consultant

    • Confidential is a leading biotechnology company committed to the discovery and development of small molecule drugs for serious diseases. Confidential Project includes support for upgrade for 11i. Involved in customizing the Oracle System including the interface programs, reports and forms personalization's as per the user and business requirements.
    • Responsibilities:
    • Modified Custom Interface between web based Order Management systems VICI to Oracle Order Management.
    • Involved in Scrambling the HRMS records in test instances after cloning the data
    • Involved in upgrade of family pack K for 11.5.10.
    • Did personalization of Receipts PUI forms using Oracle provided Personalization functionality as per user requirement as part post of upgrade steps.
    • Involved in Workflow administration for processing Requisition and Purchase orders.
    • Involved in designing and developing Packages for Auto User Account creation in oracle from HRMS Data and Scrambling Local login password for end user.
    • Wrote a package for scrambling the HRMS records in test instances after cloning the data
    • Involved in System Administration for creating New Menus, new Responsibilities, new functions, User Authentication security system profiles, etc.
    • Provided daily support for Purchasing, Receiving users.
    • Interacted with DBAs in creating new test instances and solving many Production issues.
    • Designed, developed and documented many alerts for Purchase order of certain amount basis approvals and also designed alerts as per End user required alerts using Alert Manager Responsibility.

    Functional

    • Involved in setting up punch out stores in I-procurement
    • Did Smart forms in I-procurement for a Non-Catalog request as per user requirement

    Environment: Oracle Applications 11.5.10.2 (HRMS, EMSS, MSS, Payroll, Advanced benefits, I-procurement, I-Expenses, AR, AP, PO, GL), Developer 2000/6i/9i/10g, SQL*Loader, PL/SQL, Forms6i, Reports2.5/4.5, OracleBI Discoverer 10.1.2.50.050, UNIX.

    Confidential July 2006 - Mar 2007 Technical Consultant

    CTB McGraw- Hill is the leading publisher of standardized achievement tests for children and adults. CTB assist thousands of school districts across the nation and score more than 30 million test documents each year. The objective of the project was to upgrade from 11.5.4 to 11.5.8 and implemented New Modules

    Responsibilities:

    • Engaged in setting up of complete work structures: (organizations, jobs, positions, grades, pay scales with scale rates, position hierarchies).
    • Engaged in implementing competency-based approach for competency assessment and legacy appraisal system of for non-supervisory staff in Talent management.
    • Setups for compensation workbench.
    • SSHR setup of personal, professional employee information, Special information views, training history, assessment formats, Assignment history.
    • Setting up of security profiles, users and responsibilities based on position hierarchy security approach.
    • Configuration of requirements for Data migration using API's and data loader.
    • Complete set-ups for Oracle Training Administration.
    • Wrote fast formula, Alerts and triggers for Appraisal system for annual based review system.
    • Specifications for HRMS Reports and defining of Letter Generations
    • Project Solutions provided include deliverables on Methodology for Implementing Re-engineered Competency.
    • Impact and Gap Analysis on HRMS and Self Service Web Applications
    • Prepared Functional Specifications for forms and reports.
    • Implementation of Self Service Human Resource at client location
    • Training to Business Team and end users.
    • Preparation of Documentation (BR100, MD70, MD50 etc) using AIM Methodology.

    Environment: Oracle Applications 11.5.4/11.5.8 (HRMS, OLMS, Payroll), Oracle 8.0.5, Developer 2000, SQL*Loader, PL/SQL, Forms4.5, Reports2.5/4.5, Sun Solaris

    Confidential July 2005 - June 2006 Technical Consultant The project involves the upgrade and conversion of Oracle HR Payroll Rel 10.7 to Release 11i. Involved in customizing the Oracle System including the interface programs, reports and forms as per the user and business requirements, Customizing and developing several reports using Oracle Reports.

    Responsibilities:

    • Designed and developed Staging tables, Conversion routines, and Custom PL/SQL API for Employees, Employee Addresses, Jobs, Positions, Assignment set, Element Set, Element Link, Element, Earnings, Deductions, Benefit Contributions, Absence Types etcfrom PeopleSoft legacy system.
    • Designing and developing Proto Type Data Migration Process to test load legacy sample data.
    • Conversion of certain 6i reports developed in 10.7 to 11i, Design and development of migration scripts for all activates of HRMS and Payroll migration
    • Researching and analyzing the HR and Payroll legacy volume transactions and possible impact on one time Conversion Process under existing data transport mechanism.
    • Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
    • Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
    • Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
    • Developed PL/SQL Scripts/Packages fast formulas for Benefits, Compensation Work Bench and Payroll Interface
    • Tuning of customized application including reports and back end programs by using different application tuning techniques.
    • Developing Documentation Templates such as Data Mapping, Functional, Technical and Testing

    Environment: HP-UX 11, PeopleSoft, Oracle Applications 11i/10.7, GL, AR, AP, AOL, Forms 6i and Reports 6i, PL/SQL, SQL*Loader, SQL*Plus, TOAD, UNIX, Shell scripts.

    Confidential, Hyderabad, INDIA May 2003 - DEC 2004 Technical Consultant

    Responsibilities:

    • Wrote MD70, CV40 Documents for Data Conversions.
    • Designed, developed and documented for Conversion of Employees, Employees addresses, Jobs, Positions, Employee benefits, and Salary History.
    • Wrote MD70, CV40 Documents for Data Conversions.
    • Designed Staging Tables, Conversion Routines, and Custom PL/SQL API for conversion of Employees, Employees addresses, Jobs, Positions, Employee benefits, and Salary History.
    • Developed various reports such as head count reports with reference to employments report.
    • Designed and developed an Interface between Oracle HRMS to ADP for Payroll Processing.
    • Wrote MD70 document for HRMS to ADP Interface.
    • Defined Payroll Periods, Elements, Pay Groups etc.,
    • Validated the data and populated the Payables interface table through a Concurrent program which in turn submits a standard Payables Interface program.
    • Involved in EEO Report Customization.

    Environment: Oracle Applications 11.5.3 (AR, AP, GL, PO, HRMS, Payroll), Oracle 8.0.5, Developer 2000, SQL*Loader, PL/SQL, Forms4.5, Reports2.5/4.5, Sun Solaris

    EDUCATION:

    MBA MS Computer Engineering BE Computer Science & Engineering

    Hire Now