SUMMARY:

• Over 8 years of IT Experience, in the field of OBIEE 11.x /10.x / Siebel Analytics 7.x.
• Extensive experience in developing Siebel Analytics Repository at three layers (Physical Layer, Business Model Mapping & Presentation Layer).
• Experience in Oracle 9i/8i/10g/11g - design and developing Stored Procedures/Packages, Database Triggers, Cursors using SQL, PL/SQL
• Experienced in providing end-to-end business intelligence solution, all the way from building Siebel Analytics Repository till building Answers, Delivers, and Dashboards.
• Expertise in understanding data model like star and snowflakes and data warehousing concepts, also familiar with transaction systems like ERP, CRM.
• Extensive experience in creating Connection Pools, Time Series Objects, Authentication using LDAP, External Tables, configuring Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports, Filters, Prompts), scheduling iBots and Alerts using Siebel Analytics Delivers.
• Proven experience configuring Interactive Dashboards with drill-down capabilities using page and dashboard prompts, filters, implementing Security in repository and catalog level, creating hierarchies.
• Experience in setting up a Multi-User Development Environment (MUDE).
• Used Oracle business intelligence scheduler, an extensible scheduling application for scheduling reports (iBots and alerts) to be delivered to users at specified times.
• Experience with the Oracle EBS (OBI 9.6.x Apps): Financial, Supply Chain & Order Management, Sales, Marketing, Service Modules and Project Analytics in particular and DAC (Execution Plans, Subject Areas, Containers, Design, Setup, and Execute etc.).
• Worked with BI publisher 10g/11g, created and managed highly formatted reports for a different data sources (ERP, CRM etc.)
• Worked with newly introduced features in BI Publisher 11g: building new data models and creating and editing new report layouts within the BI Publisher interface
• Experienced in design and development of PL/SQL Stored Procedures, Functions, Cursors, Packages and Triggers.
• Experienced in writing complex SQL queries (Materialized View, Inline views, Sub Queries).
• 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
• Experience in developing Informatica Mappings using various Transformations and Oracle PL/SQL for ETL of data from multiple sources to Data Warehouse.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel, Analytical Dashboards / Reports.
• Responsibilities handled include requirement study, functional study, system analysis, programming, testing and implementation support.
• Results oriented, hardworking, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

TECHNICAL SKILLS:

Reporting tools: OBIEE 10.1.3.X/11.1.1.X and Siebel Analytics 7.8.x/7.7.x/7.5.x

ETL Tools: Informatica Powercenter 9.x/8.x/7.x/6.x, DAC 10.1.3.x

Database: Oracle 11g/10g/9i/8i, SQL Server, MS Access.

Languages: SQL,PL/SQL, C, C++

Operating System: Windows 95/98/2000/XP/8.1, Windows NT, UNIX, Sun Solaris, LINUX

Database Admin Tool: TOAD eclipse, SQL Plus 10.x/ 9.x/ 8.x., SQL Developer, DB Visualizer 6.0

PROFESSIONAL EXPERIENCE:

OBIEE / BI Apps Developer

Confidential - Fountain Valley, CA

Responsibilities:

• Marketing Campaign Loading, Campaign Scheduling And Launch Process To Load And Launch Test Campaigns With Seed Data.
• Understanding of Marketing Terminologies Treatment, Template, Wave, Allocation, Mta, Seed List Program and Campaign Designing
• Marketing Functionalities Such As Dynamic Content, A/B Testing, Purl, Merge Fields working In Trouble Shooting Campaign Loading and Launching Errors. Support Siebel Marketing Application, With Solid Background in Performing Siebel Marketing Administration Functions
• Working In Database Concepts, Logical/Physical Design and Development with the Understanding of Data Warehouse /Business Intelligence Concepts.
• Working On Informatica Etl Jobs On Data Transformation To Olap Database
• Working In A Pl - Sql Environment and Familiarity with MS Sql, Oracle Databases.
• Working on Obiee Marketing Dashboard Canned Reports &; Ad-Hoc Reports.
• Create Test Plan, Approach And Test For New Enhancements On Siebel Marketing Module.

Environment: Oracle Data Integrator ODI 11g OBIEE 11g/11.1.1.9, Siebel Analytics, Siebel CRM, OBIA 11.1.1.9, Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX, Cognos 10, Micro strategy 10.0x

OBIEE / BI Apps Developer

Confidential - Sunnyvale, CA

Responsibilities:

• Worked closely with the business community to assess business needs, define requirements and Implement solutions.
• Analyzed the reports developed in Micro Strategy tool and extracted the SQLs from the reports.
• Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
• Created various data marts from data warehouse and generated reports using Cognos
• Design OBIEE Answers and Intelligence Dashboards. 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.
• Developing Business Objects reports using Universe and BICS.
• Administration of OBIEE 12c by configuring Active Directory Authentication
• Implement Marketing Analytics module from Oracle BI Apps.
• Implement new data modeling and new hierarchies on the existing marketing module as per client requirements.
• Redefine hierarchies in Marketing Accounts and contacts as per client requirement.
• Map the tasks to execute mappings in Informatics.
• Modified mappings as per the changed business requirements.
• Implemented security based on LAP Authentication.
• Worked during the whole life cycle of the project from requirements gathering to deployment.

Environment: Oracle Data Integrator ODI 11g/12c, OBIEE 11g/ 11.1.1.7/12 c, OBIA 11.1.1.7.1 , Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX, Cognos 10, Micro strategy 10.0x

OBIEE 11g Developer/ BI Apps Developer

Confidential - Edison, NJ

Responsibilities:

• Involved in business requirements gathering and translated the requirements into technical requirements.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Windows Environment.
• Developed mappings in Informatica to load the data from various sources into the Data warehouse different transformations like Source Qualifier Expression, Lookup, Aggregate, Update Strategy and Joiner.
• Analyzed the reports developed in Micro Strategy tool and extracted the SQLs from the reports.
• Kimball dimensional modeling, OLTP and OLAP database designs and implementation strategies.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• 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: OBIEE 11g/11.1.1.7, OBIA 11.1.1.7.1 , ODI 11g/12c, Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX, Cognos 10, Micro strategy 10.0x

OBIEE/BI Apps Developer

Confidential - New Haven, CT

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.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Developed and tuned all the Affiliations received from data sources using Oracle and Informatica and tested with high volume of data.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle and Informatica Power Center.
• 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.
• Developed BI Consumer reports using OBIEE 11g.
• Expertise in segmentations and scheduled programs on daily basis.
• Expertise in SQL check and List pulls.
• Proficient in using Xcelsius tools.
• Developed new Informatica mappings for enhancement and bug fixes for various brands as per various requirements.
• Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
• Added new facts and Dimensions to the OBAW and created new execution plan in DAC for dial load into these table.
• 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: ODI 11g/12c, OBIEE 11g/ 11.1.1.7/12 c, OBIA 11.1.1.7.1 , Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX.

OBIEE Developer

QSSI - Washington, DC

Responsibilities:

• Work with end users to understand business process of Credit Union and gather requirements for the necessary reports.
• Analysis of business requirement to define KPIs (Key Performance Indicator).
• Designed the RPD and defined the Subject Areas.
• Customized Oracle BI Repository defining Physical Data Layer and developed Business Model and Presentation Layer using Administration Tool.
• Prepare technical design documentation of all the necessary aggregates, KPIs which needs to be configured in fact dimension.
• Implemented data level and object level securities.
• Designed the implementation of ETL and OBIEE for various Modules like incentives, loans and cross sales.
• Worked with different groups in organization to understand their business requirement and give valuable suggestions for reports and dashboards.
• Create groups for different users to provide suitable securities for different dashboards and reports.
• Designed the layout for different dashboards and reports.
• Managed day - to-day .rpd, Scheduler & iBots.
• Implemented BI Publisher and created business reports using BI Publisher.
• Configured Database to authenticate users against Microsoft Active Directory.
• Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
• Extensively used Informatica to load data from wide range of sources such as flat files (CSV, fixed length), Oracle to Oracle.
• Extensively worked with performance tuning of the mappings, sessions and Stored Procedures.
• Developed re-usable transformations, mappings and Mapplets conforming to the business rules.
• Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes.

Environment: OBIEE 11g/ 11.1.1.7/12 c, OBIA 11.1.1.7.1 , Oracle 11g/10g, Oracle Data Integrator ODI 11g/12c, SQL Plus, TOAD, WinNT/7 and UNIX.

11g Developer

Confidential - Corona, CA

Responsibilities:

• Worked closely with the business community to assess business needs, define requirements and Implement solutions.
• Interacted with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
• Design OBIEE Answers and Intelligence Dashboards.
• Implement Marketing Analytics module from Oracle BI Apps.
• Implement new data modeling and new hierarchies on the existing marketing module as per client requirements.
• Customized BI Repository defined Physical Data Layer and developed Business Model and Presentation Layer using BI Analytics Administration Tool and using OBIEE.
• Configure DAC and create containers, subject areas and tasks.
• Customized the repository and created new requests using Answers.
• Managed day - to-day rpd, Scheduler & iBots
• Worked on creation and configuration of BI dashboards, customized reports and charts (like Sales, Service and marketing), in BI Answers.
• Redefine hierarchies in Marketing Accounts and contacts as per client requirement.
• Map the tasks to execute mappings in Informatica.
• Extensively used Transformations like Lookup, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy.
• Modified mappings as per the changed business requirements.
• Developed UNIX and PL/SQL scripts to automate chronological loads.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.

Environment: OBIEE 11g/ 11.1.1.7/12 c, OBIA 11.1.1.7.1 , Oracle 11g/10g, SQL Plus, TOAD, WinNT/7 and UNIX.

BI Analytics Developer

Confidential - Bethesda, MD

Responsibilities:

• Responsible for delivery of quick fixes and enhancements to BI customers in the form of Fix packs.
• Developed End - to-End Reporting Solutions.
• Installation and Configuration of DAC (Data warehouse Application Console) for multi OLTP regional instance environment.
• Used DAC client to load the custom mapping to the warehouse.
• Direct Interact with different QA teams and program managers located at different locations in onshore and offshore before delivering fix packs to customers ensuring quality of fix packs.
• Created/Modified Workflow Process.
• Developed mappings by extensively using Informatica Transformations like Lookup, Filter, Expression, Aggregator, Joiner etc.
• Extensively involved in designing the workflows, worklets and involved in designing sequential and concurrent sessions using workflow manager.
• Created Reusable Transformations and Mapplets in the Designer using Transformation Developer and Mapplet Designer Tools. Created and Monitored Workflows and Sessions using Informatica Workflow Manager.
• Customized the application using BI Tools configuration in Data, Business and User interface layers.
• Involved in unit testing and integration testing of all the mappings, workflows, schedules.
• Configured BI Web Components including BI Answers and Intelligence Dashboards.
• Created Logical Columns based on other Logical and Physical columns in the BMM layer.
• Customized users, groups and assign privileges for the users to access the data from the warehouse.
• Customized the repository and created new requests using Answers.
• Created and configured the BI dashboards, customized reports and charts (like Sales, Service and marketing), in BI Answers.
• Created Workflow Process, Workflow group and policy conditions to handle bounce backs.
• Developed UNIX shell and PL/SQL scripts for pre & post session processes to automate daily loads.
• Provided production support for applications.

Environment: 10.1.3.4, Informatica Power Center 8.6, DAC, Oracle 10g, PL/SQL, Oracle SQL, Toad, UNIX.

Oracle Developer

Confidential

Responsibilities:

• Involved in user requirement and requirement specification from users.
• Documenting business requirements, functional specifications and test requirements.
• Identified the key facts and dimensions necessary to support the business requirements.
• Prepared prototype models to support the development efforts.
• Developed various complex SQL queries, stored procedures, functions, packages and Database triggers.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages
• Developed Unix Shell scripts to automate repetitive database processes and maintained shell scripts.
• Provided input into updates and modifications of the product documentation and support the testing team to deliver the highest product quality to the customers.
• Involved in analysis, estimating, design, development, testing, and 24 x 7 production support.

Environment: Oracle 1Og, Oracle SQL, PL/SQL, Windows 8, UNIX, SQL