SUMMARY

8 years of IT experience, with 6 yrs. focused on Data warehouse, ETL and OBIEE reporting development life cycle involving Requirement Analysis, Design, Coding, Testing and Deployment. Deep expertise in Business Intelligence and ETL technologies. I am self-motivated, team player, intend to make a career in an esteemed organization giving ample scope for professional growth.

Major Strengths:

• Experience in OBIA Architecture and in depth experience in OBIA suite Oracle Database, ODI and OBIEE . Experience in Implementing Oracle BI Apps OBIA 11.1.1.8.1 HR, Financial and Procurement Spend Analytics with a data source as Oracle EBS. Expert in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, Oracle BI Delivers and OBIEE performance tuning of BI Applications.
• Extensive experience in providing end-to-end business intelligence solution by configuring metadata and building OBIEE Repository .rpd consisting of three layers Physical Layer, Business Model Presentation Layer using of Hierarchies, Aggregates, Partition Fragments, Time Series functions. Level based measures and Cache mechanisms.
• Excellent in developing OBIEE Reports and Interactive Dashboards with drill-down capabilities using global and local Filters, Security Setup groups, access/ query privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Analysis . Configure BI Agents to deliver reports.
• Extensive Data Warehousing experience with the Integration of various data sources like Oracle11g/10g/9i, MS SQL Server, DB2, Teradata, VSAM files, XML files and Flat Files into the staging area, ODS, Data Warehouse and Data Marts. Monitor DWH and BI systems performance and integrity, provide corrective and preventative maintenance as required.
• Extensively designed and developed ETL mappings with various transformations in Informatica Power Center 9.01. Creating Workflows with Worklets Tasks and scheduling using both Workflow Manager and DAC. Excellent in executing ETL routines for Full and Incremental loads into staging DWH.
• Experience in OLTP / OLAP System Study, Analysis and E-R modeling, developing Database Schemas in relational modeling like 3NF Schemas and multidimensional modeling like Star schema and Snowflake schema. Extensive experience with Fact, Dimension tables, slowly changing dimensions, Physical and Logical Data Modeling. Experience in working with Erwin tool.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, and Packages. Experience in writing UNIX shell Scripts and automate ETL process using scheduling tools like AUTOSYS. Experience in performance tuning of mapping and sessions.
• Excellent in developing and testing COBOL applications in Mainframe with VSAM and UNIX environment with Oracle DB. Proficient in writing JCLs and C Shell scripts to run batch using CA-7 Autosys. Experience in batch support and solve runtime abends in production.
• Excellent knowledge in solving Incident Problem raised, QA process, Change Management Process, Implementation Procedures and SDLC Process. Adept at working with internal and external teams including offshore teams and coordinating for on-time delivery of solutions and end users training.

Technical Skills:

Data warehousing / Business Intelligence:

BI Tools:

OBI Apps11g Configuration Manager BIACM , Functional Setup Manager FSM , OBIEE 10g, 11g Admin tool, Analytics, Enterprise Manager, and Admin Console , DAC, BI Publisher, Oracle SQL Developer.

ETL tools:

Informatica Power Center 9.01 Repository Manager, Power Centre Designer, Workflow Manager, and Workflow Monitor and ODI tools - Topology, Security Manager, Designer and Operator.

Data modeling Tools:

Erwin, MS Visio

Languages:

• Oracle SQL/PL SQL, UNIX Shell scripts Database:
• Oracle 10g/11g, Data Modeling Operating System/Environment:

Windows XP/2003/NT, UNIX

Mainframe/ UNIX Batch: -

Tools:

CA-7, File manager, Endeavor, Ellipse

Languages Database:

COBOL, CICS, JCL, UNIX shell scripts, DB2, VSAM

Operating System/Environment:

UNIX, Z/OS 1.7, OS/390, IBM3270 Emulato

Project Experience:

Sr. OBIEE Developer

Hong Leong group is a leading conglomerate based in Malaysia with diversified businesses in banking, insurance and financial services etc. Implemented the Business Intelligence Analytical Solutions for five different work streams HR, Insurance, Investments, Retirement, Employee Benefits and Life Advice of Hong Leong group, each stream is a different set of users. The project involved creating business intelligence solutions for the various work streams, by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level. This project helps to enhance decision making process regarding their products and customer based on data in the Enterprise Data Store. In addition to viewing dashboards, an analytics power user can create ad-hoc reports and charts, and also share or publish them to the user community. The OBI repository is designed to support analytical querying and reporting.

Responsibilities:

• Analyzed the business requirements and understand the Dimensional data model in the data warehouse designed based on mixed Star Schema. Identified Facts, Dimensions and defined the keys, relationship among the tables and prepared the design document.
• Extracted and customized the pre-built BI solutions of tables using Oracle BI Apps 11.1.1.8.1 HR Financial Analytics . Worked on repository development, configured metadata objects Subject Area, Table and Column and web catalog objects Dashboards, Filters, Prompts, Reports .
• Import the Meta data RPD of HR and Financial BI Apps into OBIEE11g Development Environment and creating the aliases to establish the joins and customized BI Apps solutions with Category 1, 2, 3 customizations according to the requirements.
• Configured Physical Layer - Import tables, Create Tables, add / change physical joins / keys. Setup the Cache settings for various tables and import the event polling table. Configured the separate connection pools for session variables, Aggregate tables.
• Configured Logical Layer - Create Logical Facts / Dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns. Added new Calculations to the Fact tables. Defined new Hierarchies to the dimensions.
• Configured Presentation Layer - Create Folders / sub-folders, Standard Queries for different User Groups. Setup the implicit columns for dimension only queries. Setup the permissions for objects like subject area, table, and column and specify the access type.
• Developed Analyses and Dashboards with different Analytics Views including Pivot Table, Graphs, Gauges, Column Selector and View Selector with global and local Filters Defined new prompts, filters and variables and customizing the existing objects.
• Implemented the delivery of BI-Agents using OBI Delivers to alert the associated teams. Implemented Object level security and data level security by setting the permissions in OBIEE Administration Tool and Analytics Page. Verified the Permissions of the users in OBIEE web.
• Develop Test Plan including test scripts for Unit, Integration, and User Acceptance Testing including resolution of bugs.
• Provided guidance and support to end users during the implementation in production.

Environment: OBIA 11.1.1.8.1, ODI 11g, OBIEE 11g, Oracle11g, SQL Developer, Erwin, UNIX

OBIEE Developer

Jusco Retail Stores is one of the leading company in the Asia pacific in Retail Sector, Jusco have various stores, which maintains the Database has lots of historical data. The Strategic requirement for the enterprise is to build a separate Data warehouse for Sales and Order Management using dimensional data modelling in 2 phases. Objective of SALES Data Warehouse is to analyze sales of major brands varying with different promotional schemes. New DW system is capable of analyzing the sales and profit and generates reports for Sales and Profits in year wise, month wise, weekly wise and days wise reports. OBIEE and BI Publisher is used for Business Intelligence reporting.

In Phase2, Order Management Data warehouse is implemented to analyze the Orders, Inventories and supplier performance with the enterprise. The resulting model gives us an idea about growth in profit, prediction about increase in sales.

Responsibilities:

• Being as a team player, analyzed the Reporting Requirements and designed and developed the Application Design and Test cases Document.
• Developed Oracle BI Metadata repository using BI Administration tool by importing data from various OLTP sources, Flat files.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model mapping layer.
• Developed measure for Time comparison using Time functions, To Date and Ago.
• Developed Analyses and Dashboards with different Analytics Views including Pivot Table, Graphs, Gauges, Column Selector and View Selector with global and local Filters using Oracle BI Presentation Services.
• Developed Analysis and Dashboard prompts with Inline and saved type and controlled the dashboard pages with 'Is Prompted' Option.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
• Configured BI Scheduler and Oracle BI Delivers- Agents to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Created reports using BI Publisher on MS Word and Excel. Developed reports using various templates to publish the reports as per user requirements
• Developed test cases and performed Unit testing, Integration testing of the repository and web catalogs generated by OBIEE and reports by BI Publisher.

Environment: OBIEE 11g, BI Publisher, Oracle11g, SQL, SQL Developer, LINUX

OBIEE Developer

The Personal Systems Group PSG of Hewlett-Packard Company is the division which deals with the sales and support of HP personal products. Implemented the Inventory Data warehouse to accurately forecast, measure, monitor and report by capturing the various products from different suppliers. It helps to track the availability of products in various stores across region that will facilitate management as a decision support system. The data will be organized according to requirements of the organization such as by Customer, Products, Sales, Orders, Region, Time and Accounts. The data captured using ETL will be further analyzed using various reporting tools. OBIEE Answers Dashboards is used for Business Intelligence reporting. Also Involved in the Migration Project of OBIEE 10g to OBIEE 11g.

Responsibilities:

• Used the OBIEE Administration tool to develop and enhance meta-data.
• Created connection pools, physical tables, defined joins, Identified facts, dimensional table to establish the relationship and implemented authorizations in the physical layer of the repository.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Built repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
• Built Business model and established relationships Foreign Keys Physical Logical between tables.
• Created new logical columns, dimensional hierarchies, calculated measures and aggregate mappings in the BMM layer as per the business requirements.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Developed custom reports using OBIEE Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tables/compound layout with global and local Filters.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Created Object and data level security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Analytics Page.

Environment: OBIEE 10g, Oracle10g, SQL, SQL Developer, Windows 2003

ETL Informatica Developer

The Personal Systems Group PSG of Hewlett-Packard Company is the division which deals with the sales and support of HP personal products. Implemented the Inventory Data warehouse to accurately forecast, measure, monitor and report by capturing the various products from different suppliers. It helps to track the availability of products in various stores across region that will facilitate management as a decision support system. The data will be organized according to requirements of the organization such as by Customer, Products, Sales, Orders, Region, Time and Accounts. The data captured using ETL will be further analyzed using various reporting tools.

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Analyzed business requirements and worked closely with the various application teams and business teams and developed ETL procedures that are consistent across all application and systems.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections. Pre and Post session assignment variables were used to pass the variable values from one session to other.
• Extensively used Source Qualifier Transformation and created different transformations such as Joiner, Expression, Aggregator, Rank, Lookups, Filters, Normalizer, Stored Procedures, Update Strategy and Sequence Generator.
• Developed several reusable transformations and mapplets that were used in other mappings. Created complex mappings which involved SCD Type II, III, implementation of Business Logic and capturing the deleted records in the source systems.
• Designed workflows with many sessions with decision, assignment task, and event wait, and event raise tasks, used informatica scheduler to schedule jobs and monitored the results using workflow monitor.
• Performed Unit testing at various levels of the ETL and actively involved in team code reviews. Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations. Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Actively coordinated with testing team in the testing phase and interactively work with the team for the successful implementation of the project.

Environment: Informatica Power Center 9.01, Oracle 11g, SQL, PL/SQL, UNIX, Windows XP

ETL Informatica Developer

CIMB Bank is one of the leading financial services company in South East Asia. This project was to create Sales Data Warehouse and generate reports using Oracle BI. The system has a database which stores information about sales, profits and contacts of customers.

The resulting model gives us an idea about growth in profit, prediction about increase in sales. The data Warehouse was further used to do Market Based analysis. The data Warehouse plays a major role in enabling various stores to view the data at a lowest level and help them to make decisions to bring more revenue to company with new policies.

Responsibilities:

• Analyzed business requirements and worked closely with the various application teams and business teams and developed ETL procedures that are consistent across all application and systems
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from Flat files, OLTP database to Data warehouse.
• Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load consistent data into Data warehouse. Implemented SCD methodology including Type 1, Type 2 to keep track of historical data.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Wrapped the sessions with pre-session and post-session UNIX shell scripts. Worked with Parameters and Variables at mapping and session level.
• Created Workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs and sessions to run a mapping and scheduled batches for the daily load of data.
• Executed Workflows and Sessions and monitored using Workflow Monitor. Maintain Development, Test and Production mapping migration using Repository Manager.
• Developed Test cases, Unit tested and reviewed the test results along with the QA team. Worked on complete SDLC for Extraction, Transformation and Loading ETL of data using Informatica.

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL, PL/SQL, UNIX, Windows XP

Database Developer

CIMB Bank is one of the leading financial services company in South East Asia. This Project is a re-hosting of online and batch applications for the trade finance banking systems from legacy mainframe environment to UNIX platform. The new UNIX system facilitates to enhance the business online application in future and also to reduce the cost of application maintenance running in legacy mainframe. The deployment was done successfully with online and batch migration which includes writing shell scripts and enhancing COBOL programs with embedded SQLs and stored procedures to accessing oracle database at the backend. The batch changes involved the core batch processing, interfaces and reports to UNIX platform.

Responsibilities:

• Involved in Database Development Life Cycle including Analysis, Data Modeling, Mapping ER diagrams into tables, normalizing the relations and coding.
• Developed a Conceptual model based on requirements analysis and normalized Logical and Physical model to design OLTP system for Bank trade systems using Erwin tool.
• Used forward engineering approach for designing and creating databases. Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications.
• Developed complex SQL queries using various joins, sub queries, unions, aliases, aggregate functions and developed various dynamic SQL's thorough out the projects.
• Developed PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures.
• Involved in data conversion from COBOL EBCDIC to UNIX ASCII format and data loads using SQL loader Import utility. Developed UNIX Shell scripts for MF JCL Conversion for batch scheduling in UNIX platform.
• Worked on all phases of the project from initial concept through research and development, testing, QA, implementation by strict adherence to project timelines.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, Erwin, UNIX

COBOL / SQL Developer

Meijer is ranked as one of the largest retail chains in the U.S. and in the world. HTC is one of the IT service provider for Meijer in both onshore offshore supporting mainframe based batch applications. As a Programmer, involved in the development and testing of the Auto Scorecard project. The project involved developing a system to approve carriers, maintain email address information for carriers, generate carrier performance and ranking reports, and to distribute reports to the carriers via email.

Responsibilities:

• Preparing technical specifications and design document
• Developing COBOL programs embedded with SQL and JCL procedures
• Developing SORT, PARM parameters using IBM MF Utilities and created run JCLs.
• Tuning SQL queries for better performance
• Developed Unit Test Cases and perform Unit testing with positive and negative conditions.
• Revisit the coding and resolved the bugs raised in SIT UAT phase.

Environment: COBOL, DB2, VSAM, JCL, and MVS, ZOS1.4