SUMMARY:

• Over SIXTEEN 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 Discoverer 10g, BI Publisher, Oracle Reports 6i/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 OBIEE, Informatica, Cognos (Datawarehousing Software).

COMPUTER SYSTEMS EXPERIENCE:

Hardware: IBM PC Compatibles, HP Workstation, Sun Sparc

Oper Sys: Linux, SUN Solaris, HP-UX (10.2, 11), SCO UNIXWindows 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

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.
• 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

Confidential

Responsibilities:

• listed, market leader in manufacturing of water pipe, drainage pipe, structural and speciality products, stormwater management systems.
• Converted existing business critical customer facing reports from Oracle Reports 10g to BI Publisher.

Environment: Oracle EBS 12.1.3, BI Publisher, Oracle Reports 10g, TOAD, PL/SQL, SQL, Unix (AIX)

Confidential, Round Rock, TX

Senior Principal Technical Specialist

Responsibilities:

• 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, 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, Oracle Forms/Reports 6i, HP Service Manager, Kintana, Serena Dimensions

Confidential, Houston, TX

Technology Architect

Responsibilities:

• Developed interface programs in PO module.
• Developed BI publisher reports, PL/SQL packages etc.

Confidential, Pasadena, CA

Oracle Developer

Responsibilities:

• Responsibilities included providing day to day production support and maintenance for Oracle Applications R12. Resolved over 350 help desk tickets.
• Part of team responsible for implementation of Oracle Applications 12.0.4.
• 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:

• Provided day to day production support, help desk support for
• Oracle Applications 11i hosted by Oracle On Demand. Resolved/managed numerous help desk tickets.
• 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:

• 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.
• Also 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