EXPERIENCE SUMMARY:

• 10+ Years of IT experience on Oracle Applications (E - Business Suite) 11i, R12i and Oracle ERP Cloud, PL SQL as a Technical Consultant, development, implementation, Production support, Project & Program Management and documentation of Application Software out of total of 13+ Years of IT Industry Experience.
• Extensive experience developing interface, conversions, extensions using oracle PL/SQL, around SCM & FIN modules.
• Experienced in creating sandbox and publishing, creating ESS jobs, developing FBDI Interfaces using
• WSDLs, Creating BIP Reports.
• Lead the team understanding and defining As-is processes, gathering & documenting requirements globally defining to-be processes, documenting test scenarios and planning and testing the same during, CRP, SITUAT by involving global/Site level SU/SME’s/BO and cutover plans preparations/execution
• Interacts with multiple team and customers for different Oracle implementations and supports.
• Capable of leading high performing teams under tough deadlines, to meet expectations of multiple customers.
• Strong communicator (verbal and written) and multi-tasking skills
• A keen strategist, planner and implementer with expertise in devising strategies aimed at enhancing overall rganizational growth, sustained profitability of operations and improved business performance. Motivated by internal standards of performance to deliver quality results.
• Experience includes exposure to all the phases of Software Development Life Cycle including AnalysisDesign, Development, Testing, Implementation, Production Support and Maintenance using Water fall and
• Agile (Jira and Rally) Methodologies.
• Learned and Trained team members employing agile and scrum practices to improve work flow, facilitating exercises such as sprint planning and team standups.
• An effective leader and communicator with strong interpersonal, leadership, analytical and relationship management skills. Trouble shooting and problem-solving skills.
• Participated in Proposal Preparation & Presentation (Defining the scope, Effort Estimation & Cost, Detail
• Project plan, Risk analysis and mitigation plans)
• Project planning, risk management, project tracking, re-planning, proposal preparation, People Management, Estimations, Change requests tracking
• Worked in different roles like technical consultant, analyst, project lead, Programmer Analyst, Team Lead

TECHNICAL SUMMARY

ERP Oracle Applications: (Release. R12.2X/11i/11/10.7), Oracle Fusion Cloud R12 & R13

Modules: AP, GL, AR, CM, HRMS, OM, INV, PO, AOL, PA, FA, BOM

Languages: SQL, PL/SL, C, Pro*C, VB, Unix Shell Script, HTML5

Development Tools: Oracle Developer Suite 6i/10g Forms/Reports, Discoverer, Workflow Builder, XML/BI Publisher, OTBI, Oracle ADF

Operating Systems: Windows 10,08,07,95, 98 / NT/2000, SCOUNIX, HP Unix, LINUX, MS-DOS.

RDBMS: Oracle 12c/10g/9i/8i/8, MS-Access

Other Tools: Toad, SQL Loader, SQL Developer, Putty, WinSCP, Kintana, Putty, WinSCP Tortoises SVN, Remedy, Jira, Rally, Clarify, Clear Case, Panaya, Oracle JDeveloper

WORK HISTORY:

Confidential

Technology Lead

Responsibilities:

• Responsible for project documentation such as risk register, issue register, acceptance criteria, project progress reportchange management report etc.
• During Analysis phase data quality issues need to be addressed like Data Cleanse in source, Cleanse in staging process, Cleanse in-flight using coding logic.
• Gathering specification of how the source and target objects will be mapped, down to attribute level.
• Prepare technical specification and Extract rule document for Master and Transactional Data Extract Programs.
• Extracts in Scope Vendor, Addresses, Items Master and Assets, Projects, AP invoices, Equipment master etc.
• Seek approval from the Business owner on quality of data before providing to source system to be loaded in multiple testing Environment and make sure to resolve the Issues related to Data from Source System.

Environment: Oracle eBusiness Suit R12.2.5, XML Publisher, PL/SQL Packages, Oracle Database 12c

Confidential

Offshore Fusion Technical Consultant

Responsibilities:

• Involved in overall architecture design for implementing the interfaces by using FBDI templates and WSDLS which are provided by Oracle.
• Development of BIP reports and OTBI
• Creation of ESS (Enterprise Scheduler Services) jobs for the custom BIP reports.
• Responsible for creation of functional and technical design documents and perform the peer reviews.
• Involved in various test cycle of the project, defect fix and resolution of the Interfaces.
• OFC - Synergy Integration: The integration sends the master customer information to Synergy Application from
• Oracle Fusion Cloud
• GL validation Interface to ARCS (Account Reconciliation Cloud System) cloud.
• Developed GL Budget Outbound Interfaces to Essbase system
• Developed AP Invoice Payment Outbound Interface for Blackline System
• Developed BIP reports for FBDI interface Errors like GL Import, Payable Import and AR Auto Invoice Import.
• Worked on POC to create customers in OFC by using SOAPUI Web Services

Environment: XML/BI Publisher, FBDI, OTBI, ESS, OFC Release12/13, SOAP

Confidential, Broomfield

Responsibilities:

• Estimating the efforts required for RICE Developments
• Involved in building a Technical & Functional team.
• Drive the Business Requirement Meeting & translating the requirement into Functional & Technical specification
• Lead the team in gathering and documenting business requirements by involving global and Site level business teams(SME s/BO)
• Lead the team in designing solutions and reviewed and approved the same with Site& global level SME s and BO (Business Owners)
• Involved in preparing and presenting the data migration strategy and planning and execution
• Lead the team documenting test scenarios and testing the same in different phases of the projects like CRP, SIT and UAT
• Planned regular calls with teams during critical phases of the project like design/testing/cutover to maintain project on time delivery with quality
• Publishing the test results and coordinating with Business teams for review and approval
• Preparation of cut over plan and execution.
• Prepared and presented weekly risk analysis report with mitigation plans
• Involved in providing post go - live support

Environment: R12.2X, Oracle Database 12c,11g, Forms10g, Reports10g, PL/SQL, SQL, TOAD, Panaya

Confidential, Burbank, California

Responsibilities:

• Involved in estimating the efforts required for upgrade from 11.0.3 to 11i
• Managing the support tickets through remedy and Service Now.
• Involved in building a balanced Technical team.
• Extensive help to auditors to make sure systems are under SOX compliance.
• Customize the Oracle Forms and Oracle Reports to capture the Business requirements.
• Drive the Business Requirement Meeting & translating the requirement into Functional & Technical specification.
• Played a key role in motivating the team by giving the spot awards and appreciating them at the appropriate time.
• Involved in providing solution for the business requirement.

Confidential

Responsibilities:

• Monitor, analysis and solve the production tickets in finance track within stipulated SLAs
• Evaluating enhancements/change requests, impact analysis and end-to- end QA testing while delivering solutions in financial modules
• Lead the finance track from offshore
• Developed the effective communication plan between onsite and offshore
• Requirements elicitation and clarification
• Impact analysis, coding, unit testing and documentation
• Developed customizations for various Forms and Reports across modules
• Designed and developed complex RICE components and personalization

Environnent: Oracle Applications 11.0.3, Oracle 9i/10g, Forms6i, Reports6i, PL/SQL, SQL, TOAD, SQL Loader

Confidential

Team Member

Responsibilities:

• Code generation.
• Creating Low Level Design.
• Develop and execute Test Scripts.
• Creating Unit Test Plan document.
• Doing Unit Testing and System Testing.
• Creating System test plan document.
• Creating User Documents.
• Played active role in Database migration from Oracle 8i to Oracle 10g.

Environment: PL/SQL, Oracle 8.1.7, ORACLE 10.0.1.5, Unix Shell Scripting (Sun Solaris 2.5), Win 2000

Confidential

Responsibilities:

• Designing database to maintain the data.
• Writing queries/procedures to retrieve and store data in database.
• Testing, Providing Technical Support to End Users.

Environment: PL/SQL, Oracle 9iAS with Oracle 9i RDBMS UNIX Shell Scripting