Cell: 858-***-****
Venkat Ramamoorthy, Oracle Techno/Functional Consultant
Email: abnjc6@r.postjobfree.com
Over 13 years of Professional Technical and Functional experience in
P rofessional Summary
projects involving Development, Conversion, Interfaces, Customizations,
Yrs of Experience: 13
Migrations, Enhancements, Implementations and Support using Oracle ERP
(10.7SC/11i/R12) applications modules ( GMS, PA, AP, AR, GL, FA, HRMS,
Industry Experience
PO, INV,OM) in varied business environments like Federal, Public Sector(Govt),
F ederal
HealthCare, Insurance, Manufacturing and Automotive industry.
P ublic Sector Financials
F inancial Services 9+ years working with large Oracle Integrators such as IBM BCS, Accenture,
Health Care CapGemini, GE (General Electric), Northrop Grumman and Bearing Point.
Insurance
Manufacturing Technical (Lead, Consultant, Analyst, Developer) activities: preparation of
Bio-sciences conceptual and technical design documents, interfacing with business and users,
Research programming, managing developers, scheduling, test script generation, devising
Automotive test strategies and providing overall project.
Achievements: Awarded Certificate of Recognition for Outstanding Technical
Education
Contribution and Certificate of Excellence for Successful Implementation of GE-
Masters Degree in
Instrumentation Business.
Computer Applications,
MK University, Functional (Consultant, Analyst) activities: business requirements
India gathering, translating business to IT requirements, functional analysis,
application design, configuration, and module setup, writing training guides, and
B.S (Computer Science), training end users
University of Madras,
Exposure to Oracle AIM / SOX Compliance Process / Six-Sigma / CMM Level V
India
Process methodologies in Software Application Development Life Cycle.
Post Graduate Have good technical leadership, presentation and inter-personal skills with a
Diploma in Management proven ability to rapidly trouble shoot, diagnose and resolve complex issues.
All India Institute
Of Management
CONSULTING SKILLS
India
Certifications Business Requirement Gathering Process Design
Oracle Financials Development Configuration
Oracle 11i Technical
Interfaces Test scripts
RDBMS
Problem Solving Skills Organizational Skills
Oracle Developer 2000/VB
eCommerce Communication Skills Reporting Documentation
Web Programming
Technical Team Lead Functional Team Lead
FoxPro/C/LINUX
Production Support Education/Training
Contact
CLIENT LIST
Work Status:
GreenCard (Permanent Resident)
County of San Diego (CoSD) SDCVB.ORG
Cell Phone: Tucson Airport Authority Boulder County
Northrop Grumman IBM BCS
Accenture Cap Gemini
Home Phone:
858-***-**** United Health Group Bearing Point
Pacific Health Care GE (General Electric)
Email id:
Solbourne Merrill Lynch
abnjc6@r.postjobfree.com
Chicago Transit Authority CN Bio-sciences
Current Location:
Nu-skin Korea Systems BARC
San Diego, CA 92126
ATUL India Ltd Autolec Industries
Page 1 of 7
Venkat Ramamoorthy, Oracle Techno/Functional Consultant
Continued TECHNICAL SKILLS
Operating Systems: WIN’NT/2000/98/95/XP, MSDOS, UNIX & Sun Solaris,
IBM /AIX
RDBMS: Oracle 7.x/8.x/9i/10g/11g, PL/SQL, SQL Server 2000/05, MS-Access
ERP: Oracle EBS Applications R12(12.0.4), 11i, 11.0.3 & 10.7 SC
Oracle Application Modules:
Grants Management (GMS)
Project Accounting (PA)
Accounts Receivable (AR /TCA) / iReceivables
Accounts Payable (AP) / iExpense / iPayables
Fixed Assets (FA)
Human Resource Management System (HRMS)
General Ledger (GL /SLA)
Purchasing (PO)
Inventory (INV) / Order Management (OM)
Oracle Telesales (AST) / Oracle Marketing (AMS)
Application Object Library (AOL )
Customizations (RICEW)
Apps Form Customizat ions(Seeded, Custom) / Personalization’s
GUI: Oracle Developer Suite 6i/10g, Oracle Forms 4.5 / 5.0/6.0/6i/10g,
SQL*Report Writer 1.1, Oracle Reports 2.5 / 3.0/6.0/6i/10g, Visual Basic,
FoxPro 2.0,2.5/2.6a,dBase III+/IV/V
Programming Languages: SQL 8.x/9.x/10g, 10g, PL/SQL 8.x/9.x/10g, ‘C’,
Pro*C, Pro*Cobol, Visual Basic, Java, JSP, JavaScript, HTML, XML, Unix Shell
Scripting (Korn)/Cron Jobs / Awk programming
Application Server: Oracle 9iAS/10g
Utilities: SQL*Loader, Oracle IMPORTS & EXPORTS, Or acle Discoverer 10g
(User/Admin/Plus/Viewer) /4i /3.0.8, Oracle Graphics 2.5, Query Builder,
Procedure Builder, Schema Builder, Oracle BI 10g (Standard Edition)
Query Optimization: Explain plan, TkProf, Analyze command
Methodologies: Oracle AIM, CMM Leve l V, Six-Sigma Quality Process,
SOX Compliance
EDW/ETL Tools: Ascential Datastage 7.5 for Extract, Transform and Load,
Oracle BI 10g (Standard Edition)
Other Tools: Oracle SQL Developer, Toad 7.x /8.x/9.x, PLSQL Developer (All
Round Automations), D ata Loader, SQL Navigator, Remedy, PRS, Clear Quest,
GE- (Kintana, Clarify, Idea Hopper), EDS-Peregrine (Problem Ticket Tracking
System),AUTOSYS – Batch job scheduler
PMP Tools: Microsoft Project, MS PowerPoint, MS Word, Excel, & MS -Visio
Version Control : PVCS, WinCVS 1.3, Serena Version Manager, Microsoft VSS
(Visual Source Safe)
Exposure: Oracle Financial Analyzer, Oracle Sales Analyzer, Oracle Express,
EAI (Vitria), LINUX
Page 2 of 7
Venkat Ramamoorthy, Oracle Techno/Functional Consultant
PROJECT EXPERIENCE
SanDiego Conventions & Visitors Bureau (www.sandiego.org) Dec 2008 to Present
Senior Architect - Oracle EBS R12 Implementation(Financials /Manufacturing/CRM/Business Intelligence)
(Working ~ 80% Technical and 20% Functional within Oracle Applications)
Environment: Oracle EBS R12(RUP4) (GL/AP/AR/TCA/PO/INV/OM/HRMS/iExpense/AST/AMS/CRM/Oracle BI) modules,
Oracle 10g/11g, SQL, SQL*Plus, PL/SQL, UNIX Sun Solaris, Toad 9.7, Oracle Discoverer 10g (User & Admin), Oracle
Forms 10g, Oracle Reports 10g, Korn Shell scripting, Standard/Custom Apps Forms (Personalization & Customizations),
SQL*Loader, MS Project, UPK(User Productivity Kit), Oracle Portal
Project: Development / Customizations / Enhancements / Workflows / Reporting / Post Go-Live Support/Maintenance
Wrote business requirements for reports, interfaces, data conversions and application extensions.
Prepared detailed documentation as needed including; Functional Specification, Technical designs, Updates to
existing Technical Documentation, Test Scripts, and Process Flow Charts.
Responsible for all aspects of technical/functional development within Oracle E -Business Suite applications such
as requirements, analysis, design, development and delivery of RICEW applications.
Established standards perform code reviews and prepare test cases/scripts for unit, functional and System
Integration testing.
Document business requirements, analyzes impact of the changes, prepare functional specifications, technical
specifications, develop, configure and perform unit tests as well as assists the users in the UAT phase .
Configured System Administrator responsibilities for users, menus, responsibilities, Key and Descriptive Flex
Fields, Request Groups, Request Sets and maintaining concurrent programs.
Configured, designed database views, Prepared Functional and Technical requirement documents and developed
various reports using Oracle Discoverer (Admin, Plus and Viewer) for all apps modul es.
Designed and developed Customizations and Personalization’s of Oracle Seeded Forms based on user
requirements.
Wrote Data Conversion scripts to load data from Legacy System to Oracle and also converted SQL Server data
from the old web system to Oracle Portal
Develop end-user documentation and training materials using UPK.
Deliver presentations and end-user trainings.
Co-ordinate all activities for IT/Users during design development, testing, and deployment.
Manage technical team members and work closely with users and functional team members; ensure appropriate
utilization and productivity through weekly status reports, prepare work estimates and evaluations.
Track all outstanding work through reports on a weekly basis.
Provide status and issue reports to the IT Director/VP on a regular basis.
Northrop Grumman & Bearing Point May-06 to Dec-08
@
County of San Diego, CA (www.sdcounty.ca.gov) (Public Sector / Government Client)
Oracle Techno/Functional Consultant (Lead/Analyst/Developer)
(Working ~ 70% Technical and 30% Functional within Oracle Applications)
Environment: Oracle EBS 11i (GMS/PA/AR/AP/GL/FA/HRMS) modules, Oracle 8.1.7/9i, SQL, SQL*Plus, PL/SQL, UNIX
Sun Solaris, Toad 9.0, Oracle Discoverer 4i (User & Admin), Oracle Forms 6i, Oracle Reports 6i, Korn Shell scripting,
Custom Apps Forms (Development), SQL*Loader, PVCS/VM, Peregrine (Problem Ticket Tracking System), MS Project,
Kronos (Timekeeping system), Peoplesoft (HRMS)
Project: Development / Customizations / Enhancements / Management Reporting /Production Support
Wrote business requirements for reports, interfaces, data conversions and application extensions.
Prepared detailed documentation as needed including; Functional Specification, Technical designs, Updates to
existing Technical Documentation, Test Scripts, and Process Flow Charts.
Prepared the Technical Design document and converted them into Report program specifications for Oracle
Application 11i modules using Oracle Report Builder 6i and Oracle Discoverer 4i.
Page 3 of 7
WORK EXPERIENCE
Continued
Developed new interfaces to feed external systems data and also bring historical data from Legacy system to
Oracle Project modules.
Developed Custom Billing program to integrate Oracle PA to AR module
Developed new reports using Oracle Reports 6i in GMS/PA/AR/AP/GL/FA modules.
Customized Oracle standard reports in AR, AP and PA modules.
Worked with Discoverer and created views to enable users to generate ad-hoc reports.
Developed Custom Apps Forms to handle Internal Agreements functionality in Oracle Projects.
Developed Oracle Project Costing Extension Program to handle Employee cost rates based on the County’s
unique costing methods.
Developed Interface to feed Peoplesoft HR data into Oracle HRMS using standard API’s
Prepared business reporting requirement mapping from Kronos Time keeping system to Oracle Projects module.
Developed several reconciliation and Cross Functional reports in GMS/PA/AR/AP/FA and GL to assist County
users during the Fiscal year end process.
Developed and Customized PLSQL packages, procedures, functions, triggers and database views.
Provide functional and technical expertise within an assigned business area, in the analysis, design,
development and implementation of business processes and applications.
Translated complex business needs and problems into feasible technical solutions.
Established standards, performed code reviews, coded PL/SQL interfaces, forms and reports and prepared the
test cases for Unit and System Integration testing.
Provide day to day support and troubleshooting of user and application problems within a specific business area.
Identified operational inefficiencies, conflicting business practices and integration issues, suggested alternative
solutions.
Fix any defects and performance problems discovered during testing.
Tuned Complex SQL Queries using Explain Plan statistics and TkProf Utility.
Performed Code review and refinement to the code design leading to significant improvement in system
response time and efficiency.
Coordinated all activities for IT/Users during design, development, testing, and deployment.
Developed end-user documentation and training materials.
Delivered presentations and end-user trainings.
Managed Technical Team members and worked closely with Users and Functional Team members; ensured
appropriate utilization and productivity through weekly status reports, p repared work estimates and did
evaluations.
Track all outstanding work through the production ticket system on a weekly basis.
Provide status and issue reports to the Project Manager on a regular basis.
Solbourne March-06 to May-06
@
Tucson Airport Authority, AZ (www.tucsonairport.org)
(Federal Client)
Oracle Techno/Functional Consultant
(Working ~ 80% Technical and 20% Functional within Oracle Applications)
Environment: Oracle EBS 11i (PA/FA/GL) modules, Oracle 9.x, SQL, SQL*Plus, PL/SQL, Windows /2000 server, Toad
8.0, Oracle Discoverer 4i, Oracle Reports 6i
Project: Integrated Airport Management System (IAMS)
Prepared the Technical Design document and converted them into Report program specifications.
Developed and customized reports for Oracle Applications 11i modules using Oracle Reports 6i.
Developed Report templates for enforcement of Standards.
Worked with Discoverer and created views to enable users to generate
Ad-hoc reports.
Converted SQL*Reports 1.1 to Oracle Reports 6i
Customized FSG reports on Oracle GL Module.
Prepared Test strategies and Plans documentation for report development .
Page 4 of 7
WORK EXPERIENCE
Continued
Solbourne Jan-06 to Mar-06
@
Boulder County, Boulder, CO (www.co.boulder.co.us)
(Government)
Oracle Techno/Functional Consultant
(Working ~ 80% Technical and 20% Functional within Oracle Applications)
Environment: Oracle 11i (PO/INV/GL) modules, Oracle 9.x, SQL, SQL*Plus, PL/SQL, Windows /2000 server, Toad 8.0,
Oracle Discoverer 4i, Oracle Reports 6i
Project: Report Development – Customizations / Enhancements / Support
Prepared the Technical Design document and converted them into Report program specifications.
Customized the Purchased Order Report.
Developed and customized reports for Oracle Applications 11i modules using Oracle Reports 6i.
Worked with Discoverer and created views to enable users to generate
Ad-hoc reports.
Customized FSG reports on Oracle GL Module.
Supported 11.5.10 upgrade activities.
Accenture/Cap Gemini Mar-05 to Jan-06
@
PacifiCare Health Systems, Cypress, CA (www.phs.com)
United Health Group, Cypress, CA (www.unitedhealthgroup.com/)
Oracle Techno/Functional Consultant
(Working ~ 80% Technical and 20% Functional within Oracle Applications)
Environment: Oracle EBS 11i, Oracle AR/AP, Oracle 9.x, SQL, SQL*Plus,
PL/SQL 9.2.0.6.0, PLSQL Developer, Oracle SQL Developer, Sun Solaris, ETL-Ascential Datastage 7.5, MS-Access, Toad
7.6, MS-Visio, AUTOSYS, WinCVS 1.3, SOX Compliance
Project: Integrated Broker Payment System (IBPS) – Release Phase I
Prepared the conceptual and technical Design document specifications for ETL system conversion and interface
project (Extraction, Transformation and Loading Legacy Data to Oracle).
Worked closely with the business systems analyst to develop the source to target data mappings and al so conduct
user interviews to validate the transformation rules.
Developed Unix Korn Shell scripts and Customized existing PLSQL packages, procedures and functions by uutilizing
the Oracle 9i features such as Scalar SQL and CASE WHEN statements to optimise performance of embedded SQL
from within PL/SQL code and to reduce context switch between PL/SQL and SQL engines as well as to eliminate
extra processing to augment the ETL process design.
Implemented Core application logic using PL/SQL Bulk Binds, Bulk Co llect, and Table-Types Arrays to boost the
System Performance to load high volume of Data into Data Warehouse on an incremental basis.
Used Rule and Cost based optimization approaches to maximize system performance and achieve best response
times.
Tuned Complex SQL Queries using Explain Plan statistics and TkProf Utility
Performed Code review and refinement to the code design leading to significant improvement in system response
time and efficiency.
Responsible for planning, developing and deploying Datastage Components in various business environments.
Develop Test data manipulation routines, Address to code bugs, Support implementation effort and Document
support essentials
Prepared documentation and training materials, coordinated technology related train ing
Prepared JIL scripts for AUTOSYS job scheduler to schedule batch jobs on various business environments.
Supported cross-platform development and integration with data transformation, job scheduling, database loading
tools, and source code control and release/configuration management tools.
Page 5 of 7
WORK EXPERIENCE
Continued
GE- Instrumentation Services Business, Duluth, GA Jan-04 to Mar-05
(www.gecals.com)
Oracle Techno/Functional Consultant – Development / Conversions/ Migration / Delivery
(Working ~ 70% Technical and 30% Functional within Oracle Applications)
Achievements:
Awarded Certificate of Recognition for Outstanding Technical Contribution.
Awarded Certificate of Excellence for Successful Implementation of GE-Instrumentation Services Business.
Environment: Oracle EBS 11i (AR/GL), Oracle 9iAS, Oracle 8i, SQL, PLSQL, Developer 6i, Forms 6i/ Reports 6i,
SQL*Loader, Pro*c, Pro*COBOL, Java, JSP, JavaScript, Oracle Discoverer 4i (User Edition), Sun Solaris UNIX, Toad 7.6,
MS Project, Six Sigma Quality processes, GE- (Kintana, Idea Hopper, and Clarify)
Project: ESBS is legacy system built in GE for its Instrumentation services. ESBS helps end use rs to keep track of
Work in Process right from receiving, Internal transfers, shipping, billing, calibration certificate generation and Order
mgmt.
Studied the business requirement and converted them into Technical Design documents.
Wrote complete detailed documentation as needed including; MD50 Functional Specification, MD70 Updates to
Technical Documentation, Test Scripts, and Process Flow Charts
Mapping of business requirements to application features and identifying the areas that needed customization.
Developed and Customized Oracle Reports, PLSQL packages, procedures and triggers, converted all the Custom
Reports to work on Oracle Applications 11i using Oracle Reports 6i.
Developed and Customized Oracle Reports 6i for Oracle Portal Integration.
Worked with Discoverer and created views to enable users to generate ad-hoc reports.
Developed several Unix Korn shell scripts to aid the performance of some Customized programs on Oracle
Applications.
Developed Java Server Pages (JSP), JavaScript and Java program to call Oracle Stored Procedures for Asset
Information Management Systems, which is a part of GE Instrumentation Business.
Automated the equipment out of tolerance notification to users using Pro*C, UNIX shell scripts and scheduled the
job using Unix Cron.
Supported and Integrated the Business System to be fully User Authenticated via) Oracle Single Sign -On (SSO)
Architecture in development and Production environments.
Established standards, performed code reviews, coded PL/SQL interfaces, forms and r eports and prepared the test
cases for Unit and System Integration testing.
Supported System upgrades and change request management for code deployment into production environments
through Kintana Management Tool.
Supported Post-Go Live activities and closed all production issues logged through Clarify.
IBM BCS Sep-03 to Jan-04
@
Merrill Lynch, Hopewell, NJ (www.ml.com)
Oracle Technical Consultant / Developer
(Working ~ 90% Technical and 10% Functional within Oracle Applications)
Environment: Oracle EBS 11i(PA,HRMS,GL,AP), Oracle 8i, Forms 6i, Reports 6i, SQL/PLSQL, Discoverer 4i/3.0, Oracle
Portal, Sun Solaris, Pro*C, Toad 7.3, PVCS, Remedy, PRS, SQL*Loader, Autosys, Clear Quest
Project: Management Reporting – Oracle Financials
Analyzed functional designed specification did data analysis and developed detail design document.
Developed SQL/PLSQL scripts to Load Data from Legacy System to Oracle.
Modified and developed PLSQL package and UNIX shell scripts to perform certain specific requirements and
enhancements in Oracle AP.
Developed Customized Reports using Oracle Discoverer 4i/3.08, Reports 2.5/6i
Worked on AUTOSYS job scheduler to schedule Unix box jobs
Provided Technical Consultations, Performed technical Code Review and Bug -Fixing for Offsite Team Members.
Exposure to Request System, Clear Quest, PVCS and Remedy System to track Production Issues.
Page 6 of 7
WORK EXPERIENCE
Continued
IBM BCS Apr-03 to Sep-03
@
Chicago Transit Authority, Chicago (www.transitchicago.com)
Oracle Technical Consultant / Developer
(Working ~ 90% Technical and 10% Functional within Oracle Applications)
Environment: Oracle EBS 11i(GMS,AR,AP,GL,PO), Oracle 8i, Forms 6i, Reports 6i, SQL 8.x / PLSQL 8.x, Discoverer 4i,
Win NT 2000,Sun Solaris, SQL*Plus, Toad 7.3, PLSQL Developer
Project Description: Custom Report Development
Study, Review Functional Specifications and Design Technical Specification Document to meet the Business
requirements.
Converted Technical Design Document into Report Program Specification.
Developed Customized Reports for Grants Management, Inventory, Purchasing, Order Management, and Accounts
Receivable Modules
Developed Back-end PLSQL packages, procedures and functions for reports development
Developed SQL Scripts for GL interfaces and pre-printed format reports
Involved in identifying data required, building new files during development
Devise Report Registration and prepare installation Scripts.
Devise test strategies and plans documentation.
CN-Biosciences Inc, Nu-skin Korea System & Paquet Express Aug-02 to Apr-03
Oracle Technical Consultant / Developer
(Working ~ 90% Technical and 10% Functional within Oracle Applications)
Environment: Oracle 8i, Forms 6i, Reports 6i, SQL 8.x / PLSQL 8.x, Win NT 2000 and UNIX
Project: Integrated ERP Package
Prepared Functional and Technical Specifications document to meet the desir ed requirement.
Designed, Developed and Converted SQL *Reports 1.1 / Ext Plus Reports to Oracle Reports 6i.
Developed Report templates for enforcement of Standards.
Developed Re-usable Template Forms to Integrate Reports over the Web
Customized Reports for Web Deployment in various formats PDF, Html, Excel and for Pre-printed stationary
Worked with Discoverer and created SQL views to generate ad-hoc reports.
Developed and Customized Forms v4.5 to 6i to support new requirement
Developed Dynamic Data Exchange (DDE) programs to automate the loading of Customer Data from MS-Excel
worksheet into Oracle Staging Tables using PLSQL Packages.
Prepared Test strategies and Plans documentation for report development
Developed Database Packages / Procedures / Functions / Triggers to support Java Team
Involved in Unit, Specification and Integration Testing
ATUL India Ltd, Thomson Mercantile, BARC, Autolec Industries Ltd) Dec-96 to Aug-02
Software Engineer / Developer – Oracle Application Development
Environment: Win NT, Microsoft Excel, VBA, SQL Server and Oracle Express
Oracle 8.0, Forms 6.0, Reports 6.0, SQL 8.0, and PLSQL 8.0
Project: Integrated ERP comprising modules such as Financial Accounting
Management, Inventory Control, Integrated Information System (Materials Servicing), Sales Management System
Computer Aided Maintenance Management, Human Resource Development - Training Module,
Integrated ERP Admin Information System, Payroll Management
Involved in Functional design, code design and development.
Involved in Development, Modifications and Enhancements of Oracle Express programs to automate monthly tasks
updated and refreshed Database for clients
Environment: Oracle 7.3, Forms 4.5, Reports 2.5, SQL, and PLSQL, Dbase III+
Project: It has 5 Core modules that integrate strategic function via,
Order Processing, Material Management, Production Planning, Financial Accounting, Conversion of Dbase III+ Data into
Oracle.
Developed the Database Packages / Procedures / Functions / Triggers
Designed and Developed Forms and Reports.
Involved in Unit and Integration Testing.
Page 7 of 7