SUMMARY

• Total 20+ years of experience in IT, which comprises of experience in IT organization and in - house IT functions, Business Analysis, Gap Analysis, Design & Development, Project(s)management, IT Restructuring, Product Management, People Management, Team Co-Ordination, System Analysis, Data Modeling, Database Administrator, Pre sales, Technical/Functional Consulting, EBS Technical Architect, Program Management, Planning and Coordination, Resourcing, Budgeting and Testing of Applications.
• Extensive 14+ experience on Oracle 10.5, 11i, 12.1.3 e-business Suite in Development/Management for eg. Conversions, Customization, Extensions, Interfaces, Reports, Implementation and support.
• 7+ years into IT Management, IT Restructuring, ERP/EBS Implementations, IT Business Development.
• 2 years of experience in Oracle Fusion ERP (Cloud), ADF Development, Java, interfaces with SOA & OBIEE Reports.
• Good Knowledge of Oracle Apps 11i/R12 Architecture, Flex fields, AOL, API, Open Interfaces, Concurrent Program, Alerts, Concurrent Program Executable, User Request etc.
• EBS Technical Experience in OAF, Oracle Developer (Forms & Reports) 4.5/6i/9i/10g, BI Publisher, OBIEE, SOA, Data Loader, EDQ, Pro C, Java, PLSql, Work flow, Interfaces.
• Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), Order Management (OM), I-Procurement, Enterprise Asset Management(EAM).
• Experience with Oracle 11g/10g/9i/8i/8.0/7.x, Database client/server environment, PLSQL, Triggers, SQL Tuning, Packages and Stored Procedures.
• Experience in Jdeveloper, SOA, Jsp, Java/Html screens, Servlet and java scripts etc.
• Technically proficient in RICE components (Reports, Interfaces, Conversions, Extensions)
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Software Development Life Cycle (SDLC).
• Knowledge of Testing & debugging process, System Integration testing, Unit testing, automated testing etc.
• Strong in Requirement Gathering and Rendering proper guidance to Clients on different approach for a solution.
• Knowledge of Project Management. Product Management & Standard Quality Assurance.
• Experienced in migration of Oracle Applications from old to new versions of Oracle & data migration from non oracle data sources to oracle databases.
• A self-starter with excellent interpersonal skills and possess situational leadership skills.
• Good communication and user interaction skills, capacity to work harmoniously in a group with sincerity and dedication towards work and organization
• Good understanding of all phases of Software Development Cycle (SDLC), from gathering Business Requirements Analysis, System Analysis & Design, Building Framework, Architecture, and associated Project Management and Agile Project Management.

TECHNICAL SKILLS

Front End Applications: Oracle Forms and Reports 6i, 10g, 12c, Oracle Fusion Middleware, Oracle Application Framework (OAF), ADF, VB 6., .NET, C#, APEX

Reporting Tools: BI Publisher, OBIEE, Oracle Reports 2.5,6i,9i,10g (Character, XML, PDF reports), Oracle Discoverer, Crystal Reports, Business Objects, PL Sql Reports, ADI, Pro-C

RDBMS: Oracle 7.3/8.0/8i/9i,10g,11g, 12C SQL Server 2018

DBMS: FoxPro, MS Access, My Sql

Languages: Dbase, FoxPro, Clipper, C++, Java, Pro C

Designing Tools: Visio, Oracle Designer, Rational Rose

Testing / QC Tools: Test Director, Load Runner, Oracle OATS

Project Management Tool: MS Project, MS Office, MS Excel, Acti-time, Track-IT

Case Tools: ER win 3.5, Rational Clear Case, Oracle Designer

Web Tools: HTML, DHTML, JavaScript’s, XML, Macromedia, PHP, JQuery, Bootstrap, Html5

Other Tools & Techniques: TOAD, Eclipse, SQL Developer, Data Loader, Oracle EDQ, SOA, Bartender

Quality: ISO 9001, CMMI level 5-quality system standards implementation

PROFESSIONAL EXPERIENCE

Confidential, Crawfordsville, IN

Sr. Programmer/ Analyst

Responsibilities:

• Technical Lead at Crawfordsville Division implementation, (Interfaces, Reports, Conversions & Extensions).
• Lead teh BI Publisher Team, Customized, Developed & Supported EBS reports in SPS ERP Implementations.
• Conducted Oracle EBS Trainings for Users to get better understanding of teh product.
• Developed and Designed EBS Extensions using Oracle Forms & OAF.
• Involved in developing Interfaces from Legacy to EBS for Crawfordsville using SOA Suite.
• Involved in Data Conversions for Nucor Crawfordsville using data loader & API.
• Worked as co-coordinator between on Nucor Team and Offshore on Nexgen Project, to design and develop all Customer facing documents.
• Involved in Functional / Technical Solution Designs.
• Involved in Barcode, fax printing from EBS.
• Built Warehouse Bolton (barcode labels, self-checkout, receipts, transfers, cycle counting, returns) & interface with EBS.
• Customized list of EBS reports with BI Publisher, OBIEE & Oracle reports.
• Creations of technical and functional design documents using AIM methodology.(DS140,MD 50,MD 70)

Environment: BI Publisher, OBIEE, OAF, Oracle Forms & Reports 10g/12c, SOA, Data Loader, EDQ, SQL Loader, Visual Studio, Jdeveloper, Business Object, Java., PL SQL Developer, Toad, Workflow Builder, WinSCP, Putty, Bartender, EIS Reporting tool.

Confidential, Louisville, KY

Oracle Techno/Functional Consultant

Responsibilities:

• As a Technical Lead, responsible for requirements gathering, design & development, gap analysis, Development of solution product new features & maintenance of existing product solution.
• Created AIM based documents like BRD100, MD050, and MD070 etc. for various customization.
• Involved in providing techno-functional Procure-to-Pay (P2P) life cycle support.
• Developed extensions using ADF, fusion financial apps.
• Customized & created a list of reports with BI Publisher & OBIEE.
• Developed and implemented teh interfaces such as AP, Customer, and Supplier etc.
• Developed and support a custom service module using forms and ADF.
• Involved in Unit testing and writing test cases.
• Developed applications using Oracle APEX.

Environment: BI Publisher, OBIEE, ADF, Oracle Forms & Reports 10g, PL SQL Developer, Jdeveloper., OATS. WinSCP, Putty, BARTender

Confidential, Chicago, IL

Oracle Techno/Functional Consultant

Responsibilities:

• Worked as a Technical Lead / Architect on dis project.
• Developed a Bolton’s for inventory issues & receipts using touch screen.
• Developing interface/conversion programs using material transaction Interface.
• Customized list of EBS reports with BI Publisher & Oracle reports.
• Developed extensions using Forms and OAF
• Involved in customizing seeded Workflows.

Environment: Oracle Forms & Reports 10g, PL SQL Developer, Jdeveloper, XML Publisher, Crystal Reports XI. Test Director. WinSCP, Discoverer, Workflow Builder

Confidential, Indianapolis, IN

Oracle Technical Consultant

Responsibilities:

• Customized list of EBS Forms, Reports
• Developed technical document M D-070 for reports and forms customizations.
• Designing teh processes of data migration from third party systems to Oracle Applications
• Extensively worked on Data warehousing, to retrieve teh data and present it to teh clients.
• Working with global users to gather teh requirements

Environment: Oracle Forms & Reports 6i, PL SQL Developer, Jdeveloper, TOAD, APEX, ER win 3.5, PHP

Confidential

Oracle Technical Consultant

Responsibilities:

• Customized list of EBS reports with Oracle Reports & extensions with Oracle Forms 6i.
• Developed E-Business Suite programs for databases supporting supply chain management, inventory, warehouse management system, purchasing.
• Coordinating development teams on all technical aspects of implementing, upgrading, and customizing Oracle Application modules
• Development of Extensions/Customizations, Interfaces, data conversion and Deployment on teh Production based on MD70, MD50.

Environment: Oracle Forms & Reports 6i, PL SQL Developer, TOAD, Oracle Designer

Confidential

IT Manager

Responsibilities:

• Involved in IT restructuring, People management, Team building, Business Development activities, procurement management, Risk Management, Project management.
• Project support for clients, managing teh technical team.
• Created detailed project outlines, application design specifications, and test plans.
• Utilized ORACLE APPLICATIONS 11i/11.03/10.7, ORACLE FORMS 6i/5.0/4.5/, ORACLE REPORTS 6i/3.0/2.5, DEVELOPER 2000, PL/SQL and SQL to create and customized databases.
• As project manager, work with users through all Software Development Lifecycle (SDLC) phases.
• Responsible for Solution product requirements gathering, Solution product design & development, Solution product gap analysis, Development of solution product new features & maintenance of existing product solution.
• Involved in presales activities to give teh demos to teh clients.
• Worked extensively with development team members in resolving issues.
• Developed technical document M D-070 for forms and interfaces.
• Implementing Oracle AP, AR, GL, INV, PUR modules to meet Business requirements of teh client.
• Normalized Logical and Physical database design by utilizing ERWIN and DESIGNER 2000.
• Migrating from Forms 6i to Forms 10g Architecture.
• Building & Creating teh Frame-Work for MIPS ERP Applications.
• Involved in preparation of technical documents, domain specific product presentations, white papers, proposals and other marketing collaterals.

Environment: Oracle Forms & Reports 6i, PL SQL Developer, TOAD, Visual Studio, Eclipse, Macromedia, ER win 3.5 Crystal Reports, MS Projects, Oracle Designer, Test Director, Win/Load Runner, Visio, Photoshop, Track-IT

Confidential

Oracle Technical Lead / Co-ordinator

Responsibilities:

• TAR(s) and obtaining one of teh solutions using METALINK.
• Troubleshoot data related issues, Fixing bugs and issues with concurrent programs.
• Set-ups modules of Oracle Applications.
• Involved in providing techno-functional Procure-to-Pay (P2P) life cycle support.
• Optimization & Tuning of SQL codes using Toad or SQL.

Environment: Oracle Forms & Reports 6i, PL SQL Developer, Visio, Jdeveloper