SUMMARY:

• 16 + Years of IT experience in Analysis, Design, Development, Implementation and Customization of Software Applications.
• 12 + Years of Oracle EBS Release R12( R 12.2.4) & Release 11i (R11i - 11.5.10, 11.5.7, 11.03) Techno Functional experience in AR, AP, PO, GL,OM,AOL, Quality, Service contracts and SysAdmin modules.
• End to end technical Project management experience in Oracle EBS customization and Support, maintenance projects
• 12+ Years Extensive experience in developing Oracle EBS CEMLI components. Strong experience in Applications Object Library setups. Worked in Oracle Forms10g/6i, Workflow Customizations, custom.pll and Back-end development using tools like SQL*Loader, PL/SQL.
• Very strong experience (3 +Yrs.) in Oracle Accounts Receivables and O2C cycle. Very strong experience on P2P cycle(Purchasing, Accounts payables )
• Strong experience in R12 upgrades projects. Experience in R12 upgrade impact analysis tools - Panaya and Chart of accounts conversion tools - ePrentise.experince in develop custom impact analysis tools for Chart of Accounts. experience in end to end management of Oracle SR’s for upgrades and production support issues, Tracking and updating SR’s and working with multiple Oracle teams
• Very strong in developing Oracle EBS Custom forms development, personalization’s and PL/SQL code components
• Extensive experience in Oracle core Technologies - Oracle Pl/Sql and Forms6i/4.5, Reports6i/2.5, Pro*C, Developer2000, Oracle databases 10g/9i/8i/7.3 and Pro*C& Unix and Shell scripts
• Extensive experience in writing Technical Design, Functional specification documents/requirements, SRS, DOU, System/UAT Test cases. Experience in OracleApps AIM documentation MD70/MD60/CV60/MD200 and Setup documents
• Experience in all stages of ERP Customization and implementation including Requirement Gathering, Solution Design, GAP Analysis, Customization, Configuration, Testing and Project Coordination
• Extensive experience in Project management and certified in TechM Project Management methodologies and QMS. PMP trained and acquired 36 Hrs. PMP credits
• Performance tuning experience in ORACLE Applications database and other layers of the technology stack using Tkprof, Explain plan, Experience in large Oracle OLTP databases. Proficient in UNIX shell scripting, scheduling and automating.
• Good Knowledge in OA Framework Extensions (Jdeveloper9i).
• 7 + Years of Onsite Customer facing experience in various engagements and locations (USA, UK) in PM, Techno Functional consultant, Business analyst and Tech Lead roles

TECHNICAL SKILLS:

Languages: C, Pro*C, SQL, PL/SQL, MS.VisualBasic 6.0, Unix Shell Scripts, Fortran.

Database: ORACLE 7.1/7.3/8.x/9.x/10g/11g, MS Access.

ERP Applications: Oracle EBusiness Suite R12(12.2.4), Oracle Applications11i(11.5.10)/11.03 Modules: AR, PO, AP, GL, INV,OM, Quality, Oracle Service contracts, AOL, Oracle Workflow, CEMLI components, SysAdminOA Framework Extensions

Tools Forms 10G/6i/4.5& Reports 2.5/6i/10g, XML publisher, Jdeveloper9i. Appworx scheduler, SQL * Loader, Sql Developer, TOAD MS. Visual Basic 5.0/6.0, VB Scripts, MS Excel Macros. Crystal Reports 5.0/7.0,SQL* Reports.: X-Server Unix FORMS4.5 client, KEA - VT tool (Telnet client).

Version Control Tools - PVCS, MS Visual SourceSafe: HP ALM, Quality center, MS Visio, MS Project 2013.

Web Technologies : XML, ASP 2.0, Java Script, VB Script, HTML/DHTML. Web Logic Application server

Operating Systems: SUN Solaris, Linux, HP-Unix, Windows NT.

PROFESSIONAL EXPERIENCE

Confidential, WI

Senior Oracle EBS Consultant

Responsibilities:

• end to end owned design and development of Chart of Accounts impact analysis custom concurrent program/tool in collaboration with Oracle COE to search oracle application File system and database for CEMLI code components referring to CCID/gl Code combinations or KFF segment valueset names or accounting flex field name and COA Id
• Impact analysis on AR CEMLI code components and interfaces for chart impact. created 25 + one pager CEMLI (including Packages, XML reports, custom forms, Valuesets) impact analysis documents and routed for Functional team inputs and approvals
• Contributed to Oracle ecosystem impact analysis including middleware impact analysis on AR, GL and AP inbound and outbound interfaces
• Responsible for solution design for impacted objects - CEMLI, valuesets, DFF’s, appworx chains, Custom workflows (Account generators etc.) and presenting the Solution design for architecture review approvals assist functional teams on modules setups conversion validations - GL Cvr, Security rules, mass allocations. SL standard setups and validate Master data - Customer, vendor and Bank setups etc. end to end ownership of custom bolton(PREPRO) components analysis, redesign and coordinated end to end development with offshore teams for PREPRO engine CEMLI components coordinated code moves across Test instances with code move workflows with and assisted Configuration management teams, performance teams on code moves
• Identified Test scripts to be remediated and updated/created new scripts required for New chart conversion validated testing in ALM/HP QC
• Documentation - created/updated and reviewed MD60/MD63/MD64/MD70 design documents coordinated Design review workflows approvals with architects and validation managers, coordinated teams setup documents approvals, created Traceability matrix and created/updated test scripts in ALM and coordinated Test manager and VM approvals.
• Currently Supporting users on CRP2 test cycles and UAT’s on ALM/HP QC assist GEHC IT Program management team to create or update project Quality tollgate documentation and trackers - Charter, Project plans, budgets, architecture coaching pitches, Risk review trackers, design review trackers, weekly Program review meeting notes analyze and resolve defects raised by functional users, regional IT teams in ALM application

Environment: Oracle Ebusiness Suite R12.2.4, AR, AP, GL, OM, AOL, PLSQL, Forms10g/Reports10g, Appworx, ePrentise, ALM (HP Quality Center), Sun Solaris, Unix shell scripts, putty, WinScp, MS Visio, MS Project 2013

Confidential, Milwaukee, WI

Senior Oracle EBS Consultant

Responsibilities:

• end to end delivery responsibility of 14 + Team members R12 upgrade team deliverables end to end design and development of 8 new custom Oracle EBS R12 forms (GPO customization) to retire custom developed pages
• End to end responsible for delivering R12 OPCR (Online patching remediated code ) remediation /upgrade of 200+ Forms and 150 + reports R12 Code remediation
• End to end technical support and design support of Appworx chains R12 code remediation
• Review design, coding and test scripts of team during R12 remediation, 11i Major and SI releases
• Responsible for key design and technical support on 30 + Custom XML and RDF reports customer status reporting, resource management and work allocation and monitoring and tracking the progress design and remediation technical support on Number of GECARS R12 code remediation’s including GECARS code remediation’s
• Design and technical support on R12 code remediation of AR interfaces for GECARS. Create oracle SR’s on AR API’s not compatible for R12 and complete R12 patch impact analysis, code fix and support testing of R12 patches for AR interfaces. End to end ownership of AR API patches to fix Operating Unit context initialization issues, fix brazil AR API’S localization issues
• Raise Change controls for deploying the application changes to Test/Release instances. coordinate with Oracle DBA, Apps Admin teams to deploy the changes across environments. coordinate in Build reviews and Coordinate with performance teams on performance testing of the code components being deployed
• Support regional users on testing localizations impact and interfaces related to region coordinate with Load testing, regression testing and performance Test teams on Performance and Load testing
• Support users on UAT Issues, Fix UAT data issues, bugs and raise change controls to move bug fixes to Validated Stage environment

Environment: : Oracle Ebusiness Suite R12.2.4, AR, AP, GL, OM, INV AOL, PL/SQL, Forms personalization’s, Forms10g/Reports10g, Appworx, Panaya, ALM (HP Quality Center), Sun Solaris, Unix shell scripts, putty, WinScp, MS Visio, MS Project 2013

Confidential, Milwaukee, WI

Senior Oracle EBS Consultant

Contribution:

• Created architecture coaching pitches and provided end to end support on Perspective POC design, Architecture approval meetings and calls from technical perspective
• Responsible for MD63/Design documents for key interfaces from AP, Purchasing to Perspective (Vendors interfaces, PO interfaces, Invoice, Invoice payments statuses, GL lookups)
• Supported corporate SOA teams on design of Interfaces users on testing the perspective interfaces
• End to end responsible for managing the testing scripts and test cycles on HP QC
• Coordinated development with CDDT teams and supported users and SOA teams on CRP, UAT testing on HP QC
• Reviewed PLSQL programs and facilitated DRB workflow approvals from performance and code review teams
• Create adhoc SQL reports for corporate SOA architects and users to test the interfaces

Confidential

Project Manager (Technical)

Contribution:

• Contributed to POC/pilot implementation of Oracle Quality for China manufacturing site. Assisted Quality consultants and functional owners on setups and customizations
• Assisted regional IT teams on pitching design and architecture slides as part of global Oracle COE design review meetings/ workflows and responsible for approvals on forms personalization customization and Interface design
• Provided technical design on OQA enhancements(collections screen Forms personalization), design report format for specific receipt inspection details, Inbound Interfaces to OQA design from MES systems (Quality inspection collections data)
• Coordinated code moves, build across CRP and validation instances and assisted GEHC IT managers on R12 testing phases
• Supported team and customer on design documents, HP QC test setups for 11i releases and setting up test environment on Test R12 instances
• Supported on Release management aspects of this engagement. Coordinated cut-over phase (code moves, Setups on Prod environment), setup verifications and sanity checks on Prod environment during go-live and transition to Support teams

Environment: : Oracle Ebusiness Suite 11i(11.5.10),Oracle Quality, Purchasing, PL/SQL, Forms10g/Reports10g,ALM(HP Quality Center), Unix shell scripts, putty, WinScp, MS Visio, MS Project 2013

Confidential, Atlanta, GA

Oracle EBS Techno Functional consultant

Contribution:

• End to End Project Management of the PGS development Tracks
• Requirements gathering from Workout sessions, daily calls with Process owners, Functional teams and black belts on One PGS portal Technical requirements, Data flow requirements, Integration with Other applications and Identify Web services required between Applications, PGS Portal UI and PGS ODS database.
• Coordinate with onsite and offshore architects on One PGS portal BRD and design integrations requirements between Pillar. Create MD200 and CF250 documents for Contracts, Customer, outage, demands/Tasks, Site and Equipment Outbound interfaces/integrations.
• Coordinated and planned data conversion for PGS Portal and end to end supported fixing Performance issues with data conversion Programs and optimized Conversion window.
• Analyzed and Designed Functional Specification for Oracle Field Services - Field Services Portal and Charlie Instance(Oracle Project Accounting)Integration .Developed Code components required for OFS-FSP-Charlie Integration - Concurrent Programs for Incidents and Tasks Outbound interface from OFS, API wrappers for Incident/Outage level Updates from FSP application. Designed and coded BPM Oracle wrapper Procedure to Update Project tables with corresponding OFS/FSP Outage/Event Id.
• Worked with Web services, Data modeling team, UI development teams to Design ODS/Portal database schema Objects for various Modules and objects for Staging area for Web methods integrations with ERP instances and Field Services portal, Power Services portal applications.
• Supported technical design of Oracle ERP Concurrent programs, BPM/WebServices Oracle Wrapper Code components - Package procedures for Oracle ERP to One PGS portal out bound data (Contracts, customers, Equipment, Site, Demand/Tasks outbound interfaces).Performance fixed number of code components and created Debug code components for Web Services testing.
• Created SIT System test cases for ERP concurrent programs, Integrations with ERP-Portal and upload test cases to Quality Center and execute SIT test cases on Dev, SIT instances with UI, Web Services teams.
• Assisted PGS IT managers to create cutover plan for deploying Oracle ERP code components, One PGS portal Web Services Oracle code components and objects on Dev, SIT/Staging and Production instances.
• Coordinated with Offshore development teams on daily basis on Deliveries, review each delivery from offshore team and Promote Changes to Dev, Stage environments, and maintain Version control.
• Coordinate and assist IT managers on Project Tollgate documentation and Tollgate approvals.

Environment: : Oracle Ebusiness Suite 11i, ERP Modules - Oracle Service contracts, Field Service, Project Accounting, Erwin Data modeler, PL/SQL, Web Service, Web Methods BPM, Java/JSF, Web Logic application server, HP Quality Center, Sun Solaris, MS Office SharePoint designer 2007, MS Visio.

Confidential, WI, USA

Oracle EBS Techno Functional consultant

Responsibilities:

• Solution design support with POC’s and simulation, support Architecture coaching approvals, Oracle COE customization workflow approvals, solution approach demos and CRP’s to Functional teams. create design documents MD60, MD70, MD63 and support users on URS creation and approvals
• Key solution design contribution for GECARS Oracle AR Prime, Lite models /interfaces
• Requirement analysis, Solution design for AR backfeed and Debit Variance inbound feed means to Create equivalent Oracle AR transactions
• Prepare proposed Oracle Design/Architecture slides/documents to Present in Architecture coaching sessions and raise customization workflows for Oracle COE approvals, coordinate with Confidential IT managers to get Architect/COE approvals on Design/Architecture session presentation documentation
• Support Load Testing and performance testing for releases. Work with DBA, performance teams on Concurrent programs performance issues
• Create and manage Oracle SR’s on backfeed related Oracle AR Public API’s, Brazil localization issues and context initialization issues for R11I/R12 in backfeed program. Implement oracle Patches and action plan on Test instance for API issue resolution. Coordinate with Oracle on Patches, deploy fixes/patches on test environments and patch analysis before moving the Patch to Oracle Production environments
• Design valuesets for code components and DFF’s for attribute fields and Value set setups. Support functional team on Oracle AR setup documents, setup verification SQL’s and setup verification documents. create code review reports for team and support code/build review workflow approvals
• Prepare Unit, System test scripts and upload Test scripts to HP QC and assist Functional team in creating UAT Test scripts and document Test results on CRP, Validation/Stage, Pre-Prod environments.
• Raise Change controls for deploying the application changes to Test/Release instances. Coordinate with Oracle DBA, Apps Admin teams to deploy the changes across environments. coordinate in Build reviews and Coordinate with performance teams on performance testing of the code components being deployed
• Coordinate with Load testing, regression testing and performance Test teams on Performance and Load testing
• Support users on UAT Issues, Fix UAT data issues, bugs and deploy changes on Stage environment.
• Prepare KT documentation, KT plan, Transition new Oracle GECARS Interface jobs, Oracle Custom code components, Oracle reports, Oracle DFF setups, Appworx jobs to Oracle Support teams and signoff on Transition.

Environment: Oracle Ebusiness Suite 11i(11.5.10), Accounts Receivables, General Ledger, Order Management, eOM(Custom application), Progress Billing(Oracle Custom bolt-on), PL/SQL, Appworx chains Forms10g/Reports10g, Informatica, ALM(HP Quality Center), Sun Solaris, Unix shell scripts, putty, WinScp, MS Visio, MS Project 2013

Confidential, Schenectady, NY

Technical Lead

Responsibilities:

• Support Oracle PO Concurrent Programs (Transmit/Publish PO report, Transmit PO Cancels/Updates, ASN Inbound interfaces, Transmit Receipts Outbound interface), AP Concurrent Programs (Invoice inbound Open Interfaces, Remit-To /Vendor Sites Outbound, Payment Advice Outbound Interfaces), Oracle workflow customizations (PO Approval WF) and Custom Workflow Implementations (PO Acknowledge WF for O2S)
• Customize Oracle components to implement O2S-OracleIntegrations for New Business units/Instances requiring Order to Settle Process as part of Quarterly Train releases.
• Development or Modification of an existing Oracle-O2S Interface concurrent Program (AP Invoice open interface, PO interfaces, Receipt interfaces, ASN, PO Status changes and Payment Advice, Custom PO acknowledgement workflow) code to meet a gap in application Functionality, or to comply with additional features or improvements in features in the O2S.
• Responsible for creating MD60, MD070, MD200 documents for implementing new Integrations.
• Identify and Fix bugs in O2S-OracleApps Concurrent Program codes. Resolve issues with Custom PO approval workflow code components related to O2S PO approvals on various O2S enabled Oracle instances. Raise Oracle SR’s and coordinate with Oracle Support for Issues with Open Interface API’s.
• Run and maintain Dashboard for ePO module to get Oracle PO-O2S discrepancy report. Validate PO discrepancies to find out the failure points and corrective actions. Execute Corrective actions for all Oracle integrated instances. Run reports to find out lost ASN/Invoice Transactions and suggest corrective actions, Run discrepancy report to find out eS&S module related defects in ASN, Invoice, Payment Advice, ASN Receipts and Remit-To Sites.
• Coordinate corresponding Oracle ERP release/patch updates as required.
• Changes in OracleApps due to upgrade in Oracle ERP or O2S application. Coordinate corresponding ERP updates across various O2S enabled Oracle instances as required.
• Provide GEE with UTP’s for approval. Provide UTP results after unit testing for enhancements
• Assist GEE in integrated testing and Regression testing, including ensuring proper environment Setups and configuration with the O2S application.
• Analyze failure of transactions between Oracle PO-O2S in EAI web methods and work with web methods team to fix data and bug fixes.
• Provide expert advice on O2S-OracleApps interfaces.
• Generation of one time Ad hoc reports for business analysis.

Environment: OracleApps EBS 11i (11.5.10/11.5.9 ) & 11.03, PO, AP, GL, INV, AOL, PL/SQL,SQL, HTML, Unix Shell Scripts, Oracle Workflow2.3, Forms6i, XML, Toad, SQL* Loader, PVCS.

Confidential

Team Lead

Responsibilities:

• Production support- Analyze Issues raised by user and work for the resolution of technical issues related to financial, distribution and manufacturing application modules
• Bug fixes, changes to Inbound Interfaces, workflow code, reports and concurrent programs and data fixes. Bugfixes to concurrent Programs, workflow code and reports.
• Support Upgrades, month end, quarterly reporting.
• Testing application (Including Unit Testing and Pre Integration testing), Production Support for Oracle ERP upgrades, server moves, Oracle Patches, Oracle Database and application server upgrades.
• Fix and close Cases raised by users per SLA, manage team SLA metrics.
• Co-ordinate with Oracle Eco system, Middleware and third party application teams to resolve the interface issues.
• Customizing Concurrent Programs and interfaces (Pl/Sql Package Procedures, Reports).
• Prepare weekly Metrics status reports and present it to the clients.
• Co-ordinate with DBA, Sysadmin teams for code release, Bug fixes and Enhancements and Oracle setup changes.
• Raise Oracle SR’s and Coordinate with Oracle Support for Service Requests and support Oracle patches and fixes

ERP Modules: OracleApps 11i(11.5.10) EBusinessSuite, PO, INV, OM, EDI, AP, AR, GL, BOM, PLSQL, HTML/XML, Oracle 9i/10g, Forms6i, Report6i, Oracle Workflow, Oracle XML Publisher, TOAD, PVCS.O/s: Solaris

GECF Auto UK

Team Lead

Responsibilities:

• Study and analyze feasibility of receiving large QCB block reply from Credit Bureau, Study changes to Credit Bureau requests.
• Identify necessary Variables for CustomFianace new card along with business and Equifax team onshore.
• Design of new Credit Bureau request for CustomFianace, design new card variable positions, interpretation of new variable values for Equifax specification. Design new scorecard packages, views.
• Coding and testing of Oracle Forms validation changes and new Program Units, responsible for creating new Pro*C functions, Pl/Sql packages, views.
• Create unit/system Test cases, UAT support at Onsite. Post release support onsite.

Environment: Pro*C/C, PL/SQL, SQL, Shell Scripts, Pancredit(Expand UK version) application , D2K/Oracle Forms6i, User Exit Interface, TOAD, Kea term, PVCS, Mercury Test Director,

Confidential

Oracle developer

Task Force Enhancements Team

• Direct-Debit (PayOut) for HONDA in PanCredit.
• US GAAP Phase3 enhancements
• Garnishment Registration Fee from Branches .
• Jumping Horse (JUMPY)
• Rescheduling of Balloon Agreements.
• Money Transfer: Change in ATM Cash Card Fee.
• Market Partner/Companies Bank Account Names Cleanup.
• Reconciliation screen enhancement
• Analysis Codes from CCApps along with New Agreements.
• Locking CostCenter Codes.
• New Loss Provision Reports
• Stop CASH Posting’s on L/R Contracts.
• Queuing: Enquiry, Serveres Queues clean up.
• IKS Report on Deferrals and Term extensions
• Dialer Download Extension
• Data warehouse Views: Events and Notes new views, New View for BaseRate, Changes to Contracts view.
• Changes to ATM authorization process.
• New HOEHER queue
• Sales Reorganization - II
• MassPrint Branch migration.

Responsibilities:

• Analysis of requirements, Design, Impact study, writing solution Approach (IDD), Estimations.
• Coding Pro*C programs, Pl/Sql Packages, Create new Forms4.5 screens and Forms4.5 changes.
• Unit Testing, UAT Support, prepare unit Test cases, system test cases 3.

Environment: PL/SQL, Pro*C/C, Shell Scripts, SQL.Pancredit application, User Exit Interface, Developer/2000 FORMS4.5, Reports2.5, SqlPlus Reports, UserExit Interface, Toad, PVCS.X - Thin Pro Forms 4.5 client. PVCS.

Confidential

Oracle developer

Responsibilities:

• HLD for CCApps Interface, NewCardno, Agreement Limits Maintenance Forms4.5 CUI Screens, Product setup Screen, Name Change event generation.
• Design & Coding of Error handling/logging routines throughout the modules.
• Developed new Product (Cash Card) setup (onetime set and updateable) screen for setting up Cash Card Product level parameters such as product Online/Offline cash limits, POS online/offline.
• Developed Agreement Limits Maintenance Screen (Forms4.5) ·Coding Program Units for Cash Card Limits Maintenance Screens
• Changes to existing Product setup screen with Program Units for identifying new Cash Card product and calling, Block Maintenance Screen. Implementing the Euro Currency Conversion for the Cash Limits screen. Agreement Limit changes to Identify Cash Card Agreements for relevant Fee postings etc.
• Writing Unit Test cases/System Test cases for all the above Units and other modules/Initial ·Code review for PL/SQL, FORMS programs of other Team members for PL/SQL stand

Environment: PL/SQL, Pro*C/C, Shell Scripts, SQL.Pancredit application, User Exit Interface, Developer/2000 FORMS4.5, Reports2.5, SqlPlus Reports, UserExit Interface, Toad,X - Thin Pro Forms 4.5 client, PVCS.

Confidential

Programmer/Developer

Responsibilities:

• Handled MLD Fixing Module, Fixing Screen and Schema/Stored Procs for New deals, Validate Deals, Authorize, Close, Reopen, modifying of deals for Fixing. Design and coding of Class Module (MLDFIXING.CLS) which includes all Business Logic .
• Design and Coding of Maintenance Forms (fixing), Design and Coding of Error-Handling Routines Both in Class/Form Modules, Coding Stored Procedures and Routines for showing up Backend Exceptions (Validations Based) on front-end.
• Handled User Defined MLD Reports (MLD Maturity/Profitability/Accruals/ Customer Report (With Stored Procedure)/Amortization Control List.)
• Coding of class Module For Userdef Report Screen (Routines For Generating Parameter (userdef) Strings, Decode parameter Strings, Procedures for dumping Data Required Data for Reps into worktables From Transaction Tables/Spooling Reports to EX.WorkSheets,Ms word etc.,Procs For Preparing Report Headers, Page Header Selection Formulas/Calling rpt From Crystal Report API. Error handling routines For Failed /Previews/Printing/Stored Procedures etc. Coding of Stored Procedures for Data Dumping in Customer Report. Design of RPT’s (Crystal Report 7.0) for all 5 Screens.
• Handled Unit Test Plan (UTP) for all the above Modules/Technical Documentation/Module Testing.

Environment: MS. VisualBasic6.0 with ODBC API/WIN32 API, PL/SQL, SQL, Oracle 8.0, Crystal Reports7.0 API, MS Access/VBA