SUMMARY:

• 9 years of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE / Oracle Business Intelligence Apps BI Apps and 3 years of BA expert.
• Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE/OBIA in Marketing, Sales, Procurement modules.
• Expertise in Building Executive Dashboards using Dashboard Manager for Siebel Analytics Web / Oracle Presentation Services for OBIEE Dashboard developer with ad-hoc reports on OBIEE 11g.
• Lead and participate in gathering business requirements, analysis of source systems, and define underlying data sources and transformation requirements and Business Intelligence Reporting using OBIEE 11g.
• Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Expert in designing, development, and implementation of Oracle BI Apps.
• Great experience in designing and developing repositories using Star Schema.
• Good expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation
• Expert on OBIEE 11G reports design and development including RPD, Metadata development with OBIEE 11G Map viewer OBIEE Publisher with HIPPA rules.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Expert in writing SQL queries for SQL server and other data bases.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution data warehouse load .
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Strong aptitude for learning and understanding business process and needs with little direction and achieve quality results independently.
• Great experience working with offshore team members.

TECHNICAL SKILLS:

BI : OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/11g,BI Publisher, Map Viewer, DAC 7.x,Siebel Analytics 7.8 ETL : Informatica Power Mart, Informatica Power Center 9.x/8.x/7.x/6.x Languages : SQL, PL/SQL, HTML, Java/JavaScript, Web services, C, C , C , XML Databases : Oracle 11g, Microsoft SQL SERVER 2000, 2005 Tools : Clear case, Visual Source Safe OS : Windows 95/98/2000/XP, UNIX, Linux WORK EXPERIENCE: Merck, NJ Nov12- Till Date

Work Summary

OBIEE Report Developer

Responsibilities:

• Building the business and presentation layer within OBIEE to meet the business requirements of the project
• Complete requirements analysis, by helping to capture, document and prioritize the customer's business and technical needs.
• Installed, Contribute to the design and implementation of the metadata and/or reporting components of the solution. This includes testing and, at times, deployment of the components Worked extensively with Physical Layer, Business Layer and Presentation Layer. Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements. Built Business model and established relationships Foreign Keys Physical Logical between tables. Created business reports using BI Answers as per requirements. Generated various ad-hoc Reports and working with OBIEE 11g dashboard developer.
• Great experiencein designing and developing repositories using Star Schema.
• Identified the aggregate levels for each source and created dimension sources for each level of Business Model development with Dimensions, Hierarchies, Measures, Aggregation.
• Added users and configured security in web logic console of OBIEE 11g. Managed security privileges for each subject area and dashboards according to user requirements Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse. Worked closely with BA to determine feasibility and determine LOEs
• Create and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements
• Proactively communicate issues to team to assist in managing defects
• Expert in designing development and implementation of ORACLE BI Apps.

Environment: Siebel Analytics 7.8.4, BI Apps 7.8.4, Informatica 7.1, Oracle 10g/9i, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL Plus, Unix, JavaScript, Windows XP. Pfizer Inc, NJ Feb10 -- Jan12 OBIEE/BI Apps Developer Consumer Experience Management CEM HUB is a project which involves gathering information from various marketing strategies developed by Epsilon team and the Task Force Team. Using this information certain groups are targeted, in turn increasing the hit ratio and reducing the expenditure spent on campaigns. Responsibilities: Full project life cycle implementation for Oracle Business Analytics Warehouse OBAW Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities, Project Execution Plan and Resource Plan. Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area. Expertise with Siebel Base tables and EIM workflows. Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model. Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool. Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships Foreign Keys Physical Logical between tables Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement. Created executive level Reports and Dashboards catering to provide insight into the sales / marketing data. Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards. Expertise in segmentations and scheduled programs on daily basis. Expertise in SQL check and List pulls. Proficient in working with HP Service center and Quality center. Worked in production support and seen through the phase of the developments in the production and done various bug fixes. Environment: OBIEE 10.1.3.3./11g, BI Apps 7.9.6,Informatica 8.0, Oracle 10g, SQL, PL/SQL, DAC, TOAD, SQL Plus, Windows XP. AIG, NJ May09 Nov09

Confidential

OBIEE Developer/Business Analyst

• AIG deals with both Commercial and Personal Lines of Insurance auto, home, excess liability, collections . It involves in various insurances like Property and casualty, Group Benefits for Small Business and Large Businesses in USA Canada.
• Responsible for analyzing and translating business requirements for the development of business rules for Commercial and Personal Lines of Insurance business units
• Actively involved in gathering and preparation of technical and business documentation for the application in design, which could serve as future reference to the programmers and system developers
• Conduct workflow, process diagram and gap analysis to derive requirements for existing systems enhancements
• Experience with SAS Campaign Management BI tools
• Mapped data elements from Mainframe system to Relational database as a part of data analysis
• Assisted the Project Manager in setting project expectations, in evaluating the impact of changes on the organization and conducted project related presentations
• Conducted user interviews and gathered business requirements using JAD sessions with SMEs, Managers andBrokers
• Responsible for identifying and documenting business rules and creating detailed Use Cases
• Responsible for automating the Corporate Actions Department so as to send and receive the notifications to/from clients.
• Supported the development of the test plan and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Involved in Joint Application Development JAD sessions to define technology applications for business requirements.
• Assist in development of training materials for new technology and process improvements.
• Acted as a liaison between the technical, businesses and testing groups to provide them with required specifications/documentation and to resolve any issues in between.

Environment: MS-Office, JAD, UML, SAS, SQL, Data Analysis, RUP, SDLC, Use Cases, Quality Center.

OBIEE Report Developer

Confidential

• Worked closely with project managers, business users and developers to formalize a business idea and define requirements using rational requisite pro. Analyze gathered requirements data, verify requirements and create functional specifications FRD/FRS . Gathered requirements for building a sub-ledger that hosted day to day trading activities of various hedge fund clients and assist in reporting and accounting. Mapped data between Sybase to Sybase, Sybase to Oracle databases to assist in analysis and development phases of Client Sub Ledger project. . Created Requirement Traceability Matrix to make sure the current project requirements are being met. Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT. Acted a project manager/business analyst for the Buy-In project and build a new application using service oriented architecture SOA and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC for post settlement date clearings. Managed enhancements and defects promptly to assist the operations in resolving issues. Environment: Use Cases, SQL, UML, JAD, Quality Center, Java, XML, FTP, MS-Office, Windows, Rational Rose, Rational Requisite Pro, Windows..

Confidential

Business Analyst

• Project was developed to integrate multiple test results from different legacies Data Migration from Multiple projects to populate the data on GiveLife.org DRM web based application. Donor Relationship Management DRM isa commercial off-the-shelf, web basedapplication.
• Developed business requirements and process workflows Managed the development of a reporting capability of current and historical fund performance prices made available on restricted web sites for viewing by client customers. Defined requirements for a daily feed of fund performance data from the fund data warehouse, coordinated systems testing, and supported UAT. Well Versed with Configuration Management. Gathered requirements and managed the implementation of a private, secure ftp site allowing authorized print vendors to download files containing sensitive shareholder information Environment: MS-Office, Siebel, SDLC, Use Cases, and Quality Center.