Responsible for delivery of client solutions that exceed business requirements issues, integration of high quality source data, development of full life cycle data models innovative business intelligence delivery to users.

Expertise in developing BI Publisher reports.

Expertise in creating BI reports and Interactive dashboards as per the user requirement. Hands on experience in RPD and Webcatlog changes.

Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.

Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.

Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.

Involved in modifications on the Repository Metadata.

Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic's, and creating the Presentation catalogs in Presentation Layer.

Developed different kinds of Reports using Table and Pivot Views, View Selectors, Column Selectors, Narrative Views, Static Views, Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.

Developed different kind of reports using BI Publisher.

Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.

Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.

Involved in Upgrade process of the entire infrastructure from OBIEE 10.1.3.3.2 to OBIEE 10.1.3.4.

Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.

Performed Unit testing to validate report.

Involved in UAT and post Production Support.

Migrated Web Catalog and RPD from different environments by using PVCS.

Worked closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.

Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.

Implemented Time Comparison and calculation measures in the business model using Time series wizard.

Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns. Setup the visibility of dashboards to employees with respect to their responsibilities.

Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.

Providing object level security for different web groups based on responsibilities.

Developed security matrix for dashboards/Answers users based on Individual responsibilities and External table Authentication.

Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Configured new customized mappingswork flows in DAC for new customized subject area.

The data warehouse is designed for use by different departments such as Finance, Marketing, Buyers and the production team create the physical database and stored procedures, new users, views and indexes, all on SQL Server.

Upload of data from the Oracle database to the SQL Server database. Debug and test the data warehouse.

Develop new and maintain existing ASP code for partner affiliates programs such as AOL, Yahoo, Excite, Brands for Less etc, tested data feed output files. Develop in VB an application to print sample labels for the production team. Day-to-day tasks include sending PO's to the fulfillment center, shipment confirmation to the customers, and bills to customers via Cyber Source. Maintain existing VB code for shipment confirmation, purchase orders and the Cyber Source billing system. Troubleshoot MS Access issues for the Finance, Buyers, Marketing and Production departments.

Environment: ORACLE, SQL Server 2000, Windows NT

Confidential

Jr. Developer

Responsibilities:

Worked as one member of a team of programmer developing a Real Estate Information Management system. The system was built for the NY and NJ metro area counties and stores and manages housing and plot information.

The system contains records of names, addresses, properties, deeds, previous property owner, new buyer, banks and other relevant details. Wrote PL/SQL scripts to clean up user data. Reformatted any type of data into a pipe delimited format used by Data Junction

Uploaded data from flat files into the ORACLE database using SQL Loader. Created the physical database, including triggers, views and stored procedures. Developed an application to reconcile and correct user data such as address, bank name, seller, buyer, zip code etc. Debugged and tested the corrected data.

Developed an Extraction, Transformation Loading ETL tool for downloading new data to flat file for each county.

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.