EXPERIENCE SUMMARY
          BI technical specialist, with present focus areas being ODI ,Informatica,EDQ  and he has in depth experience in ETL Development, ETL Testing,ODI, Informatica administration and Release & configuration Management. 
Extensive career experience in Data Warehousing, Decision support Systems and has wide experience in implementing Data Warehousing solutions to large corporate clients and has professional experience working with various industries such as Sales, Healthcare and Banking and Finance.
Also has experience in Oracle Products BIAPPS,ODI and SQL/PLSQL, EXADATA and EXALOGIC environments.
End to end BIAPPS Installation and configuration experience at customer site. Having 2 on site experience as well.

–    Having around 12 years of experience in IT.

Current Employment:
–       Working for ITC Infotech as ODI Architect/ Project manager ( Sep-2019 to till date) 

Previous employment:
–    Wissen Infotech  06/07/2018 to 07/06/2019
–    Oracle SSi from 03/11/2014 to 02/03/2018.
–    EDCS from 16/12/2013 to 31/10/2014
–    Nityo Infotech from 05/07/2012 to 13/10/2013.
–    Virtusa Ind Pvt Ltd from 11/10/2010 to 02/07/2012

EDUCATION
MCA (Computer Applications) from J.N.T University in 2008     with 76%.
B.Sc. (Computer Science) from S.V.  University in 2004 with 74%. 

TECHNICAL EXPERTISE
BI Development & Administration 

–    Domain expertise in Data Warehousing/ BI (Data Modeling, ETL, Analytical and OLAP) for     Retail, Banking, Health Care Sector.
–    Linking business strategy/ requirement to ETL Architecture and Design
–    Primarily worked on Data Warehousing projects(ETL, Data Modeling, Analytical)
–    Experience in Informatica Administration and Testing.
–    Experience in creating test scripts and testing strategy.
–    Experience of leading a team and guiding them in delivering the project.
–    Experience in collecting project requirements, coming up with design and providing it to the team members
–    Handling multiple project modules and responsible for technical deliveries.
–    Customer management and coordinating between customer stakeholders.
–    Have successfully managed onsite/offshore delivery models from onsite location. 
–    Good experience as ETL Lead and Data Modeling in the area of Data Warehousing (ETL/ BI) using Oracle technology tools.  
–    Hands on Experience in providing estimate in coming up with estimates for code development and Testing.

Database

–     Hands on experience in Oracle 11 g, 10g, 9i and Teradata V13 database.

Data Modeling

–    Knowledge in Erwin data modeling tool.

Other Areas
–    Knowledge in UNIX Shell scripting. 
–    Hands on experience in Control-M scheduling tool.
–    Installation experience of Oracle products BIAPPS, ORDM and ODI.
–    Worked on EXADATA, EXALOGIC servers
.

Core Competencies     
–    Experience in implementing Data Warehousing solutions to large corporate clients and has professional experience working with various industries such as Sales, Healthcare, Banking and Finance.

Product Competencies
–    BIAPPS 11.1.8.1
–    ODI 11g,12c
–    OBIEE 11g
–    Informatica 9.x/8x development.
–    Oracle 10g.
–    Control-M
–    ER
–    DAC

Process Competencies

Technologies and Methods

–    BIAPPS
–    ODI
–    Informatica 9.x
–    Control-M.
–    TOAD.
–    Oracle 9i Database 
–    EXADATA
–    EXALOGIC

Programming Languages and Operating Systems

–    C,C++,Shell Programming and Visual Basic.
–    Windows 7,NT, 2000, XP, Linux Platform, 

Methods
–    Good understanding on SDLC Methodologies and OUM.

Trainings:

–    Hands on training on OBIEE 10.1.3.4
–    Hands on training on BIAPPS 11G.

On Site Experience:

–            Worked in Kuwait for NBK project to gather the requirements(Client Location).
–            Worked in Singapore for SCB project to give knowledge transfer( Client Location).

Project Experience                                       Duration: Jul ‘2016 to till date
Company     SAIL
Customer                                    SCB
Team Size        6
About the Project    Project SAIL is a strategic multi year programme to implement am oracle automated AML monitoring system. Oracle FCCM is an industry standard, proven,configuarable and scalable system that ensure that the bank can implement the automated transaction and customer monitoring required to meet the AML policy and increasing regulatory expectations.  
Tasks involved    
–    Development of Custom Mappings in ODI 12C
–    Worked on SIT migration and enhancements.
–    Performance Tuned mappings and sessions to achieve best possible performance.
–    Worked with Operations team to make sure the migrated code is run smoothly as per the steps provided in implementation plan.
–    Perform Coding/testing/code review of ETL changes for the enhancements and defects and ensure the on-time delivery.

Project Experience                                       Duration: Aug ‘2015 to JUN 2016
Company     Oracle, Bangalore
Customer                                    BT
Team Size        15
About the Project    BT British Telecom is Implemented BI Solution. As a part of their BI strategy Oracle have been asked to provide solution for implementing the enterprise BI solution using BIAPPS 11.1.8.1
Tasks involved    
–    Development of Custom Mappings in BIAPPS
–    Worked on SIT migration and enhancements.
–    Performance Tuned mappings and sessions to achieve best possible performance.
–    Worked with Operations team to make sure the migrated code is run smoothly as per the steps provided in implementation plan.
–    Perform Coding/testing/code review of ETL changes for the enhancements and defects and ensure the on-time delivery.
–    BIACM Load Monitoring.

   Project Experience                                       Duration: MAR ‘2015 to Aug ‘2015
Company     Oracle, Bangalore
Customer                                    ASM upgrading its BIApps HR Analytics reports
Team Size        5
About the Project    –    Advantage Sales and Marketing is upgrading its BIApps HR Analytics reports (including custom reports)
from BIApps 7.9.6 to BIApps 11.1.1.8.1. Scope of this project is to configure BIApps 11g for enabling
vanilla reports and also recreate 50 existing custom reports.

Tasks involved    
–    BIApps Configuarations.
–    Creating custom reports.
–    Creating and modifying Load plans.
                                     
–    Prepared technical design documents and operational   
       manuals for process flow
–    Designing the ETL specifications based on the requirement. 
–    Creating the mappings according to the ETL Design 
specifications.
–    Creating the ODI Objects (Interfaces, Packages etc.)       
Deploying and testing the  mappings. 
    

Project Experience                                Duration: June ‘2012 to MAR ‘2015
Company     Oracle, Bangalore
Customer                                    Statoil Fuel and retail
Team Size        15

About the Project    SFR Project is a migration of SAP ERP to JDE Edwards and the current BI solution within SAP BI/ BW to be replaced by Oracle BI. 
Tasks involved    –    Worked on Infrastructure administration and SFR BI solution.
–    Meeting with client Technical and business team for SFR Technical and Business requirements on a daily basis.
–    ODI Installation and configuration.
–    BIAPPS infrastructure installation and configuration.
–    Installation and configuration of Informatica, DAC and OBIEE on hosting servers.
–    Done SFR QA Installations on Exalogic servers.
–    Worked on EXADATA, EXALOGIC servers.
–    Involved in the design of the ODI components.
–    Involved in Unit Testing, System Integration Testing, User Acceptance Testing
–    Release and configuration management

Project Experience                        Duration: DEC ‘2011 to JUN ‘2012
Company     Virtusa Ind pvt ltd
Customer                                    Iron Mountain Transformation Initiative Project 

Team Size        15
About the Project    Iron Mountain is World leader in information management services, assisting    more than 140,000 organizations in 39 countries on five continents with storing, protecting
and  managing their information, Leader in Records management, Data protection andrecovery and Information destruction.

Tasks involved    
–    Understanding the business functionality & Analysis of business requirements.
–    Involved in the preparation of the Detailed Design documents.
–    Creating Interface and packages by using Procedures, global and local variables For a Job. 

–    Implemented SCD Type 1 and SCD Type 2
–    Good Knowledge in Creating XML Related Interface and packages.
–    Good Knowledge in Creating File to DB and DB to DB Related Interface and packages.
–    Knowledge in FTP package.
–    Involved in Unit Testing and Test plan preparation to meet proper testing activity
    

 Project Experience                                       Duration: OCT ‘2010 to DEC ‘2011
Company     Virtusa Ind pvt ltd
Customer                                    JPMC ASSET MANAGEMENT
Team Size        3
About the Project    The SDW satisfies the reporting needs for JPM Asset Management’s Strategy & Planning, Marketing & Finance divisions. The SDW is integrated with the Operational Data Store (ODS) which receives the FETA, Condor and Sales CRM data feeds and subsequently processes them.
The SDW database is made up of staging tables (for temporary processing of data), dimension tables and fact tables.  The dimension and fact tables are populated by a process known as the ‘SDW Build’ that loads ‘holdings’ and ‘transactions’ data on a weekly and monthly basis.  This work-stream focuses specifically on the holdings data in the SDW.

Tasks involved    
–    Understanding the business functionality & Analysis of business requirements.
–    Involved in the preparation of the Detailed Design documents.
–    Creating Interface and packages by using Procedures, global and local variables For a Job. 
–    Good Knowledge in Creating File to DB and DB to DB Related Interface and packages.
–    Involved in Unit Testing and Test plan preparation to meet proper testing activity