PROFESSIONAL SUMMARY:

• Over 8+ years of strong IT consulting experience, with profound knowledge in Analysis, Design, Development and Maintenance of Business Applications in Government Sectors, Manufacturing, Retail, Finance and Health care.
• Created LOGICAL DATABSE MODEL by framing up all Entities, Entities Relationships, attributes and associated keys using ERWIN DATA MODELLER and SYBASE POWER DESIGNE, ORACLE DESIGNER, TOAD DATA MODELLER.After logical model is approved generated the corresponding PHYSICAL DATABASE MODEL by populating them into TABLES, Columns and establishing accurate Primary Key Foreign Key Relationships. Even Constraints are also enforced at column level to match the business requirements.
• Strong in Implementing ETL/ELT processes using Informatica (9.x), Power center designer, Power center workflow manager, Power center workflow monitor, Power center repository manager and Oracle ODI & Warehouse Builder.
• Strong understanding of the principles of Data Warehouse using Fact tables, Dimensiontables and Star Schema modeling, Snow flake modeling with sound knowledge of database architecture for OLTP and OLAP applications.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel AnalyticsDashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration, user maintenance and proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Proficiency in security management of all aspects of OBIEE (Siebel Analytics). Extracted data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Developed OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Analytics, created Ad - hoc reportsper the client needs.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
• Maintained Tables with Primary Key, Foreign key relations (Referential integrity). Created column level Constraints like NOT NULL, UNIQUE, CHECK for values, DEFAULT set of values like SYSDATE etc. Created INDEXES for columns to make the SQL, PL/SQL response time faster.Havegood knowledge in handling System and user defined Exceptions.
• Proficient in writing SQL code for DML’s, DDL’s and DCL’s with good knowledge in creatingPL/SQL Anonymous blocks, Packages, Stored Procedures, Functions and Triggers. Maintained database activities for Oracle schemas using SQL and PL/SQL programing. Performed fine tuning of SQL and PL/SQL code using Cost based methods using tools like TOAD query optimizer, SQL Developer. Data Migration using SQL Loader, UTL FILE package for loading data into Oracle.
• Developed Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users.
• Performance tuning of SQL and PL/SQL code by providing HINTS, running Explain Plan and creating INDEXES as need & eliminating unnecessary joins in long queries. Filtering only required set of data at source level.
• Implemented Security features for users and objects via GRANTS, REVOKINGPRIVILEGES and enforcing mapping level Security features like READ ONLY MODE and controlling FILE level SECURITY by altering read, write execute as needed.
• Strong data warehousing experience using Informatica Power Center, Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB),OBIEE, Microsoft SSIS.Implemented Change Data Capture, SCD-Type 1, SCD-Type 2, SCD-Type 3 mappings in in ETLInformatica and ELTODI to populate heterogeneous source data into Targets.
• Experience on dealing with ODI Knowledge Modules like, LKM, IKM, CKM and JKM.
• Have good hands-on knowledge in creating Unix Bash, Korn, Perl scripting. Created scripts to Archive the processed Flat files, Compressing the files to free server storage space, working with the Unix environment for giving user access file permissions, creating scripts to sort the files in sort order and process the recent files, to remove carriage returns, to move the file from one server environment to another, to email the files and concat the files.
• Used the OBIEEAdministration tool to develop and enhance Data Model. Customized and developed RPD ( Physical, Businessmodel and PresentationLayer), configured metadata objects and Web Catalog Objects.
• Ability to work independently and work with teams having various backgrounds on solving complex issues and have strong verbal and written communication skills along with strong analytical and decision-making skills.

TECHNICAL SKILLS:

Database Tools: Toad10.0, PL/SQL Developer 9.0.1,Teradata SQL Assistant 12.0

ETL Tools: SQL Loader, Oracle ODI, OWB, Informatica 9.X, 8.X, SSIS, DAC, PMCMD.

Operating Systems: Windows NT, 2000, 2003 Server, XP, 7, 8,10 and UNIX.

ProgrammingLanguages: SQL, PL/SQL, C.

Data Modeling Tools: Oracle Designer 2000, Sybase power designer 12.5, Erwin 10.

Web application Tools: HTML, XML, Oracle Form builder 10g.

Reporting Tools: Oracle Report builder 10g, OBIEE 11.

ALBANY - NEW YORK

BI Expert - Database PL/SQL ETL/EL-T, BI Reports

Responsibilities:

• Involved in Analysis and design of Database Objects for various data collection systems. Created mappings documents to transformation legislative requirements into system functionality models and implemented data modelling of the requirements. Involved in development of tasks including coding, testing, and implementation.
• Prepared Technical and User documentation for applications and field mapping documents for all transformations and complex SQL, PL/SQL scenarios. Created LOGICAL DATABASE MODEL (ER DIAGRAMS) with Entities Relationships, attributes and associated keys using ERWIN DATA MODELLER.After logical model is approved generated the corresponding PHYSICAL DATABASE MODEL by populating them into TABLES, Columns and establishing accurate Primary Key Foreign Key Relationships.
• Created Database/Datamart designs with respect to Application technical architecture point of view considering the aspects like coordination with other business applications and products that run on those platformsand which share common modules in DATABASE point of view.
• Designed efficient Databases by implementing logical and physical database models with an in-depth knowledge in concepts such as indexes, primary keys, foreign keys, constraints and Normalization techniques.
• Prepared Technical and User documentation for applications and field mapping documents for all transformations and complex SQL, PL/SQL scenarios.
• Constraints like NOT NULL, UNIQUE, DEFAULT VALUES like SYSDATE and standard CODED VALUES are defined at column level to match the business requirements. Developed SQL scripts for creating various database objects like Tables, Views, Indexes, Triggers, Sequences and Synonyms etc. based on physical data model.
• Using Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications on frequent basis.
• Worked with Cluster DBA's in creating Backup and Recovery of DATABASE Schemas and STAGE Environment Data.
• Created Security for all user’s accesses.
• As Database developer played key leadership role in supporting large teams with various backgrounds and has proven experience in solving complex scenarios.
• Experience developing Oracle PL/SQL using advanced PL/SQL programming techniques. Used Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications.
• Designed efficient Databases by implementing logical and physical database models with an in-depth knowledge of concepts such as indexes, primary keys, foreign keys, and constraints.
• Profound Experience in implementing & performing Extract, Transform, and Load of Data from Homogeneous sources and Heterogeneous sources using (ETL/ELT) techniques.
• Good implementation knowledge in optimizing, performance tuning, and debugging PL/SQL. Designed oracle schemas in Normalized form all the OLTP application systems. Maintained PRIMARY key and FOREIGN key relations and avoided redundancy.
• Experience in developing Oracle PL/SQL using advanced PL/SQL programming techniques.
• Created ETL design documents for interfaces and mappings, ETL Source to target mapping documents, ETL implementation documents using Oracle Data Integrator and Pentaho Data Integration ETL tools, unit test plans and deployment check lists documents.
• Developed complex PL/SQL objects like Stored Procedures, Functions and Packages in oracle for implementing/building logic for complex business requirements.
• Did Data analysis by developing SQL and PL/SQL scripts for testing data after completion of data load operations.
• Extensively used SQL Loader for loading data from comma separated CSV files from Albany county Sherriff Department into staging tables.
• Has good Knowledge in PL/SQL advanced objects like Collections using ASSOCIATIVE ARRAYS, NESTED TABLES and VARRAY. Configured user defined exceptions using DBMS STANDARD.RAISE APPLICATION ERROR procedure.
• Created TRIGGERS to NOTIFY and pass alerts for BEFORE insert and AFTER updates PL/SQL programs.
• Created FUNCTIONS to REUSE them by passing values and getting the RETURN value. So, common functionality can be achieved by calling the FUNCTIONS.
• Created PROCEDURES for achieving complex PL/SQL logic and called them as STAND ALONE PROCEDUTRES.
• Created oracle tables with the concepts of external table mechanism for accessing data available in flat file.
• During part of ETL implementations Loaded the data into database staging tables using SQL*loader from text files.
• Has good hands-on expertise on ETL tools like KETTLE and ODI for loading data into various business environments and formatting the data as per business rules.
• Worked with java developers to modify and enhance current base of PL/SQL packages for fixing production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed tuning SQL scripts, SQL statements and PL/SQL objects using various tools like TKPROF, AUTOTRACE, EXPLAIN PLAN, DBMS XPLAN and DBMS SQLTUNE.
• Extensively used oracle supplied built in packages like UTL FILE, DBMS LOB, DBMS XMLGEN, DBMS XPLAN etc.
• Extensively used Oracle PL/SQL features like Cursors, exception handling, collections and bulk collections for handling large volume of data sets (some tables contain data more than 10 million of rows).
• Used PL/SQL Anonymous Blocks, User Defined EXCEPTIONS, PL/SQL Loops (While Loop, for loops) to Iterate required set of data and process them accordingly. Created Cursors to incorporate business logic and process them in PL/SQL.
• Created PL/SQL triggers and other data base objects on Spectrum Justice System (SJS) for capturing changed data.
• Debugging complex PL/SQL programs using PL/SQL DEBUGGER, creating BREAKPOINTS and default display statements to track the execution of query and troubleshoot the missing/wrongly defined parameters &variables.
• Worked extensively on different types of transformations like Source qualifier, Joiner, Expression, Filter, lookup (connected & unconnected), Stored procedure, Router transformation, Update Strategy and SQL transformation.
• Designed and developed complex mappings using Mapplets and reusable transformations. Repeated business logic is done using re-usable mapplets.(SVC Area code, Location, Postal Code lookup’s).Calculation of CHECKSUM using MD5 function and converting to upper and lower case, concatenating names is done using re-usable expression transformations.
• Have sound knowledge with version and dependencies, Check in, Check outs and maintaining full version history of the repository.

Environment: ODI 12, Informatica, Oracle 12g, 11g, 10g, SQL Developer, OBIEE BI Publisher TOAD, Windows 7, UNIX, Tortoise SVN, HP Quality Center.

California - Newport Beach.

Sr.ETL PL/SQL Developer.

Responsibilities:

• Working with business users and analyst to gather requirements and framing it into design specification. Assisted in Logical Modeling. Forward engineered the Physical Data Model for development and production databases.
• Assign development tasks to the team and coordinate with them to match the release dates and for support.
• Developed logical data models for the operations business area using Erwin.
• Created Database designs with respect to Application technical architecture point of view considering the aspects like coordination with other business applications and products that run on those platforms and which share common modules in DATABASE point of view.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Managed Oracle Delivers, Scheduler & iBots. Has good Knowledge in PL/SQL advanced objects like Collections using ASSOCIATIVE ARRAYS, NESTED TABLES and VARRAY. Configured user defined exceptions using DBMS STANDARD.RAISE APPLICATION ERROR procedure.
• Developed Complex mappings like Slowly Changing Dimensions Type 1 to maintain current history, Slowly Changing Dimensions Type 2 (Version numbering, Time stamp) in the mapping designer to maintain Full history of transactions.
• Performance tuning of Informatica sessions for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively used stored procedures and also worked with parallel processing.
• Worked on issues with migration from development to testing and testing to production environments.
• Used different Cache properties, such as dynamic cache session property to perform the Update and Insert into the relational table simultaneously using Lookup transformation.
• Creation of Sessions, Workflows and Testing Sales Marketing and distribution Reports.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager and PMCMD.
• Used debugger to troubleshoot logical errors.
• Used ODI Topology manager module to manage the data information systems physical and logical architecture.
• Modified IKM and LKM to populate a FLAG column in the target.
• Used TOAD to develop Oracle PL/SQL, DDL's and Stored Procedures.
• Developed PL/SQL procedures for processing business logic in the database.

Environment:ODI 10.1.3.x, Oracle 10g/9i, PL/SQL. SQL Loader, Toad, Oracle SQL Developer, IMS Data, ETL, Erwin 4.2, Trillium, MS SQL Server 2005, Shell Programming, SQL * Loader, IBM DB2 8.0, Sun Solaris, Windows NT.

 Minnesota-Hopkins.

Sr. ETL ODI Developer

Responsibilities:

• Developed business requirements by programming in Oracle PL/SQL using advanced PL/SQL programming techniques like CURSORS, BULK COLLECT and NESTED TABLES.
• Used Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for maintaining applications.
• Designed efficient Databases by implementing logical and physical database models with an in-depth knowledge of concepts such as indexes, primary keys, foreign keys, and constraints.
• As Database developer played key leadership role in supporting large teams with various backgrounds and has proven experience in solving complex scenarios.
• 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.
• Involved in performing the Impact Analysis of Migration.
• 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.
• Enabled Siebel Delivers using iBots for delivery of reports to business users, by setting up Scheduler and configuring Job Manager.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.
• Profound Experience in implementing & performing Extract, Transform, and Load of Data from Homogeneous sources and Heterogeneous sources using (ETL/ELT) techniques.
• Good implementation knowledge in optimizing, performance tuning, and debugging PL/SQL.
• Estimated Initial Level of Effort (LOE) for various Phases of Development of different Adaptors.
• Scheduled Meetings with Pillar teams to do the gap analysis among Fusion/EBS/PSFT Sources Systems.
• Prepared Data Model Design and Mapping Documents for Fusion/EBS/PSFT Adaptors for OBIA 11gPS1.
• Prepared ETL Design Document for Fusion/EBS/PSFT Adaptors for Purchase Orders/ Agreements Areas.
• Developed SDE/SIL/PLP Interfaces and Temporary Interfaces for Agreement Facts & Dimensions in ODI.
• Implemented ODI Knowledge Modules LKM BIAPPS SQL to Oracle & IKM BIAPPS SQL Control Append.
• Used Transformations like Source Qualifier, Expressions, Lookups, Filter, and Update Strategy in Informatica.
• Provided SDE Schema Delta between Oracle EBS and PSFT Adaptors using DAC for OBIA 11g PS1.
• Fixed unwanted Procurement Objects Metadata w.r.t Informatica in 11g Fusion Adaptor using DAC.
• Imported Fact and Dimension Tables into the Physical Layer and Added Columns to few tables.
• Created Logical Table Sources (LTS), Logical Columns and Performed Calculations in BMM Layer.
• Validated Logical Table Sources, Logical Columns in BMM Layer by performing consistency check in RPD.
• Prepared Unit Test Cases and Performed Unit Testing for Purchase Agreements/Orders Subject Areas.
• Did Peer-to-Peer Technical Design and Code Reviews.

Environment:OBIEE 10.3.4, Informatica 8.X, 10g R2, OBIA, DAC, ODI, BI Publisher, Oracle 10g, Oracle PL/SQL, Oracle OLAP, Oracle Work Flow, SQL Developer, TOAD, Unix Shell scripting

Oregon-Portland.

Team Lead/Sr. ETL ODI Developer

Responsibilities:

• Used to interact with end users to gather business ETL requirements and frame them into ETL speck documents and assign the development tasks to the team.
• Designed efficient Databases by implementing logical and physical database models with an in-depth knowledge of concepts such as indexes, primary keys, foreign keys, and constraints.
• Profound Experience in implementing & performing Extract, Transform, and Load of Data from Homogeneous sources and Heterogeneous sources using (ETL/ELT) techniques. Used Informatica Power Center 9.0.1 & 8.6.1 as ETL tool for developing mappings in Designer and scheduling the workflows in the workflow manager.
• Was responsible to schedule the mappings to run on a daily basis using DAC (Data warehouse administration console).Used to check the logs and fix any failed processes.
• Created connection pools in DAC, registered the required tables, created a subject area for each domain and configured an execution plan to run on daily basis.
• Created a staging area to move the data from Source system (Oracle EBS and Flat files) and put them in associated tables.
• Responsible to create Surrogate keys and Indexes required for performance issues.
• Worked extensively on different types oftransformations like Source qualifier, Filter, Expression, lookup (connected & unconnected), Stored procedure, Joiner, Update Strategy andRouter transformation.
• Designed and developed complex mappings using Mapplets and reusable transformations
• Created reusable sessions using Informatica power center. Worked with parameters and variables in various mappings.
• Hands on experience in customizing reports, filters and charts in Oracle.
• Comprehensive knowledge in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Proficiency in security management of all aspects of OBIEE (Siebel Analytics).
• Knowledge in extracting data from Siebel CRM, Oracle EBS, PeopleSoft, OLTP, flat files and integration and loading data to OLAP systems.
• Good implementation knowledge in optimizing, performance tuning, and debugging PL/SQL.
• Created Cursors to incorporate business logic and process them in PL/SQL also used Loops (While Loop, for loops) to Iterate required set of data.
• Wrote SQL code with DML’s, DDL’s for extracting data from legacy systems and populated the data into TARGET environments via STAGING AREA.
• Enforced Security of Mappings in ADMIN console and all legacy application files on SERVER are secured by giving appropriate privileges to users like READ only mode.
• Database level security for DIMENSION and FACTS tables is maintained by GRANTING and REVOKING user SELECT &UPDATE privileges accordingly.
• Change data capture for dimensions of TYPE-1, TYPE-2, TYPE-3 is implemented based on the business.
• Involved in Informatica architecture, documenting, code reviews and change migration
• Created Informatica Interfaces using transformation logics and migrated data from legacy to oracle data base.
• Created different types of join conditions, filter conditions and SQL quires to transform data to oracle.
• CreatedInformatica interfaces and packages for initial load and incremental load
• Used Informatica operator to debugger after execution of interface.
• Provide Informatica Administration such as: versioning, repository creation and backups, ETL monitoring, troubleshooting failures, and scheduling.
• Prepare Informatica objects Project, Data Models for deployment by using import export method
• Created agents to run the ETL jobs.
• Used Triggers to govern the constraints and data issues by creating Before Insert and After Update triggers.
• Used SQL*LOADER to load data from flat files into Oracle Tables.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups. Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report per the client needs.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects. Applied Cascading Prompts and Multi Level Prompts on Dashboards. Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports. Developed different kinds of reports (pivots, charts, tabular) using global and local Filters. Wrote Custom SQL Codes for the reports. Applied Optimization Techniques for the better performance of the reports.

Environment:Informatica 9.X,Oracle 10g, SQL Developer, Windows7, XP, SQL SERVER 2005, UNIX. Qwest Communications. Virginia - Arlington.

ETL ODI Developer/Informatica Developer.

Responsibilities:

• Involved in design, development and maintenance of various Qwest products and transactions for Data Mart using ODI, Power Center. Estimated Initial Level of Effort (LOE) for various Phases of Development of different Adaptors.
• Created Database designs with respect to Application technical architecture point of view considering the aspects like coordination with other business applications and products that run on those platforms
• and which share common modules in DATABASE point of view.
• Worked in creating Backup and Recovery of DATABASE Schemas. Created object level Security for all users.
• Created database maintenance activates using SQL, PL/SQL. Created FUNCTIONS to REUSE them by passing values and getting the RETURN value.SO that common functionality can be achieved by calling the FUNCTIONS.
• Created PROCEDURES for achieving complex PL/SQL logic and called them as STAND ALONE PROCEDUTRES.
• Used RMAN to create Database Backup sets, Recovery of the backup as per business rules. Configuring to split backup files and do series of backup files.
• As Database developer played key leadership role in supporting large teams with various backgrounds and has proven experience in solving complex scenarios.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented them in the physical layer.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Managed Oracle Delivers, Scheduler & iBots.
• Used PL/SQL Loops (While Loop, For loops) to Iterate required set of data and process them accordingly.
• Scheduled Meetings with Pillar teams to do the gap analysis among Fusion/EBS/PSFT Sources Systems.
• Prepared Data Model Design and Mapping Documents for Fusion/EBS/PSFT Adaptors for OBIA 11gPS1.
• Prepared ETL Design Document for Fusion/EBS/PSFT Adaptors for Purchase Orders/ Agreements Areas.
• Developed SDE/SIL/PLP Interfaces and Temporary Interfaces for Agreement Facts & Dimensions in ODI.
• Implemented ODI Knowledge Modules LKM BIAPPS SQL to Oracle & IKM BIAPPS SQL Control Append.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Procurement Subject Area using ODI.
• Created Source to Target Domain Members & Maps in Seed Data Manager for Domain General Mappings.
• Developed SDE/SIL Mappings, Mapplets, Sessions, and Workflows for EBS Adaptor using Informatica.
• Developed SDE Mappings with Fusion View Objects (VO) as Source using Informatica and ODI.
• Used Transformations like Source Qualifier, Expressions, Lookups, Filter, Update Strategy in Informatica.
• Performed Administration Activities like Installation and Configuration of Informatica, ODI, and OBIEE.
• Took the advantage of enhanced functionality for SQL*LOADER using External tables to access the data in external sources.
• Used SQL*LOADER to load data into External Tables and Used Oracle Data pump to unload required data from External tables.
• Exposed Dimensions and Various Metrics in Presentation Layer for Purchase Agreements/Orders Areas.
• Executed Engineering Acceptance Tests (EAT) on Supply Chain/ Procurement Subject Areas using DAC.
• Prepared Unit Test Cases and Performed Unit Testing for Purchase Agreements/Orders Subject Areas.
• Did Peer-to-Peer Technical Design and Code Reviews.

Environment: Informatica Power center 8.6, 8.1.1, Oracle 11g, 10g, 9i, Cobol Sources, SQL Server 2000, 2005, Erwin 7.3, Cognos 7.3, PL/SQL, SQL, Java, Toad 9.0, SQL Loader, Sybase power designer 12.5, 4.1.

Chicago - Schaumburg.

ETL ODI Developer

Responsibilities;

• Developed business requirements by programming in Oracle PL/SQL using advanced PL/SQL programming techniques like CURSORS, BULK COLLECT, NESTED TABLES.
• Used Oracle development tools such as SQL Plus, SQL Developer, and SQL Loader for programming and maintaining applications.
• 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.
• Involved in performing the Impact Analysis of Migration.
• 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.
• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting up External Table Authentication.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance Data Model.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Created new requests and opened Answers for adhoc reporting to the End users
• Trained End Users and Pilot Users about OBIEE Tools.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Designed schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Designed efficient Databases by implementing logical and physical database models with an in-depth knowledge of concepts such as indexes, primary keys, foreign keys, and constraints.
• Profound Experience in implementing & performing Extract, Transform, and Load of Data from Homogeneous sources and Heterogeneous sources using (ETL/ELT) techniques.
• Designed the ETL processes using Informatica to load data from DB2, Oracle, SQL Server, Flat Files, (Fixed Width) and Excel files to staging database and from staging to the target Oracle Data Warehouse database.
• Loaded data in bulk into multiple target systems, performed complex transformations and scheduled using PMCMD.
• Performed data cleansing, data manipulations using various Informatica Transformations.
• Setting up batches/sessions to schedule the loads at required frequency using Informatica Server manager (Workflow manager/ Workflow monitor)
• Created various transformations like Source Qualifier, Joiner, Expression, Lookup, Aggregate, Filter, Router, Update Strategy, Sequence Generator etc.
• Generated Reports using Cognos Impromptu and oracle reports builder.
• Involved in designing Facts, Dimensions and Slowly Changing Dimensions.
• Designed Reports with Slice and Dice & Drilldown operations.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time to load the data into the Target Database.
• Designed and developed Oracle ETL staging tables.
• Configured ODI Master, Development and Execution Repositories.
• Developed ODI Physical and Logical Topology.
• Developed ODI interfaces, procedures and packages. Generated scenarios and created load plans.
• Performed ODI DBA tasks. Managed ODI users. Maintained load plan schedules. Monitored ODI production processes. Migrated ODI ETL structures from development to test to production environments.
• Developed GROOVY programs to generate ODI structures using the ODI Java SDK.
• Loaded XML data using ODI procedures that reference GROOVY technology.

Environment: OBIEE 10g and 10.1.3,Oracle 11g, Oracle PL/SQL, TOAD, SQL Developer, Unix Shell Scripting, Oracle Work Flow, BI Publisher, ERWIN