We provide IT Staff Augmentation Services!

Hadoop/sql Developer Resume

Plano, TexaS

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

  • Hadoop
  • HQL
  • Impala
  • Java Spark
  • SQL Server
  • T-SQL
  • C#
  • SSIS
  • Datastage
  • Autosys
  • Unix
  • Python
  • Visual Studio 2015 - 2010
  • BIML
  • SSRS.

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:

  • Used SSRS 2008 to create Matrix, Graphical and Statistical reports.
  • Created and modified SSIS packages.
  • Used T-SQL to create and modify Stored Procedures, Functions and Views.

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.

Hire Now