SUMMARY

• Over eight years of experience in obtaining Business Requirements, Analysis, Design, Development, Testing, and Documentation of various functionalities of Data Warehouse, Data Marts, and Business Intelligence
• Extensive BI and Data warehousing experience using OBIEE 11.1.1.x/10.1.3.x, OBIA 7.9.6.x/7.9.5.x, Siebel Analytics 7.x, Informatica 9.x/8.x/7.x, DAC 10.1.3.4, SQL and PL/SQL
• Strong expertise with Informatica PowerCenter with strengths in integration throughout various platforms
• Experience in Installation and Configuration of OBIA (including Informatica, DAC, and OBIEE)
• Customizing OBIA “Out of Box” Reports by conducting Business Analysis, Technical Analysis, and RPD Modifications
• Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers, and iBots with OBIEE Applications
• Developing Dimensional Hierarchies, Creating Aggregate Measures, Aggregate Tables, New Logical Columns, Filters, Variables, Time Series Functions, and several business related requirements
• Proficient in configuring security settings at various levels both in Repository Level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog Level
• Experienced in integrating LDAP Server for authentication of users and working in Multi User Development Environment (MUDE)
• Experienced in developing reports & dashboards in OBIEE (BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office)
• Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting
• Configured, designed, and developed BI Publisher reports by integrating them with Microsoft Office application according to client’s requirement
• Experienced in migration techniques for OBIEE, Informatica and DAC components into various test and production environments
• Experience using OBIEE 11g, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog
• Extensive knowledge and understanding of upgrading and implementing OBIEE 11g
• Extensive knowledge and understanding of relational databases, meta data, data warehousing concepts, and querying tools (Oracle, SQL Server, etc.)
• Skilled in data warehouse methodology, data analysis and modeling, business intelligence architectures, report development, ETL development and database design
• Created test cases and tested the reports/dashboards by comparing the SQL Output on the data warehouse to the values in the reports/dashboards, documented the test results
• Experienced in designing and testing mappings, mapplets, and workflows using Informatica Power Center
• Experience and strong working knowledge with Oracle EBS and People Soft Modules of Financial Analytics, Procurement and Spend Analytics, Sales Analytics, Project Analytics, Marketing Analytics, HR Analytics, HCM Analytics, and Supply Chain modules
• Worked with different subject areas including AP, AR and GL to create reports and dashboards according to the business requirements
• Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects
• Excellent written and verbal skills, including technical documentation
• Quick at learning and applying new technologies and improving existing processes

TECHNICAL SKILLS

BI Tools: OBIEE 11g/ 10.1.3.2/3.3/3.4 g, Discoverer, Essbase Oracle BI Publisher 10g/11g, Siebel Analytics 7.5/7.7/7.8, Business Objects XIR3

Data Warehousing: Informatica Power Center 9.x/8.x, MDM, IDQ, Grid, HA, BODI, BODS, ETL

Dimensional Data Modeling: Data Modeling, Dimensional Data Modeling, Star Join Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling.

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, Metadata, and System Integration

Databases: Oracle 11g/10g/9i, MS SQL Server 2000/2005/2008 , Teradata

Environment: Windows: NT, 2003, XP, 7, 8, and Microsoft Office Mac OSX: 10.4 - 10.9 Additional: Linux, UNIX

Methodologies: Agile, Scrum, and Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

Sr. OBIEE 11g Administrator/Developer & Informatica Developer

Responsibilities:

• Created a functional and scalable data warehouse used to aggregate financial metadata while implementing Oracle best practices
• Effectively worked with the financial end users for requirement gathering and defining specifications
• Worked extensively with the physical layer, business layer, and presentation layer
• Managed a team of 12-15 on-site/off-shore Oracle and Informatica developers
• Created pdf, excel, and interactive reports using BI Publisher (BIP) and integrated reports with OBIEE
• Utilized bursting capabilities of OBIEE agents and BI Publisher scheduler to deliver reports on schedule
• 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
• Administered and developed ETL solutions using Informatica PowerCenter, Grid, HA, B2B, Cognos Data Manager, and IBM DataStage
• Integrated Informatica with Web Services for SSO Oracle database and financial applications
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• 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 On (SSO) for users in development environment leveraging analytics repository
• Utilized Informatica mapping designer to create/update mapping using different transformations required to move data into data warehouse
• Administered various OBI Apps including OBIEE, Discoverer, OFSAA, and Essbase
• 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.
• Monitoring incremental & full load through DAC
• Conducted User Acceptance Testing (UAT) throughout project deliverables
• Responsible for installing, configuring, developing, support and maintenance of the BI apps
• Created OBIEE 10g/11g repository (.rpd) which involved schema import and implementing business logic
• Administered a team of on-site and off-shore clients in both OBIEE and Informatica development

Environment: OBIEE 11g, OBI Discoverer 11g, Informatica 9.0.1, MDM, B2B, HA, Grid, Cognos Data Manager, IBM InfoSphere DataStage, BI, Apps, ETL, Web Logic Server, Oracle JDeveloper, Oracle 11g, SQL, PL/SQL, SQL*Plus, DAC 7.x, TOAD, Unix, BODS, CRM, OFSAA, Java, Teradata

Confidential, Weston, MA/Philadelphia, PA

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined specifications documents
• Configured and developed OBIA Financials, Supply Chain, Procurement and Spend, and HR modules
• Extensive experience and knowledge in processes regarding HIPPA compliance, the Affordable Care Act (ACA), and Health Care Reform (HCM) policies and practices
• Managed a team of 8-10 on-site/off-shore Oracle and Informatica developers
• 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
• Created pdf, excel, and interactive reports using BI Publisher (BIP) and integrated reports with OBIEE
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates
• 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 On for users in development environment leveraging analytics repository
• Administered Informatica to integrate internal web applications through Web Services
• Created workflows for full load and incremental loads to be used by DAC
• Assembled subject areas, created execution plans, and accommodated the new Informatica mappings
• Administered and developed ETL solutions using Informatica PowerCenter, Cognos Data Manager, and IBM DataStage
• Monitoring incremental & full load through DAC
• Conducted User Acceptance Testing (UAT) throughout project deliverables
• Responsible for installing, configuring, developing, support and maintenance of the BI apps
• Created OBIEE 10g/11g repository (.rpd) implementing the business logic
• Experience with onboarding users in eHealth Exchange and other “exchange” platforms
• Worked on reports on Oracle BI publisher 11.1.1.3 after migrating from 10.1.3.4.1
• Involved in setup and configuration of Oracle BI publisher 10.1.3.4.1
• Developed/Administered Informatica HA and B2B (Data Exchange and Data Transformation)

Environment: OBIEE 11g, Informatica 9.x, IDQ, MDM, B2B, Grid, HA, Cognos Data Manager, IBM InfoSphere DataStage,Oracle 11.2.0.2, SQL, PL/SQL, SQL* Plus, DAC 7.8.4, ADF, Java, JSP, XML, Teradata

Confidential, Wilmington, DE

OBIEE 10g & Informatica Administrator/Developer

Responsibilities:

• Understanding the client requirements, source data, business objectives and key performance indicators
• Conducting retail and sales analytics to make sense of business performance by adding context to real- time business measure
• Interacted with business management representatives for gathering the reports/dashboards requirements and to define business and functional specifications
• Designing the technical design documents by understanding the functional design documents for sales performance
• Created pdf, excel, and interactive reports using BI Publisher (BIP) and integrated reports with OBIEE
• Identified the gaps by analyzing the data mart instance and provided alternative solutions as well recommended changes to database
• Analyze data components and metadata to document data strategy to identify key metrics for reporting
• Built the physical layer/logical layer/business model and mapping/presentation layer of a repository by using star schemas
• Responsible for installing, configuring and administration of OBIEE repository for physical, business model and presentation services
• Maintaining the full and incremental loads through DAC on different environments like development and test environment
• Developed financial analytics reports using OBI Discoverer and OFSAA
• Configuring the Analytics repository (.rpd) and implementing security to authenticate Oracle users
• Identified the facts, dimensions, and grain of the dimensional mode, and referential joins
• Used SQL loader to import data from large flat files and excel sheets to Oracle tables
• Built repository at 3 layers i.e., physical layer (connecting to data sources and import schema), business model/data mapping (create logical tables and data source mapping) and presentation layer level (create presentation catalogs)
• Created business facts & dimensions and defined logical relation between them in BMM layer
• Tested and implemented stored procedures, triggers, functions, and packages at database level
• Created dimensional hierarchies for the drill down functionality and implemented business logics for facts
• Worked with security of the application/solution to define users and groups, set permissions, group inheritance, authentication methods, query limits, timing restrictions, and filters
• Responsible for implementing OBIEE for the modules retail and sales
• Extensively worked on answers, created reports using different analytics views (pivot table, chart, column selector and table)
• Configured and scheduled BI Publisher scheduler for report bursting to file and email locations and used advanced reporting features such as online analyzer, excel analyzer and report security options
• Designed executive dashboards to provide business critical analytical view of the written sales for a set of power users
• Configured FTP rules in OFSAA and used T2Ts to transform data
• Create/manage repository/web users and groups and assigning permissions using OBIEE administration tool
• Designed and implemented Informatica Power Center and Grid for ETL to load target Oracle database
• Extensively used transformations like lookup, router, normalize, aggregator, source qualifier, joiner, expression and update strategy
• Performed unit, integration, and regression testing to validate reports and mappings

Environment: OBIEE 10.3.3.4.1 , OBI Discoverer, DAC 7.5, Informatica 8.6, Grid, HA, MDM, Oracle 11g, Windows server 2003, Unix, SQL DEV, SQL*Loader, CRM (SalesForce), Teradata, OFSAA

Confidential, Philadelphia, PA

OBIEE 10g & Informatica Administrator/Developer

Responsibilities:

• Created business areas, custom folders and registered PL/SQL functions in discoverer admin version
• Built custom reports using Oracle report builder 10g and integrated them with the application (based on the descriptive flex fields) to solve the client’s reporting needs
• Standard reports in INV module like customer item report, inactive item reports were enhanced according to the business needs
• Customized BI publisher reports as per customer’s specific requirements
• Customized expected receipts reports journal entries report and billing history report in account receivables using BI Publisher
• Developed a customized BI Publisher reports for on-hand-quantity available for all the items in every sub- inventory, which belonged to a particular organization in the inventory module
• Developed/converted most of the existing text reports to excel format using BI publisher
• BI publisher report development report templates formatting engine report output familiar desktop tools for layout customization
• Customized all the OBI dashboards, reports look and feel as per the business requirements
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page
• Administered both data level and object level security based on business requirements
• Tested and validated the repository reports and dashboards

Environment: OBIEE 10.1.3.4, BI Publisher, Informatica Power Center 8.5, Grid, HA, ETL, Oracle 10g, TOAD, MS SQL Server 2005, UNIX, Windows NT, Oracle SQL Loader, BODI

Confidential, Philadelphia, PA

OBIEE 10g Developer & BI Applications Specialist

Responsibilities:

• Worked with business analysts and analyzed the business requirements for developing the repository and extraction of reports
• Analyzed the specifications provided by the client, understanding the business
• Involved in rpd development, Oracle BI administration, Oracle BI answers, scheduling iBots and BI Publisher
• Designed star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary
• Created views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Specified dimensional hierarchy and aggregate levels for the dimensions
• Used filters (global and local) and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI answers
• Designed and configured intelligent dashboards in analytics for different groups of users, which include like managers, functional heads, and department heads
• Managed security privileges for each subject area and dashboards according to user requirements
• Used the catalog manager and maintained the analytics web catalog to manage dashboards & answers
• Worked in creating transformations and mappings using Informatica designer and processing tasks using workflow manager to move data from multiple sources into targets
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, sessions, tasks, etc.
• Build test cases and tested the reports/dashboards by comparing the SQL output on the data warehouse to the values in the reports/dashboards, documented the test results
• Performed unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected

Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1.1, Oracle EBS, Windows XP, UNIX AIX, Oracle 10g, SQL, PL/SQL