SUMMARY:

• Having total 9 Years of IT experience on Oracle Business Intelligence (OBIEE), Oracle PLSQL and Informatica.
• Currently working as a Senior BI Developer with Equinix at Singapore.
• Currently holding B1 Visa and Employment Pass (2 Years - Singapore).
• Experience in physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration.
• Experience in creation of dimension and fact tables, logical columns, hierarchies, level-based measures in Business model and catalog folders in Presentation layers.
• Experience in configuring Interactive Dashboards.
• Experience in installation and configuration of OBIEE 11g/12c in the windows environment.
• Experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
• Experience in Creating Roles/Groups and OBIEE 11g/12c Security.
• Experience in creating OBIEE 11g/12c reports, dashboards.
• Experience in creating BI Publisher reports.
• Working extensively on Oracle- 9i/10g/11g/12c environment with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL. Also have an excellent knowledge on TOAD.
• Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.x.
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica (Power Mart/ Power Center- Meta Data Repository, Designer, Server Manager).
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Experience in extracting the data from different source systems like Cassandra NoSQL Database using Python.
• Conceptual knowledge of Data Warehousing in ETL tools.
• Experienced in all phases of software Development Life Cycle (SDLC) like System analysis, design, development, testing, implementation, and maintenance.
• Good analytical, problem solving skills, ability to learn quickly and Self-motivated.

TECHNICAL SKILLS:

Operating System: Windows 98 /2000/NT, MS-DOS, UNIX

Database: ORACLE-9i/10g/11g/12c, Oracle EBS R12,Netezza, NoSQL DB s .Analytics:OBIEE 11.1.1.6.2/11. x.x.7,12c,Tableau

ETL Tool: Informatica PowerCenter 8.6, 9.0, 9.5.1, 9.6.1/10 Packages: MS - OFFICE

Languages: SQL, PL/SQL, Python

Tools: Sql Developer, ToadProjects ProfileProject # 1: EquinixTitle: BI Equinix

PROFESSIONAL EXPERIENCE:

Confidential

Environment: OBIEE 11g, 12c, Tableau, Oracle 11g/12c, Informatica 9.6.1/10, Python

OBIEE, Tableau and Informatica Developer

Responsibilities:

• Created OBIEE 11g/12c reports, dashboards.
• Experience in physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration.
• Experience in creation of dimension and fact tables, logical columns, hierarchies, level-based measures in Business model and catalog folders in Presentation layers.
• Experience in configuring Interactive Dashboards.
• Experience in installation and configuration of OBIEE 11g/12c in the windows environment.
• Experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
• Experience in Creating Roles/Groups and OBIEE 11g/12c Security.
• Experience in creating BI Publisher reports.
• Created Tableau worksheets, dashboards and stories using Tableau Desktop.
• Experience in Google Big query.
• Working extensively on Oracle- 11g/12c environment with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL. Also have an excellent knowledge on TOAD.
• Experience in creation of monthly snapshots using Oracle PLSQL procedures, packages.
• Created Tables, Views, Triggers, Cursors.
• Experience in Performance Tuning and query optimization.
• Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.x.
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica (Power Mart/ Power Center- Meta Data Repository, Designer, Server Manager).
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Experience in extracting the data from different source systems like Cassandra NoSQL Database using Python.

Confidential

Environment: OBIEE 11g, Oracle 11g, Informatica 9.1Duration:

OBIEE and Informatica Developer

Responsibilities:

• Created OBIEE 11g reports, dashboards.
• Experience in physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration.
• Experience in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model and catalog folders in Presentation layers.
• Experience in configuring Interactive Dashboards.
• Experience in installation and configuration of OBIEE 11g in the windows environment.
• Experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
• Experience in Creating Roles/Groups and OBIEE 11g Security.
• Experience in creating BI Publisher reports.
• Worked extensively on Oracle- 9i/10g/11 g environments with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL.
• Programmed Packages, Stored Procedures, Triggers, Cursors using Oracle 11g.
• Experience in Performance tuning and query optimization.
• Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.x.
• Extensively used ETL methodology for supporting Data Extraction, transformations and loading processing, using Informatica (Power Mart/ Power Center- Meta Data Repository, Designer, Server Manager).
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.

Confidential

Environment: OBIEE 11g, Oracle 11g, Informatica 8.6Duration:

Team Member

Responsibilities:

• Created OBIEE 11g reports, dashboards.
• Experience in physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration.
• Experience in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model and catalog folders in Presentation layers.
• Experience in configuring Interactive Dashboards.
• Experience in installation and configuration of OBIEE 11g in the windows environment.
• Experience in Creating Dimensional Hierarchies, Level Based Measures. Time series Functions, Initialization Blocks and Variables depending upon the need for Business Reports using the OBIEE Admin tool.
• Experience in Creating Roles/Groups and OBIEE 11g Security.
• Experience in creating BI Publisher reports.
• Worked extensively on Oracle- 9i/10g/11 g environments with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL.
• Creating Tables, Stored Procedures, Functions, Triggers, Collections, Dynamic cursors, Query optimization, Performance tuning and Constraints.
• Programmed Packages, Stored Procedures, Triggers, Cursors using Oracle 11g.
• Experience in Performance tuning and query optimization.
• Involved in Table Designing.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Extensively used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator and Joiner.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Used Informatica Workflow manger to create Sessions, Workflows and worklets to run the mappings.
• Worked on performance improvement like cutting down the production batch runtime and writing new prod batch logic to improve batch performances using PLSQL Cursor, Unix Shell scripts.
• Involved in ETL Testing.

Confidential

Environnent: Informatica PowerCenter 8.6, OBIEE 10.1.3.x, OBIA7.9.6.2Database: Oracle 11g, Oracle EBS R12

Analyst Programmer/OBIA Developer

Responsibilities:

• Creating Tables, Stored Procedures, Functions, Triggers, Collections, Analytical functions, Dynamic cursors, Query optimization, Performance tuning and Constraints.
• Customized OBIEE Repository per user requirements and available information in DW.
• Experience in installation and configuration of Oracle BIEE 10g in the windows environment.
• Experience in physical layer, Business model mapping layer and Presentation layer using on oracle BI Server administration.
• Experience in creation of dimension and fact tables, logical columns, hierarchies, level based measures in Business model and catalog folders in Presentation layers.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Developed customized reports for EAM apart from HR, Finance, Spend and Procurement pre-built Analytics.
• Worked extensively on Oracle- 9i/10g/11 g environments with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL.
• Creating Tables, Stored Procedures, Functions, Triggers, Collections, Dynamic cursors, Query optimization, Performance tuning and Constraints.
• Programmed Packages, Stored Procedures, Triggers, Cursors using Oracle 11g.
• Experience in Performance tuning and query optimization.
• Involved in Table Designing.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Developed and customized the coding of Informatica Mapping for the different stages of ETL (SDE/SIL).
• Extensively used Transformations like Source Qualifier, Lookup, Expression, Router, Aggregator and Joiner.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Involved in development of Informatica Mappings using transformations like Source qualifier, Aggregator, Connected & unconnected Lookups, Filter
• Involved in ETL Testing and OBIEE reports testing.
• Written test scripts to compare OLTP vs OLAP for ETL testing.
• Coordinated activities onsite & offshore towards meeting project timelines.
• Prepared ETL Design Documents and OBIEE Repository Design Documents.
• Excellent Knowledge on Oracle HRMS EBS Tables and ERP Forms.

Confidential

Environment: Oracle 10g, VB ScriptsDuration: Role

Team Member

Responsibilities:

• Creating Tables, Stored Procedures, Functions, Triggers, Collections, Analytical functions, Dynamic cursors, Query optimization, Performance tuning and Constraints.
• Worked extensively on Oracle- 9i/10g/11 g environments with expertise in Stored Procedures, Triggers, Functions, Dynamic cursors, Query optimization, Performance tuning and Packages using SQL, PL/SQL and advanced PL/SQL.
• Creating Tables, Stored Procedures, Functions, Triggers, Collections, Dynamic cursors, Query optimization, Performance tuning and Constraints.
• Programmed Packages, Stored Procedures, Triggers, Cursors using Oracle 11g.
• Experience in Performance tuning and query optimization.
• Involved in Table Designing.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Tickets resolving by doing analysis and enhancements to the existing system
• Documentation