SUMMARY

• Techno - Functional Consultant wif 8+ years of experience in implementing and supporting oracle distribution applications wif leaders in health care, logistics & communication industries.
• Possess strong noledge in various Oracle SCM modules like Inventory, Order Management, Purchasing and Financials Modules like AR, AP and GL.
• In a business analyst role, extensively worked wif client operations and projects team to identify teh gaps in existing business model and leverage Oracle EBS offerings to bridge them.
• Hands-on involvement in business requirement, GAP analysis, process mapping, solution design, configuration, Application Interface design, user training.
• Experience in teh preparation of Functional Design, Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports, Forms and Customizations.
• Proficient in developing functional and technical specifications as well as test plans in AIM methodology.
• Good Experience in implementing Order-to-Cash Business Process flows.
• Experience in database programming using Oracle 8i/9i/10g databases.
• Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
• Experience in developing UNIX Shell scripts for loading data into staging tables.
• Demonstrated excellent troubleshooting skills in supporting production issues and working wif Oracle to resolve issues in a timely manner.
• Specialize in Legacy Data Conversions, Customizations, Development, Testing and Production Support.
• Possess excellent communication skills and strong coordination skills in an onshore-offshore model.
• Absolutely capable of working in a fast paced, dynamic, team-oriented environment.

TECHNICAL SKILLS

Process Area: Order to Cash, Procure to Pay

Applications: Oracle EBS (Version R12, 11.5.10.2)

Oracle EBS Modules: Order Management, Purchasing, Inventory, AR, AP, GL

Operating Systems: LINUX, UNIX, Windows NT Server, Windows XP/2000/98/95, DOS

Software Languages: SQL, PL/SQL, Java, HTML, XML, C

Database: Oracle 9i,10g, MS Access,SQL Server 2008

Software / Tools: SQL*Plus, Quest Toad, SQL Developer, PL/SQL Developer, Putty, WinSCP(FTP tool), Microsoft Office Family, Visio, HP Quality Center (Test Management), SAP Business Objects 4.0, Crystal Reports (Reporting),UC4, APPWORX, PVCS Version Manager & Microsoft Team Foundation Server( Version Control), Peregrine,HDFS

Professional Certifications: Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist Oracle Inventory

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Application Techno Functional Analyst

Responsibilities:

• Business Requirements Review: - Responsible for analysis of requirement in order to implement clients' requests for new or modified functionalities in Oracle Apps.
• Gap Analysis: - Compare business requirements wif Standard Oracle Apps functionality and identify gaps. Identify customizations to TEMPeffectively fill these gaps or suggest alternate standard designs that satisfy business requirement.
• Solution Design: - Design teh end to end solution including key integration points and data flow, based on teh confirmed business requirement document. Prepare standard Solution design documents (MD50, Application Interface Design). This Involved Design of Custom AR Pre Processors and Autoinvoice Process, Forms Personalization and Design of Roles and Responsibility Matrix in Oracle.
• System configuration: - Responsible to perform system Set-up / Configuration and prepare a BR100 document for teh business users.
• Functional Testing: - Develop Functional Test Scripts (TE40) and perform functional testing of individual components in HP Quality Center.
• System Integration Testing (SIT): - Develop teh Plan and perform SIT in coordination wif business, upstream and downstream IT teams to ensure teh end to end solution is working as per teh business requirement.
• End User Training: - Train business users to TEMPeffectively leverage teh solution.
• UAT and Warranty Support: - Provide Functional/Technical Support to business users during User Acceptance testing and in teh Warranty period post Deployment.

Confidential

Oracle Application Techno Functional Analyst

Responsibilities:

• Understanding GEO/country specific requirements, to identify teh comprehensive list of elements that needs to be captured for teh respective transaction.
• Understanding teh Country specific trade documents requirements like Nota Fiscal for Brazil etc.
• Identifying teh most commonly used/configured pricing models from teh historical data and work wif Business to standardize teh pricing models.
• Coming up wif gap analysis and solution options.
• Preparation of Impact Analysis, Solution Design, Functional Design, Setups, Data Model, Development of Technical Design Documents, Unit & System testing, Post production analysis and support, Preparation of Knowledge repository.
• Work wif Oracle in resolving Key issues in production and conduct trainings for operational users to TEMPeffectively leverage teh system functionality wifin its scope.
• Worked as Oracle Data Expert to build custom reports ( in Crystal Reports/SAP Business Objects) and also designed BO Universes using Universe Design Tool leveraging teh understanding of Custom and Standard Oracle Data Models.

Confidential

Oracle Application Techno Functional Analyst

Responsibilities:

• Understanding and analyzing teh existing Business rules and Blaze implementation.
• Assist development wif complete re-write of iARS module leveraging teh features of Oracle Rules Manager to meet teh existing business rules.
• Preparation of Impact Analysis, Solution Design, Functional Design, Setups, Data Model, Development of Technical Design Documents,Unit & System testing, Post production analysis and support, Preparation of Knowledge repository.

Confidential

Oracle Apps ERP SME

Responsibilities:

• Worked wif Client consultants to understand teh client business model and key integration points.
• Legacy Data conversion into Oracle EBS, mainly for Item master import for individual customers
• Designed and Developed Custom Item type conversion process based on teh specific validation requirements for client business
• Designed ASN “track” custom functionality, based on teh clients requirement to bypass teh responsibility of tracking receipt quantity to customers.
• Fine-tuned several custom components as well as custom mappings to run teh system in most efficient way.

Confidential

Oracle Apps Techno Functional Analyst

Responsibilities:

• Participated in review sessions for Business Requirements
• Performed functional and regression testing
• Prepared BR100 documents
• Worked as functional SME for production support in later phases of project
• Worked wif Oracle in high severity SRs
• Worked on AR month end closures
• Developed Custom Reports for teh customer using Crystal Reports
• Developed Unix CRONs to automate fixes for recurring issues and worked on their RCA for permanent fix.