VENU GOPAL

 

 

SUMMARY:                                                                                                                                                                                           

4+ years of professional experience in IT industry, involved in data projects with extensive usage of SQL Server and ETL tool -SQL Server Integration Services (SSIS).

• Worked Extensively on SSIS and SQL –Server to extract the data from various data sources.

 

• Experience in Creating SQL Objects–Tables, Constraints, Views and Procedures.

 

• Having good experience in using all types SQL Server objects such as Tables, Constraints, Views, Indexes, Functions and Procedures.
• Experience in using Temp tables and Common Table Expressions to hold the data temporarily while processing the data between various layers of data warehouse
• Experience in using Transactions, Try and Catch blocks in Stored procedures
• Experience in using SSIS Tasks, Containers and Transformations and Event Handlers.

 

• Experience In Configuring Packages, Transactions and Logs.
• Creation of workflows with Dataflow Task, Execute SQL Task and Containers.

 

• Used various SSIS Transformations such as Derived Column, Conditional Split, Aggregates, Sort, Data Conversion, Merge join , Union all and Lookup
• Experience in Creating jobs and Scheduling SSIS Packages.

 

Qualification:                                                                                                                                                                                        

Bachelor of Technology (IT) from JNTU, 2014

Experience Summary:                                                                                                                                                                        

 

• Working as a Senior Software Engineer