PROFESSIONAL SUMMARY:

• 8 years of IT experience in Requirements gathering, Analysis, Design, Development, Implementation, Modelling, Testing and support for Data warehousing applications.
• Expertise in the Installation, Migration & converting of ODI versions (10g,11g & 12C) in different working environments.
• Experienced in OBIEE solution architecting (OBIEE 12C, 11g & OBIEE10g) and have a strong understanding on OBIEE 12C & 11g capabilities with Web logic Version: 10.3.5 & 12.2.1.0.0 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.
• Hands-on experience in using BI reporting tools like Oracle Business Intelligence Enterprise Edition (OBIEE) 12C/ 12.2.1.0/11.1.1.9. 0/10.1.3.4 , Siebel Analytics 7.7/8, Oracle BI Publisher.
• 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.
• Experienced and Good knowledge on Oracle GoldenGate Studio,Big Data, Management Pack, Veridata.
• 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, Informatica power center, 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.
• Experience in UNIX working environment, writing UNIX shell scripts for ODI pre & post session operations.
• Experienced in IBM Cognos Configuring, analytics, Troubleshoots, Planning, Documenting, & Admin.
• 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 SKILLS:

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

ETL TOOLS: ODI 12C, 12.2.1.0/11.1.1.9/11.1.1.3/10.1.3.5 , DAC 10.1.3.4.1 , Informatica Power Center,     Informatica - 11.0.1 & +, PeopleSoft 9.x

DATA BASES: Oracle 12c/11g/10g/9i/8i, RAC, SQL Server, DB2 UDB(8.x & 7.x), Oracle GoldenGate, MS-Access, Hyperion System9, Essbase.

OPERATING SYSTEMS: Microsoft Windows 7/Vista/XP/2000/NT, UNIX, Mac OS X, Linux, Solaris. LANGUAGES SQL, PL/SQL, XML, UNIX Shell Scripting, Java, C++,C,TOAD,HTML/XHTML. Python

REPORTING TOOLS: Crystal reports, Tableau

BUSINESS INTELLIGENCE: OBIEE, EPM 11.1.1.3, IBM Cognos SCHEDULER Control-M, AutoSys, Active Batch 7, ESP Scheduler

Methodologies: Software Development Life Cycle(SDLC)- Waterfall Model, Agile, Rational Unified Process(RUP)

WORK EXPERIENCE:

Confidential, San Francisco, CA

Sr. ODI/OBIEE 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.
• Involved in the Installation & Migration of ODI & OBIEE 11g & 12C in Linux environments.
• Discovered and modeled 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.
• Expertise in converting and using Oracle BI Apps pre-build rpd’s (Financial, Supply Chain and Order Management) according to business requirements.
• 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.
• 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 release1 (11.1.1.10, 11.1.1.9, 11.1.1.8,12), ODI 12.2.1.0/11.1.1.9. x (Repository Manager, Designer, Load Plan Generator, and Operator), OBIEE 12c, 12.2.1.0/11.1.1.9. 0, OBIA 11.1.1.10.1/ 11.1.1.8.1 , Oracle 12c/11g, SQL Developer 4.x, Toad 10.x, PLSQL, SQL. Hyperion System9. EBS R12.

Confidential, Norfolk, VA

Sr. 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.
• Monitor Oracle Data Integrator(ODI) components availability and performance out-of-thebox; access historical data, track logs, and receive notifications of potential problems
• Obtain real-time and historical in-depth performance statistics for the Oracle Data by ODI.
• 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.
• 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.
• 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 (Inventory, Sales, Bill of Material, Order fulfilment, Shipping), ODI 11.1.1.7.x(Topology manager, Repository Manager, Designer, Load Plan Generator, and Operator), Oracle 11g,ODI 11g, Oracle GolenGate 11, OBIEE 11.1.1.7.x, PLSQL Developer, SQL, PLSQL. Essbase. IBM Cognos.

Confidential, Billerica, MA

ODI/OBIEE Developer

Responsibilities:

• Installed & managed ODI & OBIEE 11g 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.
• Trace end-to-end Oracle Data Integrator (ODI) Sessions activity, review execution statistics and drill- down from a particular Step or Task into a detailed report of Oracle databasesactivity
• Control Service Level Agreements (SLA) with robust and scalable alerting capabilities by ODI.
• 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.
• 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.
• Performed on Support for heterogeneous databases and operating systems by GoldenGate.
• 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, Solaris, SAML, OID, Toad, MS VISIO, CVS.Essbase, Hyperion. ODI. Oracle GoldenGate 11, 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.
• 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, Informatica 8.1.1, Informatica Power Exchange, Business Process Modelling (BPM), SAP R/3 7.1, Oracle 9i, DB2, Flat files, TOAD, Visio, PL/SQL, SQL, UNIX (AIX), Unix Shell Scripting, Windows XP, Tableau, ODI 11g,

Confidential, Virginia Beach, VA

ETL Informatica Developer

Responsibilities:

• Involved in the design, development and implementation of the Enterprise Data Warehousing (EDW) process and Data Mart.
• Used InformaticaPower Center8.6for migrating data from various OLTP servers/databases to the data mart.
• Created complex Informatica mappings to load the data mart and monitored them. The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Expertise in developing SQL and Oracle PL/SQL code as procedures to implement the business logic.
• Worked on ETL design, development, source to target mappings, data warehouse transformations, on call support, troubleshooting, testing, and documentation.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
• Used Informatica Power Center/Power Exchange to extract/transform and load data from different operational data sources like Oracle, Flat files into staging area (Oracle) and load into Oracle data warehouse.
• Performed data analysis for Advanced Commercial Banking System (ACBS) data.
• Implemented Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Extensively worked with performance tuning at mapping levels. For example, implementing active transformation like filter as early as possible in the mapping.
• Created and configured workflows, and sessions using Informatica Workflow Manager.
• Performed unit test for Informatica mappings and workflows in both development and test environments.

Environment: Informatica Power Center 8.6, Toad Data Modeler, Oracle 10g/11g, Excel, Flat Files. Essbase, Hyperion. IBM Cognos

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, Shell Scripts, Database Systems, SQL and PL/SQL, Windows NT, Oracle8i and UNIX.