Foram Poladia

Mail to: acghe0@r.postjobfree.com Contact No: +1-416-***-****

(Cell)

Professional Summary

? Five+ years of experience implementing full life cycle of business intelligence solution with

Requirements Gathering, Gap Analysis, performing System & Data Analysis, Application Design &

Dimensional and Data Modeling with Design, and Documentation with applications on various flavors

of UNIX and Windows.

? More than 4 years of experience in Data Warehousing/ ETL Testing within the environment of Oracle,

SQL Server, Informatica Power Center 9.1/8.6/ 8.1 (Repository Manager, Server manager, Mapping

Designer, Mapplet Designer, Transformation Developer and Warehouse designer).

? Extensive experience using Oracle Business Intelligence 10.1.3.4.x, 11G, Oracle BI Publisher 11g,

Dimensional Designs (T-1,T-2 and T-3), Fact Designs (Aggregate, Transactional, Snapshot,

Accumulating) with adaptive aggregation measures and business hierarchies.

? Implemented OBIEE Security Modules viz OBIA EBS Security / RPD/LDAP/ External Table

Authentication.

? Worked extensively on OBIEE Repository and Answers, Metadata Editor and Report Designer,

experience configuring Interactive Dashboards with Drill-Down capabilities using global and local

Filters, Variables, OBIEE Web/Admin Security Setup (groups, access / query privileges), Metadata

Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and Publishing OBIEE Reports

using OBIEE Publisher

? Tested ETL applications in relational databases and flat files using Informatica

? Tested UNIX shell scripts written for ETL Processes to schedule workflows on Autosys.

? Strong in PL/SQL Procedures, Packages, Functions, Triggers and other objects.

? Extensive experience in Unit Testing Cases, Data Quality Analysis and Validation and production

support with excellent problem solving skills with strong technical background and good interpersonal

skills.

? Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills

? Oracle Business Intelligence 11G 1.1.7x, 10 G 10.1.3.3.4.x/7.x, Security (Web/Admin), Web Catalog,

Dashboards, Answers, Delivers, BI Publisher 11G.

? Informatica 8.x/7.x/6.x/5.x (Power Center & PowerMart.

? Oracle 8.x/8i/9i/10g, PL/SQL 8.x/9.x,Noetix Operational Views and Analytical Data warehouse against

Oracle EBS

? Toad 10.x,Teradata SQL Assistant 7.1.x, PL/SQL Developer 7.x, Power Architect

? HTML, MS Visio, MS Office, MS Project.

? Windows XP/2003/2000/NT, SCO-Unix, Sun Solaris, IBM AIX, HP UNIX

Roles Performed:

? BI Developer

? ETL Developer

? Front and Back End Report Developer

Education and Certifications

? BE in Electronics, INDIA

? Certification in OBIEE Repository Development, Oracle.

Page?1?of?4

? Certification in E-Business Suite Essentials, Oracle

Professional Experience

Barrick Gold Pascua Lama Project, Chile as OBIEE/ETL Developer May 2012?May 2014

Projects:

The project involves implementation of various applications for Barrick Pascua Lama mine site

including Estado de Pago (custom tool for claiming service completion by Vendors), Protocolo suite

(custom including tracking of goods, people and vehicle between Chile Argentina border ), PPE

(custom solution for issuance and tracking of personal protective equipment from inventory to

Vendors and Barrick employees), implementation of various modules of E-business suite including

Supply chain, Projects and Finance. The project also includes enhancement and support for already

installed applications. The project involved extensive development and use of OBIEE reports for all

the modules.

Responsibilities:

? Extensive work on OBIEE reports 11G for Financial Business reports and custom Business Reports.

? Worked on trouble shooting issues OBIEE reports, ETL modifications.

? Extensive interaction with Business Domain Spocs for BRD`s and TRD`s (Business and Technical

Requirement Docs) their modifications and corresponding implementation to suffice immediate

reporting needs.

? Extensive Data Validations with internal team.

? Perform requirement Gathering along with the users to understand the requirements

? Analyzing Business Requirements and create functional specifications for the Business

Requirements

? Creating ETL mappings, sessions and workflow.

? Performed Verification, Validation, and Transformations on the Input data (Text files, XML files)

before loading into target database

? Creating test cases for ETL mappings and design documents for production support

? Setting up, monitoring and using Job Control System in Development/QA/Prod

? Extensively worked with flat files and Oracle database.

? Scheduling and automating jobs to be run in a batch process using Autosys

? Create Low Level Design based on the Functional Design

? Creating Test Scenarios, test scripts and test cases based on Requirements

? Conducting Conference Room Pilots

? Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases,

Documenting Defects, Resolved defects and Signed Off from Application

? Attending weekly status meeting to provide defect review and issues related to quality and status

update to Project Manager.

? Live link Management for Documents for entire Project across Canada and South America region

Environment: OBIEE-11.1.1.7.1 on Windows, Oracle BI/XML Publisher 11g, TOAD 10.x, PL / SQL

Developer 7.x, Autosys, Informatica Power center

Page?2?of?4

Canadian Imperial Bank of Commerce as Business Intelligence Developer Jan 2011 ? Jul 2011

Projects:

The project involves development of web based system and reporting tools required by Canadian

Imperial Bank of Commerce in order to support Business.

Responsibilities:

? Perform requirement Gathering along with the users to understand the requirements. Analyzing

Business Requirements and create functional specifications for the Business Requirements.

? Development of Tax and Mortgage reports in Cognos 8 environment and OBIEE Reports related to

Tax and Mortgage.

? Designed and developed custom multi-dimensional data warehouse for and Finance domain.

? Developing the OBIEE 11g repository with 3 Basic layers defining Aliases, LBM`s (Level Based

Measure), Aggregate /Hierarchy Tables, Helper tables, Logical sources and display folders, defining

security using LDAP.

? Data Validation and front end reporting using Answers and performance tuning is under process.

? Preparation of technical specifications and Source to Target mappings

? Creating ETL mappings, sessions and workflow.

? Creating test cases for ETL mappings and design documents for production support

? Setting up, monitoring and using Job Control System in Development/QA/Prod

? Production support for ETL mappings,workflows, sessions using Informatica and Unix

? Scheduling, monitoring and running jobs using Autosys

? Creating Test Scenarios, test scripts and test cases based on Requirements

? Conducting Conference Room Pilots and User Acceptance Testing

? Attending weekly status meeting to provide defect review and issues related to quality and deadlines

? Resolution of technical and functional issues identified during user testing

Environment: OBIEE-11.1.1.7.x on Windows, Informatica 8.6.1, TOAD 10.x, PL / SQL Developer 7.x,

Cognos 8, Autosys

Page?3?of?4

Ultimatix, TCS In-House Project as Business Intelligence Developer Oct 2008 ? Dec 2010

Projects:

OBIEE reporting for Procure, Spend and Supply Chain module upgrade Project for Analytical

Reporting, EBS Modules with analysis and implementation of the OBIA/Custom integrated Apps

with Informatica 8.6.1.

Responsibilities:

? Major responsibilities include requirement gathering from different departments filling in the

reporting gap, rectifying current reporting issues.

? Implementing BI Publisher for real time reporting analysis for Projects, Supply Chain and Financial

Team.

? Preparation of technical specifications and Source to Target mappings

? Creating ETL mappings, sessions and workflow.

? Creating test cases for ETL mappings and design documents for production support

? Setting up, monitoring and using Job Control System in Development/QA/Prod

? Production support for ETL mappings,workflows, sessions using Informatica and Unix

? Debugging Informatica transformations for any Data Validation issues.

? Help creating reports in BI Publisher for operational reports Business Intelligence.

Environment: OBIEE-10.1.3.4.x on Windows, OBIA 8.1.1,XML/Oracle BI Publisher 11g, Informatica 8.6.1,

TOAD 10.x, PL / SQL Developer 7.x, Autosys

Page?4?of?4

Contact this candidate