Raj Patel

I am Microsoft certified with 4+ years’ experience in database design, development and administration in SQL Server 2016 to 2019. I have worked on SQL server products like SSIS, SSRS, DW.

While working on T-SQL

• I have designed and developed databases from scratch based on functional requirements. I have created all database objects using my TSQL skill set like tables, constraint, Index, Views, functions, triggers, stored procedures etc.
• I have used Join, Sub query, Derive table, Temp table, variable, Merge, Union, Union All, Except, Pivot, Un-Pivot, CTEs, Dynamic SQL, Cursor etc in my T-SQL scripts.
• For the Performance Tuning, I have analyzed actual and/or expected query Execution plans, updated statistics, Alter the indexes and rewrite the code for better logical and physical reads.
• I have used Query Analyzer, SQL server Profiler, Database engine tuning advisor for performance monitoring of the operational databases.

• I have created tons of ETL packages, to backup and migrate the data from one server to another server, to extract the data from multiple files like flat file/Excel file, used different transformation based on business requirements and load the data into the data warehouses.
• While developing the ETL, I have used various control flow, data flow items like, 
• In control flow I have used containers that provide structures in packages, tasks that provide functionality, and precedence constraints that connect the executable containers and tasks into an ordered control flow. 
• In data flow, I have worked with different Sources like OLEDB, Flat file, Excel file, Different transformation like Conditional split, Copy column, Derive column, Data Conversation, Merge, Sort, Multicast, UnionAll, Lookup & Different Destinations like OLEDB, EXCEL, SQL SERVER.
• I have designed SSIS Template package for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments by just creating Configuration files.
• I also have Implemented Event handling, Error Handling, logging; used Checkpoint, BreakPoint & have experience of Deploying, Scheduling, Monitoring and Maintaining SSIS package execution. 

• I have developed various types of reports like Tabular, Matrix, List & Chart, Parameterized reports, Sub reports, Drill down reports, interactive reports according to requirements and manage them using SQL Server Report Manager.
• I have generated reports using Global Variables, Expressions and Functions. 
• I also have work on configuration of Report Server,Report Manager, Report scheduling, & give permissions to different level of users in SSRS. 

• I have Experience in Installing SQL Server 2016 to 2019 and configuration of their tools. 
• Strong experience in Database Maintenance, Monitoring, Backup and Recovery procedures and Replication.
• Responsible for Security Administration-Have create users and assigning them roles and privileges.
• Used DBCC (Database Console Command) commands and Dynamic Management Views for monitoring and maintaining Database health and consistency.
• Involved in creating Jobs, Alerts, SQL Mail Agent.

• I have Knowledge in designing and developing Data Warehouses, Data marts and Business

  Intelligence solutions using multi-dimensional models such as Star Schemas and Snow Flake Schema.

• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• I also have experience in Create and maintain indexes of OLAP/Datawarehouse databases to scale up or meet the performance requirement.

• Updating existing reports, adding report pages, altering, upgrading and formatting visuals and preparing slices for new information provided.

I am Microsoft certified with 4+ years’ experience in database design, development and administration in SQL Server 2016 to 2019. I have worked on SQL server products like SSIS, SSRS, DW.

While working on T-SQL

• I have designed and developed databases from scratch based on functional requirements. I have created all database objects using my TSQL skill set like tables, constraint, Index, Views, functions, triggers, stored procedures etc.
• I have used Join, Sub query, Derive table, Temp table, variable, Merge, Union, Union All, Except, Pivot, Un-Pivot, CTEs, Dynamic SQL, Cursor etc in my T-SQL scripts.
• For the Performance Tuning, I have analyzed actual and/or expected query Execution plans, updated statistics, Alter the indexes and rewrite the code for better logical and physical reads.
• I have used Query Analyzer, SQL server Profiler, Database engine tuning advisor for performance monitoring of the operational databases.

• I have created tons of ETL packages, to backup and migrate the data from one server to another server, to extract the data from multiple files like flat file/Excel file, used different transformation based on business requirements and load the data into the data warehouses.
• While developing the ETL, I have used various control flow, data flow items like, 
• In control flow I have used containers that provide structures in packages, tasks that provide functionality, and precedence constraints that connect the executable containers and tasks into an ordered control flow. 
• In data flow, I have worked with different Sources like OLEDB, Flat file, Excel file, Different transformation like Conditional split, Copy column, Derive column, Data Conversation, Merge, Sort, Multicast, UnionAll, Lookup & Different Destinations like OLEDB, EXCEL, SQL SERVER.
• I have designed SSIS Template package for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments by just creating Configuration files.
• I also have Implemented Event handling, Error Handling, logging; used Checkpoint, BreakPoint & have experience of Deploying, Scheduling, Monitoring and Maintaining SSIS package execution. 

• I have developed various types of reports like Tabular, Matrix, List & Chart, Parameterized reports, Sub reports, Drill down reports, interactive reports according to requirements and manage them using SQL Server Report Manager.
• I have generated reports using Global Variables, Expressions and Functions. 
• I also have work on configuration of Report Server,Report Manager, Report scheduling, & give permissions to different level of users in SSRS. 

• I have Experience in Installing SQL Server 2016 to 2019 and configuration of their tools. 
• Strong experience in Database Maintenance, Monitoring, Backup and Recovery procedures and Replication.
• Responsible for Security Administration-Have create users and assigning them roles and privileges.
• Used DBCC (Database Console Command) commands and Dynamic Management Views for monitoring and maintaining Database health and consistency.
• Involved in creating Jobs, Alerts, SQL Mail Agent.

• I have Knowledge in designing and developing Data Warehouses, Data marts and Business

  Intelligence solutions using multi-dimensional models such as Star Schemas and Snow Flake Schema.

• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• I also have experience in Create and maintain indexes of OLAP/Datawarehouse databases to scale up or meet the performance requirement.

• Updating existing reports, adding report pages, altering, upgrading and formatting visuals and preparing slices for new information provided.

I completed a Bachelor of Engineering in Information Technology in 2019. Throughout my graduation journey, I have worked on many projects that helped me to hone my skills. I did an internship in the final year of my graduation which gave me professional and practical experience. I am always open to learn new technologies and keep updating my skills according to the market requirement.