SUMARRY:

• Profile: Architect/Senior OBIEE Consultant
• Oracle BI Certified Specialist having 17 - year experience in Oracle Enterprise Technologies.
• 5+ Years’ experience in Oracle Business Intelligence Edition (OBIEE) 11g/10g, Oracle BI Applications (OBIA) 11.x/7.9.x, Oracle E-Business Suite (EBS) R12/11i, and Oracle development tools.
• Led and successfully completed large BI project implementation and major upgrades
• Expertise in implementation, customizations and extensions of Financials, Supply Chain and Order Management, Procurement and Spend Analytics
• Extensive experience in business analytics warehouse design, Informatica ETL and OBIEE repository customizations.
• Extensive experience in Oracle Data Integrator (ODI) and Oracle GoldenGate 11.x/12.x.
• Highly proficient in creating reports and dashboards in the environment of Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/10g.
• Played key role in implementation and customization of financials, Project Accounting, Fixed Assets, supply chain and procurement modules of Oracle E-Business Suite.
• Extensive experience in Oracle E-Business Suite implementation, upgrade, extensions, customizations, migration, interfacing and conversion with emphasis to Application Object Library (FND), General Ledger (GL), Project Accounting (PA), Fixed Assets(FA), Project Management(PM),Payables (AP),Receivable (AR), Purchasing (PO), Inventory (INV).
• Vast experience of developing applications using Oracle Developer Suite 10g/6i and registering with E-Business Suite R12/11i
• Extensive experience in building and registering custom reports with E-Business Suite 11i/R12 and modifying standard reports utilizing Oracle Reports as per management and user requirements
• Experienced in integrating third party applications with Oracle E-Business Suite R12/11i
• Involved in requirement analysis, technical design, development, implementation, testing, post-production support, application customizations and upgrades
• Extensively involved in forms customizations using Custom library, report generation using Oracle Reports and BI Publisher, creating extensions/interfaces with Oracle E-Business suite R12/11i

TECHNICAL SKILLS:

Business Intelligence: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/10g, Oracle BI Applications 11.x/7.9.x (Financials Analytics, Supply Chain and Order Management Analytics, Procurement and Spend Analytics, Projects Analytics, HR Analytics), Oracle BI Administration Tool, Data Warehouse Administration Console (DAC), Informatica PowerCenter 9.x/8.x, Oracle BI/XML Publisher 10g/5.6.3, Oracle Discoverer 10g

Enterprise Applications: Oracle E-Business Suite R12/11i: Financials (GL, AP, AR, FA, CE), Project Accounting (PA), Fixed Assets (FA), Project Management (PM), Purchasing (PO), Inventory (INV).

Java IDE & Framework: Oracle JDeveloper 10g, Oracle Application Framework (OAF)

Databases: Oracle Database 11g/10g/9i/8i/8.x/7.x

Middleware: WebLogic 10.x, Oracle Application Server 10g/9i, and Oracle Enterprise Manager 10g/9i

Languages: Java, PL/SQL, XML, SQL, HTML

Development Tools / Environments: Oracle Forms 10g/9i/6i/6/5/4.5, Oracle Reports 10g/9i/6i/6/3.0/2.5, Oracle Workflow, Toad for Oracle 11.0/9.7, Oracle SQL Developer, PL/SQL Developer 6, SQL*Plus, AllFusion ERwin Data Modeler 4.1, ERwin/ERX 3.5/3.0/1.2, Visio, Microsoft Project

Utilities: SQL*Loader, impdp, expdp, Telnet, PuTTY, FileZilla, CoreFTP

Operating Systems: Oracle Enterprise Linux 6/5, Sun Solaris 10/9/8, Red Hat Enterprise Linux 6/5/4, Windows Server 2008/2003

PROFESSIONAL EXPERIENCE

Confidential

Oracle BI Technical Specialist/Architect

Responsibilities:

• Implemented Oracle Projects and Financial Analytics
• Completed setups and configurations of Procurement and Spend Analytics
• Prepared project plan and worked on extensions and customizations of Fixed Assets and Project Accounting.
• Prepared project plan and built custom dashboards for MR Enhancements to provide unified view of Financials, Procurement, Supply Chain and other analytics to a large number of front line managers
• Worked on prototype of Executive Dashboard to provide Key Performance Indicators (KPIs) to senior executives
• Assembled subject areas for various analytics and built execution plan for full and incremental load
• Loaded data into business analytics warehouse using DAC from E-Business Suite 12.1.3 and PeopleSoft 8.9.
• Diagnosed data load issues of Project Accounting, Fixed Assets, Financials,, and Procurement and Spend Analytics using DAC log and Informatica Workflow Monitor.
• Resolved data load issues utilizing Data Warehouse Administration Console (DAC) and Informatica client tools (Designer, Workflow Manager and Repository Manager)
• Developed several dashboards related to Financials, Supply Chain and Procurement.
• Used PowerCenter Designer to build mappings that extracted data from various sources and loaded to targets, transforming as necessary.
• Used PowerCenter transformations to cleanse, format, join, aggregate and route data to the appropriate targets
• Performed error handling/trapping using PowerCenter mappings
• Used PowerCenter Workflow Manager to build and run workflows
• Designed and built complex mappings and workflows based on business needs.
• Performed advanced troubleshooting using PowerCenter logs and debugger.
• Customized the Physical, Business Model and Mapping, and Presentation layers of OBIEE repository.
• Created dimension hierarchies and level-based measures.
• Modeled aggregate tables to speed up processing.
• Modeled partitions and fragments to improve application performance and usability.
• Used variables to streamline administrative tasks and dynamically modify metadata content.
• Used time series functions to support historical time comparison analyses.
• Used bridge tables to resolve many-to-many relationships between dimension and fact tables.
• Used helper tables to maintain team-based hierarchical relationships in a dimension table.
• Configured Oracle BI to support multilingual environments.
• Used implicit fact columns to select fact tables for dimension only queries.
• Completed a number of Oracle EBS tasks that were required for BI projects

Confidential

Senior Software Analyst

Responsibilities:

• Analyze software & configuration requirements & articulate specifications.
• Query data using SQL*Plus from multiple relational databases & data warehouse.
• Create use case strategies, and when necessary, help to create test strategies.
• Producing technical feasibility studies.
• Providing security consultancy & best practice for securing Oracle platforms.
• Conducting product overview presentations.
• Deploying complex systems for department.
• Solution development and technical consultancy across a broad technology spectrum.
• Developing application forms, reports, menus Using Oracle Forms 10g as development language and Oracle 10g report as a report tool.
• Designing and developing a system use cases and business use cases implementing RUP methodology.
• Programming Oracle 10g PL/SQL stored procedures, packages and triggers.

Technical Environment: SQL Server 2005, Visual Studio 2005, C#.NET, Windows XP, Alberta Energy Framework, .Net framework 2, VSS Source control and Visual Intercept for Quality Control.

Confidential

Architect

Responsibilities:

• Responsible for the full software life cycle design and development of a system logistics transportation system.
• Building database schemas and schema objects to be used in front end development.
• Building Forms & reports using oracle developer suite 10g and database packages for processing billing and invoices issuing
• Designing & building Managerial reports that illustrate all business operations in well descriptive figures.
• Programming Oracle 10g PL/SQL stored procedures, packages and triggers.
• Supervising oracle forms Developers team consists of 2 for building application functions
• Operates all running software & hardware systems to run fine
• Managing crisis situations, which may involve complex technical hardware or software problems
• Technical Environment: Oracle Developer suite 10g, Oracle Database Enterprise server 10g,Windows, Oracle .Net Component, oracle Designer 10g, Windows 2003 Enterprise, Windows XP, Oracle Grid, Quest Tools, SQL Navigator, Crystal Reports, etc.

Confidential

Team Lead/Senior Software Engineer

Responsibilities:

• Meeting customers, Preparing requirement
• Leading development team of (7) developers to build applications (Forms, Reports, Menus) using RAD Tools Using Oracle developer 2000, 6i, 9i.
• Designing ERD (Entity Relationship Diagram) defining how objects are related to each other using Oracle Designer 2000,6i,9i
• Generating SMD (Server Model Diagram) using Oracle Designer 2000, 6i, 9i.
• Designing Flowcharts, process Model Diagrams using Oracle Designer 2000, 6i.
• Creating primary objects (tables, views, indexes ) once the application design is finished
• Modifying the database structure, as necessary, from information given by application developers using Oracle RDBMS 8i, 9i, 10g.
• Developing application forms, reports, menus Using Oracle developer 2000, 6i, 9i.
• Coding Sophisticated PL/SQL Packages to generate end of the year transactions.
• Tuning PL/SQL Code, Performance follows up.
• Building Oracle discover schemas for Financial & Sales data manipulating and flexible information extraction
• Supervised the upgrading financial version from V2 to V3, V3 Built on Oracle 10g Forms, Reports implemented using Oracle 10g Database

Technical Environment: Oracle Database 8,8i,9i,10g Oracle Application Server, Oracle discover 3,4,6i,Bussiness intelligence suite 10g,Oracle Designer 2000, Red Hat Linux 3,4, Solaris Unix, Developer 2000,6i,PL/SQL, Windows 2000 Server, Windows 98,2000, Quest Tools, etc.