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.