Oracle Apps Technical Consultant Resume Profile

Experience Summary

10 years of extensive IT experience in analysis, design, development, implementation, support, and maintenance of Software development and relational databases especially for manufacturing domain such as Engine/ Automobile/ Foundry/ Valves/ Pumps Industries.
Worked in various roles in the project uses methodologies such as SDLC, Waterfall, Agile, Scrum RAD as Project Manager/ Module leader/ Tech lead/ Technology Expert/ BI Analyst
Comprehensive Technical Experience in Middleware Fusion Oracle Data Integrator ODI , Oracle Developer 2000 D2K - Forms, Reports Graphs , Oracle PL/SQL, XML Publisher and BI Tools such as OBIEE, Informatica, OWB and Oracle Discoverer.
Good Technical experience in Oracle Applications EBS 11i MFG- SCM - Order Management, Pricing, WIP Modules Forms/Reports/Interface Customization as well as Functional experience in Inventory, Purchase, AP AR Modules.
Expertise in developing end to end Integration required between applications using Middleware Fusion ODI, PL/SQL packages, procedures functions, triggers, exception handling, DBMS packages, interfaces and data conversion using ODI PL/SQL.
Experience in System Analysis AS IS , Requirement Study, Functional Technical Design Documentation, Test Plan Preparation, Unit testing, System Integration testing, CRP, UAT, Issue Management and Documentation.
Strong Functional knowledge of Manufacturing Domain especially in SCM areas as well as knowledge in multiple manufacturing industries such as Engine Manufacturer, Automobile, Valves, Pumps Foundry. Functional Experience spans in areas such as Sales Order Management, Inventory, Purchase, Material Costing, MRP, and Production Planning Control. Spans in Financial areas include Accounting Management System HR module includes Payroll Application System.
Strong experience in Database Modeling and in the development of complex stored procedures in SQL environment.
Good knowledge of Database concepts, Oracle DB Installation, creation of database, Table space, User Roles and other database activities such as performance monitoring.
Excellent knowledge of how to design for, test, and improve scalability in database and web-based applications. Ensuring the best practices for, performing code reviews and providing technical assistance as needed.
Excellent communication skills, leadership, management abilities, team spirit and interpersonal skills with the ability to work on multiple projects simultaneously.
Trained Formed technical team both at Onsite Offsite location for Oracle technologies such as MW ODI, D2K Advanced PL/SQL, Unix Shell Scripting Some Automations tools creation.
Good knowledge on PMP and skill in Project Management activities such as Preparation of PMR Audit reports, Project billing generation, UMP DP Report Generation, Creating, Assigning Managing task , assisting to resolve issues and following up of various TCS Ultimatix IPMS processes. Also voluntarily involved in Centre level activities such as CSR, Fund Raising event.

Technical Skills

Hardware	Databases	Tools	Languages	Operating System	Other Application
Computer Assembly, Troubleshooting, OS Installation.	Oracle 11i EBS, 9.X, 8.X	MW Fusion ODI, Developer 2000 Forms, Reports, Graphs, XML Publisher, BI reporting tools - OBIEE, Oracle Discoverer Informatica, OWB, Crystal Report, SQL, PL/SQL, SQL Navigator, SQL Tools, PL /SQL Developer, AppWorx	FOXPRO, DBASE, C, C , Visual Basic, VBSCRIPT, HTML, XML, UNIX Shell Script,	Linux, Unix, Windows 9x NT 4.0/2000/XP/.X.	Oracle EBS SCM, Purchase, Inventory, WIP Microsoft Office Word, Excel, Powerpoint, Project and Visio , MPP, Remedy User, Clearcase, Visual Source safe.

Awards Achieved Details

Confidential

Total Experience Details:

Name of Company	From	To
TATA CONSULTANCY SERVICES
MASTER SOFTWARE SOLUTION
MIS CONSULTANTS

Professional Experience

Confidential
Designation	Middleware ODI Technical Expert/Lead
Middleware ODI Development Support Implemented 28 project's end to end integration of more than 500 interfaces with various integration patterns its Production Support at Onsite Global Warranty System GWS Integration DBU NextGen System Integration Powersuite Integration SIM MDM Supplier Information Management Integration UCM MDM Universal Customer Management Integration PIM MDM Product Information Management Integration PROS MDM Pricing Application Integration SCP Integration FITS Integration IAD Integration Xelus Brazil/ Mexico Integration Global Locator Integration BOLT Integration
Technology Used
Job Profile	Design analysis for all requirements and prepare the High Level and Low-level design Analysis of requirements for finding any ambiguity, incompleteness or incorrectness Suggesting Technical Approach for the business requirement Taking concept review of the proposed integration design for any requirement to Cummins EAI Design council for approval to make sure that to align Cummins Standards in all the way Developed end-to-end ETL process documents NFR, Questionnaire, Requirement Specification, High Level Design, Low Level Design, Test Cases, UAT, and Review as per Cummins EAI Policy Developed ETL mappings to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL mappings. Designed developed enterprise level end to end integration to make sure that there will be more re-usability across organization in the integration for any future requirement Responsible to tune Development and testing environment/ interfaces created for ODI Developed and implemented Error Handling Strategies for ETL mechanism which is automated for overall project implementation now Defined Enterprise ODI Coding Standard, Naming Convention, Best Practices, IFP Integration Foundation Practice review check list for Design/ Code Development/ Testing/ Support Done One Time Data load for all MW Fusion projects using ODI as data conversion activities Supported all Pre-CRP/CRP/UAT Testing/ Review Production go-Live preparation activities Supported Infant care for all projects implemented at Onsite Supported Co-ordinated end to end smooth hand over to MW Production Support to maintain the implemented solution

Organization	Confidential
Designation	BI Technical Analyst/ Lead
BI Development Support Projects Purchasing BI interfaces INFORMATICA/SQL Planner Support Tool OBIEE/PLSQL Parts Pricing Manager interfaces INFORMATICA/SQL Engine Emission Environmental Monitor Reports OWB/DISCOVERER/SQL Order Management System Data Mart GOMS, SGOMS, MECHGOMS, MGOMS PLSQL, DISCOVERER DBU NextGen interfaces ODI/PLSQL
Confidential
Technology Used	ODI, Oracle PL/SQL, OBIEE, Informatica, OWB, Discoverer
Job Profile	Developed PL/SQL Packages, Procedures, Functions, Triggers views required for the project Developed OBIEE reports by creating new repositories, imported data stores and created new reports Developed Interfaces in Informatica tool as per business requirement with the Cummins standard Created interfaces in OWB for the data required for generating reports using Oracle Discoverer Created Unix Shell Scripts as wrapper for the Informatica workflows and for error handling strategies. Reviewed deliverables and ensure they meet the high quality standards before delivering them to the client team.

Since 2006 - TATA Consultancy Services

Confidential
Designation	Oracle Apps - Technical Consultant/Developer
Confidential
Technology Used	Oracle EBS SCM/ Pricing Module Customization using Oracle Forms, Reports, PL/SQL XML Publisher
Job Profile	Customizing Forms, Reports PL/SQL procedure for various Oracle Apps - Order Management, Pricing Module Created Interfaces with Mainframe Java based COM Web Order Management legacy systems in Cummins Developed Interfaces such as CSL Setup Checks which will be used for defining Customer Specific Language for products in Cummins as per Apps Standard Developed Customer Item and Cross ref interface which will be used for building cross reference between Legacy system's Product Name brand new application Product Name Developed Pricing interface which will be used for product pricing in Cummins with specific business rules defined by Cummins and integrated with workflow Developed Shipment History interface which will be used for customer to view daily shipping history plant wise and its tracking status Developed One time load of Order import interface which will be used for bringing all Customer Orders which are OPEN into Apps system from IMS Legacy system Developed Order Import interface which will be used for importing orders created in legacy system such as IMS, java based application called COM Customer Order Management in a daily nightly job Developed Nightly Order acknowledgement interface which will be used for getting acknowledgement for all orders received from legacy system its status Developed Packing Slip Report which will be used for logistic along with shipping for every order Created reports using Oracle Reports XML Publisher Following Cummins Standard 11 Step process which is mandatory for any Apps implementation

Confidential
Designation	Oracle Apps Technical Consultant/ Forms PLSQL Developer
Confidential
Technology Used	Oracle EBS WIP Module Customization using Oracle Forms, Reports, PL/SQL XML Publisher
Job Profile	Customized Forms PL/SQL procedure for Oracle Apps WIP - Firm Build Interface. Followed 11 Step process which is mandatory for any Oracle Apps Implementation Created Deployed new reports using Oracle Reports Development, Implement, Production Support of CIC planner support tool MRP Tool. This is a simple Support tool developed for Planners to analyse their demand Supply in all manners. MRP is a tool developed for Planners to analyse material requirement to meet their demand in all manners using Oracle Forms/ Reports Graphs, PLSQL

Confidential
Description	Development, Implement, Training on various MSS VALVES ERP product modules such as Order Management, BOM, Purchase, Inventory, PPC, WIP, MRP with Accounts Payroll packages which show the information about the entire operation of the valves industries to the management.
Role	Senior Technical Consultant/ Developer D2K
Solution Environment	Windows 2003 Oracle 8i
Tools	Developer 2000, Forms 6i, Reports 6i, Sql, PL/SQL, SQL Tools, SQL Navigator
Highlights	1. Involved in Database Server Installation, Database creation, User Roles creation for MSS Valves ERP System. 2. Involved directly with Client to get their requirement and doing the changes.

Confidential

Confidential
1.Ultimate Alloys, INDIA 2. Suera Alloys, INDIA 3. Veeyes Alloy Castings, INDIA 4. Sri Venkateshwara Alloy Casting, INDIA
Confidential
Description	Development, Implement, Training, Maintenance according to Clients requirement in MSS Foundry ERP Sales Purchase modules.
Role	Senior Technical Consultant/ Developer D2K
Solution Environment	Windows 2003, Oracle 8i
Tools	Developer 2000, Forms 6i, Reports 6i, Sql, PL/SQL, SQL Tools, SQL Navigator
Highlights	1. Involved in Modifications of modules and development of new reports according to clients requirement on the spot after analysing the entire system. 2. Involved directly with Client to get their requirement and doing the changes.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship