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.• Used SNOW PIPE for continuous data ingestion from the S3 bucket.• Developed snowflake procedures for executing branching and looping• Created clone objects to maintain zero-copy cloning.• Design and implement data models that meet business requirements.• Develop and maintain database schemas, tables, views, and stored procedures in Snowflake.• Transform and preprocess data to meet business needs using SQL, scripting languages, or data transformation tools.• Data validations have been done through information_schema.• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake• Experience with AWS cloud services: EC2, 53, EMR, RDS, Athena, and Glue• Cloned Production data for code modifications and testing● Work alongside executive leadership, project managers, software engineers, application developers and end users to develop solutions to common needs in various parts of the organization● Participate in disaster recovery protocols, including the development and execution of plans● Perform database administration including monitoring and management.● Create ETL pipelines to extract data from various sources, transform it, and load it into Snowflake.● Develop and maintain data integration workflows using tools like Snowflake's built-in features, Apache Airflow, or other ETL tools.

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.● Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.● Restricted data for particular users using Row level security and User filters.● Developed Tableau visualizations and dashboards using Tableau Desktop.● Developed Tableau Workbooks from multiple dal sources using. bala blending● Provided 24/7-production support for Tableau users.● Expertise in Data Extraction, Transforming and Loading (EL) using various tools such as SQL Server Integration Services (SIS), Bulk Insert and BCP for Enterprise Data Warehouse.● EDW) Skilled in creating SIS packages providing specific functionality like Data Profiling and Data● Designed Reports using SQL Server Reporting Services (SSRS)● Included graphical structures using charts, tables, matrices, parameters and conditional formatting● Created Parameterized Reports, Sub Reports, Drill Through, Drill down Reports in SSRS and Ad-hoc Reports using Report Builder.

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● Used various SIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, Slowly Changing Dimension etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the data warehouse from Flat Files, Excel and XML Files.● Responsible for implementation of data viewers, Logging, error configurations for error handling the packages.● Involved in the complete life cycle in creating SIS packages, building, deploying, and executing the packages in both environments (Development and Production).● Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS).● Created reports to retrieve data using Stored Procedures that accept parameters. Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions● Created Parameterized Queries, generated Tabular reports, sub-reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, sorting the data, Defining Data sources and Subtotals for the reports

● 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● Database administration including performance monitoring, access management and storage management● Partners with development teams/vendors to provide reporting on in flight software development projects● Create, develop and maintain SQL processes for channel performance data warehousing● Closely working with development manager and onsite team to deliver solutions● Makes recommendations towards the development of new code or reuse of existing code● Provides technical advice and assists in solving programming problems● Assists in preparing project plans using project management tools.● Build SQL scripts that include complex queries for large databases with a complex authentication process● Set security clearance parameters for authorized user access● Test SQL servers and maintain the integrity of the environment through regular updates and monitoring.