Oracle Manager
Resume:
Bala C Lingala
********@*******.***
Professional Summary
Accomplished, result oriented techno functional professional with over
seventeen years of progressive IT experience spanning across various
sectors like manufacturing, government, retail, computer hardware,
financial and hospitality industries. Extensive experience with Oracle E-
Business technologies Suite, Oracle RDBMS and related GUI tools in
implementing and managing projects. Have strong techno functional
knowledge and involved in all phases of software development life cycle.
Accountable for business requirements gathering, gap/fit analysis,
creating functional/technical specifications, testing and end user
training. Have experience in managing projects, leading the team,
preparing project plans, schedules, status tracking, monitoring and
execution. Highly organized, dedicated and motivated to meet
organizational goals and departmental objectives. Operationally focused,
supporting business critical systems in a highly revenue generating
business environments. Effective strategic planner, driving customer
value in complex environments. Excellent team player having effective
interpersonal and communication skills.
Skills Inventory
Operating System: Windows, Sun Solaris, HP-UNIX
Database Technology: Oracle 7X, 8i, 9i and 10g
Tools & Utilities: Tools & Utilities: Oracle Forms,
Reports, Designer, Oracle SQL, PL/SQL, TOAD, JDeveloper, XML Publisher
Business Intelligence:
OBIEE, BI Answers, BI Publisher, Discoverer
Change Management: Kintana, HP PPM
Version Control: PVCS
ERP Technology: Oracle Applications 10.7, 11i, 12i
(under upgrade)
(Core HR, Payroll,
Advanced Benefits, ESS, MSS, Compensation Work Bench, Learning Management,
Labor Distribution,
Time and Labor, Payables, Receivables, General Ledger, Fixed Assets,
Purchasing and
System
Administration)
Professional Experience
Wyndham Worldwide. NJ
05/2007- Current
Senior Techno Functional Analyst/Lead
Oracle Apps 11i/12i upgrade
Lead the team in smooth transition of the project deliverables from
implementation to maintenance for HRMS Suite. This involve Knowledge
transfer, organizing key functional and technical design documents,
sourcing the code, user training. Established coding
Standards and processes for effective post implementation
maintenance.
Managed the implementation of Learning Management for franchisee users'
community, development of integrated project plans, implementation
schedules, cost estimates, identifying project deliverables, Milestones
and required tasks.
Maintained the Learning Management system by resolving complex
business critical issues with quick turn around
Time. My contribution is recognized with Star award since this is a
revenue generating application used by more than 60000
Franchisee user community.
Played key role in implementing Compensation Work Bench for
Corporate services HRMS group which manages employee salaries,
Bonus and LTIP. Helped business community in maintenance and
enhancements related to the application.
Accountable for developing major technical solutions for ADP
Payroll. This involves correcting the back feed programs to load back
Feed data from ADP to Oracle. The HRMS business could load the data
into Oracle successfully which helped the business to send
Accurate data files to outside vendors for various business needs.
Developed project plans, BRD, Scope, functional and technical
documents for enhancements projects implementation.
Extensively worked on personalization of employee/manager self
service screens as per user requirements.
Developed RPD and Answer & Dashboard using OBIEE for ERP analytics.
Created BI Publisher reports and deployed on Dashboard.
Involved in Release 12i upgrade initiative for HRMS suite. This
consists of backing up the customizations and setups before
Upgrade, migration of custom objects, validating/creating the setups
and system testing after upgrade.
Managed the offshore team for work allocation, status tracking and
project deliverables. Worked with cross project teams to resolve
technical performance issues/bottlenecks, creating RFCs and service
requests and following it up.
IB Infologic (Client: Black Rock, NY)
10/2006 - 04/2007
Senior Techno Functional Lead Consultant
Oracle Apps 11i
Provided functional expertise and developed business requirements and
solution design for HR interfaces. This includes interfaces
For ADP payroll, 401k, Medical/Dental/Vision, Wage Works, Legal and
Web.
Responsible for solution design and roadmap for the team, for HRMS
data conversion. Converted employee and assignment
Information, contacts, addresses, initial balances.
Created Oracle Alerts for data changes based on specific user
requirements. Configured functional setups for Compensation
Work Bench and developed fast formulas.
Extensively worked on personalization of employee and manager self
service screens as per user requirements. Widely used Discoverer/XML
Publisher to develop reports for various user requirements in Core HR.
Developed script for Loading Vendor data into Oracle Payables.
Provided solution for Interface deriving distributed invoices,
Paid and unpaid, for a given GL accounting period.
Developed custom reports for Encumbrance Summary Report, Encumbrance
Accounts Analysis Detail Report and Actual
Accounts Detail Report in General Ledger. Generated custom reports
using FSG for various user requirements.
The Great A&P Tea Co, NJ
09/2004 - 09/2006
Senior Techno Functional Analyst/Lead
Oracle Apps 11i
Led the technical team for customizations, development and deployment
of solutions for HRMS suite within time and budget.
Configured complete setups for plans/programs design, eligibility
requirements, eligibility profiles, standard/variable Rates, Premiums,
communication types, collapsing rules and life events for open enrollment.
Developed new Fast formulas for US Open Enrollment and Compensation Work
Bench. Designed system extracts for various benefits requirements.
Provided functional expertise and developed business
requirements/solution design for HR, Payroll and Benefits. Extensively
used APIs' for HR data conversion. Built new reports using Discoverer/XML
Publisher.
Core team member responsible for design, development and implementation
of automation solution for Oracle Payroll. This solution
Streamlined the payroll processes running smoothly with no manual
intervention and minimal failure. Customized Check Writer
And Deposit Advice as per user requirements.
Extensively worked on personalization of manager self service screens
as per user requirements. Modified custom new hire and Update employee
forms used by the HRMS business for data entry. These forms play a
critical role in loading all the employee data into Oracle without getting
into core HR screens.
Managed and implemented solution for custom Union Benefits system.
This includes creating BRD, functional/technical design,
Forms/database packages and integrating with Oracle Applications.
Modified script for document attachments using API for Invoices.
Customized seeded reports as per user requirements in
Payables and Receivables. Created Payables and Receivables invoices by
using Open Interfaces with validations.
Generated custom reports using Financial System Generator for various
user requirements.
Developed reports for Summarize revenue by region, Summarize revenue
by ship-to, Revenue Proof Report, Sub Ledger Detail
Report and Credit Watch Report.
Production support of HR, Payroll and OAB modules, creating service
requests and following it up
Rapidigm Inc (Client: University Of Alabama at Birmingham, AL)
12/2002 - 08/2004
Senior Oracle Apps Lead Consultant
Oracle Apps 11i
Widely used HRMS APIs' for data conversion from legacy to Oracle.
Developed and Implemented solution design for US Benefits Program.
Using Oracle's AIM, created BRD, Fit/Gap Analysis during solution
design phases of the implementation.
Developed project scope, reporting requirements, testing strategy and
configuration documents.
Provided functional expertise and developed business
requirements/solution design for HR, Payroll and Benefits.
Created Fast Formulas for Advanced Benefits and Payroll and customized
seeded Payroll Fast Formulas for prorating regular salary.
Used Benefits APIs' for creating and updating potential life events,
primary care providers, enrollment results.
Developed database triggers to capture self service changes done by
employees through Oracle Self Service.
Created custom package using oracle API's to update the encumbrance for
user defined elements in Labor Distribution.
Customized seeded Check Writer and Deposit Advice reports as per the
user specifications in Payroll.
Designed and implemented interfaces for HR, Payroll and Advanced
Benefits. Built custom forms for Time/Attendance,
Reclassification and Action Log. Developed custom reports for various
user requirements.
Actively involved in post implementation maintenance.
Rapidigm Inc (Client:Oregon Health & Science University, OR)
01/2002 - 11/2002
Senior Oracle Apps Techno Functional Consultant
Oracle Apps 11i
Responsible for design and development of scripts for HRMS data
conversion of Terminated Employees', Elements, Salary
Proposals and Positions.
Configured the set ups for key flex fields; programs, plan types,
plans, rates and premiums for various benefit plans in Advanced Benefits.
Designed and developed interface packages for Benefit Enrollment and
401k-contribution interface.
Developed custom reports for Invalid Labor Schedule POETA-GL Account
and Element Entry Funding Validation in Labor Distribution. .
Developed discoverer reports for HR and Benefits. Built custom reports
for Recruitment Aging, Recruitment Statistics Summary/Detail, Position
Listing by Job Class Code, Seniority Points, Temporary Hours, Vendor
Payment Summary and Detail and Leave Liability.
Designed and implemented solution for hiding PII data and fields across
HR and Payroll applications. This involves developing custom Form, setting
up profile options and developing logic using custom PLL.
Rapidigm Inc (Client: Seagate Technology, CA)
01/2001 - 12/2001
Senior Oracle Apps Consultant/Technical Lead
Oracle Apps 11i
Widely used HRMS API's for data conversion from legacy to Oracle.
Customized Fast Formulas for shift differential calculations, benefit
eligibility.
Customized Oracle standard people form to display certain fields and
tabs, based on the localization of the country using
Custom PLL.
Designed and developed interfaces for budget, HR Guide and Health Care
Plans like Cobra, Vision and Medical.
Built reports for open enrollment, benefits eligibility, medical plan
default, New Hire Benefit Elections and Spouse Date of Birth.
Configured the set ups for programs, plan types, plans, rates and
premiums for medical, dental, vision, AD&D and Group Life plans, in
Advanced Benefits.
Developed test scripts and executed for system testing the global HRMS
system.
UBICS Inc(Client: Haworth Inc, MI)
01/1999 - 12/2000
Senior Oracle Apps Consultant
Oracle Apps 10.7
Customized the custom PLL to display the Oracle Instance Site Name in
the title bar
Built outbound interfaces for Legal-Care Eligibility and Met-Pay
Eligibility.
Designed and developed inbound interface for Met-Pay billing incoming
flat file using PL/SQL.
Developed custom reports for Group Life Insurance Summary /Detail,
Workers Compensation, Performance Appraisal,
Employment Activity Listing, Long-term Disability Summary, Open/Closed
Requisitions Activity, Employee Training Activity,
Events and Bookings.
Customized the check writer and Deposit Advice reports as per the user
specifications.
Designed and developed custom process for PTO allocation and carry
over, for active employees.
Built interface for com-star invoice interface system using PL/SQL.
Created custom reports for Miscellaneous Invoice, Shipping and Billing,
Un-invoiced Receipts, Supplier Maintenance,
Property Tax Details and RFE Tracking.
Developed interface programs to validate and load legacy data into
interface tables.
Post implementation maintenance of HRMS and Financial Applications.
UBICS Inc(Client: Shoe Carnival Inc, IN)
08/1998 - 12/1998
Oracle Apps Consultant
Oracle Apps 10.7
Created custom reports for Daily Invoice, EDI Invoice, Invoice Check
Register, Transfer Analysis, Shipping and Billing,
Credit Memo, Supplier Maintenance and Property Tax Details.
Built interface programs to validate and load legacy data into
interface tables in Receivables.
Developed program to Import the AR Invoices using Invoice Import APIs.
Developed reports for AR Aging, AR to GL Reconciliation, Auto-invoice
execution/validation, Tax and Revenue, Receipt register,
Un-posted items, Adjustments and VAT/Tax Reporting.
Designed and developed an interface for monthly import of journal
entries from Payroll system by using the journal import Interface.
Developed interface programs to integrate Legacy System with the AR
module to import customer information using
The Customer Interface
Post Implementation maintenance.
HCL, India
04/1997 - 06/1998
BEL, India
10/1992 - 02/1997
Senior System Analyst
EDP Solutions
Functioned as core team member in developing and implementing software
solutions in the areas of purchasing, inventory,
Sales, Capacity Requirement Planning and Bill Of Materials.
Evaluated the user requirements and generated the specifications.
Designed the user interfaces using forms and developed code for them.
Generated reports for item master, stock master, item balance, item
ordered, invoice,
Credit and debit voucher, project wise reports to show manpower
deployment, employee master with skills set and times schedules.
Extensively involved in system maintenance and enhancements and trained
the end users.
Education
. Masters Degree in Engineering
. Certified PMP
. Training from Oracle University on Workflow.
. Training from KBace on Oracle Advanced Benefits.
Contact this candidate