Description
Professional summary * Seasoned information technology (IT) professional with eighteen years of experience in Analysis, Design, Coding, Testing, Migration, Production support and Implementation of Software applications. * Technical lead for large data conversion / migration projects of transforming data from legacy systems to enterprise AMS system including scope/requirement/effort analysis, defining mappings, setting transformation rules and modifying ETL routines for data transformation. * Expertise in designing of Data Warehouse solutions using dimensional data modeling and development of STAR / SNOWFLAKE schemas (Kimball). * Expertise in designing ETL architecture and developing ETL Processes for Data warehouse, Data Integration, Data conversion and Data Migration projects. * Strong requirement and business analysis skills and ability to translate business and data requirements into a logical and physical data mode. * 10+ years of hands-on experience in Logical / Physical Data model design. * 8+ years of experience in specialized focus in BI / Data Warehouse / Data Management area, Enterprise data warehouse design, DataMart design, Metadata, Data quality, Data profiling, Master Data Management and Data Governance. * 5+ years of hands on experience using Business Objects BI suite of products including BODS, Universe Designer, Dashboard Designer, WEBI reporting tool, SSRS and SSAS. Design, development and support of Business Objects Universes, WEBI intelligence and dashboard development. * 3 years of hands on experience building SSIS ETL packages and Tableau dashboards using multiple data sources.