SUMMARY

• I am a Security+ certified professional wif quite adroit at Systems design, development, implement and maintain Oracle Applications wif an experience spanning over twenty two years in IT industry.
• During teh past sixteen years, I has provided Oracle E - Business Suite and Oracle-centric technical expertise for around ten clients (Federal, state, county governments and commercial clients).
• Even though Oracle Applications DBA / Solution Architect is my core skill, in recent years, I was providing my expertise in Oracle WebLogic, OBIEE, SOA administration, Security, Systems Analysis, and Enterprise Solution Design etc.
• Because of teh fact dat I was involved in different roles throughout my career, I has a strong exposure to Oracle administration and development tools.
• My varied experience developed teh team management and communication skills necessary to ensure successful solution delivery.
• My customer-first attitude enables me to make decisions dat best fit client needs and strengtans customer relationships.
• I am viewed as a “solution provider” who will learn new technologies dat provide teh most value to teh customer.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business Suite Rel.12, 11i, 11.x, 10.7 NCA, 10.7 SC.

Oracle DB Servers: Oracle 11.x, 10.x, 9.x, 8.x, 7.x, 6.x.Oracle Fusion

Middleware products: Oracle WebLogic, OBIEE, Oracle Identity Management, WebCenter

Operating Systems: Linux, HP UX, AIX, SCO UNIX, Sun Solaris, Windows NT.

Software /Languages: Oracle Forms 6i & 4.5, Oracle Reports 6i &2.5, SQL*Plus, PL/SQL, C,JAVA, HTML, COBOL and PASCAL.

Oracle Tools: Oracle Enterprise Manager, Import /Export, Procedure Builder, SQL*Loader,Discoverer, Apex admin.

Other Tools: Kintana, Harvest, PVCS, Visio, Toad, SQL Navigator, RICE, ERWIN CaseTool, Data Junction, DBA Artisan, Remedy Request Management tool, ClearCase, DataLoader.

PROFESSIONAL EXPERIENCE

Confidential

Environment: Oracle Applications- 11.5.10.2 and upgrade to Rel. 12.1.3; Oracle RDBMS -11gR111gR2; RHEL6; Oracle Fusion middleware - 11g- Identity Management, OBIEEWebLogic, WebCenter, Secure Enterprise Search, and Apex; Windows7.

Responsibilities:

• Ensured all instances had teh appropriate CPU/IAVA patches installed as per Information Assurance guidelines.
• Installed, patched, and maintained multiple EBS instances in support of configuration control and change management of Oracle Applications and related third party bolt-on components.
• Maintained and supported all instances wif teh use of AD utilities, Enterprise Manager / Grid Control, OAM, and custom scripts.
• Enabled teh Auditing on Databases and monitoring teh audit logs just to make sure dat there are no suspicious activities.
• Automated teh log file cleanup and managing them according to teh retention requirements across teh systems.
• Responsible for running SRR scripts (Security Readyness Review) and successful completion of DIACAP (Defense Information Assurance Certification and Accreditation Process) audit of all of our systems.
• Performed periodic password sweeps across teh systems as per teh Security Techinical Implementation Guides (STIG).
• Integrating teh third party systems and resolving any related issues.
• Responsible for planning teh backup strategy and automating it.
• Perform recovery test once in six months.
• Responsible for performance tuning support across teh technology stack.
• Upgraded EBS database from 9i to 11gR1.
• Responsible to migrate all systems from physical servers to teh virtual servers (VMware).
• Migrated systems from teh offsite hosting facility to teh Network Enterprise Center (NEC) in Army Base.
• I was part of teh architecture team to design teh new environment for teh Oracle products purchased by USAMRIID.
• Upgraded EBS from Release 11i (11.5.10.2) to Rel. 12 (12.1.3) and enabled Single Sign-On.
• Installed and administered OBIEE.
• Secondary support for WebLogic Administration.
• Worked on day to day issues and coordinate wif Oracle Support in timely resolution of teh issues.
• Generated documentation and training materials for both administrators and end-users.

Confidential

Environment: Oracle E-Business Suite Rel. 12.1.1 (Financials, Projects, HRMS and ProcurementSuites) and 11g, RedHat Linux 5.0 OSTransform MCG is Oracle ERP

Responsibilities:

• Determine teh Technical architectural requirement, oracle technologies for data integration, application integration etc., Technical FitGap Analysis, Capacity Planning based on teh county requirements
• Document teh Application Security Architecture in compliant wif teh existing county infrastructure.
• Install E-Business Suite Rel. 12.1.1, OBIEE, Oracle Application Server 10g
• Prepare technical designs to integrate EBS wif various third party systems.
• Involved in designing various data conversion tasks
• Implemented Oracle Single Sign-On in EBS by integrating EBS, OID, Tivoli Access Manager (Third Party access manager) and Active Directory.
• Implemented single Sign-On in OBIEE by integrating EBS- OBIEE
• Instance Planning and Cloning EBS instances as and when required.
• Maintain applications in intranet and EHI environments( Highly Secure Enterprise Hosting Infrastructure )
• Responsible for backup and recovery.
• Apply Patches to E-Business Rel 12.1.1 based on teh requirement.
• Document teh coding standards for developers to follow them while developing code.
• Coordinated check printing using third party software (Piracle)
• Configure printers for various custom reports, standard reports
• Responsible to resolve issues, smooth running of Rel 12.1.1 and other integrated software.
• Documented all work products.

Confidential

Environment: Oracle E-Business Suite 11.5.10.2 (AP, GL, AR, PO, Inventory, FA, HR, PayrollProjects, CE), Oracle 10G (RAC) and 9i, RedHat Linux OS.

Responsibilities:

• Responsible for all technical tasks pertaining to implementation of E-Business suite and post go-live support.
• Responsible for installing teh E-Business 11.5.10.2 on Linux environment.
• Responsible for applying teh patches to a level business requires them.
• Developed coding standards and performing code reviews for all technical development work.
• Responsible for converting teh E-Business instance to Multi-Org.
• Responsible for Implementing Vertex tax software, Evergreen Check printing software.
• Responsible for installing ADI, configure teh mail server etc.,
• Install, manage and support discoverer on top of EBS.
• Responsible for planning and defining strategies for all technical activities like, conversions, interfaces, extensions, reports, forms customization/personalization and new development etc.,
• Define teh instance strategy and cloning to suffice needs of teh implementation team for CRP, Development, SIT, UAT, GOLD instances etc.,
• Planning and defining all custom responsibilities, menus and request groups etc to suffice teh needs as per business requirement.
• Overall responsible for planning, developing strategies to maintain teh security of teh system.
• Performing teh change management activities.
• Involved in planning and successful execute of CRP, SIT, UAT etc.,
• Involved in Production Cutover planning, execution and made sure dat Go-Live to Production is seamless.
• Responsible for day-to-day support for business and SMEs in postproduction situation.
• Responsible for User, Roles management.
• Working wif oracle support to resolve issues faced by teh business and technical team.
• Involved in various enhancement activities in different technical/functional areas.
• Resolved many workflow issues in various functional areas.
• Liaison among development team, functional and business teams.

Confidential, Washington, DC

Environment: Oracle E-Business Suite 11.5.10 ( AP, GL, AR, Tele Service, Cash ManagementFed Admin) and Oracle 9i, Sun Solaris OS, Linux

Responsibilities:

• Analyze teh business requirements; prepare Technical / Functional design documents for various PBGC specific business processes.
• Designed Technical / Functional Documents to convert Vendors, AP Invoices, AR Invoices, Customers etc.,
• Designed Technical document for automatic creation of Projected Filings/ Invoices for each Plan every year using Oracle AR, Customer Support, TCA modules.
• Designed Technical / Function document for Filing, Data Capture process, Data Validation process.
• Designed Technical / Function document for Transaction Posting Process (automating Receipt, Invoices, Debit Memos, Credit Memos, Adjustments etc in Oracle AR) for across Premium Practitioner System (PPS).
• Designed Technical / Function document for 5500 Data Loading and Matching Interface process to integrate teh information coming from DOL (Dept. of Labor) wif PPS.
• Designed Technical / Function document for PPS interface to IPS (Image Processing System) to commit or retrieve images to / from IPS.
• Prepared Interface Technical / Functional Design document for Enterprise wide letter generation process (eALG) which is a common service to send outgoing letters from PBGC.
• Involved in designing Technical / Functional Design document for PPS Refund Process, Waiver Request Process.
• Involved in designing Technical / Functional Design document for creating Service Request using TCA architecture, Tele Service / Customer Support / CRM Admin modules.
• Responsible for preparing / presenting design documents in various Technical and Functional Design Reviews wif different PBGC project teams and business community.

Confidential, Shelton, CT

Environment: Oracle E-Business Suite 11.5.5 / upgrade to 11.5.8 (AP, GL, AR, FA, Cash Management, INV, OM, Service Contracts, IB, OIC, Advanced Collections, Advance Pricing, Tele Service, Marketing), Oracle 8i/9i, PLSQL, SQL Loader, SQL Plus, Shell Scripts, Developer 6i, Discoverer 4i plus, Kintana for Version Control and Change Management, Toad, AIX 5.0 OS.Functional consultant

Responsibilities:

• Gather business requirements, analyze requirements, design and implement new customizations using Oracle AIM, enhance existing customizations. Also provide Post-Implementation support.
• Major area of responsibility is in developing Legacy Data Conversion Processes and Interfaces to third party systems using SQL Loader, Pl/Sql, Data Loader, Shell Scripts.
• Responsible for designing and developing data conversion reconciliation reports from Oracle Applications.
• Designed and developed programs to load Legacy Journal Entries, Budgets, Vendors, Customers, AR Invoices, AP Invoices into respective Oracle modules.
• Responsible for designing Custom AR/Contracts Billing/Pre-Validation processes for Service Contracts Billing to ensure accuracy.
• Responsible for designing Inbound and Outbound interfaces between Order Management and BAX Global Shipping Systems.
• Involved in Unit Test / System Integration Test / User Acceptance Test of various tasks.
• Defined and enforced Change Control Procedures for Imagistics.
• Responsible for successful internal and External audits (PWC) for SOX compliance.
• Good at understanding teh SOX (Sarbanes and Oxley) key control requirements.
• Responsible for implementing teh key controls in accordance wif SOX compliance.
• Responsible for overseeing teh deployment of Source code to different instances.

Confidential

Environment: Oracle Applications Rel. 11i (11.5.9). AP, GL, AR, Oracle Projects, PO, INV.PLSQL, SQL Loader, SQL Plus, Shell Scripts, Developer 2000, Kintana(Mercury), Toad, Solaris Operating System.

Responsibilities:

• Responsible for developing Functional and Technical Design Documents for Project Task WBS conversion, Project Budgets Conversion Process, Project Expenditures, Converting Vendors, GL Journal Entries, Budgets, AR Invoices Interface, AP Invoices.
• Involved in configuring teh projects module.
• Designed Functional and Technical Specification documents for Project Budgets Conversion process to load teh budgets for different projects.
• Designed functional and technical specification documents for Employee Conversion Process to load teh employees from PeopleSoft HR system.
• Responsible for developing Conversion Reconciliation Strategies.
• Responsible for overseeing technical development work performed by development team members.
• Good understanding of Oracle Applications technical architecture, underlying tables and inter relationship between teh modules.
• Conducting Code Review / Peer Review Sessions to review teh code written by developers.
• Responsible for providing teh Pre-Conversion Validation Scripts so dat it halps in cleansing teh source data and also setup missing configurations in target instance.
• Responsible for providing teh Post-Conversion Validation Scripts and Control Reports to make sure conversions are completed successfully.
• Used Kintana (Mercury Change Management) Version Control Software for teh Code Control and Change Management.
• Responsible for Migrating teh Code, Configurations required for teh different Conversions and Interfaces.
• Participating in knowledge transfer to teh users time to time.

Confidential

Environment: Oracle Applications Rel. 11i (11.5.8). AP, GL, AR, CM, Sun Solaris OS.

Responsibilities:

• Conducting Brain Storming sessions wif SMEs to discuss and understand teh requirements, various gaps between requirements and functionality of Oracle Applications.
• Responsible to understand and translate Functional Specifications into Technical Specifications and set software deliverables.
• Developed Technical Design Documents for Customizations, Interfaces, and Data Conversions across teh modules.
• Followed AIM Methodology for developing/ implementing most of teh tasks.
• Planning, allocating right resource for various tasks and tracking teh development activities wif time and percentage of completion using Microsoft Projects.
• Arranged / Participated in various meetings for Development / Status review
• Conducting Code/Peer Reviews for teh code developed by developers and provide suggestions if any.
• Responsible for Planning, Developing, Testing, Transitioning phases of teh project.
• Responsible for Change/Code Control Process as we did not has any version control software.
• Good at using PL/SQL, Reports, Packages, Procedure, Functions, Triggers, Oracle Interfaces, APIs, AOL for development activities etc.,
• Document Coding and Reporting Standards specific to teh client.
• Assist developers to understand teh functional requirements, develop teh code for various processes.
• Conducting Unit/System Integration/User Acceptance Test of various tasks.
• AP Invoice Interface from STARS to Oracle Accounts Payables.
• Interface process to load Vendors (Providers) every month.
• Developing a process to Create Payments in Account Payables.
• Process to Create Additional GL entries to sync STARS and Oracle GL.
• GL Journals Import Interface Process to load journals from STARS to Oracle GL.
• Interface process to load Budgets into Oracle GL Module.
• Forms for maintaining Transaction Codes, GL Accounts Mapping between STARS and Oracle AP, AR and GL modules.
• Purge Process to purge teh Operating System files and various other tables used in different interfaces periodically.
• Developing various Forms like Premium Rate Maintenance form, Message Maintenance Form for Invoice Printing, Case / Customer History Form for AR (Premium Management) Module.
• Developing AutoLock Box, Custom Dunning Process for Collections.
• Developing various Outbound Interface processes like AP, GL, AR Extracts to send to STARS. These extracts contain all transactions done everyday. dis is to sync STARS and Oracle Apps.
• Working wif Oracle Support and Opening TARs for teh issues and problems.
• Involved in Instance Planning and backup strategies for Phase I and Phase II.
• Applying various patches required to different instances.
• Tuning teh database to improve teh performance for heavy data loads.
• Running Explain Plan and understanding teh output of TKPRO, recommend tuning tips.
• Good at using Database and Applications monitoring tools like Spotlight for Database and Spotlight for Applications.
• Setting Custom Application, printers and various profiles (system and personal).
• Define Data Groups, Responsibilities, Request Groups, Concurrent Executables, Programs and registering them to different responsibilities.

Confidential, Arlington, VA

Environment: Oracle Applications Rel. 11i (11.5.8 and 11.5.3 ), Sun Solaris OS.

Responsibilities:

• Understanding teh Business needs, Functional Documents and develop FDDs if necessary.
• Designed Technical Documents for Interfaces, Conversion Processes and Reports developed.
• Integrated third party Budget system (FRx) wif Oracle GL Budgets by developing Budget interface to load teh Budgets from FRx to GL Module.
• Designed Outbound Interface to transfer teh Actual Balances to FRx.
• Integrated Third party HR and Payroll System wif Oracle Apps.
• Designed Item Transaction Interface to load Item transactions from a works management system.
• Designed Open Item Replenishment, Item Cost, Requisition Open interface.
• Used Remedy Request management system for managing Requests, Tasks and Problem tracking.
• Involved in Instance Planning, backup strategies, Applying various patches required.
• Performing pre-upgrade steps for 11.5.3, setting up of Context Editor Tool in 11.5.3.
• Enabling teh AutoConfig in 11.5.3, dis is a mandatory prerequisite step for upgrade to 11.5.8.
• Upgrading JDK, Apache Server, setting up of Rapid Cloning, upgrade from 11.5.3 to 11.5.8.
• Working wif Oracle Support. Open TARs for teh issues.

Confidential

Environment: Oracle Apps 11i ( 11.5.5 upgraded recently to 11.5.6 ), AP, PO, FA, INVAR, GL, PA, ABM and ADI, HP 9000 Sever, HPUX OS.

Responsibilities:

• Developing new Enhancements, Requests, and technical/functional tasks from business.
• Understanding teh Business needs and Developing Functional and Technical Documents.
• Developed Pseudo Code and Code for teh tasks.
• Planning Change Control and Code Control strategies.
• Customized various reports in AP, AR, FA, and INV.
• Responsible to assign tasks to developers and assist them in technical issues / development.
• Arranging Team meetings to discuss teh problems and check teh status of different activities.
• Arranging regular meetings wif Business people and satisfying their needs.
• Worked wif Oracle Support on TARS, Problem tracking and resolving teh issues.
• Planning different Conc. Mgrs, create new Conc. Mgrs to avoid performance problems.
• Perform SysAdmin activities and Planning Security.
• Designed process to import Customers, AR Invoices, Address validations, sales tax rates and other transactions using AutoInvoice process.

Confidential, Brooklyn, NYC

Environment: Oracle Applications Rel. 11i ( 11.5.3 ) and 10.7 SC, AIX 4.0, Dell Clients.

Responsibilities:

• Participated in Brain Storming Sessions wif Clients to collect teh requirements, prepare teh Functional and Technical Design Documents.
• Developed Inbound Interface to Load Master Items, Organization Items, Item Locators (Area, Row, Bins), Item Categories, Item Onhand Quantities and Costing information from Legacy System into Oracle Inventory Module using Item Interface Import Process, SQL * Loader and PL/SQL.
• Developed a process to load teh Manufacturers and their Part numbers to attach to Inventory Items.
• Developed teh process to attach teh Item Long Descriptions as documents.
• Customized process to print teh Manufacturer name and Numbers on Purchase Order Documents.
• Developed Conversion process to load 3 years of Item Usage history used for Item Forecast.
• Designed custom process to Restrict inventory items to specific Sub-inventories and Locators.
• Designed Use Tax report to find teh difference in teh Use Tax when an item is transferred from one organization location to another.
• Designed conversion process to load Payable Invoices into AP, Customers and AR Invoice in to AR.
• Designed Outbound Interface to send item issues to teh Works Management System (MAXIMO).
• Designed various interfaces to Projects, AP and GL to other Non Oracle Systems.
• Developed complex SQL queries for reconciliation and management reports
• Planning instances for configuration, development, Integration Testing, User Acceptance Testing.
• Defined Concurrent Executables, Programs and register them to different responsibilities.
• Performing some System Administration and Data Base Administration Activities.
• Good understanding over Multi-Org Setup in applications.
• Analyzing all customizations done in 10.7 SC according to EMM templates.
• Recommended changes required for teh database and custom programs before migrating to Rel. 11i.
• Made changes database objects and custom programs, interfaces developed in 10.7 SC.
• Developed new custom reports using Discoverer 3.0 in place of SQL*PLUS reports.

Confidential

Environment: Oracle Apps Rel. 11.0.3, GL, AP, AR, PA, CM, BOM, HR, Sun Solaris 2.6

Responsibilities:

• Prepared Functional and Technical design documents for teh various tasks.
• Developed an Outbound Interface for Positive Pay, to load Employees, Addresses to populate data into teh HR base tables using Pl/Sql, Sql*Loader and Shell Scripts.
• Developed Process to load Payroll Checks, Bank Statements into CM for recon.
• Developed Conversion Programs to load Legacy Customers, AP Invoices, AR Invoices, AP Checks, Outstanding Payroll Checks, Payroll GL Distributions, Inventory Items into AP,AR, Cash Management, GL and Inventory modules.
• Customized reports like Employee Summary, Group Life Insurance Premium, Job and Position Skills Matching Reports in HR
• Defining Printers, Styles, Creating Custom Drivers and adding drivers etc.
• Assisting Database Administrators in Database designing and administration.