Data Developer
Resume:
Summary:
Over ** years of overall IT experience in Business intelligence with SSIS/SSRS, OBIEE (Siebel Analytics), BI Publisher, BIAPPS (OBIA), DAC, Informatica, ODI, BIACM, FSM.
* ***** ** ******ence in OBIA. Completed five full OBIEE / OBIA Implementations with Extensive experience in Analysis, Design, Development, Data conversion, Data Modelling in various domains Manufacturing, Financial, Retail, Supply Chain, Procurement & Spend and HR Analytics.
Good understanding of source applications like E–business suite, Siebel CRM and Legacy Applications & implemented Incremental vs. Full load mechanisms and have Ability to design and develop Ad hoc Reports and dashboards using OBIEE.
Worked on SSIS/SSRS, Business Intelligence Applications (OBIA) Customizations for Oracle EBS R12 GL, AP, AR, OM & Procurement Modules using BIAPPS 7.9.6.4, BIAPPS 11.1.8.1 and ODI (Oracle Data Integrator)
Good Understanding in customizing Informatica mappings & ODI Interfaces sourcing data heterogeneous data sources and perform Data Conversion, Cleansing & Validation.
Experienced in configuring DAC, BIACM for executing, scheduling and monitoring various ETL tasks (Execution plans), Index management strategies and Database statistical updates for efficient query performance.
Experienced in designing Star Schema/ Snowflake Schema methodologies, Data security & Object level security, scheduling and configuring iBots / Agents to deliver analytics content based on schedule for OBIEE Reporting.
Extensively worked on Performance tuning strategies by tuning the rpd for OBIEE to generate efficient queries.
Extensively used Catalog Manager for webcatalog migrations and Administered webcatalog upgrades.
Strong experience with oracle Database in writing SQL, PL/SQL Procedures, Functions, Cursors, Triggers and Packages, Materialized view.
Managing the entire Oracle BI environments, including Installation, Configuration, Upgrades and build deployments on OBIEE & OBIA.
Business Requirements gathering, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
Technical Skills:
ETL
OracleDataIntegrator11.1.1.6/12c, Informatica 9.1/8.6.1/8.5.1/7.1.4, SSIS/SSRS
DATA MODELLING
Dimensional Data Modelling, Star Schema, Snow-Flake Modelling,
FACT and Dimensions Tables, Physical and Logical Data Modelling
DATABASES
Oracle 11g/10g/9i, MS SQL Server7.0/2000, MS Access, Sybase,
DB2, MySQL, Teradata V2R6, JD Edwards
PROGRAMMING
SQL, PL/SQL, HTML, UNIX, JAVA
REPORTING TOOLS
OBIEE 12c, 11G,10G, Business Objects XIR2, Tableau 10.3, Power BI, SSRS
Cognos, Crystal Report, BI Publisher, OBIA 7.x, Siebel Analytics 7.x
OPERATING SYSTEMS
Windows 98/NT/2000/XP/7, MAC, UNIX
ACADEMIC QUALIFICATIONS:
Bachelor of Technology in Engineering - 2007
Jawaharlal Nehru Technological University (JNTU), India
Professional Experience:
Panasonic Avionics, Lake Forest CA Jan ‘18 – Till date
ETL/ BI Developer
Develop a customized mapping on BIAPPS analytics and standalone environment for the combined source data from multiple source systems, data validation, analytic reports and Dashboard development.
Responsibilities:
Worked on different ODI Knowledge modules for extracting, Integrating and Loading data in data warehouse from heterogeneous data sources by creating data servers, data stores, Interfaces, Knowledge Modules (KM), Scenarios, Load plans in Oracle Data Integrator (ODI).
Worked on OBIEE RPD and Involved in testing after Upgrading the RPD and performed Unit testing of OBIEE Reports in 12C after initial data loads
Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and validating repository level calculations done in the business model layer.
Environment: OBIEE 12c / 11.1.1.7.1, BI APPS 7.9.6.4, Oracle Data Visualizer, Oracle EBS 11/R12.1.1, Oracle 11g, MS SQL Server7.0/2000, SSIS/SSRS, Informatica 9.6, Oracle data integrator 11g/ 12c, Oracle BI Publisher, Tableau, Power BI.
TOYOTA, Erlanger KY Jan ‘15 – Jan’18
ETL/ BI Developer
Worked on different BI projects to implement a reporting solution for Manufacturing Analysis. Develop reports and Dashboards using the Finance, Online Payment and Vehicle Buy off Systems Created new ad-hoc subject areas for Reports on Power BI.
Responsibilities:
Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting.
Implemented Oracle data integrator static control for data cleansing, data validation, data transformation for the data in designer’s model folder.
Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
Configured the LDAP Authentication for OBIEE using Fusion Middleware and implemented data and object level security based on the business requirements through External table.
Implemented data and object level security based on the business requirements through External table authentication.
Built test cases and tested the Repository/Reports by comparing the SQL Output on the Data warehouse to the values in the Reports and documented the test results.
Environment: Microsoft Power BI, OBIEE 11.1.1.7.1/ 12c, BI APPS 7.9.6.4, Oracle EBS R12.1.1, Oracle 11g, Informatica 9.1, MS SQL Server7.0/2000, SSIS/SSRS, Oracle data integrator 11.1.1.6, DAC, TOAD, Oracle BI Publisher, Softerra LDAP Browser 4.5.
JDSU, Milpitas CA Mar ‘14 – Jan’15
ETL/ BI Developer
JDSU is a Networking Optical Fiber Company, and this is a Supply chain Management Project, as a Cost Reduction on the Item (Raw material) they spend. The objective of the project is to implement a reporting solution for the Managers on Spend and Percentage of Cost Reduction.
Responsibilities:
Implemented current reporting outputs using SalesForce.com and EDW data delivered through the OBIEE 11.1.7.1 Dashboard and reporting capabilities.
Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
Complicated reports have been developed using multiple views like Pivot, View Selector, Chart View and Gauges and ensured pleasant User Experience and proper delivery of major requirements, minor details, and intuitive OBIEE User Interface.
Working closely with Business Users, Team and gathering the requirements from different user groups for Migrating Current BRIO Reports into OBIEE 11G
Implemented Cache management to handle performance issue in report generation.
Executed OBIEE administrative tasks such as OBIEE RPD, Webcatalog migration & Caching strategies
Good Understanding of BI Publisher reports and using various templates to publish the reports as per user requirements.
Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.4, MS SQL Server7.0/2000, Oracle EBS R12.1.1, Oracle 11g, Oracle data integrator 11.1.1.6, DAC, TOAD, Oracle BI Publisher
UnitedHealth Group, Gaithersburg, MD Jan ‘13 – Mar ‘14
ETL/ BI Developer
The objective of the project is to implement a reporting solution for Progressive HR analytics. Develop the HR reports like Workforce, Promotions, Terminations, Turnover rate. Progressive HR Analytics testing Project involves the Testing Methodology for the OBIEE Dashboards. Testing Strategy involves UI Testing, Functional testing, Data Validation and Performance Testing.
Responsibilities:
Involved in overall SDLC lifecycle of the project in all stages right from the Analysis, requirement gathering, IVSC SDM design, development & reporting requirements.
Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
Responsible for conducting interviews with stakeholders to gather requirements, perform data analysis to design ODI interfaces from multiple source systems.
Developed packages by using ODI interfaces, procedures, variables alongside working on all three layers of the OBIEE repository to facilitate end user reporting
Developed reports, dashboards, standard filters and prompts.
Created and scheduled IBOT’s for delivering personalized reports to users.
Worked on implementing automatic cache purging after monthly data load completion by using Event pooling table.
Tested UI testing, Functional testing, Data Validation testing and Performance testing.
Implemented and developed the migration plan for moving the repository and webcatalog from DEV to UAT and PROD.
Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.4, Oracle EBS R12.1.1, Oracle 11g, Oracle data integrator 11.1.1.6, DAC, TOAD, Oracle BI Publisher.
BHAGYAM LOGICIEL LTD, London, UK Jan’09 - Jan’13
ETL/ BI Developer
Responsibilities:
Worked with Business Users, Involved in Discussing and Gathering the Analytics requirements from different user groups.
Requirement analysis Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
Installed and configured the OBIEE 10.1.3.2 on servers and dealt with the installation issues.
Designed and Developed OBI Repository at three layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (create presentation catalog), create presentation folders, test and validate the model.
Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales using inbuilt functions and expressions.
Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
Environment: OBIEE 11.1.1.7.1, BI APPS 7.9.6.3, Oracle EBS R12.1.1, Oracle 11g, Informatica 8.6.1, DAC, TOAD, Oracle BI Publisher
Proteron InfoTech Ltd, Bangalore, India Jan ’07 – Nov ’08
ETL/ BI Developer
Responsibilities:
Involved in the design phase of logical and physical data model using Erwin.
Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Centre.
Used simple to moderately complex debugging techniques to test ETL applications.
Developed Test Cases for testing the ETL mappings.
Conducted code reviews and lead design reviews to assure compliance.
Involved in migration of ETL code from Development environment to QA environment and finally to Production environment.
Worked along with the QA team in order to determine the data validation and preformed the data validating at the source and the target database level.
Environment: Informatica Power Centre 7.1, Oracle 9i, Windows 2000, flat files, Erwin,
OBIEE 10.1.3.3.3
Contact this candidate