SUMMARY

• 7+ years of expertise in providing Efficient Business Intelligence Solutions to various clients wif a goal to provide quality and decisive information. - Dynamic Dashboards, Reports, Scorecards, Trends, KPIs, Infographic, Ad Hoc/ On-Demand Reporting, Traditional Reporting.
• Expertise in BI Tools OBIEE 11g/BI Apps, BI Publisher - Architecture Design, WebLogic, RPD Modeling/Design, Dynamic Dashboard Design, Ad Hoc Reports, Security, Role Management, Performance, XML Publisher, Production Support.
• Experience wif ETL Tools - (SSIS, Informatica, Data-Stage, ODI): Architecture, Mapping Design and Specification, Modeling, Monitoring, Customization, Performance Optimization.
• Expertise in building BI solutions on various ERP Platforms - Oracle EBS (R12) (Finance, HR, Supply Chain, Manufacturing, Projects), Essbase, Hyperion, Traditional Operations ERP.
• 5 years of experience wif Analytics which halped finance and operational departments plan and forecast the business trends and take appropriate actions. - Statistical Analysis, Budgeting, Predictions, and Decision Making Tools.
• Over 4 years of experience in Data Architecture & Design on various platforms Oracle, MS SQL Server, DB2, Access. - OLAP, OLTP, Data Marts, Cubes, Design, Specification, Model, Build, Performance, Auditing.
• 4 year of experience as Business/Data Analyst to identify the unique business processes, discover data and structure logical/physical models - Data Identification, Operational/Source Analysis, Quality, Process, Efficiency
• Over 2 years of expertise in working as Project Lead - Planning, Estimate, Offshore Model, Team Management.
• Experience wif BI Efficiency Methods - Quality Check, Performance Optimization, 24x7 Support
• 3 years of experience wif Agile Methodology - Scrum (Sprint, Scrum Master)
• Passionate in Interest wif Graphical representation of data - Website, Case Study, Infographics

TECHNICAL SKILLS

Business Intelligence: OBIEE 11g, BI/XML Publisher, BI Apps, Noetix

Analytics: Hyperion IR and Financial Reporting, Essbase

Oracle ERP: (EBS) Projects, HR, Finance, Manufacturing, Supply Chain

ETL Tools: Informatica, Data Stage, SSIS, ODI

Databases: Oracle, MS SQL server, MS Access, Essbase

Date Modeling: Power Designer, Erwin

Scripting: SQL, PL SQL, XML, X path, XDOSLT

Web Based: HTML, DHTML, CSS, Ajax

Graphic Tool: Adobe Photoshop CS5, Adobe Dreamweaver, Adobe Illustrator

PROFESSIONAL EXPERIENCE

Confidential, Vancouver, WA

BI Architect / Data Analyst

Responsibilities:

• Business Intelligence Infrastructure, Architecture, Design and Development.
• Developed strategies for data acquisitions and integration of the new data into Data Warehouse.
• Created Data Warehouse Design: Logical Model, Physical Model and Implementation.
• Created Data Model using various techniques and develop scripts against Oracle EBS for reports.
• Develop scripts for OBIEE against EBS (Oracle) to simulate Discover Reports.
• Created specification for ETL development of DW (Finance, Police, Operations Fire, and Planning).
• Customize existing ETL Logic based on requirement (Finance, HR) and Validate scripts wif source system (Oracle EBS).
• Developed, deployed, administered and maintained OBIEE RPD wif data model, transformation and functions for dashboards.
• Developed RPD against Essbase and Hyperion (Integration of Cubes) for budget reports.
• Developed dynamic dashboards for departments Finance and HR.
• Created Dynamic real time dashboards for Fire and Police department which were installed in stations to track events/incidents/activities of city.
• Created various custom reports for each of the departments. These were both analytical (budget-actual-projections-trend) and operational reports (daily activity).
• Created budget-actual projections which halped analysts to forecast (trend) .
• Developed reporting model for Ad-Hoc Reporting solution so dat users could develop their own report when needed.
• Created test cases and extensively validated OBIEE Reports against EBS Data.
• Tested ETL in very detail to see it behaves as per Oracle EBS in terms of data. (Discoverer Reports).
• Daily Administer OBIEE (RPD, EM, Console, Web-logic, and Security).
• Enabled Data federation against multiple sources. (Star Schema)
• Achieved performance optimization in every layer (Database, Data Warehouse, RPD, and Presentation Catalog) using indexes, effective query, variables, and cache. De-normalization, etc.

Environment: OBIEE, BI Apps, Oracle EBS, Hyperion, Essbase, ETL(SSIS), OLTP, OLAP, Oracle 11g, SQL Server.

Confidential, Portland, OR

BI Reports Developer/ Data Analyst

Responsibilities:

• Report requirement gathering from business users.
• Report mockup and UI design using Visio and Power Designer.
• Data Architecture and Design. (Logical, Physical and Optimization).
• Meeting users to understand business process worldwide. Transform them to technical design.
• Work in Agile method (Scrum, Task) to perform daily development/progress.
• Oracle EBS (GL/AP/AR) Analysis. (OLTP)
• Analytical Data-Warehouse Model and Design. (ETL)
• Data Integration Audit Design between Oracle Finance, OLTP, OLAP, and Data warehouse.
• Detailed ETL and Report spec design for developers on shore and off shore.
• Functional and Technical Spec Design
• IBM Cognos Technical and Logical design document for report writers.
• Unit Testing of Reports and Data Stage ETL in terms of functionality and data.
• OBIEE BI Publisher reports design, test and deployments.
• Conversion of BI Publisher reports to Cognos.
• Development of financial dashboards wif KPIs.
• Presentation of reports to users and demo.
• Performance optimization and enhancements of existing reports
• Database Optimization.

Environment: OBIEE BI Publisher 11g, ETL Data-stage, Cognos, SQL Server Management Studio, Power Designer, MS Visio, SQL Designer, XML, IBM Eclipse

Confidential, Chicago, IL

Sr. OBIEE Consultant

Responsibilities:

• Involved in data model design, mockup and build for data analysis.
• KPI identification and report mockups.
• Build 5 subject areas in OBIEE rpd. based on the existing legacy system to cover various business needs.
• Build complex data models in rpd. using concepts in logical model like logical table source, force joins, variables, hierarchies, and various functions.
• Used various functions in BMM layer for presenting data / information in business standards.
• Built highly interactive and drilldown 5 dashboards wif features, which would replace 30 existing reports.
• Conversion of Essbase and discoverer reports to OBIEE dashboards.
• Build reports using maps in OBIEE for geographical reporting worldwide using mapviewer.
• Built charts, graphs for dashboards for trend analysis.
• Built complex data model in RPD for the purpose of Ad Hoc and future reporting.
• Built around 60 template reports for the purpose of On Demand analysis.
• 25 BI Publisher reports were designed wif complete custom format (pdf and excel) which would be scheduled to third party business partners.
• Built charts and graphs in BI Publisher for the CFO to review the daily trend in business.
• Administer daily activities like user settings, rpd + object deployments, performance monitor and other.
• ODI Mapping design and modeling. Knowledge of ODI
• Testing, validation and fix for data accuracy and performance.
• Monitor existing Data warehouse wif the team and creating suggestions document to increase the performance and usability.
• Involved in User Training and validation.

Environment: OBIEE: 11.1.1.6.6. , Hyperion 11x and 8x, ODI, BI Publisher, IBM DB2 Database, Squirrel SQL Editor, Oracle Web-logic, EM and Console. Oracle Discoverer, Essbase

Confidential, Portland, OR

Business Intelligence Developer

Responsibilities:

• To gather business requirement and transform to technical documentation..
• Work wif SME to identify data, relationship and business standards, which would halp operational reporting.
• Involved in architecture and design phase
• BI Publisher Report Development Lead to deliver operational reports and invoice templates.
• Build and install reporting environment.
• Build operational Reports for Cargo Operation Module using BI Publisher.
• Define and analyze the Data Model for Operational Reporting.
• Build Reports on Web Service Application and integrate wif data warehouse reports
• Used web - services as a source to build, print, schedule reports.
• Built financial reports on top of Oracle R12.
• Convert Cognos reports to Oracle BI.
• Build custom RTF, Excel and PDF template to deliver reports on demand.
• Use XML, XPath, XDO and other XML functions to navigate, select, Data and format them to PDF, Excel
• Build templates in MS Word and Excel using BIP Add-in. Charts, Graphs were also built for analytical reports.
• Define style Sheets using XML and BI Publisher.
• Build and test Invoices, Labels using XML and web-services.
• To do admin activities using Oracle web-logic enterprise manager and console.
• Work wif Admin to define BI Publisher security and setup.
• To participate in UAT and production support.

Environment: BI Publisher 11g, SQL Server, XML XPath, XML Functions, IBM ETL Data Stage, Oracle Apps, Oracle Financial, IBM Eclipse

Confidential, South Jordan, Utah

Oracle BI Consultant

Responsibilities:

• Design, build and enhancement of the Reports using Oracle Business Intelligence (OBIEE) and BI/XML Publisher.
• Provide overall Business Intelligence & Reporting support to business. Built Operational Reports for business and field managers. their reports halped to track every day activities across the business.
• For executives build Analytical solutions. their were financial reports presented data at different dimensions, which halped to make collective decisions through forecasting across the Globe.
• Worked exclusively as Front End Report Developer using OBIEE and BI Publisher. Worked on User Interface part of Reports and Dashboards. The Reports were completely custom made which halped business partners to maintain integrity. Developed Reports / Dashboards for Projects, Supply chain and Finance wif different Analytics Views: Pivot Table, Chart, Gauges, and Column Selector, wif global and local Filters using Oracle BI Presentation Services.
• Built Customized OBIEE Reports for Oracle Projects, Supply Chain, Human Resource and Finance.
• Developed Ad Hoc Reports for Operational Managers using OBIEE Variables. dis was halpful for business users to run reports on demand.
• Created Schedulers; iBots to send or subscribe reports.
• Work wif Admin to create users, performance tuning and security
• Converted existing OBIEE Reports to BI Publisher Reports for Executives.
• Developed and generated Custom Templates in BI Publisher, which were targeted for Operational Managers. Created PDF, RTF, Excel Reports and Graphs using BI Publisher.
• Developed custom scripts for BIP templates, which were done for unique layout and functionality.
• Wrote Custom SQL through BI Publisher for Operational Reporting on Oracle Application tables.
• Created Navigation between templates and Reports. Connected OBIEE/ BIP.
• Part of the design phase the 3 layers of RPD; Physical, Business and Presentation layers using Noetix AMDR - Generator.
• Created Views on using Oracle ERP tables using Noetix for Operational Reporting.
• Customized views and generated Logical views for Operational Reporting using Noetix Scripts and Generator.
• Create OBIEE reports & dashboards for the Field organization on demand.
• Customized and enhanced existing Crystal reports
• Work wif ETL Informatica team for creating the mappings, transformations, schedulers for Analytical reporting.
• Supporting the production environment, performance tuning and enhancements. Worked to see the reports closely to identify issues if any.
• Perform data analysis to determine root cause of data issues and SQL fix.
• Unit testing and user acceptance testing.
• Engage in project activity for implementing new BI business capabilities and value additions.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle EBS, Oracle Projects, Noetix Analytics, Noetix Views, Informatica Power Center 8.1, Oracle 11g, TOAD, SQL and PL/SQL., HTML, DHTML,CSS, JAVA, AJAX, XML

Confidential, NYC, New York

OBIEE Consultant

Responsibilities:

• Identified Business Model and Security (Determined Facts & Dimensions, Date & Time relationships, Granularity, Data Consistency across Dimensions and Identified Business Users & Group Security).
• Designed and implemented custom business intelligence solutions .rpd, and configured metadata objects, web catalog using Siebel Analytics.
• Presented cutting-edge, visual analyses to the management through executive dashboards twice monthly. The visualizations revealed important trends in the business unknown to senior management.
• Developed OBIEE Repository (RPD) at 3 layers me.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Built time series and drilldown function on reports.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Configured schedulers and used iBots effectively to generate and deliver reports based on criteria. The reports were delivered to the concerned department as an email alert.
• The new dashboards provided insights into early indicators of profitability, like financial and business behavior, allowing senior management to quickly identify unsuccessful programs and alter them.
• Converted existing reports to PDF and RTF Formats. Was also responsible to generate and deliver chronological reports using iBots.
• Implemented security by creating roles & web groups, checks wif External tables and LDAP, and Object Level Security.
• Involved in the phase of Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars wif Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts)
• Assisted in creating, Reusable Mappings using Filters, Aggregator, Lookups, Expression Aggregator, Sequence generator, sorter, Joiner and Update Strategy Transformation.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle BI Apps Marketing Analytics, Informatica Power Center 8.1, Oracle 11g, TOAD, SQL and PL/SQL., HTML, DHTML,CSS, JAVA, AJAX

Confidential, San Francisco, CA

OBIEE Consultant

Responsibilities:

• Identified and worked wif various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements.
• Based on business requirements and analysis developed OBIEE Repository (.rpd) consisting of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Created and implemented operational dashboards. The dashboards provided instant insight for Organization’s business by providing them wif relevant and timely information, allowing executives to instantly identify and apply appropriate check points to improve their efficiency.
• Developed customized reports wif different drilldown views, filters, variables, prompts and selectors. Implemented dynamic dashboards prompt to zoom into particular segments of the business in a performance-optimized manner.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Created custom dashboards featuring rich User Interface using CSS, HTML and Java Scripts. Created modified and administered analytics intelligence interactive graphical dashboards wif links to web sites, HTML text, links to documents; and embedded content such as images, PDF Documents, charts, maps and tables.
• Created Dimension Hierarchies, Drilldown facility and Aggregate Tables in the BMM Layer.
• Created security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Responsible for the Production and Maintenance Support.
• Involved in Performance Tuning of Dashboards/Reports and made changes to database by implementing the aggregation table and Cache management through (Event polling table).
• Involved in developing Mappings in Informatica using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the data.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle
• Created materialized views in Oracle to enhance the performance.

Environment: OBIEE 10.1.3.3, BI Publisher 10.1.3.3,Oracle BI Financial Analytics, Informatica Power Center 8.1, TOAD, Oracle 10g, SQL, Oracle EBS, PL/SQL and Shell Scripts, HTML,CSS,DHTML,AJAX, Java

Confidential

Reports Developer

Responsibilities:

• Carried out requirements analysis.
• Designed and implemented custom business intelligence solutions .rpd, and configured metadata objects using Siebel Analytics.
• Worked extensively on Siebel User Interface (Siebel Answers, Delivers, and Dashboards).
• Based on business requirements and analysis developed OBIEE Repository (.rpd) consisting of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
• Was responsible for front end UI of the reports and dashboards. Used CSS, HTML and Java Scripts to increase the user interface design and navigation.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Was responsible for scheduling and sending BI Publisher reports to executives.
• Involved in Performance Tuning using optimization efforts such as re-organizing the data, aggregation, Cache Management, indexes; Oracle materialized views and reports changes.
• Designed reusable transformations and shortcuts to share different mappings.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.