Rss

Evalinn P

Datawarehouse Designer - 20 Years of Experience - Near anywhere

Occupation:

Datawarehouse Designer

Location:

Holyoke, MA

Education Level:

Some College Units Completed

Will Relocate:

YES

CollapseDescription

Summary * IT professional with 15+ years of expertise in Data Modeling, Data Analysis for Online Transaction Processing (OLTP), Data Warehousing (OLAP)/Business Intelligence (BI) applications * Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data Warehousing environments. * Dimensional Data Modeling, Building Star and Snowflake schemas, Canonical modeling, OLAP tools. * Proficient in creating Conceptual, Logical and Physical Data models as per the client project requirements. * Performance tuning for Teradata, Microsoft SQL Server, Informix, and DB2 * Excellent analytical skills and problem solving techniques as a data modeler. * Experienced in Normalization/Denormalization techniques for optimum performance in OLTP and OLAP environments * Knowledge and experience in the Teradata development tool set (Including multiple SQL utilities). * Knowledge of Apache Hadoop. * Knowledge of string up Teradata Bar solution. * Knowledge and experience with Teradata Aprimo. * Experience with Teradata utilities such as Fast Export, MLOAD for handling various tasks. * Hands on experience with creating cubes using SQL Server Management Studio 2000, 2005, 2008 R2 and 2012 / 2014 analysis and process modeling (JAD) structured development methodologies. * Knowledge and experience of designing and implementing dashboards using various reporting tools like idashboards, SSRS and Business Object. * Expertise in ETL tools like Informatica, Business Object and SSIS Created source to target mapping documents for the ETL developers and helped them understand complex transformations involving business input. * Knowledge and experience with slowly changing dimensions.

Right_template4_bottom

CollapseAccomplishments

Highlights:

Left_template4_bottom

CollapseJob Skills

Left_template4_bottom

CollapseKeywords

Left_template4_bottom