Swetha Chopperla

• Led design and development of centralized analytics warehouse in Snowflake to integrate data and build enterprise model.
• ·Managed Snowflake Analytics & SQL Server operational warehouse to ensure optimal performance, security, and cost-efficiency of the company's data platform.
• Designed scalable and maintainable data models using dbt to support business intelligence initiatives and reporting needs in PowerBI,Quickbase.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Collaborated with cross-functional teams for seamless integration of data sources using Fivetran, AWS-S3, DBT and Microsoft SSIS into our analytics ecosystem(Snowflake & SQL Server).
• Profiled data movement from different databases like Bigquery, Pendo, SQL Server, Salesforce to our central analytics snowflake warehouse.
• Built and developed efficient models to convert raw data into structured datasets in our enterprise model using DBT along with unit testing and code documentation.
• Migrated legacy systems(On premise SQL Server) to AWS, improving performance and scalability while minimizing business disruption.
• Developed pipelines between SQL Server and various other on-premises databases or cloud databases via Microsoft BI stack (SSIS).
• Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
• Worked on Technical documentation for different projects, interacted with business analysts and users to gather requirements in preparing technical documents for applications.

• Worked on numerous integration processes in Microsoft SSIS/Python to ensure proper stewardship of ETL environment.
• Assisted several teams as data expert by providing metric analysis using Power BI and SSRS reports.
• Optimized existing SSIS Packages embedded in current ETL system on SQL Server and automated BI reports for secure virtual server environment.
• Additionally, I have increased collaboration between departments by facilitating cross-functional discussions on shared metrics and KPIs.
• Evaluated emerging BI technologies and methodologies, recommending appropriate additions or improvements to existing systems.

• Monitored and optimized SQL server performance and its ETL processes.
• Worked and utilized Microsoft BI tools in facilitating metrics and KPIs to internal teams in the org.
• Directed implementation of new business intelligence tools, selecting appropriate solutions.

• Enhanced database performance by optimizing SQL queries and indexing strategies.
• Designed and developed customized extract, transform and load (ETL) applications per client specifications.
• Analyzed existing SQL queries to identify opportunities for improvements.
• Participated in regular status meetings with project stakeholders to provide updates on progress and address any concerns or feedback promptly.

· Created Numerous SSISpackages for business Design Applications Using Business Intelligence Studio. Worked in Extracting the flat files excel files and csv files into SQL SERVER Tables.

· Designed and created SQLSERVER 2008R2/2012 Database tables, indexes, and views.

· Created Cubes in SSAS on OLAP Databases and generated reports using SSRS from SSAS Cubes.

· Worked on Performance Tuning of the SQL Queries and experience in analysis of Execution Plans for better performance.