SUMMARY

• 7+ years of experience in OBIEE/BI Publisher reporting.
• Hands on experience in R Programming, statistical analysis of data.
• Good knowdlege on Internet of Things (IoT), Big Data systems and Cyber security.
• Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist.
• Experience in OBIEE 11.1.1.6, 10.1.3.4, Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x, Oracle EPM 11.1.2.1 which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots (ETL Informatica, ODI, Reporting - Siebel Analytics, Scheduling-DAC).
• Strong knowledge in installing and configuring OBIEE 11.1.1.6 with Weblogic, OBIA Financial, HR, Sales Modules.
• Installed and configured Oracle EPM Suite including HFM, Planning and Essbase.
• Experience in understanding transactional data modeling (OLTP) and working in OLAP data model design.
• Efficient in analyzing business requirements and designing/creating Subject Area, designing Star Schema/Snowflake Schema methodologies, creating dimension hierarchies and level-based measures and adding disparate sources.
• Strong knowledge in configuring Data level and Object level security and Multi-User Development Environment (MUDE).
• Experience in Developing reports using column selector, dashboard prompts, drill down reports and using time-series functions and Guided Navigation.
• Designed Informatica mappings to extract the data from various sources.
• Tuned mappings, procedures and SQL scripts by creating indexes and partitioning when doing complex data loads for better performance .
• Worked with transformations such as Lookup, Expression, Router, Source Qualifier, Union etc to apply the business logic and loaded data into the target schema.
• Responsible for error handling using Session Logs in the Workflow Monitor.
• Implemented ad-hoc techniques to achieve business needs.
• Involved in data visualtization reporting using Tableau.
• Created deployment groups and deployed the code from Development to Test and Production repositories.
• Contact point for defects in ETL team and Monitored the maintenance release.
• Provided production support and monitor daily load process.
• Used DAC(Datawarehosue Administration Console) to create Task Groups, modify Source System parameters, create Execution plans and scheduling.
• Experience in Unit, Regression, Performance and User acceptance testing methodologies.
• Experience in BI suite - using integration services (SSIS) for ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design.
• Experience in extraction, transformation and loading (ETL) of data flows using SSIS with complex integration of SQL Server, Oracle.
• Strong in Analysis and collecting business requirements from Business Analysts and users.
• Team player and an individual contributor with steep learning curve and good interpersonal skills.

TECHNICAL SKILLS

OBIEE Infrastructure: OBIEE 11.1.1.7, OBIEE11.1.1.5, 10.1.3.4, BI Publisher.

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financial analytics, HR Analytics, Sales).

Reporting and Visualization Tool: Tableau

ETL and Scheduling Tools: ODI 11.1.1.6,11.1.1.5, Informatica 9.0, 7.1.4, DAC 10.1.3.4.1 .

Languages and Web Technologies: SQL, PL/SQL, Java, XML, HTML/XHTML, VBScript, .Net.

ERP and Applications Servers: Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle WebLogicServer 10.3.5.

RDBMS: Oracle11g/10g, MS-Access, SQL-Server 2008.

Tools and Utilities: SQL*Loader, TOAD.

Operating Systems: Windows XP/ 2000/2003/2008 R2, Windows Server 2008 R2, Sun Solaris 5.8, Oracle Enterprise Linux 5.7, Red RHEL 5.0.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

OBIEE Developer

Responsibilities:

• Participate in BI/DW business requirements and user stories review sessions
• Participate in BI/DW functional and technical design sessions
• Work with Business Analysts to create prototypes for BI solutions
• Create technical specifications in accordance with business requirements documentation
• Review technical specs with remote developers
• Coordinate the development tasks with in-house developers
• Coordinate the testing tasks with in-house QA Analysts and onsite Business Analysts
• Conduct quality reviews on offshore development deliverable's
• Understand the underlying data sources (databases) and interpret requirements provided by the business to analyze operational issues and develop appropriate diagnostic and/or tracking data via reports and dashboards.
• Provide hands-on technical expertise in OBIEE upgrades, OBIEE repository changes and report changes.
• Hands on experience in developing BIPublisher reports which also included developing RTF templates, Develop Excel based templates, and conditional formatting using xml tags.
• Drive the Production support team with required install plans and steps necessary.
• Availability during weekends as and when required for the production installs.
• Gathered and documented requirements for new reports and changes to existing reports, extraction or collection of data for performing queries and writing reports, and developing and analyzing operational performance metrics and reports to ensure the quality and integrity of extracts though the use of validation and audit strategies.
• Participate ina major OBIEE megre strategy with the data and BI architects.

Environment: OBIEE 11.1.1.7, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

Confidential, Newport Beach, CA

OBIEE CONSULTANT

Responsibilities:

• Gathered Business Requirements and documented using Oracle’s process Templates like MD50’s etc.
• Develop financial reports for the client at different Business Units of the organization.
• Troubleshoot Performance related issues.
• Work with RPD in modifying the objects for performance improvements and also for rewuirement changes.
• Develop front end reports with multiple functionality like Drill Down, Drill Across, Guided Navigation, Action Links, Master detail reports.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Define ODI data transformation rules and determine most appropriate method for processing (extract-based, load-based, or dbms-based).
• Prepare detailed data mapping documentation for ODI Interfaces from Source to Target.
• Develop Conceptual, Logical and Physical Data Models using SQL DataModeller.
• Setup the ODI Topology with different Technologies and created the Data Servers and Physical Schemas.
• Developed ODI Packages with interfaces using different Knowledge modules like RKM, LKM, IKM and JKMs.
• Created Aggregate and loopup ODI interfaces which can be used in the main interface.
• Created Load plans by setting up email alerts and created ODI Scenarios and scheduled them for Full and Incremental Loads.
• Use SQL Tuning to improve performance.
• Work with Excel Workbooks for data extraction to the datawarehouse.

Environment: OBIEE 11.1.1.6, Oracle Peoplesoft 8.9, ODI 11.1.1.6, Oracle 11g, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

Confidential, Westlake Village, CA

OBIEE / BI DEVELOPER

Responsibilities:

• Gathered Business Requirements and documented using Oracle’s process Templates like MD50’s etc.
• Help answer questions associated with the design of the status quo application, its features, and its capabilities.
• Helped refine and determine feasibility, correctness, and completeness of end-user’s requirements.
• Participated in the scope definition meetings.
• Performed data analysis on the sources (Oracle EBS).
• Experience in Installing and Configuring OBIA Financial Analytics.
• Configured Physical layer, Business Model Layer and Presentation Layer of the Repository.
• Renamed the components as per business terminology.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Translated BI requirements into analytic BI subject areas.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Utilized OBI reporting features (Navigational, Drill Down, Drill Across, Guided Navigation, Security etc).
• Installed, configured Oracle EPM Suite including HFM, Planning and Essbase.
• Migrated Applications and Data from Prod to Non Prod instances. created scripts to take Level 0 Data Exports and LCM Exports for Application Backups.
• Ensure Production environment stability and provide continued support.
• Provide assistance to the business for annual budget and forecast processes. performed all month-end/year-end close processes needed in the system to report timely and accurate financial statements, forecasts and budgets.
• Applied required Application patches using OPATCH to fix Application related bugs.
• Modified the Informatica Mappings according to the user requirements.
• Created Custom mappings in Informatica for Security development in OBIEE.
• Configured the Data warehouse Administration Console to run the custom execution plans and scheduled the weekly runs in DAC.
• Built dashboards according to the Business requirement with necessary prompts, drill downs and Hyperlinks in the reports.

Environment: OBIEE 11.1.1.6, OBIEE Financial Analytics 7.9.6.3, Oracle Peoplesoft 8.9, Informatica 9.0, DAC 10.1.3.4.1, Oracle 11g, Oracle EPM 11.1.2.1, Oracle Enterprise Linux 5.7, Windows Server 2008 R2, Windows XP.

Confidential, Charlotte, NC

SOFTWARE DEVELOPER

Responsibilities:

• Worked as a Developer in SQL Server Reporting Services.
• Designed and developed a full-scale reporting solution using MS SQL Server 2008 and MS SSRS 2008.
• Proficient in ETL (Extract - Transform - Load) using SQL Server Integration Services 2005 / 2008 (SSIS).
• Strong SSRS development skills, experience including Tablix, Matrix, chart, and graphic score card reports, sub-reports.
• Hands-on experience in design and development of ETL solutions for data warehouses and data marts, using different architecture, design techniques.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extracted data from different sources including Oracle, Flat Files.
• Hands-on experience in Performance tuning, Query Optimization and Indexing of database using SQL Profiler and Query Analyzer.

Environment: SQL Server 2000/2005/2008, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), C#, .Net, Windows 2008/2008 R2, XML, MS Excel, MS Access, MS visual Studio.

Confidential

OBIEE DEVELOPER / ADMINISTRATOR

Responsibilities:

• Configured OBIEE Security Model, Siebel Security Model in BI Publisher reports and made them available for Siebel users accessing OBIEE Dashboards.
• Extensively worked on RPD, dashboards, IBots, Answers & Prompts.
• Created BI Publisher reports and made them available on OBIEE Dashboards.
• Worked on creating RTF templates, Layouts, Parameters for BI Publisher reports.
• Installed and configured BI-Office, integrated it with OBIEE Web Catalog, and made the OBIEE reports and charts accessible in Confidential Excel and Power Point.
• Gathered Business Requirements and documented using Oracle’s process Templates.
• GAP analysis between the existing reports and OBIEE.
• Configured Physical layer, Business Model Layer and Presentation Layer of the repository.
• Renamed the components as per business terminology.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• 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.
• Implemented MUD (Multi User Development) Environment.
• Implemented Security & Cache features to accommodate business requirements.
• Moving and merging the repository.
• Created several SDE’s and SIL’s Mappings for Siebel as source.
• Configuration of the DAC Server and the DAC client.
• ETL refresh performance improvement.
• Analyze and fix the problems reported by the users.
• Coding, testing and supporting to users for UAT.
• Carry out Quality Assurance activities for all deliverables.

Environment: OBIEE 10.1.3.2, Informatica 7.1.4, Oracle 9i, TOAD, UNIX, Windows XP.