SUMMARY:

• Over SEVENTEEN YEARS of IT experience in developing various software applications. Extensive experience in analysis, design, development and implementation of business applications and application software in the web, client/server and database environments using procedural and object - oriented techniques.
• Worked at a Big 4 consulting firm. Experienced in program management and leading onsite/offshore teams.
• Managed multiple projects, involved in contract/vendor negotiations, involved in cost cutting initiatives.
• Well versed in Oracle 11g/10g/9i/8.x/7.x and Oracle Applications (R12/11i/10.7SC/10.6/10.5) - AP, GL, AR, OM, PO, INV, FA, PA, BOM, Service Contracts, Install Base, HRMS, OPM Inventory, AOL, SYSADMIN.
• Extensive experience in providing production support for Oracle Applications.
• Expertise in PL/SQL. Developed interface programs from scratch
• Expertise in design/development of reports using Oracle BI Publisher, OBIEE, Oracle Reports 6i/10g, Discoverer 10g.
• Expertise in Application Object Library (AOL), Oracle Forms/Reports 6i/10g, Oracle Developer 2000, TOAD, Crystal Reports, HTML, PL/SQL, SQL, SQL*Loader, Constellar.
• In depth knowledge in translating user requirements into program specifications and customizing Oracle Applications forms and reports. Proficient in writing interface programs including PL/SQL scripts and SQL*Loader control files to import legacy/feeder system data into Oracle Application modules.
• Well versed in development of web applications using JAVA, JDK, JDBC and Servlets.
• Trained in Big Data, Hadoop, Hadoop Administration, NoSQL, Hive, HBase, Sqoop, Flume, Oozie. Trained in Informatica, Cognos, Business Objects 5.0.

TECHNICAL SKILLS:

Hardware: IBM PC Compatibles, HP Workstation, Sun Sparc

Oper Sys: Linux, SUN Solaris, HP-UX (10.2, 11), SCO UNIX,Windows 10/8/7/Vista/XP/NT/2000/95, MS DOS

Software: Oracle Applications AP, GL, AR, FA, PO, OM, PA, INV, BOM, Service contracts, Install Base, Sales, Teleservice, OPM Inventory, AOL, SYSADMIN (R12/11i/10.7SC/10.6/10.5), Oracle 10g/9i/8.x/7.x, Oracle JDeveloper, TOAD, Developer 2000, Reports 2.0, Oracle Forms/Reports 6i/10g, PL/SQL, SQL, HTML, C, Fortran, SQL*Plus, SQL*Loader, SQL*Forms 2.3, Explain Plan, SQL Trace, Tkprof, Oracle Enterprise Manager, Oracle Discoverer, Crystal Reports 6.0, Constellar, OBIEE, Informatica, Business Objects 5.0, Cognos, Winrunner, SQA Robot, ERWIN, JAVA, Servlets, JavaScript, XML, MINITAB, Arc/Info, AutoCAD, MS Access, MS-Word, MS-Excel, MS-Project.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Manager/Specialist Master

Responsibilities:

• Served as Electronic Data Interchange (EDI) testing lead as part of Oracle R12 implementation project. Led EDI testing activities, integration testing, performance testing, defect tracking and resolution. Provided status updates. Planned, coordinated and facilitated various EDI tasks with Client director/team, offshore Confidential USI team, Manhattan WMS team, OTC team etc. Conducted multiple conference meetings with client/ Confidential USI team.

Environment: Oracle EBS 12.2.5, Manhattan Associates WMS, TOAD, PL/SQL, SQL, WinSCP, HP ALM

Independent Consultant

Responsibilities:

• Converted existing business critical customer facing reports from Oracle Reports 10g to BI Publisher.

Environment: Oracle EBS 12.1.3, Oracle JDeveloper, OAF

Confidential, Round Rock, TX

Senior Principal Technical Specialist

Responsibilities:

• Part of team responsible for providing global production support for Oracle Applications 11.5.10.2. Business users are located worldwide. Resolved over 1100 support tickets. Interacted extensively with business directors, managers and users.
• Supervised developers.
• Attended change advisory board meetings, approved technical design reviews
• Developed/enhanced/fixed issues with BI Publisher reports, RPD, OBIEE reports, interfaces, oracle reports, PL/SQL packages etc.
• Developed/enhanced/fixed issues with RICEFW objects.
• Opened and followed up on SRs with Oracle Support.

Environment: Oracle Applications 11.5.10.2 (GL, AR, AP, iExpenses, FA, OM, PO, INV, BOM, Install Base, AME, Quoting, BI Publisher, Sysadmin), Linux, Windows 7, Oracle 11g, TOAD, Oracle Workflow Builder 2.6.x, SQL, PL/SQL, OBIEE, Oracle Forms/Reports 6i, HP Service Manager, Kintana, Serena Dimensions

Confidential, Houston, TX

Technology Architect

Responsibilities:

• Part of consulting team responsible for implementing Oracle Applications 12.1.3 at a major oil and gas client. Supervised technical developers.
• Developed interface programs in PO module from scratch.
• Developed BI publisher reports, PL/SQL packages etc.

Confidential, Pasadena, CA

Oracle Developer

Responsibilities:

• Part of team responsible for implementation of Oracle Applications 12.0.4. Resolved UAT and production issues.
• Interacted extensively with business directors, managers and users.
• Designed and developed numerous custom discoverer reports per user requirements. Created new custom reports/modified existing reports. Personalized OAF pages.
• Key member in project to upgrade from Oracle Applications 12.0.4 to 12.1.1
• Fixed issues with custom oracle reports/discoverer reports/BI Publisher reports, PL/SQL packages etc.
• Assisted with SOX audit.
• Opened and followed up on SRs with Oracle Support.

Environment: Oracle Applications 12.1.1/12.0.4 (GL, AR, AP, iExpenses, SLA, OM, Service Contracts, Install Base, HRMS, PO, INV, BOM, Quoting, AME, Sales, Teleservice, BI Publisher, Sysadmin), Linux, Windows XP, Oracle 11g, Oracle JDeveloper, OAF, TOAD, Oracle Workflow Builder 2.6.x, SQL, PL/SQL, Oracle Forms/Reports 10g, Fortress, QuestStat, Oracle Discoverer 11g.

Confidential, Los Angeles, CA

Technical Manager

Responsibilities:

• Oracle Applications 11i hosted by Oracle On Demand. Resolved/managed numerous help desk tickets. Managed personnel.
• Interacted with Senior Management (VP, CFO level). Interacted with business managers and users in US and international locations (Singapore, Australia, Hong Kong, UK, Fiji), on a day-to-day basis.
• Worked as project manager for conversion of business critical reports from Formscape to XML Publisher reports. Fixed issues with custom printed/emailed XML publisher reports.
• Worked as project manager for 170 Systems (now Kofax Markview) implementation project.
• Worked as project manager for EDI 860 implementation for POM/PFI
• Performed Discoverer reports administration activities. Created/modified numerous discoverer 10g reports as per user requirements.
• Performed Application administration activities
• Provided technical/functional assistance for Oracle Applications implementations at POM, Confidential international locations.
• Designed, developed, modified custom PL/SQL programs, SQL scripts, forms, FSG and oracle reports at POM Wonderful, Confidential, Paramount Citrus.
• Performed unit testing, integration testing
• Performed 170 Systems administration and support activities.
• Supported custom sales and forecasting web application/Narnia portal application.
• Worked with onsite/offshore consultants. Offshore consultants were based in India and China. Created functional/technical documents. Provided answers for functional/technical questions.
• Opened and followed up Oracle SRs until resolution.

Environment: Linux, Windows XP, Oracle 10g, Oracle Applications 11.5.10.2 (AP, GL, AR, FA, Cash Management, OM, PO, INV, HRMS, EAM, Alerts, OPM Inventory, OPM Financialse-Commerce Gateway, XML Publisher, Sysadmin), SQL, PL/SQL, 170 Systems, Inovis TLE (EDI), TrackIT, Mercury ITG, Oracle Forms/Reports 6i, TOAD, Oracle Discoverer 10g.

Confidential, Aliso Viejo, CA

Senior Programmer/Analyst

Responsibilities:

• Contribution Provided day to day production support, help desk support and maintenance for
• Oracle Applications 11i. Main modules supported included AP, GL, AR, FA, Cash management, PA, OM, INV, HRMS, service contracts.
• Resolved numerous IT help desk tickets.
• Created numerous data analysis files and SQL scripts based on requirements from managers and end users in accounting, finance, order management and other departments. Created data files and reports for SOX audit and compliance.
• Worked on issues with Oracle forms and reports.
• Developed many custom reports using Oracle Reports 6i and Oracle discoverer. Customized existing reports as per user requirements.
• Created/Modified PL/SQL packages, procedures and functions. Fixed issues with existing custom programs and reports.
• Served as technical lead for Vertex upgrade from 2.x to 3.x. Worked with external consultant on the project. Performed monthly vertex rate updates.
• Created Oracle Alerts.
• Logged TARs with Oracle Support to resolve issues.
• Communicated, gathered requirements and worked with functional business analysts, end users and managers to resolve issues on a daily basis. Participated in numerous meetings. Created technical documentation.
• Supported custom contract, quote and forecasting application.
• Worked with offshore technical resources on development work in Oracle financial modules.

Environment: Sun Solaris, Windows XP, Oracle 9i, Oracle Applications 11i (AP, GL, AR, PA, FA, Cash Management, HRMS, OM, PO, INV, BOM, Service Contracts, Install Base, Knowledge Base, Email Center, Alerts, Sysadmin), SQL, PL/SQL, Remedy, TOAD, Webmethods, Oracle Forms/Reports 6i, Oracle Discoverer.

Confidential, Santa Clara, CA

Independent Consultant

Responsibilities:

• Developed an invoice import interface program to validate and load check data into AP module, modified existing reports and developed new custom reports in AP and FA module as per the company requirements.

Environment: Oracle Applications 10.7 SC(AP,GL, FA, Sysadmin), Oracle 8i, Sun Solaris, Windows XP, PL/SQL, SQL, Oracle Developer 2000

Confidential, San Jose, CA

Senior Consultant

Responsibilities:

• Part of team responsible for implementing an oracle 11i based service contracts, installed base, entitlement and product data management system to replace the current Contract service manager (CSM custom application) functionality and data. Modified custom PL/SQL procedures, functions, packages and database triggers to point from CSM schema to Oracle 11i schema. Modified custom reports. Created technical documentation. Involved in performing unit testing and integration testing.

Environment: Oracle Applications 11i (Service contracts, Install Base, Sysadmin), Oracle 8i

Confidential, San Jose, CA

Responsibilities:

• Cisco capital RRR Transaction summary report, Cisco GL Cross charges to BV(manufacturing), Cisco GL cross-charges to BV (sales), Cisco GL Intercompany royalty (BV-US) calculation report etc.
• Created Cisco intercompany account reconciliation reports in GL to report on reconciliation between intercompany accounts in a distributed database environment consisting of 5 databases.
• Created/modified custom PL/SQL packages, procedures, functions, SQL scripts as per user requirements.
• Modified custom SQL programs such as shipment extract program, AR daily extract program. Created technical documentation.
• Enhanced/modified custom forms like royalty rates form, royalty country form, royalty mapping form used for maintaining royalty data using Oracle Forms 6i

Environment: Oracle Applications 10.7 /11.0.5 (GL, AR, Sysadmin), Oracle 8i

Confidential, Attleboro, MA

Responsibilities:

• Created/modified custom PL/SQL programs and SQL*Loader files as per user requirements.

Environment: Oracle Applications 11.0.3(OE, BOM, PO, AR), Oracle 8i, Reports 2.5, Sun

Confidential, Pleasantville, NY

Responsibilities:

• ContributionResponsible for design and development of interfaces from Oracle Applications OE and PO modules to the Mainframe systems in UK and Nordic Countries(Finland, Denmark, Sweden, Norway). Developed pick release interfaces to send pick release information from OE to the mainframe fulfillment system. Developed PO goods received interface to transfer receipt information from Oracle self service purchasing to the mainframe warehouse system.
• Designed and developed the interfaces using Constellar tool. Interacted extensively with users. Created data extract files as per the user specifications. Customized reports like packing slip, shipment report etc. Created technical documentation.

Environment: Oracle Applications 11.x (OE, PO, Self Service Purchasing Web Applications), Oracle 8i, Constellar Metadata Manager Hub version 3.5, Reports 2.5, SQL, PL/SQL, SQL*Plus, Windows 2000, Sun OS 5.6

Confidential, Columbus, OH

Responsibilities:

• Multimillion dollar system for managing online ordering and e-fulfillment services (super system v2.0) developed using Java, XML, Oracle etc. Prepared test plans, tested for bugs, prepared bug reports, tested custom interfaces from custom application to Oracle Applications(OE, INV) and from Oracle Applications to Mainframe system (AS400 system)
• Tested PL/SQL procedures and functions to ensure that they conform to specifications, performed system/integration testing etc.

Environment: Oracle Applications 11.x (OE, INV), Oracle 8.x, Sun Solaris, Windows NT, PL/SQL, SQL, Java, XML, Mainframes.

Confidential, Needham, MA

Responsibilities:

• Responsible for reports development and customization of Oracle Applications. Modified numerous reports after Oracle Applications upgrade from 10.7 SC to 11.0.3. Customized reports like AR aging report, Commercial Invoice, Material account distribution detail, Revenue and cost by invoice drive by item report, Receipt Traveler, BTI Backlog report by product description/due date, BTI Backlog report by salesrep etc. Created Oracle alerts like alert that would e-mail customer contacts about order details, alert that would e-mail customer about order shipment details, alert that would notify purchasing manager about drop ship items, alert that would inform the requestor that PO has been created from requisition and alert that would inform the salesperson about the orders shipped for the week

Environment: HP-UX 10.2, Windows 95, Oracle 7.3.x, Oracle Applications 11.0.3/10.7 C161 (AR, GL, INV, OE, Alert, SYSADMIN), Reports 2.5, SQL, PL/SQL, SQL* Plus.

Confidential, North Andover, MA

Responsibilities:

• ContributionAnalyzed user requirements. Responsible for development and customization of reports like shipment report, shipment report with serial numbers, pick slip, pack slip, bill of material structure report, inventory item master listing report, open orders for inventory items, receiving transactions register and supplier on time delivery performance report.

Environment: Oracle Applications 11.x (OE, INV, BOM, SYSADMIN, AOL), Oracle 8.x, HP-UX 11, Windows NT, Reports 2.5

Confidential, Peabody, MA

Responsibilities:

• Customized reports like Custom Bookings Summary report by product family/line/class, custom bookings detail report, custom bookings summary report by region/area, inventory backlog report, custom shipping report etc.

Environment: Oracle Applications 10.7 SC (OE, INV, SYSADMIN), HP-UX 10.2, Oracle 7.x, Windows 95, Reports 2.5, SQL, PL/SQL

Confidential, Waltham, MA

Responsibilities:

• Responsible for creating data extract files from Oracle Applications and Concentra Custom application. Used these data extracts to load data into MS Access database. Responsible for development of custom reports in Oracle Applications 10.7 and Concentra Custom Application. Interacted with AR department managers and users to gather reporting requirements. Created technical specifications and user documentation. Created new reports like customer invoice details report, missing claim numbers report etc. Customized existing reports like Aged Trial Balance report, Dunning letters etc. Also created reports like
• CRA Aged Trial balance by product, top 125 accounts aging by product, top 125 accounts aging summary, CRA Aged Trail balance - By collector. Reduced runtime for some reports. Utilized Clearcase 3.2 software for version control.

Environment: Oracle Applications 10.7 (AP, GL, AR), HP-UX 10.2, Oracle 7.3.x, Oracle Developer 2000/Discoverer 2000, SQL, PL/SQL, SQL*Plus, Clearcase 3.2, Windows 95, MS DOS

Confidential, Downers Grove, IL

Consultant

Responsibilities:

• Responsible for preparing project plan for Oracle Applications Upgrade from 10.7 SC prod 16.1 to 11.x NCA. Installed Applet viewers and software such as GLDI, -Oracle workflow, etc. on PC and laptops. Installed and administered Oracle Discoverer 2000. Developed custom reports in Oracle Application modules using Oracle Reports 2.5/SQL*Plus. Assisted in developing SQL*Loader control files and PL/SQL scripts for data conversion from legacy system to Oracle AP module.
• Performed other technical work assigned by IS manager. Developed custom reports in inventory like Equipment Backlog Report, Confidential Sales Report (Customer Wise) and Open Sales Order Report. Responsible for providing technical support, troubleshooting, development and system maintenance for multiple implementation projects. Handled telephone calls/e-mails requesting technical assistance from 8 client sites implementing Oracle Applications 11.x NCA. Fixed technical problems and maintained issue resolution log in MS Access database. Interacted extensively with Oracle Worldwide Support. Performed Oracle Applications 11.x System Administration activities. Also performed DBA activities like applying Patches to SUN Solaris and HP-UX 11 Application servers. Also applied 11.0.2 maintenance pack patches to Oracle application modules. Utilized adadmin, adpatch, and adcontroller application utilities. Prepared and maintained patch log.

Environment: HP-UX 11, SUN Solaris 2.x, Windows NT/95, MS DOS, Oracle 8.x, Oracle applications 11.x NCA (AR, INV, AP), Oracle Developer 2000, Oracle Discoverer 2000, MS Project

Confidential, Chicago, IL.

Responsibilities:

• Contribution Analyzed and modified the existing interfaces from mainframe systems to AP and GL modules. Also analyzed stored procedures and database triggers. Performed the preupgrade/postupgrade steps. Used AOL features such as message dictionary, context sensitive help to further enhance the forms. Customized descriptive flexfields. Gathered reporting requirements from users. Designed and developed custom reports as per the client requirements. Customized important reports. Performed system administration activities such as creating responsibilities, menus, report security groups, etc. Aided in cleaning up the database. Participated in the Testing and Quality Assurance of upgraded version.

Environment: Oracle Applications (AP, GL), HP-UX 10.2, Windows 3.x, SQL*Plus, SQL, PL/SQL, Reports 2.5.

Confidential, NC

Responsibilities:

• Designed and developed custom reports in PeopleSoft AP module. Utilized PeopleSoft Query and Crystal Reports 6.0

Environment: PeopleSoft (AP, FA), PeopleSoft Query, Crystal Reports 6.0.

Confidential

Responsibilities:

• Contribution Analyzed reporting requirements. Developed and modified numerous reports for the Company Management and CEO. Designed and developed accounting reports for accounting department manager. Performed duties assigned by practice director including resolving problems with application systems. Conducted candidate interviews.

Environment: MAS90 for Windows, Crystal Reports 6.0, ACT