Oracle Software Engineer
Resume:
Mobile: 978-***-****
Raghunath Anisingaraju
SUMMARY
Over 10 years of professional experience in Oracle Applications working
with Finance, Sales Compensation and HR departments. Worked directly with
business users supporting their existing operational systems, implementing
system migrations from legacy to oracle and integrating different
applications into oracle during mergers & acquisitions by understanding the
system gaps and utilizing the common features. Worked in both development
and production support roles and experienced in all phases of SDLC. Managed
and coordinated offshore team for development effort and also worked with
geographically distributed teams.
SKILLS
Languages PL/SQL, C/C++, Java, HTML, Shell Programming.
ERP Applications Oracle R12/11i/11.5.10, OIC,HR, Payroll, OAB, AR, AP,
GL, FA, PO, INV
Data warehouse ETL, Cognos Decision stream, Cognos Report Net
Databases Oracle 10g (PL/SQL, and SQL*PLUS), MS-Access
Operating Systems Solaris, SunOS, DOS, HP UNIX, Windows 95, and Windows
NT
Version Control Quest Stat, PVCS, Clear case
Third Party Systems Bottom-line, Get Paid, HP RIM Archive Tool, APRO,
Treasura
EDUCATION
Masters in Engg. (Computer Science) University of
Toledo, Toledo, OH August 2001
Bachelors in Engg. (Computer Science) Osmania University,
Hyderabad, AP April 2000
PROFESSIONAL EXPERIENCE:
Principal Programmer Analyst
Staples Inc, Framingham, MA
Mar-2006 - Present
Environment: Oracle Applications R12/ 11.i, Oracle Financials, Oracle
Incentive Compensation, Cognos Decision stream, Report Net, Reports6i,
Forms 6i, Quest Stat, TOAD, APRO, Shell Script, Bottom-line, Accurate,
AutoMatch, Remedy, Orsyp
Responsibilities
. Worked as a Technical Lead in the Implementation of Oracle Incentive
Compensation Module for Retail copy/print
. Responsible for f all the 17 RICE items that were designed and
developed for the OIC module that include Transaction Interface, Payee
Interface, Revenue Rollup Hierarchy Conversion, Quota/Subsidy Upload
etc
. Worked with business users to understand/configure their compensation
plans and provide test scripts/cases for the CRP2 testing
. Worked on design of the Oracle workflow process to send commission
reports to manager for approval before sending payment to payroll
. Worked with business users in setting up Roles, Pay Groups, Groups,
Teams etc
. Provide primary production support on call rotation basis for AR
module working with business users across US, Canada and Europe.
. Manage and lead offshore resources for development and testing efforts
in archive and upgrade projects.
. Back production support system administrator tasks include creating
new/modifying users, responsibilities, profiles, value sets, flex
fields, security rules and overall concurrent manager tasks
. Manage APRO third party bank reconciliation tool that integrates into
Cash management application and General Ledger
. Worked with GL treasury department to implement Treasura and developed
daily inbound interface to import journals into oracle GL
. Technical/Functional lead for Oracle upgrade projects in AR and FA
modules from 11.5.9 to 11.5.10.
. Served on the IS team Integrating AP and FA systems of Corporate
Express and Staples
. Archived data for GL and AR modules in Oracle Financials using HP
Reference Information Management Tool. Developed archiving strategy
for ongoing data reduction in AR and GL modules
. Redesigned the existing customized AR Lockbox process to improve
the cash application ratio and enhance the performance
. Lead the AR securitization project and setup secure file transfer
mechanism between the servers
. Implemented and supporting third party collection tool Get paid for
Oracle AR
. Implemented Cognos AR/AP data warehouse reporting solution for US
and European AR /AP business users
. Worked with Cognos Decision Stream and Cognos Report Net to extract
and report the data in DW.
. Led the Global AR Canada and Portugal rollout projects by designing
and developing outbound and Inbound Interfaces and conversion programs
for AR,GL,FA and AP modules
. Consistently met strict, time-sensitive deadlines working under
severe resource constraints
. Designed customized reports, fit gap analysis, and all documentation
and deliverables.
. Work with internal audit teams to extract financial audit data and
provide to EY on monthly, quarterly and yearly basis
. Created Performance Matrix to track slow performing jobs across
different organizational units in oracle applications to identify
system bottlenecks and schedule jobs effectively
. Performance tuned several processes and reports that ran with slow
performance like Aging reports, FA reports etc
. Worked with Oracle on Issue resolution by creating service requests
for oracle bugs and follow up closely with oracle until the issues are
resolved.
. Developed several AR, AP Reports for the several user requirements as
per the specifications provided
. Developed Test Plans and Testing framework for Upgrade and Archive
Projects
. Followed agile development model, with intense one to two week develop-
test-release cycles and daily interaction with business users
. Used shell scripting and PL/SQL programming to resolve business
problems of various nature.
. Represented the interests and knowledge of the team in a number of key
business initiatives, including Sarbanes-Oxley and PCI compliance.
Also, attended and participated in architectural and weekly change
management review meetings
. Worked as development lead to coordinate with business users for
requirements, prioritization and estimation.
Sr. Software Engineer /Consultant
Fidelity Investments, Merrimack, NH
Aug-2004 -Mar 2006
Environment: Oracle Applications 11.0/11.i, Oracle HRMS, Reports6i,
Forms6i, Clear Case, Solaris, TOAD, Kintana, Business Objects, Control M
Responsibilities
. Supported 13 different Oracle Application clients in a hectic and
challenging environment. Served as primary production support person
for large payroll systems. Worked on-call rotation on weekends and
weekdays for issue resolution
. Served as lead techno-functional support person presenting solutions
to time critical P1 Issues that include monthly payroll process
issues, merit increase, balance issues, year end process or
hire/rehire issues
. Developed several interfaces and scripts that use HR data load API's
to support the production support mass updates, merit increase,
job/grade change process
. Converted data for new client additions and existing client mergers
like Person, Assignments, Elements, balances etc.
. Supported W2 year end process and SQWL for all the 13 clients. Worked
on Year end Process SQWL, W2 Printing and adjusting tax balances for
fixing the W2 errors.
. Developed and supported several Oracle Alerts that were developed in
the oracle and tracked them in case of errors
. Developed functional & technical design specifications, unit test
plans and obtained business approvals before migrating the code in
production.
. Involved in the set up of Elements, Links, and Balances, Lookup types,
User tables, taxation rules, consolidation sets, third party payments
and NACHA rules for direct deposit information.
. Created and/or modified Oracle fast formulas used to facilitate
applicable payroll calculations, validation rules and skip rules.
. Developed custom Rehire package using Oracle API's that allows users
to change the hire date of an employee backwards or forward.
. Manage issue resolution related to bugs, application errors, patches,
etc (Log and monitor TAR's).
. Involved in resolving day to day payroll issues related to quick pays,
off-cycle checks, Rollback & reversals, Voiding and re issuing a check
and Payroll Fast formula errors.
. Setup Organizations, Locations, Costing, Payrolls, Tax withholding
rules and Security Profiles within Oracle HRMS module for the US
legislations.
. Modified Check writer (PAY_CHQWRT_PKG) and Deposit Advice
(PYUSDAR_PKG) packages to sort based on a user-enterable value.
. Created interfaces for uploading the time entry records using the
Oracle Batch Element Entry API's.
. Maintained and developed interfaces for the all the 13 LPS clients,
there were over 50 interfaces running on a daily basis.
. Developed reports For Zero Payments, employee deductions, PTO Accruals
and Garnishments.
. Assit the monthly releases that include patches, enhancement and
bug fixes
Oracle Applications 11i Consultant
Safelite Auto Glass, Columbus, Ohio
Mar 2003 - Aug 2004
Environment: Oracle Applications 11i, Financials, HRMS, Reports6i,
Forms6i
Responsibilities
. Served on the Oracle technical team implementing Accounts Receivable
and Purchasing modules
. Fixed major oracle AR stopper issue by fixing the Customer Bill to -
parent hierarchy issues.
. Fixed the custom Purchasing Receipts program Issue which was essential
for the PO module
. Developed and designed complex bank aging reports .The buckets of the
report were based on fiscal Month and complex logic.
. Developed around 30 different reports mostly in AR, AP and PO
modules. Some reports had both complex logic and layouts.
. Debugged several custom packages, workflow items, and reports across
Purchasing and Inventory modules.
. Developed the complex custom purchase/invoice price variance report.
. Gathered requirements from the business users and worked closely with
business analysts to assist them develop BR documents
. Worked closely with DBA and oracle system administrator on regular
basis
. Followed Oracle AIM methodology using standard MD50, MD70 and CV40's
templates to design, develop
and migrate the code into production
Oracle Applications 11i HRMS Consultant
University of Alabama, Birmingham, AL
Mar 2002 - Mar 2003
Environment: Oracle Applications 11i, Human Resource/Payroll/Advanced
Benefits/Labor Distribution, Fast Formulas, Oracle8i, SQL*Plus, Api's
Responsibilities
. Technical developer in Implementation of OAB (Oracle advanced
benefits) conversion for University of Alabama.
. Assisted in analyzing conversion scope, objectives, approach, and
requirements
. Converted person, assignments, EIT's, contacts, address, salary,
balances, LD Schedules from legacy to Oracle HRMS.
. ACT Customization: HR forms were customized and data was dumped into
temp tables. Developed robust code for supporting this process
. Developed inbound interface for mass upload of salaries from legacy
system to Oracle HRMS base tables.
. Worked on Fast Formulas for different business needs of the client.
. Involved in outbound interfaces for OTL module at UAB.
. Worked and customized oracle workflow process to suite client needs
. Followed Oracle AIM methodology in design, development and testing
process
. Worked closely with users in UAT life cycles and supported post go
live issues
Software Engineer
GTV Inc.
Nov 2001 - Feb 2002
New York City, New York
Environment: Windows NT, Win 32 API, C++, HTML, PHP, Visual Studio 6.0
Responsibilities:
. Managed the functional customization of interoperable instant
messaging platform in C++, HTML by assessing legacy code base and
designing a development strategy under limited resources.
. Implemented several functionalities like skins, ad servers, etc.
. Customized the application to a client in a time sensitive deadline.
. Created new Buttons on the messenger with functionality.
. Linked the messenger to the client domain using PHP based
administrative toolkit.
Oracle/Java Developer
Radiant systems,
Hyderabad, India
Aug1999 -Aug 2000
Environment: J2EE, UML,JSP, JDBC, HTMl,Oracle, Servlet, Rational Rose,
Weblogic
. Worked on one of their project which was the Reservation system with a
credit card interface (CCI), which shall provide electronic payment
services using a credit card or a debit card. From a high level, the
responsibility of the system is to provide Web interface to perform
credit card transactions during the payment and refunds by the
cancellation.
. Developed java servlets and worked on database design.
Contact this candidate