SUMMARY:

• I am a seasoned senior IT leader with 10+ Years of experience in providing cost effective IT solutions leveraging my Enterprise Architecture (EA) expertise to align IT with business Strategy through the use of EA frameworks such as TOGAF, FEAF, and DODAF; and through extending my expertise in Oracle E - Business Suite Applications 10.7SC/11i/R12, Data Warehousing, and Oracle Business Intelligence. My experience spreads across Implementations, Version upgrades, data conversions, customization of Oracle Financials applications, and overall IT Service Management.
• I have extensive exposure in writing successful project proposals for Oracle E-Business Suite implementations Request for Proposals and Enterprise Data warehousing (EDW)/Business Intelligence (BI) implementation for Federal government and private sector projects.
• In keeping alignment between business and IT my focus has been on managing in-house and client’s Oracle EBS and BI enhancements and conversion projects, collaborating with the Project Management Office (PMO) team to keep projects’ triple constraints (scope, time, and cost) within bounds.
• On the technology end I have extensive exposure to a host of technologies but my emphasis has mainly been around Oracle technologies where I have had hands-on exposure leveraging Oracle’s Applications Implementation Methodology (AIM) and Oracle Unified Method (OUM) for adherence to best practice on capturing Functional and Technical requirements and design using documents like BR100, MD050, MD070, CV040, RD140, RD45, DS45, etc. Leveraging Oracle’s OUM to achieve the vision of supporting the entire Enterprise IT Lifecycle through managing, envisioning, and Implementation of solutions building blocks and architecture building blocks. A truly collaborative and focused individual that has successful experience in the development and education of peers, superiors and subordinates through thought leadership, innovative practices and industry best practices that is well grounded in practical experience. I possess solid and proven communication and interpersonal skills which I utilize as the foundation to effectively lead and negotiate with many diverse professionals to achieve desired business results.

TECHNICAL SKILLS:

ERP: Oracle Financials R12/11i/11.3/10.7sc (AP, FA, GL, AR, CE, AOL), OAB& HR.Oracle Manufacturing11i (PO, INV, MRP/ASCP, OM, BOM, WIP)

Oracle BI EE: Oracle BI Admin Tool, Answers (Analysis), Dashboard, BI Publisher, and Delivers.

Oracle BIA: Financial Analytics, SCM and Order Management Analytics, and HR Analytics.

Databases: Oracle 11g/10g/9i/8i/8/7.x, Teradata 12, MySQL, MS SQL Server 6.5/7.0/2000

Oracle Tools: SQL*PLUS, SQL*Loader, Forms/Reports6i, Oracle FSG, JDeveloper, APEX3.2

Languages: SQL, PL/SQL, XML (XSLT, XPATH, XQUERY), Java

ETL: Informatica 7.9.5/8.6.1, Oracle Warehouse builder 10.2

Platform: HP-UNIX, Solaris-UNIX, Linux, Windows Server, and Novell 4.x

Version Control Tools: PVCS, Clear Case, HP Application Lifecycle Management

IDE: TOAD7.6/9.5,Oracle SQL Developer, Hyperion 9.3, OBIEE10g/11g, and OBIA 7.9.x

UML Tools: Visual Paradigm, Borland Together 6.2, MS VISIO 2000/2003, Sparx 9 System Architect

Project Management: Plainview, SharePoint, AIM3.0/1, OUM5.5, PMBOK, COBIT

Tools: /Methodologies: Ms Project

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Sr OBIEE Developer

Responsibilities:

• Acted in a lead role primarily supporting the requests from VR&E and also requests from other business areas on a need basis.
• Did requirement analysis to understand the business needs and provide system solutions to achieve the cost/time/quality objectives of the project.
• Used Oracle Designer data modeling tool to do conceptual/logical/physical data models.
• Designed jobs to read data from several Oracle source databases and flat files and load data into Data Warehouse using Informatica.
• Developed solutions for operational reports using OBIEE Answers/Dashboard. Involved in code review, code migration to both test and production environments.
• Prepared end to end documentation like Requirements document, Data Dictionary and Detail Technical Specification document, Test plan document and Deployment document.
• Configured OBIEE Repository (Physical, business and presentation layer) to provide Analytical Reporting solutions to business.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• •Used several OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, and Security.etc).
• Analyzed requirements, implemented prebuilt business intelligence solutions using the Oracle Business Intelligence Analytics platform
• Identified granularity level of the Financial data required to be available for analysis.
• Worked extensively on OBIEE Answers to create the Financial Statement reports and Intelligence Dashboards (Financials) as per the detailed design requirements
• Extensively used page prompts and dashboard prompts for filtering data values in financial reports
• Created drill down charts and drill down tables to gather more information on Financial Analytics and Supply Chain using navigation
• Used LDAP Server for Security Authentication.
• Created security settings to setup groups, query privileges and access privileges
• Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Created reports with PDF, RTF and Excel templates using the BI Publisher.
• Delivers (Ibots) are created and scheduled.
• Performance tuning on the Dashboards and Answers.
• Worked extensively to customize DAC (Execution Plans, Subject areas, Task Definitions and Tables) for OBIEE Financial Analytics.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the Adhoc report according to the client needs.
• Successfully configured OBIEE EBS for oracle BI Applications.
• Configured the Extract date, Global Currencies, Exchange Rate Types, and Fiscal Calendar.
• Performed the necessary impact analysis in upgrading the OAS to Oracle WebLogic 11g environments as far as the web server technologies are concerned—thereby, ensuring that present functionality exists for all the CPMS applications.
• Performed the configuration of the OAS and WebLogic 11g servers, including the server and client-based secure socket layer (SSL) configurations using X509 and CAC-based authentication.
• Created any new Windows Server-based OBIEE or Oracle BI Publisher Suite environment based on customer priorities.
• Tested new enhancements and changes as a part of our OBIEE test bed environment
• Designed and Documented Requirements for DIUCS v.3 as needed.
• Implemented Oracle Database and Middle-Tier Changes to Accommodate DIUCS v3
• Worked with DBA resources to support Database Replication across Servers.

Sr OBIEE Developer

Responsibilities:

• Developed BI Publisher report templates with advanced customizations using XSL, XSLT, XHTML and XPATH
• Gathered OBIEE and BI Publisher 10g/11g implementation, configuration and support skills, gained from implementing projects on client sites
• Experience extending BI Publisher to have report templates invoke Java classes
• Configured the OBIEE BI Repository (RPD) at the physical, business model and presentation layers to meet business requirements
• Configured OBIEE Dashboards, Analyses, Prompts and other Presentation Services elements to meet business requirements
• Configured OBIEE, WebLogic and Fusion Middleware to support integration with LDAP directory servers
• Performed advanced customization of OBIEE UI to create highly customized look and feel, including customization of CCS, XML, Javascript and HTML for the OBIEE UI
• Integrated OBIEE or BI Publisher with Oracle UCM (e.g., using RIDC API to store PDF outputs in UCM)
• Integrated OBIEE or BI Publisher with Oracle WebCenter, either through Spaces or custom ADF workflow
• Integrated OBIEE with Oracle BPM via EJBs using the Action Framework
• Used Oracle Data Mining and Oracle R to create predictive modeling reports in OBIEE

OBIEE Lead

Responsibilities:

• Reviewing and updating the data lineage document, RD080 - the Master report listing, and rebuilding the project's WBS and WBS dictionary to realign project tasks with available resources, scope review recommendations, and approved change requests. Reviewed the baseline architecture for conformance to the Federal Enterprise Architecture Framework, to keep solutions in line with the overall Federal Enterprise Architecture as prescribed by FEAF requirements.
• Designing mappings for reporting from Oracle Loans (LNS) to migrate Loan origination and servicing from the legacy systems into LNS and migrate reporting to OBIEE. Making recommendations to management on issues that require expertise and areas that needs attention to save on BI investment.
• Designing enhanced Data warehouse model, designing ETL(using Informatica 8.6.1) processes to extract data from a legacy Loan origination and management system called APPX, Oracle Loans, Oracle Receivables, Oracle risk Management, Oracle Payables, and Oracle General Ledger.
• Developed Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator. Mapped Oracle general ledger natural accounts to group account numbers. Added columns to existing dimension tables in the Oracle Business Analytics Warehouse (OBAW) and populated them with data

Senior Oracle Applications Developer

Responsibilities:

• Design, develop and maintaining Hyperion reporting across Hyperion Interactive Reporting, Web Analysis, SmartView and Financial Reporting.
• OBIEE-BIP development and support for the client. Configuring EBS-BIP bursting for reports in Oracle EBS 11.5.10.2.
• Oracle E-Business support with Forms personalizations, CUSTOM.pll mods, Reports, and XML Publisher templates.
• SQL tuning for reports running slow and PL/SQL packages using SQLTXPLAIN, TKPROF, EXPLAIN plan, applying indexing and HINTS.
• Developed a PL/SQL package to upload data to a custom table, refreshing some materialized views from the PL/SQL package using a Hyperion report query.
• Created Hyperion .oce files, Data Models, and Reports using Hyperion Interactive Reporting Studio.
• OBIEE - Implementation Fit GAP analysis to compare the existing Business Intelligence and Reporting Tools to assess the gaps with what OBIEE offers. Documenting OBIEE implementation infrastructural requirements including hardware and environmental prerequisites.
• Designing ETL Data Flow Mappings using OWB for data integration preparing a data warehouse creating mapping from source systems to Data warehouse targets from Oracle R12 EBS applications database and several other data sources.
• Testing and debugging Mappings using mapping debugger is embedded in the OWB Mapping Editor.
• Deploying Objects in the Target Warehouse deployed the external tables, the dimensions, the cube, and ETL mappings.
• Created Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalize and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Created Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Control).
• Installed OBIEE platform on Linux, BI applications onto OBIEE platform for Release 12 (Financials, Procurement, Supply Chain, and HR), Informatica, and DAC.
• Restored out of the box Informatica Repository and DAC Repository. Performed extensions and customizations to the RPD, Reports and Dashboards
• Customized data models and designed additional Subject Areas to support extensions. Extensive performance tuning with data volume, table partitions, fragmentation and Caching concepts within OBIEE
• Training and mentor support to OBIEE Developers, and end-users.
• Used the Data Warehouse Administration Console (DAC) to configure, manage, and load the Oracle Business Analytics Warehouse.

Oracle Developer

Responsibilities:

• Conducted a High-Level Gap Analysis for 11i/R12 upgrade that is projected to be started early 2010.
• Developed GL daily conversion rates SQL*LOADER program and a PL/SQL package to validate daily forex conversion rates and upload rates into the GL Daily Rates Interface; along with MD50/MD70.
• Created a new set of books defining value sets, Accounting Flexfield Structure, segments, Flexfield qualifiers, Security rules, cross-validation, accounting Calendar, and responsibilities associated with the set of books and the MO: operating unit. Oracle Application Express (APEX3.2): developing forms and Reports on 10g.
• Configured Oracle Payables - Financial options, Payables options, Internal and external banks, payment programs, created Distribution Sets, and Payment Terms; along with an AIM BR100 document.
• Configured Oracle Assets- Defined assets corporate books, tax books, asset key Flexfield, category Key Flexfield, and location Flexfield. Defined Prorate Calendar and conventions, setting up Asset Book Controls, Asset Categories, Fiscal Years, Calendars, System Controls, and depreciation methods.
• Converted standard AR customer invoice report and print statement reports into xml templates in BI publisher and developed xml bursting control files for these reports to be emailed directly to customers print the ones for customers without emails in our system, and archiving copies of these documents in SharePoint.
• Customized several standard oracle reports6i (Pick Slip Report, Proforma Invoice, Sales Order Acknowledgement, Invoice Print Selected Invoice) and developed custom reports we later converted into XML templates.
• Oracle Application Server 10g- implemented and configured application server for OBIEE (oc4j and HTTP Server). Implemented Noetix Generator for OBIEE automatically creating the Enterprise Information Model for our Oracle E-Business Suite.
• Time series modeling and dimensional hierarchy Modeling, created calculated logical columns.
• Integrating with Oracle BI EE Delivers Alerts-modifying instanceconfig.xml and credentialstore.xml
• Integrated Oracle-BIEE with Oracle E-Business Suite 11i&R12 to enable Single Sign-On through Oracle E-Business suite application using existing user accounts.
• Migrated Oracle Business Intelligence Discoverer (Discoverer) metadata to Oracle Business Intelligence Suite Enterprise Edition (Oracle BI EE), using the Oracle Discoverer Metadata Conversion Assistant.
• Exported Discoverer End User Layer (EUL) to create an .eex file by using Discoverer Administrator.
• Used MigrateEul.exe file for the migration and MigrationConfig.properties file to control the migration behavior (helps with maintaining joins and recovering joins dropped during migration).
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables.)
• Setting up a Multi-User Development Environment (MUDE).
• Built time and calculated measures for a fact table and created dimension hierarchies and level -based measures

Confidential

Oracle Applications

Responsibilities:

• Manage a team of contractor Oracle developers, some onsite and some offshore in India.
• Gathering, refining, and documentation of the business rules, functional and technical requirements.
• Performed Fit GAP analysis and prepared solution presentation for review.
• Performed functional testing for existing modules to understand existing business process, created documents to understand functional requirements for interfaces.
• Leading assigned projects providing project planning and administration, issue resolution, monitoring project progress to plan, and obtaining and distributing project status.
• Interfacing with management on all Oracle EBS project related issues, changes, reporting and impacts ensuring that comprehensive information is provided to all stakeholders in a timely manner.
• Managed changes to project scope, requirements, design, resources, functionality and risk. Performing various administrative tasks as directed.
• Manage Oracle Applications Systems Administration Security, Profiles, Concurrent Managers, Printers, Responsibilities, Menus, Functions, and registering the new objects in Oracle applications.
• Performed a pilot on OBIEE, and later lead the OBIEE implementation with OBIA Analytics for financials, Procurement, and HR.
• Install and configure OBIEE 10.1.3.3 on Linux.
• Restored out of the box Informatica Repository and DAC Repository for Financials and Procurement.
• ETL-Configured Informatica Repository and integration Services; created users in Informatica Admin Console and used client tools to customize OOTB ETL mappings, workflows, transformations and DAC.
• Configured Oracle Business Intelligence Applications for Financial Analytics for Oracle EBS and other custom Source Systems. Used DAC to configure the list and types of Ledgers (R12)/set of books (11i) from which to extract the GL data.
• Customized repository (.rpd), in the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using OBI Admin tool. Configured the NQSCONFIG.INI file for Usage Tracking using direct insertion.
• Developed various Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables.). Setting up a Multi-User Development Environment (MUDE).
• Created BI Publisher Reports based on various data source (BI Answers / BI Server Subject Area / Web Services/ HTTP Data Set / File Data Set.).Built time and calculated measures for a fact table and created dimension hierarchies and level-based measures.
• Used DAC to configure domain values for Oracle Receivables and Payables Analytics.
• Configured Transaction Types for Oracle General Ledger and Profitability Analytics for Oracle EBS R12.
• Used UNIX shell programming for Converting FTP scripts into NDM scripts and writing new scripts for oracle job scheduling and file transfer automation.