Data Engineer Resume Lyndhurst, NJ - Hire IT People

SUMMARY

Honors graduate of Confidential BS in Environmental Science worked on several project including a functional including a series of web pages for a dissertation.
Consistently recommended by professors and thesis supervisor to assist other students with IT related projects ; strong understanding of Web Fundamentals (HTML, CSS and Javascript); and hardware troubleshooting.
Known as a self - starter, team player and multitasker; strive to consistently exceed expectations.

TECHNICAL SKILLS

Programming/Languages: T-SQL, C#, XML, Python, HTML5/CSS

Databases: MySQL, Amazon Redshift, Oracle, MS Access

ETL Applications: SSIS, SSMS, SAS, Matillion, Hadoop, Talend

Tools: Visual Studio, AWS, S3, RDS, Apache, MS Word, Excel, PowerPoint, Outlook, etc.

Operating Systems: All versions of Windows including Server 2008, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential — Lyndhurst, NJ

Data Engineer

Responsibilities:

I facilitated on-boarding clients such as Confidential and Confidential by creating ETL processes in SSIS for their membership and claims data in support of the SmartShopper product.
Built Functions and Stored Procedures in Visual Studio using C#
I built a ‘Mock Shopping’ tool which used our existing API to utilize our transactional database. dis provided more accurate savings projection for potential clients.
Took on responsibilities as DBA; I many responsibilities including scheduling back-ups, new database architecture, performance tuning and modified users permissions.
I regularly assisted the reporting department to generate various metrics around product TEMPeffectiveness in SSRS.

Confidential — Long Island, NY

Data Analyst II

Responsibilities:

Processed vast datasets related to hospital transparency reporting from dozens of states including NY, CA, TX, TN and IL.
Executed SQL query optimization analysis and minimized call time by indexing tables.
Lead the company from a MySQL database structure toward an AWS Redshift data warehouse.
Used Amazon’s Could services such as S3 Buckets to ingest data from many heterogeneous sources as well as identifying data patterns through data analysis.
Was responsible for ETL and data validation using Matillion for Redshift.
Analyzed Big Data to generate reports tracking the relative performance of health providers.

Confidential

Data Processor

Responsibilities:

National Fraud Initiative: The NFI is a computerized data matching exercise used to detect housing benefit, payroll and other frauds perpetrated upon both public and private sector organizations.
Worked with SQL and MS Access queries to clean and streamline data for analysis.
Redesigned Internet and intranet pages. Assisted in optimizing website for internal search engine and improved functionality of company database.