Oracle Software Engineer
Resume:
Ajay Pratap Paidi
***************@*****.***
Summary
. Around 8+ years of in-depth BI/data warehouse experience in the areas
of analysis, design and development in client server technologies in
verticals like Telecom, Banking, and Retail domains.
. Extensively experienced in Data modeling in the datawarehouse as well
as Analytics spheres primarily using the Oracle BI technologies.
. Extensive experience on Business Intelligence/ETL tools - OBIEE,
Hyperion Essbase, Hyperion Planning, Informatica, ODI, Hyperion
Interactive Reporting, Smart View and Essbase Excel Addin.
. Exposure to End-to-End Project Lifecycle: Requirements gathering,
writing of business and technical specifications, prototyping, system
setup/installation/configuration, development, testing,
deployment/implementation across the globe, performance tuning,
documentation and support.
. Extensive experience in presenting Proof-of-Concept (POC).
Technical Skills Inventory:
Business Intelligence Tools : OBIEE 10.x /11.x, Hyperion Essbase
9.x/11.x
Planning 9.x/11.x
ETL tools : Oracle Data Integrator, Informatica
Databases : Oracle 10g, 11g
Operating Systems : IBM AIX, RHEL, Win2003 Server
Work Experience
Ioppolo & Associates - Australia Mar-2013 till date
BI Architect/Information Technology Consultant
Responsibilities:
. Design, implementation, customization, automation of OBIEE 11g for
Airlines and Government agencies.
. Installation & Configuration, Implementation and Customization of
Oracle BI Applications 7.9.6.4
. Performance tuning of the OBIEE reporting to reduce the dashboard
response times and improve user queries.
. Implementation of Enhanced security in OBIEE through SQL Adapters.
. Creation and Customization of new mappings in Informatica for OBI Apps
reporting.
Environment: OBIEE 11.1.1.6+, Oracle 11g, Hyperion Essbase 11.1.2.1,
Hyperion Planning 11.1.2.1, IBM AIX.
Work Experience
United Overseas Bank - Singapore Mar-2012 - Feb 2013
BI Architect/Information Technology Consultant
Responsibilities:
. Designing of Data Architecture/modeling using ESSBASE (11.1.2.1)
databases.
. Design and implementation of OBIEE 11.1.1.6 application.
. Performance tuning of OBIEE Reporting with Essbase as database.
. Performance tuning of Essbase calc scripts for increased batch
performance
. Installation, configuration and setup of the Oracle EPM 11.1.2.1 and
OBIEE 11.1.1.6
Environment: OBIEE 11.6, Oracle 11g, Hyperion Essbase 11.1.2.1, Hyperion
Planning 11.1.2.1, IBM AIX.
Standard Chartered Scope International May-2010 - Feb 2012
BI Architect/Sr. Product Specialist
Responsibilities:
. Design, implementation, customization, automation of Hyperion 9.3.0.1
(BI+ Reporting, Interactive Reporting, ESSBASE) and OBIEE 10.1.3.4.1
applications.
. Implemented OLAP Systems for Wholesale Banking reported across 60
countries analyzing with huge volume of data.
. Implemented Security for Relationship Managers to view revenues of
clients tied to their subordinates.
. Performance Tuning of OBIEE reporting through various oracle
optimization techniques
Environment: OBIEE 10.3.4.1, Essbase 9.3.0.1, Oracle 10g, Data Stage and HP
RHEL 4.
Thirdware Solutions Aug 2007 -
Feb 2010
BI Solutions/Technical Specialist
Responsibilities:
. Implementing business intelligence solutions for HR/ Telecom /Banking
domains through Hyperion Interactive Reporting, Essbase Integration
Services
. Developing Hyperion Interactive Reporting system on both Essbase and
Oracle databases
. Atomization of Hyperion Interactive dashboard systems through Java
script
Environment: OBIEE 10.3.4.1, Essbase 9.3.0.1, Oracle 10g, Data Stage and HP
RHEL 4.
Nexxoft Infotel Jun 2005 - Jul 2007
BI Solutions / Software Engineer
Responsibilities:
. Analyzing the Data Sources.
. Involved in Design and Development of Data Marts and implementation of
Star Schema Methodology.
. Developing the dashboards and Reports using Brio 6.6
Environment: Brio 6.6, Oracle 8i, Windows NT.
Contact this candidate