• 10 years of experience in analysis, design, development, implementation and production support in areas of Database, ETL, and analytics using ER Studio, SAS, OLAP and Report Development.
• Extensive knowledge of relational and dimensional data model, star schema and Snow Flake schema and Kimball Methodologies.
• Expertise in developing Conceptual, Logical and physical data models and maintaining it with version control
• Proficient in translating user requirements to physical data model, generate data definition language using ER Studio CASE tool.
• Experience designing Geographical Information System database tables to be compatible with map layers using SDO and SDE
• In depth knowledge of Dimension tables, Fact and summary tables, slowly Changing Dimensions, Conformed Dimensions, and Metadata.
• Experienced developing multi star schema with secondary dimension tables.
• In depth knowledge of database concepts Entity relationships, Database constraints, data types.
• Expertise in designing and developing Enterprise Information and Content Architecture Models.
• Experienced in collaborating with application teams and database administrators and design the optimal solution to fit the requirements
• Expertise in data analysis and reporting using advanced Excel features like Pivot table, charts, VLookups, macros, formula auditing and data validation.
• Proficient in using SAS Enterprise Miner and IBM SPSS for Predictive Analytics.