SUMMARY:

• Over 13 years of experience in Oracle Apps / Oracle EBS Applications including Developing, Customizing, Designing, Testing and Implementation.
• Strong Functional/Development/QA Knowledge on Oracle E - business SCM and Finance 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 )
• Worked on Oracle Application Security using MOAC for creating or updating User, Responsibility, Request Group, Profile, Custom Security Profile, Form Function, Menu etc.
• Having good experience in Interface, Conversion, Data Loader and Web Adi
• Experience Planning and scheduling project tasks and assigning work items to the resources
• Experience in designing, coding, testing custom applications with an integration to Oracle Applications
• Involved in development of RICEW components using SQL, PL/SQL, Forms, Reports, XML/BI Publisher, JDeveloper, Workflow Builder and Discoverer as per Oracle Applications coding/ Customization/ User Interface standards and Coding techniques
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL
• Experience includes exposure to all the phases of Software Development Life Cycle( SDLC ) including Analysis, Design, Development, Testing, Implementation, Production Support and Maintenance and Software Testing Life Cycle ( STLC ).
• Prepared Technical Design Documents for customizations and conversions using Application Implementation Methodology ( AIM ) documentation methodology
• Trained by Oracle on Oracle Fusion Cloud Financials
• Managed QA projects through various Life Cycle models such as Agile, V & Waterfall .
• Strong experience in defect tracking tools such as JIRA, HPQC (Quality Center), Team Track, PVCS Tracker and Issue Manager
• Having good experience on Trading Community Architecture ( TCA ) and Sub Ledger Accounting ( SLA )
• Having experience of different type of projects like Implementation, Upgrade, Retrofit and Support for Financial modules.
• Having experience in OAF page creation, personalization, VO, EO, CO extension
• Having experience in working with Oracle for Service Request (SR)/TAR
• Having experience in Setting up AME User and creation and customization of Approval Management Engine ( AME ) rules
• Having good experience in SQL* Plus and PL/SQL, Advance PL/SQL, Performance Tuning using various types of Indexes, Explain plan, Trace utility & TK Prof and Partition Table .
• Experience in managing, mentoring and guiding team members with effective processes
• Achieved Certification for ‘ Amazon AWS Certified Developer associate ’
• Good Knowledge on Hadoop Cluster architecture and monitoring the cluster
• Experience in RDBMS & Data warehousing, experience in design, development, testing, implementation and support of enterprise data warehouse
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
• Experienced in BI Reporting tools such as Tableau and Oracle Discoverer
• Experienced in developing Data Mapping, Data Profiling, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions
• Performed Project Lead/Manager role and provided Product and Senior Management with estimates for Dev and QA project costs, resource needs and timelines.
• Responsible for providing final QA sign off on products and services for release
• 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
• Good experience in working with documents like MD50, MD70, MD120, CV40, TE20, TE40 and BR100
• 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 SKILL:

Oracle EBS: Oracle EBS R12 & 11i, 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, XML Publisher, IntelliJ IDEA, JIRA, Git, SVN, Jenkins, Postman, Databricks, Informatica, PL/SQL Developer

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

Cloud Stacks: Amazon Web Services (AWS S3, EMR, EC2, VPC, EBS, ELB)

PROFESSIONAL EXPERIENCE:

Confidential,New York, NY

Project Lead/Techno Functional Consultant

• 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), GL, 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.
• 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 Lock box 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 to 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

Confidential,New York,NY

Oracle EBS Financial Tech Lead/Techno Functional Consultant

• Successfully completed Global Implementation Project across ASIA & Europe
• Implemented Custom Global Intercompany system(GIS) and Global Chart of Accounts (GCOA)
• Implemented Web ADI for FA and GL with Project DFF customization for FA Addition
• Integration and Full end to end testing of AP-FA-GL flow
• Implemented Automated Custom File upload process, Invoice creation, Email & print Invoices
• Successfully Implemented the custom lockbox functionality for the Bank of New York
• Implemented Cash Management for Statement upload, interfaced to GL and reconciliation
• Implemented Custom Approval workflow, Form Personalization changes in Multi Org
• Successfully completed DR (Disaster Recovery) and Data center move project
• Coordinated and participated in product design, requirement, scheduling, development, status, and bug triage meetings
• Review, Analyze Impact of a patch for bug fix and not breaking existing functionality
• Performed Regression and Functional Testing before and after applying different patch
• Handling Development and Testing work for Support, New Projects and Enhancements
• Managing all Development and QA Instances and their cloning for the ongoing projects
• Validating existing functionality, Performance and Bug fixes after critical patch applied
• Reviewed and analyzed business requirement documents and technical specifications to ensure they are precise and accurate.
• Developed and executed test related documentation including plans, processes and schedules, and versioned them using Windows Share Point tool.
• Took initiative to re-organize and implement client process methodologies like release management, defect assignment and tracking for all projects which result in high quality and efficient results and ultimately reduce the time and efforts.
• Developed schedule and Work Breakdown structure (WBS) and assigned resources to the project tasks as a part of project planning through MS Project.
• Collaborated with Project Managers, Business Analysts, SME's, Development teams, and organized early sync-up meetings with QA team as a part of test readiness and defect prevention process.
• Monitored test execution of Order Management modules after deploying
• Reviewed all test cases and scenarios to ensure they will adequately cover the system requirements and business process flows as per Requirement Traceability Matrix (RTM).
• Participated in daily SCRUM meetings and gave the daily status of testing
• Provided leadership, test framework and actively identified needs to resolve them immediately. Conducted team status meetings regularly and facilitated issue resolutions.
• Provided defect and test status reports to the project management team periodically through Team Track.
• Communicated effectively with project team members, stakeholders and made recommendations to the management on process and approach.
• Provided an assessment of overall customer readiness of the application functionality to the management.
• Successfully Managing Team both onsite and offsite.

Environment: Oracle Applications R12 (GL, AP, AR, PO, OM, GIS, INV), PL/SQL, Oracle Developer 10g, XML/BI Publisher, Workflow, SVN, UNIX

Confidential, New York,NY

Oracle EBS Finance Techno Functional Consultant

• Study BP40 (as-is process) and BP80 (to-be process) documents for various OM billing streams - Activity Fees, SIAC,SFTI, Market Data, Transaction Fees, LCA. Analyze custom interface programs, custom tables, custom packages and reports. Participated in business requirement reviews and implemented plans and strategy documents for solution design
• Developed conversion programs to convert data from Oracle Applications 11.0.3 to 11.5.10 for Supplier, Banks and AP Payment Modules with help of seeded open interfaces
• Involved in development of Report, Interfaces, conversion, extensions, customizations of workflow in OM, AP, PO, AR, GL.
• Testing functionality, data flow and data reconciliation of successful conversion with interrelated modules like Inventory, Purchase etc.
• Preparing design documents, writing conversion Programs, preparing test cases, unit testing, integration testing, preparing conversion manuals
• Developed and design reports using XML publisher.
• Used SQL Loader and shell scripting to load data
• Implemented Oracle Order Management module and its integration within the Order-to-Cash(O2C) business process and integration with external interfaces to RAAMS, END2 systems
• Lead the UAT team by providing direction and support in terms of implementing SDLC processes & standards and participated in Office of Quality Control (OQC) review meetings.
• Develop and execute test scripts to manually and functionally test the Order Management core module and Order to Cash, GL, FA, Payable business flow
• Analyze custom interface programs, custom tables, custom packages and reports
• Managed, guided and trained team members. Planned and scheduled timelines and assigned Work items to the test team members.
• Conducted clarification review meetings with the business group after analyzing business requirements and decreased project scope by 20%
• Defined UAT Test approach and framework. Managed development and execution of test cases and tracked identified defects through defect tracking tool
• Conducted team status meetings and TRR (Test Readiness Review) meeting and tracked testing progress throughout the test life cycle
• Worked closely with the Team members, Analyst and tester in trouble shooting critical defects and effectively communicated to cross functional team member on defect resolutions.

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

Confidential

Software Engineer

• Gathered and analyzed business/Product requirements and technical specifications
• Involved in complete life cycle of Procure to Pay and Order to Cash
• Analysis & coding of Conversion Program for Customer & Items. Data Loading, validation and uploading of different objects in different instance & preparing Status Report
• Customization of Reports, Alerts and a Workflow. Created New Repair report & new Alert creation and customizing it as per the requirement
• Creating & modifying Concurrent programs, Value sets, Scripts for registration of programs, Control files, Table scripts, Packages and LDTs
• Performed Report and Alert customization. Created custom utility packages in PL/SQL.
• Involved in functional, System Integration, Regression and UAT for Suppliers, Items, Banks, GL, Payables, CM, OM Modules
• Developed custom interface Program to load transactions from external flat files into interface tables.
• Having good experience in working with Unix Shell Scripting

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