PROFESSIONAL SUMMARY:

• 8+ years of IT experience in Requirements gathering, Analysis, Design, Development, Implementation, Modelling, Testing and support for Data warehousing applications.
• Experienced in ODI & OBIEE solution architecting (12C, 11g & 10g) and have a strong understanding on 12C & 11g capabilities with Web logic as an Application server.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes and providing data mining features for data warehouses, and Scheduling - DAC .
• Extensive experience on creating BI reports in different subject areas, critical analysis and upgrade of the existing reports.
• Extensive DW experience using Oracle Data Integrator, Configured and setup ODI, Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Interfaces, Scenarios, Filters, Condition, Metadata.
• Very good in Debugging, Optimizing the Analytics Dashboards/ Reports and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
• Expert in Oracle EBS R12 configuring, designing, development, implementation and using Oracle BI Apps pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements.
• Configured Oracle Business Intelligence Application (OBIA) 11.1.1.8.1 HR Analytics, Financial Analytics, Sales & Marketing Analytics, and Supply chain, Retail and Procurement & Spend Analytics, Pharma Analytics.
• Involved in the OBIA 11.1.1.8.1 to OBIA 11.1.1.10.1 upgrade and tested ODI ETL objects and OBIA reports
• Created Proof of Concept on OBIEE 12.2.1.0 and provided demo on the advanced features including Geospatial Reports in OBIEE.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
• Worked on Slowly Changing Dimensions and its implementation to keep track of Historical data.
• Actively involved in Performance Tuning, Error handling and production support for various projects.
• Implemented different Caching techniques to improve the performance of BI server.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, and Oracle Fusion.
• Experienced in troubleshooting installation issues, production issues and production support for projects.
• Experienced in analyzing the needs of the user and creating new BI reports according to the user requirement in OBIEE.
• Experience in creating executive reports with BI Publisher integrated with OBIEE.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Extensive experience in building Interactive Dashboards with drill-down, drill-across capabilities using global,local Filters, Guided Navigation, Business rules, selection steps, prompts, etc.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.
• Experienced in Oracle EPM - Enterprise Performance Management.
• Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Expertise in working with Oracle HCM and Payroll for integration with Oracle BI platforms.

TECHNICAL EXPERTISE:

BI TOOLS (Infrastructure & Applications): OBIEE 10g/11g/12C, BI publisher 10g/11g, EBS Financial, OBIA R12, 7.9.6.3, 7.9.6.1(Financial Analytics, HR Analytics, Sales, Service, Marketing, Supply Chain, Manufacturing, Procurement.)

ETL TOOLS: ODI 12C/11g/10g, DAC 10.1.3.4.1 , Informatica Power Center 9x

DATA BASES/ RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server, DB2 UDB, TOAD, Hyperion System 9 Essbase, MS-Access, AS 400OPERATING SYSTEMS

MS Windows 10, 8.x, 7,xp, Vista, UNIX, Mac OS X, Linux, SolarisLANGUAGES & Web Technologies: SQL, PL/SQL, XML, UNIX Shell Scripting, Java,JVS, C++,C, HTML/XHTML.

ERP / Applications Servers: Oracle Applications 11i & R12, Oracle Web Logic Server 10.3.5, 11g, 12C

METHODOLOGIES: Software Development Life Cycle (SDLC) - Waterfall Model, Agile, Rational Unified Process (RUP), JIRA, Service Now, DevSuit, Sharepoint

WORK EXPERIENCE

Confidential, Franklin, TN

Sr. ODI Developer & Administrator

Responsibilities:

• Involved in Analysis of the Project requirements.
• Extracting the data from various source systems.
• Involved in the Installation and Migrating of ODI 11g & 12C.
• Performed loading from flat files to Oracle in Dev. UAT and Prod Environment.
• Worked on SQL loader utilities.
• Used Shell Scripting to figure out the Files, records, directories, and troubleshoot the .bad files/records.
• Created and Designed (ODI/ETL) Data Load process across the clients.
• Created ODI Package of various complexity and automated process data flow
• Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment
• Performed source to Staging and staging to target mapping specifications and developed ETL / ODI code for the same.
• Created Topology connection for reading xml logs and writing into oracle db.
• Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
• Created ODI Interfaces to load data into ODS for downstream systems.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Used Refresh, Set and Evaluate ODI variables types into ODI Packages
• Created Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrated Code from Development to Testing to production.
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Identified and fixed bottlenecks and tuned the complex ODI Interfaces for optimized performance.
• Troubleshoot the break & fix production issues, and created Service now ticket as well.
• Supported clients for any kinds of production & data Load issues.
• Created Unix Shell Scripts and SQL procedures.
• Maintained Agile to keep work flow updated.

Environment: ODI 12C, 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12, UNIX, Agile, MS windows.

Confidential

Sr. OBIEE/ODI Developer & Administrator

Responsibilities:

• Responsible for developing & administrating the ELT (Extract, Load and Transform) processes using Oracle Data Integrator (ODI) and OBIEE.
• Involved in the Installation of ODI & OBIEE 11g & 12C (BI Administration Tool, Oracle BI Enterprise Manager, Web logic server and BI Publisher) in Windows environments.
• Develop complex interfaces to load the data from the various sources into dimensions and facts.
• Testing and fixing the bugs in the interfaces and migrating them to stage and production environments.
• Participating in team planning sessions.
• Created ODI Package of various complexity and automated process data flow
• Created ODI Interfaces to load data into ODS for downstream systems
• Gathered ELT requirements from Business team and designed its high level documents.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
• Debug the mappings using debugger to resolve code issue.
• Worked in importing data from heterogeneous data sources like AS 400, database, flat file, XML files, excel.
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Migrated Code from Development to Testing to production.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
• Used PLSQL Developer for running SQL queries.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Extensive experience in working with OBIEE and OBIA Answers, Delivers, iBots, and Intelligent Dashboards
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.

Environment: ODI 12C, 11.1.1.7, 11.1.1.9, OBIA 11g, OBIEE 12c, RDBMS Oracle 12C, 11g,Toad (12.5, 11.x), PL SQL. EBS R12. DB2 UDB

Confidential, San Francisco, CA

Sr. OBIEE/ODI Developer & Administrator

Responsibilities:

• Analyzed business requirements of the project and wrote technical specs for the implementation.
• Analyzed the user requirements and created BI reports in different subject areas.
• Expertise in converting and using Oracle BI Apps pre-build rpd’s (Financial, Supply Chain and Order Management) according to business requirements.
• Execution environment Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same
• Used OOTB RPD and created new measures, calculated items and calculated groups.
• Worked on RPD Development, Oracle BI Administration, Oracle BI Answers and Agents.
• Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
• Created complex requirements like Dimension hierarchies, time comparisons and share measures along with ranks.
• Developed Month Ago, Year Ago Measures for Comparison of Facts and Used Time Series Functions and To Date Functions Extensively.
• Developed new Balance sheet, income statements, AP aging and AR aging reports and dashboards, etc as per business requirements.
• Implemented Oracle BI security at the data and object levels and utilized variables and initialization blocks in the repository.
• Utilized BI Delivers for sending real-time, personalized alerts via intelligence agents (IBots) to intelligence dashboards for subscribed users.
• Created operational reports with BI Publisher integrated with OBIEE.
• Created variables in OBIEE for use with reporting - Repository Variables, Session Variables, Presentation Variables and Initialization blocks.
• Discover and model dependencies between Oracle Data Integrator (ODI) and various components such as databases or other
• Oracle Fusion Middleware products automatically using the Oracle Enterprise Manager Cloud Control framework
• Managed and provided permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Used group functions like aggregate, count, sum, etc and created separate measures within the data model and used the group variables in the reports
• Developed report templates in RTF and Excel and coded different groups of the same data in an organized fashion to enable the exact rendering of report requirements.
• Used bursting feature to burst the report output to different roles/users within the organization.
• Used ODI 11.1.1.7.x designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
• Created complex Interfaces and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created Interfaces to implement one time as well as Incremental loads.
• Used Interface Variables, Interface Parameters and Session Parameters to increase the re-usability of the Interfaces.
• Implemented performance tuning logic on targets, sources, interfaces, sessions to provide maximum efficiency and performance.
• Modified the Source system parameters in the DAC according to the Business requirements with their respective currencies and exchange rates.
• Configured repository (RPD) to use the LDAP authentication.
• Included the custom mappings in DAC Execution plan.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Used ODI knowledge modules to implement SCD logic and Update logic.
• Developed load plans using Load Plan Generator and monitored the results using ODI Operator.

Environment: OBIA (11g,12.0.0), ODI 12c, 11g, OBIEE 12c, 12C/11g, Oracle 12c/11g, SQL Developer, Toad 10.x, PLSQL, EBS R12.

Confidential, Norfolk, VA

ODI/OBIEE Developer and Administrator

Responsibilities:

• Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
• Extensive experience in working with OBIEE and OBIA Answers, Delivers, iBots, and Intelligent Dashboards
• Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter,
• Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
• Worked with the OBIA Financial Analytics Suite using OBIEE 11.1.1.7.x and customized the dashboards and metrics for reporting.
• Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
• Designed, documented and tested logical and physical data models optimized for operational and analytical reporting
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator
• Used BI Publisher and created complex pivot table reports and cross-tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• Performed the changes to the physical layer, Business Model and Mapping Layer and Presentation Layer in an OBIEE Repository for all new objects that needed to be added.
• Started/Stopped BI and Weblogic Servers using OPMNCTL commands and also start/stop shell script.
• Performed security administration for the entire organization, mapping PeopleSoft roles and LDAP configuration and Weblogic roles.
• Monitor Oracle Data Integrator (ODI) components availability and performance out-of-thebox; access historical data, track logs, and receive notifications of potential problems.
• Configured the Data warehouse Administration Console (DAC) according to the OBIA 7.9.6.3financial analytics.
• Used various templates in BI Publisher to publish the reports as per user requirements.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.
• Presented demo sessions of the BI tool in many offsite locations of the client and won appreciation from the executive teams.
• Reconciled the data in the reports to tie numbers back to PeopleSoft, which was the system of record.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co-ordination effectively.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
• Used PLSQL Developer for running SQL queries.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
• A key contributor in creating and supporting standard and ad hoc reports to IT and Business Units & Senior Management.
• Involved in Performance tuning for sources, targets, interfaces and sessions.

Environment: OBIA, ODI 11.1.1.7, Oracle 11g, ODI 11g, OBIEE 11.1.1.7, PLSQL Developer, SQL.

Confidential, Billerica, MA

OBIEE & Reports Developer

Responsibilities:

• Installed OBIEE 11.1.1.5 on Solaris and configured horizontal scaling for high availability. Upgraded OBIEE reports and BI Publisher reports from 10.1.3.4 to 11.1.1.5.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Participated in the weekly meeting to structure the timelines for the project.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Created dimension hierarchies, logical levels, level keys, and level based measures,.
• Used the expression builder utility for the new logical columns in the BMM layer and created various calculation measures and Time series measures.
• Defined session variables, static and dynamic repository variables, and presentation variables.
• Worked on both data level security and object level security.
• Set up the Usage Tracking subject area in the repository to track the statistics of reports.
• Created the reports by interacting with the users and analyzing the legacy systems.
• Created RTF templates and Data templates for creating Master-Detail reports in BI publisher.
• Obtain real-time and historical in-depth performance statistics for the Oracle Data Integrator (ODI) Standalone and JEE Agents.
• Developed BIP reports with different analytical charts and conditional formatting.
• Created and Scheduled BI publisher Bursting reports to deliver reports based on the content via ftp and file transfer delivery channels.
• Involved in the configuration of Single Sign On authentication to integrate with Oracle portal.
• Created Materialized views, Functions in the Database to map them in the repository.
• Documented the data loading scenarios in Oracle Data Integrator (ODI).
• Responsible for deployment of rpd, catalog, and BI Publisher reports across all environments.
• Performed Unit, Integration and Regression testing to validate reports and data.
• Worked with ODI and Database developers to resolve the data issues.
• Created connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Technical understanding of the Specifications and Documenting the Gap analysis.
• Creation of LLD and HLD, Designing the logic, Estimation of efforts.
• Implementation of the logic and developing the Reports, and Gap Analysis and Data Sanity Check.
• Testing the accuracy of the data, and Gathering the defects, enhancements and the change requests raised by the user.
• Preparing the test cases document and the result of the test cases.
• Taking up the calls with the user for gathering the change requests and feedback on the resolved defects
• Implemented the security in OBIEE Admin tool to set up users, groups and access privileges.
• Used the expression builder utility for the

Environment: OBIEE 11.1.1.7, OBIEE 11.1.1.5/10.1.3.4 , SQL, Oracle 11g, Toad, MS VISIO,. ODI11g, EBS 11.

Confidential, Minneapolis, MN

OBIEE Consultant

Responsibilities:

• Responsible for developing Complex Informatica interfaces using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Data.
• Responsible for creating Workflows and sessions using Informatica, workflow manager and monitoring the workflow run and statistic properties on workflow monitor.
• Responsible for Unit and Regression testing of the Informatica mappings created according to the business requirements.
• Used Version control provided by Informatica on each and every object used. In this way, each and every version of the process will be available for recovery or research purposes.
• As an ODI consultant streamlined and tuned accounting related ETL to be more efficient using Teradata.
• Assisted in designing database solutions to meet both business and technical requirements.
• Developed Unix Scripts for updating the control table.
• Responsible for providing first level operational support for development and production database systems
• Participated in complete life cycle of the project from project initiation to development and maintenance.
• Customized the Siebel Analytics/OBIEE repository (Physical Layer, BMM and Presentation Layer).
• Modified Presentation layer to add presentation tables and defined joins in the physical layer of the repository.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Created materialized views and aggregates to improve performance.
• Manage multiple Oracle Data Integrator (ODI) domains from a single location.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.

Environment: OBIEE 11g, Oracle 9i, Flat files, TOAD, PL/SQL, UNIX, Shell Scripting, ODI 11g

Confidential

ETL Informatica Developer

Responsibilities:

• Experience with ETL/ETI(Informatica) (Extraction Transform and Loading, Extraction Transform and Import) data from production database to data warehouse database.
• Worked on transformations such as source qualifier, joiner, lookup, rank, expression, aggregator and sequence generator etc.
• Reused mapping, mapplets and transformations.
• Scheduled sessions and batches on the Informatica Server using Informatica Server.
• Tuned transformations and mappings in Informatica.
• Implemented slowly changing dimensions.
• Created Unix Shell Scripts and PL/SQL procedures.

Environment: Informatica PowerCenter 7.1, Database Systems, SQL and PL/SQL, Windows NT, Oracle8i and UNIX.