We provide IT Staff Augmentation Services!

Oracle E-business Suite Resume

San Jose, CA

SUMMARY

  • A competent professional with 2+ years of experience in Information Technology which includes all phases of Software Development Life Cycle from Requirement Gathering, Design & Development, Testing, Administration & Implementation and Production Support.
  • Solid experience working on Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2003/2005/2008 , Toad 7.0/9.2, SQL Developer 3.2, SQL, PL/SQL.
  • Installed & configured database software, associated database tools and performance monitoring software.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Created, administered & maintained SQL Server Databases
  • Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, Packages and Triggers.
  • Designed database schema's using Entity relationship modeling with ER diagrams & database normalization principles.
  • Experienced in SQL Loader, Export and Import Enforcing security by creating roles, granting system and object privileges on the Tables, stored procedures.
  • Strong knowledge on Oracle architecture and database design.
  • Enforcing data integrity using integrity constraints & database triggers.
  • Good understanding of oracle Data Dictionary and Normalization Techniques.
  • Developed Data Mapping and Data Conversion scripts using SQL and PL/SQL.
  • Ability to explain technical concepts and communicate with users and system administrators at all levels. Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
  • Expertise in handling the customers in 24x7 scenarios and production support.
  • Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support.
  • Superior communication, presentation, analytical and problem solving skill.
  • Self - motivated and enjoy working in a technically challenging environment.
  • Ability to work under stringent deadlines within a team as well as independently.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008 , MySQL and MS ACCESS

ERP: Oracle Financials (10.0.7, 11.03 and 11i) - i-Procurement, i-Receivables, iExpense, Oracle Accounts Payables, Oracle General Ledger, Oracle Purchasing, Oracle Federal Financials, Oracle Order Management and Oracle Accounts Receivables

Languages: SQL, PL/SQL, C, HTML, XML, Java, ASP.Net

Tools: TOAD, SQL Developer, Oracle Enterprise Manager 10g, SQL*Plus, SQL*Loader, ERWIN, Oracle Forms and Reports 6i, Pro*C, MS Visual Studio/Office

Operating System: Windows7/ NT/2000/98/95, DOS 6.0/3.0, UNIX

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Oracle E-Business Suite

Responsibilities:

  • Achieved the high level hands-on knowledge in different oracle e-business suite supply chain and financial modules: GL, AP, OM, PO, TCA, i-Expense, i-Procurement and AR.
  • Tested the implementation of 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
  • Analyzed systems design specifications and developed Test Plan, Test Cases to perform overall QA testing.
  • Involved in working with users, identifying functional and technical gaps, estimating work to fulfill business requirements, designing custom solutions, programming, scheduling, documentation, and production support.
  • Prepared Test Scripts for Oracle Financial modules, Manufacturing Modules and Oracle HRMS as part of the Release 11.5.9/11.5.10.2 implementation
  • Analyzed upgrade issues with code errors, performance and data corruption issues.

Env ironment: ERP(Oracle Financials, GL, AP, AR, PO,OM, i-Procurement, i-Expense), Oracle 11g/10g/9i/8i, SQL 2000/2005/2008 , MySql, Toad 7.2, SQL*Plus, SQL*Loader, PL/SQL, UNIX, Windows NT.

Confidential

Junior SQL DBA

Responsibilities:

  • Served as DBA in the completion of medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
  • Installed & configured database software, associated database tools and performance monitoring software.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
  • Participated in designing, testing and implementing an enterprise Disaster Recovery Plan. Monitored data activities (i.e. database status, logs, space utilization, extents, checkpointslocks and long transactions).
  • Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
  • Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc.
  • Creating E-R Diagram, Function Hierarchy diagrams, Process diagrams and Data flow diagrams for designing database.
  • Involved in the Analysis, Design, Coding and Testing of the application.
  • Proven ability to handle Database of more than 1 TB in Size.
  • Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
  • Used SQL*Loader to load bulk data from various flat files.
  • Developed complex triggers in reports before/after for validation of user input.
  • Extensively Used JOINS writing views in the Database.
  • Created and used different type of Indexes and Sequences.
  • Extensive tuning of application SQL Statements.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Forecasting the need to change the existing system and re-aligning the existing functionalities according to the business expansion.
  • Ensuring that underlying client processes are followed and integrity is maintained.

Env ironment: Oracle 11g/10g/9i/8i, SQL 2000/2005/2008 , MySql, Toad 7.2, SQL*Plus, SQL*Loader, PL/SQL, UNIX, Windows NT.

Hire Now