Senior Consultant Resume
SUMMARY
- Oracle Certified Professional with 10 years of consulting industry experience in software - oriented roles.
- Excels at PLSQL Development including coordinating ground-up planning, programming, and implementation for core modules.
- Expertise in developing complex reports using reporting tools like Oracle OBIEE, Oracle Endeca, Oracle Reports, Oracle Forms and excel reports using PLSQL programming.
- Expertise in creating PLSQL packages,triggers,view and using data migration tool such as SQL loader.
- Expertise in using Advanced PLSQL such as Collection, method, Bulk Collect .
- Expertise in the tuning of code and extensive join-based SQL queries to a performance effective code and query optimization, Index Optimization, Analysis of trace files.
- Proven planning, organizational, analytical, communication, presentation and team management skills.
- Have strong quantitative and analytical skills along with problem solving ability.
- Have got excellent customer relationship skills and an appetite to learn new skills.
- Able to work effectively as part of team or independently.
- Have worked in culturally diversified teams spread across different geographical locations and multiple levels of the organization.
TECHNICAL SKILLS
Programming Skills: Oracle PL/SQL, Oracle SQL,Oracle E-Business Suite,Oracle Applications, Oracle Forms Oracle Demantra forecasting tool, Query Optimization.
Reporting Tools: Oracle Reports, Oracle Business Intelligence(OBIEE11g), Oracle BI Publisher, Oracle Discoverer, Oracle Web ADI, Oracle Endeca Information Discovery.
Functional Knowledge: Supply Chain Management, Value Chain Planning(VCP), Inventory Optimization(IO), Advanced Supply Chain Planning(ASCP),Service Parts Planning(SPP),Order Management, Inventory, Bills of Material, Material Requirement Planning(MRP),Advanced Planning Command Center(APCC).
PROFESSIONAL EXPERIENCE
Senior Consultant
Confidential
Responsibilities:
- Being a core team member, involved in all phases of project implementation starting from gathering requirements till production support.
- Worked on complex SQL queries;created functions, procedures, packages, Triggers, views for a variety of projects.
- Developed Technical and Functional Solution design documents.
- Developed complex custom reports using reporting tools such as Oracle OBIEE,Oracle Endeca, Advanced Planning Command Center (APCC),Oracle WEB ADI.
- Resolved P1 bugs under extreme pressures.
- Created and executed test cases including unit, integration, and load testing; Assist business users during UAT.
- Analyzed project requirements to find bugs and eliminate issues within a timely manner.
- Worked closely with other development team members to identify and remove software bugs.
- Expertise experience on Unix Platform .
- Participated in a planning workshop with business users and top management to understand business issues and assisted them with the solutions.
Oracle e-biz technical consultant
Confidential
Responsibilities:
- Worked closely with other development team members to understand the existing system.
- Worked on a few customizations using PLSQL programming language.
- Extensive experience of Oracle PL/SQL development involving Packages, Procedures, Functions, Triggers, Hints and data migration scripts
- Supported implemented Oracle Applications project for CISCO client.
Oracle e-biz Technical Consultant
Confidential
Responsibilities:
- Developed custom reports using Oracle reports, Triggers, PL/SQL packages to integrate legacy and e-business product.
- Implemented and tested enhancement code to improve product functionality and performance.
- Developed Periodic and Event based Alerts.
- Worked on various RDF and XML Publisher Reports.
- Developed custom code to load data using data loader from legacy system to Oracle Applications Product.
- Developed SQL Loader control scripts for different conversions and interfaces using SQL Loader.
- Developed Interfaces to import the data from Legacy system to Oracle Application R12 System.
- Worked on System Administration Activities like managing concurrent managers, Application user setup, defining responsibilities
- Value Sets, custom look-ups, Flex fields, Registering menus, forms, reports, concurrent programs
Jr. Software engineer
Confidential
Responsibilities:
- Worked on core PLSQL projects and developed new code for a variety of projects.
- Resolved customer issues by establishing workarounds and solutions.
- Assisted business users during UAT.