Data Modelling, Analysis Resume Memphis TN - Hire IT People

SUMMARY:

11 years of experience in Data Modelling, Analysis, Design and Development of Data warehousing with extensive knowledge in Informatica, Oracle, OBIEE, BIAPPS.
Worked in various databases Oracle, DB2 & MS SQL.
Experience in ODI, OBIEE reporting tool & Informatica Data quality (IDQ).
Experience in scheduling tools - DAC, Autosys and Control-M.
Excellent analytical and problem solving skills.
Worked on all phases of data warehouse development lifecycle, from requirements gathering to analysis, design, development, testing and support

TECHNICAL SKILLS:

Databases: Oracle 11g/10G/9.i SQL server 2005/2000 IBM DB2

Tools: BIAPPS 7963 & 7964 Informatica Power Center 9/8/7 ODI 11.1.1.5.0 DAC Informatica Data Quality (IDQ) 8.6 OBIEE 11g, RPD Modelling Tableau Cloud Hadoop

Platforms: Windows 2000/ 98/95/XP Unix

Scripting: PL/SQL SQL

PROFESSIONAL EXPERIENCE:

Confidential, Memphis TN

Responsibilities:

Interaction with business representatives for requirement analysis
Requirement analysis and design the ETL, RPD & Reports
Data modelling of Lease, Contract, Clear & Request Module.
Designed & Developed the ETL mappings & DAC Metadata.
Managed the team in all the development efforts which include ETL, RPD, Report, DAC and Database changes.
Performance tuning of Informatica mappings and session
Actively involved in testing strategy and execution

Environment: BIAPPS 7964, Informatica 9, Oracle 11g, OBIEE 11, DAC, IBM Tririga

Confidential, Miami, Florida

Responsibilities:

Interaction with business representatives for requirement analysis, to define functional specifications
Designed & Developed the ETL & DAC metadata for the Fixed Assets & Sub Ledger module for Real time.
ETL, RPD, Reports & DAC customization following the BI Apps standards
Designed and implemented RPD changes for Performance tuning of Informatica mappings and session
Actively involved in testing strategy and execution during SIT & UAT

Environment: BIAPPS 7964, Informatica 9, Oracle 11g, OBIEE 11, DAC

Confidential

Responsibilities:

Managed the offshore team in all the development efforts.
Analysis of comparing keys for EBS R11 and R12 sources
Created design documents for ETL changes
Developed & tested Procedures to delete duplicate records
Developed & tested ETL mappings and DAC metadata.
Performance tuning of the Procedures
Fixed bugs during UAT

Environment: BIAPPS 7963, Informatica 9.0.1, Oracle 10g, R11 EBS, R12 EBS, DAC

Confidential

Responsibilities:

Lead the offshore team in all the development efforts.
Designed & Developed the Data Model, ETL and DAC metadata for the & Survey module.
Developed & tested custom mappings following the BI Apps standards.
Performance tuning of the Informatica mappings
Developed & tested reports for module
Fixed bugs for, Survey & HR Module during the UAT phase.

Environment: Informatica 8.6, Oracle 10g, People Soft 9.0, TOAD, OBIEE 10.1.3.4, DAC

Confidential

Responsibilities:

Requirement gathering for design phase from users
Design & build efficient Informatica mappings and workflows for processing fact and dimension tables with complex transformations.
Performance tuning of the Informatica mappings.
Unit Testing of Mappings and created Test plans.
Active member during UAT phase of project

Environment: Informatica 8.6, Oracle 10g, Oracle SQL Developer, DB2, Autosys, Unix, Filezilla.

Confidential

Responsibilities:

Requirement gathering for design phase from clients
Design, development and testing of Mappings & Workflows in Informatica, Procedures & Packages in Oracle
Created numerous mappings which do previous/next row processing, type 1& type 2 dimensions
Built efficient Informatica mappings for processing fact and dimension tables using major transforms such as source qualifier, lookups, normalizer, joiner, aggregator, update strategy, router, filter
Presentation of design document & code to Client
Lead the team
Performance tuning of the Informatica mappings.
Unit Testing of Mappings and created Test plans
Fixed the bugs raised by the QA team.

Environment: DWH, Informatica Power Center (8.6), Oracle, TOAD

Confidential

Responsibilities:

Legacy Systems Data Analysis, Cleansing, Standardization, Parsing and De-duplication using Informatica data Quality (IDQ)
Reporting the Data Quality
Environment: Informatica (8.6.1), Informatica Data Quality (IDQ), Oracle, DWH, TOAD

Environment: DWH, Informatica (7.1.1), MSSQL, Control M, Batch File, TOAD

We provide IT Staff Augmentation Services!

Data Modelling, Analysis Resume

Memphis, TN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship