Data Analyst Resume Phoenix, AZ - Hire IT People

PROFESSIONAL SUMMARY:

Dynamic Software Engineer with 5 years of experience, skilled at developing complex solutions possessing strong creative thinking skills, high energy and enthusiastic team player dedicated to streamlining processes and developing innovative solutions tounusual and difficult problems.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX, Shell Script

Tools/Technologies: Snowflake, AWS Redshift, SSIS, SSMS, SQL Profiler, Perfmon, BCP, Github, Gitlab, Tableau

Databases: SQL Server, Oracle, MySQL

Operating System: Windows, OS X, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Data Analyst

Responsibilities:

Hands - on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored procedures.
Loaded data into snowflake tables from the internal staging using SnowSQL.
Designed and wrote code as per required database structures and components.
Defined virtual warehouse sizing for different type of workloads.
Used COPY to bulk load the data, created internal/external stage and transformed data during load.
Utilized temporary and transient tables on different databases.
Experienced in administering Snowflake, creation of user accounts and security groups.
Hands-on experience of ETL tool like SSIS and data visualization tool like Tableau.
Experienced in working with AWS and writing complex SQL, PL/SQL queries.
Used GitHub repository to store Snowflake code.

Confidential

Responsibilities:

Analyzed, designed, developed, installed, configured, and deployed MS SQL Server suite of products with BI in SSRS, SSAS, AND SSIS.
Used SSIS tools like import and export wizard, package installation, and SSIS package designer.
Expertized in importing, exporting data between different sources like Oracle, Excel, SQL Server, PostgreSQL, NetSuite, Salesforce using SSIS utility.
Implemented ETL processes that involves migration and synchronizing processes between two databases.
Proficient in writing SQL queries, dynamic queries, sub-queries and complex joins for stored procedures, triggers, views, and cursors.
Transformed data from one server to the other using tools like BCP and SSIS.
Created dashboards, KPI reports, charts, graphs to analyze the data on various levels and showed the same to the inventory decision makers.
Used OnPost Execute and OnError event handlers to log each task in SSIS log table.

Confidential

Senior Database Administrator

Responsibilities:

Provided L1/L2 support for managing & monitoring SQL Server instances.
Daily on-call server administration and support for production and internal Microsoft SQL Servers and other database systems, including performance optimization strategies, profiling, disaster recovery planning, security, and system status.
Designed and implemented backup and restore databases strategies and recovery.
Performed mission critical or point-in-time databases recovery whenever needed.
Performance tuning (using DMV's, SQL profiler, Perfmon, index tuning wizard and query analyzer), and optimized indexes to reduce logical disk I/O for effective performance.
Developed and maintained in-house written utilities using SSIS and T-SQL.
Cleaned and maintained the database environment by archiving old data for better accessibility.
Implemented process changes in production after UAT in the development environment.

Confidential

Senior Software Engineer

Responsibilities:

Worked as a SQL Server Database Developer and Administrator.
Installed, configured, administered, and secured clients Production/Test/Dev/UAT servers.
Managed configuration and optimization of 50 databases of total size 10TB.
Worked on Performance Tuning & Optimization issues like troubleshooting performance issues and fine-tuning queries and stored procedures.
Involved in database user management, files and file group management, storage space management and incident-management Support.
Provided consultation on SQL Server to Development team for data warehouse, analyzing the locking and blocking issues in dev, qc and production environments and upon the live databases.
Came up with custom-tailored backup/restore and disaster recovery plans for production servers.
Rebuilt the indexes at regular intervals for better performance.

Software Engineer

Confidential

Responsibilities:

Wrote T-SQL, stored procedures, views with 24/7 monitoring and support to client in production environment where DB size ranges from 50GB to 500 GB.
Involved in troubleshooting application with respect to database issues using SQL Profiler.
Handled server performance and management, disk space utilizations, sizing, and capacity planning.
Using Performance Monitor tool performed SQL server daily health check and preparing a report based on it.
Wrote scripts for automating alerts (ex- Space issue, Job Failure, Partition Failure) using PowerShell, T-SQL
Monitored and troubleshoot the routine jobs, alerts, and maintenance plans.