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.