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 developingData modelbased onSTARschema concept usingOBIEE 11g Administration Toolfor 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 configuringUsage 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 400O

PERATING SYSTEMS: MS Windows 10, 8.x, 7,xp, Vista, UNIX, Mac OS X, Linux, Solaris

LANGUAGES & 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

PROFESSIONAL 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, ADA, MI

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 experiencein 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 UDBWells Fargo Bank, San Francisco, CA Aug, 15 - FEB, 17

Sr. OBIEE/ODI Developer & Administrator

Confidential

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 usingOracle BI Appspre-build rpd’s (Financial,Supply ChainandOrder 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 Confidential 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 experiencein 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 usingODIand monitored the workflow run and statistic properties onODI 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 Publisherto 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 usingODIand monitored the workflow run and statistic properties onODI Operator.
• A key contributor in creating and supporting standard and ad hoc reports to IT and Business Units & Senior Management.
• Involved inPerformance tuningfor 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 ComplexInformaticainterfaces using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations forLarge volumes of Data.
• Responsible for creating Workflows and sessions usingInformatica, workflow manager and monitoring the workflow run and statistic properties onworkflow monitor.
• Responsible forUnitandRegressiontesting of theInformatica mappings created according to the business requirements.
• UsedVersion controlprovided byInformaticaon 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.
• DevelopedUnix Scriptsfor 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.
• 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.