SUMMARY:

• A Technology Oriented Professional with 8 years of experience in the field of Data Warehousing and Business Intelligence.
• Presently working at Confidential LLC as an OBIEE Architect/Lead
• Excellent and proven abilities in OBI Apps, OBIEE, Informatica, DAC, SQL, PL/SQL, Oracle DBA, Java.
• Very good exposure of Iterative and Test Driven Development.
• Very good exposure to Oracle Applications 11i/R12 Environments.
• Excellent exposure to architectural design, development and testing of BI Applications using Oracle Technologies.
• Excellent Communication skills, both written and verbal.
• Excellent Project Management, Leadership, Time Management skills and Project Delivery skills.

TECHNICAL SKILLS:

Software Languages: SQL, PL/SQL, Java

Version Control Tools: Clearcase, CVS, ARCS

S/E Methodologies: Waterfall, Iterative model, Agile

Operating System: Windows, Unix, Linux, Solaris

RDBMS: Oracle 9i/10g/11g

Internet: MVC Architecture, JSP, Servlets

Tools: OBI Apps 7.9.6.3, OBIEE 11g / 10.1.3.4, Informatica 8.6.1, DAC, SQL Developer, MyEclipse

Functional: Proficient in design and development of ETLs, RPD, Dashboards and Reports

ERP System: Oracle Applications 11i/R12

Application Servers: Weblogic, OC4J, Apache, Oracle Application Server

PROFESSIONAL EXPERIENCE:

Confidential, NYC

OBIEE Architect/Lead

Technology/Tools: OBIEE 11g, Weblogic, SQL, PL/SQL, Oracle Apps R12, Noetix Apps.

Responsibilities:

• Responsible for the development of Project Plan, Architecture design and delegating the tasks among the team members.
• Responsible for installation, configuration, implementation of OBIEE 11g.
• Responsible for designing the high available & scalable Architecture.
• Responsible for the development & deployment of RPD using OBIEE Admin Tool.
• Responsible for the development of custom reports and dashboards in OBIEE.
• Responsible for customization of Out - Of-The-Box ETL mappings and RPD.
• Responsible for modifying of all the three layers in the OBIEE RPD.
• Excellent understanding of implementing Authentication & Data Level Security in OBIEE.
• Responsible to performance tuning of OBIEE Reports.
• Responsible for deciding the mechanism of deployment of RPD & Catalog from Dev to Test and Prod Environments.
• Responsible for Integration of OBIEE 11g with Oracle Apps R12.
• Coordinate product management and strategy team for ensure technical feasibility of business requirement document and functional design documents through conference call.
• Involved in the development and customization of Star-Schema data model.
• Serving as the lead troubleshooter to diagnose technology and functional related issues in development.
• Coordinating between offshore team members and onsite business analysts.
• Review the SQL queries and Mappings and suggested changes to ensure the optimal performance

Confidential, New York

Technical Lead/Architect

Technology/Tools: OBI Apps 7.9.6.2, OBIEE 10g/11g, Informatica 8.6.1, DAC, SQL, PL/SQL

Responsibilities:

• Responsible for Installation, Implementation and Customization of OBI Apps 7.9.6.2/7.9.6.3.
• Responsible for the development of Project Plan and delegating the tasks among the team members.
• Responsible for the development & deployment of RPD using OBIEE Admin Tool.
• Responsible for Installation and Configuration of Informatica, DAC, OBIEE 11g.
• Responsible for the development of custom reports and dashboards in OBIEE.
• Responsible for customization of Out-Of-The-Box ETL mappings and RPD.
• Responsible for modifying of all the three layers in the OBIEE RPD.
• Responsible for scheduling the ETL run using DAC 10.1.3.4.
• Excellent understanding of implementing Authentication & Data Level Security in OBIEE.
• Responsible to performance tuning of OBIEE Reports.
• Responsible in ETL Coding & Code review using Informatica
• Coordinate product management and strategy team for ensure technical feasibility of business requirement document and functional design documents through conference call.
• Involved in the development and customization of Star-Schema data model.
• Serving as the lead troubleshooter to diagnose technology and functional related issues in development.
• Coordinating between offshore team members and onsite business analysts.
• Review the SQL queries and Mappings and suggested changes to ensure the optimal performance
• Developed the various mappings using various transformations like source qualifier, joiner, filter, router, expression, aggregation, lookup, etc.
• Tuned the ETL code at query, Mapping and Session level.

Confidential

Technical Lead

Technology/Tools: OBIEE, Informatica, DAC, SQL, PL/SQL

Responsibilities:

• Responsible for the development of RPD using OBIEE Admin Tool for reporting purpose.
• Responsible for the development of custom reports and dashboards in OBIEE.
• Responsible for configuration of OBIEE with Weblogic Application Server.
• Responsible for designing of all the three layers in the OBIEE RPD.
• Involved in ETL Coding & Code review using Informatica
• Coordinate product management and strategy team for ensure technical feasibility of business requirement document and functional design documents through conference call.
• Involved in the development of Star-Schema data model along with the business analysts and Data-Modeling Team.
• Served as the lead troubleshooter to diagnose technology and functional related issues in development.
• Coordinated between offshore team members and onsite business analysts.
• Review the SQL queries and Mappings and suggested changes to ensure the optimal performance
• Developed the various mappings using various transformations like source qualifier, joiner, filter, router, expression, aggregation, lookup, etc.
• Tuned the ETL code at query, Mapping and Session level.
• Developed technical design document for audit review.
• Design the testing strategy to ensure the functionality and performance.

Confidential

PL/SQL Developer

Technology/Tools: OBIEE, SQL, PL/SQL, SQL Developer

Responsibilities:

• Design of metadata definitions for various LSH modules.
• Development of various packages, procedures, functions and triggers using PL/SQL.
• Enhancements of the runtime engine of LSH to execute the Report Set object.
• SQL Tuning.
• Building RPD & Reports using OBIEE 10g
• Direct interaction with the customer on the enhancements they required. Have delivered many enhancements on stringent and demanding deadlines that were required for one-off patch releases.
• Implementation of logic within LSH to setup the post-processing feature for RS objects.
• Researched and prototyped the XML Publisher’s usage and integration scheme in the context of post processing of RS’s outputs.
• Design and implementation of the XMLP Adapter to integrate the LSH to XMLP.
• Setup, configuration and maintenance of the XMLP Distributed Processing Server, which handles post-processing requests.

Confidential

Pl/SQL Developer

Technology/Tools: OBIEE, SQL, PL/SQL, SQL Developer

Responsibilities:

• Responsible for building reports using OBIEE and BI Publisher for the Top Management Team.
• Responsible for writing complex SQL queries and PL/SQL code.
• Responsible for Installation, Configuration and Maintenance of Oracle Database, OBIEE on Windows servers.
• Responsible for bug-fixing and implementing the best practices to develop the product.
• Responsible for creation of packages, olb’s and pll’s.
• Responsible for creation of required procedures, functions and Object Libraries.
• Responsible for WebUtil configuration.
• Involved in Preparing Quality documents for the implementation.