SQL Analyst Resume Redmond WAÂ - Hire IT People

SUMMARY:

A results - oriented, client-focused professional with a unique mix of database, software and data analysis experience, Extensive experience working with clients to define their needs and implement flexible, cost-effective technical solutions.
Extensive experience designing and administering relational databases including data modeling, entity relationship diagrams, PL/SQL programming, performance tuning, replication, data migration, and database backup. Database technologies and tools include SQL Azure, Oracle, Microsoft SQL Server, MySQL, Toad, various ETL tool
Experience with data modeling, data hygiene, analytic segmentation, database marketing, test design and reporting.
The tools used include Microsoft SQL server SSAS/SSIS/SSRS, PowerBI.and Oracle BI suite.
Can deal successfully with people at all organizational levels.
Strong team player with excellent organizational skills and independent management ability.
Able to allocate resources and delegate responsibility effectively

PROFESSIONAL EXPERIENCE:

Confidential, Redmond WA

SQL Analyst

Responsibilities:

Create and monitor ETL process to load business data from multiple sources into backend database.
Maintain and troubleshoot complicated legacy system
Migrate on-prem sql server to IaaS VM and SQL Azure PaaS environment.
Move logic from third party tool(Apptio) into SQL Server, simplify the Azure billing process and shorten the third party tool process time from several hours to 5 minutes in SQL server.
Automate the manual processes such as Azure VM and SQL Data forecast.
Ensure simplified maintenance and troubleshooting
Perform system administrator and database administrator tasks
Write report and adhoc queries.
Research various data provider API and analyze whether the data source contains right information

Confidential, Seattle WA

SQL Engineer

Responsibilities:

Confidential, Bellevue, WA

Database Administrator

Responsibilities:

Design consistent build and deploy processes for database changes.
Monitor large and complex terabyte database that supports Vehicle Multi-Media system on Toyota/Lexus and respond immediately to critical issues.
Design and develop complex PL/SQL code to deliver ad-hoc reports.
Use cron jobs and Oracle scheduler to automate various reports and common administrative tasks.
Maintain the production databases and provide ongoing performance tuning.
Troubleshoot the application issues and find the root cause.
Monitor master-master and master to slave database replication processes.
Set up, configure and optimize the new Oracle 11g databases

Confidential, Little Rock, AR

Database Administrator

Responsibilities:

Requirements analysis by working closely with internal and external stakeholders;
Developed packages, stored procedures, functions and triggers in PL/SQL and SQL/TSQL to implement business logic.
Created multiple data extract, transformation and loading (ETL) processes.
Analyzed consume data to find targeted costumer
Data manipulation, monitoring, and management in order to insure data integrity;
Designed and created analysis reports;
Performance monitoring and tuning;
Developed and implemented disaster recovery plan.