Amareswari Vemuru

Clients:

1. Weltman Welnberg & Reis Co.,LPA (Location: REMOTE From USA 08/2024-current)

2. Atlantic Health.org (Location: - Remote From USA 02/2024-08/2024)

3. Duluth Trading MLM (Location: - Remote From USA 09/2023 -02/2024)

Employer: Oxford Global Resources, LLC.

Responsibilities:

• Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
• Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
• Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
• Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
• Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Established standard procedures for version control, code review, deployment, and documentation to ensure consistency across the team''s work products.
• Leveraged advanced analytics tools to create interactive dashboards that provided actionable insights into key business metrics.

Tools:-MS Power BI , Power Bi Desktop Version:2.1 MS SQl Server, Management studio, Teams, GitHub, Tidal tools, and SQL server 2012, MICROSOFT, Business Intelligence Development, Teams, GitHub, Tidal tools, and SQL server 2012, Microsoft Business Intelligence Development Studio (MSBI). [SSIS]. Azure SQL Data Warehouse, Azure Data factory, Azure Dev-ops, Citrix, move IT.

Client:-ADOBE

• Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
• Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
• Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
• Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.
• Optimized data pipelines by implementing advanced ETL processes and streamlining data flow.
• Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
• Gathering Requirements and analysis and working with direct Business stakeholders.
• Created analytical reports and provided valuable and relevant business insights for internal and external clients.
• Cleaned and transformed data using Power BIs Query Editor to prepare ETL processes to optimize reporting datasets.
• Created data models and tables within Power BI to support efficient, optimized data warehousing and reporting workflows.
• Experienced in tuning long-running SQL queries using SQL server built-in tools like SQL Server profiler, Execution plan and creating indexes.
• Experienced with Power BI Incremental refresh.Provided technical or functional guidance to project or work teams as needed within a specific discipline.Collaborated on an on-going basis with the Business Systems Analyst.
• Developed and maintained Tableau and Power BI dashboards and reports to support business objectives, resulting in a 25% increase in data-driven decision making across the organization.
• Analyzed data from multiple sources to identify trends and insights, leading to the identification of a new customer segment and a 10% increase in revenue from that segment.
• Designed and implemented data visualizations to effectively communicate data insights, resulting in a 15% increase in user engagement with the dashboards.
• Written SSAS Tabular Cubes Dims and Facts to generate the Power BI Reporting using Live connections.
• DAX query for the Calculate YTD values in only reports.
• Collect stakeholder requirements, update BRD and estimate work to ensure timely project completion.
• To ensure complete source-to-target data testing, it is essential to perform manual testing using SQL queries. This process involves an in-depth examination of the data flow throughout the system to identify any discrepancies or errors. By conducting manual testing, we can thoroughly analyze the data and ensure that it accurately represents the intended source. This approach is crucial to guaranteeing the completeness and accuracy of the data, which is a critical factor in the success of any business or academic project.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, XML to MS SQL Server by using BCP utility, SSIS services.
• SQL Server 2005 RDBMS database development including T-SQL programming.
• Expertise in designing B2B data Exchange platform using ETL process. SQL Server 2005 OLAP database development including KPIs, Data mining, working with slow changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSRS on SQL Server (2005).
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture. Experience in creating SSIS packages for XML based Business to Business Data exchange using different types of tasks and with Error Handling and Reporting Capability.Configured the report server and generated the report models for user interactions.
• Configuration of Snapshot and Transactional Replication.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Experience in creating SSIS packages using different types of tasks and with Error Handling.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Generated dynamic stored procedures, xml stored procedures, triggers for the database development.
• Fine-tuned the complex database stored procedures and increased performance up to 7%.
• Experience in Database Mirroring, Database Snapshots.
• Taking weekly database backup and schedules job using SQL Agent.
• Involved in Backing up and restoring databases.
• I worked in OLAP Data warehouse Modeling, Design, and Implementation. I have experience Designing and Building Dimensions and cubes with star and snowflake schemas using SQL Server Analysis Services (SSAS).
• Create join s and sub-queries for complex queries involving multiple tables.
• Strong experience in migrating to other databases to snowflake.
• Develop SQL queries Snow SQL
• ETL Pipelines in and out of data warehouses using combination of python and snowflakes Snow SQL writing SQL queries against Snowflake.
• Have good knowledge in ETL and hands on Experience in ETL. Handling complex transactions and Data manipulation and data modeling, Data mapping.

Technologies Used: Hadoop, Azure Cloud, Azure Dev-ops, Azure SQL Data Warehouse, Tableau, Power BI and all SQL’s, , Microsoft Business Intelligence Development Studio , MSBI tools (SSIS, SSRS, SSAS), GitHub, GitHub, SAP HANA. Snowflake, Snow SQL, SnowpipeAWS.