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 knowledge 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 knowledge 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 teh areas of SQL and ODI.
• Experience in Scheduling teh 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 teh security settings in OBIEE administration tool to setup groups, access privileges using LDAP and external database authentication.
• Worked extensively on debugging, troubleshooting teh defects and production issues in teh 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 teh business requirements and functional specifications.
• Involved in setting up teh 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 teh data sources - MS SQL server, Oracle and did reverse engineering for teh data sources and targets.
• Developed aConceptual modelusing Erwin based on requirements analysis
• Created dimensional model for teh 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 teh form of Entity Relationships and elicit more information
• Developed new interfaces for loading teh data and created new ODI packages, scenarios using interfaces, variables.
• Developed Interfaces using different knowledge 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 teh scenarios and load plan’s in new DEV server.
• Involved in Operations and Maintenance activities, troubleshooting teh issues and resolving teh tickets based on teh severity of teh issue.
• Modified teh existing database objects like tables, views, PL/SQL procedures to adhere to teh business requirements.
• Thoroughly analyzed teh impact of source and target tables and its related components on other applications before decommissioning teh existing ETLs.
• Modified metadata repository - Physical and BMM layer as per reporting requirements using OBIEE Admin Tool.
• Analyzed teh data and enhanced Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Modified teh existing reports by adding teh 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 teh migration of OBIEE repository and catalogs from DEV to UAT, PROD.
• Extensively interacted with business users during UAT.
• Co-ordinate with teh business analyst in preparing teh test case scenarios for business users.
• Prepared teh project documentation for knowledge 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 teh various work streams by meeting with teh business user and base lining teh details.
• Participated in teh installation and configuration of Oracle BI EE 11.1.1.7 and Oracle Data Integrator 11g
• Reverse engineered teh reports and identified teh Data Elements (in teh source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Designed a STAR schema for teh 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 teh 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 teh changes in teh 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 knowledge modules according to teh requirements to add Hints for performance tuning proposes
• Deployed, Configured, Tested ODI Agents and scheduled ODI Scenarios.
• Developed teh repository model for teh different work streams with teh necessary logic that involved creating teh Physical, BMM and teh Presentation layer. Also created hierarchies and variables in teh repository.
• Developed Dashboards/Reports using teh 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 teh 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 teh 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 teh SNAPSHOT logic to store teh history data based teh parameters using IKM ( Oracle Incremental Load and Oracle SCD)
• Created load plans to accommodate all teh 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 teh custom and pre built mappings by using teh variables in ODI
• Performed performance tuning by implementing teh parallelism features and by following teh good design standards.
• Migrated teh ODI code by using Smart View exports and Folder exports, imported teh code into other environment by using Inset Update mode.
• Configured teh Email in teh 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 teh Business analysts and analyzed various sources for requirements gathering, business analysis, testing, metrics and project coordination.
• Prepared teh Technical Assessments, Technical Specification, Technical Design Documents based on teh functional, publishing requirements.
• Designed Mapping documents between source and target databases by analysing teh requirements documents.
• Developed and worked with Master and work repositories using teh 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 knowledge modules (LKM, IKM, CKM, etc) to load and transform teh 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 teh jobs using AGENTS and documenting teh processes.
• Analyzed business and system requirements, managed development of specifications to create and execute detailed test cases, and executed teh test cases.
• Provided support for proper functioning of teh application.

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