Professional Summary:

• Around 6+ years of IT experience.
• Around 3 years of report development experience using Business Objects specializing in Universe Builder, Web Intelligence and OBIEE.
• Proficient in business analysis ,business requirements gathering, logical data modeling, reporting design solutions.
• Excellent understanding of Data Warehouse concepts and complete Software development Life Cycle (SDLC) both as a BI Reporter and data warehouse user.
• Excellent understanding of Data Warehousing Concepts, In-depth knowledge of Oracle 9i/10g/11g databases.
• Experience in OBIEE, Oracle forms and Reports 6i.
• Exposure to INFORMATICA Power Center 8.1/8.6 and Teradata.
• Good working experience in Oracle SQL, PL/SQL.
• Highly self-motivated and able to work independently as well as in a team environment.
• Excellent analytical, conceptual, and problem-solving abilities.
• Strong verbal and written communication skills.

Education:

• Bachelors in Electronics and Computer Engineering.
• Oracle Certified Associate(SQL & PL/SQL)

Technical Skills :

Business Intelligence
Tools:

SAP BusinessObjects Enterprise XI 3.1 ( Web Intelligence Rich Client , Info View , CMS, Universe Designer) Crystal Reports 2011, Xcelsius 2008.

Data Warehousing (ETL Tools):

Informatica 8.1/7.1, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Data Mining, Data mart, ERWIN 4.0,OLAP, ROLAP, OLTP.

DATABASES:

Oracle 8i/9i/10g/11g, SQL *Plus, Teradata 13.0, MS SQL .

LANGUAGES:

C, C++, SQL, PL/SQL, Java, HTML, XML

OPERATING SYSTEMS:

Windows 95/98/2000/2003/NT/XP/Vista, MS DOS, UNIX.

SQL Tools:

SQL Developer, TOAD, Teradata SQL Assistant 13.0

Professional Experience:

Confidential,La Palma, CA MAY’ 10 – Till Date
Business Objects Report Developer/Analyst
Description: Confidential,is one of the largest electric utilities in California, serving more than 14 million people in 50,000 square-mile area of central, coastal and southern California. The project was replacing Operational reporting system with Business Object Reports and also involved generating of few new reports based on business requirement for the study of smart connect meter daily and monthly statistics.

Responsibilities:

• Involved in analysis and requirements gathering and translating high-level business requirements into logical business dimensional model.
• Analyzed Data sources and existing Data warehouse for new reporting requirements.
• Worked on Business Requirement Documentation, Source to Data mapping and came up with the new tables in the Data warehouse for Report development.
• Analyzed the calculations involved in the reports to implement on Data warehouse tables.
• Worked in team to create new E-R model for the Semantic layer.
• Installed and Configured the SAP-BusinessObjects tools and Teradata SQL assistant tool.
• Build the new universe as per the requirement by identifying the required tables from semantic layer and by defining the universe connections
• Optimized the Universe and Database table for improving report performance.
• Worked on Universe Designer with required measures and objects, Implemented various Calculations, Variables, Filter conditions, Prompts, Hierarchies, Derived Tables, Aggregate tables.
• Used contexts and Alias tables to resolve loops.
• Developed complex reports merging queries, using @aggregate_aware function for calculating monthly and 3day intervals, drill down, Slice and Dice, master/detail for analysis.
• Implemented sub-reports, graphical reports, formula based, Pivot Tables, Charts and well formatted reports according to user requirement.
• Experience troubleshooting and solving business user ad-hoc report development problems.
• Worked on Teradata SQL Assistant by writing complex SQL queries for testing the data for Reports and also universe designing.
• Created various Canned and Ad-hoc reports based on the requirement, Unit tested and exported them to info view to make resources available to the users.

Environment: SAP Business Objects XI 3.1( Universe Designer, Web Intelligence Rich Client, Info View, Xcelsius) Teradata 13 ( Teradata SQL Assistant 13.0) Data Stage 7.5 ERWIN Data Modeler 7.1

Confidential,CA FEB’ 09- MAY’ 10 Business Intelligence Consultant / Report Developer
Description: This system includes supplier details, order entry, tracking, shipping information and billing modules. A Data Warehouse was developed to integrate all the related data from different sources, and to integrate reporting tool to the so designed Data Warehouse. The system includes a query module to report on product details and product sales. Various analytical and decision support reports like Sales Analysis by regions and Sales by category and period were produced from this system. These reports were used by Senior Management as a means of tracking various sales related activities.

Responsibilities:

• Involved in analysis and requirements gathering and translating high-level business requirements into logical business dimensional model.
• Analyzed the reports and worked on preparing technical documentation.
• Installed and configured the BO,OBIEE tools and Oracle data base defined appropriate connections.
• Integrated the Warehouse to the OBIEE reporting application tool and imported data for Repository development.
• Customized Physical Layer, Business Model and Mapping Layer and Presentation Layer using Siebel Analytics Administration Tool.
• Generated Snowflake, Star schemas, and defined Logical relation between them at the Business model and mapping layer based of the reporting requirements.
• Created presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized and Formatted Reports and Dashboards using Siebel Analytics Web.
• Grouping sorting and summarizing the data working with crystal reports.
• Working with sessions, formatting report pages, headers footers working with cross tab Objects.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Assigned Data level & UI level security to the Users.
• Implemented Session, Dynamic and static Repository variables in to the reporting. Scheduled the reports based on the requirement.
• Used presentation variable in OBIEE answers to save prompt values and use them for conditional formatting.
• Developed Dashboards & Reports using Answers validated and unit tested.

Environment: Business Objects ( Crystal reports 12), OBIEE 10.1.3 Oracle 10g (SQL,PL/SQL) Informatics 8.1ERWIN Data Modeler 7.1

Confidential,INDIA NOV’ 06 - JAN’ 09
ORACLE 9i / FORMS AND REPORTS 6i DEVELOPER

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document.
• Analyzed the data requirements and modeled the database structure.
• Created Master and Detail tables, defined primary, foreign and Compound keys.
• Developed Packages, Procedures, and Functions for the front end enhancements
• Created database objects tables, views, triggers, public Synonyms according to the requirements.
• Created PL/SQL functions to facilitate business functions and calculations.
• Created constraints on the tables for data validations and for maintaining the clear data without any Issues.
• Created Indexes on the tables for the faster data retrieval to improve the query performance.
• Integrated oracle database with the oracle reporting tool, and imported tables to the reporting environment.
• Created different reports based on the business requirement, applied required aggregations and formatting.
• Generated simple reports using reports and Forms 6i. Scheduled the reports based on the requirement.
• Involved in Technical Documentation, Unit testing, Integration testing and writing test plans.

Environment: Forms and Reports 6i Oracle 9i SQL * Plus, PLSQL Editor, Toad ,Unix/Linux