PROFESSIONAL SUMMARY

Result Oriented IT professional with 11 years of extensive expertise in analyzing requirements application design development testing Full Systems Development Life Cycle and a comprehensive background in Data Warehousing and Business Intelligence.

Experience of around 7 years in the dome of Business Intelligence OBIEE and in designing developing Business Intelligence solutions.

Proficient in working with OBIEE administration tool developing metadata repository and strong experience in working with Oracle BI answers Oracle BI dashboards Oracle BI Delivers and Oracle BI Publisher.

Excellent understanding of OLTP/OLAPSystem Study Analysis and developing Database Schemas like Star schema and Snowflake schema.

Experience in implementing the Oracle BI Security Setup groups data access/query privileges .

Proficient in developing OBIEE Interactive Dashboards/Reports with different analytics view Drill-Down/Dynamic Pivot Table Chart Column Selector Tabular with global and local Filters configuring OBIEE Metadata objects Subject Area Table Column Presentation Services/Web Catalog objects Dashboards Pages Folders Reports Scheduling iBots/Agents.

Expertise in OBIEE features like cache usage tracking dimensional hierarchy aggregate navigation variables /initialization blocks configuration Dim extensions physical and logical data modeling.

Experience in debugging and optimizing the OBIEE Dashboards/Reports.

Hands on experience in Oracle BIEE testing unit testing report data validation report data testing based on SQL results OBIEE query log data validation.

Highly experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.

Experienced with OBIEE 11g and also took part in the upgrade activities of OBIEE 10g to OBIEE 11g.

Exposure to Data Warehousing ETL tools such as Informatica Power Center SQL Server Integration Services SSIS and DTS Packages.

Proficient at interviewing stakeholders from CXO level executives to end users and in translating users statements of needed system behavior and functionality into Business and Functional Requirement

Very strong Analytical and Presentation skills problem-solving techniques proven leadership qualities with emphasis on individual and team effort backed by excellent Communication skills.

Good Analytic and Statistical Exposure to create Reports Proficient in building analytical repository presentation layer business models generating reports and creating dynamic Dashboards using OBIEE.

Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design building business models configuring metadata Answers/Analysis Delivers / IBots creating reports / Dashboards cache monitor and building Analytics Repository using OBIEE.

Experience in implementing security in OBI using Repository Variables Initialization Blocks and Session Variables and creating Object Level Security and Row Level Security at the repository level.

Worked on implementation of Data Warehouse BI solutions and a strong understanding of Data Warehouse concepts Star Schema Data Modeling Business Process Analysis Dimensional Data Modeling FACT Dimensions tables Physical Logical Data Modeling.

Good experience on CRM and Sales Analytics module of OBI Apps.

Self-driven and passionate performer with the yearn to learn new technologies and concepts

Can handle multiple projects at one time and deliver quality work.

Experience working with AGILE methodology and participating in daily SCRUM meetings for time critical projects.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Consultant

Confidential is implementing CRM Business Intelligence project as a suite of business intelligence tools including CRM and business analytics. Overall these tools will provide insights and data to allow users to gain knowledge about business performance and to understand progress toward goals including state of the art referral prospect and pipeline management access to data and information related to the existing book of business streamlined and centralized access to consistent data across the user base and the identification of potential trends.

Responsibilities

Involved in the whole SDLC of the project which includes requirement gathering design development testing and release and production support.

Designed and built Oracle BIEE Repository 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.

Worked closely with Business Users in understanding the requirements and created the business model for generating reports as per the user requirements.

Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer Logical tables dimensions and columns.

Used the Catalog manager and maintained the web catalog to manage Dashboards Analysis.

Created Drill down Hierarchies and implemented Business Logics for Facts.

Analyzed and validated the business model in Administration Tool by performing consistency check validating logical source tables logical columns and also validating repository level calculations done in the business model layer.

Interacted with Business Users for gathering the Reports / Dashboards requirements and to define business and functional specifications.

Conducted and delivered Mock Up-Presentations with Business Users as a part of the AGILE methodology and facilitated in getting approvals and signoffs.

Developed many Reports / Dashboards to showcase Referrals Sales Metrics Pipeline Opportunities and Performance Metrics etc. with different Analytics Views Drill-Down / Dynamic Pivot Table Chart Column Selector Tabular with global and local Filters using OBIEE Presentation server.

Managed security privileges for each subject area and dashboards according to user requirements.

Configured OBIEE Repository like implementation of physical data model as per requirements importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.

Worked on Multi-User Environment MUDE by merging and importing multiple projects throughout the development phase.

Created/manipulated initialization blocks and variables for usage in reports.

Integrate BI Publisher with OBIEE. Create Templates Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.

Worked on setting up column level security for the OBIEE Reports and also handled the security and privileges from the Database to the Oracle repository.

Created user and groups using Web logic Administration Console.

Created Roles and policies using Web logic Enterprise Manager.

Worked closely with the Business Users corresponding track developers and Administrators to resolve ongoing production issues.

Environment OBIEE 11g OBIA 7.9.6 Oracle 11gR2 Informatica 9 TOAD Windows Server 2008.

SHAPE

Confidential

OBIEE Consultant

XSELLerate project was targeted to enhance current Institutional data and reporting capabilities in order to support knowledge management improved management reporting and BDO performance management by providing them access to a common place to access Opportunity Sales Metrics Book of Business training materials and other tools

Responsibilities

Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.

Analyzed the specifications provided by the client understanding the business.

Install configure and administer the OBIEE platform.

Involved in RPD Development Oracle BI Administration Oracle BI Answers Scheduling IBOTS

Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.

Developed Physical Layer Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.

Specified Dimensional hierarchy Aggregate levels for the dimensions.

Developed different brand level Reports Filters and Prompts using Oracle BI Answers.

Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.

Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic criteria filters Pivot Table Chart Column Selector View Selector Tabular with global and local Filters using Oracle BI Presentation Services.

Helped built a custom Usage Tracking Report to showcase user and dashboard based usage tracking.

Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.

Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include like Managers Directors Business Development Officers

Managed Security privileges for each Subject area and Dashboards according to user requirements

Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.

Developed under MUDE environment for concurrent rpd development. Developed and debugged many Dashboards using different Analytics Views.

Worked closely with the team in upgrading to new version OBIEE11g on all the environmental servers

Involved in System Integration Testing SIT User Acceptance testing UAT and Production support.

Performed Upgrade Assistant on repository and web catalog from OBIEE 10g to OBIEE 11g.

Conducted mockup and Training sessions for the end user.

Environment OBIEE 10.1.3.3/10.1.3.4/ 11g Oracle 10g Informatica 8.1 TOAD Windows XP

SHAPE

Confidential

OBIEE Consultant

PNC I R project was targeted to deliver key metrics reports at the Firm level Business segment level and Managerial level mostly for the Investments and Retirement business arm of the organization. Many customized reports were developed to showcase Stacked Rankings Financial Planning and Sales Actuals and Goals.

Responsibilities

Reviewed Functional design document and Technical design document.

Worked closely with Business Users discussed and gathered the Analytics requirements from different user groups.

Worked on repository Physical Data Layer Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.

Used the Security settings in OBI Admin Tool to set up users groups access privileges and query privileges.

Configured charts pivot table views Gauge Views filters in user interface.

Configured Global Filters and Dashboard and page Prompts in OBI Web.

Created navigation reports with conditional formatted columns.

Configured Repository and session variables to get dynamic reports and dashboards.

Upgrade and Migrating from the Crystal Reports to Oracle Business Intelligence 10.1.3.3.2

Involved in Performance Tuning of reports created bitmap Indexes and Materialized Views.

Added new Dimensions and Columns to the Subject Areas to full fill the additional Requirements of the Business Analysts.

Involved with the Testing team to resolve fixing and testing problems found during the Systems integration test UAT Phases.

Involved in user trainings on the generated reports for this project.

Environment Oracle Business Intelligence 10.1.3.3.2 Oracle Informatica 8.1 DAC 7.9.4 Microsoft Windows XP

SHAPE

Confidential

Sr. Analyst Programmer

Designed developed tested and implemented a secure laser check printing solution - CSS Corporate Shareholder Services FlexWeb. This integrated Solution provides the CSS users of the Trust operations department to perform check printing check re-printing individual and range check-renumbering generating financial and audit reports and through the admin function - management of the check stub.

Responsibilities

Performed an initial client data review and determined the client requirements.

Analyzed current financial and Check Printing workflow in the context of data movement transformation and integrity along with estimation.

Designed normalized data schemas and developed stored procedures using MS SQL Server 2005 / 2000.

Developed business logic components as a middle-tier between database C ADO.NET and the client application administration tools C ASP.NET and IIS

Performed design and development of complex dynamic Web Forms using ASP.NET / C and third-party components such as NetAdvantage to provide a friendly and rich User Interface.

Designed and developed windows-service application which serves as a File watcher and triggers the appropriate Library Function calls.

Developed Wrappers for integrating new modules with vendor product which is responsible to generate printer ready Check Images.

Installed Check Printer queues on the application servers and integrating it with the application itself.

Implemented the security module to restrict data accessibility and perform separation of duties using Role Based Access Control Active Directories .

Developed comprehensive and parameterized financial statistical and audit reports using Microsoft Reporting Services.

Prepared test cases and executed them to track defects.

Performed Unit System Regression Testing

Implemented on the application/web server

Environment ASP.Net C SQL Server 2000 Microsoft Reporting Services T-SQL Infragistics-NetAdvantage for ASP.NET IIS 6.0 Windows XP/2003 Server 2003 Virtual server

SHAPE

Confidential

Sr. Analyst Programmer

The objective of the system was to gather Critical to Quality data CTQ through a primarily automated process where this data was stored in a centrally located server for the purpose of summary and parameterized reporting using a web interface.

Responsibilities

Data Model analysis for the functionality

Performed Data Model analysis Web form Design and development of the web application

Client interaction to gather requirements performed effort estimation and resolved any issues or queries regarding bugs encountered if any.

Development of Overdrafts functionality of the Web Application which was used to keep track of all the overdrafts and the related processes in trust accounts.

Development of the stored procedures and building of queries related to the Overdrafts Section and Panorama Reports.

Analyzed and modified the data model tables for the overdraft functionality in SQL Server 2000.

Designed the inputs provided by Six Sigma and Trust Operations management to develop the look and functionality of the application to meet customer needs.

Implementation on the application/web server

Code Management using VSS and Serena ChangeManDS Application defect fixing post implementation

Deployment of application in QA and Test environment for validation

Created System Test Plan and System Test Cases.

Facilitated Acceptance and Regression testing.

Environment ASP.Net VB.Net MSSQL Server 2000 VSS Serena ChangemanDS Windows 2003 Server IIS 6.0

SHAPE

Confidential

Developer/Designer

The FlexWeb is an ASP.NET web application used for administration and printing of checks at different sites paid out of Trust accounts.

Responsibilities

Conducted requirement analysis provided by the Line of Business and Designed the application to meet user requirements

Developed common libraries in C for Data Access Layer Security and Exception Handling which were also used by many other applications within the organization.

Also developed web forms for the Admin User and Trust operations functionality of the Web Application using Microsoft.Net platform

Prepared Test cases and performed Extensive Acceptance and Regression testing on Dev and Test Environments before moving to Production.

Configured check printer queues and integrated with the application on the application server.

Conducted functionality training of the application through web meetings

Migrated the code into production through change controls using Serena ChangemanDS.

Provided application support post implementation in the production environment.

Environment ASP.NET C MSSQL Server 2000 VSS Serena ChangeManDS Windows 2003 Server

SHAPE

Confidential

Analyst Programmer

For ECGC s Global Connectivity with the world and its clients an Internet Portal was developed which provides various services for its online users like applications for issuance of Policy/Guarantee Claims Settlement etc. The solution also provides an integrated software system for ECGC operations in issuance of Policy/Guarantee Claims Settlement Buyer and Country underwriting Policy planning Project Exports Accounts Human resource management and Payroll in the form of an Intranet Application.

Responsibilities

Requirement Study

Analysis and system design

Client interaction through meetings

Development of Web forms and Data Access layer for the application

Enhancement and modification of the application as requested by Clients

Implementation on the application/web server

Code Management using VSS

Application Support post implementation

Deployment of application Test environment for validation

Unit System Regression Testing

Functionality training of the application to clients

Technical Knowledge Transition to team members

Documentation including generating Help documents

Development of Bank Branch and Exporter modules involving Services like online application forms online Shipment Declarations Queries Premium Calculation etc.

Creating DTS packages to import data from the intranet application.

Extensive Acceptance testing.

Enhancement for additional requests and Documentation.

Environment ASP.NET C MSSQL Server 2000 VSS Serena Windows 2003 Server

SHAPE

Confidential

Programmer

Idea Cellular Services is a major cellular service providing company which is one of the largest cellular service providers in India. It is one of the leading organization in providing value added and automated services in the cellular world to its customers. To provide Group messaging and some of the top Value added services the SMS and MMS Push Services For Corporates project was undertaken.

Responsibilities

Work with a team of 4 to develop this Web Application mainly enabling Group Messaging functionality and Value Added services.

Technologies used include JSP Oracle 8i Nokia Toolkit and Simulator on Windows 2000 Advanced Server.

Developed additional features such as Timed SMS MMS User Tracking and logging at every level for ease in billing and administration control.

Also responsible for the design of backend on Oracle 8i and handling of data using SQL.

Environment JSP HTML JavaScript Tomcat Nokia Toolkit and Simulator WML Wireless Markup Language Windows 2000 Advanced Server.