SUMMARY:

• Confidential has 13+ years of strong experience in Oracle Applications E - Business Suite and SQL & PL/SQL. Involved in Implementation, Upgrade, Migration of different Releases (R12, 11.5.10, and 11.5.9), Customization, Training, Post Go-Live and Production Support of Oracle ERP and Oracle based technologies in Logistics, Manufacturing and Healthcare Industries.
• Strong experience in Order to Cash, Procure to Pay and Supply chain modules, including project management and support engagements
• Worked in different roles such as Technical Consultant , Senior Systems Analyst , Production Support lead for different clients and also provided functional and setup based solutions when needed.
• Effective collaboration with key stakeholders (Business users, IT teams such as Application Development team, DBAs, Infra structure, external vendors)
• Managed both onsite and offshore resources for completion of projects on time and budget
• Effective client management, communication, presentation and facilitation skills
• Experience in managing full SDLC projects from inception to implementation
• Coordinated User Acceptance Test planning and execution
• Part of recruitment team in hiring resources for different requirements for the related Technologies.
• Successful rollout & support of R12 and 11i implementation.
• Well versed with AIM and Agile methodologies.
• Ability to learn new skills very quickly.

TECHNICAL SKILLS:

• Accounts Payables (AP)
• Account Receivables (AR)
• General Ledger (GL)
• Purchasing (PO)
• Order Management(OM)
• Inventory (INV)
• Hands on experience on Bills of Material (BOM) and Work in Progress (WIP).
• Oracle Human Resources (HR)
• Sun Solaris, Windows 2008/2000/NT/98
• SQL/PL-SQL
• Developer 2000 (Form6i/9i, Reports6i/9i)
• Oracle Workflow, BI publisher
• Oracle Discoverer Reports 10g
• Oracle 11g, 10g, 9i
• Oracle EBS Suite (R12, 11.5.10.2 and earlier versions)
• Oracle SQL & PL/SQL
• Oracle API's
• OAF
• Java (Hands on Experience working on XML’s and Jars)
• TOAD, SQL & PL/SQL Developer
• XML Publisher
• Jdeveloper 10g
• Text Editors - Ultra Edit, Beyond Compare & Snagit 11
• Version Control - PVCS, Harvest & TortoiseSVN
• Migration Tools - Kintana, HP Project and Portfolio Mang. Software
• Automation Job Scheduler - Tivoli Work Scheduler(TWS)
• Incident Management - HPSM, Service Request and Team Track Mang. System.
• Release Services - ITG
• CA Agile Central (Formerly Rally)
• Document Management - Live Link, SharePoint & ADR
• Application Life Cycle Mang. - HP ALM, Mercury Quality Center & Test Director
• Code Verification & Bugs finding Tool - HPE Security Fortify SCA
• Others: Enterprise Service Catalog Suite, Putty (SSH)
• Unix Box - Ipswitch WS FTP 12.5.1 Professional, WinSCP3
• Microsoft project, MS office, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Technology: Oracle SQL & PL/SQL, Java (Partially), ETL, EBS R-12(AOL, SYSADMIN, AR)

SQL developer

Responsibilities:

• Worked on customizing the seeded reports.
• Worked on Interfaces
• Developed the on-hand quantity reports.
• Implementation of the ATP
• Customization of Order management Workflows.
• Developed Master and Detail reports.
• Adding descriptive flex fields at the order header and detail level forms.
• Form personalization to change the existing functionality of the fields. Made the changes, in AR, INV and OM modules, on the major utility forms.
• Used the UTL functionality for generating outbound Data files and the excel files.
• Used the XML publisher to generate the reports based on different templates.
• Created the reports, on running the concurrent job and sending them to the respective authorities through emails.
• Generated the Auto Invoice reports.
• Worked on new OAF forms and customizaitons
• Very good at the functional navigation and setpup of these modules
• Worked on adhoc reports when ever needed. Generated reports for Items, priceslist for the items,
• Leading the offshore time and making sure all the deliverable are delivered on time.
• Hosting SRS walkthroughs and leading the discussion with the Business team to solve the ongoing issues and process based bottlenecks.
• Increased the productivity and accuracy of the current process; regularly interacting with the client’s, for the betterment of the existing process.
• Working on Team Tracks - Correction portal, where the tasks are assigned through tickets by the business team. Able to complete and deliver the tasks as per the SLA, with at most accuracy and precision.
• Analyzing the tables, and gathering the stats on the custom tables, when there is performance hit.
• Analyzing and performing the performance tuning, when the query is running slow.
• Monitoring the audits. Analyzing and fixing the data, when there is an Audit controls deviation.
• Monitoring the Job Abends, analyzing the issue, fixing that and continuing the automated jobs till completion.
• Being available on the weekends, for the weekend support.
• Managing onsite and offshore team members, including project management
• Attending Agile Standup calls, and giving the day to day updates representing On-Site and Offshore teams.
• Lead the Agile team, as a Scrum Master. Taking the updates and sharing the tasks, among the team folks.
• Have been a part of Kanban team as well. Prioritizing and completing the task, as per the business deadlines.
• Worked on Break Fixes, Work Orders and fully blown projects end to end.
• Worked on Design documents, Test Case, Summary and Snapshot documents, Tech Spec, Mini Tech Spec and Detail Design and the Deployment documents.
• Uploading all the required documents into ADR (Document Mang.) and the scripts into Harvest/SVN and follow through the approvals.
• Active participant of the Deployment team. Supporting and deploying of the scripts and verifying the deployments.
• Worked on Research tickets and provided work arounds and solutions.
• Loading huge PHI (Protected Health Information) files e.g. Claim and Provider files, processing them and generating the reports for the Business on a Weekly and Bi-Weekly basis.
• Providing the estimates for the Projects, Work Orders and Break Fixes.
• Carrying out Unit Testing and preparing the scripts.
• Supporting UAT and setting up the data in the respective instance.
• Supporting Pre-Deployment, Deployment and Post Deployment Actives.
• Attending client mandated Training Sessions, be it organizational, process or technology based.
• Holding process and domain based training sessions with the clients.

Confidential, Orlando, FL

Technology: Oracle APPS (O2C, P2P and SCM modules, including custom applications)

SQL developer

Responsibilities:

• Development and Customization of existing RDF, SQL & PL/SQL Reports, Custom Packages and Forms
• Gap Analysis between 11.5.9 to 11.5.10 Oracle Applications EBS.
• Raising Service Requests in Oracle Metalink and following through the issues. Any scripts or the patches provided by the Oracle, where deployed.
• Testing of new developments and customizations
• Preparation of MD50, MD120 and TE20.
• Working on Change Request
• Analyzing all the DB objects and identifying the impacts on them due to upgrade.
• Identifying the custom objects, which are impacted due to upgraded API’s.
• Identifying the impacted .Pll’s and .Pls files and replacing them.
• Worked on Zoom functionality and the Custom.pll
• Worked on developing Forms from the scratch using the Template.fmb
• Worked on Personalization of Forms.
• Worked on DFF’s (Descriptive Flex fields).
• Responsible for conducting SIT,UAT and post production support for multiple projects
• Production support enhancements, responsible for transitioning to new members of the team

Confidential

Technology: Oracle APPS R12 (GL, AP, PO & OM)

Technical Consultant

Responsibilities:

• Involved in gathering requirements from business users, preparing design documents for interfaces, data conversions for suppliers and Purchase orders, coordination with offshore team during development and unit testing
• Responsible for preparing test cases, functional testing of interfaces, attending client meeting etc…
• Participated in CRP, UAT, Go live activities had extensive business user interaction during each phase of implementation
• Worked on RICE components.
• Hands on experience on BPEL.

Confidential

Technology: Oracle APPS 11.5.10.2 (GL, INV, AR, OM), Oracle 11g

SQL, PL/SQL Developer

Responsibilities:

• Preparing Detail technical design document
• Responsible for managing the entire releases which includes managing the timelines, resources, providing status updates to stakeholders, coordinating with offshore development team, conducting SIT, UAT and also worked on post implementation support, transitioning to support team.
• Developed Excel format reports, generating them on running the Concurrent Programs and Sets.
• Worked on Discoverer and XML Publisher reports.
• Worked on Alliance Cases - Incident Management System.
• Developed and Customized Master Detail forms.
• Code Enhancements.
• Worked on Interfaces.

Confidential

Technology: Oracle APPS (Receivables, Service contracts), Oracle 11g

Responsibilities:

• I was responsible for gathering requirements from business, coordinate with cross functional team, prepare detailed technical design document required for conversion, coordinating with offshore team during design and development
• Responsible for coordinating with multiple IT teams to planning and conducting CRP1, CRP2, UAT, provide status report to stakeholders periodically, managing the timelines in terms of deliverables.
• Worked on customizations, reports, data migration, interfaces, new form development related to OM, AR modules
• Developed concurrent programs for reports, data conversion and interface programs, developed new form extension using TEMPLATE.fmb,