Oracle Manager
Resume:
Srinivasa ************@*****.***
Professional Summary:
** ***** ** ********** ** an IT Professional in implementation, enhancement and support of Oracle
•
Apps 12i & 11i HRMS E-Business Suite HCM modules (HR, OAB, OPM, Compensation workbench,
Payroll,OTL, Self Service and Workflow) and custom oracle Applications.
Experience in System Analysis, Requirement Study, Specification Generation, Test Plan Preparation,
•
Unit Testing, System Integration Testing, CRP and UAT.
Extensive experience is running OPEN Enrollments and troubleshooting production issues.
•
Extensive experience in AIM Documents creation and designing conversion programs, interface
•
programs, reports and workflow customizations.
Created and maintained Application Responsibilities, Users, Concurrent Programs, Menus, Security
•
Profiles, Flex fields and Value Sets in Oracle HRMS, OAB and Payroll Modules.
Expertise in SQL, JAVA and PL/SQL in writing stored procedures, functions, Reports, Fast Formulas,
•
Web-ADI and packages to validate the inbound and outbound data between the Oracle Applications and
third party systems and UNIX shell scripting.
Extensive knowledge and experience in developing and customizing Oracle Self Service application
•
using OA Framework
Ability to troubleshoot Oracle Application Issues regarding setups, flex fields, value sets, concurrent
•
manager processing etc.
Experience of end-to-end HRMS implementations and post-production support and SOX compliance.
•
Technical Skills:
ERP Applications (12.1.2, 11.5.10.2,11.5.10, 11.5.9, 11.0.5)
E-Business suite
HR, OAB, OTL, OPM, CWB, SSHR, SYSADMIN
Modules
RDBMS Oracle v 11g, 10g, 9i, 8i
Operating Systems LINUX, Sun-Solaris, Unix, Windows 9X/2K/XP
Languages SQL, PL/SQL, C, C++, Java
Forms 6i/9i, Reports 6i/2.5, SQL*Loader, Jdeveloper, Oracle Workflow
Tools & Utilities
Builder, TOAD and SQL*Plus, XML Publisher, MS Visio.
Hardware HP 9000, Intel Pentium based PC’s
Documentation AIM Documentation (MD50, MD70, MD120,CV60,CV40)
Professional Work Experience:
Aleris – Cleveland, OH Feb 2011 – Till date
Oracle Apps Techno-Functional
Responsibilities:
Primary responsibility involves system study, Requirements Gathering, preparing functional specs,
•
Conversion Design, Test script documents, User Manuals and Business Process documents.
Setup functions, Menus, Responsibilities, and Request groups and performed other System admin
•
responsibilities.
Setup Oracle HRMS Advance Benefits by establishing Elements for various Benefit Plans,
•
Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the
Customizations in OAB and modified the Configurations at different levels to follow Oracle rules and
hierarchy of Eligibility and Electability rules.
Setup Performance management for yearly appraisals.
•
Setup Global Compensation workbench for Salary increase, Bonus and performance awards for US,
•
CA, MX, UK, China and Germany business groups.
Documented the setup specification using AIM - BR0100 as setup document for deliverable.
•
Designed Talent Profile/Succession Planning Webpages where Managers and Employee can access
•
their functions like Adding/Modifying Qualification, Benefits, Employee assignments, Salary,
Performance and Objectives
Setup Manager and Employee Self Service.
•
Personalized OAB Pages where employees can change their benefits and Elect benefits during
•
Open Enrollments.
Workflow administration and trouble shooting of approvals.
•
Defined various security profiles based on business requirements.
•
Writing Business requirements for offshore teams and validating the work deliverables.
•
Customized Webpages using Oracle JDeveloper.
•
Wrote fast formulae to make employees eligible for performance, compensation and benefits
•
TAR Creation and follow-ups using Metalink.
•
Environment: Windows, Oracle 11g, Oracle Applications 12.1.2, Oracle HRMS, XML Publisher, SOAP, EiS,
JDeveloper, XML Gateway, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer 10g.
City Of Philadelphia, Philadelphia, PA May 2007 – Feb 2011
Oracle Apps Techno-Functional
Responsibilities:
Primary responsibility involves system study, Requirements Gathering, preparing functional specs,
•
Conversion Design, Test script documents, User Manuals and Business Process documents.
Setup functions, Menus, Responsibilities, and Request groups and performed other System admin
•
responsibilities.
Documented the setup specification using AIM - BR0100 as setup document for deliverable.
•
Prepared functional and technical design specification for the Historical conversion Event to transfer
•
the benefit elections from legacy system to OAB using Oracle API’s.
Documented MD050/MD070/CV040/CV080 for application extension/modification/interfaces &
•
conversion.
Setup Oracle HRMS Advance Benefits by establishing Elements for various Benefit Plans,
•
Programs, Program Enrollments, Life events, Eligibility Profiles to restrict eligibility. Simplified the
Customizations in OAB and modified the Configurations at different levels to follow Oracle rules and
hierarchy of Eligibility and Electability rules.
Setup Self Service OTL, OTL Timekeeper groups, Alternate names, Rotation plans, earning policies,
•
Holiday calendar, Work plan etc
Designed Conversion Strategy and Conversion Data Mapping Documents for HR/OAB and OTL
•
modules and wrote conversion programs using API’s.
Benefits Self Service Personalization with communication message text changes and added text on
•
SSHR pages to provide information about the plan which they are about elect and enroll.
Wrote fast formulas to calculate coverage amounts, enable/disable the options programmatically and
•
validation of options selection like he/she must select same emp/emp+1/family option across all
plans (Medical/dental/vision/prescription) provided.
Employee and Manager Self Service Personalization and user creation.
•
Developed fast formulas to calculate coverage amounts, enable/disable the options
•
programmatically and validation of options selection like he/she must select same emp/emp+1/family
option across all plans (Medical/dental/vision/prescription) provided.
Preparing system for Open Enrollments and Conducting mock open enrollments in advance to avoid
•
issues during open enrollments.
Interacting with Third party benefits providers (IBC, Delta Dental, Vision Benefits of America and
•
CVS Caremark) and prepared functional specifications for the Carrier Extracts.
Adding new plans/options and ending existing plans, rate changes.
•
Assisting end user training performed by key users.
•
Created Approval Rules, Conditions, and Approval Groups (AME.B) as per the City’s Organization
•
Structure.
Wrote dynamic attributes for AME.B and modified Workflow Notification to display employee number
•
& employee name using Sql and PL/Sql.
Created security profiles to avoid departments to access other departments Information.
•
Regular status reviews through conducting meetings with client & variance analysis if any through
•
issue & risk log.
Conducted CRP’s (CRP1 & CRP2) for the client to demonstrate the business process flows.
•
As OTL Functional, responsible for gathering requirements, system configuration, Documenting
•
BR100 and User Training manuals. Configured OTLR and OTL
Configured different approval routes for exempt and non-exempt employees.
•
Worked closely with the users and trained the trainers on using the OTL functionality
Performed the Workflow Administrator role.
•
Environment: Windows, Oracle 10g, Oracle Applications 12.1.2, Oracle HRMS, XML Publisher, SOAP, EiS,
JDeveloper, XML Gateway, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer 10g.
KPIT Cummins Info systems Limited, Columbus, IN Aug 2004 to Feb 2007
Oracle Apps Techno-Functional
Responsibilities:
Primary responsibility involves system study, Requirements Gathering, Conversion Design,
•
preparing functional specs, Test script documents, User Manuals and Business Process documents.
Data conversion, customization and development of inbound and outbound interfaces.
•
Loading legacy system data (csv, xml, flat files) into HRMS using SQL*Loader, pl/sql and API’s
•
available in HRMS modules
Registering Forms, Reports, Packages, Web Pages and Unix scripts in AOL
•
Customization of SSHR web pages using JDeveloper (OA Framework).
•
Customized New Hire V4.0 Workflow process for Contingent worker maintenance.
•
Developed custom web pages in OA Framework for Contingent workers self-service for rehire
•
process.
Developed custom web pages in OA Framework for the Cummins Merit review process.
•
Extraction of employee, Payroll and benefits data from HR, PAY and BEN tables using custom
•
views.
Development and enhancements of the reports for core HR, Payroll, OAB modules using Reports6i
•
and XML Publisher.
Developed Reports for COBRA.
•
Writing utilities using Unix Shell Scripting for FTP, SFTP, Encryption and Decryption
•
Wrote PL/SQL Packages, Procedures and Functions Scripts:
•
To validate data before loading into Oracle HR Tables.
To End Date Non-active user Responsibilities.
Employee Benefits extraction for third party venders like CIGNA, DELTA DENTAL.. using
utl_file utility.
Extract for Open Enrollment Confirmation.
For COBRA report requirements like Calculating monthly premiums, rate etc.
Increase in Employee’s pay proposals based on Organization requirements.
To Extract Oracle HR and Payroll data, which is, required ADP for processing the
Payments.
For backfeed of processed payroll data from the third party payroll provider (ADP) to the
Current HRMS application
For Workflow Function activities
Transfer and load recruitment and vacancy data into third party vendors
(webhire.recuriter.com) and HRMS base tables.
Wrote SQL Scripts:
•
To make correction in the data issues like updating, correction and deletion of
records.
To Grant Access to APPS on Custom Objects.
Loading Data into EIT Tables
Developed Periodic/Event based alerts as per the Business Requirement.
•
Handling Change requests from Clients.
•
Analyzing the data issues in Development, Proxy and Production servers.
•
Updating the Technical documents as per the functional design documents.
•
Creating Unit Test Planning and Test Cases Documents.
•
Code debugging, Review, defect sheet updating and checking into Clearcase.
•
• Prepared functional design specification for the Historical conversion Event to transfer the benefit
elections from legacy system to OAB.
• Preparedfunctionaldesign specification for the Benefit Structure/Eligibility/Rates/Premiums/Others as
per the User needs.
• Involved in Design of Life Events, Eligibility, Rates and System Extracts (e.g. Carrier Extracts, AP,
Payroll etc.)
• Prepared functional specifications for the Carrier Extracts and designed/configured/tested the
Extracts in OAB using System Extracts.
• Developed Functional specifications for various business rule which were implemented in OAB as
fast formulas for the requirements which weren’t satisfied by in built OAB functionality setups.
• Developed Functional specifications for Various Reports needed by the user.
• Used AIM Methodology for OAB Project Plan documents/deliverables.
• Conducting knowledge-sharing programs on every week among the team members.
• Ongoing production support for HRMS/Payroll/OAB.
Environment: Sun OS (8.0), Oracle 9i AS, Oracle Applications 11.5.10, Workflow Builder (2.6), J2EE, BC4J,
OAF JDeveloper, XML Publisher, TOAD, E-Business, Forms 6i, Reports 6i, Discoverer, VSS, Clearcase and
Citrix.
P&O IT Services Pvt Ltd. – PUNE, India Jun 2004 to Aug 2004
Responsibilities:
Wrote SQL scripts to populate EIT Tables.
•
Wrote Shell Scripts to load the legacy data into staging tables using SQL*Loader.
•
Forms customization using custom.dll
•
Created Custom reports as per the requirements
•
Adhoc Reporting as per client's requirement.
•
Analysis and Bug Fixing of Incident Reports by Client.
•
Prepare Daily Monitoring report for nightly batch jobs.
•
Worked as a Defect Prevention Representative.
•
Environment: AIX – UNIX (4.0), Oracle 8i/9i, Oracle Applications 11.5.7, TOAD 7.0, VSS, SQL*Loader,
Clear case, Forms 6i, Reports 6i andCitrix
Nihilent Technologies Pvt Ltd., - PUNE, India Dec 2003 to May 2004
Responsibilities:
Created Pl/Sql Interface to validate legacy data and loaded into Oracle Staging Tables
•
Involved into creating KFF, DFF and required valuesets and inserted required data into the
•
corresponding KFF, DFF Structures as per the functional design documents.
Using HRMS Tables created database procedures, database triggers, cursors, packaged procedures
•
and program units to enforce the client specifications.
Created and linked elements to maintain data for Employees for Merit reviews.
•
Extraction of employee data from HR tables using custom views.
•
Worked in Configuration Management Team.(Source code Maintenance).
•
Reviewed, tested and trained customers on the developed system.
•
Environment: AIX – UNIX (4.0), Oracle 8i/9i, Oracle Applications 11.5.7, TOAD 7.0, VSS, SQL*Loader,
Clear case, Forms 6i, Reports 6i andCitrix
NITAMS–Visakhapatnam, India Nov 2000 – Dec 2003
Responsibilities:
Requirement Analysis.
•
Maintaining the Muster by open List Reports.
•
Back-End programming in oracle (creating functions and procedures, Packages, Triggers and
•
views).
I also have an exposure to DBA activities like Back Up and Recovery.
•
PL/SQL programming and tuning
•
Changes, Bug fixing and problem analysis.
•
Designing User interface Units in Forms and Reports.
•
Attending Team and Client meetings to discuss functional issues
•
Designing, developing & maintaining the in house MLM Database.
•
Implementing Business Logics in PL/SQL and Matrix Binary, royalty and other Commission
•
calculations
Creating of custom views for reports & statistical data.
•
Product income plan design
•
Environment: Windows 95, Oracle 7.3, Pl/Sql, Forms 4.5, and Reports 2.5
Education:
Post Graduate Diploma in Computer Applications
Pondicherry University, India
Bachelors of Science
Andhra University, AP, INDIA
Contact this candidate