Software Engineer Data

Suhas Agrawal

*** ***** ******, *** ***, Lynn, MA – 01902 *****.*******@*****.*** 630-***-**** www.linkedin.com/in/suhasagrawal

EDUCATION

Master of Science in Information Systems May 2016

Northeastern University, Boston

Bachelor of Computer Engineering June 2012

University of Pune, India

TECHNICAL SKILLS

ETL/ELT Tools Ab Initio, Talend, Oracle Data Integrator, SSIS

Databases Oracle 12C, MySQL, Microsoft SQL Server 2014, Teradata v13.0

Data Modeling Rational Rose

Programming C++, PL/SQL,

Operating System UNIX/Linux

Reporting Tableau, Spotfire, QlikView, QlikSense, Excel Power Pivot

Other Tools SPSS, Microsoft Azure, Microsoft Visio, Control M Scheduler

ACADEMIC PROJECTS

Data Warehousing/ETL/BI Project Sept 2015 - Dec 2015

Designed Dimensional Data Model and Data Warehouse using UK government’s traffic data with facts & dimensions, Slowly Changing Dimensions (SCD), and developed ETL jobs on Talend with MySQL as the Database and SSIS with MS SQL Server.

Created Tableau dashboards on the Airline Industry and World Energy Consumption Datasets.

Designed 5 Reports on Adventure Works Retail Sales Data using QlikView and QlikSense.

Forest Cover Type Prediction System Jan 2015 - May 2015

Designed and built a model to predict forest cover type from cartographical and geological data.

Analyzed the data set and created reports through Spotfire.

Implemented the prediction model using Decision Trees/Forest, Logistical Regression and K-Means with Azure and SPSS.

WORK EXPERIENCE

Compact Solutions LLC, Ahmedabad, India Chicago, IL

Software Engineer July 2014 - Apr 2016

Project: New POS (Bed Bath Beyond, USA)

Lead Designer and the Primary Ab Initio Developer on the New POS Project.

Utilized continuous flow processes with queues and Conduct<IT concepts for real time processing of point of sale transactions.

Supervised the analysis, development and testing of ETL jobs.

Developed several generic ETL jobs to be used across various projects to help all teams to access data faster.

Associate Software Engineer Dec 2012 - July 2014

Project: EPICOR/ Re-Entry/ Return Authorization (Bed Bath and Beyond, USA)

Served as the primary Ab Initio developer on all three projects simultaneously.

Worked extensively with Point of Sale transactional XML data.

Analyzed different source systems and created Source to Target Mapping documents.

Implemented ETL jobs using Multi File Systems to process data in parallel thereby optimizing the jobs.

Reviewed Data/Process Flow designs and codes of team members to ensure high quality of deliverables.

Scheduled batch graphs and plans using Control M.

Associate Software Engineer Aug 2012 - Nov 2012

Project: Enterprise Data Enablement (Bed Bath and Beyond, USA)

Converted critical Teradata stored procedures to Ab Initio ETL jobs.

Created generic ETL jobs to extract data from legacy systems to stage before cleansing and loading it into data warehouses.

Enhanced ETL jobs’ performance by using lookups and data parallelism techniques.

Coordinated with Teradata DBAs for optimized solutions to reduce Teradata CPU seconds.

Contact this candidate