We provide IT Staff Augmentation Services!

Senior Oracle Technical Consultant Resume

SUMMARY:

  • Result oriented seasoned and dynamic IT Professional with 18 years of experience in spearheading planning, design and implementation of high performance IT solutions for Federal and Commercial sectors.
  • Strong experience in Oracle Applications EBS/ERP Federal Financials ( R12 and 11i) in modules AP, GL, AR, FA, PO, FV, Inventory, CRM Supply - Chain
  • Full lifecycle experience in implementation of Oracle Federal Financials R12 upgrade (AP, GL, AR, FA, PO, FV)
  • Very Strong 18 years of experience in Oracle SQL, PL/SQL, functions, packages, procedures , complex queries, database analysis, Oracle Forms 6i/10g Oracle Reports 6i/10g, SQL Loader, Database ERD
  • Ability to perform root-cause analysis, analyzing the functional requirements, producing high level/detail level design, updating system design documents, implementation plan document, help the testers to generate test cases and guide testers perform testing
  • Strong background in software development life cycle (SDLC) process
  • Good knowledge of Agile Methodology
  • Good working knowledge on Service-Oriented Architecture (SOA)
  • Superior interpersonal communication skills, team player, mentoring fellow team members, proactively helping others, problem solving skills
  • Experience in writing Technical documentations, which include Design artifacts, Process flow diagrams, Power-point presentations, presenting status to PMO office, weekly reports to Program Director
  • Experience in heavy user interaction, ability to understand/interpret user requirements and converting them into detail business requirements, JAD sessions, discussions, meetings
  • Successfully manage multiple tasks and projects simultaneously
  • Working knowledge in Oracle HRMS and OLM modules which includes multiple implementations
  • Oracle Self Service, Oracle Workflow, Oracle OBIEE, Oracle BI Publisher

EXPERIENCE SUMMARY:

Confidential

Senior Oracle Technical Consultant

Responsibilities:

  • Analyzing User requirements
  • Come with high level Design and detail Design
  • Interact with Functional Analyst
  • Finalize the design and develop the code
  • Unit testing
  • Promoting to Test environment for functional and user testing
  • Create request to Promote the code to PRODUCTION
  • GAP analysis
  • Identifying, analyzing, design, development of changes to
  • Modified many custom objects to add R12 Multiple Organization Access Control (MOAC) .
  • Modified custom objects to use Ledger Id instead of Set of Book Id.
  • SLA (Sub Ledger Accounting): Modified custom Objects (Procedures, Packages, reports) referring GL JE LINES columns to add XLA logic to retrieve data from base tables through XLA tables. Created a function to return column value by passing JE source and Category.
  • GTAS (Government Treasury account symbol): added logic to custom Objects mainly Interfaces to handle Treasury mandated TAS and BETC information for storing and reporting. Also, personalized PO distribution and AP Form to add logic to derive correct TAS and BETC.
  • Modified and maintained many GL Reports like GL to AR Reconciliation Report, Trail Balance Report, Journal Detail Report and many more custom reports.
  • Forms personalization
  • Designed and Develop Custom Form (Forms 10g) for GL Combination and Balancing Edits Correction, form was designed to control and edit the
  • Modified and Enhanced GL, AP, PO, AR Interfaces to reflect R12 changes.
  • Modified many custom Objects referring to AP Supplier, Payment, Bank table to refer TCA architecture tables
  • Creating new custom reports and enhancing and fixing the issues with the existing Custom Financial Reports developed using Report 10g/6i.
  • Created new custom FORMs using Forms 10g/6i
  • Personalized many standard FORMS
  • Created many BI reports
  • Modified Oracle Workflows
  • Created and modified many Oracle Alerts

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

  • It’s an Oracle Database Application project developed for FAA. It’s a very complex Oracle DB project with very large amounts of data.
  • Thorough understanding of FAA business process related to this project
  • Responsible for fixing lots of bugs in PL/SQL Code, code fixing in PL/SQL and Advanced PL/SQL
  • As a team member, responsible gathering requirements from users, creating design documents as necessary.
  • Documenting every small change in system.
  • Working hard in time constraint, mission critical project.
  • Able to resolve lots of major issues, bugs, performance issues and database related issues.

Confidential

Development Lead, Sr. Oracle Technical Consultant

Responsibilities:

  • Extensively worked on Oracle Applications RICE, which includes Custom Reports, Interfaces to external systems, Data conversion from legacy to Oracle Applications and enhancements to standard Oracle Applications functionalities.
  • As a team member, responsible for full-life cycle implementation of Oracle Applications 11i - modules HR, AP, GL, FA, PO and PA. And responsible for designing, developing and implementation of various Custom INTERFACES, which includes creating of, audit tables, UNIX shell scripts, Reports, Report Sets and Error Reports, and Custom Reports.
  • Design, Development and implementation of third party interfaces using SQL, PL/SQL and UNIX Scripts, which involved thorough design since heavy data (in millions of rows), tuned interface queries and designed test tables to accommodate large data.
  • Responsible for design, development, testing and implementation of new and customization of Oracle Reports and Oracle Forms.
  • Responsible for Data modeling for custom interfaces
  • Registration of reports, report sets and interfaces Concurrent Manager
  • Responsible for ETL (Data extract, Transfer, Load) using Oracle Applications API’s
  • Sole responsible for maintaining Oracle Applications HR, AP, FA, PO, GL after implementation for last 3+ years, which includes maintaining all Customizations, changes such as Value Sets, Flex fields, descriptive fields, setup changes to modules, Interfaces, standard reports, custom reports, forms and creating new Oracle reports, SQL reports and interfaces as per user requirements.
  • Have Strong 4 years of functional and technical experience in Oracle Applications HR module.
  • Sole responsible for setting up automated processes for daily/weekly/monthly activities & maintenance. Responsible for maintaining and running of reports and interfaces using Concurrent Manager.
  • Sole responsible for maintaining responsibilities and security profiles using Oracle Applications System Administration.
  • Made necessary modifications Oracle Applications forms using Custom.pll.
  • Designed and developed numerous Oracle Reports and SQL reports, and made modifications to standard reports.
  • Responsible for designing, developing and maintaining applications, ALERTS, WORKFLOW, HR Self Service, interfaces, reports, forms and all customizations in post-implementation of Oracle applications 11.0.3.
  • Did customization in the WORKFLOW mainly in the HR module, Time and Attendance and purchasing module.
  • Sole responsible for Design, Implementation and Maintenance HRSS (Oracle HR Self service)
  • Employee Self Service
  • Manager Self Service
  • Location Change
  • Payroll Area Change
  • Salary Change
  • Job Title/Grade Change
  • Designed, Developed, Tested & Implemented some Oracle Alerts (like whenever the applicant status changes to Offer, Reminder to supervisors to approve time sheets, IT Job Requisitions etc),
  • Sole responsible for many major modification to interfaces and UNIX shell scripts (Here are some interfaces: Interface HR to exchange(which is 2-way interface), AP Interface to Bank, GL Interfaces, HR to Capture, HR To T Rowe Price, HR to ADP Payroll, HR to Kronos etc)

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

  • Responsible for design, develop, implementation of applications using Oracle PL/SQL, SQL, UNIX Shell scripts
  • Responsible for coding/changing numerous Packages, Procedures, Functions
  • Responsible for design, development, testing and implementation of Oracle Reports and Oracle Forms.
  • Designed, developed a new SQL report which generates MS Excel report and defined executable, concurrent program & registered Concurrent Program using System Admin responsibility.
  • Designed and built the interface for ESPP (Employee Stock Purchase Plan), did shell scripting for calling SQL loader, PL/SQL packages, and SQL reports and did error handling in UNIX script itself.

Tools: Used. UNIX, Oracle Applications 11.0.3, Oracle 8.0.5, SQL, PL/SQL, FTP

Confidential

Sr. Oracle Technical Consultant

Responsibilities:

  • Responsible for data conversion in Applications HR module.
  • Interviewed users and performed data mapping from legacy system to Oracle Applications HRMS.
  • Created temporary tables & SQL loader scripts to load legacy data.
  • Validated data and generated error reports for data clean up.
  • Wrote & tested PL/SQL scripts to call Oracle provided API’s to load the data into Oracle Applications.
  • Also, helped Oracle Applications DBA to resolve installation errors, setting up printers by searching on Metalink and created user accounts using System Administration responsibility. Wrote detail documentation for conversion.

Tools: Used. NT, SQL, PL/SQL, SQL Loader, Oracle 8.1.6/8.0.5 , Oracle Applications 11i, MS Word.

Confidential

Oracle Technical Developer

Responsibilities:

  • Responsible for Creating packages, procedures, functions using Oracle SQL, PL/SQL
  • Responsible for creating Oracle Reports and Customizing Oracle Forms
  • Sole responsible of data conversion for HRMS module.
  • Interviewed users and performed data mapping from legacy system to Oracle Applications HRMS.
  • Created temporary tables & SQL loader scripts to load legacy data.
  • Validated data and generated error reports for data clean up.
  • Wrote & tested PL/SQL scripts to call Oracle provided API’s to load the data into Oracle Applications.
  • Wrote detail documentation for each step of the conversion process

Tools: Used. NT, SQL, PL/SQL, SQL Loader, Oracle 8.05, Oracle Applications 11.0.3, MS Word.

Confidential

Oracle Technical Developer

Responsibilities:

  • This application consists of 40-50 front-end screens (Oracle Forms) and various Reports (Oracle Reports & MS Word Templates).
  • Make enhancements and fix bugs in 35-40 of the Oracle Forms and 20-25 of the Oracle Reports and MS Word Templates.
  • Performed a detailed investigation of FTS Business Process, in order to debug the Oracle Forms and Reports code.
  • Interacted with users on a daily basis to understand functionality of the forms and reports, and the errors that were occurring.
  • Modified and created MS Word templates. Wrote OLE code in Oracle Forms to interact with MS Word templates.
  • Wrote system documentation, which describes the functionality of all front-end screens and reports.

Tools: Used. NT, SQL, PL/SQL, SQL Loader, Oracle 8.05, MS Word.

Hire Now