Otc Tech Lead Resume
Charlotte North, CarolinA
SUMMARY
- 10 plus years of experience with Oracle Applications in Procure to Pay (P2P), Order to Cash(O2C), i - Expense, Inventory management and Financial Accounting Hub.
- Experience in Oracle Application Modules which include Payables, Purchasing (PO), iProcurement, Order Management (OM), Application Object Library (AOL), General Ledger (GL) and Accounts Receivable (AR), Inventory (INV) and financial Accounting Hub (FAH).
- Good knowledge in Application Implementation Methodology in different phases i.e., Requirement gathering, Operation analysis, Solution Design, Build, Test, Training, Data Migration and Production Support.
- Experienced in defining Testing Methodologies, Test Environment, Designing Test Plans, Writing Test Cases and Test Scripts.
- Supported Oracle Applications patching, upgrades and maintenance activities. Worked Closely with Oracle Support on SR.
- Ability to interact effectively with stakeholders, understanding their requirements and providing optimum solution and support.
- Excellent Interpersonal communication, technical and functional documentation skills and experience collaborating with project managers, business analysts, Architects, DBA’s, and Developers.
- Well versed with EBS System configuration and defined the application setup in BR100 for purchasing, Inventory, AOL, Accounts Payable etc.
- Proficient in running diagnostics using profile options and debugging issues using SQL Queries. Also experienced in debugging PL/SQL, SQL Loader, Oracle Reports 10g/6i Oracle Forms 10g/6i and workflow.
TECHNICAL SKILLS
Packages: Oracle E-business Suite (12.1.3+, 11.5.9, 11.5.10 CU2)
Modules: Accounts Payable, Purchasing, Accounts Receivables, General Ledger, Inventory.
Languages: PL/SQL, SQL, XML, UNIX, Shell scripting
Database: Oracle 10g, 11g, 19c
Development/Productivity Tools: Oracle Reports builder, SQL Developer, BI Publisher, Kintana, Service Now, Mercury Quality center, Tortoise Subversion, ITG, Team Track, Putty, Git Hub, Jira, Change Management.
PROFESSIONAL EXPERIENCE
Confidential
OTC Tech Lead
Responsibilities:
- Experience of team management, status gathering, customer handling, coordination with the clients, leadership, financial users & offshore team.
- Develop technical system enhancements/improvements that align to the business needs and requirement.
- Develop business process capabilities across all entities to set standard solutions that will deliver scale, agility, and value to the customers.
- Strong understanding of oracle third party integration that connect multiple systems and platforms.
- Initiated process improvements that eliminated the redundancy in daily tasks.
- Designed self heal & monitoring processes as a proactive measure.
- Lead, design and execute the development of new and existing configurations as well as supporting documentation that enables change management and end user training.
- Advanced troubleshooting techniques to reduce the business impact.
- Provide End-to End solution and process expertise to business stakeholders.
- Support Month-end, Quarter-end & Year-end close cycles. Followed up with oracle SR on various issues.
- Strong operational & technical experience with Oracle order to cash & service contracts.
- Deliver business briefs, status updates to clients, non- technical stakeholders, and technical teams.
Confidential, Charlotte, North Carolina
Apps System Engineer
Responsibilities:
- Thorough understanding in the Financial Accounting Hub functionality.
- Worked on and verified the Setups in GL and FAH.
- Develop, test, maintain and support customization to Oracle E-Business Suite version 12.2.5., PL/SQL code, UNIX shell scripts Streaming of high-volume data into parallel processing.
- Performed analysis and development on multiple moderate to large projects concurrently.
- Participated in technical and functional group discussions and code reviews. o Wrote clear design documents based on analysis of business requirements.
- Understand and follow corporate SDLC standards and release management standards.
- As needed, worked with the infrastructure teams (e.g., database DBA’s, UNIX or Windows SA, SAN engineers, etc.) in support of production issues or the build out of new infrastructure.
Confidential, Atlanta, GA
Techno Functional Analyst
Responsibilities:
- Engaged in the project as techno functional analyst.
- Understand the difference in Oracle 11i and R12 application.
- Upgrading finance application from Oracle 11i to 12. o Worked on OAF page personalization.
- Setup of item Attributes, Categories, Financial options, purchasing options, receiving options, Suppliers etc.
- Involved in developing, testing and bug fixing code from 11i to 12.
- Form customization and retrofitting code to ensure a smooth upgrade from 11i to 12.
- Experience working in issues related to Open Interfaces and API’s. o Retrofitted Oracle Reports and workflow and debugged the same.
Confidential
Senior Analyst
Responsibilities:
- Engaged in the project since its inception as offshore techno functional senior analyst.
- Involved in requirement gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
- Collaborated with global stakeholders to understand the business processes and gathered requirements for defining scope of the project.
- Create/update supplier, Enable/Disable GL code Combinations using API Wizard.
- Worked closely with development team to ensure the functional requirements are translated to effective and scalable technical solutions.
- Responsible for resolving critical Functional Issues related to financial module like (OM, AP, GL, AR and Sys Admin, Inventory) Setups in PROD Instance. E.g., Calendars, Currency Rates, Chart of Account (COA), Cross Validation Rule, payment terms etc.
- Performed fundamental administrative tasks including registering applications and reports, defining new users, responsibilities, profiles, menus, and setup value sets in the application.
- Actively involved in the transition process and preparing SOPs on the same and perform peer reviews.
- Responsible for defect analysis, coordinating with on-site developers, business users, various teams internal/external to the client, resolving issues, testing, and implementing code fixes, data fixes, performing root cause analysis and coordinating change management with DBAs/ SOA administrators.
- Closely worked with Oracle product support (metalink) on SRs helping resolve product level issues and bugs.
- Worked on fixing the issues using PLSQL, Oracle reports, oracle workflow, Oracle forms, XML publisher, putty, AOL etc. o Worked on middleware technology like SOA and BPEL Process to work on issues related to inbound and outbound interfaces.
- Responsible for testing all existing customization and standard functionality.
- Took lead in transitioning and mentoring of the complex batch monitoring process and the ESP mainframe tool and conducting training sessions for the team on the same.
Confidential
Software Engineer
Responsibilities:
- Mainly focused on Resolution of tickets related to I-procurement, Purchasing, Payables, GL, workflow forms, reports and interfaces, Invoice validation, payment batch and automated period close process. o Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the workflow utilizing the standard scripts from
- Oracle o Extensively worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities/Roles, Forms, Functions, Menus, Value sets and Flex fields in Oracle Applications.
- Worked on Profile, user, menu and responsibility, flex fields (KFF and DFF) setups and issues.
- The code migration includes the activities from implementation of new OU, New enhancements to the project or some bug fixes. o Also worked on the 170 systems, RightFax and Markview which is an Invoicing system followed by SSS.