Summary

10+ Years of Professional experience in IT industry including 8 years of expertise as a BI Developer/Architect with a Strong Background in Developing and Implementing BI/Data Warehousing & ETL Projects using OBIEE & Major ETL Tools.

• Experienced in Designing and Building the BI/Datawarehousing Architecture with 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 and Oracle Warehouse Builder.
• Expertin working with Datawarehouse Application Console (DAC) Administration and Configuration.
• Extensivelyworked on BI Answers, BI Dashboards, BI Delivers, BI Server and BI Publisher.
• Expertisein Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Guided navigation Properties.
• Worked Extensively in Creating Users, Groups, Initialization Blocks in Oracle Admin Tool to set up Security using LDAP, VPD's and external tables.
• AdeptKnowledgein Query Performance Tuning and Database Tuning.
• Expertise in using SQL, TSQL, PL/SQL and MDX Queries.
• Experiencedin working with Oracle BI Applications (Finance, Supply Chain, HR and Sales).
• Experience in working with other BI Tools such as Cognos and Open Source BI Tools Pentaho and Jasper.
• Have Experience working in Industry Sectors such as Insurance, Finance, Healthcare, HR, Banking and Manufacturing.
• Have 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, 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.0/8.6/8.1, DAC 10.1.3.4/3.4.1, UC4

Databases

Oracle 11g/10g/9i, MS SQL Server 2003/2005, Teradata, Postgres

Languages

SQL, PL/SQL, T-SQL, C, C++, Java, J2EE

ERP/CRM

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

Data Modeling Tools

Sybase, SQL Developer

Education:

• Bachelors of Computer Science

Certifications:

• Oracle Fusion Middleware 11g Business Intelligence Foundation Certified Implementation Specialist.
• Oracle Database SQL Expert.

Professional Experience:

Confidential, Baltimore, MD Jan 2012 - Till Date
ETL Lead Developer

Confidential, is a Gas & Energy company supplying electricity & gas within the state of Maryland. The project involved customizing their BI Apps Datawarehouse & building a new Meter Data management & Customer care billing data mart.

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 11g,
OWB 11g, EBS 11, UC4, TFS, Windows Server 2008, RHE Linux.

Company: Confidential, Sep 2011 - Dec 2011
Client: East Kentucky Power Cooperative, KY
OBIA Architect / Lead

Confidential, is a Power generation Coop providing Power to different utility companies in and around Kentucky. EKPC initiated a BI Apps Project to implement Financial Analytics and a custom Datawarehouse for their Reporting purposes to cater to their Executive staff.

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 with 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 11g,
Peoplesoft 9.0, Windows Server 2008, RHE Linux.

Company: Confidential, Aug 2011
Client: Confidential, WI
OBIA Architect

Confidential, is a leading manufacturer of Motor Boat Engines for Clients in US and across the world. The Project was to Upgrade from their existing BI Apps 7.9.5.1 (Supply Chain & Order Management Analytics) to BI Apps 7.9.6.2.

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 then 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.1,
RHE Linux.

Confidential, Cleveland, OH Feb 2011 - May 2011
OBIA/ETL Architect

Confidential, Division handled the complete Demographics of Employees in the entire Bank. The Project involved work around setting up and customizing the Compensation, Workforce Profile and Recruitment Subject Areas under the HR Analytics Package. The Work comprised of handling the Database, ETL and the OBIEE Suites.

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 Server,
Linux, Oracle 10g, PeopleSoft 8.4.

Confidential, Dayton, OH Oct 2010 - Feb 2011
OBIEE Architect

Confidential, is the Section of the PNC Bank handling the entire Bank's Mortgage Business. The Project requirement was to Build Dashboard's for the Finance, Sales, Credit Risk, Compliance and Strategic Partnership Division of PNC Mortgage. It involved work at the Database, RPD, Oracle Map Viewer and BI Answers.

Responsibilities:

• Met the Business Users to Understand the Mortgage Data and identify the Data Sources for Several Business Targets and Thresholds.
• Developed a Data Model for the Target Data and Created Views, Materialized Views and Indexes in the Datawarehouse.
• Created Informatica Mappings & Workflows to Populate Data into the Target Fact Tables.
• 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 with 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
Viewer 10.1.3.3.

Confidential, Okemos, MI Jul 2010 - Sep 2010
OBIA Architect

Confidential, is National Insurance Company which provides Dental Insurance to Millions of Customers. The Project involved setting up the Oracle BI Application Installation & Configuration for their Peoplesoft Financials 9.1.

Responsibilities:

• Investigated the Clients Hardware and Software setup for the BI Apps Installation.
• Provided guideline to the Infrastructure required for the Installation.
• Created appropriate Database Schemas to hold the DAC Repository, Informatica Repository and the Business Analytics Warehouse.
• Created the Windows and Linux Virtual Servers to hold the Client and Server Components respectively.
• Installed OBIEE 10.1.3.4.1 on the RHE Linux Servers and configured the BI Scheduler.
• Installed OBI Apps 7.9.6 and migrated the Repository and Catalogs to the OBI Server location.
• Installed Informatica 8.6 Servers and the Hotfix 10 on the Linux Platform.
• Installed the DAC 10.1.3.4 standalone Server on the same box as the Informatica Servers.
• Configured the Connections between Informatica and DAC.
• Configured the User Variables on the Linux Box to enable OCI Connectivity to the Oracle Databases.
• Installed the Informatica, OBIEE and DAC Client components on the Windows Box.
• Created ODBC Connections to populate the Business Analytic warehouse from the DAC.
• Configured Peoplesoft 8.4 in the DAC and Informatica and Ran the ETL Routines from DAC.

Environment: RHE Linux 5.5(64 Bit), Windows Server 2003 (32 Bit), OBIEE 10.1.3.4.1, OBI
Apps 7.9.6 (Financial Analytics), Informatica 8.6.1, DAC 10.1.3.4, Peoplesoft
8.4/9.1.

Confidential, Chicago, IL Feb 2010 - Jul 2010
OBIEE / ETL Architect

The American Hospital Association (AHA) is a national organization that represents and serves all types of hospitals, health care networks, and their patients and communities. Close to 5,000 hospitals, health care systems, networks, other providers of care and 37,000 individual members come together to form the AHA. The Project was initiated for AHA to Develop a BI Platform over their Membership CRM Solution. My primary responsibility was to lay down the BI & Datawarehousing Platform for this Project.

Responsibilities:

• Gathered Report & Dashboard Requirements from all PMG's(Personal Member Groups).
• Documented and Reviewed Requirements to build the Business Requirement Document for the 1'st Phase of the Project.
• Installed OBIEE 10.1.3.4 & OWB 11.2 on Windows & Linux Environments respectively.
• Studied the Avectra CRM's ER Diagram to identify the Data Tables & Joins in tandem with the Business Rules.
• Configured SQL Server Gateways from Oracle to load Data from the AMS Data Source (SQL Server 2005).
• Built Staging Area (Oracle DB) structure with Data Tables, Surrogate Key Tables & PL/SQL Procedures to implement Surrogate Key Generation and accommodate SCD Type 2.
• Built a Star Schema Datawarehouse for Reporting and built Indexes for Performance.
• Built OWB Mapping's & Process Flows to populate the Staging & Datawarehouse Tables.
• Built the Physical Layer by Importing Tables, creating Aliases and Physical Joins.
• Created the Business Model Layer (Logical Tables, Logical Joins, Dimensions, Facts, Hierarchies, Calculated Measures).
• Built the Presentation Layer and modified it according to the User Requirement.
• Created Users and Groups in the Repository to enable User Authentication.
• Created Filters on Users Groups to implement Authorization.
• Designed Reports (Pivot Table, Tabular, Charts, Prompts, View Selector and Filters) and Dashboard's in BI Answers.
• Performed Unit Testing and User Interface Testing.
• Migrated the Web Catalog, Mappings and ETL Transformation from Test to Production Environments.
• Trained Business Users in handling Ad-hoc Reports and Dashboards.

Environment: OBIEE 10.1.3.4.1, OWB 11.2.1, Oracle 11g, SQL Server 2005, Avectra CRM,
Oracle Financials, Windows Server 2003, Red Hat Linux 5.5.

Confidential, Nashville, TN Dec 2007 - Dec 2009

Sr. OBIEE Developer

Griffin Technology a Leading provider of Accessories for Apple Products was developing a BI
Project to analyze their Internal Productivity. The Project involved in setting up an ETL and DataWarehousing Environment and Creating a Reporting Solution for the Business Users. I was primarily responsible to build the entire Architecture from their existing Resources.

Responsibilities:

• Gathered Report Requirement and Specification from Sales, Supply Chain, Inventory and Accounts Departments.
• Set Up Virtual Servers for the Installation of the Data Warehouse components.
• Installed OBIEE Suite and OWB on Windows and Linux Environments respectively.
• Documented a Business Requirement Document with the Input from the Business Users.
• Set up Staging and Datawarehouse Databases.
• Analyzed JDE Table Structure and set up Staging Area for Space and Performance Consistency.
• Created Source, Staging and Target Modules in OWB.
• Set up ETL Mappings and Transformation and Unit Tested each Mapping..
• Designed the Data Model and Built a Star-Schema Datawarehouse for their Reporting Solutions.
• Created Aggregate Tables using Materialized Views and Aggregation Persistence wizard.
• Created Physical Layer with Aliases and Joins by importing Database Tables, Views and XML Files.
• Set up the Business Model with Dimensions, Facts and other Logical Metadata.
• Created Calculated Measures, Rolling Measures, Time Series Measures in the Business Model.
• Set up BI Authorization using the Clients LDAP Server.
• Created Initialization Blocks, Session Variables andPresentation Variables for Use in Reports and Dashboard Prompts.
• Created Charts, Pivot Table, Tables, Filters and Prompts in Dashboard Reports.
• Built customized Reports using HTML and Java Script.
• Created Oracle PL/SQL Functions and Stored Procedures for Business Operations.
• Set up XML Publisher Reports and Templates using Windows and Excel Plugins.
• Created Bitmap/B-Tree/Join Indexes, Aggregation Tables and Materialized Views to improve Performance.
• Involved in setting up Data Loading from Postgres to Oracle Databases using Shell Scripts and Kron Jobs.
• Involved in the Migration of Data from their Old ERP System (AcctVantage) to their New ERP System (JD Edward's).
• Worked extensively with the Clients Sales, Supply Chain, Inventory and Accounts Users to set up Reports for their Daily Operations.
• Used the Credential Store in effect to synchronize the Authorization method between BI Answers, BI Scheduler and BI Publisher.
• Troubleshooted Bugs and Issues in the BI and OWB Environment.
• Trained Business Users and performed Knowledge Transfer to the Client.

Environment: OBIEE.1.3.3 Suite, OBI Apps 7.9.5, OWB 10.1, Oracle 10g, JDE World, AcctVantage, SalesForce CRM.

Confidential, Roseland, NJ Dec 2005- Nov 2007
Sr. OBIEE/OBIA Developer

Automatic Data Processing, Inc., with nearly $9 billion in revenues and over 585,000 clients, is one of the world\'s largest providers of business outsourcing solutions. ADP offers the widest range of HR, payroll, tax and benefits administration solutions from a single source. ADP was looking for a BI Solution to offer their Clients on top of their Home Grown Ad-hoc Reporting Solution. They had chosen OBIEE over other BI Vendors for this Project. As a Sr.OBIEE Developer my Primary Work was to build the Entire BI Architecture from scratch. Responsibilities:

• Installed and Configured OBIEE 10.1.3.3 Suite on the UNIX Environment.
• Created Star Schema Data warehouse from their existing Oracle 10g OLTP database.
• Used Informatica to Perform the Transformation and Loading into the Data warehouse.
• Configured Oracle EBS with Informatica using the Adapters and deployed the Source Metadata into the DAC Repository.
• Set up ETL Schedules and Performed Index Tuning and Load Balancing using DAC
• Imported Multidimensional Data from Hyperion Essbase and built the Physical Layer.
• Set up Virtual Private Database on the Star Schema to Implement Client based Security.
• Used the Administration Tool to Configure and develop the Metadata Repository (RPD).
• Designed the HR Data Model using Toad and built the Bussiness Model.
• Imported Tables, Views and defined Joins to develop the Physical Layer in the Admin Tool.
• Created Logical Tables, Dimensions, Facts, Hierarchies and additional Metadata in the Business Layer.
• Created Users, Groups by establishing a Connection to the existing LDAP Server.
• Created Initialization Blocks and variables to call VPD Functions for establishing Client Level Data Security.
• Created custom built Reports and Dashboards on the HR & Finance Subject Areas.
• Created Pivots,Charts and Tabular Reports with Prompts and Filters.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Created proactive agents iBots(BI Scheduler) and interactive Dashboards and sent Alerts to High Level Client Users.
• Troubleshooted errors in the BI Server and made backups for RPD's.
• Developed PL/SQL Scripts for ETL Transformations and Oracle Data Load utilities.
• Created Oracle Cubes using Analytic Workspace Manager.
• Created Cube Views and used them as Data Source to create the Metadata in the Admin Tool.
• Created Reports and Dashboards with Drill thru, Drill up, Slice and Dice Properties.
• Trained Users on Ad-Hoc Reporting and documented the work.

Environment: OBIEE 10.1.3.3 Suite, OBI Apps 7.9.5.1(HR, Finance, Sales), Informatica 8.1,Oracle 10g, AWM 10.2.0.3, Informatica 7.1, Golden Gate, Oracle EBS, UNIX, Toad.

Confidential, India Feb 2002 - Jul 2005
BI/Database Junior Developer

Confidential, is one of the World's Largest Cell Phone Manufacturer with IT Teams in India. My Primary Job at Nokia was to Develop and Maintain Cognos Reports and Database Queries.

Responsibilities:

• Developed SQL & PL/SQL Scripts for Database Reporting.
• Installed and configured Siebel Analytics on the Windows Environment.
• Applied Drill through for the reports to get detailed information of a particular field in another report
• Built the RPD with Physical, Business and Presentation layers.
• Created User Profiles in the Catalog for the security.
• Built Shell Scripts to automate Data loading and SQL Reporting.
• Involved in gathering New Business Requirements to develop logic for Transformations.
• Documented Business Designs and communicated to the Application Team.
• Trained Developers on SQL Reporting.
• Worked on building a small Datawarehouse for Reporting.

Environment: Oracle 9i, Siebel Analytics 7.8, Windows NT/2000, UNIX