We provide IT Staff Augmentation Services!

Principal Bi Applications Engineer Resume

Redwood, CA

SUMMARY:

  • Over 16 years of IT experience in Analysis, design and development.
  • 8 years of experience in Oracle Data Integrator (ODI).
  • 10 years of experience in Data warehouse/Conversion and Integration projects.
  • Worked on multiple source system as Oracle EBS, CRM, custom Oracle source systems for requirements gathering and involved in data modelling .
  • Experience in Informatica Power Centre/ Mart.
  • Extensive experience in Oracle ERP Apps (PO/INV/WIP and OM).
  • Extensive experience in SQL and PL/SQL.
  • Extensive experience in development of database objects Stored Procedure/Functions/Triggers/Materialized view etc.,
  • Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Oracle, MySQL, SQL Server.
  • Working experience in using Oracle 10g/9i/8i, SQL, SQL Plus, PL/SQL, Shell Scripts, Windows XP/2000/98/95, and UNIX.
  • Excellent in Trouble shooting and problem solving skills.
  • Self Motivated and goal oriented, able to operate with sense of urgency as needed to meet deadlines, can take ownership of assignments.
  • Excellent Team player with effective communication and leadership skills.
  • Willingness to learn and master new technology as fast pace.

TECHNICAL SKILLS:

ERP: Oracle Apps 11.5.10(BOM/WIP/INV/PO/OM)Point Man

RDBMS: ORACLE 8i/9i/10g(SQLPLUS, PL/SQL, SQL Loader)

Programming Language: Visual Basic 6.0,Forms 6i

Web Development: HTML, Oracle WebDB(Portal)

ETL Tool: Informatica 6.2 (Power center / Power mart),Oracle Data Warehouse Builder, Oracle Data Integrator

Reporting Tool: Oracle Forms and ReportsCrystal Reports 8.x,Discoverer 4.x

Operating Systems: Windows 98, 2000, XP,NT, Sun Solaris 5.x

PROFESSIONAL EXPERIENCE:

Confidential, Redwood, CA

Principal BI Applications Engineer

Responsibilities:

  • Involved in Various phases of the project like Requirement understanding, preparing mapping documents and development of the mappings.
  • Involved in Migration ETL Mappings from Oracle to Microsoft SQL Server.
  • Mapping involves various types of transformation like Lookups, Update, Joins, Filters and Error handling using ODI.
  • Installation and Configuration, Deployments of ODI in LINUX/AIX environments
  • Worked on configuration, setup and deploying OK Analytics product in Web logic
  • Extensive Experience on web logic clustering and managed servers and domains.
  • Creation of PL/SQL cursors, functions, procedures, packages and Triggers in Oracle and calling then in ODI through ODI Procedures.
  • Hands on Experience in Performance tuning ( Materialized Views, Partitioning, Hints, Explain Plain)
  • Studying the existing environment and accumulating the requirements by querying the Clients on various aspects and Identification of various Data Sources and Development Environment.
  • Extensively used Oracle Data Integrator for loading the data from various sources involving flat files and oracle tables.
  • Involved in Developing Mappings, Creating Interfaces, Packages and Scenarios.
  • Responsible for Mapping and Test case development, unit testing and documentation.
  • Hands on Experience in ODI Administration and Security Configuration
  • Developed the source to target mappings and (ETL) data design documentation for fact and dimension tables, including architecture blueprint and program specifications.
  • Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes.

Confidential, New Jersey

Principal BI Applications Engineer

Technologies Used: Oracle Data Integrator, Oracle 11g, PL/SQL and SQL* Loader

Responsibilities:

  • Interacted with the Business Analyst in collecting the business requirements for the project.
  • Analysis and design approach on the business requirements given above.
  • Modified Knowledge modules to customize it to ETL requirements
  • Wrote SQL, PL/SQL, Stored Procedures and Triggers for implementing business rules and transformations.
  • Topology settings for various sources and targets.
  • Involved inter team discussion for report development using Oracle Express.
  • Performance tuning on the ETL Code for large data volume e.g. Partitioning the tables etc.,

Confidential, Nevada

Principal BI Applications Engineer

Technologies Used: Oracle Data Integrator, Oracle 11g, PL/SQL and SQL* Loader

Responsibilities:

  • Leading Off - shore team, in assigning the task and getting works done.
  • Interacted with the Business Analyst in collecting the business requirements for the project.
  • Analysis and design approach on the business requirements given above.
  • Modified Knowledge modules to customize it to ETL requirements
  • Wrote SQL, PL/SQL, Stored Procedures and Triggers for implementing business rules and transformations.
  • Topology settings for various sources and targets.
  • Involved inter team discussion with BI(OBIEE) Team for on report development
  • Performance tuning on the ETL Code.

Confidential, Mountain View, CA

Principal BI Applications Engineer

Technologies Used: Oracle Data Integrator, Oracle 10g, PL/SQL and SQL* Loader

Responsibilities:

  • Interacted with the Business Analyst in collecting the business requirements for the project.
  • Analysis and design approach on the business requirements given above.
  • Assisted the Data Architect in designing and modeling of the database.
  • Data Migration from flat source files from multiple data stores to load to ORACLE 9i/10g with appropriate conversion rules.
  • Built transformations, configured servers and established connections to various sources and targets
  • Using Oracle Data Integrator Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
  • Customized Email distributions to get the error messages and out put from ODI package run.
  • Modified Knowledge modules to customize it to ETL requirements
  • Handled error through exception handling and configured the event-based scenarios to send the alert emails.
  • Wrote SQL, PL/SQL, Stored Procedures and Triggers for implementing business rules and transformations.
  • Topology settings for various sources and targets.
  • Performance tuning on the ETL Code.

Confidential, New Jersey

Principal BI Applications Engineer

Technologies Used: ERWIN 3.5, Oracle Data Integrator, Oracle 10g, PL/SQL and SQL* Loader

Responsibilities:

  • Interacted with the Business Analyst in collecting the business requirements for the project.
  • Analysis and design approach on the business requirements given above.
  • Assisted the Data Architect in designing and modeling of the database.
  • Data Migration from flat source files from multiple data stores to load to ORACLE 9i/10g with appropriate conversion rules.
  • Built transformations, configured servers and established connections to various sources and targets
  • Using Oracle Data Integrator Developed, Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances.
  • Customized Email distributions to get the error messages and out put from ODI package run.
  • Modified Knowledge modules to customize it to ETL requirements
  • Handled error through exception handling and configured the event-based scenarios to send the alert emails.
  • Wrote SQL, PL/SQL, Stored Procedures and Triggers for implementing business rules and transformations.
  • Topology settings for various sources and targets.
  • Performance tuning on the ETL Code.

Confidential, New Jersey

Principal BI Applications Engineer

Technologies Used: Informatica Power Center 6.2, Oracle 8i, PL/SQL, SQL* Loader, ERWIN 3.5, SQL server 2000, Windows NT 4.0, Unix, Shell Script

Responsibilities:

  • Created workflows for the different tasks using Workflow Manager.
  • Creating Users, Folders, Assigning access Permissions to repository Users.
  • Development of ETL mappings using Informatica and PL/SQL.
  • Developed Event Wait Tasks for the workflow
  • Created transformations according to Business Requirement
  • Performance tuning on the ETL Code
  • Production Support for the existing Data Warehousing Projects for Day to day activities and also for the new requirements / enhancements.

Hire Now