Professional Summary

• An Oracle Certified Associate has 80 months of experience in IT industry with Cognizant Technology Solutions.
• Served as Onsite coordinator for around 8 months in Netherland and Singapore.
• Have worked for Data warehouse, Business Intelligence, Data Modeling, Data Mining, Business plan development, Report Development, ETL, Business Applications.
• Strong experience in Object Oriented Analysis / Design / Methodologies.
• Extensive SDLC experience including Requirement gathering, Analysis, Preparations of Technical Specifications Document, Design and Coding, Application Implementation, Unit testing and System Testing, Documentation, Production Support, Functional and Regression Testing.
• Gave Corporate Training on Actuate 7.0 in Cognizant Academy.
• Working knowledge in different domains including Manufacturing, banking and finance, pharmaceutical and telecommunication.
• Excellent knowledge of Analysis, Design and Development of business applications in developing Client/ Server environment using OBIEE 10.1.3.x,/Siebel Analytics,PL/SQL, Informatica 8.x/7.x/6.x /DAC,Siebel and Actuate eReporting designer professional 6/7.
• Extensive knowledge of supervised learning and unsupervised learning data mining models.
• Experience in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Time Series Objects, Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access / query/report privileges , configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Involved in the configuration of Siebel Analytics/OBIEE Delivers, iBots, Jobs Manager, Cache Manager, Variable and Security Manager Object level security and Data level security .
• Involved in Administration activities like migration of Siebel Analytics/OBIEE RPD, INFA rep and DAC rep from Dev-Test-Stage to Production.
• Strong understanding of PL/SQL Procedures, Packages, Functions, Triggers and other objects
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment MUDE .
• Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.
• Oracle Certified Professional fundamental exam with 100 marks.
• Oracle Certified Associate exam with 97 marks.
• Sun Certified Java Professional for Java 1.4 with 88 marks.
• Worked on Defect management tool HP-QC for resolving the development issues raised by the QA.

Coursework

Business Intelligence, Data warehouse implementation, Data mining, Data Modeling, Software project management, Reporting, Data management and information processing, Marketing Strategy, Web development, financial management for IT professional.

Tools and Technologies

Sonoco Data warehouse Implementation Confidential

Sonoco is a multi-billion dollar global provider of consumer packaging, industrial products, protective packaging and packaging supply chain services. Aim of this project is to implement manufacturing analytics package provided by oracle and develop dashboards on top of it. Sonoco plant managers and regional managers are the current audience of dashboards. We have developed inventory, sales, production, consumption and performance reports. Goal is to provide a single platform to view the plants performance, comparison and identify the best performing and nonperforming plants and take the corrective action to improve the performance.

Roles and Responsibilities

• Serving as lead of OBIEE Module.
• Interacting with client to gather requirement.
• Developed OBIEE Dashboard Prompts, Intelligence Dashboards to accommodate the reports that are built in Answers.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, time comparison analysis and event poll strategies in the repository.
• Development and Implementation of reports using OBIEE MAPs.
• Creation/customization of star schemas and Business Metrics in RPD as per customer requirements.
• Extensively involved in Business Model and Mapping Layer to create Dimensional hierarchies, level based measures. Identify Fact tables Measures. Identify Aggregate tables their definitions.
• Involved in Unit testing and System testing of the metrics created in BMM Layer.
• Development of union reports, drilldown, presentation variables and prompts in the creation of answers and dashboard reports.
• Business Object Universe development
• Webi report development

Environment: OBIEE Platform 11.1.1.3 DAC, Informatica 9.0.1, Ms-SQL Server 2005,2008,R, UNIX, Putty, Windows XP Professional, HP Quality Center 9.2, SQL developer, business object14.0.2

NGCRM T system Confidential

T-Systems is a German global IT services and consulting company headquartered in Frankfurt. Founded in October 2000, it is a subsidiary of Deutsche Telekom AG. Aim of the NGCRM project was to implement the new generation CRM. I was serving as lead of business intelligence module and was responsible to handle the offshore activities. We had fifteen environments divided into development, testing and production for different countries including Hungry, Germany, Slovakia, Check Republic and Macedonia.

Roles and Responsibilities

• Gathered and analyzed the Business requirements, Functional requirements and Design Specifications in order to design and write detail requirement, design and technical Specifications.
• Involved in developing Test Plans, Test Cases based on Business Requirement Documents to test the functionality of the Application for Quality Assurance.
• Interact with Business Owners/End-user to create Subject Areas, Folders/Sub-folders, and Presentation/Business columns.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, LDAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT Dimensions tables, Physical Logical Data Modeling
• Implemented Object level security to hide Tables and columns according to the user responsibilities.
• Created and granted privileges for the users using OBIEE Admin/ Presentation Catalog
• Extensively worked on OBIEE Components, BI Publisher, Webcat Manager, Scorecards, OBI Presentation services Answers and Dashboards to create reports and dashboards.
• Implemented Caching and purging of Cache to increase performance.
• Worked with Order Management Pre-built dashboards like Backlog, Customer Report and Sales cycle, OBIEE Metadata and Customer dashboards.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Optimization and Troubleshooting of the Reports, Dashboards for better performance.
• Validation of Data Loaded by ETL Process.
• Worked with DBA's to resolve issues like extending table space or any other issues with OLAP database which causes ETLs to fail and troubleshoot them accordingly.
• Worked on Multi User Environment MUDE model for check in and checkout of the repository/project.
• Involved in Administration for OBIEE Server, Cluster Server, Scheduler Server, Presentation Server and IIS Web Server.
• Installation and configuration of OBIEE Product Suite.

Environment: OBIEE Platform 10.1.3.4 Siebel Analytics 7.8, Ms-SQL Server 2005,R,SSAS, UNIX, Putty, Windows XP Professional, HP Quality Center 9.2, SQL developer, Cygwin.

OBIEE Reporting Confidential

United Overseas Bank UOB provides a wide range of financial services including personal financial services, private banking, commercial and corporate banking, investment banking, corporate finance, capital market activities, treasury services, futures broking, asset management, venture capital management, insurance and stockbroking services. OBIEE reporting was a credit card report development project. The aim was to cater the summary and detail report of the credit card performance in different region and segment. Those were used by the higher management in deciding their strategy, policy and management plans including discounts, offers and target customers. I have been extensively involved in Reporting Data mart and front end report design and development.

Roles and Responsibilities

• Implementing OBIEE based Dashboards for Sales Agents which gives up-to-date view of their sales credits, commission, targets at District/ Region/Manager/VP/Corporate levels.
• Implemented complicated sales commission calculation logic which frequently changes in OBIEE using many OBIEE repository features like oracle subtotaling
• Implemented Sales agents Hierarchy and login based personalized Dashboard views which can restrict sales data applicable to only their appropriate regions
• Migrate existing reporting infrastructure to OBI based executive dashboard and answers requests
• Assisting in implementing Oracle HR metrics through OBIEE based HR executive dashboards with special emphasis on data security
• Review the overall OBIEE platform and evaluate/correct the variations between Prod, Test, Dev, MUD environments.
• Implementing automatic startup, shutdown, restart recoverability scripts for OBIEE prod, dev test platforms
• Involved in performance tuning of dashboard refresh and end-user report queries
• Managing efficient cache management for frequently used Dashboards
• Review of Consolidated RPD we needed to clean up redundant connection pools, obsolete projects, and other undesirable objects.
• Providing assistance for Informatica based ETL for OBIEE Financials Analytics modules

Environment: OBIEE Platform 10.1.3.4, Informatica Power Center 8, Teradata, UNIX, Perl Scripting, putty, murphy.

KPN BI Innovation Confidential

KPN is the leading telecommunications and ICT service provider in The Netherlands, offering wire line and wireless telephony, internet and TV to consumers, and end-to-end telecommunications and ICT services to business customers. KPN BI Innovation was a Teradata - CLDM data warehouse application has been created to facilitate users to have details info of customers, offerings, billings and revenue. I have developed the 260 degree customer care application on top of this data warehouse for KPN consumer channel customers. It was basically a search engine on OBIEE platform to find detail information of product used by the customer, technical information and product details. KPN was monitoring the usage tracing reports of this application lead them to decide the business strategy on products, area and cost.

Roles and Responsibilities

• Interacted with the users and maintained proper documentation to ensure the required reports are properly developed.
• Involved in meetings with the Business Partners, Business Users and gathered the Business Requirements and documented them in a systematic manner BRD , also discussed the technical feasibility and the system requirements for the new developments such as the creation of any new database tables or about using the existing tables and Schemas etc.
• Developed the new metadata definitions, new Subject areas in the OBIEE Repository which involved working with the Physical, Business Model and Mapping and Presentation Layers of the Repository.
• Developed a search engine on OBIEE platform to ease the job of customer care associate in finding the customer and related info based on search criteria.
• Configured dimensional hierarchy and implemented them in the appropriate reports.
• Configured Aggregate tables in order to use them in the applicable reports.
• Created reports in the OBIEE Answers and configured the results in different views such as Table view, Pivot table view, Chart view, Funnel view, Narrative view etc based on the requirement.
• Dealt with the performance issues by Tuning the queries for the reports which are running at significantly higher time periods.
• Participated in weekly scheduled support calls with Business Users concerning the Production Tickets.
• Tested the reports and worked closely with the UAT testers to figure out the modifications if any are required and worked out on them to get the final sign-off from the Business partners.
• Migrated the approved developments Webcat, .rpd from the Test environment to the Production environment using the catalog manager.

Environment: OBIEE Platform 10.1.3.4, Informatica Power Center 7.1, Teradata, SQL,PL/SQL,TOAD, UNIX, Perl Scripting, perforce, putty,

NBIM Reports and Segmentation Confidential

Customer Trial Repeat Behavior Analysis:

Designed and deployed real time OBIEE dashboards that identified items which are most/least liked by the Customers using key performance metrics that aided retailer towards better customer centric assortments.

Customer Segmentation:

I have developed 11 customer segments using K-means, Gaussian mixture techniques. The clusters helped retailer understanding life time values in designing strategies to boost per household values.

Roles and Responsibilities

• Setup of Dash Boards, Business Areas, Dimensions and Hierarchies, Generating Input Templates, Creating Actuals Business process and Budget Business process and Generating Variance Reports.
• Worked on configuration of Dashboards for DBI Daily Business Intelligence Finance, Supply Chain, Procurement and Human Resources modules. Implemented, Setup of Dimensions, Hierarchies.
• Setup of Business Areas, Setup of Dimensions and Hierarchies.
• Setup of Business Processes, Generating Input Templates.
• Creating Actuals Business process and Budget Business process.
• Pre-Populating Budget worksheet with Actuals Data, Generating Variance Reports.
• Involved in Gap Analysis Study to recommend a powerful and robust BI Reporting solution.
• Responsible for gap analysis to determine Business views usage against Third party Views to suit companies reporting requirements.

Environment: OBIEE Platform 10.1.3.3, 7 Informatica Power Center 7.1, Oracle 9g, SQL,PL/SQL,TOAD, UNIX, Perl Scripting, perforce, Quality Center.

GHH Callidus Incentive Comp Confidential

Confidential. is a global research-driven pharmaceutical company dedicated to its patients and giving them their first priority. It is one of the oldest pharmaceutical and chemical companies in the world. Merck requires a way to provide Incentive compensation to its Sales forces based on their performance through the Sales teams. The Sales team data is integrated into the system from various upstream data sources and is categorized into Performance data, Sales data, transaction data etc. The GHH Callidus Incentive Comp was to calculate Sales Incentives of Merck participants under Sales performance Management and to develop the reports on actuate platform. The aim was to enable company to reward sales performers, manage channel partner promotions, maintain the quality staff, increasing the top line revenue and reduce the bottom line costs. I have developed the plans and rules for Sales Incentives calculation using True Comp incentive measurement tool and displayed the results in reports in Actuate/OBIEE platform.

Roles and Responsibilities

• Involved in the analysis and functional requirements gathering process by meeting up with the business users, business analyst.
• Designed, implemented the Metadata, Reports and Dashboards for the Views and Disclosures, Summary, Details, Ranking and Sales force subject areas using the OBIEE tool.
• Created the technical design documents and functional documents.
• Maintained the various subject areas by providing technical support as a part of the global implementation.
• Used fragmentation content and also set the total and detail levels for use of different tables.
• Used Repository and Session variables.
• Developed on demand, canned Reports and Dashboards for the various subject areas.
• Used BI publisher for the integrated OBIEE analysis by creating the data models and RTF/eText Templates to build the reports and publish them in the Dashboard Answers.
• Used different views in OBIEE like view selector, column selector, table, pivot, chart.
• Involved in creation of various Oracle tables, views, Materialized views and functions.
• Performed Unit Testing and Functional Testing for the various reports and dashboards.
• Created training manuals for the users, conducted training and presentations to the users to help drive user satisfaction.

Environment:

Oracle 10g, SQL Plus, PL/SQL,OBIEE 10.1.3.3, Actuate erdPro 7. and MS Office.

True Comp Incentive Management Confidential

The project was to calculate incentive of participants in Home Loan and Retail Banking divisions based on their performance. The aim was to help the company higher management to decide and overview the company and employee performance based on reports. I was involved in the development of plan based on the business strategy using True Comp and reports development on Actuate/OBIEE platform.

Roles and Responsibilities

• Served as a Module lead and handled client site and offshore activities of reporting module.
• Involved in creation/modification of views, sub partition, creation of new tables and columns etc.,
• Involved in working on the OBI HR Apps subject areas like Workforce, Compensations, Learning, Performance and Talent Management.
• RPD design/data modeling, Developing and deploying Dashboard, Analytics/OLAP Reports.
• Developed packages, procedures using PL/SQL.
• Involvement in analysis for the OBI HR Apps Dashboards and the reports for the Workforce profile subject area.
• Created dimensional hierarchies levels and new logical columns as per the business requirements.
• Organized the Presentation layer in a format that is easy for end user to use as basis for reporting.
• Implemented Security at the data and object levels.
• Utilized Variables and Initialization blocks in the repository.
• Implemented Caching to increase performance.
• Troubleshooting and Performance optimization of the ETL Jobs,Dashboards and Reports.
• Meeting with the business users and prepared the FRD/BRD documents based on the user requirements.

Environment: OBIEE Platform 10.1.3.3, Actuate ErdPro 6, 7 Informatica Power Center 7.1, Oracle 9g, SQL,PL/SQL,TOAD, UNIX, Shell Scripting, perforce, Quality Center.