We provide IT Staff Augmentation Services!

Ocdm Mapping, Etl Developer Resume

PROFESSIONAL EXPERIENCE

Profile:

  • Overall 6+ years of experience
  • Around 5+ years of experience in design, development, implementation, deployment, and management of software in Product Engineering Services.
  • Around 2 years of experience in Data Warehousing, ETL design & development .
  • Experience in development on various platforms
  • Experience in validation, verification and testing.
  • Can easily switch between individual as well as team contributor roles.
  • Good Understanding of the software development life cycle
  • Self - Motivated, Responsible and Goal oriented. Ability to get along well with team members and motivate co-workers.

Employer History:

  • Confidential as a Consultant.
  • Confidential as a Senior Associate.
  • Confidential as a Software Developer (Contractual).
  • Confidential as a System-IT Trainee.
  • Confidential as a Tech-supporter.

KEY SKILLS:

ERP: Oracle 11i (Oracle Apps: Purchasing Module)

DBMS Packages: Oracle 9i,10g,11g & Microsoft SQL-Server

Front End: Forms 6i & 9i and Reports 6i & 9i

Operating System: Windows XP, Windows 2000 Server, Basic Linux.

Languages: Oracle SQL, PL/SQL,SQL-Server & T-SQL.

DWH Module: Oracle Communications Data Model (OCDM), Oracle Airlines Data Module (OADM).

Tools: Oracle Data Integrator.

Tuning: Oracle SQL & PL/SQL Performance Tuning.

ASSIGNMENT HISTORY:

Company: Confidential

Role: - OCDM mapping, ETL Development & Design.

Responsibilities:

  • Design and develop the "Active Subscriber Base" calculation.
  • Fixed mapping for OCDM Reference and Base table.
  • Design and develop the ETL for Network Event Calculation.

Company: Confidential

Role: - ETL Development & SQL Performance Tuning.

Responsibilities:
  • ETL development & SQL tuning .

Company: Confidential

Role - ODI & ETL Development and SQL Performance Tuning.

Responsibilities:
  • Partially design & development on "Subscriber Active Base" calculation.
  • ODI interface development for Source to Stage and Stage to OCDM.
  • SQL tuning for inbuilt ETL of OCDM.

Company: Confidential

Role - Database Developer.

Responsibilities:
  • Understanding the functional flow and logic.
  • Design the report & developed DB objects as requirement.

Company: Confidential

Role - Database Developer.

Responsibilities:
  • Understanding the functional flow and logic.
  • Design the report & developed DB objects as requirement
  • Design the Historical Data processing steps.

Company: Confidential

Role – Database Developer.

Responsibilities:
  • Understanding the functional flow and logic.
  • DB design & develop DB objects for the individual project.
  • Create Procedure & function to calculate "Ratio" as per business requirement

Company: Confidential

Role – Database Developer.

Responsibilities:
  • Setting up the application
  • Resolved user-end problems and provided full system support in total flow after implementation.
  • Designed & developed all reports as per user requirements.
  • Implement the Payroll Management System & giving training to the user.

Company: Confidential

Role – Forms & Reports Developer.

Responsibilities:
  • Understanding the functional flow
  • Develop reports as requirement.
  • Resolved user-end problems and provided full system support in total flow after implementation.

Company: Confidential

Role – Forms & Reports Developer.

Responsibilities:
  • I design the total flow.
  • Developed Reports, Procedures and Triggers.
  • Resolved user-end problems and provided full system support in total flow after implementation

Hire Now