SUMMARY:

• 9 years of Software developer experience in Business Intelligence Applications using Oracle Business Intelligence OBIEE / Oracle Business Intelligence Apps BI Apps Siebel Analytics expert.
• Expertise in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE/BI 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.
• Experience in Dashboard Report designing/Developmental skills in variety of BI tools including Tableau, Qlikview.
• Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• OBIEE metadata RPD design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules.
• Great experience in designing and developing repositories using Star Schema/Snowflake.
• Good expertise in OBIEE Metadata development with Administration, Multi User development environment /architecture, Migration, deployment, applying patches, maintenance with Dimensions, Hierarchies, Measures, Aggregation
• Strong knowledge on Databases like SQL Server 2005/2000, Oracle DB2.
• 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 .
• Experience with XML, XSLT and MDM will be a plus
• Worked closely with Users, Developers and Administrators to resolve ongoing issues.
• Strong aptitude for learning and understanding business process and needs with little direction and achieve quality results independently.

TECHNICAL SKILLS: BI : OBIEE 10.1.3.2/ 10.1.3.3/ 10.1.3.4/11g,QlikView, Tableau, 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, DB2, Microsoft SQL SERVER 2000, 2005 Tools : Clear case, Visual Source Safe OS : Windows 95/98/2000/XP, UNIX, Linux WORK EXPERIENCE: Confidential

Sr. OBIEE Developer

Responsibilities:

• Complete requirements analysis, by helping to capture, document and prioritize the customer's business and technical needs.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer in OBIEE Repository.
• OBIEE metadata RPD design and development - including design and definition of logical tables, physical sources, dimensions, columns and aggregation rules.
• Created and complete testing of repository, reports, dashboards and analytics to ensure they meet documented business requirements
• Designed Star 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/architecture and established relationships Foreign Keys Physical Logical between tables.
• Created business reports using BI Scheduler as per requirements.
• Great experience in designing and developing repositories using Star SchemaSnowflake.
• 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 Single Sign Multi Sign on 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.
• Troubleshoot Production issues, identify root cause and migrate fixes. Develop reporting standards and best practices to ensure data standardization and consistency.
• Create and complete testing of performance of reports, dashboards and analytics to ensure they meet documented business requirements
• Proactively communicate issues to team to assist in managing defects
• Create, maintain, and manage documentation for all data warehouse and reporting development effort
• Create and implement a long term storage and business continuity strategy including backup recovery and data storage and archiving.
• Installation, configuration, administration and maintenance of OBIEE platform on Windows.
• Customization/Branding of OBIEE as per company's branding guide
• Development of OBIEE reports/dashboards for mobile devices/iPads with Qlikview.
• Drive the business area to identify and execute on opportunities to positively impact business results.

Environment: OBIEE 11g, BI Apps 7.9.6.3, Siebel Analytics, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL Plus, Java, Unix/Linux, Windows XP, Qlikview.

Confidential

OBIEE Developer

Responsibilities:

• Full project life cycle implementation for Siebel Business Analytics Warehouse. Involved in business requirements gathering and translated the requirements into technical requirements. Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment. Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects. Developed Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters using Oracle BI Presentation Services. Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Created workflows for full load and incremental loads to be used by DAC. Assembled subject areas and created execution plan and accommodated the new
• Informatica mappings. Documented all the configurations and new reports creation and published it to the
• end users. Involved in the preparation of Technical design documents, Source to target S2T
• document, Review checklist and Technical Specifications. Created proper documentation to describe program development, logic, coding,
• testing, changes and corrections.

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, QlikView, JavaScript, Windows XP. Confidential

OBIEE/BI Apps Developer

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 Install 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.

Confidential

OBIEE Software Developer/Business Analyst

• 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
• 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 and Brokers
• 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.
• 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, DB2, RUP, SDLC, Use Cases, QC.

Confidential

Business Analyst

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, SQL Server, Rational Requisite Pro, Windows..

Confidential

Business Analyst

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, Tableau, SDLC, Use Cases, and Quality Center.