Sireesha A

Software Engineer @Vstack.Dev

Toronto, ON, CA

Modify the data using derived column and fulfill the customer needs. Migrate the data from Source to Target.Validate the data once it gets migrate to the target database. Prepare the SQL queries and verify data got migrated successfully to the target.Developing SSIS ETL packages and SQL scripts for process data into the bigdata system.Create the jobs to run the packages for provide the environment variables for 3 servers like Dev, QA and Pre-production.Monitor the jobs and fix the issues if any of the job fail during the job run.Working with business to get the requirements and work on TechnicalDesign document.Migrating data from multiple source systems such as SQL Server, Oracle toand file system for data analysis.Created complex transformations in ETL processes to load data from multiplesources into the data warehouse and ensured that all business requirementswere met.Coordinating various meetings with business users and stakeholders forrequirement gathering.Performance tuning for ETL code, stored procedures and SQL query optimizationand process automation.Track all the tasks through Jira to provide an updates to the BA and project manager.Using the ALM software to monitor the work progress and send the SSIS packages tracking to the production.Build the Power BI table, Matrix and graph charts for the business forecast.Pull the data from SQL Server, Azure Databricks, snowflake, Oracle into Power BI desktop and made required report and prepare the Power BI reports.Each department we have build specific Bar and Pie charts based upon the requirement and published into the production.

Jawaharlal Nehru Technological University

Bachelor's degree, Computer Science

Northeastern University

Project Management