SUMMARY

• Over 16 years of experience in Oracle Cloud Financial / EBS Applications including Developing, Customizing, Designing, Testing and Implementation.
• Experienced Functional Architect on Oracle Utilities Work and Asset Management (WAM) V2.2 upgrade project includes Oracle EBS/Cloud Financial, Oracle C2M & MWM integration.
• Strong Functional/Development/QA Knowledge on Oracle E - business/Fusion Cloud Finance and SCM modules like Oracle Accounts Payable(AP),Account Receivable(AR), Order Management(OM), General Ledger(GL), Fixed Asset(FA), Cash Management (CM), Oracle Inventory(INV), iProcurement, iExpense, Advance Pricing, Core HR, Payroll, Oracle Projects, Project Accounting, Global Intercompany Solutions(GIS) module with custom Interfaces and Integration with External Systems.
• Proficient in Techno functional knowledge of Oracle Financial business processes with Procure-to-Pay (P2P) and Order-to-Cash (O2C)
• Experienced Oracle EBS/Fusion Cloud/WAM V2.2 Techno Functional/Project Lead with a demonstrated history of working in the information technology and services industry.
• Extensive expertise in Project Management, User Engagement, Business Analysis, Functional, Technical, customization and Implementation.
• Strong experience on developing CEMLI/RICE components in the sphere of Oracle EBS using SQL, PL/SQL, Forms and Reports 11g/12c, OA Framework (OAF), Web ADI, SOA, XML/BI Publisher, Workflow, Oracle Discoverer 10g
• Demonstrated proficiency and strong experience in development of EBS Data Conversions, Interfaces, Extensions & Customizations (CEMLI or RICEW) in Oracle EBS
• Experienced Functional Architect having strong implementation knowledge of integrations between Oracle EBS and Oracle WAM V2.2 (Oracle Utilities) through SOA configuration layers
• Proficient in all the phases of Software Development Life Cycle ( SDLC ) including Requirement Analysis, Solution Design, Development, Testing, Implementation, Production Support and Maintenance and Software Testing Life Cycle ( STLC ).
• Worked closely with Project Management, Development, IT, and 3rd party Vendors to improve product performance and reliability, discuss issues and evaluate product risks.
• Experience coordinating and overseeing onsite team and offsite team
• A strong customer advocate and believer in upholding strict best practices policies
• Excellent interpersonal, communication skills and understanding of Business applications
• Coordinated and participated in product design, requirement, scheduling, development, status and bug triage meetings
• Willing to take up challenging assignments and interested to work in emerging technologies.

TECHNICAL SKILLS

Oracle System: Oracle EBS R12 & 11i, Oracle WAM 2.2, Oracle C2M, Oracle MWM, Oracle Forms & Reports, Oracle Workflow Builder

Language: Hive, PL/SQL, Spark-SQL, Python, C/C++, HTML, Java

Tools: Aqua Data Studio, TOAD, SQL*Loader, SQL*plus, SOA, XML Publisher, IntelliJ IDEA, JIRA, Git, SVN, Jenkins, Postman, Databricks, Informatica, PL/SQL Developer, CAWA (CA Workload Automation)

SQL/NoSQL: Oracle DBaaS, Oracle 10g/9i, SQL-Server2000, MySQL, PostgreSQL

Cloud Stacks: Oracle Cloud Financial, Oracle Integration Cloud (OIC), Procurement Cloud, Amazon Web Services (AWS S3, EMR, EC2, VPC, EBS, ELB)

PROFESSIONAL EXPERIENCE

Techno Functional Architect

Confidential, CA

Responsibilities:

• Involved in designing, developing and validating solution design for Inbound, out bound interface between Oracle Cloud Financial and Multiple systems like Oracle Retails Cloud, EDI, Prompt, PFI, Thompson Reuters and many more
• Provided expert Functional, Technical and Quality Assurance knowledge to the project team and driven execution of new application releases.
• Discovery, analysis and design sessions with key stakeholders and process owners
• Conducting iterative CRP, System Integration and UAT sessions and issue resolutions
• Involved in Analysis, Design, Business Process mapping for Integration Project.
• Conducted Design Workshops, Liaise with Business Users to design appropriate solutions.
• Design and Implemented solution for Oracle Financial Cloud Integration with different systems for Inbound and Outbound Interfaces using Oracle Integration Cloud (OIC), DataStage, Public SFTP, HTTPS Server
• Involved in POC for various solutions like CAWA (CA Workload Automation) scheduling tool to schedule OIC Integration, Standard Oracle SaaS jobs, DataStage Jobs, Custom Component
• Involved in Design and Implement Framework for CAWA and OIC Integration using DBaaS.
• Performed POC and implemented Inbound Integration for Invoice import and GL Import in Oracle Integration Cloud
• Worked with Client to Complete FBDI Journal Import, Invoice Import Template for bulk upload
• Used FBDI and ADFDI for Invoice, GL, Suppliers
• Configuration of COA, Primary Ledger, LE using Rapid Implementation (RI)
• Development of significant number of BIP and OTBI reports
• Work with the Project team to build prototype of the solution and conduct CRP sessions with stake holders. Documented solution design completion. Work with the project team to build accepted final solution
• Validate solution and support validation by Business users. Support user change management with Trainings and Documentation. Perform Integration and Regression Testing for Oracle Fusion Cloud modules including Interfaces and Reports
• Prepare and review system appreciation, test strategy, test planning documents, support the creation of client training material, conduct knowledge transfer and mentor other associates in the team

Techno Functional Architect

Confidential

Responsibilities:

• Involved in WAM v2.2 Upgrade project, designing, developing and validating solution design for Inbound, out bound interface between Oracle EBS/Cloud Financial, Oracle WAM, Oracle C2M, Oracle MWM
• Provided expert Functional, Technical and Quality Assurance knowledge to the project team and driven execution of new application releases.
• Involved in Analysis, Design, Business Process mapping for Integration Project.
• Conducted Design Workshops, Liaise with Business Users to design appropriate solutions.
• Design and implemented solution for Inventory, Procurement, Payables, Timesheets, cost modules between EBS, WAM 2.2, C2M and MWM.
• Designing, writing and vetting functional specification for configuration, enhancements, new designs, interfaces and reports.
• Prepared Functional Design document, participated in business process meetings, preparing mapping document between source and target system, preparing business process diagram, work closely with offshore for solution delivery
• Implemented and validated integration interfaces between oracle EBS and Oracle WAM v2.2
• Implemented and validated entire process of Requisitions, PO, Invoice, Item Sync, Material Transactions like Material Req/Issue, Return, Transfer, Shipment Receipt, GL Accounts, Reference data conversion etc.
• Participated in design SOA web services, interface programs, spreadsheet integration, reports
• Executing data conversion for customers, suppliers, open AR transactions, GL balances, and fixed assets using Oracle FBDI and ADFDI templates
• Configuration of COA, Primary Ledger, LE using Rapid Implementation (RI)
• Participated in daily SCRUM meetings to discuss the status of work
• Extensive use of SQL Scripting for data validation
• Communicates project status, issues and plans to management and project team. Provide defect status and daily status
• Identify and facilitate test issue solutions and manage implementation and maintenance of automated tool and testing
• Used JIRA for defect tracking and Git Bitbucket for version control repository

Environment: Oracle EBS R12.1.3 (GL, AP, AR, CE, OM, PO, FA ), Cloud Financial, Oracle Utility Work and Asset Management (WAM) v2.2, Oracle C2M, Oracle MWM, PL/SQL, OUAF, Oracle SOA Suit, Oracle Developer 10g, XML/BI Publisher, Workflow, OA Framework, SVN, UNIX

Project Lead/Techno Functional Consultant

Confidential

Responsibilities:

• Built and Lead the Development and QA team by providing guidance and support with defined procedures throughout SDLC phases.
• Provided expert Technical and Quality Assurance knowledge to the project team and driven execution of new application releases.
• Provided Product and Senior Management with estimates for project costs, resource needs and timelines.
• Involved in implementation and testing of Procure to Pay (P2P Cycle), OM, AP and AR modules
• Implemented WebADI for Upload AP Invoices
• Implemented and validated entire process of payable transfer to GL, AP asset creation and mass additions create through payables.
• Using Advance Pricing, formula, modifier, Qualifiers for the OM Billing Streams
• Working with developers on developing conversion programs, interfaces, reports
• Involved in Analysis, Design, Business Process mapping for Integration Project.
• Implemented Automatic Bank Reconciliation functionality
• Implemented Auto Lockbox Functionality
• Responsible for Analyzing requirements, designing and executing manual and automated test cases, test conditions.
• Participated in daily SCRUM meetings to discuss the status of work
• Extensive use of SQL Scripting for data validation
• Develop XML, Python scripts for technical updates to modify automation framework
• Using Amazon AWS EC2, Hive, EMR and S3, monitoring pattern program deployment, execution and integrating with test Automation suite for validating results
• Successfully Managed Amazon AWS Cloud migration of legacy patterns from on premise to Amazon AWS Cloud
• Written Hive queries for data analysis
• Worked on Analysis and validation of the data stored on HDFS using Hive
• Responsible for determine task lists and effort estimates then communicate to managers
• Worked closely with Business Analysts for a correctness of the requirements
• Participated in Walkthroughs and weekly status meetings
• Collaborate with managers, analysts and development teams. Monitor test executions and ensure timely completion of testing
• Communicates project status, issues and plans to management and project team. Provide defect status and daily status
• Identify and facilitate test issue solutions and manage implementation and maintenance of automated tool and testing
• Recommend test approach strategies to management and provide assessment of application functionality
• Used Jenkins for build deployment, JIRA for defect tracking and SCRUM and Git BitBucket for version control repository

Environment: Oracle Applications R12.1.3 (GL, AP, AR, CE, OM, PO, FA ), PL/SQL, Oracle Developer 10g, XML/BI Publisher, Workflow, OA Framework, Tortoise SVN, UNIX, AWS