SUMMARY:

• 6 years expertise in End-to-End Implementation of Data Warehouse and Business Intelligence applications for clients in major industry sectors like Health, Insurance and Retail.
• Expertise in developing OBIEE consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Extensive experience in configuring Interactive Dashboards/Reports with drill-down capabilities using global and local filters, Contextual Navigation, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in debugging and optimizing theOracle BI Dashboards / Reports and Informatica Mappings / Workflows.
• Experience in installation and configuration of Oracle BI EE 10.1.3.2 and 10.1.3.3
• Expertise in performance tuning of Oracle BI Repository & Dashboards / Reports, by implementing Aggregate tables, Indexes and managing Cache.
• Extensive BI Publisher experience integrated with OBIEE
• Worked Extensively on Informatica 8.6.1/8.1/7.1/6.2/6.0/5.1 PowerCenter Client tools - Designer, Repository manager, Workflow manager/monitor and Server tools Informatica Server, Repository Server manager.
• Expertise in Data Warehouse/Data mart, OLAP and OLTP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ER-Studio.
• Expertise in working with relational databases such as Oracle 10g/9i/8x, SQL Server 2000/2005, DB2 8.0/7.0,.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Set up the DAC parameters for Incremental and Full loads
• Researched and resolved issues occurs during the initial load and incremental load
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to generating reports to business users.
• Hands on experience in customizingreports, filtersandchartsin OracleAnswers.
• Comprehensive knowledge inDebugging, OptimizingandPerformance Tuningof Oracle BIDashboards/Reportsby implementingAggregate navigation,cache management.
• Worked extensively with slowly changing dimensions.
• Hands-on experience in Agile Methodology and across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Strong analytical, problem-solving and organizational skills.

Technical SKILLS:

Operating Systems

Windows 200X/XP/95/NT Server. UNIX (Sun-Solaris, AIX, HP/UX), Linux.

ETL Tools

Informatica PowerCenter 5.X/6.X/7.X/8.X

Databases

Oracle 8i/9i/10g/11i, MS-SQL Server 2000/2005/2008,My SQL
and MS-Access

Languages

C, C++, C#.Net, Java 1.5, J2EE, UNIX Shell Scripting, PL/SQL

Reporting Tools

OBIEE

Modeling

Star-Schema Modeling, Snowflake Modeling, FACT and Dimension Tables,

EDUCATION:

Bachelor of Technology in Information Technology

PROFESSIONAL EXPERIENCE:

Confidential, OH May’10-June’11
OBIEE Developer

Responsibilities:

• Participated in requirements gathering of functional areas by meeting with the business users and identifying the details of appropriate measures and dimensions.
• Analyzed the Various Design Scopes for the SCM Solutions and also understanding the Business Process pertaining to it
• Analyzed, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBIEE) Analytics platform.
• Worked extensively in multi-user development environment on RPD
• Translated business requirements into data mart design and developed the detailed design of Analytical Data Model (Metadata / .rpd) and Reports / Dashboards. based on the requirements
• Tasks also include backup of the RPD code line and delivery of the code line to the Client periodically.
• Worked on time series functions to implement time comparison measures.
• Modeled time series and slowly changing dimension data.
• Implemented object level and row level security based on roles and responsibilities of end users.
• Involved in the migration of Repository & Web Catalogs/WebCat from Development to Test & Production server.
• Performance tuning of Reports / Dashboards by implementing the Aggregate tables, and managing Cache.
• Customized reports from the existing Subjects Areas & incorporated Global Prompts & Filters.
• Participated in installation and configuration of OBIEE 10.1.3.2 in windows environment.
• 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 in the repository.
• Developed over 40 Reports and 12 Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle Business Intelligence (OBI) Presentation Services for the various work streams.
• Created Logical dimensions, Aggregates & Hierarchies/levels using Analytics Admin Tool.
• Configured Repository, Session variables to generate dynamic reports.
• Rigorous testing of reports for any possible data inconsistencies.
• Update the management on issue and resolve.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.2, Oracle 9i, Informatica PowerCenter 8.6, Toad, Putty, Linux, Windows

Confidential,CO May’09-Apr’10
OBIEE Developer

Responsibilities:

• Involved in gathering business requirements, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping

Layer and Presentation LayerusingOracle Business IntelligenceAdmin tool.

• Createdconnection pools, physical tables, definedjoinsand implemented authorizations in the physical layer of the repository.
• Performed the detailed design of Analytical Data Model (Metadata / .rpd) and Reports / Dashboards.
• Participated in the installation and configuration of OBIEE 10.1.3.2 in windows environment.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Modified several existing reports and dashboards, and fixing some of the issues related to performance and data quality during production support.
• Created Dimensional Hierarchy, Level based Measures andAggregate navigationinBMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Developed customreports/Ad-hocqueries usingOracle Answersand assigned them to application specific dashboards.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies in BMM layer
• Developed different kinds ofReports(pivots, charts, tabular) using global and local Filters.
• Created proactive agentsiBotsand interactive Dashboards to alert the financial team about business changes.
• Managed OracleDelivers,Scheduler & iBots.
• Handled Full load and refresh load viastagingtables in theETLLayer.
• Involved inDesignandData ModelingusingStar schema.
• Developed several mappings to load data from multiple sources to data warehouse.
• Created users, groups using Web Admin Tool & assigned different dashboards permissions as per data visibility rules defined by the client.
• Implemented Security by creating roles & web groups.
• Modified several existing reports and dashboards, and fixing some of the issues related to performance and data quality during production support.
• Trained users on the generated reports of this project and documented the work.

Environment: OBIEE 10.1.3.2,Oracle BI Applications7.9.6.1, Informatica 8.6.1, DAC,Oracle 10g,SQL Developer, SQL*Plus, Windows

Confidential,TN May’07-Apr’09
OBIEE Developer

Responsibilities:

• Gathered business user’s reporting requirements and prepared the requirement specifications document. This involved interviewing the business users and understanding the current reporting system.
• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables & their definitions.
• Analyze, Design and Developed CP/CR Analytical Metadata repository (.rpd) as per the data requirements that consists of physical layer, multiple business model / layers with dimensions & time series objects, presentation layers with presentation catalogs, LDAP security using variables
• Design and developed various Dashboards /Reports that are Dynamic & Interactive with drill-down & drill-across capabilities with local & global filters.
• Used BI publisher to customize and extend the reporting content delivered.
• Created Role based authorization and access to report folders and data sources for BI Publisher.
• Configured & published Delivers / iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed many Mappings using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting, transforming and loading the CP/CR data
• Extensively used DAC to configure, monitor and schedule ETL routines.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

Environment: OBIEE 10.1.3.2, Informatica 6.2, Oracle9i, SQL-Navigator 4.5, Erwin 4.0.

Confidential, Feb’06-Mar’07
ETL Developer

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• Involved in dimensional modeling of the data warehouse to design the business process, grain, dimensions and facts.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created cubes, dimensions, hierarchies, mappings and mapplets using Informatica Power Center Designer
• Extracted data from Oracle as one of the source databases.
• Involved in JAD sessions for the requirements gathering and understanding.
• Involved in the ETL design and its documentation.
• Extensive experience with PL/SQL in designing, developing functions, procedures, triggers and packages.
• Developed mappings in Informatica to load the data including facts and dimensions from various sources into the Data Warehouse, using different transformations like Source Qualifier, JAVA, Expression, Filter, Aggregate, Update Strategy,Router Normalizer and Joiner.
• Developed mapping in Informatica to handle XML data and Web Services using XML Transformations like XML parser and XML generator
• Developed reusable Mapplets and Transformations.
• Optimized the performance of the mappings by various tests on sources, targets and transformations
• Design, develop and Informatica mappings and workflows; Identify and Remove Bottlenecks in order to improve the performance of mappings and workflows
• Review existing code, lead efforts to tweak and tune the performance of existing Informatica processes
• Scheduling the sessions, workflow to extract, transform and load data in to warehouse database on Business requirements.

Environment: Informatica Power Center 6.2.2, Erwin 4.2, Oracle 9i, SQL * Plus, PL/SQL, Windows XP Professional 2002, UNIX.

Confidential, June’ 05 Jan’06

Responsibilities:

• Worked with the business analysts and DBA to gather business requirements to be translated into design considerations.
• Involved in dimensional modeling of the data warehouse to design the business process, grain, dimensions and facts.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Created cubes, dimensions, hierarchies, mappings and mapplets using Informatica Power Center Designer 6.2.
• Resolving the production issues in production support.
• Configured the Informatica Power Connect to extract data from Oracle 8i, SQL Server, UDB DB2 data sources.
• Used various transformations like lookup, update strategy, router, filter, sequence generator, source qualifier on data extracted according to the business rules and technical specifications.
• Used task developer in the Workflow manager to define sessions.
• Created reusable worklets and mapplets.
• Involved in data cleansing and data profiling.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run the sessions.
• Developed schedules to automate the update process and Informatica Batches/Sessions.
• Monitored sessions that were scheduled, running, completed or failed.
• Debugged mappings for failed sessions.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions.
• Implemented data integrity constraints like referential integrity using primary-key and foreign-keys relationships.
• Involved in extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Wrote PL/SQL procedures for processing business logic in the database.
• Involved in production support.
• Created different types of reports such as Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects. Use of filters, conditions, calculations, etc
• Documented processing times, developed test cases and used them to run through each process.
• Tuned the matching parameters based on test results.
• Implemented and supported the Business Intelligence environment and User Interface.

Environment: Informatica Power Center 5/6.2, Oracle 8i, UDB DB2, SQL Server (7.0/2000), SQL/PLSQL, UNIX Shell Programming.