KUTTY JANARDHANAN DHANDAPANI

hfsgn2@r.postjobfree.com 408-***-****

_________________________________________________________________________________

SUMMARY

• 10 Years of overall software experience with around 5 years in OBIEE and 2 years in Informatica.

• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology.

• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.

• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.

• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.

• Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing

• Experience in testing integration solutions for Data import, Export and Migration using EIM

• Experience in application development in CRM domain with Health Care, Banking and Financial Services industries

• Strong knowledge on Siebel Data Model and Performed Data Mapping between Siebel and External Systems

• Coordinate with offshore by scheduling weekly calls.

TECHNICAL SKILLS

• Data Modeling Dimensional Data Modeling, Star and Snowflake Schema

• BI Tools OBIEE 10.1.3.4/10.1.3.2, Siebel Analytics 7.8.4/7.7, Oracle BI Applications

• Oracle Tools SQL*PLUS, SQL*Loader, SQL Developer, Oracle Reports 6i/9i/10g, BI Publisher (XML).

• Databases Oracle 8i/9i/10g, MS SQL Server 2000

• Scheduling tools DAC(Data Warehouse Administration Console)

• Languages SQL, PL/SQL, XML, JAVA, JAVASCRIPT, VB

• Operating Systems Windows 95/98/NT/2000/XP,Solaris9, LINUX

• Testing Tools Mercury Test Director 7.x, Mercury Load Runner 8.1

• Reporting Tools Cognos, OBIEE, Siebel Analytics 7.x, RPD, Dashboards

• Web Technologies HTML, JSP, Servlet, EJB and XML

• Other Tools Visual InterDev 6.0, MS Office 2000, IBM MQ Series, Altova XMLSpy

EXPERIENCE SUMMARY

Project:

Progressive Insurance, San Francisco, CA – Oracle BI Consultant July 2011 – Till Date

Progressive Insurance implemented Customer SQL Application Data flow from many sources into Customer-SQL Hub. Reports were developed based out of this Schema from different sources. The project was to centralize decision making system as part of data management which involved integrating and simplifying by using OBIEE and providing composite and meaningful views to users.

Responsibilities:

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

• Involved in managing appropriate security privileges on subject areas and dashboards according to business and User requirements.

• Implemented caching and aggregate table techniques to improve the performance.

• Identified the aggregate levels for each source and configured dimension sources for each level of aggregates.

• Configured Connection Pools, defined joins and implemented authorizations in the physical layer of the repository.

• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Configured different types of Reports Drilldown techniques, Aggregation rules to meet client requirements.

• Customized business reports using BI Answers as per requirements.

• Configured numerous executive level reports. ‘Dashboards’ were generated to provide insight into the Human Capital Metrics/Headcount and Turnover/Recruitment data coming from PeopleSoft.

• Tuned sources, targets, mappings and sessions to improve the performance of data load.

• Migrated Test Code from Development to QA and QA to Production of Repository, Dashboard Reports, Informatica mappings and workflows and DAC entities.

• Hands on experience in the administration of creating new ids, Account modification of existing users, Password reset and Deletion of accounts.

• Load Contacts and Policies and from Customer-SQL into Siebel UCM application.

Environment: OBIEE 10.1.3.4, Siebel UCM, Siebel Tools 8.1, Oracle 10g, 11g, Informatica, UNIX

Credit Suisse, San Francisco, CA – Oracle BI Consultant August 2010 – June 2011

Credit Suisse implemented Siebel UCM application for its banking customers and employee to login to application. Data flow from many sources into Siebel UCM application. One of the largest financial services companies in the country, who offers personal banking services, asset management, corporate and institutional services for organizations.

Responsibilities:

• Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.

• Extracted data from different sources like Oracle, SQL Server and Flat files implemented business logic and loaded into the target Warehouse (Oracle).

• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)

• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.

• Implemented Out-of-the-box Analytics Reporting Functionality of Data mart Reporting. Incorporating Analytics will help users especially Recruiters, employer to analyze the performance of organization by Market, Finance, Manager.

• Configured Connection Pools, defined joins and implemented authorizations in the physical layer of the repository.

• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Configured different types of Reports Drilldown techniques, Aggregation rules to meet client requirements.

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

• Involved in managing appropriate security privileges on subject areas and dashboards according to business and User requirements.

• Implemented caching and aggregate table techniques to improve the performance.

• Identified the aggregate levels for each source and configured dimension sources for each level of aggregates.

Environment: OBIEE 10.1.3.4, Siebel UCM, Siebel Tools 8.1, Oracle 10g, 11g, Informatica, UNIX

GE Health Care, Milwaukee, WI – Siebel Analytics Developer January 2010 – August 2010

GE Health Care implemented Siebel for selling medical equipment. Clinical System – The second largest P&L of GE Medical Systems is implementing a CRM system to automate the Service functions.

Responsibilities:

• Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling.

• Configured Connection Pools, defined joins and implemented authorizations in the physical layer of the repository.

• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.

• Configured different types of Reports Drilldown techniques, Aggregation rules to meet client requirements.

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

• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes

• Built OBIEE Repositories at three layers Physical layer, Business model Layer and Presentation layer.

• Developed the Dimensions and Time Series Objects in the BMM Layer with Security settings in Siebel Analytics Admin Tool to setup groups, access and query privileges.

• Used the security settings in Siebel Analytics Admin tool to setup users, Groups and Access privileges.

• Developed reports in Siebel Answers. Developed different kinds of Reports, pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.

• Write System test scripts that are run in Quality center for unit testing to move changes to production.

Environment: Siebel eServices, Siebel Call Center, Siebel Sales, Siebel Tools 7.8.2.3,8.0,Siebel UCM, Oracle 8i, 9i, 10g, OBIEE 10g, Siebel Analytics 7x, Informatica Power Center 8.1.1, Solaris 9,SOA,WSDL.

Abbott vascular, Santa Clara, CA – Oracle Data Analyst September 2008 –December 2009

Abbott Vascular uses CTMS Application to manage clinical trials. They use CTMS monitoring for monitoring reports of the trials been carried out in different sites. Site Management, Site Assessment is done through the CTMS Application. Monitoring Reports are also done in CTMS application by Super users to Monitor the Enrollment overview, Protocol deviations and follow up letters.

Responsibilities:

• Gathered requirements, designed, visualized and built a custom BI solution for Siebel eClinical 7 Analytics

• Develop Siebel Analytics Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.

• Creating UI and Data Level security for the Dashboards to restrict the level of navigation.

• Develop Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.

• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.

• Developed different kinds of Reports (pivots, charts, tables/compound layout) using global and local Filters.

• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.

• Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).

• Load users, Studies, Monitoring Data in Excel sheet using Siebel VB.

Environment: Siebel Analytics 7x, Siebel Tools 7.7, Informatica, Oracle 8i, 9i, HP UNIX

Hartford Insurance, CT – Senior Programmer Analyst August 2007 – June 2008

Hartford implemented Siebel for their Insurance business. This mainly involves in the Policies, Assets and contacts. They developed reports for their sales application using SH schema.

Responsibilities:

• Develop different types of Customized Reports (Drilldown, Aggregation) to meet client requirements. Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.

• Developed the Dimensions and Time Series Objects in the BMM Layer with Security settings in Siebel Analytics Admin Tool to setup groups, access and query privileges.

• Created and managed user groups for each dashboard for security using security Manager and was also responsible for data security.

• Define business rules and transformations for data coming from source systems into the data warehouse to match the business application of the data.

• Create documents for subject area for user dashboard and identified Siebel star schema and custom tables. Implement scheduler for Siebel analytics process.

• Developed Oracle procedures using PL/SQL scripts for the backend ETL Process

• Develop Informatica Mappings for enhancement to Facts/Dimensions in developing the Initial and Incremental ETL process.

Environment: Siebel Financial Services, Siebel Analytics 7.8, Siebel Tools 7.8,Siebel UCM, C++, Oracle 8i, 9i, 10g,XML,UNIX

Nokia CCCP, FL – Programmer Analyst May 2006 – April 2007

The solution will deliver capability to support Nokia’s Cell phone products. There are many regions all over the world where they sell cell phones. The customers call, email and fax to Nokia about the cell phone products they are interested to buy. The main Objective was to perform Sales Analytics on the company’s sales data to further improve the growth of the company’s Sales.

Responsibilities:

• Did requirements gathering of the various work streams by meeting with the business user and base lining the details.

• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer

• Create Informatica Workflows, sessions and Run that Sessions to load into Target and done Debugging, Unit Testing of Mappings

• Schedule sessions and batch process based on demand, run time, run only once using Informatica Server Manager and Scheduled Multiple sessions, run on time using AppWorx an Enterprise Scheduling Tool

• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy.

• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.

• Utilized Siebel Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.

Environment: Informatica Power center 8, Siebel Analytics 7x, Siebel Sales, Siebel eservices, Siebel Call Center, Web Methods, and Siebel Tools 7.8

Indy Mac Bank, LA – Senior Software Engineer January 2006 - May 2006

Indymac Bank is Home Equity Line of Credit (HELOC) Application for Mortgage Division. Indymac Bank

Operations include Retail Banking, Corporate and Institutional Banking, Mortgage, Global Investment Servicing, Asset Management, and Midland Loan Services.

Responsibilities:

• Involved in gathering requirements and created design documents and mapping documents.

Involved in design and development complex ETL mappings and stored procedures in an optimized manner.

• Created metadata queries which would help in restart and to find out any missing link conditions or disabled tasks in a workflow.

• Fine-tuned existing Informatica maps for performance optimization

• Worked on bug fixes on existing Informatica Mappings to produce correct output.

• Involved in the Unit testing, Event & Thread testing and System testing.

• Analyzed existing system and developed business documentation on changes required.

• Made adjustments in Data Model and SQL scripts to create and alter tables.

• Worked on various issues on existing Informatica Mappings to produce correct output.

• Efficient Documentation was done for all phases like Analysis, design, development, testing and maintenance.

• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.

Involved in the Unit testing and System testing.

• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.

Environment: Siebel Financial Services, Siebel Analytics 7, Informatica 7.0, Siebel Tools 7.7, Siebel Partner portal, J2EE, Web Services

Amgen US – Senior Software Engineer Feb 2005 – December 2005

Amgen is the world leader in discovering, developing and manufacturing cost-effective human therapeutics based on advances in cellular and molecular biology. They have CRM applications built on Siebel7 for major US and European business accounts. They have introduced the activities of the US based ePharma Application to the Orion Application

Responsibilities:

• Design the Business Object Layer and User Interface Layer Establishing Joins, Links, Pick Applets and MVGs.

• Added the specifications for Joins and Pick maps that will participate in the activation of Pick Applet.

• Create Assignment rules for Assigning the Accounts and contacts to the sales rep.

• Create Server script for creating new orders in the application.

• Test each change requests before delivering it to the client.

• Modify and Configure of Vanilla Siebel Application using Siebel Tools.

• Develop User Interface by mapping and designing the Applets into Views, Views into screens by using Applet and View Designer.

• Design workflows and running it in Runtime event and also using policies

• Customize and modify of various Object definition using Tools.

• Extracted data from multiple databases and presented to the management in the form of Excel Sheets.

• Developing SQL Scripts, Stored Procedures.

• Spooling & Uploading the generated reports to Excel files.

Environment: Siebel 7.5.3, Oracle 9i, UNIX, Siebel Epharma, Actuate Reports

Digital Wave Technologies and Research Institute, India – Software Engineer

Shopping Cart May 2003 – Dec 2004

Shopping cart aids the customer to buy the necessary books. It helps the users (the online customers) to view various books in the repository search for the required books, and enter their suggestions.

I did Knowledge transfer to the team, Primary data collection design and technical architecture.

Environment: Java, Oracle 9i.

Project House allotment May 2002 - April 2003

Production Management System developed for Production Facilities in India connecting to the head quarters in Virginia, U.S.A. It includes Modules like Logistics Management (LM) and Quality Assurance (QA). LM is used at head quarters for processing allocation of jobs to various production facilities, and keeping track of them real time and generating reports. Production facilities use LM for monitoring for the production process of the jobs. The QA module enables tracking of errors during production on-line and interprets that information with a separate module for salary computations mainly involved in LM.

Environment: Java, Oracle8i, SQL-Server, Windows NT Testing Tools: Manual Testing, Win runner

Project Real Estate Management March 2001 - April 2002

This is a standalone product targeting real estate business. The system allows real estate dealers to have a control on the business with respect to the plots of land they own, to keep track of the prospective customers (who would like to buy/sell) and existing customers.

Design and coding forms. Unit testing of code developed and system testing of product. Report creation. Tuned the Query form for better performance, since any or all of the parameters can be passed as search criteria.

Environment: C++, SQL-Server, Windows NT Testing Tool.

EDUCATION AND TRAINING:

• Bachelor of Engineering (Electronics & Communication) – Bharathiar University, India

• Oracle Certified Associate (OCA) Certification from Oracle Corporation Software-2007

Contact this candidate