Phone 972-***-**** • E-mail ad4z1q@r.postjobfree.com

TECHNICAL SKILLS

I specialize in Microsoft SQL Server Enterprise (2000 to 2019 all version) BIG Data, T-SQL, SQL Development, Troubleshooting, debugging, ETL, Service.

Also, I am able to do Database performance tuning, TSQL & SQL query tuning, and SSIS development, BI/ SSRS, active Reports, Create, update tables, triggers, indexing, and views. Complex stored procedures (CTE), SSAS and Models, DBA Skills - backup and restore, profiler, deadlocks, Service broker, Azure Pipelines, Azure Data Factor, Azure Data storage- on prim and in cloud, add users to groups for access to only the data they are suppose to see.

EDUCATION

Degree in Software Engineering 1997

Pierce College, Lakewood, Washington

EXPERIENCE

Inform Diagnostic- Fulgent Genetics Company 2021-2023

SQL Architect/ Developer

Increased database speed by adding indexing and changing table layouts and adding indexes.

Created Stored Procedures T-SQL & SQL that were fast and efficient.

Debug old code to faster SQL code used CTE and improved output average 10 minutes to 1 minutes.

Suggested new products Red gate and debugging tools, running profiler to find long running SQL code.

Created Huge SQL code to pull in all the data for the Doctors to compare with our AI results.

Azure programmer

Thomson Reuters: 2021

SR. SQL Server Architect & Developer

Consultation to evaluate and improve the database (over 1000)

Business logic Function Requirements

User Accepted testing

They had a database for every customer ]

I worked on slow DB's, showed DBA's how to make them faster ( like log files should be on separate drive.)

Advised on hardware updates and to separate web serve and database to not be on same server.

Sunoco 0 2020-2021

Senior SQL Server Architect & Developer

Created SQL scripts for ETL processes in SSIS

Architect a new data mart

Database Modeling

Query Optimization

VM ware for Unit testing, did not want to test in prod.

SQL database administration

Used Service broker for asynchronous processing

City of Fort Worth 2020

Senior SQL Server Developer

Short consulting to advise and create T-SQl code for their incoming data.

Created many Stored Procedures, T-SQL and SQL and SSIS for stake holders

Used Service broker for asynchronous processing and messaging.

UHC - Well Med/ UHG 2019

Senior SQL Server Developer

Created DDD / Scopes for stake holders, to get requirements correct.

Created the database and ETL jobs using T-SQL and SQL in stored procedures.

Contract work to get them caught up and up to speed on a faster database.

Full life cycle Development and implementation.

Customize it Today 2018-2019

Senior Microsoft backend developer

Database Administration, setup and creation of the database and fat clients.

Database Modeling and Dimension Modeling

Database was to big, so I created reporting database on another server and that keep the report quires out of production. Then moved the none production data from prod. speed up the entire system.

Autonomy, HP INC, HP Enterprise, then Open Text bought us out 2007-2017

Systems Integration Specialist

Autonomy bought us out then HP and Open Text

Call center (Big Data) needed to be saved, so i took voice to text and saved the call as text

I worked with the customer, created what they needed Data wise SQL and then pulled it into SSRS

Nationwide has a database failure and I flew up there and merged in the missing data.

UHG needed a way to move 3 database into 1, I created the T-SQL scripts in production and merged it.

UHC needed a custom UI that you select the team to migrate and i would move that team and their data.

Averaged 500k profit per year for the company. I managed most of my projects, scope to QA to prod.

HP requested merge all the users into one database then break it apart when the split the company. all T-SQL (HP Inc and HP Enterprise) scripts ran great and while production was running i was pulling data.

I managed 6 servers and started being DBA for these servers, then we started VM's for each version.

I was on call for customers if they had database issues. Big Customers Volkswagen to ATT...

Etalk Contract to Hire 2005-2007

SQL Developer and Software Engineer

Started with Etalk (contract to hire) they had no data engineer or SQL developers.

New product call Qfiniti 3.0 had no report, I created the stored procedures using SQL and SSRS reports.

I created tables, views, indexes using T-SQL and SQL scripts and procedures and add-hoc reporting using the prams to pull the data and then show the data in SSRS.

After over 100 canned reports and about 50 custom reports for customers they hired me.

Contact this candidate