SUMMARY:

• 11 plus years of professional IT experience in Oracle Application configuration, design, development and implementation having expertise on GAP analysis, Process mapping and Gathering Business requirement.
• Experienced in Oracle product development, implementation, upgrade and support projects.
• Extensive experience in configuration, implementation, customization, maintenance and support of ERP Applications using Oracle R 12/11.5.10/11.5.9 E - Business Suite.
• Strong knowledge in SCM modules of Oracle application like AP, AR, OM, PO, INV, WMS and fair exposer to Oracle HRMS and Payroll modules
• Technical and Functional knowledge of Order Management, Inventory, Purchasing, iProcurement, Payables, Warehouse Management, fair exposer, Exposer to ERP iProcurement cloud.
• Strong familiarity with AIM methodology in creating BRD, BR-100, MD-50, MD-70 etc. documents throughout multiple Projects.
• Strong application/ process testing skills created and executed UTP (unit test plan), SITP (system integration test plan), and UATP (User acceptance test plan).
• Strong knowledge of testing tools like MQC, Bugzilla, Test Director, HP Quality Center
• Expertise in customizing RICEW objects for Oracle implementation, well understanding on Incident, Problem, Change and Release management cycle/process and documents through Remedy/Service Now tool for fixes/code implementation.
• Rich experience of working in Production Support Projects as Problem manager, Incident manager and Change Manager Roles and ITIL aligned support processes.
• Strong knowledge of configuration controller concepts and versioning tools like SVN, Microsoft Visual SourceSafe, Serena, Harvest, ITG, Strong analytical skills, solution providing skills and result oriented.
• Strong inter-personnel skills, written and oral communication and team player
• Strong knowledge of GDM (Global delivery model) and SDLC (Software Development life cycle), have done two full life cycle implementation, one rollout project and 4 support management project.
• Strong knowledge in Microsoft Office (word, excel, PowerPoint), Microsoft Visio and Microsoft Project Planner.
• Well versed with Waterfall and Agile methods of project delivery

TECHNICAL SKILLS:

Technical: PL/SQL, RICEW, XML Publisher and RDF reports, Oracle Forms

Knowledge: SCM Domain i.e. P2P cycle, O2C cycle, Order Management (OM), Purchase Order

Functional: (PO), Inventory (INV), Account Receivables, Accounts Payables, Warehouse Management System (WMS), iSupplier, System Administrator, OMNI Channel

Knowledge: Upgrade, Vertex implementation, Proship Rating System

RDBMS: Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12C

Tools: Toad, SQL plus, SQL Developer, Mercury Quality Center, SVN, Microsoft Visual SourceSafe, Serena, Harvest, ITG, Remedy, Service Now, Mercury, Autosys

Projects Done: Two full life cycle implementation, one rollout project and 4 support management project

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Onsite Tech Lead

Platform: Oracle R12, webMethods, WMS-Manhattan, DP-Logility

Responsibilities:

• Oversight across delivery for Technical Analysis of issues raised by users
• Problem Management for the issues raised by users for their day to day business activities
• Ensure team adherence to processes and SLA across portfolio of work.
• Generate defect prevention matrix and thereby drive service improvement initiatives and manage the resolution of operational issues.
• Initiating change management process by creating change request for fix implementation and issue resolution
• Proposing solutions to business for issue resolution and clarification of doubts
• Work closely with offshore team to ensure onshore and offshore alignment, discuss internal team issues, and manage staffing levels.
• Co-ordination with Oracle support team to ensure the best practices and recommended solution
• Testing and migration co-ordination with different teams
• Managing patch implementation (RUP/ One-off) with Oracle support for R12.4 instance
• Ensuring code and data integrity in the system
• Created/Updated and reviewed BR100, MD050, MD070 and Test plan documents
• Conducted BR100, MD050, MD070, Test strategy, Test plans review session with Client
• Implementation of EDI interfaces (like 850,855,860 etc.)
• Implementing Oracle best practices by formulating process in coding and documentation
• Conducting CRP/ UAT session with client to obtain their approvals for implementing the developed solution
• Supporting the application post production Go-live
• Weekly Operations Status Reporting
• Organizing CAB meetings
• Worked as Problem and Change Manager

Confidential, Irving, TX

Onsite Tech Lead

Platform: Oracle R12, webMethods

Responsibilities:

• Managing the P1 application for HR data, time card entry and Payroll management.
• Generation of Payroll every week for more than sixty thousand employees across US and Canada
• Ensuring benefit management to generate the 401k, W2, W4 and health insurance
• Monthly implementation of Vertex tax file for government compliance of taxes in payroll
• Quarterly patch implementation to keep the HRMS module updated to latest Oracle version
• Data security and data masking activities due sensitive data
• Maintaining the time card entries for all employees across US and Canada geographies
• Problem Management for the issues raised by users for their day to day business activities
• Oversight across delivery for Technical Analysis of issues raised by users
• Ensure team adherence to processes and SLA across portfolio of work.
• Generate defect prevention matrix and thereby drive service improvement initiatives and manage the resolution of operational issues.
• Initiating change management process by creating change request for fix implementation and issue resolution
• Proposing solutions to business for issue resolution and clarification of doubts
• Work closely with offshore team to ensure onshore and offshore alignment, discuss internal team issues, and manage staffing levels.
• Worked as Incident Manager for P1 incidents

Confidential, Madison, WI

Onsite Technical Lead

Platform: Oracle 11.5.10, Oracle 11i

Responsibilities:

• Involved in Enhancements to the existing Application as well as fixing Issues as part of Production Support
• Involved in creation of different Database objects like Tables, Indexes, Functions, Stored Procedures, Packages, Functions, Views
• Created complex SQL Queries and Stored Procedures for providing data to the Web Application
• Involved in tuning Queries to provide data quickly to the Application
• Worked on Order Management(OM) Price List conversion, Custom Sales Order Import, Packing Slip report, Pick slip reports
• Developed a program to collect the details of the item created and sends a notification to group of users along with the details and link to master item form when an item is created in inventory
• Developed inventory on hand balances report
• Actively involved in performance tuning task force team, fine tuning all the affected processes (Reports, Concurrent Programs, and Nightly Jobs etc.) which would have Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc.) and modified (or redesigned) the existing programs to drastically increase the performance.
• Developed Vendor Interface program to load data from legacy system into temporary table to validate the data and run the Interface Program to load the data into base tables.
• Worked both as Development Lead and Production Support person for the Application
• Preparation of the various technical and functional documents such as Requirement Specification document, High Level Analysis and Approach document, High Level Design document, Detailed Design document, Unit Test Cases document, Release Notes and Implementation plans

Confidential, Blue Bell, PA

Onsite Technical Lead

Platform: Oracle 11g

Responsibilities:

• Requirement Analysis and Solution design.
• Providing solutions for complex Business problems by coordinating with Business users.
• Deployment planning and coordination for releases.
• Code review, Impact analysis of existing objects in the Project.
• Developed solution for first time load for large volume of data
• Implementing business rule for user provisioning.
• Used REF CURSORS to provide data sets back to Application from Database
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Used Bulk Collects to improve performance on handling larger Data
• Involved in creating Jobs using DBMS JOBS & DBMS SCHEDULER

Confidential, Blue Bell, PA

Onsite Technical Lead

Platform: Oracle 11g

Responsibilities:

• Lead Developer from onsite.
• Data mapping between ETL and Database tables
• Low level design for database
• Writing packages, stored procedures, functions, that to be used in application development.
• Implemented solution using SQL, PL/SQL, Stored Procedures, functions, Packages, Exceptions, PL/SQL Collections, REF Cursor and Exception Handling.
• Created database interface for Tibco
• Handling deployment and documentation related activities
• Code review, extensive testing and using Quality Center approach for test cases

Confidential, Blue Bell, PA

Onsite Technical Lead

Platform: Oracle 11g

Responsibilities:

• Worked on Data mapping for new system SPECTRUM and existing system CORE
• Worked on gap analysis and created gap analysis doc
• Participated in High Level design and low level design
• Participated in all phases of SDLC of this Application.
• Worked on estimations of project.
• Worked on complete metadata population
• Handling study migration activities
• Developing data migration code
• Design, coding, integration and testing for inform2CTMS Application.
• Writing packages, stored procedures, functions, that to be used in application development.
• Developed business solution using PL/SQL Object Types, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge, Global Temporary tables, Autonomous transactions, Dynamic SQL
• Handling deployment and documentation related activities
• Code review and extensive testing
• Analysis of all downstream applications and making sure no downstream application impacted
• Implementing business rules for comparison of two subsystems (Impact and Spectrum)

Confidential, Bridgewater, NJ

Onsite Coordinator / Technology Analyst

Platform: Oracle 11g

Responsibilities:

• Involved in analysis of production issues and handling of incidents.
• Involved in monitoring activities
• Creating reports for the PF hosted trials which contains information about the EDC provisioned users, confirmed sites, etc.
• Automation of different reports
• Impact analysis on the existing objects and addition of new interface systems
• Enhancement and bug fix
• Testing and Preparing UTC and UTL docs
• Creating scripts which compare data discrepancy among source and target system
• Developing automation scripts for easy analysis of issues.
• Maintained accurate documentation and issues resolution log.
• Module lead for R2 application.
• Handling code deployment
• Involved in Job Monitoring Automation