Hadoop/SQL Developer Resume Plano, Texas - Hire IT People

SUMMARY

SQL/Hadoop developer responsible for helping clients with their data needs in the medical, banking, insurance, and government industries. Involved in numerous conversion and migration projects.
Utilize SSIS for data migration and cleansing. Work with databases such as SQL Server 2000 - 2016 and Sybase.
Create stored procedures, functions, views and triggers using T-SQL. Help developers tune poor performing queries and stored procedures.
Work with different design methodologies such as Agile and Waterfall. Use various source controls such as TFS, AccuRev and Visual Source Safe.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential, Plano, Texas

Hadoop/SQL Developer

Responsibilities:

Responsible for supporting large SQL Server reporting and analytical environment.
Work with HDFS, Hive, Impala, and Java Spark to load and maintain enterprise data lake.
Create HIVE tables and views using HQL.
Schedule jobs within the data lake using Autosys.
Create Unix shell scripts to run and modify different process flows.
Work on small to large projects and provide project documentation.
Build ETL processes, stored procedures and SQL jobs in a SQL Server database environment.
Optimize poor preforming stored procedures and queries.
Utilize ETL tools like SSIS and Datastage to load tables and create files.

Confidential, Plano, Texas

SQL/BI Developer

Responsibilities:

Administered, developed and maintained SQL Server 2014/2012 databases.
Backed up and restored databases. Also ensured that backups ran successfully.
Use professional tools like Red Gate's SQL Toolbelt, SQL Monitor, ReSharper, etc.
Developed stored procedures, functions and views based on business needs.
Optimized poor preforming stored procedures and queries.
Designed SSIS packages for ETL processes.
Created SSIS packages on the fly using BIML (Business Intelligence Markup Language).
Developed CLR-based SQL UDF’s and stored procedures in C#.

Confidential, Plano, Texas

Conversion Developer

Responsibilities:

Designed, developed, and executed ETL packages to convert client data using stored procedures, functions, and SQL scripts in a Microsoft SQL Server environment.
Performed basic data analysis to identify data patterns and anomalies.
Engaged in query performance tuning.
Designed, implemented, and maintained new and existing database objects including tables, indexes, constraints, stored procedures, and user-defined functions in support of data conversion utilities and projects.
Performed SQL Server administration activities (backup, restore, DBCC commands, shrink) in support of development work.

Confidential, Irving, Texas

SQL Developer

Responsibilities:

Worked on data migration project that moved data from Oracle to SQL Server 2008 R2.
Used T-SQL to create stored procedures, triggers, functions and views in SQL Server 2008 R2.
Optimized poor performing queries and stored procedures using Executions Plans.
Designed and deployed reports using SQL Server Reporting Services (SRSS).
Backed up and restored databases on different environments.
Created SSIS packages to process incoming files.

Confidential

SQL Developer/DBA

Responsibilities:

Administered SQL Server 2008 R2 databases.
Administered HelpIT’s MatchIT application to dedupe critical database tables.
Used T-SQL to create stored procedures, triggers, functions and views in SQL Server 2008 R2.
Optimize poor performing stored procedures using Executions Plans and SQL Server Profiler.

Confidential, Dallas, Texas

Business Intelligence Developer

Responsibilities:

Used T-SQL to create stored procedures, triggers, functions and views in SQL Server 2005.
Added indexes and constraints to tables. Also optimized poor running queries.
Used Crystal Reports to create Matrix and Graphical style reports.

Confidential

Report Developer

Responsibilities:

Confidential

Software Developer

Responsibilities:

Worked on conversion project to convert over 150 reports and sub-reports from Crystal Reports to SSRS 2005.
Created and re-wrote Stored Procedures for reports using T-SQL on an SQL Server 2005 Database.
Analyze, design, program, test, and implement system integration and reports.