Data Engineer Resume Alpharetta,GAÂ - Hire IT People

SUMMARY:

Strategic, client - focused database engineer with more than seven years of experience designing, developing, and reengineering databases, software applications, and reporting systems. Specifically skilled in anticipating and responding to client and system issues and finding cost-effective and well-designed solutions. Equally effective when leading teams or working independently. Comfortable communicating at all levels of an organization, and working with multiple clients simultaneously. Able to learn and implement new technologies while under competing pressures of testing, non-production, and production environments.

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2008, Windows 7 Enterprise

Databases: MS SQL Server 2005/2008/2012/2014, ECL THOR, FLAT Files, Access, Oracle, HPCC SYSTEMS, BIG DATA, MySQL

SQL Server Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Profiler, Database Tuning Wizard

ETL Tools: DTS, SQL Server Integration Services (SSIS), Informatica, ECL IDE

Reporting Tools: SQL Server Reporting Services (SSRS)

Development Skills: Transact SQL (T-SQL), ECL

Languages: Visual Basic (VB), HTML, XML, C#, Batch (CMD)

Application Packages: MS Office Suite 2007/2012, MS Outlook

PROFESSIONAL EXPERIENCE:

Confidential,Alpharetta,GA

Data Engineer

Responsibilities:

Ingested large sets of unstructured data into standardized, distributed data to effectively and efficiently query data from THOR files.
Developed data scrubs for Current Carrier Life project for life insurance data.
Established several data statistics on daily scrub file to help QA team to determine whether to ingest or reject data.
Standardized legacy code and synched SQL data with THOR files to keep them current
Collaborated with database administrators, architects, and developers to define primary keys, and unique keys to several SQL tables.
Wrote proof of concept to automate daily migration of transaction log SQL data to THOR files.
Trained on new proprietary languages, including Enterprise Control Language (ECL) and High-Performance Computing Cluster (HPCC) systems.

Environment: HPCC Systems, ECL IDE, MySQL, SQL SERVER 2012, SqlYog, GITHUB

Confidential,Richardson,TX

Database Engineer

Responsibilities:

Worked closely with enterprise architecture team to push legacy database design towards more efficient micro databases; documented database designs by creating data definitions using Erwin Data Modeler.
Created SSIS packages for migrating legacy data into new database table design.
Developed complex stored procedures, functions and multi-table join queries to copy production data to non-prod environments and assist QA with automation scripts.
Collaborated with business object developers to create views, and stored procedures to support customer quote artifacts.
Synched non-production databases with production copies to support Regression, UAT and pre-production testing.
Developed and validated unit test cases; conducted integration testing, performance testing, and UAT

Environment: SQL Server 2012/2008R2, SSIS/SSRS, T-SQL, Erwin, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Java, HIBERNATE ENVERSE, IDERA, Business Objects.

Confidential,Costa Mesa,CA

Database Engineer

Responsibilities:

Managed Project Rio to establish MeProteja (ProtectMyID) services in Brazil.
Provided subject matter expertise for database elements including, customer notifications, billing, customer service, order placement, and promo codes.
Developed ETL procedures to transform data in the intermediate tables using CRUDs.
Developed test cases based on business scenarios and requirements; conducted integration and regression tests.
Performed component level, integration, performance, user acceptance, and client acceptance testing.
Created reports for daily billing and enrollments using SSRS.

Environment: SQL Server 2012/2008R2, CONTROL-M, SSIS/SSRS, T-SQL, Embacardo E/R Studio, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

Confidential, Malvern, PA

SQL Server/SSIS/SSRS Business Intelligence Developer

Responsibilities:

Documented ETL (SSIS) process design and worked on populating the Data warehouse based on business requirements and system specifications.
Created use cases for UAT testing and for testing ETL SSIS packages; deployed UAT and production packages and schedule SSIS jobs; developed SSRS Daily Sales Summary Reports showing daily, MTS, and YTD sales.
Defined the relationships and cardinality between tables using COGNOS Framework Manager.

Environment: MS SQL Server 2008 R2/2005, SSIS 2008, SSRS 2008, DTS, T-SQL, Visual Basic(VB), Visual Studio 2005, SQL Server Profiler, Erwin Data Modeler 7.2, Windows XP, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS) MS Access 2007,COGNOS 10.1, COGNOS Framework Manager, IBM TM1 9.5.2, VSS

We provide IT Staff Augmentation Services!

Data Engineer Resume

Alpharetta, Ga

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship