Technical Consultant Oracle
Resume:
JOB PROF
Oracle Technical Consultant
RAKESH PATEL
Apt. 1021, Bedford, TX,
76021.
Mobile Number:
E-Mail:
************@*****.***
PERSONAL DETAILS:
DOB : 29.06.1978
Gender : Male
Nationality : Indian
Marital status: Married
Passport
Number : P6982010
Date of issue: 21.12.2016
Date of expiry: 20.12.2026
Languages known:
English, Hindi, Gujarati
OBJECTIVE:
Highly skilled and experienced Oracle Technical Consultant with Oracle Forms, Reports, and PL/SQL Developer with 24+ years of experience in designing, developing, and maintaining database applications. Proven ability to translate business requirements into robust and efficient solutions using Oracle PL/SQL, Forms, and Reports. Expertise in performance tuning, database optimization, and data warehousing concepts.
AREA OF EXPERTISE:
o Requirements Gathering o Application Migration
o Scope of Work Creation o Business Process Flow Analysis o Customized Forms & Reports o Test Cycle Creation and Management o Documentation, Schedules and Status Reports o Development of Training Materials o Gap Identification and Resolution o Timeline and disruption SUMMARY:
Excellent experience as a Technical/Functional Consultant in Oracle Fusion R12c.
Implementation and technical expertise in Oracle Applications 12c, 11x, across the Discrete and Manufacturing Modules, Purchasing Order (PO), Material management (MM), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work in Progress (WIP), Quoting and System administration (AOL), Human Resources (HRMS), Financials Modules such as General Ledger (GL), Payables (AP), Receivables (AR), Asset Management (AM).
Experience in designing, coding, testing custom applications with an integration to Oracle Applications or other custom applications.
Experience in developing custom Oracle Forms using Oracle Forms/Reports 12c, 11i/10g/6i.
Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
Experience includes exposure to all the phases of Software Development Life Cycle including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance.
Excellent problem-solving skills with an ability to identify problems and implement connective solutions.
Prepared Technical Design Documents for customizations and conversions. TECHNICAL SKILLS:
ERP Suite: Oracle 12c, 11.x; PO, MM, OM, WIP, BOM, HRMS, Quoting, INV, GL, AP, AR, AM, Advanced Pricing, AOL
Database Tools: Oracle 11g/12c/18c/19c, SQL, PL/SQL, SQL Loader, SQL Plus, TOAD, SQL Developer
Oracle Tools: Forms 12c, 11i, 10g/6i, Reports 12c, 11i/10g/6i, Discoverer 10g/4i, Workflow Builder
PL/SQL: Stored Procedures, Functions, Packages, Triggers, Cursors, Collections, Records, Dynamic SQL, Exception Handling
Data Modeling & Design: Entity-Relationship Modeling, Database Normalization, Data Flow Diagrams, Data Dictionary
ETL: Experience with data extraction, transformation, and loading processes
Other: UNIX Shell Scripting, SQL*Net, Oracle Enterprise Manager (OEM), Data warehousing concepts
Installation of Servers: Windows 2016, 2012 R2, Active Directory, DNS, DHCP, Linux, VMware, Hyper-V
Other Programming Languages: ASP. Net, C/C++, HTML, XML.
Operating Systems: Windows 2010, 7/XP/NT/95, DOS, Linux 9.0, Mac OS X.
Other Tools: MS-Office, Outlook, IBM Lotus Notes. 2
EXPERIENCE:
ACI Infotech (IT Company)
Designation: Oracle Technical Consultant
Duration: 11th Nov 2021 to Till.
ACI InfoTech (ACI) is a next-generation Global Technology Services & Products company with deep expertise in and delivering Business-driven Technology Solutions that empower clients to streamline & run their business efficiently. Serving a global client base that includes Fortune 500 companies, Responsibilities:
He plays the role of an Oracle Techno / Functional Consultant for our USA, TX based client. CBC (Carter Blood Care), with origins in the 1950s, Carter Blood Care is one of Texas largest blood centers, providing over 440,000 units of life- saving blood and blood components to patients in North, Central, and East Texas annually. He is currently working on Carter BloodCare BBIMS (Blood Bank Information Management System). The project involves enhancement of existing and development of new modules for BBIMS in the areas of blood donor registration, blood collection, testing, component preparation, storage, order processing, and shipping to hospitals for patient transfusion. We have worked remotely with Rakesh, and he is highly qualified, knowledgeable, and experienced with development tools used in BBIMS.
• Designed, developed, and maintained Oracle Forms and Reports applications.
• Developed and optimized PL/SQL stored procedures, functions, and packages for data manipulation and reporting.
• Performed database performance tuning and optimization, resulting in [Quantifiable results, e.g., 25% performance improvement].
• Implemented data warehousing solutions using Oracle databases.
• Conducted data migration and conversion projects.
• Resolved complex technical issues related to Oracle Forms, Reports, and PL/SQL.
• Collaborated with cross-functional teams to understand business requirements and deliver solutions. Project and Environment details:
• Oracle 12c Database, Oracle Forms R12c, Reports 12c, Toad, SQL Developer.
• Windows 2016 Server, VMware, Hyper-V.
• Responsible for Migrating Old Application in Oracle Fusion 12c.
• Develop and Implement multiple Oracle Modules for CBC
• Providing Functional / Technical support to CBC Team.
GUJARAT INFRAPIPES PVT. LTD. (Mfg. Company)
Designation : AGM- IT, ERP Techno / Functional Consultant Duration : 27th Dec 2010 to 5th Nov 2021.
Gujarat Infrapipes (GiPL) is India's largest manufacturer of Pipe fittings & Piping Spools. GIPL has been catering to key infrastructural sectors like Oil & Gas, Refineries & Petrochemicals, Power & Energy, Steel & Shipbuilding, Fertilizers, etc. for over 25 years.
Responsibilities:
Worked as an AGM-IT, ERP Techno / Functional Consultant, He is responsible for Developing, implementing and providing support for Enterprise Resource Planning systems. He analyzes the systems and works directly with department seniors and management to define system requirements, design and propose solutions, configure the software and train employees. He is responsible for Maintaining Database, Application and Domain Servers, Desktop applications and Network activities. He designs loosely coupled and extensible systems and new features as required by Management and module related department. He is responsible for delivering technical specifications, unit-tested code with an appropriate level of performance for upcoming new features in ERP. Currently, he is responsible for designing and delivering programs and guiding teams. He is also responsible for databases related to all activity. He is responsible for improving the existing IT setup and giving advice on improving it with cost-effective solution. 3
Project and Environment details:
• Oracle 11g Database, Oracle EBS R12, Forms Suit 11, Forms 6i, PL/SQL, Reports 10g, Workflow 2.6.3.
• Windows 2012 R2 Server, VMware, Hyper-V.
• Develop and Implement multiple Oracle Financial Modules (FA, AP, PO & EB-Tax).
• Provided Technical support for Oracle 11i Modules (General Ledger, Accounts Payable, and HRMS).
• Prepared financial reports, developed processes, and performed variance analysis in accordance with business plan using Excel, Oracle Discoverer and Oracle Financial Reporting.
• Developed and maintained PL/SQL packages, procedures, and triggers to support business logic.
• Designed and optimized Oracle Reports for financial and operational data analysis.
• Enhanced database performance through query tuning and indexing strategies.
• Assisted in data migration and conversion projects, ensuring data integrity.
• Trained personnel and management on Oracle other modules; Order Management, Purchasing, BOM, WIP, INV, AP/AR and MRP.
• Implemented Quick Reference Guide training materials for plant and corporate office employees.
• Facilitated multi-unit work sessions to determine requirements, screen flows and processes.
• Interfaced with Tech Support, Helpdesk defines and improve support procedures and capabilities through training, communications, and documentations across related Oracle projects and future system upgrades.
RUCHI POWER AND STEEL INDUSTRIES LIMITED (Mfg. Company) Designation : Sr. Software Developer, IT-Manager.
Duration : 19th Nov 2005 to 20th Dec 2010.
The company largely manufactures structural steel long products including-TMT Bars, BEAMS, ANGLES, CHANNELS and STAINLESS STEEL FLATS. Ruchi Power and Steel Industries Ltd. immensely caters to various prominent sectors such as Infrastructure compliance with Residential Buildings, Roads, Bridges & Flyovers, Airports, Dams, Commercial Complexes, Power Plants & Industrial Structures. Believing in backward integration and to ensure the authenticity and reliability of the raw materials, the company has been in the process of attaining ‘Iron Ore mining rights’ in Madhya Pradesh. The company plans to expand and build its capacity to 500,000 MT per annum. Responsibilities:
• Managing a team of over 12 administrative & technical staff.
• Designed, developed, and enhanced Oracle Forms and Reports to support business operations and decision-making.
• Wrote complex PL/SQL stored procedures, functions, packages, and triggers to improve application functionality.
• Optimized SQL queries, improved database performance, and reduced query execution time.
• Migrated Oracle Forms and Reports from 6i to 12c, ensuring compatibility and minimal downtime.
• Developed and maintained custom reports using Oracle Reports for finance, HR, and operations teams.
• Collaborated with DBAs, business analysts, and end-users to analyze requirements and implement solutions.
• Provided technical support, troubleshooting, and bug fixes for Oracle-based applications.
• Trained and mentored junior developers on best practices in Oracle development.
• Involved in installation, configuration and upgradation of Oracle 10g Database server.
• Development of customized ERP system, manage Application and Database servers and responsible for the day-to- day IT (H/W, desktop applications and Network) activities and ERP related requirements of the company. To help to improve existing system and to give advice to improve it with cost effective solution.
• Invented and implemented strategy for Backups, recovery & fine-tuning.
• Developed table spaces, rollback segments, user maintenance, and database security imposition.
• Handled the overall performance tuning of the database by tapping & tuning different areas.
• Responsibility of Functional and Technical.
• Project gone live from Apr’06 with 10 modules (Marketing, CRM, PPC, Stores, Purchase, Production, Q.C., HR, Finance, Excise, Logistic, MIS, Admin)
4
INNOVA SYSTEMS (I) PVT. LTD. (IT. Company)
Designation : Sr. System Engineer / Network Administrator. Duration : 1st Jan 2001 to 30th Apr 2005.
Innova Systems is one of the System and Service providing company, it maintains a stringent and robust quality process giving the clients a non-stop functionality to their work and to support that it a 24 X 7 technical support. It is also their unmatched experience and features that sets them apart from others… Role & Responsibilities:
• Establishes networking environment by designing system configuration; directing system installation; defining, documenting, and enforcing system standards.
• Maximizes network performance by monitoring performance; troubleshooting network problems and outages; scheduling upgrades; collaborating with network architects on network optimization.
• Secures network system by establishing and enforcing policies, defining and monitoring access.
• Updates job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplishes information systems and organization mission by completing related results as needed.
• Reporting network operational status by gathering prioritizing information; managing projects.
• Installing and Configuring Windows Server 2003, 2000, Active Directory Services, Windows NT* 4.0 Server.
• Managing and administrating all user domains and accounts.
• Managing Firewall and Backup Devices and Server.
• Networking, LAN & WAN trouble shooting. Network Auditing, Knowledge of configuration and maintenance.
• Windows mail, Local Mail Server, Print server.
• Designing IP addressing scheme using subnets. Configuring Routers and Switches, Switch Configuration.
• Router configuration (static routing, dynamic routing)
• VMware Virtualization configuration
STRENGTH:
• Self-Analysis
• Quick-Learning
• Positive-Attitude
• Creativity and Hardworking.
• Motivate to downstream team.
• Stronger follows up with higher authority and with clients, prospective.
• Built-up strong relations with team members and clients. EDUCATION & CERTIFICATION:
• BE-IT – M. S. University, Tamilnadu – scoring 64%
• Diploma Software Engineering – APTECH LIMITED scoring 66%
• HSC – GSEB - Gandhinagar scoring. 45 %
• SSC – GSEB - Gandhinagar scoring. 57 %
• OCP - Oracle DBA – Xduce Institute – scoring A Grade
• CCNA – IIHT scoring B Grade
• Asp .Net and tools – Image Institute – scoring A Grade
Contact this candidate