PROFESSIONAL SUMMARY

• Over Eight years of experience in Information technology mostly involving Data warehousing, Data modeling, Decision Support Systems (DSS).
• Experienced in Project Planning, Requirement Analysis, System Design, Construction, Implementation and Operation.
• 4 years extensive experience in OBIEE (configuring repository (.rpd), creating Intelligent Dashboards / reports, Answers, Delivers iBots / Scheduler and Publisher).
• Experience in Oracle Business Intelligence Analytics(OBIA) in Sales and Finance.
• Experience in ETL Analysis and development using Informatica and Datastage.
• Experience in Installation, Configuration, and Administration of all components of OBIEE.
• Experience in Dimensional Data modeling (Star Schema modeling, Snow-Flake modeling, Fact and Dimension tables), physical and logical data modeling.
• Good understanding on SDLC; participate in Full project life cycle from collecting Business requirements through specifications and implementations, customizations, and DAC ETL execution plans.
• Designed and developed the OBIEE Analytics Metadata repository (.rpd) using Siebel Analytic Sever Admin tool by importing the required objects (Dimensions, Facts and Aggregates) with referential integrity constraints into Physical Layer using connection pool. Develop multiple dimensions for Drill –down, Logical and Facts Measure objects in Business Model Layer, and Catalogs in Presentation Layer.
• Developed various interactive Dashboards with drill-down capabilities, reports, Charts using Answers. Managed OBIEE security set up, by authorizing groups and user access privileges.
• Extensive experience in developing Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows & Tasks, and Scheduling using Workflow Manager.
• Creating Test plan which includes data validation, User-acceptance testing and Unit-testing.
• Experience in writing complex Sql queries as part of report analysis and testing.
• Experience in Oracle, MS SQL Server, MS Access databases and have experience in writing, testing and implementing Procedures, Triggers and Functions using PL/SQL.
• Over 6 years of experience in SAP Business Objects.
• Experience in Client Server and Web Applications using VB and ASP technologies.
• Capability to adapt to any industry and learn any new technology/trends.
• Excellent Interpersonal and Communication Skills and desire to work in dynamic and challenging environments.

TECHNICAL SKILLS

DSS Tools
OBIEE, DAC,BI Presentation Services,Oracle BI Publisher,Catalog Manager,Business Objects XI R2/6.X, Web Intelligence XI
R2, 6.X, Crystal Reports 9/XI
ETL Tools
Informatica Power Center, IBM DataStage
Languages
C++, C, VB, SQL and PL/SQL
OS
Windows NT, Windows2008/2003/2000, Windows XP and UNIX HP/AIX
Databases
Oracle, MS SQL Server 2005/2000, MS Access
Data Modeling
Erwin
Web Tools
IIS, XML, HTML and ASP
Office Tools
MS Office Suite

EDUCATION & CERTIFICATIONS

• Master of Science in Financial & Management
• Received Training on Post Graduate Diploma in Computers from Systems Research Group
• Received Training on C, C++ programming from NIIT Corporation
• Received Training on RDBMS & Oracle from APTECH Limited

PROFessional Experience

Sr.Business Intelligence Consultant
Confidential, Houston,TX June 2011 – Present

Responsibilities:

• Involved in gathering requirements, analyzing and documentation of business requirements/specifications.
• Created High and Low level technical design documents.
• Analyzed reports for reverse engineering.
• Created Use Case and Detail Data Specification(DDS).
• Created ETL Technical High level and detailed documents.
• Developed reports, dashboards, Custom KPI's with different views, drill downs, report-to-report Navigation and Dashboard to report navigation using OBIEE.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs using OBIEE.
• Trained Users on developing Ad Hoc reports and building custom dashboards.
• Performed requirements gathering by interacting with business users focusing on Sales group and Purchasing on Sales Analytics and Margin Improvement projects.
• Design and Developed custom OLAP data model for overall project based on Sales and Purchasing data from GAPS and WPS systems.
• Designed and developed the Sales Oracle Business Intelligence Analytics(OBIA) Metadata Repository (.rpd) using DAC by connecting Data Sources and importing the required objects (Dimensions, Facts & Aggregates) with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions (Drill-down Hierarchies) & Logical & Facts in Business Model & Mapping Layer, and Presentation Catalogs in Presentation Layer.
• Prepared detailed flow-chart diagrams using Microsoft-Visio for Process flow for each of the entities being loaded. Using PL/SQL, developed Oracle procedures for the back end ETL process to load data into target oracle tables.
• Created and managed security groups of users, Sales groups and web-groups using various authentication systems such as LDAP, OS, and Database table authentication using Session Variable features, Dashboard and Report-level security.
• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Using Answers, created Analytic reports including Charts, Pivot tables, and Compound layouts and assigned to specific dashboards.
• Created user manual, conduct end user trainings, and application improvement /enhancement.

Environment: OBIEE, Business Objects , Web Intelligence XI R2/R3, Crystal Reports XI, Dashboard Manager, Informatica, Oracle 10g, Windows, MS Office.

Business Intelligence Consultant
Confidential, CA April 2009 – May 2011

Responsibilities:

• Involved in gathering requirements, analyzing and documentation of business requirements/specifications.
• Created reports and custom dashboards to Display Information by Customer Corporation, Reason code, By Carrier, by lane, By Mode for On Time Delivery, On Time Pickup calculations using OBIEE.
• Developed reports, dashboards, Custom KPI's with different views, drill downs, report-to-report Navigation and Dashboard to report navigation using OBIEE.
• Involved in integrating various subject area RPDs to give a single presentation view across SCM scope using OBIEE.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs using OBIEE.
• Designed and configured variety Analytical repositories according to client’s business units.
• Created additional new tables and correct data in oracle database as required.
• Imported data from External Data source systems such as Excel and Access.
• Developed reports, dashboards and score cards to support Management, Operations and Sales divisions. Report migration from legacy system to OBIEE (Oracle Publisher).
• Used star schema and designed and implemented dimension tables, fact tables, hierarchies in dimension tables, cubes, and levels. Used OLAP functions to generate reports such as rank, and lead.
• Implemented role based security on cubes and reports. Assign user access to Catalogs according to their job roles.
• Created daily and weekly schedules for the cubes and reports to automate data refreshes.
• Created and managed OBIEE Dashboards, Answers and iBots on OBIEE Analytics.
• Created new repository RPD, testing changes in Answers and releasing updated RPD.
• Developed and configured Siebel business integration applications using Informatica Designer tools, Siebel Analytics Admin tools and OBIEE Analytics answers.
• Created reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.

Environment: OBIEE, Business Objects XI R2/6.5, Web Intelligence XI R2, Crystal Reports, Dashboard Manager, OBIEE, DataStage 7.5.2, Oracle 10g, Windows XP, MS Office.

Confidential, TX July 2007 – March 2009
Business Objects Contractor

Responsibilities:

• Designed and developed Business Objects Universes to support the new sales reporting requirements of business users.
• Extensively worked with multiple data providers and linking these data providers based on the requirements.
• Set up groups and users for Business Objects deployment. Managed user and user group profiles using Supervisor.
• Extensively used Contexts and aliases to resolve the loops.
• Extensively used @prompt, aggregate aware functions while designing the objects in the Universe.
• Generated various reports with prompt functionalities at both universe and report level to enhance end-user interactivity.
• Developed row level security on Business Objects reports based on user/group level.
• Extensively worked on scheduling reports based on scheduling priorities using BCA.
• Developed SQL queries in oracle 9i and exported the data into Excel to use them as personal data providers to Business Objects reports.
• Creation of Dashboard and Score Cards using Dashboard Manager.
• Publishing reports using Web Intelligence to the various categories in the corporate documents.
• Testing the data after the ETL loads and coordinating with ETL developers and architect/designers.
• Actively involved in the Production support.

Environment: Business Objects 6.5, Crystal reports, Oracle9i, DataStage, Windows 2000/SunSolaris, Netezza 3.1

Confidential, IA Mar 2005 to June 2007
Business Objects Consultant

Responsibilities:

• Involved in gathering and analyzing the business requirements.
• Extensively used the Business Objects functionalities such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Created breaks on reports based on reporting requirements.
• Generated the customized list of values to use them for user inputs of the reports.
• Used the set analyzer to create sets and subsets of the requirements to feed it into the universe.
• Resolved Loops using contexts created Dimension, Detail and Measure objects and exported Universe to the repository.
• Separate Logical and Physical models support using ERWIN.
• Analyzed and modified the data model using ERWIN.
• Design, Development and the Implementation of the Universes and the financial reports based on the requirements.
• Created ETL Informatica mappings to load data from source to target.
• Generated various Adhoc/Canned Reports.

Environment: Business Objects 6.X (BO Reporter Supervisor, Designer, Web Intelligence), Informatica, Oracle 8i, SQL\PL-SQL, Teradata, MS-Office, Win NT.

Confidential Jan 2003 to Feb 2005
Software Programmer

Responsibilities:

• Involved in Design and Implementation.
• Involved in developing the web site in ASP Pages.
• Responsible for Enhancements to Graphical user interface (GUI) and incorporation additional functionality to the application.
• Designed the process flow.
• Designed the layout and templates using Dreamweaver.
• Designed tables using normalization techniques.
• Created reports in Crystal Reports.
• Created database objects like tables, stored procedures, views and triggers in Oracle and SQL Server.

Environment: Visual Basic (VB), ASP, XML, VBScripts, Java Script, HTML, SQL Server 200, Oracle 8i, MS Access, Windows2000.