Chetan Kumar Patel
Sql Bi Developer Datawarehouse Developer (Contract) @Santander UK
Signup · Get unlimited contacts
WORK HISTORY
Sql Bi Developer Datawarehouse Developer (Contract) @Santander UK
Milton Keynes, GB
Created SSIS packages for PPI, FOS, SOLIX data integration and automation.• Developed, deployed and monitored SSIS packages for new ETL process and upgraded existing DTS packages to SSIS for the on-going ETL processes.• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.• Monitored Full/Incremental/Daily loads and support all scheduled ETL jobs.• Developed SSIS packages for SSAS cube processing. Handled incremental/Full process for cube partitions, process add and process update for dimensions• provided Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages• Scheduled jobs to execute SSIS packages which were developed to update database objects and maintain nightly loads of data by creating the correspondence tasks.• Involved in designing, developing, deploying and testing of Power BI and SSRS reports• Created SSRS reports and Power BI visuals for Customised and adhoc queries• Designed and developed various types of reports like drill down, Parameterized, Cascading, Tabular, Matrix, Chart, Linked Reports and Sub Reports• Developed SSRS report using MDX queries for SSAS cubes.• Automated SSRS report Delivery (data driven subscription) to the Management and partners.• Involved in Analysing, Designing, Building and Testing of OLAP cubes with SSAS• Developed tabular models in SSDT for analytic reporting as well as aggregated data reports.• Developed complex calculated measures using DAX• Enrolling users and maintaining system security, created users/logins, specified users and users access level for each segment of database• Worked on testing of databases (Dev, Test, Prelive and Live), query optimization and performance• Monitoring, optimising and troubleshooting SQL Server Performance• Tuned the SQL queries using Database Engine Tuning Advisor.
EDUCATION
Hemchandracharya North Gujarat University
Master of Computer Applications - MCA, Software Development
Leeds Beckett University
Doctor of Philosophy (PhD), Agile Methods
SKILLS
ABOUT CHETAN KUMAR PATEL
Expertise in T-SQL, SSIS, SSAS, SSRS, MDX, DAX, CRM data integration, Power BI, SQL AzureIn depth working experience in SSIS Package creation, Checkpoints implementation, Dynamic Configuring of package, Logging, Custom script writing, Package deployment, and Implementing Transactions Excellent working experience in Data warehouse applications, directly responsible for the Development, Extraction, Transformation and Loading (ETL) of data from multiple sources in to data warehouseExperience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS PackagesExperience in Performance Tuning in SSIS packages by using Blocking, Semi-Blocking and non-blocking TransformationsIn depth proven experience in report writing using SSRS, Power BI and creating various types of reports like drill down, Parameterized, Cascading, Tabular, Matrix, Chart, Linked Reports and Sub ReportsExperience with report authoring, report management, report delivery and report security. Expertise in SQL server analysis services (SSAS) cube design, development and Deploying.Experience in working with SSAS in creating Cubes, Data Source Views, Named Queries, Dimensions and deploying of analysis services projects.Optimized large cubes by creating partitions, and using proper storage modes like MOLAP, HOLAP, ROLAP.Experience on performing data loads to Dimension, Fact tables, Data Warehouse and Cubes.Experience in writing MDX, DAX queries while creating and customising Cubes using SSAS.Experience in Dimensional modelling, Star and Snow Flake Schema.Extensive experience in installation, upgrade, configuration and maintenance of SQL Server 2005/2008/2012/2014/2016 and SQL AzureExperience in Designing and implementing backup/recovery plans.Experience in creating jobs, schedules, and maintenance plans.Experience in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers and UDF.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.