Raj Patel

Sql Developer Dw Developer Ssis, Ssrs, Bi, Etl Developer @Scotiabank

Toronto, ON, CA

Worked on performance tuning & query optimization. • Worked extensively on SSIS & SSRS and created scripts in SSIS for data movement. • Working along with BA’s to understand the Requirements from Business Analysts, Users and converting the Business requirements into Technical Specifications. • Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, SQL, EDL). • Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse. • Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all. • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into landing zone and from landing zone to data marts. • Work closely with stake holders to understand the report requirements on different KPI values. • Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs. • Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database. • Design and develop dynamic advanced T-SQL, stored procedures, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SQL Server Agent jobs, deployment scripts. • Created and modified various Stored Procedures used in the application using T-SQL. • Scheduled and maintained packages daily, weekly, and monthly using SQL Server Agent in SSMS. • Managed Dev, IST, UAT and Prod environment for deployment. • Worked on automating SQL Server processes using SQL Agent Jobs and set up a PowerBI data refresh to produce daily report.

Gujarat Technological University, Ahmedbabd

Bachelor of Engineering - BE, Information Technology, Distinction