Summary

• Working knowledge with financial applications AR, AP and general ledger.
• Excellent experience with databases like DB2 UDB, SQL server, Oracle, flat files, CSV and XML files.
• 9 years of IT industry experience. Expertise in full life cycle development, deployment, architecture, data modeling in design and development of data warehouse projects under various environments. Performing data analysis and providing Business Intelligence BI solutions.
• Actively participated and contributed in all phases of Software Development Life Cycle SDLC with expertise in Requirement Analysis, Test Plan formulation, Test Design, and Testing progress and defect reporting.
• Experience with BI tools and versions supported are OBIEE 11g, 10g, 10.1.3.2/3.3, Cognos 8.3, MS SSRS 2005/2008, Siebel Analytics, Crystal reports and Developer 2000.
• Strong working knowledge as Data analyst and Business analyst.
• Experience in developing OBIEE / Siebel Analytics Repository .rpd at three layers Physical Layer, Business Model Presentation Layer , Security Setup groups, object and data level , External Tables, configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Interactive Dashboards with drill-down capabilities using page and dashboard prompts, Pages, Folders, Reports and scheduling iBots.
• Expertise in Designing Mapping documents ETL architecture documents and Functional, Technical specifications.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation rules and Time series.
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI Repository, Cognos Dashboards / Reports and Informatica Mappings / Workflows.
• Extensive experience in database designing, modeling for data warehouse with strong understanding of dimensional modeling, star and snowflake schemas using Erwin.
• Created and Used Existing ETL Mappings / Mapplets for the source systems data extractions, data transformations, data staging and aggregation. Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate and Update Strategy.
• Experienced in deploying Informatica workflows to OBI DAC and created dependency and dependent hierarchical tasks. Streamlined the Execution Plans with their respective tasks in OBI DAC.
• Strong Experience with multiple databases Oracle, SQL and DB2 UDB.
• Experience with Cognos Business Intelligence tools like Cognos8.X, Cognos Report Net, Framework Manager, Report Studio, Impromptu, Metrics Studio, Transformer and Power Play.
• Experience in development and effective implementation of Data cleansing, Data acquisition and Data integration tasks using tools reporting tool Cognos and OBIEE.
• Proven capability of taking up responsibility right from inception till product delivery by leading and developing with strong leadership and decision-making skills.

Technical Skills:

Professional Experience :

Confidential

OBIEE Analyst

Description: Confidential decided to improve the mortgage loan servicing processes and the overall efficiency. The objective of this project is to convert all residential loans from Core Banking platform to MSP Mortgage Service Platform loan serving system. Design and implement the new system, including integration to existing Fremont Bank system to positively impact Confidential customers, investor customers and employees.

Responsibilities:

• Created and scheduled iBots to deliver Analytics content for users.
• Created multiple hierarchies in single dimension for RPD development, level based measures, new logical columns, calculated columns using the expression builder and created presentation Catalogs in presentation Layer for the ad-hoc query purpose.
• Created OBIEE Repository .rpd using the OBIEE Admin tool and extensively worked on all the three layers physical, business and presentation layers.
• Responsible for migrating the web catalog and RPD from DEV, UAT and PROD environments.
• Customized/Developed reports request using Oracle BI Answers and configured all Dashboards as per the client requirements.
• Worked closely with business users while gathering requirements, analyzing data and supporting existing reporting solutions.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements
• Designed and customized RPD's, Oracle Answers webcat , Dashboards and Cache.
• Worked on Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Variables, and Initialization blocks.
• Identified granularity level of the data required to be available for analysis.
• Created measures in Administration tool for the requirements using expression builder and calculation wizard.
• Designed and developed Business Intelligence reports and dashboards using Oracle Enterprise Edition BI Answers and BI Interactive dashboards.
• Developed balanced scorecard to measure financial status, customer feedback and other key performance indicators KPIs .
• Customized Reports using different Analytics Views Pivot Table, Chart, and Column Selector , Interactive Dashboards with drill-down capabilities, charts, tabular using Dashboard and Page Prompts.
• Developed and implemented test plans for Loan Processing Services to provide analysis, design, development and testing guidance and support.
• Developed System Test Cases, Test Scripts based on system requirement specifications, and also analyzed RTM.
• Performed Functional, System, Regression and User Acceptance Testing.
• Created Test Scripts for System testing and Regression testing using Excel.
• Managed requirements, test cases and defects in Excel
• Documented Test Cases corresponding to business rules and other operating conditions.
• Participated in walkthroughs and technical reviews all through the testing phase.

Environment: OBIEE 11g, Informatica Power Center 8.1, Oracle 11g, DAC, MS Visio, MS Office Suite and Unix / Windows.

Confidential

OBIEE Analyst/Developer

Description: BI Solutions Analyst for rate engineering project with Con-Edison. Con-Edison mandate is to provide a comprehensive rate case to public service commission.

Responsibilities:

• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Configured OBIEE iBots to deliver Analytics content based on schedule for subscribed users, automated iBot queries to obtain daily and weekly reports.
• Developed Reports / Dashboards with different Analytics Views Drill-Down, Pivot Table, Chart, and Column Selector, tabular with global and local Filters using Siebel Analytics Web and BI Publisher.
• Worked on setting Users, groups, access privileges and Security settings checks with External tables, LDAP and Object Level Security in Analytics Admin Tool.
• Built Repository at 3 layers i.e. Physical Layer connecting to Data sources and import schema , Business Model / data mapping create Logical tables, data source mapping, Drill down Hierarchies and implemented logic for facts and dimensions and Presentation Layer create presentation catalogs by using OBIEE Administration tool.
• Imported Physical Meta Data from Various Data marts into Physical Layer by defining the connection pool settings.
• Deployed Informatica workflows to DAC and created dependency and dependent hierarchical tasks. Streamlined the Execution Plans with their respective tasks in DAC.
• Worked on business requirements gathering, designing Development of Informatica mappings and repository Physical Layer, Business Model Mapping and Presentation Layers for current risk management reporting system in OBIEE.
• Developed both SDE and SIL mappings in Informatica for full and incremental load.
• Implemented Auto Cache Purging.
• Involved in Level 3 Production Support, which demands frequent client interactions.

Environment: OBIEE 10g 10.1.3.X , DAC, Informatica 8.1.1, Oracle 10g/11g, MS Office Suite and Windows Server 2003.

Confidential

OBIEE Developer

Description: The Department of Treasury Management Reporting application is central reporting tool for all TM products. Data is sourced on a monthly basis from various systems. This application was initially started to facilitate the reporting needs of Treasury Management Group. Built a BI web based tool which gave the user flexibility to design their own report criteria and generate reports. Extensive data massaging and data scrubbing were used to load data to key tables for reporting and data warehousing purposes. Developed stored procedures, views and worked closely with the application development team. Designed and developed, implemented, tested, maintained relational and OLAP databases across multiple platforms.

Responsibilities:

• Involved in design, specifications, and delivery of Data Warehouse Operational Systems, Enterprise through functional level application and data architecture.
• Developed complex mappings using corresponding source, targets and transformations, which are optimized for maximum performance using different performance tuning methods.
• Created mappings using various transformations like Update Strategy, Lookup, Stored procedure, Router, Filter, Sequence generator, Joiner, Aggregate and Expression transformation.
• Created Reusable Transformations and Mapplets in the Designer using Transformation Developer and Mapplet Designer Tools. Created and Monitored Workflows and Sessions using Informatica.
• Worked extensively on Repository administration tool to configure Physical, Logical and Presentation Layers, Analyzed reporting requirements for dashboard reports and Ad-hoc reports.
• Configured facts, dimensions and Hierarchies, Set levels to support Drill-down, and Aggregation etc...
• Developed reports using different views such as table views, charts, Narrative View and Column Selector.
• Configured the OBIEE Analytics Web, Generated Reports and Dashboards using OBIEE Answers.
• Configured Delivers to send daily scheduled reports using iBots.
• Implemented Siebel Analytics best practices for better prompts and reports execution.
• Provided Technical Assistance by responding to inquiries regarding errors, problems and questions.
• Deployed Informatica workflows to Data warehouse Application Console DAC for parallel execution of various tasks with in an execution plan with their respective priority.

Environment: OBIEE 10g, Informatica power center 8.x, Erwin, Oracle 10g, DAC, MS SQL Server 2005, SSIS, UNIX, Oracle SQL Loader and MS Office Suite.

Confidential

BI Analyst

Description: Worked on Applicant tracking system. Stored Procedures using user defined functions were used to retrieve the record details from the web page when the user clicks on the links.

Responsibilities:

• Pulled data from various Financials systems to CDW Corporate Data Warehouse to build reports against the Warehouse.
• Documented business rules, design and process flow for all future developments. Involved in a team for creating OLAP Cubes which provide user interface to facilitate multi-dimensional query, reporting and creative presentation.
• Generated various levels of reports including Daily Sales report, Time Reports, Financial reports, Revenue report and Customer Call reports. EIS pages were designed so remote users could log on to the intranet and view the data according to the roles set on OnDemand Server.
• Imported data from Flat files to Oracle database using SQL Loader and PL/SQL. Extensively used JavaScript to write scripts in EIS page for various events. Wrote stored procedures, created Indexes in Oracle for performance tuning of reports.

Environment: Siebel Analytics 7.x, Informatica power center 8.x, Erwin, Oracle 10g, DAC, UNIX, Oracle SQL Loader, MS Office Suite, XML and Java Script.

Confidential

OBIEE Developer/Analyst

Confidential is a global financial services company that was founded in 1919. Initially formed to provide automotive finance products and services to General Motors dealers and clients, Confidential has since expanded its business to include mortgage operations, insurance, commercial finance and online banking. Credit risk management is for accurately forecast, measure, monitor and report potential credit risk exposures across the entire origination.

Responsibilities:

• Participated in gathering and analyzing the Business Requirements for credit risk management with business user for base lining the details.
• Developed Oracle BIEE Metadata repository .rpd model for RMRS that involved creating Physical, BMM layers with aggregates, dimensions, hierarchies time series functions, Presentation layer with catalogs folders using Oracle BI Administration tool.
• Worked in creating Logical tables, joins, Dimensions, Aggregations Logical and physical and Time series wizards in the Business Model and Mapping Layer.
• Worked on Security settings in Admin Tool to set up groups, access privileges and query privileges.
• Worked on Increasing cache parameters and bulk load size using NQSConfig.ini and also configured repositories using config.ini.
• Created Repository and session variables and Initialization block as per user requirements and implemented in answers and user session levels.
• Developed different kinds of reports like pivots, prompts, charts, global and local Filters using Siebel Analytics Web Answers .
• Developed Dashboards and KPI reports for Business managers to review high level information.
• Involved in various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Involved in Oracle Financial Analytics, with OBIEE, BI Apps.

Environment: OBIEE, Siebel Analytics 7.X, DAC, Oracle 9i/10g, Informatica 8.x, Window2003, MS Office Suite , XML, HTML and Java Script.

Confidential

OBIEE Developer

Confidential is a multi-billion dollar financial service organization. Founded in 1941 have evolved from a small neighborhood bank into the largest independently-owned bank headquartered in San Antonio. The Project was for transforming the credit risk management systems for loan based products into a platform that meets current risk management needs. Building this platform requires extracting current and history loan data from different sources and developing reports for decision support system.

Responsibilities:

• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Imported Source/Target Tables from the respective databases and created reusable transformations Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator inside a Mapplet.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Developed Crystal Reports for risk analysis and collection modules.
• Wrote PL/SQL procedures for processing business logic in the database.

Environment: Informatica Power Center 5.1, Power Connect, Crystal reports, Oracle 7.2x/8.i, SQL Server, PL/SQL, Erwin 3.0, MS Office Suite, Sun Solaris UNIX and Windows2000/XP.

Confidential

Siebel Analytics / Developer

Amgen is a leading human therapeutics company in the biotechnology industry. For more than 25 years, the company has tapped the power of scientific discovery and innovation to advance the practice of medicine. Amgen pioneered the development of novel products based on advances in recombinant DNA and molecular biology and launched the biotechnology industry's first blockbuster medicines. The purpose of this project was to integrate data from various sources and build a strategic global data warehouse for decision support and business metrics. As a Siebel Analytics developer Created repositories using Siebel Analytics Administration tool and developed reports by using Analytics web Answers, Intelligence dashboards, Delivers and scheduled reports using Delivers.

Responsibilities:

• Worked closely with Business Analyst for Analytics requirements gathering.
• Imported the Physical Meta Data from Various Data marts into the Physical Layer by defining the connection pool settings and Built Siebel Analytics Repository/Metadata.
• Created physical joins, logical joins and complex joins in Physical and BMM Layer.
• Worked Extensively on Siebel Answers to create reports and dashboards as per the client requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.
• Created Analytics Reports including Charts and Pivot tables, Compound layout using Siebel Answers.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data.
• Created intelligent bots iBots to send Alert messages to subscribed users.
• Environment: Oracle 9i, SQL Loader, PL/SQL, Informatica, Siebel Analytics, Crystal Reports, MS Office Suite and Windows 2003.

Confidential

Sr. DW Consultant

Confidential is one of the nation's leading Insurance providers, which offer a variety of products and services including life insurance, property, auto, home and specialty insurances. The primary objective of the project was to make a data warehousing system out of insurance customer's policies like property insurance data, loss claims data. Reporting capability was developed using Siebel Analytics.

Responsibilities:

• Created reports and dashboards as per the user requirements.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using router transformations.
• Worked with Business Analyst for analytics requirements and creating the business models.
• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Siebel Analytics Repository using Siebel Analytics Administration Tool as per the requirements.
• Worked extensively on Siebel Answers, Siebel Delivers, and Siebel Intelligent Dashboards for Compliance department using Siebel Analytics stand-alone/integrated implementation.
• Responsible for developing different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Created Security settings in Siebel analytics Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in Siebel Answers.
• Used Filters and provided customized prompts filtering options appropriately to avoid excessive data showing up reports.
• Responsible for unit testing, integration testing of the reports generated using Siebel analytics.

Environment: Siebel Analytics7.x, Erwin, DAC, Oracle9i, DB2, SQL Loader, PL/SQL, HTML, Informatica, MS Office Suite and UNIX.

Confidential

ETL Developer

Description: The goal of this project is to build a Customer-Centric data warehouse to analyze transactions across marketing, risk, collections, and consumer relations.

Responsibilities

• Developed processes for extracting, cleansing, transforming, integrating and loading data into the Data Warehouse.
• Involved in developing shell scripts for loading data into Oracle using SQL loader and developed control files for this process.
• Involved in designing procedures for getting data from all systems to Operational data store.
• Re-designing existing jobs with a different logical approach to improve the performance.
• Involved in creating table definitions, indexes, views, and sequences and materialized views.
• Developed Crystal Reports for risk analysis and collection modules.
• Involved in requirements gathering from business users and prepared requirement specification.
• GUI development was done using Developer/2000, Forms 4.5 Reports 2.5 as front-end.

Environment: Oracle 9i/8i, PL/SQL, Developer 2000 Forms 4.5, Reports 2.5 MS Office Suite and Windows 2000/XP.

Confidential

Oracle/PL/SQL Developer

Confidential is one of the leading private banking organizations. This system deals with automation of recurring and fixed deposit transactions.

Responsibilities

• Coded Current Account and Recurring deposit modules.
• Wrote PL/SQL packages for calculation of interest amounts on Recurring deposits.
• Wrote PL/SQL stored procedures/functions to build business rules.
• Worked on the Oracle performance tuning to load data to the target database.
• Implemented unit and system integration test.

Environment: Oracle 9i/8i, PL/SQL, Crystal Reports, SQL Server, MS Office Suite and Windows2000/XP