SUMMARY
Over seven years of IT experience of ERP implementation and Enterprise Applications Practice with proven experience in Developing, Customizing and Supporting Oracle Applications 11.0.3 and 11i (AR, AP, GL, PO, INV, OM, CRM, SCM), AOL of Oracle E-business Suite. These include Analysis, Design, Development and Implementation of different projects for applications based on Relational DBMS and in the field of Oracle e-business Suite. Expertise in database performance, data warehouse, ETL, SQL queries, PL/SQL procedures, packages, functions, cursors, triggers, interfaces and data conversion using PL/SQL, SQL*plus, TOAD, and SQL developer & full suite of Oracle Tools including development and customization of Oracle Developer (Reports & Forms) and Oracle discoverer. Strong understanding of business processes with good domain knowledge in Manufacturing and Supply Chain Management. Oracle Certified Associate (OCA) FUNCTIONAL EXPERTISE
Good insight into the functionality of Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Purchase Order (PO), Order Management (OM), Inventory (INV), BOM, WIP and Oracle Application Object Library (AOL) Good functional expertise on Open Interfaces (inbound and outbound interfaces) in Oracle Financials. Exposure to Accounting Business Practices used in Oracle GL Very good practice and experience in setting up and customizing Accounting Flexfield of General Ledger based on the Organization’s business setup. Adept in planning Security rules and Cross validations for GL, AR, AP Flexfields. Experience in working with Enter Journals, Post Journals and Posting Programs, good understanding of Journal Entry Headers and Lines model. Insight into AR Transactions and Receipts process flows and setups Proficient with the architecture of Global Descriptive Flexfields and various Common Country Features. TECHNICAL COMPETENCE
Good Expertise in developing applications using SQL, PL/SQL, Database Triggers, Stored Procedures, Oracle 11i/9i/8i and Developer 10g/6i (Forms 10g/6i, Reports 10g/6i). Good Expertise in PL/SQL Good Expertise in Query and Performance tuning in Oracle. Hands-on experience in MS Access to Oracle 10g database conversion. Hands-on experience in analyzing the Oracle SQL Raw Trace and TKPROF trace files in working query and database performance issues. Hands on experience implementing and supporting Procure-to-Pay and Order-to-cash and plan-to -build processes in Oracle 11i/R12 applications. Hands on experience in designing and implementing scalable OLTP and DSS database systems. Experience with RAC Software Storage Principles & Database Storage Principles along with RAC and Instance/Crash Recovery, Database Storage Consolidation. Hands on experience with Oracle RAC 10g Installation and RAC performance tuning. Experience working with ERwin data modeling tool. Skilled and experienced in UNIX Shell scripting and worked extensively on Unix/Solaris/Linux platforms. Extensive experience in conversion of legacy data into Oracle Applications using SQL Loader and PL/SQL. Good experience in working with Oracle Discoverer. Strong expertise on Workflow customizations & Form personalization to meet functional/business requirements. Proficiency in Oracle Application Implementation Methodology and Software Development Life Cycle (SDLC). Worked Extensively in Conversions and Interfaces in most of the Financial Modules. Extensive hands on experience using most of the API’s. Highly skilled in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications. Experience with design and implementing oracle security with Oracle Internet Directory for data storage and synchronization services. In-depth Experience in using Oracle Application Object Library (AOL) features including implementation of Flex fields (Like Implementing Cross Validation Rules, Implementation flex fields in reports, Security rules), creating and scheduling of Concurrent programs etc. Highly skilled in the use and concepts of Global Descriptive Flexfields that are used to seed country specific features for Financials Globalization Extensive experience in design and development of applications under UNIX and Linux environments. Good insight into the process flows and data model of Oracle General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Order Management (OM), Purchasing (PO), Fixed Assets (FA), Inventory (INV), Service Contracts , BOM, WIP, Install Base modules and CRM. Experience in creating and integrating custom built Forms with Oracle Applications and in using CUSTOM.pll library. Keen focus on performance tuning, testing, and quality assurance. Experience in supporting Production Systems on 24x7 cycle following Six Sigma standards. Extensively used GE Support Central & HP ServiceDesk for issue tracking & reporting. Skilled in preparing and delivering presentations to both technical and executive positions. Good understanding of system development process, from initial planning through deployment. TECHNICAL SKILLS
ERP
Oracle Financials Release 11i/R12, Financials (AR, AP,GL,FA) ,Manufacturing (PO, OM, INV) and CRM
Others
Oracle Application Object Library (AOL)
Databases
Oracle9i/10g, SQL Server (v7.0)
Development Tools
Oracle Developer 6i, Forms 6i, Reports 6i, Workflow Builder, Oracle Discoverer, XML Publisher
Programming Languages
C, C++, SQL, PL/SQL
Operating Systems
Windows XP/2000/NT/98/95, UNIX, Linux, Solaris.
Case Tools
Oracle Designer 2000
Version Control Tool
CVS, RCS
Tools
TOAD, SQL*Plus, SQL-Navigator, Informatica, ERwin data modeler and SQL*Loader.
CERTIFICATIONS
Oracle Certified Associate (OCA)
PROFESSIONAL EXPERIENCE
Confidential,10/08 to 12/09
Oracle Application Developer
Abacuss Software Technologies is a leading provider of enterprise software and consulting services. The company specializes in custom software application development and business integration services for enterprise customers, as well as small to medium size businesses.
The project involved an implementation of Oracle Applications 11i/R12modules like OM ,AR, AP, PO, FA, INV, BOM, WIP, SCM, Service Contracts , Install Base and GL. This work included data migration from a legacy system to Oracle tables. Work involved customizing the forms and reports and developing new forms and reports.
Role & Responsibilities:
Worked on Oracle Applications Release 11.5.10/ R12. Responsible for the technical design, program development, unit testing and migration of AP Invoice Interface. Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules AR, GL, AP , FA, OM, SCM, INV, Service Contracts , Install Base modules and PO. All the interfaces were registered and run through the concurrent manager. Customized Reports and Forms to meet user requirements mainly in financial modules (AP, GL, and AR). Hands on experience on Oracle EBS 11i/R12 P2P (iProcurement, AP, PO, iSupplier) modules. Hands on experience on Oracle EBS 11i/R12 SCM, BOM, WIP modules. Involved in creating new XML Reports using XML Publisher and customization of existing Reports, Forms and PL/SQL Procedures in Oracle Applications. Experience on Oracle Fixed Assets (FA) module - General Ledger entry processing, Journal entries, asset set up , year end process and global updates. Hands on experience with Oracle RAC 10g Installation, RAC performance tuning and Connection Load balancing in RAC . Experience working with ERwin data modeling tool. Used Oracle Directory Service Manager to integrate OID with Oracle Enterprise Manager to centrally manage and monitor all services, including Oracle Fusion Middleware, Oracle Databases, and Oracle Applications. Experience with testing and debugging Oracle Internals, Architecture and Performance issues. Install, create and manage several development, test and production Oracle 9i database. Setup client/server connections for developers, create databases, table spaces for different application schemas; enroll users, and setup auditing. Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests. Write extensive PL/SQL procedures, functions, packages, cursors. Created validation procedures to execute along with customer interface and vendor programs to support the interface requirements Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs. Created triggers for transaction adjustment, Auto Adjustment, defined Vendors, Invoices, Tracking of payments, Prepayments. Integrated Legacy purchase order Information with Oracle Payables Interface. Environment:
Oracle Applications 11.5.10/ R12 (GL, AP, AR, FA and PO), Service Contracts , Install Base modules Oracle Database 9i, Developer 6i – (Forms and Reports), SQL*Loader, Windows XP, UNIX
Confidential,Atlanta, GA 12/06 to 10/08
GAMS EAST Juliet Project Oracle Application Developer
Description:
Worked on a real time production support project (GAMS EAST Juliet) extending 24/7 support to clients in Germany and US for General Electric (GE Energy). The project involved the implementation of ORACLE APPLICATIONS 11i that includes implementing AR, GL, AP, OM, PO, INV, CRM,HRMS modules, writing interface programs according to user and business requirements and developing several forms and reports according to the functional specifications provided.
Role & Responsibilities:
Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA,OM, INV, SCM,CRM). Configuration of General Ledger for multiple sets of books and integration with AP & AR. Hands on experience on Oracle EBS R12 P2P (iProcurement, AP, PO, iSupplier) modules. Hands on experience on Oracle EBS R12 SCM, BOM and WIP modules. Performed data conversion from legacy system to oracle modules using SQL*Loader. HRMS integration with other Oracle Applications, including Shared and Full installation considerations. Implemented Oracle Demantra applications like demand management, sales & operations planning, and trade promotions management solutions. Worked on integration interface, workflow, methods, series and system parameters of Demantra. Provided Technical support activities resolving internal TARs and RFCs. Responsible for TAR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp. support staff working remotely. Provide data fixes to GE Energy wherever required. Worked on hosted CRM using Oracle CCA (Contact Center Anywhere) product. Worked on Oracle CRM modules (Oracle foundation, Contracts, Installed base) Worked on code modifications and project enhancements based on client requests. Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs. Customized standard reports like open Sales order report and AR Customer Invoice Report. Developed XML Reports using XML Publisher. Involved in custom objects integration activity with Oracle Applications and interaction with other functional and technical teams. Testing applications including unit testing and pre-integration testing. Work on preparing documentation (Technical and functional) conferring to GE standards. Environment:
Oracle Applications 11.5.10 /R12(GL, AP, AR, FA, OM, INV , SCM, CRM and PO), SQL*Loader, Oracle Database 9i, Developer 10g – (Forms and Reports), Discoverer 1og and Stored Procedures for business logic using PL/SQL on HP-Unix.
Confidential,Atlanta, GA 03/06 to 11/06
GAMS EAST BOP Foxtrot Project Oracle Application Developer
Description:
Worked on a real time production support project (GAMS EAST Foxtrot) extending 24/7 support to clients in US for General Electric (GE Energy) as a consultant through Satyam Computer Services. The project involved the implementation of ORACLE APPLICATIONS 11i ERP that includes implementing Oracle Financials and Distribution modules.
Role & Responsibilities:
Worked on various Financial and manufacturing modules (GL, AP, AR, PO, FA, OM, INV, BOM, WIP) and CRM. Worked on MS Access to Oracle 10g database conversion including tables, queries, standard procedures, forms and triggers. Configuration of General Ledger for multiple sets of books and integration with AP & AR. Worked on hosted CRM using Oracle CCA (Contact Center Anywhere) product. Worked on Oracle CRM modules (Oracle foundation, Contracts, Installed base) Worked on code modifications and project enhancements based on client requests. Worked in the support system, performed the responsibility of system administration which involved creating users, setting up the user profile, registering and managing the concurrent programs. Customized standard reports like open Sales order report and AR Invoice Report. Developed XML Reports using XML Publisher. Created PL/SQL packages to perform validations on the imported data from legacy system. Worked in creating menus, functions, sub functions, defining responsibilities and Segregation of Duties. Developed Concurrent Programs and Executables for the SQL*Loader, Package and Report and run them as a request set. Provide data fixes to GE Energy wherever required. Provided Technical support activities resolving internal SRs and RFCs. Responsible for TAR creations & escalation process and resolving functional & technical issues by coordinating with oracle corp. support staff working remotely. Involved in custom objects integration activity with Oracle Applications and interaction with other functional and technical teams. Testing applications including unit testing and pre-integration testing. Work on preparing documentation conferring to GE standards. Environment:
Oracle Applications 11.5.10 /R12(GL, AP, AR, FA, BOM, WIP, OM, INV, CRM and PO), SQL*Loader, Oracle Database 9i, Developer 10g – (Forms and Reports), Discoverer 1og and Stored Procedures for business logic using PL/SQL on HP-Unix.
Confidential,India 08/05 to 02/06
Unison Project Oracle Application Developer
Description:
Project implemented oracle financials and manufacturing application for efficient operation of the company. The project involved development of custom FORMS and REPORTS and query optimization.
Role & Responsibilities:
Customized Reports and Forms to meet user requirements mainly in financial modules (AP, AR, and GL). Developed SQL scripts to transfer data from the Legacy system into the staging tables. Developed PL/SQL packages to validate and load the data into the Interface table. Imported journals through Journal Import, which imported the data into the base tables. Enabled Descriptive Flex fields on Invoice Distributions to capture additional information Involved in SQL Tuning using the TKPROF Utility. Write scripts to create tables, indexes, views, aliases and synonyms to meet developer requests Write extensive PL/SQL procedures, functions, packages, cursors. Worked on SQL query optimization. .
Environment:
Oracle Applications 11.5.5, SQL, PL/SQL, Oracle 9i, Developer 6i – (Forms and Reports), TOAD and UNIX.
Confidential, India 01/05 to 07/05
Activation Project Software Engineer
Description:
Shyam Telecom Ltd. is a public limited company promoted, in 1992, by a group of first generation entrepreneurs and Shyam Antenna Electronics Ltd. The core business focus of the company is manufacturing of telecommunications equipment. The services offered to the subscribers are through wireless as well as wireline network. The company provides high bandwidth and self protected backbone which provide highly reliable super highway connecting various cities throughout the country in the ring.
Role & Responsibilities:
Worked on Real time product support project on features related to call processing, barring and unbarring calls, routing and charging on Siemens and Ericsson Switch. Worked on AXE810 ERICSSON for WIRELESS SWITCH & SIEMENS EWSD Switch. Worked on CDMA wireless. Subscriber complains regarding routing, charging, subscriber features related to wireless & wire line. Activation of Wire line, City Mobile, CDMA Technologies. Wrote various shell scripts for WLN/WLL switch and core-DECT. Making of various CENTREX’S and HUNTING GROUPS on Siemens EWSD SWITCH. Designed and developed a report showing accounts receivable by region. Environment:
AXE810 ERICSSON, SIEMENS EWSD Switch, UNIX, WINDOWS XP/2000
Confidential,06/03 to 12/04
Apex Project Software Engineer
Description:
BSNL is India\'s no. 1 Internet service provider with more than 17,00,000 subscribers, providing Internet service throughout the entire country. The project involved the Implementation of FRS (Fault Repair System), DQ (Directory Enquiry), IVRS (Interactive Voice Response System) and accounting and billing systems.
Role & Responsibilities:
Worked for India’s leading telecom provider to study SS7 signaling implementation. Worked on AXE810 ERICSSON for WIRELESS SWITCH & SIEMENS EWSD Switch. Worked with test tools on SS7 physical line analysis (frequency, voltage, alarms etc). Analysis of jumpering and grounding practices. Environment:
AXE810 ERICSSON, SIEMENS EWSD Switch, UNIX, WINDOWS XP/2000
Confidential,India 05/02 to 05/03
GDR Project Software Trainee
Description:
Orane isa leading IT services company of India. It serves the embedded & Real time software community in international and domestic markets by our Value offerings and services. The project involved development of Point of sale device and integrating POS application.
Role & Responsibilities:
Developed application for Pocket PC and implemented on Compaq iPaQ Worked extensively on Embedded VB or Embedded VC++. Two-way data synchronization between any number of mobile computers and major SQL-based databases such as Oracle, MS SQL Server, Access or other. Environment:
Embedded VB, Embedded VC++, Oracle, MS SQL Server
Web Development
01/09 to 12/09
Developed web application backend and frontend for admitting Masters and PhD students using MVC. Developed web application backend and frontend for university class schedule & student registration supporting all real world constraints using MVC. Tools: MySQL, Java, JSP, AJAX and Struts and Apache Tomcat Familiar with Linux, Apache, MySQL and PHP toolset EDUCATION
- Bachelors in Engineering (Computer Science Engineering)