Senior Consultant
DP World
مجموع سنوات الخبرة :18 years, 2 أشهر
around 70+ Reports/Notifications on HCM Learn/ Performance / Payroll Modules in Oracle Fusion
•Performed Sandbox personalization to access the Reports from Springboard to reduce customer access based on roles, Custom Logo and Disabling of fields.
•Performed Data load of 45k Employees using HDL.
•Performed Data Loads of Worker Assignments, Job, Departments, Position, Grade Data using HCM Data Loader
•Built Report Extracts in Fusion of Worker Assignments, Document Warnings, Positions, Jobs, Grades and Departments to validate loaded data from external system EBS.
•Built Bursting Reports to send the reports to users
•Integration using SOA Rostima from Oracle Fusion to generate SMS when Offering Change.
•Outbound integration through web services (WSDL)
• Print Digital Signature on Certificates
Bechtel is one of the most respected global engineering, construction, and project management companies. Together with our customers, we deliver landmark projects that foster long-term progress and economic growth. Since 1898, we’ve completed more than 25, 000 extraordinary projects across 160 countries on all seven continents. We operate through four global businesses: Infrastructure; Nuclear, Security & Environmental; Oil, Gas & Chemicals; and Mining & Metals.
•Developed the Project Accounting PO, Contracts Outbound/Inbound Interface so as to call from external Ecosys system using SOA as middleware.
•Developed Expected Receipts Report, Commitment Report as per Client requirements.
•Worked on Performance Tuning of the reports.
Technologies: Oracle Project Accounting R12.2.6, Oracle Procurement R12.2.6, SQL* Plus, PL/SQL, XML Publisher, OBIEE 11g
Jacobs Engineering, USA
Oracle Apps R12/OBIEE 11g / OBIApps Implementation
Jacobs, with annual revenues of nearly $11 billion, is one of the world's largest and most diverse providers of technical, professional, and construction services. Building strong, long-term relationships with our clients is the key to our success as a company.
•Developed the BI Reports and Interfaces in Project Accounting
•Developed Complex Project Financial Reports like OPR614, OPR696, OPR698 as per Client requirements.
•Worked on Performance Tuning of the reports.
•Worked on Bursting so the Report will be sent to Multiple Project Accountants at same time
•Developed on PO Reports, Multiple Currency, Multiple Vendor, Single Vendor Reports
•Developed OBIEE Reports on Project Financial Reporting.
•Created numerous executive level reports with Drilldown, Aggregation and 'Dashboards' which generated to provide insight into the financial data.
•Generated various Analytics Reports using global and local filters as per business requirements.
•Added users and configured security in web logic console and Managed security privileges for each subject area and dashboards according to user requirements
•Prepared the Technical Documents like MD07, TE50
•Trained End Users and Pilot Users about OBIEE Tools.
Technologies: Oracle Project Accounting R12.2.6, SQL* Plus, PL/SQL, XML
Plexus uses a unique Product Realization service model to transform your concepts into branded products and deliver them to your target markets. We tailor innovative solutions that integrate product conceptualization, design, commercialization, manufacturing, fulfillment and sustaining services. Whether you operate in the Americas, Europe, Asia Pacific region or worldwide, Plexus can deliver turnkey solutions to make your project a success.
•Lead team of size 5 members and Translated Business requirements into technical requirements.
•Developed BI Reports of Customization of Check Printing, SOA Reports etc.
•Developed Outbound Interface of Customer, Employee and Bank child relationship of TCA Architecture
•Customized Purchase Orders, Order Management, Inventory reports using OBIEE 11g.
•Worked with OBIA rpd, make use of existing logical objects, creating reports based on prebuilt rpd.
•The top priority reports like Monthly Net Sales, Customer Profitability, Funds Details, Credit Summary.
•Utilized features like dashboard prompts, pivot tables, column selector, drill down, hierarchy.
•Configured Web Catalog Objects (Dashboards, Pages, Folders, and Reports).
•Implemented various Repository Variables and System Variables depending up on user requirements.
•Prepared the shell script to migrate the components from one instance to another instance
•Prepared the Technical Documents like MD07, TE50
Environment: OBIEE-11.1.1.5, Oracle apps R12.2.2, Oracle DB 10g, SQL Plus, Oracle SQL Developer
Clopay, USA
Clopay Projects Enhancements
Clopay Building Products Company is the nation’s largest residential garage door manufacturer. We are also the preferred manufacturer and supplier of commercial overhead sectional doors among architects, specifies and building professionals. Providing industry leading customer service and quality combined with a keen market instinct for product innovations delivered healthy sales and earnings growth in 2004.
•Involved in the development/Customization of Reports/XMLP Reports like Sales Order Acknowledgement Report.
•Developed the customized interface to process the data to AR once the Orders are shipped.
•Gathered User requirements, reporting requirements and the document for requirement specifications.
•Used Administration Tool for customizing and modifying the Physical, Business Model & Mapping and Presentation Layers.
•Created dimension hierarchies, aggregates and keys in BMM layer.
•Worked on session variables and dynamic variables along with initialization blocks.
•Created users and groups in the repository and granted privileges and group inheritance.
•Worked extensively on Oracle BI Answers, Delivers and Interactive Dashboards.
•Created source and target instances and various transformations (Joiner, Aggregator, Filters, and Router).
•Configured many dashboards with different views like Pivot table, Chart, Tabular and View Selector and guided navigation links.
•Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
•Created highly formatted reports using BI Publisher based on Oracle Database.
Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle BI Publisher
Clopay, USA
Implementation of OBIEE 10g
Clopay Building Products Company is the nation’s largest residential garage door manufacturer. We are also the preferred manufacturer and supplier of commercial overhead sectional doors among architects, specifies and building professionals. Providing industry leading customer service and quality combined with a keen market instinct for product innovations delivered healthy sales and earnings growth in 2004.
•Involved in the development/Customization of Reports/XMLP Reports/OBIEE Reports.
•Involved in the development of change Requests as per the requirement of the clients
•Understanding the Clopay Custom Business process
•Involved in translating high-level business requirements into logical business dimensional model.
•Development of RPD using Physical, BMM and Presentation layers of BI Administration Tool.
•Imported physical tables and defined relations between Physical tables at the Physical Layer.
•Created Drill down Hierarchies, Levels and implemented logic by creating Level Based Measures at BMM Layer.
•Utilized Aggregation to improve query performance
•Created Reports using different views
•Worked on iBots using BI Delivers for issuing Alerts and setup a Delivery Profile to email reports to various power users at scheduled intervals.
•Involved in testing of the components to match the exact requirement.
•Involved in functional setups for the objects whenever necessary.
•Involved in creation of alerts/ iBots.
•Responsible for preparing procedures, functions, packages as per requirements.
•Involved in providing continuous support as part of AMS
•Creation of MD070 for the developed objects.
Environment: OBIEE 10.1.3.3, 10.1.3.4, Oracle 10g, MS Excel, Linux, Windows XP, SQL Plus
Clopay, USA.
Clopay OFS Process Implementation
Power-one is one of the world's largest providers of power conversion and power management solutions, Power-One is one of only a few companies with the product breadth to support every step in the refinement of utility-grade AC into the various DC voltages required to power high-availability infrastructure systems at the site, system, and semiconductor levels.
•Involved in the development/Customization of Reports/XMLP Reports.
•Involved in development of PL/SQL Reports
•Involved in the development of change Requests as per the requirement of the clients
•Understanding the Clopay Custom Business process
•Worked on XML Barcode Report
Technologies: Oracle Applications R 11.5.10, XML Publisher, PL/SQL, Oracle Order Management,
Receivables, Payables, MRP, Oracle Reports 10g, Oracle Workflow
passed out in 2008