Summary

1. Over 7+years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence (BI) applications using OBIEE/Siebel Analytics and OBIEE Apps.
2. Extensive experience in OBIEE 11.1.1.x/10.1.3.3.x, Oracle BI applications 7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), OBI/Siebel iBots (BI Scheduler), BI publisher, BI(RPD and Web-catalog) administration.
3. Expertise in handling all phases of Quality Assurance Life Cycle(QALC) and Software Development Life Cycle(SDLC) of the BI Projects.
4. Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling , Aggregate persistence wizard.
5. Strong working knowledge in Metadata modeling in all three layers (physical, BMM, presentation).
6. Experience in using Presentation, Repository and Session variables and Initialization blocks in OBIEE.
7. Experience in developing various dynamic and interactive complex reports/dashboards with intuitive drilldowns, drill-across and drillable charts using Answers
8. Extensive Knowledge on Oracle Delivers and Implemented schedule based iBots to deliver reports
9. Worked Extensively on OBIEE Administration Tool, OBIEE Presentation Services, Answers, Interactive Dashboards and BI Publisher.
10. Strong knowledge of RDBMS databases like Oracle 10g/11g, MS SQL server 2000, IBM DB2 8.2
11. Strong Knowledge in Oracle SQL queries Performance tuning using Explain plan.

Technical Skills Summary:

1. Packages Oracle EBS: R12/11.5.10, HP Quality Center,
2. BI Tools Siebel Analytics 7.X, OBIEE 10.1.3.X, 11.1.1.X& BI Applications 7.9.X
3. Relational Databases Oracle 9i/10g/11g, SQL Server 2000/2005,
4. Operating Systems Win XP/2003/2008 Win 7, Windows NT/98 & UNIX (Linux)
5. Programming Languages C, C++, SQL, PL/SQL, VS COBOL II, Core JAVA, Shell Scripting
6. ETL Tools Informatica Power Center 8.6/8.1, DAC 7.x
7. Web Technologies HTML, XML
8. Database Tools TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer
9. Web Services Oracle BPEL, ESB, JDeveloper 10.1.3.3, 10.1.3.4

OBIEE Developer, Confidential, MA
CVS Caremark is a strong, growing company guided by the corporate values of accountability, respect, integrity and teamwork supporting the colleagues. CVS Caremark is a Fortune 18 company with 200,000 employees and over $100B in revenue. It is the only fully integrated pharmacy health care company in the United States. It offers entire spectrum of pharmacy care allow us to provide greater convenience and choice for patients, improve health outcomes, and lower overall health care costs for plan sponsors and participants.
Responsibilities:

1. Used the OBIEE 11.1.1.x Administration tool to develop and enhance meta-data.
2. Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
3. Involved in setting up methods of usage tracking using Direct Insertion and setting up Log File. Merged the Usage Tracking Repository with the main repository (.rpd) to have dashboard based usage tracking.
4. Worked extensively with Physical Layer, Business Layer and Presentation Layer.
5. Implemented user security authentication using LDAP server directory
6. Involved in performance tuning for BI server and Oracle SQL queries.
7. Worked Extensively on Oracle Answers, Dashboards and Delivers to create reports.
8. Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
9. Performance Enhancement of the data ware house using indexing, partitions and running statistics.

Environment: OBIEE 11.1.1.X, Siebel Analytics 7.8, DAC 7.9.5, ORACLE 11g, SQL, TOAD, PL/SQL,DB2, BI Publisher, XML, Oracle Reports, UNIX.

Confidential,MA Aug 2007 – Dec 2010
OBIEE Developer
Verizon designs and manufactures the state of the art fiber optical communication products like cables and wires. The company mainly deals with four main products like Data, Video, Telephony, Voip. NRSC project main aim is to develop a new data warehouse for the company using Oracle’s out of box solution packaged with OBIEE and Informatica and thereby creating the reporting environment from OBIEE that helps the end users to analyze the reports.

Responsibilities:

1. Installed and configured complete suite of OBIEE 10.1.3.X in test and development environment on windows platform.
2. Worked closely with business users in the client side and designed the system accordingly.
3. Created the new RPD and detail level drill downs to as per business requirements using OracleAnswers.
4. Worked extensively on OBIEE Administration tool and Presentation Services.
5. Worked on the different layers in the data model (Physical, Business and Presentation).
6. Involved in gathering and analyzing requirements and documenting them for further implementation.
7. Created Session variable, Repository variable in RPD and used the same for role based security andDynamic calculation in OBIEE answers.
8. Customized Repository (RPD) to work with other EBI systems. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
9. •Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
10. Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
11. Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
12. Developed different Dashboards/Reports with different view( Calculation, Detailed, Pivot, Charts, Filters) using the Presentation services.
13. Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility.Scheduled reports to be e-mailed using iBots.
14. Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
15. Developed process for object level migration of web catalog, for post production release of - enhanced and bug fixed reports.
16. Worked with both migrations of the Development and QA environments.
17. Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
18. Performed Unit Testing and worked with the end user at various stages of the test cycles.
19. Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment:
OBIEE 10.1.3.4, Oracle Answers 10.1.3.4, Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Navigator, Web Logic 8X, Windows XP Professional.
Confidential,CT Aug 2005–Sep 2007
Informatica / BI Developer

Priceline is the leading travel services provider. Priceline-branded Web sites feature airline tickets, hotel reservations, car rental, cruises, and many other in-destination services from a broad selection of partners. Denali data warehouse incorporates data from various sources first into LZ staging area and then into ADS data warehouse and finally loading into Finance data mart.

Responsibilities:

1. Worked closely with the business experts to understand the source data.
2. Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
3. Developed and Implemented ETL processes using Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer.
4. Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
5. Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
6. Created reusable transformations, mappings and mapplets using Informatica Designer.
7. Designed and developed complex mappings using various transformations in Designer to load data from Oracle, Flat files into the target Oracle data warehouse.
8. Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
9. Created Report, dashboards, Answers Query.
10. In Workflow Manager created sessions, tasks, and workflows etc.
11. Used Mapping Parameters and Mapping Variables.
12. Identified and created aggregate tables to improve query performance.
13. Mapping in data sources using Siebel Analytics Admin tool to create repository.
14. Created technical documentation for mapping from source to target.

Environment: OBIEE 10.1.3, Informatica Power Center 8.6, UNIX Shell Scripting, Autosys, Toad, Perforce and SQL Server.

Confidential,NJ January 2006 – July 2006
QA Engineer

Wall Street Journal is an online business newspaper. The redesign of Online Journal provides powerful new personalization tools and an all-new site that makes it faster, easier and even effortless to get the news you need. Customers will also be able to create their own customized home page with one-click access to your personal collection of relevant information. This project involves Manual Testing of Web based Internet Application WSJ.COM that provides Stocks, Quotes&Mutual funds information. This application has modules like Today\\\'s Markets, Companies, Industries, Breaking News, Columns, Topics, Deals, Search, Quotes and Research. It has 3 type editions (US, Europe, Asia). The default WSJ.Com Edition is U.S; depending upon the type of Edition the News\\\'s Articles are displayed. WSJ.Com has two types of User\\\'s: Recognized and Unrecognized. Recognized (Subscribers) users can only see wholes site.

Responsibilities:

1. Performed Black Box Testing.
2. Developed Test Cases from Business and Technical Specification wrote them in Test Director
3. Execution of generated Test Cases Manually in Test Director
4. Performed Functional, Regression and System Testing
5. Maintained defect tracking and reporting using Test Director
6. Performing Cross Browser, Configuration and Content testing
7. Performed testing of the application on different versions of Internet Explorer, Netscape, AOL in
8. diverse environments including Windows 98/NT, Unix and MAC
9. Identified new performance issues with the web site that appeared in the new version.
10. Developed automation test scripts with WinRunnerfor Functional testing of the application
11. Regression testing done with WinRunner
12. Test scripts Involved in writing performance test plans, Designing the TPS Calculations
13. Involved in Designing the LoadRunner Scenarios.
14. Provided recommendations to the application on steps to meet performance goals.

Environment:WinRunner 8.0, LoadRunner 8.0, Test Director 8.0, Oracle, JAVA, HTML, XML,
Java Script, Java Servlets.

Confidential,MN February 2005 – February 2006
QA Tester

Blue Cross Blue Shield of MN is one of the largest healthcare providers in MN. As a QA Tester, I was involved in testing Healthcare web applications; Membership, Provider and Claims processing applications.

Responsibilities:

1. Analyzed user requirements by interacting with developers and Business Analysts.
2. Involved in testing functionality of the application.
3. Responsible for creating of automation test scripts using WinRunner.
4. Conducted End-to-End system testing.
5. Maintain and responsible for the issues related to Bugs.
6. Involved in testing Healthcare claims applications.
7. Written test cases and performed Manual Testing like Validation and Verification Testing.
8. Performed functional testing for the application using WinRunner.
9. Performed regression testing for all types of credit/debit card transactions.
10. Performed Performance/Load/stress/volume testing on the application using Load runner.
11. Developed Virtual user test scripts using Load runner.
12. Developed and executed scenarios using Load runner.
13. Testing financial institution specified formats Ex. Visa, Master, Amex, JCB, Discover and Diners.
14. Responsible for reporting defects using ClearQuest® defect tracking system

Environment:Load Runner 7.51/7.5, WinRunner7.5, QTP, TestDirector7.6, JAVA, J2EE, Web logic, JavaScript, Oracle11i/8i, Windows2000 and UNIX.

Education:

1. MBA in Progress
2. B SC in Computer Information Systems

Awards & Achievement:

1. Oracle Certified Professional
2. A+ (Metrix)
3. Dean’s List
4. Employee of the Month, five months in a row while with Verizon
5. Received “Associate of the Month” in short period in Dow Jones.