SUMMARY:

• Strong Knowledge of relational database design and data modeling.
• Expertise in Data Warehouse development through ELT ETL Tools such as ODI and Informatica. Experienced in using various Knowledge modules, transformations tools while creating Interfaces Data Mappings and extracting data from multiple sources to the data warehouse.
• Implemented Ad Hoc Reports through rich GUI and extensively used OBIEE Presentation Services.
• Worked on ODI Oracle Data Integrator , in order to extract, transform and load data from multiple data sources.
• Worked Closely with Setup of ODI 11G and 10G Versions. Migrated 10G contents to 11G.
• Experience in managing users and setting up their privileges and profiles using LDAP. Also configured user tracking to check user login details.
• Expertise in Performance Tuning, Debugging, and Optimizing Analytics Dashboards / Reports and Data Warehouse database.
• Very Strong Experience in configuring interactive dashboards with business rules such as drill-down capabilities, Guided Analytics, Alerts, Security.
• Strong in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Caching Mapping.
• Experienced in Administering and managing the repository, creating complex reports and role based Dashboards using OBIEE.
• Expertise in providing Enterprise Wide Business Intelligence solution by building business models, creating repository, generating reports and creating interactive dashboards using OBIEE.
• As a Part of Project Management, Provided BI Training and Demo, Developed BI Power User Documentations to different users within Agencies.
• Worked with new features of OBIEE 11G Such as KPI's, Score Cards, and Ragged hierarchies.
• Worked Closely with Setup of OBIEE 11G and 10G. Migrated OBIEE 10G contents to 11G.
• Over 6 years of experience in building Business Intelligence Solutions using Oracle Business Intelligence Suite - Enterprise Edition OBIEE 11G and 10G, BI Publisher, ODI 11G Oracle Data Integrator , ODI 10G and Informatica.
• Over 8 years as an IT Professional with expertise in Requirement Gathering, Requirement Analysis, Data Modeling, Development and Implementation of Data warehouse, Project Management and Providing BI Solutions for the same using OBIEE and ODI.
• Exceptional communication, analytical, and presentation skills.

TECHNICAL SKILLS

Business Intelligence: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.6.12,

OBIEE 10.1.3.x, BI Publisher 10.1.3.4.

ETL Tools: ODI 11G, ODI 10.1.3.5.0, ODI 10.1.3.6.6, Informatica 7

Relational Databases: Oracle 8i/9i/10g/11g, MS SQL server, MS Access 7.0/2000.

Languages: SQL PLUS 8.x/9.x, PL/SQL 8.x/9.x.

Date Modeling: Power Designer, Erwin

Web Based: HTML, DHTML, CSS, Ajax, Flash, XML, and JavaScript.

HTML Editing Tool: Adobe Dreamweaver CS5, Microsoft Expression Web 3, Note Pad

Operating Systems: Windows 95/98/NT/2000, Windows 7

PROFESSIONAL EXPERIENCE

Indiana State Department of Health

Confideintial

Senior BI Consultant

PROFESSIONAL EXPERIENCE:

• Implemented BI Solution at ISDH to study and enhance the scope of Public health for healthier Community.
• Worked Closely with 8 Different Agencies MCH,LABS,LTAC,TB,CSHCS,PHPER,HIV/STD,WIC within ISDH. Implemented BI Solutions following Agile Methodology techniques.
• Studying Agency Database, Gathering requirements, Building Data ware house using ELT Tool ODI Oracle Data Integrator and then Building BI Solutions using OBIEE as per requirement is major part of my Job role.
• Developed OBIEE Repository, Reports, Dashboards based on the requirement.
• Migrated OBIEE Contents from 10G 11G. Worked on new features of OBIEE 11G such as KPI and Score Cards which are used by Executive level users.
• Fixed all different issue's which we encountered while migrating the BI Contents from 10G 11G.
• Completed Certification of HIPAA Health Insurance Portability and Accountability Act
• Developed Different kind of Dashboards with different templates and features as per Clients requests.
• Created Interfaces, Packages, Models in ODI. Used, different types of Knowledge modules within ODI to populate the data in staging areas Data ware house .
• Used ODI 10g Oracle Data Integrator to extract and customize data from different sources and Populate the data on daily basis. Migrated the Same contents to ODI 11G.
• Configured both Object level and Data level security for the dashboards.
• Implemented Snowflake and Star schema methods while building Repositories.
• Worked extensively in Oracle Business Intelligence Enterprise Edition OBIEE configuring and administering the repository .rpd , creating Intelligent Dashboards / reports, Answers, Delivers iBots / Scheduler.
• Conduct User Acceptance testing, Providing BI Training and Demo, Developing BI Power User Documentations to different users within Agencies as a part of Project Management Development. Such that they can build their reports and Dashboards and share with other BI Users.
• Translate the requirements to functional specification document, develop and own requirements traceability matrix.
• Customized Skin and Styles based on projects and Agencies as per Client Request.
• Used 'Go URL' Method to pass the Out of box selected values to OBIEE Dashboards and Reports to Slice and Dice the Contents based on Selections.
• Developed Out of Box Features such as radio buttons, multiple value check box representations in 10G using Java Scripts.
• Integrated OBIEE 10g with Maps ESRI GIS Software System to represent OBIEE Information and Reports output on Maps for better understanding.
• Created KPI and Score card for State Health Commissioner Which helps to monitor the Performance of Each individual Agency within ISDH.
• Apart from regular Intranet Projects - Created one Internet Project which is currently used by all the Internet users. Which is Placed on ISDH Websit
• Certified Lean Six Sigma Course as a part of Work Environment before handling few projects.
• Exceptional communication, analytical, troubleshooting and presentation skills.
• Worked with different data sources such as Oracle, Sql Server, Excel, and Flat Files.
• Leading small to mid size teams 2-4 . Liaise with Client and Technical Team during each phase of project.

Environment: OBIEE 11G 11.1.1.6.12 , OBIEE 10.1.3.4.1, BI Publisher 10.1.3.4.1, ODI 11G, ODI 10G 10.1.3.6.6 Oracle Data Integrator 10G, Oracle 10g/11g, TOAD, SQL and PL/SQL., HTML, CSS, Java Script, Agile Methodology.

Senior BI Consultant

Confideintial

• Visited Business and Operations to gather requirements and document the same.
• Participated in Analysis of the Project, One Core and preparing RSD.
• Developed Data ware house using Dimensional Modeling Techniques and Populated the Data ware house using ELT Tool ODI.
• Created Navigation between templates and Reports.
• Created PDF, RTF, Excel Reports and Graphs using BI Publisher.
• Developed and generated Custom Templates in BI Publisher for Operational Managers.
• Generated Operational and Analytical Reports. Integrated BI Publisher with OBIEE and ERP to enable Executive Reporting.
• Developed Ad Hoc Reports for Operational Managers using OBIEE Variables.
• Was responsible for creating interactive Dashboards and layouts using CSS, HTML and Java to provide high and rich User Interface.
• Worked on User Interface part of Reports and Dashboards. Developed Reports / Dashboards with different Analytics Views: Pivot Table, Chart, Gauges, and Column Selector, with global and local Filters using Oracle BI Presentation Services.
• Participating in Group discussions, leading group of members is a part of work.
• Built Customized OBIEE Reports for Products, Inventory and Activities.
• Developed all 3 Layers of OBIEE Repository. Physical, Business and Presentation Layers
• Scheduled and Delivered RTF and PDF Reports using iBots.
• Created users, groups in LDAP for authentication and authorization of data as per levels.
• Used ODI Oracle Data Integrator ELT Tool, in order to develop the data ware house from multiple data sources.
• Installing ODI 10G, Integrating Multiple work Repositories with Master Repository, Migrating Contents from One environment to another.
• Involved in designing, developing and testing of the ELT Extract, Load and Transform Process.
• Configured Source and Target connections to various sources such as Excel, Oracle, Sql Server and then Created Interfaces, Packages and Generated scenario's in different Projects. Used Various Knowledge modules for Loading, Transforming and Integrating the Data.
• Scheduled and Monitored the ODI Jobs.

Environment: OBIEE 10.1.3.4.1, BI Publisher 10.1.3.4.1, ODI 10G, Oracle 10g, TOAD, SQL and PL/SQL., HTML, Java script.

OBIEE / BI developer

Confideintial

• Configured schedulers and used IBots effectively to generate and deliver reports based on criteria. The reports were delivered to the concerned department as an email alert.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Built time series and drilldown function on reports.
• Worked in ELT process using ODI for various transactions and loading data from Relational Database and Flat Files.
• ODI is a comprehensive data integration platform, which is required to work out with high volumes, high performance and SOA enabled data services.
• Worked out with ODI ELT tool, in order to build the required dataware house.
• Involved in the phase of Data Model Design and Documentation Facts and Dimensions, Business Users Security Permissions, Stars with Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts
• Implemented security by creating roles web groups, checks with External tables and LDAP, and Object Level Security.
• Converted existing reports to PDF and RTF Formats. Was also responsible to generate and deliver chronological reports using IBots.
• The new dashboards provided insights into early indicators of profitability, like financial and business behavior, allowing senior management to quickly identify unsuccessful programs and alter them.
• Created dimension hierarchies aggregates and logical sources in the BMM layer.
• The American Arbitration Association AAA has a long history in the field of alternative dispute resolution, provides services to individuals and organizations who wish to resolve conflicts out of court.
• Participated in analyzing and translating business requirements to functional and technical requirements.
• Identified Business Model and Security Determined Facts Dimensions, Date Time relationships, Granularity, Data Consistency across Dimensions and Identified Business Users Group Security .
• Designed and implemented custom business intelligence solutions .rpd, and configured metadata objects, web catalog using Siebel Analytics.
• Developed OBIEE Repository RPD at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Involved in installation of ODI and setting up environment.
• Created Interfaces with various transformations to build business rules to load data and to transform the existing processes.
• Various transformations filter, router, pivot, Aggregators, lookup, Filters Sequence were used to handle situations depending upon the requirement.
• Assisted in creating, Reusable Mappings using different Transformation.

Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle Data Integrator 10g, Oracle 10g, TOAD, SQL and PL/SQL., HTML, DHTML,CSS.

Informatica Developer

Confideintial

• Involved in Architecture, analysis, design of data model Star Schema .
• Prepared the requirements, design, mappings, unit integration testing documents.
• Participated in Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Designed and Developed the Informatica workflows/sessions to extract, transform and load data from various sources - MS SQL Server, Excel spreadsheet, flat files and XML files into the target Oracle 9i database.
• Involved in developing the ETL process - Mappings Mapplets using various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router.
• Responsible for creating ER Diagrams, tables, views, table level constraints and triggers to enforce referential integrity and apply business rule for the above referenced information system models and normalized data up to second normal form.
• Extensively coded PL/SQL writing Stored Procedures and packages including functions.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Involved in performance tuning of SQL Queries, Sources, Targets and sessions.

Environment: Informatica 7.2, Oracle 9i, SQL PLUS, PL/SQL, TOAD, Erwin, UNIX, Windows XP.