Data Modeler, Datastage Developer Resume

CAREER OBJECTIVE:

To excel in the professional career as a good Software professional with constant learning, contributing and growing along with the organization.

SUMMARY:

8 years of working experience
Thorough knowledge and work experience in Telecom domain
Data Modeler experience with strong Conceptual and Logical Data Modeling skills, creating data mapping documents, writing functional specifications and complex SQL queries.
Experience in Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using data modeling tool ERWIN.
Extensive experience in writing functional specifications, translating business requirements to technical specifications
Onsite experience at client site - Telstra, Australia
Experience in analyzing the business requirements and performing pre-feasibility analysis and initial analysis.
Proficient in Development, Implementation and Support of ETL processes for Large-scale Data warehouses using Datastage and Teradata.
Extensive knowledge in all areas of Project Life Cycle including requirements analysis, system analysis, design, development, documentation, implementation and maintenance.
Effective communications/presentation skills for technical and non-technical audiences.

PROFESSIONAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Data Modeler, Datastage Developer

Responsibilities:

Involved in the PDM and LDM team as a Data Modeler.
Involved in discussions with business stakeholders to understand their requirement.
Responsible for analyzing business requirements and performing pre-feasibility analysis and impact analysis for a future change request.
Involved in designing logical data model based on analysis of the requirement and feasibility analysis
Design the physical data model based on logical data model, query performance and source data size.
Design and create new tables and views based on requirements provided.
Analyze and profile the source data flowing into these tables for making the design decisions.
Design the ETL specifications sheet based on the rules in the data model.
Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded
Involved as a Datastage developer
Create/modify jobs as per the requirements for critical interfaces.
Create/modify Mload and Bteqs to help load data as per ETL specifications.

Confidential

Data Modeler

Responsibilities:

Involved in the design team as a Data Modeler
Discuss with all stakeholders and business analyst to understand existing process
Design conceptual and logical data models based on the requirement
Design and create tables and/or views in the physical data model by analyzing different access and join criteria.
Analyze and profile the source data flowing into these tables for making the design decisions.
Design the ETL specifications sheet based on the rules in the data model.
Reviewing of physical data model design deliverables and ETL specifications sheet.
Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded

Confidential

Data Modeler and Business Analyst

Responsibilities:

Involved in the team as a Data Modeler and also a business analyst
Involved in analyzing existing mapping documents and recreating them for new Hadoop platform
Comparing existing datatypes and finding the appropriate datatypes in Hive
Analyze loaded data and identify the root causes of issues if any

Confidential

Data Modeler

Responsibilities:

Involved in the PDM team as a Data Modeler
Design enhancements in the physical data model based on logical data model
Design and create tables and/or views in the physical data model by analyzing different access and join criteria.
Analyze and profile the source data flowing into these tables for making the design decisions.
Design the ETL specifications sheet based on the rules in the data model.
Reviewing of physical data model design deliverables and ETL specifications sheet.
Analyze root cause and data loaded in the data warehouse, and provide solution to issues with the data loaded/to-be loaded
Involved as a Datastage developer
Create/modify jobs as per the requirements specified in ETL specifications sheet.
Troubleshoot these jobs in case of any issues like jobs failing, or loading wrong data etc.