SUMMARY:

• A seasoned Business Intelligence Professional wif around 12 years of diverse BI technical experience in development, implementation, consulting projects which involves designing / extending data warehouse and implementing/customizing Oracle BI application solutions i.e.
• Financial, Procurement & Spend, HR and Project analytics at several client places in India, UK and US client locations.
• Self - motivated individual wif a diverse industry experience like Banking, Travel and Transportation, UK government Councils, Retail, Telecommunication etc.
• Quick to assimilate new ideas, concepts and cutting-edge technologies whilst demonstrating a logical and analytical approach to solving complex problems and issues. Able to work well on own initiative while demonstrating teh organization and prioritization required to achieve tight deadlines and deliverables.
• A motivational and inspirational leader who enjoys being part of a successful and productive team, and thrives in highly pressurized and challenging working environments.

TECHNICAL SKILLS:

Software: Tableau, Oracle Data Visualizer 12c, OBIEE 10x/11x/12c, Informatica 8.x/9.x, DAC 10.x/11x, BOXIR2, ODI 11g/12c, BIPublisher11g

Languages: Oracle SQL, PL SQL, VBScript, Batch script, C/C++,Java

Project Management Tools: Microsoft Project

Databases: Oracle 10g, 11g, 12c, MSSQL

Applications: OBI Apps 7.9.6.3/4 Finance, Procurement & Spend, HR and Project analytics, OBI Apps 11.1.1.x Finance, Procurement & Spend and Project analytics, OBI Apps fusion HCM analytics.

Industries: Banking, Travel and Transportation, UK government Councils, Retail, Telecommunication.

Operating Systems: Windows 10/8/7/XP, Windows server 2003, 2007 and Unix,Redhat, Oracle Linux

Methodologies: Oracle Unified Methodology, Agile.

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Florida

BI Technical lead

Responsibilities:

Leading a four member BI offshore support team I am responsible for maintaining and enhancing teh BI solution on four OBIEE/ETL environments. Responsible for administrating 500+ user base across eight operating units in 4 different time zones worldwide providing every kind of support on reporting and ETL issues and fixes.

Technical Environment (Development/UAT/Production): OBIEE 11.1.1.7.14 x, OBIEE 12.2.1.4, Oracle Data Visualizer 12c, BIAPPS 7.9.6.4, Informatica 9.1, DAC 11g, EBS 12.1.3, Linux

Confidentia

Senior Consultant Lead (Oracle SSI)

Responsibilities:

Heading one of teh two BI teams of 5 consultants each I was responsible to deliver phase 3 and 4 reports by Dec 2015 end. dis involved massive enhancement to teh OOTB warehouse adding/modifying ETL to add new columns and new dimensions and facts and RPD BI metadata.

Technical Environment (Development/UAT/Production): OBIEE 11.1.1.7.x, BIAPPS 11g, ODI 11g, EBS 12.1.3, Linux

Confidential

Senior Consultant (Oracle SSI)

Responsibilities:

responsible for configuration and implementation of Oracle BI Applications 11g Financial Analytics, Procurement & Spend Analytics and Project Analytics modules. Phase - 1 “COSMOS”: dis Project started wif teh implementation of Oracle BI Applications 7.9.6.3 Financial Analytics, Procurement & Spend Analytics modules and a custom integration of Project module to support project based financial and procurement reporting in absence of project analytics on Oracle EBS 12.1.3 source. Wif DFF customizations and some 100 custom reports development Phase 1 went live on March 2013. Phase - 2 “BI Theia”: After a successful go-live of COSMOS project, our next challenge was to expand BI reporting on Hyperion Essbase cube, Angel’s legacy fleet management system and CRM system (both on SQL server 2012 db) real time and adding Project analytics module. Also to add were numerous new ETL changes to support new reporting requirements. OOTB RPD was extended wif new Business Models and subject areas wif almost 400+ new reports and 15 new dashboards targeting different business users of Finance, procurement, project and CEO departments. Project went live on June14 and then continued working as a BI admin supporting day to day support work and other upgrade activities. Being teh only BI resource on dis project right from teh beginning was quite challenging.

Technical Environment (Development/UAT/Production): OBIEE 11.1.1.7.x, BIAPPS 7.9.6.3, BI Publisher, Smart View, BI Mobile, Informatica 8.6.hot fix 2, DAC 11g, EBS 12.1.3, Linux

Confidential

BI Consultant (Oracle SSI)

Responsibilities:

Wif a two member team I was able to implement all analytics applications live for all teh Confidential locations across continents on 10 th Aug12. Wif 60+ custom reports OBIEE 11g was customized to implement Multicurrency, Integration wif EBS system wif ledger based and Organization based security.

Technical Environment (Development/UAT/Production): OBIEE 11.1.1.5.1 x, BIAPPS 7.9.6.3, Informatica 8 hot fix 2, DAC 10g, EBS 12.1.3, Linux

Confidential

BI Consultant (Oracle SSI)

Responsibilities:

Contributed in upgrading ETL environment from 10g to 11g, supported in fixing UAT issues, Creating/modifying reports & Dashboards, managing user security, migration of HR analytics delivery from dev to Production.

Technical Environment (Development/UAT/Production): OBIEE 11.1.1.5.x, BIAPPS 7.9.6.2, Informatica 8 hot fix 2, DAC 10g, EBS 12.1.3, Linux

Confidentia

Senior Member of Technical Staff

Responsibilities:

Responsible for setting up various Reporting and ETL environments which involves Installation and Configuration of OBIEE 11g & OBI Fusion Apps 11g, DAC 11.x, Informatica 9.0.x. dis project also involves validation of Oracle apps fusion product for HCM sub modules, understanding Fusion HCM UI flow to come up wif various logical test scenarios, writing Data Validation queries for Data warehouse to ensure Quality assurance. Creating full ETL environment setup and Running HCM specific ETLs analyzing/debugging task failures and apply possible workarounds to successfully populate Oracle Data warehouse. Extensively used OBI Fusion apps 11g on OBIEE 11g platform.

Technical Environment (Development/UAT/Production): OBIEE 11g & OBI Fusion Apps 11g, DAC 11.x, Informatica 9.0.x., EBS Fusion, Linux

Confidential

Senior Software Engineer

Responsibilities:

Working for my client Oracle IDC my role was to setup complete, end-to-end BI environment covering teh BI platform and pre-packaged analytic applications . Responsible for setting up various Reporting and ETL environments which involves Configuration of OBIEE 10.1.3.4.x, 11g & OBI Apps 7.9.6.2 & 3, DAC 10.1.3.4.x, Informatica 8.6.x. Running PSFT, EBS adapters ETLs analyzing/debugging task failures and applying possible fixes /workarounds to successfully populate Oracle Data warehouse. Writing SQL scripts and batch scripts, to automate most of teh Data Validation work. Writing test case documents and installation documents .

Technical Environment (Development/UAT/Production): OBIEE 10.1.3.4.x, 11g & OBI Apps 7.9.6.2 & 3, DAC 10.1.3.4.x, Informatica 8.6.x., EBS 12.1.3, Linux