SUMMARY

• Over 8 years of extensive experience in complete Software Development Life Cycle (SDLC) including System Requirements Collection, Architecture, Design, Coding, Development, Testing, Production Support, Maintenance and Enhancement in variety of technological platforms with special emphasis Client/Server, Data Warehouse and Business Intelligence applications in Windows and Unix environment
• 8 years of experience in Analysis, Design, Development, Administration, Testing, Support and user training of Data Warehousing using ODI,OBIEE and Oracle Applications.
• Experience in end to end Implementation of BI Applications ( Financial Analytics, and HR Analytics )
• Expertise in Dimensional Data modeling using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
• Well - versed in Data Transformations and Data Migrations using Oracle Data Integrator 11g/12c from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Comprehensive noledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Involved in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Skilled in using ODI graphical interface modules - Security Manger, Topology Manager, Designer and Operator with versions ODI 10g/11g/12c.
• Expertise in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI noledge modules (LKM, IKM, CKM, RKM and JKM).
• Excellent experience in designing and implementing complex ETL/ELT jobs.
• Experience in developing Slowly Changing Dimensions (SCD) mappings using Change Data capture (CDC) Type1 and Type2 along with Performance Tuning.
• Expertise in handling errors, troubleshoot and debugged defects and production issues in the areas of SQL and ODI.
• Experience in Scheduling the Packages / Interfaces / Scenarios / Load plans by using agents for nightly and weekly load runs.
• Expertise in performance tuning of ODI ETL Tasks / Sessions by adding necessary hints and profiles etc and also Running SQL Tuning analyzer (STA) to get suggestion like gather stats on table, creating new Indexes, Profiling etc
• Expertise in providing end-to-end business Intelligence solutions using (OBIEE 10g/11g) with greater emphasis on BI Administration Tool and BI Analytics web, Dashboard Creation, Answers, BI Publisher.
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Objects.
• Analyze, design, develop, modify and test OBIEE Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Experienced in working with Multi User Development environment (MUD) and configuring the security settings in OBIEE administration tool to setup groups, access privileges using LDAP and external database autantication.
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas of ODI jobs and OBIEE reports.
• Extensively utilized OBIEE delivers for sending alerts via intelligence agents to interactive dashboards for subscribed users.
• Expertise in documentation of TDD (Technical Design Document) and User Training Documents.

TECHNICAL SKILLS

BI Tools: OBIEE 10.1.3.x, Oracle BI Apps 11.1.1.7.1 /11.1.1.81

ETL: Oracle Data Integrator 10g/11g/12c

Operating Skills: IBM, Sun, Linux, HP Unix, Windows 9x/2000/NT/XP, Windows Server 2005, 2008 R2

Development Tools: Toad 9.0, SQL Developer. Erwin r7.1/7.2, ER Studio V8.0.1 and Oracle SQL Data Modller

Web Tools: HTML, DHTML, ASP, Java Script, JSP, XML, Web Portals.

Database: Oracle 11g/10g/9i, DB2, MS SQL Server 2012/2008

Dimensional Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, MS Visio Diagrams / Erwin, Designer 2000

PROFESSIONAL EXPERIENCE

Confidential, DC

Sr. Oracle Data Integrator / OBIEE Consultant

Responsibilities:

• Involved in analyzing the business requirements and functional specifications.
• Involved in setting up the ODI connection with Oracle, MS SQL Server Technologies
• Experienced in Topology set up including physical architecture, logical architecture and context for different environments like DEV, TEST and PROD.
• Created and imported new models for the data sources - MS SQL server, Oracle and did reverse engineering for the data sources and targets.
• Developed aConceptual modelusing Erwin based on requirements analysis
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r7.1
• UsedErwinfor reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed new interfaces for loading the data and created new ODI packages, scenarios using interfaces, variables.
• Developed Interfaces using different noledge modules (LKM, IKM, CKM, RKM and JKM ) like Oracle SQL Control Append, Oracle Incremental Load, Oracle SCD etc
• Experienced in migration of ODI packages, scenarios from Development environment to test as well as production environment.
• Used ODI in-built scheduler to schedule the scenarios and load plan’s in new DEV server.
• Involved in Operations and Maintenance activities, troubleshooting the issues and resolving the tickets based on the severity of the issue.
• Modified the existing database objects like tables, views, PL/SQL procedures to adhere to the business requirements.
• Thoroughly analyzed the impact of source and target tables and its related components on other applications before decommissioning the existing ETLs.
• Modified metadata repository - Physical and BMM layer as per reporting requirements using OBIEE Admin Tool.
• Analyzed the data and enhanced Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Modified the existing reports by adding the new changes into OBIEE reports and developed new reports/dashboards which included guided navigations, drill downs, conditional formatting, graphs, complex compound layouts including multiple view and column selectors, dashboard prompts, etc.
• Involved in setting up agents to run reports at scheduled time for cache seeding in order to improve query performance.
• Involved in implementing LDAP Security with External Table Authorization.
• Worked on tuning SQL queries and functions to enhance performance and ran STA for tuning suggestions.
• Involved in the migration of OBIEE repository and catalogs from DEV to UAT, PROD.
• Extensively interacted with business users during UAT.
• Co-ordinate with the business analyst in preparing the test case scenarios for business users.
• Prepared the project documentation for noledge repository.

Environment: Oracle Data Integrator 11g/12c, OBIEE 11.1.1.7.1 , Erwin r7.1 Oracle 10g, DB2, Oracle EBS, Oracle BI Apps 11g (GL, AP,AR), UNIX, Win-XP.

Confidential, Jersey city, NJ

ODI / OBIEE consultant

Responsibilities:

• Involved in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Participated in the installation and configuration of Oracle BI EE 11.1.1.7 and Oracle Data Integrator 11g
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions using Erwin.
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Developed and designed ETL strategy to load the data from various source systems (Flat files, Oracle DB, XML) by creating interfaces, procedures, packages, scenarios, agents, load plans and also customized Knowledge Modules in ODI.
• Implemented SCD Type 1 and Type 2 using ODI.
• Implemented Change data capture tool (CDC) to track the changes in the source data.
• Analyzed Session log files in operator navigator to troubleshoot errors in mapping and worked on session configuration.
• Responsible for creating complex mappings according to business requirements, which are scheduled through ODI Scheduler.
• Customized noledge modules according to the requirements to add Hints for performance tuning proposes
• Deployed, Configured, Tested ODI Agents and scheduled ODI Scenarios.
• Developed the repository model for the different work streams with the necessary logic dat involved creating the Physical, BMM and the Presentation layer. Also created hierarchies and variables in the repository.
• Developed Dashboards/Reports using the Oracle Business Intelligence Analysis platform as per requirement.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Implemented Security by creating roles & web groups, External tables and LDAP.
• Controlled Analytics Cache Management & Used Event Polling Table to automate cache purging.
• Played an important role in the team and worked as a good team member.

Environment: OBIEE 11.1.1.7/11.1.1.4 , Oracle Data Integrator 11g, Oracle 11g, Pl/SQL, SQL*Plus, SQL*Loader, TOAD, Windows XP, UNIX.

Confidential, Philadelphia, PA

Oracle Data Integrator Consultant

Responsibilities:

• Designed DW tables, scripts, ETL maps and ODI Extracts.
• Configured ODI modules and ELT tools and supported accessible applications.
• Documented and maintained ELT specifications and processes
• Participated in all the phases of project - development, testing, deployment and support.
• Used Oracle Data Integrator (ODI) to develop custom interfaces, packages and procedures to move data from EBS to data warehouse for reporting purposes.
• Developed custom load plans with segregation for Dimensions, Source Dependent Extract (SDE), Source Independent Load (SIL) and Post load process (PLP).
• Migration of ODI objects such as Projects, Packages, Interfaces etc., across environments.
• Implemented the SNAPSHOT logic to store the history data based the parameters using IKM ( Oracle Incremental Load and Oracle SCD)
• Created load plans to accommodate all the custom scenarios (SDE,SIL & PLP) and schedule them periodically using ODI Agents
• Implemented new solution for making Data Source ID and Tennant ID dynamic in all the custom and pre built mappings by using the variables in ODI
• Performed performance tuning by implementing the parallelism features and by following the good design standards.
• Migrated the ODI code by using Smart View exports and Folder exports, imported the code into other environment by using Inset Update mode.
• Configured the Email in the package for load success and Load failures.

Environment: ODI 11g, Oracle 10g/11g, PL/SQL, UNIX, TOAD Windows XP, Clear Case, Clear Quest, Remedy, Oracle Linux 5.

Confidential

Siebel/Informatica Developer

Responsibilities:

• Worked with the Business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
• Prepared the Technical Assessments, Technical Specification, Technical Design Documents based on the functional, publishing requirements.
• Designed Mapping documents between source and target databases by analysing the requirements documents.
• Developed and worked with Master and work repositories using the Repository management tools.
• Used Topology Manager for creating Physical and Logical schemas for every source and target of warehouse.
• Developed Interfaces, Packages and Procedures using Oracle Data Integrator (ODI) for loading into warehouse from various sources like databases, flat files.
• Reverse engineered source and target system schemas using ODI before starting development.
• Designed and developed ODI interfaces using Designer and imported noledge modules (LKM, IKM, CKM, etc) to load and transform the data from various data sources.
• Generated scenarios and deployed them using ODI Operator for code migration from one environment to another environment.
• Involved in database development by creating SQL, Oracle PL/SQL Functions, Procedures, Triggers and Packages.
• Created Database objects like tables, views, PL/SQL Procedures and PL/SQL Packages..
• Worked on scheduling the jobs using AGENTS and documenting the processes.
• Analyzed business and system requirements, managed development of specifications to create and execute detailed test cases, and executed the test cases.
• Provided support for proper functioning of the application.

Environment: Oracle Data Integrator (ODI 10g/11g), Oracle 10g/11g, SQL*Plus