Resume

Sign in

SQL Analyst/ETL developer

Location:
Bartlett, Illinois, United States
Posted:
January 17, 2018

Contact this candidate

Resume:

*** ********* ****, ********, ***,***** Nabeel Ahmed Email: ac32da@r.postjobfree.com

Cell:630-***-****

OBJECTIVE

Seeking an excellent opportunity in a healthy and fast-growing company to take my career to a next level.

EDUCATION

Bachelor of Science in Engineering, University of Illinois at Chicago (UIC), Fall 2014 – Spring 2017

CERTIFICATIONS

IKM (International Knowledge Measurement) Subject: SQL, SSIS Dec 2017

Score: 80% Result ID:93000219

TECHNICAL SKILLS

Programming Languages

: MS-SQL, T-SQL

Tools:

: Tableau Desktop

Platforms:

: Windows, Linux

Databases:

: MySQL, MS SQl

Business Tools:

: Tableau, SSIS

Computer Skills:

: Microsoft Word, PowerPoint, Excel

LEADERSHIP AND ACTIVITIES

Tutoring Engineering Courses (UIC) Fall 2015

Tutored mass and energy balance courses to junior chemical engineering student in a one-on-one and in a group setting.

Helped student in understanding core concepts related to mass and energy balances in different processes units such as distillation, filtration, evaporation, extraction, etc.

HONORS AND AWARDS

UIC AIChE (American Institute of Chemical Engineers, UIC). Spring 2015-Present

UIC Senior Design Expo 2016 (1st prize).

WORK HISTORY

M3Q Consulting – Emblem E-Commerce June 2017- Present

SQL Tableau Developer

Designed and implemented the robust database in SQL Server 2014 defining stored procedures, triggers, user

defined functions, xml types, table value functions etc.

Acquired strong SQL skill set while performing complex queries throughout entire lifecycle of the project.

Experience with Scripting (load data into Tableau from Excel, SQL Server), Debugging and tracing.

Expertise with Aggregation (Sum/count/max/min/average), Let and Set functions, Condition on a field in a table.

Worked as Data analyst using Tableau to help an E-commerce business data through effective dashboards visualization.

Performed analytical result on various tasks such as sales based on profit using Aggregation and drilling down.

Created dashboards by interconnecting multiple work sheets along with storyboarding on facts.

Worked with various functionalities to meet desired conditions such as Global Filtering, Sorting, Grouping, Parametrizing

Conducted many different type of visual charts such as Tree maps, Bar charts, Trend charts, Bubble maps, Heats maps

Align Work sheets interactions in Dashboard using Actions Functionality such as attaching URLs, highlighting etc

Have worked with Analytical tools such as Forecasting, Clustering, Trend line, Reference line, Reference band

Experience with implementation of security in Tableau using Section Access.

Developed great problem solving and analytical skills during entire period

Have worked with SSIS to set up ETL process to move data from OLTP to OLAP database for better reporting.

Worked on different data flow controls of SSIS for batch process and transformations artifacts of lookup. Astutely used SQL scripts and custom scripts over heavy weight artifacts of SSIS.

Experienced with different types of Data flow transformation such as Conversion, Conditional split, Merge join, lookup, Derived column, Percentage sampling, Sorting, Union All, Multi Casting and Aggregating etc.

Have worked in scheduling SSIS jobs using SQL server Agent.

Deployed SSIS Package, Execute Package manually, execute package through scheduler, also execute package through T-SQL etc.

O’Hare International Airport, Chicago IL Apr 11 - Mar 12

Service Agent- Provide customer support using linux system and scripts to lookup customer data.

Served as a supervisor at arrivals department by assigning various tasks and duties to staff.

Responsible for complete check in procedures by checking passports, baggage transfers.

Made terminal announcements and alerts for prospective travelers.

Assisted arrival department in resolving customer queries such as lost and found items, managing transit flights, and helping customers through boarding process.

PROJECTS & RESEARCH

1st Prize Winner UIC Senior Design Expo 2016

Presented the idea for the manufacturing of Linear Alkyl Benzene (LAB) and Green diesel. Produce from Palm kernel oil feed in a cost-effective and eco-friendly way.

Goal of production for LAB 100,000 tons/year and Green diesel 24,000 tons/year. Initially, while conducting project analysis we found that this project was not economically feasible at all. Operating Cost was estimating around $285 Million/Yr, but total revenue was $288 Million/Yr which leads our ROI to 3.31%, payback period time up to 30.25 years and NPV after 30 years came out to be -$57.480. Which didn’t make sense at all.

We did brainstorming again as a team and found out through sensitivity analysis on excel that if we would cut down our cost of feed raw material then we could be able to make this project profitable. Somehow an idea shows up in our heads that if we would do our own plantation of palm kernel fruit then not only we can make our project feasible, but also, we will be able to generate more revenue out of plantation as well. Having this approach changed whole scenario of our project significantly.

Finally, we conduct our process on Aspen stimulation software and through optimization we successfully be able achieve gross profit of $89 Million/Yr., also our ROI went up to 29.0% which leads payback period to 3.44 years. NPV after 30 years went up to $21.288 Million.

We conducted analysis on data, process control, also Hazard and Operability Analysis (HAZOP) to meet OSHA’s safety and environmental requirements.

Compiled and presented a final report covering process flow diagram (PFD) including inputs and outputs of process.

Research on Aspirin Technologies

Performed a detailed research on medicine (Aspirin) covering its origins, physical and chemical properties and manufacturing process including complete reaction mechanism.

Elaborated its functionality while reacting with human body under different conditions e.g. advantages and disadvantages while reacting with human body under various health conditions.

References:

Mohammed Murtuza – Lead Software Engineer

Email: ac32da@r.postjobfree.com

Cell: 313-***-****



Contact this candidate