We provide IT Staff Augmentation Services!

Data Warehouse And Business Intelligent Developer Resume

OBJECTIVE:

To obtain a position in the field of Computer Engineering, where my skills and ability will enhance the company’s success and there by my own growth.

CAREER PROFILE:

  • Has FOURTEEN YEARS of professional experience in Database Development using SQL and PL/SQL, Oracle forms and reports, Design, Development and Implementation of various Software Applications.
  • SAP business Objects
  • Two years Experience in Oracle Application Development Framework (Oracle ADF), Oracle JDeveloper 11g.Expose the data model in a web application with a rich ADF Faces user interface.
  • Create JSF,jspx pages
  • Use rich client components in JSF pages
  • Add validation to ADF applications
  • Secure Web applications
  • Extend Business Components to support company standards
  • Provide validation, calculations and LOVs
  • Dissect and employ essential data binding components
  • Design application components for reuse
  • Leverage Expression Language, Managed Beans and Java Server Pages
  • Enhance an application with Active Data Service and ADF visualization components
  • Customize the look - and-feel of an application by using skins
  • Integrate applications with SOA and Web Center
  • Has more than Twelve years of extensive Analysis, Design, Development and Implementation experience in Oracle Applications.
  • Has expertise includes extensive technical knowledge & work experience on ORACLE 8i/10g, using Oracle Forms, PL/SQL, ORACLE Reports, SQL*Plus, DESIGNER 2000, DEVELOPER/2000, DEVELOPER/6i and other related tools and techniques on ORACLE database system.
  • Has good experience in developing front-end GUI based applications using DEVELOPER/6i, DEVELOPER/2000, and Oracle Forms and Reports 6i.
  • Has excellent Technical skills & Work Experience in Development & Implementation on ORACLE INSURANCE and FINANCIALS System. Worked extensively on financial modules like General Ledger GL, Accounts Payable AP, Accounts Receivable AR, Money laundering, Bank Reconciliation, Cash Management CM and Fixed Assets FA and also Manufacturing modules like Inventory INV
  • Has five years experience in Oracle Data warehouse.
  • Experienced in ETL development and Data Migration using native tools of Oracle (SQL LOADER, PL/SQL)
  • Familiarity with Oracle data warehousing features such mappings, Scheduling, materialized Views, bitmap indexes, Index Organized Tables, external tables etc.
  • Good knowledge in STAR Schema, Snow Flake Schema, FACT Tables and Dimension Tables
  • Sound Knowledge and Experience with Business Objects XI 3.1
  • Universe Builder, SAP Business Objects (Web business Intelligence Document)
  • Experienced in Database Optimization by making use of various Performance Tuning techniques.
  • Proficient in database and SQL tuning. using HINTS, EXPLAIN PLAN and index.
  • Experienced in Partitioning Administration. Creating and Managing Partitioned Tables and Indexes.
  • Experienced in Normalized Database Design and Modeling. (Logical and Physical design of database)
  • Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
  • Experience in physical and logical data modeling.
  • Very good knowledge and experience in using Oracle in-built packages like UTL FILE, DBMS SQL etc.
  • Extensively worked in Oracle Forms, Reports.
  • Very good working knowledge and experience in TOAD.
  • Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
  • Experienced to translate reporting and analytical needs into technical solutions
  • Experienced in writing SQL queries, understanding requirements, writing functional specs, writing test specs and plans.

FAMILIAR SOFTWARE/HARDWARE AREA:

Programming Languages: Oracle ADF, Oracle Forms 6i, Report 6i, SAP Business Objects XI 3.1, Oracle warehouse builder 10g, Java, JavaScript, XML, PHP,HTML, AJAX,JAVA, and JSP Visual InterDev (Java Script, VB Script, ASP) Visual Basic 6 SQL, PL/SQL, Oracle Forms 10g, Reports 10g,Business ORACLE Discoverer ( Analytical reporting tool ), C++, Pascal

Database: Oracle 11g, ORACLE 10g, ORACLE 9i, ORACLE 8i, My SQL, MS SQL Server 2005, MS Access, WAMP Sever, Oracle Warehouse Builder 10g.TomCat

Application Software: Microsoft Office, Open Office

Operating Systems: Windows XP, Linux, Unix, MSDOS, Windows 95, 98, 2000, Windows NT

PROFESSIONAL EXPERIENCE:

Data Warehouse and Business Intelligent Developer

Confidential

Responsibilities:

  • Oracle Data Warehouse Design
  • Perform as a business analyst by understanding business requirements, translating those into solutions, and explaining the solution effectively
  • Star schema design
  • Snowflake schema design
  • Data modelling by using Oracle data warehouse builder
  • Write PL/SQL to transfer the data to the data warehouseCreate data mappings by using Oracle data warehouse.
  • Scheduling data by using Oracle data warehouse.
  • Create table space
  • Create users and provide grants based on their roles.
  • Ad Hoc queries
  • Create universe to user to full fill their requirementsHelp user to solve data errorsHelp users to generate complex report by using SAP Business Objects.
  • Develop and create business objects reports
  • Oracle ADF developer
  • Development of the Work shop system using ADF.

Technical Leader

Confidential

Responsibilities:

  • New product development team to the Confidential
  • Developed new product for Confidential .
  • E - Business Application of Easy -pay Module for the Confidential system.
  • This system was integrated with the existing Insurance system and it is facilitated to the customer to pay the premium by using SMS and mobile application for the insurance system.
  • ERP Application of Agent training Module
  • This system is enabling to the human recourse department to track the agent training and analysis the cost benefit to the company.
  • Handling ERP System inventory, order entry, purchasing, product configuration, supply chain planning, supplier scheduling, inspection of goods, claim processing, commission calculation
  • Human resources, payroll, training, time and attendance, benefits
  • General ledger, cash management, accounts payable, accounts receivable, fixed assets, Bank reconciliation
  • Customer relationship management
  • Sales and marketing, commissions, service, customer contact, call - center support
  • Various "self-service" interfaces for customers, suppliers and/or employees
  • Management of user privileges for various processes

Technical Leader

Confidential

Responsibilities:

  • System analysis and design
  • Technical writing
  • Software development
  • Write database triggers
  • Write PL/SQL Procedure, Functions and Packagers
  • Application fine tuning
  • Quality Assurance
  • Data transfers between Oracle Databases (production and testing)
  • User training and Coordination with other divisions.
  • Software configuration management
  • Data modelling
  • Teat case designing
  • DDL, DML SQL queries writing
  • Existing system maintains
  • SQL tuning
  • Oracle Performance tuning

Technology & Tools:

  • ORACLE 10g as the Backend Data Repository
  • Database Stored Procedures and Functions
  • Oracle Developer 6i forms and Reports and Oracle Developer suite 10g
  • SQL Plus
  • SQL Navigator (Quest Software)
  • Toad (Quest Software)
  • SAP Business Object XI

Analyst Programmer

Confidential

Responsibilities:

  • I involved in complete lifecycle project of the above system which includes requirement analysis, design, development and testing.
  • Systems Analysis and design
  • Research
  • Software development
  • Quality Assurance
  • Technical Documentation & User Manual
  • Implementation
  • User Training
  • Data molding
  • Relational data base design and implementation.
  • Writing Software specification
Technology & Tools:
  • ORACLE 9i and ORACLE 10g as the Backend Data Repository
  • Database Stored Procedures and Functions
  • Oracle Developer 6i forms and Reports and Oracle Developer suite 10g
  • SQL Plus
  • SQL Navigator (Quest Software)

Hire Now