PROFESSIONAL OVERVIEW

• 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 Oracle E-Business Suite Applications 10.7SC/11i/R12, Data Warehousing, and Oracle Business Intelligence. As a Certified Oracle Certified Professional, my experience spreads across design, development, testing, implementation, Troubleshooting, Debugging. 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. On most of my recent engagements I have concurrently been responsible for developing, designing standards, design patterns and other design artifacts which serve as the foundation for translating organizational strategy into actionable technology solutions that drive operational excellence while enabling synergistic growth and organizational scale. 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. My background in Air Traffic Control is my witness to prove that I am stress proofed and have strong orientation to detail in defining moments.
• 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 SUMMARY

• ERP: Oracle Financials R12/11i/11.3/10.7sc AP, FA, GL, AR,
• Oracle BI EE: Oracle BI Admin Tool, Answers Analysis , Dashboard, BI Publisher, and Delivers.
• Oracle BIA: Financial 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

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Reports Developer

I was in the Enterprise Business Reporting Team on implementing Oracle Business Intelligence Enterprise Edition OBIEE for CMS DECC contract that is over 300.00 mil in design / development / consolidation program to improve health care quality for Medicare Medicaid Beneficiaries.

Responsibilities,

• Gathered OBIEE and BI Publisher 10g/11g implementation, configuration and support skills, gained from implementing projects on client sites
• Developed BI Publisher report templates with advanced customizations using XSL, XSLT, XHTML and XPATH
• 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
• Environment: Microsoft Windows XP, OBIEE 11.1.1.5, OBIEE 11g Database, Hadoop, BI Publisher 11g, Toad, Solaris 10 Servers, SQL Developer, Putty, dashboards

Confidential

Senior OBIEE Developer

Confidential is one of the most established corporations in Confidential. The requirement of the client was to deliver a business solution to the Finance users to provide insight into the financial reporting. Our initial project was to offer a demonstration of OBIEE capabilities using internal data from different sources that custom designed dashboards.

Responsibilities,

• Involved in requirement gathering from user through meetings, understanding the business from end user and technical perspective.
• Built prototype reports from excel spreadsheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Built parameter page using image prompts that enables users to visually select the input parameters.
• Created groups in the repository and added user to the groups and granted privileges explicitly through group inheritance.
• Enabled Single Sign On for OBIEE to allow authorized users to login automatically to OBIEE without entering user credentials.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Created custom CSS classes and styles, java scripts and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.
• Environment: Oracle Business Intelligence 10.1.3.4, 11.1.1.5 Informatica , Oracle 11g, Oracle SQL developer, Toad, UNIX.

Confidential

Senior Consultant Global Public Sector

In this position I was responsible for leading the Enterprise Business Reporting Team on implementing Oracle Business Intelligence Enterprise Edition OBIEE , OBIA/OBAW Federal Financial Analytics for a Federal Agency called Worked as a Senior BI consultant for Veterans Benefits Administration VBA , Department of Veterans Affairs in Washington D.C. In this role I was tasked with managing the project scope, budget, and championing the go forward campaign.

Responsibilities,

• Acted in a lead role primarily supporting the requests from VR E and also requests from other business areas on a need basis.
• Helped veterans with service-connected disabilities prepare for, find, and keep suitable jobs. For veterans with service-connected disabilities so severe that they cannot immediately consider work, VR E offers services to improve their ability to live as independently as possible.
• Did requirement analysis to understand the business needs and provide system solutions to achieve the cost/time/quality objectives of the project.
• Fine tuned of SQL and PL/SQL programs.
• 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.
• Implemented Object level security and data level security.
• Training business users.

Environment: OBIEE 10.1.3.4, 11.1.1.5, Oracle BI Apps 7.9.5/7.9.6, DAC, BI Publisher, Siebel CRM, Informatica 7.x, Oracle 10g, Windows

Confidential

Senior OBIEE Developer

Confidential manages Medicare and Medicaid in all states. Reporting to the Vice President of Information Technology my functions included strategizing, planning, architecting, designing, developing and administrating OBIEE repository and dashboards, corporate data warehouse and data marts over multiple project lifecycles from requirements gathering through production support. I functioned as a lead architect, advisor and developer on multiple OBIEE and data warehouse projects.

Responsibilities,

• Developed OBIEE Repository per user requirements and available information in DW.
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager. Version 8.6
• Extensively used OBIEE Admin tool to import the required objects Dimensions and Facts with integrity constraints into Physical Layer using connection pool
• Developed multiple Dimensions Drill-Down Hierarchies and Logical and Facts / Measures objects in Business Model Layer, and has successfully created the Presentation catalogs in Presentation Layer.
• Developed Dashboards such as Default Dashboard for the users when after login directed to a default dashboard based on the department they work
• Successfully developed row based calculations in a pivot table for the reports based on sales RPD.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE answers to build the query.
• Had developed chart and tabular reports for the total sales for Quarterly, half-yearly and annually using global and local filters.
• Scheduled iBots and seeded server cache using Delivers to improve system performance.
• Developed iBots such as Purge to clear server cache using nqcmd utility and had developed Scheduled reports to be e-mailed using iBots.
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Have used Administration Tool configure Multiuser Development Environment MUDE for multiple users for the development environment.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.
• Environment: OBIEE 10.1.3.x, Netezza, Oracle 10g, SQL, Oracle SQL developer, data stage, Linux.

Confidential

OBIEE Developer/E-Business Suites Specialist

This was an Applications operations and Development support for Covance two Oracle E-Business Suite 11i/R12 applications instances running AP, PO, FA, GL AND HR modules, and OBIEE-OBIA

Responsibilities,

• Obtain business requirements from functional managers and from users through interviews and operation observations
• Review the technical and functional environment and compare to OBIEE capabilities
• Make recommendations Design mapping strategies for data in liaison with technical personnel
• Build repositories from scratch, perform business modeling and mapping, create security profiles, create variables, send for testing, deploy to OBIEE Presentation Services
• Create drillable/guided navigation reports based on business requirements, create dashboards, iBots, prompts, and set permissions
• Create performance reports by to be reviewed by executives for the worldwide firm, by management at local regional and set security to localized regions
• Create iBots for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist management with timely decision making
• Format reports, including embedding web-based communications according to business requirements
• Test and modify OBIEE security for the internal controls environment
• Take client calls on XBRL issues and perform research and resolution
• Pull the US GAAP taxonomy using the Row set in R12 Oracle Financials' Financial Statement Generator FSG to prepare for the XBRL taxonomy build
• Perform XBRL tagging of financial statements including taxonomy build and consolidation
• Manually modify .xml language files in order to meet SEC Edgar filing manual requirements
• Advise clients on custom/extension taxonomy for purposes of accomplishing consistent tagging
• Environment: OBIEE 10.1.3.4, 11.1.1.5, Oracle BI Apps 7.9.5/7.9.6, DAC, BI Publisher, Siebel CRM, Informatica 7.x, Oracle 10g, Windows

Confidential OBIEE Consultant/Lead Developer

Confidential was implemented for mortgage division to track different kinds of key performance for indicators for their mortgage lending group. The data mart also helped evaluate credit risk with the customer and also finds new sales opportunities based on the customer's needs.

Responsibilities,

• Interviewed process owners, and discussed with functional managers to determine business requirements
• Discussed OBIEE deliverable options with management and created documentation procedures based on the AIM methodology: BP30 determine requirements , RD50 gather requirements , BR10 gaps , MD50 functional design
• Provided suggestions of implementation for various processes
• Determined plan of implementation based on functional area/departmental requirements
• Converted business requirements into data maps and schemas for technical implementation
• Participated in implementations and created connection pools and imported data from databases
• Structured the physical joins, creating Alias Tables, snow flake schemas and star schemas
• Modeled data in the BMM, including calculation based derivatives, time series modeling, dimensional hierarchies, aggregation
• Created users and groups, filtered some columns and tables, then instituted time-based access limitations to given groups for security
• Performed cosmetic formatting with the Utilities function and used system variables Created performance critical alerts for client satisfaction data as part of the Development Life Cycle
• To mitigate performance issues created additional connection pools, removed calculation functions in the presentation layer and restated them in the more efficient BMM
• Managed caching in the NQS config
• Appointed the Data Modeling Specialist because of my understanding of business models
• Presented the end products to the client in non-technical business language.

Environment: OBIEE 10.1.3.4, BI Publisher, Siebel CRM, Informatica 7.x, Oracle 10g, Windows