CAREER PROFILE
12+ years of Information technology experience in business information computer solutions, gathering Business Requirements, Analysis, and Design.
5+ years Data Warehouse Modeling, OBIEE, gathering Business Requirements, Analysis, and Design.

• Experience in OBIEE 10.1.3.3.2, Informatica 7.1.1 PowerCenter, Oracle 10g Development and Administration.
• Experience in Data Analysis, Performing Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and Hierarchies.
• Experience in creating, modifying, and administering Analytics Intelligence Dashboards with drill down capabilities using prompts and filters Oracle Business Intelligence Enterprise Edition (OBIEE), using OBIEE Answers, creating iBots using OBIEE Delivers.
• Experience in providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, cache monitor, building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer), time series objects, configuring OBIEE security (groups, access / query privileges) using OBIEE Repository, OBIEE Presentation Services, and OBI Publisher.
• Experience in Performance Tuning of Data Warehouses by implementing the materialized views.
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI Repository.
• Experience in Installation, Configuration, and Administration of Oracle OBIEE 10g standalone, OBIEE Presentation Services, and OBI Publisher, and configuring OBI scheduler, Delivers, Answers, and OBI Publisher to work together.
• Able to repair, install, upgrade, and maintain desktop and notebook computers as well as printers and scanners.
• Extensive knowledge of technology terms and developments.
• Exceptional customer service skills, account management, follow up, and sales.
• Excellent written and verbal communication skills.
• Ability to instruct users with computer and presentation skills.
• 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. Excellent ability to understand and analyze the client requirements.

OBIEE Stand Alone

• Gathered functional & technical specifications, walk through requirements.
• Identified the granularity level of the data required to be available for analysis.
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using OBIEE Server Admin tool and associating catalog objects and Web modules with the created users and groups.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data and Web Catalog Objects as per the data requirements using OBIEE Admin and Web tool.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Configured the territorial hierarchy and worked with time series objects.
• Configured Sales, Market, and Product Facts using OBIEE Answers and generated reports using BI Publisher according to the business requirement.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Experience in creating pivot table requests allowing manager to analyze the business from different perspectives, providing optimized analytics request using column selector.
• Experience in configuring the NQSCONFIG.INI file for Usage Tracking using direct insertion.
• Experience in creating comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
• Experience in generating queries, place filters in OBI Answers, and create reports. ‘Dashboards’ were generated to provide insight into the market/period/product/financial data.

Data Warehousing / ETL –Informatica 7.1.1 PowerCenter

• Used Data Modeling tool for Star and Snowflake Schemas.
• Worked heavily with Informatica using various transformations such as Expression, Sequence, Filter, Router, Aggregator, Lookup, Joiner...etc
• Created reusable transformations for re-usability in the mappings.
• Used debugger to test the mapping and fixed the bugs.
• Developed and supported the extraction, transformation and load process (ETL) for a Data Warehouse from flat files and legacy systems using Informatica.
• Developed mappings according to the business requirements.
• Worked on complex mappings using various transformations like SCD1 (Slowly Changing Dimensions), SCD2, SCD3 Lookup, Expression, Aggregator, Router, Sequence Generator, Sorter Transformation, Rank Transformation and others.

Education
Bachelor of Science in Information Technology.
Trainings

• Certified Electronics Specialist
• Computer Technician (Building and customizing computers and peripherals to client specifications – worked for Hewlett Packard as a Customization Technician.
• Web Designing – Thompson Distance Learning – familiar with Dreamweaver MX, Adobe CS3, and Adobe CS4.
• OBIEE (Oracle Business Intelligence – Formerly known as Siebel Analytics) –

Formal Training from Coriolis Business Systems – Oracle Certified Partner.

• Installation of OBIEE software on individual Laptops/Personal Computers.
• Setup and configure the OBIEE server components.
• Installing Custom Database and import data to be used for the project.
• Configuring the BI Scheduler. Creating Schema and Scheduler Tables.
• Configuring Oracle BI Presentation Services to Communicate with Oracle BI Scheduler and synchronize the security.
• Oracle BI Server Administrator 10g: Build Repositories.
• Oracle BI Presentation Services 10g: Create Reports/Dashboards.
• Oracle BI Publisher Configuration and developing Business Reports and synchronizing BI Publisher with OBI Presentation Services.
• Creating a Report template and Publishing the template to the BI Publisher Server.
• Informatica 7.1.1 PowerCenter
• Create ODBC and Relational connections.
• Importing Sources and Targets.
• Creating source tables in oracle for current and future projects.

Informatica Transformations: Filter Transformation, Expression Transformation, Parameter files, Aggregator Transformation, Router

Transformation, Lookup Transformation, Unconnected Lookup, Rank Transformation, Sequence Generator, Joiner Transformation, Sorter Transformation, Normalizer Transformation, SCD1 – Slowly Changing Dimensions, SCD2, and SCD3.

Information Technology Work Experience

Confidential,Texas April ’09 –
OBIEE Architect/Business Analyst

• Gathered functional & technical specifications, walk through requirements.
• Identified the granularity level of the data required to be available for analysis.
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using OBIEE Server Admin tool and associating catalog objects and Web modules with the created users and groups.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data and Web Catalog Objects as per the data requirements using OBIEE Admin and Web tool.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Designed the business model conforming to functional mapping, defined logical and complex joins for the dimension tables.
• Configured the territorial hierarchy and worked with time series objects.
• Configured Sales, Market, and Product Facts using OBIEE Answers and generated reports using BI Publisher according to the business requirement.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Created pivot table requests allowing manager to analyze the business from different perspectives, providing optimized analytics request using column selector.
• Configured the NQSCONFIG.INI file for Usage Tracking using direct insertion.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of Analytics that includes (.rpd, Dashboards, Security etc.).
• Generated queries, place filters in OBI Answers, and create reports. ‘Dashboards’ were generated to provide insight into the market/period/product/financial data.

Environment: OBIEE 10.1.3.3.2, OBIEE Answers, OBIEE Dashboards, OBIEE Delivers & iBots, Oracle 10g, SQL, XML, Windows XP Professional, Windows 7 Professional, LINUX, Informatica 7.1.1 PowerCenter.
Confidential,Texas Nov 2007 – Jan 2009
OBIEE Architect/Developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the data marts.
• Developed STAR Schemas.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Mapplets, stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were done.
• Worked with Type I, II, and III - slowly changing dimension
• Interacted with the client for requirement gathering and prepared OBIEE documents.
• Used time series functions to support historical time comparison analyses.
• Built the Physical, Business Model and Mapping, and Presentation layers of a repository.
• Used Oracle BI Answers to run queries to test and validate a repository.
• Built time and calculated measures for a fact table and created dimension hierarchies and level -based measures.
• Modeled aggregate tables to speed query processing and partitions and fragments to improve application performance and usability.
• Set up security to authenticate users and assign appropriate permissions and privileges.
• Applied cache management techniques to maintain and enhance query performance.
• Used administration tool wizards and utilities to manage, maintain, and enhance repositories.
• Developed various Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Narrative View, Dashboard Prompts and Variables.)
• Created BI Publisher Reports based on various data source (BI Answers / BI Server Subject Area / Web Services/ HTTP Data Set / File Data Set.)

Environment: OBIEE 10.1.3.X, Informatica 7.1, OBIEE Answers, OBIEE Dashboards, OBIEE Delivers & iBots, Oracle 10g, SQL, Toad 9.0, Windows Adv Server 2003, SQL, PL/SQL, MS Visio 2007 professional.
Confidential,IN (Mornings) Jan. 2005 – Sept. 2007
OBIEE Developer

• Analysis, design, development, and ongoing support of existing and new BI environment, Oracle Business Intelligence Enterprise Edition.
• Used Oracle BI Answers to run queries to test and validate a repository.
• Implemented security by granting roles and privileges to users and groups.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Created several answers reports and then Dashboard with Reports links.
• On reports, used case statements and several expressions, tried unions as well. Used column properties to create custom column labels, formatting.
• Used Compound view and Table View to edit the column and data display properties, images etc.
• Used Pivot views and Chart View allowing management to analyze business from different perspectives.
• I created Filters and Customized prompts to restrict my results.
• I applied cache management techniques to maintain and enhance query performance.

Confidential,Indiana
Components Sales/Customer Service (Afternoons) Apr 2005 – Nov 2007
2007 Components Top Sales Award Recipient

Responsibilities:

• Selling computer motherboards, CPUs, memory, cases, computer barebones, network routers, switches, hubs, network cables, hard drives, surveillance equipment etc.
• Participated in on-site weekly training sessions.
• Made recommendations to customers on hardware and software system configuration, installation, repair and maintenance.
• Configured and tested all necessary computer platforms for customers as part of customer service resulting in successful customer satisfaction.
• Attending customer calls for hardware, hardware troubleshooting, hardware compatibility, and availability.
• I was the recipient of 2007 Top Sales Award.

Confidential,Indiana
Computer Technician – Customization Dec 2003 – Nov 2004

Responsibilities:

• Installed, customized and upgraded desktop, notebook computers and printers.
• Installed customer specific hardware, software, company images and asset tags.
• Everything on this position came with specific hardware, software, and configuration instructions.

Confidential,Computer Techician/Manager Jan 1997 – Dec 2001

Responsibilities:

• Repair, install, upgrade, and maintain desktop and notebook computers as well as printers and scanners.
• Customer service skills, account management, follow up, and sales.
• Trained customers, technicians and other managers on system capabilities and usage.
• Configured and tested all necessary computer platforms under extreme time constraints resulting in successful customer acceptance.
• Responsible for complete support, installation, maintenance and training for all network and system components.
• attending user calls for hardware troubleshooting, period monitoring of hardware in the assigned department, hardware upgrading, record maintenance and audit of installed hardware components