Occupation:Datawarehouse Designer |
Location:Holyoke, MA |
Education Level:Some College Units Completed |
Will Relocate:YES |
Description
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.
Accomplishments
Highlights:
Job Skills
Keywords
