Description
Experienced with logical, physical, and dimensional data modeling, data mapping, data normalization, and building Referential Integrity Constraints. Efficient in creating Transact SQL (DDL, DML, DCL), Indexed, Views, Stored Procedures, CTE, Recursive CTE, Joins, Pivot, User Defined Functions to facilitate efficient data manipulations and consistent data storage. Experienced in ETL cycle including data analysis, data cleansing, database design, data mapping, data conversion, and data load. Excellent in using transformations such as Aggregate, Lookup, Fuzzy Lookups, Conditional Splits, Copy column, Export Column, Pivot, Cache Transformation, CDC Splitter, Data conversion, and other necessary transformation tasks in SSIS packages. Expert in SQL Server 2008/ 2008R2 OLAP database development, including KPI's, Data mining, and Slowly Changing Dimensions (SCD). Resolved SQL Reporting Services issues and Proficiency in creating different types of reports such as conditional, drill-down, drill-through, matrix, tabular, and sub reports. Created and deployed SSRS reports from SSAS cubes and various data sources on the portal for the user accessibility. Involved in database development, RDBMS i.e. MS SQL Server, Oracle PL/ SQL, T-SQL, Query optimization, Performance tuning, Store Procedures, Views, Materialized view, partitioning, facts and measures, OLAP, HOLAP, MOLAP, ROLAP, cubes, Data Warehousing. Good knowledge of Datasets, Data Marts, Data Warehousing (EDW), Fact and Dimension Data Modeling, Star Schema Modeling, Snow - Flake Modeling. Proficient in data migration from multiple data sources to single coded database destination. Experience in Data Migration from SQL Server 2005 to 2008, 2008 to 2012, Oracle 10g/ Business Object (BO), MS Excel to 2008R2/ 2012 SQL Server to Oracle Migration operation. Excellent problem solving, analytical, technical, interpersonal, and communication skills with strong leadership abilities. Extremely diligent, strong team player with an ability to quickly adapt to new roles.
Accomplishments
Highlights:
Keywords
