Objective :Aspiring to work in the field of Software Engineering, where an opportunity exists to work on challenging projects and to increase knowledge for the benefit of organization and self.

Professional Summary

• Around 8 years of IT experience in Analysis, Design, and Implementation as a Technical consultant for Oracle ERP Applications. Highly motivated, enthusiastic professional with a high degree of commitment to succeed. Recognized by management at different occasions for dedication and devotion at work in various projects. Have Extensive experience in IT Industry, in different phases of the software development life cycle such as requirements gathering, analysis, design, development, administration, testing, implementation and documentation of general application Ability to work independently, key team player and effectively promote teamwork. Gained valuable experience and knowledge over the span of my career as follows:
• Have experience in Implementation, Development, Customization, Testing and, Production Support of Oracle Applications, mainly in CRM, SCM and Financials Domains.
• Possesses sound knowledge of System Administration part of Oracle applications, Concurrent Program Registration, Responsibilities, Menus, and Functions etc.
• Have experience in testing, Implementation, post go-live support
• Comfortable researching issues on Metalink, reading source code and following eTRM’s. Has worked extensively on Oracle TAR’s via Metalink. Has very good working knowledge in Technical Documentation.
• Have thorough hands on experience in using PL/SQL, SQL, Oracle Reports 6i/10g, Oracle Forms 6i, , TOAD, SQL Developer, SQL*Plus, Oracle BI/XML Publisher to generate reports in PDF,HTML formats, SQL Code Tuning. Involved in development of RICE components using SQL, PL/SQL, as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques in Oracle Application.
• Designed, developed and tested customized Oracle Applications technical components for various industry segments like Wireless Field service (WFS), Install Base. (IB), Field Service (CSF), Contracts (OKC/OKS), Order Management (OM).
• Good working knowledge in Technical Documentation.
• Good exposure in migration of Oracle database from 9i to 10g.
• Excellent work ethics and interpersonal skills that help in communicating with the fellow team members, Managers, Developers and Users. Ability to handle multiple tasks and work independently as well as in a team.
• Highly motivated, hardworking, able to meet tight deadlines, thorough in project completion and possess excellent communication and analytical skills.

Educational Details

• Bachelor of Technology (B.Tech) in Electronics and Communication Engineering

Expertise Profile

Oracle skills:

PL/SQL, SQL, Oracle - Developer 2000/6i (Forms, Reports), Toad 6.0/8.0,, SQL* Plus, XML reports ,Oracle BI Publisher,workflow,sql server

ERP (Enterprise Resource Planning):

Oracle E-business suite 11.5.10..2 version, Modules worked on(CRM): Field Service(CSF) , TeleService isupport ,Depot repair, Install Base (IB), Contracts (OKC/OKS),Wireless Field Service(WFS),Oracle Retail, Oracle Identity Management,Manufacturing,HCM
Order Management (OM) ,AP,AR,GL,INV,WIP,HR modules, Oracle Pricing, Oracle Multi – Currency, Oracle Quoting

Languages:

SQL,PL/SQL,Java, JSP,ASP,PHP, C,C++,HTML,XML, .NET, UNIX Shell scripting, Microsoft SQL Server programming

Others:

MS-Word, MS-Excel, MS-PowerPoint

Databases:

Oracle 9i,10g

Environment:

Windows NT, Windows 95/98/2000, UNIX, MS DOS

Version Control
Systems:

PVCS

Projects Summary

Confidential,Emerson. Jan 2007– till date
Position: Oracle Applications Technical Lead /Oracle DBA
Organization: Emerson, Ohio

Confidential, is a diversified global manufacturing and technology company. It offer a wide range of products and services in the areas of network power, process management, climate technologies, storage solutions, professional tools, appliance solutions, motor technologies, and industrial automation. Recognized widely for engineering capabilities and management excellence, Emerson has more than 120,000 employees and approximately 250 manufacturing locations worldwide.

Project Description:
Emerson is widely spread across the world giving services on various products. This project involves in providing consulting and supporting services in Customer Relationship Management (CRM), Supply Chain Management (SCM), Projects and Finance Modules to users across the world. This includes solving issues in client day to day business activities. The major Customizations include the Customization of CRM, SCM, and Finance modules. The other customizations include development of Custom D2K reports, XML Reports for Install Base and JSP reports. Major Challenges include understanding the client’s requirement and design a solution that fits well to the need, applying fewer loads on the server during the execution of the scheduled programs.

Roles and Responsibilities

• Primary responsibilities developing, testing, supporting and maintaining standard and custom extensions to Oracle Applications Version 11.5.10.
• Worked on PL/SQL stored procedures, Functions and Packages to implement business rules for eligibility review module.
• Worked as a Team Lead for a group of 3 members.
• Involved in DBA activities like creating tables, indexes, views, synonyms and granting permissions to the users.
• Involved in Migration of Scripts, Packages, Enhancements for Test Releases and UAT Releases
• Worked on performance tuning and used EXPLAIN PLAN for tuning the queries
• Involved in Creating different complex joins according to User requirements
• Involved in analyzing complex queries and worked on performance tuning
• Worked on SQL *Loader to load data into database tables from flat files
• Developed Oracle Alerts to notify the manager if new orders are created
• Created Test cases and developed develop Unit Test documents for the RICE objects.
• Developed different reports using OracleD2K,Agile reports, BI/XML publisher ,Java,JSP such as Field Service Reports .Have good hand on experience on Oracle forms and reports
• Have very good experience in Bulk processing,REF cursors, collections, DBMS packages
• Worked on oracle apps modules like OM, Manufacturing modules, CRM, Oracle Identity Management, Retail modules.
• Have experience on multi org structures.
• Have ability to work on complex queries, triggers, views, materialized views, ref cursors.
• Worked on development of reports on Oracle Identity Management.
• Worked on Ralph Kimball approach for data modeling also worked on Reports, interfaces, conversions, extensions. Also have ETL experience.
• Have experience On Data ware housing, dimensional modeling, Have worked on OLAP
• Have Knowledge on EDI
• Have expert level experience in developing complex SQL, PL/SQL stored Procedures, Packages and functions.
• Performed front end registration of various developed objects with Oracle application
• Involved in managing concurrent programs, defining responsibilities to a particular user setup
• Registered generated reports, Flex fields. Defined Descriptive Flex fields, value sets and also registered PL/SQL, stored procedures, SQL*Plus scripts etc. Involved in maintenance and support for customization of Forms, Reports and PL/SQL code.
• Tar logging, follow up and working with Metalink.
• Worked as a member of ERP Data Migration Support Team. Resolved the bugs and improved the performance of the existing programs
• Have experience migrating the scripts during upgradation of oracle data base from oracle 9i to 10g.
• Participated in code reviews, unit test plan reviews, and other quality reviews defined by the system development lifecycle (SDLC). Identified and escalated issues that impacted testing progress
• Mentored junior programmers in Oracle database design and development
• Worked on a sub project using .NET. Designed web pages.
• Worked on Quality Assurance, Worked on Version control Systems
• Involved in enhancements and maintenance
• Involved in code walk through and review sessions with the development team
• Involved in production support

Environment
Oracle Applications 11.5.10, Oracle 9i, Oracle Forms Builder 6i, Oracle Reports Builder 6i, Toad, Java,JSP,Java Script, SQL,Sybase, SQL Oracle BI Publisher. Classic ASP,HTML,SQL Loading

Confidential,Infosys Jun 2004– Jan 2007

Position: Oracle Applications Technical Consultant
Organization: Infosys Technologies Ltd, India

Confidential,is one of the biggest names in the Indian IT industry. This multinational IT services company with offices in 22 countries and development centers in India, Japan, China, Australia, UK and Canada, is headquartered in Bangalore, India Infosys Technologies Ltd. It defines, designs and delivers technology-enabled business solution to its clients worldwide. It leverages its domain and business expertise as well as the strategic alliance with leading technology providers while developing its business solutions.

Roles and Responsibilities:

• Primary responsibilities include defining, designing, developing, testing, supporting and maintaining standard and custom extensions to Oracle Applications Version 11.5.10
• Involved in all stages of development with strong implementation skills spanning Full life cycle implementation and production support
• Developed Customer Service report and Time sheet report need for service engineer in Field Service CRM using JSP, D2k reports, BI Publisher reports.
• Developed a customization where a service engineer can run the reports and send the reports in mail as attachments. This customization is done both in Oracle and java using UTL _FILE, UTL_SMTP, Blob concepts. Developed Engineers report in Order management to retrieve all the internal orders raised by the service engineer using XML Publisher report. Created a report that shows the On-hand-Quantity of Items for service engineers and their Sub-inventories.
• Developed Signature capture customization where a service engineer can capture signature of the customer on the customer service report using his laptop during his work and send it back to the office. This saves lot of time for the service engineer
• Creation of various Oracle Alerts (ALR) to inform internal users of certain events, or to notify customers of account status (e.g., all active service contracts). Developed Alerts in Inventory Modules
• Involved in analyzing joins to improve performance of reports.
• Performed front end registration of various developed objects with Oracle application. Programmatically created concurrent program registration, created new concurrent request set and scheduled the new conversion programs to run automatically
• Designed and Developed Stored procedures, Functions and Triggers in PL/SQL to implement complex business rules. Performed Test running the objects as per the test scenario document
• Code migration and quality checks through trace file analysis are rigorously done before the objects are migrated to Production.
• Worked on a sub project using .NET. Designed web pages.
• Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers using EXPLAIN PLAN
• Developed many test scenarios in the applications and also in the database. Involved in unit testing and integrated system testing (both standard functionality and custom functionality), working with Oracle on bugs, developing new business processes, writing training documentation, and configuring the application during go-live. Involved in the process of bug fixing after QA and UAT .Involved in Post Production issue resolution and bug fixing
• Maintained Version Control System for all the codes. Worked on various Oracle TAR‘s using Metalink. Worked with people from Oracle Corporation to solve various issues in oracle applications also involved during patch application

Environment:
Oracle Applications 11.5.10, SQL, PL/SQL, Oracle 9i, D2K Reports, JSP, XML Publisher, Toad, SQL*Plus, UNIX, .NET, UNIX Shell scripting, ASP, PHP.

Confidential,, Hyderabad India Sep 2002– Jun 2004

Position: Oracle Applications Technical Consultant
Organization: Infosys Technologies Ltd ,India

Confidential,is one of the biggest names in the Indian IT industry. This multinational IT services company with offices in 22 countries and development centers in India, Japan, China, Australia, UK and Canada, is headquartered in Bangalore, India Infosys Technologies Ltd. It defines, designs and delivers technology-enabled business solution to its clients worldwide. It leverages its domain and business expertise as well as the strategic alliance with leading technology providers while developing its business solutions.

Roles and Responsibilities:

• Primary responsibilities include developing, testing, supporting and maintaining standard and custom extensions to Oracle Applications Version 11.5.10
• Developed reports for on hand quantity for a service engineer used in Order Management (OM), Field Service (CSF).
• Created Custom Triggers, Stored Procedures and SQL Scripts
• Developed scripts using FNDLOAD to migrate concurrent programs, value sets, concurrent managers and profile options.
• Used SQL loader and UTL_FILE package to load the data from the files provided by the interfacing applications.
• Wrote several Procedures, Functions, Triggers & Packages and Used Native Dynamic SQL in stored procedures
• Query Tuning to run the reports/scripts faster.
• Developed many test scenarios in the applications and also in the database. Involved in unit testing and integrated system testing (both standard functionality and custom functionality),
• Maintained Version Control System for all the codes.
• Designed and developed shell scripts for various processes like FTP the data to remote servers, email the error log files to users, and archive and zip the data files.

Environment:
Oracle Applications 11.5.10, SQL, PL/SQL, Oracle 9i, D2K Report, SQL*Plus.