SUMMARY

• Over all 11+ years of IT experience with prime focus on Analysis, Design, Development, Customization, Data Modeling, Gap Analysis, Testing, Administration, Documentation and Maintenance of Data Warehouse / Data Marts, Business Intelligence.
• 10+ years of strong background in Analysis, Design, Development, Implementation of Data Warehousing in ELT/ETL & BI, including 6 years of experience in ODI (Oracle Data Integrator)
• Good exposure to business domains like telecommunication, manufacturing, sales, consumer goods, financial services and health insurance and trains the users.
• Worked extensively in developing ELT for supporting Data Extraction, Transformation and Loading using ORACLE DATA INTEGRATOR 12.2.1.2.6/12.1.2.0.0/11.1.1. x/10.1.3.5
• Extensively used ODI (Oracle Data Integrator) to perform ELT from heterogeneous sources using ODI tools - Designer and Operator also good knowledge in Security Manger & Topology Manager
• Experience working with ODI Knowledge Modules such as LKM, IKM, CKM, JKM, RKM.
• Working experience in Creating ODI packages, scenarios using mappings/interfaces, variables, procedures and Topology including physical architecture, logical architecture.
• Excellent Data Analysis Skills and ability to translate Business logic into mappings using complex Transformation logics for ELT/ETL processes.
• Experience in customization of Knowledge modules.
• Efficient in troubleshooting, performance tuning and optimization of ELT/ETL and reporting analysis.
• Experience in Data Warehousing development using ETL tools such as Informatica 9.x/8.x/7.x
• Working in design, development and configuration of RPD, Dashboards, Reports, Analysis & Interactive Reporting, OBIEE 11g new functionality and implemented Filters, Scheduled Reports, Prompting, Drill Thru, Multi-lingual reporting, Design reports and dashboards using OBIEE11G dimensional hierarchies. Design And Develop ad-hoc queries, reports and dashboards.
• Experience in configuring interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Setup groups, access privileges, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.
• Experience in creating entity relational & dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema
• Involved in development of Informatica Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy Transformer etc.
• Experience in developing Informatica Mappings / Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookup, Router, Update Strategy) for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse
• Excellent knowledge and experience in data warehouse development life cycle, designing data marts, requirement analysis, dimensional modeling, implementation of STAR, Snowflake schemas; Incremental loads, Change Data Capture (CDC) and slowly changing dimensions (SCD).
• Implementation of Oracle Financials. (GL, AP, AR, CM, FA) Implementation of Oracle Inventory & Purchasing. Development experience in Oracle HRMS, Payroll. Administration and implementation of Oracle Business Intelligence using OBIEE, OBIA, ODI.
• Knowledge setting up of multi load Hadoop clusters.
• Understanding of various enterprise security solutions such as LDAP.
• Understanding of network configuration, devices, protocols, speeds and optimizations.
• Configured multiple WebLogic domains including machines, manage servers, node managers and cluster environments
• Knowledge in Hadoop echo system including Spark, MapReduce, HDFS, Hive, HBase, Sqoop, Flume, and zookeeper.
• Knowledge in HDFS environment using tools such as Apache Hive.
• Effective team building and problem solving abilities.
• Knowledge in Linux kernel configuration
• Configuration, deployment and trouble shooting in Linux environments
• Exclusively worked on different flavors of UNIX /Linux and Windows operating systems and good Experience in UNIX shell scripting.

TECHNICAL SKILLS

Data Warehousing/ ELT/ETL: ODI 12c, ODI 11.1.1.x and ODI 10g (10.3.5.6), Informatica Power Center 9.x/ 8.6.1/8.1.1/8.0/7.1.2/7.1.1

Dimensional Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Siebel Analytics/OBIEE: OBIEE 12c, 11.1.1.7.x/ 10.1.3.1/3.2/3.3/3.4 ,,OBIApps 7.9.5/7.9.6/7.9.6.4/11.1.7 , 11.1.1.9.

Echo Systems: Hive, Pig, Sqoop, HBase, Oozie, Zookeeper, and Map viewer.

Monitoring Tools: Cloudera Manager.

Operating Systems: MS-DOS, Windows family, UNIX, Red Hat Linux.

Database Tools: Oracle 11g/10g/9i/8i/8.0/7.x, MS SQL Server 2000/7.0/6.0 , MySQL.

Defect Tracking: HP QC/Service Manager, BMC Remedy.

Work Experience:

Confidential, CA.

ODI Data Integration Analysts (ELT)/Senior Developer

Responsibilities:

• Requirements gathering, Analysis, gap analysis, Designing, Technical documents preparation
• Development of various data feeds from disparate sources such as (relational databases, flat files) using Oracle Data Integration (ODI) Tool to the DWH or to separate Data Mart
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios
• Worked on Check Constraint Knowledge Module (CKM), Loading Knowledge Module (LKM), and Integration Knowledge Module (IKM)
• Assist business functions to coordinate on extraction of data from warehouse to the function specific data marts such as - Capitation, Health, TOS CAT and DataMart
• Maintained data quality by implementing Flow Control.
• Implemented CDC and slowly changing dimensions -2 for customer and claims data.
• Facilitate ODI ELT data mapping by gathering legacy technical information as needed and providing ODI technical information (table names, field names, Scenarios, Job Scheduling information, etc.)
• Customized Knowledge modules as per requirement.
• Implemented the industry best practices as part of performance of ODI Jobs.
• Monitoring/trouble shooting Production jobs and providing solution also helping on Nonfunctional requirement in terms of infrastructure.
• Created mapping using procedure to data store and file to file.
• Coordinate data extracts for testing efforts - unit testing, cycle testing and dry runs; Provide information for cutover planning with business to get sign-off and production move.

Environment: ODI 12.2.1.2.6/11.1.1. x, Shell Script, Oracle 11g, MS SQL Server 2008, OBIEE 11g/12c.

Confidential, Diamond bar, CA.

ODI Consultant/OBIEE Consultant

Responsibilities:

• Requirements gathering, Analysis, gap analysis, Designing, Technical documents preparation
• Implemented data mart to support efficient rollup datasets- that enables Americas Sales Force and Commercial Ops and Higher Management to track real time Orders, Opportunities, Revenue and Orders & Revenue forecasting and Install Base Insight to the lowest entities
• Integration of various source systems from EDW to capture America’s Sales data into SQL Server Report Data Mart using ODI ELT S2T Mapping
• Implementing the extraction, loading, and transformation (EL-T) of data using Oracle Data Integrator; configuring the ODI master and work repositories, ODI models
• Design and develop ODI project using interfaces, packages, procedures, variables and knowledge modules.
• Developed Source to Target Mappings using ODI Designer to load data from source systems like SQL Server and flat files to target database.
• Worked on Check Constraint Knowledge Module (CKM), Loading Knowledge Module (LKM), and Integration Knowledge Module (IKM) and JKM.
• Implemented slowly changing dimensions -2 for customer data and SCD1 for Channels, Products and Promotions.
• Implemented reports and dashboard that enabled report users to analyze data (slicing and dicing) by Zones, Regions, AE, AM’s, Fiscal Calendar Parameters.
• Developing UNIX for scheduling jobs and sending an alert on failure, file archiving
• Involved in Unit, integration, performance testing, test cases preparation and design reviews and reconciliation

Environment: Oracle 11g, ODI 11.1.1.7.0 (Data Integrator), OBIEE 11g, MS SQL Server 2008, Oracle 11g, Erwin data modeling tool

Confidential, Rockville, Maryland.

ODI Data Integration Analysts (ELT) and Developer

Responsibilities:

• Target Functions - Assignments involves creating the staging, dimension and fact tables across various environments and loads the data from different sources DB2, Netezza, SQL Server and files to build one stop data hub for reporting and analysis or in to Function Specific Data Marts using ODI ELT Tool
• Development of various data feeds from disparate sources such as (relational databases, flat files) using Oracle Data Integration (ODI) Tool to the DWH or to separate Data Mart
• Using ODI, Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Staging tables and to DWH
• Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios
• Worked on Check Constraint Knowledge Module (CKM), Loading Knowledge Module (LKM), and Integration Knowledge Module (IKM)
• Assist business functions to coordinate on extraction of data from warehouse to the function specific data marts such as - Capitation, Health, TOS CAT and DataMart
• Facilitate ODI ELT data mapping by gathering legacy technical information as needed and providing ODI technical information (table names, field names, Scenarios, Job Scheduling information, etc.)
• Maintained data quality by implementing Flow Control.
• Implemented CDC and slowly changing dimensions -2 for customer and claims data
• Worked on various ongoing ODI assignment required to revamp the existing ODI process for new servers and for optimized throughputs
• Assisting in BCBSFL ODI ELT Team in development/ support for notification of erroneous data and on production job failure
•  Accountable for Financial Analysis and planning in the Corporate Finance team in identifying the metrics for sales growth and forecast of company performance using tableau
• Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using feature such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Involved in Tableau Server installation, configuration, creating Users, Groups, Projects and assign Privileges etc.
• Coordinate data extracts for testing efforts - unit testing, cycle testing and dry runs; Provide information for cutover planning with business to get sign-off and production move Project Execution:

Environment: ODI 11.1.1.6, Unix Script, IBM Netezza, DB2, Oracle 10g, MS SQL Server 2008, WinSQL,Tableau7.x,OBIEE 11g

Confidential, CA.

ODI/OBIEE Lead

Responsibilities:

• Requirements gathering, Analysis, gap analysis, Designing, Technical documents preparation
• Defined new data marts for Americas Sales Force data structures, functions, data warehouse fact & dimension tables and views
• Modified and created the ODI Knowledge Modules such as LKM, IKM, CKM, and JKM.
• Creating ODI packages, scenarios using interfaces, variables, procedures.
• Creating incremental loads, facts and dimensions, designed new data elements and tables for data marts
• Installing and Configuring ODI 11g on all the environments with standalone agents for custom Data Warehouse project.
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Involved in the installation, configuration, customization and extension of OBIEE, OBIA, and ODI.
• Worked with Enterprise Manager for deployment and control of repository, web catalog and configuring parameters.
• Responsibilities included Building of RPD application design for Physical, Logical, and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher and testing, and deployment
• Created proactive agents iBots and interactive Dashboards to alert the Administrative team about changes. Managed day-to-day Repository, Scheduler & iBots.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Principal and Teacher Evaluation dashboard.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Responsible for migrating the web catalog and RPD from DEV, UAT and PROD environments.

Environments: ODI 11.1.1.5, OBIEE 11.x, BIApps (Financial Analytics), Oracle EBS 11i/R12, SQL Developer, Toad, Windows XP.

Confidential, NY.

Lead Developer

Responsibilities:

• Done analysis to understand data structure and data flow of legacy system and defined implementation plan (Data flow) according to the time constraints and NMAC DWH infrastructure on new NMAC Technology stack
• Done ODI architecture of the new application using topology, various database schema setup and set the ODI projects
• Defined data model to hold Filter, Scale, and Various External Data Feeds (Bid Wanted’s, Bond Characteristics, Scale, Customer Information, Bid Wanted Matching, Pricing, TIPS and system notification etc.
• Implemented ODI Mappings to load data from and to Oracle, MS SQL Server, Flat Files, and XML Files etc. using ODI 11g.
• Done the setup of scheduling option as per the business hours to turn-on and turn off the Bidding Engine
• Coordinate data extracts for testing efforts - unit testing, cycle testing and dry runs; Provide information for cutover planning with business to get sign-off and production move

Environments: ODI 11.1.1.5, OBIEE 11.x, BIApps (Financial Analytics), Oracle EBS 11i/R12, SQL Developer, Toad, Windows XP.

Confidential, NJ

BI Developer

Responsibilities:

• Develop, implement and deploy data warehousing and business analytical solutions
• Troubleshoot all issues and figure out the root cause/s of those issues
• Standardize and improvise data quality through periodical data cleansing and auditing process
• Maintain and monitor the data documentation for all data warehouse and reporting formats
• Collaborate with end-users to check the efficiency level based on report requirements
• Work with various teams across the organization, clients and other stakeholders to successfully carry out the enterprise level BI solutions
• Worked extensively with the prebuilt OBI Marketing Applications & Custom repository.
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Implemented Security by creating roles & web groups.

Environment: OBIEE 10.1.3.4.1 , Informatica 8.6, DAC, Oracle 10g, Pl/Sql, Source System is EBS (11G), Oracle DB 11g, Red Hat Linux.

Confidential

Developer (Siebel Analytics/OBIEE)

Responsibilities:

• Designing the architecture of the data warehouse
• Structuring the nightly refresh of data load and scheduling it through DAC (Data warehouse administration Console)
• Implementation of the data level and view level security, Involved in developing the Incremental ETL
• Iterative development of analytics dashboards, Answers requests, charts, pivot table layouts, dashboard prompts
• Merged new RPD, dashboard and Answers requests with existing analytics content
• Architected analytics solution to analyze multiple client reporting needs
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution

Environment: OBIEE 10.1.3.2(Siebel Analytics Applications), Administration Tool, Informatica. SQL Server 2005, reporting Services, Integration services

Confidential

Siebel/Analytics Developer

Responsibilities:

• Upgraded and migrated Siebel Analytics repository (.rpd) database from Siebel Analytics7.8.2 to Siebel Analytics 7.8.4
• Designed and build Star schemas
• Interaction with the end users for the requirements
• Participated in complete life cycle of the project from Project Initiation, to Development and Maintenance.
• Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Siebel Analytics Administration Tool
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution
• Configured repository (RPD) to use the LDAP authentication
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer
• Defined dimensions and facts in the subject areas
• Implemented OBIEE security for users and groups in administrator tool
• Created reports by applying views, filters, calculations and conditional formatting in answers
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Created and scheduled iBots as per the business requirements
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process
• Applied Optimization techniques and tuned performance of the reports
• Provided technical and user documentation and training

Environment: OBIEE 10g, Siebel Analytics Applications, Administration Tool, Informatica. SQL Server 2005, reporting Services, Integration services

Confidential

BI Developer

Responsibilities:

• Created Oracle BI Repository (.rpd) at three layers Physical Layer, Business Model and Mapping Layer & Presentation Layer).
• Created new dashboards/reports and made recommendations to report layout with reference to table, narrative, pivot, chart views in Presentation Services and embedded them into new/existing dashboards pages as required by the project.
• Created users and application roles to implement object and data level securities.
• Created presentation, repository and session variables to meet the user requirements.
• Created Hierarchies for the drill down functionality.
• Migrated the Catalog and repository from one environment to the other.
• Used Opaque views in the Repository for reporting on the source systems.
• Prepared the Technical Design Documents.