Developer Oracle
Resume:
Mail Address:
adinb5@r.postjobfree.com
Mobile Number:
Location:
Germany, Nuremberg
Dear Sir/Madam,
Kindly find enclosed my resume to provide you with an overview of my relevant technical and functional
experience in various Domains.
I have 13 years of IT Experience as an Oracle ERP
Consultant & Technical Architect using Oracle
Applications 11i, R12 modules with Strong Expertise knowledge in SQL & PLSQL.
I will be delighted to discuss my experience further with you to suit your requirement.
Looking forward to hearing from you.
Yours Sincerely,
Sunil Kumar G
SUNIL KUMAR
Oracle ERP Technology Architect
2 P a g e
NAME: Sunil Kumar CONTACT NUMER: +49-151-********
adinb5@r.postjobfree.com Germany, Nuremberg
PROFESSIONAL SUMMARY
13+ Years of extensive Techno-Functional experience in Oracle ERP/E-Business Suite.
Strong Experience in Requirement gatherings, Data Analysis, Design, Development, Implementation, Upgrade, Interfaces and Data Conversion.
Proficiency in Relational Database Management Systems (RDBMS).
Develop Functional, Technical Documentation, test plans and test scenarios using AIM methodology documents such as BR 100, MD 50, and MD 70, TE20.
Expertise in Oracle Applications, SQL and PL/SQL Database, Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML/BI Publisher, Discoverer and WEB-ADI.
Dextrous Knowledge in Oracle Application architecture 11i & R12 Multi-Org features.
R12 Techno-Functional knowledge in O2C (Order to Cash), P2P (Procure to Pay), OPM (Manufacturing), Inventory, Financials (AR, AP, GL) and HRMS modules.
Worked on creating PLSQL Interface packages using standard Oracle APIs for Financials, Accounts Receivables, Payables, Order Management and AOL modules.
Asset and Change Management experiences in Jira, ServiceNow, PVCS, Serena.
Experience in developing forms and reports using Oracle Developer tools 6i & 10g.
Adroit and Certified in Performance tuning and Optimization.
Strong Experience in Advanced PL/SQL Packages, Procedures, Indexes, Functions, Bulk Collections, Dynamic SQL, Collections (Nested tables).
Good knowledge in tools like TOAD, Putty, SQL and Data Loader, Kintana, PVCS, SVN.
Excellent communication, interpersonal, Analytical and problem-solving skills. SKILL SET
Oracle Application Modules Order Management, Procure to Pay, Inventory, GL, Accounts Payable, Accounts Receivable, Manufacturing, HRMS, Finance. Development Tools Oracle Developer Suite 6i/10g Forms/Reports, XML/BI Publisher, Discoverer, Workflow Builder.
Oracle Tools SQL*Plus, Toad, PL/SQL Developer, SQL Developer, Data Loader, Web ADI
Languages SQL, PL/SQL, HTML, XML, UNIX.
Others FTP Tool, WinSCP, Putty, Unix Shell scripts EMPLOYMENT HISTORY
Company Position Period From Period To
Cognizant Technology Solutions Technology Architect 09.2010 Till Date CCS Global Delivery Centre Application Developer 09.2007 08.2010 CMA CGM IT Resources Junior Application Developer 03.2007 09.2007 EDUCATION
Degree University, Country Period From Period To
Bachelor of Engineering (B.E) in
Computer Science
Anna University, India 06.2002 06.2006
3 P a g e
CERTIFICATIONS
Title Provider Year
Oracle Developer 12c BRAINBENCH 2020
1Z0520 - Oracle EBS R12.1 Purchasing Essentials ORACLE 2016 Oracle Database 11g: Advanced PL/SQL ORACLE 2011
Oracle Certified Professional ORACLE 2009
Oracle Certified Associate ORACLE 2009
ITIL v3 Foundation Level EXIN 2009
EMPLOYMENT HISTORY
Technology Architect 04.2016 till Present
Employer: Cognizant Technologies Gmbh Germany, Nuremberg Business: Rail Services, Financial Services, Telecom Environment: Oracle E-Business Suite i.e. SCM, HRMS, Receivables (AR), Order Management.
Project Lead, Architect and Developer for Upgrade of Oracle Application from 11i to R12.2.9 (latest) with Database Version from 11.2.0.3 to 19C (latest) Architecture.
Actively participate in the full SDLC cycles including Analysis, Design, Development, Testing, Implementation and Maintenance of Complex Oracle RDBMS (ERP Suite).
Bulk Collection Techniques, Partitioning of Tables, Materialized Views, Dynamic SQLs, Indexes and Analytical Functions are widely used.
Develop High Level Technical Design Document (MD70) & Functional Document (MD50).
Designing and building a point-to-point integration between legacy systems and Oracle ERP.
Extensively using Triggers, Sequences, Indexes, Packages, Stored Procedures, Functions, XML Publishers & UTL_FILE Process.
Development, Technical solution concepts for Customer-specific (customization).
Working on Enhancements, Development and Code Review with Performance Tuning.
Defining Concurrent Programs, Request Sets, Executables, Value Set, Responsibility, Function, Menu and User using AOL module.
Looks for an opportunity to Automate and Innovate new techniques.
Optimize query statements for better performance and proactively identify issues.
Delivery of Unit Testing (TE20) and User Acceptance Testing (UAT).
Rollout and Upgrade Activities of R12.2.6.
Single Point of Contact for Asset and Change Management usage for Upgrade Project. Senior Techno Functional Consultant 09.2010 till 03.2016 Employer: Cognizant Technologies India, Chennai
Business: Manufacturing, Life Sciences, Consumer Goods and Retail Environment: Oracle E-Business Suite i.e. SCM, MDM, Inventory.
Managing with multiplicity of teams in both Onshore and Offshore Model to ensure the solutions meet the user requirements whilst complying with industry standards
Cursors, Ref Cursors, PLSQL collections, Nested Tables, Associate Arrays, Varray and Nested objects are widely used.
Developed and fine-tuned Bulk Collections, Triggers, Autonomous transaction, PLSQL coding guidelines and Best practices.
4 P a g e
Interfaces and Conversions (Inbound & Outbound) across Legacy systems.
Good Understanding of Package, procedure, functions, DDL, DML concepts.
Creation of AIMS Technical and Functional Oracle Standard documents i.e. MD70, BR100.
Performed Data analysis, Data cleaning, Data migration from legacy system to Oracle.
Detailed analysis of functional customer requirements, database and user interface design, development and testing and system documentations.
Working with team members, managers and business Subject Matter Experts (SME’s) from other Project domains for Integration and Change Management purposes.
Post Implementation Support for SCM, Procurement and Financials.
Experience in performance tuning of SQL, analyzing the AWR (Automatic workload Repository) report, Trace file output and Advanced SQL writing skills.
Conceive and formalize detailed technical specifications based on analysis and clarification of detailed functional specifications and architectural design.
Oracle Alerts and Scheduling Process.
Oracle Application Developer 09.2007 till 08.2010
Employer: CCS Global Delivery Centre UAE, Dubai
Business: Cargo Shipping and Transportations
Environment: Oracle E-Business Suite i.e. Financials, Oracle Projects, PTP, SCM.
Business Process Analysis, Design and Coding.
Functionally involved in Defining Concurrent Programs, Request Sets, Executables, Value Set, Responsibility, Function, Menu and User using AOL module.
Production Review and Communication of Use-Cases that satisfied Business Requirements.
Preparing the MD070 for all customizations.
Customized the PL/SQL script to automate pricing Setups without manual intervention.
Tune the query to improve execution time of the long running queries.
Worked with SQL Trace, TKPROF in generating statistics for better performance.
Development of new PL/SQL Procedures, Functions, Triggers, Forms and Reports.
Coordinate with DBAs for all the development tasks.
Experience in performance tuning of SQL, analyzing the AWR (Automatic workload Repository) report, Trace file output and Advanced SQL writing skills. Junior Application Developer 03.2007 till 09.2007
Employer: CMA CGM IT Resources India, Chennai
Business: Cargo Shipping and Transportations
Environment: Oracle E-Business Suite i.e. EDI, InterModal Transportations.
Responsible for writing Packages, Procedures & Triggers for Complex Database System.
Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.
Data Extraction, Data Migration, Data Fix, Report development, Performance tuning.
Work with SQL*Loader to import and export data from flat files in & out of legacy database.
Create various DDL and DML statements using SQL and PL/SQL.
Participation in creation of database objects like Tables, Views and Materialized views.
Exceptional Troubleshoot and debugging skills.
Contact this candidate