PROFESSIONAL PROFILE:

• IT professional with 10+ years’ experience, with specific focus on end - to-end Business Intelligence solutions for mid-sized and large corporations. Expert in data warehouse, ETL and front-end report and dashboard development. Has a proven track record of designing, developing, and maintaining business intelligence solutions with Oracle EBS as well as rapidly implementing prebuilt business intelligence applications leveraging functional expertise in financials, supply chain, project management, procurement, human resources, sales and marketing. Have good understanding of EBS applications, table structure and data flow.
• 6+ Years of experience in designing, developing and delivering complex BI Analytical applications using OBIEE. Well versed with OBIEE RPD Modeling includes Physical layer, BMM layer, Presentation Layer, Dimension Hierarchies, Level based measures, Security Implementation (Authentication, Data Level and Object Level Authorization, Initialization blocks, User Management), Performance Management (Caching, Implementing Aggregates).
• 6+ Years of experience in designing, developing, customizing and delivering complex BI Analytical applications data warehouse. Extensively worked on multiple data warehousing tool like Informatica and ODI.
• 3+ Year of experience as a Scrum Mater, leading the team to follow process and organize deliverables.
• Implemented various versions of OBIA 10g and 11g, as well as custom BI solution. For multiple data sources like, EBS, PeopleSoft, Seibel. For multiple modules like, Financials, Supply Chain and Order Management, Procurement and Spend, HR, etc.
• Well experienced in designing and building custom data warehouse using ETL tools like Informatica, OWB and ODI.
• Expertise in configuring multiple modules for OBI through DAC and BIACM and enable ETL process.
• Well experienced in performing OBIA Suite installation on servers involving OS patches, WebLogic, OBIEE, ODI, Fusion Middleware patches, BI Applications.
• Expertise in performing and optimizing loads by applying various techniques in the load process through Informatica/ODI and at data base.
• Strong experience in consulting the full lifecycle of BI project efforts includes designing and leading technology roadmap using various BI tools, understanding the business objectives and develop solution to meet requirements, well versed with data warehousing methodologies, standards and industry best practices
• Strong experience in leading and participate in evaluating requirements, interface with the senior business and technology leadership and work with a team of business analyst to break down and translate the business requirements to solutions
• Expertise in analyzing information and reporting business requirements, explore and evaluate various options, develop prototype using reporting and dashboard tools upfront in the project life cycle thereby validating the requirements, eliminating ambiguity and providing early visibility to business on the final solution.
• Expertise in designing guideline, conducting workshops, user s with business on how to leverage ad-hoc reporting environment to access critical data to support their business decision
• Expertise in setting up BI processes, designing business friendly functional documentation, technical documents.
• Expertise in managing and driving end to end large DW/BI transitions engagements, that includes designing of transition hand off technical documents, understanding of current implementation with respect to technology and functionality, conducting workshop with business, technical team to address issues or gaps, plan pre go live and post go live activities includes shadow and steady support requirements, defining SLA, support processes and conduct sessions for reverse knowledge transfer to support team in multivendor environment.
• Experienced in coding PL/SQL packages, functions, procedures, views, and triggers.
• Experienced in managing BI product engineering, build engineering, build validation, data quality and enabling technical supports for latest releases and hot fixes addressing large client base across the globe.
• A keen strategist, with excellent communication, negotiation and presentation skills, effective in developing and leveraging relationship to achieve business objectives proactively
• Well versed with various BI delivery models Waterfall, WBS, & AGILE.
• Easily adaptive to latest Oracle Technologies and fast learner.

TECHNOLOGY SKILLS SUMMARY:

• OBIEE 10.x,11.x,12.x, BI Publisher (RPD, Web, Dashboards, Publisher, Delivers, iBots)
• OBIA 11g, OBIA 7.9.6.X (Financial Analytics, Supply Chain and Order Management Analytics, Project Analytics, Human Resource Analytics and Procurement and Spend Analytics)
• ODI, Informatica 9.x, 8.1 (PowerCenter) OLAP, LDAP
• Oracle 8.x/8i/9i/10g/11g
• SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x
• C, C++, Java, JSP, EJB, HTML, PHP, XML, Perl, UML, Ajax, FrontPage
• Windows 95/98/NT/2000, Linux, Unix
• Photoshop CS, Macromedia Flash, Adobe Dreamweaver
• EBS 11/12g, PeopleSoft 9.2, Tagetik
• Kanban, Jira

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

OBIA Technical Team Lead/ Scrum Master

Responsibilities:

• Responsible for assisting Confidential with the Oracle Business Intelligence (BI) technical development, integration, build and test of the reimplementation through go-live.
• Oracle Business Intelligence application development to build or modify objects including:
• OBIA 11.1.1.10.1 and above (Financial Analytics, Project Analytics, HR Analytics) Installation, Configuration, and Customization
• Weblogic 10.3.6
• Weblogic 12.2.1.1 and above
• ODI 11.1.1.9 and above
• Rebuilt all customizations that were in Informatica in the old system to ODI and In corporate them with the existing OBIA system.
• Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll)
• Custom Oracle ODI Load Plans from:
• Maximo 7.6.06 and above
• Tagetik 5.2.0 and above or similar planning application
• OBIEE 12.2.1.1 and above (RPD and Dashboard Development)
• BI Publisher 12.2.1.1 and above
• Oracle Database 12.2.0.1 and above
• Collaboration with and support of the Functional Module Leads designs and supporting the technical team analysis, design, development and implementation of Oracle BI custom functionality.
• Responsibility for identification, documentation, and reporting of technical project Issues/risks to Reporting Lead and Project Team to determine the appropriate response strategy.
• Responsibility for ensuring clear Functional Design Documentation (FDD) and to ensure the Functional Team understands the solution boundaries and risks.
• Responsibility for ensuring clear Technical Design Documentation (TDD) and to ensure the Technical Team understands the solution boundaries and risks.
• Partnering with the other technical and functional resources to ensure custom solutions are sound.
• Ensuring best practices are used for custom development to maintain a high quality product.
• Running scrum in an Agile environment. Preparing spirits for the deliverables of the Project based on the priorities using Jira.
• Guiding and the Development team on self-organizing and updating tickets on a timely manner, so that the blocker can be addressed soon for timely delivery and the success of the Project.
• Scheduling meeting to address issue, blockers and show progress to the end-users to get feedbacks.
• Creating a list of all the requirements along with the cross impacted teams to track the delivery (with dates) internally which can help us get an exact status on the release any time.
• Capture the notes and follow up items from all the JADs and work with Product / other team to discuss the gaps if any.
• Ensuring consistent use of standardized processes and forms to manage project documentation, including but not limited to: Functional Design Documents, Technical Design Documents, Change Controls, Risk Registers, Work Packages and other project documents as needed.
• Working with Confidential Enterprise Financial Operations Re-engineering (EFOR) Reporting Lead and Confidential IT team members (regarding as is state) to mitigate risks and resolve issues throughout implementation as needed.
• Completion of tasks in an efficient and timely manner while keeping project stakeholders informed.
• Achieved great success as an application developer for Oracle BI Implementations using best practices.

Confidential, Malvern, PA

Sr System and Environment Administrator/ Technical Consultant /Scrum Master

Responsibilities:

• Ensuring enterprise applications are running effectively always, which includes continuous monitoring and ensuring every reasonable effort is made to restore service as quickly as possible in the event of an outage.
• Understanding business and technical requirements and develop a solution to meet those requirements. Create detailed design documents and associated solutions built around ORACLE WebLogic, BI, Data warehousing and other potential solutions. With solid understanding of Networking, Security, and Enterprise Management.
• Engaging and collaborating regularly with infrastructure, systems, security, and quality assurance teams to provide status updates and work on both tactical and strategic plans.
• Managing multiple environments (DEV, SAT, CAT, PROD) effectively and account for differences in each environment.
• Ensuring that infrastructure systems are designed, implemented, and supported to meet customer’s internal and external standards and service level requirements.
• Performing testing, tuning, and configuration of Middleware products including WebLogic, Oracle BI, EDQ, Data warehousing, Oracle Identity Manager, Oracle Access Management, ID Vault etc.
• Developing and maintaining configuration documentation, diagrams, SOPS, materials and other supporting documentation.
• JVM and memory management, tuning, diagnostics and configuration
• Monitoring tools and techniques for Weblogic, BI, Informatica, EDQ services. Support, troubleshoot, and resolve Middleware and related infrastructure issues
• Ensuring adherence to configuration and operating best practices and standards.
• Implementing Continuous Integration (CI), Continuous Delivery and Deployments(CD)
• Automate various FMW services like stop admin services, node manager, bi components etc., through Windows scripting.
• Implement SSO configuration with WNA Kerberos on multi domain architecture.
• Performing upgrades to support continuous improvement in functionalities.
• Maintain SRF migration, setup employee positions, work on business services, configuration, link, LOVs, eScripts, Join and Business component, in an Agile development environment.
• Running scrums to keep track on the tickets with issues/enhancements/work orders to facilitate the Project success using multiple tools Kanban (Prod), Jira (Dev/Test) and Service Now (Work Orders).
• Making sure a Scrum team lives by the values and practices of Scrum
• Help team with removal of impediments, not over-committing, complacency, capacity planning, continuous delivery and to continuous improvements.
• Regular meetings with Product and Design to get a peep at their future requirements. Which will enable me to plan the order of items to the backlog and provide the prioritized order to BSA to groom the stories.
• Shift rotation planning for production support and on line availability.
• Interact with Oracle’s Technology Account Manager for resizing the Oracle products for future technology upgrades.
• Participate in software selection processes which include analyzing the technology components of solutions and gathering input from external suppliers, Institutional System administrators and other key stakeholders. Ensure that the selected solution is aligned with the enterprise and Information Technology technical standards and strategies.
• Participate in internal audit and applications security operations to define solution architectures that support the required controls for SOX compliance applications

Sr OBIA Technical Consultant

Confidential, Baltimore, MD

Responsibilities:

• Configured Oracle BI Apps 11.1.1.10.1 using BI Apps Configuration Manager, (BIACM).
• Customized ODI Interfaces to accommodate customized requirement.
• Performed data loads for Financials and Procurement and Spend Analytics, loading data from multiple data sources.
• Involved in performance tuning to improve data loads.
• Setup Dev and Prod environments
• Migrated contents from one environment to another.

Sr ODI Technical Consultant

Confidential, Newport Beach, CA

Responsibilities:

• Configured Oracle BI Apps 11.1.1.10.1 using BI Apps Configuration Manager, (BIACM).
• Customized ODI Interfaces to accommodate customized requirement.
• Architect data warehouse design for custom ETP module.
• Developed custom ODI interfaces to extract data from ETP source, transforming data to associate it with the Financial data that is extracted from PeopleSoft data source and load into the data warehouse.
• Develop data extracts from the data warehouse environment using ODI. Developed packages, scenarios using interfaces and variables.
• Ran and optimized loads for Financial Analytics.
• Developed strategic custom load plan to run the interfaces developed for custom ETP module.
• Setup TEST environment.
• Migrated BI configuration and ODI contents from one environment to another on regular bases after the fixed made based on the testing.
• Provided ODI to client side ETL developer.
• Developed design, process documents.

Sr Technical Consultant

Confidential, Seattle, WA

Responsibilities:

• Customized ODI out-of-box mappings based on Informatica customizations lineage document.
• Configured OBIA through BIACM for all the three modules and for multiple data sources, based on the user requirements.
• Designed, configured, performed and optimized loads to load data from multiple data sources.
• Setup multiple environments for Development (2) and Testing (6).
• Migrated BI analytics configuration from environment to another.
• Migrated ODI content from environment to another.
• Provided support to client side ETL developers and users.

Sr Lead Technical Consultant

Confidential, Santa Monica, CA

Responsibilities:

• Installed and setup OBIA 11g (OS patches, WebLogic, OBIEE, ODI, Fusion Middleware patches, BI Applications) complete suite for DEV, UAT and PROD environment servers.
• Configured Financial analytics through BIACM.
• Configured and performed loads to load data.

Sr Lead Technical Consultant

Confidential, Eagan, MN

Responsibilities:

• Designed and deployed OBIA Apps 11g Financials Analytics suite against SAP B/W, Oracle 11g data sources using Oracle ODIEE 11g suite.
• Architected and delivered scalable enterprise custom data warehouse using Oracle ODIEE 11g database and Shell / PL/SQL scripting and oracle data integration tools.
• Led performance optimization efforts to support the conversion of large historical data sets. Enabled DOP, partitions to support asynchronous real-time reporting.
• Design ODIEE 11g custom IKM - knowledge module to transform the data at the speed-of-light and defined processes to validate the integrity of the data.
• Deployed load plans / job scheduling to support multi-source data feeds and created rules to support alerts, notifications, exceptions, and error handling.
• Designed Unique INFA IMCMD Shell scripts to integrate SAP B/W with ODIEE 11g packages to execute SDE piece of ELT process.
• Have created PL/SQL packages and procedures to load data for Time Dimension tables
• Managed the production deployment, planning, transition, and support of delivery / release processes to operationalize the systems.
• Designed and executed high availability HA SIT tests plans and led disaster recovery and restore / reinstate processes to support BCP milestones.

Confidential, King of Prussia, PA

Sr Lead Technical Consultant

Responsibilities:

• Installed OBIA 11.1.1.8.1 which includes
• Installing Oracle OS Packages
• Installing Oracle database
• Creating Database contents
• Installing OBIEE 11.1.1.7.0 and upgrade it to 11.1.1.7.1 by applying required packages
• Installing OBIA 11.1.1.8.1 Applications

Sr Lead Technical Consultant

Confidential

Responsibilities:

• Installed OBIEE 11.1.1.7.0 and implemented Insight Accelerator reports.
• Upgraded OBIEE to 11.1.1.7.1 and installed OBIA 11.1.1.7.1.
• Configured Financial, HR, Procurement and Spend and Project applications.
• Installed OBIA 11.1.1.8.1
• Configured Financial, HR, Procurement and Spend and Project applications.
• Gathered Business requirements.
• Configured applications based on the business requirements.
• Ran initial, full and incremental ETL loads.
• Validated the reports by running reports in EBS and compared the results with the BI reports.
• Tested and validated the reports by debugging the underlying query.
• Monitored and administered system setup and configuration.

Sr Technical Consultant

Confidential

Responsibilities:

• Complex reports creation
• Scheduling reports
• Cache seeding the reports
• Exposing new columns in OBIEE cloud environment

Sr Lead Technical Consultant

Confidential

Responsibilities:

• Upgraded OBIA 7.9.6.3(including OBIEE 10g, Informatica 8.1 and DAC 7.9.6.2) to OBIA 7.9.6.4(OBI 11g, Informatica 9.1, DAC 10.1.3.4.1 and OBIA 7.9.6.4).
• Upgraded DAC, Informatica and OBIEE contents.
• Installed Noetix view generator and Noetix rpd and reports generator tool.
• Upgraded Noetix database views, metadata and reports.
• Configured OBI 11g, Informatica 9.1, DAC 10.1.3.4.1 and OBIA 7.9.6.4.
• Configured Financial, Procurement and Spend, Supply Chain and Order management and HR analytics by gathering information from EBS.
• Configured and ran ETL loads
• Architected and implemented new security model based on the business requirement.
• Implemented role based security both at catalog and rpd level based on user input.
• Trained user extensively on OBIEE, ETL management and Informatica.

Business Intelligence and Informatica Consultant

Confidential

Responsibilities:

• Configured and Implemented pre-build Financial analytics on their existing EBS system to provide an analytical view of the data with a wide variety of reports.
• Configured Financial analytics based on Financial information gathered from EBS.
• Compiled and ran full and incremental loads.
• Tested the data within the reports with EBS and fixed the reports if any differences found by debugging through ETL mappings, data warehouse and BI model.

Business Intelligence and Informatica Consultant

Confidential

Responsibilities:

• Supported their existing OBIA implementation
• Have worked on pre-built report fixing by debugging through the reports, rpd metadata, ETL and database queries.

Lead ETL Consultant

Confidential

Responsibilities:

• Architected and developed ETL solutions to build a warehouse, with data coming from huge data source with a lot of manipulation and calculations happening every day to keep track of the Sales up to date on a daily bases and to analyze their business.
• Architected the ETL solution to do full and incremental loads.
• Have successfully designed, deployed and evolved ETL solutions to meet business requirements.
• Developed and designed data models and data processing and transformation rules for proper data representation.
• Provided expertise in architecture of Informatica platform for very large and complex data.
• Defined best practices, incremental load architecture for transaction level and summary level facts.
• Provide expertise in performance tuning of Informatica mapping and sessions
• Lead team of Informatica developers
• Did unit and integration testing of the data loaded in the warehouse.

Business Intelligence Consultant

Confidential

Responsibilities:

• Installed, configured, and maintained OBIEE 11g on a Linux-64 bit environment.
• Helped to develop a reporting and security solution that involved gathering requirements, ETL modifications, Data Warehouse development, Data Modeling in the OBIEE repository and OBI report development.
• Installed OBIEE 11.1.1.5 on Linux.
• Advised the IT department on best practices involving OBI architecture and configuration.
• Implemented a security solution.
• Built custom solution for OBIEE using Banner’s ODS as a source. The solution included reports for the grants, finance, and HR modules.

Business Intelligence and ETL Consultant and Technical Team Lead

Confidential

Responsibilities:

• Lead the installation and implementation of Oracle Business Intelligence with Oracle Financial Analytics, Oracle HR Analytics and Oracle Project Analytics.
• Installed and configured OBI 11g, Informatica 9.1, DAC 10.1.3.4.1 and OBIA 7.9.6.3 on AIX.
• Captured and document requirements for OBIA configuration.
• Led and performed the configuration of Oracle Financial Analytics, HR Analytics and Project Analytics.
• Customized Oracle Financial Analytics (Reports, RPD and Informatica mappings) to support multi-segment account dependencies (i.e. support for cost centers).
• Designed and developed complex Informatica mappings, sessions, workflows and identify areas of optimizations.
• Customized Oracle Financial Analytics and Project Analytics (Reports, RPD and Informatica) to support unique customer requirements.
• Analyzed and addressed reporting issues in OBI, Informatica and the data warehouse.
• Trained IT resources scheduling and executing data warehoused loads, debugging reports and migrating OBIA components across environments.
• Designed a solution to support multiple currencies in Financial Analytics.

Lead Business Intelligence and Informatica Consultant

Confidential

Responsibilities:

• Implemented OBI with Oracle Financial Analytics and Procurement and Spend analytics.
• Also developed over 50 custom reports based of Oracle EBS views and the OBIA data warehouse.
• Extended the OBIA data warehouse and modified the Informatica ETL.
• Provided ongoing support and enhancements to ETL development and associated Data Warehouse processes.
• Analyzed routine business problems and requirements to provide technical support (coding, testing, implementation, and maintenance) for the ETL (Extract Transform and Load) and associated Data Warehouse processes required to run Data Warehouse products.
• Customized Oracle Financial Analytics (Reports, RPD and Informatica) to support multi-segment account dependencies (i.e. support for cost centers).
• Documented and communicated findings through written documents and models to stakeholders.

Lead Business Intelligence and Informatica Consultant

Confidential

Responsibilities:

• Participated in custom data warehouse and ETL development, configuration of OBIA and custom report development.
• Supported BI 10g test and production environments.
• Developed ETL mapping to load data from data source to a custom data warehouse.
• Scheduled the mapping to load data daily.
• Developed repository (RPD) and reports based on custom data warehouse tables.
• Configured execution plans in DAC for Financial analytics and ran several full and incremental loads.
• Scheduled incremental loads for Financial Analytics.
• Developed a sophisticated Weekly Sales Executive custom report built on top of views based of OLTP data, which is a higher level report that loads a large amount of analytical information.
• Migrated OBIA components across environments.
• Upgraded Informatica to version 9, OBI to 11.1.1.6.0 , and OBIA to 7.9.6.4.
• Continuous support