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
