SUMMARY

• 10+ Years of Professional experience in IT industry including 5+ years of experience as a BI Architect wif a Strong Background in Developing and Implementing BI/Data Warehousing & ETL Projects.
• Experienced in Designing and Building the BI/Datawarehousing Architecture wif Technical prowess over the Entire SDLC.
• Expertise in Developing Business Intelligence Solutions, gathering Business Requirements and implementing them using BI Tools such as OBIEE and Cognos.
• Expertise in building Metadata Repository, Designing Business and Presentation Layers, creating Interactive Dashboards and Reports using Siebel Analytics/OBIEE.
• Extensively worked on Oracle OLAP, Hyperion Essbase creating Oracle Cubes, MDX Cubes and Maintained Analytic Workspaces using Analytic Workspace Manager.
• Experienced in Building Data Warehouses (Star Schema and Snow Flake Schema) from OLTP systems performing ETL using Informatica, Oracle Warehouse Builder and ODI ETL Tools.
• Expert in working wif Datawarehouse Application Console (DAC) Administration and Configuration.
• Extensively worked on BI Admin Tool, BI Answers, BI Dashboards, BI Delivers, BI Server and BI Publisher.
• Adept Knowledge in Query Performance Tuning and Database Tuning.
• Extensive knowledge in various Database platforms such as Oracle, SQL Server and Teradata.
• Expertise in using SQL, TSQL, PL/SQL and MDX Queries.
• Expertise in full implementation of Oracle BI Applications (Finance, Project, HR, Supply Chain and Sales).
• Experience in working wif other BI Tools such as Cognos and Open Source BI Tools Pentaho and Jasper.
• Has Experience working in Industry Sectors such as Insurance, Finance, Healthcare, HR, Banking and Manufacturing.
• Has Lead BI Teams and also handled Projects single handedly.
• Excellent Analytical and Communication Skills.

TECHNICAL SKILLS

Business Intelligence Tools: Siebel Analytics 7.8,OBIEE 10.1.3.x / 11.x Suite, OBI Apps 7.9.5.x/7.9.6.x/11.1.1.x, Analytic Workspace Manager 10.2.0.3, Cognos 8.0 Suite/Report Net, Oracle Map Viewer

Operating System: Windows Server 2003/2008, Unix, Linux

Web Techniques: HTML, XML, CSS, XSLT

ETL Tools: Oracle Warehouse Builder 10.2/11.2, Informatica 9.5/9.0/8.6/8.1 , DAC 10.1.3.4/3.4.1/11 g, UC4, ODI 11g/12c

Databases: Oracle 12c/11g/10g/9i, MS SQL Server 2003/2005/2008 , Teradata, Postgres

Languages: SQL, PL/SQL, T - SQL, C++, Java, Perl, Python

ERP/CRM: Peoplesoft 8.4/9.0/9.1, Oracle EBS 11i/12i, JDE World, Brass Ring, Avectra CRM, AcctVantage, Salesforce CRM, Siebel CRM, Oracle CC&B.

Data Modeling Tools: Sybase, SQL Developer, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential

BI Architect/Manager

Responsibilities:

• Laid out Project plan timelines, Budget Plan and resource plan.
• Held Business gathering sessions wif Business Team across Europe.
• Designed ETL Architecture (JSF Web Application, DAC Command Line, Informatica, Data warehouse) for the projects On Demand Data Load requirement.
• Designed Data Model & ETL design for all Dimensions, Hierarchies and Facts.
• Provided HLD of OBIEE metadata to the development team
• Designed Aggregates, Snapshots, Partitioned tables for performance enhancements.
• Worked on design and development of BI Publisher Templates and Reports.
• Designed OBIEE Data Level Security strategy.
• Lead a development team of 9 members from Onsite.
• Handled the entire project from inception to handover phase.

Environment: OBIEE 11.1.1.7, Informatica 9.0.1, DAC 11g, Oracle 11g, JSF, Apache Tomcat, Linux

Confidential

OBIA Architect

Responsibilities:

• Installed and configured all components of OBIA 11.1.1.7.1 (ODI 11g, OBIEE 11, DAC 11g) HR Analytics on the Clients Linux servers.
• Designed ETL customizations for the Reporting requirements in the Workforce and Requisition subject Areas.
• Designed Data Model Changes and Type 2 extensions to bring in additional Dimensional attributes and Metrics.
• Designed RPD changes, OBIEE Autantication and Authorization strategy.
• Guided development team in the development of OBIEE Reports and Dashboards.
• Documented the installation, customizations and performed KT to the Clients technical team.

Environment: OBIA 11.1.1.7.1 , ODI 11g, DAC 11g, Oracle 11g, EBS R12, Linux

Confidential, MA

OBIA Architect

Responsibilities:

• Performed Map Gap analysis wif OOB Analytics & Functional requirements.
• Built design documents for the development needed identified from the Gap analysis.
• Worked wif the Business to configure Financial, Project, Sales, Procurement & Project Analytics.
• Built the ETL Subject Areas & ran Full and Incremental loads against the Oracle R12 ERP system.
• Fixed ETL issues and bugs related to ETL, RPD & OOB reports.
• Built Custom Informatica Mappings, Workflows and DAC tasks for the customization required.
• Tested the data & formatting of reports & dashboards wif the end business user.
• Built RPD MUD environment to help multi users access the RPD for development.
• Built custom RPD metadata, Reports & Dashboards as per the business requirements.
• Modified existing Data model design of the datawarehouse to build the custom objects.
• Migrated Informatica, RPD & Database codes between environments after development & Testing.
• Performance tuned ETL & Reports by adding appropriate indexes & Hints.
• Built documentation for all custom development wif detailed star schema diagrams.

Environment: OBIEE 11.1.1.7, BI Apps 7.9.6.4, Informatica 9.0.1, DAC 11g, Oracle 11gEBS R12, Linux

Confidential, NY

OBIA Architect

Responsibilities:

• Designed the project SOW & handled resource management.
• Lead offshore team throughout the project.
• Interacted wif business to gather initial configurations for OOB Financial analytics implementation.
• Architected the OBIA environment for implementation.
• Guided offshore team through Installation & Configuration of OBIA suite.
• Performed OOB ETL load & unit tested data.
• Helped fix outstanding ETL & Data issues.
• Customized ETL in accordance to Business needs.
• Built custom reports using Analysis & BI Publisher.
• Configured OBIA suite to use new data source EBS R12.
• Documented & performed KT to the internal resource.

Environment: OBIEE 11.1.1.6.8 , BI Apps 7.9.6.4, Informatica 9.0.1, DAC 11g, Oracle 11gEBS 12R/11R, Linux

Confidential, Kansas City, MO

ETL Lead

Responsibilities:

• Analyzed all OOB & Custom ETL Mappings and modified Mappings to bring the new GL, Calendar changes & Multi currency changes.
• Configured DAC & ETL Mappings for new Currency changes. Modified RPD, created new variables to enable prompting Multi Currency in Reports.
• Created new PRE SQL DAC tasks as part of the existing Execution Plan to accommodate the new Business rules.
• Solved existing data inconsistency issues by tweaking the ETL, RPD & Reports in the Finance, HR and Project Analytics Subject area.
• Created new custom Facts as per requirements and Data modeled them. Created new Informatica ETL, DAC Tasks, RPD changes and Reports for the enhancements.
• Performance tuned ETL & Reports by adding appropriate indexes & Hints.
• Created new Micro ETL DAC Execution plans to load the source for SSAS Cubes.
• Migrated Informatica, DAC and OBIEE metadata up to Prod environments from TEST.
• Documented changes and performed Knowledge transfer.

Environment: OBIEE 11.1.1.5, BI Apps 7.9.6.3, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle 10gEBS 12i, SQL Server 2005, UNIX.

Confidential, Baltimore, MD

BI / ETL Lead

Responsibilities:

• Involved in requirement gathering sessions and designed a part of the data model using Sybase.
• Created technical design pseudo codes for the ETL design.
• Configured Domain files for ETL load.
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Modified and built new Informatica Mappings, Workflows, DAC Tasks and Execution plans for the Custom Data. Customization was of Type 1 and Type 3
• Worked extensively on Production defects to fix ETL, Data & performance issues.
• Worked on the ETL orchestration tool UC4 to design the ETL flow to load the custom Data mart.
• Migrated defect fixes to Stage & production.
• Analyzed BO reports & fixed issues related to the report.
• Created new Materialized views & Logs to facilitate aggregated data for BO & OBIEE reports.
• Maintained all migration & production code using the Team Foundation server tool.
• Created shell scripts to load extract files from the source into stage tables using SQL Loader & external tables.
• Created TCL scripts to build mappings for new ETL in OWB.
• Worked extensively on Performance tuning re writing a number of ETL queries using Oracle hints.

Environment: OBIEE 11.1.1.5, BI Apps 7.9.6.3, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle Db 11gOWB 11g, EBS 11, UC4, TFS, Windows Server 2008, RHE Linux.

Confidential, KY

OBIA Architect

Responsibilities:

• Installed and configured BI Applications 7.9.6.3 (Financial Analytics) which includes OBIEE 11.1.1.5, DAC 10.1.3.4.1 , Informatica 9.0.1 on a RHE Linux 64 bit Server.
• Worked wif the Business to configure all the source and Domain files for the initial Full load.
• Performed initial Vanilla full Load (AP, AR, GL & Profitability) and fixed various issues and Bugs related to DAC & Informatica.
• Performed Unit testing on the Data and customized the ETL, BAW & OBIEE to cater to the Clients Business operations.
• Designed their custom reporting structure and built a small Start schema for their custom Datawarehouse.
• Created new Informatica Mappings, Workflows, DAC Tasks, Subject Areas and Execution plans to load the custom warehouse.
• Built the different layers in RPD and created new Reports and Dashboards to automate their reporting requirements.
• Trained the end users and imparted knowledge transfer to the Clients IT team on the entire BI Apps Architecture.
• Lead an Offshore BI development Team.

Environment: OBIEE 11.1.1.5, BI Apps 7.9.6.3, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle Db 11gPeoplesoft 9.0, Windows Server 2008, RHE Linux.

Confidential, WI

OBIA Architect

Responsibilities:

• Performed a 3 way merge between the new 7.9.6.2 prebuilt RPD, Custom 7.9.5.1 RPD and the Vanilla 7.9.5.1 RPD.
• Took a backup of the old Informatica Repository and imported the new Infa repository and tan moved the custom folder into the new repository.
• Took a backup of the old DAC repository and merged the DAC repositories using the Refresh base option.
• Applied the SQL & TCL scripts provided by oracle to upgrade the Business Analytic Warehouse.
• Merged the Old & new web catalogs to upgrade to the new reports & Dashboards.
• Ran the ETL and Unit tested the Upgrade.
• Migrated all the changes to the Test Environment.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g, BI Apps 7.9.5.1/7.9.6.2 , DAC 10.1.3.4.1 , Informatica 8.6.1RHE Linux.

Confidential

ETL Architect

Responsibilities:

• Fine Tuned the Customized Workforce Profile Subject Area by editing the Custom Dimensions and Hierarchies at the Report, RPD & Database level.
• Experimented and applied Performance Tuning efforts (Aggregate Tables, Materialized Views, Table Partitioning, SGA sizing, and Indexing).
• Configured Authorization at the Report Level by using the PSROLES Peoplesoft Table and implementing the Peoplesoft Roles at the OBIEE Level using a RPD Initialization block.
• Met the Business and gathered all the custom requirements for the Compensation Subject Area.
• Configured the Source Files, Informatica Workflows, DAC Tasks and Execution plans to run the Vanilla Compensation Subject Area.
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Modified and built new Informatica Mappings, Workflows, DAC Tasks and Execution plans for the Custom Data. Customization was of Type 1 and Type 3.
• Customized the RPD to add the New Logical Dimensional Columns and Fact Table.
• Designed the architecture Model to bring in Data from Brass Ring (Recruitment 3rd Party Tool) into the Analytic Warehouse.
• Built New Informatica Mappings to load Data from Mainframe CSV Files into replica tables in the Database. Built New DAC Tasks, Imported Source and Target Tables and assembled the Subject Area. Built a New Execution Plan by configuring the Data sources. Customization was of Type 2.
• Built Custom Informatica ETL logic to bring the Incremental Recruitment Data into the Universal Adapter format.
• Activated the Universal Adapter Subject Area in DAC to Load the Recruitment Data.
• Unit Tested the BAW and tested the Data in the Warehouse using SQL scripts.
• Modified the RPD at the Physical, Business and Presentation layers to accommodate the custom Dimensions and Facts.
• Built New Reports and Dashboards using BI Answers apart from modifying the Vanilla Dashboards to analyze the Metrics using the custom Hierarchies.
• Documented every step across the SDLC and trained internal folks on the operations of OBI Apps.

Environment: OBIEE 10.1.3.4, OBI Apps 7.9.6.1, Informatica 8.6, DAC 10.1.3.4, Windows ServerLinux, Oracle 10g, PeopleSoft 8.4.

Confidential

OBIEE Lead

Responsibilities:

• Met the Business Users to Understand the Mortgage Data and identify the Data Sources for Several Business Targets and Thresholds.
• Created a New Project using OBIEE Multi User Development Environment.
• Built the Physical, Business and Presentation Layers from Scratch.
• Created Aliases and Physical Joins in the Physical Layer.
• Built Logical Tables, Complex Joins, Dimensions, Hierarchies & Aggregation for Measures.
• Created Time Series Measures, Rolling Measures and Level Based Measures in the BMM Layer.
• Created Repository and Session Variables in the RPD.
• Built Reports and Dashboards in BI Answers and set up Object Level Security.
• Created Chart, Table, Pivot Table and Narrative View Reports.
• Built Prompts, Guided Navigation and Links in Dashboard’s.
• Installed and Configured Oracle Map Viewer wif OC4J.
• Used Oracle Spatial Data to build the underlying Tables for Map Report.
• Created Tiles, Layers, Maps and Legends using Mapbuilder Client Tool.
• Coded Java Script in Map Viewer to Pass Prompt Values into the Map report.
• Performed Unit & Regression Testing on all the Reports and Fixed Bugs.
• Created CSS to be reused in Reports and Dashboard Pages.
• Built PL/SQL Functions and called them using Evaluate Functions in Answers.
• Conducted Performance Testing and solved potential Bottlenecks.

Environment: OBIEE 10.1.3.4, Windows Server 2003, Informatica 8.6.1, Oracle 10g, Oracle Map