Naga Veera Pavan Kumar Pusarapu

ADF Developer BI Developer

+1-647-***-****

ad4l5r@r.postjobfree.com 30 Denton Avenue, Scarborough

SUMMARY

Experienced and results-driven Microsoft Business Intelligence and SQL Server professional with over 10 years of hands-on experience. Skilled in designing ETL solutions and packages in SSIS, proficient in Visual Basic and C#, and experienced in SSIS, SSAS, SSRS, SSMS, and SQL queries. Azure Data Factory professional with 2 years of hands-on experience in designing, implementing, and managing data pipelines in Azure Data Factory.

EDUCATION

Jawaharlal Nehru Technological University

Bachelor of Engineering in Information Technology, Hyderabad, India.

SKILLS

Proficient in Microsoft Business Intelligence and SQL Server

Experienced in designing ETL solutions and packages in SSIS

Proficient in Visual Basic and C#

Experienced in SSAS, SSMS, and SQL queries

Expertise in data analysis

Strong knowledge of MS Excel and MS Access, including VBA

Proficient in Performance Tuning and Optimization of stored procedures, functions and ad-hoc SQL queries.

CERTIFICATIONS

Microsoft Certified Professional in SQL Server 2012.

Microsoft Certified Professional in Azure Fundamentals.

TECHNOLOGIES

ETL Tools: SSIS,ADF

Languages: T-SQL, PL/SQL, SQL. Framework: .Net

OS: UNIX, Linux, and Windows.

Database: SQL Server, Oracle and MS Access.

Tools: SSAS and SSRS.

PROFESSIONAL EXPERIENCE

SSIS/SQL Developer

TD Securities(Contract) Nov 23- Mar 24

Designed and implemented ETL solutions and packages in SSIS to optimize data extraction, transformation, and loading processes.

Utilized Visual Basic and C# to enhance BI functionality and automate repetitive tasks.

Improved SQL queries performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.

Data warehouse Developer

Toronto Transit Commission(Contract) Oct 2020 - Nov 2023

Designed and implemented data pipelines in Azure Data Factory to efficiently move and transform data from diverse sources to target destinations.

Integrate Azure Data Factory with other Azure services such as Azure Blob Storage, Azure SQL Database, Azure Synapse Analytics, and Azure Data Lake Storage Gen2.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server Integrations Services (SSIS).

Developed T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, CTE, DML and DDL. Improved SQL queries performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.

Heavily used Excel data source and handled large sets of data which included 1400 columns.

Extensively used ETL SSIS for the Extraction, Transformation and Load of source data which was from SQL Server, XML, Excel, Web service and Flat Files

·

BI Developer

GoWeb Mar 20- Apr 20

Developed T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, CTE, DML and DDL.

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server Integrations Services (SSIS).

Team Lead

Accenture India Aug 15- Jan 20

Gather requirements and design of data warehouse and data mart entities.

Implemented performance of SSIS packages from more than 7+ Hours to less than 2 Hours by tuning the SQL queries and creating indexes and partitions on the tables by identifying bottlenecks and used Breakpoints.

Developed database objects like tables, views, indexes, stored procedures, common table expressions, functions, triggers, views, cursors, indexes, Joins and Sub queries with T-SQL. Generated reports like Drill-Through, Linked and Sub-Reports using SSRS

Designed and developed interactive dashboards in SSRS.

Software Engineer

PRODAPT, India May 15- Jul 15

Developed dashboards from multiple data sources SQL Server, flat files, excel using SSRS.

Developed various operational Drill-through and Drill-down reports using SSRS.

Software Engineer

Technosoft Solution, India May 14- Apr 15

Involved in data modeling and followed star schema data model approach.

Built efficient SSIS packages for processing fact and dimension tables with type 1 and type 2 changes.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.

Software Engineer

Wave9 IT Solutions, India Jan 12- Apr 14

Developed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Migration of DTS packages to SSIS packages.

Create and maintain SSRS Monthly Summary Reports for clients.

ACCOMPLISHMENTS

·Timely delivery of HEDIS Measures to NCQA on behalf of the client to avoid penalties.

·Recognized as a SME, collaborated with management and made architectural decisions for the key solutions.

·Leadership Role: Mentored, Knowledge Transferred on tools and technologies to the entire team.

Received star of the month award in Accenture.

Contact this candidate