SUMMARY:

• A Dynamic professional wif 7 years of professional experience in business intelligence/data warehouse, OBIEE/Siebel Analytics, OLTP and OLAP apps as a BI Analyst, and BI developer.
• Very good understanding of Healthcare, Retail, Automobile and CRM business domain.
• Excellent Analytical and Communications skills and experienced in working wif teh senior management and teh technical teams.
• Outstanding team player and very motivated to learn.
• Experience in gathering user requirements, Data Warehouse Analysis, Design and develop BI solutions.
• Participated in end - to-end implementation of BI solutions: implemented custom report solutions, and out of box solutions (Oracle Project Analytics).
• Working knowledge in Metadata modeling in all layers (Physical, BMM, and Presentation).
• Experience in project implementation methodologies, SDLC, DW, BI Architecture using OBIEE & Microstrategy.
• Extensively worked on BI Dashboards, BI Answers, BI Delivers, and BI Publisher.
• Expertise in building Interactive Dashboards wif drill-down and drill-across capabilities.
• Experience in managing security by handling multiple user groups and assigning privileges accordingly.
• Experience in implementation of ETL methodology in data Extraction, Transformation, and Loading.
• Experience in writing SQL queries and tuning report performance.

TECHNICAL SKILLS:

Reporting tools: OBIEE 11.1.1.6/11.1.1.5/10.1.3.4/10.1.3.2, Siebel Analytics 7.8.2Oracle BI Publisher 10.1.3.4, Cognos 8.0, Business Objects XI

ETL: Informatica Power Center 9.6/9.1/8.6/8.1/7.x

Databases: Oracle 11g/10g/9i, DB2, MS Access 2000/97

Languages: UNIX scripting, PL/SQL, C, C++, Visual Basic, Java

Testing tools: WinRunner, Quick Test Pro, Load Runner, Rational Robo, Test Director, and PVCS Version Control

OS: UNIX, Linux, Sun Solaris, Windows Vista, Windows NT/XP/98

PROFESSIONAL EXPERIENCE:

Confidential

BI Analyst/Developer

Responsibilities:

• Led teh meetings wif teh key stakeholders to define high-level design and changes required for teh out of box user dashboards and reports.
• Guided teh business users towards teh best practices.
• Identified fit-gaps on existing Microstrategy based analytics solution and developed solutions to meet Shoprite user requirements.
• Analyzed and converted teh business requirement documents to technical design requirements.
• Designed teh dashboard to measure teh performance of suppliers using various KPI’s.
• Identified opportunities to create Materialized views to reference Merchandise Hierarchy descriptions.
• Involved wif technical teams to tune teh database (recommended by DBA) and fine tune teh SQL generated by BI (rearrange table sequence and new indexes).
• Recommended creating custom indexes on base tables to improve teh report performance.
• Implemented teh security by autanticating against LDAP and External table.

Environnent: OBIEE 11.1.1.7, Microstrategy, BI Publisher, MS SQL server 2008, Linux

Confidential, Englewood, CO

OBIEE Developer

Responsibilities:

• Led teh meetings wif teh business team to analyze and define user requirements.
• Developed, and enhanced teh metadata and teh repository using teh OBIEE administration tool.
• Designed and implemented different types of customized reports, reports wif different views (Table, Pivot, Charts and Column Selector), complex prompts, and interactive dashboards.
• Created templates for presenting analytics & results and modified teh OBIEE dashboard using cascading style sheets.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Optimized OBIEE report performance by fine tuning teh SQL queries.
• Enhanced performance of reports by implementing teh aggregate tables and by managing cache.
• Implemented Object level security as well as Data level security, identifying teh groups and their permissions and privileges as per business needs.

Environment: OBIEE 11.1.1.6, 10g, Oracle 11g/10g, Informatica, SQL Developer, and BI Publisher

Confidential, Fairview Heights, IL

Siebel Analytics/OBIEE Developer

Responsibilities:

• Participated in user requirement gathering meetings and converted teh BRD to technical requirement documents.
• Analyzed requirements and recommended approaches for new repository and high-level design for reports.
• Built Reports, and Interactive Dashboards wif drill down capabilities.
• Built teh Repository wif three layers: Physical layer (connecting Data sources and import schema), Business Model and Data mapping layer (create logical tables and data source mapping) and Presentation layer (create presentation catalogs).
• Designed and developed Star Schema, Hierarchies, and Level based Measures.
• Created Session Variables, Repository Variables and Initialization Blocks.
• Configured Users and User Groups in Metadata and Presentation services.
• Created presentation layer catalog folders to show different views of teh business model to different users and assigned group permissions to teh catalog folders.
• Created Views, Filters, Charts, and Tables.
• Updated Sessions, and workflows for specific mappings for loading from source tables to target tables using Informatica.

Environment: Oracle BI Apps 7.9.3, Siebel Analytics 7.8.2, Informatica 7.1.4, DAC 7.9.4, Oracle Database 10g, Extended Analytics, Windows NT, IBM AIX 5, and Unix.

Confidential

OBIEE Developer

Responsibilities:

• Gathered Report & Dashboard Requirements.
• Documented and reviewed requirements to build teh Business Requirement Document.
• Built teh physical layer by importing tables, and creating aliases and physical joins.
• Created teh business model layer (logical tables, logical joins, dimensions, facts, hierarchies, calculated measures).
• Developed Star Schema’s in BMM layer of RPD as per teh Business needs.
• Identified and implemented Aggregate tables and their definitions.
• Built and modified teh Presentation Layer according to teh user requirements.
• Created Users and Groups in teh Repository to enable User Autantication.
• Created Filters on Users Groups to implement Authorization.
• Designed Reports (Pivot Table, Tabular, Charts, Prompts, View Selector, and Filters) and Dashboard in BI Answers.
• Configured iBots for emails and alerts to all teh departments on a daily and weekly basis.
• Performed Unit Testing for all reports, participated in UAT, and supported teh testing team.
• Wrote test cases for Unit, Regression, and UAT testing phases.
• Trained Business Users in handling Ad-hoc Reports and Dashboards.

Environment: OBIEE 10.1.3.2, Oracle 10g, SQL Server 2005, Avectra CRM, Oracle Financials, Windows Server 2003, and Linux

Confidential, NC

Performance Engineer

Responsibilities:

• Gathered and analyzed business requirements and functional documents.
• Created teh Test strategy document dat defines teh test environment, phases of testing, entrance and exit criteria for different phases of testing and resources required.
• Developed test cases and test plans based on teh design specifications.
• Developed and maintained all operational and technical flows using Visio and PowerPoint.
• Maintained Requirement Traceability Matrix.
• Validated teh results from teh report by using SQL.
• Executed performance testing using Load Runner.
• Worked wif developers to close teh defects.

Environment: Load Runner, Test Director, Rational Functional Tester, Windows NT, Java, J2ee, .Net, HTML, Web Services, Oracle 9i, MS-office, UNIX, and Linux