SUMMARY

• Over 7+ years of experience in OBIEE, Informatica (ETL), DAC and Siebel Analytics.
• Expertise in building the Data warehousing Model by planning, designing, developing and deploying various methodologies.
• Strong knowledge in SDLC implementation of various Business Intelligence and Data Warehouse/Data Marts, including gathering business requirements, proof of concept, GAP analysis, design/modeling (Star and Snow flake), development, implementation (Oracle AIM).
• Experience in designing the data flow from various applications to the Business Analytics Warehouse with the help of ETL tools.
• Strong experience in configuring interactive Dashboards with drill - down capability by making use of Filters, OBIEE security setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Folders, Reports).
• Experience in upgrading OBIEE 10g to 11g, and performing R12 implementation.
• Proficient in designing schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Expertise in designing and developing the repositories (RPD) and working on iBots.
• Experience in working in various JD Edwards EnterpriseOne (JDE) ERP system and designing the workflow to the analytics warehouse (OBAW).
• Strong working experience on the OBIA and SQL Server Integration Services (SSIS).
• Created, modified, and administered analytics Dashboards with links to web sites; HTML text; links to documents and embedded content, such as images, text, charts, and tables.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series and Caching.
• Extensively implemented security by creating roles and groups, check with external tables and LDAP.
• Experience in administering various OBIEE environments with large number of users and providing optimum system uptime and performance; designing security matrix, configuring authentication and authorization architecture, and providing permissions to users according to their role.
• Expertise in developing OBIEE repositories from scratch, and also many Reports/dashboards with different analytics views (drill-down/dynamics, cascading style sheets, pivot table, chart, column sector, tabular with local and global filters) using OBIEE Answers/Dashboard;
• Extensive experience working on various UNIX and Linux environments.
• Experience in configuring NQSCONFIG.INI file for usage tracking.
• Experience in developing different kinds of reports (pivots, charts, tabular) using global and local filters.
• Excellent knowledge in understanding dimensional modeling and relational database management systems.
• Good team player and also have ability to work independently in time sensitive environment.

TECHNICAL SKILLS

BI Tools: OBIEE 11.1.1, 10.1.3.2, 10.1.3.4, Siebel Analytics 7x (RPD & Webcat), OBIA, Answers/Dashboards, BI Publisher. Briefing book, iBots, Oracle EBS Discoverer, Oracle E-Business Suite

Languages: C, SQL, PL/SQL, HTML, XML, JAVA, J2EE, VB script, Unix Shell Scripting, TSL

Databases: ORACLE 11g/10g/9i/8i/8/7x, DB2 UDB V8.2, 9,9.5, MS SQL Server 2000, MYSQL, Sybase & MS-Access

Operating Systems: Unix, Linux, Windows NT/2000/2003 Server/XP.

ETL: Informatica Power Center 8.x/7.x, DataStage 7.5.1, & DAC

Database Tools: SQL Developer, SQL Navigator, TOAD, SSIS

Data Modeling: Erwin, Oracle SQL Data Modeler

Others: Star Team, PVCS Tracker, Visual Source Safe, Crystal Reports, TOAD,MS-Office, Visio, MS-Projects, VM Ware tools & CITRIX, Share Point, Web logic, OWB, ODI

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Sr. OBIEE Developer

Responsibilities:

• Extensively worked on building the Data warehousing Model by designing and implementing various methodologies.
• Worked on OBIEE 11g Administration tool in developing and enhancing the meta-data.
• Worked on JD Edwards EnterpriseOne 9.0 (JDE) ERP systems.
• Interacted with business representatives in gathering the reports/dashboards requirements and to define business and functional specifications.
• Analyzed, designed and developed ETL strategies and processes.
• Designed project scoping with other consultants to understand the project.
• Involved in sessions of Datamart Designing and analyzed the best source systems to get the required feeds as per user requirements and created BID documents for mainframe systems.
• Designed and developed the Metadata Repository (.rpd) by importing the required objects (dimensions and facts) with integrity constraints into physical layer using connection pool, developing multiple Dimensions (drill-down, hierarchies) and logical and facts / measures objects in Business Model Layer, and creating the presentation catalogs in Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed schema / diagrams using fact, dimensions, physical, logical, alias and extension tables.
• Worked on iBots to schedule reports and send alerts to the required recipients.
• Managed custom SIL and SDE mappings.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports.
• ‘Dashboards’ were generated to provide insight into the financial data and tested the reports which migrated from Siebel and OBIEE 10g to OBIEE 11g.
• Involved in working on level based data metrics and aggregation tables.
• Created different types of customized reports (drilldown, aggregation) to meet client requirements.
• Built business model and established relationships and foreign keys (physical and logical) between tables.
• Developed custom reports / Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Worked on various Answers / Dashboards in OBIEE+
• Worked on various tools like OWB to build the Warehouse.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed many reports / dashboards with different analytics views (drill-down, pivot table, chart, and column selector, tabular with global and local filters) in OBIEE 11g.
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Implemented security by creating roles and web groups, checks with database authentication.
• Performance tuning of dashboards / reports and made changes to database by implementing the aggregation table and Cache management through event pooling table.
• Created HLD, LLD, unit test case and technical architecture documents.
• Performed production supports on existing dashboard requests including making enhancement, changes, and add-ons functionalities of the dashboard report.
• 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 the repository.

Environment: OBIEE 11g/10.1.3.2 g/Siebel 7.8.4, Datastage 8.x, Oracle 10g, Win XP, Win 7, TOAD, MS Office.

Confidential, Warren, NJ

OBIEE Developer

Responsibilities:

• Used OBIEE 10g Administration tool to develop and enhance meta-data.
• Extensively worked on building the Data warehousing Model by designing and implementing various methodologies.
• Interacted with business representatives for gathering the reports / dashboards requirements and to define business and functional specifications.
• Involved in business analysis and technical design sessions to develop the requirements document and ETL specifications.
• Designed project scoping with other consultants to understand the project.
• Involved in sessions of Data mart designing and analyzed the best source systems to get the required feeds as per user requirements and created BID documents for mainframe systems.
• Involved in data profiling to make sure the feeds satisfy the business requirements.
• Designed and developed the Metadata Repository (.rpd) by importing the required objects (dimensions and facts) with integrity constraints into physical layer using connection pool, developing multiple Dimensions (drill-down, hierarchies) and logical and facts / measures objects in Business Model Layer, and creating the presentation catalogs in Presentation Layer.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Designed schema / diagrams using fact, dimensions, physical, logical, alias and extension tables.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports.
• ‘Dashboards’ were generated to provide insight into the financial data and tested the reports.
• Involved in working on level based data metrics and aggregation tables.
• Created different types of customized reports (drilldown, aggregation) to meet client requirements.
• Built business model and established relationships and foreign keys (physical and logical) between tables.
• Developed custom reports / Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed many reports / dashboards with different analytics views (drill-down, pivot table, chart, and column selector, tabular with global and local filters).
• Performed unit, integration, and regression testing to validate report and mapping functionality.
• Implemented security by creating roles and web groups, checks with database authentication.
• Performance tuning of dashboards / reports and made changes to database by implementing the aggregation table and Cache management through event pooling table.
• Created HLD, LLD, unit test case and technical architecture documents.
• Performed production supports on existing dashboard requests including making enhancement, changes, and add-ons functionalities of the dashboard report.
• 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 the repository.

Environment: OBIEE 10.1.3.2, Informatica Power Center 8.1.1, Oracle 10g, PL/SQL, TOAD, UNIX Shell scripts.

Confidential, Pittsburg, PA

OBIEE / Siebel Analytics / Informatica Developer

Responsibilities:

• Proven ability to strategically plan, lead, inspire and mentor project team.
• Worked on MUD and with multiple project teams.
• Interacted with case services management business representatives for gathering the reports / dashboards requirements and to define business and functional specifications.
• Extensively worked on general ledger, summit, trading activity, foreign exchange, cash flow subject areas.
• Involved in ETL design for the new requirements.
• Extensively worked on KPI’s and data metrics and generated reports depending on user requirements.
• Involved in working on level based data metrics and aggregation tables.
• Involved in gathering and analyzing the user requirements in coordination with business and identified facts, dimensions, and grain of the dimensional modeling.
• Also prepared the requirement specifications document based upon the background study and research.
• Worked extensively on Dimensional hierarchies.
• Designed and developed the Metadata repository (.rpd) using OBIEE administration tool by importing the required objects (dimensions, facts and aggregates) with integrity constraints into physical layer using connection pool, developing multiple dimensions (drill-down hierarchies), logical and facts / measures objects in Business Model Layer and creating the presentation catalogs in presentation layer.
• The data was imported from different sources and after applying business rules, the required presentation catalogues were created.
• Analyzed and validated the business model in OBIEE administration tool by performing consistency check, validating logical source tables (LTS), logical columns, and also validating repository level calculations done in the business model layer.
• Implemented time series measures to have chronological analysis of the business.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created the High Level Design Document (HLD) and Technical detailed design document (TDD) of Repository and Webcat (reports / dashboards).
• Implemented security by creating roles and web groups, checks with External tables and LDAP.
• Worked extensively on the SA SYSTEM tables and USAGE Tracking.
• Implemented both object level and row level security based on roles and responsibilities.
• Configured out-of-the box as well as custom analytics / dashboard reports using BI answers.
• Created reports for each department using different analytics views (pivot table, chart, table, and gauge).
• Extensively worked on procurement analysis for the bank and also created reports and dashboards on procurement.
• Worked on migrating the reports from Oracle EBS Discoverer to OBIEE.
• Migrated couple of subject areas from Oracle EBS Discoverer to OBIEE.
• Extensively worked on stored procedures, triggers, views and functions.
• Also worked with database administrator in upgrading OBIEE to newer version by implementing patches.
• Implementing report level business logic using function editor.

Environment: Oracle Bi 10.1.3.4.1, Informatica 8.x, TOAD, Linux 5E, Oracle 10g.

Confidential, Chester Brook, PA

OBIEE / Informatica Developer

Responsibilities:

• Participated with SME’s and users in gathering and analyzing the business reports requirements.
• Used Informatica Power Center Designer for developing mappings, using transformations, which included aggregation, updating, lookup, and summation.
• Developed sessions using Server Manager and improved the performance details.
• Maintained development, test and production mapping migration using repository.
• Created stored procedures to transform the data.
• Worked extensively on Siebel Analytics along with ODI.
• Used Informatica server manager to create sessions, batches to run with the logic embedded in the mappings.
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and load the data from flat files, oracle to Oracle.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Worked on complete SDLC from Extraction, Transformation and Loading (ETL) of data using Informatica.
• Worked with Siebel Analytics developer to create Repository with Siebel Analytics Admin tool.
• Worked extensively in Siebel answers and dashboards.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Developed new reports, dashboards and debugged many dashboards using different analytics views (pivot table, pie / bar chart, and view / column selector, page and dashboard prompts), interactive dashboards with drill-down capabilities using global and local filters.
• Widely used Siebel delivers and iBots.
• Performed unit and integration testing to validate reports and mapping functionality.
• 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 the OBIEE repository.

Environment: Informatica 7.1/8.1, ODI, Siebel Analytics 7.8.2, PL/SQL, Oracle 9i, Erwin, Windows.