SUMMARY

• Over 8 years of industry experience in Reporting Business Intelligence and Report Datawarehousing.
• Specialized in Data Analysis, Integration, Data Quality and Data Profiling and worked with different Data Integration DI and Business Intelligence BI tools.

• Knowledge on Bill Inman and Ralph Kimball methodologies in Data Warehouse implementation.
• Implemented data lineage reports as part of yearly Federal audit requirements to substantiate the quality of data elements/quality in the Warehouse.

• Strong knowledge data modeling using the Change Data Capture CDC and Slowly Changing Dimensions SCD- Type1, Type2, and Type3 .

• Researched and Identified Dimensions, Descriptive attributes, Facts in the legacy data set and Engineered Dimensional modes Star and Snowflake schemas with Data modeling group using Erwin.

• Design and Implementation of Datawarehouse/Data Mart, gathering Business User Requirements, System Analysis, Design and Data Modeling based on reporting requirements.

• Very strong experience in developing OBIEE Repository .rpd , three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters.

• Expertise in building Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Extensively worked and implemented conformed dimensions and aggregate fact tables.

• Proficient in Creating Dynamic and Interactive Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
• Presented a Security Model to encapsulate Object level and Row level security.

• Used Session and Presentation variables in dashboard prompt and report to filter out reports and data.
• Worked on Materialized View and Opaque views in OBIEE 11g
• Implemented Indexing and hints and complex joins to enhance performance of reports and queries.
• Worked on OBIEE upgrade from OBIEE 11.1.1.5 to OBIEE 11.1.1.7.x
• Customized and modified the OBIEE homepage to show the client logo instead of Oracle logo.

Oracle Applications

Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.0/3.x.

ETL tools

Informatica Power Center 9.x Power Exchange 8.x/7.x.

Application Tools

OBIEE, Reports 6i/4i, Discoverer 10g/6i/4i, Forms 6i, Oracle 9iAS, XML Publisher 5.6.3/5.6.2, Oracle Web Application Server 4.0.8, Oracle Enterprise Manager 2.1.0 .

Databases Tools

Oracle 11g/10g/9i/8i/7.x, TOAD, SQL Navigator, SQL PLUS, SQL Loader.

Scripting Languages

Unix Shell scripts, K shell, C shell.

Languages

SQL, PL/SQL, JAVA, XML, C, C .

Operating System

Sun Solaris, Unix, Linux, Windows NT/XP/2000/98.

Work Experience

OBIEE Senior Developer

• The goal of this project was to provide the Credit Risk Group, relationship managers and senior management the capability to obtain aggregated exposure across products, geographies, BNY Mellon legal entities and counterparty families through a common management reporting mechanism. Reduce the time and manual effort to aggregate enterprise-wide exposure risk positions across various systems and lines of business. Support enterprise-wide capabilities for limits management and capital management as well as regulatory limit monitoring and exposure concentration reporting. Improve timeliness and reliability of ad-hoc reporting requirements such as line of business requests, market conditions and regulatory drivers.
• As the lead developer and onsite coordinator, I was required to work closely with end users to designing reports and dashboards, creating mockups in OBIEE using mockup data so that the required information is visualized by end users and also translate the requirements to other offshore team members, coordinate and manage the construction of reports.
• Studied and Analyzed different source financial instruments for Regulatory reporting needs for Institutional Credit Exposure Report.
• Worked with different portfolio groups Retail, Wholesale, Securities, and Equities to gather and identify Data elements and ways to represent them on the report.
• 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. Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
• Create groups for different users to provide suitable securities for different dashboards and reports.
• Prepared the SIT and UAT scripts for Integration Testing and User Testing.
• Documented the performance stats of reports run time and background sql query stats in DB2.
• Prepared and manage the Release Management, playbook and runbook for the project release to production.

Confidential

OBIEE Senior Developer

• I principally worked as the lead OBIEE developer for migrating reports from Microstrategy tool to OBIEE. The migrating was not just to view the reports in OBIEE it was a complete redesign of the structure and delivery process of the Microstrategy Reports which required close interaction with the prime Credit Risk User.
• Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
• Documented the Business requirement and functional requirements w.r.t OBIEE details for this project. Mainly analyzed the data being sourced in to the Credit Risk Datawarehouse.
• Detailed Analyze and extract complex calculation from the Microstrategy tool and reports to use it as the building blocks of the OBIEE reports.
• Re-designed every report and designed the new dashboard that was a platform to run using the search criteria.
• Documented the design that would be involved in creation of the RPD and the mockup screens of the reports using the new designs.
• Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.
• Constructed the physical data model within OBIEE, the logical model consisted of complex aggregation and level based aggregations.
• Constructed drill down and drill through reports to replicate the features of Microstrategy.
• Implemented and documented a security model that would isolate the users and restrict the access to view and run only these reports using Object level Security.
• Extensive system integration and functional testing included as the results were verified using a comparison between the tools.

Confidential

OBIEE Senior Consultant

• I worked on the updating the existing dashboards with new graphical view using new filtering criteria and scheduling the dashboard and have them delivered to the users via email.
• Modified existing reports to incorporate different view and graphs Waterfall graph and Bubble graphs into existing reports.
• Analysis of new data to see what view could be incorporated into the reports and corresponding data model changes using SCD type 2 dimensioning model
• Designed and document the various steps involved in construction of the repository and reports.
• Created BMM using multi-fact models and converted into aggregated fact tables and conformed dimensions in logical layer.
• Updated the dashboards with new views of data with existing dashboard prompts as selection criteria to generate the reports.
• Created the agent to deliver these reports using custom built java programs that delivers these reports using a batch.

Confidential

OBIEE Senior Consultant

• I worked on design and building the data model, for all nonfunctional reports, statistical data shown on reports of various functions such data mapping and batch and jobs error/success rate to give an overview to the Technology Management team.
• Designed and Developed nonfunctional reports using Pie charts, line charts and Waterfall Charts for technology management and maintenance.
• Developed reports to monitor Data Lineage across different mappings, Batch Job scheduling report which tracks the success/error rating of the completion of batch jobs.
• Implemented the data model and structure to capture and maintain information of tables/batches/jobs etc. to build statistical reports for audit purposes.
• Designed and constructed Complex conformed dimensions and numerical facts to help build the physical and logical mapping models within the RPD.
• Scheduled the nonfunctional reports to be executed according to scheduling details using Agents.
• Designed and constructed the reports and Dashboard, and dashboard prompts as the selection criteria which was achieve by working closely with the Management team to help create ideal reports based on requirements.
• Devised a structural design for OBIEE migrations using the multi-user development MUDE OBIEE.