Anna Joyce Email & Phone Number

Rhode Island, United States

• Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
• Loading data into snowflake tables from the internal stage using snowsql.
• Used COPY, LIST, PUT and GET commands for validating the internal stage files.
• Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).
• Writing complex snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
• Used FLATTEN table function to produce a lateral view of VARIANT, OBJECT, and ARRAY column.

Dallas, Texas, United States

• Highly Proficient in T-SQL programming and vast experience in creating complex stored procedures, triggers, views and user defined functions on SQL 2012/2008 R2/2008 servers to meet the requirement of the applications.
• Performed Partitioning and Index Tuning by taking into consideration Internal and External Fragmentation levels according to the Microsoft's best practices.
• Understanding of SQL, PL/SQL and Relational Database queries in ORACLE
• Advanced SQL and PU/SQL programming Automated the administrative tasks using SQL Server Agent, event notifications, and scheduled maintenance plans according to Microsoft best practices.
• Supported the migration of data from Heterogeneous Sources and different formats to relational data warehouses, staging databases using complex Stored Procedures, SIS packages as well as command prompt scripts.
• Performed extensive GAP analysis in the project as there were numerous 'As-ls' and 'To-Be' conditions.

North Carolina, United States

• Participated in client business need discussions and translating those needs into technical executions from a data standpoint.
• Translated business requirements into B application designs and solutions.
• Assisted in the definition of the database requirements; analysed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic also created clustered and non-clustered indexes.
• Involved in performance monitoring, tuning, and capacity planning.
• Tuned the slow performance queries by looking at Execution Plan

• Specialized in data mining, data modeling, and data manipulation, ensuring data quality assurance throughout the data extraction process to provide valuable insights and predictive analytics.
• Effectively managed project tasks and client requirements using JIRA, overseeing issue tracking, fostering team collaboration, and diligently resolving any encountered bug issues.
• Increased customer retention rates through the development and execution of SQL queries to extract and analyze customer data, resulting in a 10% increase in customer retention rates.
• Work as an SQL/Java Developer and establish strong relationships with end users and technical resources throughout established projects
• Work closely with the development team to provide support for database objects (stored procedures/triggers/views) and performing code review
• The SQL Server Developer will work closely with Application Developers to ensure proper design and implementation of database systems