SYSTEMS ENGINEER Resume

SUMMARY:

Involved in various phases of Software Development Life Cycle i.e. Requirement Analysis, Design, Development and Implementation of Client Server applications using different database technologies.
Good Knowledge in Data Warehousing concepts including Meta data and Data Marts.
Expert in writing SQL Queries and analysis of the data patterns.
Strong knowledge and understanding in OLTP, OLAP Data warehouse and Business Intelligence modeling.
Strong team - oriented interpersonal, analytical and problem-solving skills.
Ability to effectively adapt to rapidly changing technology and apply it to business needs.
Extensive experience on Excel, Word, PowerPoint, MS Project, and MS Visio.

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP/Vista/7

Languages: Core Java, SQL

Database: SQL Server 2008, Oracle, Teradata

Software Packages: MS-Office, MS- Excel, MS -Access

Scripting Languages: Linux

PROFESSIONAL EXPERIENCE:

Confidential

SYSTEMS ENGINEER

Roles & Responsibilities:

Worked with the Data Modelers and the Business source system experts in analyzing the reporting requirements.
Involved in the data profiling activities for the column assessment and natural key study.
Identified and resolved data related issues.
Performed Data Mining to analyze the patterns of the data sets.
Developing data validation and file validation rules for application.
Developed Data quality completeness and policy rules for the application and ETL team to cleanse and transform the data.
Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.
Worked on source to target mapping between source and target data model for ETL team
Extensively used SQL to verify that data has been moved from transactional system to Data warehouse reporting system in accordance with requirements.

Environment: ER Studio, Data Stage, Teradata, Oracle, Flat Files, Teradata SQL Assistant, MSSQL Server, Micro Strategy.